Initial commit.

1 files changed, 20 insertions, 0 deletions

diff --git a/schema.txt b/schema.txt
new file mode 100644
index 0000000..a21b69a
--- /dev/null
+++ b/schema.txt
@@ -0,0 +1,20 @@
+CREATE TABLE whisky (
+	id int PRIMARY KEY auto_increment,
+	shop int,
+	name text,
+	url text,
+	price text,
+	original_price text,
+	valid_until int,
+	image_url text,
+	created_at int
+);
+
+CREATE TABLE shop (
+	id int PRIMARY KEY auto_increment,
+	name text,
+	website_url text,
+	logo_url text,
+	shipping_costs text,
+	free_shipping text
+);