-- Tables

-- Alters

ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [MenstruationPain] bit NULL
GO
UPDATE [AKUZ].[T_WOMENS_CONSULTATION] SET [MenstruationPain] = 0 WHERE [MenstruationPain] IS NULL
GO
ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [MenstruationPain] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [RegularMens] bit NULL
GO
UPDATE [AKUZ].[T_WOMENS_CONSULTATION] SET [RegularMens] = 0 WHERE [RegularMens] IS NULL
GO
ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [RegularMens] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [RepeatedPregnancy] bit NULL
GO
UPDATE [AKUZ].[T_WOMENS_CONSULTATION] SET [RepeatedPregnancy] = 0 WHERE [RepeatedPregnancy] IS NULL
GO
ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [RepeatedPregnancy] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [UpcomingChildBirth] bit NULL
GO
UPDATE [AKUZ].[T_WOMENS_CONSULTATION] SET [UpcomingChildBirth] = 0 WHERE [UpcomingChildBirth] IS NULL
GO
ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [UpcomingChildBirth] bit NOT NULL
GO

ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [MultiplePregnancy] bit NULL
GO
UPDATE [AKUZ].[T_WOMENS_CONSULTATION] SET [MultiplePregnancy] = 0 WHERE [MultiplePregnancy] IS NULL
GO
ALTER TABLE [AKUZ].[T_WOMENS_CONSULTATION] ALTER COLUMN [MultiplePregnancy] bit NOT NULL
GO

