Following up on T364681, Codesearch shows several other database columns that look like they might reference the revision ID and yet be signed 32-bit integers (which means they can’t represent all revisions on Wikidata anymore):
(Note if you’re looking through those Codesearch results: ignore any postgres SQL files, UNSIGNED doesn’t even exist there.)
Wikimedia deployed
Extension:Translate
CREATE TABLE /*_*/translate_reviews ( trr_user INT NOT NULL, trr_page INT NOT NULL, trr_revision INT NOT NULL,
Other
Extension:ContentStabilization
Note: I couldn’t find a Phabricator tag for this extension.
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/stable_file_points ( `sfp_revision` INT NOT NULL PRIMARY KEY,
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/stable_file_transclusions ( `sft_revision` INT NOT NULL, `sft_page` INT NOT NULL, `sft_file_revision` INT NOT NULL,
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/stable_points ( `sp_revision` INT NOT NULL PRIMARY KEY,
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/stable_transclusions ( `st_revision` INT NOT NULL, `st_page` INT NOT NULL, `st_transclusion_revision` INT NOT NULL,
Extension:MathSearch
CREATE TABLE /*_*/math_review_list ( revision_id INT(11) NOT NULL,
Extension:PageCheckout
Note: I couldn’t find a Phabricator tag for this extension.
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/page_checkout_event ( `pce_action` VARCHAR(255) NOT NULL, `pce_actor_id` INT NOT NULL, `pce_page_id` INT NOT NULL, `pce_revision_id` INT NOT NULL,