Difference between revisions of "VbzCart/tables/ supplier ittyps"
Jump to navigation
Jump to search
(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
<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>