-- Tables

-- Alters

ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT2] ADD [Amiotrophy] bit NULL
GO
UPDATE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT2] SET [Amiotrophy] = 0
GO
ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT2] ALTER COLUMN [Amiotrophy] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] DROP COLUMN [HivInfection]
GO


ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] ADD [HivInfectionWithout] bit NULL
GO
UPDATE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] SET [HivInfectionWithout] = 0
GO
ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] ALTER COLUMN [HivInfectionWithout] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] ADD [HivInfectionViralLoad] bit NULL
GO
UPDATE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] SET [HivInfectionViralLoad] = 0
GO
ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] ALTER COLUMN [HivInfectionViralLoad] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] ADD [HepatitBWithout] bit NULL
GO
UPDATE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] SET [HepatitBWithout] = 0
GO
ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] ALTER COLUMN [HepatitBWithout] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] ADD [HepatitBViremia] bit NULL
GO
UPDATE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] SET [HepatitBViremia] = 0
GO
ALTER TABLE [AKUZ].[T_EXTRAGENITAL_DISEASE_PT5] ALTER COLUMN [HepatitBViremia] bit NOT NULL
GO


ALTER TABLE [AKUZ].[T_PREGNANT_COMPLICATIONS_PT3] ADD [ThreatPrLate] bit NULL
GO
UPDATE [AKUZ].[T_PREGNANT_COMPLICATIONS_PT3] SET [ThreatPrLate] = 0
GO
ALTER TABLE [AKUZ].[T_PREGNANT_COMPLICATIONS_PT3] ALTER COLUMN [ThreatPrLate] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_PREGNANT_COMPLICATIONS_PT3] ADD [PrpEarly] bit NULL
GO
UPDATE [AKUZ].[T_PREGNANT_COMPLICATIONS_PT3] SET [PrpEarly] = 0
GO
ALTER TABLE [AKUZ].[T_PREGNANT_COMPLICATIONS_PT3] ALTER COLUMN [PrpEarly] bit NOT NULL
GO


ALTER TABLE [AKUZ].[T_FETUS_COMPLICATIONS] ADD [HydropsFetalis] bit NULL
GO
UPDATE [AKUZ].[T_FETUS_COMPLICATIONS] SET [HydropsFetalis] = 0
GO
ALTER TABLE [AKUZ].[T_FETUS_COMPLICATIONS] ALTER COLUMN [HydropsFetalis] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_FETUS_COMPLICATIONS] ADD [TwinsDissociating] bit NULL
GO
UPDATE [AKUZ].[T_FETUS_COMPLICATIONS] SET [TwinsDissociating] = 0
GO
ALTER TABLE [AKUZ].[T_FETUS_COMPLICATIONS] ALTER COLUMN [TwinsDissociating] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_FETUS_COMPLICATIONS] ADD [FetalInterventionsCondition] bit NULL
GO
UPDATE [AKUZ].[T_FETUS_COMPLICATIONS] SET [FetalInterventionsCondition] = 0
GO
ALTER TABLE [AKUZ].[T_FETUS_COMPLICATIONS] ALTER COLUMN [FetalInterventionsCondition] bit NOT NULL
GO



ALTER TABLE [AKUZ].[T_PREVIOUS_PREGNANICES_NEWBORN_INFORMATION] ALTER COLUMN [Height] int NULL
GO


ALTER TABLE [AKUZ].[T_PREGNANT_DISPANSERISATION] ADD [NoBreastExamination] bit NULL
GO
UPDATE [AKUZ].[T_PREGNANT_DISPANSERISATION] SET [NoBreastExamination] = 0
GO
ALTER TABLE [AKUZ].[T_PREGNANT_DISPANSERISATION] ALTER COLUMN [NoBreastExamination] bit NOT NULL
GO



ALTER TABLE [AKUZ].[T_PREVIOUS_PREGNANCIES_INFORMATION] ADD [UnspecifiedComplications] varchar(255) NULL
GO

