Update project date from '2002 - 2009' to '2002 - 2010'.

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

diff --git a/utf8/nucleus/upgrades/upgrade3.3.php b/utf8/nucleus/upgrades/upgrade3.3.php
index 3be5dd5..a491301 100644 (file)
--- a/utf8/nucleus/upgrades/upgrade3.3.php
+++ b/utf8/nucleus/upgrades/upgrade3.3.php
@@ -1,40 +1,71 @@
 <?php
-function upgrade_do33() {
+/*
+ * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
+ * Copyright (C) 2002-2010 The Nucleus Group
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License
+ * as published by the Free Software Foundation; either version 2
+ * of the License, or (at your option) any later version.
+ * (see nucleus/documentation/index.html#license for more info)
+ */
+/**
+ * @license http://nucleuscms.org/license.txt GNU General Public License
+ * @copyright Copyright (C) 2002-2010 The Nucleus Group
+ * @version $Id$
+ * $NucleusJP: upgrade3.3.php,v 1.5.2.1 2007/10/24 05:39:16 kimitake Exp $
+ *
+ */
 
-       if (upgrade_checkinstall(33))
-               return 'already installed';
+function upgrade_do330() {
 
-       if (!upgrade_checkIfColumnExists('comment','cemail')) {
-               $query = "      ALTER TABLE `" . sql_table('comment') . "`
-                                       ADD `cemail` VARCHAR( 100 ) AFTER `cmail` ;";
+    if (upgrade_checkinstall(330))
+        return 'インストール済みです';
 
-               upgrade_query('Altering ' . sql_table('comment') . ' table', $query);
-       }
+    if (!upgrade_checkIfColumnExists('comment','cemail')) {
+        $query = "  ALTER TABLE `" . sql_table('comment') . "`
+                    ADD `cemail` VARCHAR( 100 ) AFTER `cmail` ;";
 
-       if (!upgrade_checkIfColumnExists('blog','breqemail')) {
-               $query = "      ALTER TABLE `" . sql_table('blog') . "`
-                                       ADD `breqemail` TINYINT( 2 ) DEFAULT '0' NOT NULL ;";
+        upgrade_query('Altering ' . sql_table('comment') . ' table', $query);
+    }
+
+    if (!upgrade_checkIfColumnExists('blog','breqemail')) {
+        $query = "  ALTER TABLE `" . sql_table('blog') . "`
+                    ADD `breqemail` 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
+    update_version('330');
 
-               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);
-       }
 
-       // 3.2 -> 3.3
-       // update database version
-       update_version('330');
 
 }