Manual:Logging table/cs

Každá akce protokolu v MediaWiki je zaznamenána v tabulce logging. Uživatelé mohou vidět tyto úpravy na Special:Log, s výjimkou několika omezených protokolů (jako Special:Log/suppress).

Obsah této tabulky je to, co vidíte na stránce Special:Log. Například:



log_id
Primární klíč tabulky. je cizí klíč odkazující na tento sloupec.

log_type
Typ akce protokolu nebo "typ protokolu".

Podle některých hodnot tohoto typu můžete filtrovat na Special:Log.

Srovnatelné s.

Příklady hodnot z některých wikin Wikimedie jsou následující (včetně nyní zastaralých protokolů a několika rozšíření):


 * abusefilter
 * block
 * close
 * contentmodel
 * delete
 * gblblock
 * gblrights
 * globalauth
 * gwtoolset
 * import
 * liquidthreads
 * lock
 * managetags
 * massmessage
 * merge
 * move
 * mwoauthconsumer
 * newsletter
 * newusers
 * notifytranslators
 * pagelang
 * pagetranslation
 * patrol
 * protect
 * renameuser
 * review
 * rights
 * spamblacklist
 * tag
 * thanks
 * timedmediahandler
 * translationreview
 * upload
 * usermerge

log_action
Provedená akce. Pro daný typ může být více akcí: Například záznam typu smazat může mít akci smazat nebo obnovit atd. Srovnatelné s. Více na stránce. Podívejte se na stránku.

log_timestamp
Čas, kdy byla akce provedena, ve formátu časového razítka, který MediaWiki používá všude v databázi: yyyymmddhhmmss (například "14:18, 25. června 2008"). Má stejnou hodnotu jako odpovídající a. Nemusí mít nutně stejnou hodnotu jako odpovídající v případě nahrávání souborů.

log_user
uživatele, který akci provedl. Toto je odkaz na tabulku (v příkladu ID uživatele "Jacksprat"). Srovnatelné s a.

Zastaráno ve prospěch log_actor.

log_user_text
uživatele, který akci provedl, určeno primárně anonymním uživatelům, vyplnitelné pomocí maintenance/populateLogUsertext.php. Srovnatelné s a.

Zastaráno ve prospěch log_actor.

log_actor
Toto je cizí klíč k v tabulce, odpovídající uživateli (registrovanému nebo anonymnímu), který akci provedl.

log_namespace
Jmenný prostor dotčené stránky. Spolu s log_title je to odkaz do tabulky (v příkladu "Image:Climb.jpg"). Srovnatelné s.


 * Special:Renameuser s log_type a log_action buď "" nebo "renameuser"
 * Special:Userlogin s log_type jako "newusers" a log_action, např. být "tvořivý"

log_title
dotčené stránky. Spolu s log_namespace je to odkaz na tabulku. Srovnatelné s

Název je také známý jako 'target' (cíl) položky protokolu.

U blokování uživatelů se jedná o uživatelské jméno blokovaného uživatele. Za akci díky, toto je uživatelské jméno poděkovaného uživatele.

log_page
, kterého se tato akce protokolu týká. Srovnatelné s a. V případě přesunu stránky je toto nastaveno na page_id přesouvané stránky (od ). Dříve to bylo page_id přesměrování nebo 0, pokud byla stránka přesunuta bez vytvoření přesměrování.

log_comment
Komentář k akci. To je komentář pro nahrávání, komentář pro smazání pro smazání atd. Srovnatelné s a.


 * Místo toho je třeba použít log_comment_id a tabulku !

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

log_params
Další parametry, obvykle prázdné. Zrcadlené v. log_params je obvykle serializován, ale ne vždy. Někdy jsou z historických důvodů pole pro log_params oddělena novým řádkem. Každý, kdo vytváří nový typ protokolu, by měl používat serializaci PHP.

For user blocks, log_params contains the duration of the block and other data, in human readable form, e.g. "2 weeks nocreate,noautoblock,noemail". For page moves, it contains a serialized array of the prefixed page title the page was moved to (i.e. in FULLPAGENAME format) and the boolean value of. For other examples, see.

Since 1.19, data in log_params is in a different format. For instance, if you want to filter patrol/patrol log entries excluding autopatrol, pre-1.19 log entries need: log.log_params LIKE '%\n0' while entries added in 1.19 and further need (serialized PHP arrays): log.log_params LIKE '%"6::auto";i:0%'

Since, log_params is always serialized for newusers log too. An entry now looks like:

mysql> select log_params, log_action from logging where log_user = 4681690; +--++ +--++ +--++
 * log_params                      | log_action |
 * a:1:{s:9:"4::userid";i:4681690;} | autocreate |

while it used to look like:

mysql> select log_params, log_action from logging where log_user = 2298743; +++ +++ +++
 * log_params | log_action |
 * 2298743   | autocreate |

The numbers, e.g. the 4 in "4::userid", are used as the argument number for message keys (e.g. $1, $2,...). The numbering should start with number 4, as the first three parameters are hardcoded for every message. If there is no message key, then a number should not be used. Some data contained in log_params are also contained in to facilitate indexed queries. Log parameters are typically set using functions such as and.

