Wikibase/Schema/wb_changes

Fields

change_id

• ...

change_type

• ...

change_time

• Holds the timestamp of the edit.

change_object_id

• Holds the QID of the edited item. (?)

change_revision_id

• This is equal to the rev_id of the edit made by user.

change_user_id

• This is equal to the user_id of the user who made this edit. The value for this field is 0 for anonymous edits, initializations scripts, and for some mass imports.

change_info

• a compactDiff

Versions

Current as of Wikibase 0.4 (19 Feb 2013)

+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| change_id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| change_type        | varbinary(25)    | NO   | MUL | NULL    |                |
| change_time        | varbinary(14)    | NO   | MUL | NULL    |                |
| change_object_id   | varbinary(14)    | NO   | MUL | NULL    |                |
| change_revision_id | int(10) unsigned | NO   | MUL | NULL    |                |
| change_user_id     | int(10) unsigned | NO   | MUL | NULL    |                |
| change_info        | blob             | NO   |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+

See also

• quarry:query/3714