1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
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;
|
