Add a database migration system

[xDefcon]

Description

Currently, the app lacks a proper migration system, which I believe is a crucial feature at this stage of development. Implementing structured migrations would help manage schema changes more effectively, prevent issues as the database evolves with new features, and make upgrades more reliable and trackable.

Proposed Solution

• Add a migration manager.
• Use separate files for each migration (e.g., versioned scripts).
• Support upgrades and rollbacks (where needed).

Next Steps

I’m working on a PR to implement this. Would appreciate your support and feedback!

[xDefcon]

Can anyone assign this issue to me and label it accordingly?

[theperu]

@xDefcon if you have any update during your work you can post it here and you can tag @mikev-cw which has done most of the work for the DB