maintenance/mssql/archives/patch-rc_patrolled_type.sql

   1 DECLARE @cname sysname;--
   2
   3 SELECT @cname = dc.name
   4 FROM sys.default_constraints dc
   5 JOIN sys.columns c
   6         ON c.object_id = dc.parent_object_id
   7         AND c.column_id = dc.parent_column_id
   8 WHERE
   9         c.name = 'rc_patrolled'
  10         AND c.object_id = OBJECT_ID('/*_*/recentchanges', 'U');--
  11
  12 IF @cname IS NOT NULL
  13 BEGIN;--
  14         DECLARE @sql nvarchar(max);--
  15         SET @sql = N'ALTER TABLE /*_*/recentchanges DROP CONSTRAINT ' + @cname;--
  16         EXEC sp_executesql @sql;--
  17 END;--
  18
  19 DROP INDEX /*i*/rc_name_type_patrolled_timestamp ON /*_*/recentchanges;--
  20 ALTER TABLE /*_*/recentchanges ALTER COLUMN rc_patrolled tinyint NOT NULL;--
  21 ALTER TABLE /*_*/recentchanges ADD CONSTRAINT DF_rc_patrolled DEFAULT 0 FOR rc_patrolled;--
  22 CREATE INDEX /*i*/rc_name_type_patrolled_timestamp ON /*_*/recentchanges (rc_namespace, rc_type, rc_patrolled, rc_timestamp);