Woozle: listed inputs

2015-09-07T01:24:21Z

listed inputs

← Older revision		Revision as of 01:24, 7 September 2015
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': cached information about titles		* '''Purpose''': cached information about titles
			* '''Input''':
			** {{vbzcart\|proc\|Upd_Titles_fr_Depts}} ← {{vbzcart\|table\|cat_titles}}, {{vbzcart\|table\|_depts}}
			** {{vbzcart\|proc\|Upd_Titles_fr_CatItems}} ← {{vbzcart\|table\|cat_items}} (grouped by ID_Title)
			** {{vbzcart\|proc\|Upd_Titles_fr_TitleIttyps}} ← {{vbzcart/query\|qryCat_Titles_Item_stats}} (grouped by ID_Title)
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql> DROP TABLE IF EXISTS `_titles`;		<mysql> DROP TABLE IF EXISTS `_titles`;
	CREATE TABLE `_titles` (		CREATE TABLE `_titles` (
	`ID` int(11) unsigned NOT NULL,		`ID` int(11) unsigned NOT NULL,
Line 15:		Line 19:
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>		) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>
	~~<section end=sql />~~

Woozle: New page: ==About== * '''Purpose''': cached information about titles ==SQL==
DROP TABLE IF EXISTS `_titles`; CREATE TABLE `_titles` ( `ID` int(11) unsigned NOT NULL,...

2009-03-08T19:36:23Z

New page: ==About== * '''Purpose''': cached information about titles ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_titles`; CREATE TABLE `_titles` ( `ID` int(11) unsigned NOT NULL,...

New page

==About==
* '''Purpose''': cached information about titles
==SQL==
<section begin=sql /><mysql> DROP TABLE IF EXISTS `_titles`;
CREATE TABLE `_titles` (
`ID` int(11) unsigned NOT NULL,
`ID_Supp` int(11) unsigned NOT NULL COMMENT "avoids need for joining with cat_depts",
`CatNum` varchar(63) NOT NULL,
`CatWeb` varchar(63) NOT NULL,
`cntForSale` int DEFAULT NULL,
`cntInPrint` int DEFAULT NULL,
`qtyInStock` int DEFAULT NULL,
`currMinSell` DECIMAL(9,2) DEFAULT NULL COMMENT "minimum selling price for an item of this title",
`currMaxSell` DECIMAL(9,2) DEFAULT NULL COMMENT "maximum selling price for an item of this title",
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>
<section end=sql />

VbzCart/tables/ titles - Revision history

Woozle: listed inputs

Woozle: New page: ==About== * '''Purpose''': cached information about titles ==SQL== DROP TABLE IF EXISTS `_titles`; CREATE TABLE `_titles` ( `ID` int(11) unsigned NOT NULL,...

Woozle: New page: ==About== * '''Purpose''': cached information about titles ==SQL==
DROP TABLE IF EXISTS `_titles`; CREATE TABLE `_titles` ( `ID` int(11) unsigned NOT NULL,...