Skip to content

Schema's for some of the USGO Databases

Notifications You must be signed in to change notification settings

usgo/usgo-sql-schemas

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

38 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Short Description

Schema's for the USGO Databases

AGAGD Schemas

Description File(s)
AGAGD master schema with zero dates removed schema.sql

AGAGD Legacy Schemas

Description File(s)
AGAGD schema create statements legacy/usgo-agagd-scheme-20200913.sql
AGAGD schema with zero dates removed legacy/usgo-agagd-scheme-no-zero-dates-20200913.sql

AGAGD Updates

Description Files(s) Updated on schema.sql Updated on Prodution Updated on Test
AGAGD update for the ratings table 20201009_update_ratings_table.sql 2020-10-09 2020-10-27 2020-10-12
AGAGD update for the members_view 20201025_replace_member_view.sql 2020-10-25 2020-11-14 2020-11-14
MM Update for Chapters Table 20210431_add_chapter_columns.sql 2021-04-28

Method

Provided by Anna Wiggins via Slack

  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.

Notes

  • 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.

About

Schema's for some of the USGO Databases

Resources

Stars

Watchers

Forks