Devices table: Difference between revisions

From MediaMonkey Wiki
Jump to navigation Jump to search
No edit summary
(added asterisks for non IUNICODE fields)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{DatabaseTablesList}}
== Fields ==
== Fields ==
{| border="1"
{| border="1"
Line 8: Line 9:
! Description
! Description
|-
|-
| ID
| '''ID'''
| INTEGER
| INTEGER
| PRIMARY KEY AUTOINCREMENT
| PRIMARY KEY AUTOINCREMENT
Line 14: Line 15:
|
|
|-
|-
| PluginName
| '''PluginName'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 20: Line 21:
|
|
|-
|-
| SynchAll
| '''SynchAll'''
| INTEGER
| INTEGER
|
|
Line 26: Line 27:
|
|
|-
|-
| AdvancedSynch
| '''AdvancedSynch'''
| INTEGER
| INTEGER
|
|
Line 32: Line 33:
|
|
|-
|-
| MusicMask
| '''MusicMask'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| ClassMusicMask
| '''ClassMusicMask'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| AudiobookMask
| '''AudiobookMask'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| PodcastMask
| '''PodcastMask'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| VideoPodcastMask
| '''VideoPodcastMask'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| VideoMask
| '''VideoMask'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| MusicVideoMask
| '''MusicVideoMask'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| TVMask
| '''TVMask'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| SaveAAToFolder
| '''SaveAAToFolder'''
| INTEGER
| INTEGER
|
|
Line 86: Line 87:
|
|
|-
|-
| SaveAAToTag
| '''SaveAAToTag'''
| INTEGER
| INTEGER
|
|
Line 92: Line 93:
|
|
|-
|-
| RemoveAAFromTag
| '''RemoveAAFromTag'''
| INTEGER
| INTEGER
|
|
Line 98: Line 99:
|
|
|-
|-
| RemoveAAByteRate
| '''RemoveAAByteRate'''
| INTEGER
| INTEGER
|
|
Line 104: Line 105:
|
|
|-
|-
| SyncAAMask
| '''SyncAAMask'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 110: Line 111:
|
|
|-
|-
| DetailedUSBID
| '''DetailedUSBID'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 116: Line 117:
|
|
|-
|-
| CopyM3U
| '''CopyM3U'''
| INTEGER
| INTEGER
|
|
Line 122: Line 123:
|
|
|-
|-
| PlaylistFormat
| '''PlaylistFormat'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 128: Line 129:
|
|
|-
|-
| M3UFolder
| '''M3UFolder'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 134: Line 135:
|
|
|-
|-
| M3UFlags
| '''M3UFlags'''
| INTEGER
| INTEGER
|
|
Line 140: Line 141:
|
|
|-
|-
| M3UCopyLocations
| '''M3UCopyLocations'''
| INTEGER
| INTEGER
|
|
Line 146: Line 147:
|
|
|-
|-
| M3UCopyArtists
| '''M3UCopyArtists'''
| INTEGER
| INTEGER
|
|
Line 152: Line 153:
|
|
|-
|-
| M3UCopyAlbums
| '''M3UCopyAlbums'''
| INTEGER
| INTEGER
|
|
Line 158: Line 159:
|
|
|-
|-
| M3UCopyPlaylists
| '''M3UCopyPlaylists'''
| INTEGER
| INTEGER
|
|
Line 164: Line 165:
|
|
|-
|-
| M3UOrganize
| '''M3UOrganize'''
| INTEGER
| INTEGER
|
|
Line 170: Line 171:
|
|
|-
|-
| DeleteUnsynch
| '''DeleteUnsynch'''
| INTEGER
| INTEGER
|
|
Line 176: Line 177:
|
|
|-
|-
| DeleteConfirm
| '''DeleteConfirm'''
| INTEGER
| INTEGER
|
|
Line 182: Line 183:
|
|
|-
|-
| DeleteUnknown
| '''DeleteUnknown'''
| INTEGER
| INTEGER
|
|
Line 188: Line 189:
|
|
|-
|-
| DeleteConfirmUnknown
| '''DeleteConfirmUnknown'''
| INTEGER
| INTEGER
|
|
Line 194: Line 195:
|
|
|-
|-
| ResyncOnMaskChange
| '''ResyncOnMaskChange'''
| INTEGER
| INTEGER
|
|
Line 200: Line 201:
|
|
|-
|-
| BiDirSync
| '''BiDirSync'''
| INTEGER
| INTEGER
|
|
Line 206: Line 207:
|
|
|-
|-
| BiDirConfirm
| '''BiDirConfirm'''
| INTEGER
| INTEGER
|
|
Line 212: Line 213:
|
|
|-
|-
| BiDirSyncMetadata
| '''BiDirSyncMetadata'''
| INTEGER
| INTEGER
|
|
Line 218: Line 219:
|
|
|-
|-
| SynchOnConnect
| '''SynchOnConnect'''
| INTEGER
| INTEGER
|
|
Line 224: Line 225:
|
|
|-
|-
| ScanOnConnect
| '''ScanOnConnect'''
| INTEGER
| INTEGER
|
|
Line 230: Line 231:
|
|
|-
|-
| AllowWifiSync
| '''AllowWifiSync'''
| INTEGER
| INTEGER
|
|
Line 236: Line 237:
|
|
|-
|-
| DeviceID
| '''DeviceID'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 242: Line 243:
|
|
|-
|-
| DeviceCaption
| '''DeviceCaption'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 248: Line 249:
|
|
|-
|-
| AutoUnmount
| '''AutoUnmount'''
| INTEGER
| INTEGER
|
|
Line 254: Line 255:
|
|
|-
|-
| DontDelete
| '''DontDelete'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 260: Line 261:
|
|
|-
|-
| SyncBackFolders
| '''SyncBackFolders'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 266: Line 267:
|
|
|-
|-
| ScanFolders
| '''ScanFolders'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 272: Line 273:
|
|
|-
|-
| AutoConversions
| '''AutoConversions'''
| TEXT
| TEXT
| COLLATE IUNICODE
| COLLATE IUNICODE
Line 278: Line 279:
|
|
|-
|-
| ImagePath
| '''ImagePath'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| WirelessIDString
| '''WirelessIDString'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| CopyToPCFolder
| '''CopyToPCFolder'''
| TEXT
| TEXT*
|
|
|
|
|
|
|-
|-
| Invisible
| '''Invisible'''
| INTEGER
| INTEGER
|
|
Line 302: Line 303:
|
|
|-
|-
| LastAutoSynch
| '''LastAutoSynch'''
| FLOAT
| FLOAT
|
|
Line 308: Line 309:
|
|
|-
|-
| LastChangedACRulesTm
| '''LastChangedACRulesTm'''
| FLOAT
| FLOAT
|
|
Line 314: Line 315:
|
|
|-
|-
| FirstGenre
| '''FirstGenre'''
| INTEGER
| INTEGER
|
|
Line 320: Line 321:
|
|
|-
|-
| FirstArtist
| '''FirstArtist'''
| INTEGER
| INTEGER
|
|
Line 326: Line 327:
|
|
|-
|-
| Capacity
| '''Capacity'''
| INTEGER
| INTEGER
|
|
Line 332: Line 333:
| Added in version 5.0
| Added in version 5.0
|-
|-
| OtherContentSize
| '''OtherContentSize'''
| INTEGER DEFAULT 0
| INTEGER DEFAULT 0
|
|
Line 338: Line 339:
| Added in version 5.0
| Added in version 5.0
|-
|-
| handlerID
| '''handlerID'''
| TEXT DEFAULT "usb"
| TEXT DEFAULT "usb"
|
|
Line 344: Line 345:
| Added in version 5.0
| Added in version 5.0
|-
|-
| customJSON
| '''customJSON'''
| TEXT
| TEXT*
|
|
|
|
| Added in version 5.0
| Added in version 5.0
|-
|-
| convertArtwork
| '''convertArtwork'''
| INTEGER DEFAULT 0
| INTEGER DEFAULT 0
|
|
Line 356: Line 357:
| Added in version 5.1
| Added in version 5.1
|-
|-
| convertArtworkType
| '''convertArtworkType'''
| STRING DEFAULT "JPG"
| STRING DEFAULT "JPG"
|
|
Line 362: Line 363:
| Added in version 5.1
| Added in version 5.1
|-
|-
| resizeArtwork
| '''resizeArtwork'''
| INTEGER DEFAULT 0
| INTEGER DEFAULT 0
|
|
Line 368: Line 369:
| Added in version 5.1
| Added in version 5.1
|-
|-
| resizeArtworkMaxRes
| '''resizeArtworkMaxRes'''
| INTEGER DEFAULT 500
| INTEGER DEFAULT 500
|
|

Latest revision as of 16:17, 11 April 2024

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

Retrieved from "https://www.mediamonkey.com/wiki/index.php?title=Devices_table&oldid=11383"