SPOOL SQL.LST
	--Opretter/åbner en fil og skriver programmets 
	-- meddelelser til den.
SET TERMOUT ON		 
	--Skriver programmets meddelelser til skærmen.
PROMPT Fjerner tabeller ...	   
      --Skriver beskeden til skærmen.
SET TERMOUT OFF		 
      --Skriver ikke programmets meddelelser til skærmen.
DROP TABLE Tidsprioritet;
DROP TABLE LokalePlan;
DROP TABLE LokaleHoldRelation;
DROP TABLE Lektion;
DROP TABLE Laererliste;
DROP TABLE LaererFagProfil;
DROP TABLE Holdliste;
DROP TABLE HoldLaererRelation;
DROP TABLE Fagprofil;
DROP TABLE Fagliste;

DROP TABLE Plan;
DROP TABLE TimeFagFordeling;
DROP TABLE Lokale; 
DROP TABLE Laerer; 
DROP TABLE Hold; 
DROP TABLE Fag; 
SET TERMOUT ON

PROMPT Opretter tabeller ...
SET TERMOUT OFF
CREATE TABLE Fag
( FagID_AFa				VARCHAR(5)		NOT NULL,
  Navn_AFa				VARCHAR(25)		NOT NULL,
  Timer_AFa				INT			NOT NULL,
  Lokaletype_AFa			VARCHAR(15)		NOT NULL,
  PRIMARY KEY (FagID_AFa)
);

CREATE TABLE Hold
( HoldID_AHo			VARCHAR(5)		NOT NULL,
  Navn_AHo				VARCHAR(20)		NOT NULL,
  Semester_AHo			VARCHAR(12)		NOT NULL,
  AntalElever_AHo			INT			NOT NULL,
  Type_AHo				VARCHAR(10)		NOT NULL,
  PRIMARY KEY (HoldID_AHo)
);

CREATE TABLE Laerer
( LaererID_ALa			VARCHAR(5)		NOT NULL,
  Fornavn_ALa			VARCHAR(20)		NOT NULL,
  Mellemnavn_ALa			VARCHAR(20),
  Efternavn_ALa			VARCHAR(25)		NOT NULL,
  CprNr_ALa				CHAR(9)		NOT NULL,
  PRIMARY KEY (LaererID_ALa),
  UNIQUE (CprNr_ALa)
);

CREATE TABLE Lokale
( LokaleID_ALo			VARCHAR(6)		NOT NULL,  
  LokaleType_ALo			VARCHAR(15)		NOT NULL,  
  MaxElever_ALo			INT			NOT NULL,
  PRIMARY KEY (LokaleID_ALo)
);

CREATE TABLE TimeFagFordeling
( TimeFagFordelingID_TFF	VARCHAR(15)		NOT NULL,
  Navn_TFF				VARCHAR(20)		NOT NULL,
  AktivPassiv_TFF			VARCHAR(10)		NOT NULL,
  Godkendt_TFF			VARCHAR(15)		NOT NULL,
  PRIMARY KEY (TimeFagFordelingID_TFF)
);

CREATE TABLE Plan
( PlanID_P				VARCHAR(5)		NOT NULL,
  Navn_P				VARCHAR(20)		NOT NULL,
  TimeFagFordelingID_P		VARCHAR(15)		NOT NULL,
  PlanProcent_P			INT			NOT NULL,
  Kolonne_P				INT			NOT NULL,
  Raekke_P				INT			NOT NULL,
  PRIMARY KEY (PlanID_P),
  FOREIGN KEY (TimeFagFordelingID_P) REFERENCES 
		   TimeFagFordeling(TimeFagFordelingID_TFF)
);

CREATE TABLE Fagliste
( TimeFagFordelingID_TFa	VARCHAR(15)		NOT NULL,
  FagID_TFa				VARCHAR(5)		NOT NULL,
  PRIMARY KEY (TimeFagFordelingID_TFa, FagID_TFa),                 
  FOREIGN KEY (TimeFagFordelingID_TFa) REFERENCES 
		   TimeFagFordeling(TimeFagFordelingID_TFF),
  FOREIGN KEY (FagID_TFa) REFERENCES Fag(FagID_AFa)
);

CREATE TABLE Fagprofil
( FagID_Fp				VARCHAR(5)		NOT NULL,
  Type_Fp				VARCHAR(10)		NOT NULL,
  PRIMARY KEY (FagID_Fp, Type_Fp),
  FOREIGN KEY (FagID_Fp) REFERENCES Fag(FagID_AFa)
);

CREATE TABLE HoldLaererRelation
( LaererID_HLR			VARCHAR(5)		NOT NULL,
  FagID_HLR				VARCHAR(5)		NOT NULL,
  HoldID_HLR			VARCHAR(5)		NOT NULL,
  PlanID_HLR			VARCHAR(5)		NOT NULL,
  PRIMARY KEY (LaererID_HLR, FagID_HLR, HoldID_HLR, PlanID_HLR),
  FOREIGN KEY (LaererID_HLR) REFERENCES Laerer(LaererID_ALa),
  FOREIGN KEY (FagID_HLR)    REFERENCES Fag(FagID_AFa),
  FOREIGN KEY (HoldID_HLR)   REFERENCES Hold(HoldID_AHo),
  FOREIGN KEY (PlanID_HLR)   REFERENCES Plan(PlanID_P)
);

CREATE TABLE Holdliste
( TimeFagFordelingID_THo	VARCHAR(15)		NOT NULL,
  Hold_THo				VARCHAR(5)		NOT NULL,
  PRIMARY KEY (TimeFagFordelingID_THo, Hold_THo),
  FOREIGN KEY (TimeFagFordelingID_THo) REFERENCES 
		   TimeFagFordeling(TimeFagFordelingID_TFF),
  FOREIGN KEY (Hold_THo) REFERENCES Hold(HoldID_AHo)
);

CREATE TABLE LaererFagProfil
( TimeFagFordelingID_LFP	VARCHAR(15)		NOT NULL,
  LaererID_LFP			VARCHAR(5)		NOT NULL,
  FagID_LFP				VARCHAR(5)		NOT NULL,
  Blokstoerrelse_LFP		INT 			NOT NULL,
  AntalHold_LFP			INT			NOT NULL,
  PRIMARY KEY (TimeFagFordelingID_LFP, LaererID_LFP, FagID_LFP),
  FOREIGN KEY (TimeFagFordelingID_LFP) REFERENCES 
		   TimeFagFordeling(TimeFagFordelingID_TFF),
  FOREIGN KEY (LaererID_LFP) REFERENCES Laerer(LaererID_ALa),
  FOREIGN KEY (FagID_LFP) REFERENCES Fag(FagID_AFa)
);

CREATE TABLE Laererliste
( TimeFagFordelingID_TLa	VARCHAR(15)		NOT NULL,
  LaererID_TLa			VARCHAR(5)		NOT NULL,
  PRIMARY KEY (TimeFagFordelingID_TLa, LaererID_TLa),
  FOREIGN KEY (TimeFagFordelingID_TLa) REFERENCES 
		   TimeFagFordeling(TimeFagFordelingID_TFF),
  FOREIGN KEY (LaererID_TLa) REFERENCES Laerer(LaererID_ALa)
);

CREATE TABLE Lektion
( PlanID_Le				VARCHAR(5)		NOT NULL,
  HoldID_Le				VARCHAR(5)		NOT NULL,
  FagID_Le				VARCHAR(5)		NOT NULL,
  LaererID_Le			VARCHAR(5)		NOT NULL,
  LokaleID_Le			VARCHAR(6)		NOT NULL,
  Blokstoerrelse_Le		INT			NOT NULL,
  Kolonne_Le			INT			NOT NULL,
  Raekke_Le				INT			NOT NULL,
  PRIMARY KEY (PlanID_Le, HoldID_Le, Kolonne_Le, Raekke_Le),
  UNIQUE (PlanID_Le, LaererID_Le, Kolonne_Le, Raekke_Le),
  FOREIGN KEY (PlanID_Le)   REFERENCES Plan(PlanID_P),
  FOREIGN KEY (HoldID_Le)   REFERENCES Hold(HoldID_AHo),
  FOREIGN KEY (FagID_Le)    REFERENCES Fag(FagID_AFa),
  FOREIGN KEY (LaererID_Le) REFERENCES Laerer(LaererID_ALa),
  FOREIGN KEY (LokaleID_Le) REFERENCES Lokale(LokaleID_ALo)
);

