CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;

USE `mydb` ;



-- -----------------------------------------------------

-- Table `mydb`.`usuario`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `mydb`.`usuario` (

  `id` INT NOT NULL AUTO_INCREMENT ,

  `nome` VARCHAR(45) NOT NULL ,

  PRIMARY KEY (`id`) )

ENGINE = InnoDB;





-- -----------------------------------------------------

-- Table `mydb`.`amizade`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `mydb`.`amizade` (

  `id` INT NOT NULL ,

  `usuario_id` INT NOT NULL ,

  `amigo_id` INT NOT NULL ,

  PRIMARY KEY (`id`) ,

  INDEX `fk_amizade_usuario` (`usuario_id` ASC) ,

  INDEX `fk_amizade_amigo` (`amigo_id` ASC) ,

  CONSTRAINT `fk_amizade_usuario`

    FOREIGN KEY (`usuario_id` )

    REFERENCES `mydb`.`usuario` (`id` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_amizade_amigo`

    FOREIGN KEY (`amigo_id` )

    REFERENCES `mydb`.`usuario` (`id` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB;