VbzCart/tables/ctg supp: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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... |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| 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''': | |||
** '''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 8: | 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>
