From 9a43fa05ade031c91d515d1254e05fd33cc7a482 Mon Sep 17 00:00:00 2001 From: physcik Date: Mon, 27 Apr 2026 16:52:45 +0500 Subject: Auth middleware + origin check --- db/create_script.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'db/create_script.sql') 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, -- cgit v1.3