Manual:Logging table

New to version 1.5.

DESCRIBE logging results in:

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

The content of this table is basically what you see on the Special:Log page.


 * log_type: The type of the log action, or the "log type". You can filter by this type on Special:Log. Typical values are: block, delete, import, makebot, move, newusers, protect, renameuser, rights, upload
 * log_action: 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. Typical values are: upload, delete, protect, block, unprotect, restore, unblock, rights, move, move_redir, renameuser, newusers, create, create2, grant, interwiki, revoke
 * log_timestamp: the time the action was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss
 * log_user: the id of the user who performed the action. This is a reference into the user table
 * log_namespace: the namespace of the affected page. Together with log_title, this is a reference into the page table
 * Note: 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 and log_action being "newusers"


 * log_title: the title of the affected page. Together with log_namespace, this is a reference into the page table
 * log_comment: the comment given for the action; that is the upload comment for uploads, the deletion comment for deletions, etc
 * log_params: additional parameters, usually empty. For user blocks, this contains the duration of the block, in human readable form. For page moves, this contains the location the page was moved to.


 * log_id: primary key for the table.

"DESCRIBE logging" in MediaWiki 1.8 results in: +---+--+--+-++---+ +---+--+--+-++---+ +---+--+--+-++---+
 * 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(10) unsigned | NO   | MUL | 0              |       |
 * log_namespace | int(11)         | NO   | MUL | 0              |       |
 * log_title    | varchar(255)     | NO   |     | NULL           |       |
 * log_comment  | varchar(255)     | NO   |     | NULL           |       |
 * log_params   | blob             | NO   |     | NULL           |       |

mysql> describe mw_logging; +---+--+--+-++---+ +---+--+--+-++---+ +---+--+--+-++---+ 8 rows in set (0.02 sec)
 * 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(10) unsigned | NO   | MUL | 0              |       |
 * log_namespace | int(11)         | NO   | MUL | 0              |       |
 * log_title    | varchar(255)     | NO   |     | NULL           |       |
 * log_comment  | varchar(255)     | NO   |     | NULL           |       |
 * log_params   | blob             | NO   |     | NULL           |       |

mysql> describe mw_logging; +---+--+--+-+++ +---+--+--+-+++ +---+--+--+-+++ 9 rows in set (0.02 sec)
 * 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(10) unsigned | NO   | MUL | 0              |                |
 * log_namespace | int(11)         | NO   | MUL | 0              |                |
 * log_title    | varchar(255)     | NO   |     | NULL           |                |
 * log_comment  | varchar(255)     | NO   |     | NULL           |                |
 * log_params   | blob             | NO   |     | NULL           |                |
 * log_id       | int(10) unsigned | NO   | PRI | NULL           | auto_increment |