rapid-boot
/
rapid-boot.sql

/*
 Navicat Premium Data Transfer

 Source Server         : baidu
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 106.12.156.212:3306
 Source Schema         : rapid

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

 Date: 16/09/2019 17:42:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ACT_DE_DATABASECHANGELOG
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DE_DATABASECHANGELOG`;
CREATE TABLE `ACT_DE_DATABASECHANGELOG`  (
  `ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `AUTHOR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `FILENAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `DATEEXECUTED` datetime(0) NOT NULL,
  `ORDEREXECUTED` int(11) NOT NULL,
  `EXECTYPE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `MD5SUM` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DESCRIPTION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `COMMENTS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `TAG` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `LIQUIBASE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_DE_DATABASECHANGELOG
-- ----------------------------
INSERT INTO `ACT_DE_DATABASECHANGELOG` VALUES ('1', 'activiti', 'META-INF/liquibase/activiti-app-db-changelog.xml', '2019-09-11 18:37:06', 1, 'EXECUTED', '7:670797aeab8d035a4350ea2c794a7e46', 'createTable (x3), createIndex, createTable, createIndex, createTable, createIndex (x2), createTable, createIndex (x3), createTable, addForeignKeyConstraint (x2)', '', NULL, '3.1.0');

-- ----------------------------
-- Table structure for ACT_DE_DATABASECHANGELOGLOCK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DE_DATABASECHANGELOGLOCK`;
CREATE TABLE `ACT_DE_DATABASECHANGELOGLOCK`  (
  `ID` int(11) NOT NULL,
  `LOCKED` bit(1) NOT NULL,
  `LOCKGRANTED` datetime(0) NULL DEFAULT NULL,
  `LOCKEDBY` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_DE_DATABASECHANGELOGLOCK
-- ----------------------------
INSERT INTO `ACT_DE_DATABASECHANGELOGLOCK` VALUES (1, b'0', NULL, NULL);

-- ----------------------------
-- Table structure for ACT_DE_MODEL
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DE_MODEL`;
CREATE TABLE `ACT_DE_MODEL`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `model_key` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `model_comment` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created` datetime(6) NULL DEFAULT NULL,
  `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `last_updated` datetime(6) NULL DEFAULT NULL,
  `last_updated_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT NULL,
  `model_editor_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `thumbnail` longblob NULL,
  `model_type` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_proc_mod_created`(`created_by`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_DE_MODEL
-- ----------------------------
INSERT INTO `ACT_DE_MODEL` VALUES ('9680a6d7-97ce-4425-961c-c220dc0c1f0d', '请假流程', 'leave', '定义请假流程', NULL, '2019-09-11 18:44:32.294000', 'admin', '2019-09-11 18:44:43.518000', 'admin', 2, '{\"models\":[{\"id\":\"cfcfe403-591c-46c9-afca-3ccfaa8aaecc\",\"name\":\"请假流程\",\"version\":1,\"modelType\":0,\"description\":\"定义请假流程\",\"stencilSetId\":null,\"createdBy\":\"admin\",\"lastUpdatedBy\":\"admin\",\"lastUpdated\":\"2019-09-11T10:43:59.646+0000\"}],\"theme\":\"theme-1\",\"icon\":\"glyphicon-asterisk\"}', NULL, 3);
INSERT INTO `ACT_DE_MODEL` VALUES ('cfcfe403-591c-46c9-afca-3ccfaa8aaecc', '请假流程', 'leave', '定义请假流程', NULL, '2019-09-11 18:39:59.147000', 'admin', '2019-09-11 18:43:59.646000', 'admin', 1, '{\"resourceId\":\"cfcfe403-591c-46c9-afca-3ccfaa8aaecc\",\"properties\":{\"process_id\":\"leave\",\"name\":\"请假流程\",\"documentation\":\"定义请假流程\",\"process_author\":\"\",\"process_version\":\"\",\"process_namespace\":\"http://www.activiti.org/processdef\",\"executionlisteners\":\"\",\"eventlisteners\":\"\",\"signaldefinitions\":\"\",\"messagedefinitions\":\"\"},\"stencil\":{\"id\":\"BPMNDiagram\"},\"childShapes\":[{\"resourceId\":\"startEvent1\",\"properties\":{\"overrideid\":\"\",\"name\":\"开始\",\"documentation\":\"\",\"executionlisteners\":\"\",\"initiator\":\"\",\"formkeydefinition\":\"\",\"formreference\":\"\",\"formproperties\":\"\"},\"stencil\":{\"id\":\"StartNoneEvent\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-0DFA50FE-A6CB-49B6-8D6D-5DA8AD89A6BF\"},{\"resourceId\":\"sid-82C4DE6D-32EB-4511-8741-A12955D4BC81\"}],\"bounds\":{\"lowerRight\":{\"x\":105,\"y\":120},\"upperLeft\":{\"x\":75,\"y\":90}},\"dockers\":[]},{\"resourceId\":\"sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683\",\"properties\":{\"overrideid\":\"\",\"name\":\"组长审批\",\"documentation\":\"\",\"asynchronousdefinition\":\"false\",\"exclusivedefinition\":\"false\",\"executionlisteners\":\"\",\"multiinstance_type\":\"None\",\"multiinstance_cardinality\":\"\",\"multiinstance_collection\":\"\",\"multiinstance_variable\":\"\",\"multiinstance_condition\":\"\",\"isforcompensation\":\"false\",\"usertaskassignment\":{\"assignment\":{\"type\":\"static\",\"candidateUsers\":[{\"value\":\"${user}\",\"$$hashKey\":\"object:4182\"}]}},\"formkeydefinition\":\"\",\"formreference\":\"\",\"duedatedefinition\":\"\",\"prioritydefinition\":\"\",\"formproperties\":\"\",\"tasklisteners\":\"\"},\"stencil\":{\"id\":\"UserTask\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-7BDA0DE8-9821-43A4-815E-07321145B714\"}],\"bounds\":{\"lowerRight\":{\"x\":325,\"y\":95},\"upperLeft\":{\"x\":225,\"y\":15}},\"dockers\":[]},{\"resourceId\":\"sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38\",\"properties\":{\"overrideid\":\"\",\"name\":\"经理审批\",\"documentation\":\"\",\"asynchronousdefinition\":\"false\",\"exclusivedefinition\":\"false\",\"executionlisteners\":\"\",\"multiinstance_type\":\"None\",\"multiinstance_cardinality\":\"\",\"multiinstance_collection\":\"\",\"multiinstance_variable\":\"\",\"multiinstance_condition\":\"\",\"isforcompensation\":\"false\",\"usertaskassignment\":{\"assignment\":{\"type\":\"static\",\"candidateUsers\":[{\"value\":\"${user}\",\"$$hashKey\":\"object:4332\"}]}},\"formkeydefinition\":\"\",\"formreference\":\"\",\"duedatedefinition\":\"\",\"prioritydefinition\":\"\",\"formproperties\":\"\",\"tasklisteners\":\"\"},\"stencil\":{\"id\":\"UserTask\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-47079716-78BB-4066-858E-A826C18DFFFD\"}],\"bounds\":{\"lowerRight\":{\"x\":325,\"y\":215},\"upperLeft\":{\"x\":225,\"y\":135}},\"dockers\":[]},{\"resourceId\":\"sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907\",\"properties\":{\"overrideid\":\"\",\"name\":\"结束\",\"documentation\":\"\",\"executionlisteners\":\"\"},\"stencil\":{\"id\":\"EndNoneEvent\"},\"childShapes\":[],\"outgoing\":[],\"bounds\":{\"lowerRight\":{\"x\":493,\"y\":118},\"upperLeft\":{\"x\":465,\"y\":90}},\"dockers\":[]},{\"resourceId\":\"sid-7BDA0DE8-9821-43A4-815E-07321145B714\",\"properties\":{\"overrideid\":\"\",\"name\":\"\",\"documentation\":\"\",\"conditionsequenceflow\":\"\",\"executionlisteners\":\"\",\"defaultflow\":\"false\",\"showdiamondmarker\":false},\"stencil\":{\"id\":\"SequenceFlow\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907\"}],\"bounds\":{\"lowerRight\":{\"x\":465.27765598001514,\"y\":100.70394677951343},\"upperLeft\":{\"x\":325.37859401998486,\"y\":67.10074072048657}},\"dockers\":[{\"x\":50,\"y\":40},{\"x\":14,\"y\":14}],\"target\":{\"resourceId\":\"sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907\"}},{\"resourceId\":\"sid-47079716-78BB-4066-858E-A826C18DFFFD\",\"properties\":{\"overrideid\":\"\",\"name\":\"\",\"documentation\":\"\",\"conditionsequenceflow\":\"\",\"executionlisteners\":\"\",\"defaultflow\":\"false\",\"showdiamondmarker\":false},\"stencil\":{\"id\":\"SequenceFlow\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907\"}],\"bounds\":{\"lowerRight\":{\"x\":466.2392918722138,\"y\":157.93235027719163},\"upperLeft\":{\"x\":325.9482081277862,\"y\":110.93483722280837}},\"dockers\":[{\"x\":50,\"y\":40},{\"x\":10,\"y\":18}],\"target\":{\"resourceId\":\"sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907\"}},{\"resourceId\":\"sid-0DFA50FE-A6CB-49B6-8D6D-5DA8AD89A6BF\",\"properties\":{\"overrideid\":\"\",\"name\":\"请假天数小于3天\",\"documentation\":\"\",\"conditionsequenceflow\":{\"expression\":{\"type\":\"static\",\"staticValue\":\"${day<3}\"}},\"executionlisteners\":\"\",\"defaultflow\":\"false\"},\"stencil\":{\"id\":\"SequenceFlow\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683\"}],\"bounds\":{\"lowerRight\":{\"x\":224.15625,\"y\":105},\"upperLeft\":{\"x\":105.0625,\"y\":55}},\"dockers\":[{\"x\":15,\"y\":15},{\"x\":165,\"y\":105},{\"x\":165,\"y\":55},{\"x\":50,\"y\":40}],\"target\":{\"resourceId\":\"sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683\"}},{\"resourceId\":\"sid-82C4DE6D-32EB-4511-8741-A12955D4BC81\",\"properties\":{\"overrideid\":\"\",\"name\":\"请假天数大于3天\",\"documentation\":\"\",\"conditionsequenceflow\":{\"expression\":{\"type\":\"static\",\"staticValue\":\"${day>=3}\"}},\"executionlisteners\":\"\",\"defaultflow\":\"false\"},\"stencil\":{\"id\":\"SequenceFlow\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38\"}],\"bounds\":{\"lowerRight\":{\"x\":224.15625,\"y\":175},\"upperLeft\":{\"x\":105.0625,\"y\":105}},\"dockers\":[{\"x\":15,\"y\":15},{\"x\":165,\"y\":105},{\"x\":165,\"y\":175},{\"x\":50,\"y\":40}],\"target\":{\"resourceId\":\"sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38\"}}],\"bounds\":{\"lowerRight\":{\"x\":1200,\"y\":1050},\"upperLeft\":{\"x\":0,\"y\":0}},\"stencilset\":{\"url\":\"stencilsets/bpmn2.0/bpmn2.0.json\",\"namespace\":\"http://b3mn.org/stencilset/bpmn2.0#\"},\"ssextensions\":[]}', 0x89504E470D0A1A0A0000000D494844520000010E000000880806000000162F05D4000009FB4944415478DAED9D4D6C13E9198039EC01EDA1AA7AE94A55D5537BAC7A686FD58A4B2B5171A8846208C4E127FC29E527810409A988382541A29C16100BA82C298843A1026DB49036766AE24656BB2A5224D2A46CB18084659314A590846088E7EBFB46633AF626CEC433107BFC3CD2A761EC713C78E67BFC7EEFFB8D67C50A0000000000000000000080778D3166652A951A4E269326168B99EEEEEEC0B568346A7A7B7B2D696738E2003EA0D2482412666C6CCCA4D3E9C0B6F1F171138FC72D91C8098E3A804734D208BA349CF2900824CD5107F0880E4FE6EB64A9CF3F3103D1D6B96590E4A143178E3A8047B423E577AEE1814F4DFF67CD6FDAC84027E20080C2E2B8DBDD92230E5D471C0050501C3A44718A43D71107001414C7177DA772C4A1EB8803000A8A439B531C244701605171DCEB3B99230E5D471C0030AF3826271EE70823BFE9F388030072C451481A4119B6200E80B798E3086A431C0088037100200EC4018038100700E2401C008038000071200E00C48138001007E200284BAAABAB27A435200E0070CDFAF5EB8D36A740100700B8128753208803A00C3BEF7237C4015026E260A8823800CA461C24471107200E5F401C00880371200E401C88037100200EC4018038CA571C3B76EC789FB3111007E2702D0E95861C074BDAA4B4BF5757571FDDBC79F3F7393B0171208E8211475555D5B7E458EC5DB76E5DB7B4715B242FA50DCAFAD95028F421672B200EC45130C7D1D2D2F2DEC68D1BC519EBFE20C7E8A1B459BB3D9288E4AA3EA7DB700603E2401C05D1A84344F2B11CB37FDAD188654727518D56346AE18C06C481380AA27910CD8748FB9B9D1F31E4490071208E25419E041007E2F00C7912401C88C317C89300E2401C9E214F02880371902701C48138961FF224803810077912401C88A33428A73CC9AA55AB56CA7E8545745DB28CEB52F6B15EF6F19BEF6407366CD8F00B79E37E593E9737CEFE76A6A9ADAD7D213B332456FE25E2583AB1580C719439A5982759BB76ED0F5564F2FED6023F94AD51D31DDDEEADEC80C8E1DB2A06118675FAF4E999C1C141333D3D6D9499991973FFFE7D73E5CA154B0462649B07757575DF431CEE49241299B1B1B18A90C6C8C8C84311473AE851ED72E749E47D23B6BCE62471F0E04173F9F26573F5EAD5B9E5E1C387F30572E26D4419B36D6D6D2F9E3F7F6E0AA132397FFEBC251F8AA5AF431CEEE8E9E9698FC7E3D6E8E868E0A5118D465F4B3BB1A202F1334FA2C30C1D822C707E5FC94A21128998070F1ECCDB5F9F3C79625A5B5B9DF7F8B9EE5BA4A1D23877EEDC4BB304D46AE170583F941F200E7748678AC837F19486F1016EE94A9586DF7912FDA57CD96E5CFBE83C91C69C086EDCB86166676717EDAF9D9D9D6FE4E14BE4A1C393F6F6F617A6082E5CB860B66DDBF625E200F03F4F228F25ED8EFE221BDDDB390D2B2B8DA5E090878E187EE26988A2438EC5862785862D220E6D358803C0DF3C89B4B4334721EDD71AA96487276E228D7C8E1E3D9AFD7BFD5E3A57FFD9B3675F190FE89065EFDEBD5F210E005FF324170ADD52F4D1A34745F557CD7948C03027A2A24BB5353535935A3DF182565B1A1B1B338803C03FECFC465614AF64FD994E91D0F5A6A6264F7DF6D0A143D944697DB13BF7A6E45A2C5AAA150119C401E0EBF9AB93B93E72CEBFB02777994B972E79EAB35AAAB573275D45772E3FB03BE97B6BD6ACF94E381CFEB1FC673577B249766CBF845DBF91E74F892D7F2FEBD765F96759FFAB3CFE0F11D780FCFBDFF2D84379EE89ACFF47D6FF6B679DA7E5314D1AA565F95A9ED3715FC62E6F59CEFAF5428DD30F022693B89ED79A1EF09A5EB0FB48BCA81DD1B18E460C7E441C8B75624767D7CE9F5111A8106C31BCB445A1B35527EC6CF3972A14158B0A4645A3C291E7FE24CB3FCAB2439627554C2A2815950A4BC5555555F501E280000E5FAEEB797DF1E2454F7DB6A3A3C35BC4515757F75273145ED08927CDCDCD164315005F25A15F8C5FE974719DEC255FA267E4B18B7A5EEFDEBDDBF2D267F7EDDB6779CA71C8B773EADAB56B9EC4A1B5E1482432833800FCC39ECDBD60043F3434547431C3FE1B998566A5BAB15ABD441D45D583157DDD9E3D7B4C5B5BDB478803C0F77378324F18197BAE87A9AFAF371313134BEAAFBABDBECEFE5B514F3B575B5B3B75FBF6EDA2C4D1D7D7671A1A1A8A3717E200F81AA150480B0B77F2AE781DD77E665F3E3F2794C6C646A3174EBA41B7D3EDEDBF35E5F9727BBD4C7ED3A64D96DB1D70EEC8CE9D3BCD810307F694A8AD1107940D22899FDB559357F68CD1BF84C3E15FD949CC94F3CBD99E763E37AB74EBD6ADE6E6CD9B0B1639F4F1AEAE2EB36BD7AEAC34D232D2F8A95F3BDDB57DFBF68CDBD047B7DBBF7FBF461B774B38CC431C50EA798C1FC9797A4323007B18A295C370DE791C9D2F3AD08B4BE5B9E16C44229231C78E1DCBB9ACFEF8F1E3465EEB1CEA0C7BBA46650179DC91C82333383898592CB922F6B2B66CD932548A4314C401259EB7F8AE7CE3EB74F2A7F6F4847F496B2AF6773BEC2B659F2E321D6252DEF3D8DB34E019BDC0A6A9A969FAD6AD5BE967CF9E59D97027994C668E1C39F2BAA6A646E7607494C101421C501268C4207DEBB7724E3EB665F1583AFCF1D5AB577FC3AFF7D0E18BCAC1F9D3817AF9BCEF11C642D8BFCFD1A9C918A7B5746296864DA5FAFB1B88034A098D2042A1D041E937F76C593C95F5DF69C4C1A783380072C85644EC9CC594CEF6D45C069F0CE200C8CF337CAD2222C2F8199F0CE200C8C14D4504100780EF1511401C1050DE454504100704002A228803C03554440071802BA88840498BC318B332954A0D279349A3F7910DE2CD98A2D1A8E9EDEDB5A49D29E573838A08948D38541A8944C204FDFEB1E3E3E3466F75596A7773A3220265290E8D342AE5A6D32A8F52B8E9341511287B71E8F064BE4E96FAFC1333106D9D5B06491E3A74598ECF998A08044A1CDA91F23BD7F0C0A7A6FFB3E6376D64A0137114091511A81871DCED6EC91187AE230EF75011818A14870E519CE2D075C451182A2250F1E2F8A2EF548E38741D71CC7B2CA98800E27036A738488EFE1F2A2280381610C7BDBE9339E2D0F54A16071511401C05C43139F1384718F94D9FAF2471501101C4E1421C85A4119461CB62E2A0220288C3438E23A86D3E71501101C481385C89838A08200EC4B124716805C48E2CA88800E2401CEE230E640188037194FC456E0088037100200EC40180381007E200C481381007208E6514477575F584B406C401803896F4DEDA9C02411C0088C395389C02411C0065228E526A88030018AA200E0092A38803A004411C008038100700E2401C0088037100200EC4018038100700200EC4018038100700E2401C0088037100200EC4010088037100200EC4018038100700E2401C008803710000E20000C4813800DE25B1580C7100C0D248241299B1B1B18A90C6C8C8C84311479AA30EE0919E9E9EF6783C6E8D8E8E065E1AD168F4B5B4131C75001F90CE14916FE2290DE303DCD248030000000000000000000000000000000000006099F91F370BA610E96B99D70000000049454E44AE426082, 0);

-- ----------------------------
-- Table structure for ACT_DE_MODEL_HISTORY
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DE_MODEL_HISTORY`;
CREATE TABLE `ACT_DE_MODEL_HISTORY`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `model_key` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `model_comment` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created` datetime(6) NULL DEFAULT NULL,
  `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `last_updated` datetime(6) NULL DEFAULT NULL,
  `last_updated_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `removal_date` datetime(6) NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT NULL,
  `model_editor_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `model_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `model_type` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_proc_mod_history_proc`(`model_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_DE_MODEL_HISTORY
-- ----------------------------
INSERT INTO `ACT_DE_MODEL_HISTORY` VALUES ('ab07e012-5a3b-4804-a0fb-0c09df89c082', '请假流程', 'leave', '定义请假流程', NULL, '2019-09-11 18:44:32.294000', 'admin', '2019-09-11 18:44:43.518000', 'admin', NULL, 1, '{\"models\":[{\"id\":\"cfcfe403-591c-46c9-afca-3ccfaa8aaecc\",\"name\":\"请假流程\",\"version\":1,\"modelType\":0,\"description\":\"定义请假流程\",\"stencilSetId\":null,\"createdBy\":\"admin\",\"lastUpdatedBy\":\"admin\",\"lastUpdated\":\"2019-09-11T10:43:59.646+0000\"}],\"theme\":\"theme-1\",\"icon\":\"glyphicon-asterisk\"}', '9680a6d7-97ce-4425-961c-c220dc0c1f0d', 3);

-- ----------------------------
-- Table structure for ACT_DE_MODEL_RELATION
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DE_MODEL_RELATION`;
CREATE TABLE `ACT_DE_MODEL_RELATION`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `parent_model_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `model_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `relation_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk_relation_parent`(`parent_model_id`) USING BTREE,
  INDEX `fk_relation_child`(`model_id`) USING BTREE,
  CONSTRAINT `fk_relation_child` FOREIGN KEY (`model_id`) REFERENCES `ACT_DE_MODEL` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_relation_parent` FOREIGN KEY (`parent_model_id`) REFERENCES `ACT_DE_MODEL` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_DE_MODEL_RELATION
-- ----------------------------
INSERT INTO `ACT_DE_MODEL_RELATION` VALUES ('5d4eaa3c-16d5-4606-9959-a252f1d1f356', '9680a6d7-97ce-4425-961c-c220dc0c1f0d', 'cfcfe403-591c-46c9-afca-3ccfaa8aaecc', 'process-model');

-- ----------------------------
-- Table structure for ACT_DMN_DATABASECHANGELOG
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DMN_DATABASECHANGELOG`;
CREATE TABLE `ACT_DMN_DATABASECHANGELOG`  (
  `ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `AUTHOR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `FILENAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `DATEEXECUTED` datetime(0) NOT NULL,
  `ORDEREXECUTED` int(11) NOT NULL,
  `EXECTYPE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `MD5SUM` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DESCRIPTION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `COMMENTS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `TAG` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `LIQUIBASE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_DMN_DATABASECHANGELOG
-- ----------------------------
INSERT INTO `ACT_DMN_DATABASECHANGELOG` VALUES ('1', 'activiti', 'org/activiti/dmn/db/liquibase/activiti-dmn-db-changelog.xml', '2019-09-11 18:36:58', 1, 'EXECUTED', '7:d878c2672ead57b5801578fd39c423af', 'createTable (x3)', '', NULL, '3.1.0');

-- ----------------------------
-- Table structure for ACT_DMN_DATABASECHANGELOGLOCK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DMN_DATABASECHANGELOGLOCK`;
CREATE TABLE `ACT_DMN_DATABASECHANGELOGLOCK`  (
  `ID` int(11) NOT NULL,
  `LOCKED` bit(1) NOT NULL,
  `LOCKGRANTED` datetime(0) NULL DEFAULT NULL,
  `LOCKEDBY` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_DMN_DATABASECHANGELOGLOCK
-- ----------------------------
INSERT INTO `ACT_DMN_DATABASECHANGELOGLOCK` VALUES (1, b'0', NULL, NULL);

-- ----------------------------
-- Table structure for ACT_DMN_DECISION_TABLE
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DMN_DECISION_TABLE`;
CREATE TABLE `ACT_DMN_DECISION_TABLE`  (
  `ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `VERSION_` int(11) NULL DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PARENT_DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `RESOURCE_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DESCRIPTION_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ACT_DMN_DEPLOYMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DMN_DEPLOYMENT`;
CREATE TABLE `ACT_DMN_DEPLOYMENT`  (
  `ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DEPLOY_TIME_` datetime(0) NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PARENT_DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ACT_DMN_DEPLOYMENT_RESOURCE
-- ----------------------------
DROP TABLE IF EXISTS `ACT_DMN_DEPLOYMENT_RESOURCE`;
CREATE TABLE `ACT_DMN_DEPLOYMENT_RESOURCE`  (
  `ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `RESOURCE_BYTES_` longblob NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ACT_EVT_LOG
-- ----------------------------
DROP TABLE IF EXISTS `ACT_EVT_LOG`;
CREATE TABLE `ACT_EVT_LOG`  (
  `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
  `TYPE_` varchar(64) 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 DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `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(4) NULL DEFAULT 0,
  PRIMARY KEY (`LOG_NR_`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ACT_FO_DATABASECHANGELOG
-- ----------------------------
DROP TABLE IF EXISTS `ACT_FO_DATABASECHANGELOG`;
CREATE TABLE `ACT_FO_DATABASECHANGELOG`  (
  `ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `AUTHOR` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `FILENAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `DATEEXECUTED` datetime(0) NOT NULL,
  `ORDEREXECUTED` int(11) NOT NULL,
  `EXECTYPE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `MD5SUM` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DESCRIPTION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `COMMENTS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `TAG` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `LIQUIBASE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_FO_DATABASECHANGELOG
-- ----------------------------
INSERT INTO `ACT_FO_DATABASECHANGELOG` VALUES ('1', 'activiti', 'org/activiti/form/db/liquibase/activiti-form-db-changelog.xml', '2019-09-11 18:36:56', 1, 'EXECUTED', '7:913aee6a78e577fe455efed1d40980f1', 'createTable (x4)', '', NULL, '3.1.0');

-- ----------------------------
-- Table structure for ACT_FO_DATABASECHANGELOGLOCK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_FO_DATABASECHANGELOGLOCK`;
CREATE TABLE `ACT_FO_DATABASECHANGELOGLOCK`  (
  `ID` int(11) NOT NULL,
  `LOCKED` bit(1) NOT NULL,
  `LOCKGRANTED` datetime(0) NULL DEFAULT NULL,
  `LOCKEDBY` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_FO_DATABASECHANGELOGLOCK
-- ----------------------------
INSERT INTO `ACT_FO_DATABASECHANGELOGLOCK` VALUES (1, b'0', NULL, NULL);

-- ----------------------------
-- Table structure for ACT_FO_FORM_DEFINITION
-- ----------------------------
DROP TABLE IF EXISTS `ACT_FO_FORM_DEFINITION`;
CREATE TABLE `ACT_FO_FORM_DEFINITION`  (
  `ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `VERSION_` int(11) NULL DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PARENT_DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `RESOURCE_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DESCRIPTION_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ACT_FO_FORM_DEPLOYMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_FO_FORM_DEPLOYMENT`;
CREATE TABLE `ACT_FO_FORM_DEPLOYMENT`  (
  `ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CATEGORY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DEPLOY_TIME_` datetime(0) NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PARENT_DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ACT_FO_FORM_RESOURCE
-- ----------------------------
DROP TABLE IF EXISTS `ACT_FO_FORM_RESOURCE`;
CREATE TABLE `ACT_FO_FORM_RESOURCE`  (
  `ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `RESOURCE_BYTES_` longblob NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ACT_FO_SUBMITTED_FORM
-- ----------------------------
DROP TABLE IF EXISTS `ACT_FO_SUBMITTED_FORM`;
CREATE TABLE `ACT_FO_SUBMITTED_FORM`  (
  `ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `FORM_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `TASK_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PROC_INST_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PROC_DEF_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `SUBMITTED_DATE_` datetime(0) NULL DEFAULT NULL,
  `SUBMITTED_BY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `FORM_VALUES_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `TENANT_ID_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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(11) 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(4) 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 ('2502', 1, 'leave.bpmn', '2501', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A7873643D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22687474703A2F2F7777772E61637469766974692E6F72672F70726F63657373646566223E0A20203C70726F636573732069643D226C6561766522206E616D653D22E8AFB7E58187E6B581E7A88B2220697345786563757461626C653D2274727565223E0A202020203C646F63756D656E746174696F6E3EE5AE9AE4B989E8AFB7E58187E6B581E7A88B3C2F646F63756D656E746174696F6E3E0A202020203C73746172744576656E742069643D2273746172744576656E743122206E616D653D22E5BC80E5A78B222061637469766974693A696E69746961746F723D22696E69746961746F72223E3C2F73746172744576656E743E0A202020203C757365725461736B2069643D227369642D45313637434130422D413342442D343143412D423142302D41374241444432364636383322206E616D653D22E7BB84E995BFE5AEA1E689B9222061637469766974693A63616E64696461746555736572733D22247B757365727D223E3C2F757365725461736B3E0A202020203C757365725461736B2069643D227369642D37414445454437422D303345392D343244442D423831382D33384430344330324442333822206E616D653D22E7BB8FE79086E5AEA1E689B9222061637469766974693A63616E64696461746555736572733D22247B757365727D223E3C2F757365725461736B3E0A202020203C656E644576656E742069643D227369642D36354546433442372D364439452D344437462D393642422D30424236444235324539303722206E616D653D22E7BB93E69D9F223E3C2F656E644576656E743E0A202020203C73657175656E6365466C6F772069643D227369642D37424441304445382D393832312D343341342D383135452D3037333231313435423731342220736F757263655265663D227369642D45313637434130422D413342442D343143412D423142302D41374241444432364636383322207461726765745265663D227369642D36354546433442372D364439452D344437462D393642422D304242364442353245393037223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D227369642D34373037393731362D373842422D343036362D383538452D4138323643313844464646442220736F757263655265663D227369642D37414445454437422D303345392D343244442D423831382D33384430344330324442333822207461726765745265663D227369642D36354546433442372D364439452D344437462D393642422D304242364442353245393037223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D227369642D30444641353046452D413643422D343942362D384436442D35444138414438394136424622206E616D653D22E8AFB7E58187E5A4A9E695B0E5B08FE4BA8E33E5A4A92220736F757263655265663D2273746172744576656E743122207461726765745265663D227369642D45313637434130422D413342442D343143412D423142302D413742414444323646363833223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6461793C337D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D227369642D38324334444536442D333245422D343531312D383734312D41313239353544344243383122206E616D653D22E8AFB7E58187E5A4A9E695B0E5A4A7E4BA8E33E5A4A92220736F757263655265663D2273746172744576656E743122207461726765745265663D227369642D37414445454437422D303345392D343244442D423831382D333844303443303244423338223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6461793E3D337D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F6C65617665223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D226C65617665222069643D2242504D4E506C616E655F6C65617665223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D2273746172744576656E7431222069643D2242504D4E53686170655F73746172744576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233302E30222077696474683D2233302E302220783D2237352E302220793D2239302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D45313637434130422D413342442D343143412D423142302D413742414444323646363833222069643D2242504D4E53686170655F7369642D45313637434130422D413342442D343143412D423142302D413742414444323646363833223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2238302E30222077696474683D223130302E302220783D223232352E302220793D2231352E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D37414445454437422D303345392D343244442D423831382D333844303443303244423338222069643D2242504D4E53686170655F7369642D37414445454437422D303345392D343244442D423831382D333844303443303244423338223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2238302E30222077696474683D223130302E302220783D223232352E302220793D223133352E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227369642D36354546433442372D364439452D344437462D393642422D304242364442353245393037222069643D2242504D4E53686170655F7369642D36354546433442372D364439452D344437462D393642422D304242364442353245393037223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2232382E30222077696474683D2232382E302220783D223436352E302220793D2239302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D30444641353046452D413643422D343942362D384436442D354441384144383941364246222069643D2242504D4E456467655F7369642D30444641353046452D413643422D343942362D384436442D354441384144383941364246223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223130352E302220793D223130352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223136352E302220793D223130352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223136352E302220793D2235352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223232352E302220793D2235352E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D34373037393731362D373842422D343036362D383538452D413832364331384446464644222069643D2242504D4E456467655F7369642D34373037393731362D373842422D343036362D383538452D413832364331384446464644223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223332352E302220793D223135382E3235223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223436352E35313739313837323231333832332220793D223131312E31373634393732323830383337223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D38324334444536442D333245422D343531312D383734312D413132393535443442433831222069643D2242504D4E456467655F7369642D38324334444536442D333245422D343531312D383734312D413132393535443442433831223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223130352E302220793D223130352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223136352E302220793D223130352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223136352E302220793D223137352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223232352E302220793D223137352E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D227369642D37424441304445382D393832312D343341342D383135452D303733323131343542373134222069643D2242504D4E456467655F7369642D37424441304445382D393832312D343341342D383135452D303733323131343542373134223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223332352E302220793D2236372E3030393830333932313536383633223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223436352E333837313833373230323131372220793D223130302E37333032353439313331383831223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, 0);
INSERT INTO `ACT_GE_BYTEARRAY` VALUES ('2503', 1, 'leave.leave.png', '2501', 0x89504E470D0A1A0A0000000D49484452000001F7000000E10806000000D58DFC15000016634944415478DAEDDD0B8C5D759DC071420C21C418628CC69868CC46B331C66836868D316C8D59777143DC507AEBDC69CBD0C214BA8254445D01DB02F2AC4AD008288B8064410D0856A0B5D3766C29C50702A5BC5A298FB614A69496BEE8F431677FBFD93364183AD3693BAF33F3F924FFDCF6DE292D73EF3DDFF99F7BCEFF1C75140000000000000000000000000000000000000000000000000000000000C0C85014C5B16BD7AE5DB762C58A62D1A245C5C2850B8D211E2D2D2DC5D2A54B3B625CEF1509C011CBB02F5BB6AC686B6B2BDADBDB8D611A9B366D2A5A5B5B3B22F473BD2A013822396317F69113F898C9B77B550270447257BCB08E9C91BBE9BD2A013822191351157700C660DC776CDD58ACFDCB2F8A275B2EE91CF9EBBC4F90C51D800AC67DFB960DC5AA0517178FDF77C1DB46DE978F89B2B80350B1B8AF7BF277EF087BD758FFE43C51167700AA16F7A7975CD56BDCF331511677002A16F7550B67F71AF77C4C94C51D007137C41D80E18C7B1E1DDF5BDCF331511677002A16F735CB7FD26BDCF331511677002A16F7CD1B5616ABFE30EB9DBBE4E3BE7C4C94C51D808AC53DC7F37FBDED1D71CFFB0459DC01A862DC77EF2ED63C74FD3B77C9C77DF998288B3B00158A7BAE40B77AF98F7BFDCC3D1FB34A9DB8035085B8C78C7CE39AC5C513F3BFDB6BD8BB467E4D7EAD59BCB8033042E37EB0D9BA59BCB80350B1B8F767B6DED72C5EA4C51D801116F7C30D7BD7106971076084C5DD107700C4DD107700C4DD107700C45DDC0140DCC51D007137C41D007137C41D007137C41D00711777001077710740DC0D710740DC0D710740DC0D710740DCC51D00BEFAD5AF6E6E68689821EEE20EC0E8897B518ECD13274E3C43DCC51D80D113F7AEB1E940337971177700AA1BF7B766F2DD232FEEE20E40F5E3FED64C3E77D78BBBB80388E2281BE22EEE006322EEA3FC87941D31639F336EDCB863F3EBC45DDC01C4BDBA717F5BD4BB8CB4B8C73FE98063A81E17770071AF42DCB73734345CD133EA2339EE7DDD37D88F8B3B80B88FE4FF8F03CED4C55DDC01C47D94137771071077711777710710777117777107107771177700C47DF4C4FD28A7C20120EEA327EE16B11177007117F75135162C5820EE00E22EEEA365ECDCB9B39832654AD1D0D0B02D5E872B625C1CBFFF90772580B88B7B85C7030F3C50D46AB599F13A5C12917F3D6E3B62EC8CF148AE34D8D4D4F431EF52007117F70A7FE6DEDCDC7C5C447DFAC48913E7C76BB32D631FBFDE1DB7ABE2F6BAB8FD8C772D80B88B7B850FA89B3061C23111FB49F13ABD27C6CB11F88EF8FD9EF8F5B371FBF398F59FE85D0C20EEA25AEDA3E58FAED7EB5F89C8DF11AFDD1763EC8FB12F42FF7CDCFE321EFBB2773520EEE26E54FC54B8534F3DF58B11F79BE3B5FCF7187B33F811FFF571DF6FE276C2ECD9B3DFE59D0E88BBB81B153ECF3D5ED32744D47F1AB74FC5682F0FD27BA556ABFD3E6EA71EECCA8100E22EEEC6085FC4A6B1B1F113F57AFD9A08FE63F17ADF55C6FEB5182D71DF39279D74D27B6C0900711777A3C22BD44D9B36ED2311F5390D0D0D7F8AD7FF8E32F65B632C8BF1EDB8FF03B60C80B88BBB51E1E567274F9EFCFE8C7A19F7AD65EC33FA7F8E19FFA5F9C3802D0520EEE26E54786DF9DC4D9FBBEB73B77DEEBECFD3EF72777EEED68F313777F3DB7200E22EEE46852F1C9307E03534349C1EEF957979605ECEECE3F779A0DE53E5817B27D89200E22EEE4685AF0A97A7D6E5297679AA5DBC7FD695E7DAEF8DDFE7A978B7E4A979B62C80B88BBBB8575C2E9E938BE8948BE9EC2B83FF62DC7F67AD56FBCFF892A36D6D0071177771AFB088FCE763767F63B94CEE9EF273FB977319DD5C4E3797D5B5F501C45DDCC5BDDA33FB4F47D4AF8DC83F11EFB937CB23F237E50572F2423911FB77DB1A01E22EEEE25E617929DBBCA46D5EDA3602BFB33C482F2F79DB1AB7E747ECDF6BEB0488BBB88B7B854D9932E543F15EBC38C68A88FBB632F679BB22EFCFC77D970071177771AFB09CB9D76AB599F1FE5C52CEE873377ECEF01FC9197FCEFC7D970071177771AFB0E6E6E6E3F2B3F9FC8C3EDEB36D19FBF8F5EEB85D15B7D7C5ED677C97007137C4BDDA33FB63F2A8FB3CFA3E8FC2CFA3F1F3A8FCF2E8FC9FC7ACFF44DF2510777137C4BDDA8EAED7EB5F89C8DF91E7D797E7D9EF2BCFBBFF659E87EF5B04E22EEE86B8575CAE941771BF39DEE3B972DEDE0C7EC47F7DAEAC972BECE54A7BA3F1FFBBB1B1F1B3F1FFF7EB5C3DB0DC9B91C72B14E5D85BAE37302FBFCEAB64842A8AE2F8952B57DE7EDB6DB76DBDF2CA2B3BCE3DF7DCA2A9A9A9F3499C3469523163C68CE2C20B2FDC7BD55557ADBDFAEAABFFDD774CDCC55DDCC7F07BFD84722DFCA762B497D17BA556ABFD3E6EA7E61AFA55FEFF2B4F2DDC1CB745B798F739E26BB7D4EBF5EBBD3A4650D4EFBAEBAEE72EBDF4D2E2BCF3CE2B6EBCF1C6E2E1871F2E366CD850BCF9E69B45CADBB6B6B6E291471E296EBDF5D6E2EB5FFF7A3173E6CCBDCDCDCDB7F80E8ABB21EE635D5EDD2EC2764D5EED2EAF7A57C6FEB5BC1A5E5E152FAF8E5791A87F3EC6A6FE06BD97F1866B020CB388F82F2EBBECB2E2820B2EE80CF7BE7DFB8AFE7AECB1C78AEF7CE73BC5F4E9D3DB3D916333EE8B162D125571E700F2BAF511F53911CA3F95D7B3EF28AF6F9FD7B9FF76DCFF8191F66FCE3305E20794EEBBDD8BF8A1A5B8E28A2B8AC58B17172FBDF452B16DDBB6CEEDFFCE9D3B3B2780CB972F2F7EF4A31F1593274FEE19F80EB3F8E199AD1F7BEFBDF76E39EBACB38A79F3E61D52D47B9A3F7F7E112FE4C22C7EECC57DD9B265FB738F8EB00EFF58BF7EFD8B11F7765BB79129E2F7FE8C7A19F7AD65EC33FA7F8E085E9A3F0C0CE4DFD7D4D474FC21867D4EF75DF019F5DB6FBFBD738F6D7F6CD9B2A5F3EBF3CFF5D8557FAB677F08C3BE64C9921DE79C734EB17AF5EA6220BCF0C20B45FEA070C61967FC4ADCC78EF869FEF2D6D6D68E575F7D55608739EC2D2D2D7B63CCB585AB86DC4D9FBBEB73B77DEEBE2F2F86B32B77EBC7989BBBF98F7016FE4C84F5B7FD9DB1770FFB37BEF18DCE59FAE1C83F977B82BB07DE0C7E88E48C3DC3DEDF9FC8FA2BFF7B679E79E698DE1533D6E29E22287362C6B82377091BC336DA85BDDAF200BC08ECE979E4791E98572E999B07EA3D551EB877C2216E8BF697715DD1D7C17DF9197BF75DF1B366CD7A6BD7FBE1CA5DF6DFFFFEF77BEEA277FAE060CACFD873863D5033F603CDE0274F9E3C669FC8B1187760E0E5A975798A5D9E6A97A7A195B1DE1BBFCF53F16EE9EB38A7BCE67D8FCFBF5F89FFD6C77B89FBE6EE33F6230D7BF7C0F798C1BFE1591D247954FC25975CD2F919FB60BAFFFEFB3B1A1B1BB78B3BC0C0C949532EA2532EA6B3AF0CFE8B71FF9D19F4F892A3CB60DFDAF308F688FBAE9E812F4F777BEB33F6C3DD15DFD72EFAEE9FC1DB3D3F48EEBEFBEEE7F327A93D7BF614836DC68C19FBC7E21329EEC050C95DEA11EC1BCB6572F7949FDBE7F2B9DB7A39452D7F1898DC6D7BF5D6AC3D0F861B0C77DC7187D9FB60CFDAF33CF63CDD6D283CFEF8E3457F66EFE3C68D3B7E347D9FC51D18C699FDA723F2D7F6750E7AFE009047C6E78A725D07D1E5EC7AF3E6CD83D2823C8ABEFB6972F90389676A00E5CA737910DD919CF276A8A64E9DBABFB727321E3E75C3860D1D798EE445175DB471B4445EDC81E194D1EECF4233DD67F7575F7DF5A0B620CF83EFF677CFF32C0DA05C52F6A69B6E2A86523CA1BB0EF444BEF4D24BAF77AD7C9776EFDEDDB9EBE6ECB3CFBE5CDC010E5F9E46D747D4F3B2B69BCAF1D611F2ADADAD83DA829CC4753FB8CFB3348072ADF85C5276283DF4D0437BBB3F91DBB66DFB619E0FDD9BB56BD716F1EFDCDDDCDCFC61710738AC6DD08B5DBBDFE3767B9E0AD7B51BBEFBD7951781E90CEE401F48D753AE64D72DEEFB3C4B03282F02B371E3C6218DFB2BAFBCD27999C4F8E587D7AD5BB777FFFEFD07FD331D1D1DC5030F3C906BDCFF51DC010E79E69E0BD29C77B00BD7749FB90FD4E96F7D9D16D77D0F82676900E5D5DDBAEF0A1F0AF9F7DD79E79DC5D6AD5B0FF9CFBEFEFAEBC50D37DC90E7CBFF9BB8030CFCB6AA6B0C05711FC42772A83DF3CC33C575D75DD779B4E4E11C61997FF608AF4C342CC3AB0DA84013CCDC4783D34E3B6DC867EEBB76EDEA5CFE70FAF4E9FBF3808AFE8A997E5E4A365F78FB264E9C78B6993BC0C0F299FB28F1B5AF7D6DC83F737FF9E597DBBB9EC83CA863CE9C397DCEE2F3F3F69FFDEC67ED5DEB2157750F89571B305CCA35EA6FADD56ADFCA55EB7AFBECBD5CD2D6D1F25577F1C517EF19EAA3E5172C58D0D6FD898C59F8271B1B1B77DD75D75D45CF83EB9E7BEEB9DD93264DCA233C779E7EFAE99FABF0AE2E7107867B3BB4BDC7C785B926FD96D8BEFE2DAF42579E2EB7D479EEA3C035D75CF3EC509FE73E7BF6ECB6033D91F122BB61E6CC9919F4DC75DF71E18517EE2BAF8074C3287853893B30AC0EB4B67C5F63B057A8CB899B15EA06C9F7BEF7BD2FE4AEF9A15CA1AE5EAFEFE9ED89CC15E9E2B197CB27FB652BD4010C8CF1E3C77FAA1F51DF5B2E6A636DF9AA8BD9F29EA15A5B7EC18205CFF7E789B4B63CC0A06C8B5EEE23EC2F969FCDBB2ADC68306DDAB41F9E7FFEF943317BCFF3D377B92A1CC0D0ABD56AA7F511F735DD0FB2CBCFE207EB7AEED99BEEB3F6832DACC311983E7DFA9B837D3DF7FC7C7FAC3E91E20E0C53D04F8EEDCFB2F214B73CEBE8A17209DA5EC35EC6FDF3E5A5603BBF66D6AC59471CF80CFB65975DD6FDEFCD09DF973D4B83289FC8A953A716AB57AF1E94B0AF5CB97263FC1DFBC7EA1329EEC0506ECF23E0F363BBF3669E761CE3CF31EADDB6476B7AEE8A3FD07F2797ACEDFE4340CEE00F77177DFEB91E3376BBE387CAA449937E1A33F8A2ADAD6D40C3BE6EDDBA37E2C5B6772C3F91E20E0CA63CA538B6B3BFC94BB6E6442AB639AB62FC573C74F401E27F5E19D84D4D4D4DC71F64DB7553CF23E8F320BBFEAE309A5F9707CF75FF8CBDBC80CD7CCFDAD006FEE633CF3CB363A066F0E58C7DEF587F22C51D1868D3A64DFB486C5F6F8EEDCBE6F2B4E1BFC7ED4507FBE8331F8F6DF2DA8385BDFB0CBEE7AEFC8C759E079F0BDDE4ACBC6B977DEE7ACF95E772819A5C2A3C5741EDF11140FE776EF2EC0DCF4F80D745E43BEEB9E79E8E2338C8AEE3073FF8C19AF227C831FF448A3B30104E3EF9E4F7C576F5DAD8A66CCC50C6F67A7DBD5EBFA6BFA13E5CE567F09B8FF01A1B6FF88C7D98E513194FC2EB679D75D6FE471F7DF490AABE70E1C217E387831D9E4871078E5C7373F37179EDF5D88E3C5FCEA037C5ED8DA79C72CA078761F237F73022FF464EF21C153FB266F17333F2F153E1FE2BAFBC72F7830F3EB86FFDFAF5FBBA2E36931781C9B5E25B5A5A5E9D3D7BF6A6F8DABD9E4871078E4C6C4FDF55ABD566C6B6E3E932E85BE3F68E181F1F09FFBEC6C6C6CFC624F0B7E55AF47B7BC43C0FE27B255722B5F2DC08E78914776048B61553633BFA68791ADACEDCAEE6F6D77706C41DA890BC4A5B6C2396C7E83C173D66E78B637CC97706C41DA856D04F8CEDC21FCA73D1F38CA28763863ED17706C41DA8907ABDFEE988FADDE5A557F747D057C6EFCF3AEA00E7A203E20E8C5093274FFE6879A9D5D7CB73BCD744D0FF7BC28409C7F8EE80B803D509FAFBE33DFFE39899BF522E2E9307225F79D24927BDC77707C41DA8889889BF3B227E59AED55E2E2ED3964B6EC77D1FF0DD017107AA13F463E2BDFDCD18CF9641DF1231BFBDA9A9E963BE3B20EE408544C4CF88F7F463E5F2DA3B6AB5DABD11FA7FF29D0171072AA45EAF9F92D7422F17F1DA1D63D1A9A79EFA45DF191077A0426246FE8578EFB664CC63B69E515F11B7137C670071876ABD573F13E39EDCDD5E9E8B9EBBDFA71FE55C7440DCA13A22E0FF10EFD15F46C4B794E7A23F1BB3F66F39171D1077A8903C452DA2FED3786FBE5A063D4F61BBDCB9E880B8438564B823EA57C4FBF1A532E8B9C8CC4F72D119DF1D40DC0FA2288A63D7AE5DBB6EC58A15C5A2458B8A850B171A433C5A5A5A8AA54B9776C4B87E2CBFF7CA73D1BF1D515F5DAE1697CBC0DE96BBE26D9900713F0419F665CB96156D6D6D457B7BBB314C63D3A64D456B6B6B47847EEE187BCB1D9D07C1C5FBEEF1F2BAE83BE2F7BFCD0BB7D81A01E27E9872C62EEC2327F031936F1F0BAFBB3C4DAD3C5D2D2FA19AA7AF2D8CA8FF8B2D1020EE032077C50BEBC819B99B7EB4BED622DEFF9A0BCA940BCBE4B9E80FE58233B63A80B80FB08C89A88AFB60C9A55E73C9D7AE73D17329D85C12D6960610F71110F71D5B37166BFFF28BE2C9964B3A47FE3AEF136471EF292FC612EFA3FF8DB13542DE515EACE59BB367CF7E972D0C20EE2324EEDBB76C28562DB8B878FCBE0BDE36F2BE7C4C94C5FD94534EF96084FC8678FFB495417FA15EAF5F9A9757B55501C47D04C67DDD93BF7B47D8BBC6FA27E789F2188D7BCCD08F8F905F1DEF9975E5B9E81BE3F7D739171D10F70AC4FDE92557F51AF77C4C94C74EDCC78D1B776CCCC8BF1BEF93BF9741DF1CE39608FA476D3D0071AF50DC572D9CDD6BDCF331511EF571CF73D167C4ACFC89F2A0B8ED31EE1A3F7EFCA76C3100711777A342716FF87F7F8AF7C4BE186FC65850ABD54EB49500C47D14C43D8F8EEF2DEEF998288F9EB8C7ECFC4BF11E5812516F8FDB3D311EACD7EB5FB16500C47D94C57DCDF29FF41AF77C4C94AB1DF778CD9F10635E8C9D394B8FC0FF2DE27EBAAD0120EEA338EE9B37AC2C56FD61D63B77C9C77DF99828572FEEE3C78FFFC788F81D792E7AF939FAD3B55A6DA673D101711F2371CFF1FC5F6F7B47DCF33E41AE4EDCA74C99F2A19891FF3C5EE39BCA73D19F8FDB39CDCDCDC779E703E23ED6E2BE7B77B1E6A1EBDFB94B3EEECBC74479E4C6BD3C177D6EBCAE37749D8B1E81BFF6E4934F7E9F773B20EE6334EEB902DDEAE53FEEF533F77CCC2A75232BEE792E7ABC8E2F8EF15C19F4D76AB5DAFF4C9B36ED23DEE180B88FE5B8C78C7CE39AC5C513F3BFDB6BD8BB467E4D7EAD59FCB0C6FDE898A19F13E3C99899EF8FB12D7EFDEB189FF4AE06C45DDC0F3A5B378B1F39718F884F8A80FFA53C177D578CFB274D9AF439EF6400717FDBE8CF6CBDAF59BC480F6EDCEBF5FA9723EA7FCCF3D0E336CF455F1AE33FBC7B01C4BDD7B81F6ED8BB86480F7CDC6376FECF11F2FBE23667E7FBE2D77F8DDBC9DEB100E2DEAFB81B2323EE8D8D8D9F88D7E3AF22E46FE4B9E8F9797ADC9EEB5C74007117F70A8DFBEEBBAF88D7E04D11F4D7F25CF4186BEBF5FA2CE7A20388BBB85770ECD8B1A3686A6ACAB86FA8D56A3F9C3061C27BBD2301C45DDC2B3EE6CF9F5F78170288BBB83BCF1D00711777710710777137C41D40DCC5DD10770071177771177700711777710740DCC55DDC01C45DDC0D710710777137C41D40DCC5DD10770071EFFBFF63734343C30C71177700711F3D712FCAB179E2C4896788BBB80388FBE8897BD7D874A099BCB88B3B80B85737EE6FCDE4BB475EDCC51D40DCAB1FF7B766F2B9BB5EDCC51D604CC47D2C0D71177700AAFF43CA8E98B1CF19376EDCB1F975E22EEE005437EE6F8B7A979116F7F8271D700CD5E3E20E4015E2BEBDA1A1E18A9E511FC971EFEBBEC17E5CDC0118C9713FE04C5DDCC51D80514EDCC51D00711777710740DCC55DDC011077710780D113F7A39C0A0700A327EE16B1117700C45DDC0140DCC51D007137C41D007137C41D007137C41D00711777001077710740DC0D710740DC0D710740DC0D710740DCC51D00C45DDC01107743DC01107743DC01107743DC01107771070071177700C4DD107700C4DD107700C4DD107700C45DDC0140DCC51D007137C41D007137C41D007137C41D0071177700E8C3A2458B4455DC01184D962D5BB6BFADAD4D5847C058BF7EFD8B11F776AF4A008EC8E2C58B2F6F6D6DED78F5D557057698C3DED2D2B237C65CAF4A008E5804654ECC1877E42E6163D846BBB003000000000000000000000000000000000063DEFF01BC73713D56FD08530000000049454E44AE426082, 1);

-- ----------------------------
-- 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(11) 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', '27501', 12);
INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.history', 'create(6.0.0.4)', 1);
INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.version', '6.0.0.4', 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(20) 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 ('10006', 'leave:1:2504', '10001', '10005', 'startEvent1', NULL, NULL, '开始', 'startEvent', NULL, '2019-09-12 10:21:58.094', '2019-09-12 10:21:58.102', 8, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('10007', 'leave:1:2504', '10001', '10005', 'sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38', '10008', NULL, '经理审批', 'userTask', NULL, '2019-09-12 10:21:58.274', '2019-09-12 10:51:07.425', 1749151, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('12502', 'leave:1:2504', '10001', '10005', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '结束', 'endEvent', NULL, '2019-09-12 10:51:07.442', '2019-09-12 10:51:07.442', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('17514', 'leave:1:2504', '17509', '17513', 'startEvent1', NULL, NULL, '开始', 'startEvent', NULL, '2019-09-12 15:36:57.685', '2019-09-12 15:36:57.685', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('17515', 'leave:1:2504', '17509', '17513', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', '17516', NULL, '组长审批', 'userTask', NULL, '2019-09-12 15:36:57.685', '2019-09-12 16:29:59.041', 3181356, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('20006', 'leave:1:2504', '20001', '20005', 'startEvent1', NULL, NULL, '开始', 'startEvent', NULL, '2019-09-12 16:19:16.610', '2019-09-12 16:19:16.613', 3, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('20007', 'leave:1:2504', '20001', '20005', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', '20008', NULL, '组长审批', 'userTask', NULL, '2019-09-12 16:19:16.679', NULL, NULL, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('20016', 'leave:1:2504', '20011', '20015', 'startEvent1', NULL, NULL, '开始', 'startEvent', NULL, '2019-09-12 16:19:58.417', '2019-09-12 16:19:58.417', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('20017', 'leave:1:2504', '20011', '20015', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', '20018', NULL, '组长审批', 'userTask', NULL, '2019-09-12 16:19:58.417', '2019-09-12 16:24:52.773', 294356, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('20022', 'leave:1:2504', '20011', '20015', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '结束', 'endEvent', NULL, '2019-09-12 16:24:52.774', '2019-09-12 16:24:52.774', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('20024', 'leave:1:2504', '17509', '17513', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '结束', 'endEvent', NULL, '2019-09-12 16:29:59.041', '2019-09-12 16:29:59.041', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('22506', 'leave:1:2504', '22501', '22505', 'startEvent1', NULL, NULL, '开始', 'startEvent', NULL, '2019-09-16 15:35:45.493', '2019-09-16 15:35:45.496', 3, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('22507', 'leave:1:2504', '22501', '22505', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', '22508', NULL, '组长审批', 'userTask', NULL, '2019-09-16 15:35:45.563', '2019-09-16 17:32:53.891', 7028328, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('25002', 'leave:1:2504', '22501', '22505', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '结束', 'endEvent', NULL, '2019-09-16 17:32:53.896', '2019-09-16 17:32:53.896', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('25008', 'leave:1:2504', '25003', '25007', 'startEvent1', NULL, NULL, '开始', 'startEvent', NULL, '2019-09-16 17:33:34.780', '2019-09-16 17:33:34.780', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('25009', 'leave:1:2504', '25003', '25007', 'sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38', '25010', NULL, '经理审批', 'userTask', NULL, '2019-09-16 17:33:34.840', '2019-09-16 17:33:44.350', 9510, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('25014', 'leave:1:2504', '25003', '25007', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '结束', 'endEvent', NULL, '2019-09-16 17:33:44.351', '2019-09-16 17:33:44.351', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('25020', 'leave:1:2504', '25015', '25019', 'startEvent1', NULL, NULL, '开始', 'startEvent', NULL, '2019-09-16 17:36:38.577', '2019-09-16 17:36:38.577', 0, NULL, '');
INSERT INTO `ACT_HI_ACTINST` VALUES ('25021', 'leave:1:2504', '25015', '25019', 'sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38', '25022', NULL, '经理审批', 'userTask', NULL, '2019-09-16 17:36:38.577', 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(11) 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;

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

-- ----------------------------
-- 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(11) 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(20) 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;

-- ----------------------------
-- 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 ('10009', NULL, 'candidate', 'sas', '10008', NULL);
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('10010', NULL, 'participant', 'sas', NULL, '10001');
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('17517', NULL, 'candidate', '2', '17516', NULL);
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('17518', NULL, 'participant', '2', NULL, '17509');
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('20009', NULL, 'candidate', '1', '20008', NULL);
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('20010', NULL, 'participant', '1', NULL, '20001');
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('20019', NULL, 'candidate', '1', '20018', NULL);
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('20020', NULL, 'participant', '1', NULL, '20011');
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('22509', NULL, 'candidate', '1', '22508', NULL);
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('22510', NULL, 'participant', '1', NULL, '22501');
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('25011', NULL, 'candidate', '1', '25010', NULL);
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('25012', NULL, 'participant', '1', NULL, '25003');
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('25023', NULL, 'candidate', '1', '25022', NULL);
INSERT INTO `ACT_HI_IDENTITYLINK` VALUES ('25024', NULL, 'participant', '1', NULL, '25015');

-- ----------------------------
-- 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(20) 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 ('10001', '10001', NULL, 'leave:1:2504', '2019-09-12 10:21:57.830', '2019-09-12 10:51:08.052', 1750222, NULL, 'startEvent1', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '', NULL);
INSERT INTO `ACT_HI_PROCINST` VALUES ('17509', '17509', NULL, 'leave:1:2504', '2019-09-12 15:36:57.683', '2019-09-12 16:29:59.586', 3181903, NULL, 'startEvent1', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '', NULL);
INSERT INTO `ACT_HI_PROCINST` VALUES ('20001', '20001', NULL, 'leave:1:2504', '2019-09-12 16:19:16.374', NULL, NULL, NULL, 'startEvent1', NULL, NULL, NULL, '', NULL);
INSERT INTO `ACT_HI_PROCINST` VALUES ('20011', '20011', NULL, 'leave:1:2504', '2019-09-12 16:19:58.416', '2019-09-12 16:24:53.410', 294994, NULL, 'startEvent1', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '', NULL);
INSERT INTO `ACT_HI_PROCINST` VALUES ('22501', '22501', NULL, 'leave:1:2504', '2019-09-16 15:35:45.305', '2019-09-16 17:32:54.435', 7029130, NULL, 'startEvent1', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '', NULL);
INSERT INTO `ACT_HI_PROCINST` VALUES ('25003', '25003', NULL, 'leave:1:2504', '2019-09-16 17:33:34.779', '2019-09-16 17:33:44.890', 10111, NULL, 'startEvent1', 'sid-65EFC4B7-6D9E-4D7F-96BB-0BB6DB52E907', NULL, NULL, '', NULL);
INSERT INTO `ACT_HI_PROCINST` VALUES ('25015', '25015', NULL, 'leave:1:2504', '2019-09-16 17:36:38.576', NULL, NULL, NULL, 'startEvent1', NULL, NULL, NULL, '', NULL);

-- ----------------------------
-- Table structure for ACT_HI_TASKINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_TASKINST`;
CREATE TABLE `ACT_HI_TASKINST`  (
  `ID_` varchar(64) 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(20) NULL DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PRIORITY_` int(11) 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 ('10008', 'leave:1:2504', 'sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38', '10001', '10005', '经理审批', NULL, NULL, NULL, NULL, '2019-09-12 10:21:58.278', NULL, '2019-09-12 10:51:07.308', 1749030, NULL, 50, NULL, NULL, NULL, '');
INSERT INTO `ACT_HI_TASKINST` VALUES ('17516', 'leave:1:2504', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', '17509', '17513', '组长审批', NULL, NULL, NULL, NULL, '2019-09-12 15:36:57.686', NULL, '2019-09-12 16:29:58.954', 3181268, NULL, 50, NULL, NULL, NULL, '');
INSERT INTO `ACT_HI_TASKINST` VALUES ('20008', 'leave:1:2504', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', '20001', '20005', '组长审批', NULL, NULL, NULL, NULL, '2019-09-12 16:19:16.679', NULL, NULL, NULL, NULL, 50, NULL, NULL, NULL, '');
INSERT INTO `ACT_HI_TASKINST` VALUES ('20018', 'leave:1:2504', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', '20011', '20015', '组长审批', NULL, NULL, NULL, NULL, '2019-09-12 16:19:58.417', NULL, '2019-09-12 16:24:52.650', 294233, NULL, 50, NULL, NULL, NULL, '');
INSERT INTO `ACT_HI_TASKINST` VALUES ('22508', 'leave:1:2504', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', '22501', '22505', '组长审批', NULL, NULL, NULL, NULL, '2019-09-16 15:35:45.564', NULL, '2019-09-16 17:32:53.801', 7028237, NULL, 50, NULL, NULL, NULL, '');
INSERT INTO `ACT_HI_TASKINST` VALUES ('25010', 'leave:1:2504', 'sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38', '25003', '25007', '经理审批', NULL, NULL, NULL, NULL, '2019-09-16 17:33:34.841', NULL, '2019-09-16 17:33:44.263', 9422, NULL, 50, NULL, NULL, NULL, '');
INSERT INTO `ACT_HI_TASKINST` VALUES ('25022', 'leave:1:2504', 'sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38', '25015', '25019', '经理审批', NULL, NULL, NULL, NULL, '2019-09-16 17:36:38.577', 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(11) NULL DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `DOUBLE_` double NULL DEFAULT NULL,
  `LONG_` bigint(20) 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 ('10002', '10001', '10001', NULL, 'initiator', 'null', 0, NULL, NULL, NULL, NULL, NULL, '2019-09-12 10:21:58.069', '2019-09-12 10:21:58.069');
INSERT INTO `ACT_HI_VARINST` VALUES ('10003', '10001', '10001', NULL, 'day', 'integer', 0, NULL, NULL, 4, '4', NULL, '2019-09-12 10:21:58.077', '2019-09-12 10:21:58.077');
INSERT INTO `ACT_HI_VARINST` VALUES ('10004', '10001', '10001', NULL, 'user', 'string', 0, NULL, NULL, NULL, 'sas', NULL, '2019-09-12 10:21:58.078', '2019-09-12 10:21:58.078');
INSERT INTO `ACT_HI_VARINST` VALUES ('12501', '10001', '10005', '10008', 'createDate', 'date', 0, NULL, NULL, 1568256660481, NULL, NULL, '2019-09-12 10:51:01.325', '2019-09-12 10:51:01.325');
INSERT INTO `ACT_HI_VARINST` VALUES ('17510', '17509', '17509', NULL, 'initiator', 'null', 0, NULL, NULL, NULL, NULL, NULL, '2019-09-12 15:36:57.684', '2019-09-12 15:36:57.684');
INSERT INTO `ACT_HI_VARINST` VALUES ('17511', '17509', '17509', NULL, 'user', 'string', 0, NULL, NULL, NULL, '2', NULL, '2019-09-12 15:36:57.684', '2019-09-12 15:36:57.684');
INSERT INTO `ACT_HI_VARINST` VALUES ('17512', '17509', '17509', NULL, 'day', 'long', 0, NULL, NULL, 2, '2', NULL, '2019-09-12 15:36:57.684', '2019-09-12 15:36:57.684');
INSERT INTO `ACT_HI_VARINST` VALUES ('20002', '20001', '20001', NULL, 'initiator', 'null', 0, NULL, NULL, NULL, NULL, NULL, '2019-09-12 16:19:16.606', '2019-09-12 16:19:16.606');
INSERT INTO `ACT_HI_VARINST` VALUES ('20003', '20001', '20001', NULL, 'user', 'string', 0, NULL, NULL, NULL, '1', NULL, '2019-09-12 16:19:16.608', '2019-09-12 16:19:16.608');
INSERT INTO `ACT_HI_VARINST` VALUES ('20004', '20001', '20001', NULL, 'day', 'long', 0, NULL, NULL, 2, '2', NULL, '2019-09-12 16:19:16.608', '2019-09-12 16:19:16.608');
INSERT INTO `ACT_HI_VARINST` VALUES ('20012', '20011', '20011', NULL, 'initiator', 'null', 0, NULL, NULL, NULL, NULL, NULL, '2019-09-12 16:19:58.417', '2019-09-12 16:19:58.417');
INSERT INTO `ACT_HI_VARINST` VALUES ('20013', '20011', '20011', NULL, 'user', 'string', 0, NULL, NULL, NULL, '1', NULL, '2019-09-12 16:19:58.417', '2019-09-12 16:19:58.417');
INSERT INTO `ACT_HI_VARINST` VALUES ('20014', '20011', '20011', NULL, 'day', 'long', 0, NULL, NULL, 2, '2', NULL, '2019-09-12 16:19:58.417', '2019-09-12 16:19:58.417');
INSERT INTO `ACT_HI_VARINST` VALUES ('20021', '20011', '20015', '20018', 'createDate', 'date', 0, NULL, NULL, 1568276691970, NULL, NULL, '2019-09-12 16:24:52.107', '2019-09-12 16:24:52.107');
INSERT INTO `ACT_HI_VARINST` VALUES ('20023', '17509', '17513', '17516', 'createDate', 'date', 0, NULL, NULL, 1568276998424, NULL, NULL, '2019-09-12 16:29:58.506', '2019-09-12 16:29:58.506');
INSERT INTO `ACT_HI_VARINST` VALUES ('22502', '22501', '22501', NULL, 'initiator', 'null', 0, NULL, NULL, NULL, NULL, NULL, '2019-09-16 15:35:45.490', '2019-09-16 15:35:45.490');
INSERT INTO `ACT_HI_VARINST` VALUES ('22503', '22501', '22501', NULL, 'user', 'string', 0, NULL, NULL, NULL, '1', NULL, '2019-09-16 15:35:45.491', '2019-09-16 15:35:45.491');
INSERT INTO `ACT_HI_VARINST` VALUES ('22504', '22501', '22501', NULL, 'day', 'long', 0, NULL, NULL, 2, '2', NULL, '2019-09-16 15:35:45.491', '2019-09-16 15:35:45.491');
INSERT INTO `ACT_HI_VARINST` VALUES ('25001', '22501', '22505', '22508', 'createDate', 'date', 0, NULL, NULL, 1568626372692, NULL, NULL, '2019-09-16 17:32:53.343', '2019-09-16 17:32:53.343');
INSERT INTO `ACT_HI_VARINST` VALUES ('25004', '25003', '25003', NULL, 'initiator', 'null', 0, NULL, NULL, NULL, NULL, NULL, '2019-09-16 17:33:34.779', '2019-09-16 17:33:34.779');
INSERT INTO `ACT_HI_VARINST` VALUES ('25005', '25003', '25003', NULL, 'user', 'string', 0, NULL, NULL, NULL, '1', NULL, '2019-09-16 17:33:34.780', '2019-09-16 17:33:34.780');
INSERT INTO `ACT_HI_VARINST` VALUES ('25006', '25003', '25003', NULL, 'day', 'long', 0, NULL, NULL, 9, '9', NULL, '2019-09-16 17:33:34.780', '2019-09-16 17:33:34.780');
INSERT INTO `ACT_HI_VARINST` VALUES ('25013', '25003', '25007', '25010', 'createDate', 'date', 0, NULL, NULL, 1568626423721, NULL, NULL, '2019-09-16 17:33:43.807', '2019-09-16 17:33:43.807');
INSERT INTO `ACT_HI_VARINST` VALUES ('25016', '25015', '25015', NULL, 'initiator', 'null', 0, NULL, NULL, NULL, NULL, NULL, '2019-09-16 17:36:38.576', '2019-09-16 17:36:38.576');
INSERT INTO `ACT_HI_VARINST` VALUES ('25017', '25015', '25015', NULL, 'user', 'string', 0, NULL, NULL, NULL, '1', NULL, '2019-09-16 17:36:38.576', '2019-09-16 17:36:38.576');
INSERT INTO `ACT_HI_VARINST` VALUES ('25018', '25015', '25015', NULL, 'day', 'long', 0, NULL, NULL, 16, '16', NULL, '2019-09-16 17:36:38.576', '2019-09-16 17:36:38.576');

-- ----------------------------
-- Table structure for ACT_ID_GROUP
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_GROUP`;
CREATE TABLE `ACT_ID_GROUP`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(11) NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TYPE_` 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_ID_GROUP
-- ----------------------------
INSERT INTO `ACT_ID_GROUP` VALUES ('ROLE_ADMIN', 1, 'Superusers', 'security-role');

-- ----------------------------
-- Table structure for ACT_ID_INFO
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_INFO`;
CREATE TABLE `ACT_ID_INFO`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(11) NULL DEFAULT NULL,
  `USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `VALUE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PASSWORD_` longblob NULL,
  `PARENT_ID_` 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;

-- ----------------------------
-- Table structure for ACT_ID_MEMBERSHIP
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_MEMBERSHIP`;
CREATE TABLE `ACT_ID_MEMBERSHIP`  (
  `USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `GROUP_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`USER_ID_`, `GROUP_ID_`) USING BTREE,
  INDEX `ACT_FK_MEMB_GROUP`(`GROUP_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_ID_MEMBERSHIP
-- ----------------------------
INSERT INTO `ACT_ID_MEMBERSHIP` VALUES ('admin', 'ROLE_ADMIN');

-- ----------------------------
-- Table structure for ACT_ID_USER
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_USER`;
CREATE TABLE `ACT_ID_USER`  (
  `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `REV_` int(11) NULL DEFAULT NULL,
  `FIRST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `LAST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `EMAIL_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PWD_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `PICTURE_ID_` varchar(64) 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_ID_USER
-- ----------------------------
INSERT INTO `ACT_ID_USER` VALUES ('admin', 1, NULL, 'Administrator', 'admin', 'test', NULL);

-- ----------------------------
-- Table structure for ACT_IDM_PERSISTENT_TOKEN
-- ----------------------------
DROP TABLE IF EXISTS `ACT_IDM_PERSISTENT_TOKEN`;
CREATE TABLE `ACT_IDM_PERSISTENT_TOKEN`  (
  `series` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `token_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `token_date` datetime(6) NULL DEFAULT NULL,
  `ip_address` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`series`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ACT_IDM_PERSISTENT_TOKEN
-- ----------------------------
INSERT INTO `ACT_IDM_PERSISTENT_TOKEN` VALUES ('WlXyomj1jalcg34KCHFePA==', 'admin', 'wEm4WL3r+SRsl4IaNU0u1g==', '2019-09-11 18:39:03.424000', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3887.7 Safari/537.36');

-- ----------------------------
-- 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(11) 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;

-- ----------------------------
-- 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,
  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 ('2501', '请假流程', NULL, 'leave', '', '2019-09-11 18:44:43.970', 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(11) 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(11) 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;

-- ----------------------------
-- 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(11) 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(11) 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(4) NULL DEFAULT NULL,
  `HAS_GRAPHICAL_NOTATION_` tinyint(4) NULL DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) 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,
  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:1:2504', 1, 'http://www.activiti.org/processdef', '请假流程', 'leave', 1, '2501', 'leave.bpmn', 'leave.leave.png', '定义请假流程', 0, 1, 1, '', 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(11) 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_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_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
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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(11) 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;

-- ----------------------------
-- 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(11) 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(4) NULL DEFAULT NULL,
  `IS_CONCURRENT_` tinyint(4) NULL DEFAULT NULL,
  `IS_SCOPE_` tinyint(4) NULL DEFAULT NULL,
  `IS_EVENT_SCOPE_` tinyint(4) NULL DEFAULT NULL,
  `IS_MI_ROOT_` tinyint(4) NULL DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) NULL DEFAULT NULL,
  `CACHED_ENT_STATE_` int(11) 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(4) NULL DEFAULT NULL,
  `EVT_SUBSCR_COUNT_` int(11) NULL DEFAULT NULL,
  `TASK_COUNT_` int(11) NULL DEFAULT NULL,
  `JOB_COUNT_` int(11) NULL DEFAULT NULL,
  `TIMER_JOB_COUNT_` int(11) NULL DEFAULT NULL,
  `SUSP_JOB_COUNT_` int(11) NULL DEFAULT NULL,
  `DEADLETTER_JOB_COUNT_` int(11) NULL DEFAULT NULL,
  `VAR_COUNT_` int(11) NULL DEFAULT NULL,
  `ID_LINK_COUNT_` int(11) 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 ('20001', 1, '20001', NULL, NULL, 'leave:1:2504', NULL, '20001', NULL, 1, 0, 1, 0, 0, 1, NULL, '', NULL, '2019-09-12 16:19:16.374', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `ACT_RU_EXECUTION` VALUES ('20005', 1, '20001', NULL, '20001', 'leave:1:2504', NULL, '20001', 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', 1, 0, 0, 0, 0, 1, NULL, '', NULL, '2019-09-12 16:19:16.608', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `ACT_RU_EXECUTION` VALUES ('25015', 1, '25015', NULL, NULL, 'leave:1:2504', NULL, '25015', NULL, 1, 0, 1, 0, 0, 1, NULL, '', NULL, '2019-09-16 17:36:38.576', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `ACT_RU_EXECUTION` VALUES ('25019', 1, '25015', NULL, '25015', 'leave:1:2504', NULL, '25015', 'sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38', 1, 0, 0, 0, 0, 1, NULL, '', NULL, '2019-09-16 17:36:38.576', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- ----------------------------
-- 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(11) 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 ('20009', 1, NULL, 'candidate', '1', '20008', NULL, NULL);
INSERT INTO `ACT_RU_IDENTITYLINK` VALUES ('20010', 1, NULL, 'participant', '1', NULL, '20001', NULL);
INSERT INTO `ACT_RU_IDENTITYLINK` VALUES ('25023', 1, NULL, 'candidate', '1', '25022', NULL, NULL);
INSERT INTO `ACT_RU_IDENTITYLINK` VALUES ('25024', 1, NULL, 'participant', '1', NULL, '25015', NULL);

-- ----------------------------
-- 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(11) 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(11) 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_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_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
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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(11) 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(11) 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_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_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
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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(11) 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,
  `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(11) 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(11) 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,
  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 ('20008', 1, '20005', '20001', 'leave:1:2504', '组长审批', NULL, NULL, 'sid-E167CA0B-A3BD-41CA-B1B0-A7BADD26F683', NULL, NULL, NULL, 50, '2019-09-12 16:19:16.679', NULL, NULL, 1, '', NULL, NULL);
INSERT INTO `ACT_RU_TASK` VALUES ('25022', 1, '25019', '25015', 'leave:1:2504', '经理审批', NULL, NULL, 'sid-7ADEED7B-03E9-42DD-B818-38D04C02DB38', NULL, NULL, NULL, 50, '2019-09-16 17:36:38.577', NULL, NULL, 1, '', 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(11) 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(11) 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_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_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
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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(11) 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(20) 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 ('20002', 1, 'null', 'initiator', '20001', '20001', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `ACT_RU_VARIABLE` VALUES ('20003', 1, 'string', 'user', '20001', '20001', NULL, NULL, NULL, NULL, '1', NULL);
INSERT INTO `ACT_RU_VARIABLE` VALUES ('20004', 1, 'long', 'day', '20001', '20001', NULL, NULL, NULL, 2, '2', NULL);
INSERT INTO `ACT_RU_VARIABLE` VALUES ('25016', 1, 'null', 'initiator', '25015', '25015', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `ACT_RU_VARIABLE` VALUES ('25017', 1, 'string', 'user', '25015', '25015', NULL, NULL, NULL, NULL, '1', NULL);
INSERT INTO `ACT_RU_VARIABLE` VALUES ('25018', 1, 'long', 'day', '25015', '25015', NULL, NULL, NULL, 16, '16', NULL);

-- ----------------------------
-- Table structure for ACT_WO_COMMENTS
-- ----------------------------
DROP TABLE IF EXISTS `ACT_WO_COMMENTS`;
CREATE TABLE `ACT_WO_COMMENTS`  (
  `id` bigint(20) NOT NULL,
  `message` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created` timestamp(6) NULL DEFAULT NULL,
  `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `task_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `proc_inst_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `comment_definition` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `comment_task_created`(`task_id`, `created`) USING BTREE,
  INDEX `comment_proc_created`(`proc_inst_id`, `created`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ACT_WO_RELATED_CONTENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_WO_RELATED_CONTENT`;
CREATE TABLE `ACT_WO_RELATED_CONTENT`  (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created` timestamp(6) NULL DEFAULT NULL,
  `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `task_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `process_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `source_id` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `store_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `related_content` bit(1) NOT NULL,
  `link` bit(1) NOT NULL,
  `link_url` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content_available` bit(1) NULL DEFAULT b'0',
  `locked` bit(1) NULL DEFAULT b'0',
  `lock_date` timestamp(6) NULL DEFAULT NULL,
  `lock_exp_date` timestamp(6) NULL DEFAULT NULL,
  `lock_owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `checked_out` bit(1) NULL DEFAULT b'0',
  `checkout_date` timestamp(6) NULL DEFAULT NULL,
  `checkout_owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `last_modified` timestamp(6) NULL DEFAULT NULL,
  `last_modified_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `checked_out_to_local` bit(1) NULL DEFAULT b'0',
  `content_size` bigint(20) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_relcont_createdby`(`created_by`) USING BTREE,
  INDEX `idx_relcont_taskid`(`task_id`) USING BTREE,
  INDEX `idx_relcont_procid`(`process_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for hibernate_sequences
-- ----------------------------
DROP TABLE IF EXISTS `hibernate_sequences`;
CREATE TABLE `hibernate_sequences`  (
  `sequence_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sequence_next_hi_value` int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for license_event
-- ----------------------------
DROP TABLE IF EXISTS `license_event`;
CREATE TABLE `license_event`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `license_id` bigint(20) NOT NULL COMMENT '事项',
  `license_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事项名称',
  `account_id` bigint(20) NOT NULL COMMENT '申请人',
  `account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请人名称',
  `start_time` datetime(0) NOT NULL COMMENT '申请时间',
  `approve_id` bigint(20) NOT NULL COMMENT '审批人',
  `approve_time` datetime(0) NULL DEFAULT NULL COMMENT '审批时间',
  `status_id` bigint(20) NOT NULL COMMENT '状态',
  `status_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态名称',
  `form_id` bigint(20) NOT NULL COMMENT '表单id',
  `work_flow_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程id',
  `is_deleted` bit(1) NOT NULL,
  `creator` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `mender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '流程事项' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of license_event
-- ----------------------------
INSERT INTO `license_event` VALUES (1, 1, '请假流程', 1, '18512345671', '2019-09-12 15:37:16', 1, '2019-09-12 16:30:01', 2, '审批驳回', 3, '17509', b'0', '18512345671', '2019-09-12 15:37:19', 'handy', '2019-09-12 16:30:01');
INSERT INTO `license_event` VALUES (2, 1, '请假流程', 2, '18512345672', '2019-09-12 16:19:59', 1, '2019-09-12 16:25:05', 3, '审批通过', 5, '20011', b'0', '18512345672', '2019-09-12 16:19:59', 'handy', '2019-09-12 16:25:08');
INSERT INTO `license_event` VALUES (3, 1, '请假流程', 1, 'handy', '2019-09-16 15:35:46', 1, '2019-09-16 17:32:55', 3, '审批通过', 6, '22501', b'0', '18512345671', '2019-09-16 15:35:46', 'handy', '2019-09-16 17:32:55');
INSERT INTO `license_event` VALUES (4, 1, '请假流程', 1, 'handy', '2019-09-16 17:33:35', 1, '2019-09-16 17:33:46', 2, '审批驳回', 7, '25003', b'0', '18512345671', '2019-09-16 17:33:35', 'handy', '2019-09-16 17:33:46');
INSERT INTO `license_event` VALUES (5, 1, '请假流程', 1, 'handy', '2019-09-16 17:36:39', 1, NULL, 1, '待审批', 8, '25015', b'0', '18512345671', '2019-09-16 17:36:39', NULL, NULL);

-- ----------------------------
-- Table structure for license_form
-- ----------------------------
DROP TABLE IF EXISTS `license_form`;
CREATE TABLE `license_form`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `start_time` datetime(0) NOT NULL,
  `end_time` datetime(0) NOT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_deleted` bit(1) NOT NULL,
  `creator` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `mender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '请假表单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of license_form
-- ----------------------------
INSERT INTO `license_form` VALUES (3, '2019-09-12 00:00:00', '2019-09-14 00:00:00', '请假', b'0', '18512345671', '2019-09-12 15:36:55', NULL, NULL);
INSERT INTO `license_form` VALUES (4, '2019-09-12 00:00:00', '2019-09-14 00:00:00', '请假', b'0', '18512345672', '2019-09-12 16:19:16', NULL, NULL);
INSERT INTO `license_form` VALUES (5, '2019-09-12 00:00:00', '2019-09-14 00:00:00', '请假', b'0', '18512345672', '2019-09-12 16:19:58', NULL, NULL);
INSERT INTO `license_form` VALUES (6, '2019-09-12 00:00:00', '2019-09-14 00:00:00', '', b'0', '18512345671', '2019-09-16 15:35:45', NULL, NULL);
INSERT INTO `license_form` VALUES (7, '2019-09-11 00:00:00', '2019-09-20 00:00:00', '', b'0', '18512345671', '2019-09-16 17:33:35', NULL, NULL);
INSERT INTO `license_form` VALUES (8, '2019-09-11 00:00:00', '2019-09-27 00:00:00', '', b'0', '18512345671', '2019-09-16 17:36:38', NULL, NULL);

-- ----------------------------
-- Table structure for license_setting
-- ----------------------------
DROP TABLE IF EXISTS `license_setting`;
CREATE TABLE `license_setting`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作流名称',
  `work_flow_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作流key',
  `is_deleted` bit(1) NOT NULL,
  `creator` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `mender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '流程信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of license_setting
-- ----------------------------
INSERT INTO `license_setting` VALUES (1, '请假流程', 'leave', b'0', 'hs', '2019-09-12 14:52:19', NULL, NULL);

-- ----------------------------
-- Table structure for log_login
-- ----------------------------
DROP TABLE IF EXISTS `log_login`;
CREATE TABLE `log_login`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `account_id` bigint(11) NOT NULL COMMENT '用户id',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '帐号',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ip地址',
  `category_id` bigint(11) NULL DEFAULT NULL COMMENT '分类id',
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类name',
  `is_deleted` bit(1) NOT NULL COMMENT '逻辑删除',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '登录日志' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of log_login
-- ----------------------------
INSERT INTO `log_login` VALUES (1, 1, '18512345671', 'handy', '58.246.141.21', 1, '密码登录', b'0', '2019-09-08 19:20:39');
INSERT INTO `log_login` VALUES (2, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-08 19:50:23');
INSERT INTO `log_login` VALUES (3, 1, '18512345671', 'handy', '58.246.143.53', 1, '密码登录', b'0', '2019-09-09 10:13:18');
INSERT INTO `log_login` VALUES (4, 1, '18512345671', 'handy', '58.246.141.183', 1, '密码登录', b'0', '2019-09-09 14:21:32');
INSERT INTO `log_login` VALUES (5, 1, '18512345671', 'handy', '58.246.143.53', 1, '密码登录', b'0', '2019-09-09 17:58:21');
INSERT INTO `log_login` VALUES (6, 1, '18512345671', 'handy', '58.246.141.183', 1, '密码登录', b'0', '2019-09-09 18:01:44');
INSERT INTO `log_login` VALUES (7, 1, '18512345671', 'handy', '58.246.141.183', 1, '密码登录', b'0', '2019-09-09 18:26:41');
INSERT INTO `log_login` VALUES (8, 2, '13546606929', '13546606929', '58.246.143.25', 0, '注册登录', b'0', '2019-09-10 11:58:18');
INSERT INTO `log_login` VALUES (9, 2, '13546606929', '13546606929', '58.246.143.25', 1, '密码登录', b'0', '2019-09-10 12:00:29');
INSERT INTO `log_login` VALUES (10, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-10 12:06:17');
INSERT INTO `log_login` VALUES (11, 2, '13546606929', '13546606929', '58.246.143.25', 1, '密码登录', b'0', '2019-09-10 12:08:03');
INSERT INTO `log_login` VALUES (12, 1, '18512345671', 'handy', '58.246.143.25', 1, '密码登录', b'0', '2019-09-10 12:08:17');
INSERT INTO `log_login` VALUES (13, 1, '18512345671', 'handy', '58.246.140.203', 1, '密码登录', b'0', '2019-09-10 18:53:05');
INSERT INTO `log_login` VALUES (14, 1, '18512345671', 'handy', '58.246.140.203', 1, '密码登录', b'0', '2019-09-10 18:53:13');
INSERT INTO `log_login` VALUES (15, 1, '18512345671', 'handy', '58.246.140.203', 1, '密码登录', b'0', '2019-09-10 19:09:23');
INSERT INTO `log_login` VALUES (16, 1, '18512345671', 'handy', '58.246.140.203', 1, '密码登录', b'0', '2019-09-10 19:12:53');
INSERT INTO `log_login` VALUES (17, 1, '18512345671', 'handy', '58.246.141.212', 1, '密码登录', b'0', '2019-09-11 09:30:31');
INSERT INTO `log_login` VALUES (18, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-11 18:32:46');
INSERT INTO `log_login` VALUES (19, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-11 18:46:46');
INSERT INTO `log_login` VALUES (20, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-11 18:53:36');
INSERT INTO `log_login` VALUES (21, 1, '18512345671', 'handy', '183.209.34.234', 1, '密码登录', b'0', '2019-09-11 19:14:05');
INSERT INTO `log_login` VALUES (22, 1, '18512345671', 'handy', '183.209.34.234', 1, '密码登录', b'0', '2019-09-11 19:16:29');
INSERT INTO `log_login` VALUES (23, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 10:08:33');
INSERT INTO `log_login` VALUES (24, 1, '18512345671', 'handy', '0:0:0:0:0:0:0:1', 1, '密码登录', b'0', '2019-09-12 10:19:30');
INSERT INTO `log_login` VALUES (25, 1, '18512345671', 'handy', '0:0:0:0:0:0:0:1', 1, '密码登录', b'0', '2019-09-12 10:21:44');
INSERT INTO `log_login` VALUES (26, 1, '18512345671', 'handy', '0:0:0:0:0:0:0:1', 1, '密码登录', b'0', '2019-09-12 10:48:17');
INSERT INTO `log_login` VALUES (27, 1, '18512345671', 'handy', '0:0:0:0:0:0:0:1', 1, '密码登录', b'0', '2019-09-12 10:50:15');
INSERT INTO `log_login` VALUES (28, 1, '18512345671', 'handy', '114.221.79.77', 1, '密码登录', b'0', '2019-09-12 10:53:21');
INSERT INTO `log_login` VALUES (29, 1, '18512345671', 'handy', '58.246.142.5', 1, '密码登录', b'0', '2019-09-12 11:25:42');
INSERT INTO `log_login` VALUES (30, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 12:21:52');
INSERT INTO `log_login` VALUES (31, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 12:22:14');
INSERT INTO `log_login` VALUES (32, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 12:24:00');
INSERT INTO `log_login` VALUES (33, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 12:30:37');
INSERT INTO `log_login` VALUES (34, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 12:34:03');
INSERT INTO `log_login` VALUES (35, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 12:44:16');
INSERT INTO `log_login` VALUES (36, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 12:44:57');
INSERT INTO `log_login` VALUES (37, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 13:06:25');
INSERT INTO `log_login` VALUES (38, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 13:16:16');
INSERT INTO `log_login` VALUES (39, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 13:18:35');
INSERT INTO `log_login` VALUES (40, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 13:35:08');
INSERT INTO `log_login` VALUES (41, 1, '18512345671', 'handy', '58.246.142.5', 1, '密码登录', b'0', '2019-09-12 15:23:23');
INSERT INTO `log_login` VALUES (42, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 15:29:38');
INSERT INTO `log_login` VALUES (43, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 15:34:44');
INSERT INTO `log_login` VALUES (44, 2, '18512345672', '18512345672', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 15:38:12');
INSERT INTO `log_login` VALUES (45, 2, '18512345672', '18512345672', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 15:38:47');
INSERT INTO `log_login` VALUES (46, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 16:18:14');
INSERT INTO `log_login` VALUES (47, 2, '18512345672', '18512345672', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 16:18:29');
INSERT INTO `log_login` VALUES (48, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-12 16:20:12');
INSERT INTO `log_login` VALUES (49, 1, '18512345671', 'handy', '58.246.141.201', 1, '密码登录', b'0', '2019-09-12 16:43:13');
INSERT INTO `log_login` VALUES (50, 1, '18512345671', 'handy', '220.112.125.179', 1, '密码登录', b'0', '2019-09-15 17:30:34');
INSERT INTO `log_login` VALUES (51, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-16 14:58:04');
INSERT INTO `log_login` VALUES (52, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-16 15:31:54');
INSERT INTO `log_login` VALUES (53, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-16 16:26:05');
INSERT INTO `log_login` VALUES (54, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-16 16:48:14');
INSERT INTO `log_login` VALUES (55, 1, '18512345671', 'handy', '127.0.0.1', 1, '密码登录', b'0', '2019-09-16 17:32:31');

-- ----------------------------
-- Table structure for msg_message
-- ----------------------------
DROP TABLE IF EXISTS `msg_message`;
CREATE TABLE `msg_message`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `account_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `category` bigint(20) NULL DEFAULT NULL COMMENT '类型',
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息标题',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '消息内容',
  `is_deleted` bit(1) NOT NULL,
  `creator` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `mender` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of msg_message
-- ----------------------------
INSERT INTO `msg_message` VALUES (1, 1, 1, '测试消息', '通知:发奖励了', '内容很牛逼</br>真的', b'0', 'hs', '2019-09-06 15:01:28', NULL, NULL);
INSERT INTO `msg_message` VALUES (2, 1, 1, '测试消息', '欢迎来到rapid-boot世界', '欢迎来到rapid-boot世界', b'0', 'hs', '2019-09-10 12:06:09', NULL, NULL);

-- ----------------------------
-- Table structure for msg_record
-- ----------------------------
DROP TABLE IF EXISTS `msg_record`;
CREATE TABLE `msg_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识-主键',
  `category` bigint(20) NOT NULL COMMENT '类型（1.注册，2.找回密码等）',
  `category_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '短信内容',
  `sent_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间',
  `result` bit(1) NULL DEFAULT NULL COMMENT '结果',
  `result_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结果描述',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '验证码记录' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of msg_record
-- ----------------------------
INSERT INTO `msg_record` VALUES (1, 2, '登录验证码', '18512345672', '290576', '2019-09-10 11:45:05', b'1', '{\"Message\":\"OK\",\"RequestId\":\"CBD238AC-4B69-4951-9368-30694691295E\",\"BizId\":\"927002968087104732^0\",\"Code\":\"OK\"}', '2019-09-10 11:45:05');
INSERT INTO `msg_record` VALUES (2, 2, '登录验证码', '18512345672', '848828', '2019-09-10 11:57:31', b'1', '{\"Message\":\"OK\",\"RequestId\":\"FA69C900-464F-456B-AF3C-05146AE49BAB\",\"BizId\":\"816712468087851087^0\",\"Code\":\"OK\"}', '2019-09-10 11:57:31');
INSERT INTO `msg_record` VALUES (3, 1, '注册验证码', '18512345672', '150702', '2019-09-10 11:58:03', b'1', '{\"Message\":\"OK\",\"RequestId\":\"56CA20EC-DC3E-47D4-A114-CE758D551629\",\"BizId\":\"598413268087882704^0\",\"Code\":\"OK\"}', '2019-09-10 11:58:03');

-- ----------------------------
-- Table structure for schedule_task
-- ----------------------------
DROP TABLE IF EXISTS `schedule_task`;
CREATE TABLE `schedule_task`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `job_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述任务',
  `cron` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务表达式',
  `status` tinyint(1) NOT NULL COMMENT '状态:0未启动false/1启动true',
  `clazz_path_id` bigint(20) NOT NULL COMMENT '任务执行方法id',
  `clazz_path_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务执行方法name',
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其他描述',
  `is_deleted` bit(1) NOT NULL,
  `creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `mender` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `modify_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of schedule_task
-- ----------------------------
INSERT INTO `schedule_task` VALUES (1, '测试1号', '0 0 0/1 * * ?', 1, 1, 'com.handy.task.MsgDelTask', '一小时一次', b'0', '18512345671', '2019-09-06 10:34:05', '18512345671', '2019-09-08 14:12:55');
INSERT INTO `schedule_task` VALUES (2, '测试2号', '0 0/5 * * * ?', 1, 0, 'com.handy.task.MsgTask', '5分钟执行一次', b'0', '18512345671', '2019-09-06 10:37:17', '18512345671', '2019-09-08 14:12:46');
INSERT INTO `schedule_task` VALUES (3, '测试3号', '0 0 0/1 * * ?', 0, 1, 'com.handy.task.MsgDelTask', '一小时一次', b'0', '18512345671', '2019-09-06 17:56:39', '18512345671', '2019-09-08 14:12:36');
INSERT INTO `schedule_task` VALUES (4, '测试4号', '0/1 * * * * ?', 0, 1, 'com.handy.task.MsgDelTask', '一秒执行一次', b'0', '18512345671', '2019-09-08 14:11:53', '18512345671', '2019-09-08 14:13:09');

-- ----------------------------
-- Table structure for sys_account
-- ----------------------------
DROP TABLE IF EXISTS `sys_account`;
CREATE TABLE `sys_account`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账号',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `sex` bit(1) NULL DEFAULT NULL COMMENT '(1:男,0:女)',
  `birth_data` datetime(0) NULL DEFAULT NULL COMMENT '出生日期',
  `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `password` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电子邮箱',
  `is_locked` bit(1) NOT NULL COMMENT '是否锁定（0:未锁定;1:已锁定）',
  `login_count` int(11) NULL DEFAULT NULL COMMENT '登录次数',
  `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登录时间',
  `note` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `is_deleted` bit(1) NOT NULL COMMENT '逻辑删除',
  `creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `mender` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后修改者',
  `modify_time` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统账户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_account
-- ----------------------------
INSERT INTO `sys_account` VALUES (1, '18512345671', 'handy', b'1', '2019-08-27 00:00:00', 'http://rapid-boot.oss-cn-hangzhou.aliyuncs.com/201909/jpeg/20190908122031.jpeg?Expires=1883276432&OSSAccessKeyId=LTAInLUy8ia23gd5&Signature=pb0c6zgHTUe4QZmn2PuQBHoRkZk%3D', 'afdd0b4ad2ec172c586e2150770fbf9e', 'shljhs@foxmail.com', b'0', 294, '2019-09-16 17:32:31', '开发用户', b'0', '18512345671', '2019-08-18 12:43:06', NULL, '2019-09-16 17:32:31');
INSERT INTO `sys_account` VALUES (2, '18512345672', '18512345672', NULL, NULL, '/images/logo.png', 'e10adc3949ba59abbe56e057f20f883e', '', b'0', 6, '2019-09-12 16:18:29', '', b'0', '13546606929', '2019-09-10 11:58:17', NULL, '2019-09-12 16:18:29');
INSERT INTO `sys_account` VALUES (3, '18512345673', '18512345673', NULL, NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, b'0', NULL, NULL, NULL, b'0', NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) NOT NULL COMMENT '角色标识',
  `submenu_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单标识',
  `note` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `is_deleted` bit(1) NOT NULL COMMENT '逻辑删除',
  `creator` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `mender` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后修改者',
  `modify_time` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 512 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色权限' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
INSERT INTO `sys_permission` VALUES (65, 4, 7, NULL, b'0', '18512345671', '2019-09-01 12:19:37', NULL, NULL);
INSERT INTO `sys_permission` VALUES (66, 4, 8, NULL, b'0', '18512345671', '2019-09-01 12:19:37', NULL, NULL);
INSERT INTO `sys_permission` VALUES (67, 4, 9, NULL, b'0', '18512345671', '2019-09-01 12:19:37', NULL, NULL);
INSERT INTO `sys_permission` VALUES (68, 4, 24, NULL, b'0', '18512345671', '2019-09-01 12:19:37', NULL, NULL);
INSERT INTO `sys_permission` VALUES (69, 4, 25, NULL, b'0', '18512345671', '2019-09-01 12:19:37', NULL, NULL);
INSERT INTO `sys_permission` VALUES (70, 4, 26, NULL, b'0', '18512345671', '2019-09-01 12:19:37', NULL, NULL);
INSERT INTO `sys_permission` VALUES (71, 4, 27, NULL, b'0', '18512345671', '2019-09-01 12:19:37', NULL, NULL);
INSERT INTO `sys_permission` VALUES (111, 6, 1, NULL, b'0', '18512345671', '2019-09-01 13:16:02', NULL, NULL);
INSERT INTO `sys_permission` VALUES (112, 6, 2, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (113, 6, 3, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (114, 6, 4, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (115, 6, 5, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (116, 6, 6, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (117, 6, 12, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (118, 6, 13, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (119, 6, 14, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (120, 6, 15, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (121, 6, 16, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (122, 6, 17, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (123, 6, 18, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (124, 6, 19, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (125, 6, 20, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (126, 6, 21, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (127, 6, 22, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (128, 6, 23, NULL, b'0', '18512345671', '2019-09-01 13:16:03', NULL, NULL);
INSERT INTO `sys_permission` VALUES (249, 1, 1, NULL, b'1', '18512345671', '2019-09-05 16:49:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (250, 1, 2, NULL, b'1', '18512345671', '2019-09-05 16:49:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (251, 1, 3, NULL, b'1', '18512345671', '2019-09-05 16:49:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (252, 1, 4, NULL, b'1', '18512345671', '2019-09-05 16:49:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (253, 1, 5, NULL, b'1', '18512345671', '2019-09-05 16:49:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (254, 1, 6, NULL, b'1', '18512345671', '2019-09-05 16:49:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (255, 1, 12, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (256, 1, 13, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (257, 1, 14, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (258, 1, 15, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (259, 1, 16, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (260, 1, 17, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (261, 1, 18, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (262, 1, 19, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (263, 1, 20, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (264, 1, 21, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (265, 1, 22, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (266, 1, 23, NULL, b'1', '18512345671', '2019-09-05 16:49:33', NULL, NULL);
INSERT INTO `sys_permission` VALUES (267, 1, 7, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (268, 1, 8, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (269, 1, 9, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (270, 1, 24, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (271, 1, 25, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (272, 1, 26, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (273, 1, 27, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (274, 1, 10, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (275, 1, 11, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (276, 1, 28, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (277, 1, 29, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (278, 1, 30, NULL, b'1', '18512345671', '2019-09-05 16:49:34', NULL, NULL);
INSERT INTO `sys_permission` VALUES (279, 1, 31, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (280, 1, 32, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (281, 1, 33, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (282, 1, 34, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (283, 1, 35, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (284, 1, 36, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (285, 1, 39, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (286, 1, 37, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (287, 1, 38, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (288, 1, 40, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (289, 1, 41, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (290, 1, 42, NULL, b'1', '18512345671', '2019-09-05 16:49:35', NULL, NULL);
INSERT INTO `sys_permission` VALUES (301, 5, 10, NULL, b'0', '18512345671', '2019-09-08 14:16:20', NULL, NULL);
INSERT INTO `sys_permission` VALUES (302, 5, 11, NULL, b'0', '18512345671', '2019-09-08 14:16:20', NULL, NULL);
INSERT INTO `sys_permission` VALUES (303, 5, 28, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (304, 5, 29, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (305, 5, 30, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (306, 5, 31, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (307, 5, 32, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (308, 5, 33, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (309, 5, 34, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (310, 5, 35, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (311, 5, 36, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (312, 5, 39, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (313, 5, 37, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (314, 5, 38, NULL, b'0', '18512345671', '2019-09-08 14:16:21', NULL, NULL);
INSERT INTO `sys_permission` VALUES (325, 2, 33, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (326, 2, 34, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (327, 2, 35, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (328, 2, 36, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (329, 2, 39, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (330, 2, 37, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (331, 2, 38, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (332, 2, 40, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (333, 2, 41, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (334, 2, 42, NULL, b'0', '18512345671', '2019-09-08 14:16:46', NULL, NULL);
INSERT INTO `sys_permission` VALUES (345, 7, 1, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (346, 7, 2, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (347, 7, 3, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (348, 7, 4, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (349, 7, 5, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (350, 7, 6, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (351, 7, 12, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (352, 7, 13, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (353, 7, 14, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (354, 7, 15, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (355, 7, 16, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (356, 7, 17, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (357, 7, 18, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (358, 7, 19, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (359, 7, 20, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (360, 7, 21, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (361, 7, 22, NULL, b'1', '18512345671', '2019-09-08 17:28:31', NULL, NULL);
INSERT INTO `sys_permission` VALUES (362, 7, 23, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (363, 7, 7, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (364, 7, 8, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (365, 7, 9, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (366, 7, 24, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (367, 7, 25, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (368, 7, 26, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (369, 7, 27, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (370, 7, 10, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (371, 7, 11, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (372, 7, 28, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (373, 7, 29, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (374, 7, 30, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (375, 7, 31, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (376, 7, 32, NULL, b'1', '18512345671', '2019-09-08 17:28:32', NULL, NULL);
INSERT INTO `sys_permission` VALUES (377, 7, 1, NULL, b'0', '18512345671', '2019-09-09 18:26:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (378, 7, 2, NULL, b'0', '18512345671', '2019-09-09 18:26:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (379, 7, 3, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (380, 7, 4, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (381, 7, 5, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (382, 7, 6, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (383, 7, 12, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (384, 7, 13, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (385, 7, 14, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (386, 7, 15, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (387, 7, 16, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (388, 7, 17, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (389, 7, 18, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (390, 7, 19, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (391, 7, 20, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (392, 7, 21, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (393, 7, 22, NULL, b'0', '18512345671', '2019-09-09 18:26:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (394, 7, 23, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (395, 7, 7, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (396, 7, 8, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (397, 7, 9, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (398, 7, 24, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (399, 7, 25, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (400, 7, 26, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (401, 7, 27, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (402, 7, 10, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (403, 7, 11, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (404, 7, 28, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (405, 7, 29, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (406, 7, 30, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (407, 7, 31, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (408, 7, 32, NULL, b'0', '18512345671', '2019-09-09 18:26:53', NULL, NULL);
INSERT INTO `sys_permission` VALUES (409, 7, 33, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (410, 7, 34, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (411, 7, 35, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (412, 7, 36, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (413, 7, 39, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (414, 7, 37, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (415, 7, 38, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (416, 7, 40, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (417, 7, 41, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (418, 7, 42, NULL, b'0', '18512345671', '2019-09-09 18:26:54', NULL, NULL);
INSERT INTO `sys_permission` VALUES (419, 1, 1, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (420, 1, 2, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (421, 1, 3, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (422, 1, 4, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (423, 1, 5, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (424, 1, 6, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (425, 1, 12, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (426, 1, 13, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (427, 1, 14, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (428, 1, 15, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (429, 1, 16, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (430, 1, 17, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (431, 1, 18, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (432, 1, 19, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (433, 1, 20, NULL, b'1', '18512345671', '2019-09-12 12:22:07', NULL, NULL);
INSERT INTO `sys_permission` VALUES (434, 1, 21, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (435, 1, 22, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (436, 1, 23, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (437, 1, 7, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (438, 1, 8, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (439, 1, 9, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (440, 1, 24, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (441, 1, 25, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (442, 1, 26, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (443, 1, 27, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (444, 1, 10, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (445, 1, 11, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (446, 1, 28, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (447, 1, 29, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (448, 1, 30, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (449, 1, 31, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (450, 1, 32, NULL, b'1', '18512345671', '2019-09-12 12:22:08', NULL, NULL);
INSERT INTO `sys_permission` VALUES (451, 1, 33, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (452, 1, 34, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (453, 1, 35, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (454, 1, 36, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (455, 1, 39, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (456, 1, 37, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (457, 1, 38, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (458, 1, 40, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (459, 1, 41, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (460, 1, 42, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (461, 1, 43, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (462, 1, 44, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (463, 1, 45, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (464, 1, 46, NULL, b'1', '18512345671', '2019-09-12 12:22:09', NULL, NULL);
INSERT INTO `sys_permission` VALUES (465, 1, 1, NULL, b'0', '18512345671', '2019-09-12 12:44:49', NULL, NULL);
INSERT INTO `sys_permission` VALUES (466, 1, 2, NULL, b'0', '18512345671', '2019-09-12 12:44:49', NULL, NULL);
INSERT INTO `sys_permission` VALUES (467, 1, 3, NULL, b'0', '18512345671', '2019-09-12 12:44:49', NULL, NULL);
INSERT INTO `sys_permission` VALUES (468, 1, 4, NULL, b'0', '18512345671', '2019-09-12 12:44:49', NULL, NULL);
INSERT INTO `sys_permission` VALUES (469, 1, 5, NULL, b'0', '18512345671', '2019-09-12 12:44:49', NULL, NULL);
INSERT INTO `sys_permission` VALUES (470, 1, 6, NULL, b'0', '18512345671', '2019-09-12 12:44:49', NULL, NULL);
INSERT INTO `sys_permission` VALUES (471, 1, 12, NULL, b'0', '18512345671', '2019-09-12 12:44:49', NULL, NULL);
INSERT INTO `sys_permission` VALUES (472, 1, 13, NULL, b'0', '18512345671', '2019-09-12 12:44:49', NULL, NULL);
INSERT INTO `sys_permission` VALUES (473, 1, 14, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (474, 1, 15, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (475, 1, 16, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (476, 1, 17, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (477, 1, 18, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (478, 1, 19, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (479, 1, 20, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (480, 1, 21, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (481, 1, 22, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (482, 1, 23, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (483, 1, 7, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (484, 1, 8, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (485, 1, 9, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (486, 1, 24, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (487, 1, 25, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (488, 1, 26, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (489, 1, 27, NULL, b'0', '18512345671', '2019-09-12 12:44:50', NULL, NULL);
INSERT INTO `sys_permission` VALUES (490, 1, 10, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (491, 1, 11, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (492, 1, 28, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (493, 1, 29, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (494, 1, 30, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (495, 1, 31, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (496, 1, 32, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (497, 1, 33, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (498, 1, 34, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (499, 1, 35, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (500, 1, 36, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (501, 1, 39, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (502, 1, 37, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (503, 1, 38, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (504, 1, 40, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (505, 1, 41, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (506, 1, 42, NULL, b'0', '18512345671', '2019-09-12 12:44:51', NULL, NULL);
INSERT INTO `sys_permission` VALUES (507, 1, 43, NULL, b'0', '18512345671', '2019-09-12 12:44:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (508, 1, 44, NULL, b'0', '18512345671', '2019-09-12 12:44:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (509, 1, 45, NULL, b'0', '18512345671', '2019-09-12 12:44:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (510, 1, 46, NULL, b'0', '18512345671', '2019-09-12 12:44:52', NULL, NULL);
INSERT INTO `sys_permission` VALUES (511, 1, 47, NULL, b'0', '18512345671', '2019-09-12 12:44:52', NULL, NULL);

-- ----------------------------
-- Table structure for sys_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_resource`;
CREATE TABLE `sys_resource`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `category` bigint(20) NOT NULL COMMENT '类别(1:目录,2:菜单,3:按钮)',
  `super_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '父级id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标',
  `href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '访问路径',
  `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '_self' COMMENT '打开方式',
  `ordinal` bigint(20) NULL DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单资源' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_resource
-- ----------------------------
INSERT INTO `sys_resource` VALUES (1, 1, '0', '常规管理', 'fa fa-address-book', NULL, NULL, 10);
INSERT INTO `sys_resource` VALUES (2, 2, '1', '主页模板', 'fa fa-home', NULL, '_self', 1);
INSERT INTO `sys_resource` VALUES (3, 2, '2', '主页一', 'fa fa-tachometer', 'page/welcome-1', '_self', 1);
INSERT INTO `sys_resource` VALUES (4, 2, '2', '主页二', 'fa fa-tachometer', 'page/welcome-2', '_self', 2);
INSERT INTO `sys_resource` VALUES (5, 2, '1', '菜单管理', 'fa fa-window-maximize', 'page/menu', '_self', 2);
INSERT INTO `sys_resource` VALUES (6, 2, '1', '系统设置', 'fa fa-gears', 'page/setting', '_self', 3);
INSERT INTO `sys_resource` VALUES (7, 1, '0', '组件管理', 'fa fa-lemon-o', NULL, NULL, 20);
INSERT INTO `sys_resource` VALUES (8, 2, '7', '图标列表', 'fa fa-dot-circle-o', 'page/icon', '_self', 1);
INSERT INTO `sys_resource` VALUES (9, 2, '7', '图标选择', 'fa fa-adn', 'page/icon-picker', '_self', 2);
INSERT INTO `sys_resource` VALUES (10, 1, '0', '其它管理', 'fa fa-slideshare', NULL, NULL, 30);
INSERT INTO `sys_resource` VALUES (11, 2, '10', '失效菜单', 'fa fa-superpowers', 'page/error', '_self', 1);
INSERT INTO `sys_resource` VALUES (12, 2, '1', '表格示例', 'fa fa-file-text', 'page/table', '_self', 4);
INSERT INTO `sys_resource` VALUES (13, 2, '1', '表单示例', 'fa fa-calendar', NULL, NULL, 5);
INSERT INTO `sys_resource` VALUES (14, 2, '13', '普通表单', 'fa fa-list-alt', 'page/form', '_self', 1);
INSERT INTO `sys_resource` VALUES (15, 2, '13', '分步表单', 'fa fa-navicon', 'page/form-step', '_self', 2);
INSERT INTO `sys_resource` VALUES (16, 2, '1', '登录模板', 'fa fa-flag-o', NULL, NULL, 6);
INSERT INTO `sys_resource` VALUES (17, 2, '16', '登录-1', 'fa fa-stumbleupon-circle', 'page/login-1', '_self', 1);
INSERT INTO `sys_resource` VALUES (18, 2, '16', '登录-2', 'fa fa-viacoin', 'page/login-2', '_self', 2);
INSERT INTO `sys_resource` VALUES (19, 2, '1', '异常页面', 'fa fa-home', NULL, NULL, 7);
INSERT INTO `sys_resource` VALUES (20, 2, '19', '404页面', 'fa fa-hourglass-end', 'page/404', '_self', 1);
INSERT INTO `sys_resource` VALUES (21, 2, '1', '其它界面', 'fa fa-snowflake-o', NULL, NULL, 8);
INSERT INTO `sys_resource` VALUES (22, 2, '21', '按钮示例', 'fa fa-snowflake-o', 'page/button', '_self', 1);
INSERT INTO `sys_resource` VALUES (23, 2, '21', '弹出层', 'fa fa-shield', 'page/layer', '_self', 2);
INSERT INTO `sys_resource` VALUES (24, 2, '7', '颜色选择', 'fa fa-dashboard', 'page/color-select', '_self', 3);
INSERT INTO `sys_resource` VALUES (25, 2, '7', '下拉选择', 'fa fa-angle-double-down', 'page/table-select', '_self', 4);
INSERT INTO `sys_resource` VALUES (26, 2, '7', '文件上传', 'fa fa-arrow-up', 'page/upload', '_self', 5);
INSERT INTO `sys_resource` VALUES (27, 2, '7', '富文本编辑器', 'fa fa-edit', 'page/editor', '_self', 6);
INSERT INTO `sys_resource` VALUES (28, 2, '10', '多级菜单', 'fa fa-meetup', NULL, NULL, 2);
INSERT INTO `sys_resource` VALUES (29, 2, '28', '按钮1', 'fa fa-calendar', 'page/button', '_self', 1);
INSERT INTO `sys_resource` VALUES (30, 2, '28', '按钮2', 'fa fa-snowflake-o', 'page/button', '_self', 2);
INSERT INTO `sys_resource` VALUES (31, 2, '28', '按钮3', 'fa fa-snowflake-o', 'page/button', '_self', 3);
INSERT INTO `sys_resource` VALUES (32, 2, '28', '表单4', 'fa fa-calendar', 'page/form', '_self', 4);
INSERT INTO `sys_resource` VALUES (33, 1, '0', '后台管理', 'fa fa-gear', NULL, NULL, 40);
INSERT INTO `sys_resource` VALUES (34, 2, '33', '用户中心', 'fa fa-users', NULL, NULL, 1);
INSERT INTO `sys_resource` VALUES (35, 2, '34', '平台用户', 'fa fa-user', 'admin/users/user/list', '_self', 1);
INSERT INTO `sys_resource` VALUES (36, 2, '34', '验证码查询', 'fa fa-newspaper-o', 'admin/users/captcha/list', '_self', 2);
INSERT INTO `sys_resource` VALUES (37, 2, '33', '系统设置', 'fa fa-gears', NULL, NULL, 2);
INSERT INTO `sys_resource` VALUES (38, 2, '37', '角色权限', 'fa fa-street-view', 'admin/setting/rolePermission/list', '_self', 1);
INSERT INTO `sys_resource` VALUES (39, 2, '34', '登录日志', 'fa fa-area-chart', 'admin/setting/logLogin/list', '_self', 3);
INSERT INTO `sys_resource` VALUES (40, 2, '37', '菜单管理', 'fa fa-window-maximize', 'admin/setting/menu/list', '_self', 2);
INSERT INTO `sys_resource` VALUES (41, 2, '37', '接口管理', 'fa fa-hdd-o', '/doc.html', '_self', 3);
INSERT INTO `sys_resource` VALUES (42, 2, '37', '定时任务', 'fa fa-tasks', 'admin/setting/task/list', '_self', 4);
INSERT INTO `sys_resource` VALUES (43, 2, '33', '工作流程', 'fa fa-retweet ', NULL, NULL, 3);
INSERT INTO `sys_resource` VALUES (44, 2, '43', '流程列表', 'fa fa-navicon', '/admin/workflow/list', '_self', 1);
INSERT INTO `sys_resource` VALUES (45, 2, '43', '模型列表', 'fa fa-navicon', '/admin/workflow/model/list', '_self', 2);
INSERT INTO `sys_resource` VALUES (46, 2, '43', '发起流程', 'fa fa-pencil', '/admin/workflow/add', '_self', 3);
INSERT INTO `sys_resource` VALUES (47, 2, '43', '待办任务', 'fa fa-search', '/admin/workflow/task/list', '_self', 4);

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色标识',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '中文名称',
  `ordinal` int(11) NULL DEFAULT NULL COMMENT '排序',
  `note` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `is_deleted` bit(1) NOT NULL COMMENT '逻辑删除',
  `creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `mender` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后修改者',
  `modify_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '开发人员', 1, '开发人员', b'0', 'hs', '2019-07-17 16:44:28', NULL, '2019-09-12 12:44:49');
INSERT INTO `sys_role` VALUES (2, '后台管理', 2, '管理员', b'0', 'hs', '2019-08-26 09:59:15', NULL, '2019-09-08 14:16:46');
INSERT INTO `sys_role` VALUES (3, '测试1', 3, '测试常规管理1', b'1', '18512345671', '2019-09-01 12:17:10', NULL, '2019-09-01 13:16:20');
INSERT INTO `sys_role` VALUES (4, '测试2号', 4, '12', b'0', '18512345671', '2019-09-01 12:19:37', NULL, NULL);
INSERT INTO `sys_role` VALUES (5, '测试1号', 5, '212', b'0', '18512345671', '2019-09-01 12:26:05', NULL, '2019-09-08 14:16:20');
INSERT INTO `sys_role` VALUES (6, '测试3号', 6, '测试12', b'0', '18512345671', '2019-09-01 12:45:38', NULL, '2019-09-01 13:16:02');
INSERT INTO `sys_role` VALUES (7, '默认角色', 7, '默认角色', b'0', '18512345671', '2019-09-08 14:16:09', NULL, '2019-09-09 18:26:51');

-- ----------------------------
-- Table structure for sys_roles_account
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_account`;
CREATE TABLE `sys_roles_account`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `account_id` bigint(20) NOT NULL COMMENT '账户',
  `role_id` bigint(20) NOT NULL COMMENT '角色',
  `note` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  `is_deleted` bit(1) NOT NULL COMMENT '逻辑删除',
  `creator` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL,
  `mender` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后修改者',
  `modify_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '账户角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_roles_account
-- ----------------------------
INSERT INTO `sys_roles_account` VALUES (1, 1, 1, '开发人员', b'0', 'hs', '2019-07-17 16:45:22', NULL, NULL);
INSERT INTO `sys_roles_account` VALUES (2, 2, 1, NULL, b'0', NULL, '2019-09-12 15:38:39', NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;