· 8 years ago · Jun 20, 2018, 02:16 AM
1CREATE TABLE IF NOT EXISTS `my_support` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `adder` varchar(32) DEFAULT NULL,
4 `title` varchar(32) DEFAULT NULL,
5 `addtime` bigint(11) DEFAULT NULL,
6 `text` text,
7 `status` int(1) DEFAULT '0',
8 `category` int(2) DEFAULT '0',
9 `last` varchar(32) DEFAULT NULL,
10 `lasttime` bigint(11) DEFAULT NULL,
11 `members` varchar(256) DEFAULT NULL,
12 `archive` int(1) NOT NULL DEFAULT '0',
13 PRIMARY KEY (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
15
16CREATE TABLE IF NOT EXISTS `my_support_answer` (
17 `id` int(11) NOT NULL AUTO_INCREMENT,
18 `adder` varchar(32) DEFAULT NULL,
19 `quest` bigint(11) DEFAULT NULL,
20 `text` text,
21 `addtime` bigint(11) DEFAULT NULL,
22 PRIMARY KEY (`id`)
23) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;