/*
|
Navicat MySQL Data Transfer
|
|
Source Server : localhost_3306
|
Source Server Version : 50558
|
Source Host : localhost:3306
|
Source Database : oasys
|
|
Target Server Type : MYSQL
|
Target Server Version : 50558
|
File Encoding : 65001
|
|
Date: 2018-01-03 11:47:22
|
*/
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
-- ----------------------------
|
-- Table structure for `act_evt_log`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_evt_log`;
|
CREATE TABLE `act_evt_log` (
|
`LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
|
`TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT 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,
|
`TIME_STAMP_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`DATA_` longblob,
|
`LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`LOCK_TIME_` timestamp NULL DEFAULT NULL,
|
`IS_PROCESSED_` tinyint(4) DEFAULT '0',
|
PRIMARY KEY (`LOG_NR_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_evt_log
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 ('77502', '1', 'BillNote.bpmn', '77501', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A7873643D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22687474703A2F2F7777772E61637469766974692E6F72672F74657374223E0A20203C70726F636573732069643D2242696C6C4E6F746522206E616D653D22E8AFB7E58187E6B581E7A88B2220697345786563757461626C653D2274727565223E0A202020203C73746172744576656E742069643D2273746172746576656E743122206E616D653D225374617274223E3C2F73746172744576656E743E0A202020203C757365725461736B2069643D22757365727461736B3322206E616D653D22E68891E79A84E8AFB7E6B182222061637469766974693A61737369676E65653D22247B757365727D223E3C2F757365725461736B3E0A202020203C73657175656E6365466C6F772069643D22666C6F773422206E616D653D22E590AFE58AA8E4BBBBE58AA12220736F757263655265663D2273746172746576656E743122207461726765745265663D22757365727461736B33223E3C2F73657175656E6365466C6F773E0A202020203C757365725461736B2069643D22757365727461736B3422206E616D653D22E680BBE7BB8FE79086222061637469766974693A61737369676E65653D22247B61646D696E737D223E3C2F757365725461736B3E0A202020203C656E644576656E742069643D22656E646576656E743122206E616D653D22456E64223E3C2F656E644576656E743E0A202020203C73657175656E6365466C6F772069643D22666C6F773822206E616D653D22E689B9E587862220736F757263655265663D22757365727461736B3422207461726765745265663D22656E646576656E7431223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6F7574636F6D653D3D27E689B9E58786277D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C757365725461736B2069643D22757365727461736B3622206E616D653D22E983A8E997A8E7BB8FE79086222061637469766974693A61737369676E65653D22247B646570744D61677D223E3C2F757365725461736B3E0A202020203C757365725461736B2069643D22757365727461736B3722206E616D653D22E4BABAE4BA8BE7BB8FE79086222061637469766974693A61737369676E65653D22247B706572736F6E6E656C7D223E3C2F757365725461736B3E0A202020203C73657175656E6365466C6F772069643D22666C6F77313022206E616D653D22E689B9E587862220736F757263655265663D22757365727461736B3722207461726765745265663D22656E646576656E7431223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6F7574636F6D653D3D27E689B9E58786277D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313122206E616D653D22E68F90E4BAA4E794B3E8AFB72220736F757263655265663D22757365727461736B3322207461726765745265663D22757365727461736B36223E3C2F73657175656E6365466C6F773E0A202020203C6578636C7573697665476174657761792069643D226578636C7573697665676174657761793122206E616D653D224578636C75736976652047617465776179223E3C2F6578636C7573697665476174657761793E0A202020203C73657175656E6365466C6F772069643D22666C6F77313222206E616D653D22E689B9E587862220736F757263655265663D22757365727461736B3622207461726765745265663D226578636C75736976656761746577617931223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6F7574636F6D653D3D27E689B9E58786277D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313322206E616D653D22E8AFB7E58187E5A4A9E695B0E5B08FE4BA8EE4B889E5A4A92220736F757263655265663D226578636C7573697665676174657761793122207461726765745265663D22757365727461736B37223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B646179733C3D2733277D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313422206E616D653D22E8AFB7E58187E5A4A9E695B0E5A4A7E4BA8EE4B889E5A4A92220736F757263655265663D226578636C7573697665676174657761793122207461726765745265663D22757365727461736B34223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B646179733E2733277D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313622206E616D653D22E9A9B3E59B9E2220736F757263655265663D22757365727461736B3722207461726765745265663D22757365727461736B33223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6F7574636F6D653D3D27E9A9B3E59B9E277D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313722206E616D653D22E9A9B3E59B9E2220736F757263655265663D22757365727461736B3622207461726765745265663D22757365727461736B33223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6F7574636F6D653D3D27E9A9B3E59B9E277D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313822206E616D653D22E9A9B3E59B9E2220736F757263655265663D22757365727461736B3422207461726765745265663D22757365727461736B33223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6F7574636F6D653D3D27E9A9B3E59B9E277D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F42696C6C4E6F7465223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D2242696C6C4E6F7465222069643D2242504D4E506C616E655F42696C6C4E6F7465223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D2273746172746576656E7431222069643D2242504D4E53686170655F73746172746576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233352E30222077696474683D2233352E302220783D223133302E302220793D223238342E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B33222069643D2242504D4E53686170655F757365727461736B33223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223236302E302220793D223237342E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B34222069643D2242504D4E53686170655F757365727461736B34223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223737302E302220793D223335322E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22656E646576656E7431222069643D2242504D4E53686170655F656E646576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233352E30222077696474683D2233352E302220783D223936332E302220793D223238342E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B36222069643D2242504D4E53686170655F757365727461736B36223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223433302E302220793D223237342E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B37222069643D2242504D4E53686170655F757365727461736B37223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223737302E302220793D223138352E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226578636C75736976656761746577617931222069643D2242504D4E53686170655F6578636C75736976656761746577617931223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2234302E30222077696474683D2234302E302220783D223630302E302220793D223238312E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7734222069643D2242504D4E456467655F666C6F7734223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223136352E302220793D223330312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223236302E302220793D223330312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2234382E302220783D223138392E302220793D223238312E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7738222069643D2242504D4E456467655F666C6F7738223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223832322E302220793D223335322E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223938302E302220793D223331392E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D223836312E302220793D223333392E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773130222069643D2242504D4E456467655F666C6F773130223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223832322E302220793D223234302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223938302E302220793D223238342E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D223836342E302220793D223233392E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773131222069643D2242504D4E456467655F666C6F773131223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223336352E302220793D223330312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223433302E302220793D223330312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2234382E302220783D223336392E302220793D223238352E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773132222069643D2242504D4E456467655F666C6F773132223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223533352E302220793D223330312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223630302E302220793D223330312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D223535392E302220793D223238352E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773133222069643D2242504D4E456467655F666C6F773133223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223632302E302220793D223238312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223631392E302220793D223231342E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223737302E302220793D223231322E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2239362E302220783D223635302E302220793D223139332E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773134222069643D2242504D4E456467655F666C6F773134223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223632302E302220793D223332312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223631392E302220793D223338302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223737302E302220793D223337392E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2234322E30222077696474683D223130302E302220783D223635302E302220793D223335382E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773136222069643D2242504D4E456467655F666C6F773136223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223832322E302220793D223138352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223832322E302220793D223134382E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223331322E302220793D223134382E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223331322E302220793D223231342E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223331322E302220793D223237342E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D223533382E302220793D223132392E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773137222069643D2242504D4E456467655F666C6F773137223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223438322E302220793D223332392E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223438322E302220793D223336342E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223332332E302220793D223336342E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223331322E302220793D223332392E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D223338302E302220793D223333392E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773138222069643D2242504D4E456467655F666C6F773138223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223832322E302220793D223430372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223832322E302220793D223433362E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223331322E302220793D223433362E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223331322E302220793D223332392E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D223532322E302220793D223431392E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, '0');
|
INSERT INTO `act_ge_bytearray` VALUES ('77503', '1', 'BillNote.png', '77501', 0x89504E470D0A1A0A0000000D494844520000055B00000277080200000005F216E80000453849444154789CECDD7B6C64677D3F609310EA00690CA564A9100C6AA58C94424C83D8ED3F8D83D4AC2B5A18B588B8FCB17515015BD152B78A5AB7085C1552ABA2E0B6142D2DA456ABFCEA0A2DB5C4A52E21D48524B849489C8480C9854CD82498DC98349B64B26BEF9EDF594F182673391E7B67E6CC99F779F4CA1ACF9C3917BF9EF77CDFCFDC8622000000203C4369EF000000009002890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020000001022890000000084482200000000219208000000408824020074C5D0D050D3CB0000F409251A001D3054A3F6CAA8211A4890C27E0300044CF9054027D54DEC937F6DF3260000BA41F9054067347D4540D36B12EE0E0040CF28BF00E88CBAF97FD320A0F642DD9B05240200003DA6FC02A0331A5F11D06A99E40B0000F486F20B80CEA87BDA7FDBD708B4BA0000406F28BF00E8B0361301EF1A00004897F20B808E69FA51023E591000A03F29BF00E88056CFF6FBF6410080BEA5FC02A0C3925F2390209DDD05000895F20B808EA9FD58C1E4CF11687ADF6EEF1E0000B5945F000000102289000000008448220000000021920800000040882402000000102289000000008448220000000021920840B695CBE5E5E5E5999999B11FCBE5724300F49F787CAE8ED5F1B8BDB4B4542A95D23E8D001034890064D5F2F272A150181E1EAE5496CB3F562C16D3DE35009A88C7E7EA581D8FDBE3E3E3232323F118BEB8B898F6AE011028890064CFFAFA7AE52926452440D655E2DDD1D1D1B5B5B5B4F70580E048042063969696F2F97C5C41A6BD230074CCEAEAEAE8E8E8C2C242DA3B024058240290258B8B8B636363DE770A3078CAE5F2C4C4C4FCFC7CDA3B02404024029019C562717474541C0030A8CAE5F2D8D8D8CACA4ADA3B02402824029019FBF6ED5326020CB662B198CFE7CBE572DA3B0240102402900D8B8B8B854221EDBD00A0EBA6A6A6E6E6E6D2DE0B00822011806C181F1F5F5A5A4A7B2F00E8BAB5B5B57C3E9FF65E001004890064C0FAFAFA9E3D7BD2DE0B007AC4DBC400E80D89006480B70C0004C51B0700E80D89006480D21020288260007A43220019303636B6BCBC9CF65E00D0233E4A0080DE9008400678432940508AC5622E974B7B2F00187C1201C880B82E8CABC3B4F70280DE191A52A401D0754E369001232323A55229EDBD00A077240200F480930D6480BA102034467E007AC0C90632405D08101A233F003DE0640319A02E04088D911F801E70B2810C50170284C6C80F400F38D94006A80B014263E407A0079C6C2003D48500A131F203D0034E369001EA4280D018F901E801271BC800752140688CFC00F480930D6480BA102034467E007AC0C90632405D08101A233F003DE0640319A02E04088D911F801E70B2810C50170284C6C80F400F38D94006A80B014263E407A0079C6C2003D48500A131F203D0034E369001EA4280D018F901E801271BC800752140688CFC00F480930D6480BA102034467E007AC0C90632405D08101A233F003DE0640319A02E04088D911F801E70B2810C50170284C6C80F400F38D94006A80B014263E407A0079C6C2003D48500BD512E97171616262626C6C6C672B9DC50A8E2638FFF028542617E7EBE542AA5DD2D00748B690664C0904400A0FB969696E299F0C4C4C4D5575FFD956BAFBDE7DE7B8F6F6C84D9E2638FFF02870F1F3E70E040FC37999F9F4FBB7300E80AD30CC80089004057954AA5C9C9C9FDFBF71F79E0C8F18DE35A6D7BE4D1470E1C3810FF71D6D7D7D3EE28003ACC340332402200D03DA552697474F433577DFAF8C631AD55FBC217BFB077EFDE62B198767701D049A6199001120180EE999C9CDC8A039ED592DB57AEBDE6E28B7F25EDEE02A0934C3320032402005DB2B4B4B47FFFA51B9B65AD9DF6277F7AC595577E38ED4E03A0634C332003240200DD502E9773B9DC030F1637369FD1DA69479FFAD18517BE616D6D2DEDAE03A0334C332003240200DD303F3F3F3939B9B1F974B55D32FEEB6D7E3F5FEDBD826A575EF997D3D3D369771D009D619A0119201180A0343EE45B0D021D1C1C6A5795BCDA849D69A5533BD9718542E1F0E7FEFD2771C0A5FB7F1045F79F88EEDE88BE7D2CBAED5874F3D1CDB9CF7DF5CB0F3E71E3F1E87FCBD18DE5E8BAA7A36B9E8DFEEEBA3BDE73F0BDA94FCE5369DFBC6565747434EDAE03A033FAF7240D54F5733D0D7443E551BFED04BBEECAC665DA99A557EF5BF73379DFDAD9FFA6D7EFE8A0BA9D2CE4F3F93BEFBC7563F3A94A8B3771348A9E3A193DB1193D7E3C7A3A8AFEF8CF3F3474C64BF75D5A7870233A722C3AF26C542C47F76C469FFDC66D43A75E26F05480EDE8538F0D0F0F77BC2F00488569066480440002D774104898C3272CDFCE26BA9708EC54B747BF919191471F7B7063F368A5C59B7BFA4474ECC4A99B364F9EFAF9F92FFDD7CFFDFC2F7EE0237FB319454F6E464F6C448F6F44A528BAE6A6DBB71281A36136672580816140870C507B41B076F4DC7EDD4D8DAB6A73FDC94FCB0F5222B035AB7FB2DAE25F9FDA8C1E7B263A7EE2B9054AA5D2C73FF1A90F7FF413471E5A8F7FDD38191DDF4A0A6EF8E66D75F70DAA392B010C0C033A6480DA0B82D238156F1C041A67EFD169CCE46BEFD278A1D5F5C92B6C75D38EF42411F8BF6A3B95089C881E793AFAE1D168238A8E1F3B963FFFFCA1A133878686DFF1DB076AEF78F32DB7D6DD37A8E6AC0430300CE890016A2F084DE30CBF71B6DFF4D501752B49D6B8AD8435370D026AAF6C675BED1C7847D6D3FEE636369FA8B6A1AD770D3CF64CF4D093D1C3CF4637DFF9BDF3CE3BEFCC17BEE8EC735F31F1AEE72502377DF396BAFB06D53ADE1100A4C5800E19A0F682D0349D7E47CD66E3B553E5E49973F295B529406322D0CEE56DB755BDA9FD797EB747BFAD597DA9DAE25F9F39193D5E3EF51A81479E8DAEBD69EDF5175EF48A9F7DE5B9232FFBD4BF7CF6D9283A7A2C7AFAD8A93B5EB77253DD7D836ACE4A0003C3800E19A0F682D0243CF75EB74CD3F979E3A0D1B870D3CD6DBBE6560B27AF707792F7B923E2956F6EFEA8DA2ADB7AE6E4A94F10FCD1F1E8A127376EB8A378E12FBDE9925FFDB5878F453F2C470F97A3C78E45C7A2E8BA1B6FAABB6F50CD5909606018D02103D45E109A5DBF46A0E9BDA2D6B3EBA67143F2DA06381118BBE4E2DBBF73F7CD77ACADACAE5D7FCBDAF5B7DE75C3EDF7FEF78DDFFEC61DF77DED96BBBE7ECB77AFBFF5BB2BB7DD75C7DDDFFFE43F5EF5CECBDE99FACC5C2200C06932A04306A8BD2034BB7B8D4075F9566B6B5C3E6A31F33FCD57F29FFEA8D5E6CE9CFE5636371FAF6DEF7BDF7B1BFFE68D7EEB1DEFA8BB6350CD5909606018D02103D45E109AC6A7FDABD7D75D6E2723685C79ABCD25AC27E1EEBB5B664777EFD230B895083CA6EDB4392B010C0C033A6480DA0B42D3EA79FB84797BD39B1266F58DCBB48A18EAEE953C22252CB3ED13EF6DEE73079D4A044E3CAAEDB4392B010C0C033A6480DA0BA01BB6128147B49D36672580816140870C507B0174C35622F0B0B6D3E6AC0430300CE890016A2F806ED84A047EA8EDB4392B010C0C033A6480DA0BA01BB61281756DA7CD5909606018D02103D45E00BBB6B0B0502C169BDE241190080004CE800E19A0F602D89DBBEEBAABF22505E79C73CEE1C387EB6EDD4A047ED0D5D6CE261296697F0F9B7E7D43F70E2A95DE04A0E30CE890016A2F80DD2997CB679C7146657A7CD659675D70C105B5AF1788AF3C71E2A1AEB6A69BD8F68B181BEFDE7481DA5F6BAF4CD874A70E2ABD2E05A0930CE890016A2F805DDBB3674FED5CFAECB3CFBEFCF2CBCBE572F45C22F060575BC226AA37355E48B86FAB65B65D5B670F2AED5E05A0330CE890016A2FA09552A9B4DC35335D532814C6BA2397CB6DFB0CFCF39F6C7FA0AB2D6113C9FB53BDDCF4CAA68BF5ECE89C95000686011D3240ED05D9522E972BD3E95D4F53DB373232D2A5A975AC7B89C0E2E26297528CC60F113CF7DC73AB7FAEC296F8D0D6D6D6A2E75E2370A4ABAD9D4D345DA66656FFBCC5EA16AEFE9A70A11B0795C2E30A802E30A04306A8BD202BE219693CE11C1E1EAE4CA713A6A9F446A954AACCABF3F9FCBBDFFDEEF8E7C2C242F5D6AD39F3F7BBD72AEB6FBA958494A7710D752BA9BDB27A97C625BB7774CE4A0003C3800E19A0F682FEB7BEBE5E795E7D717131ED7DE127EEBFFFFEE1E1E1F1F1F15C2E373D3D5D2A956A6F4D3111683AED4F98F9B7BA4B633AD02A5C900800D0C8800E19A0F6823EB7B4B494CFE7979797D3DE119A585C5C9C9F9F6FFA328DAD39F3FD5D6AB52BAFDB50C20B047E3C93BF3FE1D7843537BDA61B87D6F36E04A02B0CE890016A2FE867F184736C6CACEEC96732E1D4E4F964B14BAD76E5C91BDADD9275D7344F16BA766869771D009D6140870C507B41DF2A168BA3A3A3E2808CDA9A33DFD78DD6B8E6BA6B925E20D0B058F26A1BEFD2A583AADD44DA5D07406718D02103D45ED0B7F6EDDBB7B2B292F65EB04B5B93E7EF75BCB55AED8EAEFFF1543F69C97696E9D201A6DD75007486011D3240ED05FD697171B15028A4BD17ECDED6E4F9DECEB6E47536DEFAE359FD36EB6CF652826D16E8C6D155379776D701D0190674C800B517F4A7F1F1F1A5A5A5B4F782DDDB9A33DFA3EDB4392B010C0C033A6480DA0BFAD0FAFAFA9E3D7BD2DE0B4ECB562270B7B6D3E6AC0430300CE890016A2FE843DE3230002402120180C019D02103D45ED087A6A6A6E6E6E6D2DE0B4E4B3CBA9E3C7997B6D3E6AC0430300CE890016A2FE843636363CBCBCB69EF05A7652B11F8AEB6D3E6AC0430300CE890016A2FE843BE7770006C25026BDA4E9BB312C0C030A04306A8BDA00FE572B962B198F65E705AB61281EF683B6DCE4A0003C3800E19A0F6823E343232522A95D2DE0B4ECBF0F0F033CFDC7AF2E4B7B51D35672580816140870C507B411FF2C01C00B95CEEBEFBBE7CF2E49DDA8E9A7F7E80816140870C507B411FF2C01C00E3E3E3FFB974E864F42DADFDF69DB5CFE7F3F9B4BB0E80CE50CD40069878401FF2C01C00B3B3B3D3D397A73EC7CE56FBE7F98F4C4E4EA6DD750074866A0632C0C403FA9007E60028168BF9FCEB9E29DF7C32BA436BB3150A6F595C5C4CBBEB00E80CD50C64808907F4210FCCC13073CAC193D1ED5A3BEDDF16FE7A62623CED4E03A06354339001261ED0873C300743B95C1E1B7BD3CACABF46D16D5A725B5FBF369F7F5DA9745DDA9D0640C7A86620034C3CA00F79600E8CB5B5B5D1D1F3D7D616A368556BD5D6D7AF1D1B7BD3F2F2A7D3EE2E003A4935031960E2017DC8037390ACACAC8C8E9E3F3BFB075174ABD6D816173F96CFE79697FF29ED8E02A0C354339001261ED0873C30074CB95C9E9E9E1C1BBB687EFE2FD6D7AF89A25BB452E97F1616FE6A62627FA130165F4EBB8B00E83CD50C64808907F4210FCC81B4BCBC3C39F91B7BF6FCCC1043432323E74C4C5CBAB0F05769770B00DDA29A810C1832F180FEE3814980262727D3FDEAC1EAE3AEF142C2F21EAD00AD181F21039432D0873C300950B1582C140A636363ABABABA9ECC0EE12816D17030896C11132401D037DC80393602D2F2F8F8E8E1E3C78707D7DBDC79B4E48041A5F0ED0F4AD10BDDD5F807E6758840C50C1401FF2C02470870E1DCAE7F3B3B3B3E572B9375BAC9DD56F1B0D34BD00401DE32364805206FA900726944AA5E9E9E97C3EDFB30F17A89DE4370D086A979408006CCBF80819A094813EE4810915BDFC7081A6CFFF378D03A266EF1AE8F6EE01648E9111324011037DC803136A553F5CA0542A756F2B09EF1A68BAF0B6CB0004CEF80819A094813EE481098D0E1D3A94CBE5E6E6E6BAB1F2A66F049008009C0EE32364805206FA90072634552A95A6A6A6F2F9FCD2D252C757DE6622E05D03006D323242062862A00F79604282B5B5B5F12DF1850EAEB6F1BB067DD700C0E9303E42062865A00F7960C2B6969696F2F9FCD4D454A73E5CA0F103051B3382A60B7764EB0083C7F80819A094813EE481096D9A9B9BEBC8870BB4FA42C1566F0A687CD780872D401DC32264800A06FA900726B4AFAB1F2E00C0AEA96620034C3CA00F7960C24E553F5CA0582CA6BD2F009CA29A810C30F1803EE48109BB53F97081E9E9E94E7DB80000BBA69A810C30F1803EE48109BB562E97676767F3F9FCA14387D2DE1780A0A96620034C3CA00F7960C2695A5F5F3F78F0E0E8E8E8F2F272DAFB021028D50C64808907F4210F4CE888D5D5D5B1B1B142A1E0C305007A4F35031960E2017DC803133A687171D1870B00F49E6A0632C0C403FA90072674960F1700E83DD50C64808907F4210F4CE886CA870BECDBB76F656525ED7D01187CAA19C800130FE8431E98D03D2B2B2BFBF6ED9B9898585F5F4F7B5F0006996A0632C0C403FA90072674DBC2C2422E979B99992997CB69EF0BC06052CD40069878401FF2C0841E2897CB333333B95C6E616121ED7D011840AA19C800130FE8431E98D033EBEBEB1313133E5C00A0E35433D0A7161616E2F9C6F0F0F0E8E8687C61CF9E3DF1CF17BFF8C56B6B6B69EF1A708A44007ACC870B00749C6A06FAD47FFCC77F0C35B8E4924B161717D3DE35E0148900A4C2870B0074906A06FA545CE8FCD44FFD546D1CF08637BC61CF9E3DA55229ED5D034E9108405A2A1F2E90CFE7A5E400A7493503FDEBCFFEECCF5EF8C217561381DFFBBDDF9B9E9E4E7BA780E74804205DC562B150288C8D8DADAEAEA6BD2F0059A59A81BE76DE79E755E280CB2EBB2C97CB798524F40F8900F483E5E5E5D1D1D183070FFA7001805D50CD405FFBDAD7BE76D65967C5138FF1F171AF8D84BE221180FE71E8D0A17C3E3F3B3B2B3A07D811D50CF4BBB7BCE52D954420ED1D019E4722007DA5542A4D4F4FFB7001801D51CD40BF5B5F5F8F271EBE7410FA8D4400FA900F1700D811D50C64808907F4210F4CE85BD50F17F0053D00C95433D052B95C5E5858989898181B1BCBE57243A18A8F3DFE0B140A85F9F9F9704A2BBD5F1166EFB769482200FDEDD0A143F12036373797F68E00F42FD50C34B7B4B4149711F184F0EAABAFFECAB5D7DE73EFBDC73736C26CF1B1C77F81C3870F1F387020FE9BC433C3B43BA7EBF47EC8BDDF3E8900F4BF52A934353595CFE7E3813DED7D01E847AA19A817570F939393FBF7EF3FF2C091E31BC7B5DAF6C8A38FC433C3F88F33A85FF2A4F743EEFD9D92084056ACADAD8D6FF1A13C00755433F03CF184707474F433577DFAF8C631AD55FBC217BFB077EFDE62B19876777598DE0FB9F777412200D9B2B4B494CFE7A7A6A6BC070AA04A3503CF333939B935217C564B6E5FB9F69A8B2FFE95B4BBABC3F47EC8BDBF0B1201C8A2B9B9391F2E0050A59A819F585A5ADABFFFD28DCDB2D64EFB933FBDE2CA2B3F9C76A7758CDE0FB9F77747220019E5C30500AA5433F09C72B99CCBE51E78B0B8B1F98CD64E3BFAD48F2EBCF00D83F19E4CBD1F72EFEF9A440032ADFAE102DE0605844C3503CF999F9F9F9C9CDCD87CBADA2E19FFF536BFA1ADF65E41B52BAFFCCBE9E9E9B4BBAE03F47EC8BDBF6B12011800950F178847331F2E008449354367B45F19B75AB29D3574B5FE2E140A873FF7EF3F99105EBAFF075174FF89E8EE8DE8DBC7A2DB8E45371FDD9CFBDC57BFFCE013371E8FFEB71CDD588EAE7B3ABAE6D9E8EFAEBBE33D07DF9BFAF42C95F6CD5B56464747BBD7293DA3F743EEFD5DAB7C33855904645DB95C9E9D9DCDE7F3870E1D4A7B5F007A4D2240C7349DAE579F474D5EACF1FABA7BD5AEAA562776FC39712970E79DB76E6C3E5569F1CA8F46D15327A32736A3C78F474F47D11FFFF98786CE78E9BE4B0B0F6E44478E45479E8D8AE5E89ECDE8B3DFB86DEB89E2A7026C479F7A6C7878B883BD9016BD1F72EFEF4EA954BAF8E28B3F73D55563636342011800EBEBEB070F1E1C1D1D5D5E5E4E7B5F007A47229019E572797171716666A650288CFDD8F8F8787CCDC2C2425AF568C24BA913EE927065ABBB57AE692759D8B5919191471F7B7063F368A5C5EB7FFA4474ECC4A99B364F9EFAF9F92FFDD7CFFDFC2F7EE0237FB319454F6E464F6C448F6F44F1DFFD9A9B6EDF9A131E0DB30DC60BA7F57EC8BDBF0B9538E0E66FDE727C6333FE29148081B1BABA1A3FA2E35AAB831F2E9050C2CDCFCFAFAFAF776A4300BB106831972DF159243E6D0C0F0FC72792F8E471F8F0E7BE72ED572BED0B5FFCD2073FF8A1898989783EB36FDFBEF8BCD2E37DDBE95B005AA5068D2F0748D862C75F1D505DF3C6E693D516FFFAD466F4D833D1F113CF2D1057FC1FFFC4A73EFCD14F1C79E8D4C97BE364747C6BAE78C3376FABBB6F506D30E6847A3FE4DEDFA9DA38A0D284023060E2D2AB231F2E10AF272EDE129E3EA9181D1D3D74E850B95CEED4FE03B42FC4622E43AA41753CF3AF969EADDA75D7DF70E0C0EFF4F8D56EC98940D3F97FD30BED24028D21426767235BF3BAFFABB65373C213D1234F473F3C1A6D44D1F163C7F2E79F3F3474E6D0D0F03B7EFB40ED1D6FBEE5D6BAFB06D5B64D855AC5408D4B6EDB41ED5CB9BBFF0ABDDFD9DEDFB584812261F95E06138D718050000652C2870BFCFDDFFFFD15575C917CF7B818DBB76FDFB65940AD5C2EB7B8B8D8B50302684E22D0BFE2F3503CBDFFCAB55FDD360BA8AB4AE36AF5E0C183BD499A134E6CB5CBD4DDA5F642D382BEF1D756D3830EE6025BF3BA27AA6D68EB75E38F3D133DF464F4F0B3D1CD777EEFBCF3CE3BF3852F3AFBDC574CBCEB7973C29BBE794BDD7D836AED24028D57B65A38B98312AEDFF6FF70DB95EBFD0EF6FEAEED2E11D876B14E69150708056050553E5C209EDBAFACAC54AE891FE3F180F3B297BDACD597ADC405D8E4E464DDC928AEE8FEE44FFEB4F6659E71FBE0073FB47FFFFEBA250B85826104E82589403F8ACF25131313F199664759406DFB874F7E322E4C7BF0CEB46DABF0C60512268AEDCCE8BA57F76FCDEB4AD516FFFACCC9E8F1F2A967891F7936BAF6A6B5D75F78D12B7EF695E78EBCEC53FFF2D967A3E8E8B1E8E963A7EE78DDCA4D75F70DAAB59308347668AB097CFB8B25F4A3DE4FBDF777AD717CA8BB50376EB4FF8F71FA92E300A1000CB09595957DFBF6C5B5595C597DFCE31FAF8C362323238D0FF67881BA9706BCFFFD7F78CFBDF7268C1B8F3CFA585CB6EDD9B3A77A975C2EB7BABA9ACA9102019208F49D72B91C9F4B161616761D0754DF4410AFA7839F8BD3543B33BAA8D9E4BFD5954D7F4DD850678F6573F347D55659793C2D7C6223FAD1F1E8A127376EB8A378E12FBDE9925FFDB5878F453F2C470F97A3C78E45F1ACF0BA1B6FAABB6F50AD9DCE4AE8D96D3B65DBCBED6CB79D0DE9FD8EF4FEE9A8EDB8C681A29D0BDDD34E1C201480C116D766F1BCFD852F7C6165A47AC94B5E72E9A597D62E10175DF164BE3A948D8F8F27670175B9C0073FF8A1EA7D878787ABAF4A00E82A8940DF99989838FD38A05A98EEDBB7AFAB6F1F6835EF6A2708D85122B0A3C576A76E5E3776C9C5B77FE7EE9BEF585B595DBBFE96B5EB6FBDEB86DBEFFDEF1BBFFD8D3BEEFBDA2D777DFD96EF5E7FEB77576EBBEB8EBBBFFFC97FBCEA9D97BD33F5B959BFCD096B3B3A61969E3CCFDF3611685CE7EEFE2BF47E677B7FD79AFEDB442DFE377A9608B41F07080560805D71C5157567B457BDEA551FFDE8472BB7569ED1A9DEF4912BAFDC45E576F5D5FF6F7878B8B2865C2EE76B08801E9008F497D9D9D9D379B340633B7CF8738542A14B7BDBAA52AFBD29A1ACEFCB44E0F1DAF6BEF7BD77A80DBFF58E77D4DD31A8D66667B5B94C6317B75277976D17D3FBBDECFD5D1B6A98E437EDC7569DDED99DA9D8691C20148041155768F138B367CF9E5FF8855F78E52B5F79F6D967BFFCE52F7FF5AB5F5D79327F6262A23A16C5D5D7E93C9D33323252594F3C8CA47DD0C0E09308F491D5D5D5D1D1D10EC60195F69EF7BCB7F163723B621733B1C6895CE3E5C65F5B5DD9D909C0D69CF0316DA72DA1AF93A76D432D42A276FE499A5E6EE7BF48EFF7A6F777ADF6DF66DB7E6C6799D3B4BB3840280003AC582C2E2F2FCFCCCCBCF5AD6FFDE99FFEE978FCB9E0820B161717ABE7B8DDBD3AA0B67DE18B5FAAAE6D6E6E2EED2306069C44A08F8C8E8EEEAEEE4C6E471E78F0B5AFCD75FCBD03C9B578F2958D9141DD4D8DB142E3F2DD988A6C9E7854DB696B9AD4247471D3BF7CAB05769A08B4134BE9FDAEF6FEE9680C8CA2541381C638202ED3CF3F3FDFEA8DC18F3CFAD885175EF899ABAE120A403816161672B95CF57301C7C7C73B52BC553F53205E736FBE3D0A089644A05F2C2E2E160A858EC70195F6FEF7FFA18C795B5B73C247B49DB65693B1C6D70224CCD213AE6FA5D586B65DA7DEEF41EFEF5A9B8940DD3FD52E32A06D358D032AEFEF7DED6B738DA140250EA8EC86500082B2B0B05079ECC743C491071EEC48E5F6E4D1A7AA29C3D4D454DA87080C328940BF884BC6AF5CFBD52E2502F1F9293EAFA47D88FD6E6B4EF8B0B6D3D67E2290F0976FB5406F5F2390FE1F3373ADDB8940F2AB06BAF71A818438A0A22E14A88D038402109AF8015E79E0BFFFFD7FD8C1E22D1E462AAB1D191949FB1081412611E80B71A5180FF75D8A032A6DEFDEBDBEC626D9D69CF087DA4EDBE924028DCFF66F1B1C24ACE4B45F2390FE1F3373ADAB89405DB736F672971281C638A0F6C9BAC650A0310E687CAA502800832A7E5C571FF89D7A8140B5C5E34C65CDCBCBCB691F2830B024027D617E7E7E7272B2AB89C047AEBC727A7A3AED034DDFC2C242B1586C7AD3D69C705DDB694B9EEAD73ED35BFBD47DC2E4BFD54D6D460F092BD1FBBDE9FD5DABEDB5C6DE6CDCD6503309EB4FF807A86AF55182B59FFE5D1B0ADC72EBAD4DE3802F7CF14B8D6B100AC0E0894BB8CA033F7E8077BC787BCF7B9EFBD61B251CD03D1281BE70F0E0C143870E753511F8CAB55FF51D3677DD7557E5CC7ACE39E71C3E7CB8EE5673C27E9813768FDE0FB9F7A3EDFE012A92BF59A06928F0A217BDA89D38402800832A2EE12A8FFDD3FF8A81A6C55B65E5FBF6ED4BFB4081819599626EB08D8F8FB7AA203BD5EEB9F7DED7BE3697F681A6AC5C2E9F71C6199593EB59679D75C10517D43E61B83527FC41975A65A3950BAD1668FFD784F5342ED0D5E3AAAC3FBD2EDD81747BBFCD9E6AD47E8FD7FDB3B55A4F98BD1F6DF70F10B5F745834D438136E300A1000CA4B884AB3CFCBB51C8C5C55B65E5B95CE8251CD03D9929E6065B97BE77B0B63D79F4A9B8544DFB40D357F766E0B3CF3EFBF2CB2FAF7CAF4FFCEB89130F75BC55B755FDB5EE42DDE5E46B5ACD439A6E37616D9D3DC0B47BB55D29F67EB59B9AF65AABAD375DA669D7D76D22E19F2DD8DE8F12FF01DA8903B60D05B68D0384023078E212AE320274A990AB8E30691F2830B08C2F7D21AE533BFE69344D4F2AD58FC3A5A913271EEC52ABAEBC762B95CB4DF761DBBD6ABC3EADA31B1A94FFABEEF5FEB6FF09BB5BB8EECAC68577B4ADC07BFFE28B2F6EFFDB5EFE7BF97FCE3CF3CCBA35BCE0052FB8EAAA7F6E730DDEC60503A31A35367E2969475A75FD691F2830B08C2F7D219FCF7FEBCE3B7B9008A47DA0E93BF7DC73AB157C614B5C97AFADAD45CF3D4BFC40975A75E58D5BA9BDA672B9F19ABAE5EB246FB1DB2D43FF57BDEFFD84CE4DF897D8F62EC9FF484D67BC7A3F4AFC07585D5DBDF8E28B1F79F4B16D07D2A6DF2C5051F79584096B88B71B6F31EDBF07D0017109571901BA54C855BFF734ED03050696F1A52FC4D561FB4F4FEDAEF91C81A8E62B82E2F3F7BBDFFDEEF8E7C2C242F5D6AD59D391CEB6A6D386E7CFD38ED46EB77A65ED3509D7376EAEE9AABA7168B51B4AB14FDBD7FBDEAFEBC1A6BF26F74E6DEF37DEA5D5BF44C285607B3FDAEE1F206A2F14488803DA0C05C4013060AAAF93EA4621178F1895958F8C8CA47DA0C0C0CA4C3137D82627273F73D5555D4D04AEBBFE86BD7BF7A67DA029BBFFFEFB878787C7C7C773B9DCF4F474DDFB78B7664DDFEF52ABAEBC712BB5D7342E5677A175B2D0640DD5BB74EFB82AEB4FAB4377A4F7BD9FD0594DBB2CE1DFA6D5BF505D77D7AD3CE1BF2EB4DE8FB6FB07A8480E059AC6012F78C10BDA0F05C4013078E212AEF2D8FF874F7EB2E3C5DBB7EEBCB3B2F2D1D1D1B40F1418589929E606DBDCDCDCFBDFFF875D4D043E73D555070EFC4EDA079ABEC5C5C5F9F9F9A6DF49DEE344A0712ED7746EBFEDECAEE96EF72C0EC8D69C30ADDE6FF33F61770B6FFB1F55F77F156CEF4789FF0055AD4281A671C0F0F0F0DFFDFD271A3F68B06928200E8081343B3B5B79E0C75556C78BB78F5C796565E5131313691F2830B0B254CC0DB0B842CDE5725D4D04F6EFDFBFB4B494F681F6B5AD59D3FD5D6A3F9E95DD5FFBB37A53C2E5EA35B5171A267BF5DB6ABAA1EE1D5ADA5DD7015DFA4335F654D30E4DB87BDD4A9AAEB3D57AF4FEEE348602ADE280CA370B34FDF681BA50401C00836A6D6DADF2A88FC781278F3ED5D9E22D1E8B2A2B9F9F9F4FFB4081813580C55C4675F5C305E353547CA2AA7CC916AD9C9A3E9D2C76A33D3773ABF9B5EED65637D55ED37821F9D756CB77E3E8D2EEBA0EE8D25FA9B17377D4413BBAA976858DF4FE8E348602070EFC4ED338A0D21A4381FDFBF757E706E200186CB95CAEF2C03F7CF8731D2CDEEEB9F7DEEA90E2FB4A81EE19CC622E8BBAFAC681BFF9D8C7E295A77D88FD6E6BD6745F67DB8F2763F755575EBDA67A65ED761BF7A16EE1EA1A9E3FD9AB5FF3B6ABEDEC31A6DD751DD0A53F51632FD4F55A72EFD42DB6EDBF4ADD955DEDF741EAFDA6124281BA38A03114100740507EF3377FB3F2D8BFF0C20B3BF83281B7BDFDED95D5160A85B40F111864035BCC654EB95CCEE572471E78B01B2F1078ED6B73EBEBEB691F62BFDB9A3E7DAF4BADB2F2EA266A7F6D98DE37B96375B1DA6BEA166875C7E4C53A726869775D0774E9EFD3D8B9095D9CF06FB3EDBDDA5946EFEF54D350A0691C501B0A880360205D71C5152F7FF9CB1B43F997BCE4256F7DEB5BF7ECD953F9F523575ED991E2EDBAEB6FA86EC2180274D520177399B3B0B0F0CECB2EF30281B46C4D9FEEED46FBF16CADF995B537D55D6E7A53C232DB5EDFA5A34BBBEB3AA04B7FAEC61E6CFA9FD0AA075BFDDB34040DDB2CD0D5FFEDB4BBAEBB1A438178DA9F30DE7EEBCE3BC50130907EF9977FB971687DDDEB5EF7BBBFFBBBD1D62B3D2BD70C0F0F9FFED710DE73EFBDD588E1E0C183691F3A30E006BC98CB9CB7BDFDED9D7D135A5C9E565EC396F69165C0D6ACE91E6DA76D30E6847A3FE4DE4F96FC9584AD9A3800064CB1583CF7DC736BE380FDFBF7E772B9EA8734EDDBB7AF727D3C996FF515A4EDB4B866AB7E9469BC2AAFF104BA6DF08BB96C29954A7BF7EEEDD4470C563E1F3B3E2DA57D58D9B03527BC5BDB691B8C39A1DE0FB9F7B7B5D350401C0003E9031FF8C099679E5999AB8F8C8C8C8F8F2F2E2E566F2D168BD50F138967F2C9AF276AD58E3CF060350E181E1E5E5E5E4EEF7081500451CC65CBDADADADEBD7B4F275DAE96A46F7BFBDBBFF0C52FA57D4099614E18F29C50EF87DCFBED683F141007C0E08967E6635BDEF8C63756A6EBEF7DEF7BC7C7C71B17ABBE82209ECFFFC3273FB9A3CAEDBAEB6FA8BE592036373797CAC102A109A598CB96B894BCF0C20BE313C3AEE3806FDD79E7DEBD7BC5013B129F7D4F9EBC4BDB691B8C39A1DE0FB9F7DBD44E28200E8001133F9C0B8542FCB8AE3C5DBFB0B0108F7BEF7AD7BBF6EDDBB7B6B6D6B8FCE2E262ED7791C6E55CABCF22AD7B69C03B2FBBACF62D09E200A067022AE6B2A5542AC5A5E7073FF8A19DBE79F5C9A34FFDCDC73E5679EB41DA0791315B73C2EF6A3B6D833127D4FB21F77EFB92430171000C924A16303A3A5AFBD68072B9FC9297BC249FCF273CD2D7D6D6E2056AA7F7175E78615CD135BE27F4C8030FFEC3273FB97FFFFEDA85474646BC5900E8A5B08AB96C89CF3AF1F9E3FCF3F3F10CBFCDAFB7FDCC5557C5CBBFFFFD7F1817A669EF7EF66CCD09D7B49DB6C19813EAFD907B7F475A8502E2001818F194BE310BA88AA7EBDB7EDA5FA9549A9999191E1E1E6A66EFDEBDAD6E9A9898F05182408F0557CC654E7C62989A9A1A191979DBDBDF1E4FF81B3FA826BEE6EAABFFDF3B2FBB2C5EE6C081DF29168B69EF72566DCD09BFA3EDB40DC69C50EF87DCFB3BD5180A88036030C445D4E4E4643E9F6F9A05EC545CC2C56B6B3AF36F148F212B2B2BA7BF51809D0AB198CBA272B91C9F9CE2F34AF513686B5F8AF6CECB2E5B585828954A69EF66B60D0F0F3FF3CCAD274F7E5BDB511B8C39A1DE0FB9F777A136141007C000A86401B95C6E7E7EBEB36B8E4BB8B8488B573E3A3A5A57C2C59B2B140A870E1DF2BA002045811673D0283E31DF77DF974F9EBC53DB511B8C39A1DE0FB9F777A7120ADC73EFBDE200C8B4CA33F9DDC802003221DC620EEA8C8F8FFFE7D2A193D1B7B4F6DB77D63E9FCFE7D3EEBA0ED0FB21F7FEAEBDED6D6F8B6711E200C8A8CA1B33650140E02402F09CD9D9D9E9E9CB539F6565ABFDF3FC47262727D3EEBA0ED0FB21F7FEAE85FC1209C8B46A16303737572E97D3DE1D8034A966E039C562319F7FDD33E59B4F4677686DB642E12D1DF9F8A5D4E9FD907B7FD724029039A552697A7A5A160050A59A819F9839E5E0C9E876AD9DF66F0B7F3D31319E76A7758CDE0FB9F7774722001952F946C05C2E373B3B2B0B00A852CDC04FC425C2D8D89B5656FE358A6ED392DBFAFAB5F9FCEB4AA5EBD2EEB48ED1FB21F7FEEE48042013AA5940FCD3173301D451CDC0F3ACADAD8D8E9EBFB6B61845AB5AAB164F08E3C9F3F2F2A7D3EEAE0ED3FB21F7FE2E4804A0CF95CBE5D9D95959004002D50CD45B595989A785B3B37F1045B76A8D6D71F163F97C6E79F99FD2EEA8AED0FB21F7FE4E4904A06F95CBE5B9B9B95C2E373D3D2D0B0048A09A8126E24A627A7A726CECA2F9F9BF585FBF268A6ED14AA5FF5958F8AB8989FD85C2587C39ED2EEA22BD1F72EFEF884400FA50350B989A9A5A5F5F4F7B7700FA9D6A065A5A5E5E9E9CFC8D3D7B7E6688A1A191917326262E8DA78569774B8FE8FD5AA1F57E9B862402D067E6E7E76501003BA29A810CA8FBD6F783070FFA9CE470D4F53EFD432200FDA39205C403A62C0060475433D0EF6EBCF1C678E251FB36C88B2EBAE8CD6F7EB3374606C2B4B36FE91AE807D52CA0582CA6BD2F00D9A39A817EF79AD7BC269E78FCFEEFFF7EF59A37BEF18D2F78C10B6AAF61809976F62D5D03E95A5C5CCCE7F3B20080D3A19A81BEF6B77FFBB7953772BFEA55AF5A5D5DAD5C39323252770D03CCB4B36FE91A48CBE2E2E2E8E868A150585B5B4B7B5F00B24D3503FDAB542A0D0F0F57128117BDE845175D74517CE5FAFA7ADD350C36D3CEBEA56BA0F7AA59804C1CA0235433D0BFE28AA7F6F3DE5FF39AD7CCCFCFFFD11FFD51DD3569EF26DD65DAD9B7740DF4D2F2F2F2D8D8982C00A0B35433D0A74AA552E397C0BDFAD5AF7ED5AB5E557B4DFCAB8F181C6CA69D7D4BD7406F54B280587C21ED7D011834AA19E8539FFEF4A72B73FED7BFFEF5D5F9FFF9E79F5FB9F08A57BCE2BCF3CE8B2FBCF4A52F7DF39BDF9CF6CED245A69D7D4BD740B7C90200BA4D35037DEAEB5FFF7A3CDBCFE57295CF11DCB3E5DC73CF7DF18B5F3C3A3A1AFFAC5C13DF343E3E5E2E97D3DE5FBAC5B4B36FE91AE89ED5D5D542A1200B00E836D50CF4AFB81EAA7CA35265E2115FFED297BE149747AB5B46474753DE3F7AC2B4B36FE91AE8864A16109FE3161717D3DE1780C1A79A810C683AF1181E1EF6D280109876F62D5D039DB5B6B6260B00E831D50C6440D389C7BE7DFB5656567ABF33F4986967DFD235D029C562717272329FCFCB02007A4C350319D074E2313535353737D7FB9DE9B8DAA333C56AE46FD2B7740D9CBE4A1690CBE5DAFC32DDEAE3AEF142C2F21EAD00AD181F21039A963271F1145751BDDF99D354FBD589B557460DD1408214F63B3DA11D6F86E81A381DEBEBEB3BCA022A7697086CBB1840B00C8E90014DEB98AC7FB860DD4125FFDAE64D0329B4E3CD105D03BBB3BEBE3E3535B5D32CA022211168335C3ECD9D0718308645C88056154C462B9BA6455BD36B12EE1E8ED08E3743740DEC54350B989B9BDBC587E3D6CEEAB78D069A5E00A08EF1113260B01381A64140ED85BA2776327AD4BB16DAF16688AE81F6954AA5E9E9E95D670155ADCE0E8D8FC7904F1C00ED333E42060C762290B04CF285408476BC19A26BA01DA5526966662697CBCDCECE9EFE97E6B60A8E9B2EE62D0300DB323242060C5E22D0EA891D2FFE6C14DAF16688AE8164D52C20FE195FEEC83A13DE35D074E16D9701089CF1113260C01281AA361301EF1A487B17684ED7402BE572797676B6B35940D4E28D00120180D3617C840C6855CA0C0F0F9FFE2B3053D1F4199EA6D140ABFB8623B4E3CD105D038DE2B3D2DCDC5C2E979B9E9EEE601650D56622E05D03006D32324206B42A620A85C2E2E2628F77E634B57AB6BFEE18250255A11D6F86E81AA855CD02A6A6A6D6D7D7BBB495C628D9DBCD004E87F11132A0552913D75E71E1D5E39DE9A0E4D70824486777D31057D57BF6EC497B2F682EA87F4548363F3FDFED2CA0A2EE3D65D176A792BA0B00D4313E4206B42A655657574747477BBC331D515BC9EDB47A0BAAB02B168B71919DF65ED05C50FF8AE12897CB0B0B0B131313636363F1A32F399D1C60F1B1C77F8142A1104FF5935FFC5FC902262727BB9D054489AF32ABBDA9F1FA5ADDDE49806C312C4206245430A3A3A3ABABABBDDC197A696969697C7C3CEDBDA039538BC1133FE2E2C9EDC4C4C4D5575FFD956BAFBDE7DE7B8F6F6C84D9E2638FFF02870F1F3E70E040FC3789A7FD8D7FAE6A16502C167BDD550074886A06322061E291F5370E906C664BDA7B4173128141522A95E299EDFEFDFB8F3C70E4F8C671ADB63DF2E823070E1C88FF383D781500003DA69A810C48987894CBE53D7BF674E3F39CE907E3E3E34B4B4B69EF05CD490406463C848E8E8E7EE6AA4F1FDF38A6B56A5FF8E217F6EEDDEBE500000346350319903CF1F034F2A05A5F5FCFE57219FD82C910480406C6E4E4E4561CF0AC96DCBE72ED35175FFC2B697717009DA49A810C489E78C433C67DFBF6F93481C1E32D217D4E223018969696F6EFBF7463B3ACB5D3FEE44FAFB8F2CA0FA7DD6900748C6A063260DB89C7EAEAEABE7DFB3C993C48E2DECCE572DEB5DBCF240203A0F2407BE0C1E2C6E6335A3BEDE8533FBAF0C237ACADADA5DD750074866A0632A09D89C7D2D252A150100A0C8CC9C9C9A61FEE4DFF90080C80F851163FD636369FAEB64BC67FBDCDEFE7ABBD5750EDCA2BFF727A7A3AEDAE03A033543390016D4E3C2ADF54E7530607C0DCDCDCC18307D3DE0BB6D1BD44A0E9D7AA777B1FEABEDDBDCD25EBAE6FA5533BD9718542E1F0E7FEFD2771C0A5FB7F1045F79F88EEDE88BE7D2CBAED5874F3D1CDB9CF7DF5CB0F3E71E3F1E87FCBD18DE5E8BAA7A36B9E8DFEEEBA3BDE73F0BDA94FCE5369DFBC6565747434EDAE03A033FAF7240D54B55F4F2F2C2CE4F3799F4E9F5DE572797272521C90095D9DE85656BEED04BBEECAC665DA99A557EF5BF73379DFDAD9FFA6D7EFE8A0BA9D2CC403E69D77DEBAB1F954A5C59B381A454F9D8C9ED88C1E3F1E3D1D457FFCE71F1A3AE3A5FB2E2D3CB8111D39161D79362A96A37B36A3CF7EE3B6A1532F13782AC076F4A9C78687873BDE1700A442220019B0A33A787D7D7D7C7C7CDFBE7DF3F3F3DE449021A552696E6E2E97CB79B3405674351168675B0973F884E5DBD944F712819DEAF61F796464E4D1C71EDCD83C5A69F1E69E3E111D3B71EAA6CD93A77E7EFE4BFFF5733FFF8B1FF8C8DF6C46D1939BD1131BD1E31B51298AAEB9E9F6AD44E06898AD97FFFC007495011D326017B5D7CACACAE4E4643CBD9C9898989D9D5D5E5EEEC27ED10171D7C41D542814E2CE9A9A9AF2518219D29B49D18E9EDB4FDEB7565736AE3FF969F9414A04B666F54F565BFCEB539BD163CF44C74F3CB740A954FAF8273EF5E18F7EE2C843A71E9B1B27A3E35B49C10DDFBCADEEBE41358900C0C030A04306ECBAF68AA7970B0B0BD3D3D3636363092FC4254571D7C41DB4B8B8E803203267A89B9F2330B4DD0CBFBA4CF57F293A8D997CED5D9A5E48B6A36DED48F7FEC8D5F56F6CFE5FB5C5BF3E75227AE4E9E88747A38D283A7EEC58FEFCF38786CE1C1A1A7EC76F1FA8BDE3CDB7DC5A77DFA05AB7FB05809E31A04306A8BDA00F0D0F0F77EF8D398D33FCC619F850B35707D4ADA49D997CEDB6DA5973AB0860A7A9C1E9EC73A70C9D9AD53F516D435BEF1A78EC99E8A127A3879F8D6EBEF37BE79D77DE992F7CD1D9E7BE62E25DCF4B046EFAE62D75F70DAA75BC2300488B011D3240ED057D2897CB158BC52EAD7CA8E189FAC65F873AF11A81A629404222901C16246FAB7A53FBF3FC6E8F7E5BB3FA52B5C5BF3E73327ABC7CEA35028F3C1B5D7BD3DAEB2FBCE8153FFBCA73475EF6A97FF9ECB35174F458F4F4B15377BC6EE5A6BAFB06D59C95000686011D3240ED057D687474747575B54B2BAF9DA8B79A3C374ECE5BE5084D176EBAB96D173EFD44A07D6D6EEB3437B1B9F9A36AAB6CEB9993A73E41F047C7A3879EDCB8E18EE285BFF4A64B7EF5D71E3E16FDB01C3D5C8E1E3B161D8BA2EB6EBCA9EEBE4135672580816140870C507B411F1A1B1BEBDE6776EEFA35024DEF15B59E5D378D1B12166E7A3961FF4F47EF1381B14B2EBEFD3B77DF7CC7DACAEADAF5B7AC5D7FEB5D37DC7EEF7FDFF8ED6FDC71DFD76EB9EBEBB77CF7FA5BBFBB72DB5D77DCFDFD4FFEE355EFBCEC9DA9CFCC2502009C26033A6480DA0BFAD0E4E464F7BE2A7277AF11A82EDF6A6D8DCB472D7284841708242CD0E6ADED687F5BA7B995CDCDC76BDBFBDEF7DEC6BF79A3DF7AC73BEAEE185473560218180674C800B517F4A1F9F9F9C9C9C92EADBCF169FFEAF57597DBC9081A57DE6A73A7B99E766E6AC78EB6759A1BDADC7C4CDB6973560218180674C800B517F4A1B5B5B57C3EDFA595B77ADE3E61DEDEF4A656A3476DE290F06681F6D753774DAB971824DBE9B64EDFA944E0C4A3DA4E9BB312C0C030A04306A8BDA03F75F5C305E981AD44E0116DA7CD5909606018D02103D45ED09FE6E6E6A6A6A6D2DE0B766F2B117858DB6973560218180674C800B517F4A772B99CCBE5D6D7D7D3DE1176692B11F8A1B6D3E6AC0430300CE890016A2FE85BCBCBCB63636369EF05491616168AC562D39BB61281756DA7CD5909606018D02103D45ED0CF666666BC77A06FDD75D75D958F243CE79C730E1F3E5C77AB444022001038033A6480DA0BFADCF4F4F4F8F878A9544A7B47A8572E97CF38E38C4A2870D659675D70C105B5AF17D84A047ED09BD6B8AD76AE49585BA35E1E4B7A5D0A402719D02103D45ED0FF96969672B9DCCCCC8C8F15E8377BF6ECA99D369F7DF6D9975F7E79B95C8EB646D713271EEA59ABDD5CD34D57AFAC9BEAD75D59B764C20ABB772069F72A009D6140870C507B4126944AA59999995C2E373E3E1E5F585E5EEECD4697BB66A66B0A85C25877C47FFFA6CF9FB772E2C4833D68EDEC40D39DA9BBB2FA6BC285DE1C4E0FFEB701E801033A6480DA0B32A45C2E2F2D2DC593DE7876BAA3A9E9EE8C8C8C74696A1DEB5E22B0B8B8D8A514A3F14304CF3DF7DCEA9FABB0253EB4B5B5B5E8B9D7083CD083D66A43D5EB1B2F34BD57ED628D7A732C95ADA7F0D002A00B0CE890016A2F80DD29954A95D9723E9F7FF7BBDF1DFF5C5858A8DEBA358B3ED283D66A43D5EB6B66F5CFBBA9EE8EB5CBB7BAD09BC349B14F01E820033A6480DA0B6077EEBFFFFEE1E1E1F1F1F15C2E373D3D5DF7E98F5BB3E8EFF7A0B5DA50DDF5D55F6BAFAFBDF2C7A94193257B762C956DA5D5A1007496011D3240ED05B06B8B8B8BF3F3F38DEF26887A9B08B4921C07B4BA297955120100DA6440870C507B0174C3D62CFAFE7E68CF9FD8DFDF30D5FFC9628D774C656FD3EE3A003AC3800E19A0F602E88653D3E993C51EB7DA8D26EF40E3ADD56B9ABF46A087879076D701D0190674C800B51740376CCDA2EFEB41AB6CA8BAB9DAEDD65D6E7553D3059A2ED39BC349BBEB00E80C033A6480DA0BA01BB6A6D3DFEB41AB6CA86E73B557FE78AADFE45EB5BF6EBB4CCF0E27EDAE03A0330CE890016A2F806ED89A4EDFDBED56BB9586D7F9375FBED93B02B659A037C752DD81B4BB0E80CE30A04306A8BD00BA616B167D8FB6D3E6AC0430300CE890016A2F806ED84A04EED676DA9C95000686011D3240ED05D00D1201890040E00CE890016A2F806E8847D79327EFD276DA9C95000686011D3240ED05D00D5B89C077B59D36672580816140870C507B0174C35622B0A6EDB4392B010C0C033A6480DA0BA01BB61281EF683B6DCE4A0003C3800E19A0F602E886E1E1E1679EB9F5E4C96F6B3B6ACE4A0003C3800E19A0F602E8865C2E77DF7D5F3E79F24E6D47CD5909606018D02103D45E00DD303E3EFE9F4B874E46DFD2DA6FDF59FB7C3E9F4FBBEB00E80CD30CC80089004037CCCECE4E4F5F9EFA1C3B5BED9FE73F3239399976D701D019A61990011201806E28168BF9FCEB9E29DF7C32BA436BB3150A6F595C5C4CBBEB00E80CD30CC80089004097CC9C72F06474BBD64EFBB785BF9E98184FBBD300E818D30CC8008900409794CBE5B1B137ADACFC6B14DDA625B7F5F56BF3F9D7954AD7A5DD6900748C690664804400A07BD6D6D64647CF5F5B5B8CA255AD555B5FBF766CEC4DCBCB9F4EBBBB00E824D30CC80089004057ADACAC8C8E9E3F3BFB075174ABD6D816173F96CFE79697FF29ED8E02A0C34C332003240200DD562E97A7A727C7C62E9A9FFF8BF5F56BA2E816AD54FA9F8585BF9A98D85F288CC597D3EE22003ACF340332402200D01BCBCBCB9393BFB167CFCF0C3134343272CEC4C4A50B0B7F9576B700D02DA619900143120180C04C4E4EA6BD0B000C3ED30CC800890040688CFC00F480930D6480BA102034467E007AC0C90632405D08101A233F003DE0640319A02E04088D911F801E70B2810C50170284C6C80F400F38D94006A80B014263E407A0079C6C2003D48500A131F203D0034E369001EA4280D018F901E801271BC800752140688CFC00F480930D6480BA102034467E007AC0C90632405D08101A233F003DE0640319A02E04088D911F801E70B2810C50170284C6C80F400F38D940060C0F0F97CBE5B4F782D0D5CE4FCC55A0DB3CCA00E801271BC8805C2E572C16D3DE0BC23254A3F6CAA8211A4890C27EC3A0F00802A0079C6C2003464747575757D3DE0B0255372D49FEB5CD9B8064EBEBEB7BF6EC497B2F00187CCA35C880B1B1B1E5E5E5B4F782E0347D4540D36B12EE0EEC42B158CCE57269EF0500834FB90619303939393F3F9FF65E109CBAF97FD320A0F642DD9B052402B06B4B4B4BE3E3E369EF0500834FB90619303F3F3F393999F65E109CC65704B45A26F902B053335BD2DE0B00069F720D32606D6D2D9FCFA7BD1704A7EE69FF6D5F23D0EA02B053E3E3E34B4B4B69EF0500834FB906D9E0C30549519B8980770D4047ACAFAFE772395F3A0B400F28D7201BE6E6E6A6A6A6D2DE0B82D3F4A3047CB2207495011F809E51AE413694CBE55C2EB7BEBE9EF68E108A56CFF6FBF641E82AA33D00BDA45C83CC585E5E1E1B1B4B7B2F0851F26B0412A4B3BB9065BE5C06805E52AE4196CCCCCC782929BD54FBB182C99F23D0F4BEDDDE3D1830737373070F1E4C7B2F000888720D32667A7A7A7C7CBC542AA5BD2300744CB95C9E9C9C140700D0631201C89EA5A5A55C2E373333E38DA60059572A95E6E6E6E251DD9B0500E83D890064525C41CECCCCC415E4F8F8787C61797939ED3D026007E2717B7676B65028C423F9D4D49484178054480420C3CAE5F2D2D2D2CCCCCCD8D858F207BC01D057E2717B7A7A7A7171D1BBC0004891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080104904000000204412010000000891440000000042241100000080FFDF8E1D080000000008F2B71EE4C2E8C808000000C09111000000802323000000004746000000008E8C000000001C1901000000383202000000706404000000E0C808000000C09111000000802323000000004746000000008E8C000000001C1901000000383202000000706404000000E0C808000000C09111000000802323000000004746000000008E8C000000001C1901000000383202000000706404000000E0C808000000C09111000000802323000000004746000000008E8C000000001C1901000000383202000000706404000000E0C808000000C09111000000802323000000004746000000008E8C000000001C1901000000383202000000706404000000E0C808000000C09111000000802323000000004746000000008E8C000000001C1901000000383202000000706404000000E028E86AE6F1C2A6640C0000000049454E44AE426082, '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', '80001', '33');
|
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(5.22.0.0)', '1');
|
INSERT INTO `act_ge_property` VALUES ('schema.version', '5.22.0.0', '1');
|
|
-- ----------------------------
|
-- 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(255) COLLATE utf8_bin DEFAULT NULL,
|
`START_TIME_` datetime NOT NULL,
|
`END_TIME_` datetime DEFAULT NULL,
|
`DURATION_` bigint(20) DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
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
|
-- ----------------------------
|
INSERT INTO `act_hi_actinst` VALUES ('77506', 'BillNote:1:77504', '77505', '77505', 'startevent1', null, null, 'Start', 'startEvent', null, '2018-01-03 11:44:32', '2018-01-03 11:44:32', '5', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77509', 'BillNote:1:77504', '77505', '77505', 'usertask3', '77510', null, '我的请求', 'userTask', 'cc', '2018-01-03 11:44:32', null, null, '');
|
INSERT INTO `act_hi_actinst` VALUES ('77513', 'BillNote:1:77504', '77512', '77512', 'startevent1', null, null, 'Start', 'startEvent', null, '2018-01-03 11:44:46', '2018-01-03 11:44:46', '3', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77516', 'BillNote:1:77504', '77512', '77512', 'usertask3', '77517', null, '我的请求', 'userTask', 'cc', '2018-01-03 11:44:46', '2018-01-03 11:44:54', '8861', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77520', 'BillNote:1:77504', '77512', '77512', 'usertask6', '77521', null, '部门经理', 'userTask', 'c', '2018-01-03 11:44:54', '2018-01-03 11:45:55', '61876', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77524', 'BillNote:1:77504', '77523', '77523', 'startevent1', null, null, 'Start', 'startEvent', null, '2018-01-03 11:45:30', '2018-01-03 11:45:30', '3', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77527', 'BillNote:1:77504', '77523', '77523', 'usertask3', '77528', null, '我的请求', 'userTask', 'cc', '2018-01-03 11:45:30', '2018-01-03 11:45:39', '9248', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77531', 'BillNote:1:77504', '77523', '77523', 'usertask6', '77532', null, '部门经理', 'userTask', 'c', '2018-01-03 11:45:39', null, null, '');
|
INSERT INTO `act_hi_actinst` VALUES ('77538', 'BillNote:1:77504', '77512', '77512', 'exclusivegateway1', null, null, 'Exclusive Gateway', 'exclusiveGateway', null, '2018-01-03 11:45:55', '2018-01-03 11:45:55', '1', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77539', 'BillNote:1:77504', '77512', '77512', 'usertask7', '77540', null, '人事经理', 'userTask', 'b', '2018-01-03 11:45:55', null, null, '');
|
INSERT INTO `act_hi_actinst` VALUES ('77543', 'BillNote:1:77504', '77542', '77542', 'startevent1', null, null, 'Start', 'startEvent', null, '2018-01-03 11:46:58', '2018-01-03 11:46:58', '2', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77546', 'BillNote:1:77504', '77542', '77542', 'usertask3', '77547', null, '我的请求', 'userTask', 'aa', '2018-01-03 11:46:58', '2018-01-03 11:47:01', '3646', '');
|
INSERT INTO `act_hi_actinst` VALUES ('77550', 'BillNote:1:77504', '77542', '77542', 'usertask6', '77551', null, '部门经理', 'userTask', 'a', '2018-01-03 11:47:01', null, null, '');
|
|
-- ----------------------------
|
-- 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,
|
`TIME_` datetime 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
|
-- ----------------------------
|
INSERT INTO `act_hi_comment` VALUES ('77534', 'comment', '2018-01-03 11:45:55', null, '77521', '77512', 'AddComment', '', '');
|
|
-- ----------------------------
|
-- 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
|
-- ----------------------------
|
INSERT INTO `act_hi_identitylink` VALUES ('77511', null, 'participant', 'cc', null, '77505');
|
INSERT INTO `act_hi_identitylink` VALUES ('77518', null, 'participant', 'cc', null, '77512');
|
INSERT INTO `act_hi_identitylink` VALUES ('77522', null, 'participant', 'c', null, '77512');
|
INSERT INTO `act_hi_identitylink` VALUES ('77529', null, 'participant', 'cc', null, '77523');
|
INSERT INTO `act_hi_identitylink` VALUES ('77533', null, 'participant', 'c', null, '77523');
|
INSERT INTO `act_hi_identitylink` VALUES ('77541', null, 'participant', 'b', null, '77512');
|
INSERT INTO `act_hi_identitylink` VALUES ('77548', null, 'participant', 'aa', null, '77542');
|
INSERT INTO `act_hi_identitylink` VALUES ('77552', null, 'participant', 'a', null, '77542');
|
|
-- ----------------------------
|
-- 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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
|
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
|
-- ----------------------------
|
INSERT INTO `act_hi_procinst` VALUES ('77505', '77505', 'BillNote.27', 'BillNote:1:77504', '2018-01-03 11:44:32', null, null, null, 'startevent1', null, null, null, '', null);
|
INSERT INTO `act_hi_procinst` VALUES ('77512', '77512', 'BillNote.28', 'BillNote:1:77504', '2018-01-03 11:44:46', null, null, null, 'startevent1', null, null, null, '', null);
|
INSERT INTO `act_hi_procinst` VALUES ('77523', '77523', 'BillNote.29', 'BillNote:1:77504', '2018-01-03 11:45:30', null, null, null, 'startevent1', null, null, null, '', null);
|
INSERT INTO `act_hi_procinst` VALUES ('77542', '77542', 'BillNote.30', 'BillNote:1:77504', '2018-01-03 11:46:58', null, null, null, 'startevent1', null, null, null, '', null);
|
|
-- ----------------------------
|
-- 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,
|
`CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_taskinst
|
-- ----------------------------
|
INSERT INTO `act_hi_taskinst` VALUES ('77510', 'BillNote:1:77504', 'usertask3', '77505', '77505', '我的请求', null, null, null, 'cc', '2018-01-03 11:44:32', null, null, null, null, '50', null, null, null, '');
|
INSERT INTO `act_hi_taskinst` VALUES ('77517', 'BillNote:1:77504', 'usertask3', '77512', '77512', '我的请求', null, null, null, 'cc', '2018-01-03 11:44:46', null, '2018-01-03 11:44:54', '8857', 'completed', '50', null, null, null, '');
|
INSERT INTO `act_hi_taskinst` VALUES ('77521', 'BillNote:1:77504', 'usertask6', '77512', '77512', '部门经理', null, null, null, 'c', '2018-01-03 11:44:54', null, '2018-01-03 11:45:55', '61866', 'completed', '50', null, null, null, '');
|
INSERT INTO `act_hi_taskinst` VALUES ('77528', 'BillNote:1:77504', 'usertask3', '77523', '77523', '我的请求', null, null, null, 'cc', '2018-01-03 11:45:30', null, '2018-01-03 11:45:39', '9239', 'completed', '50', null, null, null, '');
|
INSERT INTO `act_hi_taskinst` VALUES ('77532', 'BillNote:1:77504', 'usertask6', '77523', '77523', '部门经理', null, null, null, 'c', '2018-01-03 11:45:39', null, null, null, null, '50', null, null, null, '');
|
INSERT INTO `act_hi_taskinst` VALUES ('77540', 'BillNote:1:77504', 'usertask7', '77512', '77512', '人事经理', null, null, null, 'b', '2018-01-03 11:45:55', null, null, null, null, '50', null, null, null, '');
|
INSERT INTO `act_hi_taskinst` VALUES ('77547', 'BillNote:1:77504', 'usertask3', '77542', '77542', '我的请求', null, null, null, 'aa', '2018-01-03 11:46:58', null, '2018-01-03 11:47:01', '3643', 'completed', '50', null, null, null, '');
|
INSERT INTO `act_hi_taskinst` VALUES ('77551', 'BillNote:1:77504', 'usertask6', '77542', '77542', '部门经理', null, null, null, 'a', '2018-01-03 11:47:01', null, null, null, null, '50', null, null, null, '');
|
|
-- ----------------------------
|
-- 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,
|
`CREATE_TIME_` datetime DEFAULT NULL,
|
`LAST_UPDATED_TIME_` datetime 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_`),
|
KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_varinst
|
-- ----------------------------
|
INSERT INTO `act_hi_varinst` VALUES ('77507', '77505', '77505', null, 'objId', 'string', '0', null, null, null, 'BillNote.27', null, '2018-01-03 11:44:32', '2018-01-03 11:44:32');
|
INSERT INTO `act_hi_varinst` VALUES ('77508', '77505', '77505', null, 'user', 'string', '0', null, null, null, 'cc', null, '2018-01-03 11:44:32', '2018-01-03 11:44:32');
|
INSERT INTO `act_hi_varinst` VALUES ('77514', '77512', '77512', null, 'objId', 'string', '0', null, null, null, 'BillNote.28', null, '2018-01-03 11:44:46', '2018-01-03 11:44:46');
|
INSERT INTO `act_hi_varinst` VALUES ('77515', '77512', '77512', null, 'user', 'string', '0', null, null, null, 'cc', null, '2018-01-03 11:44:46', '2018-01-03 11:44:46');
|
INSERT INTO `act_hi_varinst` VALUES ('77519', '77512', '77512', null, 'deptMag', 'string', '0', null, null, null, 'c', null, '2018-01-03 11:44:54', '2018-01-03 11:44:54');
|
INSERT INTO `act_hi_varinst` VALUES ('77525', '77523', '77523', null, 'objId', 'string', '0', null, null, null, 'BillNote.29', null, '2018-01-03 11:45:30', '2018-01-03 11:45:30');
|
INSERT INTO `act_hi_varinst` VALUES ('77526', '77523', '77523', null, 'user', 'string', '0', null, null, null, 'cc', null, '2018-01-03 11:45:30', '2018-01-03 11:45:30');
|
INSERT INTO `act_hi_varinst` VALUES ('77530', '77523', '77523', null, 'deptMag', 'string', '0', null, null, null, 'c', null, '2018-01-03 11:45:39', '2018-01-03 11:45:39');
|
INSERT INTO `act_hi_varinst` VALUES ('77535', '77512', '77512', null, 'days', 'long', '0', null, null, '1', '1', null, '2018-01-03 11:45:55', '2018-01-03 11:45:55');
|
INSERT INTO `act_hi_varinst` VALUES ('77536', '77512', '77512', null, 'personnel', 'string', '0', null, null, null, 'b', null, '2018-01-03 11:45:55', '2018-01-03 11:45:55');
|
INSERT INTO `act_hi_varinst` VALUES ('77537', '77512', '77512', null, 'outcome', 'string', '0', null, null, null, '批准', null, '2018-01-03 11:45:55', '2018-01-03 11:45:55');
|
INSERT INTO `act_hi_varinst` VALUES ('77544', '77542', '77542', null, 'objId', 'string', '0', null, null, null, 'BillNote.30', null, '2018-01-03 11:46:58', '2018-01-03 11:46:58');
|
INSERT INTO `act_hi_varinst` VALUES ('77545', '77542', '77542', null, 'user', 'string', '0', null, null, null, 'aa', null, '2018-01-03 11:46:58', '2018-01-03 11:46:58');
|
INSERT INTO `act_hi_varinst` VALUES ('77549', '77542', '77542', null, 'deptMag', 'string', '0', null, null, null, 'a', null, '2018-01-03 11:47:01', '2018-01-03 11:47:01');
|
|
-- ----------------------------
|
-- 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
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_procdef_info`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_procdef_info`;
|
CREATE TABLE `act_procdef_info` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
|
KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
|
KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
|
CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_procdef_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
`DEPLOY_TIME_` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_re_deployment
|
-- ----------------------------
|
INSERT INTO `act_re_deployment` VALUES ('77501', null, null, '', '2018-01-03 11:43:56');
|
|
-- ----------------------------
|
-- 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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
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,
|
`HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
|
`SUSPENSION_STATE_` int(11) DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_re_procdef
|
-- ----------------------------
|
INSERT INTO `act_re_procdef` VALUES ('BillNote:1:77504', '1', 'http://www.activiti.org/test', '请假流程', 'BillNote', '1', '77501', 'BillNote.bpmn', 'BillNote.png', null, '0', '1', '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,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`LOCK_TIME_` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
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_`),
|
KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
|
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
|
-- ----------------------------
|
INSERT INTO `act_ru_execution` VALUES ('77505', '1', '77505', 'BillNote.27', null, 'BillNote:1:77504', null, 'usertask3', '1', '0', '1', '0', '1', '2', '', null, null);
|
INSERT INTO `act_ru_execution` VALUES ('77512', '3', '77512', 'BillNote.28', null, 'BillNote:1:77504', null, 'usertask7', '1', '0', '1', '0', '1', '2', '', null, null);
|
INSERT INTO `act_ru_execution` VALUES ('77523', '2', '77523', 'BillNote.29', null, 'BillNote:1:77504', null, 'usertask6', '1', '0', '1', '0', '1', '2', '', null, null);
|
INSERT INTO `act_ru_execution` VALUES ('77542', '2', '77542', 'BillNote.30', null, 'BillNote:1:77504', null, 'usertask6', '1', '0', '1', '0', '1', '2', '', null, null);
|
|
-- ----------------------------
|
-- 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
|
-- ----------------------------
|
INSERT INTO `act_ru_identitylink` VALUES ('77511', '1', null, 'participant', 'cc', null, '77505', null);
|
INSERT INTO `act_ru_identitylink` VALUES ('77518', '1', null, 'participant', 'cc', null, '77512', null);
|
INSERT INTO `act_ru_identitylink` VALUES ('77522', '1', null, 'participant', 'c', null, '77512', null);
|
INSERT INTO `act_ru_identitylink` VALUES ('77529', '1', null, 'participant', 'cc', null, '77523', null);
|
INSERT INTO `act_ru_identitylink` VALUES ('77533', '1', null, 'participant', 'c', null, '77523', null);
|
INSERT INTO `act_ru_identitylink` VALUES ('77541', '1', null, 'participant', 'b', null, '77512', null);
|
INSERT INTO `act_ru_identitylink` VALUES ('77548', '1', null, 'participant', 'aa', null, '77542', null);
|
INSERT INTO `act_ru_identitylink` VALUES ('77552', '1', null, 'participant', 'a', null, '77542', null);
|
|
-- ----------------------------
|
-- 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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
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 NULL DEFAULT NULL,
|
`DUE_DATE_` datetime DEFAULT NULL,
|
`CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`SUSPENSION_STATE_` int(11) DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
`FORM_KEY_` varchar(255) COLLATE utf8_bin 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
|
-- ----------------------------
|
INSERT INTO `act_ru_task` VALUES ('77510', '1', '77505', '77505', 'BillNote:1:77504', '我的请求', null, null, 'usertask3', null, 'cc', null, '50', '2018-01-03 11:44:32', null, null, '1', '', null);
|
INSERT INTO `act_ru_task` VALUES ('77532', '1', '77523', '77523', 'BillNote:1:77504', '部门经理', null, null, 'usertask6', null, 'c', null, '50', '2018-01-03 11:45:39', null, null, '1', '', null);
|
INSERT INTO `act_ru_task` VALUES ('77540', '1', '77512', '77512', 'BillNote:1:77504', '人事经理', null, null, 'usertask7', null, 'b', null, '50', '2018-01-03 11:45:55', null, null, '1', '', null);
|
INSERT INTO `act_ru_task` VALUES ('77551', '1', '77542', '77542', 'BillNote:1:77504', '部门经理', null, null, 'usertask6', null, 'a', null, '50', '2018-01-03 11:47:01', null, null, '1', '', null);
|
|
-- ----------------------------
|
-- 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
|
-- ----------------------------
|
INSERT INTO `act_ru_variable` VALUES ('77507', '1', 'string', 'objId', '77505', '77505', null, null, null, null, 'BillNote.27', null);
|
INSERT INTO `act_ru_variable` VALUES ('77508', '1', 'string', 'user', '77505', '77505', null, null, null, null, 'cc', null);
|
INSERT INTO `act_ru_variable` VALUES ('77514', '1', 'string', 'objId', '77512', '77512', null, null, null, null, 'BillNote.28', null);
|
INSERT INTO `act_ru_variable` VALUES ('77515', '1', 'string', 'user', '77512', '77512', null, null, null, null, 'cc', null);
|
INSERT INTO `act_ru_variable` VALUES ('77519', '1', 'string', 'deptMag', '77512', '77512', null, null, null, null, 'c', null);
|
INSERT INTO `act_ru_variable` VALUES ('77525', '1', 'string', 'objId', '77523', '77523', null, null, null, null, 'BillNote.29', null);
|
INSERT INTO `act_ru_variable` VALUES ('77526', '1', 'string', 'user', '77523', '77523', null, null, null, null, 'cc', null);
|
INSERT INTO `act_ru_variable` VALUES ('77530', '1', 'string', 'deptMag', '77523', '77523', null, null, null, null, 'c', null);
|
INSERT INTO `act_ru_variable` VALUES ('77535', '1', 'long', 'days', '77512', '77512', null, null, null, '1', '1', null);
|
INSERT INTO `act_ru_variable` VALUES ('77536', '1', 'string', 'personnel', '77512', '77512', null, null, null, null, 'b', null);
|
INSERT INTO `act_ru_variable` VALUES ('77537', '1', 'string', 'outcome', '77512', '77512', null, null, null, null, '批准', null);
|
INSERT INTO `act_ru_variable` VALUES ('77544', '1', 'string', 'objId', '77542', '77542', null, null, null, null, 'BillNote.30', null);
|
INSERT INTO `act_ru_variable` VALUES ('77545', '1', 'string', 'user', '77542', '77542', null, null, null, null, 'aa', null);
|
INSERT INTO `act_ru_variable` VALUES ('77549', '1', 'string', 'deptMag', '77542', '77542', null, null, null, null, 'a', null);
|
|
-- ----------------------------
|
-- Table structure for `tb_bill`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_bill`;
|
CREATE TABLE `tb_bill` (
|
`bill_id` int(11) NOT NULL AUTO_INCREMENT,
|
`user_id` int(11) DEFAULT NULL,
|
`name` varchar(255) DEFAULT NULL,
|
`type` varchar(255) DEFAULT NULL,
|
`reason` varchar(255) DEFAULT NULL,
|
`startTime` varchar(255) DEFAULT NULL,
|
`endTime` varchar(255) DEFAULT NULL,
|
`reMark` varchar(255) DEFAULT NULL,
|
`status` varchar(255) DEFAULT NULL,
|
`optTime` datetime DEFAULT NULL,
|
`optName` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`bill_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_bill
|
-- ----------------------------
|
INSERT INTO `tb_bill` VALUES ('27', '18', 'cc', '公休', 'fd', '2018-01-03 11:44:27', '2018-01-04 11:44:29', 'df', '初始录入', null, null);
|
INSERT INTO `tb_bill` VALUES ('28', '18', 'cc', '病假', 'fd', '2018-01-12 11:44:38', '2018-01-13 11:44:40', 'fff', '部门经理已批准', '2018-01-03 11:44:54', 'c');
|
INSERT INTO `tb_bill` VALUES ('29', '18', 'cc', '婚假', 'f', '2018-02-09 11:45:09', '2018-03-01 11:45:11', 'sss', '审核中', '2018-01-03 11:45:39', null);
|
INSERT INTO `tb_bill` VALUES ('30', '16', 'aa', '公休', 'fg', '2018-01-03 11:46:52', '2018-01-04 11:46:54', 'der', '审核中', '2018-01-03 11:47:01', null);
|
|
-- ----------------------------
|
-- Table structure for `tb_dept`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_dept`;
|
CREATE TABLE `tb_dept` (
|
`dept_id` int(11) NOT NULL AUTO_INCREMENT,
|
`dept_name` varchar(255) NOT NULL,
|
`dept_desc` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`dept_id`),
|
UNIQUE KEY `dept_name` (`dept_name`)
|
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_dept
|
-- ----------------------------
|
INSERT INTO `tb_dept` VALUES ('1', '市场部', '市场');
|
INSERT INTO `tb_dept` VALUES ('2', '人事部', '人事');
|
INSERT INTO `tb_dept` VALUES ('3', 'it部', '技术');
|
INSERT INTO `tb_dept` VALUES ('4', '董事', '董事');
|
INSERT INTO `tb_dept` VALUES ('6', 'fdffds', 'fd');
|
INSERT INTO `tb_dept` VALUES ('7', '111', '');
|
INSERT INTO `tb_dept` VALUES ('11', '组织部', 'wwwwwwww');
|
|
-- ----------------------------
|
-- Table structure for `tb_dept_opt`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_dept_opt`;
|
CREATE TABLE `tb_dept_opt` (
|
`dopt_id` int(11) NOT NULL AUTO_INCREMENT,
|
`d_id` int(11) DEFAULT NULL,
|
`dopt_name` varchar(255) DEFAULT NULL,
|
`dopt_type` varchar(255) DEFAULT NULL,
|
`dopt_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`dopt_id`),
|
KEY `did` (`d_id`),
|
CONSTRAINT `did` FOREIGN KEY (`d_id`) REFERENCES `tb_dept` (`dept_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_dept_opt
|
-- ----------------------------
|
INSERT INTO `tb_dept_opt` VALUES ('6', '6', 'admins', '添加', '2017-12-18 13:14:35');
|
INSERT INTO `tb_dept_opt` VALUES ('7', '7', 'admins', '添加', '2017-12-18 13:17:10');
|
INSERT INTO `tb_dept_opt` VALUES ('11', '7', 'admins', '更新', '2017-12-18 13:29:25');
|
INSERT INTO `tb_dept_opt` VALUES ('12', '7', 'admins', '更新', '2017-12-18 14:11:23');
|
INSERT INTO `tb_dept_opt` VALUES ('13', '11', 'admins', '添加', '2017-12-18 14:11:51');
|
INSERT INTO `tb_dept_opt` VALUES ('15', '11', 'admins', '更新', '2017-12-18 15:16:23');
|
INSERT INTO `tb_dept_opt` VALUES ('16', '6', 'admins', '更新', '2017-12-18 15:16:54');
|
INSERT INTO `tb_dept_opt` VALUES ('18', '7', 'admins', '更新', '2017-12-20 16:35:21');
|
INSERT INTO `tb_dept_opt` VALUES ('19', '11', 'admins', '更新', '2017-12-21 10:07:32');
|
|
-- ----------------------------
|
-- Table structure for `tb_menu`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_menu`;
|
CREATE TABLE `tb_menu` (
|
`menu_id` int(11) NOT NULL AUTO_INCREMENT,
|
`menu_name` varchar(255) DEFAULT NULL,
|
`url` varchar(255) DEFAULT NULL,
|
`parentID` int(11) DEFAULT NULL,
|
`icon` varchar(255) DEFAULT NULL,
|
`statu` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`menu_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=1106 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_menu
|
-- ----------------------------
|
INSERT INTO `tb_menu` VALUES ('1', '系统管理', null, '0', 'fa fa-cog', '0');
|
INSERT INTO `tb_menu` VALUES ('2', '流程管理', null, '0', 'fa fa-random', '0');
|
INSERT INTO `tb_menu` VALUES ('3', '报表管理', 'user/goChar.action', '0', 'fa fa-list-alt', '0');
|
INSERT INTO `tb_menu` VALUES ('101', '菜单管理', 'user/goMenu.action', '1', 'fa fa-th-large', '0');
|
INSERT INTO `tb_menu` VALUES ('102', '用户管理', 'user/goUser.action', '1', 'fa fa-user', '0');
|
INSERT INTO `tb_menu` VALUES ('103', '部门管理', 'dept/goDept.action', '1', 'fa fa-home', '0');
|
INSERT INTO `tb_menu` VALUES ('104', '角色管理', 'user/goRole.action', '1', 'fa fa-globe', '0');
|
INSERT INTO `tb_menu` VALUES ('105', '权限管理', 'user/goAuth.action', '1', 'fa fa-lock', '1');
|
INSERT INTO `tb_menu` VALUES ('201', '我的请求', 'activiti/goQuest.action', '2', 'fa fa-comment', '0');
|
INSERT INTO `tb_menu` VALUES ('202', '我的任务', 'activiti/goTask.action', '2', 'fa fa-tasks', '0');
|
INSERT INTO `tb_menu` VALUES ('203', '流程部署', 'activiti/goProcess.action', '2', 'fa fa-wrench', '0');
|
|
-- ----------------------------
|
-- Table structure for `tb_role`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_role`;
|
CREATE TABLE `tb_role` (
|
`role_id` int(11) NOT NULL AUTO_INCREMENT,
|
`role_name` varchar(255) DEFAULT NULL,
|
`role_desc` varchar(255) DEFAULT NULL,
|
`pid` int(11) DEFAULT NULL,
|
PRIMARY KEY (`role_id`),
|
UNIQUE KEY `f` (`role_name`)
|
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_role
|
-- ----------------------------
|
INSERT INTO `tb_role` VALUES ('1', '普通员工', '公司普通员工', '4');
|
INSERT INTO `tb_role` VALUES ('2', '部门经理', '部门经理', '3');
|
INSERT INTO `tb_role` VALUES ('3', '总经理', '总经理', '0');
|
INSERT INTO `tb_role` VALUES ('4', '组长', '组长', '2');
|
|
-- ----------------------------
|
-- Table structure for `tb_role_menu`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_role_menu`;
|
CREATE TABLE `tb_role_menu` (
|
`rm_id` int(11) NOT NULL AUTO_INCREMENT,
|
`menu_id` int(11) DEFAULT NULL,
|
`role_id` int(11) DEFAULT NULL,
|
PRIMARY KEY (`rm_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_role_menu
|
-- ----------------------------
|
INSERT INTO `tb_role_menu` VALUES ('48', '1', '2');
|
INSERT INTO `tb_role_menu` VALUES ('49', '102', '2');
|
INSERT INTO `tb_role_menu` VALUES ('50', '103', '2');
|
INSERT INTO `tb_role_menu` VALUES ('51', '2', '2');
|
INSERT INTO `tb_role_menu` VALUES ('52', '201', '2');
|
INSERT INTO `tb_role_menu` VALUES ('53', '202', '2');
|
INSERT INTO `tb_role_menu` VALUES ('54', '3', '2');
|
INSERT INTO `tb_role_menu` VALUES ('55', '4', '2');
|
INSERT INTO `tb_role_menu` VALUES ('56', '1', '3');
|
INSERT INTO `tb_role_menu` VALUES ('57', '101', '3');
|
INSERT INTO `tb_role_menu` VALUES ('58', '102', '3');
|
INSERT INTO `tb_role_menu` VALUES ('59', '103', '3');
|
INSERT INTO `tb_role_menu` VALUES ('60', '104', '3');
|
INSERT INTO `tb_role_menu` VALUES ('61', '2', '3');
|
INSERT INTO `tb_role_menu` VALUES ('62', '201', '3');
|
INSERT INTO `tb_role_menu` VALUES ('63', '202', '3');
|
INSERT INTO `tb_role_menu` VALUES ('64', '203', '3');
|
INSERT INTO `tb_role_menu` VALUES ('65', '3', '3');
|
INSERT INTO `tb_role_menu` VALUES ('66', '4', '3');
|
INSERT INTO `tb_role_menu` VALUES ('67', '1', '5');
|
INSERT INTO `tb_role_menu` VALUES ('68', '101', '5');
|
INSERT INTO `tb_role_menu` VALUES ('69', '102', '5');
|
INSERT INTO `tb_role_menu` VALUES ('70', '2', '5');
|
INSERT INTO `tb_role_menu` VALUES ('71', '201', '5');
|
INSERT INTO `tb_role_menu` VALUES ('72', '3', '5');
|
INSERT INTO `tb_role_menu` VALUES ('73', '4', '5');
|
INSERT INTO `tb_role_menu` VALUES ('81', '1', '4');
|
INSERT INTO `tb_role_menu` VALUES ('82', '101', '4');
|
INSERT INTO `tb_role_menu` VALUES ('83', '102', '4');
|
INSERT INTO `tb_role_menu` VALUES ('84', '2', '4');
|
INSERT INTO `tb_role_menu` VALUES ('85', '201', '4');
|
INSERT INTO `tb_role_menu` VALUES ('86', '202', '4');
|
INSERT INTO `tb_role_menu` VALUES ('87', '3', '4');
|
INSERT INTO `tb_role_menu` VALUES ('88', '4', '4');
|
INSERT INTO `tb_role_menu` VALUES ('98', '1', '1');
|
INSERT INTO `tb_role_menu` VALUES ('99', '101', '1');
|
INSERT INTO `tb_role_menu` VALUES ('100', '2', '1');
|
INSERT INTO `tb_role_menu` VALUES ('101', '201', '1');
|
|
-- ----------------------------
|
-- Table structure for `tb_role_opt`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_role_opt`;
|
CREATE TABLE `tb_role_opt` (
|
`ropt_id` int(11) NOT NULL AUTO_INCREMENT,
|
`r_id` int(11) DEFAULT NULL,
|
`ropt_name` varchar(255) DEFAULT NULL,
|
`ropt_type` varchar(255) DEFAULT NULL,
|
`ropt_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`ropt_id`),
|
KEY `fd` (`r_id`),
|
CONSTRAINT `fd` FOREIGN KEY (`r_id`) REFERENCES `tb_role` (`role_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_role_opt
|
-- ----------------------------
|
INSERT INTO `tb_role_opt` VALUES ('2', '3', 'admins', '修改', '2017-12-22 16:26:57');
|
|
-- ----------------------------
|
-- Table structure for `tb_user`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_user`;
|
CREATE TABLE `tb_user` (
|
`user_id` int(11) NOT NULL AUTO_INCREMENT,
|
`dept_id` int(11) DEFAULT NULL,
|
`user_account` varchar(100) DEFAULT NULL,
|
`user_password` varchar(100) DEFAULT NULL,
|
`user_name` varchar(100) DEFAULT NULL,
|
`img` varchar(200) DEFAULT NULL,
|
`user_age` int(11) DEFAULT NULL,
|
`user_sex` varchar(10) DEFAULT NULL,
|
`user_address` varchar(200) DEFAULT NULL,
|
`user_birth` date DEFAULT NULL,
|
`user_phone` varchar(100) DEFAULT NULL,
|
`email` varchar(100) DEFAULT NULL,
|
`reg_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`user_id`),
|
UNIQUE KEY `user_account` (`user_account`)
|
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_user
|
-- ----------------------------
|
INSERT INTO `tb_user` VALUES ('1', '4', 'admin', '111111', 'admins', null, '34', '女', 'FGG', '2017-12-07', '34433434', 'rg233@GF', null);
|
INSERT INTO `tb_user` VALUES ('16', '1', 'aa', '111111', 'aa', null, '23', '男', 'fd', '2017-12-29', '12212112', 'fd@s', '2017-12-29 15:22:49');
|
INSERT INTO `tb_user` VALUES ('17', '2', 'bb', '111111', 'bb', null, '11', '男', 're', '2017-12-29', '123322323', 'fd@sd', '2017-12-29 15:23:56');
|
INSERT INTO `tb_user` VALUES ('18', '3', 'cc', '111111', 'cc', null, '12', '男', 'fd', '2017-12-29', '12122112', 'df@fd', '2017-12-29 15:24:28');
|
INSERT INTO `tb_user` VALUES ('19', '2', 'b', '111111', 'b', null, '11', '男', 'fg', '2017-12-29', '32323223', 'fd@fd', '2017-12-29 15:24:58');
|
INSERT INTO `tb_user` VALUES ('20', '3', 'c', '111111', 'c', null, '11', '男', 'fd', '2017-12-29', '12121212', 'ds@sd', '2017-12-29 15:36:06');
|
INSERT INTO `tb_user` VALUES ('22', '1', 'a', '111111', 'a', null, '23', '男', 'sd', '2018-01-03', '23232323', 'we@s', '2018-01-03 11:39:02');
|
|
-- ----------------------------
|
-- Table structure for `tb_user_opt`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_user_opt`;
|
CREATE TABLE `tb_user_opt` (
|
`uopt_id` int(11) NOT NULL AUTO_INCREMENT,
|
`u_id` int(11) DEFAULT NULL,
|
`uopt_name` varchar(100) DEFAULT NULL,
|
`uopt_type` varchar(100) DEFAULT NULL,
|
`uopt_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`uopt_id`),
|
KEY `u_id` (`u_id`),
|
CONSTRAINT `tb_user_opt_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `tb_user` (`user_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_user_opt
|
-- ----------------------------
|
INSERT INTO `tb_user_opt` VALUES ('1', '1', 'admins', '修改', '2017-12-19 11:17:26');
|
INSERT INTO `tb_user_opt` VALUES ('7', '1', 'admins', '修改', '2017-12-19 17:28:12');
|
INSERT INTO `tb_user_opt` VALUES ('20', '1', 'admins', '修改', '2017-12-27 11:20:12');
|
INSERT INTO `tb_user_opt` VALUES ('23', '16', 'admins', '添加', '2017-12-29 15:22:49');
|
INSERT INTO `tb_user_opt` VALUES ('24', '17', 'admins', '添加', '2017-12-29 15:23:56');
|
INSERT INTO `tb_user_opt` VALUES ('25', '18', 'admins', '添加', '2017-12-29 15:24:28');
|
INSERT INTO `tb_user_opt` VALUES ('26', '19', 'admins', '添加', '2017-12-29 15:24:58');
|
INSERT INTO `tb_user_opt` VALUES ('27', '20', 'admins', '添加', '2017-12-29 15:36:06');
|
INSERT INTO `tb_user_opt` VALUES ('29', '22', 'admins', '添加', '2018-01-03 11:39:02');
|
INSERT INTO `tb_user_opt` VALUES ('30', '22', 'admins', '修改', '2018-01-03 11:39:36');
|
|
-- ----------------------------
|
-- Table structure for `tb_user_role`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_user_role`;
|
CREATE TABLE `tb_user_role` (
|
`ur_id` int(11) NOT NULL AUTO_INCREMENT,
|
`user_id` int(11) DEFAULT NULL,
|
`role_id` int(11) DEFAULT NULL,
|
PRIMARY KEY (`ur_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_user_role
|
-- ----------------------------
|
INSERT INTO `tb_user_role` VALUES ('1', '1', '3');
|
INSERT INTO `tb_user_role` VALUES ('2', '2', '2');
|
INSERT INTO `tb_user_role` VALUES ('4', '11', '1');
|
INSERT INTO `tb_user_role` VALUES ('13', '13', '1');
|
INSERT INTO `tb_user_role` VALUES ('17', '9', '4');
|
INSERT INTO `tb_user_role` VALUES ('18', '12', '2');
|
INSERT INTO `tb_user_role` VALUES ('20', '20', '2');
|
INSERT INTO `tb_user_role` VALUES ('21', '19', '2');
|
INSERT INTO `tb_user_role` VALUES ('22', '18', '1');
|
INSERT INTO `tb_user_role` VALUES ('23', '17', '1');
|
INSERT INTO `tb_user_role` VALUES ('24', '16', '1');
|
INSERT INTO `tb_user_role` VALUES ('25', '21', '1');
|
INSERT INTO `tb_user_role` VALUES ('27', '22', '2');
|
