2 -- patch-logging-drop-log_comment.sql
4 -- T166732. Drop old xx_comment fields, and defaults from xx_comment_id fields.
8 DROP TABLE IF EXISTS /*_*/logging_tmp
;
9 CREATE TABLE /*_*/logging_tmp (
10 log_id
int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT
,
11 log_type
varbinary(32) NOT NULL default '',
12 log_action
varbinary(32) NOT NULL default '',
13 log_timestamp
binary(14) NOT NULL default '19700101000000',
14 log_user
int unsigned
NOT NULL default 0,
15 log_user_text
varchar(255) binary NOT NULL default '',
16 log_actor
bigint unsigned
NOT NULL DEFAULT 0,
17 log_namespace
int NOT NULL default 0,
18 log_title
varchar(255) binary NOT NULL default '',
19 log_page
int unsigned
NULL,
20 log_comment_id
bigint unsigned
NOT NULL,
21 log_params
blob NOT NULL,
22 log_deleted tinyint unsigned
NOT NULL default 0
23 ) /*$wgDBTableOptions*/;
25 INSERT OR IGNORE INTO /*_*/logging_tmp (
26 log_id
, log_type
, log_action
, log_timestamp
, log_user
, log_user_text
, log_actor
,
27 log_namespace
, log_title
, log_page
, log_comment_id
, log_params
, log_deleted
29 log_id
, log_type
, log_action
, log_timestamp
, log_user
, log_user_text
, log_actor
,
30 log_namespace
, log_title
, log_page
, log_comment_id
, log_params
, log_deleted
33 DROP TABLE /*_*/logging
;
34 ALTER TABLE /*_*/logging_tmp
RENAME TO /*_*/logging
;
35 CREATE INDEX /*i*/type_time
ON /*_*/logging (log_type
, log_timestamp
);
36 CREATE INDEX /*i*/user_time
ON /*_*/logging (log_user
, log_timestamp
);
37 CREATE INDEX /*i*/actor_time
ON /*_*/logging (log_actor
, log_timestamp
);
38 CREATE INDEX /*i*/page_time
ON /*_*/logging (log_namespace
, log_title
, log_timestamp
);
39 CREATE INDEX /*i*/times
ON /*_*/logging (log_timestamp
);
40 CREATE INDEX /*i*/log_user_type_time
ON /*_*/logging (log_user
, log_type
, log_timestamp
);
41 CREATE INDEX /*i*/log_actor_type_time
ON /*_*/logging (log_actor
, log_type
, log_timestamp
);
42 CREATE INDEX /*i*/log_page_id_time
ON /*_*/logging (log_page
,log_timestamp
);
43 CREATE INDEX /*i*/log_type_action
ON /*_*/logging (log_type
, log_action
, log_timestamp
);
44 CREATE INDEX /*i*/log_user_text_type_time
ON /*_*/logging (log_user_text
, log_type
, log_timestamp
);
45 CREATE INDEX /*i*/log_user_text_time
ON /*_*/logging (log_user_text
, log_timestamp
);