删除Flowable所有的表

-- 删除所有run开头的表
delete from act_ru_timer_job  where 1=1;
delete from  act_ru_job  where 1=1;
delete from  act_ru_identitylink  where 1=1;
delete from  act_ru_deadletter_job  where 1=1;
delete from  act_ru_event_subscr  where 1=1;
delete from  act_ru_suspended_job  where 1=1;
delete from  act_ru_history_job  where 1=1;
delete from  act_ru_actinst  where 1=1;
delete from  act_ru_variable  where 1=1;
delete from   act_ru_task where 1=1;
delete from  act_ru_execution where 1=1;
-- 删除所有his开头的表
delete from  act_hi_actinst where 1=1;
delete from  act_hi_attachment where 1=1;
delete from  act_hi_comment where 1=1;
delete from  act_hi_detail where 1=1;
delete from  act_hi_entitylink where 1=1;
delete from  act_hi_identitylink where 1=1;
delete from  act_hi_procinst where 1=1;
delete from  act_hi_taskinst where 1=1;
delete from  act_hi_tsk_log where 1=1;
delete from  act_hi_varinst where 1=1;
-- 删除所有app开头的表
delete from act_app_appdef where 1=1;
delete from  act_app_deployment_resource where 1=1;
delete from  act_app_deployment where 1=1;
-- 删除所有from开头的表
delete from  act_fo_form_definition where 1=1;
delete from  act_fo_form_deployment where 1=1;
delete from  act_fo_form_instance where 1=1;
delete from  act_fo_form_resource where 1=1;
-- 删除所有de开头的表
delete from  act_de_model_history where 1=1;
delete from  act_de_model_relation where 1=1;
delete from  act_de_model where 1=1;
-- 删除所有ge开头的表 (应该是设计流程图对应的内容)
delete from  act_ge_bytearray where 1=1;
delete from  act_ge_property where 1=1;
-- 删除所有re开头的表(实际部署的)
delete from  act_re_deployment where 1=1;
delete from  act_re_model where 1=1;
delete from  act_re_procdef where 1=1;
-- 删除所有event的表
delete from flw_channel_definition where 1=1;
delete from  flw_event_definition where 1=1;
delete from  flw_event_deployment where 1=1;
delete from  flw_event_resource where 1=1;
-- 删除所有co开头的表
delete from  act_co_content_item where 1=1;

act_ge_property表谨慎删除,否则会导致一下错误

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is java.lang.NullPointerException
dflow-all_1              | 	at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:176) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1884) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1284) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:345) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1380) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1300) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-5.3.12.jar:5.3.12]
dflow-all_1              | 	... 47 common frames omitted
dflow-all_1              | Caused by: java.lang.NullPointerException: null
dflow-all_1              | 	at org.flowable.engine.impl.db.ProcessDbSchemaManager.schemaUpdate(ProcessDbSchemaManager.java:232) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:54) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:28) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:67) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:140) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:114) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:72) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.interceptor.BpmnOverrideContextInterceptor.execute(BpmnOverrideContextInterceptor.java:26) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:105) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:57) ~[flowable-spring-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.12.jar:5.3.12]
dflow-all_1              | 	at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:57) ~[flowable-spring-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:83) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:914) ~[flowable-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:76) ~[flowable-spring-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator.initProcessEngine(SpringProcessEngineConfigurator.java:58) ~[flowable-spring-configurator-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator.configure(SpringProcessEngineConfigurator.java:47) ~[flowable-spring-configurator-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1109) ~[flowable-engine-common-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.app.engine.AppEngineConfiguration.init(AppEngineConfiguration.java:237) ~[flowable-app-engine-6.7.1.1.jar:6.7.1.1]
dflow-all_1              | 	at org.flowable.app.engine.AppEngineConfiguration.buildAppEngine(AppEngineConfiguration.java:193) ~[flowable-app-engine-6.7.1.1.jar:6.7.1.
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值