IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'tradingAs'
      AND Object_ID = Object_ID(N'pal_Setup'))
BEGIN
    ALTER TABLE pal_Setup
	ADD tradingAs VARCHAR(350)
END


IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'postalProvinceState'
      AND Object_ID = Object_ID(N'pal_Setup'))
BEGIN
    ALTER TABLE pal_Setup
	ADD postalProvinceState VARCHAR(100)
END


IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'postalCountry'
      AND Object_ID = Object_ID(N'pal_Setup'))
BEGIN
    ALTER TABLE pal_Setup
	ADD postalCountry VARCHAR(100)
END



IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'physicalProvinceState'
      AND Object_ID = Object_ID(N'pal_Setup'))
BEGIN
    ALTER TABLE pal_Setup
	ADD physicalProvinceState VARCHAR(100)
END


IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'physicalCountry'
      AND Object_ID = Object_ID(N'pal_Setup'))
BEGIN
    ALTER TABLE pal_Setup
	ADD physicalCountry VARCHAR(100)
END