CREATE TABLE LokaleHoldRelation
( LokaleID_LoHR			VARCHAR(6)		NOT NULL,
  PlanID_LoHR			VARCHAR(5)		NOT NULL,  
  HoldID_LoHR			VARCHAR(5),
  PRIMARY KEY (LokaleID_LoHR, PlanID_LoHR, HoldID_LoHR),
  FOREIGN KEY (LokaleID_LoHR) REFERENCES Lokale(LokaleID_ALo),
  FOREIGN KEY (PlanID_LoHR)   REFERENCES Plan(PlanID_P),
  FOREIGN KEY (HoldID_LoHR)   REFERENCES Hold(HoldID_AHo)
); 

CREATE TABLE LokalePlan
( LokaleID_LP			VARCHAR(6)		NOT NULL,
  PlanID_LP				VARCHAR(5)		NOT NULL,
  PRIMARY KEY (LokaleID_LP, PlanID_LP),
  FOREIGN KEY (LokaleID_LP) REFERENCES Lokale(LokaleID_ALo),
  FOREIGN KEY (PlanID_LP)   REFERENCES Plan(PlanID_P)
);

CREATE TABLE Tidsprioritet
( PlanID_Ti				VARCHAR(5)		NOT NULL,
  LaererID_Ti			VARCHAR(5)		NOT NULL,
  Prioritet_Ti			INT			NOT NULL,
  Kolonne_Ti			INT			NOT NULL,
  Raekke_Ti				INT			NOT NULL,
  PRIMARY KEY (PlanID_Ti, LaererID_Ti, Kolonne_Ti, Raekke_Ti),
  FOREIGN KEY (PlanID_Ti)   REFERENCES Plan(PlanID_P),
  FOREIGN KEY (LaererID_Ti) REFERENCES Laerer(LaererID_ALa)
);
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Fag ...
SET TERMOUT OFF
INSERT INTO Fag 	VALUES ('ehoa','erhvervsoekonomi A',      10, 'Stamlokale');
INSERT INTO Fag 	VALUES ('ehob','erhvervsoekonomi B',       6, 'Stamlokale');
INSERT INTO Fag 	VALUES ('afsa','afsaetning A',             8, 'Stamlokale');
INSERT INTO Fag 	VALUES ('afsb','afsaetning B',             6, 'Stamlokale');
INSERT INTO Fag 	VALUES ('inob','international oekonomi B', 6, 'Stamlokale');
INSERT INTO Fag 	VALUES ('ehrb','erhvervsret B',            4, 'Stamlokale');
INSERT INTO Fag 	VALUES ('idhb','idehistorie B',            4, 'Stamlokale');
INSERT INTO Fag	VALUES ('miob','miljoe B',                 4, 'Stamlokale');
INSERT INTO Fag 	VALUES ('mtmb','multimedie B',             4, 'Edb'       );
INSERT INTO Fag 	VALUES ('iktb','informationsteknologi B',  6, 'Edb'       );
INSERT INTO Fag 	VALUES ('ikta','informationsteknologi A',  8, 'Edb'       );
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Hold ...
SET TERMOUT OFF
INSERT INTO Hold	VALUES ('sa','studentklasse A','1.',28,'HHX1');
INSERT INTO Hold	VALUES ('se','studentklasse E','1.',27,'HHX2');
INSERT INTO Hold	VALUES ('si','studentklasse I','1.',25,'HHX3');

INSERT INTO Hold	VALUES ('sb','studentklasse B','2.',28,'HHX1');
INSERT INTO Hold	VALUES ('sc','studentklasse C','2.',27,'HHX2');
INSERT INTO Hold	VALUES ('sd','studentklasse D','2.',25,'HHX3');
INSERT INTO Hold	VALUES ('sf','studentklasse F','2.',27,'HHX1');
INSERT INTO Hold	VALUES ('sg','studentklasse G','2.',24,'HHX2');
INSERT INTO Hold	VALUES ('sh','studentklasse H','2.',26,'HHX3');
INSERT INTO Hold	VALUES ('sj','studentklasse J','2.',23,'HHX1');
INSERT INTO Hold	VALUES ('sk','studentklasse K','2.',28,'HHX2');
INSERT INTO Hold	VALUES ('sl','studentklasse L','2.',25,'HHX3');

INSERT INTO Hold	VALUES ('sta','studenterklasse A','3.',28,'HHX1');
INSERT INTO Hold	VALUES ('ste','studenterklasse E','3.',27,'HHX2');
INSERT INTO Hold	VALUES ('sti','studenterklasse I','3.',25,'HHX3');
INSERT INTO Hold	VALUES ('stb','studenterklasse B','3.',28,'HHX1');
INSERT INTO Hold	VALUES ('stc','studenterklasse C','3.',27,'HHX2');
INSERT INTO Hold	VALUES ('std','studenterklasse D','3.',25,'HHX3');
INSERT INTO Hold	VALUES ('stf','studenterklasse F','3.',27,'HHX1');
INSERT INTO Hold	VALUES ('stg','studenterklasse G','3.',24,'HHX2');
INSERT INTO Hold	VALUES ('sth','studenterklasse H','3.',26,'HHX3');
INSERT INTO Hold	VALUES ('stj','studenterklasse J','3.',23,'HHX1');
INSERT INTO Hold	VALUES ('stk','studenterklasse K','3.',28,'HHX2');
INSERT INTO Hold	VALUES ('stl','studenterklasse L','3.',25,'HHX3');
INSERT INTO Hold	VALUES ('stn','studenterklasse N','3.',28,'HHX1');
INSERT INTO Hold	VALUES ('sto','studenterklasse O','3.',27,'HHX2');
INSERT INTO Hold	VALUES ('stp','studenterklasse P','3.',25,'HHX3');
INSERT INTO Hold	VALUES ('stq','studenterklasse B','3.',28,'HHX1');
INSERT INTO Hold	VALUES ('str','studenterklasse R','3.',27,'HHX2');
INSERT INTO Hold	VALUES ('sts','studenterklasse S','3.',25,'HHX3');
INSERT INTO Hold	VALUES ('stt','studenterklasse T','3.',27,'HHX1');
INSERT INTO Hold	VALUES ('stu','studenterklasse U','3.',24,'HHX2');
INSERT INTO Hold	VALUES ('stv','studenterklasse V','3.',26,'HHX3');
INSERT INTO Hold	VALUES ('stx','studenterklasse X','3.',23,'HHX1');
INSERT INTO Hold	VALUES ('sty','studenterklasse Y','3.',28,'HHX2');
INSERT INTO Hold	VALUES ('stz','studenterklasse Z','3.',25,'HHX3');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Laerer ...
SET TERMOUT OFF
INSERT INTO Laerer  VALUES ('lot','Lotte',     '','Andersen',      '111111111');
INSERT INTO Laerer  VALUES ('mik','Mikkel',    '','Jensen',        '222222222');
INSERT INTO Laerer  VALUES ('han','Hanne',     '','Hansen',        '333333333');
INSERT INTO Laerer  VALUES ('las','Lasse',     '','Poulsen',       '444444444');
INSERT INTO Laerer  VALUES ('sus','Susanne',   '','Petersen',      '555555555');

