- Patch #30622 by Gerhard: the update produces a type field in node_revisions which shouldn't be there.

1 files changed, 13 insertions, 1 deletions

diff --git a/database/updates.inc b/database/updates.inc
index ad8d5420c..27a87d8a8 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -44,7 +44,8 @@ $sql_updates = array(
   "2005-07-30" => "update_143",
   "2005-08-08" => "update_144",
   "2005-08-15" => "update_145",
-  "2005-08-25" => "update_146"
+  "2005-08-25" => "update_146",
+  "2005-09-07" => "update_147"
 );
 
 function update_110() {
@@ -778,6 +779,17 @@ function update_146() {
   return $ret;
 }
 
+function update_147() {
+  $ret = array();
+
+  // this update is mysql only, pgsql should get it right in the first try.
+  if ($GLOBALS['db_type'] == 'mysql') {
+    $ret[] = update_sql("ALTER TABLE {node_revisions} DROP type");
+  }
+
+  return $ret;
+}
+
 function update_sql($sql) {
   $edit = $_POST["edit"];
   $result = db_query($sql);