mysql1714,mysql.sql

浅浅的花香味﹌ 2023-01-14 04:55 96阅读 0赞

\-- 适用于MySQL5.6.5+

\-- 备注：5.5.3开始支持utf8mb4，5.6.5开始支持CURRENT\_TIMESTAMP(datetime)

CREATE DATABASE IF NOT EXISTS \`torna\` DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4\_general\_ci;

USE \`torna\`;

DROP TABLE IF EXISTS \`user\_subscribe\`;

DROP TABLE IF EXISTS \`user\_message\`;

DROP TABLE IF EXISTS \`user\_info\`;

DROP TABLE IF EXISTS \`space\_user\`;

DROP TABLE IF EXISTS \`space\`;

DROP TABLE IF EXISTS \`project\_user\`;

DROP TABLE IF EXISTS \`project\`;

DROP TABLE IF EXISTS \`open\_user\`;

DROP TABLE IF EXISTS \`module\_config\`;

DROP TABLE IF EXISTS \`module\`;

DROP TABLE IF EXISTS \`enum\_item\`;

DROP TABLE IF EXISTS \`enum\_info\`;

DROP TABLE IF EXISTS \`doc\_param\`;

DROP TABLE IF EXISTS \`doc\_info\`;

CREATE TABLE \`doc\_info\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`data\_id\` varchar(64) NOT NULL DEFAULT '' COMMENT '唯一id，接口规则：md5(module\_id:parent\_id:url:http\_method)。分类规则：md5(module\_id:parent\_id:name)',

\`name\` varchar(128) NOT NULL DEFAULT '' COMMENT '文档名称',

\`description\` varchar(256) NOT NULL DEFAULT '' COMMENT '文档描述',

\`url\` varchar(128) NOT NULL DEFAULT '' COMMENT '访问URL',

\`http\_method\` varchar(12) NOT NULL DEFAULT '' COMMENT 'http方法',

\`content\_type\` varchar(128) NOT NULL DEFAULT '' COMMENT 'contentType',

\`is\_folder\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否是分类，0：不是，1：是',

\`parent\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父节点',

\`module\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '模块id，module.id',

\`create\_mode\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '新增操作方式，0：人工操作，1：开放平台推送',

\`modify\_mode\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '修改操作方式，0：人工操作，1：开放平台推送',

\`creator\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',

\`creator\_name\` varchar(64) NOT NULL DEFAULT '' COMMENT '创建者昵称user\_info.nickname',

\`modifier\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '修改人',

\`modifier\_name\` varchar(64) NOT NULL DEFAULT '' COMMENT '创建者昵称user\_info.realname',

\`order\_index\` int(11) NOT NULL DEFAULT '0' COMMENT '排序索引',

\`remark\` varchar(128) NOT NULL DEFAULT '' COMMENT '备注',

\`is\_show\` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

UNIQUE KEY \`uk\_data\_id\` (\`data\_id\`) USING BTREE,

KEY \`idx\_moduleid\` (\`module\_id\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='文档信息';

CREATE TABLE \`doc\_param\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`data\_id\` varchar(64) NOT NULL DEFAULT '' COMMENT '唯一id，md5(doc\_id:parent\_id:style:name)',

\`name\` varchar(64) NOT NULL DEFAULT '' COMMENT '字段名称',

\`type\` varchar(64) NOT NULL DEFAULT 'String' COMMENT '字段类型',

\`required\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否必须，1：是，0：否',

\`max\_length\` varchar(64) NOT NULL DEFAULT '0' COMMENT '最大长度',

\`example\` varchar(128) NOT NULL DEFAULT '' COMMENT '示例值',

\`description\` varchar(256) NOT NULL DEFAULT '' COMMENT '描述',

\`enum\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'enum\_info.id',

\`doc\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'doc\_info.id',

\`parent\_id\` bigint(20) unsigned NOT NULL DEFAULT '0',

\`style\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0：path, 1：header， 2：请求参数，3：返回参数，4：错误码',

\`create\_mode\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '新增操作方式，0：人工操作，1：开放平台推送',

\`modify\_mode\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '修改操作方式，0：人工操作，1：开放平台推送',

\`creator\_id\` bigint(20) unsigned NOT NULL DEFAULT '0',

\`creator\_name\` varchar(64) NOT NULL DEFAULT '',

\`modifier\_id\` bigint(20) unsigned NOT NULL DEFAULT '0',

\`modifier\_name\` varchar(64) NOT NULL DEFAULT '',

\`order\_index\` int(11) NOT NULL DEFAULT '0' COMMENT '排序索引',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

UNIQUE KEY \`uk\_dataid\` (\`data\_id\`) USING BTREE,

KEY \`idx\_docid\` (\`doc\_id\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COMMENT='文档参数';

CREATE TABLE \`enum\_info\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`data\_id\` varchar(64) NOT NULL DEFAULT '' COMMENT '唯一id，md5(module\_id:name)',

\`name\` varchar(128) NOT NULL DEFAULT '' COMMENT '枚举名称',

\`description\` varchar(128) NOT NULL DEFAULT '' COMMENT '枚举说明',

\`module\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'module.id',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

KEY \`idx\_moduleid\` (\`module\_id\`) USING BTREE,

KEY \`idx\_dataid\` (\`data\_id\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='枚举信息';

CREATE TABLE \`enum\_item\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`enum\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'enum\_info.id',

