oa.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50521
Source Host           : localhost:3306
Source Database       : oa

Target Server Type    : MYSQL
Target Server Version : 50521
File Encoding         : 65001

Date: 2017-10-08 21:48:05
*/

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 ('40002', '1', 'qingjia.bpmn', '40001', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A7873643D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22687474703A2F2F7777772E61637469766974692E6F72672F74657374223E0A20203C70726F636573732069643D2271696E676A69615F5F70726F6365737322206E616D653D2271696E676A696170726F636573732220697345786563757461626C653D2274727565223E0A202020203C73746172744576656E742069643D2273746172746576656E743122206E616D653D225374617274223E3C2F73746172744576656E743E0A202020203C757365725461736B2069643D22757365727461736B3122206E616D653D22E68F90E4BAA4E794B3E8AFB7222061637469766974693A61737369676E65653D22247B666F726D7D223E3C2F757365725461736B3E0A202020203C757365725461736B2069643D22757365727461736B3222206E616D653D22E4B8BBE7AEA1E5AEA1E689B9223E3C2F757365725461736B3E0A202020203C757365725461736B2069643D22757365727461736B3322206E616D653D22E680BBE7BB8FE79086E5AEA1E689B9223E3C2F757365725461736B3E0A202020203C656E644576656E742069643D22656E646576656E743122206E616D653D22456E64223E3C2F656E644576656E743E0A202020203C73657175656E6365466C6F772069643D22666C6F77312220736F757263655265663D2273746172746576656E743122207461726765745265663D22757365727461736B31223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77322220736F757263655265663D22757365727461736B3122207461726765745265663D22757365727461736B32223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77332220736F757263655265663D22757365727461736B3222207461726765745265663D22757365727461736B33223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77342220736F757263655265663D22757365727461736B3322207461726765745265663D22656E646576656E7431223E3C2F73657175656E6365466C6F773E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F71696E676A69615F5F70726F63657373223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D2271696E676A69615F5F70726F63657373222069643D2242504D4E506C616E655F71696E676A69615F5F70726F63657373223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D2273746172746576656E7431222069643D2242504D4E53686170655F73746172746576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235312E30222077696474683D2236312E302220783D223237302E302220793D2231302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B31222069643D2242504D4E53686170655F757365727461736B31223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235312E30222077696474683D2236312E302220783D223237302E302220793D223132302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B32222069643D2242504D4E53686170655F757365727461736B32223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235312E30222077696474683D2236312E302220783D223237302E302220793D223233302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B33222069643D2242504D4E53686170655F757365727461736B33223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223234382E302220793D223332362E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22656E646576656E7431222069643D2242504D4E53686170655F656E646576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2234312E30222077696474683D2236312E302220783D223435302E302220793D223333332E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7731222069643D2242504D4E456467655F666C6F7731223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330302E302220793D2236312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330302E302220793D223132302E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7732222069643D2242504D4E456467655F666C6F7732223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330302E302220793D223137312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330302E302220793D223233302E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7733222069643D2242504D4E456467655F666C6F7733223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330302E302220793D223238312E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330302E302220793D223332362E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7734222069643D2242504D4E456467655F666C6F7734223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223335332E302220793D223335332E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223435302E302220793D223335332E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, '0');
INSERT INTO `act_ge_bytearray` VALUES ('40003', '1', 'qingjia.png', '40001', 0x89504E470D0A1A0A0000000D49484452000002FC000001A30802000000DF0A5667000026DC49444154789CEDDD6B6C5B77FDF8F1686B5936312D3F3168C49379E2412C018DC526B58FA85B892648C02C3135860799A5892ED3C4A810EA32D056C41A22C44A85B6AA83AD44A00CFF35A58B4437026D4A2869177A49D376D9BC5E566F493AAFB7B924694F133BFEFEBFB19939F5ADC7497A3EC739EF973EAA5CDF629F6C9FBEE5244E9502000070812AE9070000006007A2070000B802D10300005C81E8010000AE40F400000057207A0000802B103D0000C015881E0000E00A440F00007005A207B04F341AEDE8E8D894160A85FC370A0683998BB66FDFAEAF29FD600160B1217A805B2B1E8F777777B7B4B478BD5E8FC7A35B4767CD33CF3CFBCA8E1D7B7AF79AA7B3F3557DBE9EF5EB1FF3A4E95B85C3617D0FD24F02001603A207B855FAFAFA0281404D4D8DFE73FBF6ED6F0F0F4F2792D6E7F499332F6EDB160C06F53DF8FD7E5D4ED24F08002A1BD1032CBC7038ECF3F974A97475ED2C2B748ACD9EDEBDDF79E8218FC7A3E3C9300CE9E707001589E8011692CE1D9D26C16070686868417227E7B59F9696167DFFEDEDEDD24F14002A0FD1032C8C783C1E0A8574EEE83459F0DC31CFC8E8D8C68D4FAD5CB9321289483F6900A824440FB0007A7A7ABC5E6F4747C72DCD1DF3F4EF3FE0F3F9F447947EEA005031881E60BE5A5A5A1A1B1B4746C76C2B9ECC8C4F4C36373F120804F82E1F00B082E801E625140A6DDFBEDDE6DC314F57D74EBA0700AC207A80B9D3C563E797B48ACDAE37DEA47B00E0A6881E608E1C523C740F005844F40073D1D2D222FB55AD82DDD3D8D8287D6000C0B9881EA06CE17038180C8A574EFE6CDCF8146FE10300C5103D407962B198CFE7B3FF67B5ACCCF8C4647D7D3DEFDF030005113D40791CF5AD3CF9B3A777AFDFEF973E4800E044440F50869E9E9EC6C646F1B2293DEBD73FB67DFB76E94305008E43F4006558B97265FFFE03E259537A4646C76A6B6BA50F1500380ED10358158944BC5EAF78D358998686869E9E1EE9030600CE42F40056B5B6B6B6B7B78B078D95E9EC7C35180C4A1F30007016A207B0AAB6B6D6993FB4953FE31393FAD1C6E371E96306000E42F4009654C4B7309BA7B9F9117E073B0098113D80255BB76EDDB0618378CA589FCD6D6DADADADD2870D001C84E8012CD1C5F3FC962DE229637D3A3B5F5DD7D4247DD800C041881EC0924020D0D5B5533C65AC4FFFFE032B56AC903E6C00E020440F6089CFE73B7C64503C65AC0FEFD6030039881EC0920AFAD1ADEC5455F13F3800FC0F3B11B0C4EBF5BE3D3C2CDE31D6677C62B2BABA5AFAB0018083103D80258D8D8DBBDE78533C65AC8F4EB4BA3AAFF461030007217A004B5A5A5A5EDCB64D3C65AC8F4EB4868606E9C306000E42F40096B4B7B76FDCF89478CA581F9D68EBD73F267DD800C041881EC0927038BCAEA9493C65AC8F4EB4CD6D6DD2870D001C84E8012C310CA3A6A6667C6252BC662CCE7DF779A2D1A8F461030007217A00AB42A1D02B3B7688D78C95D9D3BB77D5AA55D2070C009C85E801ACEAEBEBD325211E3456A6B9F911DD67D2070C009C85E801CAE0F1784E9F3923DE34A5677C62B2A6A6C6300CE9A30500CE42F40065A8889FE17A7ECB96279FFC91F4A10200C7217A80321886B172E54A27FF12AE91D1B1BA3A6F3C1E973E5400E038440F509EA1A1A1FAFA7AF1B82936DF79E8A1AEAE9DD20709009C88E801CAD6DADABAB9AD4DBC6FF2A7B3F3D5754D4DD28707001C8AE801CA6618465D9DD769DFD13C323A565F5FAFFF943E3C00E050440F3017D16874D5AA55CEE99E0B172FE9C773F8C8A0F4810100E7227A8039724EF7503C006005D103CC5DA67BDE1E1EA67800C0F9881E605E74F7D4D7D7BFB86D9B48F1EC7AE3CDBA3A2FC5030056103DC07C1986B17EFD630D0D0D23A363B6E5CEF8C46473F323990F2A7D0000A032103DC0C2E8E9E9A9ABF37676BE6A43F1F4EF3F505F5FCF6FD70280B2103DC08289C7E3EB9A9A323972EBBE9ED5D0D0B062C58AB78787A59F2E005418A2075860434343CDCD8FDC779FE7F92D5B2E5CBCB450B9A343AAAECEAB8B47778FF45304808A44F400B744341A7DF2C91FE9F459D7D4F4E2B66D73FB09AFD367CEE8D6D109555B5BABFFE4D51D00980FA207B885E2F178381C6E6969A9ABF3EA00D2E1A223664FEF5E3DF96FF033323A96B9A8B3F3D5F5EB1FCBDEA4A3A323168B493F1500A878440F60936834AAF325140AAD4AD3415375A3DADADACC45EB9A9AB66FDF1E8944A41F32002C2A440F204C6790F443000057207A00615555FC6F08007660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB0202C2E1B06E9DEAEA6A9FCFA74FD4D6D6EA3FEFBAEBAE482422FDD00060D1227A0001AFBFFE7A559ED5AB577777774B3F340058B4881E4080611877DC7187B978962F5F5E5B5B1B8FC7A51F1A002C5A440F20E3E9A79F5EB26449367A1E7FFCF1D6D656E90705008B19D1038859B66C59A6789A9A9A3C1E8F6118D28F08001633A20710B36FDFBEA54B97EAE8696C6CE4BB7900E056237A00496BD6ACC9448FF4030180C58FE80124C562311D3DFCA43A00D880E80184F1E68400600FB62D3047866184C3E16030E8F7FB3D1E4FFEFBEED8407F5CFDD10381404747073FEE0E00A5113DC05CF4F4F4E8E0D0C5D3D9D9B9A7B7F7F49933D38984FDA33FAEFEE85D5D5DCDCDCDFAF1E8F4913E3000E05C440F509E783C1E0A851A1A1A464647A613D3CE990B172FE8F4D10F2C168B491F24007022A20728832E1E9FCFF7CA8E97A71353CE9C5D6FEC5AB16245341A953E5400E038440F50865028942E9EEB4E9E3DBDBB57ADFABAF4A10200C7217A00AB7A7A7A1A1AD6269286F367E3533F696B7B4EFA800180B3103D80258661783C9ED1B1682279CDF93331F9497DFD72DEFE0700CC881EC0928E8E8E502894485ECDCEEAC66F59FCC172F3AD6C9BB6B65FF01B4C01C08CE8012C0904025D3BC389E4646656AF6DF848A90F66D4A9847A674A1D9B528727925B77EEFDFBD89583D3EADF863A68A8FEAB6AF775F5DBFE13EB5B1ECBDED0B63932F896CFE7933E6C00E020440F6089D7EB1D1E1E4C24273253555535A1D4644A5D49AACBD3EAAA523FFEE9B355B77D76E5DAC058428D4CA991EB2A6AA8D349F5DA5BC7D22FF64CD83C139317ABABABA50F1B003808D1035852535373F1D26822399E19DD315767D4D4CCEC45C9D4EC9F7F79F36F5FFCD2577EB6F9F9A452E3497525A12E27545CA9DD878EA7A367DCFEA9E2175C0080093B11B0241D2EFFC98EFEEB64525DBAA6A667FE7B85783CFE9B175E7AEED72F8C9C9B7D6FC0444A4DA763E8C0916339B7B56D881E003063270296A4C3E54A7666A367465DB8AA3E9E5009A5A6A7A6BC75755555B75755553FFCBD66F30D0F0F1ECDB9AD6D43F40080193B11B0241D2EF1EC64BEBC75E99A3A37AECE5F578787DF5FB66CD9ED4B3E73E73DF706BF7F43F41C3A3298735BDB86E8010033762260890E8864F293ECE8BF5E4BA9CBC6EC2B3D17AEABDE4391AFD63F70EFE7BF704FCDFFBDF4C7D7AE2B3531A5AE4ECDDEB07FE050CE6D6D1BA20700CCD8898025E970B99C9D4C4FE8EEB992509F4CAB73E3890327A2F55F7B70F537BE797E4A7D6CA8F386BA34A574F6F41F3C94735BDB86E8010033762260493A5C2E65C7BF7AD5F1774F1D3E1119188AEC1F8CEC3F7AF2C0F133FF38F8CE5B27CEEE1B3CF9AFC1F7F61F7D6FE0D8C913A73EDCF6BB1DEB9AD6996F6BDB103D0060C64E042CC9891E3D4F3CF19895B763FEEEC30F8B140FD1030039D8898025B3D13373B1B286E8010033762260493A7A2E54D6103D0060C64E042C4947CFF9CA1AA20700CCD8898025E9E8F9B8B286E8010033762260493A7A629535440F0098B113014BD2D1F351FE64CFCFF9A1AD12D72C3D166F6BE5DE881E003063270296E880989939973FD9F3CD57B8E9954B4CE9DB16FBC1F86237913E6C00E020EC44C09274588CE54FF6FCBC0A297066A158B9C9D50A7E50F3C72D31440F0098B113014BD291316A9E4281F2BF8B72AE5C7A8ADDB6E0FD94F8B8F9D7943E6C00E020EC44C092745B8CE44FF6FCBC10297CB59CD3A52FCDB9F362372936440F0098B113014BD291F161FE143BBFF47572CE29F9E5AD1B6E72D3ABE5DCADF46103000761270296A4C3E283FCF9B4393E281422FFBD42F6CFD2E7583C9DF3488A3DB0CC45D2870D001C849D085832DB16A9A879FE1737379E9973B59C8B0A5EC17CE64D4F17A8ABE21F51FAB0018083B013014BD26D71367FB2E7674E9842A4D495F3CF2FFA75AB221FE8A6F799B948FAB0018083B013014BD26DF17EFE64CFCF9C2876B5D257309F79D3D385C2A8E847943E6C00E020EC44C092745B9CC99FECF9991305AFF6699A14FE6BB13B2C76273957287D57D2870D001C849D085852BA66B27FDEF8024CA9BE297691C5BAB2D84FD2870D001C849D0858926E8BD39535440F0098B113014BD2D173AAB286E8010033762260890E8854EA64650DD1030066EC44C09274F4BC575943F40080193B11B0241D3D91CA1AA20700CCD8898025D5D5D5D7AE0DA552EF56D0103D0060C64E042CF1783C67CFEE4EA5DEA9A0217A00C08C9D0858D2D8D8F8D7BFBE944A0D57CABCFBEE2EAFD72B7DD800C041881EC092F6F6F6D6D64753EAED4A993F746C0E8542D2870D001C84E8012C8946A35EEFFDD78CC32975A222261058D3DDDD2D7DD800C041881EC0AA4DB35A52EAB8F3E7CFE15F05838DD2070C009C85E801AC320CC3EF7F7060E04F4A1D73F2C462BD5EEFFDF178BFF401030067217A80324422119FAF2E12E9566AC899A38B4797595FDFCBD2870A001C87E801CA333030A0BBA7BDFD874A1D75DA74776FF17A3D7D7DBF973E4800E044440F5036C3305A5B437EFF031D1D3F8FC5762B35283BF1F83FC3E15F06830D81805F9F963E3C00E050440F30477D7D7DA1D0B76B6B3F5725ADA6E6EE6070ADEE1EE94302008E46F400C278371D00B007D10308E3974500803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B680807038AC5BA7BABADAE7F3E913B5B5B5FACFBBEEBA2B1289483F340058B4881E40C0EBAFBF5E9567F5EAD5DDDDDDD20F0D00162DA207106018C61D77DC612E9EE5CB97D7D6D6C6E371E98706008B16D103C878FAE9A7972C59928D9EC71F7FBCB5B555FA4101C06246F40062962D5B96299EA6A6268FC7631886F4230280C58CE801C4ECDBB76FE9D2A53A7A1A1B1BF96E1E00B8D5881E40D29A356B32D123FD400060F1237A0049B1584C470F3FA90E0036207A0061BC392100D8836D0BCC916118E17038180CFAFD7E8FC793FFBE3B36D01F577FF44020D0D1D1C18FBB034069440F30173D3D3D3A3874F1747676EEE9ED3D7DE6CC742261FFE88FAB3F7A5757577373B37E3C3A7DA40F0C003817D10394271E8F8742A186868691D191E9C4B473E6C2C50B3A7DF4038BC562D20709009C88E801CAA08BC7E7F3BDB2E3E5E9C4943367D71BBB56AC58118D46A50F1500380ED1039421140AA58BE7BA93674FEFEE55ABBE2E7DA800C071881EC0AA9E9E9E8686B589A4E1FCD9F8D44FDADA9E933E6000E02C440F608961181E8F67742C9A485E73FE4C4C7E525FBF9CB7FF010033A207B0A4A3A323140A259257B3B3BAF15B167FB0DC7C2BDBA6ADED17FC06530030237A004B028140D7CE7022399999D56B1B3E52EA8319752AA1DE9952C7A6D4E189E4D69D7BFF3E76E5E0B4FAB7A10E1AAAFFAADA7D5DFDB6FFC4FA96C7B237B46D8E0CBEE5F3F9A40F1B003808D10358E2F57A87870713C989CC5455554D283599525792EAF2B4BAAAD48F7FFA6CD56D9F5DB93630965023536AE4BA8A1AEA7452BDF6D6B1F48B3D1336CFC4E4C5EAEA6AE9C306000E42F40096D4D4D45CBC349A488E674677CCD5193535337B513235FBE75FDEFCDB17BFF4959F6D7E3EA9D478525D49A8CB0915576AF7A1E3E9E819B77FAAF805170060C24E042C4987CB7FB2A3FF3A995497AEA9E999FF5E211E8FFFE685979EFBF50B23E766DF1B309152D3E9183A70E458CE6D6D1BA20700CCD8898025E970B9929DD9E8995117AEAA8F275442A9E9A9296F5D5D55D5ED5555D50F7FAFD97CC3C38347736E6BDB103D0060C64E042C49874B3C3B992F6F5DBAA6CE8DABF3D7D5E1E1F7972D5B76FB92CFDC79CFBDC1EFDF103D878E0CE6DCD6B6217A00C08C9D0858A2032299FC243BFAAFD752EAB231FB4ACF85EBAAF750E4ABF50FDCFBF92FDC53F37F2FFDF1B5EB4A4D4CA9AB53B337EC1F3894735BDB86E8010033762260493A5C2E6727D313BA7BAE24D427D3EADC78E2C08968FDD71E5CFD8D6F9E9F521F1BEABCA12E4D299D3DFD070FE5DCD6B6217A00C08C9D0858920E974BD9F1AF5E75FCDD53874F44068622FB0723FB8F9E3C70FCCC3F0EBEF3D689B3FB064FFE6BF0BDFD47DF1B3876F2C4A90FB7FD6EC7BAA675E6DBDA36440F0098B113014B72A247CF134F3C66E5ED98BFFBF0C322C543F400400E762260C96CF4CC5CACAC217A00C08C9D0858928E9E0B9535440F0098B113014BD2D173BEB286E8010033762260493A7A3EAEAC217A00C08C9D0858928E9E58650DD1030066EC44C09274F47C546C4A5C9A7351E9FB297185ECF9F9274ADC95F46103000761270296E88098993957628A5DC1FCE3EB397F2D784EBE9CFBCF3F51E221491F3600701076226049BA30C6CA9DECAD322772FE9A7FFAA6F750FA44FE6DA50F1B0038083B11B0241D16A33953F2E5999B5CC17CB59CFB2CF181CC57C83F917F2BE9C306000EC24E042C4987C54889297885D2B7CA5E5AB28A4A5DB9F487207A00C08C9D0858926E8B0F4B4C892B14A999C2B7BDE969F389D28F8AE8010033762260493A2F3E283125AE907F51CE39255FE9B9E13AE6DB5A7948D2870D001C849D0858325B18A968CE948A959B5D2DE70AA54F9B6F927FA2D8103D0060C64E042C4917C6D91253E20A566E5B3C9E72EF24FF4489BB953E6C00E020EC44C0927461BC5F624A5CA178D014B8ED4D4F674E98EFA1D887267A00C08C9D0858920E8B3325A6C4150A5E54ECFA373DFFD3DCB9E19C6237913E6C00E020EC44C092FCB028F135A96C9794BE6659855430716E7A57D2870D001C849D0858920E8BD39535440F0098B113014BD2D173AAB286E8010033762260890E8854EA64650DD1030066EC44C09274F4BC575943F40080193B11B0241D3D91CA1AA20700CCD8898025D5D5D5D7AE0DA552EF56D0103D0060C64E042CF1783C67CFEE4EA5DEA9A0217A00C08C9D0858D2D8D8F8D7BFBE944A0D57CABCFBEE2EAFD72B7DD800C041881EC092F6F6F6D6D64753EAED4A993F746C0E8542D2870D001C84E8012C8946A35EEFFDD78CC32975A222261058D3DDDD2D7DD800C041881EC0AA4DB35A52EAB8F3E7CFE15F05838DD2070C009C85E801AC320CC3EF7F7060E04F4A1D73F2C462BD5EEFFDF178BFF401030067217A80324422119FAF2E12E9566AC899A38B4797595FDFCBD2870A001C87E801CA333030A0BBA7BDFD874A1D75DA74776FF17A3D7D7DBF973E4800E044440F5036C3305A5B437EFF031D1D3F8FC5762B35283BF1F83FC3E15F06830D81805F9F963E3C00E050440F30477D7D7DA1D0B76B6B3F5725ADA6E6EE6070ADEE1EE94302008E46F400C278371D00B007D10308E3974500803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D208CE801007BB06D0161440F00D8836D0B08237A00C01E6C5B4018D10300F660DB02C2881E00B007DB161046F400803DD8B68030A20700ECC1B60584113D00600FB62D20201C0EEBD6A9AEAEF6F97CFA446D6DADFEF3AEBBEE8A4422D20F0D00162DA20710F0FAEBAF57E559BD7A757777B7F4430380458BE80104188671C71D77988B67F9F2E5B5B5B5F1785CFAA101C0A245F400329E7EFAE9254B9664A3E7F1C71F6F6D6D957E5000B098113D809865CB96658AA7A9A9C9E3F1188621FD88006031237A0031FBF6ED5BBA74A98E9EC6C646BE9B07006E35A20790B466CD9A4CF4483F100058FC881E40522C16D3D1C34FAA03800D881E40186F4E0800F660DBC2A50CC30887C3C160D0EFF77B3C9EFC77CD7109FDDCF5110804021D1D1DFCC03C80C58DE8811BF5F4F4E87FEC75F1747676EEE9ED3D7DE6CC7422E1CED1CF5D1F81AEAEAEE6E6667D4C74FA487F7200E056217AE02EF1783C140A3534348C8C8E4C27A619F35CB87841A78F3E38B1584CFA1305000B8FE8818BE8E2F1F97CAFEC78793A31C5149B5D6FEC5AB16245341A95FE7401C002237AE022A150285D3CD799D2B3A777F7AA555F97FE7401C002237AE0163D3D3D0D0D6B134983B1321B9FFA495BDB73D29F34005848440F5CC1300C8FC7333A164D24AF31566662F293FAFAE5BC811080C584E8812B7474748442A144F26A7656377ECBE20F759B6FE5AA696BFB05BF03D5367D7D7D5BB76EDD94D6D8D8E8CFB3E953FA9ABCB9003037440F5C21100874EDFC7FFF2B9EB50D1F29F5C18C3A9550EF4CA96353EAF04472EBCEBD7F1FBB72705AFDDB50070DD57F55EDBEAE7EDB7F627DCB63E2FD21324706077C3E9FF4A76ED18A4422BA72748BEB833CB73758D2FF55EB061A1818907E2A40C5207AE00A5EAF7778F86822399919FD6FC6845293297525A92E4FABAB4AFDF8A7CF56DDF6D9956B0363093532A546AEABA8A14E27D56B6F1D4BBFD833E9C29998BC545D5D2DFDA95B6C62B1986E9DB9854E8900DAB061035F8B046E8AE8812BD4D4D45CBC3496484E6446FF3B7175464DCDCC5E944CCDFEF99737FFF6C52F7DE5679B9F4F2A359E545712EA7242C595DA7DE8783A7A26DC3955FC8A8C85D3DDDDEDF7FB8B858BCEA05028F4CC33CF3EBF65CB9EDEBDF9F3E2B66DFAD2279FFC51893BD171AF8BCA300CE9E70A38141B0DAE900E97F1ECE8BF4E26D5A56B6A7AE6BF5788C7E3BF79E1A5E77EFDC2C8B9D9F7E54BA4D4743A860E1C3996735B570DD1B320FAFAFAF25FDAA9AEAE0E06839BDBDA74D04C2792E5CEE123833A839A9B1FD1419F73CFB5B5B5BCB33650101B0DAE900E97FF6467367A66D485ABEAE30995506A7A6ACA5B57575575BBFE97E8E1EF359B6F7878F068CE6D5D3544CF3C0D0D0DE5BF30A3CFD15172E1E2A539B44EC1E9EC7C55F793AEA89C978EBABBBBA50F00E02C6C34B8423A5CAE6427F3E5AD4BD7D4B97175FEBA3A3CFCFEB265CB6E5FF2993BEFB937F8FD1BA2E7D091C19CDBBA6A889EF9686F6FCFC99D0D1B368C8C8E2D54EBE48CAEA8E7B76CC979E1A7A5A585AF7601596C34B8423A5CE2D9D17FBD9652978DD9577A2E5C57BD87225FAD7FE0DECF7FE19E9AFF7BE98FAF5D576A624A5D9D9ABD61FFC0A19CDBBA6A889EB989C7E38140C01C1FC16030FD7B6D6F49EEE4A4CFC68D4F995FF559B97225BF4C0DC860A3C115F4EA4F263FC94EE6DF72DD3D5712EA9369756E3C71E044B4FE6B0FAEFEC637CF4FA98F0D75DE5097A694CE9EFE8387726EEBAA217AE620128978BD5EF317B30E1F19B42177CC33323AB6AEA9C9FC5D3EFC643BA0881EB8444EB8F857AF3AFEEEA9C32722034391FD8391FD474F1E387EE61F07DF79EBC4D97D8327FF35F8DEFEA3EF0D1C3B79E2D487DB7EB7635DD33AF1F8207A2A45341AD58561FE7A96CDB9639E17B76DCBBEE4A34F0C0D0D491F1E40181B0DAE908E9ECBE679E289C7AA2CF8EEC30FE7DCD05543F494C5308C952B576623231C0E0B164F66FAF71FC84698C7E3D14D267D9000496C34B8423A7A2E31E50ED15396502894CDE59E9E1EF1E2C9CCDBC3C3D9EF6EF6F97C7C5F33DC8C8D0657988D9E998B4CB943F458B77DFBF66CF16C6E6B136F1DF3EC7AE34DF3B7544B1F2A400C1B0DAE908E9E0B4CB943F458641846F6AB48814040BC72F2E7F92D5BB2DDC32FAC806BB1D1E00AE9E839CF943B448F455BB76ECDFE9CD4F8C4A478E2149CEF3CF450F6DBABA50F1820838D06574847CFC74CB943F458617E99E7F92D5BC4E3A6D87475EDCC7E9335EFDC037762A3C115D2D11363CA1DA2272B1C0E17FBD1277D91F35FE6C94C7D7D7DE6A16EDAB4C9D6C30738031B0DAE40F4103DF371F2E4C94C2BDC7DF7DD5D5D5D3997667FDD84ECBBF2589917B76DE3DB99E1666C34B8423A7A3E9AFFE4DF8F95734ADC5B3E2B1F34E7FCFC130B35444F866118B7DD765BE613B474E9D22F7FF9CBE6577DB23FA9AE93423C6B4A4FFFFE03D99F5D973B9C8018361A5C416FF99999730B32E6BB2A78B7D933736A26E7CC9C6B9A4F148CA1827755ECC4023E59E94F9D5398DF6759BBF3CE3B1F7DF4D1CC7BDE64DF9070D71B6F8A674DE9B970F152E6A15657574B1F5140001B0DAE90AE81B1794EC90AF9DF750ADEB0E05F8B9D28FD686F7AF39BDE43594FD9EFF7DF34C25C2EDB43F6FC4AD1794EF6175348FF4F0908E0BF7BB842D56C048CCE738ADD49F6FCFC13056F65BE5A3E8B1FD77CFDD20F609E4F59FA53E714F7DC734FF69807D2740E66DEF0C6E7F365CEEFDF7F40BC694ACFF8C464F659481F514000FFDDC315D2113032CF297627D9F34D2172C3453937345FBFC489624A7CDC821F6E9E4F59FA53E708F1783C7378BD5EEF0F7EF003FD67381CCE5E1A0C0633977676BE2A9E35A5E7F091C1EC13113C9E8014361A5C21DD011FCE738ADD49CEF9D9BF9ACF379FF9699D14B866E9DB96B84FF39DCFFF999A3F84F4A7CE113EF8E083EAEAEAC6C6468FC7D3DADAAA1BC87CA93E2773E4376E7C4A3C6B4A4FF6AD7AF473913A988020361A5C61A1A2A7F8AB2FA58AA774A314BC2B8B1FAB583C113D0BAEBBBBBBA3A3A3E05BF5E8F3339F8BFAFA7AF1AC293DBC29335C8E8D065748D7C007B77A6E4C931BFE6A7E00F90FA6F439054F9BEF33FFC4023E23E94F5D0588C562D9EF0EEEEADA295E36C56664742CFB38878686A40F1B20808D065798AD81547401C77C87A5EF3CFFD2EC39855FC8297E91F90A39F763E591CCED694A7FEA2AC3860D1B9CFF62CF934FFE28F320038180F4010364B0D1E00AE91A383BCFC9DC49F6AECCF79973BAD84505AF50EC3AD64F671F58C1C736CFA72CFDA9AB0CE6177B9CF9EBB7FAF71FC83EC2EEEE6EE90306C860A3C115D211F0FE3C2773273977653EF3D3EC28702BF35F6F7A1D8B9766CFCFDEA7F99CF93FDFCCFD487FEA2A46F6C51EDD167B7AF78A578E794646C7B26F26C47B31C3CDD868708574049C99CF98EF21EFEB4D85AF5FE82B5337B942C17B2B7666F6FC828F6D9ECF377B6FD29FBA8A611846F6AD99756138E78D0AC7272657AC58917960353535C57E6D2AE0066C34B8423A024E33E50ED15316DD13BA2A3279515F5FEF84EEB970F152434343F625A8BEBE3EE983044862A3C115D2D1738A2977889E72E9AAC8BED8A60348F6EB5C6F0F0FD7D579B38F67FBF6EDD2870710C646832B103D448F6D745B64BF6558DBDCD626523C9D9DAF665F76D2DADBDBA50F0C208F8D0657D04B3F953AC9943B44CFDC0C0C0C987F2BFB7DF779ECFC0D157B7AF766BF8927F382133FAE0564B0D1E00AE9E8798F2977889E398BC562D9EF6BCE7E97CFADFE6AD7DBC3C3D9F75CCEF07ABD99DF8A0A40113D708974F444987287E8990FC330366DDA64FE1A93B662C58A17B76D1B191D5BC0D6199F987C65C78E9CDCD15A5A5A727E4D18E0726C34B8423A7ADE65CA1DA267FE74766CD8B0C1FC5D3E19BA5174A9CCE727BC2E5CBCD4D5B5735D5353FE9D0702017E341DC8C746832BE87F15AE5D3B9A4ABDC3943544CF4289C56205D327F33D37AB56AD7AE6996777BDF166FFFE03A5BF7AB5A777EFE6B6361D4CF7DDE7C9BFAB4CEEF07BB58062D86870058FC773F6ECDF53A961A6AC217A169661181D1D1D8D8D8D057BA5600C158B9B1C5EAF77EBD6AD3AADA49F22E0686C34B882FE67E6AF3DDB53EA6DC6FABC1BF98BFEA754FA53B738E93A696F6FF7FBFD055FFBB14EDFC3860D1BF85665C022A207AEA0FF81696D7D543C232A6BFED0B139140A497FEA163F9D2CE170B8B5B5D59F96F38DCF593A8F3257D095D3D1D1C1D7B08039207AE00AD168D4EBBDFF9A7138A54E3016271058C3FBBB00584C881EB8C5A6592D29759CB1327F0EFF2A186C94FEA401C042227AE0168661F8FD0F0E0CFC49A9634CE989C57ABDDEFBE3F17EE94F1A002C24A2072E1289447CBEBA48A45BA921A6D8E8E2D175D8D7F7B2F4A70B001618D10377191818D0DDD3DEFE43A58E32F9D3DDBDC5EBF5F4F5FD5EFA1305000B8FE881EB1886D1DA1AF2FB1FE8E8F8792CB65BA941261EFF6738FCCB60B02110F0EBD3D29F2200B825881EB8545F5F5F28F4EDDADACFCDE75D52168D9A9ABB83C1B5BA7BA43F2D00700B113D0000C015881E0000E00A440F00007005A2070000B802D10300005C81E8010000AE40F400000057207A0000802B103D0000C015881E0000E00A440F00007005A2070000B802D10300005C81E8010000AE40F400000057207A0000802B103D0000C015881E0000E00A440F00007005A2070000B802D10300005C81E8010000AE40F400000057207A0000802B103D0000C015881E0000E00A440F00007005A2070000B802D10300005C81E8010000AE40F400000057207A0000802B103D0000C015881E0000E00A440F00007005A2070000B802D10300005C81E8010000AEF0FF010D715975647358A20000000049454E44AE426082, '0');
INSERT INTO `act_ge_bytearray` VALUES ('42505', '1', 'hist.var-form', null, 0xACED000573720019636E2E626C616B652E73686F612E646F6D61696E2E466F726D52029B6775FF540B0200094C000A6170706C696361746F727400124C6A6176612F6C616E672F537472696E673B4C000C6170706C6963746574696D657400104C6A6176612F7574696C2F446174653B4C0008617070726F76657374000F4C6A6176612F7574696C2F5365743B4C00036669647400134C6A6176612F6C616E672F496E74656765723B4C000C666F726D54656D706C6174657400234C636E2F626C616B652F73686F612F646F6D61696E2F466F726D54656D706C6174653B4C00047069696471007E00014C0005737461746571007E00014C00057469746C6571007E00014C000375726C71007E00017870740005626C616B657372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000015E37500DDA787372002F6F72672E68696265726E6174652E636F6C6C656374696F6E2E696E7465726E616C2E50657273697374656E7453657486E4FDA1F2EEE0AF0200014C000373657471007E00037872003E6F72672E68696265726E6174652E636F6C6C656374696F6E2E696E7465726E616C2E416273747261637450657273697374656E74436F6C6C656374696F6E23038AEBA4E896C702000749000A63616368656453697A655A000564697274795A000B696E697469616C697A65644C00036B65797400164C6A6176612F696F2F53657269616C697A61626C653B4C00056F776E65727400124C6A6176612F6C616E672F4F626A6563743B4C0004726F6C6571007E00014C000E73746F726564536E617073686F7471007E000C7870FFFFFFFF0001707070737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000017708000000010000000078737200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000078737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000373720021636E2E626C616B652E73686F612E646F6D61696E2E466F726D54656D706C61746563B955F35005BF620200054C0005666F726D7371007E00034C00046674696471007E00044C00046E616D6571007E00014C000A70726F636573734B657971007E00014C000375726C71007E000178707371007E000AFFFFFFFF00007371007E00130000000471007E0017740027636E2E626C616B652E73686F612E646F6D61696E2E466F726D54656D706C6174652E666F726D73707071007E0019740009E8AFB7E5818746474774001071696E676A69615F5F70726F63657373740051453A5C4A4156415C4D792045636C697073655C6D792065636C6970736520323031345C2E6D657461646174615C2E6D655F746361745C776562617070735C6F615C646F63756D656E745C4753482E6F647470740009E794B3E8AFB7E4B8AD74002CE8AFB7E581874647475F626C616B655F546875204175672033312031363A30323A3236204353542032303137740051453A5C4A4156415C4D792045636C697073655C6D792065636C6970736520323031345C2E6D657461646174615C2E6D655F746361745C776562617070735C6F615C646F63756D656E745C7572692E747874, null);
INSERT INTO `act_ge_bytearray` VALUES ('50005', '1', 'hist.var-form', null, 0xACED000573720019636E2E626C616B652E73686F612E646F6D61696E2E466F726D52029B6775FF540B0200094C000A6170706C696361746F727400124C6A6176612F6C616E672F537472696E673B4C000C6170706C6963746574696D657400104C6A6176612F7574696C2F446174653B4C0008617070726F76657374000F4C6A6176612F7574696C2F5365743B4C00036669647400134C6A6176612F6C616E672F496E74656765723B4C000C666F726D54656D706C6174657400234C636E2F626C616B652F73686F612F646F6D61696E2F466F726D54656D706C6174653B4C00047069696471007E00014C0005737461746571007E00014C00057469746C6571007E00014C000375726C71007E00017870740005626C616B657372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000015EFB9B059E787372002F6F72672E68696265726E6174652E636F6C6C656374696F6E2E696E7465726E616C2E50657273697374656E7453657486E4FDA1F2EEE0AF0200014C000373657471007E00037872003E6F72672E68696265726E6174652E636F6C6C656374696F6E2E696E7465726E616C2E416273747261637450657273697374656E74436F6C6C656374696F6E844A7E7706AE8D0B0200095A001B616C6C6F774C6F61644F7574736964655472616E73616374696F6E49000A63616368656453697A655A000564697274795A000B696E697469616C697A65644C00036B65797400164C6A6176612F696F2F53657269616C697A61626C653B4C00056F776E65727400124C6A6176612F6C616E672F4F626A6563743B4C0004726F6C6571007E00014C001273657373696F6E466163746F72795575696471007E00014C000E73746F726564536E617073686F7471007E000C787000FFFFFFFF000170707070737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000007708000000010000000078737200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000003F4000000000000078737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000473720021636E2E626C616B652E73686F612E646F6D61696E2E466F726D54656D706C61746563B955F35005BF620200054C0005666F726D7371007E00034C00046674696471007E00044C00046E616D6571007E00014C000A70726F636573734B657971007E00014C000375726C71007E000178707371007E000A00FFFFFFFF000071007E001571007E0017740027636E2E626C616B652E73686F612E646F6D61696E2E466F726D54656D706C6174652E666F726D7370707071007E0015740009E8AFB7E5818746474774001071696E676A69615F5F70726F63657373740051453A5C4A4156415C4D792045636C697073655C6D792065636C6970736520323031345C2E6D657461646174615C2E6D655F746361745C776562617070735C6F615C646F63756D656E745C4753482E6F647470740009E794B3E8AFB7E4B8AD74002CE8AFB7E581874647475F626C616B655F53756E204F63742030382031383A34393A3534204353542032303137740062443A5C4A6176615F7373685C746F6D6361745F616E645F6A626F73735F61735C6170616368652D746F6D6361742D362E302E33355C776562617070735C6F615C646F63756D656E745CE59BBEE8A7A3E98193E5BEB7E7BB8FE69585E4BA8B2E706466, null);
INSERT INTO `act_ge_bytearray` VALUES ('50019', '1', 'hist.var-form', null, 0xACED000573720019636E2E626C616B652E73686F612E646F6D61696E2E466F726D52029B6775FF540B0200094C000A6170706C696361746F727400124C6A6176612F6C616E672F537472696E673B4C000C6170706C6963746574696D657400104C6A6176612F7574696C2F446174653B4C0008617070726F76657374000F4C6A6176612F7574696C2F5365743B4C00036669647400134C6A6176612F6C616E672F496E74656765723B4C000C666F726D54656D706C6174657400234C636E2F626C616B652F73686F612F646F6D61696E2F466F726D54656D706C6174653B4C00047069696471007E00014C0005737461746571007E00014C00057469746C6571007E00014C000375726C71007E00017870740005626C616B657372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000015EFB9C35A0787372002F6F72672E68696265726E6174652E636F6C6C656374696F6E2E696E7465726E616C2E50657273697374656E7453657486E4FDA1F2EEE0AF0200014C000373657471007E00037872003E6F72672E68696265726E6174652E636F6C6C656374696F6E2E696E7465726E616C2E416273747261637450657273697374656E74436F6C6C656374696F6E844A7E7706AE8D0B0200095A001B616C6C6F774C6F61644F7574736964655472616E73616374696F6E49000A63616368656453697A655A000564697274795A000B696E697469616C697A65644C00036B65797400164C6A6176612F696F2F53657269616C697A61626C653B4C00056F776E65727400124C6A6176612F6C616E672F4F626A6563743B4C0004726F6C6571007E00014C001273657373696F6E466163746F72795575696471007E00014C000E73746F726564536E617073686F7471007E000C787000FFFFFFFF000170707070737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000007708000000010000000078737200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000003F4000000000000078737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000573720021636E2E626C616B652E73686F612E646F6D61696E2E466F726D54656D706C61746563B955F35005BF620200054C0005666F726D7371007E00034C00046674696471007E00044C00046E616D6571007E00014C000A70726F636573734B657971007E00014C000375726C71007E000178707371007E000A00FFFFFFFF00007371007E00130000000471007E0017740027636E2E626C616B652E73686F612E646F6D61696E2E466F726D54656D706C6174652E666F726D7370707071007E0019740009E8AFB7E5818746474774001071696E676A69615F5F70726F63657373740051453A5C4A4156415C4D792045636C697073655C6D792065636C6970736520323031345C2E6D657461646174615C2E6D655F746361745C776562617070735C6F615C646F63756D656E745C4753482E6F647470740009E794B3E8AFB7E4B8AD74002CE8AFB7E581874647475F626C616B655F53756E204F63742030382031383A35313A3132204353542032303137740065443A5C4A6176615F7373685C746F6D6361745F616E645F6A626F73735F61735C6170616368652D746F6D6361742D362E302E33355C776562617070735C6F615C646F63756D656E745CE98193E5BEB7E7BB8FE585A8E69687E58F8AE7BFBBE8AF912E706466, null);
INSERT INTO `act_ge_bytearray` VALUES ('55005', '1', 'hist.var-form', null, 0xACED000573720019636E2E626C616B652E73686F612E646F6D61696E2E466F726D52029B6775FF540B0200094C000A6170706C696361746F727400124C6A6176612F6C616E672F537472696E673B4C000C6170706C6963746574696D657400104C6A6176612F7574696C2F446174653B4C0008617070726F76657374000F4C6A6176612F7574696C2F5365743B4C00036669647400134C6A6176612F6C616E672F496E74656765723B4C000C666F726D54656D706C6174657400234C636E2F626C616B652F73686F612F646F6D61696E2F466F726D54656D706C6174653B4C00047069696471007E00014C0005737461746571007E00014C00057469746C6571007E00014C000375726C71007E00017870740005626C616B657372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000015EFBAF0E04787372002F6F72672E68696265726E6174652E636F6C6C656374696F6E2E696E7465726E616C2E50657273697374656E7453657486E4FDA1F2EEE0AF0200014C000373657471007E00037872003E6F72672E68696265726E6174652E636F6C6C656374696F6E2E696E7465726E616C2E416273747261637450657273697374656E74436F6C6C656374696F6E844A7E7706AE8D0B0200095A001B616C6C6F774C6F61644F7574736964655472616E73616374696F6E49000A63616368656453697A655A000564697274795A000B696E697469616C697A65644C00036B65797400164C6A6176612F696F2F53657269616C697A61626C653B4C00056F776E65727400124C6A6176612F6C616E672F4F626A6563743B4C0004726F6C6571007E00014C001273657373696F6E466163746F72795575696471007E00014C000E73746F726564536E617073686F7471007E000C787000FFFFFFFF000170707070737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000007708000000010000000078737200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000003F4000000000000078737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000673720021636E2E626C616B652E73686F612E646F6D61696E2E466F726D54656D706C61746563B955F35005BF620200054C0005666F726D7371007E00034C00046674696471007E00044C00046E616D6571007E00014C000A70726F636573734B657971007E00014C000375726C71007E000178707371007E000A00FFFFFFFF00007371007E00130000000471007E0017740027636E2E626C616B652E73686F612E646F6D61696E2E466F726D54656D706C6174652E666F726D7370707071007E0019740009E8AFB7E5818746474774001071696E676A69615F5F70726F63657373740051453A5C4A4156415C4D792045636C697073655C6D792065636C6970736520323031345C2E6D657461646174615C2E6D655F746361745C776562617070735C6F615C646F63756D656E745C4753482E6F647470740009E794B3E8AFB7E4B8AD74002CE8AFB7E581874647475F626C616B655F53756E204F63742030382031393A31313A3437204353542032303137740065443A5C4A6176615F7373685C746F6D6361745F616E645F6A626F73735F61735C6170616368652D746F6D6361742D362E302E33355C776562617070735C6F615C646F63756D656E745CE98193E5BEB7E7BB8FE585A8E69687E58F8AE7BFBBE8AF912E706466, null);

