BEGIN;

-- appstore
CREATE TRIGGER update_lastupdate_trigger BEFORE UPDATE ON appstore FOR EACH ROW EXECUTE PROCEDURE update_lastupdate_column();

-- application
CREATE TRIGGER update_lastupdate_trigger BEFORE UPDATE ON application FOR EACH ROW EXECUTE PROCEDURE update_lastupdate_column();

-- competence
CREATE TRIGGER update_lastupdate_trigger BEFORE UPDATE ON competence FOR EACH ROW EXECUTE PROCEDURE update_lastupdate_column();

-- notificationrole
CREATE TRIGGER update_lastupdate_trigger BEFORE UPDATE ON notificationrole FOR EACH ROW EXECUTE PROCEDURE update_lastupdate_column();

-- contact_competence
CREATE TRIGGER update_lastupdate_trigger BEFORE UPDATE ON contact_competence FOR EACH ROW EXECUTE PROCEDURE update_lastupdate_column();

-- contact_notificationrole
CREATE TRIGGER update_lastupdate_trigger BEFORE UPDATE ON contact_notificationrole FOR EACH ROW EXECUTE PROCEDURE update_lastupdate_column();

-- contact_role
CREATE TRIGGER update_lastupdate_trigger BEFORE UPDATE ON contact_role FOR EACH ROW EXECUTE PROCEDURE update_lastupdate_column();

-- role_application
CREATE TRIGGER update_lastupdate_trigger BEFORE UPDATE ON role_application FOR EACH ROW EXECUTE PROCEDURE update_lastupdate_column();

COMMIT;
