**Confirm new schema works**
1. Observe the current SQLite threads schema
{F448100}
2. Delete the app and re-install from XCode
3. Run the app and check the new schema for `threads`
{F448096}
**Confirm migration for new clients works**
1. Build the app while checked out on `master`
2. Add the migration
3. Rebuild the app
4. Confirm that the migration is successful and the new db version is 26
**Confirm migration for new clients already with the column works**
It looks like SQLite doesn't support `ALTER TABLE ... ADD COLUMN IF NOT EXISTS ...`, so the alternative proposed by Kamil is to use `PRAGMA table_info()`. This is to help the case where the client has the column already (i.e. my own machine), so the migration should not fail.
1. Delete the app
2. Add the schema changes
3. Install the app (so the db is constructed from the schema)
4. Add the migration
5. Rebuild the app
6. Confirm that no error for 'duplicate column' is thrown since we detected the column before adding it
I'm not entirely sure if we really even need to consider a case where a new client will already have the column besides me in development work, so I can also just remove that check entirely and just add the column