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
↑ 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.