-create table packagestatus (
- pkgid text primary key,
- status text, -- installed installing removed upgraded
- -- asof timestamp
- asof integer default (strftime('%s', 'now'))
-);
+-- handle package status history with a logging trigger.
+create trigger logpkgstatus after update of status on packages
+begin insert into zpmlog (action,target,info)
+ values (printf('status change %s %s', OLD.status, NEW.status),
+ printf('%s-%s-%s', NEW.package, NEW.version, NEW.release),
+ NULL); END;