VbzCart/tables/cat images - Revision history

Woozle: /* History */ removed "WebSpec OLD"

2016-01-25T20:55:19Z

History: removed "WebSpec OLD"

← Older revision		Revision as of 20:55, 25 January 2016
Line 8:		Line 8:
	* '''2010-11-16''' Added '''WhenAdded''' and '''WhenEdited''' fields because... well, it's easy to do, and provides a secondary check against the event log.		* '''2010-11-16''' Added '''WhenAdded''' and '''WhenEdited''' fields because... well, it's easy to do, and provides a secondary check against the event log.
	* '''2016-01-25''' Added '''CatKey''' field as part of getting rid of {{l/same\|cat_pages}}.		* '''2016-01-25''' Added '''CatKey''' field as part of getting rid of {{l/same\|cat_pages}}.
			** Also finally removed '''WebSpec OLD''' from the actual data (was probably just a rename of WebSpec in 2010 in case removing it turned out to be a bad idea).

	==Fields==		==Fields==
	* '''CatKey''' is much like CatKey in every other type of record, i.e. it defines part of the URL -- in this case, the part after the Title. The value should be the same as updating all records with the following SQL: <mysql>CatKey=CONCAT_WS("-",Ab_Size,AttrFldr)</mysql>		* '''CatKey''' is much like CatKey in every other type of record, i.e. it defines part of the URL -- in this case, the part after the Title. The value should be the same as updating all records with the following SQL: <mysql>CatKey=CONCAT_WS("-",Ab_Size,AttrFldr)</mysql>

Woozle: values of CatKey

2016-01-25T20:52:08Z

values of CatKey

← Older revision		Revision as of 20:52, 25 January 2016
Line 9:		Line 9:
	* '''2016-01-25''' Added '''CatKey''' field as part of getting rid of {{l/same\|cat_pages}}.		* '''2016-01-25''' Added '''CatKey''' field as part of getting rid of {{l/same\|cat_pages}}.
	==Fields==		==Fields==
	* '''CatKey''' is much like CatKey in every other type of record, i.e. it defines part of the URL -- in this case, the part after the Title.		* '''CatKey''' is much like CatKey in every other type of record, i.e. it defines part of the URL -- in this case, the part after the Title. The value should be the same as updating all records with the following SQL: <mysql>CatKey=CONCAT_WS("-",Ab_Size,AttrFldr)</mysql>
	* '''Spec''' (filesystem spec) can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like FilePath, LocalSpec, StorSpec, SrcSpec...		* '''Spec''' (filesystem spec) can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like FilePath, LocalSpec, StorSpec, SrcSpec...
	* [[FileFerret]] columns:		* [[FileFerret]] columns:

Woozle: CatKey

2016-01-25T20:33:32Z

CatKey

← Older revision		Revision as of 20:33, 25 January 2016
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Stores data for images relevant to displaying catalog entities (currently only Titles)		* '''Purpose''': Stores data for images relevant to displaying catalog entities (currently only Titles)
	* '''History~~''':~~		==History==
	** '''2010-11-15'''		* '''2010-11-15'''
	*** Added ID_Folder to allow use of different base URLs via {{vbzcart\|table\|cat_folders}}.		** Added ID_Folder to allow use of different base URLs via {{vbzcart\|table\|cat_folders}}.
	*** Removed WebSpec because nothing was using it and some of the data was missing and all of it used DOS-style paths.		** Removed WebSpec because nothing was using it and some of the data was missing and all of it used DOS-style paths.
	** '''2010-11-16''' Added '''WhenAdded''' and '''WhenEdited''' fields because... well, it's easy to do, and provides a secondary check against the event log.		*** Description of WebSpec field was: should be considered the official location for the purposes of page display; only image admin functions should update it.
	* '''Fields''':		* '''2010-11-16''' Added '''WhenAdded''' and '''WhenEdited''' fields because... well, it's easy to do, and provides a secondary check against the event log.
	** '''Spec''' can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like LocalSpec, StorSpec, SrcSpec...		* '''2016-01-25''' Added '''CatKey''' field as part of getting rid of {{l/same\|cat_pages}}.
	** '''WebSpec''' should be considered the official location for the purposes of page display; only image admin functions should update it.		==Fields==
	** [[FileFerret]] columns:		* '''CatKey''' is much like CatKey in every other type of record, i.e. it defines part of the URL -- in this case, the part after the Title.
	*** '''IDFF_File''' should always be set; this way, the file can be located if it gets moved. NOT NULL isn't required, though, because it may be necessary to find the file first and later request a FileFerret ID for it.		* '''Spec''' (filesystem spec) can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like FilePath, LocalSpec, StorSpec, SrcSpec...
	*** '''IDFF_Fideal''' is set opportunistically, for now. Later on we may want to have a policy that all VbzCart images should have a Fideal, but this will be determined as FileFerret is worked out.		* [[FileFerret]] columns:
	* '''~~Future~~''': I had boldly planned to use [[FileFerret]] to manage image files, and towards that end had boldly removed any actual filespec information from this table, but then later realized that this was placing too much tight dependency on another entire subsystem. Maybe FileFerret should be responsible for keeping track of apps that use it, and for notifying them if any of their files are moved.		** '''IDFF_File''' should always be set; this way, the file can be located if it gets moved. NOT NULL isn't required, though, because it may be necessary to find the file first and later request a FileFerret ID for it.
			** '''IDFF_Fideal''' is set opportunistically, for now. Later on we may want to have a policy that all VbzCart images should have a Fideal, but this will be determined as FileFerret is worked out.
			==Future==
			'''Spec''' should probably be renamed to something more specific like FilePath.

			I had boldly planned to use [[FileFerret]] to manage image files, and towards that end had boldly removed any actual filespec information from this table, but then later realized that this was placing too much tight dependency on another entire subsystem. Maybe FileFerret should be responsible for keeping track of apps that use it, and for notifying them if any of their files are moved.
	==SQL==		==SQL==
	<mysql> CREATE TABLE `cat_images` (		<mysql> CREATE TABLE `cat_images` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	isActive BOOL NOT NULL DEFAULT FALSE,		isActive BOOL NOT NULL DEFAULT FALSE,
			CatKey VARCHAR(63) DEFAULT NULL COMMENT "change to NOT NULL after populating",
	ID_Folder INT NOT NULL COMMENT "base folder to which the Spec is relative",		ID_Folder INT NOT NULL COMMENT "base folder to which the Spec is relative",
	Spec VARCHAR(255) NOT NULL COMMENT "relative filespec for accessing image file",		Spec VARCHAR(255) NOT NULL COMMENT "relative filespec for accessing image file",

Woozle: updates

2015-04-18T16:12:52Z

updates

← Older revision		Revision as of 16:12, 18 April 2015
Line 12:		Line 12:
	*** '''IDFF_File''' should always be set; this way, the file can be located if it gets moved. NOT NULL isn't required, though, because it may be necessary to find the file first and later request a FileFerret ID for it.		*** '''IDFF_File''' should always be set; this way, the file can be located if it gets moved. NOT NULL isn't required, though, because it may be necessary to find the file first and later request a FileFerret ID for it.
	*** '''IDFF_Fideal''' is set opportunistically, for now. Later on we may want to have a policy that all VbzCart images should have a Fideal, but this will be determined as FileFerret is worked out.		*** '''IDFF_Fideal''' is set opportunistically, for now. Later on we may want to have a policy that all VbzCart images should have a Fideal, but this will be determined as FileFerret is worked out.
	* '''Future''': I had boldly planned to use [[FileFerret]] to manage image files, and towards that end had boldly removed any actual filespec information from this table, but then later realized that this was placing too much tight dependency on another entire subsystem. ~~Eventually the filespec fields need to be restored and~~ FileFerret should be ~~relegated to~~ keeping them ~~updated~~ if ~~things~~ are moved.		* '''Future''': I had boldly planned to use [[FileFerret]] to manage image files, and towards that end had boldly removed any actual filespec information from this table, but then later realized that this was placing too much tight dependency on another entire subsystem. Maybe FileFerret should be responsible for keeping track of apps that use it, and for notifying them if any of their files are moved.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql> CREATE TABLE `cat_images` (		<mysql> CREATE TABLE `cat_images` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	isActive BOOL NOT NULL DEFAULT FALSE,		isActive BOOL NOT NULL DEFAULT FALSE,
Line 31:		Line 31:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: timestamp fields

2010-11-16T23:03:15Z

timestamp fields

← Older revision		Revision as of 23:03, 16 November 2010
Line 5:		Line 5:
	*** Added ID_Folder to allow use of different base URLs via {{vbzcart\|table\|cat_folders}}.		*** Added ID_Folder to allow use of different base URLs via {{vbzcart\|table\|cat_folders}}.
	*** Removed WebSpec because nothing was using it and some of the data was missing and all of it used DOS-style paths.		*** Removed WebSpec because nothing was using it and some of the data was missing and all of it used DOS-style paths.
			** '''2010-11-16''' Added '''WhenAdded''' and '''WhenEdited''' fields because... well, it's easy to do, and provides a secondary check against the event log.
	* '''Fields''':		* '''Fields''':
	** '''Spec''' can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like LocalSpec, StorSpec, SrcSpec...		** '''Spec''' can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like LocalSpec, StorSpec, SrcSpec...
Line 14:		Line 15:
	==SQL==		==SQL==
	<section begin=sql /><mysql> CREATE TABLE `cat_images` (		<section begin=sql /><mysql> CREATE TABLE `cat_images` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	isActive BOOL NOT NULL DEFAULT FALSE,		isActive BOOL NOT NULL DEFAULT FALSE,
	ID_Folder INT NOT NULL COMMENT "base folder to which the Spec is relative",		ID_Folder INT NOT NULL COMMENT "base folder to which the Spec is relative",
	Spec VARCHAR(255) NOT NULL COMMENT "relative filespec for accessing image file",		Spec VARCHAR(255) NOT NULL COMMENT "relative filespec for accessing image file",
	ID_Title INT NOT NULL COMMENT "titles.ID of title to which this image applies",		ID_Title INT NOT NULL COMMENT "titles.ID of title to which this image applies",
	Ab_Size VARCHAR(7) COMMENT "ImgSizes.Ab: abbreviation for image size class",		Ab_Size VARCHAR(7) COMMENT "ImgSizes.Ab: abbreviation for image size class",
	AttrFldr VARCHAR(15) COMMENT "folder (key) name for images with this attribute",		AttrFldr VARCHAR(15) COMMENT "folder (key) name for images with this attribute",
	AttrDispl VARCHAR(64) COMMENT "description to display (e.g. in image tooltip) for this attribute",		AttrDispl VARCHAR(64) COMMENT "description to display (e.g. in image tooltip) for this attribute",
	AttrSort VARCHAR(15) COMMENT "sorting order for this attribute",		AttrSort VARCHAR(15) COMMENT "sorting order for this attribute",
	IDFF_File INT DEFAULT NULL COMMENT "FileFerret.Files.ID",		WhenAdded DATETIME DEFAULT NULL COMMENT "when this record was created",
	IDFF_Fideal INT DEFAULT NULL COMMENT "FileFerret.Fideals.ID",		WhenEdited DATETIME DEFAULT NULL COMMENT "when this record was last updated",
			IDFF_File INT DEFAULT NULL COMMENT "FileFerret.Files.ID",
			IDFF_Fideal INT DEFAULT NULL COMMENT "FileFerret.Fideals.ID",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: changes - +ID_Folder, -WebSpec

2010-11-16T02:35:25Z

changes - +ID_Folder, -WebSpec

← Older revision		Revision as of 02:35, 16 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Stores data for images relevant to displaying catalog entities (currently only Titles)		* '''Purpose''': Stores data for images relevant to displaying catalog entities (currently only Titles)
			* '''History''':
			** '''2010-11-15'''
			*** Added ID_Folder to allow use of different base URLs via {{vbzcart\|table\|cat_folders}}.
			*** Removed WebSpec because nothing was using it and some of the data was missing and all of it used DOS-style paths.
	* '''Fields''':		* '''Fields''':
	** '''Spec''' can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like LocalSpec, StorSpec, SrcSpec...		** '''Spec''' can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like LocalSpec, StorSpec, SrcSpec...
Line 10:		Line 14:
	==SQL==		==SQL==
	<section begin=sql /><mysql> CREATE TABLE `cat_images` (		<section begin=sql /><mysql> CREATE TABLE `cat_images` (
	`ID` INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	isActive BOOL NOT NULL DEFAULT FALSE,		isActive BOOL NOT NULL DEFAULT FALSE,
	~~`Spec` varchar(255)~~ NOT NULL COMMENT 'relative ~~filespec to image file on client system'~~,		ID_Folder INT NOT NULL COMMENT "base folder to which the Spec is relative",
	~~`WebSpec` varchar~~(255) NOT NULL COMMENT 'relative filespec to image file ~~on web server'~~,		Spec VARCHAR(255) NOT NULL COMMENT "relative filespec for accessing image file",
	`ID_Title` INT NOT NULL COMMENT 'titles.ID of title to which this image applies',		ID_Title INT NOT NULL COMMENT "titles.ID of title to which this image applies",
	`Ab_Size~~` varchar~~(7) COMMENT 'ImgSizes.Ab: abbreviation for image size class',		Ab_Size VARCHAR(7) COMMENT "ImgSizes.Ab: abbreviation for image size class",
	`AttrFldr~~` varchar~~(15) COMMENT 'folder (key) name for images with this attribute',		AttrFldr VARCHAR(15) COMMENT "folder (key) name for images with this attribute",
	`AttrDispl~~` varchar~~(64) COMMENT 'description to display (e.g. in image tooltip) for this attribute',		AttrDispl VARCHAR(64) COMMENT "description to display (e.g. in image tooltip) for this attribute",
	`AttrSort~~` varchar~~(15) COMMENT 'sorting order for this attribute',		AttrSort VARCHAR(15) COMMENT "sorting order for this attribute",
	`IDFF_File` INT DEFAULT NULL COMMENT "FileFerret.Files.ID",		IDFF_File INT DEFAULT NULL COMMENT "FileFerret.Files.ID",
	`IDFF_Fideal` INT DEFAULT NULL COMMENT "FileFerret.Fideals.ID",		IDFF_Fideal INT DEFAULT NULL COMMENT "FileFerret.Fideals.ID",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: extracted from "tables" page

2008-12-06T15:48:36Z

extracted from "tables" page

New page

==About==
* '''Purpose''': Stores data for images relevant to displaying catalog entities (currently only Titles)
* '''Fields''':
** '''Spec''' can either be the official location of the file or can be updated from [[FileFerret]] using the IDFF data. It should eventually be renamed to something like LocalSpec, StorSpec, SrcSpec...
** '''WebSpec''' should be considered the official location for the purposes of page display; only image admin functions should update it.
** [[FileFerret]] columns:
*** '''IDFF_File''' should always be set; this way, the file can be located if it gets moved. NOT NULL isn't required, though, because it may be necessary to find the file first and later request a FileFerret ID for it.
*** '''IDFF_Fideal''' is set opportunistically, for now. Later on we may want to have a policy that all VbzCart images should have a Fideal, but this will be determined as FileFerret is worked out.
* '''Future''': I had boldly planned to use [[FileFerret]] to manage image files, and towards that end had boldly removed any actual filespec information from this table, but then later realized that this was placing too much tight dependency on another entire subsystem. Eventually the filespec fields need to be restored and FileFerret should be relegated to keeping them updated if things are moved.
==SQL==
<section begin=sql /><mysql> CREATE TABLE `cat_images` (
`ID` INT NOT NULL AUTO_INCREMENT,
isActive BOOL NOT NULL DEFAULT FALSE,
`Spec` varchar(255) NOT NULL COMMENT 'relative filespec to image file on client system',
`WebSpec` varchar(255) NOT NULL COMMENT 'relative filespec to image file on web server',
`ID_Title` INT NOT NULL COMMENT 'titles.ID of title to which this image applies',
`Ab_Size` varchar(7) COMMENT 'ImgSizes.Ab: abbreviation for image size class',
`AttrFldr` varchar(15) COMMENT 'folder (key) name for images with this attribute',
`AttrDispl` varchar(64) COMMENT 'description to display (e.g. in image tooltip) for this attribute',
`AttrSort` varchar(15) COMMENT 'sorting order for this attribute',
`IDFF_File` INT DEFAULT NULL COMMENT "FileFerret.Files.ID",
`IDFF_Fideal` INT DEFAULT NULL COMMENT "FileFerret.Fideals.ID",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />