'',\r\n file: ''projectL_2.0.x.zip'',\r\n author: ''CrimeS''\r\n },\r\n 2837: {\r\n name: ''Wide A Responsive Theme for SMF 2.0.11'',\r\n desc: ''
It’s Quite User Friendly with Sticky Tables, Retina Display and Attractive User Interface.'',\r\n file: ''vVide.zip'',\r\n author: ''gecitli''\r\n },\r\n 2836: {\r\n name: ''Exodus'',\r\n desc: ''
'',\r\n file: ''Exodus.zip'',\r\n author: ''Daniiel''\r\n },\r\n 2835: {\r\n name: ''Greeny'',\r\n desc: ''
Greeny is a Free Responsive Theme.
'',\r\n file: ''Greeny.zip'',\r\n author: ''Pipee''\r\n },\r\n 1897: {\r\n name: ''WPhotoshop'',\r\n desc: ''WPhotoshop theme design by WannaBeDie.
You can edit logo and button by yourself.
'',\r\n file: ''WPhotoshop.zip'',\r\n author: ''WannaBeDie''\r\n }\r\n};\r\nvar smf_featured = 2834;\r\nvar smf_random = 1897;\r\nvar smf_latestThemes = [2837, 2836, 2835];\r\nfunction smf_themesMoreInfo(id)\r\n{\r\n window.smfLatestThemes_temp = document.getElementById("smfLatestThemesWindow").innerHTML;\n\n // !!! Why not just always auto?\n document.getElementById("smfLatestThemesWindow").style.overflow = "auto";\n setInnerHTML(document.getElementById("smfLatestThemesWindow"),\n ''\\\n
\\\r\n
\\\r\n
'' + smf_themeInfo[id].desc.replace(/
\\\r\n \\\r\n
'');\n}\r\n\r\nfunction smf_themesBack()\r\n{\r\n document.getElementById("smfLatestThemesWindow").style.overflow = "";\n setInnerHTML(document.getElementById("smfLatestThemesWindow"), window.smfLatestThemes_temp);\n window.scrollTo(0, findTop(document.getElementById("smfLatestThemesWindow")) - 10);\r\n}\r\n\r\nwindow.smfLatestThemes = ''\\\r\n
'';\r\n\r\nfunction findTop(el)\r\n{\r\n if (typeof(el.tagName) == "undefined")\r\n return 0;\r\n\r\n var skipMe = in_array(el.tagName.toLowerCase(), el.parentNode ? ["tr", "tbody", "form"] : []);\r\n var coordsParent = el.parentNode ? "parentNode" : "offsetParent";\r\n\r\n if (el[coordsParent] == null || typeof(el[coordsParent].offsetTop) == "undefined")\r\n return skipMe ? 0 : el.offsetTop;\r\n else\r\n return (skipMe ? 0 : el.offsetTop) + findTop(el[coordsParent]);\r\n}\r\n\r\nfunction in_array(item, array)\r\n{\r\n for (var i in array)\r\n {\r\n if (array[i] == item)\r\n return true;\r\n }\r\n\r\n return false;\r\n}', 'text/javascript');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_approval_queue`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_attachments`
--
CREATE TABLE `smf_attachments` (
`id_attach` int(10) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_ban_groups`
--
CREATE TABLE `smf_ban_groups` (
`id_ban_group` mediumint(8) UNSIGNED NOT NULL,
`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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_ban_items`
--
CREATE TABLE `smf_ban_items` (
`id_ban` mediumint(8) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_boards`
--
CREATE TABLE `smf_boards` (
`id_board` smallint(5) UNSIGNED NOT NULL,
`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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_boards`
--
INSERT INTO `smf_boards` (`id_board`, `id_cat`, `child_level`, `id_parent`, `board_order`, `id_last_msg`, `id_msg_updated`, `member_groups`, `id_profile`, `name`, `description`, `num_topics`, `num_posts`, `count_posts`, `id_theme`, `override_theme`, `unapproved_posts`, `unapproved_topics`, `redirect`) VALUES
(1, 1, 0, 0, 1, 1, 1, '-1,0,2', 1, 'General Discussion', 'Feel free to talk about anything and everything in this board.', 1, 1, 0, 0, 0, 0, 0, '');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_board_permissions`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_board_permissions`
--
INSERT INTO `smf_board_permissions` (`id_group`, `id_profile`, `permission`, `add_deny`) VALUES
(-1, 1, 'poll_view', 1),
(0, 1, 'remove_own', 1),
(0, 1, 'lock_own', 1),
(0, 1, 'mark_any_notify', 1),
(0, 1, 'mark_notify', 1),
(0, 1, 'modify_own', 1),
(0, 1, 'poll_add_own', 1),
(0, 1, 'poll_edit_own', 1),
(0, 1, 'poll_lock_own', 1),
(0, 1, 'poll_post', 1),
(0, 1, 'poll_view', 1),
(0, 1, 'poll_vote', 1),
(0, 1, 'post_attachment', 1),
(0, 1, 'post_new', 1),
(0, 1, 'post_reply_any', 1),
(0, 1, 'post_reply_own', 1),
(0, 1, 'post_unapproved_topics', 1),
(0, 1, 'post_unapproved_replies_any', 1),
(0, 1, 'post_unapproved_replies_own', 1),
(0, 1, 'post_unapproved_attachments', 1),
(0, 1, 'delete_own', 1),
(0, 1, 'report_any', 1),
(0, 1, 'send_topic', 1),
(0, 1, 'view_attachments', 1),
(2, 1, 'moderate_board', 1),
(2, 1, 'post_new', 1),
(2, 1, 'post_reply_own', 1),
(2, 1, 'post_reply_any', 1),
(2, 1, 'post_unapproved_topics', 1),
(2, 1, 'post_unapproved_replies_any', 1),
(2, 1, 'post_unapproved_replies_own', 1),
(2, 1, 'post_unapproved_attachments', 1),
(2, 1, 'poll_post', 1),
(2, 1, 'poll_add_any', 1),
(2, 1, 'poll_remove_any', 1),
(2, 1, 'poll_view', 1),
(2, 1, 'poll_vote', 1),
(2, 1, 'poll_lock_any', 1),
(2, 1, 'poll_edit_any', 1),
(2, 1, 'report_any', 1),
(2, 1, 'lock_own', 1),
(2, 1, 'send_topic', 1),
(2, 1, 'mark_any_notify', 1),
(2, 1, 'mark_notify', 1),
(2, 1, 'delete_own', 1),
(2, 1, 'modify_own', 1),
(2, 1, 'make_sticky', 1),
(2, 1, 'lock_any', 1),
(2, 1, 'remove_any', 1),
(2, 1, 'move_any', 1),
(2, 1, 'merge_any', 1),
(2, 1, 'split_any', 1),
(2, 1, 'delete_any', 1),
(2, 1, 'modify_any', 1),
(2, 1, 'approve_posts', 1),
(2, 1, 'post_attachment', 1),
(2, 1, 'view_attachments', 1),
(3, 1, 'moderate_board', 1),
(3, 1, 'post_new', 1),
(3, 1, 'post_reply_own', 1),
(3, 1, 'post_reply_any', 1),
(3, 1, 'post_unapproved_topics', 1),
(3, 1, 'post_unapproved_replies_any', 1),
(3, 1, 'post_unapproved_replies_own', 1),
(3, 1, 'post_unapproved_attachments', 1),
(3, 1, 'poll_post', 1),
(3, 1, 'poll_add_any', 1),
(3, 1, 'poll_remove_any', 1),
(3, 1, 'poll_view', 1),
(3, 1, 'poll_vote', 1),
(3, 1, 'poll_lock_any', 1),
(3, 1, 'poll_edit_any', 1),
(3, 1, 'report_any', 1),
(3, 1, 'lock_own', 1),
(3, 1, 'send_topic', 1),
(3, 1, 'mark_any_notify', 1),
(3, 1, 'mark_notify', 1),
(3, 1, 'delete_own', 1),
(3, 1, 'modify_own', 1),
(3, 1, 'make_sticky', 1),
(3, 1, 'lock_any', 1),
(3, 1, 'remove_any', 1),
(3, 1, 'move_any', 1),
(3, 1, 'merge_any', 1),
(3, 1, 'split_any', 1),
(3, 1, 'delete_any', 1),
(3, 1, 'modify_any', 1),
(3, 1, 'approve_posts', 1),
(3, 1, 'post_attachment', 1),
(3, 1, 'view_attachments', 1),
(-1, 2, 'poll_view', 1),
(0, 2, 'remove_own', 1),
(0, 2, 'lock_own', 1),
(0, 2, 'mark_any_notify', 1),
(0, 2, 'mark_notify', 1),
(0, 2, 'modify_own', 1),
(0, 2, 'poll_view', 1),
(0, 2, 'poll_vote', 1),
(0, 2, 'post_attachment', 1),
(0, 2, 'post_new', 1),
(0, 2, 'post_reply_any', 1),
(0, 2, 'post_reply_own', 1),
(0, 2, 'post_unapproved_topics', 1),
(0, 2, 'post_unapproved_replies_any', 1),
(0, 2, 'post_unapproved_replies_own', 1),
(0, 2, 'post_unapproved_attachments', 1),
(0, 2, 'delete_own', 1),
(0, 2, 'report_any', 1),
(0, 2, 'send_topic', 1),
(0, 2, 'view_attachments', 1),
(2, 2, 'moderate_board', 1),
(2, 2, 'post_new', 1),
(2, 2, 'post_reply_own', 1),
(2, 2, 'post_reply_any', 1),
(2, 2, 'post_unapproved_topics', 1),
(2, 2, 'post_unapproved_replies_any', 1),
(2, 2, 'post_unapproved_replies_own', 1),
(2, 2, 'post_unapproved_attachments', 1),
(2, 2, 'poll_post', 1),
(2, 2, 'poll_add_any', 1),
(2, 2, 'poll_remove_any', 1),
(2, 2, 'poll_view', 1),
(2, 2, 'poll_vote', 1),
(2, 2, 'poll_lock_any', 1),
(2, 2, 'poll_edit_any', 1),
(2, 2, 'report_any', 1),
(2, 2, 'lock_own', 1),
(2, 2, 'send_topic', 1),
(2, 2, 'mark_any_notify', 1),
(2, 2, 'mark_notify', 1),
(2, 2, 'delete_own', 1),
(2, 2, 'modify_own', 1),
(2, 2, 'make_sticky', 1),
(2, 2, 'lock_any', 1),
(2, 2, 'remove_any', 1),
(2, 2, 'move_any', 1),
(2, 2, 'merge_any', 1),
(2, 2, 'split_any', 1),
(2, 2, 'delete_any', 1),
(2, 2, 'modify_any', 1),
(2, 2, 'approve_posts', 1),
(2, 2, 'post_attachment', 1),
(2, 2, 'view_attachments', 1),
(3, 2, 'moderate_board', 1),
(3, 2, 'post_new', 1),
(3, 2, 'post_reply_own', 1),
(3, 2, 'post_reply_any', 1),
(3, 2, 'post_unapproved_topics', 1),
(3, 2, 'post_unapproved_replies_any', 1),
(3, 2, 'post_unapproved_replies_own', 1),
(3, 2, 'post_unapproved_attachments', 1),
(3, 2, 'poll_post', 1),
(3, 2, 'poll_add_any', 1),
(3, 2, 'poll_remove_any', 1),
(3, 2, 'poll_view', 1),
(3, 2, 'poll_vote', 1),
(3, 2, 'poll_lock_any', 1),
(3, 2, 'poll_edit_any', 1),
(3, 2, 'report_any', 1),
(3, 2, 'lock_own', 1),
(3, 2, 'send_topic', 1),
(3, 2, 'mark_any_notify', 1),
(3, 2, 'mark_notify', 1),
(3, 2, 'delete_own', 1),
(3, 2, 'modify_own', 1),
(3, 2, 'make_sticky', 1),
(3, 2, 'lock_any', 1),
(3, 2, 'remove_any', 1),
(3, 2, 'move_any', 1),
(3, 2, 'merge_any', 1),
(3, 2, 'split_any', 1),
(3, 2, 'delete_any', 1),
(3, 2, 'modify_any', 1),
(3, 2, 'approve_posts', 1),
(3, 2, 'post_attachment', 1),
(3, 2, 'view_attachments', 1),
(-1, 3, 'poll_view', 1),
(0, 3, 'remove_own', 1),
(0, 3, 'lock_own', 1),
(0, 3, 'mark_any_notify', 1),
(0, 3, 'mark_notify', 1),
(0, 3, 'modify_own', 1),
(0, 3, 'poll_view', 1),
(0, 3, 'poll_vote', 1),
(0, 3, 'post_attachment', 1),
(0, 3, 'post_reply_any', 1),
(0, 3, 'post_reply_own', 1),
(0, 3, 'post_unapproved_replies_any', 1),
(0, 3, 'post_unapproved_replies_own', 1),
(0, 3, 'post_unapproved_attachments', 1),
(0, 3, 'delete_own', 1),
(0, 3, 'report_any', 1),
(0, 3, 'send_topic', 1),
(0, 3, 'view_attachments', 1),
(2, 3, 'moderate_board', 1),
(2, 3, 'post_new', 1),
(2, 3, 'post_reply_own', 1),
(2, 3, 'post_reply_any', 1),
(2, 3, 'post_unapproved_topics', 1),
(2, 3, 'post_unapproved_replies_any', 1),
(2, 3, 'post_unapproved_replies_own', 1),
(2, 3, 'post_unapproved_attachments', 1),
(2, 3, 'poll_post', 1),
(2, 3, 'poll_add_any', 1),
(2, 3, 'poll_remove_any', 1),
(2, 3, 'poll_view', 1),
(2, 3, 'poll_vote', 1),
(2, 3, 'poll_lock_any', 1),
(2, 3, 'poll_edit_any', 1),
(2, 3, 'report_any', 1),
(2, 3, 'lock_own', 1),
(2, 3, 'send_topic', 1),
(2, 3, 'mark_any_notify', 1),
(2, 3, 'mark_notify', 1),
(2, 3, 'delete_own', 1),
(2, 3, 'modify_own', 1),
(2, 3, 'make_sticky', 1),
(2, 3, 'lock_any', 1),
(2, 3, 'remove_any', 1),
(2, 3, 'move_any', 1),
(2, 3, 'merge_any', 1),
(2, 3, 'split_any', 1),
(2, 3, 'delete_any', 1),
(2, 3, 'modify_any', 1),
(2, 3, 'approve_posts', 1),
(2, 3, 'post_attachment', 1),
(2, 3, 'view_attachments', 1),
(3, 3, 'moderate_board', 1),
(3, 3, 'post_new', 1),
(3, 3, 'post_reply_own', 1),
(3, 3, 'post_reply_any', 1),
(3, 3, 'post_unapproved_topics', 1),
(3, 3, 'post_unapproved_replies_any', 1),
(3, 3, 'post_unapproved_replies_own', 1),
(3, 3, 'post_unapproved_attachments', 1),
(3, 3, 'poll_post', 1),
(3, 3, 'poll_add_any', 1),
(3, 3, 'poll_remove_any', 1),
(3, 3, 'poll_view', 1),
(3, 3, 'poll_vote', 1),
(3, 3, 'poll_lock_any', 1),
(3, 3, 'poll_edit_any', 1),
(3, 3, 'report_any', 1),
(3, 3, 'lock_own', 1),
(3, 3, 'send_topic', 1),
(3, 3, 'mark_any_notify', 1),
(3, 3, 'mark_notify', 1),
(3, 3, 'delete_own', 1),
(3, 3, 'modify_own', 1),
(3, 3, 'make_sticky', 1),
(3, 3, 'lock_any', 1),
(3, 3, 'remove_any', 1),
(3, 3, 'move_any', 1),
(3, 3, 'merge_any', 1),
(3, 3, 'split_any', 1),
(3, 3, 'delete_any', 1),
(3, 3, 'modify_any', 1),
(3, 3, 'approve_posts', 1),
(3, 3, 'post_attachment', 1),
(3, 3, 'view_attachments', 1),
(-1, 4, 'poll_view', 1),
(0, 4, 'mark_any_notify', 1),
(0, 4, 'mark_notify', 1),
(0, 4, 'poll_view', 1),
(0, 4, 'poll_vote', 1),
(0, 4, 'report_any', 1),
(0, 4, 'send_topic', 1),
(0, 4, 'view_attachments', 1),
(2, 4, 'moderate_board', 1),
(2, 4, 'post_new', 1),
(2, 4, 'post_reply_own', 1),
(2, 4, 'post_reply_any', 1),
(2, 4, 'post_unapproved_topics', 1),
(2, 4, 'post_unapproved_replies_any', 1),
(2, 4, 'post_unapproved_replies_own', 1),
(2, 4, 'post_unapproved_attachments', 1),
(2, 4, 'poll_post', 1),
(2, 4, 'poll_add_any', 1),
(2, 4, 'poll_remove_any', 1),
(2, 4, 'poll_view', 1),
(2, 4, 'poll_vote', 1),
(2, 4, 'poll_lock_any', 1),
(2, 4, 'poll_edit_any', 1),
(2, 4, 'report_any', 1),
(2, 4, 'lock_own', 1),
(2, 4, 'send_topic', 1),
(2, 4, 'mark_any_notify', 1),
(2, 4, 'mark_notify', 1),
(2, 4, 'delete_own', 1),
(2, 4, 'modify_own', 1),
(2, 4, 'make_sticky', 1),
(2, 4, 'lock_any', 1),
(2, 4, 'remove_any', 1),
(2, 4, 'move_any', 1),
(2, 4, 'merge_any', 1),
(2, 4, 'split_any', 1),
(2, 4, 'delete_any', 1),
(2, 4, 'modify_any', 1),
(2, 4, 'approve_posts', 1),
(2, 4, 'post_attachment', 1),
(2, 4, 'view_attachments', 1),
(3, 4, 'moderate_board', 1),
(3, 4, 'post_new', 1),
(3, 4, 'post_reply_own', 1),
(3, 4, 'post_reply_any', 1),
(3, 4, 'post_unapproved_topics', 1),
(3, 4, 'post_unapproved_replies_any', 1),
(3, 4, 'post_unapproved_replies_own', 1),
(3, 4, 'post_unapproved_attachments', 1),
(3, 4, 'poll_post', 1),
(3, 4, 'poll_add_any', 1),
(3, 4, 'poll_remove_any', 1),
(3, 4, 'poll_view', 1),
(3, 4, 'poll_vote', 1),
(3, 4, 'poll_lock_any', 1),
(3, 4, 'poll_edit_any', 1),
(3, 4, 'report_any', 1),
(3, 4, 'lock_own', 1),
(3, 4, 'send_topic', 1),
(3, 4, 'mark_any_notify', 1),
(3, 4, 'mark_notify', 1),
(3, 4, 'delete_own', 1),
(3, 4, 'modify_own', 1),
(3, 4, 'make_sticky', 1),
(3, 4, 'lock_any', 1),
(3, 4, 'remove_any', 1),
(3, 4, 'move_any', 1),
(3, 4, 'merge_any', 1),
(3, 4, 'split_any', 1),
(3, 4, 'delete_any', 1),
(3, 4, 'modify_any', 1),
(3, 4, 'approve_posts', 1),
(3, 4, 'post_attachment', 1),
(3, 4, 'view_attachments', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_calendar`
--
CREATE TABLE `smf_calendar` (
`id_event` smallint(5) UNSIGNED NOT NULL,
`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(255) NOT NULL DEFAULT '',
`id_member` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_calendar_holidays`
--
CREATE TABLE `smf_calendar_holidays` (
`id_holiday` smallint(5) UNSIGNED NOT NULL,
`event_date` date NOT NULL DEFAULT '0001-01-01',
`title` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_calendar_holidays`
--
INSERT INTO `smf_calendar_holidays` (`id_holiday`, `event_date`, `title`) VALUES
(1, '0004-01-01', 'New Year''s'),
(2, '0004-12-25', 'Christmas'),
(3, '0004-02-14', 'Valentine''s Day'),
(4, '0004-03-17', 'St. Patrick''s Day'),
(5, '0004-04-01', 'April Fools'),
(6, '0004-04-22', 'Earth Day'),
(7, '0004-10-24', 'United Nations Day'),
(8, '0004-10-31', 'Halloween'),
(9, '2010-05-09', 'Mother''s Day'),
(10, '2011-05-08', 'Mother''s Day'),
(11, '2012-05-13', 'Mother''s Day'),
(12, '2013-05-12', 'Mother''s Day'),
(13, '2014-05-11', 'Mother''s Day'),
(14, '2015-05-10', 'Mother''s Day'),
(15, '2016-05-08', 'Mother''s Day'),
(16, '2017-05-14', 'Mother''s Day'),
(17, '2018-05-13', 'Mother''s Day'),
(18, '2019-05-12', 'Mother''s Day'),
(19, '2020-05-10', 'Mother''s Day'),
(20, '2008-06-15', 'Father''s Day'),
(21, '2009-06-21', 'Father''s Day'),
(22, '2010-06-20', 'Father''s Day'),
(23, '2011-06-19', 'Father''s Day'),
(24, '2012-06-17', 'Father''s Day'),
(25, '2013-06-16', 'Father''s Day'),
(26, '2014-06-15', 'Father''s Day'),
(27, '2015-06-21', 'Father''s Day'),
(28, '2016-06-19', 'Father''s Day'),
(29, '2017-06-18', 'Father''s Day'),
(30, '2018-06-17', 'Father''s Day'),
(31, '2019-06-16', 'Father''s Day'),
(32, '2020-06-21', 'Father''s Day'),
(33, '2010-06-21', 'Summer Solstice'),
(34, '2011-06-21', 'Summer Solstice'),
(35, '2012-06-20', 'Summer Solstice'),
(36, '2013-06-21', 'Summer Solstice'),
(37, '2014-06-21', 'Summer Solstice'),
(38, '2015-06-21', 'Summer Solstice'),
(39, '2016-06-20', 'Summer Solstice'),
(40, '2017-06-20', 'Summer Solstice'),
(41, '2018-06-21', 'Summer Solstice'),
(42, '2019-06-21', 'Summer Solstice'),
(43, '2020-06-20', 'Summer Solstice'),
(44, '2010-03-20', 'Vernal Equinox'),
(45, '2011-03-20', 'Vernal Equinox'),
(46, '2012-03-20', 'Vernal Equinox'),
(47, '2013-03-20', 'Vernal Equinox'),
(48, '2014-03-20', 'Vernal Equinox'),
(49, '2015-03-20', 'Vernal Equinox'),
(50, '2016-03-19', 'Vernal Equinox'),
(51, '2017-03-20', 'Vernal Equinox'),
(52, '2018-03-20', 'Vernal Equinox'),
(53, '2019-03-20', 'Vernal Equinox'),
(54, '2020-03-19', 'Vernal Equinox'),
(55, '2010-12-21', 'Winter Solstice'),
(56, '2011-12-22', 'Winter Solstice'),
(57, '2012-12-21', 'Winter Solstice'),
(58, '2013-12-21', 'Winter Solstice'),
(59, '2014-12-21', 'Winter Solstice'),
(60, '2015-12-21', 'Winter Solstice'),
(61, '2016-12-21', 'Winter Solstice'),
(62, '2017-12-21', 'Winter Solstice'),
(63, '2018-12-21', 'Winter Solstice'),
(64, '2019-12-21', 'Winter Solstice'),
(65, '2020-12-21', 'Winter Solstice'),
(66, '2010-09-22', 'Autumnal Equinox'),
(67, '2011-09-23', 'Autumnal Equinox'),
(68, '2012-09-22', 'Autumnal Equinox'),
(69, '2013-09-22', 'Autumnal Equinox'),
(70, '2014-09-22', 'Autumnal Equinox'),
(71, '2015-09-23', 'Autumnal Equinox'),
(72, '2016-09-22', 'Autumnal Equinox'),
(73, '2017-09-22', 'Autumnal Equinox'),
(74, '2018-09-22', 'Autumnal Equinox'),
(75, '2019-09-23', 'Autumnal Equinox'),
(76, '2020-09-22', 'Autumnal Equinox'),
(77, '0004-07-04', 'Independence Day'),
(78, '0004-05-05', 'Cinco de Mayo'),
(79, '0004-06-14', 'Flag Day'),
(80, '0004-11-11', 'Veterans Day'),
(81, '0004-02-02', 'Groundhog Day'),
(82, '2010-11-25', 'Thanksgiving'),
(83, '2011-11-24', 'Thanksgiving'),
(84, '2012-11-22', 'Thanksgiving'),
(85, '2013-11-28', 'Thanksgiving'),
(86, '2014-11-27', 'Thanksgiving'),
(87, '2015-11-26', 'Thanksgiving'),
(88, '2016-11-24', 'Thanksgiving'),
(89, '2017-11-23', 'Thanksgiving'),
(90, '2018-11-22', 'Thanksgiving'),
(91, '2019-11-28', 'Thanksgiving'),
(92, '2020-11-26', 'Thanksgiving'),
(93, '2010-05-31', 'Memorial Day'),
(94, '2011-05-30', 'Memorial Day'),
(95, '2012-05-28', 'Memorial Day'),
(96, '2013-05-27', 'Memorial Day'),
(97, '2014-05-26', 'Memorial Day'),
(98, '2015-05-25', 'Memorial Day'),
(99, '2016-05-30', 'Memorial Day'),
(100, '2017-05-29', 'Memorial Day'),
(101, '2018-05-28', 'Memorial Day'),
(102, '2019-05-27', 'Memorial Day'),
(103, '2020-05-25', 'Memorial Day'),
(104, '2010-09-06', 'Labor Day'),
(105, '2011-09-05', 'Labor Day'),
(106, '2012-09-03', 'Labor Day'),
(107, '2013-09-02', 'Labor Day'),
(108, '2014-09-01', 'Labor Day'),
(109, '2015-09-07', 'Labor Day'),
(110, '2016-09-05', 'Labor Day'),
(111, '2017-09-04', 'Labor Day'),
(112, '2018-09-03', 'Labor Day'),
(113, '2019-09-02', 'Labor Day'),
(114, '2020-09-07', 'Labor Day'),
(115, '0004-06-06', 'D-Day');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_categories`
--
CREATE TABLE `smf_categories` (
`id_cat` tinyint(4) UNSIGNED NOT NULL,
`cat_order` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`can_collapse` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_categories`
--
INSERT INTO `smf_categories` (`id_cat`, `cat_order`, `name`, `can_collapse`) VALUES
(1, 0, 'General Category', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_collapsed_categories`
--
CREATE TABLE `smf_collapsed_categories` (
`id_cat` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
`id_member` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_custom_fields`
--
CREATE TABLE `smf_custom_fields` (
`id_field` smallint(5) NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_group_moderators`
--
CREATE TABLE `smf_group_moderators` (
`id_group` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`id_member` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_actions`
--
CREATE TABLE `smf_log_actions` (
`id_action` int(10) UNSIGNED NOT NULL,
`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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_activity`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_activity`
--
INSERT INTO `smf_log_activity` (`date`, `hits`, `topics`, `posts`, `registers`, `most_on`) VALUES
('2016-04-28', 0, 1, 1, 1, 1),
('2016-04-30', 0, 0, 0, 0, 2);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_banned`
--
CREATE TABLE `smf_log_banned` (
`id_ban_log` mediumint(8) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_boards`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_boards`
--
INSERT INTO `smf_log_boards` (`id_member`, `id_board`, `id_msg`) VALUES
(1, 1, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_comments`
--
CREATE TABLE `smf_log_comments` (
`id_comment` mediumint(8) UNSIGNED NOT NULL,
`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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_digest`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_errors`
--
CREATE TABLE `smf_log_errors` (
`id_error` mediumint(8) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_errors`
--
INSERT INTO `smf_log_errors` (`id_error`, `log_time`, `id_member`, `ip`, `url`, `message`, `session`, `error_type`, `file`, `line`) VALUES
(1, 1461871652, 1, '', '?', '8: Undefined index: lang_character_set', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Load.php', 1738),
(2, 1461871652, 1, '', '?', '8: Undefined index: today', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 788),
(3, 1461871652, 1, '', '?', '8: Undefined index: lang_locale', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 797),
(4, 1461871652, 1, '', '?', '8: Undefined index: time_pm', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 802),
(5, 1461871652, 1, '', '?', '8: Undefined index: forum_index', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/BoardIndex.php', 115),
(6, 1461871652, 1, '', '?', '8: Undefined index: lang_locale', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 797),
(7, 1461871652, 1, '', '?', '8: Undefined index: time_pm', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 802),
(8, 1461871652, 1, '', '?', '8: Undefined index: code', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1086),
(9, 1461871652, 1, '', '?', '8: Undefined index: code_select', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1086),
(10, 1461871652, 1, '', '?', '8: Undefined index: code', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1128),
(11, 1461871652, 1, '', '?', '8: Undefined index: code_select', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1128),
(12, 1461871652, 1, '', '?', '8: Undefined index: quote', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1398),
(13, 1461871652, 1, '', '?', '8: Undefined index: quote_from', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1407),
(14, 1461871652, 1, '', '?', '8: Undefined index: quote_from', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1414),
(15, 1461871652, 1, '', '?', '8: Undefined index: quote_from', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1428),
(16, 1461871652, 1, '', '?', '8: Undefined index: search_on', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1428),
(17, 1461871652, 1, '', '?', '8: Undefined index: quote_from', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 1437),
(18, 1461871652, 1, '', '?', '8: Undefined index: icon_cheesy', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(19, 1461871652, 1, '', '?', '8: Undefined index: icon_rolleyes', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(20, 1461871652, 1, '', '?', '8: Undefined index: icon_angry', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(21, 1461871652, 1, '', '?', '8: Undefined index: icon_smiley', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(22, 1461871652, 1, '', '?', '8: Undefined index: icon_wink', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(23, 1461871652, 1, '', '?', '8: Undefined index: icon_grin', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(24, 1461871652, 1, '', '?', '8: Undefined index: icon_sad', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(25, 1461871652, 1, '', '?', '8: Undefined index: icon_shocked', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(26, 1461871652, 1, '', '?', '8: Undefined index: icon_cool', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(27, 1461871652, 1, '', '?', '8: Undefined index: icon_tongue', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(28, 1461871652, 1, '', '?', '8: Undefined index: icon_huh', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(29, 1461871652, 1, '', '?', '8: Undefined index: icon_embarrassed', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(30, 1461871652, 1, '', '?', '8: Undefined index: icon_lips', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(31, 1461871652, 1, '', '?', '8: Undefined index: icon_kiss', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(32, 1461871652, 1, '', '?', '8: Undefined index: icon_cry', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(33, 1461871652, 1, '', '?', '8: Undefined index: icon_undecided', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 2466),
(34, 1461871652, 1, '', '?', '8: Undefined index: home', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3923),
(35, 1461871652, 1, '', '?', '8: Undefined index: help', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3931),
(36, 1461871652, 1, '', '?', '8: Undefined index: search', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3938),
(37, 1461871652, 1, '', '?', '8: Undefined index: admin', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3945),
(38, 1461871652, 1, '', '?', '8: Undefined index: modSettings_title', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3950),
(39, 1461871652, 1, '', '?', '8: Undefined index: package', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3955),
(40, 1461871652, 1, '', '?', '8: Undefined index: errlog', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3960),
(41, 1461871652, 1, '', '?', '8: Undefined index: edit_permissions', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3965),
(42, 1461871652, 1, '', '?', '8: Undefined index: moderate', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3973),
(43, 1461871652, 1, '', '?', '8: Undefined index: modlog_view', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3978),
(44, 1461871652, 1, '', '?', '8: Undefined index: mc_unapproved_poststopics', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3983),
(45, 1461871652, 1, '', '?', '8: Undefined index: mc_unapproved_attachments', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3988),
(46, 1461871652, 1, '', '?', '8: Undefined index: mc_reported_posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 3993),
(47, 1461871652, 1, '', '?', '8: Undefined index: profile', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4001),
(48, 1461871652, 1, '', '?', '8: Undefined index: summary', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4006),
(49, 1461871652, 1, '', '?', '8: Undefined index: account', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4011),
(50, 1461871652, 1, '', '?', '8: Undefined index: forumprofile', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4016),
(51, 1461871652, 1, '', '?', '8: Undefined index: pm_short', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4024),
(52, 1461871652, 1, '', '?', '8: Undefined index: pm_menu_read', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4029),
(53, 1461871652, 1, '', '?', '8: Undefined index: pm_menu_send', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4034),
(54, 1461871652, 1, '', '?', '8: Undefined index: calendar', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4042),
(55, 1461871652, 1, '', '?', '8: Undefined index: calendar_menu', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4047),
(56, 1461871652, 1, '', '?', '8: Undefined index: calendar_post_event', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4052),
(57, 1461871652, 1, '', '?', '8: Undefined index: members_title', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4060),
(58, 1461871652, 1, '', '?', '8: Undefined index: mlist_menu_view', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4065),
(59, 1461871652, 1, '', '?', '8: Undefined index: mlist_search', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4070),
(60, 1461871652, 1, '', '?', '8: Undefined index: login', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4078),
(61, 1461871652, 1, '', '?', '8: Undefined index: register', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4085),
(62, 1461871652, 1, '', '?', '8: Undefined index: logout', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 4093),
(63, 1461871652, 1, '', '?', '8: Undefined index: ajax_in_progress', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (html_above sub template - eval?)', 119),
(64, 1461871652, 1, '', '?', '8: Undefined index: modify_cancel', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (html_above sub template - eval?)', 120),
(65, 1461871652, 1, '', '?', '8: Undefined index: rss', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (html_above sub template - eval?)', 148),
(66, 1461871652, 1, '', '?', '8: Undefined index: hello_member_ndt', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (body_above sub template - eval?)', 287),
(67, 1461871652, 1, '', '?', '8: Undefined index: view_unread_category', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 114),
(68, 1461871652, 1, '', '?', '8: Undefined index: new_posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 144),
(69, 1461871652, 1, '', '?', '8: Undefined index: in', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 185),
(70, 1461871652, 1, '', '?', '8: Undefined index: posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 191),
(71, 1461871652, 1, '', '?', '8: Undefined index: board_topics', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 192),
(72, 1461871652, 1, '', '?', '8: Undefined index: new_posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 250),
(73, 1461871652, 1, '', '?', '8: Undefined index: old_posts', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 251),
(74, 1461871652, 1, '', '?', '8: Undefined index: redirect_board', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 252),
(75, 1461871652, 1, '', '?', '8: Undefined index: mark_as_read', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 480),
(76, 1461871652, 1, '', '?', '8: Undefined index: upshrink_description', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 284),
(77, 1461871652, 1, '', '?', '8: Undefined index: info_center_title', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 285),
(78, 1461871652, 1, '', '?', '8: Undefined index: forum_stats', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 390),
(79, 1461871652, 1, '', '?', '8: Undefined index: forum_stats', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 391),
(80, 1461871652, 1, '', '?', '8: Undefined index: posts_made', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(81, 1461871652, 1, '', '?', '8: Undefined index: in', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(82, 1461871652, 1, '', '?', '8: Undefined index: topics', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(83, 1461871652, 1, '', '?', '8: Undefined index: by', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(84, 1461871652, 1, '', '?', '8: Undefined index: members', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(85, 1461871652, 1, '', '?', '8: Undefined index: latest_member', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 396),
(86, 1461871652, 1, '', '?', '8: Undefined index: latest_post', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 397),
(87, 1461871652, 1, '', '?', '8: Undefined index: recent_view', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 398),
(88, 1461871652, 1, '', '?', '8: Undefined index: more_stats', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 399),
(89, 1461871652, 1, '', '?', '8: Undefined index: online_users', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 408),
(90, 1461871652, 1, '', '?', '8: Undefined index: online_users', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 409),
(91, 1461871652, 1, '', '?', '8: Undefined index: guests', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 414),
(92, 1461871652, 1, '', '?', '8: Undefined index: user', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 414),
(93, 1461871652, 1, '', '?', '8: Undefined index: users_active', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 436),
(94, 1461871652, 1, '', '?', '8: Undefined index: most_online_today', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 447),
(95, 1461871652, 1, '', '?', '8: Undefined index: most_online_ever', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 448),
(96, 1461871652, 1, '', '?', '8: Undefined index: today', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 788),
(97, 1461871652, 1, '', '?', '8: Undefined index: lang_locale', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 797),
(98, 1461871652, 1, '', '?', '8: Undefined index: time_pm', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Sources/Subs.php', 802),
(99, 1461871652, 1, '', '?', '8: Undefined index: upshrink_description', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 489),
(100, 1461871652, 1, '', '?', '8: Undefined index: upshrink_description', 'c247e87e844ae4b88915aecff5f77c0f', 'undefined_vars', 'D:/xampp/htdocs/Themes/gearbox_20a/BoardIndex.template.php (main sub template - eval?)', 491),
(101, 1462012274, 1, '', '?action=topplayers', '2: require_once(D:\\xampp\\htdocs/Sources/TopPlayers.php): failed to open stream: No such file or directory', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 374),
(102, 1462012321, 1, '', '?action=banlist', '2: require_once(D:\\xampp\\htdocs/Sources/Banlist.php): failed to open stream: No such file or directory', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 375),
(103, 1462012323, 1, '', '?action=banlist', '2: require_once(D:\\xampp\\htdocs/Sources/Banlist.php): failed to open stream: No such file or directory', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 375),
(104, 1462012458, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(105, 1462012458, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(106, 1462012475, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(107, 1462012475, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(108, 1462012483, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(109, 1462012483, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(110, 1462012521, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(111, 1462012521, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(112, 1462012531, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(113, 1462012531, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(114, 1462012537, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(115, 1462012537, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(116, 1462012566, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(117, 1462012566, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(118, 1462012572, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(119, 1462012572, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(120, 1462012574, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(121, 1462012574, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(122, 1462012574, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(123, 1462012574, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(124, 1462012576, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(125, 1462012576, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(126, 1462014299, 1, '', '?action=banlist', '2: call_user_func() expects parameter 1 to be a valid callback, function ''Banlist'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(127, 1462014299, 1, '', '?action=banlist', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0),
(128, 1462014861, 1, '', '?action=topplayers', '2: call_user_func() expects parameter 1 to be a valid callback, function ''TopPlayers'' not found or invalid function name', '81b3f144d341b43c8fd19b1b254e3aa3', 'general', 'D:/xampp/htdocs/index.php', 162),
(129, 1462014861, 1, '', '?action=topplayers', 'Unable to load the ''main'' template.', '81b3f144d341b43c8fd19b1b254e3aa3', 'template', '', 0);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_floodcontrol`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_floodcontrol`
--
INSERT INTO `smf_log_floodcontrol` (`ip`, `log_time`, `log_type`) VALUES
('', 1462012078, 'login'),
('', 1461872863, 'search'),
('', 1461876534, 'spsbp');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_group_requests`
--
CREATE TABLE `smf_log_group_requests` (
`id_request` mediumint(8) UNSIGNED NOT NULL,
`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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_karma`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_mark_read`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_member_notices`
--
CREATE TABLE `smf_log_member_notices` (
`id_notice` mediumint(8) UNSIGNED NOT NULL,
`subject` varchar(255) NOT NULL DEFAULT '',
`body` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_notify`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_online`
--
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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_online`
--
INSERT INTO `smf_log_online` (`session`, `log_time`, `id_member`, `id_spider`, `ip`, `url`) VALUES
('ip', 1462115180, 0, 0, 0, 'a:1:{s:10:"USER_AGENT";s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";}');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_packages`
--
CREATE TABLE `smf_log_packages` (
`id_install` int(10) NOT NULL,
`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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_packages`
--
INSERT INTO `smf_log_packages` (`id_install`, `filename`, `package_id`, `name`, `version`, `id_member_installed`, `member_installed`, `time_installed`, `id_member_removed`, `member_removed`, `time_removed`, `install_state`, `failed_steps`, `themes_installed`, `db_changes`) VALUES
(1, 'SimplePortal_2.3.6.zip', '[SiNaN]:SimplePortal', 'SimplePortal', '2.3.6', 1, 'admin', 1461876158, 1, 'admin', 1461876257, 0, 'a:0:{}', '1', 'a:8:{i:0;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_parameters";}i:1;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_shoutboxes";}i:2;a:2:{i:0;s:12:"remove_table";i:1;s:13:"smf_sp_shouts";}i:3;a:2:{i:0;s:12:"remove_table";i:1;s:12:"smf_sp_pages";}i:4;a:2:{i:0;s:12:"remove_table";i:1;s:16:"smf_sp_functions";}i:5;a:2:{i:0;s:12:"remove_table";i:1;s:13:"smf_sp_blocks";}i:6;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_categories";}i:7;a:2:{i:0;s:12:"remove_table";i:1;s:15:"smf_sp_articles";}}'),
(2, 'SimplePortal_2.3.6.zip', '[SiNaN]:SimplePortal', 'SimplePortal', '2.3.6', 1, 'admin', 1461876271, 0, '0', 0, 1, 'a:0:{}', '1,3', 'a:8:{i:0;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_parameters";}i:1;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_shoutboxes";}i:2;a:2:{i:0;s:12:"remove_table";i:1;s:13:"smf_sp_shouts";}i:3;a:2:{i:0;s:12:"remove_table";i:1;s:12:"smf_sp_pages";}i:4;a:2:{i:0;s:12:"remove_table";i:1;s:16:"smf_sp_functions";}i:5;a:2:{i:0;s:12:"remove_table";i:1;s:13:"smf_sp_blocks";}i:6;a:2:{i:0;s:12:"remove_table";i:1;s:17:"smf_sp_categories";}i:7;a:2:{i:0;s:12:"remove_table";i:1;s:15:"smf_sp_articles";}}');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_polls`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_reported`
--
CREATE TABLE `smf_log_reported` (
`id_report` mediumint(8) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_reported_comments`
--
CREATE TABLE `smf_log_reported_comments` (
`id_comment` mediumint(8) UNSIGNED NOT NULL,
`id_report` mediumint(8) NOT NULL DEFAULT '0',
`id_member` mediumint(8) NOT NULL,
`membername` varchar(255) NOT NULL DEFAULT '',
`email_address` varchar(255) NOT NULL DEFAULT '',
`member_ip` varchar(255) NOT NULL DEFAULT '',
`comment` varchar(255) NOT NULL DEFAULT '',
`time_sent` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_scheduled_tasks`
--
CREATE TABLE `smf_log_scheduled_tasks` (
`id_log` mediumint(8) NOT NULL,
`id_task` smallint(5) NOT NULL DEFAULT '0',
`time_run` int(10) NOT NULL DEFAULT '0',
`time_taken` float NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_scheduled_tasks`
--
INSERT INTO `smf_log_scheduled_tasks` (`id_log`, `id_task`, `time_run`, `time_taken`) VALUES
(1, 2, 1461870684, 0),
(2, 3, 1461870739, 0),
(3, 5, 1461870924, 0),
(4, 6, 1461870934, 0),
(5, 7, 1461870940, 3),
(6, 9, 1461870942, 0),
(7, 1, 1462012044, 0),
(8, 5, 1462012064, 0),
(9, 3, 1462012078, 0),
(10, 7, 1462012084, 2),
(11, 1, 1462019245, 0),
(12, 1, 1462115181, 0);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_search_messages`
--
CREATE TABLE `smf_log_search_messages` (
`id_search` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`id_msg` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_search_results`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_search_results`
--
INSERT INTO `smf_log_search_results` (`id_search`, `id_topic`, `id_msg`, `relevance`, `num_matches`) VALUES
(1, 1, 1, 650, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_search_subjects`
--
CREATE TABLE `smf_log_search_subjects` (
`word` varchar(20) NOT NULL DEFAULT '',
`id_topic` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_log_search_subjects`
--
INSERT INTO `smf_log_search_subjects` (`word`, `id_topic`) VALUES
('smf', 1),
('to', 1),
('welcome', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_search_topics`
--
CREATE TABLE `smf_log_search_topics` (
`id_search` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`id_topic` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_spider_hits`
--
CREATE TABLE `smf_log_spider_hits` (
`id_hit` int(10) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_spider_stats`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_subscribed`
--
CREATE TABLE `smf_log_subscribed` (
`id_sublog` int(10) UNSIGNED NOT NULL,
`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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_log_topics`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_mail_queue`
--
CREATE TABLE `smf_mail_queue` (
`id_mail` int(10) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_membergroups`
--
CREATE TABLE `smf_membergroups` (
`id_group` smallint(5) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_membergroups`
--
INSERT INTO `smf_membergroups` (`id_group`, `group_name`, `description`, `online_color`, `min_posts`, `max_messages`, `stars`, `group_type`, `hidden`, `id_parent`) VALUES
(1, 'Administrator', '', '#FF0000', -1, 0, '5#staradmin.gif', 1, 0, -2),
(2, 'Global Moderator', '', '#0000FF', -1, 0, '5#stargmod.gif', 0, 0, -2),
(3, 'Moderator', '', '', -1, 0, '5#starmod.gif', 0, 0, -2),
(4, 'Newbie', '', '', 0, 0, '1#star.gif', 0, 0, -2),
(5, 'Jr. Member', '', '', 50, 0, '2#star.gif', 0, 0, -2),
(6, 'Full Member', '', '', 100, 0, '3#star.gif', 0, 0, -2),
(7, 'Sr. Member', '', '', 250, 0, '4#star.gif', 0, 0, -2),
(8, 'Hero Member', '', '', 500, 0, '5#star.gif', 0, 0, -2);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_members`
--
CREATE TABLE `smf_members` (
`id_member` mediumint(8) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_members`
--
INSERT INTO `smf_members` (`id_member`, `member_name`, `date_registered`, `posts`, `id_group`, `lngfile`, `last_login`, `real_name`, `instant_messages`, `unread_messages`, `new_pm`, `buddy_list`, `pm_ignore_list`, `pm_prefs`, `mod_prefs`, `message_labels`, `passwd`, `openid_uri`, `email_address`, `personal_text`, `gender`, `birthdate`, `website_title`, `website_url`, `location`, `icq`, `aim`, `yim`, `msn`, `hide_email`, `show_online`, `time_format`, `signature`, `time_offset`, `avatar`, `pm_email_notify`, `karma_bad`, `karma_good`, `usertitle`, `notify_announcements`, `notify_regularity`, `notify_send_body`, `notify_types`, `member_ip`, `member_ip2`, `secret_question`, `secret_answer`, `id_theme`, `is_activated`, `validation_code`, `id_msg_last_visit`, `additional_groups`, `smiley_set`, `id_post_group`, `total_time_logged_in`, `password_salt`, `ignore_boards`, `warning`, `passwd_flood`, `pm_receive_from`) VALUES
(1, 'admin', 1461870586, 0, 1, '', 1462014901, 'admin', 0, 0, 0, '', '', 0, '', '', '1e496d95637d527c76d2a362dae3873097a110aa', '', 'reinier.dorst1@hotmail.com', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 0, '', 0, 0, 0, '', 1, 1, 0, 2, '', '', '', '', 0, 1, '', 1, '', '', 0, 7276, 'd908', '', 0, '', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_messages`
--
CREATE TABLE `smf_messages` (
`id_msg` int(10) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_messages`
--
INSERT INTO `smf_messages` (`id_msg`, `id_topic`, `id_board`, `poster_time`, `id_member`, `id_msg_modified`, `subject`, `poster_name`, `poster_email`, `poster_ip`, `smileys_enabled`, `modified_time`, `modified_name`, `body`, `icon`, `approved`) VALUES
(1, 1, 1, 1461870549, 0, 1, 'Welcome to SMF!', 'Simple Machines', 'info@simplemachines.org', '127.0.0.1', 1, 0, '', 'Welcome to Simple Machines Forum!
We hope you enjoy using your forum. If you have any problems, please feel free to [url=http://www.simplemachines.org/community/index.php]ask us for assistance[/url].
Thanks!
Simple Machines', 'xx', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_message_icons`
--
CREATE TABLE `smf_message_icons` (
`id_icon` smallint(5) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_message_icons`
--
INSERT INTO `smf_message_icons` (`id_icon`, `title`, `filename`, `id_board`, `icon_order`) VALUES
(1, 'Standard', 'xx', 0, 0),
(2, 'Thumb Up', 'thumbup', 0, 1),
(3, 'Thumb Down', 'thumbdown', 0, 2),
(4, 'Exclamation point', 'exclamation', 0, 3),
(5, 'Question mark', 'question', 0, 4),
(6, 'Lamp', 'lamp', 0, 5),
(7, 'Smiley', 'smiley', 0, 6),
(8, 'Angry', 'angry', 0, 7),
(9, 'Cheesy', 'cheesy', 0, 8),
(10, 'Grin', 'grin', 0, 9),
(11, 'Sad', 'sad', 0, 10),
(12, 'Wink', 'wink', 0, 11);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_moderators`
--
CREATE TABLE `smf_moderators` (
`id_board` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`id_member` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_openid_assoc`
--
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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_package_servers`
--
CREATE TABLE `smf_package_servers` (
`id_server` smallint(5) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_package_servers`
--
INSERT INTO `smf_package_servers` (`id_server`, `name`, `url`) VALUES
(1, 'Simple Machines Third-party Mod Site', 'http://custom.simplemachines.org/packages/mods');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_permissions`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_permissions`
--
INSERT INTO `smf_permissions` (`id_group`, `permission`, `add_deny`) VALUES
(-1, 'search_posts', 1),
(-1, 'calendar_view', 1),
(-1, 'view_stats', 1),
(-1, 'profile_view_any', 1),
(0, 'view_mlist', 1),
(0, 'search_posts', 1),
(0, 'profile_view_own', 1),
(0, 'profile_view_any', 1),
(0, 'pm_read', 1),
(0, 'pm_send', 1),
(0, 'calendar_view', 1),
(0, 'view_stats', 1),
(0, 'who_view', 1),
(0, 'profile_identity_own', 1),
(0, 'profile_extra_own', 1),
(0, 'profile_remove_own', 1),
(0, 'profile_server_avatar', 1),
(0, 'profile_upload_avatar', 1),
(0, 'profile_remote_avatar', 1),
(0, 'karma_edit', 1),
(2, 'view_mlist', 1),
(2, 'search_posts', 1),
(2, 'profile_view_own', 1),
(2, 'profile_view_any', 1),
(2, 'pm_read', 1),
(2, 'pm_send', 1),
(2, 'calendar_view', 1),
(2, 'view_stats', 1),
(2, 'who_view', 1),
(2, 'profile_identity_own', 1),
(2, 'profile_extra_own', 1),
(2, 'profile_remove_own', 1),
(2, 'profile_server_avatar', 1),
(2, 'profile_upload_avatar', 1),
(2, 'profile_remote_avatar', 1),
(2, 'profile_title_own', 1),
(2, 'calendar_post', 1),
(2, 'calendar_edit_any', 1),
(2, 'karma_edit', 1),
(2, 'access_mod_center', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_permission_profiles`
--
CREATE TABLE `smf_permission_profiles` (
`id_profile` smallint(5) NOT NULL,
`profile_name` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_permission_profiles`
--
INSERT INTO `smf_permission_profiles` (`id_profile`, `profile_name`) VALUES
(1, 'default'),
(2, 'no_polls'),
(3, 'reply_only'),
(4, 'read_only');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_personal_messages`
--
CREATE TABLE `smf_personal_messages` (
`id_pm` int(10) UNSIGNED NOT NULL,
`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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_pm_recipients`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_pm_rules`
--
CREATE TABLE `smf_pm_rules` (
`id_rule` int(10) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_polls`
--
CREATE TABLE `smf_polls` (
`id_poll` mediumint(8) UNSIGNED NOT NULL,
`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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_poll_choices`
--
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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_scheduled_tasks`
--
CREATE TABLE `smf_scheduled_tasks` (
`id_task` smallint(5) NOT NULL,
`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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_scheduled_tasks`
--
INSERT INTO `smf_scheduled_tasks` (`id_task`, `next_time`, `time_offset`, `time_regularity`, `time_unit`, `disabled`, `task`) VALUES
(1, 1462125600, 0, 2, 'h', 0, 'approval_notification'),
(2, 1462406400, 0, 7, 'd', 0, 'auto_optimize'),
(3, 1462060860, 60, 1, 'd', 0, 'daily_maintenance'),
(5, 1462060800, 0, 1, 'd', 0, 'daily_digest'),
(6, 1462406400, 0, 1, 'w', 0, 'weekly_digest'),
(7, 1462062720, 88333, 1, 'd', 0, 'fetchSMfiles'),
(8, 0, 0, 1, 'd', 1, 'birthdayemails'),
(9, 1462406400, 0, 1, 'w', 0, 'weekly_maintenance'),
(10, 0, 120, 1, 'd', 1, 'paid_subscriptions');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sessions`
--
CREATE TABLE `smf_sessions` (
`session_id` char(32) NOT NULL,
`last_update` int(10) UNSIGNED NOT NULL,
`data` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_sessions`
--
INSERT INTO `smf_sessions` (`session_id`, `last_update`, `data`) VALUES
('ui9a3moe6gncdt3b14dqq3rou3', 1461870586, 'USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";admin_time|i:1461870586;'),
('bqv8buesk23e3pmgbfi51p8r11', 1461879305, 'session_value|s:32:"94f10b0c80d4ed15c246f44fb84fb32d";session_var|s:10:"af192ee9f2";mc|a:7:{s:4:"time";i:1461878624;s:2:"id";s:1:"1";s:2:"gq";s:3:"1=1";s:2:"bq";s:3:"1=1";s:2:"ap";a:1:{i:0;i:0;}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}ban|a:5:{s:12:"last_checked";i:1461878624;s:9:"id_member";i:0;s:2:"ip";s:0:"";s:3:"ip2";s:0:"";s:5:"email";s:0:"";}log_time|i:1461879305;timeOnlineUpdated|i:1461879305;old_url|s:39:"http://localhost/index.php?action=forum";USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";login_SMFCookie956|s:95:"a:4:{i:0;s:1:"1";i:1;s:40:"a891bdc453931df91a819605d55c5197d94e220e";i:2;i:1461882224;i:3;i:2;}";admin_time|i:1461878624;id_msg_last_visit|s:1:"1";rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1461878624;s:7:"reports";s:1:"0";}unread_messages|i:0;'),
('amks3auakl0ugk1k7g10elt6u7', 1462015686, 'session_value|s:32:"81b3f144d341b43c8fd19b1b254e3aa3";session_var|s:10:"fb760256ae";mc|a:7:{s:4:"time";i:1462015685;s:2:"id";i:0;s:2:"gq";s:3:"0=1";s:2:"bq";s:3:"0=1";s:2:"ap";a:0:{}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}ban|a:5:{s:12:"last_checked";i:1462015686;s:9:"id_member";i:0;s:2:"ip";s:0:"";s:3:"ip2";s:0:"";s:5:"email";s:0:"";}log_time|i:1462015685;timeOnlineUpdated|i:1462014901;old_url|s:39:"http://localhost/index.php?action=forum";USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";login_SMFCookie956|s:95:"a:4:{i:0;s:1:"1";i:1;s:40:"a891bdc453931df91a819605d55c5197d94e220e";i:2;i:1462015678;i:3;i:2;}";admin_time|i:1462012078;id_msg_last_visit|s:1:"1";rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1462012078;s:7:"reports";s:1:"0";}unread_messages|i:0;'),
('g6g4e47ac2pq2d2icumn4r60o6', 1462019315, 'session_value|s:32:"b881e8a068acae3fa5f07c7c7d358912";session_var|s:12:"c0bdf59bbade";mc|a:7:{s:4:"time";i:1462019245;s:2:"id";i:0;s:2:"gq";s:3:"0=1";s:2:"bq";s:3:"0=1";s:2:"ap";a:0:{}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}ban|a:5:{s:12:"last_checked";i:1462019315;s:9:"id_member";i:0;s:2:"ip";s:0:"";s:3:"ip2";s:0:"";s:5:"email";s:0:"";}log_time|i:1462019314;timeOnlineUpdated|i:1462019245;old_url|s:26:"http://localhost/index.php";USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";'),
('fmmog9t570cdkpci180mmo4um4', 1462117581, 'session_value|s:32:"6c9781c1115e9371ac74f2a4c7e68a88";session_var|s:9:"b3cf22060";mc|a:7:{s:4:"time";i:1462115180;s:2:"id";i:0;s:2:"gq";s:3:"0=1";s:2:"bq";s:3:"0=1";s:2:"ap";a:0:{}s:2:"mb";a:0:{}s:2:"mq";s:3:"0=1";}ban|a:5:{s:12:"last_checked";i:1462115180;s:9:"id_member";i:0;s:2:"ip";s:0:"";s:3:"ip2";s:0:"";s:5:"email";s:0:"";}log_time|i:1462115180;timeOnlineUpdated|i:1462115180;old_url|s:26:"http://localhost/index.php";USER_AGENT|s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.87 Safari/537.36";');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_settings`
--
CREATE TABLE `smf_settings` (
`variable` varchar(255) NOT NULL DEFAULT '',
`value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_settings`
--
INSERT INTO `smf_settings` (`variable`, `value`) VALUES
('smfVersion', '2.0.11'),
('news', 'SMF - Just Installed!'),
('compactTopicPagesContiguous', '5'),
('compactTopicPagesEnable', '1'),
('enableStickyTopics', '1'),
('todayMod', '1'),
('karmaMode', '0'),
('karmaTimeRestrictAdmins', '1'),
('enablePreviousNext', '1'),
('pollMode', '1'),
('enableVBStyleLogin', '1'),
('enableCompressedOutput', '1'),
('karmaWaitTime', '1'),
('karmaMinPosts', '0'),
('karmaLabel', 'Karma:'),
('karmaSmiteLabel', '[smite]'),
('karmaApplaudLabel', '[applaud]'),
('attachmentSizeLimit', '128'),
('attachmentPostLimit', '192'),
('attachmentNumPerPostLimit', '4'),
('attachmentDirSizeLimit', '10240'),
('attachmentUploadDir', 'D:\\xampp\\htdocs/attachments'),
('attachmentExtensions', 'doc,gif,jpg,mpg,pdf,png,txt,zip'),
('attachmentCheckExtensions', '0'),
('attachmentShowImages', '1'),
('attachmentEnable', '1'),
('attachmentEncryptFilenames', '1'),
('attachmentThumbnails', '1'),
('attachmentThumbWidth', '150'),
('attachmentThumbHeight', '150'),
('censorIgnoreCase', '1'),
('mostOnline', '2'),
('mostOnlineToday', '2'),
('mostDate', '1462015686'),
('allow_disableAnnounce', '1'),
('trackStats', '1'),
('userLanguage', '1'),
('titlesEnable', '1'),
('topicSummaryPosts', '15'),
('enableErrorLogging', '1'),
('max_image_width', '0'),
('max_image_height', '0'),
('onlineEnable', '0'),
('cal_enabled', '0'),
('cal_maxyear', '2020'),
('cal_minyear', '2008'),
('cal_daysaslink', '0'),
('cal_defaultboard', ''),
('cal_showholidays', '1'),
('cal_showbdays', '1'),
('cal_showevents', '1'),
('cal_showweeknum', '0'),
('cal_maxspan', '7'),
('smtp_host', ''),
('smtp_port', '25'),
('smtp_username', ''),
('smtp_password', ''),
('mail_type', '0'),
('timeLoadPageEnable', '0'),
('totalMembers', '1'),
('totalTopics', '1'),
('totalMessages', '1'),
('simpleSearch', '0'),
('censor_vulgar', ''),
('censor_proper', ''),
('enablePostHTML', '0'),
('theme_allow', '1'),
('theme_default', '1'),
('theme_guests', '3'),
('enableEmbeddedFlash', '0'),
('xmlnews_enable', '1'),
('xmlnews_maxlen', '255'),
('hotTopicPosts', '15'),
('hotTopicVeryPosts', '25'),
('registration_method', '0'),
('send_validation_onChange', '0'),
('send_welcomeEmail', '1'),
('allow_editDisplayName', '1'),
('allow_hideOnline', '1'),
('guest_hideContacts', '1'),
('spamWaitTime', '5'),
('pm_spam_settings', '10,5,20'),
('reserveWord', '0'),
('reserveCase', '1'),
('reserveUser', '1'),
('reserveName', '1'),
('reserveNames', 'Admin\nWebmaster\nGuest\nroot'),
('autoLinkUrls', '1'),
('banLastUpdated', '0'),
('smileys_dir', 'D:\\xampp\\htdocs/Smileys'),
('smileys_url', 'http://localhost/Smileys'),
('avatar_directory', 'D:\\xampp\\htdocs/avatars'),
('avatar_url', 'http://localhost/avatars'),
('avatar_max_height_external', '65'),
('avatar_max_width_external', '65'),
('avatar_action_too_large', 'option_html_resize'),
('avatar_max_height_upload', '65'),
('avatar_max_width_upload', '65'),
('avatar_resize_upload', '1'),
('avatar_download_png', '1'),
('failed_login_threshold', '3'),
('oldTopicDays', '120'),
('edit_wait_time', '90'),
('edit_disable_time', '0'),
('autoFixDatabase', '1'),
('allow_guestAccess', '1'),
('time_format', '%B %d, %Y, %I:%M:%S %p'),
('number_format', '1234.00'),
('enableBBC', '1'),
('max_messageLength', '20000'),
('signature_settings', '1,300,0,0,0,0,0,0:'),
('autoOptMaxOnline', '0'),
('defaultMaxMessages', '15'),
('defaultMaxTopics', '20'),
('defaultMaxMembers', '30'),
('enableParticipation', '1'),
('recycle_enable', '0'),
('recycle_board', '0'),
('maxMsgID', '1'),
('enableAllMessages', '0'),
('fixLongWords', '0'),
('knownThemes', '1,2,3'),
('who_enabled', '1'),
('time_offset', '0'),
('cookieTime', '60'),
('lastActive', '15'),
('smiley_sets_known', 'default,aaron,akyhne'),
('smiley_sets_names', 'Alienine''s Set\nAaron''s Set\nAkyhne''s Set'),
('smiley_sets_default', 'default'),
('cal_days_for_index', '7'),
('requireAgreement', '1'),
('unapprovedMembers', '0'),
('default_personal_text', ''),
('package_make_backups', '1'),
('databaseSession_enable', '1'),
('databaseSession_loose', '1'),
('databaseSession_lifetime', '2880'),
('search_cache_size', '50'),
('search_results_per_page', '30'),
('search_weight_frequency', '30'),
('search_weight_age', '25'),
('search_weight_length', '20'),
('search_weight_subject', '15'),
('search_weight_first_message', '10'),
('search_max_results', '1200'),
('search_floodcontrol_time', '5'),
('permission_enable_deny', '0'),
('permission_enable_postgroups', '0'),
('mail_next_send', '0'),
('mail_recent', '0000000000|0'),
('settings_updated', '1461877122'),
('next_task_time', '1462060800'),
('warning_settings', '1,20,0'),
('warning_watch', '10'),
('warning_moderate', '35'),
('warning_mute', '60'),
('admin_features', ''),
('last_mod_report_action', '0'),
('pruningOptions', '30,180,180,180,30,0'),
('cache_enable', '1'),
('reg_verification', '1'),
('visual_verification_type', '3'),
('enable_buddylist', '1'),
('birthday_email', 'happy_birthday'),
('dont_repeat_theme_core', '1'),
('dont_repeat_smileys_20', '1'),
('dont_repeat_buddylists', '1'),
('attachment_image_reencode', '1'),
('attachment_image_paranoid', '0'),
('attachment_thumb_png', '1'),
('avatar_reencode', '1'),
('avatar_paranoid', '0'),
('globalCookies', '1'),
('default_timezone', 'Etc/GMT-1'),
('memberlist_updated', '1461870656'),
('latestMember', '1'),
('latestRealName', 'admin'),
('rand_seed', '1677321675'),
('mostOnlineUpdated', '2016-04-30'),
('search_pointer', '1'),
('sp_version', '2.3.6'),
('sp_smf_version', '2'),
('sp_portal_mode', '1'),
('sp_disableForumRedirect', '1'),
('showleft', '1'),
('showright', '1'),
('leftwidth', '200'),
('rightwidth', '200'),
('sp_enableIntegration', '1'),
('sp_adminIntegrationHide', '1'),
('sp_resize_images', '1'),
('calendar_updated', '1461877122');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_smileys`
--
CREATE TABLE `smf_smileys` (
`id_smiley` smallint(5) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_smileys`
--
INSERT INTO `smf_smileys` (`id_smiley`, `code`, `filename`, `description`, `smiley_row`, `smiley_order`, `hidden`) VALUES
(1, ':)', 'smiley.gif', 'Smiley', 0, 0, 0),
(2, ';)', 'wink.gif', 'Wink', 0, 1, 0),
(3, ':D', 'cheesy.gif', 'Cheesy', 0, 2, 0),
(4, ';D', 'grin.gif', 'Grin', 0, 3, 0),
(5, '>:(', 'angry.gif', 'Angry', 0, 4, 0),
(6, ':(', 'sad.gif', 'Sad', 0, 5, 0),
(7, ':o', 'shocked.gif', 'Shocked', 0, 6, 0),
(8, '8)', 'cool.gif', 'Cool', 0, 7, 0),
(9, '???', 'huh.gif', 'Huh?', 0, 8, 0),
(10, '::)', 'rolleyes.gif', 'Roll Eyes', 0, 9, 0),
(11, ':P', 'tongue.gif', 'Tongue', 0, 10, 0),
(12, ':-[', 'embarrassed.gif', 'Embarrassed', 0, 11, 0),
(13, ':-X', 'lipsrsealed.gif', 'Lips Sealed', 0, 12, 0),
(14, ':-\\', 'undecided.gif', 'Undecided', 0, 13, 0),
(15, ':-*', 'kiss.gif', 'Kiss', 0, 14, 0),
(16, ':''(', 'cry.gif', 'Cry', 0, 15, 0),
(17, '>:D', 'evil.gif', 'Evil', 0, 16, 1),
(18, '^-^', 'azn.gif', 'Azn', 0, 17, 1),
(19, 'O0', 'afro.gif', 'Afro', 0, 18, 1),
(20, ':))', 'laugh.gif', 'Laugh', 0, 19, 1),
(21, 'C:-)', 'police.gif', 'Police', 0, 20, 1),
(22, 'O:-)', 'angel.gif', 'Angel', 0, 21, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_spiders`
--
CREATE TABLE `smf_spiders` (
`id_spider` smallint(5) UNSIGNED NOT NULL,
`spider_name` varchar(255) NOT NULL DEFAULT '',
`user_agent` varchar(255) NOT NULL DEFAULT '',
`ip_info` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_spiders`
--
INSERT INTO `smf_spiders` (`id_spider`, `spider_name`, `user_agent`, `ip_info`) VALUES
(1, 'Google', 'googlebot', ''),
(2, 'Yahoo!', 'slurp', ''),
(3, 'MSN', 'msnbot', ''),
(4, 'Google (Mobile)', 'Googlebot-Mobile', ''),
(5, 'Google (Image)', 'Googlebot-Image', ''),
(6, 'Google (AdSense)', 'Mediapartners-Google', ''),
(7, 'Google (Adwords)', 'AdsBot-Google', ''),
(8, 'Yahoo! (Mobile)', 'YahooSeeker/M1A1-R2D2', ''),
(9, 'Yahoo! (Image)', 'Yahoo-MMCrawler', ''),
(10, 'MSN (Mobile)', 'MSNBOT_Mobile', ''),
(11, 'MSN (Media)', 'msnbot-media', ''),
(12, 'Cuil', 'twiceler', ''),
(13, 'Ask', 'Teoma', ''),
(14, 'Baidu', 'Baiduspider', ''),
(15, 'Gigablast', 'Gigabot', ''),
(16, 'InternetArchive', 'ia_archiver-web.archive.org', ''),
(17, 'Alexa', 'ia_archiver', ''),
(18, 'Omgili', 'omgilibot', ''),
(19, 'EntireWeb', 'Speedy Spider', '');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sp_articles`
--
CREATE TABLE `smf_sp_articles` (
`id_article` int(10) NOT NULL,
`id_category` int(10) NOT NULL DEFAULT '0',
`id_message` int(10) NOT NULL DEFAULT '0',
`approved` tinyint(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sp_blocks`
--
CREATE TABLE `smf_sp_blocks` (
`id_block` int(10) NOT NULL,
`label` tinytext NOT NULL,
`type` text NOT NULL,
`col` tinyint(4) NOT NULL DEFAULT '0',
`row` tinyint(4) NOT NULL DEFAULT '0',
`permission_set` tinyint(4) NOT NULL DEFAULT '0',
`groups_allowed` varchar(255) NOT NULL DEFAULT '',
`groups_denied` varchar(255) NOT NULL DEFAULT '',
`state` tinyint(4) NOT NULL DEFAULT '1',
`force_view` tinyint(2) NOT NULL DEFAULT '0',
`display` text NOT NULL,
`display_custom` text NOT NULL,
`style` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_sp_blocks`
--
INSERT INTO `smf_sp_blocks` (`id_block`, `label`, `type`, `col`, `row`, `permission_set`, `groups_allowed`, `groups_denied`, `state`, `force_view`, `display`, `display_custom`, `style`) VALUES
(1, 'User Info', 'sp_userInfo', 1, 1, 3, '', '', 1, 0, '', '', ''),
(2, 'Who's Online', 'sp_whosOnline', 1, 2, 3, '', '', 1, 0, '', '', ''),
(3, 'Board Stats', 'sp_boardStats', 1, 3, 3, '', '', 1, 0, '', '', ''),
(4, 'Theme Select', 'sp_theme_select', 1, 4, 3, '', '', 1, 0, '', '', ''),
(5, 'Search', 'sp_quickSearch', 1, 5, 3, '', '', 1, 0, '', '', ''),
(6, 'News', 'sp_news', 2, 1, 3, '', '', 1, 0, '', '', 'title_default_class~|title_custom_class~|title_custom_style~|body_default_class~windowbg|body_custom_class~|body_custom_style~|no_title~1|no_body~'),
(7, 'Welcome', 'sp_html', 2, 2, 3, '', '', 1, 0, '', '', 'title_default_class~|title_custom_class~|title_custom_style~|body_default_class~windowbg|body_custom_class~|body_custom_style~|no_title~1|no_body~'),
(8, 'Board News', 'sp_boardNews', 2, 3, 3, '', '', 1, 0, '', '', ''),
(9, 'Recent Topics', 'sp_recent', 3, 1, 3, '', '', 1, 0, '', '', ''),
(10, 'Top Poster', 'sp_topPoster', 4, 1, 3, '', '', 1, 0, '', '', ''),
(11, 'Recent Posts', 'sp_recent', 4, 2, 3, '', '', 1, 0, '', '', ''),
(12, 'Forum Staff', 'sp_staff', 4, 3, 3, '', '', 1, 0, '', '', ''),
(13, 'Calendar', 'sp_calendar', 4, 4, 3, '', '', 1, 0, '', '', ''),
(14, 'Top Boards', 'sp_topBoards', 4, 5, 3, '', '', 1, 0, '', '', '');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sp_categories`
--
CREATE TABLE `smf_sp_categories` (
`id_category` int(10) NOT NULL,
`name` tinytext NOT NULL,
`picture` tinytext NOT NULL,
`articles` tinyint(4) NOT NULL DEFAULT '0',
`publish` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sp_functions`
--
CREATE TABLE `smf_sp_functions` (
`id_function` tinyint(4) NOT NULL,
`function_order` tinyint(4) NOT NULL DEFAULT '0',
`name` tinytext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_sp_functions`
--
INSERT INTO `smf_sp_functions` (`id_function`, `function_order`, `name`) VALUES
(1, 1, 'sp_userInfo'),
(2, 2, 'sp_latestMember'),
(3, 3, 'sp_whosOnline'),
(5, 4, 'sp_boardStats'),
(7, 5, 'sp_topPoster'),
(35, 6, 'sp_topStatsMember'),
(23, 7, 'sp_recent'),
(9, 8, 'sp_topTopics'),
(8, 9, 'sp_topBoards'),
(4, 10, 'sp_showPoll'),
(12, 11, 'sp_boardNews'),
(6, 12, 'sp_quickSearch'),
(13, 13, 'sp_news'),
(20, 14, 'sp_attachmentImage'),
(21, 15, 'sp_attachmentRecent'),
(27, 16, 'sp_calendar'),
(24, 17, 'sp_calendarInformation'),
(25, 18, 'sp_rssFeed'),
(28, 19, 'sp_theme_select'),
(29, 20, 'sp_staff'),
(31, 21, 'sp_articles'),
(36, 22, 'sp_shoutbox'),
(26, 23, 'sp_gallery'),
(32, 24, 'sp_arcade'),
(33, 25, 'sp_shop'),
(30, 26, 'sp_blog'),
(10, 27, 'sp_menu'),
(19, 98, 'sp_bbc'),
(17, 99, 'sp_html'),
(18, 100, 'sp_php');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sp_pages`
--
CREATE TABLE `smf_sp_pages` (
`id_page` int(10) NOT NULL,
`namespace` tinytext NOT NULL,
`title` tinytext NOT NULL,
`body` mediumtext NOT NULL,
`type` tinytext NOT NULL,
`permission_set` tinyint(4) NOT NULL DEFAULT '0',
`groups_allowed` varchar(255) NOT NULL DEFAULT '',
`groups_denied` varchar(255) NOT NULL DEFAULT '',
`views` int(10) NOT NULL DEFAULT '0',
`style` text NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sp_parameters`
--
CREATE TABLE `smf_sp_parameters` (
`id_block` int(10) NOT NULL DEFAULT '0',
`variable` varchar(255) NOT NULL DEFAULT '',
`value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_sp_parameters`
--
INSERT INTO `smf_sp_parameters` (`id_block`, `variable`, `value`) VALUES
(7, 'content', '<h2 style="text-align: center;">Welcome to SimplePortal!</h2>\n<p>SimplePortal is one of several portal mods for Simple Machines Forum (SMF). Although always developing, SimplePortal is produced with the user in mind first. User feedback is the number one method of growth for SimplePortal, and our users are always finding ways for SimplePortal to grow. SimplePortal stays competative with other portal software by adding numerous user-requested features such as articles, block types and the ability to completely customize the portal page.</p>\n<p>All this and SimplePortal has remained Simple! SimplePortal is built for simplicity and ease of use; ensuring the average forum administrator can install SimplePortal, configure a few settings, and show off the brand new portal to the users in minutes. Confusing menus, undesired pre-loaded blocks and settings that cannot be found are all avoided as much as possible. Because when it comes down to it, SimplePortal is YOUR portal, and should reflect your taste as much as possible.</p>\n<p><strong>Ultimate Simplicity</strong>\n<br />\nThe simplest portal you can ever think of... You only need a few clicks to install it through Package Manager. A few more to create your own blocks and articles. Your portal is ready to go within a couple of minutes, and simple to customise to reflect YOU.</p>\n<p><strong>Install Friendly</strong>\n<br />\nWith the ingenius design of install and update packages, SimplePortal is incredibly install and update friendly. You will never need any manual changes even on a heavily modified forum.</p>\n<p><strong>Incredible Theme Support</strong>\n<br />\nThe simple but powerful structure of SimplePortal brings you wide-range theme support too. You can use SimplePortal with all SMF themes by just adding a button for it.</p>\n<p><strong>Professional Support</strong>\n<br />\nSimplePortal offers high quality professional support with its own well known support team.</p>'),
(8, 'avatar', '1'),
(8, 'per_page', '3'),
(13, 'events', '1'),
(13, 'birthdays', '1'),
(13, 'holidays', '1'),
(9, 'type', '1'),
(9, 'display', '1');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sp_shoutboxes`
--
CREATE TABLE `smf_sp_shoutboxes` (
`id_shoutbox` int(10) NOT NULL,
`name` tinytext NOT NULL,
`permission_set` tinyint(4) NOT NULL DEFAULT '0',
`groups_allowed` varchar(255) NOT NULL DEFAULT '',
`groups_denied` varchar(255) NOT NULL DEFAULT '',
`moderator_groups` text NOT NULL,
`warning` text NOT NULL,
`allowed_bbc` text NOT NULL,
`height` smallint(5) NOT NULL DEFAULT '200',
`num_show` smallint(5) NOT NULL DEFAULT '20',
`num_max` mediumint(8) NOT NULL DEFAULT '1000',
`refresh` tinyint(4) NOT NULL DEFAULT '1',
`reverse` tinyint(4) NOT NULL DEFAULT '0',
`caching` tinyint(4) NOT NULL DEFAULT '1',
`status` tinyint(4) NOT NULL DEFAULT '1',
`num_shouts` mediumint(8) NOT NULL DEFAULT '0',
`last_update` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_sp_shoutboxes`
--
INSERT INTO `smf_sp_shoutboxes` (`id_shoutbox`, `name`, `permission_set`, `groups_allowed`, `groups_denied`, `moderator_groups`, `warning`, `allowed_bbc`, `height`, `num_show`, `num_max`, `refresh`, `reverse`, `caching`, `status`, `num_shouts`, `last_update`) VALUES
(1, 'Untitled Shoutbox', 3, '', '', '', '', 'b,i,u,s,url,code,quote,me', 200, 20, 1000, 0, 0, 1, 1, 0, 1461876538);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_sp_shouts`
--
CREATE TABLE `smf_sp_shouts` (
`id_shout` mediumint(8) NOT NULL,
`id_shoutbox` int(10) NOT NULL DEFAULT '0',
`id_member` mediumint(8) NOT NULL DEFAULT '0',
`member_name` varchar(80) NOT NULL DEFAULT '0',
`log_time` int(10) NOT NULL DEFAULT '0',
`body` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_subscriptions`
--
CREATE TABLE `smf_subscriptions` (
`id_subscribe` mediumint(8) UNSIGNED NOT NULL,
`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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_themes`
--
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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_themes`
--
INSERT INTO `smf_themes` (`id_member`, `id_theme`, `variable`, `value`) VALUES
(0, 1, 'name', 'SMF Default Theme - Curve'),
(0, 1, 'theme_url', 'http://localhost/Themes/default'),
(0, 1, 'images_url', 'http://localhost/Themes/default/images'),
(0, 1, 'theme_dir', 'D:\\xampp\\htdocs/Themes/default'),
(0, 1, 'show_bbc', '1'),
(0, 1, 'show_latest_member', '1'),
(0, 1, 'show_modify', '1'),
(0, 1, 'show_user_images', '1'),
(0, 1, 'show_blurb', '1'),
(0, 1, 'show_gender', '0'),
(0, 1, 'show_newsfader', '0'),
(0, 1, 'number_recent_posts', '0'),
(0, 1, 'show_member_bar', '1'),
(0, 1, 'linktree_link', '1'),
(0, 1, 'show_profile_buttons', '1'),
(0, 1, 'show_mark_read', '1'),
(0, 1, 'show_stats_index', '1'),
(0, 1, 'linktree_inline', '0'),
(0, 1, 'show_board_desc', '1'),
(0, 1, 'newsfader_time', '5000'),
(0, 1, 'allow_no_censored', '0'),
(0, 1, 'additional_options_collapsable', '1'),
(0, 1, 'use_image_buttons', '1'),
(0, 1, 'enable_news', '1'),
(0, 1, 'forum_width', '90%'),
(0, 2, 'name', 'Core Theme'),
(0, 2, 'theme_url', 'http://localhost/Themes/core'),
(0, 2, 'images_url', 'http://localhost/Themes/core/images'),
(0, 2, 'theme_dir', 'D:\\xampp\\htdocs/Themes/core'),
(-1, 1, 'display_quick_reply', '1'),
(-1, 1, 'posts_apply_ignore_list', '1'),
(0, 3, 'theme_url', 'http://localhost/Themes/gearbox_20a'),
(0, 3, 'images_url', 'http://localhost/Themes/gearbox_20a/images'),
(0, 3, 'theme_dir', 'D:\\xampp\\htdocs/Themes/gearbox_20a'),
(0, 3, 'name', 'Gearbox'),
(0, 3, 'theme_layers', 'html,body'),
(0, 3, 'theme_templates', 'index'),
(1, 3, 'sp_block_1', '0'),
(1, 3, 'use_sidebar_menu', '1');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `smf_topics`
--
CREATE TABLE `smf_topics` (
`id_topic` mediumint(8) UNSIGNED NOT NULL,
`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'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `smf_topics`
--
INSERT INTO `smf_topics` (`id_topic`, `is_sticky`, `id_board`, `id_first_msg`, `id_last_msg`, `id_member_started`, `id_member_updated`, `id_poll`, `id_previous_board`, `id_previous_topic`, `num_replies`, `num_views`, `locked`, `unapproved_posts`, `approved`) VALUES
(1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
--
-- Indexen voor geëxporteerde tabellen
--
--
-- Indexen voor tabel `smf_admin_info_files`
--
ALTER TABLE `smf_admin_info_files`
ADD PRIMARY KEY (`id_file`),
ADD KEY `filename` (`filename`(30));
--
-- Indexen voor tabel `smf_attachments`
--
ALTER TABLE `smf_attachments`
ADD PRIMARY KEY (`id_attach`),
ADD UNIQUE KEY `id_member` (`id_member`,`id_attach`),
ADD KEY `id_msg` (`id_msg`),
ADD KEY `attachment_type` (`attachment_type`);
--
-- Indexen voor tabel `smf_ban_groups`
--
ALTER TABLE `smf_ban_groups`
ADD PRIMARY KEY (`id_ban_group`);
--
-- Indexen voor tabel `smf_ban_items`
--
ALTER TABLE `smf_ban_items`
ADD PRIMARY KEY (`id_ban`),
ADD KEY `id_ban_group` (`id_ban_group`);
--
-- Indexen voor tabel `smf_boards`
--
ALTER TABLE `smf_boards`
ADD PRIMARY KEY (`id_board`),
ADD UNIQUE KEY `categories` (`id_cat`,`id_board`),
ADD KEY `id_parent` (`id_parent`),
ADD KEY `id_msg_updated` (`id_msg_updated`),
ADD KEY `member_groups` (`member_groups`(48));
--
-- Indexen voor tabel `smf_board_permissions`
--
ALTER TABLE `smf_board_permissions`
ADD PRIMARY KEY (`id_group`,`id_profile`,`permission`);
--
-- Indexen voor tabel `smf_calendar`
--
ALTER TABLE `smf_calendar`
ADD PRIMARY KEY (`id_event`),
ADD KEY `start_date` (`start_date`),
ADD KEY `end_date` (`end_date`),
ADD KEY `topic` (`id_topic`,`id_member`);
--
-- Indexen voor tabel `smf_calendar_holidays`
--
ALTER TABLE `smf_calendar_holidays`
ADD PRIMARY KEY (`id_holiday`),
ADD KEY `event_date` (`event_date`);
--
-- Indexen voor tabel `smf_categories`
--
ALTER TABLE `smf_categories`
ADD PRIMARY KEY (`id_cat`);
--
-- Indexen voor tabel `smf_collapsed_categories`
--
ALTER TABLE `smf_collapsed_categories`
ADD PRIMARY KEY (`id_cat`,`id_member`);
--
-- Indexen voor tabel `smf_custom_fields`
--
ALTER TABLE `smf_custom_fields`
ADD PRIMARY KEY (`id_field`),
ADD UNIQUE KEY `col_name` (`col_name`);
--
-- Indexen voor tabel `smf_group_moderators`
--
ALTER TABLE `smf_group_moderators`
ADD PRIMARY KEY (`id_group`,`id_member`);
--
-- Indexen voor tabel `smf_log_actions`
--
ALTER TABLE `smf_log_actions`
ADD PRIMARY KEY (`id_action`),
ADD KEY `id_log` (`id_log`),
ADD KEY `log_time` (`log_time`),
ADD KEY `id_member` (`id_member`),
ADD KEY `id_board` (`id_board`),
ADD KEY `id_msg` (`id_msg`);
--
-- Indexen voor tabel `smf_log_activity`
--
ALTER TABLE `smf_log_activity`
ADD PRIMARY KEY (`date`),
ADD KEY `most_on` (`most_on`);
--
-- Indexen voor tabel `smf_log_banned`
--
ALTER TABLE `smf_log_banned`
ADD PRIMARY KEY (`id_ban_log`),
ADD KEY `log_time` (`log_time`);
--
-- Indexen voor tabel `smf_log_boards`
--
ALTER TABLE `smf_log_boards`
ADD PRIMARY KEY (`id_member`,`id_board`);
--
-- Indexen voor tabel `smf_log_comments`
--
ALTER TABLE `smf_log_comments`
ADD PRIMARY KEY (`id_comment`),
ADD KEY `id_recipient` (`id_recipient`),
ADD KEY `log_time` (`log_time`),
ADD KEY `comment_type` (`comment_type`);
--
-- Indexen voor tabel `smf_log_errors`
--
ALTER TABLE `smf_log_errors`
ADD PRIMARY KEY (`id_error`),
ADD KEY `log_time` (`log_time`),
ADD KEY `id_member` (`id_member`),
ADD KEY `ip` (`ip`);
--
-- Indexen voor tabel `smf_log_floodcontrol`
--
ALTER TABLE `smf_log_floodcontrol`
ADD PRIMARY KEY (`ip`,`log_type`);
--
-- Indexen voor tabel `smf_log_group_requests`
--
ALTER TABLE `smf_log_group_requests`
ADD PRIMARY KEY (`id_request`),
ADD UNIQUE KEY `id_member` (`id_member`,`id_group`);
--
-- Indexen voor tabel `smf_log_karma`
--
ALTER TABLE `smf_log_karma`
ADD PRIMARY KEY (`id_target`,`id_executor`),
ADD KEY `log_time` (`log_time`);
--
-- Indexen voor tabel `smf_log_mark_read`
--
ALTER TABLE `smf_log_mark_read`
ADD PRIMARY KEY (`id_member`,`id_board`);
--
-- Indexen voor tabel `smf_log_member_notices`
--
ALTER TABLE `smf_log_member_notices`
ADD PRIMARY KEY (`id_notice`);
--
-- Indexen voor tabel `smf_log_notify`
--
ALTER TABLE `smf_log_notify`
ADD PRIMARY KEY (`id_member`,`id_topic`,`id_board`),
ADD KEY `id_topic` (`id_topic`,`id_member`);
--
-- Indexen voor tabel `smf_log_online`
--
ALTER TABLE `smf_log_online`
ADD PRIMARY KEY (`session`),
ADD KEY `log_time` (`log_time`),
ADD KEY `id_member` (`id_member`);
--
-- Indexen voor tabel `smf_log_packages`
--
ALTER TABLE `smf_log_packages`
ADD PRIMARY KEY (`id_install`),
ADD KEY `filename` (`filename`(15));
--
-- Indexen voor tabel `smf_log_polls`
--
ALTER TABLE `smf_log_polls`
ADD KEY `id_poll` (`id_poll`,`id_member`,`id_choice`);
--
-- Indexen voor tabel `smf_log_reported`
--
ALTER TABLE `smf_log_reported`
ADD PRIMARY KEY (`id_report`),
ADD KEY `id_member` (`id_member`),
ADD KEY `id_topic` (`id_topic`),
ADD KEY `closed` (`closed`),
ADD KEY `time_started` (`time_started`),
ADD KEY `id_msg` (`id_msg`);
--
-- Indexen voor tabel `smf_log_reported_comments`
--
ALTER TABLE `smf_log_reported_comments`
ADD PRIMARY KEY (`id_comment`),
ADD KEY `id_report` (`id_report`),
ADD KEY `id_member` (`id_member`),
ADD KEY `time_sent` (`time_sent`);
--
-- Indexen voor tabel `smf_log_scheduled_tasks`
--
ALTER TABLE `smf_log_scheduled_tasks`
ADD PRIMARY KEY (`id_log`);
--
-- Indexen voor tabel `smf_log_search_messages`
--
ALTER TABLE `smf_log_search_messages`
ADD PRIMARY KEY (`id_search`,`id_msg`);
--
-- Indexen voor tabel `smf_log_search_results`
--
ALTER TABLE `smf_log_search_results`
ADD PRIMARY KEY (`id_search`,`id_topic`);
--
-- Indexen voor tabel `smf_log_search_subjects`
--
ALTER TABLE `smf_log_search_subjects`
ADD PRIMARY KEY (`word`,`id_topic`),
ADD KEY `id_topic` (`id_topic`);
--
-- Indexen voor tabel `smf_log_search_topics`
--
ALTER TABLE `smf_log_search_topics`
ADD PRIMARY KEY (`id_search`,`id_topic`);
--
-- Indexen voor tabel `smf_log_spider_hits`
--
ALTER TABLE `smf_log_spider_hits`
ADD PRIMARY KEY (`id_hit`),
ADD KEY `id_spider` (`id_spider`),
ADD KEY `log_time` (`log_time`),
ADD KEY `processed` (`processed`);
--
-- Indexen voor tabel `smf_log_spider_stats`
--
ALTER TABLE `smf_log_spider_stats`
ADD PRIMARY KEY (`stat_date`,`id_spider`);
--
-- Indexen voor tabel `smf_log_subscribed`
--
ALTER TABLE `smf_log_subscribed`
ADD PRIMARY KEY (`id_sublog`),
ADD UNIQUE KEY `id_subscribe` (`id_subscribe`,`id_member`),
ADD KEY `end_time` (`end_time`),
ADD KEY `reminder_sent` (`reminder_sent`),
ADD KEY `payments_pending` (`payments_pending`),
ADD KEY `status` (`status`),
ADD KEY `id_member` (`id_member`);
--
-- Indexen voor tabel `smf_log_topics`
--
ALTER TABLE `smf_log_topics`
ADD PRIMARY KEY (`id_member`,`id_topic`),
ADD KEY `id_topic` (`id_topic`);
--
-- Indexen voor tabel `smf_mail_queue`
--
ALTER TABLE `smf_mail_queue`
ADD PRIMARY KEY (`id_mail`),
ADD KEY `time_sent` (`time_sent`),
ADD KEY `mail_priority` (`priority`,`id_mail`);
--
-- Indexen voor tabel `smf_membergroups`
--
ALTER TABLE `smf_membergroups`
ADD PRIMARY KEY (`id_group`),
ADD KEY `min_posts` (`min_posts`);
--
-- Indexen voor tabel `smf_members`
--
ALTER TABLE `smf_members`
ADD PRIMARY KEY (`id_member`),
ADD KEY `member_name` (`member_name`),
ADD KEY `real_name` (`real_name`),
ADD KEY `date_registered` (`date_registered`),
ADD KEY `id_group` (`id_group`),
ADD KEY `birthdate` (`birthdate`),
ADD KEY `posts` (`posts`),
ADD KEY `last_login` (`last_login`),
ADD KEY `lngfile` (`lngfile`(30)),
ADD KEY `id_post_group` (`id_post_group`),
ADD KEY `warning` (`warning`),
ADD KEY `total_time_logged_in` (`total_time_logged_in`),
ADD KEY `id_theme` (`id_theme`);
--
-- Indexen voor tabel `smf_messages`
--
ALTER TABLE `smf_messages`
ADD PRIMARY KEY (`id_msg`),
ADD UNIQUE KEY `topic` (`id_topic`,`id_msg`),
ADD UNIQUE KEY `id_board` (`id_board`,`id_msg`),
ADD UNIQUE KEY `id_member` (`id_member`,`id_msg`),
ADD KEY `approved` (`approved`),
ADD KEY `ip_index` (`poster_ip`(15),`id_topic`),
ADD KEY `participation` (`id_member`,`id_topic`),
ADD KEY `show_posts` (`id_member`,`id_board`),
ADD KEY `id_topic` (`id_topic`),
ADD KEY `id_member_msg` (`id_member`,`approved`,`id_msg`),
ADD KEY `current_topic` (`id_topic`,`id_msg`,`id_member`,`approved`),
ADD KEY `related_ip` (`id_member`,`poster_ip`,`id_msg`);
--
-- Indexen voor tabel `smf_message_icons`
--
ALTER TABLE `smf_message_icons`
ADD PRIMARY KEY (`id_icon`),
ADD KEY `id_board` (`id_board`);
--
-- Indexen voor tabel `smf_moderators`
--
ALTER TABLE `smf_moderators`
ADD PRIMARY KEY (`id_board`,`id_member`);
--
-- Indexen voor tabel `smf_openid_assoc`
--
ALTER TABLE `smf_openid_assoc`
ADD PRIMARY KEY (`server_url`(125),`handle`(125)),
ADD KEY `expires` (`expires`);
--
-- Indexen voor tabel `smf_package_servers`
--
ALTER TABLE `smf_package_servers`
ADD PRIMARY KEY (`id_server`);
--
-- Indexen voor tabel `smf_permissions`
--
ALTER TABLE `smf_permissions`
ADD PRIMARY KEY (`id_group`,`permission`);
--
-- Indexen voor tabel `smf_permission_profiles`
--
ALTER TABLE `smf_permission_profiles`
ADD PRIMARY KEY (`id_profile`);
--
-- Indexen voor tabel `smf_personal_messages`
--
ALTER TABLE `smf_personal_messages`
ADD PRIMARY KEY (`id_pm`),
ADD KEY `id_member` (`id_member_from`,`deleted_by_sender`),
ADD KEY `msgtime` (`msgtime`),
ADD KEY `id_pm_head` (`id_pm_head`);
--
-- Indexen voor tabel `smf_pm_recipients`
--
ALTER TABLE `smf_pm_recipients`
ADD PRIMARY KEY (`id_pm`,`id_member`),
ADD UNIQUE KEY `id_member` (`id_member`,`deleted`,`id_pm`);
--
-- Indexen voor tabel `smf_pm_rules`
--
ALTER TABLE `smf_pm_rules`
ADD PRIMARY KEY (`id_rule`),
ADD KEY `id_member` (`id_member`),
ADD KEY `delete_pm` (`delete_pm`);
--
-- Indexen voor tabel `smf_polls`
--
ALTER TABLE `smf_polls`
ADD PRIMARY KEY (`id_poll`);
--
-- Indexen voor tabel `smf_poll_choices`
--
ALTER TABLE `smf_poll_choices`
ADD PRIMARY KEY (`id_poll`,`id_choice`);
--
-- Indexen voor tabel `smf_scheduled_tasks`
--
ALTER TABLE `smf_scheduled_tasks`
ADD PRIMARY KEY (`id_task`),
ADD UNIQUE KEY `task` (`task`),
ADD KEY `next_time` (`next_time`),
ADD KEY `disabled` (`disabled`);
--
-- Indexen voor tabel `smf_sessions`
--
ALTER TABLE `smf_sessions`
ADD PRIMARY KEY (`session_id`);
--
-- Indexen voor tabel `smf_settings`
--
ALTER TABLE `smf_settings`
ADD PRIMARY KEY (`variable`(30));
--
-- Indexen voor tabel `smf_smileys`
--
ALTER TABLE `smf_smileys`
ADD PRIMARY KEY (`id_smiley`);
--
-- Indexen voor tabel `smf_spiders`
--
ALTER TABLE `smf_spiders`
ADD PRIMARY KEY (`id_spider`);
--
-- Indexen voor tabel `smf_sp_articles`
--
ALTER TABLE `smf_sp_articles`
ADD PRIMARY KEY (`id_article`);
--
-- Indexen voor tabel `smf_sp_blocks`
--
ALTER TABLE `smf_sp_blocks`
ADD PRIMARY KEY (`id_block`),
ADD KEY `state` (`state`);
--
-- Indexen voor tabel `smf_sp_categories`
--
ALTER TABLE `smf_sp_categories`
ADD PRIMARY KEY (`id_category`);
--
-- Indexen voor tabel `smf_sp_functions`
--
ALTER TABLE `smf_sp_functions`
ADD PRIMARY KEY (`id_function`);
--
-- Indexen voor tabel `smf_sp_pages`
--
ALTER TABLE `smf_sp_pages`
ADD PRIMARY KEY (`id_page`);
--
-- Indexen voor tabel `smf_sp_parameters`
--
ALTER TABLE `smf_sp_parameters`
ADD PRIMARY KEY (`id_block`,`variable`),
ADD KEY `variable` (`variable`);
--
-- Indexen voor tabel `smf_sp_shoutboxes`
--
ALTER TABLE `smf_sp_shoutboxes`
ADD PRIMARY KEY (`id_shoutbox`);
--
-- Indexen voor tabel `smf_sp_shouts`
--
ALTER TABLE `smf_sp_shouts`
ADD PRIMARY KEY (`id_shout`);
--
-- Indexen voor tabel `smf_subscriptions`
--
ALTER TABLE `smf_subscriptions`
ADD PRIMARY KEY (`id_subscribe`),
ADD KEY `active` (`active`);
--
-- Indexen voor tabel `smf_themes`
--
ALTER TABLE `smf_themes`
ADD PRIMARY KEY (`id_theme`,`id_member`,`variable`(30)),
ADD KEY `id_member` (`id_member`);
--
-- Indexen voor tabel `smf_topics`
--
ALTER TABLE `smf_topics`
ADD PRIMARY KEY (`id_topic`),
ADD UNIQUE KEY `last_message` (`id_last_msg`,`id_board`),
ADD UNIQUE KEY `first_message` (`id_first_msg`,`id_board`),
ADD UNIQUE KEY `poll` (`id_poll`,`id_topic`),
ADD KEY `is_sticky` (`is_sticky`),
ADD KEY `approved` (`approved`),
ADD KEY `id_board` (`id_board`),
ADD KEY `member_started` (`id_member_started`,`id_board`),
ADD KEY `last_message_sticky` (`id_board`,`is_sticky`,`id_last_msg`),
ADD KEY `board_news` (`id_board`,`id_first_msg`);
--
-- AUTO_INCREMENT voor geëxporteerde tabellen
--
--
-- AUTO_INCREMENT voor een tabel `smf_admin_info_files`
--
ALTER TABLE `smf_admin_info_files`
MODIFY `id_file` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT voor een tabel `smf_attachments`
--
ALTER TABLE `smf_attachments`
MODIFY `id_attach` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_ban_groups`
--
ALTER TABLE `smf_ban_groups`
MODIFY `id_ban_group` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_ban_items`
--
ALTER TABLE `smf_ban_items`
MODIFY `id_ban` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_boards`
--
ALTER TABLE `smf_boards`
MODIFY `id_board` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT voor een tabel `smf_calendar`
--
ALTER TABLE `smf_calendar`
MODIFY `id_event` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_calendar_holidays`
--
ALTER TABLE `smf_calendar_holidays`
MODIFY `id_holiday` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;
--
-- AUTO_INCREMENT voor een tabel `smf_categories`
--
ALTER TABLE `smf_categories`
MODIFY `id_cat` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_custom_fields`
--
ALTER TABLE `smf_custom_fields`
MODIFY `id_field` smallint(5) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_actions`
--
ALTER TABLE `smf_log_actions`
MODIFY `id_action` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_banned`
--
ALTER TABLE `smf_log_banned`
MODIFY `id_ban_log` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_comments`
--
ALTER TABLE `smf_log_comments`
MODIFY `id_comment` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_errors`
--
ALTER TABLE `smf_log_errors`
MODIFY `id_error` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=130;
--
-- AUTO_INCREMENT voor een tabel `smf_log_group_requests`
--
ALTER TABLE `smf_log_group_requests`
MODIFY `id_request` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_member_notices`
--
ALTER TABLE `smf_log_member_notices`
MODIFY `id_notice` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_packages`
--
ALTER TABLE `smf_log_packages`
MODIFY `id_install` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT voor een tabel `smf_log_reported`
--
ALTER TABLE `smf_log_reported`
MODIFY `id_report` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_reported_comments`
--
ALTER TABLE `smf_log_reported_comments`
MODIFY `id_comment` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_scheduled_tasks`
--
ALTER TABLE `smf_log_scheduled_tasks`
MODIFY `id_log` mediumint(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT voor een tabel `smf_log_spider_hits`
--
ALTER TABLE `smf_log_spider_hits`
MODIFY `id_hit` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_log_subscribed`
--
ALTER TABLE `smf_log_subscribed`
MODIFY `id_sublog` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_mail_queue`
--
ALTER TABLE `smf_mail_queue`
MODIFY `id_mail` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_membergroups`
--
ALTER TABLE `smf_membergroups`
MODIFY `id_group` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT voor een tabel `smf_members`
--
ALTER TABLE `smf_members`
MODIFY `id_member` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_messages`
--
ALTER TABLE `smf_messages`
MODIFY `id_msg` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_message_icons`
--
ALTER TABLE `smf_message_icons`
MODIFY `id_icon` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT voor een tabel `smf_package_servers`
--
ALTER TABLE `smf_package_servers`
MODIFY `id_server` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_permission_profiles`
--
ALTER TABLE `smf_permission_profiles`
MODIFY `id_profile` smallint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT voor een tabel `smf_personal_messages`
--
ALTER TABLE `smf_personal_messages`
MODIFY `id_pm` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_pm_rules`
--
ALTER TABLE `smf_pm_rules`
MODIFY `id_rule` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_polls`
--
ALTER TABLE `smf_polls`
MODIFY `id_poll` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_scheduled_tasks`
--
ALTER TABLE `smf_scheduled_tasks`
MODIFY `id_task` smallint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT voor een tabel `smf_smileys`
--
ALTER TABLE `smf_smileys`
MODIFY `id_smiley` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT voor een tabel `smf_spiders`
--
ALTER TABLE `smf_spiders`
MODIFY `id_spider` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_articles`
--
ALTER TABLE `smf_sp_articles`
MODIFY `id_article` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_blocks`
--
ALTER TABLE `smf_sp_blocks`
MODIFY `id_block` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_categories`
--
ALTER TABLE `smf_sp_categories`
MODIFY `id_category` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_functions`
--
ALTER TABLE `smf_sp_functions`
MODIFY `id_function` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_pages`
--
ALTER TABLE `smf_sp_pages`
MODIFY `id_page` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_shoutboxes`
--
ALTER TABLE `smf_sp_shoutboxes`
MODIFY `id_shoutbox` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_sp_shouts`
--
ALTER TABLE `smf_sp_shouts`
MODIFY `id_shout` mediumint(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT voor een tabel `smf_subscriptions`
--
ALTER TABLE `smf_subscriptions`
MODIFY `id_subscribe` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT voor een tabel `smf_topics`
--
ALTER TABLE `smf_topics`
MODIFY `id_topic` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
\\\n 
'',\n file: ''sdgirlsmilies.zip''\n },\n 1513: {\n name: ''DarkB Smiley set 1.2'',\n versions: [''41'', ''44'', ''46'', ''49'', ''53'', ''55'', ''58'', ''64'', ''67'', ''70'', ''72'', ''81'', ''63'', ''65'', ''84''],\n desc: ''This is a set of lightly animated 20*20px smileys fitted to SMF forums using a dark background. The smileys are made in traditional colours - yellow and dark colors. This package only contains the standard smileys used in SMF and not the afro, azn, evil, police, and sleepy custom smileys!!! The DarkB smileys looks terrible in forums with very bright background!!! 
\\\n 
'',\r\n file: ''Greeny.zip'',\r\n author: ''Pipee''\r\n },\r\n 1897: {\r\n name: ''WPhotoshop'',\r\n desc: ''WPhotoshop theme design by WannaBeDie.
\\\r\n 