From 95125e250b9e4a3023a6b769c372990530d1aa87 Mon Sep 17 00:00:00 2001
From: Helmut Grohne <helmut@subdivi.de>
Date: Tue, 22 Jul 2014 21:16:14 +0200
Subject: store filenames as blobs

To facilitate this importpkg.py decodes filenames using iso-8859-1.
While this is not the encoding used for most filenames, decoding will
never fail. Conversely, readyaml.py encodes to iso-8859-1 to undo the
above effect.

webapp.py cannot currently cope with the above change and is broken by
this commit.
---
 schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 99ae7e5..ce36e09 100644
--- a/schema.sql
+++ b/schema.sql
@@ -10,7 +10,7 @@ CREATE TABLE content (		-- a file contained in a binary package
 	id INTEGER PRIMARY KEY,
 	pid INTEGER NOT NULL REFERENCES package(id) ON DELETE CASCADE,
 	-- which package the file is contained in
-	filename TEXT NOT NULL,
+	filename BLOB NOT NULL,
 	size INTEGER NOT NULL);
 
 CREATE TABLE function (			-- hash functions
-- 
cgit v1.2.3

