film_text table is the only table in
the Sakila sample database that uses the
MyISAM storage engine. This table is
provided to allow for full-text searching of the titles and
descriptions of the films listed in the
film_text table contains the
description columns of the
film table, with the contents of the table
kept in synchrony with the
film table by
means of triggers on the
DELETE operations (see
Section 5.5, “Triggers”).
film_id: A surrogate primary key used
to uniquely identify each film in the table.
title: The title of the film.
description: A short description or
plot summary of the film.
The contents of the
film_text table should
never be modified directly. All changes should be made to the
film table instead.