S8tjYQh1

1-- MySQL Script generated by MySQL Workbench
2-- Mon Nov 20 15:59:08 2017
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 mydb
12-- -----------------------------------------------------
13-- -----------------------------------------------------
14-- Schema todosapp
15-- -----------------------------------------------------
16
17-- -----------------------------------------------------
18-- Schema todosapp
19-- -----------------------------------------------------
20CREATE SCHEMA IF NOT EXISTS `todosapp` DEFAULT CHARACTER SET utf8 ;
21USE `todosapp` ;
22
23-- -----------------------------------------------------
24-- Table `todosapp`.`categoria`
25-- -----------------------------------------------------
26CREATE TABLE IF NOT EXISTS `todosapp`.`categoria` (
27  `id` INT(11) NOT NULL AUTO_INCREMENT,
28  `descricao` VARCHAR(127) NULL DEFAULT NULL,
29  PRIMARY KEY (`id`))
30ENGINE = InnoDB
31DEFAULT CHARACTER SET = utf8;
32
33
34-- -----------------------------------------------------
35-- Table `todosapp`.`usuario`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `todosapp`.`usuario` (
38  `id` INT(11) NOT NULL AUTO_INCREMENT,
39  `username` VARCHAR(127) NULL DEFAULT NULL,
40  `password` VARCHAR(127) NULL DEFAULT NULL,
41  PRIMARY KEY (`id`),
42  UNIQUE INDEX `username_UNIQUE` (`username` ASC))
43ENGINE = InnoDB
44AUTO_INCREMENT = 2
45DEFAULT CHARACTER SET = utf8;
46
47
48-- -----------------------------------------------------
49-- Table `todosapp`.`tarefa`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `todosapp`.`tarefa` (
52  `id` INT(11) NOT NULL AUTO_INCREMENT,
53  `descricao` VARCHAR(127) NULL DEFAULT NULL,
54  `usuario_id` INT(11) NOT NULL,
55  `prazo` DATETIME NULL DEFAULT NULL,
56  `status` TINYINT(1) NULL DEFAULT NULL,
57  PRIMARY KEY (`id`),
58  INDEX `fk_tarefa_usuario_idx` (`usuario_id` ASC),
59  CONSTRAINT `fk_tarefa_usuario`
60    FOREIGN KEY (`usuario_id`)
61    REFERENCES `todosapp`.`usuario` (`id`)
62    ON DELETE NO ACTION
63    ON UPDATE NO ACTION)
64ENGINE = InnoDB
65AUTO_INCREMENT = 12
66DEFAULT CHARACTER SET = utf8;
67
68
69-- -----------------------------------------------------
70-- Table `todosapp`.`tarefa_caregoria`
71-- -----------------------------------------------------
72CREATE TABLE IF NOT EXISTS `todosapp`.`tarefa_caregoria` (
73  `id` INT(11) NOT NULL AUTO_INCREMENT,
74  `tarefa_id` INT(11) NOT NULL,
75  `categoria_id` INT(11) NOT NULL,
76  PRIMARY KEY (`id`),
77  INDEX `fk_tarefa_caregoria_tarefa1_idx` (`tarefa_id` ASC),
78  INDEX `fk_tarefa_caregoria_categoria1_idx` (`categoria_id` ASC),
79  CONSTRAINT `fk_tarefa_caregoria_categoria1`
80    FOREIGN KEY (`categoria_id`)
81    REFERENCES `todosapp`.`categoria` (`id`)
82    ON DELETE NO ACTION
83    ON UPDATE NO ACTION,
84  CONSTRAINT `fk_tarefa_caregoria_tarefa1`
85    FOREIGN KEY (`tarefa_id`)
86    REFERENCES `todosapp`.`tarefa` (`id`)
87    ON DELETE NO ACTION
88    ON UPDATE NO ACTION)
89ENGINE = InnoDB
90DEFAULT CHARACTER SET = utf8;
91
92
93SET SQL_MODE=@OLD_SQL_MODE;
94SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
95SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;