1
CREATE DATABASE IF NOT EXISTS test;
3
DROP TABLE IF EXISTS `smf_admin_info_files`;
4
CREATE TABLE `smf_admin_info_files` ( `id_file` tinyint(4) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL DEFAULT '', `path` varchar(255) NOT NULL DEFAULT '', `parameters` varchar(255) NOT NULL DEFAULT '', `data` text NOT NULL, `filetype` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id_file`), KEY `filename` (`filename`(30))) CHECKSUM=1 DEFAULT CHARSET=latin1 ;
5
DROP TABLE IF EXISTS `smf_approval_queue`;
6
CREATE TABLE `smf_approval_queue` ( `id_msg` int(10) unsigned NOT NULL DEFAULT '0', `id_attach` int(10) unsigned NOT NULL DEFAULT '0', `id_event` smallint(5) unsigned NOT NULL DEFAULT '0') CHECKSUM=1 DEFAULT CHARSET=latin1 ;
7
DROP TABLE IF EXISTS `smf_attachments`;
8
CREATE TABLE `smf_attachments` ( `id_attach` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_thumb` int(10) unsigned NOT NULL DEFAULT '0', `id_msg` int(10) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_folder` tinyint(3) NOT NULL DEFAULT '1', `attachment_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `filename` varchar(255) NOT NULL DEFAULT '', `file_hash` varchar(40) NOT NULL DEFAULT '', `fileext` varchar(8) NOT NULL DEFAULT '', `size` int(10) unsigned NOT NULL DEFAULT '0', `downloads` mediumint(8) unsigned NOT NULL DEFAULT '0', `width` mediumint(8) unsigned NOT NULL DEFAULT '0', `height` mediumint(8) unsigned NOT NULL DEFAULT '0', `mime_type` varchar(20) NOT NULL DEFAULT '', `approved` tinyint(3) NOT NULL DEFAULT '1', PRIMARY KEY (`id_attach`), UNIQUE KEY `id_member` (`id_member`,`id_attach`), KEY `id_msg` (`id_msg`), KEY `attachment_type` (`attachment_type`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
9
DROP TABLE IF EXISTS `smf_ban_groups`;
10
CREATE TABLE `smf_ban_groups` ( `id_ban_group` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL DEFAULT '', `ban_time` int(10) unsigned NOT NULL DEFAULT '0', `expire_time` int(10) unsigned DEFAULT NULL, `cannot_access` tinyint(3) unsigned NOT NULL DEFAULT '0', `cannot_register` tinyint(3) unsigned NOT NULL DEFAULT '0', `cannot_post` tinyint(3) unsigned NOT NULL DEFAULT '0', `cannot_login` tinyint(3) unsigned NOT NULL DEFAULT '0', `reason` varchar(255) NOT NULL DEFAULT '', `notes` text NOT NULL, PRIMARY KEY (`id_ban_group`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
11
DROP TABLE IF EXISTS `smf_ban_items`;
12
CREATE TABLE `smf_ban_items` ( `id_ban` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `id_ban_group` smallint(5) unsigned NOT NULL DEFAULT '0', `ip_low1` tinyint(3) unsigned NOT NULL DEFAULT '0', `ip_high1` tinyint(3) unsigned NOT NULL DEFAULT '0', `ip_low2` tinyint(3) unsigned NOT NULL DEFAULT '0', `ip_high2` tinyint(3) unsigned NOT NULL DEFAULT '0', `ip_low3` tinyint(3) unsigned NOT NULL DEFAULT '0', `ip_high3` tinyint(3) unsigned NOT NULL DEFAULT '0', `ip_low4` tinyint(3) unsigned NOT NULL DEFAULT '0', `ip_high4` tinyint(3) unsigned NOT NULL DEFAULT '0', `hostname` varchar(255) NOT NULL DEFAULT '', `email_address` varchar(255) NOT NULL DEFAULT '', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `hits` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_ban`), KEY `id_ban_group` (`id_ban_group`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
13
DROP TABLE IF EXISTS `smf_board_permissions`;
14
CREATE TABLE `smf_board_permissions` ( `id_group` smallint(5) NOT NULL DEFAULT '0', `id_profile` smallint(5) unsigned NOT NULL DEFAULT '0', `permission` varchar(30) NOT NULL DEFAULT '', `add_deny` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id_group`,`id_profile`,`permission`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
15
DROP TABLE IF EXISTS `smf_boards`;
16
CREATE TABLE `smf_boards` ( `id_board` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `id_cat` tinyint(4) unsigned NOT NULL DEFAULT '0', `child_level` tinyint(4) unsigned NOT NULL DEFAULT '0', `id_parent` smallint(5) unsigned NOT NULL DEFAULT '0', `board_order` smallint(5) NOT NULL DEFAULT '0', `id_last_msg` int(10) unsigned NOT NULL DEFAULT '0', `id_msg_updated` int(10) unsigned NOT NULL DEFAULT '0', `member_groups` varchar(255) NOT NULL DEFAULT '-1,0', `id_profile` smallint(5) unsigned NOT NULL DEFAULT '1', `name` varchar(255) NOT NULL DEFAULT '', `description` text NOT NULL, `num_topics` mediumint(8) unsigned NOT NULL DEFAULT '0', `num_posts` mediumint(8) unsigned NOT NULL DEFAULT '0', `count_posts` tinyint(4) NOT NULL DEFAULT '0', `id_theme` tinyint(4) unsigned NOT NULL DEFAULT '0', `override_theme` tinyint(4) unsigned NOT NULL DEFAULT '0', `unapproved_posts` smallint(5) NOT NULL DEFAULT '0', `unapproved_topics` smallint(5) NOT NULL DEFAULT '0', `redirect` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id_board`), UNIQUE KEY `categories` (`id_cat`,`id_board`), KEY `id_parent` (`id_parent`), KEY `id_msg_updated` (`id_msg_updated`), KEY `member_groups` (`member_groups`(48))) CHECKSUM=1 DEFAULT CHARSET=utf8;
17
DROP TABLE IF EXISTS `smf_calendar`;
18
CREATE TABLE `smf_calendar` ( `id_event` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `start_date` date NOT NULL DEFAULT '0001-01-01', `end_date` date NOT NULL DEFAULT '0001-01-01', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', `title` varchar(60) NOT NULL DEFAULT '', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_event`), KEY `start_date` (`start_date`), KEY `end_date` (`end_date`), KEY `topic` (`id_topic`,`id_member`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
19
DROP TABLE IF EXISTS `smf_calendar_holidays`;
20
CREATE TABLE `smf_calendar_holidays` ( `id_holiday` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `event_date` date NOT NULL DEFAULT '0001-01-01', `title` varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (`id_holiday`), KEY `event_date` (`event_date`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
21
DROP TABLE IF EXISTS `smf_categories`;
22
CREATE TABLE `smf_categories` ( `id_cat` tinyint(4) unsigned NOT NULL AUTO_INCREMENT, `cat_order` tinyint(4) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `can_collapse` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id_cat`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
23
DROP TABLE IF EXISTS `smf_collapsed_categories`;
24
CREATE TABLE `smf_collapsed_categories` ( `id_cat` tinyint(4) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_cat`,`id_member`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
25
DROP TABLE IF EXISTS `smf_custom_fields`;
26
CREATE TABLE `smf_custom_fields` ( `id_field` smallint(5) NOT NULL AUTO_INCREMENT, `col_name` varchar(12) NOT NULL DEFAULT '', `field_name` varchar(40) NOT NULL DEFAULT '', `field_desc` varchar(255) NOT NULL DEFAULT '', `field_type` varchar(8) NOT NULL DEFAULT 'text', `field_length` smallint(5) NOT NULL DEFAULT '255', `field_options` text NOT NULL, `mask` varchar(255) NOT NULL DEFAULT '', `show_reg` tinyint(3) NOT NULL DEFAULT '0', `show_display` tinyint(3) NOT NULL DEFAULT '0', `show_profile` varchar(20) NOT NULL DEFAULT 'forumprofile', `private` tinyint(3) NOT NULL DEFAULT '0', `active` tinyint(3) NOT NULL DEFAULT '1', `bbc` tinyint(3) NOT NULL DEFAULT '0', `can_search` tinyint(3) NOT NULL DEFAULT '0', `default_value` varchar(255) NOT NULL DEFAULT '', `enclose` text NOT NULL, `placement` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id_field`), UNIQUE KEY `col_name` (`col_name`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
27
DROP TABLE IF EXISTS `smf_group_moderators`;
28
CREATE TABLE `smf_group_moderators` ( `id_group` smallint(5) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_group`,`id_member`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
29
DROP TABLE IF EXISTS `smf_log_actions`;
30
CREATE TABLE `smf_log_actions` ( `id_action` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_log` tinyint(3) unsigned NOT NULL DEFAULT '1', `log_time` int(10) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `ip` char(16) NOT NULL DEFAULT '', `action` varchar(30) NOT NULL DEFAULT '', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_msg` int(10) unsigned NOT NULL DEFAULT '0', `extra` text NOT NULL, PRIMARY KEY (`id_action`), KEY `id_log` (`id_log`), KEY `log_time` (`log_time`), KEY `id_member` (`id_member`), KEY `id_board` (`id_board`), KEY `id_msg` (`id_msg`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
31
DROP TABLE IF EXISTS `smf_log_activity`;
32
CREATE TABLE `smf_log_activity` ( `date` date NOT NULL DEFAULT '0001-01-01', `hits` mediumint(8) unsigned NOT NULL DEFAULT '0', `topics` smallint(5) unsigned NOT NULL DEFAULT '0', `posts` smallint(5) unsigned NOT NULL DEFAULT '0', `registers` smallint(5) unsigned NOT NULL DEFAULT '0', `most_on` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`date`), KEY `most_on` (`most_on`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
33
DROP TABLE IF EXISTS `smf_log_banned`;
34
CREATE TABLE `smf_log_banned` ( `id_ban_log` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `ip` char(16) NOT NULL DEFAULT '', `email` varchar(255) NOT NULL DEFAULT '', `log_time` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_ban_log`), KEY `log_time` (`log_time`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
35
DROP TABLE IF EXISTS `smf_log_boards`;
36
CREATE TABLE `smf_log_boards` ( `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `id_msg` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_member`,`id_board`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
37
DROP TABLE IF EXISTS `smf_log_comments`;
38
CREATE TABLE `smf_log_comments` ( `id_comment` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `member_name` varchar(80) NOT NULL DEFAULT '', `comment_type` varchar(8) NOT NULL DEFAULT 'warning', `id_recipient` mediumint(8) unsigned NOT NULL DEFAULT '0', `recipient_name` varchar(255) NOT NULL DEFAULT '', `log_time` int(10) NOT NULL DEFAULT '0', `id_notice` mediumint(8) unsigned NOT NULL DEFAULT '0', `counter` tinyint(3) NOT NULL DEFAULT '0', `body` text NOT NULL, PRIMARY KEY (`id_comment`), KEY `id_recipient` (`id_recipient`), KEY `log_time` (`log_time`), KEY `comment_type` (`comment_type`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
39
DROP TABLE IF EXISTS `smf_log_digest`;
40
CREATE TABLE `smf_log_digest` ( `id_topic` mediumint(8) unsigned NOT NULL, `id_msg` int(10) unsigned NOT NULL, `note_type` varchar(10) NOT NULL DEFAULT 'post', `daily` tinyint(3) unsigned NOT NULL DEFAULT '0', `exclude` mediumint(8) unsigned NOT NULL DEFAULT '0') CHECKSUM=1 DEFAULT CHARSET=utf8;
41
DROP TABLE IF EXISTS `smf_log_errors`;
42
CREATE TABLE `smf_log_errors` ( `id_error` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `log_time` int(10) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `ip` char(16) NOT NULL DEFAULT '', `url` text NOT NULL, `message` text NOT NULL, `session` char(32) NOT NULL DEFAULT '', `error_type` char(15) NOT NULL DEFAULT 'general', `file` varchar(255) NOT NULL DEFAULT '', `line` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_error`), KEY `log_time` (`log_time`), KEY `id_member` (`id_member`), KEY `ip` (`ip`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
43
DROP TABLE IF EXISTS `smf_log_floodcontrol`;
44
CREATE TABLE `smf_log_floodcontrol` ( `ip` char(16) NOT NULL DEFAULT '', `log_time` int(10) unsigned NOT NULL DEFAULT '0', `log_type` varchar(8) NOT NULL DEFAULT 'post', PRIMARY KEY (`ip`,`log_type`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
45
DROP TABLE IF EXISTS `smf_log_group_requests`;
46
CREATE TABLE `smf_log_group_requests` ( `id_request` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_group` smallint(5) unsigned NOT NULL DEFAULT '0', `time_applied` int(10) unsigned NOT NULL DEFAULT '0', `reason` text NOT NULL, PRIMARY KEY (`id_request`), UNIQUE KEY `id_member` (`id_member`,`id_group`)) CHECKSUM=1 DEFAULT CHARSET=latin1 ;
47
DROP TABLE IF EXISTS `smf_log_karma`;
48
CREATE TABLE `smf_log_karma` ( `id_target` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_executor` mediumint(8) unsigned NOT NULL DEFAULT '0', `log_time` int(10) unsigned NOT NULL DEFAULT '0', `action` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id_target`,`id_executor`), KEY `log_time` (`log_time`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
49
DROP TABLE IF EXISTS `smf_log_mark_read`;
50
CREATE TABLE `smf_log_mark_read` ( `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `id_msg` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_member`,`id_board`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
51
DROP TABLE IF EXISTS `smf_log_member_notices`;
52
CREATE TABLE `smf_log_member_notices` ( `id_notice` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `subject` varchar(255) NOT NULL DEFAULT '', `body` text NOT NULL, PRIMARY KEY (`id_notice`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
53
DROP TABLE IF EXISTS `smf_log_notify`;
54
CREATE TABLE `smf_log_notify` ( `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `sent` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_member`,`id_topic`,`id_board`), KEY `id_topic` (`id_topic`,`id_member`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
55
DROP TABLE IF EXISTS `smf_log_online`;
56
CREATE TABLE `smf_log_online` ( `session` varchar(32) NOT NULL DEFAULT '', `log_time` int(10) NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_spider` smallint(5) unsigned NOT NULL DEFAULT '0', `ip` int(10) unsigned NOT NULL DEFAULT '0', `url` text NOT NULL, PRIMARY KEY (`session`), KEY `log_time` (`log_time`), KEY `id_member` (`id_member`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
57
DROP TABLE IF EXISTS `smf_log_packages`;
58
CREATE TABLE `smf_log_packages` ( `id_install` int(10) NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL DEFAULT '', `package_id` varchar(255) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `version` varchar(255) NOT NULL DEFAULT '', `id_member_installed` mediumint(8) NOT NULL DEFAULT '0', `member_installed` varchar(255) NOT NULL DEFAULT '', `time_installed` int(10) NOT NULL DEFAULT '0', `id_member_removed` mediumint(8) NOT NULL DEFAULT '0', `member_removed` varchar(255) NOT NULL DEFAULT '', `time_removed` int(10) NOT NULL DEFAULT '0', `install_state` tinyint(3) NOT NULL DEFAULT '1', `failed_steps` text NOT NULL, `themes_installed` varchar(255) NOT NULL DEFAULT '', `db_changes` text NOT NULL, PRIMARY KEY (`id_install`), KEY `filename` (`filename`(15))) CHECKSUM=1 DEFAULT CHARSET=utf8;
59
DROP TABLE IF EXISTS `smf_log_polls`;
60
CREATE TABLE `smf_log_polls` ( `id_poll` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_choice` tinyint(3) unsigned NOT NULL DEFAULT '0', KEY `id_poll` (`id_poll`,`id_member`,`id_choice`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
61
DROP TABLE IF EXISTS `smf_log_reported`;
62
CREATE TABLE `smf_log_reported` ( `id_report` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `id_msg` int(10) unsigned NOT NULL DEFAULT '0', `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `membername` varchar(255) NOT NULL DEFAULT '', `subject` varchar(255) NOT NULL DEFAULT '', `body` text NOT NULL, `time_started` int(10) NOT NULL DEFAULT '0', `time_updated` int(10) NOT NULL DEFAULT '0', `num_reports` mediumint(6) NOT NULL DEFAULT '0', `closed` tinyint(3) NOT NULL DEFAULT '0', `ignore_all` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id_report`), KEY `id_member` (`id_member`), KEY `id_topic` (`id_topic`), KEY `closed` (`closed`), KEY `time_started` (`time_started`), KEY `id_msg` (`id_msg`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
63
DROP TABLE IF EXISTS `smf_log_reported_comments`;
64
CREATE TABLE `smf_log_reported_comments` ( `id_comment` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `id_report` mediumint(8) NOT NULL DEFAULT '0', `id_member` mediumint(8) NOT NULL, `membername` varchar(255) NOT NULL DEFAULT '', `comment` varchar(255) NOT NULL DEFAULT '', `time_sent` int(10) NOT NULL, PRIMARY KEY (`id_comment`), KEY `id_report` (`id_report`), KEY `id_member` (`id_member`), KEY `time_sent` (`time_sent`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
65
DROP TABLE IF EXISTS `smf_log_scheduled_tasks`;
66
CREATE TABLE `smf_log_scheduled_tasks` ( `id_log` mediumint(8) NOT NULL AUTO_INCREMENT, `id_task` smallint(5) NOT NULL DEFAULT '0', `time_run` int(10) NOT NULL DEFAULT '0', `time_taken` float NOT NULL DEFAULT '0', PRIMARY KEY (`id_log`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
67
DROP TABLE IF EXISTS `smf_log_search_messages`;
68
CREATE TABLE `smf_log_search_messages` ( `id_search` tinyint(3) unsigned NOT NULL DEFAULT '0', `id_msg` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_search`,`id_msg`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
69
DROP TABLE IF EXISTS `smf_log_search_results`;
70
CREATE TABLE `smf_log_search_results` ( `id_search` tinyint(3) unsigned NOT NULL DEFAULT '0', `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_msg` int(10) unsigned NOT NULL DEFAULT '0', `relevance` smallint(5) unsigned NOT NULL DEFAULT '0', `num_matches` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_search`,`id_topic`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
71
DROP TABLE IF EXISTS `smf_log_search_subjects`;
72
CREATE TABLE `smf_log_search_subjects` ( `word` varchar(20) NOT NULL DEFAULT '', `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`word`,`id_topic`), KEY `id_topic` (`id_topic`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
73
DROP TABLE IF EXISTS `smf_log_search_topics`;
74
CREATE TABLE `smf_log_search_topics` ( `id_search` tinyint(3) unsigned NOT NULL DEFAULT '0', `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_search`,`id_topic`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
75
DROP TABLE IF EXISTS `smf_log_spider_hits`;
76
CREATE TABLE `smf_log_spider_hits` ( `id_hit` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_spider` smallint(5) unsigned NOT NULL DEFAULT '0', `log_time` int(10) unsigned NOT NULL DEFAULT '0', `url` varchar(255) NOT NULL DEFAULT '', `processed` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id_hit`), KEY `id_spider` (`id_spider`), KEY `log_time` (`log_time`), KEY `processed` (`processed`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
77
DROP TABLE IF EXISTS `smf_log_spider_stats`;
78
CREATE TABLE `smf_log_spider_stats` ( `id_spider` smallint(5) unsigned NOT NULL DEFAULT '0', `page_hits` smallint(5) unsigned NOT NULL DEFAULT '0', `last_seen` int(10) unsigned NOT NULL DEFAULT '0', `stat_date` date NOT NULL DEFAULT '0001-01-01', PRIMARY KEY (`stat_date`,`id_spider`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
79
DROP TABLE IF EXISTS `smf_log_subscribed`;
80
CREATE TABLE `smf_log_subscribed` ( `id_sublog` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_subscribe` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_member` int(10) NOT NULL DEFAULT '0', `old_id_group` smallint(5) NOT NULL DEFAULT '0', `start_time` int(10) NOT NULL DEFAULT '0', `end_time` int(10) NOT NULL DEFAULT '0', `status` tinyint(3) NOT NULL DEFAULT '0', `payments_pending` tinyint(3) NOT NULL DEFAULT '0', `pending_details` text NOT NULL, `reminder_sent` tinyint(3) NOT NULL DEFAULT '0', `vendor_ref` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id_sublog`), UNIQUE KEY `id_subscribe` (`id_subscribe`,`id_member`), KEY `end_time` (`end_time`), KEY `reminder_sent` (`reminder_sent`), KEY `payments_pending` (`payments_pending`), KEY `status` (`status`), KEY `id_member` (`id_member`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
81
DROP TABLE IF EXISTS `smf_log_topics`;
82
CREATE TABLE `smf_log_topics` ( `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_msg` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_member`,`id_topic`), KEY `id_topic` (`id_topic`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
83
DROP TABLE IF EXISTS `smf_mail_queue`;
84
CREATE TABLE `smf_mail_queue` ( `id_mail` int(10) unsigned NOT NULL AUTO_INCREMENT, `time_sent` int(10) NOT NULL DEFAULT '0', `recipient` varchar(255) NOT NULL DEFAULT '', `body` text NOT NULL, `subject` varchar(255) NOT NULL DEFAULT '', `headers` text NOT NULL, `send_html` tinyint(3) NOT NULL DEFAULT '0', `priority` tinyint(3) NOT NULL DEFAULT '1', `private` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id_mail`), KEY `time_sent` (`time_sent`), KEY `mail_priority` (`priority`,`id_mail`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
85
DROP TABLE IF EXISTS `smf_membergroups`;
86
CREATE TABLE `smf_membergroups` ( `id_group` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `group_name` varchar(80) NOT NULL DEFAULT '', `description` text NOT NULL, `online_color` varchar(20) NOT NULL DEFAULT '', `min_posts` mediumint(9) NOT NULL DEFAULT '-1', `max_messages` smallint(5) unsigned NOT NULL DEFAULT '0', `stars` varchar(255) NOT NULL DEFAULT '', `group_type` tinyint(3) NOT NULL DEFAULT '0', `hidden` tinyint(3) NOT NULL DEFAULT '0', `id_parent` smallint(5) NOT NULL DEFAULT '-2', PRIMARY KEY (`id_group`), KEY `min_posts` (`min_posts`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
87
DROP TABLE IF EXISTS `smf_members`;
88
CREATE TABLE `smf_members` ( `id_member` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `member_name` varchar(80) NOT NULL DEFAULT '', `date_registered` int(10) unsigned NOT NULL DEFAULT '0', `posts` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_group` smallint(5) unsigned NOT NULL DEFAULT '0', `lngfile` varchar(255) NOT NULL DEFAULT '', `last_login` int(10) unsigned NOT NULL DEFAULT '0', `real_name` varchar(255) NOT NULL DEFAULT '', `instant_messages` smallint(5) NOT NULL DEFAULT '0', `unread_messages` smallint(5) NOT NULL DEFAULT '0', `new_pm` tinyint(3) unsigned NOT NULL DEFAULT '0', `buddy_list` text NOT NULL, `pm_ignore_list` varchar(255) NOT NULL DEFAULT '', `pm_prefs` mediumint(8) NOT NULL DEFAULT '0', `mod_prefs` varchar(20) NOT NULL DEFAULT '', `message_labels` text NOT NULL, `passwd` varchar(64) NOT NULL DEFAULT '', `openid_uri` text NOT NULL, `email_address` varchar(255) NOT NULL DEFAULT '', `personal_text` varchar(255) NOT NULL DEFAULT '', `gender` tinyint(4) unsigned NOT NULL DEFAULT '0', `birthdate` date NOT NULL DEFAULT '0001-01-01', `website_title` varchar(255) NOT NULL DEFAULT '', `website_url` varchar(255) NOT NULL DEFAULT '', `location` varchar(255) NOT NULL DEFAULT '', `icq` varchar(255) NOT NULL DEFAULT '', `aim` varchar(255) NOT NULL DEFAULT '', `yim` varchar(32) NOT NULL DEFAULT '', `msn` varchar(255) NOT NULL DEFAULT '', `hide_email` tinyint(4) NOT NULL DEFAULT '0', `show_online` tinyint(4) NOT NULL DEFAULT '1', `time_format` varchar(80) NOT NULL DEFAULT '', `signature` text NOT NULL, `time_offset` float NOT NULL DEFAULT '0', `avatar` varchar(255) NOT NULL DEFAULT '', `pm_email_notify` tinyint(4) NOT NULL DEFAULT '0', `karma_bad` smallint(5) unsigned NOT NULL DEFAULT '0', `karma_good` smallint(5) unsigned NOT NULL DEFAULT '0', `usertitle` varchar(255) NOT NULL DEFAULT '', `notify_announcements` tinyint(4) NOT NULL DEFAULT '1', `notify_regularity` tinyint(4) NOT NULL DEFAULT '1', `notify_send_body` tinyint(4) NOT NULL DEFAULT '0', `notify_types` tinyint(4) NOT NULL DEFAULT '2', `member_ip` varchar(255) NOT NULL DEFAULT '', `member_ip2` varchar(255) NOT NULL DEFAULT '', `secret_question` varchar(255) NOT NULL DEFAULT '', `secret_answer` varchar(64) NOT NULL DEFAULT '', `id_theme` tinyint(4) unsigned NOT NULL DEFAULT '0', `is_activated` tinyint(3) unsigned NOT NULL DEFAULT '1', `validation_code` varchar(10) NOT NULL DEFAULT '', `id_msg_last_visit` int(10) unsigned NOT NULL DEFAULT '0', `additional_groups` varchar(255) NOT NULL DEFAULT '', `smiley_set` varchar(48) NOT NULL DEFAULT '', `id_post_group` smallint(5) unsigned NOT NULL DEFAULT '0', `total_time_logged_in` int(10) unsigned NOT NULL DEFAULT '0', `password_salt` varchar(255) NOT NULL DEFAULT '', `ignore_boards` text NOT NULL, `warning` tinyint(4) NOT NULL DEFAULT '0', `passwd_flood` varchar(12) NOT NULL DEFAULT '', `pm_receive_from` tinyint(4) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id_member`), KEY `member_name` (`member_name`), KEY `real_name` (`real_name`), KEY `date_registered` (`date_registered`), KEY `id_group` (`id_group`), KEY `birthdate` (`birthdate`), KEY `posts` (`posts`), KEY `last_login` (`last_login`), KEY `lngfile` (`lngfile`(30)), KEY `id_post_group` (`id_post_group`), KEY `warning` (`warning`), KEY `total_time_logged_in` (`total_time_logged_in`), KEY `id_theme` (`id_theme`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
89
DROP TABLE IF EXISTS `smf_message_icons`;
90
CREATE TABLE `smf_message_icons` ( `id_icon` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(80) NOT NULL DEFAULT '', `filename` varchar(80) NOT NULL DEFAULT '', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `icon_order` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_icon`), KEY `id_board` (`id_board`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
91
DROP TABLE IF EXISTS `smf_messages`;
92
CREATE TABLE `smf_messages` ( `id_msg` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `poster_time` int(10) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_msg_modified` int(10) unsigned NOT NULL DEFAULT '0', `subject` varchar(255) NOT NULL DEFAULT '', `poster_name` varchar(255) NOT NULL DEFAULT '', `poster_email` varchar(255) NOT NULL DEFAULT '', `poster_ip` varchar(255) NOT NULL DEFAULT '', `smileys_enabled` tinyint(4) NOT NULL DEFAULT '1', `modified_time` int(10) unsigned NOT NULL DEFAULT '0', `modified_name` varchar(255) NOT NULL DEFAULT '', `body` text NOT NULL, `icon` varchar(16) NOT NULL DEFAULT 'xx', `approved` tinyint(3) NOT NULL DEFAULT '1', PRIMARY KEY (`id_msg`), UNIQUE KEY `topic` (`id_topic`,`id_msg`), UNIQUE KEY `id_board` (`id_board`,`id_msg`), UNIQUE KEY `id_member` (`id_member`,`id_msg`), KEY `approved` (`approved`), KEY `ip_index` (`poster_ip`(15),`id_topic`), KEY `participation` (`id_member`,`id_topic`), KEY `show_posts` (`id_member`,`id_board`), KEY `id_topic` (`id_topic`), KEY `id_member_msg` (`id_member`,`approved`,`id_msg`), KEY `current_topic` (`id_topic`,`id_msg`,`id_member`,`approved`), KEY `related_ip` (`id_member`,`poster_ip`,`id_msg`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
93
DROP TABLE IF EXISTS `smf_moderators`;
94
CREATE TABLE `smf_moderators` ( `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_board`,`id_member`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
95
DROP TABLE IF EXISTS `smf_openid_assoc`;
96
CREATE TABLE `smf_openid_assoc` ( `server_url` text NOT NULL, `handle` varchar(255) NOT NULL DEFAULT '', `secret` text NOT NULL, `issued` int(10) NOT NULL DEFAULT '0', `expires` int(10) NOT NULL DEFAULT '0', `assoc_type` varchar(64) NOT NULL, PRIMARY KEY (`server_url`(125),`handle`(125)), KEY `expires` (`expires`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
97
DROP TABLE IF EXISTS `smf_package_servers`;
98
CREATE TABLE `smf_package_servers` ( `id_server` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `url` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id_server`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
99
DROP TABLE IF EXISTS `smf_permission_profiles`;
100
CREATE TABLE `smf_permission_profiles` ( `id_profile` smallint(5) NOT NULL AUTO_INCREMENT, `profile_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id_profile`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
101
DROP TABLE IF EXISTS `smf_permissions`;
102
CREATE TABLE `smf_permissions` ( `id_group` smallint(5) NOT NULL DEFAULT '0', `permission` varchar(30) NOT NULL DEFAULT '', `add_deny` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id_group`,`permission`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
103
DROP TABLE IF EXISTS `smf_personal_messages`;
104
CREATE TABLE `smf_personal_messages` ( `id_pm` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_pm_head` int(10) unsigned NOT NULL DEFAULT '0', `id_member_from` mediumint(8) unsigned NOT NULL DEFAULT '0', `deleted_by_sender` tinyint(3) unsigned NOT NULL DEFAULT '0', `from_name` varchar(255) NOT NULL DEFAULT '', `msgtime` int(10) unsigned NOT NULL DEFAULT '0', `subject` varchar(255) NOT NULL DEFAULT '', `body` text NOT NULL, PRIMARY KEY (`id_pm`), KEY `id_member` (`id_member_from`,`deleted_by_sender`), KEY `msgtime` (`msgtime`), KEY `id_pm_head` (`id_pm_head`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
105
DROP TABLE IF EXISTS `smf_pm_recipients`;
106
CREATE TABLE `smf_pm_recipients` ( `id_pm` int(10) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0', `labels` varchar(60) NOT NULL DEFAULT '-1', `bcc` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_read` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_new` tinyint(3) unsigned NOT NULL DEFAULT '0', `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_pm`,`id_member`), UNIQUE KEY `id_member` (`id_member`,`deleted`,`id_pm`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
107
DROP TABLE IF EXISTS `smf_pm_rules`;
108
CREATE TABLE `smf_pm_rules` ( `id_rule` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_member` int(10) unsigned NOT NULL DEFAULT '0', `rule_name` varchar(60) NOT NULL, `criteria` text NOT NULL, `actions` text NOT NULL, `delete_pm` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_or` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_rule`), KEY `id_member` (`id_member`), KEY `delete_pm` (`delete_pm`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
109
DROP TABLE IF EXISTS `smf_poll_choices`;
110
CREATE TABLE `smf_poll_choices` ( `id_poll` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_choice` tinyint(3) unsigned NOT NULL DEFAULT '0', `label` varchar(255) NOT NULL DEFAULT '', `votes` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_poll`,`id_choice`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
111
DROP TABLE IF EXISTS `smf_polls`;
112
CREATE TABLE `smf_polls` ( `id_poll` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `question` varchar(255) NOT NULL DEFAULT '', `voting_locked` tinyint(1) NOT NULL DEFAULT '0', `max_votes` tinyint(3) unsigned NOT NULL DEFAULT '1', `expire_time` int(10) unsigned NOT NULL DEFAULT '0', `hide_results` tinyint(3) unsigned NOT NULL DEFAULT '0', `change_vote` tinyint(3) unsigned NOT NULL DEFAULT '0', `guest_vote` tinyint(3) unsigned NOT NULL DEFAULT '0', `num_guest_voters` int(10) unsigned NOT NULL DEFAULT '0', `reset_poll` int(10) unsigned NOT NULL DEFAULT '0', `id_member` mediumint(8) NOT NULL DEFAULT '0', `poster_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id_poll`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
113
DROP TABLE IF EXISTS `smf_scheduled_tasks`;
114
CREATE TABLE `smf_scheduled_tasks` ( `id_task` smallint(5) NOT NULL AUTO_INCREMENT, `next_time` int(10) NOT NULL DEFAULT '0', `time_offset` int(10) NOT NULL DEFAULT '0', `time_regularity` smallint(5) NOT NULL DEFAULT '0', `time_unit` varchar(1) NOT NULL DEFAULT 'h', `disabled` tinyint(3) NOT NULL DEFAULT '0', `task` varchar(24) NOT NULL DEFAULT '', PRIMARY KEY (`id_task`), UNIQUE KEY `task` (`task`), KEY `next_time` (`next_time`), KEY `disabled` (`disabled`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
115
DROP TABLE IF EXISTS `smf_sessions`;
116
CREATE TABLE `smf_sessions` ( `session_id` char(32) NOT NULL, `last_update` int(10) unsigned NOT NULL, `data` text NOT NULL, PRIMARY KEY (`session_id`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
117
DROP TABLE IF EXISTS `smf_settings`;
118
CREATE TABLE `smf_settings` ( `variable` varchar(255) NOT NULL DEFAULT '', `value` text NOT NULL, PRIMARY KEY (`variable`(30))) CHECKSUM=1 DEFAULT CHARSET=utf8;
119
DROP TABLE IF EXISTS `smf_smileys`;
120
CREATE TABLE `smf_smileys` ( `id_smiley` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(30) NOT NULL DEFAULT '', `filename` varchar(48) NOT NULL DEFAULT '', `description` varchar(80) NOT NULL DEFAULT '', `smiley_row` tinyint(4) unsigned NOT NULL DEFAULT '0', `smiley_order` smallint(5) unsigned NOT NULL DEFAULT '0', `hidden` tinyint(4) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_smiley`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
121
DROP TABLE IF EXISTS `smf_spiders`;
122
CREATE TABLE `smf_spiders` ( `id_spider` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `spider_name` varchar(255) NOT NULL DEFAULT '', `user_agent` varchar(255) NOT NULL DEFAULT '', `ip_info` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id_spider`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
123
DROP TABLE IF EXISTS `smf_subscriptions`;
124
CREATE TABLE `smf_subscriptions` ( `id_subscribe` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `cost` text NOT NULL, `length` varchar(6) NOT NULL DEFAULT '', `id_group` smallint(5) NOT NULL DEFAULT '0', `add_groups` varchar(40) NOT NULL DEFAULT '', `active` tinyint(3) NOT NULL DEFAULT '1', `repeatable` tinyint(3) NOT NULL DEFAULT '0', `allow_partial` tinyint(3) NOT NULL DEFAULT '0', `reminder` tinyint(3) NOT NULL DEFAULT '0', `email_complete` text NOT NULL, PRIMARY KEY (`id_subscribe`), KEY `active` (`active`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
125
DROP TABLE IF EXISTS `smf_themes`;
126
CREATE TABLE `smf_themes` ( `id_member` mediumint(8) NOT NULL DEFAULT '0', `id_theme` tinyint(4) unsigned NOT NULL DEFAULT '1', `variable` varchar(255) NOT NULL DEFAULT '', `value` text NOT NULL, PRIMARY KEY (`id_theme`,`id_member`,`variable`(30)), KEY `id_member` (`id_member`)) CHECKSUM=1 DEFAULT CHARSET=utf8;
127
DROP TABLE IF EXISTS `smf_topics`;
128
CREATE TABLE `smf_topics` ( `id_topic` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `is_sticky` tinyint(4) NOT NULL DEFAULT '0', `id_board` smallint(5) unsigned NOT NULL DEFAULT '0', `id_first_msg` int(10) unsigned NOT NULL DEFAULT '0', `id_last_msg` int(10) unsigned NOT NULL DEFAULT '0', `id_member_started` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_member_updated` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_poll` mediumint(8) unsigned NOT NULL DEFAULT '0', `id_previous_board` smallint(5) NOT NULL DEFAULT '0', `id_previous_topic` mediumint(8) NOT NULL DEFAULT '0', `num_replies` int(10) unsigned NOT NULL DEFAULT '0', `num_views` int(10) unsigned NOT NULL DEFAULT '0', `locked` tinyint(4) NOT NULL DEFAULT '0', `unapproved_posts` smallint(5) NOT NULL DEFAULT '0', `approved` tinyint(3) NOT NULL DEFAULT '1', PRIMARY KEY (`id_topic`), UNIQUE KEY `last_message` (`id_last_msg`,`id_board`), UNIQUE KEY `first_message` (`id_first_msg`,`id_board`), UNIQUE KEY `poll` (`id_poll`,`id_topic`), KEY `is_sticky` (`is_sticky`), KEY `approved` (`approved`), KEY `id_board` (`id_board`), KEY `member_started` (`id_member_started`,`id_board`), KEY `last_message_sticky` (`id_board`,`is_sticky`,`id_last_msg`), KEY `board_news` (`id_board`,`id_first_msg`)) CHECKSUM=1 DEFAULT CHARSET=utf8;