- Bugfix: increased the size of variable's tables the 'name' field.  Patch
  by Gerhard.

- Bugfix: don't set a name and e-mail address for the anonymous user.  Fixes
  bug #3740.

- Bugfix: renamed the 'statistics' table to 'node_counter' as 'statistics' is
  a reserved SQL keyword.  Required for both PostgreSQL and MSSQL.  Patch by
  Adrian.

- Bugfix: renamed the 'path' table to 'url_alias' as 'path' is a reserved SQL
  keyword.  Required for both PostgreSQL and MSSQL.  Patch by Adrian.

- Fixed translation bugs with statistics module.  Patch by Gabor.

- Removed 'homepage' field from user table.  Patch by Gabor.

- Added 'real name' field to the profile module.  Patch by Gabor.

- Modifies path.module to get rid of pgsql reserved word.  Patch by Adrian.

- Updates database.pgsql and database.mysql to work with current cvs. Patch
  by Adrian.

- Updates update.php to be able to update postgres from 4.2 to current.
  Patch by Adrian.

- Small fixes by me.

- Some URL alias fixes by Matt.

- Url aliasing improvements.  Patch by Matt.  See mailing list for more
  information.

- Added PostgreSQL support to the update script.  Patch by Adrian.

- Making Adrian the new PostgreSQL maintainer.

- Patch by Bart Jansen:

  <quote>

  This adds session support for anonymous users and fixes a bug/typo.

    1. changed rid for user #0 from 0 to 1 (rid 1 == anonymous user) to make
       inner join work.

    2. replaced "if ($user .." by "if ($user->uid .." because now $user is
       always set (my previous change probably caused this).

    3. db_next_id("user_uid") -> db_next_id("users_uid");
  </quote>

  I repeat:

  "This adds session support for anonymous users and fixes a bug/typo."

- Gerhard's uid 0 patches.  These patches bring various performance
  improvements.  Requires a database update.

- Small bugfix for the database.mysql sql structure with the new indexes
  introduced in yesterday's forum query patch.  Patch by Matt.

- Tested and committed Kjartan's performance patches.  (Fixed the access check
  in update.php though.)

  PostgreSQL and MSSQL database scheme as well.

- Made sure the update script updates the correct tables when database
  prefixing is enabled.  Patch by Bart Jansens.

- Improved the breadcrumb navigation of the book and the forum module as per
  Keith Instone's suggestions.

- Updated page titles (or block titles) and links to match.  Suggested by
  Keith Instone.

- Added missing 'thread' field to the comment table of the MySQL database scheme.
  Fixes bug #2590.

- Fixed braino in MySQL database scheme.  Patch by Gerhard.

- Committed Jeremy's session patch: this brings us one step closer to having
  session for anonymous users.

- Changing the node body to type 'mediumtext'.  Addresses bug #2155.

- Commited the URL aliasing patch.  Thanks Matt.

  This update requires you to run update.php!

- Bugfix: renamed the SQL field 'types' to 'nodes' because 'types' is a reserved keyword in MySQL 4.  This fixes critical bug #1618.  Patch by Marco.

  ==> This fix requires to run update.php!

- Bugfix: made sessions work without warnings when register_globals is turned off. The solution is to use $_SESSION instead of session_register().  This fixes critical bug #1797.  Patch by Marco.

- Bugfix: sometimes error messages where being discarded when previewing a node.  Patch by Craig Courtney.

- Bugfix: fixed charset problems.  This fixes critical bug #1549.  Patch '0023.charset.patch' by Al.

- Code improvements: removed some dead code from the comment module.  Patch by Marco.

- Documentation improvements: polished the node module help texts and form descriptions.  Patch '0019.node.module.help.patch' by Al.

- CSS improvements all over the map!  Patch '0021.more.css.patch' by Al.

- GUI improvements: improved the position of Druplicon in the admin menu.  Patch '0020.admin.logo.patch' by Al.

