@@verze 1 @@sql CREATE TABLE `mod_eshop_produkt_price_history`( `id` int(11) NOT NULL AUTO_INCREMENT, `id_product` int(11) NOT NULL, `language` int(11) NOT NULL, `row_date` datetime NOT NULL, `old_price` double NOT NULL, `new_price` double NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TRIGGER `mod_eshop_produkt_detail_bu` BEFORE UPDATE ON `mod_eshop_produkt_detail` FOR EACH ROW IF OLD.cena <> NEW.cena THEN INSERT INTO mod_eshop_produkt_price_history SET id_product = OLD.master, language = OLD.jazyk, row_date=NOW(), old_price = OLD.cena, new_price = NEW.cena; END IF; @@init PriceHistoryManager::integrate(); @@reflection if (PriceHistoryManager::isEnabled()) { return "ano"; } else { return "ne"; }