[Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[44084] branches/9.x/installer/schema/ 20100927_better_column_fix2_tiki.php

[<cha...@us...>]

Revision: 44084
          http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=44084&view=rev
Author:   changi67
Date:     2012-11-26 21:22:09 +0000 (Mon, 26 Nov 2012)
Log Message:
-----------
[BP/44083][FIX] Because some time we made mistake, that script is necessary to move from 5 to 6+ and fix tweetId, it was already fix in 6 but with the same name as in 5 so the script was not executed.

Added Paths:
-----------
    branches/9.x/installer/schema/20100927_better_column_fix2_tiki.php

Copied: branches/9.x/installer/schema/20100927_better_column_fix2_tiki.php (from rev 44083, branches/10.x/installer/schema/20100927_better_column_fix2_tiki.php)
===================================================================
--- branches/9.x/installer/schema/20100927_better_column_fix2_tiki.php	                        (rev 0)
+++ branches/9.x/installer/schema/20100927_better_column_fix2_tiki.php	2012-11-26 21:22:09 UTC (rev 44084)
@@ -0,0 +1,37 @@
+<?php
+// (c) Copyright 2002-2012 by authors of the Tiki Wiki CMS Groupware Project
+//
+// All Rights Reserved. See copyright.txt for details and a complete list of authors.
+// Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details.
+// $Id$
+
+if (strpos($_SERVER["SCRIPT_NAME"], basename(__FILE__)) !== false) {
+	header("location: index.php");
+	exit;
+}
+
+function upgrade_20100927_better_column_fix2_tiki($installer)
+{
+	global $dbs_tiki;
+
+	$result = $installer->getOne(
+		"SELECT COUNT(*) FROM information_schema.COLUMNS" .
+		" WHERE COLUMN_NAME='show_lastDownload' AND TABLE_NAME='tiki_file_galleries' AND TABLE_SCHEMA='" .
+		$dbs_tiki .
+		"';"
+	);
+
+	if ($result == 0) {
+		$result = $installer->query('ALTER TABLE `tiki_file_galleries` ADD COLUMN  `show_lastDownload` char(1) default NULL AFTER `show_hits`;');
+	}
+
+	$result = $installer->getOne(
+		"SELECT COUNT(*) FROM information_schema.COLUMNS" .
+		" WHERE COLUMN_NAME='tweetId' AND TABLE_NAME='tiki_shoutbox' AND TABLE_SCHEMA='" .
+		$dbs_tiki."';"
+	);
+
+	if ($result == 0) {
+		$result = $installer->query('ALTER TABLE `tiki_shoutbox` ADD COLUMN `tweetId` bigint(20) unsigned NOT NULL AFTER `hash`;');
+	}
+}

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.