{"id":28,"date":"2009-07-16T08:46:53","date_gmt":"2009-07-16T00:46:53","guid":{"rendered":"http:\/\/www.magki.com\/blog\/?p=28"},"modified":"2009-07-16T08:51:15","modified_gmt":"2009-07-16T00:51:15","slug":"rebuild-tinypad","status":"publish","type":"post","link":"http:\/\/www.ijony.com\/blog\/2009\/07\/rebuild-tinypad.html","title":{"rendered":"\u91cd\u65b0\u67b6\u6784 TinyPad"},"content":{"rendered":"

\u81ea\u4ece\u5230\u4e86\u6df1\u5733\u627e\u5230\u5de5\u4f5c\u540e\u5c31\u4e00\u76f4\u65e0\u6687\u987e\u53ca\u6599\u7406\u8fd9\u4e2a\u535a\u5ba2\uff0c\u66f4\u522b\u8bf4\u5c06 TinyPad \u201c\u5584\u7ec8\u201d\u4e86\u3002\u5728\u516c\u53f8\u5b8c\u6210\u4e86\u51e0\u4e2a\u9879\u76ee\u540e\uff0c\u53c8\u5b66\u5230\u4e0d\u5c11\u67b6\u6784\u65b9\u9762\u7684\u7ecf\u9a8c\uff0c\u5f92\u7684\u4e00\u4e0b\u5b50\u627e\u5230\u4e86\u89e3\u51b3\u4ee5\u524d\u4e00\u76f4\u56f0\u6270\u81ea\u5df1\u7684 post \u4e0e talk \u6df7\u5408\u8f93\u51fa\u7684\u95ee\u9898\uff0c\u5176\u5b9e\u5f88\u7b80\u5355\uff0c\u5c31\u662f\u589e\u52a0\u4e00\u4e2a\u5e8f\u5217\u8868\u5c31\u53ef\u4ee5\u4e86\uff0c\u4ee5\u524d\u548b\u5c31\u6ca1\u5f80\u8fd9\u601d\u8def\u4e0a\u8d70\u634f\uff0c\u54ce\u2026\u2026\u521b\u610f\u532e\u4e4f\u4e9a\u3002<\/p>\n

\u4e8e\u662f\u4fbf\u5b8c\u6210\u4e86\u5982\u4e0b\u5efa\u8868\uff0c\u672c\u6765\u60f3\u5c06\u8868\u7c7b\u578b\u5efa\u6210 InnoDB \u5e76\u8bbe\u7f6e\u5916\u952e\u7684\uff0c\u540e\u6765\u60f3\u60f3\u8fd9\u6837\u4f5c\u7528\u4e0d\u5927\u53cd\u800c\u67d0\u4e9b\u65b9\u9762\u4e0d\u597d\u7528\u4e86\uff0c\u624d\u53c8\u4f5c\u7f62\u3002<\/p>\n

<\/p>\n

CREATE TABLE IF NOT EXISTS `mc_entries` (
\n    `entryid` bigint(20) NOT NULL AUTO_INCREMENT,
\n    `cateid` bigint(20) NOT NULL DEFAULT ‘0’,
\n    `tagid` varchar(255) NOT NULL DEFAULT ”,
\n    `title` varchar(255) NOT NULL DEFAULT ”,
\n    `slug` varchar(255) NOT NULL DEFAULT ”,
\n    `pubdate` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
\n    `modified` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
\n    `summary` text NOT NULL,
\n    `content` longtext NOT NULL,
\n    `downurls` text NOT NULL,
\n    `pinged` text NOT NULL,
\n    `type` enum(‘blog’,’talk’,’down’) NOT NULL DEFAULT ‘blog’,
\n    `state` enum(‘published’,’draft’) NOT NULL DEFAULT ‘draft’,
\n    `feedback` enum(‘all’,’comm’,’trac’,’close’) NOT NULL DEFAULT ‘all’,
\n    `feedback_count` bigint(20) NOT NULL DEFAULT ‘0’,
\n    PRIMARY KEY (`entryid`),
\n    KEY `type` (`type`),
\n    KEY `state` (`state`)
\n) ENGINE=MyISAM;<\/p>\n

CREATE TABLE IF NOT EXISTS `mc_posts` (
\n    `postid` bigint(20) NOT NULL AUTO_INCREMENT,
\n    `entryid` bigint(20) NOT NULL DEFAULT ‘0’,
\n    PRIMARY KEY (`postid`)
\n) ENGINE=MyISAM;<\/p>\n

CREATE TABLE IF NOT EXISTS `mc_talks` (
\n    `talkid` bigint(20) NOT NULL AUTO_INCREMENT,
\n    `entryid` bigint(20) NOT NULL DEFAULT ‘0’,
\n    PRIMARY KEY (`talkid`)
\n) ENGINE=MyISAM;<\/p>\n

CREATE TABLE IF NOT EXISTS `mc_downs` (
\n    `downid` bigint(20) NOT NULL AUTO_INCREMENT,
\n    `entryid` bigint(20) NOT NULL DEFAULT ‘0’,
\n    PRIMARY KEY (`downid`)
\n) ENGINE=MyISAM;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

\u81ea\u4ece\u5230\u4e86\u6df1\u5733\u627e\u5230\u5de5\u4f5c\u540e\u5c31\u4e00\u76f4\u65e0\u6687\u987e\u53ca\u6599\u7406\u8fd9\u4e2a\u535a\u5ba2\uff0c\u66f4\u522b\u8bf4\u5c06 TinyPad \u201c\u5584\u7ec8\u201d\u4e86\u3002\u5728\u516c\u53f8\u5b8c\u6210\u4e86\u51e0\u4e2a\u9879\u76ee\u540e […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/posts\/28"}],"collection":[{"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/comments?post=28"}],"version-history":[{"count":0,"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/posts\/28\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/media?parent=28"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/categories?post=28"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ijony.com\/blog\/wp-json\/wp\/v2\/tags?post=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}