Hello! Imho it's better to create audit table for single table. For example, we can attach audit database "audit" and create all tables from main db (without constraints, triggers and checks). Before drop or edit record ID in table T execute "insert into audit.T select * from T where rowid=ID". Thus it's very simple to show the history and revert records becouse structure of audit table is identical to original table. Then we want to make audit we can attach audit database and create temp triggers on main db.
Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
