-- Migration: prevent duplicate reports from the same user, and index for
-- the home-feed "hide reported content" filter.

ALTER TABLE `report_pack`
  ADD UNIQUE KEY `report_pack_user_pack_uq` (`user_id`, `pack_id`);

ALTER TABLE `report_sticker`
  ADD UNIQUE KEY `report_sticker_user_sticker_uq` (`user_id`, `sticker_id`);

ALTER TABLE `report_pack`
  ADD KEY `report_pack_status_idx` (`status`);

ALTER TABLE `report_sticker`
  ADD KEY `report_sticker_status_idx` (`status`);