X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=00c5df0f6f1e316c964dd380fe84570f95cbc169;hb=d92a98237b9bccf4e7017dce7a294ece618cf1fc;hp=c7040349b38dc2004ed9970eb3e9ca9a414da33a;hpb=30aa9bfe1e9a0e682f7c942b8e68054551f14857;p=zpackage

diff --git a/db.sql b/db.sql
index c704034..00c5df0 100644
--- a/db.sql
+++ b/db.sql
@@ -194,6 +194,23 @@ begin
 end
 ;
 
+create trigger packagefiles_delete_trigger instead of
+delete on packagefiles_pkgid
+begin
+	delete from packagefiles
+	where package = OLD.package
+	and version = OLD.version
+	and release = OLD.release
+	and path = OLD.path
+	;
+	update packages set hash = null
+	where package = OLD.package
+	and version = OLD.version
+	and release = OLD.release
+	;
+end
+;
+
 create view installed_ref_count as
 select I.path, count(*) as refcount
 from installedfiles I