geopackage_triggers.sql

-- Classic triggers for geopackages DB files
-- 1. Creation date
CREATE TRIGGER "trigger_add_creation_date" AFTER INSERT 
ON "table_name"
BEGIN 
	UPDATE table_name SET attribute = datetime('now') WHERE fid = NEW.fid;
END

-- 2. Update date
CREATE TRIGGER "trigger_update_date" AFTER UPDATE 
ON "table_name"
BEGIN 
	UPDATE "line_area_exceptions" SET attribute = datetime('now') WHERE fid = OLD.fid;
END