BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "Building" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"Name"	TEXT NOT NULL,
	"Faculty"	TEXT NOT NULL,
	"Address"	TEXT,
	PRIMARY KEY("Id" AUTOINCREMENT)
);
CREATE TABLE IF NOT EXISTS "SemesterType" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"Name"	TEXT NOT NULL,
	PRIMARY KEY("Id" AUTOINCREMENT)
);
CREATE TABLE IF NOT EXISTS "LessonType" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"Abbreviation"	TEXT NOT NULL,
	"Description"	TEXT,
	"ColorHexcode"	TEXT NOT NULL DEFAULT '#ffffff',
	PRIMARY KEY("Id" AUTOINCREMENT)
);
CREATE TABLE IF NOT EXISTS "Room" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"Name"	TEXT NOT NULL,
	"BuildingId"	INTEGER NOT NULL,
	"RoomTypeId"	INTEGER,
	"Description"	TEXT,
	"Capacity"	INTEGER NOT NULL DEFAULT 0,
	PRIMARY KEY("Id" AUTOINCREMENT),
	FOREIGN KEY("RoomTypeId") REFERENCES "RoomType"("Id") ON DELETE SET NULL ON UPDATE CASCADE,
	FOREIGN KEY("BuildingId") REFERENCES "Building"("Id") ON DELETE RESTRICT ON UPDATE CASCADE
);
CREATE TABLE IF NOT EXISTS "LessonRoom" (
	"LessonId"	INTEGER NOT NULL,
	"RoomId"	INTEGER NOT NULL,
	PRIMARY KEY("LessonId","RoomId"),
	FOREIGN KEY("LessonId") REFERENCES "Lesson"("Id") ON DELETE CASCADE ON UPDATE CASCADE,
	FOREIGN KEY("RoomId") REFERENCES "Room"("Id") ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE IF NOT EXISTS "LessonStudentGroup" (
	"LessonId"	INTEGER NOT NULL,
	"StudentGroupId"	INTEGER NOT NULL,
	PRIMARY KEY("LessonId","StudentGroupId"),
	FOREIGN KEY("LessonId") REFERENCES "Lesson"("Id") ON DELETE CASCADE ON UPDATE CASCADE,
	FOREIGN KEY("StudentGroupId") REFERENCES "StudentGroup"("Id") ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE IF NOT EXISTS "LessonTeacher" (
	"LessonId"	INTEGER NOT NULL,
	"TeacherId"	INTEGER NOT NULL,
	PRIMARY KEY("LessonId","TeacherId"),
	FOREIGN KEY("LessonId") REFERENCES "Lesson"("Id") ON DELETE CASCADE ON UPDATE CASCADE,
	FOREIGN KEY("TeacherId") REFERENCES "Teacher"("Id") ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE IF NOT EXISTS "CourseHours" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"LessonTypeId"	INTEGER NOT NULL,
	"CourseId"	INTEGER NOT NULL,
	"Hours"	INTEGER NOT NULL DEFAULT 2,
	PRIMARY KEY("Id" AUTOINCREMENT),
	FOREIGN KEY("CourseId") REFERENCES "Course"("Id") ON DELETE CASCADE ON UPDATE CASCADE,
	FOREIGN KEY("LessonTypeId") REFERENCES "LessonType"("Id") ON UPDATE CASCADE
);
CREATE TABLE IF NOT EXISTS "Semester" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"SemesterTypeId"	INTEGER NOT NULL,
	"DateStartDT"	TEXT NOT NULL,
	"DateEndDT"	TEXT NOT NULL,
	"AcademicStartYear"	INTEGER NOT NULL,
	PRIMARY KEY("Id" AUTOINCREMENT),
	FOREIGN KEY("SemesterTypeId") REFERENCES "SemesterType"("Id") ON UPDATE CASCADE
);
CREATE TABLE IF NOT EXISTS "StudentGroup" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"CurriculumId"	INTEGER NOT NULL,
	"SemesterId"	INTEGER NOT NULL,
	"Name"	TEXT NOT NULL,
	"Capacity"	INTEGER NOT NULL DEFAULT 20,
	"YearOfStudy"	INTEGER NOT NULL DEFAULT 1,
	PRIMARY KEY("Id" AUTOINCREMENT),
	FOREIGN KEY("SemesterId") REFERENCES "Semester"("Id") ON DELETE CASCADE ON UPDATE CASCADE,
	FOREIGN KEY("CurriculumId") REFERENCES "Curriculum"("Id") ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE IF NOT EXISTS "CurriculumCourse" (
	"CurriculumId"	INTEGER NOT NULL,
	"CourseId"	INTEGER NOT NULL,
	"YearOfStudy"	INTEGER NOT NULL DEFAULT 1,
	"SemesterTypeId"	INTEGER NOT NULL DEFAULT 1,
	PRIMARY KEY("CurriculumId","CourseId"),
	FOREIGN KEY("SemesterTypeId") REFERENCES "SemesterType"("Id") ON DELETE RESTRICT ON UPDATE CASCADE,
	FOREIGN KEY("CurriculumId") REFERENCES "Curriculum"("Id") ON UPDATE CASCADE ON DELETE CASCADE,
	FOREIGN KEY("CourseId") REFERENCES "Course"("Id") ON UPDATE CASCADE ON DELETE CASCADE
);
CREATE TABLE IF NOT EXISTS "Course" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"Abbreviation"	TEXT NOT NULL,
	"Name"	TEXT,
	PRIMARY KEY("Id" AUTOINCREMENT)
);
CREATE TABLE IF NOT EXISTS "Lesson" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"CourseId"	INTEGER NOT NULL,
	"LessonTypeId"	INTEGER NOT NULL,
	"Periodicity"	INTEGER NOT NULL DEFAULT 1,
	"PeriodStart"	INTEGER NOT NULL DEFAULT 0,
	"Hours"	INTEGER NOT NULL DEFAULT 2,
	"StartDateDT"	TEXT NOT NULL,
	"Note"	TEXT,
	"SemesterId"	INTEGER NOT NULL DEFAULT 1,
	PRIMARY KEY("Id" AUTOINCREMENT),
	FOREIGN KEY("CourseId") REFERENCES "Course"("Id") ON UPDATE CASCADE ON DELETE CASCADE,
	FOREIGN KEY("SemesterId") REFERENCES "Semester"("Id") ON DELETE CASCADE ON UPDATE CASCADE,
	FOREIGN KEY("LessonTypeId") REFERENCES "LessonType"("Id") ON UPDATE CASCADE ON DELETE RESTRICT
);
CREATE TABLE IF NOT EXISTS "RoomType" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"Name"	TEXT NOT NULL,
	"Description"	TEXT,
	PRIMARY KEY("Id" AUTOINCREMENT)
);
CREATE TABLE IF NOT EXISTS "Curriculum" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"Abbreviation"	TEXT NOT NULL,
	"Name"	TEXT NOT NULL,
	"Faculty"	TEXT NOT NULL,
	"Length"	INTEGER NOT NULL DEFAULT 3,
	"AccreditStartDT"	TEXT NOT NULL,
	"AccreditEndDT"	TEXT NOT NULL,
	PRIMARY KEY("Id" AUTOINCREMENT)
);
CREATE TABLE IF NOT EXISTS "Teacher" (
	"Id"	INTEGER NOT NULL UNIQUE,
	"FirstName"	TEXT NOT NULL,
	"LastName"	TEXT NOT NULL,
	"Ranks"	TEXT,
	PRIMARY KEY("Id" AUTOINCREMENT)
);
INSERT INTO "Building" VALUES (1,'A1','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (2,'A2','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (3,'A3','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (4,'A4','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (5,'A5','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (6,'A6','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (7,'B1','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (8,'B2','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (9,'B3','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (10,'C0','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (11,'C1','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (12,'C2','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (13,'C3','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (14,'C3a','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (15,'D0','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (16,'D1','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (17,'D2','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (18,'D3','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (19,'D4','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (20,'D5','FSI','Technická 2896/2, 616 69 Brno');
INSERT INTO "Building" VALUES (21,'A','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (22,'B','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (23,'C','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (24,'D','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (25,'E','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (26,'F','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (27,'G','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (28,'H','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (29,'T8','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (30,'T10','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (31,'T12','FEKT','Technická 3058/10, 616 00 Brno');
INSERT INTO "Building" VALUES (32,'A','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (33,'B','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (34,'C','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (35,'D','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (36,'E','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (37,'F','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (38,'G','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (39,'H','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (40,'I','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (41,'J','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (42,'K','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (43,'L','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (44,'M','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (45,'N','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (46,'O','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (47,'P','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (48,'Q','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (49,'R','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "Building" VALUES (50,'S','FIT','Božetěchova 2, 612 00 Brno');
INSERT INTO "SemesterType" VALUES (1,'Zimní');
INSERT INTO "SemesterType" VALUES (2,'Letní');
INSERT INTO "LessonType" VALUES (0,'X','Nedostupný','#222222');
INSERT INTO "LessonType" VALUES (1,'P','Přednáška','#9cff9c');
INSERT INTO "LessonType" VALUES (2,'C1','Cvičení','#ccffff');
INSERT INTO "LessonType" VALUES (3,'C2a','Cvičení na PC','#ffffcc');
INSERT INTO "LessonType" VALUES (4,'C2b','Laboratoře a ateliéry','#ffe5b7');
INSERT INTO "LessonType" VALUES (5,'CPP','Cvičení s počítačovou podporou','#ffffff');
INSERT INTO "LessonType" VALUES (6,'L','Laboratorní cvičení','#ffe5b7');
INSERT INTO "LessonType" VALUES (7,'KK','Konzultace v kombinovaném studiu','#ffffff');
INSERT INTO "LessonType" VALUES (8,'K','Konzultace','#ffffff');
INSERT INTO "LessonType" VALUES (9,'Cj','Cvičení jazykové','#ffffcc');
INSERT INTO "LessonType" VALUES (10,'VB','Vedení bakalářské práce','#ffffcc');
INSERT INTO "LessonType" VALUES (11,'VD','Vedení diplomové práce','#ffffcc');
INSERT INTO "LessonType" VALUES (12,'A','Ateliér','#ffe5b7');
INSERT INTO "LessonType" VALUES (13,'Z','Zkouška','#ffffff');
INSERT INTO "LessonType" VALUES (14,'Cp','Cvičení na počítači','#ffffcc');
INSERT INTO "LessonType" VALUES (15,'PX','Odborná praxe','#ffffff');
INSERT INTO "Room" VALUES (1,'A1/0618',1,1,NULL,0);
INSERT INTO "Room" VALUES (2,'A1/0619',1,1,NULL,0);
INSERT INTO "Room" VALUES (3,'A1/0620',1,1,NULL,0);
INSERT INTO "Room" VALUES (4,'A1/0621',1,1,NULL,0);
INSERT INTO "Room" VALUES (5,'A1/0622',1,1,NULL,0);
INSERT INTO "Room" VALUES (6,'A1/0623',1,1,NULL,0);
INSERT INTO "Room" VALUES (7,'A1/0624',1,1,NULL,0);
INSERT INTO "Room" VALUES (8,'A1/0625',1,1,NULL,0);
INSERT INTO "Room" VALUES (9,'A1/0626',1,1,NULL,0);
INSERT INTO "Room" VALUES (10,'A1/0627',1,1,NULL,0);
INSERT INTO "Room" VALUES (11,'A1/0628',1,1,NULL,0);
INSERT INTO "Room" VALUES (12,'A1/0629',1,1,NULL,0);
INSERT INTO "Room" VALUES (13,'A1/0635',1,3,NULL,0);
INSERT INTO "Room" VALUES (14,'A1/0636',1,5,NULL,0);
INSERT INTO "Room" VALUES (15,'A1/0637',1,1,NULL,0);
INSERT INTO "Room" VALUES (16,'A1/0638',1,1,NULL,0);
INSERT INTO "Room" VALUES (17,'A1/0639',1,1,NULL,0);
INSERT INTO "Room" VALUES (18,'A1/0640',1,1,NULL,0);
INSERT INTO "Room" VALUES (19,'A1/0641',1,1,NULL,0);
INSERT INTO "Room" VALUES (20,'A1/0642',1,1,NULL,0);
INSERT INTO "Room" VALUES (21,'A1/0643',1,1,NULL,0);
INSERT INTO "Room" VALUES (22,'Aula Q',6,2,NULL,0);
INSERT INTO "Room" VALUES (23,'P1',5,2,NULL,0);
INSERT INTO "Room" VALUES (24,'P2',5,2,NULL,0);
INSERT INTO "Room" VALUES (25,'P3',5,2,NULL,0);
INSERT INTO "Room" VALUES (26,'P4',5,2,NULL,0);
INSERT INTO "Room" VALUES (27,'P5',5,2,NULL,0);
INSERT INTO "Room" VALUES (28,'P6',5,2,NULL,0);
INSERT INTO "Room" VALUES (29,'U1',5,1,NULL,0);
INSERT INTO "Room" VALUES (30,'U2',5,1,NULL,0);
INSERT INTO "Room" VALUES (31,'U3',5,1,NULL,0);
INSERT INTO "Room" VALUES (32,'U4',5,1,NULL,0);
INSERT INTO "Room" VALUES (33,'U5',5,1,NULL,0);
INSERT INTO "Room" VALUES (34,'U6',5,1,NULL,0);
INSERT INTO "Room" VALUES (35,'U7',5,1,NULL,0);
INSERT INTO "Room" VALUES (36,'U8',5,1,NULL,0);
INSERT INTO "Room" VALUES (37,'A4/701',4,1,NULL,0);
INSERT INTO "Room" VALUES (38,'A4/702',4,1,NULL,0);
INSERT INTO "Room" VALUES (39,'A4/703',4,1,NULL,0);
INSERT INTO "Room" VALUES (40,'A4/705',4,1,NULL,0);
INSERT INTO "Room" VALUES (41,'A4/707',4,1,NULL,0);
INSERT INTO "Room" VALUES (42,'A4/708',4,1,NULL,0);
INSERT INTO "Room" VALUES (43,'A4/711',4,5,NULL,0);
INSERT INTO "Room" VALUES (44,'A4/712',4,1,NULL,0);
INSERT INTO "Room" VALUES (45,'A4/713',4,1,NULL,0);
INSERT INTO "Room" VALUES (46,'A4/714',4,5,NULL,0);
INSERT INTO "Room" VALUES (47,'A4/715a',4,5,NULL,0);
INSERT INTO "Room" VALUES (48,'A4/711a',4,1,NULL,0);
INSERT INTO "Room" VALUES (49,'A4/712a',4,1,NULL,0);
INSERT INTO "Room" VALUES (50,'A4/716',4,1,NULL,0);
INSERT INTO "Room" VALUES (51,'T12/SD 2.104',31,5,NULL,0);
INSERT INTO "Room" VALUES (52,'T12/SD 2.99',31,2,NULL,0);
INSERT INTO "Room" VALUES (53,'N/N203',45,1,NULL,0);
INSERT INTO "Room" VALUES (54,'D/D0207',35,2,NULL,0);
INSERT INTO "CourseHours" VALUES (1,1,1,26);
INSERT INTO "CourseHours" VALUES (2,6,1,14);
INSERT INTO "CourseHours" VALUES (3,5,1,12);
INSERT INTO "CourseHours" VALUES (4,1,2,26);
INSERT INTO "CourseHours" VALUES (5,5,2,26);
INSERT INTO "CourseHours" VALUES (6,1,3,52);
INSERT INTO "CourseHours" VALUES (7,8,3,26);
INSERT INTO "CourseHours" VALUES (8,2,3,12);
INSERT INTO "CourseHours" VALUES (9,5,3,14);
INSERT INTO "CourseHours" VALUES (10,1,4,26);
INSERT INTO "CourseHours" VALUES (11,5,4,26);
INSERT INTO "CourseHours" VALUES (12,9,5,26);
INSERT INTO "CourseHours" VALUES (13,1,6,26);
INSERT INTO "CourseHours" VALUES (14,6,6,22);
INSERT INTO "CourseHours" VALUES (15,2,6,4);
INSERT INTO "CourseHours" VALUES (16,1,7,39);
INSERT INTO "CourseHours" VALUES (17,6,7,8);
INSERT INTO "CourseHours" VALUES (18,5,7,18);
INSERT INTO "CourseHours" VALUES (19,1,8,26);
INSERT INTO "CourseHours" VALUES (20,5,8,26);
INSERT INTO "CourseHours" VALUES (21,1,9,39);
INSERT INTO "CourseHours" VALUES (22,6,9,26);
INSERT INTO "CourseHours" VALUES (23,1,10,26);
INSERT INTO "CourseHours" VALUES (24,5,10,26);
INSERT INTO "CourseHours" VALUES (25,8,11,1);
INSERT INTO "CourseHours" VALUES (26,9,12,26);
INSERT INTO "CourseHours" VALUES (27,1,13,52);
INSERT INTO "CourseHours" VALUES (28,2,13,14);
INSERT INTO "CourseHours" VALUES (29,5,13,12);
INSERT INTO "CourseHours" VALUES (30,1,14,39);
INSERT INTO "CourseHours" VALUES (31,6,14,39);
INSERT INTO "CourseHours" VALUES (32,6,15,39);
INSERT INTO "CourseHours" VALUES (33,1,16,26);
INSERT INTO "CourseHours" VALUES (34,6,16,26);
INSERT INTO "CourseHours" VALUES (35,1,17,26);
INSERT INTO "CourseHours" VALUES (36,5,17,39);
INSERT INTO "CourseHours" VALUES (37,1,18,26);
INSERT INTO "CourseHours" VALUES (38,5,18,26);
INSERT INTO "CourseHours" VALUES (39,1,19,39);
INSERT INTO "CourseHours" VALUES (40,6,19,26);
INSERT INTO "CourseHours" VALUES (41,1,20,13);
INSERT INTO "CourseHours" VALUES (42,6,20,39);
INSERT INTO "CourseHours" VALUES (43,10,21,130);
INSERT INTO "CourseHours" VALUES (44,1,22,26);
INSERT INTO "CourseHours" VALUES (45,5,22,13);
INSERT INTO "CourseHours" VALUES (46,1,23,26);
INSERT INTO "CourseHours" VALUES (47,5,23,26);
INSERT INTO "CourseHours" VALUES (48,5,24,26);
INSERT INTO "CourseHours" VALUES (49,5,25,26);
INSERT INTO "CourseHours" VALUES (50,2,26,26);
INSERT INTO "CourseHours" VALUES (51,1,27,26);
INSERT INTO "CourseHours" VALUES (52,6,27,26);
INSERT INTO "CourseHours" VALUES (53,7,28,13);
INSERT INTO "CourseHours" VALUES (54,8,28,34);
INSERT INTO "CourseHours" VALUES (55,6,28,5);
INSERT INTO "CourseHours" VALUES (56,7,29,17);
INSERT INTO "CourseHours" VALUES (57,8,29,35);
INSERT INTO "CourseHours" VALUES (58,7,30,26);
INSERT INTO "CourseHours" VALUES (59,8,30,78);
INSERT INTO "CourseHours" VALUES (60,7,31,17);
INSERT INTO "CourseHours" VALUES (61,8,31,35);
INSERT INTO "CourseHours" VALUES (62,7,32,9);
INSERT INTO "CourseHours" VALUES (63,8,32,17);
INSERT INTO "CourseHours" VALUES (64,7,33,10);
INSERT INTO "CourseHours" VALUES (65,8,33,35);
INSERT INTO "CourseHours" VALUES (66,6,33,7);
INSERT INTO "CourseHours" VALUES (67,7,34,19);
INSERT INTO "CourseHours" VALUES (68,8,34,43);
INSERT INTO "CourseHours" VALUES (69,6,34,3);
INSERT INTO "CourseHours" VALUES (70,7,35,17);
INSERT INTO "CourseHours" VALUES (71,8,35,35);
INSERT INTO "CourseHours" VALUES (72,7,36,13);
INSERT INTO "CourseHours" VALUES (73,8,36,43);
INSERT INTO "CourseHours" VALUES (74,6,36,9);
INSERT INTO "CourseHours" VALUES (75,7,37,17);
INSERT INTO "CourseHours" VALUES (76,8,37,35);
INSERT INTO "CourseHours" VALUES (77,8,38,1);
INSERT INTO "CourseHours" VALUES (78,7,39,9);
INSERT INTO "CourseHours" VALUES (79,8,39,17);
INSERT INTO "CourseHours" VALUES (80,7,40,26);
INSERT INTO "CourseHours" VALUES (81,8,40,52);
INSERT INTO "CourseHours" VALUES (82,7,41,13);
INSERT INTO "CourseHours" VALUES (83,8,41,52);
INSERT INTO "CourseHours" VALUES (84,6,41,13);
INSERT INTO "CourseHours" VALUES (85,7,43,9);
INSERT INTO "CourseHours" VALUES (86,8,43,34);
INSERT INTO "CourseHours" VALUES (87,6,43,9);
INSERT INTO "CourseHours" VALUES (88,7,44,22);
INSERT INTO "CourseHours" VALUES (89,8,44,43);
INSERT INTO "CourseHours" VALUES (90,7,45,17);
INSERT INTO "CourseHours" VALUES (91,8,45,35);
INSERT INTO "CourseHours" VALUES (92,7,46,13);
INSERT INTO "CourseHours" VALUES (93,8,46,43);
INSERT INTO "CourseHours" VALUES (94,6,46,9);
INSERT INTO "CourseHours" VALUES (95,7,47,4);
INSERT INTO "CourseHours" VALUES (96,8,47,35);
INSERT INTO "CourseHours" VALUES (97,6,47,13);
INSERT INTO "CourseHours" VALUES (98,10,48,130);
INSERT INTO "CourseHours" VALUES (99,7,49,13);
INSERT INTO "CourseHours" VALUES (100,8,49,26);
INSERT INTO "CourseHours" VALUES (101,7,50,17);
INSERT INTO "CourseHours" VALUES (102,8,50,35);
INSERT INTO "CourseHours" VALUES (103,7,51,9);
INSERT INTO "CourseHours" VALUES (104,8,51,17);
INSERT INTO "CourseHours" VALUES (105,7,52,9);
INSERT INTO "CourseHours" VALUES (106,8,52,17);
INSERT INTO "CourseHours" VALUES (107,7,53,9);
INSERT INTO "CourseHours" VALUES (108,8,53,17);
INSERT INTO "CourseHours" VALUES (109,7,54,9);
INSERT INTO "CourseHours" VALUES (110,8,54,34);
INSERT INTO "CourseHours" VALUES (111,6,54,9);
INSERT INTO "CourseHours" VALUES (112,1,55,26);
INSERT INTO "CourseHours" VALUES (113,6,55,26);
INSERT INTO "CourseHours" VALUES (114,1,56,52);
INSERT INTO "CourseHours" VALUES (115,5,56,26);
INSERT INTO "CourseHours" VALUES (116,1,57,26);
INSERT INTO "CourseHours" VALUES (117,6,57,26);
INSERT INTO "CourseHours" VALUES (118,1,58,39);
INSERT INTO "CourseHours" VALUES (119,6,58,26);
INSERT INTO "CourseHours" VALUES (120,1,59,39);
INSERT INTO "CourseHours" VALUES (121,6,59,8);
INSERT INTO "CourseHours" VALUES (122,5,59,18);
INSERT INTO "CourseHours" VALUES (123,1,60,26);
INSERT INTO "CourseHours" VALUES (124,5,60,26);
INSERT INTO "CourseHours" VALUES (125,1,61,26);
INSERT INTO "CourseHours" VALUES (126,5,61,26);
INSERT INTO "CourseHours" VALUES (127,1,62,26);
INSERT INTO "CourseHours" VALUES (128,5,62,26);
INSERT INTO "CourseHours" VALUES (129,1,63,26);
INSERT INTO "CourseHours" VALUES (130,6,63,26);
INSERT INTO "CourseHours" VALUES (131,1,64,26);
INSERT INTO "CourseHours" VALUES (132,5,64,26);
INSERT INTO "CourseHours" VALUES (133,1,65,13);
INSERT INTO "CourseHours" VALUES (134,5,65,26);
INSERT INTO "CourseHours" VALUES (135,1,66,39);
INSERT INTO "CourseHours" VALUES (136,2,66,12);
INSERT INTO "CourseHours" VALUES (137,5,66,14);
INSERT INTO "CourseHours" VALUES (138,1,67,39);
INSERT INTO "CourseHours" VALUES (139,6,67,8);
INSERT INTO "CourseHours" VALUES (140,5,67,18);
INSERT INTO "CourseHours" VALUES (141,1,68,26);
INSERT INTO "CourseHours" VALUES (142,5,68,13);
INSERT INTO "CourseHours" VALUES (143,1,69,13);
INSERT INTO "CourseHours" VALUES (144,5,69,26);
INSERT INTO "CourseHours" VALUES (145,1,70,13);
INSERT INTO "CourseHours" VALUES (146,5,70,26);
INSERT INTO "CourseHours" VALUES (147,1,71,26);
INSERT INTO "CourseHours" VALUES (148,5,71,26);
INSERT INTO "CourseHours" VALUES (149,1,72,26);
INSERT INTO "CourseHours" VALUES (150,5,72,26);
INSERT INTO "CourseHours" VALUES (151,15,73,120);
INSERT INTO "CourseHours" VALUES (152,1,74,13);
INSERT INTO "CourseHours" VALUES (153,5,74,26);
INSERT INTO "CourseHours" VALUES (154,1,75,26);
INSERT INTO "CourseHours" VALUES (155,14,75,26);
INSERT INTO "CourseHours" VALUES (156,1,76,39);
INSERT INTO "CourseHours" VALUES (157,5,76,26);
INSERT INTO "CourseHours" VALUES (158,1,77,39);
INSERT INTO "CourseHours" VALUES (159,5,77,26);
INSERT INTO "CourseHours" VALUES (160,1,78,26);
INSERT INTO "CourseHours" VALUES (161,5,78,26);
INSERT INTO "CourseHours" VALUES (162,1,79,26);
INSERT INTO "CourseHours" VALUES (163,6,79,26);
INSERT INTO "CourseHours" VALUES (164,1,80,26);
INSERT INTO "CourseHours" VALUES (165,1,81,26);
INSERT INTO "CourseHours" VALUES (166,5,81,26);
INSERT INTO "CourseHours" VALUES (167,11,82,156);
INSERT INTO "CourseHours" VALUES (168,1,83,26);
INSERT INTO "CourseHours" VALUES (169,5,83,26);
INSERT INTO "CourseHours" VALUES (170,2,84,26);
INSERT INTO "CourseHours" VALUES (171,8,85,1);
INSERT INTO "CourseHours" VALUES (172,1,86,26);
INSERT INTO "CourseHours" VALUES (173,6,86,26);
INSERT INTO "CourseHours" VALUES (174,1,87,13);
INSERT INTO "CourseHours" VALUES (175,5,87,26);
INSERT INTO "CourseHours" VALUES (176,7,88,13);
INSERT INTO "CourseHours" VALUES (177,8,88,13);
INSERT INTO "CourseHours" VALUES (178,7,89,9);
INSERT INTO "CourseHours" VALUES (179,8,89,34);
INSERT INTO "CourseHours" VALUES (180,6,89,9);
INSERT INTO "CourseHours" VALUES (181,7,90,26);
INSERT INTO "CourseHours" VALUES (182,8,90,52);
INSERT INTO "CourseHours" VALUES (183,7,91,9);
INSERT INTO "CourseHours" VALUES (184,8,91,34);
INSERT INTO "CourseHours" VALUES (185,6,91,9);
INSERT INTO "CourseHours" VALUES (186,7,92,13);
INSERT INTO "CourseHours" VALUES (187,8,92,43);
INSERT INTO "CourseHours" VALUES (188,6,92,9);
INSERT INTO "CourseHours" VALUES (189,7,93,19);
INSERT INTO "CourseHours" VALUES (190,8,93,43);
INSERT INTO "CourseHours" VALUES (191,6,93,3);
INSERT INTO "CourseHours" VALUES (192,7,94,17);
INSERT INTO "CourseHours" VALUES (193,8,94,35);
INSERT INTO "CourseHours" VALUES (194,7,95,17);
INSERT INTO "CourseHours" VALUES (195,8,95,35);
INSERT INTO "CourseHours" VALUES (196,7,96,13);
INSERT INTO "CourseHours" VALUES (197,8,96,13);
INSERT INTO "CourseHours" VALUES (198,7,97,9);
INSERT INTO "CourseHours" VALUES (199,8,97,34);
INSERT INTO "CourseHours" VALUES (200,6,97,9);
INSERT INTO "CourseHours" VALUES (201,7,98,17);
INSERT INTO "CourseHours" VALUES (202,8,98,35);
INSERT INTO "CourseHours" VALUES (203,7,99,13);
INSERT INTO "CourseHours" VALUES (204,8,99,26);
INSERT INTO "CourseHours" VALUES (205,7,100,22);
INSERT INTO "CourseHours" VALUES (206,8,100,43);
INSERT INTO "CourseHours" VALUES (207,7,101,19);
INSERT INTO "CourseHours" VALUES (208,8,101,43);
INSERT INTO "CourseHours" VALUES (209,6,101,3);
INSERT INTO "CourseHours" VALUES (210,7,102,13);
INSERT INTO "CourseHours" VALUES (211,8,102,26);
INSERT INTO "CourseHours" VALUES (212,7,103,13);
INSERT INTO "CourseHours" VALUES (213,8,103,26);
INSERT INTO "CourseHours" VALUES (214,7,104,13);
INSERT INTO "CourseHours" VALUES (215,8,104,26);
INSERT INTO "CourseHours" VALUES (216,7,105,13);
INSERT INTO "CourseHours" VALUES (217,8,105,26);
INSERT INTO "CourseHours" VALUES (218,1,106,26);
INSERT INTO "CourseHours" VALUES (219,14,106,26);
INSERT INTO "CourseHours" VALUES (220,7,107,22);
INSERT INTO "CourseHours" VALUES (221,8,107,43);
INSERT INTO "CourseHours" VALUES (222,7,108,22);
INSERT INTO "CourseHours" VALUES (223,8,108,43);
INSERT INTO "CourseHours" VALUES (224,7,109,17);
INSERT INTO "CourseHours" VALUES (225,8,109,35);
INSERT INTO "CourseHours" VALUES (226,7,110,9);
INSERT INTO "CourseHours" VALUES (227,8,110,34);
INSERT INTO "CourseHours" VALUES (228,6,110,9);
INSERT INTO "CourseHours" VALUES (229,7,111,9);
INSERT INTO "CourseHours" VALUES (230,8,111,17);
INSERT INTO "CourseHours" VALUES (231,7,112,17);
INSERT INTO "CourseHours" VALUES (232,8,112,35);
INSERT INTO "CourseHours" VALUES (233,11,113,156);
INSERT INTO "CourseHours" VALUES (234,7,114,17);
INSERT INTO "CourseHours" VALUES (235,8,114,35);
INSERT INTO "CourseHours" VALUES (236,7,115,9);
INSERT INTO "CourseHours" VALUES (237,8,115,17);
INSERT INTO "Semester" VALUES (1,1,'20.09.2021 0:00:00','17.12.2021 0:00:00',2021);
INSERT INTO "Semester" VALUES (2,2,'07.02.2022 0:00:00','06.05.2022 0:00:00',2021);
INSERT INTO "StudentGroup" VALUES (1,3,1,'4pAIŘ/1',20,1);
INSERT INTO "StudentGroup" VALUES (2,4,1,'4kAIŘ/1',20,1);
INSERT INTO "StudentGroup" VALUES (3,3,2,'4pAIŘ/1',20,1);
INSERT INTO "StudentGroup" VALUES (4,3,1,'5pAIŘ/1',20,2);
INSERT INTO "StudentGroup" VALUES (5,4,1,'5kAIŘ/1',20,2);
INSERT INTO "CurriculumCourse" VALUES (1,1,2,1);
INSERT INTO "CurriculumCourse" VALUES (1,2,2,1);
INSERT INTO "CurriculumCourse" VALUES (1,3,2,1);
INSERT INTO "CurriculumCourse" VALUES (1,4,2,1);
INSERT INTO "CurriculumCourse" VALUES (1,5,2,1);
INSERT INTO "CurriculumCourse" VALUES (1,6,2,1);
INSERT INTO "CurriculumCourse" VALUES (1,7,2,1);
INSERT INTO "CurriculumCourse" VALUES (1,8,2,2);
INSERT INTO "CurriculumCourse" VALUES (1,9,2,2);
INSERT INTO "CurriculumCourse" VALUES (1,10,2,2);
INSERT INTO "CurriculumCourse" VALUES (1,11,2,2);
INSERT INTO "CurriculumCourse" VALUES (1,12,2,2);
INSERT INTO "CurriculumCourse" VALUES (1,13,2,2);
INSERT INTO "CurriculumCourse" VALUES (1,14,2,2);
INSERT INTO "CurriculumCourse" VALUES (1,15,2,2);
INSERT INTO "CurriculumCourse" VALUES (1,16,3,1);
INSERT INTO "CurriculumCourse" VALUES (1,17,3,1);
INSERT INTO "CurriculumCourse" VALUES (1,18,3,1);
INSERT INTO "CurriculumCourse" VALUES (1,19,3,1);
INSERT INTO "CurriculumCourse" VALUES (1,20,3,1);
INSERT INTO "CurriculumCourse" VALUES (1,21,3,2);
INSERT INTO "CurriculumCourse" VALUES (1,22,3,2);
INSERT INTO "CurriculumCourse" VALUES (1,23,3,2);
INSERT INTO "CurriculumCourse" VALUES (1,24,3,2);
INSERT INTO "CurriculumCourse" VALUES (1,25,3,2);
INSERT INTO "CurriculumCourse" VALUES (1,26,3,2);
INSERT INTO "CurriculumCourse" VALUES (1,27,3,2);
INSERT INTO "CurriculumCourse" VALUES (2,28,2,1);
INSERT INTO "CurriculumCourse" VALUES (2,29,2,1);
INSERT INTO "CurriculumCourse" VALUES (2,30,2,1);
INSERT INTO "CurriculumCourse" VALUES (2,31,2,1);
INSERT INTO "CurriculumCourse" VALUES (2,32,2,1);
INSERT INTO "CurriculumCourse" VALUES (2,33,2,1);
INSERT INTO "CurriculumCourse" VALUES (2,34,2,1);
INSERT INTO "CurriculumCourse" VALUES (2,35,2,2);
INSERT INTO "CurriculumCourse" VALUES (2,36,2,2);
INSERT INTO "CurriculumCourse" VALUES (2,37,2,2);
INSERT INTO "CurriculumCourse" VALUES (2,38,2,2);
INSERT INTO "CurriculumCourse" VALUES (2,39,2,2);
INSERT INTO "CurriculumCourse" VALUES (2,40,2,2);
INSERT INTO "CurriculumCourse" VALUES (2,41,2,2);
INSERT INTO "CurriculumCourse" VALUES (2,43,3,1);
INSERT INTO "CurriculumCourse" VALUES (2,44,3,1);
INSERT INTO "CurriculumCourse" VALUES (2,45,3,1);
INSERT INTO "CurriculumCourse" VALUES (2,46,3,1);
INSERT INTO "CurriculumCourse" VALUES (2,47,3,1);
INSERT INTO "CurriculumCourse" VALUES (2,48,3,2);
INSERT INTO "CurriculumCourse" VALUES (2,49,3,2);
INSERT INTO "CurriculumCourse" VALUES (2,50,3,2);
INSERT INTO "CurriculumCourse" VALUES (2,51,3,2);
INSERT INTO "CurriculumCourse" VALUES (2,52,3,2);
INSERT INTO "CurriculumCourse" VALUES (2,53,3,2);
INSERT INTO "CurriculumCourse" VALUES (2,54,3,2);
INSERT INTO "CurriculumCourse" VALUES (3,55,1,1);
INSERT INTO "CurriculumCourse" VALUES (3,56,1,1);
INSERT INTO "CurriculumCourse" VALUES (3,57,1,1);
INSERT INTO "CurriculumCourse" VALUES (3,58,1,1);
INSERT INTO "CurriculumCourse" VALUES (3,59,1,1);
INSERT INTO "CurriculumCourse" VALUES (3,60,1,1);
INSERT INTO "CurriculumCourse" VALUES (3,61,1,1);
INSERT INTO "CurriculumCourse" VALUES (3,62,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,63,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,64,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,65,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,66,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,67,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,68,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,69,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,70,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,71,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,72,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,73,1,2);
INSERT INTO "CurriculumCourse" VALUES (3,74,2,1);
INSERT INTO "CurriculumCourse" VALUES (3,75,2,1);
INSERT INTO "CurriculumCourse" VALUES (3,76,2,1);
INSERT INTO "CurriculumCourse" VALUES (3,77,2,1);
INSERT INTO "CurriculumCourse" VALUES (3,78,2,1);
INSERT INTO "CurriculumCourse" VALUES (3,79,2,1);
INSERT INTO "CurriculumCourse" VALUES (3,80,2,2);
INSERT INTO "CurriculumCourse" VALUES (3,81,2,2);
INSERT INTO "CurriculumCourse" VALUES (3,82,2,2);
INSERT INTO "CurriculumCourse" VALUES (3,83,2,2);
INSERT INTO "CurriculumCourse" VALUES (3,84,2,2);
INSERT INTO "CurriculumCourse" VALUES (3,85,2,2);
INSERT INTO "CurriculumCourse" VALUES (3,86,2,2);
INSERT INTO "CurriculumCourse" VALUES (3,87,2,2);
INSERT INTO "CurriculumCourse" VALUES (4,88,1,1);
INSERT INTO "CurriculumCourse" VALUES (4,89,1,1);
INSERT INTO "CurriculumCourse" VALUES (4,90,1,1);
INSERT INTO "CurriculumCourse" VALUES (4,91,1,1);
INSERT INTO "CurriculumCourse" VALUES (4,92,1,1);
INSERT INTO "CurriculumCourse" VALUES (4,93,1,1);
INSERT INTO "CurriculumCourse" VALUES (4,94,1,1);
INSERT INTO "CurriculumCourse" VALUES (4,95,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,96,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,97,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,98,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,99,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,100,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,101,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,102,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,103,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,104,1,2);
INSERT INTO "CurriculumCourse" VALUES (4,105,2,1);
INSERT INTO "CurriculumCourse" VALUES (4,106,2,1);
INSERT INTO "CurriculumCourse" VALUES (4,107,2,1);
INSERT INTO "CurriculumCourse" VALUES (4,108,2,1);
INSERT INTO "CurriculumCourse" VALUES (4,109,2,1);
INSERT INTO "CurriculumCourse" VALUES (4,110,2,1);
INSERT INTO "CurriculumCourse" VALUES (4,111,2,2);
INSERT INTO "CurriculumCourse" VALUES (4,112,2,2);
INSERT INTO "CurriculumCourse" VALUES (4,113,2,2);
INSERT INTO "CurriculumCourse" VALUES (4,114,2,2);
INSERT INTO "CurriculumCourse" VALUES (4,115,2,2);
INSERT INTO "Course" VALUES (0,'X','Nedostupný');
INSERT INTO "Course" VALUES (1,'VHT','Hardware a mikroprocesorová technika');
INSERT INTO "Course" VALUES (2,'VPG','Počítače a grafika');
INSERT INTO "Course" VALUES (3,'4PP','Pružnost a pevnost');
INSERT INTO "Course" VALUES (4,'CS1','Statistika a pravděpodobnost');
INSERT INTO "Course" VALUES (5,'TEN1','Technical English');
INSERT INTO "Course" VALUES (6,'2VT','Výrobní technologie');
INSERT INTO "Course" VALUES (7,'VZR','Základy automatického řízení');
INSERT INTO "Course" VALUES (8,'VCP','Algoritmy a programovací techniky');
INSERT INTO "Course" VALUES (9,'6EE','Elektrotechnika a elektronika');
INSERT INTO "Course" VALUES (10,'VPN','Počítačové sítě a IoT');
INSERT INTO "Course" VALUES (11,'TEN3','Technical English Exam');
INSERT INTO "Course" VALUES (12,'TEN2','Technical English II');
INSERT INTO "Course" VALUES (13,'DTM','Technická mechanika');
INSERT INTO "Course" VALUES (14,'DTB','Technologie obrábění');
INSERT INTO "Course" VALUES (15,'0MR','Mobilní roboty');
INSERT INTO "Course" VALUES (16,'VPR','Automatizační prostředky');
INSERT INTO "Course" VALUES (17,'VOU','Počítačové řešení optimalizačních úloh');
INSERT INTO "Course" VALUES (18,'VSP','Simulace, plánování a rozvrhování výroby');
INSERT INTO "Course" VALUES (19,'VTM','Technická měření');
INSERT INTO "Course" VALUES (20,'VAM','Základy programovatelných automatů');
INSERT INTO "Course" VALUES (21,'FDI','Bakalářský projekt (B-AIŘ)');
INSERT INTO "Course" VALUES (22,'VDR','Diferenciální a diferenční rovnice v teorii řízení');
INSERT INTO "Course" VALUES (23,'VI4','Digitalizace průmyslu (Průmysl 4.0)	ne');
INSERT INTO "Course" VALUES (24,'0PA','Programování pro Android');
INSERT INTO "Course" VALUES (25,'VP0','Programování v Pythonu');
INSERT INTO "Course" VALUES (26,'FEI','Seminář k bakalářské práci (B-AIŘ)');
INSERT INTO "Course" VALUES (27,'6SR','Stavba výrobních strojů a robotů');
INSERT INTO "Course" VALUES (28,'VHT-K','Hardware a mikroprocesorová technika');
INSERT INTO "Course" VALUES (29,'VPG-K','Počítače a grafika');
INSERT INTO "Course" VALUES (30,'4PP-K','Pružnost a pevnost');
INSERT INTO "Course" VALUES (31,'CS1-K','Statistika a pravděpodobnost');
INSERT INTO "Course" VALUES (32,'TEN1-K','Technical English');
INSERT INTO "Course" VALUES (33,'2VT-K','Výrobní technologie');
INSERT INTO "Course" VALUES (34,'VZR-K','Základy automatického řízení');
INSERT INTO "Course" VALUES (35,'VCP-K','Algoritmy a programovací techniky');
INSERT INTO "Course" VALUES (36,'6EE-K','Elektrotechnika a elektronika');
INSERT INTO "Course" VALUES (37,'VPN-K','Počítačové sítě a IoT');
INSERT INTO "Course" VALUES (38,'TEN3-K','Technical English Exam');
INSERT INTO "Course" VALUES (39,'TEN2-K','Technical English II');
INSERT INTO "Course" VALUES (40,'DTM-K','Technická mechanika');
INSERT INTO "Course" VALUES (41,'DTB-K','Technologie obrábění');
INSERT INTO "Course" VALUES (43,'VPR-K','Automatizační prostředky');
INSERT INTO "Course" VALUES (44,'VOU-K','Počítačové řešení optimalizačních úloh');
INSERT INTO "Course" VALUES (45,'VSP-K','Simulace, plánování a rozvrhování výroby');
INSERT INTO "Course" VALUES (46,'VTM-K','Technická měření');
INSERT INTO "Course" VALUES (47,'VAM-K','Základy programovatelných automatů');
INSERT INTO "Course" VALUES (48,'FDI-K','Bakalářský projekt (B-AIŘ)');
INSERT INTO "Course" VALUES (49,'VDR-K','Diferenciální a diferenční rovnice v teorii řízení');
INSERT INTO "Course" VALUES (50,'VI4-K','Digitalizace průmyslu (Průmysl 4.0)');
INSERT INTO "Course" VALUES (51,'0PA-K','Programování pro Android');
INSERT INTO "Course" VALUES (52,'VP0-K','Programování v Pythonu');
INSERT INTO "Course" VALUES (53,'FEI-K','Seminář k bakalářské práci (B-AIŘ)');
INSERT INTO "Course" VALUES (54,'6SR-K','Stavba výrobních strojů a robotů');
INSERT INTO "Course" VALUES (55,'VAU','Elektrické a pneumatické automatizační prvky');
INSERT INTO "Course" VALUES (56,'VZI','Matematické základy informatiky');
INSERT INTO "Course" VALUES (57,'VPL','Programovatelné řídicí systémy (PLC)');
INSERT INTO "Course" VALUES (58,'VMD','Senzorika, měření a diagnostika');
INSERT INTO "Course" VALUES (59,'VA1','Teorie automatického řízení I');
INSERT INTO "Course" VALUES (60,'VTI','Teorie informace a kódování');
INSERT INTO "Course" VALUES (61,'V0M','CISCO CCNA 1');
INSERT INTO "Course" VALUES (62,'VAI','Algoritmy umělé inteligence');
INSERT INTO "Course" VALUES (63,'VAP','Aplikovaná elektronika a elektrické pohony');
INSERT INTO "Course" VALUES (64,'VSC','Neuronové sítě a strojové učení');
INSERT INTO "Course" VALUES (65,'VOB','Objektově orientované programování');
INSERT INTO "Course" VALUES (66,'FOA','Optimalizační metody I');
INSERT INTO "Course" VALUES (67,'VA2','Teorie automatického řízení II');
INSERT INTO "Course" VALUES (68,'VAS','Automatizace energetických systémů');
INSERT INTO "Course" VALUES (69,'VRM','Programování robotů a manipulátorů');
INSERT INTO "Course" VALUES (70,'VPD','Programování v Pythonu – Data Science');
INSERT INTO "Course" VALUES (71,'VCP','Algoritmy a programovací techniky');
INSERT INTO "Course" VALUES (72,'V0N','CISCO CCNA 2');
INSERT INTO "Course" VALUES (73,'0PPV','Průmyslový projekt (N-AIŘ)');
INSERT INTO "Course" VALUES (74,'VBC','Biologicky inspirované výpočty');
INSERT INTO "Course" VALUES (75,'MPC-MID','Modelování a identifikace');
INSERT INTO "Course" VALUES (76,'VPP','Optimalizační metody II');
INSERT INTO "Course" VALUES (77,'VSG','Signály a systémy');
INSERT INTO "Course" VALUES (78,'FSI','Simulace dynamických systémů');
INSERT INTO "Course" VALUES (79,'VSV','Strojové vidění');
INSERT INTO "Course" VALUES (80,'VTR','Algebraická teorie řízení');
INSERT INTO "Course" VALUES (81,'VDC','Databázové systémy a cloudová úložiště');
INSERT INTO "Course" VALUES (82,'VD9','Diplomový projekt (M-AIŘ)');
INSERT INTO "Course" VALUES (83,'VPK-A','Počítačová komunikace');
INSERT INTO "Course" VALUES (84,'VD8','Seminář k diplomové práci (M-AIŘ)');
INSERT INTO "Course" VALUES (85,'7AZM','Technická angličtina pro NMS');
INSERT INTO "Course" VALUES (86,'VE0','Odborná způsobilost v elektrotechnice');
INSERT INTO "Course" VALUES (87,'V0R','Virtuální realita');
INSERT INTO "Course" VALUES (88,'A5K','Angličtina 5 pro KS');
INSERT INTO "Course" VALUES (89,'VAU-K','Elektrické a pneumatické automatizační prvky');
INSERT INTO "Course" VALUES (90,'VZI-K','Matematické základy informatiky');
INSERT INTO "Course" VALUES (91,'VPL-K','Programovatelné řídicí systémy (PLC)');
INSERT INTO "Course" VALUES (92,'VMD-K','Senzorika, měření a diagnostika');
INSERT INTO "Course" VALUES (93,'VA1-K','Teorie automatického řízení I');
INSERT INTO "Course" VALUES (94,'VTI-K','Teorie informace a kódování');
INSERT INTO "Course" VALUES (95,'VAI-K','Algoritmy umělé inteligence');
INSERT INTO "Course" VALUES (96,'A6K','Angličtina 6 pro KS');
INSERT INTO "Course" VALUES (97,'VAP-K','Aplikovaná elektronika a elektrické pohony');
INSERT INTO "Course" VALUES (98,'VSC-K','Neuronové sítě a strojové učení');
INSERT INTO "Course" VALUES (99,'VOB-K','Objektově orientované programování');
INSERT INTO "Course" VALUES (100,'FOA-K','Optimalizační metody I');
INSERT INTO "Course" VALUES (101,'VA2-K','Teorie automatického řízení II');
INSERT INTO "Course" VALUES (102,'VAS-K','Automatizace energetických systémů');
INSERT INTO "Course" VALUES (103,'VRM-K','Programování robotů a manipulátorů');
INSERT INTO "Course" VALUES (104,'VPD-K','Programování v Pythonu – Data Science');
INSERT INTO "Course" VALUES (105,'VBC-K','Biologicky inspirované výpočty');
INSERT INTO "Course" VALUES (106,'MPC-MID-K','Modelování a identifikace');
INSERT INTO "Course" VALUES (107,'VPP-K','Optimalizační metody II');
INSERT INTO "Course" VALUES (108,'VSG-K','Signály a systémy');
INSERT INTO "Course" VALUES (109,'FSI-K','Simulace dynamických systémů');
INSERT INTO "Course" VALUES (110,'VSV-K','Strojové vidění');
INSERT INTO "Course" VALUES (111,'VTR-K','Algebraická teorie řízení');
INSERT INTO "Course" VALUES (112,'VDC-K','Databázové systémy a cloudová úložiště');
INSERT INTO "Course" VALUES (113,'VD9-K','Diplomový projekt (M-AIŘ)');
INSERT INTO "Course" VALUES (114,'VPK-K','Počítačová komunikace');
INSERT INTO "Course" VALUES (115,'VD8-K','Seminář k diplomové práci (M-AIŘ)');
INSERT INTO "RoomType" VALUES (1,'Běžná',NULL);
INSERT INTO "RoomType" VALUES (2,'Přednášková místnost',NULL);
INSERT INTO "RoomType" VALUES (3,'Laboratoř',NULL);
INSERT INTO "RoomType" VALUES (4,'Ateliér',NULL);
INSERT INTO "RoomType" VALUES (5,'PC učebna',NULL);
INSERT INTO "Curriculum" VALUES (1,'AIŘ','Aplikovaná informatika a řízení','FSI',3,'18.02.2020 0:00:00','18.02.2030 0:00:00');
INSERT INTO "Curriculum" VALUES (2,'AIŘ-K','Aplikovaná informatika a řízení','FSI',3,'18.02.2020 0:00:00','18.02.2030 0:00:00');
INSERT INTO "Curriculum" VALUES (3,'N-AIŘ-P','Aplikovaná informatika a řízení','FSI',2,'18.02.2020 0:00:00','18.02.2030 0:00:00');
INSERT INTO "Curriculum" VALUES (4,'N-AIŘ-K','Aplikovaná informatika a řízení','FSI',2,'18.02.2020 0:00:00','18.02.2030 0:00:00');
INSERT INTO "Teacher" VALUES (213,'Jindřich','Klapka','doc. RNDr., CSc.');
INSERT INTO "Teacher" VALUES (373,'Ivan','Švarc','doc. Ing., CSc.');
INSERT INTO "Teacher" VALUES (680,'Branislav','Lacko','doc. Ing., CSc.');
INSERT INTO "Teacher" VALUES (1095,'Zdeněk','Němec','doc. Ing., CSc.');
INSERT INTO "Teacher" VALUES (1116,'Jiří','Dvořák','RNDr., CSc.');
INSERT INTO "Teacher" VALUES (1421,'Miloš','Šeda','prof. RNDr. Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (1435,'Simeon','Simeonov','doc. Ing., CSc.');
INSERT INTO "Teacher" VALUES (1508,'Miloš','Hammer','doc. Ing., CSc.');
INSERT INTO "Teacher" VALUES (1519,'Jiří','Šťastný','prof. RNDr. Ing., CSc.');
INSERT INTO "Teacher" VALUES (1988,'Jan','Roupec','doc. Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (2018,'Olga','Davidová','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (2233,'Pavel','Heriban','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (2321,'Jan','Černocký','prof. Dr. Ing.');
INSERT INTO "Teacher" VALUES (2401,'Radomil','Matoušek','doc. Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (2498,'Petr','Blaha','doc. Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (2522,'Radek','Poliščuk','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (11980,'Tomáš','Holoubek','Ing.');
INSERT INTO "Teacher" VALUES (23310,'Monika','Dosoudilová','Mgr, Ph.D.');
INSERT INTO "Teacher" VALUES (27791,'Libor','Beneš','prof. Ing., Dr.');
INSERT INTO "Teacher" VALUES (32621,'Blanka','Rybková','Ing.');
INSERT INTO "Teacher" VALUES (49361,'Petr','Šoustek','Ing.');
INSERT INTO "Teacher" VALUES (74188,'Stanislav','Lang','Ing. et. Ing, Ph.D.');
INSERT INTO "Teacher" VALUES (78756,'Ivana','Hromková','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (85160,'Kateřina','Mouralová','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (107735,'Ladislav','Dobrovský','Ing.');
INSERT INTO "Teacher" VALUES (125766,'Jakub','Kůdela','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (125810,'Radim','Zahradníček','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (145185,'Tomáš','Prokeš','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (146256,'Zuzana','Otoupalík','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (146257,'Jan','Otoupalík','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (146782,'Ondřej','Bartík','Ing.');
INSERT INTO "Teacher" VALUES (152614,'Tomáš','Hůlka','Ing.');
INSERT INTO "Teacher" VALUES (162528,'Zdeněk','Cejpek','Ing.');
INSERT INTO "Teacher" VALUES (184605,'Roman','Parák','Ing.');
INSERT INTO "Teacher" VALUES (191435,'Antonín','Konečný','Ing.');
INSERT INTO "Teacher" VALUES (191542,'Jakub','Robota','Ing.');
INSERT INTO "Teacher" VALUES (191676,'Tomáš','Nevoral','Ing.');
INSERT INTO "Teacher" VALUES (191831,'Marina','Lengerová','doc. Mgr., Ph.D.');
INSERT INTO "Teacher" VALUES (209801,'Pavel','Škrabánek','Ing., Ph.D.');
INSERT INTO "Teacher" VALUES (214203,'Mhd Ali','Shehadeh','Ing.');
INSERT INTO "Teacher" VALUES (245816,'Marcel','Smejkal','Ing. Mgr.');
CREATE VIEW LessonMN AS SELECT Id as LessonId,TeacherId,RoomId,StudentGroupId FROM Lesson 
LEFT OUTER JOIN LessonTeacher ON LessonTeacher.LessonId = Lesson.Id
LEFT OUTER JOIN LessonRoom ON LessonRoom.LessonId = Lesson.Id
LEFT OUTER JOIN LessonStudentGroup ON LessonStudentGroup.LessonId = Lesson.Id;
CREATE VIEW CourseCheck AS
SELECT c.Id as "CourseId", c.Abbreviation as "CourseAbbreviation", lt.Id as "LessonTypeId", lt.Abbreviation as "LessonType",ch.Hours as "MinHours" FROM CourseHours AS ch 
JOIN LessonType AS lt ON lt.Id = ch.LessonTypeId 
JOIN Course AS c ON c.Id = ch.CourseId;
COMMIT;
