IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'FollowAction' AND COLUMN_NAME = 'Mat_ID') begin alter table dbo.FollowAction add Mat_ID bigint references dbo.matter(ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'FollowAction' AND COLUMN_NAME = 'Dom_ID_Type') begin alter table dbo.FollowAction add Dom_ID_Type int references dbo.domain(ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'FollowAction' AND COLUMN_NAME = 'SystemTitle') begin alter table dbo.FollowAction add SystemTitle nvarchar(max) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'FollowAction' AND COLUMN_NAME = 'Subject') begin alter table dbo.FollowAction add [Subject] nvarchar(300) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'FollowAction' AND COLUMN_NAME = 'Dom_ID_CallType') begin alter table dbo.FollowAction add Dom_ID_CallType int references dbo.domain(ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'FollowAction' AND COLUMN_NAME = 'Dom_ID_CallResultType') begin alter table dbo.FollowAction add Dom_ID_CallResultType int references dbo.domain(ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'FollowAction' AND COLUMN_NAME = 'Dom_ID_Status') begin alter table dbo.FollowAction add Dom_ID_Status int references dbo.domain(ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'FollowAction' AND COLUMN_NAME = 'Dom_ID_Priority') begin alter table dbo.FollowAction add Dom_ID_Priority int references dbo.domain(ID) null end