Update of /cvsroot/fink/scripts/buildfink/schemas
In directory sc8-pr-cvs5.sourceforge.net:/tmp/cvs-serv21143/schemas

Added Files:
        sqlite.sql 
Removed Files:
        sqlite 
Log Message:
Start moving buildfink over to direct FDB database access

--- sqlite DELETED ---

--- NEW FILE: sqlite.sql ---
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

Reply via email to