CREATE TABLE /*_*/revtag ( rt_type BLOB NOT NULL, rt_page BIGINT UNSIGNED NOT NULL, rt_revision BIGINT UNSIGNED NOT NULL, rt_value BLOB DEFAULT NULL, PRIMARY KEY(rt_type, rt_page, rt_revision) ); CREATE INDEX rt_revision_type ON /*_*/revtag (rt_revision, rt_type);