v30

List of changes

PlaylistMediaRelation table

• Updating media_id ON DELETE clause from SET NULL to CASCADE (!364 (merged))

MediaGroup table

• Store the number of media regardless of their presence in nb_video/nb_audio/nb_unknown (!359 (merged))
• Add a nb_present_video column (!359 (merged))
• Add a nb_present_audio column (!359 (merged))
• Add a nb_present_unknown column (!359 (merged))
• Remove nb_media column (!359 (merged))

Playlist table

• Add a nb_media column (!359 (merged))
• Add a nb_present_media column (!359 (merged))

Triggers

• Add playlist_update_nb_media_on_media_deletion (!359 (merged))
• Add playlist_update_nb_present_media (!359 (merged))

Rescan required:

• No

Used by: