-- Adds appeal category as another matching dimension on
-- appeal_status_notification_trigger, alongside appeal type and old/new
-- status. Empty (the default, '[]') means "any category", matching the
-- existing wildcard convention for the other *_ids/*_names columns, so
-- existing triggers keep matching exactly as before.
--
-- Apply to every environment's database before deploying this change.

ALTER TABLE `appeal_status_notification_trigger`
  ADD COLUMN `appeal_category_ids` text NOT NULL DEFAULT '[]' AFTER `appeal_type_ids`;
