﻿IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TaskPermission' AND  COLUMN_NAME = 'Tas_ID_Process')
begin
	alter table dbo.TaskPermission add Tas_ID_Process	int references dbo.Task(ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TaskDependency' AND  COLUMN_NAME = 'TaskTitleFrom')
begin
	alter table dbo.TaskDependency	add TaskTitleFrom	nvarchar(200) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TaskDependency' AND  COLUMN_NAME = 'TaskTitleTo')
begin
	alter table dbo.TaskDependency	add TaskTitleTo	nvarchar(200) null
end