diff options
Diffstat (limited to 'www/wiki/maintenance/mssql/archives/patch-add-3d.sql')
| -rw-r--r-- | www/wiki/maintenance/mssql/archives/patch-add-3d.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/www/wiki/maintenance/mssql/archives/patch-add-3d.sql b/www/wiki/maintenance/mssql/archives/patch-add-3d.sql new file mode 100644 index 00000000..51d2775f --- /dev/null +++ b/www/wiki/maintenance/mssql/archives/patch-add-3d.sql @@ -0,0 +1,27 @@ +ALTER TABLE /*$wgDBprefix*/image + DROP CONSTRAINT img_media_type_ckc; + +ALTER TABLE /*$wgDBprefix*/image + ADD CONSTRAINT img_media_type_ckc + CHECK (img_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D")); + +ALTER TABLE /*$wgDBprefix*/oldimage + DROP CONSTRAINT oi_media_type_ckc; + +ALTER TABLE /*$wgDBprefix*/oldimage + ADD CONSTRAINT oi_media_type_ckc + CHECK (oi_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D")); + +ALTER TABLE /*$wgDBprefix*/filearchive + DROP CONSTRAINT fa_media_type_ckc; + +ALTER TABLE /*$wgDBprefix*/filearchive + ADD CONSTRAINT fa_media_type_ckc + CHECK (fa_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D")); + +ALTER TABLE /*$wgDBprefix*/uploadstash + DROP CONSTRAINT us_media_type_ckc; + +ALTER TABLE /*$wgDBprefix*/uploadstash + ADD CONSTRAINT us_media_type_ckc + CHECK (us_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D")); |