-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathinsert_data.txt
59 lines (49 loc) · 6.04 KB
/
insert_data.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
-- food insert queries
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('1', 'Onion pizza', 'Pizza', '90', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('2', 'Cheese pizza', 'Pizza', '150', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('3', 'White pasta', 'Pasta', '70', b'1', b'0', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('4', 'Red pasta', 'Pasta', '60', b'1', b'0', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('5', 'Coke', 'Cold Drinks', '40', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('6', 'Veg Burger', 'Burgers', '70', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('7', 'Cheese Burger', 'Burgers', '100', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('8', 'Combo1', 'combos', '170', b'1', b'1', b'1');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('9', 'Chicken pizza', 'Pizza', '60', b'0', b'0', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('10', 'Butter chicken pizza', 'Pizza', '60', b'0', b'0', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('11', 'Delux pizza', 'Pizza', '90', b'0', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('12', 'Capsicum pizza', 'Pizza', '150', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('13', 'Mexican pasta', 'Pasta', '100', b'1', b'0', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('14', 'Italian pasta', 'Pasta', '120', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('15', 'Fanta', 'Cold Drinks', '40', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('16', 'Paneer Burger', 'Burgers', '70', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('17', 'Chicken Burger', 'Burgers', '100', b'1', b'0', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('18', 'Super duper ultra pro max combo', 'combos', '3000', b'1', b'1', b'1');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('19', 'Indian Sharbat', 'Cold Drinks', '60', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('20', 'Virgin Mojito', 'Cold Drinks', '160', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('21', 'Combo3', 'combos', '400', b'0', b'0', b'1');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('22', 'Badam Shake', 'Shake', '80', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('23', 'Pan Shake', 'Shake', '70', b'1', b'0', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('24', 'Chocolate Shake', 'Shake', '60', b'1', b'1', b'0');
INSERT INTO `food_item` (`food_id`, `name`, `type`, `price`, `is_veg`, `availability`, `is_combo`) VALUES ('25', 'Kitkat Shake', 'Shake', '90', b'1', b'1', b'0');
-- combo addition
INSERT INTO `food_combos` (`combo_food_id`, `food_id`, `quantity`) VALUES ('8', '2', '1');
INSERT INTO `food_combos` (`combo_food_id`, `food_id`, `quantity`) VALUES ('8', '5', '2');
INSERT INTO `food_combos` (`combo_food_id`, `food_id`, `quantity`) VALUES ('18', '11', '1');
INSERT INTO `food_combos` (`combo_food_id`, `food_id`, `quantity`) VALUES ('18', '14', '2');
INSERT INTO `food_combos` (`combo_food_id`, `food_id`, `quantity`) VALUES ('18', '15', '1');
INSERT INTO `food_combos` (`combo_food_id`, `food_id`, `quantity`) VALUES ('18', '5', '2');
INSERT INTO `food_combos` (`combo_food_id`, `food_id`, `quantity`) VALUES ('21', '16', '1');
INSERT INTO `food_combos` (`combo_food_id`, `food_id`, `quantity`) VALUES ('21', '19', '2');
-- Customer addition
INSERT INTO Customer (name, email, phone, res_coins, balance) VALUES ('jack', '[email protected]','1234567890', '0','20000');
INSERT INTO Customer (name, email, phone, res_coins, balance) VALUES ('john', '[email protected]','2345678901', '0','20000');
INSERT INTO Customer (name, email, phone, res_coins, balance) VALUES ('alice', '[email protected]','3456789012', '0','20000');
INSERT INTO Customer (name, email, phone, res_coins, balance) VALUES ('bob', '[email protected]','4567890123', '0','20000');
INSERT INTO Customer (name, email, phone, res_coins, balance) VALUES ('jerry', '[email protected]','5678901234', '0','20000');
INSERT INTO Customer (name, email, phone, res_coins, balance) VALUES ('chris', '[email protected]','6789012345', '0','20000');
-- Employee addition
insert into Employee (name, position, salary) values ('salman', 'manager','150000');
insert into Employee (name, position, salary) values ('abdul', 'waiter','10000');
insert into Employee (name, position, salary) values ('younus', 'waiter','10000');
insert into Employee (name, position, salary) values ('Shahbaz', 'chef','25000');
insert into Employee (name, position, salary) values ('Amir', 'chef','300000');
insert into Employee (name, position, salary) values ('Razzaq', 'security','8000');