홈 탐색 도움말
로그인
chendeben
/
zheng
1
0
포크 0
파일 이슈 0 풀 리퀘스트 0 위키
트리: ef2e5dc6d5
브랜치 태그
zheng
/
project-datamodel
/
zheng_20170326_1.sql

zheng_20170326_1.sql 161 KB
히스토리 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849 
  1. /*
    2. 

  2. Navicat MySQL Data Transfer
    3. 

  3. 

  4. Source Server         : 127.0.0.1
    5. 

  5. Source Server Version : 50621
    6. 

  6. Source Host           : localhost:3306
    7. 

  7. Source Database       : zheng
    8. 

  8. 

  9. Target Server Type    : MYSQL
    10. 

  10. Target Server Version : 50621
    11. 

  11. File Encoding         : 65001
    12. 

  12. 

  13. Date: 2017-03-26 02:07:21
    14. 

  14. */
    15. 

  15. 

  16. SET FOREIGN_KEY_CHECKS=0;
    17. 

  17. 

  18. -- ----------------------------
    19. 

  19. -- Table structure for cms_article
    20. 

  20. -- ----------------------------
    21. 

  21. DROP TABLE IF EXISTS `cms_article`;
    22. 

  22. CREATE TABLE `cms_article` (
    23. 

  23.   `article_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章编号',
    24. 

  24.   `topic_id` int(11) DEFAULT NULL COMMENT '所属专题',
    25. 

  25.   `title` varchar(200) NOT NULL COMMENT '文章标题',
    26. 

  26.   `author` varchar(50) DEFAULT NULL COMMENT '文章原作者',
    27. 

  27.   `fromurl` varchar(300) DEFAULT NULL COMMENT '转载来源网址',
    28. 

  28.   `image` varchar(300) DEFAULT NULL COMMENT '封面图',
    29. 

  29.   `keywords` varchar(100) DEFAULT NULL COMMENT '关键字',
    30. 

  30.   `description` varchar(500) DEFAULT NULL COMMENT '简介',
    31. 

  31.   `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '类型(1:普通,2:热门...)',
    32. 

  32.   `allowcomments` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否允许评论(0:不允许,1:允许)',
    33. 

  33.   `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(-1:不通过,0未审核,1:通过)',
    34. 

  34.   `content` mediumtext COMMENT '内容',
    35. 

  35.   `user_id` int(10) unsigned NOT NULL COMMENT '发布人id',
    36. 

  36.   `readnumber` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '阅读数量',
    37. 

  37.   `ctime` bigint(20) unsigned NOT NULL COMMENT '创建时间',
    38. 

  38.   `orders` bigint(20) unsigned NOT NULL COMMENT '排序',
    39. 

  39.   PRIMARY KEY (`article_id`),
    40. 

  40.   KEY `cms_article_orders` (`orders`)
    41. 

  41. ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COMMENT='文章表';
    42. 

  42. 

  43. -- ----------------------------
    44. 

  44. -- Records of cms_article
    45. 

  45. -- ----------------------------
    46. 

  46. INSERT INTO `cms_article` VALUES ('3', '0', '标题1', '1', '1', '1', '1', '1', '1', '1', '0', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1489827019528', '1489827019528');
    47. 

  47. INSERT INTO `cms_article` VALUES ('4', '0', '标题2', '2', '2', '2', '2', '2', '1', '1', '-1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1489827340870', '1489827340870');
    48. 

  48. INSERT INTO `cms_article` VALUES ('5', '0', '标题3', '3', '3', '3', '3', '3', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1489827581414', '1489827581414');
    49. 

  49. INSERT INTO `cms_article` VALUES ('8', '1', '日本从地球消失，我们倍(喜)感(大)心(普)痛(奔)', 'shuzheng', '网络', '', '日本消失,日本地震', '日本从地震中消失', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '999', '1489845594355', '1489845594355');
    50. 

  50. INSERT INTO `cms_article` VALUES ('9', '0', '标题4', '4', '4', '4', '4', '4', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460546198', '1490460546198');
    51. 

  51. INSERT INTO `cms_article` VALUES ('10', '0', '标题5', '5', '5', '5', '5', '5', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460567137', '1490460567137');
    52. 

  52. INSERT INTO `cms_article` VALUES ('11', '0', '标题6', '6', '6', '6', '6', '6', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460575304', '1490460575304');
    53. 

  53. INSERT INTO `cms_article` VALUES ('12', '0', '标题7', '7', '7', '7', '7', '7', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460582004', '1490460582004');
    54. 

  54. INSERT INTO `cms_article` VALUES ('13', '0', '标题8', '8', '8', '8', '8', '8', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460588840', '1490460588840');
    55. 

  55. INSERT INTO `cms_article` VALUES ('14', '0', '标题9', '9', '9', '9', '9', '9', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460596394', '1490460596394');
    56. 

  56. INSERT INTO `cms_article` VALUES ('15', '0', '标题10', '10', '10', '10', '10', '10', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460612370', '1490460612370');
    57. 

  57. INSERT INTO `cms_article` VALUES ('16', '0', '标题11', '11', '11', '11', '11', '11', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460782767', '1490460782767');
    58. 

  58. INSERT INTO `cms_article` VALUES ('17', '0', '标题12', '12', '12', '12', '12', '12', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460792501', '1490460792501');
    59. 

  59. INSERT INTO `cms_article` VALUES ('18', '0', '标题13', '13', '13', '13', '13', '13', '1', '1', '1', '<div class=\"highlight highlight-source-lua\"><pre>zheng\r\n├── zheng<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> SSM框架公共模块</span>\r\n├── zheng<span class=\"pl-k\">-</span>ui <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理系统UI模板（基于bootstrap实现的响应式Material Design风格的通用后台管理系统模板）[端口:1000]</span>\r\n├── zheng<span class=\"pl-k\">-</span>upms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限管理系统（网关）</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> upms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>client <span class=\"pl-c\"><span class=\"pl-c\">--</span> 集成upms依赖包，提供单点认证、授权、统一会话管理</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>upms<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户权限系统及SSO服务端[端口:1111]</span>\r\n├── zheng<span class=\"pl-k\">-</span>cms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 内容管理系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> cms系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>search <span class=\"pl-c\"><span class=\"pl-c\">--</span> 搜索服务[端口:2221]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:2222]</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>job <span class=\"pl-c\"><span class=\"pl-c\">--</span> 消息队列、任务调度等[端口:2223]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>cms<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:2224]</span>\r\n├── zheng<span class=\"pl-k\">-</span>pay <span class=\"pl-c\"><span class=\"pl-c\">--</span> 支付系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:3331]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>pay<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 演示示例[端口:3332]</span>\r\n├── zheng<span class=\"pl-k\">-</span>ucenter <span class=\"pl-c\"><span class=\"pl-c\">--</span> 用户系统(包括第三方登录)</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>home <span class=\"pl-c\"><span class=\"pl-c\">--</span> 网站前台[端口:4441]</span>\r\n├── zheng<span class=\"pl-k\">-</span>wechat <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信公众号管理系统</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>dao <span class=\"pl-c\"><span class=\"pl-c\">--</span> MyBatisGenerator代码生成模块，无需开发</span>\r\n|    |    ├── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> 业务逻辑</span>\r\n|    |    └── zheng<span class=\"pl-k\">-</span>wechat<span class=\"pl-k\">-</span>mp<span class=\"pl-k\">-</span>admin <span class=\"pl-c\"><span class=\"pl-c\">--</span> 后台管理[端口:5551]</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>ucenter<span class=\"pl-k\">-</span>app <span class=\"pl-c\"><span class=\"pl-c\">--</span> 微信小程序后台</span>\r\n├── zheng<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> API接口总线系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>common <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统公共模块</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>api <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc接口包</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>rpc<span class=\"pl-k\">-</span>service <span class=\"pl-c\"><span class=\"pl-c\">--</span> rpc服务提供者</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>api<span class=\"pl-k\">-</span>server <span class=\"pl-c\"><span class=\"pl-c\">--</span> api系统服务端[端口:6666]</span>\r\n├── zheng<span class=\"pl-k\">-</span>oss <span class=\"pl-c\"><span class=\"pl-c\">--</span> 对象存储系统</span>\r\n|    ├── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>sdk <span class=\"pl-c\"><span class=\"pl-c\">--</span> 开发工具包</span>\r\n|    └── zheng<span class=\"pl-k\">-</span>oss<span class=\"pl-k\">-</span>web <span class=\"pl-c\"><span class=\"pl-c\">--</span> 管理界面[端口:7771]</span>\r\n├── zheng<span class=\"pl-k\">-</span>shop <span class=\"pl-c\"><span class=\"pl-c\">--</span> 电子商务系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>im <span class=\"pl-c\"><span class=\"pl-c\">--</span> 即时通讯系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>oa <span class=\"pl-c\"><span class=\"pl-c\">--</span> 办公自动化系统</span>\r\n├── zheng<span class=\"pl-k\">-</span>eoms <span class=\"pl-c\"><span class=\"pl-c\">--</span> 运维系统</span>\r\n└── zheng<span class=\"pl-k\">-</span>demo <span class=\"pl-c\"><span class=\"pl-c\">--</span> 示例模块(包含一些示例代码等)</span></pre></div>', '1', '0', '1490460800634', '1490460800634');
    60. 

  60. 

  61. -- ----------------------------
    62. 

  62. -- Table structure for cms_article_category
    63. 

  63. -- ----------------------------
    64. 

  64. DROP TABLE IF EXISTS `cms_article_category`;
    65. 

  65. CREATE TABLE `cms_article_category` (
    66. 

  66.   `article_category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    67. 

  67.   `article_id` int(10) unsigned NOT NULL COMMENT '文章编号',
    68. 

  68.   `category_id` int(10) unsigned NOT NULL COMMENT '类目编号',
    69. 

  69.   PRIMARY KEY (`article_category_id`),
    70. 

  70.   KEY `cms_article_category_article_id` (`article_id`),
    71. 

  71.   KEY `cms_article_category_category_id` (`category_id`),
    72. 

  72.   CONSTRAINT `FK_Reference_7` FOREIGN KEY (`category_id`) REFERENCES `cms_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    73. 

  73.   CONSTRAINT `FK_Reference_8` FOREIGN KEY (`article_id`) REFERENCES `cms_article` (`article_id`) ON DELETE CASCADE ON UPDATE CASCADE
    74. 

  74. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章类目关联表';
    75. 

  75. 

  76. -- ----------------------------
    77. 

  77. -- Records of cms_article_category
    78. 

  78. -- ----------------------------
    79. 

  79. 

  80. -- ----------------------------
    81. 

  81. -- Table structure for cms_article_tag
    82. 

  82. -- ----------------------------
    83. 

  83. DROP TABLE IF EXISTS `cms_article_tag`;
    84. 

  84. CREATE TABLE `cms_article_tag` (
    85. 

  85.   `article_tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    86. 

  86.   `article_id` int(10) unsigned NOT NULL COMMENT '文章编号',
    87. 

  87.   `tag_id` int(10) unsigned NOT NULL COMMENT '标签编号',
    88. 

  88.   PRIMARY KEY (`article_tag_id`),
    89. 

  89.   KEY `cms_article_tag_article_id` (`article_id`),
    90. 

  90.   KEY `cms_article_tag_tag_id` (`tag_id`),
    91. 

  91.   CONSTRAINT `FK_Reference_3` FOREIGN KEY (`article_id`) REFERENCES `cms_article` (`article_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    92. 

  92.   CONSTRAINT `FK_Reference_4` FOREIGN KEY (`tag_id`) REFERENCES `cms_tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
    93. 

  93. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签关联表';
    94. 

  94. 

  95. -- ----------------------------
    96. 

  96. -- Records of cms_article_tag
    97. 

  97. -- ----------------------------
    98. 

  98. 

  99. -- ----------------------------
    100. 

  100. -- Table structure for cms_book
    101. 

  101. -- ----------------------------
    102. 

  102. DROP TABLE IF EXISTS `cms_book`;
    103. 

  103. CREATE TABLE `cms_book` (
    104. 

  104.   `book_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    105. 

  105.   `user_id` int(10) unsigned NOT NULL COMMENT '用户编号',
    106. 

  106.   `name` varchar(45) NOT NULL COMMENT '书名',
    107. 

  107.   PRIMARY KEY (`book_id`),
    108. 

  108.   KEY `FK_book_1` (`user_id`),
    109. 

  109.   CONSTRAINT `FK_Reference_9` FOREIGN KEY (`user_id`) REFERENCES `cms_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
    110. 

  110. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='书';
    111. 

  111. 

  112. -- ----------------------------
    113. 

  113. -- Records of cms_book
    114. 

  114. -- ----------------------------
    115. 

  115. 

  116. -- ----------------------------
    117. 

  117. -- Table structure for cms_category
    118. 

  118. -- ----------------------------
    119. 

  119. DROP TABLE IF EXISTS `cms_category`;
    120. 

  120. CREATE TABLE `cms_category` (
    121. 

  121.   `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '类目编号',
    122. 

  122.   `pid` int(10) unsigned DEFAULT NULL COMMENT '上级编号',
    123. 

  123.   `level` tinyint(4) NOT NULL COMMENT '层级',
    124. 

  124.   `name` varchar(20) NOT NULL COMMENT '名称',
    125. 

  125.   `description` varchar(200) DEFAULT NULL COMMENT '描述',
    126. 

  126.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    127. 

  127.   `type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '类型(1:普通,2:热门...)',
    128. 

  128.   `alias` varchar(20) DEFAULT NULL COMMENT '别名',
    129. 

  129.   `ctime` bigint(20) unsigned NOT NULL COMMENT '创建时间',
    130. 

  130.   `orders` bigint(255) unsigned NOT NULL COMMENT '排序',
    131. 

  131.   PRIMARY KEY (`category_id`),
    132. 

  132.   KEY `cms_category_orders` (`orders`),
    133. 

  133.   KEY `cms_category_pid` (`pid`),
    134. 

  134.   KEY `cms_category_alias` (`alias`),
    135. 

  135.   KEY `cms_category_level` (`level`),
    136. 

  136.   CONSTRAINT `FK_Reference_10` FOREIGN KEY (`pid`) REFERENCES `cms_category` (`category_id`) ON DELETE SET NULL
    137. 

  137. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='类目表';
    138. 

  138. 

  139. -- ----------------------------
    140. 

  140. -- Records of cms_category
    141. 

  141. -- ----------------------------
    142. 

  142. INSERT INTO `cms_category` VALUES ('5', null, '1', '经济', '经济类目', '', '1', 'economic', '1489590733919', '1489590733919');
    143. 

  143. INSERT INTO `cms_category` VALUES ('6', '5', '2', '中国经济', '中国经济类目', '', '1', 'chinaeconomic', '1489590768989', '1489590768989');
    144. 

  144. 

  145. -- ----------------------------
    146. 

  146. -- Table structure for cms_category_tag
    147. 

  147. -- ----------------------------
    148. 

  148. DROP TABLE IF EXISTS `cms_category_tag`;
    149. 

  149. CREATE TABLE `cms_category_tag` (
    150. 

  150.   `category_tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    151. 

  151.   `category_id` int(10) unsigned NOT NULL COMMENT '类目编号',
    152. 

  152.   `tag_id` int(10) unsigned NOT NULL COMMENT '标签编号',
    153. 

  153.   PRIMARY KEY (`category_tag_id`),
    154. 

  154.   KEY `cms_category_tag_tag_id` (`tag_id`),
    155. 

  155.   KEY `cms_category_tag_category_id` (`category_id`),
    156. 

  156.   CONSTRAINT `FK_Reference_5` FOREIGN KEY (`category_id`) REFERENCES `cms_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    157. 

  157.   CONSTRAINT `FK_Reference_6` FOREIGN KEY (`tag_id`) REFERENCES `cms_tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
    158. 

  158. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='类目标签关联表';
    159. 

  159. 

  160. -- ----------------------------
    161. 

  161. -- Records of cms_category_tag
    162. 

  162. -- ----------------------------
    163. 

  163. 

  164. -- ----------------------------
    165. 

  165. -- Table structure for cms_comment
    166. 

  166. -- ----------------------------
    167. 

  167. DROP TABLE IF EXISTS `cms_comment`;
    168. 

  168. CREATE TABLE `cms_comment` (
    169. 

  169.   `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    170. 

  170.   `pid` int(10) unsigned DEFAULT NULL COMMENT '回复楼中楼编号回复楼中楼编号',
    171. 

  171.   `article_id` int(10) unsigned NOT NULL COMMENT '文章编号',
    172. 

  172.   `user_id` int(10) unsigned NOT NULL COMMENT '用户编号',
    173. 

  173.   `content` text NOT NULL COMMENT '评论内容',
    174. 

  174.   `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(-1:不通过,0:未审核,1:通过)',
    175. 

  175.   `ip` varchar(30) DEFAULT NULL COMMENT '评论人ip地址',
    176. 

  176.   `agent` varchar(200) DEFAULT NULL COMMENT '评论人终端信息',
    177. 

  177.   `ctime` bigint(20) NOT NULL COMMENT '创建时间',
    178. 

  178.   PRIMARY KEY (`comment_id`),
    179. 

  179.   KEY `cms_comment_article_id` (`article_id`),
    180. 

  180.   KEY `FK_Reference_2` (`pid`),
    181. 

  181.   CONSTRAINT `FK_Reference_1` FOREIGN KEY (`article_id`) REFERENCES `cms_article` (`article_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    182. 

  182.   CONSTRAINT `FK_Reference_2` FOREIGN KEY (`pid`) REFERENCES `cms_comment` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE
    183. 

  183. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论表';
    184. 

  184. 

  185. -- ----------------------------
    186. 

  186. -- Records of cms_comment
    187. 

  187. -- ----------------------------
    188. 

  188. 

  189. -- ----------------------------
    190. 

  190. -- Table structure for cms_menu
    191. 

  191. -- ----------------------------
    192. 

  192. DROP TABLE IF EXISTS `cms_menu`;
    193. 

  193. CREATE TABLE `cms_menu` (
    194. 

  194.   `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    195. 

  195.   `pid` int(11) DEFAULT NULL COMMENT '父菜单',
    196. 

  196.   `name` varchar(20) DEFAULT NULL COMMENT '名称',
    197. 

  197.   `url` varchar(100) DEFAULT NULL COMMENT '链接',
    198. 

  198.   `target` varchar(10) DEFAULT NULL COMMENT '打开方式',
    199. 

  199.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    200. 

  200.   PRIMARY KEY (`menu_id`)
    201. 

  201. ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='菜单';
    202. 

  202. 

  203. -- ----------------------------
    204. 

  204. -- Records of cms_menu
    205. 

  205. -- ----------------------------
    206. 

  206. INSERT INTO `cms_menu` VALUES ('1', null, '首页', '/', '_self', '1489847080380');
    207. 

  207. INSERT INTO `cms_menu` VALUES ('2', null, '问答', '/qa', '_self', '1489847080381');
    208. 

  208. INSERT INTO `cms_menu` VALUES ('3', null, '博客', '/blog', '_self', '1489847186644');
    209. 

  209. INSERT INTO `cms_menu` VALUES ('4', null, '资讯', '/news', '_self', '1489847186645');
    210. 

  210. INSERT INTO `cms_menu` VALUES ('5', null, '专题', '/topic/list', '_self', '1489847186646');
    211. 

  211. INSERT INTO `cms_menu` VALUES ('6', null, '关于', '/page/about', '_self', '1489847186647');
    212. 

  212. 

  213. -- ----------------------------
    214. 

  214. -- Table structure for cms_page
    215. 

  215. -- ----------------------------
    216. 

  216. DROP TABLE IF EXISTS `cms_page`;
    217. 

  217. CREATE TABLE `cms_page` (
    218. 

  218.   `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编码',
    219. 

  219.   `pid` int(10) DEFAULT NULL COMMENT '父页面',
    220. 

  220.   `title` varchar(20) DEFAULT NULL COMMENT '标题',
    221. 

  221.   `alias` varchar(20) DEFAULT NULL COMMENT '别名',
    222. 

  222.   `content` mediumtext COMMENT '页面内容',
    223. 

  223.   `keywords` varchar(100) DEFAULT NULL COMMENT '关键字',
    224. 

  224.   `description` varchar(300) DEFAULT NULL COMMENT '描述',
    225. 

  225.   `ctime` bigint(20) DEFAULT NULL COMMENT '创建时间',
    226. 

  226.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    227. 

  227.   PRIMARY KEY (`page_id`)
    228. 

  228. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='页面';
    229. 

  229. 

  230. -- ----------------------------
    231. 

  231. -- Records of cms_page
    232. 

  232. -- ----------------------------
    233. 

  233. INSERT INTO `cms_page` VALUES ('1', null, '关于', 'about', '作者：张恕征', '单页关键字', '单页描述', '1489839705049', '1489839705049');
    234. 

  234. 

  235. -- ----------------------------
    236. 

  236. -- Table structure for cms_setting
    237. 

  237. -- ----------------------------
    238. 

  238. DROP TABLE IF EXISTS `cms_setting`;
    239. 

  239. CREATE TABLE `cms_setting` (
    240. 

  240.   `setting_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    241. 

  241.   `setting_key` varchar(10) DEFAULT NULL,
    242. 

  242.   `setting_value` varchar(500) DEFAULT NULL,
    243. 

  243.   PRIMARY KEY (`setting_id`)
    244. 

  244. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='网站配置';
    245. 

  245. 

  246. -- ----------------------------
    247. 

  247. -- Records of cms_setting
    248. 

  248. -- ----------------------------
    249. 

  249. INSERT INTO `cms_setting` VALUES ('1', 'copyright', '© 2017 Zhang Shuzheng');
    250. 

  250. 

  251. -- ----------------------------
    252. 

  252. -- Table structure for cms_tag
    253. 

  253. -- ----------------------------
    254. 

  254. DROP TABLE IF EXISTS `cms_tag`;
    255. 

  255. CREATE TABLE `cms_tag` (
    256. 

  256.   `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签编号',
    257. 

  257.   `name` varchar(20) NOT NULL COMMENT '名称',
    258. 

  258.   `description` varchar(200) DEFAULT NULL COMMENT '描述',
    259. 

  259.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    260. 

  260.   `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '类型(1:普通,2:热门...)',
    261. 

  261.   `alias` varchar(20) DEFAULT NULL COMMENT '别名',
    262. 

  262.   `ctime` bigint(20) unsigned NOT NULL COMMENT '创建时间',
    263. 

  263.   `orders` bigint(20) unsigned NOT NULL COMMENT '排序',
    264. 

  264.   PRIMARY KEY (`tag_id`),
    265. 

  265.   KEY `cms_tag_orders` (`orders`),
    266. 

  266.   KEY `cms_tag_alias` (`alias`)
    267. 

  267. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='标签表';
    268. 

  268. 

  269. -- ----------------------------
    270. 

  270. -- Records of cms_tag
    271. 

  271. -- ----------------------------
    272. 

  272. INSERT INTO `cms_tag` VALUES ('1', 'JAVA', 'java标签', '', '1', 'java', '1489585694864', '1489585694864');
    273. 

  273. INSERT INTO `cms_tag` VALUES ('2', 'Android', 'android标签', '', '1', 'android', '1489585720382', '1489585720382');
    274. 

  274. INSERT INTO `cms_tag` VALUES ('3', 'zheng', 'zheng标签', '', '2', 'zheng', '1489585815042', '1489585815042');
    275. 

  275. 

  276. -- ----------------------------
    277. 

  277. -- Table structure for cms_topic
    278. 

  278. -- ----------------------------
    279. 

  279. DROP TABLE IF EXISTS `cms_topic`;
    280. 

  280. CREATE TABLE `cms_topic` (
    281. 

  281.   `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    282. 

  282.   `title` varchar(100) DEFAULT NULL COMMENT '标题',
    283. 

  283.   `description` varchar(300) DEFAULT NULL COMMENT '描述',
    284. 

  284.   `url` varchar(100) DEFAULT NULL COMMENT '链接',
    285. 

  285.   `ctime` bigint(20) DEFAULT NULL COMMENT '创建时间',
    286. 

  286.   PRIMARY KEY (`topic_id`)
    287. 

  287. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='专题';
    288. 

  288. 

  289. -- ----------------------------
    290. 

  290. -- Records of cms_topic
    291. 

  291. -- ----------------------------
    292. 

  292. INSERT INTO `cms_topic` VALUES ('1', '日本地震专题', '日本经历灭国性地震，彻底沉入海底', '/topic/1', '1489843484448');
    293. 

  293. 

  294. -- ----------------------------
    295. 

  295. -- Table structure for cms_user
    296. 

  296. -- ----------------------------
    297. 

  297. DROP TABLE IF EXISTS `cms_user`;
    298. 

  298. CREATE TABLE `cms_user` (
    299. 

  299.   `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    300. 

  300.   `username` varchar(32) DEFAULT NULL COMMENT '账号',
    301. 

  301.   `password` varchar(32) DEFAULT NULL COMMENT '密码',
    302. 

  302.   `nickname` varchar(32) DEFAULT NULL COMMENT '昵称',
    303. 

  303.   `sex` int(11) DEFAULT NULL COMMENT '0未知,1男,2女',
    304. 

  304.   `ctime` bigint(20) DEFAULT NULL COMMENT '创建时间',
    305. 

  305.   `content` text COMMENT '备注',
    306. 

  306.   PRIMARY KEY (`user_id`)
    307. 

  307. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';
    308. 

  308. 

  309. -- ----------------------------
    310. 

  310. -- Records of cms_user
    311. 

  311. -- ----------------------------
    312. 

  312. 

  313. -- ----------------------------
    314. 

  314. -- Table structure for pay_in_order
    315. 

  315. -- ----------------------------
    316. 

  316. DROP TABLE IF EXISTS `pay_in_order`;
    317. 

  317. CREATE TABLE `pay_in_order` (
    318. 

  318.   `pay_in_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    319. 

  319.   `pay_vendor_id` int(10) DEFAULT NULL,
    320. 

  320.   `pay_mch_id` int(10) DEFAULT NULL,
    321. 

  321.   `amount` decimal(10,0) NOT NULL,
    322. 

  322.   `status` tinyint(4) NOT NULL,
    323. 

  323.   `ctime` bigint(20) unsigned NOT NULL,
    324. 

  324.   PRIMARY KEY (`pay_in_order_id`),
    325. 

  325.   KEY `FK_Reference_32` (`pay_vendor_id`),
    326. 

  326.   KEY `FK_Reference_38` (`pay_mch_id`),
    327. 

  327.   CONSTRAINT `FK_Reference_32` FOREIGN KEY (`pay_vendor_id`) REFERENCES `pay_vendor` (`pay_vendor_id`),
    328. 

  328.   CONSTRAINT `FK_Reference_38` FOREIGN KEY (`pay_mch_id`) REFERENCES `pay_mch` (`pay_mch_id`)
    329. 

  329. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收入订单表';
    330. 

  330. 

  331. -- ----------------------------
    332. 

  332. -- Records of pay_in_order
    333. 

  333. -- ----------------------------
    334. 

  334. 

  335. -- ----------------------------
    336. 

  336. -- Table structure for pay_in_order_detail
    337. 

  337. -- ----------------------------
    338. 

  338. DROP TABLE IF EXISTS `pay_in_order_detail`;
    339. 

  339. CREATE TABLE `pay_in_order_detail` (
    340. 

  340.   `pay_in_order_detail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    341. 

  341.   `pay_in_order_id` int(10) DEFAULT NULL,
    342. 

  342.   `product_id` varchar(50) DEFAULT NULL,
    343. 

  343.   `product_name` varchar(100) DEFAULT NULL,
    344. 

  344.   `product_price` decimal(10,0) DEFAULT NULL,
    345. 

  345.   `product_count` int(10) DEFAULT NULL,
    346. 

  346.   `remark` varchar(500) DEFAULT NULL,
    347. 

  347.   PRIMARY KEY (`pay_in_order_detail_id`)
    348. 

  348. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收入订单明细表';
    349. 

  349. 

  350. -- ----------------------------
    351. 

  351. -- Records of pay_in_order_detail
    352. 

  352. -- ----------------------------
    353. 

  353. 

  354. -- ----------------------------
    355. 

  355. -- Table structure for pay_mch
    356. 

  356. -- ----------------------------
    357. 

  357. DROP TABLE IF EXISTS `pay_mch`;
    358. 

  358. CREATE TABLE `pay_mch` (
    359. 

  359.   `pay_mch_id` int(10) NOT NULL AUTO_INCREMENT,
    360. 

  360.   `mch_id` varchar(20) DEFAULT NULL,
    361. 

  361.   `name` varchar(20) DEFAULT NULL,
    362. 

  362.   `reqKey` varchar(50) DEFAULT NULL,
    363. 

  363.   `resKey` varchar(50) DEFAULT NULL,
    364. 

  364.   PRIMARY KEY (`pay_mch_id`)
    365. 

  365. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付中心商户管理表';
    366. 

  366. 

  367. -- ----------------------------
    368. 

  368. -- Records of pay_mch
    369. 

  369. -- ----------------------------
    370. 

  370. 

  371. -- ----------------------------
    372. 

  372. -- Table structure for pay_out_order
    373. 

  373. -- ----------------------------
    374. 

  374. DROP TABLE IF EXISTS `pay_out_order`;
    375. 

  375. CREATE TABLE `pay_out_order` (
    376. 

  376.   `pay_out_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    377. 

  377.   `pay_mch_id` int(10) DEFAULT NULL,
    378. 

  378.   `pay_vendor_id` int(10) DEFAULT NULL,
    379. 

  379.   `amount` decimal(10,0) NOT NULL,
    380. 

  380.   `status` tinyint(4) NOT NULL,
    381. 

  381.   `ctime` bigint(20) unsigned NOT NULL,
    382. 

  382.   PRIMARY KEY (`pay_out_order_id`)
    383. 

  383. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支出订单表';
    384. 

  384. 

  385. -- ----------------------------
    386. 

  386. -- Records of pay_out_order
    387. 

  387. -- ----------------------------
    388. 

  388. 

  389. -- ----------------------------
    390. 

  390. -- Table structure for pay_out_order_detail
    391. 

  391. -- ----------------------------
    392. 

  392. DROP TABLE IF EXISTS `pay_out_order_detail`;
    393. 

  393. CREATE TABLE `pay_out_order_detail` (
    394. 

  394.   `pay_out_order_detail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    395. 

  395.   `pay_out_order_id` int(10) DEFAULT NULL,
    396. 

  396.   `remark` varchar(500) DEFAULT NULL,
    397. 

  397.   PRIMARY KEY (`pay_out_order_detail_id`)
    398. 

  398. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支出订单明细表';
    399. 

  399. 

  400. -- ----------------------------
    401. 

  401. -- Records of pay_out_order_detail
    402. 

  402. -- ----------------------------
    403. 

  403. 

  404. -- ----------------------------
    405. 

  405. -- Table structure for pay_pay
    406. 

  406. -- ----------------------------
    407. 

  407. DROP TABLE IF EXISTS `pay_pay`;
    408. 

  408. CREATE TABLE `pay_pay` (
    409. 

  409.   `pay_pay_id` int(10) NOT NULL AUTO_INCREMENT,
    410. 

  410.   `pay_type_id` int(10) DEFAULT NULL,
    411. 

  411.   `param` varchar(1000) DEFAULT NULL,
    412. 

  412.   PRIMARY KEY (`pay_pay_id`)
    413. 

  413. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付参数配置表';
    414. 

  414. 

  415. -- ----------------------------
    416. 

  416. -- Records of pay_pay
    417. 

  417. -- ----------------------------
    418. 

  418. 

  419. -- ----------------------------
    420. 

  420. -- Table structure for pay_type
    421. 

  421. -- ----------------------------
    422. 

  422. DROP TABLE IF EXISTS `pay_type`;
    423. 

  423. CREATE TABLE `pay_type` (
    424. 

  424.   `pay_type_id` int(10) NOT NULL AUTO_INCREMENT,
    425. 

  425.   `pay_vendor_id` int(10) DEFAULT NULL,
    426. 

  426.   `pay_mch_id` int(10) DEFAULT NULL,
    427. 

  427.   PRIMARY KEY (`pay_type_id`)
    428. 

  428. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商户支持支付类型表';
    429. 

  429. 

  430. -- ----------------------------
    431. 

  431. -- Records of pay_type
    432. 

  432. -- ----------------------------
    433. 

  433. 

  434. -- ----------------------------
    435. 

  435. -- Table structure for pay_vendor
    436. 

  436. -- ----------------------------
    437. 

  437. DROP TABLE IF EXISTS `pay_vendor`;
    438. 

  438. CREATE TABLE `pay_vendor` (
    439. 

  439.   `pay_vendor_id` int(10) NOT NULL AUTO_INCREMENT,
    440. 

  440.   `name` varchar(20) DEFAULT NULL,
    441. 

  441.   `appid` varchar(50) DEFAULT NULL,
    442. 

  442.   `appsecret` varchar(150) DEFAULT NULL,
    443. 

  443.   `config` varchar(1000) DEFAULT NULL,
    444. 

  444.   PRIMARY KEY (`pay_vendor_id`)
    445. 

  445. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='第三方支付标识表';
    446. 

  446. 

  447. -- ----------------------------
    448. 

  448. -- Records of pay_vendor
    449. 

  449. -- ----------------------------
    450. 

  450. 

  451. -- ----------------------------
    452. 

  452. -- Table structure for pay_vest
    453. 

  453. -- ----------------------------
    454. 

  454. DROP TABLE IF EXISTS `pay_vest`;
    455. 

  455. CREATE TABLE `pay_vest` (
    456. 

  456.   `pay_vest_id` int(10) NOT NULL AUTO_INCREMENT,
    457. 

  457.   `pay_type_id` int(10) DEFAULT NULL,
    458. 

  458.   `prefix` varchar(20) DEFAULT NULL,
    459. 

  459.   `param` varchar(1000) DEFAULT NULL,
    460. 

  460.   PRIMARY KEY (`pay_vest_id`)
    461. 

  461. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='马甲支付参数配置表';
    462. 

  462. 

  463. -- ----------------------------
    464. 

  464. -- Records of pay_vest
    465. 

  465. -- ----------------------------
    466. 

  466. 

  467. -- ----------------------------
    468. 

  468. -- Table structure for upms_log
    469. 

  469. -- ----------------------------
    470. 

  470. DROP TABLE IF EXISTS `upms_log`;
    471. 

  471. CREATE TABLE `upms_log` (
    472. 

  472.   `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
    473. 

  473.   `description` varchar(100) DEFAULT NULL COMMENT '操作描述',
    474. 

  474.   `username` varchar(20) DEFAULT NULL COMMENT '操作用户',
    475. 

  475.   `start_time` bigint(20) DEFAULT NULL COMMENT '操作时间',
    476. 

  476.   `spend_time` int(11) DEFAULT NULL COMMENT '消耗时间',
    477. 

  477.   `base_path` varchar(100) DEFAULT NULL COMMENT '根路径',
    478. 

  478.   `uri` varchar(50) DEFAULT NULL COMMENT 'URI',
    479. 

  479.   `url` varchar(200) DEFAULT NULL COMMENT 'URL',
    480. 

  480.   `method` varchar(10) DEFAULT NULL COMMENT '请求类型',
    481. 

  481.   `parameter` text COMMENT '请求参数',
    482. 

  482.   `user_agent` varchar(200) DEFAULT NULL COMMENT '用户标识',
    483. 

  483.   `ip` varchar(30) DEFAULT NULL COMMENT 'IP地址',
    484. 

  484.   `result` text COMMENT '响应结果',
    485. 

  485.   `permissions` varchar(100) DEFAULT NULL COMMENT '权限值',
    486. 

  486.   PRIMARY KEY (`log_id`)
    487. 

  487. ) ENGINE=InnoDB AUTO_INCREMENT=1463 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志';
    488. 

  488. 

  489. -- ----------------------------
    490. 

  490. -- Records of upms_log
    491. 

  491. -- ----------------------------
    492. 

  492. 

  493. -- ----------------------------
    494. 

  494. -- Table structure for upms_organization
    495. 

  495. -- ----------------------------
    496. 

  496. DROP TABLE IF EXISTS `upms_organization`;
    497. 

  497. CREATE TABLE `upms_organization` (
    498. 

  498.   `organization_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    499. 

  499.   `name` varchar(20) DEFAULT NULL COMMENT '组织名称',
    500. 

  500.   `description` varchar(1000) DEFAULT NULL COMMENT '组织描述',
    501. 

  501.   `ctime` bigint(20) DEFAULT NULL COMMENT '创建时间',
    502. 

  502.   PRIMARY KEY (`organization_id`)
    503. 

  503. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='组织';
    504. 

  504. 

  505. -- ----------------------------
    506. 

  506. -- Records of upms_organization
    507. 

  507. -- ----------------------------
    508. 

  508. INSERT INTO `upms_organization` VALUES ('1', '总部', '北京总部', '1');
    509. 

  509. INSERT INTO `upms_organization` VALUES ('4', '河北分部', '河北石家庄', '1488122466236');
    510. 

  510. INSERT INTO `upms_organization` VALUES ('5', '河南分部', '河南郑州', '1488122480265');
    511. 

  511. INSERT INTO `upms_organization` VALUES ('6', '湖北分部', '湖北武汉', '1488122493265');
    512. 

  512. INSERT INTO `upms_organization` VALUES ('7', '湖南分部', '湖南长沙', '1488122502752');
    513. 

  513. 

  514. -- ----------------------------
    515. 

  515. -- Table structure for upms_permission
    516. 

  516. -- ----------------------------
    517. 

  517. DROP TABLE IF EXISTS `upms_permission`;
    518. 

  518. CREATE TABLE `upms_permission` (
    519. 

  519.   `permission_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    520. 

  520.   `system_id` int(10) unsigned NOT NULL COMMENT '所属系统',
    521. 

  521.   `pid` int(10) DEFAULT NULL COMMENT '所属上级',
    522. 

  522.   `name` varchar(20) DEFAULT NULL COMMENT '名称',
    523. 

  523.   `type` tinyint(4) DEFAULT NULL COMMENT '类型(1:目录,2:菜单,3:按钮)',
    524. 

  524.   `permission_value` varchar(50) DEFAULT NULL COMMENT '权限值',
    525. 

  525.   `uri` varchar(100) DEFAULT NULL COMMENT '路径',
    526. 

  526.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    527. 

  527.   `status` tinyint(4) DEFAULT NULL COMMENT '状态(0:禁止,1:正常)',
    528. 

  528.   `ctime` bigint(20) DEFAULT NULL COMMENT '创建时间',
    529. 

  529.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    530. 

  530.   PRIMARY KEY (`permission_id`)
    531. 

  531. ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COMMENT='权限';
    532. 

  532. 

  533. -- ----------------------------
    534. 

  534. -- Records of upms_permission
    535. 

  535. -- ----------------------------
    536. 

  536. INSERT INTO `upms_permission` VALUES ('1', '1', '0', '系统组织管理', '1', '', '', 'zmdi zmdi-accounts-list', '1', '1', '1');
    537. 

  537. INSERT INTO `upms_permission` VALUES ('2', '1', '1', '系统管理', '2', 'upms:system:read', '/manage/system/index', '', '1', '2', '2');
    538. 

  538. INSERT INTO `upms_permission` VALUES ('3', '1', '1', '组织管理', '2', 'upms:organization:read', '/manage/organization/index', '', '1', '3', '3');
    539. 

  539. INSERT INTO `upms_permission` VALUES ('4', '1', '0', '角色用户管理', '1', '', '', 'zmdi zmdi-accounts', '1', '4', '4');
    540. 

  540. INSERT INTO `upms_permission` VALUES ('5', '1', '4', '角色管理', '2', 'upms:role:read', '/manage/role/index', '', '1', '6', '6');
    541. 

  541. INSERT INTO `upms_permission` VALUES ('6', '1', '4', '用户管理', '2', 'upms:user:read', '/manage/user/index', '', '1', '5', '5');
    542. 

  542. INSERT INTO `upms_permission` VALUES ('7', '1', '0', '权限资源管理', '1', '', '', 'zmdi zmdi-lock-outline', '1', '7', '7');
    543. 

  543. INSERT INTO `upms_permission` VALUES ('12', '1', '0', '其他数据管理', '1', '', '', 'zmdi zmdi-more', '1', '12', '12');
    544. 

  544. INSERT INTO `upms_permission` VALUES ('14', '1', '12', '会话管理', '2', 'upms:session:read', '/manage/session/index', '', '1', '14', '14');
    545. 

  545. INSERT INTO `upms_permission` VALUES ('15', '1', '12', '日志记录', '2', 'upms:log:read', '/manage/log/index', '', '1', '15', '15');
    546. 

  546. INSERT INTO `upms_permission` VALUES ('17', '2', '0', '标签类目管理', '1', null, null, 'zmdi zmdi-menu', '1', '17', '17');
    547. 

  547. INSERT INTO `upms_permission` VALUES ('18', '2', '17', '标签管理', '2', 'cms:tag:read', '/manage/tag/index', null, '1', '18', '18');
    548. 

  548. INSERT INTO `upms_permission` VALUES ('19', '2', '17', '类目管理', '2', 'cms:category:read', '/manage/category/index', null, '1', '19', '19');
    549. 

  549. INSERT INTO `upms_permission` VALUES ('20', '2', '0', '文章评论管理', '1', null, null, 'zmdi zmdi-collection-text', '1', '20', '20');
    550. 

  550. INSERT INTO `upms_permission` VALUES ('21', '2', '20', '文章管理', '2', 'cms:article:read', '/manage/article/index', null, '1', '21', '21');
    551. 

  551. INSERT INTO `upms_permission` VALUES ('22', '2', '20', '回收管理', '2', 'cms:article:read', '/manage/article/recycle', null, '1', '22', '22');
    552. 

  552. INSERT INTO `upms_permission` VALUES ('24', '1', '2', '新增系统', '3', 'upms:system:create', '/manage/system/create', 'zmdi zmdi-plus', '1', '24', '24');
    553. 

  553. INSERT INTO `upms_permission` VALUES ('25', '1', '2', '编辑系统', '3', 'upms:system:update', '/manage/system/update', 'zmdi zmdi-edit', '1', '25', '25');
    554. 

  554. INSERT INTO `upms_permission` VALUES ('26', '1', '2', '删除系统', '3', 'upms:system:delete', '/manage/system/delete', 'zmdi zmdi-close', '1', '26', '26');
    555. 

  555. INSERT INTO `upms_permission` VALUES ('27', '1', '3', '新增组织', '3', 'upms:organization:create', '/manage/organization/create', 'zmdi zmdi-plus', '1', '27', '27');
    556. 

  556. INSERT INTO `upms_permission` VALUES ('28', '1', '3', '编辑组织', '3', 'upms:organization:update', '/manage/organization/update', 'zmdi zmdi-edit', '1', '28', '28');
    557. 

  557. INSERT INTO `upms_permission` VALUES ('29', '1', '3', '删除组织', '3', 'upms:organization:delete', '/manage/organization/delete', 'zmdi zmdi-close', '1', '29', '29');
    558. 

  558. INSERT INTO `upms_permission` VALUES ('30', '1', '6', '新增用户', '3', 'upms:user:create', '/manage/user/create', 'zmdi zmdi-plus', '1', '30', '30');
    559. 

  559. INSERT INTO `upms_permission` VALUES ('31', '1', '6', '编辑用户', '3', 'upms:user:update', '/manage/user/update', 'zmdi zmdi-edit', '1', '31', '31');
    560. 

  560. INSERT INTO `upms_permission` VALUES ('32', '1', '6', '删除用户', '3', 'upms:user:delete', '/manage/user/delete', 'zmdi zmdi-close', '1', '32', '32');
    561. 

  561. INSERT INTO `upms_permission` VALUES ('33', '1', '5', '新增角色', '3', 'upms:role:create', '/manage/role/create', 'zmdi zmdi-plus', '1', '33', '33');
    562. 

  562. INSERT INTO `upms_permission` VALUES ('34', '1', '5', '编辑角色', '3', 'upms:role:update', '/manage/role/update', 'zmdi zmdi-edit', '1', '34', '34');
    563. 

  563. INSERT INTO `upms_permission` VALUES ('35', '1', '5', '删除角色', '3', 'upms:role:delete', '/manage/role/delete', 'zmdi zmdi-close', '1', '35', '35');
    564. 

  564. INSERT INTO `upms_permission` VALUES ('36', '1', '39', '新增权限', '3', 'upms:permission:create', '/manage/permission/create', 'zmdi zmdi-plus', '1', '36', '36');
    565. 

  565. INSERT INTO `upms_permission` VALUES ('37', '1', '39', '编辑权限', '3', 'upms:permission:update', '/manage/permission/update', 'zmdi zmdi-edit', '1', '37', '37');
    566. 

  566. INSERT INTO `upms_permission` VALUES ('38', '1', '39', '删除权限', '3', 'upms:permission:delete', '/manage/permission/delete', 'zmdi zmdi-close', '1', '38', '38');
    567. 

  567. INSERT INTO `upms_permission` VALUES ('39', '1', '7', '权限管理', '2', 'upms:permission:read', '/manage/permission/index', null, '1', '39', '39');
    568. 

  568. INSERT INTO `upms_permission` VALUES ('46', '1', '5', '角色权限', '3', 'upms:role:permission', '/manage/role/permission', 'zmdi zmdi-key', '1', '1488091928257', '1488091928257');
    569. 

  569. INSERT INTO `upms_permission` VALUES ('48', '1', '6', '用户组织', '3', 'upms:user:organization', '/manage/user/organization', 'zmdi zmdi-accounts-list', '1', '1488120011165', '1488120011165');
    570. 

  570. INSERT INTO `upms_permission` VALUES ('50', '1', '6', '用户角色', '3', 'upms:user:role', '/manage/user/role', 'zmdi zmdi-accounts', '1', '1488120554175', '1488120554175');
    571. 

  571. INSERT INTO `upms_permission` VALUES ('51', '1', '6', '用户权限', '3', 'upms:user:permission', '/manage/user/permission', 'zmdi zmdi-key', '1', '1488092013302', '1488092013302');
    572. 

  572. INSERT INTO `upms_permission` VALUES ('53', '1', '14', '强制退出', '3', 'upms:session:forceout', '/manage/session/forceout', 'zmdi zmdi-run', '1', '1488379514715', '1488379514715');
    573. 

  573. INSERT INTO `upms_permission` VALUES ('54', '2', '18', '新增标签', '3', 'cms:tag:create', '/manage/tag/create', 'zmdi zmdi-plus', '1', '1489417315159', '1489417315159');
    574. 

  574. INSERT INTO `upms_permission` VALUES ('55', '2', '18', '编辑标签', '3', 'cms:tag:update', 'zmdi zmdi-edit', 'zmdi zmdi-widgets', '1', '1489417344931', '1489417344931');
    575. 

  575. INSERT INTO `upms_permission` VALUES ('56', '2', '18', '删除标签', '3', 'cms:tag:delete', '/manage/tag/delete', 'zmdi zmdi-close', '1', '1489417372114', '1489417372114');
    576. 

  576. INSERT INTO `upms_permission` VALUES ('57', '1', '15', '删除权限', '3', 'upms:log:delete', '/manage/log/delete', 'zmdi zmdi-close', '1', '1489503867909', '1489503867909');
    577. 

  577. INSERT INTO `upms_permission` VALUES ('58', '2', '19', '编辑类目', '3', 'cms:category:update', '/manage/category/update', 'zmdi zmdi-edit', '1', '1489586600462', '1489586600462');
    578. 

  578. INSERT INTO `upms_permission` VALUES ('59', '2', '19', '删除类目', '3', 'cms:category:delete', '/manage/category/delete', 'zmdi zmdi-close', '1', '1489586633059', '1489586633059');
    579. 

  579. INSERT INTO `upms_permission` VALUES ('60', '2', '19', '新增类目', '3', 'cms:category:create', '/manage/category/create', 'zmdi zmdi-plus', '1', '1489590342089', '1489590342089');
    580. 

  580. INSERT INTO `upms_permission` VALUES ('61', '2', '0', '其他数据管理', '1', '', '', 'zmdi zmdi-more', '1', '1489835455359', '1489835455359');
    581. 

  581. INSERT INTO `upms_permission` VALUES ('62', '2', '20', '评论管理', '2', 'cms:comment:read', '/manage/comment/index', '', '1', '1489591408224', '1489591408224');
    582. 

  582. INSERT INTO `upms_permission` VALUES ('63', '2', '62', '删除评论', '3', 'cms:comment:delete', '/manage/comment/delete', 'zmdi zmdi-close', '1', '1489591449614', '1489591449614');
    583. 

  583. INSERT INTO `upms_permission` VALUES ('64', '2', '79', '单页管理', '2', 'cms:page:read', '/manage/page/index', '', '1', '1489591332779', '1489591332779');
    584. 

  584. INSERT INTO `upms_permission` VALUES ('65', '2', '64', '新增单页', '3', 'cms:page:create', '/manage/page/create', 'zmdi zmdi-plus', '1', '1489591614473', '1489591614473');
    585. 

  585. INSERT INTO `upms_permission` VALUES ('66', '2', '64', '编辑单页', '3', 'cms:page:update', '/manage/page/update', 'zmdi zmdi-edit', '1', '1489591653000', '1489591653000');
    586. 

  586. INSERT INTO `upms_permission` VALUES ('67', '2', '64', '删除单页', '3', 'cms:page:delete', '/manage/page/delete', 'zmdi zmdi-close', '1', '1489591683552', '1489591683552');
    587. 

  587. INSERT INTO `upms_permission` VALUES ('68', '2', '61', '菜单管理', '2', 'cms:menu:read', '/manage/menu/index', 'zmdi zmdi-widgets', '1', '1489591746846', '1489591746846');
    588. 

  588. INSERT INTO `upms_permission` VALUES ('69', '2', '68', '新增菜单', '3', 'cms:menu:create', '/manage/menu/create', 'zmdi zmdi-plus', '1', '1489591791747', '1489591791747');
    589. 

  589. INSERT INTO `upms_permission` VALUES ('70', '2', '68', '编辑菜单', '3', 'cms:menu:update', '/manage/menu/update', 'zmdi zmdi-edit', '1', '1489591831878', '1489591831878');
    590. 

  590. INSERT INTO `upms_permission` VALUES ('71', '2', '68', '删除菜单', '3', 'cms:menu:delete', '/manage/menu/delete', 'zmdi zmdi-close', '1', '1489591865454', '1489591865454');
    591. 

  591. INSERT INTO `upms_permission` VALUES ('72', '2', '61', '系统设置', '2', 'cms:setting:read', '/manage/setting/index', 'zmdi zmdi-widgets', '1', '1489591981165', '1489591981165');
    592. 

  592. INSERT INTO `upms_permission` VALUES ('73', '2', '72', '新增设置', '3', 'cms:setting:create', '/manage/setting/create', 'zmdi zmdi-plus', '1', '1489592024762', '1489592024762');
    593. 

  593. INSERT INTO `upms_permission` VALUES ('74', '2', '72', '编辑设置', '3', 'cms:setting:update', '/manage/setting/update', 'zmdi zmdi-edit', '1', '1489592052582', '1489592052582');
    594. 

  594. INSERT INTO `upms_permission` VALUES ('75', '2', '72', '删除设置', '3', 'cms:setting:delete', '/manage/setting/delete', 'zmdi zmdi-close', '1', '1489592081426', '1489592081426');
    595. 

  595. INSERT INTO `upms_permission` VALUES ('76', '2', '21', '新增文章', '3', 'cms:article:create', '/manage/article/create', 'zmdi zmdi-plus', '1', '1489820150404', '1489820150404');
    596. 

  596. INSERT INTO `upms_permission` VALUES ('77', '2', '21', '编辑文章', '3', 'cms:article:update', '/manage/article/update', 'zmdi zmdi-edit', '1', '1489820178269', '1489820178269');
    597. 

  597. INSERT INTO `upms_permission` VALUES ('78', '2', '21', '删除文章', '3', 'cms:article:delete', '/manage/article/delete', 'zmdi zmdi-close', '1', '1489820207607', '1489820207607');
    598. 

  598. INSERT INTO `upms_permission` VALUES ('79', '2', '0', '单页专题管理', '1', '', '', 'zmdi zmdi-view-web', '1', '1489835320327', '1489835320327');
    599. 

  599. INSERT INTO `upms_permission` VALUES ('80', '2', '79', '专题管理', '2', 'cms:topic:read', '/manage/topic/index', 'zmdi zmdi-widgets', '1', '1489591507566', '1489591507566');
    600. 

  600. INSERT INTO `upms_permission` VALUES ('81', '2', '80', '新增专题', '3', 'cms:topic:create', '/manage/topic/create', 'zmdi zmdi-plus', '1', '1489843327028', '1489843327028');
    601. 

  601. INSERT INTO `upms_permission` VALUES ('82', '2', '80', '编辑专题', '3', 'cms:topic:update', '/manage/topic/update', 'zmdi zmdi-edit', '1', '1489843351513', '1489843351513');
    602. 

  602. INSERT INTO `upms_permission` VALUES ('83', '2', '80', '删除专题', '3', 'cms:topic:delete', '/manage/topic/delete', 'zmdi zmdi-close', '1', '1489843379953', '1489843379953');
    603. 

  603. INSERT INTO `upms_permission` VALUES ('84', '2', '68', '上移菜单', '3', 'cms:menu:up', '/manage/menu/up', 'zmdi zmdi-long-arrow-up', '1', '1489846486548', '1489846486548');
    604. 

  604. INSERT INTO `upms_permission` VALUES ('85', '2', '68', '下移菜单', '3', 'cms:menu:down', '/manage/menu/down', 'zmdi zmdi-long-arrow-down', '1', '1489846578051', '1489846578051');
    605. 

  605. 

  606. -- ----------------------------
    607. 

  607. -- Table structure for upms_role
    608. 

  608. -- ----------------------------
    609. 

  609. DROP TABLE IF EXISTS `upms_role`;
    610. 

  610. CREATE TABLE `upms_role` (
    611. 

  611.   `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    612. 

  612.   `name` varchar(20) DEFAULT NULL COMMENT '角色名称',
    613. 

  613.   `title` varchar(20) DEFAULT NULL COMMENT '角色标题',
    614. 

  614.   `description` varchar(1000) DEFAULT NULL COMMENT '角色描述',
    615. 

  615.   `ctime` bigint(20) NOT NULL COMMENT '创建时间',
    616. 

  616.   `orders` bigint(20) NOT NULL COMMENT '排序',
    617. 

  617.   PRIMARY KEY (`role_id`)
    618. 

  618. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色';
    619. 

  619. 

  620. -- ----------------------------
    621. 

  621. -- Records of upms_role
    622. 

  622. -- ----------------------------
    623. 

  623. INSERT INTO `upms_role` VALUES ('1', 'super', '超级管理员', '拥有所有权限', '1', '1');
    624. 

  624. INSERT INTO `upms_role` VALUES ('2', 'admin', '管理员', '拥有除权限管理系统外的所有权限', '1487471013117', '1487471013117');
    625. 

  625. 

  626. -- ----------------------------
    627. 

  627. -- Table structure for upms_role_permission
    628. 

  628. -- ----------------------------
    629. 

  629. DROP TABLE IF EXISTS `upms_role_permission`;
    630. 

  630. CREATE TABLE `upms_role_permission` (
    631. 

  631.   `role_permission_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    632. 

  632.   `role_id` int(10) unsigned NOT NULL COMMENT '角色编号',
    633. 

  633.   `permission_id` int(10) unsigned NOT NULL COMMENT '权限编号',
    634. 

  634.   PRIMARY KEY (`role_permission_id`),
    635. 

  635.   KEY `FK_Reference_23` (`role_id`),
    636. 

  636.   CONSTRAINT `FK_Reference_23` FOREIGN KEY (`role_id`) REFERENCES `upms_role` (`role_id`)
    637. 

  637. ) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COMMENT='角色权限关联表';
    638. 

  638. 

  639. -- ----------------------------
    640. 

  640. -- Records of upms_role_permission
    641. 

  641. -- ----------------------------
    642. 

  642. INSERT INTO `upms_role_permission` VALUES ('1', '1', '1');
    643. 

  643. INSERT INTO `upms_role_permission` VALUES ('2', '1', '2');
    644. 

  644. INSERT INTO `upms_role_permission` VALUES ('3', '1', '3');
    645. 

  645. INSERT INTO `upms_role_permission` VALUES ('4', '1', '4');
    646. 

  646. INSERT INTO `upms_role_permission` VALUES ('5', '1', '5');
    647. 

  647. INSERT INTO `upms_role_permission` VALUES ('6', '1', '6');
    648. 

  648. INSERT INTO `upms_role_permission` VALUES ('7', '1', '7');
    649. 

  649. INSERT INTO `upms_role_permission` VALUES ('8', '1', '39');
    650. 

  650. INSERT INTO `upms_role_permission` VALUES ('12', '1', '12');
    651. 

  651. INSERT INTO `upms_role_permission` VALUES ('14', '1', '14');
    652. 

  652. INSERT INTO `upms_role_permission` VALUES ('15', '1', '15');
    653. 

  653. INSERT INTO `upms_role_permission` VALUES ('17', '1', '17');
    654. 

  654. INSERT INTO `upms_role_permission` VALUES ('19', '1', '19');
    655. 

  655. INSERT INTO `upms_role_permission` VALUES ('20', '1', '20');
    656. 

  656. INSERT INTO `upms_role_permission` VALUES ('21', '1', '21');
    657. 

  657. INSERT INTO `upms_role_permission` VALUES ('24', '1', '24');
    658. 

  658. INSERT INTO `upms_role_permission` VALUES ('27', '1', '27');
    659. 

  659. INSERT INTO `upms_role_permission` VALUES ('28', '1', '28');
    660. 

  660. INSERT INTO `upms_role_permission` VALUES ('29', '1', '29');
    661. 

  661. INSERT INTO `upms_role_permission` VALUES ('30', '1', '30');
    662. 

  662. INSERT INTO `upms_role_permission` VALUES ('31', '1', '31');
    663. 

  663. INSERT INTO `upms_role_permission` VALUES ('32', '1', '32');
    664. 

  664. INSERT INTO `upms_role_permission` VALUES ('33', '1', '33');
    665. 

  665. INSERT INTO `upms_role_permission` VALUES ('34', '1', '34');
    666. 

  666. INSERT INTO `upms_role_permission` VALUES ('35', '1', '35');
    667. 

  667. INSERT INTO `upms_role_permission` VALUES ('36', '1', '36');
    668. 

  668. INSERT INTO `upms_role_permission` VALUES ('37', '1', '37');
    669. 

  669. INSERT INTO `upms_role_permission` VALUES ('38', '1', '38');
    670. 

  670. INSERT INTO `upms_role_permission` VALUES ('39', '1', '46');
    671. 

  671. INSERT INTO `upms_role_permission` VALUES ('40', '1', '51');
    672. 

  672. INSERT INTO `upms_role_permission` VALUES ('41', '1', '26');
    673. 

  673. INSERT INTO `upms_role_permission` VALUES ('42', '1', '26');
    674. 

  674. INSERT INTO `upms_role_permission` VALUES ('43', '1', '25');
    675. 

  675. INSERT INTO `upms_role_permission` VALUES ('44', '1', '48');
    676. 

  676. INSERT INTO `upms_role_permission` VALUES ('45', '1', '50');
    677. 

  677. INSERT INTO `upms_role_permission` VALUES ('47', '1', '53');
    678. 

  678. INSERT INTO `upms_role_permission` VALUES ('48', '1', '18');
    679. 

  679. INSERT INTO `upms_role_permission` VALUES ('49', '1', '54');
    680. 

  680. INSERT INTO `upms_role_permission` VALUES ('50', '1', '54');
    681. 

  681. INSERT INTO `upms_role_permission` VALUES ('51', '1', '55');
    682. 

  682. INSERT INTO `upms_role_permission` VALUES ('52', '1', '54');
    683. 

  683. INSERT INTO `upms_role_permission` VALUES ('53', '1', '55');
    684. 

  684. INSERT INTO `upms_role_permission` VALUES ('54', '1', '56');
    685. 

  685. INSERT INTO `upms_role_permission` VALUES ('55', '1', '57');
    686. 

  686. INSERT INTO `upms_role_permission` VALUES ('56', '1', '58');
    687. 

  687. INSERT INTO `upms_role_permission` VALUES ('57', '1', '58');
    688. 

  688. INSERT INTO `upms_role_permission` VALUES ('58', '1', '59');
    689. 

  689. INSERT INTO `upms_role_permission` VALUES ('59', '1', '60');
    690. 

  690. INSERT INTO `upms_role_permission` VALUES ('60', '1', '61');
    691. 

  691. INSERT INTO `upms_role_permission` VALUES ('61', '1', '62');
    692. 

  692. INSERT INTO `upms_role_permission` VALUES ('62', '1', '62');
    693. 

  693. INSERT INTO `upms_role_permission` VALUES ('63', '1', '63');
    694. 

  694. INSERT INTO `upms_role_permission` VALUES ('64', '1', '62');
    695. 

  695. INSERT INTO `upms_role_permission` VALUES ('65', '1', '63');
    696. 

  696. INSERT INTO `upms_role_permission` VALUES ('66', '1', '64');
    697. 

  697. INSERT INTO `upms_role_permission` VALUES ('67', '1', '62');
    698. 

  698. INSERT INTO `upms_role_permission` VALUES ('68', '1', '63');
    699. 

  699. INSERT INTO `upms_role_permission` VALUES ('69', '1', '64');
    700. 

  700. INSERT INTO `upms_role_permission` VALUES ('70', '1', '65');
    701. 

  701. INSERT INTO `upms_role_permission` VALUES ('71', '1', '62');
    702. 

  702. INSERT INTO `upms_role_permission` VALUES ('72', '1', '63');
    703. 

  703. INSERT INTO `upms_role_permission` VALUES ('73', '1', '64');
    704. 

  704. INSERT INTO `upms_role_permission` VALUES ('74', '1', '65');
    705. 

  705. INSERT INTO `upms_role_permission` VALUES ('75', '1', '66');
    706. 

  706. INSERT INTO `upms_role_permission` VALUES ('76', '1', '62');
    707. 

  707. INSERT INTO `upms_role_permission` VALUES ('77', '1', '63');
    708. 

  708. INSERT INTO `upms_role_permission` VALUES ('78', '1', '64');
    709. 

  709. INSERT INTO `upms_role_permission` VALUES ('79', '1', '65');
    710. 

  710. INSERT INTO `upms_role_permission` VALUES ('80', '1', '66');
    711. 

  711. INSERT INTO `upms_role_permission` VALUES ('81', '1', '67');
    712. 

  712. INSERT INTO `upms_role_permission` VALUES ('82', '1', '68');
    713. 

  713. INSERT INTO `upms_role_permission` VALUES ('83', '1', '69');
    714. 

  714. INSERT INTO `upms_role_permission` VALUES ('84', '1', '69');
    715. 

  715. INSERT INTO `upms_role_permission` VALUES ('85', '1', '70');
    716. 

  716. INSERT INTO `upms_role_permission` VALUES ('86', '1', '69');
    717. 

  717. INSERT INTO `upms_role_permission` VALUES ('87', '1', '70');
    718. 

  718. INSERT INTO `upms_role_permission` VALUES ('88', '1', '71');
    719. 

  719. INSERT INTO `upms_role_permission` VALUES ('89', '1', '72');
    720. 

  720. INSERT INTO `upms_role_permission` VALUES ('90', '1', '72');
    721. 

  721. INSERT INTO `upms_role_permission` VALUES ('91', '1', '73');
    722. 

  722. INSERT INTO `upms_role_permission` VALUES ('92', '1', '72');
    723. 

  723. INSERT INTO `upms_role_permission` VALUES ('93', '1', '73');
    724. 

  724. INSERT INTO `upms_role_permission` VALUES ('94', '1', '74');
    725. 

  725. INSERT INTO `upms_role_permission` VALUES ('95', '1', '72');
    726. 

  726. INSERT INTO `upms_role_permission` VALUES ('96', '1', '73');
    727. 

  727. INSERT INTO `upms_role_permission` VALUES ('97', '1', '74');
    728. 

  728. INSERT INTO `upms_role_permission` VALUES ('98', '1', '75');
    729. 

  729. INSERT INTO `upms_role_permission` VALUES ('99', '1', '76');
    730. 

  730. INSERT INTO `upms_role_permission` VALUES ('100', '1', '76');
    731. 

  731. INSERT INTO `upms_role_permission` VALUES ('101', '1', '77');
    732. 

  732. INSERT INTO `upms_role_permission` VALUES ('102', '1', '76');
    733. 

  733. INSERT INTO `upms_role_permission` VALUES ('103', '1', '77');
    734. 

  734. INSERT INTO `upms_role_permission` VALUES ('104', '1', '78');
    735. 

  735. INSERT INTO `upms_role_permission` VALUES ('105', '1', '79');
    736. 

  736. INSERT INTO `upms_role_permission` VALUES ('106', '1', '80');
    737. 

  737. INSERT INTO `upms_role_permission` VALUES ('107', '1', '81');
    738. 

  738. INSERT INTO `upms_role_permission` VALUES ('108', '1', '81');
    739. 

  739. INSERT INTO `upms_role_permission` VALUES ('109', '1', '82');
    740. 

  740. INSERT INTO `upms_role_permission` VALUES ('110', '1', '81');
    741. 

  741. INSERT INTO `upms_role_permission` VALUES ('111', '1', '82');
    742. 

  742. INSERT INTO `upms_role_permission` VALUES ('112', '1', '83');
    743. 

  743. INSERT INTO `upms_role_permission` VALUES ('113', '1', '84');
    744. 

  744. INSERT INTO `upms_role_permission` VALUES ('114', '1', '84');
    745. 

  745. INSERT INTO `upms_role_permission` VALUES ('115', '1', '85');
    746. 

  746. 

  747. -- ----------------------------
    748. 

  748. -- Table structure for upms_system
    749. 

  749. -- ----------------------------
    750. 

  750. DROP TABLE IF EXISTS `upms_system`;
    751. 

  751. CREATE TABLE `upms_system` (
    752. 

  752.   `system_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    753. 

  753.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    754. 

  754.   `banner` varchar(50) DEFAULT NULL COMMENT '背景',
    755. 

  755.   `theme` varchar(50) DEFAULT NULL COMMENT '主题',
    756. 

  756.   `basepath` varchar(100) DEFAULT NULL COMMENT '根目录',
    757. 

  757.   `status` tinyint(4) DEFAULT NULL COMMENT '状态(-1:黑名单,1:正常)',
    758. 

  758.   `name` varchar(20) DEFAULT NULL COMMENT '系统名称',
    759. 

  759.   `title` varchar(20) DEFAULT NULL COMMENT '系统标题',
    760. 

  760.   `description` varchar(300) DEFAULT NULL COMMENT '系统描述',
    761. 

  761.   `ctime` bigint(20) DEFAULT NULL COMMENT '创建时间',
    762. 

  762.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    763. 

  763.   PRIMARY KEY (`system_id`)
    764. 

  764. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='系统';
    765. 

  765. 

  766. -- ----------------------------
    767. 

  767. -- Records of upms_system
    768. 

  768. -- ----------------------------
    769. 

  769. INSERT INTO `upms_system` VALUES ('1', 'zmdi zmdi-shield-security', '/resources/zheng-ui/images/zheng-upms.png', '#29A176', 'http://upms.zhangshuzheng.cn:1111', '1', 'zheng-upms-server', '权限管理系统', '用户权限管理系统（RBAC细粒度用户权限、统一后台、单点登录、会话管理）', '1', '1');
    770. 

  770. INSERT INTO `upms_system` VALUES ('2', 'zmdi zmdi-wikipedia', '/resources/zheng-ui/images/zheng-cms.png', '#455EC5', 'http://cms.zhangshuzheng.cn:2222', '1', 'zheng-cms-admin', '内容管理系统', '内容管理系统（门户、博客、论坛、问答等）', '2', '2');
    771. 

  771. INSERT INTO `upms_system` VALUES ('3', 'zmdi zmdi-paypal-alt', '/resources/zheng-ui/images/zheng-pay.png', '#F06292', 'http://pay.zhangshuzheng.cn:3331', '1', 'zheng-pay-admin', '支付管理系统', '支付管理系统', '3', '3');
    772. 

  772. INSERT INTO `upms_system` VALUES ('4', 'zmdi zmdi-account', '/resources/zheng-ui/images/zheng-ucenter.png', '#6539B4', 'http://ucenter.zhangshuzheng.cn:4441', '1', 'zheng-ucenter-home', '用户管理系统', '用户管理系统', '4', '4');
    773. 

  773. INSERT INTO `upms_system` VALUES ('5', 'zmdi zmdi-cloud', '/resources/zheng-ui/images/zheng-oss.png', '#0B8DE5', 'http://oss.zhangshuzheng.cn:7771', '1', 'zheng-oss-web', '存储管理系统', '存储管理系统', '5', '5');
    774. 

  774. 

  775. -- ----------------------------
    776. 

  776. -- Table structure for upms_user
    777. 

  777. -- ----------------------------
    778. 

  778. DROP TABLE IF EXISTS `upms_user`;
    779. 

  779. CREATE TABLE `upms_user` (
    780. 

  780.   `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    781. 

  781.   `username` varchar(20) NOT NULL COMMENT '帐号',
    782. 

  782.   `password` varchar(32) NOT NULL COMMENT '密码MD5(密码+盐)',
    783. 

  783.   `salt` varchar(32) DEFAULT NULL COMMENT '盐',
    784. 

  784.   `realname` varchar(20) DEFAULT NULL COMMENT '姓名',
    785. 

  785.   `avatar` varchar(50) DEFAULT NULL COMMENT '头像',
    786. 

  786.   `phone` varchar(20) DEFAULT NULL COMMENT '电话',
    787. 

  787.   `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
    788. 

  788.   `sex` tinyint(4) DEFAULT NULL COMMENT '性别',
    789. 

  789.   `locked` tinyint(4) DEFAULT NULL COMMENT '状态(0:正常,1:锁定)',
    790. 

  790.   `ctime` bigint(20) DEFAULT NULL COMMENT '创建时间',
    791. 

  791.   PRIMARY KEY (`user_id`)
    792. 

  792. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户';
    793. 

  793. 

  794. -- ----------------------------
    795. 

  795. -- Records of upms_user
    796. 

  796. -- ----------------------------
    797. 

  797. INSERT INTO `upms_user` VALUES ('1', 'admin', '3038D9CB63B3152A79B8153FB06C02F7', '66f1b370c660445a8657bf8bf1794486', '张恕征', '/resources/zheng-ui/images/avatar.jpg', '', '469741414@qq.com', '1', '0', '1');
    798. 

  798. 

  799. -- ----------------------------
    800. 

  800. -- Table structure for upms_user_organization
    801. 

  801. -- ----------------------------
    802. 

  802. DROP TABLE IF EXISTS `upms_user_organization`;
    803. 

  803. CREATE TABLE `upms_user_organization` (
    804. 

  804.   `user_organization_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    805. 

  805.   `user_id` int(10) unsigned NOT NULL COMMENT '用户编号',
    806. 

  806.   `organization_id` int(10) unsigned NOT NULL COMMENT '组织编号',
    807. 

  807.   PRIMARY KEY (`user_organization_id`)
    808. 

  808. ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COMMENT='用户组织关联表';
    809. 

  809. 

  810. -- ----------------------------
    811. 

  811. -- Records of upms_user_organization
    812. 

  812. -- ----------------------------
    813. 

  813. INSERT INTO `upms_user_organization` VALUES ('19', '1', '1');
    814. 

  814. INSERT INTO `upms_user_organization` VALUES ('20', '1', '4');
    815. 

  815. INSERT INTO `upms_user_organization` VALUES ('21', '1', '5');
    816. 

  816. INSERT INTO `upms_user_organization` VALUES ('22', '1', '6');
    817. 

  817. INSERT INTO `upms_user_organization` VALUES ('23', '1', '7');
    818. 

  818. 

  819. -- ----------------------------
    820. 

  820. -- Table structure for upms_user_permission
    821. 

  821. -- ----------------------------
    822. 

  822. DROP TABLE IF EXISTS `upms_user_permission`;
    823. 

  823. CREATE TABLE `upms_user_permission` (
    824. 

  824.   `user_permission_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    825. 

  825.   `user_id` int(10) unsigned NOT NULL COMMENT '用户编号',
    826. 

  826.   `permission_id` int(10) unsigned NOT NULL COMMENT '权限编号',
    827. 

  827.   PRIMARY KEY (`user_permission_id`)
    828. 

  828. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户权限关联表';
    829. 

  829. 

  830. -- ----------------------------
    831. 

  831. -- Records of upms_user_permission
    832. 

  832. -- ----------------------------
    833. 

  833. 

  834. -- ----------------------------
    835. 

  835. -- Table structure for upms_user_role
    836. 

  836. -- ----------------------------
    837. 

  837. DROP TABLE IF EXISTS `upms_user_role`;
    838. 

  838. CREATE TABLE `upms_user_role` (
    839. 

  839.   `user_role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    840. 

  840.   `user_id` int(10) unsigned NOT NULL COMMENT '用户编号',
    841. 

  841.   `role_id` int(10) DEFAULT NULL COMMENT '角色编号',
    842. 

  842.   PRIMARY KEY (`user_role_id`)
    843. 

  843. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='用户角色关联表';
    844. 

  844. 

  845. -- ----------------------------
    846. 

  846. -- Records of upms_user_role
    847. 

  847. -- ----------------------------
    848. 

  848. INSERT INTO `upms_user_role` VALUES ('4', '1', '1');
    849. 

  849. INSERT INTO `upms_user_role` VALUES ('5', '1', '2');
    850.