企业OA办公系统开发笔记：1、搭建后端环境

文章目录

企业办公系统：搭建环境
- 一、项目介绍
- - 1、介绍
  - 2、技术栈
  - 3、项目模块
  - 4、数据库
- 二、搭建环境
- - 1、搭建后端
  - - 1.1、搭建父工程clfwzx-oa-parent
    - 1.2、搭建工具类父模块common
    - 1.3、搭建工具类common的子模块
    - 1.4、搭建实体类模块model和项目模块service-oa
  - 2、配置依赖关系
  - - 2.1、clfwzx-oa-parent父模块管理依赖版本
    - 2.2、common模块
    - 2.3、common-util模块
    - 2.4、service-util模块
    - 2.5、model模块
    - 2.6、service-oa模块

企业办公系统：搭建环境

一、项目介绍

1、介绍

本文企业办公系统主要采用SpringBoot + MyBatisPlus + SpringSecurity整合activit 工作流框架，系统主要包含：管理端和员工端：

管理端包含：权限管理、审批管理、公众号菜单管理
员工端采用微信公众号操作，包含：办公审批、微信授权登录、消息推送等功能

2、技术栈

采用springboot+vue前后端分离，多模块单体架构。

后端技术栈：SpringBoot + MyBatisPlus + SpringSecurity + Redis + Activiti+ MySQL
前端技术栈：vue-admin-template + Node.js + Npm + Vue + ElementUI + Axios
其他：内网穿透工具ngrok https://www.ngrok.cc/

基础框架：	SpringBoot
数据缓存：	Redis
数据库：	MySQL
权限控制：	SpringSecurity
工作流引擎：	Activiti
前端技术：	vue-admin-template + Node.js + Npm + Vue + ElementUI + Axios
微信公众号：	公众号菜单 + 微信授权登录 + 消息推送

3、项目模块

Java后端项目架构模块

clfwzx-oa-parent  根目录   主模块
com.atsurvey
├── common  // 公共类父模块
│       └── common-utils //核心工具类
│       └── service-utils //模块工具类
│       └── spring-security  //安全框架相关业务模块
├── model：实体类模块
├── service-oa：系统服务模块 [8800]
├──pom.xml // 公共依赖
├── clfwzx-oa-ui：前端 PC管理端 [9528]
├── clfwzx-oa-wechat：前端 微信移动端-公众号 [9090]

4、数据库

包括业务表和Activiti表，数据库表总共35张表，详情如下：
在这里插入图片描述
数据库sql文件：

/*
 Navicat Premium Data Transfer

 Source Server         : localhost-mysql
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : survey-oa

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 11/05/2024 20:47:41
*/

SET NAMES utf8mb4;
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(0) NOT NULL AUTO_INCREMENT,
  `TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TIME_STAMP_` timestamp(3) NOT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DATA_` longblob NULL,
  `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_PROCESSED_` tinyint(0) NULL DEFAULT 0,
  PRIMARY KEY (`LOG_NR_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `BYTES_` longblob NULL,
  `GENERATED_` tinyint(0) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_FK_BYTEARR_DEPL`(`DEPLOYMENT_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ge_bytearray
