maintenance/mssql/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 DECLARE @sql nvarchar(max),
   7         @id sysname;
   8
   9 ALTER TABLE /*_*/archive DROP CONSTRAINT DF_ar_comment, COLUMN ar_comment;
  10 ALTER TABLE /*_*/archive DROP CONSTRAINT DF_ar_comment_id;
  11
  12 ALTER TABLE /*_*/ipblocks DROP CONSTRAINT DF_ipb_reason, COLUMN ipb_reason;
  13 ALTER TABLE /*_*/ipblocks DROP CONSTRAINT DF_ipb_reason_id;
  14
  15 ALTER TABLE /*_*/image DROP CONSTRAINT DF_img_description, COLUMN img_description;
  16 ALTER TABLE /*_*/image DROP CONSTRAINT DF_img_description_id;
  17
  18 ALTER TABLE /*_*/oldimage DROP CONSTRAINT DF_oi_description, COLUMN oi_description;
  19 ALTER TABLE /*_*/oldimage DROP CONSTRAINT DF_oi_description_id;
  20
  21 ALTER TABLE /*_*/filearchive DROP CONSTRAINT DF_fa_deleted_reason, COLUMN fa_deleted_reason;
  22 ALTER TABLE /*_*/filearchive DROP CONSTRAINT DF_fa_deleted_reason_id;
  23 ALTER TABLE /*_*/filearchive DROP CONSTRAINT DF_fa_description, COLUMN fa_description;
  24 ALTER TABLE /*_*/filearchive DROP CONSTRAINT DF_fa_description_id;
  25
  26 SET @sql = 'ALTER TABLE /*_*/recentchanges DROP CONSTRAINT ';
  27 SELECT @id = df.name
  28 FROM sys.default_constraints df
  29 JOIN sys.columns c
  30         ON c.object_id = df.parent_object_id
  31         AND c.column_id = df.parent_column_id
  32 WHERE
  33         df.parent_object_id = OBJECT_ID('/*_*/recentchanges')
  34         AND c.name = 'rc_comment';
  35 SET @sql = @sql + @id;
  36 EXEC sp_executesql @sql;
  37 ALTER TABLE /*_*/recentchanges DROP COLUMN rc_comment;
  38 ALTER TABLE /*_*/recentchanges DROP CONSTRAINT DF_rc_comment_id;
  39
  40 SET @sql = 'ALTER TABLE /*_*/logging DROP CONSTRAINT ';
  41 SELECT @id = df.name
  42 FROM sys.default_constraints df
  43 JOIN sys.columns c
  44         ON c.object_id = df.parent_object_id
  45         AND c.column_id = df.parent_column_id
  46 WHERE
  47         df.parent_object_id = OBJECT_ID('/*_*/logging')
  48         AND c.name = 'log_comment';
  49 SET @sql = @sql + @id;
  50 EXEC sp_executesql @sql;
  51 ALTER TABLE /*_*/logging DROP COLUMN log_comment;
  52 ALTER TABLE /*_*/logging DROP CONSTRAINT DF_log_comment_id;
  53
  54 ALTER TABLE /*_*/protected_titles DROP CONSTRAINT DF_pt_reason, COLUMN pt_reason;
  55 ALTER TABLE /*_*/protected_titles DROP CONSTRAINT DF_pt_reason_id;