3 DROP TABLE IF EXISTS /*_*/protected_titles_tmp
;
4 CREATE TABLE /*_*/protected_titles_tmp (
5 pt_namespace
int NOT NULL,
6 pt_title
varchar(255) binary NOT NULL,
7 pt_user
int unsigned
NOT NULL,
8 pt_reason
varbinary(767) default '',
9 pt_reason_id
bigint unsigned
NOT NULL DEFAULT 0,
10 pt_timestamp
binary(14) NOT NULL,
11 pt_expiry
varbinary(14) NOT NULL default '',
12 pt_create_perm
varbinary(60) NOT NULL
13 ) /*$wgDBTableOptions*/;
15 INSERT OR IGNORE INTO /*_*/protected_titles_tmp (
16 pt_namespace
, pt_title
, pt_user
, pt_reason
, pt_timestamp
, pt_expiry
, pt_create_perm
)
18 pt_namespace
, pt_title
, pt_user
, pt_reason
, pt_timestamp
, pt_expiry
, pt_create_perm
19 FROM /*_*/protected_titles
;
21 DROP TABLE /*_*/protected_titles
;
22 ALTER TABLE /*_*/protected_titles_tmp
RENAME TO /*_*/protected_titles
;
23 CREATE UNIQUE INDEX /*i*/pt_namespace_title
ON /*_*/protected_titles (pt_namespace
,pt_title
);
24 CREATE INDEX /*i*/pt_timestamp
ON /*_*/protected_titles (pt_timestamp
);