Attachment 161782 Details for Bug 203600 – patch to enable ActiveSync

patch to enable ActiveSync

activesync.patch (text/plain), 4.06 KB, created by Martin Waschbüsch on 2015-10-07 05:43:44 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Waschbüsch

Created: 2015-10-07 05:43:44 UTC

Size: 4.06 KB

patch

obsolete

>DROP TABLE xt_products_price_group_5;
>DROP TABLE xt_products_price_group_6;
>DROP TABLE xt_products_price_group_7;
>DROP TABLE xt_products_price_group_8;
>
>CREATE VIEW xt_products_price_group_5 (id,products_id,discount_quantity,price) AS SELECT id,products_id,discount_quantity,price FROM xt_products_price_group_3;
>CREATE VIEW xt_products_price_group_6 (id,products_id,discount_quantity,price) AS SELECT id,products_id,discount_quantity,price FROM xt_products_price_group_3;
>CREATE VIEW xt_products_price_group_7 (id,products_id,discount_quantity,price) AS SELECT id,products_id,discount_quantity,price FROM xt_products_price_group_3;
>CREATE VIEW xt_products_price_group_8 (id,products_id,discount_quantity,price) AS SELECT id,products_id,discount_quantity,price FROM xt_products_price_group_3;
>
>
>
>
>
>
>
>
>
>
>DROP VIEW xt_products_price_group_5;
>DROP VIEW xt_products_price_group_6;
>DROP VIEW xt_products_price_group_7;
>DROP VIEW xt_products_price_group_8;
>
>CREATE TABLE `xt_products_price_group_5` (
>  `id` int(11) NOT NULL AUTO_INCREMENT,
>  `products_id` int(11) NOT NULL,
>  `discount_quantity` int(11) DEFAULT NULL,
>  `price` decimal(15,4) DEFAULT NULL,
>  PRIMARY KEY (`id`),
>  KEY `products_id` (`products_id`)
>) ENGINE=MyISAM AUTO_INCREMENT=4147 DEFAULT CHARSET=utf8;
>
>CREATE TABLE `xt_products_price_group_6` (
>  `id` int(11) NOT NULL AUTO_INCREMENT,
>  `products_id` int(11) NOT NULL,
>  `discount_quantity` int(11) DEFAULT NULL,
>  `price` decimal(15,4) DEFAULT NULL,
>  PRIMARY KEY (`id`),
>  KEY `products_id` (`products_id`)
>) ENGINE=MyISAM AUTO_INCREMENT=4147 DEFAULT CHARSET=utf8;
>
>CREATE TABLE `xt_products_price_group_7` (
>  `id` int(11) NOT NULL AUTO_INCREMENT,
>  `products_id` int(11) NOT NULL,
>  `discount_quantity` int(11) DEFAULT NULL,
>  `price` decimal(15,4) DEFAULT NULL,
>  PRIMARY KEY (`id`),
>  KEY `products_id` (`products_id`)
>) ENGINE=MyISAM AUTO_INCREMENT=4147 DEFAULT CHARSET=utf8;
>
>CREATE TABLE `xt_products_price_group_8` (
>  `id` int(11) NOT NULL AUTO_INCREMENT,
>  `products_id` int(11) NOT NULL,
>  `discount_quantity` int(11) DEFAULT NULL,
>  `price` decimal(15,4) DEFAULT NULL,
>  PRIMARY KEY (`id`),
>  KEY `products_id` (`products_id`)
>) ENGINE=MyISAM AUTO_INCREMENT=4147 DEFAULT CHARSET=utf8;
>
>
>DELIMITER $$
>
>CREATE TRIGGER price_insert AFTER INSERT ON xt_products_price_group_3
>FOR EACH ROW BEGIN
>  INSERT INTO xt_products_price_group_5 (id,products_id,discount_quantity,price) VALUES (NEW.id,NEW.products_id,NEW.discount_quantity,NEW.price);
>  INSERT INTO xt_products_price_group_6 (id,products_id,discount_quantity,price) VALUES (NEW.id,NEW.products_id,NEW.discount_quantity,NEW.price);
>  INSERT INTO xt_products_price_group_7 (id,products_id,discount_quantity,price) VALUES (NEW.id,NEW.products_id,NEW.discount_quantity,NEW.price);
>  INSERT INTO xt_products_price_group_8 (id,products_id,discount_quantity,price) VALUES (NEW.id,NEW.products_id,NEW.discount_quantity,NEW.price);
>END$$
>
>CREATE TRIGGER price_delete AFTER DELETE ON xt_products_price_group_3
>FOR EACH ROW BEGIN
>  DELETE FROM xt_products_price_group_5 WHERE id=OLD.id;
>  DELETE FROM xt_products_price_group_6 WHERE id=OLD.id;
>  DELETE FROM xt_products_price_group_7 WHERE id=OLD.id;
>  DELETE FROM xt_products_price_group_8 WHERE id=OLD.id;
>END$$
>
>CREATE TRIGGER price_update AFTER UPDATE ON xt_products_price_group_3
>FOR EACH ROW BEGIN
>  DELETE FROM xt_products_price_group_5 WHERE id=OLD.id;
>  DELETE FROM xt_products_price_group_6 WHERE id=OLD.id;
>  DELETE FROM xt_products_price_group_7 WHERE id=OLD.id;
>  DELETE FROM xt_products_price_group_8 WHERE id=OLD.id;
>  INSERT INTO xt_products_price_group_5 (id,products_id,discount_quantity,price) VALUES (NEW.id,NEW.products_id,NEW.discount_quantity,NEW.price);
>  INSERT INTO xt_products_price_group_6 (id,products_id,discount_quantity,price) VALUES (NEW.id,NEW.products_id,NEW.discount_quantity,NEW.price);
>  INSERT INTO xt_products_price_group_7 (id,products_id,discount_quantity,price) VALUES (NEW.id,NEW.products_id,NEW.discount_quantity,NEW.price);
>  INSERT INTO xt_products_price_group_8 (id,products_id,discount_quantity,price) VALUES (NEW.id,NEW.products_id,NEW.discount_quantity,NEW.price);
>END$$
>
>DELIMITER ;

Actions: View

Attachments on bug 203600: 161782 | 162021 | 162023 | 162114