| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -173,6 +173,7 @@ |
| 174 | 174 | tl_title TEXT NOT NULL |
| 175 | 175 | ); |
| 176 | 176 | CREATE UNIQUE INDEX templatelinks_unique ON templatelinks (tl_namespace,tl_title,tl_from); |
| | 177 | +CREATE INDEX templatelinks_from ON templatelinks (tl_from); |
| 177 | 178 | |
| 178 | 179 | CREATE TABLE imagelinks ( |
| 179 | 180 | il_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE, |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1547,6 +1547,7 @@ |
| 1548 | 1548 | array("oldimage", "oi_sha1", "(oi_sha1)"), |
| 1549 | 1549 | array("revision", "rev_text_id_idx", "(rev_text_id)"), |
| 1550 | 1550 | array("recentchanges", "rc_timestamp_nobot", "(rc_timestamp) WHERE rc_bot = 0"), |
| | 1551 | + array("templatelinks", "templatelinks_from", "(tl_from)"), |
| 1551 | 1552 | array("watchlist", "wl_user", "(wl_user)"), |
| 1552 | 1553 | ); |
| 1553 | 1554 | |
| — | — | @@ -1749,7 +1750,7 @@ |
| 1750 | 1751 | # This is create or replace, so harmless to call if not needed |
| 1751 | 1752 | dbsource(archive('patch-ts2pagetitle.sql')); |
| 1752 | 1753 | |
| 1753 | | - ## If the server is 8.3 or higher, rewrite teh tsearch2 triggers |
| | 1754 | + ## If the server is 8.3 or higher, rewrite the tsearch2 triggers |
| 1754 | 1755 | ## in case they have the old 'default' versions |
| 1755 | 1756 | if ( $numver >= 8.3 ) |
| 1756 | 1757 | dbsource(archive('patch-tsearch2funcs.sql')); |