-- MySQL Workbench Synchronization
-- Generated: 2015-04-25 23:51
-- Model: Talibro DB Models
-- Version: 1.1
-- Project: Talibro Accounting
-- Author: sherzodr@gmail.com

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

DELIMITER //

DROP TRIGGER IF EXISTS `talibro`.`invoice_BEFORE_UPDATE` //

CREATE DEFINER = CURRENT_USER TRIGGER `talibro`.`invoice_BEFORE_UPDATE` BEFORE UPDATE ON `invoice` FOR EACH ROW
BEGIN
    IF (OLD.type = "sale") THEN
        DELETE FROM `transaction` WHERE company=NEW.company AND object_id=NEW.id AND form_name="invoice";
    ELSE
        DELETE FROM `transaction` WHERE company=NEW.company AND object_id=NEW.id AND form_name="credit note";
    END IF;
END;

/* this is the comment */

//


DROP TRIGGER IF EXISTS `talibro`.`invoice_BEFORE_DELETE` //



DELIMITER ;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;