Manual:ip_changes table

From MediaWiki.org
Jump to navigation Jump to search
Translate this page
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.

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.

Engines
Technical documentation
Configuration
Development
Core tables
actor – archive – bot_passwords – category – categorylinks – change_tag – comment – config – content – content_models – externallinks – filearchive – hitcounter – image – imagelinks – image_comment_temp – interwiki – iwlinks – ipblocks – ip_changes – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – revision_comment_temp – searchindex – sites – site_identifiers – site_stats – slots – slot_roles – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist
Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Ip_changes_table&oldid=2675322"