summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorphyscik <mynameisgennadiy@vk.com>2026-04-27 16:52:45 +0500
committerphyscik <mynameisgennadiy@vk.com>2026-04-27 16:52:45 +0500
commit9a43fa05ade031c91d515d1254e05fd33cc7a482 (patch)
treec585ee7725c5e88518e18ff98b93b944caa4520e /db
parentb5ce961b3ef30758f77e2487dc9b6ed2dd39de73 (diff)
Auth middleware + origin check
Diffstat (limited to 'db')
-rw-r--r--db/create_script.sql7
1 files changed, 4 insertions, 3 deletions
diff --git a/db/create_script.sql b/db/create_script.sql
index 5f1b0c7..8f0dfde 100644
--- a/db/create_script.sql
+++ b/db/create_script.sql
@@ -1,4 +1,4 @@
-CREATE TABLE RangedWeapons (
+CREATE TABLE IF NOT EXISTS RangedWeapons (
id VARCHAR(255) PRIMARY KEY,
name VARCHAR(255) NOT NULL,
weapon_type VARCHAR(255) NOT NULL,
@@ -11,10 +11,11 @@ CREATE TABLE RangedWeapons (
rate_of_fire INTEGER,
reliability VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
- updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+ updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+ origin VARCHAR(255) NOT NULL
);
-CREATE TABLE RangedWeaponsDescriptions (
+CREATE TABLE IF NOT EXISTS RangedWeaponsDescriptions (
id VARCHAR(255) REFERENCES RangedWeapons(id),
language VARCHAR(16),
contents TEXT,