fix: Resolve purchases.pack_id constraint conflict

Commit notes

This commit drops the NOT NULL constraint on the pack_id column in the purchases table to allow for proper handling of ON DELETE SET NULL behavior when a sample_pack is deleted. Additionally, updates the schema to reflect this change.