flowable 6.6表结构 执行sql

最新推荐文章于 2024-05-28 09:34:12 发布
最新推荐文章于 2024-05-28 09:34:12 发布
阅读量602 收藏 10
点赞数 10
文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_41609778/article/details/135642000
版权

事件起因：网上存在flowable的表结构说明，但是领导想在数据库直接看，没办法，一点一点粘贴出来执行sql。

以下是执行sql，直接执行就行。

ALTER TABLE `act_ge_bytearray` 
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本	Activiti 有可能会被频繁修改数据库表，加入字段，用来表示该数据被操作的次数' AFTER `ID_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '资源名称	' AFTER `REV_`,
MODIFY COLUMN `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '部署序号，一次部署可以部署多个资源，该字段与部署表 ACT_RE_DEPLOYMENT 的主键关联\r\n部署序号	部署序号，一次部署可以部署多个资源，该字段与部署表 ACT_RE_DEPLOYMENT 的主键关联' AFTER `NAME_`,
MODIFY COLUMN `BYTES_` longblob NULL COMMENT '资源内容	' AFTER `DEPLOYMENT_ID_`,
MODIFY COLUMN `GENERATED_` tinyint NULL DEFAULT NULL COMMENT '是否是右 activiti 自动产生的资源	0 表示 false，1 表示 true' AFTER `BYTES_`;

ALTER TABLE `act_ge_property` 
MODIFY COLUMN `NAME_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '属性名称	' FIRST,
MODIFY COLUMN `VALUE_` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '属性值	' AFTER `NAME_`,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本号	' AFTER `VALUE_`;

ALTER TABLE `act_re_deployment` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '部署序号	' FIRST,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '部署名称	' AFTER `ID_`,
MODIFY COLUMN `CATEGORY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '类别	流程定义的 Namespace 就是类别' AFTER `NAME_`,
MODIFY COLUMN `KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义 ID	' AFTER `CATEGORY_`,
MODIFY COLUMN `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '部署时间	' AFTER `TENANT_ID_`,
MODIFY COLUMN `ENGINE_VERSION_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '引擎版本	' AFTER `PARENT_DEPLOYMENT_ID_`;

ALTER TABLE `act_re_procdef` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键	' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本号	' AFTER `ID_`,
MODIFY COLUMN `CATEGORY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义分类	读取 xml 文件中程的 targetNamespace 值\r\n' AFTER `REV_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义的名称	读取流程文件中 process 元素的 name 属性\r\n' AFTER `CATEGORY_`,
MODIFY COLUMN `KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '流程定义 key	读取流程文件中 process 元素的 id 属性\r\n' AFTER `NAME_`,
MODIFY COLUMN `VERSION_` int NOT NULL COMMENT '版本	' AFTER `KEY_`,
MODIFY COLUMN `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '部署 ID	流程定义对应的部署数据 ID\r\n' AFTER `VERSION_`,
MODIFY COLUMN `RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'bpmn 文件名称	一般为流程文件的相对路径\r\n' AFTER `DEPLOYMENT_ID_`,
MODIFY COLUMN `DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义对应的流程图资源名称	' AFTER `RESOURCE_NAME_`,
MODIFY COLUMN `DESCRIPTION_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '说明	' AFTER `DGRM_RESOURCE_NAME_`,
MODIFY COLUMN `HAS_START_FORM_KEY_` tinyint NULL DEFAULT NULL COMMENT '是否存在开始节点 formKey	start 节点是否存在 formKey 0 否 1 是' AFTER `DESCRIPTION_`,
MODIFY COLUMN `SUSPENSION_STATE_` int NULL DEFAULT NULL COMMENT '流程定义状态	1 激活、2 中止\r\n' AFTER `HAS_GRAPHICAL_NOTATION_`;


ALTER TABLE `act_id_user` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键	' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本	' AFTER `ID_`,
MODIFY COLUMN `FIRST_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '人名' AFTER `REV_`,
MODIFY COLUMN `LAST_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '邮件	' AFTER `FIRST_`,
MODIFY COLUMN `EMAIL_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '邮件	' AFTER `DISPLAY_NAME_`,
MODIFY COLUMN `PWD_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户密码	' AFTER `EMAIL_`,
MODIFY COLUMN `PICTURE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '图片 ID	' AFTER `PWD_`;

