X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=2e34ad38b6f0fbfc67ba5fc82ba510fe242f3f27;hb=8d39ba5617367d688e653ab40192a9c7f9a5c187;hp=bf6fd22a07c01b886d9d6e26a9dc1557d5132c03;hpb=1543353d5f552717ef55bea0a70f5ef80072ce3d;p=zpackage

diff --git a/db.sql b/db.sql
index bf6fd22..2e34ad3 100644
--- a/db.sql
+++ b/db.sql
@@ -52,6 +52,8 @@ create table packages (
 without rowid
 ;
 
+create index package_status_index on packages (status);
+
 create view packages_pkgid as
 select printf('%s-%s-%s', package, version, release) as pkgid, *
 from packages;
@@ -143,7 +145,8 @@ without rowid
 ;
 
 create view packagefiles_pkgid as
-select printf('%s-%s-%s', package, version, release) as pkgid, *
+select printf('%s-%s-%s', package, version, release) as pkgid, *,
+printf('%s:%o:%s:%s', filetype, mode, username, groupname) as mds
 from packagefiles
 ;
 
@@ -153,6 +156,13 @@ from installedfiles I
 group by I.path
 ;
 
+create view sync_status_ref_count as
+select path, status, count(*) as refcount
+from packagefiles_status
+where status in ('installed', 'installing', 'removing')
+group by path, status
+;
+
 create view packagefiles_status as
 select P.status, PF.*
 from packagefiles_pkgid PF
@@ -197,6 +207,16 @@ left join packagefiles_status PN
 	and PI.pkgid != PN.pkgid
 where PN.path is null
 and PI.package in (select package from packages where status = 'installing')
+
+union all
+-- remove files in removing, but not installing
+select distinct 'remove' as op, PR.*
+from packagefiles_status PR
+left join packagefiles_status PN
+on PR.path = PN.path
+and PR.pkgid != PN.pkgid and PN.status in ('installing', 'installed')
+where PN.path is null
+and PR.status = 'removing'
 ;
 
 create table pathtags (