DELIMITER // 
DROP FUNCTION  IF EXISTS `editBuhRas`//
CREATE FUNCTION `editBuhRas` (name VARCHAR(255), col INT, oldtext VARCHAR(255), newtext VARCHAR(255), idc INT, month INT, year INT, user INT, ra1 INT) RETURNS VARCHAR(255) NON DETERMINISTIC
BEGIN

        IF col=2 THEN
            UPDATE `buhras` SET `name`=newtext WHERE `id`=idc; 
        END IF;
        IF col=3 THEN 
            UPDATE `buhras` SET `otdnal`=newtext WHERE `id`=idc;
        END IF;
        IF col=4 THEN 
            UPDATE `buhras` SET `otdbnal`=newtext WHERE `id`=idc;
        END IF;
        IF col=5 THEN 
            UPDATE `buhras` SET `dol`=newtext WHERE `id`=idc; 
        END IF;
        IF col=6 THEN 
            UPDATE `buhras` SET `prognoz`=newtext WHERE `id`=idc; 
        END IF;
        IF col=7 THEN 
            UPDATE `buhras` SET `date`=newtext WHERE `id`=idc; 
        END IF;
        IF col=8 THEN 
            UPDATE `buhras` SET `comment`=newtext WHERE `id`=idc;
        END IF;    
    
    INSERT INTO `buhlog`(`user`, `table`, `action`, `name`, `column`, `oldtext`, `newtext`, `date`, `time`, `id`, `month`, `year`, `ra`) VALUES 
    (user,2,2,name,col,oldtext,newtext, CONCAT(YEAR(adddate(NOW(), INTERVAL 2 HOUR)),"-",MONTH(adddate(NOW(), INTERVAL 2 HOUR)),"-",DAYOFMONTH(adddate(NOW(), INTERVAL 2 HOUR))),addtime(CURRENT_TIME, '2:00:00.000000'),NULL, month, year, ra1);
    RETURN 'ok';
END//