maintenance/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 /*_*/archive
   7   DROP COLUMN ar_comment,
   8   ALTER COLUMN ar_comment_id DROP DEFAULT;
   9
  10 ALTER TABLE /*_*/ipblocks
  11   DROP COLUMN ipb_reason,
  12   ALTER COLUMN ipb_reason_id DROP DEFAULT;
  13
  14 ALTER TABLE /*_*/image
  15   DROP COLUMN img_description,
  16   ALTER COLUMN img_description_id DROP DEFAULT;
  17
  18 ALTER TABLE /*_*/oldimage
  19   DROP COLUMN oi_description,
  20   ALTER COLUMN oi_description_id DROP DEFAULT;
  21
  22 ALTER TABLE /*_*/filearchive
  23   DROP COLUMN fa_deleted_reason,
  24   ALTER COLUMN fa_deleted_reason_id DROP DEFAULT,
  25   DROP COLUMN fa_description,
  26   ALTER COLUMN fa_description_id DROP DEFAULT;
  27
  28 ALTER TABLE /*_*/recentchanges
  29   DROP COLUMN rc_comment,
  30   ALTER COLUMN rc_comment_id DROP DEFAULT;
  31
  32 ALTER TABLE /*_*/logging
  33   DROP COLUMN log_comment,
  34   ALTER COLUMN log_comment_id DROP DEFAULT;
  35
  36 ALTER TABLE /*_*/protected_titles
  37   DROP COLUMN pt_reason,
  38   ALTER COLUMN pt_reason_id DROP DEFAULT;