gplx/mediawiki/extensions/ApprovedRevs/sql/ApprovedRevs.sql

CREATE TABLE /*_*/approved_revs (
	page_id int default NULL,
	rev_id int default NULL,
	approver_id int NOT NULL default 0,
	approval_date timestamp NULL
) /*$wgDBTableOptions*/;

CREATE UNIQUE INDEX approved_revs_page_id ON /*_*/approved_revs (page_id);