﻿IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND  COLUMN_NAME = 'Price')
begin
	alter table KalaProperty add	Price decimal(19,4) null
end;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND  COLUMN_NAME = 'Tarikh')
begin
	alter table KalaProperty add	Tarikh int null
end;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND  COLUMN_NAME = 'Percent')
begin
	alter table KalaProperty add	[Percent] float null
end;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table KalaProperty add	Mat_ID bigint references Matter(ID) null
end;
