· 9 years ago · Dec 18, 2016, 06:00 PM
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 Hearthstone
9-- -----------------------------------------------------
10DROP SCHEMA IF EXISTS `Hearthstone` ;
11
12-- -----------------------------------------------------
13-- Schema Hearthstone
14-- -----------------------------------------------------
15CREATE SCHEMA IF NOT EXISTS `Hearthstone` DEFAULT CHARACTER SET utf8 ;
16USE `Hearthstone` ;
17
18-- -----------------------------------------------------
19-- Table `Hearthstone`.`Karta`
20-- -----------------------------------------------------
21DROP TABLE IF EXISTS `Hearthstone`.`Karta` ;
22
23CREATE TABLE IF NOT EXISTS `Hearthstone`.`Karta` (
24 `id_Karte` INT NOT NULL AUTO_INCREMENT,
25 `naziv` VARCHAR(250) NOT NULL,
26 `kratak_opis` VARCHAR(250) NULL,
27 `klasa` VARCHAR(250) NULL,
28 PRIMARY KEY (`id_Karte`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `Hearthstone`.`Carolija`
34-- -----------------------------------------------------
35DROP TABLE IF EXISTS `Hearthstone`.`Carolija` ;
36
37CREATE TABLE IF NOT EXISTS `Hearthstone`.`Carolija` (
38 `id_Karte` INT NOT NULL,
39 `efekat` VARCHAR(45) NOT NULL,
40 PRIMARY KEY (`id_Karte`),
41 CONSTRAINT `fk_table1_Karta`
42 FOREIGN KEY (`id_Karte`)
43 REFERENCES `Hearthstone`.`Karta` (`id_Karte`)
44 ON DELETE CASCADE
45 ON UPDATE CASCADE)
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `Hearthstone`.`Oruzje`
51-- -----------------------------------------------------
52DROP TABLE IF EXISTS `Hearthstone`.`Oruzje` ;
53
54CREATE TABLE IF NOT EXISTS `Hearthstone`.`Oruzje` (
55 `id_Karte` INT NOT NULL,
56 `jacina` VARCHAR(45) NOT NULL,
57 `izdrzljivost` VARCHAR(45) NOT NULL,
58 PRIMARY KEY (`id_Karte`))
59ENGINE = InnoDB;
60
61
62-- -----------------------------------------------------
63-- Table `Hearthstone`.`Cudoviste`
64-- -----------------------------------------------------
65DROP TABLE IF EXISTS `Hearthstone`.`Cudoviste` ;
66
67CREATE TABLE IF NOT EXISTS `Hearthstone`.`Cudoviste` (
68 `id_Karte` INT NOT NULL,
69 `napad` VARCHAR(45) NOT NULL,
70 `odbrana` VARCHAR(45) NOT NULL,
71 `vrsta` VARCHAR(45) NOT NULL,
72 PRIMARY KEY (`id_Karte`),
73 CONSTRAINT `fk_table3_Karta1`
74 FOREIGN KEY (`id_Karte`)
75 REFERENCES `Hearthstone`.`Karta` (`id_Karte`)
76 ON DELETE CASCADE
77 ON UPDATE CASCADE)
78ENGINE = InnoDB;
79
80
81-- -----------------------------------------------------
82-- Table `Hearthstone`.`Pakovanje`
83-- -----------------------------------------------------
84DROP TABLE IF EXISTS `Hearthstone`.`Pakovanje` ;
85
86CREATE TABLE IF NOT EXISTS `Hearthstone`.`Pakovanje` (
87 `id_Pakovanja` INT NOT NULL AUTO_INCREMENT,
88 `cena` DOUBLE NOT NULL,
89 `broj_karata` INT NOT NULL,
90 PRIMARY KEY (`id_Pakovanja`))
91ENGINE = InnoDB;
92
93
94-- -----------------------------------------------------
95-- Table `Hearthstone`.`Igrac`
96-- -----------------------------------------------------
97DROP TABLE IF EXISTS `Hearthstone`.`Igrac` ;
98
99CREATE TABLE IF NOT EXISTS `Hearthstone`.`Igrac` (
100 `id_Igraca` INT NOT NULL AUTO_INCREMENT,
101 `ime` VARCHAR(45) NOT NULL,
102 PRIMARY KEY (`id_Igraca`))
103ENGINE = InnoDB;
104
105
106-- -----------------------------------------------------
107-- Table `Hearthstone`.`Kolekcija`
108-- -----------------------------------------------------
109DROP TABLE IF EXISTS `Hearthstone`.`Kolekcija` ;
110
111CREATE TABLE IF NOT EXISTS `Hearthstone`.`Kolekcija` (
112 `id_Igraca` INT NOT NULL,
113 `id_Karte` INT NOT NULL,
114 PRIMARY KEY (`id_Igraca`, `id_Karte`),
115 INDEX `fk_Kolekcija_Karta1_idx` (`id_Karte` ASC),
116 CONSTRAINT `fk_Kolekcija_Igrac1`
117 FOREIGN KEY (`id_Igraca`)
118 REFERENCES `Hearthstone`.`Igrac` (`id_Igraca`)
119 ON DELETE CASCADE
120 ON UPDATE CASCADE,
121 CONSTRAINT `fk_Kolekcija_Karta1`
122 FOREIGN KEY (`id_Karte`)
123 REFERENCES `Hearthstone`.`Karta` (`id_Karte`)
124 ON DELETE CASCADE
125 ON UPDATE CASCADE)
126ENGINE = InnoDB;
127
128
129-- -----------------------------------------------------
130-- Table `Hearthstone`.`Sadrzi`
131-- -----------------------------------------------------
132DROP TABLE IF EXISTS `Hearthstone`.`Sadrzi` ;
133
134CREATE TABLE IF NOT EXISTS `Hearthstone`.`Sadrzi` (
135 `id_Karte` INT NOT NULL,
136 `id_Pakovanja` INT NOT NULL,
137 PRIMARY KEY (`id_Karte`, `id_Pakovanja`),
138 INDEX `fk_Sadrzi_Pakovanje1_idx` (`id_Pakovanja` ASC),
139 CONSTRAINT `fk_Sadrzi_Karta1`
140 FOREIGN KEY (`id_Karte`)
141 REFERENCES `Hearthstone`.`Karta` (`id_Karte`)
142 ON DELETE CASCADE
143 ON UPDATE CASCADE,
144 CONSTRAINT `fk_Sadrzi_Pakovanje1`
145 FOREIGN KEY (`id_Pakovanja`)
146 REFERENCES `Hearthstone`.`Pakovanje` (`id_Pakovanja`)
147 ON DELETE CASCADE
148 ON UPDATE CASCADE)
149ENGINE = InnoDB;
150
151
152-- -----------------------------------------------------
153-- Table `Hearthstone`.`Kupovina`
154-- -----------------------------------------------------
155DROP TABLE IF EXISTS `Hearthstone`.`Kupovina` ;
156
157CREATE TABLE IF NOT EXISTS `Hearthstone`.`Kupovina` (
158 `id_Pakovanja` INT NOT NULL,
159 `id_Igraca` INT NOT NULL,
160 `cena` DOUBLE NOT NULL,
161 PRIMARY KEY (`id_Pakovanja`, `id_Igraca`),
162 INDEX `fk_Kupovina_Igrac1_idx` (`id_Igraca` ASC),
163 CONSTRAINT `fk_Kupovina_Pakovanje1`
164 FOREIGN KEY (`id_Pakovanja`)
165 REFERENCES `Hearthstone`.`Pakovanje` (`id_Pakovanja`)
166 ON DELETE CASCADE
167 ON UPDATE CASCADE,
168 CONSTRAINT `fk_Kupovina_Igrac1`
169 FOREIGN KEY (`id_Igraca`)
170 REFERENCES `Hearthstone`.`Igrac` (`id_Igraca`)
171 ON DELETE CASCADE
172 ON UPDATE CASCADE)
173ENGINE = InnoDB;
174
175
176-- -----------------------------------------------------
177-- Table `Hearthstone`.`Spil`
178-- -----------------------------------------------------
179DROP TABLE IF EXISTS `Hearthstone`.`Spil` ;
180
181CREATE TABLE IF NOT EXISTS `Hearthstone`.`Spil` (
182 `id_Spila` INT NOT NULL,
183 `id_Igraca` INT NOT NULL,
184 `id_Karte` INT NOT NULL,
185 PRIMARY KEY (`id_Spila`, `id_Igraca`, `id_Karte`),
186 INDEX `fk_Spil_Kolekcija1_idx` (`id_Igraca` ASC, `id_Karte` ASC),
187 CONSTRAINT `fk_Spil_Kolekcija1`
188 FOREIGN KEY (`id_Igraca` , `id_Karte`)
189 REFERENCES `Hearthstone`.`Kolekcija` (`id_Igraca` , `id_Karte`)
190 ON DELETE CASCADE
191 ON UPDATE CASCADE)
192ENGINE = InnoDB;
193
194
195-- -----------------------------------------------------
196-- Table `Hearthstone`.`Igra`
197-- -----------------------------------------------------
198DROP TABLE IF EXISTS `Hearthstone`.`Igra` ;
199
200CREATE TABLE IF NOT EXISTS `Hearthstone`.`Igra` (
201 `Spil1` INT NOT NULL,
202 `Igrac1` INT NOT NULL,
203 `Spil2` INT NOT NULL,
204 `Igrac2` INT NOT NULL,
205 `datum` DATE NOT NULL,
206 `pobednik` VARCHAR(45) NOT NULL,
207 PRIMARY KEY (`Spil1`, `Igrac1`, `Spil2`, `Igrac2`),
208 INDEX `fk_Igra_Spil1_idx` (`Spil2` ASC, `Igrac2` ASC),
209 CONSTRAINT `fk_table2_Spil1`
210 FOREIGN KEY (`Spil1` , `Igrac1`)
211 REFERENCES `Hearthstone`.`Spil` (`id_Spila` , `id_Igraca`)
212 ON DELETE CASCADE
213 ON UPDATE CASCADE,
214 CONSTRAINT `fk_Igra_Spil1`
215 FOREIGN KEY (`Spil2` , `Igrac2`)
216 REFERENCES `Hearthstone`.`Spil` (`id_Spila` , `id_Igraca`)
217 ON DELETE CASCADE
218 ON UPDATE CASCADE)
219ENGINE = InnoDB;
220
221
222SET SQL_MODE=@OLD_SQL_MODE;
223SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
224SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;