log_deleted
Used with the system to delete log entries. Comparable to and. It is a bit field. Take the sum of the following to determine what it represents:


 * 1 Action deleted
 * 2 Comment deleted
 * 4 User deleted
 * 8 If the deleted information is restricted. If this field is not set, then only deletedhistory right is needed, otherwise you need suppressrevision right. (On Wikimedia wikis, this corresponds to if admins can view the entry, or if only oversighters can)

For example, if the value is 6 (4+2), then the action would be visible, but the comment and user would not be unless you had deletedhistory rights.



Přehled změn ve schématu tabulky
++-+--+-+++ ++-+--+-+++ ++-+--+-+++
 * Field         | Type                | Null | Key | Default        | Extra          |
 * log_id        | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type      | varbinary(32)       | NO   | MUL |                |                |
 * log_action    | varbinary(32)       | NO   |     |                |                |
 * log_timestamp | binary(14)          | NO   | MUL | 19700101000000 |                |
 * log_actor     | bigint(20) unsigned | NO   | MUL | NULL           |                |
 * log_namespace | int(11)             | NO   | MUL | 0              |                |
 * log_title     | varbinary(255)      | NO   |     |                |                |
 * log_page      | int(10) unsigned    | YES  | MUL | NULL           |                |
 * log_comment_id | bigint(20) unsigned | NO  |     | NULL           |                |
 * log_params    | blob                | NO   |     | NULL           |                |
 * log_deleted   | tinyint(3) unsigned | NO   |     | 0              |                |

++-+--+-+++ ++-+--+-+++ ++-+--+-+++
 * Field         | Type                | Null | Key | Default        | Extra          |
 * log_id        | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type      | varbinary(32)       | NO   | MUL |                |                |
 * log_action    | varbinary(32)       | NO   |     |                |                |
 * log_timestamp | binary(14)          | NO   | MUL | 19700101000000 |                |
 * log_user      | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_user_text | varbinary(255)      | NO   | MUL |                |                |
 * log_actor     | bigint(20) unsigned | NO   | MUL | 0              |                |
 * log_namespace | int(11)             | NO   | MUL | 0              |                |
 * log_title     | varbinary(255)      | NO   |     |                |                |
 * log_page      | int(10) unsigned    | YES  | MUL | NULL           |                |
 * log_comment_id | bigint(20) unsigned | NO  |     | NULL           |                |
 * log_params    | blob                | NO   |     | NULL           |                |
 * log_deleted   | tinyint(3) unsigned | NO   |     | 0              |                |

++-+--+-+++ ++-+--+-+++ ++-+--+-+++
 * Field         | Type                | Null | Key | Default        | Extra          |
 * log_id        | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type      | varbinary(32)       | NO   | MUL |                |                |
 * log_action    | varbinary(32)       | NO   |     |                |                |
 * log_timestamp | binary(14)          | NO   | MUL | 19700101000000 |                |
 * log_user      | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_user_text | varbinary(255)      | NO   | MUL |                |                |
 * log_actor     | bigint(20) unsigned | NO   | MUL | 0              |                |
 * log_namespace | int(11)             | NO   | MUL | 0              |                |
 * log_title     | varbinary(255)      | NO   |     |                |                |
 * log_page      | int(10) unsigned    | YES  | MUL | NULL           |                |
 * log_comment   | varbinary(767)      | NO   |     |                |                |
 * log_comment_id | bigint(20) unsigned | NO  |     | 0              |                |
 * log_params    | blob                | NO   |     | NULL           |                |
 * log_deleted   | tinyint(3) unsigned | NO   |     | 0              |                |

