-- Tables

-- Alters

ALTER TABLE [AKUZ].[T_OBSTETRIC_NEWBORN_INFORMATION] DROP COLUMN [FirstName]
GO

ALTER TABLE [AKUZ].[T_OBSTETRIC_NEWBORN_INFORMATION] DROP COLUMN [FatherName]
GO

ALTER TABLE [AKUZ].[T_OBSTETRIC_NEWBORN_INFORMATION] DROP COLUMN [LastName]
GO

ALTER TABLE [AKUZ].[T_OBSTETRIC_NEWBORN_INFORMATION] ADD [FIO] varchar(255) NULL
GO

ALTER TABLE [AKUZ].[T_OBSTETRIC_HOSPITAL_STAGE] ADD [FullYears] int NULL
GO

ALTER TABLE [AKUZ].[T_OBSTETRIC_NEWBORN_INFORMATION] ADD [Gynecologist] varbinary(max) NULL
GO

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

ALTER TABLE [AKUZ].[T_OBSTETRIC_NEWBORN_INFORMATION] ADD [Neonatologist] varbinary(max) NULL
GO

ALTER TABLE [AKUZ].[T_OBSTETRIC_NEWBORN_INFORMATION] ADD [MotherConditionAtDischarging] varchar(255) NULL
GO