﻿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