topic Liquibase create unexpected tables in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/liquibase-create-unexpected-tables/m-p/36403#M15368 <HTML><HEAD></HEAD><BODY><P style="color: #727174; background-color: #ffffff; border: 0px;">When I use DbSchemaCreate to init database, the tables are:<BR />act_evt_log&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_ge_bytearray&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_ge_property&nbsp; &nbsp; &nbsp; &nbsp;act_hi_actinst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; act_hi_attachment<BR />act_hi_comment&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;act_hi_detail&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; act_hi_identitylink&nbsp; &nbsp; act_hi_procinst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;act_hi_taskinst</P><P style="color: #727174; background-color: #ffffff; border: 0px;">act_hi_varinst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_id_group&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;act_id_info&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_id_membership&nbsp;&nbsp;&nbsp;act_id_user<BR />act_procdef_info&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; act_re_deployment&nbsp;&nbsp;&nbsp;&nbsp;act_re_model&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; act_re_procdef&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;act_ru_deadletter_job<BR />act_ru_event_subscr&nbsp;&nbsp;&nbsp;act_ru_execution&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; act_ru_identitylink&nbsp;&nbsp;&nbsp;&nbsp;act_ru_job&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; act_ru_suspended_job<BR />act_ru_task&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_ru_timer_job&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; act_ru_variable</P><P style="color: #727174; background-color: #ffffff; border: 0px;">total 28 tables</P><P style="color: #727174; background-color: #ffffff; border: 0px;">&nbsp;</P><P style="color: #727174; background-color: #ffffff; border: 0px;">But when I start my web app, Liquibase create another unexpected tables in the process of ProcessEngine initialization.</P><P style="color: #727174; background-color: #ffffff; border: 0px;">Even though&nbsp;I set "databaseSchemaUpdate" to false or limit the table creation privilege of mysql user.</P><P style="color: #727174; background-color: #ffffff; border: 0px;">&nbsp;</P><P style="color: #727174; background-color: #ffffff; border: 0px;">act_de_databasechangelog&nbsp;&nbsp;&nbsp;act_de_databasechangeloglock&nbsp;&nbsp;&nbsp;act_de_model&nbsp;&nbsp;&nbsp;act_de_model_history&nbsp;</P><P style="color: #727174; background-color: #ffffff; border: 0px;">act_de_model_relation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_dmn_databasechangelog&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_dmn_databasechangeloglock&nbsp;&nbsp;&nbsp;act_dmn_decision_table<BR />act_dmn_deployment&nbsp;&nbsp;&nbsp;act_dmn_deployment_resource&nbsp;&nbsp;&nbsp;act_fo_databasechangelog&nbsp;&nbsp; act_fo_databasechangeloglock</P><P style="color: #727174; background-color: #ffffff; border: 0px;">act_fo_form_definition&nbsp;&nbsp;&nbsp;act_fo_form_deployment&nbsp;&nbsp;&nbsp;act_fo_form_resource&nbsp;&nbsp;&nbsp;act_fo_submitted_form</P><P style="color: #727174; background-color: #ffffff; border: 0px;">act_idm_persistent_token&nbsp;&nbsp;act_wo_comments&nbsp;&nbsp;&nbsp;act_wo_related_content&nbsp;&nbsp;&nbsp;hibernate_sequences</P><P style="color: #727174; background-color: #ffffff; border: 0px;">another 20 tables</P><P style="color: #727174; background-color: #ffffff; border: 0px;">&nbsp;</P><P style="color: #727174; background-color: #ffffff; border: 0px;">environments</P><P style="color: #727174; background-color: #ffffff; border: 0px;">activiti version: 6.0.0</P><P style="color: #727174; background-color: #ffffff; border: 0px;">database: mysql 5.5.49</P></BODY></HTML> Thu, 25 Jan 2018 07:35:14 GMT liuxy 2018-01-25T07:35:14Z Liquibase create unexpected tables https://connect.hyland.com/t5/alfresco-forum/liquibase-create-unexpected-tables/m-p/36403#M15368 When I use DbSchemaCreate to init database, the tables are:act_evt_log&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_ge_bytearray&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;act_ge_property&nbsp; &nbsp; &nbsp; &nbsp;act_hi_actinst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; act_hi_attachmentact_hi_comment&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;act_hi_detail&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; act_hi_identitylink&nbsp; &nbsp; act_hi_procinst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;act_hi_taskinstact_hi_va Thu, 25 Jan 2018 07:35:14 GMT https://connect.hyland.com/t5/alfresco-forum/liquibase-create-unexpected-tables/m-p/36403#M15368 liuxy 2018-01-25T07:35:14Z Re: Liquibase create unexpected tables https://connect.hyland.com/t5/alfresco-forum/liquibase-create-unexpected-tables/m-p/36404#M15369 <HTML><HEAD></HEAD><BODY><P>I found the reason. I put activiti-app in the same tomcat. When I start my tomcat, activiti-app will init ActivitiEngineImpl, ActivitiFormEngineImpl and ActivitiDmnEngineImpl.</P></BODY></HTML> Thu, 25 Jan 2018 08:14:15 GMT https://connect.hyland.com/t5/alfresco-forum/liquibase-create-unexpected-tables/m-p/36404#M15369 liuxy 2018-01-25T08:14:15Z