Anonymous

CREATE TABLE IF NOT EXISTS `selected_product` (
  `id` bigint(20) NOT NULL auto_increment,
  `basket_id` bigint(20) NOT NULL,
  `quantity` int(6) NOT NULL,
  `updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `created_product_id` bigint(20) NOT NULL,
  `purchase_id` bigint(20) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `basket_created_product` (`created_product_id`),
  KEY `basket_id` (`basket_id`),
  KEY `purchase_id` (`purchase_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=82 ;


INSERT INTO `selected_product` (`id`, `basket_id`, `quantity`, `updated`, `created_product_id`, `purchase_id`, `created`) VALUES 
(81, 45, 1, '0000-00-00 00:00:00', 151, 0, '2007-10-26 13:26:59');



CREATE TABLE IF NOT EXISTS `selected_product_option` (
  `id` bigint(20) NOT NULL auto_increment,
  `quantity` int(8) NOT NULL,
  `selected_product_id` bigint(20) NOT NULL,
  `product_attribute_type_id` bigint(20) NOT NULL,
  `product_attribute_value_id` bigint(20) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=21 ;


INSERT INTO `selected_product_option` (`id`, `quantity`, `selected_product_id`, `product_attribute_type_id`, `product_attribute_value_id`) VALUES 
(19, 1, 81, 7, 19),
(20, 1, 81, 6, 10);