#Flyway Migrations

Firmiana uses Flyway for versioned schema management. There are 23 migrations (V1–V23).

#Migration History

#Migration Naming

Migrations follow the Flyway convention: V{version}__{description}.sql

Double underscore (__) separates the version from the description.

#Adding New Migrations

Create a new SQL file in src/main/resources/db/migration/:

V24__description.sql

The file should contain only DDL statements (CREATE TABLE, ALTER TABLE, CREATE INDEX).

#Baseline Migration

The baseline schema (V1) creates the core tables:

• users, user_passwords, user_access_tokens, user_refresh_tokens
• rooms, room_user, room_aliases
• event, event_relations
• forward_extremity, room_state_group
• device_inbox, device_list_stream
• typing_user, presence_stream, receipt, room_receipt
• media_metadata, media_auth_token
• user_push_rules, user_pushers
• notification, event_push_summary

#Database Reset

To reset the database:

rm -rf data/matrix*
mvn exec:java

Flyway will re-run all migrations from scratch.