-- Retire the CMS labels for OTP login, which no longer exists.
--
-- V3 seeded editable labels for the OTP tab, its button, and its toast and
-- validation messages. With the feature removed these rows are unreachable from
-- the site but still appear in the admin CMS editor, where they read as text the
-- editor can change and expect to see somewhere. That is worse than absent:
-- someone eventually spends time translating a label for a screen that does not
-- exist.
--
-- The equivalent password-reset strings deliberately do NOT get seeded rows.
-- Their defaults live in the components, so the feature works before anyone
-- touches the CMS; rows can be added later if the editor asks to reword them.
DELETE FROM cms_content
WHERE (section = 'LOGIN'      AND group_key = 'auth_labels' AND field_key IN ('otp_label', 'send_otp_button'))
   OR (section = 'LOGIN'      AND group_key = 'auth_tabs'   AND field_key IN ('otp_mode', 'password_mode'))
   OR (section = 'TOAST'      AND group_key = 'auth'        AND field_key IN ('otp_sent', 'otp_error'))
   OR (section = 'VALIDATION' AND group_key = 'auth'        AND field_key = 'otp_format');