On Fri, 2005-06-03 at 17:56 +0200, Martijn Voncken wrote: > create table file (fileid integer primary key > ,mediaid integer,path character,mtime integer)
You'll want to use a separate table for directories and use the dirid in this table rather than include the dirname in the path field. Use a TEXT field that holds just the filename, rather than full path name. This saves a lot of space in the database (for very large collections) and also has the benefit of making directory rename operations a matter of updating just one row. The dir row would also have the necessary fields to identify removable media. Cheers, Jason. ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ Freevo-devel mailing list Freevo-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freevo-devel
