diff options
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 |