VbzCart/tables/ titles
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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>