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 |