﻿IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'matter' AND  COLUMN_NAME = 'Description')
begin
	alter table matter add  Description nvarchar(max) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table OtherProperties add  Mat_ID bigint references Matter(ID) null
end