-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathservicebase.sql
104 lines (95 loc) · 22.6 KB
/
servicebase.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
/*
Navicat Premium Data Transfer
Source Server : 10.0.0.85_root
Source Server Type : MySQL
Source Server Version : 50718
Source Host : 10.0.0.85:3306
Source Schema : servicebase
Target Server Type : MySQL
Target Server Version : 50718
File Encoding : 65001
Date: 26/03/2019 11:01:58
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for sb_app
-- ----------------------------
DROP TABLE IF EXISTS `sb_app`;
CREATE TABLE `sb_app` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录code 主键',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '应用名称',
`type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用类型',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '应用编码',
`secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '应用秘钥',
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用描述',
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用状态',
`creator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录创建人',
`create_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '记录创建时间',
`modifier` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录修改人',
`modify_time` timestamp(0) NULL DEFAULT NULL COMMENT '记录修改时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `sb_app_idx_unique`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 144 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sb_app
-- ----------------------------
INSERT INTO `sb_app` VALUES (121, 'ambari', NULL, 'IXpdwuZUkZhHXMZ', '7e43e420f3e94eae97f580d1341b1517', 'sadf', 'enable', 'root', '2018-07-24 17:39:18', 'root', '2018-07-24 17:39:18');
INSERT INTO `sb_app` VALUES (122, 'dxxx', NULL, 'eHdfJedeXJBpDua', '464d265ff8264ea1aca4b36dbd1b2540', 'xxx', 'enable', 'etl3', '2018-08-09 14:59:25', 'etl3', '2018-08-09 14:59:25');
INSERT INTO `sb_app` VALUES (123, 'yidali', NULL, 'OuhNfEhEluUseoK', 'a25d10deab2149869b7a4f917ef10e68', '', 'enable', 'yidali', '2018-09-05 15:54:49', 'yidali', '2018-09-05 15:54:49');
INSERT INTO `sb_app` VALUES (124, 'ssswwsss', NULL, 'zxhMMmHpZqnhlvQ', 'eb8d485cc8dc4e27a8339427915237a2', 'ssss', 'disable', 'etl5', '2018-09-28 16:35:24', 'etl5', '2018-09-28 16:35:21');
INSERT INTO `sb_app` VALUES (125, 'wwww', NULL, 'XAGYFwweoGJWDih', 'a974acbb5e844ff6b4959cd0388b4b36', 'wwww', 'disable', 'etl5', '2018-09-28 16:35:39', 'etl5', '2018-09-28 16:35:29');
INSERT INTO `sb_app` VALUES (126, 'wwwws', NULL, 'FSJACssfoQjELKS', 'e7d26b0f44b742bcba7f6995bfa68869', 'wwww', 'disable', 'etl5', '2018-09-28 16:36:47', 'etl5', '2018-09-28 16:35:57');
INSERT INTO `sb_app` VALUES (127, 'wwws', NULL, 'tTItFUwiwxQnayF', '074ff4a45daf405db33f96736d7272b6', 'wwws', 'disable', 'etl5', '2018-09-28 16:37:30', 'etl5', '2018-09-28 16:37:21');
INSERT INTO `sb_app` VALUES (128, 'app_delete_2', NULL, 'FVEZijXCwBZYbQO', '5ecbf25423df41da8b117780bdd6eb39', '测试删除应用在创建', 'disable', 'etl5', '2018-09-28 19:04:41', 'etl5', '2018-09-28 19:04:42');
INSERT INTO `sb_app` VALUES (129, '12345', NULL, 'KitkJfhjkCsvlEc', '649fb39213cd4e2fab62a86e0510ccb4', '', 'enable', 'etl53', '2018-09-29 15:07:02', 'etl53', '2018-09-29 15:07:02');
INSERT INTO `sb_app` VALUES (130, 'yidali_app_test', NULL, 'bMvRYmtxboVkRWo', '0003e287781b462dab12cd7aa0a3fae6', '创建应用testabc', 'enable', 'yidali', '2018-10-26 16:07:51', 'yidali', '2018-10-26 16:07:51');
INSERT INTO `sb_app` VALUES (131, 'Steven', NULL, 'eqqPTvUDrtFpSuE', '2f1e9b814a7446b69ea40e75248d3888', '', 'enable', 'etl63', '2018-10-31 15:16:31', 'etl63', '2018-10-31 15:16:31');
INSERT INTO `sb_app` VALUES (132, 'aaaaaa', NULL, 'XPQcarYAUcNrNUK', '53e01a60c428430c845679bed2d73977', 'aaaa', 'enable', 'etl63', '2018-11-01 10:34:04', 'etl63', '2018-11-01 10:34:04');
INSERT INTO `sb_app` VALUES (133, '测试数据', NULL, 'enDIWaLICTxYCvT', '5552b29d77994a6693200685309cac15', '测试数据1', 'enable', 'etl64', '2018-11-09 14:49:19', 'etl64', '2018-11-09 14:49:19');
INSERT INTO `sb_app` VALUES (134, '测试数据1', NULL, 'vPgmrGuQKZvHvJj', 'f3eef32024074ceca015c6f53d7d3b1e', '测试数据3', 'enable', 'etl64', '2018-11-09 14:52:54', 'etl64', '2018-11-09 14:52:54');
INSERT INTO `sb_app` VALUES (135, '中文', NULL, 'qCGZNIwGkHRKlkD', 'c0200edd66544c3fbf959036915ac3ae', '', 'enable', 'etl5', '2018-11-09 15:32:05', 'etl5', '2018-11-09 15:32:05');
INSERT INTO `sb_app` VALUES (136, '深圳环境Redis', NULL, 'WqOjndHTklNhDPW', '87bc47c8231c473c8c8766eafc516570', '', 'enable', 'yidali', '2018-11-09 15:44:01', 'yidali', '2018-11-09 15:44:01');
INSERT INTO `sb_app` VALUES (137, '资源', NULL, 'iZiBUInJZWUIwZf', '6c9c72419fb14c93962be6786f017c4a', '', 'enable', 'oyr', '2018-11-10 14:29:16', 'oyr', '2018-11-10 14:29:16');
INSERT INTO `sb_app` VALUES (138, 'app_one', NULL, 'SFsAovXMIfGgdpi', 'f014deeab7ed49eab4d79f1bea0760b8', '测试', 'enable', 'yidali', '2018-11-10 17:02:28', 'yidali', '2018-11-10 17:02:28');
INSERT INTO `sb_app` VALUES (139, 'sssss', NULL, 'MyLXEcQAKdOORep', '41f612c510354d20ac1ddfa4512ab28d', '', 'enable', 'etl63', '2018-11-28 17:01:24', 'etl63', '2018-11-28 17:01:24');
INSERT INTO `sb_app` VALUES (140, 'WWWRW', NULL, 'XMAhVlEorCYktcB', 'fd83af66b237472f9ac634117a4a3a7b', '', 'enable', 'etl63', '2018-11-28 17:01:28', 'etl63', '2018-11-28 17:01:28');
INSERT INTO `sb_app` VALUES (141, 'WWWWW', NULL, 'iIyPPPVtTvbooHL', '812061bb5eee4dbfb341013908a6cf19', '', 'enable', 'etl63', '2018-11-28 17:01:36', 'etl63', '2018-11-28 17:01:36');
INSERT INTO `sb_app` VALUES (142, 'sswww', NULL, 'djkWtxVHvsDBrFD', 'ca5f6b9a5c974ee587d0f061387bbb25', '', 'enable', 'new88', '2019-03-20 16:07:53', 'new88', '2019-03-20 16:07:53');
INSERT INTO `sb_app` VALUES (143, 'www465', NULL, 'EYjZXKoJjuexiHt', '93ae5355eeab461e8511855726ea5995', 'www465', 'enable', 'new88', '2019-03-20 16:08:02', 'new88', '2019-03-20 16:08:02');
-- ----------------------------
-- Table structure for sb_service_meta_data
-- ----------------------------
DROP TABLE IF EXISTS `sb_service_meta_data`;
CREATE TABLE `sb_service_meta_data` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`service_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '服务id',
`title` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服务说明',
`group_title` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服务组名',
`version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服务版本',
`need_in_session` tinyint(1) NULL DEFAULT NULL COMMENT '是否需要会话检查',
`ignore_sign` tinyint(1) NULL DEFAULT NULL COMMENT '是否需要签名检查',
`action_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求类型',
`timeout` int(11) NULL DEFAULT NULL COMMENT '超时时间',
`obsoleted` tinyint(1) NULL DEFAULT NULL COMMENT '服务是否过期',
`input_meta_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '输入json',
`output_meta_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '响应json',
`creator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`create_time` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间',
`modifier` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
`modify_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 98 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of sb_service_meta_data
-- ----------------------------
INSERT INTO `sb_service_meta_data` VALUES (89, 'auth.logout', '注销', '平台公用', '1.0', 1, 0, 'POST GET', -1, 0, NULL, '[{\"description\":\"返回结果\",\"limited\":\"\",\"name\":\"successful\",\"required\":false,\"sample\":\"true,false\",\"type\":\"boolean\"}]', '0', '2018-10-26 15:59:23', '0', '2019-03-18 18:59:02');
INSERT INTO `sb_service_meta_data` VALUES (90, 'query.hdfs.download', '文件下载', '查询服务', '1.0', 1, 0, 'POST ', -1, 0, '[{\"description\":\"远程目标文件地址\",\"limited\":\"\",\"name\":\"fetchFilePath\",\"required\":true,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"文件分块大小\",\"limited\":\"\",\"name\":\"blockSize\",\"required\":false,\"sample\":\"1024 * 1024\",\"type\":\"int\"},{\"description\":\"文件保存路径\",\"limited\":\"\",\"name\":\"saveFilePath\",\"required\":false,\"sample\":\"D:/temp\",\"type\":\"string\"},{\"description\":\"文件保存名称\",\"limited\":\"\",\"name\":\"saveFileName\",\"required\":false,\"sample\":\"\",\"type\":\"string\"}]', '[{\"description\":\"文件名称\",\"limited\":\"\",\"name\":\"fileName\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"文件总的大小\",\"limited\":\"\",\"name\":\"fileSize\",\"required\":false,\"sample\":\"\",\"type\":\"long\"},{\"description\":\"块数据\",\"limited\":\"\",\"name\":\"blockBytes\",\"required\":false,\"sample\":\"\",\"type\":\"byte[]\"},{\"description\":\"是否结束\",\"limited\":\"\",\"name\":\"bEnd\",\"required\":false,\"sample\":\"\",\"type\":\"boolean\"},{\"description\":\"执行成功与否\",\"limited\":\"\",\"name\":\"successful\",\"required\":false,\"sample\":\"true | false\",\"type\":\"boolean\"},{\"description\":\"错误信息\",\"limited\":\"\",\"name\":\"exception\",\"required\":false,\"sample\":\"\",\"type\":\"string\"}]', '0', '2018-10-26 15:59:23', '0', '2019-03-18 18:59:02');
INSERT INTO `sb_service_meta_data` VALUES (91, 'query.es.document', '索引文档搜索', '查询服务', '1.0', 1, 0, 'POST ', -1, 0, '[{\"description\":\"索引名或索引同义词\",\"limited\":\"\",\"name\":\"index\",\"required\":true,\"sample\":\"es_index_1_1 | es_index_1\",\"type\":\"string\"},{\"description\":\"索引类型\",\"limited\":\"\",\"name\":\"type\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"查询条件参数\",\"limited\":\"\",\"name\":\"queryCriterionList\",\"required\":false,\"sample\":\"\",\"type\":\"EsQueryCriteriaDto[]\",\"typeFields\":[{\"description\":\"单字段搜索或过滤：索引文档字段名\",\"limited\":\"\",\"name\":\"fieldName\",\"required\":false,\"sample\":\"address\",\"type\":\"string\"},{\"description\":\"多字段搜索或过滤：索引文档字段名\",\"limited\":\"\",\"name\":\"fieldNames\",\"required\":false,\"sample\":\"[\\\"address\\\",\\\"desc\\\"]\",\"type\":\"string[]\"},{\"description\":\"全文搜索内容关键字\",\"limited\":\"\",\"name\":\"value\",\"required\":true,\"sample\":\"文档字段内容：“书籍” | DSL {“query”:{“prefix”:{“comment”:“跨”}}}\",\"type\":\"object\"},{\"description\":\"单字段搜索或过滤：匹配值多个\",\"limited\":\"\",\"name\":\"values\",\"required\":false,\"sample\":\"[\\\"广东\\\",\\\"湖南\\\"]\",\"type\":\"object[]\"},{\"description\":\"范围开始、结束\",\"limited\":\"\",\"name\":\"rangeFrom\",\"required\":false,\"sample\":\"10\",\"type\":\"object\"},{\"description\":\"范围开始、结束\",\"limited\":\"\",\"name\":\"rangeTo\",\"required\":false,\"sample\":\"99\",\"type\":\"object\"},{\"description\":\"布尔模式-枚举类型\",\"limited\":\"\",\"name\":\"boolMode\",\"required\":false,\"sample\":\"BoolMode.MUST/BoolMode.MUST_NOT/BoolMode.SHOULD/BoolMode.FILTER\"},{\"description\":\"查询模式-枚举类型\",\"limited\":\"\",\"name\":\"queryMode\",\"required\":false,\"sample\":\"TERM/TERMS/MATCH/MATCH_MULTI/MATCH_ALL/QUERY_STRING/QUERY_WRAPPER/RANGE/FUZZY/IDS\"}]},{\"description\":\"查询结果提取参数\",\"limited\":\"\",\"name\":\"fetchCriteria\",\"required\":false,\"sample\":\"\",\"type\":\"EsFetchCriteriaDto\",\"typeFields\":[{\"description\":\"是否提取文档源数据。默认获取\",\"limited\":\"\",\"name\":\"fetchSource\",\"required\":false,\"sample\":\"true\",\"type\":\"boolean\"},{\"description\":\"source中包含多个字段，想在结果中返回用户指定的字段。默认所有\",\"limited\":\"\",\"name\":\"sourceFields\",\"required\":false,\"sample\":\"\",\"type\":\"string[]\"},{\"description\":\"排序参数\",\"limited\":\"\",\"name\":\"sortList\",\"required\":false,\"sample\":\"\",\"type\":\"EsSortDto[]\",\"typeFields\":[{\"description\":\"排序字段名称\",\"limited\":\"\",\"name\":\"field\",\"required\":false,\"sample\":\"address\",\"type\":\"string\"},{\"description\":\"排序枚举 DESC | AES。默认ASC\",\"limited\":\"\",\"name\":\"sortOrder\",\"required\":false,\"sample\":\"SortOrder.ASC\"}]},{\"description\":\"高亮参数对象\",\"limited\":\"\",\"name\":\"highlightDto\",\"required\":false,\"sample\":\"\",\"type\":\"EsHighlightDto\",\"typeFields\":[{\"description\":\"高亮字段Set集合\",\"limited\":\"\",\"name\":\"fields\",\"required\":false,\"sample\":\"[\\\"address\\\",\\\"desc\\\"]\",\"type\":\"string[]\"},{\"description\":\"高亮Http标签前缀\",\"limited\":\"html标签\",\"name\":\"preTags\",\"required\":false,\"sample\":\"<font color=\\\"#ff55ae\\\">\",\"type\":\"string[]\"},{\"description\":\"高亮Http标签后缀\",\"limited\":\"html标签\",\"name\":\"postTags\",\"required\":false,\"sample\":\"</font>\",\"type\":\"string[]\"},{\"description\":\"每一个高亮片段字符大小。默认100\",\"limited\":\"\",\"name\":\"fragmentSize\",\"required\":false,\"sample\":\"200\",\"type\":\"int\"},{\"description\":\"高亮文本片段的(最大)数量。默认5\",\"limited\":\"\",\"name\":\"numberOfFragments\",\"required\":false,\"sample\":\"10\",\"type\":\"int\"}]},{\"description\":\"分页提取-分页数（从1开始\",\"limited\":\"\",\"name\":\"pageNum\",\"required\":false,\"sample\":\"1\",\"type\":\"int\"},{\"description\":\"分页提取-每页数量\",\"limited\":\"\",\"name\":\"pageSize\",\"required\":false,\"sample\":\"10\",\"type\":\"int\"},{\"description\":\"分卷提取-搜索超时时间。默认6000毫秒\",\"limited\":\"\",\"name\":\"scrollTimeout\",\"required\":false,\"sample\":\"10000\",\"type\":\"long\"},{\"description\":\"分卷提取-每卷查询数据量。默认100条\",\"limited\":\"\",\"name\":\"scrollSize\",\"required\":false,\"sample\":\"200\",\"type\":\"int\"},{\"description\":\"内容提取方式。枚举类型\",\"limited\":\"\",\"name\":\"fetchMode\",\"required\":false,\"sample\":\"EsFetchMode.PAGE/EsFetchMode.SCROLL/EsFetchMode.NORMAL\"}]}]', '[{\"description\":\"命中总数\",\"limited\":\"\",\"name\":\"total\",\"required\":false,\"sample\":\"\",\"type\":\"long\"},{\"description\":\"命中文档数据\",\"limited\":\"\",\"name\":\"docHitsList\",\"required\":false,\"sample\":\"\",\"type\":\"EsQueryDocHitsDto[]\",\"typeFields\":[{\"description\":\"索引名\",\"limited\":\"\",\"name\":\"index\",\"required\":false,\"sample\":\"es_index_1_1\",\"type\":\"string\"},{\"description\":\"索引类型\",\"limited\":\"\",\"name\":\"type\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"文档ID\",\"limited\":\"\",\"name\":\"id\",\"required\":false,\"sample\":\"AVwP7xZYFHs2AAEMCgjG\",\"type\":\"string\"},{\"description\":\"索引文档字段\",\"limited\":\"\",\"name\":\"docFieldList\",\"required\":false,\"sample\":\"\",\"type\":\"EsQueryDocFieldDto[]\",\"typeFields\":[{\"description\":\"文档字段名\",\"limited\":\"\",\"name\":\"fieldName\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"文档字段值\",\"limited\":\"\",\"name\":\"fieldValue\",\"required\":false,\"sample\":\"\",\"type\":\"object\"}]}]},{\"description\":\"执行成功与否\",\"limited\":\"\",\"name\":\"successful\",\"required\":false,\"sample\":\"true | false\",\"type\":\"boolean\"},{\"description\":\"错误信息\",\"limited\":\"\",\"name\":\"exception\",\"required\":false,\"sample\":\"\",\"type\":\"string\"}]', '0', '2018-10-26 15:59:23', '0', '2019-03-18 18:59:02');
INSERT INTO `sb_service_meta_data` VALUES (92, 'auth.login', '免密码登录', '平台公用', '1.0', 0, 0, 'POST GET', -1, 0, '[{\"description\":\"用户名\",\"limited\":\"最大长度255\",\"name\":\"userName\",\"required\":true,\"sample\":\"admin123\",\"type\":\"string\"}]', '[{\"description\":\"会话ID\",\"limited\":\"\",\"name\":\"sessionId\",\"required\":false,\"sample\":\"1122233\",\"type\":\"string\"}]', '0', '2018-10-26 15:59:23', '0', '2018-11-10 14:42:06');
INSERT INTO `sb_service_meta_data` VALUES (93, 'query.hdfs.listFiles', '目录文件查询', '查询服务', '1.0', 1, 0, 'POST ', -1, 0, '[{\"description\":\"远程目标文件地址\",\"limited\":\"\",\"name\":\"remoteFilePath\",\"required\":false,\"sample\":\"\",\"type\":\"string\"}]', '[{\"description\":\"目录文件数据\",\"limited\":\"\",\"name\":\"fileList\",\"required\":false,\"sample\":\"\",\"type\":\"HdfsFileInfo[]\",\"typeFields\":[{\"description\":\"文件名称\",\"limited\":\"\",\"name\":\"fileName\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"文件路径\",\"limited\":\"\",\"name\":\"filePath\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"是否是文件\",\"limited\":\"\",\"name\":\"isFile\",\"required\":false,\"sample\":\"\",\"type\":\"boolean\"},{\"description\":\"文件长度\",\"limited\":\"\",\"name\":\"fileLen\",\"required\":false,\"sample\":\"\",\"type\":\"long\"},{\"description\":\"文件修改日期\",\"limited\":\"\",\"name\":\"modifiedTime\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"上次访问日期\",\"limited\":\"\",\"name\":\"accessTime\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"文件副本数\",\"limited\":\"\",\"name\":\"replicates\",\"required\":false,\"sample\":\"\",\"type\":\"int\"},{\"description\":\"文件所有者\",\"limited\":\"\",\"name\":\"owner\",\"required\":false,\"sample\":\"admin\",\"type\":\"string\"},{\"description\":\"文件所在的分组\",\"limited\":\"\",\"name\":\"groupName\",\"required\":false,\"sample\":\"hadoop\",\"type\":\"string\"},{\"description\":\"文件的权限\",\"limited\":\"\",\"name\":\"permissions\",\"required\":false,\"sample\":\"drwxr-xr-x\",\"type\":\"string\"}]},{\"description\":\"执行成功与否\",\"limited\":\"\",\"name\":\"successful\",\"required\":false,\"sample\":\"true | false\",\"type\":\"boolean\"},{\"description\":\"错误信息\",\"limited\":\"\",\"name\":\"exception\",\"required\":false,\"sample\":\"\",\"type\":\"string\"}]', '0', '2018-10-26 15:59:23', '0', '2019-03-18 18:59:02');
INSERT INTO `sb_service_meta_data` VALUES (94, 'added.es.document', '添加索引文档', '新增服务', '1.0', 1, 0, 'POST ', -1, 0, '[{\"description\":\"文件数据集合\",\"limited\":\"\",\"name\":\"addedDoc\",\"required\":false,\"sample\":\"\",\"type\":\"EsAddedDoc\",\"typeFields\":[{\"description\":\"文件数据集合\",\"limited\":\"\",\"name\":\"docDetails\",\"required\":false,\"sample\":\"\",\"type\":\"EsAddedDocDetail[]\",\"typeFields\":[{\"description\":\"索引名\",\"limited\":\"\",\"name\":\"index\",\"required\":true,\"sample\":\"es_index_1_1\",\"type\":\"string\"},{\"description\":\"索引类型\",\"limited\":\"\",\"name\":\"type\",\"required\":true,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"文档ID\",\"limited\":\"\",\"name\":\"docId\",\"required\":false,\"sample\":\"AVwP7xZYFHs2AAEMCgjG\",\"type\":\"string\"},{\"description\":\"新增索引文档集合\",\"limited\":\"\",\"name\":\"docFieldMap\",\"required\":false,\"sample\":\"\",\"type\":\"Map\"}]}]}]', '[{\"description\":\"执行成功与否\",\"limited\":\"\",\"name\":\"successful\",\"required\":false,\"sample\":\"true | false\",\"type\":\"boolean\"},{\"description\":\"错误信息\",\"limited\":\"\",\"name\":\"exception\",\"required\":false,\"sample\":\"\",\"type\":\"string\"}]', '0', '2018-10-26 15:59:23', '0', '2019-03-18 18:59:02');
INSERT INTO `sb_service_meta_data` VALUES (95, 'query.sql', '执行sql查询语句返回结果', '查询服务', '1.0', 1, 0, 'POST ', -1, 0, '[{\"description\":\"模式ID\",\"limited\":\"\",\"name\":\"schemaId\",\"required\":true,\"sample\":\"testMysql\",\"type\":\"string\"},{\"description\":\"sql语句\",\"limited\":\"\",\"name\":\"sql\",\"required\":true,\"sample\":\"select * from test\",\"type\":\"string\"}]', '[{\"description\":\"行数据\",\"limited\":\"\",\"name\":\"data\",\"required\":false,\"sample\":\"\",\"type\":\"RowData[]\",\"typeFields\":[{\"description\":\"列数据\",\"limited\":\"\",\"name\":\"columns\",\"required\":false,\"sample\":\"\",\"type\":\"ColumnValue[]\",\"typeFields\":[{\"description\":\"列名\",\"limited\":\"\",\"name\":\"columnName\",\"required\":false,\"sample\":\"\",\"type\":\"string\"},{\"description\":\"列值\",\"limited\":\"\",\"name\":\"value\",\"required\":false,\"sample\":\"\",\"type\":\"object\"}]}]},{\"description\":\"是否执行成功\",\"limited\":\"\",\"name\":\"successful\",\"required\":false,\"sample\":\"true,false\",\"type\":\"boolean\"},{\"description\":\"错误信息\",\"limited\":\"\",\"name\":\"exception\",\"required\":false,\"sample\":\"不存在的表名:table1\",\"type\":\"string\"}]', '0', '2018-10-26 15:59:23', '0', '2019-03-18 18:59:02');
INSERT INTO `sb_service_meta_data` VALUES (96, 'query.es.metadata', '索引元数据查询', '查询服务', '1.0', 1, 0, 'POST ', -1, 0, '[{\"description\":\"索引名或索引同义词\",\"limited\":\"\",\"name\":\"index\",\"required\":true,\"sample\":\"es_index_1_1 | es_index_1\",\"type\":\"string\"},{\"description\":\"索引元数据Id\",\"limited\":\"\",\"name\":\"metaId\",\"required\":true,\"sample\":\"\",\"type\":\"long\"}]', '[{\"description\":\"索引名\",\"limited\":\"\",\"name\":\"metaData\",\"required\":false,\"sample\":\"es_index_1_1\",\"type\":\"string\"},{\"description\":\"执行成功与否\",\"limited\":\"\",\"name\":\"successful\",\"required\":false,\"sample\":\"true | false\",\"type\":\"boolean\"},{\"description\":\"错误信息\",\"limited\":\"\",\"name\":\"exception\",\"required\":false,\"sample\":\"\",\"type\":\"string\"}]', '0', '2018-10-26 15:59:23', '0', '2019-03-18 18:59:02');
INSERT INTO `sb_service_meta_data` VALUES (97, 'auth.logon', '免密码登录', '平台公用', '1.0', 0, 0, 'POST GET', -1, 0, '[{\"description\":\"用户名\",\"limited\":\"最大长度255\",\"name\":\"userName\",\"required\":true,\"sample\":\"admin123\",\"type\":\"string\"}]', '[{\"description\":\"会话ID\",\"limited\":\"\",\"name\":\"sessionId\",\"required\":false,\"sample\":\"1122233\",\"type\":\"string\"}]', '0', '2018-11-14 14:19:18', '0', '2019-03-18 18:59:02');
SET FOREIGN_KEY_CHECKS = 1;