Luis Semedo Duarte wrote:

> Hello,
> And thank you all in advance for reading my message!
>
> I would like to have some kind of build version for my database.
> This would help me keep track of changes made to the database, and it would be easier to write upgrade/downgrade scripts to specific database versions.
>
> Any easy way of doing it?
> I though of going through all system tables and place triggers for insert/update/delete to increment the build number!
>
> My question is this, is there any easy way to do it? (without having to write triggers for all system tables)
> If not, do i have to write triggers for all system tables? Surely, some could be ignored... (i think)
>
> Thank you for your time.
> Luis Semedo Duarte
>

Look for messages with the following subject "Re: [firebird-support] Re:
Logging Patches to Database" on the past week...

Triggers on system tables would not survive a back-up/restore cycle

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br