IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Contract' AND  COLUMN_NAME = 'Tarikh')
begin
	alter table Contract add Tarikh	int not null default 0
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ContractHistory' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table ContractHistory add Mat_ID	bigint references matter(ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ContractHistory' AND  COLUMN_NAME = 'FC_ID')
begin
	alter table ContractHistory add FC_ID	int references finance_Cycle(ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ContractHistory' AND  COLUMN_NAME = 'Pro_ID_VahedMali')
begin
	alter table ContractHistory add Pro_ID_VahedMali	int references otherProperties(ID) null
end