When are database fields set / reset?
Posted: Wed Feb 08, 2023 12:52 pm
I'm looking for an unused (in my installation) integer field in the Songs table that I can use in scripts - a field that will not be reset by MediaMonkey during a library (re)scan, etc. I cannot find a description of when MediaMonkey sets fields in the database. So I've got some questions about fields that seem to be in their initial and/or unused condition in our Songs table.
Are video- and web-related fields ever set by MM when scanning an audio-only library (e.g., only MP3 files)?
What is the "Seekable" field and when is it set?
What is the PreviewState field? (It looks like were using PreviewName as a "custom" field at some point.)
What are the SignType and SignPart1,2,3 fields?
What sets the AudioCDTrack field?
What sets OriginalFileLength?
What sets IDEpisode?
What sets TrackType? (All ours are 0, but I suspect this field is actually used by MM.)
What sets OrigYear? (All ours are -1, 0, or null - nothing that looks like a date.)
What sets ContainerType?
What sets StreamCount? ParentalRating?
(And yes, I know I could use a "Custom" field, but we are already using 4 of them, and I think they are character rather than integer fields.)
Are video- and web-related fields ever set by MM when scanning an audio-only library (e.g., only MP3 files)?
What is the "Seekable" field and when is it set?
What is the PreviewState field? (It looks like were using PreviewName as a "custom" field at some point.)
What are the SignType and SignPart1,2,3 fields?
What sets the AudioCDTrack field?
What sets OriginalFileLength?
What sets IDEpisode?
What sets TrackType? (All ours are 0, but I suspect this field is actually used by MM.)
What sets OrigYear? (All ours are -1, 0, or null - nothing that looks like a date.)
What sets ContainerType?
What sets StreamCount? ParentalRating?
(And yes, I know I could use a "Custom" field, but we are already using 4 of them, and I think they are character rather than integer fields.)