2 -- patch-protected_titles-drop-pt_reason.sql
4 -- T166732. Drop old xx_comment fields, and defaults from xx_comment_id fields.
8 DROP TABLE IF EXISTS /*_*/protected_titles_tmp
;
9 CREATE TABLE /*_*/protected_titles_tmp (
10 pt_namespace
int NOT NULL,
11 pt_title
varchar(255) binary NOT NULL,
12 pt_user
int unsigned
NOT NULL,
13 pt_reason_id
bigint unsigned
NOT NULL,
14 pt_timestamp
binary(14) NOT NULL,
15 pt_expiry
varbinary(14) NOT NULL default '',
16 pt_create_perm
varbinary(60) NOT NULL,
17 PRIMARY KEY (pt_namespace
,pt_title
)
18 ) /*$wgDBTableOptions*/;
20 INSERT OR IGNORE INTO /*_*/protected_titles_tmp (
21 pt_namespace
, pt_title
, pt_user
, pt_reason_id
, pt_timestamp
, pt_expiry
, pt_create_perm
23 pt_namespace
, pt_title
, pt_user
, pt_reason_id
, pt_timestamp
, pt_expiry
, pt_create_perm
24 FROM /*_*/protected_titles
;
26 DROP TABLE /*_*/protected_titles
;
27 ALTER TABLE /*_*/protected_titles_tmp
RENAME TO /*_*/protected_titles
;
28 CREATE INDEX /*i*/pt_timestamp
ON /*_*/protected_titles (pt_timestamp
);