-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathsampleshifts.sql
98 lines (95 loc) · 3.96 KB
/
sampleshifts.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
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
INSERT
INTO employees (
empFirstName,
empLastName,
empAccessLevel,
empLogin,
empPassword,
empEmail,
empWage)
VALUES ('Damon', 'L', 1, 'tdamon', 'hashthis', '[email protected]', 10),
('Tori', 'M', 1, 'ttori', 'hashthis', '[email protected]', 10),
('Dorian', 'R', 1, 'tdorian', 'hashthis', '[email protected]', 10),
('Mike', 'S', 2, 'tmike', 'cantscheduleforshit', '[email protected]', 999999),
('Ken', 'Slawinski', 1, 't884027', 'thisismyrealpasswordimnotkidding#imkidding', '[email protected]', 1),
('Sanjay', 'S', 1, 'tsanjay', 'learningisgreat', '[email protected]', 25),
('Nicolas', 'Cage', 3, 'tcage', '1truegod', '[email protected]', 9001) -- added another person with level 3 access
;
--linking everyone to their managers, managers are linked to the owner.
INSERT
INTO bossmanager (
employee,
manager)
VALUES
('tdamon', 'tmike'),
('ttori', 'tmike'),
('tdorian', 'tmike'),
('tmike', 'tcage'),
('t884027', 'tmike'),
('tsanjay', 'tmike')
;
INSERT
INTO employeeinbox (
mssgreciever,
mssgsender,
mssgsendtime,
mssgtext,
mssgisread)
VALUES
('tmike', 't884027', '2014-10-19 10:45', 'Please Sir, can i have some time off, I have so much database work to do', TRUE),
('t884027', 'tmike', '2014-10-19 11:45', 'Never peasant, just for that you need to work all weekend ', FALSE),
('tsanjay', 'tcage', '2014-10-19 13:45', 'Yo we should grab drinks sometime ;P', FALSE)
;
INSERT
INTO employeeShifts (
shiftEmployeeLogin,
shiftStartTime,
shiftEndTime)
VALUES
('tdamon', '2014-10-19 10:45', '2014-10-19 17:15'),
('tdamon', '2014-10-20 08:45', '2014-10-20 18:30'),
('tdamon', '2014-10-21 09:00', '2014-10-21 18:30'),
('tdamon', '2014-10-22 09:00', '2014-10-22 17:00'),
('tdamon', '2014-10-23 13:00', '2014-10-23 21:30'),
('tdamon', '2014-10-24 09:00', '2014-10-24 17:00'),
('ttori', '2014-10-19 10:45', '2014-10-19 17:15'),
('ttori', '2014-10-22 15:00', '2014-10-22 21:30'),
('ttori', '2014-10-23 14:30', '2014-10-23 21:30'),
('t884027', '2014-10-21 09:00', '2014-10-21 13:00'),
('t884027', '2014-10-24 15:00', '2014-10-24 21:30'),
('t884027', '2014-10-25 09:00', '2014-10-25 18:30'),
('tmike', '2014-10-20 08:45', '2014-10-20 18:30'),
('tmike', '2014-10-21 09:00', '2014-10-21 18:30'),
('tmike', '2014-10-22 09:00', '2014-10-22 17:00'),
('tmike', '2014-10-23 09:00', '2014-10-23 17:00'),
('tmike', '2014-10-24 09:00', '2014-10-24 17:00'),
('tmike', '2014-10-25 12:00', '2014-10-25 18:30'),
('tsanjay', '2014-10-20 10:00', '2014-10-20 18:00'),
('tsanjay', '2014-10-21 10:00', '2014-10-21 18:00'),
('tsanjay', '2014-10-22 10:00', '2014-10-22 18:00'),
('tsanjay', '2014-10-23 10:00', '2014-10-23 18:00'),
('tsanjay', '2014-10-24 13:00', '2014-10-24 21:30'),
('tdamon', '2014-10-26 10:45', '2014-10-26 17:15'),-- just copied and changed dates fuck data entry
('tdamon', '2014-10-27 08:45', '2014-10-27 18:30'),
('tdamon', '2014-10-28 09:00', '2014-10-28 18:30'),
('tdamon', '2014-10-29 09:00', '2014-10-29 17:00'),
('tdamon', '2014-10-30 13:00', '2014-10-30 21:30'),
('tdamon', '2014-10-31 09:00', '2014-10-31 17:00'),
('ttori', '2014-10-26 10:45', '2014-10-26 17:15'),
('ttori', '2014-10-29 15:00', '2014-10-29 21:30'),
('ttori', '2014-10-30 14:30', '2014-10-30 21:30'),
('t884027', '2014-10-28 09:00', '2014-10-28 13:00'),
('t884027', '2014-10-31 15:00', '2014-10-31 21:30'),
('t884027', '2014-11-1 09:00', '2014-11-1 18:30'),
('tmike', '2014-10-27 08:45', '2014-10-27 18:30'),
('tmike', '2014-10-28 09:00', '2014-10-28 18:30'),
('tmike', '2014-10-29 09:00', '2014-10-29 17:00'),
('tmike', '2014-10-30 09:00', '2014-10-30 17:00'),
('tmike', '2014-10-31 09:00', '2014-10-31 17:00'),
('tmike', '2014-11-1 12:00', '2014-11-01 18:30'),
('tsanjay', '2014-10-27 10:00', '2014-10-27 18:00'),
('tsanjay', '2014-10-28 10:00', '2014-10-28 18:00'),
('tsanjay', '2014-10-29 10:00', '2014-10-29 18:00'),
('tsanjay', '2014-10-30 10:00', '2014-10-30 18:00'),
('tsanjay', '2014-10-31 13:00', '2014-10-31 21:30');
;