maintenance/oracle/archives/patch-drop-comment-fields.sql

   1 --
   2 -- patch-drop-comment-fields.sql
   3 --
   4 -- T166732. Drop old xx_comment fields, and defaults from xx_comment_id fields.
   5
   6 ALTER TABLE &mw_prefix.archive DROP COLUMN ar_comment;
   7 ALTER TABLE &mw_prefix.archive MODIFY ar_comment_id DEFAULT NULL;
   8
   9 ALTER TABLE &mw_prefix.ipblocks DROP COLUMN ipb_reason;
  10 ALTER TABLE &mw_prefix.ipblocks MODIFY ipb_reason_id DEFAULT NULL;
  11
  12 ALTER TABLE &mw_prefix.image DROP COLUMN img_description;
  13 ALTER TABLE &mw_prefix.image MODIFY img_description_id DEFAULT NULL;
  14
  15 ALTER TABLE &mw_prefix.oldimage DROP COLUMN oi_description;
  16 ALTER TABLE &mw_prefix.oldimage MODIFY oi_description_id DEFAULT NULL;
  17
  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;
  22
  23 ALTER TABLE &mw_prefix.recentchanges DROP COLUMN rc_comment;
  24 ALTER TABLE &mw_prefix.recentchanges MODIFY rc_comment_id DEFAULT NULL;
  25
  26 ALTER TABLE &mw_prefix.logging DROP COLUMN log_comment;
  27 ALTER TABLE &mw_prefix.logging MODIFY log_comment_id DEFAULT NULL;
  28
  29 ALTER TABLE &mw_prefix.protected_titles DROP COLUMN pt_reason;
  30 ALTER TABLE &mw_prefix.protected_titles MODIFY pt_reason_id DEFAULT NULL;