[pLog-svn] r538 - plog/trunk

[subaochen at devel.plogworld.net]

Author: subaochen
Date: 2004-12-19 05:21:28 +0000 (Sun, 19 Dec 2004)
New Revision: 538

Modified:
   plog/trunk/wizard.php
Log:
drop unneeded columns from articles table when updating from 0.3.2 to 1.0


Modified: plog/trunk/wizard.php
===================================================================
--- plog/trunk/wizard.php	2004-12-19 00:44:10 UTC (rev 537)
+++ plog/trunk/wizard.php	2004-12-19 05:21:28 UTC (rev 538)
@@ -1553,6 +1553,18 @@
 				$this->message .= "There was an error updating the articles_text table.<br/>";
 				return false;
 			}
+
+            // drop unneeded columns from articles table
+            $alter_query[] = "ALTER TABLE ".$dbPrefix."articles DROP COLUMN text";
+            $alter_query[] = "ALTER TABLE ".$dbPrefix."articles DROP COLUMN topic";
+            $alter_query[] = "ALTER TABLE ".$dbPrefix."articles DROP COLUMN normalized_text";
+            $alter_query[] = "ALTER TABLE ".$dbPrefix."articles DROP COLUMN normalized_topic";
+            $alter_query[] = "ALTER TABLE ".$dbPrefix."articles DROP COLUMN mangled_topic";
+
+            foreach ($alter_query as $value) {
+                $this->db->Execute($value);
+            }
+
 			
 			$this->message .= "articles_text table updated successfully!<br/>";