Форум пользователей MySQL

CREATE TABLE `bd_tema` (
  `ID_TEMA` int(11) NOT NULL auto_increment,
  `PARENT` int(11) NOT NULL default '0',
  `LINE` tinytext NOT NULL,
  `CODE` varchar(100) NOT NULL default '',
  `lb` int(11) NOT NULL,
  `rb` int(11) NOT NULL,
  PRIMARY KEY  (`ID_TEMA`),
  FOREIGN KEY (`PARENT`) REFERENCES bd_tema (`ID_TEMA`)
    ON UPDATE CASCADE
    ON DELETE CASCADE,
  CHECK (lb <= rb)
);
CREATE FUNCTION EL_TEMA (
  pparent INTEGER,
  DELTA INTEGER,
  LB2 INTEGER,
  RB2 INTEGER)
RETURNS INTEGER
BEGIN
  DECLARE  R INTEGER;
  DECLARE  L INTEGER;
  DECLARE  R2 INTEGER;
  DECLARE  MKey INTEGER;
  DECLARE  MultiDelta INTEGER;

  SELECT t.rb, t.lb
    INTO R, L
  FROM bd_tema t
  WHERE ID_TEMA= pparent;
 
  SET R2 = NULL;
  SELECT MAX(rb) INTO R2 FROM bd_tema WHERE PARENT = pparent;
 
  IF R2 IS NULL THEN
    SET R2 = L;
  END IF;

 
  IF R - R2 < Delta THEN
    BEGIN
        SET MultiDelta = R - L + 100;
     
        IF (Delta > MultiDelta) THEN
          SET MultiDelta = Delta;
        END IF;

        IF (LB2 > -1) THEN
          UPDATE bd_tema SET rb = rb + MultiDelta
          WHERE lb <= L AND rb >= R
            AND NOT (lb >= LB2 AND rb <= RB2);
        ELSE
          UPDATE bd_tema SET rb = rb + MultiDelta
          WHERE lb <= L AND rb >= R;
        END IF;

        IF (LB2 > -1) THEN
          UPDATE bd_tema
            SET lb = lb + MultiDelta,
            rb = rb + MultiDelta
            WHERE lb > R
              AND NOT (lb >= LB2 AND rb <= RB2);
        ELSE
          UPDATE bd_tema
            SET lb = lb + MultiDelta,
            rb = rb + MultiDelta
            WHERE lb > R;
        END IF;
    END;
  END IF;
 
  RETURN R2 + 1;
END;