-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsert_script.sql
59 lines (47 loc) · 3.57 KB
/
insert_script.sql
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
-- booking
INSERT INTO booking(bookingDate,tableNumber,customerID,staffID) values('2023-01-23','T40',1,1);
INSERT INTO booking(date,tableNumber,customerID,staffID) values('2022-12-14','T44',2,3);
INSERT INTO booking(date,tableNumber,customerID,staffID) values('2023-03-23','T20',3,2);
INSERT INTO booking(date,tableNumber,customerID,staffID) values('2023-02-23','T40',4,4);
INSERT INTO booking(bookingDate,customerID,staffID) values('2023-02-23',4,4);
-- customer
INSERT INTO customer values(1,'Alex', 'Seth','O5588889','[email protected]','Parkview Downtown');
INSERT INTO customer values(2,'Sam', 'Juls','O5577889','[email protected]','Tantra Hills');
INSERT INTO customer values(3,'Tracy', 'Ray','O5682889','[email protected]','Brandy ST');
INSERT INTO customer values(4,'Nita', 'Dan','O6588889','[email protected]','Oak ST');
INSERT INTO customer values(5, 'Remi','Titus','05924532','[email protected]','Yoke Avenue');
INSERT INTO customer values(6,'Ruth','Rick','05649867','[email protected]','Old Folks Town');
INSERT INTO customer values(7, 'Ben','Glover','067924532','[email protected]','Trinity Avenue');
INSERT INTO customer values(8, 'Lisa','James','079245892','[email protected]','Wood ST');
-- staff
INSERT INTO staff values(1,'Jane', 'Tims','Chef','$1400','08475679','Simon ST', '[email protected]');
INSERT INTO staff values(2,'Tim', 'John','Receptionist','$1300','07235672','Ray ST', '[email protected]');
INSERT INTO staff values(3,'Trisha', 'Boye','Manager','$20000','07125674','John"s Town', '[email protected]');
INSERT INTO staff values(4,'Ramsey', 'Grey','Assistant Chef','$1300','075986790','Pop Avenue', '[email protected]');
INSERT INTO staff values(5,'Pat', 'Rashford','Receptionist','$1400','087686790','Truck Avenue', '[email protected]');
-- delivery
INSERT INTO delivery values('D145','2023-04-28',' Not Delivered');
INSERT INTO delivery values('D20','2023-04-29',' Not Delivered');
INSERT INTO delivery values('D130','2023-02-16','Delivered');
INSERT INTO delivery values('D14','2023-03-16','Delivered');
INSERT INTO delivery values('D18','2023-03-19','Delivered');
-- menu
INSERT INTO menu(cuisine,starter,drink,dessert,main) values('Italian','Bruschetta','Chianti','Tiramisu','Spaghetti Carbonara');
INSERT INTO menu(cuisine,starter,drink,dessert,main) values('African','Suya','Hisbiscus Tea','Peanut and Banana','Jollof');
INSERT INTO menu(cuisine,starter,drink,dessert,main) values('Mexican','Quesadilla','Margarita','Churros','Enchiladas');
INSERT INTO menu(cuisine,starter,drink,dessert,main) values('Indian','Kakori Khebab','Masala','Modak','Chicken Tikka Masala');
INSERT INTO menu(cuisine,starter,drink,dessert,main) values('African','Suya','Hibiscus Tea','Peanut and Banana','Jollof');
-- payment
INSERT INTO payment values(1,'Bank Transfer');
INSERT INTO payment values(2,'Online');
INSERT INTO payment values(3,'Mobile');
INSERT INTO payment values(4,'Cash');
INSERT INTO payment values(8,'Cash');
-- order
INSERT INTO itemOrder(quantity,totalCost,paymentID,staffID,deliveryID,menuID,CustomerID) values(2,300,1,1,'D145',1,1);
INSERT INTO itemOrder(quantity,totalCost,paymentID,staffID,deliveryID,menuID,CustomerID) values(1,150,2,2,'D20',2,2);
INSERT INTO itemOrder(quantity,totalCost,paymentID,staffID,deliveryID,menuID,CustomerID) values(1,130,3,3,'D130',3,3);
INSERT INTO itemOrder(quantity,totalCost,paymentID,staffID,deliveryID,menuID,CustomerID) values(4,540.55,4,4,'D14',4,4);
INSERT INTO itemOrder(quantity,totalCost,paymentID,staffID,deliveryID,menuID,CustomerID) values(4,540.55,4,4,'D14',4,4);
INSERT INTO itemOrder(quantity,totalCost,paymentID,staffID,deliveryID,menuID,CustomerID) values(2,520,8,3,'D17',8,8);
commit;