filetype varchar not null default 'r',
-- r regular file
-- d directory
- -- s symlink
+ -- l symlink
-- h hard link -- not supported
-- c character special -- not supported
-- b block special -- not supported
check (not (filetype = 'r' and hash is null)),
check (not (filetype = 'c' and (devmajor is null or devminor is null))),
check (not (filetype = 'b' and (devmajor is null or devminor is null))),
- check (filetype in ('r','d','s','h','c','b','p')),
+ check (filetype in ('r','d','l','h','c','b','p')),
check(length(username) between 1 and 256),
check(length(groupname) between 1 and 256),
check (configuration = 0 or configuration = 1)