at the root of the repository (outside of source) create a db folder with the following files
Anyone who desires to contribute to this project should be able to check out and run the schema.sql and data.sql and have all the necessary database objects created. The scripts should be non-destructive and twice run safe. For any update to schema or data users should be able to run these scripts at any time to get updates.
- IF NOT EXISTS: create database
- IF NOT EXISTS: create schema
- IF NOT EXISTS: insert resource data
at the root of the repository (outside of source) create a db folder with the following files
Anyone who desires to contribute to this project should be able to check out and run the schema.sql and data.sql and have all the necessary database objects created. The scripts should be non-destructive and twice run safe. For any update to schema or data users should be able to run these scripts at any time to get updates.