INSERT INTO Laerer  VALUES ('pet','Peter',     '','Albertsen',     '111222333');
INSERT INTO Laerer  VALUES ('joh','Johannes',  '','Jensen',        '222333444');
INSERT INTO Laerer  VALUES ('ann','Annemette', '','Hansen',        '333444555');
INSERT INTO Laerer  VALUES ('jul','Julie',     '','Poulsen',       '444555666');
INSERT INTO Laerer  VALUES ('bet','Betina',    '','Petersen',      '555666777');
INSERT INTO Laerer  VALUES ('seb','Sebastian', '','Andersen',      '666777888');
INSERT INTO Laerer  VALUES ('ste','Steffen',   '','Houlberg',      '777888999');
INSERT INTO Laerer  VALUES ('pal','Palle',     '','Helger',        '888999000');
INSERT INTO Laerer  VALUES ('kim','Kim',       '','Kjoeller',      '999000111');
INSERT INTO Laerer  VALUES ('ibo','Ib',        '','Olsen',         '000111222');

INSERT INTO Laerer  VALUES ('kat','Katrine',   '','Hansen',        '123456789');
INSERT INTO Laerer  VALUES ('mak','Mak',       '','Clausen',       '234567890');
INSERT INTO Laerer  VALUES ('apu','Apu',       '','Nahasa-Hansen', '345678901');
INSERT INTO Laerer  VALUES ('lar','Lars',      '','Poulsen',       '456789012');
INSERT INTO Laerer  VALUES ('suj','Susan',     '','Jensen',        '567890123');
INSERT INTO Laerer  VALUES ('ben','Bent',      '','Albertsen',     '678901234');
INSERT INTO Laerer  VALUES ('pau','Paulus',    '','Jensen',        '789012345');
INSERT INTO Laerer  VALUES ('anj','Anne',      '','Jokumsen',      '890123456');
INSERT INTO Laerer  VALUES ('jup','Julius',    '','Poulsen',       '901234567');
INSERT INTO Laerer  VALUES ('sti','Stine',     '','Andersen',      '012345678');
INSERT INTO Laerer  VALUES ('seo','Sepp',      '','Olmsen',        '987654321');
INSERT INTO Laerer  VALUES ('aag','Aage',      '','Pilmark',       '876543210');
INSERT INTO Laerer  VALUES ('ole','Ole',       '','Helger',        '765432109');
INSERT INTO Laerer  VALUES ('ove','Ove',       '','Kjoeller',      '654321098');
INSERT INTO Laerer  VALUES ('ibh','Ib',        '','Hansen',        '543210987');
INSERT INTO Laerer  VALUES ('boe','Boerge',    '','Albertsen',     '432109876');
INSERT INTO Laerer  VALUES ('bir','Birger',    '','Jensen',        '321098765');
INSERT INTO Laerer  VALUES ('cha','Charles',   '','Jokumsen',      '210987654');
INSERT INTO Laerer  VALUES ('ing','Ingrid',    '','Poulsen',       '109876543');
INSERT INTO Laerer  VALUES ('chr','Christine', '','Andersen',      '098765432');
INSERT INTO Laerer  VALUES ('hom','Homer',     '','Simpson',       '121212121');
INSERT INTO Laerer  VALUES ('bar','Bart',      '','Simpson',       '232323232');
INSERT INTO Laerer  VALUES ('lis','Lisa',      '','Simpson',       '343434343');
INSERT INTO Laerer  VALUES ('mar','Marge',     '','Simpson',       '454545454');
INSERT INTO Laerer  VALUES ('abr','Abraham',   '','Simpson',       '565656565');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Lokale ...
SET TERMOUT OFF
INSERT INTO Lokale	VALUES ('H305','Stamlokale',  29);
INSERT INTO Lokale	VALUES ('H306','Stamlokale',  30);
INSERT INTO Lokale	VALUES ('H307','Stamlokale',  28);
INSERT INTO Lokale	VALUES ('H308','Edb',         30);
INSERT INTO Lokale	VALUES ('H309','Edb',         29);

INSERT INTO Lokale	VALUES ('B305','Stamlokale',  29);
INSERT INTO Lokale	VALUES ('B316','Stamlokale',  30);
INSERT INTO Lokale	VALUES ('B327','Stamlokale',  28);
INSERT INTO Lokale	VALUES ('B338','Stamlokale',  31);
INSERT INTO Lokale	VALUES ('D409','Stamlokale',  27);
INSERT INTO Lokale	VALUES ('D421','Stamlokale',  28);
INSERT INTO Lokale	VALUES ('D432','Stamlokale',  30);
INSERT INTO Lokale	VALUES ('F103','Stamlokale',  29);
INSERT INTO Lokale	VALUES ('F130','Stamlokale',  28);
INSERT INTO Lokale	VALUES ('E213','Edb',         30);
INSERT INTO Lokale	VALUES ('E214','Edb',         30);

INSERT INTO Lokale	VALUES ('O315','Stamlokale', 29);
INSERT INTO Lokale	VALUES ('O326','Stamlokale', 30);
INSERT INTO Lokale	VALUES ('O337','Stamlokale', 28);
INSERT INTO Lokale	VALUES ('O358','Stamlokale', 29);
INSERT INTO Lokale	VALUES ('O369','Stamlokale', 30);
INSERT INTO Lokale	VALUES ('P327','Stamlokale', 28);
INSERT INTO Lokale	VALUES ('P338','Stamlokale', 31);
INSERT INTO Lokale	VALUES ('P409','Stamlokale', 27);
INSERT INTO Lokale	VALUES ('P421','Stamlokale', 28);
INSERT INTO Lokale	VALUES ('P432','Stamlokale', 30);
INSERT INTO Lokale	VALUES ('R103','Stamlokale', 29);
INSERT INTO Lokale	VALUES ('R130','Stamlokale', 28);
INSERT INTO Lokale	VALUES ('Q308','Edb',        30);
INSERT INTO Lokale	VALUES ('Q309','Edb',        29);
INSERT INTO Lokale	VALUES ('X135','Stamlokale', 29);
INSERT INTO Lokale	VALUES ('X147','Stamlokale', 30);
INSERT INTO Lokale	VALUES ('X159','Stamlokale', 28);
INSERT INTO Lokale	VALUES ('X184','Stamlokale', 29);
INSERT INTO Lokale	VALUES ('X173','Stamlokale', 30);
INSERT INTO Lokale	VALUES ('X162','Stamlokale', 28);
INSERT INTO Lokale	VALUES ('Y240','Stamlokale', 31);
INSERT INTO Lokale	VALUES ('Y250','Stamlokale', 27);
INSERT INTO Lokale	VALUES ('Y260','Stamlokale', 28);
INSERT INTO Lokale	VALUES ('Y270','Stamlokale', 30);
INSERT INTO Lokale	VALUES ('Y280','Stamlokale', 29);
INSERT INTO Lokale	VALUES ('Y290','Stamlokale', 28);
INSERT INTO Lokale	VALUES ('Z314','Edb',        30);
INSERT INTO Lokale	VALUES ('Z341','Edb',        30);
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen TimeFagFordeling ...
SET TERMOUT OFF
INSERT INTO TimeFagFordeling
	VALUES ('Foraar_99',   'Foraar 99',   'Aktiv', 'Godkendt');
INSERT INTO TimeFagFordeling
	VALUES ('Efteraar_99', 'Efteraar 99', 'Aktiv', 'Godkendt');
INSERT INTO TimeFagFordeling
	VALUES ('Foraar_00',   'Foraar 00',   'Aktiv', 'Godkendt');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Plan ...
SET TERMOUT OFF
INSERT INTO PLAN	VALUES ('PF99','Plan Foraar 99',  'Foraar_99',  0, 5, 8);
INSERT INTO PLAN	VALUES ('PE99','Plan Efteraar 99','Efteraar_99',0, 5, 8);
INSERT INTO PLAN	VALUES ('PF00','Plan Foraar 00','Foraar_00'  ,0, 5, 8);
COMMIT;
SET TERMOUT ON

