v9hYrwvd

1-- MySQL Script generated by MySQL Workbench
2-- 09/10/16 02:00:28
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema pibic
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema pibic
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `pibic` DEFAULT CHARACTER SET utf8 ;
18USE `pibic` ;
19
20-- -----------------------------------------------------
21-- Table `pibic`.`Categorias`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `pibic`.`Categorias` (
24  `id` INT NOT NULL AUTO_INCREMENT,
25  `Categoria` VARCHAR(45) NULL,
26  PRIMARY KEY (`id`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `pibic`.`Produtos`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `pibic`.`Produtos` (
34  `id` INT NOT NULL AUTO_INCREMENT,
35  `Produto` VARCHAR(65) NOT NULL,
36  `Valor` FLOAT NOT NULL,
37  `Quantidade` INT NULL,
38  `Categoria_id` INT NOT NULL,
39  `NivelReposicao` INT NULL,
40  PRIMARY KEY (`id`),
41  INDEX `fk_Produtos_Categorias_idx` (`Categoria_id` ASC),
42  CONSTRAINT `fk_Produtos_Categorias`
43    FOREIGN KEY (`Categoria_id`)
44    REFERENCES `pibic`.`Categorias` (`id`)
45    ON DELETE NO ACTION
46    ON UPDATE NO ACTION)
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `pibic`.`Tags`
52-- -----------------------------------------------------
53CREATE TABLE IF NOT EXISTS `pibic`.`Tags` (
54  `id` INT NOT NULL AUTO_INCREMENT,
55  `Id_Produto` INT NULL,
56  `Tag` VARCHAR(16) NULL,
57  PRIMARY KEY (`id`))
58ENGINE = InnoDB;
59
60
61SET SQL_MODE=@OLD_SQL_MODE;
62SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
63SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;