· 10 years ago · Sep 20, 2016, 09:12 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-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`scene`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`scene` (
21 `idscene` INT NOT NULL,
22 `name` VARCHAR(45) NULL,
23 `stage_size` MEDIUMINT(9) NULL,
24 PRIMARY KEY (`idscene`))
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `mydb`.`organizer`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `mydb`.`organizer` (
32 `idorganizer` INT NOT NULL,
33 `name` VARCHAR(45) NULL,
34 PRIMARY KEY (`idorganizer`))
35ENGINE = InnoDB;
36
37
38-- -----------------------------------------------------
39-- Table `mydb`.`concert`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `mydb`.`concert` (
42 `idconcert` INT NOT NULL,
43 `stardate` DATETIME(0) NULL,
44 `endate` DATETIME(0) NULL,
45 `genre` VARCHAR(45) NULL,
46 `tickets_available` INT(32) NULL,
47 `tickets_sold` INT(32) NULL,
48 `konsertcol` VARCHAR(45) NULL,
49 `scene_idscene` INT NOT NULL,
50 `organizer_idorganizer` INT NOT NULL,
51 PRIMARY KEY (`idconcert`, `scene_idscene`, `organizer_idorganizer`),
52 INDEX `fk_konsert_scene1_idx` (`scene_idscene` ASC),
53 INDEX `fk_konsert_organizer1_idx` (`organizer_idorganizer` ASC),
54 CONSTRAINT `fk_konsert_scene1`
55 FOREIGN KEY (`scene_idscene`)
56 REFERENCES `mydb`.`scene` (`idscene`)
57 ON DELETE NO ACTION
58 ON UPDATE NO ACTION,
59 CONSTRAINT `fk_konsert_organizer1`
60 FOREIGN KEY (`organizer_idorganizer`)
61 REFERENCES `mydb`.`organizer` (`idorganizer`)
62 ON DELETE NO ACTION
63 ON UPDATE NO ACTION)
64ENGINE = InnoDB;
65
66
67-- -----------------------------------------------------
68-- Table `mydb`.`artist`
69-- -----------------------------------------------------
70CREATE TABLE IF NOT EXISTS `mydb`.`artist` (
71 `idartist` INT NOT NULL,
72 `name` TEXT NULL,
73 PRIMARY KEY (`idartist`))
74ENGINE = InnoDB;
75
76
77-- -----------------------------------------------------
78-- Table `mydb`.`concert_in_norway`
79-- -----------------------------------------------------
80CREATE TABLE IF NOT EXISTS `mydb`.`concert_in_norway` (
81 `idconcert_in_norway` INT NOT NULL,
82 PRIMARY KEY (`idconcert_in_norway`))
83ENGINE = InnoDB;
84
85
86-- -----------------------------------------------------
87-- Table `mydb`.`technical`
88-- -----------------------------------------------------
89CREATE TABLE IF NOT EXISTS `mydb`.`technical` (
90 `idtechnical` INT NOT NULL,
91 PRIMARY KEY (`idtechnical`))
92ENGINE = InnoDB;
93
94
95-- -----------------------------------------------------
96-- Table `mydb`.`album`
97-- -----------------------------------------------------
98CREATE TABLE IF NOT EXISTS `mydb`.`album` (
99 `idalbum` INT NOT NULL,
100 `artist_idartist` INT NOT NULL,
101 PRIMARY KEY (`idalbum`, `artist_idartist`),
102 INDEX `fk_album_artist1_idx` (`artist_idartist` ASC),
103 CONSTRAINT `fk_album_artist1`
104 FOREIGN KEY (`artist_idartist`)
105 REFERENCES `mydb`.`artist` (`idartist`)
106 ON DELETE NO ACTION
107 ON UPDATE NO ACTION)
108ENGINE = InnoDB;
109
110
111-- -----------------------------------------------------
112-- Table `mydb`.`bookingboss`
113-- -----------------------------------------------------
114CREATE TABLE IF NOT EXISTS `mydb`.`bookingboss` (
115 `idbookingboss` INT NOT NULL,
116 PRIMARY KEY (`idbookingboss`))
117ENGINE = InnoDB;
118
119
120-- -----------------------------------------------------
121-- Table `mydb`.`booking`
122-- -----------------------------------------------------
123CREATE TABLE IF NOT EXISTS `mydb`.`booking` (
124 `idbooking` INT NOT NULL,
125 PRIMARY KEY (`idbooking`))
126ENGINE = InnoDB;
127
128
129-- -----------------------------------------------------
130-- Table `mydb`.`offer`
131-- -----------------------------------------------------
132CREATE TABLE IF NOT EXISTS `mydb`.`offer` (
133 `idoffer` INT NOT NULL,
134 `artist_idartist` INT NOT NULL,
135 `bookingboss_idbookingboss` INT NOT NULL,
136 `booking_idbooking` INT NOT NULL,
137 PRIMARY KEY (`idoffer`, `artist_idartist`, `bookingboss_idbookingboss`, `booking_idbooking`),
138 INDEX `fk_tilbud_artist1_idx` (`artist_idartist` ASC),
139 INDEX `fk_offer_bookingboss1_idx` (`bookingboss_idbookingboss` ASC),
140 INDEX `fk_offer_booking1_idx` (`booking_idbooking` ASC),
141 CONSTRAINT `fk_tilbud_artist1`
142 FOREIGN KEY (`artist_idartist`)
143 REFERENCES `mydb`.`artist` (`idartist`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION,
146 CONSTRAINT `fk_offer_bookingboss1`
147 FOREIGN KEY (`bookingboss_idbookingboss`)
148 REFERENCES `mydb`.`bookingboss` (`idbookingboss`)
149 ON DELETE NO ACTION
150 ON UPDATE NO ACTION,
151 CONSTRAINT `fk_offer_booking1`
152 FOREIGN KEY (`booking_idbooking`)
153 REFERENCES `mydb`.`booking` (`idbooking`)
154 ON DELETE NO ACTION
155 ON UPDATE NO ACTION)
156ENGINE = InnoDB;
157
158
159-- -----------------------------------------------------
160-- Table `mydb`.`artist_has_concert_in_norway`
161-- -----------------------------------------------------
162CREATE TABLE IF NOT EXISTS `mydb`.`artist_has_concert_in_norway` (
163 `artist_idartist` INT NOT NULL,
164 `concert_in_norway_idconcert_in_norway` INT NOT NULL,
165 PRIMARY KEY (`artist_idartist`, `concert_in_norway_idconcert_in_norway`),
166 INDEX `fk_artist_has_concert_in_norway_concert_in_norway1_idx` (`concert_in_norway_idconcert_in_norway` ASC),
167 INDEX `fk_artist_has_concert_in_norway_artist1_idx` (`artist_idartist` ASC),
168 CONSTRAINT `fk_artist_has_concert_in_norway_artist1`
169 FOREIGN KEY (`artist_idartist`)
170 REFERENCES `mydb`.`artist` (`idartist`)
171 ON DELETE NO ACTION
172 ON UPDATE NO ACTION,
173 CONSTRAINT `fk_artist_has_concert_in_norway_concert_in_norway1`
174 FOREIGN KEY (`concert_in_norway_idconcert_in_norway`)
175 REFERENCES `mydb`.`concert_in_norway` (`idconcert_in_norway`)
176 ON DELETE NO ACTION
177 ON UPDATE NO ACTION)
178ENGINE = InnoDB;
179
180
181-- -----------------------------------------------------
182-- Table `mydb`.`technicaltask`
183-- -----------------------------------------------------
184CREATE TABLE IF NOT EXISTS `mydb`.`technicaltask` (
185 `idtechnicaltask` INT NOT NULL,
186 `description` MEDIUMTEXT NULL,
187 `technicaltaskcol` VARCHAR(45) NULL,
188 PRIMARY KEY (`idtechnicaltask`))
189ENGINE = InnoDB;
190
191
192-- -----------------------------------------------------
193-- Table `mydb`.`concert_has_technical`
194-- -----------------------------------------------------
195CREATE TABLE IF NOT EXISTS `mydb`.`concert_has_technical` (
196 `concert_idconcert` INT NOT NULL,
197 `technical_idtechnical` INT NOT NULL,
198 `technicaltask_idtechnicaltask` INT NOT NULL,
199 `work_start` DATETIME(0) NULL,
200 `work_end` DATETIME(0) NULL,
201 PRIMARY KEY (`concert_idconcert`, `technical_idtechnical`, `technicaltask_idtechnicaltask`),
202 INDEX `fk_concert_has_technical_technical1_idx` (`technical_idtechnical` ASC),
203 INDEX `fk_concert_has_technical_concert1_idx` (`concert_idconcert` ASC),
204 INDEX `fk_concert_has_technical_technicaltask1_idx` (`technicaltask_idtechnicaltask` ASC),
205 CONSTRAINT `fk_concert_has_technical_concert1`
206 FOREIGN KEY (`concert_idconcert`)
207 REFERENCES `mydb`.`concert` (`idconcert`)
208 ON DELETE NO ACTION
209 ON UPDATE NO ACTION,
210 CONSTRAINT `fk_concert_has_technical_technical1`
211 FOREIGN KEY (`technical_idtechnical`)
212 REFERENCES `mydb`.`technical` (`idtechnical`)
213 ON DELETE NO ACTION
214 ON UPDATE NO ACTION,
215 CONSTRAINT `fk_concert_has_technical_technicaltask1`
216 FOREIGN KEY (`technicaltask_idtechnicaltask`)
217 REFERENCES `mydb`.`technicaltask` (`idtechnicaltask`)
218 ON DELETE NO ACTION
219 ON UPDATE NO ACTION)
220ENGINE = InnoDB;
221
222
223-- -----------------------------------------------------
224-- Table `mydb`.`concert_has_artist`
225-- -----------------------------------------------------
226CREATE TABLE IF NOT EXISTS `mydb`.`concert_has_artist` (
227 `concert_idconcert` INT NOT NULL,
228 `artist_idartist` INT NOT NULL,
229 PRIMARY KEY (`concert_idconcert`, `artist_idartist`),
230 INDEX `fk_concert_has_artist_artist1_idx` (`artist_idartist` ASC),
231 INDEX `fk_concert_has_artist_concert1_idx` (`concert_idconcert` ASC),
232 CONSTRAINT `fk_concert_has_artist_concert1`
233 FOREIGN KEY (`concert_idconcert`)
234 REFERENCES `mydb`.`concert` (`idconcert`)
235 ON DELETE NO ACTION
236 ON UPDATE NO ACTION,
237 CONSTRAINT `fk_concert_has_artist_artist1`
238 FOREIGN KEY (`artist_idartist`)
239 REFERENCES `mydb`.`artist` (`idartist`)
240 ON DELETE NO ACTION
241 ON UPDATE NO ACTION)
242ENGINE = InnoDB;
243
244
245SET SQL_MODE=@OLD_SQL_MODE;
246SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
247SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;