· 8 years ago · May 16, 2018, 05:40 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 praktika
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema praktika
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `praktika` DEFAULT CHARACTER SET utf8 ;
18USE `praktika` ;
19
20-- -----------------------------------------------------
21-- Table `praktika`.`leidejas`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `praktika`.`leidejas` (
24 `pavadinimas` VARCHAR(45) NOT NULL,
25 `salis` VARCHAR(45) NULL DEFAULT NULL,
26 PRIMARY KEY (`pavadinimas`))
27ENGINE = InnoDB
28DEFAULT CHARACTER SET = utf8;
29
30
31-- -----------------------------------------------------
32-- Table `praktika`.`zaidimas`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `praktika`.`zaidimas` (
35 `id` INT(11) NOT NULL,
36 `leidejas` VARCHAR(45) NULL DEFAULT NULL,
37 `pavadinimas` VARCHAR(90) NULL DEFAULT NULL,
38 `aprasymas` MEDIUMTEXT NULL DEFAULT NULL,
39 `populiarumas` INT(11) NULL DEFAULT NULL,
40 `isleidimo_data` DATE NULL DEFAULT NULL,
41 PRIMARY KEY (`id`),
42 INDEX `fk_leidejas_idx` (`leidejas` ASC),
43 CONSTRAINT `fk_leidejas`
44 FOREIGN KEY (`leidejas`)
45 REFERENCES `praktika`.`leidejas` (`pavadinimas`)
46 ON DELETE NO ACTION
47 ON UPDATE NO ACTION)
48ENGINE = InnoDB
49DEFAULT CHARACTER SET = utf8;
50
51
52-- -----------------------------------------------------
53-- Table `praktika`.`dlc`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `praktika`.`dlc` (
56 `id` INT(11) NOT NULL,
57 `zaidimas` INT(11) NOT NULL,
58 `pavadinimas` VARCHAR(90) NULL DEFAULT NULL,
59 `isleidimo_data` DATE NULL DEFAULT NULL,
60 PRIMARY KEY (`id`, `zaidimas`),
61 INDEX `fk_zaidimas3_idx` (`zaidimas` ASC),
62 CONSTRAINT `fk_zaidimas3`
63 FOREIGN KEY (`zaidimas`)
64 REFERENCES `praktika`.`zaidimas` (`id`)
65 ON DELETE NO ACTION
66 ON UPDATE NO ACTION)
67ENGINE = InnoDB
68DEFAULT CHARACTER SET = utf8;
69
70
71-- -----------------------------------------------------
72-- Table `praktika`.`vartotojas`
73-- -----------------------------------------------------
74CREATE TABLE IF NOT EXISTS `praktika`.`vartotojas` (
75 `slapyvardis` VARCHAR(20) NOT NULL,
76 `el_pastas` VARCHAR(45) NOT NULL,
77 `slaptazodis` VARCHAR(45) NOT NULL,
78 `vardas` VARCHAR(45) NULL DEFAULT NULL,
79 `pavarde` VARCHAR(45) NULL DEFAULT NULL,
80 `adresas` VARCHAR(45) NULL DEFAULT NULL,
81 `saskaitos_likutis` INT(10) UNSIGNED ZEROFILL NULL DEFAULT NULL,
82 PRIMARY KEY (`slapyvardis`),
83 UNIQUE INDEX `slapyvardis_UNIQUE` (`slapyvardis` ASC),
84 UNIQUE INDEX `el_pastas_UNIQUE` (`el_pastas` ASC))
85ENGINE = InnoDB
86DEFAULT CHARACTER SET = utf8;
87
88
89-- -----------------------------------------------------
90-- Table `praktika`.`ivertinimas`
91-- -----------------------------------------------------
92CREATE TABLE IF NOT EXISTS `praktika`.`ivertinimas` (
93 `zaidimas` INT(11) NOT NULL,
94 `vartotojas` VARCHAR(20) NOT NULL,
95 `tekstas` TEXT NOT NULL,
96 `data` DATE NULL DEFAULT NULL,
97 `ivertinimas` INT(10) UNSIGNED NULL DEFAULT NULL,
98 PRIMARY KEY (`zaidimas`, `vartotojas`),
99 INDEX `fk_vartotojas3_idx` (`vartotojas` ASC),
100 CONSTRAINT `fk_vartotojas3`
101 FOREIGN KEY (`vartotojas`)
102 REFERENCES `praktika`.`vartotojas` (`slapyvardis`)
103 ON DELETE NO ACTION
104 ON UPDATE NO ACTION,
105 CONSTRAINT `fk_zaidimas5`
106 FOREIGN KEY (`zaidimas`)
107 REFERENCES `praktika`.`zaidimas` (`id`)
108 ON DELETE NO ACTION
109 ON UPDATE NO ACTION)
110ENGINE = InnoDB
111DEFAULT CHARACTER SET = utf8;
112
113
114-- -----------------------------------------------------
115-- Table `praktika`.`kaina`
116-- -----------------------------------------------------
117CREATE TABLE IF NOT EXISTS `praktika`.`kaina` (
118 `zaidimas` INT(11) NOT NULL,
119 `kaina` DECIMAL(8,2) UNSIGNED NULL DEFAULT NULL,
120 `nuolaida` INT(10) UNSIGNED ZEROFILL NULL DEFAULT NULL,
121 PRIMARY KEY (`zaidimas`),
122 UNIQUE INDEX `zaidimas_UNIQUE` (`zaidimas` ASC),
123 CONSTRAINT `fk_zaidimas`
124 FOREIGN KEY (`zaidimas`)
125 REFERENCES `praktika`.`zaidimas` (`id`)
126 ON DELETE NO ACTION
127 ON UPDATE NO ACTION)
128ENGINE = InnoDB
129DEFAULT CHARACTER SET = utf8;
130
131
132-- -----------------------------------------------------
133-- Table `praktika`.`kaina_dlc`
134-- -----------------------------------------------------
135CREATE TABLE IF NOT EXISTS `praktika`.`kaina_dlc` (
136 `dlc` INT(11) NOT NULL,
137 `kaina` DECIMAL(8,2) UNSIGNED NULL DEFAULT NULL,
138 `nuolaida` INT(11) NULL DEFAULT NULL,
139 PRIMARY KEY (`dlc`),
140 UNIQUE INDEX `dlc_UNIQUE` (`dlc` ASC),
141 CONSTRAINT `fk_dlc`
142 FOREIGN KEY (`dlc`)
143 REFERENCES `praktika`.`dlc` (`id`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION)
146ENGINE = InnoDB
147DEFAULT CHARACTER SET = utf8;
148
149
150-- -----------------------------------------------------
151-- Table `praktika`.`kategorija`
152-- -----------------------------------------------------
153CREATE TABLE IF NOT EXISTS `praktika`.`kategorija` (
154 `pavadinimas` VARCHAR(45) NOT NULL,
155 PRIMARY KEY (`pavadinimas`),
156 UNIQUE INDEX `pavadinimas_UNIQUE` (`pavadinimas` ASC))
157ENGINE = InnoDB
158DEFAULT CHARACTER SET = utf8;
159
160
161-- -----------------------------------------------------
162-- Table `praktika`.`kurejas`
163-- -----------------------------------------------------
164CREATE TABLE IF NOT EXISTS `praktika`.`kurejas` (
165 `pavadinimas` VARCHAR(45) NOT NULL,
166 `salis` VARCHAR(45) NULL DEFAULT NULL,
167 PRIMARY KEY (`pavadinimas`))
168ENGINE = InnoDB
169DEFAULT CHARACTER SET = utf8;
170
171
172-- -----------------------------------------------------
173-- Table `praktika`.`kurejo_zaidimai`
174-- -----------------------------------------------------
175CREATE TABLE IF NOT EXISTS `praktika`.`kurejo_zaidimai` (
176 `zaidimas` INT(11) NOT NULL,
177 `kurejas` VARCHAR(45) NOT NULL,
178 PRIMARY KEY (`zaidimas`, `kurejas`),
179 INDEX `fk_kurejas_idx` (`kurejas` ASC),
180 CONSTRAINT `fk_kurejas`
181 FOREIGN KEY (`kurejas`)
182 REFERENCES `praktika`.`kurejas` (`pavadinimas`)
183 ON DELETE NO ACTION
184 ON UPDATE NO ACTION,
185 CONSTRAINT `fk_zaidimas6`
186 FOREIGN KEY (`zaidimas`)
187 REFERENCES `praktika`.`zaidimas` (`id`)
188 ON DELETE NO ACTION
189 ON UPDATE NO ACTION)
190ENGINE = InnoDB
191DEFAULT CHARACTER SET = utf8;
192
193
194-- -----------------------------------------------------
195-- Table `praktika`.`pegi`
196-- -----------------------------------------------------
197CREATE TABLE IF NOT EXISTS `praktika`.`pegi` (
198 `zaidimas` INT(11) NOT NULL,
199 `rekomendacija` INT(11) NULL DEFAULT NULL,
200 `smurtas` TINYINT(1) UNSIGNED ZEROFILL NULL DEFAULT NULL,
201 `keiksmazodziai` TINYINT(1) UNSIGNED ZEROFILL NULL DEFAULT NULL,
202 `baime` TINYINT(1) UNSIGNED ZEROFILL NULL DEFAULT NULL,
203 `losimas` TINYINT(1) UNSIGNED ZEROFILL NULL DEFAULT NULL,
204 `nuogybes` TINYINT(1) UNSIGNED ZEROFILL NULL DEFAULT NULL,
205 `narkotikai` TINYINT(1) UNSIGNED ZEROFILL NULL DEFAULT NULL,
206 `diskriminacija` TINYINT(1) UNSIGNED ZEROFILL NULL DEFAULT NULL,
207 PRIMARY KEY (`zaidimas`),
208 CONSTRAINT `fk_zaidimas7`
209 FOREIGN KEY (`zaidimas`)
210 REFERENCES `praktika`.`zaidimas` (`id`)
211 ON DELETE NO ACTION
212 ON UPDATE NO ACTION)
213ENGINE = InnoDB
214DEFAULT CHARACTER SET = utf8;
215
216
217-- -----------------------------------------------------
218-- Table `praktika`.`vartotojo_dlc`
219-- -----------------------------------------------------
220CREATE TABLE IF NOT EXISTS `praktika`.`vartotojo_dlc` (
221 `vartotojas` VARCHAR(20) NOT NULL,
222 `dlc` INT(11) NOT NULL,
223 `pirktine_kaina` DECIMAL(8,2) NULL DEFAULT NULL,
224 PRIMARY KEY (`vartotojas`, `dlc`),
225 INDEX `fk_dlc2_idx` (`dlc` ASC),
226 CONSTRAINT `fk_dlc2`
227 FOREIGN KEY (`dlc`)
228 REFERENCES `praktika`.`dlc` (`id`)
229 ON DELETE NO ACTION
230 ON UPDATE NO ACTION,
231 CONSTRAINT `fk_vartotojas2`
232 FOREIGN KEY (`vartotojas`)
233 REFERENCES `praktika`.`vartotojas` (`slapyvardis`)
234 ON DELETE NO ACTION
235 ON UPDATE NO ACTION)
236ENGINE = InnoDB
237DEFAULT CHARACTER SET = utf8;
238
239
240-- -----------------------------------------------------
241-- Table `praktika`.`vartotojo_zaidimai`
242-- -----------------------------------------------------
243CREATE TABLE IF NOT EXISTS `praktika`.`vartotojo_zaidimai` (
244 `zaidimas` INT(11) NOT NULL,
245 `vartotojas` VARCHAR(20) NOT NULL,
246 `pirktine_kaina` DECIMAL(8,2) UNSIGNED NULL DEFAULT NULL,
247 `laikas` DATE NULL DEFAULT NULL,
248 PRIMARY KEY (`zaidimas`, `vartotojas`),
249 INDEX `fk_vartotojas_idx` (`vartotojas` ASC),
250 CONSTRAINT `fk_vartotojas`
251 FOREIGN KEY (`vartotojas`)
252 REFERENCES `praktika`.`vartotojas` (`slapyvardis`)
253 ON DELETE NO ACTION
254 ON UPDATE NO ACTION,
255 CONSTRAINT `fk_zaidimas4`
256 FOREIGN KEY (`zaidimas`)
257 REFERENCES `praktika`.`zaidimas` (`id`)
258 ON DELETE NO ACTION
259 ON UPDATE NO ACTION)
260ENGINE = InnoDB
261DEFAULT CHARACTER SET = utf8;
262
263
264-- -----------------------------------------------------
265-- Table `praktika`.`zaidimo_kategorija`
266-- -----------------------------------------------------
267CREATE TABLE IF NOT EXISTS `praktika`.`zaidimo_kategorija` (
268 `zaidimas` INT(11) NOT NULL,
269 `kategorija` VARCHAR(45) NOT NULL,
270 PRIMARY KEY (`zaidimas`, `kategorija`),
271 INDEX `fk_kategorija_idx` (`kategorija` ASC),
272 CONSTRAINT `fk_kategorija`
273 FOREIGN KEY (`kategorija`)
274 REFERENCES `praktika`.`kategorija` (`pavadinimas`)
275 ON DELETE NO ACTION
276 ON UPDATE NO ACTION,
277 CONSTRAINT `fk_zaidimas2`
278 FOREIGN KEY (`zaidimas`)
279 REFERENCES `praktika`.`zaidimas` (`id`)
280 ON DELETE NO ACTION
281 ON UPDATE NO ACTION)
282ENGINE = InnoDB
283DEFAULT CHARACTER SET = utf8;
284
285
286SET SQL_MODE=@OLD_SQL_MODE;
287SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
288SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;