CREATE TABLE `item` (
                        `id` int(11) NOT NULL,
                        `partnumber` varchar(30) DEFAULT NULL,
                        `codigo2` varchar(30) DEFAULT NULL,
                        `codigo3` varchar(30) DEFAULT NULL,
                        `codigo4` varchar(30) DEFAULT NULL,
                        `name` varchar(100) DEFAULT NULL,
                        `pvp1` double DEFAULT NULL,
                        `pvp2` double DEFAULT NULL,
                        `pvp3` double DEFAULT NULL,
                        `pvp4` double DEFAULT NULL,
                        `pvp5` double DEFAULT NULL,
                        `porcdesc1` double DEFAULT NULL,
                        `porcdesc2` double DEFAULT NULL,
                        `porcdesc3` double DEFAULT NULL,
                        `porcdesc4` double DEFAULT NULL,
                        `porcdesc5` double DEFAULT NULL,
                        `cost` double DEFAULT NULL,
                        `iva` tinyint(1) DEFAULT NULL,
                        `aplica_pda` tinyint(1) DEFAULT NULL,
                        `isservice` tinyint(1) DEFAULT NULL,
                        `negativo` tinyint(1) DEFAULT NULL,
                        `solopromocion` tinyint(1) DEFAULT NULL,
                        `unidad` varchar(20) DEFAULT NULL,
                        `descripcion` varchar(200) DEFAULT NULL,
                        `uc` decimal(3,0) DEFAULT NULL,
                        `peso` double DEFAULT NULL,
                        `idgrupo` int(11) DEFAULT NULL,
                        `idfam` int(11) DEFAULT NULL,
                        `idsubfam` int(11) DEFAULT NULL,
                        `idbrand` int(11) DEFAULT NULL,
                        `idsupplier` int(11) DEFAULT NULL,
                        `stock` double DEFAULT NULL,
                        `rotacion` double DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
