All scanned data is stored in a single table
(customscan_track_attributes), in this table there might be multiple
rows for the same track/tag combination.
So I believe it stores the information as you like with the difference
that it doesn't separate each tag in a separate table.
The table definition looks like this:
Code:
--------------------
CREATE TABLE `customscan_track_attributes` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`track` int(10) default NULL,
`url` varchar(511) NOT NULL,
`musicbrainz_id` varchar(40) default NULL,
`module` varchar(40) NOT NULL,
`attr` varchar(40) NOT NULL,
`value` varchar(255) default NULL,
`valuesort` varchar(255) default NULL,
`extravalue` varchar(255) default NULL,
`valuetype` varchar(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `track_attr_idx` (`track`,`module`,`attr`,`id`),
KEY `musicbrainzIndex` (`musicbrainz_id`),
KEY `urlIndex` (`url`(255)),
KEY `module_attr_value_idx` (`module`,`attr`,`value`),
KEY `attr_module_idx` (`attr`,`module`),
KEY `extravalue_attr_module_track_idx` (`extravalue`,`attr`,`module`,`track`),
KEY `track_module_attr_extravalue_idx` (`track`,`module`,`attr`,`extravalue`),
KEY `module_attr_extravalue_idx` (`module`,`attr`,`extravalue`),
KEY `module_attr_valuesort_idx` (`module`,`attr`,`valuesort`)
) ENGINE=InnoDB
--------------------
Where each column contains information like:
`id` - A unique number (generated)
`track` - Reference to a track, refers to tracks.id
`url` - Reference to a track, refers to tracks.url. Used to reconnect
track column after a rescan.
`musicbrainz_id` - Reference to a track, refers to
tracks.musicbrainz_id. Used to reconnect track column after a rescan.
`module` - Scanning module used, for example "customtag"
`attr` - Tag name, for example "MOOD" or "STYLE"
`value` - Tag value, for example "Romantic"
`valuesort` - Sort tag value
`extravalue` - Type of object, NULL for customtag scanning module
`valuetype` - Type of object, NULL for customtag scanning module
--
erland
Erland Isaksson
'My homepage' (http://erland.isaksson.info) (Install my plugins through
Extension Downloader)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=69611
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
