diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2008-01-13 21:34:56 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2008-01-13 21:34:56 +0000 |
| commit | 7e154abae9113055bb935e7b95c55119bfaff208 (patch) | |
| tree | 97f885a6fc2ad55cc97a5f155dbc243605aac824 /lib/class/update.class.php | |
| parent | cba4a991c0f554c2b5e3dec7e882476ff73760bb (diff) | |
| download | ampache-7e154abae9113055bb935e7b95c55119bfaff208.tar.gz ampache-7e154abae9113055bb935e7b95c55119bfaff208.tar.bz2 ampache-7e154abae9113055bb935e7b95c55119bfaff208.zip | |
- Fixed search by rating (Thx alex2008)
- Fixed no result return on random methods
- Added mime,language & lyrics to catalog updating functions
Diffstat (limited to 'lib/class/update.class.php')
| -rw-r--r-- | lib/class/update.class.php | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/lib/class/update.class.php b/lib/class/update.class.php index 75bc8fc3..5be760b4 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -258,6 +258,12 @@ 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); + return $version; } // populate_version @@ -1119,9 +1125,13 @@ class Update { $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"; + $sql = "ALTER TABLE `playlist` CHANGE `date` `date` INT ( 11 ) UNSIGNED NOT NULL"; + $db_results = Dba::query($sql); + + $sql = "ALTER TABLE `rating` CHANGE `rating` TINYINT ( 11 ) NOT NULL"; $db_results = Dba::query($sql); + self::set_version('db_version','340015'); } // update_340015 |