Question: Having problems with my sql schema. here is the schema script, having issues where the word visible Appears on line, 74, 87,100,113 -- MySQL Workbench

Having problems with my sql schema. here is the schema script, having issues where the word "visible" Appears on line, 74, 87,100,113

-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema mymovies -- -----------------------------------------------------

-- ----------------------------------------------------- -- Schema mymovies -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `mymovies` DEFAULT CHARACTER SET latin1 ; USE `mymovies` ;

-- ----------------------------------------------------- -- Table `mymovies`.`tblactors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`tblactors` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `First Name` VARCHAR(45) NOT NULL, `Last Name` VARCHAR(45) NOT NULL, `Gender` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 42 DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`tbldirectors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`tbldirectors` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `First Name` VARCHAR(45) NOT NULL, `Last Name` VARCHAR(45) NOT NULL, `Gender` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 15 DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`tblgenre` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`tblgenre` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `Genre` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 15 DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`tblmovies` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`tblmovies` ( `Film_Id` INT(11) NOT NULL, `Title` VARCHAR(45) NOT NULL, `DateOfRelease` DATE NOT NULL, `Genre` VARCHAR(45) NOT NULL, `Directors` VARCHAR(45) NOT NULL, `Rated` VARCHAR(45) NOT NULL, `Studio` VARCHAR(45) NOT NULL, `Format` VARCHAR(45) NOT NULL, `Running Time` VARCHAR(45) NOT NULL, PRIMARY KEY (`Film_Id`), UNIQUE INDEX `Film_Id_UNIQUE` (`Film_Id` ASC) VISIBLE) ENGINE = MyISAM AUTO_INCREMENT = 14 DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`movies_actors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`movies_actors` ( `tblmovies_Film_Id` INT(11) NOT NULL, `tblactors_id` INT(11) NOT NULL, PRIMARY KEY (`tblmovies_Film_Id`, `tblactors_id`), INDEX `fk_tblmovies_has_tblactors_tblactors1_idx` (`tblactors_id` ASC) VISIBLE, INDEX `fk_tblmovies_has_tblactors_tblmovies_idx` (`tblmovies_Film_Id` ASC) VISIBLE) ENGINE = MyISAM DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`movies_directors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`movies_directors` ( `tblmovies_Film_Id` INT(11) NOT NULL, `tbldirectors_id` INT(11) NOT NULL, PRIMARY KEY (`tblmovies_Film_Id`, `tbldirectors_id`), INDEX `fk_tblmovies_has_tbldirectors_tbldirectors1_idx` (`tbldirectors_id` ASC) VISIBLE, INDEX `fk_tblmovies_has_tbldirectors_tblmovies1_idx` (`tblmovies_Film_Id` ASC) VISIBLE) ENGINE = MyISAM DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`movies_genres` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`movies_genres` ( `tblmovies_Film_Id` INT(11) NOT NULL, `tblgenre_id` INT(11) NOT NULL, PRIMARY KEY (`tblmovies_Film_Id`, `tblgenre_id`), INDEX `fk_tblmovies_has_tblgenre_tblgenre1_idx` (`tblgenre_id` ASC) VISIBLE, INDEX `fk_tblmovies_has_tblgenre_tblmovies1_idx` (`tblmovies_Film_Id` ASC) VISIBLE) ENGINE = MyISAM DEFAULT CHARACTER SET = latin1;

SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!