Migrations

schema.sql is for a new empty database. Existing installations should apply only the migration required by the feature, in dependency order, after a database backup.

Current migration files include channels, roles/custom roles, message editing, friends, conversations, attachments, reports, replies, reactions, email verification, and account administration. Treat each migration as a one-time upgrade and verify its assumptions against the installed schema.