X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=db.sql;h=b1343d00a3b6a7f829452af0868f1de2c04798e1;hb=884d3cefd3b5d5ba5c6f5af0f0c87168005af3f3;hp=42eeb067cc0a824de9204613bf74a520ba9ca0af;hpb=d230fdf22ba4e063b616f2e7a00c36ffa040d754;p=zpackage diff --git a/db.sql b/db.sql index 42eeb06..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)),