store filenames as blobsbinaryfilename

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.

1 files changed, 1 insertions, 1 deletions

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