
IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'dateCreated'
      AND Object_ID = Object_ID(N'pal_LoyaltyMember'))
BEGIN
    ALTER TABLE pal_LoyaltyMember
	ADD dateCreated DATETIME; 
END

IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'dateUpdated'
      AND Object_ID = Object_ID(N'pal_LoyaltyMember'))
BEGIN
    ALTER TABLE pal_LoyaltyMember
	ADD dateUpdated DATETIME; 
END


