Preis updaten

[Bernd]

--
-- Tabellenstruktur für Tabelle `xUmLObm6Zd_products`
--

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;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `xUmLObm6Zd_products`
--
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`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `xUmLObm6Zd_products`
--
ALTER TABLE `xUmLObm6Zd_products`
  MODIFY `products_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;