UPDATE document a
    INNER JOIN workshift b 
        ON a.workshiftid = b.workshiftid 
    SET a.identifier=b.shiftnum

UPDATE document,workshift SET document.identifier=workshift.shiftnum
WHERE document.workshiftid = workshift.workshiftid;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `triggerAfterUpdate` AFTER UPDATE ON `document`
FOR EACH ROW BEGIN
    SET @oldfactor:=(SELECT moneyfactor FROM documenttype WHERE doctype = old.doctype);
    SET @newfactor:=(SELECT moneyfactor FROM documenttype WHERE doctype = new.doctype);
    SET @oldsumb=0;
    SET @oldsumcash=0;
    SET @newsumb=0;
    SET @newsumcash=0;

    IF old.closed = 1
    THEN
       SET @oldsumb=old.sumb;
       SET @oldsumcash=@oldfactor * old.sumcash;
    END IF;
    
    IF new.closed = 1 
    THEN
       SET @newsumb=new.sumb;
       SET @newsumcash=@newfactor * new.sumcash;
    END IF;

    UPDATE workshift 
    SET sumsale = COALESCE(sumsale, 0) + IF(new.doctype = 1, -@oldsumb + @newsumb, 0),
        sumgain = COALESCE(sumgain, 0) + IF(new.doctype IN (1, 2, 25), -@oldsumb + @newsumb, 0),
        sumdrawer = COALESCE(sumdrawer, 0) - @oldsumcash + @newsumcash
    WHERE workshiftid = new.workshiftid;
END */;;
DELIMITER ;     

drop trigger IF EXISTS triggerAfterUpdate;
        
SET @shopnumber='100100001';
SET @cashnumber='1001000014';

UPDATE document,workshift SET document.identifier=CONCAT(
    @shopnumber,
    @cashnumber,
    RIGHT(CONCAT("0000",workshift.shiftnum),4),
    RIGHT(CONCAT("0000000",document.checknum),7)), document.cashcode=@cashnumber
WHERE document.workshiftid = workshift.workshiftid;

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `triggerAfterUpdate` AFTER UPDATE ON `document`
FOR EACH ROW BEGIN
    SET @oldfactor:=(SELECT moneyfactor FROM documenttype WHERE doctype = old.doctype);
    SET @newfactor:=(SELECT moneyfactor FROM documenttype WHERE doctype = new.doctype);
    SET @oldsumb=0;
    SET @oldsumcash=0;
    SET @newsumb=0;
    SET @newsumcash=0;

    IF old.closed = 1
    THEN
       SET @oldsumb=old.sumb;
       SET @oldsumcash=@oldfactor * old.sumcash;
    END IF;

    IF new.closed = 1
    THEN
       SET @newsumb=new.sumb;
       SET @newsumcash=@newfactor * new.sumcash;
    END IF;

    UPDATE workshift
    SET sumsale = COALESCE(sumsale, 0) + IF(new.doctype = 1, -@oldsumb + @newsumb, 0),
        sumgain = COALESCE(sumgain, 0) + IF(new.doctype IN (1, 2, 25), -@oldsumb + @newsumb, 0),
        sumdrawer = COALESCE(sumdrawer, 0) - @oldsumcash + @newsumcash
    WHERE workshiftid = new.workshiftid;
END */;;
DELIMITER ;