Ferreteria/modules/files/rf node

About

• Purpose: can represent any filesystem entity

History

• 2017-07-22 created for reworking file-management

SQL

<mysql> CREATE TABLE `fm_node` (

 ID        INT              NOT NULL AUTO_INCREMENT,
 ID_Parent INT              DEFAULT NULL,
 FSpecPart VARCHAR(255)     NOT NULL COMMENT "relative filespec - the part of the path from parent to this file/folder",
 FSpecFull TEXT             NOT NULL COMMENT "full filespec (calculated)",
 WFullPath VARCHAR(255)     NOT NULL COMMENT "full web URL (calculated)",
 Descr     VARCHAR(255) DEFAULT NULL COMMENT "brief name or description",
 PRIMARY KEY(`ID`)

) ENGINE = InnoDB;</mysql>