| Index: trunk/phase3/maintenance/archives/patch-index-renames.sql |
| — | — | @@ -1,11 +1,11 @@ |
| 2 | | -
|
| 3 | | -DROP INDEX user_id ON /*_*/user_newtalk;
|
| 4 | | -DROP INDEX user_ip ON /*_*/user_newtalk;
|
| 5 | | -DROP INDEX usertext_timestamp ON /*_*/archive;
|
| 6 | | -CREATE INDEX un_user_id ON /*_*/user_newtalk (user_id);
|
| 7 | | -CREATE INDEX un_user_ip ON /*_*/user_newtalk (user_ip);
|
| | 2 | +-- |
| | 3 | +-- patch-index-renames.sql |
| | 4 | +-- |
| | 5 | +-- Rename three indices because of naming conflicts |
| | 6 | + |
| | 7 | +DROP INDEX user_id ON /*_*/user_newtalk; |
| | 8 | +DROP INDEX user_ip ON /*_*/user_newtalk; |
| | 9 | +DROP INDEX usertext_timestamp ON /*_*/archive; |
| | 10 | +CREATE INDEX un_user_id ON /*_*/user_newtalk (user_id); |
| | 11 | +CREATE INDEX un_user_ip ON /*_*/user_newtalk (user_ip); |
| 8 | 12 | CREATE INDEX ar_usertext_timestamp ON /*_*/archive (ar_user_text,ar_timestamp); |
| \ No newline at end of file |
| Property changes on: trunk/phase3/maintenance/archives/patch-index-renames.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 9 | 13 | + native |
| Index: trunk/phase3/maintenance/archives/patch-pl-tl-il-unique.sql |
| — | — | @@ -1,11 +1,11 @@ |
| 2 | | -
|
| 3 | | -DROP INDEX pl_namespace ON /*_*/pagelinks;
|
| 4 | | -CREATE UNIQUE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from);
|
| 5 | | -DROP INDEX tl_namespace ON /*_*/templatelinks;
|
| 6 | | -CREATE UNIQUE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from);
|
| 7 | | -DROP INDEX il_to ON /*_*/imagelinks;
|
| 8 | | -CREATE UNIQUE INDEX il_to ON /*_*/imagelinks (il_to, il_from);
|
| | 2 | +-- |
| | 3 | +-- patch-pl-tl-il-unique-index.sql |
| | 4 | +-- |
| | 5 | +-- Make reorderings of UNIQUE indices UNIQUE as well |
| | 6 | + |
| | 7 | +DROP INDEX pl_namespace ON /*_*/pagelinks; |
| | 8 | +CREATE UNIQUE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from); |
| | 9 | +DROP INDEX tl_namespace ON /*_*/templatelinks; |
| | 10 | +CREATE UNIQUE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from); |
| | 11 | +DROP INDEX il_to ON /*_*/imagelinks; |
| | 12 | +CREATE UNIQUE INDEX il_to ON /*_*/imagelinks (il_to, il_from); |
| Property changes on: trunk/phase3/maintenance/archives/patch-pl-tl-il-unique.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 9 | 13 | + native |