-- Tables

-- Alters


ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT2 ADD "amiotrophy" boolean NULL;

UPDATE AKUZ.T_EXTRAGENITAL_DISEASE_PT2 SET "amiotrophy" = '0';

ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT2 ALTER COLUMN "amiotrophy" SET NOT NULL;



ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 DROP COLUMN "hivinfection";


ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 ADD "hivinfectionwithout" boolean NULL;

UPDATE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 SET "hivinfectionwithout" = '0';

ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 ALTER COLUMN "hivinfectionwithout" SET NOT NULL;

ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 ADD "hivinfectionviralload" boolean NULL;

UPDATE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 SET "hivinfectionviralload" = '0';

ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 ALTER COLUMN "hivinfectionviralload" SET NOT NULL;

ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 ADD "hepatitbwithout" boolean NULL;

UPDATE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 SET "hepatitbwithout" = '0';

ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 ALTER COLUMN "hepatitbwithout" SET NOT NULL;

ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 ADD "hepatitbviremia" boolean NULL;

UPDATE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 SET "hepatitbviremia" = '0';

ALTER TABLE AKUZ.T_EXTRAGENITAL_DISEASE_PT5 ALTER COLUMN "hepatitbviremia" SET NOT NULL;


ALTER TABLE AKUZ.T_FETUS_COMPLICATIONS ADD "hydropsfetalis" boolean NULL;

UPDATE AKUZ.T_FETUS_COMPLICATIONS SET "hydropsfetalis" = '0';

ALTER TABLE AKUZ.T_FETUS_COMPLICATIONS ALTER COLUMN "hydropsfetalis" SET NOT NULL;

ALTER TABLE AKUZ.T_FETUS_COMPLICATIONS ADD "twinsdissociating" boolean NULL;

UPDATE AKUZ.T_FETUS_COMPLICATIONS SET "twinsdissociating" = '0';

ALTER TABLE AKUZ.T_FETUS_COMPLICATIONS ALTER COLUMN "twinsdissociating" SET NOT NULL;

ALTER TABLE AKUZ.T_FETUS_COMPLICATIONS ADD "fetalinterventionscondition" boolean NULL;

UPDATE AKUZ.T_FETUS_COMPLICATIONS SET "fetalinterventionscondition" = '0';

ALTER TABLE AKUZ.T_FETUS_COMPLICATIONS ALTER COLUMN "fetalinterventionscondition" SET NOT NULL;


ALTER TABLE AKUZ.T_PREGNANT_COMPLICATIONS_PT3 ADD "threatprlate" boolean NULL;

UPDATE AKUZ.T_PREGNANT_COMPLICATIONS_PT3 SET "threatprlate" = '0';

ALTER TABLE AKUZ.T_PREGNANT_COMPLICATIONS_PT3 ALTER COLUMN "threatprlate" SET NOT NULL;

ALTER TABLE AKUZ.T_PREGNANT_COMPLICATIONS_PT3 ADD "prpearly" boolean NULL;

UPDATE AKUZ.T_PREGNANT_COMPLICATIONS_PT3 SET "prpearly" = '0';

ALTER TABLE AKUZ.T_PREGNANT_COMPLICATIONS_PT3 ALTER COLUMN "prpearly" SET NOT NULL;



ALTER TABLE AKUZ.T_PREVIOUS_PREGNANICES_NEWBORN_INFORMATION ALTER COLUMN "height" SET DATA TYPE integer;

ALTER TABLE AKUZ.T_PREVIOUS_PREGNANICES_NEWBORN_INFORMATION ALTER COLUMN "height" DROP NOT NULL;


ALTER TABLE AKUZ.T_PREGNANT_DISPANSERISATION ADD "nobreastexamination" boolean NULL;

UPDATE AKUZ.T_PREGNANT_DISPANSERISATION SET "nobreastexamination" = '0';

ALTER TABLE AKUZ.T_PREGNANT_DISPANSERISATION ALTER COLUMN "nobreastexamination" SET NOT NULL;



ALTER TABLE AKUZ.T_PREVIOUS_PREGNANCIES_INFORMATION ADD "unspecifiedcomplications" varchar(255) NULL;