feat: Add migration for purchases table to allow null pack_id

Commit notes

- Created a new SQL migration to alter the "purchases" table, dropping the NOT NULL constraint on the "pack_id" column. - Updated the journal and snapshot metadata to include the new migration entry.