IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ControlStructureDetail' AND  COLUMN_NAME = 'UT_ID')
begin
	alter table ControlStructureDetail Add UT_ID	int references UserTable(ID) null
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ControlStructureDetail' AND  COLUMN_NAME = 'ValueMember')
begin
	alter table ControlStructureDetail Add ValueMember	nvarchar(200)
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ControlStructureDetail' AND  COLUMN_NAME = 'DisplayMember')
begin
	alter table ControlStructureDetail Add DisplayMember	nvarchar(200)
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND  COLUMN_NAME = 'CS_ID')
begin
	alter table OtherProperties add CS_ID	int references ControlStructure(ID) null
end