Manual:ip_changes table
Jump to navigation
Jump to search
↑ 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 the ip_changes table. This stores the IP as a hex representation so that we can more easily find edits within an IP range. One of the primary purposes of the table is to support IP range queries at Special:Contributions. 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()
is then used to identify revisions within a given range.
BETWEEN
Schema summary[edit]
MediaWiki version: | ≥ 1.36 |
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 | NULL | | | ipc_hex | varbinary(35) | NO | MUL | | | +-------------------+------------------+------+-----+---------+-------+
MediaWiki versions: | 1.30 – 1.35 |
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 | | | +-------------------+------------------+------+-----+----------------+-------+