-- MySQL dump 10.13 Distrib 5.6.25-73.1, for osx10.10 (x86_64) -- -- Host: localhost Database: ee.213 -- ------------------------------------------------------ -- Server version 5.6.25-73.1 /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 `exp_accessories` -- DROP TABLE IF EXISTS `exp_accessories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_accessories` ( `accessory_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `class` varchar(75) NOT NULL DEFAULT '', `member_groups` varchar(50) NOT NULL DEFAULT 'all', `controllers` text, `accessory_version` varchar(12) NOT NULL, PRIMARY KEY (`accessory_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_accessories` -- LOCK TABLES `exp_accessories` WRITE; /*!40000 ALTER TABLE `exp_accessories` DISABLE KEYS */; INSERT INTO `exp_accessories` VALUES (1,'Expressionengine_info_acc','1|5','addons|addons_accessories|addons_extensions|addons_fieldtypes|addons_modules|addons_plugins|admin_content|admin_system|content|content_edit|content_files|content_publish|design|homepage|members|myaccount|tools|tools_communicate|tools_data|tools_logs|tools_utilities','1.0'); /*!40000 ALTER TABLE `exp_accessories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_actions` -- DROP TABLE IF EXISTS `exp_actions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_actions` ( `action_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `class` varchar(50) NOT NULL, `method` varchar(50) NOT NULL, PRIMARY KEY (`action_id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_actions` -- LOCK TABLES `exp_actions` WRITE; /*!40000 ALTER TABLE `exp_actions` DISABLE KEYS */; INSERT INTO `exp_actions` VALUES (1,'Comment','insert_new_comment'),(2,'Comment_mcp','delete_comment_notification'),(3,'Comment','comment_subscribe'),(4,'Comment','edit_comment'),(5,'Email','send_email'),(6,'Mailinglist','insert_new_email'),(7,'Mailinglist','authorize_email'),(8,'Mailinglist','unsubscribe'),(9,'Search','do_search'),(10,'Channel','insert_new_entry'),(11,'Channel','filemanager_endpoint'),(12,'Channel','smiley_pop'),(13,'Member','registration_form'),(14,'Member','register_member'),(15,'Member','activate_member'),(16,'Member','member_login'),(17,'Member','member_logout'),(18,'Member','retrieve_password'),(19,'Member','reset_password'),(20,'Member','send_member_email'),(21,'Member','update_un_pw'),(22,'Member','member_search'),(23,'Member','member_delete'); /*!40000 ALTER TABLE `exp_actions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_captcha` -- DROP TABLE IF EXISTS `exp_captcha`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_captcha` ( `captcha_id` bigint(13) unsigned NOT NULL AUTO_INCREMENT, `date` int(10) unsigned NOT NULL, `ip_address` varchar(16) NOT NULL DEFAULT '0', `word` varchar(20) NOT NULL, PRIMARY KEY (`captcha_id`), KEY `word` (`word`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_captcha` -- LOCK TABLES `exp_captcha` WRITE; /*!40000 ALTER TABLE `exp_captcha` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_captcha` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_categories` -- DROP TABLE IF EXISTS `exp_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_categories` ( `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_id` int(6) unsigned NOT NULL, `parent_id` int(4) unsigned NOT NULL, `cat_name` varchar(100) NOT NULL, `cat_url_title` varchar(75) NOT NULL, `cat_description` text, `cat_image` varchar(120) DEFAULT NULL, `cat_order` int(4) unsigned NOT NULL, PRIMARY KEY (`cat_id`), KEY `group_id` (`group_id`), KEY `cat_name` (`cat_name`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_categories` -- LOCK TABLES `exp_categories` WRITE; /*!40000 ALTER TABLE `exp_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_category_field_data` -- DROP TABLE IF EXISTS `exp_category_field_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_category_field_data` ( `cat_id` int(4) unsigned NOT NULL, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_id` int(4) unsigned NOT NULL, PRIMARY KEY (`cat_id`), KEY `site_id` (`site_id`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_category_field_data` -- LOCK TABLES `exp_category_field_data` WRITE; /*!40000 ALTER TABLE `exp_category_field_data` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_category_field_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_category_fields` -- DROP TABLE IF EXISTS `exp_category_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_category_fields` ( `field_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_id` int(4) unsigned NOT NULL, `field_name` varchar(32) NOT NULL DEFAULT '', `field_label` varchar(50) NOT NULL DEFAULT '', `field_type` varchar(12) NOT NULL DEFAULT 'text', `field_list_items` text NOT NULL, `field_maxl` smallint(3) NOT NULL DEFAULT '128', `field_ta_rows` tinyint(2) NOT NULL DEFAULT '8', `field_default_fmt` varchar(40) NOT NULL DEFAULT 'none', `field_show_fmt` char(1) NOT NULL DEFAULT 'y', `field_text_direction` char(3) NOT NULL DEFAULT 'ltr', `field_required` char(1) NOT NULL DEFAULT 'n', `field_order` int(3) unsigned NOT NULL, PRIMARY KEY (`field_id`), KEY `site_id` (`site_id`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_category_fields` -- LOCK TABLES `exp_category_fields` WRITE; /*!40000 ALTER TABLE `exp_category_fields` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_category_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_category_groups` -- DROP TABLE IF EXISTS `exp_category_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_category_groups` ( `group_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_name` varchar(50) NOT NULL, `sort_order` char(1) NOT NULL DEFAULT 'a', `field_html_formatting` char(4) NOT NULL DEFAULT 'all', `can_edit_categories` text, `can_delete_categories` text, PRIMARY KEY (`group_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_category_groups` -- LOCK TABLES `exp_category_groups` WRITE; /*!40000 ALTER TABLE `exp_category_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_category_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_category_posts` -- DROP TABLE IF EXISTS `exp_category_posts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_category_posts` ( `entry_id` int(10) unsigned NOT NULL, `cat_id` int(10) unsigned NOT NULL, PRIMARY KEY (`entry_id`,`cat_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_category_posts` -- LOCK TABLES `exp_category_posts` WRITE; /*!40000 ALTER TABLE `exp_category_posts` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_category_posts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_channel_data` -- DROP TABLE IF EXISTS `exp_channel_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_channel_data` ( `entry_id` int(10) unsigned NOT NULL, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `channel_id` int(4) unsigned NOT NULL, PRIMARY KEY (`entry_id`), KEY `channel_id` (`channel_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_channel_data` -- LOCK TABLES `exp_channel_data` WRITE; /*!40000 ALTER TABLE `exp_channel_data` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_channel_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_channel_entries_autosave` -- DROP TABLE IF EXISTS `exp_channel_entries_autosave`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_channel_entries_autosave` ( `entry_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `original_entry_id` int(10) unsigned NOT NULL, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `channel_id` int(4) unsigned NOT NULL, `author_id` int(10) unsigned NOT NULL DEFAULT '0', `pentry_id` int(10) NOT NULL DEFAULT '0', `forum_topic_id` int(10) unsigned DEFAULT NULL, `ip_address` varchar(16) NOT NULL, `title` varchar(100) NOT NULL, `url_title` varchar(75) NOT NULL, `status` varchar(50) NOT NULL, `versioning_enabled` char(1) NOT NULL DEFAULT 'n', `view_count_one` int(10) unsigned NOT NULL DEFAULT '0', `view_count_two` int(10) unsigned NOT NULL DEFAULT '0', `view_count_three` int(10) unsigned NOT NULL DEFAULT '0', `view_count_four` int(10) unsigned NOT NULL DEFAULT '0', `allow_comments` varchar(1) NOT NULL DEFAULT 'y', `sticky` varchar(1) NOT NULL DEFAULT 'n', `entry_date` int(10) NOT NULL, `dst_enabled` varchar(1) NOT NULL DEFAULT 'n', `year` char(4) NOT NULL, `month` char(2) NOT NULL, `day` char(3) NOT NULL, `expiration_date` int(10) NOT NULL DEFAULT '0', `comment_expiration_date` int(10) NOT NULL DEFAULT '0', `edit_date` bigint(14) DEFAULT NULL, `recent_comment_date` int(10) DEFAULT NULL, `comment_total` int(4) unsigned NOT NULL DEFAULT '0', `entry_data` text, PRIMARY KEY (`entry_id`), KEY `channel_id` (`channel_id`), KEY `author_id` (`author_id`), KEY `url_title` (`url_title`), KEY `status` (`status`), KEY `entry_date` (`entry_date`), KEY `expiration_date` (`expiration_date`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_channel_entries_autosave` -- LOCK TABLES `exp_channel_entries_autosave` WRITE; /*!40000 ALTER TABLE `exp_channel_entries_autosave` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_channel_entries_autosave` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_channel_fields` -- DROP TABLE IF EXISTS `exp_channel_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_channel_fields` ( `field_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_id` int(4) unsigned NOT NULL, `field_name` varchar(32) NOT NULL, `field_label` varchar(50) NOT NULL, `field_instructions` text, `field_type` varchar(50) NOT NULL DEFAULT 'text', `field_list_items` text NOT NULL, `field_pre_populate` char(1) NOT NULL DEFAULT 'n', `field_pre_channel_id` int(6) unsigned DEFAULT NULL, `field_pre_field_id` int(6) unsigned DEFAULT NULL, `field_related_to` varchar(12) NOT NULL DEFAULT 'channel', `field_related_id` int(6) unsigned NOT NULL DEFAULT '0', `field_related_orderby` varchar(12) NOT NULL DEFAULT 'date', `field_related_sort` varchar(4) NOT NULL DEFAULT 'desc', `field_related_max` smallint(4) NOT NULL DEFAULT '0', `field_ta_rows` tinyint(2) DEFAULT '8', `field_maxl` smallint(3) DEFAULT NULL, `field_required` char(1) NOT NULL DEFAULT 'n', `field_text_direction` char(3) NOT NULL DEFAULT 'ltr', `field_search` char(1) NOT NULL DEFAULT 'n', `field_is_hidden` char(1) NOT NULL DEFAULT 'n', `field_fmt` varchar(40) NOT NULL DEFAULT 'xhtml', `field_show_fmt` char(1) NOT NULL DEFAULT 'y', `field_order` int(3) unsigned NOT NULL, `field_content_type` varchar(20) NOT NULL DEFAULT 'any', `field_settings` text, PRIMARY KEY (`field_id`), KEY `group_id` (`group_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_channel_fields` -- LOCK TABLES `exp_channel_fields` WRITE; /*!40000 ALTER TABLE `exp_channel_fields` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_channel_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_channel_member_groups` -- DROP TABLE IF EXISTS `exp_channel_member_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_channel_member_groups` ( `group_id` smallint(4) unsigned NOT NULL, `channel_id` int(6) unsigned NOT NULL, PRIMARY KEY (`group_id`,`channel_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_channel_member_groups` -- LOCK TABLES `exp_channel_member_groups` WRITE; /*!40000 ALTER TABLE `exp_channel_member_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_channel_member_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_channel_titles` -- DROP TABLE IF EXISTS `exp_channel_titles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_channel_titles` ( `entry_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `channel_id` int(4) unsigned NOT NULL, `author_id` int(10) unsigned NOT NULL DEFAULT '0', `pentry_id` int(10) NOT NULL DEFAULT '0', `forum_topic_id` int(10) unsigned DEFAULT NULL, `ip_address` varchar(16) NOT NULL, `title` varchar(100) NOT NULL, `url_title` varchar(75) NOT NULL, `status` varchar(50) NOT NULL, `versioning_enabled` char(1) NOT NULL DEFAULT 'n', `view_count_one` int(10) unsigned NOT NULL DEFAULT '0', `view_count_two` int(10) unsigned NOT NULL DEFAULT '0', `view_count_three` int(10) unsigned NOT NULL DEFAULT '0', `view_count_four` int(10) unsigned NOT NULL DEFAULT '0', `allow_comments` varchar(1) NOT NULL DEFAULT 'y', `sticky` varchar(1) NOT NULL DEFAULT 'n', `entry_date` int(10) NOT NULL, `dst_enabled` varchar(1) NOT NULL DEFAULT 'n', `year` char(4) NOT NULL, `month` char(2) NOT NULL, `day` char(3) NOT NULL, `expiration_date` int(10) NOT NULL DEFAULT '0', `comment_expiration_date` int(10) NOT NULL DEFAULT '0', `edit_date` bigint(14) DEFAULT NULL, `recent_comment_date` int(10) DEFAULT NULL, `comment_total` int(4) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry_id`), KEY `channel_id` (`channel_id`), KEY `author_id` (`author_id`), KEY `url_title` (`url_title`), KEY `status` (`status`), KEY `entry_date` (`entry_date`), KEY `expiration_date` (`expiration_date`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_channel_titles` -- LOCK TABLES `exp_channel_titles` WRITE; /*!40000 ALTER TABLE `exp_channel_titles` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_channel_titles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_channels` -- DROP TABLE IF EXISTS `exp_channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_channels` ( `channel_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `channel_name` varchar(40) NOT NULL, `channel_title` varchar(100) NOT NULL, `channel_url` varchar(100) NOT NULL, `channel_description` varchar(225) DEFAULT NULL, `channel_lang` varchar(12) NOT NULL, `total_entries` mediumint(8) NOT NULL DEFAULT '0', `total_comments` mediumint(8) NOT NULL DEFAULT '0', `last_entry_date` int(10) unsigned NOT NULL DEFAULT '0', `last_comment_date` int(10) unsigned NOT NULL DEFAULT '0', `cat_group` varchar(255) DEFAULT NULL, `status_group` int(4) unsigned DEFAULT NULL, `deft_status` varchar(50) NOT NULL DEFAULT 'open', `field_group` int(4) unsigned DEFAULT NULL, `search_excerpt` int(4) unsigned DEFAULT NULL, `deft_category` varchar(60) DEFAULT NULL, `deft_comments` char(1) NOT NULL DEFAULT 'y', `channel_require_membership` char(1) NOT NULL DEFAULT 'y', `channel_max_chars` int(5) unsigned DEFAULT NULL, `channel_html_formatting` char(4) NOT NULL DEFAULT 'all', `channel_allow_img_urls` char(1) NOT NULL DEFAULT 'y', `channel_auto_link_urls` char(1) NOT NULL DEFAULT 'y', `channel_notify` char(1) NOT NULL DEFAULT 'n', `channel_notify_emails` varchar(255) DEFAULT NULL, `comment_url` varchar(80) DEFAULT NULL, `comment_system_enabled` char(1) NOT NULL DEFAULT 'y', `comment_require_membership` char(1) NOT NULL DEFAULT 'n', `comment_use_captcha` char(1) NOT NULL DEFAULT 'n', `comment_moderate` char(1) NOT NULL DEFAULT 'n', `comment_max_chars` int(5) unsigned DEFAULT '5000', `comment_timelock` int(5) unsigned NOT NULL DEFAULT '0', `comment_require_email` char(1) NOT NULL DEFAULT 'y', `comment_text_formatting` char(5) NOT NULL DEFAULT 'xhtml', `comment_html_formatting` char(4) NOT NULL DEFAULT 'safe', `comment_allow_img_urls` char(1) NOT NULL DEFAULT 'n', `comment_auto_link_urls` char(1) NOT NULL DEFAULT 'y', `comment_notify` char(1) NOT NULL DEFAULT 'n', `comment_notify_authors` char(1) NOT NULL DEFAULT 'n', `comment_notify_emails` varchar(255) DEFAULT NULL, `comment_expiration` int(4) unsigned NOT NULL DEFAULT '0', `search_results_url` varchar(80) DEFAULT NULL, `ping_return_url` varchar(80) DEFAULT NULL, `show_button_cluster` char(1) NOT NULL DEFAULT 'y', `rss_url` varchar(80) DEFAULT NULL, `enable_versioning` char(1) NOT NULL DEFAULT 'n', `max_revisions` smallint(4) unsigned NOT NULL DEFAULT '10', `default_entry_title` varchar(100) DEFAULT NULL, `url_title_prefix` varchar(80) DEFAULT NULL, `live_look_template` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`channel_id`), KEY `cat_group` (`cat_group`), KEY `status_group` (`status_group`), KEY `field_group` (`field_group`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_channels` -- LOCK TABLES `exp_channels` WRITE; /*!40000 ALTER TABLE `exp_channels` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_channels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_comment_subscriptions` -- DROP TABLE IF EXISTS `exp_comment_subscriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_comment_subscriptions` ( `subscription_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `entry_id` int(10) unsigned DEFAULT NULL, `member_id` int(10) DEFAULT '0', `email` varchar(50) DEFAULT NULL, `subscription_date` varchar(10) DEFAULT NULL, `notification_sent` char(1) DEFAULT 'n', `hash` varchar(15) DEFAULT NULL, PRIMARY KEY (`subscription_id`), KEY `entry_id` (`entry_id`), KEY `member_id` (`member_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_comment_subscriptions` -- LOCK TABLES `exp_comment_subscriptions` WRITE; /*!40000 ALTER TABLE `exp_comment_subscriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_comment_subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_comments` -- DROP TABLE IF EXISTS `exp_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_comments` ( `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) DEFAULT '1', `entry_id` int(10) unsigned DEFAULT '0', `channel_id` int(4) unsigned DEFAULT '1', `author_id` int(10) unsigned DEFAULT '0', `status` char(1) DEFAULT '0', `name` varchar(50) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `url` varchar(75) DEFAULT NULL, `location` varchar(50) DEFAULT NULL, `ip_address` varchar(16) DEFAULT NULL, `comment_date` int(10) DEFAULT NULL, `edit_date` int(10) DEFAULT NULL, `comment` text, PRIMARY KEY (`comment_id`), KEY `entry_id` (`entry_id`), KEY `channel_id` (`channel_id`), KEY `author_id` (`author_id`), KEY `status` (`status`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_comments` -- LOCK TABLES `exp_comments` WRITE; /*!40000 ALTER TABLE `exp_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_cp_log` -- DROP TABLE IF EXISTS `exp_cp_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_cp_log` ( `id` int(10) NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `member_id` int(10) unsigned NOT NULL, `username` varchar(32) NOT NULL, `ip_address` varchar(16) NOT NULL DEFAULT '0', `act_date` int(10) NOT NULL, `action` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_cp_log` -- LOCK TABLES `exp_cp_log` WRITE; /*!40000 ALTER TABLE `exp_cp_log` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_cp_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_cp_search_index` -- DROP TABLE IF EXISTS `exp_cp_search_index`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_cp_search_index` ( `search_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `controller` varchar(20) DEFAULT NULL, `method` varchar(50) DEFAULT NULL, `language` varchar(20) DEFAULT NULL, `access` varchar(50) DEFAULT NULL, `keywords` text, PRIMARY KEY (`search_id`), FULLTEXT KEY `keywords` (`keywords`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_cp_search_index` -- LOCK TABLES `exp_cp_search_index` WRITE; /*!40000 ALTER TABLE `exp_cp_search_index` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_cp_search_index` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_email_cache` -- DROP TABLE IF EXISTS `exp_email_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_email_cache` ( `cache_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `cache_date` int(10) unsigned NOT NULL DEFAULT '0', `total_sent` int(6) unsigned NOT NULL, `from_name` varchar(70) NOT NULL, `from_email` varchar(70) NOT NULL, `recipient` text NOT NULL, `cc` text NOT NULL, `bcc` text NOT NULL, `recipient_array` mediumtext NOT NULL, `subject` varchar(120) NOT NULL, `message` mediumtext NOT NULL, `plaintext_alt` mediumtext NOT NULL, `mailinglist` char(1) NOT NULL DEFAULT 'n', `mailtype` varchar(6) NOT NULL, `text_fmt` varchar(40) NOT NULL, `wordwrap` char(1) NOT NULL DEFAULT 'y', `priority` char(1) NOT NULL DEFAULT '3', PRIMARY KEY (`cache_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_email_cache` -- LOCK TABLES `exp_email_cache` WRITE; /*!40000 ALTER TABLE `exp_email_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_email_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_email_cache_mg` -- DROP TABLE IF EXISTS `exp_email_cache_mg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_email_cache_mg` ( `cache_id` int(6) unsigned NOT NULL, `group_id` smallint(4) NOT NULL, PRIMARY KEY (`cache_id`,`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_email_cache_mg` -- LOCK TABLES `exp_email_cache_mg` WRITE; /*!40000 ALTER TABLE `exp_email_cache_mg` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_email_cache_mg` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_email_cache_ml` -- DROP TABLE IF EXISTS `exp_email_cache_ml`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_email_cache_ml` ( `cache_id` int(6) unsigned NOT NULL, `list_id` smallint(4) NOT NULL, PRIMARY KEY (`cache_id`,`list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_email_cache_ml` -- LOCK TABLES `exp_email_cache_ml` WRITE; /*!40000 ALTER TABLE `exp_email_cache_ml` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_email_cache_ml` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_email_console_cache` -- DROP TABLE IF EXISTS `exp_email_console_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_email_console_cache` ( `cache_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `cache_date` int(10) unsigned NOT NULL DEFAULT '0', `member_id` int(10) unsigned NOT NULL, `member_name` varchar(50) NOT NULL, `ip_address` varchar(16) NOT NULL DEFAULT '0', `recipient` varchar(70) NOT NULL, `recipient_name` varchar(50) NOT NULL, `subject` varchar(120) NOT NULL, `message` mediumtext NOT NULL, PRIMARY KEY (`cache_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_email_console_cache` -- LOCK TABLES `exp_email_console_cache` WRITE; /*!40000 ALTER TABLE `exp_email_console_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_email_console_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_email_tracker` -- DROP TABLE IF EXISTS `exp_email_tracker`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_email_tracker` ( `email_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email_date` int(10) unsigned NOT NULL DEFAULT '0', `sender_ip` varchar(16) NOT NULL, `sender_email` varchar(75) NOT NULL, `sender_username` varchar(50) NOT NULL, `number_recipients` int(4) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`email_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_email_tracker` -- LOCK TABLES `exp_email_tracker` WRITE; /*!40000 ALTER TABLE `exp_email_tracker` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_email_tracker` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_entry_ping_status` -- DROP TABLE IF EXISTS `exp_entry_ping_status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_entry_ping_status` ( `entry_id` int(10) unsigned NOT NULL, `ping_id` int(10) unsigned NOT NULL, PRIMARY KEY (`entry_id`,`ping_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_entry_ping_status` -- LOCK TABLES `exp_entry_ping_status` WRITE; /*!40000 ALTER TABLE `exp_entry_ping_status` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_entry_ping_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_entry_versioning` -- DROP TABLE IF EXISTS `exp_entry_versioning`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_entry_versioning` ( `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `entry_id` int(10) unsigned NOT NULL, `channel_id` int(4) unsigned NOT NULL, `author_id` int(10) unsigned NOT NULL, `version_date` int(10) NOT NULL, `version_data` mediumtext NOT NULL, PRIMARY KEY (`version_id`), KEY `entry_id` (`entry_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_entry_versioning` -- LOCK TABLES `exp_entry_versioning` WRITE; /*!40000 ALTER TABLE `exp_entry_versioning` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_entry_versioning` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_extensions` -- DROP TABLE IF EXISTS `exp_extensions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_extensions` ( `extension_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `class` varchar(50) NOT NULL DEFAULT '', `method` varchar(50) NOT NULL DEFAULT '', `hook` varchar(50) NOT NULL DEFAULT '', `settings` text NOT NULL, `priority` int(2) NOT NULL DEFAULT '10', `version` varchar(10) NOT NULL DEFAULT '', `enabled` char(1) NOT NULL DEFAULT 'y', PRIMARY KEY (`extension_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_extensions` -- LOCK TABLES `exp_extensions` WRITE; /*!40000 ALTER TABLE `exp_extensions` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_extensions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_field_formatting` -- DROP TABLE IF EXISTS `exp_field_formatting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_field_formatting` ( `formatting_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(10) unsigned NOT NULL, `field_fmt` varchar(40) NOT NULL, PRIMARY KEY (`formatting_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_field_formatting` -- LOCK TABLES `exp_field_formatting` WRITE; /*!40000 ALTER TABLE `exp_field_formatting` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_field_formatting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_field_groups` -- DROP TABLE IF EXISTS `exp_field_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_field_groups` ( `group_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_name` varchar(50) NOT NULL, PRIMARY KEY (`group_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_field_groups` -- LOCK TABLES `exp_field_groups` WRITE; /*!40000 ALTER TABLE `exp_field_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_field_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_fieldtypes` -- DROP TABLE IF EXISTS `exp_fieldtypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_fieldtypes` ( `fieldtype_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `version` varchar(12) NOT NULL, `settings` text, `has_global_settings` char(1) DEFAULT 'n', PRIMARY KEY (`fieldtype_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_fieldtypes` -- LOCK TABLES `exp_fieldtypes` WRITE; /*!40000 ALTER TABLE `exp_fieldtypes` DISABLE KEYS */; INSERT INTO `exp_fieldtypes` VALUES (1,'select','1.0','YTowOnt9','n'),(2,'text','1.0','YTowOnt9','n'),(3,'textarea','1.0','YTowOnt9','n'),(4,'date','1.0','YTowOnt9','n'),(5,'file','1.0','YTowOnt9','n'),(6,'multi_select','1.0','YTowOnt9','n'),(7,'checkboxes','1.0','YTowOnt9','n'),(8,'radio','1.0','YTowOnt9','n'),(9,'rel','1.0','YTowOnt9','n'); /*!40000 ALTER TABLE `exp_fieldtypes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_global_variables` -- DROP TABLE IF EXISTS `exp_global_variables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_global_variables` ( `variable_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `variable_name` varchar(50) NOT NULL, `variable_data` text NOT NULL, PRIMARY KEY (`variable_id`), KEY `variable_name` (`variable_name`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_global_variables` -- LOCK TABLES `exp_global_variables` WRITE; /*!40000 ALTER TABLE `exp_global_variables` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_global_variables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_html_buttons` -- DROP TABLE IF EXISTS `exp_html_buttons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_html_buttons` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `member_id` int(10) NOT NULL DEFAULT '0', `tag_name` varchar(32) NOT NULL, `tag_open` varchar(120) NOT NULL, `tag_close` varchar(120) NOT NULL, `accesskey` varchar(32) NOT NULL, `tag_order` int(3) unsigned NOT NULL, `tag_row` char(1) NOT NULL DEFAULT '1', `classname` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_html_buttons` -- LOCK TABLES `exp_html_buttons` WRITE; /*!40000 ALTER TABLE `exp_html_buttons` DISABLE KEYS */; INSERT INTO `exp_html_buttons` VALUES (1,1,0,'b','','','b',1,'1','btn_b'),(2,1,0,'i','','','i',2,'1','btn_i'),(3,1,0,'blockquote','
','
','q',3,'1','btn_blockquote'),(4,1,0,'a','','','a',4,'1','btn_a'),(5,1,0,'img','\"[![Alternative','','',5,'1','btn_img'); /*!40000 ALTER TABLE `exp_html_buttons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_layout_publish` -- DROP TABLE IF EXISTS `exp_layout_publish`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_layout_publish` ( `layout_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `member_group` int(4) unsigned NOT NULL DEFAULT '0', `channel_id` int(4) unsigned NOT NULL DEFAULT '0', `field_layout` text, PRIMARY KEY (`layout_id`), KEY `site_id` (`site_id`), KEY `member_group` (`member_group`), KEY `channel_id` (`channel_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_layout_publish` -- LOCK TABLES `exp_layout_publish` WRITE; /*!40000 ALTER TABLE `exp_layout_publish` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_layout_publish` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_mailing_list` -- DROP TABLE IF EXISTS `exp_mailing_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_mailing_list` ( `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `list_id` int(7) unsigned NOT NULL, `authcode` varchar(10) NOT NULL, `email` varchar(50) NOT NULL, `ip_address` varchar(16) NOT NULL, PRIMARY KEY (`user_id`), KEY `list_id` (`list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_mailing_list` -- LOCK TABLES `exp_mailing_list` WRITE; /*!40000 ALTER TABLE `exp_mailing_list` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_mailing_list` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_mailing_list_queue` -- DROP TABLE IF EXISTS `exp_mailing_list_queue`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_mailing_list_queue` ( `queue_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(50) NOT NULL, `list_id` int(7) unsigned NOT NULL DEFAULT '0', `authcode` varchar(10) NOT NULL, `date` int(10) NOT NULL, PRIMARY KEY (`queue_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_mailing_list_queue` -- LOCK TABLES `exp_mailing_list_queue` WRITE; /*!40000 ALTER TABLE `exp_mailing_list_queue` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_mailing_list_queue` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_mailing_lists` -- DROP TABLE IF EXISTS `exp_mailing_lists`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_mailing_lists` ( `list_id` int(7) unsigned NOT NULL AUTO_INCREMENT, `list_name` varchar(40) NOT NULL, `list_title` varchar(100) NOT NULL, `list_template` text NOT NULL, PRIMARY KEY (`list_id`), KEY `list_name` (`list_name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_mailing_lists` -- LOCK TABLES `exp_mailing_lists` WRITE; /*!40000 ALTER TABLE `exp_mailing_lists` DISABLE KEYS */; INSERT INTO `exp_mailing_lists` VALUES (1,'default','Default Mailing List','{message_text}\n\nTo remove your email from this mailing list, click here:\n{if html_email}{unsubscribe_url}{/if}\n{if plain_email}{unsubscribe_url}{/if}'); /*!40000 ALTER TABLE `exp_mailing_lists` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_member_bulletin_board` -- DROP TABLE IF EXISTS `exp_member_bulletin_board`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_member_bulletin_board` ( `bulletin_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender_id` int(10) unsigned NOT NULL, `bulletin_group` int(8) unsigned NOT NULL, `bulletin_date` int(10) unsigned NOT NULL, `hash` varchar(10) NOT NULL DEFAULT '', `bulletin_expires` int(10) unsigned NOT NULL DEFAULT '0', `bulletin_message` text NOT NULL, PRIMARY KEY (`bulletin_id`), KEY `sender_id` (`sender_id`), KEY `hash` (`hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_member_bulletin_board` -- LOCK TABLES `exp_member_bulletin_board` WRITE; /*!40000 ALTER TABLE `exp_member_bulletin_board` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_member_bulletin_board` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_member_data` -- DROP TABLE IF EXISTS `exp_member_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_member_data` ( `member_id` int(10) unsigned NOT NULL, PRIMARY KEY (`member_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_member_data` -- LOCK TABLES `exp_member_data` WRITE; /*!40000 ALTER TABLE `exp_member_data` DISABLE KEYS */; INSERT INTO `exp_member_data` VALUES (1); /*!40000 ALTER TABLE `exp_member_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_member_fields` -- DROP TABLE IF EXISTS `exp_member_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_member_fields` ( `m_field_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `m_field_name` varchar(32) NOT NULL, `m_field_label` varchar(50) NOT NULL, `m_field_description` text NOT NULL, `m_field_type` varchar(12) NOT NULL DEFAULT 'text', `m_field_list_items` text NOT NULL, `m_field_ta_rows` tinyint(2) DEFAULT '8', `m_field_maxl` smallint(3) NOT NULL, `m_field_width` varchar(6) NOT NULL, `m_field_search` char(1) NOT NULL DEFAULT 'y', `m_field_required` char(1) NOT NULL DEFAULT 'n', `m_field_public` char(1) NOT NULL DEFAULT 'y', `m_field_reg` char(1) NOT NULL DEFAULT 'n', `m_field_cp_reg` char(1) NOT NULL DEFAULT 'n', `m_field_fmt` char(5) NOT NULL DEFAULT 'none', `m_field_order` int(3) unsigned NOT NULL, PRIMARY KEY (`m_field_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_member_fields` -- LOCK TABLES `exp_member_fields` WRITE; /*!40000 ALTER TABLE `exp_member_fields` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_member_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_member_groups` -- DROP TABLE IF EXISTS `exp_member_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_member_groups` ( `group_id` smallint(4) unsigned NOT NULL, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_title` varchar(100) NOT NULL, `group_description` text NOT NULL, `is_locked` char(1) NOT NULL DEFAULT 'y', `can_view_offline_system` char(1) NOT NULL DEFAULT 'n', `can_view_online_system` char(1) NOT NULL DEFAULT 'y', `can_access_cp` char(1) NOT NULL DEFAULT 'y', `can_access_content` char(1) NOT NULL DEFAULT 'n', `can_access_publish` char(1) NOT NULL DEFAULT 'n', `can_access_edit` char(1) NOT NULL DEFAULT 'n', `can_access_files` char(1) NOT NULL DEFAULT 'n', `can_access_design` char(1) NOT NULL DEFAULT 'n', `can_access_addons` char(1) NOT NULL DEFAULT 'n', `can_access_modules` char(1) NOT NULL DEFAULT 'n', `can_access_extensions` char(1) NOT NULL DEFAULT 'n', `can_access_accessories` char(1) NOT NULL DEFAULT 'n', `can_access_plugins` char(1) NOT NULL DEFAULT 'n', `can_access_members` char(1) NOT NULL DEFAULT 'n', `can_access_admin` char(1) NOT NULL DEFAULT 'n', `can_access_sys_prefs` char(1) NOT NULL DEFAULT 'n', `can_access_content_prefs` char(1) NOT NULL DEFAULT 'n', `can_access_tools` char(1) NOT NULL DEFAULT 'n', `can_access_comm` char(1) NOT NULL DEFAULT 'n', `can_access_utilities` char(1) NOT NULL DEFAULT 'n', `can_access_data` char(1) NOT NULL DEFAULT 'n', `can_access_logs` char(1) NOT NULL DEFAULT 'n', `can_admin_channels` char(1) NOT NULL DEFAULT 'n', `can_admin_design` char(1) NOT NULL DEFAULT 'n', `can_admin_members` char(1) NOT NULL DEFAULT 'n', `can_delete_members` char(1) NOT NULL DEFAULT 'n', `can_admin_mbr_groups` char(1) NOT NULL DEFAULT 'n', `can_admin_mbr_templates` char(1) NOT NULL DEFAULT 'n', `can_ban_users` char(1) NOT NULL DEFAULT 'n', `can_admin_modules` char(1) NOT NULL DEFAULT 'n', `can_admin_templates` char(1) NOT NULL DEFAULT 'n', `can_admin_accessories` char(1) NOT NULL DEFAULT 'n', `can_edit_categories` char(1) NOT NULL DEFAULT 'n', `can_delete_categories` char(1) NOT NULL DEFAULT 'n', `can_view_other_entries` char(1) NOT NULL DEFAULT 'n', `can_edit_other_entries` char(1) NOT NULL DEFAULT 'n', `can_assign_post_authors` char(1) NOT NULL DEFAULT 'n', `can_delete_self_entries` char(1) NOT NULL DEFAULT 'n', `can_delete_all_entries` char(1) NOT NULL DEFAULT 'n', `can_view_other_comments` char(1) NOT NULL DEFAULT 'n', `can_edit_own_comments` char(1) NOT NULL DEFAULT 'n', `can_delete_own_comments` char(1) NOT NULL DEFAULT 'n', `can_edit_all_comments` char(1) NOT NULL DEFAULT 'n', `can_delete_all_comments` char(1) NOT NULL DEFAULT 'n', `can_moderate_comments` char(1) NOT NULL DEFAULT 'n', `can_send_email` char(1) NOT NULL DEFAULT 'n', `can_send_cached_email` char(1) NOT NULL DEFAULT 'n', `can_email_member_groups` char(1) NOT NULL DEFAULT 'n', `can_email_mailinglist` char(1) NOT NULL DEFAULT 'n', `can_email_from_profile` char(1) NOT NULL DEFAULT 'n', `can_view_profiles` char(1) NOT NULL DEFAULT 'n', `can_edit_html_buttons` char(1) NOT NULL DEFAULT 'n', `can_delete_self` char(1) NOT NULL DEFAULT 'n', `mbr_delete_notify_emails` varchar(255) DEFAULT NULL, `can_post_comments` char(1) NOT NULL DEFAULT 'n', `exclude_from_moderation` char(1) NOT NULL DEFAULT 'n', `can_search` char(1) NOT NULL DEFAULT 'n', `search_flood_control` mediumint(5) unsigned NOT NULL, `can_send_private_messages` char(1) NOT NULL DEFAULT 'n', `prv_msg_send_limit` smallint(5) unsigned NOT NULL DEFAULT '20', `prv_msg_storage_limit` smallint(5) unsigned NOT NULL DEFAULT '60', `can_attach_in_private_messages` char(1) NOT NULL DEFAULT 'n', `can_send_bulletins` char(1) NOT NULL DEFAULT 'n', `include_in_authorlist` char(1) NOT NULL DEFAULT 'n', `include_in_memberlist` char(1) NOT NULL DEFAULT 'y', `include_in_mailinglists` char(1) NOT NULL DEFAULT 'y', PRIMARY KEY (`group_id`,`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_member_groups` -- LOCK TABLES `exp_member_groups` WRITE; /*!40000 ALTER TABLE `exp_member_groups` DISABLE KEYS */; INSERT INTO `exp_member_groups` VALUES (1,1,'Super Admins','','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','','y','y','y',0,'y',20,60,'y','y','y','y','y'),(2,1,'Banned','','y','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','','n','n','n',60,'n',20,60,'n','n','n','n','n'),(3,1,'Guests','','y','n','y','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','y','n','n','','y','n','y',15,'n',20,60,'n','n','n','n','n'),(4,1,'Pending','','y','n','y','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','y','n','n','','y','n','y',15,'n',20,60,'n','n','n','n','n'),(5,1,'Members','','y','n','y','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','y','y','y','n','','y','n','y',10,'y',20,60,'y','n','n','y','y'); /*!40000 ALTER TABLE `exp_member_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_member_homepage` -- DROP TABLE IF EXISTS `exp_member_homepage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_member_homepage` ( `member_id` int(10) unsigned NOT NULL, `recent_entries` char(1) NOT NULL DEFAULT 'l', `recent_entries_order` int(3) unsigned NOT NULL DEFAULT '0', `recent_comments` char(1) NOT NULL DEFAULT 'l', `recent_comments_order` int(3) unsigned NOT NULL DEFAULT '0', `recent_members` char(1) NOT NULL DEFAULT 'n', `recent_members_order` int(3) unsigned NOT NULL DEFAULT '0', `site_statistics` char(1) NOT NULL DEFAULT 'r', `site_statistics_order` int(3) unsigned NOT NULL DEFAULT '0', `member_search_form` char(1) NOT NULL DEFAULT 'n', `member_search_form_order` int(3) unsigned NOT NULL DEFAULT '0', `notepad` char(1) NOT NULL DEFAULT 'r', `notepad_order` int(3) unsigned NOT NULL DEFAULT '0', `bulletin_board` char(1) NOT NULL DEFAULT 'r', `bulletin_board_order` int(3) unsigned NOT NULL DEFAULT '0', `pmachine_news_feed` char(1) NOT NULL DEFAULT 'n', `pmachine_news_feed_order` int(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`member_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_member_homepage` -- LOCK TABLES `exp_member_homepage` WRITE; /*!40000 ALTER TABLE `exp_member_homepage` DISABLE KEYS */; INSERT INTO `exp_member_homepage` VALUES (1,'l',1,'l',2,'n',0,'r',1,'n',0,'r',2,'r',0,'l',0); /*!40000 ALTER TABLE `exp_member_homepage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_member_search` -- DROP TABLE IF EXISTS `exp_member_search`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_member_search` ( `search_id` varchar(32) NOT NULL, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `search_date` int(10) unsigned NOT NULL, `keywords` varchar(200) NOT NULL, `fields` varchar(200) NOT NULL, `member_id` int(10) unsigned NOT NULL, `ip_address` varchar(16) NOT NULL, `total_results` int(8) unsigned NOT NULL, `query` text NOT NULL, PRIMARY KEY (`search_id`), KEY `member_id` (`member_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_member_search` -- LOCK TABLES `exp_member_search` WRITE; /*!40000 ALTER TABLE `exp_member_search` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_member_search` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_members` -- DROP TABLE IF EXISTS `exp_members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_members` ( `member_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `group_id` smallint(4) NOT NULL DEFAULT '0', `username` varchar(50) NOT NULL, `screen_name` varchar(50) NOT NULL, `password` varchar(40) NOT NULL, `unique_id` varchar(40) NOT NULL, `crypt_key` varchar(40) DEFAULT NULL, `authcode` varchar(10) DEFAULT NULL, `email` varchar(72) NOT NULL, `url` varchar(150) DEFAULT NULL, `location` varchar(50) DEFAULT NULL, `occupation` varchar(80) DEFAULT NULL, `interests` varchar(120) DEFAULT NULL, `bday_d` int(2) DEFAULT NULL, `bday_m` int(2) DEFAULT NULL, `bday_y` int(4) DEFAULT NULL, `aol_im` varchar(50) DEFAULT NULL, `yahoo_im` varchar(50) DEFAULT NULL, `msn_im` varchar(50) DEFAULT NULL, `icq` varchar(50) DEFAULT NULL, `bio` text, `signature` text, `avatar_filename` varchar(120) DEFAULT NULL, `avatar_width` int(4) unsigned DEFAULT NULL, `avatar_height` int(4) unsigned DEFAULT NULL, `photo_filename` varchar(120) DEFAULT NULL, `photo_width` int(4) unsigned DEFAULT NULL, `photo_height` int(4) unsigned DEFAULT NULL, `sig_img_filename` varchar(120) DEFAULT NULL, `sig_img_width` int(4) unsigned DEFAULT NULL, `sig_img_height` int(4) unsigned DEFAULT NULL, `ignore_list` text, `private_messages` int(4) unsigned NOT NULL DEFAULT '0', `accept_messages` char(1) NOT NULL DEFAULT 'y', `last_view_bulletins` int(10) NOT NULL DEFAULT '0', `last_bulletin_date` int(10) NOT NULL DEFAULT '0', `ip_address` varchar(16) NOT NULL DEFAULT '0', `join_date` int(10) unsigned NOT NULL DEFAULT '0', `last_visit` int(10) unsigned NOT NULL DEFAULT '0', `last_activity` int(10) unsigned NOT NULL DEFAULT '0', `total_entries` smallint(5) unsigned NOT NULL DEFAULT '0', `total_comments` smallint(5) unsigned NOT NULL DEFAULT '0', `total_forum_topics` mediumint(8) NOT NULL DEFAULT '0', `total_forum_posts` mediumint(8) NOT NULL DEFAULT '0', `last_entry_date` int(10) unsigned NOT NULL DEFAULT '0', `last_comment_date` int(10) unsigned NOT NULL DEFAULT '0', `last_forum_post_date` int(10) unsigned NOT NULL DEFAULT '0', `last_email_date` int(10) unsigned NOT NULL DEFAULT '0', `in_authorlist` char(1) NOT NULL DEFAULT 'n', `accept_admin_email` char(1) NOT NULL DEFAULT 'y', `accept_user_email` char(1) NOT NULL DEFAULT 'y', `notify_by_default` char(1) NOT NULL DEFAULT 'y', `notify_of_pm` char(1) NOT NULL DEFAULT 'y', `display_avatars` char(1) NOT NULL DEFAULT 'y', `display_signatures` char(1) NOT NULL DEFAULT 'y', `parse_smileys` char(1) NOT NULL DEFAULT 'y', `smart_notifications` char(1) NOT NULL DEFAULT 'y', `language` varchar(50) NOT NULL, `timezone` varchar(8) NOT NULL, `daylight_savings` char(1) NOT NULL DEFAULT 'n', `localization_is_site_default` char(1) NOT NULL DEFAULT 'n', `time_format` char(2) NOT NULL DEFAULT 'us', `cp_theme` varchar(32) DEFAULT NULL, `profile_theme` varchar(32) DEFAULT NULL, `forum_theme` varchar(32) DEFAULT NULL, `tracker` text, `template_size` varchar(2) NOT NULL DEFAULT '20', `notepad` text, `notepad_size` varchar(2) NOT NULL DEFAULT '18', `quick_links` text, `quick_tabs` text, `show_sidebar` char(1) NOT NULL DEFAULT 'y', `pmember_id` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`member_id`), KEY `group_id` (`group_id`), KEY `unique_id` (`unique_id`), KEY `password` (`password`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_members` -- LOCK TABLES `exp_members` WRITE; /*!40000 ALTER TABLE `exp_members` DISABLE KEYS */; INSERT INTO `exp_members` VALUES (1,1,'admin','EllisLab Team','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8','9597f0fbb98cb3e171ebc01864d8984448dd39f8',NULL,NULL,'team@ellislab.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'y',0,0,'0.0.0.0',1439207346,1439207346,0,1,0,0,0,1439207346,0,0,0,'n','y','y','y','y','y','y','y','y','english','UM5','n','n','us',NULL,NULL,NULL,NULL,'20',NULL,'18','',NULL,'y',0); /*!40000 ALTER TABLE `exp_members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_message_attachments` -- DROP TABLE IF EXISTS `exp_message_attachments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_message_attachments` ( `attachment_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender_id` int(10) unsigned NOT NULL DEFAULT '0', `message_id` int(10) unsigned NOT NULL DEFAULT '0', `attachment_name` varchar(50) NOT NULL DEFAULT '', `attachment_hash` varchar(40) NOT NULL DEFAULT '', `attachment_extension` varchar(20) NOT NULL DEFAULT '', `attachment_location` varchar(150) NOT NULL DEFAULT '', `attachment_date` int(10) unsigned NOT NULL DEFAULT '0', `attachment_size` int(10) unsigned NOT NULL DEFAULT '0', `is_temp` char(1) NOT NULL DEFAULT 'y', PRIMARY KEY (`attachment_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_message_attachments` -- LOCK TABLES `exp_message_attachments` WRITE; /*!40000 ALTER TABLE `exp_message_attachments` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_message_attachments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_message_copies` -- DROP TABLE IF EXISTS `exp_message_copies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_message_copies` ( `copy_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `message_id` int(10) unsigned NOT NULL DEFAULT '0', `sender_id` int(10) unsigned NOT NULL DEFAULT '0', `recipient_id` int(10) unsigned NOT NULL DEFAULT '0', `message_received` char(1) NOT NULL DEFAULT 'n', `message_read` char(1) NOT NULL DEFAULT 'n', `message_time_read` int(10) unsigned NOT NULL DEFAULT '0', `attachment_downloaded` char(1) NOT NULL DEFAULT 'n', `message_folder` int(10) unsigned NOT NULL DEFAULT '1', `message_authcode` varchar(10) NOT NULL DEFAULT '', `message_deleted` char(1) NOT NULL DEFAULT 'n', `message_status` varchar(10) NOT NULL DEFAULT '', PRIMARY KEY (`copy_id`), KEY `message_id` (`message_id`), KEY `recipient_id` (`recipient_id`), KEY `sender_id` (`sender_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_message_copies` -- LOCK TABLES `exp_message_copies` WRITE; /*!40000 ALTER TABLE `exp_message_copies` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_message_copies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_message_data` -- DROP TABLE IF EXISTS `exp_message_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_message_data` ( `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `sender_id` int(10) unsigned NOT NULL DEFAULT '0', `message_date` int(10) unsigned NOT NULL DEFAULT '0', `message_subject` varchar(255) NOT NULL DEFAULT '', `message_body` text NOT NULL, `message_tracking` char(1) NOT NULL DEFAULT 'y', `message_attachments` char(1) NOT NULL DEFAULT 'n', `message_recipients` varchar(200) NOT NULL DEFAULT '', `message_cc` varchar(200) NOT NULL DEFAULT '', `message_hide_cc` char(1) NOT NULL DEFAULT 'n', `message_sent_copy` char(1) NOT NULL DEFAULT 'n', `total_recipients` int(5) unsigned NOT NULL DEFAULT '0', `message_status` varchar(25) NOT NULL DEFAULT '', PRIMARY KEY (`message_id`), KEY `sender_id` (`sender_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_message_data` -- LOCK TABLES `exp_message_data` WRITE; /*!40000 ALTER TABLE `exp_message_data` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_message_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_message_folders` -- DROP TABLE IF EXISTS `exp_message_folders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_message_folders` ( `member_id` int(10) unsigned NOT NULL DEFAULT '0', `folder1_name` varchar(50) NOT NULL DEFAULT 'InBox', `folder2_name` varchar(50) NOT NULL DEFAULT 'Sent', `folder3_name` varchar(50) NOT NULL DEFAULT '', `folder4_name` varchar(50) NOT NULL DEFAULT '', `folder5_name` varchar(50) NOT NULL DEFAULT '', `folder6_name` varchar(50) NOT NULL DEFAULT '', `folder7_name` varchar(50) NOT NULL DEFAULT '', `folder8_name` varchar(50) NOT NULL DEFAULT '', `folder9_name` varchar(50) NOT NULL DEFAULT '', `folder10_name` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`member_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_message_folders` -- LOCK TABLES `exp_message_folders` WRITE; /*!40000 ALTER TABLE `exp_message_folders` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_message_folders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_message_listed` -- DROP TABLE IF EXISTS `exp_message_listed`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_message_listed` ( `listed_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(10) unsigned NOT NULL DEFAULT '0', `listed_member` int(10) unsigned NOT NULL DEFAULT '0', `listed_description` varchar(100) NOT NULL DEFAULT '', `listed_type` varchar(10) NOT NULL DEFAULT 'blocked', PRIMARY KEY (`listed_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_message_listed` -- LOCK TABLES `exp_message_listed` WRITE; /*!40000 ALTER TABLE `exp_message_listed` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_message_listed` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_module_member_groups` -- DROP TABLE IF EXISTS `exp_module_member_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_module_member_groups` ( `group_id` smallint(4) unsigned NOT NULL, `module_id` mediumint(5) unsigned NOT NULL, PRIMARY KEY (`group_id`,`module_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_module_member_groups` -- LOCK TABLES `exp_module_member_groups` WRITE; /*!40000 ALTER TABLE `exp_module_member_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_module_member_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_modules` -- DROP TABLE IF EXISTS `exp_modules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_modules` ( `module_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `module_name` varchar(50) NOT NULL, `module_version` varchar(12) NOT NULL, `has_cp_backend` char(1) NOT NULL DEFAULT 'n', `has_publish_fields` char(1) NOT NULL DEFAULT 'n', PRIMARY KEY (`module_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_modules` -- LOCK TABLES `exp_modules` WRITE; /*!40000 ALTER TABLE `exp_modules` DISABLE KEYS */; INSERT INTO `exp_modules` VALUES (1,'Comment','2.1','y','n'),(2,'Email','2.0','n','n'),(3,'Emoticon','2.0','n','n'),(4,'Jquery','1.0','n','n'),(5,'Mailinglist','3.0','y','n'),(6,'Rss','2.0','n','n'),(7,'Search','2.0','n','n'),(8,'Channel','2.0.1','n','n'),(9,'Member','2.0','n','n'),(10,'Stats','2.0','n','n'); /*!40000 ALTER TABLE `exp_modules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_online_users` -- DROP TABLE IF EXISTS `exp_online_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_online_users` ( `online_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `member_id` int(10) NOT NULL DEFAULT '0', `in_forum` char(1) NOT NULL DEFAULT 'n', `name` varchar(50) NOT NULL DEFAULT '0', `ip_address` varchar(16) NOT NULL DEFAULT '0', `date` int(10) unsigned NOT NULL DEFAULT '0', `anon` char(1) NOT NULL, PRIMARY KEY (`online_id`), KEY `date` (`date`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_online_users` -- LOCK TABLES `exp_online_users` WRITE; /*!40000 ALTER TABLE `exp_online_users` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_online_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_password_lockout` -- DROP TABLE IF EXISTS `exp_password_lockout`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_password_lockout` ( `lockout_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `login_date` int(10) unsigned NOT NULL, `ip_address` varchar(16) NOT NULL DEFAULT '0', `user_agent` varchar(50) NOT NULL, `username` varchar(50) NOT NULL, PRIMARY KEY (`lockout_id`), KEY `login_date` (`login_date`), KEY `ip_address` (`ip_address`), KEY `user_agent` (`user_agent`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_password_lockout` -- LOCK TABLES `exp_password_lockout` WRITE; /*!40000 ALTER TABLE `exp_password_lockout` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_password_lockout` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_ping_servers` -- DROP TABLE IF EXISTS `exp_ping_servers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_ping_servers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `member_id` int(10) NOT NULL DEFAULT '0', `server_name` varchar(32) NOT NULL, `server_url` varchar(150) NOT NULL, `port` varchar(4) NOT NULL DEFAULT '80', `ping_protocol` varchar(12) NOT NULL DEFAULT 'xmlrpc', `is_default` char(1) NOT NULL DEFAULT 'y', `server_order` int(3) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_ping_servers` -- LOCK TABLES `exp_ping_servers` WRITE; /*!40000 ALTER TABLE `exp_ping_servers` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_ping_servers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_relationships` -- DROP TABLE IF EXISTS `exp_relationships`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_relationships` ( `rel_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `rel_parent_id` int(10) NOT NULL DEFAULT '0', `rel_child_id` int(10) NOT NULL DEFAULT '0', `rel_type` varchar(12) NOT NULL, `rel_data` mediumtext NOT NULL, `reverse_rel_data` mediumtext NOT NULL, PRIMARY KEY (`rel_id`), KEY `rel_parent_id` (`rel_parent_id`), KEY `rel_child_id` (`rel_child_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_relationships` -- LOCK TABLES `exp_relationships` WRITE; /*!40000 ALTER TABLE `exp_relationships` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_relationships` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_reset_password` -- DROP TABLE IF EXISTS `exp_reset_password`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_reset_password` ( `reset_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(10) unsigned NOT NULL, `resetcode` varchar(12) NOT NULL, `date` int(10) NOT NULL, PRIMARY KEY (`reset_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_reset_password` -- LOCK TABLES `exp_reset_password` WRITE; /*!40000 ALTER TABLE `exp_reset_password` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_reset_password` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_revision_tracker` -- DROP TABLE IF EXISTS `exp_revision_tracker`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_revision_tracker` ( `tracker_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `item_id` int(10) unsigned NOT NULL, `item_table` varchar(20) NOT NULL, `item_field` varchar(20) NOT NULL, `item_date` int(10) NOT NULL, `item_author_id` int(10) unsigned NOT NULL, `item_data` mediumtext NOT NULL, PRIMARY KEY (`tracker_id`), KEY `item_id` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_revision_tracker` -- LOCK TABLES `exp_revision_tracker` WRITE; /*!40000 ALTER TABLE `exp_revision_tracker` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_revision_tracker` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_search` -- DROP TABLE IF EXISTS `exp_search`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_search` ( `search_id` varchar(32) NOT NULL, `site_id` int(4) NOT NULL DEFAULT '1', `search_date` int(10) NOT NULL, `keywords` varchar(60) NOT NULL, `member_id` int(10) unsigned NOT NULL, `ip_address` varchar(16) NOT NULL, `total_results` int(6) NOT NULL, `per_page` tinyint(3) unsigned NOT NULL, `query` mediumtext, `custom_fields` mediumtext, `result_page` varchar(70) NOT NULL, PRIMARY KEY (`search_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_search` -- LOCK TABLES `exp_search` WRITE; /*!40000 ALTER TABLE `exp_search` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_search` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_search_log` -- DROP TABLE IF EXISTS `exp_search_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_search_log` ( `id` int(10) NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `member_id` int(10) unsigned NOT NULL, `screen_name` varchar(50) NOT NULL, `ip_address` varchar(16) NOT NULL DEFAULT '0', `search_date` int(10) NOT NULL, `search_type` varchar(32) NOT NULL, `search_terms` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_search_log` -- LOCK TABLES `exp_search_log` WRITE; /*!40000 ALTER TABLE `exp_search_log` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_search_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_security_hashes` -- DROP TABLE IF EXISTS `exp_security_hashes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_security_hashes` ( `hash_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `date` int(10) unsigned NOT NULL, `ip_address` varchar(16) NOT NULL DEFAULT '0', `hash` varchar(40) NOT NULL, PRIMARY KEY (`hash_id`), KEY `hash` (`hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_security_hashes` -- LOCK TABLES `exp_security_hashes` WRITE; /*!40000 ALTER TABLE `exp_security_hashes` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_security_hashes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_sessions` -- DROP TABLE IF EXISTS `exp_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_sessions` ( `session_id` varchar(40) NOT NULL DEFAULT '0', `site_id` int(4) unsigned NOT NULL DEFAULT '1', `member_id` int(10) NOT NULL DEFAULT '0', `admin_sess` tinyint(1) NOT NULL DEFAULT '0', `ip_address` varchar(16) NOT NULL DEFAULT '0', `user_agent` varchar(50) NOT NULL, `last_activity` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`session_id`), KEY `member_id` (`member_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_sessions` -- LOCK TABLES `exp_sessions` WRITE; /*!40000 ALTER TABLE `exp_sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_sites` -- DROP TABLE IF EXISTS `exp_sites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_sites` ( `site_id` int(5) unsigned NOT NULL AUTO_INCREMENT, `site_label` varchar(100) NOT NULL DEFAULT '', `site_name` varchar(50) NOT NULL DEFAULT '', `site_description` text, `site_system_preferences` text NOT NULL, `site_mailinglist_preferences` text NOT NULL, `site_member_preferences` text NOT NULL, `site_template_preferences` text NOT NULL, `site_channel_preferences` text NOT NULL, `site_bootstrap_checksums` text NOT NULL, PRIMARY KEY (`site_id`), KEY `site_name` (`site_name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_sites` -- LOCK TABLES `exp_sites` WRITE; /*!40000 ALTER TABLE `exp_sites` DISABLE KEYS */; INSERT INTO `exp_sites` VALUES (1,'ExpressionEngine 2.1.3','default_site',NULL,'YTo5MTp7czoxMDoic2l0ZV9pbmRleCI7czo5OiJpbmRleC5waHAiO3M6ODoic2l0ZV91cmwiO3M6MTA6Imh0dHA6Ly9lZS8iO3M6MTY6InRoZW1lX2ZvbGRlcl91cmwiO3M6MTc6Imh0dHA6Ly9lZS90aGVtZXMvIjtzOjE1OiJ3ZWJtYXN0ZXJfZW1haWwiO3M6MTc6InRlYW1AZWxsaXNsYWIuY29tIjtzOjE0OiJ3ZWJtYXN0ZXJfbmFtZSI7czowOiIiO3M6MjA6ImNoYW5uZWxfbm9tZW5jbGF0dXJlIjtzOjc6ImNoYW5uZWwiO3M6MTA6Im1heF9jYWNoZXMiO3M6MzoiMTUwIjtzOjExOiJjYXB0Y2hhX3VybCI7czoyNjoiaHR0cDovL2VlL2ltYWdlcy9jYXB0Y2hhcy8iO3M6MTI6ImNhcHRjaGFfcGF0aCI7czoyODoiL3Zhci93d3cvZWUvaW1hZ2VzL2NhcHRjaGFzLyI7czoxMjoiY2FwdGNoYV9mb250IjtzOjE6InkiO3M6MTI6ImNhcHRjaGFfcmFuZCI7czoxOiJ5IjtzOjIzOiJjYXB0Y2hhX3JlcXVpcmVfbWVtYmVycyI7czoxOiJuIjtzOjE3OiJlbmFibGVfZGJfY2FjaGluZyI7czoxOiJuIjtzOjE4OiJlbmFibGVfc3FsX2NhY2hpbmciO3M6MToibiI7czoxODoiZm9yY2VfcXVlcnlfc3RyaW5nIjtzOjE6Im4iO3M6MTM6InNob3dfcHJvZmlsZXIiO3M6MToibiI7czoxODoidGVtcGxhdGVfZGVidWdnaW5nIjtzOjE6Im4iO3M6MTU6ImluY2x1ZGVfc2Vjb25kcyI7czoxOiJuIjtzOjEzOiJjb29raWVfZG9tYWluIjtzOjA6IiI7czoxMToiY29va2llX3BhdGgiO3M6MDoiIjtzOjE3OiJ1c2VyX3Nlc3Npb25fdHlwZSI7czoxOiJjIjtzOjE4OiJhZG1pbl9zZXNzaW9uX3R5cGUiO3M6MjoiY3MiO3M6MjE6ImFsbG93X3VzZXJuYW1lX2NoYW5nZSI7czoxOiJ5IjtzOjE4OiJhbGxvd19tdWx0aV9sb2dpbnMiO3M6MToieSI7czoxNjoicGFzc3dvcmRfbG9ja291dCI7czoxOiJ5IjtzOjI1OiJwYXNzd29yZF9sb2Nrb3V0X2ludGVydmFsIjtzOjE6IjEiO3M6MjA6InJlcXVpcmVfaXBfZm9yX2xvZ2luIjtzOjE6InkiO3M6MjI6InJlcXVpcmVfaXBfZm9yX3Bvc3RpbmciO3M6MToieSI7czoyNDoicmVxdWlyZV9zZWN1cmVfcGFzc3dvcmRzIjtzOjE6Im4iO3M6MTk6ImFsbG93X2RpY3Rpb25hcnlfcHciO3M6MToieSI7czoyMzoibmFtZV9vZl9kaWN0aW9uYXJ5X2ZpbGUiO3M6MDoiIjtzOjE3OiJ4c3NfY2xlYW5fdXBsb2FkcyI7czoxOiJ5IjtzOjE1OiJyZWRpcmVjdF9tZXRob2QiO3M6ODoicmVkaXJlY3QiO3M6OToiZGVmdF9sYW5nIjtzOjc6ImVuZ2xpc2giO3M6ODoieG1sX2xhbmciO3M6MjoiZW4iO3M6MTI6InNlbmRfaGVhZGVycyI7czoxOiJ5IjtzOjExOiJnemlwX291dHB1dCI7czoxOiJuIjtzOjEzOiJsb2dfcmVmZXJyZXJzIjtzOjE6Im4iO3M6MTM6Im1heF9yZWZlcnJlcnMiO3M6MzoiNTAwIjtzOjExOiJ0aW1lX2Zvcm1hdCI7czoyOiJ1cyI7czoxNToic2VydmVyX3RpbWV6b25lIjtzOjM6IlVNNSI7czoxMzoic2VydmVyX29mZnNldCI7czowOiIiO3M6MTY6ImRheWxpZ2h0X3NhdmluZ3MiO3M6MToibiI7czoyMToiZGVmYXVsdF9zaXRlX3RpbWV6b25lIjtzOjM6IlVNNSI7czoxNjoiZGVmYXVsdF9zaXRlX2RzdCI7czoxOiJuIjtzOjE1OiJob25vcl9lbnRyeV9kc3QiO3M6MToieSI7czoxMzoibWFpbF9wcm90b2NvbCI7czo0OiJtYWlsIjtzOjExOiJzbXRwX3NlcnZlciI7czowOiIiO3M6MTM6InNtdHBfdXNlcm5hbWUiO3M6MDoiIjtzOjEzOiJzbXRwX3Bhc3N3b3JkIjtzOjA6IiI7czoxMToiZW1haWxfZGVidWciO3M6MToibiI7czoxMzoiZW1haWxfY2hhcnNldCI7czo1OiJ1dGYtOCI7czoxNToiZW1haWxfYmF0Y2htb2RlIjtzOjE6Im4iO3M6MTY6ImVtYWlsX2JhdGNoX3NpemUiO3M6MDoiIjtzOjExOiJtYWlsX2Zvcm1hdCI7czo1OiJwbGFpbiI7czo5OiJ3b3JkX3dyYXAiO3M6MToieSI7czoyMjoiZW1haWxfY29uc29sZV90aW1lbG9jayI7czoxOiI1IjtzOjIyOiJsb2dfZW1haWxfY29uc29sZV9tc2dzIjtzOjE6InkiO3M6ODoiY3BfdGhlbWUiO3M6NzoiZGVmYXVsdCI7czoyMToiZW1haWxfbW9kdWxlX2NhcHRjaGFzIjtzOjE6Im4iO3M6MTY6ImxvZ19zZWFyY2hfdGVybXMiO3M6MToieSI7czoxMjoic2VjdXJlX2Zvcm1zIjtzOjE6InkiO3M6MTk6ImRlbnlfZHVwbGljYXRlX2RhdGEiO3M6MToieSI7czoyNDoicmVkaXJlY3Rfc3VibWl0dGVkX2xpbmtzIjtzOjE6Im4iO3M6MTY6ImVuYWJsZV9jZW5zb3JpbmciO3M6MToibiI7czoxNDoiY2Vuc29yZWRfd29yZHMiO3M6MDoiIjtzOjE4OiJjZW5zb3JfcmVwbGFjZW1lbnQiO3M6MDoiIjtzOjEwOiJiYW5uZWRfaXBzIjtzOjA6IiI7czoxMzoiYmFubmVkX2VtYWlscyI7czowOiIiO3M6MTY6ImJhbm5lZF91c2VybmFtZXMiO3M6MDoiIjtzOjE5OiJiYW5uZWRfc2NyZWVuX25hbWVzIjtzOjA6IiI7czoxMDoiYmFuX2FjdGlvbiI7czo4OiJyZXN0cmljdCI7czoxMToiYmFuX21lc3NhZ2UiO3M6MzQ6IlRoaXMgc2l0ZSBpcyBjdXJyZW50bHkgdW5hdmFpbGFibGUiO3M6MTU6ImJhbl9kZXN0aW5hdGlvbiI7czoyMToiaHR0cDovL3d3dy55YWhvby5jb20vIjtzOjE2OiJlbmFibGVfZW1vdGljb25zIjtzOjE6InkiO3M6MTM6ImVtb3RpY29uX3BhdGgiO3M6Mjc6Ii92YXIvd3d3L2VlL2ltYWdlcy9zbWlsZXlzLyI7czoxOToicmVjb3VudF9iYXRjaF90b3RhbCI7czo0OiIxMDAwIjtzOjE3OiJuZXdfdmVyc2lvbl9jaGVjayI7czoxOiJ5IjtzOjE3OiJlbmFibGVfdGhyb3R0bGluZyI7czoxOiJuIjtzOjE3OiJiYW5pc2hfbWFza2VkX2lwcyI7czoxOiJ5IjtzOjE0OiJtYXhfcGFnZV9sb2FkcyI7czoyOiIxMCI7czoxMzoidGltZV9pbnRlcnZhbCI7czoxOiI4IjtzOjEyOiJsb2Nrb3V0X3RpbWUiO3M6MjoiMzAiO3M6MTU6ImJhbmlzaG1lbnRfdHlwZSI7czo3OiJtZXNzYWdlIjtzOjE0OiJiYW5pc2htZW50X3VybCI7czowOiIiO3M6MTg6ImJhbmlzaG1lbnRfbWVzc2FnZSI7czo1MDoiWW91IGhhdmUgZXhjZWVkZWQgdGhlIGFsbG93ZWQgcGFnZSBsb2FkIGZyZXF1ZW5jeS4iO3M6MTc6ImVuYWJsZV9zZWFyY2hfbG9nIjtzOjE6InkiO3M6MTk6Im1heF9sb2dnZWRfc2VhcmNoZXMiO3M6MzoiNTAwIjtzOjE3OiJ0aGVtZV9mb2xkZXJfcGF0aCI7czoxOToiL3Zhci93d3cvZWUvdGhlbWVzLyI7czoxMDoiaXNfc2l0ZV9vbiI7czoxOiJ5IjtzOjEyOiJlbW90aWNvbl91cmwiO3M6MjU6Imh0dHA6Ly9lZS9pbWFnZXMvc21pbGV5cy8iO30=','YTozOntzOjE5OiJtYWlsaW5nbGlzdF9lbmFibGVkIjtzOjE6InkiO3M6MTg6Im1haWxpbmdsaXN0X25vdGlmeSI7czoxOiJuIjtzOjI1OiJtYWlsaW5nbGlzdF9ub3RpZnlfZW1haWxzIjtzOjA6IiI7fQ==','YTo0NDp7czoxMDoidW5fbWluX2xlbiI7czoxOiI0IjtzOjEwOiJwd19taW5fbGVuIjtzOjE6IjUiO3M6MjU6ImFsbG93X21lbWJlcl9yZWdpc3RyYXRpb24iO3M6MToibiI7czoyNToiYWxsb3dfbWVtYmVyX2xvY2FsaXphdGlvbiI7czoxOiJ5IjtzOjE4OiJyZXFfbWJyX2FjdGl2YXRpb24iO3M6NToiZW1haWwiO3M6MjM6Im5ld19tZW1iZXJfbm90aWZpY2F0aW9uIjtzOjE6Im4iO3M6MjM6Im1icl9ub3RpZmljYXRpb25fZW1haWxzIjtzOjA6IiI7czoyNDoicmVxdWlyZV90ZXJtc19vZl9zZXJ2aWNlIjtzOjE6InkiO3M6MjI6InVzZV9tZW1iZXJzaGlwX2NhcHRjaGEiO3M6MToibiI7czoyMDoiZGVmYXVsdF9tZW1iZXJfZ3JvdXAiO3M6MToiNSI7czoxNToicHJvZmlsZV90cmlnZ2VyIjtzOjY6Im1lbWJlciI7czoxMjoibWVtYmVyX3RoZW1lIjtzOjc6ImRlZmF1bHQiO3M6MTQ6ImVuYWJsZV9hdmF0YXJzIjtzOjE6InkiO3M6MjA6ImFsbG93X2F2YXRhcl91cGxvYWRzIjtzOjE6Im4iO3M6MTA6ImF2YXRhcl91cmwiO3M6MjU6Imh0dHA6Ly9lZS9pbWFnZXMvYXZhdGFycy8iO3M6MTE6ImF2YXRhcl9wYXRoIjtzOjI3OiIvdmFyL3d3dy9lZS9pbWFnZXMvYXZhdGFycy8iO3M6MTY6ImF2YXRhcl9tYXhfd2lkdGgiO3M6MzoiMTAwIjtzOjE3OiJhdmF0YXJfbWF4X2hlaWdodCI7czozOiIxMDAiO3M6MTM6ImF2YXRhcl9tYXhfa2IiO3M6MjoiNTAiO3M6MTM6ImVuYWJsZV9waG90b3MiO3M6MToibiI7czo5OiJwaG90b191cmwiO3M6MzE6Imh0dHA6Ly9lZS9pbWFnZXMvbWVtYmVyX3Bob3Rvcy8iO3M6MTA6InBob3RvX3BhdGgiO3M6MzM6Ii92YXIvd3d3L2VlL2ltYWdlcy9tZW1iZXJfcGhvdG9zLyI7czoxNToicGhvdG9fbWF4X3dpZHRoIjtzOjM6IjEwMCI7czoxNjoicGhvdG9fbWF4X2hlaWdodCI7czozOiIxMDAiO3M6MTI6InBob3RvX21heF9rYiI7czoyOiI1MCI7czoxNjoiYWxsb3dfc2lnbmF0dXJlcyI7czoxOiJ5IjtzOjEzOiJzaWdfbWF4bGVuZ3RoIjtzOjM6IjUwMCI7czoyMToic2lnX2FsbG93X2ltZ19ob3RsaW5rIjtzOjE6Im4iO3M6MjA6InNpZ19hbGxvd19pbWdfdXBsb2FkIjtzOjE6Im4iO3M6MTE6InNpZ19pbWdfdXJsIjtzOjM5OiJodHRwOi8vZWUvaW1hZ2VzL3NpZ25hdHVyZV9hdHRhY2htZW50cy8iO3M6MTI6InNpZ19pbWdfcGF0aCI7czo0MToiL3Zhci93d3cvZWUvaW1hZ2VzL3NpZ25hdHVyZV9hdHRhY2htZW50cy8iO3M6MTc6InNpZ19pbWdfbWF4X3dpZHRoIjtzOjM6IjQ4MCI7czoxODoic2lnX2ltZ19tYXhfaGVpZ2h0IjtzOjI6IjgwIjtzOjE0OiJzaWdfaW1nX21heF9rYiI7czoyOiIzMCI7czoxOToicHJ2X21zZ191cGxvYWRfcGF0aCI7czozNDoiL3Zhci93d3cvZWUvaW1hZ2VzL3BtX2F0dGFjaG1lbnRzLyI7czoyMzoicHJ2X21zZ19tYXhfYXR0YWNobWVudHMiO3M6MToiMyI7czoyMjoicHJ2X21zZ19hdHRhY2hfbWF4c2l6ZSI7czozOiIyNTAiO3M6MjA6InBydl9tc2dfYXR0YWNoX3RvdGFsIjtzOjM6IjEwMCI7czoxOToicHJ2X21zZ19odG1sX2Zvcm1hdCI7czo0OiJzYWZlIjtzOjE4OiJwcnZfbXNnX2F1dG9fbGlua3MiO3M6MToieSI7czoxNzoicHJ2X21zZ19tYXhfY2hhcnMiO3M6NDoiNjAwMCI7czoxOToibWVtYmVybGlzdF9vcmRlcl9ieSI7czoxMToidG90YWxfcG9zdHMiO3M6MjE6Im1lbWJlcmxpc3Rfc29ydF9vcmRlciI7czo0OiJkZXNjIjtzOjIwOiJtZW1iZXJsaXN0X3Jvd19saW1pdCI7czoyOiIyMCI7fQ==','YTo2OntzOjExOiJzdHJpY3RfdXJscyI7czoxOiJuIjtzOjg6InNpdGVfNDA0IjtzOjA6IiI7czoxOToic2F2ZV90bXBsX3JldmlzaW9ucyI7czoxOiJuIjtzOjE4OiJtYXhfdG1wbF9yZXZpc2lvbnMiO3M6MToiNSI7czoxNToic2F2ZV90bXBsX2ZpbGVzIjtzOjE6Im4iO3M6MTg6InRtcGxfZmlsZV9iYXNlcGF0aCI7czo0NjoiL3Zhci93d3cvZWUvc3lzdGVtL2V4cHJlc3Npb25lbmdpbmUvdGVtcGxhdGVzLyI7fQ==','YTo5OntzOjIxOiJpbWFnZV9yZXNpemVfcHJvdG9jb2wiO3M6MzoiZ2QyIjtzOjE4OiJpbWFnZV9saWJyYXJ5X3BhdGgiO3M6MDoiIjtzOjE2OiJ0aHVtYm5haWxfcHJlZml4IjtzOjU6InRodW1iIjtzOjE0OiJ3b3JkX3NlcGFyYXRvciI7czoxMDoidW5kZXJzY29yZSI7czoxNzoidXNlX2NhdGVnb3J5X25hbWUiO3M6MToibiI7czoyMjoicmVzZXJ2ZWRfY2F0ZWdvcnlfd29yZCI7czo4OiJjYXRlZ29yeSI7czoyMzoiYXV0b19jb252ZXJ0X2hpZ2hfYXNjaWkiO3M6MToibiI7czoyMjoibmV3X3Bvc3RzX2NsZWFyX2NhY2hlcyI7czoxOiJ5IjtzOjIzOiJhdXRvX2Fzc2lnbl9jYXRfcGFyZW50cyI7czoxOiJ5Ijt9',''); /*!40000 ALTER TABLE `exp_sites` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_snippets` -- DROP TABLE IF EXISTS `exp_snippets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_snippets` ( `snippet_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) NOT NULL, `snippet_name` varchar(75) NOT NULL, `snippet_contents` text, PRIMARY KEY (`snippet_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_snippets` -- LOCK TABLES `exp_snippets` WRITE; /*!40000 ALTER TABLE `exp_snippets` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_snippets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_specialty_templates` -- DROP TABLE IF EXISTS `exp_specialty_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_specialty_templates` ( `template_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `enable_template` char(1) NOT NULL DEFAULT 'y', `template_name` varchar(50) NOT NULL, `data_title` varchar(80) NOT NULL, `template_data` text NOT NULL, PRIMARY KEY (`template_id`), KEY `template_name` (`template_name`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_specialty_templates` -- LOCK TABLES `exp_specialty_templates` WRITE; /*!40000 ALTER TABLE `exp_specialty_templates` DISABLE KEYS */; INSERT INTO `exp_specialty_templates` VALUES (1,1,'y','offline_template','','\n\n\nSystem Offline\n\n\n\n\n\n\n\n
\n\n

System Offline

\n\n

This site is currently offline

\n\n
\n\n\n\n'),(2,1,'y','message_template','','\n\n\n{title}\n\n\n\n{meta_refresh}\n\n\n\n\n\n\n\n
\n\n

{heading}

\n\n{content}\n\n

{link}

\n\n
\n\n\n\n'),(3,1,'y','admin_notify_reg','Notification of new member registration','New member registration site: {site_name}\n\nScreen name: {name}\nUser name: {username}\nEmail: {email}\n\nYour control panel URL: {control_panel_url}'),(4,1,'y','admin_notify_entry','A new channel entry has been posted','A new entry has been posted in the following channel:\n{channel_name}\n\nThe title of the entry is:\n{entry_title}\n\nPosted by: {name}\nEmail: {email}\n\nTo read the entry please visit: \n{entry_url}\n'),(5,1,'y','admin_notify_mailinglist','Someone has subscribed to your mailing list','A new mailing list subscription has been accepted.\n\nEmail Address: {email}\nMailing List: {mailing_list}'),(6,1,'y','admin_notify_comment','You have just received a comment','You have just received a comment for the following channel:\n{channel_name}\n\nThe title of the entry is:\n{entry_title}\n\nLocated at: \n{comment_url}\n\nPosted by: {name}\nEmail: {email}\nURL: {url}\nLocation: {location}\n\n{comment}'),(7,1,'y','mbr_activation_instructions','Enclosed is your activation code','Thank you for your new member registration.\n\nTo activate your new account, please visit the following URL:\n\n{unwrap}{activation_url}{/unwrap}\n\nThank You!\n\n{site_name}\n\n{site_url}'),(8,1,'y','forgot_password_instructions','Login information','{name},\n\nTo reset your password, please go to the following page:\n\n{reset_url}\n\nYour password will be automatically reset, and a new password will be emailed to you.\n\nIf you do not wish to reset your password, ignore this message. It will expire in 24 hours.\n\n{site_name}\n{site_url}'),(9,1,'y','reset_password_notification','New Login Information','{name},\n\nHere is your new login information:\n\nUsername: {username}\nPassword: {password}\n\n{site_name}\n{site_url}'),(10,1,'y','validated_member_notify','Your membership account has been activated','{name},\n\nYour membership account has been activated and is ready for use.\n\nThank You!\n\n{site_name}\n{site_url}'),(11,1,'y','decline_member_validation','Your membership account has been declined','{name},\n\nWe\'re sorry but our staff has decided not to validate your membership.\n\n{site_name}\n{site_url}'),(12,1,'y','mailinglist_activation_instructions','Email Confirmation','Thank you for joining the \"{mailing_list}\" mailing list!\n\nPlease click the link below to confirm your email.\n\nIf you do not want to be added to our list, ignore this email.\n\n{unwrap}{activation_url}{/unwrap}\n\nThank You!\n\n{site_name}'),(13,1,'y','comment_notification','Someone just responded to your comment','{name_of_commenter} just responded to the entry you subscribed to at:\n{channel_name}\n\nThe title of the entry is:\n{entry_title}\n\nYou can see the comment at the following URL:\n{comment_url}\n\n{comment}\n\nTo stop receiving notifications for this comment, click here:\n{notification_removal_url}'),(14,1,'y','comments_opened_notification','New comments have been added','Responses have been added to the entry you subscribed to at:\n{channel_name}\n\nThe title of the entry is:\n{entry_title}\n\nYou can see the comments at the following URL:\n{comment_url}\n\n{comments}\n{comment} \n{/comments}\n\nTo stop receiving notifications for this entry, click here:\n{notification_removal_url}'),(15,1,'y','private_message_notification','Someone has sent you a Private Message','\n{recipient_name},\n\n{sender_name} has just sent you a Private Message titled ‘{message_subject}’.\n\nYou can see the Private Message by logging in and viewing your inbox at:\n{site_url}\n\nContent:\n\n{message_content}\n\nTo stop receiving notifications of Private Messages, turn the option off in your Email Settings.\n\n{site_name}\n{site_url}'),(16,1,'y','pm_inbox_full','Your private message mailbox is full','{recipient_name},\n\n{sender_name} has just attempted to send you a Private Message,\nbut your inbox is full, exceeding the maximum of {pm_storage_limit}.\n\nPlease log in and remove unwanted messages from your inbox at:\n{site_url}'); /*!40000 ALTER TABLE `exp_specialty_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_stats` -- DROP TABLE IF EXISTS `exp_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_stats` ( `stat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `total_members` mediumint(7) NOT NULL DEFAULT '0', `recent_member_id` int(10) NOT NULL DEFAULT '0', `recent_member` varchar(50) NOT NULL, `total_entries` mediumint(8) NOT NULL DEFAULT '0', `total_forum_topics` mediumint(8) NOT NULL DEFAULT '0', `total_forum_posts` mediumint(8) NOT NULL DEFAULT '0', `total_comments` mediumint(8) NOT NULL DEFAULT '0', `last_entry_date` int(10) unsigned NOT NULL DEFAULT '0', `last_forum_post_date` int(10) unsigned NOT NULL DEFAULT '0', `last_comment_date` int(10) unsigned NOT NULL DEFAULT '0', `last_visitor_date` int(10) unsigned NOT NULL DEFAULT '0', `most_visitors` mediumint(7) NOT NULL DEFAULT '0', `most_visitor_date` int(10) unsigned NOT NULL DEFAULT '0', `last_cache_clear` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`stat_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_stats` -- LOCK TABLES `exp_stats` WRITE; /*!40000 ALTER TABLE `exp_stats` DISABLE KEYS */; INSERT INTO `exp_stats` VALUES (1,1,1,1,'EllisLab Team',1,0,0,0,1439207346,0,0,0,0,0,1439207346); /*!40000 ALTER TABLE `exp_stats` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_status_groups` -- DROP TABLE IF EXISTS `exp_status_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_status_groups` ( `group_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_name` varchar(50) NOT NULL, PRIMARY KEY (`group_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_status_groups` -- LOCK TABLES `exp_status_groups` WRITE; /*!40000 ALTER TABLE `exp_status_groups` DISABLE KEYS */; INSERT INTO `exp_status_groups` VALUES (1,1,'Statuses'); /*!40000 ALTER TABLE `exp_status_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_status_no_access` -- DROP TABLE IF EXISTS `exp_status_no_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_status_no_access` ( `status_id` int(6) unsigned NOT NULL, `member_group` smallint(4) unsigned NOT NULL, PRIMARY KEY (`status_id`,`member_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_status_no_access` -- LOCK TABLES `exp_status_no_access` WRITE; /*!40000 ALTER TABLE `exp_status_no_access` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_status_no_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_statuses` -- DROP TABLE IF EXISTS `exp_statuses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_statuses` ( `status_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_id` int(4) unsigned NOT NULL, `status` varchar(50) NOT NULL, `status_order` int(3) unsigned NOT NULL, `highlight` varchar(30) NOT NULL, PRIMARY KEY (`status_id`), KEY `group_id` (`group_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_statuses` -- LOCK TABLES `exp_statuses` WRITE; /*!40000 ALTER TABLE `exp_statuses` DISABLE KEYS */; INSERT INTO `exp_statuses` VALUES (1,1,1,'open',1,'009933'),(2,1,1,'closed',2,'990000'); /*!40000 ALTER TABLE `exp_statuses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_template_groups` -- DROP TABLE IF EXISTS `exp_template_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_template_groups` ( `group_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_name` varchar(50) NOT NULL, `group_order` int(3) unsigned NOT NULL, `is_site_default` char(1) NOT NULL DEFAULT 'n', PRIMARY KEY (`group_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_template_groups` -- LOCK TABLES `exp_template_groups` WRITE; /*!40000 ALTER TABLE `exp_template_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_template_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_template_member_groups` -- DROP TABLE IF EXISTS `exp_template_member_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_template_member_groups` ( `group_id` smallint(4) unsigned NOT NULL, `template_group_id` mediumint(5) unsigned NOT NULL, PRIMARY KEY (`group_id`,`template_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_template_member_groups` -- LOCK TABLES `exp_template_member_groups` WRITE; /*!40000 ALTER TABLE `exp_template_member_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_template_member_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_template_no_access` -- DROP TABLE IF EXISTS `exp_template_no_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_template_no_access` ( `template_id` int(6) unsigned NOT NULL, `member_group` smallint(4) unsigned NOT NULL, PRIMARY KEY (`template_id`,`member_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_template_no_access` -- LOCK TABLES `exp_template_no_access` WRITE; /*!40000 ALTER TABLE `exp_template_no_access` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_template_no_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_templates` -- DROP TABLE IF EXISTS `exp_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_templates` ( `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_id` int(6) unsigned NOT NULL, `template_name` varchar(50) NOT NULL, `save_template_file` char(1) NOT NULL DEFAULT 'n', `template_type` varchar(16) NOT NULL DEFAULT 'webpage', `template_data` mediumtext, `template_notes` text, `edit_date` int(10) NOT NULL DEFAULT '0', `last_author_id` int(10) unsigned NOT NULL DEFAULT '0', `cache` char(1) NOT NULL DEFAULT 'n', `refresh` int(6) unsigned NOT NULL DEFAULT '0', `no_auth_bounce` varchar(50) NOT NULL DEFAULT '', `enable_http_auth` char(1) NOT NULL DEFAULT 'n', `allow_php` char(1) NOT NULL DEFAULT 'n', `php_parse_location` char(1) NOT NULL DEFAULT 'o', `hits` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`template_id`), KEY `group_id` (`group_id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_templates` -- LOCK TABLES `exp_templates` WRITE; /*!40000 ALTER TABLE `exp_templates` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_throttle` -- DROP TABLE IF EXISTS `exp_throttle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_throttle` ( `throttle_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ip_address` varchar(16) NOT NULL DEFAULT '0', `last_activity` int(10) unsigned NOT NULL DEFAULT '0', `hits` int(10) unsigned NOT NULL, `locked_out` char(1) NOT NULL DEFAULT 'n', PRIMARY KEY (`throttle_id`), KEY `ip_address` (`ip_address`), KEY `last_activity` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_throttle` -- LOCK TABLES `exp_throttle` WRITE; /*!40000 ALTER TABLE `exp_throttle` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_throttle` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_upload_no_access` -- DROP TABLE IF EXISTS `exp_upload_no_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_upload_no_access` ( `upload_id` int(6) unsigned NOT NULL, `upload_loc` varchar(3) NOT NULL, `member_group` smallint(4) unsigned NOT NULL, PRIMARY KEY (`upload_id`,`member_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_upload_no_access` -- LOCK TABLES `exp_upload_no_access` WRITE; /*!40000 ALTER TABLE `exp_upload_no_access` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_upload_no_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_upload_prefs` -- DROP TABLE IF EXISTS `exp_upload_prefs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_upload_prefs` ( `id` int(4) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `name` varchar(50) NOT NULL, `server_path` varchar(150) NOT NULL DEFAULT '', `url` varchar(100) NOT NULL, `allowed_types` varchar(3) NOT NULL DEFAULT 'img', `max_size` varchar(16) DEFAULT NULL, `max_height` varchar(6) DEFAULT NULL, `max_width` varchar(6) DEFAULT NULL, `properties` varchar(120) DEFAULT NULL, `pre_format` varchar(120) DEFAULT NULL, `post_format` varchar(120) DEFAULT NULL, `file_properties` varchar(120) DEFAULT NULL, `file_pre_format` varchar(120) DEFAULT NULL, `file_post_format` varchar(120) DEFAULT NULL, PRIMARY KEY (`id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_upload_prefs` -- LOCK TABLES `exp_upload_prefs` WRITE; /*!40000 ALTER TABLE `exp_upload_prefs` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_upload_prefs` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!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 */; -- Dump completed on 2015-08-10 7:49:17