Woozle: not used; use the query instead

2009-03-09T11:19:11Z

not used; use the query instead

← Older revision		Revision as of 11:19, 9 March 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table		* '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table
			* '''Status''': NOT USED; use {{vbzcart/query\|qryStock_containers}} instead
	* '''Fields''':		* '''Fields''':
	** '''Name''': auto-generated but hopefully somewhat descriptive and human-readable name for this container		** '''Name''': auto-generated but hopefully somewhat descriptive and human-readable name for this container

Woozle: New page: ==About== * '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table * '''Fields''': ** '''Name''': auto-generated but hopefully somewhat descript...

2009-03-08T20:43:54Z

New page: ==About== * '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table * '''Fields''': ** '''Name''': auto-generated but hopefully somewhat descript...

New page

==About==
* '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table
* '''Fields''':
** '''Name''': auto-generated but hopefully somewhat descriptive and human-readable name for this container
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `_stk_containers`;
CREATE TABLE `_stk_containers` (
`IDS` varchar(31) NOT NULL COMMENT "Type + ID_forType: unique ID for this container, across all types",
`Type` char(1) NOT NULL COMMENT "identifies which type of container each record refers to",
`ID_forType` INT NOT NULL COMMENT "record's unique ID for that type",
`Name` varchar(63) NOT NULL COMMENT "auto-generated human-readable name for this container",
`When` DATETIME COMMENT "applicable date, as a somewhat more human-readable cue for some of the container types",
PRIMARY KEY(`IDS`)
) ENGINE = MYISAM;</mysql>
<section end=sql />

VbzCart/tables/ stk containers - Revision history

Woozle: not used; use the query instead

Woozle: New page: ==About== * '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table * '''Fields''': ** '''Name''': auto-generated but hopefully somewhat descript...