From: Nathan Wagner <nw@hydaspes.if.org>
Date: Wed, 17 Oct 2018 11:02:51 +0000 (+0000)
Subject: fix wrong file type letter for symlinks
X-Git-Tag: v0.2.16~81
X-Git-Url: https://pd.if.org/git/?p=zpackage;a=commitdiff_plain;h=cb88857461bf9ac2f4fdc693d68a8be99e75bee2

fix wrong file type letter for symlinks
---

diff --git a/db.sql b/db.sql
index 2418d12..be71bde 100644
--- 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)