diff options
Diffstat (limited to 'extensions/CheckUser/cu_changes.sql')
-rw-r--r-- | extensions/CheckUser/cu_changes.sql | 59 |
1 files changed, 0 insertions, 59 deletions
diff --git a/extensions/CheckUser/cu_changes.sql b/extensions/CheckUser/cu_changes.sql deleted file mode 100644 index 6edc747e..00000000 --- a/extensions/CheckUser/cu_changes.sql +++ /dev/null @@ -1,59 +0,0 @@ --- 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; |