diff options
| author | Kevin J Hoerr <kjhoerr@protonmail.com> | 2018-08-31 00:54:19 -0400 |
|---|---|---|
| committer | Kevin Hoerr <kjhoerr@submelon.tech> | 2018-08-31 23:24:45 -0400 |
| commit | ce68cc32e95a875ee5af40c429c9bbe191997394 (patch) | |
| tree | bd958d3fb44cd4cc29c7f2a57f0f4390d716eee8 /migrations | |
| parent | 2463916a5c3f25f3d584aacb8b40130c13619ba1 (diff) | |
| download | august-offensive-ce68cc32e95a875ee5af40c429c9bbe191997394.tar.gz august-offensive-ce68cc32e95a875ee5af40c429c9bbe191997394.tar.bz2 august-offensive-ce68cc32e95a875ee5af40c429c9bbe191997394.zip | |
Modify migration files to work seamlessly; update README.md
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/00000000000000_diesel_initial_setup/down.sql | 15 | ||||
| -rw-r--r-- | migrations/00000000000000_diesel_initial_setup/up.sql | 2 |
2 files changed, 8 insertions, 9 deletions
diff --git a/migrations/00000000000000_diesel_initial_setup/down.sql b/migrations/00000000000000_diesel_initial_setup/down.sql index 74a7b3d..25f4412 100644 --- a/migrations/00000000000000_diesel_initial_setup/down.sql +++ b/migrations/00000000000000_diesel_initial_setup/down.sql @@ -1,11 +1,10 @@ -- down.sql: Destroy initial database migration for AO -DROP FUNCTION IF EXISTS public.GETDATE(); -DROP TABLE users; -DROP TABLE activation_keys; -DROP TABLE games; -DROP TABLE allegiances; -DROP TABLE regions; -DROP TABLE nationstates; +DROP TABLE games_nationstates; DROP TABLE borders; -DROP TABLE games_nationstates;
\ No newline at end of file +DROP TABLE nationstates; +DROP TABLE regions; +DROP TABLE allegiances; +DROP TABLE games; +DROP TABLE activation_keys; +DROP TABLE users;
\ No newline at end of file diff --git a/migrations/00000000000000_diesel_initial_setup/up.sql b/migrations/00000000000000_diesel_initial_setup/up.sql index 83a7869..2140a57 100644 --- a/migrations/00000000000000_diesel_initial_setup/up.sql +++ b/migrations/00000000000000_diesel_initial_setup/up.sql @@ -28,7 +28,7 @@ CREATE TABLE activation_keys ( CREATE TABLE games ( gameid SERIAL, title VARCHAR(140) NOT NULL, - gametypeid SERIAL NOT NULL, -- future proofing: suppose different game types + gametypeid SERIAL NOT NULL, -- future proofing: suppose different game types players SMALLINT NOT NULL, -- number of players in a game waitfor INTEGER NOT NULL, -- time in seconds to wait for player to complete a turn lastturn DATE DEFAULT GETDATE(), |