--
-- Host: localhost    Database: persisters_db_to733
-- ------------------------------------------------------


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

CREATE TABLE `States` (
  `Country` varchar(255) NOT NULL,
  `CountryCode` varchar(5) NOT NULL,
  `State` varchar(255) NOT NULL,
  `StateCode` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `States`
--

INSERT INTO `States` VALUES ('Afghanistan','AF','Badakhshan','BAD'),('Afghanistan','AF','Badghis','BAH'),('Afghanistan','AF','Baghlan','BAG'),('Afghanistan','AF','Balkh','BAL'),('Afghanistan','AF','Bamian','BAM'),('Afghanistan','AF','Farah','FAR'),('Afghanistan','AF','Faryab','FAY'),('Afghanistan','AF','Ghazni','GHA'),('Afghanistan','AF','Ghowr','GHO'),('Afghanistan','AF','Helmand','HEL'),('Afghanistan','AF','Herat','HER'),('Afghanistan','AF','Jowzjan','JOW'),('Afghanistan','AF','Kabol','KAB'),('Afghanistan','AF','Kandahar','KAN'),('Afghanistan','AF','Kapisa','KAP'),('Afghanistan','AF','Khowst','KHW'),('Afghanistan','AF','Konar','KNR'),('Afghanistan','AF','Kondoz','KON'),('Afghanistan','AF','Laghman','LAG'),('Afghanistan','AF','Lowgar','LOW'),('Afghanistan','AF','Nangarhar','NAN'),('Afghanistan','AF','Nimruz','NIM'),('Afghanistan','AF','Nurestan','NUR'),('Afghanistan','AF','Oruzgan','ORU'),('Afghanistan','AF','Paktia','PKT'),('Afghanistan','AF','Paktika','PAK'),('Afghanistan','AF','Parvan','PAR'),('Afghanistan','AF','Samangan','SAM'),('Afghanistan','AF','Sar-e Pol','SAR'),('Afghanistan','AF','Takhar','TAK'),('Afghanistan','AF','Unknown','UNK'),('Afghanistan','AF','Vardak','VAR'),('Afghanistan','AF','Zabol','ZAB'),('Albania','AL','Beratit','BER'),('Albania','AL','Dibres','DIB'),('Albania','AL','Durresit','DUR'),('Albania','AL','Elbasanit','ELB'),('Albania','AL','Fierit','FIE'),('Albania','AL','Gjirokastres','GJI'),('Albania','AL','Korces','KOR'),('Albania','AL','Kukesit','KUK'),('Albania','AL','Lezhes','LEZ'),('Albania','AL','Shkodres','SHK'),('Albania','AL','Tiranes','TIR'),('Albania','AL','Vlores','VLO'),('Algeria','DZ','Adrar','ADR'),('Algeria','DZ','Ain Defla','AID'),('Algeria','DZ','Ain Temouchent','AIT'),('Algeria','DZ','Alger','ALG'),('Algeria','DZ','Annaba','ANN'),('Algeria','DZ','Batna','BAT'),('Algeria','DZ','Bechar','BEC'),('Algeria','DZ','Bejaia','BEJ'),('Algeria','DZ','Biskra','BIS'),('Algeria','DZ','Blida','BLI'),('Algeria','DZ','Bordj Bou Arreridj','BOR'),('Algeria','DZ','Bouira','BOU'),('Algeria','DZ','Chlef','CHL'),('Algeria','DZ','Constantine','CON'),('Algeria','DZ','Djelfa','DJE'),('Algeria','DZ','El Bayadh','ELB'),('Algeria','DZ','El Oued','ELO'),('Algeria','DZ','Ghardaia','GHA'),('Algeria','DZ','Guelma','GUE'),('Algeria','DZ','Illizi','ILL'),('Algeria','DZ','Jijel','JIJ'),('Algeria','DZ','Khenchela','KHE'),('Algeria','DZ','Laghouat','LAG'),('Algeria','DZ','M\'Sila','MSI'),('Algeria','DZ','Mascara','MAS'),('Algeria','DZ','Medea','MED'),('Algeria','DZ','Mila','MIL'),('Algeria','DZ','Mostaganem','MOS'),('Algeria','DZ','Naama','NAA'),('Algeria','DZ','Oran','ORA'),('Algeria','DZ','Ouargla','OUA'),('Algeria','DZ','Oum el Bouaghi','OUM'),('Algeria','DZ','Relizane','REL'),('Algeria','DZ','Saida','SAI'),('Algeria','DZ','Setif','SET'),('Algeria','DZ','Sidi Bel Abbes','SID'),('Algeria','DZ','Skikda','SKI'),('Algeria','DZ','Souk Ahras','SOU'),('Algeria','DZ','Tamanghasset','TAM'),('Algeria','DZ','Tebessa','TEB'),('Algeria','DZ','Tiaret','TIA'),('Algeria','DZ','Tindouf','TIN'),('Algeria','DZ','Tipaza','TIP'),('Algeria','DZ','Tissemsilt','TIS'),('Algeria','DZ','Tizi Ouzou','TIZ'),('Algeria','DZ','Tlemcen','TLE'),('Andorra','AD','Andorra','AND'),('Angola','AO','Benguela','BEN'),('Angola','AO','Huambo','HUA'),('Angola','AO','Luanda','LUA'),('Angola','AO','Lunda Sul','LUS'),('Anguilla','AI','Anguilla','ANG'),('Antarctica','AQ','Antarctica','ARC'),('Antigua and Barbuda','AG','Antigua & Barbuda','ANT'),('Argentina','AR','Buenos Aires','BA'),('Argentina','AR','Catamarca','CAT'),('Argentina','AR','Chaco','CHA'),('Argentina','AR','Chubut','CHU'),('Argentina','AR','Cordoba','CDB'),('Argentina','AR','Corrientes','COR'),('Argentina','AR','Distrito Federal','DF'),('Argentina','AR','Entre Rios','ERI'),('Argentina','AR','Formosa','FOR'),('Argentina','AR','Jujuy','JUJ'),('Argentina','AR','La Pampa','LPA'),('Argentina','AR','La Rioja','LRI'),('Argentina','AR','Mendoza','MEN'),('Argentina','AR','Misiones','MIS'),('Argentina','AR','Neuquen','NEU'),('Argentina','AR','Rio Negro','RNE'),('Argentina','AR','Salta','SAL'),('Argentina','AR','San Juan','SJU'),('Argentina','AR','San Luis','SLU'),('Argentina','AR','Santa Cruz','SCR'),('Argentina','AR','Santa Fe','SFE'),('Argentina','AR','Santiago del Estero','SDE'),('Argentina','AR','Tierra del Fuego','TDF'),('Argentina','AR','Tucuman','TUC'),('Armenia','AM','Aragatsotni','ARA'),('Armenia','AM','Ararati','ARR'),('Armenia','AM','Armaviri','ARM'),('Armenia','AM','Geghark\'unik\'i','GEG'),('Armenia','AM','K\'aghak\' Yerevan','KAY'),('Armenia','AM','Kalininskiy Rayon','KAL'),('Armenia','AM','Kotayk\'i','KOT'),('Armenia','AM','Lorru','KAL'),('Armenia','AM','Shiraki','SHI'),('Armenia','AM','Syunik\'i','SYU'),('Armenia','AM','Tavushi','TAV'),('Armenia','AM','Vayots\' Dzori','VAY'),('Aruba','AW','Aruba','ARU'),('Australia','AU','Australian Capital Territory','ACT'),('Australia','AU','New South Wales','NSW'),('Australia','AU','Northern Territory','NTY'),('Australia','AU','Queensland','QLD'),('Australia','AU','South Australia','SAU'),('Australia','AU','Tasmania','TAS'),('Australia','AU','Victoria','VIC'),('Australia','AU','Western Australia','WAU'),('Austria','AT','Burgenland','BUR'),('Austria','AT','Karnten','KAR'),('Austria','AT','Niederosterreich','NIE'),('Austria','AT','Oberosterreich','OBE'),('Austria','AT','Salzburg','SAL'),('Austria','AT','Steiermark','STE'),('Austria','AT','Tirol','TIR'),('Austria','AT','Vorarlberg','VOR'),('Austria','AT','Wien','WIE'),('Azerbaijan','AZ','Abseron','ABS'),('Azerbaijan','AZ','Agcabadi','AGC'),('Azerbaijan','AZ','Agdam','AGM'),('Azerbaijan','AZ','Agdas','AGD'),('Azerbaijan','AZ','Agstafa','AGS'),('Azerbaijan','AZ','Agsu','AGU'),('Azerbaijan','AZ','Ali Bayramli Sahari','ALI'),('Azerbaijan','AZ','Astara','AST'),('Azerbaijan','AZ','Baki Sahari','BAK'),('Azerbaijan','AZ','Balakan','BAL'),('Azerbaijan','AZ','Barda','BAR'),('Azerbaijan','AZ','Beylaqan','BEY'),('Azerbaijan','AZ','Bilasuvar','BIL'),('Azerbaijan','AZ','Cabrayil','CAB'),('Azerbaijan','AZ','Calilabad','CAL'),('Azerbaijan','AZ','Daskasan','DAS'),('Azerbaijan','AZ','Davaci','DAV'),('Azerbaijan','AZ','Fuzuli','FUZ'),('Azerbaijan','AZ','Gadabay','GAD'),('Azerbaijan','AZ','Ganca Sahari','GAN'),('Azerbaijan','AZ','Goranboy','GOR'),('Azerbaijan','AZ','Goycay','GOY'),('Azerbaijan','AZ','Haciqabul','HAC'),('Azerbaijan','AZ','Imisli','IMI'),('Azerbaijan','AZ','Ismayilli','ISM'),('Azerbaijan','AZ','Kalbacar','KAL'),('Azerbaijan','AZ','Kurdamir','KUR'),('Azerbaijan','AZ','Lacin','LAC'),('Azerbaijan','AZ','Lankaran','LAN'),('Azerbaijan','AZ','Lankaran Sahari','LAs'),('Azerbaijan','AZ','Lerik','LER'),('Azerbaijan','AZ','Masalli','MAS'),('Azerbaijan','AZ','Mingacevir Sahari','MIN'),('Azerbaijan','AZ','Naftalan Sahari','NAF'),('Azerbaijan','AZ','Naxcivan Muxtar Respublikasi','NAX'),('Azerbaijan','AZ','Neftcala','NEF'),('Azerbaijan','AZ','Oguz','OGU'),('Azerbaijan','AZ','Qabala','QAB'),('Azerbaijan','AZ','Qax','QAX'),('Azerbaijan','AZ','Qazax','QAZ'),('Azerbaijan','AZ','Qobustan','QOB'),('Azerbaijan','AZ','Quba','QUB'),('Azerbaijan','AZ','Qubadli','QUL'),('Azerbaijan','AZ','Qusar','QUS'),('Azerbaijan','AZ','Saatli','SAA'),('Azerbaijan','AZ','Sabirabad','SAB'),('Azerbaijan','AZ','Saki','SAK'),('Azerbaijan','AZ','Saki Sahari','SAS'),('Azerbaijan','AZ','Salyan','SAL'),('Azerbaijan','AZ','Samaxi','SAM'),('Azerbaijan','AZ','Samkir','SAR'),('Azerbaijan','AZ','Samux','SAX'),('Azerbaijan','AZ','Siyazan','SIY'),('Azerbaijan','AZ','Susa','SUR'),('Azerbaijan','AZ','Tartar','TAR'),('Azerbaijan','AZ','Tovuz','TOV'),('Azerbaijan','AZ','Ucar','UCA'),('Azerbaijan','AZ','Xacmaz','XAC'),('Azerbaijan','AZ','Xankandi Sahari','XAN'),('Azerbaijan','AZ','Xanlar','XAL'),('Azerbaijan','AZ','Xizi','XIZ'),('Azerbaijan','AZ','Xocali','XOC'),('Azerbaijan','AZ','Xocavand','XOV'),('Azerbaijan','AZ','Yardimli','YAR'),('Azerbaijan','AZ','Yevlax','YEV'),('Azerbaijan','AZ','Yevlax Sahari','YES'),('Azerbaijan','AZ','Zangilan','ZAN'),('Azerbaijan','AZ','Zaqatala','ZAQ'),('Azerbaijan','AZ','Zardab','ZAR'),('Bahamas','BS','Abaco','ABA'),('Bahamas','BS','Andros','AND'),('Bahamas','BS','Bimini Islands','BIM'),('Bahamas','BS','Cat Island','CAT'),('Bahamas','BS','Eleuthera','ELE'),('Bahamas','BS','Exuma & Cays','EXU'),('Bahamas','BS','Grand Bahama','GBA'),('Bahamas','BS','Harbour Island & Spanish Wells','HIS'),('Bahamas','BS','Inagua','INA'),('Bahamas','BS','Long Island','LIS'),('Bahamas','BS','Mayaguana','MAY'),('Bahamas','BS','New Providence','NPR'),('Bahamas','BS','Ragged Islands','RAG'),('Bahrain','BH','Al Hadd','HAD'),('Bahrain','BH','Al Manamah','MAN'),('Bahrain','BH','Al Mintaqah al Gharbiyah','GHA'),('Bahrain','BH','Al Mintaqah al Wusta','WUS'),('Bahrain','BH','Al Mintaqah ash Shamaliyah','SHA'),('Bahrain','BH','Al Muharraq','MUH'),('Bahrain','BH','Ar Rifa` wa al Mintaqah al Janubiyah','RIF'),('Bahrain','BH','Jidd Hafs','JID'),('Bahrain','BH','Madinat Hamad','MAH'),('Bahrain','BH','Madinat `Isa','MAI'),('Bahrain','BH','Mintaqat Juzur Hawar','JUZ'),('Bahrain','BH','Sitrah','SIT'),('Bangladesh','BD','Chittagong','CHI'),('Bangladesh','BD','Dhaka','DHA'),('Bangladesh','BD','Khulna','KHU'),('Bangladesh','BD','Rajshahi','RAJ'),('Barbados','BB','Christ Church','CHR'),('Barbados','BB','Saint Andrew','AND'),('Barbados','BB','Saint George','GEO'),('Barbados','BB','Saint James','JAM'),('Barbados','BB','Saint John','JOH'),('Barbados','BB','Saint Joseph','JOS'),('Barbados','BB','Saint Lucy','LUC'),('Barbados','BB','Saint Michael','MIC'),('Barbados','BB','Saint Peter','PET'),('Barbados','BB','Saint Philip','PHI'),('Barbados','BB','Saint Thomas','THO'),('Belarus','BY','Brestskaya','BRE'),('Belarus','BY','Homyel\'skaya','HOM'),('Belarus','BY','Hrodzyenskaya','HRO'),('Belarus','BY','Mahilyowskaya','MAH'),('Belarus','BY','Minskaya','MIN'),('Belarus','BY','Unknown','UNK'),('Belarus','BY','Vitsyebskaya','VIT'),('Belgium','BE','Antwerpen','ANT'),('Belgium','BE','Hainaut','HAI'),('Belgium','BE','Liege','LIE'),('Belgium','BE','Limburg','LIM'),('Belgium','BE','Luxembourg','LUX'),('Belgium','BE','Namur','NAM'),('Belgium','BE','Oost-Vlaanderen','OOV'),('Belgium','BE','Unknown','UNK'),('Belgium','BE','West-Vlaanderen','WEV'),('Belize','BZ','Belize','BEL'),('Belize','BZ','Cayo','CAY'),('Belize','BZ','Corozal','COR'),('Belize','BZ','Orange Walk','ORA'),('Belize','BZ','Stann Creek','STA'),('Belize','BZ','Toledo','TOL'),('Benin','BJ','Unknown','UNK'),('Bermuda','BM','Devonshire','DEV'),('Bermuda','BM','Hamilton','HAM'),('Bermuda','BM','Paget','PAG'),('Bermuda','BM','Pembroke','PEM'),('Bermuda','BM','Saint Georges','SGS'),('Bermuda','BM','Sandys','SAN'),('Bermuda','BM','Smiths','SMI'),('Bermuda','BM','Southampton','SOU'),('Bermuda','BM','Warwick','WAR'),('Bhutan','BT','Bhutan','BHU'),('Bolivia','BO','Beni','BEN'),('Bolivia','BO','Chuquisaca','CHU'),('Bolivia','BO','Cochabamba','COC'),('Bolivia','BO','La Paz','LAP'),('Bolivia','BO','Oruro','ORU'),('Bolivia','BO','Pando','PAN'),('Bolivia','BO','Potosi','POT'),('Bolivia','BO','Santa Cruz','SAN'),('Bolivia','BO','Tarija','TAR'),('Bosnia and Herzegovina','BA','Bosnia and Herzegovina','BOS'),('Bosnia and Herzegovina','BA','Republika Srpska','SRP'),('Bosnia and Herzegovina','BA','Unknown','UNK'),('Botswana','BW','Gaborone','GAB'),('Botswana','BW','Unknown','UNK'),('Brazil','BR','Acre','ACR'),('Brazil','BR','Alagoas','ALA'),('Brazil','BR','Amapa','AMP'),('Brazil','BR','Amazonas','AMZ'),('Brazil','BR','Bahia','BAH'),('Brazil','BR','Ceara','CEA'),('Brazil','BR','Distrito Federal','DF'),('Brazil','BR','Espirito Santo','ESA'),('Brazil','BR','Goias','GOI'),('Brazil','BR','Maranhao','MAR'),('Brazil','BR','Mato Grosso','MGR'),('Brazil','BR','Mato Grosso do Sul','MGS'),('Brazil','BR','Minas Gerais','MGE'),('Brazil','BR','Para','PAR'),('Brazil','BR','Paraiba','PRB'),('Brazil','BR','Parana','PRN'),('Brazil','BR','Pernambuco','PER'),('Brazil','BR','Piaui','PIA'),('Brazil','BR','Rio de Janeiro','RDJ'),('Brazil','BR','Rio Grande do Norte','RGN'),('Brazil','BR','Rio Grande do Sul','RGS'),('Brazil','BR','Rondonia','RON'),('Brazil','BR','Roraima','ROR'),('Brazil','BR','Santa Catarina','SCA'),('Brazil','BR','Sao Paulo','SPA'),('Brazil','BR','Sergipe','SER'),('Brazil','BR','Tocantins','TOC'),('British Virgin Islands','VG','British Virgin Islands','BVI'),('Brunei','BN','Brunei','BRU'),('Bulgaria','BG','Blagoevgrad','BLA'),('Bulgaria','BG','Burgas','BUR'),('Bulgaria','BG','Dobrich','DOB'),('Bulgaria','BG','Gabrovo','GAB'),('Bulgaria','BG','Khaskovo','KHA'),('Bulgaria','BG','Kurdzhali','KUR'),('Bulgaria','BG','Kyustendil','KYU'),('Bulgaria','BG','Lovech','LOV'),('Bulgaria','BG','Montana','MON'),('Bulgaria','BG','Pazardzhik','PAZ'),('Bulgaria','BG','Pernik','PER'),('Bulgaria','BG','Pleven','PLE'),('Bulgaria','BG','Plovdiv','PLO'),('Bulgaria','BG','Razgrad','RAZ'),('Bulgaria','BG','Ruse','RUS'),('Bulgaria','BG','Shumen','SHU'),('Bulgaria','BG','Silistra','SIL'),('Bulgaria','BG','Sliven','SLI'),('Bulgaria','BG','Smolyan','SMO'),('Bulgaria','BG','Sofiya','SOF'),('Bulgaria','BG','Sofiya-Grad','SFG'),('Bulgaria','BG','Stara Zagora','STA'),('Bulgaria','BG','Turgovishte','TUR'),('Bulgaria','BG','Varna','VAR'),('Bulgaria','BG','Veliko Turnovo','VEL'),('Bulgaria','BG','Vidin','VID'),('Bulgaria','BG','Vratsa','VRA'),('Bulgaria','BG','Yambol','YAM'),('Burkina Faso','BF','Burkina Faso','BUF'),('Burundi','BN','Burundi','BUR'),('Cambodia','KH','Batdambang','BAT'),('Cambodia','KH','Kampong Cham','CHA'),('Cambodia','KH','Kampong Chhnang','CHH'),('Cambodia','KH','Kampong Spoe','SPO'),('Cambodia','KH','Kampong Thum','THU'),('Cambodia','KH','Kampot','KAM'),('Cambodia','KH','Kandal','KAN'),('Cambodia','KH','Kaoh Kong','KAO'),('Cambodia','KH','Kracheh','KRA'),('Cambodia','KH','Mondol Kiri','MON'),('Cambodia','KH','Pouthisat','POU'),('Cambodia','KH','Preah Vihear','PRE'),('Cambodia','KH','Prey Veng','PRV'),('Cambodia','KH','Rotanah Kiri','ROT'),('Cambodia','KH','Siem Reab','SIE'),('Cambodia','KH','Stoeng Treng','STO'),('Cambodia','KH','Svay Rieng','SVA'),('Cambodia','KH','Takev','TAK'),('Cambodia','KH','Unknown','UNK'),('Cameroon','CM','Cameroon','CAM'),('Canada','CA','Alberta','AB'),('Canada','CA','British Columbia','BC'),('Canada','CA','Manitoba','MB'),('Canada','CA','New Brunswick','NB'),('Canada','CA','Newfoundland and Labrador','NF'),('Canada','CA','Northwest Territories','NT'),('Canada','CA','Nova Scotia','NS'),('Canada','CA','Nunavut','NU'),('Canada','CA','Ontario','ON'),('Canada','CA','Prince Edward Island','PE'),('Canada','CA','Quebec','QC'),('Canada','CA','Saskatchewan','SK'),('Canada','CA','Yukon','YT'),('Cape Verde','CV','Cape Verde','CPV'),('Cayman Islands','KY','Cayman Islands','CYN'),('Central African Republic','CF','Central African Republic','CAR'),('Chad','TD','Batha','BAT'),('Chad','TD','Biltine','BIL'),('Chad','TD','Borkou-Ennedi-Tibesti','BET'),('Chad','TD','Chari-Baguirmi','CHB'),('Chad','TD','Guera','GUE'),('Chad','TD','Kanem','KAN'),('Chad','TD','Lac','LAC'),('Chad','TD','Logone Occidental','LOC'),('Chad','TD','Logone Oriental','LOR'),('Chad','TD','Mayo-Kebbi','MAK'),('Chad','TD','Moyen-Chari','MOC'),('Chad','TD','Ouaddai','OUA'),('Chad','TD','Salamat','SAL'),('Chad','TD','Tandjile','TAN'),('Chile','CL','Aisen del General Carlos Ibanez del Campo','AIS'),('Chile','CL','Antofagasta','ANT'),('Chile','CL','Araucania','ARA'),('Chile','CL','Atacama','ATA'),('Chile','CL','Bio-Bio','BIO'),('Chile','CL','Coquimbo','COQ'),('Chile','CL','Libertador G.B. O\'Higgins','LIB'),('Chile','CL','Los Lagos','LAG'),('Chile','CL','Magallanes y de la Antartica Chilena','MAG'),('Chile','CL','Maule','MAU'),('Chile','CL','Region Metropolitana','MET'),('Chile','CL','Tarapaca','TAR'),('Chile','CL','Valparaiso','VAL'),('China','CN','Anhui','ANH'),('China','CN','Beijing Shi','BEJ'),('China','CN','Chongqing Shi','CHS'),('China','CN','Fujian','FUJ'),('China','CN','Gansu','GAN'),('China','CN','Guangdong','GUA'),('China','CN','Guangxi Zhuangzu','GUZ'),('China','CN','Guizhou','GUI'),('China','CN','Hainan','HAI'),('China','CN','Hebei','HEB'),('China','CN','Heilongjiang','HEI'),('China','CN','Henan','HEN'),('China','CN','Hubei','HUB'),('China','CN','Hunan','HUN'),('China','CN','Inner Mongolia','IMO'),('China','CN','Jiangsu','JIU'),('China','CN','Jiangxi','JII'),('China','CN','Jilin','JIN'),('China','CN','Liaoning','LIA'),('China','CN','Ningxia Huizu','NIH'),('China','CN','Qinghai','QIN'),('China','CN','Shaanxi','SHX'),('China','CN','Shandong','SHG'),('China','CN','Shanxi','SHI'),('China','CN','Sichuan','SIC'),('China','CN','Tibet','TIB'),('China','CN','Unknown','UNK'),('China','CN','Xinjiang Uygur','XIU'),('China','CN','Yunnan','YUN'),('China','CN','Zhejiang','ZHE'),('Christmas Island','CX','Christmas Island','CHI'),('Columbia','CO','Antioquia','ANT'),('Columbia','CO','Atlantico','ALT'),('Columbia','CO','Bogota','BOG'),('Columbia','CO','Bolivar','BOL'),('Columbia','CO','Cauca','CAU'),('Columbia','CO','Cundinamarca','CUN'),('Columbia','CO','Magdalena','MAG'),('Columbia','CO','Meta','MET'),('Columbia','CO','Santander','SAN'),('Columbia','CO','Valle del Cauca','VAL'),('Comoros','KM','Comoros','COM'),('Congo','CG','Bouenza','BOU'),('Congo','CG','Brazzaville','BRA'),('Congo','CG','Cuvette','CUV'),('Congo','CG','Kouilou','KOU'),('Congo','CG','Lekoumou','LEK'),('Congo','CG','Likouala','LIK'),('Congo','CG','Niari','NIA'),('Congo','CG','Plateaux','PLA'),('Congo','CG','Pool','POO'),('Congo','CG','Sangha','SAN'),('Cook Islands','CW','Cook Islands','CKI'),('Costa Rica','CR','Alajuela','ALA'),('Costa Rica','CR','Cartago','CAR'),('Costa Rica','CR','Guanacaste','GUA'),('Costa Rica','CR','Heredia','HER'),('Costa Rica','CR','Limon','LIM'),('Costa Rica','CR','Puntarenas','PUN'),('Costa Rica','CR','San Jose','SJO'),('Cote D\'Ivoire','CI','Cote D\'Ivoire','CDI'),('Croatia','HR','Bjelovarsko-Bilogorska','BJE'),('Croatia','HR','Brodsko-Posavska','BRO'),('Croatia','HR','Dubrovacko-Neretvanska','DUB'),('Croatia','HR','Grad Zagreb','GRA'),('Croatia','HR','Istarska','IST'),('Croatia','HR','Karlovacka','KAR'),('Croatia','HR','Koprivnicko-Krizevacka','KOP'),('Croatia','HR','Krapinsko-Zagorska','KRA'),('Croatia','HR','Licko-Senjska','LIC'),('Croatia','HR','Medimurska','MED'),('Croatia','HR','Osjecko-Baranjska','OSJ'),('Croatia','HR','Pozesko-Slavonska','POZ'),('Croatia','HR','Primorsko-Goranska','PRI'),('Croatia','HR','Sibensko-Kninska','SIB'),('Croatia','HR','Sisacko-Moslavacka','SIS'),('Croatia','HR','Splitsko-Dalmatinska','SPL'),('Croatia','HR','Varazdinska','VAR'),('Croatia','HR','Viroviticko-Podravska','VIR'),('Croatia','HR','Vukovarsko-Srijemska','VUK'),('Croatia','HR','Zagrebacka','ZAG'),('Cuba','CU','Camaguey','CAM'),('Cuba','CU','Ciego de Avila','CDA'),('Cuba','CU','Cienfuegos','CIE'),('Cuba','CU','Ciudad de la Habana','CLH'),('Cuba','CU','Granma','GRA'),('Cuba','CU','Guantanamo','GUA'),('Cuba','CU','Holguin','HOL'),('Cuba','CU','Isla de la Juventud','JUV'),('Cuba','CU','La Habana','HAB'),('Cuba','CU','Las Tunas','TUN'),('Cuba','CU','Matanzas','MAT'),('Cuba','CU','Pinar del Rio','PIN'),('Cuba','CU','Sancti Spiritus','SSP'),('Cuba','CU','Santiago de Cuba','SAN'),('Cuba','CU','Villa Clara','VIL'),('Cyprus','CY','Cyprus','CYP'),('Czech Republic','CZ','Czech Republic','CZE'),('Democratic Repubilic of Congo','CD','Bandundu','BAN'),('Democratic Repubilic of Congo','CD','Bas-Congo','BAS'),('Democratic Repubilic of Congo','CD','Equateur','EQU'),('Democratic Repubilic of Congo','CD','Kasai-Occidental','KOC'),('Democratic Repubilic of Congo','CD','Katanga','KAT'),('Democratic Repubilic of Congo','CD','Kinshasa','KIN'),('Democratic Repubilic of Congo','CD','Kivu','KIV'),('Democratic Repubilic of Congo','CD','Maniema','MAN'),('Democratic Repubilic of Congo','CD','Nord-Kivu','NKI'),('Democratic Repubilic of Congo','CD','Orientale','ORI'),('Democratic Repubilic of Congo','CD','Sud-Kivu','SKI'),('Denmark','DK','Arhus Amt','ARH'),('Denmark','DK','Bornholms Amt','BOR'),('Denmark','DK','Frederiksberg Kommune','FK'),('Denmark','DK','Frederiksborg Amt','FRE'),('Denmark','DK','Fyns Amt','FYN'),('Denmark','DK','Kobenhavns Amt','KOB'),('Denmark','DK','Kobenhavns Kommune','KK'),('Denmark','DK','Nordjyllands Amt','NJL'),('Denmark','DK','Ribe Amt','RIB'),('Denmark','DK','Ringkobing Amt','RIN'),('Denmark','DK','Roskilde Amt','ROS'),('Denmark','DK','Sonderjyllands Amt','SJL'),('Denmark','DK','Storstroms Amt','STO'),('Denmark','DK','Vejle Amt','VEJ'),('Denmark','DK','Vestsjaellands Amt','VSL'),('Denmark','DK','Viborg Amt','VIB'),('Djibouti','DJ','Djibouti','DJI'),('Dominica','DM','Dominica','DOM'),('Dominican Republic','DO','Azua','AZU'),('Dominican Republic','DO','Baoruco','BAH'),('Dominican Republic','DO','Barahona','BAR'),('Dominican Republic','DO','Dajabon','DAJ'),('Dominican Republic','DO','Distrito Nacional','DN'),('Dominican Republic','DO','Duarte','DUA'),('Dominican Republic','DO','El Seibo','ESE'),('Dominican Republic','DO','Elias Pina','EPA'),('Dominican Republic','DO','Espaillat','ESP'),('Dominican Republic','DO','Hato Mayor','HMA'),('Dominican Republic','DO','Independencia','IND'),('Dominican Republic','DO','La Altagracia','LAL'),('Dominican Republic','DO','La Romana','LRO'),('Dominican Republic','DO','La Vega','LVE'),('Dominican Republic','DO','Maria Trinidad Sanchez','MTS'),('Dominican Republic','DO','Monsenor Nouel','MSN'),('Dominican Republic','DO','Monte Cristi','MCR'),('Dominican Republic','DO','Monte Plata','MPL'),('Dominican Republic','DO','Pedernales','PED'),('Dominican Republic','DO','Peravia','PER'),('Dominican Republic','DO','Puerto Plata','PPL'),('Dominican Republic','DO','Salcedo','SAL'),('Dominican Republic','DO','Samana','SAM'),('Dominican Republic','DO','San Cristobal','SCR'),('Dominican Republic','DO','San Juan','SJU'),('Dominican Republic','DO','San Pedro de Macoris','SPM'),('Dominican Republic','DO','Sanchez Ramirez','SRA'),('Dominican Republic','DO','Santiago','SAN'),('Dominican Republic','DO','Santiago Rodriguez','SRO'),('Dominican Republic','DO','Valverde','VAL'),('East Timor','TL','East Timor','ETM'),('Ecuador','EC','Azuay','AZU'),('Ecuador','EC','Boliar','BOL'),('Ecuador','EC','Canar','CAN'),('Ecuador','EC','Carchi','CAR'),('Ecuador','EC','Chimborazo','CHI'),('Ecuador','EC','Cotopaxi','COT'),('Ecuador','EC','El Oro','EOR'),('Ecuador','EC','Esmeraldas','ESM'),('Ecuador','EC','Galapagos','GAL'),('Ecuador','EC','Guayas','GUA'),('Ecuador','EC','Imbabura','IMB'),('Ecuador','EC','Loja','LOJ'),('Ecuador','EC','Los Rios','LRI'),('Ecuador','EC','Manabi','MAN'),('Ecuador','EC','Morona-Santiago','MSA'),('Ecuador','EC','Napo','NAP'),('Ecuador','EC','Orellana','ORE'),('Ecuador','EC','Pastaza','PAS'),('Ecuador','EC','Pichincha','PIC'),('Ecuador','EC','Sucumbios','SUC'),('Ecuador','EC','Zamora-Chinchipe','ZCH'),('Egypt','EG','Ad-Daqahiyah','DAQ'),('Egypt','EG','Al-Bahr al-Ahmar','BAH'),('Egypt','EG','Al-Buhayrah','BUH'),('Egypt','EG','Al-Fayyum','FAY'),('Egypt','EG','Al-Gharbiyah','GHA'),('Egypt','EG','Al-Iskandariyah','ISK'),('Egypt','EG','Al-Isma\'iliyah','ISM'),('Egypt','EG','Al-Jizah','JIZ'),('Egypt','EG','Al-Minufiyah','MNF'),('Egypt','EG','Al-Minya','MIN'),('Egypt','EG','Al-Qahirah','QAH'),('Egypt','EG','Al-Qalyubyah','QAL'),('Egypt','EG','Al-Wadi al-Jadid','WJA'),('Egypt','EG','As-Suways','SUW'),('Egypt','EG','Ash-Sharqiyah','SHA'),('Egypt','EG','Aswan','ASW'),('Egypt','EG','Asyut','ASY'),('Egypt','EG','Bani Suwayf','BSU'),('Egypt','EG','Bur Sa\'id','BSA'),('Egypt','EG','Dumyat','DUM'),('Egypt','EG','Kafr ash-Shaykh','KSH'),('Egypt','EG','Marsa Matruh','MMA'),('Egypt','EG','Qina','QIN'),('Egypt','EG','Sawhaj','SAW'),('Egypt','EG','Sina\' al-Janubiyah','SJA'),('Egypt','EG','Sina\' ash-Shamaliyah','SSH'),('El Salvador','SV','Ahuachapan','AHU'),('El Salvador','SV','Cabanas','CAB'),('El Salvador','SV','Chalatenango','CHA'),('El Salvador','SV','Cuscatlan','CUS'),('El Salvador','SV','La Libertad','LLI'),('El Salvador','SV','La Paz','LPA'),('El Salvador','SV','La Union','LUN'),('El Salvador','SV','Morazan','MOR'),('El Salvador','SV','San Miguel','SMI'),('El Salvador','SV','San Salvador','SSA'),('El Salvador','SV','San Vicente','SVI'),('El Salvador','SV','Santa Ana','SAN'),('El Salvador','SV','Sonsonate','SON'),('El Salvador','SV','Usulutan','USU'),('Equatorial Guinea','GQ','Equatorial Guinea','EQG'),('Eritrea','ER','Eritrea','ERI'),('Estonia','EE','Estonia','EST'),('Ethiopia','ET','Ethiopia','ETH'),('Falkland Islands','FK','Falkland Islands','FAL'),('Faroe Islands','FO','Faroe Islands','FAR'),('Fiji','FJ','Fiji','FIJ'),('Finland','FI','Alands Lan','ALA'),('Finland','FI','Lapplands Lan','LPA'),('Finland','FI','Ostra Finlands Lan','OST'),('Finland','FI','Sodra Finlands Lan','SOD'),('Finland','FI','Uleaborgs Lan','ULE'),('Finland','FI','Vastra Finlands Lan','VAS'),('France','FR','Alsace','ALS'),('France','FR','Aquitaine','AQU'),('France','FR','Auvergne','AUV'),('France','FR','Basse-Normandie','BAS'),('France','FR','Bourgogne','BOU'),('France','FR','Bretagne','BRE'),('France','FR','Centre','CEN'),('France','FR','Champagne-Ardenne','CHA'),('France','FR','Corse','COR'),('France','FR','Franche-Comte','FRA'),('France','FR','Haute-Normandie','HAU'),('France','FR','Ile-de-France','ILE'),('France','FR','Languedoc-Roussillon','LAN'),('France','FR','Limousin','LIM'),('France','FR','Lorraine','LOR'),('France','FR','Midi-Pyrenees','MID'),('France','FR','Nord-Pas-de-Calais','NOR'),('France','FR','Pays-de-la Loire','PAY'),('France','FR','Picardie','PIC'),('France','FR','Poitou-Charentes','POI'),('France','FR','Provence-Alpes-Cote d\'Azur','PRO'),('France','FR','Rhooe-Alpes','RHO'),('France','FR','Unknown','UNK'),('French Guiana','GF','French Guiana','FGU'),('French Polynesia','FP','French Polynesia','FPY'),('Gabon','GA','Gabon','GAB'),('Gambia','GM','Gambia','GAM'),('Georgia','GE','Georgia','GEO'),('Germany','DE','Baden-Wurttemberg','BW'),('Germany','DE','Bayern','BY'),('Germany','DE','Berlin','BE'),('Germany','DE','Brandenburg','BB'),('Germany','DE','Bremen','HB'),('Germany','DE','Hamburg','HH'),('Germany','DE','Hessen','HE'),('Germany','DE','Mecklenburg-Vorpommern','MV'),('Germany','DE','Niedersachsen','NI'),('Germany','DE','Nordrhein-Westfalen','NW'),('Germany','DE','Rheinland-Pfalz','RP'),('Germany','DE','Saarland','SL'),('Germany','DE','Sachsen','SN'),('Germany','DE','Sachsen-Anhalt','ST'),('Germany','DE','Schleswig-Holstein','SH'),('Germany','DE','Thuringen','TH'),('Ghana','GH','Kumasi','KUI'),('Ghana','GH','Sunyani','SUI'),('Ghana','GH','Cape Coast','CAT'),('Ghana','GH','Koforidua','KOA'),('Ghana','GH','Accra','ACA'),('Ghana','GH','Tamale','TAE'),('Ghana','GH','Bolgatanga','BOA'),('Ghana','GH','Wa','Wa'),('Ghana','GH','Ho','Ho'),('Ghana','GH','Sekondi-Takoradi','STI'),('Gibraltar','GI','Gibraltar','GIB'),('Greece','GR','Aegean Islands','AIY'),('Greece','GR','Attiki','ATT'),('Greece','GR','Central Greece & Evvoia','SEE'),('Greece','GR','Crete','KRI'),('Greece','GR','Epirus','IPI'),('Greece','GR','Ionia Islands','ION'),('Greece','GR','Macedonia','MAK'),('Greece','GR','Peloponnesus','PEL'),('Greece','GR','Thessalia','THE'),('Greece','GR','Thrace','THR'),('Greenland','GL','Greenland','GL'),('Grenada','GD','Grenada','GJ'),('Guadeloupe','GP','Guadeloupe','GUA'),('Guatemala','GT','Alta Verapaz','AVE'),('Guatemala','GT','Baja Verapaz','BVE'),('Guatemala','GT','Chimaltenango','CMT'),('Guatemala','GT','Chiquimula','CQM'),('Guatemala','GT','El Progreso','EPR'),('Guatemala','GT','Escuintla','ESC'),('Guatemala','GT','Guatemala','GUA'),('Guatemala','GT','Huehuetenango','HUE'),('Guatemala','GT','Izabal','IZA'),('Guatemala','GT','Jalapa','JAL'),('Guatemala','GT','Jutiapa','JUT'),('Guatemala','GT','Peten','PET'),('Guatemala','GT','Quetzaltenango','QUE'),('Guatemala','GT','Quiche','QUI'),('Guatemala','GT','Retalhuleu','RET'),('Guatemala','GT','Sacatepequez','SAC'),('Guatemala','GT','San Marcos','SMA'),('Guatemala','GT','Santa Rosa','SRO'),('Guatemala','GT','Solola','SOL'),('Guatemala','GT','Suchitepequez','SUC'),('Guatemala','GT','Totonicapan','TOT'),('Guatemala','GT','Zacapa','ZAC'),('Guernsey','GG','Guernsey','GUR'),('Guinea','GN','Guinea','GUI'),('Guinea-Bissau','GW','Guinea-Bissau','GUB'),('Guyana','GY','Guyana','GUY'),('Haiti','HT','Haiti','HAI'),('Honduras','HN','Atlantida','ATL'),('Honduras','HN','Choluteca','CHO'),('Honduras','HN','Colon','COL'),('Honduras','HN','Comayagua','COM'),('Honduras','HN','Copan','COP'),('Honduras','HN','El Paraiso','EPA'),('Honduras','HN','Francisco Morazan','FMO'),('Honduras','HN','Gracias a Dios','GAD'),('Honduras','HN','Intibuca','INT'),('Honduras','HN','Islas de la Bahia','IBA'),('Honduras','HN','La Paz','LPA'),('Honduras','HN','Lempira','LEM'),('Honduras','HN','Ocotepeque','OCO'),('Honduras','HN','Olancho','OLA'),('Honduras','HN','Santa Barbara','SBA'),('Honduras','HN','Valle','VAL'),('Honduras','HN','Yoro','YOR'),('Hungary','HU','Bacs-Kiskun Megye','BAC'),('Hungary','HU','Baranya Megye','BAR'),('Hungary','HU','Bekes Megye','BEK'),('Hungary','HU','Borsod-Abauj-Zemplen Megye','BOR'),('Hungary','HU','Budapest Fovaros','BUD'),('Hungary','HU','Csongrad Megye','CSO'),('Hungary','HU','Debrecen Megyei Varos','DEB'),('Hungary','HU','Fejer Megye','FEJ'),('Hungary','HU','Gyor Megyei Varos','GYO'),('Hungary','HU','Gyor-Moson-Sopron Megye','GYO'),('Hungary','HU','Hajdu-Bihar Megye','HAJ'),('Hungary','HU','Heves Megye','HEV'),('Hungary','HU','Jasz-Nagykun-Szolnok Megye','JAS'),('Hungary','HU','Komarom-Esztergom Megye','KOM'),('Hungary','HU','Miskolc Megyei Varos','MIS'),('Hungary','HU','Nograd Megye','NOG'),('Hungary','HU','Pecs Megyei Varos','PEC'),('Hungary','HU','Pest Megye','PES'),('Hungary','HU','Somogy Megye','SOM'),('Hungary','HU','Szabolcs-Szatmar-Bereg Megye','SZA'),('Hungary','HU','Szeged Megyei Varos','SZE'),('Hungary','HU','Tolna Megye','TOL'),('Hungary','HU','Vas Megye','VAS'),('Hungary','HU','Veszprem Megye','VES'),('Hungary','HU','Zala Megye','ZAL'),('Iceland','IS','Arnessysla','ARN'),('Iceland','IS','Austur-Bardhastrandarsysla','ABA'),('Iceland','IS','Austur-Hunavatnssysla','AHU'),('Iceland','IS','Austur-Skaftafellssysla','ASK'),('Iceland','IS','Borgarfjardharsysla','BOR'),('Iceland','IS','Dalasysla','DAL'),('Iceland','IS','Eyjafjardharsysla','EYJ'),('Iceland','IS','Gullbringusysla','GUL'),('Iceland','IS','Kjosarsysla','KJY'),('Iceland','IS','Myrasysla','MYR'),('Iceland','IS','Nordhur-Isafjardharsysla','NIS'),('Iceland','IS','Nordhur-Mulasysla','NMU'),('Iceland','IS','Nordhur-Thingeyjarsysla','NTY'),('Iceland','IS','Rangarvallasysla','RNG'),('Iceland','IS','Skagafjardharsysla','SKA'),('Iceland','IS','Snaefellsnessysla- og Hnappadalssysla','SHN'),('Iceland','IS','Strandasysla','STR'),('Iceland','IS','Sudhur-Mulasysla','SMU'),('Iceland','IS','Sudhur-Thingeijjar','STI'),('Iceland','IS','Vestur-Bardhastrandarsysla','VBA'),('Iceland','IS','Vestur-Hunavatnssysla','VHU'),('Iceland','IS','Vestur-Isafjardharsysla','VIS'),('Iceland','IS','Vestur-Skaftafellssysla','VSK'),('India','IN','Andaman & Nicobar Islands','ANI'),('India','IN','Andhra Pradesh','AND'),('India','IN','Arunachal Pradesh','ARU'),('India','IN','Assam','ASS'),('India','IN','Bihar','BIH'),('India','IN','Chandigarh','CHA'),('India','IN','Dadra & Nagar Haveli','DAD'),('India','IN','Delhi','DEL'),('India','IN','Goa','GOA'),('India','IN','Gujarat','GUJ'),('India','IN','Haryana','HAR'),('India','IN','Himachal Pradesh','HIM'),('India','IN','Jammu & Kashmir','JAM'),('India','IN','Jharkhand','JHA'),('India','IN','Karnataka','KAR'),('India','IN','Kerala','KER'),('India','IN','Lakshadweep','LAK'),('India','IN','Madhya Pradesh','MAD'),('India','IN','Maharashtra','MAH'),('India','IN','Manipur','MAN'),('India','IN','Meghalaya','MEG'),('India','IN','Mizoram','MIZ'),('India','IN','Nagaland','NAG'),('India','IN','Orissa','ORI'),('India','IN','Pondicherry','PON'),('India','IN','Punjab','PUN'),('India','IN','Rajasthan','RAJ'),('India','IN','Sikkim','SIK'),('India','IN','Tamil Nadu','TAM'),('India','IN','Tripura','TRI'),('India','IN','Uttar Pradesh','UTT'),('India','IN','Uttaranchal','UAR'),('India','IN','West Bengal','WES'),('Indonesia','ID','Aceh','ACE'),('Indonesia','ID','Bali','BAL'),('Indonesia','ID','Bengkulu','BEN'),('Indonesia','ID','Jambi','JAM'),('Indonesia','ID','Jawa Barat','JBA'),('Indonesia','ID','Jawa Tengah','JTE'),('Indonesia','ID','Jawa Timur','JTI'),('Indonesia','ID','Kalimantan Barat','BAR'),('Indonesia','ID','Kalimantan Selatan','SEL'),('Indonesia','ID','Kalimantan Tengah','TEN'),('Indonesia','ID','Kalimantan Timur','TIM'),('Indonesia','ID','Lampung','LAM'),('Indonesia','ID','Maluku','MAL'),('Indonesia','ID','Nusa Tenggara Barat','NTB'),('Indonesia','ID','Nusa Tenggara Timur','NTT'),('Indonesia','ID','Papua','PAP'),('Indonesia','ID','Riau','RIA'),('Indonesia','ID','Sulawesi Selatan','SSE'),('Indonesia','ID','Sulawesi Tengah','STE'),('Indonesia','ID','Sulawesi Tenggara','STG'),('Indonesia','ID','Sulawesi Utara','SLU'),('Indonesia','ID','Sumatera Barat','SBA'),('Indonesia','ID','Sumatera Utara','SUT'),('Indonesia','ID','Unknown','UNK'),('Indonesia','ID','Yogyakarta','YOG'),('Iran','IR','a Baluchestan','BAL'),('Iran','IR','ahall va Bakhtiari','BAK'),('Iran','IR','an-e Gharbi','GHA'),('Iran','IR','an-e Sharqi','SHA'),('Iran','IR','eh va Buyer Ahmad','KOH'),('Iran','IR','n','KOR'),('Iran','IR','n','KHU'),('Iran','IR','n','HOR'),('Iraq','IQ','Anbar','ANB'),('Iraq','IQ','Arbil','ARB'),('Iraq','IQ','Babil','BAB'),('Iraq','IQ','Baghdad','BAG'),('Iraq','IQ','Basrah','BAS'),('Iraq','IQ','Dahuk','DAH'),('Iraq','IQ','Dhi Qar','DHI'),('Iraq','IQ','Diyala','DIY'),('Iraq','IQ','Karbala\'','KAR'),('Iraq','IQ','Maysan','MAY'),('Iraq','IQ','Muthanna','MUT'),('Iraq','IQ','Najaf','NAJ'),('Iraq','IQ','Ninawa','NIN'),('Iraq','IQ','Qadisiyah','QAD'),('Iraq','IQ','Salah ad Din','SAL'),('Iraq','IQ','Sulaymaniyah','SUL'),('Iraq','IQ','Ta\'mim','TAM'),('Iraq','IQ','Wasit','WAS'),('Ireland','IE','Carlow','CAR'),('Ireland','IE','Cavan','CAV'),('Ireland','IE','Clare','CLA'),('Ireland','IE','Cork','COR'),('Ireland','IE','Donegal','DON'),('Ireland','IE','Dublin','DUB'),('Ireland','IE','Galway','GAL'),('Ireland','IE','Kerry','KRY'),('Ireland','IE','Kildare','KID'),('Ireland','IE','Kilkenny','KIK'),('Ireland','IE','Laois','LAO'),('Ireland','IE','Leitrim','LEI'),('Ireland','IE','Limerick','LIM'),('Ireland','IE','Longford','LON'),('Ireland','IE','Louth','LOU'),('Ireland','IE','Mayo','MAY'),('Ireland','IE','Meath','MEA'),('Ireland','IE','Monaghan','MON'),('Ireland','IE','Offaly','OFF'),('Ireland','IE','Roscommon','ROS'),('Ireland','IE','Sligo','SLI'),('Ireland','IE','Tipperary','TIP'),('Ireland','IE','Unknown','UNK'),('Ireland','IE','Waterford','WAT'),('Ireland','IE','Westmeath','WES'),('Ireland','IE','Wexford','WEX'),('Ireland','IE','Wicklow','WIC'),('Isle of Man','IM','Isle of Man','IOM'),('Israel','IL','Central District','CEN'),('Israel','IL','Haifa District','HAF'),('Israel','IL','Jerusalem District','JER'),('Israel','IL','Northern District','HAF'),('Israel','IL','Southern District','MEH'),('Israel','IL','Tel Aviv District','TEL'),('Italy','IT','Abruzzi','ABR'),('Italy','IT','Basilicata','BAS'),('Italy','IT','Calabria','CAL'),('Italy','IT','Campania','CAM'),('Italy','IT','Emilia-Romagna','EMI'),('Italy','IT','Friuli-Venezia Giulia','FRI'),('Italy','IT','Lazio','LAZ'),('Italy','IT','Liguria','LIG'),('Italy','IT','Lombardia','LOM'),('Italy','IT','Marche','MAR'),('Italy','IT','Molise','MOL'),('Italy','IT','Piemonte','PIE'),('Italy','IT','Puglia','PUG'),('Italy','IT','Sardegna','SAR'),('Italy','IT','Sicilia','SIC'),('Italy','IT','Toscana','TOS'),('Italy','IT','Trentino-Alto Adige','TRE'),('Italy','IT','Umbria','UMB'),('Italy','IT','Valle d\'Aosta','VDA'),('Italy','IT','Veneto','VEN'),('Jamaica','JM','Clarendon','CLA'),('Jamaica','JM','Hanover','HAN'),('Jamaica','JM','Kingston','KIN'),('Jamaica','JM','Manchester','MAN'),('Jamaica','JM','Portland','POR'),('Jamaica','JM','Saint Andrews','AND'),('Jamaica','JM','Saint Ann','ANN'),('Jamaica','JM','Saint Catherine','CAT'),('Jamaica','JM','Saint Elizabeth','ELI'),('Jamaica','JM','Saint James','JAM'),('Jamaica','JM','Saint Mary','MAR'),('Jamaica','JM','Saint Thomas','THO'),('Jamaica','JM','Trelawny','TRE'),('Jamaica','JM','Westmoreland','WML'),('Japan','JP','Aichi','AIC'),('Japan','JP','Akita','AKI'),('Japan','JP','Aomori','AOM'),('Japan','JP','Chiba','CHI'),('Japan','JP','Ehime','EHI'),('Japan','JP','Fukui','FUI'),('Japan','JP','Fukuoka','FUA'),('Japan','JP','Fukushima','FUM'),('Japan','JP','Gifu','GIF'),('Japan','JP','Gumma','GUM'),('Japan','JP','Hiroshima','HIR'),('Japan','JP','Hokkaido','HOK'),('Japan','JP','Hyogo','HYO'),('Japan','JP','Ibaraki','IBA'),('Japan','JP','Ishikawa','ISH'),('Japan','JP','Iwate','IWA'),('Japan','JP','Kagawa','KAG'),('Japan','JP','Kagoshima','KAM'),('Japan','JP','Kanagawa','KAN'),('Japan','JP','Kochi','KOC'),('Japan','JP','Kumamoto','KUM'),('Japan','JP','Kyoto','KYO'),('Japan','JP','Mie','MIE'),('Japan','JP','Miyagi','MIG'),('Japan','JP','Miyazaki','MIZ'),('Japan','JP','Nagano','NAG'),('Japan','JP','Nagasaki','NAK'),('Japan','JP','Nara','NAR'),('Japan','JP','Niigata','NII'),('Japan','JP','Oita','OIT'),('Japan','JP','Okayama','OKA'),('Japan','JP','Okinawa','OKI'),('Japan','JP','Osaka','OSA'),('Japan','JP','Saga','SAG'),('Japan','JP','Saitama','SAI'),('Japan','JP','Shiga','SHG'),('Japan','JP','Shimane','SHM'),('Japan','JP','Shizuoka','SHZ'),('Japan','JP','Tochigi','TOC'),('Japan','JP','Tokushima','TOK'),('Japan','JP','Tokyo','TOY'),('Japan','JP','Tottori','TOT'),('Japan','JP','Toyama','TYM'),('Japan','JP','Wakayama','WAK'),('Japan','JP','Yamagata','YMT'),('Japan','JP','Yamaguchi','YMG'),('Japan','JP','Yamanashi','YMN'),('Jersey','JE','Jersey','JER'),('Jordan','JO','Jordan','JOR'),('Kazakhstan','KZ','Kazakhstan','KAZ'),('Kenya','KE','Central','CEN'),('Kenya','KE','Coast','CST'),('Kenya','KE','Eastern','EST'),('Kenya','KE','Nairobi','NAI'),('Kenya','KE','North Eastern','NEA'),('Kenya','KE','Nyanza','NYA'),('Kenya','KE','Rift Valley','RVY'),('Kenya','KE','Western','WST'),('Kiribati','KI','Kiribati','KIR'),('Kuwait','KW','Al-Ahmadi','AHM'),('Kuwait','KW','Al-Farwaniyah','FAR'),('Kuwait','KW','Al-Kuwayt','KUW'),('Kuwait','KW','Bubiyan & Warbah','BUB'),('Kuwait','KW','Hawalli','HAW'),('Kyrgyzstan','KG','Kyrgyzstan','KYR'),('Laos','LA','Laos','LAO'),('Latvia','LV','Latvia','LAT'),('Lebanon','LB','Lebanon','LEB'),('Lesotho','LS','Lesotho','LES'),('Liberia','LR','Liberia','LIB'),('Libya','LY','Libya','LIB'),('Liechtenstein','LI','Liechtenstein','LIE'),('Lithuania','LT','Lithuania','LIT'),('Luxembourg','LU','Luxembourg','LUX'),('Macau','MA','Macau','MAC'),('Macedonia','MK','Macedonia','MAC'),('Madagascar','MG','Antananarivo','ANT'),('Madagascar','MG','Antsiranana','ASI'),('Madagascar','MG','Fianarantsoa','FIA'),('Madagascar','MG','Mahajanga','MAH'),('Madagascar','MG','Toamasina','TOA'),('Madagascar','MG','Toliary','TOL'),('Malawi','MW','Malawi','MAL'),('Malaysia','MY','Johor','JOH'),('Malaysia','MY','Kedah','KED'),('Malaysia','MY','Kelantan','KEL'),('Malaysia','MY','Melaka','MEL'),('Malaysia','MY','Pahang','PAH'),('Malaysia','MY','Perak','PER'),('Malaysia','MY','Perlis','PES'),('Malaysia','MY','Pulau Pinang','PIN'),('Malaysia','MY','Sabah','SAB'),('Malaysia','MY','Sarawak','SAR'),('Malaysia','MY','Selangor','SEL'),('Malaysia','MY','Sembilan','SEM'),('Malaysia','MY','Terengganu','TER'),('Malaysia','MY','Unknown','UNK'),('Malaysia','MY','Wilayah Persekutuan','WIL'),('Maldives','MV','Maldives','MAL'),('Mali','ML','Mali','MAL'),('Malta','MT','Malta','MAL'),('Marshall Islands','MH','Marshall Islands','MRI'),('Martinique','MB','Martinique','MAR'),('Mauritania','MR','Mauritania','MAU'),('Mauritius','MU','Mauritius','MAU'),('Mayotte','YT','Mayotte','MAY'),('Mexico','MX','Aguascalientes','AGS'),('Mexico','MX','Baja California','BCN'),('Mexico','MX','Baja California Sur','BCS'),('Mexico','MX','Campeche','CAM'),('Mexico','MX','Chiapas','CHS'),('Mexico','MX','Chihuahua','CHI'),('Mexico','MX','Coahuila','COA'),('Mexico','MX','Colima','COL'),('Mexico','MX','Distrito Federal','DF'),('Mexico','MX','Durango','DGO'),('Mexico','MX','Guanajuato','GTO'),('Mexico','MX','Guerrero','GRO'),('Mexico','MX','Hidalgo','HGO'),('Mexico','MX','Jalisco','JAL'),('Mexico','MX','Mexico','MEX'),('Mexico','MX','Michoacan de Ocampo','MIC'),('Mexico','MX','Morelos','MOR'),('Mexico','MX','Nayarit','NAY'),('Mexico','MX','Nuevo Leon','NLN'),('Mexico','MX','Oaxaca','OAX'),('Mexico','MX','Puebla','PUE'),('Mexico','MX','Queretaro de Arteaga','QRO'),('Mexico','MX','Quintana Roo','QTR'),('Mexico','MX','San Luis Potosi','SLP'),('Mexico','MX','Sinaloa','SIN'),('Mexico','MX','Sonora','SON'),('Mexico','MX','Tabasco','TAB'),('Mexico','MX','Tamaulipas','TAM'),('Mexico','MX','Tlaxcala','TLA'),('Mexico','MX','Veracruz-Llave','VER'),('Mexico','MX','Yucatan','YUC'),('Mexico','MX','Zacatecas','ZAC'),('Micronesia','FM','Micronesia','MIC'),('Moldova','MD','Moldova','MOL'),('Monaco','MC','Monaco','MON'),('Mongolia','MN','Mongolia','MNG'),('Montserrat','MS','Montserrat','MON'),('Morocco','MA','Chaouia-Ouardigha','CHO'),('Morocco','MA','Doukkala-Abda','DOA'),('Morocco','MA','Fes-Boulemane','FEB'),('Morocco','MA','Gharb-Chrarda-Beni Hsen','GCB'),('Morocco','MA','Grand Casablanca','CAS'),('Morocco','MA','Marrakech-Tensift-El Haouz','MTH'),('Morocco','MA','Meknes-Tafilalt','MET'),('Morocco','MA','Rabat-Sale-Zemmour-Zaer','RSZ'),('Morocco','MA','Sous-Massa-Draa','SMD'),('Morocco','MA','Tanger-Tetouan','TAT'),('Morocco','MA','Taza-Al Hoceima-Taounate','THT'),('Mozambique','MZ','Mozambique','MOZ'),('Myanmar','MM','Ayeyarwady','AYE'),('Myanmar','MM','Bago','BAG'),('Myanmar','MM','Chin','CHI'),('Myanmar','MM','Kachin','KAC'),('Myanmar','MM','Kayah','KAH'),('Myanmar','MM','Kayin','KAN'),('Myanmar','MM','Magway','MAG'),('Myanmar','MM','Mandalay','MAN'),('Myanmar','MM','Mon','MON'),('Myanmar','MM','Rakhine','RAK'),('Myanmar','MM','Sagaing','SAG'),('Myanmar','MM','Shan','SHA'),('Myanmar','MM','Tanintharyi','TAN'),('Myanmar','MM','Unknown','UNK'),('Namibia','NA','Namibia','NAM'),('Nauru','NR','Nauru','NAU'),('Nepal','NP','Nepal','NEP'),('Netherlands','NL','Drenthe','DRE'),('Netherlands','NL','Flevoland','FLE'),('Netherlands','NL','Friesland','FRI'),('Netherlands','NL','Gelderland','GEL'),('Netherlands','NL','Groningen','GRO'),('Netherlands','NL','Limburg','LIM'),('Netherlands','NL','Noord-Brabant','NBR'),('Netherlands','NL','Noord-Holland','NHL'),('Netherlands','NL','Overijssel','OVE'),('Netherlands','NL','Utrecht','UTR'),('Netherlands','NL','Zeeland','ZEE'),('Netherlands','NL','Zuid-Holland','ZHO'),('Netherlands Antilles','AN','Netherlands Antilles','NTA'),('New Caledonia','NC','New Caledonia','NWC'),('New Zealand','NZ','Chatham Islands','CHI'),('New Zealand','NZ','North Island','NIS'),('New Zealand','NZ','South Island','SIS'),('New Zealand','NZ','Stewart Island','STI'),('Nicaragua','NI','Atlantico Norte','ATN'),('Nicaragua','NI','Atlantico Sur','ATS'),('Nicaragua','NI','Boaco','BOA'),('Nicaragua','NI','Carazo','CAR'),('Nicaragua','NI','Chinandega','CHI'),('Nicaragua','NI','Chontales','CHO'),('Nicaragua','NI','Esteli','EST'),('Nicaragua','NI','Granada','GRA'),('Nicaragua','NI','Jinotega','JIN'),('Nicaragua','NI','Leon','LEO'),('Nicaragua','NI','Madriz','MAD'),('Nicaragua','NI','Managua','MAN'),('Nicaragua','NI','Masaya','MAS'),('Nicaragua','NI','Matagalpa','MAT'),('Nicaragua','NI','Nueva Segovia','NSE'),('Nicaragua','NI','Rio San Juan','RSJ'),('Nicaragua','NI','Rivas','RIV'),('Niger','NE','Agadez','AGA'),('Niger','NE','Diffa','DIF'),('Niger','NE','Dosso','DOS'),('Niger','NE','Maradi','MAR'),('Niger','NE','Niamey','NIA'),('Niger','NE','Tahoua','TAH'),('Niger','NE','Tillaberi','TIL'),('Niger','NE','Zinder','ZIN'),('Nigeria','NG','Abuja','FC'),('Nigeria','NG','Adamawa','AD'),('Nigeria','NG','Bauchi','BA'),('Nigeria','NG','Benue','BE'),('Nigeria','NG','Borno','BO'),('Nigeria','NG','Delta','DE'),('Nigeria','NG','Gombe','GO'),('Nigeria','NG','Gongola','UNK'),('Nigeria','NG','Jigawa','JI'),('Nigeria','NG','Kaduna','KD'),('Nigeria','NG','Kano','KN'),('Nigeria','NG','Katsina','KT'),('Nigeria','NG','Kwara','KW'),('Nigeria','NG','Lagos','LA'),('Nigeria','NG','Nassarawa','NA'),('Nigeria','NG','Niger','NI'),('Nigeria','NG','Ogun','OG'),('Nigeria','NG','Oyo','OY'),('Nigeria','NG','Plateau','PL'),('Nigeria','NG','Sokoto','SO'),('Nigeria','NG','Unknown','UNK'),('Nigeria','NG','Zamfara','ZA'),('Niue','NU','Niue','NIU'),('Norfolk Island','NF','Norfolk Island','NFI'),('North Korea','KP','Chagang-do','CHA'),('North Korea','KP','Hamgyong-bukto','HYP'),('North Korea','KP','Hamgyong-namdo','HYN'),('North Korea','KP','Hwanghae-bukto','HWP'),('North Korea','KP','Hwanghae-namdo','HWN'),('North Korea','KP','Kaesong-si','KAE'),('North Korea','KP','Kangwon-do','KAN'),('North Korea','KP','Najin Sonbong-si','HAM'),('North Korea','KP','Namp\'o-si','NAM'),('North Korea','KP','P\'yongan-bukto','PYP'),('North Korea','KP','P\'yongan-namdo','PYN'),('North Korea','KP','P\'yongyang-si','PYY'),('North Korea','KP','Yanggang-do','YAN'),('Norway','NO','Akershus','AKE'),('Norway','NO','Aust-Agder','AAG'),('Norway','NO','Buskerud','BUS'),('Norway','NO','Finnmark','FIN'),('Norway','NO','Hedmark','HED'),('Norway','NO','Hordaland','HOR'),('Norway','NO','More og Romsdal','MOR'),('Norway','NO','Nord-Trondelag','NTR'),('Norway','NO','Nordland','NOR'),('Norway','NO','Oppland','OPP'),('Norway','NO','Oslo','OSL'),('Norway','NO','Ostfold','OFO'),('Norway','NO','Rogaland','ROG'),('Norway','NO','Sogn og Fjordane','SOF'),('Norway','NO','Sor-Trondelag','STR'),('Norway','NO','Telemark','TEL'),('Norway','NO','Troms','TRO'),('Norway','NO','Vest-Agder','VAG'),('Norway','NO','Vestfold','VFO'),('Oman','OM','Oman','OMN'),('Pakistan','PK','Balochistan','BAL'),('Pakistan','PK','Federally Administered Tribal Areas','TA'),('Pakistan','PK','Islamabad Capital Territory','FCA'),('Pakistan','PK','North-West Frontier Province','NWF'),('Pakistan','PK','Punjab','PUN'),('Pakistan','PK','Sind','SIN'),('Palau','PW','Palau','PAL'),('Panama','PA','Bocas del Toro','BDT'),('Panama','PA','Chiriqui','CHI'),('Panama','PA','Colon','COL'),('Panama','PA','Darien','DAR'),('Panama','PA','Herrera','HER'),('Panama','PA','Kuna Yala','KYA'),('Panama','PA','Los Santos','LSA'),('Panama','PA','Panama','PAN'),('Panama','PA','Veraguas','VER'),('Papua New Guinea','PG','Papua New Guinea','PNG'),('Paraguay','PY','Alto Paraguay','APG'),('Paraguay','PY','Alto Parana','APR'),('Paraguay','PY','Amambay','AMA'),('Paraguay','PY','Boqueron','BOQ'),('Paraguay','PY','Caaguazu','CGZ'),('Paraguay','PY','Caazapa','CZP'),('Paraguay','PY','Canindeyu','CAN'),('Paraguay','PY','Central','CEN'),('Paraguay','PY','Concepcion','CON'),('Paraguay','PY','Cordillera','COR'),('Paraguay','PY','Guaira','GUA'),('Paraguay','PY','Itapua','ITA'),('Paraguay','PY','Misiones','MIS'),('Paraguay','PY','Neembucu','NEE'),('Paraguay','PY','Paraguari','PAR'),('Paraguay','PY','Presidente Hayes','PHA'),('Paraguay','PY','San Pedro','SPE'),('Peru','PE','Amazonas','AMA'),('Peru','PE','Ancash','ANC'),('Peru','PE','Apurimac','APU'),('Peru','PE','Arequipa','ARE'),('Peru','PE','Ayacucho','AYA'),('Peru','PE','Cajamarca','CAJ'),('Peru','PE','Callao','CAL'),('Peru','PE','Cusco','CUS'),('Peru','PE','Huancavelica','HUA'),('Peru','PE','Huanuco','HUO'),('Peru','PE','Ica','ICA'),('Peru','PE','Junin','JUN'),('Peru','PE','La Libertad','LIB'),('Peru','PE','Lambayeque','LAM'),('Peru','PE','Lima','LIM'),('Peru','PE','Loreto','LOR'),('Peru','PE','Madre de Dios','MAD'),('Peru','PE','Moquegua','MOQ'),('Peru','PE','Pasco','PAS'),('Peru','PE','Piura','PIU'),('Peru','PE','Puno','PUN'),('Peru','PE','San Martin','MAR'),('Peru','PE','Tacna','TAC'),('Peru','PE','Tumbes','TUM'),('Peru','PE','Ucayali','UCA'),('Philippines','PH','Abra','01'),('Philippines','PH','Agusan del Norte','02'),('Philippines','PH','Agusan del Sur','03'),('Philippines','PH','Aklan','04'),('Philippines','PH','Albay','05'),('Philippines','PH','Angeles City','A1'),('Philippines','PH','Antique','06'),('Philippines','PH','Aurora','G8'),('Philippines','PH','Bacolod City','A2'),('Philippines','PH','Bago City','A3'),('Philippines','PH','Baguio City','A4'),('Philippines','PH','Basilan','22'),('Philippines','PH','Bataan','07'),('Philippines','PH','Batanes','08'),('Philippines','PH','Batangas','09'),('Philippines','PH','Batangas City','A7'),('Philippines','PH','Benguet','10'),('Philippines','PH','Bohol','11'),('Philippines','PH','Bukidnon','12'),('Philippines','PH','Bulacan','13'),('Philippines','PH','Butuan City','A8'),('Philippines','PH','Cabanatuan City','A9'),('Philippines','PH','Cadiz City','B1'),('Philippines','PH','Cagayan','14'),('Philippines','PH','Cagayan de Oro City','B2'),('Philippines','PH','Calbayog City','B3'),('Philippines','PH','Caloocan City','B4'),('Philippines','PH','Camarines Norte','15'),('Philippines','PH','Camarines Sur','16'),('Philippines','PH','Camiguin','17'),('Philippines','PH','Canlaon City','B5'),('Philippines','PH','Capiz','18'),('Philippines','PH','Catanduanes','19'),('Philippines','PH','Cavite','20'),('Philippines','PH','Cavite City','B6'),('Philippines','PH','Cebu','21'),('Philippines','PH','Cebu City','B7'),('Philippines','PH','City of Manila','D9'),('Philippines','PH','Cotabato City','B8'),('Philippines','PH','Dagupan City','B9'),('Philippines','PH','Danao City','C1'),('Philippines','PH','Dapitan City','C2'),('Philippines','PH','Davao City','C3'),('Philippines','PH','Davao del Norte','24'),('Philippines','PH','Davao del Sur','25'),('Philippines','PH','Davao Oriental','26'),('Philippines','PH','Dipolog City','C4'),('Philippines','PH','Dumaguete City','C5'),('Philippines','PH','Eastern Samar','23'),('Philippines','PH','General Santos City','C6'),('Philippines','PH','Gingoog City','C7'),('Philippines','PH','Ifugao','27'),('Philippines','PH','Iligan City','C8'),('Philippines','PH','Ilocos Norte','28'),('Philippines','PH','Ilocos Sur','29'),('Philippines','PH','Iloilo','30'),('Philippines','PH','Iloilo City','C9'),('Philippines','PH','Iriga City','D1'),('Philippines','PH','Isabela','31'),('Philippines','PH','Kalinga-Apayao','32'),('Philippines','PH','La Carlota City','D2'),('Philippines','PH','La Union','36'),('Philippines','PH','Laguna','33'),('Philippines','PH','Lanao del Norte','34'),('Philippines','PH','Lanao del Sur','35'),('Philippines','PH','Laoag City','D3'),('Philippines','PH','Lapu-Lapu City','D4'),('Philippines','PH','Legaspi City','D5'),('Philippines','PH','Leyte','37'),('Philippines','PH','Lipa City','D6'),('Philippines','PH','Lucena City','D7'),('Philippines','PH','Maguindanao','56'),('Philippines','PH','Mandaue City','D8'),('Philippines','PH','Marawi City','E1'),('Philippines','PH','Marinduque','38'),('Philippines','PH','Masbate','39'),('Philippines','PH','Mindoro Occidental','40'),('Philippines','PH','Mindoro Oriental','41'),('Philippines','PH','Misamis Occidental','42'),('Philippines','PH','Misamis Oriental','43'),('Philippines','PH','Mountain Province','44'),('Philippines','PH','Naga City','E2'),('Philippines','PH','Negros Occidental','H3'),('Philippines','PH','Negros Oriental','46'),('Philippines','PH','North Cotabato','57'),('Philippines','PH','Northern Samar','67'),('Philippines','PH','Nueva Ecija','47'),('Philippines','PH','Nueva Vizcaya','48'),('Philippines','PH','Olongapo City','E3'),('Philippines','PH','Ormoc City','E4'),('Philippines','PH','Oroquieta City','E5'),('Philippines','PH','Ozamis City','E6'),('Philippines','PH','Pagadian City','E7'),('Philippines','PH','Palawan','49'),('Philippines','PH','Palayan City','E8'),('Philippines','PH','Pampanga','50'),('Philippines','PH','Pangasinan','51'),('Philippines','PH','Pasay City','E9'),('Philippines','PH','Puerto Princesa City','F1'),('Philippines','PH','Quezon','H2'),('Philippines','PH','Quezon City','F2'),('Philippines','PH','Quirino','68'),('Philippines','PH','Rizal','53'),('Philippines','PH','Romblon','54'),('Philippines','PH','Roxas City','F3'),('Philippines','PH','Samar','55'),('Philippines','PH','San Carlos City','F4'),('Philippines','PH','San Pablo City','F7'),('Philippines','PH','Silay City','F8'),('Philippines','PH','Siquijor','69'),('Philippines','PH','Sorsogon','58'),('Philippines','PH','South Cotabato','70'),('Philippines','PH','Southern Leyte','59'),('Philippines','PH','Sultan Kudarat','71'),('Philippines','PH','Sulu','60'),('Philippines','PH','Surigao City','F9'),('Philippines','PH','Surigao del Norte','61'),('Philippines','PH','Surigao del Sur','62'),('Philippines','PH','Tacloban City','G1'),('Philippines','PH','Tagaytay City','G2'),('Philippines','PH','Tagbilaran City','G3'),('Philippines','PH','Tangub City','G4'),('Philippines','PH','Tarlac','63'),('Philippines','PH','Tawi-Tawi','72'),('Philippines','PH','Toledo City','G5'),('Philippines','PH','Trece Martires City','G6'),('Philippines','PH','Zambales','64'),('Philippines','PH','Zamboanga City','G7'),('Philippines','PH','Zamboanga del Norte','65'),('Philippines','PH','Zamboanga del Sur','66'),('Pitcairn Islands','PN','Pitcairn Islands','PIT'),('Poland','PL','Dolnoslaskie','DOL'),('Poland','PL','Kujawsko-Pomorskie','KUJ'),('Poland','PL','Lodzkie','LOD'),('Poland','PL','Lubelskie','LUB'),('Poland','PL','Lubuskie','LBU'),('Poland','PL','Malopolskie','MAL'),('Poland','PL','Mazowieckie','MAZ'),('Poland','PL','Opolskie','OPO'),('Poland','PL','Podkarpackie','PDK'),('Poland','PL','Podlaskie','POD'),('Poland','PL','Pomorskie','POM'),('Poland','PL','Slaskie','SLA'),('Poland','PL','Swietokrzyskie','SWI'),('Poland','PL','Warminsko-Mazurskie','WAR'),('Poland','PL','Wielkopolskie','WIE'),('Poland','PL','Zachodniopomorskie','ZAC'),('Portugal','PT','Acores','ACO'),('Portugal','PT','Alentejo','ALE'),('Portugal','PT','Algarve','ALG'),('Portugal','PT','Centro','CEN'),('Portugal','PT','Lisboa','LIS'),('Portugal','PT','Madeira','MAD'),('Portugal','PT','Norte','NOR'),('Qatar','QA','Qatar','QTR'),('Reunion','RE','Reunion','RE'),('Romania','RO','Alba','ALB'),('Romania','RO','Arad','ARA'),('Romania','RO','Arges','ARG'),('Romania','RO','Bacau','BAC'),('Romania','RO','Bihor','BIH'),('Romania','RO','Bistrita-Nasaud','BIS'),('Romania','RO','Botosani','BOT'),('Romania','RO','Braila','BRA'),('Romania','RO','Brasov','BRS'),('Romania','RO','Buzau','BUZ'),('Romania','RO','Calarasi','CAL'),('Romania','RO','Caras-Severin','CAR'),('Romania','RO','Cluj','CLU'),('Romania','RO','Constanta','CON'),('Romania','RO','Covasna','COV'),('Romania','RO','Dambovita','DAM'),('Romania','RO','Dolj','DOL'),('Romania','RO','Galati','GAL'),('Romania','RO','Giurgiu','GIU'),('Romania','RO','Gorj','GOR'),('Romania','RO','Harghita','HAR'),('Romania','RO','Hunedoara','HUN'),('Romania','RO','Ialomita','IAL'),('Romania','RO','Iasi','IAS'),('Romania','RO','Ilfov','ILF'),('Romania','RO','Maramures','MAR'),('Romania','RO','Mehedinti','MEH'),('Romania','RO','Municipiul Bucuresti','BUC'),('Romania','RO','Mures','MUR'),('Romania','RO','Neamt','NEA'),('Romania','RO','Olt','OLT'),('Romania','RO','Prahova','PRA'),('Romania','RO','Salaj','SAL'),('Romania','RO','Satu Mare','SAT'),('Romania','RO','Sibiu','SIB'),('Romania','RO','Suceava','SUC'),('Romania','RO','Teleorman','TEL'),('Romania','RO','Timis','TIM'),('Romania','RO','Tulcea','TUL'),('Romania','RO','Unknown','UNK'),('Romania','RO','Valcea','VAL'),('Romania','RO','Vaslui','VAS'),('Romania','RO','Vrancea','VRA'),('Russia','RU','Aginskiy Buryatskiy','02'),('Russia','RU','Altayskiy Kray','04'),('Russia','RU','Amurskaya','05'),('Russia','RU','Arkhangel\'skaya','06'),('Russia','RU','Astrakhanskaya','07'),('Russia','RU','Belgorodskaya','09'),('Russia','RU','Bryanskaya','10'),('Russia','RU','Chechenskaya','CI'),('Russia','RU','Chelyabinskaya','13'),('Russia','RU','Chitinskaya','14'),('Russia','RU','Chukotskiy','15'),('Russia','RU','Chuvashskaya','16'),('Russia','RU','Evenkiyskiy','18'),('Russia','RU','Gorod Moskva','48'),('Russia','RU','Gorod Sankt-Peterburg','66'),('Russia','RU','Irkutskaya','20'),('Russia','RU','Ivanovskaya','21'),('Russia','RU','Kabardino-Balkarskaya','22'),('Russia','RU','Kaliningradskaya','23'),('Russia','RU','Kaluzhskaya','25'),('Russia','RU','Kamchatskaya','26'),('Russia','RU','Karachayevo-Cherkesskaya','27'),('Russia','RU','Kemerovskaya','29'),('Russia','RU','Khabarovskiy Kray','30'),('Russia','RU','Khanty-Mansiyskiy','32'),('Russia','RU','Kirovskaya','33'),('Russia','RU','Komi-Permyatskiy','35'),('Russia','RU','Koryakskiy','36'),('Russia','RU','Kostromskaya','37'),('Russia','RU','Krasnodarskiy Kray','38'),('Russia','RU','Krasnoyarskiy Kray','39'),('Russia','RU','Kurganskaya','40'),('Russia','RU','Kurskaya','41'),('Russia','RU','Leningradskaya','42'),('Russia','RU','Lipetskaya','43'),('Russia','RU','Magadanskaya','44'),('Russia','RU','Moskovskaya','47'),('Russia','RU','Murmanskaya','49'),('Russia','RU','Nenetskiy','50'),('Russia','RU','Nizhegorodskaya','51'),('Russia','RU','Novgorodskaya','52'),('Russia','RU','Novosibirskaya','53'),('Russia','RU','Omskaya','54'),('Russia','RU','Orenburgskaya','55'),('Russia','RU','Orlovskaya','56'),('Russia','RU','Penzenskaya','57'),('Russia','RU','Permskaya','58'),('Russia','RU','Primorskiy Kray','59'),('Russia','RU','Pskovskaya','60'),('Russia','RU','Respublika Adygeya','01'),('Russia','RU','Respublika Altay','03'),('Russia','RU','Respublika Bashkortostan','08'),('Russia','RU','Respublika Buryatiya','11'),('Russia','RU','Respublika Dagestan','17'),('Russia','RU','Respublika Kalmykiya','24'),('Russia','RU','Respublika Kareliya','28'),('Russia','RU','Respublika Khakasiya','31'),('Russia','RU','Respublika Komi','34'),('Russia','RU','Respublika Mariy-El','45'),('Russia','RU','Respublika Mordoviya','46'),('Russia','RU','Respublika Sakha','Yakut'),('Russia','RU','Respublika Severnaya Osetiya-Alaniya','68'),('Russia','RU','Respublika Tatarstan','73'),('Russia','RU','Respublika Tyva','79'),('Russia','RU','Rostovskaya','61'),('Russia','RU','Ryazanskaya','62'),('Russia','RU','Sakhalinskaya','64'),('Russia','RU','Samarskaya','65'),('Russia','RU','Saratovskaya','67'),('Russia','RU','Smolenskaya','69'),('Russia','RU','Stavropol\'skiy Kray','70'),('Russia','RU','Sverdlovskaya','71'),('Russia','RU','Tambovskaya','72'),('Russia','RU','Taymyrskiy','Dolga'),('Russia','RU','Tomskaya','75'),('Russia','RU','Tul\'skaya','76'),('Russia','RU','Tverskaya','77'),('Russia','RU','Tyumenskaya','78'),('Russia','RU','Udmurtskaya','80'),('Russia','RU','Ul\'yanovskaya','81'),('Russia','RU','Ust\'-Ordynskiy Buryatskiy','82'),('Russia','RU','Vladimirskaya','83'),('Russia','RU','Volgogradskaya','84'),('Russia','RU','Vologodskaya','85'),('Russia','RU','Voronezhskaya','86'),('Russia','RU','Yamalo-Nenetskiy','87'),('Russia','RU','Yaroslavskaya','88'),('Russia','RU','Yevreyskaya','89'),('Rwanda','RW','Rwanda','RWA'),('Saint Helena','SH','Saint Helena','STH'),('Saint Kitts and Nevis','KN','Saint Kitts & Nevis','SKN'),('Saint Lucia','LC','Saint Lucia','SLC'),('Saint Pierre and Miquelon','PM','Saint Pierre & Miquelon','SPM'),('Saint Vincent and the Grenadines','VC','Saint Vincent & the Grenadines','STV'),('Samoa','WS','Samoa','SAM'),('San Marino','SM','San Marino','MAR'),('Sao Tome & Principe','ST','Sao Tome & Principe','SAO'),('Saudi Arabia','SA','Al Bahah','BAH'),('Saudi Arabia','SA','Al Hudud ash Shamaliyah','HUD'),('Saudi Arabia','SA','Al Madinah','MAD'),('Saudi Arabia','SA','Al Mintaqah ash Sharqiyah','MAS'),('Saudi Arabia','SA','Al Qasim','QAS'),('Saudi Arabia','SA','Al-Jawf','JAW'),('Saudi Arabia','SA','Ar Riyad','RIY'),('Saudi Arabia','SA','Ha\'il','HAI'),('Saudi Arabia','SA','Jizan','JIZ'),('Saudi Arabia','SA','Makkah','MAK'),('Saudi Arabia','SA','Tabuk','TAB'),('Senegal','SN','Dakar','DAK'),('Senegal','SN','Saint-Louis','STL'),('Senegal','SN','Thies','THI'),('Serbia and Montenegro','CS','Serbia & Montenegro','SRB'),('Seychelles','SC','Seychelles','SEY'),('Sierra Leone','SL','Eastern Province','EAS'),('Sierra Leone','SL','Northern Province','NOR'),('Sierra Leone','SL','Southern Province','SOU'),('Sierra Leone','SL','Western Area','WES'),('Singapore','SG','Singapore','SNG'),('Slovakia','SK','Slovakia','SLO'),('Slovenia','SI','Slovenia','SLO'),('Solomon Islands','SB','Solomon Islands','SOL'),('Somalia','SO','Bakool','BAK'),('Somalia','SO','Banaadir','BAN'),('Somalia','SO','Bari','BAR'),('Somalia','SO','Bay','BAY'),('Somalia','SO','Gedo','GED'),('Somalia','SO','Jubbada Dhexe','JUD'),('Somalia','SO','Jubbada Hoose','JUH'),('Somalia','SO','Shabeellaha Hoose','SHH'),('South Africa','ZA','Eastern Cape','EAS'),('South Africa','ZA','Free State','FRE'),('South Africa','ZA','Gauteng','GAU'),('South Africa','ZA','KwaZulu-Natal','KWA'),('South Africa','ZA','Limpopo','LIM'),('South Africa','ZA','Mpumalanga','MPU'),('South Africa','ZA','North-West','NRW'),('South Africa','ZA','Northern Cape','NOR'),('South Africa','ZA','Unknown','UNK'),('South Africa','ZA','Western Cape','WES'),('South Georgia','GS','South Georgia & South Sandwich Islands','SGS'),('South Korea','KR','Ch\'ungch\'ong-bukto','CHU'),('South Korea','KR','Ch\'ungch\'ong-namdo','CON'),('South Korea','KR','Cheju-do','CHE'),('South Korea','KR','Cholla-bukto','CHO'),('South Korea','KR','Cholla-namdo','CHN'),('South Korea','KR','Inch\'on-gwangyoksi','INC'),('South Korea','KR','Kangwon-do','KAN'),('South Korea','KR','Kwangju-gwangyoksi','KWA'),('South Korea','KR','Kyonggi-do','KYO'),('South Korea','KR','Kyongsang-bukto','KYB'),('South Korea','KR','Kyongsang-namdo','KGM'),('South Korea','KR','Pusan-gwangyoksi','PUS'),('South Korea','KR','Soul-t\'ukpyolsi','SOU'),('South Korea','KR','Taegu-gwangyoksi','TAE'),('South Korea','KR','Taejon-gwangyoksi','TAG'),('South Korea','KR','Ulsan-gwangyoksi','ULS'),('Spain','ES','Andalucia','AND'),('Spain','ES','Aragon','ARA'),('Spain','ES','Asturias','AST'),('Spain','ES','Baleares','BAL'),('Spain','ES','Canarias','CAN'),('Spain','ES','Cantabria','CAR'),('Spain','ES','Castilla y Leon','CLE'),('Spain','ES','Castilla-La Mancha','CLM'),('Spain','ES','Cataluna','CAT'),('Spain','ES','Ceuta y Melilla','CM'),('Spain','ES','Extremadura','EXT'),('Spain','ES','Galicia','GAL'),('Spain','ES','La Rioja','LAR'),('Spain','ES','Madrid','MAD'),('Spain','ES','Murcia','MUR'),('Spain','ES','Navarra','NAV'),('Spain','ES','Pais Vasco','PAI'),('Spain','ES','Valencia','VAL'),('Sri Lanka','LK','Sri Lanka','SRI'),('Sudan','SD','Sudan','SUD'),('Suriname','SR','Suriname','SUR'),('Svalbard','SJ','Svalbard','SVL'),('Swaziland','SZ','Swaziland','SWZ'),('Sweden','SE','Blekinge lan','BLE'),('Sweden','SE','Dalarnas lan','DAL'),('Sweden','SE','Gavleborgs lan','GAV'),('Sweden','SE','Gotlands lan','GOT'),('Sweden','SE','Hallands lan','HAL'),('Sweden','SE','Jamtlands lan','JAM'),('Sweden','SE','Jonkopings lan','JON'),('Sweden','SE','Kalmar lan','KAL'),('Sweden','SE','Kronobergs lan','KRO'),('Sweden','SE','Norrbottens lan','NOR'),('Sweden','SE','Orebro lan','ORE'),('Sweden','SE','Ostergotlands lan','OST'),('Sweden','SE','Skane lan','SKA'),('Sweden','SE','Sodermanlands lan','SOD'),('Sweden','SE','Stockholms lan','STO'),('Sweden','SE','Uppsala lan','UPP'),('Sweden','SE','Varmlands lan','VAR'),('Sweden','SE','Vasterbottens lan','VAS'),('Sweden','SE','Vasternorrlands lan','VNL'),('Sweden','SE','Vastmanlands lan','VML'),('Sweden','SE','Vastra Gotalands lan','VGI'),('Switzerland','CH','Aargau','1AG'),('Switzerland','CH','Appenzell Ausserrhoden','1AR'),('Switzerland','CH','Appenzell Innerrhoden','1AI'),('Switzerland','CH','Basel-Landschaft','1BL'),('Switzerland','CH','Basel-Stadt','1BS'),('Switzerland','CH','Bern','1BE'),('Switzerland','CH','Fribourg','1FR'),('Switzerland','CH','Geneva','1GE'),('Switzerland','CH','Glarus','1GL'),('Switzerland','CH','Graub','1GR'),('Switzerland','CH','Jura','1JU'),('Switzerland','CH','Lucerne','1LU'),('Switzerland','CH','Neuch','1NE'),('Switzerland','CH','Nidwalden','1NW'),('Switzerland','CH','Obwalden','1OW'),('Switzerland','CH','Schaffhausen','1SH'),('Switzerland','CH','Schwyz','1SZ'),('Switzerland','CH','Solothurn','1SO'),('Switzerland','CH','St. Gallen','1SG'),('Switzerland','CH','Thurgau','1TG'),('Switzerland','CH','Ticino','1TI'),('Switzerland','CH','Uri','1UR'),('Switzerland','CH','Valais','1VS'),('Switzerland','CH','Vaud','1VD'),('Switzerland','CH','Zug','1ZG'),('Switzerland','CH','Zurich','1ZH'),('Syria','SY','Dar`a','DAR'),('Syria','SY','Dayr az Zawr','DAY'),('Syria','SY','Dimashq','DIM'),('Syria','SY','Hamah','HAM'),('Syria','SY','Hasakah','HAS'),('Syria','SY','Hims','HIM'),('Syria','SY','Ladhiqiyah','LAD'),('Syria','SY','Unknown','UNK'),('Taiwan','TW','Kao-hsiung','KAO'),('Taiwan','TW','T\'ai-pei','TPS'),('Taiwan','TW','T\'ai-wan','TWS'),('Tajikistan','TJ','Khatlon','KHA'),('Tajikistan','TJ','Mukhtori Kuhistoni Badakhshon','MKB'),('Tajikistan','TJ','Sughd','SUG'),('Tajikistan','TJ','Unknown','UNK'),('Tanzania','TZ','Kagera','KAG'),('Tanzania','TZ','Kigoma','KIG'),('Tanzania','TZ','Kilimanjaro','KIL'),('Tanzania','TZ','Mwanza','MWA'),('Tanzania','TZ','Rukwa','RUK'),('Tanzania','TZ','Shinyanga','SHI'),('Tanzania','TZ','Tabora','TAB'),('Tanzania','TZ','Unknown','UNK'),('Thailand','TH','Bangkok Metropolis','BKM'),('Thailand','TH','Central','CEN'),('Thailand','TH','Northeastern','NEA'),('Thailand','TH','Northern','NOR'),('Thailand','TH','Southern','SOU'),('Togo','TG','Togo','TOG'),('Tokelau','TK','Tokelau','TOK'),('Tonga','TO','Tonga','TNG'),('Trinidad and Tobago','TT','Trinidad & Tobago','TRT'),('Tunisia','TN','Ariana','ARI'),('Tunisia','TN','Mahdia','MAH'),('Tunisia','TN','Sousse','SOU'),('Tunisia','TN','Tunis','TUN'),('Tunisia','TN','Unknown','UNK'),('Turkey','TR','Adana','ADA'),('Turkey','TR','Ankara','ANK'),('Turkey','TR','Antalya','ANT'),('Turkey','TR','Aydin','AYD'),('Turkey','TR','Bilecik','BIL'),('Turkey','TR','Bursa','BUR'),('Turkey','TR','Diyarbakir','DIY'),('Turkey','TR','Erzurum','ERZ'),('Turkey','TR','Hakkari','HAK'),('Turkey','TR','Hatay','HAT'),('Turkey','TR','Icel','ICE'),('Turkey','TR','Isparta','ISP'),('Turkey','TR','Istanbul','IST'),('Turkey','TR','Izmir','IZM'),('Turkey','TR','Karaman','KAM'),('Turkey','TR','Kilis','KIL'),('Turkey','TR','Kocaeli','KOC'),('Turkey','TR','Konya','KON'),('Turkey','TR','Manisa','MAN'),('Turkey','TR','Nigde','NIG'),('Turkey','TR','Sirnak','SIR'),('Turkey','TR','Sivas','SIV'),('Turkey','TR','Yalova','YAL'),('Turkmenistan','TM','Ahal','AHL'),('Turkmenistan','TM','Balkan','BAL'),('Turkmenistan','TM','Dasoguz','DAS'),('Turkmenistan','TM','Lebap','LEB'),('Turkmenistan','TM','Mary','MAR'),('Turks and Caicos Islands','TC','Turks & Caicos Islands','TUK'),('Tuvalu','TV','Tuvalu','TUV'),('Uganda','UG','Uganda','UGA'),('Ukraine','UA','Cherkas\'ka','CHK'),('Ukraine','UA','Chernihivs\'ka','CHH'),('Ukraine','UA','Chernivets\'ka','CHT'),('Ukraine','UA','Dnipropetrovs\'ka','DNI'),('Ukraine','UA','Donets\'ka','DON'),('Ukraine','UA','Ivano-Frankivs\'ka','IVA'),('Ukraine','UA','Kharkivs\'ka','KHA'),('Ukraine','UA','Khersons\'ka','KHE'),('Ukraine','UA','Khmel\'nyts\'ka','KHM'),('Ukraine','UA','Kirovohrads\'ka','KIR'),('Ukraine','UA','Kyrm','KRY'),('Ukraine','UA','Kyyivs\'ka','KYY'),('Ukraine','UA','L\'vivs\'ka','LVI'),('Ukraine','UA','Luhans\'ka','LUH'),('Ukraine','UA','Misto Kyyiv','KYC'),('Ukraine','UA','Misto Sevastopol\'','SEV'),('Ukraine','UA','Mykolayivs\'ka','MYK'),('Ukraine','UA','Odes\'ka','ODE'),('Ukraine','UA','Poltavs\'ka','POL'),('Ukraine','UA','Rivnens\'ka','RIV'),('Ukraine','UA','Sums\'ka','SUM'),('Ukraine','UA','Ternopil\'s\'ka','TER'),('Ukraine','UA','Vinnyts\'ka','VIN'),('Ukraine','UA','Volyns\'ka','VOL'),('Ukraine','UA','Zakarpats\'ka','ZAK'),('Ukraine','UA','Zaporiz\'ka','ZAP'),('Ukraine','UA','Zhytomyrs\'ka','ZHY'),('United Arab Emirates','AE','United Arab Emirates','UAE'),('United Kingdom','GB','Avon','AVN'),('United Kingdom','GB','Bedfordshire','BFE'),('United Kingdom','GB','Berkshire','BKE'),('United Kingdom','GB','Borders','BDE'),('United Kingdom','GB','Buckinghamshire','BHE'),('United Kingdom','GB','Cambridgeshire','CBE'),('United Kingdom','GB','Central','CTL'),('United Kingdom','GB','Cheshire','CHE'),('United Kingdom','GB','Cleveland','CVD'),('United Kingdom','GB','Clwyd','CLD'),('United Kingdom','GB','Cornwall','CWL'),('United Kingdom','GB','CountyAntrim','CAM'),('United Kingdom','GB','CountyArmagh','CAH'),('United Kingdom','GB','CountyDown','CDN'),('United Kingdom','GB','CountyFermanagh','CFH'),('United Kingdom','GB','CountyLondonderry','CLY'),('United Kingdom','GB','CountyTyrone','CTE'),('United Kingdom','GB','Cumbria','CUA'),('United Kingdom','GB','Derbyshire','DYE'),('United Kingdom','GB','Devon','DVN'),('United Kingdom','GB','Dorset','DST'),('United Kingdom','GB','DumfriesandGalloway','DGY'),('United Kingdom','GB','Durham','DRM'),('United Kingdom','GB','Dyfed','DYD'),('United Kingdom','GB','EastSussex','EAX'),('United Kingdom','GB','Essex','ESX'),('United Kingdom','GB','Fife','FFE'),('United Kingdom','GB','Gloucestershire','GTE'),('United Kingdom','GB','Grampian','GRN'),('United Kingdom','GB','GreaterManchester','GMR'),('United Kingdom','GB','Gwent','GWT'),('United Kingdom','GB','GwyneddCounty','GCY'),('United Kingdom','GB','Hampshire','HHE'),('United Kingdom','GB','Herefordshire','HEE'),('United Kingdom','GB','Hertfordshire','HTE'),('United Kingdom','GB','HighlandsandIslands','HSS'),('United Kingdom','GB','Humberside','HBE'),('United Kingdom','GB','IsleofWight','IWT'),('United Kingdom','GB','Kent','KET'),('United Kingdom','GB','Lancashire','LCE'),('United Kingdom','GB','Leicestershire','LEE'),('United Kingdom','GB','Lincolnshire','LIE'),('United Kingdom','GB','Lothian','LTN'),('United Kingdom','GB','Merseyside','MYE'),('United Kingdom','GB','MidGlamorgan','MGN'),('United Kingdom','GB','Norfolk','NFK'),('United Kingdom','GB','NorthYorkshire','NYE'),('United Kingdom','GB','Northamptonshire','NSE'),('United Kingdom','GB','Northumberland','NLD'),('United Kingdom','GB','Nottinghamshire','NHE'),('United Kingdom','GB','Oxfordshire','OSE'),('United Kingdom','GB','Powys','POS'),('United Kingdom','GB','Rutland','RTD'),('United Kingdom','GB','Shropshire','SSE'),('United Kingdom','GB','Somerset','SRT'),('United Kingdom','GB','SouthGlamorgan','SGN'),('United Kingdom','GB','SouthYorkshire','SYE'),('United Kingdom','GB','Staffordshire','SFE'),('United Kingdom','GB','Strathclyde','STE'),('United Kingdom','GB','Suffolk','SUK'),('United Kingdom','GB','Surrey','SRY'),('United Kingdom','GB','Tayside','TSE'),('United Kingdom','GB','TyneandWear','TWR'),('United Kingdom','GB','Warwickshire','WSE'),('United Kingdom','GB','WestGlamorgan','WGN'),('United Kingdom','GB','WestMidlands','WMS'),('United Kingdom','GB','WestSussex','WSX'),('United Kingdom','GB','WestYorkshire','WYE'),('United Kingdom','GB','Wiltshire','WHE'),('United Kingdom','GB','Worcestershire','WOE'),('United States','US','Alabama','AL'),('United States','US','Alaska','AK'),('United States','US','American Samoa','AS'),('United States','US','Arizona','AZ'),('United States','US','Arkansas','AR'),('United States','US','California','CA'),('United States','US','Colorado','CO'),('United States','US','Connecticut','CT'),('United States','US','Delaware','DE'),('United States','US','District of Columbia','DC'),('United States','US','Florida','FL'),('United States','US','Georgia','GA'),('United States','US','Guam','GU'),('United States','US','Hawaii','HI'),('United States','US','Idaho','ID'),('United States','US','Illinois','IL'),('United States','US','Indiana','IN'),('United States','US','Iowa','IA'),('United States','US','Kansas','KS'),('United States','US','Kentucky','KY'),('United States','US','Louisiana','LA'),('United States','US','Maine','ME'),('United States','US','Maryland','MD'),('United States','US','Massachusetts','MA'),('United States','US','Michigan','MI'),('United States','US','Minnesota','MN'),('United States','US','Mississippi','MS'),('United States','US','Missouri','MO'),('United States','US','Montana','MT'),('United States','US','Nebraska','NE'),('United States','US','Nevada','NV'),('United States','US','New Hampshire','NH'),('United States','US','New Jersey','NJ'),('United States','US','New Mexico','NM'),('United States','US','New York','NY'),('United States','US','North Carolina','NC'),('United States','US','North Dakota','ND'),('United States','US','Northern Mariana Islands','MP'),('United States','US','Ohio','OH'),('United States','US','Oklahoma','OK'),('United States','US','Oregon','OR'),('United States','US','Pennsylvania','PA'),('United States','US','Puerto Rico','PR'),('United States','US','Rhode Island','RI'),('United States','US','South Carolina','SC'),('United States','US','South Dakota','SD'),('United States','US','Tennessee','TN'),('United States','US','Texas','TX'),('United States','US','Utah','UT'),('United States','US','Vermont','VT'),('United States','US','Virgin Islands','VI'),('United States','US','Virginia','VA'),('United States','US','Washington','WA'),('United States','US','West Virginia','WV'),('United States','US','Wisconsin','WI'),('United States','US','Wyoming','WY'),('Uruguay','UY','Artigas','ART'),('Uruguay','UY','Canelones','CAN'),('Uruguay','UY','Cerro Largo','CER'),('Uruguay','UY','Colonia','COL'),('Uruguay','UY','Durazno','DUR'),('Uruguay','UY','Florida','FLO'),('Uruguay','UY','Lavalleja','LAV'),('Uruguay','UY','Maldonado','MAL'),('Uruguay','UY','Montevideo','MON'),('Uruguay','UY','Paysandu','PAY'),('Uruguay','UY','Rio Negro','RNE'),('Uruguay','UY','Rivera','RIV'),('Uruguay','UY','Rocha','ROC'),('Uruguay','UY','Salto','SAL'),('Uruguay','UY','San Jose','SJO'),('Uruguay','UY','Soriano','SOR'),('Uruguay','UY','Tacuarembo','TAC'),('Uruguay','UY','Treinta y Tres','TYT'),('Uzbekistan','UZ','Andijon','AND'),('Uzbekistan','UZ','Buxoro','BUX'),('Uzbekistan','UZ','Jizzax','JIZ'),('Uzbekistan','UZ','Namangan','NAM'),('Uzbekistan','UZ','Navoiy','NAV'),('Uzbekistan','UZ','Qashqadaryo','QAS'),('Uzbekistan','UZ','Qoraqalpog`iston','QOR'),('Uzbekistan','UZ','Samarqand','SAM'),('Uzbekistan','UZ','Sirdaryo','SIR'),('Uzbekistan','UZ','Surxondaryo','SUR'),('Uzbekistan','UZ','Toshkent','TOS'),('Uzbekistan','UZ','Toshkent Shahri','TSH'),('Uzbekistan','UZ','Unknown','UNK'),('Uzbekistan','UZ','Xorazm','XOR'),('Vanuatu','VU','Vanuatu','VAN'),('Vatican City','VA','Vatican City','VTC'),('Venezuela','VE','Amazonas','AMA'),('Venezuela','VE','Anzoategui','ANZ'),('Venezuela','VE','Apure','APU'),('Venezuela','VE','Aragua','ARA'),('Venezuela','VE','Barinas','BAR'),('Venezuela','VE','Bolivar','BOL'),('Venezuela','VE','Carabobo','CAR'),('Venezuela','VE','Falcon','FAL'),('Venezuela','VE','Guarico','GUA'),('Venezuela','VE','Lara','LAR'),('Venezuela','VE','Merida','MER'),('Venezuela','VE','Miranda','MIR'),('Venezuela','VE','Monagas','MON'),('Venezuela','VE','Nueva Esparta','NES'),('Venezuela','VE','Sucre','SUC'),('Venezuela','VE','Tachira','TAC'),('Venezuela','VE','Trujillo','TRU'),('Venezuela','VE','Vargas','VAR'),('Venezuela','VE','Yaracuy','YAR'),('Venezuela','VE','Zulia','ZUL'),('Vietnam','VN','An Giang','ANG'),('Vietnam','VN','Ba Ria-Vung Tau','BRV'),('Vietnam','VN','Bac Giang','GIN'),('Vietnam','VN','Bac Kan','KAN'),('Vietnam','VN','Bac Lieu','LIU'),('Vietnam','VN','Bac Ninh','NIH'),('Vietnam','VN','Ben Tre','BEN'),('Vietnam','VN','Binh Dinh','BDI'),('Vietnam','VN','Binh Duong','DUO'),('Vietnam','VN','Binh Phuoc','BPC'),('Vietnam','VN','Binh Thuan','BTH'),('Vietnam','VN','Ca Mau','CAM'),('Vietnam','VN','Can Tho','CAN'),('Vietnam','VN','Cao Bang','CAO'),('Vietnam','VN','Da Nang','DAN'),('Vietnam','VN','Dac Lak','DAC'),('Vietnam','VN','Dong Nai','DNA'),('Vietnam','VN','Dong Thap','DON'),('Vietnam','VN','Gia Lai','GIA'),('Vietnam','VN','Ha Giang','HAG'),('Vietnam','VN','Ha Nam','HAM'),('Vietnam','VN','Ha Tay','HAT'),('Vietnam','VN','Ha Tinh','HAN'),('Vietnam','VN','Hai Duong','HDG'),('Vietnam','VN','Hoa Binh','HOA'),('Vietnam','VN','Hung Yen','HUY'),('Vietnam','VN','Khanh Hoa','KHH'),('Vietnam','VN','Kien Giang','KIE'),('Vietnam','VN','Kon Tum','KON'),('Vietnam','VN','Lai Chau','LAI'),('Vietnam','VN','Lam Dong','LAM'),('Vietnam','VN','Lang Son','LAN'),('Vietnam','VN','Lao Cai','LAC'),('Vietnam','VN','Long An','LON'),('Vietnam','VN','Nam Dinh','NAN'),('Vietnam','VN','Nghe An','NGH'),('Vietnam','VN','Ninh Binh','NBI'),('Vietnam','VN','Ninh Thuan','NIT'),('Vietnam','VN','Phu Tho','PTO'),('Vietnam','VN','Phu Yen','PHU'),('Vietnam','VN','Quang Binh','QBI'),('Vietnam','VN','Quang Nam','QNM'),('Vietnam','VN','Quang Ngai','QNG'),('Vietnam','VN','Quang Ninh','NIN'),('Vietnam','VN','Quang Tri','QTR'),('Vietnam','VN','Soc Trang','SOC'),('Vietnam','VN','Son La','SOL'),('Vietnam','VN','Tay Ninh','TAY'),('Vietnam','VN','Thai Binh','THB'),('Vietnam','VN','Thai Nguyen','TNY'),('Vietnam','VN','Thanh Hoa','THH'),('Vietnam','VN','Thanh Pho Hai Phong','PHP'),('Vietnam','VN','Thanh Pho Ho Chi Minh','PHC'),('Vietnam','VN','Thu Do Ha Noi','TDH'),('Vietnam','VN','Thua Thien-Hue','TTH'),('Vietnam','VN','Tien Giang','TGI'),('Vietnam','VN','Tra Vinh','TRA'),('Vietnam','VN','Tuyen Quang','TUY'),('Vietnam','VN','Vinh Long','VIL'),('Vietnam','VN','Vinh Phuc','VPC'),('Vietnam','VN','Yen Bai','YEN'),('Wallis and Futuna','WF','Wallis & Futuna','WAF'),('Yemen','YE','Yemen','YEM'),('Zambia','ZM','Central','CEN'),('Zambia','ZM','Eastern','EAS'),('Zambia','ZM','Lusaka','LUS'),('Zambia','ZM','Southern','SOU'),('Zambia','ZM','Unknown','UNK'),('Zambia','ZM','Western','WES'),('Zimbabwe','ZW','Harare','HAR'),('Zimbabwe','ZW','Manicaland','MNL'),('Zimbabwe','ZW','Mashonaland East','MSE'),('Zimbabwe','ZW','Mashonaland West','MSW'),('Zimbabwe','ZW','Masvingo','MVG'),('Zimbabwe','ZW','Matabeleland North','MBN'),('Zimbabwe','ZW','Matabeleland South','MBS'),('Zimbabwe','ZW','Midlands','MID'),('Zimbabwe','ZW','Unknown','UNK');

--
-- 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 (83,'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 (9,'Free / Recycling','For-Sale','Free / Recycling','','','','','shopping-cart');

--
-- 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'),(72,8,'men seeking men','men-seeking-men','men seeking men 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=9 DEFAULT CHARSET=utf8;

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

INSERT INTO `bx_ads_main` VALUES (4,3,79,1476406365,'baby crib','baby-crib','<p>3 year old baby crib, good as new! White with sides that go up and down</p>','active','0','0',30,NULL,'','US','01002',0,5,0,0,0,0,0,0),(7,3,74,1546720198,'Bike','Bike','<p>24\" bike needs work</p>','active','0','0',5,NULL,'','US','Amherst, MA 01002',0,1,0,0,0,5,5,5);

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

INSERT INTO `bx_ads_rating` VALUES (6,1,5);

--
-- 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 (4,3,2923395480,1479249373),(4,12,851164926,1482419474),(7,3,2923395480,1546720206);

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

INSERT INTO `bx_ads_voting_track` VALUES (6,'50.187.190.254','2017-01-04 12:37:29');

--
-- Table structure for table `bx_arl_comments_bak`
--

CREATE TABLE `bx_arl_comments_bak` (
  `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_arl_comments_bak`
--


--
-- Table structure for table `bx_arl_comments_track_bak`
--

CREATE TABLE `bx_arl_comments_track_bak` (
  `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_arl_comments_track_bak`
--


--
-- Table structure for table `bx_arl_entries`
--

CREATE TABLE `bx_arl_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_arl_entries`
--


--
-- Table structure for table `bx_arl_entries_bak`
--

CREATE TABLE `bx_arl_entries_bak` (
  `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_arl_entries_bak`
--


--
-- Table structure for table `bx_arl_views_track_bak`
--

CREATE TABLE `bx_arl_views_track_bak` (
  `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_arl_views_track_bak`
--


--
-- Table structure for table `bx_arl_voting_bak`
--

CREATE TABLE `bx_arl_voting_bak` (
  `articles_id` bigint(8) NOT NULL DEFAULT '0',
  `articles_rating_count` int(11) NOT NULL DEFAULT '0',
  `articles_rating_sum` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `articles_id` (`articles_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_voting_bak`
--


--
-- Table structure for table `bx_arl_voting_track_bak`
--

CREATE TABLE `bx_arl_voting_track_bak` (
  `articles_id` bigint(8) NOT NULL DEFAULT '0',
  `articles_ip` varchar(20) DEFAULT NULL,
  `articles_date` datetime DEFAULT NULL,
  KEY `articles_ip` (`articles_ip`,`articles_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bx_arl_voting_track_bak`
--


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

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

INSERT INTO `bx_events_cmts` VALUES (5,0,7,24,'heeeeelllpppp',0,0,0,'2016-10-14 14:09:02',1),(6,5,7,27,'i may be too late, but if there is more to do then i will do it. otherwise, i will buy it and eat it. and CELEBRATE it and YOU.',0,0,0,'2016-10-27 23:08:09',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=10 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),(4,'test',1,'test','DAvzeXKiGw',0,0,1466453623,'public',0,4),(5,'Test-2016-06-28',1,'Test','DAvzeXKiGw',0,0,1467139570,'public',0,5),(7,'Canning-my-ass-off',1,'Canning my ass off','zBQpjhpCG8',0,0,1476468494,'public',0,7),(8,'Walk-the-dogs',1,'Walk the dogs','zBQpjhpCG8',0,0,1478297954,'public',0,8),(9,'Dog-talk',1,'Dog talk','persister1',0,0,1479247487,'public',0,9);

--
-- 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 (9,45);

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

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

INSERT INTO `bx_events_main` VALUES (9,'Dog talk','Dog-talk','<p>bla bla bla dogs</p>','approved','US','amherst, MA 01002','hobla',45,1479247486,1478968200,1478960760,3,'','','',1,5,1,0,0,0,3,'','4','',3,'','',0,'a','','',''),(8,'Walk the dogs','Walk-the-dogs','<p>Dog walking in the back field<img src=\"plugins/tinymce/plugins/emoticons/img/smiley-foot-in-mouth.gif\" alt=\"foot-in-mouth\" /></p>','approved','US','Amherst, MA 01002','Back Fields',0,1478297954,1478822400,1478908800,24,'','','',3,0,0,0,0,0,3,'','4','',3,'','',0,'a','','',''),(7,'Canning my ass off','Canning-my-ass-off','<p>help me get all the harvest into cans</p>','approved','US','Amherst, MA 01002','Greenhouse',0,1476468494,1476576000,1476748800,24,'','','',1,0,0,2,0,0,3,'','4','',3,'','',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`
--


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

INSERT INTO `bx_events_rating` VALUES (9,1,5);

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

INSERT INTO `bx_events_rating_track` VALUES (9,'50.187.190.254','2016-11-30 20:15:27');

--
-- 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 (7,24,1229237105,1476468506),(8,12,851164926,1483042812),(9,12,1240338797,1495985530),(8,48,3635313828,1546985050);

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


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


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


--
-- 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',1482353444,1471551027),('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',0,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`
--

INSERT INTO `bx_groups_fans` VALUES (7,3,1479247581,1),(7,12,1482766170,1),(11,48,1546985181,0);

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

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

INSERT INTO `bx_groups_forum` VALUES (6,'Meditate-with-Moms',1,'Meditate with Moms','9Jukj2dZdQ',0,0,1476785074,'public',0,6),(2,'Test',1,'Test','DAvzeXKiGw',0,0,1467139891,'public',0,2),(5,'Bitchy-over-50',1,'Bitchy over 50','zBQpjhpCG8',0,0,1476468366,'public',0,5),(7,'Dog-walkers-unite',1,'Dog walkers unite','zBQpjhpCG8',0,0,1478298037,'public',0,7),(11,'Women-Against-Sexual-Abuse',1,'Women Against Sexual Abuse','persister1',0,0,1546720603,'public',0,11);

--
-- 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',1471532133,1448464449);

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

INSERT INTO `bx_groups_images` VALUES (7,46),(11,52),(11,53);

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

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

INSERT INTO `bx_groups_main` VALUES (7,'Dog walkers unite','Dog-walkers-unite','<p>got a dog? gotta walk them? let\'s do it together. </p>','US','Amherst','01002','approved',46,1478298037,24,'','',5,0,0,0,2,0,3,'4','f','','f','f',3,0,'a','','',''),(6,'Meditate with Moms','Meditate-with-Moms','<p>come let the world go together... Share the energy</p>','US','Amherst','01002','approved',0,1476785074,23,'','',1,0,0,0,0,0,3,'4','f','','f','f',3,0,'a','','',''),(5,'Bitchy over 50','Bitchy-over-50','<p>you know the drill</p>','US','Amherst','01002','approved',0,1476468365,24,'','',1,0,0,0,0,0,3,'4','f','','f','f',3,0,'a','','',''),(11,'Women Against Sexual Abuse','Women-Against-Sexual-Abuse','<p>We women need to stand together against sexual abuse. Lets form a large group to help one another with this!</p>','US','','','approved',52,1546720603,3,'safe sharing,help one another,activism','Health & Wellness',4,0,0,0,0,0,3,'3','f','f','','',3,1,'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 (7,3,2923395480,1479247575),(6,3,2923395480,1479248404),(7,12,851164926,1483042654),(7,39,1222881933,1546713669),(11,3,2923395480,1546720612),(11,48,3635313828,1546985176),(5,48,3635313828,1546985202),(11,0,627978969,1547758959),(11,0,2151949307,1552317183);

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

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

INSERT INTO `bx_photos_cmts` VALUES (1,0,17,3,'nice night sky!!<br />\n',0,0,0,'2016-05-12 17:03:27',0),(4,0,24,3,'interesting photo. Looks like the work I do with people',0,0,0,'2016-06-28 15:05:47',0),(5,0,34,24,'hi fanny!',0,1,1,'2016-10-13 18:03:44',0),(6,0,26,24,'I love this photo of you!',0,0,0,'2016-10-13 18:04:05',0),(7,0,34,3,'How many of those can you eat?',0,0,0,'2016-10-18 12:25:51',0),(8,0,39,24,'what a gorgeous photo!<br />\n',0,0,0,'2016-11-04 17:59:36',0),(9,0,38,24,'beautiful ladies!<br />\n',0,0,0,'2016-11-04 18:00:11',0),(10,0,38,3,'lovely photo my dear!!! ',0,0,0,'2016-11-15 16:46:20',0);

--
-- 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 (26,2,10);

--
-- 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,1462471291),(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),(15,12,851164926,1459987867),(16,12,851164926,1461688650),(17,12,2923395480,1462471349),(18,12,851164926,1466094978),(21,12,851164926,1466100193),(24,3,2923395480,1466271283),(27,19,851164926,1466450186),(23,19,851164926,1467134211),(25,3,847959309,1468869992),(22,12,851164926,1482351343),(32,12,851164926,1471630426),(30,12,851164926,1471630469),(39,3,2923395480,1477921325),(43,3,2923395480,1479245566),(26,3,2923395480,1483894602),(35,12,1240338797,1495984496);

--
-- 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 (26,'65.34.5.210','2016-10-27 23:07:31'),(26,'73.68.171.113','2016-10-13 18:01:23');

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

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

INSERT INTO `bx_simple_messenger_messages` VALUES (6,'Hello!! :D',50,3,'2019-01-18 16:39:33','active','active');

--
-- 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),(27,5),(12,5),(37,3);

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

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

INSERT INTO `bx_wall_comments` VALUES (1,0,56,12,'Hey test',0,0,0,'2016-05-05 13:49:04',0),(2,0,97,3,'interesting',0,0,0,'2016-06-01 22:48:10',0);

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

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

INSERT INTO `bx_wall_events` VALUES (153,3,'4','ads','create','','Monique Hillen added new ad','Monique Hillen added new ad',0,1476406365,1,0),(154,0,'26','wall_common_text','','<div class=\"wall-post-text\">I\'m in</div>','PbZPJm4S9Z wrote','I\'m in',0,1476461268,1,0),(112,3,'23','bx_photos','commentPost','a:2:{s:10:\"comment_id\";i:2;s:17:\"comment_author_id\";i:3;}','Monique Hillen commented on a photo','The vision I have for the site :)',0,1466271667,1,0),(113,3,'26','bx_photos','add','a:2:{s:5:\"album\";s:14:\"Profile-photos\";s:12:\"privacy_view\";s:1:\"4\";}','Monique Hillen added new photo','',1,1466272057,1,0),(119,12,'12','wall_common_text','','<div class=\"wall-post-text\">test test</div>','ericamlee wrote','test test',0,1466451890,1,0),(162,23,'11','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1476784866,1,0),(163,23,'12','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1476784962,1,0),(164,23,'6','bx_groups','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1476785074,1,0),(166,23,'23','profile','edit','a:2:{s:14:\"OldProfileInfo\";a:65:{s:2:\"ID\";s:2:\"23\";s:8:\"NickName\";s:10:\"9Jukj2dZdQ\";s:5:\"Email\";s:23:\"revisionary@comcast.net\";s:8:\"Password\";s:40:\"6ddb413492e4d8ab2aa84d65eda3d27c91f12b2f\";s:4:\"Salt\";s:8:\"c8Jp2fvz\";s:6:\"Status\";s:6:\"Active\";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:263:\"I have 2 children  are out of the house now. I work freelance. I have a partner.  I feel most comfortable communicating and sharing time with women more than men., Even though I\'m in a relationship with a man.  Therefore I like the idea of an all women\'s website.\";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-10-13 10:56:29\";s:12:\"DateLastEdit\";s:19:\"0000-00-00 00:00:00\";s:13:\"DateLastLogin\";s:19:\"2016-10-18 05:51:10\";s:11:\"DateLastNav\";s:19:\"2016-10-18 06:10:37\";s:7:\"aff_num\";s:1:\"0\";s:4:\"Tags\";s:0:\"\";s:3:\"zip\";s:5:\"01060\";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: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:46:\"Astrology,Art,Dance,Movies,Reading,Videography\";s:9:\"Interests\";s:0:\"\";s:9:\"Ethnicity\";s:5:\"Human\";s:13:\"FavoriteSites\";s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";s:8:\"FullName\";s:16:\"Fanny Rothschild\";s:13:\"PoliticalView\";s:7:\"Liberal\";s:19:\"InterestsAltHealing\";s:52:\"Acupuncture,Chiropractic,Energy Therapies,Meditation\";s:12:\"InterestsArt\";s:28:\"Crafts,Videography,Galleries\";s:11:\"WomanStatus\";s:14:\"Involved Woman\";s:14:\"InterestsBooks\";s:37:\"Comedy,Drama,Fantasy,Literary Fiction\";s:22:\"InterestsEntertainment\";s:42:\"Animals,Concerts,Dancing,Traveling,Writing\";s:16:\"InterestsGeneral\";s:0:\"\";s:15:\"InterestsSports\";s:13:\"Aerobics,Yoga\";s:15:\"InterestsWomens\";s:136:\"Affordable Child Care,Equal Rights,Human Trafficking/Sex Slavery,Paid Sick and Parental Leave,Reproductive Rights,Violence Against Women\";s:14:\"InterestsMusic\";s:11:\"Banjo,Voice\";s:9:\"Education\";s:0:\"\";s:9:\"FirstName\";s:0:\"\";s:8:\"LastName\";s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";s:15:\"FacebookProfile\";s:0:\"\";}s:7:\"privacy\";i:3;}','Fanny Rothschild ','',0,1476785458,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),(176,27,'7','bx_events','commentPost','a:2:{s:10:\"comment_id\";i:6;s:17:\"comment_author_id\";i:27;}','','',0,1477624089,1,0),(177,0,'27','wall_common_text','','<div class=\"wall-post-text\">i wonder if any of my sisters might want to exchange wellness, exercise and nutrition information?</div>','dRVHThGtVA wrote','i wonder if any of my sisters might want to exchange wellness, exercise and nutrition information?',0,1477624142,1,0),(175,27,'27','profile','edit','a:2:{s:14:\"OldProfileInfo\";a:65:{s:2:\"ID\";s:2:\"27\";s:8:\"NickName\";s:10:\"dRVHThGtVA\";s:5:\"Email\";s:19:\"jensprung@yahoo.com\";s:8:\"Password\";s:40:\"7a56c39c56b20defacb6402bd606487fb4347d08\";s:4:\"Salt\";s:8:\"XvfHipGG\";s:6:\"Status\";s:6:\"Active\";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:1076:\"Hello, I am a nuerosomatic massage therapist, specializing in Visceral Manipulation, Temporomandibular Joint Dysfunction, Postural Distortions, Pelvic Floor, Trigger Point Therapy, Myofascial Release, Manual Therapies and more. I am a mother of three...a stepdaughter who is 43, a daughter who is 29 and a son who is 27. They, and my work, are my life. I am married to a very interesting fellow who sustains, supports and loves me deeply. I live in Amherst, MA and Treasure Island, FL. Working and teaching in both areas. My parents are still alive and thriving at 83 years of age. They live close to me. I am grateful and thankful. For many things. I work hard to support a healthy environment, eat whole organic foods, stay away from all chemicals in my life, home, work, etc. I have several causes that are close to my heart...creating safe healing for veterans and addicts, as well as my most amazing one year old grandson. A connection that is deep and true!\r\n I look forward to meeting people here and expanding my knowledge as well as sharing all there is to this life.\";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-10-14 20:22:02\";s:12:\"DateLastEdit\";s:19:\"2016-10-27 23:03:56\";s:13:\"DateLastLogin\";s:19:\"2016-10-27 22:53:32\";s:11:\"DateLastNav\";s:19:\"2016-10-27 23:03:57\";s:7:\"aff_num\";s:1:\"0\";s:4:\"Tags\";s:0:\"\";s:3:\"zip\";s:5:\"01002\";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:27:\"Spiritual but not religious\";s:18:\"RelationshipStatus\";s:0:\"\";s:7:\"Hobbies\";s:59:\"Astrology,Art,Beauty,Cycling,Crafts,Sculpting,Workout,Other\";s:9:\"Interests\";s:0:\"\";s:9:\"Ethnicity\";s:15:\"White/Caucasian\";s:13:\"FavoriteSites\";s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";s:8:\"FullName\";s:15:\"Jennifer Sprung\";s:13:\"PoliticalView\";s:12:\"Very Liberal\";s:19:\"InterestsAltHealing\";s:73:\"Acupuncture,Bio Feedback,Energy Therapies,Herbalism,Homeopathy,Meditation\";s:12:\"InterestsArt\";s:0:\"\";s:11:\"WomanStatus\";s:14:\"Involved Woman\";s:14:\"InterestsBooks\";s:22:\"Comedy,Fantasy,Fiction\";s:22:\"InterestsEntertainment\";s:16:\"Concerts,Writing\";s:16:\"InterestsGeneral\";s:0:\"\";s:15:\"InterestsSports\";s:53:\"Aerobics,Cycling,Swimming,Weight Lifting,Workout,Yoga\";s:15:\"InterestsWomens\";s:249:\"Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights\";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:15:\"FacebookProfile\";s:0:\"\";}s:7:\"privacy\";i:3;}','Jennifer Sprung ','',0,1477623852,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),(130,3,'3','wall_common_repost','','a:3:{s:4:\"type\";s:9:\"bx_photos\";s:6:\"action\";s:3:\"add\";s:9:\"object_id\";s:2:\"26\";}','Monique Hillen reposted a photo','',0,1468869798,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),(136,12,'2','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1471528528,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),(234,12,'23','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1546889299,1,0),(233,12,'22','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546888955,1,0),(208,12,'9','bx_groups','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1482437118,1,0),(209,3,'3','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:130:{i:0;s:1:\"3\";s:2:\"ID\";s:1:\"3\";i:1;s:10:\"persister1\";s:8:\"NickName\";s:10:\"persister1\";i:2;s:23:\"moniquehillen@gmail.com\";s:5:\"Email\";s:23:\"moniquehillen@gmail.com\";i:3;s:40:\"c2fcdbc19e4715893780825d39372754dcf7d148\";s:8:\"Password\";s:40:\"c2fcdbc19e4715893780825d39372754dcf7d148\";i:4;s:8:\"BSAxcFXM\";s:4:\"Salt\";s:8:\"BSAxcFXM\";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:6:\"female\";s:10:\"LookingFor\";s:6:\"female\";i:10;s:8:\"Founder1\";s:8:\"Headline\";s:8:\"Founder1\";i:11;s:105:\"Single mom of 3 sons, raised kids alone for the last 14 years. Although my last son just left the nest :(\";s:13:\"DescriptionMe\";s:105:\"Single mom of 3 sons, raised kids alone for the last 14 years. Although my last son just left the nest :(\";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:\"1960-05-15\";s:11:\"DateOfBirth\";s:10:\"1960-05-15\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-04-10 03:58:19\";s:7:\"DateReg\";s:19:\"2015-04-10 03:58:19\";i:17;s:19:\"2016-10-18 11:09:54\";s:12:\"DateLastEdit\";s:19:\"2016-10-18 11:09:54\";i:18;s:19:\"2017-03-10 10:47:22\";s:13:\"DateLastLogin\";s:19:\"2017-03-10 10:47:22\";i:19;s:19:\"2017-03-10 10:48:01\";s:11:\"DateLastNav\";s:19:\"2017-03-10 10:48:01\";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:\"0\";s:11:\"UpdateMatch\";s:1:\"0\";i:26;s:2:\"16\";s:5:\"Views\";s:2:\"16\";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:\"4\";s:13:\"allow_view_to\";s:1:\"4\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:38:\"wondering if this works. Cold outside \";s:17:\"UserStatusMessage\";s:38:\"wondering if this works. Cold outside \";i:34;s:10:\"1456942976\";s:21:\"UserStatusMessageWhen\";s:10:\"1456942976\";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:27:\"Spiritual but not religious\";s:17:\"SpiritualPractice\";s:27:\"Spiritual but not religious\";i:41;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:42;s:0:\"\";s:7:\"Hobbies\";s:0:\"\";i:43;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:44;s:5:\"Human\";s:9:\"Ethnicity\";s:5:\"Human\";i:45;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:49;s:14:\"Monique Hillen\";s:8:\"FullName\";s:14:\"Monique Hillen\";i:50;s:12:\"Very Liberal\";s:13:\"PoliticalView\";s:12:\"Very Liberal\";i:51;s:48:\"Energy Therapies,Herbalism,Homeopathy,Meditation\";s:19:\"InterestsAltHealing\";s:48:\"Energy Therapies,Herbalism,Homeopathy,Meditation\";i:52;s:38:\"Painting,Photography,Galleries,Museums\";s:12:\"InterestsArt\";s:38:\"Painting,Photography,Galleries,Museums\";i:53;s:26:\"Single Mother,Single Woman\";s:11:\"WomanStatus\";s:26:\"Single Mother,Single Woman\";i:54;s:19:\"Fiction,Non Fiction\";s:14:\"InterestsBooks\";s:19:\"Fiction,Non Fiction\";i:55;s:57:\"Concerts,Cooking,Dancing,Gardening,Hiking,Music,Traveling\";s:22:\"InterestsEntertainment\";s:57:\"Concerts,Cooking,Dancing,Gardening,Hiking,Music,Traveling\";i:56;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:57;s:19:\"Cycling,Golf,Tennis\";s:15:\"InterestsSports\";s:19:\"Cycling,Golf,Tennis\";i:58;s:168:\"Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Poverty,Violence Against Women,Women’s Rights\";s:15:\"InterestsWomens\";s:168:\"Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Poverty,Violence Against Women,Women’s Rights\";i:59;s:12:\"Viola,Violin\";s:14:\"InterestsMusic\";s:12:\"Viola,Violin\";i:60;s:15:\"Master\'s Degree\";s:9:\"Education\";s:15:\"Master\'s Degree\";i:61;s:0:\"\";s:9:\"FirstName\";s:0:\"\";i:62;s:0:\"\";s:8:\"LastName\";s:0:\"\";i:63;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";i:64;s:0:\"\";s:15:\"FacebookProfile\";s:0:\"\";}}','Monique Hillen edited her profile','',0,1489160893,1,0),(173,0,'27','wall_common_text','','<div class=\"wall-post-text\">Hello Everyone! I am very excited to be a member of PerSisters! Thank you!!!</div>','dRVHThGtVA wrote','Hello Everyone! I am very excited to be a member of PerSisters! Thank you!!!',0,1477623740,1,0),(174,27,'27','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:130:{i:0;s:2:\"27\";s:2:\"ID\";s:2:\"27\";i:1;s:10:\"dRVHThGtVA\";s:8:\"NickName\";s:10:\"dRVHThGtVA\";i:2;s:19:\"jensprung@yahoo.com\";s:5:\"Email\";s:19:\"jensprung@yahoo.com\";i:3;s:40:\"7a56c39c56b20defacb6402bd606487fb4347d08\";s:8:\"Password\";s:40:\"7a56c39c56b20defacb6402bd606487fb4347d08\";i:4;s:8:\"XvfHipGG\";s:4:\"Salt\";s:8:\"XvfHipGG\";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:0:\"\";s:3:\"Sex\";s:0:\"\";i:9;s:0:\"\";s:10:\"LookingFor\";s:0:\"\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:1076:\"Hello, I am a nuerosomatic massage therapist, specializing in Visceral Manipulation, Temporomandibular Joint Dysfunction, Postural Distortions, Pelvic Floor, Trigger Point Therapy, Myofascial Release, Manual Therapies and more. I am a mother of three...a stepdaughter who is 43, a daughter who is 29 and a son who is 27. They, and my work, are my life. I am married to a very interesting fellow who sustains, supports and loves me deeply. I live in Amherst, MA and Treasure Island, FL. Working and teaching in both areas. My parents are still alive and thriving at 83 years of age. They live close to me. I am grateful and thankful. For many things. I work hard to support a healthy environment, eat whole organic foods, stay away from all chemicals in my life, home, work, etc. I have several causes that are close to my heart...creating safe healing for veterans and addicts, as well as my most amazing one year old grandson. A connection that is deep and true!\r\n I look forward to meeting people here and expanding my knowledge as well as sharing all there is to this life.\";s:13:\"DescriptionMe\";s:1076:\"Hello, I am a nuerosomatic massage therapist, specializing in Visceral Manipulation, Temporomandibular Joint Dysfunction, Postural Distortions, Pelvic Floor, Trigger Point Therapy, Myofascial Release, Manual Therapies and more. I am a mother of three...a stepdaughter who is 43, a daughter who is 29 and a son who is 27. They, and my work, are my life. I am married to a very interesting fellow who sustains, supports and loves me deeply. I live in Amherst, MA and Treasure Island, FL. Working and teaching in both areas. My parents are still alive and thriving at 83 years of age. They live close to me. I am grateful and thankful. For many things. I work hard to support a healthy environment, eat whole organic foods, stay away from all chemicals in my life, home, work, etc. I have several causes that are close to my heart...creating safe healing for veterans and addicts, as well as my most amazing one year old grandson. A connection that is deep and true!\r\n I look forward to meeting people here and expanding my knowledge as well as sharing all there is to this life.\";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:0:\"\";s:4:\"City\";s:0:\"\";i:14;s:10:\"0000-00-00\";s:11:\"DateOfBirth\";s:10:\"0000-00-00\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2016-10-14 20:22:02\";s:7:\"DateReg\";s:19:\"2016-10-14 20:22:02\";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:\"2016-10-27 22:53:32\";s:13:\"DateLastLogin\";s:19:\"2016-10-27 22:53:32\";i:19;s:19:\"2016-10-27 23:03:36\";s:11:\"DateLastNav\";s:19:\"2016-10-27 23:03:36\";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:\"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:27:\"Spiritual but not religious\";s:17:\"SpiritualPractice\";s:27:\"Spiritual but not religious\";i:41;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:42;s:59:\"Astrology,Art,Beauty,Cycling,Crafts,Sculpting,Workout,Other\";s:7:\"Hobbies\";s:59:\"Astrology,Art,Beauty,Cycling,Crafts,Sculpting,Workout,Other\";i:43;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:44;s:15:\"White/Caucasian\";s:9:\"Ethnicity\";s:15:\"White/Caucasian\";i:45;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:49;s:15:\"Jennifer Sprung\";s:8:\"FullName\";s:15:\"Jennifer Sprung\";i:50;s:12:\"Very Liberal\";s:13:\"PoliticalView\";s:12:\"Very Liberal\";i:51;s:73:\"Acupuncture,Bio Feedback,Energy Therapies,Herbalism,Homeopathy,Meditation\";s:19:\"InterestsAltHealing\";s:73:\"Acupuncture,Bio Feedback,Energy Therapies,Herbalism,Homeopathy,Meditation\";i:52;s:0:\"\";s:12:\"InterestsArt\";s:0:\"\";i:53;s:14:\"Involved Woman\";s:11:\"WomanStatus\";s:14:\"Involved Woman\";i:54;s:22:\"Comedy,Fantasy,Fiction\";s:14:\"InterestsBooks\";s:22:\"Comedy,Fantasy,Fiction\";i:55;s:16:\"Concerts,Writing\";s:22:\"InterestsEntertainment\";s:16:\"Concerts,Writing\";i:56;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:57;s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";i:58;s:249:\"Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights\";s:15:\"InterestsWomens\";s:249:\"Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights\";i:59;s:0:\"\";s:14:\"InterestsMusic\";s:0:\"\";i:60;s:0:\"\";s:9:\"Education\";s:0:\"\";i:61;s:0:\"\";s:9:\"FirstName\";s:0:\"\";i:62;s:0:\"\";s:8:\"LastName\";s:0:\"\";i:63;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";i:64;s:0:\"\";s:15:\"FacebookProfile\";s:0:\"\";}}','Jennifer Sprung ','',0,1477623836,1,0),(169,3,'34','bx_photos','commentPost','a:2:{s:10:\"comment_id\";i:7;s:17:\"comment_author_id\";i:3;}','','',0,1476807951,1,0),(167,3,'24','friend','accept','','','',0,1476803039,1,0),(168,3,'3','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:130:{i:0;s:1:\"3\";s:2:\"ID\";s:1:\"3\";i:1;s:10:\"persister1\";s:8:\"NickName\";s:10:\"persister1\";i:2;s:23:\"moniquehillen@gmail.com\";s:5:\"Email\";s:23:\"moniquehillen@gmail.com\";i:3;s:40:\"ce9ff19a1ee379431a8abd8e009c8fee563989bc\";s:8:\"Password\";s:40:\"ce9ff19a1ee379431a8abd8e009c8fee563989bc\";i:4;s:9:\"NJE8UJ0WJ\";s:4:\"Salt\";s:9:\"NJE8UJ0WJ\";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:6:\"female\";s:10:\"LookingFor\";s:6:\"female\";i:10;s:8:\"Founder1\";s:8:\"Headline\";s:8:\"Founder1\";i:11;s:66:\"Single mom of 3 sons, raised kids alone for the last 12.5 years.  \";s:13:\"DescriptionMe\";s:66:\"Single mom of 3 sons, raised kids alone for the last 12.5 years.  \";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:\"1960-05-15\";s:11:\"DateOfBirth\";s:10:\"1960-05-15\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-04-10 03:58:19\";s:7:\"DateReg\";s:19:\"2015-04-10 03:58:19\";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:\"2016-10-14 19:40:26\";s:13:\"DateLastLogin\";s:19:\"2016-10-14 19:40:26\";i:19;s:19:\"2016-10-18 11:09:30\";s:11:\"DateLastNav\";s:19:\"2016-10-18 11:09:30\";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:\"0\";s:11:\"UpdateMatch\";s:1:\"0\";i:26;s:2:\"16\";s:5:\"Views\";s:2:\"16\";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:\"4\";s:13:\"allow_view_to\";s:1:\"4\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:38:\"wondering if this works. Cold outside \";s:17:\"UserStatusMessage\";s:38:\"wondering if this works. Cold outside \";i:34;s:10:\"1456942976\";s:21:\"UserStatusMessageWhen\";s:10:\"1456942976\";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:18:\"RelationshipStatus\";s:0:\"\";i:42;s:0:\"\";s:7:\"Hobbies\";s:0:\"\";i:43;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:44;s:0:\"\";s:9:\"Ethnicity\";s:0:\"\";i:45;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:49;s:14:\"Monique Hillen\";s:8:\"FullName\";s:14:\"Monique Hillen\";i:50;s:0:\"\";s:13:\"PoliticalView\";s:0:\"\";i:51;s:0:\"\";s:19:\"InterestsAltHealing\";s:0:\"\";i:52;s:0:\"\";s:12:\"InterestsArt\";s:0:\"\";i:53;s:0:\"\";s:11:\"WomanStatus\";s:0:\"\";i:54;s:0:\"\";s:14:\"InterestsBooks\";s:0:\"\";i:55;s:0:\"\";s:22:\"InterestsEntertainment\";s:0:\"\";i:56;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:57;s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";i:58;s:0:\"\";s:15:\"InterestsWomens\";s:0:\"\";i:59;s:0:\"\";s:14:\"InterestsMusic\";s:0:\"\";i:60;s:0:\"\";s:9:\"Education\";s:0:\"\";i:61;s:0:\"\";s:9:\"FirstName\";s:0:\"\";i:62;s:0:\"\";s:8:\"LastName\";s:0:\"\";i:63;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";i:64;s:0:\"\";s:15:\"FacebookProfile\";s:0:\"\";}}','Monique Hillen edited her profile','',0,1476803394,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),(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),(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),(60,12,'12','wall_common_link','','<div class=\"wall-post-link\">\r\n    <div class=\"wall-lnk-title bx-def-font-h2\">\r\n        <a href=\"http://www.bbc.com/travel/story/20160329-living-in-the-worlds-sunniest-cities\" target=\"_blank\">BBC - Travel - Living in the world’s sunniest cities</a>\r\n    </div>\r\n    \r\n		<div class=\"wall-lnk-thumbnail bx-def-padding-sec\">\r\n			<img class=\"bx-def-shadow bx-def-round-corners\" src=\"http://ichef.bbci.co.uk/wwfeatures/624_351/images/live/p0/3p/fc/p03pfcm1.jpg\" />\r\n		</div>\r\n	\r\n    <div class=\"wall-lnk-url\">\r\n        <a href=\"http://www.bbc.com/travel/story/20160329-living-in-the-worlds-sunniest-cities\" target=\"_blank\">http://www.bbc.com/travel/story/20160329-living-in-the-worlds-sunniest-cities</a>\r\n    </div>\r\n    <div class=\"wall-lnk-description\">In these five lucky locales, the sun can shine more than 90% of the time. We asked residents how they live their life when the skies are cloudless and blue.  </div>\r\n</div>','ericamlee shared a link','http://www.bbc.com/travel/story/20160329-living-in-the-worlds-sunniest-cities - BBC - Travel - Living in the world’s sunniest cities',0,1461002150,1,0),(62,12,'12','profile','edit_status_message','a:1:{i:0;s:0:\"\";}','Erik Amlee changed his profile status message','',0,1461255544,1,0),(110,3,'3','wall_common_photos','','a:2:{s:4:\"type\";s:6:\"photos\";s:2:\"id\";i:24;}','Monique Hillen added a photo','',0,1466271280,1,0),(104,12,'12','profile','edit','a:2:{s:14:\"OldProfileInfo\";a:64:{s:2:\"ID\";s:2:\"12\";s:8:\"NickName\";s:9:\"ericamlee\";s:5:\"Email\";s:19:\"erik@yesexactly.com\";s:8:\"Password\";s:40:\"412dce24cac5edc92b9e882ee55d9f0ec4cb9dd4\";s:4:\"Salt\";s:8:\"YTBqZkcC\";s:6:\"Status\";s:6:\"Active\";s:4:\"Role\";s:1:\"3\";s:6:\"Couple\";s:1:\"0\";s:3:\"Sex\";s:4:\"male\";s:10:\"LookingFor\";s:6:\"female\";s:8:\"Headline\";s:0:\"\";s:13:\"DescriptionMe\";s:0:\"\";s:7:\"Country\";s:2:\"US\";s:4:\"City\";s:7:\"Amherst\";s:11:\"DateOfBirth\";s:10:\"1966-06-06\";s:8:\"Featured\";s:1:\"0\";s:7:\"DateReg\";s:19:\"2015-08-27 02:07:34\";s:12:\"DateLastEdit\";s:19:\"2016-06-07 11:54:23\";s:13:\"DateLastLogin\";s:19:\"2016-06-16 12:08:49\";s:11:\"DateLastNav\";s:19:\"2016-06-16 13:30:25\";s:7:\"aff_num\";s:1:\"0\";s:4:\"Tags\";s:0:\"\";s:3:\"zip\";s:5:\"01002\";s:11:\"EmailNotify\";s:1:\"1\";s:6:\"LangID\";s:1:\"1\";s:11:\"UpdateMatch\";s:1:\"0\";s:5:\"Views\";s:1:\"8\";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:10:\"1461255544\";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:6:\"Single\";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:16:\"PerSisters Admin\";s:13:\"PoliticalView\";s:0:\"\";s:19:\"InterestsAltHealing\";s:0:\"\";s:12:\"InterestsArt\";s:0:\"\";s:11:\"WomanStatus\";s:13:\"Sponsor 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;}','PerSisters Admin edited his profile','',0,1466098228,1,0),(66,12,'12','wall_common_text','','<div class=\"wall-post-text\">https://www.google.com/#gws_rd=ssl</div>','ericamlee wrote','https://www.google.com/#gws_rd=ssl',0,1462470900,1,0),(67,12,'12','wall_common_text','','<div class=\"wall-post-text\">http://www.bbc.com/</div>','ericamlee wrote','http://www.bbc.com/',0,1462470915,1,0),(68,12,'12','wall_common_link','','<div class=\"wall-post-link\">\r\n    <div class=\"wall-lnk-title bx-def-font-h2\">\r\n        <a href=\"http://www.bbc.com/\" target=\"_blank\">BBC - Homepage</a>\r\n    </div>\r\n    \r\n    <div class=\"wall-lnk-url\">\r\n        <a href=\"http://www.bbc.com/\" target=\"_blank\">http://www.bbc.com/</a>\r\n    </div>\r\n    <div class=\"wall-lnk-description\">Breaking news, sport, TV, radio and a whole lot more. The BBC informs, educates and entertains - wherever you are, whatever your age.</div>\r\n</div>','ericamlee shared a link','http://www.bbc.com/ - BBC - Homepage',0,1462470923,1,0),(69,12,'12','wall_common_link','','<div class=\"wall-post-link\">\r\n    <div class=\"wall-lnk-title bx-def-font-h2\">\r\n        <a href=\"http://www.bbc.com/news/election-us-2016-36203799\" target=\"_blank\">US election: Will normal rules ultimately apply? - BBC News</a>\r\n    </div>\r\n    \r\n		<div class=\"wall-lnk-thumbnail bx-def-padding-sec\">\r\n			<img class=\"bx-def-shadow bx-def-round-corners\" src=\"http://ichef.bbci.co.uk/news/1024/cpsprodpb/611B/production/_89595842_032174578-1.jpg\" />\r\n		</div>\r\n	\r\n    <div class=\"wall-lnk-url\">\r\n        <a href=\"http://www.bbc.com/news/election-us-2016-36203799\" target=\"_blank\">http://www.bbc.com/news/election-us-2016-36203799</a>\r\n    </div>\r\n    <div class=\"wall-lnk-description\">Break-the-rules politics seems to be the order of the day, but normal and longstanding rules will most probably decide the outcome of the US presidential election.</div>\r\n</div>','ericamlee shared a link','http://www.bbc.com/news/election-us-2016-36203799 - US election: Will normal rules ultimately apply? - BBC News',0,1462470960,1,0),(111,3,'3','wall_common_text','','<div class=\"wall-post-text\">I want to see if I can edit my text after I post it. I could not figure it out when i posted a photo. I will try again. It all looks a bit too complicated right now. </div>','persister1 wrote','I want to see if I can edit my text after I post it. I could not figure it out when i posted a photo. I will try again. It all looks a bit too complicated right now. ',0,1466271418,1,0),(73,3,'17','bx_photos','commentPost','a:2:{s:10:\"comment_id\";i:1;s:17:\"comment_author_id\";i:3;}','Monique Hillen commented on a photo','nice night sky!!\n',0,1463087007,1,0),(84,0,'3','wall_common_text','','<div class=\"wall-post-text\">https://www.youtube.com/watch?v=EjM3NzGJ28I</div>','persister1 wrote','https://www.youtube.com/watch?v=EjM3NzGJ28I',0,1463670765,1,0),(85,0,'12','wall_common_text','','<div class=\"wall-post-text\">Test <br />\r\n<br />\r\nhttps://youtu.be/EqnUiEVgmAg</div>','ericamlee wrote','Test <br />\r\n<br />\r\nhttps://youtu.be/EqnUiEVgmAg',0,1463671603,1,0),(92,0,'12','wall_common_text','','<div class=\"wall-post-text\">http://www.bbc.com/travel/story/20160512-the-island-ready-to-welcome-the-world</div>','ericamlee wrote','http://www.bbc.com/travel/story/20160512-the-island-ready-to-welcome-the-world',0,1463762251,1,0),(106,12,'22','bx_photos','add','a:2:{s:5:\"album\";s:14:\"Profile-photos\";s:12:\"privacy_view\";s:1:\"4\";}','PerSisters Admin added new photo','',0,1466100255,1,0),(124,3,'24','bx_photos','commentPost','a:2:{s:10:\"comment_id\";i:4;s:17:\"comment_author_id\";i:3;}','','',0,1467140747,1,0),(149,0,'24','wall_common_photos','','a:2:{s:4:\"type\";s:6:\"photos\";s:2:\"id\";i:35;}','Robin Jaffin added a photo','',0,1476396187,1,0),(150,0,'24','wall_common_text','','<div class=\"wall-post-text\">I\'m so thrilled to be a member of PerSisters! </div>','zBQpjhpCG8 wrote','I\'m so thrilled to be a member of PerSisters! ',0,1476396196,1,0),(97,0,'12','wall_common_text','','<div class=\"wall-post-text\">Test <br />\r\n<br />\r\nhttp://www.bbc.com/culture/story/20160518-eight-of-the-greatest-optical-illusions-in-art</div>','ericamlee wrote','Test <br />\r\n<br />\r\nhttp://www.bbc.com/culture/story/20160518-eight-of-the-greatest-optical-illusions-in-art',1,1464097760,1,0),(155,26,'9','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1476462127,1,0),(156,24,'10','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1476468302,1,0),(157,24,'5','bx_groups','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1476468366,1,0),(158,24,'7','bx_events','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','Robin Jaffin added new event','help me get all the harvest into cans',0,1476468494,1,0),(159,24,'7','bx_events','commentPost','a:2:{s:10:\"comment_id\";i:5;s:17:\"comment_author_id\";i:24;}','','',0,1476468542,1,0),(160,24,'24','profile','edit','a:2:{s:14:\"OldProfileInfo\";a:65:{s:2:\"ID\";s:2:\"24\";s:8:\"NickName\";s:10:\"zBQpjhpCG8\";s:5:\"Email\";s:22:\"robin.jaffin@gmail.com\";s:8:\"Password\";s:40:\"79e84b74e0450d0b44801457fe643cd1aa7ee463\";s:4:\"Salt\";s:8:\"wy.+wFWR\";s:6:\"Status\";s:6:\"Active\";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:228:\"I am a 56 year old single woman living in New England with a grown daughter who lives on the West Coast. I am in a relationship but do not live with my partner. I love to garden, cook and spend as much time outside as possible. \";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-10-13 15:01:38\";s:12:\"DateLastEdit\";s:19:\"0000-00-00 00:00:00\";s:13:\"DateLastLogin\";s:19:\"2016-10-14 08:52:33\";s:11:\"DateLastNav\";s:19:\"2016-10-14 14:13:09\";s:7:\"aff_num\";s:1:\"0\";s:4:\"Tags\";s:0:\"\";s:3:\"zip\";s:5:\"01060\";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:7:\"Atheist\";s:18:\"RelationshipStatus\";s:0:\"\";s:7:\"Hobbies\";s:9:\"Gardening\";s:9:\"Interests\";s:0:\"\";s:9:\"Ethnicity\";s:15:\"White/Caucasian\";s:13:\"FavoriteSites\";s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";s:8:\"FullName\";s:12:\"Robin Jaffin\";s:13:\"PoliticalView\";s:7:\"Liberal\";s:19:\"InterestsAltHealing\";s:11:\"Acupuncture\";s:12:\"InterestsArt\";s:11:\"Photography\";s:11:\"WomanStatus\";s:12:\"Single Woman\";s:14:\"InterestsBooks\";s:7:\"Fiction\";s:22:\"InterestsEntertainment\";s:7:\"Dancing\";s:16:\"InterestsGeneral\";s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";s:15:\"InterestsWomens\";s:7:\"Poverty\";s:14:\"InterestsMusic\";s:0:\"\";s:9:\"Education\";s:14:\"Masters Degree\";s:9:\"FirstName\";s:0:\"\";s:8:\"LastName\";s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";s:15:\"FacebookProfile\";s:0:\"\";}s:7:\"privacy\";i:4;}','Robin Jaffin ','',0,1476468812,1,0),(161,24,'24','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:130:{i:0;s:2:\"24\";s:2:\"ID\";s:2:\"24\";i:1;s:10:\"zBQpjhpCG8\";s:8:\"NickName\";s:10:\"zBQpjhpCG8\";i:2;s:22:\"robin.jaffin@gmail.com\";s:5:\"Email\";s:22:\"robin.jaffin@gmail.com\";i:3;s:40:\"79e84b74e0450d0b44801457fe643cd1aa7ee463\";s:8:\"Password\";s:40:\"79e84b74e0450d0b44801457fe643cd1aa7ee463\";i:4;s:8:\"wy.+wFWR\";s:4:\"Salt\";s:8:\"wy.+wFWR\";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:0:\"\";s:3:\"Sex\";s:0:\"\";i:9;s:0:\"\";s:10:\"LookingFor\";s:0:\"\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:228:\"I am a 56 year old single woman living in New England with a grown daughter who lives on the West Coast. I am in a relationship but do not live with my partner. I love to garden, cook and spend as much time outside as possible. \";s:13:\"DescriptionMe\";s:228:\"I am a 56 year old single woman living in New England with a grown daughter who lives on the West Coast. I am in a relationship but do not live with my partner. I love to garden, cook and spend as much time outside as possible. \";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:0:\"\";s:4:\"City\";s:0:\"\";i:14;s:10:\"0000-00-00\";s:11:\"DateOfBirth\";s:10:\"0000-00-00\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2016-10-13 15:01:38\";s:7:\"DateReg\";s:19:\"2016-10-13 15:01:38\";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:\"2016-10-14 08:52:33\";s:13:\"DateLastLogin\";s:19:\"2016-10-14 08:52:33\";i:19;s:19:\"2016-10-14 14:16:03\";s:11:\"DateLastNav\";s:19:\"2016-10-14 14:16:03\";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:\"01060\";s:3:\"zip\";s:5:\"01060\";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:\"4\";s:13:\"allow_view_to\";s:1:\"4\";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:7:\"Atheist\";s:17:\"SpiritualPractice\";s:7:\"Atheist\";i:41;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:42;s:9:\"Gardening\";s:7:\"Hobbies\";s:9:\"Gardening\";i:43;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:44;s:15:\"White/Caucasian\";s:9:\"Ethnicity\";s:15:\"White/Caucasian\";i:45;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:49;s:12:\"Robin Jaffin\";s:8:\"FullName\";s:12:\"Robin Jaffin\";i:50;s:7:\"Liberal\";s:13:\"PoliticalView\";s:7:\"Liberal\";i:51;s:11:\"Acupuncture\";s:19:\"InterestsAltHealing\";s:11:\"Acupuncture\";i:52;s:11:\"Photography\";s:12:\"InterestsArt\";s:11:\"Photography\";i:53;s:12:\"Single Woman\";s:11:\"WomanStatus\";s:12:\"Single Woman\";i:54;s:7:\"Fiction\";s:14:\"InterestsBooks\";s:7:\"Fiction\";i:55;s:7:\"Dancing\";s:22:\"InterestsEntertainment\";s:7:\"Dancing\";i:56;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:57;s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";i:58;s:7:\"Poverty\";s:15:\"InterestsWomens\";s:7:\"Poverty\";i:59;s:0:\"\";s:14:\"InterestsMusic\";s:0:\"\";i:60;s:14:\"Masters Degree\";s:9:\"Education\";s:14:\"Masters Degree\";i:61;s:0:\"\";s:9:\"FirstName\";s:0:\"\";i:62;s:0:\"\";s:8:\"LastName\";s:0:\"\";i:63;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";i:64;s:0:\"\";s:15:\"FacebookProfile\";s:0:\"\";}}','Robin Jaffin ','',0,1476468982,1,0),(131,12,'12','wall_common_repost','','a:3:{s:4:\"type\";s:16:\"wall_common_text\";s:6:\"action\";s:0:\"\";s:9:\"object_id\";s:2:\"97\";}','PerSisters Admin reposted a text','',0,1468869808,1,0),(148,0,'23','wall_common_photos','','a:2:{s:4:\"type\";s:6:\"photos\";s:2:\"id\";i:34;}','Fanny Rothschild added a photo','',0,1476371189,1,0),(137,12,'3','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1471528571,1,0),(151,24,'34','bx_photos','commentPost','a:2:{s:10:\"comment_id\";i:5;s:17:\"comment_author_id\";i:24;}','','',0,1476396224,1,0),(152,24,'26','bx_photos','commentPost','a:2:{s:10:\"comment_id\";i:6;s:17:\"comment_author_id\";i:24;}','','',0,1476396245,1,0),(141,12,'4','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1471612114,1,0),(142,12,'5','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1471612114,1,0),(143,12,'6','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1471615896,1,0),(144,12,'7','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1471617320,1,0),(146,12,'8','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1471632819,1,0),(147,3,'3','wall_common_repost','','a:3:{s:4:\"type\";s:16:\"wall_common_text\";s:6:\"action\";s:0:\"\";s:9:\"object_id\";s:2:\"30\";}','Monique Hillen reposted a text','',0,1473872995,1,0),(178,27,'3','friend','accept','','','',0,1477924613,1,0),(179,25,'3','wall_common_text','','<div class=\"wall-post-text\">Hi Pam, How is the school thing going?!<br />\r\n</div>','persister1 wrote','Hi Pam, How is the school thing going?!<br />\r\n',0,1478104821,1,0),(184,24,'24','wall_common_repost','','a:3:{s:4:\"type\";s:18:\"wall_common_photos\";s:6:\"action\";s:0:\"\";s:9:\"object_id\";s:3:\"171\";}','Robin Jaffin reposted a photo','',0,1478296824,1,0),(185,24,'24','wall_common_repost','','a:3:{s:4:\"type\";s:18:\"wall_common_photos\";s:6:\"action\";s:0:\"\";s:9:\"object_id\";s:3:\"172\";}','Robin Jaffin reposted a photo','',0,1478296839,1,0),(187,24,'24','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:130:{i:0;s:2:\"24\";s:2:\"ID\";s:2:\"24\";i:1;s:10:\"zBQpjhpCG8\";s:8:\"NickName\";s:10:\"zBQpjhpCG8\";i:2;s:22:\"robin.jaffin@gmail.com\";s:5:\"Email\";s:22:\"robin.jaffin@gmail.com\";i:3;s:40:\"79e84b74e0450d0b44801457fe643cd1aa7ee463\";s:8:\"Password\";s:40:\"79e84b74e0450d0b44801457fe643cd1aa7ee463\";i:4;s:8:\"wy.+wFWR\";s:4:\"Salt\";s:8:\"wy.+wFWR\";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:0:\"\";s:3:\"Sex\";s:0:\"\";i:9;s:0:\"\";s:10:\"LookingFor\";s:0:\"\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:228:\"I am a 56 year old single woman living in New England with a grown daughter who lives on the West Coast. I am in a relationship but do not live with my partner. I love to garden, cook and spend as much time outside as possible. \";s:13:\"DescriptionMe\";s:228:\"I am a 56 year old single woman living in New England with a grown daughter who lives on the West Coast. I am in a relationship but do not live with my partner. I love to garden, cook and spend as much time outside as possible. \";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:0:\"\";s:4:\"City\";s:0:\"\";i:14;s:10:\"0000-00-00\";s:11:\"DateOfBirth\";s:10:\"0000-00-00\";i:15;s:1:\"1\";s:8:\"Featured\";s:1:\"1\";i:16;s:19:\"2016-10-13 15:01:38\";s:7:\"DateReg\";s:19:\"2016-10-13 15:01:38\";i:17;s:19:\"2016-10-14 14:16:22\";s:12:\"DateLastEdit\";s:19:\"2016-10-14 14:16:22\";i:18;s:19:\"2016-11-04 17:57:47\";s:13:\"DateLastLogin\";s:19:\"2016-11-04 17:57:47\";i:19;s:19:\"2016-11-04 18:16:29\";s:11:\"DateLastNav\";s:19:\"2016-11-04 18:16:29\";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:\"01060\";s:3:\"zip\";s:5:\"01060\";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:\"4\";s:13:\"allow_view_to\";s:1:\"4\";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:7:\"Atheist\";s:17:\"SpiritualPractice\";s:7:\"Atheist\";i:41;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:42;s:26:\"Crafts,Vegetable Gardening\";s:7:\"Hobbies\";s:26:\"Crafts,Vegetable Gardening\";i:43;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:44;s:15:\"White/Caucasian\";s:9:\"Ethnicity\";s:15:\"White/Caucasian\";i:45;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:49;s:12:\"Robin Jaffin\";s:8:\"FullName\";s:12:\"Robin Jaffin\";i:50;s:7:\"Liberal\";s:13:\"PoliticalView\";s:7:\"Liberal\";i:51;s:11:\"Acupuncture\";s:19:\"InterestsAltHealing\";s:11:\"Acupuncture\";i:52;s:11:\"Photography\";s:12:\"InterestsArt\";s:11:\"Photography\";i:53;s:12:\"Single Woman\";s:11:\"WomanStatus\";s:12:\"Single Woman\";i:54;s:7:\"Fiction\";s:14:\"InterestsBooks\";s:7:\"Fiction\";i:55;s:46:\"Animals,Antiques,Art,Cooking,Dancing,Gardening\";s:22:\"InterestsEntertainment\";s:46:\"Animals,Antiques,Art,Cooking,Dancing,Gardening\";i:56;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:57;s:0:\"\";s:15:\"InterestsSports\";s:0:\"\";i:58;s:0:\"\";s:15:\"InterestsWomens\";s:0:\"\";i:59;s:0:\"\";s:14:\"InterestsMusic\";s:0:\"\";i:60;s:0:\"\";s:9:\"Education\";s:0:\"\";i:61;s:0:\"\";s:9:\"FirstName\";s:0:\"\";i:62;s:0:\"\";s:8:\"LastName\";s:0:\"\";i:63;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";i:64;s:0:\"\";s:15:\"FacebookProfile\";s:0:\"\";}}','Robin Jaffin ','',0,1478297793,1,0),(188,24,'8','bx_events','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','Robin Jaffin added new event','Dog walking in the back field',0,1478297954,1,0),(189,24,'7','bx_groups','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','zBQpjhpCG8 added new group','got a dog? gotta walk them? let\'s do it together. ',1,1478298037,1,0),(193,3,'9','bx_events','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','Monique Hillen added new event','bla bla bla dogs',0,1479247487,1,0),(194,3,'3','wall_common_repost','','a:3:{s:4:\"type\";s:9:\"bx_groups\";s:6:\"action\";s:3:\"add\";s:9:\"object_id\";s:1:\"7\";}','Monique Hillen reposted a group','',0,1479247660,1,0),(195,3,'8','bx_groups','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','persister1 added new group','We stand strong against sexism',0,1479248285,1,0),(196,3,'13','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1479249051,1,0),(213,0,'37','wall_common_text','','<div class=\"wall-post-text\">A wonderful Good Morning to everyone !</div>','86sHuX9XKv wrote','A wonderful Good Morning to everyone !',0,1529584381,1,0),(217,37,'50','bx_photos','add','a:2:{s:5:\"album\";s:14:\"Profile-Photos\";s:12:\"privacy_view\";s:1:\"5\";}','Francis added new photo','',0,1546714760,1,0),(218,37,'37','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:128:{i:0;s:2:\"37\";s:2:\"ID\";s:2:\"37\";i:1;s:10:\"86sHuX9XKv\";s:8:\"NickName\";s:10:\"86sHuX9XKv\";i:2;s:18:\"noremac180@aol.com\";s:5:\"Email\";s:18:\"noremac180@aol.com\";i:3;s:40:\"e8a25bc37329fd4d190f4de512ea00db50d8baf0\";s:8:\"Password\";s:40:\"e8a25bc37329fd4d190f4de512ea00db50d8baf0\";i:4;s:8:\"K+B.W2V/\";s:4:\"Salt\";s:8:\"K+B.W2V/\";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:0:\"\";s:3:\"Sex\";s:0:\"\";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:\"0000-00-00\";s:11:\"DateOfBirth\";s:10:\"0000-00-00\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2017-03-10 10:56:29\";s:7:\"DateReg\";s:19:\"2017-03-10 10:56:29\";i:17;s:19:\"2018-06-21 08:57:35\";s:12:\"DateLastEdit\";s:19:\"2018-06-21 08:57:35\";i:18;s:19:\"2019-01-05 13:47:24\";s:13:\"DateLastLogin\";s:19:\"2019-01-05 13:47:24\";i:19;s:19:\"2019-01-05 14:02:25\";s:11:\"DateLastNav\";s:19:\"2019-01-05 14: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:10:\"10065-7794\";s:3:\"zip\";s:10:\"10065-7794\";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:\"2\";s:5:\"Views\";s:1:\"2\";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:22:\"Christian / Protestant\";s:17:\"SpiritualPractice\";s:22:\"Christian / Protestant\";i:41;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:42;s:111:\"Animals,Antiques,Cooking,Cycling,Gardening,Movies,Museums,Music,Photography,Play Sports,Watching Sports,Workout\";s:7:\"Hobbies\";s:111:\"Animals,Antiques,Cooking,Cycling,Gardening,Movies,Museums,Music,Photography,Play Sports,Watching Sports,Workout\";i:43;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:44;s:15:\"White/Caucasian\";s:9:\"Ethnicity\";s:15:\"White/Caucasian\";i:45;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:49;s:7:\"Francis\";s:8:\"FullName\";s:7:\"Francis\";i:50;s:18:\"Middle of The Road\";s:13:\"PoliticalView\";s:18:\"Middle of The Road\";i:51;s:0:\"\";s:19:\"InterestsAltHealing\";s:0:\"\";i:52;s:19:\"Photography,Museums\";s:12:\"InterestsArt\";s:19:\"Photography,Museums\";i:53;s:14:\"Involved Woman\";s:11:\"WomanStatus\";s:14:\"Involved Woman\";i:54;s:17:\"Fiction,Thrillers\";s:14:\"InterestsBooks\";s:17:\"Fiction,Thrillers\";i:55;s:68:\"Animals,Antiques,Cooking,Gardening,Music,Physical Exercise,Traveling\";s:22:\"InterestsEntertainment\";s:68:\"Animals,Antiques,Cooking,Gardening,Music,Physical Exercise,Traveling\";i:56;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:57;s:79:\"Cycling,Football,Golf,Racquetball,Skiing,Soccer,Swimming,Weight Lifting,Workout\";s:15:\"InterestsSports\";s:79:\"Cycling,Football,Golf,Racquetball,Skiing,Soccer,Swimming,Weight Lifting,Workout\";i:58;s:68:\"Discrimination in the Work Force,Equal Rights,Violence Against Women\";s:15:\"InterestsWomens\";s:68:\"Discrimination in the Work Force,Equal Rights,Violence Against Women\";i:59;s:13:\"Piano,Trumpet\";s:14:\"InterestsMusic\";s:13:\"Piano,Trumpet\";i:60;s:15:\"Master\'s Degree\";s:9:\"Education\";s:15:\"Master\'s Degree\";i:61;s:0:\"\";s:9:\"FirstName\";s:0:\"\";i:62;s:0:\"\";s:8:\"LastName\";s:0:\"\";i:63;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";}}','Liz Francis ','',0,1546714973,1,0),(219,37,'37','profile','edit','a:2:{s:14:\"OldProfileInfo\";a:64:{s:2:\"ID\";s:2:\"37\";s:8:\"NickName\";s:10:\"86sHuX9XKv\";s:5:\"Email\";s:18:\"noremac180@aol.com\";s:8:\"Password\";s:40:\"e8a25bc37329fd4d190f4de512ea00db50d8baf0\";s:4:\"Salt\";s:8:\"K+B.W2V/\";s:6:\"Status\";s:6:\"Active\";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:63:\"Divorced single mother with grown twins living in New York City\";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:\"2017-03-10 10:56:29\";s:12:\"DateLastEdit\";s:19:\"2019-01-05 14:02:53\";s:13:\"DateLastLogin\";s:19:\"2019-01-05 13:47:24\";s:11:\"DateLastNav\";s:19:\"2019-01-05 14:02:54\";s:7:\"aff_num\";s:1:\"0\";s:4:\"Tags\";s:0:\"\";s:3:\"zip\";s:10:\"10065-7794\";s:11:\"EmailNotify\";s:1:\"1\";s:6:\"LangID\";s:1:\"1\";s:11:\"UpdateMatch\";s:1:\"0\";s:5:\"Views\";s:1:\"2\";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:22:\"Christian / Protestant\";s:18:\"RelationshipStatus\";s:0:\"\";s:7:\"Hobbies\";s:119:\"Animals,Antiques,Cooking,Cycling,Fashion,Gardening,Movies,Museums,Music,Photography,Play Sports,Watching Sports,Workout\";s:9:\"Interests\";s:0:\"\";s:9:\"Ethnicity\";s:15:\"White/Caucasian\";s:13:\"FavoriteSites\";s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";s:8:\"FullName\";s:11:\"Liz Francis\";s:13:\"PoliticalView\";s:18:\"Middle of The Road\";s:19:\"InterestsAltHealing\";s:0:\"\";s:12:\"InterestsArt\";s:19:\"Photography,Museums\";s:11:\"WomanStatus\";s:28:\"Single Mother,Involved Woman\";s:14:\"InterestsBooks\";s:23:\"Drama,Fiction,Thrillers\";s:22:\"InterestsEntertainment\";s:79:\"Animals,Antiques,Cooking,Decorating,Gardening,Music,Physical Exercise,Traveling\";s:16:\"InterestsGeneral\";s:0:\"\";s:15:\"InterestsSports\";s:84:\"Cycling,Football,Golf,Racquetball,Skiing,Soccer,Swimming,Weight Lifting,Workout,Yoga\";s:15:\"InterestsWomens\";s:68:\"Discrimination in the Work Force,Equal Rights,Violence Against Women\";s:14:\"InterestsMusic\";s:13:\"Piano,Trumpet\";s:9:\"Education\";s:15:\"Master\'s Degree\";s:9:\"FirstName\";s:0:\"\";s:8:\"LastName\";s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";}s:7:\"privacy\";i:3;}','Liz Francis ','',0,1546714984,1,0),(220,3,'3','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:128:{i:0;s:1:\"3\";s:2:\"ID\";s:1:\"3\";i:1;s:10:\"persister1\";s:8:\"NickName\";s:10:\"persister1\";i:2;s:23:\"moniquehillen@gmail.com\";s:5:\"Email\";s:23:\"moniquehillen@gmail.com\";i:3;s:40:\"c0fe32a552b86b3d7efb5021386cc6c508670734\";s:8:\"Password\";s:40:\"c0fe32a552b86b3d7efb5021386cc6c508670734\";i:4;s:8:\"BSAxcFXM\";s:4:\"Salt\";s:8:\"BSAxcFXM\";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:6:\"female\";s:10:\"LookingFor\";s:6:\"female\";i:10;s:8:\"Founder1\";s:8:\"Headline\";s:8:\"Founder1\";i:11;s:105:\"Single mom of 3 sons, raised kids alone for the last 14 years. Although my last son just left the nest :(\";s:13:\"DescriptionMe\";s:105:\"Single mom of 3 sons, raised kids alone for the last 14 years. Although my last son just left the nest :(\";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:\"1960-05-15\";s:11:\"DateOfBirth\";s:10:\"1960-05-15\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2015-04-10 03:58:19\";s:7:\"DateReg\";s:19:\"2015-04-10 03:58:19\";i:17;s:19:\"2017-07-25 17:51:34\";s:12:\"DateLastEdit\";s:19:\"2017-07-25 17:51:34\";i:18;s:19:\"2019-01-05 15:15:01\";s:13:\"DateLastLogin\";s:19:\"2019-01-05 15:15:01\";i:19;s:19:\"2019-01-05 15:15:58\";s:11:\"DateLastNav\";s:19:\"2019-01-05 15:15:58\";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:\"0\";s:11:\"UpdateMatch\";s:1:\"0\";i:26;s:2:\"16\";s:5:\"Views\";s:2:\"16\";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:\"4\";s:13:\"allow_view_to\";s:1:\"4\";i:32;s:6:\"online\";s:10:\"UserStatus\";s:6:\"online\";i:33;s:38:\"wondering if this works. Cold outside \";s:17:\"UserStatusMessage\";s:38:\"wondering if this works. Cold outside \";i:34;s:10:\"1456942976\";s:21:\"UserStatusMessageWhen\";s:10:\"1456942976\";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:27:\"Spiritual but not religious\";s:17:\"SpiritualPractice\";s:27:\"Spiritual but not religious\";i:41;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:42;s:0:\"\";s:7:\"Hobbies\";s:0:\"\";i:43;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:44;s:5:\"Human\";s:9:\"Ethnicity\";s:5:\"Human\";i:45;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:49;s:14:\"Monique Hillen\";s:8:\"FullName\";s:14:\"Monique Hillen\";i:50;s:12:\"Very Liberal\";s:13:\"PoliticalView\";s:12:\"Very Liberal\";i:51;s:48:\"Energy Therapies,Herbalism,Homeopathy,Meditation\";s:19:\"InterestsAltHealing\";s:48:\"Energy Therapies,Herbalism,Homeopathy,Meditation\";i:52;s:38:\"Painting,Photography,Galleries,Museums\";s:12:\"InterestsArt\";s:38:\"Painting,Photography,Galleries,Museums\";i:53;s:26:\"Single Mother,Single Woman\";s:11:\"WomanStatus\";s:26:\"Single Mother,Single Woman\";i:54;s:19:\"Fiction,Non Fiction\";s:14:\"InterestsBooks\";s:19:\"Fiction,Non Fiction\";i:55;s:57:\"Concerts,Cooking,Dancing,Gardening,Hiking,Music,Traveling\";s:22:\"InterestsEntertainment\";s:57:\"Concerts,Cooking,Dancing,Gardening,Hiking,Music,Traveling\";i:56;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:57;s:19:\"Cycling,Golf,Tennis\";s:15:\"InterestsSports\";s:19:\"Cycling,Golf,Tennis\";i:58;s:168:\"Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Poverty,Violence Against Women,Women’s Rights\";s:15:\"InterestsWomens\";s:168:\"Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Poverty,Violence Against Women,Women’s Rights\";i:59;s:12:\"Viola,Violin\";s:14:\"InterestsMusic\";s:12:\"Viola,Violin\";i:60;s:15:\"Master\'s Degree\";s:9:\"Education\";s:15:\"Master\'s Degree\";i:61;s:0:\"\";s:9:\"FirstName\";s:0:\"\";i:62;s:0:\"\";s:8:\"LastName\";s:0:\"\";i:63;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";}}','Monique Hillen edited her profile','',0,1546719382,1,0),(221,3,'14','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546719891,1,0),(222,3,'15','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546720045,1,0),(223,12,'16','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546720185,1,0),(224,3,'7','ads','create','','Monique Hillen added new ad','Monique Hillen added new ad',0,1546720203,1,0),(225,12,'17','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546720282,1,0),(226,12,'10','bx_groups','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1546720333,1,0),(227,3,'11','bx_groups','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1546720603,1,0),(228,12,'18','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546720776,1,0),(232,3,'21','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546882288,1,0),(230,12,'19','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546721437,1,0),(231,12,'20','modzzz_articles','add','a:1:{s:6:\"Status\";s:5:\"draft\";}','','',0,1546721630,1,0),(235,12,'24','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1546889340,1,0),(236,12,'25','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1546890700,1,0),(237,12,'26','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1546966003,1,0),(238,24,'3','friend','accept','','','',0,1546977226,1,0),(239,12,'27','modzzz_articles','add','a:1:{s:6:\"Status\";s:8:\"approved\";}','','',0,1547051297,1,0),(240,50,'50','profile','edit','a:1:{s:14:\"OldProfileInfo\";a:128:{i:0;s:2:\"50\";s:2:\"ID\";s:2:\"50\";i:1;s:10:\"aR5qUuRMG7\";s:8:\"NickName\";s:10:\"aR5qUuRMG7\";i:2;s:24:\"evadandylion@hotmail.com\";s:5:\"Email\";s:24:\"evadandylion@hotmail.com\";i:3;s:40:\"2f2532544972e97834574f59af93e8565fabeb56\";s:8:\"Password\";s:40:\"2f2532544972e97834574f59af93e8565fabeb56\";i:4;s:8:\"BrstNam&\";s:4:\"Salt\";s:8:\"BrstNam&\";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:0:\"\";s:3:\"Sex\";s:0:\"\";i:9;s:0:\"\";s:10:\"LookingFor\";s:0:\"\";i:10;s:0:\"\";s:8:\"Headline\";s:0:\"\";i:11;s:3:\"⭐\";s:13:\"DescriptionMe\";s:3:\"⭐\";i:12;s:2:\"US\";s:7:\"Country\";s:2:\"US\";i:13;s:0:\"\";s:4:\"City\";s:0:\"\";i:14;s:10:\"0000-00-00\";s:11:\"DateOfBirth\";s:10:\"0000-00-00\";i:15;s:1:\"0\";s:8:\"Featured\";s:1:\"0\";i:16;s:19:\"2019-01-18 11:31:41\";s:7:\"DateReg\";s:19:\"2019-01-18 11:31:41\";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:\"2019-01-18 11:33:27\";s:13:\"DateLastLogin\";s:19:\"2019-01-18 11:33:27\";i:19;s:19:\"2019-01-18 11:41:42\";s:11:\"DateLastNav\";s:19:\"2019-01-18 11:41:42\";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:\"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:27:\"Spiritual but not religious\";s:17:\"SpiritualPractice\";s:27:\"Spiritual but not religious\";i:41;s:0:\"\";s:18:\"RelationshipStatus\";s:0:\"\";i:42;s:277:\"Animals,Antiques,Art,Astrology,Beauty,Camping,Concerts,Cooking,Crafts,Dancing,Decorating,Drawing,Fashion,Galleries,Gardening,Health,Hiking,Jewelry Making,Kids Arts/Crafts,Knitting,Museums,Music,Painting,Photography,Reading,Singing,Sewing,Sculpture,Traveling,Woodworking,Writing\";s:7:\"Hobbies\";s:277:\"Animals,Antiques,Art,Astrology,Beauty,Camping,Concerts,Cooking,Crafts,Dancing,Decorating,Drawing,Fashion,Galleries,Gardening,Health,Hiking,Jewelry Making,Kids Arts/Crafts,Knitting,Museums,Music,Painting,Photography,Reading,Singing,Sewing,Sculpture,Traveling,Woodworking,Writing\";i:43;s:0:\"\";s:9:\"Interests\";s:0:\"\";i:44;s:5:\"Human\";s:9:\"Ethnicity\";s:5:\"Human\";i:45;s:0:\"\";s:13:\"FavoriteSites\";s:0:\"\";i:46;s:0:\"\";s:13:\"FavoriteMusic\";s:0:\"\";i:47;s:0:\"\";s:13:\"FavoriteFilms\";s:0:\"\";i:48;s:0:\"\";s:13:\"FavoriteBooks\";s:0:\"\";i:49;s:3:\"Eva\";s:8:\"FullName\";s:3:\"Eva\";i:50;s:19:\"Other Point of View\";s:13:\"PoliticalView\";s:19:\"Other Point of View\";i:51;s:51:\"Acupuncture,Chiropractic,Energy Therapies,Herbalism\";s:19:\"InterestsAltHealing\";s:51:\"Acupuncture,Chiropractic,Energy Therapies,Herbalism\";i:52;s:56:\"Crafts,Drawing,Jewelry Making,Painting,Galleries,Museums\";s:12:\"InterestsArt\";s:56:\"Crafts,Drawing,Jewelry Making,Painting,Galleries,Museums\";i:53;s:12:\"Single Woman\";s:11:\"WomanStatus\";s:12:\"Single Woman\";i:54;s:99:\"Comedy,Drama,Erotica,Fantasy,Fiction,Literary Fiction,Mystery,Non Fiction,Romance,Science,Thrillers\";s:14:\"InterestsBooks\";s:99:\"Comedy,Drama,Erotica,Fantasy,Fiction,Literary Fiction,Mystery,Non Fiction,Romance,Science,Thrillers\";i:55;s:0:\"\";s:22:\"InterestsEntertainment\";s:0:\"\";i:56;s:0:\"\";s:16:\"InterestsGeneral\";s:0:\"\";i:57;s:19:\"Swimming,Yoga,Zumba\";s:15:\"InterestsSports\";s:19:\"Swimming,Yoga,Zumba\";i:58;s:249:\"Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights\";s:15:\"InterestsWomens\";s:249:\"Affordable Child Care,Discrimination in the Work Force,Equal Rights,Free Speech,Health,Human Trafficking/Sex Slavery,Inadequate Representation,Paid Sick and Parental Leave,Poverty,Pregnancy,Reproductive Rights,Violence Against Women,Women’s Rights\";i:59;s:31:\"Banjo,Djembe Drum,Ukulele,Voice\";s:14:\"InterestsMusic\";s:31:\"Banjo,Djembe Drum,Ukulele,Voice\";i:60;s:12:\"Some College\";s:9:\"Education\";s:12:\"Some College\";i:61;s:0:\"\";s:9:\"FirstName\";s:0:\"\";i:62;s:0:\"\";s:8:\"LastName\";s:0:\"\";i:63;s:0:\"\";s:8:\"NEW_ITEM\";s:0:\"\";}}','Eva D ','',0,1547829719,1,0),(241,3,'50','friend','accept','','','',0,1547850974,1,0),(242,3,'3','wall_common_text','','<div class=\"wall-post-text\">Hello to everyone!! Welcome to PerSisters, our brand new and free social media for single mothers and women. I worked on it for over 2 years so I truly excited for it to take off. I need your help with this. Please spread the word because the more members, the more mutual support. </div>','persister1 wrote','Hello to everyone!! Welcome to PerSisters, our brand new and free social media for single mothers and women. I worked on it for over 2 years so I truly excited for it to take off. I need your help with this. Please spread the word because the more members, the more mutual support. ',0,1547935887,1,0),(243,45,'57','friend','accept','','','',0,1550336134,1,0),(244,45,'54','bx_photos','add','a:2:{s:5:\"album\";s:10:\"02-16-2019\";s:12:\"privacy_view\";s:1:\"5\";}','Susan Lowery added new photo','',0,1550336677,1,0),(246,23,'57','friend','accept','','','',0,1550340796,1,0),(247,23,'3','friend','accept','','','',0,1550340797,1,0);

--
