Medias table - Revision history

Drakinite: Fixed asterisks in the wrong place

2024-04-11T16:13:08Z

Fixed asterisks in the wrong place

← Older revision		Revision as of 16:13, 11 April 2024
Line 63:		Line 63:
	\|		\|
	\|-		\|-
	\| '''CDDBQueryResult'''*		\| '''CDDBQueryResult'''
	\| TEXT		\| TEXT*
	\|		\|
	\|		\|
Line 78:		Line 78:
	\| Ascii code of drive letter "A"=65		\| Ascii code of drive letter "A"=65
	\|-		\|-
	\| '''MusicBrainzDiscId'''*		\| '''MusicBrainzDiscId'''
	\| TEXT		\| TEXT*
	\|		\|
	\|		\|

Drakinite: {{DatabaseTablesList}} and capitalization

2024-04-11T16:01:20Z

{{DatabaseTablesList}} and capitalization

← Older revision		Revision as of 16:01, 11 April 2024
Line 1:		Line 1:
			{{DatabaseTablesList}}
	== Fields ==		== Fields ==
	{\| border="1"		{\| border="1"
Line 7:		Line 8:
	! Description		! Description
	\|-		\|-
	\| '''~~IDMEDIA~~'''		\| '''IDMedia'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Internal MM ID number		\| Internal MM ID number
	\|-		\|-
	\| '''~~SERIALNUMBER~~'''		\| '''SerialNumber'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~DRIVETYPE~~'''		\| '''DriveType'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~LABEL~~'''		\| '''Label'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~SHOWLABEL~~'''		\| '''ShowLabel'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~COMMENT~~'''		\| '''Comment'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~ISAUDIOCD~~'''		\| '''IsAudioCD'''
	\| INTEGER		\| INTEGER
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~LOCATION~~'''		\| '''Location'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~CDDBID~~'''		\| '''CDDBId'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~TOCDATA~~'''		\| '''TOCData'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~CDDBQUERYSTATE~~'''		\| '''CDDBQueryState'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~CDDBQUERYRESULT~~'''		\| '''CDDBQueryResult'''*
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~TURNEDSN~~'''		\| '''TurnedSN'''
	\| TEXT		\| TEXT
	\|		\|
	\|		\|
	\|-		\|-
	\| '''~~DRIVELETTER~~'''		\| '''DriveLetter'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Ascii code of drive letter "A"=65		\| Ascii code of drive letter "A"=65
	\|-		\|-
	\| '''~~MUSICBRAINZDISCID~~'''		\| '''MusicBrainzDiscId'''*
	\| TEXT		\| TEXT
	\|		\|

Drakinite: Added fields from 5.0

2024-04-10T17:35:15Z

Added fields from 5.0

← Older revision		Revision as of 17:35, 10 April 2024
Line 76:		Line 76:
	\|		\|
	\| Ascii code of drive letter "A"=65		\| Ascii code of drive letter "A"=65
			\|-
			\| '''MUSICBRAINZDISCID'''
			\| TEXT
			\|
			\|
	\|-		\|-
	\|}		\|}

	(need more info in each)		(need more info in each)

Markstuartwalker: /* Fields */

2009-10-29T14:55:01Z

Fields

← Older revision		Revision as of 14:55, 29 October 2009
Line 75:		Line 75:
	\| INTEGER		\| INTEGER
	\|		\|
	\|		\| Ascii code of drive letter "A"=65
	\|-		\|-
	\|}		\|}

	(~~4 fields total, but~~ need more info in each)		(need more info in each)

Markstuartwalker: /* Fields */

2009-10-29T14:54:01Z

Fields

← Older revision		Revision as of 14:54, 29 October 2009
Line 7:		Line 7:
	! Description		! Description
	\|-		\|-
	\| '''~~IDMedia~~'''		\| '''IDMEDIA'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Internal MM ID number		\| Internal MM ID number
	\|-		\|-
	\| '''~~Label~~'''		\| '''SERIALNUMBER'''
	\| TEXT		\| TEXT
	\|		\|
	\| ~~Label of the media~~		\|
			\|-
			\| '''DRIVETYPE'''
			\| TEXT
			\|
			\|
			\|-
			\| '''LABEL'''
			\| TEXT
			\|
			\|
			\|-
			\| '''SHOWLABEL'''
			\| TEXT
			\|
			\|
			\|-
			\| '''COMMENT'''
			\| TEXT
			\|
			\|
	\|-		\|-
	\| '''~~Label~~'''		\| '''ISAUDIOCD'''
			\| INTEGER
			\|
			\|
			\|-
			\| '''LOCATION'''
	\| TEXT		\| TEXT
	\|		\|
	\| ~~Label of the media~~		\|
	\|-		\|-
	\| '''~~Label~~'''		\| '''CDDBID'''
	\| TEXT		\| TEXT
	\|		\|
	\| ~~Label of the media~~		\|
	\|-		\|-
	\| '''~~Label~~'''		\| '''TOCDATA'''
	\| TEXT		\| TEXT
	\|		\|
	\| ~~Label of the media~~		\|
	\|-		\|-
	\| '''~~Label~~'''		\| '''CDDBQUERYSTATE'''
	\| TEXT		\| TEXT
	\|		\|
	\| ~~Label of the media~~		\|
	\|-		\|-
	\| '''~~Label~~'''		\| '''CDDBQUERYRESULT'''
	\| TEXT		\| TEXT
	\|		\|
	\| ~~Label of the media~~		\|
			\|-
			\| '''TURNEDSN'''
			\| TEXT
			\|
			\|
			\|-
			\| '''DRIVELETTER'''
			\| INTEGER
			\|
			\|
	\|-		\|-
	\|}		\|}

	(4 fields total, but need more info in each)		(4 fields total, but need more info in each)

Markstuartwalker: /* Fields */

2009-10-29T14:39:17Z

Fields

@@ Line 11: / Line 11: @@
+|
 | Internal MM ID number
 |-
 | '''Label'''

Markstuartwalker: /* Fields */

2009-10-29T07:57:49Z

Fields

← Older revision		Revision as of 07:57, 29 October 2009
Line 7:		Line 7:
	! Description		! Description
	\|-		\|-
	\| '''~~IDSong~~'''		\| '''IDMedia'''
	\| INTEGER		\| INTEGER
	\|		\|
	\| Internal MM ID number		\| Internal MM ID number
	\|-		\|-
	\| '''~~IDPlaylist~~'''		\| '''Label'''
	\| ~~INTEGER~~		\| TEXT
	\|
	~~\| Assigned Playlist Number~~
	\|-
	~~\| '''IDPlaylistSong'''~~
	~~\| INTEGER~~
	\|
	\|		\|
			\| Label of the media
	\|-		\|-
	~~\| '''SongOrder'''~~
	~~\| INTEGER~~
	\|
	\|
	\|}		\|}

	(4 fields total, but need more info in each)		(4 fields total, but need more info in each)

Markstuartwalker at 07:56, 29 October 2009

2009-10-29T07:56:22Z

New page

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''IDSong'''
| INTEGER
|
| Internal MM ID number
|-
| '''IDPlaylist'''
| INTEGER
|
| Assigned Playlist Number
|-
| '''IDPlaylistSong'''
| INTEGER
|
|
|-
| '''SongOrder'''
| INTEGER
|
|
|}

(4 fields total, but need more info in each)