VbzCart/tables/ctg upd1 - Revision history

Woozle: removed unwanted column

2014-08-18T01:07:41Z

removed unwanted column

← Older revision		Revision as of 01:07, 18 August 2014
Line 6:		Line 6:
	** '''2010-12-29''' Added '''ID_Supp''' field because {{vbzcart\|table\|cat_items}} now has that field too		** '''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}}		** '''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==
	~~<section begin=sql />~~<mysql>CREATE TABLE `ctg_upd1` (		<mysql>CREATE TABLE `ctg_upd1` (
	CatSfx VARCHAR(31),		CatSfx VARCHAR(31),
	isCloseOut BOOL,		isCloseOut BOOL,
	~~ID_CTG_Title INT,~~
	ID_CTG_Item INT,		ID_CTG_Item INT,
	ID_Supp INT,		ID_Supp INT,
Line 36:		Line 36:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: TitleName

2011-01-03T00:48:14Z

TitleName

← Older revision		Revision as of 00:48, 3 January 2011
Line 5:		Line 5:
	* '''History''':		* '''History''':
	** '''2010-12-29''' Added '''ID_Supp''' field because {{vbzcart\|table\|cat_items}} now has that field too		** '''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}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ctg_upd1` (		<section begin=sql /><mysql>CREATE TABLE `ctg_upd1` (
Line 21:		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),

Woozle: +ID_Supp

2010-12-30T02:55:44Z

+ID_Supp

← Older revision		Revision as of 02:55, 30 December 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': ~~Experimental, but hopefully will replace~~ {{vbzcart\|table\|ctg_updates}} which never worked entirely properly. ~~This table contains only the essential fields from~~ {{vbzcart/query\|qryCtg_src}}.		* '''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,

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

2009-03-08T18:56:41Z

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

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 {{vbzcart/query|qryCtg_src}}.
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ctg_upd1` (
CatSfx VARCHAR(31),
isCloseOut BOOL,
ID_CTG_Title INT,
ID_CTG_Item 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>
<section end=sql />