-- MySQL dump 10.13 Distrib 5.6.25-73.1, for osx10.10 (x86_64) -- -- Host: localhost Database: ee.core -- ------------------------------------------------------ -- 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_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, `csrf_exempt` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`action_id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 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,'Channel','submit_entry',0),(2,'Channel','filemanager_endpoint',0),(3,'Channel','smiley_pop',0),(4,'Channel','combo_loader',0),(5,'Comment','insert_new_comment',0),(6,'Comment_mcp','delete_comment_notification',0),(7,'Comment','comment_subscribe',0),(8,'Comment','edit_comment',0),(9,'Rte','get_js',0),(10,'Search','do_search',1); /*!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(45) NOT NULL DEFAULT '0', `word` varchar(20) NOT NULL, PRIMARY KEY (`captcha_id`), KEY `word` (`word`) ) ENGINE=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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', `exclude_group` tinyint(1) unsigned NOT NULL DEFAULT '0', `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=MyISAM 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=MyISAM 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=MyISAM 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', `forum_topic_id` int(10) unsigned DEFAULT NULL, `ip_address` varchar(45) NOT NULL DEFAULT '0', `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, `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=MyISAM 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_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 `field_type` (`field_type`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM 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_form_settings` -- DROP TABLE IF EXISTS `exp_channel_form_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_channel_form_settings` ( `channel_form_settings_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '0', `channel_id` int(6) unsigned NOT NULL DEFAULT '0', `default_status` varchar(50) NOT NULL DEFAULT 'open', `allow_guest_posts` char(1) NOT NULL DEFAULT 'n', `default_author` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`channel_form_settings_id`), KEY `site_id` (`site_id`), KEY `channel_id` (`channel_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_channel_form_settings` -- LOCK TABLES `exp_channel_form_settings` WRITE; /*!40000 ALTER TABLE `exp_channel_form_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_channel_form_settings` 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=MyISAM 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', `forum_topic_id` int(10) unsigned DEFAULT NULL, `ip_address` varchar(45) NOT NULL DEFAULT '0', `title` varchar(200) NOT NULL, `url_title` varchar(200) 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, `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=MyISAM 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(255) 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', `extra_publish_controls` char(1) NOT NULL DEFAULT 'n', `channel_allow_img_urls` char(1) NOT NULL DEFAULT 'y', `channel_auto_link_urls` char(1) NOT NULL DEFAULT 'n', `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_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, `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, `title_field_label` varchar(100) NOT NULL DEFAULT 'Title', `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 `channel_name` (`channel_name`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM 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(75) 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(75) DEFAULT NULL, `url` varchar(75) DEFAULT NULL, `location` varchar(50) DEFAULT NULL, `ip_address` varchar(45) 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_content_types` -- DROP TABLE IF EXISTS `exp_content_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_content_types` ( `content_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`content_type_id`), KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_content_types` -- LOCK TABLES `exp_content_types` WRITE; /*!40000 ALTER TABLE `exp_content_types` DISABLE KEYS */; INSERT INTO `exp_content_types` VALUES (1,'grid'),(2,'channel'); /*!40000 ALTER TABLE `exp_content_types` 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(45) NOT NULL DEFAULT '0', `act_date` int(10) NOT NULL, `action` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 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 */; INSERT INTO `exp_cp_log` VALUES (1,1,1,'admin','fe80::1',1450210168,'Logged in'); /*!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_developer_log` -- DROP TABLE IF EXISTS `exp_developer_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_developer_log` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `timestamp` int(10) unsigned NOT NULL, `viewed` char(1) NOT NULL DEFAULT 'n', `description` text, `function` varchar(100) DEFAULT NULL, `line` int(10) unsigned DEFAULT NULL, `file` varchar(255) DEFAULT NULL, `deprecated_since` varchar(10) DEFAULT NULL, `use_instead` varchar(100) DEFAULT NULL, `template_id` int(10) unsigned NOT NULL DEFAULT '0', `template_name` varchar(100) DEFAULT NULL, `template_group` varchar(100) DEFAULT NULL, `addon_module` varchar(100) DEFAULT NULL, `addon_method` varchar(100) DEFAULT NULL, `snippets` text, `hash` char(32) NOT NULL, PRIMARY KEY (`log_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_developer_log` -- LOCK TABLES `exp_developer_log` WRITE; /*!40000 ALTER TABLE `exp_developer_log` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_developer_log` 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(75) 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, `mailtype` varchar(6) NOT NULL, `text_fmt` varchar(40) NOT NULL, `wordwrap` char(1) NOT NULL DEFAULT 'y', `attachments` mediumtext, PRIMARY KEY (`cache_id`) ) ENGINE=MyISAM 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=MyISAM 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=MyISAM 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(45) NOT NULL DEFAULT '0', `recipient` varchar(75) NOT NULL, `recipient_name` varchar(50) NOT NULL, `subject` varchar(120) NOT NULL, `message` mediumtext NOT NULL, PRIMARY KEY (`cache_id`) ) ENGINE=MyISAM 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_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=MyISAM 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=MyISAM AUTO_INCREMENT=3 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 */; INSERT INTO `exp_extensions` VALUES (1,'Rte_ext','myaccount_nav_setup','myaccount_nav_setup','',10,'1.0.1','y'),(2,'Rte_ext','cp_menu_array','cp_menu_array','',10,'1.0.1','y'); /*!40000 ALTER TABLE `exp_extensions` 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=MyISAM 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=MyISAM AUTO_INCREMENT=12 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.0','YTowOnt9','n'),(2,'text','1.0.0','YTowOnt9','n'),(3,'textarea','1.0.0','YTowOnt9','n'),(4,'date','1.0.0','YTowOnt9','n'),(5,'file','1.0.0','YTowOnt9','n'),(6,'grid','1.0.0','YTowOnt9','n'),(7,'multi_select','1.0.0','YTowOnt9','n'),(8,'checkboxes','1.0.0','YTowOnt9','n'),(9,'radio','1.0.0','YTowOnt9','n'),(10,'relationship','1.0.0','YTowOnt9','n'),(11,'rte','1.0.1','YTowOnt9','n'); /*!40000 ALTER TABLE `exp_fieldtypes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_file_categories` -- DROP TABLE IF EXISTS `exp_file_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_file_categories` ( `file_id` int(10) unsigned DEFAULT NULL, `cat_id` int(10) unsigned DEFAULT NULL, `sort` int(10) unsigned DEFAULT '0', `is_cover` char(1) DEFAULT 'n', KEY `file_id` (`file_id`), KEY `cat_id` (`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_file_categories` -- LOCK TABLES `exp_file_categories` WRITE; /*!40000 ALTER TABLE `exp_file_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_file_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_file_dimensions` -- DROP TABLE IF EXISTS `exp_file_dimensions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_file_dimensions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `upload_location_id` int(4) unsigned DEFAULT NULL, `title` varchar(255) DEFAULT '', `short_name` varchar(255) DEFAULT '', `resize_type` varchar(50) DEFAULT '', `width` int(10) DEFAULT '0', `height` int(10) DEFAULT '0', `watermark_id` int(4) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `upload_location_id` (`upload_location_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_file_dimensions` -- LOCK TABLES `exp_file_dimensions` WRITE; /*!40000 ALTER TABLE `exp_file_dimensions` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_file_dimensions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_file_watermarks` -- DROP TABLE IF EXISTS `exp_file_watermarks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_file_watermarks` ( `wm_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `wm_name` varchar(80) DEFAULT NULL, `wm_type` varchar(10) DEFAULT 'text', `wm_image_path` varchar(100) DEFAULT NULL, `wm_test_image_path` varchar(100) DEFAULT NULL, `wm_use_font` char(1) DEFAULT 'y', `wm_font` varchar(30) DEFAULT NULL, `wm_font_size` int(3) unsigned DEFAULT NULL, `wm_text` varchar(100) DEFAULT NULL, `wm_vrt_alignment` varchar(10) DEFAULT 'top', `wm_hor_alignment` varchar(10) DEFAULT 'left', `wm_padding` int(3) unsigned DEFAULT NULL, `wm_opacity` int(3) unsigned DEFAULT NULL, `wm_hor_offset` int(4) unsigned DEFAULT NULL, `wm_vrt_offset` int(4) unsigned DEFAULT NULL, `wm_x_transp` int(4) DEFAULT NULL, `wm_y_transp` int(4) DEFAULT NULL, `wm_font_color` varchar(7) DEFAULT NULL, `wm_use_drop_shadow` char(1) DEFAULT 'y', `wm_shadow_distance` int(3) unsigned DEFAULT NULL, `wm_shadow_color` varchar(7) DEFAULT NULL, PRIMARY KEY (`wm_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_file_watermarks` -- LOCK TABLES `exp_file_watermarks` WRITE; /*!40000 ALTER TABLE `exp_file_watermarks` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_file_watermarks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_files` -- DROP TABLE IF EXISTS `exp_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_files` ( `file_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned DEFAULT '1', `title` varchar(255) DEFAULT NULL, `upload_location_id` int(4) unsigned DEFAULT '0', `mime_type` varchar(255) DEFAULT NULL, `file_name` varchar(255) DEFAULT NULL, `file_size` int(10) DEFAULT '0', `description` text, `credit` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `uploaded_by_member_id` int(10) unsigned DEFAULT '0', `upload_date` int(10) DEFAULT NULL, `modified_by_member_id` int(10) unsigned DEFAULT '0', `modified_date` int(10) DEFAULT NULL, `file_hw_original` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`file_id`), KEY `upload_location_id` (`upload_location_id`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_files` -- LOCK TABLES `exp_files` WRITE; /*!40000 ALTER TABLE `exp_files` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_files` 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=MyISAM 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_grid_columns` -- DROP TABLE IF EXISTS `exp_grid_columns`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_grid_columns` ( `col_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(10) unsigned DEFAULT NULL, `content_type` varchar(50) DEFAULT NULL, `col_order` int(3) unsigned DEFAULT NULL, `col_type` varchar(50) DEFAULT NULL, `col_label` varchar(50) DEFAULT NULL, `col_name` varchar(32) DEFAULT NULL, `col_instructions` text, `col_required` char(1) DEFAULT NULL, `col_search` char(1) DEFAULT NULL, `col_width` int(3) unsigned DEFAULT NULL, `col_settings` text, PRIMARY KEY (`col_id`), KEY `field_id` (`field_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_grid_columns` -- LOCK TABLES `exp_grid_columns` WRITE; /*!40000 ALTER TABLE `exp_grid_columns` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_grid_columns` 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=MyISAM 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,'html_btn_bold','','','b',1,'1','html-bold'),(2,1,0,'html_btn_italic','','','i',2,'1','html-italic'),(3,1,0,'html_btn_blockquote','
','
','q',3,'1','html-quote'),(4,1,0,'html_btn_anchor','','','a',4,'1','html-link'),(5,1,0,'html_btn_picture','\"[![Alternative','','',5,'1','html-upload'); /*!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', `channel_id` int(4) unsigned NOT NULL DEFAULT '0', `layout_name` varchar(50) NOT NULL, `field_layout` text, PRIMARY KEY (`layout_id`), KEY `site_id` (`site_id`), KEY `channel_id` (`channel_id`) ) ENGINE=MyISAM 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_layout_publish_member_groups` -- DROP TABLE IF EXISTS `exp_layout_publish_member_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_layout_publish_member_groups` ( `layout_id` int(10) unsigned NOT NULL, `group_id` int(4) unsigned NOT NULL, PRIMARY KEY (`layout_id`,`group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_layout_publish_member_groups` -- LOCK TABLES `exp_layout_publish_member_groups` WRITE; /*!40000 ALTER TABLE `exp_layout_publish_member_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_layout_publish_member_groups` 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=MyISAM 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=MyISAM 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) DEFAULT NULL, `m_field_width` varchar(6) DEFAULT 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_show_fmt` char(1) NOT NULL DEFAULT 'y', `m_field_order` int(3) unsigned DEFAULT NULL, `m_field_text_direction` char(3) DEFAULT 'ltr', PRIMARY KEY (`m_field_id`) ) ENGINE=MyISAM 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_footer_report_bug` char(1) NOT NULL DEFAULT 'n', `can_access_footer_new_ticket` char(1) NOT NULL DEFAULT 'n', `can_access_footer_user_guide` 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_members` char(1) NOT NULL DEFAULT 'n', `can_access_sys_prefs` 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_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_addons` 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_cached_email` char(1) NOT NULL DEFAULT 'n', `can_email_member_groups` 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', `cp_homepage` varchar(20) DEFAULT NULL, `cp_homepage_channel` int(10) unsigned NOT NULL DEFAULT '0', `cp_homepage_custom` varchar(100) DEFAULT NULL, `can_create_entries` char(1) NOT NULL DEFAULT 'n', `can_edit_self_entries` char(1) NOT NULL DEFAULT 'n', `can_upload_new_files` char(1) NOT NULL DEFAULT 'n', `can_edit_files` char(1) NOT NULL DEFAULT 'n', `can_delete_files` char(1) NOT NULL DEFAULT 'n', `can_upload_new_toolsets` char(1) NOT NULL DEFAULT 'n', `can_edit_toolsets` char(1) NOT NULL DEFAULT 'n', `can_delete_toolsets` char(1) NOT NULL DEFAULT 'n', `can_create_upload_directories` char(1) NOT NULL DEFAULT 'n', `can_edit_upload_directories` char(1) NOT NULL DEFAULT 'n', `can_delete_upload_directories` char(1) NOT NULL DEFAULT 'n', `can_create_channels` char(1) NOT NULL DEFAULT 'n', `can_edit_channels` char(1) NOT NULL DEFAULT 'n', `can_delete_channels` char(1) NOT NULL DEFAULT 'n', `can_create_channel_fields` char(1) NOT NULL DEFAULT 'n', `can_edit_channel_fields` char(1) NOT NULL DEFAULT 'n', `can_delete_channel_fields` char(1) NOT NULL DEFAULT 'n', `can_create_statuses` char(1) NOT NULL DEFAULT 'n', `can_delete_statuses` char(1) NOT NULL DEFAULT 'n', `can_edit_statuses` char(1) NOT NULL DEFAULT 'n', `can_create_categories` char(1) NOT NULL DEFAULT 'n', `can_create_member_groups` char(1) NOT NULL DEFAULT 'n', `can_delete_member_groups` char(1) NOT NULL DEFAULT 'n', `can_edit_member_groups` char(1) NOT NULL DEFAULT 'n', `can_create_members` char(1) NOT NULL DEFAULT 'n', `can_edit_members` char(1) NOT NULL DEFAULT 'n', `can_create_new_templates` char(1) NOT NULL DEFAULT 'n', `can_edit_templates` char(1) NOT NULL DEFAULT 'n', `can_delete_templates` char(1) NOT NULL DEFAULT 'n', `can_create_template_groups` char(1) NOT NULL DEFAULT 'n', `can_edit_template_groups` char(1) NOT NULL DEFAULT 'n', `can_delete_template_groups` char(1) NOT NULL DEFAULT 'n', `can_create_template_partials` char(1) NOT NULL DEFAULT 'n', `can_edit_template_partials` char(1) NOT NULL DEFAULT 'n', `can_delete_template_partials` char(1) NOT NULL DEFAULT 'n', `can_create_template_variables` char(1) NOT NULL DEFAULT 'n', `can_delete_template_variables` char(1) NOT NULL DEFAULT 'n', `can_edit_template_variables` char(1) NOT NULL DEFAULT 'n', `can_access_security_settings` char(1) NOT NULL DEFAULT 'n', `can_access_translate` char(1) NOT NULL DEFAULT 'n', `can_access_import` char(1) NOT NULL DEFAULT 'n', `can_access_sql_manager` char(1) NOT NULL DEFAULT 'n', PRIMARY KEY (`group_id`,`site_id`) ) ENGINE=MyISAM 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 Admin','','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',NULL,'n','y','n',0,'y',20,60,'y','y','y','y',NULL,0,NULL,'n','n','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','n','n','n','n'),(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',NULL,'n','n','n',60,'n',20,60,'n','n','n','n',NULL,0,NULL,'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'),(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',NULL,'n','n','n',10,'n',20,60,'n','n','n','y',NULL,0,NULL,'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'),(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',NULL,'n','n','n',10,'n',20,60,'n','n','n','y',NULL,0,NULL,'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'),(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','y','y','y','y',NULL,'n','n','n',10,'y',20,60,'y','n','n','y',NULL,0,NULL,'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'); /*!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=MyISAM 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(45) NOT NULL DEFAULT '0', `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=MyISAM 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(128) NOT NULL, `salt` varchar(128) NOT NULL DEFAULT '', `unique_id` varchar(40) NOT NULL, `crypt_key` varchar(40) DEFAULT NULL, `authcode` varchar(10) DEFAULT NULL, `email` varchar(75) 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(45) 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` mediumint(8) unsigned NOT NULL DEFAULT '0', `total_comments` mediumint(8) 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(50) NOT NULL, `time_format` char(2) NOT NULL DEFAULT '12', `date_format` varchar(8) NOT NULL DEFAULT '%n/%j/%Y', `include_seconds` char(1) NOT NULL DEFAULT 'n', `profile_theme` varchar(32) DEFAULT NULL, `forum_theme` varchar(32) DEFAULT NULL, `tracker` text, `template_size` varchar(2) NOT NULL DEFAULT '28', `notepad` text, `notepad_size` varchar(2) NOT NULL DEFAULT '18', `bookmarklets` text, `quick_links` text, `quick_tabs` text, `show_sidebar` char(1) NOT NULL DEFAULT 'n', `pmember_id` int(10) NOT NULL DEFAULT '0', `rte_enabled` char(1) NOT NULL DEFAULT 'y', `rte_toolset_id` int(10) NOT NULL DEFAULT '0', `cp_homepage` varchar(20) DEFAULT NULL, `cp_homepage_channel` varchar(255) DEFAULT NULL, `cp_homepage_custom` varchar(100) DEFAULT NULL, PRIMARY KEY (`member_id`), KEY `group_id` (`group_id`), KEY `unique_id` (`unique_id`), KEY `password` (`password`) ) ENGINE=MyISAM 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','admin','069feaeb4c941d06dfa14a6d8c58faf14f2c2fd18e348e8491d25cf59764957ae5c0d3d9c88724b7b3b1aae8677442466988f06177ca7ebe9c80c2f7d6638618','yfNv89o+n^\',xtfU7D-~DT@+R|@De5!ABys83w*x[)_]Gp4ZHE/\"w~IX**1mNSN|l&d`N<[{crVRa-\'awHqFFjB\\&\'HIF8S&P|U(85]tJ*qOvh-8A;SZLGEErZuhKHyz','8bc31fa9b24039ba10bbcd054c34169ff58c7d82','e5737d385d132051aaec0c1e1a1d3e7342ede91e',NULL,'wes.baker@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,'fe80::1',1450210164,1450210169,1450210169,0,0,0,0,0,0,0,0,'n','y','y','y','y','y','y','y','y','english','America/New_York','12','%n/%j/%Y','n',NULL,NULL,NULL,'28',NULL,'18',NULL,'',NULL,'n',0,'y',0,NULL,NULL,NULL); /*!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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM AUTO_INCREMENT=8 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,'Channel','2.0.1','n','n'),(2,'Comment','2.3.2','y','n'),(3,'Stats','2.0.0','n','n'),(4,'Rte','1.0.1','y','n'),(5,'File','1.0.0','n','n'),(6,'Filepicker','1.0.0','y','n'),(7,'Search','2.2.2','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(45) 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=MyISAM 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(45) NOT NULL DEFAULT '0', `user_agent` varchar(120) 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=MyISAM 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_plugins` -- DROP TABLE IF EXISTS `exp_plugins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_plugins` ( `plugin_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `plugin_name` varchar(50) NOT NULL, `plugin_package` varchar(50) NOT NULL, `plugin_version` varchar(12) NOT NULL, `is_typography_related` char(1) NOT NULL DEFAULT 'n', PRIMARY KEY (`plugin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_plugins` -- LOCK TABLES `exp_plugins` WRITE; /*!40000 ALTER TABLE `exp_plugins` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_plugins` 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` ( `relationship_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned NOT NULL DEFAULT '0', `child_id` int(10) unsigned NOT NULL DEFAULT '0', `field_id` int(10) unsigned NOT NULL DEFAULT '0', `grid_field_id` int(10) unsigned NOT NULL DEFAULT '0', `grid_col_id` int(10) unsigned NOT NULL DEFAULT '0', `grid_row_id` int(10) unsigned NOT NULL DEFAULT '0', `order` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`relationship_id`), KEY `parent_id` (`parent_id`), KEY `child_id` (`child_id`), KEY `field_id` (`field_id`), KEY `grid_row_id` (`grid_row_id`) ) ENGINE=MyISAM 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_remember_me` -- DROP TABLE IF EXISTS `exp_remember_me`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_remember_me` ( `remember_me_id` varchar(40) NOT NULL DEFAULT '0', `member_id` int(10) DEFAULT '0', `ip_address` varchar(45) DEFAULT '0', `user_agent` varchar(120) DEFAULT '', `admin_sess` tinyint(1) DEFAULT '0', `site_id` int(4) DEFAULT '1', `expiration` int(10) DEFAULT '0', `last_refresh` int(10) DEFAULT '0', PRIMARY KEY (`remember_me_id`), KEY `member_id` (`member_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_remember_me` -- LOCK TABLES `exp_remember_me` WRITE; /*!40000 ALTER TABLE `exp_remember_me` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_remember_me` 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=MyISAM 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=MyISAM 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_rte_tools` -- DROP TABLE IF EXISTS `exp_rte_tools`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_rte_tools` ( `tool_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(75) DEFAULT NULL, `class` varchar(75) DEFAULT NULL, `enabled` char(1) DEFAULT 'y', PRIMARY KEY (`tool_id`), KEY `enabled` (`enabled`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_rte_tools` -- LOCK TABLES `exp_rte_tools` WRITE; /*!40000 ALTER TABLE `exp_rte_tools` DISABLE KEYS */; INSERT INTO `exp_rte_tools` VALUES (1,'Blockquote','Blockquote_rte','y'),(2,'Bold','Bold_rte','y'),(3,'Headings','Headings_rte','y'),(4,'Image','Image_rte','y'),(5,'Italic','Italic_rte','y'),(6,'Link','Link_rte','y'),(7,'Ordered List','Ordered_list_rte','y'),(8,'Underline','Underline_rte','y'),(9,'Unordered List','Unordered_list_rte','y'),(10,'View Source','View_source_rte','y'); /*!40000 ALTER TABLE `exp_rte_tools` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_rte_toolsets` -- DROP TABLE IF EXISTS `exp_rte_toolsets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_rte_toolsets` ( `toolset_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `member_id` int(10) DEFAULT '0', `name` varchar(100) DEFAULT NULL, `tools` text, `enabled` char(1) DEFAULT 'y', PRIMARY KEY (`toolset_id`), KEY `member_id` (`member_id`), KEY `enabled` (`enabled`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_rte_toolsets` -- LOCK TABLES `exp_rte_toolsets` WRITE; /*!40000 ALTER TABLE `exp_rte_toolsets` DISABLE KEYS */; INSERT INTO `exp_rte_toolsets` VALUES (1,0,'Default','3|2|5|1|9|7|6|4|10','y'); /*!40000 ALTER TABLE `exp_rte_toolsets` 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(45) 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`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM 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(45) 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=MyISAM 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, `session_id` varchar(40) NOT NULL DEFAULT '0', `hash` varchar(40) NOT NULL, PRIMARY KEY (`hash_id`), KEY `session_id` (`session_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 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 */; INSERT INTO `exp_security_hashes` VALUES (1,1450210169,'f843a46cba5b8a3bfc9beaa6ff86a4d7e45b6356','44c49e92211458ecc2f62f93e70d84be9537ff5f'); /*!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', `member_id` int(10) NOT NULL DEFAULT '0', `admin_sess` tinyint(1) NOT NULL DEFAULT '0', `ip_address` varchar(45) NOT NULL DEFAULT '0', `user_agent` varchar(120) NOT NULL, `login_state` varchar(32) DEFAULT NULL, `fingerprint` varchar(40) NOT NULL, `sess_start` int(10) unsigned NOT NULL DEFAULT '0', `last_activity` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`session_id`), KEY `member_id` (`member_id`), KEY `last_activity_idx` (`last_activity`) ) ENGINE=MyISAM 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 */; INSERT INTO `exp_sessions` VALUES ('f843a46cba5b8a3bfc9beaa6ff86a4d7e45b6356',1,1,'fe80::1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_2) AppleWebKit/601.3.9 (KHTML, like Gecko) Version/9.0.2 Safari/601.3.9',NULL,'8c742fd5d51c3935e597f513cf96bb37',1450210168,1450210179); /*!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` mediumtext 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, `site_pages` text NOT NULL, PRIMARY KEY (`site_id`), KEY `site_name` (`site_name`) ) ENGINE=MyISAM 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,'','default_site',NULL,'YTo4Mzp7czoxMDoic2l0ZV9pbmRleCI7czo5OiJpbmRleC5waHAiO3M6ODoic2l0ZV91cmwiO3M6MTU6Imh0dHA6Ly9lZS5jb3JlLyI7czoxNjoidGhlbWVfZm9sZGVyX3VybCI7czoyMjoiaHR0cDovL2VlLmNvcmUvdGhlbWVzLyI7czoxNToid2VibWFzdGVyX2VtYWlsIjtzOjIyOiJ3ZXMuYmFrZXJAZWxsaXNsYWIuY29tIjtzOjE0OiJ3ZWJtYXN0ZXJfbmFtZSI7czowOiIiO3M6MjA6ImNoYW5uZWxfbm9tZW5jbGF0dXJlIjtzOjc6ImNoYW5uZWwiO3M6MTA6Im1heF9jYWNoZXMiO3M6MzoiMTUwIjtzOjExOiJjYXB0Y2hhX3VybCI7czozMToiaHR0cDovL2VlLmNvcmUvaW1hZ2VzL2NhcHRjaGFzLyI7czoxMjoiY2FwdGNoYV9wYXRoIjtzOjQ3OiIvVXNlcnMvd2VzL0RldmVsb3BtZW50L2VlLmNvcmUvaW1hZ2VzL2NhcHRjaGFzLyI7czoxMjoiY2FwdGNoYV9mb250IjtzOjE6InkiO3M6MTI6ImNhcHRjaGFfcmFuZCI7czoxOiJ5IjtzOjIzOiJjYXB0Y2hhX3JlcXVpcmVfbWVtYmVycyI7czoxOiJuIjtzOjE1OiJyZXF1aXJlX2NhcHRjaGEiO3M6MToibiI7czoxODoiZW5hYmxlX3NxbF9jYWNoaW5nIjtzOjE6Im4iO3M6MTg6ImZvcmNlX3F1ZXJ5X3N0cmluZyI7czoxOiJuIjtzOjEzOiJzaG93X3Byb2ZpbGVyIjtzOjE6Im4iO3M6MTU6ImluY2x1ZGVfc2Vjb25kcyI7czoxOiJuIjtzOjEzOiJjb29raWVfZG9tYWluIjtzOjA6IiI7czoxMToiY29va2llX3BhdGgiO3M6MDoiIjtzOjIwOiJ3ZWJzaXRlX3Nlc3Npb25fdHlwZSI7czoxOiJjIjtzOjE1OiJjcF9zZXNzaW9uX3R5cGUiO3M6MToiYyI7czoyMToiYWxsb3dfdXNlcm5hbWVfY2hhbmdlIjtzOjE6InkiO3M6MTg6ImFsbG93X211bHRpX2xvZ2lucyI7czoxOiJ5IjtzOjE2OiJwYXNzd29yZF9sb2Nrb3V0IjtzOjE6InkiO3M6MjU6InBhc3N3b3JkX2xvY2tvdXRfaW50ZXJ2YWwiO3M6MToiMSI7czoyMDoicmVxdWlyZV9pcF9mb3JfbG9naW4iO3M6MToieSI7czoyMjoicmVxdWlyZV9pcF9mb3JfcG9zdGluZyI7czoxOiJ5IjtzOjI0OiJyZXF1aXJlX3NlY3VyZV9wYXNzd29yZHMiO3M6MToibiI7czoxOToiYWxsb3dfZGljdGlvbmFyeV9wdyI7czoxOiJ5IjtzOjIzOiJuYW1lX29mX2RpY3Rpb25hcnlfZmlsZSI7czowOiIiO3M6MTc6Inhzc19jbGVhbl91cGxvYWRzIjtzOjE6InkiO3M6MTU6InJlZGlyZWN0X21ldGhvZCI7czo4OiJyZWRpcmVjdCI7czo5OiJkZWZ0X2xhbmciO3M6NzoiZW5nbGlzaCI7czo4OiJ4bWxfbGFuZyI7czoyOiJlbiI7czoxMjoic2VuZF9oZWFkZXJzIjtzOjE6InkiO3M6MTE6Imd6aXBfb3V0cHV0IjtzOjE6Im4iO3M6MTE6ImRhdGVfZm9ybWF0IjtzOjg6IiVuLyVqLyVZIjtzOjExOiJ0aW1lX2Zvcm1hdCI7czoyOiIxMiI7czoxMzoic2VydmVyX29mZnNldCI7czowOiIiO3M6MjE6ImRlZmF1bHRfc2l0ZV90aW1lem9uZSI7czoxNjoiQW1lcmljYS9OZXdfWW9yayI7czoxMzoibWFpbF9wcm90b2NvbCI7czo0OiJtYWlsIjtzOjExOiJzbXRwX3NlcnZlciI7czowOiIiO3M6MTM6InNtdHBfdXNlcm5hbWUiO3M6MDoiIjtzOjEzOiJzbXRwX3Bhc3N3b3JkIjtzOjA6IiI7czoxMToiZW1haWxfZGVidWciO3M6MToibiI7czoxMzoiZW1haWxfY2hhcnNldCI7czo1OiJ1dGYtOCI7czoxNToiZW1haWxfYmF0Y2htb2RlIjtzOjE6Im4iO3M6MTY6ImVtYWlsX2JhdGNoX3NpemUiO3M6MDoiIjtzOjExOiJtYWlsX2Zvcm1hdCI7czo1OiJwbGFpbiI7czo5OiJ3b3JkX3dyYXAiO3M6MToieSI7czoyMjoiZW1haWxfY29uc29sZV90aW1lbG9jayI7czoxOiI1IjtzOjIyOiJsb2dfZW1haWxfY29uc29sZV9tc2dzIjtzOjE6InkiO3M6MTY6ImxvZ19zZWFyY2hfdGVybXMiO3M6MToieSI7czoxOToiZGVueV9kdXBsaWNhdGVfZGF0YSI7czoxOiJ5IjtzOjI0OiJyZWRpcmVjdF9zdWJtaXR0ZWRfbGlua3MiO3M6MToibiI7czoxNjoiZW5hYmxlX2NlbnNvcmluZyI7czoxOiJuIjtzOjE0OiJjZW5zb3JlZF93b3JkcyI7czowOiIiO3M6MTg6ImNlbnNvcl9yZXBsYWNlbWVudCI7czowOiIiO3M6MTA6ImJhbm5lZF9pcHMiO3M6MDoiIjtzOjEzOiJiYW5uZWRfZW1haWxzIjtzOjA6IiI7czoxNjoiYmFubmVkX3VzZXJuYW1lcyI7czowOiIiO3M6MTk6ImJhbm5lZF9zY3JlZW5fbmFtZXMiO3M6MDoiIjtzOjEwOiJiYW5fYWN0aW9uIjtzOjg6InJlc3RyaWN0IjtzOjExOiJiYW5fbWVzc2FnZSI7czozNDoiVGhpcyBzaXRlIGlzIGN1cnJlbnRseSB1bmF2YWlsYWJsZSI7czoxNToiYmFuX2Rlc3RpbmF0aW9uIjtzOjIxOiJodHRwOi8vd3d3LnlhaG9vLmNvbS8iO3M6MTY6ImVuYWJsZV9lbW90aWNvbnMiO3M6MToieSI7czoxMjoiZW1vdGljb25fdXJsIjtzOjMwOiJodHRwOi8vZWUuY29yZS9pbWFnZXMvc21pbGV5cy8iO3M6MTk6InJlY291bnRfYmF0Y2hfdG90YWwiO3M6NDoiMTAwMCI7czoxNzoibmV3X3ZlcnNpb25fY2hlY2siO3M6MToieSI7czoxNzoiZW5hYmxlX3Rocm90dGxpbmciO3M6MToibiI7czoxNzoiYmFuaXNoX21hc2tlZF9pcHMiO3M6MToieSI7czoxNDoibWF4X3BhZ2VfbG9hZHMiO3M6MjoiMTAiO3M6MTM6InRpbWVfaW50ZXJ2YWwiO3M6MToiOCI7czoxMjoibG9ja291dF90aW1lIjtzOjI6IjMwIjtzOjE1OiJiYW5pc2htZW50X3R5cGUiO3M6NzoibWVzc2FnZSI7czoxNDoiYmFuaXNobWVudF91cmwiO3M6MDoiIjtzOjE4OiJiYW5pc2htZW50X21lc3NhZ2UiO3M6NTA6IllvdSBoYXZlIGV4Y2VlZGVkIHRoZSBhbGxvd2VkIHBhZ2UgbG9hZCBmcmVxdWVuY3kuIjtzOjE3OiJlbmFibGVfc2VhcmNoX2xvZyI7czoxOiJ5IjtzOjE5OiJtYXhfbG9nZ2VkX3NlYXJjaGVzIjtzOjM6IjUwMCI7czoxNzoidGhlbWVfZm9sZGVyX3BhdGgiO3M6Mzg6Ii9Vc2Vycy93ZXMvRGV2ZWxvcG1lbnQvZWUuY29yZS90aGVtZXMvIjtzOjEwOiJpc19zaXRlX29uIjtzOjE6InkiO3M6MTE6InJ0ZV9lbmFibGVkIjtzOjE6InkiO3M6MjI6InJ0ZV9kZWZhdWx0X3Rvb2xzZXRfaWQiO3M6MToiMSI7fQ==','YTo0NTp7czoxMDoidW5fbWluX2xlbiI7czoxOiI0IjtzOjEwOiJwd19taW5fbGVuIjtzOjE6IjUiO3M6MjU6ImFsbG93X21lbWJlcl9yZWdpc3RyYXRpb24iO3M6MToibiI7czoyNToiYWxsb3dfbWVtYmVyX2xvY2FsaXphdGlvbiI7czoxOiJ5IjtzOjE4OiJyZXFfbWJyX2FjdGl2YXRpb24iO3M6NToiZW1haWwiO3M6MjM6Im5ld19tZW1iZXJfbm90aWZpY2F0aW9uIjtzOjE6Im4iO3M6MjM6Im1icl9ub3RpZmljYXRpb25fZW1haWxzIjtzOjA6IiI7czoyNDoicmVxdWlyZV90ZXJtc19vZl9zZXJ2aWNlIjtzOjE6InkiO3M6MjA6ImRlZmF1bHRfbWVtYmVyX2dyb3VwIjtzOjE6IjUiO3M6MTU6InByb2ZpbGVfdHJpZ2dlciI7czo2OiJtZW1iZXIiO3M6MTI6Im1lbWJlcl90aGVtZSI7czo3OiJkZWZhdWx0IjtzOjE0OiJlbmFibGVfYXZhdGFycyI7czoxOiJ5IjtzOjIwOiJhbGxvd19hdmF0YXJfdXBsb2FkcyI7czoxOiJuIjtzOjEwOiJhdmF0YXJfdXJsIjtzOjMwOiJodHRwOi8vZWUuY29yZS9pbWFnZXMvYXZhdGFycy8iO3M6MTE6ImF2YXRhcl9wYXRoIjtzOjQ2OiIvVXNlcnMvd2VzL0RldmVsb3BtZW50L2VlLmNvcmUvaW1hZ2VzL2F2YXRhcnMvIjtzOjE2OiJhdmF0YXJfbWF4X3dpZHRoIjtzOjM6IjEwMCI7czoxNzoiYXZhdGFyX21heF9oZWlnaHQiO3M6MzoiMTAwIjtzOjEzOiJhdmF0YXJfbWF4X2tiIjtzOjI6IjUwIjtzOjEzOiJlbmFibGVfcGhvdG9zIjtzOjE6Im4iO3M6OToicGhvdG9fdXJsIjtzOjM2OiJodHRwOi8vZWUuY29yZS9pbWFnZXMvbWVtYmVyX3Bob3Rvcy8iO3M6MTA6InBob3RvX3BhdGgiO3M6NTI6Ii9Vc2Vycy93ZXMvRGV2ZWxvcG1lbnQvZWUuY29yZS9pbWFnZXMvbWVtYmVyX3Bob3Rvcy8iO3M6MTU6InBob3RvX21heF93aWR0aCI7czozOiIxMDAiO3M6MTY6InBob3RvX21heF9oZWlnaHQiO3M6MzoiMTAwIjtzOjEyOiJwaG90b19tYXhfa2IiO3M6MjoiNTAiO3M6MTY6ImFsbG93X3NpZ25hdHVyZXMiO3M6MToieSI7czoxMzoic2lnX21heGxlbmd0aCI7czozOiI1MDAiO3M6MjE6InNpZ19hbGxvd19pbWdfaG90bGluayI7czoxOiJuIjtzOjIwOiJzaWdfYWxsb3dfaW1nX3VwbG9hZCI7czoxOiJuIjtzOjExOiJzaWdfaW1nX3VybCI7czo0NDoiaHR0cDovL2VlLmNvcmUvaW1hZ2VzL3NpZ25hdHVyZV9hdHRhY2htZW50cy8iO3M6MTI6InNpZ19pbWdfcGF0aCI7czo2MDoiL1VzZXJzL3dlcy9EZXZlbG9wbWVudC9lZS5jb3JlL2ltYWdlcy9zaWduYXR1cmVfYXR0YWNobWVudHMvIjtzOjE3OiJzaWdfaW1nX21heF93aWR0aCI7czozOiI0ODAiO3M6MTg6InNpZ19pbWdfbWF4X2hlaWdodCI7czoyOiI4MCI7czoxNDoic2lnX2ltZ19tYXhfa2IiO3M6MjoiMzAiO3M6MTU6InBydl9tc2dfZW5hYmxlZCI7czoxOiJ5IjtzOjI1OiJwcnZfbXNnX2FsbG93X2F0dGFjaG1lbnRzIjtzOjE6InkiO3M6MTk6InBydl9tc2dfdXBsb2FkX3BhdGgiO3M6NTM6Ii9Vc2Vycy93ZXMvRGV2ZWxvcG1lbnQvZWUuY29yZS9pbWFnZXMvcG1fYXR0YWNobWVudHMvIjtzOjIzOiJwcnZfbXNnX21heF9hdHRhY2htZW50cyI7czoxOiIzIjtzOjIyOiJwcnZfbXNnX2F0dGFjaF9tYXhzaXplIjtzOjM6IjI1MCI7czoyMDoicHJ2X21zZ19hdHRhY2hfdG90YWwiO3M6MzoiMTAwIjtzOjE5OiJwcnZfbXNnX2h0bWxfZm9ybWF0IjtzOjQ6InNhZmUiO3M6MTg6InBydl9tc2dfYXV0b19saW5rcyI7czoxOiJ5IjtzOjE3OiJwcnZfbXNnX21heF9jaGFycyI7czo0OiI2MDAwIjtzOjE5OiJtZW1iZXJsaXN0X29yZGVyX2J5IjtzOjExOiJ0b3RhbF9wb3N0cyI7czoyMToibWVtYmVybGlzdF9zb3J0X29yZGVyIjtzOjQ6ImRlc2MiO3M6MjA6Im1lbWJlcmxpc3Rfcm93X2xpbWl0IjtzOjI6IjIwIjt9','YTo2OntzOjIyOiJlbmFibGVfdGVtcGxhdGVfcm91dGVzIjtzOjE6InkiO3M6MTE6InN0cmljdF91cmxzIjtzOjE6InkiO3M6ODoic2l0ZV80MDQiO3M6MDoiIjtzOjE5OiJzYXZlX3RtcGxfcmV2aXNpb25zIjtzOjE6Im4iO3M6MTg6Im1heF90bXBsX3JldmlzaW9ucyI7czoxOiI1IjtzOjE1OiJzYXZlX3RtcGxfZmlsZXMiO3M6MToibiI7fQ==','YTo5OntzOjIxOiJpbWFnZV9yZXNpemVfcHJvdG9jb2wiO3M6MzoiZ2QyIjtzOjE4OiJpbWFnZV9saWJyYXJ5X3BhdGgiO3M6MDoiIjtzOjE2OiJ0aHVtYm5haWxfcHJlZml4IjtzOjU6InRodW1iIjtzOjE0OiJ3b3JkX3NlcGFyYXRvciI7czo0OiJkYXNoIjtzOjE3OiJ1c2VfY2F0ZWdvcnlfbmFtZSI7czoxOiJuIjtzOjIyOiJyZXNlcnZlZF9jYXRlZ29yeV93b3JkIjtzOjg6ImNhdGVnb3J5IjtzOjIzOiJhdXRvX2NvbnZlcnRfaGlnaF9hc2NpaSI7czoxOiJuIjtzOjIyOiJuZXdfcG9zdHNfY2xlYXJfY2FjaGVzIjtzOjE6InkiO3M6MjM6ImF1dG9fYXNzaWduX2NhdF9wYXJlbnRzIjtzOjE6InkiO30=','',''); /*!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=MyISAM 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_type` varchar(16) DEFAULT NULL, `template_subtype` varchar(16) DEFAULT NULL, `template_data` text NOT NULL, `template_notes` text, `edit_date` int(10) NOT NULL DEFAULT '0', `last_author_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`template_id`), KEY `template_name` (`template_name`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 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','','system',NULL,'\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',NULL,1450210164,0),(2,1,'y','message_template','','system',NULL,'\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',NULL,1450210164,0),(3,1,'y','admin_notify_reg','Notification of new member registration','email','members','New member registration site: {site_name}\n\nScreen name: {name}\nUser name: {username}\nEmail: {email}\n\nYour control panel URL: {control_panel_url}',NULL,1450210164,0),(4,1,'y','admin_notify_entry','A new channel entry has been posted','email','content','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',NULL,1450210164,0),(5,1,'y','admin_notify_comment','You have just received a comment','email','comments','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}',NULL,1450210164,0),(6,1,'y','mbr_activation_instructions','Enclosed is your activation code','email','members','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}',NULL,1450210164,0),(7,1,'y','forgot_password_instructions','Login information','email','members','{name},\n\nTo reset your password, please go to the following page:\n\n{reset_url}\n\nThen log in with your username: {username}\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}',NULL,1450210164,0),(8,1,'y','validated_member_notify','Your membership account has been activated','email','members','{name},\n\nYour membership account has been activated and is ready for use.\n\nThank You!\n\n{site_name}\n{site_url}',NULL,1450210164,0),(9,1,'y','decline_member_validation','Your membership account has been declined','email','members','{name},\n\nWe\'re sorry but our staff has decided not to validate your membership.\n\n{site_name}\n{site_url}',NULL,1450210164,0),(10,1,'y','comment_notification','Someone just responded to your comment','email','comments','{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}',NULL,1450210164,0),(11,1,'y','comments_opened_notification','New comments have been added','email','comments','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}',NULL,1450210164,0),(12,1,'y','private_message_notification','Someone has sent you a Private Message','email','private_messages','\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}',NULL,1450210164,0),(13,1,'y','pm_inbox_full','Your private message mailbox is full','email','private_messages','{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}',NULL,1450210164,0); /*!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=MyISAM 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,'admin',0,0,0,0,1450210164,0,0,0,0,0,1450210164); /*!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=MyISAM 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,'Default'); /*!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=MyISAM 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=MyISAM 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`), KEY `group_name_idx` (`group_name`), KEY `group_order_idx` (`group_order`) ) ENGINE=MyISAM 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=MyISAM 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=MyISAM 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_template_routes` -- DROP TABLE IF EXISTS `exp_template_routes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_template_routes` ( `route_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `template_id` int(10) unsigned NOT NULL, `order` int(10) unsigned DEFAULT NULL, `route` varchar(512) DEFAULT NULL, `route_parsed` varchar(512) DEFAULT NULL, `route_required` char(1) NOT NULL DEFAULT 'n', PRIMARY KEY (`route_id`), KEY `template_id` (`template_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_template_routes` -- LOCK TABLES `exp_template_routes` WRITE; /*!40000 ALTER TABLE `exp_template_routes` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_template_routes` 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, `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', `protect_javascript` char(1) NOT NULL DEFAULT 'n', PRIMARY KEY (`template_id`), KEY `group_id` (`group_id`), KEY `template_name` (`template_name`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM 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(45) 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=MyISAM 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_update_log` -- DROP TABLE IF EXISTS `exp_update_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_update_log` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `timestamp` int(10) unsigned DEFAULT NULL, `message` text, `method` varchar(100) DEFAULT NULL, `line` int(10) unsigned DEFAULT NULL, `file` varchar(255) DEFAULT NULL, PRIMARY KEY (`log_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_update_log` -- LOCK TABLES `exp_update_log` WRITE; /*!40000 ALTER TABLE `exp_update_log` DISABLE KEYS */; INSERT INTO `exp_update_log` VALUES (1,1450210164,'Smartforge::add_key failed. Table \'exp_comments\' does not exist.','Smartforge::add_key',120,'/Users/wes/Development/ee.core/system/ee/EllisLab/Addons/comment/upd.comment.php'); /*!40000 ALTER TABLE `exp_update_log` 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, `member_group` smallint(4) unsigned NOT NULL, PRIMARY KEY (`upload_id`,`member_group`) ) ENGINE=MyISAM 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(255) NOT NULL DEFAULT '', `url` varchar(100) NOT NULL, `allowed_types` varchar(3) NOT NULL DEFAULT 'img', `default_modal_view` varchar(5) NOT NULL DEFAULT 'list', `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, `cat_group` varchar(255) DEFAULT NULL, `batch_location` varchar(255) DEFAULT NULL, `module_id` int(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM 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-12-15 15:09:54