Ferreteria/modules/files/rf node

From Woozle Writes Code
< Ferreteria‎ | modules‎ | files
Revision as of 22:54, 23 July 2017 by htyp>Woozle
Jump to navigation Jump to search

About

  • Purpose: can represent any filesystem entity

Things to keep in mind: directory size optimization and the fact that the maximum URL length is somewhere around 1024 characters (varies by browser and server; presumably there is an official limit that is ≤ this).

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 TEXT         NOT NULL COMMENT "full web URL (calculated)",
 Descr     VARCHAR(255) DEFAULT NULL COMMENT "brief name or description",
 PRIMARY KEY(`ID`)

) ENGINE = InnoDB;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=Ferreteria/modules/files/rf_node&oldid=1646"