-- Tables

-- Alters

ALTER TABLE AKUZ.T_MEDICAL_EXAMINATION_DATA ALTER COLUMN "diagnosis" SET DATA TYPE varchar(4096);

UPDATE AKUZ.T_MEDICAL_EXAMINATION_DATA SET "diagnosis" = '' WHERE "diagnosis" IS NULL;

ALTER TABLE AKUZ.T_MEDICAL_EXAMINATION_DATA ALTER COLUMN "diagnosis" SET NOT NULL;


ALTER TABLE AKUZ.T_MEDICAL_EXAMINATION_DATA ALTER COLUMN "visitpurpose" DROP NOT NULL;
