GithubStar/mp-Blog
1
0
Fork 0
mirror of https://github.com/rumosky/mp-Blog.git synced 2026-10-20 23:50:40 +08:00
Code Issues Packages Projects Releases Wiki Activity
Files
master
mp-Blog/Restful/tests/typecho.sql
T
rumosky 6e866d4e7a v1.0.0
2023-07-19 00:35:41 +08:00

207 lines
22 KiB
SQL
Raw Permalink Blame History

-- Adminer 4.3.1 MySQL dump
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
SET NAMES utf8mb4;
DROP DATABASE IF EXISTS `typecho_test_db`;
CREATE DATABASE `typecho_test_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `typecho_test_db`;
DROP TABLE IF EXISTS `typecho_comments`;
CREATE TABLE `typecho_comments` (
`coid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cid` int(10) unsigned DEFAULT '0',
`created` int(10) unsigned DEFAULT '0',
`author` varchar(150) DEFAULT NULL,
`authorId` int(10) unsigned DEFAULT '0',
`ownerId` int(10) unsigned DEFAULT '0',
`mail` varchar(150) DEFAULT NULL,
`url` varchar(150) DEFAULT NULL,
`ip` varchar(64) DEFAULT NULL,
`agent` varchar(511) DEFAULT NULL,
`text` text,
`type` varchar(16) DEFAULT 'comment',
`status` varchar(16) DEFAULT 'approved',
`parent` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`coid`),
KEY `cid` (`cid`),
KEY `created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `typecho_comments` (`coid`, `cid`, `created`, `author`, `authorId`, `ownerId`, `mail`, `url`, `ip`, `agent`, `text`, `type`, `status`, `parent`) VALUES
(1, 1, 1516520053, 'Typecho', 0, 1, NULL, 'http://typecho.org', '127.0.0.1', 'Typecho 1.1/17.12.14', '欢迎加入 Typecho 大家族', 'comment', 'approved', 0);
DROP TABLE IF EXISTS `typecho_contents`;
CREATE TABLE `typecho_contents` (
`cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(150) DEFAULT NULL,
`slug` varchar(150) DEFAULT NULL,
`created` int(10) unsigned DEFAULT '0',
`modified` int(10) unsigned DEFAULT '0',
`text` longtext,
`order` int(10) unsigned DEFAULT '0',
`authorId` int(10) unsigned DEFAULT '0',
`template` varchar(32) DEFAULT NULL,
`type` varchar(16) DEFAULT 'post',
`status` varchar(16) DEFAULT 'publish',
`password` varchar(32) DEFAULT NULL,
`commentsNum` int(10) unsigned DEFAULT '0',
`allowComment` char(1) DEFAULT '0',
`allowPing` char(1) DEFAULT '0',
`allowFeed` char(1) DEFAULT '0',
`parent` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`cid`),
UNIQUE KEY `slug` (`slug`),
KEY `created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `typecho_contents` (`cid`, `title`, `slug`, `created`, `modified`, `text`, `order`, `authorId`, `template`, `type`, `status`, `password`, `commentsNum`, `allowComment`, `allowPing`, `allowFeed`, `parent`) VALUES
(1, '欢迎使用 Typecho', 'start', 1516520040, 1516585449, '<!--markdown-->如果您看到这篇文章,表示您的 blog 已经安装成功.', 0, 1, NULL, 'post', 'publish', NULL, 1, '1', '1', '1', 0),
(2, '关于', 'start-page', 1516520053, 1516520053, '<!--markdown-->本页面由 Typecho 创建, 这只是个测试页面.', 0, 1, NULL, 'page', 'publish', NULL, 0, '1', '1', '1', 0);
DROP TABLE IF EXISTS `typecho_fields`;
CREATE TABLE `typecho_fields` (
`cid` int(10) unsigned NOT NULL,
`name` varchar(150) NOT NULL,
`type` varchar(8) DEFAULT 'str',
`str_value` text,
`int_value` int(10) DEFAULT '0',
`float_value` float DEFAULT '0',
PRIMARY KEY (`cid`,`name`),
KEY `int_value` (`int_value`),
KEY `float_value` (`float_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
DROP TABLE IF EXISTS `typecho_metas`;
CREATE TABLE `typecho_metas` (
`mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(150) DEFAULT NULL,
`slug` varchar(150) DEFAULT NULL,
`type` varchar(32) NOT NULL,
`description` varchar(150) DEFAULT NULL,
`count` int(10) unsigned DEFAULT '0',
`order` int(10) unsigned DEFAULT '0',
`parent` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`mid`),
KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `typecho_metas` (`mid`, `name`, `slug`, `type`, `description`, `count`, `order`, `parent`) VALUES
(1, '默认分类', 'default', 'category', '只是一个默认分类', 1, 1, 0),
(2, '分类1', 'cat1', 'category', NULL, 1, 2, 0),
(3, '分类2', 'cat2', 'category', NULL, 0, 3, 0),
(4, 'tag1', 'tag1', 'tag', NULL, 1, 0, 0),
(5, 'tag2', 'tag2', 'tag', NULL, 0, 0, 0);
DROP TABLE IF EXISTS `typecho_options`;
CREATE TABLE `typecho_options` (
`name` varchar(32) NOT NULL,
`user` int(10) unsigned NOT NULL DEFAULT '0',
`value` text,
PRIMARY KEY (`name`,`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `typecho_options` (`name`, `user`, `value`) VALUES
('actionTable', 0, 'a:0:{}'),
('allowRegister', 0, '0'),
('allowXmlRpc', 0, '2'),
('attachmentTypes', 0, '@image@'),
('autoSave', 0, '0'),
('charset', 0, 'UTF-8'),
('commentDateFormat', 0, 'F jS, Y \\a\\t h:i a'),
('commentsAntiSpam', 0, '1'),
('commentsAutoClose', 0, '0'),
('commentsAvatar', 0, '1'),
('commentsAvatarRating', 0, 'G'),
('commentsCheckReferer', 0, '1'),
('commentsHTMLTagAllowed', 0, NULL),
('commentsListSize', 0, '10'),
('commentsMarkdown', 0, '0'),
('commentsMaxNestingLevels', 0, '5'),
('commentsOrder', 0, 'ASC'),
('commentsPageBreak', 0, '0'),
('commentsPageDisplay', 0, 'last'),
('commentsPageSize', 0, '20'),
('commentsPostInterval', 0, '60'),
('commentsPostIntervalEnable', 0, '1'),
('commentsPostTimeout', 0, '2592000'),
('commentsRequireMail', 0, '1'),
('commentsRequireModeration', 0, '0'),
('commentsRequireURL', 0, '0'),
('commentsShowCommentOnly', 0, '0'),
('commentsShowUrl', 0, '1'),
('commentsThreaded', 0, '1'),
('commentsUrlNofollow', 0, '1'),
('commentsWhitelist', 0, '0'),
('contentType', 0, 'text/html'),
('defaultAllowComment', 0, '1'),
('defaultAllowFeed', 0, '1'),
('defaultAllowPing', 0, '1'),
('defaultCategory', 0, '1'),
('description', 0, 'Just So So ...'),
('editorSize', 0, '350'),
('feedFullText', 0, '1'),
('frontArchive', 0, '0'),
('frontPage', 0, 'recent'),
('generator', 0, 'Typecho 1.1/17.12.14'),
('gzip', 0, '0'),
('installed', 0, '1'),
('keywords', 0, 'typecho,php,blog'),
('lang', 0, 'zh_CN'),
('markdown', 0, '1'),
('pageSize', 0, '5'),
('panelTable', 0, 'a:0:{}'),
('plugin:Restful', 0, 'a:12:{s:5:\"posts\";i:1;s:5:\"pages\";i:1;s:10:\"categories\";i:1;s:4:\"tags\";i:1;s:4:\"post\";i:1;s:8:\"comments\";i:1;s:7:\"comment\";i:1;s:8:\"settings\";i:1;s:5:\"users\";i:1;s:8:\"archives\";i:1;s:6:\"origin\";N;s:8:\"csrfSalt\";s:32:\"05faabd6637f7e30c797973a558d4372\";}'),
('plugins', 0, 'a:2:{s:9:\"activated\";a:1:{s:7:\"Restful\";a:1:{s:7:\"handles\";a:1:{s:23:\"Widget_Feedback:comment\";a:1:{i:0;a:2:{i:0;s:14:\"Restful_Plugin\";i:1;s:7:\"comment\";}}}}}s:7:\"handles\";a:1:{s:23:\"Widget_Feedback:comment\";a:1:{i:0;a:2:{i:0;s:14:\"Restful_Plugin\";i:1;s:7:\"comment\";}}}}'),
('postDateFormat', 0, 'Y-m-d'),
('postsListSize', 0, '10'),
('rewrite', 0, '1'),
('routingTable', 0, 'a:36:{i:0;a:35:{s:5:\"index\";a:6:{s:3:\"url\";s:1:\"/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:8:\"|^[/]?$|\";s:6:\"format\";s:1:\"/\";s:6:\"params\";a:0:{}}s:7:\"archive\";a:6:{s:3:\"url\";s:6:\"/blog/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:13:\"|^/blog[/]?$|\";s:6:\"format\";s:6:\"/blog/\";s:6:\"params\";a:0:{}}s:2:\"do\";a:6:{s:3:\"url\";s:22:\"/action/[action:alpha]\";s:6:\"widget\";s:9:\"Widget_Do\";s:6:\"action\";s:6:\"action\";s:4:\"regx\";s:32:\"|^/action/([_0-9a-zA-Z-]+)[/]?$|\";s:6:\"format\";s:10:\"/action/%s\";s:6:\"params\";a:1:{i:0;s:6:\"action\";}}s:4:\"post\";a:6:{s:3:\"url\";s:24:\"/archives/[cid:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:26:\"|^/archives/([0-9]+)[/]?$|\";s:6:\"format\";s:13:\"/archives/%s/\";s:6:\"params\";a:1:{i:0;s:3:\"cid\";}}s:10:\"attachment\";a:6:{s:3:\"url\";s:26:\"/attachment/[cid:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:28:\"|^/attachment/([0-9]+)[/]?$|\";s:6:\"format\";s:15:\"/attachment/%s/\";s:6:\"params\";a:1:{i:0;s:3:\"cid\";}}s:8:\"category\";a:6:{s:3:\"url\";s:17:\"/category/[slug]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:25:\"|^/category/([^/]+)[/]?$|\";s:6:\"format\";s:13:\"/category/%s/\";s:6:\"params\";a:1:{i:0;s:4:\"slug\";}}s:3:\"tag\";a:6:{s:3:\"url\";s:12:\"/tag/[slug]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:20:\"|^/tag/([^/]+)[/]?$|\";s:6:\"format\";s:8:\"/tag/%s/\";s:6:\"params\";a:1:{i:0;s:4:\"slug\";}}s:6:\"author\";a:6:{s:3:\"url\";s:22:\"/author/[uid:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:24:\"|^/author/([0-9]+)[/]?$|\";s:6:\"format\";s:11:\"/author/%s/\";s:6:\"params\";a:1:{i:0;s:3:\"uid\";}}s:6:\"search\";a:6:{s:3:\"url\";s:19:\"/search/[keywords]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:23:\"|^/search/([^/]+)[/]?$|\";s:6:\"format\";s:11:\"/search/%s/\";s:6:\"params\";a:1:{i:0;s:8:\"keywords\";}}s:10:\"index_page\";a:6:{s:3:\"url\";s:21:\"/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:22:\"|^/page/([0-9]+)[/]?$|\";s:6:\"format\";s:9:\"/page/%s/\";s:6:\"params\";a:1:{i:0;s:4:\"page\";}}s:12:\"archive_page\";a:6:{s:3:\"url\";s:26:\"/blog/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:27:\"|^/blog/page/([0-9]+)[/]?$|\";s:6:\"format\";s:14:\"/blog/page/%s/\";s:6:\"params\";a:1:{i:0;s:4:\"page\";}}s:13:\"category_page\";a:6:{s:3:\"url\";s:32:\"/category/[slug]/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:34:\"|^/category/([^/]+)/([0-9]+)[/]?$|\";s:6:\"format\";s:16:\"/category/%s/%s/\";s:6:\"params\";a:2:{i:0;s:4:\"slug\";i:1;s:4:\"page\";}}s:8:\"tag_page\";a:6:{s:3:\"url\";s:27:\"/tag/[slug]/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:29:\"|^/tag/([^/]+)/([0-9]+)[/]?$|\";s:6:\"format\";s:11:\"/tag/%s/%s/\";s:6:\"params\";a:2:{i:0;s:4:\"slug\";i:1;s:4:\"page\";}}s:11:\"author_page\";a:6:{s:3:\"url\";s:37:\"/author/[uid:digital]/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:33:\"|^/author/([0-9]+)/([0-9]+)[/]?$|\";s:6:\"format\";s:14:\"/author/%s/%s/\";s:6:\"params\";a:2:{i:0;s:3:\"uid\";i:1;s:4:\"page\";}}s:11:\"search_page\";a:6:{s:3:\"url\";s:34:\"/search/[keywords]/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:32:\"|^/search/([^/]+)/([0-9]+)[/]?$|\";s:6:\"format\";s:14:\"/search/%s/%s/\";s:6:\"params\";a:2:{i:0;s:8:\"keywords\";i:1;s:4:\"page\";}}s:12:\"archive_year\";a:6:{s:3:\"url\";s:18:\"/[year:digital:4]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:19:\"|^/([0-9]{4})[/]?$|\";s:6:\"format\";s:4:\"/%s/\";s:6:\"params\";a:1:{i:0;s:4:\"year\";}}s:13:\"archive_month\";a:6:{s:3:\"url\";s:36:\"/[year:digital:4]/[month:digital:2]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:30:\"|^/([0-9]{4})/([0-9]{2})[/]?$|\";s:6:\"format\";s:7:\"/%s/%s/\";s:6:\"params\";a:2:{i:0;s:4:\"year\";i:1;s:5:\"month\";}}s:11:\"archive_day\";a:6:{s:3:\"url\";s:52:\"/[year:digital:4]/[month:digital:2]/[day:digital:2]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:41:\"|^/([0-9]{4})/([0-9]{2})/([0-9]{2})[/]?$|\";s:6:\"format\";s:10:\"/%s/%s/%s/\";s:6:\"params\";a:3:{i:0;s:4:\"year\";i:1;s:5:\"month\";i:2;s:3:\"day\";}}s:17:\"archive_year_page\";a:6:{s:3:\"url\";s:38:\"/[year:digital:4]/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:33:\"|^/([0-9]{4})/page/([0-9]+)[/]?$|\";s:6:\"format\";s:12:\"/%s/page/%s/\";s:6:\"params\";a:2:{i:0;s:4:\"year\";i:1;s:4:\"page\";}}s:18:\"archive_month_page\";a:6:{s:3:\"url\";s:56:\"/[year:digital:4]/[month:digital:2]/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:44:\"|^/([0-9]{4})/([0-9]{2})/page/([0-9]+)[/]?$|\";s:6:\"format\";s:15:\"/%s/%s/page/%s/\";s:6:\"params\";a:3:{i:0;s:4:\"year\";i:1;s:5:\"month\";i:2;s:4:\"page\";}}s:16:\"archive_day_page\";a:6:{s:3:\"url\";s:72:\"/[year:digital:4]/[month:digital:2]/[day:digital:2]/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:55:\"|^/([0-9]{4})/([0-9]{2})/([0-9]{2})/page/([0-9]+)[/]?$|\";s:6:\"format\";s:18:\"/%s/%s/%s/page/%s/\";s:6:\"params\";a:4:{i:0;s:4:\"year\";i:1;s:5:\"month\";i:2;s:3:\"day\";i:3;s:4:\"page\";}}s:12:\"comment_page\";a:6:{s:3:\"url\";s:53:\"[permalink:string]/comment-page-[commentPage:digital]\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:36:\"|^(.+)/comment\\-page\\-([0-9]+)[/]?$|\";s:6:\"format\";s:18:\"%s/comment-page-%s\";s:6:\"params\";a:2:{i:0;s:9:\"permalink\";i:1;s:11:\"commentPage\";}}s:4:\"feed\";a:6:{s:3:\"url\";s:20:\"/feed[feed:string:0]\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:4:\"feed\";s:4:\"regx\";s:17:\"|^/feed(.*)[/]?$|\";s:6:\"format\";s:7:\"/feed%s\";s:6:\"params\";a:1:{i:0;s:4:\"feed\";}}s:8:\"feedback\";a:6:{s:3:\"url\";s:31:\"[permalink:string]/[type:alpha]\";s:6:\"widget\";s:15:\"Widget_Feedback\";s:6:\"action\";s:6:\"action\";s:4:\"regx\";s:29:\"|^(.+)/([_0-9a-zA-Z-]+)[/]?$|\";s:6:\"format\";s:5:\"%s/%s\";s:6:\"params\";a:2:{i:0;s:9:\"permalink\";i:1;s:4:\"type\";}}s:4:\"page\";a:6:{s:3:\"url\";s:12:\"/[slug].html\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";s:4:\"regx\";s:22:\"|^/([^/]+)\\.html[/]?$|\";s:6:\"format\";s:8:\"/%s.html\";s:6:\"params\";a:1:{i:0;s:4:\"slug\";}}s:10:\"rest_posts\";a:6:{s:3:\"url\";s:10:\"/api/posts\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:11:\"postsAction\";s:4:\"regx\";s:18:\"|^/api/posts[/]?$|\";s:6:\"format\";s:10:\"/api/posts\";s:6:\"params\";a:0:{}}s:10:\"rest_pages\";a:6:{s:3:\"url\";s:10:\"/api/pages\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:11:\"pagesAction\";s:4:\"regx\";s:18:\"|^/api/pages[/]?$|\";s:6:\"format\";s:10:\"/api/pages\";s:6:\"params\";a:0:{}}s:15:\"rest_categories\";a:6:{s:3:\"url\";s:15:\"/api/categories\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:16:\"categoriesAction\";s:4:\"regx\";s:23:\"|^/api/categories[/]?$|\";s:6:\"format\";s:15:\"/api/categories\";s:6:\"params\";a:0:{}}s:9:\"rest_tags\";a:6:{s:3:\"url\";s:9:\"/api/tags\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:10:\"tagsAction\";s:4:\"regx\";s:17:\"|^/api/tags[/]?$|\";s:6:\"format\";s:9:\"/api/tags\";s:6:\"params\";a:0:{}}s:9:\"rest_post\";a:6:{s:3:\"url\";s:9:\"/api/post\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:10:\"postAction\";s:4:\"regx\";s:17:\"|^/api/post[/]?$|\";s:6:\"format\";s:9:\"/api/post\";s:6:\"params\";a:0:{}}s:13:\"rest_comments\";a:6:{s:3:\"url\";s:13:\"/api/comments\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:14:\"commentsAction\";s:4:\"regx\";s:21:\"|^/api/comments[/]?$|\";s:6:\"format\";s:13:\"/api/comments\";s:6:\"params\";a:0:{}}s:12:\"rest_comment\";a:6:{s:3:\"url\";s:12:\"/api/comment\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:13:\"commentAction\";s:4:\"regx\";s:20:\"|^/api/comment[/]?$|\";s:6:\"format\";s:12:\"/api/comment\";s:6:\"params\";a:0:{}}s:13:\"rest_settings\";a:6:{s:3:\"url\";s:13:\"/api/settings\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:14:\"settingsAction\";s:4:\"regx\";s:21:\"|^/api/settings[/]?$|\";s:6:\"format\";s:13:\"/api/settings\";s:6:\"params\";a:0:{}}s:10:\"rest_users\";a:6:{s:3:\"url\";s:10:\"/api/users\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:11:\"usersAction\";s:4:\"regx\";s:18:\"|^/api/users[/]?$|\";s:6:\"format\";s:10:\"/api/users\";s:6:\"params\";a:0:{}}s:13:\"rest_archives\";a:6:{s:3:\"url\";s:13:\"/api/archives\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:14:\"archivesAction\";s:4:\"regx\";s:21:\"|^/api/archives[/]?$|\";s:6:\"format\";s:13:\"/api/archives\";s:6:\"params\";a:0:{}}}s:5:\"index\";a:3:{s:3:\"url\";s:1:\"/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:7:\"archive\";a:3:{s:3:\"url\";s:6:\"/blog/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:2:\"do\";a:3:{s:3:\"url\";s:22:\"/action/[action:alpha]\";s:6:\"widget\";s:9:\"Widget_Do\";s:6:\"action\";s:6:\"action\";}s:4:\"post\";a:3:{s:3:\"url\";s:24:\"/archives/[cid:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:10:\"attachment\";a:3:{s:3:\"url\";s:26:\"/attachment/[cid:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:8:\"category\";a:3:{s:3:\"url\";s:17:\"/category/[slug]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:3:\"tag\";a:3:{s:3:\"url\";s:12:\"/tag/[slug]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:6:\"author\";a:3:{s:3:\"url\";s:22:\"/author/[uid:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:6:\"search\";a:3:{s:3:\"url\";s:19:\"/search/[keywords]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:10:\"index_page\";a:3:{s:3:\"url\";s:21:\"/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:12:\"archive_page\";a:3:{s:3:\"url\";s:26:\"/blog/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:13:\"category_page\";a:3:{s:3:\"url\";s:32:\"/category/[slug]/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:8:\"tag_page\";a:3:{s:3:\"url\";s:27:\"/tag/[slug]/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:11:\"author_page\";a:3:{s:3:\"url\";s:37:\"/author/[uid:digital]/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:11:\"search_page\";a:3:{s:3:\"url\";s:34:\"/search/[keywords]/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:12:\"archive_year\";a:3:{s:3:\"url\";s:18:\"/[year:digital:4]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:13:\"archive_month\";a:3:{s:3:\"url\";s:36:\"/[year:digital:4]/[month:digital:2]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:11:\"archive_day\";a:3:{s:3:\"url\";s:52:\"/[year:digital:4]/[month:digital:2]/[day:digital:2]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:17:\"archive_year_page\";a:3:{s:3:\"url\";s:38:\"/[year:digital:4]/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:18:\"archive_month_page\";a:3:{s:3:\"url\";s:56:\"/[year:digital:4]/[month:digital:2]/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:16:\"archive_day_page\";a:3:{s:3:\"url\";s:72:\"/[year:digital:4]/[month:digital:2]/[day:digital:2]/page/[page:digital]/\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:12:\"comment_page\";a:3:{s:3:\"url\";s:53:\"[permalink:string]/comment-page-[commentPage:digital]\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:4:\"feed\";a:3:{s:3:\"url\";s:20:\"/feed[feed:string:0]\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:4:\"feed\";}s:8:\"feedback\";a:3:{s:3:\"url\";s:31:\"[permalink:string]/[type:alpha]\";s:6:\"widget\";s:15:\"Widget_Feedback\";s:6:\"action\";s:6:\"action\";}s:4:\"page\";a:3:{s:3:\"url\";s:12:\"/[slug].html\";s:6:\"widget\";s:14:\"Widget_Archive\";s:6:\"action\";s:6:\"render\";}s:10:\"rest_posts\";a:3:{s:3:\"url\";s:10:\"/api/posts\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:11:\"postsAction\";}s:10:\"rest_pages\";a:3:{s:3:\"url\";s:10:\"/api/pages\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:11:\"pagesAction\";}s:15:\"rest_categories\";a:3:{s:3:\"url\";s:15:\"/api/categories\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:16:\"categoriesAction\";}s:9:\"rest_tags\";a:3:{s:3:\"url\";s:9:\"/api/tags\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:10:\"tagsAction\";}s:9:\"rest_post\";a:3:{s:3:\"url\";s:9:\"/api/post\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:10:\"postAction\";}s:13:\"rest_comments\";a:3:{s:3:\"url\";s:13:\"/api/comments\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:14:\"commentsAction\";}s:12:\"rest_comment\";a:3:{s:3:\"url\";s:12:\"/api/comment\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:13:\"commentAction\";}s:13:\"rest_settings\";a:3:{s:3:\"url\";s:13:\"/api/settings\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:14:\"settingsAction\";}s:10:\"rest_users\";a:3:{s:3:\"url\";s:10:\"/api/users\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:11:\"usersAction\";}s:13:\"rest_archives\";a:3:{s:3:\"url\";s:13:\"/api/archives\";s:6:\"widget\";s:14:\"Restful_Action\";s:6:\"action\";s:14:\"archivesAction\";}}'),
('secret', 0, '2ejc9tw*kO^vPyY&NSs7Kt$h3dcWtnXP'),
('siteUrl', 0, 'http://localhost:2333'),
('theme', 0, 'default'),
('theme:default', 0, 'a:2:{s:7:\"logoUrl\";N;s:12:\"sidebarBlock\";a:5:{i:0;s:15:\"ShowRecentPosts\";i:1;s:18:\"ShowRecentComments\";i:2;s:12:\"ShowCategory\";i:3;s:11:\"ShowArchive\";i:4;s:9:\"ShowOther\";}}'),
('timezone', 0, '28800'),
('title', 0, 'Hello World'),
('xmlrpcMarkdown', 0, '0');
DROP TABLE IF EXISTS `typecho_relationships`;
CREATE TABLE `typecho_relationships` (
`cid` int(10) unsigned NOT NULL,
`mid` int(10) unsigned NOT NULL,
PRIMARY KEY (`cid`,`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `typecho_relationships` (`cid`, `mid`) VALUES
(1, 1),
(1, 2),
(1, 4);
DROP TABLE IF EXISTS `typecho_users`;
CREATE TABLE `typecho_users` (
`uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) DEFAULT NULL,
`password` varchar(64) DEFAULT NULL,
`mail` varchar(150) DEFAULT NULL,
`url` varchar(150) DEFAULT NULL,
`screenName` varchar(32) DEFAULT NULL,
`created` int(10) unsigned DEFAULT '0',
`activated` int(10) unsigned DEFAULT '0',
`logged` int(10) unsigned DEFAULT '0',
`group` varchar(16) DEFAULT 'visitor',
`authCode` varchar(64) DEFAULT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `mail` (`mail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `typecho_users` (`uid`, `name`, `password`, `mail`, `url`, `screenName`, `created`, `activated`, `logged`, `group`, `authCode`) VALUES
(1, 'admin', '$P$BD5WcZVsOvI2QjiBDuDSNKbPzjByyx1', 'webmaster@yourdomain.com', 'http://www.typecho.org', 'admin', 1516520053, 1516585496, 1516521817, 'administrator', '07893aeff14bc33b097f49b47c82fe2b');
-- 2018-01-22 01:45:27
Reference in New Issue View Git Blame Copy Permalink