[sqlite] Recording history of changes to schema

[BareFeet]

Hi all,

I want to set up a history of changes in a database schema. I hoped I  
could simply set up triggers for changes to the SQLite_Master table,  
like this:

create table "BF SQLite_Master History" -- record changes to  
SQLite_Master
(
          ID integer primary key
        , Date date                     -- julianday utc of the date & time of 
the change
        , Event text                    -- insert, delete, or update
        , SQL text                      -- SQL prior to change for delete and 
update, after  
change for insert
)
;

create trigger "BF SQLite_Master Insert"
before insert
on SQLite_Master
begin
insert into "BF SQLite_Master History"
(
          Date
        , Event
        , SQL
)
select
          julianday('now', 'utc')
        , 'insert'
        , new.SQL
;
end
;

But I get an error:

SQL error near line 1: cannot create trigger on system table

Is it possible to enable this functionality?

Thanks,
Tom
BareFeet

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users