· 6 years ago · Jul 11, 2019, 12:28 PM
1-- MySQL Script generated by MySQL Workbench
2-- Thu Jul 11 14:24:24 2019
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema WL-DB
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema WL-DB
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `WL-DB` DEFAULT CHARACTER SET utf8 ;
18USE `WL-DB` ;
19
20-- -----------------------------------------------------
21-- Table `WL-DB`.`User`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `WL-DB`.`User` (
24 `id_user` INT(10) NOT NULL,
25 `password` VARCHAR(45) NULL,
26 `first_name` VARCHAR(45) NULL,
27 `last_name` VARCHAR(45) NULL,
28 `phone_no` VARCHAR(16) NULL,
29 `email` VARCHAR(45) NULL,
30 `last_signin` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
31 `role` TINYINT(1) NULL DEFAULT 1,
32 `active` TINYINT(1) NULL DEFAULT 1,
33 `deleted` TINYINT(1) NULL DEFAULT 0,
34 PRIMARY KEY (`id_user`),
35 UNIQUE INDEX `ID-user_UNIQUE` (`id_user` ASC) VISIBLE)
36ENGINE = InnoDB;
37
38
39-- -----------------------------------------------------
40-- Table `WL-DB`.`File`
41-- -----------------------------------------------------
42CREATE TABLE IF NOT EXISTS `WL-DB`.`File` (
43 `id_file` INT(10) NOT NULL,
44 `file_token` VARCHAR(45) NULL,
45 `id_sender` INT(10) NULL,
46 `id_receiver` INT(10) NULL,
47 `date_added` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
48 `file_expires` DATETIME NULL,
49 `splitted` TINYINT(1) NULL DEFAULT 0,
50 `active` TINYINT(1) NULL DEFAULT 1,
51 `deleted` TINYINT(1) NULL DEFAULT 0,
52 PRIMARY KEY (`id_file`),
53 UNIQUE INDEX `id_file_UNIQUE` (`id_file` ASC) INVISIBLE,
54 INDEX `fk_File_User1_idx` (`id_sender` ASC) VISIBLE,
55 INDEX `fk_File_User2_idx` (`id_receiver` ASC) VISIBLE,
56 CONSTRAINT `fk_File_User1`
57 FOREIGN KEY (`id_sender`)
58 REFERENCES `WL-DB`.`User` (`id_user`)
59 ON DELETE NO ACTION
60 ON UPDATE NO ACTION,
61 CONSTRAINT `fk_File_User2`
62 FOREIGN KEY (`id_receiver`)
63 REFERENCES `WL-DB`.`User` (`id_user`)
64 ON DELETE NO ACTION
65 ON UPDATE NO ACTION)
66ENGINE = InnoDB;
67
68
69-- -----------------------------------------------------
70-- Table `WL-DB`.`Requests`
71-- -----------------------------------------------------
72CREATE TABLE IF NOT EXISTS `WL-DB`.`Requests` (
73 `id_request` INT(10) NOT NULL,
74 `title` VARCHAR(45) NULL,
75 `content` TEXT NULL,
76 `id_sender` INT(10) NULL,
77 `id_receiver` INT(10) NULL,
78 `status` TINYINT(1) NULL DEFAULT 0,
79 PRIMARY KEY (`id_request`),
80 UNIQUE INDEX `id_request_UNIQUE` (`id_request` ASC) VISIBLE,
81 INDEX `fk_Requests_User_idx` (`id_sender` ASC) VISIBLE,
82 INDEX `fk_Requests_User1_idx` (`id_receiver` ASC) VISIBLE,
83 CONSTRAINT `fk_Requests_User`
84 FOREIGN KEY (`id_sender`)
85 REFERENCES `WL-DB`.`User` (`id_user`)
86 ON DELETE NO ACTION
87 ON UPDATE NO ACTION,
88 CONSTRAINT `fk_Requests_User1`
89 FOREIGN KEY (`id_receiver`)
90 REFERENCES `WL-DB`.`User` (`id_user`)
91 ON DELETE NO ACTION
92 ON UPDATE NO ACTION)
93ENGINE = InnoDB;
94
95
96SET SQL_MODE=@OLD_SQL_MODE;
97SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
98SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;