Consolidate DB migrations into one new migration about roadmap

[briri]

I still think we should do this just to clean up the migrations directory. A user cannot run rake db:migrate from a clean installation without encountering errors. It should be fairly easy to convert the the current schema.rb over to a migration file. @jollopre @vyruss and @xsrust what do you think?

[briri]

Started working on this but it makes sense to wait until after the DB refactor. Work was done in a branch on CDLUC3/roadmap

[Yu-Chieh-Henry-Yang]

I'm doing a project that use DMP Roadmap and we need to have database pass migration before going to production. Does anyone have an estimate about when the database consolidation this ticket mention will be finished?

Also, I provide a possible temporary workaround here: #1774 but I'm not sure if it breaks anything

@briri

[Bodacious]

@briri @xsrust @Yu-Chieh-Henry-Yang This should not be necessary. The schema file (db/schema.rb) is a single migration that reflects the current DB structure. Creating a new, single migration would simply be a duplicate of the schema file.

The following rake tasks should be useful for almost all of the issues devs are likely to come across:

rake db:migrate should only be necessary when you have an existing DB that has fallen behind the schema at HEAD. If there are issues preventing those migrations from running, these should be added as issues with the bug label.

rake db:reset          # Drop DB, create DB again, and load the schema to the current version
rake db:schema:load    # Load a schema.rb file into the database
rake db:create         # Creates the database from DATABASE_URL or config/database.yml for the current RAILS_ENV 
rake db:seed           # Load the seed data from db/seeds.rb (ONLY FOR DEVELOPMENT)
rake db:setup          # Create the database, load the schema, and initialize with the seed data (use db:reset to also drop the database first)
rake db:drop           # Drops the database from DATABASE_URL or config/database.yml for the current RAILS_ENV (use db:drop:all to drop all databases in the ...
rake db:migrate:status # Display status of migrations
rake db:rollback       # Rolls the schema back to the previous version (specify steps w/ STEP=n)