-- 002_topic_announce_target.sql — move announce-channel routing from
-- backend env to per-topic config. Topic creator picks which Fabric
-- guild + announce channel to broadcast lifecycle events to (a single
-- backend deployment can serve topics broadcasting to multiple guilds/
-- channels). Both fields are nullable; null means "do not broadcast
-- for this topic" (intentional opt-out).

ALTER TABLE topics
  ADD COLUMN announce_guild_base_url VARCHAR(255) NULL AFTER cancelled_reason,
  ADD COLUMN announce_channel_id     VARCHAR(64)  NULL AFTER announce_guild_base_url;