-- @database: main
--
-- Purges the user_preference rows for settings dropped in the preferences
-- rework. These keys are no longer in the registry: currency and
-- profileVisibility were never wired to real behaviour, emailVisibleOnProfile
-- required server-side enforcement that never shipped, and the two
-- notification bools are superseded by the notification preference matrix
-- (type x channel), which is the sole gate for InApp/Push dispatch.

DELETE FROM `user_preference`
 WHERE `key` IN (
    'currency',
    'profileVisibility',
    'emailVisibleOnProfile',
    'notificationsEmail',
    'notificationsPush'
 );
