**************************************************************************************
* Bemærk at denne fil kun er til orientering om databaseændringer til denne release. *
* Filen MÅ IKKE afvikles!                                                            *
**************************************************************************************

DROP TABLE IF EXISTS EPEksamenPlanOpdateringLog
CREATE TABLE EPEksamenPlanOpdateringLog(
    planNavn CHAR(80) NOT NULL, 
    institutionKode CHAR(10) NOT NULL,
    medarbejderInitialer CHAR(5) NOT NULL,
    oprettelsesDato TIMESTAMP NOT NULL,
    CONSTRAINT epEksamenPlan FOREIGN KEY(planNavn, institutionKode) 
        REFERENCES EPEksamenPlan(planNavn, institutionKode)
        on update cascade on delete cascade, 
PRIMARY KEY (planNavn, institutionKode));

DROP TABLE IF EXISTS EPEksamenPlanOpdateringLogEksaminator
CREATE TABLE EPEksamenPlanOpdateringLogEksaminator(
    planNavn CHAR(80) NOT NULL, 
    institutionKode CHAR(10) NOT NULL,
    logType CHAR(20) NOT NULL,
    initialer CHAR(5) NOT NULL,
    holdId CHAR(8) NOT NULL,
    holdStart CHAR(8) NOT NULL,
    fagKode CHAR(8) NOT NULL,
    terminKode CHAR(10) NOT NULL,
    CONSTRAINT epEksamensLog FOREIGN KEY(planNavn, institutionKode) 
        REFERENCES EPEksamenPlanOpdateringLog(planNavn, institutionKode)
        on update cascade on delete cascade, 
PRIMARY KEY (planNavn, institutionKode, initialer, holdId, holdStart, fagKode, terminKode));

DROP TABLE IF EXISTS EPEksamenPlanOpdateringLogTilmelding
CREATE TABLE EPEksamenPlanOpdateringLogTilmelding(
    planNavn CHAR(80) NOT NULL, 
    institutionKode CHAR(10) NOT NULL,
    logType CHAR(20) NOT NULL,
    kursistNummer INTEGER NOT NULL,
    holdId CHAR(8) NOT NULL,
    holdStart CHAR(8) NOT NULL,
    fagKode CHAR(8) NOT NULL,
    terminKode CHAR(10) NOT NULL,
    CONSTRAINT epEksamensLog FOREIGN KEY(planNavn, institutionKode)  
        REFERENCES EPEksamenPlanOpdateringLog(planNavn, institutionKode)
        on update cascade on delete cascade, 
PRIMARY KEY (planNavn, institutionKode, kursistNummer, holdId, holdStart, fagKode, terminKode));

DROP TABLE IF EXISTS EPEksamenPlanOpdateringLogModul
CREATE TABLE EPEksamenPlanOpdateringLogModul(
    planNavn CHAR(80) NOT NULL, 
    institutionKode CHAR(10) NOT NULL,
    logType CHAR(20) NOT NULL,
    holdId CHAR(8) NOT NULL,
    holdStart CHAR(8) NOT NULL,
    fagKode CHAR(8) NOT NULL,
    terminKode CHAR(10) NOT NULL,
    CONSTRAINT epEksamensLog FOREIGN KEY(planNavn, institutionKode) 
        REFERENCES EPEksamenPlanOpdateringLog(planNavn, institutionKode)
        on update cascade on delete cascade, 
PRIMARY KEY (planNavn, institutionKode, holdId, holdStart, fagKode, terminKode));

IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'EksternForberedelseTraekning' AND cname = 'anvendes') THEN
ALTER TABLE EksternForberedelseTraekning ADD anvendes bit default 1;
END IF;
IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'EksamenModul' AND cname = 'planlagt') THEN
ALTER TABLE EksamenModul ADD planlagt bit default 0;
END IF;

IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'EPEksamenModul' AND cname = 'betegnelse') THEN
    ALTER TABLE EPEksamenModul ADD betegnelse CHAR(80);
END IF;

IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'EPEksamenPlan' AND cname = 'udgaaet') THEN
    ALTER TABLE EPEksamenPlan ADD udgaaet BIT DEFAULT 0;
END IF;

COMMIT;QUIT;