Update of /cvsroot/fink/scripts/buildfink/lib/FinkFDB
In directory sc8-pr-cvs5.sourceforge.net:/tmp/cvs-serv25174/lib/FinkFDB
Modified Files:
DBI.pm
Log Message:
Tweak DB schema
Index: DBI.pm
===================================================================
RCS file: /cvsroot/fink/scripts/buildfink/lib/FinkFDB/DBI.pm,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- DBI.pm 8 Apr 2007 18:03:30 -0000 1.8
+++ DBI.pm 8 Apr 2007 18:14:58 -0000 1.9
@@ -13,20 +13,20 @@
INSERT INTO file_versions(
package_id,
is_directory,
- fullpath,
file_id,
size,
posix_user,
posix_group,
flags)
-VALUES (?, ?, ?, ?, ?, ?, ?, ?)
+VALUES (?, ?, ?, ?, ?, ?, ?)
EOF
get_package_id => "SELECT package_id FROM packages WHERE
package_name = ?",
get_file_id => "SELECT file_id FROM file_paths WHERE fullpath
= ?",
get_package_files => <<EOF,
SELECT fullpath AS 'path',
size, posix_user, posix_group, flags
-FROM file_versions
+FROM file_versions LEFT OUTER JOIN file_paths
+ ON file_paths.file_id = file_versions.file_id
WHERE package_id=?
ORDER BY is_directory DESC, fullpath ASC
EOF
@@ -245,7 +245,6 @@
$self->execQuery("add_file_version",
$pkgid,
$filever->{isdir},
- $filever->{fullpath},
$file_id,
$filever->{size},
$filever->{user},
-------------------------------------------------------------------------
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
