surwiki/migrations/20171018134042_add_author_to_article_revisions/up.sql

ALTER TABLE article_revisions ADD COLUMN author TEXT CHECK (author != '');

CREATE INDEX author_lookup ON article_revisions (author);