| Index: trunk/phase3/maintenance/postgres/archives/patch-iwlinks.sql |
| — | — | @@ -0,0 +1,8 @@ |
| | 2 | + |
| | 3 | +CREATE TABLE iwlinks ( |
| | 4 | + iwl_from INTEGER NOT NULL DEFAULT 0, |
| | 5 | + iwl_prefix TEXT NOT NULL DEFAULT '', |
| | 6 | + iwl_title TEXT NOT NULL DEFAULT '' |
| | 7 | +); |
| | 8 | +CREATE UNIQUE INDEX iwl_from ON iwlinks (iwl_from, iwl_prefix, iwl_title); |
| | 9 | +CREATE INDEX iwl_prefix ON iwlinks (iwl_prefix, iwl_title); |
| Property changes on: trunk/phase3/maintenance/postgres/archives/patch-iwlinks.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 10 | + native |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -636,3 +636,11 @@ |
| 637 | 637 | lc_value TEXT NOT NULL |
| 638 | 638 | ); |
| 639 | 639 | CREATE INDEX l10n_cache_lc_lang_key ON l10n_cache (lc_lang, lc_key); |
| | 640 | + |
| | 641 | +CREATE TABLE iwlinks ( |
| | 642 | + iwl_from INTEGER NOT NULL DEFAULT 0, |
| | 643 | + iwl_prefix TEXT NOT NULL DEFAULT '', |
| | 644 | + iwl_title TEXT NOT NULL DEFAULT '' |
| | 645 | +); |
| | 646 | +CREATE UNIQUE INDEX iwl_from ON iwlinks (iwl_from, iwl_prefix, iwl_title); |
| | 647 | +CREATE INDEX iwl_prefix ON iwlinks (iwl_prefix, iwl_title); |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1596,7 +1596,7 @@ |
| 1597 | 1597 | array('user_properties', 'patch-user_properties.sql'), |
| 1598 | 1598 | array('log_search', 'patch-log_search.sql'), |
| 1599 | 1599 | array('l10n_cache', 'patch-l10n_cache.sql'), |
| 1600 | | - // @fixme add iwlinks table |
| | 1600 | + array('iwlinks', 'patch-iwlinks.sql'), |
| 1601 | 1601 | ); |
| 1602 | 1602 | |
| 1603 | 1603 | $newcols = array( |