83pKNBXH

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 skft
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema skft
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `skft` DEFAULT CHARACTER SET utf8 ;
15USE `skft` ;
16
17-- -----------------------------------------------------
18-- Table `skft`.`User`
19-- -----------------------------------------------------
20DROP TABLE IF EXISTS `skft`.`User` ;
21
22CREATE TABLE IF NOT EXISTS `skft`.`User` (
23  `idUser` INT NOT NULL AUTO_INCREMENT,
24  `Name` VARCHAR(60) NOT NULL,
25  `Password` VARCHAR(256) NOT NULL,
26  `Phonenumber` VARCHAR(15) NULL,
27  `Email` VARCHAR(60) NOT NULL,
28  PRIMARY KEY (`idUser`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `skft`.`Event`
34-- -----------------------------------------------------
35DROP TABLE IF EXISTS `skft`.`Event` ;
36
37CREATE TABLE IF NOT EXISTS `skft`.`Event` (
38  `idEvent` INT NOT NULL AUTO_INCREMENT,
39  `Name` VARCHAR(100) NOT NULL,
40  `Street_Address` VARCHAR(60) NOT NULL,
41  `Post_Number` INT NOT NULL,
42  `City` VARCHAR(60) NOT NULL,
43  `Date` DATETIME NOT NULL,
44  `Description` VARCHAR(100) NULL DEFAULT '',
45  `Information` TEXT(10000) NOT NULL,
46  PRIMARY KEY (`idEvent`))
47ENGINE = InnoDB
48COMMENT = '\n'
49INSERT_METHOD = NO;
50
51
52-- -----------------------------------------------------
53-- Table `skft`.`eventUser`
54-- -----------------------------------------------------
55DROP TABLE IF EXISTS `skft`.`eventUser` ;
56
57CREATE TABLE IF NOT EXISTS `skft`.`eventUser` (
58  `Event_eventUser_fk` INT NOT NULL,
59  `User_eventUser_fk` INT NOT NULL,
60  PRIMARY KEY (`Event_eventUser_fk`, `User_eventUser_fk`),
61  CONSTRAINT `Event_eventUser_fk`
62    FOREIGN KEY (`Event_eventUser_fk`)
63    REFERENCES `skft`.`Event` (`idEvent`)
64    ON DELETE RESTRICT
65    ON UPDATE CASCADE,
66  CONSTRAINT `User_eventUser_fk`
67    FOREIGN KEY (`User_eventUser_fk`)
68    REFERENCES `skft`.`User` (`idUser`)
69    ON DELETE RESTRICT
70    ON UPDATE CASCADE)
71ENGINE = InnoDB;
72
73CREATE INDEX `Event_eventUser_fk_idx` ON `skft`.`eventUser` (`User_eventUser_fk` ASC);
74
75CREATE INDEX `User_eventUser_fk_idx` ON `skft`.`eventUser` (`Event_eventUser_fk` ASC);
76
77
78-- -----------------------------------------------------
79-- Table `skft`.`Organizer`
80-- -----------------------------------------------------
81DROP TABLE IF EXISTS `skft`.`Organizer` ;
82
83CREATE TABLE IF NOT EXISTS `skft`.`Organizer` (
84  `idOrganizer` INT NOT NULL AUTO_INCREMENT,
85  `Name` VARCHAR(60) NOT NULL,
86  `Organizer_User_fk` INT NOT NULL,
87  PRIMARY KEY (`idOrganizer`, `Organizer_User_fk`),
88  CONSTRAINT `Organizer_User_fk`
89    FOREIGN KEY (`Organizer_User_fk`)
90    REFERENCES `skft`.`User` (`idUser`)
91    ON DELETE RESTRICT
92    ON UPDATE CASCADE)
93ENGINE = InnoDB;
94
95CREATE INDEX `Organizer_User_fk_idx` ON `skft`.`Organizer` (`Organizer_User_fk` ASC);
96
97
98-- -----------------------------------------------------
99-- Table `skft`.`eventOrganizer`
100-- -----------------------------------------------------
101DROP TABLE IF EXISTS `skft`.`eventOrganizer` ;
102
103CREATE TABLE IF NOT EXISTS `skft`.`eventOrganizer` (
104  `Event_eventOrganizer_fk` INT NOT NULL,
105  `Organizer_eventOrganizer_fk` INT NOT NULL,
106  PRIMARY KEY (`Organizer_eventOrganizer_fk`, `Event_eventOrganizer_fk`),
107  CONSTRAINT `Event_eventOrganizer_fk`
108    FOREIGN KEY (`Event_eventOrganizer_fk`)
109    REFERENCES `skft`.`Event` (`idEvent`)
110    ON DELETE RESTRICT
111    ON UPDATE CASCADE,
112  CONSTRAINT `Organizer_eventOrganizer_fk`
113    FOREIGN KEY (`Organizer_eventOrganizer_fk`)
114    REFERENCES `skft`.`Organizer` (`idOrganizer`)
115    ON DELETE RESTRICT
116    ON UPDATE CASCADE)
117ENGINE = InnoDB;
118
119CREATE INDEX `Event_eventOrganizer_fk_idx` ON `skft`.`eventOrganizer` (`Organizer_eventOrganizer_fk` ASC);
120
121CREATE INDEX `Organizer_eventOrganizer_fk_idx` ON `skft`.`eventOrganizer` (`Event_eventOrganizer_fk` ASC);
122
123
124SET SQL_MODE=@OLD_SQL_MODE;
125SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
126SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;