--ALTER table BRUGER
--ADD COLUMN TOKEN char(50);

ALTER table BRUGER
ALTER COLUMN BRUGER_ID BRUGER_ID double constraint NOT NULL;

ALTER table BRUGERSTED
ALTER COLUMN BRUGER_ID BRUGER_ID double constraint NOT NULL;

ALTER table BRUGERADGANG
ALTER COLUMN BRUGER_ID BRUGER_ID double constraint NOT NULL
ALTER COLUMN FIRMA_ID FIRMA_ID double constraint NOT NULL
ALTER COLUMN REGION_ID REGION_ID double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE_ID DRIFTOMRODE_ID double constraint NOT NULL
ALTER COLUMN AFDELING_ID AFDELING_ID double constraint NOT NULL;

ALTER table FIRMA
ALTER COLUMN FIRMA_ID FIRMA_ID double constraint NOT NULL;

ALTER table REGION
ALTER COLUMN FIRMA_ID FIRMA_ID double constraint NOT NULL
ALTER COLUMN REGION_ID REGION_ID double constraint NOT NULL;

ALTER table DRIFTOMRODE
ALTER COLUMN FIRMA_ID FIRMA_ID double constraint NOT NULL
ALTER COLUMN REGION_ID REGION_ID double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE_ID DRIFTOMRODE_ID double constraint NOT NULL;

ALTER table FASTVAGT
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN VAGT_ID VAGT_ID double constraint NOT NULL
ALTER COLUMN VAGT VAGT Char(10) constraint NOT NULL;

ALTER table VAGT
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN DATO DATO timestamp constraint NOT NULL
ALTER COLUMN PERSONREGION PERSONREGION double constraint NOT NULL
ALTER COLUMN PERSONDRIFTOMRODE PERSONDRIFTOMRODE double constraint NOT NULL
ALTER COLUMN PERSONNUMMER PERSONNUMMER double constraint NOT NULL;

ALTER table VAGTER
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN PLANPERIODE PLANPERIODE double constraint NOT NULL
ALTER COLUMN VAGT VAGT Char(10) constraint NOT NULL;

ALTER table BESKRIVELSER
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN PLANPERIODE PLANPERIODE double constraint NOT NULL
ALTER COLUMN VAGT VAGT Char(10) constraint NOT NULL
ALTER COLUMN LBNR LBNR integer constraint NOT NULL;

ALTER table PLANPERIODE
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN PLANPERIODE PLANPERIODE double constraint NOT NULL;

ALTER table PERSON
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN NUMMER NUMMER double constraint NOT NULL;

ALTER table REJSEKORT
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN NUMMER NUMMER double constraint NOT NULL
ALTER COLUMN DATO DATO date constraint NOT NULL
ALTER COLUMN TID TID time constraint NOT NULL
ALTER COLUMN POSTTYPE POSTTYPE integer constraint NOT NULL;

ALTER table PERSONCERTIFIKATER
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN PERSON PERSON double constraint NOT NULL
ALTER COLUMN CID CID double constraint NOT NULL;

ALTER table CERTIFIKATER
ALTER COLUMN LBNR LBNR double constraint NOT NULL;

ALTER table CERTIFIKATFORNYELSE
ALTER COLUMN LBNR LBNR double constraint NOT NULL
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL;

ALTER table PERSONCERTIFIKATER
ALTER COLUMN FIRMA FIRMA double constraint NOT NULL
ALTER COLUMN REGION REGION double constraint NOT NULL
ALTER COLUMN DRIFTOMRODE DRIFTOMRODE double constraint NOT NULL
ALTER COLUMN PERSON PERSON double constraint NOT NULL
ALTER COLUMN CID CID double constraint NOT NULL;