diff options
| author | physcik <mynameisgennadiy@vk.com> | 2026-04-14 15:49:44 +0500 |
|---|---|---|
| committer | physcik <mynameisgennadiy@vk.com> | 2026-04-14 15:49:44 +0500 |
| commit | 075872c98fbd9a19e684a18b24f471bc1f78d1b1 (patch) | |
| tree | b89ccdb5a326b046d448c9f6e36de40306096f47 /db/create_script.sql | |
| parent | cc133dd2e36c9eee7f04a29322e5a18181971189 (diff) | |
ranged weapons db connection
Diffstat (limited to 'db/create_script.sql')
| -rw-r--r-- | db/create_script.sql | 9 |
1 files changed, 5 insertions, 4 deletions
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 |