multi-platform-media-manage/database/migrations/add_share_collect_to_user_day_statistics.sql

-- Add share_count and collect_count to user_day_statistics
-- Date: 2026-01-28

USE media_manager;

ALTER TABLE user_day_statistics
  ADD COLUMN share_count INT DEFAULT 0 COMMENT 'share_count' AFTER like_count,
  ADD COLUMN collect_count INT DEFAULT 0 COMMENT 'collect_count' AFTER share_count;