[/B] Ayuda ... porfavor PRIMARY KEY[/B]

[gnzsoloyo]

Me parece que este tema ya se trató aquí, pero evidentemente no se entendió la respuesta...
Lo que normalmente se hace:

Código MySQL:

/***********************************************************************************************************/
 
DROP TABLE IF EXISTS `producto`;
CREATE TABLE  `producto` (
  `numprod` int(20) unsigned NOT NULL,
  `descprod` varchar(20) NOT NULL,
  `preuniprod` int(20) unsigned NOT NULL,
  PRIMARY KEY  (`numprod`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
/***********************************************************************************************************/
 
DROP TABLE IF EXISTS `proveedor`;
CREATE TABLE  `proveedor` (
  `numprov` int(20) unsigned NOT NULL,
  `nomprov` varchar(20) NOT NULL,
  `dirprov` varchar(20) NOT NULL,
  PRIMARY KEY  (`numprov`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
/***********************************************************************************************************/
 
DROP TABLE IF EXISTS `pedido`;
CREATE TABLE  `pedido` (
  `numped` int(20) unsigned NOT NULL,
  `numprov` int(20) unsigned NOT NULL,
  `mtotlped` int(20) unsigned NOT NULL,
  PRIMARY KEY  (`numped`),
  KEY `numprov` (`numprov`),
  CONSTRAINT `FK_pedido_proveedor` FOREIGN KEY (`numprov`)
  REFERENCES `proveedor` (`numprov`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
/***********************************************************************************************************/
 
DROP TABLE IF EXISTS `pedidoprod`;
CREATE TABLE  `pedidoprod` (
  `numped` int(20) unsigned NOT NULL,
  `subitemped` int(20) unsigned NOT NULL,
  `numprod` int(20) unsigned NOT NULL,
  `cantped` int(20) unsigned NOT NULL,
  `subtlprod` int(20) unsigned NOT NULL,
  PRIMARY KEY  USING BTREE (`numped`,`subitemped`),
  KEY `numprod` (`numprod`),
  CONSTRAINT `FK_pedidoprod_prod` FOREIGN KEY (`numprod`)
  REFERENCES `producto` (`numprod`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_pedidoprod_nroped` FOREIGN KEY (`numped`)
  REFERENCES `pedido` (`numped`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/***********************************************************************************************************/
/* Y para completar.. el TRIGGER que puede numerar los subitems, si po ocio no quieres manejarlo tu mismo. */
/***********************************************************************************************************/
DROP TRIGGER IF EXISTS subitempedido;
DELIMITER $$
CREATE TRIGGER subitempedido BEFORE INSERT
ON pedidoprod
FOR EACH ROW
BEGIN
        IF(SELECT MAX(subitemped) FROM pedidoprod WHERE numped = NEW.numped) IS NULL THEN
      SET NEW.subitemped = 1;
    ELSE
      SET NEW.subitemped=(SELECT MAX(subitemped) FROM pedidoprod WHERE numped = NEW.numped) + 1;
    END IF;
END$$
 
DELIMITER ;