1 files changed, 54 insertions, 0 deletions
diff --git a/core/Updates/0.6.3.php b/core/Updates/0.6.3.php
new file mode 100644
index 0000000000..d4e5a8b38a
--- /dev/null
+++ b/core/Updates/0.6.3.php
@@ -0,0 +1,54 @@
+<?php
+/**
+ * Piwik - Open source web analytics
+ *
+ * @link http://piwik.org
+ * @license http://www.gnu.org/licenses/gpl-3.0.html Gpl v3 or later
+ * @version $Id$
+ *
+ * @category Piwik
+ * @package Updates
+ */
+
+/**
+ * @package Updates
+ */
+class Piwik_Updates_0_6_3 extends Piwik_Updates
+{
+	static function getSql($adapter = 'PDO_MYSQL')
+	{
+		return array(
+			'ALTER TABLE `'. Piwik_Common::prefixTable('log_visit') .'`
+				CHANGE `location_ip` `location_ip` INT UNSIGNED NOT NULL' => false,
+			'ALTER TABLE `'. Piwik_Common::prefixTable('logger_api_call') .'`
+				CHANGE `caller_ip` `caller_ip` INT UNSIGNED' => false,
+		);
+	}
+
+	static function update()
+	{
+		$config = Zend_Registry::get('config');
+		$dbInfos = $config->database->toArray();
+		if(!isset($dbInfos['schema']))
+		{
+			try {
+				if(is_writable( Piwik_Config::getDefaultUserConfigPath() ))
+				{
+					$dbInfos['schema'] = 'Myisam';
+					$config->database = $dbInfos;
+
+					$config->__destruct();
+					Piwik::createConfigObject();
+				}
+				else
+				{
+					throw new Exception('mandatory update failed');
+				}
+			} catch(Exception $e) {
+				throw new Piwik_Updater_UpdateErrorException("Please edit your config/config.ini.php file and add below <code>[database]</code> the following line: <br /><code>schema = Myisam</code>");
+			}
+		}
+
+		Piwik_Updater::updateDatabase(__FILE__, self::getSql());
+	}
+}