--

-- Table structure for table `film_text`

--

-- InnoDB added FULLTEXT support in 5.6.10. If you use an

-- earlier version, then consider upgrading (recommended) or

-- changing InnoDB to MyISAM as the film_text engine

--

CREATE TABLE film_text (

  film_id SMALLINT NOT NULL,

  title VARCHAR(255) NOT NULL,

  description TEXT,

  PRIMARY KEY  (film_id),

  FULLTEXT KEY idx_title_description (title,description)

)ENGINE=InnoDB DEFAULT CHARSET=utf8;

--

-- Table structure for table `film_text`

--

-- InnoDB added FULLTEXT support in 5.6.10. If you use an

-- earlier version, then consider upgrading (recommended) or

-- changing InnoDB to MyISAM as the film_text engine

--

CREATE TABLE film_text (

  film_id SMALLINT NOT NULL,

  title VARCHAR(255) NOT NULL,

  description TEXT,

  PRIMARY KEY  (film_id),

  FULLTEXT KEY idx_title_description (title,description)

)ENGINE=MyISAM DEFAULT CHARSET=utf8;