1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
CREATE TABLE products (id INTEGER, name TEXT);
CREATE TABLE purchases (user INTEGER, product INTEGER, timestamp INTEGER);
BEGIN TRANSACTION;
INSERT INTO products VALUES(4029764001807,'Club Mate');
INSERT INTO products VALUES(5449000017888,'Coka Cola');
INSERT INTO products VALUES(5449000017895,'Coka Cola Light');
INSERT INTO products VALUES(5449000134264,'Coka Cola Zero');
INSERT INTO products VALUES(5449000017918,'Fanta');
INSERT INTO products VALUES(5449000017932,'Sprite');
INSERT INTO products VALUES(4104450004383,'Limette');
INSERT INTO products VALUES(4104450005878,'Vilsa Classic');
INSERT INTO products VALUES(5000159407236,'Mars');
INSERT INTO products VALUES(5000159407397,'Snickers');
INSERT INTO products VALUES(5000159418539,'Balisto Jogurt Beeren Mix');
INSERT INTO products VALUES(7613032625474,'Lion');
INSERT INTO products VALUES(7613032850340,'KitKat Chunky');
INSERT INTO products VALUES(40084015,'Duplo');
INSERT INTO products VALUES(40358802,'Knoppers');
INSERT INTO products VALUES(40084107,'Ü-Ei');
INSERT INTO products VALUES(40114606,'KitKat');
INSERT INTO products VALUES(40111315,'Twix');
INSERT INTO products VALUES(4003586000491,'Chips Frisch Oriento');
INSERT INTO products VALUES(8690504018568,'Üker Sesamsticks');
INSERT INTO products VALUES(4001686216125,'Haribo Salino');
INSERT INTO products VALUES(4001686312025,'Haribo Schnuller');
INSERT INTO products VALUES(4001686150689,'Haribo Konfekt');
INSERT INTO products VALUES(4001686128244,'Haribo Staffeten');
INSERT INTO products VALUES(4001686390085,'Haribo Phantasia');
INSERT INTO products VALUES(4001686310229,'Haribo Weinland');
INSERT INTO products VALUES(4001686386613,'Haribo Saftgoldbären');
INSERT INTO products VALUES(4001686301265,'Haribo Goldbären');
INSERT INTO products VALUES(4001686313046,'Haribo Saure Bohnen');
INSERT INTO products VALUES(4001686720028,'Haribo Colorado Mini');
COMMIT;
|
