Sākums Izpētīt Palīdzība
Pierakstīties
chendeben
/
zheng
1
0
Atdalīts 0
Faili Problēmas 0 Izmaiņu pieprasījumi 0 Vikivietne
Koks: 9ef1235fce
Atzari Tagi
zheng
/
project-datamodel
/
zheng.sql

zheng.sql 163 KB
Vēsture Neapstrādāts

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850 
  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-04-05 23:12:00
    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.   `top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶等级',
    38. 

  38.   `system_id` int(11) DEFAULT NULL COMMENT '所属系统',
    39. 

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

  40.   `orders` bigint(20) unsigned NOT NULL COMMENT '排序',
    41. 

  41.   PRIMARY KEY (`article_id`),
    42. 

  42.   KEY `cms_article_orders` (`orders`)
    43. 

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

  44. 

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

  46. -- Records of cms_article
    47. 

  47. -- ----------------------------
    48. 

  48. 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', '0', '1', '1489827019528', '1489827019528');
    49. 

  49. 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', '0', '1', '1489827340870', '1489827340870');
    50. 

  50. 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', '0', '1', '1489827581414', '1489827581414');
    51. 

  51. 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', '0', '1', '1489845594355', '1489845594355');
    52. 

  52. 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', '0', '1', '1490460546198', '1490460546198');
    53. 

  53. 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', '0', '1', '1490460567137', '1490460567137');
    54. 

  54. 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', '0', '1', '1490460575304', '1490460575304');
    55. 

  55. 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', '0', '1', '1490460582004', '1490460582004');
    56. 

  56. 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', '0', '1', '1490460588840', '1490460588840');
    57. 

  57. 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', '0', '1', '1490460596394', '1490460596394');
    58. 

  58. 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', '0', '1', '1490460612370', '1490460612370');
    59. 

  59. 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', '0', '1', '1490460782767', '1490460782767');
    60. 

  60. 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', '0', '1', '1490460792501', '1490460792501');
    61. 

  61. 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', '0', '1', '1490460800634', '1490460800634');
    62. 

  62. 

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

  64. -- Table structure for cms_article_category
    65. 

  65. -- ----------------------------
    66. 

  66. DROP TABLE IF EXISTS `cms_article_category`;
    67. 

  67. CREATE TABLE `cms_article_category` (
    68. 

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

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

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

  71.   PRIMARY KEY (`article_category_id`),
    72. 

  72.   KEY `cms_article_category_article_id` (`article_id`),
    73. 

  73.   KEY `cms_article_category_category_id` (`category_id`),
    74. 

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

  75.   CONSTRAINT `FK_Reference_8` FOREIGN KEY (`article_id`) REFERENCES `cms_article` (`article_id`) ON DELETE CASCADE ON UPDATE CASCADE
    76. 

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

  77. 

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

  79. -- Records of cms_article_category
    80. 

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

  81. 

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

  83. -- Table structure for cms_article_tag
    84. 

  84. -- ----------------------------
    85. 

  85. DROP TABLE IF EXISTS `cms_article_tag`;
    86. 

  86. CREATE TABLE `cms_article_tag` (
    87. 

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

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

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

  90.   PRIMARY KEY (`article_tag_id`),
    91. 

  91.   KEY `cms_article_tag_article_id` (`article_id`),
    92. 

  92.   KEY `cms_article_tag_tag_id` (`tag_id`),
    93. 

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

  94.   CONSTRAINT `FK_Reference_4` FOREIGN KEY (`tag_id`) REFERENCES `cms_tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
    95. 

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

  96. 

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

  98. -- Records of cms_article_tag
    99. 

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

  100. 

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

  102. -- Table structure for cms_category
    103. 

  103. -- ----------------------------
    104. 

  104. DROP TABLE IF EXISTS `cms_category`;
    105. 

  105. CREATE TABLE `cms_category` (
    106. 

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

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

  108.   `level` tinyint(4) NOT NULL COMMENT '层级',
    109. 

  109.   `name` varchar(20) NOT NULL COMMENT '名称',
    110. 

  110.   `description` varchar(200) DEFAULT NULL COMMENT '描述',
    111. 

  111.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    112. 

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

  113.   `alias` varchar(20) DEFAULT NULL COMMENT '别名',
    114. 

  114.   `system_id` int(11) DEFAULT NULL COMMENT '所属系统',
    115. 

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

  116.   `orders` bigint(255) unsigned NOT NULL COMMENT '排序',
    117. 

  117.   PRIMARY KEY (`category_id`),
    118. 

  118.   KEY `cms_category_orders` (`orders`),
    119. 

  119.   KEY `cms_category_pid` (`pid`),
    120. 

  120.   KEY `cms_category_alias` (`alias`),
    121. 

  121.   KEY `cms_category_level` (`level`)
    122. 

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

  123. 

  124. -- ----------------------------
    125. 

  125. -- Records of cms_category
    126. 

  126. -- ----------------------------
    127. 

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

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

  129. 

  130. -- ----------------------------
    131. 

  131. -- Table structure for cms_category_tag
    132. 

  132. -- ----------------------------
    133. 

  133. DROP TABLE IF EXISTS `cms_category_tag`;
    134. 

  134. CREATE TABLE `cms_category_tag` (
    135. 

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

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

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

  138.   PRIMARY KEY (`category_tag_id`),
    139. 

  139.   KEY `cms_category_tag_tag_id` (`tag_id`),
    140. 

  140.   KEY `cms_category_tag_category_id` (`category_id`),
    141. 

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

  142.   CONSTRAINT `FK_Reference_6` FOREIGN KEY (`tag_id`) REFERENCES `cms_tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
    143. 

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

  144. 

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

  146. -- Records of cms_category_tag
    147. 

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

  148. 

  149. -- ----------------------------
    150. 

  150. -- Table structure for cms_comment
    151. 

  151. -- ----------------------------
    152. 

  152. DROP TABLE IF EXISTS `cms_comment`;
    153. 

  153. CREATE TABLE `cms_comment` (
    154. 

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

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

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

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

  158.   `content` text NOT NULL COMMENT '评论内容',
    159. 

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

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

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

  162.   `system_id` int(11) DEFAULT NULL COMMENT '所属系统',
    163. 

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

  164.   PRIMARY KEY (`comment_id`),
    165. 

  165.   KEY `cms_comment_article_id` (`article_id`)
    166. 

  166. ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='评论表';
    167. 

  167. 

  168. -- ----------------------------
    169. 

  169. -- Records of cms_comment
    170. 

  170. -- ----------------------------
    171. 

  171. INSERT INTO `cms_comment` VALUES ('1', null, '8', '1', '1', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490535749413');
    172. 

  172. INSERT INTO `cms_comment` VALUES ('2', null, '8', '1', '2', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536186447');
    173. 

  173. INSERT INTO `cms_comment` VALUES ('3', null, '8', '1', '3', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536192205');
    174. 

  174. INSERT INTO `cms_comment` VALUES ('4', null, '8', '1', '4', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536460544');
    175. 

  175. INSERT INTO `cms_comment` VALUES ('5', null, '8', '1', '5', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536462182');
    176. 

  176. INSERT INTO `cms_comment` VALUES ('6', null, '8', '1', '6', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536463614');
    177. 

  177. INSERT INTO `cms_comment` VALUES ('7', null, '8', '1', '7', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536464870');
    178. 

  178. INSERT INTO `cms_comment` VALUES ('8', null, '8', '1', '8', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536465926');
    179. 

  179. INSERT INTO `cms_comment` VALUES ('9', null, '8', '1', '9', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536466853');
    180. 

  180. INSERT INTO `cms_comment` VALUES ('10', null, '8', '1', '10', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36', '1', '1490536467821');
    181. 

  181. 

  182. -- ----------------------------
    183. 

  183. -- Table structure for cms_menu
    184. 

  184. -- ----------------------------
    185. 

  185. DROP TABLE IF EXISTS `cms_menu`;
    186. 

  186. CREATE TABLE `cms_menu` (
    187. 

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

  188.   `pid` int(11) DEFAULT NULL COMMENT '父菜单',
    189. 

  189.   `name` varchar(20) DEFAULT NULL COMMENT '名称',
    190. 

  190.   `url` varchar(100) DEFAULT NULL COMMENT '链接',
    191. 

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

  192.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    193. 

  193.   PRIMARY KEY (`menu_id`)
    194. 

  194. ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='菜单';
    195. 

  195. 

  196. -- ----------------------------
    197. 

  197. -- Records of cms_menu
    198. 

  198. -- ----------------------------
    199. 

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

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

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

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

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

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

  205. 

  206. -- ----------------------------
    207. 

  207. -- Table structure for cms_page
    208. 

  208. -- ----------------------------
    209. 

  209. DROP TABLE IF EXISTS `cms_page`;
    210. 

  210. CREATE TABLE `cms_page` (
    211. 

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

  212.   `pid` int(10) DEFAULT NULL COMMENT '父页面',
    213. 

  213.   `title` varchar(20) DEFAULT NULL COMMENT '标题',
    214. 

  214.   `alias` varchar(20) DEFAULT NULL COMMENT '别名',
    215. 

  215.   `content` mediumtext COMMENT '页面内容',
    216. 

  216.   `keywords` varchar(100) DEFAULT NULL COMMENT '关键字',
    217. 

  217.   `description` varchar(300) DEFAULT NULL COMMENT '描述',
    218. 

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

  219.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    220. 

  220.   PRIMARY KEY (`page_id`)
    221. 

  221. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='页面';
    222. 

  222. 

  223. -- ----------------------------
    224. 

  224. -- Records of cms_page
    225. 

  225. -- ----------------------------
    226. 

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

  227. 

  228. -- ----------------------------
    229. 

  229. -- Table structure for cms_setting
    230. 

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

  231. DROP TABLE IF EXISTS `cms_setting`;
    232. 

  232. CREATE TABLE `cms_setting` (
    233. 

  233.   `setting_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    234. 

  234.   `setting_key` varchar(10) DEFAULT NULL,
    235. 

  235.   `setting_value` varchar(500) DEFAULT NULL,
    236. 

  236.   PRIMARY KEY (`setting_id`)
    237. 

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

  238. 

  239. -- ----------------------------
    240. 

  240. -- Records of cms_setting
    241. 

  241. -- ----------------------------
    242. 

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

  243. 

  244. -- ----------------------------
    245. 

  245. -- Table structure for cms_system
    246. 

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

  247. DROP TABLE IF EXISTS `cms_system`;
    248. 

  248. CREATE TABLE `cms_system` (
    249. 

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

  250.   `name` varchar(20) NOT NULL COMMENT '系统名称',
    251. 

  251.   `code` varchar(20) DEFAULT NULL COMMENT '别名',
    252. 

  252.   `description` varchar(300) DEFAULT NULL COMMENT '描述',
    253. 

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

  254.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    255. 

  255.   PRIMARY KEY (`system_id`)
    256. 

  256. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='系统管理';
    257. 

  257. 

  258. -- ----------------------------
    259. 

  259. -- Records of cms_system
    260. 

  260. -- ----------------------------
    261. 

  261. INSERT INTO `cms_system` VALUES ('1', '门户', 'news', '门户', '1', '1');
    262. 

  262. INSERT INTO `cms_system` VALUES ('2', '博客', 'blog', '博客', '2', '2');
    263. 

  263. INSERT INTO `cms_system` VALUES ('3', '问答', 'qa', '问答', '3', '3');
    264. 

  264. 

  265. -- ----------------------------
    266. 

  266. -- Table structure for cms_tag
    267. 

  267. -- ----------------------------
    268. 

  268. DROP TABLE IF EXISTS `cms_tag`;
    269. 

  269. CREATE TABLE `cms_tag` (
    270. 

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

  271.   `name` varchar(20) NOT NULL COMMENT '名称',
    272. 

  272.   `description` varchar(200) DEFAULT NULL COMMENT '描述',
    273. 

  273.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    274. 

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

  275.   `alias` varchar(20) DEFAULT NULL COMMENT '别名',
    276. 

  276.   `system_id` int(11) DEFAULT NULL COMMENT '所属系统',
    277. 

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

  278.   `orders` bigint(20) unsigned NOT NULL COMMENT '排序',
    279. 

  279.   PRIMARY KEY (`tag_id`),
    280. 

  280.   KEY `cms_tag_orders` (`orders`),
    281. 

  281.   KEY `cms_tag_alias` (`alias`)
    282. 

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

  283. 

  284. -- ----------------------------
    285. 

  285. -- Records of cms_tag
    286. 

  286. -- ----------------------------
    287. 

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

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

  289. INSERT INTO `cms_tag` VALUES ('3', 'zheng', 'zheng标签', '', '2', 'zheng', '1', '1489585815042', '1489585815042');
    290. 

  290. 

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

  292. -- Table structure for cms_topic
    293. 

  293. -- ----------------------------
    294. 

  294. DROP TABLE IF EXISTS `cms_topic`;
    295. 

  295. CREATE TABLE `cms_topic` (
    296. 

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

  297.   `title` varchar(100) DEFAULT NULL COMMENT '标题',
    298. 

  298.   `description` varchar(300) DEFAULT NULL COMMENT '描述',
    299. 

  299.   `url` varchar(100) DEFAULT NULL COMMENT '链接',
    300. 

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

  301.   PRIMARY KEY (`topic_id`)
    302. 

  302. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='专题';
    303. 

  303. 

  304. -- ----------------------------
    305. 

  305. -- Records of cms_topic
    306. 

  306. -- ----------------------------
    307. 

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

  308. 

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

  310. -- Table structure for pay_in_order
    311. 

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

  312. DROP TABLE IF EXISTS `pay_in_order`;
    313. 

  313. CREATE TABLE `pay_in_order` (
    314. 

  314.   `pay_in_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    315. 

  315.   `pay_vendor_id` int(10) DEFAULT NULL,
    316. 

  316.   `pay_mch_id` int(10) DEFAULT NULL,
    317. 

  317.   `amount` decimal(10,0) NOT NULL,
    318. 

  318.   `status` tinyint(4) NOT NULL,
    319. 

  319.   `ctime` bigint(20) unsigned NOT NULL,
    320. 

  320.   PRIMARY KEY (`pay_in_order_id`),
    321. 

  321.   KEY `FK_Reference_32` (`pay_vendor_id`),
    322. 

  322.   KEY `FK_Reference_38` (`pay_mch_id`),
    323. 

  323.   CONSTRAINT `FK_Reference_32` FOREIGN KEY (`pay_vendor_id`) REFERENCES `pay_vendor` (`pay_vendor_id`),
    324. 

  324.   CONSTRAINT `FK_Reference_38` FOREIGN KEY (`pay_mch_id`) REFERENCES `pay_mch` (`pay_mch_id`)
    325. 

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

  326. 

  327. -- ----------------------------
    328. 

  328. -- Records of pay_in_order
    329. 

  329. -- ----------------------------
    330. 

  330. 

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

  332. -- Table structure for pay_in_order_detail
    333. 

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

  334. DROP TABLE IF EXISTS `pay_in_order_detail`;
    335. 

  335. CREATE TABLE `pay_in_order_detail` (
    336. 

  336.   `pay_in_order_detail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    337. 

  337.   `pay_in_order_id` int(10) DEFAULT NULL,
    338. 

  338.   `product_id` varchar(50) DEFAULT NULL,
    339. 

  339.   `product_name` varchar(100) DEFAULT NULL,
    340. 

  340.   `product_price` decimal(10,0) DEFAULT NULL,
    341. 

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

  342.   `remark` varchar(500) DEFAULT NULL,
    343. 

  343.   PRIMARY KEY (`pay_in_order_detail_id`)
    344. 

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

  345. 

  346. -- ----------------------------
    347. 

  347. -- Records of pay_in_order_detail
    348. 

  348. -- ----------------------------
    349. 

  349. 

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

  351. -- Table structure for pay_mch
    352. 

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

  353. DROP TABLE IF EXISTS `pay_mch`;
    354. 

  354. CREATE TABLE `pay_mch` (
    355. 

  355.   `pay_mch_id` int(10) NOT NULL AUTO_INCREMENT,
    356. 

  356.   `mch_id` varchar(20) DEFAULT NULL,
    357. 

  357.   `name` varchar(20) DEFAULT NULL,
    358. 

  358.   `reqKey` varchar(50) DEFAULT NULL,
    359. 

  359.   `resKey` varchar(50) DEFAULT NULL,
    360. 

  360.   PRIMARY KEY (`pay_mch_id`)
    361. 

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

  362. 

  363. -- ----------------------------
    364. 

  364. -- Records of pay_mch
    365. 

  365. -- ----------------------------
    366. 

  366. 

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

  368. -- Table structure for pay_out_order
    369. 

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

  370. DROP TABLE IF EXISTS `pay_out_order`;
    371. 

  371. CREATE TABLE `pay_out_order` (
    372. 

  372.   `pay_out_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    373. 

  373.   `pay_mch_id` int(10) DEFAULT NULL,
    374. 

  374.   `pay_vendor_id` int(10) DEFAULT NULL,
    375. 

  375.   `amount` decimal(10,0) NOT NULL,
    376. 

  376.   `status` tinyint(4) NOT NULL,
    377. 

  377.   `ctime` bigint(20) unsigned NOT NULL,
    378. 

  378.   PRIMARY KEY (`pay_out_order_id`)
    379. 

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

  380. 

  381. -- ----------------------------
    382. 

  382. -- Records of pay_out_order
    383. 

  383. -- ----------------------------
    384. 

  384. 

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

  386. -- Table structure for pay_out_order_detail
    387. 

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

  388. DROP TABLE IF EXISTS `pay_out_order_detail`;
    389. 

  389. CREATE TABLE `pay_out_order_detail` (
    390. 

  390.   `pay_out_order_detail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    391. 

  391.   `pay_out_order_id` int(10) DEFAULT NULL,
    392. 

  392.   `remark` varchar(500) DEFAULT NULL,
    393. 

  393.   PRIMARY KEY (`pay_out_order_detail_id`)
    394. 

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

  395. 

  396. -- ----------------------------
    397. 

  397. -- Records of pay_out_order_detail
    398. 

  398. -- ----------------------------
    399. 

  399. 

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

  401. -- Table structure for pay_pay
    402. 

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

  403. DROP TABLE IF EXISTS `pay_pay`;
    404. 

  404. CREATE TABLE `pay_pay` (
    405. 

  405.   `pay_pay_id` int(10) NOT NULL AUTO_INCREMENT,
    406. 

  406.   `pay_type_id` int(10) DEFAULT NULL,
    407. 

  407.   `param` varchar(1000) DEFAULT NULL,
    408. 

  408.   PRIMARY KEY (`pay_pay_id`)
    409. 

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

  410. 

  411. -- ----------------------------
    412. 

  412. -- Records of pay_pay
    413. 

  413. -- ----------------------------
    414. 

  414. 

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

  416. -- Table structure for pay_type
    417. 

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

  418. DROP TABLE IF EXISTS `pay_type`;
    419. 

  419. CREATE TABLE `pay_type` (
    420. 

  420.   `pay_type_id` int(10) NOT NULL AUTO_INCREMENT,
    421. 

  421.   `pay_vendor_id` int(10) DEFAULT NULL,
    422. 

  422.   `pay_mch_id` int(10) DEFAULT NULL,
    423. 

  423.   PRIMARY KEY (`pay_type_id`)
    424. 

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

  425. 

  426. -- ----------------------------
    427. 

  427. -- Records of pay_type
    428. 

  428. -- ----------------------------
    429. 

  429. 

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

  431. -- Table structure for pay_vendor
    432. 

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

  433. DROP TABLE IF EXISTS `pay_vendor`;
    434. 

  434. CREATE TABLE `pay_vendor` (
    435. 

  435.   `pay_vendor_id` int(10) NOT NULL AUTO_INCREMENT,
    436. 

  436.   `name` varchar(20) DEFAULT NULL,
    437. 

  437.   `appid` varchar(50) DEFAULT NULL,
    438. 

  438.   `appsecret` varchar(150) DEFAULT NULL,
    439. 

  439.   `config` varchar(1000) DEFAULT NULL,
    440. 

  440.   PRIMARY KEY (`pay_vendor_id`)
    441. 

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

  442. 

  443. -- ----------------------------
    444. 

  444. -- Records of pay_vendor
    445. 

  445. -- ----------------------------
    446. 

  446. 

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

  448. -- Table structure for pay_vest
    449. 

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

  450. DROP TABLE IF EXISTS `pay_vest`;
    451. 

  451. CREATE TABLE `pay_vest` (
    452. 

  452.   `pay_vest_id` int(10) NOT NULL AUTO_INCREMENT,
    453. 

  453.   `pay_type_id` int(10) DEFAULT NULL,
    454. 

  454.   `prefix` varchar(20) DEFAULT NULL,
    455. 

  455.   `param` varchar(1000) DEFAULT NULL,
    456. 

  456.   PRIMARY KEY (`pay_vest_id`)
    457. 

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

  458. 

  459. -- ----------------------------
    460. 

  460. -- Records of pay_vest
    461. 

  461. -- ----------------------------
    462. 

  462. 

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

  464. -- Table structure for upms_log
    465. 

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

  466. DROP TABLE IF EXISTS `upms_log`;
    467. 

  467. CREATE TABLE `upms_log` (
    468. 

  468.   `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
    469. 

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

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

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

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

  473.   `base_path` varchar(100) DEFAULT NULL COMMENT '根路径',
    474. 

  474.   `uri` varchar(200) DEFAULT NULL COMMENT 'URI',
    475. 

  475.   `url` varchar(200) DEFAULT NULL COMMENT 'URL',
    476. 

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

  477.   `parameter` mediumtext,
    478. 

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

  479.   `ip` varchar(30) DEFAULT NULL COMMENT 'IP地址',
    480. 

  480.   `result` mediumtext,
    481. 

  481.   `permissions` varchar(100) DEFAULT NULL COMMENT '权限值',
    482. 

  482.   PRIMARY KEY (`log_id`)
    483. 

  483. ) ENGINE=InnoDB AUTO_INCREMENT=2228 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志';
    484. 

  484. 

  485. -- ----------------------------
    486. 

  486. -- Records of upms_log
    487. 

  487. -- ----------------------------
    488. 

  488. 

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

  490. -- Table structure for upms_organization
    491. 

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

  492. DROP TABLE IF EXISTS `upms_organization`;
    493. 

  493. CREATE TABLE `upms_organization` (
    494. 

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

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

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

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

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

  499.   PRIMARY KEY (`organization_id`)
    500. 

  500. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='组织';
    501. 

  501. 

  502. -- ----------------------------
    503. 

  503. -- Records of upms_organization
    504. 

  504. -- ----------------------------
    505. 

  505. INSERT INTO `upms_organization` VALUES ('1', null, '总部', '北京总部', '1');
    506. 

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

  507. INSERT INTO `upms_organization` VALUES ('5', null, '河南分部', '河南郑州', '1488122480265');
    508. 

  508. INSERT INTO `upms_organization` VALUES ('6', null, '湖北分部', '湖北武汉', '1488122493265');
    509. 

  509. INSERT INTO `upms_organization` VALUES ('7', null, '湖南分部', '湖南长沙', '1488122502752');
    510. 

  510. 

  511. -- ----------------------------
    512. 

  512. -- Table structure for upms_permission
    513. 

  513. -- ----------------------------
    514. 

  514. DROP TABLE IF EXISTS `upms_permission`;
    515. 

  515. CREATE TABLE `upms_permission` (
    516. 

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

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

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

  519.   `name` varchar(20) DEFAULT NULL COMMENT '名称',
    520. 

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

  521.   `permission_value` varchar(50) DEFAULT NULL COMMENT '权限值',
    522. 

  522.   `uri` varchar(100) DEFAULT NULL COMMENT '路径',
    523. 

  523.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    524. 

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

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

  526.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    527. 

  527.   PRIMARY KEY (`permission_id`)
    528. 

  528. ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COMMENT='权限';
    529. 

  529. 

  530. -- ----------------------------
    531. 

  531. -- Records of upms_permission
    532. 

  532. -- ----------------------------
    533. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  602. 

  603. -- ----------------------------
    604. 

  604. -- Table structure for upms_role
    605. 

  605. -- ----------------------------
    606. 

  606. DROP TABLE IF EXISTS `upms_role`;
    607. 

  607. CREATE TABLE `upms_role` (
    608. 

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

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

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

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

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

  613.   `orders` bigint(20) NOT NULL COMMENT '排序',
    614. 

  614.   PRIMARY KEY (`role_id`)
    615. 

  615. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色';
    616. 

  616. 

  617. -- ----------------------------
    618. 

  618. -- Records of upms_role
    619. 

  619. -- ----------------------------
    620. 

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

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

  622. 

  623. -- ----------------------------
    624. 

  624. -- Table structure for upms_role_permission
    625. 

  625. -- ----------------------------
    626. 

  626. DROP TABLE IF EXISTS `upms_role_permission`;
    627. 

  627. CREATE TABLE `upms_role_permission` (
    628. 

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

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

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

  631.   PRIMARY KEY (`role_permission_id`),
    632. 

  632.   KEY `FK_Reference_23` (`role_id`),
    633. 

  633.   CONSTRAINT `FK_Reference_23` FOREIGN KEY (`role_id`) REFERENCES `upms_role` (`role_id`)
    634. 

  634. ) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COMMENT='角色权限关联表';
    635. 

  635. 

  636. -- ----------------------------
    637. 

  637. -- Records of upms_role_permission
    638. 

  638. -- ----------------------------
    639. 

  639. INSERT INTO `upms_role_permission` VALUES ('1', '1', '1');
    640. 

  640. INSERT INTO `upms_role_permission` VALUES ('2', '1', '2');
    641. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  670. INSERT INTO `upms_role_permission` VALUES ('42', '1', '26');
    671. 

  671. INSERT INTO `upms_role_permission` VALUES ('43', '1', '25');
    672. 

  672. INSERT INTO `upms_role_permission` VALUES ('44', '1', '48');
    673. 

  673. INSERT INTO `upms_role_permission` VALUES ('45', '1', '50');
    674. 

  674. INSERT INTO `upms_role_permission` VALUES ('47', '1', '53');
    675. 

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

  676. INSERT INTO `upms_role_permission` VALUES ('49', '1', '54');
    677. 

  677. INSERT INTO `upms_role_permission` VALUES ('50', '1', '54');
    678. 

  678. INSERT INTO `upms_role_permission` VALUES ('51', '1', '55');
    679. 

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

  680. INSERT INTO `upms_role_permission` VALUES ('53', '1', '55');
    681. 

  681. INSERT INTO `upms_role_permission` VALUES ('54', '1', '56');
    682. 

  682. INSERT INTO `upms_role_permission` VALUES ('55', '1', '57');
    683. 

  683. INSERT INTO `upms_role_permission` VALUES ('56', '1', '58');
    684. 

  684. INSERT INTO `upms_role_permission` VALUES ('57', '1', '58');
    685. 

  685. INSERT INTO `upms_role_permission` VALUES ('58', '1', '59');
    686. 

  686. INSERT INTO `upms_role_permission` VALUES ('59', '1', '60');
    687. 

  687. INSERT INTO `upms_role_permission` VALUES ('60', '1', '61');
    688. 

  688. INSERT INTO `upms_role_permission` VALUES ('61', '1', '62');
    689. 

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

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

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

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

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

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

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

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

  697. INSERT INTO `upms_role_permission` VALUES ('70', '1', '65');
    698. 

  698. INSERT INTO `upms_role_permission` VALUES ('71', '1', '62');
    699. 

  699. INSERT INTO `upms_role_permission` VALUES ('72', '1', '63');
    700. 

  700. INSERT INTO `upms_role_permission` VALUES ('73', '1', '64');
    701. 

  701. INSERT INTO `upms_role_permission` VALUES ('74', '1', '65');
    702. 

  702. INSERT INTO `upms_role_permission` VALUES ('75', '1', '66');
    703. 

  703. INSERT INTO `upms_role_permission` VALUES ('76', '1', '62');
    704. 

  704. INSERT INTO `upms_role_permission` VALUES ('77', '1', '63');
    705. 

  705. INSERT INTO `upms_role_permission` VALUES ('78', '1', '64');
    706. 

  706. INSERT INTO `upms_role_permission` VALUES ('79', '1', '65');
    707. 

  707. INSERT INTO `upms_role_permission` VALUES ('80', '1', '66');
    708. 

  708. INSERT INTO `upms_role_permission` VALUES ('81', '1', '67');
    709. 

  709. INSERT INTO `upms_role_permission` VALUES ('82', '1', '68');
    710. 

  710. INSERT INTO `upms_role_permission` VALUES ('83', '1', '69');
    711. 

  711. INSERT INTO `upms_role_permission` VALUES ('84', '1', '69');
    712. 

  712. INSERT INTO `upms_role_permission` VALUES ('85', '1', '70');
    713. 

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

  714. INSERT INTO `upms_role_permission` VALUES ('87', '1', '70');
    715. 

  715. INSERT INTO `upms_role_permission` VALUES ('88', '1', '71');
    716. 

  716. INSERT INTO `upms_role_permission` VALUES ('89', '1', '72');
    717. 

  717. INSERT INTO `upms_role_permission` VALUES ('90', '1', '72');
    718. 

  718. INSERT INTO `upms_role_permission` VALUES ('91', '1', '73');
    719. 

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

  720. INSERT INTO `upms_role_permission` VALUES ('93', '1', '73');
    721. 

  721. INSERT INTO `upms_role_permission` VALUES ('94', '1', '74');
    722. 

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

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

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

  725. INSERT INTO `upms_role_permission` VALUES ('98', '1', '75');
    726. 

  726. INSERT INTO `upms_role_permission` VALUES ('99', '1', '76');
    727. 

  727. INSERT INTO `upms_role_permission` VALUES ('100', '1', '76');
    728. 

  728. INSERT INTO `upms_role_permission` VALUES ('101', '1', '77');
    729. 

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

  730. INSERT INTO `upms_role_permission` VALUES ('103', '1', '77');
    731. 

  731. INSERT INTO `upms_role_permission` VALUES ('105', '1', '79');
    732. 

  732. INSERT INTO `upms_role_permission` VALUES ('106', '1', '80');
    733. 

  733. INSERT INTO `upms_role_permission` VALUES ('107', '1', '81');
    734. 

  734. INSERT INTO `upms_role_permission` VALUES ('108', '1', '81');
    735. 

  735. INSERT INTO `upms_role_permission` VALUES ('109', '1', '82');
    736. 

  736. INSERT INTO `upms_role_permission` VALUES ('110', '1', '81');
    737. 

  737. INSERT INTO `upms_role_permission` VALUES ('111', '1', '82');
    738. 

  738. INSERT INTO `upms_role_permission` VALUES ('112', '1', '83');
    739. 

  739. INSERT INTO `upms_role_permission` VALUES ('113', '1', '84');
    740. 

  740. INSERT INTO `upms_role_permission` VALUES ('114', '1', '84');
    741. 

  741. INSERT INTO `upms_role_permission` VALUES ('115', '1', '85');
    742. 

  742. INSERT INTO `upms_role_permission` VALUES ('121', '1', '78');
    743. 

  743. INSERT INTO `upms_role_permission` VALUES ('122', '1', '78');
    744. 

  744. 

  745. -- ----------------------------
    746. 

  746. -- Table structure for upms_system
    747. 

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

  748. DROP TABLE IF EXISTS `upms_system`;
    749. 

  749. CREATE TABLE `upms_system` (
    750. 

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

  751.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    752. 

  752.   `banner` varchar(50) DEFAULT NULL COMMENT '背景',
    753. 

  753.   `theme` varchar(50) DEFAULT NULL COMMENT '主题',
    754. 

  754.   `basepath` varchar(100) DEFAULT NULL COMMENT '根目录',
    755. 

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

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

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

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

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

  760.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    761. 

  761.   PRIMARY KEY (`system_id`)
    762. 

  762. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='系统';
    763. 

  763. 

  764. -- ----------------------------
    765. 

  765. -- Records of upms_system
    766. 

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

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

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

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

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

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

  772. 

  773. -- ----------------------------
    774. 

  774. -- Table structure for upms_user
    775. 

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

  776. DROP TABLE IF EXISTS `upms_user`;
    777. 

  777. CREATE TABLE `upms_user` (
    778. 

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

  779.   `username` varchar(20) NOT NULL COMMENT '帐号',
    780. 

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

  781.   `salt` varchar(32) DEFAULT NULL COMMENT '盐',
    782. 

  782.   `realname` varchar(20) DEFAULT NULL COMMENT '姓名',
    783. 

  783.   `avatar` varchar(50) DEFAULT NULL COMMENT '头像',
    784. 

  784.   `phone` varchar(20) DEFAULT NULL COMMENT '电话',
    785. 

  785.   `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
    786. 

  786.   `sex` tinyint(4) DEFAULT NULL COMMENT '性别',
    787. 

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

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

  789.   PRIMARY KEY (`user_id`)
    790. 

  790. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户';
    791. 

  791. 

  792. -- ----------------------------
    793. 

  793. -- Records of upms_user
    794. 

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

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

  796. 

  797. -- ----------------------------
    798. 

  798. -- Table structure for upms_user_organization
    799. 

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

  800. DROP TABLE IF EXISTS `upms_user_organization`;
    801. 

  801. CREATE TABLE `upms_user_organization` (
    802. 

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

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

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

  805.   PRIMARY KEY (`user_organization_id`)
    806. 

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

  807. 

  808. -- ----------------------------
    809. 

  809. -- Records of upms_user_organization
    810. 

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

  811. INSERT INTO `upms_user_organization` VALUES ('19', '1', '1');
    812. 

  812. INSERT INTO `upms_user_organization` VALUES ('20', '1', '4');
    813. 

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

  814. INSERT INTO `upms_user_organization` VALUES ('22', '1', '6');
    815. 

  815. INSERT INTO `upms_user_organization` VALUES ('23', '1', '7');
    816. 

  816. 

  817. -- ----------------------------
    818. 

  818. -- Table structure for upms_user_permission
    819. 

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

  820. DROP TABLE IF EXISTS `upms_user_permission`;
    821. 

  821. CREATE TABLE `upms_user_permission` (
    822. 

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

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

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

  825.   `type` tinyint(4) NOT NULL COMMENT '权限类型(-1:减权限,1:增权限)',
    826. 

  826.   PRIMARY KEY (`user_permission_id`)
    827. 

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

  828. 

  829. -- ----------------------------
    830. 

  830. -- Records of upms_user_permission
    831. 

  831. -- ----------------------------
    832. 

  832. INSERT INTO `upms_user_permission` VALUES ('3', '1', '22', '-1');
    833. 

  833. INSERT INTO `upms_user_permission` VALUES ('4', '1', '22', '1');
    834. 

  834. 

  835. -- ----------------------------
    836. 

  836. -- Table structure for upms_user_role
    837. 

  837. -- ----------------------------
    838. 

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

  839. CREATE TABLE `upms_user_role` (
    840. 

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

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

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

  843.   PRIMARY KEY (`user_role_id`)
    844. 

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

  845. 

  846. -- ----------------------------
    847. 

  847. -- Records of upms_user_role
    848. 

  848. -- ----------------------------
    849. 

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

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