From a5bda60647639e787a777446dce693ac330fe940 Mon Sep 17 00:00:00 2001
From: horus_arch
Date: Thu, 1 Feb 2018 12:06:16 +0100
Subject: Initial commit.

---
 schema.txt | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 schema.txt

(limited to 'schema.txt')

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
+);
-- 
cgit v1.2.3