Can someone check the changes made in the migration file? I removed unused columns, added indices to all tables with references, and changed the data type of comments and description fields. Are there any other indices to add (like two-column indices) and are there any other columns that should be marked unique (email)?
Note: SQLite lacks the ability to remove columns. Developers will need to recreate the database or remove entries referencing the customer table for the migration to succeed.
The database can be regenerated by running:
$ rails db:drop
$ rails db:migrate
Make sure to delete any files uploaded into storage.
Closes #6
Can someone check the changes made in the migration file? I removed unused columns, added indices to all tables with references, and changed the data type of comments and description fields. Are there any other indices to add (like two-column indices) and are there any other columns that should be marked unique (email)?
Note: SQLite lacks the ability to remove columns. Developers will need to recreate the database or remove entries referencing the customer table for the migration to succeed.
The database can be regenerated by running:
Make sure to delete any files uploaded into storage.