VbzCart/docs/tables/ctg upd1: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''': Experimental, but hopefully will replace {{vbzcart|table|ctg_updates}} which never worked entirely properly. This table contains only the essential fields from {...) |
m (Woozle moved page VbzCart/VbzCart/tables/ctg upd1 to VbzCart/docs/tables/ctg upd1 without leaving a redirect: part 3/5) |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': | * '''Purpose''': intermediate calculations for updating {{vbzcart|table|cat_items}} from catalog-source tables | ||
** Replaces {{vbzcart|table|ctg_updates}} which never worked entirely properly. | |||
* '''Source''': {{vbzcart/query|qryCtg_src}} (essential fields only) | |||
* '''History''': | |||
** '''2010-12-29''' Added '''ID_Supp''' field because {{vbzcart|table|cat_items}} now has that field too | |||
** '''2011-01-02''' Added '''TitleName''' to fill in new '''Descr''' field in {{vbzcart|table|cat_items}} | |||
** '''2014-08-17''' Removed '''ID_CTG_Title''' to match output of {{vbzcart/query|qryCtg_src_sub}}. | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `ctg_upd1` ( | |||
CatSfx VARCHAR(31), | CatSfx VARCHAR(31), | ||
isCloseOut BOOL, | isCloseOut BOOL, | ||
ID_CTG_Item INT, | ID_CTG_Item INT, | ||
ID_Supp INT, | |||
ID_Title INT, | ID_Title INT, | ||
ID_ItTyp INT, | ID_ItTyp INT, | ||
| Line 16: | Line 22: | ||
ItOpt_Descr_part VARCHAR(63), | ItOpt_Descr_part VARCHAR(63), | ||
NameSng VARCHAR(63), | NameSng VARCHAR(63), | ||
TitleName VARCHAR(127), | |||
GrpItmDescr VARCHAR(63), | GrpItmDescr VARCHAR(63), | ||
TitleGroupDescr VARCHAR(63), | TitleGroupDescr VARCHAR(63), | ||
| Line 29: | Line 36: | ||
) | ) | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
Latest revision as of 01:56, 25 February 2024
About
- Purpose: intermediate calculations for updating Template:Vbzcart from catalog-source tables
- Replaces Template:Vbzcart which never worked entirely properly.
- Source: Template:Vbzcart/query (essential fields only)
- History:
- 2010-12-29 Added ID_Supp field because Template:Vbzcart now has that field too
- 2011-01-02 Added TitleName to fill in new Descr field in Template:Vbzcart
- 2014-08-17 Removed ID_CTG_Title to match output of Template:Vbzcart/query.
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>