From b5ce961b3ef30758f77e2487dc9b6ed2dd39de73 Mon Sep 17 00:00:00 2001 From: physcik Date: Mon, 27 Apr 2026 15:31:39 +0500 Subject: Weapon description support --- db/create_script.sql | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'db/create_script.sql') diff --git a/db/create_script.sql b/db/create_script.sql index 900857c..5f1b0c7 100644 --- a/db/create_script.sql +++ b/db/create_script.sql @@ -14,6 +14,14 @@ CREATE TABLE RangedWeapons ( updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); +CREATE TABLE RangedWeaponsDescriptions ( + id VARCHAR(255) REFERENCES RangedWeapons(id), + language VARCHAR(16), + contents TEXT, + + PRIMARY KEY (id, language) +); + CREATE TABLE Users ( Id UUID PRIMARY KEY DEFAULT gen_random_uuid(), Username TEXT NOT NULL UNIQUE, @@ -21,4 +29,3 @@ CREATE TABLE Users ( PasswordHash VARCHAR(512) NOT NULL UNIQUE, Role TEXT NOT NULL ); - -- cgit v1.3