-- ----------------------------
-- 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', '60001', '25');
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 ('42502', 'qingjia__process:2:40004', '42501', '42501', 'startevent1', null, null, 'Start', 'startEvent', null, '2017-08-31 16:02:27', '2017-08-31 16:02:27', '43', '');
INSERT INTO `act_hi_actinst` VALUES ('42506', 'qingjia__process:2:40004', '42501', '42501', 'usertask1', '42507', null, '提交申请', 'userTask', 'cn.blake.shoa.domain.Form@63bd26d6', '2017-08-31 16:02:27', '2017-08-31 16:02:27', '701', '');
INSERT INTO `act_hi_actinst` VALUES ('42509', 'qingjia__process:2:40004', '42501', '42501', 'usertask2', '42510', null, '主管审批', 'userTask', null, '2017-08-31 16:02:27', '2017-08-31 23:01:32', '25145110', '');
INSERT INTO `act_hi_actinst` VALUES ('45002', 'qingjia__process:2:40004', '42501', '42501', 'usertask3', '45003', null, '总经理审批', 'userTask', null, '2017-08-31 23:01:32', '2017-09-01 16:55:56', '64464425', '');
INSERT INTO `act_hi_actinst` VALUES ('47501', 'qingjia__process:2:40004', '42501', '42501', 'endevent1', null, null, 'End', 'endEvent', null, '2017-09-01 16:55:56', '2017-09-01 16:55:56', '0', '');
INSERT INTO `act_hi_actinst` VALUES ('50002', 'qingjia__process:2:40004', '50001', '50001', 'startevent1', null, null, 'Start', 'startEvent', null, '2017-10-08 18:49:54', '2017-10-08 18:49:54', '31', '');
INSERT INTO `act_hi_actinst` VALUES ('50006', 'qingjia__process:2:40004', '50001', '50001', 'usertask1', '50007', null, '提交申请', 'userTask', 'cn.blake.shoa.domain.Form@84a226', '2017-10-08 18:49:54', '2017-10-08 18:49:54', '850', '');
INSERT INTO `act_hi_actinst` VALUES ('50009', 'qingjia__process:2:40004', '50001', '50001', 'usertask2', '50010', null, '主管审批', 'userTask', null, '2017-10-08 18:49:54', '2017-10-08 18:50:06', '12151', '');
INSERT INTO `act_hi_actinst` VALUES ('50012', 'qingjia__process:2:40004', '50001', '50001', 'usertask3', '50013', null, '总经理审批', 'userTask', null, '2017-10-08 18:50:06', '2017-10-08 18:50:18', '12185', '');
INSERT INTO `act_hi_actinst` VALUES ('50014', 'qingjia__process:2:40004', '50001', '50001', 'endevent1', null, null, 'End', 'endEvent', null, '2017-10-08 18:50:18', '2017-10-08 18:50:18', '0', '');
INSERT INTO `act_hi_actinst` VALUES ('50016', 'qingjia__process:2:40004', '50015', '50015', 'startevent1', null, null, 'Start', 'startEvent', null, '2017-10-08 18:51:12', '2017-10-08 18:51:12', '0', '');
INSERT INTO `act_hi_actinst` VALUES ('50020', 'qingjia__process:2:40004', '50015', '50015', 'usertask1', '50021', null, '提交申请', 'userTask', 'cn.blake.shoa.domain.Form@a96172', '2017-10-08 18:51:12', '2017-10-08 18:51:12', '176', '');
INSERT INTO `act_hi_actinst` VALUES ('50023', 'qingjia__process:2:40004', '50015', '50015', 'usertask2', '50024', null, '主管审批', 'userTask', null, '2017-10-08 18:51:12', '2017-10-08 18:57:15', '363915', '');
INSERT INTO `act_hi_actinst` VALUES ('52502', 'qingjia__process:2:40004', '50015', '50015', 'usertask3', '52503', null, '总经理审批', 'userTask', null, '2017-10-08 18:57:15', '2017-10-08 18:57:50', '35252', '');
INSERT INTO `act_hi_actinst` VALUES ('52504', 'qingjia__process:2:40004', '50015', '50015', 'endevent1', null, null, 'End', 'endEvent', null, '2017-10-08 18:57:50', '2017-10-08 18:57:50', '0', '');
INSERT INTO `act_hi_actinst` VALUES ('55002', 'qingjia__process:2:40004', '55001', '55001', 'startevent1', null, null, 'Start', 'startEvent', null, '2017-10-08 19:11:47', '2017-10-08 19:11:47', '23', '');
INSERT INTO `act_hi_actinst` VALUES ('55006', 'qingjia__process:2:40004', '55001', '55001', 'usertask1', '55007', null, '提交申请', 'userTask', 'cn.blake.shoa.domain.Form@1d5c5f6', '2017-10-08 19:11:47', '2017-10-08 19:11:47', '507', '');
INSERT INTO `act_hi_actinst` VALUES ('55009', 'qingjia__process:2:40004', '55001', '55001', 'usertask2', '55010', null, '主管审批', 'userTask', null, '2017-10-08 19:11:47', '2017-10-08 20:11:26', '3579342', '');
INSERT INTO `act_hi_actinst` VALUES ('57502', 'qingjia__process:2:40004', '55001', '55001', 'usertask3', '57503', null, '总经理审批', 'userTask', null, '2017-10-08 20:11:26', '2017-10-08 20:11:35', '9908', '');
INSERT INTO `act_hi_actinst` VALUES ('57504', 'qingjia__process:2:40004', '55001', '55001', 'endevent1', null, null, 'End', 'endEvent', null, '2017-10-08 20:11:35', '2017-10-08 20:11:35', '0', '');

