activiti表名统一修改为小写
activiti表名统一修改为小写
activiti 自动新建的表默认是大写的,但是我们数据库定义的规则是表名得小写。所以就得手动的把他改为小写,(activiti 暂时好像还不支持通过配置参数实现表名大小写)
下面我通过查询本数据库中带有act 前缀的表 并通过 CONCAT 函数来拼接,修改表名的sql
SELECT CONCAT('ALTER TABLE ',table_name , ' RENAME ',LOWER(table_name),";" ) AS statement FROM information_schema.tables
WHERE table_schema = 'xxx' AND
table_name LIKE 'ACT%';
CONCAT将两个或者是多个字符串拼接在一起
LOWER: 转换为小写
table_schema = ‘xxx’ 指定库名,避免不必要的问题
table_name LIKE ‘ACT%’ 已ACT 开头的表
ALTER TABLE ACT_GE_BYTEARRAY RENAME act_ge_bytearray;
ALTER TABLE ACT_GE_PROPERTY RENAME act_ge_property;
ALTER TABLE ACT_HI_ACTINST RENAME act_hi_actinst;
ALTER TABLE ACT_HI_ATTACHMENT RENAME act_hi_attachment;
ALTER TABLE ACT_HI_COMMENT RENAME act_hi_comment;
ALTER TABLE ACT_HI_DETAIL RENAME act_hi_detail;
ALTER TABLE ACT_HI_IDENTITYLINK RENAME act_hi_identitylink;
ALTER TABLE ACT_HI_PROCINST RENAME act_hi_procinst;
ALTER TABLE ACT_HI_TASKINST RENAME act_hi_taskinst;
ALTER TABLE ACT_HI_VARINST RENAME act_hi_varinst;
ALTER TABLE ACT_PROCDEF_INFO RENAME act_procdef_info;
ALTER TABLE ACT_RE_DEPLOYMENT RENAME act_re_deployment;
ALTER TABLE ACT_RE_MODEL RENAME act_re_model;
ALTER TABLE ACT_RE_PROCDEF RENAME act_re_procdef;
ALTER TABLE ACT_RU_DEADLETTER_JOB RENAME act_ru_deadletter_job;
ALTER TABLE ACT_RU_EVENT_SUBSCR RENAME act_ru_event_subscr;
ALTER TABLE ACT_RU_EXECUTION RENAME act_ru_execution;
ALTER TABLE ACT_RU_IDENTITYLINK RENAME act_ru_identitylink;
ALTER TABLE ACT_RU_INTEGRATION RENAME act_ru_integration;
ALTER TABLE ACT_RU_JOB RENAME act_ru_job;
ALTER TABLE ACT_RU_SUSPENDED_JOB RENAME act_ru_suspended_job;
ALTER TABLE ACT_RU_TASK RENAME act_ru_task;
ALTER TABLE ACT_RU_TIMER_JOB RENAME act_ru_timer_job;
ALTER TABLE ACT_RU_VARIABLE RENAME act_ru_variable;
这就是最后拼接的sql,拷贝出来,在执行下,问题解决!!!