Triggers

SET 
  NEW.create_date = NOW()

BEGIN INSERT INTO film_text (film_id, title, description) 
VALUES 
  (
    new.film_id, new.title, new.description
  ); END

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

BEGIN 
DELETE FROM 
  film_text 
WHERE 
  film_id = old.film_id; END

SET 
  NEW.payment_date = NOW()

SET 
  NEW.rental_date = NOW()