Nh1MyNdN

1-- MySQL Script generated by MySQL Workbench
2-- Fri Nov 24 17:56:44 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 task
15-- -----------------------------------------------------
16
17-- -----------------------------------------------------
18-- Schema task
19-- -----------------------------------------------------
20CREATE SCHEMA IF NOT EXISTS `task` DEFAULT CHARACTER SET utf8 ;
21USE `task` ;
22
23-- -----------------------------------------------------
24-- Table `task`.`user`
25-- -----------------------------------------------------
26CREATE TABLE IF NOT EXISTS `task`.`user` (
27  `id_user` INT(10) UNSIGNED NOT NULL,
28  `email_user` VARCHAR(50) NOT NULL,
29  PRIMARY KEY (`id_user`),
30  UNIQUE INDEX `id_user_UNIQUE` (`id_user` ASC),
31  UNIQUE INDEX `email_user_UNIQUE` (`email_user` ASC))
32ENGINE = InnoDB
33DEFAULT CHARACTER SET = utf8;
34
35
36-- -----------------------------------------------------
37-- Table `task`.`task`
38-- -----------------------------------------------------
39CREATE TABLE IF NOT EXISTS `task`.`task` (
40  `id_task` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
41  `nome_task` VARCHAR(45) NOT NULL,
42  `desc_task` VARCHAR(200) NULL DEFAULT NULL,
43  `pri_task` TINYINT(1) UNSIGNED NOT NULL,
44  `id_task_user` INT(10) UNSIGNED NOT NULL,
45  PRIMARY KEY (`id_task`),
46  UNIQUE INDEX `id_Task_UNIQUE` (`id_task` ASC),
47  CONSTRAINT `id_task_user`
48    FOREIGN KEY (`id_task`)
49    REFERENCES `task`.`user` (`id_user`)
50    ON DELETE NO ACTION
51    ON UPDATE NO ACTION)
52ENGINE = InnoDB
53AUTO_INCREMENT = 3
54DEFAULT CHARACTER SET = utf8
55COMMENT = '		';
56
57
58-- -----------------------------------------------------
59-- Table `task`.`status`
60-- -----------------------------------------------------
61CREATE TABLE IF NOT EXISTS `task`.`status` (
62  `id_status` INT(11) UNSIGNED NOT NULL,
63  `status_status` VARCHAR(15) NOT NULL,
64  `id_status_user` INT(10) UNSIGNED NOT NULL,
65  `id_status_task` INT(10) UNSIGNED NOT NULL,
66  PRIMARY KEY (`id_status`),
67  INDEX `id_status_user_idx` (`id_status_user` ASC),
68  INDEX `id_status_task_idx` (`id_status_task` ASC),
69  CONSTRAINT `id_status_task`
70    FOREIGN KEY (`id_status_task`)
71    REFERENCES `task`.`task` (`id_task`)
72    ON DELETE NO ACTION
73    ON UPDATE NO ACTION,
74  CONSTRAINT `id_status_user`
75    FOREIGN KEY (`id_status_user`)
76    REFERENCES `task`.`user` (`id_user`)
77    ON DELETE NO ACTION
78    ON UPDATE NO ACTION)
79ENGINE = InnoDB
80DEFAULT CHARACTER SET = utf8;
81
82
83SET SQL_MODE=@OLD_SQL_MODE;
84SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
85SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;