--
-- Host: localhost    Database: persisters_deva
-- ------------------------------------------------------


--
-- 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;

--
-- Dumping data for table `RayBoardBoards`
--


--
-- 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;

--
-- Dumping data for table `RayBoardCurrentUsers`
--


--
-- 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;

--
-- Dumping data for table `RayBoardUsers`
--


--
-- 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;

--
-- Dumping data for table `RayChatCurrentUsers`
--


--
-- 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;

--
-- Dumping data for table `RayChatHistory`
--


--
-- 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;

--
-- Dumping data for table `RayChatMemberships`
--


--
-- 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 AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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;

--
-- Dumping data for table `RayChatMessages`
--


--
-- 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;

--
-- Dumping data for table `RayChatProfiles`
--


--
-- 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;

--
-- Dumping data for table `RayChatRoomsUsers`
--


--
-- 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;

--
-- Dumping data for table `RayImContacts`
--


--
-- 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;

--
-- Dumping data for table `RayImMessages`
--


--
-- 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;

--
-- Dumping data for table `RayImPendings`
--


--
-- 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;

--
-- Dumping data for table `RayImProfiles`
--


--
-- 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`),
  KEY `Owner` (`Owner`),
  FULLTEXT KEY `ftMain` (`Title`,`Tags`,`Description`,`Categories`),
  FULLTEXT KEY `ftTags` (`Tags`),
  FULLTEXT KEY `ftCategories` (`Categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayMp3Files`
--


--
-- 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;

--
-- Dumping data for table `RayMp3Tokens`
--


--
-- 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;

--
-- Dumping data for table `RayShoutboxMessages`
--


--
-- 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`),
  KEY `Owner` (`Owner`),
  FULLTEXT KEY `ftMain` (`Title`,`Tags`,`Description`,`Categories`),
  FULLTEXT KEY `ftTags` (`Tags`),
  FULLTEXT KEY `ftCategories` (`Categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayVideoFiles`
--


--
-- 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;

--
-- Dumping data for table `RayVideoTokens`
--


--
-- 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`),
  KEY `Owner` (`Owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RayVideo_commentsFiles`
--


--
-- 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;

--
-- Dumping data for table `RayVideo_commentsTokens`
--


--
-- Table structure for table `aqb_advanced_search_form_properties`
--

CREATE TABLE `aqb_advanced_search_form_properties` (
  `FieldID` int(11) NOT NULL DEFAULT '0',
  `Control` enum('default','select_box','select_multiple','checkbox_set') DEFAULT 'default',
  `ShowEmptyValue` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`FieldID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aqb_advanced_search_form_properties`
--

INSERT INTO `aqb_advanced_search_form_properties` VALUES (55,'default',1),(58,'default',1);

--
-- Table structure for table `bx_ads_category`
--

CREATE TABLE `bx_ads_category` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(64) NOT NULL DEFAULT '',
  `CEntryUri` varchar(64) NOT NULL DEFAULT '',
  `Description` varchar(128) DEFAULT NULL,
  `CustomFieldName1` varchar(50) DEFAULT NULL,
  `CustomFieldName2` varchar(50) DEFAULT NULL,
  `Unit1` varchar(8) NOT NULL DEFAULT '$',
  `Unit2` varchar(8) NOT NULL,
  `Picture` varchar(255) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `CEntryUri` (`CEntryUri`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_category`
--

INSERT INTO `bx_ads_category` VALUES (1,'Jobs','Jobs','Jobs','salary','','$','','user-md'),(4,'Housing & Rentals','Housing-_-Rentals','Housing & Rentals','rental','','$','','home'),(5,'Services','Services','Services','price','','$','','wrench'),(9,'For Sale','For-Sale','For Sale','price','year','$','','shopping-cart'),(10,'Cars For Sale','Cars-For-Sale','Cars For Sale','price','year','$','','truck');

--
-- Table structure for table `bx_ads_category_subs`
--

CREATE TABLE `bx_ads_category_subs` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `IDClassified` int(11) unsigned DEFAULT NULL,
  `NameSub` varchar(128) NOT NULL DEFAULT '',
  `SEntryUri` varchar(128) NOT NULL DEFAULT '',
  `Description` varchar(150) DEFAULT 'No description',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `SEntryUri` (`SEntryUri`),
  KEY `IDClassified` (`IDClassified`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_category_subs`
--

INSERT INTO `bx_ads_category_subs` VALUES (4,2,'positions and openings','positions-and-openings','positions and openings desc'),(5,2,'instruments for sale','instruments-for-sale','instruments for sale desc'),(6,2,'instruments wanted','instruments-wanted','instruments wanted desc'),(7,3,'activities','activities','activities desc'),(8,3,'artists','artists','artists desc'),(9,3,'childcare','childcare','childcare desc'),(10,4,'apartments / housing','apartments-housing','apartments / housing description'),(11,4,'real estate for sale','real-estate-for-sale','real estate for sale description'),(12,4,'roommates','roommates','roommates description'),(38,1,'accounting / finance','accounting-finance','accounting / finance desc'),(36,5,'automotive','automotive','automotive desc'),(43,1,'education / nonprofit sec','education-nonprofit-sec','education / nonprofit sector desc'),(47,1,'government / legal','government-legal','government/legal desc'),(84,1,'programming / web design','programming-web-design','programming / web design desc'),(54,1,'other','other','other desc'),(55,4,'temporary vacation rental','temporary-vacation-rental','temporary vacation rentals desc'),(56,4,'office / commercial','office-commercial','office / commercial  desc'),(58,5,'financial','financial','financial'),(60,5,'labor / move','labor-move','labor/move desc'),(61,5,'legal','legal','legal desc'),(62,5,'educational','educational','educational desc'),(64,7,'acting','acting','acting desc'),(65,7,'dance','dance','dance desc'),(83,7,'musicians','musicians','musicians desc'),(67,7,'modeling','modeling','modeling desc'),(68,7,'reality shows','reality-shows','reality shows  desc'),(69,8,'men seeking women','men-seeking-women','men seeking women desc'),(70,8,'women seeking men','women-seeking-men','women seeking men desc'),(71,8,'women seeking women','women-seeking-women','women seeking women desc'),(73,8,'missed connections','missed-connections','missed connections desc'),(74,9,'barter','barter','barter desc'),(77,9,'clothing','clothing','clothing desc'),(78,9,'collectibles','collectibles','collectibles desc'),(79,9,'miscellaneous','miscellaneous','miscellaneous desc'),(80,10,'autos / trucks','autos-trucks','autos / trucks desc'),(81,10,'motorcycles','motorcycles','motorcycles desc'),(82,10,'auto parts','auto-parts','auto parts desc');

--
-- Table structure for table `bx_ads_cmts`
--

CREATE TABLE `bx_ads_cmts` (
  `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;

--
-- Dumping data for table `bx_ads_cmts`
--


--
-- Table structure for table `bx_ads_main`
--

CREATE TABLE `bx_ads_main` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `IDProfile` int(11) unsigned NOT NULL DEFAULT '0',
  `IDClassifiedsSubs` int(11) unsigned NOT NULL DEFAULT '0',
  `DateTime` int(10) DEFAULT NULL,
  `Subject` varchar(50) NOT NULL DEFAULT '',
  `EntryUri` varchar(255) NOT NULL DEFAULT '',
  `Message` text NOT NULL,
  `Status` enum('new','active','inactive') NOT NULL DEFAULT 'new',
  `CustomFieldValue1` varchar(50) DEFAULT NULL,
  `CustomFieldValue2` varchar(50) DEFAULT NULL,
  `LifeTime` int(3) NOT NULL DEFAULT '30',
  `Media` varchar(50) DEFAULT NULL,
  `Tags` text NOT NULL,
  `Country` varchar(2) DEFAULT NULL,
  `City` varchar(128) DEFAULT NULL,
  `Featured` int(1) NOT NULL DEFAULT '0',
  `Views` int(11) NOT NULL,
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `AllowView` int(11) NOT NULL,
  `AllowRate` int(11) NOT NULL,
  `AllowComment` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EntryUri` (`EntryUri`),
  KEY `IDProfile` (`IDProfile`),
  KEY `IDClassifiedsSubs` (`IDClassifiedsSubs`),
  FULLTEXT KEY `ftMain` (`Subject`,`Tags`,`Message`,`City`),
  FULLTEXT KEY `ftTags` (`Tags`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_main`
--

INSERT INTO `bx_ads_main` VALUES (2,12,10,1445390442,'ericamlee','ericamlee','<p>2 bedroom loft apartment near center of town. Large bedroom, 1 1/2 baths. </p>\r\n<p> </p>','active','1000','0',30,NULL,'sunny, loft','US','Anytown',0,1,0,0,0,4,4,4);

--
-- Table structure for table `bx_ads_main_media`
--

CREATE TABLE `bx_ads_main_media` (
  `MediaID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `MediaProfileID` int(11) unsigned NOT NULL DEFAULT '0',
  `MediaType` enum('photo','other') NOT NULL DEFAULT 'photo',
  `MediaFile` varchar(50) NOT NULL DEFAULT '',
  `MediaDate` int(10) DEFAULT NULL,
  PRIMARY KEY (`MediaID`),
  KEY `med_prof_id` (`MediaProfileID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_main_media`
--


--
-- Table structure for table `bx_ads_rating`
--

CREATE TABLE `bx_ads_rating` (
  `ads_id` int(12) NOT NULL DEFAULT '0',
  `ads_rating_count` int(11) NOT NULL DEFAULT '0',
  `ads_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `med_id` (`ads_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_rating`
--


--
-- Table structure for table `bx_ads_views_track`
--

CREATE TABLE `bx_ads_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;

--
-- Dumping data for table `bx_ads_views_track`
--

INSERT INTO `bx_ads_views_track` VALUES (2,12,2923333906,1445390443);

--
-- Table structure for table `bx_ads_voting_track`
--

CREATE TABLE `bx_ads_voting_track` (
  `ads_id` int(12) NOT NULL DEFAULT '0',
  `ads_ip` varchar(20) DEFAULT NULL,
  `ads_date` datetime DEFAULT NULL,
  KEY `med_ip` (`ads_ip`,`ads_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_ads_voting_track`
--


--
-- Table structure for table `bx_avatar_images`
--

CREATE TABLE `bx_avatar_images` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_avatar_images`
--


--
-- Table structure for table `bx_events_admins`
--

CREATE TABLE `bx_events_admins` (
  `id_entry` int(10) unsigned NOT NULL,
  `id_profile` int(10) unsigned NOT NULL,
  `when` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_entry`,`id_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_admins`
--


--
-- Table structure for table `bx_events_cmts`
--

CREATE TABLE `bx_events_cmts` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(12) 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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_cmts`
--

INSERT INTO `bx_events_cmts` VALUES (1,0,1,1,'I don\'t think I\'ve been invited yet.',0,0,0,'2015-04-08 16:29:11',0),(2,0,1,2,'did you get one now? \n',0,0,0,'2015-04-08 16:30:48',0),(3,0,1,1,'Odd.  I got an email about it, but when I log in, there\'s nothing to remind me of it.',0,0,0,'2015-04-08 16:32:39',0),(4,0,1,1,'I hired some entertainment.  See picture.',0,0,0,'2015-04-08 16:34:08',0);

--
-- Table structure for table `bx_events_cmts_track`
--

CREATE TABLE `bx_events_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;

--
-- Dumping data for table `bx_events_cmts_track`
--


--
-- Table structure for table `bx_events_files`
--

CREATE TABLE `bx_events_files` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_files`
--


--
-- Table structure for table `bx_events_forum`
--

CREATE TABLE `bx_events_forum` (
  `forum_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `forum_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `forum_title` varchar(255) DEFAULT NULL,
  `forum_desc` varchar(255) NOT NULL DEFAULT '',
  `forum_posts` int(11) NOT NULL DEFAULT '0',
  `forum_topics` int(11) NOT NULL DEFAULT '0',
  `forum_last` int(11) NOT NULL DEFAULT '0',
  `forum_type` enum('public','private') NOT NULL DEFAULT 'public',
  `forum_order` int(11) NOT NULL DEFAULT '0',
  `entry_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`forum_id`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_uri` (`forum_uri`),
  KEY `entry_id` (`entry_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum`
--

INSERT INTO `bx_events_forum` VALUES (1,'Test-Event',1,'Test Event','bethany',0,0,1428510258,'public',0,1),(2,'Mothers-Meeting-Test-Event',1,'Mothers Meeting Test Event','bethany',0,0,1433255749,'public',0,2),(3,'Main-Event',1,'Main Event','ericamlee',0,0,1445390725,'public',0,3);

--
-- Table structure for table `bx_events_forum_actions_log`
--

CREATE TABLE `bx_events_forum_actions_log` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `id` int(11) NOT NULL DEFAULT '0',
  `action_name` varchar(32) NOT NULL DEFAULT '',
  `action_when` int(11) NOT NULL DEFAULT '0',
  KEY `action_when` (`action_when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_actions_log`
--


--
-- Table structure for table `bx_events_forum_attachments`
--

CREATE TABLE `bx_events_forum_attachments` (
  `att_hash` char(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  `att_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_when` int(11) NOT NULL,
  `att_size` int(11) NOT NULL,
  `att_downloads` int(11) NOT NULL,
  PRIMARY KEY (`att_hash`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_attachments`
--


--
-- Table structure for table `bx_events_forum_cat`
--

CREATE TABLE `bx_events_forum_cat` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_name` varchar(255) DEFAULT NULL,
  `cat_icon` varchar(32) NOT NULL DEFAULT '',
  `cat_order` float NOT NULL DEFAULT '0',
  `cat_expanded` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `cat_order` (`cat_order`),
  KEY `cat_uri` (`cat_uri`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_cat`
--

INSERT INTO `bx_events_forum_cat` VALUES (1,'Events','Events','',64,0);

--
-- Table structure for table `bx_events_forum_flag`
--

CREATE TABLE `bx_events_forum_flag` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `when` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`,`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_flag`
--


--
-- Table structure for table `bx_events_forum_post`
--

CREATE TABLE `bx_events_forum_post` (
  `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `user` varchar(32) NOT NULL DEFAULT '0',
  `post_text` mediumtext NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `reports` int(11) NOT NULL DEFAULT '0',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `user` (`user`),
  KEY `when` (`when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_post`
--


--
-- Table structure for table `bx_events_forum_signatures`
--

CREATE TABLE `bx_events_forum_signatures` (
  `user` varchar(32) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `when` int(11) NOT NULL,
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_signatures`
--


--
-- Table structure for table `bx_events_forum_topic`
--

CREATE TABLE `bx_events_forum_topic` (
  `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_uri` varchar(255) NOT NULL DEFAULT '',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `topic_title` varchar(255) NOT NULL DEFAULT '',
  `when` int(11) NOT NULL DEFAULT '0',
  `topic_posts` int(11) NOT NULL DEFAULT '0',
  `first_post_user` varchar(32) NOT NULL DEFAULT '0',
  `first_post_when` int(11) NOT NULL DEFAULT '0',
  `last_post_user` varchar(32) NOT NULL DEFAULT '',
  `last_post_when` int(11) NOT NULL DEFAULT '0',
  `topic_sticky` int(11) NOT NULL DEFAULT '0',
  `topic_locked` tinyint(4) NOT NULL DEFAULT '0',
  `topic_hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `forum_id_2` (`forum_id`,`when`),
  KEY `topic_uri` (`topic_uri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_topic`
--


--
-- Table structure for table `bx_events_forum_user`
--

CREATE TABLE `bx_events_forum_user` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `user_pwd` varchar(32) NOT NULL DEFAULT '',
  `user_email` varchar(128) NOT NULL DEFAULT '',
  `user_join_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_user`
--


--
-- Table structure for table `bx_events_forum_user_activity`
--

CREATE TABLE `bx_events_forum_user_activity` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `act_current` int(11) NOT NULL DEFAULT '0',
  `act_last` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_user_activity`
--


--
-- Table structure for table `bx_events_forum_user_stat`
--

CREATE TABLE `bx_events_forum_user_stat` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `posts` int(11) NOT NULL DEFAULT '0',
  `user_last_post` int(11) NOT NULL DEFAULT '0',
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_user_stat`
--


--
-- Table structure for table `bx_events_forum_vote`
--

CREATE TABLE `bx_events_forum_vote` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `post_id` int(11) NOT NULL DEFAULT '0',
  `vote_when` int(11) NOT NULL DEFAULT '0',
  `vote_point` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`,`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_forum_vote`
--


--
-- Table structure for table `bx_events_images`
--

CREATE TABLE `bx_events_images` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_images`
--

INSERT INTO `bx_events_images` VALUES (1,3);

--
-- Table structure for table `bx_events_main`
--

CREATE TABLE `bx_events_main` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) NOT NULL DEFAULT '',
  `EntryUri` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Status` enum('approved','pending') NOT NULL DEFAULT 'approved',
  `Country` varchar(2) NOT NULL DEFAULT 'US',
  `City` varchar(50) NOT NULL DEFAULT '',
  `Place` varchar(100) NOT NULL DEFAULT '',
  `PrimPhoto` int(11) NOT NULL,
  `Date` int(11) NOT NULL,
  `EventStart` int(11) NOT NULL DEFAULT '0',
  `EventEnd` int(11) NOT NULL DEFAULT '0',
  `ResponsibleID` int(10) unsigned NOT NULL DEFAULT '0',
  `EventMembershipFilter` varchar(100) NOT NULL DEFAULT '',
  `Tags` varchar(255) NOT NULL DEFAULT '',
  `Categories` text NOT NULL,
  `Views` int(11) NOT NULL,
  `Rate` float NOT NULL,
  `RateCount` int(11) NOT NULL,
  `CommentsCount` int(11) NOT NULL,
  `FansCount` int(11) NOT NULL,
  `Featured` tinyint(4) NOT NULL,
  `allow_view_event_to` int(11) NOT NULL,
  `allow_view_participants_to` varchar(16) NOT NULL,
  `allow_comment_to` varchar(16) NOT NULL,
  `allow_rate_to` varchar(16) NOT NULL,
  `allow_join_to` int(11) NOT NULL,
  `allow_post_in_forum_to` varchar(16) NOT NULL,
  `allow_view_forum_to` varchar(16) NOT NULL,
  `JoinConfirmation` tinyint(4) NOT NULL DEFAULT '0',
  `allow_upload_photos_to` varchar(16) NOT NULL,
  `allow_upload_videos_to` varchar(16) NOT NULL,
  `allow_upload_sounds_to` varchar(16) NOT NULL,
  `allow_upload_files_to` varchar(16) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EntryUri` (`EntryUri`),
  KEY `ResponsibleID` (`ResponsibleID`),
  KEY `EventStart` (`EventStart`),
  KEY `Date` (`Date`),
  FULLTEXT KEY `Title` (`Title`,`Description`,`City`,`Place`,`Tags`,`Categories`),
  FULLTEXT KEY `Tags` (`Tags`),
  FULLTEXT KEY `Categories` (`Categories`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_main`
--

INSERT INTO `bx_events_main` VALUES (1,'Test Event','Test-Event','Show up if you can. ','approved','US','Amherst','A restaurant',3,1428510258,1428564660,1428576480,2,'','something','Presentation',5,0,0,4,2,1,3,'3','3','3',3,'','',0,'a','','',''),(2,'Mothers Meeting Test Event','Mothers-Meeting-Test-Event','<p>Test event. Mothers meet.  Etc.</p>','approved','US','Amherst','Raos',0,1433255749,1434427200,1434412800,2,'','fun','Birthday',1,0,0,0,0,0,4,'4','4','4',4,'','',0,'a','','',''),(3,'Main Event','Main-Event','<p><span style=\"color: #000000; font-family: Arial, Helvetica, sans; font-size: 11px; line-height: 14px; text-align: justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sollicitudin cursus viverra. Phasellus consequat ligula malesuada consectetur lobortis. In hac habitasse platea dictumst. Mauris ac porttitor odio, ac pretium arcu. Aenean finibus eget odio et hendrerit. Mauris pretium odio in elit sodales, quis posuere lorem vestibulum. Aliquam tincidunt leo nec blandit accumsan. Proin fringilla quam tellus, eu posuere elit placerat at. Nam sit amet iaculis ipsum, vitae dictum nulla. In pretium placerat faucibus. Donec nec nulla sit amet urna placerat bibendum id ut tellus. Aenean lobortis sollicitudin turpis, in sodales orci. Pellentesque sit amet faucibus ligula. Aliquam porttitor semper lorem vitae vestibulum.</span></p>','approved','US','Testville','The Foo Bar',0,1445390724,1446249600,1446422400,12,'','halloween,fun,africa','Expedition',1,0,0,0,0,0,4,'4','4','4',3,'p','p',0,'a','','','');

--
-- Table structure for table `bx_events_participants`
--

CREATE TABLE `bx_events_participants` (
  `id_entry` int(10) unsigned NOT NULL,
  `id_profile` int(10) unsigned NOT NULL,
  `when` int(10) unsigned NOT NULL,
  `confirmed` tinyint(4) NOT NULL,
  PRIMARY KEY (`id_entry`,`id_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_participants`
--

INSERT INTO `bx_events_participants` VALUES (1,2,1428510658,1),(1,1,1428510770,1);

--
-- Table structure for table `bx_events_rating`
--

CREATE TABLE `bx_events_rating` (
  `gal_id` int(10) unsigned NOT NULL DEFAULT '0',
  `gal_rating_count` int(11) NOT NULL DEFAULT '0',
  `gal_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `gal_id` (`gal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_rating`
--


--
-- Table structure for table `bx_events_rating_track`
--

CREATE TABLE `bx_events_rating_track` (
  `gal_id` int(10) unsigned NOT NULL DEFAULT '0',
  `gal_ip` varchar(20) DEFAULT NULL,
  `gal_date` datetime DEFAULT NULL,
  KEY `gal_ip` (`gal_ip`,`gal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_rating_track`
--


--
-- Table structure for table `bx_events_shoutbox`
--

CREATE TABLE `bx_events_shoutbox` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `HandlerID` int(11) NOT NULL,
  `OwnerID` int(11) NOT NULL,
  `Message` blob NOT NULL,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `IP` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `IP` (`IP`),
  KEY `HandlerID` (`HandlerID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bx_events_shoutbox`
--


--
-- Table structure for table `bx_events_sounds`
--

CREATE TABLE `bx_events_sounds` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_sounds`
--


--
-- Table structure for table `bx_events_videos`
--

CREATE TABLE `bx_events_videos` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_events_videos`
--


--
-- Table structure for table `bx_events_views_track`
--

CREATE TABLE `bx_events_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;

--
-- Dumping data for table `bx_events_views_track`
--

INSERT INTO `bx_events_views_track` VALUES (1,2,2722637885,1428510270),(1,1,2903073612,1428510539),(2,2,404930803,1433256072),(1,0,1311682103,1443508565),(1,0,1123631568,1443562986),(1,0,1123632055,1443992407),(3,12,2923333906,1445981293);

--
-- Table structure for table `bx_fdb_comments`
--

CREATE TABLE `bx_fdb_comments` (
  `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;

--
-- Dumping data for table `bx_fdb_comments`
--


--
-- Table structure for table `bx_fdb_comments_track`
--

CREATE TABLE `bx_fdb_comments_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;

--
-- Dumping data for table `bx_fdb_comments_track`
--


--
-- Table structure for table `bx_fdb_entries`
--

CREATE TABLE `bx_fdb_entries` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int(11) unsigned NOT NULL DEFAULT '0',
  `caption` varchar(64) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `uri` varchar(64) NOT NULL DEFAULT '',
  `tags` varchar(255) NOT NULL DEFAULT '',
  `allow_comment_to` int(11) NOT NULL DEFAULT '0',
  `allow_vote_to` int(11) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `rate` int(11) NOT NULL DEFAULT '0',
  `rate_count` int(11) NOT NULL DEFAULT '0',
  `cmts_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uri` (`uri`),
  FULLTEXT KEY `search_group` (`caption`,`content`,`tags`),
  FULLTEXT KEY `search_caption` (`caption`),
  FULLTEXT KEY `search_content` (`content`),
  FULLTEXT KEY `search_tags` (`tags`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_fdb_entries`
--


--
-- Table structure for table `bx_fdb_voting`
--

CREATE TABLE `bx_fdb_voting` (
  `fdb_id` bigint(8) NOT NULL DEFAULT '0',
  `fdb_rating_count` int(11) NOT NULL DEFAULT '0',
  `fdb_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `fdb_id` (`fdb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_fdb_voting`
--


--
-- Table structure for table `bx_fdb_voting_track`
--

CREATE TABLE `bx_fdb_voting_track` (
  `fdb_id` bigint(8) NOT NULL DEFAULT '0',
  `fdb_ip` varchar(20) DEFAULT NULL,
  `fdb_date` datetime DEFAULT NULL,
  KEY `fdb_ip` (`fdb_ip`,`fdb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_fdb_voting_track`
--


--
-- Table structure for table `bx_forum`
--

CREATE TABLE `bx_forum` (
  `forum_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `forum_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `forum_title` varchar(255) DEFAULT NULL,
  `forum_desc` varchar(255) NOT NULL DEFAULT '',
  `forum_posts` int(11) NOT NULL DEFAULT '0',
  `forum_topics` int(11) NOT NULL DEFAULT '0',
  `forum_last` int(11) NOT NULL DEFAULT '0',
  `forum_type` enum('public','private') NOT NULL DEFAULT 'public',
  `forum_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_uri` (`forum_uri`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum`
--

INSERT INTO `bx_forum` VALUES (1,'General-discussions',1,'General discussions','General discussions',1,1,1445808433,'public',2);

--
-- Table structure for table `bx_forum_actions_log`
--

CREATE TABLE `bx_forum_actions_log` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `id` int(11) NOT NULL DEFAULT '0',
  `action_name` varchar(32) NOT NULL DEFAULT '',
  `action_when` int(11) NOT NULL DEFAULT '0',
  KEY `action_when` (`action_when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_actions_log`
--

INSERT INTO `bx_forum_actions_log` VALUES ('ericamlee',2,'hide post',1445808441),('ericamlee',2,'unhide post',1445808444);

--
-- Table structure for table `bx_forum_attachments`
--

CREATE TABLE `bx_forum_attachments` (
  `att_hash` char(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  `att_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_when` int(11) NOT NULL,
  `att_size` int(11) NOT NULL,
  `att_downloads` int(11) NOT NULL,
  PRIMARY KEY (`att_hash`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_attachments`
--


--
-- Table structure for table `bx_forum_cat`
--

CREATE TABLE `bx_forum_cat` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_name` varchar(255) DEFAULT NULL,
  `cat_icon` varchar(32) NOT NULL DEFAULT '',
  `cat_order` float NOT NULL DEFAULT '0',
  `cat_expanded` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `cat_order` (`cat_order`),
  KEY `cat_uri` (`cat_uri`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_cat`
--

INSERT INTO `bx_forum_cat` VALUES (1,'General','General','',2,0);

--
-- Table structure for table `bx_forum_flag`
--

CREATE TABLE `bx_forum_flag` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `when` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`,`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_flag`
--


--
-- Table structure for table `bx_forum_post`
--

CREATE TABLE `bx_forum_post` (
  `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `user` varchar(32) NOT NULL DEFAULT '0',
  `post_text` mediumtext NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `reports` int(11) NOT NULL DEFAULT '0',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `user` (`user`),
  KEY `when` (`when`),
  FULLTEXT KEY `post_text` (`post_text`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_post`
--

INSERT INTO `bx_forum_post` VALUES (1,1,1,'ericamlee','<p>Test</p>',1445808420,0,0,0);

--
-- Table structure for table `bx_forum_signatures`
--

CREATE TABLE `bx_forum_signatures` (
  `user` varchar(32) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `when` int(11) NOT NULL,
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_signatures`
--


--
-- Table structure for table `bx_forum_topic`
--

CREATE TABLE `bx_forum_topic` (
  `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_uri` varchar(255) NOT NULL DEFAULT '',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `topic_title` varchar(255) NOT NULL DEFAULT '',
  `when` int(11) NOT NULL DEFAULT '0',
  `topic_posts` int(11) NOT NULL DEFAULT '0',
  `first_post_user` varchar(32) NOT NULL DEFAULT '0',
  `first_post_when` int(11) NOT NULL DEFAULT '0',
  `last_post_user` varchar(32) NOT NULL DEFAULT '',
  `last_post_when` int(11) NOT NULL DEFAULT '0',
  `topic_sticky` int(11) NOT NULL DEFAULT '0',
  `topic_locked` tinyint(4) NOT NULL DEFAULT '0',
  `topic_hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `forum_id_2` (`forum_id`,`when`),
  KEY `topic_uri` (`topic_uri`),
  FULLTEXT KEY `topic_title` (`topic_title`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_topic`
--

INSERT INTO `bx_forum_topic` VALUES (1,'First-Topic',1,'First Topic',1445808420,1,'ericamlee',1445808420,'ericamlee',1445808420,0,0,0);

--
-- Table structure for table `bx_forum_user`
--

CREATE TABLE `bx_forum_user` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `user_pwd` varchar(32) NOT NULL DEFAULT '',
  `user_email` varchar(128) NOT NULL DEFAULT '',
  `user_join_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_user`
--


--
-- Table structure for table `bx_forum_user_activity`
--

CREATE TABLE `bx_forum_user_activity` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `act_current` int(11) NOT NULL DEFAULT '0',
  `act_last` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_user_activity`
--

INSERT INTO `bx_forum_user_activity` VALUES ('ericamlee',1459438781,1448835373),('test',1448465135,1447431602),('persister1',1447034484,0);

--
-- Table structure for table `bx_forum_user_stat`
--

CREATE TABLE `bx_forum_user_stat` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `posts` int(11) NOT NULL DEFAULT '0',
  `user_last_post` int(11) NOT NULL DEFAULT '0',
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_user_stat`
--

INSERT INTO `bx_forum_user_stat` VALUES ('ericamlee',1,1445808420);

--
-- Table structure for table `bx_forum_vote`
--

CREATE TABLE `bx_forum_vote` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `post_id` int(11) NOT NULL DEFAULT '0',
  `vote_when` int(11) NOT NULL DEFAULT '0',
  `vote_point` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`,`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_forum_vote`
--


--
-- Table structure for table `bx_groups_admins`
--

CREATE TABLE `bx_groups_admins` (
  `id_entry` int(10) unsigned NOT NULL,
  `id_profile` int(10) unsigned NOT NULL,
  `when` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_entry`,`id_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_admins`
--


--
-- Table structure for table `bx_groups_cmts`
--

CREATE TABLE `bx_groups_cmts` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(12) 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;

--
-- Dumping data for table `bx_groups_cmts`
--


--
-- Table structure for table `bx_groups_cmts_track`
--

CREATE TABLE `bx_groups_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;

--
-- Dumping data for table `bx_groups_cmts_track`
--


--
-- Table structure for table `bx_groups_fans`
--

CREATE TABLE `bx_groups_fans` (
  `id_entry` int(10) unsigned NOT NULL,
  `id_profile` int(10) unsigned NOT NULL,
  `when` int(10) unsigned NOT NULL,
  `confirmed` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_entry`,`id_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_fans`
--


--
-- Table structure for table `bx_groups_files`
--

CREATE TABLE `bx_groups_files` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(11) NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_files`
--


--
-- Table structure for table `bx_groups_forum`
--

CREATE TABLE `bx_groups_forum` (
  `forum_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `forum_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `forum_title` varchar(255) DEFAULT NULL,
  `forum_desc` varchar(255) NOT NULL DEFAULT '',
  `forum_posts` int(11) NOT NULL DEFAULT '0',
  `forum_topics` int(11) NOT NULL DEFAULT '0',
  `forum_last` int(11) NOT NULL DEFAULT '0',
  `forum_type` enum('public','private') NOT NULL DEFAULT 'public',
  `forum_order` int(11) NOT NULL DEFAULT '0',
  `entry_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`forum_id`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_uri` (`forum_uri`),
  KEY `entry_id` (`entry_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum`
--

INSERT INTO `bx_groups_forum` VALUES (1,'Test-Group',1,'Test Group','ericamlee',0,0,1447432018,'public',0,1);

--
-- Table structure for table `bx_groups_forum_actions_log`
--

CREATE TABLE `bx_groups_forum_actions_log` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `id` int(11) NOT NULL DEFAULT '0',
  `action_name` varchar(32) NOT NULL DEFAULT '',
  `action_when` int(11) NOT NULL DEFAULT '0',
  KEY `action_when` (`action_when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_actions_log`
--


--
-- Table structure for table `bx_groups_forum_attachments`
--

CREATE TABLE `bx_groups_forum_attachments` (
  `att_hash` char(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  `att_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `att_when` int(11) NOT NULL,
  `att_size` int(11) NOT NULL,
  `att_downloads` int(11) NOT NULL,
  PRIMARY KEY (`att_hash`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_attachments`
--


--
-- Table structure for table `bx_groups_forum_cat`
--

CREATE TABLE `bx_groups_forum_cat` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_uri` varchar(255) NOT NULL DEFAULT '',
  `cat_name` varchar(255) DEFAULT NULL,
  `cat_icon` varchar(32) NOT NULL DEFAULT '',
  `cat_order` float NOT NULL DEFAULT '0',
  `cat_expanded` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `cat_order` (`cat_order`),
  KEY `cat_uri` (`cat_uri`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_cat`
--

INSERT INTO `bx_groups_forum_cat` VALUES (1,'Groups','Groups','',64,0);

--
-- Table structure for table `bx_groups_forum_flag`
--

CREATE TABLE `bx_groups_forum_flag` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `when` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`,`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_flag`
--


--
-- Table structure for table `bx_groups_forum_post`
--

CREATE TABLE `bx_groups_forum_post` (
  `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `user` varchar(32) NOT NULL DEFAULT '0',
  `post_text` mediumtext NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `reports` int(11) NOT NULL DEFAULT '0',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `user` (`user`),
  KEY `when` (`when`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_post`
--


--
-- Table structure for table `bx_groups_forum_signatures`
--

CREATE TABLE `bx_groups_forum_signatures` (
  `user` varchar(32) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `when` int(11) NOT NULL,
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_signatures`
--


--
-- Table structure for table `bx_groups_forum_topic`
--

CREATE TABLE `bx_groups_forum_topic` (
  `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_uri` varchar(255) NOT NULL DEFAULT '',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `topic_title` varchar(255) NOT NULL DEFAULT '',
  `when` int(11) NOT NULL DEFAULT '0',
  `topic_posts` int(11) NOT NULL DEFAULT '0',
  `first_post_user` varchar(32) NOT NULL DEFAULT '0',
  `first_post_when` int(11) NOT NULL DEFAULT '0',
  `last_post_user` varchar(32) NOT NULL DEFAULT '',
  `last_post_when` int(11) NOT NULL DEFAULT '0',
  `topic_sticky` int(11) NOT NULL DEFAULT '0',
  `topic_locked` tinyint(4) NOT NULL DEFAULT '0',
  `topic_hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `forum_id_2` (`forum_id`,`when`),
  KEY `topic_uri` (`topic_uri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_topic`
--


--
-- Table structure for table `bx_groups_forum_user`
--

CREATE TABLE `bx_groups_forum_user` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `user_pwd` varchar(32) NOT NULL DEFAULT '',
  `user_email` varchar(128) NOT NULL DEFAULT '',
  `user_join_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_user`
--


--
-- Table structure for table `bx_groups_forum_user_activity`
--

CREATE TABLE `bx_groups_forum_user_activity` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `act_current` int(11) NOT NULL DEFAULT '0',
  `act_last` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_user_activity`
--

INSERT INTO `bx_groups_forum_user_activity` VALUES ('ericamlee',1448464449,0);

--
-- Table structure for table `bx_groups_forum_user_stat`
--

CREATE TABLE `bx_groups_forum_user_stat` (
  `user` varchar(32) NOT NULL DEFAULT '',
  `posts` int(11) NOT NULL DEFAULT '0',
  `user_last_post` int(11) NOT NULL DEFAULT '0',
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_user_stat`
--


--
-- Table structure for table `bx_groups_forum_vote`
--

CREATE TABLE `bx_groups_forum_vote` (
  `user_name` varchar(32) NOT NULL DEFAULT '',
  `post_id` int(11) NOT NULL DEFAULT '0',
  `vote_when` int(11) NOT NULL DEFAULT '0',
  `vote_point` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_name`,`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_forum_vote`
--


--
-- Table structure for table `bx_groups_images`
--

CREATE TABLE `bx_groups_images` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_images`
--


--
-- Table structure for table `bx_groups_main`
--

CREATE TABLE `bx_groups_main` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `uri` varchar(255) NOT NULL,
  `desc` text NOT NULL,
  `country` varchar(2) NOT NULL,
  `city` varchar(64) NOT NULL,
  `zip` varchar(16) NOT NULL,
  `status` enum('approved','pending') NOT NULL DEFAULT 'approved',
  `thumb` int(11) NOT NULL,
  `created` int(11) NOT NULL,
  `author_id` int(10) unsigned NOT NULL DEFAULT '0',
  `tags` varchar(255) NOT NULL DEFAULT '',
  `categories` text NOT NULL,
  `views` int(11) NOT NULL,
  `rate` float NOT NULL,
  `rate_count` int(11) NOT NULL,
  `comments_count` int(11) NOT NULL,
  `fans_count` int(11) NOT NULL,
  `featured` tinyint(4) NOT NULL,
  `allow_view_group_to` int(11) NOT NULL,
  `allow_view_fans_to` varchar(16) NOT NULL,
  `allow_comment_to` varchar(16) NOT NULL,
  `allow_rate_to` varchar(16) NOT NULL,
  `allow_post_in_forum_to` varchar(16) NOT NULL,
  `allow_view_forum_to` varchar(16) NOT NULL,
  `allow_join_to` int(11) NOT NULL,
  `join_confirmation` tinyint(4) NOT NULL DEFAULT '0',
  `allow_upload_photos_to` varchar(16) NOT NULL,
  `allow_upload_videos_to` varchar(16) NOT NULL,
  `allow_upload_sounds_to` varchar(16) NOT NULL,
  `allow_upload_files_to` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uri` (`uri`),
  KEY `author_id` (`author_id`),
  KEY `created` (`created`),
  FULLTEXT KEY `search` (`title`,`desc`,`tags`,`categories`),
  FULLTEXT KEY `tags` (`tags`),
  FULLTEXT KEY `categories` (`categories`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_main`
--

INSERT INTO `bx_groups_main` VALUES (1,'Test Group','Test-Group','<p>This group will serve the local community.</p>','US','Amherst','01002','approved',0,1447432018,12,'test','Family & Friends',1,0,0,0,0,0,4,'3','f','f','f','f',3,0,'a','','','');

--
-- Table structure for table `bx_groups_rating`
--

CREATE TABLE `bx_groups_rating` (
  `gal_id` smallint(6) NOT NULL DEFAULT '0',
  `gal_rating_count` int(11) NOT NULL DEFAULT '0',
  `gal_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `gal_id` (`gal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_rating`
--


--
-- Table structure for table `bx_groups_rating_track`
--

CREATE TABLE `bx_groups_rating_track` (
  `gal_id` smallint(6) NOT NULL DEFAULT '0',
  `gal_ip` varchar(20) DEFAULT NULL,
  `gal_date` datetime DEFAULT NULL,
  KEY `gal_ip` (`gal_ip`,`gal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_rating_track`
--


--
-- Table structure for table `bx_groups_shoutbox`
--

CREATE TABLE `bx_groups_shoutbox` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `HandlerID` int(11) NOT NULL,
  `OwnerID` int(11) NOT NULL,
  `Message` blob NOT NULL,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `IP` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `IP` (`IP`),
  KEY `HandlerID` (`HandlerID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bx_groups_shoutbox`
--


--
-- Table structure for table `bx_groups_sounds`
--

CREATE TABLE `bx_groups_sounds` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(11) NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_sounds`
--


--
-- Table structure for table `bx_groups_videos`
--

CREATE TABLE `bx_groups_videos` (
  `entry_id` int(10) unsigned NOT NULL,
  `media_id` int(11) NOT NULL,
  UNIQUE KEY `entry_id` (`entry_id`,`media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_groups_videos`
--


--
-- Table structure for table `bx_groups_views_track`
--

CREATE TABLE `bx_groups_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;

--
-- Dumping data for table `bx_groups_views_track`
--

INSERT INTO `bx_groups_views_track` VALUES (1,12,2923333906,1447432031);

--
-- Table structure for table `bx_news_comments`
--

CREATE TABLE `bx_news_comments` (
  `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;

--
-- Dumping data for table `bx_news_comments`
--


--
-- Table structure for table `bx_news_comments_track`
--

CREATE TABLE `bx_news_comments_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;

--
-- Dumping data for table `bx_news_comments_track`
--


--
-- Table structure for table `bx_news_entries`
--

CREATE TABLE `bx_news_entries` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int(11) unsigned NOT NULL DEFAULT '0',
  `caption` varchar(64) NOT NULL DEFAULT '',
  `snippet` text NOT NULL,
  `content` text NOT NULL,
  `when` int(11) NOT NULL DEFAULT '0',
  `uri` varchar(64) NOT NULL DEFAULT '',
  `tags` varchar(255) NOT NULL DEFAULT '',
  `categories` varchar(255) NOT NULL DEFAULT '',
  `comment` tinyint(4) NOT NULL DEFAULT '0',
  `vote` tinyint(4) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `featured` tinyint(4) NOT NULL DEFAULT '0',
  `rate` int(11) NOT NULL DEFAULT '0',
  `rate_count` int(11) NOT NULL DEFAULT '0',
  `view_count` int(11) NOT NULL DEFAULT '0',
  `cmts_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uri` (`uri`),
  FULLTEXT KEY `search_group` (`caption`,`content`,`tags`,`categories`),
  FULLTEXT KEY `search_caption` (`caption`),
  FULLTEXT KEY `search_content` (`content`),
  FULLTEXT KEY `search_tags` (`tags`),
  FULLTEXT KEY `search_categories` (`categories`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_news_entries`
--


--
-- Table structure for table `bx_news_views_track`
--

CREATE TABLE `bx_news_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;

--
-- Dumping data for table `bx_news_views_track`
--


--
-- Table structure for table `bx_news_voting`
--

CREATE TABLE `bx_news_voting` (
  `news_id` bigint(8) NOT NULL DEFAULT '0',
  `news_rating_count` int(11) NOT NULL DEFAULT '0',
  `news_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `news_id` (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_news_voting`
--


--
-- Table structure for table `bx_news_voting_track`
--

CREATE TABLE `bx_news_voting_track` (
  `news_id` bigint(8) NOT NULL DEFAULT '0',
  `news_ip` varchar(20) DEFAULT NULL,
  `news_date` datetime DEFAULT NULL,
  KEY `news_ip` (`news_ip`,`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_news_voting_track`
--


--
-- Table structure for table `bx_pageac_member_menu_visibility`
--

CREATE TABLE `bx_pageac_member_menu_visibility` (
  `MenuItemID` int(11) NOT NULL,
  `MemLevels` text,
  PRIMARY KEY (`MenuItemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_pageac_member_menu_visibility`
--


--
-- Table structure for table `bx_pageac_page_blocks_visibility`
--

CREATE TABLE `bx_pageac_page_blocks_visibility` (
  `PageBlockID` int(11) NOT NULL,
  `MemLevels` text,
  PRIMARY KEY (`PageBlockID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_pageac_page_blocks_visibility`
--


--
-- Table structure for table `bx_pageac_rules`
--

CREATE TABLE `bx_pageac_rules` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Rule` text NOT NULL,
  `MemLevels` text,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_pageac_rules`
--


--
-- Table structure for table `bx_pageac_top_menu_visibility`
--

CREATE TABLE `bx_pageac_top_menu_visibility` (
  `MenuItemID` int(11) NOT NULL,
  `MemLevels` text,
  PRIMARY KEY (`MenuItemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_pageac_top_menu_visibility`
--


--
-- Table structure for table `bx_photos_cmts`
--

CREATE TABLE `bx_photos_cmts` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(10) unsigned 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;

--
-- Dumping data for table `bx_photos_cmts`
--


--
-- Table structure for table `bx_photos_cmts_albums`
--

CREATE TABLE `bx_photos_cmts_albums` (
  `cmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cmt_parent_id` int(11) NOT NULL DEFAULT '0',
  `cmt_object_id` int(10) unsigned 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;

--
-- Dumping data for table `bx_photos_cmts_albums`
--


--
-- Table structure for table `bx_photos_favorites`
--

CREATE TABLE `bx_photos_favorites` (
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `Profile` int(10) unsigned NOT NULL DEFAULT '0',
  `Date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`Profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_photos_favorites`
--


--
-- Table structure for table `bx_photos_rating`
--

CREATE TABLE `bx_photos_rating` (
  `gal_id` int(10) unsigned NOT NULL DEFAULT '0',
  `gal_rating_count` int(11) NOT NULL DEFAULT '0',
  `gal_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `med_id` (`gal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_photos_rating`
--

INSERT INTO `bx_photos_rating` VALUES (1,1,5),(2,1,5);

--
-- Table structure for table `bx_photos_views_track`
--

CREATE TABLE `bx_photos_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;

--
-- Dumping data for table `bx_photos_views_track`
--

INSERT INTO `bx_photos_views_track` VALUES (1,1,2903073612,1428510862),(4,1,2903073612,1429102806),(4,0,2923395480,1429190386),(1,2,2923395480,1429190452),(4,3,2923395480,1439573948),(10,12,2923333906,1443203682),(11,13,2923333906,1443404013),(12,13,2923333906,1443404115),(13,13,2923333906,1443404252),(4,0,1311682103,1443508481),(11,0,1311682103,1443508509),(10,0,1311682103,1443508524),(1,0,1311682103,1443508559),(2,0,1311682103,1443508695),(11,0,1123631568,1443562754),(1,0,1123631568,1443562764),(4,0,1123631554,1443562779),(10,0,1123631568,1443562939),(2,0,1123631554,1443563038),(1,0,1123632074,1443978766),(10,0,1123635138,1444019689),(11,0,1123635152,1444024236),(4,0,1123635138,1444028793),(2,12,2923333906,1445390798),(14,13,2923333906,1450815866);

--
-- Table structure for table `bx_photos_voting_track`
--

CREATE TABLE `bx_photos_voting_track` (
  `gal_id` int(10) unsigned NOT NULL DEFAULT '0',
  `gal_ip` varchar(20) DEFAULT NULL,
  `gal_date` datetime DEFAULT NULL,
  KEY `med_ip` (`gal_ip`,`gal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_photos_voting_track`
--

INSERT INTO `bx_photos_voting_track` VALUES (1,'162.72.40.61','2015-04-08 16:33:49'),(2,'162.72.40.61','2015-04-08 16:33:56');

--
-- Table structure for table `bx_profile_custom_images`
--

CREATE TABLE `bx_profile_custom_images` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ext` varchar(4) NOT NULL,
  `count` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_profile_custom_images`
--


--
-- Table structure for table `bx_profile_custom_main`
--

CREATE TABLE `bx_profile_custom_main` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `css` text NOT NULL,
  `tmp` text NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_profile_custom_main`
--


--
-- Table structure for table `bx_profile_custom_themes`
--

CREATE TABLE `bx_profile_custom_themes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `ownerid` int(10) NOT NULL,
  `css` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_profile_custom_themes`
--


--
-- Table structure for table `bx_profile_custom_units`
--

CREATE TABLE `bx_profile_custom_units` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `caption` varchar(100) NOT NULL,
  `css_name` varchar(500) NOT NULL,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_profile_custom_units`
--

INSERT INTO `bx_profile_custom_units` VALUES (1,'body','Page background','body','background'),(2,'boxtext','Font for boxes','#divUnderCustomization .disignBoxFirst, #divUnderCustomization .boxFirstHeader, #divUnderCustomization .disignBoxFirst a, #divUnderCustomization .bx-def-font-grayed','font'),(3,'boxborder','Border for boxes','#divUnderCustomization .disignBoxFirst','border');

--
-- Table structure for table `bx_simple_messenger_messages`
--

CREATE TABLE `bx_simple_messenger_messages` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Message` blob NOT NULL,
  `SenderID` int(11) NOT NULL,
  `RecipientID` int(11) NOT NULL,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `SenderStatus` enum('active','close') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `RecipientStatus` enum('active','close') COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `SenderID` (`SenderID`),
  KEY `RecipientID` (`RecipientID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bx_simple_messenger_messages`
--

INSERT INTO `bx_simple_messenger_messages` VALUES (1,'Oh, tell me about it!',2,1,'2015-04-08 16:34:50','active','active'),(2,'Jusrt reading your message to me.',2,1,'2015-04-08 16:35:03','active','active'),(3,'This system is not very intuiive, but does have lots of options.',2,1,'2015-04-08 16:35:37','active','close');

--
-- Table structure for table `bx_simple_messenger_privacy`
--

CREATE TABLE `bx_simple_messenger_privacy` (
  `author_id` int(11) NOT NULL,
  `allow_contact_to` int(11) NOT NULL,
  PRIMARY KEY (`author_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bx_simple_messenger_privacy`
--

INSERT INTO `bx_simple_messenger_privacy` VALUES (17,5);

--
-- Table structure for table `bx_wall_comments`
--

CREATE TABLE `bx_wall_comments` (
  `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 COLLATE utf8_unicode_ci 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 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bx_wall_comments`
--


--
-- Table structure for table `bx_wall_comments_track`
--

CREATE TABLE `bx_wall_comments_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 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bx_wall_comments_track`
--


--
-- Table structure for table `bx_wall_events`
--

CREATE TABLE `bx_wall_events` (
  `id` bigint(8) NOT NULL AUTO_INCREMENT,
  `owner_id` int(10) unsigned NOT NULL DEFAULT '0',
  `object_id` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `reposts` int(11) unsigned NOT NULL DEFAULT '0',
  `date` int(11) unsigned NOT NULL DEFAULT '0',
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `owner_id` (`owner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bx_wall_events`
--

INSERT INTO `bx_wall_events` VALUES (1,1,'2','friend','accept','','seth is now friends with bethany','',0,1428509385,1,0),(2,2,'2','profile','edit_status_message','a:1:{i:0;s:15:\"Is tired today.\";}','bethany changed her profile status message','Is tired today.',0,1428509485,1,0),(3,1,'1','bx_photos','add','a:3:{s:5:\"album\";s:13:\"seth-s-photos\";s:12:\"privacy_view\";s:1:\"3\";s:5:\"idims\";a:1:{i:1;a:2:{s:1:\"w\";i:134;s:1:\"h\";i:140;}}}','seth added new photo','Avatar',0,1428509515,1,0),(6,1,'1','wall_common_text','','<div class=\"wall-post-text bx-def-font-h2\">I just uploaded a new profile photo.  What do you think?</div>','seth wrote','I just uploaded a new profile photo.  What do you think?',0,1428509613,1,0),(7,1,'2','wall_common_text','','<div class=\"wall-post-text bx-def-font-h2\">Cute picture!</div>','bethany wrote','Cute picture!',0,1428509697,1,0),(8,2,'2','profile','edit','a:2:{s:14:\"OldProfileInfo\";a:53:{s:8:\"datafile\";b:1;s:2:\"ID\";s:1:\"2\";s:8:\"NickName\";s:7:\"bethany\";s:5:\"Email\";s:17:\"bethany@seeger.ws\";s:8:\"Password\";s:40:\"c8506e0ed61dc81b4e18d8f7ea4aa394f3f4e1a5\";s:4:\"Salt\";s:8:\"Y,fPE&Fw\";s:6:\"Status\";s:6:\"Active\";s:4:\"Role\";s:1:\"3\";s:6:\"Couple\";s:1:\"0\";s:3:\"Sex\";s:6:\"female\";s:10:\"LookingFor\";s:0:\"\";s:8:\"Headline\";s:8:\"It\'s me!\";s:13:\"DescriptionMe\";s:55:\"Seriously awesome admin. Just entering characters here!\";s:7:\"Country\";s:2:\"US\";s:4:\"City\";s:8:\"Leverett\";s:11:\"DateOfBirth\";s:10:\"1977-03-01\";s:8:\"Featured\";s:1:\"0\";s:7:\"DateReg\";s:19:\"2015-04-08 15:18:45\";s:12:\"DateLastEdit\";s:19:\"0000-00-00 00:00:00\";s:13:\"DateLastLogin\";s:19:\"2015-04-08 15:26:06\";s:11:\"DateLastNav\";s:19:\"2015-04-08 16:11:23\";s:7:\"aff_num\";s:1:\"0\";s:4:\"Tags\";s:0:\"\";s:3:\"zip\";s:5:\"01054\";s:11:\"EmailNotify\";s:1:\"1\";s:6:\"LangID\";s:1:\"1\";s:11:\"UpdateMatch\";s:1:\"0\";s:5:\"Views\";s:1:\"1\";s:4:\"Rate\";s:1:\"0\";s:9:\"RateCount\";s:1:\"0\";s:13:\"CommentsCount\";s:1:\"0\";s:19:\"PrivacyDefaultGroup\";s:1:\"3\";s:13:\"allow_view_to\";s:1:\"3\";s:10:\"UserStatus\";s:6:\"online\";s:17:\"UserStatusMessage\";s:15:\"Is tired today.\";s:21:\"UserStatusMessageWhen\";s:10:\"1428509485\";s:6:\"Avatar\";s:1:\"0\";s:6:\"Height\";s:0:\"\";s:6:\"Weight\";s:0:\"\";s:6:\"Income\";s:0:\"\";s:10:\"Occupation\";s:0:\"\";s:8:\"Religion\";s:0:\"\";s:9:\"Education\";s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";s:7:\"Hobbies\";s:0:\"\";s:9:\"Interests\";s:0:\"\";s:9:\"Ethnicity\";s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";s:9:\"FirstName\";s:7:\"Bethany\";s:8:\"LastName\";s:6:\"Seeger\";}s:7:\"privacy\";i:5;}','bethany edited her profile','',0,1428509798,1,0),(9,2,'2','bx_photos','add','a:3:{s:5:\"album\";s:16:\"bethany-s-photos\";s:12:\"privacy_view\";s:1:\"3\";s:5:\"idims\";a:1:{i:2;a:2:{s:1:\"w\";i:105;s:1:\"h\";i:140;}}}','bethany added new photo','Avatar',0,1428509894,1,0),(12,2,'1','bx_events','add','a:2:{s:6:\"Status\";s:8:\"approved\";s:5:\"idims\";a:1:{i:1;a:2:{s:1:\"w\";i:140;s:1:\"h\";i:105;}}}','bethany added new event','Show up if you can. ',0,1428510258,1,0),(55,17,'17','profile','edit','a:2:{s:14:\"OldProfileInfo\";a:64:{s:2:\"ID\";s:2:\"17\";s:8:\"NickName\";s:10:\"DMKDXWebPi\";s:5:\"Email\";s:21:\"erikamlee23@gmail.com\";s:8:\"Password\";s:40:\"5c3c2896b62aef9867a2bed1b1704e64ec01cb61\";s:4:\"Salt\";s:8:\"MBjtKwt6\";s:6:\"Status\";s:11:\"Unconfirmed\";s:4:\"Role\";s:1:\"1\";s:6:\"Couple\";s:1:\"0\";s:3:\"Sex\";s:0:\"\";s:10:\"LookingFor\";s:0:\"\";s:8:\"Headline\";s:0:\"\";s:13:\"DescriptionMe\";s:0:\"\";s:7:\"Country\";s:2:\"US\";s:4:\"City\";s:0:\"\";s:11:\"DateOfBirth\";s:10:\"0000-00-00\";s:8:\"Featured\";s:1:\"0\";s:7:\"DateReg\";s:19:\"2016-02-26 14:43:53\";s:12:\"DateLastEdit\";s:19:\"0000-00-00 00:00:00\";s:13:\"DateLastLogin\";s:19:\"2016-02-26 14:44:00\";s:11:\"DateLastNav\";s:19:\"2016-02-26 14:54:50\";s:7:\"aff_num\";s:1:\"0\";s:4:\"Tags\";s:0:\"\";s:3:\"zip\";s:0:\"\";s:11:\"EmailNotify\";s:1:\"1\";s:6:\"LangID\";s:1:\"1\";s:11:\"UpdateMatch\";s:1:\"0\";s:5:\"Views\";s:1:\"0\";s:4:\"Rate\";s:1:\"0\";s:9:\"RateCount\";s:1:\"0\";s:13:\"CommentsCount\";s:1:\"0\";s:19:\"PrivacyDefaultGroup\";s:1:\"3\";s:13:\"allow_view_to\";s:1:\"3\";s:10:\"UserStatus\";s:6:\"online\";s:17:\"UserStatusMessage\";s:0:\"\";s:21:\"UserStatusMessageWhen\";s:1:\"0\";s:6:\"Avatar\";s:1:\"0\";s:6:\"Height\";s:0:\"\";s:6:\"Weight\";s:0:\"\";s:6:\"Income\";s:0:\"\";s:10:\"Occupation\";s:0:\"\";s:17:\"SpiritualPractice\";s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";s:7:\"Hobbies\";s:0:\"\";s:9:\"Interests\";s:0:\"\";s:9:\"Ethnicity\";s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";s:8:\"FullName\";s:8:\"Jane Doe\";s:13:\"PoliticalView\";s:0:\"\";s:19:\"InterestsAltHealing\";s:0:\"\";s:12:\"InterestsArt\";s:0:\"\";s:11:\"WomanStatus\";s:12:\"Single Woman\";s:14:\"InterestsBooks\";s:0:\"\";s:22:\"InterestsEntertainment\";s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";s:15:\"InterestsWomens\";s:0:\"\";s:14:\"InterestsMusic\";s:0:\"\";s:9:\"Education\";s:0:\"\";s:9:\"FirstName\";s:0:\"\";s:8:\"LastName\";s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";}s:7:\"privacy\";i:4;}','Jane Doe ','',0,1456516495,1,0),(16,1,'1','bx_events','commentPost','a:2:{s:10:\"comment_id\";i:1;s:17:\"comment_author_id\";i:1;}','seth commented on a event','I don\'t think I\'ve been invited yet.',0,1428510551,1,0),(17,2,'1','bx_events','commentPost','a:2:{s:10:\"comment_id\";i:2;s:17:\"comment_author_id\";i:2;}','bethany commented on a event','did you get one now? \n',0,1428510648,1,0),(18,1,'1','bx_events','commentPost','a:2:{s:10:\"comment_id\";i:3;s:17:\"comment_author_id\";i:1;}','seth commented on a event','Odd.  I got an email about it, but when I log in, there\'s nothing to remind me of it.',0,1428510759,1,0),(19,1,'1','bx_events','commentPost','a:2:{s:10:\"comment_id\";i:4;s:17:\"comment_author_id\";i:1;}','seth commented on a event','I hired some entertainment.  See picture.',0,1428510848,1,0),(20,2,'2','profile','edit_status_message','a:1:{i:0;s:0:\"\";}','bethany changed her profile status message','',0,1428590221,1,0),(21,0,'2','wall_common_text','','<div class=\"wall-post-text bx-def-font-h2\">Testing testing</div>','bethany wrote','Testing testing',0,1428627258,1,0),(22,0,'2','wall_common_text','','<div class=\"wall-post-text bx-def-font-h2\">I am posting to a time line. Mine I think. </div>','bethany wrote','I am posting to a time line. Mine I think. ',0,1428627299,1,0),(23,2,'2','wall_common_text','','<div class=\"wall-post-text bx-def-font-h2\">Posting to timeline</div>','bethany wrote','Posting to timeline',0,1428627354,1,0),(24,0,'2','wall_common_text','','<div class=\"wall-post-text bx-def-font-h2\">Okay, got a home page now. </div>','bethany wrote','Okay, got a home page now. ',0,1428627833,1,0),(25,3,'4','bx_photos','add','a:3:{s:12:\"privacy_view\";s:1:\"3\";s:5:\"album\";s:19:\"persister1-s-photos\";s:5:\"idims\";a:1:{i:4;a:2:{s:1:\"w\";i:117;s:1:\"h\";i:140;}}}','persister1 added new photo','Avatar',0,1428638299,1,0),(28,3,'2','friend','accept','','persister1 is now friends with bethany','',0,1428981820,1,0),(34,12,'12','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:124:{i:0;s:2:\"12\";s:2:\"ID\";s:2:\"12\";i:1;s:9:\"ericamlee\";s:8:\"NickName\";s:9:\"ericamlee\";i:2;s:19:\"bethany+1@seeger.ws\";s:5:\"Email\";s:19:\"bethany+1@seeger.ws\";i:3;s:40:\"a0851f28a8ee50827389d16ab60714a569d7cf69\";s:8:\"Password\";s:40:\"a0851f28a8ee50827389d16ab60714a569d7cf69\";i:4;s:8:\"YTBqZkcC\";s:4:\"Salt\";s:8:\"YTBqZkcC\";i:5;s:8:\"Approval\";s:6:\"Status\";s:8:\"Approval\";i:6;s:1:\"3\";s:4:\"Role\";s:1:\"3\";i:7;s:1:\"0\";s:6:\"Couple\";s:1:\"0\";i:8;s:4:\"male\";s:3:\"Sex\";s:4:\"male\";i:9;s:0:\"\";s:10:\"LookingFor\";s:0:\"\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:0:\"\";s:13:\"DescriptionMe\";s:0:\"\";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:0:\"\";s:4:\"City\";s:0:\"\";i:14;s:10:\"1993-08-18\";s:11:\"DateOfBirth\";s:10:\"1993-08-18\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-08-27 02:07:34\";s:7:\"DateReg\";s:19:\"2015-08-27 02:07:34\";i:17;s:19:\"0000-00-00 00:00:00\";s:12:\"DateLastEdit\";s:19:\"0000-00-00 00:00:00\";i:18;s:19:\"2015-09-02 00:06:12\";s:13:\"DateLastLogin\";s:19:\"2015-09-02 00:06:12\";i:19;s:19:\"2015-09-02 02:05:09\";s:11:\"DateLastNav\";s:19:\"2015-09-02 02:05:09\";i:20;s:1:\"0\";s:7:\"aff_num\";s:1:\"0\";i:21;s:0:\"\";s:4:\"Tags\";s:0:\"\";i:22;s:5:\"01001\";s:3:\"zip\";s:5:\"01001\";i:23;s:1:\"1\";s:11:\"EmailNotify\";s:1:\"1\";i:24;s:1:\"1\";s:6:\"LangID\";s:1:\"1\";i:25;s:1:\"0\";s:11:\"UpdateMatch\";s:1:\"0\";i:26;s:1:\"0\";s:5:\"Views\";s:1:\"0\";i:27;s:1:\"0\";s:4:\"Rate\";s:1:\"0\";i:28;s:1:\"0\";s:9:\"RateCount\";s:1:\"0\";i:29;s:1:\"0\";s:13:\"CommentsCount\";s:1:\"0\";i:30;s:1:\"3\";s:19:\"PrivacyDefaultGroup\";s:1:\"3\";i:31;s:1:\"3\";s:13:\"allow_view_to\";s:1:\"3\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:0:\"\";s:17:\"UserStatusMessage\";s:0:\"\";i:34;s:1:\"0\";s:21:\"UserStatusMessageWhen\";s:1:\"0\";i:35;s:1:\"0\";s:6:\"Avatar\";s:1:\"0\";i:36;s:0:\"\";s:6:\"Height\";s:0:\"\";i:37;s:0:\"\";s:6:\"Weight\";s:0:\"\";i:38;s:0:\"\";s:6:\"Income\";s:0:\"\";i:39;s:0:\"\";s:10:\"Occupation\";s:0:\"\";i:40;s:0:\"\";s:17:\"SpiritualPractice\";s:0:\"\";i:41;s:0:\"\";s:9:\"Education\";s:0:\"\";i:42;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:43;s:0:\"\";s:7:\"Hobbies\";s:0:\"\";i:44;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:45;s:0:\"\";s:9:\"Ethnicity\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:49;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:50;s:4:\"Eric\";s:9:\"FirstName\";s:4:\"Eric\";i:51;s:5:\"Amlee\";s:8:\"LastName\";s:5:\"Amlee\";i:52;s:0:\"\";s:13:\"PoliticalView\";s:0:\"\";i:53;s:0:\"\";s:19:\"InterestsAltHealing\";s:0:\"\";i:54;s:0:\"\";s:12:\"InterestsArt\";s:0:\"\";i:55;s:13:\"Sponsor Woman\";s:11:\"WomanStatus\";s:13:\"Sponsor Woman\";i:56;s:0:\"\";s:14:\"InterestsBooks\";s:0:\"\";i:57;s:0:\"\";s:22:\"InterestsEntertainment\";s:0:\"\";i:58;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:59;s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";i:60;s:0:\"\";s:15:\"InterestsWomens\";s:0:\"\";i:61;s:0:\"\";s:14:\"InterestsMusic\";s:0:\"\";}}','ericamlee edited his profile','',0,1441159516,1,0),(29,1,'3','friend','accept','','seth is now friends with persister1','',0,1429198964,1,0),(30,3,'1','wall_common_text','','<div class=\"wall-post-text bx-def-font-h2\">Yay!  Welcome to Persisters!</div>','seth wrote','Yay!  Welcome to Persisters!',0,1429198976,1,0),(31,2,'2','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:104:{i:0;s:1:\"2\";s:2:\"ID\";s:1:\"2\";i:1;s:7:\"bethany\";s:8:\"NickName\";s:7:\"bethany\";i:2;s:17:\"bethany@seeger.ws\";s:5:\"Email\";s:17:\"bethany@seeger.ws\";i:3;s:40:\"e296af2117c326e802b8387699c2d16b755435d9\";s:8:\"Password\";s:40:\"e296af2117c326e802b8387699c2d16b755435d9\";i:4;s:8:\"MjWKiqPq\";s:4:\"Salt\";s:8:\"MjWKiqPq\";i:5;s:6:\"Active\";s:6:\"Status\";s:6:\"Active\";i:6;s:1:\"3\";s:4:\"Role\";s:1:\"3\";i:7;s:1:\"0\";s:6:\"Couple\";s:1:\"0\";i:8;s:6:\"female\";s:3:\"Sex\";s:6:\"female\";i:9;s:0:\"\";s:10:\"LookingFor\";s:0:\"\";i:10;s:8:\"It\'s me!\";s:8:\"Headline\";s:8:\"It\'s me!\";i:11;s:55:\"Seriously awesome admin. Just entering characters here!\";s:13:\"DescriptionMe\";s:55:\"Seriously awesome admin. Just entering characters here!\";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:8:\"Leverett\";s:4:\"City\";s:8:\"Leverett\";i:14;s:10:\"1977-03-01\";s:11:\"DateOfBirth\";s:10:\"1977-03-01\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-04-08 15:18:45\";s:7:\"DateReg\";s:19:\"2015-04-08 15:18:45\";i:17;s:19:\"0000-00-00 00:00:00\";s:12:\"DateLastEdit\";s:19:\"0000-00-00 00:00:00\";i:18;s:19:\"2015-05-05 01:24:28\";s:13:\"DateLastLogin\";s:19:\"2015-05-05 01:24:28\";i:19;s:19:\"2015-05-05 01:26:08\";s:11:\"DateLastNav\";s:19:\"2015-05-05 01:26:08\";i:20;s:1:\"0\";s:7:\"aff_num\";s:1:\"0\";i:21;s:0:\"\";s:4:\"Tags\";s:0:\"\";i:22;s:5:\"01054\";s:3:\"zip\";s:5:\"01054\";i:23;s:1:\"1\";s:11:\"EmailNotify\";s:1:\"1\";i:24;s:1:\"1\";s:6:\"LangID\";s:1:\"1\";i:25;s:1:\"0\";s:11:\"UpdateMatch\";s:1:\"0\";i:26;s:1:\"1\";s:5:\"Views\";s:1:\"1\";i:27;s:1:\"0\";s:4:\"Rate\";s:1:\"0\";i:28;s:1:\"0\";s:9:\"RateCount\";s:1:\"0\";i:29;s:1:\"0\";s:13:\"CommentsCount\";s:1:\"0\";i:30;s:1:\"3\";s:19:\"PrivacyDefaultGroup\";s:1:\"3\";i:31;s:1:\"5\";s:13:\"allow_view_to\";s:1:\"5\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:0:\"\";s:17:\"UserStatusMessage\";s:0:\"\";i:34;s:10:\"1428590221\";s:21:\"UserStatusMessageWhen\";s:10:\"1428590221\";i:35;s:1:\"2\";s:6:\"Avatar\";s:1:\"2\";i:36;s:0:\"\";s:6:\"Height\";s:0:\"\";i:37;s:0:\"\";s:6:\"Weight\";s:0:\"\";i:38;s:0:\"\";s:6:\"Income\";s:0:\"\";i:39;s:0:\"\";s:10:\"Occupation\";s:0:\"\";i:40;s:0:\"\";s:8:\"Religion\";s:0:\"\";i:41;s:0:\"\";s:9:\"Education\";s:0:\"\";i:42;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:43;s:0:\"\";s:7:\"Hobbies\";s:0:\"\";i:44;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:45;s:0:\"\";s:9:\"Ethnicity\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:49;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:50;s:7:\"Bethany\";s:9:\"FirstName\";s:7:\"Bethany\";i:51;s:6:\"Seeger\";s:8:\"LastName\";s:6:\"Seeger\";}}','bethany edited her profile','',0,1430789169,1,0),(45,12,'13','wall_common_text','','<div class=\"wall-post-text\">hey</div>','test wrote','hey',0,1445391341,1,0),(33,2,'2','bx_events','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','bethany added new event','Test event. Mothers meet.  Etc.',0,1433255749,1,0),(35,12,'12','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:124:{i:0;s:2:\"12\";s:2:\"ID\";s:2:\"12\";i:1;s:9:\"ericamlee\";s:8:\"NickName\";s:9:\"ericamlee\";i:2;s:19:\"erik@yesexactly.com\";s:5:\"Email\";s:19:\"erik@yesexactly.com\";i:3;s:40:\"412dce24cac5edc92b9e882ee55d9f0ec4cb9dd4\";s:8:\"Password\";s:40:\"412dce24cac5edc92b9e882ee55d9f0ec4cb9dd4\";i:4;s:8:\"YTBqZkcC\";s:4:\"Salt\";s:8:\"YTBqZkcC\";i:5;s:8:\"Approval\";s:6:\"Status\";s:8:\"Approval\";i:6;s:1:\"3\";s:4:\"Role\";s:1:\"3\";i:7;s:1:\"0\";s:6:\"Couple\";s:1:\"0\";i:8;s:4:\"male\";s:3:\"Sex\";s:4:\"male\";i:9;s:6:\"female\";s:10:\"LookingFor\";s:6:\"female\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:0:\"\";s:13:\"DescriptionMe\";s:0:\"\";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:7:\"Amherst\";s:4:\"City\";s:7:\"Amherst\";i:14;s:10:\"1966-06-06\";s:11:\"DateOfBirth\";s:10:\"1966-06-06\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-08-27 02:07:34\";s:7:\"DateReg\";s:19:\"2015-08-27 02:07:34\";i:17;s:19:\"2015-09-02 02:05:16\";s:12:\"DateLastEdit\";s:19:\"2015-09-02 02:05:16\";i:18;s:19:\"2015-09-15 20:24:57\";s:13:\"DateLastLogin\";s:19:\"2015-09-15 20:24:57\";i:19;s:19:\"2015-09-15 21:02:25\";s:11:\"DateLastNav\";s:19:\"2015-09-15 21:02:25\";i:20;s:1:\"0\";s:7:\"aff_num\";s:1:\"0\";i:21;s:0:\"\";s:4:\"Tags\";s:0:\"\";i:22;s:5:\"01002\";s:3:\"zip\";s:5:\"01002\";i:23;s:1:\"1\";s:11:\"EmailNotify\";s:1:\"1\";i:24;s:1:\"1\";s:6:\"LangID\";s:1:\"1\";i:25;s:1:\"1\";s:11:\"UpdateMatch\";s:1:\"1\";i:26;s:1:\"0\";s:5:\"Views\";s:1:\"0\";i:27;s:1:\"0\";s:4:\"Rate\";s:1:\"0\";i:28;s:1:\"0\";s:9:\"RateCount\";s:1:\"0\";i:29;s:1:\"0\";s:13:\"CommentsCount\";s:1:\"0\";i:30;s:1:\"3\";s:19:\"PrivacyDefaultGroup\";s:1:\"3\";i:31;s:1:\"3\";s:13:\"allow_view_to\";s:1:\"3\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:0:\"\";s:17:\"UserStatusMessage\";s:0:\"\";i:34;s:1:\"0\";s:21:\"UserStatusMessageWhen\";s:1:\"0\";i:35;s:1:\"0\";s:6:\"Avatar\";s:1:\"0\";i:36;s:0:\"\";s:6:\"Height\";s:0:\"\";i:37;s:0:\"\";s:6:\"Weight\";s:0:\"\";i:38;s:0:\"\";s:6:\"Income\";s:0:\"\";i:39;s:0:\"\";s:10:\"Occupation\";s:0:\"\";i:40;s:0:\"\";s:17:\"SpiritualPractice\";s:0:\"\";i:41;s:0:\"\";s:9:\"Education\";s:0:\"\";i:42;s:6:\"Single\";s:18:\"RelationshipStatus\";s:6:\"Single\";i:43;s:0:\"\";s:7:\"Hobbies\";s:0:\"\";i:44;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:45;s:0:\"\";s:9:\"Ethnicity\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:49;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:50;s:4:\"Erik\";s:9:\"FirstName\";s:4:\"Erik\";i:51;s:5:\"Amlee\";s:8:\"LastName\";s:5:\"Amlee\";i:52;s:0:\"\";s:13:\"PoliticalView\";s:0:\"\";i:53;s:0:\"\";s:19:\"InterestsAltHealing\";s:0:\"\";i:54;s:0:\"\";s:12:\"InterestsArt\";s:0:\"\";i:55;s:13:\"Sponsor Woman\";s:11:\"WomanStatus\";s:13:\"Sponsor Woman\";i:56;s:0:\"\";s:14:\"InterestsBooks\";s:0:\"\";i:57;s:0:\"\";s:22:\"InterestsEntertainment\";s:0:\"\";i:58;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:59;s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";i:60;s:0:\"\";s:15:\"InterestsWomens\";s:0:\"\";i:61;s:0:\"\";s:14:\"InterestsMusic\";s:0:\"\";}}','ericamlee edited his profile','',0,1442350974,1,0),(36,12,'10','bx_photos','add','a:3:{s:5:\"album\";s:18:\"ericamlee-s-photos\";s:12:\"privacy_view\";s:1:\"3\";s:5:\"idims\";a:1:{i:10;a:2:{s:1:\"w\";i:140;s:1:\"h\";i:140;}}}','ericamlee added new photo','',0,1442351179,1,0),(37,12,'12','profile','edit_status_message','a:1:{i:0;s:2:\"Yo\";}','ericamlee changed his profile status message','Yo',0,1442351288,1,0),(44,13,'12','friend','accept','','test is now friends with ericamlee','',0,1445391328,1,0),(42,12,'2','ads','create','','ericamlee added new ad','ericamlee added new ad',0,1445390442,1,0),(43,12,'3','bx_events','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','ericamlee added new event','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sollicitudin cursus viverra. Phasellus consequat ligula malesuada consectetur lobortis. In hac habitasse platea dictumst. Mauris ac porttitor odio, ac pretium arcu. Aenean finibus eget odio et hendrerit. Mauris pretium odio in elit sodales, quis posuere lorem vestibulum. Aliquam tincidunt leo nec blandit accumsan. Proin fringilla quam tellus, eu posuere elit placerat at. Nam sit amet iaculis ipsum, vitae dictum nulla. In pretium placerat faucibus. Donec nec nulla sit amet urna placerat bibendum id ut tellus. Aenean lobortis sollicitudin turpis, in sodales orci. Pellentesque sit amet faucibus ligula. Aliquam porttitor semper lorem vitae vestibulum.',0,1445390725,1,0),(39,13,'13','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:122:{i:0;s:2:\"13\";s:2:\"ID\";s:2:\"13\";i:1;s:4:\"test\";s:8:\"NickName\";s:4:\"test\";i:2;s:19:\"test@persisters.com\";s:5:\"Email\";s:19:\"test@persisters.com\";i:3;s:40:\"c7f7687f9533d9dcdf6a6332d362d850fa9e2ec4\";s:8:\"Password\";s:40:\"c7f7687f9533d9dcdf6a6332d362d850fa9e2ec4\";i:4;s:8:\"RW.gvwMR\";s:4:\"Salt\";s:8:\"RW.gvwMR\";i:5;s:6:\"Active\";s:6:\"Status\";s:6:\"Active\";i:6;s:1:\"1\";s:4:\"Role\";s:1:\"1\";i:7;s:1:\"0\";s:6:\"Couple\";s:1:\"0\";i:8;s:4:\"male\";s:3:\"Sex\";s:4:\"male\";i:9;s:0:\"\";s:10:\"LookingFor\";s:0:\"\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:4:\"Test\";s:13:\"DescriptionMe\";s:4:\"Test\";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:11:\"Springfield\";s:4:\"City\";s:11:\"Springfield\";i:14;s:10:\"1993-09-07\";s:11:\"DateOfBirth\";s:10:\"1993-09-07\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-09-21 21:26:28\";s:7:\"DateReg\";s:19:\"2015-09-21 21:26:28\";i:17;s:19:\"2015-09-28 01:25:21\";s:12:\"DateLastEdit\";s:19:\"2015-09-28 01:25:21\";i:18;s:19:\"2015-09-28 01:31:43\";s:13:\"DateLastLogin\";s:19:\"2015-09-28 01:31:43\";i:19;s:19:\"2015-09-28 01:36:40\";s:11:\"DateLastNav\";s:19:\"2015-09-28 01:36:40\";i:20;s:1:\"0\";s:7:\"aff_num\";s:1:\"0\";i:21;s:0:\"\";s:4:\"Tags\";s:0:\"\";i:22;s:5:\"01002\";s:3:\"zip\";s:5:\"01002\";i:23;s:1:\"0\";s:11:\"EmailNotify\";s:1:\"0\";i:24;s:1:\"1\";s:6:\"LangID\";s:1:\"1\";i:25;s:1:\"1\";s:11:\"UpdateMatch\";s:1:\"1\";i:26;s:1:\"0\";s:5:\"Views\";s:1:\"0\";i:27;s:1:\"0\";s:4:\"Rate\";s:1:\"0\";i:28;s:1:\"0\";s:9:\"RateCount\";s:1:\"0\";i:29;s:1:\"0\";s:13:\"CommentsCount\";s:1:\"0\";i:30;s:1:\"3\";s:19:\"PrivacyDefaultGroup\";s:1:\"3\";i:31;s:1:\"3\";s:13:\"allow_view_to\";s:1:\"3\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:0:\"\";s:17:\"UserStatusMessage\";s:0:\"\";i:34;s:1:\"0\";s:21:\"UserStatusMessageWhen\";s:1:\"0\";i:35;s:1:\"0\";s:6:\"Avatar\";s:1:\"0\";i:36;s:0:\"\";s:6:\"Height\";s:0:\"\";i:37;s:0:\"\";s:6:\"Weight\";s:0:\"\";i:38;s:0:\"\";s:6:\"Income\";s:0:\"\";i:39;s:0:\"\";s:10:\"Occupation\";s:0:\"\";i:40;s:8:\"Agnostic\";s:17:\"SpiritualPractice\";s:8:\"Agnostic\";i:41;s:17:\"Elementary School\";s:9:\"Education\";s:17:\"Elementary School\";i:42;s:6:\"Single\";s:18:\"RelationshipStatus\";s:6:\"Single\";i:43;s:18:\"Alternative Health\";s:7:\"Hobbies\";s:18:\"Alternative Health\";i:44;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:45;s:5:\"Asian\";s:9:\"Ethnicity\";s:5:\"Asian\";i:46;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:49;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:50;s:9:\"Test Test\";s:8:\"FullName\";s:9:\"Test Test\";i:51;s:18:\"Ultra Conservative\";s:13:\"PoliticalView\";s:18:\"Ultra Conservative\";i:52;s:11:\"Acupuncture\";s:19:\"InterestsAltHealing\";s:11:\"Acupuncture\";i:53;s:6:\"Crafts\";s:12:\"InterestsArt\";s:6:\"Crafts\";i:54;s:12:\"Single Woman\";s:11:\"WomanStatus\";s:12:\"Single Woman\";i:55;s:6:\"Comedy\";s:14:\"InterestsBooks\";s:6:\"Comedy\";i:56;s:7:\"Animals\";s:22:\"InterestsEntertainment\";s:7:\"Animals\";i:57;s:7:\"Fashion\";s:16:\"InterestsGeneral\";s:7:\"Fashion\";i:58;s:8:\"Aerobics\";s:15:\"InterestsSports\";s:8:\"Aerobics\";i:59;s:0:\"\";s:15:\"InterestsWomens\";s:0:\"\";i:60;s:5:\"Banjo\";s:14:\"InterestsMusic\";s:5:\"Banjo\";}}','test edited his profile','',0,1443404228,1,0),(40,13,'13','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:124:{i:0;s:2:\"13\";s:2:\"ID\";s:2:\"13\";i:1;s:4:\"test\";s:8:\"NickName\";s:4:\"test\";i:2;s:19:\"test@persisters.com\";s:5:\"Email\";s:19:\"test@persisters.com\";i:3;s:40:\"c7f7687f9533d9dcdf6a6332d362d850fa9e2ec4\";s:8:\"Password\";s:40:\"c7f7687f9533d9dcdf6a6332d362d850fa9e2ec4\";i:4;s:8:\"RW.gvwMR\";s:4:\"Salt\";s:8:\"RW.gvwMR\";i:5;s:6:\"Active\";s:6:\"Status\";s:6:\"Active\";i:6;s:1:\"1\";s:4:\"Role\";s:1:\"1\";i:7;s:1:\"0\";s:6:\"Couple\";s:1:\"0\";i:8;s:4:\"male\";s:3:\"Sex\";s:4:\"male\";i:9;s:0:\"\";s:10:\"LookingFor\";s:0:\"\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:4:\"Test\";s:13:\"DescriptionMe\";s:4:\"Test\";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:11:\"Springfield\";s:4:\"City\";s:11:\"Springfield\";i:14;s:10:\"1993-09-07\";s:11:\"DateOfBirth\";s:10:\"1993-09-07\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-09-21 21:26:28\";s:7:\"DateReg\";s:19:\"2015-09-21 21:26:28\";i:17;s:19:\"2015-09-28 01:37:08\";s:12:\"DateLastEdit\";s:19:\"2015-09-28 01:37:08\";i:18;s:19:\"2015-10-09 20:59:45\";s:13:\"DateLastLogin\";s:19:\"2015-10-09 20:59:45\";i:19;s:19:\"2015-10-12 18:19:57\";s:11:\"DateLastNav\";s:19:\"2015-10-12 18:19:57\";i:20;s:1:\"0\";s:7:\"aff_num\";s:1:\"0\";i:21;s:0:\"\";s:4:\"Tags\";s:0:\"\";i:22;s:5:\"01002\";s:3:\"zip\";s:5:\"01002\";i:23;s:1:\"0\";s:11:\"EmailNotify\";s:1:\"0\";i:24;s:1:\"1\";s:6:\"LangID\";s:1:\"1\";i:25;s:1:\"1\";s:11:\"UpdateMatch\";s:1:\"1\";i:26;s:1:\"3\";s:5:\"Views\";s:1:\"3\";i:27;s:1:\"0\";s:4:\"Rate\";s:1:\"0\";i:28;s:1:\"0\";s:9:\"RateCount\";s:1:\"0\";i:29;s:1:\"0\";s:13:\"CommentsCount\";s:1:\"0\";i:30;s:1:\"3\";s:19:\"PrivacyDefaultGroup\";s:1:\"3\";i:31;s:1:\"3\";s:13:\"allow_view_to\";s:1:\"3\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:0:\"\";s:17:\"UserStatusMessage\";s:0:\"\";i:34;s:1:\"0\";s:21:\"UserStatusMessageWhen\";s:1:\"0\";i:35;s:1:\"0\";s:6:\"Avatar\";s:1:\"0\";i:36;s:0:\"\";s:6:\"Height\";s:0:\"\";i:37;s:0:\"\";s:6:\"Weight\";s:0:\"\";i:38;s:0:\"\";s:6:\"Income\";s:0:\"\";i:39;s:0:\"\";s:10:\"Occupation\";s:0:\"\";i:40;s:8:\"Agnostic\";s:17:\"SpiritualPractice\";s:8:\"Agnostic\";i:41;s:9:\"Post Doc.\";s:9:\"Education\";s:9:\"Post Doc.\";i:42;s:6:\"Single\";s:18:\"RelationshipStatus\";s:6:\"Single\";i:43;s:18:\"Alternative Health\";s:7:\"Hobbies\";s:18:\"Alternative Health\";i:44;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:45;s:5:\"Asian\";s:9:\"Ethnicity\";s:5:\"Asian\";i:46;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:49;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:50;s:9:\"Test Test\";s:8:\"FullName\";s:9:\"Test Test\";i:51;s:18:\"Ultra Conservative\";s:13:\"PoliticalView\";s:18:\"Ultra Conservative\";i:52;s:11:\"Acupuncture\";s:19:\"InterestsAltHealing\";s:11:\"Acupuncture\";i:53;s:6:\"Crafts\";s:12:\"InterestsArt\";s:6:\"Crafts\";i:54;s:12:\"Single Woman\";s:11:\"WomanStatus\";s:12:\"Single Woman\";i:55;s:6:\"Comedy\";s:14:\"InterestsBooks\";s:6:\"Comedy\";i:56;s:7:\"Animals\";s:22:\"InterestsEntertainment\";s:7:\"Animals\";i:57;s:7:\"Fashion\";s:16:\"InterestsGeneral\";s:7:\"Fashion\";i:58;s:8:\"Aerobics\";s:15:\"InterestsSports\";s:8:\"Aerobics\";i:59;s:0:\"\";s:15:\"InterestsWomens\";s:0:\"\";i:60;s:10:\"Bongo Drum\";s:14:\"InterestsMusic\";s:10:\"Bongo Drum\";i:61;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";}}','test edited his profile','',0,1444674020,1,0),(41,12,'12','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:124:{i:0;s:2:\"12\";s:2:\"ID\";s:2:\"12\";i:1;s:9:\"ericamlee\";s:8:\"NickName\";s:9:\"ericamlee\";i:2;s:19:\"erik@yesexactly.com\";s:5:\"Email\";s:19:\"erik@yesexactly.com\";i:3;s:40:\"412dce24cac5edc92b9e882ee55d9f0ec4cb9dd4\";s:8:\"Password\";s:40:\"412dce24cac5edc92b9e882ee55d9f0ec4cb9dd4\";i:4;s:8:\"YTBqZkcC\";s:4:\"Salt\";s:8:\"YTBqZkcC\";i:5;s:6:\"Active\";s:6:\"Status\";s:6:\"Active\";i:6;s:1:\"3\";s:4:\"Role\";s:1:\"3\";i:7;s:1:\"0\";s:6:\"Couple\";s:1:\"0\";i:8;s:4:\"male\";s:3:\"Sex\";s:4:\"male\";i:9;s:6:\"female\";s:10:\"LookingFor\";s:6:\"female\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:0:\"\";s:13:\"DescriptionMe\";s:0:\"\";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:7:\"Amherst\";s:4:\"City\";s:7:\"Amherst\";i:14;s:10:\"1966-06-06\";s:11:\"DateOfBirth\";s:10:\"1966-06-06\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-08-27 02:07:34\";s:7:\"DateReg\";s:19:\"2015-08-27 02:07:34\";i:17;s:19:\"2015-09-15 21:02:54\";s:12:\"DateLastEdit\";s:19:\"2015-09-15 21:02:54\";i:18;s:19:\"2015-10-12 18:41:33\";s:13:\"DateLastLogin\";s:19:\"2015-10-12 18:41:33\";i:19;s:19:\"2015-10-12 18:56:04\";s:11:\"DateLastNav\";s:19:\"2015-10-12 18:56:04\";i:20;s:1:\"0\";s:7:\"aff_num\";s:1:\"0\";i:21;s:0:\"\";s:4:\"Tags\";s:0:\"\";i:22;s:5:\"01002\";s:3:\"zip\";s:5:\"01002\";i:23;s:1:\"1\";s:11:\"EmailNotify\";s:1:\"1\";i:24;s:1:\"1\";s:6:\"LangID\";s:1:\"1\";i:25;s:1:\"1\";s:11:\"UpdateMatch\";s:1:\"1\";i:26;s:1:\"4\";s:5:\"Views\";s:1:\"4\";i:27;s:1:\"0\";s:4:\"Rate\";s:1:\"0\";i:28;s:1:\"0\";s:9:\"RateCount\";s:1:\"0\";i:29;s:1:\"0\";s:13:\"CommentsCount\";s:1:\"0\";i:30;s:1:\"3\";s:19:\"PrivacyDefaultGroup\";s:1:\"3\";i:31;s:1:\"3\";s:13:\"allow_view_to\";s:1:\"3\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:2:\"Yo\";s:17:\"UserStatusMessage\";s:2:\"Yo\";i:34;s:10:\"1442351288\";s:21:\"UserStatusMessageWhen\";s:10:\"1442351288\";i:35;s:1:\"0\";s:6:\"Avatar\";s:1:\"0\";i:36;s:0:\"\";s:6:\"Height\";s:0:\"\";i:37;s:0:\"\";s:6:\"Weight\";s:0:\"\";i:38;s:0:\"\";s:6:\"Income\";s:0:\"\";i:39;s:0:\"\";s:10:\"Occupation\";s:0:\"\";i:40;s:0:\"\";s:17:\"SpiritualPractice\";s:0:\"\";i:41;s:0:\"\";s:9:\"Education\";s:0:\"\";i:42;s:6:\"Single\";s:18:\"RelationshipStatus\";s:6:\"Single\";i:43;s:0:\"\";s:7:\"Hobbies\";s:0:\"\";i:44;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:45;s:0:\"\";s:9:\"Ethnicity\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:49;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:50;s:10:\"Erik Amlee\";s:8:\"FullName\";s:10:\"Erik Amlee\";i:51;s:0:\"\";s:13:\"PoliticalView\";s:0:\"\";i:52;s:0:\"\";s:19:\"InterestsAltHealing\";s:0:\"\";i:53;s:0:\"\";s:12:\"InterestsArt\";s:0:\"\";i:54;s:13:\"Sponsor Woman\";s:11:\"WomanStatus\";s:13:\"Sponsor Woman\";i:55;s:0:\"\";s:14:\"InterestsBooks\";s:0:\"\";i:56;s:0:\"\";s:22:\"InterestsEntertainment\";s:0:\"\";i:57;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:58;s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";i:59;s:0:\"\";s:15:\"InterestsWomens\";s:0:\"\";i:60;s:0:\"\";s:14:\"InterestsMusic\";s:0:\"\";i:61;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";}}','ericamlee edited his profile','',0,1444676177,1,0),(46,12,'13','wall_common_text','','<div class=\"wall-post-text\">hey</div>','test wrote','hey',0,1445391392,1,0),(48,12,'1','bx_groups','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','ericamlee added new group','This group will serve the local community.',0,1447432018,1,0),(49,12,'12','profile','edit_status_message','a:1:{i:0;s:14:\"It\\\'s Tuesday!\";}','ericamlee changed his profile status message','It\'s Tuesday!',0,1448463611,1,0),(50,12,'12','wall_common_text','','<div class=\"wall-post-text\">This is a post!</div>','ericamlee wrote','This is a post!',0,1448464037,1,0),(51,12,'12','profile','edit_status_message','a:1:{i:0;s:6:\"Status\";}','ericamlee changed his profile status message','Status',0,1448464052,1,0),(52,12,'12','profile','edit_status_message','a:1:{i:0;s:9:\"I\\\'m home\";}','ericamlee changed his profile status message','I\'m home',0,1448464135,1,0),(53,13,'14,15','bx_photos','add','a:3:{s:5:\"album\";s:13:\"test-s-photos\";s:12:\"privacy_view\";s:1:\"3\";s:5:\"idims\";a:2:{i:14;a:2:{s:1:\"w\";i:240;s:1:\"h\";i:240;}i:15;a:2:{s:1:\"w\";i:240;s:1:\"h\";i:240;}}}','test added 2 new photos to album','',0,1450816542,1,0),(56,3,'3','profile','edit_status_message','a:1:{i:0;s:38:\"wondering if this works. Cold outside \";}','Monique Hillen changed her profile status message','wondering if this works. Cold outside ',0,1456942976,1,0);

--
-- Table structure for table `bx_wall_handlers`
--

CREATE TABLE `bx_wall_handlers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alert_unit` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `alert_action` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `module_uri` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `module_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `module_method` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `groupable` tinyint(1) NOT NULL DEFAULT '0',
  `group_by` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `timeline` tinyint(1) NOT NULL DEFAULT '1',
  `outline` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `handler` (`alert_unit`,`alert_action`,`module_uri`,`module_class`,`module_method`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bx_wall_handlers`
--

INSERT INTO `bx_wall_handlers` VALUES (1,'wall_common_text','','','','',0,'',1,0),(2,'wall_common_link','','','','',0,'',1,0),(3,'wall_common_photos','','','','',0,'',1,0),(4,'wall_common_sounds','','','','',0,'',1,0),(5,'wall_common_videos','','','','',0,'',1,0),(6,'profile','edit','','','',0,'',1,0),(7,'profile','edit_status_message','','','',0,'',1,0),(8,'profile','commentPost','','','',0,'',1,0),(9,'profile','delete','','','',0,'',1,0),(10,'friend','accept','','','',0,'',1,0),(13,'bx_events','add','events','Module','get_wall_post',0,'',1,1),(14,'bx_events','commentPost','events','Module','get_wall_post_comment',0,'',1,0),(15,'bx_photos','add','photos','Search','get_wall_post',1,'album',1,1),(16,'bx_photos','commentPost','photos','Search','get_wall_post_comment',0,'',1,0),(26,'bx_groups','commentPost','groups','Module','get_wall_post_comment',0,'',1,0),(25,'bx_groups','add','groups','Module','get_wall_post',0,'',1,1),(21,'ads','create','ads','Module','get_wall_post',0,'',1,1),(22,'ads','commentPost','ads','Module','get_wall_post_comment',0,'',1,0),(23,'bx_avatar','add','avatar','Module','get_wall_post',0,'',1,0),(24,'bx_avatar','change','avatar','Module','get_wall_post',0,'',1,0),(27,'wall_common_repost','','','','',0,'',1,0),(28,'profile','comment_add','','','',0,'',1,0),(29,'comment','add','','','',0,'',0,0);

--
-- Table structure for table `bx_wall_repost_track`
--

CREATE TABLE `bx_wall_repost_track` (
  `event_id` int(11) NOT NULL DEFAULT '0',
  `author_id` int(11) NOT NULL DEFAULT '0',
  `author_nip` int(11) unsigned NOT NULL DEFAULT '0',
  `reposted_id` int(11) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `event_id` (`event_id`),
  KEY `repost` (`reposted_id`,`author_nip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_wall_repost_track`
--


--
-- Table structure for table `bx_wall_voting`
--

CREATE TABLE `bx_wall_voting` (
  `wall_id` bigint(8) NOT NULL DEFAULT '0',
  `wall_rating_count` int(11) NOT NULL DEFAULT '0',
  `wall_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `wall_id` (`wall_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_wall_voting`
--


--
-- Table structure for table `bx_wall_voting_track`
--

CREATE TABLE `bx_wall_voting_track` (
  `wall_id` bigint(8) NOT NULL DEFAULT '0',
  `wall_ip` varchar(20) DEFAULT NULL,
  `wall_date` datetime DEFAULT NULL,
  KEY `wall_ip` (`wall_ip`,`wall_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_wall_voting_track`
--


--
-- Table structure for table `bx_zip_countries_geonames`
--

CREATE TABLE `bx_zip_countries_geonames` (
  `ISO2` varchar(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`ISO2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_zip_countries_geonames`
--


--
-- Table structure for table `bx_zip_countries_google`
--

CREATE TABLE `bx_zip_countries_google` (
  `ISO2` varchar(2) NOT NULL DEFAULT '',
  PRIMARY KEY (`ISO2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_zip_countries_google`
--

INSERT INTO `bx_zip_countries_google` VALUES ('AR'),('AT'),('AU'),('BB'),('BE'),('BR'),('CA'),('CH'),('CL'),('CN'),('CZ'),('DE'),('DK'),('EE'),('EG'),('ES'),('FI'),('FR'),('GB'),('HK'),('HR'),('HU'),('IL'),('IN'),('IT'),('JP'),('KR'),('LI'),('LT'),('LU'),('LV'),('MO'),('MY'),('NL'),('NO'),('NZ'),('PL'),('PT'),('RU'),('SE'),('SG'),('SI'),('SK'),('TW'),('US');

--
-- 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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_account_custom_stat_elements`
--

INSERT INTO `sys_account_custom_stat_elements` VALUES (1,'_bx_events','__bx_events__ (<a href=\"modules/?r=events/browse/my&bx_events_filter=add_event\">__l_add__</a>)'),(2,'_bx_photos','__phs__ (<a href=\"modules/?r=photos/albums/my/main/\">__l_add__</a>)'),(7,'_bx_groups','__bx_groups__ (<a href=\"modules/?r=groups/browse/my&bx_groups_filter=add_group\">__l_add__</a>)'),(5,'_bx_ads_Ads','__mad__ (<a href=\"__site_url__ads/my_page/add/\">__l_add__</a>)'),(6,'_bx_forums','__mop__ (<a href=\"__site_url__forum/\">__l_add__</a>)');

--
-- 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 AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

--
-- 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),(15,'events view',NULL),(16,'events browse',NULL),(17,'events search',NULL),(18,'events add',NULL),(19,'events comments delete and edit',NULL),(20,'events edit any event',NULL),(21,'events delete any event',NULL),(22,'events mark as featured',NULL),(23,'events approve',NULL),(24,'events broadcast message',NULL),(25,'timeline post comment',''),(26,'timeline delete comment',''),(27,'photos view',NULL),(28,'photos add',NULL),(29,'photos delete',NULL),(30,'photos approve',NULL),(31,'photos edit',NULL),(32,'Feedback Delete',''),(33,'News Delete',''),(69,'groups view group',NULL),(35,'use simple messenger',NULL),(44,'ads view',NULL),(45,'ads browse',NULL),(46,'ads search',NULL),(47,'ads add',NULL),(48,'ads edit any ad',NULL),(49,'ads delete any ad',NULL),(50,'ads approving',NULL),(51,'forum public read',NULL),(52,'forum public post',NULL),(53,'forum private read',NULL),(54,'forum private post',NULL),(55,'forum search',NULL),(56,'forum files download',NULL),(57,'forum edit all',NULL),(58,'forum delete all',NULL),(59,'forum make sticky',NULL),(60,'forum del topics',NULL),(61,'forum move topics',NULL),(62,'forum hide topics',NULL),(63,'forum unhide topics',NULL),(64,'forum hide posts',NULL),(65,'forum unhide posts',NULL),(66,'avatar upload',NULL),(67,'avatar edit any',NULL),(68,'avatar delete any',NULL),(70,'groups browse',NULL),(71,'groups search',NULL),(72,'groups add group',NULL),(73,'groups comments delete and edit',NULL),(74,'groups edit any group',NULL),(75,'groups delete any group',NULL),(76,'groups mark as featured',NULL),(77,'groups approve groups',NULL),(78,'groups broadcast message',NULL),(79,'timeline repost','');

--
-- 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;

--
-- Dumping data for table `sys_acl_actions_track`
--

INSERT INTO `sys_acl_actions_track` VALUES (1,1,4,'2015-05-05 01:21:51'),(1,2,4,'2015-06-10 00:38:01'),(4,2,9,'2015-04-08 16:08:21'),(4,1,9,'2015-04-08 16:27:43'),(1,3,4,'2016-03-02 13:31:00'),(1,12,4,'2016-03-31 11:32:23'),(4,12,10,'2015-11-25 14:50:09'),(1,13,4,'2016-01-18 16:19:56');

--
-- 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;

--
-- Dumping data for table `sys_acl_level_prices`
--


--
-- 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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- 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;

--
-- Dumping data for table `sys_acl_levels_members`
--


--
-- 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),(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),(1,13,NULL,NULL,NULL,NULL,NULL),(2,13,NULL,NULL,NULL,NULL,NULL),(3,13,NULL,NULL,NULL,NULL,NULL),(1,14,NULL,NULL,NULL,NULL,NULL),(2,14,NULL,NULL,NULL,NULL,NULL),(3,14,NULL,NULL,NULL,NULL,NULL),(1,15,NULL,NULL,NULL,NULL,NULL),(2,15,NULL,NULL,NULL,NULL,NULL),(3,15,NULL,NULL,NULL,NULL,NULL),(1,16,NULL,NULL,NULL,NULL,NULL),(2,16,NULL,NULL,NULL,NULL,NULL),(3,16,NULL,NULL,NULL,NULL,NULL),(1,17,NULL,NULL,NULL,NULL,NULL),(2,17,NULL,NULL,NULL,NULL,NULL),(3,17,NULL,NULL,NULL,NULL,NULL),(2,18,NULL,NULL,NULL,NULL,NULL),(3,18,NULL,NULL,NULL,NULL,NULL),(2,25,NULL,NULL,NULL,NULL,NULL),(3,25,NULL,NULL,NULL,NULL,NULL),(1,27,NULL,NULL,NULL,NULL,NULL),(2,27,NULL,NULL,NULL,NULL,NULL),(3,27,NULL,NULL,NULL,NULL,NULL),(2,28,NULL,NULL,NULL,NULL,NULL),(3,28,NULL,NULL,NULL,NULL,NULL),(2,69,NULL,NULL,NULL,NULL,NULL),(1,69,NULL,NULL,NULL,NULL,NULL),(2,35,NULL,NULL,NULL,NULL,NULL),(3,35,NULL,NULL,NULL,NULL,NULL),(2,39,NULL,NULL,NULL,NULL,NULL),(3,39,NULL,NULL,NULL,NULL,NULL),(1,44,NULL,NULL,NULL,NULL,NULL),(2,44,NULL,NULL,NULL,NULL,NULL),(3,44,NULL,NULL,NULL,NULL,NULL),(1,45,NULL,NULL,NULL,NULL,NULL),(2,45,NULL,NULL,NULL,NULL,NULL),(3,45,NULL,NULL,NULL,NULL,NULL),(1,46,NULL,NULL,NULL,NULL,NULL),(2,46,NULL,NULL,NULL,NULL,NULL),(3,46,NULL,NULL,NULL,NULL,NULL),(2,47,NULL,NULL,NULL,NULL,NULL),(3,47,NULL,NULL,NULL,NULL,NULL),(1,51,NULL,NULL,NULL,NULL,NULL),(2,51,NULL,NULL,NULL,NULL,NULL),(3,51,NULL,NULL,NULL,NULL,NULL),(2,52,NULL,NULL,NULL,NULL,NULL),(3,52,NULL,NULL,NULL,NULL,NULL),(3,53,NULL,NULL,NULL,NULL,NULL),(3,54,NULL,NULL,NULL,NULL,NULL),(1,55,NULL,NULL,NULL,NULL,NULL),(2,55,NULL,NULL,NULL,NULL,NULL),(3,55,NULL,NULL,NULL,NULL,NULL),(2,56,NULL,NULL,NULL,NULL,NULL),(3,56,NULL,NULL,NULL,NULL,NULL),(2,66,NULL,NULL,NULL,NULL,NULL),(3,66,NULL,NULL,NULL,NULL,NULL),(3,69,NULL,NULL,NULL,NULL,NULL),(1,70,NULL,NULL,NULL,NULL,NULL),(2,70,NULL,NULL,NULL,NULL,NULL),(3,70,NULL,NULL,NULL,NULL,NULL),(1,71,NULL,NULL,NULL,NULL,NULL),(2,71,NULL,NULL,NULL,NULL,NULL),(3,71,NULL,NULL,NULL,NULL,NULL),(2,72,NULL,NULL,NULL,NULL,NULL),(3,72,NULL,NULL,NULL,NULL,NULL),(2,79,NULL,NULL,NULL,NULL,NULL),(3,79,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;

--
-- Dumping data for table `sys_admin_ban_list`
--


--
-- 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 AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_albums`
--

INSERT INTO `sys_albums` VALUES (1,'bethany\'s photos','bethany-s-photos','Undefined','','bx_photos',2,'active',1428509413,1,2,3),(2,'seth\'s photos','seth-s-photos','Undefined','','bx_photos',1,'active',1428509514,1,1,3),(3,'Hidden','Hidden','Undefined','','bx_photos',1,'active',1428510828,1,3,8),(4,'persister1\'s photos','persister1-s-photos','Undefined','','bx_photos',3,'active',1428638299,1,4,3),(8,'Kalamoma\'s photos','Kalamoma-s-photos','Undefined','','bx_photos',7,'active',1433169172,0,0,3),(9,'Founder\'s photos','Founder-s-photos','Undefined','','bx_photos',8,'active',1433201166,0,0,3),(13,'test\'s photos','test-s-photos','Undefined','','bx_photos',13,'active',1442871438,2,15,3),(12,'ericamlee\'s photos','ericamlee-s-photos','Undefined','','bx_photos',12,'active',1442344441,1,10,3),(14,'ericamlee\'s cover photos','ericamlee-s-cover-photos','Undefined','','bx_photos',12,'active',1443212884,0,0,3),(15,'test\'s cover photos','test-s-cover-photos','Undefined','','bx_photos',13,'active',1443403910,1,11,3),(16,'persister1\'s cover photos','persister1-s-cover-photos','Undefined','','bx_photos',3,'active',1443490279,0,0,3),(17,'checkers\'s photos','checkers-s-photos','Undefined','','bx_photos',11,'active',1443634938,0,0,3),(18,'21.10.2015','21-10-2015','','','bx_photos',13,'active',1445391385,0,0,3),(22,'DMKDXWebPi\'s cover photos','DMKDXWebPi-s-cover-photos','Undefined','','bx_photos',17,'active',1458832357,0,0,3),(21,'DMKDXWebPi\'s photos','DMKDXWebPi-s-photos','Undefined','','bx_photos',17,'active',1456515841,0,0,3);

--
-- 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;

--
-- Dumping data for table `sys_albums_objects`
--

INSERT INTO `sys_albums_objects` VALUES (2,1,0),(1,2,0),(3,3,0),(4,4,0),(12,10,0),(15,11,0),(13,15,0),(13,14,0);

--
-- 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 AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;

--
-- 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','join',3),(9,'profile','edit',3),(10,'profile','delete',3),(11,'profile','join',4),(12,'profile','edit',4),(13,'profile','delete',4),(14,'profile','change_status',4),(15,'profile','commentRemoved',5),(17,'profile','delete',7),(18,'bx_photos','delete',8),(19,'bx_videos','delete',8),(20,'bx_sounds','delete',8),(21,'bx_files','delete',8),(22,'module','install',9),(38,'profile','edit',12),(39,'profile','edit_status_message',12),(112,'comment','add',12),(41,'profile','delete',12),(42,'friend','accept',12),(45,'bx_events','add',12),(46,'bx_events','commentPost',12),(47,'profile','delete',13),(48,'bx_photos','add',12),(49,'bx_photos','commentPost',12),(55,'system','design_included',14),(98,'bx_photos','delete',24),(97,'profile','delete',23),(65,'profile','delete',16),(75,'profile','delete',18),(76,'module','install',19),(77,'ads','create',12),(78,'ads','commentPost',12),(88,'profile','edit',20),(89,'profile','delete',20),(90,'profile','delete',21),(91,'bx_avatar','add',12),(92,'bx_avatar','change',12),(99,'bx_videos','delete',24),(100,'bx_sounds','delete',24),(101,'bx_files','delete',24),(102,'module','install',25),(103,'bx_groups','add',12),(104,'bx_groups','commentPost',12),(113,'profile','delete',2);

--
-- 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 AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

--
-- 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',''),(7,'bx_events_profile_delete','','','BxDolService::call(\'events\', \'response_profile_delete\', array($this));'),(8,'bx_events_media_delete','','','BxDolService::call(\'events\', \'response_media_delete\', array($this));'),(9,'bx_events_map_install','','','if (\'wmap\' == $this->aExtras[\'uri\'] && $this->aExtras[\'res\'][\'result\']) BxDolService::call(\'events\', \'map_install\');'),(12,'bx_wall','','','BxDolService::call(\'wall\', \'response\', array($this));'),(13,'bx_photos_profile_delete','','','BxDolService::call(\'photos\', \'response_profile_delete\', array($this));'),(14,'bx_pageac','','','BxDolService::call(\'pageac\', \'responce_protect_URL\', array($_SERVER[\'REQUEST_URI\']));'),(16,'bx_simple_messenger','BxSimpleMessengerResponse','modules/boonex/simple_messenger/classes/BxSimpleMessengerResponse.php',''),(18,'bx_ads_profile_delete','','','BxDolService::call(\'ads\', \'response_profile_delete\', array($this));'),(19,'bx_ads_map_install','','','if (\'wmap\' == $this->aExtras[\'uri\'] && $this->aExtras[\'res\'][\'result\']) BxDolService::call(\'ads\', \'map_install\');'),(20,'bx_forum_profile','BxForumProfileResponse','modules/boonex/forum/profile_response.php',''),(21,'bx_avatar','BxAvaProfileDeleteResponse','modules/boonex/avatar/classes/BxAvaProfileDeleteResponse.php',''),(23,'bx_groups_profile_delete','','','BxDolService::call(\'groups\', \'response_profile_delete\', array($this));'),(24,'bx_groups_media_delete','','','BxDolService::call(\'groups\', \'response_media_delete\', array($this));'),(25,'bx_groups_map_install','','','if (\'wmap\' == $this->aExtras[\'uri\'] && $this->aExtras[\'res\'][\'result\']) BxDolService::call(\'groups\', \'map_install\');');

--
-- 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;

--
-- Dumping data for table `sys_antispam_block_log`
--

INSERT INTO `sys_antispam_block_log` VALUES (2706229731,0,'stopforumspam','join',1440640891),(2706229731,0,'stopforumspam','join',1440640903),(2706229731,0,'stopforumspam','join',1440640905),(2706229731,0,'stopforumspam','join',1440641029),(2706229731,0,'stopforumspam','join',1440641051),(1096872948,0,'stopforumspam','join',1448461642),(1096872948,0,'stopforumspam','join',1448461653),(1096872948,0,'stopforumspam','join',1448461657),(1096872948,0,'stopforumspam','join',1448461667),(1096872948,0,'stopforumspam','join',1448461676),(1096872948,0,'stopforumspam','join',1448461733),(1096872948,0,'stopforumspam','join',1448461828);

--
-- 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;

--
-- Dumping data for table `sys_banners`
--


--
-- 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;

--
-- Dumping data for table `sys_banners_clicks`
--


--
-- 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;

--
-- Dumping data for table `sys_banners_shows`
--


--
-- 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;

--
-- Dumping data for table `sys_block_list`
--


--
-- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- 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;

--
-- Dumping data for table `sys_categories`
--

INSERT INTO `sys_categories` VALUES ('Party',0,'bx_events',0,'active','2015-04-08 16:05:08'),('Expedition',0,'bx_events',0,'active','2015-04-08 16:05:08'),('Presentation',0,'bx_events',0,'active','2015-04-08 16:05:08'),('Last Friday',0,'bx_events',0,'passive','2015-04-08 16:05:08'),('Birthday',0,'bx_events',0,'active','2015-04-08 16:05:08'),('Exhibition',0,'bx_events',0,'active','2015-04-08 16:05:08'),('Bushwalking',0,'bx_events',0,'passive','2015-04-08 16:05:08'),('Profile photos',0,'bx_photos',0,'active','2015-04-08 16:06:08'),('wall',0,'bx_sounds',0,'active','2015-04-08 16:05:09'),('wall',0,'bx_videos',0,'active','2015-04-08 16:05:09'),('Family',0,'bx_photos',0,'active','2015-04-08 16:06:08'),('Fun',0,'bx_photos',0,'active','2015-04-08 16:06:08'),('My portfolio',0,'bx_photos',0,'active','2015-04-08 16:06:08'),('Our cars',0,'bx_photos',0,'passive','2015-04-08 16:06:08'),('Other',0,'bx_photos',0,'active','2015-04-08 16:06:08'),('Profile Photos',1,'bx_photos',1,'active','2015-04-08 16:11:54'),('Profile Photos',2,'bx_photos',2,'active','2015-04-08 16:18:13'),('Default',0,'bx_news',0,'active','2015-04-08 16:21:07'),('BoonEx Products',0,'bx_news',0,'passive','2015-04-08 16:21:07'),('Some Useful Info',0,'bx_news',0,'passive','2015-04-08 16:21:07'),('Expedition',3,'bx_events',12,'active','2015-10-21 01:25:24'),('Presentation',1,'bx_events',2,'active','2015-04-08 16:24:18'),('Events',3,'bx_photos',1,'active','2015-04-08 16:33:48'),('Profile Photos',4,'bx_photos',3,'active','2015-04-10 03:58:19'),('Birthday',2,'bx_events',2,'active','2015-06-02 14:35:49'),('Profile photos',10,'bx_photos',12,'active','2015-09-15 21:06:19'),('Groups',0,'bx_photos',0,'passive','2015-10-30 01:34:31'),('Arts & Literature',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Animals & Pets',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Activities',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Automotive',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Business & Money',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Companies & Co-workers',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Cultures & Nations',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Dolphin Community',0,'bx_groups',0,'passive','2015-10-30 01:34:31'),('Family & Friends',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Fan Clubs',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Fashion & Style',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Fitness & Body Building',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Food & Drink',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Gay, Lesbian & Bi',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Health & Wellness',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Hobbies & Entertainment',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Internet & Computers',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Love & Relationships',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Mass Media',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Music & Cinema',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Places & Travel',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Politics',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Recreation & Sports',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Religion',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Science & Innovations',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Sex',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Teens & Schools',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Other',0,'bx_groups',0,'active','2015-10-30 01:34:31'),('Family & Friends',1,'bx_groups',12,'active','2015-11-13 16:26:58'),('Profile Photos',15,'bx_photos',13,'active','2015-12-22 20:35:41');

--
-- 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;

--
-- Dumping data for table `sys_cmts_profile`
--


--
-- 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;

--
-- Dumping data for table `sys_cmts_track`
--


--
-- 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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- 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',''),(7,'bx_news','*/5 * * * *','BxNewsCron','modules/boonex/news/classes/BxNewsCron.php','');

--
-- 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 AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- 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_dnsbluri_zones`
--

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

--
-- Dumping data for table `sys_dnsbluri_zones`
--


--
-- 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 AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_email_templates`
--



--
-- 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;

--
-- Dumping data for table `sys_fave_list`
--


--
-- 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;

--
-- Dumping data for table `sys_friend_list`
--

INSERT INTO `sys_friend_list` VALUES (2,1,1,'2015-04-08 16:09:45'),(2,3,1,'2015-04-14 03:23:40'),(3,1,1,'2015-04-16 15:42:44'),(12,13,1,'2015-10-21 01:35:28');

--
-- 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;

--
-- Dumping data for table `sys_greetings`
--

INSERT INTO `sys_greetings` VALUES (1,2,1,'2015-04-08','1');

--
-- 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;

--
-- Dumping data for table `sys_ip_list`
--


--
-- 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 AUTO_INCREMENT=126 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_ip_members_visits`
--

INSERT INTO `sys_ip_members_visits` VALUES (1,1,2903073612,'2015-04-07 14:29:02'),(2,2,2722637885,'2015-04-08 15:18:45'),(3,2,2722637885,'2015-04-08 15:23:40'),(4,2,2722637885,'2015-04-08 15:26:05'),(5,2,2722637885,'2015-04-09 14:38:42'),(6,3,2923395480,'2015-04-10 03:58:19'),(7,2,2722637885,'2015-04-13 16:11:24'),(8,2,404930803,'2015-04-15 14:53:05'),(9,3,2923395480,'2015-04-16 14:24:37'),(10,2,2923395480,'2015-04-16 14:30:46'),(11,3,2923395480,'2015-04-18 04:25:14'),(12,1,2722637885,'2015-05-05 01:20:55'),(13,2,2722637885,'2015-05-05 01:24:26'),(14,2,2722637885,'2015-05-05 01:26:39'),(15,2,3478595606,'2015-05-05 19:49:17'),(16,2,2796403229,'2015-05-11 21:17:09'),(17,2,2722637885,'2015-05-13 13:48:36'),(18,2,2706229665,'2015-05-19 14:27:23'),(19,4,2706229665,'2015-05-21 14:22:49'),(20,5,2706229665,'2015-05-21 15:03:08'),(21,6,2706229665,'2015-05-21 15:47:04'),(22,2,2706229665,'2015-05-26 15:39:12'),(23,2,2706229665,'2015-05-26 16:15:16'),(24,3,2923395480,'2015-06-01 13:59:04'),(25,2,2923395480,'2015-06-01 14:06:02'),(26,7,2923395480,'2015-06-01 14:25:50'),(27,8,1222881933,'2015-06-01 23:04:22'),(28,9,404930803,'2015-06-04 17:44:40'),(29,10,404930803,'2015-06-04 17:47:22'),(30,3,2923395480,'2015-07-03 19:33:50'),(31,2,2923395480,'2015-07-03 19:34:06'),(32,11,2923395480,'2015-07-09 19:24:44'),(33,11,2923395480,'2015-07-09 19:26:16'),(34,3,2923395480,'2015-07-10 13:58:59'),(35,11,1222881933,'2015-07-10 17:17:09'),(36,2,2706229731,'2015-07-27 23:27:49'),(37,3,2923395480,'2015-08-11 15:32:02'),(38,3,2923395480,'2015-08-25 17:30:35'),(39,2,2706229731,'2015-08-27 01:38:45'),(40,2,2706229731,'2015-08-27 02:05:00'),(41,12,2706229731,'2015-08-27 02:07:34'),(42,12,2706229731,'2015-08-27 02:11:07'),(43,12,2923333906,'2015-09-02 02:05:40'),(44,3,2923395480,'2015-09-03 14:45:26'),(45,3,2923395480,'2015-09-03 22:59:27'),(46,3,2923395480,'2015-09-04 15:45:54'),(47,12,2923333906,'2015-09-09 19:52:19'),(48,12,2923333906,'2015-09-09 19:59:37'),(49,3,2923395480,'2015-09-10 00:00:12'),(50,3,2923395480,'2015-09-10 15:52:56'),(51,3,2923395480,'2015-09-10 22:09:35'),(52,3,2923395480,'2015-09-11 16:22:30'),(53,12,2923333906,'2015-09-15 21:05:10'),(54,12,2923333906,'2015-09-15 21:06:44'),(55,3,2923395480,'2015-09-16 19:28:33'),(56,13,2923333906,'2015-09-21 21:26:28'),(57,13,2923333906,'2015-09-21 21:26:56'),(58,13,2923333906,'2015-09-21 21:36:55'),(59,13,2923333906,'2015-09-22 01:20:26'),(60,3,2923395480,'2015-09-22 03:06:58'),(61,13,2923333906,'2015-09-22 16:50:30'),(62,12,1206566245,'2015-09-25 20:02:42'),(63,13,1206566245,'2015-09-25 20:35:52'),(64,12,1206566245,'2015-09-25 20:40:21'),(65,13,1206566245,'2015-09-25 20:41:11'),(66,13,2923333906,'2015-09-28 01:21:46'),(67,13,2923333906,'2015-09-28 01:29:04'),(68,13,2923333906,'2015-09-28 01:31:43'),(69,13,2923333906,'2015-09-28 23:30:20'),(70,3,2923395480,'2015-09-29 01:26:56'),(71,13,2923333906,'2015-09-29 21:12:09'),(72,13,2923333906,'2015-09-29 23:21:30'),(73,11,1165308677,'2015-09-30 17:40:38'),(74,13,2923395480,'2015-10-02 14:11:07'),(75,3,2923395480,'2015-10-02 14:11:53'),(76,14,2923395480,'2015-10-02 14:16:15'),(77,12,2923395480,'2015-10-02 14:16:37'),(78,3,2923395480,'2015-10-02 15:55:52'),(79,12,2923333906,'2015-10-06 02:10:16'),(80,12,1096872948,'2015-10-09 20:56:23'),(81,13,1096872948,'2015-10-09 20:59:45'),(82,12,2923333906,'2015-10-12 18:41:33'),(83,12,2923333906,'2015-10-13 02:20:53'),(84,13,2923333906,'2015-10-21 01:35:15'),(85,3,2923395480,'2015-10-22 19:08:16'),(86,13,2923333906,'2015-10-27 21:15:56'),(87,13,2923333906,'2015-10-30 01:12:09'),(88,13,2923333906,'2015-10-30 02:34:32'),(89,3,2923395480,'2015-11-09 01:41:40'),(90,13,1096872948,'2015-11-25 14:00:34'),(91,3,1096872948,'2015-11-25 14:26:13'),(92,3,1096872948,'2015-11-25 14:32:10'),(93,13,1096872948,'2015-11-25 15:22:40'),(94,13,2923333906,'2015-12-08 17:22:30'),(95,13,2923333906,'2015-12-22 20:17:39'),(96,13,2923333906,'2015-12-22 20:17:54'),(97,13,2923333906,'2015-12-22 20:19:05'),(98,13,2923333906,'2016-01-13 20:17:05'),(99,3,2923395480,'2016-01-15 15:05:47'),(100,13,2923333906,'2016-01-18 15:15:01'),(101,13,2923333906,'2016-01-18 16:14:31'),(102,13,2923333906,'2016-01-18 16:19:13'),(103,13,2923333906,'2016-01-18 15:46:38'),(104,13,2923333906,'2016-01-18 16:05:18'),(105,3,2923395480,'2016-02-04 13:07:15'),(106,12,1096872948,'2016-02-24 12:29:11'),(107,13,2923333906,'2016-02-26 12:55:10'),(108,13,2923333906,'2016-02-26 12:55:28'),(109,15,2923333906,'2016-02-26 13:07:21'),(110,15,2923333906,'2016-02-26 13:10:02'),(111,15,2923333906,'2016-02-26 13:14:49'),(112,15,2923333906,'2016-02-26 13:17:15'),(113,15,2923333906,'2016-02-26 13:24:30'),(114,16,2923333906,'2016-02-26 14:16:17'),(115,16,2923333906,'2016-02-26 14:16:34'),(116,17,2923333906,'2016-02-26 14:43:53'),(117,17,2923333906,'2016-02-26 14:44:00'),(118,17,2923333906,'2016-02-26 15:10:46'),(119,3,2923395480,'2016-02-28 16:28:49'),(120,12,851164926,'2016-03-08 12:31:23'),(121,17,851164926,'2016-03-08 14:13:28'),(122,17,851164926,'2016-03-24 11:09:29'),(123,12,851164926,'2016-03-24 11:13:47'),(124,12,851164926,'2016-03-31 21:04:34'),(125,12,851164926,'2016-03-31 21:13:13');

--
-- 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 AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

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

INSERT INTO `sys_localization_categories` VALUES (1,'System'),(2,'ZIP Code Search'),(26,'Boonex Site Search'),(6,'Boonex Events'),(8,'Boonex Timeline'),(9,'Boonex Photos'),(10,'Boonex Feedback'),(11,'Boonex News'),(12,'Boonex Page Access Control'),(14,'Simple messenger'),(16,'Boonex Ads'),(18,'BoonEx Forum'),(19,'Boonex Avatars'),(21,'Boonex Profile Customize'),(24,'Boonex Groups'),(25,'AQB Advanced Search Form');

--
-- 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 AUTO_INCREMENT=4127 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_localization_keys`
--



--
-- 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

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

--
-- 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;

--
-- Dumping data for table `sys_localization_string_params`
--


--
-- 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;

--
-- Dumping data for table `sys_localization_strings`
--



--
-- 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 AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

--
-- 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','',1),(2,0,'modules','_adm_mmi_modules','','','puzzle-piece col-red1','puzzle-piece','',2),(3,2,'manage_modules','_adm_mmi_manage_modules','{siteAdminUrl}modules.php','Manage and configure integration modules for 3d party scripts','plus col-red1','','',0),(4,2,'flash_apps','_adm_mmi_flash_apps','{siteAdminUrl}flash.php','Flash Apps administration panel is available here','bolt col-red1','','',1),(5,0,'tools','_adm_mmi_tools','','','wrench col-green3','wrench','',3),(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','','',0),(7,5,'banners','_adm_mmi_banners','{siteAdminUrl}banners.php','Provides you with the ability to manage banners on your web site','flag col-green3','','',1),(8,5,'ip_blacklist','_adm_mmi_ip_blacklist','{siteAdminUrl}ip_blacklist.php','IP Blacklist system','ban col-green3','','',2),(9,5,'database_backup','_adm_mmi_database_backup','{siteAdminUrl}db.php','Make a backup of your site database with this utility','download col-green3','','',3),(10,5,'host_tools','_adm_mmi_host_tools','{siteAdminUrl}host_tools.php','Admin Host Tools','hdd-o col-green3','','',4),(11,5,'antispam','_adm_mmi_antispam','{siteAdminUrl}antispam.php','Antispam Tools','gavel col-green3','','',5),(12,5,'sitemap','_adm_mmi_sitemap','{siteAdminUrl}sitemap.php','Sitemap','sitemap col-green3','','',6),(13,5,'cache','_adm_mmi_cache','{siteAdminUrl}cache.php','Cache','bolt col-green3','','',7),(14,0,'builders','_adm_mmi_builders','','','magic col-red2','magic','',4),(15,14,'navigation_menu','_adm_mmi_navigation_menu','{siteAdminUrl}nav_menu_compose.php','For top menu items management','list col-red2','','',0),(16,14,'service_menu','_adm_mmi_service_menu','{siteAdminUrl}service_menu_compose.php','For top service\'s menu items management','list col-red2','','',1),(17,14,'bottom_menu','_adm_mmi_bottom_menu','{siteAdminUrl}bottom_menu_compose.php','For top bottom\'s menu items management','list col-red2','','',2),(18,14,'member_menu','_adm_mmi_member_menu','{siteAdminUrl}member_menu_compose.php','For top member\'s menu items management','list col-red2','','',3),(19,14,'admin_menu','_adm_mmi_admin_menu','{siteAdminUrl}menu_compose_admin.php','For top admin\'s menu items management','list col-red2','','',4),(20,14,'profile_fields','_adm_mmi_profile_fields','{siteAdminUrl}fields.php','For member profile fields management','list-alt col-red2','','',5),(21,14,'pages_blocks','_adm_mmi_pages_blocks','{siteAdminUrl}pageBuilder.php','Compose blocks for the site pages here','th-large col-red2','','',6),(22,14,'mobile_pages','_adm_mmi_mobile_pages','{siteAdminUrl}mobileBuilder.php','Mobile pages builder','th col-red2','','',7),(23,14,'predefined_values','_adm_mmi_predefined_values','{siteAdminUrl}preValues.php','','list-ol col-red2','','',8),(24,0,'settings','_adm_mmi_settings','','','sliders col-blue2','sliders','',5),(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','','',0),(26,24,'basic_settings','_adm_mmi_basic_settings','{siteAdminUrl}basic_settings.php','For managing site system settings','cog col-blue2','','',1),(27,24,'advanced_settings','_adm_mmi_advanced_settings','{siteAdminUrl}advanced_settings.php','More enhanced settings for your site features','cogs col-blue2','','',2),(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','','',3),(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','','',4),(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','','',5),(31,24,'templates','_adm_mmi_templates','{siteAdminUrl}templates.php','Templates management','eye col-blue2','','',6),(32,24,'categories_settings','_adm_mmi_categories_settings','{siteAdminUrl}categories.php','Categories settings','folder col-blue2','','',7),(33,24,'watermark','_adm_mmi_watermark','{siteAdminUrl}settings.php?cat=16','Setting up watermark for media content','certificate col-blue2','','',8),(34,0,'dashboard','_adm_mmi_dashboard','{siteAdminUrl}index.php','','tachometer col-blue3','tachometer','',0),(50,2,'bx_forum','_bx_forum','{siteUrl}forum/?action=goto&manage_forum=1','Forum Administration Panel','comments','','',14),(36,2,'bx_zip','_bx_zip_admin_menu','{siteUrl}modules/?r=zipcodesearch/administration/','ZIP Code Search','search','','',2),(38,2,'bx_events','_bx_events','{siteUrl}modules/?r=events/administration/','Events module by BoonEx','calendar','','',3),(40,2,'bx_wall','_wall_admin_menu_sitem','{siteUrl}modules/?r=wall/admin/','For managing Timeline','clock-o','','',5),(41,2,'bx_photos','_bx_photos','{siteUrl}modules/?r=photos/administration','Photo module by BoonEx','picture-o','','',6),(42,2,'bx_feedback','_feedback_admin_menu_sitem','{siteUrl}modules/?r=feedback/admin/','For managing member\'s feedback','thumbs-up','','',7),(43,2,'bx_news','_news_admin_menu_sitem','{siteUrl}modules/?r=news/admin/','For managing news','bullhorn','','',8),(44,2,'bx_pageac','_bx_pageac','{siteUrl}modules/?r=pageac/admin/','Page Access Control','unlock','','',9),(58,2,'bx_gsearch','_bx_gsearch','{siteUrl}modules/?r=google_search/administration/','Google Site Search module by BoonEx','google-plus','','',22),(46,2,'Simple messenger','_simple_messenger_title','{siteAdminUrl}settings.php?cat=109','Managing the simple messenger settings','comments-o','','',11),(48,2,'Ads','_sys_module_ads','{siteUrl}modules/boonex/ads/post_mod_ads.php','Administrator can manage ads categories, subcategories, etc.','money','','',13),(51,2,'bx_avatar','_bx_ava_avatar','{siteUrl}modules/?r=avatar/administration/','Avatar module by BoonEx','user','','',15),(53,2,'bx_profile_customize','_bx_profile_customize','{siteUrl}modules/?r=profile_customize/administration','Profile customizer module by BoonEx','magic','','',17),(56,2,'bx_groups','_bx_groups','{siteUrl}modules/?r=groups/administration/','Groups module by BoonEx','users','','',20),(57,2,'aqb_advanced_search_form','_aqb_advanced_search_form','{siteUrl}modules/?r=aqb_advanced_search_form/admin/','For managing Advanced Search Form module','list-alt col-red2','','',21),(59,24,'privacy','_adm_mmi_privacy','{siteAdminUrl}privacy.php','Privacy settings','lock col-blue2','','',8);

--
-- 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 AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

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

INSERT INTO `sys_menu_admin_top` VALUES (7,'info','_adm_tmi_info','https://www.boonex.com/trac/dolphin/wiki','','question-circle',3),(6,'extensions','_adm_tmi_extensions','https://www.boonex.com/market','','puzzle-piece',2),(5,'home','_adm_tmi_home','{site_url}index.php','_blank','external-link-square',1),(8,'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 AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

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

INSERT INTO `sys_menu_bottom` VALUES (1,'_About Us','About Us','','about_us.php','',0,'','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','',1,'','non,memb',1,3,1,1,1),(4,'_FAQ','FAQ','','faq.php','',0,'','non,memb',0,3,1,1,1),(5,'_Invite a friend','Invite a friend','','tellfriend.php','return launchTellFriend();',0,'','non,memb',0,3,1,1,1),(6,'_contact_us','Contact us','','contact.php','',0,'','non,memb',0,3,1,1,1),(7,'_Bookmark','Bookmark','','','addBookmark(); return false;',0,'','non,memb',0,3,1,1,1),(8,'_Terms_of_use','Terms of use','','terms_of_use.php','',0,'','',0,1,1,1,1),(9,'_Privacy','Privacy','','privacy.php','',0,'','',0,1,1,1,1),(10,'_contact_us','Contact us','','contact.php','',3,'','',1,1,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 AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

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

INSERT INTO `sys_menu_member` VALUES (6,'{evalResult}','MemberBlock','','{ProfileLink}','','return \'<b class=\"menu_item_username\">\' . getNickName({ID}) . \'</b>\';','bx_import(\'BxDolUserStatusView\');\r\n$oStatusView = new BxDolUserStatusView();\r\nreturn $oStatusView->getMemberMenuStatuses();',0,'1',3,1,0,0,'','top','link',0,'','_Presence'),(4,'_Settings','Settings','cog','pedit.php?ID={ID}','','','',0,'',3,1,0,0,'','top_extra','link',0,'','_Edit_profile_and_settings'),(7,'_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'),(8,'_sys_add_content','AddContent','plus','javascript:void(0);','','','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'),(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'),(10,'_Admin Panel','AdminPanel','wrench','{evalResult}','','return isAdmin() ? $GLOBALS[\'site\'][\'url_admin\'] : \'\';','',5,'1',3,1,1,1,'','top_extra','link',0,'','_Go admin panel'),(11,'','bx_events','','','','return BxDolService::call(\'events\', \'get_member_menu_item_add_content\');','',1,'1',3,1,1,1,'','top_extra','linked_item',8,'',''),(13,'','bx_photos','','','','return BxDolService::call(\'photos\', \'get_member_menu_item_add_content\');','',2,'1',3,1,1,1,'','top_extra','linked_item',8,'',''),(21,'','bx_groups','','','','return BxDolService::call(\'groups\', \'get_member_menu_item_add_content\');','',7,'1',3,1,1,1,'','top_extra','linked_item',8,'',''),(16,'','bx_ads','','','','return BxDolService::call(\'ads\', \'get_member_menu_item_add_content\');','',5,'1',3,1,1,1,'','top_extra','linked_item',8,'',''),(17,'_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'),(18,'Logout','logout','member_menu_default.png','logout.php?action=member_logout','','','',1,'1',3,1,1,1,'_self','top','link',0,'',''),(19,'_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});',2,'1',3,0,0,1,'','top','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'),(20,'','bx_forum','','','','$oMemberMenu = bx_instance(\'BxDolMemberMenu\'); $a = array(\'item_img_src\' => \'comments\', \'item_link\' => BX_DOL_URL_ROOT . \'forum/#action=goto&new_topic=0\', \'item_title\' => _t(\'_bx_forum_forum_topic\')); return $oMemberMenu->getGetExtraMenuLink($a);','',6,'1',3,1,1,1,'','top_extra','linked_item',8,'','');

--
-- 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 AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- 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),(11,'bx_photos','homepage','_bx_photos','home_images.png',7,'','','',6,1),(12,'bx_photos','profile','_bx_photos','',7,'','return BxDolXMLRPCMedia::_getMediaCount(\'photo\', \'{profile_id}\', \'{member_id}\');','',4,1),(13,'bx_news','homepage','_news_bcaption_view_main','{site_url}modules/boonex/news/templates/base/images/icons/mobile_icon.png',100,'{xmlrpc_url}r.php?url=modules%2F%3Fr%3Dnews%2Fmobile_latest_entries%2F&user={member_username}&pwd={member_password}','','',7,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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- 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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

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

INSERT INTO `sys_menu_service` VALUES (1,'Join','_sys_sm_join','user','','showPopupJoinForm(); return false;','',0,'',1,3,1,1,1),(2,'Login','_sys_sm_login','sign-in','','showPopupLoginForm(); return false;','',1,'non',1,3,1,1,1),(3,'Profile','_sys_sm_profile','','{memberLink}|{memberNick}|change_status.php','','',0,'memb',0,3,1,1,1),(4,'Account','_sys_sm_account','tachometer','member.php','','',0,'memb',0,3,1,1,1),(5,'Logout','_sys_sm_logout','sign-out','logout.php?action=member_logout','','',3,'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,'LoginOnly','_sys_sm_login','sign-in','','showPopupLoginOnlyForm(); return false;','',0,'non',0,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 AUTO_INCREMENT=330 DEFAULT CHARSET=utf8;

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

INSERT INTO `sys_menu_top` VALUES (4,0,'My Profile','{memberNick}','{memberLink}|{memberUsername}|change_status.php',0,'memb','','','',1,0,0,0,1,'system','user','',0,''),(5,0,'Home','_Sisters','index.php',0,'memb','','','',3,1,1,0,0,'top','home','',0,''),(6,0,'People','_People','browse.php|search.php|calendar.php|tags.php?tags_mode=profile|search.php?show=match',0,'non,memb','','','',3,1,1,0,0,'top','user','',0,''),(7,0,'All members','_All Members','browse.php|browse',0,'non,memb','','','',3,1,1,0,0,'custom','','',0,''),(8,0,'Search Members','_Search','search.php',0,'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,0,'View My Profile','_Profile','{memberLink}|{memberUsername}|profile.php?ID={memberID}',0,'','','','',3,1,1,0,0,'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,0,'Online Members','_Online','search.php?online_only=1',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(60,9,'View Profile','_Profile','{profileLink}|{profileUsername}|profile.php?ID={profileID}',0,'','','','',3,1,1,0,1,'custom','','',0,''),(80,4,'My Friends','_Friends','viewFriends.php?iUser={memberID}',1,'memb','','','',3,1,1,0,1,'custom','','',0,'mfa'),(82,9,'Info','_profile_info','profile_info.php?ID={profileID}',1,'','','','',3,1,1,0,1,'custom','','',0,''),(83,9,'Member Friends','_Friends','viewFriends.php?iUser={profileID}',2,'memb','','','',3,1,1,0,1,'custom','','',0,''),(98,0,'Join','_Account','join.php',0,'non','','','',3,1,1,0,1,'system','user','',0,''),(99,0,'Login','_Login','member.php',0,'non','','','',3,1,0,0,0,'top','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,'','','','',3,1,1,0,1,'custom','','',0,''),(129,0,'Top Rated','_Top Rated','search.php?show=top_rated',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(127,0,'Match','_Match','search.php?show=match',0,'non,memb','','','return isLogged() && getParam(\'enable_match\') == \'on\';',3,1,1,0,1,'custom','','',0,''),(128,0,'Featured','_Featured','search.php?show=featured',0,'non,memb','','','',3,1,1,0,0,'custom','','',0,''),(107,118,'Privacy Groups','_ps_tmenu_privacy_settings','member_privacy.php',3,'','','','bx_import(\'BxDolPrivacy\'); return BxDolPrivacy::isPrivacyPage();',3,1,1,0,1,'custom','','',0,''),(109,118,'Unregister','_Unregister','unregister.php',5,'','','','',3,1,1,0,1,'custom','','',0,''),(111,4,'Profile Info','_Info','profile_info.php',0,'','','','',3,1,1,0,1,'custom','','',0,''),(118,0,'Dashboard','_Dashboard','member.php',0,'memb','','','',1,0,1,0,1,'system','tachometer','',0,''),(120,0,'About','_About','about_us.php',5,'memb','','','',3,1,1,0,1,'top','info-circle','',0,''),(122,120,'Terms of Use','_TERMS_OF_USE_H','terms_of_use.php',1,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(123,120,'Privacy Policy','_PRIVACY_H','privacy.php',2,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(126,118,'Activity','_Activity','communicator.php',1,'','','','',3,1,1,0,1,'custom','','',0,''),(130,0,'Popular','_Popular','search.php?show=popular',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(131,0,'Birthdays','_Birthdays','search.php?show=birthdays',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(132,0,'People Calendar','_People_Calendar','calendar.php',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(138,0,'Search','_Search','search_home.php',0,'non,memb','','','',3,1,1,0,0,'top','search','',0,''),(139,0,'Keyword Search','_Keyword_Search','searchKeyword.php',0,'non,memb','','','',3,1,1,0,0,'custom','','',0,''),(141,0,'People Search','_People_Search','search.php',0,'non,memb','','','',3,1,1,0,0,'top','','',0,''),(159,0,'Help','_help','help.php',0,'non,memb','','','',3,1,1,0,0,'top','question-circle','',0,''),(160,120,'FAQ','_FAQ','faq.php',3,'memb','','','',3,1,1,0,1,'custom','','',0,''),(161,120,'Contact','_Contact','contact.php',4,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(162,0,'Advice','_Advice','advice.php',0,'non,memb','','','',3,1,1,0,0,'custom','','',0,''),(163,0,'Help','_help','help.php',0,'non,memb','','','',3,1,1,0,0,'custom','','',0,''),(175,0,'About','_About','about_us.php',0,'non,memb','','','',3,1,1,0,0,'custom','','',0,''),(176,0,'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',0,'memb','','','',3,1,1,0,1,'system','envelope','',0,''),(191,118,'Subscriptions','_sbs_tmenu_my_subscriptions','member_subscriptions.php',4,'','','','',3,1,1,0,1,'custom','','',0,''),(194,0,'ChatHome','_chat_home_top_menu_sitem','modules/?r=chat/home/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(195,0,'ChatRules','_chat_rules_top_menu_sitem','modules/?r=chat/rules/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(196,0,'ChatModerators','_chat_moderators_top_menu_sitem','search.php?show=moderators',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(197,0,'Events','_bx_events_menu_root','modules/?r=events/view/|modules/?r=events/broadcast/|modules/?r=events/invite/|modules/?r=events/edit/|modules/?r=events/upload_photos/|modules/?r=events/upload_videos/|modules/?r=events/upload_sounds/|modules/?r=events/upload_files/',0,'non,memb','','','',3,1,1,1,1,'system','calendar','',0,''),(198,197,'Event View','_bx_events_menu_view','modules/?r=events/view/{bx_events_view_uri}',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(199,197,'Event View Forum','_bx_events_menu_view_forum','forum/events/forum/{bx_events_view_uri}-0.htm|forum/events/',1,'non,memb','','','$oModuleDb = new BxDolModuleDb(); return $oModuleDb->getModuleByUri(\'forum\') ? true : false;',3,1,1,1,1,'custom','','',0,''),(200,197,'Event View Comments','_bx_events_menu_view_comments','modules/?r=events/comments/{bx_events_view_uri}',2,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(201,197,'Event View Participants','_bx_events_menu_view_participants','modules/?r=events/browse_participants/{bx_events_view_uri}',3,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(202,0,'Events','_bx_events_menu_root','modules/?r=events/home/|modules/?r=events/',4,'memb','','','',3,1,1,1,1,'top','calendar','calendar',1,''),(203,0,'Events Main Page','_bx_events_menu_main','modules/?r=events/home/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(204,0,'Upcoming Events','_bx_events_menu_upcoming_events','modules/?r=events/browse/upcoming',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(205,0,'Past Events','_bx_events_menu_past_events','modules/?r=events/browse/past',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(206,0,'Recently Added Events','_bx_events_menu_recently_added','modules/?r=events/browse/recent',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(207,0,'Top Rated Events','_bx_events_menu_top_rated','modules/?r=events/browse/top',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(208,0,'Popular Events','_bx_events_menu_popular','modules/?r=events/browse/popular',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(209,0,'Featured Events','_bx_events_menu_featured','modules/?r=events/browse/featured',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(210,0,'Events Tags','_bx_events_menu_tags','modules/?r=events/tags',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,'bx_events'),(211,0,'Events Categories','_bx_events_menu_categories','modules/?r=events/categories',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,'bx_events'),(212,202,'Calendar','_bx_events_menu_calendar','modules/?r=events/calendar',0,'','','','',3,1,1,1,1,'custom','','',0,''),(213,0,'Search','_bx_events_menu_search','modules/?r=events/search',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(214,9,'Events','_bx_events_menu_my_events_profile','modules/?r=events/browse/user/{profileUsername}|modules/?r=events/browse/joined/{profileUsername}',3,'','','','',3,1,1,1,1,'custom','','',0,''),(215,4,'Events','_bx_events_menu_my_events_profile','modules/?r=events/browse/my',2,'','','','',3,1,1,1,1,'custom','','',0,''),(217,4,'TimelineOwner','_wall_top_smenu_item_my_wall','modules/?r=wall/',3,'memb','','','',3,1,1,1,1,'custom','','',0,''),(218,9,'TimelineViewer','_wall_top_smenu_item_wall','modules/?r=wall/index/{profileUsername}',4,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(219,0,'Photos','_bx_photos_top_menu_item','modules/?r=photos/home/|modules/?r=photos/',0,'non,memb','','','',3,1,1,1,0,'top','picture-o','picture-o',1,''),(220,0,'PhotosHome','_bx_photos_top_menu_home','modules/?r=photos/home/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(221,0,'PhotosAlbums','_bx_photos_top_menu_albums','modules/?r=photos/albums/browse/all',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(222,0,'PhotosAll','_bx_photos_top_menu_all','modules/?r=photos/browse/all',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(223,0,'PhotosTop','_bx_photos_top_menu_top','modules/?r=photos/browse/top',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(224,0,'PhotosPopular','_bx_photos_top_menu_popular','modules/?r=photos/browse/popular',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(225,0,'PhotosFeatured','_bx_photos_top_menu_featured','modules/?r=photos/browse/featured',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(226,0,'PhotosTags','_bx_photos_top_menu_tags','modules/?r=photos/tags',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(227,0,'PhotosCategories','_bx_photos_top_menu_categories','modules/?r=photos/categories',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(228,0,'PhotosRate','_bx_photos_top_menu_rate','modules/?r=photos/rate',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(229,0,'PhotosCalendar','_bx_photos_top_menu_calendar','modules/?r=photos/calendar|modules/?r=photos/browse/calendar/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(230,0,'PhotosSearch','_bx_photos_top_menu_search','searchKeyword.php?type=bx_photos',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(231,9,'Photos','_bx_photos_menu_profile','modules/?r=photos/albums/browse/owner/{profileUsername}',6,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(232,4,'Photos','_bx_photos_menu_profile','modules/?r=photos/albums/my/main/|modules/?r=photos/albums/my/add/|modules/?r=photos/albums/my/manage/|modules/?r=photos/albums/my/disapproved/',5,'memb','','','',3,1,1,1,1,'custom','','',0,''),(233,0,'PhotosUnit','_bx_photos_top_menu_item','modules/?r=photos/view/|modules/?r=photos/crop/|photo/gallery/',0,'non,memb','','','',3,1,1,1,1,'system','picture-o','',0,''),(234,0,'PhotosAlbum','_bx_photos_top_menu_item','modules/?r=photos/browse/album/|modules/?r=photos/albums/my/edit/|modules/?r=photos/albums/my/organize/|modules/?r=photos/albums/my/add_objects/|modules/?r=photos/albums/my/manage_objects',0,'non,memb','','','',3,1,1,1,1,'system','picture-o','',0,''),(235,120,'Feedback','_feedback_top_menu_sitem','modules/?r=feedback/index/|modules/?r=feedback/',0,'memb','','','',3,1,1,1,1,'custom','','',0,''),(236,0,'FeedbackView','_feedback_top_menu_sitem','modules/?r=feedback/view/',0,'non,memb','','','',3,1,1,1,1,'system','thumbs-up','',0,''),(237,0,'News','_news_top_menu_item','modules/?r=news/index/|modules/?r=news/',0,'non,memb','','','',3,1,1,1,1,'custom','bullhorn','',0,''),(238,0,'NewsHome','_news_home_top_menu_sitem','modules/?r=news/index/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(239,0,'NewsArchive','_news_archive_top_menu_sitem','modules/?r=news/archive/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(240,0,'NewsTop','_news_top_top_menu_sitem','modules/?r=news/top/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(241,0,'NewsPopular','_news_popular_top_menu_sitem','modules/?r=news/popular/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(242,0,'NewsFeatured','_news_featured_top_menu_sitem','modules/?r=news/featured/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(243,0,'NewsTags','_news_tags_top_menu_sitem','modules/?r=news/tags/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(244,0,'NewsCategories','_news_categories_top_menu_sitem','modules/?r=news/categories/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(245,0,'NewsCalendar','_news_calendar_top_menu_sitem','modules/?r=news/calendar/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(246,0,'NewsSearch','_news_search_top_menu_sitem','searchKeyword.php?type=bx_news',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(247,0,'NewsView','_news_view_top_menu_sitem','modules/?r=news/view/',0,'non,memb','','','',3,1,1,1,1,'system','bullhorn','',0,''),(307,0,'Google Search','_bx_gsearch_menu_title','modules/?r=google_search/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(308,0,'World Map','_bx_wmap_search_submenu','modules/?r=wmap/home',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(250,0,'Home polls','_bx_poll_home','modules/?r=poll/&action=poll_home',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(251,0,'All Polls','_bx_poll_all','modules/?r=poll/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(252,0,'Popular','_bx_poll_popular','modules/?r=poll/&action=popular',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(253,0,'Featured','_bx_poll_featured_polls','modules/?r=poll/&action=featured',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(254,0,'Calendar','_bx_poll_calendar','modules/?r=poll/calendar',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(255,0,'Search','_bx_poll_search','searchKeyword.php?type=poll',0,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(256,0,'Tags','_bx_poll_tags','modules/?r=poll/tags',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(257,0,'Categories','_bx_poll_categories','modules/?r=poll/categories',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(310,0,'Upcoming Events','_bx_events_menu_upcoming_events','modules/?r=events/browse/upcoming',0,'non,memb','','','',3,0,1,1,0,'custom','','',0,''),(309,0,'Match','_Match','search.php?show=match',1,'memb','','','return isLogged() && getParam(\'enable_match\') == \'on\';',3,0,1,0,1,'top','','',0,''),(262,0,'SitesHome','_bx_sites_home_top_menu_sitem','modules/?r=sites/home/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(263,0,'SitesAll','_bx_sites_all_top_menu_sitem','modules/?r=sites/browse/all',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(264,0,'SitesAdmin','_bx_sites_admin_top_menu_sitem','modules/?r=sites/browse/admin',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(265,0,'SitesUsers','_bx_sites_profile_top_menu_sitem','modules/?r=sites/browse/users',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(266,0,'SitesTop','_bx_sites_top_top_menu_sitem','modules/?r=sites/browse/top',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(267,0,'SitesPopular','_bx_sites_popular_top_menu_sitem','modules/?r=sites/browse/popular',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(268,0,'SitesFeatured','_bx_sites_featured_top_menu_sitem','modules/?r=sites/browse/featured',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,'bx_sites'),(269,0,'SitesTags','_bx_sites_tags_top_menu_sitem','modules/?r=sites/tags',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,'bx_sites'),(270,0,'SitesCategories','_bx_sites_categories_top_menu_sitem','modules/?r=sites/categories',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(271,0,'SitesHoN','_bx_sites_hon_top_menu_sitem','modules/?r=sites/hon',0,'memb','','','',3,1,1,1,1,'custom','','',0,''),(272,0,'SitesCalendar','_bx_sites_calendar_top_menu_sitem','modules/?r=sites/calendar',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(273,0,'SitesSearch','_bx_sites_search_top_menu_sitem','modules/?r=sites/search',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(275,0,'Sites','_bx_sites_menu_my_sites_profile','modules/?r=sites/browse/my',0,'memb','','','',3,1,1,1,0,'custom','','',0,''),(276,0,'Popular','_Popular','search.php?show=popular',0,'non,memb','','','',3,1,1,0,0,'top','','',0,''),(277,0,'Photos','_bx_photos_menu_profile','modules/?r=photos/albums/my/main/|modules/?r=photos/albums/my/add/|modules/?r=photos/albums/my/manage/|modules/?r=photos/albums/my/disapproved/',0,'memb','','','',3,1,1,1,0,'top','','',0,''),(278,0,'Ads','Resources','modules/boonex/ads/classifieds.php?Browse=1|modules/boonex/ads/classifieds.php?action=show_calendar_ads&date=|modules/boonex/ads/classifieds_tags.php?tag=|ads/tag/|modules/boonex/ads/classifieds.php?bClassifiedID=|ads/cat/|modules/boonex/ads/classifieds.p',3,'memb','','','',3,1,1,1,1,'top','money','money',1,''),(279,9,'Profile Ads','_bx_ads_Ads','modules/boonex/ads/classifieds.php?UsersOtherListing=1&IDProfile={profileID}',5,'','','','',3,1,1,1,1,'custom','','',0,''),(280,4,'Profile Ads','_bx_ads_Ads','modules/boonex/ads/classifieds.php?action=my_page|ads/my_page/',4,'','','','',3,1,1,1,1,'custom','','',0,''),(281,0,'Ads Calendar','_bx_ads_Calendar','modules/boonex/ads/classifieds.php?action=show_calendar',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(282,278,'Ads Categories','_bx_ads_Categories','modules/boonex/ads/classifieds.php?action=show_categories',2,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(283,278,'Popular Ads','_bx_ads_Popular','modules/boonex/ads/classifieds.php?action=show_popular',1,'memb','','','',3,1,1,1,1,'custom','','',0,''),(284,0,'Ads Tags','_Tags','modules/boonex/ads/classifieds.php?action=tags',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(285,0,'Top Rated Ads','Top Rated','modules/boonex/ads/classifieds.php?action=show_top_rated',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(286,278,'Ads Search','_Search','searchKeyword.php?type=bx_ads|modules/boonex/ads/classifieds.php?FilterCountry=',3,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(287,0,'Ads Featured','_bx_ads_Featured','modules/boonex/ads/classifieds.php?action=show_featured',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(288,278,'All Ads','All Resources','modules/boonex/ads/classifieds.php?action=show_all_ads',0,'memb','','','',3,1,1,1,1,'custom','','',0,''),(289,0,'Ads Home','_bx_ads_Ads_Home','modules/boonex/ads/classifieds.php?Browse=1',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(290,0,'Ad View','_bx_ads_Ads','modules/boonex/ads/classifieds.php?ShowAdvertisementID=|ads/entry/',0,'non,memb','','','',3,1,1,1,1,'system','money','',0,''),(291,0,'View Profile','{memberNick}','{memberNick}',0,'','','','',3,1,1,0,1,'top','','',0,''),(292,0,'Event View','_bx_events_menu_view','modules/?r=events/view/{bx_events_view_uri}',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(329,0,'Google Search','_bx_gsearch_menu_title','modules/?r=google_search/',0,'non,memb','','','',3,1,1,1,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/',6,'','','','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/',7,'','','','bx_import(\'BxDolPayments\'); return BxDolPayments::getInstance()->isActive();',3,1,1,0,1,'custom','','',0,''),(295,0,'Forums','_bx_forums','forum/',0,'memb','','','',3,1,1,1,0,'top','comments','comments',1,''),(296,0,'Forums Home','_bx_forum_menu_home','forum/',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(297,0,'Forums Index','_bx_forum_menu_forum_index','forum/?action=goto&index=1',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(298,0,'Flagged Topics','_bx_forum_menu_flagged_topics','forum/?action=goto&my_flags=1',0,'memb','','','',3,1,1,1,1,'custom','','',0,''),(299,0,'My Topics','_bx_forum_menu_my_topics','forum/?action=goto&my_threads=1',0,'memb','','','',3,1,1,1,1,'custom','comments','comments',1,''),(300,0,'Spy','_bx_forum_menu_spy','forum/?action=live_tracker',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(301,0,'Forum Search','_bx_forum_menu_search','forum/?action=goto&search=1',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(302,0,'Manage Forum','_bx_forum_menu_manage_forum','forum/?action=goto&manage_forum=1',0,'memb','','','return isAdmin();',3,1,1,1,1,'custom','','',0,''),(303,0,'Reported Posts','_bx_forum_menu_reported_posts','forum/?action=goto&reported_posts=1',0,'memb','','','return isAdmin();',3,1,1,1,1,'custom','','',0,''),(304,0,'Hidden Posts','_bx_forum_menu_hidden_posts','forum/?action=goto&hidden_posts=1',0,'memb','','','return isAdmin();',3,1,1,1,1,'custom','','',0,''),(305,0,'Hidden Topics','_bx_forum_menu_hidden_topics','forum/?action=goto&hidden_topics=1',0,'memb','','','return isAdmin();',3,1,1,1,1,'custom','','',0,''),(306,118,'Avatar','_bx_ava_avatar','modules/?r=avatar/',2,'memb','','','',3,1,1,1,1,'custom','','',0,''),(311,0,'Events Categories','_bx_events_menu_categories','modules/?r=events/categories',0,'non,memb','','','',3,0,1,1,0,'custom','','',0,'bx_events'),(312,0,'Groups','_bx_groups_menu_root','modules/?r=groups/view/|modules/?r=groups/broadcast/|modules/?r=groups/invite/|modules/?r=groups/edit/|forum/groups/',0,'non,memb','','','',3,1,1,1,1,'system','users','',0,''),(313,312,'Group View','_bx_groups_menu_view_group','modules/?r=groups/view/{bx_groups_view_uri}',0,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(314,312,'Group View Forum','_bx_groups_menu_view_forum','forum/groups/forum/{bx_groups_view_uri}-0.htm|forum/groups/',1,'non,memb','','','$oModuleDb = new BxDolModuleDb(); return $oModuleDb->getModuleByUri(\'forum\') ? true : false;',3,1,1,1,1,'custom','','',0,''),(315,312,'Group View Fans','_bx_groups_menu_view_fans','modules/?r=groups/browse_fans/{bx_groups_view_uri}',2,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(316,312,'Group View Comments','_bx_groups_menu_view_comments','modules/?r=groups/comments/{bx_groups_view_uri}',3,'non,memb','','','',3,1,1,1,1,'custom','','',0,''),(317,0,'Groups','_bx_groups_menu_root','modules/?r=groups/home/|modules/?r=groups/',2,'memb','','','',3,1,1,1,1,'top','users','users',1,''),(318,317,'Groups Main Page','_bx_groups_menu_main','modules/?r=groups/home/',0,'','','','',3,1,1,1,1,'custom','','',0,''),(319,0,'Recent Groups','_bx_groups_menu_recent','modules/?r=groups/browse/recent',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(320,0,'Top Rated Groups','_bx_groups_menu_top_rated','modules/?r=groups/browse/top',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(321,0,'Popular Groups','_bx_groups_menu_popular','modules/?r=groups/browse/popular',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(322,0,'Featured Groups','_bx_groups_menu_featured','modules/?r=groups/browse/featured',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(323,0,'Groups Tags','_bx_groups_menu_tags','modules/?r=groups/tags',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,'bx_groups'),(324,317,'Groups Categories','_bx_groups_menu_categories','modules/?r=groups/categories',1,'non,memb','','','',3,1,1,1,1,'custom','','',0,'bx_groups'),(325,0,'Calendar','_bx_groups_menu_calendar','modules/?r=groups/calendar',0,'non,memb','','','',3,1,1,1,0,'custom','','',0,''),(326,317,'Search','_bx_groups_menu_search','modules/?r=groups/search',2,'non,memb','','','',3,1,1,0,1,'custom','','',0,''),(327,9,'Groups','_bx_groups_menu_my_groups_profile','modules/?r=groups/browse/user/{profileUsername}|modules/?r=groups/browse/joined/{profileUsername}',7,'','','','',3,1,1,1,1,'custom','','',0,''),(328,4,'Groups','_bx_groups_menu_my_groups_profile','modules/?r=groups/browse/my',6,'','','','',3,1,1,1,1,'custom','','',0,'');

--
