2 -- patch-filearchive-fa_description_id.sql
4 -- Split from patch-comment-table.sql to work around SQLite unconditionally running
5 -- patch-add-3d.sql on a fresh install, which wipes out fa_description_id and
6 -- fa_deleted_reason_id.
10 DROP TABLE IF EXISTS /*_*/filearchive_tmp
;
11 CREATE TABLE /*_*/filearchive_tmp (
12 fa_id
int NOT NULL PRIMARY KEY AUTO_INCREMENT
,
13 fa_name
varchar(255) binary NOT NULL default '',
14 fa_archive_name
varchar(255) binary default '',
15 fa_storage_group
varbinary(16),
16 fa_storage_key
varbinary(64) default '',
18 fa_deleted_timestamp
binary(14) default '',
19 fa_deleted_reason
varbinary(767) default '',
20 fa_deleted_reason_id
bigint unsigned
NOT NULL DEFAULT 0,
21 fa_size
int unsigned
default 0,
22 fa_width
int default 0,
23 fa_height
int default 0,
24 fa_metadata mediumblob
,
25 fa_bits
int default 0,
26 fa_media_type
ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D") default NULL,
27 fa_major_mime
ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart", "chemical") default "unknown",
28 fa_minor_mime
varbinary(100) default "unknown",
29 fa_description
varbinary(767) default '',
30 fa_description_id
bigint unsigned
NOT NULL DEFAULT 0,
31 fa_user
int unsigned
default 0,
32 fa_user_text
varchar(255) binary,
33 fa_timestamp
binary(14) default '',
34 fa_deleted tinyint unsigned
NOT NULL default 0,
35 fa_sha1
varbinary(32) NOT NULL default ''
36 ) /*$wgDBTableOptions*/;
38 INSERT OR IGNORE INTO /*_*/filearchive_tmp (
39 fa_id
, fa_name
, fa_archive_name
, fa_storage_group
, fa_storage_key
,
40 fa_deleted_user
, fa_deleted_timestamp
, fa_deleted_reason
, fa_size
,
41 fa_width
, fa_height
, fa_metadata
, fa_bits
, fa_media_type
, fa_major_mime
,
42 fa_minor_mime
, fa_description
, fa_user
, fa_user_text
, fa_timestamp
,
45 fa_id
, fa_name
, fa_archive_name
, fa_storage_group
, fa_storage_key
,
46 fa_deleted_user
, fa_deleted_timestamp
, fa_deleted_reason
, fa_size
,
47 fa_width
, fa_height
, fa_metadata
, fa_bits
, fa_media_type
, fa_major_mime
,
48 fa_minor_mime
, fa_description
, fa_user
, fa_user_text
, fa_timestamp
,
50 FROM /*_*/filearchive
;
52 DROP TABLE /*_*/filearchive
;
53 ALTER TABLE /*_*/filearchive_tmp
RENAME TO /*_*/filearchive
;
54 CREATE INDEX /*i*/fa_name
ON /*_*/filearchive (fa_name
, fa_timestamp
);
55 CREATE INDEX /*i*/fa_storage_group
ON /*_*/filearchive (fa_storage_group
, fa_storage_key
);
56 CREATE INDEX /*i*/fa_deleted_timestamp
ON /*_*/filearchive (fa_deleted_timestamp
);
57 CREATE INDEX /*i*/fa_user_timestamp
ON /*_*/filearchive (fa_user_text
,fa_timestamp
);
58 CREATE INDEX /*i*/fa_sha1
ON /*_*/filearchive (fa_sha1(10));