- Bugfix: fixed the CREATE FUNCTION in database.mssql as it needs to be prefixed with GO for some obscure reason.  Patch by Kjartan.

- Bugfix: fixed the defaults for blocks in database.mssql so the NOT NULL fields get values.  Patch by Kjartan.

- Bugfix: changed check_form() to use htmlspecialchars() instead of drupal_specialchars() as this caused Drupal to emit incorrect form items in presence of quotes.  Example:

  <input type="submit" class="form-submit" name="op" value="Submit "top nodes" block changes" />

  IMO, drupal_specialchars() is better called xmlspecialchars() to avoid confusion.

- Bugfix: when an anonymous user visits a site, they shouldn't see any content (except the login block, if it is enabled) unless they have the "access content" permissions.  Patch by Matt Westgate.

- Improvement: improved the error checking and the error messages in the profile module.  Updated the code to match the Drupal coding conventions.  Modified patch from Matt Westgate.

- Improvement: don't generate the <base href=""> tag in the base theme; it is already emitted by theme_head().  Patch by Kristjan.

- Improvement: don't execute any SQL queries when checking the permissions of user #1.  Patch by Kjartan.

- Improvement: made a scalable layout form that works in IE and that behaves better with narrow themes.  Part of patch #51 by Al.

- Improvement: removed some redundant print statements from the comment module.  Modified patch from Craig Courtney.

- 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.

- Fixed a typo in the PostgreSQL database scheme.  Patch by Michael Frankowski.

- Fixed a typo in the MSSQL database scheme.  Patch by Michael Frankowski.

- Removed dependency on "register_globals = on"!  Patches by Michael Frankowski.

  Notes:

  + Updated the patches to use $foo["bar"] instead of $foo['bar'].
  + Updated the INSTALL and CHANGELOG files as well.

- Tiny improvement to the "./scripts/code-clean.sh" script.

- Added default table values to MSSQL database scheme.  Patch by Moshe.  Fixes bug #1571.

- 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.

- Some MSSQL related fixes by Moshe.

- 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.

- Added a database scheme for Microsoft's SQL server.

- 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.

- Fixed typo in the database scheme.  Reported by Ettiene.

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.

- Updated PostgreSQL scheme.  Patch by Stefan.

- 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.

- Made the forum module work with PostgreSQL.  Patch by Gordon Kerr, verified
  by James Arthur.

- Applied a PostgreSQL patch from James.

- Wrapped some hardcoded colors in "theme_invoke()"s; we can still create
  a drupal_error() later on but I think we better get used to theme_invoke().

- Fixed translation bug.  Patch by Moshe.

- Fixed PHP warning.  Patch by ax.

- updated database dump.
- removed tables modules, layout and referrer (don't forget to backup!).

- Some PostgreSQL improvements.  Patch by James Arthur.

- Changed "$watchdog->message" from type "varchar(255)" to type "text".
  Patch by James.  For sake of consistency, I updated the MySQL scheme
  and added a new update entry to "update.php".

- Removed the unused table and included the sequences table.   Patch by
  jaa.

- Fixed typo.  Patch by Marco.

- Applied a (modified) version of Marco's SQL sequence patch.