You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1727 lines
467 KiB
1727 lines
467 KiB
3 years ago
|
/*
|
||
|
|
SQLyog v10.2
|
||
|
|
MySQL - 8.0.22 : Database - anrui_flowable
|
||
|
|
*********************************************************************
|
||
|
|
*/
|
||
|
|
|
||
|
|
/*!40101 SET NAMES utf8 */;
|
||
|
|
|
||
|
|
/*!40101 SET SQL_MODE=''*/;
|
||
|
|
|
||
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
||
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
||
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
||
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
||
|
|
CREATE DATABASE /*!32312 IF NOT EXISTS*/`anrui_flowable` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;
|
||
|
|
|
||
|
|
USE `anrui_flowable`;
|
||
|
|
|
||
|
|
/*Table structure for table `act_de_databasechangelog` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_de_databasechangelog`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_de_databasechangelog` (
|
||
|
|
`ID` varchar(255) NOT NULL,
|
||
|
|
`AUTHOR` varchar(255) NOT NULL,
|
||
|
|
`FILENAME` varchar(255) NOT NULL,
|
||
|
|
`DATEEXECUTED` datetime NOT NULL,
|
||
|
|
`ORDEREXECUTED` int NOT NULL,
|
||
|
|
`EXECTYPE` varchar(10) NOT NULL,
|
||
|
|
`MD5SUM` varchar(35) DEFAULT NULL,
|
||
|
|
`DESCRIPTION` varchar(255) DEFAULT NULL,
|
||
|
|
`COMMENTS` varchar(255) DEFAULT NULL,
|
||
|
|
`TAG` varchar(255) DEFAULT NULL,
|
||
|
|
`LIQUIBASE` varchar(20) DEFAULT NULL,
|
||
|
|
`CONTEXTS` varchar(255) DEFAULT NULL,
|
||
|
|
`LABELS` varchar(255) DEFAULT NULL,
|
||
|
|
`DEPLOYMENT_ID` varchar(10) DEFAULT NULL
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `act_de_databasechangelog` */
|
||
|
|
|
||
|
|
insert into `act_de_databasechangelog`(`ID`,`AUTHOR`,`FILENAME`,`DATEEXECUTED`,`ORDEREXECUTED`,`EXECTYPE`,`MD5SUM`,`DESCRIPTION`,`COMMENTS`,`TAG`,`LIQUIBASE`,`CONTEXTS`,`LABELS`,`DEPLOYMENT_ID`) values ('1','flowable','META-INF/liquibase/flowable-modeler-app-db-changelog.xml','2021-08-28 22:24:01',1,'EXECUTED','8:e70d1d9d3899a734296b2514ccc71501','createTable tableName=ACT_DE_MODEL; createIndex indexName=idx_proc_mod_created, tableName=ACT_DE_MODEL; createTable tableName=ACT_DE_MODEL_HISTORY; createIndex indexName=idx_proc_mod_history_proc, tableName=ACT_DE_MODEL_HISTORY; createTable tableN...','',NULL,'3.8.9',NULL,NULL,'0160641853'),('3','flowable','META-INF/liquibase/flowable-modeler-app-db-changelog.xml','2021-08-28 22:24:02',2,'EXECUTED','8:3a9143bef2e45f2316231cc1369138b6','addColumn tableName=ACT_DE_MODEL; addColumn tableName=ACT_DE_MODEL_HISTORY','',NULL,'3.8.9',NULL,NULL,'0160641853');
|
||
|
|
|
||
|
|
/*Table structure for table `act_de_databasechangeloglock` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_de_databasechangeloglock`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_de_databasechangeloglock` (
|
||
|
|
`ID` int NOT NULL,
|
||
|
|
`LOCKED` bit(1) NOT NULL,
|
||
|
|
`LOCKGRANTED` datetime DEFAULT NULL,
|
||
|
|
`LOCKEDBY` varchar(255) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `act_de_databasechangeloglock` */
|
||
|
|
|
||
|
|
insert into `act_de_databasechangeloglock`(`ID`,`LOCKED`,`LOCKGRANTED`,`LOCKEDBY`) values (1,'\0',NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `act_de_model` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_de_model`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_de_model` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(400) NOT NULL,
|
||
|
|
`model_key` varchar(400) NOT NULL,
|
||
|
|
`description` varchar(4000) DEFAULT NULL,
|
||
|
|
`model_comment` varchar(4000) DEFAULT NULL,
|
||
|
|
`created` datetime(6) DEFAULT NULL,
|
||
|
|
`created_by` varchar(255) DEFAULT NULL,
|
||
|
|
`last_updated` datetime(6) DEFAULT NULL,
|
||
|
|
`last_updated_by` varchar(255) DEFAULT NULL,
|
||
|
|
`version` int DEFAULT NULL,
|
||
|
|
`model_editor_json` longtext,
|
||
|
|
`thumbnail` longblob,
|
||
|
|
`model_type` int DEFAULT NULL,
|
||
|
|
`tenant_id` varchar(255) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `idx_proc_mod_created` (`created_by`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `act_de_model` */
|
||
|
|
|
||
|
|
insert into `act_de_model`(`id`,`name`,`model_key`,`description`,`model_comment`,`created`,`created_by`,`last_updated`,`last_updated_by`,`version`,`model_editor_json`,`thumbnail`,`model_type`,`tenant_id`) values ('bb67fef0-080b-11ec-a89d-8032536963e7','公司请假测试','holiday_test','',NULL,'2021-08-28 22:25:02.071000','dimengzhe','2021-08-28 22:32:19.452000','dimengzhe',1,'{\"modelId\":\"bb67fef0-080b-11ec-a89d-8032536963e7\",\"bounds\":{\"lowerRight\":{\"x\":1200,\"y\":1050},\"upperLeft\":{\"x\":0,\"y\":0}},\"properties\":{\"process_id\":\"holiday_test\",\"name\":\"公司请假测试\",\"documentation\":\"\",\"process_author\":\"\",\"process_version\":\"\",\"process_namespace\":\"http://www.flowable.org/processdef\",\"process_historylevel\":\"\",\"isexecutable\":true,\"dataproperties\":\"\",\"executionlisteners\":\"{\\\"executionListeners\\\":[]}\",\"eventlisteners\":\"{\\\"eventListeners\\\":[]}\",\"signaldefinitions\":\"[]\",\"messagedefinitions\":\"[]\",\"escalationdefinitions\":\"[]\",\"process_potentialstarteruser\":\"\",\"process_potentialstartergroup\":\"\",\"iseagerexecutionfetch\":\"false\",\"messages\":[]},\"childShapes\":[{\"resourceId\":\"_1\",\"properties\":{\"overrideid\":\"_1\",\"name\":\"开始\",\"documentation\":\"\",\"executionlisteners\":{\"executionListeners\":[]},\"initiator\":\"\",\"formkeydefinition\":\"\",\"formreference\":\"\",\"formfieldvalidation\":\"true\",\"formproperties\":\"\",\"interrupting\":true},\"stencil\":{\"id\":\"StartNoneEvent\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-58A2AF54-664F-4DB8-8D92-50908CC56490\"}],\"bounds\":{\"lowerRight\":{\"x\":130,\"y\":193},\"upperLeft\":{\"x\":100,\"y\":163}},\"dockers\":[]},{\"resourceId\":\"_2\",\"properties\":{\"overrideid\":\"_2\",\"name\":\"请假申请\",\"documentation\":\"\",\"asynchronousdefinition\":false,\"exclusivedefinition\":true,\"executionlisteners\":{\"executionListeners\":[]},\"multiinstance_type\":\"None\",\"multiinstance_cardinality\":\"\",\"multiinstance_collection\":\"\",\"multiinstance_variable\":\"\",\"multiinstance_condition\":\"\",\"isforcompensation\":false,\"usertaskassignment\":{\"assignment\":{\"type\":\"static\",\"assignee\":\"${initiator}\"}},\"formkeydefinition\":\"holiday_test\",\"formreference\":\"\",\"formfieldvalidation\":true,\"duedatedefinition\":\"\",\"prioritydefinition\":\"\",\"formproperties\":\"\",\"tasklisteners\":{\"taskListeners\":[]},\"skipexpression\":\"\",\"categorydefinition\":\"\"},\"stencil\":{\"id\":\"UserTask\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-BA2260E5-F225-4B24-B5C9-3CCA47DA8216\"}],\"bounds\":{\"lowerRight\":{\"x\":265,\"y\":215},\"upperLeft\":{\"x\":165,\"y\":135}},\"dockers\":[]},{\"resourceId\":\"sid-58A2AF54-664F-4DB8-8D92-50908CC56490\",\"properties\":{\"overrideid\":\"sid-58A2AF54-664F-4DB8-8D92-50908CC56490\",\"name\":\"\",\"documentation\":\"\",\"conditionsequenceflow\":\"\",\"executionlisteners\":\"\",\"defaultflow\":\"false\",\"skipexpression\":\"\"},\"stencil\":{\"id\":\"SequenceFlow\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"_2\"}],\"bounds\":{\"lowerRight\":{\"x\":164.78169969647763,\"y\":177.54813849089433},\"upperLeft\":{\"x\":130.06205030352237,\"y\":176.50654900910567}},\"dockers\":[{\"x\":15,\"y\":15},{\"x\":50,\"y\":40}],\"target\":{\"resourceId\":\"_2\"}},{\"resourceId\":\"sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04\",\"properties\":{\"overrideid\":\"sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04\",\"name\":\"\",\"documentation\":\"\",\"asynchronousdefinition\":\"false\",\"exclusivedefinition\":\"false\",\"sequencefloworder\":\"\",\"executionlisteners\":{\"executionListeners\":[]}},\"stencil\":{\"id\":\"ExclusiveGateway\"},\"childShapes\":[],\"outgoing\":[{\"resourceId\":\"sid-7944F75F-0CD1-4C29-BB23-74032D0FDDB8\"},{\"resourceId\":\"sid-4C22374A-976D-4C6A-BCDA-5056EC2E4CA1\"}],\"bounds\":{\"lowerRight\":{\"x\":430,\"y\":195},\"upperLeft\":{\"x\":390,\"y\":155}},\"dockers\":[]},{\"resourceId\":\"sid-BA2260E5-F225-4B24-B5C9-3CCA47DA8216\",\"properties\":{\"overrideid\":\"sid-BA2260E5-F225-4B24-B5C9-3CCA47DA8216\",\"name\":\"
|
||
|
|
|
||
|
|
/*Table structure for table `act_de_model_history` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_de_model_history`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_de_model_history` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`name` varchar(400) NOT NULL,
|
||
|
|
`model_key` varchar(400) NOT NULL,
|
||
|
|
`description` varchar(4000) DEFAULT NULL,
|
||
|
|
`model_comment` varchar(4000) DEFAULT NULL,
|
||
|
|
`created` datetime(6) DEFAULT NULL,
|
||
|
|
`created_by` varchar(255) DEFAULT NULL,
|
||
|
|
`last_updated` datetime(6) DEFAULT NULL,
|
||
|
|
`last_updated_by` varchar(255) DEFAULT NULL,
|
||
|
|
`removal_date` datetime(6) DEFAULT NULL,
|
||
|
|
`version` int DEFAULT NULL,
|
||
|
|
`model_editor_json` longtext,
|
||
|
|
`model_id` varchar(255) NOT NULL,
|
||
|
|
`model_type` int DEFAULT NULL,
|
||
|
|
`tenant_id` varchar(255) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `idx_proc_mod_history_proc` (`model_id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `act_de_model_history` */
|
||
|
|
|
||
|
|
/*Table structure for table `act_de_model_relation` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_de_model_relation`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_de_model_relation` (
|
||
|
|
`id` varchar(255) NOT NULL,
|
||
|
|
`parent_model_id` varchar(255) DEFAULT NULL,
|
||
|
|
`model_id` varchar(255) DEFAULT NULL,
|
||
|
|
`relation_type` varchar(255) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `fk_relation_parent` (`parent_model_id`),
|
||
|
|
KEY `fk_relation_child` (`model_id`),
|
||
|
|
CONSTRAINT `fk_relation_child` FOREIGN KEY (`model_id`) REFERENCES `act_de_model` (`id`),
|
||
|
|
CONSTRAINT `fk_relation_parent` FOREIGN KEY (`parent_model_id`) REFERENCES `act_de_model` (`id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `act_de_model_relation` */
|
||
|
|
|
||
|
|
/*Table structure for table `act_evt_log` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_evt_log`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_evt_log` (
|
||
|
|
`LOG_NR_` bigint NOT NULL AUTO_INCREMENT,
|
||
|
|
`TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin 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 DEFAULT NULL,
|
||
|
|
`DATA_` longblob,
|
||
|
|
`LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`IS_PROCESSED_` tinyint DEFAULT '0',
|
||
|
|
PRIMARY KEY (`LOG_NR_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_evt_log` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`BYTES_` longblob,
|
||
|
|
`GENERATED_` tinyint DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ge_bytearray` */
|
||
|
|
|
||
|
|
insert into `act_ge_bytearray`(`ID_`,`REV_`,`NAME_`,`DEPLOYMENT_ID_`,`BYTES_`,`GENERATED_`) values ('2',1,'测试1.bpmn','1','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<definitions xmlns=\"http://www.omg.org/spec/BPMN/20100524/MODEL\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:flowable=\"http://flowable.org/bpmn\" xmlns:bpmndi=\"http://www.omg.org/spec/BPMN/20100524/DI\" xmlns:omgdc=\"http://www.omg.org/spec/DD/20100524/DC\" xmlns:omgdi=\"http://www.omg.org/spec/DD/20100524/DI\" typeLanguage=\"http://www.w3.org/2001/XMLSchema\" expressionLanguage=\"http://www.w3.org/1999/XPath\" targetNamespace=\"http://www.flowable.org/processdef\">\n <process id=\"holiday_test\" name=\"公司请假测试\" isExecutable=\"true\">\n <startEvent id=\"_1\" name=\"开始\" flowable:formFieldValidation=\"true\"></startEvent>\n <userTask id=\"_2\" name=\"请假申请\" flowable:assignee=\"${initiator}\" flowable:formKey=\"holiday_test\" flowable:formFieldValidation=\"true\">\n <extensionElements>\n <modeler:initiator-can-complete xmlns:modeler=\"http://flowable.org/modeler\"><![CDATA[false]]></modeler:initiator-can-complete>\n </extensionElements>\n </userTask>\n <sequenceFlow id=\"sid-58A2AF54-664F-4DB8-8D92-50908CC56490\" sourceRef=\"_1\" targetRef=\"_2\"></sequenceFlow>\n <exclusiveGateway id=\"sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04\"></exclusiveGateway>\n <sequenceFlow id=\"sid-BA2260E5-F225-4B24-B5C9-3CCA47DA8216\" sourceRef=\"_2\" targetRef=\"sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04\"></sequenceFlow>\n <userTask id=\"_3\" name=\"部门经理审批\" flowable:assignee=\"0b4d1362-b3a1-4487-9046-a5ed56bd8f60\" flowable:formFieldValidation=\"true\">\n <extensionElements>\n <modeler:initiator-can-complete xmlns:modeler=\"http://flowable.org/modeler\"><![CDATA[false]]></modeler:initiator-can-complete>\n </extensionElements>\n </userTask>\n <userTask id=\"_4\" name=\"总经理审批\" flowable:assignee=\"0b4d1362-b3a1-4487-9046-a5ed56bd8f61\" flowable:formFieldValidation=\"true\">\n <extensionElements>\n <modeler:initiator-can-complete xmlns:modeler=\"http://flowable.org/modeler\"><![CDATA[false]]></modeler:initiator-can-complete>\n </extensionElements>\n </userTask>\n <intermediateThrowEvent id=\"_5\" name=\"结束\"></intermediateThrowEvent>\n <sequenceFlow id=\"sid-28D1C2F2-C1F7-4586-9069-162662A81C3B\" name=\"通过\" sourceRef=\"_3\" targetRef=\"_5\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'通过\'}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"sid-009E74C3-B3AC-4ABC-B761-93378FE710B0\" name=\"通过\" sourceRef=\"_4\" targetRef=\"_5\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'通过\'}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"sid-1613EA36-9F3A-4760-A400-9BBD077F8975\" name=\"驳回\" sourceRef=\"_4\" targetRef=\"_2\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'驳回\'}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"sid-8E853772-D7EE-4D7F-8C66-513B974FB5A5\" name=\"驳回\" sourceRef=\"_3\" targetRef=\"_2\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'驳回\'}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"sid-7944F75F-0CD1-4C29-BB23-74032D0FDDB8\" name=\"大于3天\" sourceRef=\"sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04\" targetRef=\"_4\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${days>3}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"sid-4C22374A-976D-4C6A-BCDA-5056EC2E4CA1\" name=\"小于等于3\" sourceRef=\"sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04\" targetRef=\"_3\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${days<=3}]]></conditionExpression>\n </sequenceFlow>\n </process>\n <bpmndi:BPMNDiagram id=\"BPMNDiagram_holiday_test\">\n <bpmndi:BPM
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`NAME_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ge_property` */
|
||
|
|
|
||
|
|
insert into `act_ge_property`(`NAME_`,`VALUE_`,`REV_`) values ('batch.schema.version','6.5.0.6',1),('cfg.execution-related-entities-count','true',1),('cfg.task-related-entities-count','true',1),('common.schema.version','6.5.0.6',1),('entitylink.schema.version','6.5.0.6',1),('eventsubscription.schema.version','6.5.0.6',1),('identitylink.schema.version','6.5.0.6',1),('job.schema.version','6.5.0.6',1),('next.dbid','57501',24),('schema.history','create(6.5.0.6)',1),('schema.version','6.5.0.6',1),('task.schema.version','6.5.0.6',1),('variable.schema.version','6.5.0.6',1);
|
||
|
|
|
||
|
|
/*Table structure for table `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,
|
||
|
|
`REV_` int DEFAULT '1',
|
||
|
|
`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 DEFAULT NULL,
|
||
|
|
`CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`START_TIME_` datetime(3) NOT NULL,
|
||
|
|
`END_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`DURATION_` bigint DEFAULT NULL,
|
||
|
|
`DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
|
||
|
|
KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
|
||
|
|
KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
|
||
|
|
KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_actinst` */
|
||
|
|
|
||
|
|
insert into `act_hi_actinst`(`ID_`,`REV_`,`PROC_DEF_ID_`,`PROC_INST_ID_`,`EXECUTION_ID_`,`ACT_ID_`,`TASK_ID_`,`CALL_PROC_INST_ID_`,`ACT_NAME_`,`ACT_TYPE_`,`ASSIGNEE_`,`START_TIME_`,`END_TIME_`,`DURATION_`,`DELETE_REASON_`,`TENANT_ID_`) values ('10',1,'holiday_test:1:4','5','8','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-08-28 23:06:08.718','2021-08-28 23:06:08.718',0,NULL,''),('11',1,'holiday_test:1:4','5','8','_2','12',NULL,'请假申请','userTask','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2021-08-28 23:06:08.718',NULL,NULL,NULL,''),('2506',1,'holiday_test:1:4','2501','2505','_1',NULL,NULL,'开始','startEvent',NULL,'2021-08-28 23:24:13.391','2021-08-28 23:24:13.399',8,NULL,''),('2507',1,'holiday_test:1:4','2501','2505','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-08-28 23:24:13.401','2021-08-28 23:24:13.401',0,NULL,''),('2508',1,'holiday_test:1:4','2501','2505','_2','2509',NULL,'请假申请','userTask','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2021-08-28 23:24:13.401',NULL,NULL,NULL,''),('40034',1,'holiday_test:2:40023','40024','40033','_1',NULL,NULL,'开始','startEvent',NULL,'2021-10-19 16:07:41.383','2021-10-19 16:07:41.383',0,NULL,''),('40035',1,'holiday_test:2:40023','40024','40033','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:07:41.383','2021-10-19 16:07:41.383',0,NULL,''),('40036',2,'holiday_test:2:40023','40024','40033','_2','40037',NULL,'请假申请c','userTask','1','2021-10-19 16:07:41.383','2021-10-19 16:07:41.475',92,NULL,''),('40042',1,'holiday_test:2:40023','40024','40033','sid-BA2260E5-F225-4B24-B5C9-3CCA47DA8216',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:07:41.477','2021-10-19 16:07:41.477',0,NULL,''),('40043',1,'holiday_test:2:40023','40024','40033','sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04',NULL,NULL,NULL,'exclusiveGateway',NULL,'2021-10-19 16:07:41.478','2021-10-19 16:07:41.480',2,NULL,''),('40044',1,'holiday_test:2:40023','40024','40033','sid-4C22374A-976D-4C6A-BCDA-5056EC2E4CA1',NULL,NULL,'小于等于3','sequenceFlow',NULL,'2021-10-19 16:07:41.480','2021-10-19 16:07:41.480',0,NULL,''),('40045',1,'holiday_test:2:40023','40024','40033','_3','40046',NULL,'部门经理审批','userTask','0b4d1362-b3a1-4487-9046-a5ed56bd8f60','2021-10-19 16:07:41.482',NULL,NULL,NULL,''),('42511',1,'holiday_test:2:40023','42501','42510','_1',NULL,NULL,'开始','startEvent',NULL,'2021-10-19 16:14:09.479','2021-10-19 16:14:09.485',6,NULL,''),('42512',1,'holiday_test:2:40023','42501','42510','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:14:09.488','2021-10-19 16:14:09.488',0,NULL,''),('42513',2,'holiday_test:2:40023','42501','42510','_2','42514',NULL,'请假申请c','userTask','1','2021-10-19 16:14:09.488','2021-10-19 16:14:09.717',229,NULL,''),('42519',1,'holiday_test:2:40023','42501','42510','sid-BA2260E5-F225-4B24-B5C9-3CCA47DA8216',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:14:09.719','2021-10-19 16:14:09.719',0,NULL,''),('42520',1,'holiday_test:2:40023','42501','42510','sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04',NULL,NULL,NULL,'exclusiveGateway',NULL,'2021-10-19 16:14:09.720','2021-10-19 16:14:09.735',15,NULL,''),('42521',1,'holiday_test:2:40023','42501','42510','sid-7944F75F-0CD1-4C29-BB23-74032D0FDDB8',NULL,NULL,'大于3天','sequenceFlow',NULL,'2021-10-19 16:14:09.735','2021-10-19 16:14:09.735',0,NULL,''),('42522',1,'holiday_test:2:40023','42501','42510','_4','42523',NULL,'总经理审批','userTask','0b4d1362-b3a1-4487-9046-a5ed56bd8f61','2021-10-19 16:14:09.737',NULL,NULL,NULL,''),('45011',1,'holiday_test:2:40023','45001','45010','_1',NULL,NULL,'开始','startEvent',NULL,'2021-10-19 16:28:08.620','2021-10-19 16:28:08.628',8,NULL,''),('45012',1,'holiday_test:2:40023','45001','45010','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:28:08.633','2021-10-19 16:28:08.633',0,NULL,''),('45013',2,'holiday_test:2:40023','45001','45010','_2','45014',NULL,'请假申请c','userTask','1','2021-10-1
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`URL_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CONTENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_attachment` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`TIME_` datetime(3) NOT NULL,
|
||
|
|
`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ACTION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`MESSAGE_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`FULL_MSG_` longblob,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_comment` */
|
||
|
|
|
||
|
|
insert into `act_hi_comment`(`ID_`,`TYPE_`,`TIME_`,`USER_ID_`,`TASK_ID_`,`PROC_INST_ID_`,`ACTION_`,`MESSAGE_`,`FULL_MSG_`) values ('40040','1','2021-10-19 16:07:41.435','fff5040e-3ea5-4df0-bbd2-714ee93e1c20','40037','40024','AddComment','null发起流程申请','null发起流程申请'),('42517','1','2021-10-19 16:14:09.659','7a5ff7d1-1aff-4baa-901b-e6143d7c84ea','42514','42501','AddComment','null发起流程申请','null发起流程申请'),('45017','1','2021-10-19 16:28:08.814','bc59f6f1-f5c8-463f-86af-b68e9ddc800c','45014','45001','AddComment','null发起流程申请','null发起流程申请'),('47517','1','2021-10-19 16:41:45.623','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','47514','47501','AddComment','null发起流程申请','null发起流程申请'),('50017','1','2021-10-19 17:49:39.504','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','50014','50001','AddComment','null发起流程申请','null发起流程申请'),('5012','1','2021-08-28 23:28:51.086','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','5009','5001','AddComment','0b4d1362-b3a1-4487-9046-a5ed56bd8f59发起流程申请','0b4d1362-b3a1-4487-9046-a5ed56bd8f59发起流程申请'),('52517','1','2021-10-20 16:05:41.596','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','52514','52501','AddComment','null发起流程申请','null发起流程申请'),('55024','1','2021-10-20 16:53:05.669','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','55021','55007','AddComment','null发起流程申请','null发起流程申请'),('55033','1','2021-10-20 16:54:11.985',NULL,'55030','55007','AddComment','通过','通过'),('55057','1','2021-10-20 16:59:08.853','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','55054','55040','AddComment','null发起流程申请','null发起流程申请'),('55066','1','2021-10-20 16:59:47.582',NULL,'55063','55040','AddComment','111','111'),('55072','1','2021-10-20 17:00:19.664',NULL,'55069','55040','AddComment','212122','212122');
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`VAR_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
`TIME_` datetime(3) NOT NULL,
|
||
|
|
`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DOUBLE_` double DEFAULT NULL,
|
||
|
|
`LONG_` bigint DEFAULT NULL,
|
||
|
|
`TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
|
||
|
|
KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
|
||
|
|
KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
|
||
|
|
KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
|
||
|
|
KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_detail` */
|
||
|
|
|
||
|
|
/*Table structure for table `act_hi_entitylink` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_hi_entitylink`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_hi_entitylink` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`LINK_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REF_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REF_SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REF_SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HIERARCHY_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_HI_ENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_entitylink` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
|
||
|
|
KEY `ACT_IDX_HI_IDENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
|
||
|
|
KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_identitylink` */
|
||
|
|
|
||
|
|
insert into `act_hi_identitylink`(`ID_`,`GROUP_ID_`,`TYPE_`,`USER_ID_`,`TASK_ID_`,`CREATE_TIME_`,`PROC_INST_ID_`,`SCOPE_ID_`,`SUB_SCOPE_ID_`,`SCOPE_TYPE_`,`SCOPE_DEFINITION_ID_`) values ('13',NULL,'assignee','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','12','2021-08-28 23:06:08.745',NULL,NULL,NULL,NULL,NULL),('14',NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-08-28 23:06:08.746','5',NULL,NULL,NULL,NULL),('2502',NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-08-28 23:24:13.383','2501',NULL,NULL,NULL,NULL),('2510',NULL,'assignee','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2509','2021-08-28 23:24:13.423',NULL,NULL,NULL,NULL,NULL),('2511',NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-08-28 23:24:13.423','2501',NULL,NULL,NULL,NULL),('40025',NULL,'starter','fff5040e-3ea5-4df0-bbd2-714ee93e1c20',NULL,'2021-10-19 16:07:41.382','40024',NULL,NULL,NULL,NULL),('40038',NULL,'assignee','1','40037','2021-10-19 16:07:41.384',NULL,NULL,NULL,NULL,NULL),('40039',NULL,'participant','1',NULL,'2021-10-19 16:07:41.384','40024',NULL,NULL,NULL,NULL),('40041',NULL,'participant','fff5040e-3ea5-4df0-bbd2-714ee93e1c20',NULL,'2021-10-19 16:07:41.468','40024',NULL,NULL,NULL,NULL),('40047',NULL,'assignee','0b4d1362-b3a1-4487-9046-a5ed56bd8f60','40046','2021-10-19 16:07:41.482',NULL,NULL,NULL,NULL,NULL),('40048',NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f60',NULL,'2021-10-19 16:07:41.482','40024',NULL,NULL,NULL,NULL),('42502',NULL,'starter','7a5ff7d1-1aff-4baa-901b-e6143d7c84ea',NULL,'2021-10-19 16:14:09.466','42501',NULL,NULL,NULL,NULL),('42515',NULL,'assignee','1','42514','2021-10-19 16:14:09.532',NULL,NULL,NULL,NULL,NULL),('42516',NULL,'participant','1',NULL,'2021-10-19 16:14:09.533','42501',NULL,NULL,NULL,NULL),('42518',NULL,'participant','7a5ff7d1-1aff-4baa-901b-e6143d7c84ea',NULL,'2021-10-19 16:14:09.705','42501',NULL,NULL,NULL,NULL),('42524',NULL,'assignee','0b4d1362-b3a1-4487-9046-a5ed56bd8f61','42523','2021-10-19 16:14:09.737',NULL,NULL,NULL,NULL,NULL),('42525',NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'2021-10-19 16:14:09.737','42501',NULL,NULL,NULL,NULL),('45002',NULL,'starter','bc59f6f1-f5c8-463f-86af-b68e9ddc800c',NULL,'2021-10-19 16:28:08.605','45001',NULL,NULL,NULL,NULL),('45015',NULL,'assignee','1','45014','2021-10-19 16:28:08.681',NULL,NULL,NULL,NULL,NULL),('45016',NULL,'participant','1',NULL,'2021-10-19 16:28:08.681','45001',NULL,NULL,NULL,NULL),('45018',NULL,'participant','bc59f6f1-f5c8-463f-86af-b68e9ddc800c',NULL,'2021-10-19 16:28:08.856','45001',NULL,NULL,NULL,NULL),('45024',NULL,'assignee','0b4d1362-b3a1-4487-9046-a5ed56bd8f61','45023','2021-10-19 16:28:08.888',NULL,NULL,NULL,NULL,NULL),('45025',NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'2021-10-19 16:28:08.888','45001',NULL,NULL,NULL,NULL),('47502',NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-10-19 16:41:45.485','47501',NULL,NULL,NULL,NULL),('47515',NULL,'assignee','5','47514','2021-10-19 16:41:45.550',NULL,NULL,NULL,NULL,NULL),('47516',NULL,'participant','5',NULL,'2021-10-19 16:41:45.551','47501',NULL,NULL,NULL,NULL),('47518',NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-10-19 16:41:45.660','47501',NULL,NULL,NULL,NULL),('47524',NULL,'assignee','0b4d1362-b3a1-4487-9046-a5ed56bd8f61','47523','2021-10-19 16:41:45.696',NULL,NULL,NULL,NULL,NULL),('47525',NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'2021-10-19 16:41:45.696','47501',NULL,NULL,NULL,NULL),('50002',NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-10-19 17:49:39.359','50001',NULL,NULL,NULL,NULL),('50015',NULL,'assignee','7','50014','2021-10-19 17:49:39.424',NULL,NULL,NULL,NULL,NULL),('50016',NULL,'participant','7',NULL,'2021-10-19 17:49:39.424','50001',NULL,NULL,NULL,NULL),('50018',NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-10-19 17:49:39.538','50001',NULL,NULL,NULL,NULL),('5002',NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-08-28 23:28:50.996','5001',NULL,NULL,NULL,NULL),('50024',NULL,'assigne
|
||
|
|
|
||
|
|
/*Table structure for table `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,
|
||
|
|
`REV_` int DEFAULT '1',
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin 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) DEFAULT NULL,
|
||
|
|
`DURATION_` bigint DEFAULT NULL,
|
||
|
|
`START_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`START_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`END_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUPER_PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CALLBACK_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CALLBACK_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REFERENCE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REFERENCE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
|
||
|
|
KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
|
||
|
|
KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_procinst` */
|
||
|
|
|
||
|
|
insert into `act_hi_procinst`(`ID_`,`REV_`,`PROC_INST_ID_`,`BUSINESS_KEY_`,`PROC_DEF_ID_`,`START_TIME_`,`END_TIME_`,`DURATION_`,`START_USER_ID_`,`START_ACT_ID_`,`END_ACT_ID_`,`SUPER_PROCESS_INSTANCE_ID_`,`DELETE_REASON_`,`TENANT_ID_`,`NAME_`,`CALLBACK_ID_`,`CALLBACK_TYPE_`,`REFERENCE_ID_`,`REFERENCE_TYPE_`) values ('2501',1,'2501',NULL,'holiday_test:1:4','2021-08-28 23:24:13.330',NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('40024',1,'40024',NULL,'holiday_test:2:40023','2021-10-19 16:07:41.382',NULL,NULL,'fff5040e-3ea5-4df0-bbd2-714ee93e1c20','_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('42501',1,'42501',NULL,'holiday_test:2:40023','2021-10-19 16:14:09.449',NULL,NULL,'7a5ff7d1-1aff-4baa-901b-e6143d7c84ea','_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('45001',1,'45001',NULL,'holiday_test:2:40023','2021-10-19 16:28:08.587',NULL,NULL,'bc59f6f1-f5c8-463f-86af-b68e9ddc800c','_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('47501',1,'47501',NULL,'holiday_test:2:40023','2021-10-19 16:41:45.464',NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('5',1,'5',NULL,'holiday_test:1:4','2021-08-28 23:06:08.707',NULL,NULL,NULL,'_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('50001',1,'50001',NULL,'holiday_test:2:40023','2021-10-19 17:49:39.342',NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('5001',1,'5001',NULL,'holiday_test:1:4','2021-08-28 23:28:50.949',NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('52501',1,'52501',NULL,'holiday_test:2:40023','2021-10-20 16:05:41.429',NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','_1',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('55007',2,'55007',NULL,'holiday_test:3:55006','2021-10-20 16:53:05.595','2021-10-20 16:54:12.053',66458,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','_1','_5',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),('55040',2,'55040',NULL,'holiday_test:4:55039','2021-10-20 16:59:08.795','2021-10-20 17:00:19.716',70921,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','_1','_5',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `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,
|
||
|
|
`REV_` int DEFAULT '1',
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROPAGATED_STAGE_INST_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`START_TIME_` datetime(3) NOT NULL,
|
||
|
|
`CLAIM_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`END_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`DURATION_` bigint DEFAULT NULL,
|
||
|
|
`DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PRIORITY_` int DEFAULT NULL,
|
||
|
|
`DUE_DATE_` datetime(3) DEFAULT NULL,
|
||
|
|
`FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
`LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_HI_TASK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_taskinst` */
|
||
|
|
|
||
|
|
insert into `act_hi_taskinst`(`ID_`,`REV_`,`PROC_DEF_ID_`,`TASK_DEF_ID_`,`TASK_DEF_KEY_`,`PROC_INST_ID_`,`EXECUTION_ID_`,`SCOPE_ID_`,`SUB_SCOPE_ID_`,`SCOPE_TYPE_`,`SCOPE_DEFINITION_ID_`,`PROPAGATED_STAGE_INST_ID_`,`NAME_`,`PARENT_TASK_ID_`,`DESCRIPTION_`,`OWNER_`,`ASSIGNEE_`,`START_TIME_`,`CLAIM_TIME_`,`END_TIME_`,`DURATION_`,`DELETE_REASON_`,`PRIORITY_`,`DUE_DATE_`,`FORM_KEY_`,`CATEGORY_`,`TENANT_ID_`,`LAST_UPDATED_TIME_`) values ('12',1,'holiday_test:1:4',NULL,'_2','5','8',NULL,NULL,NULL,NULL,NULL,'请假申请',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2021-08-28 23:06:08.718',NULL,NULL,NULL,NULL,50,NULL,'holiday_test',NULL,'','2021-08-28 23:06:08.744'),('2509',1,'holiday_test:1:4',NULL,'_2','2501','2505',NULL,NULL,NULL,NULL,NULL,'请假申请',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2021-08-28 23:24:13.401',NULL,NULL,NULL,NULL,50,NULL,'holiday_test',NULL,'','2021-08-28 23:24:13.422'),('40037',2,'holiday_test:2:40023',NULL,'_2','40024','40033',NULL,NULL,NULL,NULL,NULL,'请假申请c',NULL,NULL,NULL,'1','2021-10-19 16:07:41.383',NULL,'2021-10-19 16:07:41.470',87,NULL,50,NULL,'holiday_test',NULL,'','2021-10-19 16:07:41.470'),('40046',1,'holiday_test:2:40023',NULL,'_3','40024','40033',NULL,NULL,NULL,NULL,NULL,'部门经理审批',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f60','2021-10-19 16:07:41.482',NULL,NULL,NULL,NULL,50,NULL,NULL,NULL,'','2021-10-19 16:07:41.482'),('42514',2,'holiday_test:2:40023',NULL,'_2','42501','42510',NULL,NULL,NULL,NULL,NULL,'请假申请c',NULL,NULL,NULL,'1','2021-10-19 16:14:09.488',NULL,'2021-10-19 16:14:09.708',220,NULL,50,NULL,'holiday_test',NULL,'','2021-10-19 16:14:09.708'),('42523',1,'holiday_test:2:40023',NULL,'_4','42501','42510',NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f61','2021-10-19 16:14:09.737',NULL,NULL,NULL,NULL,50,NULL,NULL,NULL,'','2021-10-19 16:14:09.737'),('45014',2,'holiday_test:2:40023',NULL,'_2','45001','45010',NULL,NULL,NULL,NULL,NULL,'请假申请c',NULL,NULL,NULL,'1','2021-10-19 16:28:08.633',NULL,'2021-10-19 16:28:08.858',225,NULL,50,NULL,'holiday_test',NULL,'','2021-10-19 16:28:08.858'),('45023',1,'holiday_test:2:40023',NULL,'_4','45001','45010',NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f61','2021-10-19 16:28:08.888',NULL,NULL,NULL,NULL,50,NULL,NULL,NULL,'','2021-10-19 16:28:08.888'),('47514',2,'holiday_test:2:40023',NULL,'_2','47501','47510',NULL,NULL,NULL,NULL,NULL,'请假申请c',NULL,NULL,NULL,'5','2021-10-19 16:41:45.511',NULL,'2021-10-19 16:41:45.662',151,NULL,50,NULL,'holiday_test',NULL,'','2021-10-19 16:41:45.662'),('47523',1,'holiday_test:2:40023',NULL,'_4','47501','47510',NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f61','2021-10-19 16:41:45.696',NULL,NULL,NULL,NULL,50,NULL,NULL,NULL,'','2021-10-19 16:41:45.696'),('50014',2,'holiday_test:2:40023',NULL,'_2','50001','50010',NULL,NULL,NULL,NULL,NULL,'请假申请c',NULL,NULL,NULL,'7','2021-10-19 17:49:39.384',NULL,'2021-10-19 17:49:39.541',157,NULL,50,NULL,'holiday_test',NULL,'','2021-10-19 17:49:39.541'),('50023',1,'holiday_test:2:40023',NULL,'_4','50001','50010',NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f61','2021-10-19 17:49:39.568',NULL,NULL,NULL,NULL,50,NULL,NULL,NULL,'','2021-10-19 17:49:39.568'),('5009',2,'holiday_test:1:4',NULL,'_2','5001','5005',NULL,NULL,NULL,NULL,NULL,'请假申请',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2021-08-28 23:28:51.008',NULL,'2021-08-28 23:28:51.098',90,NULL,50,NULL,'holiday_test',NULL,'','2021-08-28 23:28:51.098'),('5018',1,'holiday_test:1:4',NULL,'_4','5001','5005',NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f61','2021-08-28 23:28:51.115',NULL,NULL,NULL,NULL,50,NULL,NULL,NULL,'','2021-08-28 23:28:51.115'),('52514',2,'holiday_test:2:40023',NULL,'_2','52501','52510',NULL,NULL,NULL,NULL,NULL,'请假申请c',NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2021-10-20 16:05:4
|
||
|
|
|
||
|
|
/*Table structure for table `act_hi_tsk_log` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_hi_tsk_log`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_hi_tsk_log` (
|
||
|
|
`ID_` bigint NOT NULL AUTO_INCREMENT,
|
||
|
|
`TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT 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 DEFAULT NULL,
|
||
|
|
`DATA_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_tsk_log` */
|
||
|
|
|
||
|
|
/*Table structure for table `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,
|
||
|
|
`REV_` int DEFAULT '1',
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`VAR_TYPE_` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DOUBLE_` double DEFAULT NULL,
|
||
|
|
`LONG_` bigint DEFAULT NULL,
|
||
|
|
`TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
|
||
|
|
KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`),
|
||
|
|
KEY `ACT_IDX_HI_PROCVAR_EXE` (`EXECUTION_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_hi_varinst` */
|
||
|
|
|
||
|
|
insert into `act_hi_varinst`(`ID_`,`REV_`,`PROC_INST_ID_`,`EXECUTION_ID_`,`TASK_ID_`,`NAME_`,`VAR_TYPE_`,`SCOPE_ID_`,`SUB_SCOPE_ID_`,`SCOPE_TYPE_`,`BYTEARRAY_ID_`,`DOUBLE_`,`LONG_`,`TEXT_`,`TEXT2_`,`CREATE_TIME_`,`LAST_UPDATED_TIME_`) values ('2503',0,'2501','2501',NULL,'initiator','string',NULL,NULL,NULL,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2021-08-28 23:24:13.388','2021-08-28 23:24:13.388'),('2504',0,'2501','2501',NULL,'days','double',NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,'2021-08-28 23:24:13.389','2021-08-28 23:24:13.389'),('40026',1,'40024','40024',NULL,'days','string',NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'2021-10-19 16:07:41.382','2021-10-19 16:07:41.454'),('40027',1,'40024','40024',NULL,'initiator','string',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2021-10-19 16:07:41.382','2021-10-19 16:07:41.456'),('40028',1,'40024','40024',NULL,'zd','string',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2021-10-19 16:07:41.382','2021-10-19 16:07:41.457'),('40030',1,'40024','40024',NULL,'variables','serializable',NULL,NULL,NULL,'40031',NULL,NULL,NULL,NULL,'2021-10-19 16:07:41.383','2021-10-19 16:07:41.461'),('40032',1,'40024','40024',NULL,'INITIATOR','string',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'2021-10-19 16:07:41.383','2021-10-19 16:07:41.466'),('42503',1,'42501','42501',NULL,'days','string',NULL,NULL,NULL,NULL,NULL,NULL,'4',NULL,'2021-10-19 16:14:09.470','2021-10-19 16:14:09.687'),('42504',1,'42501','42501',NULL,'initiator','string',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2021-10-19 16:14:09.471','2021-10-19 16:14:09.689'),('42505',1,'42501','42501',NULL,'zd','string',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2021-10-19 16:14:09.471','2021-10-19 16:14:09.691'),('42507',1,'42501','42501',NULL,'variables','serializable',NULL,NULL,NULL,'42508',NULL,NULL,NULL,NULL,'2021-10-19 16:14:09.476','2021-10-19 16:14:09.699'),('42509',1,'42501','42501',NULL,'INITIATOR','string',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'2021-10-19 16:14:09.476','2021-10-19 16:14:09.703'),('45003',1,'45001','45001',NULL,'days','string',NULL,NULL,NULL,NULL,NULL,NULL,'4',NULL,'2021-10-19 16:28:08.610','2021-10-19 16:28:08.838'),('45004',1,'45001','45001',NULL,'initiator','string',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2021-10-19 16:28:08.611','2021-10-19 16:28:08.840'),('45005',1,'45001','45001',NULL,'zd','string',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2021-10-19 16:28:08.611','2021-10-19 16:28:08.843'),('45007',1,'45001','45001',NULL,'variables','serializable',NULL,NULL,NULL,'45008',NULL,NULL,NULL,NULL,'2021-10-19 16:28:08.618','2021-10-19 16:28:08.851'),('45009',1,'45001','45001',NULL,'INITIATOR','string',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'2021-10-19 16:28:08.618','2021-10-19 16:28:08.854'),('47503',1,'47501','47501',NULL,'days','string',NULL,NULL,NULL,NULL,NULL,NULL,'5',NULL,'2021-10-19 16:41:45.491','2021-10-19 16:41:45.643'),('47504',1,'47501','47501',NULL,'initiator','string',NULL,NULL,NULL,NULL,NULL,NULL,'5',NULL,'2021-10-19 16:41:45.491','2021-10-19 16:41:45.645'),('47505',1,'47501','47501',NULL,'zd','string',NULL,NULL,NULL,NULL,NULL,NULL,'5',NULL,'2021-10-19 16:41:45.491','2021-10-19 16:41:45.647'),('47507',1,'47501','47501',NULL,'variables','serializable',NULL,NULL,NULL,'47508',NULL,NULL,NULL,NULL,'2021-10-19 16:41:45.497','2021-10-19 16:41:45.654'),('47509',1,'47501','47501',NULL,'INITIATOR','string',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'2021-10-19 16:41:45.497','2021-10-19 16:41:45.658'),('50003',1,'50001','50001',NULL,'days','string',NULL,NULL,NULL,NULL,NULL,NULL,'7',NULL,'2021-10-19 17:49:39.365','2021-10-19 17:49:39.524'),('50004',1,'50001','50001',NULL,'initiator','string',NULL,NULL,NULL,NULL,NULL,NULL,'7',NULL,'2021-10-19 17:49:39.365','2021-10-19 17:49:39.526'),('50005',1,'50001','50001',NULL,'zd','string',NULL,NULL,NULL,NULL,NULL,NULL,'7',NULL,'2021-10-19 17:49:39.365','2021-10-19 17:49:39.528'),('50007',1,'50001','50001',NULL,'variables','serializable',NULL,NULL,NULL,'50008',NULL,NULL,NULL,NULL,'2021-10-19 17:49:39.371','2021-10-19 17:49:39.534'),('50009',1,'50001','50001',NULL,'INITIATOR','string',NULL,NULL,NULL,NULL,N
|
||
|
|
|
||
|
|
/*Table structure for table `act_id_bytearray` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_id_bytearray`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_id_bytearray` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`BYTES_` longblob,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_bytearray` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_group` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`VALUE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PASSWORD_` longblob,
|
||
|
|
`PARENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_info` */
|
||
|
|
|
||
|
|
/*Table structure for table `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_`),
|
||
|
|
KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_membership` */
|
||
|
|
|
||
|
|
/*Table structure for table `act_id_priv` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_id_priv`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_id_priv` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
UNIQUE KEY `ACT_UNIQ_PRIV_NAME` (`NAME_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_priv` */
|
||
|
|
|
||
|
|
/*Table structure for table `act_id_priv_mapping` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_id_priv_mapping`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_id_priv_mapping` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`PRIV_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_FK_PRIV_MAPPING` (`PRIV_ID_`),
|
||
|
|
KEY `ACT_IDX_PRIV_USER` (`USER_ID_`),
|
||
|
|
KEY `ACT_IDX_PRIV_GROUP` (`GROUP_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_PRIV_MAPPING` FOREIGN KEY (`PRIV_ID_`) REFERENCES `act_id_priv` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_priv_mapping` */
|
||
|
|
|
||
|
|
/*Table structure for table `act_id_property` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_id_property`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_id_property` (
|
||
|
|
`NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`VALUE_` varchar(300) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`NAME_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_property` */
|
||
|
|
|
||
|
|
insert into `act_id_property`(`NAME_`,`VALUE_`,`REV_`) values ('schema.version','6.5.0.6',1);
|
||
|
|
|
||
|
|
/*Table structure for table `act_id_token` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_id_token`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_id_token` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
`TOKEN_VALUE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TOKEN_DATE_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
|
||
|
|
`IP_ADDRESS_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`USER_AGENT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TOKEN_DATA_` varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_token` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`FIRST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`LAST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DISPLAY_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EMAIL_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PWD_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PICTURE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_id_user` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`INFO_JSON_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
|
||
|
|
KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
|
||
|
|
KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_procdef_info` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
`DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`DERIVED_FROM_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DERIVED_FROM_ROOT_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PARENT_DEPLOYMENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ENGINE_VERSION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_re_deployment` */
|
||
|
|
|
||
|
|
insert into `act_re_deployment`(`ID_`,`NAME_`,`CATEGORY_`,`KEY_`,`TENANT_ID_`,`DEPLOY_TIME_`,`DERIVED_FROM_`,`DERIVED_FROM_ROOT_`,`PARENT_DEPLOYMENT_ID_`,`ENGINE_VERSION_`) values ('1','测试1','null',NULL,'','2021-08-28 23:04:16.324',NULL,NULL,NULL,NULL),('22501','消贷主流程',NULL,NULL,'','2021-09-14 11:55:12.697',NULL,NULL,NULL,NULL),('40020','公司请假测试',NULL,NULL,'','2021-10-19 16:07:19.883',NULL,NULL,NULL,NULL),('55003','公司请假测试',NULL,NULL,'','2021-10-20 16:52:06.539',NULL,NULL,NULL,NULL),('55036','公司请假测试2',NULL,NULL,'','2021-10-20 16:58:23.609',NULL,NULL,NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`VERSION_` int DEFAULT NULL,
|
||
|
|
`META_INFO_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EDITOR_SOURCE_VALUE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
|
||
|
|
KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
|
||
|
|
KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_re_model` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`VERSION_` int NOT NULL,
|
||
|
|
`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HAS_START_FORM_KEY_` tinyint DEFAULT NULL,
|
||
|
|
`HAS_GRAPHICAL_NOTATION_` tinyint DEFAULT NULL,
|
||
|
|
`SUSPENSION_STATE_` int DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
`ENGINE_VERSION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DERIVED_FROM_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DERIVED_FROM_ROOT_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DERIVED_VERSION_` int NOT NULL DEFAULT '0',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`DERIVED_VERSION_`,`TENANT_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_re_procdef` */
|
||
|
|
|
||
|
|
insert into `act_re_procdef`(`ID_`,`REV_`,`CATEGORY_`,`NAME_`,`KEY_`,`VERSION_`,`DEPLOYMENT_ID_`,`RESOURCE_NAME_`,`DGRM_RESOURCE_NAME_`,`DESCRIPTION_`,`HAS_START_FORM_KEY_`,`HAS_GRAPHICAL_NOTATION_`,`SUSPENSION_STATE_`,`TENANT_ID_`,`ENGINE_VERSION_`,`DERIVED_FROM_`,`DERIVED_FROM_ROOT_`,`DERIVED_VERSION_`) values ('holiday_test:1:4',2,'null','公司请假测试','holiday_test',1,'1','测试1.bpmn','测试1.holiday_test.png',NULL,0,1,1,'',NULL,NULL,NULL,0),('holiday_test:2:40023',2,NULL,'公司请假测试','holiday_test',2,'40020','公司请假测试.bpmn','公司请假测试.holiday_test.png',NULL,0,1,1,'',NULL,NULL,NULL,0),('holiday_test:3:55006',2,NULL,'公司请假测试','holiday_test',3,'55003','公司请假测试.bpmn','公司请假测试.holiday_test.png',NULL,0,1,1,'',NULL,NULL,NULL,0),('holiday_test:4:55039',2,NULL,'公司请假测试2','holiday_test',4,'55036','公司请假测试2.bpmn','公司请假测试2.holiday_test.png',NULL,0,1,1,'',NULL,NULL,NULL,0),('process_02:1:22504',2,NULL,'消贷主流程','process_02',1,'22501','消贷主流程.bpmn','消贷主流程.process_02.png',NULL,0,1,1,'',NULL,NULL,NULL,0);
|
||
|
|
|
||
|
|
/*Table structure for table `act_ru_actinst` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_ru_actinst`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_ru_actinst` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`REV_` int DEFAULT '1',
|
||
|
|
`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 DEFAULT NULL,
|
||
|
|
`CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`START_TIME_` datetime(3) NOT NULL,
|
||
|
|
`END_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`DURATION_` bigint DEFAULT NULL,
|
||
|
|
`DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_RU_ACTI_START` (`START_TIME_`),
|
||
|
|
KEY `ACT_IDX_RU_ACTI_END` (`END_TIME_`),
|
||
|
|
KEY `ACT_IDX_RU_ACTI_PROC` (`PROC_INST_ID_`),
|
||
|
|
KEY `ACT_IDX_RU_ACTI_PROC_ACT` (`PROC_INST_ID_`,`ACT_ID_`),
|
||
|
|
KEY `ACT_IDX_RU_ACTI_EXEC` (`EXECUTION_ID_`),
|
||
|
|
KEY `ACT_IDX_RU_ACTI_EXEC_ACT` (`EXECUTION_ID_`,`ACT_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_actinst` */
|
||
|
|
|
||
|
|
insert into `act_ru_actinst`(`ID_`,`REV_`,`PROC_DEF_ID_`,`PROC_INST_ID_`,`EXECUTION_ID_`,`ACT_ID_`,`TASK_ID_`,`CALL_PROC_INST_ID_`,`ACT_NAME_`,`ACT_TYPE_`,`ASSIGNEE_`,`START_TIME_`,`END_TIME_`,`DURATION_`,`DELETE_REASON_`,`TENANT_ID_`) values ('10',1,'holiday_test:1:4','5','8','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-08-28 23:06:08.718','2021-08-28 23:06:08.718',0,NULL,''),('11',1,'holiday_test:1:4','5','8','_2','12',NULL,'请假申请','userTask','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2021-08-28 23:06:08.718',NULL,NULL,NULL,''),('2506',1,'holiday_test:1:4','2501','2505','_1',NULL,NULL,'开始','startEvent',NULL,'2021-08-28 23:24:13.391','2021-08-28 23:24:13.399',8,NULL,''),('2507',1,'holiday_test:1:4','2501','2505','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-08-28 23:24:13.401','2021-08-28 23:24:13.401',0,NULL,''),('2508',1,'holiday_test:1:4','2501','2505','_2','2509',NULL,'请假申请','userTask','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','2021-08-28 23:24:13.401',NULL,NULL,NULL,''),('40034',1,'holiday_test:2:40023','40024','40033','_1',NULL,NULL,'开始','startEvent',NULL,'2021-10-19 16:07:41.383','2021-10-19 16:07:41.383',0,NULL,''),('40035',1,'holiday_test:2:40023','40024','40033','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:07:41.383','2021-10-19 16:07:41.383',0,NULL,''),('40036',2,'holiday_test:2:40023','40024','40033','_2','40037',NULL,'请假申请c','userTask','1','2021-10-19 16:07:41.383','2021-10-19 16:07:41.475',92,NULL,''),('40042',1,'holiday_test:2:40023','40024','40033','sid-BA2260E5-F225-4B24-B5C9-3CCA47DA8216',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:07:41.477','2021-10-19 16:07:41.477',0,NULL,''),('40043',1,'holiday_test:2:40023','40024','40033','sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04',NULL,NULL,NULL,'exclusiveGateway',NULL,'2021-10-19 16:07:41.478','2021-10-19 16:07:41.480',2,NULL,''),('40044',1,'holiday_test:2:40023','40024','40033','sid-4C22374A-976D-4C6A-BCDA-5056EC2E4CA1',NULL,NULL,'小于等于3','sequenceFlow',NULL,'2021-10-19 16:07:41.480','2021-10-19 16:07:41.480',0,NULL,''),('40045',1,'holiday_test:2:40023','40024','40033','_3','40046',NULL,'部门经理审批','userTask','0b4d1362-b3a1-4487-9046-a5ed56bd8f60','2021-10-19 16:07:41.482',NULL,NULL,NULL,''),('42511',1,'holiday_test:2:40023','42501','42510','_1',NULL,NULL,'开始','startEvent',NULL,'2021-10-19 16:14:09.479','2021-10-19 16:14:09.485',6,NULL,''),('42512',1,'holiday_test:2:40023','42501','42510','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:14:09.488','2021-10-19 16:14:09.488',0,NULL,''),('42513',2,'holiday_test:2:40023','42501','42510','_2','42514',NULL,'请假申请c','userTask','1','2021-10-19 16:14:09.488','2021-10-19 16:14:09.717',229,NULL,''),('42519',1,'holiday_test:2:40023','42501','42510','sid-BA2260E5-F225-4B24-B5C9-3CCA47DA8216',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:14:09.719','2021-10-19 16:14:09.719',0,NULL,''),('42520',1,'holiday_test:2:40023','42501','42510','sid-57E59C9B-CF9C-4755-896B-19DAD46C1A04',NULL,NULL,NULL,'exclusiveGateway',NULL,'2021-10-19 16:14:09.720','2021-10-19 16:14:09.735',15,NULL,''),('42521',1,'holiday_test:2:40023','42501','42510','sid-7944F75F-0CD1-4C29-BB23-74032D0FDDB8',NULL,NULL,'大于3天','sequenceFlow',NULL,'2021-10-19 16:14:09.735','2021-10-19 16:14:09.735',0,NULL,''),('42522',1,'holiday_test:2:40023','42501','42510','_4','42523',NULL,'总经理审批','userTask','0b4d1362-b3a1-4487-9046-a5ed56bd8f61','2021-10-19 16:14:09.737',NULL,NULL,NULL,''),('45011',1,'holiday_test:2:40023','45001','45010','_1',NULL,NULL,'开始','startEvent',NULL,'2021-10-19 16:28:08.620','2021-10-19 16:28:08.628',8,NULL,''),('45012',1,'holiday_test:2:40023','45001','45010','sid-58A2AF54-664F-4DB8-8D92-50908CC56490',NULL,NULL,NULL,'sequenceFlow',NULL,'2021-10-19 16:28:08.633','2021-10-19 16:28:08.633',0,NULL,''),('45013',2,'holiday_test:2:40023','45001','45010','_2','45014',NULL,'请假申请c','userTask','1','2021-10-1
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`EXCLUSIVE_` tinyint(1) DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ELEMENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ELEMENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DUEDATE_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CUSTOM_VALUES_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
|
||
|
|
KEY `ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
|
||
|
|
KEY `ACT_IDX_DJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_DJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_DJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_FK_DEADLETTER_JOB_EXECUTION` (`EXECUTION_ID_`),
|
||
|
|
KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
|
||
|
|
KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF` (`PROC_DEF_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_deadletter_job` */
|
||
|
|
|
||
|
|
/*Table structure for table `act_ru_entitylink` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_ru_entitylink`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_ru_entitylink` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`LINK_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REF_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REF_SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REF_SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HIERARCHY_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_ENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`),
|
||
|
|
KEY `ACT_IDX_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_entitylink` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`EVENT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`EVENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ACTIVITY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
|
||
|
|
KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_event_subscr` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PARENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUPER_EXEC_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`IS_ACTIVE_` tinyint DEFAULT NULL,
|
||
|
|
`IS_CONCURRENT_` tinyint DEFAULT NULL,
|
||
|
|
`IS_SCOPE_` tinyint DEFAULT NULL,
|
||
|
|
`IS_EVENT_SCOPE_` tinyint DEFAULT NULL,
|
||
|
|
`IS_MI_ROOT_` tinyint DEFAULT NULL,
|
||
|
|
`SUSPENSION_STATE_` int DEFAULT NULL,
|
||
|
|
`CACHED_ENT_STATE_` int DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`START_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`START_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`START_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`IS_COUNT_ENABLED_` tinyint DEFAULT NULL,
|
||
|
|
`EVT_SUBSCR_COUNT_` int DEFAULT NULL,
|
||
|
|
`TASK_COUNT_` int DEFAULT NULL,
|
||
|
|
`JOB_COUNT_` int DEFAULT NULL,
|
||
|
|
`TIMER_JOB_COUNT_` int DEFAULT NULL,
|
||
|
|
`SUSP_JOB_COUNT_` int DEFAULT NULL,
|
||
|
|
`DEADLETTER_JOB_COUNT_` int DEFAULT NULL,
|
||
|
|
`VAR_COUNT_` int DEFAULT NULL,
|
||
|
|
`ID_LINK_COUNT_` int DEFAULT NULL,
|
||
|
|
`CALLBACK_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CALLBACK_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REFERENCE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`REFERENCE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROPAGATED_STAGE_INST_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
|
||
|
|
KEY `ACT_IDC_EXEC_ROOT` (`ROOT_PROC_INST_ID_`),
|
||
|
|
KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
|
||
|
|
KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
|
||
|
|
KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
|
||
|
|
KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE,
|
||
|
|
CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
|
||
|
|
CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_execution` */
|
||
|
|
|
||
|
|
insert into `act_ru_execution`(`ID_`,`REV_`,`PROC_INST_ID_`,`BUSINESS_KEY_`,`PARENT_ID_`,`PROC_DEF_ID_`,`SUPER_EXEC_`,`ROOT_PROC_INST_ID_`,`ACT_ID_`,`IS_ACTIVE_`,`IS_CONCURRENT_`,`IS_SCOPE_`,`IS_EVENT_SCOPE_`,`IS_MI_ROOT_`,`SUSPENSION_STATE_`,`CACHED_ENT_STATE_`,`TENANT_ID_`,`NAME_`,`START_ACT_ID_`,`START_TIME_`,`START_USER_ID_`,`LOCK_TIME_`,`IS_COUNT_ENABLED_`,`EVT_SUBSCR_COUNT_`,`TASK_COUNT_`,`JOB_COUNT_`,`TIMER_JOB_COUNT_`,`SUSP_JOB_COUNT_`,`DEADLETTER_JOB_COUNT_`,`VAR_COUNT_`,`ID_LINK_COUNT_`,`CALLBACK_ID_`,`CALLBACK_TYPE_`,`REFERENCE_ID_`,`REFERENCE_TYPE_`,`PROPAGATED_STAGE_INST_ID_`) values ('2501',1,'2501',NULL,NULL,'holiday_test:1:4',NULL,'2501',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-08-28 23:24:13.330','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('2505',1,'2501',NULL,'2501','holiday_test:1:4',NULL,'2501','_2',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-08-28 23:24:13.390',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('40024',1,'40024',NULL,NULL,'holiday_test:2:40023',NULL,'40024',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-10-19 16:07:41.382','fff5040e-3ea5-4df0-bbd2-714ee93e1c20',NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('40033',2,'40024',NULL,'40024','holiday_test:2:40023',NULL,'40024','_3',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-10-19 16:07:41.383',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('42501',1,'42501',NULL,NULL,'holiday_test:2:40023',NULL,'42501',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-10-19 16:14:09.449','7a5ff7d1-1aff-4baa-901b-e6143d7c84ea',NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('42510',2,'42501',NULL,'42501','holiday_test:2:40023',NULL,'42501','_4',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-10-19 16:14:09.478',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('45001',1,'45001',NULL,NULL,'holiday_test:2:40023',NULL,'45001',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-10-19 16:28:08.587','bc59f6f1-f5c8-463f-86af-b68e9ddc800c',NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('45010',2,'45001',NULL,'45001','holiday_test:2:40023',NULL,'45001','_4',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-10-19 16:28:08.619',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('47501',1,'47501',NULL,NULL,'holiday_test:2:40023',NULL,'47501',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-10-19 16:41:45.464','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('47510',2,'47501',NULL,'47501','holiday_test:2:40023',NULL,'47501','_4',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-10-19 16:41:45.498',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('5',1,'5',NULL,NULL,'holiday_test:1:4',NULL,'5',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-08-28 23:06:08.707',NULL,NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('50001',1,'50001',NULL,NULL,'holiday_test:2:40023',NULL,'50001',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-10-19 17:49:39.342','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('5001',1,'5001',NULL,NULL,'holiday_test:1:4',NULL,'5001',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-08-28 23:28:50.949','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('50010',2,'50001',NULL,'50001','holiday_test:2:40023',NULL,'50001','_4',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-10-19 17:49:39.372',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('5005',2,'5001',NULL,'5001','holiday_test:1:4',NULL,'5001','_4',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-08-28 23:28:51.002',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('52501',1,'52501',NULL,NULL,'holiday_test:2:40023',NULL,'52501',NULL,1,0,1,0,0,1,NULL,'',NULL,'_1','2021-10-20 16:05:41.429','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,1,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('52510',2,'52501',NULL,'52501','holiday_test:2:40023',NULL,'52501','_4',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-10-20 16:05:41.459',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL),('8',1,'5',NULL,'5','holiday_test:1:4',NULL,'5','_2',1,0,0,0,0,1,NULL,'',NULL,NULL,'2021-08-28 23:06:08.710',NULL,NULL,1,0,1,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `act_ru_history_job` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `act_ru_history_job`;
|
||
|
|
|
||
|
|
CREATE TABLE `act_ru_history_job` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
`LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`RETRIES_` int DEFAULT NULL,
|
||
|
|
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CUSTOM_VALUES_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ADV_HANDLER_CFG_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_history_job` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
|
||
|
|
KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
|
||
|
|
KEY `ACT_IDX_IDENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
|
||
|
|
KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
|
||
|
|
KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_identitylink` */
|
||
|
|
|
||
|
|
insert into `act_ru_identitylink`(`ID_`,`REV_`,`GROUP_ID_`,`TYPE_`,`USER_ID_`,`TASK_ID_`,`PROC_INST_ID_`,`PROC_DEF_ID_`,`SCOPE_ID_`,`SUB_SCOPE_ID_`,`SCOPE_TYPE_`,`SCOPE_DEFINITION_ID_`) values ('14',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'5',NULL,NULL,NULL,NULL,NULL),('2502',1,NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2501',NULL,NULL,NULL,NULL,NULL),('2511',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'2501',NULL,NULL,NULL,NULL,NULL),('40025',1,NULL,'starter','fff5040e-3ea5-4df0-bbd2-714ee93e1c20',NULL,'40024',NULL,NULL,NULL,NULL,NULL),('40039',1,NULL,'participant','1',NULL,'40024',NULL,NULL,NULL,NULL,NULL),('40041',1,NULL,'participant','fff5040e-3ea5-4df0-bbd2-714ee93e1c20',NULL,'40024',NULL,NULL,NULL,NULL,NULL),('40048',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f60',NULL,'40024',NULL,NULL,NULL,NULL,NULL),('42502',1,NULL,'starter','7a5ff7d1-1aff-4baa-901b-e6143d7c84ea',NULL,'42501',NULL,NULL,NULL,NULL,NULL),('42516',1,NULL,'participant','1',NULL,'42501',NULL,NULL,NULL,NULL,NULL),('42518',1,NULL,'participant','7a5ff7d1-1aff-4baa-901b-e6143d7c84ea',NULL,'42501',NULL,NULL,NULL,NULL,NULL),('42525',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'42501',NULL,NULL,NULL,NULL,NULL),('45002',1,NULL,'starter','bc59f6f1-f5c8-463f-86af-b68e9ddc800c',NULL,'45001',NULL,NULL,NULL,NULL,NULL),('45016',1,NULL,'participant','1',NULL,'45001',NULL,NULL,NULL,NULL,NULL),('45018',1,NULL,'participant','bc59f6f1-f5c8-463f-86af-b68e9ddc800c',NULL,'45001',NULL,NULL,NULL,NULL,NULL),('45025',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'45001',NULL,NULL,NULL,NULL,NULL),('47502',1,NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'47501',NULL,NULL,NULL,NULL,NULL),('47516',1,NULL,'participant','5',NULL,'47501',NULL,NULL,NULL,NULL,NULL),('47518',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'47501',NULL,NULL,NULL,NULL,NULL),('47525',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'47501',NULL,NULL,NULL,NULL,NULL),('50002',1,NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'50001',NULL,NULL,NULL,NULL,NULL),('50016',1,NULL,'participant','7',NULL,'50001',NULL,NULL,NULL,NULL,NULL),('50018',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'50001',NULL,NULL,NULL,NULL,NULL),('5002',1,NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'5001',NULL,NULL,NULL,NULL,NULL),('50025',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'50001',NULL,NULL,NULL,NULL,NULL),('5011',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'5001',NULL,NULL,NULL,NULL,NULL),('5013',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'5001',NULL,NULL,NULL,NULL,NULL),('5020',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'5001',NULL,NULL,NULL,NULL,NULL),('52502',1,NULL,'starter','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'52501',NULL,NULL,NULL,NULL,NULL),('52516',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'52501',NULL,NULL,NULL,NULL,NULL),('52518',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,'52501',NULL,NULL,NULL,NULL,NULL),('52525',1,NULL,'participant','0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,'52501',NULL,NULL,NULL,NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `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 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 DEFAULT NULL,
|
||
|
|
`EXCLUSIVE_` tinyint(1) DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ELEMENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ELEMENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`RETRIES_` int DEFAULT NULL,
|
||
|
|
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DUEDATE_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CUSTOM_VALUES_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
|
||
|
|
KEY `ACT_IDX_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
|
||
|
|
KEY `ACT_IDX_JOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_JOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_JOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_FK_JOB_EXECUTION` (`EXECUTION_ID_`),
|
||
|
|
KEY `ACT_FK_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
|
||
|
|
KEY `ACT_FK_JOB_PROC_DEF` (`PROC_DEF_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_job` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`EXCLUSIVE_` tinyint(1) DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ELEMENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ELEMENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`RETRIES_` int DEFAULT NULL,
|
||
|
|
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DUEDATE_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CUSTOM_VALUES_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
|
||
|
|
KEY `ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
|
||
|
|
KEY `ACT_IDX_SJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_SJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_SJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_FK_SUSPENDED_JOB_EXECUTION` (`EXECUTION_ID_`),
|
||
|
|
KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
|
||
|
|
KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF` (`PROC_DEF_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_suspended_job` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROPAGATED_STAGE_INST_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DELEGATION_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PRIORITY_` int DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`DUE_DATE_` datetime(3) DEFAULT NULL,
|
||
|
|
`CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUSPENSION_STATE_` int DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
`FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CLAIM_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`IS_COUNT_ENABLED_` tinyint DEFAULT NULL,
|
||
|
|
`VAR_COUNT_` int DEFAULT NULL,
|
||
|
|
`ID_LINK_COUNT_` int DEFAULT NULL,
|
||
|
|
`SUB_TASK_COUNT_` int DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
|
||
|
|
KEY `ACT_IDX_TASK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
|
||
|
|
KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
|
||
|
|
KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_task` */
|
||
|
|
|
||
|
|
insert into `act_ru_task`(`ID_`,`REV_`,`EXECUTION_ID_`,`PROC_INST_ID_`,`PROC_DEF_ID_`,`TASK_DEF_ID_`,`SCOPE_ID_`,`SUB_SCOPE_ID_`,`SCOPE_TYPE_`,`SCOPE_DEFINITION_ID_`,`PROPAGATED_STAGE_INST_ID_`,`NAME_`,`PARENT_TASK_ID_`,`DESCRIPTION_`,`TASK_DEF_KEY_`,`OWNER_`,`ASSIGNEE_`,`DELEGATION_`,`PRIORITY_`,`CREATE_TIME_`,`DUE_DATE_`,`CATEGORY_`,`SUSPENSION_STATE_`,`TENANT_ID_`,`FORM_KEY_`,`CLAIM_TIME_`,`IS_COUNT_ENABLED_`,`VAR_COUNT_`,`ID_LINK_COUNT_`,`SUB_TASK_COUNT_`) values ('12',1,'8','5','holiday_test:1:4',NULL,NULL,NULL,NULL,NULL,NULL,'请假申请',NULL,NULL,'_2',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,50,'2021-08-28 23:06:08.718',NULL,NULL,1,'','holiday_test',NULL,1,0,0,0),('2509',1,'2505','2501','holiday_test:1:4',NULL,NULL,NULL,NULL,NULL,NULL,'请假申请',NULL,NULL,'_2',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,50,'2021-08-28 23:24:13.401',NULL,NULL,1,'','holiday_test',NULL,1,0,0,0),('40046',1,'40033','40024','holiday_test:2:40023',NULL,NULL,NULL,NULL,NULL,NULL,'部门经理审批',NULL,NULL,'_3',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f60',NULL,50,'2021-10-19 16:07:41.482',NULL,NULL,1,'',NULL,NULL,1,0,0,0),('42523',1,'42510','42501','holiday_test:2:40023',NULL,NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,'_4',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f61',NULL,50,'2021-10-19 16:14:09.737',NULL,NULL,1,'',NULL,NULL,1,0,0,0),('45023',1,'45010','45001','holiday_test:2:40023',NULL,NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,'_4',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,50,'2021-10-19 16:28:08.888',NULL,NULL,1,'',NULL,NULL,1,0,0,0),('47523',1,'47510','47501','holiday_test:2:40023',NULL,NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,'_4',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,50,'2021-10-19 16:41:45.696',NULL,NULL,1,'',NULL,NULL,1,0,0,0),('50023',1,'50010','50001','holiday_test:2:40023',NULL,NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,'_4',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,50,'2021-10-19 17:49:39.568',NULL,NULL,1,'',NULL,NULL,1,0,0,0),('5018',1,'5005','5001','holiday_test:1:4',NULL,NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,'_4',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,50,'2021-08-28 23:28:51.115',NULL,NULL,1,'',NULL,NULL,1,0,0,0),('52523',1,'52510','52501','holiday_test:2:40023',NULL,NULL,NULL,NULL,NULL,NULL,'总经理审批',NULL,NULL,'_4',NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL,50,'2021-10-20 16:05:41.661',NULL,NULL,1,'',NULL,NULL,1,0,0,0);
|
||
|
|
|
||
|
|
/*Table structure for table `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 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 DEFAULT NULL,
|
||
|
|
`EXCLUSIVE_` tinyint(1) DEFAULT NULL,
|
||
|
|
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ELEMENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`ELEMENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_DEFINITION_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`RETRIES_` int DEFAULT NULL,
|
||
|
|
`EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DUEDATE_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CUSTOM_VALUES_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
|
||
|
|
KEY `ACT_IDX_TIMER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
|
||
|
|
KEY `ACT_IDX_TJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_TJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_TJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_FK_TIMER_JOB_EXECUTION` (`EXECUTION_ID_`),
|
||
|
|
KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
|
||
|
|
KEY `ACT_FK_TIMER_JOB_PROC_DEF` (`PROC_DEF_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TIMER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_timer_job` */
|
||
|
|
|
||
|
|
/*Table structure for table `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 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 DEFAULT NULL,
|
||
|
|
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`DOUBLE_` double DEFAULT NULL,
|
||
|
|
`LONG_` bigint DEFAULT NULL,
|
||
|
|
`TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `ACT_IDX_RU_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_IDX_RU_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
|
||
|
|
KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
|
||
|
|
KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
|
||
|
|
KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
|
||
|
|
KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
||
|
|
CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `act_ru_variable` */
|
||
|
|
|
||
|
|
insert into `act_ru_variable`(`ID_`,`REV_`,`TYPE_`,`NAME_`,`EXECUTION_ID_`,`PROC_INST_ID_`,`TASK_ID_`,`SCOPE_ID_`,`SUB_SCOPE_ID_`,`SCOPE_TYPE_`,`BYTEARRAY_ID_`,`DOUBLE_`,`LONG_`,`TEXT_`,`TEXT2_`) values ('2503',1,'string','initiator','2501','2501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL),('2504',1,'double','days','2501','2501',NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL),('40026',1,'string','days','40024','40024',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL),('40027',1,'string','initiator','40024','40024',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL),('40028',1,'string','zd','40024','40024',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL),('40030',1,'serializable','variables','40024','40024',NULL,NULL,NULL,NULL,'40029',NULL,NULL,NULL,NULL),('40032',1,'string','INITIATOR','40024','40024',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),('42503',1,'string','days','42501','42501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4',NULL),('42504',1,'string','initiator','42501','42501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL),('42505',1,'string','zd','42501','42501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL),('42507',1,'serializable','variables','42501','42501',NULL,NULL,NULL,NULL,'42506',NULL,NULL,NULL,NULL),('42509',1,'string','INITIATOR','42501','42501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),('45003',1,'string','days','45001','45001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4',NULL),('45004',1,'string','initiator','45001','45001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL),('45005',1,'string','zd','45001','45001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL),('45007',1,'serializable','variables','45001','45001',NULL,NULL,NULL,NULL,'45006',NULL,NULL,NULL,NULL),('45009',1,'string','INITIATOR','45001','45001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),('47503',1,'string','days','47501','47501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5',NULL),('47504',1,'string','initiator','47501','47501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5',NULL),('47505',1,'string','zd','47501','47501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5',NULL),('47507',1,'serializable','variables','47501','47501',NULL,NULL,NULL,NULL,'47506',NULL,NULL,NULL,NULL),('47509',1,'string','INITIATOR','47501','47501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),('50003',1,'string','days','50001','50001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7',NULL),('50004',1,'string','initiator','50001','50001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7',NULL),('50005',1,'string','zd','50001','50001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7',NULL),('50007',1,'serializable','variables','50001','50001',NULL,NULL,NULL,NULL,'50006',NULL,NULL,NULL,NULL),('50009',1,'string','INITIATOR','50001','50001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),('5003',1,'string','initiator','5001','5001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL),('5004',1,'double','days','5001','5001',NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL),('52503',1,'string','days','52501','52501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5',NULL),('52504',1,'string','initiator','52501','52501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL),('52505',1,'string','zd','52501','52501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'5',NULL),('52507',1,'serializable','variables','52501','52501',NULL,NULL,NULL,NULL,'52506',NULL,NULL,NULL,NULL),('52509',1,'string','INITIATOR','52501','52501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),('6',1,'string','initiator','5','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',NULL),('7',1,'double','days','5','5',NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `dict_common` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `dict_common`;
|
||
|
|
|
||
|
|
CREATE TABLE `dict_common` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
|
|
`sid` varchar(50) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '版本锁',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`isDelete` int NOT NULL DEFAULT '0' COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`state` int NOT NULL DEFAULT '1' COMMENT '记录状态值',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`createBySid` varchar(36) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBysid` varchar(36) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`remarks` varchar(1024) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`dictKey` varchar(1024) NOT NULL COMMENT 'key值',
|
||
|
|
`dictType` varchar(1024) NOT NULL COMMENT '类型',
|
||
|
|
`dictValue` varchar(1024) NOT NULL COMMENT 'value值',
|
||
|
|
`sidPath` varchar(1024) DEFAULT NULL COMMENT '路径',
|
||
|
|
`parentSid` varchar(1024) DEFAULT NULL COMMENT '父级sid',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `com_dictvalue_name` (`dictValue`(255)),
|
||
|
|
KEY `com_dicttype_name` (`dictType`(255)),
|
||
|
|
KEY `com_dictkey_name` (`dictKey`(255)),
|
||
|
|
KEY `com_isdelete_name` (`isDelete`),
|
||
|
|
KEY `psid` (`parentSid`(255)),
|
||
|
|
KEY `sid` (`sid`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=226 DEFAULT CHARSET=utf8 COMMENT='数据字典——数据项';
|
||
|
|
|
||
|
|
/*Data for the table `dict_common` */
|
||
|
|
|
||
|
|
insert into `dict_common`(`id`,`sid`,`lockVersion`,`isEnable`,`isDelete`,`state`,`createTime`,`modifyTime`,`createBySid`,`updateBysid`,`remarks`,`dictKey`,`dictType`,`dictValue`,`sidPath`,`parentSid`) values (1,'98e18632-7bed-4330-abd8-da3885f02920',0,1,0,1,'2021-06-24 10:27:34','2021-06-24 10:27:34',NULL,NULL,NULL,'0001','registNumType','商事与非商事登记证号',NULL,'0'),(2,'63ce9008-9cc7-4f44-90b9-0171ea726fdb',0,1,0,1,'2021-06-24 10:38:08','2021-06-24 10:38:08',NULL,NULL,NULL,'0002','registNumType','宗教活动场所登记号',NULL,'0'),(3,'f24f8f56-0b71-49b9-aec1-b67b03e70798',0,1,0,1,'2021-06-24 10:48:15','2021-06-24 10:48:15',NULL,NULL,NULL,'0003','registNumType','统一社会信用代码',NULL,'0'),(4,'a60c7ef3-8518-47db-b1a2-b4b1c353abbd',0,1,0,1,'2021-06-24 10:48:35','2021-06-24 10:48:35',NULL,NULL,NULL,'0004','registNumType','工商注册号',NULL,'0'),(5,'c0427134-dfa6-4615-9bb1-fcd165451974',0,1,0,1,'2021-06-24 10:48:50','2021-06-24 10:48:50',NULL,NULL,NULL,'0005','registNumType','身份证',NULL,'0'),(6,'6848c1d9-83a9-4173-bd9c-884c650c50bf',0,1,0,1,'2021-06-24 10:49:20','2021-06-24 10:49:20',NULL,NULL,NULL,'0006','registNumType','民办非企业单位登记号',NULL,'0'),(7,'36ce1377-f0f1-4a78-a039-144dfad4639c',0,1,0,1,'2021-06-24 10:49:35','2021-06-24 10:49:35',NULL,NULL,NULL,'0007','registNumType','基金会登记号',NULL,'0'),(8,'753883cb-fa9d-45a7-afa1-e8fd1c1f639d',0,1,0,1,'2021-06-24 10:49:54','2021-06-24 10:49:54',NULL,NULL,NULL,'0008','registNumType','机关和事业单位登记号',NULL,'0'),(9,'77211ca0-ae8e-45cd-828e-fee1686be0d3',0,1,0,1,'2021-06-24 10:50:12','2021-06-24 10:50:12',NULL,NULL,NULL,'0009','registNumType','社会团体登记号',NULL,'0'),(10,'79681004-a81b-44b5-82d3-1af85a1508f3',0,1,0,1,'2021-06-24 10:50:33','2021-06-24 10:50:33',NULL,NULL,NULL,'0010','registNumType','其他',NULL,'0'),(11,'9d218f0c-6a1c-49ca-97c4-22b3c7894617',0,1,0,1,'2021-06-24 11:02:45','2021-06-24 11:02:45',NULL,NULL,NULL,'0001','maritalstatus','丧偶Widow',NULL,'0'),(12,'baa1b34e-5765-45ac-8a58-6ad1aee73f5e',0,1,0,1,'2021-06-24 11:15:16','2021-06-24 11:15:16',NULL,NULL,NULL,'0003','maritalstatus','离婚Divorced',NULL,'0'),(13,'ae50a0fb-f369-47be-b6a2-fc111bee840d',0,1,0,1,'2021-06-24 11:16:29','2021-06-24 11:16:29',NULL,NULL,NULL,'0004','maritalstatus','已婚Married',NULL,'0'),(14,'07729607-baf9-49e2-99f2-fb5a815cf3b3',0,1,0,1,'2021-06-24 11:16:45','2021-06-24 11:16:45',NULL,NULL,NULL,'0005','maritalstatus','其他Others',NULL,'0'),(15,'da8fe2dc-27af-44ea-8d3f-285ca1eecde3',0,1,0,1,'2021-06-24 11:20:46','2021-06-24 11:20:46',NULL,NULL,NULL,'0001','currentlivestate','全款自购商品房',NULL,'0'),(16,'d0672cd9-01e9-4abf-b3eb-96f668916c1e',0,1,0,1,'2021-06-24 11:21:04','2021-06-24 11:21:04',NULL,NULL,NULL,'0002','currentlivestate','按揭自购商品房',NULL,'0'),(17,'24d57b51-285b-4f18-ac58-76d617df1301',0,1,0,1,'2021-06-24 11:21:24','2021-06-24 11:21:24',NULL,NULL,NULL,'0003','currentlivestate','租赁房',NULL,'0'),(18,'8df3941b-cae6-4305-8bc8-b118d30a55a1',0,1,0,1,'2021-06-24 11:21:37','2021-06-24 11:21:37',NULL,NULL,NULL,'0004','currentlivestate','直系亲属房',NULL,'0'),(19,'80691f8f-17ee-40b6-bfd8-0af15dfab1c8',0,1,0,1,'2021-06-24 11:21:55','2021-06-24 11:21:55',NULL,NULL,NULL,'0005','currentlivestate','按揭自购经适房',NULL,'0'),(20,'d57eb584-7842-4c9a-a993-916aa5f17107',0,1,0,1,'2021-06-24 11:22:12','2021-06-24 11:22:12',NULL,NULL,NULL,'0006','currentlivestate','公司房',NULL,'0'),(21,'62352211-18bf-4c36-bed0-07ff2587e032',0,1,0,1,'2021-06-24 11:22:26','2021-06-24 11:22:26',NULL,NULL,NULL,'0007','currentlivestate','自建房',NULL,'0'),(22,'334467fb-ce2c-43a7-add5-3e1b7e165ee5',0,1,0,1,'2021-06-24 11:22:40','2021-06-24 11:22:40',NULL,NULL,NULL,'0008','currentlivestate','全款自购经适房',NULL,'0'),(23,'2a5e53fa-abe8-4e8e-89d3-dd4c99096e4c',0,1,0,1,'2021-06-24 11:22:49','2021-06-24 11:22:49',NULL,NULL,NULL,'0009','currentlivestate','其他',NULL,'0'),(24,'00e5f87a-638e-45c2-9fa0-97cc5de9bdca',0,1,0,1,'2021-06-24 11:25:50','2021-06-24 11:25:50',NULL,NULL,NULL,'0001','
|
||
|
|
|
||
|
|
/*Table structure for table `dict_type` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `dict_type`;
|
||
|
|
|
||
|
|
CREATE TABLE `dict_type` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
|
|
`sid` varchar(50) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`isDelete` int NOT NULL DEFAULT '0' COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT NULL COMMENT '记录修改时间',
|
||
|
|
`state` int NOT NULL DEFAULT '1' COMMENT '状态值',
|
||
|
|
`remarks` varchar(1024) DEFAULT NULL COMMENT '备注',
|
||
|
|
`createBySid` varchar(36) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(36) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`dictTypeCode` varchar(36) NOT NULL COMMENT '类型代码',
|
||
|
|
`dictTypeName` varchar(50) NOT NULL COMMENT '类型名称',
|
||
|
|
`dictTypeLevel` varchar(50) DEFAULT NULL COMMENT '级别',
|
||
|
|
`name` varchar(200) DEFAULT NULL COMMENT '名称',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `dict_type_code` (`dictTypeCode`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='数据字典——数据类型';
|
||
|
|
|
||
|
|
/*Data for the table `dict_type` */
|
||
|
|
|
||
|
|
insert into `dict_type`(`id`,`sid`,`lockVersion`,`isEnable`,`isDelete`,`createTime`,`modifyTime`,`state`,`remarks`,`createBySid`,`updateBySid`,`dictTypeCode`,`dictTypeName`,`dictTypeLevel`,`name`) values (1,'de2a8065-c5be-415d-a541-b0ba28f83bce',0,1,0,'2021-06-23 18:31:34','2021-06-23 18:31:34',1,'登记注册号类型',NULL,NULL,'registNumType','登记注册号类型',NULL,NULL),(2,'5cbc374e-0d13-44fe-ad38-64d1f3ca9947',0,1,0,'2021-06-24 11:01:57','2021-06-24 11:01:57',1,'婚姻状况',NULL,NULL,'maritalstatus','婚姻状况',NULL,NULL),(3,'5140b2d0-6d60-450d-bf23-b6177c3fc25b',0,1,0,'2021-06-24 11:20:21','2021-06-24 11:20:21',1,'现居住状况',NULL,NULL,'currentlivestate','现居住状况',NULL,NULL),(4,'8a36c355-5894-47ef-a5c8-4959b561ca37',0,1,0,'2021-06-24 11:24:41','2021-06-24 11:24:41',1,'教育程度',NULL,NULL,'educationdegree','教育程度',NULL,NULL),(5,'08b7238a-42c9-4358-8190-f054b4eee812',0,1,0,'2021-06-24 11:28:41','2021-06-24 11:28:41',1,'雇员类型',NULL,NULL,'employeetype','雇员类型',NULL,NULL),(6,'dd538b72-28de-403e-a941-3d0002d5846d',0,1,0,'2021-06-24 11:42:52','2021-06-24 11:42:52',1,'证件类型',NULL,NULL,'documenttype','证件类型',NULL,NULL),(7,'85e78107-7001-4abc-9614-6f87146e5002',0,1,0,'2021-06-24 13:44:07','2021-06-24 13:44:07',1,'客户类型',NULL,NULL,'customertype','客户类型',NULL,NULL),(8,'42760646-74fb-4a86-ac1a-24bfe17dd10c',0,1,0,'2021-06-24 13:46:34','2021-06-24 13:46:34',1,'行业类型',NULL,NULL,'industrytype','行业类别',NULL,NULL),(9,'38d85827-77d0-4c73-a6fc-7680148e9d34',0,1,0,'2021-06-24 14:15:08','2021-06-24 14:15:08',1,'经济类型',NULL,NULL,'economictype','经济类型',NULL,NULL),(10,'d20f0806-bd76-49ef-a629-6ce52a876b1a',0,1,0,'2021-06-24 14:18:07','2021-06-24 14:18:07',1,'组织结构类别',NULL,NULL,'organizationtype','组织机构类别',NULL,NULL),(11,'293b266b-a78e-4aec-8d76-4f077238b5f4',0,1,0,'2021-06-24 14:28:07','2021-06-24 14:28:07',1,'组织结构类别细分',NULL,NULL,'organizationtypedetails','组织机构类别细分',NULL,NULL),(12,'a36b3936-9f0e-4ab9-9751-5dc8a65bfa5f',0,1,0,'2021-07-08 16:16:39','2021-07-08 16:16:39',1,'民族',NULL,NULL,'national','民族',NULL,NULL),(13,'74b36b3f-d3a0-437b-ac52-471ee8eb1af1',0,1,0,'2021-07-08 17:10:59','2021-07-08 17:10:59',1,'是或否',NULL,NULL,'isTrue','是或否',NULL,NULL),(14,'8acd2939-4e77-451d-a542-bb86594c5caa',0,1,0,'2021-07-10 09:00:23','2021-07-10 09:00:23',1,'准驾车型',NULL,NULL,'carType','准驾车型',NULL,NULL),(15,'0e7b9851-b130-4af9-bd3c-eaef3a9ea7db',0,1,0,'2021-07-12 10:48:11','2021-07-12 10:48:11',1,'性别',NULL,NULL,'sex','性别',NULL,NULL),(16,'8c957dbe-1836-4d88-a15f-57aa801fcb10',0,1,0,'2021-07-12 10:50:20','2021-07-12 10:50:20',1,'与客户关系',NULL,NULL,'relationship','与客户关系',NULL,NULL),(17,'91a654b9-201e-4655-9d6b-03eafb02b905',0,1,0,'2021-07-12 10:52:34','2021-07-12 10:52:34',1,'现工作单位性质',NULL,NULL,'orgNature','现工作单位性质',NULL,NULL),(18,'1b48eff3-428c-4369-b8fa-38b0dcbba433',0,1,0,'2021-07-12 10:54:46','2021-07-12 10:54:46',1,'主要收入来源',NULL,NULL,'incomeSource','主要收入来源',NULL,NULL),(19,'af626b29-6459-40fb-b09a-fe4f8858ffd5',0,1,0,'2021-07-12 10:57:11','2021-07-12 10:57:11',1,'职位',NULL,NULL,'position','职位',NULL,NULL),(20,'d1fb570c-5e4f-4d3c-a836-e8535d0c6caf',0,1,0,'2021-07-12 11:00:01','2021-07-12 11:00:01',1,'经销商类型',NULL,NULL,'dealersType','经销商类型',NULL,NULL),(21,'8f278bb9-836e-4b6a-8893-1b8ab87e6acc',0,1,0,'2021-07-12 11:03:19','2021-07-12 11:03:19',1,'附件类型',NULL,NULL,'attachType','附件类型',NULL,NULL),(22,'444e8399-6fb5-4421-a892-2868a992a1f6',0,1,0,'2021-07-12 11:08:50','2021-07-12 11:08:50',1,'信用记录',NULL,NULL,'creditRecord','信用记录',NULL,NULL),(23,'ee29a3c9-ff75-4a4a-818c-f2eca8762749',0,1,0,'2021-07-12 11:11:30','2021-07-12 11:11:30',1,'拟租赁形式',NULL,NULL,'plansToLease','拟租赁形式',NULL,NULL),(24,'692a9478-ba21-496c-a553-24cf56e54d85',0,1,0,'2021-07-12 11:12:48','2021-07-12 11:12:48',1,'去返程货物',NULL,NULL,'goGoods','去返
|
||
|
|
|
||
|
|
/*Table structure for table `flw_channel_definition` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `flw_channel_definition`;
|
||
|
|
|
||
|
|
CREATE TABLE `flw_channel_definition` (
|
||
|
|
`ID_` varchar(255) NOT NULL,
|
||
|
|
`NAME_` varchar(255) DEFAULT NULL,
|
||
|
|
`VERSION_` int DEFAULT NULL,
|
||
|
|
`KEY_` varchar(255) DEFAULT NULL,
|
||
|
|
`CATEGORY_` varchar(255) DEFAULT NULL,
|
||
|
|
`DEPLOYMENT_ID_` varchar(255) DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) DEFAULT NULL,
|
||
|
|
`RESOURCE_NAME_` varchar(255) DEFAULT NULL,
|
||
|
|
`DESCRIPTION_` varchar(255) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
UNIQUE KEY `ACT_IDX_CHANNEL_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `flw_channel_definition` */
|
||
|
|
|
||
|
|
/*Table structure for table `flw_ev_databasechangelog` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `flw_ev_databasechangelog`;
|
||
|
|
|
||
|
|
CREATE TABLE `flw_ev_databasechangelog` (
|
||
|
|
`ID` varchar(255) NOT NULL,
|
||
|
|
`AUTHOR` varchar(255) NOT NULL,
|
||
|
|
`FILENAME` varchar(255) NOT NULL,
|
||
|
|
`DATEEXECUTED` datetime NOT NULL,
|
||
|
|
`ORDEREXECUTED` int NOT NULL,
|
||
|
|
`EXECTYPE` varchar(10) NOT NULL,
|
||
|
|
`MD5SUM` varchar(35) DEFAULT NULL,
|
||
|
|
`DESCRIPTION` varchar(255) DEFAULT NULL,
|
||
|
|
`COMMENTS` varchar(255) DEFAULT NULL,
|
||
|
|
`TAG` varchar(255) DEFAULT NULL,
|
||
|
|
`LIQUIBASE` varchar(20) DEFAULT NULL,
|
||
|
|
`CONTEXTS` varchar(255) DEFAULT NULL,
|
||
|
|
`LABELS` varchar(255) DEFAULT NULL,
|
||
|
|
`DEPLOYMENT_ID` varchar(10) DEFAULT NULL
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `flw_ev_databasechangelog` */
|
||
|
|
|
||
|
|
insert into `flw_ev_databasechangelog`(`ID`,`AUTHOR`,`FILENAME`,`DATEEXECUTED`,`ORDEREXECUTED`,`EXECTYPE`,`MD5SUM`,`DESCRIPTION`,`COMMENTS`,`TAG`,`LIQUIBASE`,`CONTEXTS`,`LABELS`,`DEPLOYMENT_ID`) values ('1','flowable','org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml','2021-08-28 22:23:14',1,'EXECUTED','8:1b0c48c9cf7945be799d868a2626d687','createTable tableName=FLW_EVENT_DEPLOYMENT; createTable tableName=FLW_EVENT_RESOURCE; createTable tableName=FLW_EVENT_DEFINITION; createIndex indexName=ACT_IDX_EVENT_DEF_UNIQ, tableName=FLW_EVENT_DEFINITION; createTable tableName=FLW_CHANNEL_DEFIN...','',NULL,'3.8.9',NULL,NULL,'0160594225');
|
||
|
|
|
||
|
|
/*Table structure for table `flw_ev_databasechangeloglock` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `flw_ev_databasechangeloglock`;
|
||
|
|
|
||
|
|
CREATE TABLE `flw_ev_databasechangeloglock` (
|
||
|
|
`ID` int NOT NULL,
|
||
|
|
`LOCKED` bit(1) NOT NULL,
|
||
|
|
`LOCKGRANTED` datetime DEFAULT NULL,
|
||
|
|
`LOCKEDBY` varchar(255) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `flw_ev_databasechangeloglock` */
|
||
|
|
|
||
|
|
insert into `flw_ev_databasechangeloglock`(`ID`,`LOCKED`,`LOCKGRANTED`,`LOCKEDBY`) values (1,'\0',NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `flw_event_definition` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `flw_event_definition`;
|
||
|
|
|
||
|
|
CREATE TABLE `flw_event_definition` (
|
||
|
|
`ID_` varchar(255) NOT NULL,
|
||
|
|
`NAME_` varchar(255) DEFAULT NULL,
|
||
|
|
`VERSION_` int DEFAULT NULL,
|
||
|
|
`KEY_` varchar(255) DEFAULT NULL,
|
||
|
|
`CATEGORY_` varchar(255) DEFAULT NULL,
|
||
|
|
`DEPLOYMENT_ID_` varchar(255) DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) DEFAULT NULL,
|
||
|
|
`RESOURCE_NAME_` varchar(255) DEFAULT NULL,
|
||
|
|
`DESCRIPTION_` varchar(255) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
UNIQUE KEY `ACT_IDX_EVENT_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `flw_event_definition` */
|
||
|
|
|
||
|
|
/*Table structure for table `flw_event_deployment` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `flw_event_deployment`;
|
||
|
|
|
||
|
|
CREATE TABLE `flw_event_deployment` (
|
||
|
|
`ID_` varchar(255) NOT NULL,
|
||
|
|
`NAME_` varchar(255) DEFAULT NULL,
|
||
|
|
`CATEGORY_` varchar(255) DEFAULT NULL,
|
||
|
|
`DEPLOY_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) DEFAULT NULL,
|
||
|
|
`PARENT_DEPLOYMENT_ID_` varchar(255) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `flw_event_deployment` */
|
||
|
|
|
||
|
|
/*Table structure for table `flw_event_resource` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `flw_event_resource`;
|
||
|
|
|
||
|
|
CREATE TABLE `flw_event_resource` (
|
||
|
|
`ID_` varchar(255) NOT NULL,
|
||
|
|
`NAME_` varchar(255) DEFAULT NULL,
|
||
|
|
`DEPLOYMENT_ID_` varchar(255) DEFAULT NULL,
|
||
|
|
`RESOURCE_BYTES_` longblob,
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
/*Data for the table `flw_event_resource` */
|
||
|
|
|
||
|
|
/*Table structure for table `flw_ru_batch` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `flw_ru_batch`;
|
||
|
|
|
||
|
|
CREATE TABLE `flw_ru_batch` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`SEARCH_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SEARCH_KEY2_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` datetime(3) NOT NULL,
|
||
|
|
`COMPLETE_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`STATUS_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`BATCH_DOC_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `flw_ru_batch` */
|
||
|
|
|
||
|
|
/*Table structure for table `flw_ru_batch_part` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `flw_ru_batch_part`;
|
||
|
|
|
||
|
|
CREATE TABLE `flw_ru_batch_part` (
|
||
|
|
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`REV_` int DEFAULT NULL,
|
||
|
|
`BATCH_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
||
|
|
`SCOPE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SUB_SCOPE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SCOPE_TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SEARCH_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`SEARCH_KEY2_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`CREATE_TIME_` datetime(3) NOT NULL,
|
||
|
|
`COMPLETE_TIME_` datetime(3) DEFAULT NULL,
|
||
|
|
`STATUS_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`RESULT_DOC_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
|
||
|
|
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
||
|
|
PRIMARY KEY (`ID_`),
|
||
|
|
KEY `FLW_IDX_BATCH_PART` (`BATCH_ID_`),
|
||
|
|
CONSTRAINT `FLW_FK_BATCH_PART_PARENT` FOREIGN KEY (`BATCH_ID_`) REFERENCES `flw_ru_batch` (`ID_`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
/*Data for the table `flw_ru_batch_part` */
|
||
|
|
|
||
|
|
/*Table structure for table `sys_deploy_form` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_deploy_form`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_deploy_form` (
|
||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
|
|
`form_id` bigint DEFAULT NULL COMMENT '表单主键',
|
||
|
|
`deploy_id` varchar(50) DEFAULT NULL COMMENT '流程实例主键',
|
||
|
|
PRIMARY KEY (`id`) USING BTREE
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='流程实例关联表单';
|
||
|
|
|
||
|
|
/*Data for the table `sys_deploy_form` */
|
||
|
|
|
||
|
|
insert into `sys_deploy_form`(`id`,`form_id`,`deploy_id`) values (8,10,'1'),(12,11,'35018'),(13,13,'40020'),(14,14,'55003'),(15,14,'55036');
|
||
|
|
|
||
|
|
/*Table structure for table `sys_form` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_form`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_form` (
|
||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '表单主键',
|
||
|
|
`form_name` varchar(50) DEFAULT NULL COMMENT '表单名称',
|
||
|
|
`form_content` longtext COMMENT '表单内容',
|
||
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
|
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
|
|
`create_by` bigint DEFAULT NULL COMMENT '创建人员',
|
||
|
|
`update_by` bigint DEFAULT NULL COMMENT '更新人员',
|
||
|
|
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
|
|
`formId` varchar(20) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`) USING BTREE
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='流程表单';
|
||
|
|
|
||
|
|
/*Data for the table `sys_form` */
|
||
|
|
|
||
|
|
insert into `sys_form`(`id`,`form_name`,`form_content`,`create_time`,`update_time`,`create_by`,`update_by`,`remark`,`formId`) values (10,'zd','{\"fields\":[{\"__config__\":{\"label\":\"zd1\",\"labelWidth\":null,\"showLabel\":true,\"changeTag\":true,\"tag\":\"el-input\",\"tagIcon\":\"input\",\"required\":true,\"layout\":\"colFormItem\",\"span\":24,\"document\":\"https://element.eleme.cn/#/zh-CN/component/input\",\"regList\":[],\"formId\":101,\"renderKey\":\"1011634549017909\"},\"__slot__\":{\"prepend\":\"\",\"append\":\"\"},\"placeholder\":\"请输入zd1\",\"style\":{\"width\":\"100%\"},\"clearable\":true,\"prefix-icon\":\"\",\"suffix-icon\":\"\",\"maxlength\":null,\"show-word-limit\":false,\"readonly\":false,\"disabled\":false,\"__vModel__\":\"zd1\"},{\"__config__\":{\"label\":\"zd2\",\"labelWidth\":null,\"showLabel\":true,\"changeTag\":true,\"tag\":\"el-input\",\"tagIcon\":\"input\",\"required\":true,\"layout\":\"colFormItem\",\"span\":24,\"document\":\"https://element.eleme.cn/#/zh-CN/component/input\",\"regList\":[],\"formId\":102,\"renderKey\":\"1021634549020320\"},\"__slot__\":{\"prepend\":\"\",\"append\":\"\"},\"placeholder\":\"请输入zd2\",\"style\":{\"width\":\"100%\"},\"clearable\":true,\"prefix-icon\":\"\",\"suffix-icon\":\"\",\"maxlength\":null,\"show-word-limit\":false,\"readonly\":false,\"disabled\":false,\"__vModel__\":\"zd2\"}],\"formRef\":\"elForm\",\"formModel\":\"formData\",\"size\":\"medium\",\"labelPosition\":\"right\",\"labelWidth\":100,\"formRules\":\"rules\",\"gutter\":15,\"disabled\":false,\"span\":24,\"formBtns\":true}',NULL,NULL,NULL,NULL,NULL,NULL),(11,'zd1','{\"fields\":[{\"__config__\":{\"label\":\"initiator\",\"labelWidth\":null,\"showLabel\":true,\"changeTag\":true,\"tag\":\"el-input\",\"tagIcon\":\"input\",\"required\":true,\"layout\":\"colFormItem\",\"span\":24,\"document\":\"https://element.eleme.cn/#/zh-CN/component/input\",\"regList\":[],\"formId\":101,\"renderKey\":\"1011634629696465\"},\"__slot__\":{\"prepend\":\"\",\"append\":\"\"},\"placeholder\":\"请输入initiator\",\"style\":{\"width\":\"100%\"},\"clearable\":true,\"prefix-icon\":\"\",\"suffix-icon\":\"\",\"maxlength\":null,\"show-word-limit\":false,\"readonly\":false,\"disabled\":false,\"__vModel__\":\"initiator\"},{\"__config__\":{\"label\":\"zd\",\"labelWidth\":null,\"showLabel\":true,\"changeTag\":true,\"tag\":\"el-input\",\"tagIcon\":\"input\",\"required\":true,\"layout\":\"colFormItem\",\"span\":24,\"document\":\"https://element.eleme.cn/#/zh-CN/component/input\",\"regList\":[],\"formId\":102,\"renderKey\":\"1021634629706229\"},\"__slot__\":{\"prepend\":\"\",\"append\":\"\"},\"placeholder\":\"请输入zd\",\"style\":{\"width\":\"100%\"},\"clearable\":true,\"prefix-icon\":\"\",\"suffix-icon\":\"\",\"maxlength\":null,\"show-word-limit\":false,\"readonly\":false,\"disabled\":false,\"__vModel__\":\"zd\"}],\"formRef\":\"elForm\",\"formModel\":\"formData\",\"size\":\"medium\",\"labelPosition\":\"right\",\"labelWidth\":100,\"formRules\":\"rules\",\"gutter\":15,\"disabled\":false,\"span\":24,\"formBtns\":true}',NULL,NULL,NULL,NULL,NULL,NULL),(13,'zd2','{\"fields\":[{\"__config__\":{\"label\":\"days\",\"labelWidth\":null,\"showLabel\":true,\"changeTag\":true,\"tag\":\"el-input\",\"tagIcon\":\"input\",\"defaultValue\":\"djz\",\"required\":true,\"layout\":\"colFormItem\",\"span\":24,\"document\":\"https://element.eleme.cn/#/zh-CN/component/input\",\"regList\":[],\"formId\":101,\"renderKey\":\"1011634630787863\"},\"__slot__\":{\"prepend\":\"\",\"append\":\"\"},\"placeholder\":\"请输入days\",\"style\":{\"width\":\"100%\"},\"clearable\":true,\"prefix-icon\":\"\",\"suffix-icon\":\"\",\"maxlength\":null,\"show-word-limit\":false,\"readonly\":false,\"disabled\":false,\"__vModel__\":\"days\"},{\"__config__\":{\"label\":\"initiator\",\"labelWidth\":null,\"showLabel\":true,\"changeTag\":true,\"tag\":\"el-input\",\"tagIcon\":\"input\",\"required\":true,\"layout\":\"colFormItem\",\"span\":24,\"document\":\"https://element.eleme.cn/#/zh-CN/component/input\",\"regList\":[],\"formId\":104,\"renderKey\":\"1041634630793367\"},\"__slot__\":{\
|
||
|
|
|
||
|
|
/*Table structure for table `sys_organization` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_organization`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_organization` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`name` varchar(64) DEFAULT NULL COMMENT '部门/组织名称',
|
||
|
|
`psid` varchar(36) DEFAULT NULL COMMENT '父(部门/组织) sid',
|
||
|
|
`linkPhone` varchar(11) DEFAULT NULL COMMENT '联系电话',
|
||
|
|
`orgSidPath` text COMMENT '部门sid全路径',
|
||
|
|
`sort` int DEFAULT NULL COMMENT '排序',
|
||
|
|
`addrs` varchar(100) DEFAULT NULL COMMENT '地址',
|
||
|
|
`jwd` varchar(100) DEFAULT NULL COMMENT '地理位置经纬度',
|
||
|
|
`qrText` varchar(300) DEFAULT NULL COMMENT '二维码',
|
||
|
|
`limitOrgMember` int DEFAULT NULL COMMENT '限制本部门成员查看通讯录:限制开启后，本部门成员只能看到限定范围内的通讯录不能看到所有通讯录，仅可见自己',
|
||
|
|
`orgCode` varchar(64) DEFAULT NULL COMMENT '部门编码',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `sid_index` (`sid`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='组织机构表';
|
||
|
|
|
||
|
|
/*Data for the table `sys_organization` */
|
||
|
|
|
||
|
|
insert into `sys_organization`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`name`,`psid`,`linkPhone`,`orgSidPath`,`sort`,`addrs`,`jwd`,`qrText`,`limitOrgMember`,`orgCode`) values (1,'fd6435f2-0005-11ec-a033-48452053aa33',0,'2021-08-18 17:23:44','2021-08-18 17:23:42',1,1,NULL,NULL,NULL,NULL,'安瑞集团','0',NULL,'fd6435f2-0005-11ec-a033-48452053aa33',NULL,NULL,NULL,NULL,NULL,NULL),(2,'fd6435f2-0005-11ec-a033-48452053aa34',0,'2021-08-18 17:52:16','2021-08-18 17:52:14',1,1,NULL,NULL,NULL,NULL,'部门1','fd6435f2-0005-11ec-a033-48452053aa33',NULL,'fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa34',NULL,NULL,NULL,NULL,NULL,NULL),(3,'fd6435f2-0005-11ec-a033-48452053aa35',0,'2021-08-25 17:02:44','2021-08-25 17:02:45',1,1,NULL,NULL,NULL,NULL,'部门2','fd6435f2-0005-11ec-a033-48452053aa33',NULL,'fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35',NULL,NULL,NULL,NULL,NULL,NULL),(4,'fd6435f2-0005-11ec-a033-48452053aa36',0,'2021-08-25 17:03:02','2021-08-25 17:03:04',1,1,NULL,NULL,NULL,NULL,'部门1-1','fd6435f2-0005-11ec-a033-48452053aa34',NULL,'fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa34/fd6435f2-0005-11ec-a033-48452053aa36',NULL,NULL,NULL,NULL,NULL,NULL),(5,'e7d741ed-095b-485b-8915-3cb1ceca1098',2,'2021-08-25 17:42:27','2021-08-25 17:44:47',1,1,0,NULL,NULL,NULL,'部门2-1','fd6435f2-0005-11ec-a033-48452053aa35','','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098',0,'','','',0,''),(6,'602d34e6-abb1-42a7-b01e-9829d074d5a6',0,'2021-08-26 11:24:17','2021-08-26 11:24:17',1,1,0,NULL,NULL,NULL,'部门2-6','fd6435f2-0005-11ec-a033-48452053aa35','','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/602d34e6-abb1-42a7-b01e-9829d074d5a6',0,'','','',0,''),(7,'0660d8a4-446a-4a65-a3dc-dd45cb372935',0,'2021-08-26 11:31:07','2021-08-26 11:31:07',1,1,0,NULL,NULL,NULL,'部门2-1-1','e7d741ed-095b-485b-8915-3cb1ceca1098','','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098/0660d8a4-446a-4a65-a3dc-dd45cb372935',0,'','','',0,''),(8,'0ae3a9a2-caa8-4f57-900d-42eeb4a839da',0,'2021-08-26 11:32:58','2021-08-26 11:32:58',1,1,0,NULL,NULL,NULL,'部门2-1-2','e7d741ed-095b-485b-8915-3cb1ceca1098','','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098/0ae3a9a2-caa8-4f57-900d-42eeb4a839da',0,'','','',0,'');
|
||
|
|
|
||
|
|
/*Table structure for table `sys_post` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_post`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_post` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`name` varchar(64) DEFAULT NULL COMMENT '岗位名称',
|
||
|
|
`orgSid` varchar(36) DEFAULT NULL COMMENT '所属部门sid',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `sid_index` (`sid`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='岗位';
|
||
|
|
|
||
|
|
/*Data for the table `sys_post` */
|
||
|
|
|
||
|
|
insert into `sys_post`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`name`,`orgSid`) values (1,'10efe2e7-03df-11ec-bf08-48452053aa33',0,'2021-08-18 17:24:24','2021-08-18 17:24:24',1,1,NULL,NULL,NULL,NULL,'岗位1','fd6435f2-0005-11ec-a033-48452053aa33'),(2,'10f009f7-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:27','2021-08-23 14:53:27',1,1,NULL,NULL,NULL,NULL,'岗位2','fd6435f2-0005-11ec-a033-48452053aa33'),(3,'10f009f8-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:28','2021-08-23 14:53:28',1,1,NULL,NULL,NULL,NULL,'岗位3','fd6435f2-0005-11ec-a033-48452053aa33'),(4,'10f009f9-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:28','2021-08-23 14:53:28',1,1,NULL,NULL,NULL,NULL,'岗位4','fd6435f2-0005-11ec-a033-48452053aa33'),(5,'10f009fa-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:29','2021-08-23 14:53:29',1,1,NULL,NULL,NULL,NULL,'岗位5','fd6435f2-0005-11ec-a033-48452053aa33'),(6,'10f009fb-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:29','2021-08-23 14:53:29',1,1,NULL,NULL,NULL,NULL,'岗位6','fd6435f2-0005-11ec-a033-48452053aa33'),(7,'10f009fc-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:30','2021-08-23 14:53:30',1,1,NULL,NULL,NULL,NULL,'岗位7','fd6435f2-0005-11ec-a033-48452053aa33'),(8,'10f009fd-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:30','2021-08-23 14:53:30',1,1,NULL,NULL,NULL,NULL,'岗位8','fd6435f2-0005-11ec-a033-48452053aa33'),(9,'10f009fe-03df-11ec-bf08-48452053aa33',2,'2021-08-23 14:53:31','2021-08-23 15:10:01',1,1,NULL,NULL,NULL,NULL,'总经理','fd6435f2-0005-11ec-a033-48452053aa34'),(10,'10f009ff-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:31','2021-08-23 14:53:31',1,1,NULL,NULL,NULL,NULL,'岗位10','fd6435f2-0005-11ec-a033-48452053aa34'),(11,'10f03108-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:32','2021-08-23 14:53:32',1,1,NULL,NULL,NULL,NULL,'岗位11','fd6435f2-0005-11ec-a033-48452053aa34'),(12,'10f03109-03df-11ec-bf08-48452053aa33',0,'2021-08-23 14:53:34','2021-08-23 14:53:34',1,1,NULL,NULL,NULL,NULL,'岗位12','fd6435f2-0005-11ec-a033-48452053aa34'),(13,'6526f43c-b71e-42c6-a72d-7cc8c0fe3fc8',0,'2021-08-23 15:07:38','2021-08-23 15:07:38',1,1,0,NULL,NULL,NULL,'岗位名称3','fd6435f2-0005-11ec-a033-48452053aa34'),(14,'a5cfc706-56ee-4a84-abee-2144331eb42f',0,'2021-08-23 17:50:47','2021-08-23 17:50:47',1,1,0,NULL,NULL,NULL,'功能名称2222222',NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `sys_role` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_role`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_role` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`name` varchar(64) DEFAULT NULL COMMENT '角色名称',
|
||
|
|
`sort` int DEFAULT NULL COMMENT '排序',
|
||
|
|
`code` varchar(10) DEFAULT NULL COMMENT '编码',
|
||
|
|
`type` int DEFAULT NULL COMMENT '1、系统管理员、2、普通角色',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='角色';
|
||
|
|
|
||
|
|
/*Data for the table `sys_role` */
|
||
|
|
|
||
|
|
insert into `sys_role`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`name`,`sort`,`code`,`type`) values (1,'0b4d1362-b3a1-4487-9046-a5ed56bd8f13',1,'2021-08-18 15:10:45','2021-08-23 18:00:35',1,1,NULL,'角色1的备注',NULL,NULL,'角色1',1,'1',1),(2,'0b4d1362-b3a1-4487-9046-a5ed56bd8f14',0,'2021-08-18 15:11:20','2021-08-18 15:11:22',1,1,NULL,'角色2的备注',NULL,NULL,'角色2',NULL,'2',1),(3,'b1aee11f-7899-4075-8d2e-db0168574d88',0,'2021-08-23 09:39:34','2021-08-23 09:39:34',1,1,0,NULL,NULL,NULL,'角色5',0,'1',0),(4,'f0a79b5e-5338-435e-b0c6-08fc01048f55',0,'2021-08-23 09:40:36','2021-08-23 09:40:36',1,1,0,NULL,NULL,NULL,'角色3',0,'1',0);
|
||
|
|
|
||
|
|
/*Table structure for table `sys_staff_org` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_staff_org`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_staff_org` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`orgSid` varchar(64) DEFAULT NULL COMMENT '部门sid',
|
||
|
|
`orgName` varchar(36) DEFAULT NULL COMMENT '部门名称',
|
||
|
|
`staffSid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '人员sid',
|
||
|
|
`orgSidPath` text COMMENT '部门路径',
|
||
|
|
`orgNamePath` varchar(300) DEFAULT NULL COMMENT '部门名称路径',
|
||
|
|
`manageType` varchar(100) DEFAULT NULL COMMENT '管理类型：1、主管。2、分管。3、员工',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `staffsid_index` (`staffSid`),
|
||
|
|
KEY `orgSid_index` (`orgSid`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='员工部门关联表';
|
||
|
|
|
||
|
|
/*Data for the table `sys_staff_org` */
|
||
|
|
|
||
|
|
insert into `sys_staff_org`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`orgSid`,`orgName`,`staffSid`,`orgSidPath`,`orgNamePath`,`manageType`) values (1,'eadbfb5b-0005-11ec-a033-48452053aa33',0,'2021-08-18 17:22:34','2021-08-18 17:22:34',1,1,NULL,NULL,NULL,NULL,'fd6435f2-0005-11ec-a033-48452053aa33','部门1','b1044786-e692-4c8b-bd7e-c9b2022d8a55',NULL,NULL,'1'),(2,'eadbfb5b-0005-11ec-a033-48452053aa34',0,'2021-08-18 17:48:11','2021-08-18 17:48:13',1,1,NULL,NULL,NULL,NULL,'fd6435f2-0005-11ec-a033-48452053aa34','部门2','b1044786-e692-4c8b-bd7e-c9b2022d8a55',NULL,NULL,'2'),(3,'3a942937-5b4c-406f-9ace-7045e26bdf3c',0,'2021-08-26 11:24:17','2021-08-26 11:24:17',1,1,0,NULL,NULL,NULL,'602d34e6-abb1-42a7-b01e-9829d074d5a6','部门2-6','5360428a-c0a3-40a0-b2b3-898f48ff196d','null/602d34e6-abb1-42a7-b01e-9829d074d5a6','部门2/部门2-6','1'),(4,'0dc11d7a-926c-4370-885c-2c02f90181f8',0,'2021-08-26 11:24:17','2021-08-26 11:24:17',1,1,0,NULL,NULL,NULL,'602d34e6-abb1-42a7-b01e-9829d074d5a6','部门2-6','e04e726d-87bc-4ffe-8fcb-43ead2f7ab7e','null/602d34e6-abb1-42a7-b01e-9829d074d5a6','部门2/部门2-6','1'),(5,'4002967b-ae23-4393-888b-d19eb045cae0',0,'2021-08-26 11:24:17','2021-08-26 11:24:17',1,1,0,NULL,NULL,NULL,'602d34e6-abb1-42a7-b01e-9829d074d5a6','部门2-6','51d35470-3a77-402a-aac3-78d4470a7688','null/602d34e6-abb1-42a7-b01e-9829d074d5a6','部门2/部门2-6','2'),(6,'a2fee252-5a0a-4d8f-976b-e557221d276d',0,'2021-08-26 11:31:07','2021-08-26 11:31:07',1,1,0,NULL,NULL,NULL,'0660d8a4-446a-4a65-a3dc-dd45cb372935','部门2-1-1','5360428a-c0a3-40a0-b2b3-898f48ff196d','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098/0660d8a4-446a-4a65-a3dc-dd45cb372935','部门2-1/部门2-1-1','1'),(7,'17393af8-3ea3-48f0-9cd5-b34e23acd7a6',0,'2021-08-26 11:31:07','2021-08-26 11:31:07',1,1,0,NULL,NULL,NULL,'0660d8a4-446a-4a65-a3dc-dd45cb372935','部门2-1-1','e04e726d-87bc-4ffe-8fcb-43ead2f7ab7e','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098/0660d8a4-446a-4a65-a3dc-dd45cb372935','部门2-1/部门2-1-1','1'),(8,'d190e02b-28c7-4464-8ee2-c9af5731bef9',0,'2021-08-26 11:31:07','2021-08-26 11:31:07',1,1,0,NULL,NULL,NULL,'0660d8a4-446a-4a65-a3dc-dd45cb372935','部门2-1-1','51d35470-3a77-402a-aac3-78d4470a7688','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098/0660d8a4-446a-4a65-a3dc-dd45cb372935','部门2-1/部门2-1-1','2'),(9,'0e0edb83-1ce9-4aa0-a460-a3ff72dde6e3',0,'2021-08-26 11:33:00','2021-08-26 11:33:00',1,1,0,NULL,NULL,NULL,'0ae3a9a2-caa8-4f57-900d-42eeb4a839da','部门2-1-2','5360428a-c0a3-40a0-b2b3-898f48ff196d','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098/0ae3a9a2-caa8-4f57-900d-42eeb4a839da','部门2-1/部门2-1-2','1'),(10,'ea8c5b05-5e05-4d96-8b0f-2269906a0707',0,'2021-08-26 11:33:00','2021-08-26 11:33:00',1,1,0,NULL,NULL,NULL,'0ae3a9a2-caa8-4f57-900d-42eeb4a839da','部门2-1-2','e04e726d-87bc-4ffe-8fcb-43ead2f7ab7e','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098/0ae3a9a2-caa8-4f57-900d-42eeb4a839da','部门2-1/部门2-1-2','1'),(11,'d1705492-9e67-4e8b-99c5-e1ce3cd20220',0,'2021-08-26 11:33:00','2021-08-26 11:33:00',1,1,0,NULL,NULL,NULL,'0ae3a9a2-caa8-4f57-900d-42eeb4a839da','部门2-1-2','51d35470-3a77-402a-aac3-78d4470a7688','fd6435f2-0005-11ec-a033-48452053aa33/fd6435f2-0005-11ec-a033-48452053aa35/e7d741ed-095b-485b-8915-3cb1ceca1098/0ae3a9a2-caa8-4f57-900d-42eeb4a839da','部门2-1/部门2-1-2','2');
|
||
|
|
|
||
|
|
/*Table structure for table `sys_staff_post` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_staff_post`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_staff_post` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`staffSid` varchar(36) DEFAULT NULL COMMENT '员工sid',
|
||
|
|
`orgSid` varchar(36) DEFAULT NULL COMMENT '所属部门sid',
|
||
|
|
`postSid` varchar(36) DEFAULT NULL COMMENT '就任岗位',
|
||
|
|
`startDate` datetime DEFAULT NULL COMMENT '任岗开始日期',
|
||
|
|
`isDepetHead` int DEFAULT NULL COMMENT '是否主任岗：1是、0否',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `postsid_index` (`postSid`),
|
||
|
|
KEY `staffSid_index` (`staffSid`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='员工岗位关联表';
|
||
|
|
|
||
|
|
/*Data for the table `sys_staff_post` */
|
||
|
|
|
||
|
|
insert into `sys_staff_post`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`staffSid`,`orgSid`,`postSid`,`startDate`,`isDepetHead`) values (1,'e19d55fe-0006-11ec-a033-48452053aa33',0,'2021-08-18 17:22:42','2021-08-18 17:22:42',1,1,NULL,NULL,NULL,NULL,'b1044786-e692-4c8b-bd7e-c9b2022d8a55','fd6435f2-0005-11ec-a033-48452053aa33','da2db16e-0006-11ec-a033-48452053aa33',NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `sys_staffinfo` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_staffinfo`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_staffinfo` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`name` varchar(64) DEFAULT NULL COMMENT '姓名',
|
||
|
|
`gender` int DEFAULT NULL COMMENT '性别:1男，2女',
|
||
|
|
`idNo` varchar(64) DEFAULT NULL COMMENT '身份证号',
|
||
|
|
`idAddrs` varchar(64) DEFAULT NULL COMMENT '身份证地址',
|
||
|
|
`idTerm` datetime DEFAULT NULL COMMENT '证件有效期',
|
||
|
|
`birthday` datetime DEFAULT NULL COMMENT '生日',
|
||
|
|
`national` varchar(64) DEFAULT NULL COMMENT '民族',
|
||
|
|
`nativePlace` varchar(64) DEFAULT NULL COMMENT '籍贯',
|
||
|
|
`mobile` varchar(64) DEFAULT NULL COMMENT '手机号',
|
||
|
|
`email` varchar(64) DEFAULT NULL COMMENT '邮箱',
|
||
|
|
`jobNumber` varchar(64) DEFAULT NULL COMMENT '工号',
|
||
|
|
`position` varchar(64) DEFAULT NULL COMMENT '职位',
|
||
|
|
`joinCompnyDate` datetime DEFAULT NULL COMMENT '入职时间',
|
||
|
|
`personType` varchar(64) DEFAULT NULL COMMENT '员工类型（无类型、全职、兼职、实习、劳务派遣、退休返聘、劳务外包）',
|
||
|
|
`probPeriod` varchar(64) DEFAULT NULL COMMENT '试用期（无试用期、1个月、2个月、3个月、其他）',
|
||
|
|
`confirmationDate` datetime DEFAULT NULL COMMENT '实际转正日期',
|
||
|
|
`plannedConfirmDate` datetime DEFAULT NULL COMMENT '计划转正日期',
|
||
|
|
`postRank` varchar(64) DEFAULT NULL COMMENT '岗位职级',
|
||
|
|
`maritalStatus` varchar(64) DEFAULT NULL COMMENT '婚姻状况',
|
||
|
|
`jobDateStart` datetime DEFAULT NULL COMMENT '首次参加工作时间',
|
||
|
|
`residenceType` varchar(64) DEFAULT NULL COMMENT '户籍类型',
|
||
|
|
`address` varchar(64) DEFAULT NULL COMMENT '住址',
|
||
|
|
`poliCode` varchar(64) DEFAULT NULL COMMENT '政治面貌',
|
||
|
|
`socialAccount` varchar(64) DEFAULT NULL COMMENT '个人社保账号',
|
||
|
|
`fundAccount` varchar(64) DEFAULT NULL COMMENT '个人公积金账号',
|
||
|
|
`bankCardNo` varchar(64) DEFAULT NULL COMMENT '银行卡号',
|
||
|
|
`openBank` varchar(64) DEFAULT NULL COMMENT '开户行',
|
||
|
|
`idCardA` varchar(64) DEFAULT NULL COMMENT '身份证(人像面)',
|
||
|
|
`idCardB` varchar(64) DEFAULT NULL COMMENT '身份证(国徽面)',
|
||
|
|
`diploma` varchar(64) DEFAULT NULL COMMENT '学历证书',
|
||
|
|
`degreeCertificate` varchar(64) DEFAULT NULL COMMENT '学位证书',
|
||
|
|
`leaveCertificate` varchar(64) DEFAULT NULL COMMENT '前公司离职证明',
|
||
|
|
`photo` varchar(64) DEFAULT NULL COMMENT '员工照片',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `sid_index` (`sid`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='人员基础信息表';
|
||
|
|
|
||
|
|
/*Data for the table `sys_staffinfo` */
|
||
|
|
|
||
|
|
insert into `sys_staffinfo`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`name`,`gender`,`idNo`,`idAddrs`,`idTerm`,`birthday`,`national`,`nativePlace`,`mobile`,`email`,`jobNumber`,`position`,`joinCompnyDate`,`personType`,`probPeriod`,`confirmationDate`,`plannedConfirmDate`,`postRank`,`maritalStatus`,`jobDateStart`,`residenceType`,`address`,`poliCode`,`socialAccount`,`fundAccount`,`bankCardNo`,`openBank`,`idCardA`,`idCardB`,`diploma`,`degreeCertificate`,`leaveCertificate`,`photo`) values (1,'fda538ed-39ca-4f43-8dc2-e6674d22ffc8',0,'2021-08-17 21:47:38','2021-08-17 21:47:38',1,1,0,NULL,NULL,NULL,'员工姓名7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'6067dba8-2560-416e-ba79-135c807526b6',0,'2021-08-17 21:47:59','2021-08-17 21:47:59',1,1,0,NULL,NULL,NULL,'员工姓名6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'94a15f1a-a865-46d1-952a-d124fc608dcf',0,'2021-08-17 21:49:22','2021-08-17 21:49:22',1,1,0,NULL,NULL,NULL,'员工姓名5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'d8d98a0f-10db-4232-9e6f-e60f56f16756',0,'2021-08-18 10:48:02','2021-08-18 10:48:02',1,1,0,NULL,NULL,NULL,'员工姓名4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'2b811df0-d76b-4b61-a7ac-fbd56f0f8934',0,'2021-08-18 11:05:48','2021-08-18 11:05:48',1,1,0,NULL,NULL,NULL,'员工姓名3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'b1044786-e692-4c8b-bd7e-c9b2022d8a55',0,'2021-08-18 11:13:51','2021-08-18 11:13:51',1,1,0,NULL,NULL,NULL,'员工姓名2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'2652b8ca-bddd-463e-b5d7-133287ed4df8',0,'2021-08-18 16:48:54','2021-08-18 16:48:54',1,1,0,NULL,NULL,NULL,'员工姓名1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'51d35470-3a77-402a-aac3-78d4470a7688',0,'2021-08-19 21:03:44','2021-08-19 21:03:44',1,1,0,NULL,NULL,NULL,'员工姓名8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'0ee2e13d-e494-48a5-8dce-a5795697b14e',0,'2021-08-19 21:05:47','2021-08-19 21:05:47',1,1,0,NULL,NULL,NULL,'员工姓名9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'5360428a-c0a3-40a0-b2b3-898f48ff196d',0,'2021-08-19 21:11:38','2021-08-19 21:11:38',1,1,0,NULL,NULL,NULL,'员工姓名10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'e04e726d-87bc-4ffe-8fcb-43ead2f7ab7e',0,'2021-08-23 16:24:08','2021-08-23 16:24:08',1,1,0,NULL,NULL,NULL,'员工姓名11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
|
||
|
|
|
||
|
|
/*Table structure for table `sys_user` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_user`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_user` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`userName` varchar(64) DEFAULT NULL COMMENT '登录名，登录名不能相同',
|
||
|
|
`password` varchar(50) DEFAULT NULL COMMENT '密码（加密或签名后）',
|
||
|
|
`pwdDayslimit` varchar(11) DEFAULT NULL COMMENT '密码修改时限',
|
||
|
|
`pwdModifyTime` datetime DEFAULT NULL COMMENT '最后一次密码修改时间',
|
||
|
|
`onlineState` int DEFAULT NULL COMMENT '在线状态（0为离线、1为在线）',
|
||
|
|
`token` varchar(100) DEFAULT NULL COMMENT '用户登录时随机生成身份验证字符串',
|
||
|
|
`isAdmin` varchar(1) DEFAULT NULL COMMENT '是否是管理员：1管理员，2一般用户，0是超级管理员,3尚无单位人员',
|
||
|
|
`appId` varchar(36) DEFAULT NULL COMMENT '手机登录唯一标识，手机与用户绑定字段',
|
||
|
|
`staffSid` varchar(36) DEFAULT NULL COMMENT '关联的人员sid',
|
||
|
|
`mobile` varchar(11) DEFAULT NULL COMMENT '手机号',
|
||
|
|
`userType` int DEFAULT NULL COMMENT '用户类型:1员工、2客户、3供应商',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `staffsid_index` (`staffSid`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='用户表';
|
||
|
|
|
||
|
|
/*Data for the table `sys_user` */
|
||
|
|
|
||
|
|
insert into `sys_user`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`userName`,`password`,`pwdDayslimit`,`pwdModifyTime`,`onlineState`,`token`,`isAdmin`,`appId`,`staffSid`,`mobile`,`userType`) values (6,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59',1,'2021-08-18 11:13:51','2021-08-20 17:00:25',1,1,0,NULL,NULL,NULL,'15097329653','435d6b71ca083adda32844da3a452bd9',NULL,NULL,NULL,NULL,'1',NULL,'b1044786-e692-4c8b-bd7e-c9b2022d8a55','15097329653',2),(8,'0b4d1362-b3a1-4487-9046-a5ed56bd8f60',0,'2021-08-18 15:01:01','2021-08-18 15:01:05',1,1,0,NULL,NULL,NULL,'15097329654','435d6b71ca083adda32844da3a452bd9',NULL,NULL,NULL,NULL,'1',NULL,'b1044786-e692-4c8b-bd7e-c9b2022d8a54','15097329654',3),(9,'0b4d1362-b3a1-4487-9046-a5ed56bd8f61',0,'2021-08-18 15:01:03','2021-08-18 15:01:07',1,1,0,NULL,NULL,NULL,'15097329655','435d6b71ca083adda32844da3a452bd9',NULL,NULL,NULL,NULL,'1',NULL,'b1044786-e692-4c8b-bd7e-c9b2022d8a56','15097329655',2),(10,'364300f3-5eeb-4d8c-9b35-239c8612c6cd',0,'2021-08-18 16:48:54','2021-08-18 16:48:54',1,1,0,NULL,NULL,NULL,'15097329658','3c6ababb946124cf15a392e752f682d6',NULL,NULL,NULL,NULL,'1',NULL,'2652b8ca-bddd-463e-b5d7-133287ed4df8','15097329658',2),(11,'ecaa87c8-e094-42a6-90a9-913f78b9eca0',0,'2021-08-19 21:03:44','2021-08-19 21:03:44',1,1,0,NULL,NULL,NULL,'15263666565','389a6d23d96f41f6a03e27097d533d1f',NULL,NULL,NULL,NULL,'1',NULL,'51d35470-3a77-402a-aac3-78d4470a7688','15263666565',1),(14,'ded9f997-caff-43a4-a002-249e3d0e87c2',0,'2021-08-23 16:24:08','2021-08-23 16:24:08',1,1,0,NULL,NULL,NULL,'12356666666','c55d0d5c2c87a87f1ba9695723280ef8',NULL,NULL,NULL,NULL,'1',NULL,'e04e726d-87bc-4ffe-8fcb-43ead2f7ab7e','12356666666',1);
|
||
|
|
|
||
|
|
/*Table structure for table `sys_user_role` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_user_role`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_user_role` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`userSid` varchar(36) DEFAULT NULL COMMENT '用户sid',
|
||
|
|
`roleSid` varchar(36) DEFAULT NULL COMMENT '角色sid',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='用户与角色关联表';
|
||
|
|
|
||
|
|
/*Data for the table `sys_user_role` */
|
||
|
|
|
||
|
|
insert into `sys_user_role`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`userSid`,`roleSid`) values (2,'0b4d1362-b3a1-4487-9046-a5ed56bd8f22',0,'2021-08-18 14:10:05','2021-08-18 14:10:05',1,1,NULL,'2',NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f57','0b4d1362-b3a1-4487-9046-a5ed56bd8f14'),(11,'75f003f2-e966-4e77-baad-6eb26e51156b',0,'2021-08-23 15:56:10','2021-08-23 15:56:10',1,1,0,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f90','1'),(12,'01059045-03a9-40b7-8ad1-cad5e0a49aad',0,'2021-08-23 15:56:10','2021-08-23 15:56:10',1,1,0,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f90','2'),(13,'fa46e684-49d8-4e22-9fb3-83027a2eb763',0,'2021-08-23 15:56:10','2021-08-23 15:56:10',1,1,0,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f90','3'),(14,'0238c371-ea7d-4586-8f8f-cd2d075bd2d4',0,'2021-08-23 15:56:10','2021-08-23 15:56:10',1,1,0,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f90','4'),(15,'cf6f74ca-6d2c-420d-8a6e-82e869c20a59',0,'2021-08-23 15:56:10','2021-08-23 15:56:10',1,1,0,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f90','5'),(16,'95e8c335-8b3a-45c7-b2b0-a6f9a141866b',0,'2021-08-23 15:56:10','2021-08-23 15:56:10',1,1,0,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f90','6'),(32,'837b9615-8729-4309-91fc-03da7ed39102',0,'2021-08-23 16:22:03','2021-08-23 16:22:03',1,1,0,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f59','0b4d1362-b3a1-4487-9046-a5ed56bd8f13'),(33,'83bb0366-c84f-4033-a423-be139e123e27',0,'2021-08-23 16:22:11','2021-08-23 16:22:11',1,1,0,NULL,NULL,NULL,'0b4d1362-b3a1-4487-9046-a5ed56bd8f60','0b4d1362-b3a1-4487-9046-a5ed56bd8f14');
|
||
|
|
|
||
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
||
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
||
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
||
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|