Manual:ip_changes table

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
English • ‎português do Brasil • ‎日本語
Manual:Contents MediaWiki 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.

Fields[edit]

ipc_rev_id[edit]

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

ipc_rev_timestamp[edit]

The timestamp of the revision.

ipc_hex[edit]

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.

Schema summary[edit]

MediaWiki version: 1.30

DESCRIBE ip_changes;

+-------------------+------------------+------+-----+----------------+-------+
| Field             | Type             | Null | Key | Default        | Extra |
+-------------------+------------------+------+-----+----------------+-------+
| ipc_rev_id        | int(10) unsigned | NO   | PRI | 0              |       |
| ipc_rev_timestamp | binary(14)       | NO   | MUL |                |       |
| ipc_hex           | varbinary(35)    | NO   | MUL |                |       |
+-------------------+------------------+------+-----+----------------+-------+