/
insert.txt
120 lines (101 loc) · 7.55 KB
/
insert.txt
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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
* Customer table
Insert into customer values(‘John’,’smith’,100,’john@gmail.com’,’xxy’,’Bangalore’,’mg road’,560041,’M’,9933300924,’egg’
Insert into customer values(‘Ravi’,’Sharma’,101,’raviS@gmail.com’,’abc’,’Bangalore’,’jayanagar’,560041,’M’,’9242889791,’onion,garlic’)
Insert into customer values(‘Preethi’,’Prasad’,102,’preethi@yahoo.com’,’xyz’,’Bangalore’,’banashankari’,560070,’F’,9844037640,NULL)
Insert into customer values(‘kumar’,’narayan’,103,’kumar@gmail.com’,’aab’,’Bangalore’,’vv puram’,560004,’M’,9511747841,’nuts’)
Insert into customer values(‘chetana’,’ashok’,104,’chetana@yahoo.in’,123,’Bangalore’,’jayanagar’,560041,’F’,998056423,NULL)
Insert into customer values(‘harsha’,’gowda’,105,’harshaG@gmail.com’,’bbc’,’Bangalore’,’ banashankari’,560070,’M’,8861268940,NULL)
Insert into customer values(‘priya’,’singh’,106,’priya@gmail.com’,’cba’,’Bangalore’,’indiranagar’,560038,’F’,8879610560,’egg’)
Insert into customer values(‘Neha’,’jayanth’,107,’neha@gmail.com’,’rsa’,’Bangalore’,’jayanagar’,560041,’F’,8924299881,NULL)
Insert into customer values(‘Alice’,’zelaya’,108,’alice@gmail.com’,’cvd’,’Bangalore’,’Whitefield’,400050,’F’,7031086846,NULL)
Insert into customer values(‘ahmad’,’jabbar’,109,’jahmad@gmail.com’,dad,’Bangalore’,’banashankari’,560070,’M’,9760578022,NULL)
* Cuisine table
Insert into cuisine values(10,’chinese’)
Insert into cuisine values(11,’north indian’)
Insert into cuisine values(12,’south indian’)
Insert into cuisine values(13,’continential’)
Insert into cuisine values(14,’mexican’)
Insert into cuisine values(15,’dessert’)
Insert into cuisine values(16,’thai’)
Insert into cuisine values(17,’italian)
* Employee table
Insert into employee values(1000,’adam’,’lavine’,’15-sep-89’,’adam@gmail.com’,’adc’,’Bangalore’,9980594577,’M’,50000)
Insert into employee values(1001,’chris’,’martin’,’13-aug-92’,’chris@gmail.com’,’145’,’Adugodi’,9844038540,’M’,40000)
Insert into employee values(1002,’alex’,’wasabi’,’26-jul-82’,’alexw@gmail.com’,’123’,’girinagar’,9611747941 ,’M’,35000)
Insert into employee values(1003,’abby’,’lee’,’30-jan-95’,’abby@gmail.com’,’1@4’,’kengeri’, 9248289899,’F’,60000)
Insert into employee values(1004,’briana’,’lodge’,’27-jul-86’,’briana@gmail.com’,’aah’,’jayanagar’,8861360860,’F’,50000)
Insert into employee values(1005,’maria’,’solano’,’22-dec-95’,’maria@gmail.com’,’lad’,’double road’,9483960975,,’F’,40000)
Insert into employee values(1006,’ava’,’anderson’,’29-jan-86’,’ava@gmail.com’,’678’,’kh road’,7486911232,’F’,60000)
Insert into employee values(1007,’raksha’,’remash’,’06-jun-92’,’raksha@gmail.com’,’894’,’Bangalore’,9835383461,’F’,70000)
* Food table
Insert into food values(60,’biriyani’,100,1,’yes’,11,150,5)
Insert into food values(61,’idlysambar’,20,2,’yes’,12,150,3)
Insert into food values(62,’momos’,60,1,’yes’,10,152,2)
Insert into food values(63,’burger’,100,3,’yes’,13,153,4)
Insert into food values(64,’roti curry’,50,2,’yes,12,151,5)
Insert into food values(65,’taco’,50,4,’yes’,14,151,4)
Insert into food values(66,’fried rice’,60,1,’yes’,12,150,5)
Insert into food values(67,’ice cream’,70,3,’yes’,15,154,1)
Insert into food values(68,’sandwich,40,1,’yes’,13,153,4)
Insert into food values(69,’vada’,20,2,’yes’,12,150,3)
Insert into food values(70,’masala dosa’,40,4,’yes’,12,150,3)
Insert into food values(71,’nachos’,100,3,’yes’,14,151,4)
Insert into food values(72,’pizza’,200,7,’yes’,17,152,4)
Insert into food values(73,’pad thai’,250,1,’no’,16,155,2)
Insert into food values(74,’chinesesoup’,60,3,’yes’,10,155,2)
Insert into food values(75,’eggrice’,50,3,’yes’,11,156,5)
* Drink table
Insert into drink values(80,’pepsi’,30,’medium’,’yes’)
Insert into drink values(81,’cocacola’,35,’medium’,’yes’)
Insert into drink values(82,’mirinda’,30,’small’,’yes)
Insert into drink values(83,’lemontea’,50,’large’,’yes’)
Insert into drink values(84,’freshlimejuice’,40,’Large’,’no’)
Insert into drink values(85,’coffee’,20,’small’,’yes’)
Insert into drink values(86,’tea’,20,’small’,’no’)
Insert into drink values(87,’chocolate milkshake’,35,’medium’,’yes’)
* Ingredients table
Insert into ingredients values(150,’Rice’)
Insert into ingredients values(151,’wheat’)
Insert into ingredients values(152,’flour’)
Insert into ingredients values(153,’bread’)
Insert into ingredients values(154,’cream’)
Insert into ingredients values(155,’soup’)
Insert into ingredients values(156,’egg’)
* Chef table
Insert into chef values(1,’kumar’,’bangalore’,’girinagar’,9894757471,15,1005,’kumar@gmail.com’,’@ed’,40000)
Insert into chef values(2,’nikhil’,’bangalore’,’putenahalli’,7845795451,10,1004,’nikhil@gmail.com’,’rfd’,30000)
Insert into chef values(3,’lakshmi’,’bangalore’,’vijayanagar’,7745777888,12,1007,’lakshmi@gmail.com’,’poi’,40000)
Insert into chef values(4,’ram’,’bangalore’,’shantinagar’,698454892,13,1000,’ram@gmail.com’,’uvw’,30000)
Insert into chef values(5,’rahul’,’mysore’,’adugodi’,744587554,11,1005,’rahul@gmail.com’,’ytr’,40000)
* Delivery table
Insert into delivery values(30,’chandan’,’ka-04-9989’,103,1000,40,’22-aug-17’,05:00)
Insert into delivery values(31,’suresh’,’ka-04-2345’,104,1001,30,’26-jul-17’,10:00)
Insert into delivery values(32,’rajesh’,’ka-04-8826’,106,1002,70,’15-sep-17,16:00)
Insert into delivery values(33,’vinay’,’ka-04-6676’,102,1003,30,’05-oct-17’,’17:00)
Insert into delivery values(34,’vijay’,’ka-04-3345’,109,1004,30,’12-sep-17’,09:00)
Insert into delivery values(35,’sumit’,’ka-04-1223’,100,1005,70,’10-jan-17’,13:00)
Insert into delivery values(36,’amit’,’ka-04-8865’,108,1006,100,’06-jan-17’,’15:00)
Insert into delivery values(37,’prashant’,’ka-04-7869,101,1007,30,’14-mar-17’,19:00)
Insert into delivery values(38,’bhuvan’,’ka-04-5656’,107,1000,30,’01-jan-17’,12:00)
Insert into delivery values(39,’pramod’,’ka-04-4423’,105,1001,30,’05-dec-17’,13:00)
* Orders table
Insert into orders values(20,185,75,81,38)
Insert into orders values(21,340,63,84,37)
Insert into orders values(22,180,70,85,32)
Insert into orders values(23,120,64,86,35)
Insert into orders values(24,1430,72,80,34)
Insert into orders values(25,150,64,83,31)
Insert into orders values(26,240,67,82,30)
Insert into orders values(27,95,66,81,33)
Insert into orders values(29,80,68,84,39)
* Payment table
Insert into payment values(90,’credit card’,100,20)
Insert into payment values(91,’cash’,102,21)
Insert into payment values(92,’debit card’,101,22)
Insert into payment values(93,’cash’,105,23)
Insert into payment values(94,’cash’,104,24)
Insert into payment values(95,’cash’,109,25)
Insert into payment values(96,’paytm’,108,26)
Insert into payment values(97,’credit card’,107,27)
Insert into payment values(98,’cash’,106,28)
Insert into payment values(99,’cash’,103,29)