VbzCart/tables/shop cart data type

From HTYP, the free directory anyone can edit

Jump to: navigation, search

[edit] 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.

[edit] SQL

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;
Personal tools