From f155ed21261bf3fd67fdbf4319223478079593b1 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Wed, 7 Sep 2005 20:32:00 +0000
Subject: - Patch #30622 by Gerhard: the update produces a type field in
 node_revisions which shouldn't be there.

---
 database/updates.inc | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'database')

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);
-- 
cgit v1.2.3