· 6 years ago · Aug 19, 2019, 04:58 AM
1DROP TABLE IF EXISTS `catalog_vouchers`;
2CREATE TABLE IF NOT EXISTS `catalog_vouchers` (
3 `voucher` varchar(45) NOT NULL,
4 `type` enum('credit','ducket','diamond','gotw','furni') NOT NULL,
5 `value` int(11) NOT NULL DEFAULT 100,
6 `current_uses` int(11) NOT NULL DEFAULT 0,
7 `max_uses` int(11) NOT NULL DEFAULT 1,
8 `enabled` enum('0','1') DEFAULT '1',
9 PRIMARY KEY (`voucher`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;