Production SQL Updates

This page is meant to capture and document SQL queries/updates that we've run against our production database (and are NOT captured in Flyway migrations).

These likely will never be run again, but having a historical record of what was done can be helpful! If adding to this page, simply copy the example and paste it to the top of the list.

2024-04-15, Remove all User Notifications and Activity's prior to enabling the feature

Description

As part of going live, we wanted to remove any notifications that accrued during development. Otherwise when the feature flag was turned off, users would receive many historic notifications instead of current notifications. (See EASI-4158 )

Script(s)

DELETE FROM user_notification;

DELETE FROM activity;

Test Data

N/A