maintenance/archives/patch-img_media_type.sql

   1 -- media type columns, added for 1.5
   2 -- this alters the scheme for 1.5, img_type is no longer used.
   3
   4 ALTER TABLE /*$wgDBprefix*/image ADD (
   5   -- Media type as defined by the MEDIATYPE_xxx constants
   6   img_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL,
   7
   8   -- major part of a MIME media type as defined by IANA
   9   -- see https://www.iana.org/assignments/media-types/
  10   img_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") NOT NULL default "unknown",
  11
  12   -- minor part of a MIME media type as defined by IANA
  13   -- the minor parts are not required to adher to any standard
  14   -- but should be consistent throughout the database
  15   -- see https://www.iana.org/assignments/media-types/
  16   img_minor_mime varbinary(32) NOT NULL default "unknown"
  17 );