From c0659401d42e2a8e38ff4f86385a6823d9f481fd Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sat, 23 Jul 2011 08:15:11 +0000 Subject: [PATCH] Follow-up r86482, r86485: removed user_name portion of user_email index per CR --- .../archives/patch-user_email_index.sql | 2 +- maintenance/tables.sql | 18 +++++++++--------- 2 files changed, 10 insertions(+), 10 deletions(-) diff --git a/maintenance/archives/patch-user_email_index.sql b/maintenance/archives/patch-user_email_index.sql index c770f047b0..6a3d62083f 100644 --- a/maintenance/archives/patch-user_email_index.sql +++ b/maintenance/archives/patch-user_email_index.sql @@ -1 +1 @@ -CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50),user_name); \ No newline at end of file +CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50)); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 65c8a72b11..90326d4659 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -135,7 +135,7 @@ CREATE TABLE /*_*/user ( CREATE UNIQUE INDEX /*i*/user_name ON /*_*/user (user_name); CREATE INDEX /*i*/user_email_token ON /*_*/user (user_email_token); -CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50),user_name); +CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50)); -- @@ -164,7 +164,7 @@ CREATE TABLE /*_*/user_groups ( CREATE UNIQUE INDEX /*i*/ug_user_group ON /*_*/user_groups (ug_user,ug_group); CREATE INDEX /*i*/ug_group ON /*_*/user_groups (ug_group); --- Stores the groups the user has once belonged to. +-- Stores the groups the user has once belonged to. -- The user may still belong these groups. Check user_groups. CREATE TABLE /*_*/user_former_groups ( -- Key to user_id @@ -939,12 +939,12 @@ CREATE INDEX /*i*/fa_user_timestamp ON /*_*/filearchive (fa_user_text,fa_timesta -- --- 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, @@ -954,16 +954,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. @@ -978,7 +978,7 @@ CREATE TABLE /*_*/uploadstash ( 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. -- 2.20.1