-- Tables

-- Alters

ALTER TABLE PHARM.T_MEDICAMENT_PRODUCER ALTER COLUMN "name" SET DATA TYPE varchar(1000);

UPDATE PHARM.T_MEDICAMENT_PRODUCER SET "name" = '' WHERE "name" IS NULL;

ALTER TABLE PHARM.T_MEDICAMENT_PRODUCER ALTER COLUMN "name" SET NOT NULL;

