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...)
 
m (Woozle moved page VbzCart/VbzCart/tables/ supplier ittyps to VbzCart/docs/tables/ supplier ittyps without leaving a redirect: part 3/5)
 
(One intermediate revision by one other user not shown)
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`;

Latest revision as of 01:56, 25 February 2024

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 />