possible db schema for community

1 files changed, 34 insertions, 1 deletions

diff --git a/backend/database/init.sql b/backend/database/init.sql
index f5d380c..1b35c02 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -77,4 +77,37 @@ CREATE TABLE countries (
   country_code CHAR(2),
   country_name TEXT NOT NULL,
   PRIMARY KEY (country_code)
-);
\ No newline at end of file
+);
+
+-- CREATE TABLE community_maps (
+--   id SMALLSERIAL,
+--   map_id SMALLINT NOT NULL,
+--   category TEXT NOT NULL,
+--   tutorial TEXT NOT NULL,
+--   video_link TEXT NOT NULL,
+--   PRIMARY KEY (id),
+--   FOREIGN KEY (map_id) REFERENCES maps(id)
+-- );
+
+-- TODO
+-- CREATE TABLE community_history (
+--   id SERIAL,
+--   map_id SMALLINT NOT NULL,
+--   user_id TEXT NOT NULL,
+--   score_count SMALLINT NOT NULL,
+--   created_at TIMESTAMP NOT NULL DEFAULT now(),
+--   PRIMARY KEY (id),
+--   FOREIGN KEY (user_id) REFERENCES users(steam_id),
+--   FOREIGN KEY (map_id) REFERENCES maps(id)
+-- );
+
+-- CREATE TABLE community_posts (
+--   id SERIAL,
+--   map_id SMALLINT NOT NULL,
+--   user_id TEXT NOT NULL,
+--   post TEXT NOT NULL,
+--   created_at TIMESTAMP NOT NULL DEFAULT now(),
+--   PRIMARY KEY (id),
+--   FOREIGN KEY (user_id) REFERENCES users(steam_id),
+--   FOREIGN KEY (map_id) REFERENCES maps(id)
+-- );
\ No newline at end of file