VbzCart/tables/ctg upd1
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: intermediate calculations for updating cat_items from catalog-source tables
- Replaces ctg_updates which never worked entirely properly.
- Source:
- REDIRECT Template:l/vc/query (essential fields only)
- History:
- 2010-12-29 Added ID_Supp field because cat_items now has that field too
- 2011-01-02 Added TitleName to fill in new Descr field in cat_items
- 2014-08-17 Removed ID_CTG_Title to match output of qryCtg_src_sub.
SQL
<mysql>CREATE TABLE `ctg_upd1` (
CatSfx VARCHAR(31), isCloseOut BOOL, ID_CTG_Item INT, ID_Supp INT, ID_Title INT, ID_ItTyp INT, ID_ItOpt INT, ID_ShipCost INT, PriceBuy DECIMAL(9,2), PriceSell DECIMAL(9,2), PriceList DECIMAL(9,2), ItOpt_Descr_part VARCHAR(63), NameSng VARCHAR(63), TitleName VARCHAR(127), GrpItmDescr VARCHAR(63), TitleGroupDescr VARCHAR(63), OptionDescr VARCHAR(63), ItOpt_Sort VARCHAR(31), GrpCode VARCHAR(15), GrpDescr VARCHAR(31), GrpSort VARCHAR(31), IDS_Item VARCHAR(31), CatNum VARCHAR(31), ItOpt_Descr VARCHAR(63), PRIMARY KEY(`IDS_Item`)
) ENGINE = MYISAM;</mysql>