diff options
| author | user <user@node5.net> | 2024-04-06 22:23:06 +0200 |
|---|---|---|
| committer | user <user@node5.net> | 2024-04-06 22:23:06 +0200 |
| commit | fa360829bfe3f04f3e6d9af196dc9fd480864d4b (patch) | |
| tree | df04f3a39133d9edb0a46d591d23354849154c67 /create_database.sql | |
initial commit - displays voronoi diagram
Diffstat (limited to 'create_database.sql')
| -rw-r--r-- | create_database.sql | 14 |
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 |