1CREATE TABLE /*_*/protected_titles_tmp ( 2 pt_namespace int NOT NULL, 3 pt_title varchar(255) binary NOT NULL, 4 pt_user int unsigned NOT NULL, 5 pt_reason varbinary(767) default '', -- Deprecated. 6 pt_reason_id bigint unsigned NOT NULL DEFAULT 0, -- ("DEFAULT 0" is temporary, signaling that pt_reason should be used) 7 pt_timestamp binary(14) NOT NULL, 8 pt_expiry varbinary(14) NOT NULL default '', 9 pt_create_perm varbinary(60) NOT NULL, 10 11 PRIMARY KEY (pt_namespace,pt_title) 12) /*$wgDBTableOptions*/; 13 14INSERT INTO /*_*/protected_titles_tmp(pt_namespace, pt_title, pt_user, pt_reason, pt_reason_id, pt_timestamp, pt_expiry, pt_create_perm) 15 SELECT pt_namespace, pt_title, pt_user, pt_reason, pt_reason_id, pt_timestamp, pt_expiry, pt_create_perm FROM /*_*/protected_titles; 16 17DROP TABLE /*_*/protected_titles; 18 19ALTER TABLE /*_*/protected_titles_tmp RENAME TO /*_*/protected_titles; 20 21CREATE INDEX /*i*/pt_timestamp ON /*_*/protected_titles (pt_timestamp); 22