CREATE TABLE `xUmLObm6Zd_products` (
`products_id` int(11) NOT NULL,
`external_id` varchar(255) DEFAULT NULL,
`permission_id` int(11) DEFAULT NULL,
`products_owner` int(11) NOT NULL DEFAULT '1',
`products_ean` varchar(255) DEFAULT NULL,
`products_quantity` decimal(15,2) DEFAULT NULL,
`products_average_quantity` int(11) DEFAULT '0',
`products_shippingtime` int(4) DEFAULT NULL,
`products_model` varchar(255) DEFAULT NULL,
`products_master_model` varchar(255) DEFAULT NULL,
`products_master_flag` tinyint(1) DEFAULT NULL,
`products_option_template` varchar(255) DEFAULT NULL,
`products_option_list_template` varchar(255) DEFAULT NULL,
`products_option_master_price` varchar(3) DEFAULT NULL,
`price_flag_graduated_all` int(1) DEFAULT '0',
`price_flag_graduated_1` int(1) DEFAULT '0',
`price_flag_graduated_2` int(1) DEFAULT '0',
`price_flag_graduated_3` int(1) DEFAULT '0',
`products_sort` int(4) DEFAULT '0',
`products_image` varchar(256) DEFAULT NULL,
`products_images_url` text,
`products_price` decimal(15,4) DEFAULT NULL,
`date_added` datetime DEFAULT NULL,
`last_modified` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`date_available` datetime DEFAULT NULL,
`products_weight` decimal(15,4) DEFAULT NULL,
`products_status` tinyint(1) DEFAULT NULL,
`products_tax_class_id` int(11) DEFAULT NULL,
`product_template` varchar(64) DEFAULT NULL,
`product_list_template` varchar(64) DEFAULT NULL,
`manufacturers_id` int(11) DEFAULT NULL,
`products_ordered` int(11) DEFAULT '0',
`products_transactions` int(11) DEFAULT '0',
`products_fsk18` int(1) DEFAULT '0',
`products_vpe` int(11) DEFAULT NULL,
`products_vpe_status` int(1) DEFAULT '0',
`products_vpe_value` decimal(15,4) DEFAULT '0.0000',
`products_average_rating` decimal(14,4) DEFAULT '0.0000',
`products_rating_count` int(11) DEFAULT '0',
`products_digital` int(1) DEFAULT '0',
`flag_has_specials` int(1) NOT NULL DEFAULT '0',
`products_serials` int(1) DEFAULT '0',
`total_downloads` int(11) DEFAULT '0',
`google_product_cat` varchar(255) NOT NULL,
`group_discount_allowed` int(1) NOT NULL DEFAULT '1',
`xt_sperrgut_class` int(11) NOT NULL DEFAULT '0',
`products_image_updated` int(11) NOT NULL DEFAULT '0',
`products_unit` int(11) DEFAULT '39',
`products_image_from_master` tinyint(1) DEFAULT NULL,
`products_master_slave_order` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `xUmLObm6Zd_products`
ADD PRIMARY KEY (`products_id`),
ADD KEY `idx_products_date_added` (`date_added`),
ADD KEY `products_status` (`products_status`),
ADD KEY `products_ordered` (`products_ordered`),
ADD KEY `manufacturers_id` (`manufacturers_id`),
ADD KEY `products_fsk18` (`products_fsk18`),
ADD KEY `products_ean` (`products_ean`);
ALTER TABLE `xUmLObm6Zd_products`
MODIFY `products_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;