Manual:Logging table/ja

MediaWiki におけるすべてのログアクションは logging テーブルに記録されます. 利用者は少数の制限されたログ（Special:Log/suppress 等）を除いて Special:Log においてこれらの編集を閲覧することができます.

このテーブルの内容は Special:Log ページで表示されるものです. 例:



log_id
このテーブルの主キーです. はこのカラムにリンクしている外部キーです.

log_type
操作の種類です. 特別:記録では、この種類を使ってフィルタを掛けることができます. 典型的な値は以下の通り: block, delete, import, makebot, move, newusers, protect, renameuser, rights, upload （例: "uploaded"） に相当します. Values on itwiki, as of November 2014, are (including now-obsolete logs and several extensions):

MariaDB [itwiki_p]> SELECT DISTINCT log_type FROM logging; +---+ +---+ +---+ 16 rows in set (0.01 sec)
 * log_type     |
 * abusefilter  |
 * block        |
 * delete       |
 * gblblock     |
 * import       |
 * massmessage  |
 * merge        |
 * move         |
 * newusers     |
 * patrol       |
 * protect      |
 * renameuser   |
 * rights       |
 * spamblacklist |
 * thanks       |
 * upload       |

log_action
行われた操作. 与えられた「操作の種類」に対して複数の「操作」が該当することもあります. 例えば、"delete"（削除）という「操作の種類」には、"delete"（ページの削除）や "restore"（ページの復元）などが含まれます. に相当します. も参照してください. を参照してください.

log_timestamp
The time the action was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss ("14:18, 25 June 2008" in example). Comparable to and. If the log event is a file upload, this field is not necessarily the same as the generated by.

log_user
操作を行った利用者の. これは、 テーブルへの参照です. Comparable to and.

log_user_text
of the user who performed the action, intended primarily for anonymous users, fillable by maintenance/populateLogUsertext.php. Comparable to and.

log_namespace
影響を受けたページの名前空間. log_title とともに、 テーブルへの参照となります. に相当します.


 * log_type と log_action が "" か "renameuser" である、特別:利用者名変更.
 * log_type が "newusers"であり、log_action が "create" などである、特別:ログイン.

log_title
影響を受けたページの|ページ名. log_namespace とともに、 テーブルへの参照となります. に相当します.

ブロック記録の場合、ここにはブロックされた利用者名が入ります.

log_page
The that this log action is about. Comparable to and. In the case of a page move, this is set to the page_id of the moved page (since ). Formerly, it was the page_id of the redirect, or 0 if the page was moved without creating a redirect.

log_comment
その操作に与えられた要約. これは、アップロードの際の要約、削除の際の要約などです. と に相当します.


 * log_comment_id テーブルと comment テーブルに置き換えて利用されるべきです！

log_comment_id
This is a foreign key to in the  table.

log_params
Additional parameters, usually empty. Mirrored in. log_params is usually serialized, but not always; sometimes, for historical reasons, fields for log_params are separated by a newline. Anyone creating a new log type should use the PHP serialization.

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
機能を使って削除された記録の情報. および に相当します. 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.

スキーマの要約
+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_id       | int(10) unsigned    | NO   | PRI | NULL           | AUTO_INCREMENT |
 * log_type     | varbinary(32)       | NO   | MUL | NULL           |                |
 * log_action   | varbinary(32)       | NO   |     | NULL           |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int unsigned        | NO   | MUL | 0              |                |
 * log_user_text | varchar(255) binary | NO  | MUL | NULL           |                |
 * log_namespace | int                | NO   | MUL | 0              |                |
 * log_title    | varchar(255) binary | NO   | MUL | NULL           |                |
 * log_page     | int unsigned        | YES  |     | NULL           |                |
 * log_comment  | varbinary(767)      | 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 | NULL           |                |
 * log_action   | varbinary(32)       | NO   |     | NULL           |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int unsigned        | NO   | MUL | 0              |                |
 * log_user_text | varchar(255) binary | NO  | MUL | NULL           |                |
 * log_namespace | int                | NO   | MUL | 0              |                |
 * log_title    | varchar(255) binary | NO   | MUL | NULL           |                |
 * log_page     | int unsigned        | YES  |     | NULL           |                |
 * log_comment  | varchar(255)        | 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 | NULL           |                |
 * log_action   | varbinary(32)       | NO   |     | NULL           |                |
 * log_timestamp | binary(14)         | NO   | MUL | 19700101000000 |                |
 * log_user     | int unsigned        | NO   | MUL | 0              |                |
 * log_user_text | varchar(255) binary | NO  |     | NULL           |                |
 * log_namespace | int                | NO   | MUL | 0              |                |
 * log_title    | varchar(255) binary | NO   | MUL | NULL           |                |
 * log_page     | int unsigned        | YES  |     | NULL           |                |
 * log_comment  | varchar(255)        | NO   |     | NULL           |                |
 * log_params   | blob                | NO   |     | NULL           |                |
 * log_deleted  | tinyint(3) unsigned | NO   |     | 0              |                |

+---+-+--+-+++ +---+-+--+-+++ +---+-+--+-+++
 * Field        | Type                | Null | Key | Default        | Extra          |
 * log_type     | varbinary(10)       | NO   | MUL | NULL           |                |
 * log_action   | varbinary(10)       | NO   |     | NULL           |                |
 * log_timestamp | binary(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           |                |
 * log_id       | int(10) unsigned    | NO   | PRI | NULL           | AUTO_INCREMENT |
 * 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           |                |

関連項目

 * m:Help:Special page#Logs