[dbrobins]

Of course its worthwhile, the redesign won't happen overnight. It would be nice to have it completed in time for Eden, but there is a lot of work to do in the meantime.

OK, I'll put it on the list and see what I can do. Thanks for offering to review it for inclusion.

No repo, just yet. It's all in one complex python script. I'll be updating the wiki page with the latest schema revision in the next few days.

If you're interested, I've been using SQLAlchemy (Python db toolkit) to model the XBMC video database for my own work. SA can build DDL from the model. Since you're using Python too, you may be able to make use of parts of my model. SA also offers cascade functionality even if the db isn't set up that way; right now if I delete a row from files it will also queue the relevant settings, streamdetails, movie and *linkmovie rows for deletion (it can also be told that the database will handle it, when foreign keys are in use, and not try to do the deletes itself).