Devices table
- [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 | Other attributes | Possible Values | Description |
|---|---|---|---|---|
| ID | INTEGER | PRIMARY KEY AUTOINCREMENT | ||
| PluginName | TEXT | COLLATE IUNICODE | ||
| SynchAll | INTEGER | |||
| AdvancedSynch | INTEGER | |||
| MusicMask | TEXT* | |||
| ClassMusicMask | TEXT* | |||
| AudiobookMask | TEXT* | |||
| PodcastMask | TEXT* | |||
| VideoPodcastMask | TEXT* | |||
| VideoMask | TEXT* | |||
| MusicVideoMask | TEXT* | |||
| TVMask | TEXT* | |||
| SaveAAToFolder | INTEGER | |||
| SaveAAToTag | INTEGER | |||
| RemoveAAFromTag | INTEGER | |||
| RemoveAAByteRate | INTEGER | |||
| SyncAAMask | TEXT | COLLATE IUNICODE | ||
| DetailedUSBID | TEXT | COLLATE IUNICODE | ||
| CopyM3U | INTEGER | |||
| PlaylistFormat | TEXT | COLLATE IUNICODE | ||
| M3UFolder | TEXT | COLLATE IUNICODE | ||
| M3UFlags | INTEGER | |||
| M3UCopyLocations | INTEGER | |||
| M3UCopyArtists | INTEGER | |||
| M3UCopyAlbums | INTEGER | |||
| M3UCopyPlaylists | INTEGER | |||
| M3UOrganize | INTEGER | |||
| DeleteUnsynch | INTEGER | |||
| DeleteConfirm | INTEGER | |||
| DeleteUnknown | INTEGER | |||
| DeleteConfirmUnknown | INTEGER | |||
| ResyncOnMaskChange | INTEGER | |||
| BiDirSync | INTEGER | |||
| BiDirConfirm | INTEGER | |||
| BiDirSyncMetadata | INTEGER | |||
| SynchOnConnect | INTEGER | |||
| ScanOnConnect | INTEGER | |||
| AllowWifiSync | INTEGER | |||
| DeviceID | TEXT | COLLATE IUNICODE | ||
| DeviceCaption | TEXT | COLLATE IUNICODE | ||
| AutoUnmount | INTEGER | |||
| DontDelete | TEXT | COLLATE IUNICODE | ||
| SyncBackFolders | TEXT | COLLATE IUNICODE | ||
| ScanFolders | TEXT | COLLATE IUNICODE | ||
| AutoConversions | TEXT | COLLATE IUNICODE | ||
| ImagePath | TEXT* | |||
| WirelessIDString | TEXT* | |||
| CopyToPCFolder | TEXT* | |||
| Invisible | INTEGER | |||
| LastAutoSynch | FLOAT | |||
| LastChangedACRulesTm | FLOAT | |||
| FirstGenre | INTEGER | |||
| FirstArtist | INTEGER | |||
| Capacity | INTEGER | Added in version 5.0 | ||
| OtherContentSize | INTEGER DEFAULT 0 | Added in version 5.0 | ||
| handlerID | TEXT DEFAULT "usb" | Added in version 5.0 | ||
| customJSON | TEXT* | Added in version 5.0 | ||
| convertArtwork | INTEGER DEFAULT 0 | Added in version 5.1 | ||
| convertArtworkType | STRING DEFAULT "JPG" | Added in version 5.1 | ||
| resizeArtwork | INTEGER DEFAULT 0 | Added in version 5.1 | ||
| resizeArtworkMaxRes | INTEGER DEFAULT 500 | Maximum resolution of artwork when converted for the device.
Added in version 5.1 |
