



-- --------------------------------------------------------

--
-- Table structure for table `RayBoardBoards`
--

CREATE TABLE `RayBoardBoards` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL DEFAULT '',
  `Password` varchar(255) NOT NULL DEFAULT '',
  `OwnerID` varchar(20) NOT NULL DEFAULT '0',
  `When` int(11) DEFAULT NULL,
  `Status` enum('new','normal','delete') NOT NULL DEFAULT 'new',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayBoardCurrentUsers`
--

CREATE TABLE `RayBoardCurrentUsers` (
  `ID` varchar(20) NOT NULL DEFAULT '',
  `Nick` varchar(255) NOT NULL,
  `Sex` enum('M','F') NOT NULL DEFAULT 'M',
  `Age` int(11) NOT NULL DEFAULT '0',
  `Photo` varchar(255) NOT NULL DEFAULT '',
  `Profile` varchar(255) NOT NULL DEFAULT '',
  `Desc` varchar(255) NOT NULL,
  `When` int(11) NOT NULL DEFAULT '0',
  `Status` enum('new','old','idle') NOT NULL DEFAULT 'new',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `RayBoardUsers`
--

CREATE TABLE `RayBoardUsers` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Board` int(11) NOT NULL DEFAULT '0',
  `User` varchar(20) NOT NULL DEFAULT '',
  `When` int(11) DEFAULT NULL,
  `Status` enum('normal','delete') NOT NULL DEFAULT 'normal',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayChatCurrentUsers`
--

CREATE TABLE `RayChatCurrentUsers` (
  `ID` varchar(20) NOT NULL DEFAULT '',
  `Nick` varchar(36) NOT NULL DEFAULT '',
  `Sex` enum('M','F') NOT NULL DEFAULT 'M',
  `Age` int(11) NOT NULL DEFAULT '0',
  `Desc` text NOT NULL,
  `Photo` varchar(255) NOT NULL DEFAULT '',
  `Profile` varchar(255) NOT NULL DEFAULT '',
  `Online` varchar(10) NOT NULL DEFAULT 'online',
  `Start` int(11) NOT NULL DEFAULT '0',
  `When` int(11) NOT NULL DEFAULT '0',
  `Status` enum('new','old','idle','kick','type','online') NOT NULL DEFAULT 'new',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `RayChatHistory`
--

CREATE TABLE `RayChatHistory` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Room` int(11) NOT NULL DEFAULT '0',
  `SndRcp` varchar(40) NOT NULL DEFAULT '',
  `Sender` varchar(20) NOT NULL DEFAULT '',
  `Recipient` varchar(20) NOT NULL DEFAULT '',
  `Message` text NOT NULL,
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayChatMemberships`
--

CREATE TABLE `RayChatMemberships` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Setting` int(11) NOT NULL DEFAULT '0',
  `Value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Membership` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayChatMembershipsSettings`
--

CREATE TABLE `RayChatMembershipsSettings` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Type` enum('boolean','number','custom') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'boolean',
  `Default` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Range` int(3) NOT NULL DEFAULT '3',
  `Error` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `RayChatMembershipsSettings`
--

INSERT INTO `RayChatMembershipsSettings` VALUES
(1, 'RoomCreate', 'New Rooms Creating:', 'boolean', 'true', 1, 'RayzRoomCreate'),
(2, 'PrivateRoomCreate', 'Private Rooms Creating:', 'boolean', 'true', 1, 'RayzPrivateRoomCreate'),
(3, 'AVCasting', 'Audio/Video Casting:', 'boolean', 'true', 1, 'RayzAVCasting'),
(4, 'AVPlaying', 'Audio/Video Playing (for Messenger):', 'boolean', 'true', 1, 'RayzAVPlaying'),
(5, 'AVLargeWindow', 'Enable Large Video Window:', 'boolean', 'true', 1, 'RayzAVLargeWindow'),
(6, 'FileSend', 'Files Sending:', 'boolean', 'true', 1, 'RayzFileSend'),
(7, 'WhisperMessages', 'Whispering Messages:', 'boolean', 'true', 1, 'RayzWhisperMessages'),
(8, 'DirectMessages', 'Addressed Messages:', 'boolean', 'true', 1, 'RayzDirectMessages'),
(9, 'RoomsNumber', 'Maximum Rooms Number:', 'number', '100', 3, 'RayzRoomsNumber'),
(10, 'ChatsNumber', 'Maximum Private Chats Number:', 'number', '100', 3, 'RayzChatsNumber'),
(11, 'AVWindowsNumber', 'Maximum Video Windows Number:', 'number', '100', 3, 'RayzAVWindowsNumber'),
(12, 'RestrictedRooms', 'Restricted Rooms:', 'custom', '', 1, 'RayzRestrictedRooms');

-- --------------------------------------------------------

--
-- Table structure for table `RayChatMessages`
--

CREATE TABLE `RayChatMessages` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Room` int(11) NOT NULL DEFAULT '0',
  `SndRcp` varchar(40) NOT NULL DEFAULT '',
  `Sender` varchar(20) NOT NULL DEFAULT '',
  `Recipient` varchar(20) NOT NULL DEFAULT '',
  `Whisper` enum('true','false') NOT NULL DEFAULT 'false',
  `Message` text NOT NULL,
  `Style` text NOT NULL,
  `Type` varchar(10) NOT NULL DEFAULT 'text',
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayChatProfiles`
--

CREATE TABLE `RayChatProfiles` (
  `ID` varchar(20) NOT NULL DEFAULT '0',
  `Banned` enum('true','false') NOT NULL DEFAULT 'false',
  `Type` varchar(10) NOT NULL DEFAULT 'full',
  `Smileset` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `RayChatRoomsUsers`
--

CREATE TABLE `RayChatRoomsUsers` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Room` int(11) NOT NULL DEFAULT '0',
  `User` varchar(20) NOT NULL DEFAULT '',
  `When` int(11) DEFAULT NULL,
  `Status` enum('normal','delete') NOT NULL DEFAULT 'normal',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayImContacts`
--

CREATE TABLE `RayImContacts` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SenderID` int(11) NOT NULL DEFAULT '0',
  `RecipientID` int(11) NOT NULL DEFAULT '0',
  `Online` varchar(10) NOT NULL DEFAULT 'online',
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayImMessages`
--

CREATE TABLE `RayImMessages` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ContactID` int(11) NOT NULL DEFAULT '0',
  `Message` text NOT NULL,
  `Style` text NOT NULL,
  `Type` varchar(10) NOT NULL DEFAULT 'text',
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayImPendings`
--

CREATE TABLE `RayImPendings` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SenderID` int(11) NOT NULL DEFAULT '0',
  `RecipientID` int(11) NOT NULL DEFAULT '0',
  `Message` varchar(255) NOT NULL DEFAULT '',
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `RecipientID` (`RecipientID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayImProfiles`
--

CREATE TABLE `RayImProfiles` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Smileset` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `RayMp3Files`
--

CREATE TABLE `RayMp3Files` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Categories` text NOT NULL,
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Uri` varchar(255) NOT NULL DEFAULT '',
  `Tags` text NOT NULL,
  `Description` text NOT NULL,
  `Time` int(11) NOT NULL DEFAULT '0',
  `Date` int(20) NOT NULL DEFAULT '0',
  `Reports` int(11) NOT NULL DEFAULT '0',
  `Owner` varchar(64) NOT NULL DEFAULT '',
  `Listens` int(12) DEFAULT '0',
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `Featured` tinyint(4) NOT NULL,
  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Uri` (`Uri`),
  KEY `Owner` (`Owner`),
  FULLTEXT KEY `ftMain` (`Title`,`Tags`,`Description`,`Categories`),
  FULLTEXT KEY `ftTags` (`Tags`),
  FULLTEXT KEY `ftCategories` (`Categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayMp3Tokens`
--

CREATE TABLE `RayMp3Tokens` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Token` varchar(32) NOT NULL DEFAULT '',
  `Date` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `RayShoutboxMessages`
--

CREATE TABLE `RayShoutboxMessages` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` varchar(20) NOT NULL DEFAULT '0',
  `Msg` text NOT NULL,
  `When` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayVideoFiles`
--

CREATE TABLE `RayVideoFiles` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Categories` text NOT NULL,
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Uri` varchar(255) NOT NULL DEFAULT '',
  `Tags` text NOT NULL,
  `Description` text NOT NULL,
  `Time` int(11) NOT NULL DEFAULT '0',
  `Date` int(20) NOT NULL DEFAULT '0',
  `Owner` varchar(64) NOT NULL DEFAULT '',
  `Views` int(12) DEFAULT '0',
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `Featured` tinyint(4) NOT NULL,
  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
  `Source` varchar(20) NOT NULL DEFAULT '',
  `Video` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Uri` (`Uri`),
  KEY `Owner` (`Owner`),
  FULLTEXT KEY `ftMain` (`Title`,`Tags`,`Description`,`Categories`),
  FULLTEXT KEY `ftTags` (`Tags`),
  FULLTEXT KEY `ftCategories` (`Categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayVideoTokens`
--

CREATE TABLE `RayVideoTokens` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Token` varchar(32) NOT NULL DEFAULT '',
  `Date` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `RayVideo_commentsFiles`
--

CREATE TABLE `RayVideo_commentsFiles` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Categories` text NOT NULL,
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Uri` varchar(255) NOT NULL DEFAULT '',
  `Tags` text NOT NULL,
  `Description` text NOT NULL,
  `Time` int(11) NOT NULL DEFAULT '0',
  `Date` int(20) NOT NULL DEFAULT '0',
  `Owner` varchar(64) NOT NULL DEFAULT '',
  `Views` int(12) DEFAULT '0',
  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Uri` (`Uri`),
  KEY `Owner` (`Owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `RayVideo_commentsTokens`
--

CREATE TABLE `RayVideo_commentsTokens` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Token` varchar(32) NOT NULL DEFAULT '',
  `Date` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_account_custom_stat_elements`
--

CREATE TABLE `sys_account_custom_stat_elements` (
  `ID` int(2) NOT NULL AUTO_INCREMENT,
  `Label` varchar(128) NOT NULL,
  `Value` varchar(255) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_acl_actions`
--

CREATE TABLE `sys_acl_actions` (
  `ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL DEFAULT '',
  `AdditionalParamName` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `sys_acl_actions`
--

INSERT INTO `sys_acl_actions` VALUES
(1, 'send greetings', NULL),
(2, 'view profiles', NULL),
(3, 'vote', NULL),
(4, 'send messages', NULL),
(5, 'get other members emails', NULL),
(6, 'comments post', NULL),
(7, 'comments vote', NULL),
(8, 'comments edit own', NULL),
(9, 'comments remove own', NULL),
(10, 'send friend request', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_acl_actions_track`
--

CREATE TABLE `sys_acl_actions_track` (
  `IDAction` smallint(5) unsigned NOT NULL DEFAULT '0',
  `IDMember` int(10) unsigned NOT NULL DEFAULT '0',
  `ActionsLeft` smallint(5) unsigned NOT NULL DEFAULT '0',
  `ValidSince` datetime DEFAULT NULL,
  PRIMARY KEY (`IDAction`,`IDMember`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_acl_levels`
--

CREATE TABLE `sys_acl_levels` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL DEFAULT '',
  `Icon` varchar(255) NOT NULL DEFAULT '',
  `Description` text NOT NULL,
  `Active` enum('yes','no') NOT NULL DEFAULT 'no',
  `Purchasable` enum('yes','no') NOT NULL DEFAULT 'yes',
  `Removable` enum('yes','no') NOT NULL DEFAULT 'yes',
  `Order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `sys_acl_levels`
--

INSERT INTO `sys_acl_levels` VALUES
(1, 'Non-member', 'non-member.png', '', 'yes', 'no', 'no', 0),
(2, 'Standard', 'member.png', '', 'yes', 'no', 'no', 0),
(3, 'Promotion', 'promotion.png', '', 'yes', 'no', 'no', 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_acl_levels_members`
--

CREATE TABLE `sys_acl_levels_members` (
  `IDMember` int(10) unsigned NOT NULL DEFAULT '0',
  `IDLevel` smallint(5) unsigned NOT NULL DEFAULT '0',
  `DateStarts` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DateExpires` datetime DEFAULT NULL,
  `TransactionID` varchar(16) NOT NULL DEFAULT '',
  `Expiring` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`IDMember`,`IDLevel`,`DateStarts`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_acl_level_prices`
--

CREATE TABLE `sys_acl_level_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `IDLevel` smallint(5) unsigned NOT NULL DEFAULT '0',
  `Days` int(10) unsigned NOT NULL DEFAULT '1',
  `Price` float unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`IDLevel`,`Days`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_acl_matrix`
--

CREATE TABLE `sys_acl_matrix` (
  `IDLevel` smallint(5) unsigned NOT NULL DEFAULT '0',
  `IDAction` smallint(5) unsigned NOT NULL DEFAULT '0',
  `AllowedCount` smallint(5) unsigned DEFAULT NULL,
  `AllowedPeriodLen` smallint(5) unsigned DEFAULT NULL,
  `AllowedPeriodStart` datetime DEFAULT NULL,
  `AllowedPeriodEnd` datetime DEFAULT NULL,
  `AdditionalParamValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`IDLevel`,`IDAction`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_acl_matrix`
--

INSERT INTO `sys_acl_matrix` VALUES
(1, 2, NULL, NULL, NULL, NULL, NULL),
(1, 3, NULL, NULL, NULL, NULL, NULL),
(1, 7, NULL, NULL, NULL, NULL, NULL),
(2, 1, 4, 24, NULL, NULL, NULL),
(2, 2, NULL, NULL, NULL, NULL, NULL),
(2, 3, NULL, NULL, NULL, NULL, NULL),
(2, 4, 10, 24, NULL, NULL, NULL),
(2, 6, NULL, NULL, NULL, NULL, NULL),
(2, 7, NULL, NULL, NULL, NULL, NULL),
(2, 8, NULL, NULL, NULL, NULL, NULL),
(2, 9, NULL, NULL, NULL, NULL, NULL),
(2, 10, NULL, NULL, NULL, NULL, NULL),
(3, 1, NULL, NULL, NULL, NULL, NULL),
(3, 2, NULL, NULL, NULL, NULL, NULL),
(3, 3, NULL, NULL, NULL, NULL, NULL),
(3, 4, NULL, NULL, NULL, NULL, NULL),
(3, 6, NULL, NULL, NULL, NULL, NULL),
(3, 7, NULL, NULL, NULL, NULL, NULL),
(3, 8, NULL, NULL, NULL, NULL, NULL),
(3, 9, NULL, NULL, NULL, NULL, NULL),
(3, 10, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_admin_ban_list`
--

CREATE TABLE `sys_admin_ban_list` (
  `ProfID` int(10) unsigned NOT NULL DEFAULT '0',
  `Time` int(10) unsigned NOT NULL DEFAULT '0',
  `DateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ProfID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_albums`
--

CREATE TABLE `sys_albums` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Caption` varchar(128) NOT NULL DEFAULT '',
  `Uri` varchar(255) NOT NULL DEFAULT '',
  `Location` varchar(128) NOT NULL DEFAULT '',
  `Description` varchar(255) NOT NULL DEFAULT '',
  `Type` varchar(20) NOT NULL DEFAULT '',
  `Owner` int(10) NOT NULL DEFAULT '0',
  `Status` enum('active','passive') NOT NULL DEFAULT 'active',
  `Date` int(10) NOT NULL DEFAULT '0',
  `ObjCount` int(10) NOT NULL DEFAULT '0',
  `LastObjId` int(10) NOT NULL DEFAULT '0',
  `AllowAlbumView` int(10) NOT NULL DEFAULT '3',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Uri` (`Uri`,`Type`,`Owner`),
  KEY `Owner` (`Owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_albums_objects`
--

CREATE TABLE `sys_albums_objects` (
  `id_album` int(10) NOT NULL,
  `id_object` int(10) NOT NULL,
  `obj_order` int(10) NOT NULL DEFAULT '0',
  UNIQUE KEY `id_album` (`id_album`,`id_object`),
  KEY `id_object` (`id_object`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_alerts`
--

CREATE TABLE `sys_alerts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `unit` varchar(64) NOT NULL DEFAULT '',
  `action` varchar(64) NOT NULL DEFAULT 'none',
  `handler_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `alert_handler` (`unit`,`action`,`handler_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `sys_alerts`
--

INSERT INTO `sys_alerts` VALUES
(1, 'system', 'begin', 1),
(2, 'profile', 'before_join', 2),
(3, 'profile', 'join', 2),
(4, 'profile', 'before_login', 2),
(5, 'profile', 'login', 2),
(6, 'profile', 'logout', 2),
(7, 'profile', 'edit', 2),
(8, 'profile', 'delete', 2),
(9, 'profile', 'join', 3),
(10, 'profile', 'edit', 3),
(11, 'profile', 'delete', 3),
(12, 'profile', 'join', 4),
(13, 'profile', 'edit', 4),
(14, 'profile', 'delete', 4),
(15, 'profile', 'change_status', 4),
(16, 'profile', 'commentRemoved', 5);

-- --------------------------------------------------------

--
-- Table structure for table `sys_alerts_handlers`
--

CREATE TABLE `sys_alerts_handlers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '',
  `class` varchar(128) NOT NULL DEFAULT '',
  `file` varchar(255) NOT NULL DEFAULT '',
  `eval` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `sys_alerts_handlers`
--

INSERT INTO `sys_alerts_handlers` VALUES
(1, 'system', 'BxDolAlertsResponseSystem', 'inc/classes/BxDolAlertsResponseSystem.php', ''),
(2, 'profile', 'BxDolAlertsResponseProfile', 'inc/classes/BxDolAlertsResponseProfile.php', ''),
(3, 'membersData', 'BxDolUpdateMembersCache', 'inc/classes/BxDolUpdateMembersCache.php', ''),
(4, 'profileMatch', 'BxDolAlertsResponceMatch', 'inc/classes/BxDolAlertsResponceMatch.php', ''),
(5, 'bx_videos_comments_delete', 'BxDolVideoDeleteResponse', 'flash/modules/video_comments/inc/classes/BxDolVideoDeleteResponse.php', '');

-- --------------------------------------------------------

--
-- Table structure for table `sys_antispam_block_log`
--

CREATE TABLE `sys_antispam_block_log` (
  `ip` int(10) unsigned NOT NULL,
  `member_id` int(10) unsigned NOT NULL,
  `type` varchar(32) NOT NULL,
  `extra` text NOT NULL,
  `added` int(11) NOT NULL,
  KEY `ip` (`ip`),
  KEY `member_id` (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_banners`
--

CREATE TABLE `sys_banners` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Title` varchar(32) NOT NULL DEFAULT '',
  `Url` varchar(255) NOT NULL DEFAULT '',
  `Text` mediumtext NOT NULL,
  `Active` tinyint(4) NOT NULL DEFAULT '0',
  `Created` date NOT NULL DEFAULT '0000-00-00',
  `campaign_start` date NOT NULL DEFAULT '2005-01-01',
  `campaign_end` date NOT NULL DEFAULT '2007-01-01',
  `Position` varchar(10) NOT NULL DEFAULT '4',
  `lhshift` int(5) NOT NULL DEFAULT '-200',
  `lvshift` int(5) NOT NULL DEFAULT '-750',
  `rhshift` int(5) NOT NULL DEFAULT '100',
  `rvshift` int(5) NOT NULL DEFAULT '-750',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_banners_clicks`
--

CREATE TABLE `sys_banners_clicks` (
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Date` int(10) NOT NULL DEFAULT '0',
  `IP` varchar(16) NOT NULL DEFAULT '',
  UNIQUE KEY `ID_2` (`ID`,`Date`,`IP`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_banners_shows`
--

CREATE TABLE `sys_banners_shows` (
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Date` int(10) NOT NULL DEFAULT '0',
  `IP` varchar(16) NOT NULL DEFAULT '',
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_block_list`
--

CREATE TABLE `sys_block_list` (
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Profile` int(10) unsigned NOT NULL DEFAULT '0',
  `When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `BlockPair` (`ID`,`Profile`),
  KEY `ID` (`ID`),
  KEY `Profile` (`Profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_box_download`
--

CREATE TABLE `sys_box_download` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(64) NOT NULL,
  `url` varchar(255) NOT NULL,
  `onclick` varchar(255) NOT NULL,
  `desc` text NOT NULL,
  `icon` varchar(255) NOT NULL,
  `order` int(11) NOT NULL,
  `disabled` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `sys_box_download`
--

INSERT INTO `sys_box_download` VALUES
(1, '_sbd_iPhone_title', 'http://itunes.apple.com/us/app/oo/id345450186', '', '_sbd_iPhone_desc', 'apple', 2, 0),
(2, '_sbd_Android_title', 'https://play.google.com/store/apps/details?id=com.boonex.oo', '', '_sbd_Android_desc', 'android', 3, 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_categories`
--

CREATE TABLE `sys_categories` (
  `Category` varchar(32) NOT NULL DEFAULT '',
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Type` varchar(20) NOT NULL DEFAULT 'photo',
  `Owner` int(10) unsigned NOT NULL,
  `Status` enum('active','passive') NOT NULL DEFAULT 'active',
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`Category`,`ID`,`Type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_cmts_profile`
--

CREATE TABLE `sys_cmts_profile` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(11) NOT NULL DEFAULT '0',
  `cmt_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_text` text NOT NULL,
  `cmt_mood` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate` int(11) NOT NULL DEFAULT '0',
  `cmt_rate_count` int(11) NOT NULL DEFAULT '0',
  `cmt_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cmt_replies` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_id`),
  KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_cmts_track`
--

CREATE TABLE `sys_cmts_track` (
  `cmt_system_id` int(11) NOT NULL DEFAULT '0',
  `cmt_id` int(11) NOT NULL DEFAULT '0',
  `cmt_rate` tinyint(4) NOT NULL DEFAULT '0',
  `cmt_rate_author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_author_nip` int(11) unsigned NOT NULL DEFAULT '0',
  `cmt_rate_ts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cmt_system_id`,`cmt_id`,`cmt_rate_author_nip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_color_base`
--

CREATE TABLE `sys_color_base` (
  `ColorName` varchar(20) NOT NULL DEFAULT '',
  `ColorCode` varchar(10) NOT NULL DEFAULT '',
  UNIQUE KEY `ColorName` (`ColorName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_color_base`
--

INSERT INTO `sys_color_base` VALUES
('AliceBlue', '#F0F8FF'),
('AntiqueWhite', '#FAEBD7'),
('Aqua', '#00FFFF'),
('Aquamarine', '#7FFFD4'),
('Azure', '#F0FFFF'),
('Beige', '#F5F5DC'),
('Bisque', '#FFE4C4'),
('Black', '#000000'),
('BlanchedAlmond', '#FFEBCD'),
('Blue', '#0000FF'),
('BlueViolet', '#8A2BE2'),
('Brown', '#A52A2A'),
('BurlyWood', '#DEB887'),
('CadetBlue', '#5F9EA0'),
('Chartreuse', '#7FFF00'),
('Chocolate', '#D2691E'),
('Coral', '#FF7F50'),
('CornflowerBlue', '#6495ED'),
('Cornsilk', '#FFF8DC'),
('Crimson', '#DC143C'),
('Cyan', '#00FFFF'),
('DarkBlue', '#00008B'),
('DarkCyan', '#008B8B'),
('DarkGoldenRod', '#B8860B'),
('DarkGray', '#A9A9A9'),
('DarkGreen', '#006400'),
('DarkKhaki', '#BDB76B'),
('DarkMagenta', '#8B008B'),
('DarkOliveGreen', '#556B2F'),
('Darkorange', '#FF8C00'),
('DarkOrchid', '#9932CC'),
('DarkRed', '#8B0000'),
('DarkSalmon', '#E9967A'),
('DarkSeaGreen', '#8FBC8F'),
('DarkSlateBlue', '#483D8B'),
('DarkSlateGray', '#2F4F4F'),
('DarkTurquoise', '#00CED1'),
('DarkViolet', '#9400D3'),
('DeepPink', '#FF1493'),
('DeepSkyBlue', '#00BFFF'),
('DimGray', '#696969'),
('DodgerBlue', '#1E90FF'),
('Feldspar', '#D19275'),
('FireBrick', '#B22222'),
('FloralWhite', '#FFFAF0'),
('ForestGreen', '#228B22'),
('Fuchsia', '#FF00FF'),
('Gainsboro', '#DCDCDC'),
('GhostWhite', '#F8F8FF'),
('Gold', '#FFD700'),
('GoldenRod', '#DAA520'),
('Gray', '#808080'),
('Green', '#008000'),
('GreenYellow', '#ADFF2F'),
('HoneyDew', '#F0FFF0'),
('HotPink', '#FF69B4'),
('IndianRed', '#CD5C5C'),
('Indigo', '#4B0082'),
('Ivory', '#FFFFF0'),
('Khaki', '#F0E68C'),
('Lavender', '#E6E6FA'),
('LavenderBlush', '#FFF0F5'),
('LawnGreen', '#7CFC00'),
('LemonChiffon', '#FFFACD'),
('LightBlue', '#ADD8E6'),
('LightCoral', '#F08080'),
('LightCyan', '#E0FFFF'),
('LightGoldenRodYellow', '#FAFAD2'),
('LightGrey', '#D3D3D3'),
('LightGreen', '#90EE90'),
('LightPink', '#FFB6C1'),
('LightSalmon', '#FFA07A'),
('LightSeaGreen', '#20B2AA'),
('LightSkyBlue', '#87CEFA'),
('LightSlateBlue', '#8470FF'),
('LightSlateGray', '#778899'),
('LightSteelBlue', '#B0C4DE'),
('LightYellow', '#FFFFE0'),
('Lime', '#00FF00'),
('LimeGreen', '#32CD32'),
('Linen', '#FAF0E6'),
('Magenta', '#FF00FF'),
('Maroon', '#800000'),
('MediumAquaMarine', '#66CDAA'),
('MediumBlue', '#0000CD'),
('MediumOrchid', '#BA55D3'),
('MediumPurple', '#9370D8'),
('MediumSeaGreen', '#3CB371'),
('MediumSlateBlue', '#7B68EE'),
('MediumSpringGreen', '#00FA9A'),
('MediumTurquoise', '#48D1CC'),
('MediumVioletRed', '#C71585'),
('MidnightBlue', '#191970'),
('MintCream', '#F5FFFA'),
('MistyRose', '#FFE4E1'),
('Moccasin', '#FFE4B5'),
('NavajoWhite', '#FFDEAD'),
('Navy', '#000080'),
('OldLace', '#FDF5E6'),
('Olive', '#808000'),
('OliveDrab', '#6B8E23'),
('Orange', '#FFA500'),
('OrangeRed', '#FF4500'),
('Orchid', '#DA70D6'),
('PaleGoldenRod', '#EEE8AA'),
('PaleGreen', '#98FB98'),
('PaleTurquoise', '#AFEEEE'),
('PaleVioletRed', '#D87093'),
('PapayaWhip', '#FFEFD5'),
('PeachPuff', '#FFDAB9'),
('Peru', '#CD853F'),
('Pink', '#FFC0CB'),
('Plum', '#DDA0DD'),
('PowderBlue', '#B0E0E6'),
('Purple', '#800080'),
('Red', '#FF0000'),
('RosyBrown', '#BC8F8F'),
('RoyalBlue', '#4169E1'),
('SaddleBrown', '#8B4513'),
('Salmon', '#FA8072'),
('SandyBrown', '#F4A460'),
('SeaGreen', '#2E8B57'),
('SeaShell', '#FFF5EE'),
('Sienna', '#A0522D'),
('Silver', '#C0C0C0'),
('SkyBlue', '#87CEEB'),
('SlateBlue', '#6A5ACD'),
('SlateGray', '#708090'),
('Snow', '#FFFAFA'),
('SpringGreen', '#00FF7F'),
('SteelBlue', '#4682B4'),
('Tan', '#D2B48C'),
('Teal', '#008080'),
('Thistle', '#D8BFD8'),
('Tomato', '#FF6347'),
('Turquoise', '#40E0D0'),
('Violet', '#EE82EE'),
('VioletRed', '#D02090'),
('Wheat', '#F5DEB3'),
('White', '#FFFFFF'),
('WhiteSmoke', '#F5F5F5'),
('Yellow', '#FFFF00'),
('YellowGreen', '#9ACD32');

-- --------------------------------------------------------

--
-- Table structure for table `sys_countries`
--

CREATE TABLE `sys_countries` (
  `ISO2` varchar(2) NOT NULL DEFAULT '',
  `ISO3` varchar(3) NOT NULL DEFAULT '',
  `ISONo` smallint(3) NOT NULL DEFAULT '0',
  `Country` varchar(100) NOT NULL DEFAULT '',
  `Region` varchar(100) DEFAULT NULL,
  `Currency` varchar(100) DEFAULT NULL,
  `CurrencyCode` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`ISO2`),
  KEY `CurrencyCode` (`CurrencyCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_countries`
--

INSERT INTO `sys_countries` VALUES
('AD', 'AND', 20, 'Andorra', 'Europe', 'Euro', 'EUR'),
('AE', 'ARE', 784, 'United Arab Emirates', 'Middle East', 'UAE Dirham', 'AED'),
('AF', 'AFG', 4, 'Afghanistan', 'Asia', 'Afghani', 'AFA'),
('AG', 'ATG', 28, 'Antigua and Barbuda', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'),
('AI', 'AIA', 660, 'Anguilla', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'),
('AL', 'ALB', 8, 'Albania', 'Europe', 'Lek', 'ALL'),
('AM', 'ARM', 51, 'Armenia', 'Commonwealth of Independent States', 'Armenian Dram', 'AMD'),
('AN', 'ANT', 530, 'Netherlands Antilles', 'Central America and the Caribbean', 'Netherlands Antillean guilder', 'ANG'),
('AO', 'AGO', 24, 'Angola', 'Africa', 'Kwanza', 'AOA'),
('AQ', 'ATA', 10, 'Antarctica', 'Antarctic Region', NULL, NULL),
('AR', 'ARG', 32, 'Argentina', 'South America', 'Argentine Peso', 'ARS'),
('AS', 'ASM', 16, 'American Samoa', 'Oceania', 'US Dollar', 'USD'),
('AT', 'AUT', 40, 'Austria', 'Europe', 'Euro', 'EUR'),
('AU', 'AUS', 36, 'Australia', 'Oceania', 'Australian dollar', 'AUD'),
('AW', 'ABW', 533, 'Aruba', 'Central America and the Caribbean', 'Aruban Guilder', 'AWG'),
('AX', 'ALA', 248, 'Aland Islands', 'Europe', 'Euro', 'EUR'),
('AZ', 'AZE', 31, 'Azerbaijan', 'Commonwealth of Independent States', 'Azerbaijani Manat', 'AZM'),
('BA', 'BIH', 70, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina, Europe', 'Convertible Marka', 'BAM'),
('BB', 'BRB', 52, 'Barbados', 'Central America and the Caribbean', 'Barbados Dollar', 'BBD'),
('BD', 'BGD', 50, 'Bangladesh', 'Asia', 'Taka', 'BDT'),
('BE', 'BEL', 56, 'Belgium', 'Europe', 'Euro', 'EUR'),
('BF', 'BFA', 854, 'Burkina Faso', 'Africa', 'CFA Franc BCEAO', 'XOF'),
('BG', 'BGR', 100, 'Bulgaria', 'Europe', 'Lev', 'BGL'),
('BH', 'BHR', 48, 'Bahrain', 'Middle East', 'Bahraini Dinar', 'BHD'),
('BI', 'BDI', 108, 'Burundi', 'Africa', 'Burundi Franc', 'BIF'),
('BJ', 'BEN', 204, 'Benin', 'Africa', 'CFA Franc BCEAO', 'XOF'),
('BL', 'BLM', 652, 'Saint Barthelemy', 'Central America and the Caribbean', 'Euro', 'EUR'),
('BM', 'BMU', 60, 'Bermuda', 'North America', 'Bermudian Dollar', 'BMD'),
('BN', 'BRN', 96, 'Brunei Darussalam', 'Southeast Asia', 'Brunei Dollar', 'BND'),
('BO', 'BOL', 68, 'Bolivia', 'South America', 'Boliviano', 'BOB'),
('BR', 'BRA', 76, 'Brazil', 'South America', 'Brazilian Real', 'BRL'),
('BS', 'BHS', 44, 'The Bahamas', 'Central America and the Caribbean', 'Bahamian Dollar', 'BSD'),
('BT', 'BTN', 64, 'Bhutan', 'Asia', 'Ngultrum', 'BTN'),
('BV', 'BVT', 74, 'Bouvet Island', 'Antarctic Region', 'Norwegian Krone', 'NOK'),
('BW', 'BWA', 72, 'Botswana', 'Africa', 'Pula', 'BWP'),
('BY', 'BLR', 112, 'Belarus', 'Commonwealth of Independent States', 'Belarussian Ruble', 'BYR'),
('BZ', 'BLZ', 84, 'Belize', 'Central America and the Caribbean', 'Belize Dollar', 'BZD'),
('CA', 'CAN', 124, 'Canada', 'North America', 'Canadian Dollar', 'CAD'),
('CC', 'CCK', 166, 'Cocos (Keeling) Islands', 'Southeast Asia', 'Australian Dollar', 'AUD'),
('CD', 'COD', 180, 'Congo, Democratic Republic of the', 'Africa', 'Franc Congolais', 'CDF'),
('CF', 'CAF', 140, 'Central African Republic', 'Africa', 'CFA Franc BEAC', 'XAF'),
('CG', 'COG', 178, 'Congo, Republic of the', 'Africa', 'CFA Franc BEAC', 'XAF'),
('CH', 'CHE', 756, 'Switzerland', 'Europe', 'Swiss Franc', 'CHF'),
('CI', 'CIV', 384, 'Cote d''Ivoire', 'Africa', 'CFA Franc BCEAO', 'XOF'),
('CK', 'COK', 184, 'Cook Islands', 'Oceania', 'New Zealand Dollar', 'NZD'),
('CL', 'CHL', 152, 'Chile', 'South America', 'Chilean Peso', 'CLP'),
('CM', 'CMR', 120, 'Cameroon', 'Africa', 'CFA Franc BEAC', 'XAF'),
('CN', 'CHN', 156, 'China', 'Asia', 'Yuan Renminbi', 'CNY'),
('CO', 'COL', 170, 'Colombia', 'South America, Central America and the Caribbean', 'Colombian Peso', 'COP'),
('CR', 'CRI', 188, 'Costa Rica', 'Central America and the Caribbean', 'Costa Rican Colon', 'CRC'),
('CU', 'CUB', 192, 'Cuba', 'Central America and the Caribbean', 'Cuban Peso', 'CUP'),
('CV', 'CPV', 132, 'Cape Verde', 'World', 'Cape Verdean Escudo', 'CVE'),
('CX', 'CXR', 162, 'Christmas Island', 'Southeast Asia', 'Australian Dollar', 'AUD'),
('CY', 'CYP', 196, 'Cyprus', 'Middle East', 'Cyprus Pound', 'CYP'),
('CZ', 'CZE', 203, 'Czech Republic', 'Europe', 'Czech Koruna', 'CZK'),
('DE', 'DEU', 276, 'Germany', 'Europe', 'Euro', 'EUR'),
('DJ', 'DJI', 262, 'Djibouti', 'Africa', 'Djibouti Franc', 'DJF'),
('DK', 'DNK', 208, 'Denmark', 'Europe', 'Danish Krone', 'DKK'),
('DM', 'DMA', 212, 'Dominica', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'),
('DO', 'DOM', 214, 'Dominican Republic', 'Central America and the Caribbean', 'Dominican Peso', 'DOP'),
('DZ', 'DZA', 12, 'Algeria', 'Africa', 'Algerian Dinar', 'DZD'),
('EC', 'ECU', 218, 'Ecuador', 'South America', 'US dollar', 'USD'),
('EE', 'EST', 233, 'Estonia', 'Europe', 'Kroon', 'EEK'),
('EG', 'EGY', 818, 'Egypt', 'Africa', 'Egyptian Pound', 'EGP'),
('EH', 'ESH', 732, 'Western Sahara', 'Africa', 'Moroccan Dirham', 'MAD'),
('ER', 'ERI', 232, 'Eritrea', 'Africa', 'Nakfa', 'ERN'),
('ES', 'ESP', 724, 'Spain', 'Europe', 'Euro', 'EUR'),
('ET', 'ETH', 231, 'Ethiopia', 'Africa', 'Ethiopian Birr', 'ETB'),
('FI', 'FIN', 246, 'Finland', 'Europe', 'Euro', 'EUR'),
('FJ', 'FJI', 242, 'Fiji', 'Oceania', 'Fijian Dollar', 'FJD'),
('FK', 'FLK', 238, 'Falkland Islands (Islas Malvinas)', 'South America', 'Falkland Islands Pound', 'FKP'),
('FM', 'FSM', 583, 'Micronesia, Federated States of', 'Oceania', 'US dollar', 'USD'),
('FO', 'FRO', 234, 'Faroe Islands', 'Europe', 'Danish Krone', 'DKK'),
('FR', 'FRA', 250, 'France', 'Europe', 'Euro', 'EUR'),
('GA', 'GAB', 266, 'Gabon', 'Africa', 'CFA Franc BEAC', 'XAF'),
('GB', 'GBR', 826, 'United Kingdom', 'Europe', 'Pound Sterling', 'GBP'),
('GD', 'GRD', 308, 'Grenada', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'),
('GE', 'GEO', 268, 'Georgia', 'Commonwealth of Independent States', 'Lari', 'GEL'),
('GF', 'GUF', 254, 'French Guiana', 'South America', 'Euro', 'EUR'),
('GG', 'GGY', 831, 'Guernsey', 'Europe', 'Pound sterling', 'GBP'),
('GH', 'GHA', 288, 'Ghana', 'Africa', 'Cedi', 'GHC'),
('GI', 'GIB', 292, 'Gibraltar', 'Europe', 'Gibraltar Pound', 'GIP'),
('GL', 'GRL', 304, 'Greenland', 'Arctic Region', 'Danish Krone', 'DKK'),
('GM', 'GMB', 270, 'The Gambia', 'Africa', 'Dalasi', 'GMD'),
('GN', 'GIN', 324, 'Guinea', 'Africa', 'Guinean Franc', 'GNF'),
('GP', 'GLP', 312, 'Guadeloupe', 'Central America and the Caribbean', 'Euro', 'EUR'),
('GQ', 'GNQ', 226, 'Equatorial Guinea', 'Africa', 'CFA Franc BEAC', 'XAF'),
('GR', 'GRC', 300, 'Greece', 'Europe', 'Euro', 'EUR'),
('GS', 'SGS', 239, 'South Georgia and the South Sandwich Islands', 'Antarctic Region', 'Pound Sterling', 'GBP'),
('GT', 'GTM', 320, 'Guatemala', 'Central America and the Caribbean', 'Quetzal', 'GTQ'),
('GU', 'GUM', 316, 'Guam', 'Oceania', 'US Dollar', 'USD'),
('GW', 'GNB', 624, 'Guinea-Bissau', 'Africa', 'CFA Franc BCEAO', 'XOF'),
('GY', 'GUY', 328, 'Guyana', 'South America', 'Guyana Dollar', 'GYD'),
('HK', 'HKG', 344, 'Hong Kong (SAR)', 'Southeast Asia', 'Hong Kong Dollar', 'HKD'),
('HM', 'HMD', 334, 'Heard Island and McDonald Islands', 'Antarctic Region', 'Australian Dollar', 'AUD'),
('HN', 'HND', 340, 'Honduras', 'Central America and the Caribbean', 'Lempira', 'HNL'),
('HR', 'HRV', 191, 'Croatia', 'Europe', 'Kuna', 'HRK'),
('HT', 'HTI', 332, 'Haiti', 'Central America and the Caribbean', 'Gourde', 'HTG'),
('HU', 'HUN', 348, 'Hungary', 'Europe', 'Forint', 'HUF'),
('ID', 'IDN', 360, 'Indonesia', 'Southeast Asia', 'Rupiah', 'IDR'),
('IE', 'IRL', 372, 'Ireland', 'Europe', 'Euro', 'EUR'),
('IL', 'ISR', 376, 'Israel', 'Middle East', 'New Israeli Sheqel', 'ILS'),
('IM', 'IMN', 833, 'Isle of Man', 'Europe', 'Pound sterling', 'GBP'),
('IN', 'IND', 356, 'India', 'Asia', 'Indian Rupee', 'INR'),
('IO', 'IOT', 86, 'British Indian Ocean Territory', 'World', 'US Dollar', 'USD'),
('IQ', 'IRQ', 368, 'Iraq', 'Middle East', 'Iraqi Dinar', 'IQD'),
('IR', 'IRN', 364, 'Iran', 'Middle East', 'Iranian Rial', 'IRR'),
('IS', 'ISL', 352, 'Iceland', 'Arctic Region', 'Iceland Krona', 'ISK'),
('IT', 'ITA', 380, 'Italy', 'Europe', 'Euro', 'EUR'),
('JE', 'JEY', 832, 'Jersey', 'Europe', 'Pound sterling', 'GBP'),
('JM', 'JAM', 388, 'Jamaica', 'Central America and the Caribbean', 'Jamaican dollar', 'JMD'),
('JO', 'JOR', 400, 'Jordan', 'Middle East', 'Jordanian Dinar', 'JOD'),
('JP', 'JPN', 392, 'Japan', 'Asia', 'Yen', 'JPY'),
('KE', 'KEN', 404, 'Kenya', 'Africa', 'Kenyan shilling', 'KES'),
('KG', 'KGZ', 417, 'Kyrgyzstan', 'Commonwealth of Independent States', 'Som', 'KGS'),
('KH', 'KHM', 116, 'Cambodia', 'Southeast Asia', 'Riel', 'KHR'),
('KI', 'KIR', 296, 'Kiribati', 'Oceania', 'Australian dollar', 'AUD'),
('KM', 'COM', 174, 'Comoros', 'Africa', 'Comoro Franc', 'KMF'),
('KN', 'KNA', 659, 'Saint Kitts and Nevis', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'),
('KP', 'PRK', 408, 'Korea, North', 'Asia', 'North Korean Won', 'KPW'),
('KR', 'KOR', 410, 'Korea, South', 'Asia', 'Won', 'KRW'),
('KW', 'KWT', 414, 'Kuwait', 'Middle East', 'Kuwaiti Dinar', 'KWD'),
('KY', 'CYM', 136, 'Cayman Islands', 'Central America and the Caribbean', 'Cayman Islands Dollar', 'KYD'),
('KZ', 'KAZ', 398, 'Kazakhstan', 'Commonwealth of Independent States', 'Tenge', 'KZT'),
('LA', 'LAO', 418, 'Laos', 'Southeast Asia', 'Kip', 'LAK'),
('LB', 'LBN', 422, 'Lebanon', 'Middle East', 'Lebanese Pound', 'LBP'),
('LC', 'LCA', 662, 'Saint Lucia', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'),
('LI', 'LIE', 438, 'Liechtenstein', 'Europe', 'Swiss Franc', 'CHF'),
('LK', 'LKA', 144, 'Sri Lanka', 'Asia', 'Sri Lanka Rupee', 'LKR'),
('LR', 'LBR', 430, 'Liberia', 'Africa', 'Liberian Dollar', 'LRD'),
('LS', 'LSO', 426, 'Lesotho', 'Africa', 'Loti', 'LSL'),
('LT', 'LTU', 440, 'Lithuania', 'Europe', 'Lithuanian Litas', 'LTL'),
('LU', 'LUX', 442, 'Luxembourg', 'Europe', 'Euro', 'EUR'),
('LV', 'LVA', 428, 'Latvia', 'Europe', 'Latvian Lats', 'LVL'),
('LY', 'LBY', 434, 'Libya', 'Africa', 'Libyan Dinar', 'LYD'),
('MA', 'MAR', 504, 'Morocco', 'Africa', 'Moroccan Dirham', 'MAD'),
('MC', 'MCO', 492, 'Monaco', 'Europe', 'Euro', 'EUR'),
('MD', 'MDA', 498, 'Moldova', 'Commonwealth of Independent States', 'Moldovan Leu', 'MDL'),
('ME', 'MNE', 499, 'Montenegro', 'Europe', 'Euro', 'EUR'),
('MF', 'MAF', 663, 'Saint Martin (French part)', 'Central America and the Caribbean', 'Euro', 'EUR'),
('MG', 'MDG', 450, 'Madagascar', 'Africa', 'Malagasy Franc', 'MGF'),
('MH', 'MHL', 584, 'Marshall Islands', 'Oceania', 'US dollar', 'USD'),
('MK', 'MKD', 807, 'Macedonia, The Former Yugoslav Republic of', 'Europe', 'Denar', 'MKD'),
('ML', 'MLI', 466, 'Mali', 'Africa', 'CFA Franc BCEAO', 'XOF'),
('MM', 'MMR', 104, 'Myanmar', 'Southeast Asia', 'kyat', 'MMK'),
('MN', 'MNG', 496, 'Mongolia', 'Asia', 'Tugrik', 'MNT'),
('MO', 'MAC', 446, 'Macao', 'Southeast Asia', 'Pataca', 'MOP'),
('MP', 'MNP', 580, 'Northern Mariana Islands', 'Oceania', 'US Dollar', 'USD'),
('MQ', 'MTQ', 474, 'Martinique', 'Central America and the Caribbean', 'Euro', 'EUR'),
('MR', 'MRT', 478, 'Mauritania', 'Africa', 'Ouguiya', 'MRO'),
('MS', 'MSR', 500, 'Montserrat', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'),
('MT', 'MLT', 470, 'Malta', 'Europe', 'Maltese Lira', 'MTL'),
('MU', 'MUS', 480, 'Mauritius', 'World', 'Mauritius Rupee', 'MUR'),
('MV', 'MDV', 462, 'Maldives', 'Asia', 'Rufiyaa', 'MVR'),
('MW', 'MWI', 454, 'Malawi', 'Africa', 'Kwacha', 'MWK'),
('MX', 'MEX', 484, 'Mexico', 'North America', 'Mexican Peso', 'MXN'),
('MY', 'MYS', 458, 'Malaysia', 'Southeast Asia', 'Malaysian Ringgit', 'MYR'),
('MZ', 'MOZ', 508, 'Mozambique', 'Africa', 'Metical', 'MZM'),
('NA', 'NAM', 516, 'Namibia', 'Africa', 'Namibian Dollar', 'NAD'),
('NC', 'NCL', 540, 'New Caledonia', 'Oceania', 'CFP Franc', 'XPF'),
('NE', 'NER', 562, 'Niger', 'Africa', 'CFA Franc BCEAO', 'XOF'),
('NF', 'NFK', 574, 'Norfolk Island', 'Oceania', 'Australian Dollar', 'AUD'),
('NG', 'NGA', 566, 'Nigeria', 'Africa', 'Naira', 'NGN'),
('NI', 'NIC', 558, 'Nicaragua', 'Central America and the Caribbean', 'Cordoba Oro', 'NIO'),
('NL', 'NLD', 528, 'Netherlands', 'Europe', 'Euro', 'EUR'),
('NO', 'NOR', 578, 'Norway', 'Europe', 'Norwegian Krone', 'NOK'),
('NP', 'NPL', 524, 'Nepal', 'Asia', 'Nepalese Rupee', 'NPR'),
('NR', 'NRU', 520, 'Nauru', 'Oceania', 'Australian Dollar', 'AUD'),
('NU', 'NIU', 570, 'Niue', 'Oceania', 'New Zealand Dollar', 'NZD'),
('NZ', 'NZL', 554, 'New Zealand', 'Oceania', 'New Zealand Dollar', 'NZD'),
('OM', 'OMN', 512, 'Oman', 'Middle East', 'Rial Omani', 'OMR'),
('PA', 'PAN', 591, 'Panama', 'Central America and the Caribbean', 'balboa', 'PAB'),
('PE', 'PER', 604, 'Peru', 'South America', 'Nuevo Sol', 'PEN'),
('PF', 'PYF', 258, 'French Polynesia', 'Oceania', 'CFP Franc', 'XPF'),
('PG', 'PNG', 598, 'Papua New Guinea', 'Oceania', 'Kina', 'PGK'),
('PH', 'PHL', 608, 'Philippines', 'Southeast Asia', 'Philippine Peso', 'PHP'),
('PK', 'PAK', 586, 'Pakistan', 'Asia', 'Pakistan Rupee', 'PKR'),
('PL', 'POL', 616, 'Poland', 'Europe', 'Zloty', 'PLN'),
('PM', 'SPM', 666, 'Saint Pierre and Miquelon', 'North America', 'Euro', 'EUR'),
('PN', 'PCN', 612, 'Pitcairn Islands', 'Oceania', 'New Zealand Dollar', 'NZD'),
('PR', 'PRI', 630, 'Puerto Rico', 'Central America and the Caribbean', 'US dollar', 'USD'),
('PS', 'PSE', 275, 'Palestinian Territory, Occupied', NULL, NULL, NULL),
('PT', 'PRT', 620, 'Portugal', 'Europe', 'Euro', 'EUR'),
('PW', 'PLW', 585, 'Palau', 'Oceania', 'US dollar', 'USD'),
('PY', 'PRY', 600, 'Paraguay', 'South America', 'Guarani', 'PYG'),
('QA', 'QAT', 634, 'Qatar', 'Middle East', 'Qatari Rial', 'QAR'),
('RE', 'REU', 638, 'Reunion', 'World', 'Euro', 'EUR'),
('RO', 'ROU', 642, 'Romania', 'Europe', 'Leu', 'ROL'),
('RS', 'SRB', 688, 'Serbia', 'Europe', 'Serbian Dinar', 'RSD'),
('RU', 'RUS', 643, 'Russia', 'Asia', 'Russian Ruble', 'RUB'),
('RW', 'RWA', 646, 'Rwanda', 'Africa', 'Rwanda Franc', 'RWF'),
('SA', 'SAU', 682, 'Saudi Arabia', 'Middle East', 'Saudi Riyal', 'SAR'),
('SB', 'SLB', 90, 'Solomon Islands', 'Oceania', 'Solomon Islands Dollar', 'SBD'),
('SC', 'SYC', 690, 'Seychelles', 'Africa', 'Seychelles Rupee', 'SCR'),
('SD', 'SDN', 736, 'Sudan', 'Africa', 'Sudanese Dinar', 'SDD'),
('SE', 'SWE', 752, 'Sweden', 'Europe', 'Swedish Krona', 'SEK'),
('SG', 'SGP', 702, 'Singapore', 'Southeast Asia', 'Singapore Dollar', 'SGD'),
('SH', 'SHN', 654, 'Saint Helena', 'Africa', 'Saint Helenian Pound', 'SHP'),
('SI', 'SVN', 705, 'Slovenia', 'Europe', 'Tolar', 'SIT'),
('SJ', 'SJM', 744, 'Svalbard', 'Arctic Region', 'Norwegian Krone', 'NOK'),
('SK', 'SVK', 703, 'Slovakia', 'Europe', 'Slovak Koruna', 'SKK'),
('SL', 'SLE', 694, 'Sierra Leone', 'Africa', 'Leone', 'SLL'),
('SM', 'SMR', 674, 'San Marino', 'Europe', 'Euro', 'EUR'),
('SN', 'SEN', 686, 'Senegal', 'Africa', 'CFA Franc BCEAO', 'XOF'),
('SO', 'SOM', 706, 'Somalia', 'Africa', 'Somali Shilling', 'SOS'),
('SR', 'SUR', 740, 'Suriname', 'South America', 'Suriname Guilder', 'SRG'),
('ST', 'STP', 678, 'Sao Tome and Principe', 'Africa', 'Dobra', 'STD'),
('SV', 'SLV', 222, 'El Salvador', 'Central America and the Caribbean', 'El Salvador Colon', 'SVC'),
('SY', 'SYR', 760, 'Syria', 'Middle East', 'Syrian Pound', 'SYP'),
('SZ', 'SWZ', 748, 'Swaziland', 'Africa', 'Lilangeni', 'SZL'),
('TC', 'TCA', 796, 'Turks and Caicos Islands', 'Central America and the Caribbean', 'US Dollar', 'USD'),
('TD', 'TCD', 148, 'Chad', 'Africa', 'CFA Franc BEAC', 'XAF'),
('TF', 'ATF', 260, 'French Southern and Antarctic Lands', 'Antarctic Region', 'Euro', 'EUR'),
('TG', 'TGO', 768, 'Togo', 'Africa', 'CFA Franc BCEAO', 'XOF'),
('TH', 'THA', 764, 'Thailand', 'Southeast Asia', 'Baht', 'THB'),
('TJ', 'TJK', 762, 'Tajikistan', 'Commonwealth of Independent States', 'Somoni', 'TJS'),
('TK', 'TKL', 772, 'Tokelau', 'Oceania', 'New Zealand Dollar', 'NZD'),
('TL', 'TLS', 626, 'East Timor', NULL, 'Timor Escudo', 'TPE'),
('TM', 'TKM', 795, 'Turkmenistan', 'Commonwealth of Independent States', 'Manat', 'TMM'),
('TN', 'TUN', 788, 'Tunisia', 'Africa', 'Tunisian Dinar', 'TND'),
('TO', 'TON', 776, 'Tonga', 'Oceania', 'Pa''anga', 'TOP'),
('TR', 'TUR', 792, 'Turkey', 'Middle East', 'Turkish Lira', 'TRL'),
('TT', 'TTO', 780, 'Trinidad and Tobago', 'Central America and the Caribbean', 'Trinidad and Tobago Dollar', 'TTD'),
('TV', 'TUV', 798, 'Tuvalu', 'Oceania', 'Australian Dollar', 'AUD'),
('TW', 'TWN', 158, 'Taiwan', 'Southeast Asia', 'New Taiwan Dollar', 'TWD'),
('TZ', 'TZA', 834, 'Tanzania', 'Africa', 'Tanzanian Shilling', 'TZS'),
('UA', 'UKR', 804, 'Ukraine', 'Commonwealth of Independent States', 'Hryvnia', 'UAH'),
('UG', 'UGA', 800, 'Uganda', 'Africa', 'Uganda Shilling', 'UGX'),
('UM', 'UMI', 581, 'United States Minor Outlying Islands', NULL, 'US Dollar', 'USD'),
('US', 'USA', 840, 'United States', 'North America', 'US Dollar', 'USD'),
('UY', 'URY', 858, 'Uruguay', 'South America', 'Peso Uruguayo', 'UYU'),
('UZ', 'UZB', 860, 'Uzbekistan', 'Commonwealth of Independent States', 'Uzbekistan Sum', 'UZS'),
('VA', 'VAT', 336, 'Holy See (Vatican City)', 'Europe', 'Euro', 'EUR'),
('VC', 'VCT', 670, 'Saint Vincent and the Grenadines', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'),
('VE', 'VEN', 862, 'Venezuela', 'South America, Central America and the Caribbean', 'Bolivar', 'VEB'),
('VG', 'VGB', 92, 'British Virgin Islands', 'Central America and the Caribbean', 'US dollar', 'USD'),
('VI', 'VIR', 850, 'Virgin Islands', 'Central America and the Caribbean', 'US Dollar', 'USD'),
('VN', 'VNM', 704, 'Vietnam', 'Southeast Asia', 'Dong', 'VND'),
('VU', 'VUT', 548, 'Vanuatu', 'Oceania', 'Vatu', 'VUV'),
('WF', 'WLF', 876, 'Wallis and Futuna', 'Oceania', 'CFP Franc', 'XPF'),
('WS', 'WSM', 882, 'Samoa', 'Oceania', 'Tala', 'WST'),
('YE', 'YEM', 887, 'Yemen', 'Middle East', 'Yemeni Rial', 'YER'),
('YT', 'MYT', 175, 'Mayotte', 'Africa', 'Euro', 'EUR'),
('ZA', 'ZAF', 710, 'South Africa', 'Africa', 'Rand', 'ZAR'),
('ZM', 'ZWB', 894, 'Zambia', 'Africa', 'Kwacha', 'ZMK'),
('ZW', 'ZWE', 716, 'Zimbabwe', 'Africa', 'Zimbabwe Dollar', 'ZWD');

-- --------------------------------------------------------

--
-- Table structure for table `sys_cron_jobs`
--

CREATE TABLE `sys_cron_jobs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '',
  `time` varchar(128) NOT NULL DEFAULT '*',
  `class` varchar(128) NOT NULL DEFAULT '',
  `file` varchar(255) NOT NULL DEFAULT '',
  `eval` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `sys_cron_jobs`
--

INSERT INTO `sys_cron_jobs` VALUES
(1, 'cmd', '0 0 * * *', 'BxDolCronCmd', 'inc/classes/BxDolCronCmd.php', ''),
(2, 'notifies', '*/10 * * * *', 'BxDolCronNotifies', 'inc/classes/BxDolCronNotifies.php', ''),
(3, 'video_comments', '* * * * *', 'BxDolCronVideoComments', 'flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php', ''),
(4, 'sitemap', '0 2 * * *', '', '', 'bx_import(''BxDolSiteMaps'');\r\nBxDolSiteMaps::generateAllSiteMaps();'),
(5, 'modules', '0 0 * * 0', 'BxDolCronModules', 'inc/classes/BxDolCronModules.php', '');

-- --------------------------------------------------------

--
-- Table structure for table `sys_dnsbluri_zones`
--

CREATE TABLE `sys_dnsbluri_zones` (
  `level` tinyint(4) NOT NULL,
  `zone` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_dnsbl_rules`
--

CREATE TABLE `sys_dnsbl_rules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `chain` enum('spammers','whitelist','uridns') NOT NULL,
  `zonedomain` varchar(255) NOT NULL,
  `postvresp` varchar(32) NOT NULL,
  `url` varchar(255) NOT NULL,
  `recheck` varchar(255) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `added` int(11) NOT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `sys_dnsbl_rules`
--

INSERT INTO `sys_dnsbl_rules` VALUES
(1, 'whitelist', 'au.countries.nerd.dk.', '127.0.0.2', 'http://countries.nerd.dk/', '', 'Country based zone, any ip from Australia is whitelisted', 1287642420, 0),
(2, 'spammers', 'sbl.spamhaus.org.', 'any', 'http://www.spamhaus.org/sbl/', 'http://www.spamhaus.org/query/bl?ip=%s', 'Any non-failure result from sbl.spamhaus.org is a positive match', 1287642420, 1),
(4, 'spammers', 'cn.countries.nerd.dk.', '127.0.0.2', 'http://countries.nerd.dk/', '', 'Country based zone, any ip from China is blocked', 1287642420, 0),
(5, 'uridns', 'multi.surbl.org.', 'any', 'http://www.surbl.org/', 'http://george.surbl.org/lookup.html', 'SURBLs are lists of web sites that have appeared in unsolicited messages. Unlike most lists, SURBLs are not lists of message senders.', 1287642420, 1),
(6, 'spammers', 'dnsbl.dronebl.org.', '127.0.0.5', 'http://www.dronebl.org/', 'http://www.dronebl.org/lookup?ip=%s', 'Bottler', 1368854835, 1),
(7, 'spammers', 'dnsbl.dronebl.org.', '127.0.0.6', 'http://www.dronebl.org/', 'http://www.dronebl.org/lookup?ip=%s', 'Unknown spambot or drone', 1368854835, 1),
(8, 'spammers', 'dnsbl.dronebl.org.', '127.0.0.7', 'http://www.dronebl.org/', 'http://www.dronebl.org/lookup?ip=%s', 'DDOS Drone', 1368854835, 1),
(9, 'spammers', 'dnsbl.dronebl.org.', '127.0.0.8', 'http://www.dronebl.org/', 'http://www.dronebl.org/lookup?ip=%s', 'SOCKS Proxy', 1368854835, 1),
(10, 'spammers', 'dnsbl.dronebl.org.', '127.0.0.9', 'http://www.dronebl.org/', 'http://www.dronebl.org/lookup?ip=%s', 'HTTP Proxy', 1368854835, 1),
(11, 'spammers', 'dnsbl.dronebl.org.', '127.0.0.10', 'http://www.dronebl.org/', 'http://www.dronebl.org/lookup?ip=%s', 'ProxyChain', 1368854835, 1),
(12, 'spammers', 'dnsbl.dronebl.org.', '127.0.0.14', 'http://www.dronebl.org/', 'http://www.dronebl.org/lookup?ip=%s', 'Open Wingate Proxy', 1368854835, 1),
(13, 'spammers', 'dnsbl.dronebl.org.', '127.0.0.15', 'http://www.dronebl.org/', 'http://www.dronebl.org/lookup?ip=%s', 'Compromised router / gateway', 1368854835, 1),
(14, 'spammers', 'dnsbl.tornevall.org.', '230', 'http://dnsbl.tornevall.org/', '', 'Block anonymous/elite proxies and abuse IPs', 1369274751, 1),
(15, 'spammers', 'uribl.swinog.ch.', '127.0.0.3', 'http://antispam.imp.ch/06-dnsbl.php?lng=1', '', 'ImproWare Antispam', 1393336086, 0),
(16, 'uridns', 'uribl.swinog.ch.', 'any', 'http://antispam.imp.ch/05-uribl.php?lng=1', '', 'ImproWare Antispam', 1393336170, 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_email_templates`
--

CREATE TABLE `sys_email_templates` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL,
  `Subject` varchar(255) NOT NULL,
  `Body` text NOT NULL,
  `Desc` varchar(255) NOT NULL,
  `LangID` tinyint(4) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`ID`),
  KEY `Name` (`Name`,`LangID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;



-- --------------------------------------------------------

--
-- Table structure for table `sys_fave_list`
--

CREATE TABLE `sys_fave_list` (
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Profile` int(10) unsigned NOT NULL DEFAULT '0',
  `When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `HotPair` (`ID`,`Profile`),
  KEY `ID` (`ID`),
  KEY `Profile` (`Profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_friend_list`
--

CREATE TABLE `sys_friend_list` (
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Profile` int(10) unsigned NOT NULL DEFAULT '0',
  `Check` tinyint(2) NOT NULL DEFAULT '0',
  `When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `FriendPair` (`ID`,`Profile`),
  KEY `Profile` (`Profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_greetings`
--

CREATE TABLE `sys_greetings` (
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Profile` int(10) unsigned NOT NULL DEFAULT '0',
  `Number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `When` date NOT NULL DEFAULT '0000-00-00',
  `New` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`ID`,`Profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_ip_list`
--

CREATE TABLE `sys_ip_list` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `From` int(10) unsigned NOT NULL,
  `To` int(10) unsigned NOT NULL,
  `Type` enum('allow','deny') NOT NULL DEFAULT 'deny',
  `LastDT` int(11) unsigned NOT NULL,
  `Desc` varchar(128) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `From` (`From`),
  KEY `To` (`To`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_ip_members_visits`
--

CREATE TABLE `sys_ip_members_visits` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `MemberID` int(10) unsigned NOT NULL,
  `From` int(10) unsigned NOT NULL,
  `DateTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `From` (`From`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_localization_categories`
--

CREATE TABLE `sys_localization_categories` (
  `ID` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_localization_categories`
--

INSERT INTO `sys_localization_categories` VALUES
(1, 'System');

-- --------------------------------------------------------

--
-- Table structure for table `sys_localization_keys`
--

CREATE TABLE `sys_localization_keys` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `IDCategory` int(6) unsigned NOT NULL DEFAULT '0',
  `Key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Key` (`Key`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2269 ;


INSERT INTO `sys_localization_keys` VALUES
(1490, 1, '_greeting'),
(1491, 1, '_help'),
(1492, 1, '_hidden_comment'),
(1493, 1, '_in_x_days'),
(1494, 1, '_in_x_days_short'),
(1495, 1, '_in_x_hour'),
(1496, 1, '_in_x_hours'),
(1497, 1, '_in_x_hours_short'),
(1498, 1, '_in_x_minutes'),
(1499, 1, '_in_x_minutes_short'),
(1500, 1, '_item'),
(1501, 1, '_items'),
(1502, 1, '_join_form_note'),
(1503, 1, '_just_now'),
(1504, 1, '_kilometers'),
(1505, 1, '_letter'),
(1506, 1, '_living within'),
(1507, 1, '_loading ...'),
(1508, 1, '_login_form_description2join'),
(1509, 1, '_male'),
(1510, 1, '_media_flash_warning'),
(1511, 1, '_member_banned'),
(1512, 1, '_membership'),
(1513, 1, '_message_subject'),
(1514, 1, '_miles'),
(1515, 1, '_mma_comments_edit_own'),
(1516, 1, '_mma_comments_post'),
(1517, 1, '_mma_comments_remove_own'),
(1518, 1, '_mma_comments_vote'),
(1519, 1, '_mma_get_other_members_emails'),
(1520, 1, '_mma_send_friend_request'),
(1521, 1, '_mma_send_greetings'),
(1522, 1, '_mma_send_messages'),
(1523, 1, '_mma_view_profiles'),
(1524, 1, '_mma_vote'),
(1525, 1, '_mmbuilder_box_title'),
(1526, 1, '_mmbuilder_page_title'),
(1527, 1, '_month_next'),
(1528, 1, '_month_next_mini'),
(1529, 1, '_month_prev'),
(1530, 1, '_month_prev_mini'),
(1531, 1, '_more'),
(1532, 1, '_new'),
(1533, 1, '_newest first'),
(1534, 1, '_no limit'),
(1535, 1, '_not_a_member'),
(1536, 1, '_of'),
(1537, 1, '_oldest first'),
(1538, 1, '_online only'),
(1539, 1, '_or'),
(1540, 1, '_pending_friend_request'),
(1541, 1, '_pending_friend_request_answer'),
(1542, 1, '_pfm_unlimited'),
(1543, 1, '_please_fill_next_fields_first'),
(1544, 1, '_popular_tags'),
(1545, 1, '_post_successfully_deleted'),
(1546, 1, '_powered_by_Dolphin'),
(1547, 1, '_prof_status'),
(1548, 1, '_profile_comments'),
(1549, 1, '_profile_info'),
(1550, 1, '_ps_bcpt_add_members'),
(1551, 1, '_ps_bcpt_block_privacy'),
(1552, 1, '_ps_bcpt_create_group'),
(1553, 1, '_ps_bcpt_default_group'),
(1554, 1, '_ps_bcpt_default_values'),
(1555, 1, '_ps_bcpt_delete_members'),
(1556, 1, '_ps_bcpt_my_groups'),
(1557, 1, '_ps_btncpt_add'),
(1558, 1, '_ps_btncpt_create'),
(1559, 1, '_ps_btncpt_delete'),
(1560, 1, '_ps_btncpt_save'),
(1561, 1, '_ps_btncpt_search'),
(1562, 1, '_ps_cpt_extended'),
(1563, 1, '_ps_cpt_none'),
(1564, 1, '_ps_fcpt_extends'),
(1565, 1, '_ps_fcpt_groups'),
(1566, 1, '_ps_fcpt_keyword'),
(1567, 1, '_ps_fcpt_title'),
(1568, 1, '_ps_ferr_incorrect_length'),
(1569, 1, '_ps_ferr_incorrect_select'),
(1570, 1, '_ps_fnote_default_group'),
(1571, 1, '_ps_group_1_title'),
(1572, 1, '_ps_group_2_title'),
(1573, 1, '_ps_group_3_title'),
(1574, 1, '_ps_group_4_title'),
(1575, 1, '_ps_group_5_title'),
(1576, 1, '_ps_group_6_title'),
(1577, 1, '_ps_group_7_title'),
(1578, 1, '_ps_lcpt_add'),
(1579, 1, '_ps_lcpt_delete'),
(1580, 1, '_ps_pcpt_privacy_settings'),
(1581, 1, '_ps_tmenu_privacy_settings'),
(1582, 1, '_ps_view_block'),
(1583, 1, '_public'),
(1584, 1, '_rate profile'),
(1585, 1, '_registration by invitation only'),
(1586, 1, '_sbd_Android_desc'),
(1587, 1, '_sbd_Android_title'),
(1588, 1, '_sbd_iPhone_desc'),
(1589, 1, '_sbd_iPhone_title'),
(1590, 1, '_sbs_tmenu_my_subscriptions'),
(1591, 1, '_sbs_txt_sbs_mass_mailer'),
(1592, 1, '_sbs_txt_sbs_profile'),
(1593, 1, '_sbs_txt_sbs_profile_comments'),
(1594, 1, '_sbs_txt_sbs_profile_edit'),
(1595, 1, '_sbs_txt_title_profile'),
(1596, 1, '_sbs_txt_title_system'),
(1597, 1, '_sbs_wrn_email_notify_disabled'),
(1598, 1, '_sbs_wrn_unsubscribe'),
(1599, 1, '_search_tab_Adv'),
(1600, 1, '_search_tab_quick'),
(1601, 1, '_search_tab_simple'),
(1602, 1, '_services'),
(1603, 1, '_show_replacement'),
(1604, 1, '_sys_add_content'),
(1605, 1, '_sys_adm_akismet_key_empty'),
(1606, 1, '_sys_adm_akismet_key_invalid'),
(1607, 1, '_sys_adm_akismet_key_valid'),
(1608, 1, '_sys_adm_available'),
(1609, 1, '_sys_adm_btn_dnsbl_activate'),
(1610, 1, '_sys_adm_btn_dnsbl_add'),
(1611, 1, '_sys_adm_btn_dnsbl_deactivate'),
(1612, 1, '_sys_adm_btn_dnsbl_delete'),
(1613, 1, '_sys_adm_btn_dnsbl_help'),
(1614, 1, '_sys_adm_btn_dnsbl_help_text'),
(1615, 1, '_sys_adm_btn_dnsbl_log'),
(1616, 1, '_sys_adm_btn_dnsbl_recheck'),
(1617, 1, '_sys_adm_btn_dnsbluri_help_text'),
(1618, 1, '_sys_adm_cache_support'),
(1619, 1, '_sys_adm_disabled'),
(1620, 1, '_sys_adm_dnsbl_failed'),
(1621, 1, '_sys_adm_dnsbl_listed'),
(1622, 1, '_sys_adm_dnsbl_not_listed'),
(1623, 1, '_sys_adm_enabled'),
(1624, 1, '_sys_adm_fld_dnsbl_active'),
(1625, 1, '_sys_adm_fld_dnsbl_chain'),
(1626, 1, '_sys_adm_fld_dnsbl_comment'),
(1627, 1, '_sys_adm_fld_dnsbl_postvresp'),
(1628, 1, '_sys_adm_fld_dnsbl_recheck'),
(1629, 1, '_sys_adm_fld_dnsbl_recheck_url'),
(1630, 1, '_sys_adm_fld_dnsbl_url'),
(1631, 1, '_sys_adm_fld_dnsbl_zonedomain'),
(1632, 1, '_sys_adm_fld_dnsbluri_recheck'),
(1633, 1, '_sys_adm_form_err_required_field'),
(1634, 1, '_sys_adm_installed'),
(1635, 1, '_sys_adm_page_cpt_akismet'),
(1636, 1, '_sys_adm_page_cpt_dnsbl'),
(1637, 1, '_sys_adm_page_cpt_stopforumspam'),
(1638, 1, '_sys_adm_page_cpt_uridnsbl'),
(1639, 1, '_sys_adm_stopforumspam_key_empty'),
(1640, 1, '_sys_adm_stopforumspam_key_specified'),
(1641, 1, '_sys_adm_title_akismet_log'),
(1642, 1, '_sys_adm_title_dnsbl_log'),
(1643, 1, '_sys_adm_title_dnsbl_recheck'),
(1644, 1, '_sys_adm_title_dnsbluri_log'),
(1645, 1, '_sys_adm_title_dnsbluri_recheck'),
(1646, 1, '_sys_adm_title_stopforumspam_log'),
(1647, 1, '_sys_admin_apply'),
(1648, 1, '_sys_admin_filter'),
(1649, 1, '_sys_album'),
(1650, 1, '_sys_album_add'),
(1651, 1, '_sys_album_cancel'),
(1652, 1, '_sys_album_caption_capt'),
(1653, 1, '_sys_album_caption_desc'),
(1654, 1, '_sys_album_caption_loc'),
(1655, 1, '_sys_album_caption_new'),
(1656, 1, '_sys_album_create'),
(1657, 1, '_sys_album_create_new'),
(1658, 1, '_sys_album_delete'),
(1659, 1, '_sys_album_edit_info'),
(1660, 1, '_sys_album_edit_items'),
(1661, 1, '_sys_album_err_desc'),
(1662, 1, '_sys_album_move_to_another'),
(1663, 1, '_sys_album_organize'),
(1664, 1, '_sys_album_privacy_me_info'),
(1665, 1, '_sys_album_private'),
(1666, 1, '_sys_album_save_changes'),
(1667, 1, '_sys_album_x'),
(1668, 1, '_sys_album_x_photo_x'),
(1669, 1, '_sys_am_account_profile_page'),
(1670, 1, '_sys_am_mailbox_compose'),
(1671, 1, '_sys_am_profile_account_page'),
(1672, 1, '_sys_am_profile_friend_accept'),
(1673, 1, '_sys_am_profile_friend_add'),
(1674, 1, '_sys_am_profile_friend_cancel'),
(1675, 1, '_sys_am_profile_message'),
(1676, 1, '_sys_auth_join_with'),
(1677, 1, '_sys_auth_login_with'),
(1678, 1, '_sys_bcpt_member_account_control'),
(1679, 1, '_sys_bcpt_member_friend_requests'),
(1680, 1, '_sys_bcpt_member_new_messages'),
(1681, 1, '_sys_bcpt_my_subscriptions'),
(1682, 1, '_sys_bcpt_profile_cover'),
(1683, 1, '_sys_bcpt_subscribe'),
(1684, 1, '_sys_block_title_social_sharing'),
(1685, 1, '_sys_block_title_forum_feed'),
(1686, 1, '_sys_bm_design'),
(1687, 1, '_sys_bm_language'),
(1688, 1, '_sys_bm_popup_cpt_design'),
(1689, 1, '_sys_bm_popup_cpt_language'),
(1690, 1, '_sys_box_title_download'),
(1691, 1, '_sys_box_title_search_keyword'),
(1692, 1, '_sys_box_title_search_people'),
(1693, 1, '_sys_btn_thumbnail_change'),
(1694, 1, '_sys_btn_cover_change'),
(1695, 1, '_sys_btn_fans_add_to_admins'),
(1696, 1, '_sys_btn_fans_confirm'),
(1697, 1, '_sys_btn_fans_move_admins_to_fans'),
(1698, 1, '_sys_btn_fans_reject'),
(1699, 1, '_sys_btn_fans_remove'),
(1700, 1, '_sys_btn_sbs_send'),
(1701, 1, '_sys_btn_sbs_subscribe'),
(1702, 1, '_sys_btn_sbs_unsubscribe'),
(1703, 1, '_sys_bx_attr'),
(1704, 1, '_sys_calendar'),
(1705, 1, '_sys_city_country_format'),
(1706, 1, '_sys_cnts_bcpt_connections'),
(1707, 1, '_sys_cnts_bcpt_fave'),
(1708, 1, '_sys_cnts_bcpt_fave_remove'),
(1709, 1, '_sys_cnts_bcpt_friend_requests'),
(1710, 1, '_sys_cnts_btn_fave'),
(1711, 1, '_sys_cnts_btn_fr_accept'),
(1712, 1, '_sys_cnts_btn_fr_reject'),
(1713, 1, '_sys_cnts_msg_fr_empty'),
(1714, 1, '_sys_cnts_txt_blocked'),
(1715, 1, '_sys_cnts_txt_favorites'),
(1716, 1, '_sys_cnts_txt_frients'),
(1717, 1, '_sys_cnts_txt_mf_no'),
(1718, 1, '_sys_cnts_txt_mutual_friends'),
(1719, 1, '_sys_email_footer_info'),
(1720, 1, '_sys_err_categories'),
(1721, 1, '_sys_export_success'),
(1722, 1, '_sys_invitation_step_additional_emails'),
(1723, 1, '_sys_invitation_step_additional_emails_info'),
(1724, 1, '_sys_invitation_step_invitation_text'),
(1725, 1, '_sys_invitation_step_invitation_text_info'),
(1726, 1, '_sys_invitation_step_select_users'),
(1727, 1, '_sys_invitation_step_select_users_info'),
(1728, 1, '_sys_kilobyte'),
(1729, 1, '_sys_mailbox_back_inbox'),
(1730, 1, '_sys_mailbox_back_outbox'),
(1731, 1, '_sys_mailbox_back_trash'),
(1732, 1, '_sys_member_info_username'),
(1733, 1, '_sys_member_info_first_name'),
(1734, 1, '_sys_member_info_first_name_last_name'),
(1735, 1, '_sys_member_info_last_name_firs_name'),
(1736, 1, '_sys_member_info_full_name'),
(1737, 1, '_sys_member_info_headline'),
(1738, 1, '_sys_member_info_status_message'),
(1739, 1, '_sys_member_info_age_sex'),
(1740, 1, '_sys_member_info_location'),
(1741, 1, '_sys_member_thumb_avatar'),
(1742, 1, '_sys_member_thumb_icon_avatar'),
(1743, 1, '_sys_mobile_friends'),
(1744, 1, '_sys_mobile_info'),
(1745, 1, '_sys_mobile_mail'),
(1746, 1, '_sys_mobile_profile_contact'),
(1747, 1, '_sys_mobile_profile_friends'),
(1748, 1, '_sys_mobile_profile_info'),
(1749, 1, '_sys_mobile_search'),
(1750, 1, '_sys_mobile_search_by_keyword'),
(1751, 1, '_sys_mobile_search_by_location'),
(1752, 1, '_sys_mobile_status'),
(1753, 1, '_sys_module_profile'),
(1754, 1, '_sys_outdated_browser'),
(1755, 1, '_sys_outdated_browser_explain'),
(1756, 1, '_sys_pmt_shopping_cart_caption'),
(1757, 1, '_sys_pmt_shopping_cart_description'),
(1758, 1, '_sys_pmt_tmenu_cart'),
(1759, 1, '_sys_pmt_tmenu_payments'),
(1760, 1, '_sys_pcpt_my_subscriptions'),
(1761, 1, '_sys_private'),
(1762, 1, '_sys_profile'),
(1763, 1, '_sys_profile_private_text'),
(1764, 1, '_sys_profile_private_text_title'),
(1765, 1, '_sys_profiles'),
(1766, 1, '_sys_profiles_caption_browse_by_day'),
(1767, 1, '_sys_recaptcha_incorrect'),
(1768, 1, '_sys_recaptcha_text_image'),
(1769, 1, '_sys_recaptcha_text_audio'),
(1770, 1, '_sys_recaptcha_btn_refresh'),
(1771, 1, '_sys_recaptcha_btn_title_refresh'),
(1772, 1, '_sys_recaptcha_btn_audio'),
(1773, 1, '_sys_recaptcha_btn_title_audio'),
(1774, 1, '_sys_recaptcha_btn_image'),
(1775, 1, '_sys_recaptcha_btn_title_image'),
(1776, 1, '_sys_recaptcha_btn_help'),
(1777, 1, '_sys_recaptcha_btn_title_help'),
(1778, 1, '_sys_request_method_not_found_cnt'),
(1779, 1, '_sys_request_method_not_found_cpt'),
(1780, 1, '_sys_request_module_not_found_cnt'),
(1781, 1, '_sys_request_module_not_found_cpt'),
(1782, 1, '_sys_request_page_not_found_cnt'),
(1783, 1, '_sys_request_page_not_found_cpt'),
(1784, 1, '_sys_save_nothing'),
(1785, 1, '_sys_search_main_title'),
(1786, 1, '_sys_select_one'),
(1787, 1, '_sys_sitemap'),
(1788, 1, '_sys_sitemap_desc'),
(1789, 1, '_sys_sitemap_form_caption'),
(1790, 1, '_sys_sitemap_form_caption_sitemap_generated'),
(1791, 1, '_sys_sitemap_list'),
(1792, 1, '_sys_sitemap_pages'),
(1793, 1, '_sys_sitemap_profiles'),
(1794, 1, '_sys_sitemap_profiles_info'),
(1795, 1, '_sys_sitemap_system'),
(1796, 1, '_sys_sm_account'),
(1797, 1, '_sys_sm_account_menu'),
(1798, 1, '_sys_sm_join'),
(1799, 1, '_sys_sm_join_or_login'),
(1800, 1, '_sys_sm_login'),
(1801, 1, '_sys_sm_logout'),
(1802, 1, '_sys_sm_profile'),
(1803, 1, '_sys_sm_profile_settings'),
(1804, 1, '_sys_sm_search'),
(1805, 1, '_sys_spam_detected'),
(1806, 1, '_sys_status_default'),
(1807, 1, '_sys_status_update'),
(1808, 1, '_sys_sucess_result'),
(1809, 1, '_sys_tags_note'),
(1810, 1, '_sys_top_menu_more'),
(1811, 1, '_sys_txt_ac_manage_subscriptions'),
(1812, 1, '_sys_txt_btn_loading'),
(1813, 1, '_sys_txt_captcha_not_available'),
(1814, 1, '_sys_txt_cmt_loading'),
(1815, 1, '_sys_txt_cmt_mood_negative'),
(1816, 1, '_sys_txt_cmt_mood_neutral'),
(1817, 1, '_sys_txt_cmt_mood_positive'),
(1818, 1, '_sys_txt_form_toggle_html_editor'),
(1819, 1, '_sys_txt_select_files'),
(1820, 1, '_sys_txt_sbs_already_subscribed'),
(1821, 1, '_sys_txt_sbs_already_unsubscribed'),
(1822, 1, '_sys_txt_sbs_cannot_find_subscription'),
(1823, 1, '_sys_txt_sbs_cannot_save_visitor'),
(1824, 1, '_sys_txt_sbs_email'),
(1825, 1, '_sys_txt_sbs_empty_name_email'),
(1826, 1, '_sys_txt_sbs_error_occured'),
(1827, 1, '_sys_txt_sbs_name'),
(1828, 1, '_sys_txt_sbs_success_subscribe'),
(1829, 1, '_sys_txt_sbs_success_unsubscribe'),
(1830, 1, '_sys_txt_uploader_html5'),
(1831, 1, '_sys_txt_uploader_html5_not_supported'),
(1832, 1, '_sys_txt_upload_failed'),
(1833, 1, '_sys_txt_upload_size_error'),
(1834, 1, '_sys_txt_upload_abort'),
(1835, 1, '_sys_txt_upload_done'),
(1836, 1, '_sys_txt_wrong_file_extension'),
(1837, 1, '_sys_upload'),
(1838, 1, '_sys_media_disapproved'),
(1839, 1, '_sys_media_processing'),
(1840, 1, '_sys_media_not_found'),
(1841, 1, '_sys_wrn_disabled_scripts'),
(1842, 1, '_sys_x_byte'),
(1843, 1, '_sys_x_gigabyte'),
(1844, 1, '_sys_x_kilobyte'),
(1845, 1, '_sys_x_megabyte'),
(1846, 1, '_sys_x_terabyte'),
(1847, 1, '_tags_by_day'),
(1848, 1, '_tags_calendar'),
(1849, 1, '_tags_caption_keyword'),
(1850, 1, '_tags_caption_module'),
(1851, 1, '_tags_err_keyword'),
(1852, 1, '_tags_founded_tags'),
(1853, 1, '_tags_plural'),
(1854, 1, '_tags_recent'),
(1855, 1, '_tags_search_form'),
(1856, 1, '_tags_single'),
(1857, 1, '_td_caption'),
(1858, 1, '_td_content'),
(1859, 1, '_td_date'),
(1860, 1, '_td_edit'),
(1861, 1, '_td_err_empty_value'),
(1862, 1, '_td_err_incorrect_length'),
(1863, 1, '_td_post'),
(1864, 1, '_td_snippet'),
(1865, 1, '_td_tags'),
(1866, 1, '_title_min_lenght'),
(1867, 1, '_to'),
(1868, 1, '_tomorrow'),
(1869, 1, '_top'),
(1870, 1, '_top_extra'),
(1871, 1, '_uknown'),
(1872, 1, '_undefined'),
(1873, 1, '_votes'),
(1874, 1, '_n_votes'),
(1875, 1, '_week_fri'),
(1876, 1, '_week_mon'),
(1877, 1, '_week_sat'),
(1878, 1, '_week_sun'),
(1879, 1, '_week_thu'),
(1880, 1, '_week_tue'),
(1881, 1, '_week_wed'),
(1882, 1, '_week_fri_mini'),
(1883, 1, '_week_mon_mini'),
(1884, 1, '_week_sat_mini'),
(1885, 1, '_week_sun_mini'),
(1886, 1, '_week_thu_mini'),
(1887, 1, '_week_tue_mini'),
(1888, 1, '_week_wed_mini'),
(1889, 1, '_x_days_ago'),
(1890, 1, '_x_days_ago_short'),
(1891, 1, '_x_hour_ago'),
(1892, 1, '_x_hours_ago'),
(1893, 1, '_x_hours_ago_short'),
(1894, 1, '_x_minutes_ago'),
(1895, 1, '_x_minutes_ago_short'),
(1896, 1, '_y/o'),
(1897, 1, '_yesterday'),
(1898, 1, '__$10,000-$30,000/year'),
(1899, 1, '__$10,000/year and less'),
(1900, 1, '__$30,000-$50,000/year'),
(1901, 1, '__$50,000-$70,000/year'),
(1902, 1, '__$70,000/year and more'),
(1903, 1, '__Average'),
(1904, 1, '__Ample'),
(1905, 1, '__Athletic'),
(1906, 1, '__Cuddly'),
(1907, 1, '__Slim'),
(1908, 1, '__Very Cuddly'),
(1909, 1, '__Afghanistan'),
(1910, 1, '__Albania'),
(1911, 1, '__Algeria'),
(1912, 1, '__American Samoa'),
(1913, 1, '__Andorra'),
(1914, 1, '__Angola'),
(1915, 1, '__Anguilla'),
(1916, 1, '__Antarctica'),
(1917, 1, '__Antigua and Barbuda'),
(1918, 1, '__Argentina'),
(1919, 1, '__Armenia'),
(1920, 1, '__Aruba'),
(1921, 1, '__Australia'),
(1922, 1, '__Austria'),
(1923, 1, '__Azerbaijan'),
(1924, 1, '__Bahrain'),
(1925, 1, '__Bangladesh'),
(1926, 1, '__Barbados'),
(1927, 1, '__Belarus'),
(1928, 1, '__Belgium'),
(1929, 1, '__Belize'),
(1930, 1, '__Benin'),
(1931, 1, '__Bermuda'),
(1932, 1, '__Bhutan'),
(1933, 1, '__Bolivia'),
(1934, 1, '__Botswana'),
(1935, 1, '__Bouvet Island'),
(1936, 1, '__Brazil'),
(1937, 1, '__Brunei Darussalam'),
(1938, 1, '__Bulgaria'),
(1939, 1, '__Burkina Faso'),
(1940, 1, '__Burma'),
(1941, 1, '__Burundi'),
(1942, 1, '__Cambodia'),
(1943, 1, '__Cameroon'),
(1944, 1, '__Cape Verde'),
(1945, 1, '__Cayman Islands'),
(1946, 1, '__Chad'),
(1947, 1, '__Canada'),
(1948, 1, '__Chile'),
(1949, 1, '__China'),
(1950, 1, '__Christmas Island'),
(1951, 1, '__Cote d''Ivoire'),
(1952, 1, '__Colombia'),
(1953, 1, '__Comoros'),
(1954, 1, '__Cook Islands'),
(1955, 1, '__Costa Rica'),
(1956, 1, '__Croatia'),
(1957, 1, '__Cuba'),
(1958, 1, '__Cyprus'),
(1959, 1, '__Czech Republic'),
(1960, 1, '__Denmark'),
(1961, 1, '__Djibouti'),
(1962, 1, '__Dominica'),
(1963, 1, '__Dominican Republic'),
(1964, 1, '__East Timor'),
(1965, 1, '__Ecuador'),
(1966, 1, '__Egypt'),
(1967, 1, '__El Salvador'),
(1968, 1, '__Equatorial Guinea'),
(1969, 1, '__Eritrea'),
(1970, 1, '__Estonia'),
(1971, 1, '__Ethiopia'),
(1972, 1, '__Faroe Islands'),
(1973, 1, '__Fiji'),
(1974, 1, '__Finland'),
(1975, 1, '__Falkland Islands (Islas Malvinas)'),
(1976, 1, '__France'),
(1977, 1, '__Gabon'),
(1978, 1, '__Georgia'),
(1979, 1, '__Germany'),
(1980, 1, '__Ghana'),
(1981, 1, '__Gibraltar'),
(1982, 1, '__Greece'),
(1983, 1, '__Greenland'),
(1984, 1, '__Grenada'),
(1985, 1, '__Guadeloupe'),
(1986, 1, '__Guam'),
(1987, 1, '__Guatemala'),
(1988, 1, '__Guinea'),
(1989, 1, '__Guinea-Bissau'),
(1990, 1, '__Guyana'),
(1991, 1, '__Haiti'),
(1992, 1, '__Holy See (Vatican City)'),
(1993, 1, '__Hong Kong (SAR)'),
(1994, 1, '__Honduras'),
(1995, 1, '__Hungary'),
(1996, 1, '__Iceland'),
(1997, 1, '__India'),
(1998, 1, '__Indonesia'),
(1999, 1, '__Iran'),
(2000, 1, '__Iraq'),
(2001, 1, '__Ireland'),
(2002, 1, '__Israel'),
(2003, 1, '__Italy'),
(2004, 1, '__Jamaica'),
(2005, 1, '__Japan'),
(2006, 1, '__Jordan'),
(2007, 1, '__Kazakhstan'),
(2008, 1, '__Kenya'),
(2009, 1, '__Kiribati'),
(2010, 1, '__Kuwait'),
(2011, 1, '__Kyrgyzstan'),
(2012, 1, '__Latvia'),
(2013, 1, '__Lebanon'),
(2014, 1, '__Lesotho'),
(2015, 1, '__Liberia'),
(2016, 1, '__Liechtenstein'),
(2017, 1, '__Lithuania'),
(2018, 1, '__Luxembourg'),
(2019, 1, '__Madagascar'),
(2020, 1, '__Malawi'),
(2021, 1, '__Malaysia'),
(2022, 1, '__Maldives'),
(2023, 1, '__Mali'),
(2024, 1, '__Malta'),
(2025, 1, '__Marshall Islands'),
(2026, 1, '__Martinique'),
(2027, 1, '__Mauritania'),
(2028, 1, '__Mauritius'),
(2029, 1, '__Mayotte'),
(2030, 1, '__Mexico'),
(2031, 1, '__Moldova'),
(2032, 1, '__Monaco'),
(2033, 1, '__Mongolia'),
(2034, 1, '__Montserrat'),
(2035, 1, '__Morocco'),
(2036, 1, '__Mozambique'),
(2037, 1, '__Namibia'),
(2038, 1, '__Nauru'),
(2039, 1, '__Nepal'),
(2040, 1, '__Netherlands'),
(2041, 1, '__New Caledonia'),
(2042, 1, '__New Zealand'),
(2043, 1, '__Nicaragua'),
(2044, 1, '__Niger'),
(2045, 1, '__Nigeria'),
(2046, 1, '__Niue'),
(2047, 1, '__Norfolk Island'),
(2048, 1, '__Norway'),
(2049, 1, '__Oman'),
(2050, 1, '__Pakistan'),
(2051, 1, '__Palau'),
(2052, 1, '__Panama'),
(2053, 1, '__Papua New Guinea'),
(2054, 1, '__Paraguay'),
(2055, 1, '__Peru'),
(2056, 1, '__Philippines'),
(2057, 1, '__Poland'),
(2058, 1, '__Portugal'),
(2059, 1, '__Puerto Rico'),
(2060, 1, '__Qatar'),
(2061, 1, '__Reunion'),
(2062, 1, '__Romania'),
(2063, 1, '__Russia'),
(2064, 1, '__Rwanda'),
(2065, 1, '__Saint Lucia'),
(2066, 1, '__Samoa'),
(2067, 1, '__San Marino'),
(2068, 1, '__Saudi Arabia'),
(2069, 1, '__Senegal'),
(2070, 1, '__Seychelles'),
(2071, 1, '__Sierra Leone'),
(2072, 1, '__Singapore'),
(2073, 1, '__Slovakia'),
(2074, 1, '__Solomon Islands'),
(2075, 1, '__Somalia'),
(2076, 1, '__South Africa'),
(2077, 1, '__Spain'),
(2078, 1, '__Sri Lanka'),
(2079, 1, '__Sudan'),
(2080, 1, '__Suriname'),
(2081, 1, '__Swaziland'),
(2082, 1, '__Sweden'),
(2083, 1, '__Switzerland'),
(2084, 1, '__Syria'),
(2085, 1, '__Taiwan'),
(2086, 1, '__Tajikistan'),
(2087, 1, '__Tanzania'),
(2088, 1, '__Thailand'),
(2089, 1, '__Togo'),
(2090, 1, '__Tokelau'),
(2091, 1, '__Tonga'),
(2092, 1, '__Trinidad and Tobago'),
(2093, 1, '__Tunisia'),
(2094, 1, '__Turkey'),
(2095, 1, '__Turkmenistan'),
(2096, 1, '__Tuvalu'),
(2097, 1, '__Uganda'),
(2098, 1, '__Ukraine'),
(2099, 1, '__United Arab Emirates'),
(2100, 1, '__United Kingdom'),
(2101, 1, '__Uruguay'),
(2102, 1, '__Uzbekistan'),
(2103, 1, '__Vanuatu'),
(2104, 1, '__Venezuela'),
(2105, 1, '__Virgin Islands'),
(2106, 1, '__Western Sahara'),
(2107, 1, '__Yemen'),
(2108, 1, '__Zambia'),
(2109, 1, '__Zimbabwe'),
(2110, 1, '__Netherlands Antilles'),
(2111, 1, '__Bosnia and Herzegovina'),
(2112, 1, '__The Bahamas'),
(2113, 1, '__Cocos (Keeling) Islands'),
(2114, 1, '__Congo, Democratic Republic of the'),
(2115, 1, '__Central African Republic'),
(2116, 1, '__Congo, Republic of the'),
(2117, 1, '__Micronesia, Federated States of'),
(2118, 1, '__French Guiana'),
(2119, 1, '__The Gambia'),
(2120, 1, '__South Georgia and the South Sandwich Islands'),
(2121, 1, '__Heard Island and McDonald Islands'),
(2122, 1, '__British Indian Ocean Territory'),
(2123, 1, '__Saint Kitts and Nevis'),
(2124, 1, '__Korea, North'),
(2125, 1, '__Korea, South'),
(2126, 1, '__Laos'),
(2127, 1, '__Libya'),
(2128, 1, '__Macedonia, The Former Yugoslav Republic of'),
(2129, 1, '__Macao'),
(2130, 1, '__Northern Mariana Islands'),
(2131, 1, '__French Polynesia'),
(2132, 1, '__Saint Pierre and Miquelon'),
(2133, 1, '__Pitcairn Islands'),
(2134, 1, '__Palestinian Territory, Occupied'),
(2135, 1, '__Saint Helena'),
(2136, 1, '__Slovenia'),
(2137, 1, '__Svalbard'),
(2138, 1, '__Sao Tome and Principe'),
(2139, 1, '__Turks and Caicos Islands'),
(2140, 1, '__French Southern and Antarctic Lands'),
(2141, 1, '__United States Minor Outlying Islands'),
(2142, 1, '__United States'),
(2143, 1, '__Saint Vincent and the Grenadines'),
(2144, 1, '__British Virgin Islands'),
(2145, 1, '__Vietnam'),
(2146, 1, '__Aland_Islands'),
(2147, 1, '__Saint_Barthelemy'),
(2148, 1, '__Guernsey'),
(2149, 1, '__Isle_of_Man'),
(2150, 1, '__Jersey'),
(2151, 1, '__Montenegro'),
(2152, 1, '__Saint_Martin_French_part'),
(2153, 1, '__Serbia'),
(2154, 1, '__Wallis and Futuna'),
(2155, 1, '__All'),
(2156, 1, '__Active'),
(2157, 1, '__Approval'),
(2158, 1, '__Suspended'),
(2159, 1, '__Unconfirmed'),
(2160, 1, '__AA (2 years college)'),
(2161, 1, '__BA/BS (4 years college)'),
(2162, 1, '__High School graduate'),
(2163, 1, '__Some college'),
(2164, 1, '__College student'),
(2165, 1, '__Some grad school'),
(2166, 1, '__Grad school student'),
(2167, 1, '__MA/MS/MBA'),
(2168, 1, '__PhD/Post doctorate'),
(2169, 1, '__JD'),
(2170, 1, '__African'),
(2171, 1, '__African American'),
(2172, 1, '__Asian'),
(2173, 1, '__Caucasian'),
(2174, 1, '__East Indian'),
(2175, 1, '__Hispanic'),
(2176, 1, '__Indian'),
(2177, 1, '__Latino'),
(2178, 1, '__Mediterranean'),
(2179, 1, '__Middle Eastern'),
(2180, 1, '__Mixed'),
(2181, 1, '__English'),
(2182, 1, '__Afrikaans'),
(2183, 1, '__Arabic'),
(2184, 1, '__Bulgarian'),
(2185, 1, '__Burmese'),
(2186, 1, '__Cantonese'),
(2187, 1, '__Croatian'),
(2188, 1, '__Danish'),
(2189, 1, '__Dutch'),
(2190, 1, '__Esperanto'),
(2191, 1, '__Estonian'),
(2192, 1, '__Finnish'),
(2193, 1, '__French'),
(2194, 1, '__German'),
(2195, 1, '__Greek'),
(2196, 1, '__Gujrati'),
(2197, 1, '__Hebrew'),
(2198, 1, '__Hindi'),
(2199, 1, '__Hungarian'),
(2200, 1, '__Icelandic'),
(2201, 1, '__Indonesian'),
(2202, 1, '__Italian'),
(2203, 1, '__Japanese'),
(2204, 1, '__Korean'),
(2205, 1, '__Latvian'),
(2206, 1, '__Lithuanian'),
(2207, 1, '__Malay'),
(2208, 1, '__Mandarin'),
(2209, 1, '__Marathi'),
(2210, 1, '__Moldovian'),
(2211, 1, '__Nepalese'),
(2212, 1, '__Norwegian'),
(2213, 1, '__Persian'),
(2214, 1, '__Polish'),
(2215, 1, '__Portuguese'),
(2216, 1, '__Punjabi'),
(2217, 1, '__Romanian'),
(2218, 1, '__Russian'),
(2219, 1, '__Serbian'),
(2220, 1, '__Spanish'),
(2221, 1, '__Swedish'),
(2222, 1, '__Tagalog'),
(2223, 1, '__Taiwanese'),
(2224, 1, '__Tamil'),
(2225, 1, '__Telugu'),
(2226, 1, '__Thai'),
(2227, 1, '__Tongan'),
(2228, 1, '__Turkish'),
(2229, 1, '__Ukrainian'),
(2230, 1, '__Urdu'),
(2231, 1, '__Vietnamese'),
(2232, 1, '__Visayan'),
(2233, 1, '__Single'),
(2234, 1, '__Attached'),
(2235, 1, '__Divorced'),
(2236, 1, '__Married'),
(2237, 1, '__Separated'),
(2238, 1, '__Widow'),
(2239, 1, '__Adventist'),
(2240, 1, '__Agnostic'),
(2241, 1, '__Atheist'),
(2242, 1, '__Baptist'),
(2243, 1, '__Buddhist'),
(2244, 1, '__Caodaism'),
(2245, 1, '__Catholic'),
(2246, 1, '__Christian'),
(2247, 1, '__Hindu'),
(2248, 1, '__Iskcon'),
(2249, 1, '__Jainism'),
(2250, 1, '__Jewish'),
(2251, 1, '__Methodist'),
(2252, 1, '__Mormon'),
(2253, 1, '__Moslem'),
(2254, 1, '__Orthodox'),
(2255, 1, '__Pentecostal'),
(2256, 1, '__Protestant'),
(2257, 1, '__Quaker'),
(2258, 1, '__Scientology'),
(2259, 1, '__Shinto'),
(2260, 1, '__Sikhism'),
(2261, 1, '__Spiritual'),
(2262, 1, '__Taoism'),
(2263, 1, '__Wiccan'),
(2264, 1, '__Other'),
(2265, 1, '__No'),
(2266, 1, '__Rarely'),
(2267, 1, '__Often'),
(2268, 1, '__Very often');

-- --------------------------------------------------------

--
-- Table structure for table `sys_localization_languages`
--

CREATE TABLE `sys_localization_languages` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(5) NOT NULL DEFAULT '',
  `Flag` varchar(2) NOT NULL DEFAULT '',
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Direction` enum('LTR','RTL') NOT NULL DEFAULT 'LTR',
  `LanguageCountry` varchar(8) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_localization_languages`
--

INSERT INTO `sys_localization_languages` VALUES
(1, 'en', 'gb', 'English', 'LTR', 'en_GB');

-- --------------------------------------------------------

--
-- Table structure for table `sys_localization_strings`
--

CREATE TABLE `sys_localization_strings` (
  `IDKey` int(10) unsigned NOT NULL DEFAULT '0',
  `IDLanguage` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `String` mediumtext NOT NULL,
  PRIMARY KEY (`IDKey`,`IDLanguage`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




-- --------------------------------------------------------

--
-- Table structure for table `sys_localization_string_params`
--

CREATE TABLE `sys_localization_string_params` (
  `IDKey` int(10) unsigned NOT NULL DEFAULT '0',
  `IDParam` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`IDKey`,`IDParam`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu_admin`
--

CREATE TABLE `sys_menu_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(32) NOT NULL DEFAULT '',
  `title` varchar(64) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `icon` varchar(128) NOT NULL DEFAULT '',
  `icon_large` varchar(128) NOT NULL DEFAULT '',
  `check` varchar(255) NOT NULL DEFAULT '',
  `order` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;

--
-- Dumping data for table `sys_menu_admin`
--

INSERT INTO `sys_menu_admin` VALUES
(1, 0, 'users', '_adm_mmi_users', '{siteAdminUrl}profiles.php', '', 'users col-green1', 'users', '', 2),
(2, 0, 'modules', '_adm_mmi_modules', '', '', 'puzzle-piece col-red1', 'puzzle-piece', '', 3),
(3, 2, 'manage_modules', '_adm_mmi_manage_modules', '{siteAdminUrl}modules.php', 'Manage and configure integration modules for 3d party scripts', 'plus col-red1', '', '', 1),
(4, 2, 'flash_apps', '_adm_mmi_flash_apps', '{siteAdminUrl}flash.php', 'Flash Apps administration panel is available here', 'bolt col-red1', '', '', 2),
(5, 0, 'tools', '_adm_mmi_tools', '', '', 'wrench col-green3', 'wrench', '', 4),
(6, 5, 'mass_mailer', '_adm_mmi_mass_mailer', '{siteAdminUrl}notifies.php', 'Using this function you are able to send a newsletter to your site members', 'envelope col-green3', '', '', 1),
(7, 5, 'banners', '_adm_mmi_banners', '{siteAdminUrl}banners.php', 'Provides you with the ability to manage banners on your web site', 'flag col-green3', '', '', 4),
(8, 5, 'ip_blacklist', '_adm_mmi_ip_blacklist', '{siteAdminUrl}ip_blacklist.php', 'IP Blacklist system', 'ban col-green3', '', '', 6),
(9, 5, 'database_backup', '_adm_mmi_database_backup', '{siteAdminUrl}db.php', 'Make a backup of your site database with this utility', 'download col-green3', '', '', 7),
(10, 5, 'host_tools', '_adm_mmi_host_tools', '{siteAdminUrl}host_tools.php', 'Admin Host Tools', 'hdd-o col-green3', '', '', 8),
(11, 5, 'antispam', '_adm_mmi_antispam', '{siteAdminUrl}antispam.php', 'Antispam Tools', 'gavel col-green3', '', '', 9),
(12, 5, 'sitemap', '_adm_mmi_sitemap', '{siteAdminUrl}sitemap.php', 'Sitemap', 'sitemap col-green3', '', '', 10),
(13, 5, 'cache', '_adm_mmi_cache', '{siteAdminUrl}cache.php', 'Cache', 'bolt col-green3', '', '', 11),
(14, 0, 'builders', '_adm_mmi_builders', '', '', 'magic col-red2', 'magic', '', 5),
(15, 14, 'navigation_menu', '_adm_mmi_navigation_menu', '{siteAdminUrl}nav_menu_compose.php', 'For top menu items management', 'list col-red2', '', '', 1),
(16, 14, 'service_menu', '_adm_mmi_service_menu', '{siteAdminUrl}service_menu_compose.php', 'For top service''s menu items management', 'list col-red2', '', '', 2),
(17, 14, 'bottom_menu', '_adm_mmi_bottom_menu', '{siteAdminUrl}bottom_menu_compose.php', 'For top bottom''s menu items management', 'list col-red2', '', '', 3),
(18, 14, 'member_menu', '_adm_mmi_member_menu', '{siteAdminUrl}member_menu_compose.php', 'For top member''s menu items management', 'list col-red2', '', '', 4),
(19, 14, 'admin_menu', '_adm_mmi_admin_menu', '{siteAdminUrl}menu_compose_admin.php', 'For top admin''s menu items management', 'list col-red2', '', '', 5),
(20, 14, 'profile_fields', '_adm_mmi_profile_fields', '{siteAdminUrl}fields.php', 'For member profile fields management', 'list-alt col-red2', '', '', 10),
(21, 14, 'pages_blocks', '_adm_mmi_pages_blocks', '{siteAdminUrl}pageBuilder.php', 'Compose blocks for the site pages here', 'th-large col-red2', '', '', 20),
(22, 14, 'mobile_pages', '_adm_mmi_mobile_pages', '{siteAdminUrl}mobileBuilder.php', 'Mobile pages builder', 'th col-red2', '', '', 21),
(23, 14, 'predefined_values', '_adm_mmi_predefined_values', '{siteAdminUrl}preValues.php', '', 'list-ol col-red2', '', '', 30),
(24, 0, 'settings', '_adm_mmi_settings', '', '', 'sliders col-blue2', 'sliders', '', 6),
(25, 24, 'admin_password', '_adm_mmi_admin_password', '{siteAdminUrl}settings.php?cat=ap', 'Change a password for access to administration panel here', 'user-secret col-blue2', '', '', 1),
(26, 24, 'basic_settings', '_adm_mmi_basic_settings', '{siteAdminUrl}basic_settings.php', 'For managing site system settings', 'cog col-blue2', '', '', 2),
(27, 24, 'advanced_settings', '_adm_mmi_advanced_settings', '{siteAdminUrl}advanced_settings.php', 'More enhanced settings for your site features', 'cogs col-blue2', '', '', 3),
(28, 24, 'languages_settings', '_adm_mmi_languages_settings', '{siteAdminUrl}lang_file.php', 'For languages management your website is using and making changes in your website content', 'language col-blue2', '', '', 4),
(29, 24, 'membership_levels', '_adm_mmi_membership_levels', '{siteAdminUrl}memb_levels.php', 'For setting up different membership levels, different actions for each membership level and action limits', 'star-o col-blue2', '', '', 5),
(30, 24, 'email_templates', '_adm_mmi_email_templates', '{siteAdminUrl}email_templates.php', 'For setting up email texts which are sent from your website to members automatically', 'clipboard col-blue2', '', '', 6),
(31, 24, 'templates', '_adm_mmi_templates', '{siteAdminUrl}templates.php', 'Templates management', 'eye col-blue2', '', '', 7),
(32, 24, 'privacy', '_adm_mmi_privacy', '{siteAdminUrl}privacy.php', 'Privacy settings', 'lock col-blue2', '', '', 8),
(33, 24, 'categories_settings', '_adm_mmi_categories_settings', '{siteAdminUrl}categories.php', 'Categories settings', 'folder col-blue2', '', '', 15),
(34, 24, 'watermark', '_adm_mmi_watermark', '{siteAdminUrl}settings.php?cat=16', 'Setting up watermark for media content', 'certificate col-blue2', '', '', 16),
(35, 0, 'dashboard', '_adm_mmi_dashboard', '{siteAdminUrl}index.php', '', 'tachometer col-blue3', 'tachometer', '', 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu_admin_top`
--

CREATE TABLE `sys_menu_admin_top` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  `caption` varchar(64) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `target` varchar(64) NOT NULL DEFAULT '',
  `icon` varchar(128) NOT NULL DEFAULT '',
  `order` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `sys_menu_admin_top`
--

INSERT INTO `sys_menu_admin_top` VALUES
(1, 'home', '_adm_tmi_home', '{site_url}index.php', '_blank', 'external-link-square', 1),
(2, 'extensions', '_adm_tmi_extensions', 'https://www.boonex.com/market', '', 'puzzle-piece', 2),
(3, 'info', '_adm_tmi_info', 'https://www.boonex.com/trac/dolphin/wiki', '', 'question-circle', 3),
(4, 'logout', '_adm_tmi_logout', '{site_url}logout.php', '', 'sign-out', 4);

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu_bottom`
--

CREATE TABLE `sys_menu_bottom` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Caption` varchar(100) NOT NULL,
  `Name` varchar(200) NOT NULL,
  `Icon` varchar(100) NOT NULL,
  `Link` varchar(250) NOT NULL,
  `Script` varchar(250) NOT NULL,
  `Order` int(5) NOT NULL,
  `Target` varchar(200) NOT NULL,
  `Visible` set('non','memb') NOT NULL DEFAULT '',
  `Active` tinyint(1) NOT NULL DEFAULT '1',
  `Movable` tinyint(1) NOT NULL DEFAULT '1',
  `Clonable` tinyint(1) NOT NULL DEFAULT '1',
  `Editable` tinyint(1) NOT NULL DEFAULT '1',
  `Deletable` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `sys_menu_bottom`
--

INSERT INTO `sys_menu_bottom` VALUES
(1, '_About Us', 'About Us', '', 'about_us.php', '', 1, '', 'non,memb', 1, 3, 1, 1, 1),
(2, '_Privacy', 'Privacy', '', 'privacy.php', '', 2, '', 'non,memb', 1, 3, 1, 1, 1),
(3, '_Terms_of_use', 'Terms of use', '', 'terms_of_use.php', '', 3, '', 'non,memb', 1, 3, 1, 1, 1),
(4, '_FAQ', 'FAQ', '', 'faq.php', '', 4, '', 'non,memb', 1, 3, 1, 1, 1),
(5, '_Invite a friend', 'Invite a friend', '', 'tellfriend.php', 'return launchTellFriend();', 5, '', 'non,memb', 1, 3, 1, 1, 1),
(6, '_contact_us', 'Contact us', '', 'contact.php', '', 6, '', 'non,memb', 1, 3, 1, 1, 1),
(7, '_Bookmark', 'Bookmark', '', '', 'addBookmark(); return false;', 7, '', 'non,memb', 1, 3, 1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu_member`
--

CREATE TABLE `sys_menu_member` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Caption` varchar(100) NOT NULL,
  `Name` varchar(200) NOT NULL,
  `Icon` varchar(100) NOT NULL,
  `Link` varchar(250) NOT NULL,
  `Script` varchar(250) NOT NULL,
  `Eval` text NOT NULL,
  `PopupMenu` text NOT NULL,
  `Order` int(5) NOT NULL,
  `Active` enum('1','0') NOT NULL,
  `Movable` tinyint(4) NOT NULL DEFAULT '3',
  `Clonable` tinyint(1) NOT NULL DEFAULT '1',
  `Editable` tinyint(1) NOT NULL DEFAULT '1',
  `Deletable` tinyint(1) NOT NULL DEFAULT '1',
  `Target` varchar(200) NOT NULL,
  `Position` enum('top','bottom','top_extra') NOT NULL DEFAULT 'top',
  `Type` enum('link','system','linked_item') NOT NULL,
  `Parent` int(11) NOT NULL,
  `Bubble` text NOT NULL,
  `Description` varchar(50) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Parent` (`Parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `sys_menu_member`
--

INSERT INTO `sys_menu_member` VALUES
(1, '{evalResult}', 'MemberBlock', '', '{ProfileLink}', '', 'return ''<b class="menu_item_username">'' . getNickName({ID}) . ''</b>'';', 'bx_import(''BxDolUserStatusView'');\r\n$oStatusView = new BxDolUserStatusView();\r\nreturn $oStatusView->getMemberMenuStatuses();', 1, '1', 3, 1, 0, 0, '', 'top', 'link', 0, '', '_Presence'),
(2, '_Mail', 'Mail', 'envelope', 'mail.php?mode=inbox', '', '', 'bx_import( ''BxTemplMailBox'' );\r\n// return list of messages ;\r\nreturn BxTemplMailBox::get_member_menu_messages_list({ID});', 1, '1', 3, 1, 0, 0, '', 'top_extra', 'link', 0, 'bx_import( ''BxTemplMailBox'' );\r\n// return list of new messages ;\r\n$aRetEval= BxTemplMailBox::get_member_menu_bubble_new_messages({ID}, {iOldCount});', '_Mail'),
(3, '_Friends', 'Friends', 'users', 'viewFriends.php?iUser={ID}', '', '', 'bx_import( ''BxDolFriendsPageView'' );\r\nreturn BxDolFriendsPageView::get_member_menu_friends_list({ID});', 3, '1', 3, 1, 0, 0, '', 'top_extra', 'link', 0, 'bx_import( ''BxDolFriendsPageView'' );\r\n$aRetEval = BxDolFriendsPageView::get_member_menu_bubble_friend_requests( {ID}, {iOldCount});', '_Friends'),
(4, '_sys_pmt_shopping_cart_caption', 'ShoppingCart', 'shopping-cart', 'cart.php', '', '', 'bx_import(''BxDolPayments'');\r\nreturn BxDolPayments::getInstance()->getCartItems();', 4, '1', 3, 1, 0, 0, '', 'top_extra', 'link', 0, 'bx_import(''BxDolPayments'');\r\n$oPayment = BxDolPayments::getInstance();\r\nif($oPayment->isActive()) $aRetEval = $oPayment->getCartItemCount({ID}, {iOldCount}); else $isSkipItem = true;', '_sys_pmt_shopping_cart_description'),
(5, '_Admin Panel', 'AdminPanel', 'wrench', '{evalResult}', '', 'return isAdmin() ? $GLOBALS[''site''][''url_admin''] : '''';', '', 5, '1', 3, 1, 1, 1, '', 'top_extra', 'link', 0, '', '_Go admin panel'),
(6, '_sys_add_content', 'AddContent', 'plus', 'javascript:void(0);', '', 'return array(''evalResultCssClassWrapper'' => ''extra_item_add_content'');', 'bx_import( ''BxDolUserStatusView'' );\r\n$oStatusView = new BxDolUserStatusView();\r\nreturn $oStatusView -> getStatusField({ID});', 6, '1', 3, 0, 0, 0, '', 'top_extra', 'link', 0, '$isSkipItem = $aReplaced[$sPosition][$iKey][''linked_items''] ? false : true;\r\n$aRetEval = false;', '_sys_add_content'),
(7, '_Settings', 'Settings', 'cog', 'pedit.php?ID={ID}', '', '', '', 0, '', 3, 1, 0, 0, '', 'top_extra', 'link', 0, '', '_Edit_profile_and_settings'),
(8, '_Status Message', 'StatusMessage', 'edit', 'javascript:void(0);', '', '', 'bx_import( ''BxDolUserStatusView'' );\r\n$oStatusView = new BxDolUserStatusView();\r\nreturn $oStatusView -> getStatusField({ID});', 0, '', 3, 1, 1, 1, '', 'top_extra', 'link', 0, '', '_Status Message');

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu_mobile`
--

CREATE TABLE `sys_menu_mobile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(32) NOT NULL,
  `page` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `action` int(11) NOT NULL,
  `action_data` varchar(255) NOT NULL,
  `eval_bubble` text NOT NULL,
  `eval_hidden` text NOT NULL,
  `order` int(11) NOT NULL,
  `active` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `sys_menu_mobile`
--

INSERT INTO `sys_menu_mobile` VALUES
(1, 'system', 'homepage', '_sys_mobile_status', 'home_status.png', 1, '', '', '', 1, 1),
(2, 'system', 'homepage', '_sys_mobile_mail', 'home_messages.png', 3, '', 'return getNewLettersNum({member_id});', '', 2, 1),
(3, 'system', 'homepage', '_sys_mobile_friends', 'home_friends.png', 4, '', 'return getFriendRequests({member_id});', '', 3, 1),
(4, 'system', 'homepage', '_sys_mobile_info', 'home_info.png', 5, '', '', '', 4, 1),
(5, 'system', 'homepage', '_sys_mobile_search', 'home_search.png', 6, '', '', '', 5, 1),
(6, 'system', 'profile', '_sys_mobile_profile_info', '', 5, '', '', '', 1, 1),
(7, 'system', 'profile', '_sys_mobile_profile_contact', '', 3, '', '', '', 2, 1),
(8, 'system', 'profile', '_sys_mobile_profile_friends', '', 4, '', 'return getFriendNumber(''{profile_id}'');', '', 3, 1),
(9, 'system', 'search', '_sys_mobile_search_by_keyword', '', 30, '', '', '', 1, 1),
(10, 'system', 'search', '_sys_mobile_search_by_location', '', 31, '', '', '', 2, 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu_mobile_pages`
--

CREATE TABLE `sys_menu_mobile_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `order` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page` (`page`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `sys_menu_mobile_pages`
--

INSERT INTO `sys_menu_mobile_pages` VALUES
(1, 'homepage', '_adm_mobile_page_homepage', 1),
(2, 'profile', '_adm_mobile_page_profile', 2),
(3, 'search', '_adm_mobile_page_search', 3);

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu_service`
--

CREATE TABLE `sys_menu_service` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(200) NOT NULL,
  `Caption` varchar(100) NOT NULL,
  `Icon` varchar(100) NOT NULL,
  `Link` varchar(250) NOT NULL,
  `Script` varchar(250) NOT NULL,
  `Target` varchar(200) NOT NULL,
  `Order` int(5) NOT NULL,
  `Visible` set('non','memb') NOT NULL DEFAULT '',
  `Active` tinyint(1) NOT NULL DEFAULT '1',
  `Movable` tinyint(1) NOT NULL DEFAULT '1',
  `Clonable` tinyint(1) NOT NULL DEFAULT '1',
  `Editable` tinyint(1) NOT NULL DEFAULT '1',
  `Deletable` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `sys_menu_service`
--

INSERT INTO `sys_menu_service` VALUES
(1, 'Join', '_sys_sm_join', 'user', '', 'showPopupJoinForm(); return false;', '', 1, 'non', 1, 3, 1, 1, 1),
(2, 'Login', '_sys_sm_login', 'sign-in', '', 'showPopupLoginForm(); return false;', '', 2, 'non', 1, 3, 1, 1, 1),
(3, 'LoginOnly', '_sys_sm_login', 'sign-in', '', 'showPopupLoginOnlyForm(); return false;', '', 0, 'non', 0, 3, 1, 1, 1),
(4, 'Profile', '_sys_sm_profile', '', '{memberLink}|{memberNick}|change_status.php', '', '', 0, 'memb', 0, 3, 1, 1, 1),
(5, 'Account', '_sys_sm_account', 'tachometer', 'member.php', '', '', 1, 'memb', 1, 3, 1, 1, 1),
(6, 'ProfileSettings', '_sys_sm_profile_settings', 'cog', 'pedit.php?ID={memberID}', '', '', 2, 'memb', 1, 3, 1, 1, 1),
(7, 'Logout', '_sys_sm_logout', 'sign-out', 'logout.php?action=member_logout', '', '', 3, 'memb', 1, 3, 1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu_top`
--

CREATE TABLE `sys_menu_top` (
  `ID` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `Parent` smallint(6) unsigned NOT NULL DEFAULT '0',
  `Name` varchar(50) NOT NULL DEFAULT '',
  `Caption` varchar(50) NOT NULL DEFAULT '',
  `Link` varchar(255) NOT NULL DEFAULT '',
  `Order` smallint(6) unsigned NOT NULL DEFAULT '0',
  `Visible` set('non','memb') NOT NULL DEFAULT '',
  `Target` varchar(20) NOT NULL DEFAULT '',
  `Onclick` mediumtext NOT NULL,
  `Check` varchar(255) NOT NULL DEFAULT '',
  `Movable` tinyint(4) NOT NULL DEFAULT '3',
  `Clonable` tinyint(1) NOT NULL DEFAULT '1',
  `Editable` tinyint(1) NOT NULL DEFAULT '1',
  `Deletable` tinyint(1) NOT NULL DEFAULT '1',
  `Active` tinyint(1) NOT NULL DEFAULT '1',
  `Type` enum('system','top','custom') NOT NULL DEFAULT 'top',
  `Picture` varchar(128) NOT NULL,
  `Icon` varchar(128) NOT NULL,
  `BQuickLink` tinyint(1) NOT NULL DEFAULT '0',
  `Statistics` varchar(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=194 ;

--
-- Dumping data for table `sys_menu_top`
--

INSERT INTO `sys_menu_top` VALUES
(4, 0, 'My Profile', '{memberNick}', '{memberLink}|{memberUsername}|change_status.php', 3, 'memb', '', '', '', 1, 0, 0, 0, 1, 'system', 'user', '', 0, ''),
(5, 0, 'Home', '_Home', 'index.php', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'top', 'home', '', 0, ''),
(6, 0, 'People', '_People', 'browse.php|search.php|calendar.php|tags.php?tags_mode=profile|search.php?show=match', 5, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'top', 'user', '', 0, ''),
(7, 6, 'All members', '_All Members', 'browse.php|browse', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(8, 6, 'Search Members', '_Search', 'search.php', 9, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(9, 0, 'Profile View', '{profileNick}', '{profileUsername}|pedit.php?ID={profileID}', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'system', '', '', 0, ''),
(11, 4, 'View My Profile', '_Profile', '{memberLink}|{memberUsername}|profile.php?ID={memberID}', 0, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(12, 179, 'Mail Compose', '_Compose', 'mail.php?mode=compose', 0, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(17, 179, 'Mail Inbox', '_Inbox', 'mail.php?mode=inbox', 1, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 1, 'mma'),
(14, 179, 'Mail Outbox', '_Outbox', 'mail.php?mode=outbox', 2, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(18, 179, 'Mail Trash', '_Trash', 'mail.php?mode=trash', 3, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(20, 0, 'Edit My Profile', '_Customize', 'pedit.php?ID={memberID}', 0, 'memb', '', '', '', 3, 1, 1, 0, 0, 'custom', 'user', '', 1, ''),
(25, 6, 'Online Members', '_Online', 'search.php?online_only=1', 2, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(60, 9, 'View Profile', '_Profile', '{profileLink}|{profileUsername}|profile.php?ID={profileID}', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(80, 4, 'My Friends', '_Friends', 'viewFriends.php?iUser={memberID}', 2, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, 'mfa'),
(82, 9, 'Info', '_profile_info', 'profile_info.php?ID={profileID}', 1, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(83, 9, 'Member Friends', '_Friends', 'viewFriends.php?iUser={profileID}', 2, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(98, 0, 'Join', '_Account', 'join.php', 1, 'non', '', '', '', 3, 1, 1, 0, 1, 'system', 'user', '', 0, ''),
(99, 0, 'Login', '_Login', 'member.php', 0, 'non', '', '', '', 3, 1, 0, 0, 0, 'custom', 'user', '', 0, ''),
(100, 0, 'Main', '_Main', 'index.php|', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 0, 'custom', '', '', 0, ''),
(101, 118, 'Account home', '_Account Home', 'member.php', 0, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(129, 6, 'Top Rated', '_Top Rated', 'search.php?show=top_rated', 4, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(127, 6, 'Match', '_Match', 'search.php?show=match', 1, 'non,memb', '', '', 'return isLogged() && getParam(''enable_match'') == ''on'';', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(128, 6, 'Featured', '_Featured', 'search.php?show=featured', 3, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(107, 118, 'Privacy Groups', '_ps_tmenu_privacy_settings', 'member_privacy.php', 5, 'memb', '', '', 'bx_import(''BxDolPrivacy''); return BxDolPrivacy::isPrivacyPage();', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(109, 118, 'Unregister', '_Unregister', 'unregister.php', 8, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(111, 4, 'Profile Info', '_Info', 'profile_info.php', 1, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(118, 0, 'Dashboard', '_Dashboard', 'member.php', 2, 'memb', '', '', '', 1, 0, 1, 0, 1, 'system', 'tachometer', '', 0, ''),
(120, 0, 'About', '_About', 'about_us.php', 13, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'top', 'info-circle', '', 0, ''),
(122, 120, 'Terms of Use', '_TERMS_OF_USE_H', 'terms_of_use.php', 2, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(123, 120, 'Privacy Policy', '_PRIVACY_H', 'privacy.php', 3, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(126, 118, 'Activity', '_Activity', 'communicator.php', 3, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(130, 6, 'Popular', '_Popular', 'search.php?show=popular', 5, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(131, 6, 'Birthdays', '_Birthdays', 'search.php?show=birthdays', 6, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(132, 6, 'People Calendar', '_People_Calendar', 'calendar.php', 8, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(138, 0, 'Search', '_Search', 'search_home.php', 9, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'top', 'search', '', 0, ''),
(139, 138, 'Keyword Search', '_Keyword_Search', 'searchKeyword.php', 1, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(141, 138, 'People Search', '_People_Search', 'search.php', 3, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(159, 0, 'Help', '_help', 'help.php', 12, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'top', 'question-circle', '', 0, ''),
(160, 159, 'FAQ', '_FAQ', 'faq.php', 1, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(161, 159, 'Contact', '_Contact', 'contact.php', 2, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(162, 159, 'Advice', '_Advice', 'advice.php', 3, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(163, 159, 'Help', '_help', 'help.php', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(175, 120, 'About', '_About', 'about_us.php', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(176, 138, 'Search Home', '_Search_Home', 'search_home.php', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(179, 0, 'Mail', '_Mail', 'mail.php?mode=inbox', 4, 'memb', '', '', '', 3, 1, 1, 0, 1, 'system', 'envelope', '', 0, ''),
(191, 118, 'Subscriptions', '_sbs_tmenu_my_subscriptions', 'member_subscriptions.php', 7, 'memb', '', '', '', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(192, 118, 'Cart', '_sys_pmt_tmenu_cart', 'cart.php|modules/?r={sys_payment_module_uri}/cart/|modules/?r={sys_payment_module_uri}/history/', 9, 'memb', '', '', 'bx_import(''BxDolPayments''); return BxDolPayments::getInstance()->isActive();', 3, 1, 1, 0, 1, 'custom', '', '', 0, ''),
(193, 118, 'Payments', '_sys_pmt_tmenu_payments', 'orders.php|modules/?r={sys_payment_module_uri}/orders/|modules/?r={sys_payment_module_uri}/details/', 10, 'memb', '', '', 'bx_import(''BxDolPayments''); return BxDolPayments::getInstance()->isActive();', 3, 1, 1, 0, 1, 'custom', '', '', 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `sys_messages`
--

CREATE TABLE `sys_messages` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Sender` int(10) unsigned NOT NULL DEFAULT '0',
  `Recipient` int(10) unsigned NOT NULL DEFAULT '0',
  `Text` mediumtext NOT NULL,
  `Subject` varchar(255) NOT NULL DEFAULT '',
  `New` enum('0','1') NOT NULL DEFAULT '1',
  `Type` enum('letter','greeting') NOT NULL DEFAULT 'letter',
  `Trash` set('sender','recipient') NOT NULL,
  `TrashNotView` set('sender','recipient') NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Pair` (`Sender`,`Recipient`),
  KEY `TrashNotView` (`TrashNotView`),
  KEY `Trash` (`Trash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_modules`
--

CREATE TABLE `sys_modules` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `vendor` varchar(64) NOT NULL DEFAULT '',
  `version` varchar(32) NOT NULL DEFAULT '',
  `update_url` varchar(128) NOT NULL DEFAULT '',
  `path` varchar(255) NOT NULL DEFAULT '',
  `uri` varchar(32) NOT NULL DEFAULT '',
  `class_prefix` varchar(32) NOT NULL DEFAULT '',
  `db_prefix` varchar(32) NOT NULL DEFAULT '',
  `dependencies` varchar(255) NOT NULL DEFAULT '',
  `date` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `path` (`path`),
  UNIQUE KEY `uri` (`uri`),
  UNIQUE KEY `class_prefix` (`class_prefix`),
  UNIQUE KEY `db_prefix` (`db_prefix`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_modules_file_tracks`
--

CREATE TABLE `sys_modules_file_tracks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `module_id` int(11) unsigned NOT NULL DEFAULT '0',
  `file` varchar(255) NOT NULL DEFAULT '',
  `hash` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_actions`
--

CREATE TABLE `sys_objects_actions` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Caption` varchar(100) NOT NULL,
  `Icon` varchar(100) NOT NULL,
  `Url` varchar(250) NOT NULL,
  `Script` varchar(250) NOT NULL,
  `Eval` text NOT NULL,
  `Order` int(5) NOT NULL,
  `Type` varchar(20) NOT NULL,
  `bDisplayInSubMenuHeader` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `sys_objects_actions`
--

INSERT INTO `sys_objects_actions` VALUES
(1, '{evalResult}', 'edit', 'pedit.php?ID={ID}', '', 'if ({ID} == {member_id} || isAdmin({member_id}) || isModerator({member_id})) return _t(''{cpt_edit}'');', 1, 'Profile', 0),
(2, '{evalResult}', 'envelope', 'mail.php?mode=compose&recipient_id={ID}', '', 'if ({ID} == {member_id}) return;\r\nreturn _t(''{cpt_send_letter}'');', 2, 'Profile', 0),
(3, '{cpt_fave}', 'asterisk', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFaveAdd({ID}, {member_id});', 3, 'Profile', 0),
(4, '{cpt_remove_fave}', 'asterisk', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFaveCancel({ID}, {member_id});', 3, 'Profile', 0),
(5, '{cpt_befriend}', 'plus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendAdd({ID}, {member_id});', 4, 'Profile', 0),
(6, '{cpt_remove_friend}', 'minus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendCancel({ID}, {member_id}, false);', 4, 'Profile', 0),
(7, '{cpt_greet}', 'hand-o-right', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\nreturn "$.post(''greet.php'', { sendto: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 5, 'Profile', 0),
(8, '{cpt_get_mail}', 'envelope-o', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\n$bAnonymousMode  = ''{anonym_mode}'';\r\n\r\nif ( !$bAnonymousMode ) {\r\n    return "$.post(''freemail.php'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n}\r\n', 6, 'Profile', 0),
(9, '{cpt_share}', 'share-square-o', '', 'return launchTellFriendProfile({ID});', '', 7, 'Profile', 0),
(10, '{cpt_report}', 'exclamation-circle', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\nreturn  "$.post(''list_pop.php?action=spam'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 8, 'Profile', 0),
(11, '{cpt_block}', 'ban', '', '{evalResult}', 'if ( {ID} == {member_id} || isBlocked({member_id}, {ID}) ) return;\r\n\r\nreturn  "$.post(''list_pop.php?action=block'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 9, 'Profile', 0),
(12, '{sbs_profile_title}', 'paperclip', '', '{sbs_profile_script}', '', 10, 'Profile', 0),
(13, '{cpt_unblock}', 'ban', '', '{evalResult}', 'if ({ID} == {member_id} || !isBlocked({member_id}, {ID}) ) return;\r\n\r\nreturn "$.post(''list_pop.php?action=unblock'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 9, 'Profile', 0),
(14, '{cpt_activate}', 'check', '', 'getHtmlData(''ajaxy_popup_result_div_{ID}'', ''list_pop.php?action={act_activate}&ID={ID}'', false, ''post''); return false;', '', 11, 'Profile', 0),
(15, '{cpt_ban}', 'exclamation-circle', '', 'getHtmlData(''ajaxy_popup_result_div_{ID}'', ''list_pop.php?action={act_ban}&ID={ID}'', false, ''post''); return false;', '', 12, 'Profile', 0),
(16, '{cpt_delete}', 'times', '', 'getHtmlData(''ajaxy_popup_result_div_{ID}'', ''list_pop.php?action=delete&ID={ID}'', false, ''post'', true); return false;', '', 13, 'Profile', 0),
(17, '{cpt_delete_spam}', 'times', '', 'getHtmlData(''ajaxy_popup_result_div_{ID}'', ''list_pop.php?action=delete_spam&ID={ID}'', false, ''post'', true); return false;', '', 14, 'Profile', 0),
(18, '{cpt_feature}', 'asterisk', '', 'getHtmlData(''ajaxy_popup_result_div_{ID}'', ''list_pop.php?action={act_feature}&ID={ID}'', false, ''post''); return false;', '', 15, 'Profile', 0),
(19, '{evalResult}', 'plus', '{BaseUri}mail.php?mode=compose', '', 'return $GLOBALS[''logged''][''member''] || $GLOBALS[''logged''][''admin''] ? _t(''_sys_am_mailbox_compose'') : '''';', 1, 'Mailbox', 1),
(20, '{cpt_am_friend_add}', 'plus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendAdd({ID}, {member_id}, false);', 1, 'ProfileTitle', 1),
(21, '{cpt_am_friend_accept}', 'plus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendAccept({ID}, {member_id}, false);', 2, 'ProfileTitle', 1),
(22, '{cpt_am_friend_cancel}', 'minus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendCancel({ID}, {member_id}, false);', 3, 'ProfileTitle', 1),
(23, '{cpt_am_profile_message}', 'envelope', '{evalResult}', '', 'return $GLOBALS[''oTopMenu'']->getUrlProfileMessage({ID});', 4, 'ProfileTitle', 1),
(24, '{cpt_am_profile_account_page}', 'tachometer', '{evalResult}', '', 'return $GLOBALS[''oTopMenu'']->getUrlAccountPage({ID});', 5, 'ProfileTitle', 1),
(25, '{cpt_am_account_profile_page}', 'user', '{evalResult}', '', 'return $GLOBALS[''oTopMenu'']->getUrlProfilePage({ID});', 1, 'AccountTitle', 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_auths`
--

CREATE TABLE `sys_objects_auths` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(64) NOT NULL,
  `Title` varchar(128) NOT NULL,
  `Link` varchar(255) NOT NULL,
  `OnClick` varchar(255) NOT NULL,
  `Icon` varchar(64) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_captcha`
--

CREATE TABLE `sys_objects_captcha` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `override_class_name` varchar(255) NOT NULL,
  `override_class_file` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_objects_captcha`
--

INSERT INTO `sys_objects_captcha` VALUES
(1, 'sys_recaptcha', 'reCAPTCHA', 'BxTemplCaptchaReCAPTCHA', '');

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_categories`
--

CREATE TABLE `sys_objects_categories` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ObjectName` varchar(50) NOT NULL,
  `Query` text NOT NULL,
  `PermalinkParam` varchar(50) NOT NULL DEFAULT '',
  `EnabledPermalink` varchar(100) NOT NULL DEFAULT '',
  `DisabledPermalink` varchar(100) NOT NULL DEFAULT '',
  `LangKey` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_charts`
--

CREATE TABLE `sys_objects_charts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `table` varchar(255) NOT NULL,
  `field_date_ts` varchar(255) NOT NULL,
  `field_date_dt` varchar(255) NOT NULL,
  `column_date` int(11) NOT NULL DEFAULT '0',
  `column_count` int(11) NOT NULL DEFAULT '1',
  `type` varchar(255) NOT NULL,
  `options` text NOT NULL,
  `query` text NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `order` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `object` (`object`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `sys_objects_charts`
--

INSERT INTO `sys_objects_charts` VALUES
(1, 'sys_profiles', '_Members', 'Profiles', '', 'DateReg', 0, 1, '', '', '', 1, 1),
(2, 'sys_subscribers', '_Subscribers', 'sys_sbs_users', 'date', '', 0, 1, '', '', '', 1, 2),
(3, 'sys_messages', '_Messages', 'sys_messages', '', 'Date', 0, 1, '', '', '', 1, 3),
(4, 'sys_greetings', '_Greetings', 'sys_greetings', '', 'When', 0, 1, '', '', '', 1, 4),
(5, 'sys_tags', '_Tags', 'sys_tags', '', 'Date', 0, 1, '', '', '', 1, 5),
(6, 'sys_categories', '_Categories', 'sys_categories', '', 'Date', 0, 1, '', '', '', 1, 6),
(7, 'sys_banners', '_adm_bann_clicks_chart', 'sys_banners_clicks', 'Date', '', 0, 1, '', '', '', 1, 7);

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_cmts`
--

CREATE TABLE `sys_objects_cmts` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ObjectName` varchar(50) NOT NULL,
  `TableCmts` varchar(50) NOT NULL,
  `TableTrack` varchar(50) NOT NULL,
  `AllowTags` smallint(1) NOT NULL,
  `Nl2br` smallint(1) NOT NULL,
  `SecToEdit` smallint(6) NOT NULL,
  `PerView` smallint(6) NOT NULL,
  `IsRatable` smallint(1) NOT NULL,
  `ViewingThreshold` smallint(6) NOT NULL,
  `AnimationEffect` varchar(50) NOT NULL,
  `AnimationSpeed` smallint(6) NOT NULL,
  `IsOn` smallint(1) NOT NULL,
  `IsMood` smallint(1) NOT NULL,
  `RootStylePrefix` varchar(16) NOT NULL DEFAULT 'cmt',
  `TriggerTable` varchar(32) NOT NULL,
  `TriggerFieldId` varchar(32) NOT NULL,
  `TriggerFieldComments` varchar(32) NOT NULL,
  `ClassName` varchar(32) NOT NULL,
  `ClassFile` varchar(256) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_objects_cmts`
--

INSERT INTO `sys_objects_cmts` VALUES
(1, 'profile', 'sys_cmts_profile', 'sys_cmts_track', 0, 1, 90, 5, 1, -3, 'none', 0, 1, 0, 'cmt', 'Profiles', 'ID', 'CommentsCount', 'BxDolCmtsProfile', 'inc/classes/BxDolCmtsProfile.php');

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_editor`
--

CREATE TABLE `sys_objects_editor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `skin` varchar(255) NOT NULL,
  `override_class_name` varchar(255) NOT NULL,
  `override_class_file` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `object` (`object`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_objects_editor`
--

INSERT INTO `sys_objects_editor` VALUES
(1, 'sys_tinymce', 'TinyMCE', 'lightgray', 'BxTemplEditorTinyMCE', '');

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_exports`
--

CREATE TABLE `sys_objects_exports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `class_name` varchar(255) NOT NULL,
  `class_file` varchar(255) NOT NULL,
  `order` tinyint(4) NOT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `object` (`object`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `sys_objects_exports`
--

INSERT INTO `sys_objects_exports` VALUES
(1, 'profiles', '_Profiles', 'BxDolExportProfile', '', 1, 1),
(2, 'flash', '_adm_admtools_Flash', 'BxDolExportFlash', '', 2, 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_member_info`
--

CREATE TABLE `sys_objects_member_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(32) NOT NULL,
  `override_class_name` varchar(255) NOT NULL,
  `override_class_file` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `sys_objects_member_info`
--

INSERT INTO `sys_objects_member_info` VALUES
(1, 'sys_username', '_sys_member_info_username', 'name', '', ''),
(2, 'sys_full_name', '_sys_member_info_full_name', 'name', '', ''),
(3, 'sys_status_message', '_sys_member_info_status_message', 'info', '', ''),
(4, 'sys_age_sex', '_sys_member_info_age_sex', 'info', '', ''),
(5, 'sys_location', '_sys_member_info_location', 'info', '', ''),
(6, 'sys_avatar', '_sys_member_thumb_avatar', 'thumb', '', ''),
(7, 'sys_avatar_2x', '_sys_member_thumb_avatar_2x', 'thumb_2x', '', ''),
(8, 'sys_avatar_icon', '_sys_member_thumb_icon_avatar', 'thumb_icon', '', ''),
(9, 'sys_avatar_icon_2x', '_sys_member_thumb_icon_avatar_2x', 'thumb_icon_2x', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_payments`
--

CREATE TABLE `sys_objects_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `uri` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `object` (`object`),
  UNIQUE KEY `uri` (`uri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_search`
--

CREATE TABLE `sys_objects_search` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ObjectName` varchar(50) NOT NULL DEFAULT '',
  `Title` varchar(50) NOT NULL DEFAULT '',
  `ClassName` varchar(50) NOT NULL DEFAULT '',
  `ClassPath` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `sys_objects_search`
--

INSERT INTO `sys_objects_search` VALUES
(3, 'profile', '_Profiles', 'BxTemplSearchProfile', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchProfile.php');

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_site_maps`
--

CREATE TABLE `sys_objects_site_maps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `priority` varchar(5) NOT NULL DEFAULT '0.6',
  `changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never','auto') NOT NULL DEFAULT 'auto',
  `class_name` varchar(255) NOT NULL,
  `class_file` varchar(255) NOT NULL,
  `order` tinyint(4) NOT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `object` (`object`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `sys_objects_site_maps`
--

INSERT INTO `sys_objects_site_maps` VALUES
(1, 'system', '_sys_sitemap_system', '0.6', 'weekly', 'BxDolSiteMapsSystem', '', 1, 1),
(2, 'profiles', '_sys_sitemap_profiles', '0.8', 'daily', 'BxDolSiteMapsProfiles', '', 2, 1),
(3, 'profiles_info', '_sys_sitemap_profiles_info', '0.8', 'daily', 'BxDolSiteMapsProfilesInfo', '', 3, 1),
(4, 'pages', '_sys_sitemap_pages', '0.8', 'weekly', 'BxDolSiteMapsPages', '', 4, 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_social_sharing`
--

CREATE TABLE `sys_objects_social_sharing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object` varchar(32) NOT NULL,
  `content` text NOT NULL,
  `order` int(11) NOT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `sys_objects_social_sharing`
--

INSERT INTO `sys_objects_social_sharing` VALUES
(1, 'facebook', '<iframe src="//www.facebook.com/plugins/like.php?href={url_encoded}&amp;send=false&amp;layout=button_count&amp;width=450&amp;show_faces=false&amp;action=like&amp;colorscheme=light&amp;font&amp;height=21&amp;locale={locale}" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:100%; height:21px;" allowTransparency="true"></iframe>', 1, 1),
(2, 'twitter', '<iframe allowtransparency="true" frameborder="0" scrolling="no" src="//platform.twitter.com/widgets/tweet_button.html?url={url_encoded}&amp;text={title_encoded}&amp;size=medium&amp;count=horizontal&amp;lang={lang}" style="width:100%;height:21px;"></iframe>', 3, 1),
(3, 'pinterest', '<a href="http://pinterest.com/pin/create/button/?url={url_encoded}&media={img_url_encoded}&description={title_encoded}" class="pin-it-button" count-layout="horizontal"><img border="0" src="//assets.pinterest.com/images/PinExt.png" title="Pin It" /></a>\r\n\r\n<script type="text/javascript" src="//assets.pinterest.com/js/pinit.js"></script>', 4, 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_tag`
--

CREATE TABLE `sys_objects_tag` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ObjectName` varchar(50) NOT NULL,
  `Query` text NOT NULL,
  `PermalinkParam` varchar(50) NOT NULL DEFAULT '',
  `EnabledPermalink` varchar(100) NOT NULL DEFAULT '',
  `DisabledPermalink` varchar(100) NOT NULL DEFAULT '',
  `LangKey` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_objects_tag`
--

INSERT INTO `sys_objects_tag` VALUES
(1, 'profile', 'SELECT `Tags` FROM `Profiles` WHERE `ID` = {iID} AND `Status` = ''Active''', 'enable_modrewrite', 'search/tag/{tag}', 'search.php?Tags={tag}', '_Profiles');

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_views`
--

CREATE TABLE `sys_objects_views` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `table_track` varchar(32) NOT NULL,
  `period` int(11) NOT NULL DEFAULT '86400',
  `trigger_table` varchar(32) NOT NULL,
  `trigger_field_id` varchar(32) NOT NULL,
  `trigger_field_views` varchar(32) NOT NULL,
  `is_on` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_objects_views`
--

INSERT INTO `sys_objects_views` VALUES
(1, 'profiles', 'sys_profile_views_track', 86400, 'Profiles', 'ID', 'Views', 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_objects_vote`
--

CREATE TABLE `sys_objects_vote` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ObjectName` varchar(50) NOT NULL,
  `TableRating` varchar(50) NOT NULL,
  `TableTrack` varchar(50) NOT NULL,
  `RowPrefix` varchar(20) NOT NULL,
  `MaxVotes` smallint(2) NOT NULL,
  `PostName` varchar(50) NOT NULL,
  `IsDuplicate` varchar(80) NOT NULL,
  `IsOn` smallint(1) NOT NULL,
  `className` varchar(50) NOT NULL DEFAULT '',
  `classFile` varchar(100) NOT NULL DEFAULT '',
  `TriggerTable` varchar(32) NOT NULL,
  `TriggerFieldRate` varchar(32) NOT NULL,
  `TriggerFieldRateCount` varchar(32) NOT NULL,
  `TriggerFieldId` varchar(32) NOT NULL,
  `OverrideClassName` varchar(32) NOT NULL,
  `OverrideClassFile` varchar(256) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_objects_vote`
--

INSERT INTO `sys_objects_vote` VALUES
(1, 'profile', 'sys_profile_rating', 'sys_profile_voting_track', 'pr_', 5, 'vote_send_result', 'BX_PERIOD_PER_VOTE', 1, '', '', 'Profiles', 'Rate', 'RateCount', 'ID', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `sys_options`
--

CREATE TABLE `sys_options` (
  `Name` varchar(64) NOT NULL DEFAULT '',
  `VALUE` mediumtext NOT NULL,
  `kateg` int(6) unsigned NOT NULL DEFAULT '0',
  `desc` varchar(255) NOT NULL DEFAULT '',
  `Type` enum('digit','text','checkbox','select','select_multiple','file','list') NOT NULL DEFAULT 'digit',
  `check` text NOT NULL,
  `err_text` varchar(255) NOT NULL DEFAULT '',
  `order_in_kateg` float DEFAULT NULL,
  `AvailableValues` text NOT NULL,
  PRIMARY KEY (`Name`),
  KEY `kateg` (`kateg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



-- --------------------------------------------------------

--
-- Table structure for table `sys_options_cats`
--

CREATE TABLE `sys_options_cats` (
  `ID` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `menu_order` float DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=100 ;

--
-- Dumping data for table `sys_options_cats`
--

INSERT INTO `sys_options_cats` VALUES
(1, 'Profiles', 1),
(3, 'General', 3),
(4, 'Massmailer', 4),
(5, 'Memberships', 5),
(6, 'Moderation', 6),
(7, 'Site', 7),
(9, 'Privacy Groups', 9),
(11, 'Pruning', 11),
(12, 'Matches', 12),
(13, 'Template', 13),
(14, 'Security', 14),
(16, 'Watermark', 16),
(21, 'Languages', 21),
(22, 'IP Block List', 22),
(23, 'Antispam', 23),
(24, 'Caching', 24),
(25, 'Tags Settings', 25),
(26, 'Permalinks', 26),
(27, 'Categories Settings', 27);

-- --------------------------------------------------------

--
-- Table structure for table `sys_page_compose`
--

CREATE TABLE `sys_page_compose` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Page` varchar(255) NOT NULL DEFAULT '',
  `PageWidth` varchar(10) NOT NULL DEFAULT '1140px',
  `Desc` text NOT NULL,
  `Caption` varchar(255) NOT NULL DEFAULT '',
  `Column` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Order` smallint(6) unsigned NOT NULL DEFAULT '0',
  `Func` varchar(255) NOT NULL DEFAULT '',
  `Content` text NOT NULL,
  `DesignBox` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `ColWidth` float unsigned NOT NULL DEFAULT '0',
  `Visible` set('non','memb') NOT NULL DEFAULT 'non,memb',
  `MinWidth` int(10) unsigned NOT NULL DEFAULT '0',
  `Cache` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=71 ;

--
-- Dumping data for table `sys_page_compose`
--

INSERT INTO `sys_page_compose` VALUES
(1, '', '1140px', 'RSS Feed', '_RSS Feed', 0, 0, 'Sample', 'RSS', 1, 0, 'non,memb', 0, 0),
(2, '', '1140px', 'Simple HTML Block', '_HTML Block', 0, 0, 'Sample', 'Echo', 11, 0, 'non,memb', 0, 0),
(3, '', '1140px', 'Simple Text Block', '_Text Block', 0, 0, 'Sample', 'Text', 11, 0, 'non,memb', 0, 0),
(4, 'index', '1140px', 'Shows statistic information about your site content', '_Site Stats', 2, 2, 'SiteStats', '', 1, 28.1, 'non,memb', 0, 3600),
(5, 'index', '1140px', 'Display form to subscribe to newsletters', '_Subscribe_block_caption', 2, 1, 'Subscribe', '', 1, 28.1, 'non,memb', 0, 0),
(6, 'index', '1140px', 'Quick search form', '_Quick Search', 0, 0, 'QuickSearch', '', 1, 28.1, 'non,memb', 0, 0),
(7, 'index', '1140px', 'List of featured profiles', '_featured members', 0, 0, 'Featured', '', 1, 71.9, 'non,memb', 0, 0),
(8, 'index', '1140px', 'Site Tags', '_Tags', 0, 0, 'Tags', '', 1, 71.9, 'non,memb', 0, 0),
(9, 'index', '1140px', 'Site Categories', '_Categories', 0, 0, 'Categories', '', 1, 71.9, 'non,memb', 0, 0),
(10, 'index', '1140px', 'List of profiles', '_Members', 2, 0, 'Members', '', 1, 28.1, 'non,memb', 0, 0),
(11, 'index', '1140px', 'Shows Login Form', '_Member_Login', 0, 0, 'LoginSection', '', 11, 28.1, 'non', 0, 86400),
(12, 'index', '1140px', '', '_BoonEx News', 1, 0, 'RSS', 'https://www.boonex.com/notes/featured_posts/?rss=1#4', 1, 71.9, 'non,memb', 0, 86400),
(13, 'index', '1140px', 'Download', '_sys_box_title_download', 0, 0, 'Download', '', 1, 28.1, 'non,memb', 0, 86400),
(14, 'member', '1140px', 'Quick Links', '_Quick Links', 1, 0, 'QuickLinks', '', 1, 71.9, 'memb', 0, 0),
(15, 'member', '1140px', 'Friend Requests', '_sys_bcpt_member_friend_requests', 2, 1, 'FriendRequests', '', 1, 28.1, 'memb', 0, 0),
(16, 'member', '1140px', 'New Messages', '_sys_bcpt_member_new_messages', 2, 2, 'NewMessages', '', 1, 28.1, 'memb', 0, 0),
(17, 'member', '1140px', 'Account Control', '_sys_bcpt_member_account_control', 2, 3, 'AccountControl', '', 1, 28.1, 'memb', 0, 0),
(18, 'member', '1140px', 'Member Friends', '_My Friends', 0, 0, 'Friends', '', 1, 28.1, 'memb', 0, 0),
(19, 'profile', '1140px', 'Profile cover', '_sys_bcpt_profile_cover', 1, 1, 'Cover', '', 0, 100, 'non,memb', 0, 0),
(20, 'profile', '1140px', 'Profile actions', '_Actions', 2, 2, 'ActionsMenu', '', 1, 28.1, 'non,memb', 0, 0),
(21, 'profile', '1140px', 'Friend request notification', '_FriendRequest', 2, 3, 'FriendRequest', '', 1, 28.1, 'memb', 0, 0),
(22, 'profile', '1140px', 'Profile description block', '_Description', 3, 2, 'Description', '', 1, 71.9, 'non,memb', 0, 0),
(23, 'profile', '1140px', 'Profile Fields Block', '_FieldCaption_Admin Controls_View', 2, 4, 'PFBlock', '21', 1, 28.1, 'non,memb', 0, 0),
(24, 'profile', '1140px', 'Profile Fields Block', '_FieldCaption_General Info_View', 2, 5, 'PFBlock', '17', 1, 28.1, 'non,memb', 0, 0),
(25, 'profile', '1140px', 'Profile rating form', '_rate profile', 2, 6, 'RateProfile', '', 1, 28.1, 'non,memb', 0, 0),
(26, 'profile', '1140px', 'Member friends list', '_Friends', 0, 0, 'Friends', '', 1, 71.9, 'non,memb', 0, 0),
(27, 'profile', '1140px', 'Mutual friends of viewing and viewed members', '_Mutual Friends', 0, 0, 'MutualFriends', '', 1, 71.9, 'non,memb', 0, 0),
(28, 'profile', '1140px', 'Comments on member profile', '_profile_comments', 0, 0, 'Cmts', '', 1, 71.9, 'non,memb', 0, 0),
(29, 'profile', '1140px', 'Profile Fields Block', '_FieldCaption_Misc_View', 0, 0, 'PFBlock', '20', 1, 71.9, 'non,memb', 0, 0),
(30, 'profile_info', '1140px', '', '_FieldCaption_General Info_View', 1, 0, 'GeneralInfo', '', 1, 100, 'non,memb', 0, 0),
(31, 'profile_info', '1140px', '', '_Additional information', 1, 2, 'AdditionalInfo', '', 1, 100, 'non,memb', 0, 0),
(32, 'profile_info', '1140px', 'Profile''s description', '_Description', 1, 1, 'Description', '', 1, 100, 'non,memb', 0, 0),
(33, 'friends', '1140px', '', '_Member Friends', 1, 1, 'Friends', '', 1, 71.9, 'non,memb', 0, 0),
(34, 'friends', '1140px', '', '_Member Friends Requests', 2, 1, 'FriendsRequests', '', 1, 28.1, 'memb', 0, 0),
(35, 'friends', '1140px', '', '_Member Friends Mutual', 2, 2, 'FriendsMutual', '', 1, 28.1, 'memb', 0, 0),
(36, 'browse_page', '1140px', '', '_Browse', 2, 0, 'SettingsBlock', '', 0, 28.1, 'non,memb', 0, 0),
(37, 'browse_page', '1140px', '', '_People', 1, 0, 'SearchedMembersBlock', '', 1, 71.9, 'non,memb', 0, 0),
(38, 'mail_page', '1140px', '', '_Mail box', 1, 0, 'MailBox', '', 1, 71.9, 'non,memb', 0, 0),
(39, 'mail_page', '1140px', '', '_My contacts', 2, 0, 'Contacts', '', 1, 28.1, 'non,memb', 0, 0),
(40, 'mail_page_view', '1140px', '', '_Mail box', 1, 0, 'ViewMessage', '', 1, 71.9, 'non,memb', 0, 0),
(41, 'mail_page_view', '1140px', '', '_Archive', 2, 0, 'Archives', '', 1, 28.1, 'non,memb', 0, 0),
(42, 'mail_page_compose', '1140px', '', '_COMPOSE_H', 1, 0, 'ComposeMessage', '', 1, 71.9, 'non,memb', 0, 0),
(43, 'mail_page_compose', '1140px', '', '_My contacts', 2, 0, 'Contacts', '', 1, 28.1, 'non,memb', 0, 0),
(44, 'search', '1140px', 'Search Results', '_Search result', 1, 0, 'Results', '', 1, 71.9, 'non,memb', 0, 0),
(45, 'search', '1140px', 'Search Form', '_Search profiles', 2, 0, 'SearchForm', '', 1, 28.1, 'non,memb', 0, 0),
(46, 'search_home', '1140px', 'Keyword Search', '_sys_box_title_search_keyword', 1, 0, 'Keyword', '', 1, 71.9, 'non,memb', 0, 86400),
(47, 'search_home', '1140px', 'People Search', '_sys_box_title_search_people', 2, 0, 'People', '', 1, 28.1, 'non,memb', 0, 0),
(48, 'join', '1140px', 'Join Form Block', '_Join_now', 1, 0, 'JoinForm', '', 1, 100, 'non', 413, 0),
(49, 'join', '1140px', 'Login Form Block', '_Login', 0, 0, 'LoginSection', 'no_join_text', 11, 100, 'non', 250, 86400),
(50, 'communicator_page', '1140px', '', '_sys_cnts_bcpt_connections', 1, 1, 'Connections', '', 1, 71.9, 'memb', 0, 0),
(51, 'communicator_page', '1140px', '', '_sys_cnts_bcpt_friend_requests', 2, 1, 'FriendRequests', '', 1, 28.1, 'memb', 0, 0),
(52, 'tags_home', '1140px', 'Recent Tags', '_tags_recent', 1, 0, 'Recent', '', 1, 28.1, 'non,memb', 0, 0),
(53, 'tags_home', '1140px', 'Popular Tags', '_popular_tags', 2, 0, 'Popular', '', 1, 71.9, 'non,memb', 0, 0),
(54, 'tags_calendar', '1140px', 'Calendar', '_tags_calendar', 1, 0, 'Calendar', '', 1, 100, 'non,memb', 0, 0),
(55, 'tags_calendar', '1140px', 'Date Tags', '_Tags', 1, 1, 'TagsDate', '', 1, 100, 'non,memb', 0, 0),
(56, 'tags_search', '1140px', 'Search Form', '_tags_search_form', 1, 0, 'Form', '', 1, 100, 'non,memb', 0, 86400),
(57, 'tags_search', '1140px', 'Founded Tags', '_tags_founded_tags', 1, 1, 'Founded', '', 1, 100, 'non,memb', 0, 0),
(58, 'tags_module', '1140px', 'Recent Tags', '_tags_recent', 1, 0, 'Recent', '', 1, 28.1, 'non,memb', 0, 0),
(59, 'tags_module', '1140px', 'All Tags', '_all_tags', 2, 0, 'All', '', 1, 71.9, 'non,memb', 0, 0),
(60, 'categ_calendar', '1140px', 'Calendar', '_categ_caption_calendar', 1, 0, 'Calendar', '', 1, 100, 'non,memb', 0, 0),
(61, 'categ_calendar', '1140px', 'Categories By Day', '_categ_caption_day', 1, 1, 'CategoriesDate', '', 1, 100, 'non,memb', 0, 0),
(62, 'categ_search', '1140px', 'Search Form', '_categ_caption_search_form', 1, 0, 'Form', '', 1, 100, 'non,memb', 0, 86400),
(63, 'categ_search', '1140px', 'Founded Categories', '_categ_caption_founded', 1, 1, 'Founded', '', 1, 100, 'non,memb', 0, 0),
(64, 'categ_module', '1140px', 'Common Categories', '_categ_caption_common', 1, 0, 'Common', '', 1, 28.1, 'non,memb', 0, 0),
(65, 'categ_module', '1140px', 'All Categories', '_categ_caption_all', 2, 0, 'All', '', 1, 71.9, 'non,memb', 0, 0),
(66, 'pedit', '1140px', 'Profile fields', '_edit_profile_info', 1, 1, 'Info', '', 1, 71.9, 'memb', 0, 0),
(67, 'pedit', '1140px', 'Profile privacy', '_edit_profile_privacy', 2, 1, 'Privacy', '', 1, 28.1, 'memb', 0, 0),
(68, 'pedit', '1140px', 'Profile membership', '_edit_profile_membership', 2, 2, 'Membership', '', 1, 28.1, 'memb', 0, 0),
(69, 'profile_private', '1140px', 'Actions that other members can do', '_Actions', 1, 0, 'ActionsMenu', '', 1, 28.1, 'non,memb', 0, 0),
(70, 'profile_private', '1140px', 'Some text to explain why this profile can not be viewed. Translation for this block is stored in ''_sys_profile_private_text'' language key.', '_sys_profile_private_text_title', 2, 0, 'PrivacyExplain', '', 1, 71.9, 'non,memb', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_page_compose_pages`
--

CREATE TABLE `sys_page_compose_pages` (
  `Name` varchar(255) NOT NULL DEFAULT '',
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Order` int(10) unsigned NOT NULL DEFAULT '0',
  `System` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_page_compose_pages`
--

INSERT INTO `sys_page_compose_pages` VALUES
('index', 'Homepage', 1, 1),
('member', 'Account', 6, 1),
('profile', 'Profile', 7, 1),
('pedit', 'Profile Edit', 8, 1),
('profile_info', 'Profile Info', 14, 1),
('profile_private', 'Profile Private', 15, 1),
('browse_page', 'All Members', 17, 1),
('mail_page', 'Mail Messages', 18, 1),
('mail_page_view', 'Mail View Message', 19, 1),
('mail_page_compose', 'Mail Compose Message', 20, 1),
('search', 'Search Profiles', 21, 1),
('join', 'Join Page', 22, 1),
('friends', 'Friends', 23, 1),
('communicator_page', 'Communicator', 24, 1),
('search_home', 'Search Home', 25, 1),
('tags_home', 'Tags Home', 26, 1),
('tags_calendar', 'Tags Search', 27, 1),
('tags_search', 'Tags Calendar', 28, 1),
('tags_module', 'Tags Module', 29, 1),
('categ_calendar', 'Categories Calendar', 30, 1),
('categ_search', 'Categories Search', 31, 1),
('categ_module', 'Categories Module', 32, 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_page_compose_privacy`
--

CREATE TABLE `sys_page_compose_privacy` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `block_id` int(11) unsigned NOT NULL DEFAULT '0',
  `allow_view_block_to` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `block` (`user_id`,`block_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_permalinks`
--

CREATE TABLE `sys_permalinks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `standard` varchar(128) NOT NULL DEFAULT '',
  `permalink` varchar(128) NOT NULL DEFAULT '',
  `check` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `check` (`standard`,`permalink`,`check`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_privacy_actions`
--

CREATE TABLE `sys_privacy_actions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_uri` varchar(64) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `default_group` varchar(255) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `action` (`module_uri`,`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_privacy_actions`
--

INSERT INTO `sys_privacy_actions` VALUES
(1, 'profile', 'view_block', '_ps_view_block', '3');

-- --------------------------------------------------------

--
-- Table structure for table `sys_privacy_defaults`
--

CREATE TABLE `sys_privacy_defaults` (
  `owner_id` int(11) NOT NULL DEFAULT '0',
  `action_id` int(11) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`owner_id`,`action_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_privacy_groups`
--

CREATE TABLE `sys_privacy_groups` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `home_url` varchar(255) NOT NULL DEFAULT '',
  `get_parent` text NOT NULL,
  `get_content` text NOT NULL,
  `members_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `sys_privacy_groups`
--

INSERT INTO `sys_privacy_groups` VALUES
(1, 0, 0, '', '', '$aProfile = getProfileInfo($arg1); return (int)$aProfile[''PrivacyDefaultGroup''];', '', 0),
(2, 0, 0, '', '', '', 'return false;', 0),
(3, 0, 0, '', '', '', 'return true;', 0),
(4, 0, 0, '', '', '', 'return isMember() && isProfileActive($arg2);', 0),
(5, 0, 0, '', 'communicator.php?communicator_mode=friends_list', '', '$aIds = $arg0->fromMemory($arg0->_sGroupFriendsCache . $arg1, "getColumn", "SELECT `p`.`ID` AS `id` FROM `Profiles` AS `p` LEFT JOIN `sys_friend_list` AS `f1` ON (`f1`.`ID`=`p`.`ID` AND `f1`.`Profile`=''" . $arg1 . "'' AND `f1`.`Check`=1) LEFT JOIN `sys_friend_list` AS `f2` ON (`f2`.`Profile`=p.`ID` AND `f2`.`ID`=''" . $arg1 . "'' AND `f2`.`Check`=1) WHERE 1 AND (`f1`.`ID` IS NOT NULL OR `f2`.`ID` IS NOT NULL)"); return isProfileActive($arg2) && in_array($arg2, $aIds);', 0),
(6, 0, 0, '', 'communicator.php?&communicator_mode=hotlist_requests', '', '$aIds = $arg0->fromMemory($arg0->_sGroupFavesCache . $arg1, "getColumn", "SELECT `Profile` AS `id` FROM `sys_fave_list` WHERE `ID`=''" . $arg1 . "''"); return isProfileActive($arg2) && in_array($arg2, $aIds);', 0),
(7, 0, 0, '', 'mail.php?&mode=inbox&contacts_mode=Contacted', '', '$aIds = $arg0->fromMemory($arg0->_sGroupContactsCache . $arg1, "getColumn", "SELECT `tp`.`ID` AS `id` FROM `sys_messages` AS `tm` INNER JOIN `Profiles` AS `tp` ON (`tm`.`Sender`=`tp`.`ID` AND `tm`.`Recipient`=''" . $arg1 . "'') OR (`tm`.`Recipient`=`tp`.`ID` AND `tm`.`Sender`=''" . $arg1 . "'')"); return isProfileActive($arg2) && in_array($arg2, $aIds);', 0),
(8, 0, 0, '', '', '', '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_privacy_members`
--

CREATE TABLE `sys_privacy_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL DEFAULT '0',
  `member_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_member` (`group_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_profiles_match`
--

CREATE TABLE `sys_profiles_match` (
  `profile_id` int(10) NOT NULL,
  `sort` enum('none','activity','date_reg') NOT NULL DEFAULT 'none',
  `profiles_match` text,
  UNIQUE KEY `profile_id` (`profile_id`,`sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_profiles_match_mails`
--

CREATE TABLE `sys_profiles_match_mails` (
  `profile_id` int(10) NOT NULL,
  `profiles_match` text NOT NULL,
  PRIMARY KEY (`profile_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_profile_fields`
--

CREATE TABLE `sys_profile_fields` (
  `ID` smallint(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `Type` enum('text','html_area','area','pass','date','select_one','select_set','num','range','bool','system','block') NOT NULL DEFAULT 'text',
  `Control` enum('select','checkbox','radio') DEFAULT NULL COMMENT 'input element for selectors',
  `Extra` text NOT NULL,
  `Min` float DEFAULT NULL,
  `Max` float DEFAULT NULL,
  `Values` text NOT NULL,
  `UseLKey` enum('LKey','LKey2','LKey3') NOT NULL DEFAULT 'LKey',
  `Check` text NOT NULL,
  `Unique` tinyint(1) NOT NULL DEFAULT '0',
  `Default` text NOT NULL,
  `Mandatory` tinyint(1) NOT NULL DEFAULT '0',
  `Deletable` tinyint(1) NOT NULL DEFAULT '1',
  `JoinPage` int(10) unsigned NOT NULL DEFAULT '0',
  `JoinBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `JoinOrder` float DEFAULT NULL,
  `EditOwnBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `EditOwnOrder` float DEFAULT NULL,
  `EditAdmBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `EditAdmOrder` float DEFAULT NULL,
  `EditModBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `EditModOrder` float DEFAULT NULL,
  `ViewMembBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `ViewMembOrder` float DEFAULT NULL,
  `ViewAdmBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `ViewAdmOrder` float DEFAULT NULL,
  `ViewModBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `ViewModOrder` float DEFAULT NULL,
  `ViewVisBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `ViewVisOrder` float DEFAULT NULL,
  `SearchParams` text NOT NULL,
  `SearchSimpleBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `SearchSimpleOrder` float DEFAULT NULL,
  `SearchQuickBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `SearchQuickOrder` float DEFAULT NULL,
  `SearchAdvBlock` int(10) unsigned NOT NULL DEFAULT '0',
  `SearchAdvOrder` float DEFAULT NULL,
  `MatchField` int(10) unsigned NOT NULL DEFAULT '0',
  `MatchPercent` tinyint(7) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=71 ;



-- --------------------------------------------------------

--
-- Table structure for table `sys_profile_rating`
--

CREATE TABLE `sys_profile_rating` (
  `pr_id` int(10) unsigned NOT NULL DEFAULT '0',
  `pr_rating_count` int(11) NOT NULL DEFAULT '0',
  `pr_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `med_id` (`pr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_profile_views_track`
--

CREATE TABLE `sys_profile_views_track` (
  `id` int(10) unsigned NOT NULL,
  `viewer` int(10) unsigned NOT NULL,
  `ip` int(10) unsigned NOT NULL,
  `ts` int(10) unsigned NOT NULL,
  KEY `id` (`id`,`viewer`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_profile_voting_track`
--

CREATE TABLE `sys_profile_voting_track` (
  `pr_id` int(10) unsigned NOT NULL DEFAULT '0',
  `pr_ip` varchar(20) DEFAULT NULL,
  `pr_date` datetime DEFAULT NULL,
  KEY `pr_ip` (`pr_ip`,`pr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_sbs_entries`
--

CREATE TABLE `sys_sbs_entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subscriber_id` int(11) NOT NULL DEFAULT '0',
  `subscriber_type` tinyint(4) NOT NULL DEFAULT '0',
  `subscription_id` int(11) NOT NULL DEFAULT '0',
  `object_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry` (`subscriber_id`,`subscriber_type`,`subscription_id`,`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_sbs_messages`
--

CREATE TABLE `sys_sbs_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(128) NOT NULL DEFAULT '',
  `body` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_sbs_queue`
--

CREATE TABLE `sys_sbs_queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(64) NOT NULL DEFAULT '',
  `subject` varchar(255) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_sbs_types`
--

CREATE TABLE `sys_sbs_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit` varchar(32) NOT NULL DEFAULT '',
  `action` varchar(32) NOT NULL DEFAULT '',
  `template` varchar(64) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription` (`unit`,`action`,`template`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `sys_sbs_types`
--

INSERT INTO `sys_sbs_types` VALUES
(1, 'system', '', '', 'return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_mass_mailer''), ''ViewLink'' => BX_DOL_URL_ROOT));'),
(2, 'system', 'mass_mailer', 't_AdminEmail', 'return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_mass_mailer''), ''ViewLink'' => BX_DOL_URL_ROOT));'),
(3, 'profile', '', '', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));'),
(4, 'profile', 'commentPost', 't_sbsProfileComments', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile_comments'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));'),
(5, 'profile', 'edit', 't_sbsProfileEdit', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile_edit'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));');

-- --------------------------------------------------------

--
-- Table structure for table `sys_sbs_users`
--

CREATE TABLE `sys_sbs_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '',
  `email` varchar(64) NOT NULL DEFAULT '',
  `date` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriber` (`name`,`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sys_sessions`
--

CREATE TABLE `sys_sessions` (
  `id` varchar(32) NOT NULL DEFAULT '',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_sessions`
--

-- --------------------------------------------------------

--
-- Table structure for table `sys_shared_sites`
--

CREATE TABLE `sys_shared_sites` (
  `ID` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `URL` varchar(255) NOT NULL DEFAULT '',
  `Icon` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `sys_shared_sites`
--

INSERT INTO `sys_shared_sites` VALUES
(1, 'digg', 'http://digg.com/submit?phase=2&url=', 'digg.png'),
(2, 'delicious', 'http://del.icio.us/post?url=', 'delicious.png'),
(3, 'newsvine', 'http://www.newsvine.com/_tools/seed&save?u=', 'newsvine.png'),
(4, 'reddit', 'http://reddit.com/submit?url=', 'reddit.png'),
(5, 'facebook', 'http://www.facebook.com/sharer/sharer.php?u=', 'facebook.png'),
(6, 'twitter', 'https://twitter.com/share?url=', 'twitter.png');

-- --------------------------------------------------------

--
-- Table structure for table `sys_stat_member`
--

CREATE TABLE `sys_stat_member` (
  `Type` varchar(10) NOT NULL,
  `SQL` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_stat_member`
--

INSERT INTO `sys_stat_member` VALUES
('mma', 'SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=''__member_id__'' AND NOT FIND_IN_SET(''Recipient'', `sys_messages`.`Trash`)'),
('mmn', 'SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=''__member_id__'' AND `New`=''1'' AND NOT FIND_IN_SET(''Recipient'', `sys_messages`.`Trash`)'),
('mfl', 'SELECT COUNT(*) FROM `sys_fave_list` WHERE `ID` = ''__member_id__'' '),
('mfr', 'SELECT COUNT(*) FROM `sys_friend_list` as f LEFT JOIN `Profiles` as p ON p.`ID` = f.`ID` WHERE f.`Profile` = __member_id__ AND f.`Check` = ''0'' AND p.`Status`=''Active'''),
('mfa', 'SELECT COUNT(*) FROM `sys_friend_list` WHERE ( `ID`=''__member_id__'' OR `Profile`=''__member_id__'' ) AND `Check`=''1'''),
('mgc', 'SELECT COUNT(*) FROM `sys_greetings` WHERE `ID` = ''__member_id__'' AND New = ''1'''),
('mbc', 'SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = ''__member_id__'''),
('mgmc', 'SELECT COUNT(*) FROM `sys_greetings` WHERE `Profile` = ''__member_id__'' AND New = ''1''');

-- --------------------------------------------------------

--
-- Table structure for table `sys_stat_site`
--

CREATE TABLE `sys_stat_site` (
  `ID` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(20) NOT NULL DEFAULT '',
  `Title` varchar(50) NOT NULL DEFAULT '',
  `UserLink` varchar(255) NOT NULL DEFAULT '',
  `UserQuery` varchar(255) NOT NULL DEFAULT '',
  `AdminLink` varchar(255) NOT NULL DEFAULT '',
  `AdminQuery` varchar(255) NOT NULL DEFAULT '',
  `IconName` varchar(50) NOT NULL DEFAULT '',
  `StatOrder` int(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sys_stat_site`
--

INSERT INTO `sys_stat_site` VALUES
(1, 'all', 'Members', 'browse.php', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status`=''Active'' AND (`Couple`=''0'' OR `Couple`>`ID`)', '{admin_url}profiles.php?action=browse&by=status&value=approval', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status`=''Approval'' AND (`Couple`=''0'' OR `Couple`>`ID`)', 'user', 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_tags`
--

CREATE TABLE `sys_tags` (
  `Tag` varchar(32) NOT NULL DEFAULT '',
  `ObjID` int(10) unsigned NOT NULL DEFAULT '0',
  `Type` varchar(20) NOT NULL DEFAULT 'profile',
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`Tag`,`ObjID`,`Type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

