Ampache :: For the Love of Music

Version: 6.0.0 Build: 005
WARNING Please consider using the CLI for this update (php bin/cli admin:updateDatabase -e) Ampache Wiki
* Migrate multi-disk albums to single album id's
Version: 6.0.0 Build: 006
* Add `disk_count` to album table
Version: 6.0.0 Build: 007
* Fill album_disk table update count tables
Version: 6.0.0 Build: 008
* Rename `artist`.`album_group_count` => `album_disk_count`
Version: 6.0.0 Build: 009
* Drop `disk` from the `album` table
Version: 6.0.0 Build: 010
* Rename `user_data` album keys
Version: 6.0.0 Build: 011
* Add `album_disk` to enum types for `object_count`, `rating` and `cache_object_count` tables
Version: 6.0.0 Build: 012
* Add `song_artist` and `album_artist` maps to catalog_map
* This is a duplicate of `update_550004` But may have been skipped depending on your site's version history
Version: 6.0.0 Build: 013
* Add ui option 'api_enable_6' to enable/disable API6
Version: 6.0.0 Build: 014
* Add `subtitle` to the album table
Version: 6.0.0 Build: 015
* Add `streamtoken` to user table allowing permalink music stream access
Version: 6.0.0 Build: 016
* Add `object_type_IDX` to artist_map table
* Add `object_type_IDX` to catalog_map table
Version: 6.0.0 Build: 018
* Drop `user_playlist` table and recreate it
Version: 6.0.0 Build: 019
* During migration some album_disk data may be missing it's object type
Version: 6.0.0 Build: 020
* Set system preferences to Admin (100)
* These options are only available to Admin users anyway
Version: 6.0.0 Build: 021
* Extend `time` column for the song table
Version: 6.0.0 Build: 022
* Extend `time` column for the stream_playlist table
Version: 6.0.0 Build: 023
* Add upload_access_level to restrict uploads to certain user groups
Version: 6.0.0 Build: 024
* Add ui option ('show_subtitle') Show Album subtitle on links (if available)
* Add ui option ('show_original_year') Show Album original year on links (if available)
Version: 6.0.0 Build: 025
* Add ui option ('show_header_login') Show the login / registration links in the site header
Version: 6.0.0 Build: 026
* Add user preference `use_play2`, Use an alternative playback action for streaming if you have issues with playing music
Version: 6.0.0 Build: 027
* Rename `subtitle` to `version` in the `album` table
Version: 6.0.0 Build: 028
* Add `bitrate`, `rate`, `mode` and `channels` to the `podcast_episode` table
Version: 6.0.0 Build: 032
* Extend `object_type` enum list on `rating` table
Version: 6.0.0 Build: 033
* Convert `object_type` to an enum on `user_flag` table
Version: 6.0.0 Build: 034
* Convert `object_type` to an enum on `image` table
Version: 6.0.0 Build: 035
* Add `enabled` to `podcast_episode` table
Version: 6.0.0 Build: 036
* Update user `play_size` and catalog `size` fields to megabytes (Stop large catalogs overflowing 32bit ints)
Version: 6.0.0 Build: 037
* Update user server and user counts now that the scaling has changed
Version: 6.0.0 Build: 038
* Update `access_list` in case you have a bad `user` column
Version: 6.0.0 Build: 039
* Add user preference `custom_timezone`, Display dates using a different timezone to the server timezone
Version: 6.0.0 Build: 040
* Add `disksubtitle` to `song_data` and `album_disk` table
Version: 6.0.0 Build: 041
* Index `label` column on the `label_asso` table
Version: 6.0.0 Build: 042
* Add user preference `bookmark_latest`, Only keep the latest media bookmark
Version: 6.0.0 Build: 043
* Set correct preference type for `use_play2`
* Add user preference `jp_volume`, Default webplayer volume
Version: 6.0.0 Build: 044
* Add system preference `perpetual_api_session`, API sessions do not expire
Version: 6.0.0 Build: 045
* Add column `last_update` and `date`to search table
Version: 6.0.0 Build: 046
* Add user preference `home_recently_played_all`, Show all media types in Recently Played
Version: 6.0.0 Build: 047
* Add user preference `show_wrapped`, Enable access to your personal "Spotify Wrapped" from your user page
Version: 6.0.0 Build: 048
* Add `date` column to rating table
Version: 6.0.0 Build: 049
* Update link for `FMPL` license

Ampache Update