1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
CREATE database shop;
CREATE EXTENSION postgis;
CREATE TABLE chain (name text, color text);
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')
;
|