- GUI improvements: new logos for theme Marvin and theme UnConeD.  Logos by Kristjan Jansen.

- GUI improvements: small changes to the output emitted by the profile module.  Suggestions by Steven Wittens.

- GUI improvements: small fixes to Xtemplate.  Patch '0022.xtemplate.css.patch' by Al.

TODO:

- Some modules such as the buddy list module and the annotation module in the contributions repository are also using session_register().  They should be updated.  We should setup a task on Drupal.

- There is code emitting '<div align="right">' which doesn't validate.

- Does our XML feeds validate with the charset changes?

- The forum module's SQL doesn't work properly on PostgreSQL.

- Fixed critical bug #1788: cloud module pings too much.  Modified patch by
  Kjartan.

  This update requires some database changes so make sure to run update.php.

- Changed the type of the string fields in the locale table to BLOB.
  This fixes bug #987.  For PostgreSQL this is not required because
  its string comparisons are case-senitive.  Not idea about MSSQL.

- Fixed bug in book_prev().  Patch by Andy Colson.

- Book optimizations: updated to use inner joins.  Patch by Andy Colson.
  This should address bug #1373.

  TODO: add index to MSSQL database scheme.

- Applied modified version of Al's "block delta" patch.  I left out the
  blogroll feature as I think it would get very confusing.  I don't mind
  to add it but it need some thought and documentation as it somewhat
  conflicts with the existing cloud module.

  These changes require you to run update.php.

- Made sure the admin menu is enabled after a fresh install.  This is
  required to make the menu show up.

  This partly fixes bug #1508.

- Added missing tid-column to the forum table.  Patch by Anarcat.

- Added missing 'created' field to 'cache' table.

- All LIMIT queries must go through the pager or through db_query_range().
  The syntax for db_query_range() was enhanced so it matches db_query(). So
  you may pass extra arguments of the SQL statement which are checked via
  check_query() and then substituted into the SQL statement. After these
  optional arguments, you always pass $from and $count parameters which
  define your range.  Most often, the $from is 0 and the count is the max
  number of records you want returned.  Patch by Moshe.

- The pager_query() function for PEAR was enhanced so that it adds  proper
  GROUP BY statement counting the number of records to be paged. Patch by
  James Arthur.

- MSSQL database scheme by Moshe.

- Removing the menu table: it is no longer used.
  [TODO: update 'update.php'.]

- database.mysql cannot be run from within phpMyAdmin because of line
  consisting of hyphens only.  Patch by Zbynek.

- Fixed typo: forum2 -> forum.

- Updated the database scheme.

- Small improvement to the admin menu based on feedback from Michael.

- Added an extra parameter to watchdog() which lets you specifiy an "action"
  or "operation" link.

- Made the main page of the administration section show an overview of all
  watchdog entries with such action link.

- Fixed typo in PostgreSQL database scheme.

- Refactored the administration pages.

Applied patch by Natrak:

- page_header() now adds Last-Modified and ETag http headers.
- When running PHP as an Apache module page_header() will check the HTTP
  headers for conditional gets, and will only push the content when it
  fails. (Works for html and xml pages as they are all cached). Note:
  this is a PHP limitation, so until PHP makes it work for other web
  servers this won't work for them.
- Added created field to cache database to hold the timestamp when the
  cache was created.
- Changed cache_get() to return an object with ->data and ->created.
- Update forum and locale modules.

- Removed rating module; it is not being used much and it has a known bug.
  Will add it to the contributions repository.

- Removed two a dead table from both the MySQL and the PostgreSQL database
  scheme.

- Fixed the default settings for both the MySQL and the PostgreSQL database
  scheme.

- Fixed small glitch in the database schemes; the block table has changed but
  the queries that insert some default block values were not updated.

- Added Stefan's page module improvements.

  [NOTE: the PostgreSQL database scheme needs updating.]

- Updated the PostgreSQL database scheme (thanks James) and the MySQL
  database scheme.