in Forward Engineering i have error called table does not exist

this is my forward engineering code

-- 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='TRADITIONAL,ALLOW_INVALID_DATES';

---

-- Schema GymDB

---

---

-- Schema GymDB

---

CREATE SCHEMA IF NOT EXISTS GymDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; USE GymDB ;

---

-- Table GymDB.Staff

---

CREATE TABLE IF NOT EXISTS GymDB.Staff ( Staff_ID INT NOT NULL, Staff_FName VARCHAR(45) NOT NULL, Staff_LName VARCHAR(45) NOT NULL, PRIMARY KEY (Staff_ID)) ENGINE = InnoDB;

---

-- Table GymDB.Trainers

---

CREATE TABLE IF NOT EXISTS GymDB.Trainers ( T_ID INT NOT NULL, T_FName VARCHAR(45) NOT NULL, T_LName VARCHAR(45) NOT NULL, T_Certification VARCHAR(45) NOT NULL, Staff_ID INT NOT NULL, PRIMARY KEY (T_ID, Staff_ID), INDEX fk_Trainers_Staff1_idx (Staff_ID ASC), CONSTRAINT fk_Trainers_Staff1 FOREIGN KEY (Staff_ID) REFERENCES GymDB.Staff (Staff_ID) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;

---

-- Table GymDB.Facility

---

CREATE TABLE IF NOT EXISTS GymDB.Facility ( F_Num VARCHAR(2) NOT NULL, F_Condition VARCHAR(45) NOT NULL, PRIMARY KEY (F_Num)) ENGINE = InnoDB;

---

-- Table GymDB.Class

---

CREATE TABLE IF NOT EXISTS GymDB.Class ( C_NUM INT NOT NULL, C_Date DATE NOT NULL, C_Cost DOUBLE NOT NULL, C_Time TIME(4) NOT NULL, T_ID INT NOT NULL, F_Num VARCHAR(2) NOT NULL, PRIMARY KEY (C_NUM, T_ID, F_Num), INDEX fk_Class_Trainers1_idx (T_ID ASC), INDEX fk_Class_Facility1_idx (F_Num ASC), CONSTRAINT fk_Class_Trainers1 FOREIGN KEY (T_ID) REFERENCES GymDB.Trainers (T_ID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Class_Facility1 FOREIGN KEY (F_Num) REFERENCES GymDB.Facility (F_Num) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;

---

-- Table GymDB.Membership

---

CREATE TABLE IF NOT EXISTS GymDB.Membership ( MS_ID INT NOT NULL, Date_Created DATE NOT NULL, MS_Length VARCHAR(45) NOT NULL, Exp_Date DATE NOT NULL, PRIMARY KEY (MS_ID)) ENGINE = InnoDB;

---

-- Table GymDB.Memeber

---

CREATE TABLE IF NOT EXISTS GymDB.Memeber ( M_ID INT(11) NOT NULL, M_FName VARCHAR(45) NOT NULL, M_LName VARCHAR(45) NOT NULL, M_Gender VARCHAR(45) NOT NULL, M_PNum BIGINT(20) NOT NULL, M_Address VARCHAR(45) NOT NULL, M_MedHistory VARCHAR(45) NOT NULL, Date_Joined DATE NOT NULL, M_Height MEDIUMINT(9) NOT NULL, M_Weight MEDIUMINT(9) NOT NULL, MS_ID INT NOT NULL, PRIMARY KEY (M_ID, MS_ID), INDEX fk_Memeber_Membership1_idx (MS_ID ASC), CONSTRAINT fk_Memeber_Membership1 FOREIGN KEY (MS_ID) REFERENCES GymDB.Membership (MS_ID) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;

---

-- Table GymDB.Update

---

CREATE TABLE IF NOT EXISTS GymDB.Update ( U_SEQ INT NOT NULL AUTO_INCREMENT, Recent VARCHAR(45) NOT NULL, M_ID INT(11) NOT NULL, T_ID INT NOT NULL, PRIMARY KEY (U_SEQ, M_ID, T_ID), INDEX fk_Update_Memeber1_idx (M_ID ASC), INDEX fk_Update_Trainers1_idx (T_ID ASC), CONSTRAINT fk_Update_Memeber1 FOREIGN KEY (M_ID) REFERENCES GymDB.Memeber (M_ID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Update_Trainers1 FOREIGN KEY (T_ID) REFERENCES GymDB.Trainers (T_ID) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;

---

-- Table GymDB.Equipment

---

CREATE TABLE IF NOT EXISTS GymDB.Equipment ( EQ_Num INT NOT NULL, EQ_Condition VARCHAR(45) NOT NULL, EQ_Type VARCHAR(45) NOT NULL, PRIMARY KEY (EQ_Num)) ENGINE = InnoDB;

---

-- Table GymDB.Class_has_Memeber

---

CREATE TABLE IF NOT EXISTS GymDB.Class_has_Memeber ( C_NUM INT NOT NULL, M_ID INT(11) NOT NULL, PRIMARY KEY (C_NUM, M_ID), INDEX fk_Class_has_Memeber_Memeber1_idx (M_ID ASC), INDEX fk_Class_has_Memeber_Class_idx (C_NUM ASC), CONSTRAINT fk_Class_has_Memeber_Class FOREIGN KEY (C_NUM) REFERENCES GymDB.Class (C_NUM) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Class_has_Memeber_Memeber1 FOREIGN KEY (M_ID) REFERENCES GymDB.Memeber (M_ID) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;

---

-- Table GymDB.Memeber_has_Equipment

---

CREATE TABLE IF NOT EXISTS GymDB.Memeber_has_Equipment ( M_ID INT(11) NOT NULL, MS_ID INT NOT NULL, EQ_Num INT NOT NULL, PRIMARY KEY (M_ID, MS_ID, EQ_Num), INDEX fk_Memeber_has_Equipment_Equipment1_idx (EQ_Num ASC), INDEX fk_Memeber_has_Equipment_Memeber1_idx (M_ID ASC, MS_ID ASC), CONSTRAINT fk_Memeber_has_Equipment_Memeber1 FOREIGN KEY (M_ID , MS_ID) REFERENCES GymDB.Memeber (M_ID , MS_ID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Memeber_has_Equipment_Equipment1 FOREIGN KEY (EQ_Num) REFERENCES GymDB.Equipment (EQ_Num) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;

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

and This is the error .. what to do? I need HELP!

Executing SQL script in server ERROR: Error 1146: Table 'gymdb.staff' doesn't exist SQL Code: -- ----------------------------------------------------- -- Table GymDB.Staff -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS GymDB.Staff ( Staff_ID INT NOT NULL, Staff_FName VARCHAR(45) NOT NULL, Staff_LName VARCHAR(45) NOT NULL, PRIMARY KEY (Staff_ID)) ENGINE = InnoDB

SQL script execution finished: statements: 5 succeeded, 1 failed

Fetching back view definitions in final form. Nothing to fetch