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
|
-- CheckUser log table
-- vim: autoindent syn=mysql sts=2 sw=2
CREATE TABLE /*_*/cu_log (
-- Unique identifier
cul_id int unsigned not null primary key auto_increment,
-- Timestamp of CheckUser action
cul_timestamp binary(14) not null,
-- User who performed the action
cul_user int unsigned not null,
cul_user_text varchar(255) binary not null,
-- Reason given
cul_reason varchar(255) binary not null,
-- String indicating the type of query, may be:
-- "useredits", "userips", "ipedits", "ipusers", "ipedits-xff", "ipusers-xff"
-- or "investigate" if the check was performed from Special:Investigate
cul_type varbinary(30) not null,
-- Integer target, interpretation depends on cul_type
-- For username targets, this is the user_id
cul_target_id int unsigned not null default 0,
-- Text target, interpretation depends on cul_type
cul_target_text blob not null,
-- If the target was an IP address, this contains the hexadecimal form of the IP
cul_target_hex varbinary(255) not null default '',
-- If the target was an IP range, these fields contain the start and end, in hex form
cul_range_start varbinary(255) not null default '',
cul_range_end varbinary(255) not null default ''
) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/cul_user ON /*_*/cu_log (cul_user, cul_timestamp);
CREATE INDEX /*i*/cul_type_target ON /*_*/cu_log (cul_type,cul_target_id, cul_timestamp);
CREATE INDEX /*i*/cul_target_hex ON /*_*/cu_log (cul_target_hex, cul_timestamp);
CREATE INDEX /*i*/cul_range_start ON /*_*/cu_log (cul_range_start, cul_timestamp);
CREATE INDEX /*i*/cul_timestamp ON /*_*/cu_log (cul_timestamp);
|
GitWeb
