'',\r\n file: ''Teknomaxi.zip'',\r\n author: ''snrj''\r\n },\r\n 2718: {\r\n name: ''Origami'',\r\n desc: ''This theme may not work properly in old and non CSS3 supported browsers.
'',\r\n file: ''Origami_SMF2.zip'',\r\n author: ''CrimeS''\r\n },\r\n 1846: {\r\n name: ''Nly Grey'',\r\n desc: ''
smf 1.1.13 updated.
'',\r\n file: ''nly-grey(new).zip'',\r\n author: ''N a t i''\r\n }\r\n};\r\nvar smf_featured = 2497;\r\nvar smf_random = 1846;\r\nvar smf_latestThemes = [2723, 2722, 2718];\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');
-- --------------------------------------------------------
--
-- Table structure for table `approval_queue`
--
CREATE TABLE `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=utf8;
--
-- Dumping data for table `approval_queue`
--
-- --------------------------------------------------------
--
-- Table structure for table `attachments`
--
CREATE TABLE `attachments` (
`id_attach` int(10) unsigned NOT NULL auto_increment,
`id_thumb` int(10) unsigned NOT NULL default '0',
`id_msg` int(10) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_folder` tinyint(3) NOT NULL default '1',
`attachment_type` tinyint(3) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`file_hash` varchar(40) NOT NULL default '',
`fileext` varchar(8) NOT NULL default '',
`size` int(10) unsigned NOT NULL default '0',
`downloads` mediumint(8) unsigned NOT NULL default '0',
`width` mediumint(8) unsigned NOT NULL default '0',
`height` mediumint(8) unsigned NOT NULL default '0',
`mime_type` varchar(20) NOT NULL default '',
`approved` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`id_attach`),
UNIQUE KEY `id_member` (`id_member`,`id_attach`),
KEY `id_msg` (`id_msg`),
KEY `attachment_type` (`attachment_type`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `attachments`
--
INSERT INTO `attachments` VALUES (4, 0, 0, 1, 1, 0, 'avatar_1_1374756310.png', 'ef744ee4877dc47c24af8652adc57beb144f6094', 'png', 12928, 39, 147, 100, 'image/png', 1);
-- --------------------------------------------------------
--
-- Table structure for table `ban_groups`
--
CREATE TABLE `ban_groups` (
`id_ban_group` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`ban_time` int(10) unsigned NOT NULL default '0',
`expire_time` int(10) unsigned default NULL,
`cannot_access` tinyint(3) unsigned NOT NULL default '0',
`cannot_register` tinyint(3) unsigned NOT NULL default '0',
`cannot_post` tinyint(3) unsigned NOT NULL default '0',
`cannot_login` tinyint(3) unsigned NOT NULL default '0',
`reason` varchar(255) NOT NULL default '',
`notes` text NOT NULL,
PRIMARY KEY (`id_ban_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ban_groups`
--
-- --------------------------------------------------------
--
-- Table structure for table `ban_items`
--
CREATE TABLE `ban_items` (
`id_ban` mediumint(8) unsigned NOT NULL auto_increment,
`id_ban_group` smallint(5) unsigned NOT NULL default '0',
`ip_low1` tinyint(3) unsigned NOT NULL default '0',
`ip_high1` tinyint(3) unsigned NOT NULL default '0',
`ip_low2` tinyint(3) unsigned NOT NULL default '0',
`ip_high2` tinyint(3) unsigned NOT NULL default '0',
`ip_low3` tinyint(3) unsigned NOT NULL default '0',
`ip_high3` tinyint(3) unsigned NOT NULL default '0',
`ip_low4` tinyint(3) unsigned NOT NULL default '0',
`ip_high4` tinyint(3) unsigned NOT NULL default '0',
`hostname` varchar(255) NOT NULL default '',
`email_address` varchar(255) NOT NULL default '',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`hits` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id_ban`),
KEY `id_ban_group` (`id_ban_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ban_items`
--
-- --------------------------------------------------------
--
-- Table structure for table `board_permissions`
--
CREATE TABLE `board_permissions` (
`id_group` smallint(5) NOT NULL default '0',
`id_profile` smallint(5) unsigned NOT NULL default '0',
`permission` varchar(30) NOT NULL default '',
`add_deny` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id_group`,`id_profile`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `board_permissions`
--
INSERT INTO `board_permissions` VALUES (-1, 1, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'remove_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_add_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_edit_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_lock_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (0, 1, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (2, 1, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (3, 1, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (-1, 2, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'remove_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (0, 2, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (2, 2, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (3, 2, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (-1, 3, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'remove_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (0, 3, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (2, 3, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (3, 3, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (-1, 4, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (0, 4, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (2, 4, 'view_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'moderate_board', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_new', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_reply_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_reply_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_unapproved_topics', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_unapproved_replies_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_unapproved_replies_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_unapproved_attachments', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_post', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_add_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_view', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_vote', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'poll_edit_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'report_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'lock_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'send_topic', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'mark_any_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'mark_notify', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'delete_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'modify_own', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'make_sticky', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'lock_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'remove_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'move_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'merge_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'split_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'delete_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'modify_any', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'approve_posts', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'post_attachment', 1);
INSERT INTO `board_permissions` VALUES (3, 4, 'view_attachments', 1);
-- --------------------------------------------------------
--
-- Table structure for table `boards`
--
CREATE TABLE `boards` (
`id_board` smallint(5) unsigned NOT NULL auto_increment,
`id_cat` tinyint(4) unsigned NOT NULL default '0',
`child_level` tinyint(4) unsigned NOT NULL default '0',
`id_parent` smallint(5) unsigned NOT NULL default '0',
`board_order` smallint(5) NOT NULL default '0',
`id_last_msg` int(10) unsigned NOT NULL default '0',
`id_msg_updated` int(10) unsigned NOT NULL default '0',
`member_groups` varchar(255) NOT NULL default '-1,0',
`id_profile` smallint(5) unsigned NOT NULL default '1',
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`num_topics` mediumint(8) unsigned NOT NULL default '0',
`num_posts` mediumint(8) unsigned NOT NULL default '0',
`count_posts` tinyint(4) NOT NULL default '0',
`id_theme` tinyint(4) unsigned NOT NULL default '0',
`override_theme` tinyint(4) unsigned NOT NULL default '0',
`unapproved_posts` smallint(5) NOT NULL default '0',
`unapproved_topics` smallint(5) NOT NULL default '0',
`redirect` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_board`),
UNIQUE KEY `categories` (`id_cat`,`id_board`),
KEY `id_parent` (`id_parent`),
KEY `id_msg_updated` (`id_msg_updated`),
KEY `member_groups` (`member_groups`(48))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `boards`
--
INSERT INTO `boards` VALUES (1, 1, 0, 0, 1, 2, 2, '-1,0,2', 1, 'General Discussion', 'Feel free to talk about anything and everything in this board.', 1, 2, 0, 0, 0, 0, 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `calendar`
--
CREATE TABLE `calendar` (
`id_event` smallint(5) unsigned NOT NULL auto_increment,
`start_date` date NOT NULL default '0001-01-01',
`end_date` date NOT NULL default '0001-01-01',
`id_board` smallint(5) unsigned NOT NULL default '0',
`id_topic` mediumint(8) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`id_member` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id_event`),
KEY `start_date` (`start_date`),
KEY `end_date` (`end_date`),
KEY `topic` (`id_topic`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `calendar`
--
-- --------------------------------------------------------
--
-- Table structure for table `calendar_holidays`
--
CREATE TABLE `calendar_holidays` (
`id_holiday` smallint(5) unsigned NOT NULL auto_increment,
`event_date` date NOT NULL default '0001-01-01',
`title` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_holiday`),
KEY `event_date` (`event_date`)
) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ;
--
-- Dumping data for table `calendar_holidays`
--
INSERT INTO `calendar_holidays` VALUES (1, '0004-01-01', 'New Year''s');
INSERT INTO `calendar_holidays` VALUES (2, '0004-12-25', 'Christmas');
INSERT INTO `calendar_holidays` VALUES (3, '0004-02-14', 'Valentine''s Day');
INSERT INTO `calendar_holidays` VALUES (4, '0004-03-17', 'St. Patrick''s Day');
INSERT INTO `calendar_holidays` VALUES (5, '0004-04-01', 'April Fools');
INSERT INTO `calendar_holidays` VALUES (6, '0004-04-22', 'Earth Day');
INSERT INTO `calendar_holidays` VALUES (7, '0004-10-24', 'United Nations Day');
INSERT INTO `calendar_holidays` VALUES (8, '0004-10-31', 'Halloween');
INSERT INTO `calendar_holidays` VALUES (9, '2010-05-09', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (10, '2011-05-08', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (11, '2012-05-13', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (12, '2013-05-12', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (13, '2014-05-11', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (14, '2015-05-10', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (15, '2016-05-08', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (16, '2017-05-14', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (17, '2018-05-13', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (18, '2019-05-12', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (19, '2020-05-10', 'Mother''s Day');
INSERT INTO `calendar_holidays` VALUES (20, '2008-06-15', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (21, '2009-06-21', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (22, '2010-06-20', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (23, '2011-06-19', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (24, '2012-06-17', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (25, '2013-06-16', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (26, '2014-06-15', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (27, '2015-06-21', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (28, '2016-06-19', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (29, '2017-06-18', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (30, '2018-06-17', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (31, '2019-06-16', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (32, '2020-06-21', 'Father''s Day');
INSERT INTO `calendar_holidays` VALUES (33, '2010-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (34, '2011-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (35, '2012-06-20', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (36, '2013-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (37, '2014-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (38, '2015-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (39, '2016-06-20', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (40, '2017-06-20', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (41, '2018-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (42, '2019-06-21', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (43, '2020-06-20', 'Summer Solstice');
INSERT INTO `calendar_holidays` VALUES (44, '2010-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (45, '2011-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (46, '2012-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (47, '2013-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (48, '2014-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (49, '2015-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (50, '2016-03-19', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (51, '2017-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (52, '2018-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (53, '2019-03-20', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (54, '2020-03-19', 'Vernal Equinox');
INSERT INTO `calendar_holidays` VALUES (55, '2010-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (56, '2011-12-22', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (57, '2012-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (58, '2013-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (59, '2014-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (60, '2015-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (61, '2016-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (62, '2017-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (63, '2018-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (64, '2019-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (65, '2020-12-21', 'Winter Solstice');
INSERT INTO `calendar_holidays` VALUES (66, '2010-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (67, '2011-09-23', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (68, '2012-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (69, '2013-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (70, '2014-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (71, '2015-09-23', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (72, '2016-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (73, '2017-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (74, '2018-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (75, '2019-09-23', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (76, '2020-09-22', 'Autumnal Equinox');
INSERT INTO `calendar_holidays` VALUES (77, '0004-07-04', 'Independence Day');
INSERT INTO `calendar_holidays` VALUES (78, '0004-05-05', 'Cinco de Mayo');
INSERT INTO `calendar_holidays` VALUES (79, '0004-06-14', 'Flag Day');
INSERT INTO `calendar_holidays` VALUES (80, '0004-11-11', 'Veterans Day');
INSERT INTO `calendar_holidays` VALUES (81, '0004-02-02', 'Groundhog Day');
INSERT INTO `calendar_holidays` VALUES (82, '2010-11-25', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (83, '2011-11-24', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (84, '2012-11-22', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (85, '2013-11-21', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (86, '2014-11-20', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (87, '2015-11-26', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (88, '2016-11-24', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (89, '2017-11-23', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (90, '2018-11-22', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (91, '2019-11-21', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (92, '2020-11-26', 'Thanksgiving');
INSERT INTO `calendar_holidays` VALUES (93, '2010-05-31', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (94, '2011-05-30', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (95, '2012-05-28', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (96, '2013-05-27', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (97, '2014-05-26', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (98, '2015-05-25', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (99, '2016-05-30', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (100, '2017-05-29', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (101, '2018-05-28', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (102, '2019-05-27', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (103, '2020-05-25', 'Memorial Day');
INSERT INTO `calendar_holidays` VALUES (104, '2010-09-06', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (105, '2011-09-05', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (106, '2012-09-03', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (107, '2013-09-09', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (108, '2014-09-08', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (109, '2015-09-07', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (110, '2016-09-05', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (111, '2017-09-04', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (112, '2018-09-03', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (113, '2019-09-09', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (114, '2020-09-07', 'Labor Day');
INSERT INTO `calendar_holidays` VALUES (115, '0004-06-06', 'D-Day');
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`id_cat` tinyint(4) unsigned NOT NULL auto_increment,
`cat_order` tinyint(4) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`can_collapse` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id_cat`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` VALUES (1, 0, 'General Category', 1);
-- --------------------------------------------------------
--
-- Table structure for table `collapsed_categories`
--
CREATE TABLE `collapsed_categories` (
`id_cat` tinyint(4) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id_cat`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `collapsed_categories`
--
-- --------------------------------------------------------
--
-- Table structure for table `custom_fields`
--
CREATE TABLE `custom_fields` (
`id_field` smallint(5) NOT NULL auto_increment,
`col_name` varchar(12) NOT NULL default '',
`field_name` varchar(40) NOT NULL default '',
`field_desc` varchar(255) NOT NULL default '',
`field_type` varchar(8) NOT NULL default 'text',
`field_length` smallint(5) NOT NULL default '255',
`field_options` text NOT NULL,
`mask` varchar(255) NOT NULL default '',
`show_reg` tinyint(3) NOT NULL default '0',
`show_display` tinyint(3) NOT NULL default '0',
`show_profile` varchar(20) NOT NULL default 'forumprofile',
`private` tinyint(3) NOT NULL default '0',
`active` tinyint(3) NOT NULL default '1',
`bbc` tinyint(3) NOT NULL default '0',
`can_search` tinyint(3) NOT NULL default '0',
`default_value` varchar(255) NOT NULL default '',
`enclose` text NOT NULL,
`placement` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`id_field`),
UNIQUE KEY `col_name` (`col_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `custom_fields`
--
-- --------------------------------------------------------
--
-- Table structure for table `group_moderators`
--
CREATE TABLE `group_moderators` (
`id_group` smallint(5) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id_group`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `group_moderators`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_actions`
--
CREATE TABLE `log_actions` (
`id_action` int(10) unsigned NOT NULL auto_increment,
`id_log` tinyint(3) unsigned NOT NULL default '1',
`log_time` int(10) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`ip` char(16) NOT NULL default '',
`action` varchar(30) NOT NULL default '',
`id_board` smallint(5) unsigned NOT NULL default '0',
`id_topic` mediumint(8) unsigned NOT NULL default '0',
`id_msg` int(10) unsigned NOT NULL default '0',
`extra` text NOT NULL,
PRIMARY KEY (`id_action`),
KEY `id_log` (`id_log`),
KEY `log_time` (`log_time`),
KEY `id_member` (`id_member`),
KEY `id_board` (`id_board`),
KEY `id_msg` (`id_msg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_actions`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_activity`
--
CREATE TABLE `log_activity` (
`date` date NOT NULL default '0001-01-01',
`hits` mediumint(8) unsigned NOT NULL default '0',
`topics` smallint(5) unsigned NOT NULL default '0',
`posts` smallint(5) unsigned NOT NULL default '0',
`registers` smallint(5) unsigned NOT NULL default '0',
`most_on` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`date`),
KEY `most_on` (`most_on`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_activity`
--
INSERT INTO `log_activity` VALUES ('2013-07-25', 68, 1, 2, 1, 1);
INSERT INTO `log_activity` VALUES ('2013-07-26', 42, 0, 0, 0, 2);
-- --------------------------------------------------------
--
-- Table structure for table `log_banned`
--
CREATE TABLE `log_banned` (
`id_ban_log` mediumint(8) unsigned NOT NULL auto_increment,
`id_member` mediumint(8) unsigned NOT NULL default '0',
`ip` char(16) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`log_time` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_ban_log`),
KEY `log_time` (`log_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_banned`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_boards`
--
CREATE TABLE `log_boards` (
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_board` smallint(5) unsigned NOT NULL default '0',
`id_msg` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_member`,`id_board`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_boards`
--
INSERT INTO `log_boards` VALUES (1, 1, 2);
-- --------------------------------------------------------
--
-- Table structure for table `log_comments`
--
CREATE TABLE `log_comments` (
`id_comment` mediumint(8) unsigned NOT NULL auto_increment,
`id_member` mediumint(8) unsigned NOT NULL default '0',
`member_name` varchar(80) NOT NULL default '',
`comment_type` varchar(8) NOT NULL default 'warning',
`id_recipient` mediumint(8) unsigned NOT NULL default '0',
`recipient_name` varchar(255) NOT NULL default '',
`log_time` int(10) NOT NULL default '0',
`id_notice` mediumint(8) unsigned NOT NULL default '0',
`counter` tinyint(3) NOT NULL default '0',
`body` text NOT NULL,
PRIMARY KEY (`id_comment`),
KEY `id_recipient` (`id_recipient`),
KEY `log_time` (`log_time`),
KEY `comment_type` (`comment_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_digest`
--
CREATE TABLE `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=utf8;
--
-- Dumping data for table `log_digest`
--
INSERT INTO `log_digest` VALUES (1, 2, 'reply', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `log_errors`
--
CREATE TABLE `log_errors` (
`id_error` mediumint(8) unsigned NOT NULL auto_increment,
`log_time` int(10) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`ip` char(16) NOT NULL default '',
`url` text NOT NULL,
`message` text NOT NULL,
`session` char(32) NOT NULL default '',
`error_type` char(15) NOT NULL default 'general',
`file` varchar(255) NOT NULL default '',
`line` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id_error`),
KEY `log_time` (`log_time`),
KEY `id_member` (`id_member`),
KEY `ip` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `log_errors`
--
INSERT INTO `log_errors` VALUES (1, 1374749951, 0, '', '?scheduled=task;ts=0', 'Could not retrieve the file http://www.simplemachines.org/smf/latest-smileys.js?language=english&version=SMF+2.0.4.', '', 'general', '', 0);
INSERT INTO `log_errors` VALUES (2, 1374848194, 1, '74.125.60.56', '?http://new.minidvblinux.de/forum/', '8: Undefined index: pages', '3e4af741826d93ee80f4146b81d4f875', 'undefined_vars', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default/BoardIndex.template.php (main sub template - eval?)', 61);
INSERT INTO `log_errors` VALUES (3, 1374848265, 0, '74.125.60.56', '?http://new.minidvblinux.de/forum/', '8: Undefined index: pages', '39afd01e5096a2c7c68d84eca165bd75', 'undefined_vars', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default/BoardIndex.template.php (main sub template - eval?)', 61);
INSERT INTO `log_errors` VALUES (4, 1374848273, 1, '74.125.60.56', '?', '8: Undefined index: pages', '39afd01e5096a2c7c68d84eca165bd75', 'undefined_vars', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default/BoardIndex.template.php (main sub template - eval?)', 61);
INSERT INTO `log_errors` VALUES (5, 1374848273, 0, '', '?scheduled=task;ts=1374796800', '', '', 'general', '', 0);
INSERT INTO `log_errors` VALUES (6, 1374848277, 1, '74.125.60.56', '?action=admin;area=theme;sa=settings;th=1;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Kann die ''Settings.german-utf8'' Sprachdatei nicht laden.', '39afd01e5096a2c7c68d84eca165bd75', 'general', '', 0);
INSERT INTO `log_errors` VALUES (7, 1374848339, 1, '74.125.60.56', '?action=admin;area=theme;sa=settings;th=1', 'Kann die ''Settings.german-utf8'' Sprachdatei nicht laden.', '39afd01e5096a2c7c68d84eca165bd75', 'general', '', 0);
INSERT INTO `log_errors` VALUES (8, 1374848508, 1, '74.125.60.56', '?action=admin;area=manageattachments;sa=maintenance;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Es kann auf den Upload-Pfad der Dateianhänge nicht zugegriffen werden.', '39afd01e5096a2c7c68d84eca165bd75', 'critical', '', 0);
INSERT INTO `log_errors` VALUES (9, 1374848513, 1, '74.125.60.56', '?action=admin;area=manageattachments;sa=maintenance;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Es kann auf den Upload-Pfad der Dateianhänge nicht zugegriffen werden.', '39afd01e5096a2c7c68d84eca165bd75', 'critical', '', 0);
INSERT INTO `log_errors` VALUES (10, 1374848581, 1, '74.125.60.56', '?action=admin;area=manageattachments;sa=maintenance;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Es kann auf den Upload-Pfad der Dateianhänge nicht zugegriffen werden.', '39afd01e5096a2c7c68d84eca165bd75', 'critical', '', 0);
INSERT INTO `log_errors` VALUES (11, 1374848677, 1, '74.125.60.56', '?action=admin;area=manageattachments;sa=maintenance;a4bb6979978=39afd01e5096a2c7c68d84eca165bd75', 'Es kann auf den Upload-Pfad der Dateianhänge nicht zugegriffen werden.', '39afd01e5096a2c7c68d84eca165bd75', 'critical', '', 0);
INSERT INTO `log_errors` VALUES (12, 1374848960, 1, '74.125.60.56', '?http://new.minidvblinux.de/forum/', '8: Undefined index: pages', '39afd01e5096a2c7c68d84eca165bd75', 'undefined_vars', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default/BoardIndex.template.php (main sub template - eval?)', 61);
-- --------------------------------------------------------
--
-- Table structure for table `log_floodcontrol`
--
CREATE TABLE `log_floodcontrol` (
`ip` char(16) NOT NULL default '',
`log_time` int(10) unsigned NOT NULL default '0',
`log_type` varchar(8) NOT NULL default 'post',
PRIMARY KEY (`ip`,`log_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_floodcontrol`
--
INSERT INTO `log_floodcontrol` VALUES ('172.30.250.73', 1374756213, 'post');
INSERT INTO `log_floodcontrol` VALUES ('74.125.60.56', 1374848272, 'login');
-- --------------------------------------------------------
--
-- Table structure for table `log_group_requests`
--
CREATE TABLE `log_group_requests` (
`id_request` mediumint(8) unsigned NOT NULL auto_increment,
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_group` smallint(5) unsigned NOT NULL default '0',
`time_applied` int(10) unsigned NOT NULL default '0',
`reason` text NOT NULL,
PRIMARY KEY (`id_request`),
UNIQUE KEY `id_member` (`id_member`,`id_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_group_requests`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_karma`
--
CREATE TABLE `log_karma` (
`id_target` mediumint(8) unsigned NOT NULL default '0',
`id_executor` mediumint(8) unsigned NOT NULL default '0',
`log_time` int(10) unsigned NOT NULL default '0',
`action` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id_target`,`id_executor`),
KEY `log_time` (`log_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_karma`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_mark_read`
--
CREATE TABLE `log_mark_read` (
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_board` smallint(5) unsigned NOT NULL default '0',
`id_msg` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_member`,`id_board`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_mark_read`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_member_notices`
--
CREATE TABLE `log_member_notices` (
`id_notice` mediumint(8) unsigned NOT NULL auto_increment,
`subject` varchar(255) NOT NULL default '',
`body` text NOT NULL,
PRIMARY KEY (`id_notice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_member_notices`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_notify`
--
CREATE TABLE `log_notify` (
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_topic` mediumint(8) unsigned NOT NULL default '0',
`id_board` smallint(5) unsigned NOT NULL default '0',
`sent` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id_member`,`id_topic`,`id_board`),
KEY `id_topic` (`id_topic`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_notify`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_online`
--
CREATE TABLE `log_online` (
`session` varchar(32) NOT NULL default '',
`log_time` int(10) NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_spider` smallint(5) unsigned NOT NULL default '0',
`ip` int(10) unsigned NOT NULL default '0',
`url` text NOT NULL,
PRIMARY KEY (`session`),
KEY `log_time` (`log_time`),
KEY `id_member` (`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_online`
--
INSERT INTO `log_online` VALUES ('h06f85tjp81mt2qrphjlomhgc2', 1374848960, 1, 0, 1249721400, 'a:1:{s:10:"USER_AGENT";s:76:"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0";}');
-- --------------------------------------------------------
--
-- Table structure for table `log_packages`
--
CREATE TABLE `log_packages` (
`id_install` int(10) NOT NULL auto_increment,
`filename` varchar(255) NOT NULL default '',
`package_id` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`version` varchar(255) NOT NULL default '',
`id_member_installed` mediumint(8) NOT NULL default '0',
`member_installed` varchar(255) NOT NULL default '',
`time_installed` int(10) NOT NULL default '0',
`id_member_removed` mediumint(8) NOT NULL default '0',
`member_removed` varchar(255) NOT NULL default '',
`time_removed` int(10) NOT NULL default '0',
`install_state` tinyint(3) NOT NULL default '1',
`failed_steps` text NOT NULL,
`themes_installed` varchar(255) NOT NULL default '',
`db_changes` text NOT NULL,
PRIMARY KEY (`id_install`),
KEY `filename` (`filename`(15))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_packages`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_polls`
--
CREATE TABLE `log_polls` (
`id_poll` mediumint(8) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_choice` tinyint(3) unsigned NOT NULL default '0',
KEY `id_poll` (`id_poll`,`id_member`,`id_choice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_polls`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_reported`
--
CREATE TABLE `log_reported` (
`id_report` mediumint(8) unsigned NOT NULL auto_increment,
`id_msg` int(10) unsigned NOT NULL default '0',
`id_topic` mediumint(8) unsigned NOT NULL default '0',
`id_board` smallint(5) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`membername` varchar(255) NOT NULL default '',
`subject` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`time_started` int(10) NOT NULL default '0',
`time_updated` int(10) NOT NULL default '0',
`num_reports` mediumint(6) NOT NULL default '0',
`closed` tinyint(3) NOT NULL default '0',
`ignore_all` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`id_report`),
KEY `id_member` (`id_member`),
KEY `id_topic` (`id_topic`),
KEY `closed` (`closed`),
KEY `time_started` (`time_started`),
KEY `id_msg` (`id_msg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_reported`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_reported_comments`
--
CREATE TABLE `log_reported_comments` (
`id_comment` mediumint(8) unsigned NOT NULL auto_increment,
`id_report` mediumint(8) NOT NULL default '0',
`id_member` mediumint(8) NOT NULL,
`membername` varchar(255) NOT NULL default '',
`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,
PRIMARY KEY (`id_comment`),
KEY `id_report` (`id_report`),
KEY `id_member` (`id_member`),
KEY `time_sent` (`time_sent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_reported_comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_scheduled_tasks`
--
CREATE TABLE `log_scheduled_tasks` (
`id_log` mediumint(8) NOT NULL auto_increment,
`id_task` smallint(5) NOT NULL default '0',
`time_run` int(10) NOT NULL default '0',
`time_taken` float NOT NULL default '0',
PRIMARY KEY (`id_log`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `log_scheduled_tasks`
--
INSERT INTO `log_scheduled_tasks` VALUES (1, 2, 1374749864, 0);
INSERT INTO `log_scheduled_tasks` VALUES (2, 3, 1374749867, 0);
INSERT INTO `log_scheduled_tasks` VALUES (3, 5, 1374749872, 0);
INSERT INTO `log_scheduled_tasks` VALUES (4, 6, 1374749880, 0);
INSERT INTO `log_scheduled_tasks` VALUES (5, 9, 1374749997, 0);
INSERT INTO `log_scheduled_tasks` VALUES (6, 1, 1374754417, 0);
INSERT INTO `log_scheduled_tasks` VALUES (7, 1, 1374848265, 0);
INSERT INTO `log_scheduled_tasks` VALUES (8, 5, 1374848273, 0);
INSERT INTO `log_scheduled_tasks` VALUES (9, 3, 1374848277, 0);
INSERT INTO `log_scheduled_tasks` VALUES (10, 7, 1374848348, 7);
-- --------------------------------------------------------
--
-- Table structure for table `log_search_messages`
--
CREATE TABLE `log_search_messages` (
`id_search` tinyint(3) unsigned NOT NULL default '0',
`id_msg` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_search`,`id_msg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_search_messages`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_search_results`
--
CREATE TABLE `log_search_results` (
`id_search` tinyint(3) unsigned NOT NULL default '0',
`id_topic` mediumint(8) unsigned NOT NULL default '0',
`id_msg` int(10) unsigned NOT NULL default '0',
`relevance` smallint(5) unsigned NOT NULL default '0',
`num_matches` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`id_search`,`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_search_results`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_search_subjects`
--
CREATE TABLE `log_search_subjects` (
`word` varchar(20) NOT NULL default '',
`id_topic` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`word`,`id_topic`),
KEY `id_topic` (`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_search_subjects`
--
INSERT INTO `log_search_subjects` VALUES ('SMF', 1);
INSERT INTO `log_search_subjects` VALUES ('to', 1);
INSERT INTO `log_search_subjects` VALUES ('Welcome', 1);
-- --------------------------------------------------------
--
-- Table structure for table `log_search_topics`
--
CREATE TABLE `log_search_topics` (
`id_search` tinyint(3) unsigned NOT NULL default '0',
`id_topic` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id_search`,`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_search_topics`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_spider_hits`
--
CREATE TABLE `log_spider_hits` (
`id_hit` int(10) unsigned NOT NULL auto_increment,
`id_spider` smallint(5) unsigned NOT NULL default '0',
`log_time` int(10) unsigned NOT NULL default '0',
`url` varchar(255) NOT NULL default '',
`processed` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`id_hit`),
KEY `id_spider` (`id_spider`),
KEY `log_time` (`log_time`),
KEY `processed` (`processed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_spider_hits`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_spider_stats`
--
CREATE TABLE `log_spider_stats` (
`id_spider` smallint(5) unsigned NOT NULL default '0',
`page_hits` smallint(5) unsigned NOT NULL default '0',
`last_seen` int(10) unsigned NOT NULL default '0',
`stat_date` date NOT NULL default '0001-01-01',
PRIMARY KEY (`stat_date`,`id_spider`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_spider_stats`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_subscribed`
--
CREATE TABLE `log_subscribed` (
`id_sublog` int(10) unsigned NOT NULL auto_increment,
`id_subscribe` mediumint(8) unsigned NOT NULL default '0',
`id_member` int(10) NOT NULL default '0',
`old_id_group` smallint(5) NOT NULL default '0',
`start_time` int(10) NOT NULL default '0',
`end_time` int(10) NOT NULL default '0',
`status` tinyint(3) NOT NULL default '0',
`payments_pending` tinyint(3) NOT NULL default '0',
`pending_details` text NOT NULL,
`reminder_sent` tinyint(3) NOT NULL default '0',
`vendor_ref` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_sublog`),
UNIQUE KEY `id_subscribe` (`id_subscribe`,`id_member`),
KEY `end_time` (`end_time`),
KEY `reminder_sent` (`reminder_sent`),
KEY `payments_pending` (`payments_pending`),
KEY `status` (`status`),
KEY `id_member` (`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `log_subscribed`
--
-- --------------------------------------------------------
--
-- Table structure for table `log_topics`
--
CREATE TABLE `log_topics` (
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_topic` mediumint(8) unsigned NOT NULL default '0',
`id_msg` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_member`,`id_topic`),
KEY `id_topic` (`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `log_topics`
--
INSERT INTO `log_topics` VALUES (1, 1, 2);
-- --------------------------------------------------------
--
-- Table structure for table `mail_queue`
--
CREATE TABLE `mail_queue` (
`id_mail` int(10) unsigned NOT NULL auto_increment,
`time_sent` int(10) NOT NULL default '0',
`recipient` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`subject` varchar(255) NOT NULL default '',
`headers` text NOT NULL,
`send_html` tinyint(3) NOT NULL default '0',
`priority` tinyint(3) NOT NULL default '1',
`private` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id_mail`),
KEY `time_sent` (`time_sent`),
KEY `mail_priority` (`priority`,`id_mail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `mail_queue`
--
-- --------------------------------------------------------
--
-- Table structure for table `membergroups`
--
CREATE TABLE `membergroups` (
`id_group` smallint(5) unsigned NOT NULL auto_increment,
`group_name` varchar(80) NOT NULL default '',
`description` text NOT NULL,
`online_color` varchar(20) NOT NULL default '',
`min_posts` mediumint(9) NOT NULL default '-1',
`max_messages` smallint(5) unsigned NOT NULL default '0',
`stars` varchar(255) NOT NULL default '',
`group_type` tinyint(3) NOT NULL default '0',
`hidden` tinyint(3) NOT NULL default '0',
`id_parent` smallint(5) NOT NULL default '-2',
PRIMARY KEY (`id_group`),
KEY `min_posts` (`min_posts`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `membergroups`
--
INSERT INTO `membergroups` VALUES (1, 'Administrator', '', '#FF0000', -1, 0, '5#staradmin.gif', 1, 0, -2);
INSERT INTO `membergroups` VALUES (2, 'Global Moderator', '', '#0000FF', -1, 0, '5#stargmod.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (3, 'Moderator', '', '', -1, 0, '5#starmod.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (4, 'Newbie', '', '', 0, 0, '1#star.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (5, 'Jr. Member', '', '', 50, 0, '2#star.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (6, 'Full Member', '', '', 100, 0, '3#star.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (7, 'Sr. Member', '', '', 250, 0, '4#star.gif', 0, 0, -2);
INSERT INTO `membergroups` VALUES (8, 'Hero Member', '', '', 500, 0, '5#star.gif', 0, 0, -2);
-- --------------------------------------------------------
--
-- Table structure for table `members`
--
CREATE TABLE `members` (
`id_member` mediumint(8) unsigned NOT NULL auto_increment,
`member_name` varchar(80) NOT NULL default '',
`date_registered` int(10) unsigned NOT NULL default '0',
`posts` mediumint(8) unsigned NOT NULL default '0',
`id_group` smallint(5) unsigned NOT NULL default '0',
`lngfile` varchar(255) NOT NULL default '',
`last_login` int(10) unsigned NOT NULL default '0',
`real_name` varchar(255) NOT NULL default '',
`instant_messages` smallint(5) NOT NULL default '0',
`unread_messages` smallint(5) NOT NULL default '0',
`new_pm` tinyint(3) unsigned NOT NULL default '0',
`buddy_list` text NOT NULL,
`pm_ignore_list` varchar(255) NOT NULL default '',
`pm_prefs` mediumint(8) NOT NULL default '0',
`mod_prefs` varchar(20) NOT NULL default '',
`message_labels` text NOT NULL,
`passwd` varchar(64) NOT NULL default '',
`openid_uri` text NOT NULL,
`email_address` varchar(255) NOT NULL default '',
`personal_text` varchar(255) NOT NULL default '',
`gender` tinyint(4) unsigned NOT NULL default '0',
`birthdate` date NOT NULL default '0001-01-01',
`website_title` varchar(255) NOT NULL default '',
`website_url` varchar(255) NOT NULL default '',
`location` varchar(255) NOT NULL default '',
`icq` varchar(255) NOT NULL default '',
`aim` varchar(255) NOT NULL default '',
`yim` varchar(32) NOT NULL default '',
`msn` varchar(255) NOT NULL default '',
`hide_email` tinyint(4) NOT NULL default '0',
`show_online` tinyint(4) NOT NULL default '1',
`time_format` varchar(80) NOT NULL default '',
`signature` text NOT NULL,
`time_offset` float NOT NULL default '0',
`avatar` varchar(255) NOT NULL default '',
`pm_email_notify` tinyint(4) NOT NULL default '0',
`karma_bad` smallint(5) unsigned NOT NULL default '0',
`karma_good` smallint(5) unsigned NOT NULL default '0',
`usertitle` varchar(255) NOT NULL default '',
`notify_announcements` tinyint(4) NOT NULL default '1',
`notify_regularity` tinyint(4) NOT NULL default '1',
`notify_send_body` tinyint(4) NOT NULL default '0',
`notify_types` tinyint(4) NOT NULL default '2',
`member_ip` varchar(255) NOT NULL default '',
`member_ip2` varchar(255) NOT NULL default '',
`secret_question` varchar(255) NOT NULL default '',
`secret_answer` varchar(64) NOT NULL default '',
`id_theme` tinyint(4) unsigned NOT NULL default '0',
`is_activated` tinyint(3) unsigned NOT NULL default '1',
`validation_code` varchar(10) NOT NULL default '',
`id_msg_last_visit` int(10) unsigned NOT NULL default '0',
`additional_groups` varchar(255) NOT NULL default '',
`smiley_set` varchar(48) NOT NULL default '',
`id_post_group` smallint(5) unsigned NOT NULL default '0',
`total_time_logged_in` int(10) unsigned NOT NULL default '0',
`password_salt` varchar(255) NOT NULL default '',
`ignore_boards` text NOT NULL,
`warning` tinyint(4) NOT NULL default '0',
`passwd_flood` varchar(12) NOT NULL default '',
`pm_receive_from` tinyint(4) unsigned NOT NULL default '1',
PRIMARY KEY (`id_member`),
KEY `member_name` (`member_name`),
KEY `real_name` (`real_name`),
KEY `date_registered` (`date_registered`),
KEY `id_group` (`id_group`),
KEY `birthdate` (`birthdate`),
KEY `posts` (`posts`),
KEY `last_login` (`last_login`),
KEY `lngfile` (`lngfile`(30)),
KEY `id_post_group` (`id_post_group`),
KEY `warning` (`warning`),
KEY `total_time_logged_in` (`total_time_logged_in`),
KEY `id_theme` (`id_theme`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `members`
--
INSERT INTO `members` VALUES (1, 'clausmuus', 1374749808, 1, 1, '', 1374848919, 'clausmuus', 0, 0, 0, '', '', 0, '', '', 'f1f2ba3fa1ce041f28efeb95a5c934796c4eccf9', '', 'claus@minidvblinux.de', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 0, '', 0, 0, 0, '', 1, 1, 0, 2, '74.125.60.56', '74.125.60.56', '', '', 0, 1, '', 2, '', '', 4, 4851, 'e361', '', 0, '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `message_icons`
--
CREATE TABLE `message_icons` (
`id_icon` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(80) NOT NULL default '',
`filename` varchar(80) NOT NULL default '',
`id_board` smallint(5) unsigned NOT NULL default '0',
`icon_order` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`id_icon`),
KEY `id_board` (`id_board`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `message_icons`
--
INSERT INTO `message_icons` VALUES (1, 'Standard', 'xx', 0, 0);
INSERT INTO `message_icons` VALUES (2, 'Thumb Up', 'thumbup', 0, 1);
INSERT INTO `message_icons` VALUES (3, 'Thumb Down', 'thumbdown', 0, 2);
INSERT INTO `message_icons` VALUES (4, 'Exclamation point', 'exclamation', 0, 3);
INSERT INTO `message_icons` VALUES (5, 'Question mark', 'question', 0, 4);
INSERT INTO `message_icons` VALUES (6, 'Lamp', 'lamp', 0, 5);
INSERT INTO `message_icons` VALUES (7, 'Smiley', 'smiley', 0, 6);
INSERT INTO `message_icons` VALUES (8, 'Angry', 'angry', 0, 7);
INSERT INTO `message_icons` VALUES (9, 'Cheesy', 'cheesy', 0, 8);
INSERT INTO `message_icons` VALUES (10, 'Grin', 'grin', 0, 9);
INSERT INTO `message_icons` VALUES (11, 'Sad', 'sad', 0, 10);
INSERT INTO `message_icons` VALUES (12, 'Wink', 'wink', 0, 11);
-- --------------------------------------------------------
--
-- Table structure for table `messages`
--
CREATE TABLE `messages` (
`id_msg` int(10) unsigned NOT NULL auto_increment,
`id_topic` mediumint(8) unsigned NOT NULL default '0',
`id_board` smallint(5) unsigned NOT NULL default '0',
`poster_time` int(10) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`id_msg_modified` int(10) unsigned NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`poster_name` varchar(255) NOT NULL default '',
`poster_email` varchar(255) NOT NULL default '',
`poster_ip` varchar(255) NOT NULL default '',
`smileys_enabled` tinyint(4) NOT NULL default '1',
`modified_time` int(10) unsigned NOT NULL default '0',
`modified_name` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`icon` varchar(16) NOT NULL default 'xx',
`approved` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`id_msg`),
UNIQUE KEY `topic` (`id_topic`,`id_msg`),
UNIQUE KEY `id_board` (`id_board`,`id_msg`),
UNIQUE KEY `id_member` (`id_member`,`id_msg`),
KEY `approved` (`approved`),
KEY `ip_index` (`poster_ip`(15),`id_topic`),
KEY `participation` (`id_member`,`id_topic`),
KEY `show_posts` (`id_member`,`id_board`),
KEY `id_topic` (`id_topic`),
KEY `id_member_msg` (`id_member`,`approved`,`id_msg`),
KEY `current_topic` (`id_topic`,`id_msg`,`id_member`,`approved`),
KEY `related_ip` (`id_member`,`poster_ip`,`id_msg`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `messages`
--
INSERT INTO `messages` VALUES (1, 1, 1, 1374749649, 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);
INSERT INTO `messages` VALUES (2, 1, 1, 1374756213, 1, 2, 'Re: Welcome to SMF!', 'clausmuus', 'claus@minidvblinux.de', '172.30.250.73', 1, 0, '', 'Nur ein test', 'xx', 1);
-- --------------------------------------------------------
--
-- Table structure for table `moderators`
--
CREATE TABLE `moderators` (
`id_board` smallint(5) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id_board`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `moderators`
--
-- --------------------------------------------------------
--
-- Table structure for table `openid_assoc`
--
CREATE TABLE `openid_assoc` (
`server_url` text NOT NULL,
`handle` varchar(255) NOT NULL default '',
`secret` text NOT NULL,
`issued` int(10) NOT NULL default '0',
`expires` int(10) NOT NULL default '0',
`assoc_type` varchar(64) NOT NULL,
PRIMARY KEY (`server_url`(125),`handle`(125)),
KEY `expires` (`expires`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `openid_assoc`
--
-- --------------------------------------------------------
--
-- Table structure for table `package_servers`
--
CREATE TABLE `package_servers` (
`id_server` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_server`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `package_servers`
--
INSERT INTO `package_servers` VALUES (1, 'Simple Machines Third-party Mod Site', 'http://custom.simplemachines.org/packages/mods');
-- --------------------------------------------------------
--
-- Table structure for table `permission_profiles`
--
CREATE TABLE `permission_profiles` (
`id_profile` smallint(5) NOT NULL auto_increment,
`profile_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_profile`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `permission_profiles`
--
INSERT INTO `permission_profiles` VALUES (1, 'default');
INSERT INTO `permission_profiles` VALUES (2, 'no_polls');
INSERT INTO `permission_profiles` VALUES (3, 'reply_only');
INSERT INTO `permission_profiles` VALUES (4, 'read_only');
-- --------------------------------------------------------
--
-- Table structure for table `permissions`
--
CREATE TABLE `permissions` (
`id_group` smallint(5) NOT NULL default '0',
`permission` varchar(30) NOT NULL default '',
`add_deny` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id_group`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `permissions`
--
INSERT INTO `permissions` VALUES (-1, 'search_posts', 1);
INSERT INTO `permissions` VALUES (-1, 'calendar_view', 1);
INSERT INTO `permissions` VALUES (-1, 'view_stats', 1);
INSERT INTO `permissions` VALUES (-1, 'profile_view_any', 1);
INSERT INTO `permissions` VALUES (0, 'view_mlist', 1);
INSERT INTO `permissions` VALUES (0, 'search_posts', 1);
INSERT INTO `permissions` VALUES (0, 'profile_view_own', 1);
INSERT INTO `permissions` VALUES (0, 'profile_view_any', 1);
INSERT INTO `permissions` VALUES (0, 'pm_read', 1);
INSERT INTO `permissions` VALUES (0, 'pm_send', 1);
INSERT INTO `permissions` VALUES (0, 'calendar_view', 1);
INSERT INTO `permissions` VALUES (0, 'view_stats', 1);
INSERT INTO `permissions` VALUES (0, 'who_view', 1);
INSERT INTO `permissions` VALUES (0, 'profile_identity_own', 1);
INSERT INTO `permissions` VALUES (0, 'profile_extra_own', 1);
INSERT INTO `permissions` VALUES (0, 'profile_remove_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_upload_avatar', 1);
INSERT INTO `permissions` VALUES (0, 'profile_upload_avatar', 1);
INSERT INTO `permissions` VALUES (0, 'karma_edit', 1);
INSERT INTO `permissions` VALUES (2, 'view_mlist', 1);
INSERT INTO `permissions` VALUES (2, 'search_posts', 1);
INSERT INTO `permissions` VALUES (2, 'profile_view_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_view_any', 1);
INSERT INTO `permissions` VALUES (2, 'pm_read', 1);
INSERT INTO `permissions` VALUES (2, 'pm_send', 1);
INSERT INTO `permissions` VALUES (2, 'calendar_view', 1);
INSERT INTO `permissions` VALUES (2, 'view_stats', 1);
INSERT INTO `permissions` VALUES (2, 'who_view', 1);
INSERT INTO `permissions` VALUES (2, 'profile_identity_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_extra_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_remove_own', 1);
INSERT INTO `permissions` VALUES (2, 'profile_remote_avatar', 1);
INSERT INTO `permissions` VALUES (0, 'profile_remote_avatar', 1);
INSERT INTO `permissions` VALUES (2, 'profile_server_avatar', 1);
INSERT INTO `permissions` VALUES (2, 'profile_title_own', 1);
INSERT INTO `permissions` VALUES (2, 'calendar_post', 1);
INSERT INTO `permissions` VALUES (2, 'calendar_edit_any', 1);
INSERT INTO `permissions` VALUES (2, 'karma_edit', 1);
INSERT INTO `permissions` VALUES (2, 'access_mod_center', 1);
INSERT INTO `permissions` VALUES (0, 'profile_server_avatar', 1);
-- --------------------------------------------------------
--
-- Table structure for table `personal_messages`
--
CREATE TABLE `personal_messages` (
`id_pm` int(10) unsigned NOT NULL auto_increment,
`id_pm_head` int(10) unsigned NOT NULL default '0',
`id_member_from` mediumint(8) unsigned NOT NULL default '0',
`deleted_by_sender` tinyint(3) unsigned NOT NULL default '0',
`from_name` varchar(255) NOT NULL default '',
`msgtime` int(10) unsigned NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`body` text NOT NULL,
PRIMARY KEY (`id_pm`),
KEY `id_member` (`id_member_from`,`deleted_by_sender`),
KEY `msgtime` (`msgtime`),
KEY `id_pm_head` (`id_pm_head`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `personal_messages`
--
-- --------------------------------------------------------
--
-- Table structure for table `pm_recipients`
--
CREATE TABLE `pm_recipients` (
`id_pm` int(10) unsigned NOT NULL default '0',
`id_member` mediumint(8) unsigned NOT NULL default '0',
`labels` varchar(60) NOT NULL default '-1',
`bcc` tinyint(3) unsigned NOT NULL default '0',
`is_read` tinyint(3) unsigned NOT NULL default '0',
`is_new` tinyint(3) unsigned NOT NULL default '0',
`deleted` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id_pm`,`id_member`),
UNIQUE KEY `id_member` (`id_member`,`deleted`,`id_pm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `pm_recipients`
--
-- --------------------------------------------------------
--
-- Table structure for table `pm_rules`
--
CREATE TABLE `pm_rules` (
`id_rule` int(10) unsigned NOT NULL auto_increment,
`id_member` int(10) unsigned NOT NULL default '0',
`rule_name` varchar(60) NOT NULL,
`criteria` text NOT NULL,
`actions` text NOT NULL,
`delete_pm` tinyint(3) unsigned NOT NULL default '0',
`is_or` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id_rule`),
KEY `id_member` (`id_member`),
KEY `delete_pm` (`delete_pm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `pm_rules`
--
-- --------------------------------------------------------
--
-- Table structure for table `poll_choices`
--
CREATE TABLE `poll_choices` (
`id_poll` mediumint(8) unsigned NOT NULL default '0',
`id_choice` tinyint(3) unsigned NOT NULL default '0',
`label` varchar(255) NOT NULL default '',
`votes` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`id_poll`,`id_choice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `poll_choices`
--
-- --------------------------------------------------------
--
-- Table structure for table `polls`
--
CREATE TABLE `polls` (
`id_poll` mediumint(8) unsigned NOT NULL auto_increment,
`question` varchar(255) NOT NULL default '',
`voting_locked` tinyint(1) NOT NULL default '0',
`max_votes` tinyint(3) unsigned NOT NULL default '1',
`expire_time` int(10) unsigned NOT NULL default '0',
`hide_results` tinyint(3) unsigned NOT NULL default '0',
`change_vote` tinyint(3) unsigned NOT NULL default '0',
`guest_vote` tinyint(3) unsigned NOT NULL default '0',
`num_guest_voters` int(10) unsigned NOT NULL default '0',
`reset_poll` int(10) unsigned NOT NULL default '0',
`id_member` mediumint(8) NOT NULL default '0',
`poster_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_poll`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `polls`
--
-- --------------------------------------------------------
--
-- Table structure for table `scheduled_tasks`
--
CREATE TABLE `scheduled_tasks` (
`id_task` smallint(5) NOT NULL auto_increment,
`next_time` int(10) NOT NULL default '0',
`time_offset` int(10) NOT NULL default '0',
`time_regularity` smallint(5) NOT NULL default '0',
`time_unit` varchar(1) NOT NULL default 'h',
`disabled` tinyint(3) NOT NULL default '0',
`task` varchar(24) NOT NULL default '',
PRIMARY KEY (`id_task`),
UNIQUE KEY `task` (`task`),
KEY `next_time` (`next_time`),
KEY `disabled` (`disabled`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `scheduled_tasks`
--
INSERT INTO `scheduled_tasks` VALUES (1, 1374858000, 0, 2, 'h', 0, 'approval_notification');
INSERT INTO `scheduled_tasks` VALUES (2, 1375315200, 0, 7, 'd', 0, 'auto_optimize');
INSERT INTO `scheduled_tasks` VALUES (3, 1374966060, 60, 1, 'd', 0, 'daily_maintenance');
INSERT INTO `scheduled_tasks` VALUES (5, 1374966000, 0, 1, 'd', 0, 'daily_digest');
INSERT INTO `scheduled_tasks` VALUES (6, 1375315200, 0, 1, 'w', 0, 'weekly_digest');
INSERT INTO `scheduled_tasks` VALUES (7, 1374968040, 88451, 1, 'd', 0, 'fetchSMfiles');
INSERT INTO `scheduled_tasks` VALUES (8, 0, 0, 1, 'd', 1, 'birthdayemails');
INSERT INTO `scheduled_tasks` VALUES (9, 1375315200, 0, 1, 'w', 0, 'weekly_maintenance');
INSERT INTO `scheduled_tasks` VALUES (10, 0, 120, 1, 'd', 1, 'paid_subscriptions');
-- --------------------------------------------------------
--
-- Table structure for table `sessions`
--
CREATE TABLE `sessions` (
`session_id` char(32) NOT NULL,
`last_update` int(10) unsigned NOT NULL,
`data` text NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `sessions`
--
INSERT INTO `sessions` VALUES ('h2h277366hkjj1avogi2ujgn16', 1374756480, 'USER_AGENT|s:76:"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0";admin_time|i:1374754424;session_value|s:32:"5f97f2197707eff5ec4e3083a53c1cf2";session_var|s:9:"e8c478c81";id_msg_last_visit|s:1:"1";mc|a:7:{s:4:"time";i:1374756296;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";}rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1374749836;s:7:"reports";s:1:"0";}log_time|i:1374756480;timeOnlineUpdated|i:1374756455;unread_messages|i:0;old_url|s:110:"http://mld.claus.lbc/forum/index.php?action=admin;area=manageboards;e8c478c81=5f97f2197707eff5ec4e3083a53c1cf2";pack_ftp|a:1:{s:14:"original_perms";a:5:{s:79:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/default/languages";i:16895;s:76:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/core/languages";i:16895;s:76:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/default/images";i:16895;s:73:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/core/images";i:16895;s:54:"/usr/local/google/home/cmuus/Projects/mld/htdocs/forum";i:16895;}}visual_verification_code|s:6:"MTPBDE";last_read_topic|i:1;forms|a:1:{i:0;i:1760100;}temp_attachments|a:0:{}');
INSERT INTO `sessions` VALUES ('rjbpj2pgtj4i3t5vqfqest44q7', 1374848194, 'session_value|s:32:"3e4af741826d93ee80f4146b81d4f875";session_var|s:10:"b51b2c0ed8";id_msg_last_visit|s:1:"1";mc|a:7:{s:4:"time";i:1374848194;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";}rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1374848194;s:7:"reports";s:1:"0";}log_time|i:1374848194;timeOnlineUpdated|i:1374848194;unread_messages|i:0;old_url|s:33:"http://new.minidvblinux.de/forum/";USER_AGENT|s:76:"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0";');
INSERT INTO `sessions` VALUES ('h06f85tjp81mt2qrphjlomhgc2', 1374848961, 'session_value|s:32:"39afd01e5096a2c7c68d84eca165bd75";session_var|s:11:"a4bb6979978";mc|a:7:{s:4:"time";i:1374848676;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:1374848272;s:9:"id_member";i:0;s:2:"ip";s:12:"74.125.60.56";s:3:"ip2";s:12:"74.125.60.56";s:5:"email";s:0:"";}log_time|i:1374848960;timeOnlineUpdated|i:1374848919;old_url|s:33:"http://new.minidvblinux.de/forum/";USER_AGENT|s:76:"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0";login_SMFCookie661|s:95:"a:4:{i:0;s:1:"1";i:1;s:40:"b904739b3deea3f5139bdb573d48835051ea2afc";i:2;i:1564064272;i:3;i:0;}";admin_time|i:1374848272;id_msg_last_visit|s:1:"1";rc|a:3:{s:2:"id";s:1:"1";s:4:"time";i:1374848272;s:7:"reports";s:1:"0";}unread_messages|i:0;');
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`variable` varchar(255) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (`variable`(30))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` VALUES ('smfVersion', '2.0.4');
INSERT INTO `settings` VALUES ('news', 'SMF - Just Installed!');
INSERT INTO `settings` VALUES ('compactTopicPagesContiguous', '5');
INSERT INTO `settings` VALUES ('compactTopicPagesEnable', '1');
INSERT INTO `settings` VALUES ('enableStickyTopics', '1');
INSERT INTO `settings` VALUES ('todayMod', '1');
INSERT INTO `settings` VALUES ('karmaMode', '0');
INSERT INTO `settings` VALUES ('karmaTimeRestrictAdmins', '1');
INSERT INTO `settings` VALUES ('enablePreviousNext', '1');
INSERT INTO `settings` VALUES ('pollMode', '1');
INSERT INTO `settings` VALUES ('enableVBStyleLogin', '1');
INSERT INTO `settings` VALUES ('enableCompressedOutput', '1');
INSERT INTO `settings` VALUES ('karmaWaitTime', '1');
INSERT INTO `settings` VALUES ('karmaMinPosts', '0');
INSERT INTO `settings` VALUES ('karmaLabel', 'Karma:');
INSERT INTO `settings` VALUES ('karmaSmiteLabel', '[smite]');
INSERT INTO `settings` VALUES ('karmaApplaudLabel', '[applaud]');
INSERT INTO `settings` VALUES ('attachmentSizeLimit', '1000');
INSERT INTO `settings` VALUES ('attachmentPostLimit', '1000');
INSERT INTO `settings` VALUES ('attachmentNumPerPostLimit', '4');
INSERT INTO `settings` VALUES ('attachmentDirSizeLimit', '100000');
INSERT INTO `settings` VALUES ('attachmentUploadDir', '../../data/forum/attachments');
INSERT INTO `settings` VALUES ('attachmentExtensions', 'doc,gif,jpg,mpg,pdf,png,txt,zip');
INSERT INTO `settings` VALUES ('attachmentCheckExtensions', '0');
INSERT INTO `settings` VALUES ('attachmentShowImages', '1');
INSERT INTO `settings` VALUES ('attachmentEnable', '1');
INSERT INTO `settings` VALUES ('attachmentEncryptFilenames', '1');
INSERT INTO `settings` VALUES ('attachmentThumbnails', '1');
INSERT INTO `settings` VALUES ('attachmentThumbWidth', '150');
INSERT INTO `settings` VALUES ('attachmentThumbHeight', '150');
INSERT INTO `settings` VALUES ('censorIgnoreCase', '1');
INSERT INTO `settings` VALUES ('mostOnline', '2');
INSERT INTO `settings` VALUES ('mostOnlineToday', '2');
INSERT INTO `settings` VALUES ('mostDate', '1374848265');
INSERT INTO `settings` VALUES ('allow_disableAnnounce', '1');
INSERT INTO `settings` VALUES ('trackStats', '1');
INSERT INTO `settings` VALUES ('userLanguage', '1');
INSERT INTO `settings` VALUES ('titlesEnable', '1');
INSERT INTO `settings` VALUES ('topicSummaryPosts', '15');
INSERT INTO `settings` VALUES ('enableErrorLogging', '1');
INSERT INTO `settings` VALUES ('max_image_width', '300');
INSERT INTO `settings` VALUES ('max_image_height', '300');
INSERT INTO `settings` VALUES ('onlineEnable', '0');
INSERT INTO `settings` VALUES ('cal_enabled', '0');
INSERT INTO `settings` VALUES ('cal_maxyear', '2020');
INSERT INTO `settings` VALUES ('cal_minyear', '2008');
INSERT INTO `settings` VALUES ('cal_daysaslink', '0');
INSERT INTO `settings` VALUES ('cal_defaultboard', '');
INSERT INTO `settings` VALUES ('cal_showholidays', '1');
INSERT INTO `settings` VALUES ('cal_showbdays', '1');
INSERT INTO `settings` VALUES ('cal_showevents', '1');
INSERT INTO `settings` VALUES ('cal_showweeknum', '0');
INSERT INTO `settings` VALUES ('cal_maxspan', '7');
INSERT INTO `settings` VALUES ('smtp_host', '');
INSERT INTO `settings` VALUES ('smtp_port', '25');
INSERT INTO `settings` VALUES ('smtp_username', '');
INSERT INTO `settings` VALUES ('smtp_password', '');
INSERT INTO `settings` VALUES ('mail_type', '0');
INSERT INTO `settings` VALUES ('timeLoadPageEnable', '0');
INSERT INTO `settings` VALUES ('totalMembers', '1');
INSERT INTO `settings` VALUES ('totalTopics', '1');
INSERT INTO `settings` VALUES ('totalMessages', '2');
INSERT INTO `settings` VALUES ('simpleSearch', '0');
INSERT INTO `settings` VALUES ('censor_vulgar', '');
INSERT INTO `settings` VALUES ('censor_proper', '');
INSERT INTO `settings` VALUES ('enablePostHTML', '0');
INSERT INTO `settings` VALUES ('theme_allow', '0');
INSERT INTO `settings` VALUES ('theme_default', '1');
INSERT INTO `settings` VALUES ('theme_guests', '1');
INSERT INTO `settings` VALUES ('enableEmbeddedFlash', '0');
INSERT INTO `settings` VALUES ('xmlnews_enable', '1');
INSERT INTO `settings` VALUES ('xmlnews_maxlen', '255');
INSERT INTO `settings` VALUES ('hotTopicPosts', '15');
INSERT INTO `settings` VALUES ('hotTopicVeryPosts', '25');
INSERT INTO `settings` VALUES ('registration_method', '2');
INSERT INTO `settings` VALUES ('send_validation_onChange', '0');
INSERT INTO `settings` VALUES ('send_welcomeEmail', '1');
INSERT INTO `settings` VALUES ('allow_editDisplayName', '1');
INSERT INTO `settings` VALUES ('allow_hideOnline', '1');
INSERT INTO `settings` VALUES ('guest_hideContacts', '1');
INSERT INTO `settings` VALUES ('spamWaitTime', '5');
INSERT INTO `settings` VALUES ('pm_spam_settings', '10,5,20');
INSERT INTO `settings` VALUES ('reserveWord', '0');
INSERT INTO `settings` VALUES ('reserveCase', '1');
INSERT INTO `settings` VALUES ('reserveUser', '1');
INSERT INTO `settings` VALUES ('reserveName', '1');
INSERT INTO `settings` VALUES ('reserveNames', 'Admin\nWebmaster\nGuest\nroot');
INSERT INTO `settings` VALUES ('autoLinkUrls', '1');
INSERT INTO `settings` VALUES ('banLastUpdated', '0');
INSERT INTO `settings` VALUES ('smileys_dir', 'Smileys');
INSERT INTO `settings` VALUES ('smileys_url', 'http://new.minidvblinux.de/forum/Smileys');
INSERT INTO `settings` VALUES ('avatar_directory', 'avatars');
INSERT INTO `settings` VALUES ('avatar_url', 'http://new.minidvblinux.de/forum/avatars');
INSERT INTO `settings` VALUES ('avatar_max_height_external', '100');
INSERT INTO `settings` VALUES ('avatar_max_width_external', '150');
INSERT INTO `settings` VALUES ('avatar_action_too_large', 'option_html_resize');
INSERT INTO `settings` VALUES ('avatar_max_height_upload', '100');
INSERT INTO `settings` VALUES ('avatar_max_width_upload', '150');
INSERT INTO `settings` VALUES ('avatar_resize_upload', '1');
INSERT INTO `settings` VALUES ('avatar_download_png', '1');
INSERT INTO `settings` VALUES ('failed_login_threshold', '3');
INSERT INTO `settings` VALUES ('oldTopicDays', '120');
INSERT INTO `settings` VALUES ('edit_wait_time', '90');
INSERT INTO `settings` VALUES ('edit_disable_time', '0');
INSERT INTO `settings` VALUES ('autoFixDatabase', '1');
INSERT INTO `settings` VALUES ('allow_guestAccess', '1');
INSERT INTO `settings` VALUES ('time_format', '%B %d, %Y, %I:%M:%S %p');
INSERT INTO `settings` VALUES ('number_format', '1234.00');
INSERT INTO `settings` VALUES ('enableBBC', '1');
INSERT INTO `settings` VALUES ('max_messageLength', '20000');
INSERT INTO `settings` VALUES ('signature_settings', '1,300,10,0,0,300,30,0:');
INSERT INTO `settings` VALUES ('autoOptMaxOnline', '0');
INSERT INTO `settings` VALUES ('defaultMaxMessages', '15');
INSERT INTO `settings` VALUES ('defaultMaxTopics', '20');
INSERT INTO `settings` VALUES ('defaultMaxMembers', '30');
INSERT INTO `settings` VALUES ('enableParticipation', '1');
INSERT INTO `settings` VALUES ('recycle_enable', '0');
INSERT INTO `settings` VALUES ('recycle_board', '0');
INSERT INTO `settings` VALUES ('maxMsgID', '2');
INSERT INTO `settings` VALUES ('enableAllMessages', '0');
INSERT INTO `settings` VALUES ('fixLongWords', '0');
INSERT INTO `settings` VALUES ('knownThemes', '1,2');
INSERT INTO `settings` VALUES ('who_enabled', '1');
INSERT INTO `settings` VALUES ('time_offset', '0');
INSERT INTO `settings` VALUES ('cookieTime', '60');
INSERT INTO `settings` VALUES ('lastActive', '15');
INSERT INTO `settings` VALUES ('smiley_sets_known', 'default,aaron,akyhne');
INSERT INTO `settings` VALUES ('smiley_sets_names', 'Alienine''s Set\nAaron''s Set\nAkyhne''s Set');
INSERT INTO `settings` VALUES ('smiley_sets_default', 'default');
INSERT INTO `settings` VALUES ('cal_days_for_index', '7');
INSERT INTO `settings` VALUES ('requireAgreement', '1');
INSERT INTO `settings` VALUES ('unapprovedMembers', '0');
INSERT INTO `settings` VALUES ('default_personal_text', '');
INSERT INTO `settings` VALUES ('package_make_backups', '1');
INSERT INTO `settings` VALUES ('databaseSession_enable', '1');
INSERT INTO `settings` VALUES ('databaseSession_loose', '1');
INSERT INTO `settings` VALUES ('databaseSession_lifetime', '2880');
INSERT INTO `settings` VALUES ('search_cache_size', '50');
INSERT INTO `settings` VALUES ('search_results_per_page', '30');
INSERT INTO `settings` VALUES ('search_weight_frequency', '30');
INSERT INTO `settings` VALUES ('search_weight_age', '25');
INSERT INTO `settings` VALUES ('search_weight_length', '20');
INSERT INTO `settings` VALUES ('search_weight_subject', '15');
INSERT INTO `settings` VALUES ('search_weight_first_message', '10');
INSERT INTO `settings` VALUES ('search_max_results', '1200');
INSERT INTO `settings` VALUES ('search_floodcontrol_time', '5');
INSERT INTO `settings` VALUES ('permission_enable_deny', '0');
INSERT INTO `settings` VALUES ('permission_enable_postgroups', '0');
INSERT INTO `settings` VALUES ('mail_next_send', '0');
INSERT INTO `settings` VALUES ('mail_recent', '0000000000|0');
INSERT INTO `settings` VALUES ('settings_updated', '1374848672');
INSERT INTO `settings` VALUES ('next_task_time', '1374858000');
INSERT INTO `settings` VALUES ('warning_settings', '1,20,0');
INSERT INTO `settings` VALUES ('warning_watch', '10');
INSERT INTO `settings` VALUES ('warning_moderate', '35');
INSERT INTO `settings` VALUES ('warning_mute', '60');
INSERT INTO `settings` VALUES ('admin_features', '');
INSERT INTO `settings` VALUES ('last_mod_report_action', '0');
INSERT INTO `settings` VALUES ('pruningOptions', '30,180,180,180,30,0');
INSERT INTO `settings` VALUES ('cache_enable', '1');
INSERT INTO `settings` VALUES ('reg_verification', '1');
INSERT INTO `settings` VALUES ('visual_verification_type', '3');
INSERT INTO `settings` VALUES ('enable_buddylist', '1');
INSERT INTO `settings` VALUES ('birthday_email', 'happy_birthday');
INSERT INTO `settings` VALUES ('dont_repeat_theme_core', '1');
INSERT INTO `settings` VALUES ('dont_repeat_smileys_20', '1');
INSERT INTO `settings` VALUES ('dont_repeat_buddylists', '1');
INSERT INTO `settings` VALUES ('attachment_image_reencode', '1');
INSERT INTO `settings` VALUES ('attachment_image_paranoid', '0');
INSERT INTO `settings` VALUES ('attachment_thumb_png', '1');
INSERT INTO `settings` VALUES ('avatar_reencode', '1');
INSERT INTO `settings` VALUES ('avatar_paranoid', '0');
INSERT INTO `settings` VALUES ('global_character_set', 'UTF-8');
INSERT INTO `settings` VALUES ('default_timezone', 'Europe/Berlin');
INSERT INTO `settings` VALUES ('memberlist_updated', '1374756310');
INSERT INTO `settings` VALUES ('latestMember', '1');
INSERT INTO `settings` VALUES ('latestRealName', 'clausmuus');
INSERT INTO `settings` VALUES ('rand_seed', '1391663873');
INSERT INTO `settings` VALUES ('mostOnlineUpdated', '2013-07-26');
INSERT INTO `settings` VALUES ('queryless_urls', '1');
INSERT INTO `settings` VALUES ('hitStats', '1');
INSERT INTO `settings` VALUES ('enableReportPM', '1');
INSERT INTO `settings` VALUES ('calendar_updated', '1374756310');
-- --------------------------------------------------------
--
-- Table structure for table `smileys`
--
CREATE TABLE `smileys` (
`id_smiley` smallint(5) unsigned NOT NULL auto_increment,
`code` varchar(30) NOT NULL default '',
`filename` varchar(48) NOT NULL default '',
`description` varchar(80) NOT NULL default '',
`smiley_row` tinyint(4) unsigned NOT NULL default '0',
`smiley_order` smallint(5) unsigned NOT NULL default '0',
`hidden` tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`id_smiley`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
--
-- Dumping data for table `smileys`
--
INSERT INTO `smileys` VALUES (1, ':)', 'smiley.gif', 'Smiley', 0, 0, 0);
INSERT INTO `smileys` VALUES (2, ';)', 'wink.gif', 'Wink', 0, 1, 0);
INSERT INTO `smileys` VALUES (3, ':D', 'cheesy.gif', 'Cheesy', 0, 2, 0);
INSERT INTO `smileys` VALUES (4, ';D', 'grin.gif', 'Grin', 0, 3, 0);
INSERT INTO `smileys` VALUES (5, '>:(', 'angry.gif', 'Angry', 0, 4, 0);
INSERT INTO `smileys` VALUES (6, ':(', 'sad.gif', 'Sad', 0, 5, 0);
INSERT INTO `smileys` VALUES (7, ':o', 'shocked.gif', 'Shocked', 0, 6, 0);
INSERT INTO `smileys` VALUES (8, '8)', 'cool.gif', 'Cool', 0, 7, 0);
INSERT INTO `smileys` VALUES (9, '???', 'huh.gif', 'Huh?', 0, 8, 0);
INSERT INTO `smileys` VALUES (10, '::)', 'rolleyes.gif', 'Roll Eyes', 0, 9, 0);
INSERT INTO `smileys` VALUES (11, ':P', 'tongue.gif', 'Tongue', 0, 10, 0);
INSERT INTO `smileys` VALUES (12, ':-[', 'embarrassed.gif', 'Embarrassed', 0, 11, 0);
INSERT INTO `smileys` VALUES (13, ':-X', 'lipsrsealed.gif', 'Lips Sealed', 0, 12, 0);
INSERT INTO `smileys` VALUES (14, ':-\\', 'undecided.gif', 'Undecided', 0, 13, 0);
INSERT INTO `smileys` VALUES (15, ':-*', 'kiss.gif', 'Kiss', 0, 14, 0);
INSERT INTO `smileys` VALUES (16, ':''(', 'cry.gif', 'Cry', 0, 15, 0);
INSERT INTO `smileys` VALUES (17, '>:D', 'evil.gif', 'Evil', 0, 16, 1);
INSERT INTO `smileys` VALUES (18, '^-^', 'azn.gif', 'Azn', 0, 17, 1);
INSERT INTO `smileys` VALUES (19, 'O0', 'afro.gif', 'Afro', 0, 18, 1);
INSERT INTO `smileys` VALUES (20, ':))', 'laugh.gif', 'Laugh', 0, 19, 1);
INSERT INTO `smileys` VALUES (21, 'C:-)', 'police.gif', 'Police', 0, 20, 1);
INSERT INTO `smileys` VALUES (22, 'O:-)', 'angel.gif', 'Angel', 0, 21, 1);
-- --------------------------------------------------------
--
-- Table structure for table `spiders`
--
CREATE TABLE `spiders` (
`id_spider` smallint(5) unsigned NOT NULL auto_increment,
`spider_name` varchar(255) NOT NULL default '',
`user_agent` varchar(255) NOT NULL default '',
`ip_info` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_spider`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
--
-- Dumping data for table `spiders`
--
INSERT INTO `spiders` VALUES (1, 'Google', 'googlebot', '');
INSERT INTO `spiders` VALUES (2, 'Yahoo!', 'slurp', '');
INSERT INTO `spiders` VALUES (3, 'MSN', 'msnbot', '');
INSERT INTO `spiders` VALUES (4, 'Google (Mobile)', 'Googlebot-Mobile', '');
INSERT INTO `spiders` VALUES (5, 'Google (Image)', 'Googlebot-Image', '');
INSERT INTO `spiders` VALUES (6, 'Google (AdSense)', 'Mediapartners-Google', '');
INSERT INTO `spiders` VALUES (7, 'Google (Adwords)', 'AdsBot-Google', '');
INSERT INTO `spiders` VALUES (8, 'Yahoo! (Mobile)', 'YahooSeeker/M1A1-R2D2', '');
INSERT INTO `spiders` VALUES (9, 'Yahoo! (Image)', 'Yahoo-MMCrawler', '');
INSERT INTO `spiders` VALUES (10, 'MSN (Mobile)', 'MSNBOT_Mobile', '');
INSERT INTO `spiders` VALUES (11, 'MSN (Media)', 'msnbot-media', '');
INSERT INTO `spiders` VALUES (12, 'Cuil', 'twiceler', '');
INSERT INTO `spiders` VALUES (13, 'Ask', 'Teoma', '');
INSERT INTO `spiders` VALUES (14, 'Baidu', 'Baiduspider', '');
INSERT INTO `spiders` VALUES (15, 'Gigablast', 'Gigabot', '');
INSERT INTO `spiders` VALUES (16, 'InternetArchive', 'ia_archiver-web.archive.org', '');
INSERT INTO `spiders` VALUES (17, 'Alexa', 'ia_archiver', '');
INSERT INTO `spiders` VALUES (18, 'Omgili', 'omgilibot', '');
INSERT INTO `spiders` VALUES (19, 'EntireWeb', 'Speedy Spider', '');
-- --------------------------------------------------------
--
-- Table structure for table `subscriptions`
--
CREATE TABLE `subscriptions` (
`id_subscribe` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`cost` text NOT NULL,
`length` varchar(6) NOT NULL default '',
`id_group` smallint(5) NOT NULL default '0',
`add_groups` varchar(40) NOT NULL default '',
`active` tinyint(3) NOT NULL default '1',
`repeatable` tinyint(3) NOT NULL default '0',
`allow_partial` tinyint(3) NOT NULL default '0',
`reminder` tinyint(3) NOT NULL default '0',
`email_complete` text NOT NULL,
PRIMARY KEY (`id_subscribe`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `subscriptions`
--
-- --------------------------------------------------------
--
-- Table structure for table `themes`
--
CREATE TABLE `themes` (
`id_member` mediumint(8) NOT NULL default '0',
`id_theme` tinyint(4) unsigned NOT NULL default '1',
`variable` varchar(255) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (`id_theme`,`id_member`,`variable`(30)),
KEY `id_member` (`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `themes`
--
INSERT INTO `themes` VALUES (0, 1, 'name', 'SMF Default Theme - Curve');
INSERT INTO `themes` VALUES (0, 1, 'theme_url', 'http://new.minidvblinux.de/forum/Themes/default');
INSERT INTO `themes` VALUES (0, 1, 'images_url', 'http://new.minidvblinux.de/forum/Themes/default/images');
INSERT INTO `themes` VALUES (0, 1, 'theme_dir', '/srv/vhosts/www.minidvblinux.de/htdocs/forum/Themes/default');
INSERT INTO `themes` VALUES (0, 1, 'show_bbc', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_latest_member', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_modify', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_user_images', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_blurb', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_gender', '0');
INSERT INTO `themes` VALUES (0, 1, 'show_newsfader', '0');
INSERT INTO `themes` VALUES (0, 1, 'number_recent_posts', '10');
INSERT INTO `themes` VALUES (0, 1, 'show_member_bar', '1');
INSERT INTO `themes` VALUES (0, 1, 'linktree_link', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_profile_buttons', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_mark_read', '1');
INSERT INTO `themes` VALUES (0, 1, 'show_stats_index', '1');
INSERT INTO `themes` VALUES (0, 1, 'linktree_inline', '0');
INSERT INTO `themes` VALUES (0, 1, 'show_board_desc', '1');
INSERT INTO `themes` VALUES (0, 1, 'newsfader_time', '5000');
INSERT INTO `themes` VALUES (0, 1, 'allow_no_censored', '0');
INSERT INTO `themes` VALUES (0, 1, 'additional_options_collapsable', '1');
INSERT INTO `themes` VALUES (0, 1, 'use_image_buttons', '1');
INSERT INTO `themes` VALUES (0, 1, 'enable_news', '1');
INSERT INTO `themes` VALUES (0, 1, 'forum_width', '100%');
INSERT INTO `themes` VALUES (0, 2, 'name', 'Core Theme');
INSERT INTO `themes` VALUES (0, 2, 'theme_url', 'http://mld.claus.lbc/forum/Themes/core');
INSERT INTO `themes` VALUES (0, 2, 'images_url', 'http://mld.claus.lbc/forum/Themes/core/images');
INSERT INTO `themes` VALUES (0, 2, 'theme_dir', '/usr/local/google/home/cmuus/Projects/mld/htdocs/forum/Themes/core');
INSERT INTO `themes` VALUES (-1, 1, 'display_quick_reply', '1');
INSERT INTO `themes` VALUES (-1, 1, 'posts_apply_ignore_list', '1');
INSERT INTO `themes` VALUES (0, 1, 'header_logo_url', '');
INSERT INTO `themes` VALUES (0, 1, 'site_slogan', '');
INSERT INTO `themes` VALUES (0, 1, 'smiley_sets_default', '');
INSERT INTO `themes` VALUES (0, 1, 'show_group_key', '0');
INSERT INTO `themes` VALUES (0, 1, 'display_who_viewing', '0');
INSERT INTO `themes` VALUES (0, 1, 'hide_post_group', '0');
-- --------------------------------------------------------
--
-- Table structure for table `topics`
--
CREATE TABLE `topics` (
`id_topic` mediumint(8) unsigned NOT NULL auto_increment,
`is_sticky` tinyint(4) NOT NULL default '0',
`id_board` smallint(5) unsigned NOT NULL default '0',
`id_first_msg` int(10) unsigned NOT NULL default '0',
`id_last_msg` int(10) unsigned NOT NULL default '0',
`id_member_started` mediumint(8) unsigned NOT NULL default '0',
`id_member_updated` mediumint(8) unsigned NOT NULL default '0',
`id_poll` mediumint(8) unsigned NOT NULL default '0',
`id_previous_board` smallint(5) NOT NULL default '0',
`id_previous_topic` mediumint(8) NOT NULL default '0',
`num_replies` int(10) unsigned NOT NULL default '0',
`num_views` int(10) unsigned NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
`unapproved_posts` smallint(5) NOT NULL default '0',
`approved` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`id_topic`),
UNIQUE KEY `last_message` (`id_last_msg`,`id_board`),
UNIQUE KEY `first_message` (`id_first_msg`,`id_board`),
UNIQUE KEY `poll` (`id_poll`,`id_topic`),
KEY `is_sticky` (`is_sticky`),
KEY `approved` (`approved`),
KEY `id_board` (`id_board`),
KEY `member_started` (`id_member_started`,`id_board`),
KEY `last_message_sticky` (`id_board`,`is_sticky`,`id_last_msg`),
KEY `board_news` (`id_board`,`id_first_msg`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `topics`
--
INSERT INTO `topics` VALUES (1, 0, 1, 1, 2, 0, 1, 0, 0, 0, 1, 2, 0, 0, 1);
\\\n 
\\\n 
\\\r\n