From 075872c98fbd9a19e684a18b24f471bc1f78d1b1 Mon Sep 17 00:00:00 2001 From: physcik 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') 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