-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsertions.sql
221 lines (211 loc) · 16.3 KB
/
insertions.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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
INSERT INTO `academic_titles` (`id`, `academic_title`, `created_at`, `updated_at`) VALUES
(2, 'Prof.Ass.Dr.', '2017-07-03 06:03:01', '2017-07-03 06:03:01'),
(3, 'Ma.', '2017-07-03 06:03:14', '2017-07-03 06:03:14'),
(4, 'Prof.Asoc.Dr.', '2017-07-03 06:03:30', '2017-07-03 06:03:30'),
(5, 'Ass.Ma.', '2017-07-03 06:03:44', '2017-07-03 06:03:44'),
(6, 'PhD.C', '2017-07-03 06:04:14', '2017-07-03 06:04:14'),
(7, 'Ligj.PhD.C', '2017-07-03 06:04:32', '2017-07-03 06:04:32'),
(8, 'Prof.Ass.', '2017-07-03 06:05:09', '2017-07-03 06:05:09'),
(9, 'Mr.Sc.', '2017-07-03 06:07:06', '2017-07-03 06:07:06'),
(10, 'Ass.Mr.', '2017-07-03 06:28:57', '2017-07-03 06:28:57'),
(11, 'Ass.Msc.', '2017-07-03 06:29:29', '2017-07-03 06:29:29'),
(12, 'Ass.', '2017-07-03 06:29:58', '2017-07-03 06:29:58'),
(13, 'Ass.PhD.C.', '2017-07-03 06:30:27', '2017-07-03 06:30:27'),
(14, 'Dr.Sc.', '2017-07-03 06:31:13', '2017-07-03 06:31:13'),
(15, 'Mr.', '2017-07-03 06:34:04', '2017-07-03 06:34:04');
INSERT INTO `users` (`id`, `first_name`, `last_name`, `log_id`, `email`, `password`, `personal_number`, `cpa_id`, `academic_title_id`, `status_id`, `photo`, `permissions`, `last_login`, `created_at`, `updated_at`) VALUES
(2, 'Florim', 'Asani', 50681, 'florim_101@hotmail.com', '$2y$10$M.lu1X9gVYBIcBzx9YoBQe7WOLFmnhj7aSRNxxzwCi19gXtG6etr.', '2654465565', 4, 1, 1, 'Uploads/0MzZD4T6-Users-User-Male-2-icon.png', NULL, '2017-07-28 08:10:58', '2017-06-30 11:54:58', '2017-07-28 08:10:58'),
(5, 'Arlind', 'Kryeziu', 27523, 'arlinndkryeziu@gmail.com', '$2y$10$tTbFKq0BOlhWtUFOHtSnFuoZzUZ7SJrXxmUWiZqR6pLo/e8JaQjOe', '2654465565', 4, 1, 1, 'Uploads/Gz0Gtltv-Users-User-Male-2-icon.png', NULL, NULL, '2017-06-30 11:57:20', '2017-06-30 11:57:20'),
(6, 'Ensar', 'Krasniqi', 28964, 'ensarkrasniqi@gmail.com', '$2y$10$wy3eYY43jROp7P/FJ.pEuOYrTpwI7OttR/OkqjM8a8Xk07HX0H61y', '2654465565', 4, 1, 1, 'Uploads/0eCvvxTF-Users-User-Male-2-icon.png', NULL, NULL, '2017-06-30 11:58:02', '2017-06-30 11:58:02'),
(10, 'Artan', 'Dermaku', 26142, 'artandermaku@gmail.com', '$2y$10$i6D1mQBnoyyNqpUvkHgtz.O4lsr2e6vIH9mpsXZy5pwZwxc/zjmfG', '4565474555', 1, 1, 1, 'Uploads/jrx4PlBB-Artan-Dermaku-250x263.jpg', NULL, NULL, '2017-07-03 07:37:56', '2017-07-03 12:17:23'),
(11, 'Xhevdet', 'Thaqi', 28514, 'xhevdet.thaqi@gmail.com', '$2y$10$OE/vWS/Dsdsw/ip9hoZCeuhDzV6TpcEGp6iRVYIKmZhpnXoWIHaKG', '4565474564', 1, 4, 1, 'Uploads/FXrRZZyS-Xhevdet-Thaqi11-250x263.jpg', NULL, NULL, '2017-07-03 07:38:51', '2017-07-03 07:38:51'),
(12, 'Basri', 'Ahmedi', 25604, 'basri.258@gmail.com', '$2y$10$PwURjAxnHAJHEyaxswA.neAwzTyMisHm9TsE3wVPEHTQeUxAHA9QG', '5433434343', 1, 2, 1, 'Uploads/thj4oi1U-Basri-Ahmedi2-250x263.jpg', NULL, NULL, '2017-07-03 07:39:50', '2017-07-03 07:39:50'),
(13, 'Nevrije', 'Ismajli', 22490, 'nevrijeismajli@gmail.com', '$2y$10$n68LC/oLg9VBWyh8DIF0we8r2EDv1KkA19v7cGyUDv/.TtjEq/bxe', '4323232323', 1, 2, 1, 'Uploads/feWybUhy-Nevrije-Ismajli2-250x263.jpg', NULL, NULL, '2017-07-03 07:41:14', '2017-07-03 07:41:14'),
(14, 'Teuta', 'Agaj', 52669, 'teutaagaj@gmail.com', '$2y$10$z5s694CETDjbLhvRZz2EwOxwjeYroHqq/YKqleUenNsFzmj.cbpw.', '4323232453', 3, 1, 1, 'Uploads/PHROvmHZ-Aferdita-Ibrahimi-2-250x263.jpg', NULL, NULL, '2017-07-03 08:08:16', '2017-07-13 06:17:59'),
(15, 'Dhurata', 'Hyseni', 79839, 'dhuratahyseni@gmail.com', '$2y$10$CHo2u2QEEpljfKE2eVxQXuGYMgFFzazM/4b4.kYACAkR6.fSwSPRK', '7883382233', 2, 3, 2, 'Uploads/1K0Z4ogG-Aferdita-Ibrahimi-2-250x263.jpg', NULL, NULL, '2017-07-03 08:13:14', '2017-07-03 08:13:14'),
(16, 'Hysnije', 'Ismaili', 82198, 'hysnijeismaili@gmail.com', '$2y$10$fyioxIwietN7TJamjv8eheR4ns5aBnUDve9BbOZZasN4Pc8fRlIU6', '1235535645', 2, 3, 1, 'Uploads/6te28HOI-user.png', NULL, NULL, '2017-07-03 08:15:56', '2017-07-03 08:15:56'),
(17, 'Afërdita', 'Ibrahimi', 34659, 'aferditaibrahimi@gmail.com', '$2y$10$vUZ8L7Gb6BfEgY9wEHLUVuB/2aeEsUJSVB6/TYDfNT96bOpvieNOy', '6422122222', 2, 5, 1, 'Uploads/ZBCDMOUW-Aferdita-Ibrahimi-2-250x263.jpg', NULL, NULL, '2017-07-03 08:18:30', '2017-07-03 08:18:30'),
(18, 'Selami', 'Klaiqi', 48838, 'selamiklaiqi@gmail.com', '$2y$10$UD.p7dMf9/r2h5xa/JZjlO9WOhv1N.aU.1Xfj00u6XS8dCJ2x.i3.', '6422122453', 2, 3, 2, 'Uploads/RwuzcEO1-user.png', NULL, NULL, '2017-07-03 08:19:33', '2017-07-03 08:19:33'),
(19, 'Flamur', 'Maloku', 89205, 'flamurmaloku@gmail.com', '$2y$10$45XhRfh.nwAue.FVHZ3CJ.f5TSVtu7DWzVQjBw051KvHKgfqGI9eK', '6422122533', 2, 1, 2, 'Uploads/pTn9TiLp-user.png', NULL, NULL, '2017-07-03 08:21:04', '2017-07-03 12:10:49'),
(20, 'Lindita', 'Hyseni', 20263, 'linditanebiuhyseni@gmail.com', '$2y$10$SOgqJox7zUQia28Y.tMjku.Cf3HUyE9mCIrzvLsnSylNwYyYGtD.S', '6568999999', 3, 7, 1, 'Uploads/xKeeV1PC-user.png', NULL, NULL, '2017-07-03 08:30:25', '2017-07-03 08:30:25'),
(21, 'Butrint', 'Rashiti', 17767, 'butrintrashiti@gmail.com', '$2y$10$UZbuL1m5AyeIwc0pyZZZ6eKKIoTCoyQFefb2tDxaMM3/jodLUiVFG', '6344642233', 4, 1, 1, 'Uploads/hCCxdFkV-user.png', NULL, '2017-07-13 06:26:04', '2017-07-03 09:57:20', '2017-07-13 06:26:04'),
(22, 'Gezim', 'Tosuni', 39919, 'gezimtosuni@gmail.com', '$2y$10$ArAfQ9xp1MpqAuc78ER7FugkU7aZdxZkzNWSU7oVWIwHDXMwl3nCO', '6344462333', 1, 1, 1, 'Uploads/vXlSTpmk-user.png', NULL, NULL, '2017-07-03 10:17:13', '2017-07-03 10:17:13'),
(23, 'Arben', 'Mustafa', 20441, 'arbenmustafa@gmail.com', '$2y$10$Dr86burXhVhV3sqlzE3pcu8VdftLbxfD3EkGzK6UrsB0aT4JfymeC', '6999966666', 1, 1, 1, 'Uploads/PQRv29uN-user.png', NULL, NULL, '2017-07-03 10:18:46', '2017-07-03 10:18:46'),
(24, 'Arben', 'Sahiti', 11924, 'arbensahit@igmail.com', '$2y$10$zkwyBDH9LXiNyMHWhT23hOsIkkRFNWPOcnvi908JY0iJ7WpLaf3gi', '6999966669', 2, 2, 1, 'Uploads/qcm96toO-user.png', NULL, NULL, '2017-07-03 10:20:28', '2017-07-03 10:20:28'),
(25, 'Nexhat', 'Shkodra', 90600, 'nexhatshkodra@gmail.com', '$2y$10$pc5e.gXrEXSNQz2Zf3BwO.Rrmbtsuu0/sPJaB2jAFX/l0LvvKsRda', '6999966688', 2, 2, 1, 'Uploads/5ILpeHk6-user.png', NULL, NULL, '2017-07-03 10:21:21', '2017-07-03 10:21:21'),
(26, 'Skender', 'Ahmeti', 27000, 'skenderahmeti@gmail.com', '$2y$10$3YZzPhDCMm.VVsj/0.FYSOAxaA6RSV1oZaPAiPcDvarlx5duKB9YG', '6999966622', 1, 2, 1, 'Uploads/L0VsE7lN-user.png', NULL, NULL, '2017-07-03 10:21:58', '2017-07-03 10:21:58'),
(27, 'Muhamet', 'Aliu', 29227, 'muhametaliu@gmail.com', '$2y$10$U04QKFA8Z9DwO8WKSw4FE.kFcvvyHVtqTZ/XvGlZ85nGGV55b/Vz6', '6999966623', 1, 2, 1, 'Uploads/8Bf4OAiZ-user.png', NULL, NULL, '2017-07-03 10:22:33', '2017-07-03 10:22:33'),
(28, 'Arbenita', 'Kosumi', 84760, 'arbenitakosumi@gmail.com', '$2y$10$m4GsQb3MqXx5noag3vVaQ.ee019d0pg0OSB5sloq0vx72FqyZuiR.', '1533322222', 2, 2, 1, 'Uploads/06ysgSHg-user.png', NULL, NULL, '2017-07-03 10:24:33', '2017-07-03 10:24:33'),
(29, 'Musa', 'Ajeti', 91168, 'musaajeti@gmail.com', '$2y$10$MnZL35BPG/i5qQGxzBTyTOmE1ywNo2IOBIGxR2eFPV4hkvv2ISoiC', '6666559988', 1, 2, 1, 'Uploads/2JzAp9a0-user.png', NULL, NULL, '2017-07-03 10:25:29', '2017-07-03 10:25:29'),
(30, 'Albulena', 'Shala', 45599, 'albulenashala@gmail.com', '$2y$10$9u4dtBYu9i8yFq80.L2lO.4a3sGb6HG1wA8iL3OJjqHn/Rt03grGi', '6666559977', 2, 2, 1, 'Uploads/bChtBf9Z-user.png', NULL, NULL, '2017-07-03 10:26:28', '2017-07-03 10:26:28'),
(31, 'Fitore', 'Rrudhani', 8429, 'fitorerrudhani@gmail.com', '$2y$10$a5p57lJRR.UgLp3AyExmputnLREiz4AWYDEvLWfk40MeUyXXRjqt6', '6666559933', 2, 2, 1, 'Uploads/KQCrJagQ-user.png', NULL, NULL, '2017-07-03 10:27:08', '2017-07-03 10:27:08'),
(32, 'Valarta', 'Qerimi', 1942, 'valeartaqerimi@gmail.com', '$2y$10$c27iiSoryEc2AORHfTUOCOF/CPY1TsFzRLi3OM4OrArj/ZTA5mIEy', '6666559922', 2, 2, 1, 'Uploads/rw2c3IIM-user.png', NULL, NULL, '2017-07-03 10:28:00', '2017-07-03 10:28:00'),
(33, 'Vese', 'Qehaja', 54418, 'veseqehaja@gmail.com', '$2y$10$DKdXso5g3E1dpxX391YpVOJZPiLJG3Fk4uX2w58lO5jyHIb06V/YS', '6666559964', 2, 2, 1, 'Uploads/h2OhLUQ2-user.png', NULL, NULL, '2017-07-03 10:28:26', '2017-07-03 10:28:26'),
(34, 'Muharrem', 'Bunjaku', 55497, 'muharrembunjaku@gmail.com', '$2y$10$zDYObPialmr/PcHvX.zkCukjffrJC9qMoIH9WDVbNc5QyF36PjbtG', '1234123123', 2, 2, 1, 'Uploads/8li8NfSi-user.png', NULL, NULL, '2017-07-03 10:30:22', '2017-07-03 10:30:22'),
(35, 'Xhevat', 'Sopi', 29203, 'xhevatsopi@gmail.com', '$2y$10$.sOQlJngvPWO8S7mUzb8duMvfnrztbUGqs8R9u8MdiblOpBobJUxe', '456456789', 1, 2, 1, 'Uploads/IZu4uGT9-user.png', NULL, NULL, '2017-07-03 10:31:03', '2017-07-03 10:31:03'),
(36, 'Lulzim', 'Rashiti', 94501, 'lulzimrashiti@gmail.com', '$2y$10$wY7m4wTvg/zv/ZqH7uHCguWqAmEM0Ip70mPbaLYKiIzo1jid7oPg2', '7897531595', 2, 2, 1, 'Uploads/BQLdgDE9-user.png', NULL, NULL, '2017-07-03 10:31:34', '2017-07-03 10:31:34'),
(37, 'Bislim', 'Lekiqi', 26756, 'bislimlekiqi@gmail.com', '$2y$10$6lGphuIU7WmUPx6WUR7lcep3n22xflHUfOPahcFIo1kxbNIaLE0WO', '7412589638', 1, 2, 1, 'Uploads/oQFyhcLq-user.png', NULL, NULL, '2017-07-03 10:32:20', '2017-07-03 10:32:20');
INSERT INTO `activations` (`id`, `user_id`, `code`, `completed`, `completed_at`, `created_at`, `updated_at`) VALUES
(3, 5, 'nYgwEtUeHKFFRd4qHfxtNliD9XxDzP1H', 1, '2017-06-30 11:54:58', '2017-06-30 11:54:58', '2017-06-30 11:54:58'),
(4, 6, 'cH1Q8T9uV6Vm3arz95SdG5IOqjCeTBB3', 1, '2017-06-30 11:57:20', '2017-06-30 11:57:20', '2017-06-30 11:57:20'),
(5, 10,'48HXt8Dp2leXULKQX6WO247jZGgvxx9U', 1, '2017-06-30 11:58:02', '2017-06-30 11:58:02', '2017-06-30 11:58:02'),
(7, 11, 'QufbuokODC6zCvTNaZZeSejbKaKRPcBb', 1, '2017-07-03 07:37:57', '2017-07-03 07:37:56', '2017-07-03 07:37:57'),
(8, 12, 'ZBE5jH7BUA1AHMQueGkgy8tV7lq7ViOG', 1, '2017-07-03 07:38:51', '2017-07-03 07:38:51', '2017-07-03 07:38:51'),
(9, 13,'VdCfDdHeZfkhd4ZuRW47Cl5UhuXmEFeW', 1, '2017-07-03 07:39:50', '2017-07-03 07:39:50', '2017-07-03 07:39:50'),
(10, 14, 'nbdsInmVoGHSPPwH8LVOlZl7pYDZUbop', 1, '2017-07-03 07:41:14', '2017-07-03 07:41:14', '2017-07-03 07:41:14'),
(11, 15, 'YcPoYmP6XZmnNwJUSH7PUoRKpxicCcG4', 1, '2017-07-03 08:08:16', '2017-07-03 08:08:16', '2017-07-03 08:08:16'),
(12, 16, '3hDBL7ZG9y1VcJViEiUBcNeoVAqFHTKa', 1, '2017-07-03 08:13:15', '2017-07-03 08:13:14', '2017-07-03 08:13:15'),
(13, 17, '3UrDRq0OP8mk9Milz2lC68IwzOPG8acc', 1, '2017-07-03 08:15:56', '2017-07-03 08:15:56', '2017-07-03 08:15:56'),
(14, 18, '0m07GsSEKPjCGheRzO1ltH5nQiK0XBuh', 1, '2017-07-03 08:18:30', '2017-07-03 08:18:30', '2017-07-03 08:18:30'),
(15, 19, 'TmemKs8kH5NXGaXRJqH7zfgDdWERbRks', 1, '2017-07-03 08:19:33', '2017-07-03 08:19:33', '2017-07-03 08:19:33'),
(16, 20, 'PbbeAA24IqfkPZtNmbPq0AYp1tAJ2W6X', 1, '2017-07-03 08:21:04', '2017-07-03 08:21:04', '2017-07-03 08:21:04'),
(17, 21, 'wzkXYxzMlHyAoeJPGVAsc0nFFseF9xp2', 1, '2017-07-03 08:30:25', '2017-07-03 08:30:25', '2017-07-03 08:30:25'),
(18, 22, 'qG9m6F2lYpGiF2SxS8oT0VAbOyh1sdiS', 1, '2017-07-03 09:57:20', '2017-07-03 09:57:20', '2017-07-03 09:57:20'),
(19, 23, 'S7EbhoQ00lx617o1JIVmejihGAGanGnw', 1, '2017-07-03 10:17:13', '2017-07-03 10:17:13', '2017-07-03 10:17:13'),
(20, 24, 'mjCCiMrcrdqjbe3YsGIbaHrAU2xC8oZ9', 1, '2017-07-03 10:18:46', '2017-07-03 10:18:46', '2017-07-03 10:18:46'),
(21, 25, 'CsLEKf8vQ2X5XVvqaCuUBsawTBN9a95H', 1, '2017-07-03 10:20:29', '2017-07-03 10:20:28', '2017-07-03 10:20:29'),
(22, 26, 'C2a1obyIUmjPZfabDUziIyP483uBhs8L', 1, '2017-07-03 10:21:21', '2017-07-03 10:21:21', '2017-07-03 10:21:21'),
(23, 27, 'VujMElsgfVLUMYjIWYeaV1rlrcSbShrl', 1, '2017-07-03 10:21:59', '2017-07-03 10:21:58', '2017-07-03 10:21:59'),
(24, 28, 'hLd5VytjgLfuDD5vUVJlHhTp6Aoycllt', 1, '2017-07-03 10:22:33', '2017-07-03 10:22:33', '2017-07-03 10:22:33'),
(25, 29, 'YrrQBaqOJFhBeJiixz1ncDBvq6L65tVn', 1, '2017-07-03 10:24:33', '2017-07-03 10:24:33', '2017-07-03 10:24:33'),
(26, 30, 'WefnwaOaDoKApgJcOD7OLsNu5oqOIdVJ', 1, '2017-07-03 10:25:29', '2017-07-03 10:25:29', '2017-07-03 10:25:29'),
(27, 31, 'hhsz4niITvHx7ZAoC2zVYHOB1qzwANmF', 1, '2017-07-03 10:26:28', '2017-07-03 10:26:28', '2017-07-03 10:26:28'),
(28, 32, 'Kmee0I1Per9xPxlHLhIE9o6C4J8bBoW1', 1, '2017-07-03 10:27:08', '2017-07-03 10:27:08', '2017-07-03 10:27:08'),
(29, 33, 'TBzvpO8UDtoRp0KsQXXid13cGRDymPlA', 1, '2017-07-03 10:28:00', '2017-07-03 10:28:00', '2017-07-03 10:28:00'),
(30, 34, 'jdMgXhVnihsvCXXlHup7aSdX66GBQxtJ', 1, '2017-07-03 10:28:27', '2017-07-03 10:28:26', '2017-07-03 10:28:27'),
(31, 35, 'Gt9FJ6J1fufjWdBLCkY1yNkOSCkRS35U', 1, '2017-07-03 10:30:22', '2017-07-03 10:30:22', '2017-07-03 10:30:22'),
(32, 36, 'XcBvIhefrko26l8llBVwgyXD3Iy0HwjR', 1, '2017-07-03 10:31:03', '2017-07-03 10:31:03', '2017-07-03 10:31:03'),
(33, 37, 'QWpctWBZAHw1mlhXg1NsV6nxUocBlqrm', 1, '2017-07-03 10:31:35', '2017-07-03 10:31:35', '2017-07-03 10:31:35');
INSERT INTO `subjects` (`id`, `subject`, `ects`, `semester`, `subjecttype_id`, `department_id`) VALUES
(1, 'PROGRAMIM I', 6, 1, 1, 1),
(2, 'MATEMATIKA I PER INFORMATIKE', 6, 1, 1, 1),
(3, 'QARQET DHIXHITALE', 6, 1, 1, 1),
(4, 'ARKITEKTURA E KOMPJUTERIT & SO', 6, 1, 1, 1),
(5, 'SHKRIMI AKADEMIK', 6, 1, 1, 1),
(6, 'ANGLISHTJA PER SH.K.', 6, 1, 1, 1),
(12, 'MAKROEKONOMI I', 6, 2, 1, 4),
(13, 'KONTABILITET I', 6, 2, 1, 4),
(14, 'STATISTIKË', 6, 2, 1, 4),
(15, 'MATEMATIKA FINANCIARE', 6, 2, 2, 4),
(16, 'EKONOMIA E KOSOVES DHE BE', 6, 2, 2, 4),
(17, 'HYRJE NE BIZNES', 6, 2, 2, 4),
(18, 'PROGRAMIM II', 6, 2, 1, 1),
(19, 'MATEMATIKA II PER INFORMATIKE', 6, 2, 1, 1),
(20, 'GJUHËT WEB DHE WEB TEKNOLOGJITË', 6, 2, 1, 1),
(21, 'RRJETAT KOMPJUTERIKE', 6, 2, 1, 1),
(22, 'ANGLISHTJA PER SHKENCA KOMPJUTERIKE II', 6, 2, 1, 1),
(23, 'ZHVILLIMET PËR INTERNET', 6, 2, 2, 1),
(24, 'SENSORËT DHE INTERFEJSI', 6, 2, 2, 1);
INSERT INTO `cps` (`id`, `user_id`, `subject_id`, `lecture_hours`, `exercise_hours`) VALUES
(1, 23, 12, 2, 2),
(2, 10, 1, 2, 2),
(3, 11, 2, 2, 2),
(4, 12, 3, 2, 2),
(5, 12, 4, 2, 2),
(6, 13, 5, 2, 2),
(7, 14, 6, 2, 2),
(8, 22, 12, 2, 2),
(9, 26, 13, 2, 2),
(10, 27, 13, 2, 2),
(11, 29, 14, 2, 2),
(12, 29, 15, 2, 2),
(13, 35, 16, 2, 2),
(14, 37, 17, 2, 2);
INSERT INTO `ca` (`cps_id`, `user_id`) VALUES
(1, 25),
(2, 15),
(3, 16),
(4, 17),
(5, 18),
(6, 19),
(7, 14),
(8, 24),
(9, 28),
(10, 24),
(11, 30),
(11, 31),
(11, 32),
(11, 33),
(12, 34),
(13, 36),
(14, 32);
INSERT INTO `halls` (`id`, `hall`, `capacity`, `halltype_id`, `faculty_id`, `sec_faculty_id`) VALUES
(1, 'B23', 50, 1, 1, NULL),
(2, 'B22', 50, 1, 1, NULL),
(3, 'B21', 120, 1, 1, NULL),
(4, 'B10', 120, 2, 1, NULL),
(5, 'A01', 120, 1, 1, NULL),
(15, 'B02', 100, 1, 4, NULL),
(16, 'B11', 100, 1, 4, NULL),
(17, 'B01', 100, 1, 4, NULL),
(18, 'B03', 100, 1, 4, NULL),
(19, 'A02', 100, 1, 4, NULL),
(20, 'A23', 100, 1, 4, NULL),
(21, 'B12', 100, 2, 4, NULL),
(22, 'A31', 60, 1, 1, NULL);
INSERT INTO `lush_cpa` (`cpa_id`, `lush_id`) VALUES
(1, 1),
(2, 2),
(3, 1),
(3, 2),
(4, 1);
INSERT INTO `role_users` (`user_id`, `role_id`, `created_at`, `updated_at`) VALUES
(2, 3, '2017-06-30 11:54:58', '2017-06-30 11:54:58'),
(5, 4, '2017-06-30 11:57:21', '2017-06-30 11:57:21'),
(6, 5, '2017-06-30 11:58:02', '2017-06-30 11:58:02'),
(10, 2, '2017-07-03 07:37:57', '2017-07-03 12:17:23'),
(11, 2, '2017-07-03 07:38:52', '2017-07-03 07:38:52'),
(12, 2, '2017-07-03 07:39:51', '2017-07-03 07:39:51'),
(13, 2, '2017-07-03 07:41:14', '2017-07-03 07:41:14'),
(14, 2, '2017-07-03 08:08:16', '2017-07-13 06:17:59'),
(15, 2, '2017-07-03 08:13:15', '2017-07-03 08:13:15'),
(16, 2, '2017-07-03 08:15:56', '2017-07-03 08:15:56'),
(17, 2, '2017-07-03 08:18:30', '2017-07-03 08:18:30'),
(18, 2, '2017-07-03 08:19:33', '2017-07-03 08:19:33'),
(19, 2, '2017-07-03 08:21:05', '2017-07-03 12:10:49'),
(20, 2, '2017-07-03 08:30:26', '2017-07-03 08:30:26'),
(21, 6, '2017-07-03 09:57:20', '2017-07-03 09:57:20'),
(22, 2, '2017-07-03 10:17:13', '2017-07-03 10:17:13'),
(23, 2, '2017-07-03 10:18:46', '2017-07-03 10:18:46'),
(24, 2, '2017-07-03 10:20:29', '2017-07-03 10:20:29'),
(25, 2, '2017-07-03 10:21:21', '2017-07-03 10:21:21'),
(26, 2, '2017-07-03 10:21:59', '2017-07-03 10:21:59'),
(27, 2, '2017-07-03 10:22:33', '2017-07-03 10:22:33'),
(28, 2, '2017-07-03 10:24:33', '2017-07-03 10:24:33'),
(29, 2, '2017-07-03 10:25:29', '2017-07-03 10:25:29'),
(30, 2, '2017-07-03 10:26:28', '2017-07-03 10:26:28'),
(31, 2, '2017-07-03 10:27:09', '2017-07-03 10:27:09'),
(32, 2, '2017-07-03 10:28:00', '2017-07-03 10:28:00'),
(33, 2, '2017-07-03 10:28:27', '2017-07-03 10:28:27'),
(34, 2, '2017-07-03 10:30:22', '2017-07-03 10:30:22'),
(35, 2, '2017-07-03 10:31:03', '2017-07-03 10:31:03'),
(36, 2, '2017-07-03 10:31:35', '2017-07-03 10:31:35'),
(37, 2, '2017-07-03 10:32:20', '2017-07-03 10:32:20');
INSERT INTO `status_academic_titles` (`academic_title_id`, `status_id`, `normal_hours`, `extra_hours`) VALUES
(1, 1, 3, 6);
INSERT INTO `subject_lush` (`id`, `subject_id`, `lush_id`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 1),
(4, 1, 2),
(5, 2, 1),
(6, 2, 2),
(7, 3, 1),
(8, 3, 2),
(9, 4, 1),
(10, 4, 2),
(11, 5, 1),
(12, 5, 2),
(13, 6, 1),
(14, 6, 2),
(15, 18, 1),
(16, 18, 2),
(17, 19, 1),
(18, 19, 2),
(19, 20, 1),
(20, 20, 2),
(21, 21, 1),
(22, 21, 2),
(23, 22, 1),
(24, 22, 2),
(25, 23, 1);