From d267ba7fe4550f07221f1fea731d4b2d82063038 Mon Sep 17 00:00:00 2001
From: Robert Sesek <rsesek@bluestatic.org>
Date: Sun, 11 Mar 2007 23:33:07 +0000
Subject: [PATCH] r1450: Adding upgrade11.php as the upgrade script from 1.1.5
 to 1.2.0b1

---
 install/global.php    |   3 +-
 install/upgrade11.php | 173 ++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 175 insertions(+), 1 deletion(-)
 create mode 100644 install/upgrade11.php

diff --git a/install/global.php b/install/global.php
index 77cd0c1..755a29f 100644
--- a/install/global.php
+++ b/install/global.php
@@ -83,7 +83,8 @@ $bugsys->versions = array(
 	'1.1.2'						=> 8,
 	'1.1.3'						=> 9,
 	'1.1.4'						=> 10,
-	'1.1.5'						=> -1
+	'1.1.5'						=> 11,
+	'1.2.0 Beta 1'				=> -1
 );
 
 // ###################################################################
diff --git a/install/upgrade11.php b/install/upgrade11.php
new file mode 100644
index 0000000..4564aea
--- /dev/null
+++ b/install/upgrade11.php
@@ -0,0 +1,173 @@
+<?php
+/*=====================================================================*\
+|| ###################################################################
+|| # Bugdar [#]version[#]
+|| # Copyright ©2002-[#]year[#] Blue Static
+|| #
+|| # 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; version [#]gpl[#] of the License.
+|| #
+|| # This program is distributed in the hope that it will be useful, but
+|| # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
+|| # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
+|| # more details.
+|| #
+|| # You should have received a copy of the GNU General Public License along
+|| # with this program; if not, write to the Free Software Foundation, Inc.,
+|| # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
+|| ###################################################################
+\*=====================================================================*/
+
+define('STOP_MARK', 4);
+define('ACTIVE_SITE', 'upgrade11.php');
+
+require_once('./global.php');
+require_once('./includes/functions_datastore.php');
+
+page_start();
+
+// ###################################################################
+
+if ($bugsys->in['mark'] == 0)
+{
+?>
+<h1>Welcome to Bugdar</h1>
+
+<p>This upgrade will move you from Bugdar 1.1.5 to Bugdar 1.2.0 Beta 1.</p>
+
+<p>To begin the process, please click the button below.</p>
+<?php
+}
+
+// ###################################################################
+
+if ($bugsys->in['mark'] == 1)
+{
+?>
+<h1>Minor Database Table Changes</h1>
+
+<p>There are a few minor changes made to Bugdar's database schema that need to be propagated.</p>
+<?php
+	
+	$db->query("ALTER TABLE " . TABLE_PREFIX . "comment ADD parselinks BOOL NULL");
+	echo "Adding comment.parselinks to add an option to parse links in comments<br />\n";
+	
+	$db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD columnoptions TEXT NULL");
+	echo "Adding user.columnoptions to allow for custom column sorting<br />\n";
+
+	$db->query("ALTER TABLE " . TABLE_PREFIX . "product CHANGE componentmother parentid INT UNSIGNED NULL");
+	echo "Renaming product.componentmother to product.parentid<br />\n";
+	
+	$db->query("ALTER TABLE " . TABLE_PREFIX . "version ADD obsolete BOOL NULL");
+	echo "Adding version.obsolete so products cannot be filed against certain versions<br />\n";
+	
+	$db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD authid VARCHAR(255) NULL");
+	echo "Adding user.authid for the Authentication API<br />\n";
+	
+	echo "... done<br />\n";
+}
+
+// ###################################################################
+
+if ($bugsys->in['mark'] == 2)
+{
+?>
+<h1>Search Table Changes</h1>
+
+<p>To support saved searches, a few major modifications need to be performed on the search table.</p>
+<?php
+	
+	$db->query("ALTER TABLE " . TABLE_PREFIX . "search DROP PRIMARY KEY");
+	echo "Dropping current primary key<br />\n";
+	
+	$db->query("ALTER TABLE " . TABLE_PREFIX . "search ADD searchid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY");
+	echo "Adding search.searchid as a new primary key<br />\n";
+	
+	$db->query("ALTER TABLE " . TABLE_PREFIX . "search ADD name VARCHAR(250) NULL");
+	echo "Adding search.name to allow naming of searches<br />\n";
+	
+	echo "... done<br />\n";
+}
+
+// ###################################################################
+
+if ($bugsys->in['mark'] == 3)
+{
+?>
+<h1>Database Table Additions</h1>
+
+<p>A few new features require new database tables, so we're adding those now.</p>
+<?php
+	
+	$db->query("
+		CREATE TABLE " . TABLE_PREFIX . "passwordreset
+		(
+			activatorid VARCHAR(250) NOT NULL, 
+			userid INT NOT NULL, 
+			dateline INT NOT NULL,
+			PRIMARY KEY (activatorid)
+		)
+	");
+	echo "Creating passwordreset table to create a 'lost password' functionality<br />\n";
+	
+	$db->query("
+		CREATE TABLE " . TABLE_PREFIX . "adminsession
+		(
+			sessionid VARCHAR(250) NOT NULL, 
+			userid INT UNSIGNED NOT NULL, 
+			dateline INT UNSIGNED NOT NULL,
+			PRIMARY KEY (sessionid)
+		)
+	");
+	echo "Creating adminsession table to greatly improve the admin control panel security<br />\n";
+	
+	$db->query("
+		CREATE TABLE " . TABLE_PREFIX . "template
+		(
+			filename VARCHAR(255) NOT NULL,
+			template TEXT NOT NULL,
+			timestamp INT(10) UNSIGNED NOT NULL,
+			PRIMARY KEY  (filename)
+		)
+	");
+	echo "Creating template table to cache templates in the database to greatly inprove speed<br />\n";
+	
+	echo "... done<br />\n";
+}
+
+// ###################################################################
+
+if ($bugsys->in['mark'] == 4)
+{
+?>
+<h1>Version Number Change</h1>
+
+<p>This step finishes the upgrade by inreasing your version number.</p>
+
+<?php
+	
+	require_once('./includes/settings.php');
+		
+	$db->query("UPDATE " . TABLE_PREFIX . "setting SET value = '1.2.0 Beta 1' WHERE varname = 'trackerversion'");
+	
+	build_settings();
+	
+?>
+
+... done.
+
+<?php
+}
+
+// ###################################################################
+
+page_end();
+
+/*=====================================================================*\
+|| ###################################################################
+|| # $HeadURL$
+|| # $Id$
+|| ###################################################################
+\*=====================================================================*/
+?>
\ No newline at end of file
-- 
2.22.5