Migrate sent_notifications.id to bigint

sent_notifications.id column is an int4 primary key currently exceeding 50% of saturation. As a result, that key must be migrated to a big int to ensure we don't exhaust potential values.

Timeline

This process needs to be started ASAP - exhausting this column would cause serious harm to the running application.

Process

Following the process outlined here, we must:

• Initialize the conversion (release N)
• Swap the columns (release N + 1)
• Remove the trigger and old integer columns (release N + 2)
• Remove ignore rules (release N + 3)