Difference between revisions of "VbzCart/tables/fm folder"
Jump to navigation
Jump to search
m (Woozle moved page Ferreteria/modules/RepoFerret/rf folder to VbzCart/tables/fm folder over a redirect without leaving a redirect: actually, this is going to be a legacy thing that will be deleted; rf_folder is starting from scratch) |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': list of places from which files may be slurped into the main repository. | * '''Purpose''': list of places from which files may be slurped into the main repository. | ||
| − | ** This exists mainly for legacy and porting purposes. | + | ** This exists mainly for legacy and porting purposes. Maybe it doesn't need to exist at all; it was mainly useful when hosting disk space was limited. |
| − | + | ==History== | |
| − | + | * '''2010-11-15''' Created in order to deal with the fact that we're going to have more than one base URL for images (so we can upload new images to the wiki -- or whatever image server is handy -- and access them directly from there). | |
| − | + | * '''2010-11-16''' Decided to rename Spec to PathPart for coding clarity. | |
| − | + | * '''2017-07-21''' Rethinking purpose. Removed '''ID_Parent''', changed MYISAM to InnoDB. | |
| + | * '''2017-07-22''' Renamed from cat_folders to fm_folder (fm = file management); probably more changes to come. | ||
==SQL== | ==SQL== | ||
| − | <mysql> CREATE TABLE ` | + | <mysql> CREATE TABLE `fm_folder` ( |
ID INT NOT NULL AUTO_INCREMENT, | ID INT NOT NULL AUTO_INCREMENT, | ||
PathPart VARCHAR(255) NOT NULL COMMENT "relative filespec - the part of the path from parent to this file/folder", | PathPart VARCHAR(255) NOT NULL COMMENT "relative filespec - the part of the path from parent to this file/folder", | ||
Latest revision as of 21:10, 24 July 2017
About
- Purpose: list of places from which files may be slurped into the main repository.
- This exists mainly for legacy and porting purposes. Maybe it doesn't need to exist at all; it was mainly useful when hosting disk space was limited.
History
- 2010-11-15 Created in order to deal with the fact that we're going to have more than one base URL for images (so we can upload new images to the wiki -- or whatever image server is handy -- and access them directly from there).
- 2010-11-16 Decided to rename Spec to PathPart for coding clarity.
- 2017-07-21 Rethinking purpose. Removed ID_Parent, changed MYISAM to InnoDB.
- 2017-07-22 Renamed from cat_folders to fm_folder (fm = file management); probably more changes to come.
SQL
<mysql> CREATE TABLE `fm_folder` (
ID INT NOT NULL AUTO_INCREMENT, PathPart VARCHAR(255) NOT NULL COMMENT "relative filespec - the part of the path from parent to this file/folder", Descr VARCHAR(255) DEFAULT NULL COMMENT "brief name or description, for choice lists", PRIMARY KEY(`ID`)
) ENGINE = InnoDB;</mysql>
Archive
Information about previous version:
- Purpose: Stores complete information about where files are found and how they can be accessed; sort of a mini-FileFerret.
- Future: This table only manages paths for one particular access method, i.e. the web (and only for read-only access). In the future we might have another table which gives methods for modifying (moving, renaming, adding, deleting) files. Ideally different methods would be consolidated into one more general-purpose table, but this is a task-specific table, so we're not going to do that. Maybe that functionality will be handled by FileFerret, and this app will simply provide links to integrate with that.
<mysql> ID_Parent INT DEFAULT NULL COMMENT "base for this spec",</mysql>