VbzCart/tables/ctg supp - Revision history

Woozle at 20:37, 1 February 2016

2016-02-01T20:37:35Z

← Older revision		Revision as of 20:37, 1 February 2016
Line 1:		Line 1:
	==About==		==About==
			* '''Status''': DEPRECATED -- no code currently uses this table; will remove eventually
	* '''Purpose''': Information about suppliers which isn't needed for customer web site		* '''Purpose''': Information about suppliers which isn't needed for customer web site
	* '''History''':		* '''History''':
	** '''2009-07-02''' finally implemented on L48 server		** '''2009-07-02''' finally implemented on L48 server
			** '''2016-02-01''' deprecating -- this table doesn't seem necessary
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `ctg_supp` (		<mysql>CREATE TABLE `ctg_supp` (
	ID INT NOT NULL COMMENT "cat_supp.ID - supplier to which information applies",		ID INT NOT NULL COMMENT "cat_supp.ID - supplier to which information applies",
	ID_PriceFunc INT DEFAULT NULL COMMENT "ctg_prc_funcs.ID - function to use when calculating prices for this supplier",		ID_PriceFunc INT DEFAULT NULL COMMENT "ctg_prc_funcs.ID - function to use when calculating prices for this supplier",
Line 10:		Line 12:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: 7/2 implemented

2009-07-02T23:43:58Z

7/2 implemented

← Older revision		Revision as of 23:43, 2 July 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Information about suppliers which isn't needed for customer web site		* '''Purpose''': Information about suppliers which isn't needed for customer web site
			* '''History''':
			** '''2009-07-02''' finally implemented on L48 server
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ctg_supp` (		<section begin=sql /><mysql>CREATE TABLE `ctg_supp` (

Woozle: New page: ==About== * '''Purpose''': Information about suppliers which isn't needed for customer web site ==SQL==
CREATE TABLE `ctg_supp` ( ID INT NOT NULL COMMENT "ca...

2009-03-08T18:37:22Z

New page: ==About== * '''Purpose''': Information about suppliers which isn't needed for customer web site ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_supp` ( ID INT NOT NULL COMMENT "ca...

New page

==About==
* '''Purpose''': Information about suppliers which isn't needed for customer web site
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ctg_supp` (
ID INT NOT NULL COMMENT "cat_supp.ID - supplier to which information applies",
ID_PriceFunc INT DEFAULT NULL COMMENT "ctg_prc_funcs.ID - function to use when calculating prices for this supplier",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />

VbzCart/tables/ctg supp - Revision history

Woozle at 20:37, 1 February 2016

Woozle: 7/2 implemented

Woozle: New page: ==About== * '''Purpose''': Information about suppliers which isn't needed for customer web site ==SQL== CREATE TABLE `ctg_supp` ( ID INT NOT NULL COMMENT "ca...

Woozle: New page: ==About== * '''Purpose''': Information about suppliers which isn't needed for customer web site ==SQL==
CREATE TABLE `ctg_supp` ( ID INT NOT NULL COMMENT "ca...