VbzCart/tables/ titles

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 ←

1. 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>