ALTER TABLE `act_id_info` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '	主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `USER_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	对应用户表主键' AFTER `REV_`,
MODIFY COLUMN `TYPE_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '信息类型	当前可以设置用户帐号 (account)、用户信息 (userinfo) 和 NULL 三种值' AFTER `USER_ID_`,
MODIFY COLUMN `KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '数据的键	可以根据该键查找用户信息的值' AFTER `TYPE_`,
MODIFY COLUMN `VALUE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '数据的值	' AFTER `KEY_`,
MODIFY COLUMN `PASSWORD_` longblob NULL COMMENT '用户密码	' AFTER `VALUE_`,
MODIFY COLUMN `PARENT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '父信息 ID	' AFTER `PASSWORD_`;

ALTER TABLE `act_id_group` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户组名称	' AFTER `REV_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户组类型	' AFTER `NAME_`;

ALTER TABLE `act_id_membership` 
MODIFY COLUMN `USER_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '用户 ID' FIRST,
MODIFY COLUMN `GROUP_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '用户组 ID' AFTER `USER_ID_`;

ALTER TABLE `act_ru_execution` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `REV_`,
MODIFY COLUMN `BUSINESS_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '业务主键 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `PARENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	父执行流的 ID' AFTER `BUSINESS_KEY_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义的数据 ID' AFTER `PARENT_ID_`,
MODIFY COLUMN `ACT_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '节点实例 ID' AFTER `ROOT_PROC_INST_ID_`,
MODIFY COLUMN `IS_ACTIVE_` tinyint NULL DEFAULT NULL COMMENT '是否存活' AFTER `ACT_ID_`,
MODIFY COLUMN `IS_CONCURRENT_` tinyint NULL DEFAULT NULL COMMENT '执行流是否正在并行	' AFTER `IS_ACTIVE_`,
MODIFY COLUMN `SUSPENSION_STATE_` int NULL DEFAULT NULL COMMENT '流程终端状态' AFTER `IS_MI_ROOT_`,
MODIFY COLUMN `START_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '开始时间	' AFTER `START_ACT_ID_`;

ALTER TABLE `act_ru_task` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务所在的执行流 ID' AFTER `REV_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	流程定义数据 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	任务名称' AFTER `PROPAGATED_STAGE_INST_ID_`,
MODIFY COLUMN `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	父任务 ID' AFTER `NAME_`,
MODIFY COLUMN `DESCRIPTION_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	说明' AFTER `PARENT_TASK_ID_`,
MODIFY COLUMN `TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务定义的 ID 值' AFTER `DESCRIPTION_`,
MODIFY COLUMN `OWNER_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	任务拥有人' AFTER `TASK_DEF_KEY_`,
MODIFY COLUMN `ASSIGNEE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '被指派执行该任务的人' AFTER `OWNER_`,
MODIFY COLUMN `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '	创建时间' AFTER `PRIORITY_`,
MODIFY COLUMN `DUE_DATE_` datetime(3) NULL DEFAULT NULL COMMENT '	耗时' AFTER `CREATE_TIME_`,
MODIFY COLUMN `SUSPENSION_STATE_` int NULL DEFAULT NULL COMMENT '是否挂起	1 代表激活 2 代表挂起' AFTER `CATEGORY_`;

