Skip to content
This repository
tag: 6.3.3.1
Fetching contributors…

Octocat-spinner-32-eaf2f5

Cannot retrieve contributors at this time

file 14 lines (8 sloc) 0.293 kb
1 2 3 4 5 6 7 8 9 10 11 12 13
ALTER TABLE previews
    ADD COLUMN position TINYINT(11) unsigned DEFAULT 0 AFTER highlight;

CREATE INDEX addon_position_created_idx
    ON previews (`addon_id`, `position`, `created`);

UPDATE previews
    SET position=1 WHERE highlight=0;

ALTER TABLE previews
    DROP COLUMN highlight;


Something went wrong with that request. Please try again.