View Issue Details

IDProjectCategoryView StatusLast Update
0019432MMW 5Help / Docs / Localizationpublic2024-05-23 21:30
Reporterlowlander Assigned To 
PriorityurgentSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version5.0.4 
Target Version5.1Fixed in Version5.1 
Summary0019432: Database structure wiki doesn't exist for MMW5 database
DescriptionThis is documented for MMW4, but for MMW5 this has not yet been created.
Additional Informationhttps://www.mediamonkey.com/wiki/Database_Structure_(MM4)
TagsNo tags attached.
Fixed in build

Activities

Ludek

2022-10-12 11:41

developer   ~0069760

Last edited: 2022-10-12 11:57

MM5 database structure is almost identical to MM4 structure, the changes are:

1) LastTreePath table is no longer used anymore (all UI related settings stored within persistent.json now)

2) Three new tables in MM5:
Pinned (to store links to Pinned items)
Radio (to store radio links re the new Radio node)
URLRequestCache (just for caching purposes).

3) There are some new columns added to several DB tables:

-TABLE Songs:
BPS INTEGER
Custom6 TEXT COLLATE IUNICODE
Custom7 TEXT COLLATE IUNICODE
Custom8 TEXT COLLATE IUNICODE
Custom9 TEXT COLLATE IUNICODE
Custom10 TEXT COLLATE IUNICODE
ExtendedTags TEXT COLLATE IUNICODE
ArtworkModified REAL

-TABLE Covers:
PictureDataHash TEXT

-TABLE Podcasts:
ImageLink TEXT
CachedImageLink TEXT
WebLink TEXT

-TABLE PodcastEpisodes:
mime TEXT

-TABLE Medias:
MusicBrainzDiscId TEXT

-TABLE Artists:
PictureDataHash TEXT
MBGID TEXT
LastTimeShown REAL

-TABLE Devices:
Capacity INTEGER
OtherContentSize INTEGER DEFAULT 0
handlerID TEXT DEFAULT ''usb'''
customJSON TEXT

-TABLE Playlists:
PictureDataHash TEXT
ImageCollageInfo TEXT
QueryDataJSON TEXT

-TABLE Filters:
criteriaJSON TEXT

-TABLE Albums:
MBGID TEXT
MBRGGID TEXT
LastTimeShown REAL
TVDBID INTEGER

-TABLE RemoteClients:
LastAccessTime REAL

-TABLE DeviceTracks:
SyncID TEXT
SourceInfo TEXT
LastMetaHash TEXT

-TABLE Downloads:
TrackID INTEGER
TargetMask TEXT

drakinite

2024-04-11 19:31

developer   ~0075087

Done.

- RemoteClients and Downloads tables did not have pages on them, so I created new ones but did not add descriptions for most of the fields.
- Added Pinned, Radio, and URLRequestCache tables and since I was able to understand most of the fields, I wrote descriptions and examples of most.
- Also edited the formatting of the pages/tables so that they are more consistent.
- Also, noticed a few fields that were added after this issue was written, which I marked as being added in 5.1 after checking the SVN commit dates for the additions.
- Renamed the Database Structure (MM4) page to Database Structure, added MM5+ database location, and did a bit of cleanup

peke

2024-05-23 21:30

developer   ~0075497

Looks OK for now closing