1XNmBHSi

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema db_testing
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema db_testing
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `db_testing` DEFAULT CHARACTER SET latin1 ;
18USE `db_testing` ;
19
20-- -----------------------------------------------------
21-- Table `db_testing`.`roles`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `db_testing`.`roles` (
24  `role_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
25  `role_name` VARCHAR(255) NULL DEFAULT NULL,
26  PRIMARY KEY (`role_id`))
27ENGINE = InnoDB
28AUTO_INCREMENT = 2
29DEFAULT CHARACTER SET = latin1;
30
31
32-- -----------------------------------------------------
33-- Table `db_testing`.`testing`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `db_testing`.`testing` (
36  `id` INT(11) NOT NULL AUTO_INCREMENT,
37  `x` INT(11) NULL DEFAULT NULL,
38  PRIMARY KEY (`id`))
39ENGINE = InnoDB
40DEFAULT CHARACTER SET = latin1;
41
42
43-- -----------------------------------------------------
44-- Table `db_testing`.`users`
45-- -----------------------------------------------------
46CREATE TABLE IF NOT EXISTS `db_testing`.`users` (
47  `user_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
48  `user_name` VARCHAR(255) NULL DEFAULT NULL,
49  PRIMARY KEY (`user_id`))
50ENGINE = InnoDB
51AUTO_INCREMENT = 3
52DEFAULT CHARACTER SET = latin1;
53
54
55-- -----------------------------------------------------
56-- Table `db_testing`.`user_specifics`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `db_testing`.`user_specifics` (
59  `age` INT(11) NOT NULL,
60  `user_user_id` BIGINT(20) NOT NULL,
61  PRIMARY KEY (`user_user_id`),
62  CONSTRAINT `FK_user_id`
63    FOREIGN KEY (`user_user_id`)
64    REFERENCES `db_testing`.`users` (`user_id`))
65ENGINE = InnoDB
66DEFAULT CHARACTER SET = latin1;
67
68
69-- -----------------------------------------------------
70-- Table `db_testing`.`users_roles`
71-- -----------------------------------------------------
72CREATE TABLE IF NOT EXISTS `db_testing`.`users_roles` (
73  `users_user_id` BIGINT(20) NOT NULL,
74  `roles_role_id` BIGINT(20) NOT NULL,
75  PRIMARY KEY (`users_user_id`, `roles_role_id`),
76  INDEX `FKtgou1kvdhyryu3fia6uu1fhoi` (`roles_role_id` ASC),
77  CONSTRAINT `FKmaps3ffbyjaxkt50q1c7s7v5j`
78    FOREIGN KEY (`users_user_id`)
79    REFERENCES `db_testing`.`users` (`user_id`),
80  CONSTRAINT `FKtgou1kvdhyryu3fia6uu1fhoi`
81    FOREIGN KEY (`roles_role_id`)
82    REFERENCES `db_testing`.`roles` (`role_id`))
83ENGINE = InnoDB
84DEFAULT CHARACTER SET = latin1;
85
86
87SET SQL_MODE=@OLD_SQL_MODE;
88SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
89SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;