ALTER TABLE `bvur`.`coupons`
ADD COLUMN `description` TEXT ,
CHANGE COLUMN `code` `code` VARCHAR(12) NOT NULL ,
CHANGE COLUMN `is_active` `is_active` BIT(1) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `expiry_date` `expiry_date` DATETIME NOT NULL ,
CHANGE COLUMN `used_count` `used_count` INT DEFAULT 0 ,
CHANGE COLUMN `quantity` `quantity` INT DEFAULT 0 ,
CHANGE COLUMN `discount` `discount` INT DEFAULT 0 ,
CHANGE COLUMN `start_date` `start_date` DATETIME NOT NULL ,
CHANGE COLUMN `end_date` `end_date` DATETIME NOT NULL ,
CHANGE COLUMN `split` `split` BIT(1) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `published_for` `published_for` VARCHAR(255) NOT NULL ,
CHANGE COLUMN `published` `published` BIT(1) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `collab_discount` `collab_discount` INT DEFAULT 0 ,
CHANGE COLUMN `discount_type` `discount_type` VARCHAR(45) NOT NULL ;