IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND  COLUMN_NAME = 'Dom_ID_Status')
begin
	alter table OtherProperties add Dom_ID_Status int references domain (ID) null
end
go
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND  COLUMN_NAME = 'Taf_ID')
begin
	alter table OtherProperties add Taf_ID bigint references tafsili (ID) null
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND  COLUMN_NAME = 'vaziat')
begin
	alter table OtherProperties drop column vaziat
end
go
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND  COLUMN_NAME = 'Pro_ID_Parent')
begin
	alter table OtherProperties add Pro_ID_Parent	int references OtherProperties (ID) null
end
go
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND  COLUMN_NAME = 'Pro_ID_Unit')
begin
	alter table OtherProperties add Pro_ID_Unit	int references OtherProperties (ID) null
end
go
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND  COLUMN_NAME = 'Title')
begin
	alter table Tafsili add	Title	nvarchar(200)	
end