diff options
Diffstat (limited to 'extensions/CheckUser/cu_changes.sql')
-rw-r--r-- | extensions/CheckUser/cu_changes.sql | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/extensions/CheckUser/cu_changes.sql b/extensions/CheckUser/cu_changes.sql new file mode 100644 index 00000000..6edc747e --- /dev/null +++ b/extensions/CheckUser/cu_changes.sql @@ -0,0 +1,59 @@ +-- Tables for the CheckUser extension +-- vim: autoindent syn=mysql sts=2 sw=2 +-- Replace /*$wgDBprefix*/ with the proper prefix + +CREATE TABLE /*$wgDBprefix*/cu_changes ( + -- Primary key + cuc_id INTEGER NOT NULL AUTO_INCREMENT, + + -- When pages are renamed, their RC entries do _not_ change. + cuc_namespace int NOT NULL default '0', + cuc_title varchar(255) binary NOT NULL default '', + + -- user.user_id + cuc_user INTEGER NOT NULL DEFAULT 0, + cuc_user_text VARCHAR(255) NOT NULL DEFAULT '', + + -- Edit summary + cuc_actiontext varchar(255) binary NOT NULL default '', + cuc_comment varchar(255) binary NOT NULL default '', + cuc_minor bool NOT NULL default '0', + + -- Key to page_id (was cur_id prior to 1.5). + -- This will keep links working after moves while + -- retaining the at-the-time name in the changes list. + cuc_page_id int(10) unsigned NOT NULL default '0', + + -- rev_id of the given revision + cuc_this_oldid int(10) unsigned NOT NULL default '0', + + -- rev_id of the prior revision, for generating diff links. + cuc_last_oldid int(10) unsigned NOT NULL default '0', + + -- Edit/new/log + cuc_type tinyint(3) unsigned NOT NULL default '0', + + -- Event timestamp + cuc_timestamp CHAR(14) NOT NULL default '', + + -- IP address, visible + cuc_ip VARCHAR(255) NULL default '', + + -- IP address as hexidecimal + cuc_ip_hex VARCHAR(255) default NULL, + + -- XFF header, visible, all data + cuc_xff VARCHAR(255) BINARY NULL default '', + + -- XFF header, last IP, as hexidecimal + cuc_xff_hex VARCHAR(255) default NULL, + + -- User agent + cuc_agent VARCHAR(255) BINARY default NULL, + + PRIMARY KEY cuc_id (cuc_id), + INDEX cuc_ip_hex_time (cuc_ip_hex,cuc_timestamp), + INDEX cuc_user_ip_time (cuc_user,cuc_ip,cuc_timestamp), + INDEX cuc_xff_hex_time (cuc_xff_hex,cuc_timestamp), + INDEX (cuc_timestamp) +) TYPE=InnoDB; |