jBAZJavk

1-- MySQL Script generated by MySQL Workbench
2-- 11/18/16 17:57:49
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 interview5
12-- -----------------------------------------------------
13CREATE SCHEMA IF NOT EXISTS `interview5` DEFAULT CHARACTER SET utf8 ;
14USE `mydb` ;
15
16USE `interview5` ;
17
18-- -----------------------------------------------------
19-- Table `interview5`.`departments`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `interview5`.`departments` (
22  `id` INT(11) UNSIGNED NOT NULL,
23  `name` VARCHAR(50) CHARACTER SET 'utf8' NOT NULL,
24  `google_calendar_id` VARCHAR(255) CHARACTER SET 'utf8' NOT NULL,
25  `created_at` TIMESTAMP NULL DEFAULT NULL,
26  `updated_at` TIMESTAMP NULL DEFAULT NULL,
27  PRIMARY KEY (`id`),
28  UNIQUE INDEX `id_UNIQUE` (`id` ASC))
29ENGINE = MyISAM
30AUTO_INCREMENT = 3
31DEFAULT CHARACTER SET = utf8
32COLLATE = utf8_unicode_ci;
33
34-- -----------------------------------------------------
35-- Table `interview5`.`position`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `interview5`.`position` (
38  `id` INT(11) NOT NULL AUTO_INCREMENT,
39  `name` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL,
40  `color` VARCHAR(10) CHARACTER SET 'utf8' NOT NULL,
41  `active` TINYINT(1) NOT NULL DEFAULT '1',
42  `description` TEXT CHARACTER SET 'utf8' NOT NULL,
43  `departments_id` INT(11) UNSIGNED NOT NULL,
44  PRIMARY KEY (`id`),
45  INDEX `fk_position_departments1_idx` (`departments_id` ASC),
46  CONSTRAINT `fk_position_departments1`
47    FOREIGN KEY (`departments_id`)
48    REFERENCES `interview5`.`departments` (`id`)
49    ON DELETE NO ACTION
50    ON UPDATE NO ACTION)
51ENGINE = InnoDB
52DEFAULT CHARACTER SET = utf8
53COLLATE = utf8_bin;
54
55-- -----------------------------------------------------
56-- Table `interview5`.`users`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `interview5`.`users` (
59  `id` INT(11) NOT NULL AUTO_INCREMENT,
60  `password` VARCHAR(255) CHARACTER SET 'utf8' NOT NULL,
61  `created_at` TIMESTAMP NULL DEFAULT NULL,
62  `updated_at` TIMESTAMP NULL DEFAULT NULL,
63  `role_id` INT(11) NOT NULL DEFAULT '1',
64  `email` VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,
65  `name` VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,
66  `remember_token` VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,
67  `blocked` TINYINT(1) NULL DEFAULT '0',
68  `receive_emails` TINYINT(1) NOT NULL DEFAULT '1',
69  `lang` VARCHAR(2) CHARACTER SET 'utf8' NOT NULL DEFAULT 'en',
70  `departments_id` INT(11) UNSIGNED NOT NULL,
71  PRIMARY KEY (`id`),
72  INDEX `fk_users_user_type_idx` (`role_id` ASC),
73  INDEX `fk_users_departments1_idx` (`departments_id` ASC),
74  CONSTRAINT `fk_users_user_type`
75    FOREIGN KEY (`role_id`)
76    REFERENCES `interview5`.`role` (`id`)
77    ON DELETE NO ACTION
78    ON UPDATE NO ACTION,
79  CONSTRAINT `fk_users_departments1`
80    FOREIGN KEY (`departments_id`)
81    REFERENCES `interview5`.`departments` (`id`)
82    ON DELETE NO ACTION
83    ON UPDATE NO ACTION)
84ENGINE = InnoDB
85AUTO_INCREMENT = 13
86DEFAULT CHARACTER SET = utf8
87COLLATE = utf8_bin;
88
89SET SQL_MODE=@OLD_SQL_MODE;
90SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
91SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;