From ce68cc32e95a875ee5af40c429c9bbe191997394 Mon Sep 17 00:00:00 2001 From: Kevin J Hoerr Date: Fri, 31 Aug 2018 00:54:19 -0400 Subject: Modify migration files to work seamlessly; update README.md --- migrations/00000000000000_diesel_initial_setup/down.sql | 15 +++++++-------- migrations/00000000000000_diesel_initial_setup/up.sql | 2 +- 2 files changed, 8 insertions(+), 9 deletions(-) (limited to 'migrations') 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(), -- cgit