View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0019432 | MMW 5 | Help / Docs / Localization | public | 2022-10-06 17:01 | 2024-04-11 19:31 |
| Reporter | lowlander | Assigned To | |||
| Priority | urgent | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 5.0.4 | ||||
| Target Version | 5.1 | Fixed in Version | 5.1 | ||
| Summary | 0019432: Database structure wiki doesn't exist for MMW5 database | ||||
| Description | This is documented for MMW4, but for MMW5 this has not yet been created. | ||||
| Additional Information | https://www.mediamonkey.com/wiki/Database_Structure_(MM4) | ||||
| Tags | No tags attached. | ||||
| Fixed in build | |||||
|
|
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 |
|
|
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 |
