[ads] Add foreign key support to the database mocking script

[tmancey]

Description

components/brave_ads/core/test/data/database_migration/mock_database.py disables foreign keys while mocking the database. This could potentially mask issues related to foreign key constraints during testing.