P8MCLGnv

1DROP TABLE IF EXISTS `comercio`.`cliente` ;
2
3CREATE TABLE IF NOT EXISTS `comercio`.`cliente` (
4    `cliente_id` INT(11) NOT NULL AUTO_INCREMENT,
5    `cpf` VARCHAR(15) NOT NULL,
6    `nome` VARCHAR(50) NOT NULL,
7    `rg` VARCHAR(50) NOT NULL,
8    `sexo` VARCHAR(2) NOT NULL,
9    `nascimento` DATE NOT NULL,
10    `telefone` VARCHAR(50) NOT NULL,
11    `email` VARCHAR(50) NOT NULL,
12     PRIMARY KEY (`cliente_id`, `cpf`))
13ENGINE = InnoDB
14DEFAULT CHARACTER SET = latin1;
15
16DROP TABLE IF EXISTS `comercio`.`endereco` ;
17
18CREATE TABLE IF NOT EXISTS `comercio`.`endereco` (
19    `endereco_id` INT(11) NOT NULL AUTO_INCREMENT,
20    `cidade` VARCHAR(50) NOT NULL,
21    `estado` VARCHAR(50) NOT NULL,
22    `rua` VARCHAR(50) NOT NULL,
23    `bairro` VARCHAR(50) NOT NULL,
24    `numero` VARCHAR(50) NOT NULL,
25    `cep` VARCHAR(50) NOT NULL,
26    `complemento` VARCHAR(50) NOT NULL,
27    `cpf_cliente` VARCHAR(15) NOT NULL,
28    PRIMARY KEY (`endereco_id`),
29    INDEX `FK_CPF_CLIENTE_idx` (`cpf_cliente` ASC),
30    CONSTRAINT `FK_CPF_CLIENTE`
31        FOREIGN KEY (`cpf_cliente`)
32        REFERENCES `comercio`.`cliente` (`cpf`)
33        ON DELETE CASCADE
34        ON UPDATE CASCADE)
35ENGINE = InnoDB
36DEFAULT CHARACTER SET = latin1;
37	
38Executing SQL script in server
39ERROR: Error 1215: Cannot add foreign key constraint
40SQL Code:
41        CREATE TABLE IF NOT EXISTS `comercio`.`endereco` (
42          `endereco_id` INT(11) NOT NULL AUTO_INCREMENT,
43          `cidade` VARCHAR(50) NOT NULL,
44          `estado` VARCHAR(50) NOT NULL,
45          `rua` VARCHAR(50) NOT NULL,
46          `bairro` VARCHAR(50) NOT NULL,
47          `numero` VARCHAR(50) NOT NULL,
48          `cep` VARCHAR(50) NOT NULL,
49          `complemento` VARCHAR(50) NOT NULL,
50          `cpf_cliente` VARCHAR(15) NOT NULL,
51          PRIMARY KEY (`endereco_id`),
52          INDEX `FK_CPF_CLIENTE_idx` (`cpf_cliente` ASC),
53          CONSTRAINT `FK_CPF_CLIENTE`
54            FOREIGN KEY (`cpf_cliente`)
55            REFERENCES `comercio`.`cliente` (`cpf`)
56            ON DELETE CASCADE
57            ON UPDATE CASCADE)
58        ENGINE = InnoDB
59        DEFAULT CHARACTER SET = latin1
60
61SQL script execution finished: statements: 9 succeeded, 1 failed