\`name\` varchar(128) NOT NULL DEFAULT '' COMMENT '名称，字面值',

\`type\` varchar(64) NOT NULL DEFAULT '' COMMENT '类型',

\`value\` varchar(64) NOT NULL DEFAULT '' COMMENT '枚举值',

\`description\` varchar(128) NOT NULL DEFAULT '' COMMENT '枚举描述',

\`order\_index\` int(11) NOT NULL DEFAULT '0' COMMENT '排序索引',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

KEY \`idx\_enumid\` (\`enum\_id\`) USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='枚举详情';

CREATE TABLE \`module\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`name\` varchar(64) NOT NULL DEFAULT '' COMMENT '模块名称',

\`project\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'project.id',

\`type\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '模块类型，0：自定义添加，1：swagger导入，2：postman导入',

\`import\_url\` varchar(128) NOT NULL DEFAULT '' COMMENT '导入url',

\`basic\_auth\_username\` varchar(128) NOT NULL DEFAULT '' COMMENT 'basic认证用户名',

\`basic\_auth\_password\` varchar(128) NOT NULL DEFAULT '' COMMENT 'basic认证密码',

\`token\` varchar(128) NOT NULL DEFAULT '' COMMENT '开放接口调用token',

\`create\_mode\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '新增操作方式，0：人工操作，1：开放平台推送',

\`modify\_mode\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '修改操作方式，0：人工操作，1：开放平台推送',

\`creator\_id\` bigint(20) unsigned NOT NULL DEFAULT '0',

\`modifier\_id\` bigint(20) unsigned NOT NULL DEFAULT '0',

\`order\_index\` int(11) NOT NULL DEFAULT '0' COMMENT '排序索引',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

UNIQUE KEY \`uk\_token\` (\`token\`) USING BTREE,

KEY \`idx\_projectid\` (\`project\_id\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='项目模块';

CREATE TABLE \`module\_config\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`module\_id\` bigint(11) unsigned NOT NULL DEFAULT '0',

\`type\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '配置类型，1：全局header',

\`config\_key\` varchar(128) NOT NULL DEFAULT '' COMMENT '配置key',

\`config\_value\` varchar(128) NOT NULL DEFAULT '' COMMENT '配置值',

\`description\` varchar(256) NOT NULL DEFAULT '' COMMENT '描述',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

KEY \`idx\_moduleid\_type\` (\`module\_id\`,\`type\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='系统配置';

CREATE TABLE \`open\_user\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`app\_key\` varchar(100) NOT NULL COMMENT 'appKey',

\`secret\` varchar(200) DEFAULT NULL COMMENT 'secret',

\`status\` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '1启用，0禁用',

\`applicant\` varchar(64) NOT NULL DEFAULT '',

\`space\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'space.id',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

UNIQUE KEY \`uk\_app\_key\` (\`app\_key\`)

) ENGINE=InnoDB AUTO\_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='开放用户';

CREATE TABLE \`project\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`name\` varchar(64) NOT NULL DEFAULT '' COMMENT '项目名称',

\`description\` varchar(128) NOT NULL DEFAULT '' COMMENT '项目描述',

\`space\_id\` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属空间，space.id',

\`is\_private\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否私有项目，1：是，0：否',

\`creator\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建者userid',

\`creator\_name\` varchar(64) NOT NULL DEFAULT '',

\`modifier\_id\` bigint(20) unsigned NOT NULL DEFAULT '0',

\`modifier\_name\` varchar(64) NOT NULL DEFAULT '',

\`order\_index\` int(11) NOT NULL DEFAULT '0' COMMENT '排序索引',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

KEY \`uk\_name\` (\`creator\_id\`,\`name\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='项目表';

CREATE TABLE \`project\_user\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`project\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'project.id',

\`user\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'user\_info.id',

\`role\_code\` varchar(64) NOT NULL DEFAULT '0' COMMENT '角色，guest：访客，dev：开发者，admin：项目管理员',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

UNIQUE KEY \`uk\_projectid\_userid\` (\`project\_id\`,\`user\_id\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='项目用户关系表';

CREATE TABLE \`space\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`name\` varchar(64) NOT NULL DEFAULT '' COMMENT '空间名称',

\`creator\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建者userid',

\`creator\_name\` varchar(64) NOT NULL DEFAULT '',

\`modifier\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建者userid',

\`modifier\_name\` varchar(64) NOT NULL DEFAULT '',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`)

) ENGINE=InnoDB AUTO\_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='分组表';

CREATE TABLE \`space\_user\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`user\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'user\_info.id',

