Something went wrong. Try again.
A downstream fork of Tranquil PDS for use in margin.cafe
Something went wrong. Try again.
398 B · 13 lines
SQL
12345678910111213CREATE INDEX IF NOT EXISTS idx_record_blobs_repo_blob ON record_blobs (repo_id, blob_cid);
CREATE INDEX IF NOT EXISTS idx_comms_jobs_stale_processing ON comms_queue (updated_at, scheduled_for, id) WHERE status = 'processing';
CREATE INDEX IF NOT EXISTS idx_users_lower_email ON users (LOWER(email)) WHERE email IS NOT NULL;
UPDATE reposSET record_blobs_backfilled_at = NULL;