VbzCart/docs/tables/ supplier ittyps: Difference between revisions
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 />