# Spring boot starter drops existing app schema

**URL:** https://forum.flowable.org/t/spring-boot-starter-drops-existing-app-schema/4239
**Category:** Flowable Engine
**Created:** [July 24, 2019, 11:36pm UTC](https://forum.flowable.org/t/spring-boot-starter-drops-existing-app-schema/4239 "2019-07-24T23:36:37Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![dbouvier](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@dbouvier](https://forum.flowable.org/u/dbouvier)
#### Post date: [July 24, 2019, 11:36pm UTC](https://forum.flowable.org/t/spring-boot-starter-drops-existing-app-schema/4239/1 "2019-07-24T23:36:37Z")

</div>

I have a Spring Boot 2 app using Liquibase with an existing DB schema and I am starting to integrate the Flowable engine into the app to manage workflows. After adding flowable-spring-boot-starter to the POM file, the app reports that the app schema has been dropped when trying to run unit tests that depend on the app schema.

How can I configure the flowable database initialization to not drop all tables, but only tables that it has control over? Also, when will the flowable engine start using Liquibase to manage the DB migrations?

Thanks,  
Dave

---

<div class="post-metadata">

### Author: ![chakra](https://avatars.discourse-cdn.com/v4/letter/c/db5fbb/32.png) [@chakra](https://forum.flowable.org/u/chakra)
#### Post date: [July 28, 2019, 7:55am UTC](https://forum.flowable.org/t/spring-boot-starter-drops-existing-app-schema/4239/2 "2019-07-28T07:55:32Z")

</div>

Please share application property files.

---

<div class="post-metadata">

### Author: ![dbouvier](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@dbouvier](https://forum.flowable.org/u/dbouvier)
#### Post date: [July 29, 2019, 3:45pm UTC](https://forum.flowable.org/t/spring-boot-starter-drops-existing-app-schema/4239/3 "2019-07-29T15:45:23Z")

</div>

There are no application properties since it is a Spring Boot 2 app. I’ve tried all possible values for database-schema-update: create-drop, drop-create, true, false in the application yml file and the existing schema is always dropped when our app unit tests start to run. The property setting is being noted by Flowable since I can see it in the debug output stream.

Looking at the Flowable 6.5.0-SNAPSHOT source (liquibase.dropAll() - LiquibaseBasedSchemaManager:90), it appears that all tables are dropped, not just the ACT\_\* tables. If this is the case, it is a serious design flaw. Only the ACT\_\* tables should be dropped!

---

<div class="post-metadata">

### Author: ![dbouvier](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@dbouvier](https://forum.flowable.org/u/dbouvier)
#### Post date: [July 30, 2019, 8:12pm UTC](https://forum.flowable.org/t/spring-boot-starter-drops-existing-app-schema/4239/4 "2019-07-30T20:12:09Z")

</div>

OK, I found the solution. The property spring.liquibase.enabled must be set to true in the app and test yml files.
