esskimos

CREATE TRIGGER maintable_pricetable_sum_tr
         AFTER INSERT
            ON maintable_pricetable
      FOR EACH ROW
BEGIN
    UPDATE maintable_pricetable
       SET outcome = (NEW.transparency + NEW.color + NEW.pis + NEW.purity + NEW.intensity + NEW.typicality + NEW.purity2 + NEW.intensity2 + NEW.persistence + NEW.typicality2 + NEW.harmony) 
     WHERE id = NEW.id;
END;