Manual:Recentchanges table/cs

Tabulka recentchanges obsahuje informace o posledních úpravách provedených na wiki (ne starší než ; viz také níže). Obsah této tabulky je generován z tabulek a. Lze jej regenerovat pomocí údržbového skriptu. Samotná tabulka posledních změn se používá ke generování stránek posledních změn, stránek souvisejících změn, seznamů ke zhlédnutí a seznamu nové stránky a obsahuje informace, jako jsou IP adresy editorů (v závislosti na konfiguraci wiki), které se v jiných tabulkách nenacházejí. Tabulka recentchanges je velmi podobná tabulce, která se používá pro výpisy historie stránky a příspěvky uživatelů. Mezi rozdíly patří:


 * Tabulka posledních změn také odkazuje na předchozí revizi stránky
 * Tabulka posledních změn také zaznamenává zaznamenané události, jako jsou přesuny a mazání stránek
 * Položky v tabulce nedávných změn jsou pravidelně mazány. Ty v tabulce revizí jsou obvykle uchovávány déle nebo neomezeně dlouho.
 * Jak bylo řečeno, import revize stránky nejenže přidá záznam do tabulky revizí s datem importu, ale také záznam s původním datem.

Když jsou stránky přesunuty, jejich položky RC (konkrétně a ) se nemění.

rc_id
Toto je primární klíč pro tabulku.

rc_timestamp
Obsahuje časové razítko změny. Odpovídá (a, v případě akcí protokolu).

rc_cur_time
Byl zastaralý, ale byl nejprve zadržen kvůli zpětné kompatibilitě.

rc_user
To se rovná uživatele, který tuto změnu provedl. Hodnota tohoto pole je 0 pro anonymní úpravy, inicializační skripty a pro některé hromadné importy. Odpovídá (a  v případě akcí protokolu).

Pokud používáte  k výběru anonymních úprav, nezapomeňte také nastavit alespoň  ! Na wikinách používajících budou výsledky jinak bezvýznamné. Na jiných wikinách mohou být roboti nebo importy relevantnější, než očekáváte.

Ukončeno ve prospěch rc_actor.

rc_user_text
Toto pole obsahuje text username uživatele, který provedl změnu, nebo IP adresu, pokud změnu provedl neregistrovaný uživatel. Odpovídá (a, v případě akcí protokolu).

Ukončeno ve prospěch rc_actor.

rc_actor
Toto je cizí klíč k v tabulce. Odpovídá (nebo  v případě akcí protokolu).

rc_namespace
Číslo namespace stránky, která byla předmětem změny. V případě akcí protokolu odpovídá.

If this row describes a logged action, this field has a value of -1 (NS_SPECIAL), as it records an entry for a 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 log_title, in the case of log actions.

rc_comment
This field holds a summary of the change (editor's comment on revision). This text is shown in the recent changes, related changes, watchlists, and, in the case of page creation, the list of new pages. (The table contains a copy (rev_comment) used for the history and user contributions pages.  In the case of log actions, a copy is also in log_comment.) It is rendered in a subset of wiki markup.

rc_comment_id and the comment table should be used instead!

rc_comment_id
This is a foreign key to in the  table.

rc_minor
Records whether the user marked the change as '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 rev_minor_edit.

rc_bot
Records whether the change was made by a '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' 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 key in the  table, which stores the metadata of the page. Corresponds to log_page, in the case of log actions.

rc_this_oldid
Links to the key of the new page revision (after the edit occurs) in the  table.

rc_last_oldid
Links to 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 (added in MediaWiki 1.27, )

Extensions might use other types, e.g. StructuredDiscussions uses 142.

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 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.

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 rc_user if 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 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.

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 recent changes, related changes and 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 recent changes, related changes and watchlists. Corresponds to.

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 deletion system. The field is analogous to or.

rc_logid
This field is a foreign key to the table, which links to  if this row corresponds to a log entry.

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.

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.

rc_params
This field will be a mirror of, following the log_params text rewrite.



Přehled změn ve schématu tabulky
+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field        | Type                | Null | Key | Default | Extra          |
 * rc_id        | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
 * rc_timestamp | binary(14)          | NO   | MUL | NULL    |                |
 * rc_actor     | bigint(20) unsigned | NO   | MUL | NULL    |                |
 * 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_actor     | bigint(20) unsigned | NO   | MUL | NULL    |                |
 * 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_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       |       |

Indexy
 +---++--+--+---+---+-+--++--++-+---+ +---++--+--+---+---+-+--++--++-+---+ +---++--+--+---+---+-+--++--++-+---+
 * 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_timestamp     |            1 | rc_namespace  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_namespace_title_timestamp     |            2 | rc_title      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_namespace_title_timestamp     |            3 | rc_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_cur_id                        |            1 | rc_cur_id     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_new_name_timestamp            |            1 | rc_new        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_new_name_timestamp            |            2 | rc_namespace  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_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_actor                      |            1 | rc_namespace  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_ns_actor                      |            2 | rc_actor      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_actor                         |            1 | rc_actor      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * recentchanges |         1 | rc_actor                         |            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      |         |               |
 * recentchanges |         1 | rc_this_oldid                    |            1 | rc_this_oldid | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |

