2 -- patch-oldimage-drop-oi_user.sql
4 -- T188327. Drop old xx_user and xx_user_text fields, and defaults from xx_actor fields.
8 DROP TABLE IF EXISTS /*_*/oldimage_tmp
;
9 CREATE TABLE /*_*/oldimage_tmp (
10 oi_name
varchar(255) binary NOT NULL default '',
11 oi_archive_name
varchar(255) binary NOT NULL default '',
12 oi_size
int unsigned
NOT NULL default 0,
13 oi_width
int NOT NULL default 0,
14 oi_height
int NOT NULL default 0,
15 oi_bits
int NOT NULL default 0,
16 oi_description_id
bigint unsigned
NOT NULL,
17 oi_actor
bigint unsigned
NOT NULL,
18 oi_timestamp
binary(14) NOT NULL default '',
19 oi_metadata mediumblob
NOT NULL,
20 oi_media_type
ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D") default NULL,
21 oi_major_mime
ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart", "chemical") NOT NULL default "unknown",
22 oi_minor_mime
varbinary(100) NOT NULL default "unknown",
23 oi_deleted tinyint unsigned
NOT NULL default 0,
24 oi_sha1
varbinary(32) NOT NULL default ''
25 ) /*$wgDBTableOptions*/;
27 INSERT OR IGNORE INTO /*_*/oldimage_tmp (
28 oi_name
, oi_archive_name
, oi_size
, oi_width
, oi_height
, oi_bits
,
29 oi_description_id
, oi_actor
, oi_timestamp
, oi_metadata
,
30 oi_media_type
, oi_major_mime
, oi_minor_mime
, oi_deleted
, oi_sha1
32 oi_name
, oi_archive_name
, oi_size
, oi_width
, oi_height
, oi_bits
,
33 oi_description_id
, oi_actor
, oi_timestamp
, oi_metadata
,
34 oi_media_type
, oi_major_mime
, oi_minor_mime
, oi_deleted
, oi_sha1
37 DROP TABLE /*_*/oldimage
;
38 ALTER TABLE /*_*/oldimage_tmp
RENAME TO /*_*/oldimage
;
39 CREATE INDEX /*i*/oi_actor_timestamp
ON /*_*/oldimage (oi_actor
,oi_timestamp
);
40 CREATE INDEX /*i*/oi_name_timestamp
ON /*_*/oldimage (oi_name
,oi_timestamp
);
41 CREATE INDEX /*i*/oi_name_archive_name
ON /*_*/oldimage (oi_name
,oi_archive_name(14));
42 CREATE INDEX /*i*/oi_sha1
ON /*_*/oldimage (oi_sha1(10));