Difference between revisions of "VbzCart/tables/ctg upd1"
Jump to navigation
Jump to search
(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 {...) |
(+ID_Supp) |
||
| 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 | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `ctg_upd1` ( | <section begin=sql /><mysql>CREATE TABLE `ctg_upd1` ( | ||
| Line 7: | Line 11: | ||
ID_CTG_Title INT, | ID_CTG_Title INT, | ||
ID_CTG_Item INT, | ID_CTG_Item INT, | ||
| + | ID_Supp INT, | ||
ID_Title INT, | ID_Title INT, | ||
ID_ItTyp INT, | ID_ItTyp INT, | ||
Revision as of 02:55, 30 December 2010
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
SQL
<mysql>CREATE TABLE `ctg_upd1` (
CatSfx VARCHAR(31), isCloseOut BOOL, ID_CTG_Title INT, 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), 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>