Difference between revisions of "VbzCart/tables/ctg items"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(+Sort field)
(link to catalog-building doc area)
 
Line 1: Line 1:
 
==About==
 
==About==
 
* '''Purpose''': Specifies which item varieties/prices are available in a group
 
* '''Purpose''': Specifies which item varieties/prices are available in a group
 +
* '''Part of''': {{l/vc|pieces/catalog/building}}
 
* '''History''':
 
* '''History''':
 
** '''2011-02-13''' added '''Sort''' field
 
** '''2011-02-13''' added '''Sort''' field
 +
** '''2017-06-12''' changed engine from MYISAM to InnoDB
 
==SQL==
 
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ctg_items` (
+
<mysql>CREATE TABLE `ctg_items` (
 
   ID            INT              NOT NULL AUTO_INCREMENT,
 
   ID            INT              NOT NULL AUTO_INCREMENT,
 
   ID_Group      INT              NOT NULL COMMENT "ctg_groups.ID",
 
   ID_Group      INT              NOT NULL COMMENT "ctg_groups.ID",
Line 18: Line 20:
 
   PRIMARY KEY(`ID`)
 
   PRIMARY KEY(`ID`)
 
)
 
)
ENGINE = MYISAM;</mysql>
+
ENGINE = InnoDB;</mysql>
<section end=sql />
 

Latest revision as of 11:13, 12 June 2017

About

  • Purpose: Specifies which item varieties/prices are available in a group
  • Part of: pieces/catalog/building
  • History:
    • 2011-02-13 added Sort field
    • 2017-06-12 changed engine from MYISAM to InnoDB

SQL

<mysql>CREATE TABLE `ctg_items` (

 ID             INT              NOT NULL AUTO_INCREMENT,
 ID_Group       INT              NOT NULL COMMENT "ctg_groups.ID",
 ID_ItTyp       INT              NOT NULL COMMENT "cat_ittyps.ID -- basic item type",
 ID_ItOpt       INT          DEFAULT NULL COMMENT "cat_itopts.ID -- option for this item",
 Descr          VARCHAR(63)               COMMENT "name or description for this item/option",
 Sort           VARCHAR(15)  DEFAULT NULL COMMENT "sorting order for display",
 PriceBuy       DECIMAL(9,2) DEFAULT NULL COMMENT "cost to us",
 PriceSell      DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",
 PriceList      DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",
 ID_ShipCost    INT          DEFAULT NULL COMMENT "cat_ship_costs.ID",
 isActive       BOOL        DEFAULT FALSE COMMENT "this group/type/option is available",
 PRIMARY KEY(`ID`)

) ENGINE = InnoDB;</mysql>