CREATE database map;

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')

;