MEL Specify schema browser

DROP TRIGGER IF EXISTS preparation_before_insert;
 
DELIMITER $$
 
CREATE TRIGGER preparation_before_insert BEFORE INSERT ON preparation
FOR EACH ROW
  BEGIN
    DECLARE new_number VARCHAR(32);
    IF isnull(@DISABLE_TRIGGER) THEN
      IF NEW.PrepTypeID=2 THEN 
        IF NEW.SampleNumber IS NULL THEN
            SELECT MAX(CAST(SampleNumber AS UNSIGNED))+1
            INTO new_number
            FROM preparation
            WHERE PrepTypeID=2;
        ELSE
            SET new_number=NEW.SampleNumber;
        END IF;
 
      ELSEIF NEW.PrepTypeID=6 THEN 
        IF NEW.SampleNumber IS NULL THEN
            SELECT MAX(CAST(SampleNumber AS UNSIGNED))+1
            INTO new_number
            FROM preparation
            WHERE PrepTypeID=6;
        ELSE
            SET new_number=NEW.SampleNumber;
        END IF;
 
      ELSEIF NEW.PrepTypeID=7 THEN  
        SELECT MAX(CAST(SampleNumber AS UNSIGNED))+1
        INTO new_number
        FROM preparation
        WHERE PrepTypeID=7;
 
      ELSEIF NEW.PrepTypeID=18 THEN 
        SELECT IF(MAX(SampleNumber) IS NOT NULL, MAX(SampleNumber)+1, 1)
        INTO new_number
        FROM preparation
        WHERE PrepTypeID=18;
 
        SET new_number=LPAD(new_number, 6, '0');
 
      ELSEIF NEW.PrepTypeID=14 THEN 
        SELECT IF(MAX(SampleNumber) IS NOT NULL, MAX(SampleNumber)+1, 1)
        INTO new_number
        FROM preparation
        WHERE PrepTypeID=14;
 
        SELECT IF(MAX(CatalogNumber)>new_number, MAX(CatalogNumber)+1, new_number)
        INTO new_number
        FROM collectionobject
        WHERE CollectionID=294912;
 
        SET new_number=lpad(new_number, 7, '0');
 
      ELSEIF NEW.PrepTypeID=155 THEN 
        SELECT IF(MAX(SampleNumber) IS NOT NULL, MAX(CAST(SampleNumber AS UNSIGNED))+1, 1)
        INTO new_number
        FROM preparation
        WHERE PrepTypeID=155;
 
      ELSE
        SET new_number=NEW.SampleNumber;
 
      END IF;
 
      SET NEW.SampleNumber=new_number;
 
    END IF;
  END
 
DELIMITER ;

DROP TRIGGER IF EXISTS preparation_before_update;
 
DELIMITER $$
 
CREATE TRIGGER preparation_before_update BEFORE UPDATE ON preparation
FOR EACH ROW
  BEGIN
    DECLARE new_number VARCHAR(32);
 
    IF isnull(@DISABLE_TRIGGER) THEN
      IF NEW.PrepTypeID=18 AND OLD.PrepTypeID=24 AND NEW.SampleNumber IS NULL AND OLD.SampleNumber IS NULL THEN 
        IF NEW.SampleNumber IS NULL THEN
          SELECT IF(MAX(SampleNumber) IS NOT NULL, MAX(SampleNumber)+1, 1)
          INTO new_number
          FROM preparation
          WHERE PrepTypeID=18;
 
          SET NEW.SampleNumber = LPAD(new_number, 6, '0');
        END IF;
      END IF;
    END IF;
  END
 
DELIMITER ;