-- Tables

-- Alters

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "menstruationpain" SET DATA TYPE boolean;

UPDATE AKUZ.T_WOMENS_CONSULTATION SET "menstruationpain" = '0' WHERE "menstruationpain" IS NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "menstruationpain" SET NOT NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "regularmens" SET DATA TYPE boolean;

UPDATE AKUZ.T_WOMENS_CONSULTATION SET "regularmens" = '0' WHERE "regularmens" IS NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "regularmens" SET NOT NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "repeatedpregnancy" SET DATA TYPE boolean;

UPDATE AKUZ.T_WOMENS_CONSULTATION SET "repeatedpregnancy" = '0' WHERE "repeatedpregnancy" IS NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "repeatedpregnancy" SET NOT NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "upcomingchildbirth" SET DATA TYPE boolean;

UPDATE AKUZ.T_WOMENS_CONSULTATION SET "upcomingchildbirth" = '0' WHERE "upcomingchildbirth" IS NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "upcomingchildbirth" SET NOT NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "multiplepregnancy" SET DATA TYPE boolean;

UPDATE AKUZ.T_WOMENS_CONSULTATION SET "multiplepregnancy" = '0' WHERE "multiplepregnancy" IS NULL;

ALTER TABLE AKUZ.T_WOMENS_CONSULTATION ALTER COLUMN "multiplepregnancy" SET NOT NULL;

