diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/create_script.sql | 14 | ||||
| -rw-r--r-- | db/docker-compose.yml | 17 |
2 files changed, 31 insertions, 0 deletions
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 +); diff --git a/db/docker-compose.yml b/db/docker-compose.yml new file mode 100644 index 0000000..6f2a675 --- /dev/null +++ b/db/docker-compose.yml @@ -0,0 +1,17 @@ +version: '3.8' + +services: + postgres: + image: postgres:latest + container_name: cyber2020_pg + environment: + POSTGRES_USER: dev + POSTGRES_PASSWORD: dev + POSTGRES_DB: cyber2020 + ports: + - "5432:5432" + volumes: + - postgres_data:/var/lib/postgresql + +volumes: + postgres_data: |