q8JXQgBG

1CREATE TABLE IF NOT EXISTS `promocode` (
2  `code` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
3  `money` int(11) NOT NULL,
4  `days` int(11) NOT NULL,
5  `players` int(11) NOT NULL,
6  `data` int(11) NOT NULL,
7  `used_count` int(11) NOT NULL
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10CREATE TABLE IF NOT EXISTS `promocode_used` (
11  `id` int(5) NOT NULL AUTO_INCREMENT,
12  `idacca` varchar(30) COLLATE cp1251_bin DEFAULT NULL,
13  `code` varchar(32) CHARACTER SET cp1251 COLLATE cp1251_general_cs DEFAULT NULL,
14  PRIMARY KEY (`id`),
15  UNIQUE KEY `id` (`id`)
16) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin ROW_FORMAT=FIXED AUTO_INCREMENT=1 ;