Fwd: Suggestion for a database schema

[Lydia Pintscher]

Forwarding to devel-list so Max can read it. Should have been send
here anyway...


---------- Forwarded message ----------
From: Thomas Kamps <anubis1 at linux-ecke.de>
Date: Tue, Oct 14, 2008 at 1:36 PM
Subject: Suggestion for a database schema
To: amarok at kde.org


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.

-- 
Lydia Pintscher
Amarok community manager
kde.org - amarok.kde.org - kubuntu.org
claimid.com/nightrose
-------------- 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-devel/attachments/20081014/14785d1b/attachment-0001.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: amarok.sql
Type: text/x-sql
Size: 2837 bytes
Desc: not available
Url : http://mail.kde.org/pipermail/amarok-devel/attachments/20081014/14785d1b/attachment-0001.sql