Manual:Recentchanges table

The recentchanges table contains information about the latest modifications done to the wiki (not older than ; see also below).

The contents of this table are generated out of the tables  and ; they can be regenerated using the maintenance script .

The recentchanges table itself is used to generate the recent>Special:MyLanguage/Help:Recent changes|recent changes pages, related>Special:MyLanguage/Help:Related changes|related changes pages, watchlists, and the new>Special:MyLanguage/Help:New pages|list of new pages, and contains information such as editors' IP addresses (depending on the wiki's configuration) not found on other tables.

The recentchanges table is very similar to the  table, which is used for page history and user contributions listings.

Differences include:


 * The recentchanges table also references the previous revision of the page


 * The recentchanges table also records logged events such as page moves and deletions


 * Items in the recentchanges table are periodically purged; those in the revision table are typically kept longer or indefinitely.


 * as said, import of a page revision not only adds an entry to the revision table with the import date, but also one with the original date.

When pages are moved, their RC entries (specifically, </> and <tvar|title></>) do not change.

rc_id
This is the primary key for the table.

(Introduced in MediaWiki 1.5)

rc_timestamp
Holds the man>Special:MyLanguage/Manual:Timestamp</>|timestamp of the change.

Corresponds to <tvar|rev></> (and <tvar|log></>, in the case of log actions).

rc_cur_time
Had been deprecated, but was first held for backwards compatibility.

rc_user
This is equal to the <tvar|id></> of the user who made this change.

The value for this field is 0 for anonymous edits, initialization scripts, and for some mass imports.

Corresponds to <tvar|rev></> (and <tvar|log></>, in the case of log actions).

If you use <tvar|user> </> to select anonymous edits, remember to set at least <tvar|type> </> as well!

On wikis using <tvar|wikibase></> the results will otherwise be meaningless.

On other wikis, bots or imports may be more relevant than you expect.



Deprecated in favor of <tvar|1>rc_actor</>.

rc_user_text
This field holds the text of the 1>Special:MyLanguage/Manual:User_table#user_name</>|username for the user that made the change, or the IP address if the change was made by an unregistered user.

Corresponds to <tvar|1></> (and <tvar|2></>, in the case of log actions).



Deprecated in favor of <tvar|1>rc_actor</>.

rc_actor
This is a foreign key to <tvar|1></> in the <tvar|2></> table.

Corresponds to <tvar|1></> (or <tvar|2></> in the case of log actions).

rc_namespace
The 1>m:Special:MyLanguage/Help:Namespace</>|namespace number of the page that was subject to change.

Corresponds to <tvar|1></>, in the case of log actions.

If this row describes a logged action, this field has a value of -1 (<tvar|1>NS_SPECIAL</>), as it records an entry for a <tvar|2>Special:Log</> subpage.

rc_title
The name of the page that was subject to change, with the namespace stripped. This field stores information in text form. Corresponds to logtitle>Special:MyLanguage/Manual:Logging_table#log_title</>|log_title, in the case of log actions.

