Food-Flash-Sale/seed.sql at master · raelyz/Food-Flash-Sale · GitHub

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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
INSERT INTO users (username,password,email) VALUES('aurelialim','12345','aurelia@gmail.com');
INSERT INTO users (username,password,email) VALUES('rlyz','12345','ray@gmail.com');
INSERT INTO users (username,password,email) VALUES('exhlim','12345','eugene@gmail.com');
INSERT INTO users (username,password,email) VALUES('alvischew','22222','alvis@gmail.com');
INSERT INTO users (username,password,email) VALUES('clairetay','12345','claire@gmail.com');
INSERT INTO users (username,password,email) VALUES('joey','12345','joey@gmail.com');
INSERT INTO users (username,password,email) VALUES('vincent','12345','xincent@gmail.com');
INSERT INTO users (username,password,email) VALUES('qundax','51234','qunda@gmail.com');

INSERT INTO merchant (name,password,email,address,uen,cuisine,latitude,longitude) VALUES('mcdonalds','12345','macs@gmail.com','10 Anson Road','UEN12345MACS','fast food','1.275','103.84');

INSERT INTO merchant (name,password,email,address,uen,cuisine,latitude,longitude) VALUES('poketheory','12345','poke@gmail.com','12 Anson Road','UEN12345POKE','Poke','1.275','103.84');

INSERT INTO merchant (name,password,email,address,uen,cuisine,latitude,longitude) VALUES('RyuSushi','12345','ryu@gmail.com','11 Anson Road','UEN12345RYU','japanese','1.34','103.5');

INSERT INTO merchant (name,password,email,address,uen,cuisine,latitude,longitude) VALUES('Astons','12345','astons@gmail.com','11 Middle Road','UEN12345ASTONS','western','1.4','103.8');

INSERT INTO merchant (name,password,email,address,uen,cuisine,latitude,longitude) VALUES('Paradise Dynasty','12345','paradise@gmail.com','133 Anson Road','UEN12345PS','chinese','1.4','103.8');

INSERT INTO merchant (name,password,email,address,uen,cuisine,latitude,longitude) VALUES('Pizza Hut','12345','pizza@gmail.com','1222 Anson Road','UEN12345PIZZ','fast food','1.4','103.8');


INSERT INTO category (category_name) VALUES('snacks');
INSERT INTO category (category_name) VALUES('light bites');
INSERT INTO category (category_name) VALUES('dim sum');
INSERT INTO category (category_name) VALUES('noodles');
INSERT INTO category (category_name) VALUES('junk food');
INSERT INTO category (category_name) VALUES('hearty meals');


INSERT INTO listing (item_name,unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('Hawaiian Pizza',10,10,10,8,2,1,6,'Either you hate or u love',22,true,current_timestamp);

INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('xiao long bao',20,10,10,15,10,3,5,'soupy dumplings',122,true,current_timestamp);

INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('Nuggets',5,10,10,4,1,5,1,'nuggets r life',22,true,current_timestamp);

INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('chicken chop',14,10,10,12,5,6,4,'a hearty chicken chop',222,true,current_timestamp);

INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('Aburi Don',20,10,10,15,8,6,5,'feeling torchy',22,true,current_timestamp);

INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('Salmon Soba',20,10,10,17,10,6,2,'for the health fanatic',122,true,current_timestamp);


  INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('McSpicy',22,10,10,4,2,5,1,'McSpicy Poops are worth it',60,true,current_timestamp);
  INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('Big Mac',100,10,10,4,2,5,1,'A Classic',60,true,current_timestamp);
  INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('Seaweed Shaker Fries',20,10,10,4,2,5,1,'While stocks last',60,true,current_timestamp);
  INSERT INTO listing (item_name, unit_price,original_quantity,quantity,price_ceiling,price_floor,category_id,merchant_id,
  description,time_limit_min,live,time) VALUES('Prosperity Burger',9,10,10,4,2,5,1,'Prosperous burgs',60,true,current_timestamp)


INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(1,1,5,5,5);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(1,1,5,5,5);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(1,1,5,5,5);


INSERT INTO receipt (user_id,merchant_id) VALUES(2,6);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,6);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,6);


INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);
INSERT INTO receipt (user_id,merchant_id) VALUES(2,1);


INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(1,13,4,2,12);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(2,14,4,4,16);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(3,13,4,1,4);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(4,13,4,1,4);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(5,15,4,1,4);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(6,16,4,2,4);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(1,14,4,2,4);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(2,13,4,2,4);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(3,16,4,2,4);
INSERT INTO orders (receipt_id, listing_id,price,quantity,revenue) VALUES(4,13,4,2,4);


INSERT INTO rating (user_id,merchant_id,listing_id,rating_stars,rating_receipt_id) VALUES(2,1,14,5,1);
INSERT INTO rating (user_id,merchant_id,listing_id,rating_stars,rating_receipt_id) VALUES(2,1,13,4,2);