From cc133dd2e36c9eee7f04a29322e5a18181971189 Mon Sep 17 00:00:00 2001
From: physcik <mynameisgennadiy@vk.com>
Date: Tue, 14 Apr 2026 01:06:17 +0500
Subject: db connection

---
 db/create_script.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 db/create_script.sql

(limited to 'db/create_script.sql')

diff --git a/db/create_script.sql b/db/create_script.sql
new file mode 100644
index 0000000..9ee372e
--- /dev/null
+++ b/db/create_script.sql
@@ -0,0 +1,14 @@
+CREATE TABLE weapons (
+    id SERIAL PRIMARY KEY,
+    weapon_type VARCHAR(255) NOT NULL,
+    accuracy SMALLINT CHECK (accuracy BETWEEN -128 AND 127),
+    concealability VARCHAR(255) NOT NULL,
+    availability VARCHAR(255) NOT NULL,
+    damage VARCHAR(255) NOT NULL,
+    ammunition VARCHAR(255) NOT NULL,
+    number_of_shots SMALLINT CHECK (number_of_shots BETWEEN 0 AND 255),
+    rate_of_fire SMALLINT CHECK (rate_of_fire BETWEEN 0 AND 255),
+    reliability VARCHAR(255) NOT NULL,
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+);
-- 
cgit v1.3

