g21qYcGX

1CREATE TABLE IF NOT EXISTS `items` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `log_id` int(11) NOT NULL,
4  `res_id` int(11) NOT NULL,
5  `link` varchar(255) NOT NULL,
6  `title` text NOT NULL,
7  `content` text NOT NULL,
8  `n_date` varchar(255) NOT NULL,
9  `nd_date` int(11) NOT NULL,
10  `s_date` int(11) NOT NULL,
11  `not_date` date NOT NULL,
12  PRIMARY KEY (`id`),
13  UNIQUE KEY `link_2` (`link`),
14  KEY `not_date` (`not_date`,`res_id`,`id`),
15  KEY `nd_date` (`nd_date`,`res_id`,`id`)
16) ENGINE=Aria  DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 AUTO_INCREMENT=33580675 ;