\`space\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'space.id',

\`role\_code\` varchar(64) NOT NULL DEFAULT '' COMMENT '角色，guest：访客，dev：开发者，admin：空间管理员',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

UNIQUE KEY \`uk\_groupid\_userid\` (\`space\_id\`,\`user\_id\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COMMENT='分组用户关系表';

CREATE TABLE \`user\_info\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`username\` varchar(128) NOT NULL DEFAULT '' COMMENT '登录账号/邮箱',

\`password\` varchar(128) NOT NULL DEFAULT '' COMMENT '登录密码',

\`nickname\` varchar(64) NOT NULL DEFAULT '' COMMENT '昵称',

\`is\_super\_admin\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否是超级管理员',

\`status\` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0：禁用，1：启用，2：重设密码',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

UNIQUE KEY \`uk\_username\` (\`username\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

CREATE TABLE \`user\_message\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`user\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'user\_info.id',

\`message\` varchar(256) NOT NULL DEFAULT '',

\`is\_read\` tinyint(4) NOT NULL DEFAULT '0',

\`type\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '同user\_subscribe.type',

\`source\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '同user\_subscribe.source\_id',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

KEY \`idx\_userid\` (\`user\_id\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='站内消息';

CREATE TABLE \`user\_subscribe\` (

\`id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT,

\`user\_id\` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'user\_info.id',

\`type\` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型，1：订阅接口，2：订阅项目',

\`source\_id\` bigint(20) NOT NULL DEFAULT '0' COMMENT '关联id，当type=1对应doc\_info.id；type=2对应project.id',

\`is\_deleted\` tinyint(4) NOT NULL DEFAULT '0',

\`gmt\_create\` datetime DEFAULT CURRENT\_TIMESTAMP,

\`gmt\_modified\` datetime DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,

PRIMARY KEY (\`id\`),

UNIQUE KEY \`uk\_userid\_type\_sourceid\` (\`user\_id\`,\`type\`,\`source\_id\`) USING BTREE

) ENGINE=InnoDB AUTO\_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='用户订阅表';

INSERT INTO \`doc\_info\` (\`id\`, \`data\_id\`, \`name\`, \`description\`, \`url\`, \`http\_method\`, \`content\_type\`, \`is\_folder\`, \`parent\_id\`, \`module\_id\`, \`create\_mode\`, \`modify\_mode\`, \`creator\_id\`, \`creator\_name\`, \`modifier\_id\`, \`modifier\_name\`, \`order\_index\`, \`remark\`, \`is\_show\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,'5fa7cd78bc872cd8fdc09ee3d6afedd2','故事接口','','','','',1,0,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(2,'3292c28718c1e74d6e14e0160eecf379','获取分类信息','','/story/category/get/v1','POST','application/json',0,1,1,0,0,3,'',1,'超级管理员',0,'',1,0,'2020-12-15 10:01:48','2021-01-19 17:03:29'),

(3,'48ae195650ab5cd4d521b62704d15b57','忽略签名验证','','/story/get/ignore/v1','POST','application/json',0,1,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(4,'d623ea4fe35e903a42530643e6087795','获取故事信息(首位)','','/story/get/v1','POST','application/json',0,1,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(5,'1319b1ba77712fc4c6668d04b05fd68a','获取故事信息','','/story/get/v2','POST','application/json',0,1,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(6,'3a15e3407182ccf902b6e9f5c1b1b875','返回数组结果(第二)','','/story/list/v1','POST','application/json',0,1,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(7,'fa3324c4dd6b978434f8541f73393118','树状返回','','/story/tree/v1','POST','application/json',0,1,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(8,'ac0c66314833ef010bf7df1cf5692b43','传递token','','/token','POST','application/json',0,1,1,0,0,3,'',1,'',0,'',1,0,'2020-12-15 10:01:48','2021-01-19 17:03:30'),

(9,'7ededf48dec7c2b582affe2d08d7d0b2','文件上传','','','','',1,0,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(10,'84d41cbee05d97aa568b7a06759cc19c','文件上传例1','','/upload/file1','POST','multipart/form-data',0,9,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(11,'1172c623f531324750aad5c2fa72a751','文件上传例2','','/upload/file2','POST','multipart/form-data',0,9,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(12,'92d2fa5b0ae7a0f2e29648929c5e435f','文件下载','','','','',1,0,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(13,'f184470a11e0fd559e1f56294b53d4cb','文件下载','','/download/file1','POST','application/json',0,12,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(14,'3f3aab998c9785fe13d41e02c95f7ef4','食物接口','','','','',1,0,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(15,'4942c1bd41bbf75d995722986f70a9f4','获取食物','','/food/getFoodById','GET','',0,14,1,0,0,3,'',3,'',0,'',1,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(16,'940818d032209bc3628895d483463ce1','获取用户接口','获取用户接口','get/group/\{groupId\}/id/\{id\}','GET','',0,0,2,0,0,12,'李四',1,'超级管理员',0,'ccc',1,0,'2020-12-15 10:15:55','2021-01-18 15:05:16'),

(17,'2df0b4e87fc3a8c37d08e3d7a95d0cf4','comment','','phoenix/web/v1/comment/list/101426186','GET','',0,0,1,0,0,2,'研发一部经理',1,'研发一部经理',0,'',1,1,'2021-01-19 17:29:23','2021-01-22 11:52:21');

INSERT INTO \`doc\_param\` (\`id\`, \`data\_id\`, \`name\`, \`type\`, \`required\`, \`max\_length\`, \`example\`, \`description\`, \`enum\_id\`, \`doc\_id\`, \`parent\_id\`, \`style\`, \`create\_mode\`, \`modify\_mode\`, \`creator\_id\`, \`creator\_name\`, \`modifier\_id\`, \`modifier\_name\`, \`order\_index\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,'9cedd1b23736a816e96bca9603c2b5f4','categoryName','string',0,'-','娱乐','分类名称',0,2,0,2,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(2,'df34a965ab9c44e2e6b0b282c711e9b9','createTime','string',0,'-','2019-09-25 17:12:52','创建时间',0,2,0,2,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(3,'841d66d19b087e9982b76ba0a0aab7a4','storyParam','object',0,'-','','',0,2,0,2,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(4,'ae90af481f84971aff6d1457b11609d5','id','integer',0,'-','111','故事ID',0,2,3,2,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(5,'b4bd22cc240b23325eb3bfeadab642e3','remark','string',0,'64','xx','备注 (第二)',0,2,3,2,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(6,'5d13d5536d163c8a165f613b7d678f76','name','string',1,'20','白雪公主','故事名称',0,2,3,2,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(7,'f3a0327795da96eb4955ea525b64cb20','categoryName','string',0,'-','娱乐','分类名称',0,2,0,3,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(8,'b63b34c6077d10ca10d3a5d6a5001828','storyResult','object',0,'-','','分类故事',0,2,0,3,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(9,'a8ccc97411881fa1be3086800d199ecc','gmt\_create','string',0,'-','2019-04-14 19:02:12','创建时间',0,2,8,3,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(10,'bedf8a65ba8809d6603e013e57b2832c','id','integer',0,'-','1','故事ID',0,2,8,3,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(11,'b48f0fb65540b52e13ce16b515f758cc','name','string',0,'-','海底小纵队','故事名称',0,2,8,3,0,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 10:01:48','2021-01-19 16:39:35'),

(12,'2e5aa28eade28333f5564a9abb759e83','id','integer',0,'-','111','故事ID',0,3,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(13,'6248cfafe3b1491846475d5f8e20e248','remark','string',0,'-','xx','备注 (第二)',0,3,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(14,'6c3c6428f5853b3b0fb6639552519dd6','name','string',0,'-','白雪公主','故事名称',0,3,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(15,'eda2c2531888b200aceb76b5f6596b6a','gmt\_create','string',0,'-','2019-04-14 19:02:12','创建时间',0,3,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(16,'30dd8d1e23a460172d35a6a65a30262c','id','integer',0,'-','1','故事ID',0,3,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(17,'593b2b0cb3eb79276b02dcf8ab56eb63','name','string',0,'-','海底小纵队','故事名称',0,3,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(18,'d28b974ec3fe2bad4b934c696c4d96c8','id','integer',0,'-','111','故事ID',0,4,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(19,'cb37ba05364c6a2e0acf059f5c9d3533','remark','string',0,'64','xx','备注 (第二)',0,4,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(20,'014141306e4e9d2497b3f261152f585a','name','string',1,'20','白雪公主','故事名称',0,4,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(21,'40172ca4277e0c52a5a662e879109161','gmt\_create','string',0,'-','2019-04-14 19:02:12','创建时间',0,4,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(22,'d3f4a37bc011a373bbf6bcfcc8e4608f','id','integer',0,'-','1','故事ID',0,4,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(23,'c508f91b8ff7aede0f7ac39fbb8dd2fb','name','string',0,'-','海底小纵队','故事名称',0,4,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(24,'cac09a927ec388edfc19dd1039641d67','id','integer',0,'-','111','故事ID',0,5,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(25,'339101d3efffe3160dac1ecae7871c4b','remark','string',0,'64','xx','备注 (第二)',0,5,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(26,'88fc4120e465887ab41b9ca91da87bb3','name','string',1,'20','白雪公主','故事名称',0,5,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(27,'9e65ce76eb39ad0f82095929482e7693','gmt\_create','string',0,'-','2019-04-14 19:02:12','创建时间',0,5,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(28,'da337cdcf39f1ce880850a3189cf660b','id','integer',0,'-','1','故事ID',0,5,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(29,'be0c8d746c7e16c0adfcf0104676a9ff','name','string',0,'-','海底小纵队','故事名称',0,5,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(30,'46daac3b859ef0d48650f1162311c6a0','id','integer',0,'-','111','故事ID',0,6,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(31,'6a08c7298b39910d2a1c1a0ba9fc1f1d','remark','string',0,'64','xx','备注 (第二)',0,6,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(32,'4301980bc8dc1d8e14fadfb31a9ec85a','name','string',1,'20','白雪公主','故事名称',0,6,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(33,'4561245e7c6e270233ed6595f6e818b5','StoryResult','array',0,'-','','',0,6,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(34,'8c181ef7670cdfd45d80d6698200b7b8','gmt\_create','string',0,'-','2019-04-14 19:02:12','创建时间',0,6,33,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(35,'b7c676a3e2783b2709b7ec4accf375b6','id','integer',0,'-','1','故事ID',0,6,33,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(36,'051b23a59ff6a74ad79122fc2230422e','name','string',0,'-','海底小纵队','故事名称',0,6,33,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(37,'5533aa3704c7b4518471f5a326f47551','id','integer',0,'-','111','故事ID',0,7,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(38,'f0f92b425a93640fb206bfb0902b1366','remark','string',0,'64','xx','备注 (第二)',0,7,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(39,'112d37f2c76b5b0251949cac69d68fe1','name','string',1,'20','白雪公主','故事名称',0,7,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(40,'dd4a92a31102d4220ffb7cca2b1714e7','children','array',0,'-','','子节点',0,7,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(41,'61c83cc34f795b1bcd8a92dd45a5d2e7','children','object',0,'-','','子节点',0,7,40,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(42,'4f54764326fd4743e55850149891308c','id','integer',0,'-','','id',0,7,40,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(43,'cbe98e824b7a32fd86cd9dd160292d06','name','string',0,'-','','名称',0,7,40,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(44,'bcda07eff74d7fe716899745136d9253','pid','integer',0,'-','','父id',0,7,40,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(45,'a4f91fa41249fe004bbd76c972257b85','id','integer',0,'-','','id',0,7,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(46,'41849928604437f4478c6a8d163b0442','name','string',0,'-','','名称',0,7,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(47,'0b3b92569b57c5a027cefacd4c932a26','pid','integer',0,'-','','父id',0,7,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(48,'20ff1b4db324d1b09cf59c690c1aae03','id','integer',0,'-','111','故事ID',0,8,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(49,'c6456cfdda2dc41104a27618852b3f1f','remark','string',0,'64','xx','备注 (第二)',0,8,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(50,'54722d47865c573c3671527e22797319','name','string',1,'20','白雪公主','故事名称',0,8,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(51,'0d757e958fc3fa7665a8b8eabc212303','gmt\_create','string',0,'-','2019-04-14 19:02:12','创建时间',0,8,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(52,'a4fa420275434607ba73f33e2152422f','id','integer',0,'-','1','故事ID',0,8,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(53,'b8d81b117a75d84d6ff87d569c366ae6','name','string',0,'-','海底小纵队','故事名称',0,8,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(54,'f5c01b74aee2f850e7d7e06833241acc','file1','file',1,'-','','文件1',0,10,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(55,'e98f7c9c934e4867f563e1b9b01b5cba','file2','file',1,'-','','文件2',0,10,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(56,'f30ba8fb274890cc3f85a03f6e00d921','remark','string',0,'-','','',0,10,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(57,'5c8ba24461e3947251047e5d06d1fa1a','files','array',0,'-','','',0,10,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(58,'be3e412c33827b677b953bea02711246','content','string',0,'-','啊啊啊','文件内容',0,10,57,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(59,'8cd5101036784bf60ccb9a2faf9f577d','filename','string',0,'-','1.txt','文件名称',0,10,57,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(60,'a9db899e347349533d828f64f822b020','size','integer',0,'-','109','文件大小',0,10,57,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(61,'476448d9914541d3a39280510335d9d3','remark','string',0,'-','','',0,10,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(62,'ccc42e5b6ca0526300e867bbb1d2ba08','remark','string',0,'-','','',0,11,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(63,'5a1e26b6c5784250a14780863207ea2c','files','array',0,'-','','',0,11,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(64,'7580d08580a198b1cb507078767fe924','content','string',0,'-','啊啊啊','文件内容',0,11,63,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(65,'6989d6adeeb1f8d7bc48d82d94992503','filename','string',0,'-','1.txt','文件名称',0,11,63,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(66,'ce9866be95c15c861a6ccf518249d123','size','integer',0,'-','109','文件大小',0,11,63,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(67,'eb777cbc1343e3eea07b3d4da8b35dae','remark','string',0,'-','','',0,11,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(68,'f7c99023c97bb8ff02e23044e1d4dea5','id','integer',0,'-','111','故事ID',0,13,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(69,'9d1fc88492273e49154e2e9b53f3668c','remark','string',0,'64','xx','备注 (第二)',0,13,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(70,'edebdefbc34e83211c4b177104a6298b','name','string',1,'20','白雪公主','故事名称',0,13,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(71,'b6e6da845523c535f5517f7c33bb6731','id','integer',0,'-','','id',0,15,0,2,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(72,'555b29db1207e5377f3b1ee342f4a392','id','integer',0,'-','','',0,15,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(73,'bdfdcfe4e5ee99561bb064aebfbf6751','name','string',0,'-','','',0,15,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(74,'60ba1291613b945087ae8cfe6bff1bbc','price','number',0,'-','','',0,15,0,3,0,0,3,'商城项目admin',3,'商城项目admin',0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(75,'f788250eb074c6af22cf7755ad313431','id','number',1,'64','123','用户id',0,16,0,2,0,0,12,'李四',1,'超级管理员',0,0,'2020-12-15 10:15:55','2021-01-18 15:05:16'),

(76,'fb0d734de29a47397d24d3f9ed2b6bf0','id','number',1,'64','123','用户id',0,16,0,3,0,0,12,'李四',1,'超级管理员',0,0,'2020-12-15 10:15:55','2021-01-18 15:05:16'),

(77,'e40f2386a330283bfe9a4c8f06882224','name','string',1,'64','jim','用户名称',0,16,0,3,0,0,12,'李四',1,'超级管理员',0,0,'2020-12-15 10:15:55','2021-01-18 15:05:16'),

(78,'6e3e6a9a659dbb452e1c35a87d27cafc','groupId','string',1,'64','1','分组id',0,16,0,0,0,0,11,'后台项目负责人',1,'超级管理员',0,0,'2020-12-16 15:35:09','2021-01-18 15:05:16'),

(79,'0e799f616e11beb007d4d8e9cf919a2f','id','number',1,'64','1','用户id',0,16,0,0,0,0,11,'后台项目负责人',1,'超级管理员',0,0,'2020-12-16 15:35:09','2021-01-18 15:05:16'),

(80,'9584e01340755ba6f8c82df9eb032d89','token','string',1,'64','1111','token',0,2,0,1,0,0,1,'超级管理员',1,'超级管理员',0,0,'2021-01-19 10:32:09','2021-01-19 16:39:35'),

(81,'e50bb76340fd01b339e1a2aa8d3215f3','page','string',1,'64','1','',0,17,0,2,0,0,2,'研发一部经理',2,'研发一部经理',0,0,'2021-01-19 17:29:23','2021-01-19 17:29:23'),

(82,'227be5c273852f1927611268522efa00','size','string',1,'64','10','',0,17,0,2,0,0,2,'研发一部经理',2,'研发一部经理',0,0,'2021-01-19 17:29:23','2021-01-19 17:29:23'),

(83,'14c5f6044d9ce6850dc4e1951d0151f2','commentId','string',1,'64','','',0,17,0,2,0,0,2,'研发一部经理',2,'研发一部经理',0,0,'2021-01-19 17:29:23','2021-01-19 17:29:23');

INSERT INTO \`enum\_info\` (\`id\`, \`data\_id\`, \`name\`, \`description\`, \`module\_id\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,'0b28cfdbc7f250d85614eacda8248eb4','性别','',2,0,'2020-12-16 13:57:09','2020-12-16 13:57:09');

INSERT INTO \`module\` (\`id\`, \`name\`, \`project\_id\`, \`type\`, \`import\_url\`, \`basic\_auth\_username\`, \`basic\_auth\_password\`, \`token\`, \`create\_mode\`, \`modify\_mode\`, \`creator\_id\`, \`modifier\_id\`, \`order\_index\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,'故事API',1,1,'http://localhost:2222/v2/api-docs','','','c16931fa6590483fb7a4e85340fcbfef',0,0,3,3,0,0,'2020-12-15 10:01:48','2020-12-15 10:01:48'),

(2,'用户模块',2,0,'','','','b215b7010db5451e98305152a5fa2ddf',0,0,12,12,0,0,'2020-12-15 10:14:55','2020-12-15 10:14:55');

INSERT INTO \`module\_config\` (\`id\`, \`module\_id\`, \`type\`, \`config\_key\`, \`config\_value\`, \`description\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,1,0,'debughost\_1','http://10.1.30.165:2222','',0,'2020-12-15 10:01:48','2021-01-22 11:51:05'),

(2,2,0,'debughost\_2','http://www.aaa.com','',0,'2020-12-16 15:41:14','2020-12-16 15:41:14');

INSERT INTO \`open\_user\` (\`id\`, \`app\_key\`, \`secret\`, \`status\`, \`applicant\`, \`space\_id\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,'20201215788408948171472896','WeNAdSucgduD$M?\*83?dJR&IvgU~Re75',1,'张三',0,0,'2020-12-15 14:07:21','2021-01-25 09:59:10'),

(2,'20201216788835306945118208','W.ZyGMOB9Q0UqujVxnfi@.I\#V&tUUYZR',1,'张三',9,0,'2020-12-16 18:21:33','2021-01-25 09:59:10'),

(3,'20201216788835536872669184','Bq.XRN!S0$t8!UYpWgSOl7oHlY\#XeenJ',1,'张三',9,0,'2020-12-16 18:22:28','2021-01-25 09:59:11');

INSERT INTO \`project\` (\`id\`, \`name\`, \`description\`, \`space\_id\`, \`is\_private\`, \`creator\_id\`, \`creator\_name\`, \`modifier\_id\`, \`modifier\_name\`, \`order\_index\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,'商城项目','商城项目',9,0,3,'商城项目admin',1,'超级管理员',0,0,'2020-12-15 09:56:39','2021-01-25 08:31:33'),

(2,'后台项目','后台项目',11,1,11,'后台项目负责人',11,'后台项目负责人',0,0,'2020-12-15 10:12:37','2020-12-15 10:12:37'),

(3,'测试项目','这是一个测试项目',17,1,14,'测试A',14,'测试A',0,0,'2021-01-25 09:10:47','2021-01-25 09:10:47');

INSERT INTO \`project\_user\` (\`id\`, \`project\_id\`, \`user\_id\`, \`role\_code\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,1,3,'admin',0,'2020-12-15 09:56:38','2021-01-25 08:31:33'),

(2,1,4,'dev',0,'2020-12-15 09:58:35','2021-01-25 08:31:38'),

(3,1,9,'guest',1,'2020-12-15 09:58:44','2020-12-15 09:59:01'),

(4,2,11,'admin',0,'2020-12-15 10:12:37','2020-12-15 10:12:37'),

(5,2,12,'dev',0,'2020-12-15 10:12:52','2020-12-15 10:12:52'),

(6,2,13,'guest',0,'2020-12-15 11:35:21','2020-12-15 11:35:21'),

(9,3,14,'admin',0,'2021-01-25 09:10:47','2021-01-25 09:10:47');

INSERT INTO \`space\` (\`id\`, \`name\`, \`creator\_id\`, \`creator\_name\`, \`modifier\_id\`, \`modifier\_name\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(9,'研发一部',2,'研发一部经理',2,'研发一部经理',0,'2020-12-15 09:48:13','2020-12-15 09:48:13'),

(11,'研发二部',5,'研发二部经理',5,'研发二部经理',0,'2020-12-15 10:08:39','2020-12-15 10:08:39'),

(14,'研发三部',11,'后台项目负责人',11,'后台项目负责人',1,'2020-12-16 10:04:13','2020-12-16 10:04:13'),

(16,'研发三部',11,'后台项目负责人',11,'后台项目负责人',1,'2020-12-16 10:06:20','2020-12-16 10:06:20'),

(17,'测试空间',14,'测试A',14,'测试A',0,'2021-01-25 09:10:02','2021-01-25 09:10:02');

INSERT INTO \`space\_user\` (\`id\`, \`user\_id\`, \`space\_id\`, \`role\_code\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,2,1,'admin',0,'2020-12-15 09:41:16','2020-12-15 09:41:16'),

(2,3,2,'admin',0,'2020-12-15 09:41:58','2020-12-15 09:41:58'),

(3,4,3,'admin',0,'2020-12-15 09:42:12','2020-12-15 09:42:12'),

(4,5,4,'admin',0,'2020-12-15 09:42:29','2020-12-15 09:42:29'),

(5,6,5,'admin',0,'2020-12-15 09:42:47','2020-12-15 09:42:47'),

(6,7,6,'admin',0,'2020-12-15 09:43:00','2020-12-15 09:43:00'),

(7,8,7,'admin',0,'2020-12-15 09:43:18','2020-12-15 09:43:18'),

(8,9,8,'admin',0,'2020-12-15 09:43:32','2020-12-15 09:43:32'),

(9,2,9,'admin',0,'2020-12-15 09:48:12','2020-12-15 09:48:12'),

(10,3,9,'dev',0,'2020-12-15 09:49:18','2020-12-15 09:49:18'),

(11,4,9,'dev',0,'2020-12-15 09:49:18','2020-12-15 09:49:18'),

(12,10,10,'admin',0,'2020-12-15 09:50:00','2020-12-15 09:50:00'),

(13,9,9,'guest',0,'2020-12-15 09:50:28','2020-12-15 09:50:28'),

(14,5,11,'admin',0,'2020-12-15 10:08:38','2020-12-15 10:08:38'),

(15,11,12,'admin',0,'2020-12-15 10:10:17','2020-12-15 10:10:17'),

(16,12,13,'admin',0,'2020-12-15 10:10:31','2020-12-15 10:10:31'),

(17,11,11,'dev',0,'2020-12-15 10:12:00','2020-12-15 10:12:00'),

(18,12,11,'dev',0,'2020-12-15 10:12:00','2020-12-15 10:12:00'),

(19,10,11,'guest',0,'2020-12-15 10:12:08','2020-12-15 10:12:08'),

(20,13,11,'guest',0,'2020-12-15 11:34:59','2020-12-15 11:34:59'),

(21,11,14,'admin',0,'2020-12-16 10:04:13','2020-12-16 10:04:13'),

(22,11,16,'admin',0,'2020-12-16 10:06:19','2020-12-16 10:06:19'),

(23,14,17,'admin',0,'2021-01-25 09:10:01','2021-01-25 09:10:01');

INSERT INTO \`user\_info\` (\`id\`, \`username\`, \`password\`, \`nickname\`, \`is\_super\_admin\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,'admin@torna.cn','f1e27f8ec06b0ea415583c26457dd111','超级管理员',1,0,'2020-12-15 09:04:13','2021-01-27 09:14:36'),

(2,'dev1admin@torna.cn','1231d3ef9f1a6b3771d19e3ae453b07d','研发一部经理',0,0,'2020-12-15 09:41:16','2021-01-27 09:14:36'),

(3,'dev1shop\_admin@torna.cn','8429b4b5d6ef210811a25ad6e2e47403','商城项目admin',0,0,'2020-12-15 09:41:58','2021-01-27 09:14:36'),

(4,'dev1shop\_zhangsan@torna.cn','6903a801b91e1a81247a97bf7cf6b7ee','张三',0,0,'2020-12-15 09:42:12','2021-01-27 09:14:36'),

(5,'dev2admin@torna.cn','8a73c745cd35093af0c72b5e97c7f908','研发二部经理',0,0,'2020-12-15 09:42:30','2021-01-27 09:14:36'),

(9,'dev1guest\_wangwu@torna.cn','997a3b669d4be9b034b23e620fc1c48e','王五',0,0,'2020-12-15 09:43:33','2021-01-27 09:14:36'),

(10,'dev2guest\_zhaoliu@torna.cn','db4c69808f677df84b76b902203a807e','赵六',0,0,'2020-12-15 09:50:01','2021-01-27 09:14:36'),

(11,'dev2back\_admin@torna.cn','de017957932b285ff6032a4d0c584471','后台项目负责人',0,0,'2020-12-15 10:10:17','2021-01-27 09:14:36'),

(12,'dev2back\_lisi@torna.cn','cfb8d9b2e8447520fe0df35242566096','李四',0,0,'2020-12-15 10:10:32','2021-01-27 09:14:36'),

(13,'dev2back\_guest@torna.cn','211b7fb1fce482e3bd312fcdb5a89d7f','后台访客',0,0,'2020-12-15 11:21:07','2021-01-27 09:14:36'),

(14,'test@torna.cn','c19b85cecd8787ba8712ff764bf70f81','测试A',0,0,'2021-01-25 09:08:21','2021-01-27 09:14:36');

INSERT INTO \`user\_message\` (\`id\`, \`user\_id\`, \`message\`, \`is\_read\`, \`type\`, \`source\_id\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(3,2,'超级管理员 修改了文档 获取分类信息',1,1,2,'2021-01-19 13:38:20','2021-01-19 16:28:54'),

(4,2,'超级管理员 更新了【获取分类信息】，备注: 111',1,1,2,'2021-01-19 13:43:42','2021-01-19 16:30:36'),

(5,2,'超级管理员 更新了【获取分类信息】，备注: 3333',1,1,2,'2021-01-19 13:43:45','2021-01-19 15:27:41'),

(6,2,'超级管理员 更新了【获取分类信息】，备注: 本次需改了很多内容，这是一句很长的话',1,1,2,'2021-01-19 13:49:55','2021-01-19 16:21:17'),

(7,2,'超级管理员 更新了【获取分类信息】',1,1,2,'2021-01-19 15:33:41','2021-01-19 15:49:55'),

(8,2,'超级管理员 更新了【获取分类信息】，备注: 1231231',1,1,2,'2021-01-19 15:33:44','2021-01-19 16:21:29'),

(9,2,'超级管理员 更新了【获取分类信息】',1,1,2,'2021-01-19 16:39:35','2021-01-19 16:48:32'),

(10,2,'超级管理员 删除了【获取分类信息】',1,1,2,'2021-01-19 16:44:37','2021-01-19 16:46:06');

INSERT INTO \`user\_subscribe\` (\`id\`, \`user\_id\`, \`type\`, \`source\_id\`, \`is\_deleted\`, \`gmt\_create\`, \`gmt\_modified\`) VALUES

(1,1,1,16,0,'2021-01-18 16:33:51','2021-01-18 16:38:58'),

(2,1,1,4,0,'2021-01-18 16:41:09','2021-01-18 17:18:12'),

(3,1,1,6,0,'2021-01-18 17:17:57','2021-01-18 17:17:57'),

(4,1,1,5,0,'2021-01-18 17:17:59','2021-01-18 17:35:14'),

(5,1,1,8,1,'2021-01-18 17:18:04','2021-01-18 17:21:19'),

(6,1,1,2,0,'2021-01-18 17:18:07','2021-01-18 17:18:07'),

(7,1,1,3,0,'2021-01-18 17:18:10','2021-01-18 17:18:10'),

(8,2,1,2,0,'2021-01-19 10:24:11','2021-01-19 10:24:11');

一键复制

编辑

Web IDE

原始数据

按行查看

历史

mysql1714,mysql.sql

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Mysqlsql语句中文本带大括号

相关 mysqlsql执行顺序

相关【MySQL】MySQL之 mysql 库

相关 MySQLSQL error1271Illegal mix of collations for operation UNION

相关 mysql1714,mysql.sql

相关【MySQL】使用MySQL

相关【MySQL】MySQL简介

相关【基础知识思考整理】MySQLSQL注入（SQL Injection ）和防注入

相关优化mysqlSQL语句的方式或方法是什么

相关优化mysqlSQL语句的方式和方法