-- Add article assessments table

CREATE TABLE IF NOT EXISTS /*_*/page_assessments (
	pa_page_id          INT UNSIGNED NOT NULL,
	pa_project          VARCHAR(128) DEFAULT NULL,
	pa_class            VARCHAR(20) DEFAULT NULL,
	pa_importance       VARCHAR(20) DEFAULT NULL,
	pa_page_revision    INT UNSIGNED NOT NULL
)/*$wgDBTableOptions*/;

CREATE INDEX /*i*/pa_project ON /*_*/ page_assessments (pa_project);
CREATE UNIQUE INDEX /*i*/pa_page_project ON /*_*/ page_assessments (pa_page_id, pa_project);
