Difference between revisions of "VbzCart/tables/ctg supp"
Jump to navigation
Jump to search
(7/2 implemented) |
|||
| 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== | ||
| − | + | <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> | ||
| − | |||
Latest revision as of 20:37, 1 February 2016
About
- Status: DEPRECATED -- no code currently uses this table; will remove eventually
- Purpose: Information about suppliers which isn't needed for customer web site
- History:
- 2009-07-02 finally implemented on L48 server
- 2016-02-01 deprecating -- this table doesn't seem necessary
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>