USE `registration`;
CREATE TABLE `coupons` (
  `coupon_code` varchar(24) NOT NULL DEFAULT '',
  `coupon_type` varchar(16) NOT NULL DEFAULT '',
  `recipient_email` varchar(256) DEFAULT NULL,
  `date_issued` timestamp NULL DEFAULT NULL,
  `date_expire` date DEFAULT NULL,
  `order_id` varchar(50) DEFAULT NULL,
  `coupon_description` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`coupon_code`),
  UNIQUE KEY `coupon_code` (`coupon_code`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--  Changes for purging clear text email addresses (17 February 2022)

ALTER TABLE `registration`.`coupons`
  DROP COLUMN `recipient_email`;