INSERT INTO `module` (`module_id`, `is_configurable`, `name`, `title`, `description`, `admin_uri`, `icon`, `maintainers`, `version`, `license`, `state`) VALUES ({SGL_NEXT_ID}, 1, 'smfweb', 'Smfweb', 'SMF Module', '', '48/module_default.png', 'RV Global Soft Teams', '20070816', 'RV Global Soft', 'Stable');

SELECT @moduleId := MAX(module_id) FROM module;

REPLACE INTO `smfweb_boards` (`ID_BOARD`, `ID_CAT`, `childLevel`, `ID_PARENT`, `boardOrder`, `ID_LAST_MSG`, `ID_MSG_UPDATED`, `memberGroups`, `name`, `description`, `numTopics`, `numPosts`, `countPosts`, `ID_THEME`, `permission_mode`, `override_theme`) VALUES(1, 1, 0, 0, 1, 1, 1, '-1,0', 'General Discussion', 'Feel free to talk about anything and everything in this board.', 1, 1, 0, 0, 0, 0);

REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(-1, 0, 'poll_view', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'remove_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'lock_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'mark_any_notify', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'mark_notify', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'modify_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'poll_add_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'poll_edit_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'poll_lock_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'poll_post', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'poll_view', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'poll_vote', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'post_attachment', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'post_new', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'post_reply_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'post_reply_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'delete_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'report_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'send_topic', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(0, 0, 'view_attachments', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'moderate_board', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'post_new', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'post_reply_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'post_reply_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'poll_post', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'poll_add_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'poll_remove_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'poll_view', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'poll_vote', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'poll_edit_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'report_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'lock_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'send_topic', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'mark_any_notify', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'mark_notify', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'delete_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'modify_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'make_sticky', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'lock_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'remove_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'move_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'merge_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'split_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'delete_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(2, 0, 'modify_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'moderate_board', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'post_new', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'post_reply_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'post_reply_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'poll_post', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'poll_add_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'poll_remove_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'poll_view', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'poll_vote', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'report_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'lock_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'send_topic', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'mark_any_notify', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'mark_notify', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'delete_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'modify_own', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'make_sticky', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'lock_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'remove_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'move_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'merge_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'split_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'delete_any', 1);
REPLACE INTO `smfweb_board_permissions` (`ID_GROUP`, `ID_BOARD`, `permission`, `addDeny`) VALUES(3, 0, 'modify_any', 1);

REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(1, '0004-01-01', 'New Year''s');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(2, '0004-12-25', 'Christmas');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(3, '0004-02-14', 'Valentine''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(4, '0004-03-17', 'St. Patrick''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(5, '0004-04-01', 'April Fools');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(6, '0004-04-22', 'Earth Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(7, '0004-10-24', 'United Nations Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(8, '0004-10-31', 'Halloween');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(9, '2004-05-09', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(10, '2005-05-08', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(11, '2006-05-14', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(12, '2007-05-13', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(13, '2008-05-11', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(14, '2009-05-10', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(15, '2010-05-09', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(16, '2011-05-08', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(17, '2012-05-13', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(18, '2013-05-12', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(19, '2014-05-11', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(20, '2015-05-10', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(21, '2016-05-08', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(22, '2017-05-14', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(23, '2018-05-13', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(24, '2019-05-12', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(25, '2020-05-10', 'Mother''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(26, '2004-06-20', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(27, '2005-06-19', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(28, '2006-06-18', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(29, '2007-06-17', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(30, '2008-06-15', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(31, '2009-06-21', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(32, '2010-06-20', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(33, '2011-06-19', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(34, '2012-06-17', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(35, '2013-06-16', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(36, '2014-06-15', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(37, '2015-06-21', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(38, '2016-06-19', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(39, '2017-06-18', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(40, '2018-06-17', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(41, '2019-06-16', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(42, '2020-06-21', 'Father''s Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(43, '2004-06-20', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(44, '2005-06-20', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(45, '2006-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(46, '2007-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(47, '2008-06-20', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(48, '2009-06-20', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(49, '2010-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(50, '2011-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(51, '2012-06-20', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(52, '2013-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(53, '2014-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(54, '2015-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(55, '2016-06-20', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(56, '2017-06-20', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(57, '2018-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(58, '2019-06-21', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(59, '2020-06-20', 'Summer Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(60, '2004-03-19', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(61, '2005-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(62, '2006-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(63, '2007-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(64, '2008-03-19', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(65, '2009-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(66, '2010-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(67, '2011-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(68, '2012-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(69, '2013-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(70, '2014-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(71, '2015-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(72, '2016-03-19', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(73, '2017-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(74, '2018-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(75, '2019-03-20', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(76, '2020-03-19', 'Vernal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(77, '2004-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(78, '2005-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(79, '2006-12-22', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(80, '2007-12-22', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(81, '2008-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(82, '2009-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(83, '2010-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(84, '2011-12-22', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(85, '2012-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(86, '2013-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(87, '2014-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(88, '2015-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(89, '2016-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(90, '2017-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(91, '2018-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(92, '2019-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(93, '2020-12-21', 'Winter Solstice');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(94, '2004-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(95, '2005-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(96, '2006-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(97, '2007-09-23', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(98, '2008-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(99, '2009-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(100, '2010-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(101, '2011-09-23', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(102, '2012-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(103, '2013-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(104, '2014-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(105, '2015-09-23', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(106, '2016-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(107, '2017-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(108, '2018-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(109, '2019-09-23', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(110, '2020-09-22', 'Autumnal Equinox');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(111, '0004-07-04', 'Independence Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(112, '0004-05-05', 'Cinco de Mayo');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(113, '0004-06-14', 'Flag Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(114, '0004-11-11', 'Veterans Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(115, '0004-02-02', 'Groundhog Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(116, '2004-11-25', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(117, '2005-11-24', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(118, '2006-11-23', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(119, '2007-11-22', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(120, '2008-11-27', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(121, '2009-11-26', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(122, '2010-11-25', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(123, '2011-11-24', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(124, '2012-11-22', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(125, '2013-11-21', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(126, '2014-11-20', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(127, '2015-11-26', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(128, '2016-11-24', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(129, '2017-11-23', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(130, '2018-11-22', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(131, '2019-11-21', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(132, '2020-11-26', 'Thanksgiving');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(133, '2004-05-31', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(134, '2005-05-30', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(135, '2006-05-29', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(136, '2007-05-28', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(137, '2008-05-26', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(138, '2009-05-25', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(139, '2010-05-31', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(140, '2011-05-30', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(141, '2012-05-28', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(142, '2013-05-27', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(143, '2014-05-26', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(144, '2015-05-25', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(145, '2016-05-30', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(146, '2017-05-29', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(147, '2018-05-28', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(148, '2019-05-27', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(149, '2020-05-25', 'Memorial Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(150, '2004-09-06', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(151, '2005-09-05', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(152, '2006-09-04', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(153, '2007-09-03', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(154, '2008-09-01', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(155, '2009-09-07', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(156, '2010-09-06', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(157, '2011-09-05', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(158, '2012-09-03', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(159, '2013-09-09', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(160, '2014-09-08', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(161, '2015-09-07', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(162, '2016-09-05', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(163, '2017-09-04', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(164, '2018-09-03', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(165, '2019-09-09', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(166, '2020-09-07', 'Labor Day');
REPLACE INTO `smfweb_calendar_holidays` (`ID_HOLIDAY`, `eventDate`, `title`) VALUES(167, '0004-06-06', 'D-Day');

REPLACE INTO `smfweb_categories` (`ID_CAT`, `catOrder`, `name`, `canCollapse`) VALUES(1, 0, 'General Category', 1);

REPLACE INTO `smfweb_log_activity` (`date`, `hits`, `topics`, `posts`, `registers`, `mostOn`) VALUES('2008-08-07', 0, 0, 0, 0, 1);

REPLACE INTO `smfweb_log_online` (`session`, `logTime`, `ID_MEMBER`, `ip`, `url`) VALUES('f63059f9be6165ef283f171bb668e429', '2008-08-07 17:13:57', 1, 3232235925, 'a:1:{s:10:"USER_AGENT";s:111:"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.3) Gecko/20070310 Firefox/2.0.0.3 (Debian-2.0.0.3-1thai1.tle1)";}');

REPLACE INTO `smfweb_log_search_subjects` (`word`, `ID_TOPIC`) VALUES('smf', 1);
REPLACE INTO `smfweb_log_search_subjects` (`word`, `ID_TOPIC`) VALUES('to', 1);
REPLACE INTO `smfweb_log_search_subjects` (`word`, `ID_TOPIC`) VALUES('welcome', 1);

REPLACE INTO `smfweb_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES(1, 'Administrator', '#FF0000', -1, 0, '5#staradmin.gif');
REPLACE INTO `smfweb_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES(2, 'Global Moderator', '#0000FF', -1, 0, '5#stargmod.gif');
REPLACE INTO `smfweb_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES(3, 'Moderator', '', -1, 0, '5#starmod.gif');
REPLACE INTO `smfweb_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES(4, 'Newbie', '', 0, 0, '1#star.gif');
REPLACE INTO `smfweb_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES(5, 'Jr. Member', '', 50, 0, '2#star.gif');
REPLACE INTO `smfweb_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES(6, 'Full Member', '', 100, 0, '3#star.gif');
REPLACE INTO `smfweb_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES(7, 'Sr. Member', '', 250, 0, '4#star.gif');
REPLACE INTO `smfweb_membergroups` (`ID_GROUP`, `groupName`, `onlineColor`, `minPosts`, `maxMessages`, `stars`) VALUES(8, 'Hero Member', '', 500, 0, '5#star.gif');

REPLACE INTO `smfweb_members` (`ID_MEMBER`, `memberName`, `dateRegistered`, `posts`, `ID_GROUP`, `lngfile`, `lastLogin`, `realName`, `instantMessages`, `unreadMessages`, `buddy_list`, `pm_ignore_list`, `messageLabels`, `passwd`, `emailAddress`, `personalText`, `gender`, `birthdate`, `websiteTitle`, `websiteUrl`, `location`, `ICQ`, `AIM`, `YIM`, `MSN`, `hideEmail`, `showOnline`, `timeFormat`, `signature`, `timeOffset`, `avatar`, `pm_email_notify`, `karmaBad`, `karmaGood`, `usertitle`, `notifyAnnouncements`, `notifyOnce`, `notifySendBody`, `notifyTypes`, `memberIP`, `memberIP2`, `secretQuestion`, `secretAnswer`, `ID_THEME`, `is_activated`, `validation_code`, `ID_MSG_LAST_VISIT`, `additionalGroups`, `smileySet`, `ID_POST_GROUP`, `totalTimeLoggedIn`, `passwordSalt`) VALUES(1, 'admin', 1218104025, 0, 1, '', 1218104037, 'admin', 0, 0, '', '', '', 'cd5ea73cd58f827fa78eef7197b8ee606c99b2e6', 'admin@rvglobalsoft.com', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 0, '', 0, 0, 0, '', 1, 1, 0, 2, '192.168.1.149', '192.168.1.149', '', '', 0, 1, '', 1, '', '', 0, 0, '84e6');

REPLACE INTO `smfweb_messages` (`ID_MSG`, `ID_TOPIC`, `ID_BOARD`, `posterTime`, `ID_MEMBER`, `ID_MSG_MODIFIED`, `subject`, `posterName`, `posterEmail`, `posterIP`, `smileysEnabled`, `modifiedTime`, `modifiedName`, `body`, `icon`) VALUES(1, 1, 1, 1218103997, 0, 1, 'Welcome to SMF!', 'Simple Machines', 'info@simplemachines.org', '127.0.0.1', 1, 0, '', 'Welcome to Simple Machines Forum!<br /><br />We hope you enjoy using your forum.&nbsp; If you have any problems, please feel free to [url=http://www.simplemachines.org/community/index.php]ask us for assistance[/url].<br /><br />Thanks!<br />Simple Machines', 'xx');

REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(1, 'Standard', 'xx', 0, 0);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(2, 'Thumb Up', 'thumbup', 0, 1);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(3, 'Thumb Down', 'thumbdown', 0, 2);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(4, 'Exclamation point', 'exclamation', 0, 3);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(5, 'Question mark', 'question', 0, 4);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(6, 'Lamp', 'lamp', 0, 5);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(7, 'Smiley', 'smiley', 0, 6);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(8, 'Angry', 'angry', 0, 7);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(9, 'Cheesy', 'cheesy', 0, 8);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(10, 'Grin', 'grin', 0, 9);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(11, 'Sad', 'sad', 0, 10);
REPLACE INTO `smfweb_message_icons` (`ID_ICON`, `title`, `filename`, `ID_BOARD`, `iconOrder`) VALUES(12, 'Wink', 'wink', 0, 11);

REPLACE INTO `smfweb_package_servers` (`ID_SERVER`, `name`, `url`) VALUES(1, 'Simple Machines Third-party Mod Site', 'http://mods.simplemachines.org');

REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(-1, 'search_posts', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(-1, 'calendar_view', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(-1, 'view_stats', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(-1, 'profile_view_any', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'view_mlist', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'search_posts', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'profile_view_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'profile_view_any', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'pm_read', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'pm_send', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'calendar_view', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'view_stats', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'who_view', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'profile_identity_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'profile_extra_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'profile_remove_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'profile_server_avatar', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'profile_upload_avatar', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'profile_remote_avatar', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(0, 'karma_edit', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'view_mlist', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'search_posts', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_view_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_view_any', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'pm_read', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'pm_send', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'calendar_view', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'view_stats', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'who_view', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_identity_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_extra_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_remove_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_server_avatar', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_upload_avatar', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_remote_avatar', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'profile_title_own', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'calendar_post', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'calendar_edit_any', 1);
REPLACE INTO `smfweb_permissions` (`ID_GROUP`, `permission`, `addDeny`) VALUES(2, 'karma_edit', 1);

# REPLACE INTO `smfweb_sessions` (`session_id`, `last_update`, `data`) VALUES('f63059f9be6165ef283f171bb668e429', 1218104037, 'USER_AGENT|s:111:"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.3) Gecko/20070310 Firefox/2.0.0.3 (Debian-2.0.0.3-1thai1.tle1)";admin_time|i:1218104025;rand_code|s:32:"cdbeaa6bac38b884826e6b9b90672fc1";ID_MSG_LAST_VISIT|s:1:"0";log_time|i:1218104037;timeOnlineUpdated|i:1218104037;unread_messages|i:0;old_url|s:34:"http://boom.siaminterhost.net/smf/";');

REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smfVersion', '1.1.4');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('news', 'SMF - Just Installed!');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('compactTopicPagesContiguous', '5');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('compactTopicPagesEnable', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enableStickyTopics', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('todayMod', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('karmaMode', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('karmaTimeRestrictAdmins', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enablePreviousNext', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('pollMode', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enableVBStyleLogin', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enableCompressedOutput', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('karmaWaitTime', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('karmaMinPosts', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('karmaLabel', 'Karma:');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('karmaSmiteLabel', '[smite]');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('karmaApplaudLabel', '[applaud]');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentSizeLimit', '128');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentPostLimit', '192');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentNumPerPostLimit', '4');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentDirSizeLimit', '10240');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentUploadDir', '{SGL_PATH}/smfweb/attachments');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentExtensions', 'doc,gif,jpg,mpg,pdf,png,txt,zip');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentCheckExtensions', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentShowImages', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentEnable', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentEncryptFilenames', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentThumbnails', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentThumbWidth', '150');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('attachmentThumbHeight', '150');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('censorIgnoreCase', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('mostOnline', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('mostOnlineToday', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('mostDate', '1218104037');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('allow_disableAnnounce', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('trackStats', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('userLanguage', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('titlesEnable', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('topicSummaryPosts', '15');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enableErrorLogging', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('max_image_width', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('max_image_height', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('onlineEnable', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_holidaycolor', '000080');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_bdaycolor', '920AC4');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_eventcolor', '078907');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_enabled', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_maxyear', '2010');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_minyear', '2004');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_daysaslink', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_defaultboard', '');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_showeventsonindex', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_showbdaysonindex', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_showholidaysonindex', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_showeventsoncalendar', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_showbdaysoncalendar', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_showholidaysoncalendar', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_showweeknum', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_maxspan', '7');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smtp_host', '');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smtp_port', '25');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smtp_username', '');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smtp_password', '');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('mail_type', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('timeLoadPageEnable', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('totalTopics', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('totalMessages', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('simpleSearch', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('censor_vulgar', '');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('censor_proper', '');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enablePostHTML', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('theme_allow', '2');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('theme_default', '2');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('theme_guests', '2');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enableEmbeddedFlash', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('xmlnews_enable', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('xmlnews_maxlen', '255');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('hotTopicPosts', '15');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('hotTopicVeryPosts', '25');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('registration_method', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('send_validation_onChange', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('send_welcomeEmail', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('allow_editDisplayName', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('allow_hideOnline', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('allow_hideEmail', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('guest_hideContacts', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('spamWaitTime', '5');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('pm_spam_settings', '10,5,20');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('reserveWord', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('reserveCase', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('reserveUser', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('reserveName', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('reserveNames', 'Admin\nWebmaster\nGuest\nroot');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('autoLinkUrls', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('banLastUpdated', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smileys_dir', '{SGL_PATH}/smfweb/Smileys');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smileys_url', '{SGL_BASE_URL}/smfweb/Smileys');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_directory', '{SGL_PATH}/smfweb/avatars');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_url', '{SGL_BASE_URL}/smfweb/avatars');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_max_height_external', '65');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_max_width_external', '65');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_action_too_large', 'option_html_resize');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_max_height_upload', '65');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_max_width_upload', '65');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_resize_upload', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('avatar_download_png', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('failed_login_threshold', '3');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('oldTopicDays', '120');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('edit_wait_time', '90');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('edit_disable_time', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('autoFixDatabase', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('allow_guestAccess', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('time_format', '%B %d, %Y, %I:%M:%S %p');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('number_format', '1234.00');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enableBBC', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('max_messageLength', '20000');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('max_signatureLength', '300');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('autoOptDatabase', '7');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('autoOptMaxOnline', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('autoOptLastOpt', '1218104037');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('defaultMaxMessages', '15');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('defaultMaxTopics', '20');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('defaultMaxMembers', '30');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enableParticipation', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('recycle_enable', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('recycle_board', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('maxMsgID', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('enableAllMessages', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('fixLongWords', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('knownThemes', '1,2,3');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('who_enabled', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('time_offset', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cookieTime', '60');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('lastActive', '15');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smiley_sets_known', 'default,classic');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smiley_sets_names', 'Default\nClassic');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('smiley_sets_default', 'default');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('cal_days_for_index', '7');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('requireAgreement', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('unapprovedMembers', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('default_personalText', '');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('package_make_backups', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('databaseSession_enable', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('databaseSession_loose', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('databaseSession_lifetime', '2880');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('search_cache_size', '50');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('search_results_per_page', '30');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('search_weight_frequency', '30');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('search_weight_age', '25');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('search_weight_length', '20');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('search_weight_subject', '15');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('search_weight_first_message', '10');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('search_max_results', '1200');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('permission_enable_deny', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('permission_enable_postgroups', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('permission_enable_by_board', '0');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('default_timezone', 'Etc/GMT-7');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('memberlist_updated', '1218104025');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('latestMember', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('totalMembers', '1');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('latestRealName', 'admin');
REPLACE INTO `smfweb_settings` (`variable`, `value`) VALUES('mostOnlineUpdated', '2008-08-07');

REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(1, ':)', 'smiley.gif', 'Smiley', 0, 0, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(2, ';)', 'wink.gif', 'Wink', 0, 1, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(3, ':D', 'cheesy.gif', 'Cheesy', 0, 2, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(4, ';D', 'grin.gif', 'Grin', 0, 3, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(5, '>:(', 'angry.gif', 'Angry', 0, 4, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(6, ':(', 'sad.gif', 'Sad', 0, 5, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(7, ':o', 'shocked.gif', 'Shocked', 0, 6, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(8, '8)', 'cool.gif', 'Cool', 0, 7, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(9, '???', 'huh.gif', 'Huh?', 0, 8, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(10, '::)', 'rolleyes.gif', 'Roll Eyes', 0, 9, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(11, ':P', 'tongue.gif', 'Tongue', 0, 10, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(12, ':-[', 'embarrassed.gif', 'Embarrassed', 0, 11, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(13, ':-X', 'lipsrsealed.gif', 'Lips Sealed', 0, 12, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(14, ':-\\', 'undecided.gif', 'Undecided', 0, 13, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(15, ':-*', 'kiss.gif', 'Kiss', 0, 14, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(16, ':''(', 'cry.gif', 'Cry', 0, 15, 0);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(17, '>:D', 'evil.gif', 'Evil', 0, 16, 1);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(18, '^-^', 'azn.gif', 'Azn', 0, 17, 1);
REPLACE INTO `smfweb_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES(19, 'O0', 'afro.gif', 'Afro', 0, 18, 1);

REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'name', 'SMF Default Theme - Core');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'theme_url', '{SGL_BASE_URL}/smfweb/Themes/default');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'images_url', '{SGL_BASE_URL}/smfweb/Themes/default/images');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'theme_dir', '{SGL_PATH}/smfweb/Themes/default');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_bbc', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_latest_member', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_modify', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_user_images', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_blurb', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_gender', '0');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_newsfader', '0');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'number_recent_posts', '0');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_member_bar', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'linktree_link', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_profile_buttons', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_mark_read', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_sp1_info', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'linktree_inline', '0');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'show_board_desc', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'newsfader_time', '5000');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'allow_no_censored', '0');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'additional_options_collapsable', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'use_image_buttons', '1');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 1, 'enable_news', '1');

# REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 2, 'name', 'Classic YaBB SE Theme');
# REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 2, 'theme_url', '{SGL_BASE_URL}/smfweb/Themes/classic');
# REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 2, 'images_url', '{SGL_BASE_URL}/smfweb/Themes/classic/images');
# REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 2, 'theme_dir', '{SGL_WEB_ROOT}/smfweb/Themes/classic');
# REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 3, 'name', 'Babylon Theme');
# REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 3, 'theme_url', '{SGL_BASE_URL}/smfweb/Themes/babylon');
# REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 3, 'images_url', '{SGL_BASE_URL}/smfweb/Themes/babylon/images');
# REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 3, 'theme_dir', '{SGL_BASE_URL}/smfweb/Themes/babylon');
-- ------------------------------------
-- Add RVSMF Theme --
-- ------------------------------------
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 2, 'name', 'RVSFM Theme');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 2, 'theme_url', '{SGL_BASE_URL}/smfweb/Themes/rvsmfweb');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 2, 'images_url', '{SGL_BASE_URL}/smfweb/Themes/default/images');
REPLACE INTO `smfweb_themes` (`ID_MEMBER`, `ID_THEME`, `variable`, `value`) VALUES(0, 2, 'theme_dir', '{SGL_WEB_ROOT}/smfweb/Themes/rvsmfweb');


REPLACE INTO `smfweb_topics` (`ID_TOPIC`, `isSticky`, `ID_BOARD`, `ID_FIRST_MSG`, `ID_LAST_MSG`, `ID_MEMBER_STARTED`, `ID_MEMBER_UPDATED`, `ID_POLL`, `numReplies`, `numViews`, `locked`) VALUES(1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0);
