· 8 years ago · Jan 13, 2018, 09:36 AM
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 elephpants_new
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema elephpants_new
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `elephpants_new` DEFAULT CHARACTER SET latin1 ;
18USE `elephpants_new` ;
19
20-- -----------------------------------------------------
21-- Table `elephpants_new`.`abonament`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `elephpants_new`.`abonament` (
24 `AbonamentId` INT(11) NOT NULL AUTO_INCREMENT,
25 `Price` FLOAT NULL DEFAULT NULL,
26 `Level` INT(11) NULL DEFAULT NULL,
27 `Type` VARCHAR(200) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL,
28 `Description` VARCHAR(2000) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL,
29 PRIMARY KEY (`AbonamentId`))
30ENGINE = InnoDB
31AUTO_INCREMENT = 70
32DEFAULT CHARACTER SET = utf8
33COLLATE = utf8_unicode_ci;
34
35
36-- -----------------------------------------------------
37-- Table `elephpants_new`.`curs`
38-- -----------------------------------------------------
39CREATE TABLE IF NOT EXISTS `elephpants_new`.`curs` (
40 `CursId` INT(11) NOT NULL AUTO_INCREMENT,
41 `StartDate` DATETIME NULL DEFAULT NULL,
42 `EndDate` DATETIME NULL DEFAULT NULL,
43 `Places` INT(11) NULL DEFAULT NULL,
44 `Level` INT(11) NULL DEFAULT NULL,
45 `Type` VARCHAR(100) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL,
46 PRIMARY KEY (`CursId`))
47ENGINE = InnoDB
48DEFAULT CHARACTER SET = utf8
49COLLATE = utf8_unicode_ci;
50
51
52-- -----------------------------------------------------
53-- Table `elephpants_new`.`curs_abonament`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `elephpants_new`.`curs_abonament` (
56 `IdAbonament` INT(11) NOT NULL,
57 `IdCurs` INT(11) NOT NULL,
58 INDEX `curs_fk_idx` (`IdCurs` ASC),
59 INDEX `curs_abonament__abonament_fk` (`IdAbonament` ASC),
60 CONSTRAINT `curs_abonament__abonament_fk`
61 FOREIGN KEY (`IdAbonament`)
62 REFERENCES `elephpants_new`.`abonament` (`AbonamentId`)
63 ON DELETE NO ACTION
64 ON UPDATE NO ACTION,
65 CONSTRAINT `curs_abonament__curs_fk`
66 FOREIGN KEY (`IdCurs`)
67 REFERENCES `elephpants_new`.`curs` (`CursId`)
68 ON DELETE NO ACTION
69 ON UPDATE NO ACTION)
70ENGINE = InnoDB
71DEFAULT CHARACTER SET = latin1;
72
73
74-- -----------------------------------------------------
75-- Table `elephpants_new`.`rol`
76-- -----------------------------------------------------
77CREATE TABLE IF NOT EXISTS `elephpants_new`.`rol` (
78 `RolId` INT(11) NOT NULL,
79 `Description` VARCHAR(255) CHARACTER SET 'utf8' NULL DEFAULT NULL,
80 PRIMARY KEY (`RolId`))
81ENGINE = InnoDB
82DEFAULT CHARACTER SET = utf8
83COLLATE = utf8_unicode_ci;
84
85
86-- -----------------------------------------------------
87-- Table `elephpants_new`.`user`
88-- -----------------------------------------------------
89CREATE TABLE IF NOT EXISTS `elephpants_new`.`user` (
90 `Username` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL,
91 `Password` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL,
92 `Email` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL,
93 `RolId` INT(11) NULL DEFAULT NULL,
94 PRIMARY KEY (`Username`),
95 UNIQUE INDEX `username_password` USING BTREE (`Username` ASC, `Password` ASC),
96 UNIQUE INDEX `UNIQ_8D93D64926535370` (`Email` ASC),
97 INDEX `user_rol_idx` (`RolId` ASC),
98 CONSTRAINT `user_rol`
99 FOREIGN KEY (`RolId`)
100 REFERENCES `elephpants_new`.`rol` (`RolId`)
101 ON DELETE NO ACTION
102 ON UPDATE NO ACTION)
103ENGINE = InnoDB
104DEFAULT CHARACTER SET = utf8
105COLLATE = utf8_unicode_ci;
106
107
108-- -----------------------------------------------------
109-- Table `elephpants_new`.`profile`
110-- -----------------------------------------------------
111CREATE TABLE IF NOT EXISTS `elephpants_new`.`profile` (
112 `ProfileId` INT(11) NOT NULL AUTO_INCREMENT,
113 `Username` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL,
114 `Sex` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL,
115 `Varsta` INT(11) NULL DEFAULT NULL,
116 `Fullname` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT NULL,
117 PRIMARY KEY (`ProfileId`),
118 INDEX `profile_user_idx` (`Username` ASC),
119 CONSTRAINT `profile_user`
120 FOREIGN KEY (`Username`)
121 REFERENCES `elephpants_new`.`user` (`Username`)
122 ON DELETE NO ACTION
123 ON UPDATE NO ACTION)
124ENGINE = InnoDB
125AUTO_INCREMENT = 4
126DEFAULT CHARACTER SET = utf8
127COLLATE = utf8_unicode_ci;
128
129
130-- -----------------------------------------------------
131-- Table `elephpants_new`.`schedule`
132-- -----------------------------------------------------
133CREATE TABLE IF NOT EXISTS `elephpants_new`.`schedule` (
134 `Id` INT(11) NOT NULL,
135 `IdCurs` INT(11) NOT NULL,
136 `StartDate` DATETIME NULL DEFAULT NULL,
137 `IdTrainer` INT(11) NOT NULL,
138 `WeekDay` INT(11) NULL DEFAULT NULL,
139 `StartTime` TIMESTAMP NULL DEFAULT NULL,
140 `EndTime` TIMESTAMP NULL DEFAULT NULL,
141 `PeriodStartDate` DATETIME NULL DEFAULT NULL,
142 `PeriodEndDate` DATETIME NULL DEFAULT NULL,
143 PRIMARY KEY (`Id`),
144 INDEX `schedule_curs_fk_idx` (`IdCurs` ASC),
145 INDEX `schedule_trainer_fk_idx` (`IdTrainer` ASC),
146 CONSTRAINT `schedule_curs_fk`
147 FOREIGN KEY (`IdCurs`)
148 REFERENCES `elephpants_new`.`curs` (`CursId`)
149 ON DELETE NO ACTION
150 ON UPDATE NO ACTION,
151 CONSTRAINT `schedule_trainer_fk`
152 FOREIGN KEY (`IdTrainer`)
153 REFERENCES `elephpants_new`.`profile` (`ProfileId`)
154 ON DELETE NO ACTION
155 ON UPDATE NO ACTION)
156ENGINE = InnoDB
157DEFAULT CHARACTER SET = latin1;
158
159
160-- -----------------------------------------------------
161-- Table `elephpants_new`.`evidentainscrieri`
162-- -----------------------------------------------------
163CREATE TABLE IF NOT EXISTS `elephpants_new`.`evidentainscrieri` (
164 `idevidentainscrieri` INT(11) NOT NULL AUTO_INCREMENT,
165 `ProfileId` INT(11) NULL DEFAULT NULL,
166 `ScheduleId` INT(11) NULL DEFAULT NULL,
167 PRIMARY KEY (`idevidentainscrieri`),
168 INDEX `evidenta_schedule_idx` (`ScheduleId` ASC),
169 INDEX `evidenta_profile_idx` (`ProfileId` ASC),
170 CONSTRAINT `evidenta_profile_fk`
171 FOREIGN KEY (`ProfileId`)
172 REFERENCES `elephpants_new`.`profile` (`ProfileId`)
173 ON DELETE NO ACTION
174 ON UPDATE NO ACTION,
175 CONSTRAINT `evidenta_schedule_fk`
176 FOREIGN KEY (`ScheduleId`)
177 REFERENCES `elephpants_new`.`schedule` (`Id`)
178 ON DELETE NO ACTION
179 ON UPDATE NO ACTION)
180ENGINE = InnoDB
181DEFAULT CHARACTER SET = utf8
182COLLATE = utf8_unicode_ci;
183
184
185-- -----------------------------------------------------
186-- Table `elephpants_new`.`feedback`
187-- -----------------------------------------------------
188CREATE TABLE IF NOT EXISTS `elephpants_new`.`feedback` (
189 `Id` INT(11) NOT NULL,
190 `EvaluatorId` INT(11) NULL DEFAULT NULL,
191 `EvaluatId` INT(11) NULL DEFAULT NULL,
192 `Text` VARCHAR(1000) NULL DEFAULT NULL,
193 `Rating` INT(11) NULL DEFAULT NULL,
194 PRIMARY KEY (`Id`),
195 INDEX `feedback_evaluator_fk_idx` (`EvaluatorId` ASC),
196 INDEX `feedback_evaluat_fk_idx` (`EvaluatId` ASC),
197 CONSTRAINT `feedback_evaluat_fk`
198 FOREIGN KEY (`EvaluatId`)
199 REFERENCES `elephpants_new`.`profile` (`ProfileId`)
200 ON DELETE NO ACTION
201 ON UPDATE NO ACTION,
202 CONSTRAINT `feedback_evaluator_fk`
203 FOREIGN KEY (`EvaluatorId`)
204 REFERENCES `elephpants_new`.`profile` (`ProfileId`)
205 ON DELETE NO ACTION
206 ON UPDATE NO ACTION)
207ENGINE = InnoDB
208DEFAULT CHARACTER SET = latin1;
209
210
211-- -----------------------------------------------------
212-- Table `elephpants_new`.`migration_versions`
213-- -----------------------------------------------------
214CREATE TABLE IF NOT EXISTS `elephpants_new`.`migration_versions` (
215 `version` VARCHAR(255) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL,
216 PRIMARY KEY (`version`))
217ENGINE = InnoDB
218DEFAULT CHARACTER SET = utf8
219COLLATE = utf8_unicode_ci;
220
221
222-- -----------------------------------------------------
223-- Table `elephpants_new`.`observatii_curs`
224-- -----------------------------------------------------
225CREATE TABLE IF NOT EXISTS `elephpants_new`.`observatii_curs` (
226 `Id` INT(11) NOT NULL,
227 `IdCurs` INT(11) NULL DEFAULT NULL,
228 `EvaluatorId` INT(11) NULL DEFAULT NULL,
229 `Text` VARCHAR(1000) NULL DEFAULT NULL,
230 `Rating` INT(11) NULL DEFAULT NULL,
231 PRIMARY KEY (`Id`),
232 INDEX `observatii_curs_curs_fk_idx` (`IdCurs` ASC),
233 INDEX `observatii_curs_evaluator_fk_idx` (`EvaluatorId` ASC),
234 CONSTRAINT `observatii_curs_curs_fk`
235 FOREIGN KEY (`IdCurs`)
236 REFERENCES `elephpants_new`.`curs` (`CursId`)
237 ON DELETE NO ACTION
238 ON UPDATE NO ACTION,
239 CONSTRAINT `observatii_curs_evaluator_fk`
240 FOREIGN KEY (`EvaluatorId`)
241 REFERENCES `elephpants_new`.`profile` (`ProfileId`)
242 ON DELETE NO ACTION
243 ON UPDATE NO ACTION)
244ENGINE = InnoDB
245DEFAULT CHARACTER SET = latin1;
246
247
248-- -----------------------------------------------------
249-- Table `elephpants_new`.`user_abonament`
250-- -----------------------------------------------------
251CREATE TABLE IF NOT EXISTS `elephpants_new`.`user_abonament` (
252 `IdUser` INT(11) NOT NULL,
253 `IdAbonament` INT(11) NOT NULL,
254 `AbonamentStartDate` DATETIME NULL DEFAULT NULL,
255 `AbonamentEndDate` DATETIME NULL DEFAULT NULL,
256 `Activ` INT(11) NULL DEFAULT NULL,
257 INDEX `user_abonament__abonament_fk_idx` (`IdAbonament` ASC),
258 INDEX `user_abonament__user_idx` (`IdUser` ASC),
259 CONSTRAINT `user_abonament__abonament_fk`
260 FOREIGN KEY (`IdAbonament`)
261 REFERENCES `elephpants_new`.`abonament` (`AbonamentId`)
262 ON DELETE NO ACTION
263 ON UPDATE NO ACTION,
264 CONSTRAINT `user_abonament__user_fk`
265 FOREIGN KEY (`IdUser`)
266 REFERENCES `elephpants_new`.`profile` (`ProfileId`)
267 ON DELETE NO ACTION
268 ON UPDATE NO ACTION)
269ENGINE = InnoDB
270DEFAULT CHARACTER SET = latin1;
271
272
273SET SQL_MODE=@OLD_SQL_MODE;
274SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
275SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;