Ampache :: For the Love of Music

Version: 8.0.0 Build: 000
- Add ui option 'api_enable_8' to enable/disable API8
Version: 8.0.0 Build: 001
- Enable Opensubsonic for all users with `subsonic_legacy` enabled.
Version: 8.0.0 Build: 004
- Add 'folder' to `object_type` enum for `cache_object_count` table` table
- Add 'folder' to `object_type` enum for `cache_object_count_run` table
- Add 'folder' to `object_type` enum for `image` table
- Add 'folder' to `object_type` enum for `object_count` table
- Add 'folder' to `object_type` enum for `rating` table
- Add 'folder' to `object_type` enum for `tag_map` table
- Add 'folder' to `object_type` enum for `user_activity` table
- Add 'folder' to `object_type` enum for `user_flag` table
Version: 8.0.0 Build: 005
- Add a default limit of 500 to `direct_play_limit` to stop playing items with thousands of tracks
Version: 8.0.0 Build: 006
- Add `show_folder` preference to show/hide Sidebar the Browse menu link
Version: 8.0.0 Build: 007
- Add `folder` table for mapping folder's to library items
Version: 8.0.0 Build: 009

Warning
Please consider using the CLI for this update (`php bin/cli admin:updateDatabase -e`) Ampache Wiki,
- Add weight columns to folder table
Version: 8.0.0 Build: 010
- Create `folder_map` table for browsing Folder's and items together
Version: 8.0.0 Build: 011
- Remove obsolete `webplayer_flash`, `webplayer_aurora` and `use_play2` preferences
Version: 8.0.0 Build: 012
- Allow the system user (-1) in `object_count`, `user_activity`, `user_data` and `now_playing` on databases where `user` was UNSIGNED
- Attribute existing `share.php` plays to the system user (-1) instead of user 0
Version: 8.0.0 Build: 013
- Add `object_count_summary` table to allow consolidating old play history
Version: 8.0.0 Build: 014
- Drop redundant `object_count` indexes covered by existing keys
Version: 8.0.0 Build: 015
- Add `object_count_archive` table to retain consolidated play history detail
Version: 8.0.0 Build: 016
- Add per-user `encode_target`, `encode_video_target`, `encode_player_webplayer_target` and `encode_player_api_target` transcoding preferences
Version: 8.0.0 Build: 017
- Add per-user `max_bit_rate`/`min_bit_rate` dynamic-downsampling preferences (stored in bps)
Version: 8.0.0 Build: 018
- Store `transcode_bitrate` in bits per second (bps) and migrate existing kilobit values
Version: 8.0.0 Build: 020
- Remove the obsolete `webplayer_html5` preference
Version: 8.0.0 Build: 021
- Add the `mini_player` preference to lock a user into the mini player interface
Version: 8.0.0 Build: 022
- Remove the obsolete `ajax_load` preference
Version: 8.0.0 Build: 023
- Correct stored art mime types written from a filename extension (`image/jpg` -> `image/jpeg`)
Version: 8.0.0 Build: 024
- Add the `cron_cache_live_count` preference for accurate played counts when the cache is enabled
Version: 8.0.0 Build: 025
- Add `subsonic_secret` to the `user` table to allow Subsonic token authentication without the api key
Version: 8.0.0 Build: 026
- Correct the misleading `disabled_custom_metadata_fields_input` preference label
Version: 8.0.0 Build: 027
- Add the per-player `transcode_bitrate_webplayer` and `transcode_bitrate_api` bitrate overrides
Version: 8.0.0 Build: 028
- Create `collection` and `collection_map` tables for curating lists of any object type
Version: 8.0.0 Build: 029
- Add a maintained `last_played` column to the tables carrying a play counter
Version: 8.0.0 Build: 030
- Add `show_collection` preference to show/hide the Collections sidebar link
Version: 8.0.0 Build: 031
- Allow a `collection` to be rated and flagged
Version: 8.0.0 Build: 032
- Add `position_ms`, `playback_rate` and `state` to `now_playing` for OpenSubsonic playback reports
Version: 8.0.0 Build: 033
- Add `artist`.`lastfm_url` to keep the last.fm page url with the cached artist info
Version: 8.0.0 Build: 034
- Allow `label_asso` to associate a label with an album as well as an artist
Version: 8.0.0 Build: 035
- Drop the unique key on `collection_map` so `unique_playlist` decides whether a collection allows duplicates
Version: 8.0.0 Build: 036
- Restore `album`.`subtitle`, `folder`.`playable`, `folder`.`weight` and the `folder_map` name/catalog/path columns on databases installed from a stale ampache.sql
Version: 8.0.0 Build: 037
- Add an index on `album`.`addition_time` and `artist`.`addition_time` so the newest lists can stop at the rows they show
Version: 8.0.0 Build: 038
- Add the missing `podcast` rows to `object_count` for episode plays that predate podcast play counting
- Remove the `update_counts` row from `update_info`, which timed a sweep that no longer exists
Version: 8.0.0 Build: 039
- Remove `folder` rows whose `path_name` is a bare directory name; the next catalog scan recreates them with their real path
Version: 8.0.0 Build: 040
- Remove the `7digital_api_key` and `7digital_secret_api_key` preferences; the plugin they configured has been deleted
Version: 8.0.0 Build: 041
- Add the `broadcast_private` preference; a new broadcast requires a session to listen unless its owner turns this off
Version: 8.0.0 Build: 042
- Widen `song_preview`.`file` to varchar(4096) so signed preview urls are not truncated
Version: 8.0.0 Build: 043
- Add `wanted` to the `image`.`object_type` enum so a wanted album keeps the art it gathered
Version: 8.0.0 Build: 044
- Add an index on `object_count`.`geo_latitude`, `geo_longitude` so a cached place name is a lookup
- Add an index on `user_flag`.`object_type`, `date` so the newest flagged lists stop at the rows they show
Version: 8.0.0 Build: 045
- Create `playlist_folder` and `playlist_folder_map` tables for organising lists into a per-user tree
Version: 8.0.0 Build: 046
- Add `bpm` to `song_data` table
Version: 8.0.0 Build: 047
- Add `mood` table
- Add `mood_map` table
- Add `show_mood` preference to show/hide the Moods sidebar link
Version: 8.0.0 Build: 048
- Add ui option ('hide_moods') Hide the Mood column in browse table rows
Version: 8.0.0 Build: 049
- Allow `tag_map` to hold a broadcast, and widen `tag_map` and `user_activity` `object_type` on installs seeded from the dump
Version: 8.0.0 Build: 050
- Drop redundant `user_preference` indexes covered by existing keys
Version: 8.0.1 Build: 001
- Drop redundant indexes that repeat the leading columns of a wider key on the same table
Version: 8.0.1 Build: 002
- Convert `stream_beautiful_url` into a system preference
Version: 8.0.1 Build: 003
- Restrict `headphones_api_url`/`headphones_api_key` to Manager level, since any regular user could point the server at an arbitrary address

Ampache Update

Warning