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
(New page: ==About== * '''Purpose''': Specifies which item varieties/prices are available in a group ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_items` ( ID INT NOT NULL AUTO_...)
 
(link to catalog-building doc area)
 
(One intermediate revision by the same user not shown)
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''':
 +
** '''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",
   ID_ItTyp      INT NOT NULL COMMENT "cat_ittyps.ID -- basic item type",
+
   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",
+
   ID_ItOpt      INT         DEFAULT NULL COMMENT "cat_itopts.ID -- option for this item",
   Descr          VARCHAR(63) COMMENT "name or description for this item/option",
+
   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",
 
   PriceBuy      DECIMAL(9,2) DEFAULT NULL COMMENT "cost to us",
 
   PriceSell      DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",
 
   PriceSell      DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",
 
   PriceList      DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",
 
   PriceList      DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",
   ID_ShipCost    INT DEFAULT NULL COMMENT "cat_ship_costs.ID",
+
   ID_ShipCost    INT         DEFAULT NULL COMMENT "cat_ship_costs.ID",
   isActive      BOOL DEFAULT FALSE COMMENT "this group/type/option is available",
+
   isActive      BOOL       DEFAULT FALSE COMMENT "this group/type/option is available",
 
   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>