vash3g / usgo-sql-schemas Goto Github PK

Schema's for the USGO Databases

1. When we need to do a schema change, write a sql file that produces the changes we want.
2. Put that in an updates directory, prefixed with the date. e.g. 20201005-drop-all-tables.sql
3. Spin up a test database with the current schema.sql loaded in, and run the update file against it.
4. Dump that database schema back into schema.sql.

• Current master schema.sql is based off legacy/usgo-agagd-scheme-no-zero-dates-20200913.sql. The prod will continue to use zero dates which will be removed later.