From 6c2532d426b05acdcb008b1cd65c83d209fa758b Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Wed, 14 Feb 2024 18:26:27 +0300
Subject: feat: add images to game/chapter/map select (#151)

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

(limited to 'backend/database')

diff --git a/backend/database/init.sql b/backend/database/init.sql
index 54867ca..1fda15d 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -16,6 +16,7 @@ CREATE TABLE games (
   id SERIAL,
   name TEXT NOT NULL,
   is_coop BOOLEAN NOT NULL,
+  image TEXT NOT NULL,
   PRIMARY KEY (id)
 );
 
@@ -24,6 +25,7 @@ CREATE TABLE chapters (
   game_id SMALLINT NOT NULL,
   name TEXT NOT NULL,
   is_disabled BOOLEAN NOT NULL DEFAULT false,
+  image TEXT NOT NULL,
   PRIMARY KEY (id),
   FOREIGN KEY (game_id) REFERENCES games(id)
 );
@@ -40,6 +42,7 @@ CREATE TABLE maps (
   chapter_id SMALLINT NOT NULL,
   name TEXT NOT NULL,
   is_disabled BOOLEAN NOT NULL DEFAULT false,
+  image TEXT NOT NULL,
   PRIMARY KEY (id),
   FOREIGN KEY (game_id) REFERENCES games(id),
   FOREIGN KEY (chapter_id) REFERENCES chapters(id)
-- 
cgit v1.2.3