From cd31abc1bf4a97b04afb95fc10a88070f1a72cc4 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Mon, 24 Apr 2023 21:28:10 +0300
Subject: feat: history data from lp sheet ported

---
 backend/database/init.sql | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

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

diff --git a/backend/database/init.sql b/backend/database/init.sql
index 81461c2..51a4881 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -44,13 +44,11 @@ CREATE TABLE maps (
 CREATE TABLE map_history (
   id SMALLSERIAL,
   map_id SMALLINT NOT NULL,
-  user_id TEXT,
   user_name TEXT NOT NULL,
   score_count SMALLINT NOT NULL,
   record_date TIMESTAMP NOT NULL,
   PRIMARY KEY (id),
-  FOREIGN KEY (map_id) REFERENCES maps(id),
-  FOREIGN KEY (user_id) REFERENCES users(steam_id)
+  FOREIGN KEY (map_id) REFERENCES maps(id)
 );
 
 CREATE TABLE map_ratings (
-- 
cgit v1.2.3