-- ----------------------------
-- 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
-- ----------------------------

-- ----------------------------
-- 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 ('42508', null, 'participant', 'cn.blake.shoa.domain.Form@63bd26d6', null, '42501');
INSERT INTO `act_hi_identitylink` VALUES ('50008', null, 'participant', 'cn.blake.shoa.domain.Form@84a226', null, '50001');
INSERT INTO `act_hi_identitylink` VALUES ('50022', null, 'participant', 'cn.blake.shoa.domain.Form@a96172', null, '50015');
INSERT INTO `act_hi_identitylink` VALUES ('55008', null, 'participant', 'cn.blake.shoa.domain.Form@1d5c5f6', null, '55001');

-- ----------------------------
-- 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 ('42501', '42501', null, 'qingjia__process:2:40004', '2017-08-31 16:02:27', '2017-09-01 16:55:56', '89609542', null, 'startevent1', 'endevent1', null, null, '', null);
INSERT INTO `act_hi_procinst` VALUES ('50001', '50001', null, 'qingjia__process:2:40004', '2017-10-08 18:49:54', '2017-10-08 18:50:18', '24185', null, 'startevent1', 'endevent1', null, null, '', null);
INSERT INTO `act_hi_procinst` VALUES ('50015', '50015', null, 'qingjia__process:2:40004', '2017-10-08 18:51:12', '2017-10-08 18:57:50', '398252', null, 'startevent1', 'endevent1', null, null, '', null);
INSERT INTO `act_hi_procinst` VALUES ('55001', '55001', null, 'qingjia__process:2:40004', '2017-10-08 19:11:47', '2017-10-08 20:11:35', '3588924', null, 'startevent1', 'endevent1', 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 ('42507', 'qingjia__process:2:40004', 'usertask1', '42501', '42501', '提交申请', null, null, null, 'cn.blake.shoa.domain.Form@63bd26d6', '2017-08-31 16:02:27', null, '2017-08-31 16:02:27', '685', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('42510', 'qingjia__process:2:40004', 'usertask2', '42501', '42501', '主管审批', null, null, null, null, '2017-08-31 16:02:27', null, '2017-08-31 23:01:32', '25145078', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('45003', 'qingjia__process:2:40004', 'usertask3', '42501', '42501', '总经理审批', null, null, null, null, '2017-08-31 23:01:32', null, '2017-09-01 16:55:56', '64464365', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('50007', 'qingjia__process:2:40004', 'usertask1', '50001', '50001', '提交申请', null, null, null, 'cn.blake.shoa.domain.Form@84a226', '2017-10-08 18:49:54', null, '2017-10-08 18:49:54', '834', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('50010', 'qingjia__process:2:40004', 'usertask2', '50001', '50001', '主管审批', null, null, null, null, '2017-10-08 18:49:54', null, '2017-10-08 18:50:06', '12151', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('50013', 'qingjia__process:2:40004', 'usertask3', '50001', '50001', '总经理审批', null, null, null, null, '2017-10-08 18:50:06', null, '2017-10-08 18:50:18', '12185', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('50021', 'qingjia__process:2:40004', 'usertask1', '50015', '50015', '提交申请', null, null, null, 'cn.blake.shoa.domain.Form@a96172', '2017-10-08 18:51:12', null, '2017-10-08 18:51:12', '176', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('50024', 'qingjia__process:2:40004', 'usertask2', '50015', '50015', '主管审批', null, null, null, null, '2017-10-08 18:51:12', null, '2017-10-08 18:57:15', '363884', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('52503', 'qingjia__process:2:40004', 'usertask3', '50015', '50015', '总经理审批', null, null, null, null, '2017-10-08 18:57:15', null, '2017-10-08 18:57:50', '35252', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('55007', 'qingjia__process:2:40004', 'usertask1', '55001', '55001', '提交申请', null, null, null, 'cn.blake.shoa.domain.Form@1d5c5f6', '2017-10-08 19:11:47', null, '2017-10-08 19:11:47', '499', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('55010', 'qingjia__process:2:40004', 'usertask2', '55001', '55001', '主管审批', null, null, null, null, '2017-10-08 19:11:47', null, '2017-10-08 20:11:26', '3579311', 'completed', '50', null, null, null, '');
INSERT INTO `act_hi_taskinst` VALUES ('57503', 'qingjia__process:2:40004', 'usertask3', '55001', '55001', '总经理审批', null, null, null, null, '2017-10-08 20:11:26', null, '2017-10-08 20:11:35', '9908', 'completed', '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 ('42504', '42501', '42501', null, 'form', 'serializable', '1', '42505', null, null, null, null, '2017-08-31 16:02:27', '2017-09-01 16:55:56');
INSERT INTO `act_hi_varinst` VALUES ('45001', '42501', '42501', null, '意见', 'string', '1', null, null, null, '', null, '2017-08-31 23:01:31', '2017-09-01 16:55:56');
INSERT INTO `act_hi_varinst` VALUES ('50004', '50001', '50001', null, 'form', 'serializable', '1', '50005', null, null, null, null, '2017-10-08 18:49:54', '2017-10-08 18:50:18');
INSERT INTO `act_hi_varinst` VALUES ('50011', '50001', '50001', null, '意见', 'string', '1', null, null, null, '', null, '2017-10-08 18:50:06', '2017-10-08 18:50:18');
INSERT INTO `act_hi_varinst` VALUES ('50018', '50015', '50015', null, 'form', 'serializable', '1', '50019', null, null, null, null, '2017-10-08 18:51:12', '2017-10-08 18:57:50');
INSERT INTO `act_hi_varinst` VALUES ('52501', '50015', '50015', null, '意见', 'string', '1', null, null, null, '', null, '2017-10-08 18:57:15', '2017-10-08 18:57:50');
INSERT INTO `act_hi_varinst` VALUES ('55004', '55001', '55001', null, 'form', 'serializable', '1', '55005', null, null, null, null, '2017-10-08 19:11:47', '2017-10-08 20:11:35');
INSERT INTO `act_hi_varinst` VALUES ('57501', '55001', '55001', null, '意见', 'string', '1', null, null, null, '', null, '2017-10-08 20:11:26', '2017-10-08 20:11:35');

-- ----------------------------
-- Table structure for act_id_group
-- ----------------------------
DROP TABLE IF EXISTS `act_id_group`;
CREATE TABLE `act_id_group` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_id_group
-- ----------------------------
INSERT INTO `act_id_group` VALUES ('deptLeader', '1', '部门领导', 'assignment');

-- ----------------------------
-- Table structure for act_id_info
-- ----------------------------
DROP TABLE IF EXISTS `act_id_info`;
CREATE TABLE `act_id_info` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int(11) DEFAULT NULL,
  `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PASSWORD_` longblob,
  `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_id_info
-- ----------------------------

-- ----------------------------
-- Table structure for act_id_membership
-- ----------------------------
DROP TABLE IF EXISTS `act_id_membership`;
CREATE TABLE `act_id_membership` (
  `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
  KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
  CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`),
  CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_id_membership
-- ----------------------------
INSERT INTO `act_id_membership` VALUES ('alice', 'deptLeader');

-- ----------------------------
-- Table structure for act_id_user
-- ----------------------------
DROP TABLE IF EXISTS `act_id_user`;
CREATE TABLE `act_id_user` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int(11) DEFAULT NULL,
  `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_id_user
-- ----------------------------
INSERT INTO `act_id_user` VALUES ('alice', '1', 'Alice', 'Lee', 'alice@163.com', null, null);

-- ----------------------------
-- 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 ('15005', 'OA', null, '', '2017-08-30 09:37:46');
INSERT INTO `act_re_deployment` VALUES ('20005', 'OA', null, '', '2017-08-30 10:47:46');
INSERT INTO `act_re_deployment` VALUES ('20010', 'OA', null, '', '2017-08-30 10:49:27');
INSERT INTO `act_re_deployment` VALUES ('25005', 'XXX', null, '', '2017-08-30 11:04:25');
INSERT INTO `act_re_deployment` VALUES ('25010', 'XXX', null, '', '2017-08-30 11:05:31');
INSERT INTO `act_re_deployment` VALUES ('30005', 'XXX', null, '', '2017-08-30 12:08:40');
INSERT INTO `act_re_deployment` VALUES ('32504', 'XXX', null, '', '2017-08-31 09:45:18');
INSERT INTO `act_re_deployment` VALUES ('40001', 'XXX-', null, '', '2017-08-31 15:58:39');

-- ----------------------------
-- 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 ('qingjia__process:2:40004', '1', 'http://www.activiti.org/test', 'qingjiaprocess', 'qingjia__process', '2', '40001', 'qingjia.bpmn', 'qingjia.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
-- ----------------------------

-- ----------------------------
-- Table structure for act_ru_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_identitylink`;
CREATE TABLE `act_ru_identitylink` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int(11) DEFAULT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_identitylink
-- ----------------------------

-- ----------------------------
-- Table structure for act_ru_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_job`;
CREATE TABLE `act_ru_job` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `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
-- ----------------------------

-- ----------------------------
-- Table structure for act_ru_variable
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_variable`;
CREATE TABLE `act_ru_variable` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_variable
-- ----------------------------

-- ----------------------------
-- Table structure for approve
-- ----------------------------
DROP TABLE IF EXISTS `approve`;
CREATE TABLE `approve` (
  `AID` int(11) NOT NULL AUTO_INCREMENT,
  `APPROVENAME` varchar(255) DEFAULT NULL,
  `APPROVETIME` datetime DEFAULT NULL,
  `ISAPPROVE` tinyint(1) DEFAULT NULL,
  `FORM` int(11) DEFAULT NULL,
  `FID` int(11) DEFAULT NULL,
  PRIMARY KEY (`AID`),
  KEY `FKFB868F2DDC702388` (`FID`),
  KEY `FKFB868F2DDC9EA44B` (`FORM`),
  CONSTRAINT `FKFB868F2DDC702388` FOREIGN KEY (`FID`) REFERENCES `form` (`FID`),
  CONSTRAINT `FKFB868F2DDC9EA44B` FOREIGN KEY (`FORM`) REFERENCES `form` (`FID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of approve
-- ----------------------------

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `DID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(255) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`DID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('3', '工程部门', '工程业务相关事务');
INSERT INTO `department` VALUES ('5', '公关部门', '公关事情..........');
INSERT INTO `department` VALUES ('6', '财务部门', '财务相关');
INSERT INTO `department` VALUES ('7', '人力资源部门', '人力资源相关1');

-- ----------------------------
-- Table structure for form
-- ----------------------------
DROP TABLE IF EXISTS `form`;
CREATE TABLE `form` (
  `FID` int(11) NOT NULL AUTO_INCREMENT,
  `TITLE` varchar(255) DEFAULT NULL,
  `APPLICATOR` varchar(255) DEFAULT NULL,
  `APPLICTETIME` datetime DEFAULT NULL,
  `STATE` varchar(255) DEFAULT NULL,
  `URL` varchar(255) DEFAULT NULL,
  `FTID` int(11) DEFAULT NULL,
  `formTemplate` int(11) DEFAULT NULL,
  `piid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`FID`),
  KEY `FK2104C4D1436F8A` (`FTID`),
  KEY `FK2104C4C17265F` (`formTemplate`),
  CONSTRAINT `FK2104C4C17265F` FOREIGN KEY (`formTemplate`) REFERENCES `formtemplate` (`FTID`),
  CONSTRAINT `FK2104C4D1436F8A` FOREIGN KEY (`FTID`) REFERENCES `formtemplate` (`FTID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of form
-- ----------------------------
INSERT INTO `form` VALUES ('3', '请假FGG_blake_Thu Aug 31 16:02:26 CST 2017', 'blake', '2017-08-31 16:02:26', '申请中', 'E:\\JAVA\\My Eclipse\\my eclipse 2014\\.metadata\\.me_tcat\\webapps\\oa\\document\\uri.txt', null, '4', '42501');
INSERT INTO `form` VALUES ('4', '请假FGG_blake_Sun Oct 08 18:49:54 CST 2017', 'blake', '2017-10-08 18:49:54', '申请中', 'D:\\Java_ssh\\tomcat_and_jboss_as\\apache-tomcat-6.0.35\\webapps\\oa\\document\\图解道德经故事.pdf', null, '4', '50001');
INSERT INTO `form` VALUES ('5', '请假FGG_blake_Sun Oct 08 18:51:12 CST 2017', 'blake', '2017-10-08 18:51:12', '申请中', 'D:\\Java_ssh\\tomcat_and_jboss_as\\apache-tomcat-6.0.35\\webapps\\oa\\document\\道德经全文及翻译.pdf', null, '4', '50015');
INSERT INTO `form` VALUES ('6', '请假FGG_blake_Sun Oct 08 19:11:47 CST 2017', 'blake', '2017-10-08 19:11:47', '申请中', 'D:\\Java_ssh\\tomcat_and_jboss_as\\apache-tomcat-6.0.35\\webapps\\oa\\document\\道德经全文及翻译.pdf', '4', '4', '55001');

-- ----------------------------
-- Table structure for formtemplate
-- ----------------------------
DROP TABLE IF EXISTS `formtemplate`;
CREATE TABLE `formtemplate` (
  `FTID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(255) DEFAULT NULL,
  `PROCESSKEY` varchar(255) DEFAULT NULL,
  `URL` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`FTID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of formtemplate
-- ----------------------------
INSERT INTO `formtemplate` VALUES ('4', '请假FGG', 'qingjia__process', 'E:\\JAVA\\My Eclipse\\my eclipse 2014\\.metadata\\.me_tcat\\webapps\\oa\\document\\GSH.odt');

-- ----------------------------
-- Table structure for menuitems
-- ----------------------------
DROP TABLE IF EXISTS `menuitems`;
CREATE TABLE `menuitems` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL,
  `isParent` tinyint(1) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mid`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of menuitems
-- ----------------------------
INSERT INTO `menuitems` VALUES ('3', '0', '1', '办公自动化', 'css/images/MenuIcon/FUNC20082.gif');
INSERT INTO `menuitems` VALUES ('4', '1', '1', '个人办公', 'css/images/MenuIcon/FUNC20001.gif');
INSERT INTO `menuitems` VALUES ('5', '2', '0', '个人考勤', 'css/images/MenuIcon/FUNC20054.gif');
INSERT INTO `menuitems` VALUES ('6', '2', '0', '日程安排', 'css/images/MenuIcon/FUNC23700.gif');
INSERT INTO `menuitems` VALUES ('7', '2', '0', '工作计划', 'css/images/MenuIcon/FUNC20069.gif');
INSERT INTO `menuitems` VALUES ('8', '2', '0', '工作日记', 'css/images/MenuIcon/FUNC20056.gif');
INSERT INTO `menuitems` VALUES ('9', '2', '0', '通讯录', 'css/images/MenuIcon/time_date.gif');
INSERT INTO `menuitems` VALUES ('10', '1', '1', '审批流转', 'css/images/MenuIcon/FUNC20057.gif');
INSERT INTO `menuitems` VALUES ('11', '1', '0', '权限管理', 'css/images/MenuIcon/system.gif');
INSERT INTO `menuitems` VALUES ('12', '3', '0', '表单模板管理', 'css/images/MenuIcon/formmodel.gif');
INSERT INTO `menuitems` VALUES ('13', '3', '0', '发起申请', 'css/images/MenuIcon/FUNC241000.gif');
INSERT INTO `menuitems` VALUES ('14', '3', '0', '审批申请', 'css/images/MenuIcon/FUNC20029.gif');
INSERT INTO `menuitems` VALUES ('15', '3', '0', '状态查询', 'css/images/MenuIcon/FUNC20029.gif');
INSERT INTO `menuitems` VALUES ('16', '1', '0', '知识管理', 'css/images/MenuIcon/FUNC20056.gif');
INSERT INTO `menuitems` VALUES ('17', '1', '1', '管理行政', 'css/images/MenuIcon/manager.gif');
INSERT INTO `menuitems` VALUES ('18', '5', '0', '考勤管理', 'css/images/MenuIcon/FUNC20070.gif');
INSERT INTO `menuitems` VALUES ('19', '5', '0', '会议管理', 'css/images/MenuIcon/FUNC20064.gif');
INSERT INTO `menuitems` VALUES ('20', '5', '0', '车辆管理', 'css/images/MenuIcon/radio_blue.gif');
INSERT INTO `menuitems` VALUES ('21', '1', '1', '人力资源', 'css/images/MenuIcon/FUNC20001.gif');
INSERT INTO `menuitems` VALUES ('22', '6', '0', '档案管理', 'css/images/MenuIcon/FUNC20076.gif');
INSERT INTO `menuitems` VALUES ('23', '6', '0', '培训记录', 'css/images/MenuIcon/FUNC55000.gif');
INSERT INTO `menuitems` VALUES ('24', '6', '0', '奖赏记录', 'css/images/MenuIcon/FUNC55000.gif');
INSERT INTO `menuitems` VALUES ('25', '6', '0', '职位变更', 'css/images/MenuIcon/FUNC55000.gif');
INSERT INTO `menuitems` VALUES ('26', '6', '0', '人事合同', 'css/images/MenuIcon/FUNC55000.gif');
INSERT INTO `menuitems` VALUES ('27', '6', '0', '薪酬制度', 'css/images/MenuIcon/FUNC20001.gif');
INSERT INTO `menuitems` VALUES ('28', '1', '0', '电子邮件', 'css/images/MenuIcon/eml.gif');
INSERT INTO `menuitems` VALUES ('29', '1', '1', '实用工具', 'css/images/MenuIcon/FUNC20076.gif');
INSERT INTO `menuitems` VALUES ('30', '8', '0', '车票预定', 'css/images/MenuIcon/FUNC220000.gif');
INSERT INTO `menuitems` VALUES ('31', '8', '0', 'GIS查询', 'css/images/MenuIcon/search.gif');
INSERT INTO `menuitems` VALUES ('32', '8', '0', '邮政编码', 'css/images/MenuIcon/FUNC249000.gif');
INSERT INTO `menuitems` VALUES ('33', '1', '1', '个人设置', 'css/images/MenuIcon/FUNC20001.gif');
INSERT INTO `menuitems` VALUES ('34', '9', '0', '个人信息', 'css/images/MenuIcon/FUNC20001.gif');
INSERT INTO `menuitems` VALUES ('35', '9', '0', '密码修改', 'css/images/MenuIcon/FUNC241000.gif');
INSERT INTO `menuitems` VALUES ('36', '1', '1', '系统管理', 'css/images/MenuIcon/system.gif');
INSERT INTO `menuitems` VALUES ('37', '10', '0', '岗位管理', 'css/images/MenuIcon/FUNC20001.gif');
INSERT INTO `menuitems` VALUES ('38', '10', '0', '部门管理', 'css/images/MenuIcon/department.gif');
INSERT INTO `menuitems` VALUES ('39', '10', '0', '用户管理', 'css/images/MenuIcon/FUNC20001.gif');
INSERT INTO `menuitems` VALUES ('40', '1', '1', '权限管理', 'css/images/MenuIcon/system.gif');

-- ----------------------------
-- Table structure for persons
-- ----------------------------
DROP TABLE IF EXISTS `persons`;
CREATE TABLE `persons` (
  `PID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(255) DEFAULT NULL,
  `SEX` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`PID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of persons
-- ----------------------------

-- ----------------------------
-- Table structure for privileges
-- ----------------------------
DROP TABLE IF EXISTS `privileges`;
CREATE TABLE `privileges` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `flag` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `target` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `checked` tinyint(1) DEFAULT NULL,
  `isParent` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of privileges
-- ----------------------------
INSERT INTO `privileges` VALUES ('1', '办公自动化', '1', null, null, 'css/images/MenuIcon/FUNC20082.gif', '0', null, '1');
INSERT INTO `privileges` VALUES ('2', '个人办公', '1', null, null, 'css/images/MenuIcon/FUNC20001.gif', '1', null, '1');
INSERT INTO `privileges` VALUES ('3', '审批流转', '1', null, null, 'css/images/MenuIcon/FUNC20057.gif', '1', null, '1');
INSERT INTO `privileges` VALUES ('4', '知识管理', '1', null, null, 'css/images/MenuIcon/FUNC20056.gif', '1', null, '0');
INSERT INTO `privileges` VALUES ('5', '管理行政', '1', null, null, 'css/images/MenuIcon/manager.gif', '1', null, '1');
INSERT INTO `privileges` VALUES ('6', '人力资源', '1', null, null, 'css/images/MenuIcon/FUNC20001.gif', '1', null, '1');
INSERT INTO `privileges` VALUES ('7', '电子邮件', '1', null, null, 'css/images/MenuIcon/eml.gif', '1', null, '0');
INSERT INTO `privileges` VALUES ('8', '实用工具', '1', null, null, 'css/images/MenuIcon/FUNC20076.gif', '1', null, '1');
INSERT INTO `privileges` VALUES ('9', '个人设置', '1', null, null, 'css/images/MenuIcon/FUNC20001.gif', '1', null, '1');
INSERT INTO `privileges` VALUES ('10', '系统管理', '1', null, null, 'css/images/MenuIcon/system.gif', '1', null, '1');
INSERT INTO `privileges` VALUES ('21', '个人考勤', '1', null, null, 'css/images/MenuIcon/FUNC20054.gif', '2', null, '0');
INSERT INTO `privileges` VALUES ('22', '日程安排', '1', null, null, 'css/images/MenuIcon/FUNC23700.gif', '2', null, '0');
INSERT INTO `privileges` VALUES ('23', '工作计划', '1', null, null, 'css/images/MenuIcon/FUNC20069.gif', '2', null, '0');
INSERT INTO `privileges` VALUES ('24', '工作日记', '1', null, null, 'css/images/MenuIcon/FUNC20056.gif', '2', null, '0');
INSERT INTO `privileges` VALUES ('25', '通讯录', '1', null, null, 'css/images/MenuIcon/time_date.gif', '2', null, '0');
INSERT INTO `privileges` VALUES ('31', '审批流程管理', '1', 'showLasterVersions', 'right', 'css/images/MenuIcon/manager.gif', '3', null, '0');
INSERT INTO `privileges` VALUES ('32', '表单模板管理', '1', 'showFormTemplate', 'right', 'css/images/MenuIcon/formmodel.gif', '3', null, '0');
INSERT INTO `privileges` VALUES ('33', '发起申请', '1', 'showWorkFlowFormTemplate', 'right', 'css/images/MenuIcon/FUNC241000.gif', '3', null, '0');
INSERT INTO `privileges` VALUES ('34', '审批申请', '1', 'myTaskList', 'right', 'css/images/MenuIcon/FUNC20029.gif', '3', null, '0');
INSERT INTO `privileges` VALUES ('35', '状态查询', '1', 'listForm', 'right', 'css/images/MenuIcon/FUNC20029.gif', '3', null, '0');
INSERT INTO `privileges` VALUES ('51', '考勤管理', '1', null, null, 'css/images/MenuIcon/FUNC20070.gif', '5', null, '0');
INSERT INTO `privileges` VALUES ('52', '会议管理', '1', null, null, 'css/images/MenuIcon/FUNC20064.gif', '5', null, '0');
INSERT INTO `privileges` VALUES ('53', '车辆管理', '1', null, null, 'css/images/MenuIcon/radio_blue.gif', '5', null, '0');
INSERT INTO `privileges` VALUES ('61', '档案管理', '1', null, null, 'css/images/MenuIcon/FUNC20076.gif', '6', null, '0');
INSERT INTO `privileges` VALUES ('62', '培训记录', '1', null, null, 'css/images/MenuIcon/FUNC55000.gif', '6', null, '0');
INSERT INTO `privileges` VALUES ('63', '奖赏记录', '1', null, null, 'css/images/MenuIcon/FUNC55000.gif', '6', null, '0');
INSERT INTO `privileges` VALUES ('64', '职位变更', '1', null, null, 'css/images/MenuIcon/FUNC55000.gif', '6', null, '0');
INSERT INTO `privileges` VALUES ('65', '人事合同', '1', null, null, 'css/images/MenuIcon/FUNC55000.gif', '6', null, '0');
INSERT INTO `privileges` VALUES ('66', '薪酬制度', '1', null, null, 'css/images/MenuIcon/FUNC20001.gif', '6', null, '0');
INSERT INTO `privileges` VALUES ('81', '车票预定', '1', null, null, 'css/images/MenuIcon/FUNC220000.gif', '8', null, '0');
INSERT INTO `privileges` VALUES ('82', 'GIS查询', '1', null, null, 'css/images/MenuIcon/search.gif', '8', null, '0');
INSERT INTO `privileges` VALUES ('83', '邮政编码', '1', null, null, 'css/images/MenuIcon/FUNC249000.gif', '8', null, '0');
INSERT INTO `privileges` VALUES ('91', '个人信息', '1', null, null, 'css/images/MenuIcon/FUNC20001.gif', '9', null, '0');
INSERT INTO `privileges` VALUES ('92', '密码修改', '1', null, null, 'css/images/MenuIcon/FUNC241000.gif', '9', null, '0');
INSERT INTO `privileges` VALUES ('101', '岗位管理', '1', 'showAllRole', 'right', 'css/images/MenuIcon/FUNC20001.gif', '10', null, '0');
INSERT INTO `privileges` VALUES ('102', '部门管理', '1', 'showAllDepartment', 'right', 'css/images/MenuIcon/department.gif', '10', null, '0');
INSERT INTO `privileges` VALUES ('103', '用户管理', '1', 'showAllUser', 'right', 'css/images/MenuIcon/FUNC20001.gif', '10', null, '0');
INSERT INTO `privileges` VALUES ('201', '用户增加', '2', 'addUser_', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('202', '用户删除', '2', 'removeUser', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('203', '用户修改', '2', 'updateUser_', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('204', '部门增加', '2', 'add_', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('205', '部门删除', '2', 'removeDepartment', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('206', '部门修改', '2', 'updateDepartment_', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('207', '岗位增加', '2', 'addRole_', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('208', '岗位删除', '2', 'removeRole', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('209', '岗位修改', '2', 'updateRole_', 'right', 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('210', '用户查询', '2', null, null, 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('211', '部门查询', '2', null, null, 'css/images/MenuIcon/system.gif', '0', null, null);
INSERT INTO `privileges` VALUES ('212', '岗位查询', '2', null, null, 'css/images/MenuIcon/system.gif', '0', null, null);

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `RID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(255) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `checked` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`RID`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('8', 'Java高级工程师', 'Java开发', null, null);
INSERT INTO `role` VALUES ('9', '网页设计师', '网页设计', null, null);
INSERT INTO `role` VALUES ('10', '用户角色', '拥有用户模块的crud的操作', '0', null);
INSERT INTO `role` VALUES ('11', '部门角色', '拥有部门模块的crud的操作', '0', null);
INSERT INTO `role` VALUES ('12', '岗位角色', '拥有岗位模块的crud的操作', '0', null);

-- ----------------------------
-- Table structure for role_privilege
-- ----------------------------
DROP TABLE IF EXISTS `role_privilege`;
CREATE TABLE `role_privilege` (
  `id` int(11) NOT NULL,
  `RID` int(11) NOT NULL,
  PRIMARY KEY (`id`,`RID`),
  KEY `FK_6bjnvuwt6l90raimt98q4b39n` (`RID`),
  KEY `FK_bccw9m8lcly5r6u78an9hhk5u` (`id`),
  CONSTRAINT `FK_6bjnvuwt6l90raimt98q4b39n` FOREIGN KEY (`RID`) REFERENCES `role` (`RID`),
  CONSTRAINT `FK_bccw9m8lcly5r6u78an9hhk5u` FOREIGN KEY (`id`) REFERENCES `privileges` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of role_privilege
-- ----------------------------
INSERT INTO `role_privilege` VALUES ('1', '9');
INSERT INTO `role_privilege` VALUES ('2', '9');
INSERT INTO `role_privilege` VALUES ('3', '9');
INSERT INTO `role_privilege` VALUES ('4', '9');
INSERT INTO `role_privilege` VALUES ('9', '9');
INSERT INTO `role_privilege` VALUES ('21', '9');
INSERT INTO `role_privilege` VALUES ('22', '9');
INSERT INTO `role_privilege` VALUES ('23', '9');
INSERT INTO `role_privilege` VALUES ('24', '9');
INSERT INTO `role_privilege` VALUES ('25', '9');
INSERT INTO `role_privilege` VALUES ('33', '9');
INSERT INTO `role_privilege` VALUES ('35', '9');
INSERT INTO `role_privilege` VALUES ('91', '9');
INSERT INTO `role_privilege` VALUES ('92', '9');
INSERT INTO `role_privilege` VALUES ('1', '10');
INSERT INTO `role_privilege` VALUES ('3', '10');
INSERT INTO `role_privilege` VALUES ('4', '10');
INSERT INTO `role_privilege` VALUES ('7', '10');
INSERT INTO `role_privilege` VALUES ('8', '10');
INSERT INTO `role_privilege` VALUES ('33', '10');
INSERT INTO `role_privilege` VALUES ('35', '10');
INSERT INTO `role_privilege` VALUES ('81', '10');
INSERT INTO `role_privilege` VALUES ('82', '10');
INSERT INTO `role_privilege` VALUES ('83', '10');

-- ----------------------------
-- Table structure for role_user
-- ----------------------------
DROP TABLE IF EXISTS `role_user`;
CREATE TABLE `role_user` (
  `RID` int(11) NOT NULL,
  `UID` int(11) NOT NULL,
  PRIMARY KEY (`UID`,`RID`),
  KEY `FK_adkdstw2co1nmerbbk4t6cj8h` (`UID`),
  KEY `FK_vg3hgeujsflu70tikkbn78dd` (`RID`),
  CONSTRAINT `FK_adkdstw2co1nmerbbk4t6cj8h` FOREIGN KEY (`UID`) REFERENCES `user` (`UID`),
  CONSTRAINT `FK_vg3hgeujsflu70tikkbn78dd` FOREIGN KEY (`RID`) REFERENCES `role` (`RID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of role_user
-- ----------------------------
INSERT INTO `role_user` VALUES ('10', '43');
INSERT INTO `role_user` VALUES ('10', '61');
INSERT INTO `role_user` VALUES ('10', '62');
INSERT INTO `role_user` VALUES ('8', '64');
INSERT INTO `role_user` VALUES ('9', '64');
INSERT INTO `role_user` VALUES ('10', '64');
INSERT INTO `role_user` VALUES ('11', '64');
INSERT INTO `role_user` VALUES ('12', '64');
INSERT INTO `role_user` VALUES ('9', '65');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `UID` int(11) NOT NULL AUTO_INCREMENT,
  `USERNAME` varchar(255) DEFAULT NULL,
  `PASSWORD` varchar(255) DEFAULT NULL,
  `SEX` varchar(255) DEFAULT NULL,
  `PHONE` varchar(255) DEFAULT NULL,
  `EMAIL` varchar(255) DEFAULT NULL,
  `DEPARTMENT` int(11) DEFAULT NULL,
  `DID` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`UID`),
  KEY `FK_qrcvh4dwheupc57pi1xvt3deo` (`DEPARTMENT`),
  KEY `FK_27t9mgfx5xao4qi4tachmcr9s` (`DID`),
  CONSTRAINT `FK_27t9mgfx5xao4qi4tachmcr9s` FOREIGN KEY (`DID`) REFERENCES `department` (`DID`),
  CONSTRAINT `FK_qrcvh4dwheupc57pi1xvt3deo` FOREIGN KEY (`DEPARTMENT`) REFERENCES `department` (`DID`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('43', 'blake', 'CFDA7C24A51F4FAE9C131C73FC2E797719612D303775FE7CC0AD091D', '男', '6346333', 'noatnu@163.com', '3', null, '布莱克');
INSERT INTO `user` VALUES ('61', 'alice', 'CFDA7C24A51F4FAE9C131C73FC2E797719612D303775FE7CC0AD091D', '男', '1243325637', 'zhangsan@163.com', '3', null, '张三');
INSERT INTO `user` VALUES ('62', 'admin', 'D5C6CED99018555B5A1FFCA7DD4446D842C4631C5B857F17B6B300E7', '女', '6346333', 'admin@163.com', '3', null, '超级管理员');
INSERT INTO `user` VALUES ('64', 'lee', 'F0B32AC6517CA9D6DCD1B36E4135BA71568EC713FE6DA1336A30C9BC', '男', '27652718', 'lee@163.com', '3', null, '李');
INSERT INTO `user` VALUES ('65', 'baobao', '29EB5BA1D4955A7CCACC08175E74709AE3049FCF2A11E80B14AFB863', '男', '54678', 'baobao@163.com', '3', null, '宝宝');