| Index: trunk/phase3/maintenance/postgres/archives/patch-rename-iwl_prefix.sql |
| — | — | @@ -0,0 +1,2 @@ |
| | 2 | +DROP INDEX iwl_prefix; |
| | 3 | +CREATE INDEX iwl_prefix_from_title ON iwlinks (iwl_prefix, iwl_from, iwl_title); |
| \ No newline at end of file |
| Property changes on: trunk/phase3/maintenance/postgres/archives/patch-rename-iwl_prefix.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 4 | + native |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -622,4 +622,4 @@ |
| 623 | 623 | iwl_title TEXT NOT NULL DEFAULT '' |
| 624 | 624 | ); |
| 625 | 625 | CREATE UNIQUE INDEX iwl_from ON iwlinks (iwl_from, iwl_prefix, iwl_title); |
| 626 | | -CREATE INDEX iwl_prefix ON iwlinks (iwl_prefix, iwl_title); |
| | 626 | +CREATE INDEX iwl_prefix_from_title ON iwlinks (iwl_prefix, iwl_from, iwl_title); |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1966,6 +1966,12 @@ |
| 1967 | 1967 | wfOut( "Adding ipb_address_unique index\n" ); |
| 1968 | 1968 | $wgDatabase->sourceFile( archive( 'patch-ipb_address_unique.sql' ) ); |
| 1969 | 1969 | } |
| | 1970 | + |
| | 1971 | + # Fix iwlinks index |
| | 1972 | + if ( pg_index_exists( 'iwlinks', 'iwl_prefix' ) ) { |
| | 1973 | + wfOut( "Replacing index 'iwl_prefix' with 'iwl_prefix_from_title'...\n" ); |
| | 1974 | + $wgDatabase->sourceFile( archive( 'patch-ipb_address_unique.sql' ) ); |
| | 1975 | + } |
| 1970 | 1976 | |
| 1971 | 1977 | global $wgExtNewTables, $wgExtPGNewFields, $wgExtPGAlteredFields, $wgExtNewIndexes; |
| 1972 | 1978 | # Add missing extension tables |