maintenance/mssql/archives/patch-add-3d.sql

   1 ALTER TABLE /*$wgDBprefix*/image
   2         DROP CONSTRAINT img_media_type_ckc;
   3
   4 ALTER TABLE /*$wgDBprefix*/image
   5         ADD CONSTRAINT img_media_type_ckc
   6         CHECK (img_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D"));
   7
   8 ALTER TABLE /*$wgDBprefix*/oldimage
   9         DROP CONSTRAINT oi_media_type_ckc;
  10
  11 ALTER TABLE /*$wgDBprefix*/oldimage
  12         ADD CONSTRAINT oi_media_type_ckc
  13         CHECK (oi_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D"));
  14
  15 ALTER TABLE /*$wgDBprefix*/filearchive
  16         DROP CONSTRAINT fa_media_type_ckc;
  17
  18 ALTER TABLE /*$wgDBprefix*/filearchive
  19         ADD CONSTRAINT fa_media_type_ckc
  20         CHECK (fa_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D"));
  21
  22 ALTER TABLE /*$wgDBprefix*/uploadstash
  23         DROP CONSTRAINT us_media_type_ckc;
  24
  25 ALTER TABLE /*$wgDBprefix*/uploadstash
  26         ADD CONSTRAINT us_media_type_ckc
  27         CHECK (us_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D"));