diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2008-03-06 04:55:19 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2008-03-06 04:55:19 +0000 |
| commit | 84b483c99a32452dc53b9b77fdf818c710bcd5d3 (patch) | |
| tree | 62aa6939acb5434bb530d327f78ba3329b146fb7 /lib/class/update.class.php | |
| parent | 2c337852cff31297d681fb87d3098cc3d9041101 (diff) | |
| download | ampache-84b483c99a32452dc53b9b77fdf818c710bcd5d3.tar.gz ampache-84b483c99a32452dc53b9b77fdf818c710bcd5d3.tar.bz2 ampache-84b483c99a32452dc53b9b77fdf818c710bcd5d3.zip | |
fixed playlist update on full strict of mysql5.x and jpg mime type
Diffstat (limited to 'lib/class/update.class.php')
| -rw-r--r-- | lib/class/update.class.php | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/lib/class/update.class.php b/lib/class/update.class.php index 9e902d52..66322cd7 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -259,10 +259,9 @@ class Update { $version[] = array('version' => '340014','description'=>$update_string); $update_string = '- Alter Playlist Date Field to fix issues with some MySQL configurations.<br />' . - '- Add Index to Album_Data to improve album art random performance.<br />' . '- Alter Rating type to correct AVG issue on searching.<br />'; - //$version[] = array('version' => '340015','description'=>$update_string); + $version[] = array('version' => '340015','description'=>$update_string); return $version; @@ -1132,15 +1131,15 @@ class Update { */ public static function update_340015() { - $sql = "ALTER TABLE `playlist` CHANGE `date` `date` INT ( 11 ) UNSIGNED NOT NULL"; + $sql = "ALTER TABLE `playlist` DROP `date`"; + $db_results = Dba::query($sql); + + $sql = "ALTER TABLE `playlist` ADD `date` INT ( 11 ) UNSIGNED NOT NULL"; $db_results = Dba::query($sql); $sql = "ALTER TABLE `rating` CHANGE `rating` TINYINT ( 4 ) NOT NULL"; $db_results = Dba::query($sql); -// $sql = "ALTER TABLE `user` CHANGE `validation` VARCHAR ( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL"; -// $db_results = Dba::query($sql); - self::set_version('db_version','340015'); } // update_340015 |