CREATE TABLE IF NOT EXISTS `0in_stock` (
  `id_0in_stock` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(10) unsigned NOT NULL,
  `id_product_attribute` int(10) unsigned DEFAULT NULL,

  PRIMARY KEY (`id_0in_stock`),
  KEY `key_product` (`id_product`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `minus_in_stock` (
  `id_minus_in_stock` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(10) unsigned NOT NULL,
  `id_product_attribute` int(10) unsigned DEFAULT NULL,
  `difQq` int(10) unsigned NOT NULL,

  PRIMARY KEY (`id_minus_in_stock`),
  KEY `key_product` (`id_product`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

DROP TRIGGER IF EXISTS  `ВАША БАЗА ДАНЫХ!`.`after_insert_ps_orders`;

DELIMITER $$
CREATE TRIGGER `after_insert_ps_orders` after insert ON `ps_orders`
FOR EACH ROW BEGIN

insert 0in_stock (id_product,id_product_attribute)
select distinct id_product, case when id_product_attribute<>0 then id_product_attribute end
from ps_cart_product
where (ps_cart_product.id_cart=NEW.`id_cart`)and
      (
       (
        (ps_cart_product.id_product_attribute=0)and
        (ps_cart_product.quantity=(select quantity from ps_product where id_product=ps_cart_product.id_product))
       )

      or
       (
        (ps_cart_product.id_product_attribute<>0)and
        (ps_cart_product.quantity=(select quantity from  ps_product_attribute where (id_product=ps_cart_product.id_product)
                                                 and (id_product_attribute=ps_cart_product.id_product_attribute) ))
       )
      );


insert minus_in_stock (id_product,id_product_attribute,difQq)
select distinct id_product,

case when (id_product_attribute<>0) then id_product_attribute end,
case when (ps_cart_product.id_product_attribute=0) then
ps_cart_product.quantity-(select quantity from ps_product where id_product=ps_cart_product.id_product)
else
ps_cart_product.quantity-(select quantity from  ps_product_attribute where (id_product=ps_cart_product.id_product)
                                                  and (id_product_attribute=ps_cart_product.id_product_attribute)) end

from ps_cart_product
where (ps_cart_product.id_cart=NEW.`id_cart`)and
      (
       (
        (ps_cart_product.id_product_attribute=0)and
        (ps_cart_product.quantity>(select quantity from ps_product where id_product=ps_cart_product.id_product) )
       )
      or
       (
        (ps_cart_product.id_product_attribute<>0)and
        (ps_cart_product.quantity>(select quantity from  ps_product_attribute where (id_product=ps_cart_product.id_product)
                                                 and (id_product_attribute=ps_cart_product.id_product_attribute) ))
       )
      );


END;
$$

DELIMITER;