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