diff options
Diffstat (limited to 'www/wiki/maintenance/mssql/archives/patch-oldimage-constraints.sql')
-rw-r--r-- | www/wiki/maintenance/mssql/archives/patch-oldimage-constraints.sql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/www/wiki/maintenance/mssql/archives/patch-oldimage-constraints.sql b/www/wiki/maintenance/mssql/archives/patch-oldimage-constraints.sql new file mode 100644 index 00000000..69ede2c4 --- /dev/null +++ b/www/wiki/maintenance/mssql/archives/patch-oldimage-constraints.sql @@ -0,0 +1,34 @@ +DECLARE @baseSQL nvarchar(max), + @SQL nvarchar(max), + @id sysname;-- + +SET @baseSQL = 'ALTER TABLE /*_*/oldimage DROP CONSTRAINT ';-- + +SELECT @id = cc.name +FROM sys.check_constraints cc +JOIN sys.columns c + ON c.object_id = cc.parent_object_id + AND c.column_id = cc.parent_column_id +WHERE + cc.parent_object_id = OBJECT_ID('/*_*/oldimage') + AND c.name = 'oi_major_mime';-- + +SET @SQL = @baseSQL + @id;-- + +EXEC sp_executesql @SQL;-- + +SELECT @id = cc.name +FROM sys.check_constraints cc +JOIN sys.columns c + ON c.object_id = cc.parent_object_id + AND c.column_id = cc.parent_column_id +WHERE + cc.parent_object_id = OBJECT_ID('/*_*/oldimage') + AND c.name = 'oi_media_type';-- + +SET @SQL = @baseSQL + @id;-- + +EXEC sp_executesql @SQL;-- + +ALTER TABLE /*_*/oldimage ADD CONSTRAINT oi_major_mime_ckc check (oi_major_mime IN('unknown', 'application', 'audio', 'image', 'text', 'video', 'message', 'model', 'multipart'));-- +ALTER TABLE /*_*/oldimage ADD CONSTRAINT oi_media_type_ckc check (oi_media_type in('UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO', 'VIDEO', 'MULTIMEDIA', 'OFFICE', 'TEXT', 'EXECUTABLE', 'ARCHIVE')); |