2 -- patch-drop-comment-fields.sql
4 -- T166732. Drop old xx_comment fields, and defaults from xx_comment_id fields.
6 ALTER TABLE &mw_prefix.archive
DROP COLUMN ar_comment
;
7 ALTER TABLE &mw_prefix.archive
MODIFY ar_comment_id
DEFAULT NULL;
9 ALTER TABLE &mw_prefix.ipblocks
DROP COLUMN ipb_reason
;
10 ALTER TABLE &mw_prefix.ipblocks
MODIFY ipb_reason_id
DEFAULT NULL;
12 ALTER TABLE &mw_prefix.image
DROP COLUMN img_description
;
13 ALTER TABLE &mw_prefix.image
MODIFY img_description_id
DEFAULT NULL;
15 ALTER TABLE &mw_prefix.oldimage
DROP COLUMN oi_description
;
16 ALTER TABLE &mw_prefix.oldimage
MODIFY oi_description_id
DEFAULT NULL;
18 ALTER TABLE &mw_prefix.filearchive
DROP COLUMN fa_deleted_reason
;
19 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_deleted_reason_id
DEFAULT NULL,
20 ALTER TABLE &mw_prefix.filearchive
DROP COLUMN fa_description
;
21 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_description_id
DEFAULT NULL;
23 ALTER TABLE &mw_prefix.recentchanges
DROP COLUMN rc_comment
;
24 ALTER TABLE &mw_prefix.recentchanges
MODIFY rc_comment_id
DEFAULT NULL;
26 ALTER TABLE &mw_prefix.logging
DROP COLUMN log_comment
;
27 ALTER TABLE &mw_prefix.logging
MODIFY log_comment_id
DEFAULT NULL;
29 ALTER TABLE &mw_prefix.protected_titles
DROP COLUMN pt_reason
;
30 ALTER TABLE &mw_prefix.protected_titles
MODIFY pt_reason_id
DEFAULT NULL;