[ZendFramework][ZF2] Doctrine 2 generowanie Entites z DB Opcje

[netvalue]

Cześć

Po przez doctrine-module orm:conver-mapping -from data-base , próbuje wygenerowac Entites ale otrzymuje blad

[PHP] pobierz, plaintext 
Table category_product has no primary key.
[PHP] pobierz, plaintext 

moje tabel sql:

[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `category_product` (
  `id_category` int(11) NOT NULL,
  `id_product` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
CREATE TABLE IF NOT EXISTS `product` (
  `id_product` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id_product`),
  KEY `product_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
[SQL] pobierz, plaintext 

Niestety nie moge ustawić primary key w tabeli category_product poniewaz sa tam rekordy np:

id_category | id_product
2 | 3
2 | 4
10| 3


Co moge zrobic w takim przypadku ?

[netvalue]

teraz otrzumje przy generowaniu Entitre:
Table product_params has no primary key.



(IMG:http://s29.postimg.org/iw1tz2akn/Bez_nazwy_1.jpg)

[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `category` (
  `id_category` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `id_parent` int(11) NOT NULL,
  PRIMARY KEY (`id_category`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
--
-- Struktura tabeli dla tabeli `category_product`
--
 
CREATE TABLE IF NOT EXISTS `category_product` (
  `id_product` int(11) NOT NULL,
  `id_category` int(11) NOT NULL,
  PRIMARY KEY (`id_product`,`id_category`),
  KEY `fk_product_has_category_category1_idx` (`id_category`),
  KEY `fk_product_has_category_product_idx` (`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
--
-- Struktura tabeli dla tabeli `product`
--
 
CREATE TABLE IF NOT EXISTS `product` (
  `id_product` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
--
-- Struktura tabeli dla tabeli `product_params`
--
 
CREATE TABLE IF NOT EXISTS `product_params` (
  `id_product` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  KEY `fk_product_params_product1_idx` (`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Ograniczenia dla zrzutów tabel
--
 
--
-- Ograniczenia dla tabeli `category_product`
--
ALTER TABLE `category_product`
  ADD CONSTRAINT `fk_product_has_category_product` FOREIGN KEY (`id_product`) REFERENCES `product` (`id_product`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_product_has_category_category1` FOREIGN KEY (`id_category`) REFERENCES `category` (`id_category`) ON DELETE NO ACTION ON UPDATE NO ACTION;
 
--
-- Ograniczenia dla tabeli `product_params`
--
ALTER TABLE `product_params`
  ADD CONSTRAINT `fk_product_params_product1` FOREIGN KEY (`id_product`) REFERENCES `product` (`id_product`) ON DELETE NO ACTION ON UPDATE NO ACTION;
[SQL] pobierz, plaintext 

Ten post edytował netvalue 22.08.2014, 09:45:13