-- ----------------------------
INSERT INTO `act_ge_bytearray` VALUES ('3670e46e-0c5b-11ef-b8fa-005056c00008', 1, 'leave_apply.png', '3670e46d-0c5b-11ef-b8fa-005056c00008', 0x89504E470D0A1A0A0000000D49484452000002F1000000E108060000004171EA53000000206348524D00007A26000080840000FA00000080E8000075300000EA6000003A98000017709CBA513C0000000467414D410000B18E7CFB5193000000017352474200AECE1CE900000006624B474400FF00FF00FFA0BDA793000000097048597300000EC400000EC401952B0E1B00001BE14944415478DAEDDD0B985565BD30F035176E22A0044A6ADEA2A3662479C94E915287D4B48B9F6980A0594F46EA31D33A9A1E7BF2704CE9A43D95C76379C91B2489F75412FC5212FDD44245484F9232A2C288DCAF233033DFFBDFB3376D86191864661CF7FC7ECFF33E7BEFB5D7BECC3BEF5EEF7FFDD7BBDE956500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B4B33255007406F5F5F5DDE7CE9DFBAFAB56AD1ABD66CD9AFD56AF5EDDBDAEAE4EC56C6F27525656DFAD5BB7C55DBB767D7AFDFAF5570C1932E411B5A28D6BE3208807D86E29B0F9F6A2458BAEACA9A9D961C08001599F3E7DB25EBD7A65E5E5E52A673B45909882C66CC58A15597575F5BADADADA17D7AE5D3BFAE8A38F9EAD76B4716D1C04F100EFC8BC79F3EE79E59557BEBCE79E7B66BBEDB65B64D5544A1B9A3F7F7E565555B5B6BEBE7EE4673FFBD97BD58836AE8D43DBA8500540290737A97CF980030EC8FAF7EF2FB8690791FDEDDBB76F97850B171E377AF4E859B7DC72CB4B6A451BD7C641100FD02231BCA0AAAAEA7B11DCF4EEDD7BB3E7DF5EF56656FDC2DD59F58BF7668BE63E92AD593A37EBD67397ACB25B6F95B79DBA76ED1A414EB7EAEAEA63478D1AF5C0F8F1E317AA156D5C1B87D665B01C5072E204BF181F1CC30B9A0B6E5E7BE637D9AA457FCBEA6AD765F5751BB2354B5ECEE6CDB821AB59F1860A6C053D7BF6CCF6DE7BEFBA8A8A8A5FAA0D6D5C1B07413CC056C50C1D71825F8C0F6ECA92571FCB36AC5BBDD9F2087616CD7D5405B6923DF6D8A36F6565E587A64E9DFA09B5A18D6BE3208807D8A298622F66E8686E7CF0DA2D6422238349EBD965975DAAD3CD57D48436AE8D83201E608B628EEC9862AF39F5B5EB9B7F71BD79B55B53BF7EFD764F3743D58436AE8D43EBAA540540A9898BDCC40C12BCFBD2FFE1FDE9A6BF9AD0C6B571685D32F140C9898BB3B8C84D07E9641AFE0F1246DAB8360E827880EDD3A5C7CECD3E57D94D76136D1C10C40374387DF7FC6456D9B5E766CB2BBAF4C8FAEE354405A18D038278808E66C7FE07643DFBEDD7E4F25EBB1CA882D0C601413C404754BB7EED66CB36BCBD52C5A08D038278808E66DDEAB77257AD5CF5D68B9B3DB77AF19C6CDE5FAECBAD03DA38208807E80096CF7F260537D7676B96CE6D769D35CB5ECDAA9EBE265B3AEF89ACDE7CDA68E34007654A24A0E445D6F1CD971ECC65215B222E4D1FEBAF7CEBC56C977F3A36EB9E9B061AB471A0E39089074A5E641D5B1ADC148B6CE6AB7FFEB50A441B0704F100ED2DB28EEF547DDD061588360E743886D300256FFF6197AA04B471A0A4C8C4030080201E0000684B86D3403BA9AFAFEF3E6BD6ACAF3DFBECB3272F58B060F0FCF9F37758B16245654D4D4D56595959DFAB57AFF57DFBF67DA377EFDE4FA4D5FFF3820B2EF89B5A030004F1F02E05EF77DD75D7B5975E7AE9C8C58B17571E70C001D9D0A143B30F7CE003590ADAB3EEDDBB6729902F5BB97265D7D75E7B6D9FD9B367EFF3CC33CF9C7CEEB9E7CE5BBD7AF5A5D75E7BEDF56A1180CE6CD4A8517B6CD8B0E1F8B2B2B223D3C3C1A90C4865C7546A52A94E7DED73E9B9C72B2A2A264E9830E175413CB05D9E7CF2C96FFCF8C73FFE9FE5CB97771B31624476D04107656903B3D97A11C847E9DFBF7F76F0C10767A79E7A6AD9CC9933F79A3871E2AFC68C19F3BD254B967C71D2A4497F57A300742623478E3C3EDD9C555B5B3B2405E9DD9B582596ED9D9EDB3BDD1E9FD6FB69EA6F1F4D8F6FB8EDB6DBC60BE2816D525F5F5F79DF7DF74DB9E9A69B3E73DC71C7659FFFFCE79B0CDEB72402FE542A1E7AE8A1FD6FBFFDF6E7BFF5AD6F7D47561E80CE2005E211945F93FAD363DEC1CB87A6D70D4DEF312605F55F2FD52498201EDA20809F366DDA130F3FFCF061E79D775EF6A10F7D68BBDEEFE8A38FCEF6DF7FFF1EE3C68DFBE537BFF9CD6ED75F7FFDD56A198052357CF8F011E9E6AA54FA15964522EC231FF94876F8E1876703070ECC76DA69A7AC57AF5ED99A356BB265CB9665555555D9D34F3F9DCD9831A37EC3860D65F9970D49AF7B76E4C891679462565E100FAD2C32F011C0FFF0873FCC0D8F690D7BEDB5573676ECD81E175F7CF1B8B4315A5EEA870801E8B401FC17CACACA6E2DC4A811BCC7D1ECA38E3AAAC93E75871D76C895DD76DB2DFBE4273F19017DD9030F3C903DF8E083F575757511CCEF585F5F7F6BEA3BBBA7BEB3A48E669B62125A518C819F3C79F267CE3EFBEC560BE00BE2FD2EBAE8A21DBB74E97255DA18EDAFB60128B1007E440AE0EF2E04F011985F7EF9E571526B8BFBD4C8D0C7FAE3C68D2BDB7DF7DD6B0BCB53207F5DEA3B470BE281CDC42C3453A64CB926C6C06FEF109AE644463E6DE4BA959797DFA8C601281531063E05F0571502F8FDF6DB2FBBE4924B7233B9BD13F1BAB163C7560C1A34A8BEA89FBEA694926082786825F7DC73CF0D314D648C616F4BC71E7B6C8F3E7DFAEC536A1905003AAF14C05F97E5C7C04706FE7BDFFB5E6ECCFBF6886136DFFDEE778B33F231B4E63A413C9015EDDD779F3D7BF657631AC92E5DBAB4F9E78D193366E7F2F2F2B3D43C00EF75318D64EA4787C5FD18039F02EFED0EE08B03F973CE39A722F599858CFC9052498209E2A115C49558172E5C5819D342B6878F7EF4A35DBB75EBB64F7E0AAE9293FEAE8B63A33E74E85027DF0394BE8D49A93889F59D0EA1694EBCDF17BFF8C5C28C3591781B530A95A6838456F0ECB3CF9EDCDC859CDACAA04183AA9F7AEAA913D3DD2B4AB04AFF336D64B3010306AC1E3E7CF83DE5E5E5E3376CD8307DD2A449ABB4364A6547B5ACAC6CF682050BEE7FF4D14737A8113A6B7B8E2BB1D6D6D60E8DFB859968DAC231C71C933DF0C00385E9278744126CE2C48955EFE57A9789875690365C8363FEDAF674F8E187EF946E8E2CF1AAED993A865129A09F9C36EE6F8C1C39F2E6548E39EDB4D3BA77B42F5A575797AD5AD5B08F71CD35D7B4D9E75C7FFDF5D9BA75EBB6BACE8B2FBE98BB3F73E6CC8DCBE7CD9BE7C7DAB17654EFDE75D75D57C48E6AB4EB934E3A69C7F7C217FFE31FFF989B8FBB39F3E7CFCFFD1E9AB370E1C2ECF5D75FD7C64BB33D2F4FEDF9B66D69CF29A88E2BB2E692CA910CEBDBB76F9B7CC198B5E690430E292B5A74E27BBDD205F1D00A52A7B543CC1CD39EF6DD77DF1DD2CDE04E54CDBD5327716A04F43535358B478C1871E3BB3DE42602953BEFBC33FBC31FFE905D76D965D90D37DC905BFE97BFFC65E33AD3A64DDB18DCE73BAC5C80D25CB9F1C61B370627A171B0D3B367CF4DDEBFA97566CD9AB5F170F4B9E79EBB31203AF5D453B7185CD1FED24E6A8F54BE9CDF51AD4EED7A5247DB515DBC78F126E5A5975ECAAAABAB373EFEEB5FFF9A6BFF058F3FFE78EE71FC2E8E3FFEF838E93F9B346952EE7E2CBBF6DA6BB3DFFFFEF7DA7869B6E71D52195148BCA4F63C616BED39ADBF3119F5F18F7FBC4DBF5FA3F77FCF27C10CA78156B062C58ACAD8CB6F4F6BD6ACE99F36941BD246F292A2C5D5A9D434B57E5AB7266D2CAB9B7BBFF4FCA2F47CB3C35552A7FD7A073AEC1F3B30A7A5EF7CDA80010396A64EE2A1F4F8E66EDDBA3D7AD34D37D5B45B16A4BC3CFBCA57BEB2F1F1CA952B37793EB282575F7D75F6939FFC24DB71C71D0BF598BDF0C20B596565D39BDFD8192CCE424E9C3831FBF0873F9CFBAC1059CC3E7DFAE482A1C24EC2FBDEF7BEECFBDFFF7E6E0721EDE0E46E5F7EF9E55C80B5FBEEBB675DBB76CDAD1B414FE17DE8907AA672626AD727A6FFE3BAF4DBBE2FFD2627BCDB436E2280FEE0073F98BBFFF39FFF3C7BECB1C7B24F7DEA5331A42F377777B4D9EF7CE73B9BBCE6D0430FCD0D5F78F0C1077317E959BB766D367DFAF4DCB2C6BF156DBC74132FA99C9CDAF3C9E97F56133BA8A93DDFD5447B1E5C949C6AD32FB4F7DE7B674D7DAE201E3AB1E854BA776FDFC4D98C1933228311BFE11FB53043B25DCFA76039C63D6EED639ADD89685C65F9755BC3CEA993882F3622FE0FC3870FFF7B04CAEDE5BEFBEECB051091398C798D0B6248410427518A838A3DF6D82357B6C5B1C71EBB494015814A0450213E739F7DF6D9D80EDF7CF3CD5C2672E79D77CE2D8FCCFED2A54B379935E984134EC81D358875E8B0BA1602FA383724EDA84E4B8FAF6AEF1DD55038613F82E9D8C18C6CF7FBDFFFFEECE69B6FCEBEF6B5AF6D6C7F4D79FBEDB773BF8F08E2B5F14E2D3AC853527B3E65D75D775D99FA92A931A564B4E7F43F1D5058A9AD93618DDEBF9F201EC8D286A83E6D88CADA33901F3C78F0E23BEEB8A34FDA10FEB868F1AEF98D6553417AF7B4011DB085B78C0DDA96C630EED1826DC6806DF813DAE4821BE9EF1C183B385FFDEA57DBE5FF10C302AEBBEEBA983168E361FC08E0E7CC99939D7FFEF9B9C7319CA69089DF56917D8CA109071F7C70EE710CB5E9D7AF5FF6C61B6F64555555711468E3E7C4674489A029C695C63A11DC44E6B430DC2BDEEBA28B2E6AB7E066D1A245D933CF3C93353A62C4B6E9997EBB11E51E1B416CAACBAAB7DE7AAB5DBF4064C5E3C8D2D8B163B35B6FBD35EBDDBB77F6831FFC203BEBACB372C35F22C31E19F7C647982263DEDC51276DBC734ADBE8983BF284D4A64F88F65CACB5A6956C4E4C37D968C742100F9D5DEAD0D62F5BB6AC6B64ABDBAD57EFD97371DA18AE9D38716287E9384E3AE9A4011515155BDD30B66087E291167E645CC0A3A2D17BBF3268D0A07DDBEB6F2E1CC68FE101114C3CFFFCF3B9603E828FC83E46103375EAD4ECCA2BAFDC18CC3CF1C413596A2F9B1DF68FA107871C72482EBB592C860D445012162C58900D1B362C17C8C4F084575F7D759375632842ACFFDBDFFE361B3D7A742E90F9D297BEB4F1B5BFFEF5AF1B77646D2A82AB679F7D36EEFEC896A2D5EC1D2796160FE56A2B1140FFE94F7FCA5D85BA478F1EB9603E86D044E01A01FC61871D960D1C3830174C37358CA5A5890D6D9CC276B42D03F9356BD6143FAC79AFD797201E5AC14E3BED342F753403DB33889F356BD6CBF920B6C3983469D2B68C63F9DFE69ED8C2B09DBA14FCD7E58711858AF478597AFC708C1DEED6ADDB1F62A8C137BEF18DFAF6F87B23408FB1BC11D8FCE217BFC81DD6FFC4273E913BD975D75D77CD860E1D9A0B62BEF0852F6CF2BA38B9AAA9EC6461BC70539F53181F3C7BF6EC5CD012EF1BF763584341043C11C0C4F3279F7CF266814CACDB9EC14DF8F4A73F9D0BC25290F31FB6149B6869C0178777CA1BEFA81E7AE8A1EDB2A31A19F742FB2D0C178BE16AE977969D77DE79D981071ED8EC6B63584C71FB8C761C3BB84D9D78AA8D778AF6DC78FB5D68CFEBD3F2DC58A8486EB465101FEF5F6491201E888E6E5AEA6C061E7EF8E1EDF6994F3CF14404AAD33A41F5468F1F677A464AAF3C6DF023A0891370A3C7FF5D8F1E3D1E4E01C5B27765039A02F1C846E67760B2E29DB8238E3822176C9C73CE394DBE6E5B3FA710E0176729A3146729870C19922B4D7D66B1188A11D9D4F610C3226298C405175C70892DC5263BAACD063D29A0A94DEDBC7084A9FCDDDE518D234485234E21B2A58F3CF2480CE9CB5E7BEDB5DCE368FF11D81707D0310B4D61184C04DDF1DCE9A79F9E0BCE6307571BEF14EDB92E9F6CEA52D87E376ECF353535B766F9E91E5F79E59556BFD053B138425AE439413C902D5FBEFCF2D4D17CBDB6B6B6BC9D2EF8543367CE9C18537E5627A8DEF27C001F81FB1DA93C908280FBDBFBE4BE9604DAC50AC1CCC30F3F9C0B48B669AFA5AE6E93A109071C70409359CAB973E76E72326D7362F84171E7F5E73FFF79931309E9106247351729E703F80EB3A31A99F8E2F618E77814CF34134E3AE9A44D5EF7E4934FE6A67E2C9C0B12AFFFE94F7F9ABB1F6DB9F14C4EDA784989A07D7D21F1922FCDB6E7E1C3874F4B6D3E17C4C730B1238F6CBB991F1B5DDFE03D9F0413C4432BB8F4D24B5F3EEFBCF3E6CE9C39F3838593B3DAD2942953EE4C81DE5EEFF5ABCD6D4D646CD2CDA32900284C1FB9ACA37DC7189B1B19BFE213B46218C1AF7EF5AB6CE4C891D999679E991B137FF6D967E7029938016E4B99F898FDE3F2CB2FCF8DF72DCCC81127FE151467291B8B31F9AB57AFDEF85D6267E0B9E79ECB0DEF39E38C3336064EF1FDE27BB4475BA5C5BA76D41DD5E2003EDA67A32109CD06FF4F3DF55493CF359EC9491B2F3915F9D2A2F69CDACA3DE9FFF8F3B4BDAF880B772D59B2A44D2EF814ED36DA44913B04F140CEF2E5CB2F4C81D76F0F3AE8A0CA36CEC62FBBF9E69B3F5C5656F6B312AECE1FA6BFAF2A6DF8EFE86819F7C662FC669C601873C18738113066EB38EDB4D37299C49862F2FEFBEFDF38ADE46EBBEDB6D5F72C9CA4D794F5EBD7E74E226C2A3B19D9CB38C92E66C6290440F1BD0A19C96F7FFBDBB971FB6987A84D0F59535A3BAAC522088A6039E68BDF52D01F33D53477E19E783E86E968E3DA73983061C2EB23478E8CC90C86D5D6D66693274FCE468D1AD5EADF2D8EF444DBCA9B5E0A4930413CB4921B6EB861D29831637E983640831A9FC8D89AAEB8E28AC8C2EF575D5D3DB154EB326D5C2F7DAF7CD75D76D92597692F881301EFBAEBAE7F6C642B2B7357AA6C2DB173503C3EB9A91D80E29D80E22105CD9D388B1DD5968A13B763A8CA968E266D6DD69C08F0B571EDB991AB23888F3B11C4C73945ADB91316E76E4432A5207DD75F9742A50BE2A1152D5FBEFC4B77DF7DF70BFBEDB75F8F9892ADB5CD9A35EBBE1933661C9736409FE940574FA51D6D29B8C18E6ABB040E9595DA38ADDA9E6FBBEDB67BE28266F5F5F54746363E8EF45C72C925AD32534D4C2B79D5555765F1BE79D3172C5850124930D72686D6DD9055AD5BB7EEF42BAFBC724D6B5F8CE58D37DE787CDCB871835300FF6F6983F7BF6A1B80529102F8D3CACBCB97C6FDB8605E5C5BA3F109D0EF24808F1D82C8C4E7AD4A7DE8E9A5920413C4432B1B3F7EFC8455AB569D7DF1C517AF8A719BAD2132F0E79F7FFE076A6B6BAF4901FC78B50C4029892458EAE3CE4C41762E65FEB7BFFD2D978D2F0AC0B749BC2E5E9FFACF8DCBD27B9F514A4930413CB481091326FC66F9F2E5A78F1D3B76C5BDF7DEBBBAE830DEB65AF6B39FFDECA6CB2EBBECE37575753FFADDEF7E374EED02508A521F37B1BEBEFE9B85403E32F2175E7861F4A92D9A1529D769A6F5624281785DF10E407ADF0B4B2D09664C3CB4E1C668C488114FDE7EFBED374C9E3CF9C03163C6F4FED8C73ED6A3852FAF993A75EA3DB7DC72CBC00D1B360C8C31F086D00050EA52007ED3F0E1C36B2A2A2AAEADABABEB1549B03829354E783DE8A08372B31EEDBBEFBE71A5F4DC98F9183213817B5C2760C68C19B919948AA7FCCD1AA6BA3C3BF5C937955A5D09E2A16D374655E9E65F52307FE215575C7146D7AE5D07EDBFFFFE6F0D193264C77DF6D9A76BDFBE7D07C434846BD7AE7D336D8496BFF0C20B73A64F9F5E3167CE9CFDD2862BE624BCBABABA7ABC935801E82C0A49B0F2F2F2EB5320FF2FB12C82F908D01BCDF5BE35D3630C7CA926C104F1D03EC17C5C54E28E51A346ED3173E6CC139F7BEEB94FA5C787A612E982B8AA5D9FACE10A777129F5FF9BCA19A57E212700D842BF197DE0B04882A5407C4CBAFF99B820544B83F7546E28F52498201EDA515CD422DDFC3C5F00802D07F31B936075757527A640BE90041B903524C12219B62895E7529916EB76962498201E00800E4D126C7366A7010000413CD002FF94CAA71A2DFB6E2AFB173D3E3CBF0C0040100FEDE4D3A91C9BCA15A9FC7BFEFE09A9DC9FCAC0267E7F07A5527C06FD975299A41A01E88486A7B257D1E31802FE5F2D78DD1F3A4B7C6B4C3CB49DC7F2B7EF4B65412A0FA7B2632A9F4DE5C1A2F5764FE563A9EC910FF4F74EE5B6FC6BDE48E59854E252D44FA952003A894884FDAEE871CC32B343FE7ED754D6650D27B61E98359CD85A10CB3F50F4F85B5943326D69A955904C3CBC7BBAE66F2350FF7B2A13537934953DF3D986BFE783FAF89DDE986D3AD406004AD5E07CBF17434FBF902F852457DC5E984AFFAC61669A19A9BC95CAABF9B2BAE87E3CFFEFA518C0079978681B1F4E65DF54EAB28661327BE683F6EE451BA12FA77249D690711F96CA9D594396FE89FC6BDF4EE5F17C566171BE0040298BBE328E4E4FC81A125A97A7F266FEB9E83B1FCC363D9A1D7E9FCA95F9FBBBE5D70BA7A53222DF170BE2811679215FB27C2621C6E8C578F7E2E134C51BA1FEF960FE9F53F9497E83B56B3EB8CFF23B0286D30050EABAE703F1C8B647722B1258313E7E652A6B52393E955EA9DC5AF49A85457DEA2945F707956A002F8887F611E3F5B636AF6D6C6462B69A5D5259910FFCABB27F8CABFF3FAA11804E20FAC0DF640DC9ABE80323333F39BFBC109CF76FF49AE83B8FCDFE71E4FBEB594332EC9F4BB9A28C8987B6B5732AF35BB0DE7FA47248D67032CE61AA0D804E6C7CD6308B5BCCD21609E77FCB07E98559DECE6CB47E0CA5F973D670EED8BCAC6118EA83F960BE64C9C443DB8AB3E27FD282F522ABD0336B384CF8AFF90CC227B38643867EAB00742647670DB3D154E603F305D93FB2F03BE6FBCB627F4CE517A99C97CA7FA73225957159C379678278609BC4B49287E7372A3545CB63C3F35213017C1CF2BB3CFFF88A7CF621B20A8579E3F755A5007492FE3382F1183E1333CFC4F4CC31A4B4708E58F726FAD06FA6F283EC1FB3D0C46C35D7660DC37022C0BF3EBF23208807B66A71B6F9D9F32132ECBF6CB42C3636F7355AD6F8F17FAB52003A49FF19F3C33F5FB4ECF57C301F22137F5851C01F99FACB8BD65D97BF7D2595E3B28671F20B4AB1A28C890700A02379BED1E31B8BEEAF4AE591A280FFB146EB168F838FD96CFE5FA95692201E00805251D759FE50413C000008E201DEE50D5B79797D5D5D9D8AE800D2FF212E7DBE414D68E3DA3808E201B6A87BF7EE0B57AE5CA9223A80A54B97CE4E37CFA9096D5C1B07413CC01675E9D265FAF2E5CB554407505D5D1DD3C43DAA26B4716D1C04F1005B545353F35F0B162C585F5F5FAF32DE5D554B962C89E9DDEE5415DAB8360E8278802D3AE288239E4EC1CDF3F3E7CF5719EFA2D9B3674F4DFF87F99FFBDCE79E541BDAB8360E827880ADAAA9A9195D5555B566C58A152AE35DB06CD9B27B972C59F2C5BABABA73D58636AE8D43EBAB500540291A3F7EFCA2534E39E5E9C58B177FB94F9F3EDDBB75EBA652DA31B899356BD6A0B2B2B2338F3AEAA8E96A441BD7C641100FD062B7DC72CB2BA3478FFECB9B6FBE797CEA6C57F7EEDDBB47BA55316DA76AF6ECD993AAAAAA3E1BC1CDB061C3EE5725DAB8360E6DC32F1D28790F3DF4D0FEE5E5E5BFA8ACACFC58FFFEFD5FEFD7AFDFFBFBF4E933202D5339DB29E6C88E29F662868E38C12FC607C7F082A38F3E7AB6DAD1C6B57110C4036CB72953A60C2E2B2BFB4ABA3B34954353E9AE56B65B5CE426E6C87E34953B9DE0A78D6BE30000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F01EF0FF0132179F6B64528C230000000049454E44AE426082, 0);
INSERT INTO `act_ge_bytearray` VALUES ('367180af-0c5b-11ef-b8fa-005056c00008', 1, 'leave_apply.bpmn20.xml', '3670e46d-0c5b-11ef-b8fa-005056c00008', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A7873643D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22687474703A2F2F7777772E61637469766974692E6F72672F70726F63657373646566223E0A20203C70726F636573732069643D226C656176655F6170706C792220697345786563757461626C653D2274727565223E0A202020203C73746172744576656E742069643D227369642D30314134363831372D414137302D343933372D414442432D39454642393534373535464222206E616D653D22E5BC80E5A78B223E3C2F73746172744576656E743E0A202020203C757365725461736B2069643D227369642D31443438324141372D423937442D344144392D424537362D30353133453234344536454422206E616D653D22E5BCA0E4B889E5AEA1E689B9222061637469766974693A61737369676E65653D227A68616E6773616E223E3C2F757365725461736B3E0A202020203C757365725461736B2069643D227369642D41363434304143412D434530432D343535322D384144452D41413735463036343031313222206E616D653D22E69D8EE59B9BE5AEA1E689B9222061637469766974693A61737369676E65653D226C697369223E3C2F757365725461736B3E0A202020203C656E644576656E742069643D227369642D46383945394331362D373033462D343834452D424639382D39333943433344383835393422206E616D653D22E7BB93E69D9F223E3C2F656E644576656E743E0A202020203C73657175656E6365466C6F772069643D227369642D35314646443936302D393631302D344636382D384230332D4535314233453532344538452220736F757263655265663D227369642D30314134363831372D414137302D343933372D414442432D39454642393534373535464222207461726765745265663D227369642D31443438324141372D423937442D344144392D424537362D303531334532343445364544223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D227369642D34423531344233372D364439442D343744442D423738372D4534343438374438443842302220736F757263655265663D227369642D31443438324141372D423937442D344144392D424537362D30353133453234344536454422207461726765745265663D227369642D41363434304143412D434530432D343535322D384144452D414137354630363430313132223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D227369642D39414437363631432D424345382D344532462D393733432D4437423636423939323738452220736F757263655265663D227369642D41363434304143412D434530432D343535322D384144452D41413735463036343031313222207461726765745265663D227369642D46383945394331362D373033462D343834452D424639382D393339434333443838353934223E3C2F73657175656E6365466C6F773E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F6C656176655F6170706C79223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D226C656176655F6170706C79222069643D2242504D4E506C616E655F6C656176655F6170706C79223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D30314134363831372D414137302D343933372D414442432D394546423935343735354642222069643D2242504D4E53686170655F7369642D30314134363831372D414137302D343933372D414442432D394546423935343735354642223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233302E30222077696474683D2233302E302220783D223230392E393939393936383730373536322220793D223131372E3939393939363235393830383633223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D31443438324141372D423937442D344144392D424537362D303531334532343445364544222069643D2242504D4E53686170655F7369642D31443438324141372D423937442D344144392D424537362D303531334532343445364544223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2238302E30222077696474683D223130302E302220783D223330392E3939393939343633353538322220793D2239342E3939393939373938383334333237223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D41363434304143412D434530432D343535322D384144452D414137354630363430313132222069643D2242504D4E53686170655F7369642D41363434304143412D434530432D343535322D384144452D414137354630363430313132223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2238302E30222077696474683D223130302E302220783D223439342E393939393932363233393235332220793D2239342E3939393939363537323733333031223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D46383945394331362D373033462D343834452D424639382D393339434333443838353934222069643D2242504D4E53686170655F7369642D46383945394331362D373033462D343834452D424639382D393339434333443838353934223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2232382E303030303030303030303030303134222077696474683D2232382E302220783D223637342E393939393839393431373136332220793D223132302E3939393939343736393639323538223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D34423531344233372D364439442D343744442D423738372D453434343837443844384230222069643D2242504D4E456467655F7369642D34423531344233372D364439442D343744442D423738372D453434343837443844384230223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223430392E3939393939343633353538322220793D223133342E39393939393736303537343539223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223439342E393939393932363233393235332220793D223133342E3939393939363935353333303337223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D39414437363631432D424345382D344532462D393733432D443742363642393932373845222069643D2242504D4E456467655F7369642D39414437363631432D424345382D344532462D393733432D443742363642393932373845223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223539342E393939393932363233393235332220793D223133342E39393939393539343636373733223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223637342E393939393839393431373136332220793D223133342E3939393939343934343938383137223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D35314646443936302D393631302D344636382D384230332D453531423345353234453845222069643D2242504D4E456467655F7369642D35314646443936302D393631302D344636382D384230332D453531423345353234453845223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223233392E393938333531303438323334322220793D223133332E32323231393432393531393232223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330392E3939393939343633353538322220793D223133342E32353932353635393531343032223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, 0);
INSERT INTO `act_ge_bytearray` VALUES ('e2902afb-0ad7-11ef-b605-005056c00008', 1, 'process/leave_apply.bpmn20.xml', 'e2902afa-0ad7-11ef-b605-005056c00008', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A7873643D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22687474703A2F2F7777772E61637469766974692E6F72672F70726F63657373646566223E0A20203C70726F636573732069643D226C656176655F6170706C792220697345786563757461626C653D2274727565223E0A202020203C73746172744576656E742069643D227369642D30314134363831372D414137302D343933372D414442432D39454642393534373535464222206E616D653D22E5BC80E5A78B223E3C2F73746172744576656E743E0A202020203C757365725461736B2069643D227369642D31443438324141372D423937442D344144392D424537362D30353133453234344536454422206E616D653D22E5BCA0E4B889E5AEA1E689B9222061637469766974693A61737369676E65653D227A68616E6773616E223E3C2F757365725461736B3E0A202020203C757365725461736B2069643D227369642D41363434304143412D434530432D343535322D384144452D41413735463036343031313222206E616D653D22E69D8EE59B9BE5AEA1E689B9222061637469766974693A61737369676E65653D226C697369223E3C2F757365725461736B3E0A202020203C656E644576656E742069643D227369642D46383945394331362D373033462D343834452D424639382D39333943433344383835393422206E616D653D22E7BB93E69D9F223E3C2F656E644576656E743E0A202020203C73657175656E6365466C6F772069643D227369642D35314646443936302D393631302D344636382D384230332D4535314233453532344538452220736F757263655265663D227369642D30314134363831372D414137302D343933372D414442432D39454642393534373535464222207461726765745265663D227369642D31443438324141372D423937442D344144392D424537362D303531334532343445364544223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D227369642D34423531344233372D364439442D343744442D423738372D4534343438374438443842302220736F757263655265663D227369642D31443438324141372D423937442D344144392D424537362D30353133453234344536454422207461726765745265663D227369642D41363434304143412D434530432D343535322D384144452D414137354630363430313132223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D227369642D39414437363631432D424345382D344532462D393733432D4437423636423939323738452220736F757263655265663D227369642D41363434304143412D434530432D343535322D384144452D41413735463036343031313222207461726765745265663D227369642D46383945394331362D373033462D343834452D424639382D393339434333443838353934223E3C2F73657175656E6365466C6F773E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F6C656176655F6170706C79223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D226C656176655F6170706C79222069643D2242504D4E506C616E655F6C656176655F6170706C79223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D30314134363831372D414137302D343933372D414442432D394546423935343735354642222069643D2242504D4E53686170655F7369642D30314134363831372D414137302D343933372D414442432D394546423935343735354642223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233302E30222077696474683D2233302E302220783D223230392E393939393936383730373536322220793D223131372E3939393939363235393830383633223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D31443438324141372D423937442D344144392D424537362D303531334532343445364544222069643D2242504D4E53686170655F7369642D31443438324141372D423937442D344144392D424537362D303531334532343445364544223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2238302E30222077696474683D223130302E302220783D223330392E3939393939343633353538322220793D2239342E3939393939373938383334333237223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D41363434304143412D434530432D343535322D384144452D414137354630363430313132222069643D2242504D4E53686170655F7369642D41363434304143412D434530432D343535322D384144452D414137354630363430313132223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2238302E30222077696474683D223130302E302220783D223439342E393939393932363233393235332220793D2239342E3939393939363537323733333031223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D46383945394331362D373033462D343834452D424639382D393339434333443838353934222069643D2242504D4E53686170655F7369642D46383945394331362D373033462D343834452D424639382D393339434333443838353934223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2232382E303030303030303030303030303134222077696474683D2232382E302220783D223637342E393939393839393431373136332220793D223132302E3939393939343736393639323538223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D34423531344233372D364439442D343744442D423738372D453434343837443844384230222069643D2242504D4E456467655F7369642D34423531344233372D364439442D343744442D423738372D453434343837443844384230223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223430392E3939393939343633353538322220793D223133342E39393939393736303537343539223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223439342E393939393932363233393235332220793D223133342E3939393939363935353333303337223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D39414437363631432D424345382D344532462D393733432D443742363642393932373845222069643D2242504D4E456467655F7369642D39414437363631432D424345382D344532462D393733432D443742363642393932373845223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223539342E393939393932363233393235332220793D223133342E39393939393539343636373733223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223637342E393939393839393431373136332220793D223133342E3939393939343934343938383137223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D35314646443936302D393631302D344636382D384230332D453531423345353234453845222069643D2242504D4E456467655F7369642D35314646443936302D393631302D344636382D384230332D453531423345353234453845223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223233392E393938333531303438323334322220793D223133332E32323231393432393531393232223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330392E3939393939343633353538322220793D223133342E32353932353635393531343032223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, 0);
INSERT INTO `act_ge_bytearray` VALUES ('e290520c-0ad7-11ef-b605-005056c00008', 1, 'process/leave_apply.png', 'e2902afa-0ad7-11ef-b605-005056c00008', 0x89504E470D0A1A0A0000000D49484452000002F1000000E108060000004171EA53000000206348524D00007A26000080840000FA00000080E8000075300000EA6000003A98000017709CBA513C0000000467414D410000B18E7CFB5193000000017352474200AECE1CE900000006624B474400FF00FF00FFA0BDA793000000097048597300000EC400000EC401952B0E1B00001BE14944415478DAEDDD0B985565BD30F035176E22A0044A6ADEA2A3662479C94E915287D4B48B9F6980A0594F46EA31D33A9A1E7BF2704CE9A43D95C76379C91B2489F75412FC5212FDD44245484F9232A2C288DCAF233033DFFBDFB3376D86191864661CF7FC7ECFF33E7BEFB5D7BECC3BEF5EEF7FFDD7BBDE956500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B4B33255007406F5F5F5DDE7CE9DFBAFAB56AD1ABD66CD9AFD56AF5EDDBDAEAE4EC56C6F27525656DFAD5BB7C55DBB767D7AFDFAF5570C1932E411B5A28D6BE3208807D86E29B0F9F6A2458BAEACA9A9D961C08001599F3E7DB25EBD7A65E5E5E52A673B45909882C66CC58A15597575F5BADADADA17D7AE5D3BFAE8A38F9EAD76B4716D1C04F100EFC8BC79F3EE79E59557BEBCE79E7B66BBEDB65B64D5544A1B9A3F7F7E565555B5B6BEBE7EE4673FFBD97BD58836AE8D43DBA8500540290737A97CF980030EC8FAF7EF2FB8690791FDEDDBB76F97850B171E377AF4E859B7DC72CB4B6A451BD7C641100FD02231BCA0AAAAEA7B11DCF4EEDD7BB3E7DF5EF56656FDC2DD59F58BF7668BE63E92AD593A37EBD67397ACB25B6F95B79DBA76ED1A414EB7EAEAEA63478D1AF5C0F8F1E317AA156D5C1B87D665B01C5072E204BF181F1CC30B9A0B6E5E7BE637D9AA457FCBEA6AD765F5751BB2354B5ECEE6CDB821AB59F1860A6C053D7BF6CCF6DE7BEFBA8A8A8A5FAA0D6D5C1B07413CC056C50C1D71825F8C0F6ECA92571FCB36AC5BBDD9F2087616CD7D5405B6923DF6D8A36F6565E587A64E9DFA09B5A18D6BE3208807D8A298622F66E8686E7CF0DA2D6422238349EBD965975DAAD3CD57D48436AE8D83201E608B628EEC9862AF39F5B5EB9B7F71BD79B55B53BF7EFD764F3743D58436AE8D43EBAA540540A9898BDCC40C12BCFBD2FFE1FDE9A6BF9AD0C6B571685D32F140C9898BB3B8C84D07E9641AFE0F1246DAB8360E827880EDD3A5C7CECD3E57D94D76136D1C10C40374387DF7FC6456D9B5E766CB2BBAF4C8FAEE354405A18D038278808E66C7FE07643DFBEDD7E4F25EBB1CA882D0C601413C404754BB7EED66CB36BCBD52C5A08D038278808E66DDEAB77257AD5CF5D68B9B3DB77AF19C6CDE5FAECBAD03DA38208807E80096CF7F260537D7676B96CE6D769D35CB5ECDAA9EBE265B3AEF89ACDE7CDA68E34007654A24A0E445D6F1CD971ECC65215B222E4D1FEBAF7CEBC56C977F3A36EB9E9B061AB471A0E39089074A5E641D5B1ADC148B6CE6AB7FFEB50A441B0704F100ED2DB28EEF547DDD061588360E743886D300256FFF6197AA04B471A0A4C8C4030080201E0000684B86D3403BA9AFAFEF3E6BD6ACAF3DFBECB3272F58B060F0FCF9F37758B16245654D4D4D56595959DFAB57AFF57DFBF67DA377EFDE4FA4D5FFF3820B2EF89B5A030004F1F02E05EF77DD75D7B5975E7AE9C8C58B17571E70C001D9D0A143B30F7CE003590ADAB3EEDDBB6729902F5BB97265D7D75E7B6D9FD9B367EFF3CC33CF9C7CEEB9E7CE5BBD7AF5A5D75E7BEDF56A1180CE6CD4A8517B6CD8B0E1F8B2B2B223D3C3C1A90C4865C7546A52A94E7DED73E9B9C72B2A2A264E9830E175413CB05D9E7CF2C96FFCF8C73FFE9FE5CB97771B31624476D04107656903B3D97A11C847E9DFBF7F76F0C10767A79E7A6AD9CC9933F79A3871E2AFC68C19F3BD254B967C71D2A4497F57A300742623478E3C3EDD9C555B5B3B2405E9DD9B582596ED9D9EDB3BDD1E9FD6FB69EA6F1F4D8F6FB8EDB6DBC60BE2816D525F5F5F79DF7DF74DB9E9A69B3E73DC71C7659FFFFCE79B0CDEB72402FE542A1E7AE8A1FD6FBFFDF6E7BFF5AD6F7D47561E80CE2005E211945F93FAD363DEC1CB87A6D70D4DEF312605F55F2FD52498201EDA20809F366DDA130F3FFCF061E79D775EF6A10F7D68BBDEEFE8A38FCEF6DF7FFF1EE3C68DFBE537BFF9CD6ED75F7FFDD56A198052357CF8F011E9E6AA54FA15964522EC231FF94876F8E1876703070ECC76DA69A7AC57AF5ED99A356BB265CB9665555555D9D34F3F9DCD9831A37EC3860D65F9970D49AF7B76E4C891679462565E100FAD2C32F011C0FFF0873FCC0D8F690D7BEDB5573676ECD81E175F7CF1B8B4315A5EEA870801E8B401FC17CACACA6E2DC4A811BCC7D1ECA38E3AAAC93E75871D76C895DD76DB2DFBE4273F19017DD9030F3C903DF8E083F575757511CCEF585F5F7F6BEA3BBBA7BEB3A48E669B62125A518C819F3C79F267CE3EFBEC560BE00BE2FD2EBAE8A21DBB74E97255DA18EDAFB60128B1007E440AE0EF2E04F011985F7EF9E571526B8BFBD4C8D0C7FAE3C68D2BDB7DF7DD6B0BCB53207F5DEA3B470BE281CDC42C3453A64CB926C6C06FEF109AE644463E6DE4BA959797DFA8C601281531063E05F0571502F8FDF6DB2FBBE4924B7233B9BD13F1BAB163C7560C1A34A8BEA89FBEA694926082786825F7DC73CF0D314D648C616F4BC71E7B6C8F3E7DFAEC536A1905003AAF14C05F97E5C7C04706FE7BDFFB5E6ECCFBF6886136DFFDEE778B33F231B4E63A413C9015EDDD779F3D7BF657631AC92E5DBAB4F9E78D193366E7F2F2F2B3D43C00EF75318D64EA4787C5FD18039F02EFED0EE08B03F973CE39A722F599858CFC9052498209E2A115C49558172E5C5819D342B6878F7EF4A35DBB75EBB64F7E0AAE9293FEAE8B63A33E74E85027DF0394BE8D49A93889F59D0EA1694EBCDF17BFF8C5C28C3591781B530A95A6838456F0ECB3CF9EDCDC859CDACAA04183AA9F7AEAA913D3DD2B4AB04AFF336D64B3010306AC1E3E7CF83DE5E5E5E3376CD8307DD2A449ABB4364A6547B5ACAC6CF682050BEE7FF4D14737A8113A6B7B8E2BB1D6D6D60E8DFB859968DAC231C71C933DF0C00385E9278744126CE2C48955EFE57A9789875690365C8363FEDAF674F8E187EF946E8E2CF1AAED993A865129A09F9C36EE6F8C1C39F2E6548E39EDB4D3BA77B42F5A575797AD5AD5B08F71CD35D7B4D9E75C7FFDF5D9BA75EBB6BACE8B2FBE98BB3F73E6CC8DCBE7CD9BE7C7DAB17654EFDE75D75D57C48E6AB4EB934E3A69C7F7C217FFE31FFF989B8FBB39F3E7CFCFFD1E9AB370E1C2ECF5D75FD7C64BB33D2F4FEDF9B66D69CF29A88E2BB2E692CA910CEBDBB76F9B7CC198B5E690430E292B5A74E27BBDD205F1D00A52A7B543CC1CD39EF6DD77DF1DD2CDE04E54CDBD5327716A04F43535358B478C1871E3BB3DE42602953BEFBC33FBC31FFE905D76D965D90D37DC905BFE97BFFC65E33AD3A64DDB18DCE73BAC5C80D25CB9F1C61B370627A171B0D3B367CF4DDEBFA97566CD9AB5F170F4B9E79EBB31203AF5D453B7185CD1FED24E6A8F54BE9CDF51AD4EED7A5247DB515DBC78F126E5A5975ECAAAABAB373EFEEB5FFF9A6BFF058F3FFE78EE71FC2E8E3FFEF838E93F9B346952EE7E2CBBF6DA6BB3DFFFFEF7DA7869B6E71D52195148BCA4F63C616BED39ADBF3119F5F18F7FBC4DBF5FA3F77FCF27C10CA78156B062C58ACAD8CB6F4F6BD6ACE99F36941BD246F292A2C5D5A9D434B57E5AB7266D2CAB9B7BBFF4FCA2F47CB3C35552A7FD7A073AEC1F3B30A7A5EF7CDA80010396A64EE2A1F4F8E66EDDBA3D7AD34D37D5B45B16A4BC3CFBCA57BEB2F1F1CA952B37793EB282575F7D75F6939FFC24DB71C71D0BF598BDF0C20B596565D39BDFD8192CCE424E9C3831FBF0873F9CFBAC1059CC3E7DFAE482A1C24EC2FBDEF7BEECFBDFFF7E6E0721EDE0E46E5F7EF9E55C80B5FBEEBB675DBB76CDAD1B414FE17DE8907AA672626AD727A6FFE3BAF4DBBE2FFD2627BCDB436E2280FEE0073F98BBFFF39FFF3C7BECB1C7B24F7DEA5331A42F377777B4D9EF7CE73B9BBCE6D0430FCD0D5F78F0C1077317E959BB766D367DFAF4DCB2C6BF156DBC74132FA99C9CDAF3C9E97F56133BA8A93DDFD5447B1E5C949C6AD32FB4F7DE7B674D7DAE201E3AB1E854BA776FDFC4D98C1933228311BFE11FB53043B25DCFA76039C63D6EED639ADD89685C65F9755BC3CEA993882F3622FE0FC3870FFF7B04CAEDE5BEFBEECB051091398C798D0B6248410427518A838A3DF6D82357B6C5B1C71EBB494015814A0450213E739F7DF6D9D80EDF7CF3CD5C2672E79D77CE2D8FCCFED2A54B379935E984134EC81D358875E8B0BA1602FA383724EDA84E4B8FAF6AEF1DD55038613F82E9D8C18C6CF7FBDFFFFEECE69B6FCEBEF6B5AF6D6C7F4D79FBEDB773BF8F08E2B5F14E2D3AC853527B3E65D75D775D99FA92A931A564B4E7F43F1D5058A9AD93618DDEBF9F201EC8D286A83E6D88CADA33901F3C78F0E23BEEB8A34FDA10FEB868F1AEF98D6553417AF7B4011DB085B78C0DDA96C630EED1826DC6806DF813DAE4821BE9EF1C183B385FFDEA57DBE5FF10C302AEBBEEBA983168E361FC08E0E7CC99939D7FFEF9B9C7319CA69089DF56917D8CA109071F7C70EE710CB5E9D7AF5FF6C61B6F64555555711468E3E7C4674489A029C695C63A11DC44E6B430DC2BDEEBA28B2E6AB7E066D1A245D933CF3C93353A62C4B6E9997EBB11E51E1B416CAACBAAB7DE7AAB5DBF4064C5E3C8D2D8B163B35B6FBD35EBDDBB77F6831FFC203BEBACB372C35F22C31E19F7C647982263DEDC51276DBC734ADBE8983BF284D4A64F88F65CACB5A6956C4E4C37D968C742100F9D5DEAD0D62F5BB6AC6B64ABDBAD57EFD97371DA18AE9D38716287E9384E3AE9A4011515155BDD30B66087E291167E645CC0A3A2D17BBF3268D0A07DDBEB6F2E1CC68FE101114C3CFFFCF3B9603E828FC83E46103375EAD4ECCA2BAFDC18CC3CF1C413596A2F9B1DF68FA107871C72482EBB592C860D445012162C58900D1B362C17C8C4F084575F7D759375632842ACFFDBDFFE361B3D7A742E90F9D297BEB4F1B5BFFEF5AF1B77646D2A82AB679F7D36EEFEC896A2D5EC1D2796160FE56A2B1140FFE94F7FCA5D85BA478F1EB9603E86D044E01A01FC61871D960D1C3830174C37358CA5A5890D6D9CC276B42D03F9356BD6143FAC79AFD797201E5AC14E3BED342F753403DB33889F356BD6CBF920B6C3983469D2B68C63F9DFE69ED8C2B09DBA14FCD7E58711858AF478597AFC708C1DEED6ADDB1F62A8C137BEF18DFAF6F87B23408FB1BC11D8FCE217BFC81DD6FFC4273E913BD975D75D77CD860E1D9A0B62BEF0852F6CF2BA38B9AAA9EC6461BC70539F53181F3C7BF6EC5CD012EF1BF763584341043C11C0C4F3279F7CF266814CACDB9EC14DF8F4A73F9D0BC25290F31FB6149B6869C0178777CA1BEFA81E7AE8A1EDB2A31A19F742FB2D0C178BE16AE977969D77DE79D981071ED8EC6B63584C71FB8C761C3BB84D9D78AA8D778AF6DC78FB5D68CFEBD3F2DC58A8486EB465101FEF5F6491201E888E6E5AEA6C061E7EF8E1EDF6994F3CF14404AAD33A41F5468F1F677A464AAF3C6DF023A0891370A3C7FF5D8F1E3D1E4E01C5B27765039A02F1C846E67760B2E29DB8238E3822176C9C73CE394DBE6E5B3FA710E0176729A3146729870C19922B4D7D66B1188A11D9D4F610C3226298C405175C70892DC5263BAACD063D29A0A94DEDBC7084A9FCDDDE518D234485234E21B2A58F3CF2480CE9CB5E7BEDB5DCE368FF11D81707D0310B4D61184C04DDF1DCE9A79F9E0BCE6307571BEF14EDB92E9F6CEA52D87E376ECF353535B766F9E91E5F79E59556BFD053B138425AE439413C902D5FBEFCF2D4D17CBDB6B6B6BC9D2EF8543367CE9C18537E5627A8DEF27C001F81FB1DA93C908280FBDBFBE4BE9604DAC50AC1CCC30F3F9C0B48B669AFA5AE6E93A109071C70409359CAB973E76E72326D7362F84171E7F5E73FFF79931309E9106247351729E703F80EB3A31A99F8E2F618E77814CF34134E3AE9A44D5EF7E4934FE6A67E2C9C0B12AFFFE94F7F9ABB1F6DB9F14C4EDA784989A07D7D21F1922FCDB6E7E1C3874F4B6D3E17C4C730B1238F6CBB991F1B5DDFE03D9F0413C4432BB8F4D24B5F3EEFBCF3E6CE9C39F3838593B3DAD2942953EE4C81DE5EEFF5ABCD6D4D646CD2CDA32900284C1FB9ACA37DC7189B1B19BFE213B46218C1AF7EF5AB6CE4C891D999679E991B137FF6D967E7029938016E4B99F898FDE3F2CB2FCF8DF72DCCC81127FE151467291B8B31F9AB57AFDEF85D6267E0B9E79ECB0DEF39E38C3336064EF1FDE27BB4475BA5C5BA76D41DD5E2003EDA67A32109CD06FF4F3DF55493CF359EC9491B2F3915F9D2A2F69CDACA3DE9FFF8F3B4BDAF880B772D59B2A44D2EF814ED36DA44913B04F140CEF2E5CB2F4C81D76F0F3AE8A0CA36CEC62FBBF9E69B3F5C5656F6B312AECE1FA6BFAF2A6DF8EFE86819F7C662FC669C601873C18738113066EB38EDB4D37299C49862F2FEFBEFDF38ADE46EBBEDB6D5F72C9CA4D794F5EBD7E74E226C2A3B19D9CB38C92E66C6290440F1BD0A19C96F7FFBDBB971FB6987A84D0F59535A3BAAC522088A6039E68BDF52D01F33D53477E19E783E86E968E3DA73983061C2EB23478E8CC90C86D5D6D66693274FCE468D1AD5EADF2D8EF444DBCA9B5E0A4930413CB4921B6EB861D29831637E983640831A9FC8D89AAEB8E28AC8C2EF575D5D3DB154EB326D5C2F7DAF7CD75D76D92597692F881301EFBAEBAE7F6C642B2B7357AA6C2DB173503C3EB9A91D80E29D80E22105CD9D388B1DD5968A13B763A8CA968E266D6DD69C08F0B571EDB991AB23888F3B11C4C73945ADB91316E76E4432A5207DD75F9742A50BE2A1152D5FBEFC4B77DF7DF70BFBEDB75F8F9892ADB5CD9A35EBBE1933661C9736409FE940574FA51D6D29B8C18E6ABB040E9595DA38ADDA9E6FBBEDB67BE28266F5F5F54746363E8EF45C72C925AD32534D4C2B79D5555765F1BE79D3172C5850124930D72686D6DD9055AD5BB7EEF42BAFBC724D6B5F8CE58D37DE787CDCB871835300FF6F6983F7BF6A1B80529102F8D3CACBCB97C6FDB8605E5C5BA3F109D0EF24808F1D82C8C4E7AD4A7DE8E9A5920413C4432B1B3F7EFC8455AB569D7DF1C517AF8A719BAD2132F0E79F7FFE076A6B6BAF4901FC78B50C4029892458EAE3CE4C41762E65FEB7BFFD2D978D2F0AC0B749BC2E5E9FFACF8DCBD27B9F514A4930413CB481091326FC66F9F2E5A78F1D3B76C5BDF7DEBBBAE830DEB65AF6B39FFDECA6CB2EBBECE37575753FFADDEF7E374EED02508A521F37B1BEBEFE9B85403E32F2175E7861F4A92D9A1529D769A6F5624281785DF10E407ADF0B4B2D09664C3CB4E1C668C488114FDE7EFBED374C9E3CF9C03163C6F4FED8C73ED6A3852FAF993A75EA3DB7DC72CBC00D1B360C8C31F086D00050EA52007ED3F0E1C36B2A2A2AAEADABABEB1549B03829354E783DE8A08372B31EEDBBEFBE71A5F4DC98F9183213817B5C2760C68C19B919948AA7FCCD1AA6BA3C3BF5C937955A5D09E2A16D374655E9E65F52307FE215575C7146D7AE5D07EDBFFFFE6F0D193264C77DF6D9A76BDFBE7D07C434846BD7AE7D336D8496BFF0C20B73A64F9F5E3167CE9CFDD2862BE624BCBABABA7ABC935801E82C0A49B0F2F2F2EB5320FF2FB12C82F908D01BCDF5BE35D3630C7CA926C104F1D03EC17C5C54E28E51A346ED3173E6CC139F7BEEB94FA5C787A612E982B8AA5D9FACE10A777129F5FF9BCA19A57E212700D842BF197DE0B04882A5407C4CBAFF99B820544B83F7546E28F52498201EDA515CD422DDFC3C5F00802D07F31B936075757527A640BE90041B903524C12219B62895E7529916EB76962498201E00800E4D126C7366A7010000413CD002FF94CAA71A2DFB6E2AFB173D3E3CBF0C0040100FEDE4D3A91C9BCA15A9FC7BFEFE09A9DC9FCAC0267E7F07A5527C06FD975299A41A01E88486A7B257D1E31802FE5F2D78DD1F3A4B7C6B4C3CB49DC7F2B7EF4B65412A0FA7B2632A9F4DE5C1A2F5764FE563A9EC910FF4F74EE5B6FC6BDE48E59854E252D44FA952003A894884FDAEE871CC32B343FE7ED754D6650D27B61E98359CD85A10CB3F50F4F85B5943326D69A955904C3CBC7BBAE66F2350FF7B2A13537934953DF3D986BFE783FAF89DDE986D3AD406004AD5E07CBF17434FBF902F852457DC5E984AFFAC61669A19A9BC95CAABF9B2BAE87E3CFFEFA518C0079978681B1F4E65DF54EAB28661327BE683F6EE451BA12FA77249D690711F96CA9D594396FE89FC6BDF4EE5F17C566171BE0040298BBE328E4E4FC81A125A97A7F266FEB9E83B1FCC363D9A1D7E9FCA95F9FBBBE5D70BA7A53222DF170BE2811679215FB27C2621C6E8C578F7E2E134C51BA1FEF960FE9F53F9497E83B56B3EB8CFF23B0286D30050EABAE703F1C8B647722B1258313E7E652A6B52393E955EA9DC5AF49A85457DEA2945F707956A002F8887F611E3F5B636AF6D6C6462B69A5D5259910FFCABB27F8CABFF3FAA11804E20FAC0DF640DC9ABE80323333F39BFBC109CF76FF49AE83B8FCDFE71E4FBEB594332EC9F4BB9A28C8987B6B5732AF35BB0DE7FA47248D67032CE61AA0D804E6C7CD6308B5BCCD21609E77FCB07E98559DECE6CB47E0CA5F973D670EED8BCAC6118EA83F960BE64C9C443DB8AB3E27FD282F522ABD0336B384CF8AFF90CC227B38643867EAB00742647670DB3D154E603F305D93FB2F03BE6FBCB627F4CE517A99C97CA7FA73225957159C379678278609BC4B49287E7372A3545CB63C3F35213017C1CF2BB3CFFF88A7CF621B20A8579E3F755A5007492FE3382F1183E1333CFC4F4CC31A4B4708E58F726FAD06FA6F283EC1FB3D0C46C35D7660DC37022C0BF3EBF23208807B66A71B6F9D9F32132ECBF6CB42C3636F7355AD6F8F17FAB52003A49FF19F3C33F5FB4ECF57C301F22137F5851C01F99FACB8BD65D97BF7D2595E3B28671F20B4AB1A28C890700A02379BED1E31B8BEEAF4AE591A280FFB146EB168F838FD96CFE5FA95692201E00805251D759FE50413C000008E201DEE50D5B79797D5D5D9D8AE800D2FF212E7DBE414D68E3DA3808E201B6A87BF7EE0B57AE5CA9223A80A54B97CE4E37CFA9096D5C1B07413CC01675E9D265FAF2E5CB554407505D5D1DD3C43DAA26B4716D1C04F1005B545353F35F0B162C585F5F5FAF32DE5D554B962C89E9DDEE5415DAB8360E8278802D3AE288239E4EC1CDF3F3E7CF5719EFA2D9B3674F4DFF87F99FFBDCE79E541BDAB8360E827880ADAAA9A9195D5555B566C58A152AE35DB06CD9B27B972C59F2C5BABABA73D58636AE8D43EBAB500540291A3F7EFCA2534E39E5E9C58B177FB94F9F3EDDBB75EBA652DA31B899356BD6A0B2B2B2338F3AEAA8E96A441BD7C641100FD062B7DC72CB2BA3478FFECB9B6FBE797CEA6C57F7EEDDBB47BA55316DA76AF6ECD993AAAAAA3E1BC1CDB061C3EE5725DAB8360E6DC32F1D28790F3DF4D0FEE5E5E5BFA8ACACFC58FFFEFD5FEFD7AFDFFBFBF4E933202D5339DB29E6C88E29F662868E38C12FC607C7F082A38F3E7AB6DAD1C6B57110C4036CB72953A60C2E2B2BFB4ABA3B34954353E9AE56B65B5CE426E6C87E34953B9DE0A78D6BE30000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F01EF0FF0132179F6B64528C230000000049454E44AE426082, 0);

