IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'TedadAfradTahtTakafol')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	TedadAfradTahtTakafol	smallint
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'TedadAfradGheirTahtTakafol')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	TedadAfradGheirTahtTakafol	smallint
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'TedadOlad')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	TedadOlad	smallint
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'ReshtehTahsili')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	ReshtehTahsili	nvarchar(50)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'ShomarehCardSaat')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	ShomarehCardSaat	nvarchar(50)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'Bank')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	Bank	nvarchar(30)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'ShobehBank')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	ShobehBank	nvarchar(30)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'ModdatSanavatEbtedayeDoreh')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	ModdatSanavatEbtedayeDoreh	nvarchar(50)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'ZakhirehBazKharidEbtedayehDoreh')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	ZakhirehBazKharidEbtedayehDoreh	nvarchar(50)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'NoeHesabBanki')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	NoeHesabBanki	smallint
end
go

IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'VaziatSarbazi')
begin
	print 'Ok'
end
else
begin
	alter table Tafsili
	add	VaziatSarbazi	smallint
end
go