Currently we have Liquibase running db setup for CPS and NCMP with many steps.

Clean up unneeded liquibase steps.

Condense the steps and separate out the NCMP steps so that they can be run by a model loader instead.

---------

Initial research from Luke: https://wiki.onap.org/display/DW/CPS-1886+Spike+Liquibase+Steps+Condensing

Prerequisite:

• Step through liquibase steps

• Check if can be removed (compare with integration tests)

• Check if NCMP to be seperated

• Check if data (model) update or db update

How?

• Remove redundant data steps

• Merge subsequent (post table creation) yaml files (2-21) into createCPSTables yaml file.

• Load initial data required through the model loader

• Test schemas create successfully.

Liquibase steps:

In Scope 1 - 21

Keep step 22 as a separate Liquibase step

A/C

1. Database Schemas should set up as before

2. The redundant data should be removed

3. Demo to internal team and stakeholders