This repository was archived by the owner on Jun 6, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathDB_INSERT.sql
More file actions
77 lines (69 loc) · 6.49 KB
/
DB_INSERT.sql
File metadata and controls
77 lines (69 loc) · 6.49 KB
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
insert into users(mobile, oauth_id, role) values('9798099763','r2PoBWesLMaQevHdyXGKIKTC0Ma2','SUPER_ADMIN');
insert into place values(1,'SSN College of Engineering','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Kelambakkam',0);
insert into place values(2,'VIT University','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Vandaloor',0);
insert into place values(3,'SRM University','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Ramapuram',0);
insert into place values(4,'SVCE University','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Kelambakkam',0);
insert into place values(5,'SSN University','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Vandaloor',0);
insert into place values(6,'IBM University','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Ramapuram',0);
insert into place values(7,'HCL University','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Vandaloor',0);
insert into place values(8,'Vidya University','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Ramapuram',0);
insert into place values(9,'Accolite University','https://www.foodiesfeed.com/wp-content/uploads/2019/04/mae-mu-oranges-ice-349x436.jpg','Ramapuram',0);
insert into shop values(1,'Sathyas (Main)','shop.com','["shop.com","shop.com","shop.com"]',9176019344,1,'09:00:00','21:00:00',0);
insert into shop values(2,'Snow Qube','shop.com','["shop.com","shop.com","shop.com"]',9176019344,1,'09:00:00','21:00:00',0);
insert into shop values(3,'Sathyas PG','shop.com','["shop.com","shop.com","shop.com"]',9176019344,1,'09:00:00','21:00:00',0);
insert into shop values(4,'VIT Sathyas (Main)','shop.com','["shop.com","shop.com","shop.com"]',9176019344,2,'09:00:00','21:00:00',0);
insert into shop values(5,'VIT Snow Qube','shop.com','["shop.com","shop.com","shop.com"]',9176019344,2,'09:00:00','21:00:00',0);
insert into shop values(6,'VIT Sathyas PG','shop.com','["shop.com","shop.com","shop.com"]',9176019344,2,'09:00:00','21:00:00',0);
insert into shop values(7,'SRM Sathyas (Main)','shop.com','["shop.com","shop.com","shop.com"]',9176019344,3,'09:00:00','21:00:00',0);
insert into shop values(8,'SRM Snow Qube','shop.com','["shop.com","shop.com","shop.com"]',9176019344,3,'09:00:00','21:00:00',0);
insert into shop values(9,'SRM Sathyas PG','shop.com','["shop.com","shop.com","shop.com"]',9176019344,3,'09:00:00','21:00:00',0);
insert into item values(1,'Chicken Fried Rice',75,'food.com','CHINESE',1,0,1,0);
insert into item values(2,'Chicken Noodles',65,'food.com','CHINESE',1,0,1,0);
insert into item values(3,'Sada Dosa',35,'food.com','SOUTH INDIAN',1,1,1,0);
insert into item values(4,'Idly',30,'food.com','SOUTH INDIAN',1,1,1,0);
insert into item values(5,'Masala Dosa',45,'food.com','SOUTH INDIAN',1,1,1,0);
insert into item values(6,'Watermelon Juice',25,'food.com','BEVERAGES',1,1,1,0);
insert into item values(7,'Parota',75,'food.com','SOUTH INDIAN',1,1,1,0);
insert into item values(8,'Chappati (2)',55,'food.com','NORTH INDIAN',1,1,1,0);
insert into item values(9,'Samosa',10,'food.com','SNACKS',1,1,1,0);
insert into item values(10,'Pongal',45,'food.com','SOUTH INDIAN',1,1,1,0);
insert into item values(11,'Chicken 65',85,'food.com','SOUTH INDIAN',1,0,1,0);
insert into item values(12,'Chicken Biriyani',75,'food.com','SOUTH INDIAN',1,0,1,0);
insert into item values(13,'Apple Juice',35,'food.com','BEVERAGES',1,1,1,0);
insert into item values(14,'Grape Juice',25,'food.com','BEVERAGES',1,1,1,0);
insert into item values(15,'Mango Juice',45,'food.com','BEVERAGES',1,1,1,0);
insert into item values(16,'Mutton Biriyani',95,'food.com','SOUTH INDIAN',1,0,1,0);
insert into item values(17,'Chicken Fried Rice',75,'food.com','CHINESE',2,0,1,0);
insert into item values(18,'Chicken Noodles',65,'food.com','CHINESE',2,0,1,0);
insert into item values(19,'Sada Dosa',35,'food.com','SOUTH INDIAN',2,1,1,0);
insert into item values(20,'Idly',30,'food.com','SOUTH INDIAN',2,1,1,0);
insert into item values(21,'Masala Dosa',45,'food.com','SOUTH INDIAN',2,1,1,0);
insert into item values(22,'Watermelon Juice',25,'food.com','BEVERAGES',2,1,1,0);
insert into item values(23,'Parota',75,'food.com','SOUTH INDIAN',2,1,1,0);
insert into item values(24,'Chappati (2)',55,'food.com','NORTH INDIAN',3,1,1,0);
insert into item values(25,'Samosa',10,'food.com','SNACKS',3,1,1,0);
insert into item values(26,'Pongal',45,'food.com','SOUTH INDIAN',3,1,1,0);
insert into item values(27,'Chicken 65',85,'food.com','SOUTH INDIAN',4,0,1,0);
insert into item values(28,'Chicken Biriyani',75,'food.com','SOUTH INDIAN',4,0,1,0);
insert into item values(29,'Apple Juice',35,'food.com','BEVERAGES',4,1,1,0);
insert into item values(30,'Grape Juice',25,'food.com','BEVERAGES',5,1,1,0);
insert into item values(31,'Mango Juice',45,'food.com','BEVERAGES',5,1,1,0);
insert into item values(32,'Mutton Biriyani',95,'food.com','SOUTH INDIAN',6,0,1,0);
insert into item values(33,'Chappati (2)',55,'food.com','NORTH INDIAN',7,1,1,0);
insert into item values(34,'Samosa',10,'food.com','SNACKS',8,1,1,0);
insert into item values(35,'Pongal',45,'food.com','SOUTH INDIAN',9,1,1,0);
insert into item values(36,'Chicken 65',85,'food.com','SOUTH INDIAN',7,0,1,0);
insert into item values(37,'Chicken Biriyani',75,'food.com','SOUTH INDIAN',8,0,1,0);
insert into item values(38,'Apple Juice',35,'food.com','BEVERAGES',9,1,1,0);
insert into item values(39,'Grape Juice',25,'food.com','BEVERAGES',7,1,1,0);
insert into item values(40,'Mango Juice',45,'food.com','BEVERAGES',8,1,1,0);
insert into item values(41,'Mutton Biriyani',95,'food.com','SOUTH INDIAN',9,0,1,0);
insert into configurations(shop_id, delivery_price, merchant_id) values(1, 15.0, 'MID');
insert into configurations(shop_id, delivery_price, merchant_id) values(2, 10.0, 'MID');
insert into configurations(shop_id, delivery_price, merchant_id) values(3, 25.0, 'MID');
insert into configurations(shop_id, delivery_price, merchant_id) values(4, 15.0, 'MID');
insert into configurations(shop_id, delivery_price, merchant_id) values(5, 10.0, 'MID');
insert into configurations(shop_id, delivery_price, merchant_id) values(6, 25.0, 'MID');
insert into configurations(shop_id, delivery_price, merchant_id) values(7, 15.0, 'MID');
insert into configurations(shop_id, delivery_price, merchant_id) values(8, 10.0, 'MID');
insert into configurations(shop_id, delivery_price, merchant_id) values(9, 25.0, 'MID');