VbzCart/docs/tables/shop cart data type
Jump to navigation
Jump to search
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.
- History:
- 2009-06-16 Changing table name to singular
SQL
<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cust_data_type`; CREATE TABLE `shop_cust_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>
<section end=sql />