-- Add discordThreadId and discordMessageId to formsubmission without data loss
ALTER TABLE `formsubmission`
  ADD COLUMN `discordThreadId` VARCHAR(64) NULL AFTER `reviewedAt`,
  ADD COLUMN `discordMessageId` VARCHAR(64) NULL AFTER `discordThreadId`;

-- Optional indexes if query patterns will filter by these later
-- CREATE INDEX `idx_formsubmission_discordThread` ON `formsubmission` (`discordThreadId`);
-- CREATE INDEX `idx_formsubmission_discordMessage` ON `formsubmission` (`discordMessageId`);
