surwiki/migrations/20170920205112_fix_slugs_index/up.sql

DROP INDEX slugs_index;
CREATE UNIQUE INDEX slugs_index ON article_revisions (slug) WHERE latest=1;