1 files changed, 14 insertions, 0 deletions
diff --git a/create_database.sql b/create_database.sql
new file mode 100644
index 0000000..191506b
--- /dev/null
+++ b/create_database.sql
@@ -0,0 +1,14 @@
+CREATE database shop;
+
+CREATE EXTENSION postgis;
+CREATE EXTENSION uint;
+
+CREATE TYPE color AS (red uint1, green uint1, blue uint1);
+
+CREATE TABLE shop_color (shop text, color color);
+
+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