ddmitov

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;

ddmitov

#!/usr/bin/env bash

# Welcome message:
echo " "
echo "Opera Session Converter, v.0.1."
echo "Will convert all your Opera session files in the current folder to"
echo "plain text files with URLs only."
echo "Old files will be preserved and new files with"
echo "a .win.txt extension will be created."
echo "Input files must be without spaces!"