if not exists (select * from sys.syscolumns where name = 'IsArchived' AND id = object_id(N'dbo.LogMessage'))
    alter table dbo.LogMessage
    add IsArchived bit not null constraint DF_LogMessage_IsArchived DEFAULT(0)