mercredi 23 septembre 2015

sqlite3 trigger update on any insert/update/delete

Can I fire a trigger in sqlite whenever anything changed on a database (except for the trigger changes itself of course)? I want to save file modification date and modification revision in sqlite database, whenever anything is inserted, updated or deleted. Can I do that without applying triggers for every table?

Aucun commentaire:

Enregistrer un commentaire