deleted posted column from item

[nucleus-jp/nucleus-jp-ancient.git] / nucleus / upgrades / upgrade3.3.php

diff --git a/nucleus/upgrades/upgrade3.3.php b/nucleus/upgrades/upgrade3.3.php
index 3be5dd5..e47b948 100644 (file)
--- a/nucleus/upgrades/upgrade3.3.php
+++ b/nucleus/upgrades/upgrade3.3.php
@@ -18,19 +18,12 @@ function upgrade_do33() {
                upgrade_query('Altering ' . sql_table('blog') . ' table', $query);
        }
 
-       if (!upgrade_checkIfColumnExists('item','posted')) {
-               $query = "      ALTER TABLE `" . sql_table('item') . "`
-                                ADD `iposted` TINYINT(2) DEFAULT 1 NOT NULL ;";
-
-               upgrade_query('Altering ' . sql_table('item') . ' table', $query);
-       }
-
-       if (!upgrade_checkIfColumnExists('blog','bfuturepost')) {
-               $query = "      ALTER TABLE `" . sql_table('blog') . "`
-                                ADD `bfuturepost` TINYINT(2) DEFAULT 0 NOT NULL ;";
-
-               upgrade_query('Altering ' . sql_table('blog') . ' table', $query);
-       }
+       // check cmail column to separate to URL and cemail
+       mysql_query(
+               'UPDATE ' . sql_table('comment') . ' ' . 
+               "SET cemail = cmail, cmail = '' " .
+               "WHERE cmail LIKE '%@%'"
+       );
 
        // 3.2 -> 3.3
        // update database version