Every log action in MediaWiki is logged in the
logging
table.
Users can see those edits on
Special:Log
, except for a few restricted logs (like Special:Log/suppress).
The contents of this table is what you see on the
Special:Log
page.
For example:
14:18, 25 June 2008 Jacksprat (Talk | contribs| block) uploaded "Image:Climb.jpg" (Added this image for the climbing page)
Fields
[
edit
]
log_id
[
edit
]
MediaWiki version:
|
≥
1.10
|
Primary key for the table.
rc_logid
is a foreign key linking to this column.
log_type
[
edit
]
The type of the log action, or the "log type".
You can filter by some values of this type on
Special:Log
.
Comparable to
rc_log_type
.
Example values from
some Wikimedia wikis
are as follows (including now-obsolete logs and several extensions):
- 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
[
edit
]
The action performed.
There may be multiple actions possible for a given type: for example, an entry with the type
delete
may have the action
delete
or
restore
, etc.
Comparable to
rc_log_action
.
See also
API:Logevents
.
See
Manual:Log actions
.
log_timestamp
[
edit
]
The time the action was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss ("14:18, 25 June 2008" in example).
Has the same value as the corresponding
recentchanges.rc_timestamp
and
revision.rev_timestamp
.
Does not necessarily have the same value as the corresponding
image.img_timestamp
, in the case of file uploads.
log_user
[
edit
]
MediaWiki version:
|
≤
1.33
|
The
id
of the user who performed the action.
This is a reference into the
user
table (the user id of "Jacksprat" in example).
Comparable to
rc_user
and
rev_user
.
Deprecated in favor of
log_actor
.
log_user_text
[
edit
]
MediaWiki version:
|
≥
1.16
|
user_name
of the user who performed the action, intended primarily for anonymous users, fillable by maintenance/populateLogUsertext.php.
Comparable to
rc_user_text
and
rev_user_text
.
Deprecated in favor of
log_actor
.
log_actor
[
edit
]
This is a foreign key to
actor_id
in the
actor
table, corresponding to the user (registered or anonymous) who performed the action.
log_namespace
[
edit
]
The
namespace
of the affected page.
Together with log_title, this is a reference into the
page
table ("Image:Climb.jpg" in example).
Comparable to
rc_namespace
.
logging table may contain rows with log_namespace < 0:
- Special:Renameuser with log_type and log_action being either "" or "renameuser"
- Special:Userlogin with log_type being "newusers" and log_action e.g. being "create"
log_title
[
edit
]
The
title
of the affected page.
Together with log_namespace, this is a reference into the
page
table.
Comparable to
rc_title
The title is also known as the log entry's 'target'.
For user blocks, this is the blocked user's username.
For thanks action, this is the thanked user's username.
log_page
[
edit
]
MediaWiki version:
|
≥
1.16
|
The
page_id
that this log action is about.
Comparable to
rc_cur_id
and
rev_page
.
In the case of a page move, this is set to the page_id of the moved page (since
Gerrit change 157872
).
Formerly, it was the page_id of the redirect, or 0 if the page was moved without creating a redirect.
MediaWiki version:
|
≤
1.32
|
The comment given for the action; that is the upload comment for uploads, the deletion comment for deletions, etc.
Comparable to
rc_comment
and
rev_comment
.
(deprecated)
; log_comment_id and the
comment
table should be used instead!
MediaWiki version:
|
≥
1.30
|
This is a foreign key to
comment_id
in the
comment
table.
log_params
[
edit
]
Additional parameters, usually empty.
Mirrored in
rc_params
.
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
noredir
.
For other examples, see
Manual:Log parameters
.
MediaWiki version:
|
≥
1.19
|
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%'
MediaWiki version:
|
≥
1.21
|
Since
1.21
, 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
log_search
to facilitate indexed queries.
Log parameters are typically set using functions such as
ManualLogEntry::setParameters()
and
LogPage::addEntry()
.
log_deleted
[
edit
]
MediaWiki version:
|
≥
1.10
|
Used with the
RevisionDelete
system to delete log entries.
Comparable to
rc_deleted
and
rev_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.
Schema summary
[
edit
]
MediaWiki version:
|
≥
1.34
|
DESCRIBE
logging
;
+----------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+----------------+---------------------+------+-----+----------------+----------------+
DESCRIBE
logging
;
+----------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+----------------+---------------------+------+-----+----------------+----------------+
MediaWiki versions:
|
1.31 – 1.32
|
DESCRIBE
logging
;
+----------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+----------------+---------------------+------+-----+----------------+----------------+
DESCRIBE
logging
;
+----------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+----------------+---------------------+------+-----+----------------+----------------+
MediaWiki versions:
|
1.25 – 1.29
|
DESCRIBE
logging
;
+---------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+---------------+---------------------+------+-----+----------------+----------------+
MediaWiki versions:
|
1.23 – 1.24
|
DESCRIBE
logging
;
+---------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+---------------+---------------------+------+-----+----------------+----------------+
MediaWiki versions:
|
1.16 – 1.22
|
DESCRIBE
logging
;
+---------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+---------------+---------------------+------+-----+----------------+----------------+
MediaWiki versions:
|
1.13 – 1.15
|
DESCRIBE
logging
;
+---------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+---------------+---------------------+------+-----+----------------+----------------+
MediaWiki versions:
|
1.10 – 1.12
|
DESCRIBE
logging
;
+---------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+---------------+---------------------+------+-----+----------------+----------------+
MediaWiki versions:
|
1.6 – 1.9
|
DESCRIBE
logging
;
+---------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+---------------+---------------------+------+-----+----------------+----------------+
DESCRIBE
logging
;
+---------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+---------------+---------------------+------+-----+----------------+----------------+
DESCRIBE
logging
;
+---------------+---------------------+------+-----+----------------+----------------+
| 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 | |
+---------------+---------------------+------+-----+----------------+----------------+
Indexes
[
edit
]
MediaWiki version:
|
≥
1.36
|
SHOW
INDEX
IN
logging
;
+---------+------------+---------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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 | | |
+---------+------------+---------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
See also
[
edit
]
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|
|
---|
Events
| |
---|
Settings
| |
---|
Miscellaneous
| |
---|