X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=b1343d00a3b6a7f829452af0868f1de2c04798e1;hb=06ea9ccb6a8d36c63d5f1dac4fd2430819b75a95;hp=a4a065161f3c972dde677be7fd5d4f73c4e2af2f;hpb=63339873b48653db56a74dc6b08e73608d793bdf;p=zpackage

diff --git a/db.sql b/db.sql
index a4a0651..b1343d0 100644
--- a/db.sql
+++ b/db.sql
@@ -157,6 +157,7 @@ create table packagefiles (
 	check (not (filetype = 'h' and target is null)),
 	check (target is null or length(target) between 1 and 4095),
 	check (hash is null or length(hash) between 1 and 1024),
+	check (path not in ('.', '..')),
 	check (not (filetype = 'r' and hash is null)),
 	check (not (filetype = 'c' and device is null)),
 	check (not (filetype = 'b' and device is null)),
@@ -171,6 +172,7 @@ without rowid
 create index packagefile_package_index on packagefiles (package);
 create index packagefile_path_index on packagefiles (path);
 create index packagefile_hash_index on packagefiles (hash);
+create index pkgfile_configuration on packagefiles (configuration) where configuration = 1;
 
 create view packagefiles_pkgid as
 select printf('%s-%s-%s', package, version, release) as pkgid, *,