-
Notifications
You must be signed in to change notification settings - Fork 0
/
project_entries.sql
41 lines (41 loc) · 2.48 KB
/
project_entries.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
USE MCRONALDS_DB;
SET FOREIGN_KEY_CHECKS = 0;
INSERT INTO RESTAURANT_T VALUES(0, '1126 US-231 S', 'Troy', 'AL', '36081', 9, 0);
INSERT INTO RESTAURANT_T VALUES(1, '2212 Madison Ave', 'Montgomery', 'AL', 36107, 10, 1);
INSERT INTO RESTAURANT_T VALUES(2, '541 6th Ave', 'New York', 'NY', '10011', 8, 2);
INSERT INTO EMPLOYEE_T VALUES(0, 'Jonathan Taylor', '920 East Academy St', 'Troy', 'AL', '36081', '2054347006', 'jtaylor164422@troy.edu', '011100101', '2000-04-17', 'Full-Time', 0);
INSERT INTO FULLTIME_T VALUES(0, 50000);
INSERT INTO EMPLOYEE_T VALUES(1, 'Honey Yadhillah', '600 University Ave', 'Troy', 'AL', '36081', '0123456789', 'honey@troy.edu', '101100101', '2001-02-28', 'Full-Time', 1);
INSERT INTO FULLTIME_T VALUES(1, 50000);
INSERT INTO EMPLOYEE_T VALUES(2, 'John Doe', '123 Main Street Unit 21', 'New York City', 'NY', '10001', '9012345678', 'doe@gmail.com', '000100101', '1999-01-01', 'Full-Time', 2);
INSERT INTO FULLTIME_T VALUES(2, 50000);
INSERT INTO EMPLOYEE_T VALUES(3, 'Taylor Jonathan', '920 East Academy St', 'Troy', 'AL', '36081', '3344347006', 'tjonathan164422@troy.edu', '100011010', '2000-05-17', 'Part-Time', 0);
INSERT INTO PARTTIME_T VALUES(3, 15);
INSERT INTO EMPLOYEE_T VALUES(4, 'Intan Kumbayoni', '600 University Ave', 'Troy', 'AL', '36081', '1234567890', 'yadhillah@troy.edu', '010011010', '2001-03-28', 'Part-Time', 1);
INSERT INTO PARTTIME_T VALUES(4, 15);
INSERT INTO EMPLOYEE_T VALUES(5, 'Jane Doe', '123 Main Street Unit 21', 'New York City', 'NY', '10001', '8901234567', 'jane@gmail.com', '111011010', '1999-01-02', 'Part-Time', 2);
INSERT INTO PARTTIME_T VALUES(5, 15);
INSERT INTO ITEM_T VALUES(0, 'Burger', 'NA', 5);
INSERT INTO ITEM_T VALUES(1, 'Fries', 'Small', 1);
INSERT INTO ITEM_T VALUES(2, 'Fries', 'Medium', 2);
INSERT INTO ITEM_T VALUES(3, 'Fries', 'Large', 3);
INSERT INTO ITEM_T VALUES(4, 'Drink', 'Small', 1);
INSERT INTO ITEM_T VALUES(5, 'Drink', 'Medium', 1);
INSERT INTO ITEM_T VALUES(6, 'Drink', 'Large', 1);
INSERT INTO CUSTOMER_T VALUES(0, 'Mai Lam');
INSERT INTO CUSTOMER_T VALUES(1, 'Jesus Christ');
INSERT INTO CUSTOMER_T VALUES(2, 'Zipeng He');
INSERT INTO ORDER_T VALUES(0, NULL, 0, 0);
INSERT INTO ORDER_T VALUES(1, NULL, 0, 1);
INSERT INTO ORDER_T VALUES(2, NULL, 0, 2);
CALL MAKE_ORDER(0, 0, 1);
CALL MAKE_ORDER(0, 2, 1);
CALL MAKE_ORDER(0, 4, 1);
CALL FINISH_ORDERING(0, 0);
CALL MAKE_ORDER(1, 0, 3);
CALL MAKE_ORDER(1, 3, 3);
CALL FINISH_ORDERING(1, 1);
CALL MAKE_ORDER(2, 3, 2);
CALL MAKE_ORDER(2, 6, 2);
CALL FINISH_ORDERING(2, 2);
SET FOREIGN_KEY_CHECKS = 1;