-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathschool_insert.sql
More file actions
39 lines (31 loc) · 5.04 KB
/
school_insert.sql
File metadata and controls
39 lines (31 loc) · 5.04 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
protocol 'jdbc:derby:';
connect 'school';
INSERT INTO CLASSROOM (BUILDING, CLASSROOM_ID, NAME) VALUES ('Annie Hall', 1, '234');
INSERT INTO CLASSROOM (BUILDING, CLASSROOM_ID, NAME) VALUES ('Cow Palace', 2, '567');
INSERT INTO CLASSROOM (BUILDING, CLASSROOM_ID, NAME) VALUES ('Terrarium', 3, '111');
INSERT INTO CLASSROOM (BUILDING, CLASSROOM_ID, NAME) VALUES ('High Building', 6, '888');
INSERT INTO CLASSROOM (BUILDING, CLASSROOM_ID, NAME) VALUES ('Show Theater', 7, '711');
INSERT INTO COURSE (COURSE_ID, DETAILS, NAME, SHORT_DESCRIPTION) VALUES (1, 'Callouses, cause and treatment', 'Physics', 'The real world');
INSERT INTO COURSE (COURSE_ID, DETAILS, NAME, SHORT_DESCRIPTION) VALUES (2, 'Behavior and structure of human primates', 'Biology', 'The opposite sex');
INSERT INTO COURSE (COURSE_ID, DETAILS, NAME, SHORT_DESCRIPTION) VALUES (3, 'Acquisition and retention of large sums of cash', 'Economics', 'Money and its lack');
INSERT INTO COURSE (COURSE_ID, DETAILS, NAME, SHORT_DESCRIPTION) VALUES (4, 'How say something and still get elected', 'Government', 'Staying out of trouble');
INSERT INTO COURSE (COURSE_ID, DETAILS, NAME, SHORT_DESCRIPTION) VALUES (5, 'Figure out what works, and what doesn''t', 'History', 'Trial and error');
INSERT INTO EMPLOYEE (ADDRESS_ID, AGE, DATE_OF_BIRTH, DEGREE, DEPARTMENT, EMPLOYEE_TYPE, FIRST_NAME, LAST_NAME, LOGIN, MANAGER_ID, OFFICE, PASSWORD, PERSON_ID, SALARY, SCHEDULED_CLASS_ID, STATUS) VALUES (NULL, NULL, '2019-02-23 08:00:00', NULL, 'Physics', 3, 'Albert', 'Einstein', NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL);
INSERT INTO EMPLOYEE (ADDRESS_ID, AGE, DATE_OF_BIRTH, DEGREE, DEPARTMENT, EMPLOYEE_TYPE, FIRST_NAME, LAST_NAME, LOGIN, MANAGER_ID, OFFICE, PASSWORD, PERSON_ID, SALARY, SCHEDULED_CLASS_ID, STATUS) VALUES (NULL, NULL, '1933-03-02 08:00:00', NULL, 'Music', 3, 'Frank', 'Sinatra', NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL);
INSERT INTO EMPLOYEE (ADDRESS_ID, AGE, DATE_OF_BIRTH, DEGREE, DEPARTMENT, EMPLOYEE_TYPE, FIRST_NAME, LAST_NAME, LOGIN, MANAGER_ID, OFFICE, PASSWORD, PERSON_ID, SALARY, SCHEDULED_CLASS_ID, STATUS) VALUES (NULL, NULL, '1944-04-03 10:00:00', NULL, 'Drama', 3, 'Gene', 'Wilder', NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL);
INSERT INTO EMPLOYEE (ADDRESS_ID, AGE, DATE_OF_BIRTH, DEGREE, DEPARTMENT, EMPLOYEE_TYPE, FIRST_NAME, LAST_NAME, LOGIN, MANAGER_ID, OFFICE, PASSWORD, PERSON_ID, SALARY, SCHEDULED_CLASS_ID, STATUS) VALUES (NULL, NULL, '1951-01-15 08:00:00', NULL, 'Biology', 3, 'Dianne', 'Flossey', NULL, NULL, NULL, NULL, 11, NULL, NULL, NULL);
INSERT INTO EMPLOYEE (ADDRESS_ID, AGE, DATE_OF_BIRTH, DEGREE, DEPARTMENT, EMPLOYEE_TYPE, FIRST_NAME, LAST_NAME, LOGIN, MANAGER_ID, OFFICE, PASSWORD, PERSON_ID, SALARY, SCHEDULED_CLASS_ID, STATUS) VALUES (NULL, NULL, '1956-05-27 10:00:00', NULL, 'Government', 3, 'Bill', 'Clinton', NULL, NULL, NULL, NULL, 12, NULL, NULL, NULL);
INSERT INTO EMPLOYEE (ADDRESS_ID, AGE, DATE_OF_BIRTH, DEGREE, DEPARTMENT, EMPLOYEE_TYPE, FIRST_NAME, LAST_NAME, LOGIN, MANAGER_ID, OFFICE, PASSWORD, PERSON_ID, SALARY, SCHEDULED_CLASS_ID, STATUS) VALUES (NULL, NULL, '1942-03-16 10:00:00', NULL, 'Economics', 3, 'John', 'Locke', NULL, NULL, NULL, NULL, 13, NULL, NULL, NULL);
INSERT INTO EMPLOYEE (ADDRESS_ID, AGE, DATE_OF_BIRTH, DEGREE, DEPARTMENT, EMPLOYEE_TYPE, FIRST_NAME, LAST_NAME, LOGIN, MANAGER_ID, OFFICE, PASSWORD, PERSON_ID, SALARY, SCHEDULED_CLASS_ID, STATUS) VALUES (NULL, NULL, '1949-02-17 08:00:00', NULL, 'History', 3, 'James', 'Burke', NULL, NULL, NULL, NULL, 14, NULL, NULL, NULL);
INSERT INTO EMPLOYEE (ADDRESS_ID, AGE, DATE_OF_BIRTH, DEGREE, DEPARTMENT, EMPLOYEE_TYPE, FIRST_NAME, LAST_NAME, LOGIN, MANAGER_ID, OFFICE, PASSWORD, PERSON_ID, SALARY, SCHEDULED_CLASS_ID, STATUS) VALUES (NULL, NULL, NULL, NULL, NULL, 2, 'Administrator', NULL, 'admin', NULL, NULL, 'admin', 65, NULL, NULL, NULL);
INSERT INTO SCHEDULE (DAY, HOURS, SCHEDULE_ID, TIME) VALUES ('Monday', NULL, 1, '2000-12-31 16:00:00');
INSERT INTO SCHEDULE (DAY, HOURS, SCHEDULE_ID, TIME) VALUES ('Friday', NULL, 2, '2000-12-31 16:00:00');
INSERT INTO SCHEDULE (DAY, HOURS, SCHEDULE_ID, TIME) VALUES ('Wednesday', NULL, 3, '2000-12-31 18:00:00');
INSERT INTO SCHEDULE (DAY, HOURS, SCHEDULE_ID, TIME) VALUES ('Thursday', NULL, 5, '2000-12-31 19:00:00');
INSERT INTO SCHEDULE (DAY, HOURS, SCHEDULE_ID, TIME) VALUES ('Tuesday', NULL, 6, '2000-12-31 23:00:00');
INSERT INTO SCHEDULED_CLASS (CLASSROOM_ID, COURSE_ID, SCHEDULE_ID, SCHEDULED_CLASS_ID, TEACHER_ID) VALUES (1, 1, 1, 1, 4);
INSERT INTO SCHEDULED_CLASS (CLASSROOM_ID, COURSE_ID, SCHEDULE_ID, SCHEDULED_CLASS_ID, TEACHER_ID) VALUES (2, 2, 2, 2, 11);
INSERT INTO SCHEDULED_CLASS (CLASSROOM_ID, COURSE_ID, SCHEDULE_ID, SCHEDULED_CLASS_ID, TEACHER_ID) VALUES (3, 3, 3, 3, 13);
INSERT INTO SCHEDULED_CLASS (CLASSROOM_ID, COURSE_ID, SCHEDULE_ID, SCHEDULED_CLASS_ID, TEACHER_ID) VALUES (6, 4, 5, 5, 12);
INSERT INTO SCHEDULED_CLASS (CLASSROOM_ID, COURSE_ID, SCHEDULE_ID, SCHEDULED_CLASS_ID, TEACHER_ID) VALUES (7, 5, 6, 6, 14);
INSERT INTO STUDENT (ADDRESS_ID, AGE, DATE_OF_BIRTH, FIRST_NAME, LAST_NAME, LOGIN, PASSWORD, PERSON_ID, STATUS) VALUES (NULL, NULL, NULL, 'Guest', NULL, 'guest', 'guest', 62, NULL);