-- Badges — drop the DB-side i18n + the badge.icon column.
--
-- Rationale:
--   - Badge labels & descriptions now live in `resources/lang/<locale>/badges.php`
--     (keyed by `slug`) and are resolved at serialisation time by
--     BadgeResourceSerializer. The BO no longer drives translations — every
--     wording change goes through a PR on the locale catalogues.
--   - Badge icons are derived from `(slug, level)` by BadgeIconUrlBuilder
--     using two env knobs (BADGE_ICON_BASE_URL + BADGE_ICON_EXT). The DB
--     column `badge.icon` is therefore dead weight.
--
-- Before running this migration, export `badge_translation` to seed the
-- new PHP catalogues if you need to preserve existing labels:
--
--     SELECT b.slug, bt.locale, bt.label, bt.description
--       FROM badge_translation bt
--       JOIN badge b ON b.id = bt.badge_id;
--
-- Both operations are irreversible — make sure the PHP catalogues are in
-- place before applying.

ALTER TABLE `badge`
    DROP COLUMN `icon`;

DROP TABLE `badge_translation`;
