ALTER TABLE media ADD COLUMN date_taken TIMESTAMPTZ; CREATE INDEX IF NOT EXISTS idx_media_date_taken ON media (date_taken);