From cc133dd2e36c9eee7f04a29322e5a18181971189 Mon Sep 17 00:00:00 2001
From: physcik <mynameisgennadiy@vk.com>
Date: Tue, 14 Apr 2026 01:06:17 +0500
Subject: db connection

---
 db/create_script.sql  | 14 ++++++++++++++
 db/docker-compose.yml | 17 +++++++++++++++++
 2 files changed, 31 insertions(+)
 create mode 100644 db/create_script.sql
 create mode 100644 db/docker-compose.yml

(limited to 'db')

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:
-- 
cgit v1.3