Update of /cvsroot/fink/scripts/buildfink/schemas
In directory sc8-pr-cvs5.sourceforge.net:/tmp/cvs-serv25174/schemas
Modified Files:
sqlite.sql
Log Message:
Tweak DB schema
Index: sqlite.sql
===================================================================
RCS file: /cvsroot/fink/scripts/buildfink/schemas/sqlite.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- sqlite.sql 31 Mar 2007 20:49:14 -0000 1.1
+++ sqlite.sql 8 Apr 2007 18:14:58 -0000 1.2
@@ -1,8 +1,8 @@
CREATE TABLE file_paths (
file_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
parent_id INTEGER NOT NULL,
- file_name VARCHAR NOT NULL,
- fullpath STRING NOT NULL,
+ file_name VARCHAR NOT NULL COLLATE NOCASE,
+ fullpath STRING NOT NULL UNIQUE COLLATE NOCASE,
UNIQUE (parent_id, file_name)
);
@@ -15,7 +15,6 @@
file_version_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
is_directory BOOLEAN NOT NULL,
package_id INTEGER NOT NULL,
- fullpath STRING NOT NULL,
file_id INTEGER NOT NULL,
size INTEGER NOT NULL,
posix_user STRING NULL,
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Fink-commits mailing list
Fink-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-commits
