maintenance/archives/patch-list.txt

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