drop table if exists AKUZ.T_SUM_PRESCRIBDRUG_SPECINSTRUCTION; 

ALTER TABLE AKUZ.T_SUM_SECTIONS_SPECINSTRUCTION ADD "sumprescribdruginstruction" uuid NULL;

ALTER TABLE AKUZ.T_SUM_SECTIONS_SPECINSTRUCTION ADD "specinstruction" varchar(4096) NULL;
UPDATE AKUZ.T_SUM_SECTIONS_SPECINSTRUCTION SET "specinstruction" = '';
ALTER TABLE AKUZ.T_SUM_SECTIONS_SPECINSTRUCTION ALTER COLUMN "specinstruction" SET NOT NULL;

ALTER TABLE AKUZ.T_SUM_SECTIONS_SPECINSTRUCTION ADD CONSTRAINT FK_T_SUM_PRESCRIBDRUG_INSTRUCTION_T_SUM_SECTIONS_SPECI_66D9119D
FOREIGN KEY("sumprescribdruginstruction") REFERENCES AKUZ.T_SUM_PRESCRIBDRUG_INSTRUCTION (SumPrescribdrugInstructionID);

