· 8 years ago · Aug 15, 2018, 09:22 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.4.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jul 30, 2013 at 09:45 PM
7-- Server version: 5.6.10
8-- PHP Version: 5.3.15
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18-- --------------------------------------------------------
19
20--
21-- Table structure for table `antispam`
22--
23
24CREATE TABLE IF NOT EXISTS `antispam` (
25 `board` varchar(58) CHARACTER SET utf8 NOT NULL,
26 `thread` int(11) DEFAULT NULL,
27 `hash` char(40) COLLATE ascii_bin NOT NULL,
28 `created` int(11) NOT NULL,
29 `expires` int(11) DEFAULT NULL,
30 `passed` smallint(6) NOT NULL,
31 PRIMARY KEY (`hash`),
32 KEY `board` (`board`,`thread`),
33 KEY `expires` (`expires`)
34) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin;
35
36-- --------------------------------------------------------
37
38--
39-- Table structure for table `bans`
40--
41
42CREATE TABLE IF NOT EXISTS `bans` (
43 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
44 `ipstart` varbinary(16) NOT NULL,
45 `ipend` varbinary(16) DEFAULT NULL,
46 `created` int(10) unsigned NOT NULL,
47 `expires` int(10) unsigned DEFAULT NULL,
48 `board` varchar(58) DEFAULT NULL,
49 `creator` int(10) NOT NULL,
50 `reason` text,
51 `seen` tinyint(1) NOT NULL,
52 `post` blob,
53 PRIMARY KEY (`id`),
54 KEY `expires` (`expires`),
55 KEY `ipstart` (`ipstart`,`ipend`)
56) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
57
58-- --------------------------------------------------------
59
60--
61-- Table structure for table `boards`
62--
63
64CREATE TABLE IF NOT EXISTS `boards` (
65 `uri` varchar(58) CHARACTER SET utf8 NOT NULL,
66 `title` tinytext NOT NULL,
67 `subtitle` tinytext,
68 -- `indexed` boolean default true,
69 PRIMARY KEY (`uri`)
70) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
71
72--
73-- Dumping data for table `boards`
74--
75
76INSERT INTO `boards` VALUES
77('b', 'Random', NULL);
78
79-- --------------------------------------------------------
80
81--
82-- Table structure for table `cites`
83--
84
85CREATE TABLE IF NOT EXISTS `cites` (
86 `board` varchar(58) NOT NULL,
87 `post` int(11) NOT NULL,
88 `target_board` varchar(58) NOT NULL,
89 `target` int(11) NOT NULL,
90 KEY `target` (`target_board`,`target`),
91 KEY `post` (`board`,`post`)
92) ENGINE=MyISAM DEFAULT CHARSET=utf8;
93
94-- --------------------------------------------------------
95
96--
97-- Table structure for table `ip_notes`
98--
99
100CREATE TABLE IF NOT EXISTS `ip_notes` (
101 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
102 `ip` varchar(39) CHARACTER SET ascii NOT NULL,
103 `mod` int(11) DEFAULT NULL,
104 `time` int(11) NOT NULL,
105 `body` text NOT NULL,
106 UNIQUE KEY `id` (`id`),
107 KEY `ip_lookup` (`ip`, `time`)
108) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `modlogs`
114--
115
116CREATE TABLE IF NOT EXISTS `modlogs` (
117 `mod` int(11) NOT NULL,
118 `ip` varchar(39) CHARACTER SET ascii NOT NULL,
119 `board` varchar(58) CHARACTER SET utf8 DEFAULT NULL,
120 `time` int(11) NOT NULL,
121 `text` text NOT NULL,
122 KEY `time` (`time`),
123 KEY `mod`(`mod`)
124) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
125
126-- --------------------------------------------------------
127
128--
129-- Table structure for table `mods`
130--
131
132CREATE TABLE IF NOT EXISTS `mods` (
133 `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
134 `username` varchar(30) NOT NULL,
135 `password` varchar(256) CHARACTER SET ascii NOT NULL COMMENT 'SHA256',
136 `version` varchar(64) CHARACTER SET ascii NOT NULL,
137 `type` smallint(2) NOT NULL,
138 `boards` text CHARACTER SET utf8 NOT NULL,
139 PRIMARY KEY (`id`),
140 UNIQUE KEY `id` (`id`,`username`)
141) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
142
143--
144-- Dumping data for table `mods`
145--
146
147INSERT INTO `mods` VALUES
148(1, 'admin', 'cedad442efeef7112fed0f50b011b2b9bf83f6898082f995f69dd7865ca19fb7', '4a44c6c55df862ae901b413feecb0d49', 30, '*');
149
150-- --------------------------------------------------------
151
152--
153-- Table structure for table `mutes`
154--
155
156CREATE TABLE IF NOT EXISTS `mutes` (
157 `ip` varchar(39) NOT NULL,
158 `time` int(11) NOT NULL,
159 KEY `ip` (`ip`)
160) ENGINE=MyISAM DEFAULT CHARSET=ascii;
161
162-- --------------------------------------------------------
163
164--
165-- Table structure for table `news`
166--
167
168CREATE TABLE IF NOT EXISTS `news` (
169 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
170 `name` text NOT NULL,
171 `time` int(11) NOT NULL,
172 `subject` text NOT NULL,
173 `body` text NOT NULL,
174 UNIQUE KEY `id` (`id`),
175 KEY `time` (`time`)
176) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
177
178-- --------------------------------------------------------
179
180--
181-- Table structure for table `noticeboard`
182--
183
184CREATE TABLE IF NOT EXISTS `noticeboard` (
185 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
186 `mod` int(11) NOT NULL,
187 `time` int(11) NOT NULL,
188 `subject` text NOT NULL,
189 `body` text NOT NULL,
190 UNIQUE KEY `id` (`id`),
191 KEY `time` (`time`)
192) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
193
194-- --------------------------------------------------------
195
196--
197-- Table structure for table `pms`
198--
199
200CREATE TABLE IF NOT EXISTS `pms` (
201 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
202 `sender` int(11) NOT NULL,
203 `to` int(11) NOT NULL,
204 `message` text NOT NULL,
205 `time` int(11) NOT NULL,
206 `unread` tinyint(1) NOT NULL,
207 PRIMARY KEY (`id`),
208 KEY `to` (`to`, `unread`)
209) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
210
211-- --------------------------------------------------------
212
213--
214-- Table structure for table `reports`
215--
216
217CREATE TABLE IF NOT EXISTS `reports` (
218 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
219 `time` int(11) NOT NULL,
220 `ip` varchar(39) CHARACTER SET ascii NOT NULL,
221 `board` varchar(58) CHARACTER SET utf8 DEFAULT NULL,
222 `post` int(11) NOT NULL,
223 `reason` text NOT NULL,
224 PRIMARY KEY (`id`)
225) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
226
227-- --------------------------------------------------------
228
229--
230-- Table structure for table `robot`
231--
232
233CREATE TABLE IF NOT EXISTS `robot` (
234 `hash` varchar(40) COLLATE ascii_bin NOT NULL COMMENT 'SHA1',
235 PRIMARY KEY (`hash`)
236) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin;
237
238-- --------------------------------------------------------
239
240--
241-- Table structure for table `search_queries`
242--
243
244CREATE TABLE IF NOT EXISTS `search_queries` (
245 `ip` varchar(39) NOT NULL,
246 `time` int(11) NOT NULL,
247 `query` text NOT NULL
248) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
249
250-- --------------------------------------------------------
251
252--
253-- Table structure for table `theme_settings`
254--
255
256CREATE TABLE IF NOT EXISTS `theme_settings` (
257 `theme` varchar(40) NOT NULL,
258 `name` varchar(40) DEFAULT NULL,
259 `value` text,
260 KEY `theme` (`theme`)
261) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
262
263-- --------------------------------------------------------
264
265--
266-- Table structure for table `flood`
267--
268
269CREATE TABLE IF NOT EXISTS `flood` (
270 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
271 `ip` varchar(39) NOT NULL,
272 `board` varchar(58) CHARACTER SET utf8 NOT NULL,
273 `time` int(11) NOT NULL,
274 `posthash` char(32) NOT NULL,
275 `filehash` char(32) DEFAULT NULL,
276 `isreply` tinyint(1) NOT NULL,
277 PRIMARY KEY (`id`),
278 KEY `ip` (`ip`),
279 KEY `posthash` (`posthash`),
280 KEY `filehash` (`filehash`),
281 KEY `time` (`time`)
282) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin AUTO_INCREMENT=1 ;
283
284-- --------------------------------------------------------
285
286--
287-- Table structure for table `ban_appeals`
288--
289
290CREATE TABLE IF NOT EXISTS `ban_appeals` (
291 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
292 `ban_id` int(10) unsigned NOT NULL,
293 `time` int(10) unsigned NOT NULL,
294 `message` text NOT NULL,
295 `denied` tinyint(1) NOT NULL,
296 PRIMARY KEY (`id`),
297 KEY `ban_id` (`ban_id`)
298) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
299
300-- --------------------------------------------------------
301
302--
303-- Table structure for table `pages`
304--
305
306CREATE TABLE IF NOT EXISTS `pages` (
307 `id` int(11) NOT NULL AUTO_INCREMENT,
308 `board` varchar(58) CHARACTER SET utf8 DEFAULT NULL,
309 `name` varchar(255) CHARACTER SET utf8 NOT NULL,
310 `title` varchar(255) DEFAULT NULL,
311 `type` varchar(255) DEFAULT NULL,
312 `content` text,
313 PRIMARY KEY (`id`),
314 UNIQUE KEY `u_pages` (`name`,`board`)
315) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
316
317-- --------------------------------------------------------
318
319--
320-- Table structure for table `nntp_references`
321--
322
323CREATE TABLE IF NOT EXISTS `nntp_references` (
324 `board` varchar(30) NOT NULL,
325 `id` int(11) unsigned NOT NULL,
326 `message_id` varchar(255) CHARACTER SET ascii NOT NULL,
327 `message_id_digest` varchar(40) CHARACTER SET ascii NOT NULL,
328 `own` tinyint(1) NOT NULL,
329 `headers` text,
330 PRIMARY KEY (`message_id_digest`),
331 UNIQUE KEY `message_id` (`message_id`),
332 UNIQUE KEY `u_board_id` (`board`, `id`)
333) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
334
335-- --------------------------------------------------------
336
337--
338-- Table structure for table `captchas`
339--
340
341CREATE TABLE IF NOT EXISTS `captchas` (
342 `cookie` VARCHAR(50),
343 `extra` VARCHAR(200),
344 `text` VARCHAR(255),
345 `created_at` INT(11),
346 PRIMARY KEY (`cookie`,`extra`)
347) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
348
349
350/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
351/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
352/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;