ä¸ãä¸è½½é¡¹ç®å
ãã1.ä¸è½½ææ°çå°å¹ºé¸¡å®è£ å ï¼ä¼ éé¨ï¼http://git.oschina.net/zhoujingjie/apiManager/releases
ãã2.å°å°å¹ºé¸¡çwarå ä¸ä¼ è³/usr/local/tomcat/webappsç®å½ä¸ï¼ä¸éè¦è§£å
ãã3.ä¸ä¼ apiManager/xiaoyaoji-web/src/main/resourcesç®å½ä¸çconfig.propertiesãlog4j.propertiesè³/usr/local/tomcat/conf
ãã
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsISM9AnYldnJwAzN9c3Pn5GcuQ0MlQ0MlcnW1JkbMRzYU1UejRVTzUERPhHMD5kMJpnT5VFROJTRU1EeZRUT1UERNlHMD1ENVR0T4lEVNZXWE1UNFRUT5hzQNRTVE9EeJRVT2NmMiNnSywEd5ITW110MaZHetlVdO1GT0UERNl3YXJGc5kHT20ESjBjUIF2Lc12bj5SYphXa5VWen5WY35iclN3Ztl2Lc9CX6MHc0RHaiojIsJye.png)
ãã4.æ°å»ºMySQLæ°æ®åºï¼ç¼ç æ ¼å¼æ¯utf-8
1 create database `xiaoyaoji` character set utf-8;
ãã5.å建表ç»æï¼ç´æ¥æ·è´å°Navicatä¸è¿è¡å³å¯
1 SET FOREIGN_KEY_CHECKS=0;
2
3 -- ----------------------------
4 -- Table structure for attach
5 -- ----------------------------
6 DROP TABLE IF EXISTS `attach`;
7 CREATE TABLE `attach` (
8 `id` char(12) NOT NULL,
9 `url` varchar(1000) DEFAULT NULL,
10 `type` varchar(45) DEFAULT NULL,
11 `sort` int(11) DEFAULT NULL,
12 `relatedId` char(12) DEFAULT NULL,
13 `fileName` varchar(1000) DEFAULT NULL,
14 `createTime` datetime DEFAULT NULL,
15 `projectId` char(12) DEFAULT NULL,
16 PRIMARY KEY (`id`),
17 KEY `normal` (`relatedId`)
18 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
19
20 -- ----------------------------
21 -- Table structure for doc
22 -- ----------------------------
23 DROP TABLE IF EXISTS `doc`;
24 CREATE TABLE `doc` (
25 `id` char(12) NOT NULL,
26 `name` varchar(200) DEFAULT NULL,
27 `sort` int(11) DEFAULT \'100\',
28 `type` varchar(100) DEFAULT NULL,
29 `content` longtext,
30 `createTime` datetime DEFAULT NULL,
31 `lastUpdateTime` datetime DEFAULT NULL,
32 `parentId` char(12) DEFAULT NULL,
33 `projectId` char(12) DEFAULT NULL,
34 PRIMARY KEY (`id`),
35 KEY `parentId` (`parentId`) USING BTREE,
36 KEY `projectId` (`projectId`) USING BTREE
37 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
38
39 -- ----------------------------
40 -- Table structure for doc_history
41 -- ----------------------------
42 DROP TABLE IF EXISTS `doc_history`;
43 CREATE TABLE `doc_history` (
44 `id` int(11) NOT NULL AUTO_INCREMENT,
45 `name` varchar(200) DEFAULT NULL,
46 `sort` int(11) DEFAULT \'100\',
47 `type` varchar(100) DEFAULT NULL,
48 `content` longtext,
49 `createTime` datetime DEFAULT NULL,
50 `parentId` char(12) DEFAULT NULL,
51 `projectId` char(12) DEFAULT NULL,
52 `comment` varchar(1000) DEFAULT NULL,
53 `userId` char(12) DEFAULT NULL,
54 `docId` char(12) DEFAULT NULL,
55 PRIMARY KEY (`id`)
56 ) ENGINE=InnoDB AUTO_INCREMENT=51473 DEFAULT CHARSET=utf8mb4;
57
58 -- ----------------------------
59 -- Table structure for email_token
60 -- ----------------------------
61 DROP TABLE IF EXISTS `email_token`;
62 CREATE TABLE `email_token` (
63 `id` char(12) NOT NULL,
64 `email` varchar(45) NOT NULL,
65 `isUsed` tinyint(1) NOT NULL DEFAULT \'0\',
66 `createtime` datetime NOT NULL,
67 `token` char(32) NOT NULL,
68 PRIMARY KEY (`id`)
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
70
71 -- ----------------------------
72 -- Table structure for find_password
73 -- ----------------------------
74 DROP TABLE IF EXISTS `find_password`;
75 CREATE TABLE `find_password` (
76 `id` char(12) NOT NULL DEFAULT \'\',
77 `email` varchar(45) DEFAULT NULL,
78 `isUsed` tinyint(1) DEFAULT \'0\',
79 `createTime` datetime DEFAULT NULL,
80 PRIMARY KEY (`id`)
81 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
82
83 -- ----------------------------
84 -- Table structure for interface
85 -- ----------------------------
86 DROP TABLE IF EXISTS `interface`;
87 CREATE TABLE `interface` (
88 `id` char(14) NOT NULL DEFAULT \'\',
89 `name` varchar(50) DEFAULT NULL,
90 `description` text,
91 `folderId` char(14) DEFAULT NULL,
92 `url` varchar(300) DEFAULT NULL,
93 `requestMethod` varchar(50) DEFAULT NULL,
94 `contentType` varchar(50) DEFAULT NULL,
95 `requestHeaders` text,
96 `requestArgs` text,
97 `responseArgs` text,
98 `example` mediumtext,
99 `moduleId` varchar(50) DEFAULT NULL,
100 `projectId` char(14) DEFAULT NULL,
101 `lastUpdateTime` datetime DEFAULT NULL,
102 `createTime` datetime DEFAULT NULL,
103 `dataType` varchar(30) DEFAULT NULL,
104 `protocol` varchar(30) DEFAULT NULL,
105 `status` char(10) DEFAULT \'ENABLE\',
106 `sort` int(11) DEFAULT NULL,
107 PRIMARY KEY (`id`),
108 KEY `projectid` (`projectId`) USING BTREE
109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
110
111 -- ----------------------------
112 -- Table structure for interface_folder
113 -- ----------------------------
114 DROP TABLE IF EXISTS `interface_folder`;
115 CREATE TABLE `interface_folder` (
116 `id` char(14) NOT NULL DEFAULT \'\',
117 `name` varchar(50) DEFAULT NULL,
118 `createTime` datetime DEFAULT NULL,
119 `moduleId` char(14) DEFAULT NULL,
120 `projectId` char(14) DEFAULT NULL,
121 `sort` int(11) DEFAULT \'100\',
122 PRIMARY KEY (`id`),
123 KEY `projectid` (`projectId`) USING BTREE
124 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
125
126 -- ----------------------------
127 -- Table structure for module
128 -- ----------------------------
129 DROP TABLE IF EXISTS `module`;
130 CREATE TABLE `module` (
131 `id` char(14) NOT NULL DEFAULT \'\',
132 `name` varchar(50) DEFAULT NULL,
133 `host` varchar(255) DEFAULT NULL,
134 `description` mediumtext,
135 `lastUpdateTime` datetime DEFAULT NULL,
136 `projectId` char(14) DEFAULT NULL,
137 `createTime` datetime DEFAULT NULL,
138 `requestHeaders` text,
139 `requestArgs` text,
140 `sort` int(11) DEFAULT NULL,
141 PRIMARY KEY (`id`),
142 KEY `projectid` (`projectId`) USING BTREE
143 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
144
145 -- ----------------------------
146 -- Table structure for project
147 -- ----------------------------
148 DROP TABLE IF EXISTS `project`;
149 CREATE TABLE `project` (
150 `id` char(14) NOT NULL,
151 `name` varchar(50) DEFAULT NULL,
152 `description` varchar(300) DEFAULT NULL COMMENT \'test\',
153 `teamId` char(14) DEFAULT NULL,
154 `createTime` datetime DEFAULT NULL,
155 `userId` char(14) DEFAULT NULL,
156 `status` varchar(20) DEFAULT \'VALID\',
157 `permission` varchar(20) DEFAULT \'PRIVATE\',
158 `environments` text,
159 `details` text,
160 `lastUpdateTime` datetime DEFAULT NULL,
161 PRIMARY KEY (`id`)
162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
163
164 -- ----------------------------
165 -- Table structure for project_global
166 -- ----------------------------
167 DROP TABLE IF EXISTS `project_global`;
168 CREATE TABLE `project_global` (
169 `id` char(12) NOT NULL DEFAULT \'\',
170 `environment` mediumtext,
171 `http` mediumtext,
172 `projectId` char(12) NOT NULL DEFAULT \'\',
173 `status` mediumtext
174 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
175
176 -- ----------------------------
177 -- Table structure for project_log
178 -- ----------------------------
179 DROP TABLE IF EXISTS `project_log`;
180 CREATE TABLE `project_log` (
181 `id` char(14) NOT NULL DEFAULT \'\',
182 `userId` char(14) DEFAULT NULL,
183 `createTime` datetime DEFAULT NULL,
184 `log` text,
185 `projectId` char(14) DEFAULT NULL,
186 `action` varchar(50) DEFAULT NULL,
187 PRIMARY KEY (`id`),
188 KEY `projectid` (`projectId`) USING BTREE
189 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
190
191 -- ----------------------------
192 -- Table structure for project_user
193 -- ----------------------------
194 DROP TABLE IF EXISTS `project_user`;
195 CREATE TABLE `project_user` (
196 `id` char(14) NOT NULL,
197 `projectId` char(14) DEFAULT NULL,
198 `userId` char(14) DEFAULT NULL,
199 `createTime` datetime DEFAULT NULL,
200 `status` char(255) DEFAULT \'PENDING\',
201 `editable` char(3) DEFAULT \'YES\',
202 `commonlyUsed` char(3) DEFAULT \'NO\',
203 PRIMARY KEY (`id`),
204 KEY `project_user` (`projectId`,`userId`) USING BTREE
205 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
206
207 -- ----------------------------
208 -- Table structure for share
209 -- ----------------------------
210 DROP TABLE IF EXISTS `share`;
211 CREATE TABLE `share` (
212 `id` char(12) NOT NULL DEFAULT \'\',
213 `name` varchar(50) DEFAULT NULL,
214 `createTime` datetime DEFAULT NULL,
215 `userId` char(12) DEFAULT NULL,
216 `shareAll` char(3) DEFAULT NULL,
217 `password` varchar(20) DEFAULT NULL,
218 `moduleIds` varchar(2000) DEFAULT NULL,
219 `projectId` char(12) DEFAULT NULL,
220 `docIds` varchar(2000) DEFAULT NULL,
221 PRIMARY KEY (`id`)
222 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
223
224 -- ----------------------------
225 -- Table structure for sys
226 -- ----------------------------
227 DROP TABLE IF EXISTS `sys`;
228 CREATE TABLE `sys` (
229 `version` varchar(10) DEFAULT NULL
230 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
231
232 -- ----------------------------
233 -- Table structure for team
234 -- ----------------------------
235 DROP TABLE IF EXISTS `team`;
236 CREATE TABLE `team` (
237 `id` char(14) NOT NULL DEFAULT \'\',
238 `name` varchar(50) DEFAULT NULL,
239 `description` varchar(300) DEFAULT NULL,
240 `userId` char(14) DEFAULT NULL,
241 `createTime` datetime DEFAULT NULL,
242 `status` varchar(20) DEFAULT \'VALID\',
243 PRIMARY KEY (`id`)
244 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
245
246 -- ----------------------------
247 -- Table structure for team_user
248 -- ----------------------------
249 DROP TABLE IF EXISTS `team_user`;
250 CREATE TABLE `team_user` (
251 `id` char(14) NOT NULL,
252 `teamId` char(14) DEFAULT NULL,
253 `userId` char(14) DEFAULT NULL,
254 `createTime` datetime DEFAULT NULL,
255 PRIMARY KEY (`id`)
256 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
257
258 -- ----------------------------
259 -- Table structure for user
260 -- ----------------------------
261 DROP TABLE IF EXISTS `user`;
262 CREATE TABLE `user` (
263 `id` char(12) NOT NULL,
264 `email` varchar(45) DEFAULT NULL,
265 `createtime` datetime DEFAULT NULL,
266 `password` char(32) DEFAULT NULL,
267 `type` varchar(5) DEFAULT \'USER\',
268 `nickname` varchar(30) DEFAULT NULL,
269 `avatar` varchar(200) DEFAULT NULL,
270 `status` char(10) DEFAULT NULL,
271 PRIMARY KEY (`id`),
272 UNIQUE KEY `id_UNIQUE` (`id`),
273 UNIQUE KEY `username` (`email`) USING BTREE
274 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
275
276 -- ----------------------------
277 -- Table structure for user_third
278 -- ----------------------------
279 DROP TABLE IF EXISTS `user_third`;
280 CREATE TABLE `user_third` (
281 `id` varchar(60) NOT NULL,
282 `userid` char(12) NOT NULL,
283 `type` varchar(100) DEFAULT NULL,
284 PRIMARY KEY (`id`),
285 KEY `userId` (`userid`)
286 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
287
288 -- ----------------------------
289 -- Procedure structure for trans_module
290 -- ----------------------------
291 DROP PROCEDURE IF EXISTS `trans_module`;
292 DELIMITER ;;
293 CREATE DEFINER=`root`@`%` PROCEDURE `trans_module`()
294 begin
295 DECLARE done INT DEFAULT FALSE;
296 declare id varchar(100);
297 declare name,host,projectId varchar(100);
298 declare lastUpdateTime,createTime datetime;
299 declare description MEDIUMTEXT;
300
301 declare cur1 cursor for select id from module limit 100;
302 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
303
304 open cur1;
305 read_loop: LOOP
306
307 FETCH cur1 into id;
308
309 if done
310 then leave read_loop;
311 end if;
312
313 select id;
314
315 end LOOP;
316 close cur1;
317
318 end
319 ;;
320 DELIMITER ;
6.ä¿®æ¹Tomcatæ件çé ç½®ï¼ä¿®æ¹MySQLå°åï¼ç¨æ·åãå¯ç ä¿¡æ¯å¦ä¸ï¼
ãã
7.æµè§å¨è¾å ¥ç½åï¼è¿è¡è®¿é®Â http://192.168.14.206:8080/xiaoyaoji-2.1.63/
ãã
Â