· 6 years ago · Apr 09, 2019, 12:24 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.7
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Apr 09, 2019 at 07:21 AM
7-- Server version: 5.6.41-84.1
8-- PHP Version: 5.6.30
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `timothel_psit`
23--
24CREATE DATABASE IF NOT EXISTS `timothel_psit` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
25USE `timothel_psit`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `class`
31--
32
33CREATE TABLE IF NOT EXISTS `class` (
34 `cnr` int(11) NOT NULL AUTO_INCREMENT,
35 `cname` text COLLATE utf8_unicode_ci,
36 `csize` int(11) DEFAULT NULL,
37 PRIMARY KEY (`cnr`),
38 UNIQUE KEY `clnr` (`cnr`)
39) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
40
41--
42-- Dumping data for table `class`
43--
44
45INSERT INTO `class` VALUES(1, 'it19a_zh', 25);
46INSERT INTO `class` VALUES(2, 'it15a_win', 30);
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `class_visits_subject`
52--
53
54CREATE TABLE IF NOT EXISTS `class_visits_subject` (
55 `cnr` int(11) NOT NULL DEFAULT '0',
56 `snr` int(11) NOT NULL,
57 PRIMARY KEY (`cnr`,`snr`),
58 KEY `fk_class_has_subject_subject1_idx` (`snr`),
59 KEY `fk_class_has_subject_class_idx` (`cnr`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
61
62--
63-- Dumping data for table `class_visits_subject`
64--
65
66INSERT INTO `class_visits_subject` VALUES(1, 1);
67
68-- --------------------------------------------------------
69
70--
71-- Table structure for table `hour`
72--
73
74CREATE TABLE IF NOT EXISTS `hour` (
75 `hnr` int(11) NOT NULL AUTO_INCREMENT,
76 `time` text COLLATE utf8_unicode_ci NOT NULL,
77 PRIMARY KEY (`hnr`)
78) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
79
80--
81-- Dumping data for table `hour`
82--
83
84INSERT INTO `hour` VALUES(1, '08:00 - 08:45');
85INSERT INTO `hour` VALUES(2, '08:50 - 09:35');
86INSERT INTO `hour` VALUES(3, '10:00 - 10:45');
87INSERT INTO `hour` VALUES(4, '10:50 - 11:35');
88INSERT INTO `hour` VALUES(5, '12:00 - 12:45');
89INSERT INTO `hour` VALUES(6, '12:50 - 13:35');
90INSERT INTO `hour` VALUES(7, '14:00 - 14:45');
91INSERT INTO `hour` VALUES(8, '14:50 - 15:35');
92INSERT INTO `hour` VALUES(9, '16:00 - 16:45');
93INSERT INTO `hour` VALUES(10, '16:50 - 17:35');
94INSERT INTO `hour` VALUES(11, '17:45 - 18:30');
95INSERT INTO `hour` VALUES(12, '18:40 - 19:25');
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `lesson`
101--
102
103CREATE TABLE IF NOT EXISTS `lesson` (
104 `lnr` int(11) NOT NULL AUTO_INCREMENT,
105 `tnr` int(11) NOT NULL,
106 `snr` int(11) NOT NULL,
107 `rnr` int(11) NOT NULL,
108 `tbnr` int(11) NOT NULL,
109 `duration` int(11) DEFAULT '1',
110 `day` int(11) DEFAULT '1',
111 `hnr` int(11) NOT NULL,
112 PRIMARY KEY (`lnr`),
113 KEY `fk_lesson_teacher1_idx` (`tnr`),
114 KEY `fk_lesson_subject1_idx` (`snr`),
115 KEY `fk_lesson_room1_idx` (`rnr`),
116 KEY `fk_lesson_timetable1_idx` (`tbnr`),
117 KEY `fk_lesson_hours1_idx` (`hnr`)
118) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
119
120--
121-- Dumping data for table `lesson`
122--
123
124INSERT INTO `lesson` VALUES(107, 17, 2, 80, 49, 2, 1, 1);
125INSERT INTO `lesson` VALUES(108, 6, 8, 97, 49, 2, 1, 2);
126INSERT INTO `lesson` VALUES(109, 1, 19, 88, 49, 2, 1, 8);
127INSERT INTO `lesson` VALUES(110, 4, 10, 92, 49, 1, 1, 12);
128INSERT INTO `lesson` VALUES(111, 2, 12, 84, 49, 1, 2, 1);
129INSERT INTO `lesson` VALUES(112, 12, 9, 94, 49, 2, 2, 2);
130INSERT INTO `lesson` VALUES(113, 14, 15, 80, 49, 2, 2, 3);
131INSERT INTO `lesson` VALUES(114, 6, 5, 94, 49, 1, 2, 7);
132INSERT INTO `lesson` VALUES(115, 17, 9, 88, 49, 2, 2, 8);
133INSERT INTO `lesson` VALUES(116, 18, 5, 83, 49, 1, 2, 11);
134INSERT INTO `lesson` VALUES(117, 7, 1, 93, 49, 1, 2, 12);
135INSERT INTO `lesson` VALUES(118, 5, 16, 96, 49, 2, 3, 1);
136INSERT INTO `lesson` VALUES(119, 19, 15, 95, 49, 2, 3, 6);
137INSERT INTO `lesson` VALUES(120, 6, 11, 83, 49, 2, 4, 4);
138INSERT INTO `lesson` VALUES(121, 16, 17, 82, 49, 1, 5, 4);
139INSERT INTO `lesson` VALUES(122, 18, 9, 99, 49, 1, 5, 5);
140INSERT INTO `lesson` VALUES(123, 8, 9, 83, 49, 2, 5, 10);
141INSERT INTO `lesson` VALUES(124, 18, 16, 92, 49, 2, 5, 12);
142INSERT INTO `lesson` VALUES(176, 6, 3, 85, 71, 2, 1, 9);
143INSERT INTO `lesson` VALUES(177, 19, 2, 80, 71, 1, 1, 10);
144INSERT INTO `lesson` VALUES(178, 9, 14, 95, 71, 2, 2, 6);
145INSERT INTO `lesson` VALUES(179, 10, 11, 82, 71, 2, 2, 7);
146INSERT INTO `lesson` VALUES(180, 14, 3, 87, 71, 1, 2, 12);
147INSERT INTO `lesson` VALUES(181, 1, 6, 98, 71, 1, 3, 10);
148INSERT INTO `lesson` VALUES(182, 2, 12, 98, 71, 1, 4, 3);
149INSERT INTO `lesson` VALUES(183, 15, 13, 90, 71, 1, 4, 7);
150INSERT INTO `lesson` VALUES(187, 10, 4, 98, 71, 2, 5, 8);
151INSERT INTO `lesson` VALUES(188, 8, 13, 85, 71, 2, 5, 9);
152INSERT INTO `lesson` VALUES(189, 17, 19, 83, 71, 2, 5, 10);
153INSERT INTO `lesson` VALUES(190, 14, 4, 87, 72, 1, 1, 5);
154INSERT INTO `lesson` VALUES(191, 12, 11, 92, 72, 1, 1, 11);
155INSERT INTO `lesson` VALUES(192, 14, 9, 98, 72, 2, 2, 8);
156INSERT INTO `lesson` VALUES(193, 19, 13, 98, 72, 1, 2, 9);
157INSERT INTO `lesson` VALUES(194, 17, 5, 96, 72, 1, 3, 3);
158INSERT INTO `lesson` VALUES(195, 19, 13, 91, 72, 1, 3, 8);
159INSERT INTO `lesson` VALUES(196, 2, 10, 88, 72, 1, 3, 9);
160INSERT INTO `lesson` VALUES(197, 11, 9, 95, 72, 2, 3, 10);
161INSERT INTO `lesson` VALUES(198, 17, 17, 82, 72, 2, 3, 11);
162INSERT INTO `lesson` VALUES(199, 4, 7, 84, 72, 2, 3, 12);
163INSERT INTO `lesson` VALUES(200, 17, 7, 87, 72, 2, 4, 2);
164INSERT INTO `lesson` VALUES(201, 18, 9, 93, 72, 2, 4, 3);
165INSERT INTO `lesson` VALUES(202, 8, 16, 88, 72, 2, 4, 8);
166INSERT INTO `lesson` VALUES(204, 19, 1, 87, 72, 2, 4, 10);
167INSERT INTO `lesson` VALUES(205, 5, 19, 82, 72, 2, 5, 7);
168INSERT INTO `lesson` VALUES(206, 17, 19, 81, 72, 2, 5, 8);
169INSERT INTO `lesson` VALUES(207, 10, 13, 94, 72, 2, 5, 10);
170
171-- --------------------------------------------------------
172
173--
174-- Table structure for table `object`
175--
176
177CREATE TABLE IF NOT EXISTS `object` (
178 `onr` int(11) NOT NULL AUTO_INCREMENT,
179 `oname` text COLLATE utf8_unicode_ci NOT NULL,
180 PRIMARY KEY (`onr`)
181) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
182
183--
184-- Dumping data for table `object`
185--
186
187INSERT INTO `object` VALUES(1, 'projector');
188INSERT INTO `object` VALUES(2, 'whiteboard');
189INSERT INTO `object` VALUES(3, 'computer');
190INSERT INTO `object` VALUES(4, 'laboratory');
191INSERT INTO `object` VALUES(5, 'gas');
192
193-- --------------------------------------------------------
194
195--
196-- Table structure for table `room`
197--
198
199CREATE TABLE IF NOT EXISTS `room` (
200 `rnr` int(11) NOT NULL AUTO_INCREMENT,
201 `rsize` int(11) NOT NULL DEFAULT '1',
202 PRIMARY KEY (`rnr`)
203) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
204
205--
206-- Dumping data for table `room`
207--
208
209INSERT INTO `room` VALUES(80, 1);
210INSERT INTO `room` VALUES(81, 2);
211INSERT INTO `room` VALUES(82, 3);
212INSERT INTO `room` VALUES(83, 1);
213INSERT INTO `room` VALUES(84, 1);
214INSERT INTO `room` VALUES(85, 1);
215INSERT INTO `room` VALUES(86, 2);
216INSERT INTO `room` VALUES(87, 1);
217INSERT INTO `room` VALUES(88, 1);
218INSERT INTO `room` VALUES(89, 2);
219INSERT INTO `room` VALUES(90, 3);
220INSERT INTO `room` VALUES(91, 1);
221INSERT INTO `room` VALUES(92, 1);
222INSERT INTO `room` VALUES(93, 1);
223INSERT INTO `room` VALUES(94, 1);
224INSERT INTO `room` VALUES(95, 1);
225INSERT INTO `room` VALUES(96, 1);
226INSERT INTO `room` VALUES(97, 1);
227INSERT INTO `room` VALUES(98, 1);
228INSERT INTO `room` VALUES(99, 1);
229INSERT INTO `room` VALUES(100, 1);
230INSERT INTO `room` VALUES(101, 4);
231INSERT INTO `room` VALUES(102, 3);
232INSERT INTO `room` VALUES(128, 10000);
233
234-- --------------------------------------------------------
235
236--
237-- Table structure for table `room_has_object`
238--
239
240CREATE TABLE IF NOT EXISTS `room_has_object` (
241 `rnr` int(11) NOT NULL,
242 `onr` int(11) NOT NULL,
243 PRIMARY KEY (`rnr`,`onr`),
244 KEY `fk_room_has_object_object1_idx` (`onr`),
245 KEY `fk_room_has_object_room1_idx` (`rnr`)
246) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
247
248--
249-- Dumping data for table `room_has_object`
250--
251
252INSERT INTO `room_has_object` VALUES(80, 1);
253INSERT INTO `room_has_object` VALUES(84, 1);
254INSERT INTO `room_has_object` VALUES(90, 1);
255INSERT INTO `room_has_object` VALUES(93, 1);
256INSERT INTO `room_has_object` VALUES(100, 1);
257INSERT INTO `room_has_object` VALUES(81, 2);
258INSERT INTO `room_has_object` VALUES(82, 2);
259INSERT INTO `room_has_object` VALUES(83, 2);
260INSERT INTO `room_has_object` VALUES(97, 2);
261INSERT INTO `room_has_object` VALUES(99, 2);
262INSERT INTO `room_has_object` VALUES(88, 3);
263INSERT INTO `room_has_object` VALUES(89, 3);
264INSERT INTO `room_has_object` VALUES(91, 3);
265INSERT INTO `room_has_object` VALUES(85, 4);
266INSERT INTO `room_has_object` VALUES(87, 4);
267INSERT INTO `room_has_object` VALUES(92, 4);
268INSERT INTO `room_has_object` VALUES(95, 4);
269INSERT INTO `room_has_object` VALUES(96, 4);
270INSERT INTO `room_has_object` VALUES(98, 4);
271INSERT INTO `room_has_object` VALUES(80, 5);
272INSERT INTO `room_has_object` VALUES(81, 5);
273INSERT INTO `room_has_object` VALUES(82, 5);
274INSERT INTO `room_has_object` VALUES(86, 5);
275INSERT INTO `room_has_object` VALUES(94, 5);
276
277-- --------------------------------------------------------
278
279--
280-- Table structure for table `semester`
281--
282
283CREATE TABLE IF NOT EXISTS `semester` (
284 `semnr` int(11) NOT NULL AUTO_INCREMENT,
285 `semname` text COLLATE utf8_unicode_ci NOT NULL,
286 `start` date NOT NULL DEFAULT '2016-09-15',
287 `end` date NOT NULL DEFAULT '2016-09-15',
288 PRIMARY KEY (`semnr`),
289 UNIQUE KEY `semnr` (`semnr`)
290) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
291
292--
293-- Dumping data for table `semester`
294--
295
296INSERT INTO `semester` VALUES(1, 'fall2016', '2016-09-15', '2017-02-15');
297INSERT INTO `semester` VALUES(2, 'test', '2019-02-05', '2019-02-22');
298INSERT INTO `semester` VALUES(3, 'lol', '2019-02-11', '2019-02-22');
299INSERT INTO `semester` VALUES(4, 'Name1', '2019-04-02', '2019-04-02');
300
301-- --------------------------------------------------------
302
303--
304-- Table structure for table `subject`
305--
306
307CREATE TABLE IF NOT EXISTS `subject` (
308 `snr` int(11) NOT NULL AUTO_INCREMENT,
309 `sname` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
310 `islecture` tinyint(1) NOT NULL DEFAULT '0',
311 `ishalfclass` tinyint(1) NOT NULL DEFAULT '0',
312 PRIMARY KEY (`snr`)
313) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
314
315--
316-- Dumping data for table `subject`
317--
318
319INSERT INTO `subject` VALUES(1, 'MANIT13', 0, 0);
320INSERT INTO `subject` VALUES(2, 'PROG1', 0, 1);
321INSERT INTO `subject` VALUES(3, 'MGMIT', 0, 0);
322INSERT INTO `subject` VALUES(4, 'THIN', 0, 0);
323INSERT INTO `subject` VALUES(5, 'WEB', 0, 0);
324INSERT INTO `subject` VALUES(6, 'DAB', 0, 0);
325INSERT INTO `subject` VALUES(7, 'COM-ST', 0, 0);
326INSERT INTO `subject` VALUES(8, 'COM-BO', 0, 0);
327INSERT INTO `subject` VALUES(9, 'PSIT1', 0, 0);
328INSERT INTO `subject` VALUES(10, 'InCo', 0, 0);
329INSERT INTO `subject` VALUES(11, 'MLAIT', 0, 0);
330INSERT INTO `subject` VALUES(12, 'PROG2-P', 0, 0);
331INSERT INTO `subject` VALUES(13, 'PSIT2', 0, 0);
332INSERT INTO `subject` VALUES(14, 'ADS', 0, 0);
333INSERT INTO `subject` VALUES(15, 'KT', 0, 0);
334INSERT INTO `subject` VALUES(16, 'PROGC', 0, 0);
335INSERT INTO `subject` VALUES(17, 'WEB2', 0, 0);
336INSERT INTO `subject` VALUES(18, 'COM-PR', 0, 0);
337INSERT INTO `subject` VALUES(19, 'MANIT2', 0, 0);
338INSERT INTO `subject` VALUES(20, 'PROG2-V', 1, 0);
339
340-- --------------------------------------------------------
341
342--
343-- Table structure for table `subject_requires_object`
344--
345
346CREATE TABLE IF NOT EXISTS `subject_requires_object` (
347 `snr` int(11) NOT NULL,
348 `onr` int(11) NOT NULL,
349 PRIMARY KEY (`snr`,`onr`),
350 KEY `fk_subject_has_object_object1_idx` (`onr`),
351 KEY `fk_subject_has_object_subject1_idx` (`snr`)
352) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
353
354--
355-- Dumping data for table `subject_requires_object`
356--
357
358INSERT INTO `subject_requires_object` VALUES(2, 3);
359
360-- --------------------------------------------------------
361
362--
363-- Table structure for table `teacher`
364--
365
366CREATE TABLE IF NOT EXISTS `teacher` (
367 `tnr` int(11) NOT NULL AUTO_INCREMENT,
368 `tname` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
369 PRIMARY KEY (`tnr`)
370) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
371
372--
373-- Dumping data for table `teacher`
374--
375
376INSERT INTO `teacher` VALUES(1, 'Müller');
377INSERT INTO `teacher` VALUES(2, 'Meier');
378INSERT INTO `teacher` VALUES(3, 'Peter');
379INSERT INTO `teacher` VALUES(4, 'Steiger');
380INSERT INTO `teacher` VALUES(5, 'Alban');
381INSERT INTO `teacher` VALUES(6, 'Brockenhaus');
382INSERT INTO `teacher` VALUES(7, 'Chervez');
383INSERT INTO `teacher` VALUES(8, 'Tiziani');
384INSERT INTO `teacher` VALUES(9, 'Jaun');
385INSERT INTO `teacher` VALUES(10, 'Bléchlinger');
386INSERT INTO `teacher` VALUES(11, 'Baer');
387INSERT INTO `teacher` VALUES(12, 'Scherrer');
388INSERT INTO `teacher` VALUES(14, 'Wernich');
389INSERT INTO `teacher` VALUES(15, 'Stillhard');
390INSERT INTO `teacher` VALUES(16, 'Huber');
391INSERT INTO `teacher` VALUES(17, 'Sigismondi');
392INSERT INTO `teacher` VALUES(18, 'HÃ usler');
393INSERT INTO `teacher` VALUES(19, 'Hasler');
394
395-- --------------------------------------------------------
396
397--
398-- Table structure for table `teacher_knows_subject`
399--
400
401CREATE TABLE IF NOT EXISTS `teacher_knows_subject` (
402 `tnr` int(11) NOT NULL,
403 `snr` int(11) NOT NULL,
404 PRIMARY KEY (`tnr`,`snr`),
405 KEY `fk_teacher_has_subject_subject1_idx` (`snr`),
406 KEY `fk_teacher_has_subject_teacher1_idx` (`tnr`)
407) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
408
409--
410-- Dumping data for table `teacher_knows_subject`
411--
412
413INSERT INTO `teacher_knows_subject` VALUES(1, 1);
414INSERT INTO `teacher_knows_subject` VALUES(19, 1);
415INSERT INTO `teacher_knows_subject` VALUES(18, 2);
416INSERT INTO `teacher_knows_subject` VALUES(17, 3);
417INSERT INTO `teacher_knows_subject` VALUES(16, 4);
418INSERT INTO `teacher_knows_subject` VALUES(15, 5);
419INSERT INTO `teacher_knows_subject` VALUES(14, 6);
420INSERT INTO `teacher_knows_subject` VALUES(12, 8);
421INSERT INTO `teacher_knows_subject` VALUES(11, 9);
422INSERT INTO `teacher_knows_subject` VALUES(10, 10);
423INSERT INTO `teacher_knows_subject` VALUES(9, 11);
424INSERT INTO `teacher_knows_subject` VALUES(8, 12);
425INSERT INTO `teacher_knows_subject` VALUES(7, 13);
426INSERT INTO `teacher_knows_subject` VALUES(6, 14);
427INSERT INTO `teacher_knows_subject` VALUES(5, 15);
428INSERT INTO `teacher_knows_subject` VALUES(4, 16);
429INSERT INTO `teacher_knows_subject` VALUES(3, 17);
430INSERT INTO `teacher_knows_subject` VALUES(2, 18);
431INSERT INTO `teacher_knows_subject` VALUES(1, 19);
432
433-- --------------------------------------------------------
434
435--
436-- Table structure for table `timetable`
437--
438
439CREATE TABLE IF NOT EXISTS `timetable` (
440 `tbnr` int(11) NOT NULL AUTO_INCREMENT,
441 `rating` int(4) NOT NULL DEFAULT '0',
442 `semnr` int(11) NOT NULL,
443 `cnr` int(11) NOT NULL,
444 PRIMARY KEY (`tbnr`),
445 KEY `a` (`semnr`),
446 KEY `b` (`cnr`)
447) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
448
449--
450-- Dumping data for table `timetable`
451--
452
453INSERT INTO `timetable` VALUES(49, 0, 2, 1);
454INSERT INTO `timetable` VALUES(70, 0, 1, 1);
455INSERT INTO `timetable` VALUES(71, 3, 3, 2);
456INSERT INTO `timetable` VALUES(72, 0, 4, 1);
457
458-- --------------------------------------------------------
459
460--
461-- Table structure for table `user`
462--
463
464CREATE TABLE IF NOT EXISTS `user` (
465 `id` int(11) NOT NULL AUTO_INCREMENT,
466 `username` text COLLATE utf8_unicode_ci NOT NULL,
467 `pass` text COLLATE utf8_unicode_ci NOT NULL,
468 `firstname` text COLLATE utf8_unicode_ci NOT NULL,
469 `lastname` text COLLATE utf8_unicode_ci NOT NULL,
470 `email` text COLLATE utf8_unicode_ci NOT NULL,
471 `isadmin` tinyint(1) NOT NULL DEFAULT '0',
472 PRIMARY KEY (`id`)
473) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
474
475--
476-- Dumping data for table `user`
477--
478
479INSERT INTO `user` VALUES(1, 'user1', 'a', 'dude', 'karl', 'lol@lel.lul', 1);
480INSERT INTO `user` VALUES(3, 'a', 'a', '', '', '', 1);
481
482--
483-- Constraints for dumped tables
484--
485
486--
487-- Constraints for table `class_visits_subject`
488--
489ALTER TABLE `class_visits_subject`
490 ADD CONSTRAINT `fk_class_has_subject_class` FOREIGN KEY (`cnr`) REFERENCES `class` (`cnr`) ON DELETE CASCADE ON UPDATE CASCADE,
491 ADD CONSTRAINT `fk_class_has_subject_subject1` FOREIGN KEY (`snr`) REFERENCES `subject` (`snr`) ON DELETE CASCADE ON UPDATE CASCADE;
492
493--
494-- Constraints for table `lesson`
495--
496ALTER TABLE `lesson`
497 ADD CONSTRAINT `fk_lesson_hours1` FOREIGN KEY (`hnr`) REFERENCES `hour` (`hnr`) ON DELETE CASCADE ON UPDATE CASCADE,
498 ADD CONSTRAINT `fk_lesson_room1` FOREIGN KEY (`rnr`) REFERENCES `room` (`rnr`) ON DELETE CASCADE ON UPDATE CASCADE,
499 ADD CONSTRAINT `fk_lesson_subject1` FOREIGN KEY (`snr`) REFERENCES `subject` (`snr`) ON DELETE CASCADE ON UPDATE CASCADE,
500 ADD CONSTRAINT `fk_lesson_teacher1` FOREIGN KEY (`tnr`) REFERENCES `teacher` (`tnr`) ON DELETE CASCADE ON UPDATE CASCADE,
501 ADD CONSTRAINT `fk_lesson_timetable1` FOREIGN KEY (`tbnr`) REFERENCES `timetable` (`tbnr`) ON DELETE CASCADE ON UPDATE CASCADE;
502
503--
504-- Constraints for table `room_has_object`
505--
506ALTER TABLE `room_has_object`
507 ADD CONSTRAINT `fk_room_has_object_object1` FOREIGN KEY (`onr`) REFERENCES `object` (`onr`) ON DELETE CASCADE ON UPDATE CASCADE,
508 ADD CONSTRAINT `fk_room_has_object_room1` FOREIGN KEY (`rnr`) REFERENCES `room` (`rnr`) ON DELETE CASCADE ON UPDATE CASCADE;
509
510--
511-- Constraints for table `subject_requires_object`
512--
513ALTER TABLE `subject_requires_object`
514 ADD CONSTRAINT `fk_subject_has_object_object1` FOREIGN KEY (`onr`) REFERENCES `object` (`onr`) ON DELETE CASCADE ON UPDATE CASCADE,
515 ADD CONSTRAINT `fk_subject_has_object_subject1` FOREIGN KEY (`snr`) REFERENCES `subject` (`snr`) ON DELETE CASCADE ON UPDATE CASCADE;
516
517--
518-- Constraints for table `teacher_knows_subject`
519--
520ALTER TABLE `teacher_knows_subject`
521 ADD CONSTRAINT `fk_teacher_has_subject_subject1` FOREIGN KEY (`snr`) REFERENCES `subject` (`snr`) ON DELETE CASCADE ON UPDATE CASCADE,
522 ADD CONSTRAINT `fk_teacher_has_subject_teacher1` FOREIGN KEY (`tnr`) REFERENCES `teacher` (`tnr`) ON DELETE CASCADE ON UPDATE CASCADE;
523
524--
525-- Constraints for table `timetable`
526--
527ALTER TABLE `timetable`
528 ADD CONSTRAINT `a` FOREIGN KEY (`semnr`) REFERENCES `semester` (`semnr`) ON DELETE CASCADE ON UPDATE CASCADE,
529 ADD CONSTRAINT `b` FOREIGN KEY (`cnr`) REFERENCES `class` (`cnr`) ON DELETE CASCADE ON UPDATE CASCADE;
530COMMIT;
531
532/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
533/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
534/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;