3 DROP TABLE IF EXISTS /*_*/logging_tmp
;
4 CREATE TABLE /*_*/logging_tmp (
5 log_id
int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT
,
6 log_type
varbinary(32) NOT NULL default '',
7 log_action
varbinary(32) NOT NULL default '',
8 log_timestamp
binary(14) NOT NULL default '19700101000000',
9 log_user
int unsigned
NOT NULL default 0,
10 log_user_text
varchar(255) binary NOT NULL default '',
11 log_actor
bigint unsigned
NOT NULL DEFAULT 0,
12 log_namespace
int NOT NULL default 0,
13 log_title
varchar(255) binary NOT NULL default '',
14 log_page
int unsigned
NULL,
15 log_comment
varbinary(767) NOT NULL default '',
16 log_comment_id
bigint unsigned
NOT NULL DEFAULT 0,
17 log_params
blob NOT NULL,
18 log_deleted tinyint unsigned
NOT NULL default 0
19 ) /*$wgDBTableOptions*/;
21 INSERT OR IGNORE INTO /*_*/logging_tmp (
22 log_id
, log_type
, log_action
, log_timestamp
, log_user
, log_user_text
,
23 log_namespace
, log_title
, log_page
, log_comment
, log_comment_id
,
24 log_params
, log_deleted
)
26 log_id
, log_type
, log_action
, log_timestamp
, log_user
, log_user_text
,
27 log_namespace
, log_title
, log_page
, log_comment
, log_comment_id
,
28 log_params
, log_deleted
31 DROP TABLE /*_*/logging
;
32 ALTER TABLE /*_*/logging_tmp
RENAME TO /*_*/logging
;
33 CREATE INDEX /*i*/type_time
ON /*_*/logging (log_type
, log_timestamp
);
34 CREATE INDEX /*i*/user_time
ON /*_*/logging (log_user
, log_timestamp
);
35 CREATE INDEX /*i*/actor_time
ON /*_*/logging (log_actor
, log_timestamp
);
36 CREATE INDEX /*i*/page_time
ON /*_*/logging (log_namespace
, log_title
, log_timestamp
);
37 CREATE INDEX /*i*/times
ON /*_*/logging (log_timestamp
);
38 CREATE INDEX /*i*/log_user_type_time
ON /*_*/logging (log_user
, log_type
, log_timestamp
);
39 CREATE INDEX /*i*/log_actor_type_time
ON /*_*/logging (log_actor
, log_type
, log_timestamp
);
40 CREATE INDEX /*i*/log_page_id_time
ON /*_*/logging (log_page
,log_timestamp
);
41 CREATE INDEX /*i*/type_action
ON /*_*/logging (log_type
, log_action
, log_timestamp
);
42 CREATE INDEX /*i*/log_user_text_type_time
ON /*_*/logging (log_user_text
, log_type
, log_timestamp
);
43 CREATE INDEX /*i*/log_user_text_time
ON /*_*/logging (log_user_text
, log_timestamp
);