VbzCart/tables/shop cart data type

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
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • Status: NOT USED
  • Purpose: This table is probably unnecessary, but I can't convince myself of that. If nothing else, it will help prevent inconsistent usage. It might be useful for reports or something.
  • History:
    • 2009-06-16 Changing table name to singular
    • 2009-07-24 Pretty sure this should just be hard-coded, and no table is necessary; if necessity for a table can be shown, then that needs to be documented. Also renaming shop_cust_data_type -> shop_cart_data_type to clarify its relationship to other tables, if it is ever needed.

SQL

<mysql>DROP TABLE IF EXISTS `shop_cart_data_type`; CREATE TABLE `shop_cart_data_type` (

 `ID`         INT NOT NULL AUTO_INCREMENT,
 `Name`       VARCHAR(31) NOT NULL COMMENT "Short name, for reports or whatever",
 `Descr`      VARCHAR(255) DEFAULT NULL COMMENT "Longer description of data item, e.g. usage notes",
 PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>