Update Feature: Database Migration

[YaWK]

To make sure, the database is also updated to the latest version, db migration methods will be integrated.

[YaWK]

Added Transaction & Rollback - this version includes the following changes:

• Added a $db->begin_transaction() call before the migration SQL is executed.
• Added a $db->commit() call if the migration is successful.
• Added a $db->rollback() call if there is an error in executing the migration SQL or recording the migration in the migrations table.

These changes ensure that the migration is executed atomically, so that either all of the changes in the migration SQL are made or none of them are applied. ("all or nothing")

[YaWK]

Efficient Migration Process implemented: When a migration is necessary for a particular version, the update servers will supply the required files.

Each successful database migration to a new update version will be logged in the migrations table. Only migrations not present in this table will be processed.

If an admin missed several updates and there is a significant difference in version numbers, the update process will scan each intermediate version to determine if a migration is required. If so, the migration file will be downloaded and installed sequentially.

Further enhancements will be implemented based on feedback and requirements identified during the testing phase.