From 6a0573d1fe8b12f1adacf3924de9808401f8e7b6 Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Tue, 1 Jan 2008 22:34:12 +0000 Subject: slight tweak to the random album art, needs improvement will look funny on catalogs with no art (for now) editing an mpd instance works, need to fix httpq editing and add instance testing --- lib/class/update.class.php | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'lib/class/update.class.php') diff --git a/lib/class/update.class.php b/lib/class/update.class.php index 9a6be243..75bc8fc3 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -1108,5 +1108,22 @@ class Update { } // update_340014 + /** + * update_340015 + * This update tweaks the playlist table responding to complaints from usres + * who say it doesn't work, unreproduceable. This also adds an index to the + * album art table to try to make the random album art faster + */ + public static function update_340015() { + + $sql = "ALTER TABLE `album_data` ADD INDEX `album_art` `album_id`,`art`(5)"; + $db_results = Dba::query($sql); + + $sql = "ALTER TABLE `playlist` CHANGE `date` `date` INT ( 11 ) UNSIGNED"; + $db_results = Dba::query($sql); + + + } // update_340015 + } // end update class ?> -- cgit