Update of /cvsroot/fink/scripts/buildfink/schemas
In directory sc8-pr-cvs5.sourceforge.net:/tmp/cvs-serv7522/schemas
Added Files:
sqlite
Log Message:
Prototype of package-file database
--- NEW FILE: sqlite ---
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,
UNIQUE (parent_id, file_name)
);
CREATE TABLE packages (
package_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
package_name STRING NOT NULL UNIQUE
);
CREATE TABLE file_versions (
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,
posix_group STRING NULL,
flags VARCHAR NULL,
UNIQUE (package_id, file_id)
);
CREATE INDEX file_ver_idx ON file_versions (file_id);
-------------------------------------------------------------------------
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