ALTER TABLE `act_ru_variable` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '参数类型	可以是基本的类型，也可以用户自行扩展' AFTER `REV_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '参数名称' AFTER `TYPE_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '参数执行 ID' AFTER `NAME_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '资源 ID' AFTER `SCOPE_TYPE_`,
MODIFY COLUMN `DOUBLE_` double NULL DEFAULT NULL COMMENT '参数为 double，则保存在该字段中' AFTER `BYTEARRAY_ID_`,
MODIFY COLUMN `LONG_` bigint NULL DEFAULT NULL COMMENT '参数为 long，则保存在该字段中' AFTER `DOUBLE_`,
MODIFY COLUMN `TEXT_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户保存文本类型的参数值	' AFTER `LONG_`,
MODIFY COLUMN `TEXT2_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户保存文本类型的参数值' AFTER `TEXT_`;

ALTER TABLE `act_ru_identitylink` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `GROUP_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户组 ID' AFTER `REV_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'assignee 支配人 (组)、candidate 候选人 (组)、owner 拥有人' AFTER `GROUP_ID_`,
MODIFY COLUMN `USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '用户 ID' AFTER `TYPE_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `USER_ID_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例id' AFTER `TASK_ID_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	属性 ID' AFTER `PROC_INST_ID_`;

ALTER TABLE `act_ru_job` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '	类型' AFTER `CATEGORY_`,
MODIFY COLUMN `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '锁定释放时间' AFTER `TYPE_`,
MODIFY COLUMN `LOCK_OWNER_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '挂起者' AFTER `LOCK_EXP_TIME_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例 ID' AFTER `EXCLUSIVE_`,
MODIFY COLUMN `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '流程定义 ID' AFTER `PROCESS_INSTANCE_ID_`,
MODIFY COLUMN `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常信息 ID' AFTER `RETRIES_`,
MODIFY COLUMN `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常信息' AFTER `EXCEPTION_STACK_ID_`,
MODIFY COLUMN `DUEDATE_` timestamp(3) NULL DEFAULT NULL COMMENT '	到期时间' AFTER `EXCEPTION_MSG_`,
MODIFY COLUMN `REPEAT_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '重复' AFTER `DUEDATE_`,
MODIFY COLUMN `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '处理类型' AFTER `REPEAT_`;

ALTER TABLE `act_ru_deadletter_job` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '类型' AFTER `CATEGORY_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '执行实例 ID' AFTER `EXCLUSIVE_`,
MODIFY COLUMN `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	流程实例 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	流程定义 ID' AFTER `PROCESS_INSTANCE_ID_`,
MODIFY COLUMN `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常信息 ID' AFTER `CORRELATION_ID_`,
MODIFY COLUMN `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '异常信息' AFTER `EXCEPTION_STACK_ID_`,
MODIFY COLUMN `DUEDATE_` timestamp(3) NULL DEFAULT NULL COMMENT '到期时间' AFTER `EXCEPTION_MSG_`,
MODIFY COLUMN `REPEAT_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '重复' AFTER `DUEDATE_`,
MODIFY COLUMN `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '	处理类型' AFTER `REPEAT_`;


ALTER TABLE `act_ru_suspended_job` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '类型' AFTER `CATEGORY_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '执行实例 ID' AFTER `EXCLUSIVE_`,
MODIFY COLUMN `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程定义 ID' AFTER `PROCESS_INSTANCE_ID_`,
MODIFY COLUMN `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '异常信息 ID' AFTER `RETRIES_`,
MODIFY COLUMN `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '异常信息' AFTER `EXCEPTION_STACK_ID_`,
MODIFY COLUMN `DUEDATE_` timestamp(3) NULL DEFAULT NULL COMMENT '到期时间' AFTER `EXCEPTION_MSG_`,
MODIFY COLUMN `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '重复' AFTER `DUEDATE_`,
MODIFY COLUMN `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '处理类型' AFTER `REPEAT_`,
COMMENT = '工作数据表 (暂停工作表)';

ALTER TABLE `act_ru_timer_job` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '类型' AFTER `CATEGORY_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '执行实例 ID' AFTER `EXCLUSIVE_`,
MODIFY COLUMN `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程定义 ID' AFTER `PROCESS_INSTANCE_ID_`,
MODIFY COLUMN `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '异常信息 ID' AFTER `RETRIES_`,
MODIFY COLUMN `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '异常信息' AFTER `EXCEPTION_STACK_ID_`,
MODIFY COLUMN `DUEDATE_` timestamp(3) NULL DEFAULT NULL COMMENT '到期时间' AFTER `EXCEPTION_MSG_`,
MODIFY COLUMN `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '重复' AFTER `DUEDATE_`,
MODIFY COLUMN `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '处理类型' AFTER `REPEAT_`,
COMMENT = '工作数据表 (定时工作表)';

