| Index: trunk/phase3/maintenance/archives/patch-list.txt |
| — | — | @@ -1,182 +0,0 @@ |
| 2 | | -List of database patches and upgrades as the PediaWiki software evolves... |
| 3 | | - |
| 4 | | -* 2002-11-23: Search index format changed for UTF-8 wikis |
| 5 | | -For wikis using the UTF-8 languages, the search index entries |
| 6 | | -need to be rebuild to allow searching to work. (Other wikis |
| 7 | | -that have been run through the old phase2->phase3 conversion |
| 8 | | -script should also be reindexed to catch apostrophe misplacement.) |
| 9 | | - |
| 10 | | -Run rebuildIndex.php on your wiki. |
| 11 | | - |
| 12 | | - |
| 13 | | - |
| 14 | | -* 2002-11-27: Watchlist format changed |
| 15 | | -Converts the user_watchlist entries out to a separate table which |
| 16 | | -links user_id<->cur_id and can be more handily queried. |
| 17 | | - |
| 18 | | -Run upgradeWatchlist.php on your wiki. |
| 19 | | - |
| 20 | | - |
| 21 | | - |
| 22 | | -* 2002-12-14: Recentchanges table bot/hidden column |
| 23 | | -Adds a column to indicate changes by registered bots (or perhaps |
| 24 | | -later other admin actions) that should be hidden from the default |
| 25 | | -Recentchanges list because people think they're tedious, but should |
| 26 | | -still be available in article histories, contribs lists, and |
| 27 | | -power-user RC lists. |
| 28 | | - |
| 29 | | -Run bot.sql against your database. |
| 30 | | - |
| 31 | | - |
| 32 | | - |
| 33 | | -* 2002-12-17: Watchlist format changed again |
| 34 | | -Now using namespace, title instead of cur_id. This can track deleted/ |
| 35 | | -recreated pages better, makes it easier to handle talk pages (now with |
| 36 | | -the auto-watch feature there's a lot more watching of talk pages!) |
| 37 | | -and whatnot. |
| 38 | | - |
| 39 | | -Run patch-watchlist.sql against your database. If all is well, drop |
| 40 | | -the oldwatchlist table which is no longer needed. (Note that this update |
| 41 | | -also drops the vestigial user_watchlist column.) |
| 42 | | - |
| 43 | | - |
| 44 | | - |
| 45 | | -* 2002-12-26: TeX math rendering adds 'math' table |
| 46 | | -A new 'math' table is used to cache TeX sections. |
| 47 | | - |
| 48 | | -Run patch-math.sql against your database, and add 'tmp' and 'math' |
| 49 | | -subdirectories to your tree alongside the upload directory, and copy |
| 50 | | -the 'math' source subdirectory under the wiki's PHP directory and run |
| 51 | | -"make" to compile the texvc evaluator. (whew!) |
| 52 | | - |
| 53 | | -TeX support requires TeX, OCaml, and ImageMagick. If you don't want |
| 54 | | -to use TeX support on your wiki, you can globally disable it by |
| 55 | | -setting $wgUseTeX=false in LocalSettings.php. |
| 56 | | - |
| 57 | | - |
| 58 | | - |
| 59 | | -* 2003-01-25: searchindex table |
| 60 | | -A new 'searchindex' table separates the fulltext index fields from |
| 61 | | -'cur'. This enables use of InnoDB tables, which don't support fulltext |
| 62 | | -search, for the main data, and will keep junk out of the backup dumps. |
| 63 | | - |
| 64 | | -Run patch-searchindex.sql on the database. If you wish to change table |
| 65 | | -tables on the others, use 'alter table' manually. (See MySQL docs.) |
| 66 | | - |
| 67 | | - |
| 68 | | -* 2003-01-24: Talk pages for anonymous users |
| 69 | | -A new table user_newtalk contains a list of talk pages that were |
| 70 | | -changed, both pages by anonymous and those by non-anonymous users. |
| 71 | | - |
| 72 | | -Run patch-usernewtalk.sql if your database was created before |
| 73 | | -this date. |
| 74 | | - |
| 75 | | - |
| 76 | | -* 2003-02-02: Math table changed |
| 77 | | -Rerun patch-math.sql to recreate it. |
| 78 | | - |
| 79 | | -* 2003-02-03: Index added to USER table for performance reasons. Run |
| 80 | | -patch-userindex.sql to create it. |
| 81 | | - |
| 82 | | - |
| 83 | | -* 2003-02-09: Random table & inverse timestamps |
| 84 | | -The random page queue table has been removed in favor of a column |
| 85 | | -in the cur table. This eliminates the ssllooww queue refill step; |
| 86 | | -pre-storing random indices in an indexed column means we can do the |
| 87 | | -random sort instantly; each element is re-randomized upon selection. |
| 88 | | - |
| 89 | | -Also, an inverse_timestamp field has been added to the cur and old |
| 90 | | -tables. This will allow fast index-based sorting in history lists, |
| 91 | | -user contribs, linked recentchanges, etc with MySQL 3, which doesn't |
| 92 | | -allow DESC ordering on an indexed field. This may be removed later |
| 93 | | -when MySQL is found to be stable. |
| 94 | | - |
| 95 | | - |
| 96 | | -* 2003-03-22: Last touched fields for caching |
| 97 | | -'Last touched' timestamp fields have been added to the cur and user |
| 98 | | -tables to aid in maintaining cache consistency. Web clients will |
| 99 | | -be forced to reload a page if it has been touched since the client's |
| 100 | | -cached copy (this will catch indirect changes like creation of |
| 101 | | -linked pages) or if a user changes preferences or logs in anew (so |
| 102 | | -visual changes and login status are taken into account). |
| 103 | | - |
| 104 | | -Run patch-cache.sql on the database to set these fields up. This is |
| 105 | | -required for changes to OutputPage.php and elsewhere to continue |
| 106 | | -working on an older database. |
| 107 | | - |
| 108 | | - |
| 109 | | -* 2003-05-23: Index for "Oldest articles" |
| 110 | | -"Oldest articles" needs an index on namespace, redirect and timestamp |
| 111 | | -to be reasonably fast. (patch-oldestindex.sql) |
| 112 | | - |
| 113 | | -OutputPage.php User.php maintenance/buildTables.inc maintenance/patch-cache.sql maintenance/patch-list.txt |
| 114 | | - |
| 115 | | -* 2003-09: Ipblocks auto-expiry update |
| 116 | | -patch-ipblocks.sql |
| 117 | | - |
| 118 | | -* Interwiki URL table |
| 119 | | -Moves the interwiki prefix<->url mapping table from a static array |
| 120 | | -into the database. If you've got a custom table, be sure to make |
| 121 | | -your changes! |
| 122 | | - |
| 123 | | -Run patch-interwiki.sql to create the interwiki table, then the |
| 124 | | -plain interwiki.sql to load up the default set of mappings. |
| 125 | | - |
| 126 | | -* 2003-05-30: File upload license fields |
| 127 | | -Adds fields to 'image' table. |
| 128 | | -INCOMPLETE, DO NOT USE |
| 129 | | - |
| 130 | | - |
| 131 | | -* 2003-08-21: Interwiki URL table |
| 132 | | -Moves the interwiki prefix<->url mapping table from a static array |
| 133 | | -into the database. If you've got a custom table, be sure to make |
| 134 | | -your changes! |
| 135 | | - |
| 136 | | -Run patch-interwiki.sql to create the interwiki table, then the |
| 137 | | -plain interwiki.sql to load up the default set of mappings. |
| 138 | | - |
| 139 | | -* 2003-09: Ipblocks auto-expiry update |
| 140 | | -patch-ipblocks.sql |
| 141 | | - |
| 142 | | -* Interwiki URL table |
| 143 | | -Moves the interwiki prefix<->url mapping table from a static array |
| 144 | | -into the database. If you've got a custom table, be sure to make |
| 145 | | -your changes! |
| 146 | | - |
| 147 | | -Run patch-interwiki.sql to create the interwiki table, then the |
| 148 | | -plain interwiki.sql to load up the default set of mappings. |
| 149 | | - |
| 150 | | -* 2003-11: Indexes |
| 151 | | -Fixes up indexes on links, brokenlinks, recentchanges, watchlist, |
| 152 | | -and archive tables to boost speed. |
| 153 | | - |
| 154 | | -Run patch-indexes.sql. |
| 155 | | - |
| 156 | | -* 2003-11: linkscc table creation |
| 157 | | -patch-linkscc.sql |
| 158 | | - |
| 159 | | - |
| 160 | | -* 2004-01-25: recentchanges additional index |
| 161 | | -Adds an index to recentchanges to optimize Special:Newpages |
| 162 | | -patch-rc-newindex.sql |
| 163 | | - |
| 164 | | -* 2004-02-14: Adds the ipb_expiry field to ipblocks |
| 165 | | -patch-ipb_expiry.sql |
| 166 | | - |
| 167 | | - |
| 168 | | -* 2004-03-11: Recreate links tables to avoid duplicating titles |
| 169 | | -everywhere. **Rebuild your links after this with refreshLinks.php** |
| 170 | | - |
| 171 | | -patch-linktables.sql |
| 172 | | - |
| 173 | | - |
| 174 | | -* 2004-04: Add user_real_name field |
| 175 | | -patch-user-realname.sql |
| 176 | | - |
| 177 | | -* 2004-05-08: Add querycache table for caching special pages and generic |
| 178 | | - object cache to cover some slow operations w/o memcached. |
| 179 | | -patch-querycache.sql |
| 180 | | -patch-objectcache.sql |
| 181 | | - |
| 182 | | -* 2004-05-14: Add categorylinks table for handling category membership |
| 183 | | -patch-categorylinks.sql |