AnsweredAssumed Answered

Lower in upper case mix in the table names

Question asked by pkokorev on Apr 28, 2013
Latest reply on Apr 29, 2013 by trademak
Hello,
I ran into an issue while migrating my Activiti MySQL database from Windows to Linux server. Actually, the problem was in the case of the table names, that is ignored under Windows and is taken into account on Linux. I added the "lower_case_table_names=1" option to my Windows MySQL server configuration and regenerated the tables. Now I have both uppercase and lowercase table names in the schema. It seems to work now on both operation systems, but this mix of cases looks a bit suspicious to me. Is it normal to have such a structure? Did anyone already notice something similar when running Activiti with MySQL?
Activiti version : 5.12.1
MySQL version : 5.1.65
Show tables :

ACT_GE_BYTEARRAY
ACT_GE_PROPERTY
ACT_HI_ATTACHMENT
ACT_HI_COMMENT
ACT_HI_TASKINST
ACT_ID_GROUP
ACT_ID_INFO
ACT_ID_MEMBERSHIP
ACT_ID_USER
ACT_RE_DEPLOYMENT
ACT_RE_MODEL
ACT_RE_PROCDEF
ACT_RU_EVENT_SUBSCR
ACT_RU_EXECUTION
ACT_RU_IDENTITYLINK
ACT_RU_JOB
ACT_RU_TASK
ACT_RU_VARIABLE
act_hi_actinst
act_hi_detail
act_hi_procinst
act_hi_varinst

Outcomes