-- MySQL dump 10.13 Distrib 5.6.25-73.1, for osx10.10 (x86_64) -- -- Host: localhost Database: ee.stability -- ------------------------------------------------------ -- Server version 5.6.25-73.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `exp_accessories` -- DROP TABLE IF EXISTS `exp_accessories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_accessories` ( `accessory_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `class` varchar(75) NOT NULL DEFAULT '', `member_groups` varchar(255) NOT NULL DEFAULT 'all', `controllers` text, `accessory_version` varchar(12) NOT NULL, PRIMARY KEY (`accessory_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_accessories` -- LOCK TABLES `exp_accessories` WRITE; /*!40000 ALTER TABLE `exp_accessories` DISABLE KEYS */; INSERT INTO `exp_accessories` VALUES (1,'Expressionengine_info_acc','1|5','addons|addons_accessories|addons_extensions|addons_fieldtypes|addons_modules|addons_plugins|admin_content|admin_system|content|content_edit|content_files|content_files_modal|content_publish|design|homepage|members|myaccount|sites|tools|tools_communicate|tools_data|tools_logs|tools_utilities','1.0'); /*!40000 ALTER TABLE `exp_accessories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_actions` -- DROP TABLE IF EXISTS `exp_actions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_actions` ( `action_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `class` varchar(50) NOT NULL, `method` varchar(50) NOT NULL, `csrf_exempt` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`action_id`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_actions` -- LOCK TABLES `exp_actions` WRITE; /*!40000 ALTER TABLE `exp_actions` DISABLE KEYS */; INSERT INTO `exp_actions` VALUES (1,'Comment','insert_new_comment',0),(2,'Comment_mcp','delete_comment_notification',0),(3,'Comment','comment_subscribe',0),(4,'Comment','edit_comment',0),(5,'Email','send_email',0),(6,'Search','do_search',1),(7,'Channel','submit_entry',0),(8,'Channel','filemanager_endpoint',0),(9,'Channel','smiley_pop',0),(10,'Channel','combo_loader',0),(11,'Member','registration_form',0),(12,'Member','register_member',0),(13,'Member','activate_member',0),(14,'Member','member_login',0),(15,'Member','member_logout',0),(16,'Member','send_reset_token',0),(17,'Member','process_reset_password',0),(18,'Member','send_member_email',0),(19,'Member','update_un_pw',0),(20,'Member','member_search',0),(21,'Member','member_delete',0),(22,'Rte','get_js',0); /*!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', `require_captcha` char(1) NOT NULL DEFAULT 'n', `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(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', 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', `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_use_captcha` char(1) NOT NULL DEFAULT 'n', `comment_moderate` char(1) NOT NULL DEFAULT 'n', `comment_max_chars` int(5) unsigned DEFAULT '5000', `comment_timelock` int(5) unsigned NOT NULL DEFAULT '0', `comment_require_email` char(1) NOT NULL DEFAULT 'y', `comment_text_formatting` char(5) NOT NULL DEFAULT 'xhtml', `comment_html_formatting` char(4) NOT NULL DEFAULT 'safe', `comment_allow_img_urls` char(1) NOT NULL DEFAULT 'n', `comment_auto_link_urls` char(1) NOT NULL DEFAULT 'y', `comment_notify` char(1) NOT NULL DEFAULT 'n', `comment_notify_authors` char(1) NOT NULL DEFAULT 'n', `comment_notify_emails` varchar(255) DEFAULT NULL, `comment_expiration` int(4) unsigned NOT NULL DEFAULT '0', `search_results_url` varchar(80) DEFAULT NULL, `show_button_cluster` char(1) NOT NULL DEFAULT 'y', `rss_url` varchar(80) DEFAULT NULL, `enable_versioning` char(1) NOT NULL DEFAULT 'n', `max_revisions` smallint(4) unsigned NOT NULL DEFAULT '10', `default_entry_title` varchar(100) DEFAULT NULL, `url_title_prefix` varchar(80) DEFAULT NULL, `live_look_template` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`channel_id`), KEY `cat_group` (`cat_group`), KEY `status_group` (`status_group`), KEY `field_group` (`field_group`), KEY `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`), KEY `comment_date_idx` (`comment_date`) ) 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',1438109500,'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, `mailinglist` char(1) NOT NULL DEFAULT 'n', `mailtype` varchar(6) NOT NULL, `text_fmt` varchar(40) NOT NULL, `wordwrap` char(1) NOT NULL DEFAULT 'y', `priority` char(1) NOT NULL DEFAULT '3', PRIMARY KEY (`cache_id`) ) ENGINE=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_email_tracker` -- DROP TABLE IF EXISTS `exp_email_tracker`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_email_tracker` ( `email_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email_date` int(10) unsigned NOT NULL DEFAULT '0', `sender_ip` varchar(45) NOT NULL, `sender_email` varchar(75) NOT NULL, `sender_username` varchar(50) NOT NULL, `number_recipients` int(4) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`email_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_email_tracker` -- LOCK TABLES `exp_email_tracker` WRITE; /*!40000 ALTER TABLE `exp_email_tracker` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_email_tracker` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_entry_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_formatting` -- DROP TABLE IF EXISTS `exp_field_formatting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_field_formatting` ( `formatting_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `field_id` int(10) unsigned NOT NULL, `field_fmt` varchar(40) NOT NULL, PRIMARY KEY (`formatting_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exp_field_formatting` -- LOCK TABLES `exp_field_formatting` WRITE; /*!40000 ALTER TABLE `exp_field_formatting` DISABLE KEYS */; /*!40000 ALTER TABLE `exp_field_formatting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_field_groups` -- DROP TABLE IF EXISTS `exp_field_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_field_groups` ( `group_id` int(4) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_name` varchar(50) NOT NULL, PRIMARY KEY (`group_id`), KEY `site_id` (`site_id`) ) ENGINE=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','YTowOnt9','n'),(2,'text','1.0','YTowOnt9','n'),(3,'textarea','1.0','YTowOnt9','n'),(4,'date','1.0','YTowOnt9','n'),(5,'file','1.0','YTowOnt9','n'),(6,'grid','1.0','YTowOnt9','n'),(7,'multi_select','1.0','YTowOnt9','n'),(8,'checkboxes','1.0','YTowOnt9','n'),(9,'radio','1.0','YTowOnt9','n'),(10,'relationship','1.0','YTowOnt9','n'),(11,'rte','1.0','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', `rel_path` varchar(255) DEFAULT NULL, `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 AUTO_INCREMENT=2 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 */; INSERT INTO `exp_files` VALUES (1,1,'test.jpg',1,'../images/uploads/test.jpg','image/jpeg','test.jpg',36667,NULL,NULL,NULL,1,1429648841,1,1429648841,'232 404'); /*!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,'b','','','b',1,'1','btn_b'),(2,1,0,'i','','','i',2,'1','btn_i'),(3,1,0,'blockquote','
','
','q',3,'1','btn_blockquote'),(4,1,0,'a','','','a',4,'1','btn_a'),(5,1,0,'img','\"[![Alternative','','',5,'1','btn_img'); /*!40000 ALTER TABLE `exp_html_buttons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_layout_publish` -- DROP TABLE IF EXISTS `exp_layout_publish`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_layout_publish` ( `layout_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `member_group` int(4) unsigned NOT NULL DEFAULT '0', `channel_id` int(4) unsigned NOT NULL DEFAULT '0', `field_layout` text, PRIMARY KEY (`layout_id`), KEY `site_id` (`site_id`), KEY `member_group` (`member_group`), KEY `channel_id` (`channel_id`) ) ENGINE=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_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) NOT NULL, `m_field_width` varchar(6) NOT NULL, `m_field_search` char(1) NOT NULL DEFAULT 'y', `m_field_required` char(1) NOT NULL DEFAULT 'n', `m_field_public` char(1) NOT NULL DEFAULT 'y', `m_field_reg` char(1) NOT NULL DEFAULT 'n', `m_field_cp_reg` char(1) NOT NULL DEFAULT 'n', `m_field_fmt` char(5) NOT NULL DEFAULT 'none', `m_field_order` int(3) unsigned NOT NULL, PRIMARY KEY (`m_field_id`) ) ENGINE=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_content` char(1) NOT NULL DEFAULT 'n', `can_access_publish` char(1) NOT NULL DEFAULT 'n', `can_access_edit` char(1) NOT NULL DEFAULT 'n', `can_access_files` char(1) NOT NULL DEFAULT 'n', `can_access_fieldtypes` char(1) NOT NULL DEFAULT 'n', `can_access_design` char(1) NOT NULL DEFAULT 'n', `can_access_addons` char(1) NOT NULL DEFAULT 'n', `can_access_modules` char(1) NOT NULL DEFAULT 'n', `can_access_extensions` char(1) NOT NULL DEFAULT 'n', `can_access_accessories` char(1) NOT NULL DEFAULT 'n', `can_access_plugins` char(1) NOT NULL DEFAULT 'n', `can_access_members` char(1) NOT NULL DEFAULT 'n', `can_access_admin` char(1) NOT NULL DEFAULT 'n', `can_access_sys_prefs` char(1) NOT NULL DEFAULT 'n', `can_access_content_prefs` char(1) NOT NULL DEFAULT 'n', `can_access_tools` char(1) NOT NULL DEFAULT 'n', `can_access_comm` char(1) NOT NULL DEFAULT 'n', `can_access_utilities` char(1) NOT NULL DEFAULT 'n', `can_access_data` char(1) NOT NULL DEFAULT 'n', `can_access_logs` char(1) NOT NULL DEFAULT 'n', `can_admin_channels` char(1) NOT NULL DEFAULT 'n', `can_admin_upload_prefs` char(1) NOT NULL DEFAULT 'n', `can_admin_design` char(1) NOT NULL DEFAULT 'n', `can_admin_members` char(1) NOT NULL DEFAULT 'n', `can_delete_members` char(1) NOT NULL DEFAULT 'n', `can_admin_mbr_groups` char(1) NOT NULL DEFAULT 'n', `can_admin_mbr_templates` char(1) NOT NULL DEFAULT 'n', `can_ban_users` char(1) NOT NULL DEFAULT 'n', `can_admin_modules` char(1) NOT NULL DEFAULT 'n', `can_admin_templates` char(1) NOT NULL DEFAULT 'n', `can_edit_categories` char(1) NOT NULL DEFAULT 'n', `can_delete_categories` char(1) NOT NULL DEFAULT 'n', `can_view_other_entries` char(1) NOT NULL DEFAULT 'n', `can_edit_other_entries` char(1) NOT NULL DEFAULT 'n', `can_assign_post_authors` char(1) NOT NULL DEFAULT 'n', `can_delete_self_entries` char(1) NOT NULL DEFAULT 'n', `can_delete_all_entries` char(1) NOT NULL DEFAULT 'n', `can_view_other_comments` char(1) NOT NULL DEFAULT 'n', `can_edit_own_comments` char(1) NOT NULL DEFAULT 'n', `can_delete_own_comments` char(1) NOT NULL DEFAULT 'n', `can_edit_all_comments` char(1) NOT NULL DEFAULT 'n', `can_delete_all_comments` char(1) NOT NULL DEFAULT 'n', `can_moderate_comments` char(1) NOT NULL DEFAULT 'n', `can_send_email` char(1) NOT NULL DEFAULT 'n', `can_send_cached_email` char(1) NOT NULL DEFAULT 'n', `can_email_member_groups` char(1) NOT NULL DEFAULT 'n', `can_email_mailinglist` char(1) NOT NULL DEFAULT 'n', `can_email_from_profile` char(1) NOT NULL DEFAULT 'n', `can_view_profiles` char(1) NOT NULL DEFAULT 'n', `can_edit_html_buttons` char(1) NOT NULL DEFAULT 'n', `can_delete_self` char(1) NOT NULL DEFAULT 'n', `mbr_delete_notify_emails` varchar(255) DEFAULT NULL, `can_post_comments` char(1) NOT NULL DEFAULT 'n', `exclude_from_moderation` char(1) NOT NULL DEFAULT 'n', `can_search` char(1) NOT NULL DEFAULT 'n', `search_flood_control` mediumint(5) unsigned NOT NULL, `can_send_private_messages` char(1) NOT NULL DEFAULT 'n', `prv_msg_send_limit` smallint(5) unsigned NOT NULL DEFAULT '20', `prv_msg_storage_limit` smallint(5) unsigned NOT NULL DEFAULT '60', `can_attach_in_private_messages` char(1) NOT NULL DEFAULT 'n', `can_send_bulletins` char(1) NOT NULL DEFAULT 'n', `include_in_authorlist` char(1) NOT NULL DEFAULT 'n', `include_in_memberlist` char(1) NOT NULL DEFAULT 'y', `include_in_mailinglists` char(1) NOT NULL DEFAULT 'y', PRIMARY KEY (`group_id`,`site_id`) ) ENGINE=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 Admins','','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','','y','y','y',0,'y',20,60,'y','y','y','y','y'),(2,1,'Banned','','y','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','','n','n','n',60,'n',20,60,'n','n','n','n','n'),(3,1,'Guests','','y','n','y','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','y','n','n','n','n','','y','n','y',15,'n',20,60,'n','n','n','n','n'),(4,1,'Pending','','y','n','y','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','y','n','n','n','n','','y','n','y',15,'n',20,60,'n','n','n','n','n'),(5,1,'Members','','y','n','y','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','n','y','y','y','n','','y','n','y',10,'y',20,60,'y','n','n','y','y'); /*!40000 ALTER TABLE `exp_member_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_member_homepage` -- DROP TABLE IF EXISTS `exp_member_homepage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_member_homepage` ( `member_id` int(10) unsigned NOT NULL, `recent_entries` char(1) NOT NULL DEFAULT 'l', `recent_entries_order` int(3) unsigned NOT NULL DEFAULT '0', `recent_comments` char(1) NOT NULL DEFAULT 'l', `recent_comments_order` int(3) unsigned NOT NULL DEFAULT '0', `recent_members` char(1) NOT NULL DEFAULT 'n', `recent_members_order` int(3) unsigned NOT NULL DEFAULT '0', `site_statistics` char(1) NOT NULL DEFAULT 'r', `site_statistics_order` int(3) unsigned NOT NULL DEFAULT '0', `member_search_form` char(1) NOT NULL DEFAULT 'n', `member_search_form_order` int(3) unsigned NOT NULL DEFAULT '0', `notepad` char(1) NOT NULL DEFAULT 'r', `notepad_order` int(3) unsigned NOT NULL DEFAULT '0', `bulletin_board` char(1) NOT NULL DEFAULT 'r', `bulletin_board_order` int(3) unsigned NOT NULL DEFAULT '0', `pmachine_news_feed` char(1) NOT NULL DEFAULT 'n', `pmachine_news_feed_order` int(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`member_id`) ) ENGINE=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', `cp_theme` varchar(32) DEFAULT NULL, `profile_theme` varchar(32) DEFAULT NULL, `forum_theme` varchar(32) DEFAULT NULL, `tracker` text, `template_size` varchar(2) NOT NULL DEFAULT '28', `notepad` text, `notepad_size` varchar(2) NOT NULL DEFAULT '18', `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', 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','EllisLab','e293d2294b8f211c537917f97f3ad41d147296fb37f5e8a228708842fa45b38ae5335a80fbb87e3ec63e43723a4899bc788268e25182e6fb19008bc3a8574b27','z|Pc.>\"li~u\'~rFNl63p`@97+|K]Qk=CI*I6rm\"!8+frL\'x*,Wz2|}zcFZ>DLeQFPqHJTEVD2XW4N\n\n\nSystem Offline\n\n\n\n\n\n\n\n
\n\n

System Offline

\n\n

This site is currently offline

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

{heading}

\n\n{content}\n\n

{link}

\n\n
\n\n\n\n'),(3,1,'y','admin_notify_reg','Notification of new member registration','New member registration site: {site_name}\n\nScreen name: {name}\nUser name: {username}\nEmail: {email}\n\nYour control panel URL: {control_panel_url}'),(4,1,'y','admin_notify_entry','A new channel entry has been posted','A new entry has been posted in the following channel:\n{channel_name}\n\nThe title of the entry is:\n{entry_title}\n\nPosted by: {name}\nEmail: {email}\n\nTo read the entry please visit:\n{entry_url}\n'),(5,1,'y','admin_notify_mailinglist','Someone has subscribed to your mailing list','A new mailing list subscription has been accepted.\n\nEmail Address: {email}\nMailing List: {mailing_list}'),(6,1,'y','admin_notify_comment','You have just received a comment','You have just received a comment for the following channel:\n{channel_name}\n\nThe title of the entry is:\n{entry_title}\n\nLocated at:\n{comment_url}\n\nPosted by: {name}\nEmail: {email}\nURL: {url}\nLocation: {location}\n\n{comment}'),(7,1,'y','mbr_activation_instructions','Enclosed is your activation code','Thank you for your new member registration.\n\nTo activate your new account, please visit the following URL:\n\n{unwrap}{activation_url}{/unwrap}\n\nThank You!\n\n{site_name}\n\n{site_url}'),(8,1,'y','forgot_password_instructions','Login information','{name},\n\nTo reset your password, please go to the following page:\n\n{reset_url}\n\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}'),(9,1,'y','validated_member_notify','Your membership account has been activated','{name},\n\nYour membership account has been activated and is ready for use.\n\nThank You!\n\n{site_name}\n{site_url}'),(10,1,'y','decline_member_validation','Your membership account has been declined','{name},\n\nWe\'re sorry but our staff has decided not to validate your membership.\n\n{site_name}\n{site_url}'),(11,1,'y','mailinglist_activation_instructions','Email Confirmation','Thank you for joining the \"{mailing_list}\" mailing list!\n\nPlease click the link below to confirm your email.\n\nIf you do not want to be added to our list, ignore this email.\n\n{unwrap}{activation_url}{/unwrap}\n\nThank You!\n\n{site_name}'),(12,1,'y','comment_notification','Someone just responded to your comment','{name_of_commenter} just responded to the entry you subscribed to at:\n{channel_name}\n\nThe title of the entry is:\n{entry_title}\n\nYou can see the comment at the following URL:\n{comment_url}\n\n{comment}\n\nTo stop receiving notifications for this comment, click here:\n{notification_removal_url}'),(13,1,'y','comments_opened_notification','New comments have been added','Responses have been added to the entry you subscribed to at:\n{channel_name}\n\nThe title of the entry is:\n{entry_title}\n\nYou can see the comments at the following URL:\n{comment_url}\n\n{comments}\n{comment}\n{/comments}\n\nTo stop receiving notifications for this entry, click here:\n{notification_removal_url}'),(14,1,'y','private_message_notification','Someone has sent you a Private Message','\n{recipient_name},\n\n{sender_name} has just sent you a Private Message titled ‘{message_subject}’.\n\nYou can see the Private Message by logging in and viewing your inbox at:\n{site_url}\n\nContent:\n\n{message_content}\n\nTo stop receiving notifications of Private Messages, turn the option off in your Email Settings.\n\n{site_name}\n{site_url}'),(15,1,'y','pm_inbox_full','Your private message mailbox is full','{recipient_name},\n\n{sender_name} has just attempted to send you a Private Message,\nbut your inbox is full, exceeding the maximum of {pm_storage_limit}.\n\nPlease log in and remove unwanted messages from your inbox at:\n{site_url}'); /*!40000 ALTER TABLE `exp_specialty_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_stats` -- DROP TABLE IF EXISTS `exp_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_stats` ( `stat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `total_members` mediumint(7) NOT NULL DEFAULT '0', `recent_member_id` int(10) NOT NULL DEFAULT '0', `recent_member` varchar(50) NOT NULL, `total_entries` mediumint(8) NOT NULL DEFAULT '0', `total_forum_topics` mediumint(8) NOT NULL DEFAULT '0', `total_forum_posts` mediumint(8) NOT NULL DEFAULT '0', `total_comments` mediumint(8) NOT NULL DEFAULT '0', `last_entry_date` int(10) unsigned NOT NULL DEFAULT '0', `last_forum_post_date` int(10) unsigned NOT NULL DEFAULT '0', `last_comment_date` int(10) unsigned NOT NULL DEFAULT '0', `last_visitor_date` int(10) unsigned NOT NULL DEFAULT '0', `most_visitors` mediumint(7) NOT NULL DEFAULT '0', `most_visitor_date` int(10) unsigned NOT NULL DEFAULT '0', `last_cache_clear` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`stat_id`), KEY `site_id` (`site_id`) ) ENGINE=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,'EllisLab',1,0,0,0,1438109475,0,0,1438111685,1,1438109590,1438714390); /*!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,'Statuses'); /*!40000 ALTER TABLE `exp_status_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exp_status_no_access` -- DROP TABLE IF EXISTS `exp_status_no_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_status_no_access` ( `status_id` int(6) unsigned NOT NULL, `member_group` smallint(4) unsigned NOT NULL, PRIMARY KEY (`status_id`,`member_group`) ) ENGINE=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 AUTO_INCREMENT=6 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 */; INSERT INTO `exp_template_groups` VALUES (1,1,'site',1,'y'),(5,1,'blog',2,'n'); /*!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, `save_template_file` char(1) NOT NULL DEFAULT 'n', `template_type` varchar(16) NOT NULL DEFAULT 'webpage', `template_data` mediumtext, `template_notes` text, `edit_date` int(10) NOT NULL DEFAULT '0', `last_author_id` int(10) unsigned NOT NULL DEFAULT '0', `cache` char(1) NOT NULL DEFAULT 'n', `refresh` int(6) unsigned NOT NULL DEFAULT '0', `no_auth_bounce` varchar(50) NOT NULL DEFAULT '', `enable_http_auth` char(1) NOT NULL DEFAULT 'n', `allow_php` char(1) NOT NULL DEFAULT 'n', `php_parse_location` char(1) NOT NULL DEFAULT 'o', `hits` int(10) unsigned NOT NULL DEFAULT '0', `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 AUTO_INCREMENT=9 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 */; INSERT INTO `exp_templates` VALUES (1,1,1,'index','y','webpage','

Test Site

\n\n

Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo. Quisque sit amet est et sapien ullamcorper pharetra. Vestibulum erat wisi, condimentum sed, commodo vitae, ornare sit amet, wisi. Aenean fermentum, elit eget tincidunt condimentum, eros ipsum rutrum orci, sagittis tempus lacus enim ac dui. Donec non enim in turpis pulvinar facilisis. Ut felis. Praesent dapibus, neque id cursus faucibus, tortor neque egestas augue, eu vulputate magna eros eu erat. Aliquam erat volutpat. Nam dui mi, tincidunt quis, accumsan porttitor, facilisis luctus, metus

\n','',1438109629,1,'n',0,'','n','n','o',2,'n'),(8,1,5,'view','y','webpage','

HTML Ipsum Presents

\n \n

Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo. Quisque sit amet est et sapien ullamcorper pharetra. Vestibulum erat wisi, condimentum sed, commodo vitae, ornare sit amet, wisi. Aenean fermentum, elit eget tincidunt condimentum, eros ipsum rutrum orci, sagittis tempus lacus enim ac dui. Donec non enim in turpis pulvinar facilisis. Ut felis.

\n\n

Header Level 2

\n \n
    \n
  1. Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
    2. \n
  2. Aliquam tincidunt mauris eu risus.
    3. \n
\n\n

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus magna. Cras in mi at felis aliquet congue. Ut a est eget ligula molestie gravida. Curabitur massa. Donec eleifend, libero at sagittis mollis, tellus est malesuada tellus, at luctus turpis elit sit amet quam. Vivamus pretium ornare est.

\n\n

Header Level 3

\n\n\n\n
\n#header h1 a { \n	display: block; \n	width: 300px; \n	height: 80px; \n}\n
','',1438111725,1,'n',0,'','n','n','o',0,'n'),(7,1,5,'index','y','webpage','

Blog Index

\n\n ','',1438111731,1,'n',0,'','n','n','o',0,'n'); /*!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_upload_no_access` -- DROP TABLE IF EXISTS `exp_upload_no_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exp_upload_no_access` ( `upload_id` int(6) unsigned NOT NULL, `upload_loc` varchar(3) NOT NULL, `member_group` smallint(4) unsigned NOT NULL, PRIMARY KEY (`upload_id`,`member_group`) ) ENGINE=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', `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, 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_upload_prefs` -- LOCK TABLES `exp_upload_prefs` WRITE; /*!40000 ALTER TABLE `exp_upload_prefs` DISABLE KEYS */; INSERT INTO `exp_upload_prefs` VALUES (1,1,'Uploads','../images/uploads/','/images/uploads/','img','','','','','','','','','','',NULL); /*!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-07-28 15:28:58