-- Tables

-- Alters

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

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

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

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

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

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

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

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

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

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

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

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

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

