From cc133dd2e36c9eee7f04a29322e5a18181971189 Mon Sep 17 00:00:00 2001 From: physcik 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