g7kqii39

1Executing SQL script in server
2ERROR: Error 1215: Cannot add foreign key constraint
3SQL Code:
4        -- -----------------------------------------------------
5        -- Table `empresa`.`ClienteConta`
6        -- -----------------------------------------------------
7        CREATE TABLE IF NOT EXISTS `empresa`.`ClienteConta` (
8          `cliente_id_cliente` INT NOT NULL,
9          `conta_numConta` VARCHAR(8) NOT NULL,
10          INDEX `fk_cliente_has_conta_conta1_idx` (`conta_numConta` ASC),
11          INDEX `fk_cliente_has_conta_cliente1_idx` (`cliente_id_cliente` ASC),
12          PRIMARY KEY (`cliente_id_cliente`, `conta_numConta`),
13          CONSTRAINT `fk_cliente_has_conta_cliente1`
14            FOREIGN KEY (`cliente_id_cliente`)
15            REFERENCES `empresa`.`cliente` (`id_cliente`)
16            ON DELETE NO ACTION
17            ON UPDATE NO ACTION,
18          CONSTRAINT `fk_cliente_has_conta_conta1`
19            FOREIGN KEY (`conta_numConta`)
20            REFERENCES `empresa`.`conta` (`numConta`)
21            ON DELETE NO ACTION
22            ON UPDATE NO ACTION)
23        ENGINE = InnoDB
24
25SQL script execution finished: statements: 8 succeeded, 1 failed
26
27Fetching back view definitions in final form.
28Nothing to fetch
29Executing SQL script in server
30ERROR: Error 1215: Cannot add foreign key constraint
31SQL Code:
32        -- -----------------------------------------------------
33        -- Table `empresa`.`ClienteConta`
34        -- -----------------------------------------------------
35        CREATE TABLE IF NOT EXISTS `empresa`.`ClienteConta` (
36          `cliente_id_cliente` INT NOT NULL,
37          `conta_numConta` VARCHAR(8) NOT NULL,
38          INDEX `fk_cliente_has_conta_conta1_idx` (`conta_numConta` ASC),
39          INDEX `fk_cliente_has_conta_cliente1_idx` (`cliente_id_cliente` ASC),
40          PRIMARY KEY (`cliente_id_cliente`, `conta_numConta`),
41          CONSTRAINT `fk_cliente_has_conta_cliente1`
42            FOREIGN KEY (`cliente_id_cliente`)
43            REFERENCES `empresa`.`cliente` (`id_cliente`)
44            ON DELETE NO ACTION
45            ON UPDATE NO ACTION,
46          CONSTRAINT `fk_cliente_has_conta_conta1`
47            FOREIGN KEY (`conta_numConta`)
48            REFERENCES `empresa`.`conta` (`numConta`)
49            ON DELETE NO ACTION
50            ON UPDATE NO ACTION)
51        ENGINE = InnoDB
52
53SQL script execution finished: statements: 8 succeeded, 1 failed
54
55Fetching back view definitions in final form.
56Nothing to fetch