prompt Indsætter rækker i tabellen Fagliste ...
SET TERMOUT OFF
INSERT INTO Fagliste		VALUES ('Foraar_99',  'ikta');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'iktb');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'ehoa');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'ehob');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'afsa');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'afsb');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'inob');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'ehrb');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'idhb');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'miob');
INSERT INTO Fagliste		VALUES ('Foraar_99',  'mtmb');

INSERT INTO Fagliste		VALUES ('Efteraar_99', 'ikta');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'iktb');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'ehoa');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'ehob');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'afsa');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'afsb');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'inob');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'ehrb');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'idhb');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'miob');
INSERT INTO Fagliste		VALUES ('Efteraar_99', 'mtmb');

INSERT INTO Fagliste		VALUES ('Foraar_00', 'ikta');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'iktb');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'ehoa');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'ehob');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'afsa');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'afsb');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'inob');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'ehrb');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'idhb');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'miob');
INSERT INTO Fagliste		VALUES ('Foraar_00', 'mtmb');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Fagprofil ...
SET TERMOUT OFF
INSERT INTO Fagprofil		VALUES ('ikta','HHX1');
INSERT INTO Fagprofil		VALUES ('iktb','HHX3');
INSERT INTO Fagprofil		VALUES ('ehoa','HHX2');
INSERT INTO Fagprofil		VALUES ('ehob','HHX1');
INSERT INTO Fagprofil		VALUES ('ehob','HHX3');
INSERT INTO Fagprofil		VALUES ('afsa','HHX3');
INSERT INTO Fagprofil		VALUES ('afsb','HHX1');
INSERT INTO Fagprofil		VALUES ('afsb','HHX2');
INSERT INTO Fagprofil		VALUES ('inob','HHX1');
INSERT INTO Fagprofil		VALUES ('inob','HHX2');
INSERT INTO Fagprofil		VALUES ('inob','HHX3');
INSERT INTO Fagprofil		VALUES ('ehrb','HHX1');
INSERT INTO Fagprofil		VALUES ('ehrb','HHX2');
INSERT INTO Fagprofil		VALUES ('ehrb','HHX3');
INSERT INTO Fagprofil		VALUES ('idhb','HHX2');
INSERT INTO Fagprofil		VALUES ('idhb','HHX3');
INSERT INTO Fagprofil		VALUES ('miob','HHX1');
INSERT INTO Fagprofil		VALUES ('mtmb','HHX2');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen HoldLaererRelation ...
SET TERMOUT OFF
INSERT INTO HoldLaererRelation	VALUES ('lot','ikta','sa','PF99');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehob','sa','PF99');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','sa','PF99');
INSERT INTO HoldLaererRelation	VALUES ('han','afsb','sa','PF99');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','sa','PF99');
INSERT INTO HoldLaererRelation	VALUES ('las','miob','sa','PF99');
INSERT INTO HoldLaererRelation	VALUES ('lot','mtmb','se','PF99');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehoa','se','PF99');
INSERT INTO HoldLaererRelation	VALUES ('han','afsb','se','PF99');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','se','PF99');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','se','PF99');
INSERT INTO HoldLaererRelation	VALUES ('sus','idhb','se','PF99');
INSERT INTO HoldLaererRelation	VALUES ('lot','iktb','si','PF99');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehob','si','PF99');
INSERT INTO HoldLaererRelation	VALUES ('han','afsa','si','PF99');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','si','PF99');
INSERT INTO HoldLaererRelation	VALUES ('sus','idhb','si','PF99');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','si','PF99');

INSERT INTO HoldLaererRelation	VALUES ('lot','ikta','sb','PE99');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehob','sb','PE99');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','sb','PE99');
INSERT INTO HoldLaererRelation	VALUES ('han','afsb','sb','PE99');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','sb','PE99');
INSERT INTO HoldLaererRelation	VALUES ('las','miob','sb','PE99');
INSERT INTO HoldLaererRelation	VALUES ('lot','mtmb','sc','PE99');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehoa','sc','PE99');
INSERT INTO HoldLaererRelation	VALUES ('han','afsb','sc','PE99');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','sc','PE99');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','sc','PE99');
INSERT INTO HoldLaererRelation	VALUES ('sus','idhb','sc','PE99');
INSERT INTO HoldLaererRelation	VALUES ('lot','iktb','sd','PE99');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehob','sd','PE99');
INSERT INTO HoldLaererRelation	VALUES ('han','afsa','sd','PE99');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','sd','PE99');
INSERT INTO HoldLaererRelation	VALUES ('sus','idhb','sd','PE99');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','sd','PE99');
INSERT INTO HoldLaererRelation	VALUES ('pet','ikta','sf','PE99');
INSERT INTO HoldLaererRelation	VALUES ('seb','ehob','sf','PE99');
INSERT INTO HoldLaererRelation	VALUES ('pal','inob','sf','PE99');
INSERT INTO HoldLaererRelation	VALUES ('kim','afsb','sf','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ann','ehrb','sf','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ann','miob','sf','PE99');
INSERT INTO HoldLaererRelation	VALUES ('joh','mtmb','sg','PE99');
INSERT INTO HoldLaererRelation	VALUES ('bet','ehoa','sg','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ste','afsb','sg','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ann','ehrb','sg','PE99');
INSERT INTO HoldLaererRelation	VALUES ('pal','inob','sg','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ste','idhb','sg','PE99');
INSERT INTO HoldLaererRelation	VALUES ('joh','iktb','sh','PE99');
INSERT INTO HoldLaererRelation	VALUES ('seb','ehob','sh','PE99');
INSERT INTO HoldLaererRelation	VALUES ('kim','afsa','sh','PE99');
INSERT INTO HoldLaererRelation	VALUES ('jul','ehrb','sh','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ste','idhb','sh','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ibo','inob','sh','PE99');
INSERT INTO HoldLaererRelation	VALUES ('pet','ikta','sj','PE99');
INSERT INTO HoldLaererRelation	VALUES ('seb','ehob','sj','PE99');
INSERT INTO HoldLaererRelation	VALUES ('pal','inob','sj','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ste','afsb','sj','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ann','ehrb','sj','PE99');
INSERT INTO HoldLaererRelation	VALUES ('pet','miob','sj','PE99');
INSERT INTO HoldLaererRelation	VALUES ('joh','mtmb','sk','PE99');
INSERT INTO HoldLaererRelation	VALUES ('bet','ehoa','sk','PE99');
INSERT INTO HoldLaererRelation	VALUES ('kim','afsb','sk','PE99');
INSERT INTO HoldLaererRelation	VALUES ('jul','ehrb','sk','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ibo','inob','sk','PE99');
INSERT INTO HoldLaererRelation	VALUES ('pal','idhb','sk','PE99');
INSERT INTO HoldLaererRelation	VALUES ('joh','iktb','sl','PE99');
INSERT INTO HoldLaererRelation	VALUES ('seb','ehob','sl','PE99');
INSERT INTO HoldLaererRelation	VALUES ('kim','afsa','sl','PE99');
INSERT INTO HoldLaererRelation	VALUES ('jul','ehrb','sl','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ste','idhb','sl','PE99');
INSERT INTO HoldLaererRelation	VALUES ('ibo','inob','sl','PE99');

