Covers table: Difference between revisions
Jump to navigation
Jump to search
(Creation) |
m (added asterisk for non IUNICODE field) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{DatabaseTablesList}} | |||
== Fields == | == Fields == | ||
{| border="1" | {| border="1" | ||
| Line 40: | Line 41: | ||
| INTEGER | | INTEGER | ||
| | | | ||
| | | This is an enum. | ||
|- | |- | ||
| '''PictureType''' | | '''PictureType''' | ||
| Line 46: | Line 47: | ||
| image/bmp, image/jpg, image/jpeg, image/png, etc. | | image/bmp, image/jpg, image/jpeg, image/png, etc. | ||
| Cover picture format | | Cover picture format | ||
|- | |||
| '''PictureDataHash''' | |||
| TEXT* | |||
| | |||
| First 16 digits of a MD5 hash of the cover image. | |||
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 |
