mysql1714,mysql.sql

-- 适用于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

原始数据

按行查看

历史