Example SQLite triggers

sqlite-triggers.sql

CREATE TRIGGER calculate_vat_new AFTER INSERT ON inventory 
  BEGIN
    UPDATE inventory SET PRICE_VAT = new.PRICE/100*20+new.PRICE WHERE id = new.id;
  END;

CREATE TRIGGER calculate_vat UPDATE OF PRICE ON inventory 
  BEGIN
    UPDATE inventory SET PRICE_VAT = new.PRICE/100*20+new.PRICE WHERE id = old.id;
  END;