-- ----------------------------
-- Table structure for act_ge_property
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_property`;
CREATE TABLE `act_ge_property`  (
  `NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `VALUE_` varchar(300) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`NAME_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ge_property
-- ----------------------------
INSERT INTO `act_ge_property` VALUES ('cfg.execution-related-entities-count', 'false', 1);
INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', 1);
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(7.1.0-M6)', 1);
INSERT INTO `act_ge_property` VALUES ('schema.version', '7.1.0-M6', 1);

-- ----------------------------
-- Table structure for act_hi_actinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_actinst`;
CREATE TABLE `act_hi_actinst`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) NULL DEFAULT NULL,
  `DURATION_` bigint(0) NULL DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_ACT_INST_START`(`START_TIME_`) USING BTREE,
  INDEX `ACT_IDX_HI_ACT_INST_END`(`END_TIME_`) USING BTREE,
  INDEX `ACT_IDX_HI_ACT_INST_PROCINST`(`PROC_INST_ID_`, `ACT_ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_ACT_INST_EXEC`(`EXECUTION_ID_`, `ACT_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_hi_actinst
-- ----------------------------
INSERT INTO `act_hi_actinst` VALUES ('208b5cd4-0c6c-11ef-9ddb-005056c00008', 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', '208ae7a3-0c6c-11ef-9ddb-005056c00008', 'sid-01A46817-AA70-4937-ADBC-9EFB954755FB', NULL, NULL, '开始', 'startEvent', NULL, '2024-05-07 20:20:01.378', '2024-05-07 20:20:01.381', 3, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('208c4735-0c6c-11ef-9ddb-005056c00008', 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', '208ae7a3-0c6c-11ef-9ddb-005056c00008', 'sid-1D482AA7-B97D-4AD9-BE76-0513E244E6ED', '208e9126-0c6c-11ef-9ddb-005056c00008', NULL, '张三审批', 'userTask', 'zhangsan', '2024-05-07 20:20:01.384', '2024-05-07 22:06:24.379', 6382995, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('fd1cc8fc-0c7a-11ef-b029-005056c00008', 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', '208ae7a3-0c6c-11ef-9ddb-005056c00008', 'sid-A6440ACA-CE0C-4552-8ADE-AA75F0640112', 'fd1faf2d-0c7a-11ef-b029-005056c00008', NULL, '李四审批', 'userTask', 'lisi', '2024-05-07 22:06:24.384', NULL, NULL, NULL, '');

-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `URL_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CONTENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TIME_` datetime(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ACTION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `MESSAGE_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FULL_MSG_` longblob NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DOUBLE_` double NULL DEFAULT NULL,
  `LONG_` bigint(0) NULL DEFAULT NULL,
  `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_DETAIL_PROC_INST`(`PROC_INST_ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_DETAIL_ACT_INST`(`ACT_INST_ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_DETAIL_TIME`(`TIME_`) USING BTREE,
  INDEX `ACT_IDX_HI_DETAIL_NAME`(`NAME_`) USING BTREE,
  INDEX `ACT_IDX_HI_DETAIL_TASK_ID`(`TASK_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_IDENT_LNK_USER`(`USER_ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_IDENT_LNK_TASK`(`TASK_ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_IDENT_LNK_PROCINST`(`PROC_INST_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_hi_identitylink
-- ----------------------------
INSERT INTO `act_hi_identitylink` VALUES ('208f7b88-0c6c-11ef-9ddb-005056c00008', NULL, 'participant', 'zhangsan', NULL, '208939f1-0c6c-11ef-9ddb-005056c00008');
INSERT INTO `act_hi_identitylink` VALUES ('fd210ebf-0c7a-11ef-b029-005056c00008', NULL, 'participant', 'lisi', NULL, '208939f1-0c6c-11ef-9ddb-005056c00008');

-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) NULL DEFAULT NULL,
  `DURATION_` bigint(0) NULL DEFAULT NULL,
  `START_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `START_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `END_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE INDEX `PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_PRO_INST_END`(`END_TIME_`) USING BTREE,
  INDEX `ACT_IDX_HI_PRO_I_BUSKEY`(`BUSINESS_KEY_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_hi_procinst
-- ----------------------------
INSERT INTO `act_hi_procinst` VALUES ('208939f1-0c6c-11ef-9ddb-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', '1', 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', '2024-05-07 20:20:01.363', NULL, NULL, NULL, 'sid-01A46817-AA70-4937-ADBC-9EFB954755FB', NULL, NULL, NULL, '', NULL);

-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `CLAIM_TIME_` datetime(3) NULL DEFAULT NULL,
  `END_TIME_` datetime(3) NULL DEFAULT NULL,
  `DURATION_` bigint(0) NULL DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PRIORITY_` int(0) NULL DEFAULT NULL,
  `DUE_DATE_` datetime(3) NULL DEFAULT NULL,
  `FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_TASK_INST_PROCINST`(`PROC_INST_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_hi_taskinst
-- ----------------------------
INSERT INTO `act_hi_taskinst` VALUES ('208e9126-0c6c-11ef-9ddb-005056c00008', 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', 'sid-1D482AA7-B97D-4AD9-BE76-0513E244E6ED', '208939f1-0c6c-11ef-9ddb-005056c00008', '208ae7a3-0c6c-11ef-9ddb-005056c00008', '张三审批', NULL, NULL, NULL, 'zhangsan', '2024-05-07 20:20:01.399', NULL, '2024-05-07 22:06:24.359', 6382960, NULL, 50, NULL, NULL, NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('fd1faf2d-0c7a-11ef-b029-005056c00008', 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', 'sid-A6440ACA-CE0C-4552-8ADE-AA75F0640112', '208939f1-0c6c-11ef-9ddb-005056c00008', '208ae7a3-0c6c-11ef-9ddb-005056c00008', '李四审批', NULL, NULL, NULL, 'lisi', '2024-05-07 22:06:24.403', NULL, NULL, NULL, NULL, 50, NULL, NULL, NULL, '');

-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DOUBLE_` double NULL DEFAULT NULL,
  `LONG_` bigint(0) NULL DEFAULT NULL,
  `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CREATE_TIME_` datetime(3) NULL DEFAULT NULL,
  `LAST_UPDATED_TIME_` datetime(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_PROCVAR_PROC_INST`(`PROC_INST_ID_`) USING BTREE,
  INDEX `ACT_IDX_HI_PROCVAR_NAME_TYPE`(`NAME_`, `VAR_TYPE_`) USING BTREE,
  INDEX `ACT_IDX_HI_PROCVAR_TASK_ID`(`TASK_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_hi_varinst
-- ----------------------------
INSERT INTO `act_hi_varinst` VALUES ('208a7272-0c6c-11ef-9ddb-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', NULL, 'data', 'json', 1, NULL, NULL, NULL, '{\"Fo571osljo96p6\":\"单独\",\"F1sp62uyd6opj\":\"2\",\"Fk161osljo2nic\":\"2024-05-01\",\"F3z01osljo5dcn\":\"2024-05-02\"}', 'java.util.LinkedHashMap', '2024-05-07 20:20:01.373', '2024-05-07 22:06:24.373');
INSERT INTO `act_hi_varinst` VALUES ('208f7b87-0c6c-11ef-9ddb-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', '208ae7a3-0c6c-11ef-9ddb-005056c00008', '208e9126-0c6c-11ef-9ddb-005056c00008', 'data', 'json', 0, NULL, NULL, NULL, '{\"Fo571osljo96p6\":\"单独\",\"F1sp62uyd6opj\":\"2\",\"Fk161osljo2nic\":\"2024-05-01\",\"F3z01osljo5dcn\":\"2024-05-02\"}', 'java.util.LinkedHashMap', '2024-05-07 20:20:01.405', '2024-05-07 20:20:01.405');
INSERT INTO `act_hi_varinst` VALUES ('fd20727e-0c7a-11ef-b029-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', '208ae7a3-0c6c-11ef-9ddb-005056c00008', 'fd1faf2d-0c7a-11ef-b029-005056c00008', 'data', 'json', 0, NULL, NULL, NULL, '{\"Fo571osljo96p6\":\"单独\",\"F1sp62uyd6opj\":\"2\",\"Fk161osljo2nic\":\"2024-05-01\",\"F3z01osljo5dcn\":\"2024-05-02\"}', 'java.util.LinkedHashMap', '2024-05-07 22:06:24.409', '2024-05-07 22:06:24.409');

-- ----------------------------
-- Table structure for act_procdef_info
-- ----------------------------
DROP TABLE IF EXISTS `act_procdef_info`;
CREATE TABLE `act_procdef_info`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `INFO_JSON_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE INDEX `ACT_UNIQ_INFO_PROCDEF`(`PROC_DEF_ID_`) USING BTREE,
  INDEX `ACT_IDX_INFO_PROCDEF`(`PROC_DEF_ID_`) USING BTREE,
  INDEX `ACT_FK_INFO_JSON_BA`(`INFO_JSON_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
  `ENGINE_VERSION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `VERSION_` int(0) NULL DEFAULT 1,
  `PROJECT_RELEASE_VERSION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_re_deployment
-- ----------------------------
INSERT INTO `act_re_deployment` VALUES ('05fe4ee6-0d28-11ef-97b7-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 18:45:02.200', NULL, 34, NULL);
INSERT INTO `act_re_deployment` VALUES ('217f73a8-0ad4-11ef-96e8-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 19:39:28.307', NULL, 3, NULL);
INSERT INTO `act_re_deployment` VALUES ('28195ed4-0c6b-11ef-9f16-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 20:13:04.532', NULL, 19, NULL);
INSERT INTO `act_re_deployment` VALUES ('3670e46d-0c5b-11ef-b8fa-005056c00008', NULL, NULL, NULL, '', '2024-05-07 18:18:56.669', NULL, 1, NULL);
INSERT INTO `act_re_deployment` VALUES ('384db43d-0cf2-11ef-ac5c-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 12:19:53.784', NULL, 28, NULL);
INSERT INTO `act_re_deployment` VALUES ('392940b5-0ebc-11ef-a598-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-10 18:58:24.721', NULL, 41, NULL);
INSERT INTO `act_re_deployment` VALUES ('40c94e37-0b6d-11ef-9c7f-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-06 13:55:33.783', NULL, 11, NULL);
INSERT INTO `act_re_deployment` VALUES ('4275d072-0cf6-11ef-96e6-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 12:48:48.812', NULL, 30, NULL);
INSERT INTO `act_re_deployment` VALUES ('42cb1d56-0ebd-11ef-97e6-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-10 19:05:50.380', NULL, 42, NULL);
INSERT INTO `act_re_deployment` VALUES ('45666bad-0c7d-11ef-85bd-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 22:22:44.643', NULL, 22, NULL);
INSERT INTO `act_re_deployment` VALUES ('46bdbdf0-0cd2-11ef-ae1e-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 08:31:14.116', NULL, 26, NULL);
INSERT INTO `act_re_deployment` VALUES ('4a4b7673-0eba-11ef-803c-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-10 18:44:34.477', NULL, 40, NULL);
INSERT INTO `act_re_deployment` VALUES ('4f98eedb-0c7e-11ef-8fb2-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 22:30:11.250', NULL, 23, NULL);
INSERT INTO `act_re_deployment` VALUES ('514a2fb2-0c2e-11ef-8bd8-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 12:57:34.353', NULL, 16, NULL);
INSERT INTO `act_re_deployment` VALUES ('5167b397-0d2b-11ef-b597-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 19:08:37.214', NULL, 35, NULL);
INSERT INTO `act_re_deployment` VALUES ('52c7accf-0ceb-11ef-b803-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 11:30:31.727', NULL, 27, NULL);
INSERT INTO `act_re_deployment` VALUES ('59d42aef-0d31-11ef-b6c2-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 19:51:48.322', NULL, 37, NULL);
INSERT INTO `act_re_deployment` VALUES ('5ac071c0-0c6b-11ef-9ddb-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 20:14:29.526', NULL, 20, NULL);
INSERT INTO `act_re_deployment` VALUES ('62bea400-0bbd-11ef-a539-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-06 23:29:10.508', NULL, 15, NULL);
INSERT INTO `act_re_deployment` VALUES ('643127ac-0c4e-11ef-b8fa-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 16:47:09.961', NULL, 17, NULL);
INSERT INTO `act_re_deployment` VALUES ('687b75c9-0eac-11ef-86fe-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-10 17:05:12.164', NULL, 38, NULL);
INSERT INTO `act_re_deployment` VALUES ('6aab4089-0b72-11ef-a9b9-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-06 14:32:31.548', NULL, 12, NULL);
INSERT INTO `act_re_deployment` VALUES ('748a1dbe-0eb6-11ef-a865-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-10 18:17:07.367', NULL, 39, NULL);
INSERT INTO `act_re_deployment` VALUES ('8a3cc7b0-0ad7-11ef-a48e-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 20:03:52.522', NULL, 4, NULL);
INSERT INTO `act_re_deployment` VALUES ('914139fb-0d15-11ef-8960-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 16:32:55.405', NULL, 32, NULL);
INSERT INTO `act_re_deployment` VALUES ('91edffca-0ccc-11ef-aba8-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 07:50:23.282', NULL, 25, NULL);
INSERT INTO `act_re_deployment` VALUES ('a3900a9d-0d2d-11ef-9eea-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 19:25:14.043', NULL, 36, NULL);
INSERT INTO `act_re_deployment` VALUES ('a4a23f79-0cf2-11ef-aa7a-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 12:22:55.528', NULL, 29, NULL);
INSERT INTO `act_re_deployment` VALUES ('a6c8f916-0b76-11ef-ad7c-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-06 15:02:50.388', NULL, 13, NULL);
INSERT INTO `act_re_deployment` VALUES ('b63c416b-0a9d-11ef-8d72-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 13:09:55.527', NULL, 1, NULL);
INSERT INTO `act_re_deployment` VALUES ('bd613600-0d1a-11ef-8851-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 17:09:56.916', NULL, 33, NULL);
INSERT INTO `act_re_deployment` VALUES ('c819e34d-0adb-11ef-a2e1-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 20:34:14.293', NULL, 10, NULL);
INSERT INTO `act_re_deployment` VALUES ('ccf42cd7-0ad9-11ef-a632-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 20:20:03.447', NULL, 7, NULL);
INSERT INTO `act_re_deployment` VALUES ('d0f711c4-0c7e-11ef-aea1-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 22:33:48.287', NULL, 24, NULL);
INSERT INTO `act_re_deployment` VALUES ('df785c20-0ada-11ef-a79f-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 20:27:44.005', NULL, 8, NULL);
INSERT INTO `act_re_deployment` VALUES ('e0b79a69-0ad7-11ef-b605-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 20:06:17.610', NULL, 5, NULL);
INSERT INTO `act_re_deployment` VALUES ('e2902afa-0ad7-11ef-b605-005056c00008', '请假申请流程', NULL, NULL, '', '2024-05-05 20:06:20.712', NULL, 1, NULL);
INSERT INTO `act_re_deployment` VALUES ('e4b5d1b0-0b98-11ef-b3a6-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-06 19:07:57.175', NULL, 14, NULL);
INSERT INTO `act_re_deployment` VALUES ('eee10feb-0ada-11ef-89de-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 20:28:09.859', NULL, 9, NULL);
INSERT INTO `act_re_deployment` VALUES ('efebec6b-0c69-11ef-9351-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 20:04:20.797', NULL, 18, NULL);
INSERT INTO `act_re_deployment` VALUES ('eff3e351-0cfa-11ef-a07c-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-08 13:22:17.869', NULL, 31, NULL);
INSERT INTO `act_re_deployment` VALUES ('f00a8851-0a9d-11ef-b4a0-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 13:11:32.510', NULL, 2, NULL);
INSERT INTO `act_re_deployment` VALUES ('f167a75b-0c7a-11ef-b029-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-07 22:06:04.730', NULL, 21, NULL);
INSERT INTO `act_re_deployment` VALUES ('face1c26-0ad8-11ef-93b2-005056c00008', 'SpringAutoDeployment', NULL, NULL, '', '2024-05-05 20:14:10.875', NULL, 6, NULL);

-- ----------------------------
-- Table structure for act_re_model
-- ----------------------------
DROP TABLE IF EXISTS `act_re_model`;
CREATE TABLE `act_re_model`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `VERSION_` int(0) NULL DEFAULT NULL,
  `META_INFO_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EDITOR_SOURCE_VALUE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_FK_MODEL_SOURCE`(`EDITOR_SOURCE_VALUE_ID_`) USING BTREE,
  INDEX `ACT_FK_MODEL_SOURCE_EXTRA`(`EDITOR_SOURCE_EXTRA_VALUE_ID_`) USING BTREE,
  INDEX `ACT_FK_MODEL_DEPLOYMENT`(`DEPLOYMENT_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `VERSION_` int(0) NOT NULL,
  `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HAS_START_FORM_KEY_` tinyint(0) NULL DEFAULT NULL,
  `HAS_GRAPHICAL_NOTATION_` tinyint(0) NULL DEFAULT NULL,
  `SUSPENSION_STATE_` int(0) NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  `ENGINE_VERSION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `APP_VERSION_` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE INDEX `ACT_UNIQ_PROCDEF`(`KEY_`, `VERSION_`, `TENANT_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_re_procdef
-- ----------------------------
INSERT INTO `act_re_procdef` VALUES ('leave_apply:1:e2b90fbd-0ad7-11ef-b605-005056c00008', 1, 'http://www.activiti.org/processdef', NULL, 'leave_apply', 1, 'e2902afa-0ad7-11ef-b605-005056c00008', 'process/leave_apply.bpmn20.xml', 'process/leave_apply.png', NULL, 0, 1, 1, '', NULL, NULL);
INSERT INTO `act_re_procdef` VALUES ('leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', 1, 'http://www.activiti.org/processdef', NULL, 'leave_apply', 2, '3670e46d-0c5b-11ef-b8fa-005056c00008', 'leave_apply.bpmn20.xml', 'leave_apply.png', NULL, 0, 1, 1, '', NULL, NULL);

-- ----------------------------
-- Table structure for act_ru_deadletter_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_deadletter_job`;
CREATE TABLE `act_ru_deadletter_job`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_FK_DEADLETTER_JOB_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
  INDEX `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_`) USING BTREE,
  INDEX `ACT_FK_DEADLETTER_JOB_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
  INDEX `ACT_FK_DEADLETTER_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_deadletter_job
-- ----------------------------

-- ----------------------------
-- Table structure for act_ru_event_subscr
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_event_subscr`;
CREATE TABLE `act_ru_event_subscr`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `EVENT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EVENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ACTIVITY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_EVENT_SUBSCR_CONFIG_`(`CONFIGURATION_`) USING BTREE,
  INDEX `ACT_FK_EVENT_EXEC`(`EXECUTION_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PARENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `SUPER_EXEC_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `IS_ACTIVE_` tinyint(0) NULL DEFAULT NULL,
  `IS_CONCURRENT_` tinyint(0) NULL DEFAULT NULL,
  `IS_SCOPE_` tinyint(0) NULL DEFAULT NULL,
  `IS_EVENT_SCOPE_` tinyint(0) NULL DEFAULT NULL,
  `IS_MI_ROOT_` tinyint(0) NULL DEFAULT NULL,
  `SUSPENSION_STATE_` int(0) NULL DEFAULT NULL,
  `CACHED_ENT_STATE_` int(0) NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `START_TIME_` datetime(3) NULL DEFAULT NULL,
  `START_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_COUNT_ENABLED_` tinyint(0) NULL DEFAULT NULL,
  `EVT_SUBSCR_COUNT_` int(0) NULL DEFAULT NULL,
  `TASK_COUNT_` int(0) NULL DEFAULT NULL,
  `JOB_COUNT_` int(0) NULL DEFAULT NULL,
  `TIMER_JOB_COUNT_` int(0) NULL DEFAULT NULL,
  `SUSP_JOB_COUNT_` int(0) NULL DEFAULT NULL,
  `DEADLETTER_JOB_COUNT_` int(0) NULL DEFAULT NULL,
  `VAR_COUNT_` int(0) NULL DEFAULT NULL,
  `ID_LINK_COUNT_` int(0) NULL DEFAULT NULL,
  `APP_VERSION_` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_EXEC_BUSKEY`(`BUSINESS_KEY_`) USING BTREE,
  INDEX `ACT_IDC_EXEC_ROOT`(`ROOT_PROC_INST_ID_`) USING BTREE,
  INDEX `ACT_FK_EXE_PROCINST`(`PROC_INST_ID_`) USING BTREE,
  INDEX `ACT_FK_EXE_PARENT`(`PARENT_ID_`) USING BTREE,
  INDEX `ACT_FK_EXE_SUPER`(`SUPER_EXEC_`) USING BTREE,
  INDEX `ACT_FK_EXE_PROCDEF`(`PROC_DEF_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  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_`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_execution
-- ----------------------------
INSERT INTO `act_ru_execution` VALUES ('208939f1-0c6c-11ef-9ddb-005056c00008', 1, '208939f1-0c6c-11ef-9ddb-005056c00008', '1', NULL, 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', NULL, '208939f1-0c6c-11ef-9ddb-005056c00008', NULL, 1, 0, 1, 0, 0, 1, NULL, '', NULL, '2024-05-07 20:20:01.363', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL);
INSERT INTO `act_ru_execution` VALUES ('208ae7a3-0c6c-11ef-9ddb-005056c00008', 2, '208939f1-0c6c-11ef-9ddb-005056c00008', NULL, '208939f1-0c6c-11ef-9ddb-005056c00008', 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', NULL, '208939f1-0c6c-11ef-9ddb-005056c00008', 'sid-A6440ACA-CE0C-4552-8ADE-AA75F0640112', 1, 0, 0, 0, 0, 1, NULL, '', NULL, '2024-05-07 20:20:01.375', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL);

-- ----------------------------
-- Table structure for act_ru_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_identitylink`;
CREATE TABLE `act_ru_identitylink`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_IDENT_LNK_USER`(`USER_ID_`) USING BTREE,
  INDEX `ACT_IDX_IDENT_LNK_GROUP`(`GROUP_ID_`) USING BTREE,
  INDEX `ACT_IDX_ATHRZ_PROCEDEF`(`PROC_DEF_ID_`) USING BTREE,
  INDEX `ACT_FK_TSKASS_TASK`(`TASK_ID_`) USING BTREE,
  INDEX `ACT_FK_IDL_PROCINST`(`PROC_INST_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_identitylink
-- ----------------------------
INSERT INTO `act_ru_identitylink` VALUES ('208f7b88-0c6c-11ef-9ddb-005056c00008', 1, NULL, 'participant', 'zhangsan', NULL, '208939f1-0c6c-11ef-9ddb-005056c00008', NULL);
INSERT INTO `act_ru_identitylink` VALUES ('fd210ebf-0c7a-11ef-b029-005056c00008', 1, NULL, 'participant', 'lisi', NULL, '208939f1-0c6c-11ef-9ddb-005056c00008', NULL);

-- ----------------------------
-- Table structure for act_ru_integration
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_integration`;
CREATE TABLE `act_ru_integration`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `FLOW_NODE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CREATED_DATE_` timestamp(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_FK_INT_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
  INDEX `ACT_FK_INT_PROC_INST`(`PROCESS_INSTANCE_ID_`) USING BTREE,
  INDEX `ACT_FK_INT_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_INT_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_INT_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_INT_PROC_INST` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_integration
-- ----------------------------

-- ----------------------------
-- Table structure for act_ru_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_job`;
CREATE TABLE `act_ru_job`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `RETRIES_` int(0) NULL DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_FK_JOB_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
  INDEX `ACT_FK_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_`) USING BTREE,
  INDEX `ACT_FK_JOB_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
  INDEX `ACT_FK_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_job
-- ----------------------------

-- ----------------------------
-- Table structure for act_ru_suspended_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_suspended_job`;
CREATE TABLE `act_ru_suspended_job`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `RETRIES_` int(0) NULL DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_FK_SUSPENDED_JOB_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
  INDEX `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_`) USING BTREE,
  INDEX `ACT_FK_SUSPENDED_JOB_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
  INDEX `ACT_FK_SUSPENDED_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_suspended_job
-- ----------------------------

-- ----------------------------
-- Table structure for act_ru_task
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_task`;
CREATE TABLE `act_ru_task`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DELEGATION_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PRIORITY_` int(0) NULL DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `DUE_DATE_` datetime(3) NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `SUSPENSION_STATE_` int(0) NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  `FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `CLAIM_TIME_` datetime(3) NULL DEFAULT NULL,
  `APP_VERSION_` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_TASK_CREATE`(`CREATE_TIME_`) USING BTREE,
  INDEX `ACT_FK_TASK_EXE`(`EXECUTION_ID_`) USING BTREE,
  INDEX `ACT_FK_TASK_PROCINST`(`PROC_INST_ID_`) USING BTREE,
  INDEX `ACT_FK_TASK_PROCDEF`(`PROC_DEF_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_task
-- ----------------------------
INSERT INTO `act_ru_task` VALUES ('fd1faf2d-0c7a-11ef-b029-005056c00008', 1, '208ae7a3-0c6c-11ef-9ddb-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', 'leave_apply:2:36c39850-0c5b-11ef-b8fa-005056c00008', '李四审批', '1', NULL, NULL, 'sid-A6440ACA-CE0C-4552-8ADE-AA75F0640112', NULL, 'lisi', NULL, 50, '2024-05-07 22:06:24.386', NULL, NULL, 1, '', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for act_ru_timer_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_timer_job`;
CREATE TABLE `act_ru_timer_job`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `RETRIES_` int(0) NULL DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_FK_TIMER_JOB_EXECUTION`(`EXECUTION_ID_`) USING BTREE,
  INDEX `ACT_FK_TIMER_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_`) USING BTREE,
  INDEX `ACT_FK_TIMER_JOB_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,
  INDEX `ACT_FK_TIMER_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_timer_job
-- ----------------------------

-- ----------------------------
-- Table structure for act_ru_variable
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_variable`;
CREATE TABLE `act_ru_variable`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(0) NULL DEFAULT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DOUBLE_` double NULL DEFAULT NULL,
  `LONG_` bigint(0) NULL DEFAULT NULL,
  `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  INDEX `ACT_IDX_VARIABLE_TASK_ID`(`TASK_ID_`) USING BTREE,
  INDEX `ACT_FK_VAR_EXE`(`EXECUTION_ID_`) USING BTREE,
  INDEX `ACT_FK_VAR_PROCINST`(`PROC_INST_ID_`) USING BTREE,
  INDEX `ACT_FK_VAR_BYTEARRAY`(`BYTEARRAY_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of act_ru_variable
-- ----------------------------
INSERT INTO `act_ru_variable` VALUES ('208a7272-0c6c-11ef-9ddb-005056c00008', 2, 'json', 'data', '208939f1-0c6c-11ef-9ddb-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', NULL, NULL, NULL, NULL, '{\"Fo571osljo96p6\":\"单独\",\"F1sp62uyd6opj\":\"2\",\"Fk161osljo2nic\":\"2024-05-01\",\"F3z01osljo5dcn\":\"2024-05-02\"}', 'java.util.LinkedHashMap');
INSERT INTO `act_ru_variable` VALUES ('fd20727e-0c7a-11ef-b029-005056c00008', 1, 'json', 'data', '208ae7a3-0c6c-11ef-9ddb-005056c00008', '208939f1-0c6c-11ef-9ddb-005056c00008', 'fd1faf2d-0c7a-11ef-b029-005056c00008', NULL, NULL, NULL, '{\"Fo571osljo96p6\":\"单独\",\"F1sp62uyd6opj\":\"2\",\"Fk161osljo2nic\":\"2024-05-01\",\"F3z01osljo5dcn\":\"2024-05-02\"}', 'java.util.LinkedHashMap');

-- ----------------------------
-- Table structure for oa_process
-- ----------------------------
DROP TABLE IF EXISTS `oa_process`;
CREATE TABLE `oa_process`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `process_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '审批code',
  `user_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '用户id',
  `process_template_id` bigint(0) NULL DEFAULT NULL COMMENT '审批模板id',
  `process_type_id` bigint(0) NULL DEFAULT NULL COMMENT '审批类型id',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `form_values` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '表单值',
  `process_instance_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例id',
  `current_auditor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前审批人',
  `status` tinyint(0) NULL DEFAULT NULL COMMENT '状态（0：默认 1：审批中 2：审批通过 -1：驳回）',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '审批类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oa_process
-- ----------------------------
INSERT INTO `oa_process` VALUES (1, '1715084400829', 1, 5, 2, 'admin发起请假申请最新测试申请', '等待[李四]审批', '{\"formData\":{\"F1sp62uyd6opj\":\"2\",\"Fk161osljo2nic\":\"2024-05-01\",\"F3z01osljo5dcn\":\"2024-05-02\",\"Fo571osljo96p6\":\"单独\"},\"formShowData\":{\"天数\":\"2\",\"开始日期\":\"2024-05-01\",\"结束日期\":\"2024-05-02\",\"请假理由\":\"单独\"}}', '208939f1-0c6c-11ef-9ddb-005056c00008', NULL, 1, '2024-05-07 20:20:00', '2024-05-07 20:20:01', 0);

-- ----------------------------
-- Table structure for oa_process_record
-- ----------------------------
DROP TABLE IF EXISTS `oa_process_record`;
CREATE TABLE `oa_process_record`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `process_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '审批流程id',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批描述',
  `status` tinyint(0) NULL DEFAULT 0 COMMENT '状态',
  `operate_user_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '操作用户id',
  `operate_user` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '审批记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oa_process_record
-- ----------------------------
INSERT INTO `oa_process_record` VALUES (1, 1, '发起申请', 1, 1, 'admin', '2024-05-07 20:20:01', '2024-05-07 20:20:01', 0);
INSERT INTO `oa_process_record` VALUES (2, 1, '通过', 1, 1, 'zhangsan', '2024-05-07 22:06:24', '2024-05-08 19:51:25', 0);

-- ----------------------------
-- Table structure for oa_process_template
-- ----------------------------
DROP TABLE IF EXISTS `oa_process_template`;
CREATE TABLE `oa_process_template`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名称',
  `icon_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标路径',
  `process_type_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `form_props` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '表单属性',
  `form_options` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '表单选项',
  `process_definition_key` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义key',
  `process_definition_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义上传路径',
  `process_model_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义模型id',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `status` tinyint(0) NOT NULL DEFAULT 0,
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '审批模板' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oa_process_template
-- ----------------------------
INSERT INTO `oa_process_template` VALUES (1, '加班', 'https://gw.alicdn.com/tfs/TB1bHOWCSzqK1RjSZFjXXblCFXa-112-112.png', '1', '[{\"type\":\"datePicker\",\"field\":\"sdate\",\"title\":\"开始时间\",\"info\":\"\",\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"datePicker\",\"field\":\"edate\",\"title\":\"结束时间\",\"info\":\"\",\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"input\",\"field\":\"day\",\"title\":\"加班天数\",\"info\":\"\",\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"input\",\"field\":\"reason\",\"title\":\"加班原因\",\"info\":\"\",\"props\":{\"type\":\"textarea\",\"rows\":4},\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"select\",\"field\":\"dept\",\"title\":\"所属部门\",\"info\":\"\",\"effect\":{\"fetch\":\"\"},\"options\":[{\"value\":\"技术部\",\"label\":\"技术部\"},{\"value\":\"产品部\",\"label\":\"产品部\"},{\"label\":\"市场部\",\"value\":\"市场部\"},{\"label\":\"人事部\",\"value\":\"人事部\"}],\"_fc_drag_tag\":\"select\",\"hidden\":false,\"display\":true}]', '{\n    \"form\": {\n        \"labelPosition\": \"right\",\n        \"size\": \"medium\",\n        \"labelWidth\": \"80px\",\n        \"hideRequiredAsterisk\": false,\n        \"showMessage\": true,\n        \"inlineMessage\": false\n    },\n    \"submitBtn\": {\n                         \"innerText\":\"提交审批 \",\n                        \"round\":true,\n                        \"width\": \"280px\",\n                        \"type\":\"primary\"\n                     },\n    \"resetBtn\": false\n}\n', 'jiaban', '', '', '加班', 1, '2022-12-07 14:33:51', '2022-12-27 09:12:58', 0);
INSERT INTO `oa_process_template` VALUES (2, '请假', 'https://gw.alicdn.com/imgextra/i3/O1CN01LLn0YV1LhBXs7T2iO_!!6000000001330-2-tps-120-120.png', '2', '[{\"type\":\"datePicker\",\"field\":\"sdate\",\"title\":\"开始时间\",\"info\":\"\",\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"datePicker\",\"field\":\"edate\",\"title\":\"结束时间\",\"info\":\"\",\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"input\",\"field\":\"day\",\"title\":\"请假天数\",\"info\":\"\",\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"input\",\"field\":\"reason\",\"title\":\"请假原因\",\"info\":\"\",\"props\":{\"type\":\"textarea\",\"rows\":4},\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"select\",\"field\":\"dept\",\"title\":\"所属部门\",\"info\":\"\",\"effect\":{\"fetch\":\"\"},\"options\":[{\"value\":\"技术部\",\"label\":\"技术部\"},{\"value\":\"产品部\",\"label\":\"产品部\"},{\"label\":\"市场部\",\"value\":\"市场部\"},{\"label\":\"人事部\",\"value\":\"人事部\"}],\"_fc_drag_tag\":\"select\",\"hidden\":false,\"display\":true}]', '{\n    \"form\": {\n        \"labelPosition\": \"right\",\n        \"size\": \"medium\",\n        \"labelWidth\": \"80px\",\n        \"hideRequiredAsterisk\": false,\n        \"showMessage\": true,\n        \"inlineMessage\": false\n    },\n    \"submitBtn\": {\n                         \"innerText\":\"提交审批 \",\n                        \"round\":true,\n                        \"width\": \"280px\",\n                        \"type\":\"primary\"\n                     },\n    \"resetBtn\": false\n}\n', 'qingjia', '', '', '请假', 1, '2022-12-07 15:04:02', '2022-12-27 09:13:00', 0);
INSERT INTO `oa_process_template` VALUES (3, '申请费用', 'https://gw.alicdn.com/tfs/TB1e76lCOLaK1RjSZFxXXamPFXa-112-112.png', '3', '[{\"type\":\"datePicker\",\"field\":\"sdate\",\"title\":\"使用时间\",\"info\":\"\",\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}],\"props\":{\"format\":\"\"}},{\"type\":\"input\",\"field\":\"amount\",\"title\":\"申请金额\",\"info\":\"\",\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"select\",\"field\":\"F0ma1n7tec860p\",\"title\":\"费用类别\",\"info\":\"\",\"effect\":{\"fetch\":\"\"},\"options\":[{\"value\":\"房租费\",\"label\":\"房租费\"},{\"value\":\"水费\",\"label\":\"水费\"},{\"label\":\"电费\",\"value\":\"电费\"},{\"label\":\"网络费\",\"value\":\"网络费\"},{\"label\":\"火车票\",\"value\":\"火车票\"},{\"label\":\"飞机票\",\"value\":\"飞机票\"},{\"label\":\"部门团建费\",\"value\":\"部门团建费\"}],\"_fc_drag_tag\":\"select\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"input\",\"field\":\"reason\",\"title\":\"其他补充\",\"info\":\"\",\"props\":{\"type\":\"textarea\",\"rows\":4},\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true},{\"type\":\"select\",\"field\":\"dept\",\"title\":\"所属部门\",\"info\":\"\",\"effect\":{\"fetch\":\"\"},\"options\":[{\"value\":\"技术部\",\"label\":\"技术部\"},{\"value\":\"产品部\",\"label\":\"产品部\"},{\"label\":\"市场部\",\"value\":\"市场部\"},{\"label\":\"人事部\",\"value\":\"人事部\"}],\"_fc_drag_tag\":\"select\",\"hidden\":false,\"display\":true},{\"type\":\"input\",\"field\":\"content\",\"title\":\"申请事由\",\"info\":\"\",\"props\":{\"type\":\"textarea\",\"rows\":4},\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true,\"validate\":[{\"trigger\":\"change\",\"mode\":\"required\",\"message\":\"必须输入\",\"required\":true,\"type\":\"string\"}]},{\"type\":\"switch\",\"field\":\"F9hn1n7twlkcfk\",\"title\":\"消息提示\",\"info\":\"\",\"_fc_drag_tag\":\"switch\",\"hidden\":false,\"display\":true},{\"type\":\"span\",\"title\":\"注意\",\"native\":false,\"children\":[\"有疑问call13930895264！\"],\"_fc_drag_tag\":\"span\",\"hidden\":false,\"display\":true}]', ' ', 'feiyong', '', '', '申请费用', 0, '2022-12-08 10:35:33', '2024-05-07 13:01:17', 0);
INSERT INTO `oa_process_template` VALUES (4, '测试请假', 'https://gw.alicdn.com/tfs/TB1bHOWCSzqK1RjSZFjXXblCFXa-112-112.png', '2', '[{\"type\":\"input\",\"field\":\"Fmus62uhxo9r3\",\"title\":\"请假理由\",\"info\":\"\",\"$required\":false,\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true},{\"type\":\"datePicker\",\"field\":\"Fho962uhxuv2i\",\"title\":\"开始日期\",\"info\":\"\",\"$required\":false,\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true},{\"type\":\"datePicker\",\"field\":\"Fe6q62uhxv7u1\",\"title\":\"结束日期\",\"info\":\"\",\"$required\":false,\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true},{\"type\":\"input\",\"field\":\"F9j51osgzg113a\",\"title\":\"请假天数\",\"info\":\"\",\"$required\":false,\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true}]', '{\"form\":{\"labelPosition\":\"right\",\"size\":\"mini\",\"labelWidth\":\"125px\",\"hideRequiredAsterisk\":false,\"showMessage\":true,\"inlineMessage\":false},\"submitBtn\":true,\"resetBtn\":false}', 'leave_apply1', 'processes/leave_apply1.zip', NULL, '测试请假流程', 0, '2024-05-06 14:45:14', '2024-05-07 18:18:19', 0);
INSERT INTO `oa_process_template` VALUES (5, '请假申请最新测试', 'https://gw.alicdn.com/tfs/TB1bHOWCSzqK1RjSZFjXXblCFXa-112-112.png', '2', '[{\"type\":\"input\",\"field\":\"F1sp62uyd6opj\",\"title\":\"天数\",\"info\":\"\",\"$required\":false,\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true},{\"type\":\"datePicker\",\"field\":\"Fk161osljo2nic\",\"title\":\"开始日期\",\"info\":\"\",\"$required\":false,\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true},{\"type\":\"datePicker\",\"field\":\"F3z01osljo5dcn\",\"title\":\"结束日期\",\"info\":\"\",\"$required\":false,\"_fc_drag_tag\":\"datePicker\",\"hidden\":false,\"display\":true},{\"type\":\"input\",\"field\":\"Fo571osljo96p6\",\"title\":\"请假理由\",\"info\":\"\",\"$required\":false,\"_fc_drag_tag\":\"input\",\"hidden\":false,\"display\":true}]', '{\"form\":{\"labelPosition\":\"right\",\"size\":\"mini\",\"labelWidth\":\"125px\",\"hideRequiredAsterisk\":false,\"showMessage\":true,\"inlineMessage\":false},\"submitBtn\":true,\"resetBtn\":false}', 'leave_apply', 'processes/leave_apply.zip', NULL, '请假申请最新测试', 1, '2024-05-07 18:16:54', '2024-05-07 18:18:07', 0);

-- ----------------------------
-- Table structure for oa_process_type
-- ----------------------------
DROP TABLE IF EXISTS `oa_process_type`;
CREATE TABLE `oa_process_type`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型名称',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '审批类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oa_process_type
-- ----------------------------
INSERT INTO `oa_process_type` VALUES (1, '出勤', '出勤', '2022-12-06 09:35:12', '2022-12-06 09:36:13', 0);
INSERT INTO `oa_process_type` VALUES (2, '人事', '人事', '2022-12-06 09:35:19', '2022-12-06 09:36:16', 0);
INSERT INTO `oa_process_type` VALUES (3, '财务', '财务', '2022-12-06 09:35:29', '2022-12-06 09:36:17', 0);

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `parent_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '所属上级',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `type` tinyint(0) NOT NULL DEFAULT 0 COMMENT '类型(0:目录,1:菜单,2:按钮)',
  `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由地址',
  `component` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组件路径',
  `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图标',
  `sort_value` int(0) NULL DEFAULT NULL COMMENT '排序',
  `status` tinyint(0) NULL DEFAULT NULL COMMENT '状态(0:禁止,1:正常)',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_parent_id`(`parent_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (2, 0, '系统管理', 0, 'system', 'Layout', NULL, 'el-icon-s-tools', 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:23:24', 0);
INSERT INTO `sys_menu` VALUES (3, 2, '用户管理', 1, 'sysUser', 'system/sysUser/list', '', 'el-icon-s-custom', 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:47', 0);
INSERT INTO `sys_menu` VALUES (4, 2, '角色管理', 1, 'sysRole', 'system/sysRole/list', '', 'el-icon-user-solid', 2, 1, '2021-05-31 18:05:37', '2022-06-09 09:37:18', 0);
INSERT INTO `sys_menu` VALUES (5, 2, '菜单管理', 1, 'sysMenu', 'system/sysMenu/list', '', 'el-icon-s-unfold', 3, 1, '2021-05-31 18:05:37', '2022-06-09 09:37:21', 0);
INSERT INTO `sys_menu` VALUES (6, 3, '查看', 2, NULL, NULL, 'bnt.sysUser.list', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (7, 3, '添加', 2, NULL, NULL, 'bnt.sysUser.add', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (8, 3, '修改', 2, NULL, NULL, 'bnt.sysUser.update', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (9, 3, '删除', 2, NULL, NULL, 'bnt.sysUser.remove', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (10, 4, '查看', 2, NULL, NULL, 'bnt.sysRole.list', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (11, 4, '添加', 2, NULL, NULL, 'bnt.sysRole.add', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (12, 4, '修改', 2, NULL, NULL, 'bnt.sysRole.update', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (13, 4, '删除', 2, NULL, NULL, 'bnt.sysRole.remove', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (14, 5, '查看', 2, NULL, NULL, 'bnt.sysMenu.list', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (15, 5, '添加', 2, NULL, NULL, 'bnt.sysMenu.add', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (16, 5, '修改', 2, NULL, NULL, 'bnt.sysMenu.update', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (17, 5, '删除', 2, NULL, NULL, 'bnt.sysMenu.remove', NULL, 1, 1, '2021-05-31 18:05:37', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (18, 3, '分配角色', 2, NULL, NULL, 'bnt.sysUser.assignRole', NULL, 1, 1, '2022-05-23 17:14:32', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (19, 4, '分配权限', 2, 'assignAuth', 'system/sysRole/assignAuth', 'bnt.sysRole.assignAuth', NULL, 1, 1, '2022-05-23 17:18:14', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (20, 2, '部门管理', 1, 'sysDept', 'system/sysDept/list', '', 'el-icon-s-operation', 4, 1, '2022-05-24 10:07:05', '2022-06-09 09:38:12', 0);
INSERT INTO `sys_menu` VALUES (21, 20, '查看', 2, NULL, NULL, 'bnt.sysDept.list', NULL, 1, 1, '2022-05-24 10:07:44', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (22, 2, '岗位管理', 1, 'sysPost', 'system/sysPost/list', '', 'el-icon-more-outline', 5, 1, '2022-05-24 10:25:30', '2022-06-09 09:38:13', 0);
INSERT INTO `sys_menu` VALUES (23, 22, '查看', 2, NULL, NULL, 'bnt.sysPost.list', NULL, 1, 1, '2022-05-24 10:25:45', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (24, 20, '添加', 2, NULL, NULL, 'bnt.sysDept.add', NULL, 1, 1, '2022-05-25 15:31:27', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (25, 20, '修改', 2, NULL, NULL, 'bnt.sysDept.update', NULL, 1, 1, '2022-05-25 15:31:41', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (26, 20, '删除', 2, NULL, NULL, 'bnt.sysDept.remove', NULL, 1, 1, '2022-05-25 15:31:59', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (27, 22, '添加', 2, NULL, NULL, 'bnt.sysPost.add', NULL, 1, 1, '2022-05-25 15:32:44', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (28, 22, '修改', 2, NULL, NULL, 'bnt.sysPost.update', NULL, 1, 1, '2022-05-25 15:32:58', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (29, 22, '删除', 2, NULL, NULL, 'bnt.sysPost.remove', NULL, 1, 1, '2022-05-25 15:33:11', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (30, 34, '操作日志', 1, 'sysOperLog', 'system/sysOperLog/list', '', 'el-icon-document-remove', 7, 1, '2022-05-26 16:09:59', '2022-06-09 09:39:23', 0);
INSERT INTO `sys_menu` VALUES (31, 30, '查看', 2, NULL, NULL, 'bnt.sysOperLog.list', NULL, 1, 1, '2022-05-26 16:10:17', '2022-06-09 09:22:38', 0);
INSERT INTO `sys_menu` VALUES (32, 34, '登录日志', 1, 'sysLoginLog', 'system/sysLoginLog/list', '', 'el-icon-s-goods', 8, 1, '2022-05-26 16:36:13', '2022-06-09 09:39:24', 0);
INSERT INTO `sys_menu` VALUES (33, 32, '查看', 2, NULL, NULL, 'bnt.sysLoginLog.list', NULL, 1, 1, '2022-05-26 16:36:31', '2022-06-09 09:36:36', 0);
INSERT INTO `sys_menu` VALUES (34, 2, '日志管理', 0, 'log', 'ParentView', '', 'el-icon-tickets', 6, 1, '2022-05-31 13:23:07', '2022-06-09 09:39:22', 0);
INSERT INTO `sys_menu` VALUES (35, 0, '审批设置', 0, 'processSet', 'Layout', '', 'el-icon-setting', 1, 1, '2022-12-01 09:32:46', '2022-12-01 09:32:46', 0);
INSERT INTO `sys_menu` VALUES (36, 35, '审批模板', 1, 'processTemplate', 'processSet/processTemplate/list', '', 'el-icon-s-help', 2, 1, '2022-12-01 09:37:08', '2022-12-19 14:10:48', 0);
INSERT INTO `sys_menu` VALUES (37, 36, '查看', 2, '', '', 'bnt.processTemplate.list', '', 1, 1, '2022-12-01 09:37:49', '2022-12-01 09:37:49', 0);
INSERT INTO `sys_menu` VALUES (38, 36, '审批模板设置', 2, 'templateSet', 'processSet/processTemplate/templateSet', 'bnt.processTemplate.templateSet', '', 1, 1, '2022-12-01 14:52:08', '2022-12-13 18:11:56', 0);
INSERT INTO `sys_menu` VALUES (39, 35, '审批类型', 1, 'processType', 'processSet/processType/list', '', 'el-icon-s-unfold', 1, 1, '2022-12-02 14:46:18', '2022-12-13 18:12:24', 0);
INSERT INTO `sys_menu` VALUES (40, 39, '查看', 2, '', '', 'bnt.processType.list', '', 1, 1, '2022-12-02 14:46:41', '2022-12-02 14:46:41', 0);
INSERT INTO `sys_menu` VALUES (41, 0, '审批管理', 0, 'processMgr', 'Layout', '', 'el-icon-more-outline', 1, 1, '2022-12-02 14:48:11', '2022-12-20 09:29:30', 0);
INSERT INTO `sys_menu` VALUES (42, 41, '审批列表', 1, 'process', 'processMgr/process/list', '', 'el-icon-document-remove', 1, 1, '2022-12-02 14:49:06', '2022-12-02 14:59:17', 0);
INSERT INTO `sys_menu` VALUES (43, 42, '查看', 2, '', '', 'bnt.process.list', '', 1, 1, '2022-12-02 14:49:24', '2022-12-02 14:49:24', 0);
INSERT INTO `sys_menu` VALUES (44, 36, '在线流程设置', 2, 'onlineProcessSet', 'processSet/processTemplate/onlineProcessSet', 'bnt.processTemplate.onlineProcessSet', '', 1, 1, '2022-12-08 10:13:15', '2022-12-19 18:57:35', 0);
INSERT INTO `sys_menu` VALUES (45, 39, '添加', 2, '', '', 'bnt.processType.add', '', 1, 1, '2022-12-09 09:14:53', '2022-12-09 09:14:53', 0);
INSERT INTO `sys_menu` VALUES (46, 39, '修改', 2, '', '', 'bnt.processType.update', '', 1, 1, '2022-12-09 09:15:10', '2022-12-09 09:15:10', 0);
INSERT INTO `sys_menu` VALUES (47, 39, '删除', 2, '', '', 'bnt.processType.remove', '', 1, 1, '2022-12-09 09:15:25', '2022-12-09 09:15:25', 0);
INSERT INTO `sys_menu` VALUES (48, 36, '删除', 2, '', '', 'bnt.processTemplate.remove', '', 1, 1, '2022-12-09 09:22:29', '2022-12-09 09:22:29', 0);
INSERT INTO `sys_menu` VALUES (49, 36, '发布', 2, '', '', 'bnt.processTemplate.publish', '', 1, 1, '2022-12-09 09:24:47', '2022-12-09 09:24:47', 0);
INSERT INTO `sys_menu` VALUES (50, 0, '公众号菜单', 0, 'wechat', 'Layout', '', 'el-icon-s-operation', 1, 1, '2022-12-13 09:06:58', '2022-12-21 11:20:55', 0);
INSERT INTO `sys_menu` VALUES (51, 50, '菜单列表', 1, 'menu', 'wechat/menu/list', '', 'el-icon-s-help', 1, 1, '2022-12-13 09:07:52', '2022-12-13 09:09:49', 0);
INSERT INTO `sys_menu` VALUES (52, 51, '查看', 2, '', '', 'bnt.menu.list', '', 1, 1, '2022-12-13 09:08:48', '2022-12-13 17:58:23', 0);
INSERT INTO `sys_menu` VALUES (53, 51, '添加', 2, '', '', 'bnt.menu.add', '', 1, 1, '2022-12-13 16:29:25', '2022-12-13 17:58:34', 0);
INSERT INTO `sys_menu` VALUES (54, 51, '修改', 2, '', '', 'bnt.menu.update', '', 1, 1, '2022-12-13 16:29:41', '2022-12-13 17:58:42', 0);
INSERT INTO `sys_menu` VALUES (55, 51, '删除', 2, '', '', 'bnt.menu.remove', '', 1, 1, '2022-12-13 16:29:59', '2022-12-13 17:58:47', 0);
INSERT INTO `sys_menu` VALUES (56, 51, '删除微信菜单', 2, '', '', 'bnt.menu.removeMenu', '', 1, 1, '2022-12-13 16:30:36', '2022-12-13 17:58:54', 0);
INSERT INTO `sys_menu` VALUES (57, 51, '同步微信菜单', 2, '', '', 'bnt.menu.syncMenu', '', 1, 1, '2022-12-13 16:31:00', '2022-12-13 17:59:01', 0);
INSERT INTO `sys_menu` VALUES (58, 0, 'ttt', 0, 'ttt', 'Layout', '', '', 1, 1, '2024-05-04 13:02:56', '2024-05-04 13:03:26', 1);
INSERT INTO `sys_menu` VALUES (59, 58, 'ere111', 1, 'wee', 'wee', '', '', 1, 1, '2024-05-04 13:03:10', '2024-05-04 13:03:22', 1);

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `role_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `role_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色编码',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '角色管理员', 'role', '角色管理员1', '2024-05-02 11:15:13', '2024-05-02 11:15:13', 0);
INSERT INTO `sys_role` VALUES (2, '角色管理员2', 'role2', '角色管理员2', '2024-05-02 11:15:37', '2024-05-02 11:15:37', 0);
INSERT INTO `sys_role` VALUES (3, 'aa', 'dd', NULL, '2024-05-03 16:53:32', '2024-05-03 20:03:37', 0);
INSERT INTO `sys_role` VALUES (4, 'test01', 'test', NULL, '2024-05-03 19:19:02', '2024-05-03 20:04:18', 1);
INSERT INTO `sys_role` VALUES (5, 'dd', 'rr', NULL, '2024-05-03 20:03:58', '2024-05-03 20:04:18', 1);

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(0) NOT NULL DEFAULT 0,
  `menu_id` bigint(0) NOT NULL DEFAULT 0,
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_role_id`(`role_id`) USING BTREE,
  INDEX `idx_menu_id`(`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 52 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (1, 1, 2, '2024-05-04 14:36:43', '2024-05-04 14:37:07', 1);
INSERT INTO `sys_role_menu` VALUES (2, 1, 3, '2024-05-04 14:36:43', '2024-05-04 14:37:07', 1);
INSERT INTO `sys_role_menu` VALUES (3, 1, 6, '2024-05-04 14:36:43', '2024-05-04 14:37:07', 1);
INSERT INTO `sys_role_menu` VALUES (4, 1, 7, '2024-05-04 14:36:43', '2024-05-04 14:37:07', 1);
INSERT INTO `sys_role_menu` VALUES (5, 1, 8, '2024-05-04 14:36:43', '2024-05-04 14:37:07', 1);
INSERT INTO `sys_role_menu` VALUES (6, 1, 2, '2024-05-04 14:37:07', '2024-05-04 19:14:56', 1);
INSERT INTO `sys_role_menu` VALUES (7, 1, 4, '2024-05-04 14:37:07', '2024-05-04 19:14:56', 1);
INSERT INTO `sys_role_menu` VALUES (8, 1, 10, '2024-05-04 14:37:07', '2024-05-04 19:14:56', 1);
INSERT INTO `sys_role_menu` VALUES (9, 1, 11, '2024-05-04 14:37:07', '2024-05-04 19:14:56', 1);
INSERT INTO `sys_role_menu` VALUES (10, 1, 12, '2024-05-04 14:37:07', '2024-05-04 19:14:56', 1);
INSERT INTO `sys_role_menu` VALUES (11, 1, 13, '2024-05-04 14:37:07', '2024-05-04 19:14:56', 1);
INSERT INTO `sys_role_menu` VALUES (12, 1, 19, '2024-05-04 14:37:07', '2024-05-04 19:14:56', 1);
INSERT INTO `sys_role_menu` VALUES (13, 1, 2, '2024-05-04 19:14:56', '2024-05-05 10:36:13', 1);
INSERT INTO `sys_role_menu` VALUES (14, 1, 4, '2024-05-04 19:14:56', '2024-05-05 10:36:13', 1);
INSERT INTO `sys_role_menu` VALUES (15, 1, 10, '2024-05-04 19:14:56', '2024-05-05 10:36:13', 1);
INSERT INTO `sys_role_menu` VALUES (16, 1, 12, '2024-05-04 19:14:56', '2024-05-05 10:36:13', 1);
INSERT INTO `sys_role_menu` VALUES (17, 1, 13, '2024-05-04 19:14:56', '2024-05-05 10:36:13', 1);
INSERT INTO `sys_role_menu` VALUES (18, 1, 19, '2024-05-04 19:14:56', '2024-05-05 10:36:13', 1);
INSERT INTO `sys_role_menu` VALUES (19, 1, 2, '2024-05-05 10:36:13', '2024-05-07 19:06:19', 1);
INSERT INTO `sys_role_menu` VALUES (20, 1, 4, '2024-05-05 10:36:13', '2024-05-07 19:06:19', 1);
INSERT INTO `sys_role_menu` VALUES (21, 1, 10, '2024-05-05 10:36:13', '2024-05-07 19:06:19', 1);
INSERT INTO `sys_role_menu` VALUES (22, 1, 11, '2024-05-05 10:36:13', '2024-05-07 19:06:19', 1);
INSERT INTO `sys_role_menu` VALUES (23, 1, 12, '2024-05-05 10:36:13', '2024-05-07 19:06:19', 1);
INSERT INTO `sys_role_menu` VALUES (24, 1, 19, '2024-05-05 10:36:13', '2024-05-07 19:06:19', 1);
INSERT INTO `sys_role_menu` VALUES (25, 1, 2, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (26, 1, 3, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (27, 1, 6, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (28, 1, 7, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (29, 1, 8, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (30, 1, 9, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (31, 1, 18, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (32, 1, 4, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (33, 1, 10, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (34, 1, 11, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (35, 1, 12, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (36, 1, 19, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (37, 1, 35, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (38, 1, 36, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (39, 1, 37, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (40, 1, 38, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (41, 1, 44, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (42, 1, 48, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (43, 1, 49, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (44, 1, 39, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (45, 1, 40, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (46, 1, 45, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (47, 1, 46, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (48, 1, 47, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (49, 1, 41, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (50, 1, 42, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);
INSERT INTO `sys_role_menu` VALUES (51, 1, 43, '2024-05-07 19:06:19', '2024-05-07 19:06:19', 0);

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '会员id',
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '密码',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机',
  `head_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像地址',
  `dept_id` bigint(0) NULL DEFAULT NULL COMMENT '部门id',
  `post_id` bigint(0) NULL DEFAULT NULL COMMENT '岗位id',
  `open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信openId',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',
  `status` tinyint(0) NULL DEFAULT NULL COMMENT '状态（1：正常 0：停用）',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', '96e79218965eb72c92a549dd5a330112', 'admin', '15000000000', 'http://r61cnlsfq.hn-bkt.clouddn.com/7daa4595-dfde-45da-8513-c5c2b81d20cc', 1022, NULL, '', NULL, 1, '2021-05-31 18:08:43', '2022-12-13 14:52:31', 0);
INSERT INTO `sys_user` VALUES (2, 'wjl', '96e79218965eb72c92a549dd5a330112', '王经理', '15000000002', 'http://r61cnlsfq.hn-bkt.clouddn.com/b09b3467-3d99-437a-bd2e-dd8c9be92bb8', 1022, 6, '', NULL, 1, '2022-02-08 10:35:38', '2022-12-22 10:05:03', 0);
INSERT INTO `sys_user` VALUES (3, 'lrsjl', '96e79218965eb72c92a549dd5a330112', '李人事经理', '15000000004', NULL, 2018, 5, '', NULL, 1, '2022-05-24 11:05:40', '2022-12-22 10:05:21', 0);
INSERT INTO `sys_user` VALUES (4, 'lisi', '96e79218965eb72c92a549dd5a330112', '李四', '15000000001', NULL, 1021, 10, 'omwf25izKON9dktgoy0dogqvnGhk', NULL, 1, '2022-12-06 09:32:31', '2022-12-21 09:25:06', 0);
INSERT INTO `sys_user` VALUES (5, 'zzjl', '96e79218965eb72c92a549dd5a330112', '张总经理', '15000000003', NULL, 10, 8, '', NULL, 1, '2022-12-07 16:47:00', '2022-12-22 10:05:07', 0);
INSERT INTO `sys_user` VALUES (6, 'xkfzr', '96e79218965eb72c92a549dd5a330112', '张学科', '15000000005', NULL, 1010, 11, NULL, NULL, 1, '2022-12-14 09:18:12', '2022-12-14 09:18:12', 0);
INSERT INTO `sys_user` VALUES (7, 'zhangsan', '96e79218965eb72c92a549dd5a330112', '张三', '15000000006', NULL, 1021, 10, NULL, NULL, 1, '2022-12-26 11:26:45', '2022-12-27 09:11:37', 0);
INSERT INTO `sys_user` VALUES (11, 'zhangsan01', '96e79218965eb72c92a549dd5a330112', '张三01', '15000000007', NULL, 1021, 10, NULL, NULL, 1, '2022-12-26 11:27:33', '2022-12-27 09:11:38', 0);
INSERT INTO `sys_user` VALUES (12, 'zhangsan02', '96e79218965eb72c92a549dd5a330112', '张三02', '15000000008', NULL, 1021, 10, NULL, NULL, 1, '2022-12-26 11:27:39', '2022-12-27 09:11:39', 0);
INSERT INTO `sys_user` VALUES (13, 'test01', 'e10adc3949ba59abbe56e057f20f883e', 'qqqq', '12344566', NULL, NULL, NULL, NULL, NULL, 1, '2024-05-03 22:31:48', '2024-05-03 22:31:48', 0);

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '角色id',
  `user_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '用户id',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_role_id`(`role_id`) USING BTREE,
  INDEX `idx_admin_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (1, 1, 2, '2024-05-04 08:41:53', '2024-05-04 18:22:14', 0);
INSERT INTO `sys_user_role` VALUES (2, 2, 2, '2024-05-04 08:41:53', '2024-05-04 18:22:18', 0);
INSERT INTO `sys_user_role` VALUES (3, 3, 2, '2024-05-04 08:41:53', '2024-05-04 18:22:21', 0);
INSERT INTO `sys_user_role` VALUES (4, 2, 2, '2024-05-04 08:42:40', '2024-05-04 08:42:40', 0);
INSERT INTO `sys_user_role` VALUES (5, 3, 2, '2024-05-04 08:42:40', '2024-05-04 08:42:40', 0);
INSERT INTO `sys_user_role` VALUES (6, 1, 4, '2024-05-04 19:14:33', '2024-05-07 19:06:45', 1);
INSERT INTO `sys_user_role` VALUES (7, 1, 7, '2024-05-07 19:06:39', '2024-05-07 19:06:39', 0);
INSERT INTO `sys_user_role` VALUES (8, 1, 4, '2024-05-07 19:06:45', '2024-05-07 19:06:45', 0);

-- ----------------------------
-- Table structure for wechat_menu
-- ----------------------------
DROP TABLE IF EXISTS `wechat_menu`;
CREATE TABLE `wechat_menu`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `parent_id` bigint(0) NULL DEFAULT NULL COMMENT '上级id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '网页 链接，用户点击菜单可打开链接',
  `meun_key` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单KEY值，用于消息接口推送',
  `sort` tinyint(0) NULL DEFAULT NULL COMMENT '排序',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wechat_menu
-- ----------------------------
INSERT INTO `wechat_menu` VALUES (2, 0, '审批列表', NULL, NULL, NULL, 1, '2022-12-13 09:23:30', '2022-12-13 09:29:22', 0);
INSERT INTO `wechat_menu` VALUES (3, 0, '审批中心', 'view', '/', NULL, 2, '2022-12-13 09:23:44', '2022-12-13 09:54:20', 0);
INSERT INTO `wechat_menu` VALUES (4, 0, '我的', NULL, NULL, NULL, 3, '2022-12-13 09:23:52', '2022-12-13 09:29:24', 0);
INSERT INTO `wechat_menu` VALUES (5, 2, '待处理', 'view', '/list/0', '', 1, '2022-12-13 09:19:56', '2022-12-13 09:24:10', 0);
INSERT INTO `wechat_menu` VALUES (6, 2, '已处理', 'view', '/list/1', '', 2, '2022-12-13 09:27:00', '2022-12-13 09:29:28', 0);
INSERT INTO `wechat_menu` VALUES (7, 2, '已发起', 'view', '/list/2', '', 3, '2022-12-13 09:27:30', '2022-12-13 09:29:30', 0);
INSERT INTO `wechat_menu` VALUES (8, 4, '基本信息', 'view', '/user', '', 1, '2022-12-13 09:28:47', '2022-12-13 09:28:47', 0);
INSERT INTO `wechat_menu` VALUES (9, 4, '关于我们', 'view', '/about', '', 2, '2022-12-13 09:29:08', '2022-12-13 09:29:32', 0);

SET FOREIGN_KEY_CHECKS = 1;

二、搭建环境

1、搭建后端

使用idea工具：

1.1、搭建父工程clfwzx-oa-parent

管理子模块及依赖

GroupId：com.atsurvey

ArtifactId：clfwzx-oa-parent

新建项目

在这里插入图片描述

直接下一步到完成

删除src目录。

1.2、搭建工具类父模块common

工具类父模块

第一步：右键点击“clfwzx-oa-parent”新建"module"
在这里插入图片描述

删除src目录。

1.3、搭建工具类common的子模块

工具公共类：common-util
工具服务类：service-util

第一步：右键点击“common”新建"module"

在这里插入图片描述

1.4、搭建实体类模块model和项目模块service-oa

实体类

搭建方式如：common

整体项目结构如下：

在这里插入图片描述

2、配置依赖关系

2.1、clfwzx-oa-parent父模块管理依赖版本

修改clfwzx-oa-parent模块pom.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.6.RELEASE</version>
    </parent>

    <groupId>com.atsurvey</groupId>
    <artifactId>clfwzx-oa-parent</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>pom</packaging>

    <modules>
        <module>common</module>
        <module>model</module>
        <module>service-oa</module>
    </modules>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <java.version>1.8</java.version>
        <mybatis-plus.version>3.4.1</mybatis-plus.version>
        <mysql.version>8.0.30</mysql.version>
        <knife4j.version>3.0.3</knife4j.version>
        <jwt.version>0.9.1</jwt.version>
        <fastjson.version>2.0.21</fastjson.version>
    </properties>

    <!--配置dependencyManagement锁定依赖的版本-->
    <dependencyManagement>
        <dependencies>
            <!--mybatis-plus 持久层-->
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatis-plus.version}</version>
            </dependency>
            <!--mysql-->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
            <!--knife4j-->
            <dependency>
                <groupId>com.github.xiaoymin</groupId>
                <artifactId>knife4j-spring-boot-starter</artifactId>
                <version>${knife4j.version}</version>
            </dependency>
            <!--jjwt-->
            <dependency>
                <groupId>io.jsonwebtoken</groupId>
                <artifactId>jjwt</artifactId>
                <version>${jwt.version}</version>
            </dependency>
            <!--fastjson-->
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>${fastjson.version}</version>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

2.2、common模块

common公共父模块

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <parent>
        <groupId>com.atsurvey</groupId>
        <artifactId>clfwzx-oa-parent</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>common</artifactId>
    <packaging>pom</packaging>

    <modules>
        <module>common-utils</module>
        <module>service-utils</module>
        <module>spring-security</module>
        <!--        <module>spring-security</module>-->
    </modules>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

</project>

2.3、common-util模块

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>com.atsurvey</groupId>
        <artifactId>common</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>common-utils</artifactId>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
<!--            <scope>provided </scope>-->
        </dependency>
        <dependency>
            <groupId>io.jsonwebtoken</groupId>
            <artifactId>jjwt</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
        </dependency>
<!--        <dependency>-->
<!--            <groupId>io.springfox</groupId>-->
<!--            <artifactId>springfox-swagger2</artifactId>-->
<!--            <version>2.9.2</version>-->
<!--        </dependency>-->
<!--        <dependency>-->
<!--            <groupId>io.springfox</groupId>-->
<!--            <artifactId>springfox-swagger-ui</artifactId>-->
<!--            <version>2.9.2</version>-->
<!--        </dependency>-->
    </dependencies>


</project>

2.4、service-util模块

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>com.atsurvey</groupId>
        <artifactId>common</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>service-utils</artifactId>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <dependency>
            <groupId>com.atsurvey</groupId>
            <artifactId>common-utils</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <dependency>
            <groupId>com.github.xiaoymin</groupId>
            <artifactId>knife4j-spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-security</artifactId>
            <scope>provided</scope>
        </dependency>
    </dependencies>

</project>

2.5、model模块

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>com.atsurvey</groupId>
        <artifactId>clfwzx-oa-parent</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>model</artifactId>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <!--lombok用来简化实体类-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <dependency>
            <groupId>com.github.xiaoymin</groupId>
            <artifactId>knife4j-spring-boot-starter</artifactId>
            <scope>provided </scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <scope>provided </scope>
        </dependency>
    </dependencies>

</project>

从资源文件夹中导入实体类(实体类 评论区@我)

idea中安装lombok插件，因为目前采用idea2022版本，Lombok在2020.2开始不再更新，导致高版本IDEA(2021及之后版本)无法在Plugins中搜索到Lombok插件，需要手动安装，或者也可以不安装插件，在实体类里面手动生成get、set和构造方法

到官网下载Lombok插件，https://plugins.jetbrains.com/plugin/6317-lombok/versions

修改jar包里面文件内容，可以使用压缩工具打开jar包

第三步在idea的File -> Settings -> Plugins下选中修改参数后的安装包进行安装，安装后重启idea

2.6、service-oa模块

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>com.atsurvey</groupId>
        <artifactId>clfwzx-oa-parent</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>service-oa</artifactId>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <dependency>
            <groupId>com.atsurvey</groupId>
            <artifactId>model</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>

        <dependency>
            <groupId>com.atsurvey</groupId>
            <artifactId>service-utils</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.4.1</version>
        </dependency>

        <dependency>
            <groupId>org.apache.velocity</groupId>
            <artifactId>velocity-engine-core</artifactId>
            <version>2.0</version>
        </dependency>

        <dependency>
            <groupId>com.atsurvey</groupId>
            <artifactId>spring-security</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>

        <!--引入activiti的springboot启动器 -->
        <dependency>
            <groupId>org.activiti</groupId>
            <artifactId>activiti-spring-boot-starter</artifactId>
            <version>7.1.0.M6</version>
            <exclusions>
                <exclusion>
                    <artifactId>mybatis</artifactId>
                    <groupId>org.mybatis</groupId>
                </exclusion>
            </exclusions>
        </dependency>

        <dependency>
            <groupId>com.github.binarywang</groupId>
            <artifactId>weixin-java-mp</artifactId>
            <version>4.1.0</version>
        </dependency>

<!--        <dependency>-->
<!--            <groupId>org.activiti</groupId>-->
<!--            <artifactId>activiti-modeler</artifactId>-->
<!--            <version>5.22.0</version>-->
<!--        </dependency>-->
<!--        &lt;!&ndash; Activiti生成流程图 &ndash;&gt;-->
<!--        <dependency>-->
<!--            <groupId>org.activiti</groupId>-->
<!--            <artifactId>activiti-image-generator</artifactId>-->
<!--            <version>5.22.0</version>-->
<!--        </dependency>-->


    </dependencies>

    <build>
        <finalName>${project.artifactId}</finalName>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.yml</include>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.yml</include>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                    <include>**/*.png</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>

</project>