diff options
Diffstat (limited to 'maintenance/archives/patch-uploadstash.sql')
| -rw-r--r-- | maintenance/archives/patch-uploadstash.sql | 15 |
1 files changed, 7 insertions, 8 deletions
diff --git a/maintenance/archives/patch-uploadstash.sql b/maintenance/archives/patch-uploadstash.sql index 2512076f..14eaeab0 100644 --- a/maintenance/archives/patch-uploadstash.sql +++ b/maintenance/archives/patch-uploadstash.sql @@ -1,10 +1,10 @@ -- --- Store information about newly uploaded files before they're +-- Store information about newly uploaded files before they're -- moved into the actual filestore -- CREATE TABLE /*_*/uploadstash ( us_id int unsigned NOT NULL PRIMARY KEY auto_increment, - + -- the user who uploaded the file. us_user int unsigned NOT NULL, @@ -14,16 +14,16 @@ CREATE TABLE /*_*/uploadstash ( -- the original path us_orig_path varchar(255) NOT NULL, - + -- the temporary path at which the file is actually stored us_path varchar(255) NOT NULL, - + -- which type of upload the file came from (sometimes) us_source_type varchar(50), - + -- the date/time on which the file was added us_timestamp varbinary(14) not null, - + us_status varchar(50) not null, -- file properties from File::getPropsFromPath. these may prove unnecessary. @@ -33,12 +33,11 @@ CREATE TABLE /*_*/uploadstash ( us_sha1 varchar(31) NOT NULL, us_mime varchar(255), -- Media type as defined by the MEDIATYPE_xxx constants, should duplicate definition in the image table - us_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, + us_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, -- image-specific properties us_image_width int unsigned, us_image_height int unsigned, us_image_bits smallint unsigned - ) /*$wgDBTableOptions*/; -- sometimes there's a delete for all of a user's stuff. |