jfast/init.sql at master · xjt520/jfast · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
# ************************************************************
# Sequel Pro SQL dump
# Version 4499
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: rm-2zeo46gri4002893no.mysql.rds.aliyuncs.com (MySQL 5.6.16-log)
# Database: nbst
# Generation Time: 2016-06-20 09:18:25 +0000
# ************************************************************


/*!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 */;
/*!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 */;


# Dump of table category
# ------------------------------------------------------------

DROP TABLE IF EXISTS `category`;

CREATE TABLE `category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '分类名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;

INSERT INTO `category` (`id`, `name`)
VALUES
	(1,X'E696B0E997BB'),
	(2,X'E4BAA7E59381');

/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table posts
# ------------------------------------------------------------

DROP TABLE IF EXISTS `posts`;

CREATE TABLE `posts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `postTitle` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '标题',
  `postAuthor` int(11) DEFAULT NULL COMMENT '对应作者ID',
  `postContent` text COLLATE utf8_bin COMMENT '正文',
  `postExcerpt` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '摘要',
  `postStatus` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '文章状态（publish/auto-draft/inherit等）',
  `postDate` timestamp NULL DEFAULT NULL COMMENT '发布时间',
  `postModified` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `postCategory` int(11) DEFAULT NULL COMMENT '分类ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;

INSERT INTO `posts` (`id`, `postTitle`, `postAuthor`, `postContent`, `postExcerpt`, `postStatus`, `postDate`, `postModified`, `postCategory`)
VALUES
	(4,X'E6B19FE58D97E79AAEE99DA9E58E82E58092E997ADE4BA86',NULL,X'3C703E3C696D67207372633D22687474703A2F2F696D672E62616964752E636F6D2F68692F6A78322F6A5F303030342E676966222F3E3C696D67207372633D22687474703A2F2F696D672E62616964752E636F6D2F68692F6A78322F6A5F303030322E676966222F3E3C696D67207372633D22687474703A2F2F696D672E62616964752E636F6D2F68692F6A78322F6A5F303030382E676966222F3E3C696D67207372633D22687474703A2F2F696D672E62616964752E636F6D2F68692F6A78322F6A5F303031322E676966222F3E3C2F703E',X'E6B19FE58D97E79AAEE99DA9E58E82E58092E997ADE4BA862CE891A3E4BA8BE995BFE9BB84E9B9A4E5B8A6E79D80E5B08FE5A7A8E5AD90E8B791E8B7AFE4BA86',NULL,'2016-05-28 12:08:37','2016-06-10 20:10:58',2),
	(6,X'68656C6C6F20776F726C64',NULL,X'3C703E68656C6C6F20776F726C64202121213C2F703E3C703E68656C6C6F20776F726C64202121213C2F703E3C703E68656C6C6F20776F726C64202121213C2F703E',X'68656C6C6F20776F726C6420212121',NULL,'2016-05-28 12:11:23','2016-06-10 20:10:50',1),
	(17,X'33',NULL,X'3C703E3C696D67207372633D22687474703A2F2F696D672E62616964752E636F6D2F68692F6A78322F6A5F303036392E676966222F3E3C2F703E',X'33',NULL,'2016-06-10 20:11:48','2016-06-10 20:11:48',1),
	(18,X'3131',NULL,X'3C703E3C696D6720616C743D22312E6A706722207372633D22687474703A2F2F726561647368652E636F6D2F6E6273742F7265732F75656469746F722F6A73702F75706C6F61642F696D6167652F32303136303631302F313436353536323431353432383033353434342E6A706722207469746C653D22313436353536323431353432383033353434342E6A7067222F3E3C2F703E',X'3131',NULL,'2016-06-10 20:43:24','2016-06-10 20:43:24',1);

/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;


/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;