v0e8dick

1MySQL 1005 Error - What's wrong with the query?
2-- -----------------------------------------------------
3-- Table `agentes`
4-- -----------------------------------------------------
5CREATE  TABLE IF NOT EXISTS `agentes` (
6  `id` INT(11) NOT NULL AUTO_INCREMENT ,
7  `codAgente` VARCHAR(8) NOT NULL ,
8  `clave` VARCHAR(8) NOT NULL ,
9  `nombre` VARCHAR(50) NOT NULL ,
10  `apellido1` VARCHAR(50) NOT NULL ,
11  `apellido2` VARCHAR(50) NOT NULL ,
12  `email` VARCHAR(100) NOT NULL ,
13  `usuarioDA` VARCHAR(45) NULL ,
14  `passDA` VARCHAR(100) NULL ,
15  PRIMARY KEY (`id`) )
16ENGINE = InnoDB
17COLLATE = latin1_spanish_ci;
18
19-- -----------------------------------------------------
20-- Table `cola`
21-- -----------------------------------------------------
22CREATE  TABLE IF NOT EXISTS `colas` (
23  `idCola` INT NOT NULL AUTO_INCREMENT ,
24  `cliente` INT NOT NULL ,
25  `nombre` VARCHAR(45) NOT NULL ,
26  PRIMARY KEY (`idCola`) ,
27  INDEX `fk_colas_clientes1` (`cliente` ASC) ,
28  CONSTRAINT `fk_colas_clientes1`
29    FOREIGN KEY (`cliente` )
30    REFERENCES `clientes` (`idCliente` )
31    ON DELETE NO ACTION
32    ON UPDATE NO ACTION)
33ENGINE = InnoDB;
34
35
36-- -----------------------------------------------------
37-- Table `relColaExt`
38-- -----------------------------------------------------
39CREATE  TABLE IF NOT EXISTS `relColaExt` (
40  `id` INT NOT NULL AUTO_INCREMENT ,
41  `codAgente` VARCHAR(8) NOT NULL ,
42  `cola` VARCHAR(45) NOT NULL ,
43  `prioridad` INT NOT NULL ,
44  PRIMARY KEY (`id`) ,
45  UNIQUE INDEX `id` (`id` ASC) ,
46  INDEX `fk_relColaExt_agentes1` (`codAgente` ASC) ,
47  INDEX `fk_relColaExt_colas1` (`cola` ASC) ,
48  CONSTRAINT `fk_relColaExt_agentes1`
49    FOREIGN KEY (`codAgente` )
50    REFERENCES `agentes` (`codAgente` )
51    ON DELETE NO ACTION
52    ON UPDATE NO ACTION,
53  CONSTRAINT `fk_relColaExt_colas1`
54    FOREIGN KEY (`cola` )
55    REFERENCES `colas` (`nombre` )
56    ON DELETE NO ACTION
57    ON UPDATE NO ACTION)
58ENGINE = InnoDB;