VbzCart/tables/fm folder - Revision history

Woozle: 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

2017-07-24T21:10:00Z

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

← Older revision	Revision as of 21:10, 24 July 2017
(No difference)

Woozle: Woozle moved page VbzCart/tables/fm folder to Ferreteria/modules/RepoFerret/rf folder: this part looks completely general, so belongs in Ferreteria

2017-07-24T21:03:21Z

Woozle moved page VbzCart/tables/fm folder to Ferreteria/modules/RepoFerret/rf folder: this part looks completely general, so belongs in Ferreteria

← Older revision	Revision as of 21:03, 24 July 2017
(No difference)

Woozle at 14:46, 22 July 2017

2017-07-22T14:46:46Z

← Older revision		Revision as of 14:46, 22 July 2017
Line 6:		Line 6:
	* '''2010-11-16''' Decided to rename Spec to PathPart for coding clarity.		* '''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-21''' Rethinking purpose. Removed '''ID_Parent''', changed MYISAM to InnoDB.
	* '''2017-07-22''' Renamed from cat_folders to ~~fm_folders~~ (fm = file management); probably more changes to come.		* '''2017-07-22''' Renamed from cat_folders to fm_folder (fm = file management); probably more changes to come.
	==SQL==		==SQL==
	<mysql> CREATE TABLE `~~fm_folders~~` (		<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",

Woozle: Woozle moved page VbzCart/tables/fm folders to VbzCart/tables/fm folder: meant to also singularize but forgot

2017-07-22T14:45:06Z

Woozle moved page VbzCart/tables/fm folders to VbzCart/tables/fm folder: meant to also singularize but forgot

← Older revision	Revision as of 14:45, 22 July 2017
(No difference)

Woozle at 14:42, 22 July 2017

2017-07-22T14:42:59Z

← Older revision		Revision as of 14:42, 22 July 2017
Line 2:		Line 2:
	* '''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. Maybe it doesn't need to exist at all; it was mainly useful when hosting disk space was limited.		** 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~~''':~~		==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-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.		* '''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-21''' Rethinking purpose. Removed '''ID_Parent''', changed MYISAM to InnoDB.
			* '''2017-07-22''' Renamed from cat_folders to fm_folders (fm = file management); probably more changes to come.
	==SQL==		==SQL==
	<mysql> CREATE TABLE `~~cat_folders~~` (		<mysql> CREATE TABLE `fm_folders` (
	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",

Woozle: Woozle moved page VbzCart/tables/cat folders to VbzCart/tables/fm folders

2017-07-22T14:41:25Z

Woozle moved page VbzCart/tables/cat folders to VbzCart/tables/fm folders

← Older revision	Revision as of 14:41, 22 July 2017
(No difference)

Woozle at 00:21, 22 July 2017

2017-07-22T00:21:52Z

← Older revision		Revision as of 00:21, 22 July 2017
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''':		* '''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-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).

Woozle at 00:14, 22 July 2017

2017-07-22T00:14:53Z

← Older revision		Revision as of 00:14, 22 July 2017
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': ~~Stores complete information about where~~ files ~~are found~~ and ~~how they can be accessed; sort of a mini-[[FileFerret]]~~.		* '''Purpose''': list of places from which files may be slurped into the main repository.
			** This exists mainly for legacy and porting purposes.
	* '''History''':		* '''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-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.		** '''2010-11-16''' Decided to rename Spec to PathPart for coding clarity.
	* '''~~Future~~''':		** '''2017-07-21''' Rethinking purpose. Removed '''ID_Parent''', changed MYISAM to InnoDB.
	** 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~~.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql> CREATE TABLE `cat_folders` (		<mysql> CREATE TABLE `cat_folders` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	~~ID_Parent INT DEFAULT NULL COMMENT "base for this spec",~~
	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",
	Descr VARCHAR(255) DEFAULT NULL COMMENT "brief name or description, for choice lists",		Descr VARCHAR(255) DEFAULT NULL COMMENT "brief name or description, for choice lists",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = ~~MYISAM~~;</mysql>		) ENGINE = InnoDB;</mysql>
	<~~section end=sql~~ />		==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>

Woozle: Spec -> PathPart

2010-11-16T12:44:38Z

Spec -> PathPart

← Older revision		Revision as of 12:44, 16 November 2010
Line 3:		Line 3:
	* '''History''':		* '''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-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.
	* '''Future''':		* '''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.		** 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.
Line 9:		Line 10:
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	ID_Parent INT DEFAULT NULL COMMENT "base for this spec",		ID_Parent INT DEFAULT NULL COMMENT "base for this spec",
	~~Spec~~ VARCHAR(255) NOT NULL COMMENT "relative filespec, 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",
	Descr VARCHAR(255) DEFAULT NULL COMMENT "brief name or description, for choice lists",		Descr VARCHAR(255) DEFAULT NULL COMMENT "brief name or description, for choice lists",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: Created page with '==About== * '''Purpose''': Stores complete information about where files are found and how they can be accessed; sort of a mini-FileFerret. * '''History''': ** '''2010-11-15'…'

2010-11-16T02:27:48Z

Created page with '==About== * '''Purpose''': Stores complete information about where files are found and how they can be accessed; sort of a mini-FileFerret. * '''History''': ** '''2010-11-15'…'

New page

==About==
* '''Purpose''': Stores complete information about where files are found and how they can be accessed; sort of a mini-[[FileFerret]].
* '''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).
* '''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.
==SQL==
<section begin=sql /><mysql> CREATE TABLE `cat_folders` (
ID INT NOT NULL AUTO_INCREMENT,
ID_Parent INT DEFAULT NULL COMMENT "base for this spec",
Spec VARCHAR(255) NOT NULL COMMENT "relative filespec, from parent to this file/folder",
Descr VARCHAR(255) DEFAULT NULL COMMENT "brief name or description, for choice lists",
PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>
<section end=sql />