PDA

View Full Version : SC database model



sand
2008-10-13, 07:40
I am interested in what info there is in the SC database and how it is stored, so that I can write cool SQL queries..
Is there a database model somewhere?

peter
2008-10-13, 08:38
sand wrote:
> I am interested in what info there is in the SC database and how it is
> stored, so that I can write cool SQL queries..
> Is there a database model somewhere?
>

This is a good start:

mysqldump -d -h127.0.0.1 -P9092 slimserver

Regards,
Peter

SuperQ
2008-10-13, 10:23
I am interested in what info there is in the SC database and how it is stored, so that I can write cool SQL queries..
Is there a database model somewhere?

Yes, in the Squeezecenter package there is a schema file: MySQL/system.sql

MrSinatra
2008-10-13, 14:04
be aware, 7.3, which is due sometime this year, is supposed to sport a totally new DB model.