Triggers

There are 3 triggers defined in the Sakila database. The following describes each triggers.

customer_create_date

The customer_create_date trigger sets the create_date column of the customer table to the current time and date as rows are inserted.

payment_date

The payment_date trigger sets the payment_date column of the payment table to the current time and date as rows are inserted.

rental_date

The rental_date trigger sets the rental_date column of the rental table to the current time and date as rows are inserted.

ins_film

The ins_film trigger duplicates all INSERT operations on the film table to the film_text table.

upd_film

The upd_film trigger duplicates all UPDATE operations on the film table to the film_text table.

del_film

The del_film trigger duplicates all DELETE operations on the film table to the film_text table.