Name |
Owner |
Action Timing |
Event Manipulation |
Body |
Table Name |
ins_film
|
DEFINER
|
AFTER
|
INSERT
|
BEGIN
INSERT INTO film_text (film_id, title, description)
VALUES (new.film_id, new.title, new.description);
END
|
film
|
upd_film
|
DEFINER
|
AFTER
|
UPDATE
|
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
|
film
|
del_film
|
DEFINER
|
AFTER
|
DELETE
|
BEGIN
DELETE FROM film_text WHERE film_id = old.film_id;
END
|
film
|