CREATE TABLE "lplan" (
	"semester" character(6) NOT NULL,
	"art" character[] NOT NULL,
	"lplnr" integer DEFAULT nextval('lplan_lplnr_seq'::text) NOT NULL,
	"nachname" character varying(50),
	"vorname" character varying(50),
	"veranst_titel" character varying(150),
	"daf" boolean DEFAULT 'f',
	"tag" character(2),
	"uhrzeit" character varying(100),
	"ort" character varying(100),
	"dozent" smallint,
	"lastchanged" timestamp with time zone DEFAULT 'now',
	"kvvnr" character(4),
	"medien" boolean DEFAULT 'f',
	Constraint "lplan_pkey" Primary Key ("semester", "lplnr")
);

INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"7"}',1,'Trinkwitz','Joachim','Computer- und Internetnutzung f\374r Germanisten','f','Fr','11-13','CIP-Pool',80,'12.01.2001 10:16:03.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.4"}',204,'St\344hler','Axel','Jerusalem - in Geschichte und Literatur','f','Mi','16-18','\334R 4, VZ',111,'01.02.2001 11:22:07.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"1.4"}',3,'Kemper','Tobias A.','Einf\374hrung ins Mittelhochdeutsche','f','Mo','14-16','VZ',95,'12.01.2001 11:05:46.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.3"}',25,'Kraft','Stephan','Kom\366die','t','Mo','14-16','gro\337er \334bungsraum',37,'17.01.2001 14:43:49.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.2"}',5,'Niewerth','Heinz-Peter','','f','Di','09-11','\334 6 im VZ',51,'14.01.2001 17:10:08.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.2"}',6,'Niewerth','Heinz-Peter','','f','Di','11-13','\334 6 im VZ',51,'14.01.2001 17:11:18.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.3"}',7,'Niewerth','Heinz-Peter','','t','Mi','09-11','\334 5',51,'14.01.2001 17:12:26.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"1.3"}',41,'M\366ller','Robert','Einf\374hrung in die historische Sprachbetrachtung','f','Fr','11-13','IGL, Am Hofgarten 22',47,'24.01.2001 15:06:06.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.4"}',9,'Niewerth','Heinz-Peter','','f','Do','14-16','\334 5',51,'14.01.2001 17:15:44.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.8"}',10,'Niewerth','Heinz-Peter','','f','Do','11-13','\334 1',51,'14.01.2001 17:16:28.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.3"}',11,'Niewerth','Heinz-Peter','','t','Mi','11-13','AR V, 2. OG',51,'14.01.2001 17:17:42.00 CET');
INSERT INTO "lplan" ("semester","art","lplnr","nachname","vorname","veranst_titel","daf","tag","uhrzeit","ort","dozent","lastchanged") VALUES ('2001ws','{"2.1"}',12,'Oellers','Norbert','Schiller 2','t','Mi','10-11','HS VIII',55,'15.01.2001 10:54:37.00 CET');
