From a08a42eec0f419cf9db07fd155ecb0a661556656 Mon Sep 17 00:00:00 2001
From: Karl 'vollmerk' Vollmer <vollmer@ampache.org>
Date: Mon, 26 Nov 2007 03:49:40 +0000
Subject: bump to alpha4, db update adds democratic table and add_path to
 catalog

---
 lib/class/update.class.php | 36 ++++++++++++++++++++++++++++++++++--
 1 file changed, 34 insertions(+), 2 deletions(-)

(limited to 'lib/class')

diff --git a/lib/class/update.class.php b/lib/class/update.class.php
index eda00d70..6f36a107 100644
--- a/lib/class/update.class.php
+++ b/lib/class/update.class.php
@@ -242,6 +242,10 @@ class Update {
 
 		$version[] = array('version' => '340011','description'=>$update_string); 
 
+		$update_string = '- Added Democratic Table for new democratic play features.<br />' . 
+				'- Added Add Path to Catalog to improve add speeds on large catalogs.<br />'; 
+		
+		$version[] = array('version' => '340012','description'=>$update_string); 
 
 		return $version;
 
@@ -1001,14 +1005,42 @@ class Update {
                         "`expire` INT( 11 ) UNSIGNED NOT NULL , " .
                         "`ip` INT( 11 ) UNSIGNED NULL , " .
                         "PRIMARY KEY ( `id` ) " .
-                        ") ENGINE = MYISAM";
+                        ") ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
                 $db_results = Dba::query($sql);
 
 
 		self::set_version('db_version','340011'); 		
-				
 
 	} // 340011
 
+	/**
+	 * update_340012
+	 * This update adds in the democratic stuff, checks for some potentially screwed up indexes
+	 * and removes the timestamp from the playlist, and adds the field to the catalog for the upload dir
+	 */
+	public static function update_340012() { 
+
+		$sql = "ALTER TABLE `catalog` ADD `add_path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `path`"; 
+		$db_results = Dba::query($sql); 
+
+		$sql = "CREATE TABLE `democratic` (`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ," . 
+			"`name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ," . 
+			"`cooldown` TINYINT( 4 ) UNSIGNED NULL ," . 
+			"`level` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '25'," . 
+			"`user` INT( 11 ) NOT NULL ," . 
+			"`primary` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'" . 
+			") ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"; 
+		$db_results = Dba::query($sql); 
+
+		$sql = "ALTER TABLE `democratic` ADD INDEX (`primary`)"; 
+		$db_results = Dba::query($sql); 
+
+		$sql = "ALTER TABLE `democratic` ADD INDEX (`level`)"; 
+		$db_results = Dba::query($sql);
+
+		self::set_version('db_version','340012'); 
+
+	} // update_340012
+
 } // end update class
 ?>
-- 
cgit