Home Esplora Aiuto
Accedi
chendeben
/
zheng
1
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): ef2e5dc6d5
Rami (Branch) Tag
zheng
/
project-datamodel
/
zheng_20170326_2.sql

zheng_20170326_2.sql 163 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859 
  1. /*
    2. 

  2. Navicat MySQL Data Transfer
    3. 

  3. 

  4. Source Server         : 127.0.0.1
    5. 

  5. Source Server Version : 50621
    6. 

  6. Source Host           : localhost:3306
    7. 

  7. Source Database       : zheng
    8. 

  8. 

  9. Target Server Type    : MYSQL
    10. 

  10. Target Server Version : 50621
    11. 

  11. File Encoding         : 65001
    12. 

  12. 

  13. Date: 2017-03-26 22:20:29
    14. 

  14. */
    15. 

  15. 

  16. SET FOREIGN_KEY_CHECKS=0;
    17. 

  17. 

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

  19. -- Table structure for cms_article
    20. 

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

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

  22. CREATE TABLE `cms_article` (
    23. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  42. 

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

  44. -- Records of cms_article
    45. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  60. 

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

  62. -- Table structure for cms_article_category
    63. 

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

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

  65. CREATE TABLE `cms_article_category` (
    66. 

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

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

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

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

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

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

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

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

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

  75. 

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

  77. -- Records of cms_article_category
    78. 

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

  79. 

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

  81. -- Table structure for cms_article_tag
    82. 

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

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

  84. CREATE TABLE `cms_article_tag` (
    85. 

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

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

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

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

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

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

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

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

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

  94. 

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

  96. -- Records of cms_article_tag
    97. 

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

  98. 

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

  100. -- Table structure for cms_book
    101. 

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

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

  103. CREATE TABLE `cms_book` (
    104. 

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

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

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

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

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

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

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

  111. 

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

  113. -- Records of cms_book
    114. 

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

  115. 

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

  117. -- Table structure for cms_category
    118. 

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

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

  120. CREATE TABLE `cms_category` (
    121. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  138. 

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

  140. -- Records of cms_category
    141. 

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

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

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

  144. 

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

  146. -- Table structure for cms_category_tag
    147. 

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

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

  149. CREATE TABLE `cms_category_tag` (
    150. 

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

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

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

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

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

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

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

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

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

  159. 

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

  161. -- Records of cms_category_tag
    162. 

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

  163. 

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

  165. -- Table structure for cms_comment
    166. 

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

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

  168. CREATE TABLE `cms_comment` (
    169. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  184. 

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

  186. -- Records of cms_comment
    187. 

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

  188. 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', '1490535749413');
    189. 

  189. 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', '1490536186447');
    190. 

  190. 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', '1490536192205');
    191. 

  191. 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', '1490536460544');
    192. 

  192. 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', '1490536462182');
    193. 

  193. 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', '1490536463614');
    194. 

  194. 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', '1490536464870');
    195. 

  195. 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', '1490536465926');
    196. 

  196. 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', '1490536466853');
    197. 

  197. 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', '1490536467821');
    198. 

  198. 

  199. -- ----------------------------
    200. 

  200. -- Table structure for cms_menu
    201. 

  201. -- ----------------------------
    202. 

  202. DROP TABLE IF EXISTS `cms_menu`;
    203. 

  203. CREATE TABLE `cms_menu` (
    204. 

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

  205.   `pid` int(11) DEFAULT NULL COMMENT '父菜单',
    206. 

  206.   `name` varchar(20) DEFAULT NULL COMMENT '名称',
    207. 

  207.   `url` varchar(100) DEFAULT NULL COMMENT '链接',
    208. 

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

  209.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    210. 

  210.   PRIMARY KEY (`menu_id`)
    211. 

  211. ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='菜单';
    212. 

  212. 

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

  214. -- Records of cms_menu
    215. 

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

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

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

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

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

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

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

  222. 

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

  224. -- Table structure for cms_page
    225. 

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

  226. DROP TABLE IF EXISTS `cms_page`;
    227. 

  227. CREATE TABLE `cms_page` (
    228. 

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

  229.   `pid` int(10) DEFAULT NULL COMMENT '父页面',
    230. 

  230.   `title` varchar(20) DEFAULT NULL COMMENT '标题',
    231. 

  231.   `alias` varchar(20) DEFAULT NULL COMMENT '别名',
    232. 

  232.   `content` mediumtext COMMENT '页面内容',
    233. 

  233.   `keywords` varchar(100) DEFAULT NULL COMMENT '关键字',
    234. 

  234.   `description` varchar(300) DEFAULT NULL COMMENT '描述',
    235. 

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

  236.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    237. 

  237.   PRIMARY KEY (`page_id`)
    238. 

  238. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='页面';
    239. 

  239. 

  240. -- ----------------------------
    241. 

  241. -- Records of cms_page
    242. 

  242. -- ----------------------------
    243. 

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

  244. 

  245. -- ----------------------------
    246. 

  246. -- Table structure for cms_setting
    247. 

  247. -- ----------------------------
    248. 

  248. DROP TABLE IF EXISTS `cms_setting`;
    249. 

  249. CREATE TABLE `cms_setting` (
    250. 

  250.   `setting_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    251. 

  251.   `setting_key` varchar(10) DEFAULT NULL,
    252. 

  252.   `setting_value` varchar(500) DEFAULT NULL,
    253. 

  253.   PRIMARY KEY (`setting_id`)
    254. 

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

  255. 

  256. -- ----------------------------
    257. 

  257. -- Records of cms_setting
    258. 

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

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

  260. 

  261. -- ----------------------------
    262. 

  262. -- Table structure for cms_tag
    263. 

  263. -- ----------------------------
    264. 

  264. DROP TABLE IF EXISTS `cms_tag`;
    265. 

  265. CREATE TABLE `cms_tag` (
    266. 

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

  267.   `name` varchar(20) NOT NULL COMMENT '名称',
    268. 

  268.   `description` varchar(200) DEFAULT NULL COMMENT '描述',
    269. 

  269.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    270. 

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

  271.   `alias` varchar(20) DEFAULT NULL COMMENT '别名',
    272. 

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

  273.   `orders` bigint(20) unsigned NOT NULL COMMENT '排序',
    274. 

  274.   PRIMARY KEY (`tag_id`),
    275. 

  275.   KEY `cms_tag_orders` (`orders`),
    276. 

  276.   KEY `cms_tag_alias` (`alias`)
    277. 

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

  278. 

  279. -- ----------------------------
    280. 

  280. -- Records of cms_tag
    281. 

  281. -- ----------------------------
    282. 

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

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

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

  285. 

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

  287. -- Table structure for cms_topic
    288. 

  288. -- ----------------------------
    289. 

  289. DROP TABLE IF EXISTS `cms_topic`;
    290. 

  290. CREATE TABLE `cms_topic` (
    291. 

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

  292.   `title` varchar(100) DEFAULT NULL COMMENT '标题',
    293. 

  293.   `description` varchar(300) DEFAULT NULL COMMENT '描述',
    294. 

  294.   `url` varchar(100) DEFAULT NULL COMMENT '链接',
    295. 

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

  296.   PRIMARY KEY (`topic_id`)
    297. 

  297. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='专题';
    298. 

  298. 

  299. -- ----------------------------
    300. 

  300. -- Records of cms_topic
    301. 

  301. -- ----------------------------
    302. 

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

  303. 

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

  305. -- Table structure for cms_user
    306. 

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

  307. DROP TABLE IF EXISTS `cms_user`;
    308. 

  308. CREATE TABLE `cms_user` (
    309. 

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

  310.   `username` varchar(32) DEFAULT NULL COMMENT '账号',
    311. 

  311.   `password` varchar(32) DEFAULT NULL COMMENT '密码',
    312. 

  312.   `nickname` varchar(32) DEFAULT NULL COMMENT '昵称',
    313. 

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

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

  315.   `content` text COMMENT '备注',
    316. 

  316.   PRIMARY KEY (`user_id`)
    317. 

  317. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';
    318. 

  318. 

  319. -- ----------------------------
    320. 

  320. -- Records of cms_user
    321. 

  321. -- ----------------------------
    322. 

  322. 

  323. -- ----------------------------
    324. 

  324. -- Table structure for pay_in_order
    325. 

  325. -- ----------------------------
    326. 

  326. DROP TABLE IF EXISTS `pay_in_order`;
    327. 

  327. CREATE TABLE `pay_in_order` (
    328. 

  328.   `pay_in_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    329. 

  329.   `pay_vendor_id` int(10) DEFAULT NULL,
    330. 

  330.   `pay_mch_id` int(10) DEFAULT NULL,
    331. 

  331.   `amount` decimal(10,0) NOT NULL,
    332. 

  332.   `status` tinyint(4) NOT NULL,
    333. 

  333.   `ctime` bigint(20) unsigned NOT NULL,
    334. 

  334.   PRIMARY KEY (`pay_in_order_id`),
    335. 

  335.   KEY `FK_Reference_32` (`pay_vendor_id`),
    336. 

  336.   KEY `FK_Reference_38` (`pay_mch_id`),
    337. 

  337.   CONSTRAINT `FK_Reference_32` FOREIGN KEY (`pay_vendor_id`) REFERENCES `pay_vendor` (`pay_vendor_id`),
    338. 

  338.   CONSTRAINT `FK_Reference_38` FOREIGN KEY (`pay_mch_id`) REFERENCES `pay_mch` (`pay_mch_id`)
    339. 

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

  340. 

  341. -- ----------------------------
    342. 

  342. -- Records of pay_in_order
    343. 

  343. -- ----------------------------
    344. 

  344. 

  345. -- ----------------------------
    346. 

  346. -- Table structure for pay_in_order_detail
    347. 

  347. -- ----------------------------
    348. 

  348. DROP TABLE IF EXISTS `pay_in_order_detail`;
    349. 

  349. CREATE TABLE `pay_in_order_detail` (
    350. 

  350.   `pay_in_order_detail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    351. 

  351.   `pay_in_order_id` int(10) DEFAULT NULL,
    352. 

  352.   `product_id` varchar(50) DEFAULT NULL,
    353. 

  353.   `product_name` varchar(100) DEFAULT NULL,
    354. 

  354.   `product_price` decimal(10,0) DEFAULT NULL,
    355. 

  355.   `product_count` int(10) DEFAULT NULL,
    356. 

  356.   `remark` varchar(500) DEFAULT NULL,
    357. 

  357.   PRIMARY KEY (`pay_in_order_detail_id`)
    358. 

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

  359. 

  360. -- ----------------------------
    361. 

  361. -- Records of pay_in_order_detail
    362. 

  362. -- ----------------------------
    363. 

  363. 

  364. -- ----------------------------
    365. 

  365. -- Table structure for pay_mch
    366. 

  366. -- ----------------------------
    367. 

  367. DROP TABLE IF EXISTS `pay_mch`;
    368. 

  368. CREATE TABLE `pay_mch` (
    369. 

  369.   `pay_mch_id` int(10) NOT NULL AUTO_INCREMENT,
    370. 

  370.   `mch_id` varchar(20) DEFAULT NULL,
    371. 

  371.   `name` varchar(20) DEFAULT NULL,
    372. 

  372.   `reqKey` varchar(50) DEFAULT NULL,
    373. 

  373.   `resKey` varchar(50) DEFAULT NULL,
    374. 

  374.   PRIMARY KEY (`pay_mch_id`)
    375. 

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

  376. 

  377. -- ----------------------------
    378. 

  378. -- Records of pay_mch
    379. 

  379. -- ----------------------------
    380. 

  380. 

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

  382. -- Table structure for pay_out_order
    383. 

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

  384. DROP TABLE IF EXISTS `pay_out_order`;
    385. 

  385. CREATE TABLE `pay_out_order` (
    386. 

  386.   `pay_out_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    387. 

  387.   `pay_mch_id` int(10) DEFAULT NULL,
    388. 

  388.   `pay_vendor_id` int(10) DEFAULT NULL,
    389. 

  389.   `amount` decimal(10,0) NOT NULL,
    390. 

  390.   `status` tinyint(4) NOT NULL,
    391. 

  391.   `ctime` bigint(20) unsigned NOT NULL,
    392. 

  392.   PRIMARY KEY (`pay_out_order_id`)
    393. 

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

  394. 

  395. -- ----------------------------
    396. 

  396. -- Records of pay_out_order
    397. 

  397. -- ----------------------------
    398. 

  398. 

  399. -- ----------------------------
    400. 

  400. -- Table structure for pay_out_order_detail
    401. 

  401. -- ----------------------------
    402. 

  402. DROP TABLE IF EXISTS `pay_out_order_detail`;
    403. 

  403. CREATE TABLE `pay_out_order_detail` (
    404. 

  404.   `pay_out_order_detail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    405. 

  405.   `pay_out_order_id` int(10) DEFAULT NULL,
    406. 

  406.   `remark` varchar(500) DEFAULT NULL,
    407. 

  407.   PRIMARY KEY (`pay_out_order_detail_id`)
    408. 

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

  409. 

  410. -- ----------------------------
    411. 

  411. -- Records of pay_out_order_detail
    412. 

  412. -- ----------------------------
    413. 

  413. 

  414. -- ----------------------------
    415. 

  415. -- Table structure for pay_pay
    416. 

  416. -- ----------------------------
    417. 

  417. DROP TABLE IF EXISTS `pay_pay`;
    418. 

  418. CREATE TABLE `pay_pay` (
    419. 

  419.   `pay_pay_id` int(10) NOT NULL AUTO_INCREMENT,
    420. 

  420.   `pay_type_id` int(10) DEFAULT NULL,
    421. 

  421.   `param` varchar(1000) DEFAULT NULL,
    422. 

  422.   PRIMARY KEY (`pay_pay_id`)
    423. 

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

  424. 

  425. -- ----------------------------
    426. 

  426. -- Records of pay_pay
    427. 

  427. -- ----------------------------
    428. 

  428. 

  429. -- ----------------------------
    430. 

  430. -- Table structure for pay_type
    431. 

  431. -- ----------------------------
    432. 

  432. DROP TABLE IF EXISTS `pay_type`;
    433. 

  433. CREATE TABLE `pay_type` (
    434. 

  434.   `pay_type_id` int(10) NOT NULL AUTO_INCREMENT,
    435. 

  435.   `pay_vendor_id` int(10) DEFAULT NULL,
    436. 

  436.   `pay_mch_id` int(10) DEFAULT NULL,
    437. 

  437.   PRIMARY KEY (`pay_type_id`)
    438. 

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

  439. 

  440. -- ----------------------------
    441. 

  441. -- Records of pay_type
    442. 

  442. -- ----------------------------
    443. 

  443. 

  444. -- ----------------------------
    445. 

  445. -- Table structure for pay_vendor
    446. 

  446. -- ----------------------------
    447. 

  447. DROP TABLE IF EXISTS `pay_vendor`;
    448. 

  448. CREATE TABLE `pay_vendor` (
    449. 

  449.   `pay_vendor_id` int(10) NOT NULL AUTO_INCREMENT,
    450. 

  450.   `name` varchar(20) DEFAULT NULL,
    451. 

  451.   `appid` varchar(50) DEFAULT NULL,
    452. 

  452.   `appsecret` varchar(150) DEFAULT NULL,
    453. 

  453.   `config` varchar(1000) DEFAULT NULL,
    454. 

  454.   PRIMARY KEY (`pay_vendor_id`)
    455. 

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

  456. 

  457. -- ----------------------------
    458. 

  458. -- Records of pay_vendor
    459. 

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

  460. 

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

  462. -- Table structure for pay_vest
    463. 

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

  464. DROP TABLE IF EXISTS `pay_vest`;
    465. 

  465. CREATE TABLE `pay_vest` (
    466. 

  466.   `pay_vest_id` int(10) NOT NULL AUTO_INCREMENT,
    467. 

  467.   `pay_type_id` int(10) DEFAULT NULL,
    468. 

  468.   `prefix` varchar(20) DEFAULT NULL,
    469. 

  469.   `param` varchar(1000) DEFAULT NULL,
    470. 

  470.   PRIMARY KEY (`pay_vest_id`)
    471. 

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

  472. 

  473. -- ----------------------------
    474. 

  474. -- Records of pay_vest
    475. 

  475. -- ----------------------------
    476. 

  476. 

  477. -- ----------------------------
    478. 

  478. -- Table structure for upms_log
    479. 

  479. -- ----------------------------
    480. 

  480. DROP TABLE IF EXISTS `upms_log`;
    481. 

  481. CREATE TABLE `upms_log` (
    482. 

  482.   `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
    483. 

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

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

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

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

  487.   `base_path` varchar(100) DEFAULT NULL COMMENT '根路径',
    488. 

  488.   `uri` varchar(50) DEFAULT NULL COMMENT 'URI',
    489. 

  489.   `url` varchar(200) DEFAULT NULL COMMENT 'URL',
    490. 

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

  491.   `parameter` text COMMENT '请求参数',
    492. 

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

  493.   `ip` varchar(30) DEFAULT NULL COMMENT 'IP地址',
    494. 

  494.   `result` text COMMENT '响应结果',
    495. 

  495.   `permissions` varchar(100) DEFAULT NULL COMMENT '权限值',
    496. 

  496.   PRIMARY KEY (`log_id`)
    497. 

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

  498. 

  499. -- ----------------------------
    500. 

  500. -- Records of upms_log
    501. 

  501. -- ----------------------------
    502. 

  502. 

  503. -- ----------------------------
    504. 

  504. -- Table structure for upms_organization
    505. 

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

  506. DROP TABLE IF EXISTS `upms_organization`;
    507. 

  507. CREATE TABLE `upms_organization` (
    508. 

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

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

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

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

  512.   PRIMARY KEY (`organization_id`)
    513. 

  513. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='组织';
    514. 

  514. 

  515. -- ----------------------------
    516. 

  516. -- Records of upms_organization
    517. 

  517. -- ----------------------------
    518. 

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

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

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

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

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

  523. 

  524. -- ----------------------------
    525. 

  525. -- Table structure for upms_permission
    526. 

  526. -- ----------------------------
    527. 

  527. DROP TABLE IF EXISTS `upms_permission`;
    528. 

  528. CREATE TABLE `upms_permission` (
    529. 

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

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

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

  532.   `name` varchar(20) DEFAULT NULL COMMENT '名称',
    533. 

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

  534.   `permission_value` varchar(50) DEFAULT NULL COMMENT '权限值',
    535. 

  535.   `uri` varchar(100) DEFAULT NULL COMMENT '路径',
    536. 

  536.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    537. 

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

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

  539.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    540. 

  540.   PRIMARY KEY (`permission_id`)
    541. 

  541. ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COMMENT='权限';
    542. 

  542. 

  543. -- ----------------------------
    544. 

  544. -- Records of upms_permission
    545. 

  545. -- ----------------------------
    546. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  615. 

  616. -- ----------------------------
    617. 

  617. -- Table structure for upms_role
    618. 

  618. -- ----------------------------
    619. 

  619. DROP TABLE IF EXISTS `upms_role`;
    620. 

  620. CREATE TABLE `upms_role` (
    621. 

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

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

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

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

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

  626.   `orders` bigint(20) NOT NULL COMMENT '排序',
    627. 

  627.   PRIMARY KEY (`role_id`)
    628. 

  628. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色';
    629. 

  629. 

  630. -- ----------------------------
    631. 

  631. -- Records of upms_role
    632. 

  632. -- ----------------------------
    633. 

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

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

  635. 

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

  637. -- Table structure for upms_role_permission
    638. 

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

  639. DROP TABLE IF EXISTS `upms_role_permission`;
    640. 

  640. CREATE TABLE `upms_role_permission` (
    641. 

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

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

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

  644.   PRIMARY KEY (`role_permission_id`),
    645. 

  645.   KEY `FK_Reference_23` (`role_id`),
    646. 

  646.   CONSTRAINT `FK_Reference_23` FOREIGN KEY (`role_id`) REFERENCES `upms_role` (`role_id`)
    647. 

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

  648. 

  649. -- ----------------------------
    650. 

  650. -- Records of upms_role_permission
    651. 

  651. -- ----------------------------
    652. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  680. INSERT INTO `upms_role_permission` VALUES ('39', '1', '46');
    681. 

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

  682. INSERT INTO `upms_role_permission` VALUES ('41', '1', '26');
    683. 

  683. INSERT INTO `upms_role_permission` VALUES ('42', '1', '26');
    684. 

  684. INSERT INTO `upms_role_permission` VALUES ('43', '1', '25');
    685. 

  685. INSERT INTO `upms_role_permission` VALUES ('44', '1', '48');
    686. 

  686. INSERT INTO `upms_role_permission` VALUES ('45', '1', '50');
    687. 

  687. INSERT INTO `upms_role_permission` VALUES ('47', '1', '53');
    688. 

  688. INSERT INTO `upms_role_permission` VALUES ('48', '1', '18');
    689. 

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

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

  691. INSERT INTO `upms_role_permission` VALUES ('51', '1', '55');
    692. 

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

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

  694. INSERT INTO `upms_role_permission` VALUES ('54', '1', '56');
    695. 

  695. INSERT INTO `upms_role_permission` VALUES ('55', '1', '57');
    696. 

  696. INSERT INTO `upms_role_permission` VALUES ('56', '1', '58');
    697. 

  697. INSERT INTO `upms_role_permission` VALUES ('57', '1', '58');
    698. 

  698. INSERT INTO `upms_role_permission` VALUES ('58', '1', '59');
    699. 

  699. INSERT INTO `upms_role_permission` VALUES ('59', '1', '60');
    700. 

  700. INSERT INTO `upms_role_permission` VALUES ('60', '1', '61');
    701. 

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

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

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

  704. INSERT INTO `upms_role_permission` VALUES ('64', '1', '62');
    705. 

  705. INSERT INTO `upms_role_permission` VALUES ('65', '1', '63');
    706. 

  706. INSERT INTO `upms_role_permission` VALUES ('66', '1', '64');
    707. 

  707. INSERT INTO `upms_role_permission` VALUES ('67', '1', '62');
    708. 

  708. INSERT INTO `upms_role_permission` VALUES ('68', '1', '63');
    709. 

  709. INSERT INTO `upms_role_permission` VALUES ('69', '1', '64');
    710. 

  710. INSERT INTO `upms_role_permission` VALUES ('70', '1', '65');
    711. 

  711. INSERT INTO `upms_role_permission` VALUES ('71', '1', '62');
    712. 

  712. INSERT INTO `upms_role_permission` VALUES ('72', '1', '63');
    713. 

  713. INSERT INTO `upms_role_permission` VALUES ('73', '1', '64');
    714. 

  714. INSERT INTO `upms_role_permission` VALUES ('74', '1', '65');
    715. 

  715. INSERT INTO `upms_role_permission` VALUES ('75', '1', '66');
    716. 

  716. INSERT INTO `upms_role_permission` VALUES ('76', '1', '62');
    717. 

  717. INSERT INTO `upms_role_permission` VALUES ('77', '1', '63');
    718. 

  718. INSERT INTO `upms_role_permission` VALUES ('78', '1', '64');
    719. 

  719. INSERT INTO `upms_role_permission` VALUES ('79', '1', '65');
    720. 

  720. INSERT INTO `upms_role_permission` VALUES ('80', '1', '66');
    721. 

  721. INSERT INTO `upms_role_permission` VALUES ('81', '1', '67');
    722. 

  722. INSERT INTO `upms_role_permission` VALUES ('82', '1', '68');
    723. 

  723. INSERT INTO `upms_role_permission` VALUES ('83', '1', '69');
    724. 

  724. INSERT INTO `upms_role_permission` VALUES ('84', '1', '69');
    725. 

  725. INSERT INTO `upms_role_permission` VALUES ('85', '1', '70');
    726. 

  726. INSERT INTO `upms_role_permission` VALUES ('86', '1', '69');
    727. 

  727. INSERT INTO `upms_role_permission` VALUES ('87', '1', '70');
    728. 

  728. INSERT INTO `upms_role_permission` VALUES ('88', '1', '71');
    729. 

  729. INSERT INTO `upms_role_permission` VALUES ('89', '1', '72');
    730. 

  730. INSERT INTO `upms_role_permission` VALUES ('90', '1', '72');
    731. 

  731. INSERT INTO `upms_role_permission` VALUES ('91', '1', '73');
    732. 

  732. INSERT INTO `upms_role_permission` VALUES ('92', '1', '72');
    733. 

  733. INSERT INTO `upms_role_permission` VALUES ('93', '1', '73');
    734. 

  734. INSERT INTO `upms_role_permission` VALUES ('94', '1', '74');
    735. 

  735. INSERT INTO `upms_role_permission` VALUES ('95', '1', '72');
    736. 

  736. INSERT INTO `upms_role_permission` VALUES ('96', '1', '73');
    737. 

  737. INSERT INTO `upms_role_permission` VALUES ('97', '1', '74');
    738. 

  738. INSERT INTO `upms_role_permission` VALUES ('98', '1', '75');
    739. 

  739. INSERT INTO `upms_role_permission` VALUES ('99', '1', '76');
    740. 

  740. INSERT INTO `upms_role_permission` VALUES ('100', '1', '76');
    741. 

  741. INSERT INTO `upms_role_permission` VALUES ('101', '1', '77');
    742. 

  742. INSERT INTO `upms_role_permission` VALUES ('102', '1', '76');
    743. 

  743. INSERT INTO `upms_role_permission` VALUES ('103', '1', '77');
    744. 

  744. INSERT INTO `upms_role_permission` VALUES ('104', '1', '78');
    745. 

  745. INSERT INTO `upms_role_permission` VALUES ('105', '1', '79');
    746. 

  746. INSERT INTO `upms_role_permission` VALUES ('106', '1', '80');
    747. 

  747. INSERT INTO `upms_role_permission` VALUES ('107', '1', '81');
    748. 

  748. INSERT INTO `upms_role_permission` VALUES ('108', '1', '81');
    749. 

  749. INSERT INTO `upms_role_permission` VALUES ('109', '1', '82');
    750. 

  750. INSERT INTO `upms_role_permission` VALUES ('110', '1', '81');
    751. 

  751. INSERT INTO `upms_role_permission` VALUES ('111', '1', '82');
    752. 

  752. INSERT INTO `upms_role_permission` VALUES ('112', '1', '83');
    753. 

  753. INSERT INTO `upms_role_permission` VALUES ('113', '1', '84');
    754. 

  754. INSERT INTO `upms_role_permission` VALUES ('114', '1', '84');
    755. 

  755. INSERT INTO `upms_role_permission` VALUES ('115', '1', '85');
    756. 

  756. 

  757. -- ----------------------------
    758. 

  758. -- Table structure for upms_system
    759. 

  759. -- ----------------------------
    760. 

  760. DROP TABLE IF EXISTS `upms_system`;
    761. 

  761. CREATE TABLE `upms_system` (
    762. 

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

  763.   `icon` varchar(50) DEFAULT NULL COMMENT '图标',
    764. 

  764.   `banner` varchar(50) DEFAULT NULL COMMENT '背景',
    765. 

  765.   `theme` varchar(50) DEFAULT NULL COMMENT '主题',
    766. 

  766.   `basepath` varchar(100) DEFAULT NULL COMMENT '根目录',
    767. 

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

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

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

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

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

  772.   `orders` bigint(20) DEFAULT NULL COMMENT '排序',
    773. 

  773.   PRIMARY KEY (`system_id`)
    774. 

  774. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='系统';
    775. 

  775. 

  776. -- ----------------------------
    777. 

  777. -- Records of upms_system
    778. 

  778. -- ----------------------------
    779. 

  779. 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');
    780. 

  780. 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');
    781. 

  781. 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');
    782. 

  782. 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');
    783. 

  783. 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');
    784. 

  784. 

  785. -- ----------------------------
    786. 

  786. -- Table structure for upms_user
    787. 

  787. -- ----------------------------
    788. 

  788. DROP TABLE IF EXISTS `upms_user`;
    789. 

  789. CREATE TABLE `upms_user` (
    790. 

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

  791.   `username` varchar(20) NOT NULL COMMENT '帐号',
    792. 

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

  793.   `salt` varchar(32) DEFAULT NULL COMMENT '盐',
    794. 

  794.   `realname` varchar(20) DEFAULT NULL COMMENT '姓名',
    795. 

  795.   `avatar` varchar(50) DEFAULT NULL COMMENT '头像',
    796. 

  796.   `phone` varchar(20) DEFAULT NULL COMMENT '电话',
    797. 

  797.   `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
    798. 

  798.   `sex` tinyint(4) DEFAULT NULL COMMENT '性别',
    799. 

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

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

  801.   PRIMARY KEY (`user_id`)
    802. 

  802. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户';
    803. 

  803. 

  804. -- ----------------------------
    805. 

  805. -- Records of upms_user
    806. 

  806. -- ----------------------------
    807. 

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

  808. 

  809. -- ----------------------------
    810. 

  810. -- Table structure for upms_user_organization
    811. 

  811. -- ----------------------------
    812. 

  812. DROP TABLE IF EXISTS `upms_user_organization`;
    813. 

  813. CREATE TABLE `upms_user_organization` (
    814. 

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

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

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

  817.   PRIMARY KEY (`user_organization_id`)
    818. 

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

  819. 

  820. -- ----------------------------
    821. 

  821. -- Records of upms_user_organization
    822. 

  822. -- ----------------------------
    823. 

  823. INSERT INTO `upms_user_organization` VALUES ('19', '1', '1');
    824. 

  824. INSERT INTO `upms_user_organization` VALUES ('20', '1', '4');
    825. 

  825. INSERT INTO `upms_user_organization` VALUES ('21', '1', '5');
    826. 

  826. INSERT INTO `upms_user_organization` VALUES ('22', '1', '6');
    827. 

  827. INSERT INTO `upms_user_organization` VALUES ('23', '1', '7');
    828. 

  828. 

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

  830. -- Table structure for upms_user_permission
    831. 

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

  832. DROP TABLE IF EXISTS `upms_user_permission`;
    833. 

  833. CREATE TABLE `upms_user_permission` (
    834. 

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

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

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

  837.   PRIMARY KEY (`user_permission_id`)
    838. 

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

  839. 

  840. -- ----------------------------
    841. 

  841. -- Records of upms_user_permission
    842. 

  842. -- ----------------------------
    843. 

  843. 

  844. -- ----------------------------
    845. 

  845. -- Table structure for upms_user_role
    846. 

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

  847. DROP TABLE IF EXISTS `upms_user_role`;
    848. 

  848. CREATE TABLE `upms_user_role` (
    849. 

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

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

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

  852.   PRIMARY KEY (`user_role_id`)
    853. 

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

  854. 

  855. -- ----------------------------
    856. 

  856. -- Records of upms_user_role
    857. 

  857. -- ----------------------------
    858. 

  858. INSERT INTO `upms_user_role` VALUES ('4', '1', '1');
    859. 

  859. INSERT INTO `upms_user_role` VALUES ('5', '1', '2');
    860.