1 CREATE 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,
11 PRIMARY KEY (pt_namespace
,pt_title
)
12 ) /*$wgDBTableOptions*/;
14 INSERT INTO /*_*/protected_titles_tmp
15 SELECT * FROM /*_*/protected_titles
;
17 DROP TABLE /*_*/protected_titles
;
19 ALTER TABLE /*_*/protected_titles_tmp
RENAME TO /*_*/protected_titles
;
21 CREATE INDEX /*i*/pt_timestamp
ON /*_*/protected_titles (pt_timestamp
);