项目使用smart-doc+Torna自动化创建api文档

- 日理万妓 2024-03-31 13:16 38阅读 0赞

首先部署Torna，我这里是用docker部署的

准备工作：1 docker 环境

2 torna 所需的sql脚本（可以去github 找最新的）

DROP TABLE IF EXISTS `compose_additional_page`;
    CREATE TABLE IF NOT EXISTS `compose_additional_page` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `project_id` bigint(20) unsigned NOT NULL COMMENT 'compose_project.id',
        `title` varchar(64) NOT NULL COMMENT '文档标题',
        `content` text COMMENT '文档内容',
        `order_index` int(11) NOT NULL DEFAULT '0' COMMENT '排序值',
        `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1:启用，0：禁用',
        `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
        `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        KEY `idx_projectid` (`project_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='聚合文档附加页';
    
    -- 正在导出表  torna.compose_additional_page 的数据：~0 rows (大约)
    
    -- 导出  表 torna.compose_common_param 结构
    DROP TABLE IF EXISTS `compose_common_param`;
    CREATE TABLE IF NOT EXISTS `compose_common_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 '-' COMMENT '最大长度',
        `example` varchar(1024) NOT NULL DEFAULT '' COMMENT '示例值',
        `description` text NOT NULL COMMENT '描述',
        `enum_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'enum_info.id',
        `compose_project_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'compose_project.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：错误码',
        `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`) USING BTREE,
        UNIQUE KEY `uk_dataid` (`data_id`) USING BTREE,
        KEY `idx_compose_project_id` (`compose_project_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='聚合文档公共参数';
    
    -- 正在导出表  torna.compose_common_param 的数据：~0 rows (大约)
    
    -- 导出  表 torna.compose_doc 结构
    DROP TABLE IF EXISTS `compose_doc`;
    CREATE TABLE IF NOT EXISTS `compose_doc` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `doc_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'doc_info.id',
        `project_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'compose_project.id',
        `is_folder` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否文件夹',
        `folder_name` varchar(64) NOT NULL DEFAULT '' COMMENT '文件夹名称',
        `parent_id` bigint(20) NOT NULL DEFAULT '0',
        `origin` varchar(128) NOT NULL DEFAULT '' COMMENT '文档来源',
        `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
        `creator` varchar(64) NOT NULL DEFAULT '' COMMENT '创建人',
        `order_index` int(10) unsigned NOT NULL DEFAULT '0',
        `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        KEY `idx_projectid` (`project_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='文档引用';
    
    -- 正在导出表  torna.compose_doc 的数据：~0 rows (大约)
    
    -- 导出  表 torna.compose_project 结构
    DROP TABLE IF EXISTS `compose_project`;
    CREATE TABLE IF NOT EXISTS `compose_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',
        `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '访问形式，1：公开，2：加密',
        `password` 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',
        `modifier_name` varchar(64) NOT NULL DEFAULT '',
        `order_index` int(11) NOT NULL DEFAULT '0' COMMENT '排序索引',
        `show_debug` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示调试',
        `gateway_url` varchar(128) NOT NULL DEFAULT '' COMMENT '网关url',
        `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1：有效，0：无效',
        `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`) USING BTREE,
        KEY `idx_spaceid` (`space_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='组合项目表';
    
    -- 正在导出表  torna.compose_project 的数据：~0 rows (大约)
    
    -- 导出  表 torna.constant_info 结构
    DROP TABLE IF EXISTS `constant_info`;
    CREATE TABLE IF NOT EXISTS `constant_info` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `project_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'project.id',
        `module_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'module.id',
        `doc_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'doc_info.id',
        `content` text NOT NULL COMMENT '内容',
        `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        KEY `idx_projectid` (`project_id`) USING BTREE,
        KEY `idx_moduleid` (`module_id`) USING BTREE,
        KEY `idx_docid` (`doc_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='常量信息';
    
    -- 正在导出表  torna.constant_info 的数据：~2 rows (大约)
    INSERT INTO `constant_info` (`id`, `project_id`, `module_id`, `doc_id`, `content`, `gmt_create`, `gmt_modified`) VALUES
                                                                                                                         (1, 5, 0, 0, '<h2>全局状态码</h2><figure class="table"><table><thead><tr><th><strong>HTTP状态码</strong></th><th><strong>说明</strong></th></tr></thead><tbody><tr><td>200</td><td>OK</td></tr><tr><td>400</td><td>Bad Request</td></tr><tr><td>401</td><td>Unauthorized</td></tr><tr><td>403</td><td>Forbidden</td></tr><tr><td>404</td><td>Not Found</td></tr><tr><td>405</td><td>Method Not Allowed</td></tr><tr><td>500</td><td>Internal Server Error</td></tr><tr><td>502</td><td>Bad Gateway</td></tr><tr><td>503</td><td>Service Unavailable</td></tr><tr><td>504</td><td>Gateway Timeout</td></tr></tbody></table></figure>', '2022-11-03 20:32:43', '2022-11-03 20:32:43'),
                                                                                                                         (2, 0, 5, 0, '<h2>商品中心错误码</h2><ul><li>10001：商品不存在</li><li>10002：分类不存在</li><li>10003：商品已下架</li><li>10004：商品已售罄</li></ul>', '2022-11-03 20:33:53', '2022-11-03 20:33:53');
    
    -- 导出  表 torna.doc_info 结构
    DROP TABLE IF EXISTS `doc_info`;
    CREATE TABLE IF NOT EXISTS `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)',
        `md5` varchar(32) NOT NULL DEFAULT '' COMMENT '文档内容的md5值',
        `name` varchar(128) NOT NULL DEFAULT '' COMMENT '文档名称',
        `description` text COMMENT '文档描述',
        `author` varchar(64) NOT NULL DEFAULT '' COMMENT '维护人',
        `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0:http,1:dubbo',
        `url` varchar(256) NOT NULL DEFAULT '' COMMENT '访问URL',
        `http_method` varchar(12) NOT NULL DEFAULT '' COMMENT 'http方法',
        `content_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'contentType',
        `deprecated` varchar(128) DEFAULT '$false$' COMMENT '废弃信息',
        `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',
        `is_use_global_headers` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否使用全局请求参数',
        `is_use_global_params` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否使用全局请求参数',
        `is_use_global_returns` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否使用全局返回参数',
        `is_request_array` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否请求数组',
        `is_response_array` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否返回数组',
        `request_array_type` varchar(16) NOT NULL DEFAULT 'object' COMMENT '请求数组时元素类型',
        `response_array_type` varchar(16) NOT NULL DEFAULT 'object' COMMENT '返回数组时元素类型',
        `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` text COMMENT '备注',
        `is_show` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示',
        `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
        `is_locked` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否锁住',
        `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        UNIQUE KEY `uk_data_id` (`data_id`) USING BTREE,
        KEY `idx_moduleid` (`module_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='文档信息';
    
    -- 正在导出表  torna.doc_info 的数据：~10 rows (大约)
    INSERT INTO `doc_info` (`id`, `data_id`, `md5`, `name`, `description`, `author`, `type`, `url`, `http_method`, `content_type`, `deprecated`, `is_folder`, `parent_id`, `module_id`, `is_use_global_headers`, `is_use_global_params`, `is_use_global_returns`, `is_request_array`, `is_response_array`, `request_array_type`, `response_array_type`, `create_mode`, `modify_mode`, `creator_id`, `creator_name`, `modifier_id`, `modifier_name`, `order_index`, `remark`, `is_show`, `is_deleted`, `is_locked`, `gmt_create`, `gmt_modified`) VALUES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (97, '8421b3dc53855aa82cd9a9f493b08376', '', '产品模块', '', 'thc', 0, '', '', '', '$false$', 1, 0, 5, 1, 1, 1, 0, 0, 'object', 'object', 1, 1, 99999, 'thc', 99999, 'thc', 2, NULL, 1, 0, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (98, '4face5a97658e1323d1aaf343c742920', '6965a2919c3e33a4d5cfadbfe2d6f82e', '新增产品', '新增产品', 'thc', 0, '/shop/product/', 'POST', 'application/json', '$false$', 0, 97, 5, 1, 1, 1, 0, 0, 'object', 'object', 1, 1, 99999, 'thc', 99999, 'thc', 1, NULL, 1, 0, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (99, 'f24d20f5805ba266ba6fda13271589e0', '3de4ea5522a4486b63f0d9dc3d1408ea', '修改产品', '修改产品', 'thc', 0, '/shop/product/', 'PUT', 'application/json', '$false$', 0, 97, 5, 1, 1, 1, 0, 0, 'object', 'object', 1, 1, 99999, 'thc', 99999, 'thc', 2, NULL, 1, 0, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (100, '564b9f4b0c800f7bd1d8c064e4f87601', 'e89523f48f3a8c0b6de371eaf4c6d3a7', '查询产品', '查询产品', 'thc', 0, '/shop/product/', 'GET', 'application/x-www-form-urlencoded;charset=UTF-8', '$false$', 0, 97, 5, 1, 1, 1, 0, 0, 'object', 'object', 1, 1, 99999, 'thc', 99999, 'thc', 3, NULL, 1, 0, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (101, 'd9addaac101a3c37b680b3eff5e74b81', '', '订单查询', '', '', 0, '', '', '', '$false$', 1, 0, 6, 1, 1, 1, 0, 0, 'object', 'object', 0, 0, 16, '超级管理员', 16, '超级管理员', 0, NULL, 1, 0, 0, '2022-11-03 20:37:49', '2022-11-03 20:37:49'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (102, '5fa110de16f8289a1dfbb7ae0e68f68c', '94a9a4170c569c3a8c1d3e77dc39eb2e', '获取订单详情', '', 'jim', 0, '/order/detail', 'GET', '', '$false$', 0, 101, 6, 1, 1, 1, 0, 0, 'object', 'object', 0, 0, 16, '超级管理员', 16, '超级管理员', 10000, '', 1, 0, 0, '2022-11-03 20:38:40', '2022-11-03 20:38:40'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (103, '2dd9dc7d62a7b5f5f0a94c791775b6a5', '', '登录模块', '', '', 0, '', '', '', '$false$', 1, 0, 7, 1, 1, 1, 0, 0, 'object', 'object', 0, 0, 16, '超级管理员', 16, '超级管理员', 0, NULL, 1, 0, 0, '2022-11-03 20:47:04', '2022-11-03 20:47:04'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (104, 'ddf9207b0dafebb1e7ac1dea25b071cc', '', '分类模块', '', 'tanghc', 0, '', '', '', '$false$', 1, 0, 5, 1, 1, 1, 0, 0, 'object', 'object', 1, 1, 99999, 'thc', 99999, 'thc', 1, NULL, 1, 0, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (105, '3eaff877923fc6b20b348da955d4e8ef', 'c0fcaef099b3f06a6711f8bb2370418b', '添加分类', '添加分类', 'tanghc', 0, '/category/add', 'POST', 'application/json', '$false$', 0, 104, 5, 1, 1, 1, 0, 0, 'object', 'object', 1, 1, 99999, 'thc', 99999, 'thc', 1, NULL, 1, 0, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (106, '9c5ecbe65162543e5a1fb4cc4c8d7249', 'd6ecdb4ff1eed507cb011fed25c4c5a2', '查询分类', '查询分类', 'tanghc', 0, '/category/get', 'POST', 'application/x-www-form-urlencoded;charset=UTF-8', '$false$', 0, 104, 5, 1, 1, 1, 0, 0, 'object', 'object', 1, 1, 99999, 'thc', 99999, 'thc', 2, NULL, 1, 0, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (118, 'e769a4ab93aec62c0fbda17fa6b0244c', '5a193f3d886e786c398c414fec1e6806', '登录', '', 'jim', 0, 'login', 'POST', 'application/json', '$false$', 0, 103, 7, 1, 1, 1, 0, 0, 'object', 'object', 0, 0, 16, '超级管理员', 16, '超级管理员', 10000, '', 1, 0, 0, '2022-11-03 20:57:43', '2022-11-03 20:57:43'),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     (119, '18acdbaeed5976896b6ab6726b6c54ec', '', '退出', '', '', 0, 'logout', 'GET', '', '$false$', 0, 103, 7, 1, 1, 1, 0, 0, 'object', 'object', 0, 0, 16, '超级管理员', 16, '超级管理员', 10010, '', 1, 0, 0, '2022-11-03 20:58:18', '2022-11-03 20:58:18');
    
    -- 导出  表 torna.doc_param 结构
    DROP TABLE IF EXISTS `doc_param`;
    CREATE TABLE IF NOT EXISTS `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 '-' COMMENT '最大长度',
        `example` varchar(1024) NOT NULL DEFAULT '' COMMENT '示例值',
        `description` text NOT NULL 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：body参数，3：返回参数，4：错误码, 5：query参数',
        `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`) USING BTREE,
        UNIQUE KEY `uk_dataid` (`data_id`) USING BTREE,
        KEY `idx_docid` (`doc_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=733 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='文档参数';
    
    -- 正在导出表  torna.doc_param 的数据：~36 rows (大约)
    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
                                                                                                                                                                                                                                                                                                                        (697, '6d0c7aa7d6ad2f0ae98d22867599d0e1', 'username', 'string', 0, '-', 'jim', '用户名', 0, 95, 0, 2, 1, 1, 99999, 'thc', 99999, 'thc', 1, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (698, '9dffc368418c6ddbc950a25fe7a00813', 'password', 'string', 0, '-', '123', '密码', 0, 95, 0, 2, 1, 1, 99999, 'thc', 99999, 'thc', 2, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (699, '140f64afcc79260bf84f3f0ae81165f9', 'code', 'int32', 0, '-', '0', '返回码,0表示成功，其它失败', 0, 95, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 1, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (700, 'dba7c3f7015673ee189e6c43e678bd50', 'data', 'object', 0, '', '', '返回数据', 0, 95, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 2, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (701, '9fedeadcd8dea4d6839943445509e82a', 'userId', 'int32', 0, '-', '11', '用户id', 0, 95, 700, 3, 1, 1, 99999, 'thc', 99999, 'thc', 3, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (702, '5f1414b3189c6427ce7a5f4edb592627', 'username', 'string', 0, '-', 'jim', '用户名', 0, 95, 700, 3, 1, 1, 99999, 'thc', 99999, 'thc', 4, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (703, '66d991fc24461a130d503bc548aedf1d', 'token', 'string', 0, '-', 'xx', 'token', 0, 95, 700, 3, 1, 1, 99999, 'thc', 99999, 'thc', 5, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (704, '9bf4b1dbd940e93bc815552325e4e5fc', 'msg', 'string', 0, '-', 'OK', '错误消息', 0, 95, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 6, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (705, '69dcc015a2e72b19b017b859146b69ae', 'code', 'int32', 0, '-', '0', '返回码,0表示成功，其它失败', 0, 96, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 1, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (706, '3a2f0ceb7285c1660a951d580a563ef1', 'data', 'object', 0, '-', '', '返回数据', 0, 96, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 2, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (707, '4b4a499fb3001957e21538db1918d673', 'msg', 'string', 0, '-', 'OK', '错误消息', 0, 96, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 3, 1, '2022-11-03 20:26:07', '2022-11-03 20:55:13'),
                                                                                                                                                                                                                                                                                                                        (708, '87aacd47f8df31220676c1d8f4a8647b', 'productNo', 'string', 0, '-', 'aa', '产品id', 0, 98, 0, 2, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (709, '4ab71029575f1e154649e2f2f166a829', 'remark', 'string', 0, '-', 'xxx', '备注', 0, 98, 0, 2, 1, 1, 99999, 'thc', 99999, 'thc', 2, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (710, '1863f6e2b26e66c0181b6db99ad1bc91', 'code', 'int32', 0, '-', '0', '返回码,0表示成功，其它失败', 0, 98, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (711, 'f5c6d52f0cc1f2270868299785c65ad5', 'data', 'string', 0, '-', '', '返回数据', 0, 98, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 2, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (712, 'b57e9de2cfc702cf8e2bcb583c187095', 'msg', 'string', 0, '-', 'OK', '错误消息', 0, 98, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 3, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (713, '15cee4e78cbe980d9365a0d46ce2342a', 'productNo', 'string', 0, '-', 'aa', '产品id', 0, 99, 0, 2, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (714, '91229547a9849c329d0d2e7321fb03ca', 'remark', 'string', 0, '-', 'xxx', '备注', 0, 99, 0, 2, 1, 1, 99999, 'thc', 99999, 'thc', 2, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (715, '63c262d93317abd3b213b1ede6414c19', 'code', 'int32', 0, '-', '0', '返回码,0表示成功，其它失败', 0, 99, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (716, '3a84d6b29c00cb2e0a83236a063d03f8', 'data', 'object', 0, '', '', '返回数据', 0, 99, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 2, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (717, '86229614609aea0382c9a0ae021b63da', 'productNo', 'string', 0, '-', 'aa', '产品id', 0, 99, 716, 3, 1, 1, 99999, 'thc', 99999, 'thc', 3, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (718, '2bfd75998e84f6cce8b5a76eb8330dee', 'remark', 'string', 0, '-', 'xxx', '备注', 0, 99, 716, 3, 1, 1, 99999, 'thc', 99999, 'thc', 4, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (719, '6fc91716d033ebeed4a3a572af877102', 'productDetailVO', 'object', 0, '', '', '产品详情', 0, 99, 716, 3, 1, 1, 99999, 'thc', 99999, 'thc', 5, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (720, '7a8996d3ee2b3edb32067f8aff324990', 'productNo', 'string', 0, '-', 'aa', '产品id', 0, 99, 719, 3, 1, 1, 99999, 'thc', 99999, 'thc', 6, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (721, '4771a64ed10f0ed47fecfd3d6e402c31', 'remark', 'string', 0, '-', 'e6oj41', '备注', 0, 99, 719, 3, 1, 1, 99999, 'thc', 99999, 'thc', 7, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (722, '886ca8c3c8e0268db0417ddc04a4b4e8', 'msg', 'string', 0, '-', 'OK', '错误消息', 0, 99, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 8, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (723, 'e55e59e3476c8cfffcb8315a7221bf12', 'productNo', 'int32', 1, '-', '123', '产品id', 0, 100, 0, 5, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (724, '9672e9ae31453c7f4cfe91a72f8e9c86', 'code', 'int32', 0, '-', '0', '返回码,0表示成功，其它失败', 0, 100, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (725, '4c98db43a9608d915aafc062aa30da3d', 'data', 'object', 0, '', '', '返回数据', 0, 100, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 2, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (726, '20633f0f0226af0389af78c951f773e8', 'productNo', 'string', 0, '-', 'aa', '产品id', 0, 100, 725, 3, 1, 1, 99999, 'thc', 99999, 'thc', 3, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (727, '77e4890e0422e5afd7833a54146be1a2', 'remark', 'string', 0, '-', 'xxx', '备注', 0, 100, 725, 3, 1, 1, 99999, 'thc', 99999, 'thc', 4, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (728, 'df7d62138fb04d21752ff03ae8715462', 'productDetailVO', 'object', 0, '', '', '产品详情', 0, 100, 725, 3, 1, 1, 99999, 'thc', 99999, 'thc', 5, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (729, '22792d15059d505599bb3bd10ff82e5c', 'productNo', 'string', 0, '-', 'aa', '产品id', 0, 100, 728, 3, 1, 1, 99999, 'thc', 99999, 'thc', 6, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (730, '8cc9eb5b012c8e2cea8909fac1a3052d', 'remark', 'string', 0, '-', 'js26ts', '备注', 0, 100, 728, 3, 1, 1, 99999, 'thc', 99999, 'thc', 7, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (731, 'df6f4a37db42291f6a2c5d7ee8edce3a', 'msg', 'string', 0, '-', 'OK', '错误消息', 0, 100, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 8, 0, '2022-11-03 20:26:07', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (732, '2c39b57252b29bea5abe080c043df1bd', 'orderNo', 'string', 1, '64', '100001', '订单号', 0, 102, 0, 5, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:38:40', '2022-11-03 20:38:40'),
                                                                                                                                                                                                                                                                                                                        (733, '8722180a8e809266eaee1a6f7aee8533', 'id', 'int32', 0, '-', '1', '分类id', 0, 105, 0, 2, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (734, '70b33ba815bf0d69426c4d59354bc247', 'name', 'string', 0, '-', '手机', '分类名称', 0, 105, 0, 2, 1, 1, 99999, 'thc', 99999, 'thc', 2, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (735, 'b6f81f84555bf24177048e38be5c58c7', 'code', 'int32', 0, '-', '0', '返回码,0表示成功，其它失败', 0, 105, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (736, '06ceadf33d2ead81240983074da12b8d', 'data', 'int32', 0, '-', '', '返回数据', 0, 105, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 2, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (737, 'c8908921ecde188ffc21bc50ee4d928b', 'msg', 'string', 0, '-', 'OK', '错误消息', 0, 105, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 3, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (738, '834523c04f05b52f18a74490d9095209', 'id', 'int32', 0, '-', '407', 'No comments found.', 0, 106, 0, 5, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (739, '6546f3a87fe176e094838d3668fa359f', 'code', 'int32', 0, '-', '0', '返回码,0表示成功，其它失败', 0, 106, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 1, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (740, '2b6e1d458788353d48129c4f3253495c', 'data', 'object', 0, '', '', '返回数据', 0, 106, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 2, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (741, '6cfaea67c713a19350636aefd8157e4c', 'id', 'int32', 0, '-', '1', '分类id', 0, 106, 740, 3, 1, 1, 99999, 'thc', 99999, 'thc', 3, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (742, 'f83366b3cb607864f4b2e914c4f386e0', 'name', 'string', 0, '-', '手机', '分类名称', 0, 106, 740, 3, 1, 1, 99999, 'thc', 99999, 'thc', 4, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (743, '5740aa05a4d0fd16f390d14e204f25bc', 'msg', 'string', 0, '-', 'OK', '错误消息', 0, 106, 0, 3, 1, 1, 99999, 'thc', 99999, 'thc', 5, 0, '2022-11-03 20:55:13', '2022-11-03 20:56:26'),
                                                                                                                                                                                                                                                                                                                        (803, '3ede4dd71a319dd99d9f41f8b3c3bdfe', 'username', 'string', 1, '64', 'Jim', '用户名', 0, 118, 0, 2, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:57:43', '2022-11-03 20:57:43'),
                                                                                                                                                                                                                                                                                                                        (804, '12d3df7b6f4feef59617f23c8bd6528e', 'password', 'string', 1, '64', 'xx', '密码', 0, 118, 0, 2, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:57:43', '2022-11-03 20:57:43'),
                                                                                                                                                                                                                                                                                                                        (805, 'e3bbecd30239ac4fb541263d32e7812f', 'code', 'number', 1, '64', '0', '', 0, 102, 0, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:59:33', '2022-11-03 20:59:33'),
                                                                                                                                                                                                                                                                                                                        (806, '6f9e267c3c4babb69394b2ee9b942a94', 'data', 'object', 1, '', '', '', 0, 102, 0, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:59:33', '2022-11-03 20:59:33'),
                                                                                                                                                                                                                                                                                                                        (807, '35f5f5584504d8cbf6bb45e67ce016bc', 'orderNo', 'string', 1, '64', 'aa', '订单号', 0, 102, 806, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:59:33', '2022-11-03 20:59:33'),
                                                                                                                                                                                                                                                                                                                        (808, '38e3e71cf709183ebffc5cf92219e2a8', 'remark', 'string', 1, '64', 'xxx', '备注', 0, 102, 806, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:59:33', '2022-11-03 20:59:33'),
                                                                                                                                                                                                                                                                                                                        (809, '7216cf40f2ea884a94cf733ad2df88da', 'msg', 'string', 1, '64', 'OK', '', 0, 102, 0, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:59:33', '2022-11-03 20:59:33'),
                                                                                                                                                                                                                                                                                                                        (810, '81284f9eaf7e78c3a40f65aff12c3e46', 'code', 'number', 1, '64', '0', '', 0, 118, 0, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 21:00:03', '2022-11-03 21:00:03'),
                                                                                                                                                                                                                                                                                                                        (811, 'a35656f391a5678247952e20895d6b99', 'data', 'object', 1, '', '', '', 0, 118, 0, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 21:00:03', '2022-11-03 21:00:03'),
                                                                                                                                                                                                                                                                                                                        (812, '64030857ff745dcffc27afefaa516401', 'token', 'string', 1, '64', 'xxx', '登录成功后的token', 0, 118, 811, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 21:00:03', '2022-11-03 21:00:03'),
                                                                                                                                                                                                                                                                                                                        (813, 'f574f1cbbf5dd8a2cbbc9079e1a7a549', 'msg', 'string', 1, '64', 'OK', '', 0, 118, 0, 3, 0, 0, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 21:00:03', '2022-11-03 21:00:03');
    
    -- 导出  表 torna.enum_info 结构
    DROP TABLE IF EXISTS `enum_info`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        KEY `idx_moduleid` (`module_id`) USING BTREE,
        KEY `idx_dataid` (`data_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='枚举信息';
    
    -- 正在导出表  torna.enum_info 的数据：~1 rows (大约)
    INSERT INTO `enum_info` (`id`, `data_id`, `name`, `description`, `module_id`, `is_deleted`, `gmt_create`, `gmt_modified`) VALUES
        (5, '50c0c6ce9bf63a5f7f192e1a12c76e0e', '商品分类', '商品分类', 5, 0, '2022-11-03 20:26:42', '2022-11-03 20:26:42');
    
    -- 导出  表 torna.enum_item 结构
    DROP TABLE IF EXISTS `enum_item`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        KEY `idx_enumid` (`enum_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='枚举详情';
    
    -- 正在导出表  torna.enum_item 的数据：~4 rows (大约)
    INSERT INTO `enum_item` (`id`, `enum_id`, `name`, `type`, `value`, `description`, `order_index`, `is_deleted`, `gmt_create`, `gmt_modified`) VALUES
                                                                                                                                                     (9, 5, 'MOBILE', 'number', '1', '手机', 0, 0, '2022-11-03 20:27:20', '2022-11-03 20:27:20'),
                                                                                                                                                     (10, 5, 'COMPUTER', 'number', '2', '电脑', 0, 0, '2022-11-03 20:27:36', '2022-11-03 20:27:36'),
                                                                                                                                                     (11, 5, 'CAR', 'number', '3', '车品', 0, 0, '2022-11-03 20:27:56', '2022-11-03 20:27:56'),
                                                                                                                                                     (12, 5, 'FOOD', 'number', '4', '食品', 0, 0, '2022-11-03 20:28:15', '2022-11-03 20:28:15');
    
    -- 导出  表 torna.mock_config 结构
    DROP TABLE IF EXISTS `mock_config`;
    CREATE TABLE IF NOT EXISTS `mock_config` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `name` varchar(64) NOT NULL DEFAULT '' COMMENT '名称',
        `data_id` varchar(64) NOT NULL DEFAULT '' COMMENT 'md5(path+query+body)',
        `path` varchar(128) NOT NULL DEFAULT '',
        `ip` varchar(64) NOT NULL DEFAULT '' COMMENT '过滤ip',
        `request_data` text NOT NULL COMMENT '请求参数',
        `request_data_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '参数类型，0：KV形式，1：json形式',
        `http_status` int(11) NOT NULL DEFAULT '200' COMMENT 'http状态',
        `delay_mills` int(11) NOT NULL DEFAULT '0' COMMENT '延迟时间，单位毫秒',
        `result_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '返回类型，0：自定义内容，1：脚本内容',
        `response_headers` text NOT NULL COMMENT '响应header，数组结构',
        `response_body` text NOT NULL COMMENT '响应结果',
        `mock_script` text COMMENT 'mock脚本',
        `mock_result` text COMMENT 'mock结果',
        `doc_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '文档id',
        `remark` varchar(128) NOT NULL DEFAULT '' COMMENT '备注',
        `creator_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建人id',
        `creator_name` varchar(64) NOT NULL DEFAULT '' COMMENT '创建人姓名',
        `modifier_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '修改人id',
        `modifier_name` varchar(64) DEFAULT NULL 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`) USING BTREE,
        KEY `idx_docid` (`doc_id`) USING BTREE,
        KEY `idx_dataid` (`data_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='mock配置';
    
    -- 正在导出表  torna.mock_config 的数据：~0 rows (大约)
    
    -- 导出  表 torna.module 结构
    DROP TABLE IF EXISTS `module`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        UNIQUE KEY `uk_token` (`token`) USING BTREE,
        KEY `idx_projectid` (`project_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='项目模块';
    
    -- 正在导出表  torna.module 的数据：~2 rows (大约)
    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
                                                                                                                                                                                                                                                             (5, '商品中心', 5, 0, '', '', '', 'b414086531524fb0bc14f757346fec92', 0, 0, 16, 16, 0, 0, '2022-11-03 20:25:35', '2022-11-03 20:25:35'),
                                                                                                                                                                                                                                                             (6, '订单中心', 5, 0, '', '', '', 'bbe60f26676c4e92893170213ad05197', 0, 0, 16, 16, 0, 0, '2022-11-03 20:37:04', '2022-11-03 20:37:04'),
                                                                                                                                                                                                                                                             (7, '用户中心', 5, 0, '', '', '', '0e6cd661ea60487188d8cbbdcfe1228b', 0, 0, 16, 16, 0, 0, '2022-11-03 20:46:47', '2022-11-03 20:46:47');
    
    -- 导出  表 torna.module_config 结构
    DROP TABLE IF EXISTS `module_config`;
    CREATE TABLE IF NOT EXISTS `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 '配置值',
        `extend_id` bigint(20) unsigned NOT NULL DEFAULT '0',
        `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`) USING BTREE,
        KEY `idx_moduleid_type` (`module_id`,`type`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统配置';
    
    -- 正在导出表  torna.module_config 的数据：~0 rows (大约)
    
    -- 导出  表 torna.module_environment 结构
    DROP TABLE IF EXISTS `module_environment`;
    CREATE TABLE IF NOT EXISTS `module_environment` (
        `id` bigint(20) NOT NULL AUTO_INCREMENT,
        `module_id` bigint(20) NOT NULL COMMENT 'module.id',
        `name` varchar(64) NOT NULL DEFAULT '' COMMENT '环境名称',
        `url` varchar(255) NOT NULL DEFAULT '' COMMENT '调试路径',
        `is_public` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否公开',
        `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
        `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        KEY `uk_moduleid_name` (`module_id`,`name`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='模块调试环境';
    
    -- 正在导出表  torna.module_environment 的数据：~2 rows (大约)
    INSERT INTO `module_environment` (`id`, `module_id`, `name`, `url`, `is_public`, `is_deleted`, `gmt_create`, `gmt_modified`) VALUES
                                                                                                                                     (3, 5, '本地环境', 'http://127.0.0.1:8080', 0, 0, '2022-11-03 20:26:07', '2022-11-03 20:26:07'),
                                                                                                                                     (4, 6, '本地环境', 'http://127.0.0.1:8081', 0, 0, '2022-11-03 20:37:16', '2022-11-03 20:37:16'),
                                                                                                                                     (5, 7, '本地环境', 'http://127.0.0.1:8082', 0, 0, '2022-11-03 21:00:26', '2022-11-03 21:00:26');
    
    -- 导出  表 torna.module_environment_param 结构
    DROP TABLE IF EXISTS `module_environment_param`;
    CREATE TABLE IF NOT EXISTS `module_environment_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 '-' COMMENT '最大长度',
        `example` varchar(1024) NOT NULL DEFAULT '' COMMENT '示例值',
        `description` text NOT NULL COMMENT '描述',
        `enum_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'enum_info.id',
        `environment_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'module_environment.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`) USING BTREE,
        UNIQUE KEY `uk_dataid` (`data_id`) USING BTREE,
        KEY `idx_environmentid` (`environment_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='模块公共参数';
    
    -- 正在导出表  torna.module_environment_param 的数据：~0 rows (大约)
    
    -- 导出  表 torna.module_swagger_config 结构
    DROP TABLE IF EXISTS `module_swagger_config`;
    CREATE TABLE IF NOT EXISTS `module_swagger_config` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
        `module_id` bigint(20) NOT NULL COMMENT 'module.id',
        `url` varchar(256) NOT NULL DEFAULT '' COMMENT 'swagger url',
        `content` longtext NOT NULL COMMENT 'swagger内容',
        `auth_username` varchar(128) NOT NULL DEFAULT '' COMMENT '认证用户名',
        `auth_password` varchar(128) NOT NULL DEFAULT '' COMMENT '认证密码',
        `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`),
        KEY `idx_moduleid` (`module_id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='swagger配置表';
    
    -- 正在导出表  torna.module_swagger_config 的数据：~0 rows (大约)
    
    -- 导出  表 torna.open_user 结构
    DROP TABLE IF EXISTS `open_user`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        UNIQUE KEY `uk_app_key` (`app_key`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='开放用户';
    
    -- 正在导出表  torna.open_user 的数据：~0 rows (大约)
    
    -- 导出  表 torna.project 结构
    DROP TABLE IF EXISTS `project`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        KEY `uk_name` (`creator_id`,`name`) USING BTREE,
        KEY `idx_spaceid` (`space_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='项目表';
    
    -- 正在导出表  torna.project 的数据：~1 rows (大约)
    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
        (5, '商城项目', '商城项目', 20, 1, 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:25:20', '2022-11-03 20:25:20');
    
    -- 导出  表 torna.project_user 结构
    DROP TABLE IF EXISTS `project_user`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        UNIQUE KEY `uk_projectid_userid` (`project_id`,`user_id`) USING BTREE,
        KEY `idx_userid` (`user_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='项目用户关系表';
    
    -- 正在导出表  torna.project_user 的数据：~1 rows (大约)
    INSERT INTO `project_user` (`id`, `project_id`, `user_id`, `role_code`, `is_deleted`, `gmt_create`, `gmt_modified`) VALUES
        (11, 5, 16, 'admin', 0, '2022-11-03 20:25:20', '2022-11-03 20:25:20');
    
    -- 导出  表 torna.prop 结构
    DROP TABLE IF EXISTS `prop`;
    CREATE TABLE IF NOT EXISTS `prop` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `ref_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '关联id',
        `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型，0：doc_info属性',
        `name` varchar(64) NOT NULL DEFAULT '',
        `val` text NOT NULL,
        `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        UNIQUE KEY `uk_docid_name` (`ref_id`,`type`,`name`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='属性表';
    
    -- 正在导出表  torna.prop 的数据：~0 rows (大约)
    
    -- 导出  表 torna.push_ignore_field 结构
    DROP TABLE IF EXISTS `push_ignore_field`;
    CREATE TABLE IF NOT EXISTS `push_ignore_field` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `module_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'module.id',
        `data_id` varchar(64) NOT NULL DEFAULT '' COMMENT 'doc_info.data_id',
        `field_name` varchar(64) NOT NULL DEFAULT '' COMMENT 'doc_info.name',
        `field_description` varchar(64) NOT NULL DEFAULT '' COMMENT '字段描述',
        `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        UNIQUE KEY `uk_moduleid_dataid_fieldname` (`module_id`,`data_id`,`field_name`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='推送忽略字段';
    
    -- 正在导出表  torna.push_ignore_field 的数据：~0 rows (大约)
    
    -- 导出  表 torna.share_config 结构
    DROP TABLE IF EXISTS `share_config`;
    CREATE TABLE IF NOT EXISTS `share_config` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分享形式，1：公开，2：加密',
        `password` varchar(128) NOT NULL DEFAULT '' COMMENT '密码',
        `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，1：有效，0：无效',
        `module_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'module.id',
        `is_all` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否为全部文档',
        `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
        `remark` varchar(128) NOT NULL DEFAULT '' COMMENT '备注',
        `creator_name` varchar(64) NOT NULL DEFAULT '' COMMENT '创建人',
        `is_show_debug` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示调试',
        `is_all_selected_debug` tinyint(4) NOT NULL DEFAULT '1' COMMENT '调试环境是否全选， 1-全选， 0-不选',
        `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        KEY `idx_moduleid` (`module_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分享配置表';
    
    -- 正在导出表  torna.share_config 的数据：~0 rows (大约)
    
    -- 导出  表 torna.share_content 结构
    DROP TABLE IF EXISTS `share_content`;
    CREATE TABLE IF NOT EXISTS `share_content` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `share_config_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'share_config.id',
        `doc_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文档id',
        `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
        `is_share_folder` tinyint(4) 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`) USING BTREE,
        KEY `idx_shareconfigid_docid` (`share_config_id`,`doc_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分享详情';
    
    -- 正在导出表  torna.share_content 的数据：~0 rows (大约)
    
    -- 导出  表 torna.share_environment 结构
    DROP TABLE IF EXISTS `share_environment`;
    CREATE TABLE IF NOT EXISTS `share_environment` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `share_config_id` bigint(20) unsigned DEFAULT '0' COMMENT '分享配置id',
        `module_environment_id` bigint(20) unsigned DEFAULT '0' COMMENT '模块环境id',
        PRIMARY KEY (`id`),
        KEY `share_environment_share_config_id_index` (`share_config_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分享环境关联表';
    
    -- 正在导出表  torna.share_environment 的数据：~0 rows (大约)
    
    -- 导出  表 torna.space 结构
    DROP TABLE IF EXISTS `space`;
    CREATE TABLE IF NOT EXISTS `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_compose` tinyint(4) 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`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分组表';
    
    -- 正在导出表  torna.space 的数据：~1 rows (大约)
    INSERT INTO `space` (`id`, `name`, `creator_id`, `creator_name`, `modifier_id`, `modifier_name`, `is_compose`, `is_deleted`, `gmt_create`, `gmt_modified`) VALUES
        (20, '研发中心', 16, '超级管理员', 16, '超级管理员', 0, 0, '2022-11-03 20:24:59', '2022-11-03 20:24:59');
    
    -- 导出  表 torna.space_user 结构
    DROP TABLE IF EXISTS `space_user`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        UNIQUE KEY `uk_groupid_userid` (`space_id`,`user_id`) USING BTREE,
        KEY `idx_userid` (`user_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分组用户关系表';
    
    -- 正在导出表  torna.space_user 的数据：~1 rows (大约)
    INSERT INTO `space_user` (`id`, `user_id`, `space_id`, `role_code`, `is_deleted`, `gmt_create`, `gmt_modified`) VALUES
        (26, 16, 20, 'admin', 0, '2022-11-03 20:24:59', '2022-11-03 20:24:59');
    
    -- 导出  表 torna.system_config 结构
    DROP TABLE IF EXISTS `system_config`;
    CREATE TABLE IF NOT EXISTS `system_config` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `config_key` varchar(64) NOT NULL DEFAULT '',
        `config_value` varchar(256) NOT NULL DEFAULT '',
        `remark` varchar(128) NOT NULL DEFAULT '',
        `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`) USING BTREE,
        UNIQUE KEY `uk_configkey` (`config_key`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统配置表';
    
    -- 正在导出表  torna.system_config 的数据：~1 rows (大约)
    INSERT INTO `system_config` (`id`, `config_key`, `config_value`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`) VALUES
        (3, 'torna.version', '11800', '当前内部版本号。不要删除这条记录！！', 0, '2022-11-03 20:20:53', '2022-11-03 20:20:53');
    
    -- 导出  表 torna.user_dingtalk_info 结构
    DROP TABLE IF EXISTS `user_dingtalk_info`;
    CREATE TABLE IF NOT EXISTS `user_dingtalk_info` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `nick` varchar(64) NOT NULL DEFAULT '' COMMENT '用户在钉钉上面的昵称',
        `name` varchar(64) NOT NULL DEFAULT '' COMMENT '员工名称。',
        `email` varchar(128) NOT NULL DEFAULT '' COMMENT '员工邮箱。',
        `userid` varchar(128) NOT NULL DEFAULT '' COMMENT '员工的userid。',
        `unionid` varchar(128) NOT NULL DEFAULT '' COMMENT '用户在当前开放应用所属企业的唯一标识。',
        `openid` varchar(128) NOT NULL DEFAULT '' COMMENT '用户在当前开放应用内的唯一标识。',
        `user_info_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'user_info.id',
        `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
        `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`) USING BTREE,
        UNIQUE KEY `uk_unionid` (`unionid`) USING BTREE,
        KEY `idx_openid` (`openid`) USING BTREE,
        KEY `idx_userid` (`user_info_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='钉钉开放平台用户';
    
    -- 正在导出表  torna.user_dingtalk_info 的数据：~0 rows (大约)
    
    -- 导出  表 torna.user_info 结构
    DROP TABLE IF EXISTS `user_info`;
    CREATE TABLE IF NOT EXISTS `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 '是否是超级管理员',
        `source` varchar(64) NOT NULL DEFAULT 'register',
        `email` varchar(128) NOT NULL DEFAULT '',
        `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`) USING BTREE,
        UNIQUE KEY `uk_username` (`username`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户表';
    
    -- 正在导出表  torna.user_info 的数据：~1 rows (大约)
    INSERT INTO `user_info` (`id`, `username`, `password`, `nickname`, `is_super_admin`, `source`, `email`, `status`, `is_deleted`, `gmt_create`, `gmt_modified`) VALUES
        (16, 'admin', 'f9560048604e55186198a4a02ba1b9a9', '超级管理员', 1, 'register', '', 1, 0, '2022-11-03 20:20:53', '2022-11-03 20:20:53');
    
    -- 导出  表 torna.user_message 结构
    DROP TABLE IF EXISTS `user_message`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        KEY `idx_userid` (`user_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='站内消息';
    
    -- 正在导出表  torna.user_message 的数据：~0 rows (大约)
    
    -- 导出  表 torna.user_subscribe 结构
    DROP TABLE IF EXISTS `user_subscribe`;
    CREATE TABLE IF NOT EXISTS `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`) USING BTREE,
        UNIQUE KEY `uk_userid_type_sourceid` (`user_id`,`type`,`source_id`) USING BTREE
        ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户订阅表';

在自己的主机这边新建文件夹并创建配置文件

mkdir -p /home/torna/config
    vi application.properties

# torna 端口
    server.port=7700
    # 数据库ip+端口
    mysql.host=192.168.0.1:3306
    # 数据库库名
    mysql.schema=torna
    # 数据库用户名
    mysql.username=torna
    # 数据库密码
    mysql.password=torna

然后运行下面的脚本，注意启动之前必须要在数据库里面存在数据库脚本的那些表，不然启动的时候会报表不存在

docker run -p 7700:7700 --name torna --restart=always  -v /home/torna/config:/torna/config -d tanghc2020/torna:latest

浏览器试一下，看是否可以看到登录页（192.168.0.1: 7700）

![5c34fa3b8f3c4d4daebffdf3fb8c007a.png][]

登录进去创建项目（默认admin/123456）

![861724acba1a4462a31ddf8fe510879d.png][]

这个标签页里面有这两个参数，一会要用到

![2eb8c5157c7c42bd8654349c29859cbc.png][]

到此torna就算准备好了

此时我们开始在idea里面配一下smart-doc的插件

在项目的resource新建文件smart-doc.json

{
      // 项目名称
      "projectName": "测试",
      //torna平台appToken
      "appToken": "这个就是刚才在torna平台里的token",
      // 指定文档的输出路径，maven插件不需要，gradle插件必须  我这里不写推文档的时候总是提示不能为空
      "outPath": "src/main/resources",
      //torna平台地址，填写自己的私有化部署地址 这个也是在torna获取到的
      "openUrl": "http://192.168.0.1:7700/api",
      //测试项目接口环境
      "debugEnvName":"测试环境",
      // 推送torna时候替换旧的文档
      "replace": true,
      //测试项目接口地址
      "debugEnvUrl":"http://localhost:8088"
    }

然后在maven配置文件里配置smart-doc插件,我是直接粘贴官网了，其实很多不需要

<plugin>
    				<groupId>com.github.shalousun</groupId>
    				<artifactId>smart-doc-maven-plugin</artifactId>
    				<version>2.2.8</version>
    				<configuration>
    					
    					<configFile>./src/main/resources/smart-doc.json</configFile>
    					
    					<projectName>test</projectName>
    					
    					<excludes>
    						
    						
    						<exclude>com.alibaba:fastjson</exclude>
    					</excludes>
    					
    					
    					<includes>
    						
    						<include>com.baomidou:mybatis-plus-extension</include>
    						
    						<include>com.baomidou:mybatis-plus-core</include>
    						
    						<include>org.springframework.data:spring-data-commons</include>
    					</includes>
    				</configuration>
    				<executions>
    					<execution>
    						
    						<phase>compile</phase>
    						<goals>
    							
    							<goal>html</goal>
    						</goals>
    					</execution>
    				</executions>
    			</plugin>

刷新maven,会出来下面的maven插件

![ab8e4e3412b04c54b985da175fe516e6.png][]

双击这个，你会发现你的torna里面有了很多接口

![47aa6fa9878f4ecead1f7a1f7b7d293a.png][]

[5c34fa3b8f3c4d4daebffdf3fb8c007a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/4313331a74044dffb6edb0b5fe0c647e.png
[861724acba1a4462a31ddf8fe510879d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/c2f48c8cab7e44419cdd45ee0325c61a.png
[2eb8c5157c7c42bd8654349c29859cbc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/e4b27453726043fe9c92744fb55e0910.png
[ab8e4e3412b04c54b985da175fe516e6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/df9ea26c293f40da9d75cb45c8c0b529.png
[47aa6fa9878f4ecead1f7a1f7b7d293a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/d570b031d6344bc1a5037beea450c3c9.png