************************************************************************************** * Bemærk at denne fil kun er til orientering om databaseændringer til denne release. * * Filen MÅ IKKE afvikles! * ************************************************************************************** update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'DIG01'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'DIG02'; commit; update lokalfag set proeveformMundtlig = 'X', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'DIG03'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'DIG11'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'DIG12'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'DIG13'; commit; update lokalfag set proeveformMundtlig = 'X', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'DIG14'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'ENG01'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'ENG02'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'ENG03'; commit; update lokalfag set proeveformMundtlig = 'X', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'ENG04'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'ENG11'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'ENG12'; commit; update lokalfag set proeveformMundtlig = ' ', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'ENG13'; commit; update lokalfag set proeveformMundtlig = 'X', proeveformProjekt = ' ', proeveformSkriftlig = ' ', proeveformStrSkrOpg = ' ', proeveformAndet = ' ' where fagKode = 'ENG14'; commit; update lokalfag set proeveformMundtlig = 'X' where fagkode = 'DIG14'; update lokalfag set proeveformMundtlig = 'X' where fagkode = 'ENG14'; commit; IF ((select count(*) from lokalfag where fagkode = 'ENG11E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('ENG11E','FVU',' ',0.00,0.00,'Fagelement, Engelsk trin 1','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Engelsk trin 1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22073,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'ENG12E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('ENG12E','FVU',' ',0.00,0.00,'Fagelement, Engelsk trin 2','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Engelsk trin 2',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22074,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'ENG13E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('ENG13E','FVU',' ',0.00,0.00,'Fagelement, Engelsk trin 3','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Engelsk trin 3',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22075,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'ENG14E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('ENG14E','FVU',' ',0.00,0.00,'Fagelement, Engelsk trin 4','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Engelsk trin 4',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22075,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'DIG11E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('DIG11E','FVU',' ',0.00,0.00,'Fagelement, Digital trin 1','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Digital trin 1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22077,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'DIG12E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('DIG12E','FVU',' ',0.00,0.00,'Fagelement, Digital trin 2','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Digital trin 2',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22078,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'DIG13E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('DIG13E','FVU',' ',0.00,0.00,'Fagelement, Digital trin 3','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Digital trin 3',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22079,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'DIG14E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('DIG14E','FVU',' ',0.00,0.00,'Fagelement, Digital trin 4','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Digital trin 4',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22081,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'MAT01E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('MAT01E','FVU',' ',0.00,0.00,'Fagelement, Matematik trin 1','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Matematik trin 1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22082,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'MAT02E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('MAT02E','FVU',' ',0.00,0.00,'Fagelement, Matematik trin 2','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Matematik trin 2',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22083,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'DAN01E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('DAN01E','FVU',' ',0.00,0.00,'Fagelement, Dansk trin 1','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Dansk trin 1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22086,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'DAN02E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('DAN02E','FVU',' ',0.00,0.00,'Fagelement, Dansk trin 2','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Dansk trin 2',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22087,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'DAN03E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('DAN03E','FVU',' ',0.00,0.00,'Fagelement, Dansk trin 3','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Dansk trin 3',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22088,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; IF ((select count(*) from lokalfag where fagkode = 'DAN04E') = 0) THEN INSERT INTO "DBA"."LokalFag" ("fagKode","fagType","udgaaet","apparatOpstilling","konferenceTimer","navn","niveau","proeveformMundtlig","proeveformProjekt","proeveformSkriftlig","retteTillaeg","synonym","tidsforbrugProjekt","timetal","proeveformAndet","proeveformStrSkrOpg","tidsforbrugStrSkrOpg","fag","deltagerBetaling","deltagerBetalingSS","timerTilUdarbejdelseAfProeveSaet","deltagerBetalingAabentVUC","modultakst","proeveTilFagKode","modultakstA","modultakstB","modultakstC","modultakstD","modultakstE","modultakstF","skriftligAarskarakter","mundtligAarskarakter","antalEksaminationerPrDag","mundtligForberedelsestid","mundtligEksaminationstid","skriftligEksaminationstid","gruppeEksamen","eksamenLokaleForbrug","gruppeForberedelse","eksternForberedelseTid","xprsFagKode","xprsNiveau","tidsforbrugSkriftlig","tidsforbrugAndet","modultakstID","lvuGrundtakstEksamination","lvuFaktorTilEksamination","lvuGrundtakstCensur","lvuFaktorTilCensur","lvuAntalKursisterPrGruppe","timetalAften","respekterGruppeForberedelseVedEksamensplanlaegning","skriftligCensortid","samletVurdering","kursisttid","antalNiveauer","harNiveauPaaMindst100Timer") VALUES('DAN04E','FVU',' ',0.00,0.00,'Fagelement, Dansk trin 4','Ingen',' ',' ',' ',0.00,NULL,0.0000,0.00,' ',' ',0.0000,'Fagelement, Dansk trin 4',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,' ',0,' ',0,22089,'-',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,' ',0,' ',0.00,NULL,'Nej'); END IF; COMMIT; update systemindstillinger set cprLogFilMappe = null; commit; update systemindstillinger set xprsDirectory = null; commit; IF EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'WebAmuTilmelding' AND cname = 'kundeOrdrenr') THEN ALTER TABLE WebAmuTilmelding MODIFY kundeOrdrenr VARCHAR(20); END IF; IF EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'WebHoldReservation' AND cname = 'kundeOrdrenr') THEN ALTER TABLE WebHoldReservation MODIFY kundeOrdrenr VARCHAR(20); END IF; IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'KarakterAendret' AND cname = 'webBrugerId') THEN ALTER TABLE KarakterAendret ADD webBrugerId CHAR(80); UPDATE KarakterAendret k SET k.webBrugerId = (Select max(w.brugerId) from WebBruger w where w.ludusBrugerId = k.brugerId and w.brugerType = 'ADMINISTRATION'); COMMIT; END IF; IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'KarakterAendret' AND cname = 'id') THEN ALTER TABLE KarakterAendret DROP PRIMARY KEY; DROP INDEX KarakterAendret.KarakterAendret1; ALTER TABLE KarakterAendret DROP FOREIGN KEY bruger; ALTER TABLE KarakterAendret MODIFY brugerId CHAR(20) NULL; ALTER TABLE KarakterAendret ADD id INTEGER NOT NULL DEFAULT AUTOINCREMENT; ALTER TABLE KarakterAendret ADD PRIMARY KEY ("id" ASC); CREATE UNIQUE INDEX "KarakterAendret1" ON "DBA"."KarakterAendret" ( "fagKode" ASC, "proeveform" ASC, "terminKode" ASC, "holdId" ASC, "holdStart" ASC, "personnummer" ASC, "brugerId" ASC, "webBrugerId" ASC, "aendretDato" ASC, "aendretKl" ASC ) IN "system"; ALTER TABLE KarakterAendret ADD FOREIGN KEY bruger(brugerId) REFERENCES Bruger(brugerId) ON UPDATE CASCADE; END IF; UPDATE EmailLog l SET l.tilKursistPersonnummer = NULL WHERE l.tilKursistPersonnummer IS NOT NULL AND NOT EXISTS(SELECT k.personnummer FROM Kursist k WHERE k.personnummer = l.tilKursistPersonnummer); commit; IF EXISTS(SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'EmailLog' AND cname = 'personnummer') THEN ALTER TABLE EmailLog DROP FOREIGN KEY tilKursist; ALTER TABLE EmailLog DROP personnummer; ALTER TABLE EmailLog ADD CONSTRAINT tilKursist FOREIGN KEY ( tilKursistPersonnummer ASC ) REFERENCES Kursist ( personnummer ) ON UPDATE CASCADE ON DELETE SET NULL; END IF; IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'Vaerge' AND cname = 'navneOgAdresseBeskyttelse') THEN ALTER TABLE Vaerge ADD navneOgAdresseBeskyttelse BIT DEFAULT 0; END IF; ;COMMIT;QUIT;