Covers table: Difference between revisions
Jump to navigation
Jump to search
m ({{DatabaseTablesList}}) |
m (added asterisk for non IUNICODE field) |
||
| Line 49: | Line 49: | ||
|- | |- | ||
| '''PictureDataHash''' | | '''PictureDataHash''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| First 16 digits of a MD5 hash of the cover image. | | First 16 digits of a MD5 hash of the cover image. | ||
Added in version 5.0 | Added in version 5.0 | ||
|} | |} | ||
Latest revision as of 16:19, 11 April 2024
- [Database Structure]
- Albums
- Artists
- ArtistsAlbums
- ArtistsSongs
- Covers
- DBInfo
- DeviceFilters
- DeviceTracks
- Devices
- Downloads
- Filters
- Folders
- FoldersHier
- Genres
- GenresSongs
- LastTreePath
- Lists
- ListsSongs
- Medias
- OrganizeRules
- PathProcessing
- Pinned
- Played
- PlaylistSongs
- Playlists
- PodcastDirs
- PodcastEpisodes
- Podcasts
- Radio
- RemoteClients
- Songs
- SynchAlbum
- SynchArtist
- SynchLocation
- SynchPlaylist
- SynchPodcast
- URLRequestCache
Fields
| Name | Value Type | Possible Values | Description |
|---|---|---|---|
| ID | INTEGER | AUTOINCREMENT (1 to inf.) | |
| IDSong | INTEGER | ||
| CoverOrder | INTEGER | ||
| CoverPath | TEXT | filename | Name of cover file in folder (if applicable) |
| CoverStorage | INTEGER | ||
| Cover Description | TEXT | Any | Info/Comment about the cover |
| CoverType | INTEGER | This is an enum. | |
| PictureType | TEXT | image/bmp, image/jpg, image/jpeg, image/png, etc. | Cover picture format |
| PictureDataHash | TEXT* | First 16 digits of a MD5 hash of the cover image.
Added in version 5.0 |
