VbzCart/tables/ supplier ittyps: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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... |
"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`; | ||
Latest revision as of 18:46, 13 April 2009
About
- Purpose: Cache table
- Updated by: Upd_SupplierIttyps
- 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 />
