ALTER TABLE `reward_earning_policy` ADD `earning_tier_id` INT NOT NULL AFTER `activation_duration`;
ALTER TABLE `default_spending_tier` ADD `spending_tier_id` INT NOT NULL AFTER `enabled`;



ALTER TABLE `reward_earning_policy` DROP `earning_tier_id`;"
ALTER TABLE `reward_earnings` ADD `earning_tier_id` INT NOT NULL AFTER `expiration_id`;
CREATE TABLE `reward_spending_policy` 
ALTER TABLE `reward_spending` ADD `spending_tier_id` INT NOT NULL AFTER `value`;
ALTER TABLE `customer_wallet` CHANGE `type` `type` INT(11) NOT NULL COMMENT 'If the wallet was created from a reward card account then this value refers to the reward card type otherwise online/offline';