From 075872c98fbd9a19e684a18b24f471bc1f78d1b1 Mon Sep 17 00:00:00 2001
From: physcik <mynameisgennadiy@vk.com>
Date: Tue, 14 Apr 2026 15:49:44 +0500
Subject: ranged weapons db connection

---
 db/create_script.sql | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

(limited to 'db/create_script.sql')

diff --git a/db/create_script.sql b/db/create_script.sql
index 9ee372e..db44580 100644
--- a/db/create_script.sql
+++ b/db/create_script.sql
@@ -1,13 +1,14 @@
-CREATE TABLE weapons (
+CREATE TABLE RangedWeapons (
     id SERIAL PRIMARY KEY,
+    name VARCHAR(255) NOT NULL,
     weapon_type VARCHAR(255) NOT NULL,
-    accuracy SMALLINT CHECK (accuracy BETWEEN -128 AND 127),
+    accuracy INTEGER,
     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),
+    number_of_shots INTEGER,
+    rate_of_fire INTEGER,
     reliability VARCHAR(255) NOT NULL,
     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
-- 
cgit v1.3

