   INDEX `fk_acos_has_aros_aros` (`aro_id` ASC) ,
   CONSTRAINT `fk_acos_has_aros_acos`
     FOREIGN KEY (`aco_id` )
-    REFERENCES `phpconf`.`acos` (`id` )
+    REFERENCES `cfp`.`acos` (`id` )
     ON DELETE NO ACTION
     ON UPDATE NO ACTION,
   CONSTRAINT `fk_acos_has_aros_aros`
     FOREIGN KEY (`aro_id` )
-    REFERENCES `phpconf`.`aros` (`id` )
-    ON DELETE NO ACTION
-    ON UPDATE NO ACTION)
-ENGINE = InnoDB;
-
-
--- -----------------------------------------------------
--- Table `phpconf`.`i18n`
--- -----------------------------------------------------
-CREATE  TABLE IF NOT EXISTS `phpconf`.`i18n` (
+    REFERENCES `cfp`.`aros` (`id` )
+    ON DELETE NO ACTION
+    ON UPDATE NO ACTION)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `cfp`.`i18n`
+-- -----------------------------------------------------
+CREATE  TABLE IF NOT EXISTS `cfp`.`i18n` (
   `id` INT NOT NULL AUTO_INCREMENT ,
   `locale` VARCHAR(6) NOT NULL ,
   `model` VARCHAR(255) NOT NULL ,

  INDEX `fk_acos_acos1` (`parent_id` ASC) ,
  CONSTRAINT `fk_aros_aros`
    FOREIGN KEY (`parent_id` )
    REFERENCES `phpconf`.`aros` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `phpconf`.`acos_aros`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `phpconf`.`acos_aros` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `aco_id` INT NOT NULL ,
  `aro_id` INT NOT NULL ,

  INDEX `fk_speakers_users` (`user_id` ASC) ,
  CONSTRAINT `fk_speakers_users`
    FOREIGN KEY (`user_id` )
    REFERENCES `cfp`.`users` (`id` )
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `cfp`.`areas`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `cfp`.`areas` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(100) NOT NULL ,
  PRIMARY KEY (`id`) )
