SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
-- Database: `koken02224`
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]albums`
CREATE TABLE `[[dbprefix]]albums` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`slug` varchar(255) DEFAULT NULL,
`summary` varchar(255) DEFAULT NULL,
`sort` varchar(255) DEFAULT 'manual ASC',
`visibility` tinyint(1) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '1',
`left_id` int(11) NOT NULL,
`right_id` int(11) NOT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`featured` tinyint(1) NOT NULL DEFAULT '0',
`featured_on` int(10) DEFAULT NULL,
`featured_order` int(11) DEFAULT NULL,
`total_count` int(11) NOT NULL DEFAULT '0',
`video_count` int(11) NOT NULL DEFAULT '0',
`published_on` int(10) DEFAULT NULL,
`created_on` int(10) NOT NULL,
`modified_on` int(10) NOT NULL,
`album_type` tinyint(1) NOT NULL DEFAULT '0',
`internal_id` char(32) NOT NULL,
KEY `deleted` (`deleted`),
KEY `left_id` (`left_id`),
KEY `right_id` (`right_id`),
KEY `total_count` (`total_count`),
KEY `video_count` (`video_count`),
KEY `created_on` (`created_on`),
KEY `published_on` (`published_on`),
KEY `modified_on` (`modified_on`),
KEY `album_type` (`album_type`),
KEY `internal_id` (`internal_id`),
KEY `featured_featured_order` (`featured`,`featured_order`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]applications`
CREATE TABLE `[[dbprefix]]applications` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`nonce` varchar(32) DEFAULT NULL,
`token` varchar(32) DEFAULT NULL,
`role` varchar(10) DEFAULT 'read',
`name` varchar(255) DEFAULT NULL,
`created_on` int(11) NOT NULL,
`single_use` tinyint(1) NOT NULL DEFAULT '0',
KEY `user_id` (`user_id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]categories`
CREATE TABLE `[[dbprefix]]categories` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`slug` varchar(255) DEFAULT NULL,
`album_count` int(11) NOT NULL DEFAULT '0',
`text_count` int(11) NOT NULL DEFAULT '0',
`content_count` int(11) NOT NULL DEFAULT '0',
KEY `album_count` (`album_count`),
KEY `content_count` (`content_count`),
KEY `text_count` (`text_count`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]content`
CREATE TABLE `[[dbprefix]]content` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`slug` varchar(255) DEFAULT NULL,
`filename` varchar(255) DEFAULT NULL,
`visibility` tinyint(1) NOT NULL DEFAULT '0',
`max_download` tinyint(1) NOT NULL DEFAULT '0',
`license` char(3) NOT NULL DEFAULT 'all',
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`featured` tinyint(1) NOT NULL DEFAULT '0',
`featured_order` int(11) DEFAULT NULL,
`favorite_order` int(11) DEFAULT NULL,
`favorite` tinyint(1) NOT NULL DEFAULT '0',
`favorited_on` int(10) DEFAULT NULL,
`featured_on` int(10) DEFAULT NULL,
`uploaded_on` int(10) NOT NULL,
`captured_on` int(10) NOT NULL,
`published_on` int(10) DEFAULT NULL,
`modified_on` int(10) NOT NULL,
`file_modified_on` int(10) NOT NULL,
`focal_point` varchar(255) DEFAULT NULL,
`filesize` int(11) NOT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`aspect_ratio` decimal(5,3) DEFAULT NULL,
`duration` int(11) DEFAULT NULL,
`file_type` tinyint(1) NOT NULL DEFAULT '0',
`lg_preview` varchar(255) DEFAULT NULL,
`internal_id` char(32) NOT NULL,
`has_exif` tinyint(1) NOT NULL DEFAULT '0',
`has_iptc` tinyint(1) NOT NULL DEFAULT '0',
`source` varchar(255) DEFAULT NULL,
`source_url` varchar(255) DEFAULT NULL,
`storage_url` varchar(255) DEFAULT NULL,
`storage_url_midsize` varchar(255) DEFAULT NULL,
KEY `filename` (`filename`),
KEY `deleted` (`deleted`),
KEY `uploaded_on` (`uploaded_on`),
KEY `captured_on` (`captured_on`),
KEY `modified_on` (`modified_on`),
KEY `published_on` (`published_on`),
KEY `filesize` (`filesize`),
KEY `file_type` (`file_type`),
KEY `has_iptc` (`has_iptc`),
KEY `has_exif` (`has_exif`),
KEY `aspect_ratio` (`aspect_ratio`),
KEY `featured_featured_order` (`featured`,`featured_order`),
KEY `favorite_favorite_order` (`favorite`,`favorite_order`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]drafts`
CREATE TABLE `[[dbprefix]]drafts` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`path` varchar(255) DEFAULT NULL,
`data` mediumtext NOT NULL,
`current` tinyint(1) NOT NULL DEFAULT '0',
`draft` tinyint(1) NOT NULL DEFAULT '0',
`created_on` int(10) NOT NULL,
`modified_on` int(10) NOT NULL,
KEY `current` (`current`),
KEY `created_on` (`created_on`),
KEY `modified_on` (`modified_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `[[dbprefix]]drafts`
INSERT INTO `[[dbprefix]]drafts` VALUES
(1, 'elementary', '{"navigation":{"items":[{"auto":"home","front":true,"path":"\\/home\\/"},{"auto":"timeline"},{"auto":"albums"},{"auto":"contents"},{"auto":"essays"}],"groups":[{"key":"footer","label":"Footer","items":[{"auto":"home","front":true,"path":"\\/home\\/"},{"auto":"albums"},{"auto":"contents"},{"auto":"essays"}]},{"key":"aside_links","label":"Aside links","items":[]}]}}', '{"navigation":{"items":[{"auto":"home","front":true,"path":"\\/home\\/"},{"auto":"timeline"},{"auto":"albums"},{"auto":"contents"},{"auto":"essays"}],"groups":[{"key":"footer","label":"Footer","items":[{"auto":"home","front":true,"path":"\\/home\\/"},{"auto":"albums"},{"auto":"contents"},{"auto":"essays"}]},{"key":"aside_links","label":"Aside links","items":[]}]}}', 1, 1, [[timestamp]], [[timestamp]]);
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]history`
CREATE TABLE `[[dbprefix]]history` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`created_on` int(10) NOT NULL,
KEY `user_id` (`user_id`),
KEY `created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `[[dbprefix]]history`
INSERT INTO `[[dbprefix]]history` VALUES
(1, 1, 's:14:"system:install";', [[timestamp]]);
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_albums_categories`
CREATE TABLE `[[dbprefix]]join_albums_categories` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`album_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
KEY `album_id` (`album_id`),
KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_albums_content`
CREATE TABLE `[[dbprefix]]join_albums_content` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`album_id` int(11) NOT NULL,
`content_id` int(11) NOT NULL,
`order` int(11) DEFAULT NULL,
KEY `album_id` (`album_id`),
KEY `content_id` (`content_id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_albums_covers`
CREATE TABLE `[[dbprefix]]join_albums_covers` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`album_id` int(11) NOT NULL,
`cover_id` int(11) NOT NULL,
KEY `album_id` (`album_id`),
KEY `cover_id` (`cover_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_albums_tags`
CREATE TABLE `[[dbprefix]]join_albums_tags` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`album_id` int(11) NOT NULL,
KEY `album_id` (`album_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_albums_text`
CREATE TABLE `[[dbprefix]]join_albums_text` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`album_id` int(11) NOT NULL,
`text_id` int(11) NOT NULL,
KEY `album_id` (`album_id`),
KEY `text_id` (`text_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_categories_content`
CREATE TABLE `[[dbprefix]]join_categories_content` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`content_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
KEY `content_id` (`content_id`),
KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_categories_text`
CREATE TABLE `[[dbprefix]]join_categories_text` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`text_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
KEY `text_id` (`text_id`),
KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_content_tags`
CREATE TABLE `[[dbprefix]]join_content_tags` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`content_id` int(11) NOT NULL,
KEY `content_id` (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]join_tags_text`
CREATE TABLE `[[dbprefix]]join_tags_text` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`tag_id` int(11) NOT NULL,
`text_id` int(11) NOT NULL,
KEY `text_id` (`text_id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]plugins`
CREATE TABLE `[[dbprefix]]plugins` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`path` varchar(255) DEFAULT NULL,
`setup` tinyint(1) NOT NULL DEFAULT '1',
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]settings`
CREATE TABLE `[[dbprefix]]settings` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;
-- Dumping data for table `[[dbprefix]]settings`
INSERT INTO `[[dbprefix]]settings` VALUES
(1, 'site_timezone', 'America/New_York'),
(2, 'console_show_notifications', 'yes'),
(3, 'console_enable_keyboard_shortcuts', 'yes'),
(4, 'uploading_default_license', 'all'),
(5, 'uploading_default_visibility', 'public'),
(6, 'uploading_default_album_visibility', 'public'),
(7, 'uploading_default_max_download_size', 'none'),
(8, 'uploading_publish_on_captured_date', 'false'),
(9, 'site_title', '[[admin_fname]] [[admin_lname]]'),
(10, 'site_page_title', '[[admin_fname]] [[admin_lname]]'),
(11, 'site_tagline', 'Your site tagline'),
(12, 'site_copyright', '© [[admin_fname]] [[admin_lname]]'),
(13, 'site_description', ''),
(14, 'site_keywords', 'photography, [[admin_fname]] [[admin_lname]]'),
(15, 'site_date_format', 'F j, Y'),
(16, 'site_time_format', 'g:i a'),
(17, 'site_privacy', 'public'),
(18, 'site_hidpi', 'true'),
(19, 'site_url', 'default'),
(20, 'use_default_labels_links', 'true'),
(21, 'uuid', '[[uuid]]'),
(22, 'retain_image_metadata', 'false'),
(23, 'image_use_defaults', 'true'),
(24, 'image_tiny_quality', '80'),
(25, 'image_small_quality', '80'),
(26, 'image_medium_quality', '85'),
(27, 'image_medium_large_quality', '85'),
(28, 'image_large_quality', '85'),
(29, 'image_xlarge_quality', '90'),
(30, 'image_huge_quality', '90'),
(31, 'image_tiny_sharpening', '0.7'),
(32, 'image_small_sharpening', '0.6'),
(33, 'image_medium_sharpening', '0.6'),
(34, 'image_medium_large_sharpening', '0.6'),
(35, 'image_large_sharpening', '0.6'),
(36, 'image_xlarge_sharpening', '0.3'),
(37, 'image_huge_sharpening', '0'),
(38, 'last_upload', 'false'),
(39, 'last_migration', '42'),
(41, 'email_handler', 'DDI_Email'),
(42, 'email_delivery_address', '[[admin_email]]'),
(43, 'image_processing_library', 'convert');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]slugs`
CREATE TABLE `[[dbprefix]]slugs` (
`id` varchar(255) NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]tags`
CREATE TABLE `[[dbprefix]]tags` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`created_on` int(10) NOT NULL,
`modified_on` int(10) NOT NULL,
`last_used` int(10) DEFAULT NULL,
`album_count` int(11) NOT NULL DEFAULT '0',
`text_count` int(11) NOT NULL DEFAULT '0',
`content_count` int(11) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]text`
CREATE TABLE `[[dbprefix]]text` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`slug` varchar(255) DEFAULT NULL,
`featured_image_id` int(10) DEFAULT NULL,
`featured` tinyint(1) NOT NULL DEFAULT '0',
`featured_on` int(10) DEFAULT NULL,
`featured_order` int(11) DEFAULT NULL,
`custom_featured_image` varchar(255) DEFAULT NULL,
`excerpt` varchar(255) DEFAULT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
`page_type` int(1) NOT NULL DEFAULT '0',
`published_on` int(10) DEFAULT NULL,
`created_on` int(10) NOT NULL,
`modified_on` int(10) NOT NULL,
`internal_id` char(32) NOT NULL,
KEY `published` (`published`),
KEY `created_on` (`created_on`),
KEY `modified_on` (`modified_on`),
KEY `published_on` (`published_on`),
KEY `page_type` (`page_type`),
KEY `internal_id` (`internal_id`),
KEY `featured_image_id` (`featured_image_id`),
KEY `featured_featured_order` (`featured`,`featured_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
