Ferreteria/modules/files/rf node: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(Created page with "==About== * '''Purpose''': can represent any filesystem entity ==History== * '''2017-07-22''' created for reworking file-management ==SQL== <mysql> CREATE TABLE `fm_node` (...")
(No difference)

Revision as of 16:07, 22 July 2017

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>

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