From 6f28f28ecd899fd7f90df42528ef178a94f6677d Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sun, 24 Sep 2023 12:13:15 +0300
Subject: feat: removing (by flag) records (#56)

Former-commit-id: cc1bed84ee7ff9133192e1278c8315afee73d23a
---
 backend/database/init.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'backend/database/init.sql')

diff --git a/backend/database/init.sql b/backend/database/init.sql
index 0f8196b..9d7b68c 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -130,6 +130,7 @@ CREATE TABLE records_sp (
   score_time INTEGER NOT NULL,
   demo_id UUID NOT NULL,
   record_date TIMESTAMP NOT NULL DEFAULT now(),
+  is_deleted BOOLEAN NOT NULL DEFAULT false,
   PRIMARY KEY (id),
   FOREIGN KEY (map_id) REFERENCES maps(id),
   FOREIGN KEY (user_id) REFERENCES users(steam_id),
@@ -146,6 +147,7 @@ CREATE TABLE records_mp (
   host_demo_id UUID NOT NULL,
   partner_demo_id UUID NOT NULL,
   record_date TIMESTAMP NOT NULL DEFAULT now(),
+  is_deleted BOOLEAN NOT NULL DEFAULT false,
   PRIMARY KEY (id),
   FOREIGN KEY (map_id) REFERENCES maps(id),
   FOREIGN KEY (host_id) REFERENCES users(steam_id),
-- 
cgit v1.2.3

