
IF NOT EXISTS (SELECT * FROM sys.columns where object_id = OBJECT_ID(N'[AKUZ].[T_NOTIFICATION_ABOUT_HOSPITAL]') and name = 'IsReceivedAgain')
ALTER TABLE [AKUZ].[T_NOTIFICATION_ABOUT_HOSPITAL] ADD [IsReceivedAgain] bit NULL
GO

UPDATE [AKUZ].[T_NOTIFICATION_ABOUT_HOSPITAL] SET [IsReceivedAgain] = 0
WHERE IsReceivedAgain IS NULL

ALTER TABLE [AKUZ].[T_NOTIFICATION_ABOUT_HOSPITAL] ALTER COLUMN [IsReceivedAgain] bit NOT NULL
