|
|
|
# Model v37
|
|
|
|
|
|
|
|
### List of changes:
|
|
|
|
|
|
|
|
#### Label
|
|
|
|
|
|
|
|
* Add an `entity_type` column to the relation table (https://code.videolan.org/videolan/medialibrary/-/merge_requests/669/diffs?commit_id=6973dff53e562251b64423e0e713cb5fc174cb46)
|
|
|
|
|
|
|
|
#### Folder
|
|
|
|
|
|
|
|
* Add a `duration` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/670/diffs?commit_id=409d3de20d3f9c46b72e60f8521382e1092eb6ee)
|
|
|
|
* Add a `is_public` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/667/diffs?commit_id=d198dacf1a87aa735613fd20941b2293c905e969)
|
|
|
|
* Add a `folder_update_is_public` trigger (https://code.videolan.org/videolan/medialibrary/-/merge_requests/667/diffs?commit_id=1d2a9525d109742c9ce3db7b8e94b7313117c548)
|
|
|
|
|
|
|
|
#### Media
|
|
|
|
|
|
|
|
* Add a `is_public` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/667/diffs?commit_id=525e28ae407d1405af4e9fa93a562e76a4b53c52)
|
|
|
|
* Add a `media_update_is_public` trigger (https://code.videolan.org/videolan/medialibrary/-/merge_requests/667/diffs?commit_id=f48656d1aefc52d4a544ad110f22a7bb9badc9ff)
|
|
|
|
* Add a `nb_subscriptions` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=979ef692f7902c09b335f044b32a8799e267a35d)
|
|
|
|
* Add a `description` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=83657d240cf7d47fd60e400edc4688821672b43c)
|
|
|
|
|
|
|
|
#### Album
|
|
|
|
|
|
|
|
* Add a `album_title_idx` index (https://code.videolan.org/videolan/medialibrary/-/merge_requests/686/diffs?commit_id=abc2378984aa37b7e763d49538604b31ebac6b77)
|
|
|
|
* Add an `is_favorite` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/693/diffs?commit_id=4216b051d096705a27ac608fe9c0900f82ec12e8)
|
|
|
|
|
|
|
|
#### Artist
|
|
|
|
|
|
|
|
* Add an `is_favorite` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/693/diffs?commit_id=9453128c53d39497696131529715546e64b0200f)
|
|
|
|
|
|
|
|
#### Genre
|
|
|
|
|
|
|
|
* Add an `is_favorite` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/693/diffs?commit_id=627c95c1a70a51a9a80e49cd06b5919e78ee71c5)
|
|
|
|
|
|
|
|
#### Subscription
|
|
|
|
|
|
|
|
* Add a `Subscription` table (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=ab4b7436ef31ae1eec6c80f5c356eb84d543ac46)
|
|
|
|
* Add a `SubscriptionMediaRelation` table (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=ab4b7436ef31ae1eec6c80f5c356eb84d543ac46)
|
|
|
|
* Add a `subscription_service_id_idx` index (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=ab4b7436ef31ae1eec6c80f5c356eb84d543ac46)
|
|
|
|
* Add a `subscription_rel_media_id_idx` index (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=ab4b7436ef31ae1eec6c80f5c356eb84d543ac46)
|
|
|
|
* Add a `subscription_rel_subscription_id_idx` index (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=ab4b7436ef31ae1eec6c80f5c356eb84d543ac46)
|
|
|
|
|
|
|
|
#### File
|
|
|
|
|
|
|
|
* Add a `subscription_id` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=c2022f7f59093de20f31952073b13cbb26a3582c)
|
|
|
|
|
|
|
|
#### Task
|
|
|
|
|
|
|
|
* Add a `task_delete_subscription_linking_tasks` trigger (https://code.videolan.org/videolan/medialibrary/-/merge_requests/678/diffs?commit_id=27b224f0e46e4f87eff8979b47fa4dbb6e4c39f8)
|
|
|
|
|
|
|
|
### Rescan required:
|
|
|
|
|
|
|
|
No
|
|
|
|
|
|
|
|
### Associated milestone:
|
|
|
|
|
|
|
|
%"0.13.0"
|
|
|
|
|
|
|
|
### Used by: |
