From fa360829bfe3f04f3e6d9af196dc9fd480864d4b Mon Sep 17 00:00:00 2001 From: user Date: Sat, 6 Apr 2024 22:23:06 +0200 Subject: initial commit - displays voronoi diagram --- create_database.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 create_database.sql (limited to 'create_database.sql') 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 -- cgit v1.2.3