﻿IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND  COLUMN_NAME = 'MaxFormCount')
begin
alter table Places add MaxFormCount	int null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND  COLUMN_NAME = 'Place_ID_Web')
begin
alter table Places add Place_ID_Web	int references Places(ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND  COLUMN_NAME = 'IconFont')
begin
alter table Places add IconFont	nvarchar(100) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND  COLUMN_NAME = 'IconColor')
begin
alter table Places add IconColor	nvarchar(100) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND  COLUMN_NAME = 'Url')
begin
alter table Places add Url	nvarchar(1000) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND  COLUMN_NAME = 'Dom_ID_IsActive_Web')
begin
alter table Places add Dom_ID_IsActive_Web	int references Domain(ID) null
end