From b5ce961b3ef30758f77e2487dc9b6ed2dd39de73 Mon Sep 17 00:00:00 2001
From: physcik <mynameisgennadiy@vk.com>
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

