VbzCart/docs/tables/ titles: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (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,...) |
m (Woozle moved page VbzCart/VbzCart/tables/ titles to VbzCart/docs/tables/ titles without leaving a redirect: part 3/5) |
||
| (One intermediate revision by one other user not shown) | |||
| 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:56, 25 February 2024
About
- Purpose: cached information about titles
- Input:
- Template:Vbzcart ← Template:Vbzcart, Template:Vbzcart
- Template:Vbzcart ← Template:Vbzcart (grouped by ID_Title)
- Template:Vbzcart ← Template:Vbzcart/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>