The 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 table.

The film_text table contains the film_id, title and 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 film table's INSERT, UPDATE and DELETE operations (see Section 5.5, “Triggers”).

Columns

The contents of the film_text table should never be modified directly. All changes should be made to the film table instead.