ALTER TABLE `bpm_agent_condition` CHANGE `SETTING_ID_` `SETTING_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '设定ID'; ALTER TABLE `bpm_agent_condition` CHANGE `CONDITION_DESC_` `CONDITION_DESC_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '条件描述'; ALTER TABLE `bpm_agent_condition` CHANGE `CONDITION_` `CONDITION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '条件'; ALTER TABLE `bpm_agent_condition` CHANGE `AGENT_ID_` `AGENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人ID'; ALTER TABLE `bpm_agent_condition` CHANGE `AGENT_NAME_` `AGENT_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人'; ALTER TABLE `bpm_agent_def` CHANGE `SETTING_ID_` `SETTING_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '设定ID'; ALTER TABLE `bpm_agent_def` CHANGE `FLOW_KEY_` `FLOW_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义KEY'; ALTER TABLE `bpm_agent_def` CHANGE `FLOW_NAME_` `FLOW_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义名称'; ALTER TABLE `bpm_agent_def` CHANGE `NODE_ID_` `NODE_ID_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点定义ID(为空的情况,如果指定ID,那么代理只在这些ID的任务生效)'; ALTER TABLE `bpm_agent_def` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称'; ALTER TABLE `bpm_agent_setting` CHANGE `SUBJECT_` `SUBJECT_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '标题'; ALTER TABLE `bpm_agent_setting` CHANGE `AUTH_ID_` `AUTH_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '授权人ID'; ALTER TABLE `bpm_agent_setting` CHANGE `AUTH_NAME_` `AUTH_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '授权人姓名'; ALTER TABLE `bpm_agent_setting` CHANGE `IS_ENABLED_` `IS_ENABLED_` char(1) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '是否有效'; ALTER TABLE `bpm_agent_setting` CHANGE `AGENT_ID_` `AGENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人ID'; ALTER TABLE `bpm_agent_setting` CHANGE `AGENT_` `AGENT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人'; ALTER TABLE `bpm_agent_setting` CHANGE `FLOW_KEY_` `FLOW_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义KEY'; ALTER TABLE `bpm_agent_setting` CHANGE `TYPE_` `TYPE_` smallint(6) null DEFAULT null COMMENT '代理类型(1,全权代理,2,部分代理,3.条件代理)'; ALTER TABLE `bpm_agent_setting` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_agent_setting` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID'; ALTER TABLE `bpm_agent_setting` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID'; ALTER TABLE `bpm_agent_setting` CHANGE `TENANT_ID_` `TENANT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '租户id'; ALTER TABLE `bpm_approval_item` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户ID'; ALTER TABLE `bpm_approval_item` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义KEY'; ALTER TABLE `bpm_approval_item` CHANGE `DEF_NAME_` `DEF_NAME_` char(10) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义名称'; ALTER TABLE `bpm_approval_item` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程分类ID'; ALTER TABLE `bpm_approval_item` CHANGE `TYPE_` `TYPE_` smallint(6) null DEFAULT null COMMENT '常用语类型 默认为1=全局 2=流程分类 3=流程 4=个人的常用语'; ALTER TABLE `bpm_approval_item` CHANGE `EXPRESSION_` `EXPRESSION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '常用语 多个项用回车分开'; ALTER TABLE `bpm_approval_item` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_approval_item` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人所属组织ID'; ALTER TABLE `bpm_approval_item` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID'; ALTER TABLE `bpm_approval_org` CHANGE `APPROVAL_ID_` `APPROVAL_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '常用语'; ALTER TABLE `bpm_approval_org` CHANGE `POST_ID_` `POST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '岗位'; ALTER TABLE `bpm_approval_org` CHANGE `ROLE_ID_` `ROLE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '角色'; ALTER TABLE `bpm_approval_org` CHANGE `DEPARTMENT_ID_` `DEPARTMENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '部门'; ALTER TABLE `bpm_attention` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例id'; ALTER TABLE `bpm_attention` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户id'; ALTER TABLE `bpm_attention` CHANGE `OWNER_NAME_` `OWNER_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户名称'; ALTER TABLE `bpm_bus_link` CHANGE `DEF_ID_` `DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_bus_link` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_bus_link` CHANGE `BUSINESSKEY_` `BUSINESSKEY_` bigint(20) null DEFAULT null COMMENT '业务键'; ALTER TABLE `bpm_bus_link` CHANGE `BUSINESSKEY_STR_` `BUSINESSKEY_STR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务键字符型'; ALTER TABLE `bpm_bus_link` CHANGE `SYS_CODE_` `SYS_CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务系统编码'; ALTER TABLE `bpm_bus_link` CHANGE `FORM_IDENTIFY_` `FORM_IDENTIFY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '表单标识'; ALTER TABLE `bpm_bus_link` CHANGE `START_ID_` `START_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人'; ALTER TABLE `bpm_bus_link` CHANGE `STARTOR_` `STARTOR_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人'; ALTER TABLE `bpm_bus_link` CHANGE `START_GROUP_ID_` `START_GROUP_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起组织ID'; ALTER TABLE `bpm_bus_link` CHANGE `START_GROUP_` `START_GROUP_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起组织'; ALTER TABLE `bpm_bus_link` CHANGE `IS_MAIN_` `IS_MAIN_` smallint(6) null DEFAULT null COMMENT '主记录'; ALTER TABLE `bpm_bus_link` CHANGE `BO_DEF_CODE_` `BO_DEF_CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'bodefcode数据'; ALTER TABLE `bpm_bus_link` CHANGE `SAVE_MODE_` `SAVE_MODE_` varchar(50) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '保存模式 (boObject,database)'; ALTER TABLE `bpm_call_log` CHANGE `SUBJECT_` `SUBJECT_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT ' 流程标题'; ALTER TABLE `bpm_call_log` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT ' 流程定义ID'; ALTER TABLE `bpm_call_log` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义Key'; ALTER TABLE `bpm_call_log` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_call_log` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '父流程实例ID'; ALTER TABLE `bpm_call_log` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_call_log` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key'; ALTER TABLE `bpm_call_log` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称'; ALTER TABLE `bpm_call_log` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用人员ID'; ALTER TABLE `bpm_call_log` CHANGE `EVENT_TYPE_` `EVENT_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '事件类型'; ALTER TABLE `bpm_call_log` CHANGE `URL_` `URL_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用地址'; ALTER TABLE `bpm_call_log` CHANGE `DESC_` `DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接口描述'; ALTER TABLE `bpm_call_log` CHANGE `INVOKE_MODE_` `INVOKE_MODE_` int(11) null DEFAULT null COMMENT '接口调用模式:0:同步，1:异步'; ALTER TABLE `bpm_call_log` CHANGE `IS_SUCCESS_` `IS_SUCCESS_` smallint(6) null DEFAULT '0' COMMENT '是否调用成功'; ALTER TABLE `bpm_call_log` CHANGE `RESPONSE_` `RESPONSE_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用结果'; ALTER TABLE `bpm_call_log` CHANGE `PARAMS_` `PARAMS_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '请求参数'; ALTER TABLE `bpm_call_log` CHANGE `HEADER_` `HEADER_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '请求头'; ALTER TABLE `bpm_call_log` CHANGE `RETRY_COUNT_` `RETRY_COUNT_` int(11) null DEFAULT null COMMENT '重试次数'; ALTER TABLE `bpm_check_opinion` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID'; ALTER TABLE `bpm_check_opinion` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父流程实例ID'; ALTER TABLE `bpm_check_opinion` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID'; ALTER TABLE `bpm_check_opinion` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_check_opinion` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key'; ALTER TABLE `bpm_check_opinion` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称'; ALTER TABLE `bpm_check_opinion` CHANGE `TOKEN_` `TOKEN_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务令牌'; ALTER TABLE `bpm_check_opinion` CHANGE `QUALFIEDS_` `QUALFIEDS_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户ID串'; ALTER TABLE `bpm_check_opinion` CHANGE `QUALFIED_NAMES_` `QUALFIED_NAMES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户名称串'; ALTER TABLE `bpm_check_opinion` CHANGE `AUDITOR_` `AUDITOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID'; ALTER TABLE `bpm_check_opinion` CHANGE `AUDITOR_NAME_` `AUDITOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人名'; ALTER TABLE `bpm_check_opinion` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织ID'; ALTER TABLE `bpm_check_opinion` CHANGE `ORG_PATH_` `ORG_PATH_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织全路径'; ALTER TABLE `bpm_check_opinion` CHANGE `OPINION_` `OPINION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批意见'; ALTER TABLE `bpm_check_opinion` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '审批状态。start=发起流程；awaiting_check=待审批；agree=同意；against=反对；return=驳回；abandon=弃权；retrieve=追回'; ALTER TABLE `bpm_check_opinion` CHANGE `FORM_DEF_ID_` `FORM_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单定义ID'; ALTER TABLE `bpm_check_opinion` CHANGE `FORM_NAME_` `FORM_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单名'; ALTER TABLE `bpm_check_opinion` CHANGE `FILES_` `FILES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '附件'; ALTER TABLE `bpm_check_opinion` CHANGE `INTERPOSE_` `INTERPOSE_` smallint(6) null DEFAULT null COMMENT '是否干预'; ALTER TABLE `bpm_check_opinion` CHANGE `IS_DELE_` `IS_DELE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `bpm_check_opinion` CHANGE `IS_READ_` `IS_READ_` int(11) NOT NULL DEFAULT '0' COMMENT '0：待阅，1：已阅'; ALTER TABLE `bpm_check_opinion` CHANGE `AGENT_LEADER_ID_` `AGENT_LEADER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被代理的领导人id'; ALTER TABLE `bpm_check_opinion` CHANGE `PROP1_` `PROP1_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性1'; ALTER TABLE `bpm_check_opinion` CHANGE `PROP2_` `PROP2_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性2'; ALTER TABLE `bpm_check_opinion` CHANGE `PROP3_` `PROP3_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性3'; ALTER TABLE `bpm_check_opinion` CHANGE `PROP4_` `PROP4_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性4'; ALTER TABLE `bpm_check_opinion` CHANGE `PROP5_` `PROP5_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性5'; ALTER TABLE `bpm_check_opinion` CHANGE `PROP6_` `PROP6_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性6'; ALTER TABLE `bpm_check_opinion` CHANGE `Z_FILES_` `Z_FILES_` varchar(1000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '正文附件'; ALTER TABLE `bpm_check_opinion` CHANGE `PARENT_TASK_ID_` `PARENT_TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父任务id'; ALTER TABLE `bpm_check_opinion` CHANGE `SIGN_TYPE_` `SIGN_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务类型'; ALTER TABLE `bpm_check_opinion` CHANGE `SKIP_TYPE_` `SKIP_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '跳过类型 启动跳过 审批跳过 执行人为空跳过 相同执行人跳过'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父流程实例ID'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `TOKEN_` `TOKEN_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务令牌'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `QUALFIEDS_` `QUALFIEDS_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户ID串'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `QUALFIED_NAMES_` `QUALFIED_NAMES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户名称串'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `AUDITOR_` `AUDITOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `AUDITOR_NAME_` `AUDITOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人名'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织ID'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `ORG_PATH_` `ORG_PATH_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织全路径'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `OPINION_` `OPINION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批意见'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '审批状态。start=发起流程；create=任务创建；agree=同意；against=反对；return=驳回；abandon=弃权；retrieve=追回'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `FORM_DEF_ID_` `FORM_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单定义ID'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `FORM_NAME_` `FORM_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单名'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `DUR_MS_` `DUR_MS_` bigint(20) null DEFAULT null COMMENT '持续时间(ms)'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP1_` `PROP1_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性1'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP2_` `PROP2_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性2'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP3_` `PROP3_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性3'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP4_` `PROP4_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性4'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP5_` `PROP5_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性5'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP6_` `PROP6_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性6'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `Z_FILES_` `Z_FILES_` varchar(1000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '正文附件'; ALTER TABLE `bpm_check_opinion_hi` CHANGE `PARENT_TASK_ID_` `PARENT_TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父任务id'; ALTER TABLE `bpm_commu_receiver` CHANGE `COMMU_ID_` `COMMU_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '通知ID'; ALTER TABLE `bpm_commu_receiver` CHANGE `RECEIVER_ID_` `RECEIVER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人ID'; ALTER TABLE `bpm_commu_receiver` CHANGE `RECEIVER` `RECEIVER` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人'; ALTER TABLE `bpm_commu_receiver` CHANGE `STATUS_` `STATUS_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '状态'; ALTER TABLE `bpm_commu_receiver` CHANGE `OPINION_` `OPINION_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '反馈意见'; ALTER TABLE `bpm_cpto_receiver` CHANGE `CPTO_ID_` `CPTO_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联ID'; ALTER TABLE `bpm_cpto_receiver` CHANGE `RECEIVER_ID_` `RECEIVER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人ID'; ALTER TABLE `bpm_cpto_receiver` CHANGE `RECEIVER_` `RECEIVER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人'; ALTER TABLE `bpm_cpto_receiver` CHANGE `IS_READ_` `IS_READ_` smallint(6) null DEFAULT null COMMENT '已读'; ALTER TABLE `bpm_custom_signdata` CHANGE `TYPE_` `TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务类型（并签，顺签，并批）'; ALTER TABLE `bpm_custom_signdata` CHANGE `STATUS_` `STATUS_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批中，完成，二次并签，被撤回，撤回审批中，撤回无待办'; ALTER TABLE `bpm_custom_signdata` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父id'; ALTER TABLE `bpm_custom_signdata` CHANGE `PATH_` `PATH_` varchar(3000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '路径'; ALTER TABLE `bpm_custom_signdata` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '实例id'; ALTER TABLE `bpm_custom_signdata` CHANGE `NODE_ID_` `NODE_ID_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点id'; ALTER TABLE `bpm_custom_signdata` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务id'; ALTER TABLE `bpm_def_act` CHANGE `AUTHORIZE_ID_` `AUTHORIZE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权主表ID'; ALTER TABLE `bpm_def_act` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权流程KEY'; ALTER TABLE `bpm_def_act` CHANGE `DEF_NAME_` `DEF_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权流程名称'; ALTER TABLE `bpm_def_act` CHANGE `RIGHT_CONTENT_` `RIGHT_CONTENT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权内容'; ALTER TABLE `bpm_def_auth_type` CHANGE `AUTHORIZE_ID_` `AUTHORIZE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权主表ID'; ALTER TABLE `bpm_def_auth_type` CHANGE `AUTHORIZE_TYPE_` `AUTHORIZE_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权类型定义（management）、启动（start）、实例（instance）和任务（task）'; ALTER TABLE `bpm_def_authorize` CHANGE `AUTHORIZE_DESC_` `AUTHORIZE_DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权说明'; ALTER TABLE `bpm_def_authorize` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_def_authorize` CHANGE `CREATOR_` `CREATOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `bpm_def_data` CHANGE `BPMN_XML_` `BPMN_XML_` longtext character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义XML'; ALTER TABLE `bpm_def_user` CHANGE `AUTHORIZE_ID_` `AUTHORIZE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权主表ID'; ALTER TABLE `bpm_def_user` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象ID'; ALTER TABLE `bpm_def_user` CHANGE `OWNER_NAME_` `OWNER_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象名称'; ALTER TABLE `bpm_def_user` CHANGE `RIGHT_TYPE_` `RIGHT_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象类型(角色,用户,岗位等)'; ALTER TABLE `bpm_definition` CHANGE `DEF_ID_` `DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID'; ALTER TABLE `bpm_definition` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程名称'; ALTER TABLE `bpm_definition` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义KEY'; ALTER TABLE `bpm_definition` CHANGE `DESC_` `DESC_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程描述'; ALTER TABLE `bpm_definition` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '所属分类ID'; ALTER TABLE `bpm_definition` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '状态。草稿、发布、禁用'; ALTER TABLE `bpm_definition` CHANGE `TEST_STATUS_` `TEST_STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '测试状态'; ALTER TABLE `bpm_definition` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN - 流程定义ID'; ALTER TABLE `bpm_definition` CHANGE `BPMN_DEPLOY_ID_` `BPMN_DEPLOY_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN - 流程发布ID'; ALTER TABLE `bpm_definition` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本 - 当前版本号'; ALTER TABLE `bpm_definition` CHANGE `MAIN_DEF_ID_` `MAIN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '版本 - 主版本流程ID'; ALTER TABLE `bpm_definition` CHANGE `IS_MAIN_` `IS_MAIN_` char(1) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '版本 - 是否主版本'; ALTER TABLE `bpm_definition` CHANGE `REASON_` `REASON_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '版本 - 变更理由'; ALTER TABLE `bpm_definition` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_definition` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID'; ALTER TABLE `bpm_definition` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID'; ALTER TABLE `bpm_definition` CHANGE `DESIGNER_` `DESIGNER_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '设计器类型'; ALTER TABLE `bpm_definition` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机表单'; ALTER TABLE `bpm_definition` CHANGE `REV_` `REV_` int(11) NOT NULL DEFAULT '1' COMMENT '关联锁'; ALTER TABLE `bpm_definition` CHANGE `SHOW_URGENT_STATE_` `SHOW_URGENT_STATE_` int(11) null DEFAULT null COMMENT '是否显示紧急状态'; ALTER TABLE `bpm_definition` CHANGE `IS_READ_REVOKE` `IS_READ_REVOKE` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '传阅已阅是否允许撤回'; ALTER TABLE `bpm_definition` CHANGE `URGENT_MAIL_TEL` `URGENT_MAIL_TEL` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '人工催办内容邮件模板'; ALTER TABLE `bpm_definition` CHANGE `URGENT_SMS_TEL` `URGENT_SMS_TEL` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '人工催办内容短信模板'; ALTER TABLE `bpm_definition` CHANGE `SHOW_MODIFY_RECORD_` `SHOW_MODIFY_RECORD_` int(11) null DEFAULT null COMMENT '是否显示表单留痕'; ALTER TABLE `bpm_deputy` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '被代理人id'; ALTER TABLE `bpm_deputy` CHANGE `USER_NAME_` `USER_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被代理人姓名'; ALTER TABLE `bpm_deputy` CHANGE `AGENT_ID_` `AGENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '代理人id'; ALTER TABLE `bpm_deputy` CHANGE `AGENT_NAME_` `AGENT_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人姓名'; ALTER TABLE `bpm_deputy` CHANGE `IS_MAIL_` `IS_MAIL_` int(11) null DEFAULT '1' COMMENT '是否接收邮件(1:接收，0：不接收)'; ALTER TABLE `bpm_deputy` CHANGE `IS_USABLE_` `IS_USABLE_` int(11) null DEFAULT '1' COMMENT '是否可用（1：启用，0：禁用）'; ALTER TABLE `bpm_exe_stack` CHANGE `PRCO_DEF_ID_` `PRCO_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_exe_stack` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '节点ID'; ALTER TABLE `bpm_exe_stack` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名'; ALTER TABLE `bpm_exe_stack` CHANGE `IS_MULITI_TASK_` `IS_MULITI_TASK_` smallint(6) NOT NULL COMMENT '多实例任务 1=是 0=否'; ALTER TABLE `bpm_exe_stack` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父ID'; ALTER TABLE `bpm_exe_stack` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_exe_stack` CHANGE `NODE_PATH_` `NODE_PATH_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点路径 格式如： 0.1.2. 其中2则为本行记录的主键值'; ALTER TABLE `bpm_exe_stack` CHANGE `DEPTH_` `DEPTH_` smallint(6) null DEFAULT null COMMENT '节点层'; ALTER TABLE `bpm_exe_stack` CHANGE `TASK_TOKEN_` `TASK_TOKEN_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '是针对分发任务时，携带的令牌，方便查找其父任务堆栈'; ALTER TABLE `bpm_exe_stack` CHANGE `NODE_TYPE_` `NODE_TYPE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点类型'; ALTER TABLE `bpm_exe_stack` CHANGE `TARGET_NODE_` `TARGET_NODE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '驳回时返回节点'; ALTER TABLE `bpm_exe_stack` CHANGE `INTERPOSE_` `INTERPOSE_` smallint(6) null DEFAULT null COMMENT '是否干预执行'; ALTER TABLE `bpm_exe_stack_executor` CHANGE `STACK_ID_` `STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '堆栈ID'; ALTER TABLE `bpm_exe_stack_executor` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_exe_stack_executor` CHANGE `ASSIGNEE_ID_` `ASSIGNEE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人'; ALTER TABLE `bpm_exe_stack_executor` CHANGE `STATUS_` `STATUS_` smallint(6) null DEFAULT null COMMENT '状态(0,初始,1,完成,2,取消)'; ALTER TABLE `bpm_exe_stack_his` CHANGE `PRCO_DEF_ID_` `PRCO_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_exe_stack_his` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '节点ID'; ALTER TABLE `bpm_exe_stack_his` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名'; ALTER TABLE `bpm_exe_stack_his` CHANGE `IS_MULITI_TASK_` `IS_MULITI_TASK_` smallint(6) NOT NULL COMMENT '多实例任务 1=是 0=否'; ALTER TABLE `bpm_exe_stack_his` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父ID'; ALTER TABLE `bpm_exe_stack_his` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_exe_stack_his` CHANGE `NODE_PATH_` `NODE_PATH_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点路径 格式如： 0.1.2. 其中2则为本行记录的主键值'; ALTER TABLE `bpm_exe_stack_his` CHANGE `DEPTH_` `DEPTH_` smallint(6) null DEFAULT null COMMENT '节点层'; ALTER TABLE `bpm_exe_stack_his` CHANGE `TASK_TOKEN_` `TASK_TOKEN_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '是针对分发任务时，携带的令牌，方便查找其父任务堆栈'; ALTER TABLE `bpm_exe_stack_his` CHANGE `NODE_TYPE_` `NODE_TYPE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点类型'; ALTER TABLE `bpm_exe_stack_his` CHANGE `TARGET_NODE_` `TARGET_NODE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '驳回时返回节点'; ALTER TABLE `bpm_exe_stack_his` CHANGE `INTERPOSE_` `INTERPOSE_` smallint(6) null DEFAULT null COMMENT '是否干预执行'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `RELATION_ID_` `RELATION_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关系ID'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `FROM_STACK_ID_` `FROM_STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自堆栈ID'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `TO_STACK_ID_` `TO_STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达堆栈ID'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `FROM_NODE_ID_` `FROM_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自节点'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `TO_NODE_ID_` `TO_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达节点'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `RELATION_STATE_` `RELATION_STATE_` smallint(6) NOT NULL DEFAULT '1' COMMENT '关系状态：1正常，0回收作废'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `FROM_NODE_TYPE_` `FROM_NODE_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自的节点类型'; ALTER TABLE `bpm_exe_stack_relation` CHANGE `TO_NODE_TYPE_` `TO_NODE_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达的节点类型'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `RELATION_ID_` `RELATION_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关系ID'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `FROM_STACK_ID_` `FROM_STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自堆栈ID'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `TO_STACK_ID_` `TO_STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达堆栈ID'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `FROM_NODE_ID_` `FROM_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自节点'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `TO_NODE_ID_` `TO_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达节点'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `RELATION_STATE_` `RELATION_STATE_` smallint(6) NOT NULL DEFAULT '1' COMMENT '关系状态：1正常，0回收作废'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `FROM_NODE_TYPE_` `FROM_NODE_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自的节点类型'; ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `TO_NODE_TYPE_` `TO_NODE_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达的节点类型'; ALTER TABLE `bpm_form_modify_record` CHANGE `REF_ID_` `REF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '外键（表单记录主键）'; ALTER TABLE `bpm_form_modify_record` CHANGE `DATA_` `DATA_` longtext character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单数据'; ALTER TABLE `bpm_hr_script` CHANGE `ALIAS_NAME_` `ALIAS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本的别名'; ALTER TABLE `bpm_hr_script` CHANGE `ALIAS_DESC_` `ALIAS_DESC_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本的描叙'; ALTER TABLE `bpm_hr_script` CHANGE `CLASS_NAME_` `CLASS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用类的路径'; ALTER TABLE `bpm_hr_script` CHANGE `CLASS_INS_NAME_` `CLASS_INS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用类的对象名'; ALTER TABLE `bpm_hr_script` CHANGE `METHOD_NAME_` `METHOD_NAME_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用的方法名'; ALTER TABLE `bpm_hr_script` CHANGE `METHOD_DESC_` `METHOD_DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用的方法的描叙'; ALTER TABLE `bpm_hr_script` CHANGE `RETURN_TYPE_` `RETURN_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '方法返回类型'; ALTER TABLE `bpm_hr_script` CHANGE `ARGUMENT_` `ARGUMENT_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '方法相关设置'; ALTER TABLE `bpm_hr_script` CHANGE `ENABLE_` `ENABLE_` smallint(6) NOT NULL COMMENT '是否有效，有效 1，无效 0'; ALTER TABLE `bpm_hr_script` CHANGE `TYPE_` `TYPE_` smallint(6) null DEFAULT null COMMENT '脚本类型，条件脚本 1，别名脚本 2，人员脚本 3'; ALTER TABLE `bpm_inst_form` CHANGE `DEF_ID_` `DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义id'; ALTER TABLE `bpm_inst_form` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例id'; ALTER TABLE `bpm_inst_form` CHANGE `FORM_VALUE_` `FORM_VALUE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单 inner 记录id frame 记录formValue'; ALTER TABLE `bpm_inst_form` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点id'; ALTER TABLE `bpm_inst_form` CHANGE `FORM_TYPE_` `FORM_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单类型 pc mobile'; ALTER TABLE `bpm_inst_form` CHANGE `FORM_CATEGORY_` `FORM_CATEGORY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'url表单 frame 在线表单 inner'; ALTER TABLE `bpm_interpose_recored` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_interpose_recored` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID'; ALTER TABLE `bpm_interpose_recored` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_interpose_recored` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称'; ALTER TABLE `bpm_interpose_recored` CHANGE `AUDITOR_` `AUDITOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID'; ALTER TABLE `bpm_interpose_recored` CHANGE `AUDITOR_NAME_` `AUDITOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人名'; ALTER TABLE `bpm_interpose_recored` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '干预动作'; ALTER TABLE `bpm_interpose_recored` CHANGE `DUR_MS_` `DUR_MS_` int(11) null DEFAULT null COMMENT '持续时间(ms)'; ALTER TABLE `bpm_meetingroom` CHANGE `NAME_` `NAME_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议室名称'; ALTER TABLE `bpm_meetingroom` CHANGE `NEED_PENDING_` `NEED_PENDING_` smallint(6) null DEFAULT null COMMENT '是否需要审批'; ALTER TABLE `bpm_meetingroom` CHANGE `PENDING_USER_ID_` `PENDING_USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人ID'; ALTER TABLE `bpm_meetingroom` CHANGE `PENDING_USER_NAME_` `PENDING_USER_NAME_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人'; ALTER TABLE `bpm_meetingroom` CHANGE `SUPPORT_SERVICE_` `SUPPORT_SERVICE_` varchar(500) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '支持的服务'; ALTER TABLE `bpm_meetingroom` CHANGE `LOCATION_` `LOCATION_` varchar(300) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议室地址'; ALTER TABLE `bpm_meetingroom` CHANGE `CAPACITY_` `CAPACITY_` int(11) null DEFAULT null COMMENT '会议室容量'; ALTER TABLE `bpm_meetingroom` CHANGE `MEMO_` `MEMO_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议室备注'; ALTER TABLE `bpm_meetingroom_appointment` CHANGE `MEETING_ID_` `MEETING_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议id'; ALTER TABLE `bpm_meetingroom_appointment` CHANGE `MEETING_NAME_` `MEETING_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议名称'; ALTER TABLE `bpm_meetingroom_appointment` CHANGE `HOSTESS_NAME_` `HOSTESS_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '主持人姓名'; ALTER TABLE `bpm_meetingroom_appointment` CHANGE `APPOINTMENT_STATUS_` `APPOINTMENT_STATUS_` int(11) null DEFAULT null COMMENT '预约状态'; ALTER TABLE `bpm_message_type` CHANGE `CLASSIFICATION_CODE_` `CLASSIFICATION_CODE_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分类名称'; ALTER TABLE `bpm_message_type` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `bpm_message_type` CHANGE `IS_PENDING_` `IS_PENDING_` smallint(6) null DEFAULT null COMMENT '是否需要审批'; ALTER TABLE `bpm_message_type` CHANGE `PENDING_USER_ID_` `PENDING_USER_ID_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人id'; ALTER TABLE `bpm_message_type` CHANGE `PENDING_USER_NAME_` `PENDING_USER_NAME_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人姓名'; ALTER TABLE `bpm_multi_script` CHANGE `ALIAS_NAME_` `ALIAS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本的别名'; ALTER TABLE `bpm_multi_script` CHANGE `ALIAS_DESC_` `ALIAS_DESC_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本的描叙'; ALTER TABLE `bpm_multi_script` CHANGE `CLASS_NAME_` `CLASS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用类的路径'; ALTER TABLE `bpm_multi_script` CHANGE `CLASS_INS_NAME_` `CLASS_INS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用类的对象名'; ALTER TABLE `bpm_multi_script` CHANGE `METHOD_NAME_` `METHOD_NAME_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用的方法名'; ALTER TABLE `bpm_multi_script` CHANGE `METHOD_DESC_` `METHOD_DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用的方法的描叙'; ALTER TABLE `bpm_multi_script` CHANGE `RETURN_TYPE_` `RETURN_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '方法返回类型'; ALTER TABLE `bpm_multi_script` CHANGE `ARGUMENT_` `ARGUMENT_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '方法相关设置'; ALTER TABLE `bpm_multi_script` CHANGE `ENABLE_` `ENABLE_` smallint(6) NOT NULL COMMENT '是否有效，有效 1，无效 0'; ALTER TABLE `bpm_multi_script` CHANGE `TYPE_` `TYPE_` smallint(6) null DEFAULT null COMMENT '脚本类型，条件脚本 1，别名脚本 2，人员脚本 3'; ALTER TABLE `bpm_often_flow` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义KEY'; ALTER TABLE `bpm_often_flow` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '所属人id。-1为所有人都有权限'; ALTER TABLE `bpm_often_flow` CHANGE `ORDER_` `ORDER_` smallint(6) null DEFAULT null COMMENT '排序号'; ALTER TABLE `bpm_pro_bo` CHANGE `PROCESS_ID_` `PROCESS_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程ID'; ALTER TABLE `bpm_pro_bo` CHANGE `PROCESS_KEY_` `PROCESS_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程KEY'; ALTER TABLE `bpm_pro_bo` CHANGE `BO_CODE_` `BO_CODE_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务对象CODE'; ALTER TABLE `bpm_pro_bo` CHANGE `BO_NAME_` `BO_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务对象名称'; ALTER TABLE `bpm_pro_bo` CHANGE `CREATOR_ID_` `CREATOR_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `bpm_pro_cpto` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_pro_cpto` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'ACT实例ID'; ALTER TABLE `bpm_pro_cpto` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID'; ALTER TABLE `bpm_pro_cpto` CHANGE `OPINION_` `OPINION_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '意见'; ALTER TABLE `bpm_pro_cpto` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例标题'; ALTER TABLE `bpm_pro_cpto` CHANGE `TYPE_` `TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '抄送类型(copyto抄送,trans转发)'; ALTER TABLE `bpm_pro_cpto` CHANGE `STARTOR_ID_` `STARTOR_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程发起人'; ALTER TABLE `bpm_pro_cpto` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程分类'; ALTER TABLE `bpm_pro_cpto` CHANGE `STARTOR_` `STARTOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `bpm_pro_inst` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例标题'; ALTER TABLE `bpm_pro_inst` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID'; ALTER TABLE `bpm_pro_inst` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN流程定义ID'; ALTER TABLE `bpm_pro_inst` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义Key'; ALTER TABLE `bpm_pro_inst` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程名称'; ALTER TABLE `bpm_pro_inst` CHANGE `BIZ_KEY_` `BIZ_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务主键'; ALTER TABLE `bpm_pro_inst` CHANGE `SYS_CODE_` `SYS_CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务系统编码'; ALTER TABLE `bpm_pro_inst` CHANGE `FORM_KEY_` `FORM_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '绑定的表单主键'; ALTER TABLE `bpm_pro_inst` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '实例状态'; ALTER TABLE `bpm_pro_inst` CHANGE `DURATION_` `DURATION_` bigint(20) null DEFAULT null COMMENT '持续时间(ms)'; ALTER TABLE `bpm_pro_inst` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '所属分类ID'; ALTER TABLE `bpm_pro_inst` CHANGE `RESULT_TYPE_` `RESULT_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程结束后的最终审批结果，agree=同意；refuse=拒绝'; ALTER TABLE `bpm_pro_inst` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN流程实例ID'; ALTER TABLE `bpm_pro_inst` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_pro_inst` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID'; ALTER TABLE `bpm_pro_inst` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID'; ALTER TABLE `bpm_pro_inst` CHANGE `IS_FORMMAL_` `IS_FORMMAL_` char(1) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '是否正式数据'; ALTER TABLE `bpm_pro_inst` CHANGE `PARENT_INST_ID_` `PARENT_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父实例Id'; ALTER TABLE `bpm_pro_inst` CHANGE `IS_FORBIDDEN_` `IS_FORBIDDEN_` smallint(6) null DEFAULT null COMMENT '禁止'; ALTER TABLE `bpm_pro_inst` CHANGE `DATA_MODE_` `DATA_MODE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务数据存储模式。 pk:主键 bo:业务对象'; ALTER TABLE `bpm_pro_inst` CHANGE `CREATOR_` `CREATOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `bpm_pro_inst` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机端'; ALTER TABLE `bpm_pro_inst` CHANGE `SUPER_NODE_ID_` `SUPER_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '子流程节点的ID'; ALTER TABLE `bpm_pro_inst` CHANGE `IS_DELE_` `IS_DELE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `bpm_pro_inst` CHANGE `URGENT_STATE_` `URGENT_STATE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '紧急状态'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例标题'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN流程定义ID'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义Key'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程名称'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `BIZ_KEY_` `BIZ_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联数据业务主键'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `SYS_CODE_` `SYS_CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务系统编码'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `FORM_KEY_` `FORM_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '绑定的表单主键'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '实例状态'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `DURATION_` `DURATION_` bigint(20) null DEFAULT null COMMENT '持续时间'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '所属分类ID'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `RESULT_TYPE_` `RESULT_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程结束后的最终审批结果，agree=同意；refuse=拒绝'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT 'BPMN流程实例ID'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `IS_FORMMAL_` `IS_FORMMAL_` char(1) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '是否正式数据 0非正式,1正式'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `PARENT_INST_ID_` `PARENT_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父实例Id'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `CREATOR_` `CREATOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机端'; ALTER TABLE `bpm_pro_inst_hi` CHANGE `SUPER_NODE_ID_` `SUPER_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '子流程节点ID'; ALTER TABLE `bpm_pro_status` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID'; ALTER TABLE `bpm_pro_status` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT 'ACT流程定义ID'; ALTER TABLE `bpm_pro_status` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '节点ID'; ALTER TABLE `bpm_pro_status` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称'; ALTER TABLE `bpm_pro_status` CHANGE `STATUS_` `STATUS_` varchar(50) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '状态'; ALTER TABLE `bpm_pro_status` CHANGE `LAST_USERID_` `LAST_USERID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '最后更新人'; ALTER TABLE `bpm_pro_status_hi` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID'; ALTER TABLE `bpm_pro_status_hi` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT 'ACT流程定义ID'; ALTER TABLE `bpm_pro_status_hi` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '节点ID'; ALTER TABLE `bpm_pro_status_hi` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称'; ALTER TABLE `bpm_pro_status_hi` CHANGE `STATUS_` `STATUS_` varchar(50) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '状态'; ALTER TABLE `bpm_pro_status_hi` CHANGE `LAST_USERID_` `LAST_USERID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '最后更新人'; ALTER TABLE `bpm_read_record` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_read_record` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父流程实例ID'; ALTER TABLE `bpm_read_record` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_read_record` CHANGE `TASK_ID_` `TASK_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_read_record` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key'; ALTER TABLE `bpm_read_record` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称'; ALTER TABLE `bpm_read_record` CHANGE `READER_` `READER_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '阅读人ID'; ALTER TABLE `bpm_read_record` CHANGE `READER_NAME_` `READER_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '阅读人名'; ALTER TABLE `bpm_read_record` CHANGE `ORG_ID_` `ORG_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id'; ALTER TABLE `bpm_read_record` CHANGE `ORG_PATH_` `ORG_PATH_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织名称'; ALTER TABLE `bpm_reminder_history` CHANGE `INST_ID_` `INST_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_reminder_history` CHANGE `ISNT_NAME_` `ISNT_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例标题'; ALTER TABLE `bpm_reminder_history` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称'; ALTER TABLE `bpm_reminder_history` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID'; ALTER TABLE `bpm_reminder_history` CHANGE `EXECUTE_DATE_` `EXECUTE_DATE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行时间'; ALTER TABLE `bpm_reminder_history` CHANGE `REMIND_TYPE_` `REMIND_TYPE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行类型'; ALTER TABLE `bpm_reminder_history` CHANGE `USER_ID_` `USER_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '说明'; ALTER TABLE `bpm_report_act` CHANGE `REPORT_ID_` `REPORT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '报表主表ID'; ALTER TABLE `bpm_report_act` CHANGE `BPM_DEF_ID_` `BPM_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_report_act` CHANGE `REPORT_NAME_` `REPORT_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '报表名称'; ALTER TABLE `bpm_report_act` CHANGE `DIMENSION_ID_` `DIMENSION_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织维度id'; ALTER TABLE `bpm_report_act` CHANGE `GRADE_` `GRADE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '统计级别'; ALTER TABLE `bpm_report_act` CHANGE `PARAMS_` `PARAMS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '统计参数'; ALTER TABLE `bpm_report_act` CHANGE `RIGHT_CONTENT_` `RIGHT_CONTENT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权内容(报表类型显示)'; ALTER TABLE `bpm_report_act` CHANGE `IS_DEFAULT_` `IS_DEFAULT_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '默认显示视图(1：柱状图，2：饼图)'; ALTER TABLE `bpm_report_act` CHANGE `X_AXIS_` `X_AXIS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'x轴数据'; ALTER TABLE `bpm_report_act` CHANGE `Y_AXIS_` `Y_AXIS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'y轴数据'; ALTER TABLE `bpm_report_act` CHANGE `PORP_` `PORP_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '统计参数'; ALTER TABLE `bpm_report_list` CHANGE `NAME_` `NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '报表主表名称'; ALTER TABLE `bpm_report_list` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_report_list` CHANGE `CREATE_NAME_` `CREATE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人名称'; ALTER TABLE `bpm_report_list` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID'; ALTER TABLE `bpm_report_list` CHANGE `CREATE_ORG_NAME_` `CREATE_ORG_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织名称'; ALTER TABLE `bpm_report_list` CHANGE `TYPE_` `TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '是否发布(1:是，2否)'; ALTER TABLE `bpm_report_user` CHANGE `REPORT_ID_` `REPORT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '报表授权主表ID'; ALTER TABLE `bpm_report_user` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象ID'; ALTER TABLE `bpm_report_user` CHANGE `OWNER_NAME_` `OWNER_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象名称'; ALTER TABLE `bpm_report_user` CHANGE `RIGHT_TYPE_` `RIGHT_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象类型(角色,用户,岗位等)'; ALTER TABLE `bpm_report_user` CHANGE `AUTH_ORG_` `AUTH_ORG_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '主组织ID'; ALTER TABLE `bpm_report_user` CHANGE `AUTH_ORG_NAME_` `AUTH_ORG_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '主组织名称'; ALTER TABLE `bpm_script` CHANGE `NAME_` `NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本名称'; ALTER TABLE `bpm_script` CHANGE `SCRIPT_` `SCRIPT_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本'; ALTER TABLE `bpm_script` CHANGE `CATEGORY_` `CATEGORY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本分类'; ALTER TABLE `bpm_script` CHANGE `MEMO_` `MEMO_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '备注'; ALTER TABLE `bpm_script` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_script` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人所属组织ID'; ALTER TABLE `bpm_script` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID'; ALTER TABLE `bpm_secretary_manage` CHANGE `LEADER_ID_` `LEADER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '领导id'; ALTER TABLE `bpm_secretary_manage` CHANGE `LEADER_NAME_` `LEADER_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '领导姓名'; ALTER TABLE `bpm_secretary_manage` CHANGE `SECRETARY_ID_` `SECRETARY_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '秘书id'; ALTER TABLE `bpm_secretary_manage` CHANGE `SECRETARY_NAME_` `SECRETARY_NAME_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '秘书姓名'; ALTER TABLE `bpm_secretary_manage` CHANGE `SHARE_TYPE_` `SHARE_TYPE_` varchar(2) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '共享类型，1流程分类。2，流程定义'; ALTER TABLE `bpm_secretary_manage` CHANGE `SHARE_KEY_` `SHARE_KEY_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '共享的key'; ALTER TABLE `bpm_secretary_manage` CHANGE `SHARE_NAME_` `SHARE_NAME_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '共享对象的名称'; ALTER TABLE `bpm_secretary_manage` CHANGE `ENABLED_` `ENABLED_` varchar(2) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '1' COMMENT '是否有效'; ALTER TABLE `bpm_secretary_manage` CHANGE `SHARE_RIGHT_` `SHARE_RIGHT_` varchar(10) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '共享权限类型'; ALTER TABLE `bpm_selector_def` CHANGE `NAME_` `NAME_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '名称'; ALTER TABLE `bpm_selector_def` CHANGE `ALIAS_` `ALIAS_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '别名'; ALTER TABLE `bpm_selector_def` CHANGE `GROUP_FIELD_` `GROUP_FIELD_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组合字段'; ALTER TABLE `bpm_selector_def` CHANGE `BUTTONS_` `BUTTONS_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '按钮定义'; ALTER TABLE `bpm_selector_def` CHANGE `IS_CUSTOM_` `IS_CUSTOM_` smallint(6) null DEFAULT null COMMENT '系统预定义'; ALTER TABLE `bpm_selector_def` CHANGE `FLAG_` `FLAG_` smallint(6) null DEFAULT '0' COMMENT '标记是否系统默认'; ALTER TABLE `bpm_selector_def` CHANGE `METHOD_` `METHOD_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '选择器对应的js方法名称'; ALTER TABLE `bpm_selector_def` CHANGE `CONF_KEY_` `CONF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '已选数据参数的传递key'; ALTER TABLE `bpm_task` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务名称'; ALTER TABLE `bpm_task` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '待办事项标题'; ALTER TABLE `bpm_task` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程实例ID'; ALTER TABLE `bpm_task` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联的任务ID'; ALTER TABLE `bpm_task` CHANGE `EXEC_ID_` `EXEC_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 节点执行ID'; ALTER TABLE `bpm_task` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 任务节点ID'; ALTER TABLE `bpm_task` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程定义ID'; ALTER TABLE `bpm_task` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 流程业务主键'; ALTER TABLE `bpm_task` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 流程名称'; ALTER TABLE `bpm_task` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务所属人ID'; ALTER TABLE `bpm_task` CHANGE `ASSIGNEE_ID_` `ASSIGNEE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务执行人ID'; ALTER TABLE `bpm_task` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务状态'; ALTER TABLE `bpm_task` CHANGE `PRIORITY_` `PRIORITY_` int(11) null DEFAULT null COMMENT '任务优先级'; ALTER TABLE `bpm_task` CHANGE `SUSPEND_STATE_` `SUSPEND_STATE_` smallint(6) null DEFAULT '0' COMMENT '是否挂起(0正常,1挂起)'; ALTER TABLE `bpm_task` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父任务ID'; ALTER TABLE `bpm_task` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'bpmn实例ID'; ALTER TABLE `bpm_task` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN定义ID'; ALTER TABLE `bpm_task` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分类ID'; ALTER TABLE `bpm_task` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机'; ALTER TABLE `bpm_task` CHANGE `IS_DELE_` `IS_DELE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `bpm_task` CHANGE `PROP1_` `PROP1_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性1'; ALTER TABLE `bpm_task` CHANGE `PROP2_` `PROP2_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性2'; ALTER TABLE `bpm_task` CHANGE `PROP3_` `PROP3_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性3'; ALTER TABLE `bpm_task` CHANGE `PROP4_` `PROP4_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性4'; ALTER TABLE `bpm_task` CHANGE `PROP5_` `PROP5_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性5'; ALTER TABLE `bpm_task` CHANGE `PROP6_` `PROP6_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性6'; ALTER TABLE `bpm_task_candidate` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_task_candidate` CHANGE `TYPE_` `TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '候选人类型'; ALTER TABLE `bpm_task_candidate` CHANGE `EXECUTOR_` `EXECUTOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID'; ALTER TABLE `bpm_task_candidate` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例'; ALTER TABLE `bpm_task_commu` CHANGE `INSTANCE_ID_` `INSTANCE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_task_commu` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称'; ALTER TABLE `bpm_task_commu` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID'; ALTER TABLE `bpm_task_commu` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_task_commu` CHANGE `SENDER_ID_` `SENDER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发送沟通人ID'; ALTER TABLE `bpm_task_commu` CHANGE `SENDER` `SENDER` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发送沟通人'; ALTER TABLE `bpm_task_commu` CHANGE `OPINION_` `OPINION_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '意见'; ALTER TABLE `bpm_task_due_time` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父id'; ALTER TABLE `bpm_task_due_time` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例id'; ALTER TABLE `bpm_task_due_time` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务id'; ALTER TABLE `bpm_task_due_time` CHANGE `DATE_TYPE_` `DATE_TYPE_` varchar(32) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '时间类型 工作日 worktime 日历日 caltime'; ALTER TABLE `bpm_task_due_time` CHANGE `DUE_TIME_` `DUE_TIME_` int(11) null DEFAULT null COMMENT '任务时间 (分钟)'; ALTER TABLE `bpm_task_due_time` CHANGE `ADD_DUE_TIME_` `ADD_DUE_TIME_` int(11) null DEFAULT null COMMENT '延迟时间'; ALTER TABLE `bpm_task_due_time` CHANGE `REMAINING_TIME_` `REMAINING_TIME_` int(11) null DEFAULT null COMMENT '任务剩余时间（分钟）'; ALTER TABLE `bpm_task_due_time` CHANGE `STATUS_` `STATUS_` int(11) null DEFAULT null COMMENT '状态 是否延期申请过 1申请过 0没延迟过'; ALTER TABLE `bpm_task_due_time` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人ID'; ALTER TABLE `bpm_task_due_time` CHANGE `USER_NAME_` `USER_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人姓名'; ALTER TABLE `bpm_task_due_time` CHANGE `REMARK_` `REMARK_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '说明'; ALTER TABLE `bpm_task_due_time` CHANGE `FILE_ID_` `FILE_ID_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '附件'; ALTER TABLE `bpm_task_due_time` CHANGE `IS_NEW_` `IS_NEW_` int(11) null DEFAULT null COMMENT '是否新的延迟 1 是 0 否 '; ALTER TABLE `bpm_task_follow` CHANGE `ID` `ID` varchar(255) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '主键'; ALTER TABLE `bpm_task_follow` CHANGE `TASK_ID` `TASK_ID` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务id'; ALTER TABLE `bpm_task_follow` CHANGE `CREATOR_ID_` `CREATOR_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者ID'; ALTER TABLE `bpm_task_follow` CHANGE `PRO_INST_` `PRO_INST_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例id'; ALTER TABLE `bpm_task_notice` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务名称'; ALTER TABLE `bpm_task_notice` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '待办事项标题'; ALTER TABLE `bpm_task_notice` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程实例ID'; ALTER TABLE `bpm_task_notice` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联的任务ID'; ALTER TABLE `bpm_task_notice` CHANGE `EXEC_ID_` `EXEC_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 节点执行ID'; ALTER TABLE `bpm_task_notice` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 任务节点ID'; ALTER TABLE `bpm_task_notice` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程定义ID'; ALTER TABLE `bpm_task_notice` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 流程业务主键'; ALTER TABLE `bpm_task_notice` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 流程名称'; ALTER TABLE `bpm_task_notice` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务所属人ID'; ALTER TABLE `bpm_task_notice` CHANGE `ASSIGNEE_ID_` `ASSIGNEE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务执行人ID'; ALTER TABLE `bpm_task_notice` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务状态'; ALTER TABLE `bpm_task_notice` CHANGE `PRIORITY_` `PRIORITY_` int(11) null DEFAULT null COMMENT '任务优先级'; ALTER TABLE `bpm_task_notice` CHANGE `SUSPEND_STATE_` `SUSPEND_STATE_` smallint(6) null DEFAULT '0' COMMENT '是否挂起(0正常,1挂起)'; ALTER TABLE `bpm_task_notice` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父任务ID'; ALTER TABLE `bpm_task_notice` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'bpmn实例ID'; ALTER TABLE `bpm_task_notice` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN定义ID'; ALTER TABLE `bpm_task_notice` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分类ID'; ALTER TABLE `bpm_task_notice` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机'; ALTER TABLE `bpm_task_notice` CHANGE `IS_DELE_` `IS_DELE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删，1已删除，0未删除'; ALTER TABLE `bpm_task_notice` CHANGE `IS_READ_` `IS_READ_` int(11) NOT NULL DEFAULT '0' COMMENT '传阅的任务是否已阅 0:待阅，1：已阅'; ALTER TABLE `bpm_task_notice` CHANGE `IS_REVOKE_` `IS_REVOKE_` int(11) NOT NULL DEFAULT '0' COMMENT '传阅的任务是否撤回 0:否，1：是'; ALTER TABLE `bpm_task_notice` CHANGE `PROP1_` `PROP1_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性1'; ALTER TABLE `bpm_task_notice` CHANGE `PROP2_` `PROP2_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性2'; ALTER TABLE `bpm_task_notice` CHANGE `PROP3_` `PROP3_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性3'; ALTER TABLE `bpm_task_notice` CHANGE `PROP4_` `PROP4_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性4'; ALTER TABLE `bpm_task_notice` CHANGE `PROP5_` `PROP5_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性5'; ALTER TABLE `bpm_task_notice` CHANGE `PROP6_` `PROP6_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性6'; ALTER TABLE `bpm_task_notice_done` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID'; ALTER TABLE `bpm_task_notice_done` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父流程实例ID'; ALTER TABLE `bpm_task_notice_done` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID'; ALTER TABLE `bpm_task_notice_done` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_task_notice_done` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key'; ALTER TABLE `bpm_task_notice_done` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称'; ALTER TABLE `bpm_task_notice_done` CHANGE `TOKEN_` `TOKEN_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务令牌'; ALTER TABLE `bpm_task_notice_done` CHANGE `QUALFIEDS_` `QUALFIEDS_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户ID串'; ALTER TABLE `bpm_task_notice_done` CHANGE `QUALFIED_NAMES_` `QUALFIED_NAMES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户名称串'; ALTER TABLE `bpm_task_notice_done` CHANGE `AUDITOR_` `AUDITOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID'; ALTER TABLE `bpm_task_notice_done` CHANGE `AUDITOR_NAME_` `AUDITOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人名'; ALTER TABLE `bpm_task_notice_done` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织ID'; ALTER TABLE `bpm_task_notice_done` CHANGE `ORG_PATH_` `ORG_PATH_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织全路径'; ALTER TABLE `bpm_task_notice_done` CHANGE `OPINION_` `OPINION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批意见'; ALTER TABLE `bpm_task_notice_done` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '知会任务已办状态'; ALTER TABLE `bpm_task_notice_done` CHANGE `FORM_DEF_ID_` `FORM_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单定义ID'; ALTER TABLE `bpm_task_notice_done` CHANGE `FORM_NAME_` `FORM_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单名'; ALTER TABLE `bpm_task_notice_done` CHANGE `DUR_MS_` `DUR_MS_` int(11) null DEFAULT null COMMENT '持续时间(ms)'; ALTER TABLE `bpm_task_notice_done` CHANGE `FILES_` `FILES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '附件'; ALTER TABLE `bpm_task_notice_done` CHANGE `INTERPOSE_` `INTERPOSE_` smallint(6) null DEFAULT null COMMENT '是否干预'; ALTER TABLE `bpm_task_notice_done` CHANGE `SUBJECT_` `SUBJECT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程标题'; ALTER TABLE `bpm_task_notice_done` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称'; ALTER TABLE `bpm_task_notice_done` CHANGE `BPM_TASK_NOTICE_ID_` `BPM_TASK_NOTICE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '知会待办主键ID'; ALTER TABLE `bpm_task_notice_done` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '是否支持手机0：不支持，1：支持'; ALTER TABLE `bpm_task_read` CHANGE `READ_ID_` `READ_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '主键'; ALTER TABLE `bpm_task_read` CHANGE `PROC_DEF_ID` `PROC_DEF_ID` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_task_read` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_task_read` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_task_read` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID'; ALTER TABLE `bpm_task_read` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户ID'; ALTER TABLE `bpm_task_read` CHANGE `USER_NAME_` `USER_NAME_` varchar(32) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户名'; ALTER TABLE `bpm_task_reminder` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办任务ID'; ALTER TABLE `bpm_task_reminder` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办名称'; ALTER TABLE `bpm_task_reminder` CHANGE `DUE_ACTION_` `DUE_ACTION_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '到期执行动作'; ALTER TABLE `bpm_task_reminder` CHANGE `DUE_SCRIPT_` `DUE_SCRIPT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用指定方法'; ALTER TABLE `bpm_task_reminder` CHANGE `IS_SEND_MSG_` `IS_SEND_MSG_` int(11) null DEFAULT null COMMENT '期间是否发送催办'; ALTER TABLE `bpm_task_reminder` CHANGE `MSG_INTERVAL_` `MSG_INTERVAL_` int(11) null DEFAULT null COMMENT '发送消息间隔'; ALTER TABLE `bpm_task_reminder` CHANGE `MSG_COUNT_` `MSG_COUNT_` int(11) null DEFAULT null COMMENT '发送次数'; ALTER TABLE `bpm_task_reminder` CHANGE `MSG_TYPE_` `MSG_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '消息类型 inner,msg,email 等'; ALTER TABLE `bpm_task_reminder` CHANGE `HTML_MSG_` `HTML_MSG_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '富文本'; ALTER TABLE `bpm_task_reminder` CHANGE `PLAIN_MSG_` `PLAIN_MSG_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '纯文本消息'; ALTER TABLE `bpm_task_reminder` CHANGE `WARNINGSET_` `WARNINGSET_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '预警配置（预警名称，triggerDate，change2level）'; ALTER TABLE `bpm_task_sign_line` CHANGE `INSTANCE_ID_` `INSTANCE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例'; ALTER TABLE `bpm_task_sign_line` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_task_sign_line` CHANGE `PATH_` `PATH_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '路径'; ALTER TABLE `bpm_task_sign_line` CHANGE `EXECUTOR_` `EXECUTOR_` varchar(2048) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人'; ALTER TABLE `bpm_task_sign_line` CHANGE `ACTION_` `ACTION_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '并行签署后的动作 submit提交 back返回 '; ALTER TABLE `bpm_task_sign_line` CHANGE `NODE_ID_` `NODE_ID_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点id'; ALTER TABLE `bpm_task_sign_sequence` CHANGE `INSTANCE_ID_` `INSTANCE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例'; ALTER TABLE `bpm_task_sign_sequence` CHANGE `NODE_ID_` `NODE_ID_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点key'; ALTER TABLE `bpm_task_sign_sequence` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_task_sign_sequence` CHANGE `NEXT_TASK_ID_` `NEXT_TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '下一任务ID'; ALTER TABLE `bpm_task_sign_sequence` CHANGE `PATH_` `PATH_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '路径'; ALTER TABLE `bpm_task_sign_sequence` CHANGE `SEQ_` `SEQ_` smallint(6) null DEFAULT null COMMENT '顺序'; ALTER TABLE `bpm_task_sign_sequence` CHANGE `EXECUTOR_` `EXECUTOR_` varchar(2048) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人'; ALTER TABLE `bpm_task_signdata` CHANGE `DEF_ID_` `DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_task_signdata` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_task_signdata` CHANGE `EXECUTE_ID_` `EXECUTE_ID_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'act运行实例Id'; ALTER TABLE `bpm_task_signdata` CHANGE `ACT_INST_ID_` `ACT_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'ACT流程实例ID'; ALTER TABLE `bpm_task_signdata` CHANGE `NODE_ID_` `NODE_ID_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID'; ALTER TABLE `bpm_task_signdata` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程任务ID'; ALTER TABLE `bpm_task_signdata` CHANGE `QUALIFIED_ID_` `QUALIFIED_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有资格审批的成员ID'; ALTER TABLE `bpm_task_signdata` CHANGE `QUALIFIED_NAME_` `QUALIFIED_NAME_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有资格审批的成员名称'; ALTER TABLE `bpm_task_signdata` CHANGE `VOTE_RESULT_` `VOTE_RESULT_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票结果(no 未投票 通过 agree,abandon 弃权,oppose 反对)'; ALTER TABLE `bpm_task_signdata` CHANGE `VOTE_ID_` `VOTE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票人'; ALTER TABLE `bpm_task_signdata` CHANGE `VOTER_` `VOTER_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票人'; ALTER TABLE `bpm_task_signdata` CHANGE `INDEX_` `INDEX_` int(11) null DEFAULT null COMMENT '投票次序'; ALTER TABLE `bpm_task_signdata` CHANGE `IS_ACTIVE_` `IS_ACTIVE_` int(11) null DEFAULT null COMMENT '是否活动'; ALTER TABLE `bpm_task_signdata` CHANGE `TYPE_` `TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID'; ALTER TABLE `bpm_task_trans` CHANGE `INSTANCE_ID_` `INSTANCE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例'; ALTER TABLE `bpm_task_trans` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID 流转任务ID'; ALTER TABLE `bpm_task_trans` CHANGE `ACTION_` `ACTION_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '完成后的操作'; ALTER TABLE `bpm_task_trans` CHANGE `CREATOR_` `CREATOR_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `bpm_task_trans` CHANGE `DECIDE_TYPE_` `DECIDE_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '决策类型 agree oppose'; ALTER TABLE `bpm_task_trans` CHANGE `VOTE_TYPE_` `VOTE_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票类型 amount percent'; ALTER TABLE `bpm_task_trans` CHANGE `VOTE_AMOUNT_` `VOTE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '票数'; ALTER TABLE `bpm_task_trans` CHANGE `SIGN_TYPE_` `SIGN_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会签类型 parallel,seq'; ALTER TABLE `bpm_task_trans` CHANGE `TOTAL_AMOUNT_` `TOTAL_AMOUNT_` smallint(6) null DEFAULT null COMMENT '总票数'; ALTER TABLE `bpm_task_trans` CHANGE `AGREE_AMOUNT_` `AGREE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '通过票数'; ALTER TABLE `bpm_task_trans` CHANGE `OPPOSE_AMOUNT_` `OPPOSE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '反对票数'; ALTER TABLE `bpm_task_trans` CHANGE `SEQ_` `SEQ_` smallint(6) null DEFAULT null COMMENT '投票次序'; ALTER TABLE `bpm_task_trans` CHANGE `USER_JSON_` `USER_JSON_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户数据'; ALTER TABLE `bpm_task_trans` CHANGE `ALLOW_FORM_EDIT_` `ALLOW_FORM_EDIT_` smallint(6) null DEFAULT null COMMENT '表单允许编辑'; ALTER TABLE `bpm_task_trans_record` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例'; ALTER TABLE `bpm_task_trans_record` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID 流转任务ID'; ALTER TABLE `bpm_task_trans_record` CHANGE `ACTION_` `ACTION_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '完成后的操作'; ALTER TABLE `bpm_task_trans_record` CHANGE `CREATOR_` `CREATOR_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人'; ALTER TABLE `bpm_task_trans_record` CHANGE `DECIDE_TYPE` `DECIDE_TYPE` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '决策类型 同意 agree 反对 oppose'; ALTER TABLE `bpm_task_trans_record` CHANGE `VOTE_TYPE_` `VOTE_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票类型'; ALTER TABLE `bpm_task_trans_record` CHANGE `VOTE_AMOUNT_` `VOTE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '票数'; ALTER TABLE `bpm_task_trans_record` CHANGE `SIGN_TYPE_` `SIGN_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会签类型'; ALTER TABLE `bpm_task_trans_record` CHANGE `TOTAL_AMOUNT_` `TOTAL_AMOUNT_` smallint(6) null DEFAULT null COMMENT '总票数'; ALTER TABLE `bpm_task_trans_record` CHANGE `AGREE_AMOUNT_` `AGREE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '通过票数'; ALTER TABLE `bpm_task_trans_record` CHANGE `OPPOSE_AMOUNT_` `OPPOSE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '反对票数'; ALTER TABLE `bpm_task_trans_record` CHANGE `TRANS_USERS_` `TRANS_USERS_` varchar(300) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转人员'; ALTER TABLE `bpm_task_trans_record` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称'; ALTER TABLE `bpm_task_trans_record` CHANGE `TASK_SUBJECT_` `TASK_SUBJECT_` varchar(300) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转任务标题'; ALTER TABLE `bpm_task_trans_record` CHANGE `STATUS_` `STATUS_` smallint(6) null DEFAULT null COMMENT '状态：0流转中 1流转结束 2已撤销'; ALTER TABLE `bpm_task_trans_record` CHANGE `TRANS_USER_IDS_` `TRANS_USER_IDS_` varchar(300) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转人员ids'; ALTER TABLE `bpm_task_trans_record` CHANGE `TRANS_OPINION_` `TRANS_OPINION_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转意见(原因)'; ALTER TABLE `bpm_task_trans_record` CHANGE `DEF_NAME_` `DEF_NAME_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程名称'; ALTER TABLE `bpm_task_trans_record` CHANGE `TRANS_OWNER_` `TRANS_OWNER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转任务所属人ID'; ALTER TABLE `bpm_task_turn` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务ID'; ALTER TABLE `bpm_task_turn` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务名称'; ALTER TABLE `bpm_task_turn` CHANGE `TASK_SUBJECT_` `TASK_SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '待办事项标题'; ALTER TABLE `bpm_task_turn` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 任务节点ID'; ALTER TABLE `bpm_task_turn` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程实例ID'; ALTER TABLE `bpm_task_turn` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务所属人ID'; ALTER TABLE `bpm_task_turn` CHANGE `OWNER_NAME_` `OWNER_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务所属人姓名'; ALTER TABLE `bpm_task_turn` CHANGE `ASSIGNEE_ID_` `ASSIGNEE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务执行人ID'; ALTER TABLE `bpm_task_turn` CHANGE `ASSIGNEE_NAME_` `ASSIGNEE_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务执行人姓名'; ALTER TABLE `bpm_task_turn` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '状态。running=正在运行；finish=完成；cancel=取消'; ALTER TABLE `bpm_task_turn` CHANGE `TURN_TYPE_` `TURN_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更改类型。agent=代理；shift=转办；copy_to=抄送'; ALTER TABLE `bpm_task_turn` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '所属分类ID'; ALTER TABLE `bpm_task_turnassign` CHANGE `TASK_TURN_ID_` `TASK_TURN_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '转交ID和task_turn表主键关联'; ALTER TABLE `bpm_task_turnassign` CHANGE `FROM_USER_ID_` `FROM_USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务转交人ID'; ALTER TABLE `bpm_task_turnassign` CHANGE `FROM_USER_` `FROM_USER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务转交人'; ALTER TABLE `bpm_task_turnassign` CHANGE `RECEIVER_ID_` `RECEIVER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人ID'; ALTER TABLE `bpm_task_turnassign` CHANGE `RECEIVER` `RECEIVER` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人'; ALTER TABLE `bpm_task_turnassign` CHANGE `COMMENT_` `COMMENT_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '备注'; ALTER TABLE `bpm_task_urgent` CHANGE `TASK_ID_` `TASK_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID'; ALTER TABLE `bpm_task_urgent` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称'; ALTER TABLE `bpm_task_urgent` CHANGE `INST_ID_` `INST_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID'; ALTER TABLE `bpm_task_urgent` CHANGE `SUBJECT_` `SUBJECT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程标题'; ALTER TABLE `bpm_task_urgent` CHANGE `CONTENT_` `CONTENT_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办内容'; ALTER TABLE `bpm_task_urgent` CHANGE `PROMOTER_ID_` `PROMOTER_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办人ID'; ALTER TABLE `bpm_task_urgent` CHANGE `PROMOTER_` `PROMOTER_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办人'; ALTER TABLE `bpm_task_urgent` CHANGE `APPOINTEE_ID_` `APPOINTEE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被催办人ID'; ALTER TABLE `bpm_task_urgent` CHANGE `APPOINTEE_` `APPOINTEE_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被催办人'; ALTER TABLE `bpm_task_urgent` CHANGE `TYPE_` `TYPE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办类型'; ALTER TABLE `bpm_task_urgent` CHANGE `APPOINTEE_SECRETARY_CONF_` `APPOINTEE_SECRETARY_CONF_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办的领导和秘书的id关系map，方便秘书回复时确定代哪个领导审批的'; ALTER TABLE `bpm_test_case` CHANGE `NAME_` `NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '测试用例名称'; ALTER TABLE `bpm_test_case` CHANGE `BO_FORM_DATA_` `BO_FORM_DATA_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单数据'; ALTER TABLE `bpm_test_case` CHANGE `FLOW_VARS_` `FLOW_VARS_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程变量'; ALTER TABLE `bpm_test_case` CHANGE `ACTION_TYPE_` `ACTION_TYPE_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批动作， 默认动作时 agree'; ALTER TABLE `bpm_test_case` CHANGE `STARTOR_` `STARTOR_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人json'; ALTER TABLE `bpm_test_case` CHANGE `BPM_DEBUGGER_` `BPM_DEBUGGER_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '断点测试设置'; ALTER TABLE `bpm_test_case` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义key'; ALTER TABLE `bpm_test_case` CHANGE `STARTOR_ACCOUNT_` `STARTOR_ACCOUNT_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人账号'; ALTER TABLE `bpm_test_case` CHANGE `STARTOR_FULL_NAME_` `STARTOR_FULL_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人姓名'; ALTER TABLE `bpm_trans_receiver` CHANGE `TRANS_RECORDID_` `TRANS_RECORDID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转任务记录ID'; ALTER TABLE `bpm_trans_receiver` CHANGE `RECEIVER_` `RECEIVER_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转接受人员'; ALTER TABLE `bpm_trans_receiver` CHANGE `RECEIVER_ID_` `RECEIVER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转接收人id'; ALTER TABLE `bpm_trans_receiver` CHANGE `STATUS_` `STATUS_` smallint(6) null DEFAULT null COMMENT '状态:0尚未处理1已处理'; ALTER TABLE `bpm_trans_receiver` CHANGE `OPINION_` `OPINION_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审核意见'; ALTER TABLE `bpm_trans_receiver` CHANGE `CHECK_TYPE_` `CHECK_TYPE_` smallint(6) null DEFAULT null COMMENT '审核状态'; ALTER TABLE `bpm_trans_record` CHANGE `TYPE_` `TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交类型'; ALTER TABLE `bpm_trans_record` CHANGE `TRANSFER_` `TRANSFER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交人ID'; ALTER TABLE `bpm_trans_record` CHANGE `TRANSFER_NAME_` `TRANSFER_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交人姓名'; ALTER TABLE `bpm_trans_record` CHANGE `TRANSFERED_NAME_` `TRANSFERED_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被移交人姓名'; ALTER TABLE `bpm_trans_record` CHANGE `REASON_` `REASON_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交原因'; ALTER TABLE `bpm_trans_record` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID'; ALTER TABLE `bpm_trans_record` CHANGE `RESULT_` `RESULT_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交结果'; ALTER TABLE `bpm_trans_record` CHANGE `VAR_` `VAR_` int(11) null DEFAULT null COMMENT '移交方式'; ALTER TABLE `bpm_trans_record` CHANGE `PROC_INST_IDS_` `PROC_INST_IDS_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';