CREATE TABLE IF NOT EXISTS `coupons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accountId` int(11) NOT NULL,
`code` varchar(12) NOT NULL,
`amount` int(4) NOT NULL,
`used` tinyint(1) NOT NULL DEFAULT '0',
`createDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`redeemDate` timestamp NULL,
PRIMARY KEY (`id`),
CONSTRAINT `fk_coupons_account` FOREIGN KEY (`accountId`) REFERENCES `accounts`(`id`) ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE `accounts` 
ADD COLUMN `lastRedeem` TIMESTAMP NULL AFTER lastlogin;

ALTER TABLE `accounts` 
ADD COLUMN `streak` int(3) NOT NULL DEFAULT '0' AFTER lastRedeem;