Help:Transactions table

↑ Help:Index

Database layout

Transactions table

The Transactions table records when and by whom an object (expression, syntrans, definedmeaning, definition, etc.) was added or removed. Typically, when a user makes changes and click the "save" button, it is one transaction, even if several changes were made.

+----------------+-------------+------+-----+---------+----------------+
| Field          | Type        | Null | Key | Default | Extra          |
+----------------+-------------+------+-----+---------+----------------+
| transaction_id | int(11)     | NO   | PRI | NULL    | auto_increment | 
| user_id        | int(5)      | NO   | MUL | NULL    |                | 
| user_ip        | varchar(15) | YES  |     | NULL    |                | 
| timestamp      | varchar(14) | YES  |     | NULL    |                | 
| comment        | tinyblob    | NO   |     | NULL    |                | 
+----------------+-------------+------+-----+---------+----------------+

Fields

transaction_id 

A number that identifies the transaction (primary key)

user_id 

The id of the user who did the transaction. See http://www.mediawiki.org/wiki/Manual:User_table needs to be expanded to intp(10) as per newer versions of MediaWiki, T116581

user_ip 

The IP of the user. not clear why this is stored

timestamp 

The time when the transaction was made, in the form 20060908104024, i.e. 2006-09-08 10:40:24

comment 

The comment written by the user in the summary field.