· 8 years ago · Dec 01, 2017, 01:10 AM
1CREATE TABLE IF NOT EXISTS `articles` (
2`id` int(10) unsigned NOT NULL,
3 `info_hash` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
4 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 `save_as` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 `search_text` text COLLATE utf8_unicode_ci NOT NULL,
7 `ori_descr` text COLLATE utf8_unicode_ci NOT NULL,
8 `category` int(10) unsigned NOT NULL DEFAULT '0',
9 `added` int(11) NOT NULL,
10 `views` int(10) unsigned NOT NULL DEFAULT '0',
11 `hits` int(10) unsigned NOT NULL DEFAULT '0',
12 `last_action` int(11) NOT NULL,
13 `visible` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
14 `owner` int(10) unsigned NOT NULL DEFAULT '0',
15 `sticky` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
16 `anonymous` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
17 `allowid` text COLLATE utf8_unicode_ci NOT NULL
18) ENGINE=MyISAM AUTO_INCREMENT=1364 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
19
20--
21-- Dumping data for table `articles`
22--
23
24INSERT INTO `articles` (`id`, `info_hash`, `name`, `save_as`, `search_text`, `ori_descr`, `category`, `added`, `views`, `hits`, `last_action`, `visible`, `owner`, `sticky`, `anonymous`, `allowid`) VALUES
25(1363, '00456ba9fb928d71042ffca5388f33a7e20761ba', 'Test', 'Test', 'Test', 'Test article', 45, 1512066306, 3, 5, 1512066368, 'no', 1, 'no', 'no', '841,840');