[gollem] horde_vfs table schema

[Jon Parise]

On Fri, Jul 19, 2002 at 11:35:54AM -0400, Chuck Hagenbuch wrote:

> > CREATE TABLE horde_vfs (
> >     vfs_id         BIGINT NOT NULL,
> >     vfs_folder     BOOL NOT NULL,
> 
> I would make this vfs_type instead, and define constants inside of 
> VFS/sql.php for VFS_TYPE_FILE, VFS_TYPE_FOLDER, and leave open the 
> possibility of adding more in the future (symlinks, etc.).

Or perhaps a vfs_attrs column that contains a bitmask of attributes,
one of which may be used to indicate a directory type.

-- 
Jon Parise (jon@horde.org) :: The Horde Project (http://horde.org/)