Ok Update: I managed to get it to work. it works perfectly now. The problem was that in my data.sql file where my inserts are, the order of insertions were wrong! Thus the trigger didnt activate. now that i corrected it, both triggers work! Thank you all for your time and help! much appreciated.