· 6 years ago · Apr 02, 2019, 04:26 PM
1-- MySQL Script generated by MySQL Workbench
2-- Tue Apr 2 17:22:27 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 prodigyFinder
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema prodigyFinder
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `prodigyFinder` ;
18-- -----------------------------------------------------
19-- Schema prodigyfinder
20-- -----------------------------------------------------
21
22-- -----------------------------------------------------
23-- Schema prodigyfinder
24-- -----------------------------------------------------
25CREATE SCHEMA IF NOT EXISTS `prodigyfinder` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ;
26USE `prodigyFinder` ;
27
28-- -----------------------------------------------------
29-- Table `prodigyFinder`.`User`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `prodigyFinder`.`User` (
32 `idUser` INT NOT NULL AUTO_INCREMENT,
33 `name` VARCHAR(55) NOT NULL,
34 `email` VARCHAR(105) NOT NULL,
35 `birth_date` DATE NOT NULL,
36 `password` VARCHAR(45) NOT NULL,
37 `membership` VARCHAR(45) NOT NULL,
38 `type_user` VARCHAR(45) NOT NULL,
39 `picture_avatar` VARCHAR(255) NULL,
40 `missed` INT NULL,
41 `favorite_sports` VARCHAR(45) NULL,
42 `rating` VARCHAR(45) NULL,
43 `upcoming` VARCHAR(45) NULL,
44 PRIMARY KEY (`idUser`),
45 UNIQUE INDEX `email_UNIQUE` (`email` ASC) VISIBLE)
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `prodigyFinder`.`Event`
51-- -----------------------------------------------------
52CREATE TABLE IF NOT EXISTS `prodigyFinder`.`Event` (
53 `idEvent` INT NOT NULL AUTO_INCREMENT,
54 `date` DATE NOT NULL,
55 `hour` VARCHAR(45) NOT NULL,
56 `id_sport` INT NOT NULL,
57 `participants` VARCHAR(45) NULL,
58 `place` VARCHAR(45) NOT NULL,
59 `status` VARCHAR(45) NOT NULL,
60 `price` VARCHAR(45) NULL,
61 `missing` VARCHAR(45) NULL,
62 PRIMARY KEY (`idEvent`))
63ENGINE = InnoDB;
64
65
66-- -----------------------------------------------------
67-- Table `prodigyFinder`.`Sport`
68-- -----------------------------------------------------
69CREATE TABLE IF NOT EXISTS `prodigyFinder`.`Sport` (
70 `idSport` INT NOT NULL AUTO_INCREMENT,
71 `name` VARCHAR(45) NOT NULL,
72 PRIMARY KEY (`idSport`),
73 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE,
74 UNIQUE INDEX `idSport_UNIQUE` (`idSport` ASC) VISIBLE)
75ENGINE = InnoDB;
76
77USE `prodigyfinder` ;
78
79-- -----------------------------------------------------
80-- Table `prodigyfinder`.`sport`
81-- -----------------------------------------------------
82CREATE TABLE IF NOT EXISTS `prodigyfinder`.`sport` (
83 `idSport` INT(11) NOT NULL AUTO_INCREMENT,
84 `name` VARCHAR(45) NOT NULL,
85 PRIMARY KEY (`idSport`),
86 UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE,
87 UNIQUE INDEX `idSport_UNIQUE` (`idSport` ASC) VISIBLE)
88ENGINE = InnoDB
89DEFAULT CHARACTER SET = utf8mb4
90COLLATE = utf8mb4_0900_ai_ci;
91
92
93-- -----------------------------------------------------
94-- Table `prodigyfinder`.`event`
95-- -----------------------------------------------------
96CREATE TABLE IF NOT EXISTS `prodigyfinder`.`event` (
97 `idEvent` INT(11) NOT NULL AUTO_INCREMENT,
98 `date` DATE NOT NULL,
99 `hour` VARCHAR(45) NOT NULL,
100 `participants` VARCHAR(45) NULL DEFAULT NULL,
101 `place` VARCHAR(45) NOT NULL,
102 `status` VARCHAR(45) NOT NULL,
103 `price` VARCHAR(45) NULL DEFAULT NULL,
104 `missing` VARCHAR(45) NULL DEFAULT NULL,
105 `sport_idSport` INT(11) NOT NULL,
106 PRIMARY KEY (`idEvent`),
107 INDEX `fk_event_sport1_idx` (`sport_idSport` ASC) VISIBLE,
108 CONSTRAINT `fk_event_sport1`
109 FOREIGN KEY (`sport_idSport`)
110 REFERENCES `prodigyfinder`.`sport` (`idSport`)
111 ON DELETE NO ACTION
112 ON UPDATE NO ACTION)
113ENGINE = InnoDB
114DEFAULT CHARACTER SET = utf8mb4
115COLLATE = utf8mb4_0900_ai_ci;
116
117
118-- -----------------------------------------------------
119-- Table `prodigyfinder`.`user`
120-- -----------------------------------------------------
121CREATE TABLE IF NOT EXISTS `prodigyfinder`.`user` (
122 `idUser` INT(11) NOT NULL AUTO_INCREMENT,
123 `name` VARCHAR(55) NOT NULL,
124 `email` VARCHAR(105) NOT NULL,
125 `birth_date` DATE NOT NULL,
126 `password` VARCHAR(45) NOT NULL,
127 `membership` VARCHAR(45) NOT NULL,
128 `type_user` VARCHAR(45) NOT NULL,
129 `picture_avatar` VARCHAR(255) NULL DEFAULT NULL,
130 `missed` INT(11) NULL DEFAULT NULL,
131 `favorite_sports` VARCHAR(45) NULL DEFAULT NULL,
132 `rating` VARCHAR(45) NULL DEFAULT NULL,
133 `upcoming` VARCHAR(45) NULL DEFAULT NULL,
134 `sport_idSport` INT(11) NOT NULL,
135 PRIMARY KEY (`idUser`),
136 UNIQUE INDEX `email_UNIQUE` (`email` ASC) VISIBLE,
137 INDEX `fk_user_sport1_idx` (`sport_idSport` ASC) VISIBLE,
138 CONSTRAINT `fk_user_sport1`
139 FOREIGN KEY (`sport_idSport`)
140 REFERENCES `prodigyfinder`.`sport` (`idSport`)
141 ON DELETE NO ACTION
142 ON UPDATE NO ACTION)
143ENGINE = InnoDB
144DEFAULT CHARACTER SET = utf8mb4
145COLLATE = utf8mb4_0900_ai_ci;
146
147
148-- -----------------------------------------------------
149-- Table `prodigyfinder`.`event_has_user`
150-- -----------------------------------------------------
151CREATE TABLE IF NOT EXISTS `prodigyfinder`.`event_has_user` (
152 `event_idEvent` INT(11) NOT NULL,
153 `user_idUser` INT(11) NOT NULL,
154 PRIMARY KEY (`event_idEvent`, `user_idUser`),
155 INDEX `fk_event_has_user_user1_idx` (`user_idUser` ASC) VISIBLE,
156 INDEX `fk_event_has_user_event1_idx` (`event_idEvent` ASC) VISIBLE,
157 CONSTRAINT `fk_event_has_user_event1`
158 FOREIGN KEY (`event_idEvent`)
159 REFERENCES `prodigyfinder`.`event` (`idEvent`)
160 ON DELETE NO ACTION
161 ON UPDATE NO ACTION,
162 CONSTRAINT `fk_event_has_user_user1`
163 FOREIGN KEY (`user_idUser`)
164 REFERENCES `prodigyfinder`.`user` (`idUser`)
165 ON DELETE NO ACTION
166 ON UPDATE NO ACTION)
167ENGINE = InnoDB
168DEFAULT CHARACTER SET = utf8mb4
169COLLATE = utf8mb4_0900_ai_ci;
170
171
172SET SQL_MODE=@OLD_SQL_MODE;
173SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
174SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;