加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
ky_activitidb.sql 70.28 KB
一键复制 编辑 原始数据 按行查看 历史
Skyeye云源码 提交于 2019-12-18 09:51 . 数据库上传
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50130
Source Host : localhost:3306
Source Database : activitidb
Target Server Type : MYSQL
Target Server Version : 50130
File Encoding : 65001
Date: 2019-01-13 11:45:56
*/
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 COMMENT='资源文件表(一个存储xml,一个存储图片)';
-- ----------------------------
-- Records of act_ge_bytearray
-- ----------------------------
INSERT INTO `act_ge_bytearray` VALUES ('10002', '1', 'source', null, 0x7B226964223A2263616E766173222C227265736F757263654964223A2263616E766173222C227374656E63696C736574223A7B226E616D657370616365223A22687474703A2F2F62336D6E2E6F72672F7374656E63696C7365742F62706D6E322E3023227D7D, null);
INSERT INTO `act_ge_bytearray` VALUES ('2502', '3', 'source', null, 0x7B227265736F757263654964223A2232353031222C2270726F70657274696573223A7B2270726F636573735F6964223A2270726F63657373222C226E616D65223A22222C22646F63756D656E746174696F6E223A22222C2270726F636573735F617574686F72223A22222C2270726F636573735F76657273696F6E223A22222C2270726F636573735F6E616D657370616365223A22687474703A2F2F7777772E61637469766974692E6F72672F70726F63657373646566222C22657865637574696F6E6C697374656E657273223A22222C226576656E746C697374656E657273223A22222C227369676E616C646566696E6974696F6E73223A22222C226D657373616765646566696E6974696F6E73223A22227D2C227374656E63696C223A7B226964223A2242504D4E4469616772616D227D2C226368696C64536861706573223A5B7B227265736F757263654964223A227369642D44444143323641362D384139302D344235412D383539302D434536453730353533414246222C2270726F70657274696573223A7B226F766572726964656964223A22222C226E616D65223A22E5BC80E5A78B222C22646F63756D656E746174696F6E223A22222C22657865637574696F6E6C697374656E657273223A22222C22696E69746961746F72223A22222C22666F726D6B6579646566696E6974696F6E223A22222C22666F726D70726F70657274696573223A22227D2C227374656E63696C223A7B226964223A2253746172744E6F6E654576656E74227D2C226368696C64536861706573223A5B5D2C226F7574676F696E67223A5B7B227265736F757263654964223A227369642D45343242453830412D383944412D343431352D413833312D423336333534353332393341227D5D2C22626F756E6473223A7B226C6F7765725269676874223A7B2278223A3232352C2279223A3138307D2C2275707065724C656674223A7B2278223A3139352C2279223A3135307D7D2C22646F636B657273223A5B5D7D2C7B227265736F757263654964223A227369642D30464444453437422D364436442D344233342D384546442D433235373635413837334336222C2270726F70657274696573223A7B226F766572726964656964223A22222C226E616D65223A22E7BB93E69D9F222C22646F63756D656E746174696F6E223A22222C22657865637574696F6E6C697374656E657273223A22227D2C227374656E63696C223A7B226964223A22456E644E6F6E654576656E74227D2C226368696C64536861706573223A5B5D2C226F7574676F696E67223A5B5D2C22626F756E6473223A7B226C6F7765725269676874223A7B2278223A3739332C2279223A3137387D2C2275707065724C656674223A7B2278223A3736352C2279223A3135307D7D2C22646F636B657273223A5B5D7D2C7B227265736F757263654964223A227369642D38443944414342362D304536432D343242302D423034352D354342333545413336444139222C2270726F70657274696573223A7B226F766572726964656964223A22222C226E616D65223A22E5AEA1E689B9222C22646F63756D656E746174696F6E223A22222C226173796E6368726F6E6F7573646566696E6974696F6E223A2266616C7365222C226578636C7573697665646566696E6974696F6E223A2266616C7365222C22657865637574696F6E6C697374656E657273223A22222C226D756C7469696E7374616E63655F74797065223A224E6F6E65222C226D756C7469696E7374616E63655F63617264696E616C697479223A22222C226D756C7469696E7374616E63655F636F6C6C656374696F6E223A22222C226D756C7469696E7374616E63655F7661726961626C65223A22222C226D756C7469696E7374616E63655F636F6E646974696F6E223A22222C226973666F72636F6D70656E736174696F6E223A2266616C7365222C22757365727461736B61737369676E6D656E74223A22222C22666F726D6B6579646566696E6974696F6E223A22222C2264756564617465646566696E6974696F6E223A22222C227072696F72697479646566696E6974696F6E223A22222C22666F726D70726F70657274696573223A22222C227461736B6C697374656E657273223A22227D2C227374656E63696C223A7B226964223A22557365725461736B227D2C226368696C64536861706573223A5B5D2C226F7574676F696E67223A5B7B227265736F757263654964223A227369642D30443530354546392D383434332D344639452D383338382D433838393045333046333137227D5D2C22626F756E6473223A7B226C6F7765725269676874223A7B2278223A3632352C2279223A3230357D2C2275707065724C656674223A7B2278223A3532352C2279223A3132357D7D2C22646F636B657273223A5B5D7D2C7B227265736F757263654964223A227369642D37423634364237332D303830342D343631422D414645312D333331353844334532323339222C2270726F70657274696573223A7B226F766572726964656964223A22222C226E616D65223A22E68F90E4BAA4E794B3E8AFB7222C22646F63756D656E746174696F6E223A22222C226173796E6368726F6E6F7573646566696E6974696F6E223A2266616C7365222C226578636C7573697665646566696E6974696F6E223A2266616C7365222C22657865637574696F6E6C697374656E657273223A22222C226D756C7469696E7374616E63655F74797065223A224E6F6E65222C226D756C7469696E7374616E63655F63617264696E616C697479223A22222C226D756C7469696E7374616E63655F636F6C6C656374696F6E223A22222C226D756C7469696E7374616E63655F7661726961626C65223A22222C226D756C7469696E7374616E63655F636F6E646974696F6E223A22222C226973666F72636F6D70656E736174696F6E223A2266616C7365222C22757365727461736B61737369676E6D656E74223A22222C22666F726D6B6579646566696E6974696F6E223A22222C2264756564617465646566696E6974696F6E223A22222C227072696F72697479646566696E6974696F6E223A22222C22666F726D70726F70657274696573223A22222C227461736B6C697374656E657273223A22227D2C227374656E63696C223A7B226964223A22557365725461736B227D2C226368696C64536861706573223A5B5D2C226F7574676F696E67223A5B7B227265736F757263654964223A227369642D35314437394243382D303838332D343537392D424632372D453637393838303637414444227D5D2C22626F756E6473223A7B226C6F7765725269676874223A7B2278223A3433302C2279223A3230347D2C2275707065724C656674223A7B2278223A3333302C2279223A3132347D7D2C22646F636B657273223A5B5D7D2C7B227265736F757263654964223A227369642D45343242453830412D383944412D343431352D413833312D423336333534353332393341222C2270726F70657274696573223A7B226F766572726964656964223A22222C226E616D65223A22222C22646F63756D656E746174696F6E223A22222C22636F6E646974696F6E73657175656E6365666C6F77223A22222C22657865637574696F6E6C697374656E657273223A22222C2264656661756C74666C6F77223A2266616C7365227D2C227374656E63696C223A7B226964223A2253657175656E6365466C6F77227D2C226368696C64536861706573223A5B5D2C226F7574676F696E67223A5B7B227265736F757263654964223A227369642D37423634364237332D303830342D343631422D414645312D333331353844334532323339227D5D2C22626F756E6473223A7B226C6F7765725269676874223A7B2278223A3332392E383539333932333030353839312C2279223A3136342E3930383138303234383832377D2C2275707065724C656674223A7B2278223A3232352E363039333537363939343130392C2279223A3136342E3239343934343735313137337D7D2C22646F636B657273223A5B7B2278223A31352C2279223A31357D2C7B2278223A35302C2279223A34307D5D2C22746172676574223A7B227265736F757263654964223A227369642D37423634364237332D303830342D343631422D414645312D333331353844334532323339227D7D2C7B227265736F757263654964223A227369642D35314437394243382D303838332D343537392D424632372D453637393838303637414444222C2270726F70657274696573223A7B226F766572726964656964223A22222C226E616D65223A22222C22646F63756D656E746174696F6E223A22222C22636F6E646974696F6E73657175656E6365666C6F77223A22222C22657865637574696F6E6C697374656E657273223A22222C2264656661756C74666C6F77223A2266616C7365227D2C227374656E63696C223A7B226964223A2253657175656E6365466C6F77227D2C226368696C64536861706573223A5B5D2C226F7574676F696E67223A5B7B227265736F757263654964223A227369642D38443944414342362D304536432D343242302D423034352D354342333545413336444139227D5D2C22626F756E6473223A7B226C6F7765725269676874223A7B2278223A3532342E343838323934333938393834352C2279223A3136342E373430393635363132333032357D2C2275707065724C656674223A7B2278223A3433302E353131373035363031303135342C2279223A3136342E323539303334333837363937357D7D2C22646F636B657273223A5B7B2278223A35302C2279223A34307D2C7B2278223A35302C2279223A34307D5D2C22746172676574223A7B227265736F757263654964223A227369642D38443944414342362D304536432D343242302D423034352D354342333545413336444139227D7D2C7B227265736F757263654964223A227369642D30443530354546392D383434332D344639452D383338382D433838393045333046333137222C2270726F70657274696573223A7B226F766572726964656964223A22222C226E616D65223A22222C22646F63756D656E746174696F6E223A22222C22636F6E646974696F6E73657175656E6365666C6F77223A22222C22657865637574696F6E6C697374656E657273223A22222C2264656661756C74666C6F77223A2266616C7365227D2C227374656E63696C223A7B226964223A2253657175656E6365466C6F77227D2C226368696C64536861706573223A5B5D2C226F7574676F696E67223A5B7B227265736F757263654964223A227369642D30464444453437422D364436442D344233342D384546442D433235373635413837334336227D5D2C22626F756E6473223A7B226C6F7765725269676874223A7B2278223A3736342E343533313337303134333933332C2279223A3136342E37353239313035393831303937367D2C2275707065724C656674223A7B2278223A3632352E343036323337393835363036372C2279223A3136342E30373133303831353138393032347D7D2C22646F636B657273223A5B7B2278223A35302C2279223A34307D2C7B2278223A31342C2279223A31347D5D2C22746172676574223A7B227265736F757263654964223A227369642D30464444453437422D364436442D344233342D384546442D433235373635413837334336227D7D5D2C22626F756E6473223A7B226C6F7765725269676874223A7B2278223A313230302C2279223A313035307D2C2275707065724C656674223A7B2278223A302C2279223A307D7D2C227374656E63696C736574223A7B2275726C223A227374656E63696C736574732F62706D6E322E302F62706D6E322E302E6A736F6E222C226E616D657370616365223A22687474703A2F2F62336D6E2E6F72672F7374656E63696C7365742F62706D6E322E3023227D2C227373657874656E73696F6E73223A5B5D7D, null);
INSERT INTO `act_ge_bytearray` VALUES ('2504', '1', 'source', null, 0x7B226964223A2263616E766173222C227265736F757263654964223A2263616E766173222C227374656E63696C736574223A7B226E616D657370616365223A22687474703A2F2F62336D6E2E6F72672F7374656E63696C7365742F62706D6E322E3023227D7D, null);
INSERT INTO `act_ge_bytearray` VALUES ('2506', '1', 'source', null, 0x7B226964223A2263616E766173222C227265736F757263654964223A2263616E766173222C227374656E63696C736574223A7B226E616D657370616365223A22687474703A2F2F62336D6E2E6F72672F7374656E63696C7365742F62706D6E322E3023227D7D, null);
INSERT INTO `act_ge_bytearray` VALUES ('2508', '1', 'source', null, 0x7B226964223A2263616E766173222C227265736F757263654964223A2263616E766173222C227374656E63696C736574223A7B226E616D657370616365223A22687474703A2F2F62336D6E2E6F72672F7374656E63696C7365742F62706D6E322E3023227D7D, null);
INSERT INTO `act_ge_bytearray` VALUES ('5001', '1', 'source-extra', null, 0x89504E470D0A1A0A0000000D494844520000034B000000FF080600000020F74D88000000206348524D00007A26000080840000FA00000080E8000075300000EA6000003A98000017709CBA513C0000000467414D410000B18E7CFB5193000000017352474200AECE1CE900000006624B474400FF00FF00FFA0BDA793000000097048597300000EC400000EC401952B0E1B00001D944944415478DAEDDD0B989565BD28F06F868119E5A608A266DEF29A99D431DDBB4D8A855A6AE5290D142CEBB1D05DEDD2DCDBCB3133C3AC7DB4B27699A5A904821752D324919DFA481ED35011D46D9A20EA3022B7E13A023373DEFF9AB5A6C570159899358BDFEF79DE675DE65B7379E7BBBCFFFF7BF9B20C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000804DA9500500EF5C737373CDAC59B3BEB66CD9B2912B56AC3868F9F2E5354D4D4D2A666B2F4A1515CDD5D5D50B7AF4E8F1C4EAD5ABAF1E3C78F0436A0500C11240179182A473E6CF9F7F4D4343C38EBBEDB65BD6B76FDFAC77EFDE596565A5CAD94A1170A600345BB26449565757B7AAB1B1F185952B578E3CE1841366AA1D8903890340B00450C2E6CC9973F72BAFBCF2E9BDF6DA2BDB638F3DA241A352DA516D6D6D367BF6EC95A9417EFA473FFAD17BD488C481C481C4010896004A34504AE5D3071D7450D6A74F1F15D241962F5F9E3DFBECB34BD7AC5973C6D0A143EF5323120712071207D051BAA902804D8B0C7A6AA87CEB90430E596FA0F4F6B237B3BAE7EFCAEA5EB8279B3FEBA16CC5A2595975CF5DB3AA6A41D5D6EAD1A347D6AF5FBFEABABABA13478C18F187B163C7CE532BA5913888E361C0800102A50E103D76E938E83E6FDEBC93468E1C3963CC98317F532B205802E8743127E3E5975FFEEFDD77DFBD7B340CD71728BDF6D46FB286A573D3B68DE9034DD9EA958BB22575CF663D77D95FC0B48D02A6CACACA15F5F5F51F4C8DC45BD488C481C481C4017404838A0136DD38FC5ACCC988A146EBB3F0D547B335AB96AFF37E53E3AAD4587C58056E237BEEB967BFAAAAAA031E7CF0C17F521B9D973888394A31F46E438152240E96CD7F31B7FF3737ADC9562CFC7B3667DA8D59C3923754E036D0B367CF6C9F7DF669EAD6ADDB4FD5060896003A5DACF21593D73734D468E5461A81D17864DBD975D75DEBD2C367D584C481C481C4010896004A402C871CAB7C6D4873E3EA0D7FB8D912CADB52FFFEFDDF951E86A809890389038903102C019480B86F4C4CAEA6F3A5FFC3EEE961909A903890389038808E50A50A00362EEE77E2BE31A521FF7F70ED9238903868491C0C5013D0CED71D5500B075BAEFB0F306BF5655AD6149F9903828A1069CC401089600BA827E7B7D38ABEAD1739DF7BB75DF21EBB7F76015C47643E200102C01B0965E030EC97AF63F68BDEFF7DEF55015C47643E200102C01B08EC6D52BD7796FCDDB4B550CDB15890340B00440AB55CBDFCADD7073D95B2FACF3B5E50B5ECAE6FCF5D7B96D40E20040B004B0DDA8AF7D2A054A37642B16CDDAE0362B16BF9ACD7EE2BA6CD19CC7B2664B272371A0A2802EC52A2A005BD0287CF36FF7E71A809BA3A971556EFBA5A911B9EB81276635B9157FA1BC12076FBDFC40B666D5F24D260E06BC6768B6D3BBFF29ABA890AF054A9F3315C03B140DBECD0D94D66A2C2E9A95BDFAE4F52A90B24A1CBCF6F42DD9DCE77FB7D140A96DE2E0B5A76ECA1A96CE5581806009A0DC44836F4B3537AD5181481C481C005D84617800EFD0C14347AB04C8240E00C11200C07A491C00E5CE303C000000C11200008060090000608B99B30400006423468CD873CD9A35A75454541C935E0E4A65B7547AA5D2904A5D7373F333E96B7FEED6ADDB8471E3C6BD2E5802D6924E12353366CCF8C2D34F3F7DC6DCB97307D5D6D6EEB864C992AA868686ACAAAAAAB977EFDEABFBF5EBF7469F3E7D1E4B9B7FEFC20B2F7C51AD0100A5ECF4D34F3F253D7CB5A9A9E9E8140CF558CF2635A9EC93BEB64F7A3CA5B1B1F1FF0E1F3EFCE1F4FAC6F1E3C78F152C8120A9E677BFFBDDAF468F1E7DFA82050BAA0E39E4906CC89021D9BBDFFDEE2C0547594D4D4D9602A68AA54B97F678EDB5D7F69D3973E6BE4F3DF5D419E79D77DE9CE5CB978FFED5AF7E75835A04004A490A782200FA656AE79CB0051F1F923E37247D8F512978FAE21D77DCF1B26009B6438F3FFEF897AEBCF2CA5FD4D7D757A7134276F8E18767DDBA755B67BB0898A20C183020FBE0073F987DFEF39FAF983E7DFADE13264CF8E5A851A3BEB570E1C24F96EB890400E85A860D1B36BCB2B2F2174D4D4D3B17DE8BF6CDFBDEF7BEECA8A38ECAF6DF7FFF6CA79D76CA7AF7EE9DAD58B1225BBC7871367BF6ECEC89279EC89E7AEAA96CF5EAD5858F0D4E9F7BFAF4D34F3FB71C7B99044BB001CDCDCD55BFFFFDEF27DF7CF3CDC79E74D249D9273EF189F506491B1381552ADD1E78E081836FBFFDF667BFF295AFFC9B5E2600A09303A59353A03436054ADD0A4152B4738E3FFEF85CD2B7AD1D77DC3157F6D8638FECC31FFE702E70FAC31FFE904D9A34296B6C6C8C4D7AA576D36F53C0549302A6B26AE7580D0F3610283DF2C8238F4D9932E5D8F3CF3F3F3BF9E493DF71A054EC84134EC82EBBECB21DD289E9A7679F7DF657D53000D0498152F428DD9DDA3AB9864D0440575D75552CEEB0DE40697DA2C729B68FCFC59484A2F6D3AF53C03452B004652E7A94264E9CF8A16F7FFBDBD901071CB04DBEE7DE7BEF9D5D71C5151130FDA0DC4E240040E98B394ADDBA75FB4521503AE8A083B2CB2FBF7CAD80E79D88CFC5E70F3BECB0E280E9BAD4CE3958B004652AE6284D9A34E9D8AF7FFDEB9B9D61D95CF1FD2EB9E4925EDDBB77FF59399D4800802ED0F0AFACBCA13047297A94BEF5AD6FE5E6246D8D189EF7CD6F7EB338E08A2179BF162C41198A55EF264F9E7C5DCC51DA563D4A6D450FD3B061C3AAD309EB26350E007484581E3C054A1F8BE731B520029CAD0D948A03A64832174D59185C2EA368044B50E4EEBBEFBE3196FF8E3946EDE9C4134FDCA16FDFBEFB1A8ED771860F1F3E24B1A80DDBFB71706934981C0BB05D1EBFAD73A66331872D1D7AB721F1FD628E77417373F328C1129491E8559A3973E6E76279F0EEDDBBB7FBCF1B356AD4CE959595167BE8380FEDBEFBEE2FA6FFEF75A91C51CABFE84D37DD94D5D6D6E69EFFFDEF7F5FEB6BB15CEBC6FCFCE73FCF962C59B2D93FEBF1C71F8F24C106BF5E5757972D5BB66C9DF72FBCF0427B54D7F4BD74AEBB6BE0C0816FA5E32056AEFAF869A79DD64BB540973A7E17BED3E377C488117BA68763E37961E5BBF6F0F18F7FBCB80D3538E6480996A04CCC9831E30BF3E6CDAB8AE5BE3BC2FBDFFFFE1ED5D5D5FB96C389A40B05C4FBA58773527932D57B5D3E702AB91EA7B887458C25CF45780F3D940B66FEF8C73FE6CA65975DB6D1CFC60D937FF8C31FB6BE5EB56A55EEFB6D482CFF5A74AF8C75F4EFDF3FB299B9E753A74E6DFD3DA64D9B967BBCEFBEFBB28B2FBED8CED5C5545454EC941E46A66362526A38CD4AFFE39BA2E175D65967D594CBDF78C30D37E4F6FF4D6DF3C20B2FE49E4F9F3EBDF5FD3973E6D84928E5E3B777D1F13B67738EDF356BD69C5258D421DA39FDFAF56B97DF2D56C98B7B4D1639B5ABD7B76E78C87BFAE9A7CFD8D00D67DBCB61871D56F797BFFC254E2457FB0F74B881F9C0E99C810307D60D1B36ECBE7421B92D05CC0F276B3AE3177AEBADB72268CFDE78E38D58913117C4B4DD1F77DE79E7E28B5F76D75D77E52E4C91C98BEDE32682312FAED0D87BFDF5D7B3E79F7F3EB74D5555CB29FF0B5FF8428C5DCF3DFFEB5FFF9AAD5CB9B275DCFA8F7FFCE3ECB7BFFD6DB6EBAEBBB65C24D2674E39E594DCF3238E382277E3E5306EDCB85C063102A8EF7DEF7BF6A62E9C4388983895B3D2FE7F564343C3B2D4F0BA3335C6EE993B77EE7D9D752C6C89D8D7F7DC73CFD6D73D7BF6CCEDDF714F980D6D13C75B211970DE79E7E512003D7AF4889B8A677FFAD39F6232BC3D8452B773D1F1BB22EDCFB7AFEFF84DEF1D53787EE49147B6EB2F14DF3FB56D0A2F8FE9EA6D1CC112E4A513CBA021438674E8CF3CEAA8A3764A27942E7F22E9EAD24564B7F470767A3C3B054E4BD3C5E69EF47C5C7575F5C337DF7C734347FD1EB15A6234EC6EBBEDB65C2052084A860E1D9AF5EAD532D2E28E3BEEF8C7093C0532A79D765AEE790CBF8BA0E7820B2EC8BD8E2066E6CC99D959679DB5566331343535B57EFFB074E9D2B57E5E21502A283426C3C48913738DD074BCE41A9661FEFCF9D96EBBED6647EAA2BB7F9BC0A957A1E195FEA7F353503D25BDBEA5A38F852D3161C284ECBDEF7D6F6B80336FDEBCAC6FDFBEADFBE9238F3C92EDB2CB2EB96324120DA961997B8CA1AE0B162CC8DEF5AE77E502A510732F044A74413B168EDF742D5B9CCEDD0FA46BD9CD71FCA6FD7D5061A3FDF6DBAF5D7F897DF6D9A7F8E5A0AE5EA98225C8ABADADDD3132F21D295DC8239D7F743AA15DEE3F503281536178C3C8684C0D1B36ECE5E8F1E928D173138DB4088466CD9A95EB2D9A32654A6B8F4EA177A85804302156362AF6918F7C241768DD7AEBADD95E7BEDD5FA7E34220B0DC8B63D4B3147A9201A912FBEF862F69DEF7C27BBF7DE7BB3071F7CB07539FDE2E1AA31ECEFD24B2FCD3544DB5B0466316FCB31D3EE8153E89F8E8388948777C6B1B0254E3CF1C4D6E7D18B14414FE1FE2F713F997DF7DD37F73CFE9E37DF7C33973888DEDA783FE60A2E5AB468AD39AB9FF9CC67B21B6FBC71AD1EDD52E1586013D7B2186A3B2C1DC3C3627F4F9A0A5F8BA172EDA9CDF7EF2F588232B164C992AAF63E81B4F5ECB3CF16060D7FC77FA0642F38FBC79C9FCF7EF6B31DF2F3E2A2F6DA6BAF65E3C78FCF060E1C980B62FAF4E9D3FAF5E8498A3942E79F7F7E2E7089F94C071E7860EEF78B00A8D04374D14517E532EDDFFFFEF7730DC0E260297A8E36D6B354F09EF7BC2757E277899EA333CF3C33FBE52F7F99CB1A1E77DC71857D38378FAAA31A938F3EFA680C9975CC6C07C7C23B153D46B1BF17E64BC45CA4987317C35A67CF9E9D5BF8E43FFEE33F725F8B9EDA28D193147337629B384E62FF2A24CDE27B5D72C9252519283916D802AD5DA5DB6AB9F00D8965C48B74F979908225286AA416B2F71DE5631FFB5876CF3DF7C4D3EFFA0FB4BB2D6A50343737BF7CC41147ECDF11BFE073CF3D977DF7BBDFCD35E0468C1891EB018A9E9FC18307E7EE5FF1B39FFD2CB7DDD1471FDDDAC354984F14A2B117FB71649B23C31E73338AE7676C0B310EFD4B5FFA52EBEB1832D8918DC9E82D7BF5D557A391E898E9C0E3201F2CBD3268D0A0FD4AF98F8BDED00870420C152D0C618D61A9B1DF148BE32BB68F9ED7912347E6F6E34F7DEA53AD9FBDFEFAEBDB36FA4A8A63C1F1BB114D599B45DCD2F1DB94AE67B9F72241D69E01D38A152BD66A5E0996A04C54575737A786664547064CE922FE667AE83B61C284CBFD07DAD7F0E1C337EB22932E268B2B2B2B638C5AEB3C8DB3CF3EBBB9237EC7430F3D34D71BF4D5AFB6AC281F19EF3163C6E4029F189A1713CEE32217C36FCE3DF7DC753EFFC94F7E32FBC94F7E921B3A77DD75D76DF0E714CF376A3B0C2F1A90EBBDF23635E526C3C7CF2F5E5D2F02B48E143D05D17370E185173A66DAF138C88B35E827E7E7EFFD318E8514283797F2DF1773900AFB76CCD98B0028CEE9F17CF7DD776FDD2E82A70886E2EB679C71C63A41516C5BCA819263C1F1BB9E6B57633A560B2B0255C6B52CBD9E52387E53FB66467A3F97F88B5550DB33588AEF5F64BE6009CA449F3E7D56A703BC47474E544F3FAF3E3DAC56FB9D6E7EBAB0DC9D029289757575533A7305B0E249E5F7DF7F7F6EC27A7EBCF95A43E7D6271A77D13B15F32F3616F4470056589A3C140FC33BFEF8E3D7D97EF9F2E5B9214931B42F1AA3C5F75D8AD79495E5A94C4AE5B6B40F4D4901D2E22ED5A8A9AA6ADD978B7B96A214F72C456F6D946F7CE31B1BFD7E3147AB304F0F4A50B41F7293ECF281529C9C235B70DB0E3BECB0D6F19B02AD670AC1D22BAFBCB2CD6F485B2C86BD167946B0046562A79D769A932EA6FB7764B03463C68CB8E368A3DAEF14B192C1DDF946E1E3A5B2D257041FD18B93BBC23CF34C6E3ED0E8D1A37317B7787F432B7445AF4FF44A5D71C515B9B91AA79E7A6A6E79F0934E3A699DC0A93850DA58B056103D55D163150DD158C4A138682B5E9D8F2E1D20C53FF20F695FB9AFD457BDDB98B8CFD8FA7A9662B19458E06153A267B5B8A1F7E4934FAEB568049498EEF900E9CE4D1DBFCDCDCD8FA4802A77CFA3181D70CC31C7B4DB2FD5E6DE7E8F0896A04CF4E9D3E7917471DDFFA8A38EEAB09FF9D8638F3597C389A40B793995580AF9C6BABABA674AF11E327193D758C6381E639E528895E6E2DE47717FA498885E5D5D9D5BA12B02FB184E1419F45888E1CA2BAFCC6D1F3D4B31AF69ECD8B1D9E73EF7B9DCD7E37E4CEB9BBF1401582138DB906830B61D92148DCA6BAFBD362BF5D5D158BFD4708A5EED8752705C186EBAB81CFEAEC2D2F9A1B867A9AD183E1A3DA6855EDB38062239112B4BC610D7E86D0DB1A25ECC016C73934DE8ECE3378ED787DFC9F15B555575776363E38FE369DC8079E1C285ED7263DA1882376DDAB468DB1456D7BC53B00465A2BEBEFEAA575F7DF58BE96452D94137A66D78E9A5970E4E8F5F55FB1DE2D814204D2DF59B6CC6820D51A287A97899F058892E4AB1D82682A2F58906E239E79C932B1B138DC9C2BD6536A438508A791E2156D42B04677429DFAEA8A8985D5353736757EE41DA1CB1EC7E2417D6D7A3143D4EB19A5C3A07B70653B1047EA117298E9B584A3C1213ED395C093AEAF81D376EDCEBA79F7EFAC329D01A9ADA39D9A44993720B096D6BD1B39BAE4D854069EA840913660B96A04C8C1E3DFAEFE79F7FFEACE9D3A7BFA723B28893274F9ED8D4D4B477399C48BA8254CF0F77A9937355D536D96653361528B5C7CFA4538F83D1DBCBDF1A3764DED8FE1D2BDF1556BF0BC5C3ED36353F10BAE8F1FBF35486C693089622D9B62D930171DB8B7BEFBDB7B557290576D79743BDBB3D3514A9AFAFBFF8D65B6F5D13599776B6F8965B6E796FB99C48004ACD3B4D0440B91B3F7E7CCCD37D389E473B27E6A216869C6EAD582EFCDA6BAF6D6C6A6A6AED559A3B77EE04C11294991B6FBCF18E65CB96BD101997F674F5D55747AFD2F272399100005DC217B3FC72DEB5B5B5D935D75CB3D50153044A29F06A7EE38D370A7318965554547CB9D487BD0B96600BD5D7D77FEAAEBBEE5A1963D9DBC38C19337E3F6DDAB493CAE944020094BE18FADFDCDC1CAB07E5DA1FB1DAE9E5975F9E1B42B725E273975D7659636ADB147A9462F8DDB9E3C78FFF9F72A933C112ACE744B26AD5AA2F5F73CD352BB6F54A5F6FBCF1C69F7FF0831F0C4A27927F2FA7130900D035DC76DB6D31AAE5CB8580297A982EBEF8E25804A2ED0D653728B68BDB555C74D145C53D4AB152DFC5A97D33B69CEACB4C5D588FB163C78E1B316244F5A5975E7AED05175CD0EB80030ED8EAEF193D4A11283536365E974E5463D53200D01952A073F3B061C36245BDEB2A2A2A768A394C71CB8A988670F8E18767471E7964B6DF7EFBC53D28B3DEBD7BE786DA458014F7219B366D5A94A6B7DF7E3B3A5D0A3D4A71BFA7AFA7F6CDCDE556578225D88071E3C6FD269D48565C71C515D79F7AEAA9DD4E3EF9E49E5BB8A4F8E21FFDE847773FF9E493B1BCD2C5E578220100BA96E8611A3E7CF8E32958FA752C291EEF45D014F7168BB209C5A3D3A6C6D482721D31235882CD3891DC7EFBED374E9A34E9D051A346F5F9C0073EB0C3667EBCE1C1071FBC7BCC9831FBAF59B366FF742239D6D03B00A054E46F5F725C6AEB9C9ADA29A352D034E41DC40753B3969BBC8F2DE739D88225D8BC13C9C7E24472F5D5579FDBA3478FC30E3EF8E0B7060F1EDC6BDF7DF7EDD1AF5FBFDD6A6A6AB2952B57BEB978F1E2FAE79F7FFEA5A953A7767BE9A5970E6A6C6CDC337DF6E7E57E220100BA745BE7CEF470E7881123F66C6A6A3A35054DFF925E1F91CA6EA9D4A41243F66215BD67527924B6DD5EEE132958822D38914C9F3EFDD4679E79A6702269C89F48FAA6B23A95B821DB7FA772AE1BCE02005DC5B871E35E4F0F3FC917044BE0440200C0FA593A1C0000B64FC352D9BBE87574A4FCE7667CEE8FDB4B1C2158020080EDD3475279B5E875CCAFDE31FFBC47FE31A61AFCAF7C505528AB527977D1EB2B53D9B91C2BC8303CD87207A63220953F17BDF7CDAC25DB5258F5EEA854FE3933640F00282D8352B929DF9E3930FF5E532AFBA472622A1F4AE517A9BC95CAB47C10B522BFDDF2A2206B602AFFA75C2B49B0041B171997DEA97C349545A93C9DB56458BE943F812C6DB3FDE16D02A34FE5B703002815D16BF48154C6652DC3EEAE4AE5CDFCD72250BA3F5F8ADD9BCA35F9E77BE4B70B67A5323C1F680996603BF368FE719754E6A63225955EF9E0A9F824F2AEFC4967CFFCC9639F54C6E73FF3462A1FCF075B7F51A5004027ABC9073C17A73231950559CBFCA5480247EFD129594BB2F8B7459F9957D4F639B3E8F961E51A28099660EB456666553E208A93CA84541E4EE5B2AC25533331FB47E625BABA3F93FD63881E0040675892CA6FB29611318FE6DB3393F2EF1782A0016D3EB36BBE4D139FD92B952F662DBD51FF5CCE152558820D7B6F2AFB652DD992C289214E26918DD9277FC2F8742A97672D3D4843F3C151F43A3D96FFECDB59CB9CA608A816E40B0040671B9BCA5D59CB94811839F3EFA9FCBFFCD7A2AD133D46DF2DDA3E86E03D99B5F440CDC9B76DEE2FFA8C6009B633CFE74B88898F85851B8A87E1150FC51B900F9A22C3F2C3AC25DB32301F4465F980CB303C00A0149C90B5AC7E17F1C0C1F9364CA15D136D9D9E6DB6FF532AD7A6727E2AFF95CAE4547E90B5248D054BB09D3B34DBF48A76D103F52F594B37F5927C80353BFBC7BCA7FFAD1A018012B04B3EE889F64AAC743725DF4E2924786BDA6C1F09E1B353B9286B99831D6295BC5F652DC3F72290BA211F700996603B13F70DA8DD8CEDA2ABFADFB296FB0E7C48B50100252AA605DC96CAB345EFBD9E0F9A42AFA2B64C0456D1F37455D1B6ABF28FAFA47252D6327A666E395694600936ED2B59CBB0BA4D89AC4B7459C70A325FCB5A86E17D386B59F8C1F10600949267DBBCBEA9E8F9B2541E2A0AAC1E6DB3ED178B9EC7EA79653B6F49E30D362C32297153D9189FDB50F47E04447F5B4FA01473950A5997ABB39609933111B2B0FADD7EAA140028034DDBCB1F2A58820D8B4CCAFDEB793F7A8C7EDAE6BD18B7FBFB36EFB57DFD5FAA1400A0EBA85405009B3851565636373535A9881290FE0FAF662DAB3701806009A0B3D5D4D4CC5BBA74A98A28018B162D9A991E9E51139DD4689038281912072058022809DDBB779F5A5F5FAF224A405D5D5D2C73FBB09AE81C1207A543E200044B0025A1A1A1E13FE7CE9DBBBAB9B9596574AED90B172E8CE56927AA0A890389038903102C019480A38F3EFA8914283D5B5B5BAB323AD1CC99331F4CFF87DAE38E3BEE71B521712071207100822580D269248E9C3D7BF68A254B96A88C4EB078F1E27B52E3F0934D4D4DE7A90D890389038903102C019490134E38E17F5243FDD3CF3DF75CBD80A9E303A51933661C565151F1E5F47F98A946240E240E240EA0A3745305009B67CC9831AF8C1C39F2AF6FBEF9E629A9E1BEBC4F9F3E3BA44715D37E66CF9C39F38ED430FF68AAE77F1D3A74E87DAAA4F38D1D3B76FE99679EF9C482050B3EDDB76FDF9AEAEA6A95D2F189837F3DFEF8E3A7AA11102C01945CC03462C488BBEBEBEB0FAFADADEDD3D0D0F0B7CACACA8AD460EC2570DA7AB11CF2C2850BFF3C6BD6AC692FBEF8E22E2B57AEAC4AEF8DD03094389038903880CEE0CC06B085264F9E3C28355C3E9B9E0E49E588546AD4CA568BFBC6C472C80FA732D19C8CD2F6C0030F1C5C5959796D5555D507060C18F07AFFFEFD77EFDBB7EF6EE93D95B30D1207B13C78AC7A178B39C41CA5187A67282A08960000890389038903000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006063FE3FA14F9DF4B69BCBE50000000049454E44AE426082, null);
INSERT INTO `act_ge_bytearray` VALUES ('7502', '1', '请假审批.bpmn20.xml', '7501', 0x3C3F786D6C2076657273696F6E3D27312E302720656E636F64696E673D275554462D38273F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A7873643D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22687474703A2F2F7777772E61637469766974692E6F72672F70726F63657373646566223E0A20203C70726F636573732069643D2270726F636573732220697345786563757461626C653D2274727565223E0A202020203C73746172744576656E742069643D227369642D44444143323641362D384139302D344235412D383539302D43453645373035353341424622206E616D653D22E5BC80E5A78B222F3E0A202020203C656E644576656E742069643D227369642D30464444453437422D364436442D344233342D384546442D43323537363541383733433622206E616D653D22E7BB93E69D9F222F3E0A202020203C757365725461736B2069643D227369642D38443944414342362D304536432D343242302D423034352D35434233354541333644413922206E616D653D22E5AEA1E689B9222F3E0A202020203C757365725461736B2069643D227369642D37423634364237332D303830342D343631422D414645312D33333135384433453232333922206E616D653D22E68F90E4BAA4E794B3E8AFB7222F3E0A202020203C73657175656E6365466C6F772069643D227369642D45343242453830412D383944412D343431352D413833312D4233363335343533323933412220736F757263655265663D227369642D44444143323641362D384139302D344235412D383539302D43453645373035353341424622207461726765745265663D227369642D37423634364237332D303830342D343631422D414645312D333331353844334532323339222F3E0A202020203C73657175656E6365466C6F772069643D227369642D35314437394243382D303838332D343537392D424632372D4536373938383036374144442220736F757263655265663D227369642D37423634364237332D303830342D343631422D414645312D33333135384433453232333922207461726765745265663D227369642D38443944414342362D304536432D343242302D423034352D354342333545413336444139222F3E0A202020203C73657175656E6365466C6F772069643D227369642D30443530354546392D383434332D344639452D383338382D4338383930453330463331372220736F757263655265663D227369642D38443944414342362D304536432D343242302D423034352D35434233354541333644413922207461726765745265663D227369642D30464444453437422D364436442D344233342D384546442D433235373635413837334336222F3E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F70726F63657373223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D2270726F63657373222069643D2242504D4E506C616E655F70726F63657373223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D44444143323641362D384139302D344235412D383539302D434536453730353533414246222069643D2242504D4E53686170655F7369642D44444143323641362D384139302D344235412D383539302D434536453730353533414246223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233302E30222077696474683D2233302E302220783D223139352E302220793D223135302E30222F3E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D30464444453437422D364436442D344233342D384546442D433235373635413837334336222069643D2242504D4E53686170655F7369642D30464444453437422D364436442D344233342D384546442D433235373635413837334336223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2232382E30222077696474683D2232382E302220783D223736352E302220793D223135302E30222F3E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D38443944414342362D304536432D343242302D423034352D354342333545413336444139222069643D2242504D4E53686170655F7369642D38443944414342362D304536432D343242302D423034352D354342333545413336444139223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2238302E30222077696474683D223130302E302220783D223532352E302220793D223132352E30222F3E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D37423634364237332D303830342D343631422D414645312D333331353844334532323339222069643D2242504D4E53686170655F7369642D37423634364237332D303830342D343631422D414645312D333331353844334532323339223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2238302E30222077696474683D223130302E302220783D223333302E302220793D223132342E30222F3E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D30443530354546392D383434332D344639452D383338382D433838393045333046333137222069643D2242504D4E456467655F7369642D30443530354546392D383434332D344639452D383338382D433838393045333046333137223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223632352E302220793D223136342E37353439303139363037383433222F3E0A20202020202020203C6F6D6764693A776179706F696E7420783D223736352E303030313638323031353035342220793D223136342E3036383632363632363436333139222F3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D35314437394243382D303838332D343537392D424632372D453637393838303637414444222069643D2242504D4E456467655F7369642D35314437394243382D303838332D343537392D424632372D453637393838303637414444223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223433302E302220793D223136342E3235363431303235363431303235222F3E0A20202020202020203C6F6D6764693A776179706F696E7420783D223532352E302220793D223136342E3734333538393734333538393735222F3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D45343242453830412D383944412D343431352D413833312D423336333534353332393341222069643D2242504D4E456467655F7369642D45343242453830412D383944412D343431352D413833312D423336333534353332393341223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223232342E393939373430343931313633372220793D223136342E3931313736363233323430343931222F3E0A20202020202020203C6F6D6764693A776179706F696E7420783D223333302E302220793D223136342E3239343131373634373035383834222F3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, '0');
INSERT INTO `act_ge_bytearray` VALUES ('7503', '1', '请假审批.process.png', '7501', 0x89504E470D0A1A0A0000000D4948445200000323000000D7080600000009388E57000012324944415478DAEDDD0B9454F57D07F09CD69EDAF7FBDDB4E6D1A4EF67DAF4B4694BDFB18DD65811D95D60BB7A76D5082A6A6B7D74A94A45ADB53569ACA7B6164B42526BD5200AB2200F31348A45A2A542444517708D4144774590DBDF6F736FCE64055C969D61D6FD7CCEF99D999D191F67F7FEEEFFFB9B7B67EEDBDE06000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040DD144571D4E6CD9B6F5DB366CDEB4B972E2D962C59A21A5C3D3D3DC5CA952BBF18D5668B040060DCC84164D5AA55455F5F5FB17BF76E7584EAF9E79F2F56AC58B1330693936C95067383B9C11C00C6850C5E0691A61948764720DB60AB34981BCC0DE600302EE43BC00250F3540C237B6C9506730389C11C00C6853C3542F869AA61A4B0551ACC95C11C000C2335F5F28BDB8ACD0FDE5C3CD673D960E5FD7C4C68328C18CC955E0000EA16C076EDE82D1E5D7C69F1C8C20BBEAAF2B17C4E7012C00CE60673BD0000D425803DF3D867DE308854F5EC630B042701CC606E30D70B00407D02D886FBAE3AE03092CF094E0298C1DC60AE170080BA04B04797CC3A6000CBE7042701CC606E30D70B0080614400432FE80500E0AD13C0F243BA070A60F99CE0248019460C237A0100A84B00DBB4FA63070C60F99CE0248019CC0DE67A0100A84B007BA1777DF1E8BDDD6F7C27381ECBE7042701CC606E30D70B00405D0258D6930FDDF286F0958F094D0298C1DC60AE170080FA0D23AFBE5A6C7AE08637BE131C8FE57382930066303798EB050060D403585EC86DE3EA8F1EF0D4947CCEC5DE043083B9C15C2F0000A317C022586DDBB4ACF8FCA28B0E38885495AFC9D70A630298C1DC60AE170080C30A606F16BA843101CC606E30D70B00405D02D87042D7C1C29820258019CC0DE67A01001851001BE920529520258019CC0DE67A01001851005302985E3098EB0500C0302280A117F40200208029014C2F28BD0000086002187A412F0000029812C0F482D20B34BBD6D6D61F9E3469D259A79C72CAAD519BA27645155103514FC673B7C7EDF9F93ABF2D38028AA2387AFDFAF55D73E7CE5D3167CE9C9D3366CCD8D3DEDE9E4D5AB4B5B5ED3BE38C33765F7CF1C59BAFBAEAAA7951EFF51B13C09400A617945EA0D94D9E3CF984A82551BBCBE16338755FBCBECD6F0F1A3484DC76DB6DB75C7EF9E57BCE39E79CE2C61B6F2CD6AC5953F4F6F61603030345CADBBEBEBE62EDDAB5450C2BC5D9679FBDEFDC73CF7DAAB3B3F334BF41014C09607A41E9059A4D0C14C7C440B1E8100690FDD5AA891327BEDB6F13EA24868E8E2BAEB8E2D50B2EB86070D0D8BB776F315CEBD6AD2B2EBCF0C2BD5D5D5D1B34AA00A60430BDA0F402CD62D2A449A7B4B4B47CA976B0686D6D2DAEBCF2CA62D9B265C5962D5B8A975E7A6930CFBCF2CA2B836FC0AE5EBDBAB8EEBAEB8A2953A60C1D4876394A02A32C7AEFA83BEFBC73D9E9A79F5E2C58B0E0908690A1162D5A54747474F43B4A228029014C2F28BD40130C221F8AE1616FED10326FDEBCC1333C8663C78E1D83AFCF7FAE7628897FA79C03A335882C5FBEFC73D3A74F2F366EDC588C86A79E7AAA88C1A6FFB4D34EFB88DFB000A60430BDA0F40247681039A57610993973E6E0519091C87F2ECF1C193290384202872B8F88E42032DC7708862BFF7D9D9D9D0E650A604A00D30B4A2FD070F91991DA53B3BABBBBBF722AD648E5295CB367CF1E7ACAD68FFB6DC308E56744F2D4ACD13A22B2BF232453A74EDDA15105302580E905A51768A418447A6A8F881CEE20523B900C3942B2CA6F1B4620BF35EBB2CB2EDB9D9F11A9A7850B17F6B7B6B67ED66F5C005302985E507A8146C8AFEFADFD8CC8484FCD3AD8295BB59F217116088CC0EDB7DFFE899CEC5F7BEDB5A2DECE3CF3CCED1A55005302985E507A81060D234BAA41213F7C5E0FF3E7CF777404462A8F8AE47544F2EB7B1BE191471ED9EDE8C8919557981DCEE972029800F6563761C284A30C237A81B7EE5A96574CAF3EB49E472F5E78E185BA649BFC96AD215FFB7B8CBF100C535E593D3FB47E385FE17BA83A3A3AB66BD423BA03AF0E25CF9F3469D24F0B6002D838EE850DC33952AB17F40263732D8BC7CFAA5E77F5D557D735DBE475486A8691F3FD856098E6CE9DBBE2A69B6E2A1A291A769D463DF23BF09ABAB5A5A5E5E70530016C1CF7C2A6FCDACF031D29D10B7A81B1B996E563D5F3CB972FAF6BB6C90B23D6FCBF2CF01782619A3367CECE356BD634741879E081079ED2A84DB503AFDE5D5A12F501014C001BAFBD1003C9FFE445D10C237A81B7C65A966F34548F8FF607D787CA2BB5D7FC7F3CE32F04C33463C68C3DDBB66D6BE830B27DFBF63E8DDA7C3BF09ABA2702D9AF0A6002D838EE850723CC7CD030A21718DB6B59547FF5F3687D9DEFC1BEE6B7E6BF3DE02F04C3D4DEDE5E0C0C0C347418C9FF5E36EAAC59B3BEA6B3B3F3EB8E3DF6D8AF3FEEB8E3BE71E2C489DFDCDADAFAAD2D2D2DDF3175EAD4EF9A3265CAF7C663DF1FF543F1FAB7C7E33F1AF5CEF8F9DD51EF8DC0FC13799E6884869F8DE77F219EFBA5F8F9973348C7CFBF16F51BF1DC6F45FDCEC9279FFC7BF1F81F441D1B8FFF71D4F1F9757F517F1A8F4DCC5334424B9E3F1E352D7EFEB3B83D2D1EEB8CFB67C4ED47E2E7E951E7C4CF33A32E88C7FE22EAA2A84BA2BAE3B9BF8EDBCBA3FE266A4ED435F1D8B5517F1FAFBF3E7EFE58D40D513746DD148FFF6BD4DCB8FFEF519F8CFA54FCFC1F717B5BBCFEF6A8CFC4FDBBCA1DEAE2F2DD9E65717F797E5B47D4EAA835519F8B5A9BEFEAC6ED23518F46FD6FD4E3E5BB429BA3F268D43351BDC3D881EFCB12C09AABCABFCDEB51AF45BD1AF54A6C0F2FC5ED8B512F44E590BFBDFC1B6F897A32EA89A88DE567231E8B6D647DB99DAC2DB79BCF46DD1FB532EABEA8FC2EFE7BCB6DEEAEDC06CB6DF13F73DBCC73B3A3E695DBEDCDB91D97DBF30DE5F6FD0FF1DAEBA2FE36EAAAEC8578ED15D91BF1F35F65AFC4FDBF8CFAF33C5533EADCA819795E77D9679D51A766FF454D8D6A9DFC652767AFC6731FCEDECD1ECE5ECE9E8EFBBF1B35217AFC37A37E3DFB3FF605BF92FB833C6523F70F513F951F748D9F7F2C9E7F577E662DF729C3E88587E29F3B4E2F34DF3092EB47AC035F5BAD2171FF1B62CDF8A6E38F3FFE5B721D89B5EDDBE3B1EF8CBFDF77576B495B5BDB0FD4AE2771FF1DB93DE49A12B7EFC96D24EEFF64AE2BF1EFF899B8FDB9DAB525EEBFBF5A5FF29DF7DCE672DBCB3526B7C3B8FDFD78ED1F56EB4C6E3BD55A138F9D18F74FCA6DB9BC12F8E4DCBEE3B129D59A93DB7EB5EE449D1EF7CFCCDEC8B5276ECFCE7E89FBE755EB4FDC5E58AD41657FCD8ABAAC5C8766C76BAF2CFB70702D8ADBBF1BB21E7D3CEEFF53F670DCFE73DCFE4BF675B52E65AFD7AE4DB91FA8D6A7B8BD33CF7088FB0BCB37B01695FB8E9E9A756A65CD5A95FB9AFFCE41BFDCFF3C1CB52EF749D59A15FFDCFFD5AC5B4F94FBB0A7CBB5EBD9A8ADE53E2EF7755F1CE65AF6959F1BA1F6BF2761C221BCB37024EC2F58E5D54BA376467DA9DCD13C17B5ADDC096D290375EEA036953BAD0CDC9F2F0378EED81EAA0958ABCB1D61EE1097965FEDB738EAEE32E0DF393464C5639F2807837FCB41A1DC3967D0FA78EEB873079E41AB1C30AE2E078ED9E58E7F566DD82A0795F3CBC1E5EC5C4C72A0C9056668E02A07A0C9F1D8A472303AB11C948E2B17B40F66E8CA812AEAB7CB01EB03E5C0F5FE7200FBC5DAE0550E6AEF2907B777E4C25B86AF1F3CC88E7B6DBCF6C313264C383A177A01AC390358ED009FC12BFE66DF96A12BEA7B3270957FE3B797571C7E6706F02A6465C0CAED24B7976A70CF009F837B86AA2A50E5365785A9A1437B06A8DC6EE3F9F6DC8EABE0546EDF337260CFC0940347F642BCF6E2EC8DDA61BD0A48198E728089FA68D9675F35A8D784A14F9741E8BFCA107457D9CB8BCB01EABE78ED8A72B0AA42CF434306F40DE560F68532E46C194E98897FEFEB51B6C1E61CCCF7D6AC21F90EF8CBE580BE33FEF63BCA21FDF99AB564EB90F56473B5A69421787068CF75A50CC9EB86AC2D6B6AD69755E5369743FCD26A902F43F9DDD5305FAD3519E2CBCF2F7CBA5C6F3E596EDFB7546B4E0E0335EBCE0D71FF1FB33772EDC92122FB2507FD6AFDC961A35A83CAFEEA8EBAB47C83ECA21C56AAC13FD7A21C666AD7A37C0320EE77650F97435047F675D9DF53AA3703AAB5A9DC0F9C585EB7E3F83CA531F6277F94FB8B1CC272DF91FB906A9D2ADF101C5CABAA3709E2FEFB72FF93435E0E7BB94FAAD6ACF24DC6C1752BF75DB90F8BFB3F92FBB31C2273988CD77E5FEEEBF20DCB377913E184DC4F96B9C291116866D3A64DDBD7E82323FDFDFDDB356A531DDADEB0BF0FEF36DB3012FF4BFBAD463DEFD49471759A4706CC094ED3729A16637B2DF399111803A64F9FBEBBD19F19D9BA75EBE31AB52976E07984A9ADBDBDFDE8FDBDAE198791833D56EFE705B0711166EEA9FD1287B13A8C8CF5C15B2F305A6B996FD38231E0D24B2FDDD4E86FD35ABC78F1DD1AF588EEC0F37495F637BBE09B61C430328EC24C0696F78D955EA877AF184678ABAC65AE330263C035D75C7353A3AF33D2DDDDBD50A31E3963F5AAD3861101AC0E61E6D6835DF8D3306218616CAF657905F6E8F33D8DB8027B5B5BDB3E57608711B8E4924BDE75D65967BDDEC02BB00FB4B4B43CA1519B9F61C4308261C430C258577E81CDE090306FDEBCBA049BF9F3E7D71E1559E5B70E8768E6CC995F58BB766DA34ED19AA7510530C38800A6170C237A81060D23275483421E1D19ED0FB2E7BFAFA5A5655FCD4517DBFCD6E1109D7AEAA913CF3BEFBC3D0D383AB2231AF6618D2A8019460430BD6018D10B344AF90D7983C3C2CC993347ED6B7EF3EB7C233FEDAD3D2A32DC53A18121BABABAD62F58B0A0AE93487E3E45A30A60BEDA5700D30B8611BD4083879163CA6BCE0C0E0DDDDDDD873D90E420327BF6ECDACF89ECCA6B3AF96DC361346A474747FFC68D1BEB3288AC5FBF3E2F54B64DA30A604A00D30BBEDA572FD068790D92EAC3ECD51192919EB295FFDC9023224ECF82D1D0D6D6D6DAD5D5F54A5F5FDFA80E22CF3EFBECFD2D2D2D4F6B54014C09607A41E9058EE01BAFEDB503497E86243FD49EDF8635DC6FCDCA0FABD77E46242BAF76EFB70BA3241AB3A3B3B373D7681D21C9232239886854014C09607A41E9058EB43C4212B5A37698C8A124AF43921746CCA31ED5295C792A565E593D2F6878FDF5D717D3A64D7B7DC8855277E580E3B70A7568D4B6B6B69D77DC71C7CB87F1A1F61DD75E7BEDCD796A964615C09400A617945EA059E4A9E9B55FF93BC25AE5D473A873A3B6B4B42CEDEAEADAFEF0C30FF71FCA7544EEBDF7DEF931CC3CA85105302580E905A51768E2AC73523994EC399421E4CDAEFC0E8C72A3E650D2DEDEDE3767CE9CC7EEBFFFFEA77B7B7BB70D0C0C0C4E1EFDFDFDDBB76EDDFA784F4FCF5DB366CDBAA7B5B575B34615C09400A617945E60ACC82BB5C750724E64975BA39E8C1A28078FBC7D266A41D4F92ED80C1A15014C00432FE805BD0000029812C0F482D20B0080002680A117F40200208029014C2F28BD0000086002187A412F0000029812C0F482D20B0080002680A117F40200208029014C2F28BD0000086002187A412F0000029812C0F482D20B00208029014C2F28BD0000086002187A412F0000029812C0F482D20B0080002680A117F40200208029014C2F28BD0000086002187A412F0000029812C0F482D20B0080002680A117F40200208029014C2F28BD0000086002187A412F0000029812C0F482D20B0030FE2C5DBA54F0699E1A8800B6C756691851861100181756AE5CB9ADAFAF4FF86982EAEDEDFD5404B00DB64A83B9329803C0B8B06CD9B23F59BE7CF98BCF3DF75CBF0074E482570E223D3D3D4F479D64AB34981BCC0DE600306E4400FE502CFC0FE63B91796A846A78E5EF7D8341C460AE0CE6000018CC0DE6067300000000000000000000000000000000000000000000000000000000A88FFF07BC2C9878335843EC0000000049454E44AE426082, '1');
-- ----------------------------
-- 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 COMMENT='逐渐生成策略表(与Id相关)';
-- ----------------------------
-- Records of act_ge_property
-- ----------------------------
INSERT INTO `act_ge_property` VALUES ('next.dbid', '12501', '6');
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 COMMENT='所有活动节点的历史表(其中包括任务也不包括任务)';
-- ----------------------------
-- Records of act_hi_actinst
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
`REV_` int(11) DEFAULT NULL,
`USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
`TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
`CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`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 COMMENT='任务历史表';
-- ----------------------------
-- Records of act_hi_identitylink
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
`BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
`START_TIME_` datetime NOT NULL,
`END_TIME_` datetime DEFAULT NULL,
`DURATION_` bigint(20) DEFAULT NULL,
`START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
`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 COMMENT='流程实例的历史表(一个流程实例)';
-- ----------------------------
-- Records of act_hi_procinst
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
`OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`START_TIME_` datetime NOT NULL,
`CLAIM_TIME_` datetime DEFAULT NULL,
`END_TIME_` datetime DEFAULT NULL,
`DURATION_` bigint(20) DEFAULT NULL,
`DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
`PRIORITY_` int(11) DEFAULT NULL,
`DUE_DATE_` datetime DEFAULT NULL,
`FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`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 COMMENT='任务历史表(只有节点是UserTask的时候该表存在数据)';
-- ----------------------------
-- Records of act_hi_taskinst
-- ----------------------------
-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
`VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`REV_` int(11) DEFAULT NULL,
`BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`DOUBLE_` double DEFAULT NULL,
`LONG_` bigint(20) DEFAULT NULL,
`TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
`TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
`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 COMMENT='历史流程变量表';
-- ----------------------------
-- Records of act_hi_varinst
-- ----------------------------
-- ----------------------------
-- Table structure for act_id_group
-- ----------------------------
DROP TABLE IF EXISTS `act_id_group`;
CREATE TABLE `act_id_group` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`REV_` int(11) DEFAULT NULL,
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='角色表';
-- ----------------------------
-- Records of act_id_group
-- ----------------------------
-- ----------------------------
-- Table structure for act_id_info
-- ----------------------------
DROP TABLE IF EXISTS `act_id_info`;
CREATE TABLE `act_id_info` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`REV_` int(11) DEFAULT NULL,
`USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
`KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`PASSWORD_` longblob,
`PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of act_id_info
-- ----------------------------
-- ----------------------------
-- Table structure for act_id_membership
-- ----------------------------
DROP TABLE IF EXISTS `act_id_membership`;
CREATE TABLE `act_id_membership` (
`USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`),
CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户角色关联表';
-- ----------------------------
-- Records of act_id_membership
-- ----------------------------
-- ----------------------------
-- Table structure for act_id_user
-- ----------------------------
DROP TABLE IF EXISTS `act_id_user`;
CREATE TABLE `act_id_user` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`REV_` int(11) DEFAULT NULL,
`FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户表';
-- ----------------------------
-- Records of act_id_user
-- ----------------------------
-- ----------------------------
-- Table structure for act_procdef_info
-- ----------------------------
DROP TABLE IF EXISTS `act_procdef_info`;
CREATE TABLE `act_procdef_info` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
`REV_` int(11) DEFAULT NULL,
`INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`ID_`),
UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of act_procdef_info
-- ----------------------------
-- ----------------------------
-- Table structure for act_re_deployment
-- ----------------------------
DROP TABLE IF EXISTS `act_re_deployment`;
CREATE TABLE `act_re_deployment` (
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
`DEPLOY_TIME_` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='部署对象表';
-- ----------------------------
-- Records of act_re_deployment
-- ----------------------------
INSERT INTO `act_re_deployment` VALUES ('7501', '请假审批', null, '', '2018-12-11 09:00:52');
-- ----------------------------
-- 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
-- ----------------------------
INSERT INTO `act_re_model` VALUES ('10001', '2', 'new-process', 'process', null, '2019-01-11 16:21:22', '2019-01-11 16:21:22', '1', '{\"name\":\"new-process\",\"description\":\"\",\"revision\":1}', null, '10002', null, '');
INSERT INTO `act_re_model` VALUES ('2501', '13', '请假审批', 'process', null, '2018-12-10 15:28:54', '2018-12-11 09:00:55', '1', '{\"name\":\"请假审批\",\"description\":\"\",\"revision\":1}', '7501', '2502', '5001', '');
INSERT INTO `act_re_model` VALUES ('2503', '2', 'new-process', 'process', null, '2018-12-10 15:29:17', '2018-12-10 15:29:17', '1', '{\"name\":\"new-process\",\"description\":\"\",\"revision\":1}', null, '2504', null, '');
INSERT INTO `act_re_model` VALUES ('2505', '2', 'new-process', 'process', null, '2018-12-10 15:30:15', '2018-12-10 15:30:15', '1', '{\"name\":\"new-process\",\"description\":\"\",\"revision\":1}', null, '2506', null, '');
INSERT INTO `act_re_model` VALUES ('2507', '2', 'new-process', 'process', null, '2018-12-10 15:30:54', '2018-12-10 15:30:54', '1', '{\"name\":\"new-process\",\"description\":\"\",\"revision\":1}', null, '2508', null, '');
-- ----------------------------
-- 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 COMMENT='流程定义表`fsop`';
-- ----------------------------
-- Records of act_re_procdef
-- ----------------------------
INSERT INTO `act_re_procdef` VALUES ('process:1:7504', '1', 'http://www.activiti.org/processdef', null, 'process', '1', '7501', '请假审批.bpmn20.xml', '请假审批.process.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 COMMENT='正在执行的执行对象表(正在执行的流程实例)';
-- ----------------------------
-- 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 COMMENT='任务表(个人任务、组任务)';
-- ----------------------------
-- 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 COMMENT='正在执行的任务表(只有节点是UserTask的才有数据)';
-- ----------------------------
-- 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 COMMENT='正在执行的流程变量表';
-- ----------------------------
-- Records of act_ru_variable
-- ----------------------------
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化