DROP TABLE Bbr\g CREATE TABLE Bbr( 100Semester_Text CHAR (50), 150Semester_Text CHAR (50), 50Semester_Text CHAR (50), Beruf CHAR (255), Branderdatum CHAR (50), Burschungsdatum CHAR (50), Couleurname CHAR (255), dc INT NOT NULL DEFAULT 0, Dienstanschrift CHAR (255), Dienststelle CHAR (255), email CHAR (255), Familienname CHAR (255), Familienstand CHAR (255), GebDat CHAR (255), Geburtsort CHAR (255), Handy CHAR (255), Hochschulstudium CHAR (255), ID INT NOT NULL DEFAULT 0, LKZ1 CHAR (50), LKZ2 CHAR (50), KZ SMALLINT, massenemail INT NOT NULL DEFAULT 0, Maturajahr CHAR (255), Militaerdienst CHAR (255), MKV CHAR (255), offenePunkte CHAR (200), offenePunkteStasi CHAR (100), Ort1 CHAR (255), Ort2 CHAR (255), Philistrierungsdatu CHAR (50), Photo_v SMALLINT, PLZ1 INT NOT NULL DEFAULT 0, PLZ2 CHAR (255), pm INT NOT NULL DEFAULT 0, Receptionsdatum CHAR (50), Schule CHAR (255), sonstiges BLOB, Stand CHAR (255), Standvom DATE, Sterbedat DATE, Strasse1 CHAR (255), Strasse2 CHAR (255), Tel1 CHAR (255), Tel1V CHAR (255), Tel2 CHAR (255), Tel2V CHAR (255), Tel3 CHAR (255), Tel3V CHAR (255), Titel1 CHAR (255), Titel2 CHAR (255), TStatus CHAR (50), TTyp CHAR (50), Verwandtschaftsverh CHAR (255), Vorname CHAR (255), VStatus INT NOT NULL DEFAULT 0, VTyp INT NOT NULL DEFAULT 0, www CHAR (255), KEY (ID) )\g DROP TABLE Chargen\g CREATE TABLE Chargen( ChargenIndex INT, Chargenzeichen CHAR (100) NOT NULL , KEY (Chargenzeichen), PRIMARY KEY (ChargenIndex) )\g INSERT INTO Chargen VALUES (1,'X')\g INSERT INTO Chargen VALUES (2,'XX')\g INSERT INTO Chargen VALUES (3,'XXX')\g INSERT INTO Chargen VALUES (4,'XXXX')\g INSERT INTO Chargen VALUES (5,'FM')\g INSERT INTO Chargen VALUES (6,'BW')\g INSERT INTO Chargen VALUES (7,'XXXX1')\g INSERT INTO Chargen VALUES (8,'XXXX2')\g INSERT INTO Chargen VALUES (9,'Philx')\g INSERT INTO Chargen VALUES (10,'Philxx')\g INSERT INTO Chargen VALUES (11,'Philxxx')\g INSERT INTO Chargen VALUES (12,'Philxxxx')\g INSERT INTO Chargen VALUES (13,'FKx')\g INSERT INTO Chargen VALUES (14,'FKxx')\g INSERT INTO Chargen VALUES (16,'Kassaprüfer Altherrenschaft')\g INSERT INTO Chargen VALUES (17,'Studienkommissions-Vorsitzender')\g INSERT INTO Chargen VALUES (18,'Studienkommissionsmitglied')\g INSERT INTO Chargen VALUES (19,'GOK')\g INSERT INTO Chargen VALUES (20,'Standesführer')\g INSERT INTO Chargen VALUES (21,'NBL-Brief-Chefredakteur')\g INSERT INTO Chargen VALUES (22,'Rechtspfleger')\g INSERT INTO Chargen VALUES (23,'VG-Vorsitzender')\g INSERT INTO Chargen VALUES (24,'VG')\g INSERT INTO Chargen VALUES (25,'VBSeel')\g INSERT INTO Chargen VALUES (26,'Kassaprüfer Aktivitas')\g INSERT INTO Chargen VALUES (27,'VG-Altherrenbeisitzer')\g INSERT INTO Chargen VALUES (28,'VG Ersatzmitglied Altherrenschaft')\g INSERT INTO Chargen VALUES (29,'VG-Aktivenvertreter')\g INSERT INTO Chargen VALUES (30,'VG Ersatzmitglied Aktivitas')\g INSERT INTO Chargen VALUES (31,'GO-Aktivenvertreter')\g INSERT INTO Chargen VALUES (32,'GO-Altherrenvertreter')\g INSERT INTO Chargen VALUES (33,'XX1')\g INSERT INTO Chargen VALUES (34,'XX2')\g INSERT INTO Chargen VALUES (35,'Studienkommissionsmitglied')\g INSERT INTO Chargen VALUES (36,'Kassaprüfer Aktivitas')\g INSERT INTO Chargen VALUES (37,'VG-Aktivenvertreter')\g INSERT INTO Chargen VALUES (38,'Kassaprüfer Altherrenschaft')\g INSERT INTO Chargen VALUES (39,'VG-Altherrenbeisitzer')\g INSERT INTO Chargen VALUES (40,'Webmaster')\g INSERT INTO Chargen VALUES (41,'Systemadministrator')\g DROP TABLE Corporation\g CREATE TABLE Corporation( Personennummer INT NOT NULL , Seit CHAR (30), Stand INT NOT NULL DEFAULT 3, VerbindungNr INT NOT NULL , PRIMARY KEY (Personennummer,VerbindungNr) )\g DROP TABLE GeleisteteChargen\g CREATE TABLE GeleisteteChargen( Ableistung INT NOT NULL DEFAULT 5, ChargenIndex INT NOT NULL , Leister INT NOT NULL DEFAULT 0, Semester INT NOT NULL )\g DROP TABLE Leibfuxen\g CREATE TABLE Leibfuxen( Leibbursch INT NOT NULL , Leibfux INT NOT NULL , KEY (Leibbursch), KEY (Leibfux), PRIMARY KEY (Leibfux) )\g DROP TABLE Semester\g CREATE TABLE Semester( Jahr CHAR (10), Semester INT NOT NULL DEFAULT 0, SemesterName CHAR (12) )\g INSERT INTO Semester VALUES ('2072',50172,'Ab 2072')\g INSERT INTO Semester VALUES ('2072',100172,'Bis 2072')\g INSERT INTO Semester VALUES ('2072',344,'SS 2072')\g INSERT INTO Semester VALUES ('2072/2073',345,'WS 2072/2073')\g INSERT INTO Semester VALUES ('2073',50173,'Ab 2073')\g INSERT INTO Semester VALUES ('2073',100173,'Bis 2073')\g INSERT INTO Semester VALUES ('2073',346,'SS 2073')\g INSERT INTO Semester VALUES ('2073/2074',347,'WS 2073/2074')\g INSERT INTO Semester VALUES ('2074',50174,'Ab 2074')\g INSERT INTO Semester VALUES ('2074',100174,'Bis 2074')\g INSERT INTO Semester VALUES ('2074',348,'SS 2074')\g INSERT INTO Semester VALUES ('2074/2075',349,'WS 2074/2075')\g INSERT INTO Semester VALUES ('2075',50175,'Ab 2075')\g INSERT INTO Semester VALUES ('2075',100175,'Bis 2075')\g INSERT INTO Semester VALUES ('2075',350,'SS 2075')\g INSERT INTO Semester VALUES ('2075/2076',351,'WS 2075/2076')\g INSERT INTO Semester VALUES ('2076',50176,'Ab 2076')\g INSERT INTO Semester VALUES ('2076',100176,'Bis 2076')\g INSERT INTO Semester VALUES ('2076',352,'SS 2076')\g INSERT INTO Semester VALUES ('2076/2077',353,'WS 2076/2077')\g INSERT INTO Semester VALUES ('2077',50177,'Ab 2077')\g INSERT INTO Semester VALUES ('2077',100177,'Bis 2077')\g INSERT INTO Semester VALUES ('2077',354,'SS 2077')\g INSERT INTO Semester VALUES ('2077/2078',355,'WS 2077/2078')\g INSERT INTO Semester VALUES ('2078',50178,'Ab 2078')\g INSERT INTO Semester VALUES ('2078',100178,'Bis 2078')\g INSERT INTO Semester VALUES ('2078',356,'SS 2078')\g INSERT INTO Semester VALUES ('2078/2079',357,'WS 2078/2079')\g INSERT INTO Semester VALUES ('2079',50179,'Ab 2079')\g INSERT INTO Semester VALUES ('2079',100179,'Bis 2079')\g INSERT INTO Semester VALUES ('2079',358,'SS 2079')\g INSERT INTO Semester VALUES ('2079/2080',359,'WS 2079/2080')\g INSERT INTO Semester VALUES ('2080',50180,'Ab 2080')\g INSERT INTO Semester VALUES ('2080',100180,'Bis 2080')\g INSERT INTO Semester VALUES ('2080',360,'SS 2080')\g INSERT INTO Semester VALUES ('2080/2081',361,'WS 2080/2081')\g INSERT INTO Semester VALUES ('2081',50181,'Ab 2081')\g INSERT INTO Semester VALUES ('2081',100181,'Bis 2081')\g INSERT INTO Semester VALUES ('2081',362,'SS 2081')\g INSERT INTO Semester VALUES ('2081/2082',363,'WS 2081/2082')\g INSERT INTO Semester VALUES ('2082',50182,'Ab 2082')\g INSERT INTO Semester VALUES ('2082',100182,'Bis 2082')\g INSERT INTO Semester VALUES ('2082',364,'SS 2082')\g INSERT INTO Semester VALUES ('2082/2083',365,'WS 2082/2083')\g INSERT INTO Semester VALUES ('2083',50183,'Ab 2083')\g INSERT INTO Semester VALUES ('2083',100183,'Bis 2083')\g INSERT INTO Semester VALUES ('2083',366,'SS 2083')\g INSERT INTO Semester VALUES ('2083/2084',367,'WS 2083/2084')\g INSERT INTO Semester VALUES ('2084',50184,'Ab 2084')\g INSERT INTO Semester VALUES ('2084',100184,'Bis 2084')\g INSERT INTO Semester VALUES ('2084',368,'SS 2084')\g INSERT INTO Semester VALUES ('2084/2085',369,'WS 2084/2085')\g INSERT INTO Semester VALUES ('2085',50185,'Ab 2085')\g INSERT INTO Semester VALUES ('2085',100185,'Bis 2085')\g INSERT INTO Semester VALUES ('2085',370,'SS 2085')\g INSERT INTO Semester VALUES ('2085/2086',371,'WS 2085/2086')\g INSERT INTO Semester VALUES ('2086',50186,'Ab 2086')\g INSERT INTO Semester VALUES ('2086',100186,'Bis 2086')\g INSERT INTO Semester VALUES ('2086',372,'SS 2086')\g INSERT INTO Semester VALUES ('2086/2087',373,'WS 2086/2087')\g INSERT INTO Semester VALUES ('2087',50187,'Ab 2087')\g INSERT INTO Semester VALUES ('2087',100187,'Bis 2087')\g INSERT INTO Semester VALUES ('2087',374,'SS 2087')\g INSERT INTO Semester VALUES ('2087/2088',375,'WS 2087/2088')\g INSERT INTO Semester VALUES ('2088',50188,'Ab 2088')\g INSERT INTO Semester VALUES ('2088',100188,'Bis 2088')\g INSERT INTO Semester VALUES ('2088',376,'SS 2088')\g INSERT INTO Semester VALUES ('2088/2089',377,'WS 2088/2089')\g INSERT INTO Semester VALUES ('2106',50206,'Ab 2106')\g INSERT INTO Semester VALUES ('2106',100206,'Bis 2106')\g INSERT INTO Semester VALUES ('2106',412,'SS 2106')\g INSERT INTO Semester VALUES ('2106/2107',413,'WS 2106/2107')\g INSERT INTO Semester VALUES ('2107',50207,'Ab 2107')\g INSERT INTO Semester VALUES ('2107',100207,'Bis 2107')\g INSERT INTO Semester VALUES ('2107',414,'SS 2107')\g INSERT INTO Semester VALUES ('2107/2108',415,'WS 2107/2108')\g INSERT INTO Semester VALUES ('1900',50000,'Ab 1900')\g INSERT INTO Semester VALUES ('1900',100000,'Bis 1900')\g INSERT INTO Semester VALUES ('1900',0,'SS 1900')\g INSERT INTO Semester VALUES ('1900/1901',1,'WS 1900/1901')\g INSERT INTO Semester VALUES ('1901',50001,'Ab 1901')\g INSERT INTO Semester VALUES ('1901',100001,'Bis 1901')\g INSERT INTO Semester VALUES ('1901',2,'SS 1901')\g INSERT INTO Semester VALUES ('1901/1902',3,'WS 1901/1902')\g INSERT INTO Semester VALUES ('1902',50002,'Ab 1902')\g INSERT INTO Semester VALUES ('1902',100002,'Bis 1902')\g INSERT INTO Semester VALUES ('1902',4,'SS 1902')\g INSERT INTO Semester VALUES ('1902/1903',5,'WS 1902/1903')\g INSERT INTO Semester VALUES ('1903',50003,'Ab 1903')\g INSERT INTO Semester VALUES ('1903',100003,'Bis 1903')\g INSERT INTO Semester VALUES ('1903',6,'SS 1903')\g INSERT INTO Semester VALUES ('1903/1904',7,'WS 1903/1904')\g INSERT INTO Semester VALUES ('1904',50004,'Ab 1904')\g INSERT INTO Semester VALUES ('1904',100004,'Bis 1904')\g INSERT INTO Semester VALUES ('1904',8,'SS 1904')\g INSERT INTO Semester VALUES ('1904/1905',9,'WS 1904/1905')\g INSERT INTO Semester VALUES ('1905',50005,'Ab 1905')\g INSERT INTO Semester VALUES ('1905',100005,'Bis 1905')\g INSERT INTO Semester VALUES ('1905',10,'SS 1905')\g INSERT INTO Semester VALUES ('1905/1906',11,'WS 1905/1906')\g INSERT INTO Semester VALUES ('1906',50006,'Ab 1906')\g INSERT INTO Semester VALUES ('1906',100006,'Bis 1906')\g INSERT INTO Semester VALUES ('1906',12,'SS 1906')\g INSERT INTO Semester VALUES ('1906/1907',13,'WS 1906/1907')\g INSERT INTO Semester VALUES ('1907',50007,'Ab 1907')\g INSERT INTO Semester VALUES ('1907',100007,'Bis 1907')\g INSERT INTO Semester VALUES ('1907',14,'SS 1907')\g INSERT INTO Semester VALUES ('1907/1908',15,'WS 1907/1908')\g INSERT INTO Semester VALUES ('1908',50008,'Ab 1908')\g INSERT INTO Semester VALUES ('1908',100008,'Bis 1908')\g INSERT INTO Semester VALUES ('1908',16,'SS 1908')\g INSERT INTO Semester VALUES ('1908/1909',17,'WS 1908/1909')\g INSERT INTO Semester VALUES ('1909',50009,'Ab 1909')\g INSERT INTO Semester VALUES ('1909',100009,'Bis 1909')\g INSERT INTO Semester VALUES ('1909',18,'SS 1909')\g INSERT INTO Semester VALUES ('1909/1910',19,'WS 1909/1910')\g INSERT INTO Semester VALUES ('1910',50010,'Ab 1910')\g INSERT INTO Semester VALUES ('1910',100010,'Bis 1910')\g INSERT INTO Semester VALUES ('1910',20,'SS 1910')\g INSERT INTO Semester VALUES ('1910/1911',21,'WS 1910/1911')\g INSERT INTO Semester VALUES ('1911',50011,'Ab 1911')\g INSERT INTO Semester VALUES ('1911',100011,'Bis 1911')\g INSERT INTO Semester VALUES ('1911',22,'SS 1911')\g INSERT INTO Semester VALUES ('1911/1912',23,'WS 1911/1912')\g INSERT INTO Semester VALUES ('1912',50012,'Ab 1912')\g INSERT INTO Semester VALUES ('1912',100012,'Bis 1912')\g INSERT INTO Semester VALUES ('1912',24,'SS 1912')\g INSERT INTO Semester VALUES ('1912/1913',25,'WS 1912/1913')\g INSERT INTO Semester VALUES ('1913',50013,'Ab 1913')\g INSERT INTO Semester VALUES ('1913',100013,'Bis 1913')\g INSERT INTO Semester VALUES ('1913',26,'SS 1913')\g INSERT INTO Semester VALUES ('1913/1914',27,'WS 1913/1914')\g INSERT INTO Semester VALUES ('1914',50014,'Ab 1914')\g INSERT INTO Semester VALUES ('1914',100014,'Bis 1914')\g INSERT INTO Semester VALUES ('1914',28,'SS 1914')\g INSERT INTO Semester VALUES ('1914/1915',29,'WS 1914/1915')\g INSERT INTO Semester VALUES ('2004',50104,'Ab 2004')\g INSERT INTO Semester VALUES ('2004',100104,'Bis 2004')\g INSERT INTO Semester VALUES ('2004',208,'SS 2004')\g INSERT INTO Semester VALUES ('2004/2005',209,'WS 2004/2005')\g INSERT INTO Semester VALUES ('2005',50105,'Ab 2005')\g INSERT INTO Semester VALUES ('2005',100105,'Bis 2005')\g INSERT INTO Semester VALUES ('2005',210,'SS 2005')\g INSERT INTO Semester VALUES ('2005/2006',211,'WS 2005/2006')\g INSERT INTO Semester VALUES ('2006',50106,'Ab 2006')\g INSERT INTO Semester VALUES ('2006',100106,'Bis 2006')\g INSERT INTO Semester VALUES ('2006',212,'SS 2006')\g INSERT INTO Semester VALUES ('2006/2007',213,'WS 2006/2007')\g INSERT INTO Semester VALUES ('2007',50107,'Ab 2007')\g INSERT INTO Semester VALUES ('2007',100107,'Bis 2007')\g INSERT INTO Semester VALUES ('2007',214,'SS 2007')\g INSERT INTO Semester VALUES ('2007/2008',215,'WS 2007/2008')\g INSERT INTO Semester VALUES ('2008',50108,'Ab 2008')\g INSERT INTO Semester VALUES ('2008',100108,'Bis 2008')\g INSERT INTO Semester VALUES ('2008',216,'SS 2008')\g INSERT INTO Semester VALUES ('2008/2009',217,'WS 2008/2009')\g INSERT INTO Semester VALUES ('2009',50109,'Ab 2009')\g INSERT INTO Semester VALUES ('2009',100109,'Bis 2009')\g INSERT INTO Semester VALUES ('2009',218,'SS 2009')\g INSERT INTO Semester VALUES ('2009/2010',219,'WS 2009/2010')\g INSERT INTO Semester VALUES ('2010',50110,'Ab 2010')\g INSERT INTO Semester VALUES ('2010',100110,'Bis 2010')\g INSERT INTO Semester VALUES ('2010',220,'SS 2010')\g INSERT INTO Semester VALUES ('2010/2011',221,'WS 2010/2011')\g INSERT INTO Semester VALUES ('2011',50111,'Ab 2011')\g INSERT INTO Semester VALUES ('2011',100111,'Bis 2011')\g INSERT INTO Semester VALUES ('2011',222,'SS 2011')\g INSERT INTO Semester VALUES ('2011/2012',223,'WS 2011/2012')\g INSERT INTO Semester VALUES ('2012',50112,'Ab 2012')\g INSERT INTO Semester VALUES ('2012',100112,'Bis 2012')\g INSERT INTO Semester VALUES ('2012',224,'SS 2012')\g INSERT INTO Semester VALUES ('2012/2013',225,'WS 2012/2013')\g INSERT INTO Semester VALUES ('2013',50113,'Ab 2013')\g INSERT INTO Semester VALUES ('2013',100113,'Bis 2013')\g INSERT INTO Semester VALUES ('2013',226,'SS 2013')\g INSERT INTO Semester VALUES ('2013/2014',227,'WS 2013/2014')\g INSERT INTO Semester VALUES ('2014',50114,'Ab 2014')\g INSERT INTO Semester VALUES ('2014',100114,'Bis 2014')\g INSERT INTO Semester VALUES ('2014',228,'SS 2014')\g INSERT INTO Semester VALUES ('2014/2015',229,'WS 2014/2015')\g INSERT INTO Semester VALUES ('2015',50115,'Ab 2015')\g INSERT INTO Semester VALUES ('2015',100115,'Bis 2015')\g INSERT INTO Semester VALUES ('2015',230,'SS 2015')\g INSERT INTO Semester VALUES ('2015/2016',231,'WS 2015/2016')\g INSERT INTO Semester VALUES ('2016',50116,'Ab 2016')\g INSERT INTO Semester VALUES ('2016',100116,'Bis 2016')\g INSERT INTO Semester VALUES ('2016',232,'SS 2016')\g INSERT INTO Semester VALUES ('2016/2017',233,'WS 2016/2017')\g INSERT INTO Semester VALUES ('2017',50117,'Ab 2017')\g INSERT INTO Semester VALUES ('2017',100117,'Bis 2017')\g INSERT INTO Semester VALUES ('2017',234,'SS 2017')\g INSERT INTO Semester VALUES ('2017/2018',235,'WS 2017/2018')\g INSERT INTO Semester VALUES ('2018',50118,'Ab 2018')\g INSERT INTO Semester VALUES ('2018',100118,'Bis 2018')\g INSERT INTO Semester VALUES ('2018',236,'SS 2018')\g INSERT INTO Semester VALUES ('2018/2019',237,'WS 2018/2019')\g INSERT INTO Semester VALUES ('2019',50119,'Ab 2019')\g INSERT INTO Semester VALUES ('2019',100119,'Bis 2019')\g INSERT INTO Semester VALUES ('2019',238,'SS 2019')\g INSERT INTO Semester VALUES ('2019/2020',239,'WS 2019/2020')\g INSERT INTO Semester VALUES ('2020',50120,'Ab 2020')\g INSERT INTO Semester VALUES ('2020',100120,'Bis 2020')\g INSERT INTO Semester VALUES ('2020',240,'SS 2020')\g INSERT INTO Semester VALUES ('2020/2021',241,'WS 2020/2021')\g INSERT INTO Semester VALUES ('2055',50155,'Ab 2055')\g INSERT INTO Semester VALUES ('2055',100155,'Bis 2055')\g INSERT INTO Semester VALUES ('2055',310,'SS 2055')\g INSERT INTO Semester VALUES ('2055/2056',311,'WS 2055/2056')\g INSERT INTO Semester VALUES ('2056',50156,'Ab 2056')\g INSERT INTO Semester VALUES ('2056',100156,'Bis 2056')\g INSERT INTO Semester VALUES ('2056',312,'SS 2056')\g INSERT INTO Semester VALUES ('2056/2057',313,'WS 2056/2057')\g INSERT INTO Semester VALUES ('2057',50157,'Ab 2057')\g INSERT INTO Semester VALUES ('2057',100157,'Bis 2057')\g INSERT INTO Semester VALUES ('2057',314,'SS 2057')\g INSERT INTO Semester VALUES ('2057/2058',315,'WS 2057/2058')\g INSERT INTO Semester VALUES ('2058',50158,'Ab 2058')\g INSERT INTO Semester VALUES ('2058',100158,'Bis 2058')\g INSERT INTO Semester VALUES ('2058',316,'SS 2058')\g INSERT INTO Semester VALUES ('2058/2059',317,'WS 2058/2059')\g INSERT INTO Semester VALUES ('2059',50159,'Ab 2059')\g INSERT INTO Semester VALUES ('2059',100159,'Bis 2059')\g INSERT INTO Semester VALUES ('2059',318,'SS 2059')\g INSERT INTO Semester VALUES ('2059/2060',319,'WS 2059/2060')\g INSERT INTO Semester VALUES ('2060',50160,'Ab 2060')\g INSERT INTO Semester VALUES ('2060',100160,'Bis 2060')\g INSERT INTO Semester VALUES ('2060',320,'SS 2060')\g INSERT INTO Semester VALUES ('2060/2061',321,'WS 2060/2061')\g INSERT INTO Semester VALUES ('2061',50161,'Ab 2061')\g INSERT INTO Semester VALUES ('2061',100161,'Bis 2061')\g INSERT INTO Semester VALUES ('2061',322,'SS 2061')\g INSERT INTO Semester VALUES ('2061/2062',323,'WS 2061/2062')\g INSERT INTO Semester VALUES ('2062',50162,'Ab 2062')\g INSERT INTO Semester VALUES ('2062',100162,'Bis 2062')\g INSERT INTO Semester VALUES ('2062',324,'SS 2062')\g INSERT INTO Semester VALUES ('2062/2063',325,'WS 2062/2063')\g INSERT INTO Semester VALUES ('2063',50163,'Ab 2063')\g INSERT INTO Semester VALUES ('2063',100163,'Bis 2063')\g INSERT INTO Semester VALUES ('2063',326,'SS 2063')\g INSERT INTO Semester VALUES ('2063/2064',327,'WS 2063/2064')\g INSERT INTO Semester VALUES ('2064',50164,'Ab 2064')\g INSERT INTO Semester VALUES ('2064',100164,'Bis 2064')\g INSERT INTO Semester VALUES ('2064',328,'SS 2064')\g INSERT INTO Semester VALUES ('2064/2065',329,'WS 2064/2065')\g INSERT INTO Semester VALUES ('2065',50165,'Ab 2065')\g INSERT INTO Semester VALUES ('2065',100165,'Bis 2065')\g INSERT INTO Semester VALUES ('2065',330,'SS 2065')\g INSERT INTO Semester VALUES ('2065/2066',331,'WS 2065/2066')\g INSERT INTO Semester VALUES ('2066',50166,'Ab 2066')\g INSERT INTO Semester VALUES ('2066',100166,'Bis 2066')\g INSERT INTO Semester VALUES ('2066',332,'SS 2066')\g INSERT INTO Semester VALUES ('2066/2067',333,'WS 2066/2067')\g INSERT INTO Semester VALUES ('2067',50167,'Ab 2067')\g INSERT INTO Semester VALUES ('2067',100167,'Bis 2067')\g INSERT INTO Semester VALUES ('2067',334,'SS 2067')\g INSERT INTO Semester VALUES ('2067/2068',335,'WS 2067/2068')\g INSERT INTO Semester VALUES ('2068',50168,'Ab 2068')\g INSERT INTO Semester VALUES ('2068',100168,'Bis 2068')\g INSERT INTO Semester VALUES ('2068',336,'SS 2068')\g INSERT INTO Semester VALUES ('2068/2069',337,'WS 2068/2069')\g INSERT INTO Semester VALUES ('2069',50169,'Ab 2069')\g INSERT INTO Semester VALUES ('2069',100169,'Bis 2069')\g INSERT INTO Semester VALUES ('2069',338,'SS 2069')\g INSERT INTO Semester VALUES ('2069/2070',339,'WS 2069/2070')\g INSERT INTO Semester VALUES ('2070',50170,'Ab 2070')\g INSERT INTO Semester VALUES ('2070',100170,'Bis 2070')\g INSERT INTO Semester VALUES ('2070',340,'SS 2070')\g INSERT INTO Semester VALUES ('2070/2071',341,'WS 2070/2071')\g INSERT INTO Semester VALUES ('2071',50171,'Ab 2071')\g INSERT INTO Semester VALUES ('2071',100171,'Bis 2071')\g INSERT INTO Semester VALUES ('2071',342,'SS 2071')\g INSERT INTO Semester VALUES ('2071/2072',343,'WS 2071/2072')\g INSERT INTO Semester VALUES ('2089',50189,'Ab 2089')\g INSERT INTO Semester VALUES ('2089',100189,'Bis 2089')\g INSERT INTO Semester VALUES ('2089',378,'SS 2089')\g INSERT INTO Semester VALUES ('2089/2090',379,'WS 2089/2090')\g INSERT INTO Semester VALUES ('2090',50190,'Ab 2090')\g INSERT INTO Semester VALUES ('2090',100190,'Bis 2090')\g INSERT INTO Semester VALUES ('2090',380,'SS 2090')\g INSERT INTO Semester VALUES ('2090/2091',381,'WS 2090/2091')\g INSERT INTO Semester VALUES ('2091',50191,'Ab 2091')\g INSERT INTO Semester VALUES ('2091',100191,'Bis 2091')\g INSERT INTO Semester VALUES ('2091',382,'SS 2091')\g INSERT INTO Semester VALUES ('2091/2092',383,'WS 2091/2092')\g INSERT INTO Semester VALUES ('2092',50192,'Ab 2092')\g INSERT INTO Semester VALUES ('2092',100192,'Bis 2092')\g INSERT INTO Semester VALUES ('2092',384,'SS 2092')\g INSERT INTO Semester VALUES ('2092/2093',385,'WS 2092/2093')\g INSERT INTO Semester VALUES ('2093',50193,'Ab 2093')\g INSERT INTO Semester VALUES ('2093',100193,'Bis 2093')\g INSERT INTO Semester VALUES ('2093',386,'SS 2093')\g INSERT INTO Semester VALUES ('2093/2094',387,'WS 2093/2094')\g INSERT INTO Semester VALUES ('2094',50194,'Ab 2094')\g INSERT INTO Semester VALUES ('2094',100194,'Bis 2094')\g INSERT INTO Semester VALUES ('2094',388,'SS 2094')\g INSERT INTO Semester VALUES ('2094/2095',389,'WS 2094/2095')\g INSERT INTO Semester VALUES ('2095',50195,'Ab 2095')\g INSERT INTO Semester VALUES ('2095',100195,'Bis 2095')\g INSERT INTO Semester VALUES ('2095',390,'SS 2095')\g INSERT INTO Semester VALUES ('2095/2096',391,'WS 2095/2096')\g INSERT INTO Semester VALUES ('2096',50196,'Ab 2096')\g INSERT INTO Semester VALUES ('2096',100196,'Bis 2096')\g INSERT INTO Semester VALUES ('2096',392,'SS 2096')\g INSERT INTO Semester VALUES ('2096/2097',393,'WS 2096/2097')\g INSERT INTO Semester VALUES ('2097',50197,'Ab 2097')\g INSERT INTO Semester VALUES ('2097',100197,'Bis 2097')\g INSERT INTO Semester VALUES ('2097',394,'SS 2097')\g INSERT INTO Semester VALUES ('2097/2098',395,'WS 2097/2098')\g INSERT INTO Semester VALUES ('2098',50198,'Ab 2098')\g INSERT INTO Semester VALUES ('2098',100198,'Bis 2098')\g INSERT INTO Semester VALUES ('2098',396,'SS 2098')\g INSERT INTO Semester VALUES ('2098/2099',397,'WS 2098/2099')\g INSERT INTO Semester VALUES ('2099',50199,'Ab 2099')\g INSERT INTO Semester VALUES ('2099',100199,'Bis 2099')\g INSERT INTO Semester VALUES ('2099',398,'SS 2099')\g INSERT INTO Semester VALUES ('2099/2100',399,'WS 2099/2100')\g INSERT INTO Semester VALUES ('2100',50200,'Ab 2100')\g INSERT INTO Semester VALUES ('2100',100200,'Bis 2100')\g INSERT INTO Semester VALUES ('2100',400,'SS 2100')\g INSERT INTO Semester VALUES ('2100/2101',401,'WS 2100/2101')\g INSERT INTO Semester VALUES ('2101',50201,'Ab 2101')\g INSERT INTO Semester VALUES ('2101',100201,'Bis 2101')\g INSERT INTO Semester VALUES ('2101',402,'SS 2101')\g INSERT INTO Semester VALUES ('2101/2102',403,'WS 2101/2102')\g INSERT INTO Semester VALUES ('2102',50202,'Ab 2102')\g INSERT INTO Semester VALUES ('2102',100202,'Bis 2102')\g INSERT INTO Semester VALUES ('2102',404,'SS 2102')\g INSERT INTO Semester VALUES ('2102/2103',405,'WS 2102/2103')\g INSERT INTO Semester VALUES ('2103',50203,'Ab 2103')\g INSERT INTO Semester VALUES ('2103',100203,'Bis 2103')\g INSERT INTO Semester VALUES ('2103',406,'SS 2103')\g INSERT INTO Semester VALUES ('2103/2104',407,'WS 2103/2104')\g INSERT INTO Semester VALUES ('2104',50204,'Ab 2104')\g INSERT INTO Semester VALUES ('2104',100204,'Bis 2104')\g INSERT INTO Semester VALUES ('2104',408,'SS 2104')\g INSERT INTO Semester VALUES ('2104/2105',409,'WS 2104/2105')\g INSERT INTO Semester VALUES ('2105',50205,'Ab 2105')\g INSERT INTO Semester VALUES ('2105',100205,'Bis 2105')\g INSERT INTO Semester VALUES ('2105',410,'SS 2105')\g INSERT INTO Semester VALUES ('2105/2106',411,'WS 2105/2106')\g INSERT INTO Semester VALUES ('2021',50121,'Ab 2021')\g INSERT INTO Semester VALUES ('2021',100121,'Bis 2021')\g INSERT INTO Semester VALUES ('2021',242,'SS 2021')\g INSERT INTO Semester VALUES ('2021/2022',243,'WS 2021/2022')\g INSERT INTO Semester VALUES ('2022',50122,'Ab 2022')\g INSERT INTO Semester VALUES ('2022',100122,'Bis 2022')\g INSERT INTO Semester VALUES ('2022',244,'SS 2022')\g INSERT INTO Semester VALUES ('2022/2023',245,'WS 2022/2023')\g INSERT INTO Semester VALUES ('2023',50123,'Ab 2023')\g INSERT INTO Semester VALUES ('2023',100123,'Bis 2023')\g INSERT INTO Semester VALUES ('2023',246,'SS 2023')\g INSERT INTO Semester VALUES ('2023/2024',247,'WS 2023/2024')\g INSERT INTO Semester VALUES ('2024',50124,'Ab 2024')\g INSERT INTO Semester VALUES ('2024',100124,'Bis 2024')\g INSERT INTO Semester VALUES ('2024',248,'SS 2024')\g INSERT INTO Semester VALUES ('2024/2025',249,'WS 2024/2025')\g INSERT INTO Semester VALUES ('2025',50125,'Ab 2025')\g INSERT INTO Semester VALUES ('2025',100125,'Bis 2025')\g INSERT INTO Semester VALUES ('2025',250,'SS 2025')\g INSERT INTO Semester VALUES ('2025/2026',251,'WS 2025/2026')\g INSERT INTO Semester VALUES ('2026',50126,'Ab 2026')\g INSERT INTO Semester VALUES ('2026',100126,'Bis 2026')\g INSERT INTO Semester VALUES ('2026',252,'SS 2026')\g INSERT INTO Semester VALUES ('2026/2027',253,'WS 2026/2027')\g INSERT INTO Semester VALUES ('2027',50127,'Ab 2027')\g INSERT INTO Semester VALUES ('2027',100127,'Bis 2027')\g INSERT INTO Semester VALUES ('2027',254,'SS 2027')\g INSERT INTO Semester VALUES ('2027/2028',255,'WS 2027/2028')\g INSERT INTO Semester VALUES ('2028',50128,'Ab 2028')\g INSERT INTO Semester VALUES ('2028',100128,'Bis 2028')\g INSERT INTO Semester VALUES ('2028',256,'SS 2028')\g INSERT INTO Semester VALUES ('2028/2029',257,'WS 2028/2029')\g INSERT INTO Semester VALUES ('2029',50129,'Ab 2029')\g INSERT INTO Semester VALUES ('2029',100129,'Bis 2029')\g INSERT INTO Semester VALUES ('2029',258,'SS 2029')\g INSERT INTO Semester VALUES ('2029/2030',259,'WS 2029/2030')\g INSERT INTO Semester VALUES ('2030',50130,'Ab 2030')\g INSERT INTO Semester VALUES ('2030',100130,'Bis 2030')\g INSERT INTO Semester VALUES ('2030',260,'SS 2030')\g INSERT INTO Semester VALUES ('2030/2031',261,'WS 2030/2031')\g INSERT INTO Semester VALUES ('2031',50131,'Ab 2031')\g INSERT INTO Semester VALUES ('2031',100131,'Bis 2031')\g INSERT INTO Semester VALUES ('2031',262,'SS 2031')\g INSERT INTO Semester VALUES ('2031/2032',263,'WS 2031/2032')\g INSERT INTO Semester VALUES ('2032',50132,'Ab 2032')\g INSERT INTO Semester VALUES ('2032',100132,'Bis 2032')\g INSERT INTO Semester VALUES ('2032',264,'SS 2032')\g INSERT INTO Semester VALUES ('2032/2033',265,'WS 2032/2033')\g INSERT INTO Semester VALUES ('2033',50133,'Ab 2033')\g INSERT INTO Semester VALUES ('2033',100133,'Bis 2033')\g INSERT INTO Semester VALUES ('2033',266,'SS 2033')\g INSERT INTO Semester VALUES ('2033/2034',267,'WS 2033/2034')\g INSERT INTO Semester VALUES ('2034',50134,'Ab 2034')\g INSERT INTO Semester VALUES ('2034',100134,'Bis 2034')\g INSERT INTO Semester VALUES ('2034',268,'SS 2034')\g INSERT INTO Semester VALUES ('2034/2035',269,'WS 2034/2035')\g INSERT INTO Semester VALUES ('2035',50135,'Ab 2035')\g INSERT INTO Semester VALUES ('2035',100135,'Bis 2035')\g INSERT INTO Semester VALUES ('2035',270,'SS 2035')\g INSERT INTO Semester VALUES ('2035/2036',271,'WS 2035/2036')\g INSERT INTO Semester VALUES ('2036',50136,'Ab 2036')\g INSERT INTO Semester VALUES ('2036',100136,'Bis 2036')\g INSERT INTO Semester VALUES ('2036',272,'SS 2036')\g INSERT INTO Semester VALUES ('2036/2037',273,'WS 2036/2037')\g INSERT INTO Semester VALUES ('2037',50137,'Ab 2037')\g INSERT INTO Semester VALUES ('2037',100137,'Bis 2037')\g INSERT INTO Semester VALUES ('2037',274,'SS 2037')\g INSERT INTO Semester VALUES ('2037/2038',275,'WS 2037/2038')\g INSERT INTO Semester VALUES ('2038',50138,'Ab 2038')\g INSERT INTO Semester VALUES ('2038',100138,'Bis 2038')\g INSERT INTO Semester VALUES ('2038',276,'SS 2038')\g INSERT INTO Semester VALUES ('2038/2039',277,'WS 2038/2039')\g INSERT INTO Semester VALUES ('2039',50139,'Ab 2039')\g INSERT INTO Semester VALUES ('2039',100139,'Bis 2039')\g INSERT INTO Semester VALUES ('2039',278,'SS 2039')\g INSERT INTO Semester VALUES ('2039/2040',279,'WS 2039/2040')\g INSERT INTO Semester VALUES ('2040',50140,'Ab 2040')\g INSERT INTO Semester VALUES ('2040',100140,'Bis 2040')\g INSERT INTO Semester VALUES ('2040',280,'SS 2040')\g INSERT INTO Semester VALUES ('2040/2041',281,'WS 2040/2041')\g INSERT INTO Semester VALUES ('2041',50141,'Ab 2041')\g INSERT INTO Semester VALUES ('2041',100141,'Bis 2041')\g INSERT INTO Semester VALUES ('2041',282,'SS 2041')\g INSERT INTO Semester VALUES ('2041/2042',283,'WS 2041/2042')\g INSERT INTO Semester VALUES ('2042',50142,'Ab 2042')\g INSERT INTO Semester VALUES ('2042',100142,'Bis 2042')\g INSERT INTO Semester VALUES ('2042',284,'SS 2042')\g INSERT INTO Semester VALUES ('2042/2043',285,'WS 2042/2043')\g INSERT INTO Semester VALUES ('2043',50143,'Ab 2043')\g INSERT INTO Semester VALUES ('2043',100143,'Bis 2043')\g INSERT INTO Semester VALUES ('2043',286,'SS 2043')\g INSERT INTO Semester VALUES ('2043/2044',287,'WS 2043/2044')\g INSERT INTO Semester VALUES ('2044',50144,'Ab 2044')\g INSERT INTO Semester VALUES ('2044',100144,'Bis 2044')\g INSERT INTO Semester VALUES ('2044',288,'SS 2044')\g INSERT INTO Semester VALUES ('2044/2045',289,'WS 2044/2045')\g INSERT INTO Semester VALUES ('2045',50145,'Ab 2045')\g INSERT INTO Semester VALUES ('2045',100145,'Bis 2045')\g INSERT INTO Semester VALUES ('2045',290,'SS 2045')\g INSERT INTO Semester VALUES ('2045/2046',291,'WS 2045/2046')\g INSERT INTO Semester VALUES ('2046',50146,'Ab 2046')\g INSERT INTO Semester VALUES ('2046',100146,'Bis 2046')\g INSERT INTO Semester VALUES ('2046',292,'SS 2046')\g INSERT INTO Semester VALUES ('2046/2047',293,'WS 2046/2047')\g INSERT INTO Semester VALUES ('2047',50147,'Ab 2047')\g INSERT INTO Semester VALUES ('2047',100147,'Bis 2047')\g INSERT INTO Semester VALUES ('2047',294,'SS 2047')\g INSERT INTO Semester VALUES ('2047/2048',295,'WS 2047/2048')\g INSERT INTO Semester VALUES ('2048',50148,'Ab 2048')\g INSERT INTO Semester VALUES ('2048',100148,'Bis 2048')\g INSERT INTO Semester VALUES ('2048',296,'SS 2048')\g INSERT INTO Semester VALUES ('2048/2049',297,'WS 2048/2049')\g INSERT INTO Semester VALUES ('2049',50149,'Ab 2049')\g INSERT INTO Semester VALUES ('2049',100149,'Bis 2049')\g INSERT INTO Semester VALUES ('2049',298,'SS 2049')\g INSERT INTO Semester VALUES ('2049/2050',299,'WS 2049/2050')\g INSERT INTO Semester VALUES ('2050',50150,'Ab 2050')\g INSERT INTO Semester VALUES ('2050',100150,'Bis 2050')\g INSERT INTO Semester VALUES ('2050',300,'SS 2050')\g INSERT INTO Semester VALUES ('2050/2051',301,'WS 2050/2051')\g INSERT INTO Semester VALUES ('2051',50151,'Ab 2051')\g INSERT INTO Semester VALUES ('2051',100151,'Bis 2051')\g INSERT INTO Semester VALUES ('2051',302,'SS 2051')\g INSERT INTO Semester VALUES ('2051/2052',303,'WS 2051/2052')\g INSERT INTO Semester VALUES ('2052',50152,'Ab 2052')\g INSERT INTO Semester VALUES ('2052',100152,'Bis 2052')\g INSERT INTO Semester VALUES ('2052',304,'SS 2052')\g INSERT INTO Semester VALUES ('2052/2053',305,'WS 2052/2053')\g INSERT INTO Semester VALUES ('2053',50153,'Ab 2053')\g INSERT INTO Semester VALUES ('2053',100153,'Bis 2053')\g INSERT INTO Semester VALUES ('2053',306,'SS 2053')\g INSERT INTO Semester VALUES ('2053/2054',307,'WS 2053/2054')\g INSERT INTO Semester VALUES ('2054',50154,'Ab 2054')\g INSERT INTO Semester VALUES ('2054',100154,'Bis 2054')\g INSERT INTO Semester VALUES ('2054',308,'SS 2054')\g INSERT INTO Semester VALUES ('2054/2055',309,'WS 2054/2055')\g INSERT INTO Semester VALUES ('1915',50015,'Ab 1915')\g INSERT INTO Semester VALUES ('1915',100015,'Bis 1915')\g INSERT INTO Semester VALUES ('1915',30,'SS 1915')\g INSERT INTO Semester VALUES ('1915/1916',31,'WS 1915/1916')\g INSERT INTO Semester VALUES ('1916',50016,'Ab 1916')\g INSERT INTO Semester VALUES ('1916',100016,'Bis 1916')\g INSERT INTO Semester VALUES ('1916',32,'SS 1916')\g INSERT INTO Semester VALUES ('1916/1917',33,'WS 1916/1917')\g INSERT INTO Semester VALUES ('1917',50017,'Ab 1917')\g INSERT INTO Semester VALUES ('1917',100017,'Bis 1917')\g INSERT INTO Semester VALUES ('1917',34,'SS 1917')\g INSERT INTO Semester VALUES ('1917/1918',35,'WS 1917/1918')\g INSERT INTO Semester VALUES ('1918',50018,'Ab 1918')\g INSERT INTO Semester VALUES ('1918',100018,'Bis 1918')\g INSERT INTO Semester VALUES ('1918',36,'SS 1918')\g INSERT INTO Semester VALUES ('1918/1919',37,'WS 1918/1919')\g INSERT INTO Semester VALUES ('1919',50019,'Ab 1919')\g INSERT INTO Semester VALUES ('1919',100019,'Bis 1919')\g INSERT INTO Semester VALUES ('1919',38,'SS 1919')\g INSERT INTO Semester VALUES ('1919/1920',39,'WS 1919/1920')\g INSERT INTO Semester VALUES ('1920',50020,'Ab 1920')\g INSERT INTO Semester VALUES ('1920',100020,'Bis 1920')\g INSERT INTO Semester VALUES ('1920',40,'SS 1920')\g INSERT INTO Semester VALUES ('1920/1921',41,'WS 1920/1921')\g INSERT INTO Semester VALUES ('1921',50021,'Ab 1921')\g INSERT INTO Semester VALUES ('1921',100021,'Bis 1921')\g INSERT INTO Semester VALUES ('1921',42,'SS 1921')\g INSERT INTO Semester VALUES ('1921/1922',43,'WS 1921/1922')\g INSERT INTO Semester VALUES ('1922',50022,'Ab 1922')\g INSERT INTO Semester VALUES ('1922',100022,'Bis 1922')\g INSERT INTO Semester VALUES ('1922',44,'SS 1922')\g INSERT INTO Semester VALUES ('1922/1923',45,'WS 1922/1923')\g INSERT INTO Semester VALUES ('1923',50023,'Ab 1923')\g INSERT INTO Semester VALUES ('1923',100023,'Bis 1923')\g INSERT INTO Semester VALUES ('1923',46,'SS 1923')\g INSERT INTO Semester VALUES ('1923/1924',47,'WS 1923/1924')\g INSERT INTO Semester VALUES ('1924',50024,'Ab 1924')\g INSERT INTO Semester VALUES ('1924',100024,'Bis 1924')\g INSERT INTO Semester VALUES ('1924',48,'SS 1924')\g INSERT INTO Semester VALUES ('1924/1925',49,'WS 1924/1925')\g INSERT INTO Semester VALUES ('1925',50025,'Ab 1925')\g INSERT INTO Semester VALUES ('1925',100025,'Bis 1925')\g INSERT INTO Semester VALUES ('1925',50,'SS 1925')\g INSERT INTO Semester VALUES ('1925/1926',51,'WS 1925/1926')\g INSERT INTO Semester VALUES ('1926',50026,'Ab 1926')\g INSERT INTO Semester VALUES ('1926',100026,'Bis 1926')\g INSERT INTO Semester VALUES ('1926',52,'SS 1926')\g INSERT INTO Semester VALUES ('1926/1927',53,'WS 1926/1927')\g INSERT INTO Semester VALUES ('1927',50027,'Ab 1927')\g INSERT INTO Semester VALUES ('1927',100027,'Bis 1927')\g INSERT INTO Semester VALUES ('1927',54,'SS 1927')\g INSERT INTO Semester VALUES ('1927/1928',55,'WS 1927/1928')\g INSERT INTO Semester VALUES ('1928',50028,'Ab 1928')\g INSERT INTO Semester VALUES ('1928',100028,'Bis 1928')\g INSERT INTO Semester VALUES ('1928',56,'SS 1928')\g INSERT INTO Semester VALUES ('1928/1929',57,'WS 1928/1929')\g INSERT INTO Semester VALUES ('1929',50029,'Ab 1929')\g INSERT INTO Semester VALUES ('1929',100029,'Bis 1929')\g INSERT INTO Semester VALUES ('1929',58,'SS 1929')\g INSERT INTO Semester VALUES ('1929/1930',59,'WS 1929/1930')\g INSERT INTO Semester VALUES ('1930',50030,'Ab 1930')\g INSERT INTO Semester VALUES ('1930',100030,'Bis 1930')\g INSERT INTO Semester VALUES ('1930',60,'SS 1930')\g INSERT INTO Semester VALUES ('1930/1931',61,'WS 1930/1931')\g INSERT INTO Semester VALUES ('1931',50031,'Ab 1931')\g INSERT INTO Semester VALUES ('1931',100031,'Bis 1931')\g INSERT INTO Semester VALUES ('1931',62,'SS 1931')\g INSERT INTO Semester VALUES ('1931/1932',63,'WS 1931/1932')\g INSERT INTO Semester VALUES ('1932',50032,'Ab 1932')\g INSERT INTO Semester VALUES ('1932',100032,'Bis 1932')\g INSERT INTO Semester VALUES ('1932',64,'SS 1932')\g INSERT INTO Semester VALUES ('1932/1933',65,'WS 1932/1933')\g INSERT INTO Semester VALUES ('1933',50033,'Ab 1933')\g INSERT INTO Semester VALUES ('1933',100033,'Bis 1933')\g INSERT INTO Semester VALUES ('1933',66,'SS 1933')\g INSERT INTO Semester VALUES ('1933/1934',67,'WS 1933/1934')\g INSERT INTO Semester VALUES ('1934',50034,'Ab 1934')\g INSERT INTO Semester VALUES ('1934',100034,'Bis 1934')\g INSERT INTO Semester VALUES ('1934',68,'SS 1934')\g INSERT INTO Semester VALUES ('1934/1935',69,'WS 1934/1935')\g INSERT INTO Semester VALUES ('1935',50035,'Ab 1935')\g INSERT INTO Semester VALUES ('1935',100035,'Bis 1935')\g INSERT INTO Semester VALUES ('1935',70,'SS 1935')\g INSERT INTO Semester VALUES ('1935/1936',71,'WS 1935/1936')\g INSERT INTO Semester VALUES ('1936',50036,'Ab 1936')\g INSERT INTO Semester VALUES ('1936',100036,'Bis 1936')\g INSERT INTO Semester VALUES ('1936',72,'SS 1936')\g INSERT INTO Semester VALUES ('1936/1937',73,'WS 1936/1937')\g INSERT INTO Semester VALUES ('1937',50037,'Ab 1937')\g INSERT INTO Semester VALUES ('1937',100037,'Bis 1937')\g INSERT INTO Semester VALUES ('1937',74,'SS 1937')\g INSERT INTO Semester VALUES ('1937/1938',75,'WS 1937/1938')\g INSERT INTO Semester VALUES ('1938',50038,'Ab 1938')\g INSERT INTO Semester VALUES ('1938',100038,'Bis 1938')\g INSERT INTO Semester VALUES ('1938',76,'SS 1938')\g INSERT INTO Semester VALUES ('1938/1939',77,'WS 1938/1939')\g INSERT INTO Semester VALUES ('1939',50039,'Ab 1939')\g INSERT INTO Semester VALUES ('1939',100039,'Bis 1939')\g INSERT INTO Semester VALUES ('1939',78,'SS 1939')\g INSERT INTO Semester VALUES ('1939/1940',79,'WS 1939/1940')\g INSERT INTO Semester VALUES ('1940',50040,'Ab 1940')\g INSERT INTO Semester VALUES ('1940',100040,'Bis 1940')\g INSERT INTO Semester VALUES ('1940',80,'SS 1940')\g INSERT INTO Semester VALUES ('1940/1941',81,'WS 1940/1941')\g INSERT INTO Semester VALUES ('1941',50041,'Ab 1941')\g INSERT INTO Semester VALUES ('1941',100041,'Bis 1941')\g INSERT INTO Semester VALUES ('1941',82,'SS 1941')\g INSERT INTO Semester VALUES ('1941/1942',83,'WS 1941/1942')\g INSERT INTO Semester VALUES ('1942',50042,'Ab 1942')\g INSERT INTO Semester VALUES ('1942',100042,'Bis 1942')\g INSERT INTO Semester VALUES ('1942',84,'SS 1942')\g INSERT INTO Semester VALUES ('1942/1943',85,'WS 1942/1943')\g INSERT INTO Semester VALUES ('1943',50043,'Ab 1943')\g INSERT INTO Semester VALUES ('1943',100043,'Bis 1943')\g INSERT INTO Semester VALUES ('1943',86,'SS 1943')\g INSERT INTO Semester VALUES ('1943/1944',87,'WS 1943/1944')\g INSERT INTO Semester VALUES ('1944',50044,'Ab 1944')\g INSERT INTO Semester VALUES ('1944',100044,'Bis 1944')\g INSERT INTO Semester VALUES ('1944',88,'SS 1944')\g INSERT INTO Semester VALUES ('1944/1945',89,'WS 1944/1945')\g INSERT INTO Semester VALUES ('1945',50045,'Ab 1945')\g INSERT INTO Semester VALUES ('1945',100045,'Bis 1945')\g INSERT INTO Semester VALUES ('1945',90,'SS 1945')\g INSERT INTO Semester VALUES ('1945/1946',91,'WS 1945/1946')\g INSERT INTO Semester VALUES ('1946',50046,'Ab 1946')\g INSERT INTO Semester VALUES ('1946',100046,'Bis 1946')\g INSERT INTO Semester VALUES ('1946',92,'SS 1946')\g INSERT INTO Semester VALUES ('1946/1947',93,'WS 1946/1947')\g INSERT INTO Semester VALUES ('1947',50047,'Ab 1947')\g INSERT INTO Semester VALUES ('1947',100047,'Bis 1947')\g INSERT INTO Semester VALUES ('1947',94,'SS 1947')\g INSERT INTO Semester VALUES ('1947/1948',95,'WS 1947/1948')\g INSERT INTO Semester VALUES ('1948',50048,'Ab 1948')\g INSERT INTO Semester VALUES ('1948',100048,'Bis 1948')\g INSERT INTO Semester VALUES ('1948',96,'SS 1948')\g INSERT INTO Semester VALUES ('1948/1949',97,'WS 1948/1949')\g INSERT INTO Semester VALUES ('1949',50049,'Ab 1949')\g INSERT INTO Semester VALUES ('1949',100049,'Bis 1949')\g INSERT INTO Semester VALUES ('1949',98,'SS 1949')\g INSERT INTO Semester VALUES ('1949/1950',99,'WS 1949/1950')\g INSERT INTO Semester VALUES ('1950',50050,'Ab 1950')\g INSERT INTO Semester VALUES ('1950',100050,'Bis 1950')\g INSERT INTO Semester VALUES ('1950',100,'SS 1950')\g INSERT INTO Semester VALUES ('1950/1951',101,'WS 1950/1951')\g INSERT INTO Semester VALUES ('1951',50051,'Ab 1951')\g INSERT INTO Semester VALUES ('1951',100051,'Bis 1951')\g INSERT INTO Semester VALUES ('1951',102,'SS 1951')\g INSERT INTO Semester VALUES ('1951/1952',103,'WS 1951/1952')\g INSERT INTO Semester VALUES ('1952',50052,'Ab 1952')\g INSERT INTO Semester VALUES ('1952',100052,'Bis 1952')\g INSERT INTO Semester VALUES ('1952',104,'SS 1952')\g INSERT INTO Semester VALUES ('1952/1953',105,'WS 1952/1953')\g INSERT INTO Semester VALUES ('1953',50053,'Ab 1953')\g INSERT INTO Semester VALUES ('1953',100053,'Bis 1953')\g INSERT INTO Semester VALUES ('1953',106,'SS 1953')\g INSERT INTO Semester VALUES ('1953/1954',107,'WS 1953/1954')\g INSERT INTO Semester VALUES ('1954',50054,'Ab 1954')\g INSERT INTO Semester VALUES ('1954',100054,'Bis 1954')\g INSERT INTO Semester VALUES ('1954',108,'SS 1954')\g INSERT INTO Semester VALUES ('1954/1955',109,'WS 1954/1955')\g INSERT INTO Semester VALUES ('1955',50055,'Ab 1955')\g INSERT INTO Semester VALUES ('1955',100055,'Bis 1955')\g INSERT INTO Semester VALUES ('1955',110,'SS 1955')\g INSERT INTO Semester VALUES ('1955/1956',111,'WS 1955/1956')\g INSERT INTO Semester VALUES ('1956',50056,'Ab 1956')\g INSERT INTO Semester VALUES ('1956',100056,'Bis 1956')\g INSERT INTO Semester VALUES ('1956',112,'SS 1956')\g INSERT INTO Semester VALUES ('1956/1957',113,'WS 1956/1957')\g INSERT INTO Semester VALUES ('1957',50057,'Ab 1957')\g INSERT INTO Semester VALUES ('1957',100057,'Bis 1957')\g INSERT INTO Semester VALUES ('1957',114,'SS 1957')\g INSERT INTO Semester VALUES ('1957/1958',115,'WS 1957/1958')\g INSERT INTO Semester VALUES ('1958',50058,'Ab 1958')\g INSERT INTO Semester VALUES ('1958',100058,'Bis 1958')\g INSERT INTO Semester VALUES ('1958',116,'SS 1958')\g INSERT INTO Semester VALUES ('1958/1959',117,'WS 1958/1959')\g INSERT INTO Semester VALUES ('1959',50059,'Ab 1959')\g INSERT INTO Semester VALUES ('1959',100059,'Bis 1959')\g INSERT INTO Semester VALUES ('1959',118,'SS 1959')\g INSERT INTO Semester VALUES ('1959/1960',119,'WS 1959/1960')\g INSERT INTO Semester VALUES ('1960',50060,'Ab 1960')\g INSERT INTO Semester VALUES ('1960',100060,'Bis 1960')\g INSERT INTO Semester VALUES ('1960',120,'SS 1960')\g INSERT INTO Semester VALUES ('1960/1961',121,'WS 1960/1961')\g INSERT INTO Semester VALUES ('1961',50061,'Ab 1961')\g INSERT INTO Semester VALUES ('1961',100061,'Bis 1961')\g INSERT INTO Semester VALUES ('1961',122,'SS 1961')\g INSERT INTO Semester VALUES ('1961/1962',123,'WS 1961/1962')\g INSERT INTO Semester VALUES ('1962',50062,'Ab 1962')\g INSERT INTO Semester VALUES ('1962',100062,'Bis 1962')\g INSERT INTO Semester VALUES ('1962',124,'SS 1962')\g INSERT INTO Semester VALUES ('1962/1963',125,'WS 1962/1963')\g INSERT INTO Semester VALUES ('1963',50063,'Ab 1963')\g INSERT INTO Semester VALUES ('1963',100063,'Bis 1963')\g INSERT INTO Semester VALUES ('1963',126,'SS 1963')\g INSERT INTO Semester VALUES ('1963/1964',127,'WS 1963/1964')\g INSERT INTO Semester VALUES ('1964',50064,'Ab 1964')\g INSERT INTO Semester VALUES ('1964',100064,'Bis 1964')\g INSERT INTO Semester VALUES ('1964',128,'SS 1964')\g INSERT INTO Semester VALUES ('1964/1965',129,'WS 1964/1965')\g INSERT INTO Semester VALUES ('1965',50065,'Ab 1965')\g INSERT INTO Semester VALUES ('1965',100065,'Bis 1965')\g INSERT INTO Semester VALUES ('1965',130,'SS 1965')\g INSERT INTO Semester VALUES ('1965/1966',131,'WS 1965/1966')\g INSERT INTO Semester VALUES ('1966',50066,'Ab 1966')\g INSERT INTO Semester VALUES ('1966',100066,'Bis 1966')\g INSERT INTO Semester VALUES ('1966',132,'SS 1966')\g INSERT INTO Semester VALUES ('1966/1967',133,'WS 1966/1967')\g INSERT INTO Semester VALUES ('1967',50067,'Ab 1967')\g INSERT INTO Semester VALUES ('1967',100067,'Bis 1967')\g INSERT INTO Semester VALUES ('1967',134,'SS 1967')\g INSERT INTO Semester VALUES ('1967/1968',135,'WS 1967/1968')\g INSERT INTO Semester VALUES ('1968',50068,'Ab 1968')\g INSERT INTO Semester VALUES ('1968',100068,'Bis 1968')\g INSERT INTO Semester VALUES ('1968',136,'SS 1968')\g INSERT INTO Semester VALUES ('1968/1969',137,'WS 1968/1969')\g INSERT INTO Semester VALUES ('1969',50069,'Ab 1969')\g INSERT INTO Semester VALUES ('1969',100069,'Bis 1969')\g INSERT INTO Semester VALUES ('1969',138,'SS 1969')\g INSERT INTO Semester VALUES ('1969/1970',139,'WS 1969/1970')\g INSERT INTO Semester VALUES ('1970',50070,'Ab 1970')\g INSERT INTO Semester VALUES ('1970',100070,'Bis 1970')\g INSERT INTO Semester VALUES ('1970',140,'SS 1970')\g INSERT INTO Semester VALUES ('1970/1971',141,'WS 1970/1971')\g INSERT INTO Semester VALUES ('1971',50071,'Ab 1971')\g INSERT INTO Semester VALUES ('1971',100071,'Bis 1971')\g INSERT INTO Semester VALUES ('1971',142,'SS 1971')\g INSERT INTO Semester VALUES ('1971/1972',143,'WS 1971/1972')\g INSERT INTO Semester VALUES ('1972',50072,'Ab 1972')\g INSERT INTO Semester VALUES ('1972',100072,'Bis 1972')\g INSERT INTO Semester VALUES ('1972',144,'SS 1972')\g INSERT INTO Semester VALUES ('1972/1973',145,'WS 1972/1973')\g INSERT INTO Semester VALUES ('1973',50073,'Ab 1973')\g INSERT INTO Semester VALUES ('1973',100073,'Bis 1973')\g INSERT INTO Semester VALUES ('1973',146,'SS 1973')\g INSERT INTO Semester VALUES ('1973/1974',147,'WS 1973/1974')\g INSERT INTO Semester VALUES ('1974',50074,'Ab 1974')\g INSERT INTO Semester VALUES ('1974',100074,'Bis 1974')\g INSERT INTO Semester VALUES ('1974',148,'SS 1974')\g INSERT INTO Semester VALUES ('1974/1975',149,'WS 1974/1975')\g INSERT INTO Semester VALUES ('1975',50075,'Ab 1975')\g INSERT INTO Semester VALUES ('1975',100075,'Bis 1975')\g INSERT INTO Semester VALUES ('1975',150,'SS 1975')\g INSERT INTO Semester VALUES ('1975/1976',151,'WS 1975/1976')\g INSERT INTO Semester VALUES ('1976',50076,'Ab 1976')\g INSERT INTO Semester VALUES ('1976',100076,'Bis 1976')\g INSERT INTO Semester VALUES ('1976',152,'SS 1976')\g INSERT INTO Semester VALUES ('1976/1977',153,'WS 1976/1977')\g INSERT INTO Semester VALUES ('1977',50077,'Ab 1977')\g INSERT INTO Semester VALUES ('1977',100077,'Bis 1977')\g INSERT INTO Semester VALUES ('1977',154,'SS 1977')\g INSERT INTO Semester VALUES ('1977/1978',155,'WS 1977/1978')\g INSERT INTO Semester VALUES ('1978',50078,'Ab 1978')\g INSERT INTO Semester VALUES ('1978',100078,'Bis 1978')\g INSERT INTO Semester VALUES ('1978',156,'SS 1978')\g INSERT INTO Semester VALUES ('1978/1979',157,'WS 1978/1979')\g INSERT INTO Semester VALUES ('1979',50079,'Ab 1979')\g INSERT INTO Semester VALUES ('1979',100079,'Bis 1979')\g INSERT INTO Semester VALUES ('1979',158,'SS 1979')\g INSERT INTO Semester VALUES ('1979/1980',159,'WS 1979/1980')\g INSERT INTO Semester VALUES ('1980',50080,'Ab 1980')\g INSERT INTO Semester VALUES ('1980',100080,'Bis 1980')\g INSERT INTO Semester VALUES ('1980',160,'SS 1980')\g INSERT INTO Semester VALUES ('1980/1981',161,'WS 1980/1981')\g INSERT INTO Semester VALUES ('1981',50081,'Ab 1981')\g INSERT INTO Semester VALUES ('1981',100081,'Bis 1981')\g INSERT INTO Semester VALUES ('1981',162,'SS 1981')\g INSERT INTO Semester VALUES ('1981/1982',163,'WS 1981/1982')\g INSERT INTO Semester VALUES ('1982',50082,'Ab 1982')\g INSERT INTO Semester VALUES ('1982',100082,'Bis 1982')\g INSERT INTO Semester VALUES ('1982',164,'SS 1982')\g INSERT INTO Semester VALUES ('1982/1983',165,'WS 1982/1983')\g INSERT INTO Semester VALUES ('1983',50083,'Ab 1983')\g INSERT INTO Semester VALUES ('1983',100083,'Bis 1983')\g INSERT INTO Semester VALUES ('1983',166,'SS 1983')\g INSERT INTO Semester VALUES ('1983/1984',167,'WS 1983/1984')\g INSERT INTO Semester VALUES ('1984',50084,'Ab 1984')\g INSERT INTO Semester VALUES ('1984',100084,'Bis 1984')\g INSERT INTO Semester VALUES ('1984',168,'SS 1984')\g INSERT INTO Semester VALUES ('1984/1985',169,'WS 1984/1985')\g INSERT INTO Semester VALUES ('1985',50085,'Ab 1985')\g INSERT INTO Semester VALUES ('1985',100085,'Bis 1985')\g INSERT INTO Semester VALUES ('1985',170,'SS 1985')\g INSERT INTO Semester VALUES ('1985/1986',171,'WS 1985/1986')\g INSERT INTO Semester VALUES ('1986',50086,'Ab 1986')\g INSERT INTO Semester VALUES ('1986',100086,'Bis 1986')\g INSERT INTO Semester VALUES ('1986',172,'SS 1986')\g INSERT INTO Semester VALUES ('1986/1987',173,'WS 1986/1987')\g INSERT INTO Semester VALUES ('1987',50087,'Ab 1987')\g INSERT INTO Semester VALUES ('1987',100087,'Bis 1987')\g INSERT INTO Semester VALUES ('1987',174,'SS 1987')\g INSERT INTO Semester VALUES ('1987/1988',175,'WS 1987/1988')\g INSERT INTO Semester VALUES ('1988',50088,'Ab 1988')\g INSERT INTO Semester VALUES ('1988',100088,'Bis 1988')\g INSERT INTO Semester VALUES ('1988',176,'SS 1988')\g INSERT INTO Semester VALUES ('1988/1989',177,'WS 1988/1989')\g INSERT INTO Semester VALUES ('1989',50089,'Ab 1989')\g INSERT INTO Semester VALUES ('1989',100089,'Bis 1989')\g INSERT INTO Semester VALUES ('1989',178,'SS 1989')\g INSERT INTO Semester VALUES ('1989/1990',179,'WS 1989/1990')\g INSERT INTO Semester VALUES ('1990',50090,'Ab 1990')\g INSERT INTO Semester VALUES ('1990',100090,'Bis 1990')\g INSERT INTO Semester VALUES ('1990',180,'SS 1990')\g INSERT INTO Semester VALUES ('1990/1991',181,'WS 1990/1991')\g INSERT INTO Semester VALUES ('1991',50091,'Ab 1991')\g INSERT INTO Semester VALUES ('1991',100091,'Bis 1991')\g INSERT INTO Semester VALUES ('1991',182,'SS 1991')\g INSERT INTO Semester VALUES ('1991/1992',183,'WS 1991/1992')\g INSERT INTO Semester VALUES ('1992',50092,'Ab 1992')\g INSERT INTO Semester VALUES ('1992',100092,'Bis 1992')\g INSERT INTO Semester VALUES ('1992',184,'SS 1992')\g INSERT INTO Semester VALUES ('1992/1993',185,'WS 1992/1993')\g INSERT INTO Semester VALUES ('1993',50093,'Ab 1993')\g INSERT INTO Semester VALUES ('1993',100093,'Bis 1993')\g INSERT INTO Semester VALUES ('1993',186,'SS 1993')\g INSERT INTO Semester VALUES ('1993/1994',187,'WS 1993/1994')\g INSERT INTO Semester VALUES ('1994',50094,'Ab 1994')\g INSERT INTO Semester VALUES ('1994',100094,'Bis 1994')\g INSERT INTO Semester VALUES ('1994',188,'SS 1994')\g INSERT INTO Semester VALUES ('1994/1995',189,'WS 1994/1995')\g INSERT INTO Semester VALUES ('1995',50095,'Ab 1995')\g INSERT INTO Semester VALUES ('1995',100095,'Bis 1995')\g INSERT INTO Semester VALUES ('1995',190,'SS 1995')\g INSERT INTO Semester VALUES ('1995/1996',191,'WS 1995/1996')\g INSERT INTO Semester VALUES ('1996',50096,'Ab 1996')\g INSERT INTO Semester VALUES ('1996',100096,'Bis 1996')\g INSERT INTO Semester VALUES ('1996',192,'SS 1996')\g INSERT INTO Semester VALUES ('1996/1997',193,'WS 1996/1997')\g INSERT INTO Semester VALUES ('1997',50097,'Ab 1997')\g INSERT INTO Semester VALUES ('1997',100097,'Bis 1997')\g INSERT INTO Semester VALUES ('1997',194,'SS 1997')\g INSERT INTO Semester VALUES ('1997/1998',195,'WS 1997/1998')\g INSERT INTO Semester VALUES ('1998',50098,'Ab 1998')\g INSERT INTO Semester VALUES ('1998',100098,'Bis 1998')\g INSERT INTO Semester VALUES ('1998',196,'SS 1998')\g INSERT INTO Semester VALUES ('1998/1999',197,'WS 1998/1999')\g INSERT INTO Semester VALUES ('1999',50099,'Ab 1999')\g INSERT INTO Semester VALUES ('1999',100099,'Bis 1999')\g INSERT INTO Semester VALUES ('1999',198,'SS 1999')\g INSERT INTO Semester VALUES ('1999/2000',199,'WS 1999/2000')\g INSERT INTO Semester VALUES ('2000',50100,'Ab 2000')\g INSERT INTO Semester VALUES ('2000',100100,'Bis 2000')\g INSERT INTO Semester VALUES ('2000',200,'SS 2000')\g INSERT INTO Semester VALUES ('2000/2001',201,'WS 2000/2001')\g INSERT INTO Semester VALUES ('2001',50101,'Ab 2001')\g INSERT INTO Semester VALUES ('2001',100101,'Bis 2001')\g INSERT INTO Semester VALUES ('2001',202,'SS 2001')\g INSERT INTO Semester VALUES ('2001/2002',203,'WS 2001/2002')\g INSERT INTO Semester VALUES ('2002',50102,'Ab 2002')\g INSERT INTO Semester VALUES ('2002',100102,'Bis 2002')\g INSERT INTO Semester VALUES ('2002',204,'SS 2002')\g INSERT INTO Semester VALUES ('2002/2003',205,'WS 2002/2003')\g INSERT INTO Semester VALUES ('2003',50103,'Ab 2003')\g INSERT INTO Semester VALUES ('2003',100103,'Bis 2003')\g INSERT INTO Semester VALUES ('2003',206,'SS 2003')\g INSERT INTO Semester VALUES ('2003/2004',207,'WS 2003/2004')\g INSERT INTO Semester VALUES ('2108',50208,'Ab 2108')\g INSERT INTO Semester VALUES ('2108',100208,'Bis 2108')\g INSERT INTO Semester VALUES ('2108',416,'SS 2108')\g INSERT INTO Semester VALUES ('2108/2109',417,'WS 2108/2109')\g INSERT INTO Semester VALUES ('2109',50209,'Ab 2109')\g INSERT INTO Semester VALUES ('2109',100209,'Bis 2109')\g INSERT INTO Semester VALUES ('2109',418,'SS 2109')\g INSERT INTO Semester VALUES ('2109/2110',419,'WS 2109/2110')\g INSERT INTO Semester VALUES ('2110',50210,'Ab 2110')\g INSERT INTO Semester VALUES ('2110',100210,'Bis 2110')\g INSERT INTO Semester VALUES ('2110',420,'SS 2110')\g INSERT INTO Semester VALUES ('2110/2111',421,'WS 2110/2111')\g INSERT INTO Semester VALUES ('2111',50211,'Ab 2111')\g INSERT INTO Semester VALUES ('2111',100211,'Bis 2111')\g INSERT INTO Semester VALUES ('2111',422,'SS 2111')\g INSERT INTO Semester VALUES ('2111/2112',423,'WS 2111/2112')\g INSERT INTO Semester VALUES ('2112',50212,'Ab 2112')\g INSERT INTO Semester VALUES ('2112',100212,'Bis 2112')\g INSERT INTO Semester VALUES ('2112',424,'SS 2112')\g INSERT INTO Semester VALUES ('2112/2113',425,'WS 2112/2113')\g INSERT INTO Semester VALUES ('2113',50213,'Ab 2113')\g INSERT INTO Semester VALUES ('2113',100213,'Bis 2113')\g INSERT INTO Semester VALUES ('2113',426,'SS 2113')\g INSERT INTO Semester VALUES ('2113/2114',427,'WS 2113/2114')\g INSERT INTO Semester VALUES ('2114',50214,'Ab 2114')\g INSERT INTO Semester VALUES ('2114',100214,'Bis 2114')\g INSERT INTO Semester VALUES ('2114',428,'SS 2114')\g INSERT INTO Semester VALUES ('2114/2115',429,'WS 2114/2115')\g INSERT INTO Semester VALUES ('2115',50215,'Ab 2115')\g INSERT INTO Semester VALUES ('2115',100215,'Bis 2115')\g INSERT INTO Semester VALUES ('2115',430,'SS 2115')\g INSERT INTO Semester VALUES ('2115/2116',431,'WS 2115/2116')\g INSERT INTO Semester VALUES ('2116',50216,'Ab 2116')\g INSERT INTO Semester VALUES ('2116',100216,'Bis 2116')\g INSERT INTO Semester VALUES ('2116',432,'SS 2116')\g INSERT INTO Semester VALUES ('2116/2117',433,'WS 2116/2117')\g INSERT INTO Semester VALUES ('2117',50217,'Ab 2117')\g INSERT INTO Semester VALUES ('2117',100217,'Bis 2117')\g INSERT INTO Semester VALUES ('2117',434,'SS 2117')\g INSERT INTO Semester VALUES ('2117/2118',435,'WS 2117/2118')\g INSERT INTO Semester VALUES ('2118',50218,'Ab 2118')\g INSERT INTO Semester VALUES ('2118',100218,'Bis 2118')\g INSERT INTO Semester VALUES ('2118',436,'SS 2118')\g INSERT INTO Semester VALUES ('2118/2119',437,'WS 2118/2119')\g INSERT INTO Semester VALUES ('2119',50219,'Ab 2119')\g INSERT INTO Semester VALUES ('2119',100219,'Bis 2119')\g INSERT INTO Semester VALUES ('2119',438,'SS 2119')\g INSERT INTO Semester VALUES ('2119/2120',439,'WS 2119/2120')\g INSERT INTO Semester VALUES ('2120',50220,'Ab 2120')\g INSERT INTO Semester VALUES ('2120',100220,'Bis 2120')\g INSERT INTO Semester VALUES ('2120',440,'SS 2120')\g INSERT INTO Semester VALUES ('2120/2121',441,'WS 2120/2121')\g INSERT INTO Semester VALUES ('2121',50221,'Ab 2121')\g INSERT INTO Semester VALUES ('2121',100221,'Bis 2121')\g INSERT INTO Semester VALUES ('2121',442,'SS 2121')\g INSERT INTO Semester VALUES ('2121/2122',443,'WS 2121/2122')\g INSERT INTO Semester VALUES ('2122',50222,'Ab 2122')\g INSERT INTO Semester VALUES ('2122',100222,'Bis 2122')\g INSERT INTO Semester VALUES ('2122',444,'SS 2122')\g INSERT INTO Semester VALUES ('2122/2123',445,'WS 2122/2123')\g INSERT INTO Semester VALUES ('2123',50223,'Ab 2123')\g INSERT INTO Semester VALUES ('2123',100223,'Bis 2123')\g INSERT INTO Semester VALUES ('2123',446,'SS 2123')\g INSERT INTO Semester VALUES ('2123/2124',447,'WS 2123/2124')\g INSERT INTO Semester VALUES ('2124',50224,'Ab 2124')\g INSERT INTO Semester VALUES ('2124',100224,'Bis 2124')\g INSERT INTO Semester VALUES ('2124',448,'SS 2124')\g INSERT INTO Semester VALUES ('2124/2125',449,'WS 2124/2125')\g INSERT INTO Semester VALUES ('2125',50225,'Ab 2125')\g INSERT INTO Semester VALUES ('2125',100225,'Bis 2125')\g INSERT INTO Semester VALUES ('2125',450,'SS 2125')\g INSERT INTO Semester VALUES ('2125/2126',451,'WS 2125/2126')\g INSERT INTO Semester VALUES ('2126',50226,'Ab 2126')\g INSERT INTO Semester VALUES ('2126',100226,'Bis 2126')\g INSERT INTO Semester VALUES ('2126',452,'SS 2126')\g INSERT INTO Semester VALUES ('2126/2127',453,'WS 2126/2127')\g INSERT INTO Semester VALUES ('2127',50227,'Ab 2127')\g INSERT INTO Semester VALUES ('2127',100227,'Bis 2127')\g INSERT INTO Semester VALUES ('2127',454,'SS 2127')\g INSERT INTO Semester VALUES ('2127/2128',455,'WS 2127/2128')\g INSERT INTO Semester VALUES ('2128',50228,'Ab 2128')\g INSERT INTO Semester VALUES ('2128',100228,'Bis 2128')\g INSERT INTO Semester VALUES ('2128',456,'SS 2128')\g INSERT INTO Semester VALUES ('2128/2129',457,'WS 2128/2129')\g INSERT INTO Semester VALUES ('2129',50229,'Ab 2129')\g INSERT INTO Semester VALUES ('2129',100229,'Bis 2129')\g INSERT INTO Semester VALUES ('2129',458,'SS 2129')\g INSERT INTO Semester VALUES ('2129/2130',459,'WS 2129/2130')\g INSERT INTO Semester VALUES ('2130',50230,'Ab 2130')\g INSERT INTO Semester VALUES ('2130',100230,'Bis 2130')\g INSERT INTO Semester VALUES ('2130',460,'SS 2130')\g INSERT INTO Semester VALUES ('2130/2131',461,'WS 2130/2131')\g INSERT INTO Semester VALUES ('2131',50231,'Ab 2131')\g INSERT INTO Semester VALUES ('2131',100231,'Bis 2131')\g INSERT INTO Semester VALUES ('2131',462,'SS 2131')\g INSERT INTO Semester VALUES ('2131/2132',463,'WS 2131/2132')\g INSERT INTO Semester VALUES ('2132',50232,'Ab 2132')\g INSERT INTO Semester VALUES ('2132',100232,'Bis 2132')\g INSERT INTO Semester VALUES ('2132',464,'SS 2132')\g INSERT INTO Semester VALUES ('2132/2133',465,'WS 2132/2133')\g INSERT INTO Semester VALUES ('2133',50233,'Ab 2133')\g INSERT INTO Semester VALUES ('2133',100233,'Bis 2133')\g INSERT INTO Semester VALUES ('2133',466,'SS 2133')\g INSERT INTO Semester VALUES ('2133/2134',467,'WS 2133/2134')\g INSERT INTO Semester VALUES ('2134',50234,'Ab 2134')\g INSERT INTO Semester VALUES ('2134',100234,'Bis 2134')\g INSERT INTO Semester VALUES ('2134',468,'SS 2134')\g INSERT INTO Semester VALUES ('2134/2135',469,'WS 2134/2135')\g INSERT INTO Semester VALUES ('2135',50235,'Ab 2135')\g INSERT INTO Semester VALUES ('2135',100235,'Bis 2135')\g INSERT INTO Semester VALUES ('2135',470,'SS 2135')\g INSERT INTO Semester VALUES ('2135/2136',471,'WS 2135/2136')\g INSERT INTO Semester VALUES ('2136',50236,'Ab 2136')\g INSERT INTO Semester VALUES ('2136',100236,'Bis 2136')\g INSERT INTO Semester VALUES ('2136',472,'SS 2136')\g INSERT INTO Semester VALUES ('2136/2137',473,'WS 2136/2137')\g INSERT INTO Semester VALUES ('2137',50237,'Ab 2137')\g INSERT INTO Semester VALUES ('2137',100237,'Bis 2137')\g INSERT INTO Semester VALUES ('2137',474,'SS 2137')\g INSERT INTO Semester VALUES ('2137/2138',475,'WS 2137/2138')\g INSERT INTO Semester VALUES ('2138',50238,'Ab 2138')\g INSERT INTO Semester VALUES ('2138',100238,'Bis 2138')\g INSERT INTO Semester VALUES ('2138',476,'SS 2138')\g INSERT INTO Semester VALUES ('2138/2139',477,'WS 2138/2139')\g INSERT INTO Semester VALUES ('2139',50239,'Ab 2139')\g INSERT INTO Semester VALUES ('2139',100239,'Bis 2139')\g INSERT INTO Semester VALUES ('2139',478,'SS 2139')\g INSERT INTO Semester VALUES ('2139/2140',479,'WS 2139/2140')\g INSERT INTO Semester VALUES ('2140',50240,'Ab 2140')\g INSERT INTO Semester VALUES ('2140',100240,'Bis 2140')\g INSERT INTO Semester VALUES ('2140',480,'SS 2140')\g INSERT INTO Semester VALUES ('2140/2141',481,'WS 2140/2141')\g INSERT INTO Semester VALUES ('2141',50241,'Ab 2141')\g INSERT INTO Semester VALUES ('2141',100241,'Bis 2141')\g INSERT INTO Semester VALUES ('2141',482,'SS 2141')\g INSERT INTO Semester VALUES ('2141/2142',483,'WS 2141/2142')\g INSERT INTO Semester VALUES ('2142',50242,'Ab 2142')\g INSERT INTO Semester VALUES ('2142',100242,'Bis 2142')\g INSERT INTO Semester VALUES ('2142',484,'SS 2142')\g INSERT INTO Semester VALUES ('2142/2143',485,'WS 2142/2143')\g INSERT INTO Semester VALUES ('2143',50243,'Ab 2143')\g INSERT INTO Semester VALUES ('2143',100243,'Bis 2143')\g INSERT INTO Semester VALUES ('2143',486,'SS 2143')\g INSERT INTO Semester VALUES ('2143/2144',487,'WS 2143/2144')\g INSERT INTO Semester VALUES ('2144',50244,'Ab 2144')\g INSERT INTO Semester VALUES ('2144',100244,'Bis 2144')\g INSERT INTO Semester VALUES ('2144',488,'SS 2144')\g INSERT INTO Semester VALUES ('2144/2145',489,'WS 2144/2145')\g INSERT INTO Semester VALUES ('2145',50245,'Ab 2145')\g INSERT INTO Semester VALUES ('2145',100245,'Bis 2145')\g INSERT INTO Semester VALUES ('2145',490,'SS 2145')\g INSERT INTO Semester VALUES ('2145/2146',491,'WS 2145/2146')\g INSERT INTO Semester VALUES ('2146',50246,'Ab 2146')\g INSERT INTO Semester VALUES ('2146',100246,'Bis 2146')\g INSERT INTO Semester VALUES ('2146',492,'SS 2146')\g INSERT INTO Semester VALUES ('2146/2147',493,'WS 2146/2147')\g INSERT INTO Semester VALUES ('2147',50247,'Ab 2147')\g INSERT INTO Semester VALUES ('2147',100247,'Bis 2147')\g INSERT INTO Semester VALUES ('2147',494,'SS 2147')\g INSERT INTO Semester VALUES ('2147/2148',495,'WS 2147/2148')\g INSERT INTO Semester VALUES ('2148',50248,'Ab 2148')\g INSERT INTO Semester VALUES ('2148',100248,'Bis 2148')\g INSERT INTO Semester VALUES ('2148',496,'SS 2148')\g INSERT INTO Semester VALUES ('2148/2149',497,'WS 2148/2149')\g INSERT INTO Semester VALUES ('2149',50249,'Ab 2149')\g INSERT INTO Semester VALUES ('2149',100249,'Bis 2149')\g INSERT INTO Semester VALUES ('2149',498,'SS 2149')\g INSERT INTO Semester VALUES ('2149/2150',499,'WS 2149/2150')\g INSERT INTO Semester VALUES ('2150',50250,'Ab 2150')\g INSERT INTO Semester VALUES ('2150',100250,'Bis 2150')\g INSERT INTO Semester VALUES ('2150',500,'SS 2150')\g INSERT INTO Semester VALUES ('2150/2151',501,'WS 2150/2151')\g INSERT INTO Semester VALUES ('2151',50251,'Ab 2151')\g INSERT INTO Semester VALUES ('2151',100251,'Bis 2151')\g INSERT INTO Semester VALUES ('2151',502,'SS 2151')\g INSERT INTO Semester VALUES ('2151/2152',503,'WS 2151/2152')\g INSERT INTO Semester VALUES ('2152',50252,'Ab 2152')\g INSERT INTO Semester VALUES ('2152',100252,'Bis 2152')\g INSERT INTO Semester VALUES ('2152',504,'SS 2152')\g INSERT INTO Semester VALUES ('2152/2153',505,'WS 2152/2153')\g INSERT INTO Semester VALUES ('2153',50253,'Ab 2153')\g INSERT INTO Semester VALUES ('2153',100253,'Bis 2153')\g INSERT INTO Semester VALUES ('2153',506,'SS 2153')\g INSERT INTO Semester VALUES ('2153/2154',507,'WS 2153/2154')\g INSERT INTO Semester VALUES ('2154',50254,'Ab 2154')\g INSERT INTO Semester VALUES ('2154',100254,'Bis 2154')\g INSERT INTO Semester VALUES ('2154',508,'SS 2154')\g INSERT INTO Semester VALUES ('2154/2155',509,'WS 2154/2155')\g INSERT INTO Semester VALUES ('2155',50255,'Ab 2155')\g INSERT INTO Semester VALUES ('2155',100255,'Bis 2155')\g INSERT INTO Semester VALUES ('2155',510,'SS 2155')\g INSERT INTO Semester VALUES ('2155/2156',511,'WS 2155/2156')\g INSERT INTO Semester VALUES ('2156',50256,'Ab 2156')\g INSERT INTO Semester VALUES ('2156',100256,'Bis 2156')\g INSERT INTO Semester VALUES ('2156',512,'SS 2156')\g INSERT INTO Semester VALUES ('2156/2157',513,'WS 2156/2157')\g INSERT INTO Semester VALUES ('2157',50257,'Ab 2157')\g INSERT INTO Semester VALUES ('2157',100257,'Bis 2157')\g INSERT INTO Semester VALUES ('2157',514,'SS 2157')\g INSERT INTO Semester VALUES ('2157/2158',515,'WS 2157/2158')\g INSERT INTO Semester VALUES ('2158',50258,'Ab 2158')\g INSERT INTO Semester VALUES ('2158',100258,'Bis 2158')\g INSERT INTO Semester VALUES ('2158',516,'SS 2158')\g INSERT INTO Semester VALUES ('2158/2159',517,'WS 2158/2159')\g INSERT INTO Semester VALUES ('2159',50259,'Ab 2159')\g INSERT INTO Semester VALUES ('2159',100259,'Bis 2159')\g INSERT INTO Semester VALUES ('2159',518,'SS 2159')\g INSERT INTO Semester VALUES ('2159/2160',519,'WS 2159/2160')\g INSERT INTO Semester VALUES ('2160',50260,'Ab 2160')\g INSERT INTO Semester VALUES ('2160',100260,'Bis 2160')\g INSERT INTO Semester VALUES ('2160',520,'SS 2160')\g INSERT INTO Semester VALUES ('2160/2161',521,'WS 2160/2161')\g INSERT INTO Semester VALUES ('2161',50261,'Ab 2161')\g INSERT INTO Semester VALUES ('2161',100261,'Bis 2161')\g INSERT INTO Semester VALUES ('2161',522,'SS 2161')\g INSERT INTO Semester VALUES ('2161/2162',523,'WS 2161/2162')\g INSERT INTO Semester VALUES ('2162',50262,'Ab 2162')\g INSERT INTO Semester VALUES ('2162',100262,'Bis 2162')\g INSERT INTO Semester VALUES ('2162',524,'SS 2162')\g INSERT INTO Semester VALUES ('2162/2163',525,'WS 2162/2163')\g INSERT INTO Semester VALUES ('2163',50263,'Ab 2163')\g INSERT INTO Semester VALUES ('2163',100263,'Bis 2163')\g INSERT INTO Semester VALUES ('2163',526,'SS 2163')\g INSERT INTO Semester VALUES ('2163/2164',527,'WS 2163/2164')\g INSERT INTO Semester VALUES ('2164',50264,'Ab 2164')\g INSERT INTO Semester VALUES ('2164',100264,'Bis 2164')\g INSERT INTO Semester VALUES ('2164',528,'SS 2164')\g INSERT INTO Semester VALUES ('2164/2165',529,'WS 2164/2165')\g INSERT INTO Semester VALUES ('2165',50265,'Ab 2165')\g INSERT INTO Semester VALUES ('2165',100265,'Bis 2165')\g INSERT INTO Semester VALUES ('2165',530,'SS 2165')\g INSERT INTO Semester VALUES ('2165/2166',531,'WS 2165/2166')\g INSERT INTO Semester VALUES ('2166',50266,'Ab 2166')\g INSERT INTO Semester VALUES ('2166',100266,'Bis 2166')\g INSERT INTO Semester VALUES ('2166',532,'SS 2166')\g INSERT INTO Semester VALUES ('2166/2167',533,'WS 2166/2167')\g INSERT INTO Semester VALUES ('2167',50267,'Ab 2167')\g INSERT INTO Semester VALUES ('2167',100267,'Bis 2167')\g INSERT INTO Semester VALUES ('2167',534,'SS 2167')\g INSERT INTO Semester VALUES ('2167/2168',535,'WS 2167/2168')\g INSERT INTO Semester VALUES ('2168',50268,'Ab 2168')\g INSERT INTO Semester VALUES ('2168',100268,'Bis 2168')\g INSERT INTO Semester VALUES ('2168',536,'SS 2168')\g INSERT INTO Semester VALUES ('2168/2169',537,'WS 2168/2169')\g INSERT INTO Semester VALUES ('2169',50269,'Ab 2169')\g INSERT INTO Semester VALUES ('2169',100269,'Bis 2169')\g INSERT INTO Semester VALUES ('2169',538,'SS 2169')\g INSERT INTO Semester VALUES ('2169/2170',539,'WS 2169/2170')\g INSERT INTO Semester VALUES ('2170',50270,'Ab 2170')\g INSERT INTO Semester VALUES ('2170',100270,'Bis 2170')\g INSERT INTO Semester VALUES ('2170',540,'SS 2170')\g INSERT INTO Semester VALUES ('2170/2171',541,'WS 2170/2171')\g INSERT INTO Semester VALUES ('2171',50271,'Ab 2171')\g INSERT INTO Semester VALUES ('2171',100271,'Bis 2171')\g INSERT INTO Semester VALUES ('2171',542,'SS 2171')\g INSERT INTO Semester VALUES ('2171/2172',543,'WS 2171/2172')\g INSERT INTO Semester VALUES ('2172',50272,'Ab 2172')\g INSERT INTO Semester VALUES ('2172',100272,'Bis 2172')\g INSERT INTO Semester VALUES ('2172',544,'SS 2172')\g INSERT INTO Semester VALUES ('2172/2173',545,'WS 2172/2173')\g INSERT INTO Semester VALUES ('2173',50273,'Ab 2173')\g INSERT INTO Semester VALUES ('2173',100273,'Bis 2173')\g INSERT INTO Semester VALUES ('2173',546,'SS 2173')\g INSERT INTO Semester VALUES ('2173/2174',547,'WS 2173/2174')\g INSERT INTO Semester VALUES ('2174',50274,'Ab 2174')\g INSERT INTO Semester VALUES ('2174',100274,'Bis 2174')\g INSERT INTO Semester VALUES ('2174',548,'SS 2174')\g INSERT INTO Semester VALUES ('2174/2175',549,'WS 2174/2175')\g INSERT INTO Semester VALUES ('2175',50275,'Ab 2175')\g INSERT INTO Semester VALUES ('2175',100275,'Bis 2175')\g INSERT INTO Semester VALUES ('2175',550,'SS 2175')\g INSERT INTO Semester VALUES ('2175/2176',551,'WS 2175/2176')\g INSERT INTO Semester VALUES ('2176',50276,'Ab 2176')\g INSERT INTO Semester VALUES ('2176',100276,'Bis 2176')\g INSERT INTO Semester VALUES ('2176',552,'SS 2176')\g INSERT INTO Semester VALUES ('2176/2177',553,'WS 2176/2177')\g INSERT INTO Semester VALUES ('2177',50277,'Ab 2177')\g INSERT INTO Semester VALUES ('2177',100277,'Bis 2177')\g INSERT INTO Semester VALUES ('2177',554,'SS 2177')\g INSERT INTO Semester VALUES ('2177/2178',555,'WS 2177/2178')\g INSERT INTO Semester VALUES ('2178',50278,'Ab 2178')\g INSERT INTO Semester VALUES ('2178',100278,'Bis 2178')\g INSERT INTO Semester VALUES ('2178',556,'SS 2178')\g INSERT INTO Semester VALUES ('2178/2179',557,'WS 2178/2179')\g INSERT INTO Semester VALUES ('2179',50279,'Ab 2179')\g INSERT INTO Semester VALUES ('2179',100279,'Bis 2179')\g INSERT INTO Semester VALUES ('2179',558,'SS 2179')\g INSERT INTO Semester VALUES ('2179/2180',559,'WS 2179/2180')\g INSERT INTO Semester VALUES ('2180',50280,'Ab 2180')\g INSERT INTO Semester VALUES ('2180',100280,'Bis 2180')\g INSERT INTO Semester VALUES ('2180',560,'SS 2180')\g INSERT INTO Semester VALUES ('2180/2181',561,'WS 2180/2181')\g INSERT INTO Semester VALUES ('2181',50281,'Ab 2181')\g INSERT INTO Semester VALUES ('2181',100281,'Bis 2181')\g INSERT INTO Semester VALUES ('2181',562,'SS 2181')\g INSERT INTO Semester VALUES ('2181/2182',563,'WS 2181/2182')\g INSERT INTO Semester VALUES ('2182',50282,'Ab 2182')\g INSERT INTO Semester VALUES ('2182',100282,'Bis 2182')\g INSERT INTO Semester VALUES ('2182',564,'SS 2182')\g INSERT INTO Semester VALUES ('2182/2183',565,'WS 2182/2183')\g INSERT INTO Semester VALUES ('2183',50283,'Ab 2183')\g INSERT INTO Semester VALUES ('2183',100283,'Bis 2183')\g INSERT INTO Semester VALUES ('2183',566,'SS 2183')\g INSERT INTO Semester VALUES ('2183/2184',567,'WS 2183/2184')\g INSERT INTO Semester VALUES ('2184',50284,'Ab 2184')\g INSERT INTO Semester VALUES ('2184',100284,'Bis 2184')\g INSERT INTO Semester VALUES ('2184',568,'SS 2184')\g INSERT INTO Semester VALUES ('2184/2185',569,'WS 2184/2185')\g INSERT INTO Semester VALUES ('2185',50285,'Ab 2185')\g INSERT INTO Semester VALUES ('2185',100285,'Bis 2185')\g INSERT INTO Semester VALUES ('2185',570,'SS 2185')\g INSERT INTO Semester VALUES ('2185/2186',571,'WS 2185/2186')\g INSERT INTO Semester VALUES ('2186',50286,'Ab 2186')\g INSERT INTO Semester VALUES ('2186',100286,'Bis 2186')\g INSERT INTO Semester VALUES ('2186',572,'SS 2186')\g INSERT INTO Semester VALUES ('2186/2187',573,'WS 2186/2187')\g INSERT INTO Semester VALUES ('2187',50287,'Ab 2187')\g INSERT INTO Semester VALUES ('2187',100287,'Bis 2187')\g INSERT INTO Semester VALUES ('2187',574,'SS 2187')\g INSERT INTO Semester VALUES ('2187/2188',575,'WS 2187/2188')\g INSERT INTO Semester VALUES ('2188',50288,'Ab 2188')\g INSERT INTO Semester VALUES ('2188',100288,'Bis 2188')\g INSERT INTO Semester VALUES ('2188',576,'SS 2188')\g INSERT INTO Semester VALUES ('2188/2189',577,'WS 2188/2189')\g INSERT INTO Semester VALUES ('2189',50289,'Ab 2189')\g INSERT INTO Semester VALUES ('2189',100289,'Bis 2189')\g INSERT INTO Semester VALUES ('2189',578,'SS 2189')\g INSERT INTO Semester VALUES ('2189/2190',579,'WS 2189/2190')\g INSERT INTO Semester VALUES ('2190',50290,'Ab 2190')\g INSERT INTO Semester VALUES ('2190',100290,'Bis 2190')\g INSERT INTO Semester VALUES ('2190',580,'SS 2190')\g INSERT INTO Semester VALUES ('2190/2191',581,'WS 2190/2191')\g INSERT INTO Semester VALUES ('2191',50291,'Ab 2191')\g INSERT INTO Semester VALUES ('2191',100291,'Bis 2191')\g INSERT INTO Semester VALUES ('2191',582,'SS 2191')\g INSERT INTO Semester VALUES ('2191/2192',583,'WS 2191/2192')\g INSERT INTO Semester VALUES ('2192',50292,'Ab 2192')\g INSERT INTO Semester VALUES ('2192',100292,'Bis 2192')\g INSERT INTO Semester VALUES ('2192',584,'SS 2192')\g INSERT INTO Semester VALUES ('2192/2193',585,'WS 2192/2193')\g INSERT INTO Semester VALUES ('2193',50293,'Ab 2193')\g INSERT INTO Semester VALUES ('2193',100293,'Bis 2193')\g INSERT INTO Semester VALUES ('2193',586,'SS 2193')\g INSERT INTO Semester VALUES ('2193/2194',587,'WS 2193/2194')\g INSERT INTO Semester VALUES ('2194',50294,'Ab 2194')\g INSERT INTO Semester VALUES ('2194',100294,'Bis 2194')\g INSERT INTO Semester VALUES ('2194',588,'SS 2194')\g INSERT INTO Semester VALUES ('2194/2195',589,'WS 2194/2195')\g INSERT INTO Semester VALUES ('2195',50295,'Ab 2195')\g INSERT INTO Semester VALUES ('2195',100295,'Bis 2195')\g INSERT INTO Semester VALUES ('2195',590,'SS 2195')\g INSERT INTO Semester VALUES ('2195/2196',591,'WS 2195/2196')\g INSERT INTO Semester VALUES ('2196',50296,'Ab 2196')\g INSERT INTO Semester VALUES ('2196',100296,'Bis 2196')\g INSERT INTO Semester VALUES ('2196',592,'SS 2196')\g INSERT INTO Semester VALUES ('2196/2197',593,'WS 2196/2197')\g INSERT INTO Semester VALUES ('2197',50297,'Ab 2197')\g INSERT INTO Semester VALUES ('2197',100297,'Bis 2197')\g INSERT INTO Semester VALUES ('2197',594,'SS 2197')\g INSERT INTO Semester VALUES ('2197/2198',595,'WS 2197/2198')\g INSERT INTO Semester VALUES ('2198',50298,'Ab 2198')\g INSERT INTO Semester VALUES ('2198',100298,'Bis 2198')\g INSERT INTO Semester VALUES ('2198',596,'SS 2198')\g INSERT INTO Semester VALUES ('2198/2199',597,'WS 2198/2199')\g INSERT INTO Semester VALUES ('2199',50299,'Ab 2199')\g INSERT INTO Semester VALUES ('2199',100299,'Bis 2199')\g INSERT INTO Semester VALUES ('2199',598,'SS 2199')\g INSERT INTO Semester VALUES ('2199/2200',599,'WS 2199/2200')\g INSERT INTO Semester VALUES ('2200',50300,'Ab 2200')\g INSERT INTO Semester VALUES ('2200',100300,'Bis 2200')\g INSERT INTO Semester VALUES ('2200',600,'SS 2200')\g INSERT INTO Semester VALUES ('2200/2201',601,'WS 2200/2201')\g INSERT INTO Semester VALUES ('2201',50301,'Ab 2201')\g INSERT INTO Semester VALUES ('2201',100301,'Bis 2201')\g INSERT INTO Semester VALUES ('2201',602,'SS 2201')\g INSERT INTO Semester VALUES ('2201/2202',603,'WS 2201/2202')\g INSERT INTO Semester VALUES ('2202',50302,'Ab 2202')\g INSERT INTO Semester VALUES ('2202',100302,'Bis 2202')\g INSERT INTO Semester VALUES ('2202',604,'SS 2202')\g INSERT INTO Semester VALUES ('2202/2203',605,'WS 2202/2203')\g INSERT INTO Semester VALUES ('2203',50303,'Ab 2203')\g INSERT INTO Semester VALUES ('2203',100303,'Bis 2203')\g INSERT INTO Semester VALUES ('2203',606,'SS 2203')\g INSERT INTO Semester VALUES ('2203/2204',607,'WS 2203/2204')\g INSERT INTO Semester VALUES ('2204',50304,'Ab 2204')\g INSERT INTO Semester VALUES ('2204',100304,'Bis 2204')\g INSERT INTO Semester VALUES ('2204',608,'SS 2204')\g INSERT INTO Semester VALUES ('2204/2205',609,'WS 2204/2205')\g INSERT INTO Semester VALUES ('2205',50305,'Ab 2205')\g INSERT INTO Semester VALUES ('2205',100305,'Bis 2205')\g INSERT INTO Semester VALUES ('2205',610,'SS 2205')\g INSERT INTO Semester VALUES ('2205/2206',611,'WS 2205/2206')\g INSERT INTO Semester VALUES ('2206',50306,'Ab 2206')\g INSERT INTO Semester VALUES ('2206',100306,'Bis 2206')\g INSERT INTO Semester VALUES ('2206',612,'SS 2206')\g INSERT INTO Semester VALUES ('2206/2207',613,'WS 2206/2207')\g INSERT INTO Semester VALUES ('2207',50307,'Ab 2207')\g INSERT INTO Semester VALUES ('2207',100307,'Bis 2207')\g INSERT INTO Semester VALUES ('2207',614,'SS 2207')\g INSERT INTO Semester VALUES ('2207/2208',615,'WS 2207/2208')\g INSERT INTO Semester VALUES ('2208',50308,'Ab 2208')\g INSERT INTO Semester VALUES ('2208',100308,'Bis 2208')\g INSERT INTO Semester VALUES ('2208',616,'SS 2208')\g INSERT INTO Semester VALUES ('2208/2209',617,'WS 2208/2209')\g INSERT INTO Semester VALUES ('2209',50309,'Ab 2209')\g INSERT INTO Semester VALUES ('2209',100309,'Bis 2209')\g INSERT INTO Semester VALUES ('2209',618,'SS 2209')\g INSERT INTO Semester VALUES ('2209/2210',619,'WS 2209/2210')\g INSERT INTO Semester VALUES ('2210',50310,'Ab 2210')\g INSERT INTO Semester VALUES ('2210',100310,'Bis 2210')\g INSERT INTO Semester VALUES ('2210',620,'SS 2210')\g INSERT INTO Semester VALUES ('2210/2211',621,'WS 2210/2211')\g INSERT INTO Semester VALUES ('2211',50311,'Ab 2211')\g INSERT INTO Semester VALUES ('2211',100311,'Bis 2211')\g INSERT INTO Semester VALUES ('2211',622,'SS 2211')\g INSERT INTO Semester VALUES ('2211/2212',623,'WS 2211/2212')\g INSERT INTO Semester VALUES ('2212',50312,'Ab 2212')\g INSERT INTO Semester VALUES ('2212',100312,'Bis 2212')\g INSERT INTO Semester VALUES ('2212',624,'SS 2212')\g INSERT INTO Semester VALUES ('2212/2213',625,'WS 2212/2213')\g INSERT INTO Semester VALUES ('2213',50313,'Ab 2213')\g INSERT INTO Semester VALUES ('2213',100313,'Bis 2213')\g INSERT INTO Semester VALUES ('2213',626,'SS 2213')\g INSERT INTO Semester VALUES ('2213/2214',627,'WS 2213/2214')\g INSERT INTO Semester VALUES ('2214',50314,'Ab 2214')\g INSERT INTO Semester VALUES ('2214',100314,'Bis 2214')\g INSERT INTO Semester VALUES ('2214',628,'SS 2214')\g INSERT INTO Semester VALUES ('2214/2215',629,'WS 2214/2215')\g INSERT INTO Semester VALUES ('2215',50315,'Ab 2215')\g INSERT INTO Semester VALUES ('2215',100315,'Bis 2215')\g INSERT INTO Semester VALUES ('2215',630,'SS 2215')\g INSERT INTO Semester VALUES ('2215/2216',631,'WS 2215/2216')\g INSERT INTO Semester VALUES ('2216',50316,'Ab 2216')\g INSERT INTO Semester VALUES ('2216',100316,'Bis 2216')\g INSERT INTO Semester VALUES ('2216',632,'SS 2216')\g INSERT INTO Semester VALUES ('2216/2217',633,'WS 2216/2217')\g INSERT INTO Semester VALUES ('2217',50317,'Ab 2217')\g INSERT INTO Semester VALUES ('2217',100317,'Bis 2217')\g INSERT INTO Semester VALUES ('2217',634,'SS 2217')\g INSERT INTO Semester VALUES ('2217/2218',635,'WS 2217/2218')\g INSERT INTO Semester VALUES ('2218',50318,'Ab 2218')\g INSERT INTO Semester VALUES ('2218',100318,'Bis 2218')\g INSERT INTO Semester VALUES ('2218',636,'SS 2218')\g INSERT INTO Semester VALUES ('2218/2219',637,'WS 2218/2219')\g INSERT INTO Semester VALUES ('2219',50319,'Ab 2219')\g INSERT INTO Semester VALUES ('2219',100319,'Bis 2219')\g INSERT INTO Semester VALUES ('2219',638,'SS 2219')\g INSERT INTO Semester VALUES ('2219/2220',639,'WS 2219/2220')\g INSERT INTO Semester VALUES ('2220',50320,'Ab 2220')\g INSERT INTO Semester VALUES ('2220',100320,'Bis 2220')\g INSERT INTO Semester VALUES ('2220',640,'SS 2220')\g INSERT INTO Semester VALUES ('2220/2221',641,'WS 2220/2221')\g INSERT INTO Semester VALUES ('2221',50321,'Ab 2221')\g INSERT INTO Semester VALUES ('2221',100321,'Bis 2221')\g INSERT INTO Semester VALUES ('2221',642,'SS 2221')\g INSERT INTO Semester VALUES ('2221/2222',643,'WS 2221/2222')\g INSERT INTO Semester VALUES ('2222',50322,'Ab 2222')\g INSERT INTO Semester VALUES ('2222',100322,'Bis 2222')\g INSERT INTO Semester VALUES ('2222',644,'SS 2222')\g INSERT INTO Semester VALUES ('2222/2223',645,'WS 2222/2223')\g INSERT INTO Semester VALUES ('2223',50323,'Ab 2223')\g INSERT INTO Semester VALUES ('2223',100323,'Bis 2223')\g INSERT INTO Semester VALUES ('2223',646,'SS 2223')\g INSERT INTO Semester VALUES ('2223/2224',647,'WS 2223/2224')\g INSERT INTO Semester VALUES ('2224',50324,'Ab 2224')\g INSERT INTO Semester VALUES ('2224',100324,'Bis 2224')\g INSERT INTO Semester VALUES ('2224',648,'SS 2224')\g INSERT INTO Semester VALUES ('2224/2225',649,'WS 2224/2225')\g INSERT INTO Semester VALUES ('2225',50325,'Ab 2225')\g INSERT INTO Semester VALUES ('2225',100325,'Bis 2225')\g INSERT INTO Semester VALUES ('2225',650,'SS 2225')\g INSERT INTO Semester VALUES ('2225/2226',651,'WS 2225/2226')\g INSERT INTO Semester VALUES ('2226',50326,'Ab 2226')\g INSERT INTO Semester VALUES ('2226',100326,'Bis 2226')\g INSERT INTO Semester VALUES ('2226',652,'SS 2226')\g INSERT INTO Semester VALUES ('2226/2227',653,'WS 2226/2227')\g INSERT INTO Semester VALUES ('2227',50327,'Ab 2227')\g INSERT INTO Semester VALUES ('2227',100327,'Bis 2227')\g INSERT INTO Semester VALUES ('2227',654,'SS 2227')\g INSERT INTO Semester VALUES ('2227/2228',655,'WS 2227/2228')\g INSERT INTO Semester VALUES ('2228',50328,'Ab 2228')\g INSERT INTO Semester VALUES ('2228',100328,'Bis 2228')\g INSERT INTO Semester VALUES ('2228',656,'SS 2228')\g INSERT INTO Semester VALUES ('2228/2229',657,'WS 2228/2229')\g INSERT INTO Semester VALUES ('2229',50329,'Ab 2229')\g INSERT INTO Semester VALUES ('2229',100329,'Bis 2229')\g INSERT INTO Semester VALUES ('2229',658,'SS 2229')\g INSERT INTO Semester VALUES ('2229/2230',659,'WS 2229/2230')\g INSERT INTO Semester VALUES ('2230',50330,'Ab 2230')\g INSERT INTO Semester VALUES ('2230',100330,'Bis 2230')\g INSERT INTO Semester VALUES ('2230',660,'SS 2230')\g INSERT INTO Semester VALUES ('2230/2231',661,'WS 2230/2231')\g INSERT INTO Semester VALUES ('2231',50331,'Ab 2231')\g INSERT INTO Semester VALUES ('2231',100331,'Bis 2231')\g INSERT INTO Semester VALUES ('2231',662,'SS 2231')\g INSERT INTO Semester VALUES ('2231/2232',663,'WS 2231/2232')\g INSERT INTO Semester VALUES ('2232',50332,'Ab 2232')\g INSERT INTO Semester VALUES ('2232',100332,'Bis 2232')\g INSERT INTO Semester VALUES ('2232',664,'SS 2232')\g INSERT INTO Semester VALUES ('2232/2233',665,'WS 2232/2233')\g INSERT INTO Semester VALUES ('2233',50333,'Ab 2233')\g INSERT INTO Semester VALUES ('2233',100333,'Bis 2233')\g INSERT INTO Semester VALUES ('2233',666,'SS 2233')\g INSERT INTO Semester VALUES ('2233/2234',667,'WS 2233/2234')\g INSERT INTO Semester VALUES ('2234',50334,'Ab 2234')\g INSERT INTO Semester VALUES ('2234',100334,'Bis 2234')\g INSERT INTO Semester VALUES ('2234',668,'SS 2234')\g INSERT INTO Semester VALUES ('2234/2235',669,'WS 2234/2235')\g INSERT INTO Semester VALUES ('2235',50335,'Ab 2235')\g INSERT INTO Semester VALUES ('2235',100335,'Bis 2235')\g INSERT INTO Semester VALUES ('2235',670,'SS 2235')\g INSERT INTO Semester VALUES ('2235/2236',671,'WS 2235/2236')\g INSERT INTO Semester VALUES ('2236',50336,'Ab 2236')\g INSERT INTO Semester VALUES ('2236',100336,'Bis 2236')\g INSERT INTO Semester VALUES ('2236',672,'SS 2236')\g INSERT INTO Semester VALUES ('2236/2237',673,'WS 2236/2237')\g INSERT INTO Semester VALUES ('2237',50337,'Ab 2237')\g INSERT INTO Semester VALUES ('2237',100337,'Bis 2237')\g INSERT INTO Semester VALUES ('2237',674,'SS 2237')\g INSERT INTO Semester VALUES ('2237/2238',675,'WS 2237/2238')\g INSERT INTO Semester VALUES ('2238',50338,'Ab 2238')\g INSERT INTO Semester VALUES ('2238',100338,'Bis 2238')\g INSERT INTO Semester VALUES ('2238',676,'SS 2238')\g INSERT INTO Semester VALUES ('2238/2239',677,'WS 2238/2239')\g INSERT INTO Semester VALUES ('2239',50339,'Ab 2239')\g INSERT INTO Semester VALUES ('2239',100339,'Bis 2239')\g INSERT INTO Semester VALUES ('2239',678,'SS 2239')\g INSERT INTO Semester VALUES ('2239/2240',679,'WS 2239/2240')\g INSERT INTO Semester VALUES ('2240',50340,'Ab 2240')\g INSERT INTO Semester VALUES ('2240',100340,'Bis 2240')\g INSERT INTO Semester VALUES ('2240',680,'SS 2240')\g INSERT INTO Semester VALUES ('2240/2241',681,'WS 2240/2241')\g INSERT INTO Semester VALUES ('2241',50341,'Ab 2241')\g INSERT INTO Semester VALUES ('2241',100341,'Bis 2241')\g INSERT INTO Semester VALUES ('2241',682,'SS 2241')\g INSERT INTO Semester VALUES ('2241/2242',683,'WS 2241/2242')\g INSERT INTO Semester VALUES ('2242',50342,'Ab 2242')\g INSERT INTO Semester VALUES ('2242',100342,'Bis 2242')\g INSERT INTO Semester VALUES ('2242',684,'SS 2242')\g INSERT INTO Semester VALUES ('2242/2243',685,'WS 2242/2243')\g INSERT INTO Semester VALUES ('2243',50343,'Ab 2243')\g INSERT INTO Semester VALUES ('2243',100343,'Bis 2243')\g INSERT INTO Semester VALUES ('2243',686,'SS 2243')\g INSERT INTO Semester VALUES ('2243/2244',687,'WS 2243/2244')\g INSERT INTO Semester VALUES ('2244',50344,'Ab 2244')\g INSERT INTO Semester VALUES ('2244',100344,'Bis 2244')\g INSERT INTO Semester VALUES ('2244',688,'SS 2244')\g INSERT INTO Semester VALUES ('2244/2245',689,'WS 2244/2245')\g INSERT INTO Semester VALUES ('2245',50345,'Ab 2245')\g INSERT INTO Semester VALUES ('2245',100345,'Bis 2245')\g INSERT INTO Semester VALUES ('2245',690,'SS 2245')\g INSERT INTO Semester VALUES ('2245/2246',691,'WS 2245/2246')\g INSERT INTO Semester VALUES ('2246',50346,'Ab 2246')\g INSERT INTO Semester VALUES ('2246',100346,'Bis 2246')\g INSERT INTO Semester VALUES ('2246',692,'SS 2246')\g INSERT INTO Semester VALUES ('2246/2247',693,'WS 2246/2247')\g INSERT INTO Semester VALUES ('2247',50347,'Ab 2247')\g INSERT INTO Semester VALUES ('2247',100347,'Bis 2247')\g INSERT INTO Semester VALUES ('2247',694,'SS 2247')\g INSERT INTO Semester VALUES ('2247/2248',695,'WS 2247/2248')\g INSERT INTO Semester VALUES ('2248',50348,'Ab 2248')\g INSERT INTO Semester VALUES ('2248',100348,'Bis 2248')\g INSERT INTO Semester VALUES ('2248',696,'SS 2248')\g INSERT INTO Semester VALUES ('2248/2249',697,'WS 2248/2249')\g INSERT INTO Semester VALUES ('2249',50349,'Ab 2249')\g INSERT INTO Semester VALUES ('2249',100349,'Bis 2249')\g INSERT INTO Semester VALUES ('2249',698,'SS 2249')\g INSERT INTO Semester VALUES ('2249/2250',699,'WS 2249/2250')\g INSERT INTO Semester VALUES ('2250',50350,'Ab 2250')\g INSERT INTO Semester VALUES ('2250',100350,'Bis 2250')\g INSERT INTO Semester VALUES ('2250',700,'SS 2250')\g INSERT INTO Semester VALUES ('2250/2251',701,'WS 2250/2251')\g INSERT INTO Semester VALUES ('2251',50351,'Ab 2251')\g INSERT INTO Semester VALUES ('2251',100351,'Bis 2251')\g INSERT INTO Semester VALUES ('2251',702,'SS 2251')\g INSERT INTO Semester VALUES ('2251/2252',703,'WS 2251/2252')\g INSERT INTO Semester VALUES ('2252',50352,'Ab 2252')\g INSERT INTO Semester VALUES ('2252',100352,'Bis 2252')\g INSERT INTO Semester VALUES ('2252',704,'SS 2252')\g INSERT INTO Semester VALUES ('2252/2253',705,'WS 2252/2253')\g INSERT INTO Semester VALUES ('2253',50353,'Ab 2253')\g INSERT INTO Semester VALUES ('2253',100353,'Bis 2253')\g INSERT INTO Semester VALUES ('2253',706,'SS 2253')\g INSERT INTO Semester VALUES ('2253/2254',707,'WS 2253/2254')\g INSERT INTO Semester VALUES ('2254',50354,'Ab 2254')\g INSERT INTO Semester VALUES ('2254',100354,'Bis 2254')\g INSERT INTO Semester VALUES ('2254',708,'SS 2254')\g INSERT INTO Semester VALUES ('2254/2255',709,'WS 2254/2255')\g INSERT INTO Semester VALUES ('2255',50355,'Ab 2255')\g INSERT INTO Semester VALUES ('2255',100355,'Bis 2255')\g INSERT INTO Semester VALUES ('2255',710,'SS 2255')\g INSERT INTO Semester VALUES ('2255/2256',711,'WS 2255/2256')\g INSERT INTO Semester VALUES ('2256',50356,'Ab 2256')\g INSERT INTO Semester VALUES ('2256',100356,'Bis 2256')\g INSERT INTO Semester VALUES ('2256',712,'SS 2256')\g INSERT INTO Semester VALUES ('2256/2257',713,'WS 2256/2257')\g INSERT INTO Semester VALUES ('2257',50357,'Ab 2257')\g INSERT INTO Semester VALUES ('2257',100357,'Bis 2257')\g INSERT INTO Semester VALUES ('2257',714,'SS 2257')\g INSERT INTO Semester VALUES ('2257/2258',715,'WS 2257/2258')\g INSERT INTO Semester VALUES ('2258',50358,'Ab 2258')\g INSERT INTO Semester VALUES ('2258',100358,'Bis 2258')\g INSERT INTO Semester VALUES ('2258',716,'SS 2258')\g INSERT INTO Semester VALUES ('2258/2259',717,'WS 2258/2259')\g INSERT INTO Semester VALUES ('2259',50359,'Ab 2259')\g INSERT INTO Semester VALUES ('2259',100359,'Bis 2259')\g INSERT INTO Semester VALUES ('2259',718,'SS 2259')\g INSERT INTO Semester VALUES ('2259/2260',719,'WS 2259/2260')\g INSERT INTO Semester VALUES ('2260',50360,'Ab 2260')\g INSERT INTO Semester VALUES ('2260',100360,'Bis 2260')\g INSERT INTO Semester VALUES ('2260',720,'SS 2260')\g INSERT INTO Semester VALUES ('2260/2261',721,'WS 2260/2261')\g INSERT INTO Semester VALUES ('2261',50361,'Ab 2261')\g INSERT INTO Semester VALUES ('2261',100361,'Bis 2261')\g INSERT INTO Semester VALUES ('2261',722,'SS 2261')\g INSERT INTO Semester VALUES ('2261/2262',723,'WS 2261/2262')\g INSERT INTO Semester VALUES ('2262',50362,'Ab 2262')\g INSERT INTO Semester VALUES ('2262',100362,'Bis 2262')\g INSERT INTO Semester VALUES ('2262',724,'SS 2262')\g INSERT INTO Semester VALUES ('2262/2263',725,'WS 2262/2263')\g INSERT INTO Semester VALUES ('2263',50363,'Ab 2263')\g INSERT INTO Semester VALUES ('2263',100363,'Bis 2263')\g INSERT INTO Semester VALUES ('2263',726,'SS 2263')\g INSERT INTO Semester VALUES ('2263/2264',727,'WS 2263/2264')\g INSERT INTO Semester VALUES ('2264',50364,'Ab 2264')\g INSERT INTO Semester VALUES ('2264',100364,'Bis 2264')\g INSERT INTO Semester VALUES ('2264',728,'SS 2264')\g INSERT INTO Semester VALUES ('2264/2265',729,'WS 2264/2265')\g INSERT INTO Semester VALUES ('2265',50365,'Ab 2265')\g INSERT INTO Semester VALUES ('2265',100365,'Bis 2265')\g INSERT INTO Semester VALUES ('2265',730,'SS 2265')\g INSERT INTO Semester VALUES ('2265/2266',731,'WS 2265/2266')\g INSERT INTO Semester VALUES ('2266',50366,'Ab 2266')\g INSERT INTO Semester VALUES ('2266',100366,'Bis 2266')\g INSERT INTO Semester VALUES ('2266',732,'SS 2266')\g INSERT INTO Semester VALUES ('2266/2267',733,'WS 2266/2267')\g INSERT INTO Semester VALUES ('2267',50367,'Ab 2267')\g INSERT INTO Semester VALUES ('2267',100367,'Bis 2267')\g INSERT INTO Semester VALUES ('2267',734,'SS 2267')\g INSERT INTO Semester VALUES ('2267/2268',735,'WS 2267/2268')\g INSERT INTO Semester VALUES ('2268',50368,'Ab 2268')\g INSERT INTO Semester VALUES ('2268',100368,'Bis 2268')\g INSERT INTO Semester VALUES ('2268',736,'SS 2268')\g INSERT INTO Semester VALUES ('2268/2269',737,'WS 2268/2269')\g INSERT INTO Semester VALUES ('2269',50369,'Ab 2269')\g INSERT INTO Semester VALUES ('2269',100369,'Bis 2269')\g INSERT INTO Semester VALUES ('2269',738,'SS 2269')\g INSERT INTO Semester VALUES ('2269/2270',739,'WS 2269/2270')\g INSERT INTO Semester VALUES ('2270',50370,'Ab 2270')\g INSERT INTO Semester VALUES ('2270',100370,'Bis 2270')\g INSERT INTO Semester VALUES ('2270',740,'SS 2270')\g INSERT INTO Semester VALUES ('2270/2271',741,'WS 2270/2271')\g INSERT INTO Semester VALUES ('2271',50371,'Ab 2271')\g INSERT INTO Semester VALUES ('2271',100371,'Bis 2271')\g INSERT INTO Semester VALUES ('2271',742,'SS 2271')\g INSERT INTO Semester VALUES ('2271/2272',743,'WS 2271/2272')\g INSERT INTO Semester VALUES ('2272',50372,'Ab 2272')\g INSERT INTO Semester VALUES ('2272',100372,'Bis 2272')\g INSERT INTO Semester VALUES ('2272',744,'SS 2272')\g INSERT INTO Semester VALUES ('2272/2273',745,'WS 2272/2273')\g INSERT INTO Semester VALUES ('2273',50373,'Ab 2273')\g INSERT INTO Semester VALUES ('2273',100373,'Bis 2273')\g INSERT INTO Semester VALUES ('2273',746,'SS 2273')\g INSERT INTO Semester VALUES ('2273/2274',747,'WS 2273/2274')\g INSERT INTO Semester VALUES ('2274',50374,'Ab 2274')\g INSERT INTO Semester VALUES ('2274',100374,'Bis 2274')\g INSERT INTO Semester VALUES ('2274',748,'SS 2274')\g INSERT INTO Semester VALUES ('2274/2275',749,'WS 2274/2275')\g INSERT INTO Semester VALUES ('2275',50375,'Ab 2275')\g INSERT INTO Semester VALUES ('2275',100375,'Bis 2275')\g INSERT INTO Semester VALUES ('2275',750,'SS 2275')\g INSERT INTO Semester VALUES ('2275/2276',751,'WS 2275/2276')\g INSERT INTO Semester VALUES ('2276',50376,'Ab 2276')\g INSERT INTO Semester VALUES ('2276',100376,'Bis 2276')\g INSERT INTO Semester VALUES ('2276',752,'SS 2276')\g INSERT INTO Semester VALUES ('2276/2277',753,'WS 2276/2277')\g INSERT INTO Semester VALUES ('2277',50377,'Ab 2277')\g INSERT INTO Semester VALUES ('2277',100377,'Bis 2277')\g INSERT INTO Semester VALUES ('2277',754,'SS 2277')\g INSERT INTO Semester VALUES ('2277/2278',755,'WS 2277/2278')\g INSERT INTO Semester VALUES ('2278',50378,'Ab 2278')\g INSERT INTO Semester VALUES ('2278',100378,'Bis 2278')\g INSERT INTO Semester VALUES ('2278',756,'SS 2278')\g INSERT INTO Semester VALUES ('2278/2279',757,'WS 2278/2279')\g INSERT INTO Semester VALUES ('2279',50379,'Ab 2279')\g INSERT INTO Semester VALUES ('2279',100379,'Bis 2279')\g INSERT INTO Semester VALUES ('2279',758,'SS 2279')\g INSERT INTO Semester VALUES ('2279/2280',759,'WS 2279/2280')\g INSERT INTO Semester VALUES ('2280',50380,'Ab 2280')\g INSERT INTO Semester VALUES ('2280',100380,'Bis 2280')\g INSERT INTO Semester VALUES ('2280',760,'SS 2280')\g INSERT INTO Semester VALUES ('2280/2281',761,'WS 2280/2281')\g INSERT INTO Semester VALUES ('2281',50381,'Ab 2281')\g INSERT INTO Semester VALUES ('2281',100381,'Bis 2281')\g INSERT INTO Semester VALUES ('2281',762,'SS 2281')\g INSERT INTO Semester VALUES ('2281/2282',763,'WS 2281/2282')\g INSERT INTO Semester VALUES ('2282',50382,'Ab 2282')\g INSERT INTO Semester VALUES ('2282',100382,'Bis 2282')\g INSERT INTO Semester VALUES ('2282',764,'SS 2282')\g INSERT INTO Semester VALUES ('2282/2283',765,'WS 2282/2283')\g INSERT INTO Semester VALUES ('2283',50383,'Ab 2283')\g INSERT INTO Semester VALUES ('2283',100383,'Bis 2283')\g INSERT INTO Semester VALUES ('2283',766,'SS 2283')\g INSERT INTO Semester VALUES ('2283/2284',767,'WS 2283/2284')\g INSERT INTO Semester VALUES ('2284',50384,'Ab 2284')\g INSERT INTO Semester VALUES ('2284',100384,'Bis 2284')\g INSERT INTO Semester VALUES ('2284',768,'SS 2284')\g INSERT INTO Semester VALUES ('2284/2285',769,'WS 2284/2285')\g INSERT INTO Semester VALUES ('2285',50385,'Ab 2285')\g INSERT INTO Semester VALUES ('2285',100385,'Bis 2285')\g INSERT INTO Semester VALUES ('2285',770,'SS 2285')\g INSERT INTO Semester VALUES ('2285/2286',771,'WS 2285/2286')\g INSERT INTO Semester VALUES ('2286',50386,'Ab 2286')\g INSERT INTO Semester VALUES ('2286',100386,'Bis 2286')\g INSERT INTO Semester VALUES ('2286',772,'SS 2286')\g INSERT INTO Semester VALUES ('2286/2287',773,'WS 2286/2287')\g INSERT INTO Semester VALUES ('2287',50387,'Ab 2287')\g INSERT INTO Semester VALUES ('2287',100387,'Bis 2287')\g INSERT INTO Semester VALUES ('2287',774,'SS 2287')\g INSERT INTO Semester VALUES ('2287/2288',775,'WS 2287/2288')\g INSERT INTO Semester VALUES ('2288',50388,'Ab 2288')\g INSERT INTO Semester VALUES ('2288',100388,'Bis 2288')\g INSERT INTO Semester VALUES ('2288',776,'SS 2288')\g INSERT INTO Semester VALUES ('2288/2289',777,'WS 2288/2289')\g INSERT INTO Semester VALUES ('2289',50389,'Ab 2289')\g INSERT INTO Semester VALUES ('2289',100389,'Bis 2289')\g INSERT INTO Semester VALUES ('2289',778,'SS 2289')\g INSERT INTO Semester VALUES ('2289/2290',779,'WS 2289/2290')\g INSERT INTO Semester VALUES ('2290',50390,'Ab 2290')\g INSERT INTO Semester VALUES ('2290',100390,'Bis 2290')\g INSERT INTO Semester VALUES ('2290',780,'SS 2290')\g INSERT INTO Semester VALUES ('2290/2291',781,'WS 2290/2291')\g INSERT INTO Semester VALUES ('2291',50391,'Ab 2291')\g INSERT INTO Semester VALUES ('2291',100391,'Bis 2291')\g INSERT INTO Semester VALUES ('2291',782,'SS 2291')\g INSERT INTO Semester VALUES ('2291/2292',783,'WS 2291/2292')\g INSERT INTO Semester VALUES ('2292',50392,'Ab 2292')\g INSERT INTO Semester VALUES ('2292',100392,'Bis 2292')\g INSERT INTO Semester VALUES ('2292',784,'SS 2292')\g INSERT INTO Semester VALUES ('2292/2293',785,'WS 2292/2293')\g INSERT INTO Semester VALUES ('2293',50393,'Ab 2293')\g INSERT INTO Semester VALUES ('2293',100393,'Bis 2293')\g INSERT INTO Semester VALUES ('2293',786,'SS 2293')\g INSERT INTO Semester VALUES ('2293/2294',787,'WS 2293/2294')\g INSERT INTO Semester VALUES ('2294',50394,'Ab 2294')\g INSERT INTO Semester VALUES ('2294',100394,'Bis 2294')\g INSERT INTO Semester VALUES ('2294',788,'SS 2294')\g INSERT INTO Semester VALUES ('2294/2295',789,'WS 2294/2295')\g INSERT INTO Semester VALUES ('2295',50395,'Ab 2295')\g INSERT INTO Semester VALUES ('2295',100395,'Bis 2295')\g INSERT INTO Semester VALUES ('2295',790,'SS 2295')\g INSERT INTO Semester VALUES ('2295/2296',791,'WS 2295/2296')\g INSERT INTO Semester VALUES ('2296',50396,'Ab 2296')\g INSERT INTO Semester VALUES ('2296',100396,'Bis 2296')\g INSERT INTO Semester VALUES ('2296',792,'SS 2296')\g INSERT INTO Semester VALUES ('2296/2297',793,'WS 2296/2297')\g INSERT INTO Semester VALUES ('2297',50397,'Ab 2297')\g INSERT INTO Semester VALUES ('2297',100397,'Bis 2297')\g INSERT INTO Semester VALUES ('2297',794,'SS 2297')\g INSERT INTO Semester VALUES ('2297/2298',795,'WS 2297/2298')\g INSERT INTO Semester VALUES ('2298',50398,'Ab 2298')\g INSERT INTO Semester VALUES ('2298',100398,'Bis 2298')\g INSERT INTO Semester VALUES ('2298',796,'SS 2298')\g INSERT INTO Semester VALUES ('2298/2299',797,'WS 2298/2299')\g INSERT INTO Semester VALUES ('2299',50399,'Ab 2299')\g INSERT INTO Semester VALUES ('2299',100399,'Bis 2299')\g INSERT INTO Semester VALUES ('2299',798,'SS 2299')\g INSERT INTO Semester VALUES ('2299/2300',799,'WS 2299/2300')\g INSERT INTO Semester VALUES ('2300',50400,'Ab 2300')\g INSERT INTO Semester VALUES ('2300',100400,'Bis 2300')\g INSERT INTO Semester VALUES ('2300',800,'SS 2300')\g INSERT INTO Semester VALUES ('2300/2301',801,'WS 2300/2301')\g INSERT INTO Semester VALUES ('2301',50401,'Ab 2301')\g INSERT INTO Semester VALUES ('2301',100401,'Bis 2301')\g INSERT INTO Semester VALUES ('2301',802,'SS 2301')\g INSERT INTO Semester VALUES ('2301/2302',803,'WS 2301/2302')\g INSERT INTO Semester VALUES ('2302',50402,'Ab 2302')\g INSERT INTO Semester VALUES ('2302',100402,'Bis 2302')\g INSERT INTO Semester VALUES ('2302',804,'SS 2302')\g INSERT INTO Semester VALUES ('2302/2303',805,'WS 2302/2303')\g INSERT INTO Semester VALUES ('2303',50403,'Ab 2303')\g INSERT INTO Semester VALUES ('2303',100403,'Bis 2303')\g INSERT INTO Semester VALUES ('2303',806,'SS 2303')\g INSERT INTO Semester VALUES ('2303/2304',807,'WS 2303/2304')\g INSERT INTO Semester VALUES ('2304',50404,'Ab 2304')\g INSERT INTO Semester VALUES ('2304',100404,'Bis 2304')\g INSERT INTO Semester VALUES ('2304',808,'SS 2304')\g INSERT INTO Semester VALUES ('2304/2305',809,'WS 2304/2305')\g INSERT INTO Semester VALUES ('2305',50405,'Ab 2305')\g INSERT INTO Semester VALUES ('2305',100405,'Bis 2305')\g INSERT INTO Semester VALUES ('2305',810,'SS 2305')\g INSERT INTO Semester VALUES ('2305/2306',811,'WS 2305/2306')\g INSERT INTO Semester VALUES ('2306',50406,'Ab 2306')\g INSERT INTO Semester VALUES ('2306',100406,'Bis 2306')\g INSERT INTO Semester VALUES ('2306',812,'SS 2306')\g INSERT INTO Semester VALUES ('2306/2307',813,'WS 2306/2307')\g INSERT INTO Semester VALUES ('2307',50407,'Ab 2307')\g INSERT INTO Semester VALUES ('2307',100407,'Bis 2307')\g INSERT INTO Semester VALUES ('2307',814,'SS 2307')\g INSERT INTO Semester VALUES ('2307/2308',815,'WS 2307/2308')\g INSERT INTO Semester VALUES ('2308',50408,'Ab 2308')\g INSERT INTO Semester VALUES ('2308',100408,'Bis 2308')\g INSERT INTO Semester VALUES ('2308',816,'SS 2308')\g INSERT INTO Semester VALUES ('2308/2309',817,'WS 2308/2309')\g INSERT INTO Semester VALUES ('2309',50409,'Ab 2309')\g INSERT INTO Semester VALUES ('2309',100409,'Bis 2309')\g INSERT INTO Semester VALUES ('2309',818,'SS 2309')\g INSERT INTO Semester VALUES ('2309/2310',819,'WS 2309/2310')\g INSERT INTO Semester VALUES ('2310',50410,'Ab 2310')\g INSERT INTO Semester VALUES ('2310',100410,'Bis 2310')\g INSERT INTO Semester VALUES ('2310',820,'SS 2310')\g INSERT INTO Semester VALUES ('2310/2311',821,'WS 2310/2311')\g INSERT INTO Semester VALUES ('2311',50411,'Ab 2311')\g INSERT INTO Semester VALUES ('2311',100411,'Bis 2311')\g INSERT INTO Semester VALUES ('2311',822,'SS 2311')\g INSERT INTO Semester VALUES ('2311/2312',823,'WS 2311/2312')\g INSERT INTO Semester VALUES ('2312',50412,'Ab 2312')\g INSERT INTO Semester VALUES ('2312',100412,'Bis 2312')\g INSERT INTO Semester VALUES ('2312',824,'SS 2312')\g INSERT INTO Semester VALUES ('2312/2313',825,'WS 2312/2313')\g INSERT INTO Semester VALUES ('2313',50413,'Ab 2313')\g INSERT INTO Semester VALUES ('2313',100413,'Bis 2313')\g INSERT INTO Semester VALUES ('2313',826,'SS 2313')\g INSERT INTO Semester VALUES ('2313/2314',827,'WS 2313/2314')\g INSERT INTO Semester VALUES ('2314',50414,'Ab 2314')\g INSERT INTO Semester VALUES ('2314',100414,'Bis 2314')\g INSERT INTO Semester VALUES ('2314',828,'SS 2314')\g INSERT INTO Semester VALUES ('2314/2315',829,'WS 2314/2315')\g INSERT INTO Semester VALUES ('2315',50415,'Ab 2315')\g INSERT INTO Semester VALUES ('2315',100415,'Bis 2315')\g INSERT INTO Semester VALUES ('2315',830,'SS 2315')\g INSERT INTO Semester VALUES ('2315/2316',831,'WS 2315/2316')\g INSERT INTO Semester VALUES ('2316',50416,'Ab 2316')\g INSERT INTO Semester VALUES ('2316',100416,'Bis 2316')\g INSERT INTO Semester VALUES ('2316',832,'SS 2316')\g INSERT INTO Semester VALUES ('2316/2317',833,'WS 2316/2317')\g INSERT INTO Semester VALUES ('2317',50417,'Ab 2317')\g INSERT INTO Semester VALUES ('2317',100417,'Bis 2317')\g INSERT INTO Semester VALUES ('2317',834,'SS 2317')\g INSERT INTO Semester VALUES ('2317/2318',835,'WS 2317/2318')\g INSERT INTO Semester VALUES ('2318',50418,'Ab 2318')\g INSERT INTO Semester VALUES ('2318',100418,'Bis 2318')\g INSERT INTO Semester VALUES ('2318',836,'SS 2318')\g INSERT INTO Semester VALUES ('2318/2319',837,'WS 2318/2319')\g INSERT INTO Semester VALUES ('2319',50419,'Ab 2319')\g INSERT INTO Semester VALUES ('2319',100419,'Bis 2319')\g INSERT INTO Semester VALUES ('2319',838,'SS 2319')\g INSERT INTO Semester VALUES ('2319/2320',839,'WS 2319/2320')\g INSERT INTO Semester VALUES ('2320',50420,'Ab 2320')\g INSERT INTO Semester VALUES ('2320',100420,'Bis 2320')\g INSERT INTO Semester VALUES ('2320',840,'SS 2320')\g INSERT INTO Semester VALUES ('2320/2321',841,'WS 2320/2321')\g INSERT INTO Semester VALUES ('2321',50421,'Ab 2321')\g INSERT INTO Semester VALUES ('2321',100421,'Bis 2321')\g INSERT INTO Semester VALUES ('2321',842,'SS 2321')\g INSERT INTO Semester VALUES ('2321/2322',843,'WS 2321/2322')\g INSERT INTO Semester VALUES ('2322',50422,'Ab 2322')\g INSERT INTO Semester VALUES ('2322',100422,'Bis 2322')\g INSERT INTO Semester VALUES ('2322',844,'SS 2322')\g INSERT INTO Semester VALUES ('2322/2323',845,'WS 2322/2323')\g INSERT INTO Semester VALUES ('2323',50423,'Ab 2323')\g INSERT INTO Semester VALUES ('2323',100423,'Bis 2323')\g INSERT INTO Semester VALUES ('2323',846,'SS 2323')\g INSERT INTO Semester VALUES ('2323/2324',847,'WS 2323/2324')\g INSERT INTO Semester VALUES ('2324',50424,'Ab 2324')\g INSERT INTO Semester VALUES ('2324',100424,'Bis 2324')\g INSERT INTO Semester VALUES ('2324',848,'SS 2324')\g INSERT INTO Semester VALUES ('2324/2325',849,'WS 2324/2325')\g INSERT INTO Semester VALUES ('2325',50425,'Ab 2325')\g INSERT INTO Semester VALUES ('2325',100425,'Bis 2325')\g INSERT INTO Semester VALUES ('2325',850,'SS 2325')\g INSERT INTO Semester VALUES ('2325/2326',851,'WS 2325/2326')\g INSERT INTO Semester VALUES ('2326',50426,'Ab 2326')\g INSERT INTO Semester VALUES ('2326',100426,'Bis 2326')\g INSERT INTO Semester VALUES ('2326',852,'SS 2326')\g INSERT INTO Semester VALUES ('2326/2327',853,'WS 2326/2327')\g INSERT INTO Semester VALUES ('2327',50427,'Ab 2327')\g INSERT INTO Semester VALUES ('2327',100427,'Bis 2327')\g INSERT INTO Semester VALUES ('2327',854,'SS 2327')\g INSERT INTO Semester VALUES ('2327/2328',855,'WS 2327/2328')\g INSERT INTO Semester VALUES ('2328',50428,'Ab 2328')\g INSERT INTO Semester VALUES ('2328',100428,'Bis 2328')\g INSERT INTO Semester VALUES ('2328',856,'SS 2328')\g INSERT INTO Semester VALUES ('2328/2329',857,'WS 2328/2329')\g INSERT INTO Semester VALUES ('2329',50429,'Ab 2329')\g INSERT INTO Semester VALUES ('2329',100429,'Bis 2329')\g INSERT INTO Semester VALUES ('2329',858,'SS 2329')\g INSERT INTO Semester VALUES ('2329/2330',859,'WS 2329/2330')\g INSERT INTO Semester VALUES ('2330',50430,'Ab 2330')\g INSERT INTO Semester VALUES ('2330',100430,'Bis 2330')\g INSERT INTO Semester VALUES ('2330',860,'SS 2330')\g INSERT INTO Semester VALUES ('2330/2331',861,'WS 2330/2331')\g INSERT INTO Semester VALUES ('2331',50431,'Ab 2331')\g INSERT INTO Semester VALUES ('2331',100431,'Bis 2331')\g INSERT INTO Semester VALUES ('2331',862,'SS 2331')\g INSERT INTO Semester VALUES ('2331/2332',863,'WS 2331/2332')\g INSERT INTO Semester VALUES ('2332',50432,'Ab 2332')\g INSERT INTO Semester VALUES ('2332',100432,'Bis 2332')\g INSERT INTO Semester VALUES ('2332',864,'SS 2332')\g INSERT INTO Semester VALUES ('2332/2333',865,'WS 2332/2333')\g INSERT INTO Semester VALUES ('2333',50433,'Ab 2333')\g INSERT INTO Semester VALUES ('2333',100433,'Bis 2333')\g INSERT INTO Semester VALUES ('2333',866,'SS 2333')\g INSERT INTO Semester VALUES ('2333/2334',867,'WS 2333/2334')\g INSERT INTO Semester VALUES ('2334',50434,'Ab 2334')\g INSERT INTO Semester VALUES ('2334',100434,'Bis 2334')\g INSERT INTO Semester VALUES ('2334',868,'SS 2334')\g INSERT INTO Semester VALUES ('2334/2335',869,'WS 2334/2335')\g INSERT INTO Semester VALUES ('2335',50435,'Ab 2335')\g INSERT INTO Semester VALUES ('2335',100435,'Bis 2335')\g INSERT INTO Semester VALUES ('2335',870,'SS 2335')\g INSERT INTO Semester VALUES ('2335/2336',871,'WS 2335/2336')\g INSERT INTO Semester VALUES ('2336',50436,'Ab 2336')\g INSERT INTO Semester VALUES ('2336',100436,'Bis 2336')\g INSERT INTO Semester VALUES ('2336',872,'SS 2336')\g INSERT INTO Semester VALUES ('2336/2337',873,'WS 2336/2337')\g INSERT INTO Semester VALUES ('2337',50437,'Ab 2337')\g INSERT INTO Semester VALUES ('2337',100437,'Bis 2337')\g INSERT INTO Semester VALUES ('2337',874,'SS 2337')\g INSERT INTO Semester VALUES ('2337/2338',875,'WS 2337/2338')\g INSERT INTO Semester VALUES ('2338',50438,'Ab 2338')\g INSERT INTO Semester VALUES ('2338',100438,'Bis 2338')\g INSERT INTO Semester VALUES ('2338',876,'SS 2338')\g INSERT INTO Semester VALUES ('2338/2339',877,'WS 2338/2339')\g INSERT INTO Semester VALUES ('2339',50439,'Ab 2339')\g INSERT INTO Semester VALUES ('2339',100439,'Bis 2339')\g INSERT INTO Semester VALUES ('2339',878,'SS 2339')\g INSERT INTO Semester VALUES ('2339/2340',879,'WS 2339/2340')\g INSERT INTO Semester VALUES ('2340',50440,'Ab 2340')\g INSERT INTO Semester VALUES ('2340',100440,'Bis 2340')\g INSERT INTO Semester VALUES ('2340',880,'SS 2340')\g INSERT INTO Semester VALUES ('2340/2341',881,'WS 2340/2341')\g INSERT INTO Semester VALUES ('2341',50441,'Ab 2341')\g INSERT INTO Semester VALUES ('2341',100441,'Bis 2341')\g INSERT INTO Semester VALUES ('2341',882,'SS 2341')\g INSERT INTO Semester VALUES ('2341/2342',883,'WS 2341/2342')\g INSERT INTO Semester VALUES ('2342',50442,'Ab 2342')\g INSERT INTO Semester VALUES ('2342',100442,'Bis 2342')\g INSERT INTO Semester VALUES ('2342',884,'SS 2342')\g INSERT INTO Semester VALUES ('2342/2343',885,'WS 2342/2343')\g INSERT INTO Semester VALUES ('2343',50443,'Ab 2343')\g INSERT INTO Semester VALUES ('2343',100443,'Bis 2343')\g INSERT INTO Semester VALUES ('2343',886,'SS 2343')\g INSERT INTO Semester VALUES ('2343/2344',887,'WS 2343/2344')\g INSERT INTO Semester VALUES ('2344',50444,'Ab 2344')\g INSERT INTO Semester VALUES ('2344',100444,'Bis 2344')\g INSERT INTO Semester VALUES ('2344',888,'SS 2344')\g INSERT INTO Semester VALUES ('2344/2345',889,'WS 2344/2345')\g INSERT INTO Semester VALUES ('2345',50445,'Ab 2345')\g INSERT INTO Semester VALUES ('2345',100445,'Bis 2345')\g INSERT INTO Semester VALUES ('2345',890,'SS 2345')\g INSERT INTO Semester VALUES ('2345/2346',891,'WS 2345/2346')\g INSERT INTO Semester VALUES ('2346',50446,'Ab 2346')\g INSERT INTO Semester VALUES ('2346',100446,'Bis 2346')\g INSERT INTO Semester VALUES ('2346',892,'SS 2346')\g INSERT INTO Semester VALUES ('2346/2347',893,'WS 2346/2347')\g INSERT INTO Semester VALUES ('2347',50447,'Ab 2347')\g INSERT INTO Semester VALUES ('2347',100447,'Bis 2347')\g INSERT INTO Semester VALUES ('2347',894,'SS 2347')\g INSERT INTO Semester VALUES ('2347/2348',895,'WS 2347/2348')\g INSERT INTO Semester VALUES ('2348',50448,'Ab 2348')\g INSERT INTO Semester VALUES ('2348',100448,'Bis 2348')\g INSERT INTO Semester VALUES ('2348',896,'SS 2348')\g INSERT INTO Semester VALUES ('2348/2349',897,'WS 2348/2349')\g INSERT INTO Semester VALUES ('2349',50449,'Ab 2349')\g INSERT INTO Semester VALUES ('2349',100449,'Bis 2349')\g INSERT INTO Semester VALUES ('2349',898,'SS 2349')\g INSERT INTO Semester VALUES ('2349/2350',899,'WS 2349/2350')\g INSERT INTO Semester VALUES ('2350',50450,'Ab 2350')\g INSERT INTO Semester VALUES ('2350',100450,'Bis 2350')\g INSERT INTO Semester VALUES ('2350',900,'SS 2350')\g INSERT INTO Semester VALUES ('2350/2351',901,'WS 2350/2351')\g INSERT INTO Semester VALUES ('2351',50451,'Ab 2351')\g INSERT INTO Semester VALUES ('2351',100451,'Bis 2351')\g INSERT INTO Semester VALUES ('2351',902,'SS 2351')\g INSERT INTO Semester VALUES ('2351/2352',903,'WS 2351/2352')\g INSERT INTO Semester VALUES ('2352',50452,'Ab 2352')\g INSERT INTO Semester VALUES ('2352',100452,'Bis 2352')\g INSERT INTO Semester VALUES ('2352',904,'SS 2352')\g INSERT INTO Semester VALUES ('2352/2353',905,'WS 2352/2353')\g INSERT INTO Semester VALUES ('2353',50453,'Ab 2353')\g INSERT INTO Semester VALUES ('2353',100453,'Bis 2353')\g INSERT INTO Semester VALUES ('2353',906,'SS 2353')\g INSERT INTO Semester VALUES ('2353/2354',907,'WS 2353/2354')\g INSERT INTO Semester VALUES ('2354',50454,'Ab 2354')\g INSERT INTO Semester VALUES ('2354',100454,'Bis 2354')\g INSERT INTO Semester VALUES ('2354',908,'SS 2354')\g INSERT INTO Semester VALUES ('2354/2355',909,'WS 2354/2355')\g INSERT INTO Semester VALUES ('2355',50455,'Ab 2355')\g INSERT INTO Semester VALUES ('2355',100455,'Bis 2355')\g INSERT INTO Semester VALUES ('2355',910,'SS 2355')\g INSERT INTO Semester VALUES ('2355/2356',911,'WS 2355/2356')\g INSERT INTO Semester VALUES ('2356',50456,'Ab 2356')\g INSERT INTO Semester VALUES ('2356',100456,'Bis 2356')\g INSERT INTO Semester VALUES ('2356',912,'SS 2356')\g INSERT INTO Semester VALUES ('2356/2357',913,'WS 2356/2357')\g INSERT INTO Semester VALUES ('2357',50457,'Ab 2357')\g INSERT INTO Semester VALUES ('2357',100457,'Bis 2357')\g INSERT INTO Semester VALUES ('2357',914,'SS 2357')\g INSERT INTO Semester VALUES ('2357/2358',915,'WS 2357/2358')\g INSERT INTO Semester VALUES ('2358',50458,'Ab 2358')\g INSERT INTO Semester VALUES ('2358',100458,'Bis 2358')\g INSERT INTO Semester VALUES ('2358',916,'SS 2358')\g INSERT INTO Semester VALUES ('2358/2359',917,'WS 2358/2359')\g INSERT INTO Semester VALUES ('2359',50459,'Ab 2359')\g INSERT INTO Semester VALUES ('2359',100459,'Bis 2359')\g INSERT INTO Semester VALUES ('2359',918,'SS 2359')\g INSERT INTO Semester VALUES ('2359/2360',919,'WS 2359/2360')\g INSERT INTO Semester VALUES ('2360',50460,'Ab 2360')\g INSERT INTO Semester VALUES ('2360',100460,'Bis 2360')\g INSERT INTO Semester VALUES ('2360',920,'SS 2360')\g INSERT INTO Semester VALUES ('2360/2361',921,'WS 2360/2361')\g INSERT INTO Semester VALUES ('2361',50461,'Ab 2361')\g INSERT INTO Semester VALUES ('2361',100461,'Bis 2361')\g INSERT INTO Semester VALUES ('2361',922,'SS 2361')\g INSERT INTO Semester VALUES ('2361/2362',923,'WS 2361/2362')\g INSERT INTO Semester VALUES ('2362',50462,'Ab 2362')\g INSERT INTO Semester VALUES ('2362',100462,'Bis 2362')\g INSERT INTO Semester VALUES ('2362',924,'SS 2362')\g INSERT INTO Semester VALUES ('2362/2363',925,'WS 2362/2363')\g INSERT INTO Semester VALUES ('2363',50463,'Ab 2363')\g INSERT INTO Semester VALUES ('2363',100463,'Bis 2363')\g INSERT INTO Semester VALUES ('2363',926,'SS 2363')\g INSERT INTO Semester VALUES ('2363/2364',927,'WS 2363/2364')\g INSERT INTO Semester VALUES ('2364',50464,'Ab 2364')\g INSERT INTO Semester VALUES ('2364',100464,'Bis 2364')\g INSERT INTO Semester VALUES ('2364',928,'SS 2364')\g INSERT INTO Semester VALUES ('2364/2365',929,'WS 2364/2365')\g INSERT INTO Semester VALUES ('2365',50465,'Ab 2365')\g INSERT INTO Semester VALUES ('2365',100465,'Bis 2365')\g INSERT INTO Semester VALUES ('2365',930,'SS 2365')\g INSERT INTO Semester VALUES ('2365/2366',931,'WS 2365/2366')\g INSERT INTO Semester VALUES ('2366',50466,'Ab 2366')\g INSERT INTO Semester VALUES ('2366',100466,'Bis 2366')\g INSERT INTO Semester VALUES ('2366',932,'SS 2366')\g INSERT INTO Semester VALUES ('2366/2367',933,'WS 2366/2367')\g INSERT INTO Semester VALUES ('2367',50467,'Ab 2367')\g INSERT INTO Semester VALUES ('2367',100467,'Bis 2367')\g INSERT INTO Semester VALUES ('2367',934,'SS 2367')\g INSERT INTO Semester VALUES ('2367/2368',935,'WS 2367/2368')\g INSERT INTO Semester VALUES ('2368',50468,'Ab 2368')\g INSERT INTO Semester VALUES ('2368',100468,'Bis 2368')\g INSERT INTO Semester VALUES ('2368',936,'SS 2368')\g INSERT INTO Semester VALUES ('2368/2369',937,'WS 2368/2369')\g INSERT INTO Semester VALUES ('2369',50469,'Ab 2369')\g INSERT INTO Semester VALUES ('2369',100469,'Bis 2369')\g INSERT INTO Semester VALUES ('2369',938,'SS 2369')\g INSERT INTO Semester VALUES ('2369/2370',939,'WS 2369/2370')\g INSERT INTO Semester VALUES ('2370',50470,'Ab 2370')\g INSERT INTO Semester VALUES ('2370',100470,'Bis 2370')\g INSERT INTO Semester VALUES ('2370',940,'SS 2370')\g INSERT INTO Semester VALUES ('2370/2371',941,'WS 2370/2371')\g INSERT INTO Semester VALUES ('2371',50471,'Ab 2371')\g INSERT INTO Semester VALUES ('2371',100471,'Bis 2371')\g INSERT INTO Semester VALUES ('2371',942,'SS 2371')\g INSERT INTO Semester VALUES ('2371/2372',943,'WS 2371/2372')\g INSERT INTO Semester VALUES ('2372',50472,'Ab 2372')\g INSERT INTO Semester VALUES ('2372',100472,'Bis 2372')\g INSERT INTO Semester VALUES ('2372',944,'SS 2372')\g INSERT INTO Semester VALUES ('2372/2373',945,'WS 2372/2373')\g INSERT INTO Semester VALUES ('2373',50473,'Ab 2373')\g INSERT INTO Semester VALUES ('2373',100473,'Bis 2373')\g INSERT INTO Semester VALUES ('2373',946,'SS 2373')\g INSERT INTO Semester VALUES ('2373/2374',947,'WS 2373/2374')\g INSERT INTO Semester VALUES ('2374',50474,'Ab 2374')\g INSERT INTO Semester VALUES ('2374',100474,'Bis 2374')\g INSERT INTO Semester VALUES ('2374',948,'SS 2374')\g INSERT INTO Semester VALUES ('2374/2375',949,'WS 2374/2375')\g INSERT INTO Semester VALUES ('2375',50475,'Ab 2375')\g INSERT INTO Semester VALUES ('2375',100475,'Bis 2375')\g INSERT INTO Semester VALUES ('2375',950,'SS 2375')\g INSERT INTO Semester VALUES ('2375/2376',951,'WS 2375/2376')\g INSERT INTO Semester VALUES ('2376',50476,'Ab 2376')\g INSERT INTO Semester VALUES ('2376',100476,'Bis 2376')\g INSERT INTO Semester VALUES ('2376',952,'SS 2376')\g INSERT INTO Semester VALUES ('2376/2377',953,'WS 2376/2377')\g INSERT INTO Semester VALUES ('2377',50477,'Ab 2377')\g INSERT INTO Semester VALUES ('2377',100477,'Bis 2377')\g INSERT INTO Semester VALUES ('2377',954,'SS 2377')\g INSERT INTO Semester VALUES ('2377/2378',955,'WS 2377/2378')\g INSERT INTO Semester VALUES ('2378',50478,'Ab 2378')\g INSERT INTO Semester VALUES ('2378',100478,'Bis 2378')\g INSERT INTO Semester VALUES ('2378',956,'SS 2378')\g INSERT INTO Semester VALUES ('2378/2379',957,'WS 2378/2379')\g INSERT INTO Semester VALUES ('2379',50479,'Ab 2379')\g INSERT INTO Semester VALUES ('2379',100479,'Bis 2379')\g INSERT INTO Semester VALUES ('2379',958,'SS 2379')\g INSERT INTO Semester VALUES ('2379/2380',959,'WS 2379/2380')\g INSERT INTO Semester VALUES ('2380',50480,'Ab 2380')\g INSERT INTO Semester VALUES ('2380',100480,'Bis 2380')\g INSERT INTO Semester VALUES ('2380',960,'SS 2380')\g INSERT INTO Semester VALUES ('2380/2381',961,'WS 2380/2381')\g INSERT INTO Semester VALUES ('2381',50481,'Ab 2381')\g INSERT INTO Semester VALUES ('2381',100481,'Bis 2381')\g INSERT INTO Semester VALUES ('2381',962,'SS 2381')\g INSERT INTO Semester VALUES ('2381/2382',963,'WS 2381/2382')\g INSERT INTO Semester VALUES ('2382',50482,'Ab 2382')\g INSERT INTO Semester VALUES ('2382',100482,'Bis 2382')\g INSERT INTO Semester VALUES ('2382',964,'SS 2382')\g INSERT INTO Semester VALUES ('2382/2383',965,'WS 2382/2383')\g INSERT INTO Semester VALUES ('2383',50483,'Ab 2383')\g INSERT INTO Semester VALUES ('2383',100483,'Bis 2383')\g INSERT INTO Semester VALUES ('2383',966,'SS 2383')\g INSERT INTO Semester VALUES ('2383/2384',967,'WS 2383/2384')\g INSERT INTO Semester VALUES ('2384',50484,'Ab 2384')\g INSERT INTO Semester VALUES ('2384',100484,'Bis 2384')\g INSERT INTO Semester VALUES ('2384',968,'SS 2384')\g INSERT INTO Semester VALUES ('2384/2385',969,'WS 2384/2385')\g INSERT INTO Semester VALUES ('2385',50485,'Ab 2385')\g INSERT INTO Semester VALUES ('2385',100485,'Bis 2385')\g INSERT INTO Semester VALUES ('2385',970,'SS 2385')\g INSERT INTO Semester VALUES ('2385/2386',971,'WS 2385/2386')\g INSERT INTO Semester VALUES ('2386',50486,'Ab 2386')\g INSERT INTO Semester VALUES ('2386',100486,'Bis 2386')\g INSERT INTO Semester VALUES ('2386',972,'SS 2386')\g INSERT INTO Semester VALUES ('2386/2387',973,'WS 2386/2387')\g INSERT INTO Semester VALUES ('2387',50487,'Ab 2387')\g INSERT INTO Semester VALUES ('2387',100487,'Bis 2387')\g INSERT INTO Semester VALUES ('2387',974,'SS 2387')\g INSERT INTO Semester VALUES ('2387/2388',975,'WS 2387/2388')\g INSERT INTO Semester VALUES ('2388',50488,'Ab 2388')\g INSERT INTO Semester VALUES ('2388',100488,'Bis 2388')\g INSERT INTO Semester VALUES ('2388',976,'SS 2388')\g INSERT INTO Semester VALUES ('2388/2389',977,'WS 2388/2389')\g INSERT INTO Semester VALUES ('2389',50489,'Ab 2389')\g INSERT INTO Semester VALUES ('2389',100489,'Bis 2389')\g INSERT INTO Semester VALUES ('2389',978,'SS 2389')\g INSERT INTO Semester VALUES ('2389/2390',979,'WS 2389/2390')\g INSERT INTO Semester VALUES ('2390',50490,'Ab 2390')\g INSERT INTO Semester VALUES ('2390',100490,'Bis 2390')\g INSERT INTO Semester VALUES ('2390',980,'SS 2390')\g INSERT INTO Semester VALUES ('2390/2391',981,'WS 2390/2391')\g INSERT INTO Semester VALUES ('2391',50491,'Ab 2391')\g INSERT INTO Semester VALUES ('2391',100491,'Bis 2391')\g INSERT INTO Semester VALUES ('2391',982,'SS 2391')\g INSERT INTO Semester VALUES ('2391/2392',983,'WS 2391/2392')\g INSERT INTO Semester VALUES ('2392',50492,'Ab 2392')\g INSERT INTO Semester VALUES ('2392',100492,'Bis 2392')\g INSERT INTO Semester VALUES ('2392',984,'SS 2392')\g INSERT INTO Semester VALUES ('2392/2393',985,'WS 2392/2393')\g INSERT INTO Semester VALUES ('2393',50493,'Ab 2393')\g INSERT INTO Semester VALUES ('2393',100493,'Bis 2393')\g INSERT INTO Semester VALUES ('2393',986,'SS 2393')\g INSERT INTO Semester VALUES ('2393/2394',987,'WS 2393/2394')\g INSERT INTO Semester VALUES ('2394',50494,'Ab 2394')\g INSERT INTO Semester VALUES ('2394',100494,'Bis 2394')\g INSERT INTO Semester VALUES ('2394',988,'SS 2394')\g INSERT INTO Semester VALUES ('2394/2395',989,'WS 2394/2395')\g INSERT INTO Semester VALUES ('2395',50495,'Ab 2395')\g INSERT INTO Semester VALUES ('2395',100495,'Bis 2395')\g INSERT INTO Semester VALUES ('2395',990,'SS 2395')\g INSERT INTO Semester VALUES ('2395/2396',991,'WS 2395/2396')\g INSERT INTO Semester VALUES ('2396',50496,'Ab 2396')\g INSERT INTO Semester VALUES ('2396',100496,'Bis 2396')\g INSERT INTO Semester VALUES ('2396',992,'SS 2396')\g INSERT INTO Semester VALUES ('2396/2397',993,'WS 2396/2397')\g INSERT INTO Semester VALUES ('2397',50497,'Ab 2397')\g INSERT INTO Semester VALUES ('2397',100497,'Bis 2397')\g INSERT INTO Semester VALUES ('2397',994,'SS 2397')\g INSERT INTO Semester VALUES ('2397/2398',995,'WS 2397/2398')\g INSERT INTO Semester VALUES ('2398',50498,'Ab 2398')\g INSERT INTO Semester VALUES ('2398',100498,'Bis 2398')\g INSERT INTO Semester VALUES ('2398',996,'SS 2398')\g INSERT INTO Semester VALUES ('2398/2399',997,'WS 2398/2399')\g INSERT INTO Semester VALUES ('2399',50499,'Ab 2399')\g INSERT INTO Semester VALUES ('2399',100499,'Bis 2399')\g INSERT INTO Semester VALUES ('2399',998,'SS 2399')\g INSERT INTO Semester VALUES ('2399/2400',999,'WS 2399/2400')\g INSERT INTO Semester VALUES ('2400',50500,'Ab 2400')\g INSERT INTO Semester VALUES ('2400',100500,'Bis 2400')\g INSERT INTO Semester VALUES ('2400',1000,'SS 2400')\g INSERT INTO Semester VALUES ('2400/2401',1001,'WS 2400/2401')\g INSERT INTO Semester VALUES ('2401',50501,'Ab 2401')\g INSERT INTO Semester VALUES ('2401',100501,'Bis 2401')\g INSERT INTO Semester VALUES ('2401',1002,'SS 2401')\g INSERT INTO Semester VALUES ('2401/2402',1003,'WS 2401/2402')\g INSERT INTO Semester VALUES ('2402',50502,'Ab 2402')\g INSERT INTO Semester VALUES ('2402',100502,'Bis 2402')\g INSERT INTO Semester VALUES ('2402',1004,'SS 2402')\g INSERT INTO Semester VALUES ('2402/2403',1005,'WS 2402/2403')\g INSERT INTO Semester VALUES ('2403',50503,'Ab 2403')\g INSERT INTO Semester VALUES ('2403',100503,'Bis 2403')\g INSERT INTO Semester VALUES ('2403',1006,'SS 2403')\g INSERT INTO Semester VALUES ('2403/2404',1007,'WS 2403/2404')\g INSERT INTO Semester VALUES ('2404',50504,'Ab 2404')\g INSERT INTO Semester VALUES ('2404',100504,'Bis 2404')\g INSERT INTO Semester VALUES ('2404',1008,'SS 2404')\g INSERT INTO Semester VALUES ('2404/2405',1009,'WS 2404/2405')\g INSERT INTO Semester VALUES ('2405',50505,'Ab 2405')\g INSERT INTO Semester VALUES ('2405',100505,'Bis 2405')\g INSERT INTO Semester VALUES ('2405',1010,'SS 2405')\g INSERT INTO Semester VALUES ('2405/2406',1011,'WS 2405/2406')\g INSERT INTO Semester VALUES ('2406',50506,'Ab 2406')\g INSERT INTO Semester VALUES ('2406',100506,'Bis 2406')\g INSERT INTO Semester VALUES ('2406',1012,'SS 2406')\g INSERT INTO Semester VALUES ('2406/2407',1013,'WS 2406/2407')\g INSERT INTO Semester VALUES ('2407',50507,'Ab 2407')\g INSERT INTO Semester VALUES ('2407',100507,'Bis 2407')\g INSERT INTO Semester VALUES ('2407',1014,'SS 2407')\g INSERT INTO Semester VALUES ('2407/2408',1015,'WS 2407/2408')\g INSERT INTO Semester VALUES ('2408',50508,'Ab 2408')\g INSERT INTO Semester VALUES ('2408',100508,'Bis 2408')\g INSERT INTO Semester VALUES ('2408',1016,'SS 2408')\g INSERT INTO Semester VALUES ('2408/2409',1017,'WS 2408/2409')\g INSERT INTO Semester VALUES ('2409',50509,'Ab 2409')\g INSERT INTO Semester VALUES ('2409',100509,'Bis 2409')\g INSERT INTO Semester VALUES ('2409',1018,'SS 2409')\g INSERT INTO Semester VALUES ('2409/2410',1019,'WS 2409/2410')\g INSERT INTO Semester VALUES ('2410',50510,'Ab 2410')\g INSERT INTO Semester VALUES ('2410',100510,'Bis 2410')\g INSERT INTO Semester VALUES ('2410',1020,'SS 2410')\g INSERT INTO Semester VALUES ('2410/2411',1021,'WS 2410/2411')\g INSERT INTO Semester VALUES ('2411',50511,'Ab 2411')\g INSERT INTO Semester VALUES ('2411',100511,'Bis 2411')\g INSERT INTO Semester VALUES ('2411',1022,'SS 2411')\g INSERT INTO Semester VALUES ('2411/2412',1023,'WS 2411/2412')\g INSERT INTO Semester VALUES ('2412',50512,'Ab 2412')\g INSERT INTO Semester VALUES ('2412',100512,'Bis 2412')\g INSERT INTO Semester VALUES ('2412',1024,'SS 2412')\g INSERT INTO Semester VALUES ('2412/2413',1025,'WS 2412/2413')\g INSERT INTO Semester VALUES ('2413',50513,'Ab 2413')\g INSERT INTO Semester VALUES ('2413',100513,'Bis 2413')\g INSERT INTO Semester VALUES ('2413',1026,'SS 2413')\g INSERT INTO Semester VALUES ('2413/2414',1027,'WS 2413/2414')\g INSERT INTO Semester VALUES ('2414',50514,'Ab 2414')\g INSERT INTO Semester VALUES ('2414',100514,'Bis 2414')\g INSERT INTO Semester VALUES ('2414',1028,'SS 2414')\g INSERT INTO Semester VALUES ('2414/2415',1029,'WS 2414/2415')\g INSERT INTO Semester VALUES ('2415',50515,'Ab 2415')\g INSERT INTO Semester VALUES ('2415',100515,'Bis 2415')\g INSERT INTO Semester VALUES ('2415',1030,'SS 2415')\g INSERT INTO Semester VALUES ('2415/2416',1031,'WS 2415/2416')\g INSERT INTO Semester VALUES ('2416',50516,'Ab 2416')\g INSERT INTO Semester VALUES ('2416',100516,'Bis 2416')\g INSERT INTO Semester VALUES ('2416',1032,'SS 2416')\g INSERT INTO Semester VALUES ('2416/2417',1033,'WS 2416/2417')\g INSERT INTO Semester VALUES ('2417',50517,'Ab 2417')\g INSERT INTO Semester VALUES ('2417',100517,'Bis 2417')\g INSERT INTO Semester VALUES ('2417',1034,'SS 2417')\g INSERT INTO Semester VALUES ('2417/2418',1035,'WS 2417/2418')\g INSERT INTO Semester VALUES ('2418',50518,'Ab 2418')\g INSERT INTO Semester VALUES ('2418',100518,'Bis 2418')\g INSERT INTO Semester VALUES ('2418',1036,'SS 2418')\g INSERT INTO Semester VALUES ('2418/2419',1037,'WS 2418/2419')\g INSERT INTO Semester VALUES ('2419',50519,'Ab 2419')\g INSERT INTO Semester VALUES ('2419',100519,'Bis 2419')\g INSERT INTO Semester VALUES ('2419',1038,'SS 2419')\g INSERT INTO Semester VALUES ('2419/2420',1039,'WS 2419/2420')\g INSERT INTO Semester VALUES ('2420',50520,'Ab 2420')\g INSERT INTO Semester VALUES ('2420',100520,'Bis 2420')\g INSERT INTO Semester VALUES ('2420',1040,'SS 2420')\g INSERT INTO Semester VALUES ('2420/2421',1041,'WS 2420/2421')\g INSERT INTO Semester VALUES ('2421',50521,'Ab 2421')\g INSERT INTO Semester VALUES ('2421',100521,'Bis 2421')\g INSERT INTO Semester VALUES ('2421',1042,'SS 2421')\g INSERT INTO Semester VALUES ('2421/2422',1043,'WS 2421/2422')\g INSERT INTO Semester VALUES ('2422',50522,'Ab 2422')\g INSERT INTO Semester VALUES ('2422',100522,'Bis 2422')\g INSERT INTO Semester VALUES ('2422',1044,'SS 2422')\g INSERT INTO Semester VALUES ('2422/2423',1045,'WS 2422/2423')\g INSERT INTO Semester VALUES ('2423',50523,'Ab 2423')\g INSERT INTO Semester VALUES ('2423',100523,'Bis 2423')\g INSERT INTO Semester VALUES ('2423',1046,'SS 2423')\g INSERT INTO Semester VALUES ('2423/2424',1047,'WS 2423/2424')\g INSERT INTO Semester VALUES ('2424',50524,'Ab 2424')\g INSERT INTO Semester VALUES ('2424',100524,'Bis 2424')\g INSERT INTO Semester VALUES ('2424',1048,'SS 2424')\g INSERT INTO Semester VALUES ('2424/2425',1049,'WS 2424/2425')\g INSERT INTO Semester VALUES ('2425',50525,'Ab 2425')\g INSERT INTO Semester VALUES ('2425',100525,'Bis 2425')\g INSERT INTO Semester VALUES ('2425',1050,'SS 2425')\g INSERT INTO Semester VALUES ('2425/2426',1051,'WS 2425/2426')\g INSERT INTO Semester VALUES ('2426',50526,'Ab 2426')\g INSERT INTO Semester VALUES ('2426',100526,'Bis 2426')\g INSERT INTO Semester VALUES ('2426',1052,'SS 2426')\g INSERT INTO Semester VALUES ('2426/2427',1053,'WS 2426/2427')\g INSERT INTO Semester VALUES ('2427',50527,'Ab 2427')\g INSERT INTO Semester VALUES ('2427',100527,'Bis 2427')\g INSERT INTO Semester VALUES ('2427',1054,'SS 2427')\g INSERT INTO Semester VALUES ('2427/2428',1055,'WS 2427/2428')\g INSERT INTO Semester VALUES ('2428',50528,'Ab 2428')\g INSERT INTO Semester VALUES ('2428',100528,'Bis 2428')\g INSERT INTO Semester VALUES ('2428',1056,'SS 2428')\g INSERT INTO Semester VALUES ('2428/2429',1057,'WS 2428/2429')\g INSERT INTO Semester VALUES ('2429',50529,'Ab 2429')\g INSERT INTO Semester VALUES ('2429',100529,'Bis 2429')\g INSERT INTO Semester VALUES ('2429',1058,'SS 2429')\g INSERT INTO Semester VALUES ('2429/2430',1059,'WS 2429/2430')\g INSERT INTO Semester VALUES ('2430',50530,'Ab 2430')\g INSERT INTO Semester VALUES ('2430',100530,'Bis 2430')\g INSERT INTO Semester VALUES ('2430',1060,'SS 2430')\g INSERT INTO Semester VALUES ('2430/2431',1061,'WS 2430/2431')\g INSERT INTO Semester VALUES ('2431',50531,'Ab 2431')\g INSERT INTO Semester VALUES ('2431',100531,'Bis 2431')\g INSERT INTO Semester VALUES ('2431',1062,'SS 2431')\g INSERT INTO Semester VALUES ('2431/2432',1063,'WS 2431/2432')\g INSERT INTO Semester VALUES ('2432',50532,'Ab 2432')\g INSERT INTO Semester VALUES ('2432',100532,'Bis 2432')\g INSERT INTO Semester VALUES ('2432',1064,'SS 2432')\g INSERT INTO Semester VALUES ('2432/2433',1065,'WS 2432/2433')\g INSERT INTO Semester VALUES ('2433',50533,'Ab 2433')\g INSERT INTO Semester VALUES ('2433',100533,'Bis 2433')\g INSERT INTO Semester VALUES ('2433',1066,'SS 2433')\g INSERT INTO Semester VALUES ('2433/2434',1067,'WS 2433/2434')\g INSERT INTO Semester VALUES ('2434',50534,'Ab 2434')\g INSERT INTO Semester VALUES ('2434',100534,'Bis 2434')\g INSERT INTO Semester VALUES ('2434',1068,'SS 2434')\g INSERT INTO Semester VALUES ('2434/2435',1069,'WS 2434/2435')\g INSERT INTO Semester VALUES ('2435',50535,'Ab 2435')\g INSERT INTO Semester VALUES ('2435',100535,'Bis 2435')\g INSERT INTO Semester VALUES ('2435',1070,'SS 2435')\g INSERT INTO Semester VALUES ('2435/2436',1071,'WS 2435/2436')\g INSERT INTO Semester VALUES ('2436',50536,'Ab 2436')\g INSERT INTO Semester VALUES ('2436',100536,'Bis 2436')\g INSERT INTO Semester VALUES ('2436',1072,'SS 2436')\g INSERT INTO Semester VALUES ('2436/2437',1073,'WS 2436/2437')\g INSERT INTO Semester VALUES ('2437',50537,'Ab 2437')\g INSERT INTO Semester VALUES ('2437',100537,'Bis 2437')\g INSERT INTO Semester VALUES ('2437',1074,'SS 2437')\g INSERT INTO Semester VALUES ('2437/2438',1075,'WS 2437/2438')\g INSERT INTO Semester VALUES ('2438',50538,'Ab 2438')\g INSERT INTO Semester VALUES ('2438',100538,'Bis 2438')\g INSERT INTO Semester VALUES ('2438',1076,'SS 2438')\g INSERT INTO Semester VALUES ('2438/2439',1077,'WS 2438/2439')\g INSERT INTO Semester VALUES ('2439',50539,'Ab 2439')\g INSERT INTO Semester VALUES ('2439',100539,'Bis 2439')\g INSERT INTO Semester VALUES ('2439',1078,'SS 2439')\g INSERT INTO Semester VALUES ('2439/2440',1079,'WS 2439/2440')\g INSERT INTO Semester VALUES ('2440',50540,'Ab 2440')\g INSERT INTO Semester VALUES ('2440',100540,'Bis 2440')\g INSERT INTO Semester VALUES ('2440',1080,'SS 2440')\g INSERT INTO Semester VALUES ('2440/2441',1081,'WS 2440/2441')\g INSERT INTO Semester VALUES ('2441',50541,'Ab 2441')\g INSERT INTO Semester VALUES ('2441',100541,'Bis 2441')\g INSERT INTO Semester VALUES ('2441',1082,'SS 2441')\g INSERT INTO Semester VALUES ('2441/2442',1083,'WS 2441/2442')\g INSERT INTO Semester VALUES ('2442',50542,'Ab 2442')\g INSERT INTO Semester VALUES ('2442',100542,'Bis 2442')\g INSERT INTO Semester VALUES ('2442',1084,'SS 2442')\g INSERT INTO Semester VALUES ('2442/2443',1085,'WS 2442/2443')\g INSERT INTO Semester VALUES ('2443',50543,'Ab 2443')\g INSERT INTO Semester VALUES ('2443',100543,'Bis 2443')\g INSERT INTO Semester VALUES ('2443',1086,'SS 2443')\g INSERT INTO Semester VALUES ('2443/2444',1087,'WS 2443/2444')\g INSERT INTO Semester VALUES ('2444',50544,'Ab 2444')\g INSERT INTO Semester VALUES ('2444',100544,'Bis 2444')\g INSERT INTO Semester VALUES ('2444',1088,'SS 2444')\g INSERT INTO Semester VALUES ('2444/2445',1089,'WS 2444/2445')\g INSERT INTO Semester VALUES ('2445',50545,'Ab 2445')\g INSERT INTO Semester VALUES ('2445',100545,'Bis 2445')\g INSERT INTO Semester VALUES ('2445',1090,'SS 2445')\g INSERT INTO Semester VALUES ('2445/2446',1091,'WS 2445/2446')\g INSERT INTO Semester VALUES ('2446',50546,'Ab 2446')\g INSERT INTO Semester VALUES ('2446',100546,'Bis 2446')\g INSERT INTO Semester VALUES ('2446',1092,'SS 2446')\g INSERT INTO Semester VALUES ('2446/2447',1093,'WS 2446/2447')\g INSERT INTO Semester VALUES ('2447',50547,'Ab 2447')\g INSERT INTO Semester VALUES ('2447',100547,'Bis 2447')\g INSERT INTO Semester VALUES ('2447',1094,'SS 2447')\g INSERT INTO Semester VALUES ('2447/2448',1095,'WS 2447/2448')\g INSERT INTO Semester VALUES ('2448',50548,'Ab 2448')\g INSERT INTO Semester VALUES ('2448',100548,'Bis 2448')\g INSERT INTO Semester VALUES ('2448',1096,'SS 2448')\g INSERT INTO Semester VALUES ('2448/2449',1097,'WS 2448/2449')\g INSERT INTO Semester VALUES ('2449',50549,'Ab 2449')\g INSERT INTO Semester VALUES ('2449',100549,'Bis 2449')\g INSERT INTO Semester VALUES ('2449',1098,'SS 2449')\g INSERT INTO Semester VALUES ('2449/2450',1099,'WS 2449/2450')\g INSERT INTO Semester VALUES ('2450',50550,'Ab 2450')\g INSERT INTO Semester VALUES ('2450',100550,'Bis 2450')\g INSERT INTO Semester VALUES ('2450',1100,'SS 2450')\g INSERT INTO Semester VALUES ('2450/2451',1101,'WS 2450/2451')\g INSERT INTO Semester VALUES ('2451',50551,'Ab 2451')\g INSERT INTO Semester VALUES ('2451',100551,'Bis 2451')\g INSERT INTO Semester VALUES ('2451',1102,'SS 2451')\g INSERT INTO Semester VALUES ('2451/2452',1103,'WS 2451/2452')\g INSERT INTO Semester VALUES ('2452',50552,'Ab 2452')\g INSERT INTO Semester VALUES ('2452',100552,'Bis 2452')\g INSERT INTO Semester VALUES ('2452',1104,'SS 2452')\g INSERT INTO Semester VALUES ('2452/2453',1105,'WS 2452/2453')\g INSERT INTO Semester VALUES ('2453',50553,'Ab 2453')\g INSERT INTO Semester VALUES ('2453',100553,'Bis 2453')\g INSERT INTO Semester VALUES ('2453',1106,'SS 2453')\g INSERT INTO Semester VALUES ('2453/2454',1107,'WS 2453/2454')\g INSERT INTO Semester VALUES ('2454',50554,'Ab 2454')\g INSERT INTO Semester VALUES ('2454',100554,'Bis 2454')\g INSERT INTO Semester VALUES ('2454',1108,'SS 2454')\g INSERT INTO Semester VALUES ('2454/2455',1109,'WS 2454/2455')\g INSERT INTO Semester VALUES ('2455',50555,'Ab 2455')\g INSERT INTO Semester VALUES ('2455',100555,'Bis 2455')\g INSERT INTO Semester VALUES ('2455',1110,'SS 2455')\g INSERT INTO Semester VALUES ('2455/2456',1111,'WS 2455/2456')\g INSERT INTO Semester VALUES ('2456',50556,'Ab 2456')\g INSERT INTO Semester VALUES ('2456',100556,'Bis 2456')\g INSERT INTO Semester VALUES ('2456',1112,'SS 2456')\g INSERT INTO Semester VALUES ('2456/2457',1113,'WS 2456/2457')\g INSERT INTO Semester VALUES ('2457',50557,'Ab 2457')\g INSERT INTO Semester VALUES ('2457',100557,'Bis 2457')\g INSERT INTO Semester VALUES ('2457',1114,'SS 2457')\g INSERT INTO Semester VALUES ('2457/2458',1115,'WS 2457/2458')\g INSERT INTO Semester VALUES ('2458',50558,'Ab 2458')\g INSERT INTO Semester VALUES ('2458',100558,'Bis 2458')\g INSERT INTO Semester VALUES ('2458',1116,'SS 2458')\g INSERT INTO Semester VALUES ('2458/2459',1117,'WS 2458/2459')\g INSERT INTO Semester VALUES ('2459',50559,'Ab 2459')\g INSERT INTO Semester VALUES ('2459',100559,'Bis 2459')\g INSERT INTO Semester VALUES ('2459',1118,'SS 2459')\g INSERT INTO Semester VALUES ('2459/2460',1119,'WS 2459/2460')\g INSERT INTO Semester VALUES ('2460',50560,'Ab 2460')\g INSERT INTO Semester VALUES ('2460',100560,'Bis 2460')\g INSERT INTO Semester VALUES ('2460',1120,'SS 2460')\g INSERT INTO Semester VALUES ('2460/2461',1121,'WS 2460/2461')\g INSERT INTO Semester VALUES ('2461',50561,'Ab 2461')\g INSERT INTO Semester VALUES ('2461',100561,'Bis 2461')\g INSERT INTO Semester VALUES ('2461',1122,'SS 2461')\g INSERT INTO Semester VALUES ('2461/2462',1123,'WS 2461/2462')\g INSERT INTO Semester VALUES ('2462',50562,'Ab 2462')\g INSERT INTO Semester VALUES ('2462',100562,'Bis 2462')\g INSERT INTO Semester VALUES ('2462',1124,'SS 2462')\g INSERT INTO Semester VALUES ('2462/2463',1125,'WS 2462/2463')\g INSERT INTO Semester VALUES ('2463',50563,'Ab 2463')\g INSERT INTO Semester VALUES ('2463',100563,'Bis 2463')\g INSERT INTO Semester VALUES ('2463',1126,'SS 2463')\g INSERT INTO Semester VALUES ('2463/2464',1127,'WS 2463/2464')\g INSERT INTO Semester VALUES ('2464',50564,'Ab 2464')\g INSERT INTO Semester VALUES ('2464',100564,'Bis 2464')\g INSERT INTO Semester VALUES ('2464',1128,'SS 2464')\g INSERT INTO Semester VALUES ('2464/2465',1129,'WS 2464/2465')\g INSERT INTO Semester VALUES ('2465',50565,'Ab 2465')\g INSERT INTO Semester VALUES ('2465',100565,'Bis 2465')\g INSERT INTO Semester VALUES ('2465',1130,'SS 2465')\g INSERT INTO Semester VALUES ('2465/2466',1131,'WS 2465/2466')\g INSERT INTO Semester VALUES ('2466',50566,'Ab 2466')\g INSERT INTO Semester VALUES ('2466',100566,'Bis 2466')\g INSERT INTO Semester VALUES ('2466',1132,'SS 2466')\g INSERT INTO Semester VALUES ('2466/2467',1133,'WS 2466/2467')\g INSERT INTO Semester VALUES ('2467',50567,'Ab 2467')\g INSERT INTO Semester VALUES ('2467',100567,'Bis 2467')\g INSERT INTO Semester VALUES ('2467',1134,'SS 2467')\g INSERT INTO Semester VALUES ('2467/2468',1135,'WS 2467/2468')\g INSERT INTO Semester VALUES ('2468',50568,'Ab 2468')\g INSERT INTO Semester VALUES ('2468',100568,'Bis 2468')\g INSERT INTO Semester VALUES ('2468',1136,'SS 2468')\g INSERT INTO Semester VALUES ('2468/2469',1137,'WS 2468/2469')\g INSERT INTO Semester VALUES ('2469',50569,'Ab 2469')\g INSERT INTO Semester VALUES ('2469',100569,'Bis 2469')\g INSERT INTO Semester VALUES ('2469',1138,'SS 2469')\g INSERT INTO Semester VALUES ('2469/2470',1139,'WS 2469/2470')\g INSERT INTO Semester VALUES ('2470',50570,'Ab 2470')\g INSERT INTO Semester VALUES ('2470',100570,'Bis 2470')\g INSERT INTO Semester VALUES ('2470',1140,'SS 2470')\g INSERT INTO Semester VALUES ('2470/2471',1141,'WS 2470/2471')\g INSERT INTO Semester VALUES ('2471',50571,'Ab 2471')\g INSERT INTO Semester VALUES ('2471',100571,'Bis 2471')\g INSERT INTO Semester VALUES ('2471',1142,'SS 2471')\g INSERT INTO Semester VALUES ('2471/2472',1143,'WS 2471/2472')\g INSERT INTO Semester VALUES ('2472',50572,'Ab 2472')\g INSERT INTO Semester VALUES ('2472',100572,'Bis 2472')\g INSERT INTO Semester VALUES ('2472',1144,'SS 2472')\g INSERT INTO Semester VALUES ('2472/2473',1145,'WS 2472/2473')\g INSERT INTO Semester VALUES ('2473',50573,'Ab 2473')\g INSERT INTO Semester VALUES ('2473',100573,'Bis 2473')\g INSERT INTO Semester VALUES ('2473',1146,'SS 2473')\g INSERT INTO Semester VALUES ('2473/2474',1147,'WS 2473/2474')\g INSERT INTO Semester VALUES ('2474',50574,'Ab 2474')\g INSERT INTO Semester VALUES ('2474',100574,'Bis 2474')\g INSERT INTO Semester VALUES ('2474',1148,'SS 2474')\g INSERT INTO Semester VALUES ('2474/2475',1149,'WS 2474/2475')\g INSERT INTO Semester VALUES ('2475',50575,'Ab 2475')\g INSERT INTO Semester VALUES ('2475',100575,'Bis 2475')\g INSERT INTO Semester VALUES ('2475',1150,'SS 2475')\g INSERT INTO Semester VALUES ('2475/2476',1151,'WS 2475/2476')\g INSERT INTO Semester VALUES ('2476',50576,'Ab 2476')\g INSERT INTO Semester VALUES ('2476',100576,'Bis 2476')\g INSERT INTO Semester VALUES ('2476',1152,'SS 2476')\g INSERT INTO Semester VALUES ('2476/2477',1153,'WS 2476/2477')\g INSERT INTO Semester VALUES ('2477',50577,'Ab 2477')\g INSERT INTO Semester VALUES ('2477',100577,'Bis 2477')\g INSERT INTO Semester VALUES ('2477',1154,'SS 2477')\g INSERT INTO Semester VALUES ('2477/2478',1155,'WS 2477/2478')\g INSERT INTO Semester VALUES ('2478',50578,'Ab 2478')\g INSERT INTO Semester VALUES ('2478',100578,'Bis 2478')\g INSERT INTO Semester VALUES ('2478',1156,'SS 2478')\g INSERT INTO Semester VALUES ('2478/2479',1157,'WS 2478/2479')\g INSERT INTO Semester VALUES ('2479',50579,'Ab 2479')\g INSERT INTO Semester VALUES ('2479',100579,'Bis 2479')\g INSERT INTO Semester VALUES ('2479',1158,'SS 2479')\g INSERT INTO Semester VALUES ('2479/2480',1159,'WS 2479/2480')\g INSERT INTO Semester VALUES ('2480',50580,'Ab 2480')\g INSERT INTO Semester VALUES ('2480',100580,'Bis 2480')\g INSERT INTO Semester VALUES ('2480',1160,'SS 2480')\g INSERT INTO Semester VALUES ('2480/2481',1161,'WS 2480/2481')\g INSERT INTO Semester VALUES ('2481',50581,'Ab 2481')\g INSERT INTO Semester VALUES ('2481',100581,'Bis 2481')\g INSERT INTO Semester VALUES ('2481',1162,'SS 2481')\g INSERT INTO Semester VALUES ('2481/2482',1163,'WS 2481/2482')\g INSERT INTO Semester VALUES ('2482',50582,'Ab 2482')\g INSERT INTO Semester VALUES ('2482',100582,'Bis 2482')\g INSERT INTO Semester VALUES ('2482',1164,'SS 2482')\g INSERT INTO Semester VALUES ('2482/2483',1165,'WS 2482/2483')\g INSERT INTO Semester VALUES ('2483',50583,'Ab 2483')\g INSERT INTO Semester VALUES ('2483',100583,'Bis 2483')\g INSERT INTO Semester VALUES ('2483',1166,'SS 2483')\g INSERT INTO Semester VALUES ('2483/2484',1167,'WS 2483/2484')\g INSERT INTO Semester VALUES ('2484',50584,'Ab 2484')\g INSERT INTO Semester VALUES ('2484',100584,'Bis 2484')\g INSERT INTO Semester VALUES ('2484',1168,'SS 2484')\g INSERT INTO Semester VALUES ('2484/2485',1169,'WS 2484/2485')\g INSERT INTO Semester VALUES ('2485',50585,'Ab 2485')\g INSERT INTO Semester VALUES ('2485',100585,'Bis 2485')\g INSERT INTO Semester VALUES ('2485',1170,'SS 2485')\g INSERT INTO Semester VALUES ('2485/2486',1171,'WS 2485/2486')\g INSERT INTO Semester VALUES ('2486',50586,'Ab 2486')\g INSERT INTO Semester VALUES ('2486',100586,'Bis 2486')\g INSERT INTO Semester VALUES ('2486',1172,'SS 2486')\g INSERT INTO Semester VALUES ('2486/2487',1173,'WS 2486/2487')\g INSERT INTO Semester VALUES ('2487',50587,'Ab 2487')\g INSERT INTO Semester VALUES ('2487',100587,'Bis 2487')\g INSERT INTO Semester VALUES ('2487',1174,'SS 2487')\g INSERT INTO Semester VALUES ('2487/2488',1175,'WS 2487/2488')\g INSERT INTO Semester VALUES ('2488',50588,'Ab 2488')\g INSERT INTO Semester VALUES ('2488',100588,'Bis 2488')\g INSERT INTO Semester VALUES ('2488',1176,'SS 2488')\g INSERT INTO Semester VALUES ('2488/2489',1177,'WS 2488/2489')\g INSERT INTO Semester VALUES ('2489',50589,'Ab 2489')\g INSERT INTO Semester VALUES ('2489',100589,'Bis 2489')\g INSERT INTO Semester VALUES ('2489',1178,'SS 2489')\g INSERT INTO Semester VALUES ('2489/2490',1179,'WS 2489/2490')\g INSERT INTO Semester VALUES ('2490',50590,'Ab 2490')\g INSERT INTO Semester VALUES ('2490',100590,'Bis 2490')\g INSERT INTO Semester VALUES ('2490',1180,'SS 2490')\g INSERT INTO Semester VALUES ('2490/2491',1181,'WS 2490/2491')\g INSERT INTO Semester VALUES ('2491',50591,'Ab 2491')\g INSERT INTO Semester VALUES ('2491',100591,'Bis 2491')\g INSERT INTO Semester VALUES ('2491',1182,'SS 2491')\g INSERT INTO Semester VALUES ('2491/2492',1183,'WS 2491/2492')\g INSERT INTO Semester VALUES ('2492',50592,'Ab 2492')\g INSERT INTO Semester VALUES ('2492',100592,'Bis 2492')\g INSERT INTO Semester VALUES ('2492',1184,'SS 2492')\g INSERT INTO Semester VALUES ('2492/2493',1185,'WS 2492/2493')\g INSERT INTO Semester VALUES ('2493',50593,'Ab 2493')\g INSERT INTO Semester VALUES ('2493',100593,'Bis 2493')\g INSERT INTO Semester VALUES ('2493',1186,'SS 2493')\g INSERT INTO Semester VALUES ('2493/2494',1187,'WS 2493/2494')\g INSERT INTO Semester VALUES ('2494',50594,'Ab 2494')\g INSERT INTO Semester VALUES ('2494',100594,'Bis 2494')\g INSERT INTO Semester VALUES ('2494',1188,'SS 2494')\g INSERT INTO Semester VALUES ('2494/2495',1189,'WS 2494/2495')\g INSERT INTO Semester VALUES ('2495',50595,'Ab 2495')\g INSERT INTO Semester VALUES ('2495',100595,'Bis 2495')\g INSERT INTO Semester VALUES ('2495',1190,'SS 2495')\g INSERT INTO Semester VALUES ('2495/2496',1191,'WS 2495/2496')\g INSERT INTO Semester VALUES ('2496',50596,'Ab 2496')\g INSERT INTO Semester VALUES ('2496',100596,'Bis 2496')\g INSERT INTO Semester VALUES ('2496',1192,'SS 2496')\g INSERT INTO Semester VALUES ('2496/2497',1193,'WS 2496/2497')\g INSERT INTO Semester VALUES ('2497',50597,'Ab 2497')\g INSERT INTO Semester VALUES ('2497',100597,'Bis 2497')\g INSERT INTO Semester VALUES ('2497',1194,'SS 2497')\g INSERT INTO Semester VALUES ('2497/2498',1195,'WS 2497/2498')\g INSERT INTO Semester VALUES ('2498',50598,'Ab 2498')\g INSERT INTO Semester VALUES ('2498',100598,'Bis 2498')\g INSERT INTO Semester VALUES ('2498',1196,'SS 2498')\g INSERT INTO Semester VALUES ('2498/2499',1197,'WS 2498/2499')\g INSERT INTO Semester VALUES ('2499',50599,'Ab 2499')\g INSERT INTO Semester VALUES ('2499',100599,'Bis 2499')\g INSERT INTO Semester VALUES ('2499',1198,'SS 2499')\g INSERT INTO Semester VALUES ('2499/2500',1199,'WS 2499/2500')\g INSERT INTO Semester VALUES ('2500',50600,'Ab 2500')\g INSERT INTO Semester VALUES ('2500',100600,'Bis 2500')\g INSERT INTO Semester VALUES ('2500',1200,'SS 2500')\g INSERT INTO Semester VALUES ('2500/2501',1201,'WS 2500/2501')\g INSERT INTO Semester VALUES ('2501',50601,'Ab 2501')\g INSERT INTO Semester VALUES ('2501',100601,'Bis 2501')\g INSERT INTO Semester VALUES ('2501',1202,'SS 2501')\g INSERT INTO Semester VALUES ('2501/2502',1203,'WS 2501/2502')\g INSERT INTO Semester VALUES ('2502',50602,'Ab 2502')\g INSERT INTO Semester VALUES ('2502',100602,'Bis 2502')\g INSERT INTO Semester VALUES ('2502',1204,'SS 2502')\g INSERT INTO Semester VALUES ('2502/2503',1205,'WS 2502/2503')\g INSERT INTO Semester VALUES ('2503',50603,'Ab 2503')\g INSERT INTO Semester VALUES ('2503',100603,'Bis 2503')\g INSERT INTO Semester VALUES ('2503',1206,'SS 2503')\g INSERT INTO Semester VALUES ('2503/2504',1207,'WS 2503/2504')\g INSERT INTO Semester VALUES ('2504',50604,'Ab 2504')\g INSERT INTO Semester VALUES ('2504',100604,'Bis 2504')\g INSERT INTO Semester VALUES ('2504',1208,'SS 2504')\g INSERT INTO Semester VALUES ('2504/2505',1209,'WS 2504/2505')\g INSERT INTO Semester VALUES ('2505',50605,'Ab 2505')\g INSERT INTO Semester VALUES ('2505',100605,'Bis 2505')\g INSERT INTO Semester VALUES ('2505',1210,'SS 2505')\g INSERT INTO Semester VALUES ('2505/2506',1211,'WS 2505/2506')\g INSERT INTO Semester VALUES ('2506',50606,'Ab 2506')\g INSERT INTO Semester VALUES ('2506',100606,'Bis 2506')\g INSERT INTO Semester VALUES ('2506',1212,'SS 2506')\g INSERT INTO Semester VALUES ('2506/2507',1213,'WS 2506/2507')\g INSERT INTO Semester VALUES ('2507',50607,'Ab 2507')\g INSERT INTO Semester VALUES ('2507',100607,'Bis 2507')\g INSERT INTO Semester VALUES ('2507',1214,'SS 2507')\g INSERT INTO Semester VALUES ('2507/2508',1215,'WS 2507/2508')\g INSERT INTO Semester VALUES ('2508',50608,'Ab 2508')\g INSERT INTO Semester VALUES ('2508',100608,'Bis 2508')\g INSERT INTO Semester VALUES ('2508',1216,'SS 2508')\g INSERT INTO Semester VALUES ('2508/2509',1217,'WS 2508/2509')\g INSERT INTO Semester VALUES ('2509',50609,'Ab 2509')\g INSERT INTO Semester VALUES ('2509',100609,'Bis 2509')\g INSERT INTO Semester VALUES ('2509',1218,'SS 2509')\g INSERT INTO Semester VALUES ('2509/2510',1219,'WS 2509/2510')\g INSERT INTO Semester VALUES ('2510',50610,'Ab 2510')\g INSERT INTO Semester VALUES ('2510',100610,'Bis 2510')\g INSERT INTO Semester VALUES ('2510',1220,'SS 2510')\g INSERT INTO Semester VALUES ('2510/2511',1221,'WS 2510/2511')\g INSERT INTO Semester VALUES ('2511',50611,'Ab 2511')\g INSERT INTO Semester VALUES ('2511',100611,'Bis 2511')\g INSERT INTO Semester VALUES ('2511',1222,'SS 2511')\g INSERT INTO Semester VALUES ('2511/2512',1223,'WS 2511/2512')\g INSERT INTO Semester VALUES ('2512',50612,'Ab 2512')\g INSERT INTO Semester VALUES ('2512',100612,'Bis 2512')\g INSERT INTO Semester VALUES ('2512',1224,'SS 2512')\g INSERT INTO Semester VALUES ('2512/2513',1225,'WS 2512/2513')\g INSERT INTO Semester VALUES ('2513',50613,'Ab 2513')\g INSERT INTO Semester VALUES ('2513',100613,'Bis 2513')\g INSERT INTO Semester VALUES ('2513',1226,'SS 2513')\g INSERT INTO Semester VALUES ('2513/2514',1227,'WS 2513/2514')\g INSERT INTO Semester VALUES ('2514',50614,'Ab 2514')\g INSERT INTO Semester VALUES ('2514',100614,'Bis 2514')\g INSERT INTO Semester VALUES ('2514',1228,'SS 2514')\g INSERT INTO Semester VALUES ('2514/2515',1229,'WS 2514/2515')\g INSERT INTO Semester VALUES ('2515',50615,'Ab 2515')\g INSERT INTO Semester VALUES ('2515',100615,'Bis 2515')\g INSERT INTO Semester VALUES ('2515',1230,'SS 2515')\g INSERT INTO Semester VALUES ('2515/2516',1231,'WS 2515/2516')\g INSERT INTO Semester VALUES ('2516',50616,'Ab 2516')\g INSERT INTO Semester VALUES ('2516',100616,'Bis 2516')\g INSERT INTO Semester VALUES ('2516',1232,'SS 2516')\g INSERT INTO Semester VALUES ('2516/2517',1233,'WS 2516/2517')\g INSERT INTO Semester VALUES ('2517',50617,'Ab 2517')\g INSERT INTO Semester VALUES ('2517',100617,'Bis 2517')\g INSERT INTO Semester VALUES ('2517',1234,'SS 2517')\g INSERT INTO Semester VALUES ('2517/2518',1235,'WS 2517/2518')\g INSERT INTO Semester VALUES ('2518',50618,'Ab 2518')\g INSERT INTO Semester VALUES ('2518',100618,'Bis 2518')\g INSERT INTO Semester VALUES ('2518',1236,'SS 2518')\g INSERT INTO Semester VALUES ('2518/2519',1237,'WS 2518/2519')\g INSERT INTO Semester VALUES ('2519',50619,'Ab 2519')\g INSERT INTO Semester VALUES ('2519',100619,'Bis 2519')\g INSERT INTO Semester VALUES ('2519',1238,'SS 2519')\g INSERT INTO Semester VALUES ('2519/2520',1239,'WS 2519/2520')\g INSERT INTO Semester VALUES ('2520',50620,'Ab 2520')\g INSERT INTO Semester VALUES ('2520',100620,'Bis 2520')\g INSERT INTO Semester VALUES ('2520',1240,'SS 2520')\g INSERT INTO Semester VALUES ('2520/2521',1241,'WS 2520/2521')\g INSERT INTO Semester VALUES ('2521',50621,'Ab 2521')\g INSERT INTO Semester VALUES ('2521',100621,'Bis 2521')\g INSERT INTO Semester VALUES ('2521',1242,'SS 2521')\g INSERT INTO Semester VALUES ('2521/2522',1243,'WS 2521/2522')\g INSERT INTO Semester VALUES ('2522',50622,'Ab 2522')\g INSERT INTO Semester VALUES ('2522',100622,'Bis 2522')\g INSERT INTO Semester VALUES ('2522',1244,'SS 2522')\g INSERT INTO Semester VALUES ('2522/2523',1245,'WS 2522/2523')\g INSERT INTO Semester VALUES ('2523',50623,'Ab 2523')\g INSERT INTO Semester VALUES ('2523',100623,'Bis 2523')\g INSERT INTO Semester VALUES ('2523',1246,'SS 2523')\g INSERT INTO Semester VALUES ('2523/2524',1247,'WS 2523/2524')\g INSERT INTO Semester VALUES ('2524',50624,'Ab 2524')\g INSERT INTO Semester VALUES ('2524',100624,'Bis 2524')\g INSERT INTO Semester VALUES ('2524',1248,'SS 2524')\g INSERT INTO Semester VALUES ('2524/2525',1249,'WS 2524/2525')\g INSERT INTO Semester VALUES ('2525',50625,'Ab 2525')\g INSERT INTO Semester VALUES ('2525',100625,'Bis 2525')\g INSERT INTO Semester VALUES ('2525',1250,'SS 2525')\g INSERT INTO Semester VALUES ('2525/2526',1251,'WS 2525/2526')\g INSERT INTO Semester VALUES ('2526',50626,'Ab 2526')\g INSERT INTO Semester VALUES ('2526',100626,'Bis 2526')\g INSERT INTO Semester VALUES ('2526',1252,'SS 2526')\g INSERT INTO Semester VALUES ('2526/2527',1253,'WS 2526/2527')\g INSERT INTO Semester VALUES ('2527',50627,'Ab 2527')\g INSERT INTO Semester VALUES ('2527',100627,'Bis 2527')\g INSERT INTO Semester VALUES ('2527',1254,'SS 2527')\g INSERT INTO Semester VALUES ('2527/2528',1255,'WS 2527/2528')\g INSERT INTO Semester VALUES ('2528',50628,'Ab 2528')\g INSERT INTO Semester VALUES ('2528',100628,'Bis 2528')\g INSERT INTO Semester VALUES ('2528',1256,'SS 2528')\g INSERT INTO Semester VALUES ('2528/2529',1257,'WS 2528/2529')\g INSERT INTO Semester VALUES ('2529',50629,'Ab 2529')\g INSERT INTO Semester VALUES ('2529',100629,'Bis 2529')\g INSERT INTO Semester VALUES ('2529',1258,'SS 2529')\g INSERT INTO Semester VALUES ('2529/2530',1259,'WS 2529/2530')\g INSERT INTO Semester VALUES ('2530',50630,'Ab 2530')\g INSERT INTO Semester VALUES ('2530',100630,'Bis 2530')\g INSERT INTO Semester VALUES ('2530',1260,'SS 2530')\g INSERT INTO Semester VALUES ('2530/2531',1261,'WS 2530/2531')\g INSERT INTO Semester VALUES ('2531',50631,'Ab 2531')\g INSERT INTO Semester VALUES ('2531',100631,'Bis 2531')\g INSERT INTO Semester VALUES ('2531',1262,'SS 2531')\g INSERT INTO Semester VALUES ('2531/2532',1263,'WS 2531/2532')\g INSERT INTO Semester VALUES ('2532',50632,'Ab 2532')\g INSERT INTO Semester VALUES ('2532',100632,'Bis 2532')\g INSERT INTO Semester VALUES ('2532',1264,'SS 2532')\g INSERT INTO Semester VALUES ('2532/2533',1265,'WS 2532/2533')\g INSERT INTO Semester VALUES ('2533',50633,'Ab 2533')\g INSERT INTO Semester VALUES ('2533',100633,'Bis 2533')\g INSERT INTO Semester VALUES ('2533',1266,'SS 2533')\g INSERT INTO Semester VALUES ('2533/2534',1267,'WS 2533/2534')\g INSERT INTO Semester VALUES ('2534',50634,'Ab 2534')\g INSERT INTO Semester VALUES ('2534',100634,'Bis 2534')\g INSERT INTO Semester VALUES ('2534',1268,'SS 2534')\g INSERT INTO Semester VALUES ('2534/2535',1269,'WS 2534/2535')\g INSERT INTO Semester VALUES ('2535',50635,'Ab 2535')\g INSERT INTO Semester VALUES ('2535',100635,'Bis 2535')\g INSERT INTO Semester VALUES ('2535',1270,'SS 2535')\g INSERT INTO Semester VALUES ('2535/2536',1271,'WS 2535/2536')\g INSERT INTO Semester VALUES ('2536',50636,'Ab 2536')\g INSERT INTO Semester VALUES ('2536',100636,'Bis 2536')\g INSERT INTO Semester VALUES ('2536',1272,'SS 2536')\g INSERT INTO Semester VALUES ('2536/2537',1273,'WS 2536/2537')\g INSERT INTO Semester VALUES ('2537',50637,'Ab 2537')\g INSERT INTO Semester VALUES ('2537',100637,'Bis 2537')\g INSERT INTO Semester VALUES ('2537',1274,'SS 2537')\g INSERT INTO Semester VALUES ('2537/2538',1275,'WS 2537/2538')\g INSERT INTO Semester VALUES ('2538',50638,'Ab 2538')\g INSERT INTO Semester VALUES ('2538',100638,'Bis 2538')\g INSERT INTO Semester VALUES ('2538',1276,'SS 2538')\g INSERT INTO Semester VALUES ('2538/2539',1277,'WS 2538/2539')\g INSERT INTO Semester VALUES ('2539',50639,'Ab 2539')\g INSERT INTO Semester VALUES ('2539',100639,'Bis 2539')\g INSERT INTO Semester VALUES ('2539',1278,'SS 2539')\g INSERT INTO Semester VALUES ('2539/2540',1279,'WS 2539/2540')\g INSERT INTO Semester VALUES ('2540',50640,'Ab 2540')\g INSERT INTO Semester VALUES ('2540',100640,'Bis 2540')\g INSERT INTO Semester VALUES ('2540',1280,'SS 2540')\g INSERT INTO Semester VALUES ('2540/2541',1281,'WS 2540/2541')\g INSERT INTO Semester VALUES ('2541',50641,'Ab 2541')\g INSERT INTO Semester VALUES ('2541',100641,'Bis 2541')\g INSERT INTO Semester VALUES ('2541',1282,'SS 2541')\g INSERT INTO Semester VALUES ('2541/2542',1283,'WS 2541/2542')\g INSERT INTO Semester VALUES ('2542',50642,'Ab 2542')\g INSERT INTO Semester VALUES ('2542',100642,'Bis 2542')\g INSERT INTO Semester VALUES ('2542',1284,'SS 2542')\g INSERT INTO Semester VALUES ('2542/2543',1285,'WS 2542/2543')\g INSERT INTO Semester VALUES ('2543',50643,'Ab 2543')\g INSERT INTO Semester VALUES ('2543',100643,'Bis 2543')\g INSERT INTO Semester VALUES ('2543',1286,'SS 2543')\g INSERT INTO Semester VALUES ('2543/2544',1287,'WS 2543/2544')\g INSERT INTO Semester VALUES ('2544',50644,'Ab 2544')\g INSERT INTO Semester VALUES ('2544',100644,'Bis 2544')\g INSERT INTO Semester VALUES ('2544',1288,'SS 2544')\g INSERT INTO Semester VALUES ('2544/2545',1289,'WS 2544/2545')\g INSERT INTO Semester VALUES ('2545',50645,'Ab 2545')\g INSERT INTO Semester VALUES ('2545',100645,'Bis 2545')\g INSERT INTO Semester VALUES ('2545',1290,'SS 2545')\g INSERT INTO Semester VALUES ('2545/2546',1291,'WS 2545/2546')\g INSERT INTO Semester VALUES ('2546',50646,'Ab 2546')\g INSERT INTO Semester VALUES ('2546',100646,'Bis 2546')\g INSERT INTO Semester VALUES ('2546',1292,'SS 2546')\g INSERT INTO Semester VALUES ('2546/2547',1293,'WS 2546/2547')\g INSERT INTO Semester VALUES ('2547',50647,'Ab 2547')\g INSERT INTO Semester VALUES ('2547',100647,'Bis 2547')\g INSERT INTO Semester VALUES ('2547',1294,'SS 2547')\g INSERT INTO Semester VALUES ('2547/2548',1295,'WS 2547/2548')\g INSERT INTO Semester VALUES ('2548',50648,'Ab 2548')\g INSERT INTO Semester VALUES ('2548',100648,'Bis 2548')\g INSERT INTO Semester VALUES ('2548',1296,'SS 2548')\g INSERT INTO Semester VALUES ('2548/2549',1297,'WS 2548/2549')\g INSERT INTO Semester VALUES ('2549',50649,'Ab 2549')\g INSERT INTO Semester VALUES ('2549',100649,'Bis 2549')\g INSERT INTO Semester VALUES ('2549',1298,'SS 2549')\g INSERT INTO Semester VALUES ('2549/2550',1299,'WS 2549/2550')\g INSERT INTO Semester VALUES ('2550',50650,'Ab 2550')\g INSERT INTO Semester VALUES ('2550',100650,'Bis 2550')\g INSERT INTO Semester VALUES ('2550',1300,'SS 2550')\g INSERT INTO Semester VALUES ('2550/2551',1301,'WS 2550/2551')\g INSERT INTO Semester VALUES ('2551',50651,'Ab 2551')\g INSERT INTO Semester VALUES ('2551',100651,'Bis 2551')\g INSERT INTO Semester VALUES ('2551',1302,'SS 2551')\g INSERT INTO Semester VALUES ('2551/2552',1303,'WS 2551/2552')\g INSERT INTO Semester VALUES ('2552',50652,'Ab 2552')\g INSERT INTO Semester VALUES ('2552',100652,'Bis 2552')\g INSERT INTO Semester VALUES ('2552',1304,'SS 2552')\g INSERT INTO Semester VALUES ('2552/2553',1305,'WS 2552/2553')\g INSERT INTO Semester VALUES ('2553',50653,'Ab 2553')\g INSERT INTO Semester VALUES ('2553',100653,'Bis 2553')\g INSERT INTO Semester VALUES ('2553',1306,'SS 2553')\g INSERT INTO Semester VALUES ('2553/2554',1307,'WS 2553/2554')\g INSERT INTO Semester VALUES ('2554',50654,'Ab 2554')\g INSERT INTO Semester VALUES ('2554',100654,'Bis 2554')\g INSERT INTO Semester VALUES ('2554',1308,'SS 2554')\g INSERT INTO Semester VALUES ('2554/2555',1309,'WS 2554/2555')\g INSERT INTO Semester VALUES ('2555',50655,'Ab 2555')\g INSERT INTO Semester VALUES ('2555',100655,'Bis 2555')\g INSERT INTO Semester VALUES ('2555',1310,'SS 2555')\g INSERT INTO Semester VALUES ('2555/2556',1311,'WS 2555/2556')\g INSERT INTO Semester VALUES ('2556',50656,'Ab 2556')\g INSERT INTO Semester VALUES ('2556',100656,'Bis 2556')\g INSERT INTO Semester VALUES ('2556',1312,'SS 2556')\g INSERT INTO Semester VALUES ('2556/2557',1313,'WS 2556/2557')\g INSERT INTO Semester VALUES ('2557',50657,'Ab 2557')\g INSERT INTO Semester VALUES ('2557',100657,'Bis 2557')\g INSERT INTO Semester VALUES ('2557',1314,'SS 2557')\g INSERT INTO Semester VALUES ('2557/2558',1315,'WS 2557/2558')\g INSERT INTO Semester VALUES ('2558',50658,'Ab 2558')\g INSERT INTO Semester VALUES ('2558',100658,'Bis 2558')\g INSERT INTO Semester VALUES ('2558',1316,'SS 2558')\g INSERT INTO Semester VALUES ('2558/2559',1317,'WS 2558/2559')\g INSERT INTO Semester VALUES ('2559',50659,'Ab 2559')\g INSERT INTO Semester VALUES ('2559',100659,'Bis 2559')\g INSERT INTO Semester VALUES ('2559',1318,'SS 2559')\g INSERT INTO Semester VALUES ('2559/2560',1319,'WS 2559/2560')\g INSERT INTO Semester VALUES ('2560',50660,'Ab 2560')\g INSERT INTO Semester VALUES ('2560',100660,'Bis 2560')\g INSERT INTO Semester VALUES ('2560',1320,'SS 2560')\g INSERT INTO Semester VALUES ('2560/2561',1321,'WS 2560/2561')\g INSERT INTO Semester VALUES ('2561',50661,'Ab 2561')\g INSERT INTO Semester VALUES ('2561',100661,'Bis 2561')\g INSERT INTO Semester VALUES ('2561',1322,'SS 2561')\g INSERT INTO Semester VALUES ('2561/2562',1323,'WS 2561/2562')\g INSERT INTO Semester VALUES ('2562',50662,'Ab 2562')\g INSERT INTO Semester VALUES ('2562',100662,'Bis 2562')\g INSERT INTO Semester VALUES ('2562',1324,'SS 2562')\g INSERT INTO Semester VALUES ('2562/2563',1325,'WS 2562/2563')\g INSERT INTO Semester VALUES ('2563',50663,'Ab 2563')\g INSERT INTO Semester VALUES ('2563',100663,'Bis 2563')\g INSERT INTO Semester VALUES ('2563',1326,'SS 2563')\g INSERT INTO Semester VALUES ('2563/2564',1327,'WS 2563/2564')\g INSERT INTO Semester VALUES ('2564',50664,'Ab 2564')\g INSERT INTO Semester VALUES ('2564',100664,'Bis 2564')\g INSERT INTO Semester VALUES ('2564',1328,'SS 2564')\g INSERT INTO Semester VALUES ('2564/2565',1329,'WS 2564/2565')\g INSERT INTO Semester VALUES ('2565',50665,'Ab 2565')\g INSERT INTO Semester VALUES ('2565',100665,'Bis 2565')\g INSERT INTO Semester VALUES ('2565',1330,'SS 2565')\g INSERT INTO Semester VALUES ('2565/2566',1331,'WS 2565/2566')\g INSERT INTO Semester VALUES ('2566',50666,'Ab 2566')\g INSERT INTO Semester VALUES ('2566',100666,'Bis 2566')\g INSERT INTO Semester VALUES ('2566',1332,'SS 2566')\g INSERT INTO Semester VALUES ('2566/2567',1333,'WS 2566/2567')\g INSERT INTO Semester VALUES ('2567',50667,'Ab 2567')\g INSERT INTO Semester VALUES ('2567',100667,'Bis 2567')\g INSERT INTO Semester VALUES ('2567',1334,'SS 2567')\g INSERT INTO Semester VALUES ('2567/2568',1335,'WS 2567/2568')\g INSERT INTO Semester VALUES ('2568',50668,'Ab 2568')\g INSERT INTO Semester VALUES ('2568',100668,'Bis 2568')\g INSERT INTO Semester VALUES ('2568',1336,'SS 2568')\g INSERT INTO Semester VALUES ('2568/2569',1337,'WS 2568/2569')\g INSERT INTO Semester VALUES ('2569',50669,'Ab 2569')\g INSERT INTO Semester VALUES ('2569',100669,'Bis 2569')\g INSERT INTO Semester VALUES ('2569',1338,'SS 2569')\g INSERT INTO Semester VALUES ('2569/2570',1339,'WS 2569/2570')\g INSERT INTO Semester VALUES ('2570',50670,'Ab 2570')\g INSERT INTO Semester VALUES ('2570',100670,'Bis 2570')\g INSERT INTO Semester VALUES ('2570',1340,'SS 2570')\g INSERT INTO Semester VALUES ('2570/2571',1341,'WS 2570/2571')\g INSERT INTO Semester VALUES ('2571',50671,'Ab 2571')\g INSERT INTO Semester VALUES ('2571',100671,'Bis 2571')\g INSERT INTO Semester VALUES ('2571',1342,'SS 2571')\g INSERT INTO Semester VALUES ('2571/2572',1343,'WS 2571/2572')\g INSERT INTO Semester VALUES ('2572',50672,'Ab 2572')\g INSERT INTO Semester VALUES ('2572',100672,'Bis 2572')\g INSERT INTO Semester VALUES ('2572',1344,'SS 2572')\g INSERT INTO Semester VALUES ('2572/2573',1345,'WS 2572/2573')\g INSERT INTO Semester VALUES ('2573',50673,'Ab 2573')\g INSERT INTO Semester VALUES ('2573',100673,'Bis 2573')\g INSERT INTO Semester VALUES ('2573',1346,'SS 2573')\g INSERT INTO Semester VALUES ('2573/2574',1347,'WS 2573/2574')\g INSERT INTO Semester VALUES ('2574',50674,'Ab 2574')\g INSERT INTO Semester VALUES ('2574',100674,'Bis 2574')\g INSERT INTO Semester VALUES ('2574',1348,'SS 2574')\g INSERT INTO Semester VALUES ('2574/2575',1349,'WS 2574/2575')\g INSERT INTO Semester VALUES ('2575',50675,'Ab 2575')\g INSERT INTO Semester VALUES ('2575',100675,'Bis 2575')\g INSERT INTO Semester VALUES ('2575',1350,'SS 2575')\g INSERT INTO Semester VALUES ('2575/2576',1351,'WS 2575/2576')\g INSERT INTO Semester VALUES ('2576',50676,'Ab 2576')\g INSERT INTO Semester VALUES ('2576',100676,'Bis 2576')\g INSERT INTO Semester VALUES ('2576',1352,'SS 2576')\g INSERT INTO Semester VALUES ('2576/2577',1353,'WS 2576/2577')\g INSERT INTO Semester VALUES ('2577',50677,'Ab 2577')\g INSERT INTO Semester VALUES ('2577',100677,'Bis 2577')\g INSERT INTO Semester VALUES ('2577',1354,'SS 2577')\g INSERT INTO Semester VALUES ('2577/2578',1355,'WS 2577/2578')\g INSERT INTO Semester VALUES ('2578',50678,'Ab 2578')\g INSERT INTO Semester VALUES ('2578',100678,'Bis 2578')\g INSERT INTO Semester VALUES ('2578',1356,'SS 2578')\g INSERT INTO Semester VALUES ('2578/2579',1357,'WS 2578/2579')\g INSERT INTO Semester VALUES ('2579',50679,'Ab 2579')\g INSERT INTO Semester VALUES ('2579',100679,'Bis 2579')\g INSERT INTO Semester VALUES ('2579',1358,'SS 2579')\g INSERT INTO Semester VALUES ('2579/2580',1359,'WS 2579/2580')\g INSERT INTO Semester VALUES ('2580',50680,'Ab 2580')\g INSERT INTO Semester VALUES ('2580',100680,'Bis 2580')\g INSERT INTO Semester VALUES ('2580',1360,'SS 2580')\g INSERT INTO Semester VALUES ('2580/2581',1361,'WS 2580/2581')\g INSERT INTO Semester VALUES ('2581',50681,'Ab 2581')\g INSERT INTO Semester VALUES ('2581',100681,'Bis 2581')\g INSERT INTO Semester VALUES ('2581',1362,'SS 2581')\g INSERT INTO Semester VALUES ('2581/2582',1363,'WS 2581/2582')\g INSERT INTO Semester VALUES ('2582',50682,'Ab 2582')\g INSERT INTO Semester VALUES ('2582',100682,'Bis 2582')\g INSERT INTO Semester VALUES ('2582',1364,'SS 2582')\g INSERT INTO Semester VALUES ('2582/2583',1365,'WS 2582/2583')\g INSERT INTO Semester VALUES ('2583',50683,'Ab 2583')\g INSERT INTO Semester VALUES ('2583',100683,'Bis 2583')\g INSERT INTO Semester VALUES ('2583',1366,'SS 2583')\g INSERT INTO Semester VALUES ('2583/2584',1367,'WS 2583/2584')\g INSERT INTO Semester VALUES ('2584',50684,'Ab 2584')\g INSERT INTO Semester VALUES ('2584',100684,'Bis 2584')\g INSERT INTO Semester VALUES ('2584',1368,'SS 2584')\g INSERT INTO Semester VALUES ('2584/2585',1369,'WS 2584/2585')\g INSERT INTO Semester VALUES ('2585',50685,'Ab 2585')\g INSERT INTO Semester VALUES ('2585',100685,'Bis 2585')\g INSERT INTO Semester VALUES ('2585',1370,'SS 2585')\g INSERT INTO Semester VALUES ('2585/2586',1371,'WS 2585/2586')\g INSERT INTO Semester VALUES ('2586',50686,'Ab 2586')\g INSERT INTO Semester VALUES ('2586',100686,'Bis 2586')\g INSERT INTO Semester VALUES ('2586',1372,'SS 2586')\g INSERT INTO Semester VALUES ('2586/2587',1373,'WS 2586/2587')\g INSERT INTO Semester VALUES ('2587',50687,'Ab 2587')\g INSERT INTO Semester VALUES ('2587',100687,'Bis 2587')\g INSERT INTO Semester VALUES ('2587',1374,'SS 2587')\g INSERT INTO Semester VALUES ('2587/2588',1375,'WS 2587/2588')\g INSERT INTO Semester VALUES ('2588',50688,'Ab 2588')\g INSERT INTO Semester VALUES ('2588',100688,'Bis 2588')\g INSERT INTO Semester VALUES ('2588',1376,'SS 2588')\g INSERT INTO Semester VALUES ('2588/2589',1377,'WS 2588/2589')\g INSERT INTO Semester VALUES ('2589',50689,'Ab 2589')\g INSERT INTO Semester VALUES ('2589',100689,'Bis 2589')\g INSERT INTO Semester VALUES ('2589',1378,'SS 2589')\g INSERT INTO Semester VALUES ('2589/2590',1379,'WS 2589/2590')\g INSERT INTO Semester VALUES ('2590',50690,'Ab 2590')\g INSERT INTO Semester VALUES ('2590',100690,'Bis 2590')\g INSERT INTO Semester VALUES ('2590',1380,'SS 2590')\g INSERT INTO Semester VALUES ('2590/2591',1381,'WS 2590/2591')\g INSERT INTO Semester VALUES ('2591',50691,'Ab 2591')\g INSERT INTO Semester VALUES ('2591',100691,'Bis 2591')\g INSERT INTO Semester VALUES ('2591',1382,'SS 2591')\g INSERT INTO Semester VALUES ('2591/2592',1383,'WS 2591/2592')\g INSERT INTO Semester VALUES ('2592',50692,'Ab 2592')\g INSERT INTO Semester VALUES ('2592',100692,'Bis 2592')\g INSERT INTO Semester VALUES ('2592',1384,'SS 2592')\g INSERT INTO Semester VALUES ('2592/2593',1385,'WS 2592/2593')\g INSERT INTO Semester VALUES ('2593',50693,'Ab 2593')\g INSERT INTO Semester VALUES ('2593',100693,'Bis 2593')\g INSERT INTO Semester VALUES ('2593',1386,'SS 2593')\g INSERT INTO Semester VALUES ('2593/2594',1387,'WS 2593/2594')\g INSERT INTO Semester VALUES ('2594',50694,'Ab 2594')\g INSERT INTO Semester VALUES ('2594',100694,'Bis 2594')\g INSERT INTO Semester VALUES ('2594',1388,'SS 2594')\g INSERT INTO Semester VALUES ('2594/2595',1389,'WS 2594/2595')\g INSERT INTO Semester VALUES ('2595',50695,'Ab 2595')\g INSERT INTO Semester VALUES ('2595',100695,'Bis 2595')\g INSERT INTO Semester VALUES ('2595',1390,'SS 2595')\g INSERT INTO Semester VALUES ('2595/2596',1391,'WS 2595/2596')\g INSERT INTO Semester VALUES ('2596',50696,'Ab 2596')\g INSERT INTO Semester VALUES ('2596',100696,'Bis 2596')\g INSERT INTO Semester VALUES ('2596',1392,'SS 2596')\g INSERT INTO Semester VALUES ('2596/2597',1393,'WS 2596/2597')\g INSERT INTO Semester VALUES ('2597',50697,'Ab 2597')\g INSERT INTO Semester VALUES ('2597',100697,'Bis 2597')\g INSERT INTO Semester VALUES ('2597',1394,'SS 2597')\g INSERT INTO Semester VALUES ('2597/2598',1395,'WS 2597/2598')\g INSERT INTO Semester VALUES ('2598',50698,'Ab 2598')\g INSERT INTO Semester VALUES ('2598',100698,'Bis 2598')\g INSERT INTO Semester VALUES ('2598',1396,'SS 2598')\g INSERT INTO Semester VALUES ('2598/2599',1397,'WS 2598/2599')\g INSERT INTO Semester VALUES ('2599',50699,'Ab 2599')\g INSERT INTO Semester VALUES ('2599',100699,'Bis 2599')\g INSERT INTO Semester VALUES ('2599',1398,'SS 2599')\g INSERT INTO Semester VALUES ('2599/2600',1399,'WS 2599/2600')\g INSERT INTO Semester VALUES ('2600',50700,'Ab 2600')\g INSERT INTO Semester VALUES ('2600',100700,'Bis 2600')\g INSERT INTO Semester VALUES ('2600',1400,'SS 2600')\g INSERT INTO Semester VALUES ('2600/2601',1401,'WS 2600/2601')\g INSERT INTO Semester VALUES ('2601',50701,'Ab 2601')\g INSERT INTO Semester VALUES ('2601',100701,'Bis 2601')\g INSERT INTO Semester VALUES ('2601',1402,'SS 2601')\g INSERT INTO Semester VALUES ('2601/2602',1403,'WS 2601/2602')\g INSERT INTO Semester VALUES ('2602',50702,'Ab 2602')\g INSERT INTO Semester VALUES ('2602',100702,'Bis 2602')\g INSERT INTO Semester VALUES ('2602',1404,'SS 2602')\g INSERT INTO Semester VALUES ('2602/2603',1405,'WS 2602/2603')\g INSERT INTO Semester VALUES ('2603',50703,'Ab 2603')\g INSERT INTO Semester VALUES ('2603',100703,'Bis 2603')\g INSERT INTO Semester VALUES ('2603',1406,'SS 2603')\g INSERT INTO Semester VALUES ('2603/2604',1407,'WS 2603/2604')\g INSERT INTO Semester VALUES ('2604',50704,'Ab 2604')\g INSERT INTO Semester VALUES ('2604',100704,'Bis 2604')\g INSERT INTO Semester VALUES ('2604',1408,'SS 2604')\g INSERT INTO Semester VALUES ('2604/2605',1409,'WS 2604/2605')\g INSERT INTO Semester VALUES ('2605',50705,'Ab 2605')\g INSERT INTO Semester VALUES ('2605',100705,'Bis 2605')\g INSERT INTO Semester VALUES ('2605',1410,'SS 2605')\g INSERT INTO Semester VALUES ('2605/2606',1411,'WS 2605/2606')\g INSERT INTO Semester VALUES ('2606',50706,'Ab 2606')\g INSERT INTO Semester VALUES ('2606',100706,'Bis 2606')\g INSERT INTO Semester VALUES ('2606',1412,'SS 2606')\g INSERT INTO Semester VALUES ('2606/2607',1413,'WS 2606/2607')\g INSERT INTO Semester VALUES ('2607',50707,'Ab 2607')\g INSERT INTO Semester VALUES ('2607',100707,'Bis 2607')\g INSERT INTO Semester VALUES ('2607',1414,'SS 2607')\g INSERT INTO Semester VALUES ('2607/2608',1415,'WS 2607/2608')\g INSERT INTO Semester VALUES ('2608',50708,'Ab 2608')\g INSERT INTO Semester VALUES ('2608',100708,'Bis 2608')\g INSERT INTO Semester VALUES ('2608',1416,'SS 2608')\g INSERT INTO Semester VALUES ('2608/2609',1417,'WS 2608/2609')\g INSERT INTO Semester VALUES ('2609',50709,'Ab 2609')\g INSERT INTO Semester VALUES ('2609',100709,'Bis 2609')\g INSERT INTO Semester VALUES ('2609',1418,'SS 2609')\g INSERT INTO Semester VALUES ('2609/2610',1419,'WS 2609/2610')\g INSERT INTO Semester VALUES ('2610',50710,'Ab 2610')\g INSERT INTO Semester VALUES ('2610',100710,'Bis 2610')\g INSERT INTO Semester VALUES ('2610',1420,'SS 2610')\g INSERT INTO Semester VALUES ('2610/2611',1421,'WS 2610/2611')\g INSERT INTO Semester VALUES ('2611',50711,'Ab 2611')\g INSERT INTO Semester VALUES ('2611',100711,'Bis 2611')\g INSERT INTO Semester VALUES ('2611',1422,'SS 2611')\g INSERT INTO Semester VALUES ('2611/2612',1423,'WS 2611/2612')\g INSERT INTO Semester VALUES ('2612',50712,'Ab 2612')\g INSERT INTO Semester VALUES ('2612',100712,'Bis 2612')\g INSERT INTO Semester VALUES ('2612',1424,'SS 2612')\g INSERT INTO Semester VALUES ('2612/2613',1425,'WS 2612/2613')\g INSERT INTO Semester VALUES ('2613',50713,'Ab 2613')\g INSERT INTO Semester VALUES ('2613',100713,'Bis 2613')\g INSERT INTO Semester VALUES ('2613',1426,'SS 2613')\g INSERT INTO Semester VALUES ('2613/2614',1427,'WS 2613/2614')\g INSERT INTO Semester VALUES ('2614',50714,'Ab 2614')\g INSERT INTO Semester VALUES ('2614',100714,'Bis 2614')\g INSERT INTO Semester VALUES ('2614',1428,'SS 2614')\g INSERT INTO Semester VALUES ('2614/2615',1429,'WS 2614/2615')\g INSERT INTO Semester VALUES ('2615',50715,'Ab 2615')\g INSERT INTO Semester VALUES ('2615',100715,'Bis 2615')\g INSERT INTO Semester VALUES ('2615',1430,'SS 2615')\g INSERT INTO Semester VALUES ('2615/2616',1431,'WS 2615/2616')\g INSERT INTO Semester VALUES ('2616',50716,'Ab 2616')\g INSERT INTO Semester VALUES ('2616',100716,'Bis 2616')\g INSERT INTO Semester VALUES ('2616',1432,'SS 2616')\g INSERT INTO Semester VALUES ('2616/2617',1433,'WS 2616/2617')\g INSERT INTO Semester VALUES ('2617',50717,'Ab 2617')\g INSERT INTO Semester VALUES ('2617',100717,'Bis 2617')\g INSERT INTO Semester VALUES ('2617',1434,'SS 2617')\g INSERT INTO Semester VALUES ('2617/2618',1435,'WS 2617/2618')\g INSERT INTO Semester VALUES ('2618',50718,'Ab 2618')\g INSERT INTO Semester VALUES ('2618',100718,'Bis 2618')\g INSERT INTO Semester VALUES ('2618',1436,'SS 2618')\g INSERT INTO Semester VALUES ('2618/2619',1437,'WS 2618/2619')\g INSERT INTO Semester VALUES ('2619',50719,'Ab 2619')\g INSERT INTO Semester VALUES ('2619',100719,'Bis 2619')\g INSERT INTO Semester VALUES ('2619',1438,'SS 2619')\g INSERT INTO Semester VALUES ('2619/2620',1439,'WS 2619/2620')\g INSERT INTO Semester VALUES ('2620',50720,'Ab 2620')\g INSERT INTO Semester VALUES ('2620',100720,'Bis 2620')\g INSERT INTO Semester VALUES ('2620',1440,'SS 2620')\g INSERT INTO Semester VALUES ('2620/2621',1441,'WS 2620/2621')\g INSERT INTO Semester VALUES ('2621',50721,'Ab 2621')\g INSERT INTO Semester VALUES ('2621',100721,'Bis 2621')\g INSERT INTO Semester VALUES ('2621',1442,'SS 2621')\g INSERT INTO Semester VALUES ('2621/2622',1443,'WS 2621/2622')\g INSERT INTO Semester VALUES ('2622',50722,'Ab 2622')\g INSERT INTO Semester VALUES ('2622',100722,'Bis 2622')\g INSERT INTO Semester VALUES ('2622',1444,'SS 2622')\g INSERT INTO Semester VALUES ('2622/2623',1445,'WS 2622/2623')\g INSERT INTO Semester VALUES ('2623',50723,'Ab 2623')\g INSERT INTO Semester VALUES ('2623',100723,'Bis 2623')\g INSERT INTO Semester VALUES ('2623',1446,'SS 2623')\g INSERT INTO Semester VALUES ('2623/2624',1447,'WS 2623/2624')\g INSERT INTO Semester VALUES ('2624',50724,'Ab 2624')\g INSERT INTO Semester VALUES ('2624',100724,'Bis 2624')\g INSERT INTO Semester VALUES ('2624',1448,'SS 2624')\g INSERT INTO Semester VALUES ('2624/2625',1449,'WS 2624/2625')\g INSERT INTO Semester VALUES ('2625',50725,'Ab 2625')\g INSERT INTO Semester VALUES ('2625',100725,'Bis 2625')\g INSERT INTO Semester VALUES ('2625',1450,'SS 2625')\g INSERT INTO Semester VALUES ('2625/2626',1451,'WS 2625/2626')\g INSERT INTO Semester VALUES ('2626',50726,'Ab 2626')\g INSERT INTO Semester VALUES ('2626',100726,'Bis 2626')\g INSERT INTO Semester VALUES ('2626',1452,'SS 2626')\g INSERT INTO Semester VALUES ('2626/2627',1453,'WS 2626/2627')\g INSERT INTO Semester VALUES ('2627',50727,'Ab 2627')\g INSERT INTO Semester VALUES ('2627',100727,'Bis 2627')\g INSERT INTO Semester VALUES ('2627',1454,'SS 2627')\g INSERT INTO Semester VALUES ('2627/2628',1455,'WS 2627/2628')\g INSERT INTO Semester VALUES ('2628',50728,'Ab 2628')\g INSERT INTO Semester VALUES ('2628',100728,'Bis 2628')\g INSERT INTO Semester VALUES ('2628',1456,'SS 2628')\g INSERT INTO Semester VALUES ('2628/2629',1457,'WS 2628/2629')\g INSERT INTO Semester VALUES ('2629',50729,'Ab 2629')\g INSERT INTO Semester VALUES ('2629',100729,'Bis 2629')\g INSERT INTO Semester VALUES ('2629',1458,'SS 2629')\g INSERT INTO Semester VALUES ('2629/2630',1459,'WS 2629/2630')\g INSERT INTO Semester VALUES ('2630',50730,'Ab 2630')\g INSERT INTO Semester VALUES ('2630',100730,'Bis 2630')\g INSERT INTO Semester VALUES ('2630',1460,'SS 2630')\g INSERT INTO Semester VALUES ('2630/2631',1461,'WS 2630/2631')\g INSERT INTO Semester VALUES ('2631',50731,'Ab 2631')\g INSERT INTO Semester VALUES ('2631',100731,'Bis 2631')\g INSERT INTO Semester VALUES ('2631',1462,'SS 2631')\g INSERT INTO Semester VALUES ('2631/2632',1463,'WS 2631/2632')\g INSERT INTO Semester VALUES ('2632',50732,'Ab 2632')\g INSERT INTO Semester VALUES ('2632',100732,'Bis 2632')\g INSERT INTO Semester VALUES ('2632',1464,'SS 2632')\g INSERT INTO Semester VALUES ('2632/2633',1465,'WS 2632/2633')\g INSERT INTO Semester VALUES ('2633',50733,'Ab 2633')\g INSERT INTO Semester VALUES ('2633',100733,'Bis 2633')\g INSERT INTO Semester VALUES ('2633',1466,'SS 2633')\g INSERT INTO Semester VALUES ('2633/2634',1467,'WS 2633/2634')\g INSERT INTO Semester VALUES ('2634',50734,'Ab 2634')\g INSERT INTO Semester VALUES ('2634',100734,'Bis 2634')\g INSERT INTO Semester VALUES ('2634',1468,'SS 2634')\g INSERT INTO Semester VALUES ('2634/2635',1469,'WS 2634/2635')\g INSERT INTO Semester VALUES ('2635',50735,'Ab 2635')\g INSERT INTO Semester VALUES ('2635',100735,'Bis 2635')\g INSERT INTO Semester VALUES ('2635',1470,'SS 2635')\g INSERT INTO Semester VALUES ('2635/2636',1471,'WS 2635/2636')\g INSERT INTO Semester VALUES ('2636',50736,'Ab 2636')\g INSERT INTO Semester VALUES ('2636',100736,'Bis 2636')\g INSERT INTO Semester VALUES ('2636',1472,'SS 2636')\g INSERT INTO Semester VALUES ('2636/2637',1473,'WS 2636/2637')\g INSERT INTO Semester VALUES ('2637',50737,'Ab 2637')\g INSERT INTO Semester VALUES ('2637',100737,'Bis 2637')\g INSERT INTO Semester VALUES ('2637',1474,'SS 2637')\g INSERT INTO Semester VALUES ('2637/2638',1475,'WS 2637/2638')\g INSERT INTO Semester VALUES ('2638',50738,'Ab 2638')\g INSERT INTO Semester VALUES ('2638',100738,'Bis 2638')\g INSERT INTO Semester VALUES ('2638',1476,'SS 2638')\g INSERT INTO Semester VALUES ('2638/2639',1477,'WS 2638/2639')\g INSERT INTO Semester VALUES ('2639',50739,'Ab 2639')\g INSERT INTO Semester VALUES ('2639',100739,'Bis 2639')\g INSERT INTO Semester VALUES ('2639',1478,'SS 2639')\g INSERT INTO Semester VALUES ('2639/2640',1479,'WS 2639/2640')\g INSERT INTO Semester VALUES ('2640',50740,'Ab 2640')\g INSERT INTO Semester VALUES ('2640',100740,'Bis 2640')\g INSERT INTO Semester VALUES ('2640',1480,'SS 2640')\g INSERT INTO Semester VALUES ('2640/2641',1481,'WS 2640/2641')\g INSERT INTO Semester VALUES ('2641',50741,'Ab 2641')\g INSERT INTO Semester VALUES ('2641',100741,'Bis 2641')\g INSERT INTO Semester VALUES ('2641',1482,'SS 2641')\g INSERT INTO Semester VALUES ('2641/2642',1483,'WS 2641/2642')\g INSERT INTO Semester VALUES ('2642',50742,'Ab 2642')\g INSERT INTO Semester VALUES ('2642',100742,'Bis 2642')\g INSERT INTO Semester VALUES ('2642',1484,'SS 2642')\g INSERT INTO Semester VALUES ('2642/2643',1485,'WS 2642/2643')\g INSERT INTO Semester VALUES ('2643',50743,'Ab 2643')\g INSERT INTO Semester VALUES ('2643',100743,'Bis 2643')\g INSERT INTO Semester VALUES ('2643',1486,'SS 2643')\g INSERT INTO Semester VALUES ('2643/2644',1487,'WS 2643/2644')\g INSERT INTO Semester VALUES ('2644',50744,'Ab 2644')\g INSERT INTO Semester VALUES ('2644',100744,'Bis 2644')\g INSERT INTO Semester VALUES ('2644',1488,'SS 2644')\g INSERT INTO Semester VALUES ('2644/2645',1489,'WS 2644/2645')\g INSERT INTO Semester VALUES ('2645',50745,'Ab 2645')\g INSERT INTO Semester VALUES ('2645',100745,'Bis 2645')\g INSERT INTO Semester VALUES ('2645',1490,'SS 2645')\g INSERT INTO Semester VALUES ('2645/2646',1491,'WS 2645/2646')\g INSERT INTO Semester VALUES ('2646',50746,'Ab 2646')\g INSERT INTO Semester VALUES ('2646',100746,'Bis 2646')\g INSERT INTO Semester VALUES ('2646',1492,'SS 2646')\g INSERT INTO Semester VALUES ('2646/2647',1493,'WS 2646/2647')\g INSERT INTO Semester VALUES ('2647',50747,'Ab 2647')\g INSERT INTO Semester VALUES ('2647',100747,'Bis 2647')\g INSERT INTO Semester VALUES ('2647',1494,'SS 2647')\g INSERT INTO Semester VALUES ('2647/2648',1495,'WS 2647/2648')\g INSERT INTO Semester VALUES ('2648',50748,'Ab 2648')\g INSERT INTO Semester VALUES ('2648',100748,'Bis 2648')\g INSERT INTO Semester VALUES ('2648',1496,'SS 2648')\g INSERT INTO Semester VALUES ('2648/2649',1497,'WS 2648/2649')\g INSERT INTO Semester VALUES ('2649',50749,'Ab 2649')\g INSERT INTO Semester VALUES ('2649',100749,'Bis 2649')\g INSERT INTO Semester VALUES ('2649',1498,'SS 2649')\g INSERT INTO Semester VALUES ('2649/2650',1499,'WS 2649/2650')\g INSERT INTO Semester VALUES ('2650',50750,'Ab 2650')\g INSERT INTO Semester VALUES ('2650',100750,'Bis 2650')\g INSERT INTO Semester VALUES ('2650',1500,'SS 2650')\g INSERT INTO Semester VALUES ('2650/2651',1501,'WS 2650/2651')\g INSERT INTO Semester VALUES ('2651',50751,'Ab 2651')\g INSERT INTO Semester VALUES ('2651',100751,'Bis 2651')\g INSERT INTO Semester VALUES ('2651',1502,'SS 2651')\g INSERT INTO Semester VALUES ('2651/2652',1503,'WS 2651/2652')\g INSERT INTO Semester VALUES ('2652',50752,'Ab 2652')\g INSERT INTO Semester VALUES ('2652',100752,'Bis 2652')\g INSERT INTO Semester VALUES ('2652',1504,'SS 2652')\g INSERT INTO Semester VALUES ('2652/2653',1505,'WS 2652/2653')\g INSERT INTO Semester VALUES ('2653',50753,'Ab 2653')\g INSERT INTO Semester VALUES ('2653',100753,'Bis 2653')\g INSERT INTO Semester VALUES ('2653',1506,'SS 2653')\g INSERT INTO Semester VALUES ('2653/2654',1507,'WS 2653/2654')\g INSERT INTO Semester VALUES ('2654',50754,'Ab 2654')\g INSERT INTO Semester VALUES ('2654',100754,'Bis 2654')\g INSERT INTO Semester VALUES ('2654',1508,'SS 2654')\g INSERT INTO Semester VALUES ('2654/2655',1509,'WS 2654/2655')\g INSERT INTO Semester VALUES ('2655',50755,'Ab 2655')\g INSERT INTO Semester VALUES ('2655',100755,'Bis 2655')\g INSERT INTO Semester VALUES ('2655',1510,'SS 2655')\g INSERT INTO Semester VALUES ('2655/2656',1511,'WS 2655/2656')\g INSERT INTO Semester VALUES ('2656',50756,'Ab 2656')\g INSERT INTO Semester VALUES ('2656',100756,'Bis 2656')\g INSERT INTO Semester VALUES ('2656',1512,'SS 2656')\g INSERT INTO Semester VALUES ('2656/2657',1513,'WS 2656/2657')\g INSERT INTO Semester VALUES ('2657',50757,'Ab 2657')\g INSERT INTO Semester VALUES ('2657',100757,'Bis 2657')\g INSERT INTO Semester VALUES ('2657',1514,'SS 2657')\g INSERT INTO Semester VALUES ('2657/2658',1515,'WS 2657/2658')\g INSERT INTO Semester VALUES ('2658',50758,'Ab 2658')\g INSERT INTO Semester VALUES ('2658',100758,'Bis 2658')\g INSERT INTO Semester VALUES ('2658',1516,'SS 2658')\g INSERT INTO Semester VALUES ('2658/2659',1517,'WS 2658/2659')\g INSERT INTO Semester VALUES ('2659',50759,'Ab 2659')\g INSERT INTO Semester VALUES ('2659',100759,'Bis 2659')\g INSERT INTO Semester VALUES ('2659',1518,'SS 2659')\g INSERT INTO Semester VALUES ('2659/2660',1519,'WS 2659/2660')\g INSERT INTO Semester VALUES ('2660',50760,'Ab 2660')\g INSERT INTO Semester VALUES ('2660',100760,'Bis 2660')\g INSERT INTO Semester VALUES ('2660',1520,'SS 2660')\g INSERT INTO Semester VALUES ('2660/2661',1521,'WS 2660/2661')\g INSERT INTO Semester VALUES ('2661',50761,'Ab 2661')\g INSERT INTO Semester VALUES ('2661',100761,'Bis 2661')\g INSERT INTO Semester VALUES ('2661',1522,'SS 2661')\g INSERT INTO Semester VALUES ('2661/2662',1523,'WS 2661/2662')\g INSERT INTO Semester VALUES ('2662',50762,'Ab 2662')\g INSERT INTO Semester VALUES ('2662',100762,'Bis 2662')\g INSERT INTO Semester VALUES ('2662',1524,'SS 2662')\g INSERT INTO Semester VALUES ('2662/2663',1525,'WS 2662/2663')\g INSERT INTO Semester VALUES ('2663',50763,'Ab 2663')\g INSERT INTO Semester VALUES ('2663',100763,'Bis 2663')\g INSERT INTO Semester VALUES ('2663',1526,'SS 2663')\g INSERT INTO Semester VALUES ('2663/2664',1527,'WS 2663/2664')\g INSERT INTO Semester VALUES ('2664',50764,'Ab 2664')\g INSERT INTO Semester VALUES ('2664',100764,'Bis 2664')\g INSERT INTO Semester VALUES ('2664',1528,'SS 2664')\g INSERT INTO Semester VALUES ('2664/2665',1529,'WS 2664/2665')\g INSERT INTO Semester VALUES ('2665',50765,'Ab 2665')\g INSERT INTO Semester VALUES ('2665',100765,'Bis 2665')\g INSERT INTO Semester VALUES ('2665',1530,'SS 2665')\g INSERT INTO Semester VALUES ('2665/2666',1531,'WS 2665/2666')\g INSERT INTO Semester VALUES ('2666',50766,'Ab 2666')\g INSERT INTO Semester VALUES ('2666',100766,'Bis 2666')\g INSERT INTO Semester VALUES ('2666',1532,'SS 2666')\g INSERT INTO Semester VALUES ('2666/2667',1533,'WS 2666/2667')\g INSERT INTO Semester VALUES ('2667',50767,'Ab 2667')\g INSERT INTO Semester VALUES ('2667',100767,'Bis 2667')\g INSERT INTO Semester VALUES ('2667',1534,'SS 2667')\g INSERT INTO Semester VALUES ('2667/2668',1535,'WS 2667/2668')\g INSERT INTO Semester VALUES ('2668',50768,'Ab 2668')\g INSERT INTO Semester VALUES ('2668',100768,'Bis 2668')\g INSERT INTO Semester VALUES ('2668',1536,'SS 2668')\g INSERT INTO Semester VALUES ('2668/2669',1537,'WS 2668/2669')\g INSERT INTO Semester VALUES ('2669',50769,'Ab 2669')\g INSERT INTO Semester VALUES ('2669',100769,'Bis 2669')\g INSERT INTO Semester VALUES ('2669',1538,'SS 2669')\g INSERT INTO Semester VALUES ('2669/2670',1539,'WS 2669/2670')\g INSERT INTO Semester VALUES ('2670',50770,'Ab 2670')\g INSERT INTO Semester VALUES ('2670',100770,'Bis 2670')\g INSERT INTO Semester VALUES ('2670',1540,'SS 2670')\g INSERT INTO Semester VALUES ('2670/2671',1541,'WS 2670/2671')\g INSERT INTO Semester VALUES ('2671',50771,'Ab 2671')\g INSERT INTO Semester VALUES ('2671',100771,'Bis 2671')\g INSERT INTO Semester VALUES ('2671',1542,'SS 2671')\g INSERT INTO Semester VALUES ('2671/2672',1543,'WS 2671/2672')\g INSERT INTO Semester VALUES ('2672',50772,'Ab 2672')\g INSERT INTO Semester VALUES ('2672',100772,'Bis 2672')\g INSERT INTO Semester VALUES ('2672',1544,'SS 2672')\g INSERT INTO Semester VALUES ('2672/2673',1545,'WS 2672/2673')\g INSERT INTO Semester VALUES ('2673',50773,'Ab 2673')\g INSERT INTO Semester VALUES ('2673',100773,'Bis 2673')\g INSERT INTO Semester VALUES ('2673',1546,'SS 2673')\g INSERT INTO Semester VALUES ('2673/2674',1547,'WS 2673/2674')\g INSERT INTO Semester VALUES ('2674',50774,'Ab 2674')\g INSERT INTO Semester VALUES ('2674',100774,'Bis 2674')\g INSERT INTO Semester VALUES ('2674',1548,'SS 2674')\g INSERT INTO Semester VALUES ('2674/2675',1549,'WS 2674/2675')\g INSERT INTO Semester VALUES ('2675',50775,'Ab 2675')\g INSERT INTO Semester VALUES ('2675',100775,'Bis 2675')\g INSERT INTO Semester VALUES ('2675',1550,'SS 2675')\g INSERT INTO Semester VALUES ('2675/2676',1551,'WS 2675/2676')\g INSERT INTO Semester VALUES ('2676',50776,'Ab 2676')\g INSERT INTO Semester VALUES ('2676',100776,'Bis 2676')\g INSERT INTO Semester VALUES ('2676',1552,'SS 2676')\g INSERT INTO Semester VALUES ('2676/2677',1553,'WS 2676/2677')\g INSERT INTO Semester VALUES ('2677',50777,'Ab 2677')\g INSERT INTO Semester VALUES ('2677',100777,'Bis 2677')\g INSERT INTO Semester VALUES ('2677',1554,'SS 2677')\g INSERT INTO Semester VALUES ('2677/2678',1555,'WS 2677/2678')\g INSERT INTO Semester VALUES ('2678',50778,'Ab 2678')\g INSERT INTO Semester VALUES ('2678',100778,'Bis 2678')\g INSERT INTO Semester VALUES ('2678',1556,'SS 2678')\g INSERT INTO Semester VALUES ('2678/2679',1557,'WS 2678/2679')\g INSERT INTO Semester VALUES ('2679',50779,'Ab 2679')\g INSERT INTO Semester VALUES ('2679',100779,'Bis 2679')\g INSERT INTO Semester VALUES ('2679',1558,'SS 2679')\g INSERT INTO Semester VALUES ('2679/2680',1559,'WS 2679/2680')\g INSERT INTO Semester VALUES ('2680',50780,'Ab 2680')\g INSERT INTO Semester VALUES ('2680',100780,'Bis 2680')\g INSERT INTO Semester VALUES ('2680',1560,'SS 2680')\g INSERT INTO Semester VALUES ('2680/2681',1561,'WS 2680/2681')\g INSERT INTO Semester VALUES ('2681',50781,'Ab 2681')\g INSERT INTO Semester VALUES ('2681',100781,'Bis 2681')\g INSERT INTO Semester VALUES ('2681',1562,'SS 2681')\g INSERT INTO Semester VALUES ('2681/2682',1563,'WS 2681/2682')\g INSERT INTO Semester VALUES ('2682',50782,'Ab 2682')\g INSERT INTO Semester VALUES ('2682',100782,'Bis 2682')\g INSERT INTO Semester VALUES ('2682',1564,'SS 2682')\g INSERT INTO Semester VALUES ('2682/2683',1565,'WS 2682/2683')\g INSERT INTO Semester VALUES ('2683',50783,'Ab 2683')\g INSERT INTO Semester VALUES ('2683',100783,'Bis 2683')\g INSERT INTO Semester VALUES ('2683',1566,'SS 2683')\g INSERT INTO Semester VALUES ('2683/2684',1567,'WS 2683/2684')\g INSERT INTO Semester VALUES ('2684',50784,'Ab 2684')\g INSERT INTO Semester VALUES ('2684',100784,'Bis 2684')\g INSERT INTO Semester VALUES ('2684',1568,'SS 2684')\g INSERT INTO Semester VALUES ('2684/2685',1569,'WS 2684/2685')\g INSERT INTO Semester VALUES ('2685',50785,'Ab 2685')\g INSERT INTO Semester VALUES ('2685',100785,'Bis 2685')\g INSERT INTO Semester VALUES ('2685',1570,'SS 2685')\g INSERT INTO Semester VALUES ('2685/2686',1571,'WS 2685/2686')\g INSERT INTO Semester VALUES ('2686',50786,'Ab 2686')\g INSERT INTO Semester VALUES ('2686',100786,'Bis 2686')\g INSERT INTO Semester VALUES ('2686',1572,'SS 2686')\g INSERT INTO Semester VALUES ('2686/2687',1573,'WS 2686/2687')\g INSERT INTO Semester VALUES ('2687',50787,'Ab 2687')\g INSERT INTO Semester VALUES ('2687',100787,'Bis 2687')\g INSERT INTO Semester VALUES ('2687',1574,'SS 2687')\g INSERT INTO Semester VALUES ('2687/2688',1575,'WS 2687/2688')\g INSERT INTO Semester VALUES ('2688',50788,'Ab 2688')\g INSERT INTO Semester VALUES ('2688',100788,'Bis 2688')\g INSERT INTO Semester VALUES ('2688',1576,'SS 2688')\g INSERT INTO Semester VALUES ('2688/2689',1577,'WS 2688/2689')\g INSERT INTO Semester VALUES ('2689',50789,'Ab 2689')\g INSERT INTO Semester VALUES ('2689',100789,'Bis 2689')\g INSERT INTO Semester VALUES ('2689',1578,'SS 2689')\g INSERT INTO Semester VALUES ('2689/2690',1579,'WS 2689/2690')\g INSERT INTO Semester VALUES ('2690',50790,'Ab 2690')\g INSERT INTO Semester VALUES ('2690',100790,'Bis 2690')\g INSERT INTO Semester VALUES ('2690',1580,'SS 2690')\g INSERT INTO Semester VALUES ('2690/2691',1581,'WS 2690/2691')\g INSERT INTO Semester VALUES ('2691',50791,'Ab 2691')\g INSERT INTO Semester VALUES ('2691',100791,'Bis 2691')\g INSERT INTO Semester VALUES ('2691',1582,'SS 2691')\g INSERT INTO Semester VALUES ('2691/2692',1583,'WS 2691/2692')\g INSERT INTO Semester VALUES ('2692',50792,'Ab 2692')\g INSERT INTO Semester VALUES ('2692',100792,'Bis 2692')\g INSERT INTO Semester VALUES ('2692',1584,'SS 2692')\g INSERT INTO Semester VALUES ('2692/2693',1585,'WS 2692/2693')\g INSERT INTO Semester VALUES ('2693',50793,'Ab 2693')\g INSERT INTO Semester VALUES ('2693',100793,'Bis 2693')\g INSERT INTO Semester VALUES ('2693',1586,'SS 2693')\g INSERT INTO Semester VALUES ('2693/2694',1587,'WS 2693/2694')\g INSERT INTO Semester VALUES ('2694',50794,'Ab 2694')\g INSERT INTO Semester VALUES ('2694',100794,'Bis 2694')\g INSERT INTO Semester VALUES ('2694',1588,'SS 2694')\g INSERT INTO Semester VALUES ('2694/2695',1589,'WS 2694/2695')\g INSERT INTO Semester VALUES ('2695',50795,'Ab 2695')\g INSERT INTO Semester VALUES ('2695',100795,'Bis 2695')\g INSERT INTO Semester VALUES ('2695',1590,'SS 2695')\g INSERT INTO Semester VALUES ('2695/2696',1591,'WS 2695/2696')\g INSERT INTO Semester VALUES ('2696',50796,'Ab 2696')\g INSERT INTO Semester VALUES ('2696',100796,'Bis 2696')\g INSERT INTO Semester VALUES ('2696',1592,'SS 2696')\g INSERT INTO Semester VALUES ('2696/2697',1593,'WS 2696/2697')\g INSERT INTO Semester VALUES ('2697',50797,'Ab 2697')\g INSERT INTO Semester VALUES ('2697',100797,'Bis 2697')\g INSERT INTO Semester VALUES ('2697',1594,'SS 2697')\g INSERT INTO Semester VALUES ('2697/2698',1595,'WS 2697/2698')\g INSERT INTO Semester VALUES ('2698',50798,'Ab 2698')\g INSERT INTO Semester VALUES ('2698',100798,'Bis 2698')\g INSERT INTO Semester VALUES ('2698',1596,'SS 2698')\g INSERT INTO Semester VALUES ('2698/2699',1597,'WS 2698/2699')\g INSERT INTO Semester VALUES ('2699',50799,'Ab 2699')\g INSERT INTO Semester VALUES ('2699',100799,'Bis 2699')\g INSERT INTO Semester VALUES ('2699',1598,'SS 2699')\g INSERT INTO Semester VALUES ('2699/2700',1599,'WS 2699/2700')\g INSERT INTO Semester VALUES ('2700',50800,'Ab 2700')\g INSERT INTO Semester VALUES ('2700',100800,'Bis 2700')\g INSERT INTO Semester VALUES ('2700',1600,'SS 2700')\g INSERT INTO Semester VALUES ('2700/2701',1601,'WS 2700/2701')\g INSERT INTO Semester VALUES ('2701',50801,'Ab 2701')\g INSERT INTO Semester VALUES ('2701',100801,'Bis 2701')\g INSERT INTO Semester VALUES ('2701',1602,'SS 2701')\g INSERT INTO Semester VALUES ('2701/2702',1603,'WS 2701/2702')\g INSERT INTO Semester VALUES ('2702',50802,'Ab 2702')\g INSERT INTO Semester VALUES ('2702',100802,'Bis 2702')\g INSERT INTO Semester VALUES ('2702',1604,'SS 2702')\g INSERT INTO Semester VALUES ('2702/2703',1605,'WS 2702/2703')\g INSERT INTO Semester VALUES ('2703',50803,'Ab 2703')\g INSERT INTO Semester VALUES ('2703',100803,'Bis 2703')\g INSERT INTO Semester VALUES ('2703',1606,'SS 2703')\g INSERT INTO Semester VALUES ('2703/2704',1607,'WS 2703/2704')\g INSERT INTO Semester VALUES ('2704',50804,'Ab 2704')\g INSERT INTO Semester VALUES ('2704',100804,'Bis 2704')\g INSERT INTO Semester VALUES ('2704',1608,'SS 2704')\g INSERT INTO Semester VALUES ('2704/2705',1609,'WS 2704/2705')\g INSERT INTO Semester VALUES ('2705',50805,'Ab 2705')\g INSERT INTO Semester VALUES ('2705',100805,'Bis 2705')\g INSERT INTO Semester VALUES ('2705',1610,'SS 2705')\g INSERT INTO Semester VALUES ('2705/2706',1611,'WS 2705/2706')\g INSERT INTO Semester VALUES ('2706',50806,'Ab 2706')\g INSERT INTO Semester VALUES ('2706',100806,'Bis 2706')\g INSERT INTO Semester VALUES ('2706',1612,'SS 2706')\g INSERT INTO Semester VALUES ('2706/2707',1613,'WS 2706/2707')\g INSERT INTO Semester VALUES ('2707',50807,'Ab 2707')\g INSERT INTO Semester VALUES ('2707',100807,'Bis 2707')\g INSERT INTO Semester VALUES ('2707',1614,'SS 2707')\g INSERT INTO Semester VALUES ('2707/2708',1615,'WS 2707/2708')\g INSERT INTO Semester VALUES ('2708',50808,'Ab 2708')\g INSERT INTO Semester VALUES ('2708',100808,'Bis 2708')\g INSERT INTO Semester VALUES ('2708',1616,'SS 2708')\g INSERT INTO Semester VALUES ('2708/2709',1617,'WS 2708/2709')\g INSERT INTO Semester VALUES ('2709',50809,'Ab 2709')\g INSERT INTO Semester VALUES ('2709',100809,'Bis 2709')\g INSERT INTO Semester VALUES ('2709',1618,'SS 2709')\g INSERT INTO Semester VALUES ('2709/2710',1619,'WS 2709/2710')\g INSERT INTO Semester VALUES ('2710',50810,'Ab 2710')\g INSERT INTO Semester VALUES ('2710',100810,'Bis 2710')\g INSERT INTO Semester VALUES ('2710',1620,'SS 2710')\g INSERT INTO Semester VALUES ('2710/2711',1621,'WS 2710/2711')\g INSERT INTO Semester VALUES ('2711',50811,'Ab 2711')\g INSERT INTO Semester VALUES ('2711',100811,'Bis 2711')\g INSERT INTO Semester VALUES ('2711',1622,'SS 2711')\g INSERT INTO Semester VALUES ('2711/2712',1623,'WS 2711/2712')\g INSERT INTO Semester VALUES ('2712',50812,'Ab 2712')\g INSERT INTO Semester VALUES ('2712',100812,'Bis 2712')\g INSERT INTO Semester VALUES ('2712',1624,'SS 2712')\g INSERT INTO Semester VALUES ('2712/2713',1625,'WS 2712/2713')\g INSERT INTO Semester VALUES ('2713',50813,'Ab 2713')\g INSERT INTO Semester VALUES ('2713',100813,'Bis 2713')\g INSERT INTO Semester VALUES ('2713',1626,'SS 2713')\g INSERT INTO Semester VALUES ('2713/2714',1627,'WS 2713/2714')\g INSERT INTO Semester VALUES ('2714',50814,'Ab 2714')\g INSERT INTO Semester VALUES ('2714',100814,'Bis 2714')\g INSERT INTO Semester VALUES ('2714',1628,'SS 2714')\g INSERT INTO Semester VALUES ('2714/2715',1629,'WS 2714/2715')\g INSERT INTO Semester VALUES ('2715',50815,'Ab 2715')\g INSERT INTO Semester VALUES ('2715',100815,'Bis 2715')\g INSERT INTO Semester VALUES ('2715',1630,'SS 2715')\g INSERT INTO Semester VALUES ('2715/2716',1631,'WS 2715/2716')\g INSERT INTO Semester VALUES ('2716',50816,'Ab 2716')\g INSERT INTO Semester VALUES ('2716',100816,'Bis 2716')\g INSERT INTO Semester VALUES ('2716',1632,'SS 2716')\g INSERT INTO Semester VALUES ('2716/2717',1633,'WS 2716/2717')\g INSERT INTO Semester VALUES ('2717',50817,'Ab 2717')\g INSERT INTO Semester VALUES ('2717',100817,'Bis 2717')\g INSERT INTO Semester VALUES ('2717',1634,'SS 2717')\g INSERT INTO Semester VALUES ('2717/2718',1635,'WS 2717/2718')\g INSERT INTO Semester VALUES ('2718',50818,'Ab 2718')\g INSERT INTO Semester VALUES ('2718',100818,'Bis 2718')\g INSERT INTO Semester VALUES ('2718',1636,'SS 2718')\g INSERT INTO Semester VALUES ('2718/2719',1637,'WS 2718/2719')\g INSERT INTO Semester VALUES ('2719',50819,'Ab 2719')\g INSERT INTO Semester VALUES ('2719',100819,'Bis 2719')\g INSERT INTO Semester VALUES ('2719',1638,'SS 2719')\g INSERT INTO Semester VALUES ('2719/2720',1639,'WS 2719/2720')\g INSERT INTO Semester VALUES ('2720',50820,'Ab 2720')\g INSERT INTO Semester VALUES ('2720',100820,'Bis 2720')\g INSERT INTO Semester VALUES ('2720',1640,'SS 2720')\g INSERT INTO Semester VALUES ('2720/2721',1641,'WS 2720/2721')\g INSERT INTO Semester VALUES ('2721',50821,'Ab 2721')\g INSERT INTO Semester VALUES ('2721',100821,'Bis 2721')\g INSERT INTO Semester VALUES ('2721',1642,'SS 2721')\g INSERT INTO Semester VALUES ('2721/2722',1643,'WS 2721/2722')\g INSERT INTO Semester VALUES ('2722',50822,'Ab 2722')\g INSERT INTO Semester VALUES ('2722',100822,'Bis 2722')\g INSERT INTO Semester VALUES ('2722',1644,'SS 2722')\g INSERT INTO Semester VALUES ('2722/2723',1645,'WS 2722/2723')\g INSERT INTO Semester VALUES ('2723',50823,'Ab 2723')\g INSERT INTO Semester VALUES ('2723',100823,'Bis 2723')\g INSERT INTO Semester VALUES ('2723',1646,'SS 2723')\g INSERT INTO Semester VALUES ('2723/2724',1647,'WS 2723/2724')\g INSERT INTO Semester VALUES ('2724',50824,'Ab 2724')\g INSERT INTO Semester VALUES ('2724',100824,'Bis 2724')\g INSERT INTO Semester VALUES ('2724',1648,'SS 2724')\g INSERT INTO Semester VALUES ('2724/2725',1649,'WS 2724/2725')\g INSERT INTO Semester VALUES ('2725',50825,'Ab 2725')\g INSERT INTO Semester VALUES ('2725',100825,'Bis 2725')\g INSERT INTO Semester VALUES ('2725',1650,'SS 2725')\g INSERT INTO Semester VALUES ('2725/2726',1651,'WS 2725/2726')\g INSERT INTO Semester VALUES ('2726',50826,'Ab 2726')\g INSERT INTO Semester VALUES ('2726',100826,'Bis 2726')\g INSERT INTO Semester VALUES ('2726',1652,'SS 2726')\g INSERT INTO Semester VALUES ('2726/2727',1653,'WS 2726/2727')\g INSERT INTO Semester VALUES ('2727',50827,'Ab 2727')\g INSERT INTO Semester VALUES ('2727',100827,'Bis 2727')\g INSERT INTO Semester VALUES ('2727',1654,'SS 2727')\g INSERT INTO Semester VALUES ('2727/2728',1655,'WS 2727/2728')\g INSERT INTO Semester VALUES ('2728',50828,'Ab 2728')\g INSERT INTO Semester VALUES ('2728',100828,'Bis 2728')\g INSERT INTO Semester VALUES ('2728',1656,'SS 2728')\g INSERT INTO Semester VALUES ('2728/2729',1657,'WS 2728/2729')\g INSERT INTO Semester VALUES ('2729',50829,'Ab 2729')\g INSERT INTO Semester VALUES ('2729',100829,'Bis 2729')\g INSERT INTO Semester VALUES ('2729',1658,'SS 2729')\g INSERT INTO Semester VALUES ('2729/2730',1659,'WS 2729/2730')\g INSERT INTO Semester VALUES ('2730',50830,'Ab 2730')\g INSERT INTO Semester VALUES ('2730',100830,'Bis 2730')\g INSERT INTO Semester VALUES ('2730',1660,'SS 2730')\g INSERT INTO Semester VALUES ('2730/2731',1661,'WS 2730/2731')\g INSERT INTO Semester VALUES ('2731',50831,'Ab 2731')\g INSERT INTO Semester VALUES ('2731',100831,'Bis 2731')\g INSERT INTO Semester VALUES ('2731',1662,'SS 2731')\g INSERT INTO Semester VALUES ('2731/2732',1663,'WS 2731/2732')\g INSERT INTO Semester VALUES ('2732',50832,'Ab 2732')\g INSERT INTO Semester VALUES ('2732',100832,'Bis 2732')\g INSERT INTO Semester VALUES ('2732',1664,'SS 2732')\g INSERT INTO Semester VALUES ('2732/2733',1665,'WS 2732/2733')\g INSERT INTO Semester VALUES ('2733',50833,'Ab 2733')\g INSERT INTO Semester VALUES ('2733',100833,'Bis 2733')\g INSERT INTO Semester VALUES ('2733',1666,'SS 2733')\g INSERT INTO Semester VALUES ('2733/2734',1667,'WS 2733/2734')\g INSERT INTO Semester VALUES ('2734',50834,'Ab 2734')\g INSERT INTO Semester VALUES ('2734',100834,'Bis 2734')\g INSERT INTO Semester VALUES ('2734',1668,'SS 2734')\g INSERT INTO Semester VALUES ('2734/2735',1669,'WS 2734/2735')\g INSERT INTO Semester VALUES ('2735',50835,'Ab 2735')\g INSERT INTO Semester VALUES ('2735',100835,'Bis 2735')\g INSERT INTO Semester VALUES ('2735',1670,'SS 2735')\g INSERT INTO Semester VALUES ('2735/2736',1671,'WS 2735/2736')\g INSERT INTO Semester VALUES ('2736',50836,'Ab 2736')\g INSERT INTO Semester VALUES ('2736',100836,'Bis 2736')\g INSERT INTO Semester VALUES ('2736',1672,'SS 2736')\g INSERT INTO Semester VALUES ('2736/2737',1673,'WS 2736/2737')\g INSERT INTO Semester VALUES ('2737',50837,'Ab 2737')\g INSERT INTO Semester VALUES ('2737',100837,'Bis 2737')\g INSERT INTO Semester VALUES ('2737',1674,'SS 2737')\g INSERT INTO Semester VALUES ('2737/2738',1675,'WS 2737/2738')\g INSERT INTO Semester VALUES ('2738',50838,'Ab 2738')\g INSERT INTO Semester VALUES ('2738',100838,'Bis 2738')\g INSERT INTO Semester VALUES ('2738',1676,'SS 2738')\g INSERT INTO Semester VALUES ('2738/2739',1677,'WS 2738/2739')\g INSERT INTO Semester VALUES ('2739',50839,'Ab 2739')\g INSERT INTO Semester VALUES ('2739',100839,'Bis 2739')\g INSERT INTO Semester VALUES ('2739',1678,'SS 2739')\g INSERT INTO Semester VALUES ('2739/2740',1679,'WS 2739/2740')\g INSERT INTO Semester VALUES ('2740',50840,'Ab 2740')\g INSERT INTO Semester VALUES ('2740',100840,'Bis 2740')\g INSERT INTO Semester VALUES ('2740',1680,'SS 2740')\g INSERT INTO Semester VALUES ('2740/2741',1681,'WS 2740/2741')\g INSERT INTO Semester VALUES ('2741',50841,'Ab 2741')\g INSERT INTO Semester VALUES ('2741',100841,'Bis 2741')\g INSERT INTO Semester VALUES ('2741',1682,'SS 2741')\g INSERT INTO Semester VALUES ('2741/2742',1683,'WS 2741/2742')\g INSERT INTO Semester VALUES ('2742',50842,'Ab 2742')\g INSERT INTO Semester VALUES ('2742',100842,'Bis 2742')\g INSERT INTO Semester VALUES ('2742',1684,'SS 2742')\g INSERT INTO Semester VALUES ('2742/2743',1685,'WS 2742/2743')\g INSERT INTO Semester VALUES ('2743',50843,'Ab 2743')\g INSERT INTO Semester VALUES ('2743',100843,'Bis 2743')\g INSERT INTO Semester VALUES ('2743',1686,'SS 2743')\g INSERT INTO Semester VALUES ('2743/2744',1687,'WS 2743/2744')\g INSERT INTO Semester VALUES ('2744',50844,'Ab 2744')\g INSERT INTO Semester VALUES ('2744',100844,'Bis 2744')\g INSERT INTO Semester VALUES ('2744',1688,'SS 2744')\g INSERT INTO Semester VALUES ('2744/2745',1689,'WS 2744/2745')\g INSERT INTO Semester VALUES ('2745',50845,'Ab 2745')\g INSERT INTO Semester VALUES ('2745',100845,'Bis 2745')\g INSERT INTO Semester VALUES ('2745',1690,'SS 2745')\g INSERT INTO Semester VALUES ('2745/2746',1691,'WS 2745/2746')\g INSERT INTO Semester VALUES ('2746',50846,'Ab 2746')\g INSERT INTO Semester VALUES ('2746',100846,'Bis 2746')\g INSERT INTO Semester VALUES ('2746',1692,'SS 2746')\g INSERT INTO Semester VALUES ('2746/2747',1693,'WS 2746/2747')\g INSERT INTO Semester VALUES ('2747',50847,'Ab 2747')\g INSERT INTO Semester VALUES ('2747',100847,'Bis 2747')\g INSERT INTO Semester VALUES ('2747',1694,'SS 2747')\g INSERT INTO Semester VALUES ('2747/2748',1695,'WS 2747/2748')\g INSERT INTO Semester VALUES ('2748',50848,'Ab 2748')\g INSERT INTO Semester VALUES ('2748',100848,'Bis 2748')\g INSERT INTO Semester VALUES ('2748',1696,'SS 2748')\g INSERT INTO Semester VALUES ('2748/2749',1697,'WS 2748/2749')\g INSERT INTO Semester VALUES ('2749',50849,'Ab 2749')\g INSERT INTO Semester VALUES ('2749',100849,'Bis 2749')\g INSERT INTO Semester VALUES ('2749',1698,'SS 2749')\g INSERT INTO Semester VALUES ('2749/2750',1699,'WS 2749/2750')\g INSERT INTO Semester VALUES ('2750',50850,'Ab 2750')\g INSERT INTO Semester VALUES ('2750',100850,'Bis 2750')\g INSERT INTO Semester VALUES ('2750',1700,'SS 2750')\g INSERT INTO Semester VALUES ('2750/2751',1701,'WS 2750/2751')\g INSERT INTO Semester VALUES ('2751',50851,'Ab 2751')\g INSERT INTO Semester VALUES ('2751',100851,'Bis 2751')\g INSERT INTO Semester VALUES ('2751',1702,'SS 2751')\g INSERT INTO Semester VALUES ('2751/2752',1703,'WS 2751/2752')\g INSERT INTO Semester VALUES ('2752',50852,'Ab 2752')\g INSERT INTO Semester VALUES ('2752',100852,'Bis 2752')\g INSERT INTO Semester VALUES ('2752',1704,'SS 2752')\g INSERT INTO Semester VALUES ('2752/2753',1705,'WS 2752/2753')\g INSERT INTO Semester VALUES ('2753',50853,'Ab 2753')\g INSERT INTO Semester VALUES ('2753',100853,'Bis 2753')\g INSERT INTO Semester VALUES ('2753',1706,'SS 2753')\g INSERT INTO Semester VALUES ('2753/2754',1707,'WS 2753/2754')\g INSERT INTO Semester VALUES ('2754',50854,'Ab 2754')\g INSERT INTO Semester VALUES ('2754',100854,'Bis 2754')\g INSERT INTO Semester VALUES ('2754',1708,'SS 2754')\g INSERT INTO Semester VALUES ('2754/2755',1709,'WS 2754/2755')\g INSERT INTO Semester VALUES ('2755',50855,'Ab 2755')\g INSERT INTO Semester VALUES ('2755',100855,'Bis 2755')\g INSERT INTO Semester VALUES ('2755',1710,'SS 2755')\g INSERT INTO Semester VALUES ('2755/2756',1711,'WS 2755/2756')\g INSERT INTO Semester VALUES ('2756',50856,'Ab 2756')\g INSERT INTO Semester VALUES ('2756',100856,'Bis 2756')\g INSERT INTO Semester VALUES ('2756',1712,'SS 2756')\g INSERT INTO Semester VALUES ('2756/2757',1713,'WS 2756/2757')\g INSERT INTO Semester VALUES ('2757',50857,'Ab 2757')\g INSERT INTO Semester VALUES ('2757',100857,'Bis 2757')\g INSERT INTO Semester VALUES ('2757',1714,'SS 2757')\g INSERT INTO Semester VALUES ('2757/2758',1715,'WS 2757/2758')\g INSERT INTO Semester VALUES ('2758',50858,'Ab 2758')\g INSERT INTO Semester VALUES ('2758',100858,'Bis 2758')\g INSERT INTO Semester VALUES ('2758',1716,'SS 2758')\g INSERT INTO Semester VALUES ('2758/2759',1717,'WS 2758/2759')\g INSERT INTO Semester VALUES ('2759',50859,'Ab 2759')\g INSERT INTO Semester VALUES ('2759',100859,'Bis 2759')\g INSERT INTO Semester VALUES ('2759',1718,'SS 2759')\g INSERT INTO Semester VALUES ('2759/2760',1719,'WS 2759/2760')\g INSERT INTO Semester VALUES ('2760',50860,'Ab 2760')\g INSERT INTO Semester VALUES ('2760',100860,'Bis 2760')\g INSERT INTO Semester VALUES ('2760',1720,'SS 2760')\g INSERT INTO Semester VALUES ('2760/2761',1721,'WS 2760/2761')\g INSERT INTO Semester VALUES ('2761',50861,'Ab 2761')\g INSERT INTO Semester VALUES ('2761',100861,'Bis 2761')\g INSERT INTO Semester VALUES ('2761',1722,'SS 2761')\g INSERT INTO Semester VALUES ('2761/2762',1723,'WS 2761/2762')\g INSERT INTO Semester VALUES ('2762',50862,'Ab 2762')\g INSERT INTO Semester VALUES ('2762',100862,'Bis 2762')\g INSERT INTO Semester VALUES ('2762',1724,'SS 2762')\g INSERT INTO Semester VALUES ('2762/2763',1725,'WS 2762/2763')\g INSERT INTO Semester VALUES ('2763',50863,'Ab 2763')\g INSERT INTO Semester VALUES ('2763',100863,'Bis 2763')\g INSERT INTO Semester VALUES ('2763',1726,'SS 2763')\g INSERT INTO Semester VALUES ('2763/2764',1727,'WS 2763/2764')\g INSERT INTO Semester VALUES ('2764',50864,'Ab 2764')\g INSERT INTO Semester VALUES ('2764',100864,'Bis 2764')\g INSERT INTO Semester VALUES ('2764',1728,'SS 2764')\g INSERT INTO Semester VALUES ('2764/2765',1729,'WS 2764/2765')\g INSERT INTO Semester VALUES ('2765',50865,'Ab 2765')\g INSERT INTO Semester VALUES ('2765',100865,'Bis 2765')\g INSERT INTO Semester VALUES ('2765',1730,'SS 2765')\g INSERT INTO Semester VALUES ('2765/2766',1731,'WS 2765/2766')\g INSERT INTO Semester VALUES ('2766',50866,'Ab 2766')\g INSERT INTO Semester VALUES ('2766',100866,'Bis 2766')\g INSERT INTO Semester VALUES ('2766',1732,'SS 2766')\g INSERT INTO Semester VALUES ('2766/2767',1733,'WS 2766/2767')\g INSERT INTO Semester VALUES ('2767',50867,'Ab 2767')\g INSERT INTO Semester VALUES ('2767',100867,'Bis 2767')\g INSERT INTO Semester VALUES ('2767',1734,'SS 2767')\g INSERT INTO Semester VALUES ('2767/2768',1735,'WS 2767/2768')\g INSERT INTO Semester VALUES ('2768',50868,'Ab 2768')\g INSERT INTO Semester VALUES ('2768',100868,'Bis 2768')\g INSERT INTO Semester VALUES ('2768',1736,'SS 2768')\g INSERT INTO Semester VALUES ('2768/2769',1737,'WS 2768/2769')\g INSERT INTO Semester VALUES ('2769',50869,'Ab 2769')\g INSERT INTO Semester VALUES ('2769',100869,'Bis 2769')\g INSERT INTO Semester VALUES ('2769',1738,'SS 2769')\g INSERT INTO Semester VALUES ('2769/2770',1739,'WS 2769/2770')\g INSERT INTO Semester VALUES ('2770',50870,'Ab 2770')\g INSERT INTO Semester VALUES ('2770',100870,'Bis 2770')\g INSERT INTO Semester VALUES ('2770',1740,'SS 2770')\g INSERT INTO Semester VALUES ('2770/2771',1741,'WS 2770/2771')\g INSERT INTO Semester VALUES ('2771',50871,'Ab 2771')\g INSERT INTO Semester VALUES ('2771',100871,'Bis 2771')\g INSERT INTO Semester VALUES ('2771',1742,'SS 2771')\g INSERT INTO Semester VALUES ('2771/2772',1743,'WS 2771/2772')\g INSERT INTO Semester VALUES ('2772',50872,'Ab 2772')\g INSERT INTO Semester VALUES ('2772',100872,'Bis 2772')\g INSERT INTO Semester VALUES ('2772',1744,'SS 2772')\g INSERT INTO Semester VALUES ('2772/2773',1745,'WS 2772/2773')\g INSERT INTO Semester VALUES ('2773',50873,'Ab 2773')\g INSERT INTO Semester VALUES ('2773',100873,'Bis 2773')\g INSERT INTO Semester VALUES ('2773',1746,'SS 2773')\g INSERT INTO Semester VALUES ('2773/2774',1747,'WS 2773/2774')\g INSERT INTO Semester VALUES ('2774',50874,'Ab 2774')\g INSERT INTO Semester VALUES ('2774',100874,'Bis 2774')\g INSERT INTO Semester VALUES ('2774',1748,'SS 2774')\g INSERT INTO Semester VALUES ('2774/2775',1749,'WS 2774/2775')\g INSERT INTO Semester VALUES ('2775',50875,'Ab 2775')\g INSERT INTO Semester VALUES ('2775',100875,'Bis 2775')\g INSERT INTO Semester VALUES ('2775',1750,'SS 2775')\g INSERT INTO Semester VALUES ('2775/2776',1751,'WS 2775/2776')\g INSERT INTO Semester VALUES ('2776',50876,'Ab 2776')\g INSERT INTO Semester VALUES ('2776',100876,'Bis 2776')\g INSERT INTO Semester VALUES ('2776',1752,'SS 2776')\g INSERT INTO Semester VALUES ('2776/2777',1753,'WS 2776/2777')\g INSERT INTO Semester VALUES ('2777',50877,'Ab 2777')\g INSERT INTO Semester VALUES ('2777',100877,'Bis 2777')\g INSERT INTO Semester VALUES ('2777',1754,'SS 2777')\g INSERT INTO Semester VALUES ('2777/2778',1755,'WS 2777/2778')\g INSERT INTO Semester VALUES ('2778',50878,'Ab 2778')\g INSERT INTO Semester VALUES ('2778',100878,'Bis 2778')\g INSERT INTO Semester VALUES ('2778',1756,'SS 2778')\g INSERT INTO Semester VALUES ('2778/2779',1757,'WS 2778/2779')\g INSERT INTO Semester VALUES ('2779',50879,'Ab 2779')\g INSERT INTO Semester VALUES ('2779',100879,'Bis 2779')\g INSERT INTO Semester VALUES ('2779',1758,'SS 2779')\g INSERT INTO Semester VALUES ('2779/2780',1759,'WS 2779/2780')\g INSERT INTO Semester VALUES ('2780',50880,'Ab 2780')\g INSERT INTO Semester VALUES ('2780',100880,'Bis 2780')\g INSERT INTO Semester VALUES ('2780',1760,'SS 2780')\g INSERT INTO Semester VALUES ('2780/2781',1761,'WS 2780/2781')\g INSERT INTO Semester VALUES ('2781',50881,'Ab 2781')\g INSERT INTO Semester VALUES ('2781',100881,'Bis 2781')\g INSERT INTO Semester VALUES ('2781',1762,'SS 2781')\g INSERT INTO Semester VALUES ('2781/2782',1763,'WS 2781/2782')\g INSERT INTO Semester VALUES ('2782',50882,'Ab 2782')\g INSERT INTO Semester VALUES ('2782',100882,'Bis 2782')\g INSERT INTO Semester VALUES ('2782',1764,'SS 2782')\g INSERT INTO Semester VALUES ('2782/2783',1765,'WS 2782/2783')\g INSERT INTO Semester VALUES ('2783',50883,'Ab 2783')\g INSERT INTO Semester VALUES ('2783',100883,'Bis 2783')\g INSERT INTO Semester VALUES ('2783',1766,'SS 2783')\g INSERT INTO Semester VALUES ('2783/2784',1767,'WS 2783/2784')\g INSERT INTO Semester VALUES ('2784',50884,'Ab 2784')\g INSERT INTO Semester VALUES ('2784',100884,'Bis 2784')\g INSERT INTO Semester VALUES ('2784',1768,'SS 2784')\g INSERT INTO Semester VALUES ('2784/2785',1769,'WS 2784/2785')\g INSERT INTO Semester VALUES ('2785',50885,'Ab 2785')\g INSERT INTO Semester VALUES ('2785',100885,'Bis 2785')\g INSERT INTO Semester VALUES ('2785',1770,'SS 2785')\g INSERT INTO Semester VALUES ('2785/2786',1771,'WS 2785/2786')\g INSERT INTO Semester VALUES ('2786',50886,'Ab 2786')\g INSERT INTO Semester VALUES ('2786',100886,'Bis 2786')\g INSERT INTO Semester VALUES ('2786',1772,'SS 2786')\g INSERT INTO Semester VALUES ('2786/2787',1773,'WS 2786/2787')\g INSERT INTO Semester VALUES ('2787',50887,'Ab 2787')\g INSERT INTO Semester VALUES ('2787',100887,'Bis 2787')\g INSERT INTO Semester VALUES ('2787',1774,'SS 2787')\g INSERT INTO Semester VALUES ('2787/2788',1775,'WS 2787/2788')\g INSERT INTO Semester VALUES ('2788',50888,'Ab 2788')\g INSERT INTO Semester VALUES ('2788',100888,'Bis 2788')\g INSERT INTO Semester VALUES ('2788',1776,'SS 2788')\g INSERT INTO Semester VALUES ('2788/2789',1777,'WS 2788/2789')\g INSERT INTO Semester VALUES ('2789',50889,'Ab 2789')\g INSERT INTO Semester VALUES ('2789',100889,'Bis 2789')\g INSERT INTO Semester VALUES ('2789',1778,'SS 2789')\g INSERT INTO Semester VALUES ('2789/2790',1779,'WS 2789/2790')\g INSERT INTO Semester VALUES ('2790',50890,'Ab 2790')\g INSERT INTO Semester VALUES ('2790',100890,'Bis 2790')\g INSERT INTO Semester VALUES ('2790',1780,'SS 2790')\g INSERT INTO Semester VALUES ('2790/2791',1781,'WS 2790/2791')\g INSERT INTO Semester VALUES ('2791',50891,'Ab 2791')\g INSERT INTO Semester VALUES ('2791',100891,'Bis 2791')\g INSERT INTO Semester VALUES ('2791',1782,'SS 2791')\g INSERT INTO Semester VALUES ('2791/2792',1783,'WS 2791/2792')\g INSERT INTO Semester VALUES ('2792',50892,'Ab 2792')\g INSERT INTO Semester VALUES ('2792',100892,'Bis 2792')\g INSERT INTO Semester VALUES ('2792',1784,'SS 2792')\g INSERT INTO Semester VALUES ('2792/2793',1785,'WS 2792/2793')\g INSERT INTO Semester VALUES ('2793',50893,'Ab 2793')\g INSERT INTO Semester VALUES ('2793',100893,'Bis 2793')\g INSERT INTO Semester VALUES ('2793',1786,'SS 2793')\g INSERT INTO Semester VALUES ('2793/2794',1787,'WS 2793/2794')\g INSERT INTO Semester VALUES ('2794',50894,'Ab 2794')\g INSERT INTO Semester VALUES ('2794',100894,'Bis 2794')\g INSERT INTO Semester VALUES ('2794',1788,'SS 2794')\g INSERT INTO Semester VALUES ('2794/2795',1789,'WS 2794/2795')\g INSERT INTO Semester VALUES ('2795',50895,'Ab 2795')\g INSERT INTO Semester VALUES ('2795',100895,'Bis 2795')\g INSERT INTO Semester VALUES ('2795',1790,'SS 2795')\g INSERT INTO Semester VALUES ('2795/2796',1791,'WS 2795/2796')\g INSERT INTO Semester VALUES ('2796',50896,'Ab 2796')\g INSERT INTO Semester VALUES ('2796',100896,'Bis 2796')\g INSERT INTO Semester VALUES ('2796',1792,'SS 2796')\g INSERT INTO Semester VALUES ('2796/2797',1793,'WS 2796/2797')\g INSERT INTO Semester VALUES ('2797',50897,'Ab 2797')\g INSERT INTO Semester VALUES ('2797',100897,'Bis 2797')\g INSERT INTO Semester VALUES ('2797',1794,'SS 2797')\g INSERT INTO Semester VALUES ('2797/2798',1795,'WS 2797/2798')\g INSERT INTO Semester VALUES ('2798',50898,'Ab 2798')\g INSERT INTO Semester VALUES ('2798',100898,'Bis 2798')\g INSERT INTO Semester VALUES ('2798',1796,'SS 2798')\g INSERT INTO Semester VALUES ('2798/2799',1797,'WS 2798/2799')\g INSERT INTO Semester VALUES ('2799',50899,'Ab 2799')\g INSERT INTO Semester VALUES ('2799',100899,'Bis 2799')\g INSERT INTO Semester VALUES ('2799',1798,'SS 2799')\g INSERT INTO Semester VALUES ('2799/2800',1799,'WS 2799/2800')\g INSERT INTO Semester VALUES ('2800',50900,'Ab 2800')\g INSERT INTO Semester VALUES ('2800',100900,'Bis 2800')\g INSERT INTO Semester VALUES ('2800',1800,'SS 2800')\g INSERT INTO Semester VALUES ('2800/2801',1801,'WS 2800/2801')\g INSERT INTO Semester VALUES ('2801',50901,'Ab 2801')\g INSERT INTO Semester VALUES ('2801',100901,'Bis 2801')\g INSERT INTO Semester VALUES ('2801',1802,'SS 2801')\g INSERT INTO Semester VALUES ('2801/2802',1803,'WS 2801/2802')\g INSERT INTO Semester VALUES ('2802',50902,'Ab 2802')\g INSERT INTO Semester VALUES ('2802',100902,'Bis 2802')\g INSERT INTO Semester VALUES ('2802',1804,'SS 2802')\g INSERT INTO Semester VALUES ('2802/2803',1805,'WS 2802/2803')\g INSERT INTO Semester VALUES ('2803',50903,'Ab 2803')\g INSERT INTO Semester VALUES ('2803',100903,'Bis 2803')\g INSERT INTO Semester VALUES ('2803',1806,'SS 2803')\g INSERT INTO Semester VALUES ('2803/2804',1807,'WS 2803/2804')\g INSERT INTO Semester VALUES ('2804',50904,'Ab 2804')\g INSERT INTO Semester VALUES ('2804',100904,'Bis 2804')\g INSERT INTO Semester VALUES ('2804',1808,'SS 2804')\g INSERT INTO Semester VALUES ('2804/2805',1809,'WS 2804/2805')\g INSERT INTO Semester VALUES ('2805',50905,'Ab 2805')\g INSERT INTO Semester VALUES ('2805',100905,'Bis 2805')\g INSERT INTO Semester VALUES ('2805',1810,'SS 2805')\g INSERT INTO Semester VALUES ('2805/2806',1811,'WS 2805/2806')\g INSERT INTO Semester VALUES ('2806',50906,'Ab 2806')\g INSERT INTO Semester VALUES ('2806',100906,'Bis 2806')\g INSERT INTO Semester VALUES ('2806',1812,'SS 2806')\g INSERT INTO Semester VALUES ('2806/2807',1813,'WS 2806/2807')\g INSERT INTO Semester VALUES ('2807',50907,'Ab 2807')\g INSERT INTO Semester VALUES ('2807',100907,'Bis 2807')\g INSERT INTO Semester VALUES ('2807',1814,'SS 2807')\g INSERT INTO Semester VALUES ('2807/2808',1815,'WS 2807/2808')\g INSERT INTO Semester VALUES ('2808',50908,'Ab 2808')\g INSERT INTO Semester VALUES ('2808',100908,'Bis 2808')\g INSERT INTO Semester VALUES ('2808',1816,'SS 2808')\g INSERT INTO Semester VALUES ('2808/2809',1817,'WS 2808/2809')\g INSERT INTO Semester VALUES ('2809',50909,'Ab 2809')\g INSERT INTO Semester VALUES ('2809',100909,'Bis 2809')\g INSERT INTO Semester VALUES ('2809',1818,'SS 2809')\g INSERT INTO Semester VALUES ('2809/2810',1819,'WS 2809/2810')\g INSERT INTO Semester VALUES ('2810',50910,'Ab 2810')\g INSERT INTO Semester VALUES ('2810',100910,'Bis 2810')\g INSERT INTO Semester VALUES ('2810',1820,'SS 2810')\g INSERT INTO Semester VALUES ('2810/2811',1821,'WS 2810/2811')\g INSERT INTO Semester VALUES ('2811',50911,'Ab 2811')\g INSERT INTO Semester VALUES ('2811',100911,'Bis 2811')\g INSERT INTO Semester VALUES ('2811',1822,'SS 2811')\g INSERT INTO Semester VALUES ('2811/2812',1823,'WS 2811/2812')\g INSERT INTO Semester VALUES ('2812',50912,'Ab 2812')\g INSERT INTO Semester VALUES ('2812',100912,'Bis 2812')\g INSERT INTO Semester VALUES ('2812',1824,'SS 2812')\g INSERT INTO Semester VALUES ('2812/2813',1825,'WS 2812/2813')\g INSERT INTO Semester VALUES ('2813',50913,'Ab 2813')\g INSERT INTO Semester VALUES ('2813',100913,'Bis 2813')\g INSERT INTO Semester VALUES ('2813',1826,'SS 2813')\g INSERT INTO Semester VALUES ('2813/2814',1827,'WS 2813/2814')\g INSERT INTO Semester VALUES ('2814',50914,'Ab 2814')\g INSERT INTO Semester VALUES ('2814',100914,'Bis 2814')\g INSERT INTO Semester VALUES ('2814',1828,'SS 2814')\g INSERT INTO Semester VALUES ('2814/2815',1829,'WS 2814/2815')\g INSERT INTO Semester VALUES ('2815',50915,'Ab 2815')\g INSERT INTO Semester VALUES ('2815',100915,'Bis 2815')\g INSERT INTO Semester VALUES ('2815',1830,'SS 2815')\g INSERT INTO Semester VALUES ('2815/2816',1831,'WS 2815/2816')\g INSERT INTO Semester VALUES ('2816',50916,'Ab 2816')\g INSERT INTO Semester VALUES ('2816',100916,'Bis 2816')\g INSERT INTO Semester VALUES ('2816',1832,'SS 2816')\g INSERT INTO Semester VALUES ('2816/2817',1833,'WS 2816/2817')\g INSERT INTO Semester VALUES ('2817',50917,'Ab 2817')\g INSERT INTO Semester VALUES ('2817',100917,'Bis 2817')\g INSERT INTO Semester VALUES ('2817',1834,'SS 2817')\g INSERT INTO Semester VALUES ('2817/2818',1835,'WS 2817/2818')\g INSERT INTO Semester VALUES ('2818',50918,'Ab 2818')\g INSERT INTO Semester VALUES ('2818',100918,'Bis 2818')\g INSERT INTO Semester VALUES ('2818',1836,'SS 2818')\g INSERT INTO Semester VALUES ('2818/2819',1837,'WS 2818/2819')\g INSERT INTO Semester VALUES ('2819',50919,'Ab 2819')\g INSERT INTO Semester VALUES ('2819',100919,'Bis 2819')\g INSERT INTO Semester VALUES ('2819',1838,'SS 2819')\g INSERT INTO Semester VALUES ('2819/2820',1839,'WS 2819/2820')\g INSERT INTO Semester VALUES ('2820',50920,'Ab 2820')\g INSERT INTO Semester VALUES ('2820',100920,'Bis 2820')\g INSERT INTO Semester VALUES ('2820',1840,'SS 2820')\g INSERT INTO Semester VALUES ('2820/2821',1841,'WS 2820/2821')\g INSERT INTO Semester VALUES ('2821',50921,'Ab 2821')\g INSERT INTO Semester VALUES ('2821',100921,'Bis 2821')\g INSERT INTO Semester VALUES ('2821',1842,'SS 2821')\g INSERT INTO Semester VALUES ('2821/2822',1843,'WS 2821/2822')\g INSERT INTO Semester VALUES ('2822',50922,'Ab 2822')\g INSERT INTO Semester VALUES ('2822',100922,'Bis 2822')\g INSERT INTO Semester VALUES ('2822',1844,'SS 2822')\g INSERT INTO Semester VALUES ('2822/2823',1845,'WS 2822/2823')\g INSERT INTO Semester VALUES ('2823',50923,'Ab 2823')\g INSERT INTO Semester VALUES ('2823',100923,'Bis 2823')\g INSERT INTO Semester VALUES ('2823',1846,'SS 2823')\g INSERT INTO Semester VALUES ('2823/2824',1847,'WS 2823/2824')\g INSERT INTO Semester VALUES ('2824',50924,'Ab 2824')\g INSERT INTO Semester VALUES ('2824',100924,'Bis 2824')\g INSERT INTO Semester VALUES ('2824',1848,'SS 2824')\g INSERT INTO Semester VALUES ('2824/2825',1849,'WS 2824/2825')\g INSERT INTO Semester VALUES ('2825',50925,'Ab 2825')\g INSERT INTO Semester VALUES ('2825',100925,'Bis 2825')\g INSERT INTO Semester VALUES ('2825',1850,'SS 2825')\g INSERT INTO Semester VALUES ('2825/2826',1851,'WS 2825/2826')\g INSERT INTO Semester VALUES ('2826',50926,'Ab 2826')\g INSERT INTO Semester VALUES ('2826',100926,'Bis 2826')\g INSERT INTO Semester VALUES ('2826',1852,'SS 2826')\g INSERT INTO Semester VALUES ('2826/2827',1853,'WS 2826/2827')\g INSERT INTO Semester VALUES ('2827',50927,'Ab 2827')\g INSERT INTO Semester VALUES ('2827',100927,'Bis 2827')\g INSERT INTO Semester VALUES ('2827',1854,'SS 2827')\g INSERT INTO Semester VALUES ('2827/2828',1855,'WS 2827/2828')\g INSERT INTO Semester VALUES ('2828',50928,'Ab 2828')\g INSERT INTO Semester VALUES ('2828',100928,'Bis 2828')\g INSERT INTO Semester VALUES ('2828',1856,'SS 2828')\g INSERT INTO Semester VALUES ('2828/2829',1857,'WS 2828/2829')\g INSERT INTO Semester VALUES ('2829',50929,'Ab 2829')\g INSERT INTO Semester VALUES ('2829',100929,'Bis 2829')\g INSERT INTO Semester VALUES ('2829',1858,'SS 2829')\g INSERT INTO Semester VALUES ('2829/2830',1859,'WS 2829/2830')\g INSERT INTO Semester VALUES ('2830',50930,'Ab 2830')\g INSERT INTO Semester VALUES ('2830',100930,'Bis 2830')\g INSERT INTO Semester VALUES ('2830',1860,'SS 2830')\g INSERT INTO Semester VALUES ('2830/2831',1861,'WS 2830/2831')\g INSERT INTO Semester VALUES ('2831',50931,'Ab 2831')\g INSERT INTO Semester VALUES ('2831',100931,'Bis 2831')\g INSERT INTO Semester VALUES ('2831',1862,'SS 2831')\g INSERT INTO Semester VALUES ('2831/2832',1863,'WS 2831/2832')\g INSERT INTO Semester VALUES ('2832',50932,'Ab 2832')\g INSERT INTO Semester VALUES ('2832',100932,'Bis 2832')\g INSERT INTO Semester VALUES ('2832',1864,'SS 2832')\g INSERT INTO Semester VALUES ('2832/2833',1865,'WS 2832/2833')\g INSERT INTO Semester VALUES ('2833',50933,'Ab 2833')\g INSERT INTO Semester VALUES ('2833',100933,'Bis 2833')\g INSERT INTO Semester VALUES ('2833',1866,'SS 2833')\g INSERT INTO Semester VALUES ('2833/2834',1867,'WS 2833/2834')\g INSERT INTO Semester VALUES ('2834',50934,'Ab 2834')\g INSERT INTO Semester VALUES ('2834',100934,'Bis 2834')\g INSERT INTO Semester VALUES ('2834',1868,'SS 2834')\g INSERT INTO Semester VALUES ('2834/2835',1869,'WS 2834/2835')\g INSERT INTO Semester VALUES ('2835',50935,'Ab 2835')\g INSERT INTO Semester VALUES ('2835',100935,'Bis 2835')\g INSERT INTO Semester VALUES ('2835',1870,'SS 2835')\g INSERT INTO Semester VALUES ('2835/2836',1871,'WS 2835/2836')\g INSERT INTO Semester VALUES ('2836',50936,'Ab 2836')\g INSERT INTO Semester VALUES ('2836',100936,'Bis 2836')\g INSERT INTO Semester VALUES ('2836',1872,'SS 2836')\g INSERT INTO Semester VALUES ('2836/2837',1873,'WS 2836/2837')\g INSERT INTO Semester VALUES ('2837',50937,'Ab 2837')\g INSERT INTO Semester VALUES ('2837',100937,'Bis 2837')\g INSERT INTO Semester VALUES ('2837',1874,'SS 2837')\g INSERT INTO Semester VALUES ('2837/2838',1875,'WS 2837/2838')\g INSERT INTO Semester VALUES ('2838',50938,'Ab 2838')\g INSERT INTO Semester VALUES ('2838',100938,'Bis 2838')\g INSERT INTO Semester VALUES ('2838',1876,'SS 2838')\g INSERT INTO Semester VALUES ('2838/2839',1877,'WS 2838/2839')\g INSERT INTO Semester VALUES ('2839',50939,'Ab 2839')\g INSERT INTO Semester VALUES ('2839',100939,'Bis 2839')\g INSERT INTO Semester VALUES ('2839',1878,'SS 2839')\g INSERT INTO Semester VALUES ('2839/2840',1879,'WS 2839/2840')\g INSERT INTO Semester VALUES ('2840',50940,'Ab 2840')\g INSERT INTO Semester VALUES ('2840',100940,'Bis 2840')\g INSERT INTO Semester VALUES ('2840',1880,'SS 2840')\g INSERT INTO Semester VALUES ('2840/2841',1881,'WS 2840/2841')\g INSERT INTO Semester VALUES ('2841',50941,'Ab 2841')\g INSERT INTO Semester VALUES ('2841',100941,'Bis 2841')\g INSERT INTO Semester VALUES ('2841',1882,'SS 2841')\g INSERT INTO Semester VALUES ('2841/2842',1883,'WS 2841/2842')\g INSERT INTO Semester VALUES ('2842',50942,'Ab 2842')\g INSERT INTO Semester VALUES ('2842',100942,'Bis 2842')\g INSERT INTO Semester VALUES ('2842',1884,'SS 2842')\g INSERT INTO Semester VALUES ('2842/2843',1885,'WS 2842/2843')\g INSERT INTO Semester VALUES ('2843',50943,'Ab 2843')\g INSERT INTO Semester VALUES ('2843',100943,'Bis 2843')\g INSERT INTO Semester VALUES ('2843',1886,'SS 2843')\g INSERT INTO Semester VALUES ('2843/2844',1887,'WS 2843/2844')\g INSERT INTO Semester VALUES ('2844',50944,'Ab 2844')\g INSERT INTO Semester VALUES ('2844',100944,'Bis 2844')\g INSERT INTO Semester VALUES ('2844',1888,'SS 2844')\g INSERT INTO Semester VALUES ('2844/2845',1889,'WS 2844/2845')\g INSERT INTO Semester VALUES ('2845',50945,'Ab 2845')\g INSERT INTO Semester VALUES ('2845',100945,'Bis 2845')\g INSERT INTO Semester VALUES ('2845',1890,'SS 2845')\g INSERT INTO Semester VALUES ('2845/2846',1891,'WS 2845/2846')\g INSERT INTO Semester VALUES ('2846',50946,'Ab 2846')\g INSERT INTO Semester VALUES ('2846',100946,'Bis 2846')\g INSERT INTO Semester VALUES ('2846',1892,'SS 2846')\g INSERT INTO Semester VALUES ('2846/2847',1893,'WS 2846/2847')\g INSERT INTO Semester VALUES ('2847',50947,'Ab 2847')\g INSERT INTO Semester VALUES ('2847',100947,'Bis 2847')\g INSERT INTO Semester VALUES ('2847',1894,'SS 2847')\g INSERT INTO Semester VALUES ('2847/2848',1895,'WS 2847/2848')\g INSERT INTO Semester VALUES ('2848',50948,'Ab 2848')\g INSERT INTO Semester VALUES ('2848',100948,'Bis 2848')\g INSERT INTO Semester VALUES ('2848',1896,'SS 2848')\g INSERT INTO Semester VALUES ('2848/2849',1897,'WS 2848/2849')\g INSERT INTO Semester VALUES ('2849',50949,'Ab 2849')\g INSERT INTO Semester VALUES ('2849',100949,'Bis 2849')\g INSERT INTO Semester VALUES ('2849',1898,'SS 2849')\g INSERT INTO Semester VALUES ('2849/2850',1899,'WS 2849/2850')\g INSERT INTO Semester VALUES ('2850',50950,'Ab 2850')\g INSERT INTO Semester VALUES ('2850',100950,'Bis 2850')\g INSERT INTO Semester VALUES ('2850',1900,'SS 2850')\g INSERT INTO Semester VALUES ('2850/2851',1901,'WS 2850/2851')\g INSERT INTO Semester VALUES ('2851',50951,'Ab 2851')\g INSERT INTO Semester VALUES ('2851',100951,'Bis 2851')\g INSERT INTO Semester VALUES ('2851',1902,'SS 2851')\g INSERT INTO Semester VALUES ('2851/2852',1903,'WS 2851/2852')\g INSERT INTO Semester VALUES ('2852',50952,'Ab 2852')\g INSERT INTO Semester VALUES ('2852',100952,'Bis 2852')\g INSERT INTO Semester VALUES ('2852',1904,'SS 2852')\g INSERT INTO Semester VALUES ('2852/2853',1905,'WS 2852/2853')\g INSERT INTO Semester VALUES ('2853',50953,'Ab 2853')\g INSERT INTO Semester VALUES ('2853',100953,'Bis 2853')\g INSERT INTO Semester VALUES ('2853',1906,'SS 2853')\g INSERT INTO Semester VALUES ('2853/2854',1907,'WS 2853/2854')\g INSERT INTO Semester VALUES ('2854',50954,'Ab 2854')\g INSERT INTO Semester VALUES ('2854',100954,'Bis 2854')\g INSERT INTO Semester VALUES ('2854',1908,'SS 2854')\g INSERT INTO Semester VALUES ('2854/2855',1909,'WS 2854/2855')\g INSERT INTO Semester VALUES ('2855',50955,'Ab 2855')\g INSERT INTO Semester VALUES ('2855',100955,'Bis 2855')\g INSERT INTO Semester VALUES ('2855',1910,'SS 2855')\g INSERT INTO Semester VALUES ('2855/2856',1911,'WS 2855/2856')\g INSERT INTO Semester VALUES ('2856',50956,'Ab 2856')\g INSERT INTO Semester VALUES ('2856',100956,'Bis 2856')\g INSERT INTO Semester VALUES ('2856',1912,'SS 2856')\g INSERT INTO Semester VALUES ('2856/2857',1913,'WS 2856/2857')\g INSERT INTO Semester VALUES ('2857',50957,'Ab 2857')\g INSERT INTO Semester VALUES ('2857',100957,'Bis 2857')\g INSERT INTO Semester VALUES ('2857',1914,'SS 2857')\g INSERT INTO Semester VALUES ('2857/2858',1915,'WS 2857/2858')\g INSERT INTO Semester VALUES ('2858',50958,'Ab 2858')\g INSERT INTO Semester VALUES ('2858',100958,'Bis 2858')\g INSERT INTO Semester VALUES ('2858',1916,'SS 2858')\g INSERT INTO Semester VALUES ('2858/2859',1917,'WS 2858/2859')\g INSERT INTO Semester VALUES ('2859',50959,'Ab 2859')\g INSERT INTO Semester VALUES ('2859',100959,'Bis 2859')\g INSERT INTO Semester VALUES ('2859',1918,'SS 2859')\g INSERT INTO Semester VALUES ('2859/2860',1919,'WS 2859/2860')\g INSERT INTO Semester VALUES ('2860',50960,'Ab 2860')\g INSERT INTO Semester VALUES ('2860',100960,'Bis 2860')\g INSERT INTO Semester VALUES ('2860',1920,'SS 2860')\g INSERT INTO Semester VALUES ('2860/2861',1921,'WS 2860/2861')\g INSERT INTO Semester VALUES ('2861',50961,'Ab 2861')\g INSERT INTO Semester VALUES ('2861',100961,'Bis 2861')\g INSERT INTO Semester VALUES ('2861',1922,'SS 2861')\g INSERT INTO Semester VALUES ('2861/2862',1923,'WS 2861/2862')\g INSERT INTO Semester VALUES ('2862',50962,'Ab 2862')\g INSERT INTO Semester VALUES ('2862',100962,'Bis 2862')\g INSERT INTO Semester VALUES ('2862',1924,'SS 2862')\g INSERT INTO Semester VALUES ('2862/2863',1925,'WS 2862/2863')\g INSERT INTO Semester VALUES ('2863',50963,'Ab 2863')\g INSERT INTO Semester VALUES ('2863',100963,'Bis 2863')\g INSERT INTO Semester VALUES ('2863',1926,'SS 2863')\g INSERT INTO Semester VALUES ('2863/2864',1927,'WS 2863/2864')\g INSERT INTO Semester VALUES ('2864',50964,'Ab 2864')\g INSERT INTO Semester VALUES ('2864',100964,'Bis 2864')\g INSERT INTO Semester VALUES ('2864',1928,'SS 2864')\g INSERT INTO Semester VALUES ('2864/2865',1929,'WS 2864/2865')\g INSERT INTO Semester VALUES ('2865',50965,'Ab 2865')\g INSERT INTO Semester VALUES ('2865',100965,'Bis 2865')\g INSERT INTO Semester VALUES ('2865',1930,'SS 2865')\g INSERT INTO Semester VALUES ('2865/2866',1931,'WS 2865/2866')\g INSERT INTO Semester VALUES ('2866',50966,'Ab 2866')\g INSERT INTO Semester VALUES ('2866',100966,'Bis 2866')\g INSERT INTO Semester VALUES ('2866',1932,'SS 2866')\g INSERT INTO Semester VALUES ('2866/2867',1933,'WS 2866/2867')\g INSERT INTO Semester VALUES ('2867',50967,'Ab 2867')\g INSERT INTO Semester VALUES ('2867',100967,'Bis 2867')\g INSERT INTO Semester VALUES ('2867',1934,'SS 2867')\g INSERT INTO Semester VALUES ('2867/2868',1935,'WS 2867/2868')\g INSERT INTO Semester VALUES ('2868',50968,'Ab 2868')\g INSERT INTO Semester VALUES ('2868',100968,'Bis 2868')\g INSERT INTO Semester VALUES ('2868',1936,'SS 2868')\g INSERT INTO Semester VALUES ('2868/2869',1937,'WS 2868/2869')\g INSERT INTO Semester VALUES ('2869',50969,'Ab 2869')\g INSERT INTO Semester VALUES ('2869',100969,'Bis 2869')\g INSERT INTO Semester VALUES ('2869',1938,'SS 2869')\g INSERT INTO Semester VALUES ('2869/2870',1939,'WS 2869/2870')\g INSERT INTO Semester VALUES ('2870',50970,'Ab 2870')\g INSERT INTO Semester VALUES ('2870',100970,'Bis 2870')\g INSERT INTO Semester VALUES ('2870',1940,'SS 2870')\g INSERT INTO Semester VALUES ('2870/2871',1941,'WS 2870/2871')\g INSERT INTO Semester VALUES ('2871',50971,'Ab 2871')\g INSERT INTO Semester VALUES ('2871',100971,'Bis 2871')\g INSERT INTO Semester VALUES ('2871',1942,'SS 2871')\g INSERT INTO Semester VALUES ('2871/2872',1943,'WS 2871/2872')\g INSERT INTO Semester VALUES ('2872',50972,'Ab 2872')\g INSERT INTO Semester VALUES ('2872',100972,'Bis 2872')\g INSERT INTO Semester VALUES ('2872',1944,'SS 2872')\g INSERT INTO Semester VALUES ('2872/2873',1945,'WS 2872/2873')\g INSERT INTO Semester VALUES ('2873',50973,'Ab 2873')\g INSERT INTO Semester VALUES ('2873',100973,'Bis 2873')\g INSERT INTO Semester VALUES ('2873',1946,'SS 2873')\g INSERT INTO Semester VALUES ('2873/2874',1947,'WS 2873/2874')\g INSERT INTO Semester VALUES ('2874',50974,'Ab 2874')\g INSERT INTO Semester VALUES ('2874',100974,'Bis 2874')\g INSERT INTO Semester VALUES ('2874',1948,'SS 2874')\g INSERT INTO Semester VALUES ('2874/2875',1949,'WS 2874/2875')\g INSERT INTO Semester VALUES ('2875',50975,'Ab 2875')\g INSERT INTO Semester VALUES ('2875',100975,'Bis 2875')\g INSERT INTO Semester VALUES ('2875',1950,'SS 2875')\g INSERT INTO Semester VALUES ('2875/2876',1951,'WS 2875/2876')\g INSERT INTO Semester VALUES ('2876',50976,'Ab 2876')\g INSERT INTO Semester VALUES ('2876',100976,'Bis 2876')\g INSERT INTO Semester VALUES ('2876',1952,'SS 2876')\g INSERT INTO Semester VALUES ('2876/2877',1953,'WS 2876/2877')\g INSERT INTO Semester VALUES ('2877',50977,'Ab 2877')\g INSERT INTO Semester VALUES ('2877',100977,'Bis 2877')\g INSERT INTO Semester VALUES ('2877',1954,'SS 2877')\g INSERT INTO Semester VALUES ('2877/2878',1955,'WS 2877/2878')\g INSERT INTO Semester VALUES ('2878',50978,'Ab 2878')\g INSERT INTO Semester VALUES ('2878',100978,'Bis 2878')\g INSERT INTO Semester VALUES ('2878',1956,'SS 2878')\g INSERT INTO Semester VALUES ('2878/2879',1957,'WS 2878/2879')\g INSERT INTO Semester VALUES ('2879',50979,'Ab 2879')\g INSERT INTO Semester VALUES ('2879',100979,'Bis 2879')\g INSERT INTO Semester VALUES ('2879',1958,'SS 2879')\g INSERT INTO Semester VALUES ('2879/2880',1959,'WS 2879/2880')\g INSERT INTO Semester VALUES ('2880',50980,'Ab 2880')\g INSERT INTO Semester VALUES ('2880',100980,'Bis 2880')\g INSERT INTO Semester VALUES ('2880',1960,'SS 2880')\g INSERT INTO Semester VALUES ('2880/2881',1961,'WS 2880/2881')\g INSERT INTO Semester VALUES ('2881',50981,'Ab 2881')\g INSERT INTO Semester VALUES ('2881',100981,'Bis 2881')\g INSERT INTO Semester VALUES ('2881',1962,'SS 2881')\g INSERT INTO Semester VALUES ('2881/2882',1963,'WS 2881/2882')\g INSERT INTO Semester VALUES ('2882',50982,'Ab 2882')\g INSERT INTO Semester VALUES ('2882',100982,'Bis 2882')\g INSERT INTO Semester VALUES ('2882',1964,'SS 2882')\g INSERT INTO Semester VALUES ('2882/2883',1965,'WS 2882/2883')\g INSERT INTO Semester VALUES ('2883',50983,'Ab 2883')\g INSERT INTO Semester VALUES ('2883',100983,'Bis 2883')\g INSERT INTO Semester VALUES ('2883',1966,'SS 2883')\g INSERT INTO Semester VALUES ('2883/2884',1967,'WS 2883/2884')\g INSERT INTO Semester VALUES ('2884',50984,'Ab 2884')\g INSERT INTO Semester VALUES ('2884',100984,'Bis 2884')\g INSERT INTO Semester VALUES ('2884',1968,'SS 2884')\g INSERT INTO Semester VALUES ('2884/2885',1969,'WS 2884/2885')\g INSERT INTO Semester VALUES ('2885',50985,'Ab 2885')\g INSERT INTO Semester VALUES ('2885',100985,'Bis 2885')\g INSERT INTO Semester VALUES ('2885',1970,'SS 2885')\g INSERT INTO Semester VALUES ('2885/2886',1971,'WS 2885/2886')\g INSERT INTO Semester VALUES ('2886',50986,'Ab 2886')\g INSERT INTO Semester VALUES ('2886',100986,'Bis 2886')\g INSERT INTO Semester VALUES ('2886',1972,'SS 2886')\g INSERT INTO Semester VALUES ('2886/2887',1973,'WS 2886/2887')\g INSERT INTO Semester VALUES ('2887',50987,'Ab 2887')\g INSERT INTO Semester VALUES ('2887',100987,'Bis 2887')\g INSERT INTO Semester VALUES ('2887',1974,'SS 2887')\g INSERT INTO Semester VALUES ('2887/2888',1975,'WS 2887/2888')\g INSERT INTO Semester VALUES ('2888',50988,'Ab 2888')\g INSERT INTO Semester VALUES ('2888',100988,'Bis 2888')\g INSERT INTO Semester VALUES ('2888',1976,'SS 2888')\g INSERT INTO Semester VALUES ('2888/2889',1977,'WS 2888/2889')\g INSERT INTO Semester VALUES ('2889',50989,'Ab 2889')\g INSERT INTO Semester VALUES ('2889',100989,'Bis 2889')\g INSERT INTO Semester VALUES ('2889',1978,'SS 2889')\g INSERT INTO Semester VALUES ('2889/2890',1979,'WS 2889/2890')\g INSERT INTO Semester VALUES ('2890',50990,'Ab 2890')\g INSERT INTO Semester VALUES ('2890',100990,'Bis 2890')\g INSERT INTO Semester VALUES ('2890',1980,'SS 2890')\g INSERT INTO Semester VALUES ('2890/2891',1981,'WS 2890/2891')\g INSERT INTO Semester VALUES ('2891',50991,'Ab 2891')\g INSERT INTO Semester VALUES ('2891',100991,'Bis 2891')\g INSERT INTO Semester VALUES ('2891',1982,'SS 2891')\g INSERT INTO Semester VALUES ('2891/2892',1983,'WS 2891/2892')\g INSERT INTO Semester VALUES ('2892',50992,'Ab 2892')\g INSERT INTO Semester VALUES ('2892',100992,'Bis 2892')\g INSERT INTO Semester VALUES ('2892',1984,'SS 2892')\g INSERT INTO Semester VALUES ('2892/2893',1985,'WS 2892/2893')\g INSERT INTO Semester VALUES ('2893',50993,'Ab 2893')\g INSERT INTO Semester VALUES ('2893',100993,'Bis 2893')\g INSERT INTO Semester VALUES ('2893',1986,'SS 2893')\g INSERT INTO Semester VALUES ('2893/2894',1987,'WS 2893/2894')\g INSERT INTO Semester VALUES ('2894',50994,'Ab 2894')\g INSERT INTO Semester VALUES ('2894',100994,'Bis 2894')\g INSERT INTO Semester VALUES ('2894',1988,'SS 2894')\g INSERT INTO Semester VALUES ('2894/2895',1989,'WS 2894/2895')\g INSERT INTO Semester VALUES ('2895',50995,'Ab 2895')\g INSERT INTO Semester VALUES ('2895',100995,'Bis 2895')\g INSERT INTO Semester VALUES ('2895',1990,'SS 2895')\g INSERT INTO Semester VALUES ('2895/2896',1991,'WS 2895/2896')\g INSERT INTO Semester VALUES ('2896',50996,'Ab 2896')\g INSERT INTO Semester VALUES ('2896',100996,'Bis 2896')\g INSERT INTO Semester VALUES ('2896',1992,'SS 2896')\g INSERT INTO Semester VALUES ('2896/2897',1993,'WS 2896/2897')\g INSERT INTO Semester VALUES ('2897',50997,'Ab 2897')\g INSERT INTO Semester VALUES ('2897',100997,'Bis 2897')\g INSERT INTO Semester VALUES ('2897',1994,'SS 2897')\g INSERT INTO Semester VALUES ('2897/2898',1995,'WS 2897/2898')\g INSERT INTO Semester VALUES ('2898',50998,'Ab 2898')\g INSERT INTO Semester VALUES ('2898',100998,'Bis 2898')\g INSERT INTO Semester VALUES ('2898',1996,'SS 2898')\g INSERT INTO Semester VALUES ('2898/2899',1997,'WS 2898/2899')\g INSERT INTO Semester VALUES ('2899',50999,'Ab 2899')\g INSERT INTO Semester VALUES ('2899',100999,'Bis 2899')\g INSERT INTO Semester VALUES ('2899',1998,'SS 2899')\g INSERT INTO Semester VALUES ('2899/2900',1999,'WS 2899/2900')\g DROP TABLE Stand\g CREATE TABLE Stand( Stand CHAR (2), StandLang CHAR (15), StandMKV CHAR (50), StandNr INT, PRIMARY KEY (StandNr), KEY (Stand) )\g INSERT INTO Stand VALUES ('BP','Bandphilister','Bandphilister',1)\g INSERT INTO Stand VALUES ('BU','Bursch','Urstudierender',2)\g INSERT INTO Stand VALUES ('EM','Ehrenmitglied','Ehrenmitglied',3)\g INSERT INTO Stand VALUES ('EP','Ehrenphilister','Ehrenphilister',4)\g INSERT INTO Stand VALUES ('FU','Fux','Urstudierender',5)\g INSERT INTO Stand VALUES ('UP','Urphilister','Urphilister',6)\g INSERT INTO Stand VALUES ('NB','Keine Ahnung','',7)\g INSERT INTO Stand VALUES ('VA','Verkehrsaktiver','Verkehrsaktiver',8)\g DROP TABLE TabelleAbleistung\g CREATE TABLE TabelleAbleistung( Ableistung CHAR (50), AbleistungID INT, KEY (AbleistungID), PRIMARY KEY (AbleistungID), KEY (Ableistung) )\g INSERT INTO TabelleAbleistung VALUES ('Dank und Anerkennung',1)\g INSERT INTO TabelleAbleistung VALUES ('Dank',2)\g INSERT INTO TabelleAbleistung VALUES ('Schlicht',3)\g INSERT INTO TabelleAbleistung VALUES ('vorzeitig dechargiert/nicht entlastet',4)\g INSERT INTO TabelleAbleistung VALUES ('',5)\g INSERT INTO TabelleAbleistung VALUES ('derzeit in Amt und Würden',6)\g DROP TABLE TabelleHatPhoto\g CREATE TABLE TabelleHatPhoto( BbrNr INT NOT NULL DEFAULT 0, HatPhotoID INT NOT NULL DEFAULT 0, photoactual CHAR (2), PhotoNr INT NOT NULL DEFAULT 0, PhotoPosition INT NOT NULL DEFAULT 0, photowww CHAR (50), KEY (HatPhotoID), PRIMARY KEY (HatPhotoID) )\g DROP TABLE TabellePhotos\g CREATE TABLE TabellePhotos( Bezeichnung CHAR (255), Datum DATE, Photo CHAR (255), PhotoID INT NOT NULL DEFAULT 0, KEY (PhotoID), PRIMARY KEY (PhotoID) )\g DROP TABLE Veranstaltungen\g CREATE TABLE Veranstaltungen( applyto CHAR (50), changing SMALLINT NOT NULL DEFAULT 0, Datum DATE, Uhrzeit CHAR (50), Veranstaltung CHAR (255), wichtig SMALLINT NOT NULL DEFAULT 0, Wochentag CHAR (10) )\g DROP TABLE Verband\g CREATE TABLE Verband( Verband CHAR (10), VerbandLang CHAR (255), VerbandNr INT NOT NULL DEFAULT 0, PRIMARY KEY (VerbandNr) )\g INSERT INTO Verband VALUES ('MKV','Mittelschülerkartellverband',1)\g INSERT INTO Verband VALUES ('ÖCV','Österreichischer Cartellverband',2)\g INSERT INTO Verband VALUES ('KÖL','Katholisch Österreichische Landsmannschaften',4)\g INSERT INTO Verband VALUES ('','unbekannt',5)\g DROP TABLE Verbindung\g CREATE TABLE Verbindung( VerbandNr INT NOT NULL , VerbindungKurz CHAR (7) NOT NULL , VerbindungNr INT NOT NULL DEFAULT 0, VerbindungsName CHAR (50), VerbindungsTyp CHAR (20), PRIMARY KEY (VerbindungNr) )\g