alter table cf_users add column user_timezone varchar(100) DEFAULT NULL;
alter table cf_users add column utc_offset varchar(10) DEFAULT NULL;
alter table coupons_master add column country_id int(11) NULL after code;
alter table dl_advertisers add column balance_left_dollar double(14,4) DEFAULT 0.0;
CREATE TABLE `coupons_funds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL,
  `advertiser_id` int(11) NOT NULL DEFAULT 0,
  `amount_dollar` DOUBLE(16,4) NOT NULL,
  `amount_used`  DOUBLE(16,4) NOT NULL DEFAULT 0.0,
  `apply_status` enum('EXPIRED','AVAILABLE') NOT NULL DEFAULT 'AVAILABLE',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;
alter table coupons_funds add column valid_date DATE NULL;
alter table coupons_funds add column valid_dow varchar(3) NULL;
drop table coupons_funds;
alter table coupons_history add column advertiser_id int (11) NOT NULL after coupon_id;
alter table coupons_history add column amount_dollar double(16,4) NOT NULL;
alter table coupons_history add column amount_used double(16,4) NOT NULL;

alter table coupons_history add column valid_date date NULL;
alter table coupons_history add column valid_dow varchar(3) NULL;
alter table coupons_history add column used_status  enum('EXPIRED','AVAILABLE')  DEFAULT 'AVAILABLE';

