· 7 years ago · Nov 27, 2018, 03:42 PM
1CREATE TABLE IF NOT EXISTS `sunlight-posts` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `type` tinyint(4) NOT NULL,
4 `home` int(11) NOT NULL,
5 `xhome` int(11) NOT NULL,
6 `subject` varchar(48) NOT NULL,
7 `text` text NOT NULL,
8 `author` int(11) NOT NULL,
9 `guest` varchar(24) NOT NULL,
10 `time` int(11) NOT NULL,
11 `ip` varchar(15) NOT NULL,
12 `locked` tinyint(1) NOT NULL DEFAULT \'0\',
13 `bumptime` int(11) NOT NULL DEFAULT \'0\',
14 `sticky` tinyint(1) NOT NULL DEFAULT \'0\',
15 `flag` int(10) unsigned NOT NULL DEFAULT \'0\',
16 PRIMARY KEY (`id`),
17 KEY `bumptime` (`bumptime`),
18 KEY `type` (`type`),
19 KEY `home` (`home`),
20 KEY `xhome` (`xhome`),
21 KEY `author` (`author`),
22 KEY `time` (`time`),
23 KEY `sticky` (`sticky`),
24 KEY `flag` (`flag`)
25) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1