USB hdd support

[Maximilian Kossick]

> On Wednesday 31 May 2006 13:05, Maximilian Kossick wrote:
> > Sorry, of course the unique value is the primary key in the ATF table.
> > The filename is the primary key in both the statistics and tags table.
> > That's why I called it primary key, but it's obviously just a foreign key
> > in the ATF table. I'll change the wording on the wiki page.
>
> Err, not obviously.  Perhaps it *should* be a foreign key in the ATF table,
> but as I know approximately f***all about SQL, I just set it up in a basic
> way.  So there are no foreign keys on the ATF table, just the indexes, and
> the uniqueid field is declared UNIQUE (so is probably the primary key?) 
> :-)

Foreign key constraints are not enforced by SQLite, so I assumed that's why 
you are not using FK constraints anywhere.  But yes, theoretically the 
filename should be a foreign key.

> > Concerning "User-defined labels", I have nothing to add to what Andrew
> > wrote below. What he wrote is exactly what I meant by it.
>
> Okay.  I've been thinking that you'd have a way to view all tracks in the
> database, and then subsets, like, all those from daap, or all those from
> your iPod.  In which case you could theoretically treat it like a label in
> the Gmail style, if you wanted...might be interesting to consider.  But
> yes, user-named sources are good too!

As Andrew described in his e-mail, the device label should be another Group By 
attribute in the Collection Browser. By default, all queries should be 
restricted to the Active Collection (the songs which are on 
mounted/accessible devices). Most of the time the user simply wants to listen 
to music, and it makes no sense to show him music which is not playable at 
that time. But it should be possible to change that behaviour and search in 
the whole collection by toggling a button. Similar behaviour should be 
implemented for dynamic and smart playlists.

--Max
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/amarok/attachments/20060601/017f8c71/attachment.sig>