﻿IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DaryaftPardakht' AND  COLUMN_NAME = 'Taf_ID')
begin
	alter table dbo.DaryaftPardakht	add	Taf_ID	bigint	references dbo.Tafsili(ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND  COLUMN_NAME = 'Taf_ID_Bank')
begin
	alter table dbo.Bargeh	add	Taf_ID_Bank	bigint	references dbo.Tafsili(ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND  COLUMN_NAME = 'MablaghBank')
begin
	alter table dbo.Bargeh	add	MablaghBank	decimal(19,4) null
end