title: Tables are empty set in MySQL
body: <p>I used MySQL Workbench to generate a database and now I inserted it into the command-line client using:</p>
  
  <blockquote>
    <p>mysql> . C:\Documents and
    Settings\kdegroote\My
    Documents\School\2008-2009\ICT2
    \Gegevensbanken\Labo\Hoofdstuk 3 oef
    6\pizzasecondtry.sql</p>
  </blockquote>
  
  <p>For some reason, the last table won't be accepted. "Cannot create table" is the error message.</p>
  
  <p>I manually editted the data to basically be the same, just without the special options Workbench adds to it and it worked like that.</p>
  
  <p>I've been studying the original but I don't understand why it won't show me the tables.
  So I was wondering if anybody here could have a look at it. Maybe someone else will see what I'm overlooking.</p>
  
  <pre><code>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';
  
  CREATE SCHEMA IF NOT EXISTS `PizzaDelivery` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  USE `PizzaDelivery`;
  
  
  CREATE TABLE IF NOT EXISTS `PizzaDelivery`.`Visitors` (
    `visitor_id` INT NOT NULL AUTO_INCREMENT ,
    `name` VARCHAR(45) NOT NULL ,
    `adres` VARCHAR(45) NOT NULL ,
    `telephone` MEDIUMBLOB NOT NULL ,
    `email` VARCHAR(45) NOT NULL ,
    PRIMARY KEY (`visitor_id`))ENGINE=InnoDB;
  
  
  CREATE TABLE IF NOT EXISTS `PizzaDelivery`.`Employees` (
    `employee_id` INT NOT NULL AUTO_INCREMENT ,
    `name` VARCHAR(45) NOT NULL ,
    PRIMARY KEY (`employee_id`))ENGINE=InnoDB;
  
  
  CREATE TABLE IF NOT EXISTS `PizzaDelivery`.`Orders` (
    `order_id` INT NOT NULL AUTO_INCREMENT ,
    `pizza` VARCHAR(45) NOT NULL ,
    `extra` VARCHAR(45) NULL ,
    `kind` VARCHAR(45) NOT NULL ,
    `amount` VARCHAR(45) NOT NULL ,
    `visitor_id` INT NOT NULL ,
    `employee_id` INT NOT NULL ,
    `order_time` TIME NOT NULL ,
    PRIMARY KEY (`order_id`) ,
    INDEX `visitor_id` (`visitor_id` ASC) ,
    INDEX `employee_id` (`employee_id` ASC) ,
    CONSTRAINT `visitor_id`
      FOREIGN KEY (`visitor_id` )
      REFERENCES `PizzaDelivery`.`Visitors` (`visitor_id` )
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    CONSTRAINT `employee_id`
      FOREIGN KEY (`employee_id` )
      REFERENCES `PizzaDelivery`.`Employees` (`employee_id` )
      ON DELETE NO ACTION
      ON UPDATE NO ACTION)ENGINE=InnoDB;
  
  
  CREATE TABLE IF NOT EXISTS `PizzaDelivery`.`Deliveries` (
    `employee_id` INT NOT NULL ,
    `order_id` INT NOT NULL ,
    `voertuig_id` INT NOT NULL ,
    `deliverytime` TIME NOT NULL ,
    PRIMARY KEY (`employee_id`, `order_id`) ,
    INDEX `employee_id` (`employee_id` ASC) ,
    INDEX `order_id` (`order_id` ASC) ,
    CONSTRAINT `employee_id`
      FOREIGN KEY (`employee_id` )
      REFERENCES `PizzaDelivery`.`Employees` (`employee_id` )
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    CONSTRAINT `order_id`
      FOREIGN KEY (`order_id` )
      REFERENCES `PizzaDelivery`.`Orders` (`order_id` )
      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;
  </code></pre>