ALTER TABLE `act_ru_event_subscr` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `EVENT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '事件类型' AFTER `REV_`,
MODIFY COLUMN `EVENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '事件名称' AFTER `EVENT_TYPE_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '指定 ID' AFTER `EVENT_NAME_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程定义 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `ACTIVITY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '具体事件 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '事件的配置属性' AFTER `ACTIVITY_ID_`,
MODIFY COLUMN `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间' AFTER `CONFIGURATION_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '属性 ID' AFTER `CREATED_`,
COMMENT = '时间描述表';

ALTER TABLE `act_hi_detail` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '类型' AFTER `ID_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `TYPE_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '执行 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '节点实例 ID' AFTER `TASK_ID_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '名称' AFTER `ACT_INST_ID_`,
MODIFY COLUMN `VAR_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '参数类型' AFTER `NAME_`,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `VAR_TYPE_`,
MODIFY COLUMN `TIME_` datetime(3) NOT NULL COMMENT '时间戳' AFTER `REV_`,
MODIFY COLUMN `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '字节表 ID' AFTER `TIME_`,
MODIFY COLUMN `DOUBLE_` double NULL DEFAULT NULL COMMENT '存储变量类型为 Double' AFTER `BYTEARRAY_ID_`,
MODIFY COLUMN `LONG_` bigint NULL DEFAULT NULL COMMENT '存储变量类型为 long' AFTER `DOUBLE_`,
MODIFY COLUMN `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '存储变量值类型为 String' AFTER `LONG_`,
MODIFY COLUMN `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '此处存储的是 JPA 持久化对象时，才会有值。此值为对象 ID' AFTER `TEXT_`,
COMMENT = '流程明细表';

ALTER TABLE `act_hi_taskinst` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程定义 ID' AFTER `REV_`,
MODIFY COLUMN `TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任务定义的 ID 值' AFTER `TASK_DEF_ID_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `TASK_DEF_KEY_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '执行 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称' AFTER `PROPAGATED_STAGE_INST_ID_`,
MODIFY COLUMN `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '父任务 ID' AFTER `NAME_`,
MODIFY COLUMN `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '说明' AFTER `PARENT_TASK_ID_`,
MODIFY COLUMN `OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '实际签收人 任务的拥有者' AFTER `DESCRIPTION_`,
MODIFY COLUMN `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '被指派执行该任务的人' AFTER `OWNER_`,
MODIFY COLUMN `START_TIME_` datetime(3) NOT NULL COMMENT '开始时间' AFTER `ASSIGNEE_`,
MODIFY COLUMN `CLAIM_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '提醒时间' AFTER `START_TIME_`,
MODIFY COLUMN `END_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '结束时间' AFTER `CLAIM_TIME_`,
MODIFY COLUMN `DURATION_` bigint NULL DEFAULT NULL COMMENT '耗时' AFTER `END_TIME_`,
MODIFY COLUMN `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '删除原因' AFTER `DURATION_`,
MODIFY COLUMN `PRIORITY_` int NULL DEFAULT NULL COMMENT '优先级别' AFTER `DELETE_REASON_`,
MODIFY COLUMN `DUE_DATE_` datetime(3) NULL DEFAULT NULL COMMENT '过期时间' AFTER `PRIORITY_`,
MODIFY COLUMN `FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '节点定义的 formkey' AFTER `DUE_DATE_`,
MODIFY COLUMN `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '类别' AFTER `FORM_KEY_`,
COMMENT = '历史任务表';

