VbzCart/docs/tables/ supplier ittyps: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(New page: ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `_supplier_ittyps`; CREATE TABLE `_supplier_ittyps` ( `ID` int(11) unsigned NOT NULL, `ItemType` varchar(63) NOT NULL, `It...)
 
imported>Woozle
("about" section)
Line 1: Line 1:
==About==
* '''Purpose''': Cache table
* '''Updated by''': {{vbzcart|proc|Upd_SupplierIttyps}}
* '''Used by''': catalog department page
==SQL==
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `_supplier_ittyps`;
<section begin=sql /><mysql>DROP TABLE IF EXISTS `_supplier_ittyps`;

Revision as of 18:46, 13 April 2009

About

  • Purpose: Cache table
  • Updated by: Template:Vbzcart
  • Used by: catalog department page

SQL

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

  `ID` int(11) unsigned NOT NULL,
  `ItemType` varchar(63) NOT NULL,
  `ItemCount` int NOT NULL,
  `Name` varchar(63) NOT NULL,
  `CatKey` varchar(7) NOT NULL,
  PRIMARY KEY (`ID`,`ItemType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>

<section end=sql />

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