customer::customer_create_date [INSERT/ROW/BEFORE] - 1 1
- SET NEW.create_date = NOW()
|
customer::customer_create_date [INSERT/ROW/BEFORE] - 1 1
- SET NEW.create_date = NOW()
|
film::del_film [DELETE/ROW/AFTER] - 1 1
- BEGIN
DELETE FROM film_text WHERE film_id = old.film_id;
END
|
film::del_film [DELETE/ROW/AFTER] - 1 1
- BEGIN
DELETE FROM film_text WHERE film_id = old.film_id;
END
|
film::ins_film [INSERT/ROW/AFTER] - 1 1
- BEGIN
INSERT INTO film_text (film_id, title, description)
VALUES (new.film_id, new.title, new.description);
END
|
film::ins_film [INSERT/ROW/AFTER] - 1 1
- BEGIN
INSERT INTO film_text (film_id, title, description)
VALUES (new.film_id, new.title, new.description);
END
|
film::upd_film [UPDATE/ROW/AFTER] - 1 1
- 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::upd_film [UPDATE/ROW/AFTER] - 1 1
- 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
|
payment::payment_date [INSERT/ROW/BEFORE] - 1 1
- SET NEW.payment_date = NOW()
|
payment::payment_date [INSERT/ROW/BEFORE] - 1 1
- SET NEW.payment_date = NOW()
|
rental::rental_date [INSERT/ROW/BEFORE] - 1 1
- SET NEW.rental_date = NOW()
|
rental::rental_date [INSERT/ROW/BEFORE] - 1 1
- SET NEW.rental_date = NOW()
|