--
-- Host: localhost    Database: ruspanc1_bvlt1
-- ------------------------------------------------------


--
-- Table structure for table `evo_antispam`
--

CREATE TABLE `evo_antispam` (
  `aspm_ID` bigint(11) NOT NULL auto_increment,
  `aspm_string` varchar(80) character set utf8 NOT NULL,
  `aspm_source` enum('local','reported','central') character set utf8 NOT NULL default 'reported',
  PRIMARY KEY  (`aspm_ID`),
  UNIQUE KEY `aspm_string` (`aspm_string`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_antispam`
--

INSERT INTO `evo_antispam` VALUES (1,'online-casino','reported'),(2,'penis-enlargement','reported'),(3,'order-viagra','reported'),(4,'order-phentermine','reported'),(5,'order-xenical','reported'),(6,'order-prophecia','reported'),(7,'sexy-lingerie','reported'),(8,'-porn-','reported'),(9,'-adult-','reported'),(10,'-tits-','reported'),(11,'buy-phentermine','reported'),(12,'order-cheap-pills','reported'),(13,'buy-xenadrine','reported'),(14,'xxx','reported'),(15,'paris-hilton','reported'),(16,'parishilton','reported'),(17,'camgirls','reported'),(18,'adult-models','reported');

--
-- Table structure for table `evo_basedomains`
--

CREATE TABLE `evo_basedomains` (
  `dom_ID` int(11) unsigned NOT NULL auto_increment,
  `dom_name` varchar(250) character set utf8 NOT NULL,
  `dom_status` enum('unknown','whitelist','blacklist') character set utf8 NOT NULL default 'unknown',
  `dom_type` enum('unknown','normal','searcheng','aggregator') character set utf8 NOT NULL default 'unknown',
  PRIMARY KEY  (`dom_ID`),
  UNIQUE KEY `dom_name` (`dom_name`),
  KEY `dom_type` (`dom_type`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_basedomains`
--

INSERT INTO `evo_basedomains` VALUES (4,'ruspan.com','unknown','unknown');

--
-- Table structure for table `evo_bloggroups`
--

CREATE TABLE `evo_bloggroups` (
  `bloggroup_blog_ID` int(11) unsigned NOT NULL default '0',
  `bloggroup_group_ID` int(11) unsigned NOT NULL default '0',
  `bloggroup_ismember` tinyint(4) NOT NULL default '0',
  `bloggroup_perm_poststatuses` set('published','deprecated','protected','private','draft','redirected') collate utf8_unicode_ci NOT NULL default '',
  `bloggroup_perm_edit` enum('no','own','lt','le','all','redirected') collate utf8_unicode_ci NOT NULL default 'no',
  `bloggroup_perm_delpost` tinyint(4) NOT NULL default '0',
  `bloggroup_perm_comments` tinyint(4) NOT NULL default '0',
  `bloggroup_perm_cats` tinyint(4) NOT NULL default '0',
  `bloggroup_perm_properties` tinyint(4) NOT NULL default '0',
  `bloggroup_perm_admin` tinyint(4) NOT NULL default '0',
  `bloggroup_perm_media_upload` tinyint(4) NOT NULL default '0',
  `bloggroup_perm_media_browse` tinyint(4) NOT NULL default '0',
  `bloggroup_perm_media_change` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`bloggroup_blog_ID`,`bloggroup_group_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_bloggroups`
--

INSERT INTO `evo_bloggroups` VALUES (1,1,1,'published,deprecated,protected,private,draft','no',1,1,1,1,0,1,1,1),(1,2,1,'published,deprecated,protected,private,draft','no',1,1,0,0,0,1,1,1),(1,3,1,'published,deprecated,protected,private,draft','no',0,0,0,0,0,1,1,0),(1,4,1,'','no',0,0,0,0,0,0,0,0),(2,1,1,'published,deprecated,protected,private,draft','no',1,1,1,1,0,1,1,1),(2,2,1,'published,deprecated,protected,private,draft','no',1,1,0,0,0,1,1,1),(2,3,1,'published,deprecated,protected,private,draft','no',0,0,0,0,0,1,1,0),(2,4,1,'','no',0,0,0,0,0,0,0,0),(3,1,1,'published,deprecated,protected,private,draft','no',1,1,1,1,0,1,1,1),(3,2,1,'published,deprecated,protected,private,draft','no',1,1,0,0,0,1,1,1),(3,3,1,'published,deprecated,protected,private,draft','no',0,0,0,0,0,1,1,0),(3,4,1,'','no',0,0,0,0,0,0,0,0);

--
-- Table structure for table `evo_blogs`
--

CREATE TABLE `evo_blogs` (
  `blog_ID` int(11) unsigned NOT NULL auto_increment,
  `blog_shortname` varchar(255) collate utf8_unicode_ci default '',
  `blog_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `blog_owner_user_ID` int(11) unsigned NOT NULL default '1',
  `blog_advanced_perms` tinyint(1) NOT NULL default '0',
  `blog_tagline` varchar(250) collate utf8_unicode_ci default '',
  `blog_description` varchar(250) collate utf8_unicode_ci default '',
  `blog_longdesc` text collate utf8_unicode_ci,
  `blog_locale` varchar(20) collate utf8_unicode_ci NOT NULL default 'en-EU',
  `blog_access_type` varchar(10) collate utf8_unicode_ci NOT NULL default 'index.php',
  `blog_siteurl` varchar(120) collate utf8_unicode_ci NOT NULL default '',
  `blog_urlname` varchar(255) collate utf8_unicode_ci NOT NULL default 'urlname',
  `blog_notes` text collate utf8_unicode_ci,
  `blog_keywords` tinytext collate utf8_unicode_ci,
  `blog_allowcomments` varchar(20) collate utf8_unicode_ci NOT NULL default 'post_by_post',
  `blog_allowtrackbacks` tinyint(1) NOT NULL default '0',
  `blog_allowblogcss` tinyint(1) NOT NULL default '1',
  `blog_allowusercss` tinyint(1) NOT NULL default '1',
  `blog_skin_ID` int(10) unsigned NOT NULL default '1',
  `blog_in_bloglist` tinyint(1) NOT NULL default '1',
  `blog_links_blog_ID` int(11) default NULL,
  `blog_media_location` enum('default','subdir','custom','none') collate utf8_unicode_ci NOT NULL default 'default',
  `blog_media_subdir` varchar(255) collate utf8_unicode_ci default NULL,
  `blog_media_fullpath` varchar(255) collate utf8_unicode_ci default NULL,
  `blog_media_url` varchar(255) collate utf8_unicode_ci default NULL,
  `blog_UID` varchar(20) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`blog_ID`),
  UNIQUE KEY `blog_urlname` (`blog_urlname`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_blogs`
--

INSERT INTO `evo_blogs` VALUES (1,'Russia_span','Russia Span',1,0,'For those interested in Russian and Russian culture','','','en-US','default','','russiaspan',NULL,NULL,'post_by_post',1,1,0,19,1,NULL,'default',NULL,NULL,NULL,NULL),(2,'Russspan','Ru-ssss-pan',1,0,'For those interested in English-Russian translation and interpretation','','This blog touches upon the issues of translation from English into Russian and from Russian into English.','en-US','relative','blog2.php','russspan',NULL,NULL,'post_by_post',0,1,1,19,1,NULL,'default',NULL,NULL,NULL,NULL),(3,'Linkblog','Linkblog',1,0,'Some interesting links...','','This is the long description for the blog named \'Linkblog\'. <br />\n<br />\n<strong>The main purpose for this blog is to be included as a side item to other blogs where it will display your favorite/related links.</strong>','en-US','relative','blog3.php','links',NULL,NULL,'post_by_post',0,1,1,20,1,NULL,'default',NULL,NULL,NULL,NULL),(4,'Photoblog','Photoblog',1,0,'This blog shows photos...','','This is the long description for the blog named \'Photoblog\'. <br />\n<br />\n<strong>This is a photoblog, optimized for displaying photos.</strong>','en-US','relative','blog4.php','photos',NULL,NULL,'post_by_post',0,1,1,19,1,NULL,'default',NULL,NULL,NULL,NULL);

--
-- Table structure for table `evo_blogusers`
--

CREATE TABLE `evo_blogusers` (
  `bloguser_blog_ID` int(11) unsigned NOT NULL default '0',
  `bloguser_user_ID` int(11) unsigned NOT NULL default '0',
  `bloguser_ismember` tinyint(4) NOT NULL default '0',
  `bloguser_perm_poststatuses` set('published','deprecated','protected','private','draft','redirected') collate utf8_unicode_ci NOT NULL,
  `bloguser_perm_edit` enum('no','own','lt','le','all','redirected') collate utf8_unicode_ci NOT NULL default 'no',
  `bloguser_perm_delpost` tinyint(4) NOT NULL default '0',
  `bloguser_perm_comments` tinyint(4) NOT NULL default '0',
  `bloguser_perm_cats` tinyint(4) NOT NULL default '0',
  `bloguser_perm_properties` tinyint(4) NOT NULL default '0',
  `bloguser_perm_admin` tinyint(4) NOT NULL default '0',
  `bloguser_perm_media_upload` tinyint(4) NOT NULL default '0',
  `bloguser_perm_media_browse` tinyint(4) NOT NULL default '0',
  `bloguser_perm_media_change` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`bloguser_blog_ID`,`bloguser_user_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_blogusers`
--


--
-- Table structure for table `evo_categories`
--

CREATE TABLE `evo_categories` (
  `cat_ID` int(10) unsigned NOT NULL auto_increment,
  `cat_parent_ID` int(10) unsigned default NULL,
  `cat_name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `cat_urlname` varchar(255) collate utf8_unicode_ci NOT NULL,
  `cat_blog_ID` int(10) unsigned NOT NULL default '2',
  `cat_description` varchar(255) collate utf8_unicode_ci default NULL,
  `cat_order` int(11) default NULL,
  PRIMARY KEY  (`cat_ID`),
  UNIQUE KEY `cat_urlname` (`cat_urlname`),
  KEY `cat_blog_ID` (`cat_blog_ID`),
  KEY `cat_parent_ID` (`cat_parent_ID`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_categories`
--

INSERT INTO `evo_categories` VALUES (1,NULL,'Welcome','welcome',1,NULL,NULL),(2,NULL,'News','news',1,NULL,NULL),(3,NULL,'Background','background',1,NULL,NULL),(4,NULL,'Russian Language','russian-language',1,'',NULL),(5,4,'Vocabulary','vocabulary',1,'',NULL),(6,4,'On the web','on-the-web',1,NULL,NULL),(7,5,'Tongue twisters','tongue-twisters',1,'',NULL),(8,5,'Grammar','grammar',1,'',NULL),(9,5,'Phrases','phrases',1,'',NULL),(10,NULL,'Announcements','announcements',2,NULL,NULL),(11,NULL,'b2evolution Tips','b2evolution-tips',2,NULL,NULL),(12,NULL,'b2evolution','b2evolution',3,NULL,NULL),(13,NULL,'contributors','contributors',3,NULL,NULL),(14,NULL,'Monument Valley','monument-valley',4,NULL,NULL);

--
-- Table structure for table `evo_coll_settings`
--

CREATE TABLE `evo_coll_settings` (
  `cset_coll_ID` int(11) unsigned NOT NULL,
  `cset_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `cset_value` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`cset_coll_ID`,`cset_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_coll_settings`
--

INSERT INTO `evo_coll_settings` VALUES (4,'archive_mode','postbypost'),(4,'posts_per_page','1'),(1,'tag_rel_attib','0'),(1,'chapter_posts_per_page',''),(1,'tag_posts_per_page',''),(1,'what_to_show','posts'),(1,'posts_per_page','5'),(1,'archive_mode','monthly'),(1,'orderby','datestart'),(1,'orderdir','DESC'),(1,'feed_content','normal'),(1,'posts_per_feed','8'),(1,'require_title','required'),(1,'allow_subscriptions','1'),(1,'use_workflow','0'),(1,'new_feedback_status','draft'),(1,'allow_rating','never'),(1,'custom_double1',''),(1,'custom_double2',''),(1,'custom_double3',''),(1,'custom_double4',''),(1,'custom_double5',''),(1,'custom_varchar1',''),(1,'custom_varchar2',''),(1,'custom_varchar3',''),(2,'tag_rel_attib','0'),(2,'chapter_posts_per_page',''),(2,'tag_posts_per_page',''),(3,'tag_rel_attib','0'),(3,'chapter_posts_per_page',''),(3,'tag_posts_per_page',''),(4,'tag_rel_attib','0'),(4,'chapter_posts_per_page',''),(4,'tag_posts_per_page',''),(2,'what_to_show','posts'),(2,'posts_per_page','5'),(2,'archive_mode','monthly'),(2,'orderby','datestart'),(2,'orderdir','DESC'),(1,'archive_links','extrapath'),(1,'archive_posts_per_page',''),(1,'chapter_links','chapters'),(1,'category_prefix',''),(1,'tag_links','colon'),(1,'tag_prefix',''),(1,'single_links','ymd');

--
-- Table structure for table `evo_comments`
--

CREATE TABLE `evo_comments` (
  `comment_ID` int(11) unsigned NOT NULL auto_increment,
  `comment_post_ID` int(11) unsigned NOT NULL default '0',
  `comment_type` enum('comment','linkback','trackback','pingback') collate utf8_unicode_ci NOT NULL default 'comment',
  `comment_status` enum('published','deprecated','protected','private','draft','redirected') collate utf8_unicode_ci NOT NULL default 'published',
  `comment_author_ID` int(10) unsigned default NULL,
  `comment_author` varchar(100) collate utf8_unicode_ci default NULL,
  `comment_author_email` varchar(255) collate utf8_unicode_ci default NULL,
  `comment_author_url` varchar(255) collate utf8_unicode_ci default NULL,
  `comment_author_IP` varchar(23) collate utf8_unicode_ci NOT NULL,
  `comment_date` datetime NOT NULL default '2000-01-01 00:00:00',
  `comment_content` text collate utf8_unicode_ci NOT NULL,
  `comment_rating` tinyint(1) default NULL,
  `comment_featured` tinyint(1) NOT NULL default '0',
  `comment_nofollow` tinyint(1) NOT NULL default '1',
  `comment_karma` int(11) NOT NULL default '0',
  `comment_spam_karma` tinyint(4) default NULL,
  `comment_allow_msgform` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_date` (`comment_date`),
  KEY `comment_type` (`comment_type`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_comments`
--


--
-- Table structure for table `evo_cron__log`
--

CREATE TABLE `evo_cron__log` (
  `clog_ctsk_ID` int(10) unsigned NOT NULL,
  `clog_realstart_datetime` datetime NOT NULL default '2000-01-01 00:00:00',
  `clog_realstop_datetime` datetime default NULL,
  `clog_status` enum('started','finished','error','timeout') collate utf8_unicode_ci NOT NULL default 'started',
  `clog_messages` text collate utf8_unicode_ci,
  PRIMARY KEY  (`clog_ctsk_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_cron__log`
--


--
-- Table structure for table `evo_cron__task`
--

CREATE TABLE `evo_cron__task` (
  `ctsk_ID` int(10) unsigned NOT NULL auto_increment,
  `ctsk_start_datetime` datetime NOT NULL default '2000-01-01 00:00:00',
  `ctsk_repeat_after` int(10) unsigned default NULL,
  `ctsk_name` varchar(50) collate utf8_unicode_ci NOT NULL,
  `ctsk_controller` varchar(50) collate utf8_unicode_ci NOT NULL,
  `ctsk_params` text collate utf8_unicode_ci,
  PRIMARY KEY  (`ctsk_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_cron__task`
--


--
-- Table structure for table `evo_files`
--

CREATE TABLE `evo_files` (
  `file_ID` int(11) unsigned NOT NULL auto_increment,
  `file_root_type` enum('absolute','user','collection','shared','skins') collate utf8_unicode_ci NOT NULL default 'absolute',
  `file_root_ID` int(11) unsigned NOT NULL default '0',
  `file_path` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `file_title` varchar(255) collate utf8_unicode_ci default NULL,
  `file_alt` varchar(255) collate utf8_unicode_ci default NULL,
  `file_desc` text collate utf8_unicode_ci,
  PRIMARY KEY  (`file_ID`),
  UNIQUE KEY `file` (`file_root_type`,`file_root_ID`,`file_path`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_files`
--

INSERT INTO `evo_files` VALUES (1,'user',1,'faceyourmanga_admin_boy.png',NULL,NULL,NULL),(2,'shared',0,'monument-valley/bus-stop-ahead.jpg',NULL,NULL,NULL),(3,'shared',0,'monument-valley/john-ford-point.jpg',NULL,NULL,NULL),(4,'shared',0,'monument-valley/monuments.jpg',NULL,NULL,NULL),(5,'shared',0,'monument-valley/monument-valley-road.jpg',NULL,NULL,NULL),(6,'shared',0,'monument-valley/monument-valley.jpg',NULL,NULL,NULL),(7,'shared',0,'logos/b2evolution8.png',NULL,NULL,NULL),(9,'skins',0,'style.css',NULL,NULL,NULL),(10,'collection',3,'/Mariinsky_Theatre.jpg',NULL,NULL,NULL),(11,'collection',3,'Mariinsky_Theatre.jpg',NULL,NULL,NULL);

--
-- Table structure for table `evo_filetypes`
--

CREATE TABLE `evo_filetypes` (
  `ftyp_ID` int(11) unsigned NOT NULL auto_increment,
  `ftyp_extensions` varchar(30) collate utf8_unicode_ci NOT NULL,
  `ftyp_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `ftyp_mimetype` varchar(50) collate utf8_unicode_ci NOT NULL,
  `ftyp_icon` varchar(20) collate utf8_unicode_ci default NULL,
  `ftyp_viewtype` varchar(10) collate utf8_unicode_ci NOT NULL,
  `ftyp_allowed` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ftyp_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_filetypes`
--

INSERT INTO `evo_filetypes` VALUES (1,'gif','GIF image','image/gif','image2.png','image',1),(2,'png','PNG image','image/png','image2.png','image',1),(3,'jpg jpeg','JPEG image','image/jpeg','image2.png','image',1),(4,'txt','Text file','text/plain','document.png','text',1),(5,'htm html','HTML file','text/html','html.png','browser',0),(6,'pdf','PDF file','application/pdf','pdf.png','browser',1),(7,'doc','Microsoft Word file','application/msword','doc.gif','external',1),(8,'xls','Microsoft Excel file','application/vnd.ms-excel','xls.gif','external',1),(9,'ppt','Powerpoint','application/vnd.ms-powerpoint','ppt.gif','external',1),(10,'pps','Slideshow','pps','pps.gif','external',1),(11,'zip','ZIP archive','application/zip','zip.gif','external',1),(12,'php php3 php4 php5 php6','PHP script','application/x-httpd-php','php.gif','text',0),(13,'css','Style sheet','text/css','','text',1),(14,'mp3','MPEG audio file','audio/mpeg','','browser',1),(15,'m4a','MPEG audio file','audio/x-m4a','','browser',1),(16,'mp4','MPEG video','video/mp4','','browser',1),(17,'mov','Quicktime video','video/quicktime','','browser',1);

--
-- Table structure for table `evo_global__cache`
--

CREATE TABLE `evo_global__cache` (
  `cach_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `cach_cache` mediumblob,
  PRIMARY KEY  (`cach_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_global__cache`
--

INSERT INTO `evo_global__cache` VALUES ('version_status_msg','s:50:\"You are running the latest version of b2evolution.\";'),('extra_msg','s:58:\"b2evolution version 4.0.0-alpha is just around the corner!\";'),('version_status_color','s:5:\"green\";'),('evo_links','a:1:{s:0:\"\";a:1:{i:0;a:3:{i:0;i:100;i:1;s:23:\"http://b2evolution.net/\";i:2;a:27:{i:0;a:2:{i:0;i:28;i:1;s:22:\"powered by b2evolution\";}i:1;a:2:{i:0;i:55;i:1;s:41:\"powered by b2evolution free blog software\";}i:2;a:2:{i:0;i:57;i:1;s:29:\"powered by free blog software\";}i:3;a:2:{i:0;i:59;i:1;s:2:\"b2\";}i:4;a:2:{i:0;i:60;i:1;s:9:\"free blog\";}i:5;a:2:{i:0;i:63;i:1;s:14:\"free blog tool\";}i:6;a:2:{i:0;i:66;i:1;s:18:\"free blog software\";}i:7;a:2:{i:0;i:67;i:1;s:21:\"free open source blog\";}i:8;a:2:{i:0;i:68;i:1;s:16:\"open source blog\";}i:9;a:2:{i:0;i:69;i:1;s:21:\"open source blog tool\";}i:10;a:2:{i:0;i:70;i:1;s:25:\"open source blog software\";}i:11;a:2:{i:0;i:72;i:1;s:9:\"multiblog\";}i:12;a:2:{i:0;i:73;i:1;s:16:\"multiblog engine\";}i:13;a:2:{i:0;i:74;i:1;s:18:\"multiblog platform\";}i:14;a:2:{i:0;i:75;i:1;s:10:\"multi-blog\";}i:15;a:2:{i:0;i:76;i:1;s:17:\"multi-blog engine\";}i:16;a:2:{i:0;i:77;i:1;s:19:\"multi-blog platform\";}i:17;a:2:{i:0;i:79;i:1;s:14:\"multiple blogs\";}i:18;a:2:{i:0;i:81;i:1;s:11:\"blog engine\";}i:19;a:2:{i:0;i:83;i:1;s:8:\"blogtool\";}i:20;a:2:{i:0;i:85;i:1;s:9:\"blog tool\";}i:21;a:2:{i:0;i:87;i:1;s:13:\"blogging tool\";}i:22;a:2:{i:0;i:88;i:1;s:13:\"blogging soft\";}i:23;a:2:{i:0;i:91;i:1;s:17:\"blogging software\";}i:24;a:2:{i:0;i:92;i:1;s:8:\"blogsoft\";}i:25;a:2:{i:0;i:94;i:1;s:9:\"blog soft\";}i:26;a:2:{i:0;i:100;i:1;s:13:\"blog software\";}}}}}'),('feedhlp','a:1:{i:0;a:1:{s:0:\"\";a:1:{i:0;a:3:{i:0;i:100;i:1;s:46:\"http://webreference.fr/2006/08/30/rss_atom_xml\";i:2;a:2:{i:0;a:2:{i:0;i:16;i:1;s:11:\"More on RSS\";}i:1;a:2:{i:0;i:100;i:1;s:12:\"What is RSS?\";}}}}}}'),('creds','a:3:{i:0;a:1:{s:0:\"\";a:2:{i:0;a:3:{i:0;i:6;i:1;s:19:\"http://evocore.net/\";i:2;a:3:{i:0;a:2:{i:0;i:3;i:1;s:13:\"PHP framework\";}i:1;a:2:{i:0;i:5;i:1;s:9:\"framework\";}i:2;a:2:{i:0;i:6;i:1;s:7:\"evoCore\";}}}i:1;a:3:{i:0;i:100;i:1;s:23:\"http://b2evolution.net/\";i:2;a:17:{i:0;a:2:{i:0;i:8;i:1;s:9:\"free blog\";}i:1;a:2:{i:0;i:10;i:1;s:14:\"free blog tool\";}i:2;a:2:{i:0;i:14;i:1;s:16:\"open source blog\";}i:3;a:2:{i:0;i:17;i:1;s:9:\"multiblog\";}i:4;a:2:{i:0;i:19;i:1;s:10:\"multi-blog\";}i:5;a:2:{i:0;i:25;i:1;s:13:\"blogging tool\";}i:6;a:2:{i:0;i:42;i:1;s:13:\"blog software\";}i:7;a:2:{i:0;i:45;i:1;s:8:\"blogsoft\";}i:8;a:2:{i:0;i:47;i:1;s:2:\"b2\";}i:9;a:2:{i:0;i:64;i:1;s:13:\"blog software\";}i:10;a:2:{i:0;i:72;i:1;s:14:\"multiple blogs\";}i:11;a:2:{i:0;i:74;i:1;s:18:\"free blog software\";}i:12;a:2:{i:0;i:78;i:1;s:17:\"blogging software\";}i:13;a:2:{i:0;i:84;i:1;s:11:\"blog engine\";}i:14;a:2:{i:0;i:88;i:1;s:9:\"blog soft\";}i:15;a:2:{i:0;i:97;i:1;s:9:\"blog tool\";}i:16;a:2:{i:0;i:100;i:1;s:8:\"blogtool\";}}}}}i:1;a:4:{s:5:\"en-UK\";a:2:{i:0;s:89:\"http://b2evolution.net/web-hosting/europe/uk-recommended-hosts-php-mysql-best-choices.php\";i:1;a:13:{i:0;a:2:{i:0;i:5;i:1;s:7:\"UK host\";}i:1;a:2:{i:0;i:10;i:1;s:14:\"web hosting UK\";}i:2;a:2:{i:0;i:14;i:1;s:11:\"web host UK\";}i:3;a:2:{i:0;i:19;i:1;s:13:\"webhosting UK\";}i:4;a:2:{i:0;i:30;i:1;s:10:\"UK hosting\";}i:5;a:2:{i:0;i:33;i:1;s:7:\"host uk\";}i:6;a:2:{i:0;i:62;i:1;s:8:\"UK hosts\";}i:7;a:2:{i:0;i:64;i:1;s:7:\"hosting\";}i:8;a:2:{i:0;i:66;i:1;s:11:\"web hosting\";}i:9;a:2:{i:0;i:72;i:1;s:10:\"hosting UK\";}i:10;a:2:{i:0;i:82;i:1;s:8:\"hosts UK\";}i:11;a:2:{i:0;i:98;i:1;s:14:\"UK web hosting\";}i:12;a:2:{i:0;i:100;i:1;s:10:\"UK webhost\";}}}s:5:\"en-GB\";a:2:{i:0;a:3:{i:0;i:6;i:1;s:74:\"http://b2evolution.net/web-hosting/vps-hosting-virtual-private-servers.php\";i:2;a:4:{i:0;a:2:{i:0;i:2;i:1;s:3:\"vps\";}i:1;a:2:{i:0;i:3;i:1;s:3:\"VPS\";}i:2;a:2:{i:0;i:4;i:1;s:11:\"VPS hosting\";}i:3;a:2:{i:0;i:5;i:1;s:11:\"vps hosting\";}}}i:1;a:3:{i:0;i:100;i:1;s:89:\"http://b2evolution.net/web-hosting/europe/uk-recommended-hosts-php-mysql-best-choices.php\";i:2;a:13:{i:0;a:2:{i:0;i:10;i:1;s:14:\"web hosting UK\";}i:1;a:2:{i:0;i:14;i:1;s:11:\"web host UK\";}i:2;a:2:{i:0;i:19;i:1;s:13:\"webhosting UK\";}i:3;a:2:{i:0;i:30;i:1;s:10:\"UK hosting\";}i:4;a:2:{i:0;i:33;i:1;s:7:\"host uk\";}i:5;a:2:{i:0;i:44;i:1;s:7:\"UK host\";}i:6;a:2:{i:0;i:62;i:1;s:8:\"UK hosts\";}i:7;a:2:{i:0;i:64;i:1;s:7:\"hosting\";}i:8;a:2:{i:0;i:66;i:1;s:11:\"web hosting\";}i:9;a:2:{i:0;i:72;i:1;s:10:\"hosting UK\";}i:10;a:2:{i:0;i:82;i:1;s:8:\"hosts UK\";}i:11;a:2:{i:0;i:98;i:1;s:14:\"UK web hosting\";}i:12;a:2:{i:0;i:100;i:1;s:10:\"UK webhost\";}}}}s:2:\"fr\";a:4:{i:0;a:3:{i:0;i:78;i:1;s:71:\"http://b2evolution.net/web-hosting/europe/hebergement-web-france-fr.php\";i:2;a:8:{i:0;a:2:{i:0;i:14;i:1;s:18:\"h&eacute;bergement\";}i:1;a:2:{i:0;i:19;i:1;s:22:\"h&eacute;bergement web\";}i:2;a:2:{i:0;i:30;i:1;s:17:\"h&eacute;bergeurs\";}i:3;a:2:{i:0;i:41;i:1;s:16:\"h&eacute;bergeur\";}i:4;a:2:{i:0;i:45;i:1;s:20:\"h&eacute;bergeur web\";}i:5;a:2:{i:0;i:60;i:1;s:9:\"hebergeur\";}i:6;a:2:{i:0;i:72;i:1;s:11:\"hebergement\";}i:7;a:2:{i:0;i:78;i:1;s:11:\"serveur web\";}}}i:1;a:3:{i:0;i:91;i:1;s:71:\"http://b2evolution.net/web-hosting/budget-web-hosting-low-cost-lamp.php\";i:2;a:6:{i:0;a:2:{i:0;i:82;i:1;s:13:\"cheap hosting\";}i:1;a:2:{i:0;i:84;i:1;s:14:\"budget hosting\";}i:2;a:2:{i:0;i:86;i:1;s:13:\"value hosting\";}i:3;a:2:{i:0;i:88;i:1;s:18:\"affordable hosting\";}i:4;a:2:{i:0;i:89;i:1;s:15:\"popular hosting\";}i:5;a:2:{i:0;i:91;i:1;s:16:\"low cost hosting\";}}}i:2;a:3:{i:0;i:97;i:1;s:68:\"http://b2evolution.net/about/linux-dedicated-servers-web-hosting.php\";i:2;a:3:{i:0;a:2:{i:0;i:94;i:1;s:17:\"dedicated servers\";}i:1;a:2:{i:0;i:95;i:1;s:16:\"dedicated server\";}i:2;a:2:{i:0;i:97;i:1;s:17:\"dedicated hosting\";}}}i:3;a:3:{i:0;i:100;i:1;s:70:\"http://b2evolution.net/web-hosting/ssh-hosting-secure-shell-access.php\";i:2;a:3:{i:0;a:2:{i:0;i:98;i:1;s:15:\"SSH web hosting\";}i:1;a:2:{i:0;i:99;i:1;s:12:\"secure shell\";}i:2;a:2:{i:0;i:100;i:1;s:11:\"SSH hosting\";}}}}s:0:\"\";a:9:{i:0;a:3:{i:0;i:6;i:1;s:74:\"http://b2evolution.net/web-hosting/vps-hosting-virtual-private-servers.php\";i:2;a:4:{i:0;a:2:{i:0;i:2;i:1;s:3:\"vps\";}i:1;a:2:{i:0;i:3;i:1;s:3:\"VPS\";}i:2;a:2:{i:0;i:4;i:1;s:11:\"VPS hosting\";}i:3;a:2:{i:0;i:6;i:1;s:11:\"vps hosting\";}}}i:1;a:3:{i:0;i:10;i:1;s:75:\"http://b2evolution.net/web-hosting/green-hosting-renewable-energy-power.php\";i:2;a:2:{i:0;a:2:{i:0;i:8;i:1;s:13:\"green hosting\";}i:1;a:2:{i:0;i:10;i:1;s:17:\"green web hosting\";}}}i:2;a:3:{i:0;i:12;i:1;s:74:\"http://b2evolution.net/web-hosting/best-reseller-hosting-top-providers.php\";i:2;a:1:{i:0;a:2:{i:0;i:12;i:1;s:16:\"reseller hosting\";}}}i:3;a:3:{i:0;i:13;i:1;s:67:\"http://b2evolution.net/web-hosting/blog/news/web-hosting-test-sites\";i:2;a:1:{i:0;a:2:{i:0;i:13;i:1;s:17:\"web hosting sites\";}}}i:4;a:3:{i:0;i:18;i:1;s:71:\"http://b2evolution.net/web-hosting/top-recommended-webhosting-plans.php\";i:2;a:4:{i:0;a:2:{i:0;i:14;i:1;s:10:\"webhosting\";}i:1;a:2:{i:0;i:16;i:1;s:19:\"b2evolution hosting\";}i:2;a:2:{i:0;i:17;i:1;s:17:\"hosting companies\";}i:3;a:2:{i:0;i:18;i:1;s:19:\"recommended hosting\";}}}i:5;a:3:{i:0;i:73;i:1;s:66:\"http://b2evolution.net/web-hosting/top-quality-best-webhosting.php\";i:2;a:24:{i:0;a:2:{i:0;i:19;i:1;s:19:\"web hosting reviews\";}i:1;a:2:{i:0;i:20;i:1;s:18:\"webhosting reviews\";}i:2;a:2:{i:0;i:21;i:1;s:15:\"hosting reviews\";}i:3;a:2:{i:0;i:22;i:1;s:13:\"b2evo hosting\";}i:4;a:2:{i:0;i:27;i:1;s:12:\"blog hosting\";}i:5;a:2:{i:0;i:28;i:1;s:18:\"web hosting top 10\";}i:6;a:2:{i:0;i:29;i:1;s:14:\"top 10 hosting\";}i:7;a:2:{i:0;i:30;i:1;s:11:\"top hosting\";}i:8;a:2:{i:0;i:32;i:1;s:7:\"hosting\";}i:9;a:2:{i:0;i:34;i:1;s:5:\"hosts\";}i:10;a:2:{i:0;i:35;i:1;s:9:\"top hosts\";}i:11;a:2:{i:0;i:36;i:1;s:8:\"web host\";}i:12;a:2:{i:0;i:37;i:1;s:10:\"best hosts\";}i:13;a:2:{i:0;i:39;i:1;s:12:\"best hosting\";}i:14;a:2:{i:0;i:42;i:1;s:11:\"PHP hosting\";}i:15;a:2:{i:0;i:43;i:1;s:13:\"MySQL hosting\";}i:16;a:2:{i:0;i:44;i:1;s:8:\"webhosts\";}i:17;a:2:{i:0;i:45;i:1;s:12:\"LAMP hosting\";}i:18;a:2:{i:0;i:62;i:1;s:11:\"web hosting\";}i:19;a:2:{i:0;i:64;i:1;s:7:\"webhost\";}i:20;a:2:{i:0;i:66;i:1;s:10:\"webhosting\";}i:21;a:2:{i:0;i:70;i:1;s:9:\"web hosts\";}i:22;a:2:{i:0;i:72;i:1;s:10:\"webhosting\";}i:23;a:2:{i:0;i:73;i:1;s:7:\"hosting\";}}}i:6;a:3:{i:0;i:91;i:1;s:71:\"http://b2evolution.net/web-hosting/budget-web-hosting-low-cost-lamp.php\";i:2;a:11:{i:0;a:2:{i:0;i:74;i:1;s:19:\"low cost webhosting\";}i:1;a:2:{i:0;i:76;i:1;s:20:\"low cost web hosting\";}i:2;a:2:{i:0;i:78;i:1;s:7:\"hosting\";}i:3;a:2:{i:0;i:79;i:1;s:22:\"best cheap web hosting\";}i:4;a:2:{i:0;i:84;i:1;s:13:\"cheap hosting\";}i:5;a:2:{i:0;i:84;i:1;s:14:\"budget hosting\";}i:6;a:2:{i:0;i:87;i:1;s:17:\"cheap web hosting\";}i:7;a:2:{i:0;i:88;i:1;s:16:\"cheap webhosting\";}i:8;a:2:{i:0;i:89;i:1;s:18:\"affordable hosting\";}i:9;a:2:{i:0;i:90;i:1;s:16:\"low cost hosting\";}i:10;a:2:{i:0;i:91;i:1;s:15:\"cheaper hosting\";}}}i:7;a:3:{i:0;i:98;i:1;s:68:\"http://b2evolution.net/about/linux-dedicated-servers-web-hosting.php\";i:2;a:4:{i:0;a:2:{i:0;i:93;i:1;s:17:\"dedicated servers\";}i:1;a:2:{i:0;i:95;i:1;s:16:\"dedicated server\";}i:2;a:2:{i:0;i:96;i:1;s:14:\"managed server\";}i:3;a:2:{i:0;i:98;i:1;s:17:\"dedicated hosting\";}}}i:8;a:3:{i:0;i:100;i:1;s:70:\"http://b2evolution.net/web-hosting/ssh-hosting-secure-shell-access.php\";i:2;a:2:{i:0;a:2:{i:0;i:99;i:1;s:15:\"SSH web hosting\";}i:1;a:2:{i:0;i:100;i:1;s:11:\"SSH hosting\";}}}}}i:2;a:2:{s:2:\"fr\";a:3:{i:0;a:3:{i:0;i:36;i:1;s:20:\"http://fplanque.net/\";i:2;a:6:{i:0;a:2:{i:0;i:3;i:1;s:2:\"FP\";}i:1;a:2:{i:0;i:9;i:1;s:8:\"Francois\";}i:2;a:2:{i:0;i:17;i:1;s:2:\"fp\";}i:3;a:2:{i:0;i:19;i:1;s:3:\"F P\";}i:4;a:2:{i:0;i:28;i:1;s:8:\"Francois\";}i:5;a:2:{i:0;i:36;i:1;s:15:\"Fran&ccedil;ois\";}}}i:1;a:3:{i:0;i:90;i:1;s:52:\"http://b2evolution.net/about/monetize-blog-money.php\";i:2;a:5:{i:0;a:2:{i:0;i:41;i:1;s:8:\"pub blog\";}i:1;a:2:{i:0;i:45;i:1;s:3:\"pub\";}i:2;a:2:{i:0;i:72;i:1;s:7:\"adsense\";}i:3;a:2:{i:0;i:78;i:1;s:3:\"pub\";}i:4;a:2:{i:0;i:90;i:1;s:8:\"blog pub\";}}}i:2;a:3:{i:0;i:100;i:1;s:39:\"http://b2evolution.net/dev/authors.html\";i:2;a:3:{i:0;a:2:{i:0;i:94;i:1;s:7:\"authors\";}i:1;a:2:{i:0;i:98;i:1;s:7:\"evoTeam\";}i:2;a:2:{i:0;i:100;i:1;s:4:\"team\";}}}}s:0:\"\";a:4:{i:0;a:3:{i:0;i:27;i:1;s:20:\"http://fplanque.com/\";i:2;a:7:{i:0;a:2:{i:0;i:7;i:1;s:15:\"Fran&ccedil;ois\";}i:1;a:2:{i:0;i:11;i:1;s:2:\"FP\";}i:2;a:2:{i:0;i:13;i:1;s:0:\"\";}i:3;a:2:{i:0;i:15;i:1;s:4:\"F.P.\";}i:4;a:2:{i:0;i:20;i:1;s:0:\"\";}i:5;a:2:{i:0;i:22;i:1;s:2:\"fp\";}i:6;a:2:{i:0;i:27;i:1;s:8:\"Francois\";}}}i:1;a:2:{i:0;i:33;i:1;s:0:\"\";}i:2;a:3:{i:0;i:90;i:1;s:52:\"http://b2evolution.net/about/monetize-blog-money.php\";i:2;a:8:{i:0;a:2:{i:0;i:35;i:1;s:0:\"\";}i:1;a:2:{i:0;i:39;i:1;s:11:\"advertising\";}i:2;a:2:{i:0;i:45;i:1;s:8:\"blog ads\";}i:3;a:2:{i:0;i:52;i:1;s:10:\"monetizing\";}i:4;a:2:{i:0;i:62;i:1;s:8:\"monetize\";}i:5;a:2:{i:0;i:64;i:1;s:13:\"monetize blog\";}i:6;a:2:{i:0;i:79;i:1;s:0:\"\";}i:7;a:2:{i:0;i:90;i:1;s:7:\"adsense\";}}}i:3;a:3:{i:0;i:100;i:1;s:39:\"http://b2evolution.net/dev/authors.html\";i:2;a:3:{i:0;a:2:{i:0;i:94;i:1;s:7:\"authors\";}i:1;a:2:{i:0;i:98;i:1;s:7:\"evoTeam\";}i:2;a:2:{i:0;i:100;i:1;s:4:\"team\";}}}}}}'),('updates','a:1:{i:0;a:4:{s:4:\"name\";s:38:\"b2evolution v 4.0.0-alpha TEST RELEASE\";s:11:\"description\";s:134:\"Warning this release is for testing the upgrade system only! It will OVERWRITE your current version with something potentially OLDER!!\";s:7:\"version\";s:22:\"4.0.0-alpha 2010-07-27\";s:3:\"url\";s:71:\"http://b2evolution.net/downloads/b2evolution-4.0.0-alpha-2010-07-27.zip\";}}');

--
-- Table structure for table `evo_groups`
--

CREATE TABLE `evo_groups` (
  `grp_ID` int(11) NOT NULL auto_increment,
  `grp_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `grp_perm_admin` enum('none','hidden','visible') collate utf8_unicode_ci NOT NULL default 'visible',
  `grp_perm_blogs` enum('user','viewall','editall') collate utf8_unicode_ci NOT NULL default 'user',
  `grp_perm_bypass_antispam` tinyint(1) NOT NULL default '0',
  `grp_perm_xhtmlvalidation` varchar(10) collate utf8_unicode_ci NOT NULL default 'always',
  `grp_perm_xhtmlvalidation_xmlrpc` varchar(10) collate utf8_unicode_ci NOT NULL default 'always',
  `grp_perm_xhtml_css_tweaks` tinyint(1) NOT NULL default '0',
  `grp_perm_xhtml_iframes` tinyint(1) NOT NULL default '0',
  `grp_perm_xhtml_javascript` tinyint(1) NOT NULL default '0',
  `grp_perm_xhtml_objects` tinyint(1) NOT NULL default '0',
  `grp_perm_stats` enum('none','user','view','edit') collate utf8_unicode_ci NOT NULL default 'none',
  `grp_perm_spamblacklist` enum('none','view','edit') collate utf8_unicode_ci NOT NULL default 'none',
  `grp_perm_options` enum('none','view','edit') collate utf8_unicode_ci NOT NULL default 'none',
  `grp_perm_users` enum('none','view','edit') collate utf8_unicode_ci NOT NULL default 'none',
  `grp_perm_templates` tinyint(4) NOT NULL default '0',
  `grp_perm_files` enum('none','view','add','edit','all') collate utf8_unicode_ci NOT NULL default 'none',
  PRIMARY KEY  (`grp_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_groups`
--

INSERT INTO `evo_groups` VALUES (1,'Administrators','visible','editall',0,'always','always',1,0,0,0,'edit','edit','edit','edit',1,'all'),(2,'Privileged Bloggers','visible','viewall',0,'always','always',1,0,0,0,'user','edit','view','view',0,'add'),(3,'Bloggers','visible','user',0,'always','always',1,0,0,0,'none','view','none','none',0,'view'),(4,'Basic Users','none','user',0,'always','always',0,0,0,0,'none','none','none','none',0,'none');

--
-- Table structure for table `evo_items__item`
--

CREATE TABLE `evo_items__item` (
  `post_ID` int(11) unsigned NOT NULL auto_increment,
  `post_parent_ID` int(11) unsigned default NULL,
  `post_creator_user_ID` int(11) unsigned NOT NULL,
  `post_lastedit_user_ID` int(11) unsigned default NULL,
  `post_assigned_user_ID` int(11) unsigned default NULL,
  `post_datestart` datetime NOT NULL default '2000-01-01 00:00:00',
  `post_datedeadline` datetime default NULL,
  `post_datecreated` datetime default NULL,
  `post_datemodified` datetime NOT NULL default '2000-01-01 00:00:00',
  `post_status` enum('published','deprecated','protected','private','draft','redirected') collate utf8_unicode_ci NOT NULL default 'published',
  `post_pst_ID` int(11) unsigned default NULL,
  `post_ptyp_ID` int(10) unsigned NOT NULL default '1',
  `post_locale` varchar(20) collate utf8_unicode_ci NOT NULL default 'en-EU',
  `post_content` mediumtext collate utf8_unicode_ci,
  `post_excerpt` text collate utf8_unicode_ci,
  `post_title` text collate utf8_unicode_ci NOT NULL,
  `post_urltitle` varchar(210) collate utf8_unicode_ci default NULL,
  `post_titletag` varchar(255) collate utf8_unicode_ci default NULL,
  `post_metadesc` varchar(255) collate utf8_unicode_ci default NULL,
  `post_metakeywords` varchar(255) collate utf8_unicode_ci default NULL,
  `post_url` varchar(255) collate utf8_unicode_ci default NULL,
  `post_main_cat_ID` int(11) unsigned NOT NULL,
  `post_notifications_status` enum('noreq','todo','started','finished') collate utf8_unicode_ci NOT NULL default 'noreq',
  `post_notifications_ctsk_ID` int(10) unsigned default NULL,
  `post_views` int(11) unsigned NOT NULL default '0',
  `post_wordcount` int(11) default NULL,
  `post_comment_status` enum('disabled','open','closed') collate utf8_unicode_ci NOT NULL default 'open',
  `post_commentsexpire` datetime default NULL,
  `post_renderers` text collate utf8_unicode_ci NOT NULL,
  `post_priority` int(11) unsigned default NULL COMMENT 'Task priority in workflow',
  `post_featured` tinyint(1) NOT NULL default '0',
  `post_order` double default NULL,
  `post_double1` double default NULL COMMENT 'Custom double value 1',
  `post_double2` double default NULL COMMENT 'Custom double value 2',
  `post_double3` double default NULL COMMENT 'Custom double value 3',
  `post_double4` double default NULL COMMENT 'Custom double value 4',
  `post_double5` double default NULL COMMENT 'Custom double value 5',
  `post_varchar1` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Custom varchar value 1',
  `post_varchar2` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Custom varchar value 2',
  `post_varchar3` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Custom varchar value 3',
  `post_editor_code` varchar(32) collate utf8_unicode_ci default NULL COMMENT 'Plugin code of the editor used to edit this post',
  PRIMARY KEY  (`post_ID`),
  UNIQUE KEY `post_urltitle` (`post_urltitle`),
  KEY `post_datestart` (`post_datestart`),
  KEY `post_main_cat_ID` (`post_main_cat_ID`),
  KEY `post_creator_user_ID` (`post_creator_user_ID`),
  KEY `post_status` (`post_status`),
  KEY `post_parent_ID` (`post_parent_ID`),
  KEY `post_assigned_user_ID` (`post_assigned_user_ID`),
  KEY `post_ptyp_ID` (`post_ptyp_ID`),
  KEY `post_pst_ID` (`post_pst_ID`),
  KEY `post_order` (`post_order`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_items__item`
--

INSERT INTO `evo_items__item` VALUES (2,NULL,1,1,NULL,'2010-09-30 11:16:05',NULL,'2010-01-25 22:50:23','2010-09-30 11:16:05','published',NULL,1,'ru-RU','<p>During the first year of Russian we teach that English word \"magazine\" and Russian word \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" are false cognates. The main definition of the word \"magazine\" is \"journal\" and Russian \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" means \"store\". But has this always been the case?</p>\r\n\r\n<p>In actuality, both words come from M.Fr. magasin \"warehouse, depot, store,\" from It. magazzino, from Arabic makhazin, pl. of makhzan \"storehouse,\" from khazana \"to store up.\" In 1580s English \"magazine\" meant a \"place for storing goods, especially military ammunition\". The word acquired its main nowaday meaning as \"periodical, journal\" in 1731 after the publication of the first one \"Gentleman\'s Magazine\", a \"storehouse\" of information.</p>','This is the second post. It appears in multiple categories.','Magazine vs. ìàãàçèí','second-post','','','','',2,'finished',NULL,8,101,'open',NULL,'b2evALnk.evo_videoplug',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'html'),(3,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:21:05','deprecated',NULL,1,'en-US','In the middle of nowhere: a school bus stop where you wouldn\'t really expect it!','In the middle of nowhere: a school bus stop where you wouldn\'t really expect it!','Bus Stop Ahead','bus-stop-ahead',NULL,NULL,NULL,'http://fplanque.com/photo/monument-valley',14,'noreq',NULL,0,15,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:21:08','deprecated',NULL,1,'en-US','Does this scene look familiar? You\'ve probably seen it in a couple of John Ford westerns!','Does this scene look familiar? You\'ve probably seen it in a couple of John Ford westerns!','John Ford Point','john-ford-point',NULL,NULL,NULL,'http://fplanque.com/photo/monument-valley',14,'noreq',NULL,0,16,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:21:16','deprecated',NULL,1,'en-US','This is one of the most famous views in Monument Valley. I like to frame it with the dirt road in order to give a better idea of the size of those things!','This is one of the most famous views in Monument Valley. I like to frame it with the dirt road in order to give a better idea of the size of those things!','Monuments','monuments',NULL,NULL,NULL,'http://fplanque.com/photo/monument-valley',14,'noreq',NULL,0,33,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:21:10','deprecated',NULL,1,'en-US','This gives a pretty good idea of the Monuments you\'re about to drive into...','This gives a pretty good idea of the Monuments you\'re about to drive into...','Road to Monument Valley','road-to-monument-valley',NULL,NULL,NULL,'http://fplanque.com/photo/monument-valley',14,'noreq',NULL,0,14,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:21:14','deprecated',NULL,1,'en-US','This is a short photo album demo. Use the arrows to navigate between photos. Click on \"Index\" to see a thumbnail index.','This is a short photo album demo. Use the arrows to navigate between photos. Click on \"Index\" to see a thumbnail index.','Monument Valley','monument-valley',NULL,NULL,NULL,'http://fplanque.com/photo/monument-valley',14,'noreq',NULL,0,22,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:20:23','deprecated',NULL,1,'en-US','',NULL,'Danny','danny',NULL,NULL,NULL,'http://personman.com/',13,'noreq',NULL,0,0,'disabled',NULL,'',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:20:26','deprecated',NULL,1,'de-DE','',NULL,'Daniel','daniel',NULL,NULL,NULL,'http://daniel.hahler.de/',13,'noreq',NULL,0,0,'disabled',NULL,'',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:20:28','deprecated',NULL,1,'fr-FR','',NULL,'Francois','francois',NULL,NULL,NULL,'http://fplanque.com/',13,'noreq',NULL,0,0,'disabled',NULL,'',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:20:42','deprecated',NULL,1,'en-US','',NULL,'Blog news','blog-news',NULL,NULL,NULL,'http://b2evolution.net/news.php',12,'noreq',NULL,0,0,'disabled',NULL,'',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:20:39','deprecated',NULL,1,'en-US','',NULL,'Web hosting','web-hosting',NULL,NULL,NULL,'http://b2evolution.net/web-hosting/blog/',12,'noreq',NULL,0,0,'disabled',NULL,'',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:20:36','deprecated',NULL,1,'en-US','',NULL,'Manual','manual',NULL,NULL,NULL,'http://manual.b2evolution.net/',12,'noreq',NULL,0,0,'disabled',NULL,'',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:20:34','deprecated',NULL,1,'en-US','',NULL,'Support','support',NULL,NULL,NULL,'http://forums.b2evolution.net/',12,'noreq',NULL,0,0,'disabled',NULL,'',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:19:31','deprecated',NULL,1000,'en-US','<p>This blog is powered by b2evolution.</p>\n\n<p>You are currently looking at an info page about Blog B.</p>\n\n<p>Info pages are very much like regular posts, except that they do not appear in the regular flow of posts. They appear as info pages in the sidebar instead.</p>\n\n<p>If needed, an evoskin can format info pages differently from regular posts.</p>','This blog is powered by b2evolution.\n\n You are currently looking at an info page about Blog B.\n\n Info pages are very much like regular posts, except that they do not appear in the regular flow of posts. They appear as info pages in the sidebar instead.&hellip;','About Blog B','about-blog-b',NULL,NULL,NULL,'',10,'noreq',NULL,0,58,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:13:54','deprecated',NULL,1000,'en-US','<p>This blog is powered by b2evolution.</p>\n\n<p>You are currently looking at an info page about Blog A.</p>\n\n<p>Info pages are very much like regular posts, except that they do not appear in the regular flow of posts. They appear as info pages in the sidebar instead.</p>\n\n<p>If needed, an evoskin can format info pages differently from regular posts.</p>','This blog is powered by b2evolution.\n\n You are currently looking at an info page about Blog A.\n\n Info pages are very much like regular posts, except that they do not appear in the regular flow of posts. They appear as info pages in the sidebar instead.&hellip;','About Blog A','about-blog-a',NULL,NULL,NULL,'',1,'noreq',NULL,1,58,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:13:40','deprecated',NULL,1000,'en-US','<p>This blog platform is powered by b2evolution.</p>\n\n<p>You are currently looking at an info page about this system. It is cross-posted among the demo blogs. Thus, this page will be linked on each of these blogs.</p>\n\n<p>Info pages are very much like regular posts, except that they do not appear in the regular flow of posts. They appear as info pages in the sidebar instead.</p>\n\n<p>If needed, an evoskin can format info pages differently from regular posts.</p>','This blog platform is powered by b2evolution.\n\n You are currently looking at an info page about this system. It is cross-posted among the demo blogs. Thus, this page will be linked on each of these blogs.\n\n Info pages are very much like regular posts, ex&hellip;','About this system','about-this-system',NULL,NULL,NULL,'',1,'noreq',NULL,1,77,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,NULL,1,1,NULL,'2008-09-28 18:06:09',NULL,'2010-01-25 22:50:23','2010-01-26 12:13:28','deprecated',NULL,1500,'en-US','This is the main intro post. It appears on the homepage only.','This is the main intro post. It appears on the homepage only.','Main Intro post','main-intro-post',NULL,NULL,NULL,'',11,'noreq',NULL,0,12,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,NULL,1,1,NULL,'2008-09-28 18:06:10',NULL,'2010-01-25 22:50:23','2010-01-26 12:13:26','deprecated',NULL,1520,'en-US','This uses post type \"Intro-Cat\" and is attached to the desired Category(ies).','This uses post type \"Intro-Cat\" and is attached to the desired Category(ies).','b2evolution tips category &ndash; Sub Intro post','b2evolution-tips-category-andash-sub-intro-post',NULL,NULL,NULL,'',11,'noreq',NULL,0,12,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,NULL,1,1,NULL,'2008-09-28 18:06:11',NULL,'2010-01-25 22:50:23','2010-01-26 12:13:22','deprecated',NULL,1530,'en-US','This uses post type \"Intro-Tag\" and is tagged with the desired Tag(s).','This uses post type \"Intro-Tag\" and is tagged with the desired Tag(s).','Widgets tag &ndash; Sub Intro post','widgets-tag-andash-sub-intro-post',NULL,NULL,NULL,'',11,'noreq',NULL,0,12,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:15:34','deprecated',NULL,1,'en-US','<p>This is a demo of a featured post.</p>\n\n<p>It will be featured whenever we have no specific \"Intro\" post to display for the current request. To see it in action, try displaying the \"Announcements\" category.</p>\n\n<p>Also note that when the post is featured, it does not appear in the regular post flow.</p>','This is a demo of a featured post.\n\n It will be featured whenever we have no specific \"Intro\" post to display for the current request. To see it in action, try displaying the \"Announcements\" category.\n\n Also note that when the post is featured, it does n&hellip;','Featured post','featured-post',NULL,NULL,NULL,'',11,'noreq',NULL,0,52,'open',NULL,'default',3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:16:08','deprecated',NULL,1,'en-US','<p>In the <code>/blogs</code> folder there is a file called [<code>sample.htaccess</code>]. You should try renaming it to [<code>.htaccess</code>].</p>\n\n<p>This will optimize the way b2evolution is handled by the webserver (if you are using Apache). This file is not active by default because a few hosts would display an error right away when you try to use it. If this happens to you when you rename the file, just remove it and you\'ll be fine.</p>','In the /blogs folder there is a file called [sample.htaccess]. You should try renaming it to [.htaccess].\n\n This will optimize the way b2evolution is handled by the webserver (if you are using Apache). This file is not active by default because a few hos&hellip;','Apache optimization...','apache-optimization',NULL,NULL,NULL,'',11,'noreq',NULL,0,73,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:15:37','deprecated',NULL,1,'en-US','<p>By default, blogs are displayed using an evoskin. (More on skins in another post.)</p>\n\n<p>This means, blogs are accessed through \'<code>index.php</code>\', which loads default parameters from the database and then passes on the display job to a skin.</p>\n\n<p>Alternatively, if you don\'t want to use the default DB parameters and want to, say, force a skin, a category or a specific linkblog, you can create a stub file like the provided \'<code>a_stub.php</code>\' and call your blog through this stub instead of index.php .</p>\n\n<p>Finally, if you need to do some very specific customizations to your blog, you may use plain templates instead of skins. In this case, call your blog through a full template, like the provided \'<code>a_noskin.php</code>\'.</p>\n\n<p>If you want to integrate a b2evolution blog into a complex website, you\'ll probably want to do it by copy/pasting code from <code>a_noskin.php</code> into a page of your website.</p>\n\n<p>You will find more information in the stub/template files themselves. Open them in a text editor and read the comments in there.</p>\n\n<p>Either way, make sure you go to the blogs admin and set the correct access method/URL for your blog. Otherwise, the permalinks will not function properly.</p>','By default, blogs are displayed using an evoskin. (More on skins in another post.)\n\n This means, blogs are accessed through \'index.php\', which loads default parameters from the database and then passes on the display job to a skin.\n\n Alternatively, if yo&hellip;','Skins, Stubs, Templates &amp; website integration...','skins-stubs-templates-aamp-website-integration',NULL,NULL,NULL,'',11,'noreq',NULL,0,194,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:16:13','deprecated',NULL,1,'en-US','<p>b2evolution blogs are installed with a default selection of Widgets. For example, the sidebar of this blog includes widgets like a calendar, a search field, a list of categories, a list of XML feeds, etc.</p>\n\n<p>You can add, remove and reorder widgets from the Blog Settings tab in the admin interface.</p>\n\n<p>Note: to be displayed widgets are placed in containers. Each container appears in a specific place in an evoskin. If you change your blog skin, the new skin may not use the same containers as the previous one. Make sure you place your widgets in containers that exist in the specific skin you are using.</p>','b2evolution blogs are installed with a default selection of Widgets. For example, the sidebar of this blog includes widgets like a calendar, a search field, a list of categories, a list of XML feeds, etc.\n\n You can add, remove and reorder widgets from th&hellip;','About widgets...','about-widgets',NULL,NULL,NULL,'',11,'noreq',NULL,0,106,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:16:11','deprecated',NULL,1,'en-US','<p>By default, b2evolution blogs are displayed using an evoskin.</p>\n\n<p>You can change the skin used by any blog by editing the blog settings in the admin interface.</p>\n\n<p>You can download additional skins from the <a href=\"http://skins.b2evolution.net/\" target=\"_blank\">skin site</a>. To install them, unzip them in the /blogs/skins directory, then go to General Settings &gt; Skins in the admin interface and click on \"Install new\".</p>\n\n<p>You can also create your own skins by duplicating, renaming and customizing any existing skin folder from the /blogs/skins directory.</p>\n\n<p>To start customizing a skin, open its \"<code>index.main.php</code>\" file in an editor and read the comments in there. Note: you can also edit skins in the \"Files\" tab of the admin interface.</p>\n\n<p>And, of course, read the <a href=\"http://manual.b2evolution.net/Skins_2.0\" target=\"_blank\">manual on skins</a>!</p>','By default, b2evolution blogs are displayed using an evoskin.\n\n You can change the skin used by any blog by editing the blog settings in the admin interface.\n\n You can download additional skins from the skin site. To install them, unzip them in the /blog&hellip;','About skins...','about-skins',NULL,NULL,NULL,'',11,'noreq',NULL,1,121,'open',NULL,'default',3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:14:33','deprecated',NULL,1,'en-US','<p>This post has an image attached to it. The image is automatically resized to fit the current blog skin. You can zoom in by clicking on the thumbnail.</p>\n\n<p>Check out the photoblog (accessible through the links at the top) to see a completely different skin focused more on the photos than on the blog text.</p>','This post has an image attached to it. The image is automatically resized to fit the current blog skin. You can zoom in by clicking on the thumbnail.\n\n Check out the photoblog (accessible through the links at the top) to see a completely different skin f&hellip;','Image post','image-post',NULL,NULL,NULL,'',3,'noreq',NULL,0,55,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:14:31','deprecated',NULL,1,'en-US','<p>This is page 1 of a multipage post.</p>\n\n<p>You can see the other pages by clicking on the links below the text.</p>\n\n<!--nextpage-->\n\n<p>This is page 2.</p>\n\n<!--nextpage-->\n\n<p>This is page 3.</p>\n\n<!--nextpage-->\n\n<p>This is page 4.</p>\n\n<p>It is the last page.</p>','This is page 1 of a multipage post.\n\n You can see the other pages by clicking on the links below the text.\n\n\n\n This is page 2.\n\n\n\n This is page 3.\n\n\n\n This is page 4.\n\n It is the last page.','This is a multipage post','this-is-a-multipage-post',NULL,NULL,NULL,'',3,'noreq',NULL,0,35,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:14:38','deprecated',NULL,1,'en-US','<p>This is an extended post with no teaser. This means that you won\'t see this teaser any more when you click the \"more\" link.</p>\n\n<!--more--><!--noteaser-->\n\n<p>This is the extended text. You only see it when you have clicked the \"more\" link.</p>','This is an extended post with no teaser. This means that you won\'t see this teaser any more when you click the \"more\" link.\n\n\n\n This is the extended text. You only see it when you have clicked the \"more\" link.','Extended post with no teaser','extended-post-with-no-teaser',NULL,NULL,NULL,'',3,'noreq',NULL,0,40,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:14:36','deprecated',NULL,1,'en-US','<p>This is an extended post. This means you only see this small teaser by default and you must click on the link below to see more.</p>\n\n<!--more-->\n\n<p>This is the extended text. You only see it when you have clicked the \"more\" link.</p>','This is an extended post. This means you only see this small teaser by default and you must click on the link below to see more.\n\n\n\n This is the extended text. You only see it when you have clicked the \"more\" link.','Extended post','extended-post',NULL,NULL,NULL,'',3,'noreq',NULL,0,42,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,NULL,1,1,NULL,'2010-01-25 22:50:23',NULL,'2010-01-25 22:50:23','2010-01-26 12:14:26','deprecated',NULL,1,'en-US','<p>Four blogs have been created with sample contents:</p>\n\n<ul>\n	<li><strong>Blog A</strong>: You are currently looking at it. It contains a few sample posts, using simple features of b2evolution.</li>\n	<li><strong>Blog B</strong>: You can access it from a link at the top of the page. It contains information about more advanced features.</li>\n	<li><strong>Linkblog</strong>: By default, the linkblog is included as a \"Blogroll\" in the sidebar of both Blog A &amp; Blog B.</li>\n	<li><strong>Photoblog</strong>: This blog is an example of how you can use b2evolution to showcase photos, with one photo per page as well as a thumbnail index.</li>\n</ul>\n\n<p>You can add new blogs, delete unwanted blogs and customize existing blogs (title, sidebar, blog skin, widgets, etc.) from the Blog Settings tab in the admin interface.</p>','Four blogs have been created with sample contents:\n\n\n	Blog A: You are currently looking at it. It contains a few sample posts, using simple features of b2evolution.\n	Blog B: You can access it from a link at the top of the page. It contains information ab&hellip;','Welcome to b2evolution!','welcome-to-b2evolution',NULL,NULL,NULL,'',1,'noreq',NULL,1,122,'open',NULL,'default',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,NULL,1,1,NULL,'2010-02-12 15:45:57',NULL,'2010-02-12 15:41:58','2010-02-12 16:00:15','published',NULL,1,'en-US','<p>The <strong>Mariinsky Theatre</strong><span style=\"color: #000000;\"> </span><span style=\"color: #000000;\">is a historic theatre of </span><span style=\"color: #000000;\">opera</span><span style=\"color: #000000;\"> and </span><span style=\"color: #000000;\">ballet</span><span style=\"color: #000000;\"> in </span><span style=\"color: #000000;\">Saint Petersburg</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Russia</span><span style=\"color: #000000;\">. Opened in 1860, it became the preeminent music theatre of late 19th century Russia, where many of the stage masterpieces of </span><span style=\"color: #000000;\">Tchaikovsky</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Mussorgsky</span><span style=\"color: #000000;\">, and </span><span style=\"color: #000000;\">Rimsky-Korsakov</span><span style=\"color: #000000;\"> received their premieres. The Mariinsky Theatre is home to the </span><span style=\"color: #000000;\">Mariinsky Ballet</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Mariinsky Opera</span><span style=\"color: #000000;\"> and Mariinsky Orchestra.</span></p>\r\n<p><span style=\"color: #000000;\">Here is a wonderful link to Mariinsky Theater media center <a href=\"http://media.mariinsky.ru/Play/#/en/\">http://media.mariinsky.ru/Play/#/en/</a> The information is both in Russian and in English. A lot of the clips have Russian audio with English subtitles. It\'s a great way to see how well you understand spoken Russian!</span></p>','The Mariinsky Theatre is a historic theatre of opera and ballet in Saint Petersburg, Russia. Opened in 1860, it became the preeminent music theatre of late 19th century Russia, where many of the stage masterpieces of Tchaikovsky, Mussorgsky, and Rimsky-K&hellip;','Mariinsky Theatre Media Center','mariinsky-theatre-media-center','','','','',12,'finished',NULL,3,97,'open',NULL,'b2evALnk.evo_videoplug',3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'evo_TinyMCE');

--
-- Table structure for table `evo_items__itemtag`
--

CREATE TABLE `evo_items__itemtag` (
  `itag_itm_ID` int(11) unsigned NOT NULL,
  `itag_tag_ID` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`itag_itm_ID`,`itag_tag_ID`),
  UNIQUE KEY `tagitem` (`itag_tag_ID`,`itag_itm_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_items__itemtag`
--

INSERT INTO `evo_items__itemtag` VALUES (20,1),(23,2),(24,1),(25,2);

--
-- Table structure for table `evo_items__prerendering`
--

CREATE TABLE `evo_items__prerendering` (
  `itpr_itm_ID` int(11) unsigned NOT NULL,
  `itpr_format` enum('htmlbody','entityencoded','xml','text') collate utf8_unicode_ci NOT NULL,
  `itpr_renderers` text collate utf8_unicode_ci NOT NULL,
  `itpr_content_prerendered` mediumtext collate utf8_unicode_ci,
  `itpr_datemodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`itpr_itm_ID`,`itpr_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_items__prerendering`
--

INSERT INTO `evo_items__prerendering` VALUES (21,'text','b2evALnk.evo_videoplug','<p>This is a demo of a featured post.</p>\n\n<p>It will be featured whenever we have no specific \"Intro\" post to display for the current request. To see it in action, try displaying the \"Announcements\" category.</p>\n\n<p>Also note that when the post is featured, it does not appear in the regular post flow.</p>','2010-09-29 00:57:03'),(23,'text','b2evALnk.evo_videoplug','<p>By default, blogs are displayed using an evoskin. (More on skins in another post.)</p>\n\n<p>This means, blogs are accessed through \'<code>index.php</code>\', which loads default parameters from the database and then passes on the display job to a skin.</p>\n\n<p>Alternatively, if you don\'t want to use the default DB parameters and want to, say, force a skin, a category or a specific linkblog, you can create a stub file like the provided \'<code>a_stub.php</code>\' and call your blog through this stub instead of index.php .</p>\n\n<p>Finally, if you need to do some very specific customizations to your blog, you may use plain templates instead of skins. In this case, call your blog through a full template, like the provided \'<code>a_noskin.php</code>\'.</p>\n\n<p>If you want to integrate a b2evolution blog into a complex website, you\'ll probably want to do it by copy/pasting code from <code>a_noskin.php</code> into a page of your website.</p>\n\n<p>You will find more information in the stub/template files themselves. Open them in a text editor and read the comments in there.</p>\n\n<p>Either way, make sure you go to the blogs admin and set the correct access method/URL for your blog. Otherwise, the permalinks will not function properly.</p>','2010-09-29 00:57:03'),(22,'text','b2evALnk.evo_videoplug','<p>In the <code>/blogs</code> folder there is a file called [<code>sample.htaccess</code>]. You should try renaming it to [<code>.htaccess</code>].</p>\n\n<p>This will optimize the way b2evolution is handled by the webserver (if you are using Apache). This file is not active by default because a few hosts would display an error right away when you try to use it. If this happens to you when you rename the file, just remove it and you\'ll be fine.</p>','2010-09-29 00:57:03'),(24,'text','b2evALnk.evo_videoplug','<p>b2evolution blogs are installed with a default selection of Widgets. For example, the sidebar of this blog includes widgets like a calendar, a search field, a list of categories, a list of XML feeds, etc.</p>\n\n<p>You can add, remove and reorder widgets from the Blog Settings tab in the admin interface.</p>\n\n<p>Note: to be displayed widgets are placed in containers. Each container appears in a specific place in an evoskin. If you change your blog skin, the new skin may not use the same containers as the previous one. Make sure you place your widgets in containers that exist in the specific skin you are using.</p>','2010-09-29 00:57:03'),(25,'text','b2evALnk.evo_videoplug','<p>By default, b2evolution blogs are displayed using an evoskin.</p>\n\n<p>You can change the skin used by any blog by editing the blog settings in the admin interface.</p>\n\n<p>You can download additional skins from the <a href=\"http://skins.b2evolution.net/\" target=\"_blank\">skin site</a>. To install them, unzip them in the /blogs/skins directory, then go to General Settings &gt; Skins in the admin interface and click on \"Install new\".</p>\n\n<p>You can also create your own skins by duplicating, renaming and customizing any existing skin folder from the /blogs/skins directory.</p>\n\n<p>To start customizing a skin, open its \"<code>index.main.php</code>\" file in an editor and read the comments in there. Note: you can also edit skins in the \"Files\" tab of the admin interface.</p>\n\n<p>And, of course, read the <a href=\"http://manual.b2evolution.net/Skins_2.0\" target=\"_blank\">manual on skins</a>!</p>','2010-09-29 00:57:03'),(28,'text','b2evALnk.evo_videoplug','<p>This is an extended post with no teaser. This means that you won\'t see this teaser any more when you click the \"more\" link.</p>\n\n<!--more--><!--noteaser-->\n\n<p>This is the extended text. You only see it when you have clicked the \"more\" link.</p>','2010-09-29 00:23:32'),(29,'text','b2evALnk.evo_videoplug','<p>This is an extended post. This means you only see this small teaser by default and you must click on the link below to see more.</p>\n\n<!--more-->\n\n<p>This is the extended text. You only see it when you have clicked the \"more\" link.</p>','2010-09-29 00:23:32'),(26,'text','b2evALnk.evo_videoplug','<p>This post has an image attached to it. The image is automatically resized to fit the current blog skin. You can zoom in by clicking on the thumbnail.</p>\n\n<p>Check out the photoblog (accessible through the links at the top) to see a completely different skin focused more on the photos than on the blog text.</p>','2010-09-29 00:23:32'),(27,'text','b2evALnk.evo_videoplug','<p>This is page 1 of a multipage post.</p>\n\n<p>You can see the other pages by clicking on the links below the text.</p>\n\n<!--nextpage-->\n\n<p>This is page 2.</p>\n\n<!--nextpage-->\n\n<p>This is page 3.</p>\n\n<!--nextpage-->\n\n<p>This is page 4.</p>\n\n<p>It is the last page.</p>','2010-09-29 00:23:32'),(31,'htmlbody','b2evALnk.evo_videoplug','<p>The <strong>Mariinsky Theatre</strong><span style=\"color: #000000;\"> </span><span style=\"color: #000000;\">is a historic theatre of </span><span style=\"color: #000000;\">opera</span><span style=\"color: #000000;\"> and </span><span style=\"color: #000000;\">ballet</span><span style=\"color: #000000;\"> in </span><span style=\"color: #000000;\">Saint Petersburg</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Russia</span><span style=\"color: #000000;\">. Opened in 1860, it became the preeminent music theatre of late 19th century Russia, where many of the stage masterpieces of </span><span style=\"color: #000000;\">Tchaikovsky</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Mussorgsky</span><span style=\"color: #000000;\">, and </span><span style=\"color: #000000;\">Rimsky-Korsakov</span><span style=\"color: #000000;\"> received their premieres. The Mariinsky Theatre is home to the </span><span style=\"color: #000000;\">Mariinsky Ballet</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Mariinsky Opera</span><span style=\"color: #000000;\"> and Mariinsky Orchestra.</span></p>\r\n<p><span style=\"color: #000000;\">Here is a wonderful link to Mariinsky Theater media center <a href=\"http://media.mariinsky.ru/Play/#/en/\">http://media.mariinsky.ru/Play/#/en/</a> The information is both in Russian and in English. A lot of the clips have Russian audio with English subtitles. It\'s a great way to see how well you understand spoken Russian!</span></p>','2010-09-28 06:08:10'),(11,'text','','','2010-02-12 21:36:08'),(12,'text','','','2010-02-12 21:36:08'),(13,'text','','','2010-02-12 21:36:08'),(14,'text','','','2010-02-12 21:36:08'),(10,'text','','','2010-02-12 21:36:08'),(2,'htmlbody','b2evALnk.evo_videoplug','<p>During the first year of Russian we teach that English word \"magazine\" and Russian word \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" are false cognates. The main definition of the word \"magazine\" is \"journal\" and Russian \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" means \"store\". But has this always been the case?</p>\r\n\r\n<p>In actuality, both words come from M.Fr. magasin \"warehouse, depot, store,\" from It. magazzino, from Arabic makhazin, pl. of makhzan \"storehouse,\" from khazana \"to store up.\" In 1580s English \"magazine\" meant a \"place for storing goods, especially military ammunition\". The word acquired its main nowaday meaning as \"periodical, journal\" in 1731 after the publication of the first one \"Gentleman\'s Magazine\", a \"storehouse\" of information.</p>','2010-09-30 16:16:07'),(30,'text','b2evALnk.evo_videoplug','<p>Four blogs have been created with sample contents:</p>\n\n<ul>\n	<li><strong>Blog A</strong>: You are currently looking at it. It contains a few sample posts, using simple features of b2evolution.</li>\n	<li><strong>Blog B</strong>: You can access it from a link at the top of the page. It contains information about more advanced features.</li>\n	<li><strong>Linkblog</strong>: By default, the linkblog is included as a \"Blogroll\" in the sidebar of both Blog A &amp; Blog B.</li>\n	<li><strong>Photoblog</strong>: This blog is an example of how you can use b2evolution to showcase photos, with one photo per page as well as a thumbnail index.</li>\n</ul>\n\n<p>You can add new blogs, delete unwanted blogs and customize existing blogs (title, sidebar, blog skin, widgets, etc.) from the Blog Settings tab in the admin interface.</p>','2010-09-29 01:20:37'),(2,'entityencoded','b2evALnk.evo_videoplug','<p>During the first year of Russian we teach that English word \"magazine\" and Russian word \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" are false cognates. The main definition of the word \"magazine\" is \"journal\" and Russian \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" means \"store\". But has this always been the case?</p>\r\n\r\n<p>In actuality, both words come from M.Fr. magasin \"warehouse, depot, store,\" from It. magazzino, from Arabic makhazin, pl. of makhzan \"storehouse,\" from khazana \"to store up.\" In 1580s English \"magazine\" meant a \"place for storing goods, especially military ammunition\". The word acquired its main nowaday meaning as \"periodical, journal\" in 1731 after the publication of the first one \"Gentleman\'s Magazine\", a \"storehouse\" of information.</p>','2010-09-30 16:16:44'),(2,'text','b2evALnk.evo_videoplug','<p>During the first year of Russian we teach that English word \"magazine\" and Russian word \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" are false cognates. The main definition of the word \"magazine\" is \"journal\" and Russian \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" means \"store\". But has this always been the case?</p>\r\n\r\n<p>In actuality, both words come from M.Fr. magasin \"warehouse, depot, store,\" from It. magazzino, from Arabic makhazin, pl. of makhzan \"storehouse,\" from khazana \"to store up.\" In 1580s English \"magazine\" meant a \"place for storing goods, especially military ammunition\". The word acquired its main nowaday meaning as \"periodical, journal\" in 1731 after the publication of the first one \"Gentleman\'s Magazine\", a \"storehouse\" of information.</p>','2010-09-30 18:01:04');

--
-- Table structure for table `evo_items__status`
--

CREATE TABLE `evo_items__status` (
  `pst_ID` int(11) unsigned NOT NULL auto_increment,
  `pst_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`pst_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_items__status`
--


--
-- Table structure for table `evo_items__tag`
--

CREATE TABLE `evo_items__tag` (
  `tag_ID` int(11) unsigned NOT NULL auto_increment,
  `tag_name` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`tag_ID`),
  UNIQUE KEY `tag_name` (`tag_name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_items__tag`
--

INSERT INTO `evo_items__tag` VALUES (2,'skins'),(1,'widgets');

--
-- Table structure for table `evo_items__type`
--

CREATE TABLE `evo_items__type` (
  `ptyp_ID` int(11) unsigned NOT NULL auto_increment,
  `ptyp_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ptyp_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5001 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_items__type`
--

INSERT INTO `evo_items__type` VALUES (1,'Post'),(1000,'Page'),(1500,'Intro-Main'),(1520,'Intro-Cat'),(1530,'Intro-Tag'),(1570,'Intro-Sub'),(1600,'Intro-All'),(2000,'Podcast'),(3000,'Sidebar link'),(4000,'Reserved'),(5000,'Reserved');

--
-- Table structure for table `evo_items__version`
--

CREATE TABLE `evo_items__version` (
  `iver_itm_ID` int(10) unsigned NOT NULL,
  `iver_edit_user_ID` int(10) unsigned default NULL,
  `iver_edit_datetime` datetime NOT NULL,
  `iver_status` enum('published','deprecated','protected','private','draft','redirected') collate utf8_unicode_ci default NULL,
  `iver_title` text collate utf8_unicode_ci,
  `iver_content` mediumtext collate utf8_unicode_ci,
  KEY `iver_itm_ID` (`iver_itm_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_items__version`
--

INSERT INTO `evo_items__version` VALUES (20,1,'2010-01-25 22:50:23','published','Widgets tag &ndash; Sub Intro post','This uses post type \"Intro-Tag\" and is tagged with the desired Tag(s).'),(19,1,'2010-01-25 22:50:23','published','b2evolution tips category &ndash; Sub Intro post','This uses post type \"Intro-Cat\" and is attached to the desired Category(ies).'),(18,1,'2010-01-25 22:50:23','published','Main Intro post','This is the main intro post. It appears on the homepage only.'),(17,1,'2010-01-25 22:50:23','published','About this system','<p>This blog platform is powered by b2evolution.</p>\n\n<p>You are currently looking at an info page about this system. It is cross-posted among the demo blogs. Thus, this page will be linked on each of these blogs.</p>\n\n<p>Info pages are very much like regular posts, except that they do not appear in the regular flow of posts. They appear as info pages in the sidebar instead.</p>\n\n<p>If needed, an evoskin can format info pages differently from regular posts.</p>'),(16,1,'2010-01-25 22:50:23','published','About Blog A','<p>This blog is powered by b2evolution.</p>\n\n<p>You are currently looking at an info page about Blog A.</p>\n\n<p>Info pages are very much like regular posts, except that they do not appear in the regular flow of posts. They appear as info pages in the sidebar instead.</p>\n\n<p>If needed, an evoskin can format info pages differently from regular posts.</p>'),(30,1,'2010-01-25 22:50:23','published','Welcome to b2evolution!','<p>Four blogs have been created with sample contents:</p>\n\n<ul>\n	<li><strong>Blog A</strong>: You are currently looking at it. It contains a few sample posts, using simple features of b2evolution.</li>\n	<li><strong>Blog B</strong>: You can access it from a link at the top of the page. It contains information about more advanced features.</li>\n	<li><strong>Linkblog</strong>: By default, the linkblog is included as a \"Blogroll\" in the sidebar of both Blog A &amp; Blog B.</li>\n	<li><strong>Photoblog</strong>: This blog is an example of how you can use b2evolution to showcase photos, with one photo per page as well as a thumbnail index.</li>\n</ul>\n\n<p>You can add new blogs, delete unwanted blogs and customize existing blogs (title, sidebar, blog skin, widgets, etc.) from the Blog Settings tab in the admin interface.</p>'),(27,1,'2010-01-25 22:50:23','published','This is a multipage post','<p>This is page 1 of a multipage post.</p>\n\n<p>You can see the other pages by clicking on the links below the text.</p>\n\n<!--nextpage-->\n\n<p>This is page 2.</p>\n\n<!--nextpage-->\n\n<p>This is page 3.</p>\n\n<!--nextpage-->\n\n<p>This is page 4.</p>\n\n<p>It is the last page.</p>'),(26,1,'2010-01-25 22:50:23','published','Image post','<p>This post has an image attached to it. The image is automatically resized to fit the current blog skin. You can zoom in by clicking on the thumbnail.</p>\n\n<p>Check out the photoblog (accessible through the links at the top) to see a completely different skin focused more on the photos than on the blog text.</p>'),(29,1,'2010-01-25 22:50:23','published','Extended post','<p>This is an extended post. This means you only see this small teaser by default and you must click on the link below to see more.</p>\n\n<!--more-->\n\n<p>This is the extended text. You only see it when you have clicked the \"more\" link.</p>'),(28,1,'2010-01-25 22:50:23','published','Extended post with no teaser','<p>This is an extended post with no teaser. This means that you won\'t see this teaser any more when you click the \"more\" link.</p>\n\n<!--more--><!--noteaser-->\n\n<p>This is the extended text. You only see it when you have clicked the \"more\" link.</p>'),(2,1,'2010-01-25 22:50:23','published','Second post','<p>This is the second post.</p>\n\n<p>It appears in multiple categories.</p>'),(21,1,'2010-01-25 22:50:23','published','Featured post','<p>This is a demo of a featured post.</p>\n\n<p>It will be featured whenever we have no specific \"Intro\" post to display for the current request. To see it in action, try displaying the \"Announcements\" category.</p>\n\n<p>Also note that when the post is featured, it does not appear in the regular post flow.</p>'),(23,1,'2010-01-25 22:50:23','published','Skins, Stubs, Templates &amp; website integration...','<p>By default, blogs are displayed using an evoskin. (More on skins in another post.)</p>\n\n<p>This means, blogs are accessed through \'<code>index.php</code>\', which loads default parameters from the database and then passes on the display job to a skin.</p>\n\n<p>Alternatively, if you don\'t want to use the default DB parameters and want to, say, force a skin, a category or a specific linkblog, you can create a stub file like the provided \'<code>a_stub.php</code>\' and call your blog through this stub instead of index.php .</p>\n\n<p>Finally, if you need to do some very specific customizations to your blog, you may use plain templates instead of skins. In this case, call your blog through a full template, like the provided \'<code>a_noskin.php</code>\'.</p>\n\n<p>If you want to integrate a b2evolution blog into a complex website, you\'ll probably want to do it by copy/pasting code from <code>a_noskin.php</code> into a page of your website.</p>\n\n<p>You will find more information in the stub/template files themselves. Open them in a text editor and read the comments in there.</p>\n\n<p>Either way, make sure you go to the blogs admin and set the correct access method/URL for your blog. Otherwise, the permalinks will not function properly.</p>'),(22,1,'2010-01-25 22:50:23','published','Apache optimization...','<p>In the <code>/blogs</code> folder there is a file called [<code>sample.htaccess</code>]. You should try renaming it to [<code>.htaccess</code>].</p>\n\n<p>This will optimize the way b2evolution is handled by the webserver (if you are using Apache). This file is not active by default because a few hosts would display an error right away when you try to use it. If this happens to you when you rename the file, just remove it and you\'ll be fine.</p>'),(25,1,'2010-01-25 22:50:23','published','About skins...','<p>By default, b2evolution blogs are displayed using an evoskin.</p>\n\n<p>You can change the skin used by any blog by editing the blog settings in the admin interface.</p>\n\n<p>You can download additional skins from the <a href=\"http://skins.b2evolution.net/\" target=\"_blank\">skin site</a>. To install them, unzip them in the /blogs/skins directory, then go to General Settings &gt; Skins in the admin interface and click on \"Install new\".</p>\n\n<p>You can also create your own skins by duplicating, renaming and customizing any existing skin folder from the /blogs/skins directory.</p>\n\n<p>To start customizing a skin, open its \"<code>index.main.php</code>\" file in an editor and read the comments in there. Note: you can also edit skins in the \"Files\" tab of the admin interface.</p>\n\n<p>And, of course, read the <a href=\"http://manual.b2evolution.net/Skins_2.0\" target=\"_blank\">manual on skins</a>!</p>'),(24,1,'2010-01-25 22:50:23','published','About widgets...','<p>b2evolution blogs are installed with a default selection of Widgets. For example, the sidebar of this blog includes widgets like a calendar, a search field, a list of categories, a list of XML feeds, etc.</p>\n\n<p>You can add, remove and reorder widgets from the Blog Settings tab in the admin interface.</p>\n\n<p>Note: to be displayed widgets are placed in containers. Each container appears in a specific place in an evoskin. If you change your blog skin, the new skin may not use the same containers as the previous one. Make sure you place your widgets in containers that exist in the specific skin you are using.</p>'),(15,1,'2010-01-25 22:50:23','published','About Blog B','<p>This blog is powered by b2evolution.</p>\n\n<p>You are currently looking at an info page about Blog B.</p>\n\n<p>Info pages are very much like regular posts, except that they do not appear in the regular flow of posts. They appear as info pages in the sidebar instead.</p>\n\n<p>If needed, an evoskin can format info pages differently from regular posts.</p>'),(8,1,'2010-01-25 22:50:23','published','Danny',''),(9,1,'2010-01-25 22:50:23','published','Daniel',''),(10,1,'2010-01-25 22:50:23','published','Francois',''),(14,1,'2010-01-25 22:50:23','published','Support',''),(13,1,'2010-01-25 22:50:23','published','Manual',''),(12,1,'2010-01-25 22:50:23','published','Web hosting',''),(11,1,'2010-01-25 22:50:23','published','Blog news',''),(3,1,'2010-01-25 22:50:23','published','Bus Stop Ahead','In the middle of nowhere: a school bus stop where you wouldn\'t really expect it!'),(4,1,'2010-01-25 22:50:23','published','John Ford Point','Does this scene look familiar? You\'ve probably seen it in a couple of John Ford westerns!'),(6,1,'2010-01-25 22:50:23','published','Road to Monument Valley','This gives a pretty good idea of the Monuments you\'re about to drive into...'),(7,1,'2010-01-25 22:50:23','published','Monument Valley','This is a short photo album demo. Use the arrows to navigate between photos. Click on \"Index\" to see a thumbnail index.'),(5,1,'2010-01-25 22:50:23','published','Monuments','This is one of the most famous views in Monument Valley. I like to frame it with the dirt road in order to give a better idea of the size of those things!'),(31,1,'2010-02-12 15:41:58','draft','Mariinsky Theatre Media Center','<p>The <strong>Mariinsky Theatre</strong><span style=\"color: #000000;\"> </span><span style=\"color: #000000;\">is a historic theatre of </span><span style=\"color: #000000;\">opera</span><span style=\"color: #000000;\"> and </span><span style=\"color: #000000;\">ballet</span><span style=\"color: #000000;\"> in </span><span style=\"color: #000000;\">Saint Petersburg</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Russia</span><span style=\"color: #000000;\">. Opened in 1860, it became the preeminent music theatre of late 19th century Russia, where many of the stage masterpieces of </span><span style=\"color: #000000;\">Tchaikovsky</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Mussorgsky</span><span style=\"color: #000000;\">, and </span><span style=\"color: #000000;\">Rimsky-Korsakov</span><span style=\"color: #000000;\"> received their premieres. The Mariinsky Theatre is home to the </span><span style=\"color: #000000;\">Mariinsky Ballet</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Mariinsky Opera</span><span style=\"color: #000000;\"> and Mariinsky Orchestra.</span></p>\r\n<p><span style=\"color: #000000;\">Here is a wonderful link to Mariinsky Theater media center <a href=\"http://media.mariinsky.ru/Play/#/en/\">http://media.mariinsky.ru/Play/#/en/</a> The information is both in Russian and in English.</span></p>'),(31,1,'2010-02-12 15:45:57','published','Mariinsky Theatre Media Center','<p>The <strong>Mariinsky Theatre</strong><span style=\"color: #000000;\"> </span><span style=\"color: #000000;\">is a historic theatre of </span><span style=\"color: #000000;\">opera</span><span style=\"color: #000000;\"> and </span><span style=\"color: #000000;\">ballet</span><span style=\"color: #000000;\"> in </span><span style=\"color: #000000;\">Saint Petersburg</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Russia</span><span style=\"color: #000000;\">. Opened in 1860, it became the preeminent music theatre of late 19th century Russia, where many of the stage masterpieces of </span><span style=\"color: #000000;\">Tchaikovsky</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Mussorgsky</span><span style=\"color: #000000;\">, and </span><span style=\"color: #000000;\">Rimsky-Korsakov</span><span style=\"color: #000000;\"> received their premieres. The Mariinsky Theatre is home to the </span><span style=\"color: #000000;\">Mariinsky Ballet</span><span style=\"color: #000000;\">, </span><span style=\"color: #000000;\">Mariinsky Opera</span><span style=\"color: #000000;\"> and Mariinsky Orchestra.</span></p>\r\n<p><span style=\"color: #000000;\">Here is a wonderful link to Mariinsky Theater media center <a href=\"http://media.mariinsky.ru/Play/#/en/\">http://media.mariinsky.ru/Play/#/en/</a> The information is both in Russian and in English.</span></p>'),(2,1,'2010-01-26 12:14:40','deprecated','Second post','<p>This is the second post.</p>\n\n<p>It appears in multiple categories.</p>'),(2,1,'2010-09-28 00:40:43','deprecated','Magazine vs. ìàãàçèí','<p>During the first year of Russian we teach that English word \"magazine\" and Russian word \"ìàãàçèí\" are false cognates. The main definition of the word \"magazine\" is \"journal\" and Russian \"ìàãàçèí\" means \"store\". But has this always been the case?</p>\r\n\r\n<p>In actuality, both words come from M.Fr. magasin \"warehouse, depot, store,\" from It. magazzino, from Arabic makhazin, pl. of makhzan \"storehouse,\" from khazana \"to store up.\" In 1580s English \"magazine\" meant a \"place for storing goods, especially military ammunition\". The word acquired its main nowaday meaning as \"periodical, journal\" in 1731 after the publication of the first one \"Gentleman\'s Magazine\", a \"storehouse\" of information.</p>'),(2,1,'2010-09-28 20:19:56','draft','Magazine vs. ìàãàçèí','<p>During the first year of Russian we teach that English word \"magazine\" and Russian word \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" are false cognates. The main definition of the word \"magazine\" is \"journal\" and Russian \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" means \"store\". But has this always been the case?</p>\r\n\r\n<p>In actuality, both words come from M.Fr. magasin \"warehouse, depot, store,\" from It. magazzino, from Arabic makhazin, pl. of makhzan \"storehouse,\" from khazana \"to store up.\" In 1580s English \"magazine\" meant a \"place for storing goods, especially military ammunition\". The word acquired its main nowaday meaning as \"periodical, journal\" in 1731 after the publication of the first one \"Gentleman\'s Magazine\", a \"storehouse\" of information.</p>'),(2,1,'2010-09-29 00:06:58','draft','Magazine vs. ÌÀÃÀÇÈÍ','<p>During the first year of Russian we teach that English word \"magazine\" and Russian word \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" are false cognates. The main definition of the word \"magazine\" is \"journal\" and Russian \"&#236;&#224;&#227;&#224;&#231;&#232;&#237;\" means \"store\". But has this always been the case?</p>\r\n\r\n<p>In actuality, both words come from M.Fr. magasin \"warehouse, depot, store,\" from It. magazzino, from Arabic makhazin, pl. of makhzan \"storehouse,\" from khazana \"to store up.\" In 1580s English \"magazine\" meant a \"place for storing goods, especially military ammunition\". The word acquired its main nowaday meaning as \"periodical, journal\" in 1731 after the publication of the first one \"Gentleman\'s Magazine\", a \"storehouse\" of information.</p>');

--
-- Table structure for table `evo_links`
--

CREATE TABLE `evo_links` (
  `link_ID` int(11) unsigned NOT NULL auto_increment,
  `link_datecreated` datetime NOT NULL default '2000-01-01 00:00:00',
  `link_datemodified` datetime NOT NULL default '2000-01-01 00:00:00',
  `link_creator_user_ID` int(11) unsigned NOT NULL,
  `link_lastedit_user_ID` int(11) unsigned NOT NULL,
  `link_itm_ID` int(11) unsigned NOT NULL,
  `link_dest_itm_ID` int(11) unsigned default NULL,
  `link_file_ID` int(11) unsigned default NULL,
  `link_ltype_ID` int(11) unsigned NOT NULL default '1',
  `link_external_url` varchar(255) collate utf8_unicode_ci default NULL,
  `link_title` text collate utf8_unicode_ci,
  PRIMARY KEY  (`link_ID`),
  KEY `link_itm_ID` (`link_itm_ID`),
  KEY `link_dest_itm_ID` (`link_dest_itm_ID`),
  KEY `link_file_ID` (`link_file_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_links`
--

INSERT INTO `evo_links` VALUES (1,'2010-01-25 22:50:23','2010-01-25 22:50:23',1,1,3,NULL,2,1,NULL,NULL),(2,'2010-01-25 22:50:23','2010-01-25 22:50:23',1,1,4,NULL,3,1,NULL,NULL),(3,'2010-01-25 22:50:23','2010-01-25 22:50:23',1,1,5,NULL,4,1,NULL,NULL),(4,'2010-01-25 22:50:23','2010-01-25 22:50:23',1,1,6,NULL,5,1,NULL,NULL),(5,'2010-01-25 22:50:23','2010-01-25 22:50:23',1,1,7,NULL,6,1,NULL,NULL),(6,'2010-01-25 22:50:23','2010-01-25 22:50:23',1,1,17,NULL,7,1,NULL,NULL),(7,'2010-01-25 22:50:23','2010-01-25 22:50:23',1,1,26,NULL,4,1,NULL,NULL),(8,'2010-01-25 22:50:23','2010-01-25 22:50:23',1,1,30,NULL,7,1,NULL,NULL),(9,'2010-02-12 15:45:15','2010-02-12 15:45:15',1,1,31,NULL,11,1,NULL,NULL);

--
-- Table structure for table `evo_locales`
--

CREATE TABLE `evo_locales` (
  `loc_locale` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `loc_charset` varchar(15) collate utf8_unicode_ci NOT NULL default 'iso-8859-1',
  `loc_datefmt` varchar(20) collate utf8_unicode_ci NOT NULL default 'y-m-d',
  `loc_timefmt` varchar(20) collate utf8_unicode_ci NOT NULL default 'H:i:s',
  `loc_startofweek` tinyint(3) unsigned NOT NULL default '1',
  `loc_name` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  `loc_messages` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `loc_priority` tinyint(4) unsigned NOT NULL default '0',
  `loc_enabled` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`loc_locale`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_locales`
--

INSERT INTO `evo_locales` VALUES ('en-US','iso-8859-1','m/d/y','h:i:s a',0,'English (US) utf8','en_US',1,1),('en-GB','iso-8859-1','d/m/y','h:i:s a',1,'English (GB) utf8','en_GB',4,0),('en-CA','iso-8859-1','m/d/y','h:i:s a',1,'English (CA) utf8','en_CA',5,0),('en-NZ','iso-8859-1','d/m/y','h:i:s a',1,'English (NZ) utf8','en_NZ',6,0),('en-US-utf8','utf-8','m/d/y','h:i:s a',1,'English (US) utf8','en_US',3,1),('en-IL','iso-8859-1','Y-m-d','H:i:s',1,'English (IL) utf8','en_IL',7,0),('en-AU','iso-8859-1','d/m/y','h:i:s a',1,'English (AU) utf8','en_AU',8,0),('en-SG','iso-8859-1','d/m/y','H:i:s a',1,'English (SG) utf8','en_SG',9,0),('ru-RU','utf-8','j.m.y','H:i:s',1,'Russian (RU) utf8','ru_RU',2,1),('de-DE','iso-8859-1','d.m.y','H:i:s',1,'German (DE) utf8','de_DE',10,0),('fr-FR','iso-8859-1','d.m.y','H:i:s',1,'French (FR) utf8','fr_FR',11,0),('fr-CA','iso-8859-1','m/d/y','h:i:s a',0,'French (CA) utf8','fr_FR',12,0),('fr-BE','iso-8859-1','d/m/y','H:i:s',1,'French (BE) utf8','fr_FR',13,0);

--
-- Table structure for table `evo_pluginevents`
--

CREATE TABLE `evo_pluginevents` (
  `pevt_plug_ID` int(11) unsigned NOT NULL,
  `pevt_event` varchar(40) collate utf8_unicode_ci NOT NULL,
  `pevt_enabled` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`pevt_plug_ID`,`pevt_event`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_pluginevents`
--

INSERT INTO `evo_pluginevents` VALUES (1,'AdminDisplayToolbar',1),(2,'RenderItemAsHtml',1),(3,'RenderItemAsHtml',1),(4,'RenderItemAsHtml',1),(4,'RenderItemAsXml',1),(5,'AdminDisplayToolbar',1),(5,'DisplayCommentToolbar',1),(5,'FilterCommentContent',1),(5,'RenderItemAsHtml',1),(6,'AdminDisplayToolbar',1),(6,'RenderItemAsHtml',1),(6,'RenderItemAsXml',1),(7,'SkinTag',1),(8,'SkinTag',1),(9,'ItemSendPing',1),(10,'ItemSendPing',1),(11,'AdminDisplayEditorButton',1),(12,'ItemSendPing',1);

--
-- Table structure for table `evo_plugins`
--

CREATE TABLE `evo_plugins` (
  `plug_ID` int(11) unsigned NOT NULL auto_increment,
  `plug_priority` tinyint(4) NOT NULL default '50',
  `plug_classname` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  `plug_code` varchar(32) collate utf8_unicode_ci default NULL,
  `plug_apply_rendering` enum('stealth','always','opt-out','opt-in','lazy','never') collate utf8_unicode_ci NOT NULL default 'never',
  `plug_version` varchar(42) collate utf8_unicode_ci NOT NULL default '0',
  `plug_name` varchar(255) collate utf8_unicode_ci default NULL,
  `plug_shortdesc` varchar(255) collate utf8_unicode_ci default NULL,
  `plug_status` enum('enabled','disabled','needs_config','broken') collate utf8_unicode_ci NOT NULL,
  `plug_spam_weight` tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (`plug_ID`),
  UNIQUE KEY `plug_code` (`plug_code`),
  KEY `plug_status` (`plug_status`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_plugins`
--

INSERT INTO `evo_plugins` VALUES (1,30,'quicktags_plugin','b2evQTag','never','2.4.1',NULL,NULL,'enabled',1),(2,70,'auto_p_plugin','b2WPAutP','opt-in','3.3',NULL,NULL,'enabled',1),(3,60,'autolinks_plugin','b2evALnk','opt-out','3.3.2',NULL,NULL,'enabled',1),(4,90,'texturize_plugin','b2WPTxrz','opt-in','2.2-dev',NULL,NULL,'enabled',1),(5,15,'smilies_plugin','b2evSmil','opt-in','3.3',NULL,NULL,'enabled',1),(6,65,'videoplug_plugin','evo_videoplug','opt-out','2.2',NULL,NULL,'enabled',1),(7,20,'calendar_plugin','evo_Calr','never','3.0',NULL,NULL,'enabled',1),(8,50,'archives_plugin','evo_Arch','never','3.2',NULL,NULL,'enabled',1),(9,50,'ping_b2evonet_plugin','ping_b2evonet','never','2.4.2.1',NULL,NULL,'enabled',1),(10,50,'ping_pingomatic_plugin','ping_pingomatic','never','1.9-dev',NULL,NULL,'enabled',1),(11,10,'tinymce_plugin','evo_TinyMCE','never','3.3.0',NULL,NULL,'enabled',1),(12,50,'twitter_plugin','evo_twitter','never','3.2',NULL,NULL,'enabled',1);

--
-- Table structure for table `evo_pluginsettings`
--

CREATE TABLE `evo_pluginsettings` (
  `pset_plug_ID` int(11) unsigned NOT NULL,
  `pset_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `pset_value` text collate utf8_unicode_ci,
  PRIMARY KEY  (`pset_plug_ID`,`pset_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_pluginsettings`
--


--
-- Table structure for table `evo_pluginusersettings`
--

CREATE TABLE `evo_pluginusersettings` (
  `puset_plug_ID` int(11) unsigned NOT NULL,
  `puset_user_ID` int(11) unsigned NOT NULL,
  `puset_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `puset_value` text collate utf8_unicode_ci,
  PRIMARY KEY  (`puset_plug_ID`,`puset_user_ID`,`puset_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_pluginusersettings`
--

INSERT INTO `evo_pluginusersettings` VALUES (11,1,'use_tinymce_coll1','0'),(11,1,'use_tinymce','0'),(11,1,'tmce_options_contextmenu','1'),(11,1,'tmce_options_paste','1'),(11,1,'tmce_options_xhtmlxtras','0'),(11,1,'tmce_options_directionality','1'),(5,1,'use_toolbar','0'),(12,1,'twitter_username',''),(12,1,'twitter_password',''),(12,1,'twitter_msg_format','Just posted $title$ $url$ #b2p'),(11,1,'use_tinymce_coll3','1'),(11,1,'use_tinymce_coll2','0');

--
-- Table structure for table `evo_postcats`
--

CREATE TABLE `evo_postcats` (
  `postcat_post_ID` int(11) unsigned NOT NULL,
  `postcat_cat_ID` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`postcat_post_ID`,`postcat_cat_ID`),
  UNIQUE KEY `catpost` (`postcat_cat_ID`,`postcat_post_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_postcats`
--

INSERT INTO `evo_postcats` VALUES (2,1),(2,2),(3,14),(4,14),(5,14),(6,14),(7,14),(8,13),(9,13),(10,13),(11,12),(12,12),(13,12),(14,12),(15,10),(16,1),(17,1),(17,10),(17,12),(18,11),(19,11),(20,11),(21,10),(21,11),(22,10),(22,11),(23,11),(24,11),(25,11),(26,3),(27,3),(28,3),(29,3),(30,1),(31,12);

--
-- Table structure for table `evo_settings`
--

CREATE TABLE `evo_settings` (
  `set_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `set_value` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`set_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_settings`
--

INSERT INTO `evo_settings` VALUES ('auto_prune_stats_done','2010-09-30 11:12:13'),('db_version','9960'),('default_blog_ID','1'),('default_locale','en-US-utf8'),('evonet_last_version_checked','http://ruspan.com/blog// b2evo b2evolution 3.3.3 2009-12-15'),('evonet_last_attempt','1285863133'),('newusers_grp_ID','4'),('evonet_last_update','1285863133');

--
-- Table structure for table `evo_skins__container`
--

CREATE TABLE `evo_skins__container` (
  `sco_skin_ID` int(10) unsigned NOT NULL,
  `sco_name` varchar(40) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`sco_skin_ID`,`sco_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_skins__container`
--

INSERT INTO `evo_skins__container` VALUES (1,'Header'),(1,'Menu'),(1,'Page Top'),(1,'Sidebar'),(2,'Header'),(2,'Menu'),(2,'Page Top'),(2,'Sidebar'),(2,'Sidebar 2'),(3,'Header'),(3,'Menu'),(3,'Page Top'),(3,'Sidebar'),(4,'Menu'),(4,'Page Top'),(5,'Header'),(5,'Menu'),(5,'Page Top'),(5,'Sidebar'),(6,'Footer'),(6,'Header'),(6,'Menu'),(6,'Page Top'),(6,'Sidebar'),(7,'Header'),(7,'Menu'),(7,'Page Top'),(7,'Sidebar'),(7,'Sidebar 2'),(8,'Header'),(8,'Menu'),(8,'Page Top'),(8,'Sidebar'),(9,'Header'),(9,'Menu'),(9,'Page Top'),(9,'Sidebar'),(10,'Footer'),(10,'Header'),(10,'Menu'),(10,'Page Top'),(10,'Sidebar'),(11,'Footer'),(11,'Header'),(11,'Menu'),(11,'Page Top'),(11,'Sidebar'),(12,'Footer'),(12,'Header'),(12,'Menu'),(12,'Page Top'),(12,'Sidebar'),(18,'Page Top'),(19,'Footer'),(19,'Header'),(19,'Menu'),(19,'Page Top'),(19,'Sidebar'),(20,'Header'),(20,'Menu'),(20,'Page Top'),(20,'Sidebar');

--
-- Table structure for table `evo_skins__skin`
--

CREATE TABLE `evo_skins__skin` (
  `skin_ID` int(10) unsigned NOT NULL auto_increment,
  `skin_name` varchar(32) collate utf8_unicode_ci NOT NULL,
  `skin_type` enum('normal','feed') collate utf8_unicode_ci NOT NULL default 'normal',
  `skin_folder` varchar(32) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`skin_ID`),
  UNIQUE KEY `skin_folder` (`skin_folder`),
  KEY `skin_name` (`skin_name`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_skins__skin`
--

INSERT INTO `evo_skins__skin` VALUES (1,'evopress','normal','evopress'),(2,'evocamp','normal','evocamp'),(3,'miami_blue','normal','miami_blue'),(4,'photoblog','normal','photoblog'),(5,'asevo','normal','asevo'),(6,'Custom','normal','custom'),(7,'glossyblue','normal','glossyblue'),(8,'Natural Pink','normal','natural_pink'),(9,'nifty_corners','normal','nifty_corners'),(10,'pixelgreen','normal','pixelgreen'),(11,'terrafirma','normal','terrafirma'),(12,'vastitude','normal','vastitude'),(13,'Atom','feed','_atom'),(14,'RSS 2.0','feed','_rss2'),(18,'basic','normal','basic'),(19,'nifty_red','normal','nifty_red'),(20,'tsokolate','normal','tsokolate');

--
-- Table structure for table `evo_subscriptions`
--

CREATE TABLE `evo_subscriptions` (
  `sub_coll_ID` int(11) unsigned NOT NULL,
  `sub_user_ID` int(11) unsigned NOT NULL,
  `sub_items` tinyint(1) NOT NULL,
  `sub_comments` tinyint(1) NOT NULL,
  PRIMARY KEY  (`sub_coll_ID`,`sub_user_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_subscriptions`
--


--
-- Table structure for table `evo_track__goal`
--

CREATE TABLE `evo_track__goal` (
  `goal_ID` int(10) unsigned NOT NULL auto_increment,
  `goal_name` varchar(50) collate utf8_unicode_ci default NULL,
  `goal_key` varchar(32) collate utf8_unicode_ci default NULL,
  `goal_redir_url` varchar(255) collate utf8_unicode_ci default NULL,
  `goal_default_value` double default NULL,
  PRIMARY KEY  (`goal_ID`),
  UNIQUE KEY `goal_key` (`goal_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_track__goal`
--


--
-- Table structure for table `evo_track__goalhit`
--

CREATE TABLE `evo_track__goalhit` (
  `ghit_ID` int(10) unsigned NOT NULL auto_increment,
  `ghit_goal_ID` int(10) unsigned NOT NULL,
  `ghit_hit_ID` int(10) unsigned NOT NULL,
  `ghit_params` text collate utf8_unicode_ci,
  PRIMARY KEY  (`ghit_ID`),
  KEY `ghit_goal_ID` (`ghit_goal_ID`),
  KEY `ghit_hit_ID` (`ghit_hit_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_track__goalhit`
--


--
-- Table structure for table `evo_track__keyphrase`
--

CREATE TABLE `evo_track__keyphrase` (
  `keyp_ID` int(10) unsigned NOT NULL auto_increment,
  `keyp_phrase` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`keyp_ID`),
  UNIQUE KEY `keyp_phrase` (`keyp_phrase`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_track__keyphrase`
--

INSERT INTO `evo_track__keyphrase` VALUES (1,'russspa.com');

--
-- Table structure for table `evo_useragents`
--

CREATE TABLE `evo_useragents` (
  `agnt_ID` int(10) unsigned NOT NULL auto_increment,
  `agnt_signature` varchar(250) collate utf8_unicode_ci NOT NULL,
  `agnt_type` enum('rss','robot','browser','unknown') collate utf8_unicode_ci NOT NULL default 'unknown',
  PRIMARY KEY  (`agnt_ID`),
  KEY `agnt_type` (`agnt_type`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_useragents`
--

INSERT INTO `evo_useragents` VALUES (2,'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; FunWebProducts; .NET CLR 3.5.30729; InfoPath.2; .NET CLR 3.0.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3)','browser'),(3,'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729)','browser'),(4,'Opera/9.80 (Windows NT 6.0; U; en) Presto/2.2.15 Version/10.10','browser'),(5,'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 GTB6 (.NET CLR 3.5.30729)','browser'),(6,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','robot'),(7,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','rss'),(8,'BlogPulseLive (support@blogpulse.com)','unknown'),(9,'BlogPulseLive (support@blogpulse.com)','rss'),(10,'BlogPulse (ISSpider-3.0)','unknown'),(11,'BlogPulse (ISSpider-3.0)','rss'),(12,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.8) Gecko/20100202 Firefox/3.5.8','browser'),(13,'Moreoverbot/5.1 (+http://w.moreover.com; webmaster@moreover.com) Mozilla/5.0','unknown'),(14,'Moreoverbot/5.1 (+http://w.moreover.com; webmaster@moreover.com) Mozilla/5.0','rss'),(15,'radian6_default_(www.radian6.com/crawler)','unknown'),(16,'radian6_default_(www.radian6.com/crawler)','rss'),(17,'BlogSearch/1.0 +http://www.icerocket.com/','unknown'),(18,'Jakarta Commons-HttpClient/3.1','unknown'),(19,'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; FunWebProducts; .NET CLR 3.5.30729; InfoPath.2; .NET CLR 3.0.30729; OfficeLiveConnector.1.5; OfficeLivePatch.1.3; .NET4.0C)','browser'),(20,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.3','browser'),(21,'Jaxified RSS Check Bot (+http://www.jaxified.com/)','unknown'),(22,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.6) Gecko/20100628 Ubuntu/10.04 (lucid) Firefox/3.6.6','browser');

--
-- Table structure for table `evo_users__fielddefs`
--

CREATE TABLE `evo_users__fielddefs` (
  `ufdf_ID` int(10) unsigned NOT NULL,
  `ufdf_type` char(8) collate utf8_unicode_ci NOT NULL,
  `ufdf_name` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ufdf_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_users__fielddefs`
--

INSERT INTO `evo_users__fielddefs` VALUES (10000,'email','MSN/Live IM'),(10100,'word','Yahoo IM'),(10200,'word','AOL AIM'),(10300,'number','ICQ ID'),(40000,'phone','Skype'),(50000,'phone','Main phone'),(50100,'phone','Cell phone'),(50200,'phone','Office phone'),(50300,'phone','Home phone'),(60000,'phone','Office FAX'),(60100,'phone','Home FAX'),(100000,'url','Website'),(100100,'url','Blog'),(110000,'url','Linkedin'),(120000,'url','Twitter'),(130100,'url','Facebook'),(130200,'url','Myspace'),(140000,'url','Flickr'),(150000,'url','YouTube'),(160000,'url','Digg'),(160100,'url','StumbleUpon'),(200000,'text','Role'),(200100,'text','Organization'),(200200,'text','Division'),(211000,'text','VAT ID'),(300000,'text','Main address'),(300300,'text','Home address');

--
-- Table structure for table `evo_users__fields`
--

CREATE TABLE `evo_users__fields` (
  `uf_ID` int(10) unsigned NOT NULL auto_increment,
  `uf_user_ID` int(10) unsigned NOT NULL,
  `uf_ufdf_ID` int(10) unsigned NOT NULL,
  `uf_varchar` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`uf_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_users__fields`
--


--
-- Table structure for table `evo_usersettings`
--

CREATE TABLE `evo_usersettings` (
  `uset_user_ID` int(11) unsigned NOT NULL,
  `uset_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `uset_value` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`uset_user_ID`,`uset_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_usersettings`
--

INSERT INTO `evo_usersettings` VALUES (1,'selected_blog','1'),(1,'pref_browse_tab','list'),(1,'admin_skin','chicago'),(1,'login_multiple_sessions','1'),(1,'action_icon_threshold','3'),(1,'action_word_threshold','3'),(1,'display_icon_legend','0'),(1,'control_form_abortions','1'),(1,'focus_on_first_input','0'),(1,'results_per_page','20'),(1,'pref_edit_tab','expert');

--
-- Table structure for table `evo_widget`
--

CREATE TABLE `evo_widget` (
  `wi_ID` int(10) unsigned NOT NULL auto_increment,
  `wi_coll_ID` int(11) unsigned NOT NULL,
  `wi_sco_name` varchar(40) collate utf8_unicode_ci NOT NULL,
  `wi_order` int(10) NOT NULL,
  `wi_enabled` tinyint(1) NOT NULL default '1',
  `wi_type` enum('core','plugin') collate utf8_unicode_ci NOT NULL default 'core',
  `wi_code` varchar(32) collate utf8_unicode_ci NOT NULL,
  `wi_params` text collate utf8_unicode_ci,
  PRIMARY KEY  (`wi_ID`),
  UNIQUE KEY `wi_order` (`wi_coll_ID`,`wi_sco_name`,`wi_order`)
) ENGINE=MyISAM AUTO_INCREMENT=126 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `evo_widget`
--

INSERT INTO `evo_widget` VALUES (1,1,'Page Top',1,1,'core','colls_list_public',NULL),(2,2,'Page Top',1,1,'core','colls_list_public',NULL),(3,3,'Page Top',1,1,'core','colls_list_public',NULL),(4,4,'Page Top',1,1,'core','colls_list_public',NULL),(8,1,'Header',1,1,'core','coll_title',NULL),(9,2,'Header',1,1,'core','coll_title',NULL),(10,3,'Header',1,1,'core','coll_title',NULL),(11,4,'Header',1,1,'core','coll_title',NULL),(15,1,'Header',2,1,'core','coll_tagline',NULL),(16,2,'Header',2,1,'core','coll_tagline',NULL),(17,3,'Header',2,1,'core','coll_tagline',NULL),(18,4,'Header',2,1,'core','coll_tagline',NULL),(22,1,'Menu',1,1,'core','menu_link','a:1:{s:9:\"link_type\";s:4:\"home\";}'),(23,2,'Menu',1,1,'core','menu_link','a:1:{s:9:\"link_type\";s:4:\"home\";}'),(24,3,'Menu',1,1,'core','menu_link','a:1:{s:9:\"link_type\";s:4:\"home\";}'),(25,4,'Menu',1,1,'core','menu_link','a:1:{s:9:\"link_type\";s:4:\"home\";}'),(29,1,'Menu',2,1,'core','coll_page_list',NULL),(30,2,'Menu',2,1,'core','coll_page_list',NULL),(31,3,'Menu',2,1,'core','coll_page_list',NULL),(32,4,'Menu',2,1,'core','coll_page_list',NULL),(36,1,'Menu',3,1,'core','menu_link','a:1:{s:9:\"link_type\";s:12:\"ownercontact\";}'),(37,2,'Menu',3,1,'core','menu_link','a:1:{s:9:\"link_type\";s:12:\"ownercontact\";}'),(38,3,'Menu',3,1,'core','menu_link','a:1:{s:9:\"link_type\";s:12:\"ownercontact\";}'),(39,4,'Menu',3,1,'core','menu_link','a:1:{s:9:\"link_type\";s:12:\"ownercontact\";}'),(43,1,'Menu',4,1,'core','menu_link','a:1:{s:9:\"link_type\";s:5:\"login\";}'),(44,2,'Menu',4,1,'core','menu_link','a:1:{s:9:\"link_type\";s:5:\"login\";}'),(45,3,'Menu',4,1,'core','menu_link','a:1:{s:9:\"link_type\";s:5:\"login\";}'),(46,4,'Menu',4,1,'core','menu_link','a:1:{s:9:\"link_type\";s:5:\"login\";}'),(50,2,'Sidebar',1,1,'plugin','evo_Calr',NULL),(51,3,'Sidebar',1,1,'plugin','evo_Calr',NULL),(52,4,'Sidebar',1,1,'plugin','evo_Calr',NULL),(53,1,'Sidebar',2,1,'core','coll_title',NULL),(54,2,'Sidebar',2,1,'core','coll_title',NULL),(55,3,'Sidebar',2,1,'core','coll_title',NULL),(56,4,'Sidebar',2,1,'core','coll_title',NULL),(60,1,'Sidebar',3,1,'core','coll_longdesc',NULL),(61,2,'Sidebar',3,1,'core','coll_longdesc',NULL),(62,3,'Sidebar',3,1,'core','coll_longdesc',NULL),(63,4,'Sidebar',3,1,'core','coll_longdesc',NULL),(67,1,'Sidebar',4,1,'core','coll_common_links',NULL),(68,2,'Sidebar',4,1,'core','coll_common_links',NULL),(69,3,'Sidebar',4,1,'core','coll_common_links',NULL),(70,4,'Sidebar',4,1,'core','coll_common_links',NULL),(74,1,'Sidebar',5,1,'core','coll_search_form',NULL),(75,2,'Sidebar',5,1,'core','coll_search_form',NULL),(76,3,'Sidebar',5,1,'core','coll_search_form',NULL),(77,4,'Sidebar',5,1,'core','coll_search_form',NULL),(81,1,'Sidebar',6,1,'core','coll_category_list',NULL),(82,2,'Sidebar',6,1,'core','coll_category_list',NULL),(83,3,'Sidebar',6,1,'core','coll_category_list',NULL),(84,4,'Sidebar',6,1,'core','coll_category_list',NULL),(88,1,'Sidebar',7,1,'core','coll_media_index','a:11:{s:5:\"title\";s:12:\"Random photo\";s:10:\"thumb_size\";s:11:\"fit-160x120\";s:12:\"thumb_layout\";s:4:\"grid\";s:12:\"grid_nb_cols\";s:1:\"1\";s:5:\"limit\";s:1:\"1\";s:8:\"order_by\";s:4:\"RAND\";s:9:\"order_dir\";s:3:\"ASC\";s:7:\"blog_ID\";s:1:\"4\";s:11:\"widget_name\";s:12:\"Random photo\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(89,3,'Sidebar',7,1,'core','coll_media_index','a:11:{s:5:\"title\";s:12:\"Random photo\";s:10:\"thumb_size\";s:11:\"fit-160x120\";s:12:\"thumb_layout\";s:4:\"grid\";s:12:\"grid_nb_cols\";s:1:\"1\";s:5:\"limit\";s:1:\"1\";s:8:\"order_by\";s:4:\"RAND\";s:9:\"order_dir\";s:3:\"ASC\";s:7:\"blog_ID\";s:1:\"4\";s:11:\"widget_name\";s:12:\"Random photo\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(90,4,'Sidebar',7,1,'core','coll_media_index','a:11:{s:5:\"title\";s:12:\"Random photo\";s:10:\"thumb_size\";s:11:\"fit-160x120\";s:12:\"thumb_layout\";s:4:\"grid\";s:12:\"grid_nb_cols\";s:1:\"1\";s:5:\"limit\";s:1:\"1\";s:8:\"order_by\";s:4:\"RAND\";s:9:\"order_dir\";s:3:\"ASC\";s:7:\"blog_ID\";s:1:\"4\";s:11:\"widget_name\";s:12:\"Random photo\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(91,1,'Sidebar',8,1,'core','linkblog','a:1:{s:7:\"blog_ID\";i:3;}'),(92,2,'Sidebar',8,1,'core','linkblog','a:1:{s:7:\"blog_ID\";i:3;}'),(94,1,'Sidebar',9,1,'core','coll_xml_feeds',NULL),(95,2,'Sidebar',9,1,'core','coll_xml_feeds',NULL),(96,3,'Sidebar',9,1,'core','coll_xml_feeds',NULL),(97,4,'Sidebar',9,1,'core','coll_xml_feeds',NULL),(101,1,'Sidebar 2',1,1,'core','coll_post_list',NULL),(102,2,'Sidebar 2',1,1,'core','coll_post_list',NULL),(103,3,'Sidebar 2',1,1,'core','coll_post_list',NULL),(104,4,'Sidebar 2',1,1,'core','coll_post_list',NULL),(108,1,'Sidebar 2',2,1,'core','coll_comment_list',NULL),(109,2,'Sidebar 2',2,1,'core','coll_comment_list',NULL),(110,3,'Sidebar 2',2,1,'core','coll_comment_list',NULL),(111,4,'Sidebar 2',2,1,'core','coll_comment_list',NULL),(115,1,'Sidebar 2',3,1,'core','coll_media_index','a:11:{s:5:\"title\";s:13:\"Recent photos\";s:10:\"thumb_size\";s:10:\"crop-80x80\";s:12:\"thumb_layout\";s:4:\"grid\";s:12:\"grid_nb_cols\";s:1:\"3\";s:5:\"limit\";s:1:\"9\";s:8:\"order_by\";s:9:\"datestart\";s:9:\"order_dir\";s:4:\"DESC\";s:7:\"blog_ID\";s:1:\"4\";s:11:\"widget_name\";s:11:\"Photo index\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(116,2,'Sidebar 2',3,1,'core','coll_media_index','a:11:{s:5:\"title\";s:13:\"Recent photos\";s:10:\"thumb_size\";s:10:\"crop-80x80\";s:12:\"thumb_layout\";s:4:\"grid\";s:12:\"grid_nb_cols\";s:1:\"3\";s:5:\"limit\";s:1:\"9\";s:8:\"order_by\";s:9:\"datestart\";s:9:\"order_dir\";s:4:\"DESC\";s:7:\"blog_ID\";s:1:\"4\";s:11:\"widget_name\";s:11:\"Photo index\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(117,3,'Sidebar 2',3,1,'core','coll_media_index','a:11:{s:5:\"title\";s:13:\"Recent photos\";s:10:\"thumb_size\";s:10:\"crop-80x80\";s:12:\"thumb_layout\";s:4:\"grid\";s:12:\"grid_nb_cols\";s:1:\"3\";s:5:\"limit\";s:1:\"9\";s:8:\"order_by\";s:9:\"datestart\";s:9:\"order_dir\";s:4:\"DESC\";s:7:\"blog_ID\";s:1:\"4\";s:11:\"widget_name\";s:11:\"Photo index\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(118,4,'Sidebar 2',3,1,'core','coll_media_index','a:11:{s:5:\"title\";s:13:\"Recent photos\";s:10:\"thumb_size\";s:10:\"crop-80x80\";s:12:\"thumb_layout\";s:4:\"grid\";s:12:\"grid_nb_cols\";s:1:\"3\";s:5:\"limit\";s:1:\"9\";s:8:\"order_by\";s:9:\"datestart\";s:9:\"order_dir\";s:4:\"DESC\";s:7:\"blog_ID\";s:1:\"4\";s:11:\"widget_name\";s:11:\"Photo index\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(122,1,'Sidebar 2',4,1,'core','free_html','a:5:{s:5:\"title\";s:9:\"Sidebar 2\";s:7:\"content\";s:162:\"This is the \"Sidebar 2\" container. You can place any widget you like in here. In the evo toolbar at the top of this page, select \"Customize\", then \"Blog Widgets\".\";s:11:\"widget_name\";s:9:\"Free HTML\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(123,2,'Sidebar 2',4,1,'core','free_html','a:5:{s:5:\"title\";s:9:\"Sidebar 2\";s:7:\"content\";s:162:\"This is the \"Sidebar 2\" container. You can place any widget you like in here. In the evo toolbar at the top of this page, select \"Customize\", then \"Blog Widgets\".\";s:11:\"widget_name\";s:9:\"Free HTML\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(124,3,'Sidebar 2',4,1,'core','free_html','a:5:{s:5:\"title\";s:9:\"Sidebar 2\";s:7:\"content\";s:162:\"This is the \"Sidebar 2\" container. You can place any widget you like in here. In the evo toolbar at the top of this page, select \"Customize\", then \"Blog Widgets\".\";s:11:\"widget_name\";s:9:\"Free HTML\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}'),(125,4,'Sidebar 2',4,1,'core','free_html','a:5:{s:5:\"title\";s:9:\"Sidebar 2\";s:7:\"content\";s:162:\"This is the \"Sidebar 2\" container. You can place any widget you like in here. In the evo toolbar at the top of this page, select \"Customize\", then \"Blog Widgets\".\";s:11:\"widget_name\";s:9:\"Free HTML\";s:16:\"widget_css_class\";s:0:\"\";s:9:\"widget_ID\";s:0:\"\";}');


