--add grid options
IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'allowExport'
      AND Object_ID = Object_ID(N'pal_SurfaceGridOptions'))
BEGIN
    ALTER TABLE pal_SurfaceGridOptions
	ADD allowExport BIT; 
END
IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'allowColVis'
      AND Object_ID = Object_ID(N'pal_SurfaceGridOptions'))
BEGIN
    ALTER TABLE pal_SurfaceGridOptions
	ADD allowColVis BIT; 
END