Triggers

Name upd_film
Owner DEFINER
Action Timing AFTER
Event Manipulation UPDATE
Body BEGIN IF (old.title != new.title) OR (old.description != new.description) OR (old.film_id != new.film_id) THEN UPDATE film_text SET title=new.title, description=new.description, film_id=new.film_id WHERE film_id=old.film_id; END IF; END
Table Name film