March 01, 2004
The SQLite Database Engine
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
|
 |
|
|||||||||||||||||||||||||||
|
|
|
