db connection

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: