X-Git-Url: https://pd.if.org/git/?p=zpackage;a=blobdiff_plain;f=db.sql;h=b1343d00a3b6a7f829452af0868f1de2c04798e1;hp=42eeb067cc0a824de9204613bf74a520ba9ca0af;hb=47b298c6557161ff7e46a778de693268cf9230cc;hpb=7027564a4967fde3648c9e81c8bd46c5d1222f9b 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)),