VbzCart/docs/tables/shop cart data type: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
m (changing table names to singular)
m (Woozle moved page VbzCart/VbzCart/tables/shop cart data type to VbzCart/docs/tables/shop cart data type without leaving a redirect: part 4/5)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
==About==
==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.
* '''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''':
* '''History''':
** '''2009-06-16''' Changing table name to singular
** '''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==
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cust_data_type`;
<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data_type`;
CREATE TABLE `shop_cust_data_type` (
CREATE TABLE `shop_cart_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",

Latest revision as of 01:57, 25 February 2024

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

<section begin=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>

<section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/shop_cart_data_type&oldid=6953"