VbzCart/docs/tables/ctg supp: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(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...)
 
imported>Woozle
(7/2 implemented)
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` (

Revision as of 23:43, 2 July 2009

About

  • Purpose: Information about suppliers which isn't needed for customer web site
  • History:
    • 2009-07-02 finally implemented on L48 server

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 />