trigger.sql

LOCK TABLES lovecall WRITE, dropdb WRITE;

DROP TRIGGER lovecall_counter;

DELIMITER |

CREATE TRIGGER lovecall_counter AFTER INSERT  ON lovecall FOR EACH ROW
  BEGIN    
    UPDATE counter SET lovecall_count = lovecall_count + 1;
    UPDATE dropdb SET lovecall_count = lovecall_count + 1;
  END;
|

DELIMITER ;

UNLOCK TABLES;