-- create table bf_grting_cards
CREATE TABLE `bf_grting_cards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merchant_id` int(11) NOT NULL,
  `purpose` VARCHAR(255) NOT NULL,
  `title` VARCHAR(1024) NOT NULL,
  `status` enum('a','i') NOT NULL DEFAULT 'a',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- add label column to bf_coupon_config table
alter table bf_coupon_config add column label VARCHAR(255) NOT NULL after merchant_id;

-- add sch_day_type and sch_day columns to bf_coupon_config table
alter table bf_coupon_config add column sch_day_type enum('d','w','m') DEFAULT NULL after event_date, add column sch_day int(11) DEFAULT NULL after sch_day_type;

-- add store_eng_features column to bf_merchantinfo table
alter table bf_merchantinfo add column store_eng_features text default null after cust_profile, add column cust_profile_verification enum('y', 'n') default 'n' after store_eng_features;

-- add desc column to bf_grting_cards table
alter table bf_grting_cards add column `desc` text default null after title, add column whatsapp_query varchar(255) default null after title;