diff options
Diffstat (limited to 'migrations/00000000000000_diesel_initial_setup')
| -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(), |