1 files changed, 2 insertions, 0 deletions

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),