rnBkTMSC

1CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
2
3USE `mydb` ;
4
5
6
7-- -----------------------------------------------------
8
9-- Table `mydb`.`usuario`
10
11-- -----------------------------------------------------
12
13CREATE  TABLE IF NOT EXISTS `mydb`.`usuario` (
14
15  `id` INT NOT NULL AUTO_INCREMENT ,
16
17  `nome` VARCHAR(45) NOT NULL ,
18
19  PRIMARY KEY (`id`) )
20
21ENGINE = InnoDB;
22
23
24
25
26
27-- -----------------------------------------------------
28
29-- Table `mydb`.`amizade`
30
31-- -----------------------------------------------------
32
33CREATE  TABLE IF NOT EXISTS `mydb`.`amizade` (
34
35  `id` INT NOT NULL ,
36
37  `usuario_id` INT NOT NULL ,
38
39  `amigo_id` INT NOT NULL ,
40
41  PRIMARY KEY (`id`) ,
42
43  INDEX `fk_amizade_usuario` (`usuario_id` ASC) ,
44
45  INDEX `fk_amizade_amigo` (`amigo_id` ASC) ,
46
47  CONSTRAINT `fk_amizade_usuario`
48
49    FOREIGN KEY (`usuario_id` )
50
51    REFERENCES `mydb`.`usuario` (`id` )
52
53    ON DELETE NO ACTION
54
55    ON UPDATE NO ACTION,
56
57  CONSTRAINT `fk_amizade_amigo`
58
59    FOREIGN KEY (`amigo_id` )
60
61    REFERENCES `mydb`.`usuario` (`id` )
62
63    ON DELETE NO ACTION
64
65    ON UPDATE NO ACTION)
66
67ENGINE = InnoDB;