IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'bargehDetail' AND  COLUMN_NAME = 'CodeArzeshAfzoodeh')
begin
	print 'Ok'
end
else
begin
	alter table bargehDetail
	add	CodeArzeshAfzoodeh		bigint foreign key references tafsili(code)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'bargehDetail' AND  COLUMN_NAME = 'DarsadeArzeshAfzoodeh')
begin
	print 'Ok'
end
else
begin
	alter table bargehDetail
	add	DarsadeArzeshAfzoodeh		float default 0
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'bargehDetail' AND  COLUMN_NAME = 'MablaghArzeshAfzoodeh')
begin
	print 'Ok'
end
else
begin
	alter table bargehDetail
	add	MablaghArzeshAfzoodeh		decimal(19,4) default 0
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'bargehDetail' AND  COLUMN_NAME = 'CodeFarayandArzeshAfzoodeh')
begin
	print 'Ok'
end
else
begin
	alter table bargehDetail
	add	CodeFarayandArzeshAfzoodeh	int foreign key references farayand(code)
end