Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

8 lines (6 sloc) 0.284 kB
-- Disable UNREVIEWED files on PUBLIC add-ons.
UPDATE (files f INNER JOIN versions v ON f.version_id=v.id
INNER JOIN addons a ON a.id=v.addon_id)
SET f.status=5 WHERE f.status=1 AND a.status=4;
-- Move PENDING files to UNREVIEWED.
UPDATE files SET status=1 WHERE status=2;
Jump to Line
Something went wrong with that request. Please try again.