Ferret File System/v0.1/SQL/map/archive: Difference between revisions
< Ferret File System | v0.1 | SQL | map
Jump to navigation
Jump to search
m (Woozle moved page FileFerret/SQL/maps/archive to FileFerret/SQL/map/archive: singularizing) |
m (Woozle moved page FileFerret/SQL/map/archive to Ferret File System/v0.1/SQL/map/archive: obsolete) |
(One intermediate revision by the same user not shown) | |
(No difference)
|
Latest revision as of 13:40, 25 February 2024
This design made more sense for a Windows-only network, where drive root folders were rarely accessible.
- 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
<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>