WIP: Update Ask123321
Add a description of your merge request here.
Database checklist
- $1890744 99999] Conforms to the database guides
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
, andJOIN
s
When removing columns, tables, indexes or other structures: