﻿IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND  COLUMN_NAME = 'Pro_ID_Size')
begin
	alter table dbo.BargehDetail add Pro_ID_Size int references dbo.OtherProperties (ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND  COLUMN_NAME = 'Pro_ID_Color')
begin
	alter table dbo.BargehDetail add Pro_ID_Color int references dbo.OtherProperties (ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND  COLUMN_NAME = 'Pro_ID_Size')
begin
	alter table dbo.KalaDarAnbar add Pro_ID_Size int references dbo.OtherProperties (ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND  COLUMN_NAME = 'Pro_ID_Color')
begin
	alter table dbo.KalaDarAnbar add Pro_ID_Color int references dbo.OtherProperties (ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ConvertGoodDetail' AND  COLUMN_NAME = 'Pro_ID_Size')
begin
	alter table dbo.ConvertGoodDetail add Pro_ID_Size int references dbo.OtherProperties (ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ConvertGoodDetail' AND  COLUMN_NAME = 'Pro_ID_Color')
begin
	alter table dbo.ConvertGoodDetail add Pro_ID_Color int references dbo.OtherProperties (ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND  COLUMN_NAME = 'Pro_ID_Size')
begin
	alter table dbo.ProductDetail add Pro_ID_Size int references dbo.OtherProperties (ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND  COLUMN_NAME = 'Pro_ID_Color')
begin
	alter table dbo.ProductDetail add Pro_ID_Color int references dbo.OtherProperties (ID) null
end