bhits/vss

Where are table creation scripts?

Opened this issue · 1 comments

I checked in all paths, but there's no presence of scripts to create the tables where the data can be inserted.
Please look into it and advose

Hi @vishforyou,

We consistently use Flyway across the microservices for database migration. Once you create the schema and start up the application with correct database connection configuration, the microservice should create the tables for the very first time. If you try to manually create the tables, Flyway would probably error out due to some missing migration related tables and hash values. In each service, you can find the Flyway migration scripts at src/main/resources/db/migration

e.g. https://github.com/bhits/vss/tree/master/vss/src/main/resources/db/migration