minor change to tag gather, some speed improvements on the catalog verify and more changes to democratic play, will not work currently due to missing db update that needs more testing

1 files changed, 15 insertions, 1 deletions

diff --git a/lib/class/update.class.php b/lib/class/update.class.php
index 42cd9b86..4d21c958 100644
--- a/lib/class/update.class.php
+++ b/lib/class/update.class.php
@@ -263,6 +263,12 @@ class Update {
 		
 		$version[] = array('version' => '340015','description'=>$update_string); 
 
+		$update_string = '- Alter the Democratic Playlist table, adding base_playlist.<br />' . 
+				'- Alter tmp_playlist to account for Democratic changes.<br />' . 
+				'- Cleared Existing Democratic playlists due to changes.<br />'; 
+
+//		$version[] = array('version' => '340016','description'=>$update_string); 
+
 		return $version;
 
 	} // populate_version
@@ -1167,8 +1173,16 @@ class Update {
 		$sql = "ALTER TABLE `democratic` ADD `base_playlist` INT( 11 ) UNSIGNED NOT NULL AFTER `name`"; 
 		$db_results = Dba::query($sql); 
 
-		self::set_version('db_version','340017'); 
+		$sql = "ALTER TABLE `tmp_playlist` DROP `base_playlist`"; 
+		$db_results = Dba::query($sql); 
 
+		$sql = "DELETE FROM `tmp_playlist` WHERE `session`='-1'"; 
+		$db_results = Dba::query($sql); 
+
+		$sql = "TRUNCATE `democratic`"; 
+		$db_results = Dba::query($sql); 
+
+		self::set_version('db_version','340017'); 
 
 	} // update_340017