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

Pokud tento řádek popisuje protokolovanou akci, má toto pole hodnotu -1 (NS_SPECIAL), protože zaznamenává záznam pro podstránku Special:Log.

rc_title
Název stránky, která byla změněna, s odstraněným jmenným prostorem. Toto pole ukládá informace v textové podobě. V případě akcí protokolu odpovídá log_title.

rc_comment
Toto pole obsahuje souhrn změn (editorův komentář k revizi). Tento text je zobrazen v posledních změnách, souvisejících změnách, seznamech sledování a v případě vytvoření stránky v seznam nových stránek. (Tabulka obsahuje kopii (rev_comment) použitou pro stránky history a příspěvky uživatelů. V případě akcí protokolu je kopie také v log_comment.) Je vykreslena v podmnožině značek wiki.

Místo toho je třeba použít rc_comment_id a tabulku comment!

rc_comment_id
Toto je cizí klíč k v tabulce.

rc_minor
Zaznamenává, zda uživatel označil změnu jako 'minor'. Je-li hodnota pro toto pole 1, byla změna deklarována jako 'nepodstatná'. Jinak je 0. Mnoho automatických změn je označeno jako drobné. Odpovídá rev_minor_edit.

rc_bot
Zaznamenává, zda změnu provedl 'bot účet'. Pokud je hodnota tohoto pole 1, pak změnu provedl 'bot' (tj. uživatel s 'bot' oprávněním). Jinak je 0. Boti se mohou vyhnout nastavení tohoto příznaku při své změně tím, že do formuláře zadají parametr "bot=0". 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      |         |               |

