3 DROP TABLE IF EXISTS /*_*/oldimage_tmp
;
4 CREATE TABLE /*_*/oldimage_tmp (
5 oi_name
varchar(255) binary NOT NULL default '',
6 oi_archive_name
varchar(255) binary NOT NULL default '',
7 oi_size
int unsigned
NOT NULL default 0,
8 oi_width
int NOT NULL default 0,
9 oi_height
int NOT NULL default 0,
10 oi_bits
int NOT NULL default 0,
11 oi_description
varbinary(767) NOT NULL default '',
12 oi_description_id
bigint unsigned
NOT NULL DEFAULT 0,
13 oi_user
int unsigned
NOT NULL default 0,
14 oi_user_text
varchar(255) binary NOT NULL,
15 oi_timestamp
binary(14) NOT NULL default '',
16 oi_metadata mediumblob
NOT NULL,
17 oi_media_type
ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D") default NULL,
18 oi_major_mime
ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart", "chemical") NOT NULL default "unknown",
19 oi_minor_mime
varbinary(100) NOT NULL default "unknown",
20 oi_deleted tinyint unsigned
NOT NULL default 0,
21 oi_sha1
varbinary(32) NOT NULL default ''
22 ) /*$wgDBTableOptions*/;
24 INSERT OR IGNORE INTO /*_*/oldimage_tmp (
25 oi_name
, oi_archive_name
, oi_size
, oi_width
, oi_height
, oi_bits
,
26 oi_description
, oi_user
, oi_user_text
, oi_timestamp
, oi_metadata
,
27 oi_media_type
, oi_major_mime
, oi_minor_mime
, oi_deleted
, oi_sha1
)
29 oi_name
, oi_archive_name
, oi_size
, oi_width
, oi_height
, oi_bits
,
30 oi_description
, oi_user
, oi_user_text
, oi_timestamp
, oi_metadata
,
31 oi_media_type
, oi_major_mime
, oi_minor_mime
, oi_deleted
, oi_sha1
34 DROP TABLE /*_*/oldimage
;
35 ALTER TABLE /*_*/oldimage_tmp
RENAME TO /*_*/oldimage
;
36 CREATE INDEX /*i*/oi_usertext_timestamp
ON /*_*/oldimage (oi_user_text
,oi_timestamp
);
37 CREATE INDEX /*i*/oi_name_timestamp
ON /*_*/oldimage (oi_name
,oi_timestamp
);
38 CREATE INDEX /*i*/oi_name_archive_name
ON /*_*/oldimage (oi_name
,oi_archive_name(14));
39 CREATE INDEX /*i*/oi_sha1
ON /*_*/oldimage (oi_sha1(10));