From 775409f83d77eb4f98fbcac9419b99721f5c7815 Mon Sep 17 00:00:00 2001
From: user <user@node5.net>
Date: Sun, 7 Apr 2024 18:08:45 +0200
Subject: derive colors from database, verify icons are in sync

---
 create_database.sql | 23 ++++++++++++++++-------
 1 file changed, 16 insertions(+), 7 deletions(-)

(limited to 'create_database.sql')

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
-- 
cgit v1.2.3

