Describe the enhancement
After PR #804 introduced SQLite into Floresta, the schema is currently created via static DDL. Replace that with a versioned migrations system so schema changes are applied incrementally and safely instead of requiring destructive changes / hardforks.
Use case
- Evolve tables (add/remove columns) without breaking existing installations.
- Automatically apply only pending migrations on startup or via a controlled migration step.
- Make schema changes auditable and reversible.
Additional context
Recommend using refinery for migrations: https://docs.rs/refinery/latest/refinery/
Describe the enhancement
After PR #804 introduced SQLite into Floresta, the schema is currently created via static DDL. Replace that with a versioned migrations system so schema changes are applied incrementally and safely instead of requiring destructive changes / hardforks.
Use case
Additional context
Recommend using refinery for migrations: https://docs.rs/refinery/latest/refinery/