From 4d4712f34166a9138c6c2f627187bfcccbddd169 Mon Sep 17 00:00:00 2001
From: Karl 'vollmerk' Vollmer <vollmer@ampache.org>
Date: Sun, 1 Jul 2007 23:51:41 +0000
Subject: bunch of minor fixes and a db change

---
 lib/class/update.class.php | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'lib/class/update.class.php')

diff --git a/lib/class/update.class.php b/lib/class/update.class.php
index 79556491..067a3753 100644
--- a/lib/class/update.class.php
+++ b/lib/class/update.class.php
@@ -199,7 +199,10 @@ class Update {
 
 		$update_string = '- Alter the Session.id to be VARCHAR(64) to account for all potential configs.<br />' . 
 				'- Added new user_shout table for Sticky objects / shoutbox.<br />' . 
-				'- Added new playlist preferences, and new preference catagory of playlist.<br />';
+				'- Added new playlist preferences, and new preference catagory of playlist.<br />' . 
+				'- Tweaked Now Playing Table.<br />'; 
+
+		$version[] = array('version' => '340004','description' => $update_string); 
 
 		return $version;
 
@@ -685,6 +688,12 @@ class Update {
 		$sql = "ALTER TABLE `user_shout` ADD INDEX ( `user` )"; 
 		$db_results = Dba::query($sql); 
 
+		$sql = "ALTER TABLE `now_playing` CHANGE `start_time` `expire` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'"; 
+		$db_results = Dba::query($sql); 
+
+		$sql = "OPTIMIZE TABLE `album`"; 
+		$db_results = Dba::query($sql); 
+
 		// Update our database version now that we are all done
 		self::set_version('db_version','340004'); 
 
-- 
cgit