Listing 6: Trigger examples.
-- Log deleted projects CREATE TRIGGER on_delete_proj BEFORE DELETE ON project FOR EACH ROW BEGIN insert into removed values(old.project_id,old.projectname_full); END -- Track version changes. Set conflict to overwrite matching records. CREATE TRIGGER on_update_proj BEFORE UPDATE OF latest_version ON project FOR EACH ROW BEGIN insert OR REPLACE into versions values( new.project_id, old.latest_version, new.latest_version ) END