VbzCart/docs/tables/shop cart data type: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (VbzCart/tables/shop cust data types moved to VbzCart/tables/shop cust data type: changing table names to singular) |
imported>Woozle m (changing table names to singular) |
||
Line 1: | Line 1: | ||
==About== | ==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. | * '''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== | ==SQL== | ||
<section begin=sql /><mysql>DROP TABLE IF EXISTS ` | <section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cust_data_type`; | ||
CREATE TABLE ` | CREATE TABLE `shop_cust_data_type` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`Name` VARCHAR(31) NOT NULL COMMENT "Short name, for reports or whatever", | `Name` VARCHAR(31) NOT NULL COMMENT "Short name, for reports or whatever", |
Revision as of 23:51, 16 June 2009
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 />