From fcae5866a01b581afdb74ba829e55168d12ee3c8 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Sat, 24 Mar 2012 17:14:09 -0400 Subject: [PATCH] Fix whitespace; change tabs to spaces. Change-Id: I0c95653b47295e4bd84dec1ae74a850ca6598d9a --- maintenance/tables.sql | 64 +++++++++++++++++++++--------------------- 1 file changed, 32 insertions(+), 32 deletions(-) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 60fc7fc1bb..66a1845947 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -326,7 +326,7 @@ CREATE INDEX /*i*/rev_timestamp ON /*_*/revision (rev_timestamp); CREATE INDEX /*i*/page_timestamp ON /*_*/revision (rev_page,rev_timestamp); CREATE INDEX /*i*/user_timestamp ON /*_*/revision (rev_user,rev_timestamp); CREATE INDEX /*i*/usertext_timestamp ON /*_*/revision (rev_user_text,rev_timestamp); -CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp); +CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp); -- -- Holds text of individual page revisions. @@ -946,44 +946,44 @@ CREATE INDEX /*i*/fa_user_timestamp ON /*_*/filearchive (fa_user_text,fa_timesta -- moved into the actual filestore -- CREATE TABLE /*_*/uploadstash ( - us_id int unsigned NOT NULL PRIMARY KEY auto_increment, + us_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, - -- the user who uploaded the file. - us_user int unsigned NOT NULL, + -- the user who uploaded the file. + us_user int unsigned NOT NULL, - -- file key. this is how applications actually search for the file. - -- this might go away, or become the primary key. - us_key varchar(255) NOT NULL, + -- file key. this is how applications actually search for the file. + -- this might go away, or become the primary key. + us_key varchar(255) NOT NULL, - -- the original path - us_orig_path varchar(255) NOT NULL, + -- 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, + -- 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), + -- 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, + -- the date/time on which the file was added + us_timestamp varbinary(14) NOT NULL, - us_status varchar(50) not null, + us_status varchar(50) NOT NULL, - -- chunk counter starts at 0, current offset is stored in us_size - us_chunk_inx int unsigned NULL, + -- chunk counter starts at 0, current offset is stored in us_size + us_chunk_inx int unsigned NULL, - -- file properties from File::getPropsFromPath. these may prove unnecessary. - -- - us_size int unsigned NOT NULL, - -- this hash comes from File::sha1Base36(), and is 31 characters - 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, - -- image-specific properties - us_image_width int unsigned, - us_image_height int unsigned, - us_image_bits smallint unsigned + -- file properties from File::getPropsFromPath. these may prove unnecessary. + -- + us_size int unsigned NOT NULL, + -- this hash comes from File::sha1Base36(), and is 31 characters + 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, + -- image-specific properties + us_image_width int unsigned, + us_image_height int unsigned, + us_image_bits smallint unsigned ) /*$wgDBTableOptions*/; @@ -1237,7 +1237,7 @@ CREATE INDEX /*i*/page_time ON /*_*/logging (log_namespace, log_title, log_times CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp); CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp); CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp); -CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action, log_timestamp); +CREATE INDEX /*i*/type_action ON /*_*/logging (log_type, log_action, log_timestamp); CREATE TABLE /*_*/log_search ( @@ -1275,7 +1275,7 @@ CREATE TABLE /*_*/job ( ) /*$wgDBTableOptions*/; CREATE INDEX /*i*/job_cmd ON /*_*/job (job_cmd, job_namespace, job_title, job_params(128)); -CREATE INDEX /*i*/job_timestamp ON /*_*/job(job_timestamp); +CREATE INDEX /*i*/job_timestamp ON /*_*/job (job_timestamp); -- Details of updates to cached special pages -- 2.20.1