As an anonymous user, you can only add new data. If you would like to also modify existing data, please create an account and indicate your languages on your user page.

Help:Transactions table

From OmegaWiki
Jump to: navigation, search
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[edit]

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.