1 CREATE TABLE /*_*/logging_temp (
2 log_id INTEGER NOT NULL,
3 log_type BLOB DEFAULT '' NOT NULL,
4 log_action BLOB DEFAULT '' NOT NULL,
5 log_timestamp BLOB DEFAULT '19700101000000' NOT NULL,
6 log_actor BIGINT UNSIGNED NOT NULL,
7 log_namespace INTEGER DEFAULT 0 NOT NULL,
8 log_title BLOB DEFAULT '' NOT NULL,
9 log_page INTEGER UNSIGNED DEFAULT NULL,
10 log_comment_id BIGINT UNSIGNED NOT NULL,
11 log_params BLOB NOT NULL,
12 log_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
17 INSERT INTO /*_*/logging_temp
18 SELECT log_id, log_type, log_action, log_timestamp, log_actor, log_namespace, log_title, log_page, log_comment_id, log_params, log_deleted
20 DROP TABLE /*_*/logging;
21 ALTER TABLE /*_*/logging_temp RENAME TO /*_*/logging;
24 CREATE INDEX type_time ON /*_*/logging (log_type, log_timestamp);
26 CREATE INDEX actor_time ON /*_*/logging (log_actor, log_timestamp);
28 CREATE INDEX page_time ON /*_*/logging (
29 log_namespace, log_title, log_timestamp
32 CREATE INDEX times ON /*_*/logging (log_timestamp);
34 CREATE INDEX log_actor_type_time ON /*_*/logging (
35 log_actor, log_type, log_timestamp
38 CREATE INDEX log_page_id_time ON /*_*/logging (log_page, log_timestamp);
40 CREATE INDEX log_type_action ON /*_*/logging (
41 log_type, log_action, log_timestamp