-- T_ADDITIONAL_BARCODE_ATTRIBUTE
ALTER TABLE PHARM.T_ADDITIONAL_BARCODE_ATTRIBUTE ALTER COLUMN "lexem" SET DATA TYPE varchar(1500);
UPDATE PHARM.T_ADDITIONAL_BARCODE_ATTRIBUTE SET "lexem" = '' WHERE "lexem" IS NULL;
ALTER TABLE PHARM.T_ADDITIONAL_BARCODE_ATTRIBUTE ALTER COLUMN "lexem" SET NOT NULL;

-- T_BILL_OF_GOODS
ALTER TABLE PHARM.T_BILL_OF_GOODS ALTER COLUMN "productinfo" SET DATA TYPE varchar(512);
ALTER TABLE PHARM.T_BILL_OF_GOODS ALTER COLUMN "productinfo" DROP NOT NULL;

-- T_C_TRN
ALTER TABLE PHARM.T_C_TRN ALTER COLUMN "overdose" SET DATA TYPE varchar(512);
ALTER TABLE PHARM.T_C_TRN ALTER COLUMN "overdose" DROP NOT NULL;

