78Xr80pG

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 jpdsi_calculator
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema jpdsi_calculator
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `jpdsi_calculator` DEFAULT CHARACTER SET utf8 ;
15USE `jpdsi_calculator` ;
16
17-- -----------------------------------------------------
18-- Table `jpdsi_calculator`.`Role`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `jpdsi_calculator`.`Role` (
21  `idRole` INT NOT NULL AUTO_INCREMENT,
22  `name` VARCHAR(45) NULL,
23  `canEdit` TINYINT NULL,
24  PRIMARY KEY (`idRole`))
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `jpdsi_calculator`.`user`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `jpdsi_calculator`.`user` (
32  `idUser` INT(11) NOT NULL AUTO_INCREMENT,
33  `email` VARCHAR(45) NULL DEFAULT NULL,
34  `password` VARCHAR(45) NULL DEFAULT NULL,
35  `profileImage` VARCHAR(800) NOT NULL DEFAULT 'http://s3.amazonaws.com/37assets/svn/765-default-avatar.png',
36  `description` VARCHAR(45) NULL,
37  `city` VARCHAR(45) NULL,
38  `username` VARCHAR(45) NULL DEFAULT NULL,
39  `idRole` INT NOT NULL,
40  `active` TINYINT NULL,
41  PRIMARY KEY (`idUser`),
42  UNIQUE INDEX `email_UNIQUE` (`email` ASC),
43  INDEX `fk_user_Role1_idx` (`idRole` ASC),
44  CONSTRAINT `fk_user_Role1`
45    FOREIGN KEY (`idRole`)
46    REFERENCES `jpdsi_calculator`.`Role` (`idRole`)
47    ON DELETE NO ACTION
48    ON UPDATE NO ACTION)
49ENGINE = InnoDB
50AUTO_INCREMENT = 10
51DEFAULT CHARACTER SET = utf8;
52
53
54-- -----------------------------------------------------
55-- Table `jpdsi_calculator`.`Post`
56-- -----------------------------------------------------
57CREATE TABLE IF NOT EXISTS `jpdsi_calculator`.`Post` (
58  `idPost` INT NOT NULL AUTO_INCREMENT,
59  `data` DATETIME NULL,
60  `description` VARCHAR(280) NULL,
61  `Postcol` VARCHAR(45) NULL,
62  `authorId` INT(11) NOT NULL,
63  `ownerId` INT(11) NOT NULL,
64  PRIMARY KEY (`idPost`),
65  INDEX `fk_Post_user_idx` (`authorId` ASC),
66  INDEX `fk_Post_user1_idx` (`ownerId` ASC),
67  CONSTRAINT `fk_Post_user`
68    FOREIGN KEY (`authorId`)
69    REFERENCES `jpdsi_calculator`.`user` (`idUser`)
70    ON DELETE NO ACTION
71    ON UPDATE NO ACTION,
72  CONSTRAINT `fk_Post_user1`
73    FOREIGN KEY (`ownerId`)
74    REFERENCES `jpdsi_calculator`.`user` (`idUser`)
75    ON DELETE NO ACTION
76    ON UPDATE NO ACTION)
77ENGINE = InnoDB;
78
79
80-- -----------------------------------------------------
81-- Table `jpdsi_calculator`.`Subscription`
82-- -----------------------------------------------------
83CREATE TABLE IF NOT EXISTS `jpdsi_calculator`.`Subscription` (
84  `idSubscription` INT NOT NULL AUTO_INCREMENT,
85  `idUser` INT(11) NOT NULL,
86  `idProfile` INT(11) NOT NULL,
87  `description` VARCHAR(45) NULL,
88  PRIMARY KEY (`idSubscription`),
89  INDEX `fk_Subscription_user1_idx` (`idUser` ASC),
90  INDEX `fk_Subscription_user2_idx` (`idProfile` ASC),
91  CONSTRAINT `fk_Subscription_user1`
92    FOREIGN KEY (`idUser`)
93    REFERENCES `jpdsi_calculator`.`user` (`idUser`)
94    ON DELETE NO ACTION
95    ON UPDATE NO ACTION,
96  CONSTRAINT `fk_Subscription_user2`
97    FOREIGN KEY (`idProfile`)
98    REFERENCES `jpdsi_calculator`.`user` (`idUser`)
99    ON DELETE NO ACTION
100    ON UPDATE NO ACTION)
101ENGINE = InnoDB;
102
103
104SET SQL_MODE=@OLD_SQL_MODE;
105SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
106SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;