text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost
  Source Server Version : 50613
  Source Host           : localhost:3306
  Source Database       : jeesite
  
  Target Server Type    : MYSQL
  Target Server Version : 50613
  File Encoding         : 65001
  
  Date: 2015-09-23 14:51:51
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for `act_ge_bytearray`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_ge_bytearray`;
  CREATE TABLE `act_ge_bytearray` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `REV_` int(11) DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `BYTES_` longblob,
    `GENERATED_` tinyint(4) DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
    CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_ge_bytearray
  -- ----------------------------
  INSERT INTO `act_ge_bytearray` VALUES ('1d9d844a7d0d471a85fee4e4287e98ce', '1', 'leave.bpmn20.xml', 'a080cf2e82604c21b400cc96f7a68205', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22636F6D2E7468696E6B67656D2E6A6565736974652E6D6F64756C65732E6F612E6C65617665223E0A20203C70726F636573732069643D226C6561766522206E616D653D22E8AFB7E58187E6B581E7A88B2220697345786563757461626C653D2274727565223E0A202020203C646F63756D656E746174696F6E3EE8AFB7E58187E6B581E7A88BE6BC94E7A4BA3C2F646F63756D656E746174696F6E3E0A202020203C73746172744576656E742069643D2273746172746576656E743122206E616D653D225374617274222061637469766974693A696E69746961746F723D226170706C79557365724964223E3C2F73746172744576656E743E0A202020203C757365725461736B2069643D22646570744C6561646572417564697422206E616D653D22E983A8E997A8E9A286E5AFBCE5AEA1E689B9222061637469766974693A63616E64696461746547726F7570733D226F613A6C656176653A646570744C65616465724175646974223E3C2F757365725461736B3E0A202020203C6578636C7573697665476174657761792069643D226578636C7573697665676174657761793522206E616D653D224578636C75736976652047617465776179223E3C2F6578636C7573697665476174657761793E0A202020203C757365725461736B2069643D226D6F646966794170706C7922206E616D653D22E8B083E695B4E794B3E8AFB7222061637469766974693A61737369676E65653D22247B6170706C795573657249647D223E3C2F757365725461736B3E0A202020203C757365725461736B2069643D226872417564697422206E616D653D22E4BABAE4BA8BE5AEA1E689B9222061637469766974693A63616E64696461746547726F7570733D226F613A6C656176653A68724175646974223E3C2F757365725461736B3E0A202020203C6578636C7573697665476174657761792069643D226578636C7573697665676174657761793622206E616D653D224578636C75736976652047617465776179223E3C2F6578636C7573697665476174657761793E0A202020203C757365725461736B2069643D227265706F72744261636B22206E616D653D22E99480E58187222061637469766974693A61737369676E65653D22247B6170706C795573657249647D223E3C2F757365725461736B3E0A202020203C656E644576656E742069643D22656E646576656E743122206E616D653D22456E64223E3C2F656E644576656E743E0A202020203C6578636C7573697665476174657761792069643D226578636C7573697665676174657761793722206E616D653D224578636C75736976652047617465776179223E3C2F6578636C7573697665476174657761793E0A202020203C73657175656E6365466C6F772069643D22666C6F77322220736F757263655265663D2273746172746576656E743122207461726765745265663D22646570744C65616465724175646974223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77332220736F757263655265663D22646570744C6561646572417564697422207461726765745265663D226578636C75736976656761746577617935223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F773422206E616D653D22E4B88DE5908CE6848F2220736F757263655265663D226578636C7573697665676174657761793522207461726765745265663D226D6F646966794170706C79223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B21646570744C6561646572506173737D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F773522206E616D653D22E5908CE6848F2220736F757263655265663D226578636C7573697665676174657761793522207461726765745265663D2268724175646974223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B646570744C6561646572506173737D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77362220736F757263655265663D226872417564697422207461726765745265663D226578636C75736976656761746577617936223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F773722206E616D653D22E5908CE6848F2220736F757263655265663D226578636C7573697665676174657761793622207461726765745265663D227265706F72744261636B223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6872506173737D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77382220736F757263655265663D227265706F72744261636B22207461726765745265663D22656E646576656E7431223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F773922206E616D653D22E4B88DE5908CE6848F2220736F757263655265663D226578636C7573697665676174657761793622207461726765745265663D226D6F646966794170706C79223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B216872506173737D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313022206E616D653D22E9878DE696B0E794B3E8AFB72220736F757263655265663D226578636C7573697665676174657761793722207461726765745265663D22646570744C65616465724175646974223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B72654170706C797D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F7731312220736F757263655265663D226D6F646966794170706C7922207461726765745265663D226578636C75736976656761746577617937223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313222206E616D653D22E7BB93E69D9FE6B581E7A88B2220736F757263655265663D226578636C7573697665676174657761793722207461726765745265663D22656E646576656E7431223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B2172654170706C797D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F6C65617665223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D226C65617665222069643D2242504D4E506C616E655F6C65617665223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D2273746172746576656E7431222069643D2242504D4E53686170655F73746172746576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233352E30222077696474683D2233352E302220783D2231302E302220793D2239302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22646570744C65616465724175646974222069643D2242504D4E53686170655F646570744C65616465724175646974223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D2239302E302220793D2238302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226578636C75736976656761746577617935222069643D2242504D4E53686170655F6578636C75736976656761746577617935223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2234302E30222077696474683D2234302E302220783D223235302E302220793D2238372E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226D6F646966794170706C79222069643D2242504D4E53686170655F6D6F646966794170706C79223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223231382E302220793D223139302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D2268724175646974222069643D2242504D4E53686170655F68724175646974223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223335382E302220793D2238302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226578636C75736976656761746577617936222069643D2242504D4E53686170655F6578636C75736976656761746577617936223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2234302E30222077696474683D2234302E302220783D223439352E302220793D2238372E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227265706F72744261636B222069643D2242504D4E53686170655F7265706F72744261636B223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223539302E302220793D2238302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22656E646576656E7431222069643D2242504D4E53686170655F656E646576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233352E30222077696474683D2233352E302220783D223632352E302220793D223238332E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226578636C75736976656761746577617937222069643D2242504D4E53686170655F6578636C75736976656761746577617937223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2234302E30222077696474683D2234302E302220783D223235302E302220793D223238302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7732222069643D2242504D4E456467655F666C6F7732223E0A20202020202020203C6F6D6764693A776179706F696E7420783D2234352E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D2239302E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7733222069643D2242504D4E456467655F666C6F7733223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223139352E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223235302E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7734222069643D2242504D4E456467655F666C6F7734223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223237302E302220793D223132372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223237302E302220793D223139302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2233362E302220783D2231302E302220793D22302E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7735222069643D2242504D4E456467655F666C6F7735223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223239302E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223335382E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D222D32342E302220793D222D31372E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7736222069643D2242504D4E456467655F666C6F7736223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223436332E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223439352E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7737222069643D2242504D4E456467655F666C6F7737223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223533352E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223539302E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D222D32322E302220793D222D31372E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7738222069643D2242504D4E456467655F666C6F7738223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223634322E302220793D223133352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223634322E302220793D223238332E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7739222069643D2242504D4E456467655F666C6F7739223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223531352E302220793D223132372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223531342E302220793D223231372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223332332E302220793D223231372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2233362E302220783D2231302E302220793D22302E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773130222069643D2242504D4E456467655F666C6F773130223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223235302E302220793D223330302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223134322E302220793D223239392E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223134322E302220793D223133352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2234382E302220783D2231302E302220793D22302E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773131222069643D2242504D4E456467655F666C6F773131223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223237302E302220793D223234352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223237302E302220793D223238302E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773132222069643D2242504D4E456467655F666C6F773132223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223239302E302220793D223330302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223632352E302220793D223330302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2234382E302220783D2231302E302220793D22302E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, '0');
  INSERT INTO `act_ge_bytearray` VALUES ('64aee01b879f4bff96fba6a558db9e84', '1', 'leave.png', 'a080cf2e82604c21b400cc96f7a68205', 0x89504E470D0A1A0A0000000D49484452000004CF0000026208020000005F2772930000379849444154789CEDDD7F8CA4F57D1FF0C518585B465C95D49C2B0726E91FACE2DAB7AA23717F95C3517D5BA9B557AA65B6FEE3BC9265FBACA40EAAAA64DD0A5FD5989EAAC6BDA43622AD4D56AD68B78A0EAF14EC5E62703636902B60380C67AF81338B01676DC05ECA1D0CF7839B3EB7634F86F9F9CCEE77E63BCFF779BDF4D5696E77E6D967BECFE779BE9FF7CDDECC440D000000429B88BD030000002448DA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A4CD3EAAD5EAD2D2D2DCDCDC9E3D7B2A95CA445965CF3D9B81D9D9D9C5C5C58D8D8DD8878531E21CA9738E148BBAAD53B7000C95B4D9CB912347B295386B476EBFFDF6BBEEBEFBC91327CE9C3D5BCE913DF76C060E1F3EBC6FDFBE6C4EB2BE24F6C1612C38479C2345A46ED52D00A3216D76B6B1B1313F3FBF77EFDE679E7DE6CCD93346F378FE85E7B3BE249B9CF5F5F5D8078A689C23CE912252B7EA16805192363BC8DA91E9E9E92FDFF6A533674F1BDDC69D5FBDF3DA6BAF5D5B5B8B7DB888C039E21C292275AB6E01183169B383F9F9F9CD76E435A3F7B8EBEEAF5F77DD3F8A7DB888C039E21C292275AB6E01183169B3D5912347F6EE7DFFD9735523CFF8DDDFFBD737DFFCFBB10F1A23E51C718E1491BA55B7008C9EB4F906D56AB552A93CFBDCDAD973AF1A79C6C9533FDBB5EB3DABABABB10F1D23E21C718E1491BA55B70044216DBEC1E2E2E2FCFCFCD973AF34C6F533FF34E7FBC8373FAA54E3E69BFFFDC2C242EC43C78838479C2345A46ED52D0051489B6F303B3B7BF88EFFFDB7EDC8FBF7FE4DADF6F4EBB527CED6BE7BBAF6C8E9DA8327CF1DBAE31B7FF1DC4BF79FA9FDDF6AEDFE6AED9E576A5F7FADF647F73CFA89FD9F8CDE1C4419DF7EE8E8F4F474EC43375CF5F7B1F4617435E7488AE74819CA5BDDA657B7001482B4F906535353C78F3F7CF6DCA9FA9898983859AB9D3A5F7BE95CEDA7676AAFD46AFFEADF7C76E24D6FDBFDFED9E7CED69E395D7BE6B5DA5AB5F6E4B9DA9FFEF5239BFF047EAA84E3E4A917272727631FBA21CABAF0EBAEBBEECBB7DDB667CF9EB43BF23C9C23899D2325296F759B58DD02501401D266B55A5D5E5E3E70E0C0ECECEC9E5F989999C9BEB2B4B454ACF665C78E1D2FBCF8DCD97327EB236B325E79BD76FAF50BDF3A77FEC29F7FF6B53FFF7B7FFF1FFCDBCFFDC1B95AEDE573B597CED67E7AB6963DC3AF3FF09DCD8EE4643947F6DCE31EB8E1A9F7E20F7EFBA13367CF657FA6DD91E7E11C49E91C294F79ABDB94EA168002D9D6429285CC2C554E4E4E663933CB96870FDF71D7DDDFA88F3BBFFAB59B6EFAECDCDC5CB6C6EFDEBD7B717131D00E0FD76657F17263647F3D75AEF6E2ABB533AFFFFC0E592BF69FBFF0C7BFFF9FBEF0CC8F2E7CF8F5D9F3B5339B9DCA7DDF7EA4E5B1A51AA97624CDBD787D8C49471E71C29D23C99C23E353DE23981C759B4CDD02502C5B5C488E1D3B96352559C8CC5265A353E936EEB9F7BE7DFB3E3A3D3DBDB2B21274E7C3DBEC2AFE5F635CE8485EAF3DFF4AEDC7276B676BB533A74F4F5D73CDC4C4C51313931FFA17FB9A1FF8E0430FB73CB65423C98EA4BD171F5E47DEFB4D4AFADE27E09EE4D955E74802E7C850CB7B0CEB59DDA651B70014CE56169283070F66D1F1AEBBBFD13767B634315973B37FFFFE6AB51AFC6984B2D955BCD418139BBF6DF5E2ABB51FBD5CFBC96BB5078FFFE0CA2BAFBCF8CD97BEE58A5F9EFBC81B3A9207BEFD50CB634B35D2EB48BAF5E2430A9C3D26B0E55BCD7F8D32EDCE9104CE916197F718D6B3BA4DA06E0128A2C116922C28CECDCD2D2C2C0C94339BC7176FB925EB63D6D7D787F47CB669B3ABD8688CECAFAF9EAFFDB47AE1DFBF9F7FAD76F703ABEFDEF5DE5FFEBB6FBF62C7DFF9E3FFFEA7AFD56A274FD75E397DE181F71C7DA0E5B1A51A897524BD7BF16104CEFA04767C91A7DBB746F07250B75D758E14FA1C1941798F613DABDBA2D72D000535C0429245CDDDBB772F2D2D6D396A367EB136DBCEDADADAD09ED4D6652BEBB9733F6B8CFA429B35252F9DADFDEC4CED472F9FBDEFD1B55DFFF037AEFFC7FFE427A76B3FAED67E52ADBD78BA96F524F7DCFF40CB634B3552EA48F2F4E2C10367CED782DAEF36FA99778E14FA1C194D798F613DABDB42D72D00C535C042323737B7FDA8D9E863B2C03986BF52DBD255ECB9FEBAEF7CEF89071F5D3D7A6CF5DE8756EF7DF8F1FBBE73E22FEFFFEE5F3FFAD4371F7AFC5B0F7DFFDE87BF7FF491C71F7DE287B7FCD7DB3E7CC387A377063A926DCADF8B870D9C7D5F0B6ADC2DE2AB9A8D7D708E14F41C1959798F613DABDBE2D62D00859677213978F0E0767E81B67D1C3E7CC7ECECEC509FDB166C76243F6D1EBFF55B9FECFACB5E4DFEF9873ED4F2C0528D343A92417BF18081B3BD11EFF8C551BE16D48D73A4A0E7C828CB7B0CEB59DD16B46E0128BA5C0BC9B163C7A6A7A70346CDFAF8C4273E79EBADB70EFB190E64B32379D1187424D0916CAD170F1538F377E7EDB6FC43B7BCABD1EBAD8823EE3932E2F21EC37A56B745AC5B0012906B21C9A2E6D6DA94DEE399679FBBFAEACA58FD3EED858EE4F5178C4147D13B92F65EFCCEAF7EED9A6BA69E3C71A263E93EFFC28BBB76EDFAF26DB7850A9C8D46BCBDF3EE38B71127DC3952B87364F4E53D86F5AC6E0B57B700A4A1FF42B2BCBC3C3B3B1B3C6AD6C7A73FFD3B870E1D1AC1F3CC69B32379DE187414BA23E9D88B4F4E4E664FEAEAAB2BED1D79BD17AF77CFA102678F096C7CABA5596FBF311ACE91629D2351CA7B0CEB59DD16AB6E014846FF8524EB3006FD68CD815EDEDCB973E7089E674E9B1DC94F8C4147713B921EBD785D4B47DEDC8B070C9C5BE8CE7B7C71A89C23053A476295F718D6B3BA2D50DD0290923E0B49D658ECD8B1634851B33EAEBDF6DAA3478F8EE6D9F6B5D991FCD8187414B42369EFC55F3E796AE7CE9D2DBFFED7E8C8DB7BF14CD6BB3FF3EC73DB0C9CDD7EBDB0E3EF1FB6EC40B7870F8973A428E748C4F21EC37A56B745A95B0012D36721595C5C9C9F9F1F6ADAFCDCCD372F2C2C8CE6D9D62D2D2D75FBB4CFCD8E64DD18748C5B47D2E31037747BDF94EC2B3B76EC68EFC81F7AF8E18EBDF89D5FFD5AFB16427D0E672CCE91713E47947737EA769CEB168072EAB390ECDFBFFFD65B6F1D6ADABCEBEE6F64BDCB689E6DE6F1C71FAF3752975F7EF9E1C3875BBEAB2349A023E97D88EB7ABF4567C78EFCD24B2FCDD38B8F7F47DE9773649CCF11E5DD8DBA1DE7BA05A0B4FA2C24333333DD1A8E50E3C91327AEBEBA329A679BA956AB6F7AD39BEA4DC925975CF2AE77BDABF9DFC2373B92BF31061D63D591F43EC4B57C9F06D1B123CFD98B8F73479E8773649CCF11E5DD8DBA1DE7BA05A0B4FA2C2443FAEC93E6F1F2C9535967339A675BD7F23F97DEF296B77CEC631FAB7F104BF6D7D75FFF9131E818B78EA4C721CEFFC1833D3AF2BEBDF8D876E4393947C6F91C51DEDDA8DB71AE5B00CAA9CF42922DDECD6F1131A491AD6759D7D2E31FDA47E9F5D79F33061D13E374047BCB7AF1FCEFB1FC972B7F75F1C517B76CE1A28B2EBAEDB63FC9B985FA2F8A176572728A5E6F451C1323394794770FD16BA0886342DA04607BFA2C245353538F1D3F3E82B4399A675B77C5155734FA8FD94D59B7B4BABA5AFBF9BF7F3F6B0C3AC6AD23E971888F1D3B9675E4CFBFF062DFB2ECF8169D751D3FA8B0E316B29F9BFDC4D8F33130E7C8389F23CABB1B753BCE750B4039F5594886FA619BF531E2FFB7B9B1B151EF45B220FDF18F7F3CFB736969A9F1DDCD8EE4992D8CDE0F6C7CB7CBBFB8E7DA48B787B76C24CF5E35EF4FCE1FDD77C7467604FBEA7D886BF93AF21EBD78CE8E7C0C7BF19C86748E843A9BB67F9FE0F53FCA7344797713BD6EF3D761C79D89B88723A85B004AABCF42323F3FDFFCE9DEC318F7DC7BDFB5D75E3B9A679B79FAE9A72727276766662A95CAC2C242CB7F3ADA5CEF7F38D0684B7D3F6CF96BE36EDD1EDEED76FB76FA6EA447FBD8713B7DB79C7F12467604FBEA7D88EB7A77E41D7BF18B2EBA287F473E86BD787EC1CF912D9453DF13AD636DC7AAFF519E23CABB9BE875DBE3D037EAB347E1F528E6587B1EB06E0128AD3E0BC9A143873EFDE9DF196ADACCD2ECBE7D1F1DC993FDB9E5E5E5C5C5C58E1FCB16645D1FA8856DB973CB43DAFF9AB38DCEB963A1DAEE71EB487A1CE2866E1D79B7CFB8FFA3FFF2858E1F54D8DE918F672F3E90619F23394F8A816A3862FD8FF81C51DEDDC4ADDB3CC5DC7C9D6F2FDD3CABC0E8F77FE4871180A4F45948B265BB52A90C356DEEDDBBF7C89123A379B67D6DAEEB4F0F349A1F52BFDDF84AFB8D6E0F6FDF48C7470DBA7B1DEFDF145007DBD5DE3F28F6A1DB8AF68EBC5B2F5E7F8BCE8E6FE3D9D2918F732F1EC4D62A64FB75DB52BDCDA2D7FF789E23CABBD908EA763B15DE5C902DDF8DBBE705BDB603303EFA2F24437DA3A0974F9ECAFA9BFA3BD48F830BEBFAF9B54147FD518DC7B6FCB5E576C7C7B6DCEED04FE7DE4EC776BC7923DDEEDC7BFB7D6720F6A1DBA2F68E7CDFBE8F76ECC5EBA3BD23DFBB776F56C645EFC5F3DB72910C7A426DED3E51EA7F6CCF11E5DD3082BAED5D90DD8AB3F1F51E778EB2E711EB168094F45F4886FACBB47FF0F9CF671B1FC1F3CC69735D7F2AFFE8DED73ED5BCA91E9B6DF956E3AFDD1EDEED27E679608F9FD2BC852D8C4277243D3AF28E1F3CD8DC9127D38BE7B79D3AC9594BDD4E99BEC51FABFEC7F91C51DE75C33EBE7D4BBA6355B77C2BE24E8E5BDD02908CFE0B49B55AAD542AC3F8D4CDAC8FB9FAEACAFAFAFA089E674E9B8BFD0FB6391A1B69BFD1EDCE6DADF30FDAFFCCFFD3BB77E46FB84FCE3DCCF943631FBA6DE9D891F7F88CFB7A479E522F9E5F9073A4EFE9D3F7A7B4D473DCFA1FF3734479D7865FB7796AB54759B62C042D778EB5E771EB168034E45A489696963E7CC30DC9BFB059FB79477262A0D1D63A9C686CA4FD46C78777FC4AFB9F39B7D0FCD78EB71BFB99730F734E42EC43B75DED1D79D673F7A8DEC78E1F4FA917CF6F9BA5D2B7907A14766F11EB7FFCCF11E53D8243DCEDB8B72F0D1DCBB247C546D9F371A85B0012907721F9C0073F78F8F01D01A366D6CDECDAB52B6B6886FAF406B5B9AE3F39D0687E48FD76E32BED377A3FBCFD212D7FF6EBB69FEC7DB76E3FA5F71EE69C84D8872E803C1F54D83ED2E8C5F3DB66A90C7A360D7ACF28F55F8873A4E4E53D8243DCB7567B5FB79BEF30E2E21CE7BA05A0E8F22E241B1B1BD75E7B6DA8B70BAABF35E293274E0CF5B96DC1E6BAFEC440A3F921F5DB4D1D4387FB747B78E3B1DD369EF32BDD7E6EC7DBCD3BDC77577B4F42EC4317C6A01D7932BD787E5BAB90414FA56EB5DD3D49C6ACFFA29C23652EEFE11DD9FC85DDA3C2BB5DFF23EEF6F8D42D008536C042B2BABA9A05CE6E9FF73D50D4FCC0073F78E757BF36BC67B5655B4B9B2D5D6F9E88D8F15B1D73E340F132E7CF6D6E715A7E4AC9D3666D908E3CA55E3CBF21B5BF7D6B35FF3935FAFA2FD03952DAF28E9B36FB5ECCDBEFD0ED21A3DFF9D8870E80621B6C21C93A8F5DBB76DD73EF7D5B8E9A8F1D3F9E45D6F18C9AB5CD8EE4FCF9C7071ACD0FA9DF6EDF48C7CD36026AC77BB66F36E71672FEDC8E3FA5F7D67A4F42EC4317529E8E3CB15E3CBFAD5548FE9328CF777316EAC8EABF58E74839CB7B7847367F1DB65FED5BBE35D0F57F643B1FFBD001506C032F241B1B1B59A772D34D9F1DF4FFFFBC7CF2D41F7CFEF3F55FC71DC6330962735DFFBE31E848AF23E9DD91A7D78BE7E71C49E01C296179ABDB04EA168022DACA4252AD56B3B479CD3553597A6CBC6F61EFF1E5DB6ECBEEFFE94FFF4ED6C7047F0E016D7624ABC6A023C98EA45B479E642F9E9F73248D73A46CE5AD6ED3A85B000A67EB0BC9FAFAFA8D37DEB863C78E0F7CF08359986C7F3FFDEC2BB7DFFE3F3F7CC30DD97DF6EDFBE8DADA5AB8DD1E96CD8EE47BC6A023D58EA4BD234FB517CFCF3992CC3952AAF256B7C9D42D00C5B2DD85A45AAD2E2F2FCFCFCFEFDAB56BE28DB2AF645173696969636323C8BE8EC0E4E4E4ABAF3E7CFEFC778D8146C21D4973479E702F9E9F7324A573A43CE5AD6E53AA5B000AC442F206954AE5A9A7FEE2FCF9E3C64023ED8EA4DE913F79E244C2BD787ECE91C4CE919294B7BA4DAC6E01280A0BC91BCCCCCCFC9F23B79EAF3D66E41FDF5BFDB3A9A9A9D8876EB8B22E3CEB5613EEC5F3738EA4778E7CE0031F48BEBCD56D7A750B4021489B6F70F0E0C185858F455FE38B35FE64F173F3F3F3B10FDDD095E139E6E11C49EF1C29C3EB57EA36BDBA05A010D26F3206B2B6B63635F5ABAF561F3C5F7BD4C8396667DFB7BCBC1CFBD00D5D193AF23C9C23E99D2365A86D759B5EDD025008E93719833A70C1FEF3B5EF1879C6FF5AFA8F737333B10FDA2894A123CFC93992D8395292DA56B789D52D0085508A266320D56A75CF9EDF387AF47FD46A8F18BDC7FAFADD5353BFBAB1714FEC83360A25E9C8F3708E24768E94A4B6D56D62750B402194A2C918D4EAEAEAF4F435ABABCBB5DA31A3DBC8DA91AC755B59F952ECC3352225E9C873728EA4748E94A7B6D56D4A750B402194A5C918D4D1A347B3A6E4E0C17F59AB3D6CB48FE5E5CF4F4D555656FE5BEC03353AE5E9C873728E24738E94AAB6D56D32750B402194A8C91854B55A5D5898DFB3E7BD8B8BFF6E7DFDEBB5DA43C6C6C65F2D2DFD87B9B9BDB3B37BB2DBB10FD14895AA23CFC93992C63952B6DA56B769D42D008550AE26630B565656E6E7FFD9CE9DBF34C1C4C48E1D97CFCDBD3F6B4A621F9608264AD691E7E71C6956C47364A294B5AD6E9B15B16E01288432361905E573CFE29A2865474E19A8EDB85CDB01489826A318EEBFFFFEAC23DCD8D888BD23E5A52327556A3B2EF30F40C22C72C570D55557651DC96FFFF66FC7DE91F2D211922AB51D97F907206116B902F8C33FFCC3FA7FAD79C73BDE71ECD8B1D8BB53523A4252A5B6E332FF0024CC2237EE363636262727EB69F3D24B2F7DEF7BDF1B7B8F4A4A4748AAD4765CE61F808459E4C6DDECEC6CF33B075E75D5558B8B8BB177AA8C7484A44A6DC765FE014898456EAC6D6C6CB4BF55FD3BDFF9CE6AB51A7BD74A474748AAD4765CE61F808459E4C6DA97BEF4A57AC27CF7BBDFDD489BBFFEEBBFBEB2B2127BD74A474748AAD4765CE61F808459E4C6DAB7BEF5ADB7BDED6D954A65C78E1D5947B273D3DBDFFE766973F47484A44A6DC765FE014898456EDC1D3B766C6D6DADF68B8E24BBED6D69A3D011922AB51D97F907206116B9C2D091C465FE4995DA8ECBFC0390308B5C61E848E232FFA44A6DC765FE01489845AE30742471997F52A5B6E332FF0024CC2257183A92B8CC3FA952DB71997F001266912B0C1D495CE69F54A9EDB8CC3F0009B3C815868E242EF34FAAD4765CE61F808459E40A43471297F927556A3B2EF30F40C22C7285A12389CBFC932AB51D97F907206116B9C2D091C465FE4995DA8ECBFC0390308B5C61E848E232FFA44A6DC765FE01489845AE30742471997F52A5B6E332FF0024CC2257183A92B8CC3FA952DB71997F001266912B0C1D495CE69F54A9EDB8CC3F0009B3C815868E242EF34FAAD4765CE61F808459E40A4347125794F977D01901651697F907206116B9C2D091C4D57BFE27FAC973B7BEF719FA93A49494565CE61F808459E40A434712D7A0F3DFF1FE3D36D2F2ADE6BF3AF40C95028BCBFC0390308B5C61E848E20A98363BBE68D9ED5B5EDE64D8D4555CE61F808459E40A434712D740F3DFEDCE395FDB6CBF9BA3CFF0A8AEB8CC3F0009B3C815868E24AEFCF3DFF27265FB467ABCB6D9BC05AF6A321AAA2B2EF30F40C22C7285A123892BE7FCB744C78EFF1BB3EF17BDB6C928A9AEB8CC3F0009B3C815868E24AE3CF3DF3164B6DFCE9336BDB6C9C8A8AEB8CC3F0009B3C815868E24AEDEF3DF12083BE6C95A53B0ECFD9BB4397F2804A1CCE232FF0024CC2257183A92B846F62E41DD7E17570130244A2B2EF30F40C22C7285A123892B56DAECF14508425DC565FE01489845AE307424710D2F6DE67C67DA41F70172525771997F001266912B0C1D495CE69F54A9EDB8CC3F0009B3C815868E242EF34FAAD4765CE61F808459E40A43471297F927556A3B2EF30F40C22C7285A12389CBFC932AB51D97F907206116B9C2D091C465FE4995DA8ECBFC0390308B5C61E848E232FFA44A6DC765FE01489845AE30742471997F52A5B6E332FF0024CC2257183A92B8CC3FA952DB71997F001266912B0C1D495CE69F54A9EDB8CC3F0009B3C815868E242EF34FAAD4765CE61F808459E40A4347327A4B4B4BD9B44F4E4E4E4F4F673776EEDC99FDF9D6B7BE75757535F6AE4130AE2D71997F001266912B0C1DC9E87DE52B5F996873FDF5D72F2F2FC7DE3508C6B5252EF30F40C22C7285A12319BD6AB57AD965973547CDF7BCE73D3B77EEDCD8D888BD6B108C6B4B5CE61F808459E40A434712C5673EF39937BFF9CD8DB4F9A94F7D6A616121F64E4148AE2D71997F001266912B0C1D492C575E79653D6ADE70C30D954AA55AADC6DE2308C9B5252EF30F40C22C7285A12389E59BDFFCE625975C92CDFFCCCC8CFFB1497A5C5BE232FF0024CC2257183A9288DEF7BEF7D5D366EC1D81F05C5BE232FF0024CC2257183A9288D6D7D7B3F9F7C12724C9B5252EF30F40C22C7285A12389CBFC932AB51D97F907206116B9C228674752AD56979696E6E6E6F6ECD953A954DA3FFDB224B2E79ECDC0ECECECE2E2A2CF5F21AC89525E5BC687F907206116B9C228614772E4C8912C656551F3F6DB6FBFEBEEBB9F3C71E2CCD9B3E51CD973CF66E0F0E1C3FBF6EDCBE624CB9CB10F0EE928E1B565AC987F001266912B8C5275241B1B1BF3F3F37BF7EE7DE6D967CE9C3D63348FE75F783ECB9CD9E4ACAFAFC73E50A4A054D7963164FE01489845AE30CAD3916451737A7AFACBB77DE9CCD9D346B771E757EFBCF6DA6BD7D6D6621F2E0AAF3CD796F164FE01489845AE30CAD391CCCFCF6F46CDD78CDEE3AEBBBF7EDD75FF28F6E1A2F0CA736D194FE61F808459E40AA3241DC9912347F6EE7DFFD9735523CFF8DDDFFBD737DFFCFBB10F1AC556926BCBD832FF0024CC22571865E848AAD56AA55279F6B9B5B3E75E35F28C93A77EB66BD77B7C1028DB51866BCB3833FF0024CC22571865E848161717E7E7E7CF9E7BA531AE9FF9A7393F23A4F951A51A37DFFCEF171616621F3A0AAC0CD7967166FE01489845AE30CAD091CCCECE1EBEE37FFF6DD47CFFDEBFA9D59E7EBDF6C4D9DA774FD71E395D7BF0E4B943777CE32F9E7BE9FE33B5FF5BADDD5FADDDF34AEDEBAFD5FEE89E473FB1FF93D1835F94F1ED878E4E4F4FC73E74145819AE2DE3CCFC0390308B5C6194A123999A9A3A7EFCE1B3E74ED547F6944FD66AA7CED75E3A57FBE999DA2BB5DABFFA379F9D78D3DB76BF7FF6B9B3B5674ED79E79ADB656AD3D79AEF6A77FFDC8E6CB9BA74A384E9E7A71727232F6A1A3C0CA706D1967E61F808459E40AA30C1DC98E1D3B5E78F1B9B3E74ED647F6945F79BD76FAF50BDF3A77FEC29F7FF6B53FFF7B7FFF1FFCDBCFFDC1B95AEDE573B597CED67E7AB6B651AB7DFD81EF6CA6CD93E51C65A80D8647FDC465FE01489845AE30CAD0916C26C6971B23FBEBA973B5175FAD9D79FDE777D8D8D8F8CF5FF8E3DFFF4F5F78E647EBD95FCF9EAF9DD94CA1F77DFB9196C7966A94A136181EF51397F907206116B9C2284347B29918FF5F635C489BAFD79E7FA5F6E393B5B3B5DA99D3A7A7AEB96662E2E28989C90FFD8B7DCD0F7CF0A1875B1E5BAA5186DA6078D44F5CE61F808459E40AA30C1DC966627CA931EABF49FBE2ABB51FBD5CFBC96BB5078FFFE0CA2BAFBCF8CD97BEE58A5F9EFBC81BD2E603DF7EA8E5B1A51A65A80D8647FDC465FE01489845AE30CAD0916C26C68DC6C8FEFAEAF9DA4FAB175EDB7CFEB5DADD0FACBE7BD77B7FF9EFBEFD8A1D7FE78FFFFB9FBE56AB9D3C5D7BE5F48507DE73F48196C7966A94A1361892F5F5F59D3B77C6DE8B5273FE0290308B5C6194A123C99EE3B9733F6B8CFA53CE02E74B676B3F3B53FBD1CB67EF7B746DD73FFC8DEBFFF13FF9C9E9DA8FABB59F546B2F9EAE6579F39EFB1F68796CA946196A8321595B5BAB542AB1F7A2D49CBF0024CC22571865E8485A12E39EEBAFFBCEF79E78F0D1D5A3C756EF7D68F5DE871FBFEF3B27FEF2FEEFFEF5A34F7DF3A1C7BFF5D0F7EF7DF8FB471F79FCD1277E78CB7FBDEDC3377C387AEA9336299C23478ECCCCCCC4DE8B5273FE0290308B5C6194A123D94C9B3F6D1EBFF55B9F9CC8E19F7FE8432D0F2CD528436D30240736C5DE8B5273FE0290308B5C6194A123D94C9B2F1A838E32D4064332333373E4C891D87B516ACE5F001266912B8C32742417D2E6EB2F18838E32D406C3B0BEBE5EA954AAD56AEC1D2935E72F0009B3C81546193A92CDB4F9BC31E828436D300C870E1DBAF1C61B63EF45D9397F01489845AE30CAD0916CA6CD9F18838E32D406C155ABD54AA5B2BEBE1E7B47CACEF90B40C22C728551868E64336DFED8187494A136086E7E7E7E717131F65E508A6B3B00A565912B8C3274249B6973DD187474AB8DA5A5A5B5B5B5D11E438AE1D0A143FBF7EF8FBD175C50866B3B00A565912B8C327424D26690B4B9B1B1F1918F7CA4FED930EF78C73B044E9A55ABD5F9F97951737C94E1DA0E406959E40AA30C1DC966DAFC1B63D0D15C1BB7DE7AEBE4E4643D6A663776EEDCE93FE651B7B1B171E8D0A14AA5E21768C74A19AEED00949645AE30CAD09164CFF1F5D77F640C3AEAB5B1BABAFA6BBFF66B134D76EFDE9D458BD84795C85656560E1E3C383B3B9B15C38D37DEE85F1FC64D19AEED00949645AE30CAD0916CA6CDE78C4147366F7BF6EC99804EB2DA585858585E5EDED8D8887D8AD3C14409AEED00949645AE30CAD0914C5C489BCF1A838E7A6DACADADFDE66FFEE6AFFCCAAF3462C6E5975F3E3D3D1DFBA81259192E1D85E6000190308B5C6194A123D94C9BCF841DCDDBECF8CA4F8F3BE7DC6C8F2F0EE31975FCB98D393C72E4C8D5575FFDCE77BEB3FEEC2EBBECB26AB51AF198925FDF5729F3DCADEF7DE23D3F3A735000489845AE30CAD0916C66B31F061F8DCDB66FBFFE954E11F4872D7FEDB6CD9C1BECB69D504FB0791AB37879E0C081ABAEBA6A7A7A3AFBF3D8B163B10E28DBD4F1ACEF712968F956F35FCB700129288706808459E40AA30C1DC9F0F258B7D8D972A3392BB6A7CA1EAF17F5FD89C37E5EED93B9B6B6B6B8B8B8BCBC3CFAE348283DD266C7172DBB7DABFD9E8C0F4704808459E40AA30C1DC966367B7A78A3BEFDA688F874E327B6A5C7A75BEE90F376F317DBB739BCE715FBD0115EB7C3DAE3704FF47C31539D8C27C705808459E40AA30C1DC98548767E2DECF879D2FBC5ED6E371AF76CF94ACBA67ADF6E7978FB168634CA501B65D3F27265CBB76A3D5FDB6CDE42FB7D18378E0B0009B3C81546193A92CD6CF654F0D1D86CC7FEBBF93EDDFEECF1F0E68D343FAAF7DD823FC1D8878E905AA263CBF1ED98423BA6CD8E9B65DC382E0024CC22571865E84836F3D80F828FC666DBB75FFF4AFB1D9AEFD9FB8B79EEDCF147877D82B10F1DC1740C99EDB7F3A4CD7643DD73B6C67101206116B9C2284347B219C94E041F8DCDD66F34BDD2D8FA95EEAF49BE613B796E77DBC8909E60EC4347002D81B0639EAC3505CBF624D9B11294C798738000489845AE30CAD0916C46B227838FC666EB37DAFFEC76FFF6AF778FA39D7F56DF6D867A82B10F1DE1753BAC3D0E777B22EDF875C68A830240C22C728551868E6433923D117CFC22103ED1F8B3E52B8DBB35DFBFF96E2D77C873BB53220DFFD41A3F2BF6A123BC8069B3C71789CE1101206116B9C228434732BCB4D91E0B7B07C5FCDBEC9D6CFBDE5FDAA49B81D266E31F355AEED0F24F1E3D364B2C8E080009B3C81546193A92EC399E3FFFF89046CBC61BFD77F3ED6EFA6EADFDEBCD77E8B691804F2DF6A103B6C8F90B40C22C728551868E6433927DDF187494A1362055CE5F001266912B8C3274249B6973D5187494A1362055CE5F001266912B8C3274249B69F37BC6A0A30CB501A972FE0290308B5C6194A123999C9C7CF5D587CF9FFFAE31D028436D40AA9CBF0024CC22571865E8482A95CA534FFDC5F9F3C78D8146196A0352E5FC05206116B9C2284347323333F37F8EDC7ABEF698917F7C6FF5CFA6A6A6621F3A608BCA706D07A0B42C728551868EE4E0C1830B0B1F8B9EDF8A35FE64F173F3F3F3B10F1DB04565B8B603505A16B9C2284347B2B6B63635F5ABAF561F3C5F7BD4C8396667DFB7BCBC1CFBD0015B54866B3B00A565912B8C927424072ED87FBEF61D23CFF85F4BFF716E6E26F64103B6AE24D77600CAC922571825E948AAD5EA9E3DBF71F4E8FFA8D51E317A8FF5F5BBA7A67E7563E39ED8070DD8BA925CDB0128278B5C6194A723595D5D9D9EBE667575B9563B66741B59D4CC62F9CACA97621F2E605BCA736D07A0842C728551AA8EE4E8D1A359E03C78F05FD66A0F1BED6379F9F35353959595FF16FB4001DB55AA6B3B006563912B8CB27524D56A7561617ECF9EF72E2EFEBBF5F5AFD76A0F191B1B7FB5B4F41FE6E6F6CECEEEC96EC73E44400065BBB603502A16B9C2286747B2B2B2323FFFCF76EEFCA509262676ECB87C6EEEFD59E08C7D588060264A796D07A0242C7285A12389CB675A02C3E0DA0E40C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C728531684732D124CFA6B6F3C554BBA5A5A5A5ECA94D4E4E4E4F4F673776EEDC99FDF9D6B7BE75757535F6AE018948F5FA09003569B340FA7624136F94F33E7DEFDFE3EB135D0CF0ACC6DB57BEF295F66777FDF5D72F2F2FC7DE352011295D3301A08545AE3006EA48F2DFB9E30B9583C6C854BBA56AB57AD9659735CFC07BDEF39E9D3B776E6C6CC4DE35A0C0FCDE0400259166484852EF44D723223607C5E68D345E9FECF183BADDEEF173077F6663ED339FF9CC9BDFFCE6C6B3FBD4A73EB5B0B0107BA78062F37B130094446AD920617D835CCE94D81232F324D296DBEDA932BD90D9ECCA2BAFAC3FE51B6EB8A152A954ABD5D87B04149BDF9B00A024520E0989C99336FBBEB0D9FEF5F65738FB6EA7F951BDEF96866F7EF39B975C7249F6BC666666BCF20004E1F726002883D48241C2F2A4CDBEB7BB7D37CF633BDE2EC98B9CEF7BDFFBEA6933F68E00E9F07B1300242FCD6C90A4EDBFB6D97E9F5A88B499F60B9B75EBEBEBD953F3061E40407E6F0280E4A5990D92345090EB7DE7BEAF6DE649AD1D7F50AA69B396F4530362F17B1300A44D035D18A15EDBECF167FB0FF2DA66DDC6C6C6FCFCBC37F000C2F27B1300A42DCD6C90A4EDBFB6D9FE8264B79728FBFED0965FC4DDDA4E16451632AFBBEEBA2FDF76DB9E3D7B044E20AC242F9B005067912B8CBEBF1CDB5BCB3D6BDD5FB7CCF3433BC6D4245FDBAC47CD07BFFDD099B3E7B23F054E609BAAD5EAF2F2F2810307666767F7FCC2CCCC4CF695C5C5C5F5F5F5D83B0800C1A4960D12363939E91D0B47AC396AD687C0096C591632B384D9F71F07A7A7A76FBDF556177C0012206D1646A552595B5B8BBD1725D21E35054E606B56565676EFDEDD376736CBAEF9DEA81680A293360B637A7AFAD8B163B1F7A22CBA454D81131848B55A9D9F9F6F7FF5F2777FF7F70E1FBEE3AEBBBFD11837DDF4D9BD7BF7B6DC737676D6A50680E292360B238B372B2B2BB1F7A2147A474D8113C8697D7DBDE525CD4F7FFA779E3C71A2C7B5E5F9175EFCE22DB7ECDCB9B3F9454EFFD4084041499B85313F3FBFB8B8187B2FD297276A0A9C405F6B6B6B59506C84C6999999DE39B32573DE74D3671B8F9D9C9C3C7AF468EC2704000393360B238B9A59E08CBD1789CB1F35054EA0876AB5DAFCAAE6E76EBE39E755A579DC7EFBFFCC7266E3154E6F570B40E1489B85B1BABA3A3535157B2F523668D41438816EE6E6E61A51F3F0E13BB610351B57981D3B76D4B7935D6A623F2D00188CB45924DE286878B61635054EA0DDF2F2F2365FD56C1E777EF56B8DAD1D3A7428F693038001489B4592F51937DE7863ECBD48507BD4CCDABB6BAE99EAF69FAC9E7FE1C55DBB767DF9B6DB044EA0DDF4F474E3FF6A6E336AD647E3FF70EEDCB9D3E770025020D26691644D86FFBA135CC7A859FFBF52575F5D690F9CF5A859EFFC044EA0C5D2D252E3AD7D9E79F6B92069F3E593A71AEF52EBDF1C01281069B360565656FCD79D807A44CDBA96C0D91C35054EA05D7611687CD84990A8591FD9A5A6BED91D3B76C47E8A009097B4593C070E1CF06FDB41B447CDE61710DA03677BD46C7FF942E08432CBCEFDC6C521D40B9B8D915D8BEA5BF6D9CB001485B459480B0B0B33333322CD76747B5BA0E677806C0E9C0F3DFC70C7A879E757BFD6BE05811312B6B4B4B4B6B6D6F15B8B8B8BF58B437611081B35B3F1894F7CB2BEF16C0918ED3306802D92368BEAC89123954AE5C08103FE1BE716F47E07DA8E81F3D24B2FCD1335054E48DBE38F3F5EBF025C7EF9E5870F1F6EF9EEFEFDFBEBDFDDFE5BD1B68FBBEEFE467DE3BB77EF8EF2DC016050D266816561264B9B59E69C9999C96EF8DDAA9CF27CD849C7C099336A0A9C90B06AB5FAA637BDA97E1DB8E4924BDEF5AE7735BFCE995D8DEBDFEA7D7DD8DA78F2C489FAC6B3CB7EBC09008001489B8597B53E478E1CC9D266E3AD29E821FFE76AF6089C7DA3A6C009096BF9DFDD6F79CB5B3EF6B18FD53F98A4F1D9275BFBF0DEBEA3F14363CF0100E462C5A25CB2A879D7DDDFC8D9D8FDE5CA5F5D7CF1C52D51F3A28B2EBAEDB63FC9FF9B6F7B36854CCCC0B86A04D16E9FD6BBCDD1D87EEC4B2900E462C5A25C8E1D3B9605CEE75F78B16F57D7F11D68EB3A7E0E67C72D643933FB89B19F3463AA2533F48E103903468FBBD5BFD552CCF9F69437B8E28A2B1A1338BB293BD3575757B36F4D4D4DD5BFFED8F1E3C3489B8DCF678A3D0700908B158BD2C913387B44CD9C8153D4A4AFDE69B3EFCB68ED0FE9BD9DF6EF0A2D5BD0F88C932C587EFCE31FCFFE5C5A5A6A7CB7F18B0CF97F8722FFC8AE2AF58DFBC84D008A42AB4119F50E9C1DA3E645175D943F708A9AF4D51CFF3A26C96EF7EFF8F51E89B4FDC7F5DD263D3CFDF4D3939393333333954A656161A1E53F66CFCFCFD767FE8BB7DC123C6D3E76FC787DE3D3D3D3B19E3E000C44AB4149750B9C1DA366D65CFED17FF942C7CFE16C0F9CA2267DE5CC7EDD3264EFE4D9F727F6DD0EBD2D2F2F2F2E2E76FCC8CD83070FD62776DFBE8F064F9B9FBBF9E6FAC6E7E6E646FEA401602BB41A94577BE0EC1635EBEF40DBF15D6A5B02A7A8491E1DC35EC7B4D9F776B72F768C97DBDC6DFA5A5D5DAD4F7576AD78F9E4A9B06933BB5ED5379E65DDD84F140072D17C506AED8173DFBE8F768C9AF5D11E38F7EEDDDBE829454D06D2F7F5C6BEB7BB6DA1C7A6BADD81502A954A7D6E0F1FBE2360D46C7CD8E6C4E62739C57E9600908B5683B2EB11383B7EAE6673E01435D9B23C49AF5B86EC9642BBFD88811EC5362D2C2CD4677BD7AE5D015FDEFCC0073F58DFECECEC6CECA70800796938A073E0EC18359B03A7A8C996B5E4C6BEAF37E67929B2B1A95AA7DFAA6DF9BAB4393C1B1B1B8D4FC5FCDCCD3707899AF7DC7B5FA3065C670028100D075CD01E38B348D9A3F97BECF8715193507ABFEAD82346E6B95B7BCEEC9D6CD9BE43870E357E3F62FB1F85F2E489138DF8BA7FFFFED84F0E0006A0D5809FCBF3399CED43D464CBDA5F72AC757A59B2DB8D8E5FEF9D39BBFD95E076EFDE5D3FBE5950ECFDD9BCBDC7CB274F35DEBA2CDBD4FAFA7AEC67060003D070C0DF1A34708A9A6C4DFBFFA26C7FBDB1FD3EED0FEF9645A5CDE8D6D6D61AFFC13B4B89BD7F57A2DB78E6D9E71A5173727272656525F6D30280C16838E00DF2074E5193507AFF266DEFAF777B78C7B03AD1C936779E6EB270D898E42C2B7EF1965B06FDBF9A8D5FA0CD1C3A7428F613028081E933A0559EC0296A027D2D2F2F377F66D2AE5DBBBABDF758CB4B9A1FBEE186E67F11103501282869133AE81D38454D20A7D5D5D5A9A9A9E6E89865CE9B6EFAEC63C78FB787CC2FDE72CBDEBD7B9BEF9C8555BF400B4071499BD059B7C0296A0203D9D8D83870E0C0E4E464C7DF64BEF6DA6BBB7D6B6E6ECEDB02015068D22674D51E38454D606BB2DC383F3FDF3155B6CBAE33478F1E8DBDCB00B05DD226F4D21C38454D609BAAD5EAD2D252163BA7A7A75B1266A552999D9DBDF5D65BBD9E094032A44DE8A31E389F3C7142D4040080FCA44DE82F0B99954A45D4040080FCA44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C2933601000008EFFF0320016C4A104809070000000049454E44AE426082, '0');
  
  -- ----------------------------
  -- Table structure for `act_ge_property`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_ge_property`;
  CREATE TABLE `act_ge_property` (
    `NAME_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
    `REV_` int(11) DEFAULT NULL,
    PRIMARY KEY (`NAME_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_ge_property
  -- ----------------------------
  INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', '1');
  INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(5.13) upgrade(5.13->5.14)', '2');
  INSERT INTO `act_ge_property` VALUES ('schema.version', '5.14', '2');
  
  -- ----------------------------
  -- Table structure for `act_hi_actinst`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_hi_actinst`;
  CREATE TABLE `act_hi_actinst` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
    `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
    `ASSIGNEE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `START_TIME_` datetime NOT NULL,
    `END_TIME_` datetime DEFAULT NULL,
    `DURATION_` bigint(20) DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
    KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
    KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
    KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_hi_actinst
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_hi_attachment`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_hi_attachment`;
  CREATE TABLE `act_hi_attachment` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `REV_` int(11) DEFAULT NULL,
    `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_hi_attachment
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_hi_comment`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_hi_comment`;
  CREATE TABLE `act_hi_comment` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `TIME_` datetime NOT NULL,
    `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `FULL_MSG_` longblob,
    PRIMARY KEY (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_hi_comment
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_hi_detail`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_hi_detail`;
  CREATE TABLE `act_hi_detail` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
    `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `REV_` int(11) DEFAULT NULL,
    `TIME_` datetime NOT NULL,
    `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `DOUBLE_` double DEFAULT NULL,
    `LONG_` bigint(20) DEFAULT NULL,
    `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
    KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
    KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
    KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
    KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_hi_detail
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_hi_identitylink`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_hi_identitylink`;
  CREATE TABLE `act_hi_identitylink` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
    KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
    KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_hi_identitylink
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_hi_procinst`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_hi_procinst`;
  CREATE TABLE `act_hi_procinst` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `START_TIME_` datetime NOT NULL,
    `END_TIME_` datetime DEFAULT NULL,
    `DURATION_` bigint(20) DEFAULT NULL,
    `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
    UNIQUE KEY `ACT_UNIQ_HI_BUS_KEY` (`PROC_DEF_ID_`,`BUSINESS_KEY_`),
    KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
    KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_hi_procinst
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_hi_taskinst`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_hi_taskinst`;
  CREATE TABLE `act_hi_taskinst` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `START_TIME_` datetime NOT NULL,
    `CLAIM_TIME_` datetime DEFAULT NULL,
    `END_TIME_` datetime DEFAULT NULL,
    `DURATION_` bigint(20) DEFAULT NULL,
    `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `PRIORITY_` int(11) DEFAULT NULL,
    `DUE_DATE_` datetime DEFAULT NULL,
    `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_hi_taskinst
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_hi_varinst`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_hi_varinst`;
  CREATE TABLE `act_hi_varinst` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
    `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
    `REV_` int(11) DEFAULT NULL,
    `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `DOUBLE_` double DEFAULT NULL,
    `LONG_` bigint(20) DEFAULT NULL,
    `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
    KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_hi_varinst
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_id_group`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_id_group`;
  CREATE TABLE `act_id_group` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `REV_` int(11) DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_id_group
  -- ----------------------------
  INSERT INTO `act_id_group` VALUES ('oa:leave:deptLeaderAudit', '1', '71', null);
  INSERT INTO `act_id_group` VALUES ('oa:leave:hrAudit', '1', '72', null);
  
  -- ----------------------------
  -- Table structure for `act_id_info`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_id_info`;
  CREATE TABLE `act_id_info` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `REV_` int(11) DEFAULT NULL,
    `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `PASSWORD_` longblob,
    `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_id_info
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_id_membership`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_id_membership`;
  CREATE TABLE `act_id_membership` (
    `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
    KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
    CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`),
    CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_id_membership
  -- ----------------------------
  INSERT INTO `act_id_membership` VALUES ('1', 'oa:leave:deptLeaderAudit');
  INSERT INTO `act_id_membership` VALUES ('1', 'oa:leave:hrAudit');
  
  -- ----------------------------
  -- Table structure for `act_id_user`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_id_user`;
  CREATE TABLE `act_id_user` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `REV_` int(11) DEFAULT NULL,
    `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_id_user
  -- ----------------------------
  INSERT INTO `act_id_user` VALUES ('1', '1', null, null, null, null, null);
  
  -- ----------------------------
  -- Table structure for `act_re_deployment`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_re_deployment`;
  CREATE TABLE `act_re_deployment` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `DEPLOY_TIME_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_re_deployment
  -- ----------------------------
  INSERT INTO `act_re_deployment` VALUES ('1', 'SpringAutoDeployment', null, '2014-05-01 11:30:20');
  INSERT INTO `act_re_deployment` VALUES ('a080cf2e82604c21b400cc96f7a68205', 'SpringAutoDeployment', null, '2014-05-01 11:49:41');
  
  -- ----------------------------
  -- Table structure for `act_re_model`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_re_model`;
  CREATE TABLE `act_re_model` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `REV_` int(11) DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `CREATE_TIME_` timestamp NULL DEFAULT NULL,
    `LAST_UPDATE_TIME_` timestamp NULL DEFAULT NULL,
    `VERSION_` int(11) DEFAULT NULL,
    `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
    KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
    KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
    CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`),
    CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
    CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_re_model
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_re_procdef`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_re_procdef`;
  CREATE TABLE `act_re_procdef` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `REV_` int(11) DEFAULT NULL,
    `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `KEY_` varchar(255) COLLATE utf8_bin NOT NULL,
    `VERSION_` int(11) NOT NULL,
    `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
    `SUSPENSION_STATE_` int(11) DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_re_procdef
  -- ----------------------------
  INSERT INTO `act_re_procdef` VALUES ('leave:1:7147b4af92874814b781d7a3165e37d2', '1', 'com.thinkgem.jeesite.modules.oa.leave', '请假流程', 'leave', '1', 'a080cf2e82604c21b400cc96f7a68205', 'leave.bpmn20.xml', 'leave.png', '请假流程演示', '0', '1');
  
  -- ----------------------------
  -- Table structure for `act_ru_event_subscr`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_ru_event_subscr`;
  CREATE TABLE `act_ru_event_subscr` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `REV_` int(11) DEFAULT NULL,
    `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
    `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `CREATED_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`ID_`),
    KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
    KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
    CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_ru_event_subscr
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_ru_execution`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_ru_execution`;
  CREATE TABLE `act_ru_execution` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `REV_` int(11) DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `IS_ACTIVE_` tinyint(4) DEFAULT NULL,
    `IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
    `IS_SCOPE_` tinyint(4) DEFAULT NULL,
    `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
    `SUSPENSION_STATE_` int(11) DEFAULT NULL,
    `CACHED_ENT_STATE_` int(11) DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    UNIQUE KEY `ACT_UNIQ_RU_BUS_KEY` (`PROC_DEF_ID_`,`BUSINESS_KEY_`),
    KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
    KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
    KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
    KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
    CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`),
    CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
    CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_ru_execution
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_ru_identitylink`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_ru_identitylink`;
  CREATE TABLE `act_ru_identitylink` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `REV_` int(11) DEFAULT NULL,
    `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
    KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
    KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
    KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
    KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
    CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
    CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`),
    CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_ru_identitylink
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_ru_job`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_ru_job`;
  CREATE TABLE `act_ru_job` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `REV_` int(11) DEFAULT NULL,
    `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
    `LOCK_EXP_TIME_` timestamp NULL DEFAULT NULL,
    `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
    `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `RETRIES_` int(11) DEFAULT NULL,
    `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `DUEDATE_` timestamp NULL DEFAULT NULL,
    `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
    CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_ru_job
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_ru_task`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_ru_task`;
  CREATE TABLE `act_ru_task` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `REV_` int(11) DEFAULT NULL,
    `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PRIORITY_` int(11) DEFAULT NULL,
    `CREATE_TIME_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `DUE_DATE_` datetime DEFAULT NULL,
    `SUSPENSION_STATE_` int(11) DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
    KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
    KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
    KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
    CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
    CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
    CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_ru_task
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `act_ru_variable`
  -- ----------------------------
  DROP TABLE IF EXISTS `act_ru_variable`;
  CREATE TABLE `act_ru_variable` (
    `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
    `REV_` int(11) DEFAULT NULL,
    `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
    `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
    `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    `DOUBLE_` double DEFAULT NULL,
    `LONG_` bigint(20) DEFAULT NULL,
    `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`ID_`),
    KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
    KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
    KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
    KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
    CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
    CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
    CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of act_ru_variable
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `cms_article`
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_article`;
  CREATE TABLE `cms_article` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `category_id` bigint(20) NOT NULL COMMENT '栏目编号',
    `title` varchar(255) NOT NULL COMMENT '标题',
    `link` varchar(255) DEFAULT NULL COMMENT '文章链接',
    `color` varchar(50) DEFAULT NULL COMMENT '标题颜色',
    `image` varchar(255) DEFAULT NULL COMMENT '文章图片',
    `keywords` varchar(255) DEFAULT NULL COMMENT '关键字',
    `description` varchar(255) DEFAULT NULL COMMENT '描述、摘要',
    `weight` int(11) DEFAULT '0' COMMENT '权重，越大越靠前',
    `weight_date` datetime DEFAULT NULL COMMENT '权重期限',
    `hits` int(11) DEFAULT '0' COMMENT '点击数',
    `posid` varchar(10) DEFAULT NULL COMMENT '推荐位，多选',
    `custom_content_view` varchar(255) DEFAULT NULL COMMENT '自定义内容视图',
    `view_config` text COMMENT '视图配置',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `cms_article_create_by` (`create_by`),
    KEY `cms_article_title` (`title`),
    KEY `cms_article_keywords` (`keywords`),
    KEY `cms_article_del_flag` (`del_flag`),
    KEY `cms_article_weight` (`weight`),
    KEY `cms_article_update_date` (`update_date`),
    KEY `cms_article_category_id` (`category_id`),
    KEY `cms_article_id` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='文章表';
  
  -- ----------------------------
  -- Records of cms_article
  -- ----------------------------
  INSERT INTO `cms_article` VALUES ('1', '3', '文章标题标题标题标题', null, 'green', null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('2', '3', '文章标题标题标题标题', null, 'red', null, '关键字1,关键字2', null, '0', null, '1', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('3', '3', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('4', '3', '文章标题标题标题标题', null, 'green', null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('5', '3', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('6', '3', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('7', '4', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('8', '4', '文章标题标题标题标题', null, 'blue', null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('9', '4', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('10', '4', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('11', '5', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('12', '5', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('13', '5', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('14', '7', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('15', '7', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('16', '7', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('17', '7', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('18', '8', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('19', '8', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('20', '8', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('21', '8', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('22', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('23', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('24', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('25', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('26', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('27', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('28', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('29', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('30', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('31', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('32', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('33', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('34', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('35', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('36', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('37', '13', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('38', '13', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('39', '13', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('40', '13', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('41', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('42', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('43', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('44', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('45', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('46', '15', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('47', '15', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('48', '15', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('49', '16', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('50', '17', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('51', '17', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('52', '26', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_article` VALUES ('53', '26', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  
  -- ----------------------------
  -- Table structure for `cms_article_data`
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_article_data`;
  CREATE TABLE `cms_article_data` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `content` text COMMENT '文章内容',
    `copyfrom` varchar(255) DEFAULT NULL COMMENT '文章来源',
    `relation` varchar(255) DEFAULT NULL COMMENT '相关文章',
    `allow_comment` char(1) DEFAULT NULL COMMENT '是否允许评论',
    PRIMARY KEY (`id`),
    KEY `cms_article_data_id` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='文章详表';
  
  -- ----------------------------
  -- Records of cms_article_data
  -- ----------------------------
  INSERT INTO `cms_article_data` VALUES ('1', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('2', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('3', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('4', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('5', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('6', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('7', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('8', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('9', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('10', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('11', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('12', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('13', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('14', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('15', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('16', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('17', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('18', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('19', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('20', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('21', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('22', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('23', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('24', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('25', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('26', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('27', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('28', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('29', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('30', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('31', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('32', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('33', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('34', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('35', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('36', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('37', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('38', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('39', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('40', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('41', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('42', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('43', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('44', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('45', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('46', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('47', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('48', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('49', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('50', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('51', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('52', '文章内容内容内容内容', '来源', '1,2,3', '1');
  INSERT INTO `cms_article_data` VALUES ('53', '文章内容内容内容内容', '来源', '1,2,3', '1');
  
  -- ----------------------------
  -- Table structure for `cms_category`
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_category`;
  CREATE TABLE `cms_category` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `site_id` bigint(20) DEFAULT '1' COMMENT '站点编号',
    `office_id` bigint(20) DEFAULT NULL COMMENT '归属机构',
    `parent_id` bigint(64) NOT NULL COMMENT '父级编号',
    `parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号',
    `module` varchar(20) DEFAULT NULL COMMENT '栏目模块',
    `name` varchar(100) NOT NULL COMMENT '栏目名称',
    `image` varchar(255) DEFAULT NULL COMMENT '栏目图片',
    `href` varchar(255) DEFAULT NULL COMMENT '链接',
    `target` varchar(20) DEFAULT NULL COMMENT '目标',
    `description` varchar(255) DEFAULT NULL COMMENT '描述',
    `keywords` varchar(255) DEFAULT NULL COMMENT '关键字',
    `sort` int(11) DEFAULT '30' COMMENT '排序（升序）',
    `in_menu` char(1) DEFAULT '1' COMMENT '是否在导航中显示',
    `in_list` char(1) DEFAULT '1' COMMENT '是否在分类页中显示列表',
    `show_modes` char(1) DEFAULT '0' COMMENT '展现方式',
    `allow_comment` char(1) DEFAULT NULL COMMENT '是否允许评论',
    `is_audit` char(1) DEFAULT NULL COMMENT '是否需要审核',
    `custom_list_view` varchar(255) DEFAULT NULL COMMENT '自定义列表视图',
    `custom_content_view` varchar(255) DEFAULT NULL COMMENT '自定义内容视图',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `view_config` text COMMENT '视图配置',
    PRIMARY KEY (`id`),
    KEY `cms_category_parent_id` (`parent_id`),
    KEY `cms_category_module` (`module`),
    KEY `cms_category_name` (`name`),
    KEY `cms_category_sort` (`sort`),
    KEY `cms_category_del_flag` (`del_flag`),
    KEY `cms_category_office_id` (`office_id`),
    KEY `cms_category_site_id` (`site_id`),
    KEY `cms_category_id` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='栏目表';
  
  -- ----------------------------
  -- Records of cms_category
  -- ----------------------------
  INSERT INTO `cms_category` VALUES ('1', '0', '1', '0', '0,', null, '顶级栏目', null, null, null, null, null, '0', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('2', '1', '3', '1', '0,1,', 'article', '组织机构', null, null, null, null, null, '10', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('3', '1', '3', '2', '0,1,2,', 'article', '网站简介', null, null, null, null, null, '30', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('4', '1', '3', '2', '0,1,2,', 'article', '内部机构', null, null, null, null, null, '40', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('5', '1', '3', '2', '0,1,2,', 'article', '地方机构', null, null, null, null, null, '50', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('6', '1', '3', '1', '0,1,', 'article', '质量检验', null, null, null, null, null, '20', '1', '1', '1', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('7', '1', '3', '6', '0,1,6,', 'article', '产品质量', null, null, null, null, null, '30', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('8', '1', '3', '6', '0,1,6,', 'article', '技术质量', null, null, null, null, null, '40', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('9', '1', '3', '6', '0,1,6,', 'article', '工程质量', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('10', '1', '4', '1', '0,1,', 'article', '软件介绍', null, null, null, null, null, '20', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('11', '1', '4', '10', '0,1,10,', 'article', '网络工具', null, null, null, null, null, '30', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('12', '1', '4', '10', '0,1,10,', 'article', '浏览工具', null, null, null, null, null, '40', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('13', '1', '4', '10', '0,1,10,', 'article', '浏览辅助', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('14', '1', '4', '10', '0,1,10,', 'article', '网络优化', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('15', '1', '4', '10', '0,1,10,', 'article', '邮件处理', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('16', '1', '4', '10', '0,1,10,', 'article', '下载工具', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('17', '1', '4', '10', '0,1,10,', 'article', '搜索工具', null, null, null, null, null, '50', '1', '1', '2', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('18', '1', '5', '1', '0,1,', 'link', '友情链接', null, null, null, null, null, '90', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('19', '1', '5', '18', '0,1,18,', 'link', '常用网站', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('20', '1', '5', '18', '0,1,18,', 'link', '门户网站', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('21', '1', '5', '18', '0,1,18,', 'link', '购物网站', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('22', '1', '5', '18', '0,1,18,', 'link', '交友社区', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('23', '1', '5', '18', '0,1,18,', 'link', '音乐视频', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('24', '1', '6', '1', '0,1,', null, '百度一下', null, 'http://www.baidu.com', '_blank', null, null, '90', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('25', '1', '6', '1', '0,1,', null, '全文检索', null, '/search', null, null, null, '90', '0', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('26', '2', '6', '1', '0,1,', 'article', '测试栏目', null, null, null, null, null, '90', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('27', '1', '6', '1', '0,1,', null, '公共留言', null, '/guestbook', null, null, null, '90', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
  INSERT INTO `cms_category` VALUES ('28', '1', '1', '1', '0,1,', 'article', '1111', '', '111111', '111111', '', '', '30', '0', '1', '0', '0', '0', '', '', '1', '2014-05-19 10:15:53', '1', '2014-05-19 10:15:53', null, '0', '');
  INSERT INTO `cms_category` VALUES ('29', '1', '1', '28', '0,1,28,', 'link', '222', '', '', '', '', '', '30', '0', '1', '0', '0', '0', '', '', '1', '2014-05-19 10:16:58', '1', '2014-05-19 10:18:48', null, '0', '');
  
  -- ----------------------------
  -- Table structure for `cms_comment`
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_comment`;
  CREATE TABLE `cms_comment` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `category_id` bigint(20) NOT NULL COMMENT '栏目编号',
    `content_id` bigint(20) NOT NULL COMMENT '栏目内容的编号',
    `title` varchar(255) DEFAULT NULL COMMENT '栏目内容的标题',
    `content` varchar(255) DEFAULT NULL COMMENT '评论内容',
    `name` varchar(100) DEFAULT NULL COMMENT '评论姓名',
    `ip` varchar(100) DEFAULT NULL COMMENT '评论IP',
    `create_date` datetime NOT NULL COMMENT '评论时间',
    `audit_user_id` bigint(64) DEFAULT NULL COMMENT '审核人',
    `audit_date` datetime DEFAULT NULL COMMENT '审核时间',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `cms_comment_category_id` (`category_id`),
    KEY `cms_comment_content_id` (`content_id`),
    KEY `cms_comment_status` (`del_flag`),
    KEY `cms_comment_id` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评论表';
  
  -- ----------------------------
  -- Records of cms_comment
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `cms_guestbook`
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_guestbook`;
  CREATE TABLE `cms_guestbook` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `type` char(1) NOT NULL COMMENT '留言分类',
    `content` varchar(255) NOT NULL COMMENT '留言内容',
    `name` varchar(100) NOT NULL COMMENT '姓名',
    `email` varchar(100) NOT NULL COMMENT '邮箱',
    `phone` varchar(100) NOT NULL COMMENT '电话',
    `workunit` varchar(100) NOT NULL COMMENT '单位',
    `ip` varchar(100) NOT NULL COMMENT 'IP',
    `create_date` datetime NOT NULL COMMENT '留言时间',
    `re_user_id` bigint(20) DEFAULT NULL COMMENT '回复人',
    `re_date` datetime DEFAULT NULL COMMENT '回复时间',
    `re_content` varchar(100) DEFAULT NULL COMMENT '回复内容',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `cms_guestbook_del_flag` (`del_flag`),
    KEY `cms_site_id` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='留言板';
  
  -- ----------------------------
  -- Records of cms_guestbook
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `cms_link`
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_link`;
  CREATE TABLE `cms_link` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `category_id` bigint(20) NOT NULL COMMENT '栏目编号',
    `title` varchar(255) NOT NULL COMMENT '链接名称',
    `color` varchar(50) DEFAULT NULL COMMENT '标题颜色',
    `image` varchar(255) DEFAULT NULL COMMENT '链接图片',
    `href` varchar(255) DEFAULT NULL COMMENT '链接地址',
    `weight` int(11) DEFAULT '0' COMMENT '权重，越大越靠前',
    `weight_date` datetime DEFAULT NULL COMMENT '权重期限',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `cms_link_category_id` (`category_id`),
    KEY `cms_link_title` (`title`),
    KEY `cms_link_del_flag` (`del_flag`),
    KEY `cms_link_weight` (`weight`),
    KEY `cms_link_create_by` (`create_by`),
    KEY `cms_link_update_date` (`update_date`),
    KEY `cms_link_id` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='友情链接';
  
  -- ----------------------------
  -- Records of cms_link
  -- ----------------------------
  INSERT INTO `cms_link` VALUES ('1', '19', 'JeeSite', null, null, 'http://thinkgem.github.com/jeesite', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('2', '19', 'ThinkGem', null, null, 'http://thinkgem.iteye.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('3', '19', '百度一下', null, null, 'http://www.baidu.com', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('4', '19', '谷歌搜索', null, null, 'http://www.google.com', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('5', '20', '新浪网', null, null, 'http://www.sina.com.cn', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('6', '20', '腾讯网', null, null, 'http://www.qq.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('7', '21', '淘宝网', null, null, 'http://www.taobao.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('8', '21', '新华网', null, null, 'http://www.xinhuanet.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('9', '22', '赶集网', null, null, 'http://www.ganji.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('10', '22', '58同城', null, null, 'http://www.58.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('11', '23', '视频大全', null, null, 'http://v.360.cn/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('12', '23', '凤凰网', null, null, 'http://www.ifeng.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_link` VALUES ('13', '29', '1111', 'red', '', '/pms/paymentBefor', '0', '2014-05-08 00:00:00', '1', '2014-05-19 10:19:06', '1', '2014-05-20 15:46:41', '', '0');
  
  -- ----------------------------
  -- Table structure for `cms_site`
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_site`;
  CREATE TABLE `cms_site` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `name` varchar(100) NOT NULL COMMENT '站点名称',
    `title` varchar(100) NOT NULL COMMENT '站点标题',
    `logo` varchar(255) DEFAULT NULL COMMENT '站点Logo',
    `domain` varchar(255) DEFAULT NULL COMMENT '站点域名',
    `description` varchar(255) DEFAULT NULL COMMENT '描述',
    `keywords` varchar(255) DEFAULT NULL COMMENT '关键字',
    `theme` varchar(255) DEFAULT 'default' COMMENT '主题',
    `copyright` text COMMENT '版权信息',
    `custom_index_view` varchar(255) DEFAULT NULL COMMENT '自定义站点首页视图',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `cms_site_del_flag` (`del_flag`),
    KEY `cms_site_id` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='站点表';
  
  -- ----------------------------
  -- Records of cms_site
  -- ----------------------------
  INSERT INTO `cms_site` VALUES ('1', '默认站点', 'JeeSite Web', null, null, 'JeeSite', 'JeeSite', 'basic', 'Copyright &copy; 2012-2013 <a href=\'http://thinkgem.iteye.com\' target=\'_blank\'>ThinkGem</a> - Powered By <a href=\'https://github.com/thinkgem/jeesite\' target=\'_blank\'>JeeSite</a> V1.0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `cms_site` VALUES ('2', '子站点测试', 'JeeSite Subsite', null, null, 'JeeSite subsite', 'JeeSite subsite', 'basic', 'Copyright &copy; 2012-2013 <a href=\'http://thinkgem.iteye.com\' target=\'_blank\'>ThinkGem</a> - Powered By <a href=\'https://github.com/thinkgem/jeesite\' target=\'_blank\'>JeeSite</a> V1.0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  
  -- ----------------------------
  -- Table structure for `oa_leave`
  -- ----------------------------
  DROP TABLE IF EXISTS `oa_leave`;
  CREATE TABLE `oa_leave` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `process_instance_id` bigint(20) DEFAULT NULL COMMENT '流程实例编号',
    `start_time` datetime DEFAULT NULL COMMENT '开始时间',
    `end_time` datetime DEFAULT NULL COMMENT '结束时间',
    `leave_type` varchar(20) DEFAULT NULL COMMENT '请假类型',
    `reason` varchar(255) DEFAULT NULL COMMENT '请假理由',
    `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
    `reality_start_time` datetime DEFAULT NULL COMMENT '实际开始时间',
    `reality_end_time` datetime DEFAULT NULL COMMENT '实际结束时间',
    `process_status` varchar(50) DEFAULT NULL COMMENT '流程状态',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `oa_leave_create_by` (`create_by`),
    KEY `oa_leave_process_instance_id` (`process_instance_id`),
    KEY `oa_leave_del_flag` (`del_flag`),
    KEY `oa_leave_id` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='请假流程表';
  
  -- ----------------------------
  -- Records of oa_leave
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_buildings`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_buildings`;
  CREATE TABLE `pms_buildings` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `community_id` bigint(20) NOT NULL COMMENT '所属小区',
    `name` varchar(100) NOT NULL COMMENT '名称',
    `code` varchar(100) DEFAULT NULL COMMENT '编号',
    `build_area` decimal(10,2) NOT NULL COMMENT '建筑面积',
    `use_area` decimal(10,2) NOT NULL COMMENT '使用面积',
    `floor_count` int(11) NOT NULL DEFAULT '0' COMMENT '楼层数',
    `cap_date` datetime DEFAULT NULL COMMENT '封顶日期',
    `completion_date` datetime DEFAULT NULL COMMENT '竣工日期 ',
    `presale_permit` varchar(100) DEFAULT NULL COMMENT '预售许可证',
    `build_permit` varchar(100) DEFAULT NULL COMMENT '建筑许可证',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_buildings_community_id` (`community_id`),
    KEY `pms_buildings_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='楼宇信息表';
  
  -- ----------------------------
  -- Records of pms_buildings
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_community`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_community`;
  CREATE TABLE `pms_community` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `pro_company_id` bigint(20) NOT NULL COMMENT '物业公司',
    `dep_company_id` bigint(20) DEFAULT NULL COMMENT '开发商信息',
    `name` varchar(100) NOT NULL COMMENT '名称',
    `code` varchar(100) DEFAULT NULL COMMENT '编号',
    `total_area` decimal(10,2) DEFAULT '0.00' COMMENT '占地面积',
    `build_area` decimal(10,2) DEFAULT '0.00' COMMENT '建筑面积',
    `green_area` decimal(10,2) DEFAULT '0.00' COMMENT '绿地面积',
    `road_area` decimal(10,2) DEFAULT '0.00' COMMENT '道路面积',
    `build_count` int(11) DEFAULT '0' COMMENT '楼宇数量',
    `charge_person` varchar(100) DEFAULT NULL COMMENT '负责人',
    `address` varchar(200) DEFAULT NULL COMMENT '住宅地址',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_community_pro_ompany_id` (`pro_company_id`),
    KEY `pms_community_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='小区信息表';
  
  -- ----------------------------
  -- Records of pms_community
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_device`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_device`;
  CREATE TABLE `pms_device` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `parent_id` bigint(20) DEFAULT NULL COMMENT '父级编号',
    `parent_ids` varchar(2000) DEFAULT NULL COMMENT '所有父级编号',
    `code` varchar(100) DEFAULT NULL COMMENT '编号  私有表=房号+收费编号  公表自定义、固话号码',
    `type` char(1) DEFAULT NULL COMMENT '1 公摊  2、单位 3、个人',
    `first_num` decimal(10,2) DEFAULT NULL COMMENT '上次读数',
    `last_num` decimal(10,2) DEFAULT NULL COMMENT '本次读数',
    `first_date` datetime DEFAULT NULL COMMENT '上次日期',
    `last_date` datetime DEFAULT NULL COMMENT '本次日期',
    `payment_date` datetime DEFAULT NULL COMMENT '交费限期',
    `pool_usage_amount` decimal(10,2) DEFAULT NULL COMMENT '本次公摊用量',
    `usage_amount` decimal(10,2) DEFAULT NULL COMMENT '本次读数',
    `arrears` decimal(10,2) DEFAULT NULL COMMENT '本次读数',
    `apportion_house_count` int(11) DEFAULT NULL COMMENT '分摊户数  公表记录',
    `apportion_company_count` int(11) DEFAULT NULL COMMENT '分摊公司  公表记录',
    `sort` int(11) DEFAULT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `company_id` bigint(20) DEFAULT NULL,
    `fees_id` bigint(20) DEFAULT NULL,
    `name` varchar(200) DEFAULT NULL,
    `pool` char(1) NOT NULL DEFAULT '1' COMMENT '是否公摊',
    `enable` char(1) NOT NULL DEFAULT '1' COMMENT '是否启用',
    `house_id` bigint(20) DEFAULT NULL,
    `unit_price` double NOT NULL DEFAULT '0' COMMENT '单价',
    PRIMARY KEY (`id`),
    KEY `pms_device_type` (`type`),
    KEY `pms_device_code` (`code`),
    KEY `pms_device_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='计费设备表';
  
  -- ----------------------------
  -- Records of pms_device
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_device_detail`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_device_detail`;
  CREATE TABLE `pms_device_detail` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `device_id` bigint(20) DEFAULT NULL COMMENT '设备编号',
    `parent_id` bigint(20) DEFAULT NULL COMMENT '父级编号',
    `first_num` decimal(10,2) DEFAULT NULL COMMENT '上次读数',
    `last_num` decimal(10,2) DEFAULT NULL COMMENT '本次读数',
    `first_date` datetime DEFAULT NULL COMMENT '上次日期',
    `last_date` datetime DEFAULT NULL COMMENT '本次日期',
    `payment_date` datetime DEFAULT NULL COMMENT '交费限期',
    `fees_mode` char(1) DEFAULT NULL COMMENT '公摊方法',
    `unit_price` double NOT NULL DEFAULT '0' COMMENT '单价',
    `usage_amount` decimal(10,2) DEFAULT NULL COMMENT '本次读数',
    `pool_usage_amount` decimal(10,2) DEFAULT NULL COMMENT '本次公摊用量',
    `pay_money` decimal(10,2) DEFAULT NULL COMMENT '费用金额',
    `favour_money` decimal(10,2) DEFAULT NULL COMMENT '优惠金额',
    `pool_pay_money` decimal(10,2) DEFAULT NULL COMMENT '本次公摊金额',
    `sum_usage_amount` decimal(10,2) DEFAULT NULL COMMENT '总用量',
    `sum_pay_money` decimal(10,2) DEFAULT NULL COMMENT '总费用金额',
    `income_money` decimal(10,2) DEFAULT NULL COMMENT '收款金额',
    `arrears` decimal(10,2) DEFAULT NULL COMMENT '本次读数',
    `apportion_house_count` int(11) DEFAULT NULL COMMENT '分摊户数  公表记录',
    `apportion_company_count` int(11) DEFAULT NULL COMMENT '分摊公司  公表记录',
    `is_pay` char(1) DEFAULT NULL COMMENT '是否已付款',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `fees_params` varchar(20) DEFAULT NULL COMMENT '费用参数，来源于费用的 Remarks，目前取暖费按面积的90%收取',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `sort` int(11) DEFAULT NULL COMMENT '排序（升序）',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `pool_id` bigint(20) DEFAULT '0' COMMENT '公摊编号',
    PRIMARY KEY (`id`),
    KEY `pms_device_del_flag` (`del_flag`),
    KEY `pms_device_detail_device_id` (`device_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='计费设备表';
  
  -- ----------------------------
  -- Records of pms_device_detail
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_device_detail_payment`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_device_detail_payment`;
  CREATE TABLE `pms_device_detail_payment` (
    `payemt_id` bigint(20) NOT NULL COMMENT '用户编号',
    `device_detail_id` bigint(20) NOT NULL COMMENT '角色编号',
    PRIMARY KEY (`payemt_id`,`device_detail_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户-角色';
  
  -- ----------------------------
  -- Records of pms_device_detail_payment
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_fees`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_fees`;
  CREATE TABLE `pms_fees` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `company_id` bigint(20) NOT NULL COMMENT '归属公司',
    `parent_id` bigint(20) DEFAULT NULL COMMENT '关联费项',
    `name` varchar(100) NOT NULL COMMENT '费项名称',
    `code` varchar(100) DEFAULT NULL COMMENT '费项编号',
    `fees_type` char(1) DEFAULT NULL COMMENT '收费方式',
    `fees_mode` char(1) DEFAULT NULL COMMENT '收费方式',
    `spe_month` int(11) DEFAULT NULL COMMENT '收费间隔月份',
    `unit_price` double NOT NULL DEFAULT '0' COMMENT '单位价格',
    `is_enable_mod_price` char(1) DEFAULT NULL COMMENT '允许【生成物业费】时直接修改此费项单价',
    `remind_type` char(1) DEFAULT NULL COMMENT '提醒业主方式 短信、电话、邮件',
    `remind_days` int(11) DEFAULT NULL COMMENT '从费用到期前 天开始提醒',
    `is_ladder` char(1) DEFAULT NULL COMMENT '按单价收费  按阶梯收费',
    `ladder_rules` bigint(20) DEFAULT NULL COMMENT '阶梯规则编号',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_fees_company_id` (`company_id`),
    KEY `pms_fees_parent_id` (`parent_id`),
    KEY `pms_fees_del_flag` (`del_flag`)
  ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='收费项目表';
  
  -- ----------------------------
  -- Records of pms_fees
  -- ----------------------------
  INSERT INTO `pms_fees` VALUES ('1', '1', null, '卫生费', 'A01', '1', '1', '1', '30', null, '0', null, '0', null, '30', '1', '2014-04-17 18:55:15', '1', '2015-08-17 16:26:17', '', '0');
  INSERT INTO `pms_fees` VALUES ('2', '1', null, '水费', 'A03', '1', '4', '1', '0.63', null, '0', null, '0', null, '30', '1', '2014-04-17 19:20:13', '1', '2015-08-17 16:26:23', '', '0');
  INSERT INTO `pms_fees` VALUES ('3', '1', null, '物业管理', 'A02', '1', '2', '1', '2.3', null, '0', null, '0', null, '30', '1', '2014-04-17 19:18:42', '1', '2015-08-17 16:26:20', '', '0');
  INSERT INTO `pms_fees` VALUES ('4', '1', null, '电话费', 'A05', '1', '4', '1', '1', null, '0', null, '0', null, '30', '1', '2014-05-09 12:50:39', '1', '2015-08-17 16:26:26', '', '0');
  INSERT INTO `pms_fees` VALUES ('5', '1', null, '取暖费', 'A04', '1', '5', '12', '22.8', null, '0', null, '0', null, '30', '1', '2014-05-11 20:27:36', '1', '2015-08-11 15:51:37', '1.0', '0');
  INSERT INTO `pms_fees` VALUES ('6', '1', null, '电费', 'A06', '1', '4', '1', '0.568', null, '0', null, '0', null, '30', '1', '2014-05-13 16:33:24', '1', '2014-09-23 15:18:54', '', '0');
  INSERT INTO `pms_fees` VALUES ('7', '1', null, '天然气费', 'A07', '1', '4', '1', '2.3', null, '0', null, '0', null, '30', '1', '2014-05-13 16:35:58', '1', '2015-08-17 16:26:29', '', '0');
  INSERT INTO `pms_fees` VALUES ('17', '250', null, '卫生费', 'A01', '1', '1', '1', '30', null, '0', null, '0', null, '30', '1', '2015-08-07 03:22:06', '1', '2015-08-17 16:26:45', '', '0');
  INSERT INTO `pms_fees` VALUES ('18', '250', null, '物业管理', 'A02', '1', '2', '1', '2.3', null, '0', null, '0', null, '30', '1', '2015-08-07 03:22:08', '1', '2015-08-07 03:22:08', '', '0');
  INSERT INTO `pms_fees` VALUES ('19', '250', null, '水费', 'A03', '1', '4', '1', '0.63', null, '0', null, '0', null, '30', '1', '2015-08-07 03:22:10', '1', '2015-08-07 03:22:10', '', '0');
  INSERT INTO `pms_fees` VALUES ('20', '250', null, '取暖费', 'A04', '1', '6', '12', '22.8', null, '0', null, '0', null, '30', '1', '2015-08-07 03:22:11', '1', '2015-08-07 03:22:11', '0.9', '0');
  INSERT INTO `pms_fees` VALUES ('21', '250', null, '电话费', 'A05', '1', '5', '1', '1', null, '0', null, '0', null, '30', '1', '2015-08-07 03:22:12', '1', '2015-08-07 03:22:12', '', '0');
  INSERT INTO `pms_fees` VALUES ('22', '250', null, '电费', 'A06', '1', '4', '1', '0.568', null, '0', null, '0', null, '30', '1', '2015-08-07 03:22:13', '1', '2015-08-07 03:22:13', '', '0');
  INSERT INTO `pms_fees` VALUES ('24', '250', null, '天然气费', 'A07', '1', '4', '1', '2.3', null, '0', null, '0', null, '30', '1', '2015-08-07 10:15:12', '1', '2015-08-07 10:15:12', '', '0');
  
  -- ----------------------------
  -- Table structure for `pms_house`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_house`;
  CREATE TABLE `pms_house` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `unit_id` bigint(20) NOT NULL COMMENT '所属单元',
    `name` varchar(100) NOT NULL COMMENT '名称',
    `code` varchar(100) DEFAULT NULL COMMENT '编号',
    `num_floor` varchar(10) DEFAULT NULL COMMENT '第几层',
    `build_area` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '建筑面积',
    `use_area` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '使用面积',
    `ext_area` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '扩建面积',
    `apartment` char(1) DEFAULT NULL COMMENT '户型 ',
    `face` char(1) DEFAULT NULL COMMENT '朝向 ',
    `funct` char(1) DEFAULT NULL COMMENT '功能 ',
    `is_sell` char(1) DEFAULT NULL COMMENT '已售 ',
    `is_rent` char(1) DEFAULT NULL COMMENT '已租 ',
    `user_id` bigint(20) DEFAULT NULL COMMENT '业主',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_house_unit_id` (`unit_id`),
    KEY `pms_house_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房屋信息表';
  
  -- ----------------------------
  -- Records of pms_house
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_payment_after`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_payment_after`;
  CREATE TABLE `pms_payment_after` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `device_detail_id` bigint(20) NOT NULL DEFAULT '0',
    `fee_code` varchar(100) NOT NULL COMMENT '收款单号',
    `cert_code` varchar(100) NOT NULL COMMENT '收款单号',
    `feed_name` varchar(100) DEFAULT NULL,
    `rece_date` datetime DEFAULT NULL COMMENT '收款日期',
    `cost_money` decimal(10,2) NOT NULL COMMENT '应付金额',
    `rec_money` decimal(10,2) NOT NULL COMMENT '应付金额',
    `pay_type` char(1) DEFAULT NULL COMMENT ' 收款方式  现金 支票',
    `type` char(1) NOT NULL DEFAULT '1' COMMENT '1现付 2 预付 ',
    `collect_id` bigint(20) NOT NULL COMMENT '收款人',
    `house_id` bigint(20) NOT NULL,
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_payment_after_rece_date` (`rece_date`),
    KEY `pms_payment_after_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='已收款表';
  
  -- ----------------------------
  -- Records of pms_payment_after
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_payment_befor`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_payment_befor`;
  CREATE TABLE `pms_payment_befor` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `name` varchar(100) NOT NULL COMMENT '名称',
    `rece_date` datetime DEFAULT NULL COMMENT '生成日期',
    `fees_id` bigint(20) NOT NULL COMMENT '费用编号',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_payment_befor_fees_id` (`fees_id`),
    KEY `pms_payment_befor_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='应收款表';
  
  -- ----------------------------
  -- Records of pms_payment_befor
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_payment_detail`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_payment_detail`;
  CREATE TABLE `pms_payment_detail` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `payment_before_id` bigint(20) DEFAULT NULL COMMENT '收款凭证',
    `payment_after_id` bigint(20) DEFAULT NULL COMMENT '付款凭证',
    `device_id` bigint(20) NOT NULL COMMENT '设备编号',
    `house_id` bigint(20) DEFAULT NULL,
    `unit_price` double NOT NULL DEFAULT '0' COMMENT '单价',
    `first_num` decimal(10,2) DEFAULT NULL COMMENT '上次读数',
    `last_num` decimal(10,2) DEFAULT NULL COMMENT '本次读数',
    `first_date` datetime DEFAULT NULL COMMENT '上次日期',
    `last_date` datetime DEFAULT NULL COMMENT '本次日期',
    `payment_date` datetime DEFAULT NULL COMMENT '交费限期',
    `pool_usage_amount` decimal(10,2) DEFAULT NULL COMMENT '本次公摊用量',
    `pay_money` decimal(10,2) DEFAULT NULL COMMENT '费用金额',
    `pool_pay_money` decimal(10,2) DEFAULT NULL COMMENT '本次公摊金额',
    `usage_amount` decimal(10,2) DEFAULT NULL COMMENT '本次读数',
    `sum_usage_amount` decimal(10,2) DEFAULT NULL COMMENT '总用量',
    `cost_money` decimal(10,2) DEFAULT NULL COMMENT '总费用金额',
    `income_money` decimal(10,2) DEFAULT NULL COMMENT '收款金额',
    `favour_money` decimal(10,2) DEFAULT NULL COMMENT '优惠金额',
    `is_pay` char(1) DEFAULT NULL COMMENT '是否已付款',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_payment_detail_device_id` (`device_id`),
    KEY `pms_payment_detail_is_pay` (`is_pay`),
    KEY `pms_payment_detail_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='计费设备表';
  
  -- ----------------------------
  -- Records of pms_payment_detail
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_payment_pre`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_payment_pre`;
  CREATE TABLE `pms_payment_pre` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `type` char(1) DEFAULT NULL COMMENT ' 1 个人  2、公司 ',
    `name` varchar(100) NOT NULL COMMENT '名称',
    `code` varchar(100) NOT NULL COMMENT '凭证号',
    `user` varchar(20) NOT NULL COMMENT '经手人',
    `money` decimal(10,2) NOT NULL COMMENT '金额',
    `rece_date` datetime DEFAULT NULL COMMENT '收款日期',
    `fees_id` bigint(20) NOT NULL COMMENT '费用',
    `house_id` bigint(20) NOT NULL COMMENT '房产',
    `company_id` bigint(20) NOT NULL COMMENT '公司',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(64) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_payment_pre_device_id` (`rece_date`),
    KEY `pms_payment_pre_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预收款表';
  
  -- ----------------------------
  -- Records of pms_payment_pre
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `pms_unit`
  -- ----------------------------
  DROP TABLE IF EXISTS `pms_unit`;
  CREATE TABLE `pms_unit` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `buildings_id` bigint(20) NOT NULL COMMENT '所属楼宇',
    `name` varchar(100) NOT NULL COMMENT '名称',
    `code` varchar(100) DEFAULT NULL COMMENT '编号',
    `start_floor` int(11) NOT NULL COMMENT '开始楼层',
    `end_floor` int(11) NOT NULL COMMENT '结束楼层',
    `start_room` int(11) NOT NULL COMMENT '开始房号',
    `end_room` int(11) NOT NULL COMMENT '结束房号',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `pms_unit_buildings_id` (`buildings_id`),
    KEY `pms_unit_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='单元信息表';
  
  -- ----------------------------
  -- Records of pms_unit
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `prj_project`
  -- ----------------------------
  DROP TABLE IF EXISTS `prj_project`;
  CREATE TABLE `prj_project` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `name` varchar(255) DEFAULT NULL COMMENT '名称',
    `root_package` varchar(255) DEFAULT NULL COMMENT '包名',
    `erm_path` varchar(2000) DEFAULT NULL COMMENT '数据文件路径',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL COMMENT '删除标志',
    PRIMARY KEY (`id`),
    KEY `prj_project_id` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='项目';
  
  -- ----------------------------
  -- Records of prj_project
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `sys_area`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_area`;
  CREATE TABLE `sys_area` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `parent_id` bigint(20) NOT NULL COMMENT '父级编号',
    `parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号',
    `code` varchar(100) DEFAULT NULL COMMENT '区域编码',
    `name` varchar(100) NOT NULL COMMENT '区域名称',
    `type` char(1) DEFAULT NULL COMMENT '区域类型',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `sys_area_parent_id` (`parent_id`),
    KEY `sys_area_del_flag` (`del_flag`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='区域表';
  
  -- ----------------------------
  -- Records of sys_area
  -- ----------------------------
  INSERT INTO `sys_area` VALUES ('1', '0', '0,', '100000', '中国', '1', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_area` VALUES ('2', '1', '0,1,', '', '河南', '2', '1', '2014-04-29 15:06:01', '1', '2014-04-29 15:06:01', '', '0');
  INSERT INTO `sys_area` VALUES ('3', '2', '0,1,2,', '', '郑州', '2', '1', '2014-04-29 15:06:40', '1', '2014-04-29 15:06:40', '', '0');
  
  -- ----------------------------
  -- Table structure for `sys_dict`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_dict`;
  CREATE TABLE `sys_dict` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `label` varchar(100) NOT NULL COMMENT '标签名',
    `value` varchar(100) NOT NULL COMMENT '数据值',
    `type` varchar(100) NOT NULL COMMENT '类型',
    `description` varchar(100) NOT NULL COMMENT '描述',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `sys_dict_value` (`value`),
    KEY `sys_dict_label` (`label`),
    KEY `sys_dict_del_flag` (`del_flag`)
  ) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 COMMENT='字典表';
  
  -- ----------------------------
  -- Records of sys_dict
  -- ----------------------------
  INSERT INTO `sys_dict` VALUES ('1', '正常', '0', 'del_flag', 'SYS-删除标记', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('2', '删除', '1', 'del_flag', 'SYS-删除标记', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('3', '显示', '1', 'show_hide', 'SYS-显示/隐藏', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('4', '隐藏', '0', 'show_hide', 'SYS-显示/隐藏', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('5', '是', '1', 'yes_no', 'SYS-是/否', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('6', '否', '0', 'yes_no', 'SYS-是/否', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('7', '红色', 'red', 'color', 'SYS-颜色值', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('8', '绿色', 'green', 'color', 'SYS-颜色值', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('9', '蓝色', 'blue', 'color', 'SYS-颜色值', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('10', '黄色', 'yellow', 'color', 'SYS-颜色值', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('11', '橙色', 'orange', 'color', 'SYS-颜色值', '50', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('12', '默认主题', 'default', 'theme', 'SYS-主题方案', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('13', '天蓝主题', 'cerulean', 'theme', 'SYS-主题方案', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('14', '橙色主题', 'readable', 'theme', 'SYS-主题方案', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('15', '红色主题', 'united', 'theme', 'SYS-主题方案', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('16', 'Flat主题', 'flat', 'theme', 'SYS-主题方案', '60', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('17', '国家', '1', 'sys_area_type', 'SYS-区域类型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('18', '省份、直辖市', '2', 'sys_area_type', 'SYS-区域类型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('19', '地市', '3', 'sys_area_type', 'SYS-区域类型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('20', '区县', '4', 'sys_area_type', 'SYS-区域类型', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('21', '公司', '1', 'sys_office_type', 'SYS-机构类型', '60', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('22', '部门', '2', 'sys_office_type', 'SYS-机构类型', '70', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('23', '一级', '1', 'sys_office_grade', 'SYS-机构等级', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('24', '二级', '2', 'sys_office_grade', 'SYS-机构等级', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('25', '三级', '3', 'sys_office_grade', 'SYS-机构等级', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('26', '四级', '4', 'sys_office_grade', 'SYS-机构等级', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('27', '所有数据', '1', 'sys_data_scope', 'SYS-数据范围', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('28', '所在公司及以下数据', '2', 'sys_data_scope', 'SYS-数据范围', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('29', '所在公司数据', '3', 'sys_data_scope', 'SYS-数据范围', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('30', '所在部门及以下数据', '4', 'sys_data_scope', 'SYS-数据范围', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('31', '所在部门数据', '5', 'sys_data_scope', 'SYS-数据范围', '50', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('32', '仅本人数据', '8', 'sys_data_scope', 'SYS-数据范围', '90', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('33', '按明细设置', '9', 'sys_data_scope', 'SYS-数据范围', '100', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('34', '系统用户', '1', 'sys_user_type', 'SYS-用户类型', '10', '1', '2013-05-27 08:00:00', '1', '2014-04-18 01:08:36', null, '0');
  INSERT INTO `sys_dict` VALUES ('35', '住户', '2', 'sys_user_type', 'SYS-用户类型', '20', '1', '2013-05-27 08:00:00', '1', '2014-04-18 01:09:50', null, '0');
  INSERT INTO `sys_dict` VALUES ('36', '法人', '3', 'sys_user_type', 'SYS-用户类型', '30', '1', '2013-05-27 08:00:00', '1', '2014-05-14 19:15:11', null, '0');
  INSERT INTO `sys_dict` VALUES ('37', '基础主题', 'basic', 'cms_theme', 'SYS-站点主题', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('38', '蓝色主题', 'blue', 'cms_theme', 'SYS-站点主题', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
  INSERT INTO `sys_dict` VALUES ('39', '红色主题', 'red', 'cms_theme', 'SYS-站点主题', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
  INSERT INTO `sys_dict` VALUES ('40', '文章模型', 'article', 'cms_module', 'CMS-栏目模型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('41', '图片模型', 'picture', 'cms_module', 'CMS-栏目模型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
  INSERT INTO `sys_dict` VALUES ('42', '下载模型', 'download', 'cms_module', 'CMS-栏目模型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
  INSERT INTO `sys_dict` VALUES ('43', '链接模型', 'link', 'cms_module', 'CMS-栏目模型', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('44', '专题模型', 'special', 'cms_module', 'CMS-栏目模型', '50', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
  INSERT INTO `sys_dict` VALUES ('45', '默认展现方式', '0', 'cms_show_modes', 'CMS-展现方式', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('46', '首栏目内容列表', '1', 'cms_show_modes', 'CMS-展现方式', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('47', '栏目第一条内容', '2', 'cms_show_modes', 'CMS-展现方式', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('48', '发布', '0', 'cms_del_flag', 'CMS-内容状态', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('49', '删除', '1', 'cms_del_flag', 'CMS-内容状态', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('50', '审核', '2', 'cms_del_flag', 'CMS-内容状态', '15', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('51', '首页焦点图', '1', 'cms_posid', 'CMS-推荐位', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('52', '栏目页文章推荐', '2', 'cms_posid', 'CMS-推荐位', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('53', '咨询', '1', 'cms_guestbook', 'CMS-留言板分类', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('54', '建议', '2', 'cms_guestbook', 'CMS-留言板分类', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('55', '投诉', '3', 'cms_guestbook', 'CMS-留言板分类', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('56', '其它', '4', 'cms_guestbook', 'CMS-留言板分类', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('57', '公休', '1', 'oa_leave_type', 'OA-请假类型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('58', '病假', '2', 'oa_leave_type', 'OA-请假类型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('59', '事假', '3', 'oa_leave_type', 'OA-请假类型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('60', '调休', '4', 'oa_leave_type', 'OA-请假类型', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('61', '婚假', '5', 'oa_leave_type', 'OA-请假类型', '60', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('62', '接入日志', '1', 'sys_log_type', 'SYS-日志类型', '30', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('63', '异常日志', '2', 'sys_log_type', 'SYS-日志类型', '40', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('64', '单表增删改查', 'single', 'prj_template_type', 'PRJ-代码模板', '10', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('65', '所有entity和dao', 'entityAndDao', 'prj_template_type', 'PRJ-代码模板', '20', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
  INSERT INTO `sys_dict` VALUES ('100', '公摊', '1', 'pms_device_type', 'PMS-设备类型', '10', '1', '2014-04-23 13:36:42', '1', '2014-06-25 10:44:11', null, '0');
  INSERT INTO `sys_dict` VALUES ('101', '3', '3', 'pms_spe_month', 'PMS-收费周期', '3', '1', '2014-04-17 19:46:50', '1', '2014-04-17 19:47:08', null, '0');
  INSERT INTO `sys_dict` VALUES ('102', '1', '1', 'pms_spe_month', 'PMS-收费周期', '1', '1', '2014-04-17 19:45:16', '1', '2014-04-17 19:46:57', null, '0');
  INSERT INTO `sys_dict` VALUES ('103', '车库', '4', 'pms_house_funct', 'PMS-房间功能', '40', '1', '2014-04-19 22:17:19', '1', '2014-04-23 13:11:31', null, '0');
  INSERT INTO `sys_dict` VALUES ('104', '2', '2', 'pms_spe_month', 'PMS-收费周期', '2', '1', '2014-04-17 19:46:12', '1', '2014-04-17 19:47:04', null, '0');
  INSERT INTO `sys_dict` VALUES ('105', '个人', '3', 'pms_device_type', 'PMS-设备类型', '30', '1', '2014-04-23 15:36:38', '1', '2014-06-25 10:44:31', null, '0');
  INSERT INTO `sys_dict` VALUES ('106', '仓库', '3', 'pms_house_funct', 'PMS-房间功能', '30', '1', '2014-04-19 22:17:06', '1', '2014-04-23 13:11:18', null, '0');
  INSERT INTO `sys_dict` VALUES ('107', '按加建面积', '3', 'pms_fees_mode', 'PMS-收费方式', '3', '2', '2014-04-16 18:40:09', '1', '2014-04-17 13:14:40', null, '0');
  INSERT INTO `sys_dict` VALUES ('108', '商业', '2', 'pms_house_funct', 'PMS-房间功能', '20', '1', '2014-04-19 22:16:53', '1', '2014-04-23 13:11:07', null, '0');
  INSERT INTO `sys_dict` VALUES ('109', '临时', '3', 'pms_fees_type', 'PMS-费项类型', '30', '1', '2014-04-17 23:35:43', '1', '2014-05-11 20:23:25', null, '0');
  INSERT INTO `sys_dict` VALUES ('110', '固定电话', '5', 'pms_device_type', 'PMS-设备类型', '30', '1', '2014-04-23 13:37:22', '1', '2014-04-23 15:37:40', null, '1');
  INSERT INTO `sys_dict` VALUES ('111', '按房屋使用面积', '5', 'pms_fees_mode', 'PMS-收费方式', '5', '1', '2014-04-17 13:12:44', '1', '2014-06-01 19:32:59', null, '0');
  INSERT INTO `sys_dict` VALUES ('112', '对公', '2', 'sys_office_sort', 'SYS-机构分类', '30', '1', '2014-04-29 16:24:23', '1', '2014-04-29 20:28:51', null, '1');
  INSERT INTO `sys_dict` VALUES ('113', '公摊设备', '4', 'pms_device_type', 'PMS-设备类型', '20', '1', '2014-04-23 13:36:59', '1', '2014-04-23 15:37:35', null, '1');
  INSERT INTO `sys_dict` VALUES ('114', '特殊', '2', 'pms_fees_type', 'PMS-费项类型', '20', '1', '2014-04-17 23:36:27', '1', '2014-05-11 20:23:10', null, '0');
  INSERT INTO `sys_dict` VALUES ('115', '按使用量', '4', 'pms_fees_mode', 'PMS-收费方式', '4', '1', '2014-04-17 13:12:12', '1', '2014-04-17 13:14:26', null, '0');
  INSERT INTO `sys_dict` VALUES ('116', '住宅', '1', 'pms_house_funct', 'PMS-房间功能', '10', '1', '2014-04-19 22:16:35', '1', '2014-05-13 08:24:53', null, '0');
  INSERT INTO `sys_dict` VALUES ('117', '按房屋建筑面积', '2', 'pms_fees_mode', 'PMS-收费方式', '2', '2', '2014-04-16 18:40:27', '1', '2014-04-17 13:14:20', null, '0');
  INSERT INTO `sys_dict` VALUES ('118', '物业公司', '1', 'sys_office_sort', 'SYS-机构分类', '10', '1', '2014-04-29 20:26:32', '1', '2014-04-29 20:28:37', null, '0');
  INSERT INTO `sys_dict` VALUES ('119', '住户表(汽表)', '3', 'pms_device_type', 'PMS-设备类型', '20', '1', '2014-04-23 15:37:10', '1', '2014-04-23 15:37:10', null, '1');
  INSERT INTO `sys_dict` VALUES ('120', '全部费项', '0', 'pms_fees_mode', 'PMS-收费方式', '0', '1', '2014-04-17 13:13:30', '1', '2014-04-17 13:13:51', null, '1');
  INSERT INTO `sys_dict` VALUES ('121', '第1单元', '1', 'pms_house_unit', 'PMS-房子单元', '10', '1', '2014-04-18 02:06:29', '1', '2014-04-18 02:07:18', null, '0');
  INSERT INTO `sys_dict` VALUES ('122', '内部单位', '2', 'sys_office_sort', 'SYS-机构分类', '20', '1', '2014-04-29 16:24:51', '1', '2014-05-11 21:58:44', null, '0');
  INSERT INTO `sys_dict` VALUES ('123', '第2单元', '2', 'pms_house_unit', 'PMS-房子单元', '20', '1', '2014-04-18 02:07:03', '1', '2014-04-18 02:08:03', null, '0');
  INSERT INTO `sys_dict` VALUES ('124', '按户', '1', 'pms_fees_mode', 'PMS-收费方式', '1', '2', '2014-04-16 18:39:24', '1', '2014-07-05 09:19:28', null, '0');
  INSERT INTO `sys_dict` VALUES ('125', '按房实收金额', '6', 'pms_fees_mode', 'PMS-收费方式', '10', '1', '2014-05-09 12:44:29', '1', '2015-08-24 23:06:21', null, '0');
  INSERT INTO `sys_dict` VALUES ('126', '单位', '2', 'pms_device_type', 'PMS-设备类型', '20', '1', '2014-05-09 16:55:23', '1', '2014-06-25 10:44:20', null, '0');
  INSERT INTO `sys_dict` VALUES ('127', '常规', '1', 'pms_fees_type', 'PMS-费项类型', '10', '1', '2014-05-09 17:23:58', '1', '2014-05-11 20:23:34', null, '0');
  INSERT INTO `sys_dict` VALUES ('128', '4', '4', 'pms_spe_month', 'PMS-收费周期', '4', '1', '2014-05-11 20:29:24', '1', '2014-05-11 20:31:42', null, '0');
  INSERT INTO `sys_dict` VALUES ('129', '5', '5', 'pms_spe_month', 'PMS-收费周期', '5', '1', '2014-05-11 20:29:29', '1', '2014-05-11 20:30:52', null, '0');
  INSERT INTO `sys_dict` VALUES ('130', '6', '6', 'pms_spe_month', 'PMS-收费周期', '6', '1', '2014-05-11 20:29:35', '1', '2014-05-11 20:31:01', null, '0');
  INSERT INTO `sys_dict` VALUES ('131', '7', '7', 'pms_spe_month', 'PMS-收费周期', '7', '1', '2014-05-11 20:29:39', '1', '2014-05-11 20:30:57', null, '0');
  INSERT INTO `sys_dict` VALUES ('132', '8', '8', 'pms_spe_month', 'PMS-收费周期', '8', '1', '2014-05-11 20:29:44', '1', '2014-05-11 20:31:10', null, '0');
  INSERT INTO `sys_dict` VALUES ('133', '9', '9', 'pms_spe_month', 'PMS-收费周期', '9', '1', '2014-05-11 20:29:48', '1', '2014-05-11 20:31:06', null, '0');
  INSERT INTO `sys_dict` VALUES ('134', '10', '10', 'pms_spe_month', 'PMS-收费周期', '10', '1', '2014-05-11 20:29:56', '1', '2014-05-11 20:31:19', null, '0');
  INSERT INTO `sys_dict` VALUES ('135', '11', '11', 'pms_spe_month', 'PMS-收费周期', '11', '1', '2014-05-11 20:30:00', '1', '2014-05-11 20:31:13', null, '0');
  INSERT INTO `sys_dict` VALUES ('136', '12', '12', 'pms_spe_month', 'PMS-收费周期', '12', '1', '2014-05-11 20:30:05', '1', '2014-05-11 20:31:27', null, '0');
  INSERT INTO `sys_dict` VALUES ('137', '外单位(租户)', '3', 'sys_office_sort', 'SYS-机构分类', '30', '1', '2014-05-11 21:59:07', '1', '2014-05-11 21:59:43', null, '0');
  INSERT INTO `sys_dict` VALUES ('138', '办公', '5', 'pms_house_funct', 'PMS-房间功能', '50', '1', '2014-05-13 09:35:07', '1', '2014-05-13 09:35:16', null, '0');
  INSERT INTO `sys_dict` VALUES ('139', '其它用户', '433', 'sys_user_type', 'SYS-用户类型', '40', '1', '2014-05-14 19:15:25', '1', '2014-05-14 19:15:25', null, '0');
  INSERT INTO `sys_dict` VALUES ('140', '现金', '1', 'pms_pay_type', 'PMS-付款方式', '10', '1', '2014-08-25 10:14:28', '1', '2014-08-25 10:14:28', null, '0');
  INSERT INTO `sys_dict` VALUES ('141', '转帐', '2', 'pms_pay_type', 'PMS-付款方式', '20', '1', '2014-08-25 10:15:21', '1', '2014-08-25 10:15:21', null, '0');
  INSERT INTO `sys_dict` VALUES ('142', '支票', '3', 'pms_pay_type', 'PMS-付款方式', '30', '1', '2014-08-25 10:15:34', '1', '2014-08-25 10:15:34', null, '0');
  INSERT INTO `sys_dict` VALUES ('143', '电汇', '4', 'pms_pay_type', 'PMS-付款方式', '40', '1', '2014-08-25 10:16:02', '1', '2014-08-25 10:16:42', null, '0');
  INSERT INTO `sys_dict` VALUES ('144', '承兑', '5', 'pms_pay_type', 'PMS-付款方式', '50', '1', '2014-08-25 10:16:24', '1', '2014-08-25 10:16:35', null, '0');
  INSERT INTO `sys_dict` VALUES ('145', '代扣', '6', 'pms_pay_type', 'PMS-付款方式', '60', '1', '2014-09-25 15:24:32', '1', '2014-09-25 15:24:32', null, '0');
  
  -- ----------------------------
  -- Table structure for `sys_log`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_log`;
  CREATE TABLE `sys_log` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `type` char(1) DEFAULT '1' COMMENT '日志类型',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `remote_addr` varchar(255) DEFAULT NULL COMMENT '操作IP地址',
    `user_agent` varchar(255) DEFAULT NULL COMMENT '用户代理',
    `request_uri` varchar(255) DEFAULT NULL COMMENT '请求URI',
    `method` varchar(5) DEFAULT NULL COMMENT '操作方式',
    `params` text COMMENT '操作提交的数据',
    `exception` text COMMENT '异常信息',
    PRIMARY KEY (`id`),
    KEY `sys_log_create_by` (`create_by`),
    KEY `sys_log_request_uri` (`request_uri`),
    KEY `sys_log_type` (`type`),
    KEY `sys_log_create_date` (`create_date`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日志表';
  
  -- ----------------------------
  -- Records of sys_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `sys_mdict`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_mdict`;
  CREATE TABLE `sys_mdict` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `parent_id` bigint(20) NOT NULL COMMENT '父级编号',
    `parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号',
    `name` varchar(100) NOT NULL COMMENT '角色名称',
    `description` varchar(100) DEFAULT NULL COMMENT '描述',
    `sort` int(11) DEFAULT NULL COMMENT '排序（升序）',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `sys_mdict_parent_id` (`parent_id`),
    KEY `sys_mdict_del_flag` (`del_flag`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='多级字典表';
  
  -- ----------------------------
  -- Records of sys_mdict
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `sys_menu`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_menu`;
  CREATE TABLE `sys_menu` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `parent_id` bigint(20) NOT NULL COMMENT '父级编号',
    `parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号',
    `name` varchar(100) NOT NULL COMMENT '菜单名称',
    `href` varchar(255) DEFAULT NULL COMMENT '链接',
    `target` varchar(20) DEFAULT NULL COMMENT '目标',
    `icon` varchar(100) DEFAULT NULL COMMENT '图标',
    `sort` int(11) NOT NULL COMMENT '排序（升序）',
    `is_show` char(1) NOT NULL COMMENT '是否在菜单中显示',
    `is_activiti` char(1) DEFAULT NULL COMMENT '是否同步工作流',
    `permission` varchar(200) DEFAULT NULL COMMENT '权限标识',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `sys_menu_parent_id` (`parent_id`),
    KEY `sys_menu_del_flag` (`del_flag`)
  ) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='菜单表';
  
  -- ----------------------------
  -- Records of sys_menu
  -- ----------------------------
  INSERT INTO `sys_menu` VALUES ('1', '0', '0,', '顶级菜单', null, null, null, '0', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
  INSERT INTO `sys_menu` VALUES ('2', '1', '0,1,', '系统设置', null, null, null, '900', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('3', '2', '0,1,2,', '系统设置', null, null, null, '980', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('4', '3', '0,1,2,3,', '菜单管理', '/sys/menu/', null, 'list-alt', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('5', '4', '0,1,2,3,4,', '查看', null, null, null, '30', '0', '0', 'sys:menu:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('6', '4', '0,1,2,3,4,', '修改', null, null, null, '30', '0', '0', 'sys:menu:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('7', '3', '0,1,2,3,', '角色管理', '/sys/role/', null, 'lock', '50', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('8', '7', '0,1,2,3,7,', '查看', null, null, null, '30', '0', '0', 'sys:role:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('9', '7', '0,1,2,3,7,', '修改', null, null, null, '30', '0', '0', 'sys:role:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('10', '3', '0,1,2,3,', '字典管理', '/sys/dict/', null, 'th-list', '60', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('11', '10', '0,1,2,3,10,', '查看', null, null, null, '30', '0', '0', 'sys:dict:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('12', '10', '0,1,2,3,10,', '修改', null, null, null, '30', '0', '0', 'sys:dict:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('13', '2', '0,1,2,', '机构用户', null, null, null, '970', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('14', '13', '0,1,2,13,', '区域管理', '/sys/area/', null, 'th', '50', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('15', '14', '0,1,2,13,14,', '查看', null, null, null, '30', '0', '0', 'sys:area:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('16', '14', '0,1,2,13,14,', '修改', null, null, null, '30', '0', '0', 'sys:area:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('17', '13', '0,1,2,13,', '机构管理', '/sys/office/', null, 'th-large', '40', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('18', '17', '0,1,2,13,17,', '查看', null, null, null, '30', '0', '0', 'sys:office:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('19', '17', '0,1,2,13,17,', '修改', null, null, null, '30', '0', '0', 'sys:office:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('20', '13', '0,1,2,13,', '用户管理', '/sys/user/', null, 'user', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('21', '20', '0,1,2,13,20,', '查看', null, null, null, '30', '0', '0', 'sys:user:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('22', '20', '0,1,2,13,20,', '修改', null, null, null, '30', '0', '0', 'sys:user:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('23', '2', '0,1,2,', '关于帮助', '', '', '', '990', '0', '0', '', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('24', '23', '0,1,2,23,', '项目首页', 'http://jeesite.com', '_blank', null, '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('25', '23', '0,1,2,23,', '项目支持', 'http://jeesite.com/donation.html', '_blank', null, '50', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('26', '23', '0,1,2,23,', '论坛交流', 'http://bbs.jeesite.com', '_blank', null, '80', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('27', '1', '0,1,', '我的面板', null, null, null, '100', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('28', '27', '0,1,27,', '个人信息', null, null, null, '990', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('29', '28', '0,1,27,28,', '个人信息', '/sys/user/info', null, 'user', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('30', '28', '0,1,27,28,', '修改密码', '/sys/user/modifyPwd', null, 'lock', '40', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('31', '1', '0,1,', '内容管理', '', '', '', '500', '1', '0', '', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('32', '31', '0,1,31,', '栏目设置', null, null, null, '990', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('33', '32', '0,1,31,32,', '栏目管理', '/cms/category/', null, 'align-justify', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('34', '33', '0,1,31,32,33,', '查看', null, null, null, '30', '0', '0', 'cms:category:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('35', '33', '0,1,31,32,33,', '修改', null, null, null, '30', '0', '0', 'cms:category:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('36', '32', '0,1,31,32,', '站点设置', '/cms/site/', null, 'certificate', '40', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('37', '36', '0,1,31,32,36,', '查看', null, null, null, '30', '0', '0', 'cms:site:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('38', '36', '0,1,31,32,36,', '修改', null, null, null, '30', '0', '0', 'cms:site:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('39', '32', '0,1,31,32,', '切换站点', '/cms/site/select', null, 'retweet', '50', '1', '0', 'cms:site:select', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('40', '31', '0,1,31,', '内容管理', null, null, null, '500', '1', '0', 'cms:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('41', '40', '0,1,31,40,', '内容发布', '/cms/', '', 'briefcase', '30', '1', '0', '', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('42', '41', '0,1,31,40,41,', '文章模型', '/cms/article/', '', 'file', '40', '1', '0', '', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('43', '42', '0,1,31,40,41,42,', '查看', null, null, null, '30', '0', '0', 'cms:article:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('44', '42', '0,1,31,40,41,42,', '修改', null, null, null, '30', '0', '0', 'cms:article:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('45', '42', '0,1,31,40,41,42,', '审核', null, null, null, '30', '0', '0', 'cms:article:audit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('46', '41', '0,1,31,40,41,', '链接模型', '/cms/link/', '', 'random', '60', '1', '0', '', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('47', '46', '0,1,31,40,41,46,', '查看', null, null, null, '30', '0', '0', 'cms:link:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('48', '46', '0,1,31,40,41,46,', '修改', null, null, null, '30', '0', '0', 'cms:link:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('49', '46', '0,1,31,40,41,46,', '审核', null, null, null, '30', '0', '0', 'cms:link:audit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('50', '40', '0,1,31,40,', '评论管理', '/cms/comment/?status=2', null, 'comment', '40', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('51', '50', '0,1,31,40,50,', '查看', null, null, null, '30', '0', '0', 'cms:comment:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('52', '50', '0,1,31,40,50,', '审核', null, null, null, '30', '0', '0', 'cms:comment:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('53', '40', '0,1,31,40,', '公共留言', '/cms/guestbook/?status=2', null, 'glass', '80', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('54', '53', '0,1,31,40,53,', '查看', null, null, null, '30', '0', '0', 'cms:guestbook:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('55', '53', '0,1,31,40,53,', '审核', null, null, null, '30', '0', '0', 'cms:guestbook:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('56', '40', '0,1,31,40,', '文件管理', '/../static/ckfinder/ckfinder.html', null, 'folder-open', '90', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('57', '56', '0,1,31,40,56,', '查看', null, null, null, '30', '0', '0', 'cms:ckfinder:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('58', '56', '0,1,31,40,56,', '上传', null, null, null, '30', '0', '0', 'cms:ckfinder:upload', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('59', '56', '0,1,31,40,56,', '修改', null, null, null, '30', '0', '0', 'cms:ckfinder:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('60', '31', '0,1,31,', '统计分析', null, null, null, '600', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('61', '60', '0,1,31,60,', '信息量统计', '/cms/stats/article', null, 'tasks', '30', '1', '0', 'cms:stats:article', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('62', '1', '0,1,', '在线办公', '', '', '', '200', '0', '0', '', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('63', '62', '0,1,62,', '个人办公', null, null, null, '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('64', '63', '0,1,62,63,', '请假办理', '/oa/leave', null, 'leaf', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('65', '64', '0,1,62,63,64,', '查看', null, null, null, '30', '0', '0', 'oa:leave:view', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('66', '64', '0,1,62,63,64,', '修改', null, null, null, '40', '0', '0', 'oa:leave:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('67', '2', '0,1,2,', '日志查询', null, null, null, '985', '1', '0', null, '1', '2013-06-03 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('68', '67', '0,1,2,67,', '日志查询', '/sys/log', null, 'pencil', '30', '1', '0', 'sys:log:view', '1', '2013-06-03 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('69', '2', '0,1,2,', '流程管理', null, null, null, '983', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('70', '69', '0,1,2,69,', '流程管理', '/sys/workflow/processList', null, 'road', '300', '1', '0', 'sys:workflow:edit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('71', '64', '0,1,62,63,64,', '部门领导审批', null, null, null, '50', '0', '1', 'oa:leave:deptLeaderAudit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('72', '64', '0,1,62,63,64,', '人事审批', null, null, null, '60', '0', '1', 'oa:leave:hrAudit', '1', '2013-05-27 08:00:00', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('73', '32', '0,1,31,32,', '模板管理', '/cms/template', null, 'pencil', '40', '1', '0', null, '1', '2013-12-12 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('74', '73', '0,1,31,32,73,', '查看', null, null, null, '30', '0', '0', 'cms:template:view', '1', '2013-12-12 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('75', '73', '0,1,31,32,73,', '修改', null, null, null, '30', '0', '0', 'cms:template:edit', '1', '2013-12-12 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('76', '1', '0,1,', '项目管理', '', '', '', '1000', '0', '1', '', '1', '2013-12-12 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('77', '76', '0,1,76,', '项目数据', null, null, null, '30', '1', '0', null, '1', '2013-12-12 08:00:00', '1', '2015-07-08 21:42:41', null, '0');
  INSERT INTO `sys_menu` VALUES ('78', '77', '0,1,76,77,', '项目管理', '/prj/project/', null, 'globe', '30', '1', '0', null, '1', '2013-12-12 08:00:00', '1', '2015-07-08 21:42:42', null, '0');
  INSERT INTO `sys_menu` VALUES ('79', '78', '0,1,76,77,78,', '查看', null, null, null, '30', '0', '0', 'prj:project:view', '1', '2013-12-12 08:00:00', '1', '2015-07-08 21:42:42', null, '0');
  INSERT INTO `sys_menu` VALUES ('80', '78', '0,1,76,77,78,', '修改', null, null, null, '40', '0', '0', 'prj:project:edit', '1', '2013-12-12 08:00:00', '1', '2015-07-08 21:42:42', null, '0');
  INSERT INTO `sys_menu` VALUES ('81', '1', '0,1,', '物业管理', '', '', '', '30', '1', '0', '', '1', '2014-05-01 22:16:50', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('82', '81', '0,1,81,', '收费管理', '', '', '', '1', '1', '0', '', '1', '2014-05-01 22:23:05', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('83', '82', '0,1,81,82,', '生成物业费', '/pms/build', '', 'book', '60', '0', '0', '', '1', '2014-05-01 22:24:08', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('84', '82', '0,1,81,82,', '台帐信息', '/pms/paymentBefor', '', 'book', '70', '0', '0', '', '1', '2014-05-01 22:25:03', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('85', '82', '0,1,81,82,', '收费管理', '/pms/payemtDetail/index', '', 'book', '80', '1', '0', '', '1', '2014-05-01 22:25:34', '1', '2015-08-07 16:38:46', null, '0');
  INSERT INTO `sys_menu` VALUES ('86', '82', '0,1,81,82,', '预付款管理', '/pms/paymentPre', '', 'book', '100', '0', '0', '', '1', '2014-05-01 22:26:13', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('87', '82', '0,1,81,82,', '收费项目', '/pms/fees', '', 'book', '10', '1', '0', '', '1', '2014-05-01 22:59:11', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('88', '81', '0,1,81,', '房产管理', '', '', '', '2', '1', '0', '', '1', '2014-05-01 23:23:09', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('89', '88', '0,1,81,88,', '小区信息', '/pms/community', '', 'home', '1', '1', '0', '', '1', '2014-05-01 23:23:51', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('90', '88', '0,1,81,88,', '楼宇信息', '/pms/buildings', '', 'home', '2', '1', '0', '', '1', '2014-05-01 23:24:52', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('91', '88', '0,1,81,88,', '单元信息', '/pms/unit', '', 'home', '3', '1', '0', '', '1', '2014-05-01 23:25:32', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('92', '88', '0,1,81,88,', '房屋信息', '/pms/house', '', 'home', '4', '1', '0', '', '1', '2014-05-01 23:26:58', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('93', '82', '0,1,81,82,', '计费设备', '/pms/device', '', 'time', '20', '1', '0', '', '1', '2014-05-01 23:28:04', '1', '2015-08-07 11:09:53', null, '0');
  INSERT INTO `sys_menu` VALUES ('94', '95', '0,1,81,95,', '业主信息', '/pms/user', '', 'user', '40', '1', '0', '', '1', '2014-05-01 23:29:11', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('95', '81', '0,1,81,', '组织机构', '', '', '', '3', '1', '0', '', '1', '2014-05-11 22:54:13', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('96', '95', '0,1,81,95,', '单位信息', '/pms/office', '', 'th', '30', '1', '0', '', '1', '2014-05-11 22:55:01', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('97', '82', '0,1,81,82,', '公摊分布', '/pms/pool', '', 'th', '200', '1', '0', '', '1', '2014-05-13 10:24:50', '1', '2015-08-08 16:50:07', null, '0');
  INSERT INTO `sys_menu` VALUES ('98', '82', '0,1,81,82,', '生成公摊费', '/pms/buildpool', '', 'road', '40', '0', '1', '', '1', '2014-05-13 13:59:10', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('99', '82', '0,1,81,82,', '生成缴费', '/pms/deviceBuild', '', 'th', '30', '0', '0', '', '1', '2014-05-20 11:08:46', '1', '2015-08-05 21:32:45', null, '0');
  INSERT INTO `sys_menu` VALUES ('100', '82', '0,1,81,82,', '缴费查询', '/pms/deviceDetail/index', '', 'th', '50', '0', '0', '', '1', '2014-05-25 14:00:55', '1', '2015-08-05 21:32:33', null, '0');
  INSERT INTO `sys_menu` VALUES ('101', '88', '0,1,81,88,', '办公场所', '/pms/houseoffice', '', 'road', '40', '0', '0', '', '1', '2014-06-20 15:03:20', '1', '2015-07-08 21:42:39', null, '0');
  INSERT INTO `sys_menu` VALUES ('102', '96', '0,1,81,95,96,', '查看', '', '', '', '30', '0', '0', 'pms:office:view', '1', '2015-07-08 17:21:51', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('103', '96', '0,1,81,95,96,', '修改', '', '', '', '30', '0', '0', 'pms:office:edit', '1', '2015-07-08 17:24:30', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('104', '94', '0,1,81,95,94,', '查看', '', '', '', '30', '0', '0', 'pms:user:view', '1', '2015-07-08 17:26:54', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('105', '94', '0,1,81,95,94,', '修改', '', '', '', '30', '0', '0', 'pms:user:edit', '1', '2015-07-08 17:27:09', '1', '2015-07-08 21:42:40', null, '0');
  INSERT INTO `sys_menu` VALUES ('106', '82', '0,1,81,82,', '抄表管理', '/pms/deviceDetail', '', 'file', '30', '1', '0', '', '1', '2015-07-16 15:17:36', '1', '2015-08-07 16:38:38', null, '0');
  INSERT INTO `sys_menu` VALUES ('107', '87', '0,1,81,82,87,', '查看', '', 'pms:fees:e', '', '30', '0', '0', 'pms:fees:view', '1', '2015-08-07 11:20:21', '1', '2015-08-07 11:21:47', null, '0');
  INSERT INTO `sys_menu` VALUES ('108', '87', '0,1,81,82,87,', '修改', '', '', '', '30', '0', '0', 'pms:fees:edit', '1', '2015-08-07 11:22:20', '1', '2015-08-07 11:22:20', null, '0');
  
  -- ----------------------------
  -- Table structure for `sys_office`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_office`;
  CREATE TABLE `sys_office` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `parent_id` bigint(20) NOT NULL COMMENT '父级编号',
    `parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号',
    `area_id` bigint(20) NOT NULL COMMENT '归属区域',
    `code` varchar(100) NOT NULL COMMENT '区域编码',
    `name` varchar(100) NOT NULL COMMENT '机构名称',
    `type` char(1) NOT NULL COMMENT '机构类型',
    `sort` char(1) NOT NULL COMMENT '机构分类',
    `grade` char(1) NOT NULL COMMENT '机构等级',
    `address` varchar(255) DEFAULT NULL COMMENT '联系地址',
    `zip_code` varchar(100) DEFAULT NULL COMMENT '邮政编码',
    `master` varchar(100) DEFAULT NULL COMMENT '负责人',
    `phone` varchar(200) DEFAULT NULL COMMENT '电话',
    `fax` varchar(200) DEFAULT NULL COMMENT '传真',
    `email` varchar(200) DEFAULT NULL COMMENT '邮箱',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `is_charge` char(1) DEFAULT '0' COMMENT '是否计费',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `sys_office_parent_id` (`parent_id`),
    KEY `sys_office_del_flag` (`del_flag`)
  ) ENGINE=InnoDB AUTO_INCREMENT=289 DEFAULT CHARSET=utf8 COMMENT='机构表';
  
  -- ----------------------------
  -- Records of sys_office
  -- ----------------------------
  INSERT INTO `sys_office` VALUES ('1', '0', '0,', '1', '100000', '河南广电局', '1', '0', '1', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, null, '0');
  
  -- ----------------------------
  -- Table structure for `sys_role`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role`;
  CREATE TABLE `sys_role` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `office_id` bigint(20) DEFAULT NULL COMMENT '归属机构',
    `name` varchar(100) NOT NULL COMMENT '角色名称',
    `data_scope` char(1) DEFAULT NULL COMMENT '数据范围',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`),
    KEY `sys_role_del_flag` (`del_flag`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='角色表';
  
  -- ----------------------------
  -- Records of sys_role
  -- ----------------------------
  INSERT INTO `sys_role` VALUES ('1', '1', '系统管理员', '1', '1', '2013-05-27 08:00:00', '1', '2015-08-07 11:23:08', null, '0');
  INSERT INTO `sys_role` VALUES ('2', '1', '公司管理员', '4', '1', '2013-05-27 08:00:00', '1', '2015-07-18 15:40:01', null, '0');
  INSERT INTO `sys_role` VALUES ('3', '1', '本公司管理员', '3', '1', '2013-05-27 08:00:00', '1', '2014-05-02 10:55:44', null, '0');
  INSERT INTO `sys_role` VALUES ('4', '1', '部门管理员', '4', '1', '2013-05-27 08:00:00', '1', '2014-05-02 10:55:11', null, '0');
  INSERT INTO `sys_role` VALUES ('5', '1', '本部门管理员', '5', '1', '2013-05-27 08:00:00', '1', '2014-05-02 10:55:27', null, '0');
  INSERT INTO `sys_role` VALUES ('6', '1', '业主', '8', '1', '2013-05-27 08:00:00', '1', '2014-05-02 11:03:40', null, '0');
  INSERT INTO `sys_role` VALUES ('7', '1', '单位', '2', '1', '2014-07-02 14:32:34', '1', '2014-07-02 14:33:27', null, '0');
  INSERT INTO `sys_role` VALUES ('8', '1', '普通住户', '9', '1', '2014-04-25 00:22:57', '1', '2014-05-09 21:31:43', null, '0');
  INSERT INTO `sys_role` VALUES ('9', '1', '公司法人', '9', '1', '2014-06-20 15:41:59', '1', '2014-06-20 15:41:59', null, '0');
  
  -- ----------------------------
  -- Table structure for `sys_role_menu`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role_menu`;
  CREATE TABLE `sys_role_menu` (
    `role_id` bigint(20) NOT NULL COMMENT '角色编号',
    `menu_id` bigint(20) NOT NULL COMMENT '菜单编号',
    PRIMARY KEY (`role_id`,`menu_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色-菜单';
  
  -- ----------------------------
  -- Records of sys_role_menu
  -- ----------------------------
  INSERT INTO `sys_role_menu` VALUES ('1', '1');
  INSERT INTO `sys_role_menu` VALUES ('1', '2');
  INSERT INTO `sys_role_menu` VALUES ('1', '3');
  INSERT INTO `sys_role_menu` VALUES ('1', '4');
  INSERT INTO `sys_role_menu` VALUES ('1', '5');
  INSERT INTO `sys_role_menu` VALUES ('1', '6');
  INSERT INTO `sys_role_menu` VALUES ('1', '7');
  INSERT INTO `sys_role_menu` VALUES ('1', '8');
  INSERT INTO `sys_role_menu` VALUES ('1', '9');
  INSERT INTO `sys_role_menu` VALUES ('1', '10');
  INSERT INTO `sys_role_menu` VALUES ('1', '11');
  INSERT INTO `sys_role_menu` VALUES ('1', '12');
  INSERT INTO `sys_role_menu` VALUES ('1', '13');
  INSERT INTO `sys_role_menu` VALUES ('1', '14');
  INSERT INTO `sys_role_menu` VALUES ('1', '15');
  INSERT INTO `sys_role_menu` VALUES ('1', '16');
  INSERT INTO `sys_role_menu` VALUES ('1', '17');
  INSERT INTO `sys_role_menu` VALUES ('1', '18');
  INSERT INTO `sys_role_menu` VALUES ('1', '19');
  INSERT INTO `sys_role_menu` VALUES ('1', '20');
  INSERT INTO `sys_role_menu` VALUES ('1', '21');
  INSERT INTO `sys_role_menu` VALUES ('1', '22');
  INSERT INTO `sys_role_menu` VALUES ('1', '23');
  INSERT INTO `sys_role_menu` VALUES ('1', '24');
  INSERT INTO `sys_role_menu` VALUES ('1', '25');
  INSERT INTO `sys_role_menu` VALUES ('1', '26');
  INSERT INTO `sys_role_menu` VALUES ('1', '27');
  INSERT INTO `sys_role_menu` VALUES ('1', '28');
  INSERT INTO `sys_role_menu` VALUES ('1', '29');
  INSERT INTO `sys_role_menu` VALUES ('1', '30');
  INSERT INTO `sys_role_menu` VALUES ('1', '31');
  INSERT INTO `sys_role_menu` VALUES ('1', '32');
  INSERT INTO `sys_role_menu` VALUES ('1', '33');
  INSERT INTO `sys_role_menu` VALUES ('1', '34');
  INSERT INTO `sys_role_menu` VALUES ('1', '35');
  INSERT INTO `sys_role_menu` VALUES ('1', '36');
  INSERT INTO `sys_role_menu` VALUES ('1', '37');
  INSERT INTO `sys_role_menu` VALUES ('1', '38');
  INSERT INTO `sys_role_menu` VALUES ('1', '39');
  INSERT INTO `sys_role_menu` VALUES ('1', '40');
  INSERT INTO `sys_role_menu` VALUES ('1', '41');
  INSERT INTO `sys_role_menu` VALUES ('1', '42');
  INSERT INTO `sys_role_menu` VALUES ('1', '43');
  INSERT INTO `sys_role_menu` VALUES ('1', '44');
  INSERT INTO `sys_role_menu` VALUES ('1', '45');
  INSERT INTO `sys_role_menu` VALUES ('1', '46');
  INSERT INTO `sys_role_menu` VALUES ('1', '47');
  INSERT INTO `sys_role_menu` VALUES ('1', '48');
  INSERT INTO `sys_role_menu` VALUES ('1', '49');
  INSERT INTO `sys_role_menu` VALUES ('1', '50');
  INSERT INTO `sys_role_menu` VALUES ('1', '51');
  INSERT INTO `sys_role_menu` VALUES ('1', '52');
  INSERT INTO `sys_role_menu` VALUES ('1', '53');
  INSERT INTO `sys_role_menu` VALUES ('1', '54');
  INSERT INTO `sys_role_menu` VALUES ('1', '55');
  INSERT INTO `sys_role_menu` VALUES ('1', '56');
  INSERT INTO `sys_role_menu` VALUES ('1', '57');
  INSERT INTO `sys_role_menu` VALUES ('1', '58');
  INSERT INTO `sys_role_menu` VALUES ('1', '59');
  INSERT INTO `sys_role_menu` VALUES ('1', '60');
  INSERT INTO `sys_role_menu` VALUES ('1', '61');
  INSERT INTO `sys_role_menu` VALUES ('1', '62');
  INSERT INTO `sys_role_menu` VALUES ('1', '63');
  INSERT INTO `sys_role_menu` VALUES ('1', '64');
  INSERT INTO `sys_role_menu` VALUES ('1', '65');
  INSERT INTO `sys_role_menu` VALUES ('1', '66');
  INSERT INTO `sys_role_menu` VALUES ('1', '67');
  INSERT INTO `sys_role_menu` VALUES ('1', '68');
  INSERT INTO `sys_role_menu` VALUES ('1', '69');
  INSERT INTO `sys_role_menu` VALUES ('1', '70');
  INSERT INTO `sys_role_menu` VALUES ('1', '71');
  INSERT INTO `sys_role_menu` VALUES ('1', '72');
  INSERT INTO `sys_role_menu` VALUES ('1', '73');
  INSERT INTO `sys_role_menu` VALUES ('1', '74');
  INSERT INTO `sys_role_menu` VALUES ('1', '75');
  INSERT INTO `sys_role_menu` VALUES ('1', '76');
  INSERT INTO `sys_role_menu` VALUES ('1', '77');
  INSERT INTO `sys_role_menu` VALUES ('1', '78');
  INSERT INTO `sys_role_menu` VALUES ('1', '79');
  INSERT INTO `sys_role_menu` VALUES ('1', '80');
  INSERT INTO `sys_role_menu` VALUES ('1', '81');
  INSERT INTO `sys_role_menu` VALUES ('1', '82');
  INSERT INTO `sys_role_menu` VALUES ('1', '83');
  INSERT INTO `sys_role_menu` VALUES ('1', '84');
  INSERT INTO `sys_role_menu` VALUES ('1', '85');
  INSERT INTO `sys_role_menu` VALUES ('1', '86');
  INSERT INTO `sys_role_menu` VALUES ('1', '87');
  INSERT INTO `sys_role_menu` VALUES ('1', '88');
  INSERT INTO `sys_role_menu` VALUES ('1', '89');
  INSERT INTO `sys_role_menu` VALUES ('1', '90');
  INSERT INTO `sys_role_menu` VALUES ('1', '91');
  INSERT INTO `sys_role_menu` VALUES ('1', '92');
  INSERT INTO `sys_role_menu` VALUES ('1', '93');
  INSERT INTO `sys_role_menu` VALUES ('1', '94');
  INSERT INTO `sys_role_menu` VALUES ('1', '95');
  INSERT INTO `sys_role_menu` VALUES ('1', '96');
  INSERT INTO `sys_role_menu` VALUES ('1', '97');
  INSERT INTO `sys_role_menu` VALUES ('1', '98');
  INSERT INTO `sys_role_menu` VALUES ('1', '99');
  INSERT INTO `sys_role_menu` VALUES ('1', '100');
  INSERT INTO `sys_role_menu` VALUES ('1', '101');
  INSERT INTO `sys_role_menu` VALUES ('1', '107');
  INSERT INTO `sys_role_menu` VALUES ('1', '108');
  INSERT INTO `sys_role_menu` VALUES ('2', '1');
  INSERT INTO `sys_role_menu` VALUES ('2', '27');
  INSERT INTO `sys_role_menu` VALUES ('2', '28');
  INSERT INTO `sys_role_menu` VALUES ('2', '29');
  INSERT INTO `sys_role_menu` VALUES ('2', '30');
  INSERT INTO `sys_role_menu` VALUES ('2', '81');
  INSERT INTO `sys_role_menu` VALUES ('2', '82');
  INSERT INTO `sys_role_menu` VALUES ('2', '83');
  INSERT INTO `sys_role_menu` VALUES ('2', '84');
  INSERT INTO `sys_role_menu` VALUES ('2', '85');
  INSERT INTO `sys_role_menu` VALUES ('2', '86');
  INSERT INTO `sys_role_menu` VALUES ('2', '87');
  INSERT INTO `sys_role_menu` VALUES ('2', '88');
  INSERT INTO `sys_role_menu` VALUES ('2', '89');
  INSERT INTO `sys_role_menu` VALUES ('2', '90');
  INSERT INTO `sys_role_menu` VALUES ('2', '91');
  INSERT INTO `sys_role_menu` VALUES ('2', '92');
  INSERT INTO `sys_role_menu` VALUES ('2', '93');
  INSERT INTO `sys_role_menu` VALUES ('2', '94');
  INSERT INTO `sys_role_menu` VALUES ('2', '95');
  INSERT INTO `sys_role_menu` VALUES ('2', '96');
  INSERT INTO `sys_role_menu` VALUES ('2', '97');
  INSERT INTO `sys_role_menu` VALUES ('2', '98');
  INSERT INTO `sys_role_menu` VALUES ('2', '99');
  INSERT INTO `sys_role_menu` VALUES ('2', '100');
  INSERT INTO `sys_role_menu` VALUES ('2', '101');
  INSERT INTO `sys_role_menu` VALUES ('2', '102');
  INSERT INTO `sys_role_menu` VALUES ('2', '103');
  INSERT INTO `sys_role_menu` VALUES ('2', '104');
  INSERT INTO `sys_role_menu` VALUES ('2', '105');
  INSERT INTO `sys_role_menu` VALUES ('2', '106');
  INSERT INTO `sys_role_menu` VALUES ('3', '1');
  INSERT INTO `sys_role_menu` VALUES ('3', '2');
  INSERT INTO `sys_role_menu` VALUES ('3', '3');
  INSERT INTO `sys_role_menu` VALUES ('3', '4');
  INSERT INTO `sys_role_menu` VALUES ('3', '5');
  INSERT INTO `sys_role_menu` VALUES ('3', '6');
  INSERT INTO `sys_role_menu` VALUES ('3', '7');
  INSERT INTO `sys_role_menu` VALUES ('3', '8');
  INSERT INTO `sys_role_menu` VALUES ('3', '9');
  INSERT INTO `sys_role_menu` VALUES ('3', '10');
  INSERT INTO `sys_role_menu` VALUES ('3', '11');
  INSERT INTO `sys_role_menu` VALUES ('3', '12');
  INSERT INTO `sys_role_menu` VALUES ('3', '13');
  INSERT INTO `sys_role_menu` VALUES ('3', '14');
  INSERT INTO `sys_role_menu` VALUES ('3', '15');
  INSERT INTO `sys_role_menu` VALUES ('3', '16');
  INSERT INTO `sys_role_menu` VALUES ('3', '17');
  INSERT INTO `sys_role_menu` VALUES ('3', '18');
  INSERT INTO `sys_role_menu` VALUES ('3', '19');
  INSERT INTO `sys_role_menu` VALUES ('3', '20');
  INSERT INTO `sys_role_menu` VALUES ('3', '21');
  INSERT INTO `sys_role_menu` VALUES ('3', '22');
  INSERT INTO `sys_role_menu` VALUES ('3', '23');
  INSERT INTO `sys_role_menu` VALUES ('3', '24');
  INSERT INTO `sys_role_menu` VALUES ('3', '25');
  INSERT INTO `sys_role_menu` VALUES ('3', '26');
  INSERT INTO `sys_role_menu` VALUES ('3', '27');
  INSERT INTO `sys_role_menu` VALUES ('3', '28');
  INSERT INTO `sys_role_menu` VALUES ('3', '29');
  INSERT INTO `sys_role_menu` VALUES ('3', '30');
  INSERT INTO `sys_role_menu` VALUES ('3', '31');
  INSERT INTO `sys_role_menu` VALUES ('3', '32');
  INSERT INTO `sys_role_menu` VALUES ('3', '33');
  INSERT INTO `sys_role_menu` VALUES ('3', '34');
  INSERT INTO `sys_role_menu` VALUES ('3', '35');
  INSERT INTO `sys_role_menu` VALUES ('3', '36');
  INSERT INTO `sys_role_menu` VALUES ('3', '37');
  INSERT INTO `sys_role_menu` VALUES ('3', '38');
  INSERT INTO `sys_role_menu` VALUES ('3', '39');
  INSERT INTO `sys_role_menu` VALUES ('3', '40');
  INSERT INTO `sys_role_menu` VALUES ('3', '41');
  INSERT INTO `sys_role_menu` VALUES ('3', '42');
  INSERT INTO `sys_role_menu` VALUES ('3', '43');
  INSERT INTO `sys_role_menu` VALUES ('3', '44');
  INSERT INTO `sys_role_menu` VALUES ('3', '45');
  INSERT INTO `sys_role_menu` VALUES ('3', '46');
  INSERT INTO `sys_role_menu` VALUES ('3', '47');
  INSERT INTO `sys_role_menu` VALUES ('3', '48');
  INSERT INTO `sys_role_menu` VALUES ('3', '49');
  INSERT INTO `sys_role_menu` VALUES ('3', '50');
  INSERT INTO `sys_role_menu` VALUES ('3', '51');
  INSERT INTO `sys_role_menu` VALUES ('3', '52');
  INSERT INTO `sys_role_menu` VALUES ('3', '53');
  INSERT INTO `sys_role_menu` VALUES ('3', '54');
  INSERT INTO `sys_role_menu` VALUES ('3', '55');
  INSERT INTO `sys_role_menu` VALUES ('3', '56');
  INSERT INTO `sys_role_menu` VALUES ('3', '57');
  INSERT INTO `sys_role_menu` VALUES ('3', '58');
  INSERT INTO `sys_role_menu` VALUES ('3', '59');
  INSERT INTO `sys_role_menu` VALUES ('3', '60');
  INSERT INTO `sys_role_menu` VALUES ('3', '61');
  INSERT INTO `sys_role_menu` VALUES ('3', '62');
  INSERT INTO `sys_role_menu` VALUES ('3', '63');
  INSERT INTO `sys_role_menu` VALUES ('3', '64');
  INSERT INTO `sys_role_menu` VALUES ('3', '65');
  INSERT INTO `sys_role_menu` VALUES ('3', '66');
  INSERT INTO `sys_role_menu` VALUES ('3', '67');
  INSERT INTO `sys_role_menu` VALUES ('3', '68');
  INSERT INTO `sys_role_menu` VALUES ('3', '69');
  INSERT INTO `sys_role_menu` VALUES ('3', '70');
  INSERT INTO `sys_role_menu` VALUES ('3', '71');
  INSERT INTO `sys_role_menu` VALUES ('3', '72');
  INSERT INTO `sys_role_menu` VALUES ('3', '73');
  INSERT INTO `sys_role_menu` VALUES ('3', '74');
  INSERT INTO `sys_role_menu` VALUES ('3', '75');
  INSERT INTO `sys_role_menu` VALUES ('3', '76');
  INSERT INTO `sys_role_menu` VALUES ('3', '77');
  INSERT INTO `sys_role_menu` VALUES ('3', '78');
  INSERT INTO `sys_role_menu` VALUES ('3', '79');
  INSERT INTO `sys_role_menu` VALUES ('3', '80');
  INSERT INTO `sys_role_menu` VALUES ('3', '81');
  INSERT INTO `sys_role_menu` VALUES ('3', '82');
  INSERT INTO `sys_role_menu` VALUES ('3', '83');
  INSERT INTO `sys_role_menu` VALUES ('3', '84');
  INSERT INTO `sys_role_menu` VALUES ('3', '85');
  INSERT INTO `sys_role_menu` VALUES ('3', '86');
  INSERT INTO `sys_role_menu` VALUES ('3', '87');
  INSERT INTO `sys_role_menu` VALUES ('3', '88');
  INSERT INTO `sys_role_menu` VALUES ('3', '89');
  INSERT INTO `sys_role_menu` VALUES ('3', '90');
  INSERT INTO `sys_role_menu` VALUES ('3', '91');
  INSERT INTO `sys_role_menu` VALUES ('3', '92');
  INSERT INTO `sys_role_menu` VALUES ('3', '93');
  INSERT INTO `sys_role_menu` VALUES ('3', '94');
  INSERT INTO `sys_role_menu` VALUES ('4', '1');
  INSERT INTO `sys_role_menu` VALUES ('4', '2');
  INSERT INTO `sys_role_menu` VALUES ('4', '3');
  INSERT INTO `sys_role_menu` VALUES ('4', '4');
  INSERT INTO `sys_role_menu` VALUES ('4', '5');
  INSERT INTO `sys_role_menu` VALUES ('4', '6');
  INSERT INTO `sys_role_menu` VALUES ('4', '7');
  INSERT INTO `sys_role_menu` VALUES ('4', '8');
  INSERT INTO `sys_role_menu` VALUES ('4', '9');
  INSERT INTO `sys_role_menu` VALUES ('4', '10');
  INSERT INTO `sys_role_menu` VALUES ('4', '11');
  INSERT INTO `sys_role_menu` VALUES ('4', '12');
  INSERT INTO `sys_role_menu` VALUES ('4', '13');
  INSERT INTO `sys_role_menu` VALUES ('4', '14');
  INSERT INTO `sys_role_menu` VALUES ('4', '15');
  INSERT INTO `sys_role_menu` VALUES ('4', '16');
  INSERT INTO `sys_role_menu` VALUES ('4', '17');
  INSERT INTO `sys_role_menu` VALUES ('4', '18');
  INSERT INTO `sys_role_menu` VALUES ('4', '19');
  INSERT INTO `sys_role_menu` VALUES ('4', '20');
  INSERT INTO `sys_role_menu` VALUES ('4', '21');
  INSERT INTO `sys_role_menu` VALUES ('4', '22');
  INSERT INTO `sys_role_menu` VALUES ('4', '23');
  INSERT INTO `sys_role_menu` VALUES ('4', '24');
  INSERT INTO `sys_role_menu` VALUES ('4', '25');
  INSERT INTO `sys_role_menu` VALUES ('4', '26');
  INSERT INTO `sys_role_menu` VALUES ('4', '27');
  INSERT INTO `sys_role_menu` VALUES ('4', '28');
  INSERT INTO `sys_role_menu` VALUES ('4', '29');
  INSERT INTO `sys_role_menu` VALUES ('4', '30');
  INSERT INTO `sys_role_menu` VALUES ('4', '31');
  INSERT INTO `sys_role_menu` VALUES ('4', '32');
  INSERT INTO `sys_role_menu` VALUES ('4', '33');
  INSERT INTO `sys_role_menu` VALUES ('4', '34');
  INSERT INTO `sys_role_menu` VALUES ('4', '35');
  INSERT INTO `sys_role_menu` VALUES ('4', '36');
  INSERT INTO `sys_role_menu` VALUES ('4', '37');
  INSERT INTO `sys_role_menu` VALUES ('4', '38');
  INSERT INTO `sys_role_menu` VALUES ('4', '39');
  INSERT INTO `sys_role_menu` VALUES ('4', '40');
  INSERT INTO `sys_role_menu` VALUES ('4', '41');
  INSERT INTO `sys_role_menu` VALUES ('4', '42');
  INSERT INTO `sys_role_menu` VALUES ('4', '43');
  INSERT INTO `sys_role_menu` VALUES ('4', '44');
  INSERT INTO `sys_role_menu` VALUES ('4', '45');
  INSERT INTO `sys_role_menu` VALUES ('4', '46');
  INSERT INTO `sys_role_menu` VALUES ('4', '47');
  INSERT INTO `sys_role_menu` VALUES ('4', '48');
  INSERT INTO `sys_role_menu` VALUES ('4', '49');
  INSERT INTO `sys_role_menu` VALUES ('4', '50');
  INSERT INTO `sys_role_menu` VALUES ('4', '51');
  INSERT INTO `sys_role_menu` VALUES ('4', '52');
  INSERT INTO `sys_role_menu` VALUES ('4', '53');
  INSERT INTO `sys_role_menu` VALUES ('4', '54');
  INSERT INTO `sys_role_menu` VALUES ('4', '55');
  INSERT INTO `sys_role_menu` VALUES ('4', '56');
  INSERT INTO `sys_role_menu` VALUES ('4', '57');
  INSERT INTO `sys_role_menu` VALUES ('4', '58');
  INSERT INTO `sys_role_menu` VALUES ('4', '59');
  INSERT INTO `sys_role_menu` VALUES ('4', '60');
  INSERT INTO `sys_role_menu` VALUES ('4', '61');
  INSERT INTO `sys_role_menu` VALUES ('4', '62');
  INSERT INTO `sys_role_menu` VALUES ('4', '63');
  INSERT INTO `sys_role_menu` VALUES ('4', '64');
  INSERT INTO `sys_role_menu` VALUES ('4', '65');
  INSERT INTO `sys_role_menu` VALUES ('4', '66');
  INSERT INTO `sys_role_menu` VALUES ('4', '67');
  INSERT INTO `sys_role_menu` VALUES ('4', '68');
  INSERT INTO `sys_role_menu` VALUES ('4', '69');
  INSERT INTO `sys_role_menu` VALUES ('4', '70');
  INSERT INTO `sys_role_menu` VALUES ('4', '71');
  INSERT INTO `sys_role_menu` VALUES ('4', '72');
  INSERT INTO `sys_role_menu` VALUES ('4', '73');
  INSERT INTO `sys_role_menu` VALUES ('4', '74');
  INSERT INTO `sys_role_menu` VALUES ('4', '75');
  INSERT INTO `sys_role_menu` VALUES ('4', '76');
  INSERT INTO `sys_role_menu` VALUES ('4', '77');
  INSERT INTO `sys_role_menu` VALUES ('4', '78');
  INSERT INTO `sys_role_menu` VALUES ('4', '79');
  INSERT INTO `sys_role_menu` VALUES ('4', '80');
  INSERT INTO `sys_role_menu` VALUES ('4', '81');
  INSERT INTO `sys_role_menu` VALUES ('4', '82');
  INSERT INTO `sys_role_menu` VALUES ('4', '83');
  INSERT INTO `sys_role_menu` VALUES ('4', '84');
  INSERT INTO `sys_role_menu` VALUES ('4', '85');
  INSERT INTO `sys_role_menu` VALUES ('4', '86');
  INSERT INTO `sys_role_menu` VALUES ('4', '87');
  INSERT INTO `sys_role_menu` VALUES ('4', '88');
  INSERT INTO `sys_role_menu` VALUES ('4', '89');
  INSERT INTO `sys_role_menu` VALUES ('4', '90');
  INSERT INTO `sys_role_menu` VALUES ('4', '91');
  INSERT INTO `sys_role_menu` VALUES ('4', '92');
  INSERT INTO `sys_role_menu` VALUES ('4', '93');
  INSERT INTO `sys_role_menu` VALUES ('4', '94');
  INSERT INTO `sys_role_menu` VALUES ('5', '1');
  INSERT INTO `sys_role_menu` VALUES ('5', '2');
  INSERT INTO `sys_role_menu` VALUES ('5', '3');
  INSERT INTO `sys_role_menu` VALUES ('5', '4');
  INSERT INTO `sys_role_menu` VALUES ('5', '5');
  INSERT INTO `sys_role_menu` VALUES ('5', '6');
  INSERT INTO `sys_role_menu` VALUES ('5', '7');
  INSERT INTO `sys_role_menu` VALUES ('5', '8');
  INSERT INTO `sys_role_menu` VALUES ('5', '9');
  INSERT INTO `sys_role_menu` VALUES ('5', '10');
  INSERT INTO `sys_role_menu` VALUES ('5', '11');
  INSERT INTO `sys_role_menu` VALUES ('5', '12');
  INSERT INTO `sys_role_menu` VALUES ('5', '13');
  INSERT INTO `sys_role_menu` VALUES ('5', '14');
  INSERT INTO `sys_role_menu` VALUES ('5', '15');
  INSERT INTO `sys_role_menu` VALUES ('5', '16');
  INSERT INTO `sys_role_menu` VALUES ('5', '17');
  INSERT INTO `sys_role_menu` VALUES ('5', '18');
  INSERT INTO `sys_role_menu` VALUES ('5', '19');
  INSERT INTO `sys_role_menu` VALUES ('5', '20');
  INSERT INTO `sys_role_menu` VALUES ('5', '21');
  INSERT INTO `sys_role_menu` VALUES ('5', '22');
  INSERT INTO `sys_role_menu` VALUES ('5', '23');
  INSERT INTO `sys_role_menu` VALUES ('5', '24');
  INSERT INTO `sys_role_menu` VALUES ('5', '25');
  INSERT INTO `sys_role_menu` VALUES ('5', '26');
  INSERT INTO `sys_role_menu` VALUES ('5', '27');
  INSERT INTO `sys_role_menu` VALUES ('5', '28');
  INSERT INTO `sys_role_menu` VALUES ('5', '29');
  INSERT INTO `sys_role_menu` VALUES ('5', '30');
  INSERT INTO `sys_role_menu` VALUES ('5', '31');
  INSERT INTO `sys_role_menu` VALUES ('5', '32');
  INSERT INTO `sys_role_menu` VALUES ('5', '33');
  INSERT INTO `sys_role_menu` VALUES ('5', '34');
  INSERT INTO `sys_role_menu` VALUES ('5', '35');
  INSERT INTO `sys_role_menu` VALUES ('5', '36');
  INSERT INTO `sys_role_menu` VALUES ('5', '37');
  INSERT INTO `sys_role_menu` VALUES ('5', '38');
  INSERT INTO `sys_role_menu` VALUES ('5', '39');
  INSERT INTO `sys_role_menu` VALUES ('5', '40');
  INSERT INTO `sys_role_menu` VALUES ('5', '41');
  INSERT INTO `sys_role_menu` VALUES ('5', '42');
  INSERT INTO `sys_role_menu` VALUES ('5', '43');
  INSERT INTO `sys_role_menu` VALUES ('5', '44');
  INSERT INTO `sys_role_menu` VALUES ('5', '45');
  INSERT INTO `sys_role_menu` VALUES ('5', '46');
  INSERT INTO `sys_role_menu` VALUES ('5', '47');
  INSERT INTO `sys_role_menu` VALUES ('5', '48');
  INSERT INTO `sys_role_menu` VALUES ('5', '49');
  INSERT INTO `sys_role_menu` VALUES ('5', '50');
  INSERT INTO `sys_role_menu` VALUES ('5', '51');
  INSERT INTO `sys_role_menu` VALUES ('5', '52');
  INSERT INTO `sys_role_menu` VALUES ('5', '53');
  INSERT INTO `sys_role_menu` VALUES ('5', '54');
  INSERT INTO `sys_role_menu` VALUES ('5', '55');
  INSERT INTO `sys_role_menu` VALUES ('5', '56');
  INSERT INTO `sys_role_menu` VALUES ('5', '57');
  INSERT INTO `sys_role_menu` VALUES ('5', '58');
  INSERT INTO `sys_role_menu` VALUES ('5', '59');
  INSERT INTO `sys_role_menu` VALUES ('5', '60');
  INSERT INTO `sys_role_menu` VALUES ('5', '61');
  INSERT INTO `sys_role_menu` VALUES ('5', '62');
  INSERT INTO `sys_role_menu` VALUES ('5', '63');
  INSERT INTO `sys_role_menu` VALUES ('5', '64');
  INSERT INTO `sys_role_menu` VALUES ('5', '65');
  INSERT INTO `sys_role_menu` VALUES ('5', '66');
  INSERT INTO `sys_role_menu` VALUES ('5', '67');
  INSERT INTO `sys_role_menu` VALUES ('5', '68');
  INSERT INTO `sys_role_menu` VALUES ('5', '69');
  INSERT INTO `sys_role_menu` VALUES ('5', '70');
  INSERT INTO `sys_role_menu` VALUES ('5', '71');
  INSERT INTO `sys_role_menu` VALUES ('5', '72');
  INSERT INTO `sys_role_menu` VALUES ('5', '73');
  INSERT INTO `sys_role_menu` VALUES ('5', '74');
  INSERT INTO `sys_role_menu` VALUES ('5', '75');
  INSERT INTO `sys_role_menu` VALUES ('5', '76');
  INSERT INTO `sys_role_menu` VALUES ('5', '77');
  INSERT INTO `sys_role_menu` VALUES ('5', '78');
  INSERT INTO `sys_role_menu` VALUES ('5', '79');
  INSERT INTO `sys_role_menu` VALUES ('5', '80');
  INSERT INTO `sys_role_menu` VALUES ('5', '81');
  INSERT INTO `sys_role_menu` VALUES ('5', '82');
  INSERT INTO `sys_role_menu` VALUES ('5', '83');
  INSERT INTO `sys_role_menu` VALUES ('5', '84');
  INSERT INTO `sys_role_menu` VALUES ('5', '85');
  INSERT INTO `sys_role_menu` VALUES ('5', '86');
  INSERT INTO `sys_role_menu` VALUES ('5', '87');
  INSERT INTO `sys_role_menu` VALUES ('5', '88');
  INSERT INTO `sys_role_menu` VALUES ('5', '89');
  INSERT INTO `sys_role_menu` VALUES ('5', '90');
  INSERT INTO `sys_role_menu` VALUES ('5', '91');
  INSERT INTO `sys_role_menu` VALUES ('5', '92');
  INSERT INTO `sys_role_menu` VALUES ('5', '93');
  INSERT INTO `sys_role_menu` VALUES ('5', '94');
  INSERT INTO `sys_role_menu` VALUES ('6', '1');
  INSERT INTO `sys_role_menu` VALUES ('6', '2');
  INSERT INTO `sys_role_menu` VALUES ('6', '3');
  INSERT INTO `sys_role_menu` VALUES ('6', '4');
  INSERT INTO `sys_role_menu` VALUES ('6', '5');
  INSERT INTO `sys_role_menu` VALUES ('6', '6');
  INSERT INTO `sys_role_menu` VALUES ('6', '7');
  INSERT INTO `sys_role_menu` VALUES ('6', '8');
  INSERT INTO `sys_role_menu` VALUES ('6', '9');
  INSERT INTO `sys_role_menu` VALUES ('6', '10');
  INSERT INTO `sys_role_menu` VALUES ('6', '11');
  INSERT INTO `sys_role_menu` VALUES ('6', '12');
  INSERT INTO `sys_role_menu` VALUES ('6', '13');
  INSERT INTO `sys_role_menu` VALUES ('6', '14');
  INSERT INTO `sys_role_menu` VALUES ('6', '15');
  INSERT INTO `sys_role_menu` VALUES ('6', '16');
  INSERT INTO `sys_role_menu` VALUES ('6', '17');
  INSERT INTO `sys_role_menu` VALUES ('6', '18');
  INSERT INTO `sys_role_menu` VALUES ('6', '19');
  INSERT INTO `sys_role_menu` VALUES ('6', '20');
  INSERT INTO `sys_role_menu` VALUES ('6', '21');
  INSERT INTO `sys_role_menu` VALUES ('6', '22');
  INSERT INTO `sys_role_menu` VALUES ('6', '23');
  INSERT INTO `sys_role_menu` VALUES ('6', '24');
  INSERT INTO `sys_role_menu` VALUES ('6', '25');
  INSERT INTO `sys_role_menu` VALUES ('6', '26');
  INSERT INTO `sys_role_menu` VALUES ('6', '27');
  INSERT INTO `sys_role_menu` VALUES ('6', '28');
  INSERT INTO `sys_role_menu` VALUES ('6', '29');
  INSERT INTO `sys_role_menu` VALUES ('6', '30');
  INSERT INTO `sys_role_menu` VALUES ('6', '31');
  INSERT INTO `sys_role_menu` VALUES ('6', '32');
  INSERT INTO `sys_role_menu` VALUES ('6', '33');
  INSERT INTO `sys_role_menu` VALUES ('6', '34');
  INSERT INTO `sys_role_menu` VALUES ('6', '35');
  INSERT INTO `sys_role_menu` VALUES ('6', '36');
  INSERT INTO `sys_role_menu` VALUES ('6', '37');
  INSERT INTO `sys_role_menu` VALUES ('6', '38');
  INSERT INTO `sys_role_menu` VALUES ('6', '39');
  INSERT INTO `sys_role_menu` VALUES ('6', '40');
  INSERT INTO `sys_role_menu` VALUES ('6', '41');
  INSERT INTO `sys_role_menu` VALUES ('6', '42');
  INSERT INTO `sys_role_menu` VALUES ('6', '43');
  INSERT INTO `sys_role_menu` VALUES ('6', '44');
  INSERT INTO `sys_role_menu` VALUES ('6', '45');
  INSERT INTO `sys_role_menu` VALUES ('6', '46');
  INSERT INTO `sys_role_menu` VALUES ('6', '47');
  INSERT INTO `sys_role_menu` VALUES ('6', '48');
  INSERT INTO `sys_role_menu` VALUES ('6', '49');
  INSERT INTO `sys_role_menu` VALUES ('6', '50');
  INSERT INTO `sys_role_menu` VALUES ('6', '51');
  INSERT INTO `sys_role_menu` VALUES ('6', '52');
  INSERT INTO `sys_role_menu` VALUES ('6', '53');
  INSERT INTO `sys_role_menu` VALUES ('6', '54');
  INSERT INTO `sys_role_menu` VALUES ('6', '55');
  INSERT INTO `sys_role_menu` VALUES ('6', '56');
  INSERT INTO `sys_role_menu` VALUES ('6', '57');
  INSERT INTO `sys_role_menu` VALUES ('6', '58');
  INSERT INTO `sys_role_menu` VALUES ('6', '59');
  INSERT INTO `sys_role_menu` VALUES ('6', '60');
  INSERT INTO `sys_role_menu` VALUES ('6', '61');
  INSERT INTO `sys_role_menu` VALUES ('6', '62');
  INSERT INTO `sys_role_menu` VALUES ('6', '63');
  INSERT INTO `sys_role_menu` VALUES ('6', '64');
  INSERT INTO `sys_role_menu` VALUES ('6', '65');
  INSERT INTO `sys_role_menu` VALUES ('6', '66');
  INSERT INTO `sys_role_menu` VALUES ('6', '67');
  INSERT INTO `sys_role_menu` VALUES ('6', '68');
  INSERT INTO `sys_role_menu` VALUES ('6', '69');
  INSERT INTO `sys_role_menu` VALUES ('6', '70');
  INSERT INTO `sys_role_menu` VALUES ('6', '71');
  INSERT INTO `sys_role_menu` VALUES ('6', '72');
  INSERT INTO `sys_role_menu` VALUES ('6', '73');
  INSERT INTO `sys_role_menu` VALUES ('6', '74');
  INSERT INTO `sys_role_menu` VALUES ('6', '75');
  INSERT INTO `sys_role_menu` VALUES ('6', '76');
  INSERT INTO `sys_role_menu` VALUES ('6', '77');
  INSERT INTO `sys_role_menu` VALUES ('6', '78');
  INSERT INTO `sys_role_menu` VALUES ('6', '79');
  INSERT INTO `sys_role_menu` VALUES ('6', '80');
  INSERT INTO `sys_role_menu` VALUES ('6', '81');
  INSERT INTO `sys_role_menu` VALUES ('6', '82');
  INSERT INTO `sys_role_menu` VALUES ('6', '83');
  INSERT INTO `sys_role_menu` VALUES ('6', '84');
  INSERT INTO `sys_role_menu` VALUES ('6', '85');
  INSERT INTO `sys_role_menu` VALUES ('6', '86');
  INSERT INTO `sys_role_menu` VALUES ('6', '87');
  INSERT INTO `sys_role_menu` VALUES ('6', '88');
  INSERT INTO `sys_role_menu` VALUES ('6', '89');
  INSERT INTO `sys_role_menu` VALUES ('6', '90');
  INSERT INTO `sys_role_menu` VALUES ('6', '91');
  INSERT INTO `sys_role_menu` VALUES ('6', '92');
  INSERT INTO `sys_role_menu` VALUES ('6', '93');
  INSERT INTO `sys_role_menu` VALUES ('6', '94');
  INSERT INTO `sys_role_menu` VALUES ('8', '1');
  INSERT INTO `sys_role_menu` VALUES ('8', '31');
  INSERT INTO `sys_role_menu` VALUES ('8', '32');
  INSERT INTO `sys_role_menu` VALUES ('8', '33');
  INSERT INTO `sys_role_menu` VALUES ('8', '34');
  INSERT INTO `sys_role_menu` VALUES ('8', '35');
  INSERT INTO `sys_role_menu` VALUES ('8', '36');
  INSERT INTO `sys_role_menu` VALUES ('8', '37');
  INSERT INTO `sys_role_menu` VALUES ('8', '38');
  INSERT INTO `sys_role_menu` VALUES ('8', '39');
  INSERT INTO `sys_role_menu` VALUES ('8', '40');
  INSERT INTO `sys_role_menu` VALUES ('8', '41');
  INSERT INTO `sys_role_menu` VALUES ('8', '42');
  INSERT INTO `sys_role_menu` VALUES ('8', '43');
  INSERT INTO `sys_role_menu` VALUES ('8', '44');
  INSERT INTO `sys_role_menu` VALUES ('8', '45');
  INSERT INTO `sys_role_menu` VALUES ('8', '46');
  INSERT INTO `sys_role_menu` VALUES ('8', '47');
  INSERT INTO `sys_role_menu` VALUES ('8', '48');
  INSERT INTO `sys_role_menu` VALUES ('8', '49');
  INSERT INTO `sys_role_menu` VALUES ('8', '50');
  INSERT INTO `sys_role_menu` VALUES ('8', '51');
  INSERT INTO `sys_role_menu` VALUES ('8', '52');
  INSERT INTO `sys_role_menu` VALUES ('8', '53');
  INSERT INTO `sys_role_menu` VALUES ('8', '54');
  INSERT INTO `sys_role_menu` VALUES ('8', '55');
  INSERT INTO `sys_role_menu` VALUES ('8', '56');
  INSERT INTO `sys_role_menu` VALUES ('8', '57');
  INSERT INTO `sys_role_menu` VALUES ('8', '58');
  INSERT INTO `sys_role_menu` VALUES ('8', '59');
  INSERT INTO `sys_role_menu` VALUES ('8', '60');
  INSERT INTO `sys_role_menu` VALUES ('8', '61');
  INSERT INTO `sys_role_menu` VALUES ('8', '73');
  INSERT INTO `sys_role_menu` VALUES ('8', '74');
  INSERT INTO `sys_role_menu` VALUES ('8', '75');
  INSERT INTO `sys_role_menu` VALUES ('9', '1');
  INSERT INTO `sys_role_menu` VALUES ('9', '2');
  INSERT INTO `sys_role_menu` VALUES ('9', '3');
  INSERT INTO `sys_role_menu` VALUES ('9', '4');
  INSERT INTO `sys_role_menu` VALUES ('9', '5');
  INSERT INTO `sys_role_menu` VALUES ('9', '6');
  INSERT INTO `sys_role_menu` VALUES ('9', '7');
  INSERT INTO `sys_role_menu` VALUES ('9', '8');
  INSERT INTO `sys_role_menu` VALUES ('9', '9');
  INSERT INTO `sys_role_menu` VALUES ('9', '10');
  INSERT INTO `sys_role_menu` VALUES ('9', '11');
  INSERT INTO `sys_role_menu` VALUES ('9', '12');
  INSERT INTO `sys_role_menu` VALUES ('9', '13');
  INSERT INTO `sys_role_menu` VALUES ('9', '14');
  INSERT INTO `sys_role_menu` VALUES ('9', '15');
  INSERT INTO `sys_role_menu` VALUES ('9', '16');
  INSERT INTO `sys_role_menu` VALUES ('9', '17');
  INSERT INTO `sys_role_menu` VALUES ('9', '18');
  INSERT INTO `sys_role_menu` VALUES ('9', '19');
  INSERT INTO `sys_role_menu` VALUES ('9', '20');
  INSERT INTO `sys_role_menu` VALUES ('9', '21');
  INSERT INTO `sys_role_menu` VALUES ('9', '22');
  INSERT INTO `sys_role_menu` VALUES ('9', '23');
  INSERT INTO `sys_role_menu` VALUES ('9', '24');
  INSERT INTO `sys_role_menu` VALUES ('9', '25');
  INSERT INTO `sys_role_menu` VALUES ('9', '26');
  INSERT INTO `sys_role_menu` VALUES ('9', '27');
  INSERT INTO `sys_role_menu` VALUES ('9', '28');
  INSERT INTO `sys_role_menu` VALUES ('9', '29');
  INSERT INTO `sys_role_menu` VALUES ('9', '30');
  INSERT INTO `sys_role_menu` VALUES ('9', '31');
  INSERT INTO `sys_role_menu` VALUES ('9', '32');
  INSERT INTO `sys_role_menu` VALUES ('9', '33');
  INSERT INTO `sys_role_menu` VALUES ('9', '34');
  INSERT INTO `sys_role_menu` VALUES ('9', '35');
  INSERT INTO `sys_role_menu` VALUES ('9', '36');
  INSERT INTO `sys_role_menu` VALUES ('9', '37');
  INSERT INTO `sys_role_menu` VALUES ('9', '38');
  INSERT INTO `sys_role_menu` VALUES ('9', '39');
  INSERT INTO `sys_role_menu` VALUES ('9', '40');
  INSERT INTO `sys_role_menu` VALUES ('9', '41');
  INSERT INTO `sys_role_menu` VALUES ('9', '42');
  INSERT INTO `sys_role_menu` VALUES ('9', '43');
  INSERT INTO `sys_role_menu` VALUES ('9', '44');
  INSERT INTO `sys_role_menu` VALUES ('9', '45');
  INSERT INTO `sys_role_menu` VALUES ('9', '46');
  INSERT INTO `sys_role_menu` VALUES ('9', '47');
  INSERT INTO `sys_role_menu` VALUES ('9', '48');
  INSERT INTO `sys_role_menu` VALUES ('9', '49');
  INSERT INTO `sys_role_menu` VALUES ('9', '50');
  INSERT INTO `sys_role_menu` VALUES ('9', '51');
  INSERT INTO `sys_role_menu` VALUES ('9', '52');
  INSERT INTO `sys_role_menu` VALUES ('9', '53');
  INSERT INTO `sys_role_menu` VALUES ('9', '54');
  INSERT INTO `sys_role_menu` VALUES ('9', '55');
  INSERT INTO `sys_role_menu` VALUES ('9', '56');
  INSERT INTO `sys_role_menu` VALUES ('9', '57');
  INSERT INTO `sys_role_menu` VALUES ('9', '58');
  INSERT INTO `sys_role_menu` VALUES ('9', '59');
  INSERT INTO `sys_role_menu` VALUES ('9', '60');
  INSERT INTO `sys_role_menu` VALUES ('9', '61');
  INSERT INTO `sys_role_menu` VALUES ('9', '62');
  INSERT INTO `sys_role_menu` VALUES ('9', '63');
  INSERT INTO `sys_role_menu` VALUES ('9', '64');
  INSERT INTO `sys_role_menu` VALUES ('9', '65');
  INSERT INTO `sys_role_menu` VALUES ('9', '66');
  INSERT INTO `sys_role_menu` VALUES ('9', '67');
  INSERT INTO `sys_role_menu` VALUES ('9', '68');
  INSERT INTO `sys_role_menu` VALUES ('9', '69');
  INSERT INTO `sys_role_menu` VALUES ('9', '70');
  INSERT INTO `sys_role_menu` VALUES ('9', '71');
  INSERT INTO `sys_role_menu` VALUES ('9', '72');
  INSERT INTO `sys_role_menu` VALUES ('9', '73');
  INSERT INTO `sys_role_menu` VALUES ('9', '74');
  INSERT INTO `sys_role_menu` VALUES ('9', '75');
  INSERT INTO `sys_role_menu` VALUES ('9', '76');
  INSERT INTO `sys_role_menu` VALUES ('9', '77');
  INSERT INTO `sys_role_menu` VALUES ('9', '78');
  INSERT INTO `sys_role_menu` VALUES ('9', '79');
  INSERT INTO `sys_role_menu` VALUES ('9', '80');
  INSERT INTO `sys_role_menu` VALUES ('9', '81');
  INSERT INTO `sys_role_menu` VALUES ('9', '82');
  INSERT INTO `sys_role_menu` VALUES ('9', '83');
  INSERT INTO `sys_role_menu` VALUES ('9', '84');
  INSERT INTO `sys_role_menu` VALUES ('9', '85');
  INSERT INTO `sys_role_menu` VALUES ('9', '86');
  INSERT INTO `sys_role_menu` VALUES ('9', '87');
  INSERT INTO `sys_role_menu` VALUES ('9', '88');
  INSERT INTO `sys_role_menu` VALUES ('9', '89');
  INSERT INTO `sys_role_menu` VALUES ('9', '90');
  INSERT INTO `sys_role_menu` VALUES ('9', '91');
  INSERT INTO `sys_role_menu` VALUES ('9', '92');
  INSERT INTO `sys_role_menu` VALUES ('9', '93');
  INSERT INTO `sys_role_menu` VALUES ('9', '94');
  INSERT INTO `sys_role_menu` VALUES ('9', '95');
  INSERT INTO `sys_role_menu` VALUES ('9', '96');
  INSERT INTO `sys_role_menu` VALUES ('9', '97');
  INSERT INTO `sys_role_menu` VALUES ('9', '98');
  INSERT INTO `sys_role_menu` VALUES ('9', '99');
  INSERT INTO `sys_role_menu` VALUES ('9', '100');
  INSERT INTO `sys_role_menu` VALUES ('9', '101');
  
  -- ----------------------------
  -- Table structure for `sys_role_office`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role_office`;
  CREATE TABLE `sys_role_office` (
    `role_id` bigint(20) NOT NULL COMMENT '角色编号',
    `office_id` bigint(20) NOT NULL COMMENT '机构编号',
    PRIMARY KEY (`role_id`,`office_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色-机构';
  
  -- ----------------------------
  -- Records of sys_role_office
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `sys_sequences`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_sequences`;
  CREATE TABLE `sys_sequences` (
    `sequence_name` varchar(255) NOT NULL,
    `next_value` bigint(20) NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of sys_sequences
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `sys_user`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_user`;
  CREATE TABLE `sys_user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `company_id` bigint(20) NOT NULL COMMENT '归属公司',
    `office_id` bigint(20) DEFAULT NULL COMMENT '归属部门',
    `login_name` varchar(100) NOT NULL COMMENT '登录名',
    `password` varchar(100) NOT NULL COMMENT '密码',
    `no` varchar(100) DEFAULT NULL COMMENT '工号',
    `name` varchar(100) NOT NULL COMMENT '姓名',
    `email` varchar(200) DEFAULT NULL COMMENT '邮箱',
    `phone` varchar(200) DEFAULT NULL COMMENT '电话',
    `mobile` varchar(200) DEFAULT NULL COMMENT '手机',
    `mobile2` varchar(200) DEFAULT NULL,
    `user_type` char(1) DEFAULT NULL COMMENT '用户类型',
    `login_ip` varchar(100) DEFAULT NULL COMMENT '最后登陆IP',
    `login_date` datetime DEFAULT NULL COMMENT '最后登陆时间',
    `create_by` bigint(20) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` bigint(20) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `paperwork_code` varchar(200) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `sys_user_office_id` (`office_id`),
    KEY `sys_user_login_name` (`login_name`),
    KEY `sys_user_company_id` (`company_id`),
    KEY `sys_user_update_date` (`update_date`),
    KEY `sys_user_del_flag` (`del_flag`)
  ) ENGINE=InnoDB AUTO_INCREMENT=19088 DEFAULT CHARSET=utf8 COMMENT='用户表';
  
  -- ----------------------------
  -- Records of sys_user
  -- ----------------------------
  INSERT INTO `sys_user` VALUES ('1', '1', '1', 'admin', '39237ee612f5fdc28d6510ad7d3c41a49ca60e7706c9c607480afc30', '1', '管理员', '11@qq.com', '11', '', '', '1', '127.0.0.1', '2015-09-21 17:27:31', '1', '2014-05-01 21:03:50', '1', '2014-09-19 17:00:38', '最高管理员', '0', '123');
  
  -- ----------------------------
  -- Table structure for `sys_user_fees`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_user_fees`;
  CREATE TABLE `sys_user_fees` (
    `user_id` bigint(20) NOT NULL COMMENT '用户编号',
    `fees_id` bigint(20) NOT NULL COMMENT '费用编号',
    PRIMARY KEY (`user_id`,`fees_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户-费用';
  
  -- ----------------------------
  -- Records of sys_user_fees
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `sys_user_role`
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_user_role`;
  CREATE TABLE `sys_user_role` (
    `user_id` bigint(20) NOT NULL COMMENT '用户编号',
    `role_id` bigint(20) NOT NULL COMMENT '角色编号',
    PRIMARY KEY (`user_id`,`role_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户-角色';
  
  -- ----------------------------
  -- Records of sys_user_role
  -- ----------------------------
  INSERT INTO `sys_user_role` VALUES ('1', '1');
  