From fd12989ef8eab0fc9816decb8bcabccd1d213ee8 Mon Sep 17 00:00:00 2001 From: Pierre Schmitz Date: Wed, 18 Jul 2007 09:49:48 +0200 Subject: auf 1.10.1 aktualisiert --- maintenance/archives/patch-filearchive.sql | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) (limited to 'maintenance/archives/patch-filearchive.sql') diff --git a/maintenance/archives/patch-filearchive.sql b/maintenance/archives/patch-filearchive.sql index 71f8a5eb..587a2ab4 100644 --- a/maintenance/archives/patch-filearchive.sql +++ b/maintenance/archives/patch-filearchive.sql @@ -14,33 +14,33 @@ CREATE TABLE /*$wgDBprefix*/filearchive ( -- Which storage bin (directory tree or object store) the file data -- is stored in. Should be 'deleted' for files that have been deleted; -- any other bin is not yet in use. - fa_storage_group varchar(16), + fa_storage_group varbinary(16), -- SHA-1 of the file contents plus extension, used as a key for storage. -- eg 8f8a562add37052a1848ff7771a2c515db94baa9.jpg -- -- If NULL, the file was missing at deletion time or has been purged -- from the archival storage. - fa_storage_key varchar(64) binary default '', + fa_storage_key varbinary(64) default '', -- Deletion information, if this file is deleted. fa_deleted_user int, - fa_deleted_timestamp char(14) binary default '', + fa_deleted_timestamp binary(14) default '', fa_deleted_reason text, -- Duped fields from image - fa_size int(8) unsigned default '0', - fa_width int(5) default '0', - fa_height int(5) default '0', + fa_size int unsigned default '0', + fa_width int default '0', + fa_height int default '0', fa_metadata mediumblob, - fa_bits int(3) default '0', + fa_bits int default '0', fa_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, fa_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart") default "unknown", - fa_minor_mime varchar(32) default "unknown", + fa_minor_mime varbinary(32) default "unknown", fa_description tinyblob, - fa_user int(5) unsigned default '0', + fa_user int unsigned default '0', fa_user_text varchar(255) binary default '', - fa_timestamp char(14) binary default '', + fa_timestamp binary(14) default '', PRIMARY KEY (fa_id), INDEX (fa_name, fa_timestamp), -- pick out by image name -- cgit v1.2.3-54-g00ecf