sFzDbapG

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='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema barber_demo
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema barber_demo
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `barber_demo` DEFAULT CHARACTER SET utf8 ;
18USE `barber_demo` ;
19
20-- -----------------------------------------------------
21-- Table `barber_demo`.`users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `barber_demo`.`users` (
24  `id_user` INT(11) NOT NULL AUTO_INCREMENT,
25  `username` VARCHAR(50) NOT NULL,
26  `password` VARCHAR(68) NOT NULL,
27  `first_name` VARCHAR(45) NOT NULL,
28  `last_name` VARCHAR(45) NOT NULL,
29  `phone_number` INT(9) NOT NULL,
30  `email` VARCHAR(45) NOT NULL,
31  `enabled` TINYINT(1) NOT NULL DEFAULT '1',
32  PRIMARY KEY (`id_user`),
33  UNIQUE INDEX `id_user_UNIQUE` (`id_user` ASC),
34  UNIQUE INDEX `email_UNIQUE` (`username` ASC),
35  UNIQUE INDEX `phone_number_UNIQUE` (`phone_number` ASC))
36ENGINE = InnoDB
37AUTO_INCREMENT = 53
38DEFAULT CHARACTER SET = utf8;
39
40
41-- -----------------------------------------------------
42-- Table `barber_demo`.`orders`
43-- -----------------------------------------------------
44CREATE TABLE IF NOT EXISTS `barber_demo`.`orders` (
45  `id_order` INT(11) NOT NULL AUTO_INCREMENT,
46  `date` DATETIME NOT NULL,
47  `status` VARCHAR(45) NOT NULL,
48  `price` INT(2) NOT NULL,
49  `service` VARCHAR(45) NOT NULL,
50  `id_user` INT(11) NOT NULL,
51  PRIMARY KEY (`id_order`),
52  UNIQUE INDEX `id_order_UNIQUE` (`id_order` ASC),
53  UNIQUE INDEX `date_UNIQUE` (`date` ASC),
54  INDEX `fk_orders_users1_idx` (`id_user` ASC),
55  CONSTRAINT `fk_orders_users1`
56    FOREIGN KEY (`id_user`)
57    REFERENCES `barber_demo`.`users` (`id_user`)
58    ON DELETE CASCADE
59    ON UPDATE CASCADE)
60ENGINE = InnoDB
61AUTO_INCREMENT = 35
62DEFAULT CHARACTER SET = utf8;
63
64
65-- -----------------------------------------------------
66-- Table `barber_demo`.`roles`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `barber_demo`.`roles` (
69  `id_role` INT(11) NOT NULL AUTO_INCREMENT,
70  `role` VARCHAR(45) NOT NULL,
71  PRIMARY KEY (`id_role`),
72  UNIQUE INDEX `id_role_UNIQUE` (`id_role` ASC))
73ENGINE = InnoDB
74AUTO_INCREMENT = 18
75DEFAULT CHARACTER SET = utf8;
76
77
78-- -----------------------------------------------------
79-- Table `barber_demo`.`users_roles`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `barber_demo`.`users_roles` (
82  `user_id` INT(11) NOT NULL,
83  `role_id` INT(11) NOT NULL,
84  PRIMARY KEY (`user_id`, `role_id`),
85  INDEX `FK_ROLE_idx` (`role_id` ASC),
86  CONSTRAINT `FK_ROLE`
87    FOREIGN KEY (`role_id`)
88    REFERENCES `barber_demo`.`roles` (`id_role`),
89  CONSTRAINT `FK_USER_05`
90    FOREIGN KEY (`user_id`)
91    REFERENCES `barber_demo`.`users` (`id_user`))
92ENGINE = InnoDB
93DEFAULT CHARACTER SET = latin1;
94
95
96SET SQL_MODE=@OLD_SQL_MODE;
97SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
98SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;