Add CheckUser extension

* revision 73143
* url: http://www.mediawiki.org/wiki/Extension:CheckUser

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;