Difference between revisions of "VbzCart/tables/ titles"
Jump to navigation
Jump to search
(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,...) |
(listed inputs) |
||
| 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== | ||
| − | + | <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> | ||
| − | |||
Latest revision as of 01:24, 7 September 2015
About
- Purpose: cached information about titles
- Input:
- Upd_Titles_fr_Depts ← cat_titles, _depts
- Upd_Titles_fr_CatItems ← cat_items (grouped by ID_Title)
- Upd_Titles_fr_TitleIttyps ←
- REDIRECT Template:l/vc/query (grouped by ID_Title)
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>