-- Tables

-- Alters

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION DROP COLUMN "firstname";

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION DROP COLUMN "fathername";

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION DROP COLUMN "lastname";

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION ADD "fio" varchar(255) NULL;

ALTER TABLE AKUZ.T_OBSTETRIC_HOSPITAL_STAGE ADD "fullyears" integer NULL;

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION ADD "gynecologist" bytea NULL;

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION ADD "wasresusccitation" boolean NULL;

UPDATE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION SET "wasresusccitation" = '0';

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION ALTER COLUMN "wasresusccitation" SET NOT NULL;

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION ADD "neonatologist" bytea NULL;

ALTER TABLE AKUZ.T_OBSTETRIC_NEWBORN_INFORMATION ADD "motherconditionatdischarging" varchar(255) NULL;


