Personal Video Database

English => Feature Suggestions => Topic started by: sloe on May 08, 2010, 10:24:04 pm

Title: Database change scripts
Post by: sloe on May 08, 2010, 10:24:04 pm

Hi,

I created a view on the movies table. Since then the update procedure has problems updating the database structure. I guess because some system tables are locked.

Would it be possible to also deliver sql scripts with the changes? This would be pretty handy for me.

Greetings
sloe

Title: Re: Database change scripts
Post by: nostra on May 10, 2010, 01:39:14 pm

Most apps that work with Firebird database have also the possibility to show the database structure and sql needed to produce tables, procedures etc.

Quote

Would it be possible to also deliver sql scripts with the changes? This would be pretty handy for me.

I do not want to do this as:
1. It is too advanced information for most of the users
2. I would need to keep this info up to date (more work)
3. People could try this stuff out and break the database