Skip to content

WIP: Update Ask123321

## What does this MR do?

Add a description of your merge request here.

Database checklist

When adding migrations:

  • [ &2033 ] Updated db/schema.rb
  • [ $1867949 ] Added a down method so the migration can be reverted
  • [ &2034 ] Added the output of the migration(s) to the MR body
  • [&2036 ] Added tests for the migration in spec/migrations if necessary (e.g. when migrating data)
  • [&2037 ] Added rollback procedure. Include either a rollback procedure or description how to rollback changes

When adding or modifying queries to improve performance:

  • [&2035 ] Included data that shows the performance improvement, preferably in the form of a benchmark
  • [$1890744 ] Included the output of EXPLAIN (ANALYZE, BUFFERS) of the relevant queries

When adding foreign keys to existing tables:

  • [&2033 ] Included a migration to remove orphaned rows in the source table before adding the foreign key
  • [$1871887 ] Removed any instances of dependent: ... that may no longer be necessary

When adding tables:

  • [ &2036 ] Ordered columns based on the Ordering Table Columns guidelines
  • [&2036 ] Added foreign keys to any columns pointing to data in other tables
  • [$1870945 ] Added indexes for fields that are used in statements such as WHERE, ORDER BY, GROUP BY, and JOINs

When removing columns, tables, indexes or other structures:

  • [$1890744 ] Removed these in a post-deployment migration
  • [ $1869848 ] Made sure the application no longer uses (or ignores) these structures

Merge request reports