VbzCart/tables/ dept ittyps - Revision history

Woozle: +ID_Supp

2011-02-02T17:02:20Z

+ID_Supp

← Older revision		Revision as of 17:02, 2 February 2011
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': cache table for catalog display		* '''Purpose''': cache table for catalog display
	* '''Used for''': customer-side department ~~pages~~		* '''Used for''': customer-side supplier pages (/cat/xx/)
			** Earlier note indicated it was used for customer-side department page, but I don't see evidence of this. (2011-02-02)
			** Prior to 2011-02-02, a very slow query ({{vbzcart/query\|qryItTypsDepts_ItTyps}}) was temporarily in use.
	* '''Sources''': {{vbzcart\|proc\|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_DeptIttyps_fr_CatIttyps}}		* '''Sources''': {{vbzcart\|proc\|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_DeptIttyps_fr_CatIttyps}}
	* '''Used by''': {{vbzcart\|proc\|Upd_Depts_fr_DeptIttyps}}		* '''Used by''': {{vbzcart\|proc\|Upd_Depts_fr_DeptIttyps}}
	* '''History''':		* '''History''':
	** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo		** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo
			** '''2011-02-02''' added '''ID_Supp''' field so we can actually use this without doing another join
	==SQL==		==SQL==
	<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`;		<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`;
	CREATE TABLE `_dept_ittyps` (		CREATE TABLE `_dept_ittyps` (
	`ID_ItTyp` ~~int unsigned~~ NOT NULL,		`ID_ItTyp` INT UNSIGNED NOT NULL,
	`ID_Dept` ~~int unsigned~~ NOT NULL,		`ID_Dept` INT UNSIGNED NOT NULL,
	`cntForSale` ~~int unsigned~~ NOT NULL,		`ID_Supp` INT UNSIGNED NOT NULL,
	`cntInPrint` ~~int unsigned~~ NOT NULL,		`cntForSale` INT UNSIGNED NOT NULL,
	`qtyInStock` ~~int unsigned~~ NOT NULL,		`cntInPrint` INT UNSIGNED NOT NULL,
	`ItTypNameSng` ~~varchar~~(64) DEFAULT NULL COMMENT 'cat_ittyps.NameSng',		`qtyInStock` INT UNSIGNED NOT NULL,
	`ItTypNamePlr` ~~varchar~~(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng',		`ItTypNameSng` VARCHAR(64) DEFAULT NULL COMMENT 'cat_ittyps.NameSng',
			`ItTypNamePlr` VARCHAR(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng',
	PRIMARY KEY (`ID_ItTyp`,`ID_Dept`)		PRIMARY KEY (`ID_ItTyp`,`ID_Dept`)
	) ENGINE=MyISAM;</mysql>		) ENGINE=MyISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: sources, used by

2010-11-14T16:52:26Z

sources, used by

← Older revision		Revision as of 16:52, 14 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': cache table for catalog display		* '''Purpose''': cache table for catalog display
	* '''Used by''': department pages		* '''Used for''': customer-side department pages
			* '''Sources''': {{vbzcart\|proc\|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart\|proc\|Upd_DeptIttyps_fr_CatIttyps}}
			* '''Used by''': {{vbzcart\|proc\|Upd_Depts_fr_DeptIttyps}}
	* '''History''':		* '''History''':
	** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo		** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo

Woozle: created in db; a little doc

2010-11-13T02:51:35Z

created in db; a little doc

← Older revision		Revision as of 02:51, 13 November 2010
Line 1:		Line 1:
			==About==
			* '''Purpose''': cache table for catalog display
			* '''Used by''': department pages
			* '''History''':
			** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo
	==SQL==		==SQL==
	<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`;		<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`;
Line 10:		Line 15:
	`ItTypNamePlr` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng',		`ItTypNamePlr` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng',
	PRIMARY KEY (`ID_ItTyp`,`ID_Dept`)		PRIMARY KEY (`ID_ItTyp`,`ID_Dept`)
	) ENGINE=MyISAM ~~DEFAULT CHARSET=latin1~~;</mysql>		) ENGINE=MyISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: New page: ==SQL==
DROP TABLE IF EXISTS `_dept_ittyps`; CREATE TABLE `_dept_ittyps` ( `ID_ItTyp` int unsigned NOT NULL, `ID_Dept` int unsigned NOT NULL, `cntFor...

2009-03-08T20:13:32Z

New page: ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`; CREATE TABLE `_dept_ittyps` ( `ID_ItTyp` int unsigned NOT NULL, `ID_Dept` int unsigned NOT NULL, `cntFor...

New page

==SQL==
<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`;
CREATE TABLE `_dept_ittyps` (
`ID_ItTyp` int unsigned NOT NULL,
`ID_Dept` int unsigned NOT NULL,
`cntForSale` int unsigned NOT NULL,
`cntInPrint` int unsigned NOT NULL,
`qtyInStock` int unsigned NOT NULL,
`ItTypNameSng` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NameSng',
`ItTypNamePlr` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng',
PRIMARY KEY (`ID_ItTyp`,`ID_Dept`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>
<section end=sql />

VbzCart/tables/ dept ittyps - Revision history

Woozle: +ID_Supp

Woozle: sources, used by

Woozle: created in db; a little doc

Woozle: New page: ==SQL== DROP TABLE IF EXISTS `_dept_ittyps`; CREATE TABLE `_dept_ittyps` ( `ID_ItTyp` int unsigned NOT NULL, `ID_Dept` int unsigned NOT NULL, `cntFor...

Woozle: New page: ==SQL==
DROP TABLE IF EXISTS `_dept_ittyps`; CREATE TABLE `_dept_ittyps` ( `ID_ItTyp` int unsigned NOT NULL, `ID_Dept` int unsigned NOT NULL, `cntFor...