Devices table: Difference between revisions
Jump to navigation
Jump to search
m ({{DatabaseTablesList}} and formatting) |
(added asterisks for non IUNICODE fields) |
||
| Line 34: | Line 34: | ||
|- | |- | ||
| '''MusicMask''' | | '''MusicMask''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 40: | Line 40: | ||
|- | |- | ||
| '''ClassMusicMask''' | | '''ClassMusicMask''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 46: | Line 46: | ||
|- | |- | ||
| '''AudiobookMask''' | | '''AudiobookMask''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 52: | Line 52: | ||
|- | |- | ||
| '''PodcastMask''' | | '''PodcastMask''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 58: | Line 58: | ||
|- | |- | ||
| '''VideoPodcastMask''' | | '''VideoPodcastMask''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 64: | Line 64: | ||
|- | |- | ||
| '''VideoMask''' | | '''VideoMask''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 70: | Line 70: | ||
|- | |- | ||
| '''MusicVideoMask''' | | '''MusicVideoMask''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 76: | Line 76: | ||
|- | |- | ||
| '''TVMask''' | | '''TVMask''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 280: | Line 280: | ||
|- | |- | ||
| '''ImagePath''' | | '''ImagePath''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 286: | Line 286: | ||
|- | |- | ||
| '''WirelessIDString''' | | '''WirelessIDString''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 292: | Line 292: | ||
|- | |- | ||
| '''CopyToPCFolder''' | | '''CopyToPCFolder''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
| Line 346: | Line 346: | ||
|- | |- | ||
| '''customJSON''' | | '''customJSON''' | ||
| TEXT | | TEXT* | ||
| | | | ||
| | | | ||
Latest revision as of 16:17, 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 | 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 |
