1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| CREATE TABLE `produitcritere` (
`id_pc` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`id_prod_pc` mediumint(8) unsigned NOT NULL,
`id_fcpv_pc` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`id_pc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ;
INSERT INTO `produitcritere` (`id_pc`, `id_prod_pc`, `id_fcpv_pc`) VALUES
(73, 32, 19),
(72, 32, 18),
(71, 32, 17),
(70, 32, 16),
(69, 32, 15),
(68, 32, 14),
(67, 32, 13),
(66, 32, 12),
(65, 32, 11),
(64, 32, 10),
(63, 32, 9),
(74, 33, 1),
(75, 33, 2),
(76, 33, 3),
(77, 33, 4);
CREATE TABLE `produitcritere_valeur_liste` (
`id_pcvl` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`id_pc_pcvl` mediumint(8) unsigned NOT NULL,
`id_fcpv_pcvl` mediumint(8) unsigned NOT NULL,
`id_cv_pcvl` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`id_pcvl`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
INSERT INTO `produitcritere_valeur_liste` (`id_pcvl`, `id_pc_pcvl`, `id_fcpv_pcvl`, `id_cv_pcvl`) VALUES
(40, 63, 9, 18),
(39, 63, 9, 1),
(41, 64, 10, 20),
(47, 66, 12, 6),
(45, 66, 12, 3),
(43, 65, 11, 12),
(46, 66, 12, 5),
(44, 65, 11, 14),
(42, 65, 11, 10),
(48, 74, 1, 19),
(49, 75, 2, 0),
(50, 76, 3, 10),
(51, 76, 3, 11),
(52, 77, 4, 3),
(53, 77, 4, 4),
(54, 77, 4, 5); |
Partager