· 7 years ago · Sep 26, 2018, 05:36 PM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2SET AUTOCOMMIT=0;
3START TRANSACTION;
4SET time_zone = "+00:00";
5
6/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
7/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
8/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
9/*!40101 SET NAMES utf8 */;
10
11
12CREATE TABLE IF NOT EXISTS `ibf_admin_logs` (
13 `id` bigint(20) NOT NULL AUTO_INCREMENT,
14 `act` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
15 `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
16 `member_id` int(10) DEFAULT NULL,
17 `ctime` int(10) DEFAULT NULL,
18 `note` text COLLATE utf8_unicode_ci,
19 `ip_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
20 PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
22
23CREATE TABLE IF NOT EXISTS `ibf_admin_sessions` (
24 `ID` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
25 `IP_ADDRESS` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
26 `MEMBER_NAME` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
27 `MEMBER_ID` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
28 `SESSION_KEY` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
29 `LOCATION` varchar(64) COLLATE utf8_unicode_ci DEFAULT 'index',
30 `LOG_IN_TIME` int(10) NOT NULL DEFAULT '0',
31 `RUNNING_TIME` int(10) NOT NULL DEFAULT '0',
32 PRIMARY KEY (`ID`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
34
35CREATE TABLE IF NOT EXISTS `ibf_badwords` (
36 `wid` int(3) NOT NULL AUTO_INCREMENT,
37 `type` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
38 `swop` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
39 `m_exact` tinyint(1) DEFAULT '0',
40 PRIMARY KEY (`wid`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=108395 ;
42
43CREATE TABLE IF NOT EXISTS `ibf_cache_store` (
44 `cs_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
45 `cs_value` text COLLATE utf8_unicode_ci NOT NULL,
46 `cs_extra` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
47 PRIMARY KEY (`cs_key`)
48) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
49
50CREATE TABLE IF NOT EXISTS `ibf_calendar_events` (
51 `eventid` mediumint(8) NOT NULL AUTO_INCREMENT,
52 `userid` mediumint(8) NOT NULL DEFAULT '0',
53 `year` int(4) NOT NULL DEFAULT '2002',
54 `month` int(2) NOT NULL DEFAULT '1',
55 `mday` int(2) NOT NULL DEFAULT '1',
56 `title` varchar(254) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no title',
57 `event_text` text COLLATE utf8_unicode_ci NOT NULL,
58 `read_perms` varchar(254) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
59 `unix_stamp` int(10) NOT NULL DEFAULT '0',
60 `priv_event` tinyint(1) NOT NULL DEFAULT '0',
61 `show_emoticons` tinyint(1) NOT NULL DEFAULT '1',
62 `rating` smallint(2) NOT NULL DEFAULT '1',
63 `event_ranged` tinyint(1) NOT NULL DEFAULT '0',
64 `event_repeat` tinyint(1) NOT NULL DEFAULT '0',
65 `repeat_unit` char(2) COLLATE utf8_unicode_ci NOT NULL,
66 `end_day` int(2) DEFAULT NULL,
67 `end_month` int(2) DEFAULT NULL,
68 `end_year` int(4) DEFAULT NULL,
69 `end_unix_stamp` int(10) DEFAULT NULL,
70 `event_bgcolor` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
71 `event_color` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
72 PRIMARY KEY (`eventid`),
73 KEY `unix_stamp` (`unix_stamp`)
74) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=103822 ;
75
76CREATE TABLE IF NOT EXISTS `ibf_categories` (
77 `id` int(11) NOT NULL DEFAULT '0',
78 `position` int(11) DEFAULT NULL,
79 `state` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
80 `name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
81 `description` text COLLATE utf8_unicode_ci,
82 `image` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
83 `url` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
84 PRIMARY KEY (`id`)
85) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
86
87CREATE TABLE IF NOT EXISTS `ibf_contacts` (
88 `id` int(11) NOT NULL,
89 `contact_id` int(11) NOT NULL DEFAULT '0',
90 `member_id` mediumint(8) NOT NULL DEFAULT '0',
91 `contact_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
92 `allow_msg` int(11) DEFAULT NULL,
93 `contact_desc` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
94 PRIMARY KEY (`id`)
95) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
96
97CREATE TABLE IF NOT EXISTS `ibf_css` (
98 `cssid` int(10) NOT NULL AUTO_INCREMENT,
99 `css_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
100 `css_text` text COLLATE utf8_unicode_ci,
101 `css_comments` text COLLATE utf8_unicode_ci,
102 `updated` int(10) DEFAULT '0',
103 PRIMARY KEY (`cssid`)
104) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
105
106CREATE TABLE IF NOT EXISTS `ibf_email_logs` (
107 `email_id` int(10) NOT NULL AUTO_INCREMENT,
108 `email_subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
109 `email_content` text COLLATE utf8_unicode_ci NOT NULL,
110 `email_date` int(10) NOT NULL DEFAULT '0',
111 `from_member_id` mediumint(8) NOT NULL DEFAULT '0',
112 `from_email_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
113 `from_ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '127.0.0.1',
114 `to_member_id` mediumint(8) NOT NULL DEFAULT '0',
115 `to_email_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
116 `topic_id` int(10) NOT NULL DEFAULT '0',
117 PRIMARY KEY (`email_id`),
118 KEY `from_member_id` (`from_member_id`),
119 KEY `email_date` (`email_date`)
120) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
121
122CREATE TABLE IF NOT EXISTS `ibf_emoticons` (
123 `id` smallint(3) NOT NULL AUTO_INCREMENT,
124 `typed` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
125 `image` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
126 `clickable` smallint(2) NOT NULL DEFAULT '1',
127 PRIMARY KEY (`id`)
128) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=90 ;
129
130CREATE TABLE IF NOT EXISTS `ibf_faq` (
131 `id` mediumint(8) NOT NULL AUTO_INCREMENT,
132 `title` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
133 `text` text COLLATE utf8_unicode_ci,
134 `description` text COLLATE utf8_unicode_ci NOT NULL,
135 PRIMARY KEY (`id`)
136) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
137
138CREATE TABLE IF NOT EXISTS `ibf_forums` (
139 `id` int(11) NOT NULL DEFAULT '0',
140 `topics` int(11) DEFAULT NULL,
141 `posts` int(11) DEFAULT NULL,
142 `last_post` int(11) DEFAULT NULL,
143 `last_poster_id` int(11) NOT NULL DEFAULT '0',
144 `last_poster_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
145 `name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
146 `description` text COLLATE utf8_unicode_ci,
147 `position` int(11) DEFAULT NULL,
148 `use_ibc` int(11) DEFAULT NULL,
149 `use_html` int(11) DEFAULT NULL,
150 `status` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
151 `start_perms` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
152 `reply_perms` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
153 `read_perms` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
154 `password` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
155 `category` int(11) NOT NULL DEFAULT '0',
156 `last_title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
157 `last_id` int(11) DEFAULT NULL,
158 `sort_key` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
159 `sort_order` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
160 `prune` int(11) DEFAULT NULL,
161 `show_rules` int(11) DEFAULT NULL,
162 `upload_perms` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
163 `preview_posts` int(11) DEFAULT NULL,
164 `allow_poll` int(11) NOT NULL DEFAULT '1',
165 `allow_pollbump` int(11) NOT NULL DEFAULT '0',
166 `inc_postcount` int(11) NOT NULL DEFAULT '1',
167 `skin_id` int(11) DEFAULT NULL,
168 `parent_id` int(11) DEFAULT '-1',
169 `subwrap` int(11) DEFAULT '0',
170 `sub_can_post` int(11) DEFAULT '1',
171 `quick_reply` int(11) DEFAULT '0',
172 `redirect_url` varchar(250) COLLATE utf8_unicode_ci DEFAULT '',
173 `redirect_on` int(11) NOT NULL DEFAULT '0',
174 `redirect_hits` int(11) NOT NULL DEFAULT '0',
175 `redirect_loc` varchar(250) COLLATE utf8_unicode_ci DEFAULT '',
176 `rules_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
177 `rules_text` text COLLATE utf8_unicode_ci NOT NULL,
178 `has_mod_posts` int(11) NOT NULL DEFAULT '0',
179 `topic_mm_id` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
180 `notify_modq_emails` text COLLATE utf8_unicode_ci,
181 PRIMARY KEY (`id`)
182) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
183
184CREATE TABLE IF NOT EXISTS `ibf_forum_perms` (
185 `perm_id` int(10) NOT NULL AUTO_INCREMENT,
186 `perm_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
187 PRIMARY KEY (`perm_id`)
188) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
189
190CREATE TABLE IF NOT EXISTS `ibf_forum_tracker` (
191 `frid` mediumint(8) NOT NULL AUTO_INCREMENT,
192 `member_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
193 `forum_id` smallint(5) NOT NULL DEFAULT '0',
194 `start_date` int(10) DEFAULT NULL,
195 `last_sent` int(10) NOT NULL DEFAULT '0',
196 PRIMARY KEY (`frid`)
197) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
198
199CREATE TABLE IF NOT EXISTS `ibf_groups` (
200 `g_id` int(11) NOT NULL,
201 `g_view_board` int(11) DEFAULT NULL,
202 `g_mem_info` int(11) DEFAULT NULL,
203 `g_other_topics` int(11) DEFAULT NULL,
204 `g_use_search` int(11) DEFAULT NULL,
205 `g_email_friend` int(11) DEFAULT NULL,
206 `g_invite_friend` int(11) DEFAULT NULL,
207 `g_edit_profile` int(11) DEFAULT NULL,
208 `g_post_new_topics` int(11) DEFAULT NULL,
209 `g_reply_own_topics` int(11) DEFAULT NULL,
210 `g_reply_other_topics` int(11) DEFAULT NULL,
211 `g_edit_posts` int(11) DEFAULT NULL,
212 `g_delete_own_posts` int(11) DEFAULT NULL,
213 `g_open_close_posts` int(11) DEFAULT NULL,
214 `g_delete_own_topics` int(11) DEFAULT NULL,
215 `g_post_polls` int(11) DEFAULT NULL,
216 `g_vote_polls` int(11) DEFAULT NULL,
217 `g_use_pm` int(11) DEFAULT NULL,
218 `g_is_supmod` int(11) DEFAULT NULL,
219 `g_access_cp` int(11) DEFAULT NULL,
220 `g_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
221 `g_can_remove` int(11) DEFAULT NULL,
222 `g_append_edit` int(11) DEFAULT NULL,
223 `g_access_offline` int(11) DEFAULT NULL,
224 `g_avoid_q` int(11) DEFAULT NULL,
225 `g_avoid_flood` int(11) DEFAULT NULL,
226 `g_icon` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
227 `g_attach_max` int(11) DEFAULT NULL,
228 `g_avatar_upload` int(11) DEFAULT NULL,
229 `g_calendar_post` int(11) DEFAULT NULL,
230 `prefix` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
231 `suffix` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
232 `g_max_messages` int(11) DEFAULT '50',
233 `g_max_mass_pm` int(11) DEFAULT '0',
234 `g_search_flood` int(11) DEFAULT '20',
235 `g_edit_cutoff` int(11) DEFAULT '0',
236 `g_promotion` varchar(10) COLLATE utf8_unicode_ci DEFAULT '-1&-1',
237 `g_hide_from_list` int(11) DEFAULT NULL,
238 `g_post_closed` int(11) DEFAULT NULL,
239 `g_perm_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
240 `g_photo_max_vars` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
241 `g_dohtml` int(11) DEFAULT NULL,
242 `g_edit_topic` int(11) DEFAULT NULL,
243 `g_email_limit` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '10:15',
244 `g_fine_edit` int(11) DEFAULT NULL,
245 `g_allow_inventoryedit` int(11) DEFAULT NULL,
246 `g_discount` int(11) NOT NULL DEFAULT '0',
247 `g_access_store` int(11) DEFAULT NULL,
248 `g_donate_points` int(11) DEFAULT NULL,
249 `g_donate_items` int(11) DEFAULT NULL,
250 `g_buyitems` int(11) DEFAULT NULL,
251 `g_gain_points` int(11) DEFAULT NULL,
252 PRIMARY KEY (`g_id`)
253) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
254
255CREATE TABLE IF NOT EXISTS `ibf_languages` (
256 `lid` mediumint(8) NOT NULL AUTO_INCREMENT,
257 `ldir` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
258 `lname` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
259 `lauthor` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
260 `lemail` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
261 PRIMARY KEY (`lid`)
262) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
263
264CREATE TABLE IF NOT EXISTS `ibf_macro` (
265 `macro_id` smallint(3) NOT NULL AUTO_INCREMENT,
266 `macro_value` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
267 `macro_replace` text COLLATE utf8_unicode_ci,
268 `can_remove` tinyint(1) DEFAULT '0',
269 `macro_set` smallint(3) DEFAULT NULL,
270 PRIMARY KEY (`macro_id`),
271 KEY `macro_set` (`macro_set`)
272) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
273
274CREATE TABLE IF NOT EXISTS `ibf_macro_name` (
275 `set_id` smallint(3) NOT NULL DEFAULT '0',
276 `set_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
277 PRIMARY KEY (`set_id`)
278) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
279
280CREATE TABLE IF NOT EXISTS `ibf_members` (
281 `id` int(11) NOT NULL DEFAULT '0',
282 `name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
283 `mgroup` int(11) NOT NULL DEFAULT '0',
284 `password` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
285 `email` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
286 `joined` int(11) NOT NULL DEFAULT '0',
287 `ip_address` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
288 `avatar` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
289 `avatar_size` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
290 `posts` int(11) DEFAULT '0',
291 `post_addon` int(11) NOT NULL DEFAULT '0',
292 `aim_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
293 `icq_number` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
294 `location` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
295 `signature` text COLLATE utf8_unicode_ci,
296 `website` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
297 `yahoo` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
298 `title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
299 `allow_admin_mails` int(11) DEFAULT NULL,
300 `time_offset` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
301 `interests` text COLLATE utf8_unicode_ci,
302 `hide_email` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
303 `email_pm` int(11) DEFAULT NULL,
304 `email_full` int(11) DEFAULT NULL,
305 `skin` int(11) DEFAULT NULL,
306 `warn_level` int(11) DEFAULT NULL,
307 `warn_lastwarn` int(11) NOT NULL DEFAULT '0',
308 `language` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
309 `msnname` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
310 `last_post` int(11) DEFAULT NULL,
311 `restrict_post` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
312 `view_sigs` int(11) DEFAULT '1',
313 `view_img` int(11) DEFAULT '1',
314 `view_avs` int(11) DEFAULT '1',
315 `view_pop` int(11) DEFAULT '1',
316 `bday_day` int(11) DEFAULT NULL,
317 `bday_month` int(11) DEFAULT NULL,
318 `bday_year` int(11) DEFAULT NULL,
319 `new_msg` int(11) DEFAULT NULL,
320 `msg_from_id` int(11) DEFAULT NULL,
321 `msg_msg_id` int(11) DEFAULT NULL,
322 `msg_total` int(11) DEFAULT NULL,
323 `vdirs` text COLLATE utf8_unicode_ci,
324 `show_popup` int(11) DEFAULT NULL,
325 `misc` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
326 `last_visit` int(11) DEFAULT '0',
327 `last_activity` int(11) DEFAULT '0',
328 `dst_in_use` int(11) DEFAULT '0',
329 `view_prefs` varchar(250) COLLATE utf8_unicode_ci DEFAULT '-1&-1',
330 `coppa_user` int(11) DEFAULT '0',
331 `mod_posts` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
332 `auto_track` int(11) DEFAULT '0',
333 `org_perm_id` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
334 `org_supmod` int(11) DEFAULT '0',
335 `integ_msg` varchar(250) COLLATE utf8_unicode_ci DEFAULT '',
336 `temp_ban` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
337 `sub_end` int(11) NOT NULL DEFAULT '0',
338 `points` int(11) NOT NULL DEFAULT '0',
339 `deposited` int(11) NOT NULL DEFAULT '0',
340 `auto_collect` int(11) NOT NULL DEFAULT '0',
341 `last_collect` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0/0/0',
342 `extra_interest` int(11) NOT NULL DEFAULT '0',
343 `creditcard` int(11) NOT NULL DEFAULT '0',
344 `name_prefix` text COLLATE utf8_unicode_ci NOT NULL,
345 `name_suffix` text COLLATE utf8_unicode_ci NOT NULL,
346 PRIMARY KEY (`id`)
347) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
348
349CREATE TABLE IF NOT EXISTS `ibf_member_extra` (
350 `id` mediumint(8) NOT NULL DEFAULT '0',
351 `notes` text COLLATE utf8_unicode_ci,
352 `links` text COLLATE utf8_unicode_ci,
353 `bio` text COLLATE utf8_unicode_ci,
354 `ta_size` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
355 `photo_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
356 `photo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
357 `photo_dimensions` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
358 PRIMARY KEY (`id`)
359) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
360
361CREATE TABLE IF NOT EXISTS `ibf_messages` (
362 `msg_id` int(11) NOT NULL,
363 `msg_date` int(11) DEFAULT NULL,
364 `read_state` int(11) DEFAULT NULL,
365 `title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
366 `message` text COLLATE utf8_unicode_ci,
367 `from_id` int(11) NOT NULL DEFAULT '0',
368 `vid` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
369 `member_id` int(11) NOT NULL DEFAULT '0',
370 `recipient_id` int(11) NOT NULL DEFAULT '0',
371 `attach_type` int(11) DEFAULT NULL,
372 `attach_file` int(11) DEFAULT NULL,
373 `cc_users` text COLLATE utf8_unicode_ci,
374 `tracking` int(11) DEFAULT '0',
375 `read_date` int(11) DEFAULT NULL,
376 PRIMARY KEY (`msg_id`),
377 KEY `member_id` (`member_id`),
378 KEY `vid` (`vid`)
379) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
380
381CREATE TABLE IF NOT EXISTS `ibf_moderators` (
382 `mid` int(11) NOT NULL,
383 `forum_id` int(11) NOT NULL DEFAULT '0',
384 `member_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
385 `member_id` int(11) NOT NULL DEFAULT '0',
386 `edit_post` int(11) NOT NULL DEFAULT '0',
387 `edit_topic` int(11) NOT NULL DEFAULT '0',
388 `delete_post` int(11) NOT NULL DEFAULT '0',
389 `delete_topic` int(11) NOT NULL DEFAULT '0',
390 `view_ip` int(11) NOT NULL DEFAULT '0',
391 `open_topic` int(11) NOT NULL DEFAULT '0',
392 `close_topic` int(11) NOT NULL DEFAULT '0',
393 `mass_move` int(11) NOT NULL DEFAULT '0',
394 `mass_prune` int(11) NOT NULL DEFAULT '0',
395 `move_topic` int(11) NOT NULL DEFAULT '0',
396 `pin_topic` int(11) NOT NULL DEFAULT '0',
397 `unpin_topic` int(11) NOT NULL DEFAULT '0',
398 `post_q` int(11) NOT NULL DEFAULT '0',
399 `topic_q` int(11) NOT NULL DEFAULT '0',
400 `allow_warn` int(11) NOT NULL DEFAULT '0',
401 `edit_user` int(11) NOT NULL DEFAULT '0',
402 `is_group` int(11) NOT NULL DEFAULT '0',
403 `group_id` int(11) DEFAULT NULL,
404 `group_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
405 `split_merge` int(11) DEFAULT '0',
406 `can_mm` int(11) NOT NULL DEFAULT '0',
407 PRIMARY KEY (`mid`),
408 KEY `forum_id` (`forum_id`),
409 KEY `group_id` (`group_id`),
410 KEY `member_id` (`member_id`)
411) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
412
413CREATE TABLE IF NOT EXISTS `ibf_moderator_logs` (
414 `id` int(10) NOT NULL AUTO_INCREMENT,
415 `forum_id` int(5) DEFAULT '0',
416 `topic_id` int(10) NOT NULL DEFAULT '0',
417 `post_id` int(10) DEFAULT NULL,
418 `member_id` mediumint(8) NOT NULL DEFAULT '0',
419 `member_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
420 `ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
421 `http_referer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
422 `ctime` int(10) DEFAULT NULL,
423 `topic_title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
424 `action` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
425 `query_string` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
426 PRIMARY KEY (`id`)
427) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
428
429CREATE TABLE IF NOT EXISTS `ibf_pfields_content` (
430 `member_id` mediumint(8) NOT NULL DEFAULT '0',
431 `updated` int(10) DEFAULT '0',
432 PRIMARY KEY (`member_id`)
433) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
434
435CREATE TABLE IF NOT EXISTS `ibf_pfields_data` (
436 `fid` smallint(5) NOT NULL AUTO_INCREMENT,
437 `ftitle` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
438 `fdesc` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
439 `fcontent` text COLLATE utf8_unicode_ci,
440 `ftype` varchar(250) COLLATE utf8_unicode_ci DEFAULT 'text',
441 `freq` tinyint(1) DEFAULT '0',
442 `fhide` tinyint(1) DEFAULT '0',
443 `fmaxinput` smallint(6) DEFAULT '250',
444 `fedit` tinyint(1) DEFAULT '1',
445 `forder` smallint(6) DEFAULT '1',
446 `fshowreg` tinyint(1) DEFAULT '0',
447 PRIMARY KEY (`fid`)
448) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
449
450CREATE TABLE IF NOT EXISTS `ibf_polls` (
451 `pid` int(11) NOT NULL AUTO_INCREMENT,
452 `tid` int(11) NOT NULL DEFAULT '0',
453 `start_date` int(11) DEFAULT NULL,
454 `choices` text COLLATE utf8_unicode_ci,
455 `starter_id` int(11) NOT NULL DEFAULT '0',
456 `votes` int(11) NOT NULL DEFAULT '0',
457 `forum_id` int(11) NOT NULL DEFAULT '0',
458 `poll_question` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
459 PRIMARY KEY (`pid`)
460) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=114 ;
461
462CREATE TABLE IF NOT EXISTS `ibf_posts` (
463 `pid` int(11) NOT NULL AUTO_INCREMENT,
464 `append_edit` int(11) DEFAULT '0',
465 `edit_time` int(11) DEFAULT NULL,
466 `author_id` int(11) NOT NULL DEFAULT '0',
467 `author_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
468 `use_sig` int(11) NOT NULL DEFAULT '0',
469 `use_emo` int(11) NOT NULL DEFAULT '0',
470 `ip_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
471 `post_date` int(11) DEFAULT NULL,
472 `icon_id` int(11) DEFAULT NULL,
473 `post` text COLLATE utf8_unicode_ci,
474 `queued` int(11) DEFAULT NULL,
475 `topic_id` int(11) NOT NULL DEFAULT '0',
476 `forum_id` int(11) NOT NULL DEFAULT '0',
477 `attach_id` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
478 `attach_hits` int(11) DEFAULT NULL,
479 `attach_type` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
480 `attach_file` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
481 `post_title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
482 `new_topic` int(11) DEFAULT '0',
483 `edit_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
484 PRIMARY KEY (`pid`)
485) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13643384 ;
486
487CREATE TABLE IF NOT EXISTS `ibf_reg_antispam` (
488 `regid` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
489 `regcode` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
490 `ip_address` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
491 `ctime` int(10) DEFAULT NULL,
492 PRIMARY KEY (`regid`)
493) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
494
495CREATE TABLE IF NOT EXISTS `ibf_search_results` (
496 `id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
497 `topic_id` text COLLATE utf8_unicode_ci NOT NULL,
498 `search_date` int(12) NOT NULL DEFAULT '0',
499 `topic_max` int(3) NOT NULL DEFAULT '0',
500 `sort_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'last_post',
501 `sort_order` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'desc',
502 `member_id` mediumint(10) DEFAULT '0',
503 `ip_address` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
504 `post_id` text COLLATE utf8_unicode_ci,
505 `post_max` int(10) NOT NULL DEFAULT '0',
506 `query_cache` text COLLATE utf8_unicode_ci
507) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
508
509CREATE TABLE IF NOT EXISTS `ibf_sessions` (
510 `id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
511 `member_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
512 `member_id` mediumint(8) NOT NULL DEFAULT '0',
513 `ip_address` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
514 `browser` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
515 `running_time` int(10) DEFAULT NULL,
516 `login_type` tinyint(1) DEFAULT NULL,
517 `location` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
518 `member_group` smallint(3) DEFAULT NULL,
519 `in_forum` smallint(5) NOT NULL DEFAULT '0',
520 `in_topic` int(10) DEFAULT NULL,
521 PRIMARY KEY (`id`),
522 KEY `in_topic` (`in_topic`),
523 KEY `in_forum` (`in_forum`)
524) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
525
526CREATE TABLE IF NOT EXISTS `ibf_skins` (
527 `uid` int(10) NOT NULL AUTO_INCREMENT,
528 `sname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
529 `sid` int(10) NOT NULL DEFAULT '0',
530 `set_id` int(5) NOT NULL DEFAULT '0',
531 `tmpl_id` int(10) NOT NULL DEFAULT '0',
532 `macro_id` int(10) NOT NULL DEFAULT '1',
533 `css_id` int(10) NOT NULL DEFAULT '1',
534 `img_dir` varchar(200) COLLATE utf8_unicode_ci DEFAULT '1',
535 `tbl_width` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
536 `tbl_border` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
537 `hidden` tinyint(1) NOT NULL DEFAULT '0',
538 `default_set` tinyint(1) NOT NULL DEFAULT '0',
539 `css_method` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'inline',
540 PRIMARY KEY (`uid`),
541 KEY `tmpl_id` (`tmpl_id`),
542 KEY `css_id` (`css_id`)
543) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
544
545CREATE TABLE IF NOT EXISTS `ibf_skin_templates` (
546 `suid` int(10) NOT NULL AUTO_INCREMENT,
547 `set_id` int(10) NOT NULL DEFAULT '0',
548 `group_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
549 `section_content` mediumtext COLLATE utf8_unicode_ci,
550 `func_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
551 `func_data` text COLLATE utf8_unicode_ci,
552 `updated` int(10) DEFAULT NULL,
553 `can_remove` tinyint(4) DEFAULT '0',
554 PRIMARY KEY (`suid`)
555) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
556
557CREATE TABLE IF NOT EXISTS `ibf_spider_logs` (
558 `sid` int(10) NOT NULL AUTO_INCREMENT,
559 `bot` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
560 `query_string` text COLLATE utf8_unicode_ci NOT NULL,
561 `entry_date` int(10) NOT NULL DEFAULT '0',
562 `ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
563 PRIMARY KEY (`sid`)
564) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
565
566CREATE TABLE IF NOT EXISTS `ibf_stats` (
567 `TOTAL_REPLIES` int(10) NOT NULL DEFAULT '0',
568 `TOTAL_TOPICS` int(10) NOT NULL DEFAULT '0',
569 `LAST_MEM_NAME` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
570 `LAST_MEM_ID` mediumint(8) NOT NULL DEFAULT '0',
571 `MOST_DATE` int(10) DEFAULT NULL,
572 `MOST_COUNT` int(10) DEFAULT '0',
573 `MEM_COUNT` mediumint(8) NOT NULL DEFAULT '0'
574) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
575
576CREATE TABLE IF NOT EXISTS `ibf_subscriptions` (
577 `sub_id` smallint(5) NOT NULL AUTO_INCREMENT,
578 `sub_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
579 `sub_desc` text COLLATE utf8_unicode_ci,
580 `sub_new_group` mediumint(8) NOT NULL DEFAULT '0',
581 `sub_length` smallint(5) NOT NULL DEFAULT '1',
582 `sub_unit` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'm',
583 `sub_cost` decimal(10,2) NOT NULL DEFAULT '0.00',
584 `sub_run_module` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
585 PRIMARY KEY (`sub_id`)
586) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
587
588CREATE TABLE IF NOT EXISTS `ibf_subscription_currency` (
589 `subcurrency_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
590 `subcurrency_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
591 `subcurrency_exchange` decimal(10,8) NOT NULL,
592 `subcurrency_default` tinyint(1) NOT NULL DEFAULT '0',
593 PRIMARY KEY (`subcurrency_code`)
594) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
595
596CREATE TABLE IF NOT EXISTS `ibf_subscription_extra` (
597 `subextra_id` smallint(5) NOT NULL AUTO_INCREMENT,
598 `subextra_sub_id` smallint(5) NOT NULL DEFAULT '0',
599 `subextra_method_id` smallint(5) NOT NULL DEFAULT '0',
600 `subextra_product_id` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
601 `subextra_can_upgrade` tinyint(1) NOT NULL DEFAULT '0',
602 `subextra_recurring` tinyint(1) NOT NULL DEFAULT '0',
603 `subextra_custom_1` text COLLATE utf8_unicode_ci,
604 `subextra_custom_2` text COLLATE utf8_unicode_ci,
605 `subextra_custom_3` text COLLATE utf8_unicode_ci,
606 `subextra_custom_4` text COLLATE utf8_unicode_ci,
607 `subextra_custom_5` text COLLATE utf8_unicode_ci,
608 PRIMARY KEY (`subextra_id`)
609) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
610
611CREATE TABLE IF NOT EXISTS `ibf_subscription_logs` (
612 `sublog_id` int(10) NOT NULL AUTO_INCREMENT,
613 `sublog_date` int(10) NOT NULL,
614 `sublog_member_id` mediumint(8) NOT NULL DEFAULT '0',
615 `sublog_transid` int(10) NOT NULL,
616 `sublog_ipaddress` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
617 `sublog_data` text COLLATE utf8_unicode_ci,
618 `sublog_postdata` text COLLATE utf8_unicode_ci,
619 PRIMARY KEY (`sublog_id`)
620) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
621
622CREATE TABLE IF NOT EXISTS `ibf_subscription_methods` (
623 `submethod_id` smallint(5) NOT NULL AUTO_INCREMENT,
624 `submethod_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
625 `submethod_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
626 `submethod_email` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
627 `submethod_sid` text COLLATE utf8_unicode_ci,
628 `submethod_custom_1` text COLLATE utf8_unicode_ci,
629 `submethod_custom_2` text COLLATE utf8_unicode_ci,
630 `submethod_custom_3` text COLLATE utf8_unicode_ci,
631 `subemthod_custom_4` text COLLATE utf8_unicode_ci,
632 `submethod_custom_5` text COLLATE utf8_unicode_ci,
633 `submethod_is_cc` tinyint(1) NOT NULL DEFAULT '0',
634 `submethod_is_auto` tinyint(1) NOT NULL DEFAULT '0',
635 `submethod_desc` text COLLATE utf8_unicode_ci,
636 `submethod_logo` text COLLATE utf8_unicode_ci,
637 `submethod_active` tinyint(1) NOT NULL,
638 `submethod_use_currency` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'USD',
639 PRIMARY KEY (`submethod_id`)
640) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
641
642CREATE TABLE IF NOT EXISTS `ibf_subscription_trans` (
643 `subtrans_id` int(10) NOT NULL AUTO_INCREMENT,
644 `subtrans_sub_id` smallint(5) NOT NULL DEFAULT '0',
645 `subtrans_member_id` mediumint(8) NOT NULL DEFAULT '0',
646 `subtrans_old_group` smallint(5) NOT NULL DEFAULT '0',
647 `subtrans_paid` decimal(10,2) NOT NULL DEFAULT '0.00',
648 `subtrans_cumulative` decimal(10,2) NOT NULL DEFAULT '0.00',
649 `subtrans_method` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
650 `subtrans_start_date` int(11) NOT NULL DEFAULT '0',
651 `subtrans_end_date` int(11) NOT NULL DEFAULT '0',
652 `subtrans_state` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
653 `subtrans_trxid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
654 `subtrans_subscrid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
655 `subtrans_currency` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'USD',
656 PRIMARY KEY (`subtrans_id`)
657) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
658
659CREATE TABLE IF NOT EXISTS `ibf_templates` (
660 `tmid` int(10) NOT NULL AUTO_INCREMENT,
661 `template` mediumtext COLLATE utf8_unicode_ci,
662 `name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
663 PRIMARY KEY (`tmid`)
664) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
665
666CREATE TABLE IF NOT EXISTS `ibf_titles` (
667 `id` smallint(5) NOT NULL AUTO_INCREMENT,
668 `posts` int(10) DEFAULT NULL,
669 `title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
670 `pips` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
671 PRIMARY KEY (`id`)
672) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
673
674CREATE TABLE IF NOT EXISTS `ibf_tmpl_names` (
675 `skid` int(10) NOT NULL AUTO_INCREMENT,
676 `skname` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Invision Board',
677 `author` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
678 `email` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
679 `url` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
680 PRIMARY KEY (`skid`)
681) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
682
683CREATE TABLE IF NOT EXISTS `ibf_topics` (
684 `tid` int(11) NOT NULL AUTO_INCREMENT,
685 `title` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
686 `description` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
687 `state` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
688 `posts` int(11) DEFAULT NULL,
689 `starter_id` int(11) NOT NULL DEFAULT '0',
690 `start_date` int(11) DEFAULT NULL,
691 `last_poster_id` int(11) NOT NULL DEFAULT '0',
692 `last_post` int(11) DEFAULT NULL,
693 `icon_id` int(11) DEFAULT NULL,
694 `starter_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
695 `last_poster_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
696 `poll_state` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
697 `last_vote` int(11) DEFAULT NULL,
698 `views` int(11) DEFAULT NULL,
699 `forum_id` int(11) NOT NULL DEFAULT '0',
700 `approved` int(11) DEFAULT NULL,
701 `author_mode` int(11) DEFAULT NULL,
702 `pinned` int(11) DEFAULT NULL,
703 `moved_to` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
704 `rating` text COLLATE utf8_unicode_ci,
705 `total_votes` int(11) NOT NULL DEFAULT '0',
706 PRIMARY KEY (`tid`),
707 KEY `last_post` (`last_post`),
708 KEY `forum_id` (`forum_id`,`approved`,`pinned`),
709 FULLTEXT KEY `title` (`title`)
710) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2792 ;
711
712CREATE TABLE IF NOT EXISTS `ibf_topic_mmod` (
713 `mm_id` smallint(5) NOT NULL AUTO_INCREMENT,
714 `mm_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
715 `mm_enabled` tinyint(1) NOT NULL DEFAULT '0',
716 `topic_state` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'leave',
717 `topic_pin` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'leave',
718 `topic_move` smallint(5) NOT NULL DEFAULT '0',
719 `topic_move_link` tinyint(1) NOT NULL DEFAULT '0',
720 `topic_title_st` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
721 `topic_title_end` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
722 `topic_reply` tinyint(1) NOT NULL DEFAULT '0',
723 `topic_reply_content` text COLLATE utf8_unicode_ci NOT NULL,
724 `topic_reply_postcount` tinyint(1) NOT NULL DEFAULT '0',
725 PRIMARY KEY (`mm_id`)
726) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9433 ;
727
728CREATE TABLE IF NOT EXISTS `ibf_tracker` (
729 `trid` mediumint(8) NOT NULL AUTO_INCREMENT,
730 `member_id` mediumint(8) NOT NULL DEFAULT '0',
731 `topic_id` bigint(20) NOT NULL DEFAULT '0',
732 `start_date` int(10) DEFAULT NULL,
733 `last_sent` int(10) NOT NULL DEFAULT '0',
734 PRIMARY KEY (`trid`)
735) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
736
737CREATE TABLE IF NOT EXISTS `ibf_validating` (
738 `vid` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
739 `member_id` mediumint(8) NOT NULL DEFAULT '0',
740 `real_group` smallint(3) NOT NULL DEFAULT '0',
741 `temp_group` smallint(3) NOT NULL DEFAULT '0',
742 `entry_date` int(10) NOT NULL DEFAULT '0',
743 `coppa_user` tinyint(1) NOT NULL DEFAULT '0',
744 `lost_pass` tinyint(1) NOT NULL DEFAULT '0',
745 `new_reg` tinyint(1) NOT NULL DEFAULT '0',
746 `email_chg` tinyint(1) NOT NULL DEFAULT '0',
747 `ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
748 PRIMARY KEY (`vid`),
749 KEY `new_reg` (`new_reg`)
750) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
751
752CREATE TABLE IF NOT EXISTS `ibf_voters` (
753 `vid` int(11) NOT NULL AUTO_INCREMENT,
754 `ip_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
755 `vote_date` int(11) NOT NULL DEFAULT '0',
756 `tid` int(11) NOT NULL DEFAULT '0',
757 `member_id` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
758 `forum_id` int(11) NOT NULL DEFAULT '0',
759 PRIMARY KEY (`vid`)
760) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2696 ;
761
762CREATE TABLE IF NOT EXISTS `ibf_warn_logs` (
763 `wlog_id` int(10) NOT NULL AUTO_INCREMENT,
764 `wlog_mid` mediumint(8) NOT NULL DEFAULT '0',
765 `wlog_notes` text COLLATE utf8_unicode_ci NOT NULL,
766 `wlog_contact` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
767 `wlog_contact_content` text COLLATE utf8_unicode_ci NOT NULL,
768 `wlog_date` int(10) NOT NULL DEFAULT '0',
769 `wlog_type` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pos',
770 `wlog_addedby` mediumint(8) NOT NULL DEFAULT '0',
771 PRIMARY KEY (`wlog_id`)
772) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
773COMMIT;
774
775/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
776/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
777/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;