Manual:Ip changes table/en

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.

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

ipc_rev_timestamp
The timestamp of the revision.

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

BETWEEN is then used to identify revisions within a given range.
 * For IPv4 it will resemble:
 * For IPv6: