-- Add file_size column to social_media_content table
-- This will track the size of downloaded images and videos

ALTER TABLE social_media_content 
ADD COLUMN IF NOT EXISTS file_size BIGINT DEFAULT NULL COMMENT 'File size in bytes';

-- Create index for better query performance
CREATE INDEX IF NOT EXISTS idx_file_size ON social_media_content(file_size);
CREATE INDEX IF NOT EXISTS idx_create_date ON social_media_content(create_date);
