Define Database Migration Concept

Branch: feature/db-migrations

Goal: Establish a structured and versioned database migration and seeding system for MariaDB 10.

Deliverables:

• Create folder structure:
  • /database/migrations/
  • /database/seeders/
• Define naming convention: YYYYMMDDHHMMSS__short_name.sql
• Create a migration registry table (migrations) with:
  • id, version, checksum, applied_at -Include checksum validation and execution locking
• Write documentation file docs/migrations.md explaining workflow, rollback, and naming rules

Acceptance Criteria:

• Running migrate up creates the schema successfully in Docker.
• Migration history is tracked and listed via status.
• Seed can populate the database idempotently