fix wrong file type letter for symlinks

diff --git a/db.sql b/db.sql
index 2418d12904b98fa323ed5c15aadd7d58afaf943d..be71bde3428047a6368f6e6ed611ab0f7d12b867 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -126,7 +126,7 @@ create table packagefiles (
        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
@@ -149,7 +149,7 @@ create table packagefiles (
        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)