INSERT INTO HoldLaererRelation	VALUES ('seb','ehob','stz','PF00');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','stz','PF00');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','stz','PF00');
INSERT INTO HoldLaererRelation	VALUES ('anj','ehrb','stx','PF00');
INSERT INTO HoldLaererRelation	VALUES ('las','miob','stx','PF00');
INSERT INTO HoldLaererRelation	VALUES ('joh','mtmb','sty','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bet','ehoa','sty','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bar','afsb','sty','PF00');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','sty','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ibh','inob','sty','PF00');
INSERT INTO HoldLaererRelation	VALUES ('abr','idhb','sty','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bir','iktb','stz','PF00');
INSERT INTO HoldLaererRelation	VALUES ('hom','idhb','stz','PF00');
INSERT INTO HoldLaererRelation	VALUES ('apu','afsa','stz','PF00');
INSERT INTO HoldLaererRelation	VALUES ('seb','ehob','stx','PF00');
INSERT INTO HoldLaererRelation	VALUES ('seb','ehob','stv','PF00');
INSERT INTO HoldLaererRelation	VALUES ('chr','afsa','stv','PF00');
INSERT INTO HoldLaererRelation	VALUES ('las','ehrb','stv','PF00');
INSERT INTO HoldLaererRelation	VALUES ('boe','idhb','stv','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ibh','inob','stv','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ben','ikta','stx','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ibh','inob','stx','PF00');
INSERT INTO HoldLaererRelation	VALUES ('han','afsb','stx','PF00');
INSERT INTO HoldLaererRelation	VALUES ('boe','ikta','sta','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ing','ehob','sta','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pal','inob','sta','PF00');
INSERT INTO HoldLaererRelation	VALUES ('kim','afsb','sta','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bar','ehrb','sta','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lis','miob','sta','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bir','mtmb','ste','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehoa','ste','PF00');
INSERT INTO HoldLaererRelation	VALUES ('hom','afsb','ste','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bar','ehrb','ste','PF00');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','ste','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pal','idhb','ste','PF00');
INSERT INTO HoldLaererRelation	VALUES ('kat','iktb','sti','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ing','ehob','sti','PF00');
INSERT INTO HoldLaererRelation	VALUES ('kim','afsa','sti','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lar','ehrb','sti','PF00');
INSERT INTO HoldLaererRelation	VALUES ('aag','idhb','sti','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pal','inob','sti','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lot','ikta','stb','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mak','ehob','stb','PF00');
INSERT INTO HoldLaererRelation	VALUES ('sus','inob','stb','PF00');
INSERT INTO HoldLaererRelation	VALUES ('kim','afsb','stb','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bar','ehrb','stb','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lar','miob','stb','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lot','mtmb','stc','PF00');
INSERT INTO HoldLaererRelation	VALUES ('cha','ehoa','stc','PF00');
INSERT INTO HoldLaererRelation	VALUES ('hom','afsb','stc','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lar','ehrb','stc','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pal','inob','stc','PF00');
INSERT INTO HoldLaererRelation	VALUES ('sus','idhb','stc','PF00');
INSERT INTO HoldLaererRelation	VALUES ('joh','iktb','std','PF00');
INSERT INTO HoldLaererRelation	VALUES ('chr','ehob','std','PF00');
INSERT INTO HoldLaererRelation	VALUES ('kim','afsa','std','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lar','ehrb','std','PF00');
INSERT INTO HoldLaererRelation	VALUES ('suj','idhb','std','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ibo','inob','std','PF00');
INSERT INTO HoldLaererRelation	VALUES ('kat','ikta','stf','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ing','ehob','stf','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ibo','inob','stf','PF00');
INSERT INTO HoldLaererRelation	VALUES ('hom','afsb','stf','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lis','ehrb','stf','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lis','miob','stf','PF00');
INSERT INTO HoldLaererRelation	VALUES ('kat','mtmb','stg','PF00');
INSERT INTO HoldLaererRelation	VALUES ('cha','ehoa','stg','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ste','afsb','stg','PF00');
INSERT INTO HoldLaererRelation	VALUES ('jup','ehrb','stg','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ibo','inob','stg','PF00');
INSERT INTO HoldLaererRelation	VALUES ('suj','idhb','stg','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lot','iktb','sth','PF00');
INSERT INTO HoldLaererRelation	VALUES ('seo','ehob','sth','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ove','afsa','sth','PF00');
INSERT INTO HoldLaererRelation	VALUES ('jul','ehrb','sth','PF00');
INSERT INTO HoldLaererRelation	VALUES ('aag','idhb','sth','PF00');
INSERT INTO HoldLaererRelation	VALUES ('suj','inob','sth','PF00');
INSERT INTO HoldLaererRelation	VALUES ('boe','ikta','stj','PF00');
INSERT INTO HoldLaererRelation	VALUES ('seo','ehob','stj','PF00');
INSERT INTO HoldLaererRelation	VALUES ('suj','inob','stj','PF00');
INSERT INTO HoldLaererRelation	VALUES ('apu','afsb','stj','PF00');
INSERT INTO HoldLaererRelation	VALUES ('jul','ehrb','stj','PF00');
INSERT INTO HoldLaererRelation	VALUES ('anj','miob','stj','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bir','mtmb','stk','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bet','ehoa','stk','PF00');
INSERT INTO HoldLaererRelation	VALUES ('aag','afsb','stk','PF00');
INSERT INTO HoldLaererRelation	VALUES ('jul','ehrb','stk','PF00');
INSERT INTO HoldLaererRelation	VALUES ('suj','inob','stk','PF00');
INSERT INTO HoldLaererRelation	VALUES ('sus','idhb','stk','PF00');
INSERT INTO HoldLaererRelation	VALUES ('joh','iktb','stl','PF00');
INSERT INTO HoldLaererRelation	VALUES ('seo','ehob','stl','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ove','afsa','stl','PF00');
INSERT INTO HoldLaererRelation	VALUES ('jup','ehrb','stl','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mar','idhb','stl','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mar','inob','stl','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pet','ikta','stn','PF00');
INSERT INTO HoldLaererRelation	VALUES ('seo','ehob','stn','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mar','inob','stn','PF00');
INSERT INTO HoldLaererRelation	VALUES ('apu','afsb','stn','PF00');
INSERT INTO HoldLaererRelation	VALUES ('jup','ehrb','stn','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pet','miob','stn','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pau','mtmb','sto','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mak','ehoa','sto','PF00');
INSERT INTO HoldLaererRelation	VALUES ('aag','afsb','sto','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ann','ehrb','sto','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mar','inob','sto','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ste','idhb','sto','PF00');
INSERT INTO HoldLaererRelation	VALUES ('bir','iktb','stp','PF00');
INSERT INTO HoldLaererRelation	VALUES ('seb','ehob','stp','PF00');
INSERT INTO HoldLaererRelation	VALUES ('han','afsa','stp','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ann','ehrb','stp','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ste','idhb','stp','PF00');
INSERT INTO HoldLaererRelation	VALUES ('abr','inob','stp','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ben','ikta','stq','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mak','ehob','stq','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ole','inob','stq','PF00');
INSERT INTO HoldLaererRelation	VALUES ('han','afsb','stq','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lis','ehrb','stq','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ann','miob','stq','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pau','mtmb','str','PF00');
INSERT INTO HoldLaererRelation	VALUES ('sti','ehoa','str','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ste','afsb','str','PF00');
INSERT INTO HoldLaererRelation	VALUES ('lis','ehrb','str','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ole','inob','str','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ste','idhb','str','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pau','iktb','sts','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehob','sts','PF00');
INSERT INTO HoldLaererRelation	VALUES ('chr','afsa','sts','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ann','ehrb','sts','PF00');
INSERT INTO HoldLaererRelation	VALUES ('aag','idhb','sts','PF00');
INSERT INTO HoldLaererRelation	VALUES ('abr','inob','sts','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pet','ikta','stt','PF00');
INSERT INTO HoldLaererRelation	VALUES ('mik','ehob','stt','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ole','inob','stt','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ove','afsb','stt','PF00');
INSERT INTO HoldLaererRelation	VALUES ('anj','ehrb','stt','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ben','miob','stt','PF00');
INSERT INTO HoldLaererRelation	VALUES ('joh','mtmb','stu','PF00');
INSERT INTO HoldLaererRelation	VALUES ('sti','ehoa','stu','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ove','afsb','stu','PF00');
INSERT INTO HoldLaererRelation	VALUES ('anj','ehrb','stu','PF00');
INSERT INTO HoldLaererRelation	VALUES ('abr','inob','stu','PF00');
INSERT INTO HoldLaererRelation	VALUES ('ole','idhb','stu','PF00');
INSERT INTO HoldLaererRelation	VALUES ('pau','iktb','stv','PF00');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Holdliste ...
SET TERMOUT OFF
INSERT INTO Holdliste		VALUES ('Foraar_99', 'sa');
INSERT INTO Holdliste		VALUES ('Foraar_99', 'se');
INSERT INTO Holdliste		VALUES ('Foraar_99', 'si');

INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sb');
INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sc');
INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sd');
INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sf');
INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sg');
INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sh');
INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sj');
INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sk');
INSERT INTO Holdliste		VALUES ('Efteraar_99', 'sl');

INSERT INTO Holdliste		VALUES ('Foraar_00', 'sta');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'ste');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'sti');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stb');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stc');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'std');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stf');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stg');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'sth');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stj');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stk');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stl');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stn');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'sto');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stp');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stq');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'str');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'sts');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stt');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stu');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stv');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stx');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'sty');
INSERT INTO Holdliste		VALUES ('Foraar_00', 'stz');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen LaererFagProfil ...
SET TERMOUT OFF
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','lot','ikta', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','lot','iktb', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','lot','mtmb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','mik','ehoa', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','mik','ehob', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','han','afsa', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','han','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','las','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','las','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','sus','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_99','sus','idhb', 1, 2);

INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','lot','ikta', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','lot','iktb', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','lot','mtmb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','mik','ehoa', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','mik','ehob', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','han','afsa', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','han','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','las','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','las','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','sus','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','sus','idhb', 1, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','pet','ikta', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','pet','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','joh','iktb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','joh','mtmb', 1, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','ann','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','ann','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','jul','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','bet','ehoa', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','seb','ehob', 2, 4);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','ste','idhb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','ste','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','pal','idhb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','pal','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','kim','afsa', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','kim','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Efteraar_99','ibo','inob', 2, 3);

INSERT INTO LaererFagProfil	VALUES ('Foraar_00','lot','ikta', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','lot','iktb', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','lot','mtmb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','mik','ehoa', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','mik','ehob', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','han','afsa', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','han','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','las','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','las','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','sus','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','sus','idhb', 1, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','pet','ikta', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','pet','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','joh','iktb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','joh','mtmb', 1, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ann','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ann','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','jul','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','bet','ehoa', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','seb','ehob', 2, 4);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ste','idhb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ste','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','pal','idhb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','pal','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','kim','afsa', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','kim','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ibo','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','kat','ikta', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','kat','iktb', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','kat','mtmb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','mak','ehoa', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','mak','ehob', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','apu','afsa', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','apu','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','lar','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','lar','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','suj','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','suj','idhb', 1, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ben','ikta', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ben','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','pau','iktb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','pau','mtmb', 1, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','anj','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','anj','miob', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','jup','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','sti','ehoa', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','seo','ehob', 2, 4);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','aag','idhb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','aag','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ole','idhb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ole','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ove','afsa', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ove','afsb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ibh','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','boe','ikta', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','boe','idhb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','bir','iktb', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','bir','mtmb', 1, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','cha','ehoa', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','ing','ehob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','chr','ehob', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','chr','afsa', 2, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','hom','afsb', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','hom','idhb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','bar','afsb', 2, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','bar','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','lis','ehrb', 1, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','lis','miob', 1, 2);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','mar','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','mar','idhb', 1, 1);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','abr','inob', 2, 3);
INSERT INTO LaererFagProfil	VALUES ('Foraar_00','abr','idhb', 1, 1);
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Laererliste ...
SET TERMOUT OFF
INSERT INTO Laererliste		VALUES ('Foraar_99', 'lot');
INSERT INTO Laererliste		VALUES ('Foraar_99', 'mik');
INSERT INTO Laererliste		VALUES ('Foraar_99', 'han');
INSERT INTO Laererliste		VALUES ('Foraar_99', 'las');
INSERT INTO Laererliste		VALUES ('Foraar_99', 'sus');

INSERT INTO Laererliste		VALUES ('Efteraar_99', 'lot');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'mik');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'han');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'las');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'sus');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'pet');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'joh');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'ann');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'jul');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'bet');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'seb');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'ste');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'pal');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'kim');
INSERT INTO Laererliste		VALUES ('Efteraar_99', 'ibo');

INSERT INTO Laererliste		VALUES ('Foraar_00', 'lot');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'mik');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'han');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'las');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'sus');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'pet');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'joh');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'ann');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'jul');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'bet');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'seb');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'ste');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'pal');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'kim');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'ibo');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'kat');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'mak');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'apu');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'lar');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'suj');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'ben');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'pau');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'anj');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'jup');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'sti');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'seo');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'aag');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'ole');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'ove');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'ibh');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'boe');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'bir');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'cha');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'ing');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'chr');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'hom');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'bar');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'lis');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'mar');
INSERT INTO Laererliste		VALUES ('Foraar_00', 'abr');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Lektion ...
SET TERMOUT OFF
--Ingen rækker.
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen LokaleHoldRelation ...
SET TERMOUT OFF
INSERT INTO LokaleHoldRelation	VALUES ('H305','PF99','sa');
INSERT INTO LokaleHoldRelation	VALUES ('H306','PF99','se');
INSERT INTO LokaleHoldRelation	VALUES ('H307','PF99','si');

INSERT INTO LokaleHoldRelation	VALUES ('B305','PE99','sb');
INSERT INTO LokaleHoldRelation	VALUES ('B316','PE99','sc');
INSERT INTO LokaleHoldRelation	VALUES ('B327','PE99','sd');
INSERT INTO LokaleHoldRelation	VALUES ('B338','PE99','sf');
INSERT INTO LokaleHoldRelation	VALUES ('D409','PE99','sg');
INSERT INTO LokaleHoldRelation	VALUES ('D421','PE99','sh');
INSERT INTO LokaleHoldRelation	VALUES ('D432','PE99','sj');
INSERT INTO LokaleHoldRelation	VALUES ('F103','PE99','sk');
INSERT INTO LokaleHoldRelation	VALUES ('F130','PE99','sl');

INSERT INTO LokaleHoldRelation	VALUES ('O315','PF00','sta');
INSERT INTO LokaleHoldRelation	VALUES ('O326','PF00','ste');
INSERT INTO LokaleHoldRelation	VALUES ('O337','PF00','sti');
INSERT INTO LokaleHoldRelation	VALUES ('O358','PF00','stb');
INSERT INTO LokaleHoldRelation	VALUES ('O369','PF00','stc');
INSERT INTO LokaleHoldRelation	VALUES ('P327','PF00','std');
INSERT INTO LokaleHoldRelation	VALUES ('P338','PF00','stf');
INSERT INTO LokaleHoldRelation	VALUES ('P409','PF00','stg');
INSERT INTO LokaleHoldRelation	VALUES ('P421','PF00','sth');
INSERT INTO LokaleHoldRelation	VALUES ('P432','PF00','stj');
INSERT INTO LokaleHoldRelation	VALUES ('R103','PF00','stk');
INSERT INTO LokaleHoldRelation	VALUES ('R130','PF00','stl');
INSERT INTO LokaleHoldRelation	VALUES ('X135','PF00','stn');
INSERT INTO LokaleHoldRelation	VALUES ('X147','PF00','sto');
INSERT INTO LokaleHoldRelation	VALUES ('X159','PF00','stp');
INSERT INTO LokaleHoldRelation	VALUES ('X184','PF00','stq');
INSERT INTO LokaleHoldRelation	VALUES ('X173','PF00','str');
INSERT INTO LokaleHoldRelation	VALUES ('X162','PF00','sts');
INSERT INTO LokaleHoldRelation	VALUES ('Y240','PF00','stt');
INSERT INTO LokaleHoldRelation	VALUES ('Y250','PF00','stu');
INSERT INTO LokaleHoldRelation	VALUES ('Y260','PF00','stv');
INSERT INTO LokaleHoldRelation	VALUES ('Y270','PF00','stx');
INSERT INTO LokaleHoldRelation	VALUES ('Y280','PF00','sty');
INSERT INTO LokaleHoldRelation	VALUES ('Y290','PF00','stz');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Lokaleplan ...
SET TERMOUT OFF
INSERT INTO Lokaleplan		VALUES ('H305', 'PF99');
INSERT INTO Lokaleplan		VALUES ('H306', 'PF99');
INSERT INTO Lokaleplan		VALUES ('H307', 'PF99');
INSERT INTO Lokaleplan		VALUES ('H308', 'PF99');
INSERT INTO Lokaleplan		VALUES ('H309', 'PF99');

