https://htyp.org/mw/index.php?title=VbzCart/tables/cart_data&feed=atom&action=historyVbzCart/tables/cart data - Revision history2024-03-29T14:39:31ZRevision history for this page on the wikiMediaWiki 1.35.0https://htyp.org/mw/index.php?title=VbzCart/tables/cart_data&diff=25042&oldid=prevWoozle: Created page with "==About== * '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order. * '''Relates to''': parent: {{l..."2019-07-25T15:03:59Z<p>Created page with "==About== * '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order. * '''Relates to''': parent: {{l..."</p>
<p><b>New page</b></p><div>==About==<br />
* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.<br />
* '''Relates to''': parent: {{l/same|shop_cart}}<br />
* '''History''':<br />
** '''2019-07-25''' creating from scratch, but very similar to the (obsolete) {{l/same|shop_cart_data}} table<br />
==SQL==<br />
<source lang=mysql>DROP TABLE IF EXISTS `cart_data`;<br />
CREATE TABLE `cart_data` (<br />
`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",<br />
`name` VARCHAR(63) NOT NULL COMMENT "field name - defined in code",<br />
`value` VARCHAR(255) NOT NULL COMMENT "Value of data item",<br />
PRIMARY KEY(`ID_Cart`,`name`)<br />
) ENGINE = InnoDB;</source></div>Woozle