Ferret File System/v0.1/SQL/map

About

• Purpose: tracks methods of accessing folders on remote hosts, across different FileFerret clients. This is necessary because the root folder of some volumes may not be visible; we only have visibility within one or more specific folders. It is similar to the concept of "mount points"
  • Each FileFerret client looks itself up in the hosts table to get its host ID, then filters this table by looking only at records with a matching ID_Host.
• Fields:
  • ID_Host: host ID of the computer to whom each map applies
  • FileSpec: absolute path to the root of the map (aka mount point) being described

SQL

<mysql>CREATE TABLE `maps` (

 `ID`          INT NOT NULL AUTO_INCREMENT,
 `ID_Folder`   INT NOT NULL COMMENT "folders.ID",
 `ID_Host`     INT NOT NULL COMMENT "hosts.ID",
 `Name`        VARCHAR(63) NOT NULL COMMENT "short name for lists",
 `Descr`       VARCHAR(255) DEFAULT NULL COMMENT "longer description",
 `FileSpec`    VARCHAR(255) NOT NULL COMMENT "must not have terminating slash; will be used as prefix for folder chains",
 `isPrimary`   BOOL DEFAULT FALSE COMMENT "is Host primarily responsible for maintaining (scanning) this Folder?",
 `isDrive`     BOOL DEFAULT FALSE COMMENT "TRUE = can be queried for volume and capacity information; may be removable.",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>