ALTER TABLE `act_hi_actinst` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '流程定义 ID' AFTER `REV_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '流程实例 ID' AFTER `PROC_DEF_ID_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '执行 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '节点实例 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `ACT_ID_`,
MODIFY COLUMN `CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '调用外部的流程实例 ID' AFTER `TASK_ID_`,
MODIFY COLUMN `ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '节点名称' AFTER `CALL_PROC_INST_ID_`,
MODIFY COLUMN `ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '节点类型' AFTER `ACT_NAME_`,
MODIFY COLUMN `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '节点签收人' AFTER `ACT_TYPE_`,
MODIFY COLUMN `START_TIME_` datetime(3) NOT NULL COMMENT '开始时间' AFTER `ASSIGNEE_`,
MODIFY COLUMN `END_TIME_` datetime(3) NULL DEFAULT NULL COMMENT '结束时间' AFTER `START_TIME_`,
MODIFY COLUMN `DURATION_` bigint NULL DEFAULT NULL COMMENT '耗时' AFTER `TRANSACTION_ORDER_`,
MODIFY COLUMN `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '删除原因' AFTER `DURATION_`,
COMMENT = '历史行为表';

ALTER TABLE `act_hi_attachment` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户 ID' AFTER `REV_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称' AFTER `USER_ID_`,
MODIFY COLUMN `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '说明' AFTER `NAME_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '类型' AFTER `DESCRIPTION_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `TYPE_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `TASK_ID_`,
MODIFY COLUMN `CONTENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '字节表的 ID' AFTER `URL_`,
MODIFY COLUMN `TIME_` datetime(3) NULL DEFAULT NULL COMMENT '时间' AFTER `CONTENT_ID_`,
COMMENT = '附件表';

ALTER TABLE `act_hi_comment` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '类型：event（事件）、comment（意见）' AFTER `ID_`,
MODIFY COLUMN `TIME_` datetime(3) NOT NULL COMMENT '时间' AFTER `TYPE_`,
MODIFY COLUMN `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户 ID' AFTER `TIME_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `USER_ID_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `TASK_ID_`,
MODIFY COLUMN `ACTION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '行为类型' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `MESSAGE_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '信息' AFTER `ACTION_`,
MODIFY COLUMN `FULL_MSG_` longblob NULL COMMENT '全部内容' AFTER `MESSAGE_`,
COMMENT = '评论表';

ALTER TABLE `act_re_model` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '分类' AFTER `KEY_`,
MODIFY COLUMN `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '创建时间' AFTER `CATEGORY_`,
MODIFY COLUMN `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL COMMENT '最后更新时间' AFTER `CREATE_TIME_`,
MODIFY COLUMN `VERSION_` int NULL DEFAULT NULL COMMENT '版本' AFTER `LAST_UPDATE_TIME_`,
MODIFY COLUMN `META_INFO_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '以 json 格式保存流程定义的信息' AFTER `VERSION_`,
MODIFY COLUMN `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '部署 ID' AFTER `META_INFO_`,
COMMENT = '流程设计模型部署表';

ALTER TABLE `act_evt_log` 
MODIFY COLUMN `LOG_NR_` bigint NOT NULL AUTO_INCREMENT COMMENT '主键' FIRST,
MODIFY COLUMN `TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '类型' AFTER `LOG_NR_`,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程定义 ID' AFTER `TYPE_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `PROC_DEF_ID_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '执行 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `EXECUTION_ID_`,
COMMENT = '事件日志表';

ALTER TABLE `act_procdef_info` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '流程定义 ID' AFTER `ID_`,
MODIFY COLUMN `REV_` int NULL DEFAULT NULL COMMENT '数据版本' AFTER `PROC_DEF_ID_`,
COMMENT = '流程定义更新信息';

ALTER TABLE `act_hi_varinst` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `REV_` int NULL DEFAULT 1 COMMENT '数据版本' AFTER `ID_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `REV_`,
MODIFY COLUMN `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '指定 ID' AFTER `PROC_INST_ID_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `EXECUTION_ID_`,
MODIFY COLUMN `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '名称' AFTER `TASK_ID_`,
MODIFY COLUMN `VAR_TYPE_` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '参数类型' AFTER `NAME_`,
MODIFY COLUMN `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '字节表 ID' AFTER `SCOPE_TYPE_`,
MODIFY COLUMN `DOUBLE_` double NULL DEFAULT NULL COMMENT '存储 double 类型数据' AFTER `BYTEARRAY_ID_`,
MODIFY COLUMN `LONG_` bigint NULL DEFAULT NULL COMMENT '存储 long 类型数据' AFTER `DOUBLE_`,
COMMENT = '历史变量表历史变量表';