++-+--+-+++ ++-+--+-+++ ++-+--+-+++
 * Field         | Type                | Null | Key | Default        | Extra          |
 * log_id        | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type      | varbinary(32)       | NO   | MUL |                |                |
 * log_action    | varbinary(32)       | NO   |     |                |                |
 * log_timestamp | binary(14)          | NO   | MUL | 19700101000000 |                |
 * log_user      | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_user_text | varbinary(255)      | NO   | MUL |                |                |
 * log_namespace | int(11)             | NO   | MUL | 0              |                |
 * log_title     | varbinary(255)      | NO   |     |                |                |
 * log_page      | int(10) unsigned    | YES  | MUL | NULL           |                |
 * log_comment   | varbinary(767)      | NO   |     |                |                |
 * log_comment_id | bigint(20) unsigned | NO  |     | 0              |                |
 * log_params    | blob                | NO   |     | NULL           |                |
 * log_deleted   | tinyint(3) unsigned | NO   |     | 0              |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_id       | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type     | varbinary(32)       | NO   | MUL |                |                |
 * log_action   | varbinary(32)       | NO   |     |                |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_user_text | varbinary(255)     | NO   | MUL |                |                |
 * log_namespace | int(11)            | NO   | MUL | 0              |                |
 * log_title    | varbinary(255)      | NO   |     |                |                |
 * log_page     | int(10) unsigned    | YES  | MUL | NULL           |                |
 * log_comment  | varbinary(767)      | NO   |     |                |                |
 * log_params   | blob                | NO   |     | NULL           |                |
 * log_deleted  | tinyint(3) unsigned | NO   |     | 0              |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_id       | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type     | varbinary(32)       | NO   | MUL |                |                |
 * log_action   | varbinary(32)       | NO   |     |                |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_user_text | varbinary(255)     | NO   | MUL |                |                |
 * log_namespace | int(11)            | NO   | MUL | 0              |                |
 * log_title    | varbinary(255)      | NO   |     |                |                |
 * log_page     | int(10) unsigned    | YES  | MUL | NULL           |                |
 * log_comment  | varbinary(255)      | NO   |     |                |                |
 * log_params   | blob                | NO   |     | NULL           |                |
 * log_deleted  | tinyint(3) unsigned | NO   |     | 0              |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_id       | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type     | varbinary(32)       | NO   | MUL |                |                |
 * log_action   | varbinary(32)       | NO   |     |                |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_user_text | varbinary(255)     | NO   |     |                |                |
 * log_namespace | int(11)            | NO   | MUL | 0              |                |
 * log_title    | varbinary(255)      | NO   |     |                |                |
 * log_page     | int(10) unsigned    | YES  | MUL | NULL           |                |
 * log_comment  | varbinary(255)      | NO   |     |                |                |
 * log_params   | blob                | NO   |     | NULL           |                |
 * log_deleted  | tinyint(3) unsigned | NO   |     | 0              |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_id       | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type     | varbinary(10)       | NO   | MUL |                |                |
 * log_action   | varbinary(10)       | NO   |     |                |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_namespace | int(11)            | NO   | MUL | 0              |                |
 * log_title    | varbinary(255)      | NO   |     |                |                |
 * log_comment  | varbinary(255)      | NO   |     |                |                |
 * log_params   | blob                | NO   |     | NULL           |                |
 * log_deleted  | tinyint(3) unsigned | NO   |     | 0              |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_id       | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * log_type     | varbinary(10)       | NO   | MUL |                |                |
 * log_action   | varbinary(10)       | NO   |     |                |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int(10) unsigned    | NO   | MUL | 0              |                |
 * log_namespace | int(11)            | NO   | MUL | 0              |                |
 * log_title    | varbinary(255)      | NO   |     |                |                |
 * log_comment  | varbinary(255)      | NO   |     |                |                |
 * log_params   | blob                | NO   |     | NULL           |                |
 * log_deleted  | tinyint(3) unsigned | NO   |     | 0              |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_type     | char(10)            | NO   | MUL | NULL           |                |
 * log_action   | char(10)            | NO   |     | NULL           |                |
 * log_timestamp | char(14)           | NO   | MUL | 19700101000000 |                |
 * log_user     | int unsigned        | NO   | MUL | 0              |                |
 * log_namespace | int                | NO   | MUL | 0              |                |
 * log_title    | varchar(255) binary | NO   |     | NULL           |                |
 * log_comment  | varchar(255)        | NO   |     | NULL           |                |
 * log_params   | blob                | NO   |     | NULL           |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_type     | char(10)            | NO   | MUL | NULL           |                |
 * log_action   | char(10)            | NO   |     | NULL           |                |
 * log_timestamp | char(14)           | NO   |     | 19700101000000 |                |
 * log_user     | int unsigned        | NO   | MUL | 0              |                |
 * log_namespace | int(11)            | NO   | MUL | 0              |                |
 * log_title    | varchar(255) binary | NO   |     | NULL           |                |
 * log_comment  | varchar(255)        | NO   |     | NULL           |                |
 * log_params   | blob                | NO   |     | NULL           |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_type     | char(10)            | NO   | MUL | NULL           |                |
 * log_action   | char(10)            | NO   |     | NULL           |                |
 * log_timestamp | char(14)           | NO   |     | 19700101000000 |                |
 * log_user     | int unsigned        | NO   | MUL | 0              |                |
 * log_namespace | tinyint(?) unsigned | NO  | MUL | 0              |                |
 * log_title    | varchar(255) binary | NO   |     | NULL           |                |
 * log_comment  | varchar(255)        | NO   |     | NULL           |                |
 * log_params   | blob                | NO   |     | NULL           |                |

Indexy
 +-++-+--+---+---+-+--++--++-+---+ +-++-+--+---+---+-+--++--++-+---+ +-++-+--+---+---+-+--++--++-+---+
 * Table  | Non_unique | Key_name            | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * logging |         0 | PRIMARY             |            1 | log_id        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_type_time       |            1 | log_type      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_type_time       |            2 | log_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_actor_time      |            1 | log_actor     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_actor_time      |            2 | log_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_page_time       |            1 | log_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_page_time       |            2 | log_title     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_page_time       |            3 | log_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_times           |            1 | log_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_actor_type_time |            1 | log_actor     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_actor_type_time |            2 | log_type      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_actor_type_time |            3 | log_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_page_id_time    |            1 | log_page      | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
 * logging |         1 | log_page_id_time    |            2 | log_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_type_action     |            1 | log_type      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_type_action     |            2 | log_action    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * logging |         1 | log_type_action     |            3 | log_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |



Viz též

 * m:Help:Special page#Logs