rc_comment
This field holds a summ>m:Help:Edit summary</>|summary of the change (editor's comment on revision). This text is shown in the newchg>:m:Help:Recent changes</>|recent changes, relchg>m:help:related changes</>|related changes, watchlst>:m:Help:Watching pages</>|watchlists, and, in the case of page creation, the nplist>m:Help:Special page</>|list of new pages. (The revtab>Special:MyLanguage/Manual:Revision table</>|revision table contains a copy (revcmt>Special:MyLanguage/Manual:Revision_table#rev_comment</>|rev_comment) used for the hist>:m:Help:Page history</>|history and usrcontrb>:m:Help:User contributions</>|user contributions pages. In the case of log actions, a copy is also in logcmt>Special:MyLanguage/Manual:Logging_table#log_comment</>|log_comment.) It is rendered in a subset of wiki markup.


 * <tvar|id>rc_comment_id</> and the <tvar|comment>comment</> table should be used instead!

rc_comment_id
This is a foreign key to cmtid>Special:MyLanguage/Manual:comment table#comment_id</>|comment_id in the cmttab>Special:MyLanguage/Manual:Comment table</>|comment table.

rc_minor
Records whether the user marked the change as 'min>m:Help:Minor edit</>|minor'. If the value for this field is 1, then the change was declared as 'minor'; it is 0 otherwise. Many automated changes are marked as minor. Corresponds to revmined>Special:MyLanguage/Manual:Revision_table#rev_minor_edit</>|rev_minor_edit.

rc_bot
Records whether the change was made by a 'bot>m:Bot</>|bot account'. If the value for this field is 1, then the change was made by a 'bot' (i.e. a user with the 'bot' permsion>Special:MyLanguage/Manual:User rights#List of Permissions</>|permission); it is 0 otherwise. It is possible for bots to avoid setting this flag on their change by including the parameter "bot=0" in the form submission. Also, users with the 'rollback' and 'markbotedits' permissions may retroactively mark their rollbacks and the edits being rolled back as bot edits by including the parameter "bot=1" in the rollback link.

rc_new
If the value for this field is 1, then this edit created a page; it is 0 otherwise.

rc_cur_id
This field links to the pgid>Special:MyLanguage/Manual:Page table#page_id</>|page_id key in the pgtab>page table</>, which stores the metadata of the page. Corresponds to logpge>Special:MyLanguage/Manual:Logging_table#log_page</>|log_page, in the case of log actions.

rc_this_oldid
Links to the revid>Special:MyLanguage/Manual:Revision_table#rev_id</>|rev_id key of the new page revision (after the edit occurs) in the revtab>Special:MyLanguage/Manual:Revision table</>|revision table.

rc_last_oldid
Links to idrevprnt>Special:MyLanguage/Manual:Revision table#rev_parent_id</>|rev_parent_id, i.e. the rev_id of the revision prior to this edit, which included the previous content of the page.

rc_type
This field stores the type of modification that was made to a page:
 * 0 (RC_EDIT) – edit of existing page
 * 1 (RC_NEW) – new page
 * 2 (RC_MOVE) – move (obsolete)
 * 3 (RC_LOG) – log action (added in MediaWiki 1.2)
 * 4 (RC_MOVE_OVER_REDIRECT) – move over redirect (obsolete)
 * 5 (RC_EXTERNAL) – An external recent change. Primarily used by Wikidata
 * 6 (RC_CATEGORIZE) – category membership change, see <tvar|mbrshpchg></> (added in MediaWiki 1.27, )

rc_source
The source of the change entry (replaces rc_type).

Allows specifying the type of change and for more flexibly specifying different types of RecentChange entries. For example, 'mw.edit', 'mw.log', 'mw.new' for core RecentChange types and 'wb' and 'flow' provided by extensions.

rc_moved_to_ns
This field stored the namespace of a page whenever it was moved. As of MediaWiki 1.8, it remained in the table for backwards compatibility only, and always has the value 0. It was removed entirely in MediaWiki 1.21.

rc_moved_to_title
This field stored the new page title of a page whenever it was moved. As of MediaWiki 1.8, it remained in the table for backwards compatibility only, and is always a null string. It was removed entirely in MediaWiki 1.21.

rc_patrolled
If the Recent Changes Patrol option (<tvar|rcptrl></>) is enabled, users may mark changes as having been reviewed to remove a warning flag on the RC list. A value of 0 indicates the change is unpatrolled, 1 indicates the change has been reviewed. (Introduced in MediaWiki 1.4)

rc_patrolled now has three states: "0" for unpatrolled, "1" for manually patrolled, and "2" for autopatrolled actions.

rc_ip
This field stores the IP address of the user specified on rcusr>#rc_user</>|rc_user if <tvar|ipusr></> is enabled. If $wgPutIPinRC is false, then the field will contain an empty string.

In some old MediaWiki versions this field was used to generate chkusr>Extension:CheckUser</>|CheckUser reports, but it is now considered obsolete as CheckUser stores data in a separate  table. When the extension is set up, data from this field may be copied over a single time.

(Introduced in MediaWiki 1.3)

rc_old_len
This field stores the size, in bytes, of previous revision's text. This field is used to generate the added and removed characters feature in newchgs>:m:Help:Recent changes</>|recent changes, relchgs>m:help:related changes</>|related changes and watchlst>:m:Help:Watching pages</>|watchlists.

rc_new_len
This field stores the size, in bytes, of the current revision's text. This field is used to generate the added and removed characters feature in recentchgs>:m:Help:Recent changes</>|recent changes, relchges>m:help:related changes</>|related changes and watchlsts>:m:Help:Watching pages</>|watchlists. Corresponds to <tvar|revlen></>.

rc_deleted
This field stores a value for this particular revision's visibility within the wiki. It was created to accommodate upcoming revisions to the delsystem>bitfields for rev_deleted</>|deletion system. The field is analogous to <tvar|revdeltd></> or <tvar|logdeltd></>.

rc_logid
This field is a foreignkey>w:foreign key</>|foreign key to the <tvar|logging></> table, which links to if this row corresponds to a log entry. The field was introduced in MediaWiki 1.10.

rc_log_type
If a log action is referenced in this row, this field stores the type of log action that was performed, and which is referenced in this row. Typical values are. This field is comparable to <tvar|logtype></>.

rc_log_action
If a log action is referenced in this row, this field stores the type of log action that was performed, and which is referenced in this row. This field is comparable to <tvar|logaction></>.

rc_params
This field will be a mirror of <tvar|logparam></>, following the log_params text rewrite. Introduced in MediaWiki 1.10.

Schema summary
+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * rc_id        | int(11)             | NO   | PRI | NULL    | auto_increment |
 * rc_timestamp | varbinary(14)       | NO   | MUL |         |                |
 * rc_user      | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text | varbinary(255)      | NO   | MUL |         |                |
 * rc_actor     | bigint(20) unsigned | NO   | MUL | 0       |                |
 * rc_namespace | int(11)             | NO   | MUL | 0       |                |
 * rc_title     | varbinary(255)      | NO   |     |         |                |
 * rc_comment_id | bigint(20) unsigned | NO  |     | NULL    |                |
 * rc_minor     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot       | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new       | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id    | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid | int(10) unsigned   | NO   | MUL | 0       |                |
 * rc_last_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * rc_type      | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_source    | varbinary(16)       | NO   |     |         |                |
 * rc_patrolled | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip        | varbinary(40)       | NO   | MUL |         |                |
 * rc_old_len   | int(11)             | YES  |     | NULL    |                |
 * rc_new_len   | int(11)             | YES  |     | NULL    |                |
 * rc_deleted   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_logid     | int(10) unsigned    | NO   |     | 0       |                |
 * rc_log_type  | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action | varbinary(255)     | YES  |     | NULL    |                |
 * rc_params    | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * rc_id        | int(11)             | NO   | PRI | NULL    | auto_increment |
 * rc_timestamp | varbinary(14)       | NO   | MUL |         |                |
 * rc_user      | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text | varbinary(255)      | NO   | MUL |         |                |
 * rc_actor     | bigint(20) unsigned | NO   | MUL | 0       |                |
 * rc_namespace | int(11)             | NO   | MUL | 0       |                |
 * rc_title     | varbinary(255)      | NO   |     |         |                |
 * rc_comment   | varbinary(767)      | NO   |     |         |                |
 * rc_comment_id | bigint(20) unsigned | NO  |     | 0       |                |
 * rc_minor     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot       | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new       | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id    | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid | int(10) unsigned   | NO   | MUL | 0       |                |
 * rc_last_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * rc_type      | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_source    | varbinary(16)       | NO   |     |         |                |
 * rc_patrolled | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip        | varbinary(40)       | NO   | MUL |         |                |
 * rc_old_len   | int(11)             | YES  |     | NULL    |                |
 * rc_new_len   | int(11)             | YES  |     | NULL    |                |
 * rc_deleted   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_logid     | int(10) unsigned    | NO   |     | 0       |                |
 * rc_log_type  | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action | varbinary(255)     | YES  |     | NULL    |                |
 * rc_params    | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * rc_id        | int(11)             | NO   | PRI | NULL    | auto_increment |
 * rc_timestamp | varbinary(14)       | NO   | MUL |         |                |
 * rc_user      | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text | varbinary(255)      | NO   | MUL |         |                |
 * rc_actor     | bigint(20) unsigned | NO   | MUL | 0       |                |
 * rc_namespace | int(11)             | NO   | MUL | 0       |                |
 * rc_title     | varbinary(255)      | NO   |     |         |                |
 * rc_comment   | varbinary(767)      | NO   |     |         |                |
 * rc_comment_id | bigint(20) unsigned | NO  |     | 0       |                |
 * rc_minor     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot       | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new       | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id    | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * rc_last_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * rc_type      | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_source    | varbinary(16)       | NO   |     |         |                |
 * rc_patrolled | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip        | varbinary(40)       | NO   | MUL |         |                |
 * rc_old_len   | int(11)             | YES  |     | NULL    |                |
 * rc_new_len   | int(11)             | YES  |     | NULL    |                |
 * rc_deleted   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_logid     | int(10) unsigned    | NO   |     | 0       |                |
 * rc_log_type  | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action | varbinary(255)     | YES  |     | NULL    |                |
 * rc_params    | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * rc_id        | int(11)             | NO   | PRI | NULL    | auto_increment |
 * rc_timestamp | varbinary(14)       | NO   | MUL |         |                |
 * rc_user      | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text | varbinary(255)      | NO   | MUL | NULL    |                |
 * rc_namespace | int(11)             | NO   | MUL | 0       |                |
 * rc_title     | varbinary(255)      | NO   |     |         |                |
 * rc_comment   | varbinary(767)      | NO   |     |         |                |
 * rc_comment_id | bigint(20) unsigned | NO  |     | 0       |                |
 * rc_minor     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot       | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new       | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id    | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * rc_last_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * rc_type      | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_source    | varbinary(16)       | NO   |     |         |                |
 * rc_patrolled | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip        | varbinary(40)       | NO   | MUL |         |                |
 * rc_old_len   | int(11)             | YES  |     | NULL    |                |
 * rc_new_len   | int(11)             | YES  |     | NULL    |                |
 * rc_deleted   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_logid     | int(10) unsigned    | NO   |     | 0       |                |
 * rc_log_type  | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action | varbinary(255)     | YES  |     | NULL    |                |
 * rc_params    | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * rc_id        | int(11)             | NO   | PRI | NULL    | auto_increment |
 * rc_timestamp | varbinary(14)       | NO   | MUL |         |                |
 * rc_user      | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text | varbinary(255)      | NO   | MUL | NULL    |                |
 * rc_namespace | int(11)             | NO   | MUL | 0       |                |
 * rc_title     | varbinary(255)      | NO   |     |         |                |
 * rc_comment   | varbinary(767)      | NO   |     |         |                |
 * rc_minor     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot       | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new       | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id    | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * rc_last_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * rc_type      | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_source    | varbinary(16)       | NO   |     |         |                |
 * rc_patrolled | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip        | varbinary(40)       | NO   | MUL |         |                |
 * rc_old_len   | int(11)             | YES  |     | NULL    |                |
 * rc_new_len   | int(11)             | YES  |     | NULL    |                |
 * rc_deleted   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_logid     | int(10) unsigned    | NO   |     | 0       |                |
 * rc_log_type  | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action | varbinary(255)     | YES  |     | NULL    |                |
 * rc_params    | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * rc_id            | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
 * rc_timestamp     | varbinary(14)       | NO   | MUL | NULL    |                |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |                |
 * rc_namespace     | int(11)             | NO   | MUL | 0       |                |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |                |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |                |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_source        | varchar(16) binary  | NO   |     | NULL    |                |
 * rc_patrolled     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip            | varbinary(40)       | NO   | MUL | NULL    |                |
 * rc_old_len       | int(10)             | YES  |     | NULL    |                |
 * rc_new_len       | int(10)             | YES  |     | NULL    |                |
 * rc_deleted       | tinyint(3) unsigned | NO   |     | NULL    |                |
 * rc_logid         | int(10) unsigned    | NO   |     | NULL    |                |
 * rc_log_type      | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action    | varbinary(255)      | YES  |     | NULL    |                |
 * rc_params        | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * rc_id            | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
 * rc_timestamp     | varbinary(14)       | NO   | MUL | NULL    |                |
 * rc_cur_time      | varbinary(14)       | NO   |     | NULL    |                |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |                |
 * rc_namespace     | int(11)             | NO   | MUL | 0       |                |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |                |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |                |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_source        | varchar(16) binary  | NO   |     | NULL    |                |
 * rc_patrolled     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip            | varbinary(40)       | NO   | MUL | NULL    |                |
 * rc_old_len       | int(10)             | YES  |     | NULL    |                |
 * rc_new_len       | int(10)             | YES  |     | NULL    |                |
 * rc_deleted       | tinyint(3) unsigned | NO   |     | NULL    |                |
 * rc_logid         | int(10) unsigned    | NO   |     | NULL    |                |
 * rc_log_type      | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action    | varbinary(255)      | YES  |     | NULL    |                |
 * rc_params        | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * rc_id            | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
 * rc_timestamp     | varbinary(14)       | NO   | MUL | NULL    |                |
 * rc_cur_time      | varbinary(14)       | NO   |     | NULL    |                |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |                |
 * rc_namespace     | int(11)             | NO   | MUL | 0       |                |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |                |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |                |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_patrolled     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip            | varbinary(40)       | NO   | MUL | NULL    |                |
 * rc_old_len       | int(10)             | YES  |     | NULL    |                |
 * rc_new_len       | int(10)             | YES  |     | NULL    |                |
 * rc_deleted       | tinyint(3) unsigned | NO   |     | NULL    |                |
 * rc_logid         | int(10) unsigned    | NO   |     | NULL    |                |
 * rc_log_type      | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action    | varbinary(255)      | YES  |     | NULL    |                |
 * rc_params        | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * rc_id            | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
 * rc_timestamp     | varbinary(14)       | NO   | MUL | NULL    |                |
 * rc_cur_time      | varbinary(14)       | NO   |     | NULL    |                |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |                |
 * rc_namespace     | int(11)             | NO   | MUL | 0       |                |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |                |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |                |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_ns   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_title | varchar(255) binary | NO  |     | NULL    |                |
 * rc_patrolled     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip            | varbinary(40)       | NO   | MUL | NULL    |                |
 * rc_old_len       | int(10)             | YES  |     | NULL    |                |
 * rc_new_len       | int(10)             | YES  |     | NULL    |                |
 * rc_deleted       | tinyint(3) unsigned | NO   |     | NULL    |                |
 * rc_logid         | int(10) unsigned    | NO   |     | NULL    |                |
 * rc_log_type      | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action    | varbinary(255)      | YES  |     | NULL    |                |
 * rc_params        | blob                | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * rc_id            | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
 * rc_timestamp     | varbinary(14)       | NO   | MUL | NULL    |                |
 * rc_cur_time      | varbinary(14)       | NO   |     | NULL    |                |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |                |
 * rc_namespace     | int(11)             | NO   | MUL | 0       |                |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |                |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |                |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_ns   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_title | varchar(255) binary | NO  |     | NULL    |                |
 * rc_patrolled     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip            | varbinary(40)       | NO   | MUL | NULL    |                |
 * rc_old_len       | int(10)             | YES  |     | NULL    |                |
 * rc_new_len       | int(10)             | YES  |     | NULL    |                |
 * rc_deleted       | tinyint(3) unsigned | NO   |     | NULL    |                |
 * rc_logid         | int(10) unsigned    | NO   |     | NULL    |                |
 * rc_log_type      | varbinary(255)      | YES  |     | NULL    |                |
 * rc_log_action    | varbinary(255)      | YES  |     | NULL    |                |
 * rc_params        | blob                | NO   |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * rc_id            | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
 * rc_timestamp     | varchar(14) binary  | NO   | MUL | NULL    |                |
 * rc_cur_time      | varchar(14) binary  | NO   |     | NULL    |                |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |                |
 * rc_namespace     | int(11)             | NO   | MUL | 0       |                |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |                |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |                |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_ns   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_title | varchar(255) binary | NO  |     | NULL    |                |
 * rc_patrolled     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip            | char(15)            | NO   | MUL | NULL    |                |
 * rc_old_len       | int(10)             | YES  |     | NULL    |                |
 * rc_new_len       | int(10)             | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * rc_id            | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
 * rc_timestamp     | varchar(14) binary  | NO   | MUL | NULL    |                |
 * rc_cur_time      | varchar(14) binary  | NO   |     | NULL    |                |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |                |
 * rc_namespace     | int(11)             | NO   | MUL | 0       |                |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |                |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |                |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_ns   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_title | varchar(255) binary | NO  |     | NULL    |                |
 * rc_patrolled     | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_ip            | char(15)            | NO   | MUL | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * rc_id            | int(8)              | NO   | PRI | NULL    | AUTO_INCREMENT |
 * rc_timestamp     | varchar(14) binary  | NO   | MUL | NULL    |                |
 * rc_cur_time      | varchar(14) binary  | NO   |     | NULL    |                |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |                |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |                |
 * rc_namespace     | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |                |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |                |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |                |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |                |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_ns   | tinyint(3) unsigned | NO   |     | 0       |                |
 * rc_moved_to_title | varchar(255) binary | NO  |     | NULL    |                |
 * rc_ip            | char(15)            | NO   | MUL | NULL    |                |

+---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field            | Type                | Null | Key | Default | Extra |
 * rc_timestamp     | varchar(14) binary  | NO   | MUL | NULL    |       |
 * rc_cur_time      | varchar(14) binary  | NO   |     | NULL    |       |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |       |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |       |
 * rc_namespace     | tinyint(3) unsigned | NO   | MUL | 0       |       |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |       |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |       |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |       |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |       |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |       |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |       |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_moved_to_ns   | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_moved_to_title | varchar(255) binary | NO  |     | NULL    |       |
 * rc_ip            | char(15)            | NO   | MUL | NULL    |       |

+---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field            | Type                | Null | Key | Default | Extra |
 * rc_timestamp     | varchar(14) binary  | NO   | MUL | NULL    |       |
 * rc_cur_time      | varchar(14) binary  | NO   |     | NULL    |       |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |       |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |       |
 * rc_namespace     | tinyint(3) unsigned | NO   | MUL | 0       |       |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |       |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |       |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |       |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |       |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |       |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |       |
 * rc_type          | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_moved_to_ns   | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_moved_to_title | varchar(255) binary | NO  |     | NULL    |       |

+---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field            | Type                | Null | Key | Default | Extra |
 * rc_timestamp     | varchar(14) binary  | NO   | MUL | NULL    |       |
 * rc_cur_time      | varchar(14) binary  | NO   |     | NULL    |       |
 * rc_user          | int(10) unsigned    | NO   |     | 0       |       |
 * rc_user_text     | varchar(255) binary | NO   |     | NULL    |       |
 * rc_namespace     | tinyint(3) unsigned | NO   | MUL | 0       |       |
 * rc_title         | varchar(255) binary | NO   |     | NULL    |       |
 * rc_comment       | varchar(255) binary | NO   |     | NULL    |       |
 * rc_minor         | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_bot           | tinyint(3) unsigned | NO   |     | 0       |       |
 * rc_new           | tinyint(3) unsigned | NO   | MUL | 0       |       |
 * rc_cur_id        | int(10) unsigned    | NO   | MUL | 0       |       |
 * rc_this_oldid    | int(10) unsigned    | NO   |     | 0       |       |
 * rc_last_oldid    | int(10) unsigned    | NO   |     | 0       |       |

Indices
<pre style='letter-spacing:-.5px;white-space:pre;'> +---++--+--+--+---+-+--++--++-+---+ +---++--+--+--+---+-+--++--++-+---+ +---++--+--+--+---+-+--++--++-+---+
 * Table        | Non_unique | Key_name                         | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * recentchanges |         0 | PRIMARY                          |            1 | rc_id        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_timestamp                     |            1 | rc_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_namespace_title               |            1 | rc_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_namespace_title               |            2 | rc_title     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_cur_id                        |            1 | rc_cur_id    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | new_name_timestamp               |            1 | rc_new       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | new_name_timestamp               |            2 | rc_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | new_name_timestamp               |            3 | rc_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_ip                            |            1 | rc_ip        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_ns_usertext                   |            1 | rc_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_ns_usertext                   |            2 | rc_user_text | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_user_text                     |            1 | rc_user_text | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_user_text                     |            2 | rc_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_name_type_patrolled_timestamp |            1 | rc_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_name_type_patrolled_timestamp |            2 | rc_type      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_name_type_patrolled_timestamp |            3 | rc_patrolled | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_name_type_patrolled_timestamp |            4 | rc_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |