ALTER TABLE AKUZ.T_VIMIS_CONSULTATION_PROTOCOL_CUSTOM ALTER COLUMN "inspectiondata" SET DATA TYPE text;
UPDATE AKUZ.T_VIMIS_CONSULTATION_PROTOCOL_CUSTOM SET "inspectiondata" = '' WHERE "inspectiondata" IS NULL;
ALTER TABLE AKUZ.T_VIMIS_CONSULTATION_PROTOCOL_CUSTOM ALTER COLUMN "inspectiondata" SET NOT NULL;

ALTER TABLE AKUZ.T_VIMIS_CONSULTATION_PROTOCOL_CUSTOM ALTER COLUMN "anamnesisdisease" SET DATA TYPE text;
UPDATE AKUZ.T_VIMIS_CONSULTATION_PROTOCOL_CUSTOM SET "anamnesisdisease" = '' WHERE "anamnesisdisease" IS NULL;
ALTER TABLE AKUZ.T_VIMIS_CONSULTATION_PROTOCOL_CUSTOM ALTER COLUMN "anamnesisdisease" SET NOT NULL;

