text: -- MySQL dump 10.13  Distrib 5.5.32, for debian-linux-gnu (i686)
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `accounts`
  --
  
  DROP TABLE IF EXISTS `accounts`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `accounts` (
    `blog_id` bigint(20) NOT NULL DEFAULT '0',
    `subscription_type` enum('TRIAL','STARTER','BASIC','PRO','PREMIUM') NOT NULL DEFAULT 'TRIAL',
    `subscription_start` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
    `subscription_price` decimal(7,2) NOT NULL DEFAULT '0.00',
    `subscription_end` datetime DEFAULT NULL,
    `billing_id` varchar(16) DEFAULT NULL,
    `credit_card` char(4) DEFAULT NULL,
    `credit_card_exp` date DEFAULT NULL,
    PRIMARY KEY (`blog_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `announcements`
  --
  
  DROP TABLE IF EXISTS `announcements`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `announcements` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `publication_start` date NOT NULL DEFAULT '0000-00-00',
    `publication_end` date NOT NULL DEFAULT '0000-00-00',
    `html` varchar(255) NOT NULL DEFAULT '',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_blog_versions`
  --
  
  DROP TABLE IF EXISTS `wp_blog_versions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_blog_versions` (
    `blog_id` bigint(20) NOT NULL DEFAULT '0',
    `db_version` varchar(20) NOT NULL DEFAULT '',
    `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`blog_id`),
    KEY `db_version` (`db_version`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_blogs`
  --
  
  DROP TABLE IF EXISTS `wp_blogs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_blogs` (
    `blog_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `site_id` bigint(20) NOT NULL DEFAULT '0',
    `domain` varchar(200) NOT NULL DEFAULT '',
    `path` varchar(100) NOT NULL DEFAULT '',
    `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `public` tinyint(2) NOT NULL DEFAULT '1',
    `archived` enum('0','1') NOT NULL DEFAULT '0',
    `mature` tinyint(2) NOT NULL DEFAULT '0',
    `spam` tinyint(2) NOT NULL DEFAULT '0',
    `deleted` tinyint(2) NOT NULL DEFAULT '0',
    `lang_id` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`blog_id`),
    KEY `domain` (`domain`(50),`path`(5)),
    KEY `lang_id` (`lang_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_domain_mapping`
  --
  
  DROP TABLE IF EXISTS `wp_domain_mapping`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_domain_mapping` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `blog_id` bigint(20) NOT NULL DEFAULT '0',
    `domain` varchar(255) NOT NULL DEFAULT '',
    `active` tinyint(4) DEFAULT '1',
    PRIMARY KEY (`id`),
    KEY `blog_id` (`blog_id`,`domain`,`active`)
  ) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_domain_mapping_logins`
  --
  
  DROP TABLE IF EXISTS `wp_domain_mapping_logins`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_domain_mapping_logins` (
    `id` varchar(32) NOT NULL DEFAULT '',
    `user_id` bigint(20) NOT NULL DEFAULT '0',
    `blog_id` bigint(20) NOT NULL DEFAULT '0',
    `t` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_registration_log`
  --
  
  DROP TABLE IF EXISTS `wp_registration_log`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_registration_log` (
    `ID` bigint(20) NOT NULL AUTO_INCREMENT,
    `email` varchar(255) NOT NULL DEFAULT '',
    `IP` varchar(30) NOT NULL DEFAULT '',
    `blog_id` bigint(20) NOT NULL DEFAULT '0',
    `date_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`ID`),
    KEY `IP` (`IP`)
  ) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_signups`
  --
  
  DROP TABLE IF EXISTS `wp_signups`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_signups` (
    `domain` varchar(200) NOT NULL DEFAULT '',
    `path` varchar(100) NOT NULL DEFAULT '',
    `title` longtext NOT NULL,
    `user_login` varchar(60) NOT NULL DEFAULT '',
    `user_email` varchar(100) NOT NULL DEFAULT '',
    `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `activated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `active` tinyint(1) NOT NULL DEFAULT '0',
    `activation_key` varchar(50) NOT NULL DEFAULT '',
    `meta` longtext,
    KEY `activation_key` (`activation_key`),
    KEY `domain` (`domain`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_site`
  --
  
  DROP TABLE IF EXISTS `wp_site`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_site` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `domain` varchar(200) NOT NULL DEFAULT '',
    `path` varchar(100) NOT NULL DEFAULT '',
    PRIMARY KEY (`id`),
    KEY `domain` (`domain`,`path`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_sitecategories`
  --
  
  DROP TABLE IF EXISTS `wp_sitecategories`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_sitecategories` (
    `cat_ID` bigint(20) NOT NULL AUTO_INCREMENT,
    `cat_name` varchar(55) NOT NULL DEFAULT '',
    `category_nicename` varchar(200) NOT NULL DEFAULT '',
    `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`cat_ID`),
    KEY `category_nicename` (`category_nicename`),
    KEY `last_updated` (`last_updated`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4997 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_sitemeta`
  --
  
  DROP TABLE IF EXISTS `wp_sitemeta`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_sitemeta` (
    `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `site_id` bigint(20) NOT NULL DEFAULT '0',
    `meta_key` varchar(255) DEFAULT NULL,
    `meta_value` longtext,
    PRIMARY KEY (`meta_id`),
    KEY `meta_key` (`meta_key`),
    KEY `site_id` (`site_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=20499 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_usermeta`
  --
  
  DROP TABLE IF EXISTS `wp_usermeta`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_usermeta` (
    `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
    `meta_key` varchar(255) DEFAULT NULL,
    `meta_value` longtext,
    PRIMARY KEY (`umeta_id`),
    KEY `user_id` (`user_id`),
    KEY `meta_key` (`meta_key`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2503 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `wp_users`
  --
  
  DROP TABLE IF EXISTS `wp_users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `wp_users` (
    `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_login` varchar(60) NOT NULL DEFAULT '',
    `user_pass` varchar(64) NOT NULL DEFAULT '',
    `user_nicename` varchar(50) NOT NULL DEFAULT '',
    `user_email` varchar(100) NOT NULL DEFAULT '',
    `user_url` varchar(100) NOT NULL DEFAULT '',
    `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `user_activation_key` varchar(60) NOT NULL DEFAULT '',
    `user_status` int(11) NOT NULL DEFAULT '0',
    `display_name` varchar(250) NOT NULL DEFAULT '',
    `spam` tinyint(2) NOT NULL DEFAULT '0',
    `deleted` tinyint(2) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`),
    KEY `user_login_key` (`user_login`),
    KEY `user_nicename` (`user_nicename`)
  ) ENGINE=MyISAM AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  