INSERT INTO Lokaleplan		VALUES ('B305', 'PE99');
INSERT INTO Lokaleplan		VALUES ('B316', 'PE99');
INSERT INTO Lokaleplan		VALUES ('B327', 'PE99');
INSERT INTO Lokaleplan		VALUES ('B338', 'PE99');
INSERT INTO Lokaleplan		VALUES ('D409', 'PE99');
INSERT INTO Lokaleplan		VALUES ('D421', 'PE99');
INSERT INTO Lokaleplan		VALUES ('D432', 'PE99');
INSERT INTO Lokaleplan		VALUES ('F103', 'PE99');
INSERT INTO Lokaleplan		VALUES ('F130', 'PE99');
INSERT INTO Lokaleplan		VALUES ('E213', 'PE99');
INSERT INTO Lokaleplan		VALUES ('E214', 'PE99');

INSERT INTO Lokaleplan		VALUES ('O315', 'PF00');
INSERT INTO Lokaleplan		VALUES ('O326', 'PF00');
INSERT INTO Lokaleplan		VALUES ('O337', 'PF00');
INSERT INTO Lokaleplan		VALUES ('O358', 'PF00');
INSERT INTO Lokaleplan		VALUES ('O369', 'PF00');
INSERT INTO Lokaleplan		VALUES ('P327', 'PF00');
INSERT INTO Lokaleplan		VALUES ('P338', 'PF00');
INSERT INTO Lokaleplan		VALUES ('P409', 'PF00');
INSERT INTO Lokaleplan		VALUES ('P421', 'PF00');
INSERT INTO Lokaleplan		VALUES ('P432', 'PF00');
INSERT INTO Lokaleplan		VALUES ('R103', 'PF00');
INSERT INTO Lokaleplan		VALUES ('R130', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Q308', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Q309', 'PF00');
INSERT INTO Lokaleplan		VALUES ('X135', 'PF00');
INSERT INTO Lokaleplan		VALUES ('X147', 'PF00');
INSERT INTO Lokaleplan		VALUES ('X159', 'PF00');
INSERT INTO Lokaleplan		VALUES ('X184', 'PF00');
INSERT INTO Lokaleplan		VALUES ('X173', 'PF00');
INSERT INTO Lokaleplan		VALUES ('X162', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Y240', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Y250', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Y260', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Y270', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Y280', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Y290', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Z314', 'PF00');
INSERT INTO Lokaleplan		VALUES ('Z341', 'PF00');
COMMIT;
SET TERMOUT ON

PROMPT Indsætter rækker i tabellen Tidsprioritet ...
SET TERMOUT OFF
INSERT INTO Tidsprioritet	VALUES ('PF99','lot', -3, 0, 0);
INSERT INTO Tidsprioritet	VALUES ('PF99','lot', -3, 0, 1);
INSERT INTO Tidsprioritet	VALUES ('PF99','lot', -3, 0, 2);
INSERT INTO Tidsprioritet	VALUES ('PF99','lot', -3, 0, 3);
INSERT INTO Tidsprioritet	VALUES ('PF99','lot', -3, 0, 4);
INSERT INTO Tidsprioritet	VALUES ('PF99','lot', -3, 0, 5);
INSERT INTO Tidsprioritet	VALUES ('PF99','lot', -3, 0, 6);
INSERT INTO Tidsprioritet	VALUES ('PF99','lot', -3, 0, 7);
INSERT INTO Tidsprioritet	VALUES ('PF99','mik', -3, 1, 4);
INSERT INTO Tidsprioritet	VALUES ('PF99','mik', -3, 1, 5);
INSERT INTO Tidsprioritet	VALUES ('PF99','mik', -3, 1, 6);
INSERT INTO Tidsprioritet	VALUES ('PF99','mik', -3, 1, 7);
INSERT INTO Tidsprioritet	VALUES ('PF99','mik', -3, 2, 0);
INSERT INTO Tidsprioritet	VALUES ('PF99','mik', -3, 2, 1);
INSERT INTO Tidsprioritet	VALUES ('PF99','mik', -3, 2, 2);
INSERT INTO Tidsprioritet	VALUES ('PF99','mik', -3, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PF99','han', -3, 0, 0);
INSERT INTO Tidsprioritet	VALUES ('PF99','han', -3, 1, 0);
INSERT INTO Tidsprioritet	VALUES ('PF99','han', -3, 2, 0);
INSERT INTO Tidsprioritet	VALUES ('PF99','han', -3, 3, 0);
INSERT INTO Tidsprioritet	VALUES ('PF99','han', -3, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PF99','han', -3, 4, 6);
INSERT INTO Tidsprioritet	VALUES ('PF99','han', -3, 4, 7);
INSERT INTO Tidsprioritet	VALUES ('PF99','las', -3, 3, 6);
INSERT INTO Tidsprioritet	VALUES ('PF99','las', -3, 3, 7);
INSERT INTO Tidsprioritet	VALUES ('PF99','las', -3, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PF99','las', -3, 2, 4);
INSERT INTO Tidsprioritet	VALUES ('PF99','sus', -3, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PF99','sus', -3, 4, 1);
INSERT INTO Tidsprioritet	VALUES ('PF99','sus', -3, 4, 2);
INSERT INTO Tidsprioritet	VALUES ('PF99','sus', -3, 4, 3);
INSERT INTO Tidsprioritet	VALUES ('PF99','sus', -3, 4, 4);
INSERT INTO Tidsprioritet	VALUES ('PF99','sus', -3, 4, 5);
INSERT INTO Tidsprioritet	VALUES ('PF99','sus', -3, 4, 6);
INSERT INTO Tidsprioritet	VALUES ('PF99','sus', -3, 4, 7);

INSERT INTO Tidsprioritet	VALUES ('PE99','lot', -3, 0, 4);
INSERT INTO Tidsprioritet	VALUES ('PE99','lot', -3, 0, 5);
INSERT INTO Tidsprioritet	VALUES ('PE99','lot', -3, 0, 6);
INSERT INTO Tidsprioritet	VALUES ('PE99','lot', -3, 0, 7);
INSERT INTO Tidsprioritet	VALUES ('PE99','mik', -3, 2, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','mik', -3, 2, 1);
INSERT INTO Tidsprioritet	VALUES ('PE99','mik', -3, 2, 2);
INSERT INTO Tidsprioritet	VALUES ('PE99','mik', -3, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','han', -3, 0, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','han', -3, 1, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','han', -3, 2, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','han', -3, 3, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','han', -3, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','las', -3, 3, 6);
INSERT INTO Tidsprioritet	VALUES ('PE99','las', -3, 3, 7);
INSERT INTO Tidsprioritet	VALUES ('PE99','las', -3, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','las', -3, 2, 4);
INSERT INTO Tidsprioritet	VALUES ('PE99','sus', -3, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','sus', -3, 4, 1);
INSERT INTO Tidsprioritet	VALUES ('PE99','sus', -3, 4, 2);
INSERT INTO Tidsprioritet	VALUES ('PE99','sus', -3, 4, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','pet', -3, 0, 6);
INSERT INTO Tidsprioritet	VALUES ('PE99','pet', -3, 0, 7);
INSERT INTO Tidsprioritet	VALUES ('PE99','pet', -1, 0, 5);
INSERT INTO Tidsprioritet	VALUES ('PE99','pet',  1, 0, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','joh', -3, 1, 1);
INSERT INTO Tidsprioritet	VALUES ('PE99','joh', -3, 1, 6);
INSERT INTO Tidsprioritet	VALUES ('PE99','joh',  3, 2, 7);
INSERT INTO Tidsprioritet	VALUES ('PE99','joh',  2, 2, 5);
INSERT INTO Tidsprioritet	VALUES ('PE99','ann', -3, 2, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','ann', -3, 2, 1);
INSERT INTO Tidsprioritet	VALUES ('PE99','ann', -2, 2, 2);
INSERT INTO Tidsprioritet	VALUES ('PE99','ann', -1, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','jul', -3, 3, 7);
INSERT INTO Tidsprioritet	VALUES ('PE99','jul', -3, 3, 6);
INSERT INTO Tidsprioritet	VALUES ('PE99','jul',  2, 2, 5);
INSERT INTO Tidsprioritet	VALUES ('PE99','jul',  2, 2, 4);
INSERT INTO Tidsprioritet	VALUES ('PE99','bet',  3, 0, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','bet',  3, 0, 1);
INSERT INTO Tidsprioritet	VALUES ('PE99','bet',  3, 4, 6);
INSERT INTO Tidsprioritet	VALUES ('PE99','bet',  3, 4, 7);
INSERT INTO Tidsprioritet	VALUES ('PE99','seb', -3, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','seb', -2, 4, 1);
INSERT INTO Tidsprioritet	VALUES ('PE99','seb', -1, 4, 2);
INSERT INTO Tidsprioritet	VALUES ('PE99','seb',  1, 4, 4);
INSERT INTO Tidsprioritet	VALUES ('PE99','ste', -3, 3, 6);
INSERT INTO Tidsprioritet	VALUES ('PE99','ste', -3, 3, 7);
INSERT INTO Tidsprioritet	VALUES ('PE99','ste', -1, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PE99','ste', -1, 4, 1);
INSERT INTO Tidsprioritet	VALUES ('PE99','pal', -3, 2, 2);
INSERT INTO Tidsprioritet	VALUES ('PE99','pal', -3, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','pal',  3, 4, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','pal',  1, 4, 4);
INSERT INTO Tidsprioritet	VALUES ('PE99','kim', -3, 1, 6);
INSERT INTO Tidsprioritet	VALUES ('PE99','kim', -3, 1, 7);
INSERT INTO Tidsprioritet	VALUES ('PE99','kim',  1, 2, 4);
INSERT INTO Tidsprioritet	VALUES ('PE99','kim',  2, 2, 5);
INSERT INTO Tidsprioritet	VALUES ('PE99','ibo', -3, 0, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','ibo', -3, 0, 4);
INSERT INTO Tidsprioritet	VALUES ('PE99','ibo',  3, 3, 3);
INSERT INTO Tidsprioritet	VALUES ('PE99','ibo',  3, 3, 4);

INSERT INTO Tidsprioritet	VALUES ('PF00','lot', -3, 0, 4);
INSERT INTO Tidsprioritet	VALUES ('PF00','lot', -3, 0, 5);
INSERT INTO Tidsprioritet	VALUES ('PF00','lot', -3, 0, 6);
INSERT INTO Tidsprioritet	VALUES ('PF00','lot', -3, 0, 7);
INSERT INTO Tidsprioritet	VALUES ('PF00','mik', -3, 2, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','mik', -3, 2, 1);
INSERT INTO Tidsprioritet	VALUES ('PF00','mik', -3, 2, 2);
INSERT INTO Tidsprioritet	VALUES ('PF00','mik', -3, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','han', -3, 0, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','han', -3, 1, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','han', -3, 2, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','han', -3, 3, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','han', -3, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','las', -3, 3, 6);
INSERT INTO Tidsprioritet	VALUES ('PF00','las', -3, 3, 7);
INSERT INTO Tidsprioritet	VALUES ('PF00','las', -3, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','las', -3, 2, 4);
INSERT INTO Tidsprioritet	VALUES ('PF00','sus', -3, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','sus', -3, 4, 1);
INSERT INTO Tidsprioritet	VALUES ('PF00','sus', -3, 4, 2);
INSERT INTO Tidsprioritet	VALUES ('PF00','sus', -3, 4, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','pet', -3, 0, 6);
INSERT INTO Tidsprioritet	VALUES ('PF00','pet', -3, 0, 7);
INSERT INTO Tidsprioritet	VALUES ('PF00','pet', -1, 0, 5);
INSERT INTO Tidsprioritet	VALUES ('PF00','pet',  1, 0, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','joh', -3, 1, 1);
INSERT INTO Tidsprioritet	VALUES ('PF00','joh', -3, 1, 6);
INSERT INTO Tidsprioritet	VALUES ('PF00','joh',  3, 2, 7);
INSERT INTO Tidsprioritet	VALUES ('PF00','joh',  2, 2, 5);
INSERT INTO Tidsprioritet	VALUES ('PF00','ann', -3, 2, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','ann', -3, 2, 1);
INSERT INTO Tidsprioritet	VALUES ('PF00','ann', -2, 2, 2);
INSERT INTO Tidsprioritet	VALUES ('PF00','ann', -1, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','jul', -3, 3, 7);
INSERT INTO Tidsprioritet	VALUES ('PF00','jul', -3, 3, 6);
INSERT INTO Tidsprioritet	VALUES ('PF00','jul',  2, 2, 5);
INSERT INTO Tidsprioritet	VALUES ('PF00','jul',  2, 2, 4);
INSERT INTO Tidsprioritet	VALUES ('PF00','bet',  3, 0, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','bet',  3, 0, 1);
INSERT INTO Tidsprioritet	VALUES ('PF00','bet',  3, 4, 6);
INSERT INTO Tidsprioritet	VALUES ('PF00','bet',  3, 4, 7);
INSERT INTO Tidsprioritet	VALUES ('PF00','seb', -3, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','seb', -2, 4, 1);
INSERT INTO Tidsprioritet	VALUES ('PF00','seb', -1, 4, 2);
INSERT INTO Tidsprioritet	VALUES ('PF00','seb',  1, 4, 4);
INSERT INTO Tidsprioritet	VALUES ('PF00','ste', -3, 3, 6);
INSERT INTO Tidsprioritet	VALUES ('PF00','ste', -3, 3, 7);
INSERT INTO Tidsprioritet	VALUES ('PF00','ste', -1, 4, 0);
INSERT INTO Tidsprioritet	VALUES ('PF00','ste', -1, 4, 1);
INSERT INTO Tidsprioritet	VALUES ('PF00','pal', -3, 2, 2);
INSERT INTO Tidsprioritet	VALUES ('PF00','pal', -3, 2, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','pal',  3, 4, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','pal',  1, 4, 4);
INSERT INTO Tidsprioritet	VALUES ('PF00','kim', -3, 1, 6);
INSERT INTO Tidsprioritet	VALUES ('PF00','kim', -3, 1, 7);
INSERT INTO Tidsprioritet	VALUES ('PF00','kim',  1, 2, 4);
INSERT INTO Tidsprioritet	VALUES ('PF00','kim',  2, 2, 5);
INSERT INTO Tidsprioritet	VALUES ('PF00','ibo', -3, 0, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','ibo', -3, 0, 4);
INSERT INTO Tidsprioritet	VALUES ('PF00','ibo',  3, 3, 3);
INSERT INTO Tidsprioritet	VALUES ('PF00','ibo',  3, 3, 4);
SET TERMOUT ON

COMMIT;

SPOOL OFF		
	--Stopper udskrivning til filen og lukker den.
