schema.txt


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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
);