Schema

The fresh schema in schema.sql stores users, profiles, email tokens, warnings, reports, servers, members, roles, channels, invites, server messages, friendships, conversations, conversation messages, attachments, and reactions.

Foreign keys enforce ownership and membership relationships. Most identifiers are CHAR(36) UUID strings. Message and membership tables include indexes for their common lookup paths, while unique keys prevent duplicate usernames, server channel names, and per-user/per-message reactions.

Review the SQL file itself for exact column types, defaults, collations, and constraints before changing a migration.