-- Tables

-- Alters

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