ALTER TABLE `act_hi_identitylink` 
MODIFY COLUMN `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键' FIRST,
MODIFY COLUMN `GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '组 ID' AFTER `ID_`,
MODIFY COLUMN `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '类型' AFTER `GROUP_ID_`,
MODIFY COLUMN `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户 ID' AFTER `TYPE_`,
MODIFY COLUMN `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任务 ID' AFTER `USER_ID_`,
MODIFY COLUMN `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程实例 ID' AFTER `CREATE_TIME_`,
COMMENT = '历史流程人员表';

宁姑娘，定要到那倒悬山
关注
  • 10
    点赞
  • 踩
  • 10
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
Flowable打印调用原生API查询接口的SQL日志
weixin_40991408的博客
04-25 1969
Flowable打印调用原生API查询接口的SQL日志
flowable工作流sql
03-17
flowable工作流sql
flowable.oracle.create.6.3.1.sql
06-19
如果你第一次跑Flowable6时，提示jar版本跟数据库版本不一致时，请下载这个脚本，这个是oracle版的。到现在都没搞懂，难道Flowable的开发人员都没测试过么，还是说我忽略了啥东西导致失败，项目第一次用Flowable，决定用Flowable6.3.0，因为这个版本官方有中文文档，但是死活跑不起来，最后整理了这个建表脚本，然后把Flowable版本改为6.3.1，最后成功了！
【Flowable 7】学习笔记 01 - 初始化数据库表创建流程（源码）
最新发布
MichelleChung的星球
05-28 1312
Flowable 7 启动初始化生成数据库表简单源码分析。
1、初始化flowable数据库
放弃很容易，坚持很难。
03-21 1057
flowable初始化数据库
学习记录548@flowable查看和完成任务的sql机制与思考
教练我想学编程
03-25 986
流程 <?xml version="1.0" encoding="UTF-8"?> <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" x
Flowable流程入门课程
05-08
本课程基于最新版开源工作流Flowable 6.6.0进行讲解。着重讲解Flowable工作流的概念、理论和实战。课程内容包括Flowable的架构、安装部署与配置、工作流应用开发与运行的主要过程、Flowable流程引擎服务及其API、Flowable主要元素如事件/序列流/网关/活动和任务、Flowable表单引擎的安装配置和引擎服务、Flowable表单引擎与Spring的集成、表单定义及部署、表单REST API、 Flowable 身份管理应用、Flowable 建模器应用、Flowable 任务应用和Flowable 管理应用等概念、术语和实战内容，让大家能快速实现基于Flowable的流程应用开发。通过对Flowable官方文档进行了彻底梳理和融汇贯通，并结合实践，整合成13小时15分钟共56节的基础课程，系统、简明地呈现给大家，让大家从开源软件文档冗长耗时、英文晦涩难懂、概念理解困难的困境中解脱出来，从而能快速地将Flowable应用到项目实践中去。课程特色： 案例和代码驱动、概念与实战相结合。
flowable自定义sql查询
rhj的博客
11-17 1329
flowable+springboot自定义sql
FLOWABLE打印底层sql
Zdeshijie的博客
11-24 727
建议在 Spring Boot 的 application.properties 中添加如下配置，开启flowablelogging:level:root: info# 增加flowable 底层打印sql这个配置表示开启 flowable 的日志，开启日志的好处是可以看到底层的 SQL语句。version:{};看下控制台打印的 SQL：可以看到，就是去流程定义表 ACT_RE_PROCDEF 去查看所有。version:{};
flowable 6.7.2 工作流自定义mybatis sql查询我的待办，我的已办，流程列表，流程日志等；集成了自定义用户表
热门推荐
mxskymx的专栏
07-08 1万+
此处用mybatis.xml实现了查询流程定义，我的流程，我的待办，我的已办，流程日志等连表sql；说明：系统中没有flowable带的用户表 act_id_user，而是用的自定义用户表。 2.查询已发布的流程版本列表 3. 查询用户发起流程列表 4.查询用户待办任务列表 5.查询用户..................
flowable数据库命名规则以及其数据表结构
06-22
Flowable 是一个基于BPMN 2.0标准的开源工作流引擎，它不仅支持基本的业务流程管理，还提供了一系列扩展功能，如...通过深入理解这些表的结构和功能，用户可以更好地设计、实施和优化基于Flowable的工作流解决方案。
flowable流程引擎-核心表分析
06-27
Flowable流程引擎核心表分析 流程引擎的核心表是Flowable流程引擎的基础组件，用于存储流程引擎的各种数据。这些表可以配置为在启动时生成，所有的表都以“act_”开头，沿用了Activiti的传统。 Flowable流程引擎...
Flowable 6.6.0 Applications.docx
12-23
它提供了多个应用程序，包括Flowable Modeler、Flowable Admin、Flowable IDM（Identity Management）以及Flowable Task，这些应用程序为企业提供了一整套流程管理和任务处理的工具。 1. **Flowable UI 应用安装**...
flowable6.6.0 源码包和部署包
11-30
Flowable是一款开源的工作流引擎，它基于BPMN2.0标准，提供了强大的流程建模、执行和管理功能。在Flowable 6.6.0版本中，包含了源码包和部署包，这对于开发者和系统管理员来说是非常有价值的资源。源码包允许开发者...
Flowable高级篇 -6.8.0 最全表结构说明-主要表结构字段注释
qq_31237581的博客
04-13 6160
flowable 28张表 详细
学习记录544@springboot配置日志来打印flowable执行的sql语句
教练我想学编程
03-24 3933
事情是这个样子的，在学习flowable的时候，粗略的看了一遍用户手册，是的还蛮清晰的，但是总觉得少了点什么，仔细想了想，方法调用是很简单，但总觉得不了解内部机制，而了解内部运行机制最简单的方法就是数据库表，的确无论是官网还是博客资料均对flowable数据库表进行了详细的说明，细化到了每个表的字段，但是呢？还是不够，我想要了解的时运行机制，比如我部署的时候，内部到底执行了什么，执行的sql语句是什么，操作了哪些表哪些字段等等，带着这种疑问，尝试了起来。 我的运行环境是springboot+flowable
flowable打印sql配置
蓝天⊙白云的博客
11-04 1584
【代码】flowable打印sql配置。
flowable6.6用户手册中文版
08-09
Flowable 6.6 是一款流程引擎，用户手册为了方便使用者了解和操作该引擎而制作的教程。用户手册中文版是指将Flowable 6.6的用户手册翻译成中文，以便中文用户更加便捷地学习和使用这个工具。 Flowable 6.6用户手册中文版包含了Flowable 6.6流程引擎的详细介绍和使用方法。通过该手册，用户可以了解引擎的安装和配置方法，以及各个模块的功能和用法。例如，用户可以学习如何定义和部署流程、如何进行任务管理、如何进行表单和事件管理等。 用户手册的内容组织结构清晰，系统地介绍了Flowable 6.6的各个方面。手册中提供了大量的示例代码和图表，以帮助用户理解和运用Flowable引擎。此外，用户手册还包含了常见问题解答和技巧建议，以便用户更好地解决问题和提高使用效率。 需要注意的是，Flowable 6.6用户手册中文版是一个电子文档，可以通过下载或在线浏览的方式获取。用户可以随时方便地查阅手册并进行学习和使用。 总之，Flowable 6.6用户手册中文版是一本详细介绍Flowable 6.6流程引擎的教程，为中文用户提供了便捷的学习和使用方法。用户可以通过手册了解引擎的功能和使用技巧，并运用在实际项目中。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值