VbzCart/docs/tables/shop cart data type

About

• 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.

SQL

<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cust_data_types`; CREATE TABLE `shop_cust_data_types` (

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

<section end=sql />