CREATE TABLE IF NOT EXISTS `product_char` (
`product_id` int(11) NOT NULL,
`char_group_id` int(11) NOT NULL,
`char_name_id` int(11) NOT NULL,
`char_value_id` int(11) NOT NULL,
`subProductCategory` int(11) NOT NULL,
`char_value_name` varchar(255) NOT NULL,
PRIMARY KEY (`product_id`,`char_group_id`,`char_name_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
-- Дамп данных таблицы `product_char`
--
INSERT INTO `product_char` (`product_id`, `char_group_id`, `char_name_id`, `char_value_id`, `subProductCategory`, `char_value_name`) VALUES
(67, 36, 40, 73, 12, '16:9'),
(67, 36, 43, 93, 12, 'Есть'),
(67, 43, 45, 85, 12, 'Есть'),
(70, 36, 39, 0, 15, '42"'),
(67, 36, 39, 72, 12, '32"(81,3см)'),
(67, 36, 42, 75, 12, '1366x768 пикс.'),
(67, 36, 41, 74, 12, 'Есть'),
(67, 36, 44, 77, 12, '50Гц'),
(67, 43, 46, 86, 12, 'Есть')
............
|