diff options
| author | physcik <mynameisgennadiy@vk.com> | 2026-04-27 16:52:45 +0500 |
|---|---|---|
| committer | physcik <mynameisgennadiy@vk.com> | 2026-04-27 16:52:45 +0500 |
| commit | 9a43fa05ade031c91d515d1254e05fd33cc7a482 (patch) | |
| tree | c585ee7725c5e88518e18ff98b93b944caa4520e /db | |
| parent | b5ce961b3ef30758f77e2487dc9b6ed2dd39de73 (diff) | |
Auth middleware + origin check
Diffstat (limited to 'db')
| -rw-r--r-- | db/create_script.sql | 7 |
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, |
