Suggestion for a database schema

[Thomas Kamps]

I have worked a little bit for a new database schema for amarok2 or 
later.
It is not complete but should be enough for the basics.

For playing statics i added a listend table. Here each song gets 
insertet with the date-time when it was played.
With this table you can see how often a song was played, when it was 
the last time played, or the first time.

For static playlists a have the staticPlaylist table. Here you can insert 
the relations between 'Playlost Name, Number' and song. This table is 
able to save all static playlists. You can also find out which song is in 
wich playlist.

You are free to extend and use this schema for whatever you want.

I hope my schema can help you a little bit.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: amarok.sqlite
Type: application/x-sqlite3
Size: 18432 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/amarok/attachments/20081014/e2bb6cfb/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: amarok.sql
Type: text/x-sql
Size: 2838 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/amarok/attachments/20081014/e2bb6cfb/attachment.sql>