Ver originalCREATE TABLE IF NOT EXISTS `cat3_subgeneral` ( `id_subgeneral` int(7) NOT NULL AUTO_INCREMENT, `nombre_subgeneral` varchar(100) NOT NULL, `id_pregeneral` int(7) NOT NULL, `id_general` int(7) NOT NULL, PRIMARY KEY (`id_subgeneral`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=62 ;
Ver originalCREATE TABLE IF NOT EXISTS `fabricante` ( `id_fabricante` int(7) NOT NULL AUTO_INCREMENT, `nombre_fabricante` varchar(250) NOT NULL, PRIMARY KEY (`id_fabricante`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ;
Ver originalCREATE TABLE IF NOT EXISTS `marcas` ( `id_marca` int(7) NOT NULL AUTO_INCREMENT, `nombre_marca` varchar(250) NOT NULL, `ruta` varchar(250) NOT NULL, PRIMARY KEY (`id_marca`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=99 ;
Ver originalCREATE TABLE IF NOT EXISTS `modelo` ( `id_modelo` int(7) NOT NULL AUTO_INCREMENT, `nombre_modelo` varchar(250) NOT NULL, `id_marca` int(11) NOT NULL, `ruta` varchar(250) NOT NULL, PRIMARY KEY (`id_modelo`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3082 ;
Ver originalCREATE TABLE IF NOT EXISTS `productos` ( `id_producto` int(7) NOT NULL AUTO_INCREMENT, `nombre_producto` varchar(250) NOT NULL, `referencia` varchar(250) NOT NULL, `id_fabricante` int(7) NOT NULL, `id_subgeneral` int(7) NOT NULL, `compatible` int(20) DEFAULT NULL, PRIMARY KEY (`id_producto`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=322 ;