| Index: trunk/phase3/maintenance/archives/patch-user_email_index.sql |
| — | — | @@ -1 +1 @@ |
| 2 | | -CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50),user_name); |
| \ No newline at end of file |
| | 2 | +CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50)); |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -135,7 +135,7 @@ |
| 136 | 136 | |
| 137 | 137 | CREATE UNIQUE INDEX /*i*/user_name ON /*_*/user (user_name); |
| 138 | 138 | CREATE INDEX /*i*/user_email_token ON /*_*/user (user_email_token); |
| 139 | | -CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50),user_name); |
| | 139 | +CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50)); |
| 140 | 140 | |
| 141 | 141 | |
| 142 | 142 | -- |
| — | — | @@ -164,7 +164,7 @@ |
| 165 | 165 | CREATE UNIQUE INDEX /*i*/ug_user_group ON /*_*/user_groups (ug_user,ug_group); |
| 166 | 166 | CREATE INDEX /*i*/ug_group ON /*_*/user_groups (ug_group); |
| 167 | 167 | |
| | 168 | +-- Stores the groups the user has once belonged to. |
| 168 | 169 | -- The user may still belong these groups. Check user_groups. |
| 169 | 170 | CREATE TABLE /*_*/user_former_groups ( |
| 170 | 171 | -- Key to user_id |
| — | — | @@ -939,12 +939,12 @@ |
| 940 | 940 | |
| 941 | 941 | |
| 942 | 942 | -- |
| | 943 | +-- Store information about newly uploaded files before they're |
| 943 | 944 | -- moved into the actual filestore |
| 944 | 945 | -- |
| 945 | 946 | CREATE TABLE /*_*/uploadstash ( |
| 946 | 947 | us_id int unsigned NOT NULL PRIMARY KEY auto_increment, |
| 947 | | - |
| | 948 | + |
| 948 | 949 | -- the user who uploaded the file. |
| 949 | 950 | us_user int unsigned NOT NULL, |
| 950 | 951 | |
| — | — | @@ -954,16 +954,16 @@ |
| 955 | 955 | |
| 956 | 956 | -- the original path |
| 957 | 957 | us_orig_path varchar(255) NOT NULL, |
| 958 | | - |
| | 958 | + |
| 959 | 959 | -- the temporary path at which the file is actually stored |
| 960 | 960 | us_path varchar(255) NOT NULL, |
| 961 | | - |
| | 961 | + |
| 962 | 962 | -- which type of upload the file came from (sometimes) |
| 963 | 963 | us_source_type varchar(50), |
| 964 | | - |
| | 964 | + |
| 965 | 965 | -- the date/time on which the file was added |
| 966 | 966 | us_timestamp varbinary(14) not null, |
| 967 | | - |
| | 967 | + |
| 968 | 968 | us_status varchar(50) not null, |
| 969 | 969 | |
| 970 | 970 | -- file properties from File::getPropsFromPath. these may prove unnecessary. |
| — | — | @@ -978,7 +978,7 @@ |
| 979 | 979 | us_image_width int unsigned, |
| 980 | 980 | us_image_height int unsigned, |
| 981 | 981 | us_image_bits smallint unsigned |
| 982 | | - |
| | 982 | + |
| 983 | 983 | ) /*$wgDBTableOptions*/; |
| 984 | 984 | |
| 985 | 985 | -- sometimes there's a delete for all of a user's stuff. |