feat: add schema versioning table and improve migration logic ...

- Introduced 'internal_metadata' table to track database version.
- Updated migrate_025_to_030 to use 'internal_metadata' presence as a version indicator.
- Updated 03_database_specification.md with the new table.
- Recorded in journal 20260223-0019.