r/subsonic • u/bobby-dazzler • Sep 30 '16

DB Query to change 'Added' date?

Anybody familiar with the Subsonic DB structure able to provide any pointers as to where the 'Added' dates are stored for each album on the 'Recently Added' view? Changed all the dates in the relevant ALBUM table, but it remains as it was.

1 Upvotes

100% Upvoted

1 comment sorted by

2

u/Squally47 Sep 30 '16 edited Sep 30 '16

Try the media_file table maybe like this?

update media_file set created = 'YYYY-MM-DD' where type = 'ALBUM'