1 files changed, 16 insertions, 7 deletions
diff --git a/create_database.sql b/create_database.sql
index 191506b..50f11de 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -1,14 +1,23 @@
 CREATE database shop;
 
 CREATE EXTENSION postgis;
-CREATE EXTENSION uint;
 
-CREATE TYPE color AS (red uint1, green uint1, blue uint1);
+CREATE TABLE chain (name text, color text);
 
-CREATE TABLE shop_color (shop text, color color);
+INSERT INTO chain(name, color) VALUES
+    ('Netto', 'rgb(255, 238, 82)'),
+('365discount', '#00aa46'),
+('Rema 1000', '#002154'),
+('Min Købmand', '#054628'),
+('Føtex', '#242930'),
+('Dagli''Brugsen', '#c31414'),
+('Brugsen', '#c31414'),
+('SuperBrugsen', '#c31414'),
+('Spar', '#ed1c24'),
+('Føtex Food', '#242930'),
+('Meny', '#ce0029'),
+('Kvickly', '#c31414'),
+('Løvbjerg', '#a21837'),
+('Lidl', '#0050aa')
 
-INSERT INTO shop_color(shop, color) VALUES
-('Netto', (255, 238, 82)),
-('365discount', (0, 170, 70)),
-('Rema 1000', (0, 36, 88))
 ;
 \ No newline at end of file