   INDEX `fk_company_category_idx` (`category_id` ASC) ,
   CONSTRAINT `fk_company_category`
     FOREIGN KEY (`category_id` )
-    REFERENCES `mydb`.`category` (`id` )
+    REFERENCES `category` (`id` )
     ON DELETE NO ACTION
     ON UPDATE NO ACTION)
 ENGINE = InnoDB;
 
 
 -- -----------------------------------------------------
--- Table `mydb`.`location`
+-- Table `location`
 -- -----------------------------------------------------
 CREATE  TABLE IF NOT EXISTS `location` (
   `id` INT NOT NULL AUTO_INCREMENT ,
   `company_id` INT NOT NULL ,
+  `loc_name` VARCHAR(45) NOT NULL,
   `street1` VARCHAR(45) NOT NULL ,
   `street2` VARCHAR(45) NULL ,
   `city` VARCHAR(45) NULL ,

  INDEX `fk_company_has_person_company1_idx` (`company_id` ASC) ,
  CONSTRAINT `fk_company_has_person_company1`
    FOREIGN KEY (`company_id` )
    REFERENCES `mydb`.`company` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_company_has_person_person1`
    FOREIGN KEY (`person_id` )
    REFERENCES `mydb`.`person` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

  INDEX `fk_location_has_service_location1_idx` (`location_id` ASC) ,
  CONSTRAINT `fk_location_has_service_location1`
    FOREIGN KEY (`location_id` )
    REFERENCES `location` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_location_has_service_service1`
    FOREIGN KEY (`service_id` )
    REFERENCES `service` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `service_watch`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `service_watch` (
  `service_location_id` INT NOT NULL ,
