4 -- Add data to allow for direct reference to old images
5 -- They can be included into pages
8 ALTER TABLE /*$wgDBprefix*/oldimage
10 ADD INDEX oi_name_timestamp (oi_name
,oi_timestamp
),
11 ADD INDEX oi_name_archive_name (oi_name
,oi_archive_name
),
12 ADD oi_metadata mediumblob
NOT NULL,
13 ADD oi_media_type
ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL,
14 ADD oi_major_mime
ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") NOT NULL default "unknown",
15 ADD oi_minor_mime
varchar(32) NOT NULL default "unknown",
16 ADD oi_deleted
tinyint(1) unsigned
NOT NULL default '0';