Manual:ip_changes table

Jump to navigation Jump to search

Other languages:
English • ‎português do Brasil • ‎日本語
Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout ip_changes table

MediaWiki version: 1.30

Every time an edit by a logged out user is saved, a row is created in ip_changes. This stores the IP as a hex representation so that we can more easily find edits within an IP range. This table was introduced in Gerrit change 370946.



Foreign key to the revision table, also serves as the unique primary key.


The timestamp of the revision.


Hex representation of the IP address, as returned by IP::toHex().

  • For IPv4 it will resemble: ABCD1234
  • For IPv6: v6-ABCD1234000000000000000000000000

BETWEEN is then used to identify revisions within a given range.