add rmpackage

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index d5b1d103113f304d55b16e73908dba1118349700..2418d12904b98fa323ed5c15aadd7d58afaf943d 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -61,6 +61,13 @@ create view packages_pkgid as
 select printf('%s-%s-%s', package, version, release) as pkgid, *
 from packages;
 
+create trigger packages_delete_trigger instead of
+delete on packages_pkgid
+begin
+       delete from packages where package = OLD.package
+       and version = OLD.version and release = OLD.release;
+end;
+
 create trigger packages_update_trigger instead of
 update on packages_pkgid
 begin