LiquidThreads/Implementation
From WikiEducator
LiquidThreads is implemented as a Mediawiki extension. WikiEducator is currently using version 1.2, at least in part because upgrade to version 2.0 appears to fail for some threads.
Contents
LQT 1.2 Database Schema
mw_historical_thread
Note many hthreads can share an id, which is the same as the id
of the live thread. It is only the id/revision combo which must be unique.
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| hthread_id | int(8) unsigned | NO | PRI | NULL | |
| hthread_revision | int(8) unsigned | NO | PRI | NULL | |
| hthread_contents | blob | NO | NULL | ||
| hthread_change_type | int(4) unsigned | NO | NULL | ||
| hthread_change_object | int(8) unsigned | YES | NULL |
mw_thread
| Field | Type | Null | Key | Default | Extra | |
|---|---|---|---|---|---|---|
| thread_id | int(8) unsigned | NO | PRI | NULL | auto_increment | |
| thread_root | int(8) unsigned | NO | UNI | NULL | ||
| thread_summary_page | int(8) unsigned | YES | MUL | NULL | ||
| thread_modified | char(14) | NO | MUL | 20111122215830 | ||
| thread_revision | int(8) unsigned | NO | 1 | |||
| thread_article_namespace | int(11) | NO | MUL | NULL | ||
| thread_article_title | varchar(255) | NO | NULL | |||
| thread_type | int(4) unsigned | NO | 0 | TYPE_NORMAL = 0 TYPE_MOVED = 1 TYPE_DELETED = 2 | ||
| thread_change_type | int(4) unsigned | NO | NULL | CHANGE_NEW_THREAD = 0 CHANGE_REPLY_CREATED = 1 CHANGE_EDITED_ROOT = 2 CHANGE_EDITED_SUMMARY = 3 CHANGE_DELETED = 4 CHANGE_UNDELETED = 5 CHANGE_MOVED_TALKPAGE = 6 | ||
| thread_change_object | int(8) unsigned | YES | NULL | |||
| thread_change_comment | tinyblob | NO | NULL | |||
| thread_change_user | int(10) unsigned | NO | 0 | |||
| thread_change_user_text | varchar(255) | NO | ||||
| thread_ancestor | int(8) unsigned | NO | MUL | NULL | ||
| thread_parent | int(8) unsigned | YES | NULL | |||
| thread_created | char(14) | NO | MUL | 20111122215830 | ||
| thread_editedness | int(1) | NO | 0 | EDITED_NEVER = 0 EDITED_HAS_REPLY = 1 EDITED_BY_AUTHOR = 2 EDITED_BY_OTHERS = 3 |
mw_user_messagestate
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| ums_user | int(10) unsigned | NO | PRI | NULL | |
| ums_thread | int(8) unsigned | NO | PRI | NULL | |
| ums_read_timestamp | varbinary(14) | YES | NULL |
mw_user_newtalk
Standard Mediawiki table.
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| user_id | int(5) | NO | MUL | 0 | |
| user_ip | varchar(40) | NO | MUL | ||
| user_last_timestamp | binary(14) | NO |
