DELIMITR |

CREATE TRIGGER `after_update_customer_deposit`
	AFTER UPDATE ON `customers_deposit`
	FOR EACH ROW 
        	      BEGIN 
	            UPDATE `sisense`.`customer_deposit` SET `amount` = NEW.amount WHERE `id` = NEW.id;
                    END|
DELIMITR;

CREATE TRIGGER `after_update_customer_deposit`
	AFTER UPDATE ON `customers_deposit`
	FOR EACH ROW 
		BEGIN 
			if(OLD.amount != NEW.amount)
			{
			    UPDATE `sisense`.`customer_deposit` SET `amount` = NEW.amount WHERE `id` = NEW.id;
			}
			
			if(OLD.rateUSD != NEW.rateUSD)
			{
			    UPDATE `sisense`.`customer_deposit` SET `rateUSD` = NEW.rateUSD WHERE `id` = NEW.id;
			}
		END|
delimiter ;