Index: modules/system/system.install
===================================================================
RCS file: /cvs/drupal/drupal/modules/system/system.install,v
retrieving revision 1.94
diff -u -p -r1.94 system.install
--- modules/system/system.install	17 Apr 2007 08:13:11 -0000	1.94
+++ modules/system/system.install	20 Apr 2007 15:48:14 -0000
@@ -407,7 +407,7 @@ function system_install() {
         title varchar(128) NOT NULL default '',
         body longtext NOT NULL,
         teaser longtext NOT NULL,
-        log longtext NOT NULL,
+        log longtext NOT NULL default '',
         timestamp int NOT NULL default '0',
         format int NOT NULL default '0',
         PRIMARY KEY  (vid),
@@ -3737,6 +3737,20 @@ function system_update_6008() {
 }
 
 /**
+ * Give log field in {node_revisions} a default value on MySQL
+ */
+function system_update_6009() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql("ALTER TABLE {node_revisions} ALTER COLUMN log SET default ''");
+      break;
+  }
+  return $ret;
+}
+
+/**
  * @} End of "defgroup updates-5.x-to-6.x"
  * The next series of updates should start at 7000.
  */