· 8 years ago · Jun 05, 2018, 02:16 PM
1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4
5-- -----------------------------------------------------
6-- Schema mydb
7-- -----------------------------------------------------
8-- -----------------------------------------------------
9-- Schema tpo
10-- -----------------------------------------------------
11DROP SCHEMA IF EXISTS `tpo` ;
12
13-- -----------------------------------------------------
14-- Schema tpo
15-- -----------------------------------------------------
16CREATE SCHEMA IF NOT EXISTS `tpo` DEFAULT CHARACTER SET utf8 ;
17USE `tpo` ;
18
19-- -----------------------------------------------------
20-- Table `tpo`.`del_predmetnika`
21-- -----------------------------------------------------
22DROP TABLE IF EXISTS `tpo`.`del_predmetnika` ;
23
24CREATE TABLE IF NOT EXISTS `tpo`.`del_predmetnika` (
25 `ID_DELPREDMETNIKA` INT(11) NOT NULL AUTO_INCREMENT,
26 `NAZIV_DELAPREDMETNIKA` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
27 `SKUPNOSTEVILOKT` INT(11) NOT NULL,
28 `TIP` CHAR(2) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
29 `AKTIVNOST` INT(11) NOT NULL,
30 PRIMARY KEY (`ID_DELPREDMETNIKA`))
31 ENGINE = InnoDB
32 AUTO_INCREMENT = 13
33 DEFAULT CHARACTER SET = utf8
34 COLLATE = utf8_slovenian_ci;
35
36
37-- -----------------------------------------------------
38-- Table `tpo`.`drzava`
39-- -----------------------------------------------------
40DROP TABLE IF EXISTS `tpo`.`drzava` ;
41
42CREATE TABLE IF NOT EXISTS `tpo`.`drzava` (
43 `ID_DRZAVA` INT(11) NOT NULL AUTO_INCREMENT,
44 `DVOMESTNAKODA` CHAR(2) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
45 `TRIMESTNAKODA` CHAR(3) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
46 `ISONAZIV` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
47 `SLOVENSKINAZIV` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
48 `OPOMBA` CHAR(200) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
49 `AKTIVNOST` INT(11) NOT NULL,
50 PRIMARY KEY (`ID_DRZAVA`))
51 ENGINE = InnoDB
52 AUTO_INCREMENT = 895
53 DEFAULT CHARACTER SET = utf8
54 COLLATE = utf8_slovenian_ci;
55
56
57-- -----------------------------------------------------
58-- Table `tpo`.`predmet`
59-- -----------------------------------------------------
60DROP TABLE IF EXISTS `tpo`.`predmet` ;
61
62CREATE TABLE IF NOT EXISTS `tpo`.`predmet` (
63 `ID_PREDMET` INT(11) NOT NULL AUTO_INCREMENT,
64 `SIFRA_PREDMET` INT(11) NOT NULL,
65 `IME_PREDMET` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
66 `AKTIVNOST` INT(11) NOT NULL,
67 `ST_KREDITNIH_TOCK` INT(11) NOT NULL DEFAULT '6',
68 PRIMARY KEY (`ID_PREDMET`))
69 ENGINE = InnoDB
70 AUTO_INCREMENT = 63
71 DEFAULT CHARACTER SET = utf8
72 COLLATE = utf8_slovenian_ci;
73
74
75-- -----------------------------------------------------
76-- Table `tpo`.`studijsko_leto`
77-- -----------------------------------------------------
78DROP TABLE IF EXISTS `tpo`.`studijsko_leto` ;
79
80CREATE TABLE IF NOT EXISTS `tpo`.`studijsko_leto` (
81 `ID_STUD_LETO` INT(11) NOT NULL AUTO_INCREMENT,
82 `STUD_LETO` CHAR(10) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
83 PRIMARY KEY (`ID_STUD_LETO`))
84 ENGINE = InnoDB
85 AUTO_INCREMENT = 9
86 DEFAULT CHARACTER SET = utf8
87 COLLATE = utf8_slovenian_ci;
88
89
90-- -----------------------------------------------------
91-- Table `tpo`.`oseba`
92-- -----------------------------------------------------
93DROP TABLE IF EXISTS `tpo`.`oseba` ;
94
95CREATE TABLE IF NOT EXISTS `tpo`.`oseba` (
96 `ID_OSEBA` INT(11) NOT NULL AUTO_INCREMENT,
97 `IME` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
98 `PRIIMEK` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
99 `SIFRA_IZVAJALCA` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
100 `EMAIL` CHAR(30) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
101 `UPORABNISKO_IME` CHAR(10) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL ,
102 `GESLO` CHAR(60) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
103 `VRSTA_VLOGE` CHAR(1) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
104 `TELEFONSKA_STEVILKA` CHAR(20) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
105 `resetPwToken` VARCHAR(40) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
106 `resetPwExpiration` INT(11) NULL DEFAULT NULL,
107 `resetPwUsed` TINYINT(1) NULL DEFAULT NULL,
108 PRIMARY KEY (`ID_OSEBA`))
109 ENGINE = InnoDB
110 AUTO_INCREMENT = 40
111 DEFAULT CHARACTER SET = utf8
112 COLLATE = utf8_slovenian_ci;
113
114CREATE UNIQUE INDEX `EMAIL_UNIQUE` ON `tpo`.`oseba` (`EMAIL` ASC);
115
116
117-- -----------------------------------------------------
118-- Table `tpo`.`izvedba_predmeta`
119-- -----------------------------------------------------
120DROP TABLE IF EXISTS `tpo`.`izvedba_predmeta` ;
121
122CREATE TABLE IF NOT EXISTS `tpo`.`izvedba_predmeta` (
123 `ID_IZVEDBA` INT(11) NOT NULL AUTO_INCREMENT,
124 `ID_STUD_LETO` INT(11) NOT NULL,
125 `ID_OSEBA1` INT(11) NOT NULL,
126 `ID_OSEBA2` INT(11) NULL DEFAULT NULL,
127 `ID_OSEBA3` INT(11) NULL DEFAULT NULL,
128 `ID_PREDMET` INT(11) NOT NULL,
129 PRIMARY KEY (`ID_IZVEDBA`),
130 CONSTRAINT `FK_RELATIONSHIP_18`
131 FOREIGN KEY (`ID_PREDMET`)
132 REFERENCES `tpo`.`predmet` (`ID_PREDMET`),
133 CONSTRAINT `FK_RELATIONSHIP_19`
134 FOREIGN KEY (`ID_STUD_LETO`)
135 REFERENCES `tpo`.`studijsko_leto` (`ID_STUD_LETO`),
136 CONSTRAINT `Je_UCITELJ1`
137 FOREIGN KEY (`ID_OSEBA1`)
138 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
139 CONSTRAINT `Je_UCITELJ2`
140 FOREIGN KEY (`ID_OSEBA2`)
141 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
142 CONSTRAINT `Je_UCITELJ3`
143 FOREIGN KEY (`ID_OSEBA3`)
144 REFERENCES `tpo`.`oseba` (`ID_OSEBA`))
145 ENGINE = InnoDB
146 AUTO_INCREMENT = 28
147 DEFAULT CHARACTER SET = utf8
148 COLLATE = utf8_slovenian_ci;
149
150CREATE INDEX `FK_RELATIONSHIP_18` ON `tpo`.`izvedba_predmeta` (`ID_PREDMET` ASC);
151
152CREATE INDEX `FK_RELATIONSHIP_19` ON `tpo`.`izvedba_predmeta` (`ID_STUD_LETO` ASC);
153
154CREATE INDEX `2131_idx` ON `tpo`.`izvedba_predmeta` (`ID_OSEBA1` ASC);
155
156CREATE INDEX `Je_UCITELJ2_idx` ON `tpo`.`izvedba_predmeta` (`ID_OSEBA2` ASC);
157
158CREATE INDEX `Je_UCITELJ3_idx` ON `tpo`.`izvedba_predmeta` (`ID_OSEBA3` ASC);
159
160
161-- -----------------------------------------------------
162-- Table `tpo`.`stopnja`
163-- -----------------------------------------------------
164DROP TABLE IF EXISTS `tpo`.`stopnja` ;
165
166CREATE TABLE IF NOT EXISTS `tpo`.`stopnja` (
167 `ID_STOPNJA` INT(11) NOT NULL AUTO_INCREMENT,
168 `NAZIV` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
169 `MOZEN_VPIS` INT(11) NOT NULL,
170 `SIFRA` CHAR(10) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
171 PRIMARY KEY (`ID_STOPNJA`))
172 ENGINE = InnoDB
173 AUTO_INCREMENT = 9
174 DEFAULT CHARACTER SET = utf8
175 COLLATE = utf8_slovenian_ci;
176
177
178-- -----------------------------------------------------
179-- Table `tpo`.`program`
180-- -----------------------------------------------------
181DROP TABLE IF EXISTS `tpo`.`program` ;
182
183CREATE TABLE IF NOT EXISTS `tpo`.`program` (
184 `ID_PROGRAM` INT(11) NOT NULL AUTO_INCREMENT,
185 `ID_STOPNJA` INT(11) NOT NULL,
186 `SIFRA_PROGRAM` CHAR(15) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
187 `NAZIV_PROGRAM` CHAR(100) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
188 `ST_SEMESTROV` INT(11) NOT NULL,
189 `SIFRA_EVS` INT(11) NULL DEFAULT NULL,
190 `AKTIVNOST` INT(11) NOT NULL,
191 PRIMARY KEY (`ID_PROGRAM`),
192 CONSTRAINT `FK_STOPNJA`
193 FOREIGN KEY (`ID_STOPNJA`)
194 REFERENCES `tpo`.`stopnja` (`ID_STOPNJA`))
195 ENGINE = InnoDB
196 AUTO_INCREMENT = 21
197 DEFAULT CHARACTER SET = utf8
198 COLLATE = utf8_slovenian_ci;
199
200CREATE INDEX `FK_STOPNJA_idx` ON `tpo`.`program` (`ID_STOPNJA` ASC);
201
202
203-- -----------------------------------------------------
204-- Table `tpo`.`kandidat`
205-- -----------------------------------------------------
206DROP TABLE IF EXISTS `tpo`.`kandidat` ;
207
208CREATE TABLE IF NOT EXISTS `tpo`.`kandidat` (
209 `ID_KANDIDAT` INT(11) NOT NULL AUTO_INCREMENT,
210 `ID_PROGRAM` INT(11) NOT NULL,
211 `ID_OSEBA` INT(11) NOT NULL,
212 `ID_STUD_LETO` INT(11) NOT NULL,
213 `IZKORISCEN` INT(11) NOT NULL,
214 `EMSO` CHAR(13) NULL DEFAULT NULL,
215 `VPISNA_STEVILKA` INT(11) NULL DEFAULT NULL,
216 PRIMARY KEY (`ID_KANDIDAT`),
217 CONSTRAINT `FK_OSEBAID`
218 FOREIGN KEY (`ID_OSEBA`)
219 REFERENCES `tpo`.`oseba` (`ID_OSEBA`)
220 ON DELETE NO ACTION
221 ON UPDATE NO ACTION,
222 CONSTRAINT `FK_PROGRAM_2`
223 FOREIGN KEY (`ID_PROGRAM`)
224 REFERENCES `tpo`.`program` (`ID_PROGRAM`)
225 ON DELETE NO ACTION
226 ON UPDATE NO ACTION,
227 CONSTRAINT `FK_STUDLETOID`
228 FOREIGN KEY (`ID_STUD_LETO`)
229 REFERENCES `tpo`.`studijsko_leto` (`ID_STUD_LETO`)
230 ON DELETE NO ACTION
231 ON UPDATE NO ACTION)
232 ENGINE = InnoDB
233 AUTO_INCREMENT = 4
234 DEFAULT CHARACTER SET = utf8
235 COLLATE = utf8_slovenian_ci;
236
237CREATE INDEX `FK_PROGRAM_idx` ON `tpo`.`kandidat` (`ID_PROGRAM` ASC);
238
239CREATE INDEX `FK_OSEBAID_idx` ON `tpo`.`kandidat` (`ID_OSEBA` ASC);
240
241CREATE INDEX `FK_STUDLETOID_idx` ON `tpo`.`kandidat` (`ID_STUD_LETO` ASC);
242
243
244-- -----------------------------------------------------
245-- Table `tpo`.`letnik`
246-- -----------------------------------------------------
247DROP TABLE IF EXISTS `tpo`.`letnik` ;
248
249CREATE TABLE IF NOT EXISTS `tpo`.`letnik` (
250 `ID_LETNIK` INT(11) NOT NULL AUTO_INCREMENT,
251 `LETNIK` INT(11) NOT NULL,
252 PRIMARY KEY (`ID_LETNIK`))
253 ENGINE = InnoDB
254 AUTO_INCREMENT = 4
255 DEFAULT CHARACTER SET = utf8
256 COLLATE = utf8_slovenian_ci;
257
258
259-- -----------------------------------------------------
260-- Table `tpo`.`nacin_studija`
261-- -----------------------------------------------------
262DROP TABLE IF EXISTS `tpo`.`nacin_studija` ;
263
264CREATE TABLE IF NOT EXISTS `tpo`.`nacin_studija` (
265 `ID_NACIN` INT(11) NOT NULL AUTO_INCREMENT,
266 `OPIS_NACIN` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
267 `ANG_OPIS_NACIN` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
268 `AKTIVNOST` INT(11) NOT NULL,
269 PRIMARY KEY (`ID_NACIN`))
270 ENGINE = InnoDB
271 AUTO_INCREMENT = 3
272 DEFAULT CHARACTER SET = utf8
273 COLLATE = utf8_slovenian_ci;
274
275
276-- -----------------------------------------------------
277-- Table `tpo`.`posta`
278-- -----------------------------------------------------
279DROP TABLE IF EXISTS `tpo`.`posta` ;
280
281CREATE TABLE IF NOT EXISTS `tpo`.`posta` (
282 `ID_POSTA` INT(11) NOT NULL AUTO_INCREMENT,
283 `ST_POSTA` CHAR(4) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
284 `KRAJ` CHAR(30) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
285 `AKTIVNOST` INT(11) NOT NULL,
286 `MID_POSTA` INT(11) NULL,
287 PRIMARY KEY (`ID_POSTA`))
288 ENGINE = InnoDB
289 AUTO_INCREMENT = 470
290 DEFAULT CHARACTER SET = utf8
291 COLLATE = utf8_slovenian_ci;
292
293
294-- -----------------------------------------------------
295-- Table `tpo`.`obcina`
296-- -----------------------------------------------------
297DROP TABLE IF EXISTS `tpo`.`obcina` ;
298
299CREATE TABLE IF NOT EXISTS `tpo`.`obcina` (
300 `ID_OBCINA` INT(11) NOT NULL AUTO_INCREMENT,
301 `IME_OBCINA` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
302 `AKTIVNOST` INT(11) NULL DEFAULT NULL,
303 `MID_OBCINA` INT(11) NULL,
304 PRIMARY KEY (`ID_OBCINA`))
305 ENGINE = InnoDB
306 AUTO_INCREMENT = 214
307 DEFAULT CHARACTER SET = utf8
308 COLLATE = utf8_slovenian_ci;
309
310
311-- -----------------------------------------------------
312-- Table `tpo`.`naslov`
313-- -----------------------------------------------------
314DROP TABLE IF EXISTS `tpo`.`naslov` ;
315
316CREATE TABLE IF NOT EXISTS `tpo`.`naslov` (
317 `ID_NASLOV` INT(11) NOT NULL AUTO_INCREMENT,
318 `ID_POSTA` INT(11) NULL DEFAULT NULL,
319 `ID_OBCINA` INT(11) NULL DEFAULT NULL,
320 `ID_DRZAVA` INT(11) NULL DEFAULT NULL,
321 `ID_OSEBA` INT(11) NULL DEFAULT NULL,
322 `JE_ZAVROCANJE` INT(11) NULL DEFAULT NULL,
323 `JE_STALNI` INT(11) NULL DEFAULT NULL,
324 `ULICA` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
325 PRIMARY KEY (`ID_NASLOV`),
326 CONSTRAINT `FK_RELATIONSHIP_30`
327 FOREIGN KEY (`ID_POSTA`)
328 REFERENCES `tpo`.`posta` (`ID_POSTA`),
329 CONSTRAINT `FK_RELATIONSHIP_31`
330 FOREIGN KEY (`ID_OBCINA`)
331 REFERENCES `tpo`.`obcina` (`ID_OBCINA`),
332 CONSTRAINT `FK_RELATIONSHIP_32`
333 FOREIGN KEY (`ID_OSEBA`)
334 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
335 CONSTRAINT `FK_RELATIONSHIP_33`
336 FOREIGN KEY (`ID_DRZAVA`)
337 REFERENCES `tpo`.`drzava` (`ID_DRZAVA`))
338 ENGINE = InnoDB
339 AUTO_INCREMENT = 5
340 DEFAULT CHARACTER SET = utf8
341 COLLATE = utf8_slovenian_ci;
342
343CREATE INDEX `FK_RELATIONSHIP_30` ON `tpo`.`naslov` (`ID_POSTA` ASC);
344
345CREATE INDEX `FK_RELATIONSHIP_31` ON `tpo`.`naslov` (`ID_OBCINA` ASC);
346
347CREATE INDEX `FK_RELATIONSHIP_33` ON `tpo`.`naslov` (`ID_DRZAVA` ASC);
348
349CREATE INDEX `FK_RELATIONSHIP_32_idx` ON `tpo`.`naslov` (`ID_OSEBA` ASC);
350
351
352-- -----------------------------------------------------
353-- Table `tpo`.`oblika_studija`
354-- -----------------------------------------------------
355DROP TABLE IF EXISTS `tpo`.`oblika_studija` ;
356
357CREATE TABLE IF NOT EXISTS `tpo`.`oblika_studija` (
358 `ID_OBLIKA` INT(11) NOT NULL AUTO_INCREMENT,
359 `NAZIV_OBLIKA` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
360 `ANG_OPIS_OBLIKA` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
361 `AKTIVNOST` INT(11) NOT NULL,
362 PRIMARY KEY (`ID_OBLIKA`))
363 ENGINE = InnoDB
364 AUTO_INCREMENT = 4
365 DEFAULT CHARACTER SET = utf8
366 COLLATE = utf8_slovenian_ci;
367
368
369-- -----------------------------------------------------
370-- Table `tpo`.`vrsta_vpisa`
371-- -----------------------------------------------------
372DROP TABLE IF EXISTS `tpo`.`vrsta_vpisa` ;
373
374CREATE TABLE IF NOT EXISTS `tpo`.`vrsta_vpisa` (
375 `ID_VRSTAVPISA` INT(11) NOT NULL AUTO_INCREMENT,
376 `OPIS_VPISA` CHAR(30) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NOT NULL,
377 `AKTIVNOST` INT(11) NOT NULL,
378 PRIMARY KEY (`ID_VRSTAVPISA`))
379 ENGINE = InnoDB
380 AUTO_INCREMENT = 4
381 DEFAULT CHARACTER SET = utf8
382 COLLATE = utf8_slovenian_ci;
383
384
385-- -----------------------------------------------------
386-- Table `tpo`.`vpis`
387-- -----------------------------------------------------
388DROP TABLE IF EXISTS `tpo`.`vpis` ;
389
390CREATE TABLE IF NOT EXISTS `tpo`.`vpis` (
391 `ID_VPIS` INT(11) NOT NULL AUTO_INCREMENT,
392 `ID_PROGRAM` INT(11) NOT NULL,
393 `ID_NACIN` INT(11) NOT NULL,
394 `ID_STUD_LETO` INT(11) NOT NULL,
395 `ID_VRSTAVPISA` INT(11) NOT NULL,
396 `ID_OBLIKA` INT(11) NOT NULL,
397 `ID_LETNIK` INT(11) NOT NULL,
398 `POTRJENOST_VPISA` INT(11) NOT NULL,
399 `VPISNA_STEVILKA` INT(11) NULL DEFAULT NULL,
400 PRIMARY KEY (`ID_VPIS`),
401 CONSTRAINT `FK_RELATIONSHIP_10`
402 FOREIGN KEY (`ID_OBLIKA`)
403 REFERENCES `tpo`.`oblika_studija` (`ID_OBLIKA`),
404 CONSTRAINT `FK_RELATIONSHIP_11`
405 FOREIGN KEY (`ID_LETNIK`)
406 REFERENCES `tpo`.`letnik` (`ID_LETNIK`),
407 CONSTRAINT `FK_RELATIONSHIP_12`
408 FOREIGN KEY (`ID_PROGRAM`)
409 REFERENCES `tpo`.`program` (`ID_PROGRAM`),
410 CONSTRAINT `FK_RELATIONSHIP_16`
411 FOREIGN KEY (`ID_STUD_LETO`)
412 REFERENCES `tpo`.`studijsko_leto` (`ID_STUD_LETO`),
413 CONSTRAINT `FK_RELATIONSHIP_8`
414 FOREIGN KEY (`ID_VRSTAVPISA`)
415 REFERENCES `tpo`.`vrsta_vpisa` (`ID_VRSTAVPISA`),
416 CONSTRAINT `FK_RELATIONSHIP_9`
417 FOREIGN KEY (`ID_NACIN`)
418 REFERENCES `tpo`.`nacin_studija` (`ID_NACIN`))
419 ENGINE = InnoDB
420 AUTO_INCREMENT = 23
421 DEFAULT CHARACTER SET = utf8
422 COLLATE = utf8_slovenian_ci;
423
424CREATE INDEX `FK_RELATIONSHIP_10` ON `tpo`.`vpis` (`ID_OBLIKA` ASC);
425
426CREATE INDEX `FK_RELATIONSHIP_11` ON `tpo`.`vpis` (`ID_LETNIK` ASC);
427
428CREATE INDEX `FK_RELATIONSHIP_12` ON `tpo`.`vpis` (`ID_PROGRAM` ASC);
429
430CREATE INDEX `FK_RELATIONSHIP_16` ON `tpo`.`vpis` (`ID_STUD_LETO` ASC);
431
432CREATE INDEX `FK_RELATIONSHIP_8` ON `tpo`.`vpis` (`ID_VRSTAVPISA` ASC);
433
434CREATE INDEX `FK_RELATIONSHIP_9` ON `tpo`.`vpis` (`ID_NACIN` ASC);
435
436
437-- -----------------------------------------------------
438-- Table `tpo`.`student`
439-- -----------------------------------------------------
440DROP TABLE IF EXISTS `tpo`.`student` ;
441
442CREATE TABLE IF NOT EXISTS `tpo`.`student` (
443 `VPISNA_STEVILKA` INT(11) NOT NULL,
444 `ID_OSEBA` INT(11) NOT NULL,
445 `ID_KANDIDAT` INT(11) NULL DEFAULT NULL,
446 `ID_VPIS` INT(11) NULL DEFAULT NULL,
447 `EMSO` CHAR(13) NULL DEFAULT NULL,
448 `ID_PROGRAM` INT(11) NULL DEFAULT NULL,
449 `VSOTA_OPRAVLJENIH_KREDITNIH_TOCK` INT(11) NOT NULL DEFAULT '0',
450 `POVPRECNA_OCENA_OPRAVLJENIH_IZPITOV` FLOAT NOT NULL DEFAULT '0',
451 PRIMARY KEY (`VPISNA_STEVILKA`),
452 CONSTRAINT `FK_INHERITANCE_3`
453 FOREIGN KEY (`ID_OSEBA`)
454 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
455 CONSTRAINT `FK_PROGRAM_1`
456 FOREIGN KEY (`ID_PROGRAM`)
457 REFERENCES `tpo`.`program` (`ID_PROGRAM`)
458 ON DELETE NO ACTION
459 ON UPDATE NO ACTION,
460 CONSTRAINT `FK_RELATIONSHIP_5`
461 FOREIGN KEY (`ID_KANDIDAT`)
462 REFERENCES `tpo`.`kandidat` (`ID_KANDIDAT`),
463 CONSTRAINT `FK_RELATIONSHIP_6`
464 FOREIGN KEY (`ID_VPIS`)
465 REFERENCES `tpo`.`vpis` (`ID_VPIS`))
466 ENGINE = InnoDB
467 DEFAULT CHARACTER SET = utf8
468 COLLATE = utf8_slovenian_ci;
469
470CREATE INDEX `FK_INHERITANCE_3` ON `tpo`.`student` (`ID_OSEBA` ASC);
471
472CREATE INDEX `FK_RELATIONSHIP_5` ON `tpo`.`student` (`ID_KANDIDAT` ASC);
473
474CREATE INDEX `FK_RELATIONSHIP_6` ON `tpo`.`student` (`ID_VPIS` ASC);
475
476CREATE INDEX `FK_PROGRAM_idx` ON `tpo`.`student` (`ID_PROGRAM` ASC);
477
478
479-- -----------------------------------------------------
480-- Table `tpo`.`predmeti_studenta`
481-- -----------------------------------------------------
482DROP TABLE IF EXISTS `tpo`.`predmeti_studenta` ;
483
484CREATE TABLE IF NOT EXISTS `tpo`.`predmeti_studenta` (
485 `ID_PREDMETISTUDENTA` INT(11) NOT NULL AUTO_INCREMENT,
486 `VPISNA_STEVILKA` INT(11) NOT NULL,
487 `ID_PREDMET` INT(11) NOT NULL,
488 `ID_STUD_LETO` INT(11) NOT NULL,
489 `OCENA` INT(11) NULL DEFAULT '0',
490 PRIMARY KEY (`ID_PREDMETISTUDENTA`),
491 CONSTRAINT `FK_RELATIONSHIP_23`
492 FOREIGN KEY (`VPISNA_STEVILKA`)
493 REFERENCES `tpo`.`student` (`VPISNA_STEVILKA`),
494 CONSTRAINT `FK_RELATIONSHIP_24`
495 FOREIGN KEY (`ID_PREDMET`)
496 REFERENCES `tpo`.`predmet` (`ID_PREDMET`),
497 CONSTRAINT `FK_STUD_LETO_2`
498 FOREIGN KEY (`ID_STUD_LETO`)
499 REFERENCES `tpo`.`studijsko_leto` (`ID_STUD_LETO`)
500 ON DELETE NO ACTION
501 ON UPDATE NO ACTION)
502 ENGINE = InnoDB
503 AUTO_INCREMENT = 1372
504 DEFAULT CHARACTER SET = utf8
505 COLLATE = utf8_slovenian_ci;
506
507CREATE INDEX `FK_RELATIONSHIP_23` ON `tpo`.`predmeti_studenta` (`VPISNA_STEVILKA` ASC);
508
509CREATE INDEX `FK_RELATIONSHIP_24` ON `tpo`.`predmeti_studenta` (`ID_PREDMET` ASC);
510
511CREATE INDEX `FK_STUD_LETO_idx` ON `tpo`.`predmeti_studenta` (`ID_STUD_LETO` ASC);
512
513
514-- -----------------------------------------------------
515-- Table `tpo`.`predmetnik`
516-- -----------------------------------------------------
517DROP TABLE IF EXISTS `tpo`.`predmetnik` ;
518
519CREATE TABLE IF NOT EXISTS `tpo`.`predmetnik` (
520 `ID_PREDMETNIK` INT(11) NOT NULL AUTO_INCREMENT,
521 `ID_PREDMET` INT(11) NOT NULL,
522 `ID_DELPREDMETNIKA` INT(11) NOT NULL,
523 `ID_LETNIK` INT(11) NOT NULL,
524 `ID_STUD_LETO` INT(11) NOT NULL,
525 `ID_PROGRAM` INT(11) NOT NULL,
526 `AKTIVNOST` INT(11) NOT NULL,
527 PRIMARY KEY (`ID_PREDMETNIK`),
528 CONSTRAINT `FK_DELPREDMETNIKA`
529 FOREIGN KEY (`ID_DELPREDMETNIKA`)
530 REFERENCES `tpo`.`del_predmetnika` (`ID_DELPREDMETNIKA`)
531 ON DELETE NO ACTION
532 ON UPDATE NO ACTION,
533 CONSTRAINT `FK_PREDMET`
534 FOREIGN KEY (`ID_PREDMET`)
535 REFERENCES `tpo`.`predmet` (`ID_PREDMET`)
536 ON DELETE NO ACTION
537 ON UPDATE NO ACTION,
538 CONSTRAINT `FK_RELATIONSHIP_13`
539 FOREIGN KEY (`ID_PROGRAM`)
540 REFERENCES `tpo`.`program` (`ID_PROGRAM`),
541 CONSTRAINT `FK_RELATIONSHIP_14`
542 FOREIGN KEY (`ID_LETNIK`)
543 REFERENCES `tpo`.`letnik` (`ID_LETNIK`),
544 CONSTRAINT `FK_RELATIONSHIP_17`
545 FOREIGN KEY (`ID_STUD_LETO`)
546 REFERENCES `tpo`.`studijsko_leto` (`ID_STUD_LETO`))
547 ENGINE = InnoDB
548 AUTO_INCREMENT = 1305
549 DEFAULT CHARACTER SET = utf8
550 COLLATE = utf8_slovenian_ci;
551
552CREATE INDEX `FK_RELATIONSHIP_13` ON `tpo`.`predmetnik` (`ID_PROGRAM` ASC);
553
554CREATE INDEX `FK_RELATIONSHIP_14` ON `tpo`.`predmetnik` (`ID_LETNIK` ASC);
555
556CREATE INDEX `FK_RELATIONSHIP_17` ON `tpo`.`predmetnik` (`ID_STUD_LETO` ASC);
557
558CREATE INDEX `FK_PREDMET_idx` ON `tpo`.`predmetnik` (`ID_PREDMET` ASC);
559
560CREATE INDEX `FK_DELPREDMETNIKA_idx` ON `tpo`.`predmetnik` (`ID_DELPREDMETNIKA` ASC);
561
562
563-- -----------------------------------------------------
564-- Table `tpo`.`rok`
565-- -----------------------------------------------------
566DROP TABLE IF EXISTS `tpo`.`rok` ;
567
568CREATE TABLE IF NOT EXISTS `tpo`.`rok` (
569 `ID_ROK` INT(11) NOT NULL AUTO_INCREMENT,
570 `ID_IZVEDBA` INT(11) NOT NULL,
571 `DATUM_ROKA` DATE NOT NULL,
572 `CAS_ROKA` TIME NOT NULL,
573 `AKTIVNOST` INT(11) NULL DEFAULT NULL,
574 `ID_OSEBA_IZPRASEVALEC1` INT(11) NULL DEFAULT NULL,
575 `ID_OSEBA_IZPRASEVALEC2` INT(11) NULL DEFAULT NULL,
576 `ID_OSEBA_IZPRASEVALEC3` INT(11) NULL DEFAULT NULL,
577 PRIMARY KEY (`ID_ROK`),
578 CONSTRAINT `FK_RELATIONSHIP_25`
579 FOREIGN KEY (`ID_IZVEDBA`)
580 REFERENCES `tpo`.`izvedba_predmeta` (`ID_IZVEDBA`),
581 CONSTRAINT `fk_izvajalec1`
582 FOREIGN KEY (`ID_OSEBA_IZPRASEVALEC1`)
583 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
584 CONSTRAINT `fk_izvajalec2`
585 FOREIGN KEY (`ID_OSEBA_IZPRASEVALEC2`)
586 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
587 CONSTRAINT `fk_izvalaec3`
588 FOREIGN KEY (`ID_OSEBA_IZPRASEVALEC3`)
589 REFERENCES `tpo`.`oseba` (`ID_OSEBA`))
590 ENGINE = InnoDB
591 AUTO_INCREMENT = 36
592 DEFAULT CHARACTER SET = utf8
593 COLLATE = utf8_slovenian_ci;
594
595CREATE INDEX `FK_RELATIONSHIP_25` ON `tpo`.`rok` (`ID_IZVEDBA` ASC);
596
597CREATE INDEX `fk_izvajalec_idx` ON `tpo`.`rok` (`ID_OSEBA_IZPRASEVALEC1` ASC);
598
599CREATE INDEX `fk_izvajalec2_idx` ON `tpo`.`rok` (`ID_OSEBA_IZPRASEVALEC2` ASC);
600
601CREATE INDEX `fk_izvalaec3_idx` ON `tpo`.`rok` (`ID_OSEBA_IZPRASEVALEC3` ASC);
602
603
604-- -----------------------------------------------------
605-- Table `tpo`.`prijava`
606-- -----------------------------------------------------
607DROP TABLE IF EXISTS `tpo`.`prijava` ;
608
609CREATE TABLE IF NOT EXISTS `tpo`.`prijava` (
610 `ID_PRIJAVA` INT(11) NOT NULL AUTO_INCREMENT,
611 `ID_ROK` INT(11) NOT NULL,
612 `VPISNA_STEVILKA` INT(11) NOT NULL,
613 `ZAP_ST_POLAGANJ` INT(11) NOT NULL DEFAULT '0',
614 `ZAP_ST_POLAGANJ_LETOS` INT(11) NOT NULL DEFAULT '0',
615 `PODATKI_O_PLACILU` CHAR(50) CHARACTER SET 'utf8' COLLATE 'utf8_slovenian_ci' NULL DEFAULT NULL,
616 `TOCKE_IZPITA` INT(11) NULL DEFAULT NULL,
617 `OCENA_IZPITA` INT(11) NULL DEFAULT NULL,
618 `DATUM_PRIJAVE` DATETIME NULL DEFAULT NULL,
619 `ID_OSEBA_PRIJAVITELJ` INT(11) NULL DEFAULT NULL,
620 `DATUM_ODJAVE` DATETIME NULL DEFAULT NULL,
621 `ID_OSEBA_ODJAVITELJ` INT(11) NULL DEFAULT NULL,
622 PRIMARY KEY (`ID_PRIJAVA`),
623 CONSTRAINT `FK_RELATIONSHIP_100`
624 FOREIGN KEY (`VPISNA_STEVILKA`)
625 REFERENCES `tpo`.`student` (`VPISNA_STEVILKA`),
626 CONSTRAINT `FK_RELATIONSHIP_200`
627 FOREIGN KEY (`ID_OSEBA_PRIJAVITELJ`)
628 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
629 CONSTRAINT `FK_RELATIONSHIP_201`
630 FOREIGN KEY (`ID_OSEBA_ODJAVITELJ`)
631 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
632 CONSTRAINT `FK_RELATIONSHIP_26`
633 FOREIGN KEY (`ID_ROK`)
634 REFERENCES `tpo`.`rok` (`ID_ROK`))
635 ENGINE = InnoDB
636 AUTO_INCREMENT = 16
637 DEFAULT CHARACTER SET = utf8
638 COLLATE = utf8_slovenian_ci;
639
640CREATE INDEX `FK_RELATIONSHIP_26` ON `tpo`.`prijava` (`ID_ROK` ASC);
641
642CREATE INDEX `FK_RELATIONSHIP_100_idx` ON `tpo`.`prijava` (`VPISNA_STEVILKA` ASC);
643
644CREATE INDEX `FK_RELATIONSHIP_200_idx` ON `tpo`.`prijava` (`ID_OSEBA_PRIJAVITELJ` ASC);
645
646CREATE INDEX `FK_RELATIONSHIP_201_idx` ON `tpo`.`prijava` (`ID_OSEBA_ODJAVITELJ` ASC);
647
648
649-- -----------------------------------------------------
650-- Table `tpo`.`zeton`
651-- -----------------------------------------------------
652DROP TABLE IF EXISTS `tpo`.`zeton` ;
653
654CREATE TABLE IF NOT EXISTS `tpo`.`zeton` (
655 `ID_ZETON` INT(11) NOT NULL AUTO_INCREMENT,
656 `ID_OSEBA` INT(11) NOT NULL,
657 `ID_LETNIK` INT(11) NOT NULL,
658 `ID_STUD_LETO` INT(11) NOT NULL,
659 `IZKORISCEN` INT(11) NULL DEFAULT '0',
660 `AKTIVNOST` INT(11) NULL DEFAULT '1',
661 `ID_OBLIKA` INT(11) NOT NULL,
662 `ID_VRSTAVPISA` INT(11) NOT NULL,
663 `ID_NACIN` INT(11) NOT NULL,
664 `ID_PROGRAM` INT(11) NOT NULL,
665 `PROSTA_IZBIRNOST` INT(11) NULL DEFAULT '0',
666 PRIMARY KEY (`ID_ZETON`),
667 CONSTRAINT `FK_LETNIK_1`
668 FOREIGN KEY (`ID_LETNIK`)
669 REFERENCES `tpo`.`letnik` (`ID_LETNIK`)
670 ON DELETE NO ACTION
671 ON UPDATE NO ACTION,
672 CONSTRAINT `FK_RELATIONSHIP_7`
673 FOREIGN KEY (`ID_OSEBA`)
674 REFERENCES `tpo`.`oseba` (`ID_OSEBA`),
675 CONSTRAINT `FK_STUD_LETO_1`
676 FOREIGN KEY (`ID_STUD_LETO`)
677 REFERENCES `tpo`.`studijsko_leto` (`ID_STUD_LETO`)
678 ON DELETE NO ACTION
679 ON UPDATE NO ACTION,
680 CONSTRAINT `fk_zeton_nacin_studija1`
681 FOREIGN KEY (`ID_NACIN`)
682 REFERENCES `tpo`.`nacin_studija` (`ID_NACIN`)
683 ON DELETE NO ACTION
684 ON UPDATE NO ACTION,
685 CONSTRAINT `fk_zeton_oblika_studija1`
686 FOREIGN KEY (`ID_OBLIKA`)
687 REFERENCES `tpo`.`oblika_studija` (`ID_OBLIKA`)
688 ON DELETE NO ACTION
689 ON UPDATE NO ACTION,
690 CONSTRAINT `fk_zeton_program1`
691 FOREIGN KEY (`ID_PROGRAM`)
692 REFERENCES `tpo`.`program` (`ID_PROGRAM`)
693 ON DELETE NO ACTION
694 ON UPDATE NO ACTION,
695 CONSTRAINT `fk_zeton_vrsta_vpisa1`
696 FOREIGN KEY (`ID_VRSTAVPISA`)
697 REFERENCES `tpo`.`vrsta_vpisa` (`ID_VRSTAVPISA`)
698 ON DELETE NO ACTION
699 ON UPDATE NO ACTION)
700 ENGINE = InnoDB
701 AUTO_INCREMENT = 167
702 DEFAULT CHARACTER SET = utf8
703 COLLATE = utf8_slovenian_ci;
704
705CREATE INDEX `FK_RELATIONSHIP_7` ON `tpo`.`zeton` (`ID_OSEBA` ASC);
706
707CREATE INDEX `FK_STUD_LETO_idx` ON `tpo`.`zeton` (`ID_STUD_LETO` ASC);
708
709CREATE INDEX `FK_LETNIK_idx` ON `tpo`.`zeton` (`ID_LETNIK` ASC);
710
711CREATE INDEX `fk_zeton_oblika_studija1_idx` ON `tpo`.`zeton` (`ID_OBLIKA` ASC);
712
713CREATE INDEX `fk_zeton_vrsta_vpisa1_idx` ON `tpo`.`zeton` (`ID_VRSTAVPISA` ASC);
714
715CREATE INDEX `fk_zeton_nacin_studija1_idx` ON `tpo`.`zeton` (`ID_NACIN` ASC);
716
717CREATE INDEX `fk_zeton_program1_idx` ON `tpo`.`zeton` (`ID_PROGRAM` ASC);
718
719
720-- -----------------------------------------------------
721-- Table `tpo`.`posta_obcina`
722-- -----------------------------------------------------
723DROP TABLE IF EXISTS `tpo`.`posta_obcina` ;
724
725CREATE TABLE IF NOT EXISTS `tpo`.`posta_obcina` (
726 `MID_POSTA` INT(11) NOT NULL,
727 `MID_OBCINA` INT(11) NOT NULL)
728 ENGINE = InnoDB;
729
730
731SET SQL_MODE=@OLD_SQL_MODE;
732SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
733SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
734
735INSERT INTO `drzava` (`ID_DRZAVA`, `DVOMESTNAKODA`, `TRIMESTNAKODA`, `ISONAZIV`, `SLOVENSKINAZIV`, `OPOMBA`, `AKTIVNOST`) VALUES
736 (4, 'AF', 'AFG', 'Afghanistan', 'Afganistan', NULL, 1),
737 (8, 'AL', 'ALB', 'Albania', 'Albanija', NULL, 1),
738 (10, 'AQ', 'ATA', 'Antarctica', 'Antarktika', NULL, 1),
739 (12, 'DZ', 'DZA', 'Algeria', 'Alžirija', NULL, 1),
740 (16, 'AS', 'ASM', 'American Samoa', 'Ameriška Samoa', NULL, 1),
741 (20, 'AD', 'AND', 'Andorra', 'Andora', NULL, 1),
742 (24, 'AO', 'AGO', 'Angola', 'Angola', NULL, 1),
743 (28, 'AG', 'ATG', 'Antigua and Barbuda', 'Antigva in Barbuda', NULL, 1),
744 (31, 'AZ', 'AZE', 'Azerbaijan', 'Azerbajdžan', NULL, 1),
745 (32, 'AR', 'ARG', 'Argentina', 'Argenitna', NULL, 1),
746 (36, 'AU', 'AUS', 'Australia', 'Avstralija', NULL, 1),
747 (40, 'AT', 'AUT', 'Austria', 'Avstrija', NULL, 1),
748 (44, 'BS', 'BHS', 'Bahamas', 'Bahami', NULL, 1),
749 (48, 'BH', 'BHR', 'Bahrain', 'Bahrajn', NULL, 1),
750 (50, 'BD', 'BGD', 'Bangladesh', 'Bangladeš', NULL, 1),
751 (51, 'AM', 'ARM', 'Armenia', 'Armenija', NULL, 1),
752 (52, 'BB', 'BRB', 'Barbados', 'Barbados', NULL, 1),
753 (56, 'BE', 'BEL', 'Belgium', 'Belgija', NULL, 1),
754 (60, 'BM', 'BMU', 'Bermuda', 'Bermudi', NULL, 1),
755 (64, 'BT', 'BTN', 'Bhutan', 'Butan', NULL, 1),
756 (68, 'BO', 'BOL', 'Bolivia, Plurinational State of', 'Bolivija', NULL, 1),
757 (70, 'BA', 'BIH', 'Bosnia and Herzegovina', 'Bosna in Hercegovina', NULL, 1),
758 (72, 'BW', 'BWA', 'Botswana', 'Bocvana', NULL, 1),
759 (74, 'BV', 'BVT', 'Bouvet Island', 'Bouvetov otok', NULL, 1),
760 (76, 'BR', 'BRA', 'Brazil', 'Brazilija', NULL, 1),
761 (84, 'BZ', 'BLZ', 'Belize', 'Belize', NULL, 1),
762 (86, 'IO', 'IOT', 'British Indian Ocean Territory', 'Britansko ozemlje v Indijskem oceanu', NULL, 1),
763 (90, 'SB', 'SLB', 'Solomon Islands', 'Solomonovi otoki', NULL, 1),
764 (92, 'VG', 'VGB', 'Virgin Islands, British', 'Britanski Deviški otoki', NULL, 1),
765 (96, 'BN', 'BRN', 'Brunei Darussalam', 'Brunej', NULL, 1),
766 (100, 'BG', 'BGR', 'Bulgaria', 'Bolgarija', NULL, 1),
767 (104, 'MM', 'MMR', 'Myanmar', 'Mjanmar', NULL, 1),
768 (108, 'BI', 'BDI', 'Burundi', 'Burundi', NULL, 1),
769 (112, 'BY', 'BLR', 'Belarus', 'Belorusija', NULL, 1),
770 (116, 'KH', 'KHM', 'Cambodia', 'Kambodža', NULL, 1),
771 (120, 'CM', 'CMR', 'Cameroon', 'Kamerun', NULL, 1),
772 (124, 'CA', 'CAN', 'Canada', 'Kanada', NULL, 1),
773 (132, 'CV', 'CPV', 'Cape Verde', 'Kapverdski otoki (Zelenortski otoki)', NULL, 1),
774 (136, 'KY', 'CYM', 'Cayman Islands', 'Kajmanski otoki', NULL, 1),
775 (140, 'CF', 'CAF', 'Central African Republic', 'Srednjeafriška republika', NULL, 1),
776 (144, 'LK', 'LKA', 'Sri Lanka', 'Å ri Lanka', NULL, 1),
777 (148, 'TD', 'TCD', 'Chad', 'ÄŒad', NULL, 1),
778 (152, 'CL', 'CHL', 'Chile', 'ÄŒile', NULL, 1),
779 (156, 'CN', 'CHN', 'China', 'Kitajska', NULL, 1),
780 (158, 'TW', 'TWN', 'Taiwan, Province of China', 'Tajvan', NULL, 1),
781 (162, 'CX', 'CXR', 'Christmas Island', 'BožiÄni otok', NULL, 1),
782 (166, 'CC', 'CCK', 'Cocos (Keeling) Islands', 'Kokosovi in Keelingovi otoki', NULL, 1),
783 (170, 'CO', 'COL', 'Colombia', 'Kolumbija', NULL, 1),
784 (174, 'KM', 'COM', 'Comoros', 'Komori', NULL, 1),
785 (175, 'YT', 'MYT', 'Mayotte', 'Francoska skupnost Mejot', NULL, 1),
786 (178, 'CG', 'COG', 'Congo', 'Kongo', NULL, 1),
787 (180, 'CD', 'COD', 'Congo, the Democratic Republic of the', 'DemokratiÄna republika Kongo', NULL, 1),
788 (184, 'CK', 'COK', 'Cook Islands', 'Cookovi otoki', NULL, 1),
789 (188, 'CR', 'CRI', 'Costa Rica', 'Kostarika', NULL, 1),
790 (191, 'HR', 'HRV', 'Croatia', 'Hrvaška', NULL, 1),
791 (192, 'CU', 'CUB', 'Cuba', 'Kuba', NULL, 1),
792 (196, 'CY', 'CYP', 'Cyprus', 'Ciper', NULL, 1),
793 (203, 'CZ', 'CZE', 'Czech Republic', 'Češka', NULL, 1),
794 (204, 'BJ', 'BEN', 'Benin', 'Benin', NULL, 1),
795 (208, 'DK', 'DNK', 'Denmark', 'Danska', NULL, 1),
796 (212, 'DM', 'DMA', 'Dominica', 'Dominika', NULL, 1),
797 (214, 'DO', 'DOM', 'Dominican Republic', 'Dominikanska republika', NULL, 1),
798 (218, 'EC', 'ECU', 'Ecuador', 'Ekvador', NULL, 1),
799 (222, 'SV', 'SLV', 'El Salvador', 'Salvador', NULL, 1),
800 (226, 'GQ', 'GNQ', 'Equatorial Guinea', 'Ekvatorialna Gvineja', NULL, 1),
801 (231, 'ET', 'ETH', 'Ethiopia', 'Etiopija', NULL, 1),
802 (232, 'ER', 'ERI', 'Eritrea', 'Eritreja', NULL, 1),
803 (233, 'EE', 'EST', 'Estonia', 'Estonija', NULL, 1),
804 (234, 'FK', 'FRO', 'Falkland Islands (Malvinas)', 'Falkalndski otoki', NULL, 1),
805 (238, 'FO', 'FLK', 'Faroe Islands', 'Ferski otoki', NULL, 1),
806 (239, 'GS', 'SGS', 'South Georgia and the South Sandwich Islands', 'Južna Georgia in Južni Sandwichevi otoki', NULL, 1),
807 (242, 'FJ', 'FJI', 'Fiji', 'Fidži', NULL, 1),
808 (246, 'FI', 'FIN', 'Finland', 'Finska', NULL, 1),
809 (248, 'AX', 'ALA', 'Ã…lland Islands', 'Alandski otoki', NULL, 1),
810 (250, 'FR', 'FRA', 'France', 'Francija', NULL, 1),
811 (254, 'GF', 'GUF', 'French Guiana', 'Francoska Gvajana', NULL, 1),
812 (258, 'PF', 'PYF', 'French Polynesia', 'Francoska Polinezija', NULL, 1),
813 (260, 'TF', 'ATF', 'French Southern Territories', 'Francoska južna ozemlja', NULL, 1),
814 (262, 'DJ', 'DJI', 'Djibouti', 'Džibuti', NULL, 1),
815 (266, 'GA', 'GAB', 'Gabon', 'Gabon', NULL, 1),
816 (268, 'GE', 'GEO', 'Georgia', 'Gruzija', NULL, 1),
817 (270, 'GM', 'GMB', 'Gambia', 'Gambija', NULL, 1),
818 (275, 'PS', 'PSE', 'Palestinian Territory, Occupied', 'Palestina', NULL, 1),
819 (276, 'DE', 'DEU', 'Germany', 'NemÄija', NULL, 1),
820 (288, 'GH', 'GHA', 'Ghana', 'Gana', NULL, 1),
821 (292, 'GI', 'GIB', 'Gibraltar', 'Gibraltar', NULL, 1),
822 (296, 'KI', 'KIR', 'Kiribati', 'Kiribati', NULL, 1),
823 (300, 'GR', 'GRC', 'Greece', 'GrÄija', NULL, 1),
824 (304, 'GL', 'GRL', 'Greenland', 'Grenlandija', NULL, 1),
825 (308, 'GD', 'GRD', 'Grenada', 'Grenada', NULL, 1),
826 (312, 'GP', 'GLP', 'Guadeloupe', 'Guadeloupe', NULL, 1),
827 (316, 'GU', 'GUM', 'Guam', 'Guam', NULL, 1),
828 (320, 'GT', 'GTM', 'Guatemala', 'Gvatemala', NULL, 1),
829 (324, 'GN', 'GIN', 'Guinea', 'Gvineja', NULL, 1),
830 (328, 'GY', 'GUY', 'Guyana', 'Gvajana', NULL, 1),
831 (332, 'HT', 'HTI', 'Haiti', 'Haiti', NULL, 1),
832 (334, 'HM', 'HMD', 'Heard Island and McDonald Islands', 'Otok Heard in otoÄje McDonald', NULL, 1),
833 (336, 'VA', 'VAT', 'Holy See (Vatican City State)', 'Vatikan', NULL, 1),
834 (340, 'HN', 'HND', 'Honduras', 'Honduras', NULL, 1),
835 (344, 'HK', 'HKG', 'Hong Kong', 'Hong Kong', NULL, 1),
836 (348, 'HU', 'HUN', 'Hungary', 'Madžarska', NULL, 1),
837 (352, 'IS', 'ISL', 'Iceland', 'Islandija', NULL, 1),
838 (356, 'IN', 'IND', 'India', 'Indija', NULL, 1),
839 (360, 'ID', 'IDN', 'Indonesia', 'Indonezija', NULL, 1),
840 (364, 'IR', 'IRN', 'Iran, Islamic Republic of', 'Iran', NULL, 1),
841 (368, 'IQ', 'IRQ', 'Iraq', 'Irak', NULL, 1),
842 (372, 'IE', 'IRL', 'Ireland', 'Irska', NULL, 1),
843 (376, 'IL', 'ISR', 'Israel', 'Izrael', NULL, 1),
844 (380, 'IT', 'ITA', 'Italy', 'Italija', NULL, 1),
845 (384, 'CI', 'CIV', 'Côte dIvoire', 'SlonokoÅ¡Äena obala', NULL, 1),
846 (388, 'JM', 'JAM', 'Jamaica', 'Jamajka', NULL, 1),
847 (392, 'JP', 'JPN', 'Japan', 'Japonska', NULL, 1),
848 (398, 'KZ', 'KAZ', 'Kazakhstan', 'Kazahstan', NULL, 1),
849 (400, 'JO', 'JOR', 'Jordan', 'Jordanija', NULL, 1),
850 (404, 'KE', 'KEN', 'Kenya', 'Kenija', NULL, 1),
851 (408, 'KP', 'PRK', 'Korea, Democratic Peoples Republic of', 'Severna Koreja', NULL, 1),
852 (410, 'KR', 'KOR', 'Korea, Republic of', 'Južna Koreja', NULL, 1),
853 (414, 'KW', 'KWT', 'Kuwait', 'Kuvajt', NULL, 1),
854 (417, 'KG', 'KGZ', 'Kyrgyzstan', 'Kirgizistan (Kirgizija)', NULL, 1),
855 (418, 'LA', 'LAO', 'Lao Peoples Democratic Republic', 'Laos', NULL, 1),
856 (422, 'LB', 'LBN', 'Lebanon', 'Libanon', NULL, 1),
857 (426, 'LS', 'LSO', 'Lesotho', 'Lesoto', NULL, 1),
858 (428, 'LV', 'LVA', 'Latvia', 'Latvija', NULL, 1),
859 (430, 'LR', 'LBR', 'Liberia', 'Liberija', NULL, 1),
860 (434, 'LY', 'LBY', 'Libya', 'Libija', NULL, 1),
861 (438, 'LI', 'LIE', 'Liechtenstein', 'Lihtenštajn', NULL, 1),
862 (440, 'LT', 'LTU', 'Lithuania', 'Litva', NULL, 1),
863 (442, 'LU', 'LUX', 'Luxembourg', 'Luksemburg', NULL, 1),
864 (446, 'MO', 'MAC', 'Macao', 'Makao', NULL, 1),
865 (450, 'MG', 'MDG', 'Madagascar', 'Madagaskar', NULL, 1),
866 (454, 'MW', 'MWI', 'Malawi', 'Malavi', NULL, 1),
867 (458, 'MY', 'MYS', 'Malaysia', 'Malezija', NULL, 1),
868 (462, 'MV', 'MDV', 'Maldives', 'Maldivi', NULL, 1),
869 (466, 'ML', 'MLI', 'Mali', 'Mali', NULL, 1),
870 (470, 'MT', 'MLT', 'Malta', 'Malta', NULL, 1),
871 (474, 'MQ', 'MTQ', 'Martinique', 'Martinik', NULL, 1),
872 (478, 'MR', 'MRT', 'Mauritania', 'Mavretanija', NULL, 1),
873 (480, 'MU', 'MUS', 'Mauritius', 'Mauricius (Moris)', NULL, 1),
874 (484, 'MX', 'MEX', 'Mexico', 'Mehika', NULL, 1),
875 (492, 'MC', 'MCO', 'Monaco', 'Monako', NULL, 1),
876 (496, 'MN', 'MNG', 'Mongolia', 'Mongolija', NULL, 1),
877 (498, 'MD', 'MDA', 'Moldova, Republic of', 'Moldavija', NULL, 1),
878 (499, 'ME', 'MNE', 'Montenegro', 'ÄŒrna Gora', NULL, 1),
879 (500, 'MS', 'MSR', 'Montserrat', 'Montserat', NULL, 1),
880 (504, 'MA', 'MAR', 'Morocco', 'Maroko', NULL, 1),
881 (508, 'MZ', 'MOZ', 'Mozambique', 'Mozambik', NULL, 1),
882 (512, 'OM', 'OMN', 'Oman', 'Oman', NULL, 1),
883 (516, 'NA', 'NAM', 'Namibia', 'Namibija', NULL, 1),
884 (520, 'NR', 'NRU', 'Nauru', 'Nauru', NULL, 1),
885 (524, 'NP', 'NPL', 'Nepal', 'Nepal', NULL, 1),
886 (528, 'NL', 'NLD', 'Netherlands', 'Nizozemska', NULL, 1),
887 (531, 'CW', 'CUW', 'Curaçao', 'Kurasao', NULL, 1),
888 (533, 'AW', 'ABW', 'Aruba', 'Aruba', NULL, 1),
889 (534, 'SX', 'SXM', 'Sint Maarten (Dutch part)', 'Otok svetega.Martina (Nizozemska)', NULL, 1),
890 (535, 'BQ', 'BES', 'Bonaire, Sint Eustatius and Saba', 'OtoÄje Bonaire, Sv. Eustatij in Saba', NULL, 1),
891 (540, 'NC', 'NCL', 'New Caledonia', 'Nova Kaledonija', NULL, 1),
892 (548, 'VU', 'VUT', 'Vanuatu', 'Republika Vanuatu', NULL, 1),
893 (554, 'NZ', 'NZL', 'New Zealand', 'Nova Zelandija', NULL, 1),
894 (558, 'NI', 'NIC', 'Nicaragua', 'Nikaragva', NULL, 1),
895 (562, 'NE', 'NER', 'Niger', 'Niger', NULL, 1),
896 (566, 'NG', 'NGA', 'Nigeria', 'Nigerija', NULL, 1),
897 (570, 'NU', 'NIU', 'Niue', 'Niu', NULL, 1),
898 (574, 'NF', 'NFK', 'Norfolk Island', 'Otok Norflok', NULL, 1),
899 (578, 'NO', 'NOR', 'Norway', 'Norveška', NULL, 1),
900 (580, 'MP', 'MNP', 'Northern Mariana Islands', 'Severni Marianski otoki', NULL, 1),
901 (581, 'UM', 'UMI', 'United States Minor Outlying Islands', 'ZDA zunanji otoki', NULL, 1),
902 (583, 'FM', 'FSM', 'Micronesia, Federated States of', 'Mikronezija', NULL, 1),
903 (584, 'MH', 'MHL', 'Marshall Islands', 'Maršalovi otoki', NULL, 1),
904 (585, 'PW', 'PLW', 'Palau', 'Palau', NULL, 1),
905 (586, 'PK', 'PAK', 'Pakistan', 'Pakistan', NULL, 1),
906 (591, 'PA', 'PAN', 'Panama', 'Panama', NULL, 1),
907 (598, 'PG', 'PNG', 'Papua New Guinea', 'Papua Nova Gvineja', NULL, 1),
908 (600, 'PY', 'PRY', 'Paraguay', 'Paragvaj', NULL, 1),
909 (604, 'PE', 'PER', 'Peru', 'Peru', NULL, 1),
910 (608, 'PH', 'PHL', 'Philippines', 'Filipini', NULL, 1),
911 (612, 'PN', 'PCN', 'Pitcairn', 'Pitcairnovi otoki', NULL, 1),
912 (616, 'PL', 'POL', 'Poland', 'Poljska', NULL, 1),
913 (620, 'PT', 'PRT', 'Portugal', 'Portugalska', NULL, 1),
914 (624, 'GW', 'GNB', 'Guinea-Bissau', 'Gvineja-Bissau', NULL, 1),
915 (626, 'TL', 'TLS', 'Timor-Leste', 'Vzhodni Timor', NULL, 1),
916 (630, 'PR', 'PRI', 'Puerto Rico', 'Portoriko', NULL, 1),
917 (634, 'QA', 'QAT', 'Qatar', 'Katar', NULL, 1),
918 (638, 'RE', 'REU', 'Réunion', 'Francoska skupnost Reunion', NULL, 1),
919 (642, 'RO', 'ROU', 'Romania', 'Romunija', NULL, 1),
920 (643, 'RU', 'RUS', 'Russian Federation', 'Ruska federacija', NULL, 1),
921 (646, 'RW', 'RWA', 'Rwanda', 'Ruanda', NULL, 1),
922 (652, 'BL', 'BLM', 'Saint Barthélemy', 'Sveti Bartolomej', NULL, 1),
923 (654, 'SH', 'SHN', 'Saint Helena, Ascension and Tristan da Cunha', 'Sveta Helena', NULL, 1),
924 (659, 'KN', 'KNA', 'Saint Kitts and Nevis', 'Sveti Kits in Nevis', NULL, 1),
925 (660, 'AI', 'AIA', 'Anguilla', 'Angvila', NULL, 1),
926 (662, 'LC', 'LCA', 'Saint Lucia', 'Sveta Lucija', NULL, 1),
927 (663, 'MF', 'MAF', 'Saint Martin (French part)', 'Otok svetega Martina', NULL, 1),
928 (666, 'PM', 'SPM', 'Saint Pierre and Miquelon', 'Sveta Pierre in Miquelon', NULL, 1),
929 (670, 'VC', 'VCT', 'Saint Vincent and the Grenadines', 'Sveti Vincent in Grenadini', NULL, 1),
930 (674, 'SM', 'SMR', 'San Marino', 'San Marino', NULL, 1),
931 (678, 'ST', 'STP', 'Sao Tome and Principe', 'Sao Tome in Principe', NULL, 1),
932 (682, 'SA', 'SAU', 'Saudi Arabia', 'Savdska Arabija', NULL, 1),
933 (686, 'SN', 'SEN', 'Senegal', 'Senegal', NULL, 1),
934 (688, 'RS', 'SRB', 'Serbia', 'Srbija', NULL, 1),
935 (690, 'SC', 'SYC', 'Seychelles', 'Sejšeli', NULL, 1),
936 (694, 'SL', 'SLE', 'Sierra Leone', 'Siera Leone', NULL, 1),
937 (702, 'SG', 'SGP', 'Singapore', 'Singapur', NULL, 1),
938 (703, 'SK', 'SVK', 'Slovakia', 'Slovaška', NULL, 1),
939 (704, 'VN', 'VNM', 'Viet Nam', 'Vietnam', NULL, 1),
940 (705, 'SI', 'SVN', 'Slovenia', 'Slovenija', NULL, 1),
941 (706, 'SO', 'SOM', 'Somalia', 'Somalija', NULL, 1),
942 (710, 'ZA', 'ZAF', 'South Africa', 'Južna afrika', NULL, 1),
943 (716, 'ZW', 'ZWE', 'Zimbabwe', 'Zimbabve', NULL, 1),
944 (724, 'ES', 'ESP', 'Spain', 'Å panija', NULL, 1),
945 (728, 'SS', 'SSD', 'South Sudan', 'Južni Sudan', NULL, 1),
946 (729, 'SD', 'SDN', 'Sudan', 'Sudan', NULL, 1),
947 (732, 'EH', 'ESH', 'Western Sahara', 'Zahodna Sahara', NULL, 1),
948 (740, 'SR', 'SUR', 'Suriname', 'Surinam', NULL, 1),
949 (744, 'SJ', 'SJM', 'Svalbard and Jan Mayen', 'Svalbard in Jan Majen', NULL, 1),
950 (748, 'SZ', 'SWZ', 'Swaziland', 'Svazi', NULL, 1),
951 (752, 'SE', 'SWE', 'Sweden', 'Å vedska', NULL, 1),
952 (756, 'CH', 'CHE', 'Switzerland', 'Å vica', NULL, 1),
953 (760, 'SY', 'SYR', 'Syrian Arab Republic', 'Sirija', NULL, 1),
954 (762, 'TJ', 'TJK', 'Tajikistan', 'Tadžikistan', NULL, 1),
955 (764, 'TH', 'THA', 'Thailand', 'Tajska', NULL, 1),
956 (768, 'TG', 'TGO', 'Togo', 'Togo', NULL, 1),
957 (772, 'TK', 'TKL', 'Tokelau', 'Tokelau', NULL, 1),
958 (776, 'TO', 'TON', 'Tonga', 'Tonga', NULL, 1),
959 (780, 'TT', 'TTO', 'Trinidad and Tobago', 'Trinidad in Tobago', NULL, 1),
960 (784, 'AE', 'ARE', 'United Arab Emirates', 'Združeni Arabski Emirati', NULL, 1),
961 (788, 'TN', 'TUN', 'Tunisia', 'Tunizija', NULL, 1),
962 (792, 'TR', 'TUR', 'Turkey', 'TurÄija', NULL, 1),
963 (795, 'TM', 'TKM', 'Turkmenistan', 'Turkmenistan', NULL, 1),
964 (796, 'TC', 'TCA', 'Turks and Caicos Islands', 'Tirški in Kajkoški otoki', NULL, 1),
965 (798, 'TV', 'TUV', 'Tuvalu', 'Tuvalu', NULL, 1),
966 (800, 'UG', 'UGA', 'Uganda', 'Uganda', NULL, 1),
967 (804, 'UA', 'UKR', 'Ukraine', 'Ukrajina', NULL, 1),
968 (807, 'MK', 'MKD', 'Macedonia', 'Makedonija', NULL, 1),
969 (818, 'EG', 'EGY', 'Egypt', 'Egipt', NULL, 1),
970 (826, 'GB', 'GBR', 'United Kingdom', 'Velika Britanija', NULL, 1),
971 (831, 'GG', 'GGY', 'Guernsey', 'Otok Guernsey', NULL, 1),
972 (832, 'JE', 'JEY', 'Jersey', 'Otok Jersey', NULL, 1),
973 (833, 'IM', 'IMN', 'Isle of Man', 'Otok Man', NULL, 1),
974 (834, 'TZ', 'TZA', 'Tanzania, United Republic of', 'Tanzanija', NULL, 1),
975 (840, 'US', 'USA', 'United States', 'Združene države Amerike', NULL, 1),
976 (850, 'VI', 'VIR', 'Virgin Islands, U.S.', 'Ameriški Deviški otoki', NULL, 1),
977 (854, 'BF', 'BFA', 'Burkina Faso', 'Burkina Faso', NULL, 1),
978 (858, 'UY', 'URY', 'Uruguay', 'Urugvaj', NULL, 1),
979 (860, 'UZ', 'UZB', 'Uzbekistan', 'Uzbekistan', NULL, 1),
980 (862, 'VE', 'VEN', 'Venezuela, Bolivarian Republic of', 'Venezuela', NULL, 1),
981 (876, 'WF', 'WLF', 'Wallis and Futuna', 'OtoÄje Valis in Futuna', NULL, 1),
982 (882, 'WS', 'WSM', 'Samoa', 'Samoa', NULL, 1),
983 (887, 'YE', 'YEM', 'Yemen', 'Jemen', NULL, 1),
984 (894, 'ZM', 'ZMB', 'Zambia', 'Zambija', NULL, 1);
985
986INSERT INTO `obcina` (`ID_OBCINA`, `AKTIVNOST`, `MID_OBCINA`, `IME_OBCINA`) VALUES
987 (1, 1, 11027962, 'Novo mesto'),
988 (2, 1, 11027113, 'Mislinja'),
989 (3, 1, 11027008, 'Kungota'),
990 (4, 1, 11026982, 'Krško'),
991 (5, 1, 11027822, 'Lendava'),
992 (6, 1, 11027016, 'Lenart'),
993 (7, 1, 11027105, 'Mežica'),
994 (8, 1, 11027911, 'Miren-Kostanjevica'),
995 (9, 1, 11027148, 'Murska Sobota'),
996 (10, 1, 11027920, 'Mozirje'),
997 (11, 1, 11027156, 'Nova Gorica'),
998 (12, 1, 11027083, 'Majšperk'),
999 (13, 1, 11026630, 'Cerklje na Gorenjskem'),
1000 (14, 1, 11026788, 'Dravograd'),
1001 (15, 1, 11027946, 'Naklo'),
1002 (16, 1, 11027857, 'Ljutomer'),
1003 (17, 1, 11027849, 'Ljubljana'),
1004 (18, 1, 11027032, 'Ljubno'),
1005 (19, 1, 11027075, 'LuÄe'),
1006 (20, 1, 11027091, 'Mengeš'),
1007 (21, 1, 11027806, 'Kuzma'),
1008 (22, 1, 11027067, 'Loški Potok'),
1009 (23, 1, 11027121, 'MoravÄe'),
1010 (24, 1, 11026524, 'Beltinci'),
1011 (25, 1, 11026613, 'Tišina'),
1012 (26, 1, 11027750, 'Kobilje'),
1013 (27, 1, 11026958, 'Kobarid'),
1014 (28, 1, 11027776, 'Koper'),
1015 (29, 1, 11026796, 'Duplek'),
1016 (30, 1, 11026842, 'Gornji Petrovci'),
1017 (31, 1, 11026869, 'Grosuplje'),
1018 (32, 1, 11026893, 'Idrija'),
1019 (33, 1, 11027768, 'Komen'),
1020 (34, 1, 11026575, 'Bovec'),
1021 (35, 1, 11026516, 'AjdovÅ¡Äina'),
1022 (36, 1, 11026834, 'Gornji Grad'),
1023 (37, 1, 11027709, 'Hrpelje-Kozina'),
1024 (38, 1, 11026923, 'Izola'),
1025 (39, 1, 11027199, 'Pesnica'),
1026 (40, 1, 11028012, 'Podvelka'),
1027 (41, 1, 11027261, 'Radlje ob Dravi'),
1028 (42, 1, 11027229, 'Postojna'),
1029 (43, 1, 11027440, 'Å entilj'),
1030 (44, 1, 11026877, 'Å alovci'),
1031 (45, 1, 11027253, 'Radenci'),
1032 (46, 1, 11026672, 'Črna na Koroškem'),
1033 (47, 1, 11026737, 'Dobrepolje'),
1034 (48, 1, 11026656, 'Cerkno'),
1035 (49, 1, 11026974, 'Kozje'),
1036 (50, 1, 11026915, 'IvanÄna Gorica'),
1037 (51, 1, 11026605, 'Brežice'),
1038 (52, 1, 11028004, 'Pivka'),
1039 (53, 1, 11027245, 'RaÄe-Fram'),
1040 (54, 1, 11027423, 'Sveti Jurij ob Å Äavnici'),
1041 (55, 1, 11027610, 'Velenje'),
1042 (56, 1, 11027164, 'Odranci'),
1043 (57, 1, 11027296, 'Ribnica'),
1044 (58, 1, 11027342, 'SemiÄ'),
1045 (59, 1, 11027601, 'TurniÅ¡Äe'),
1046 (60, 1, 11027474, 'Å kocjan'),
1047 (61, 1, 11027512, 'Šmarje pri Jelšah'),
1048 (62, 1, 11027563, 'Tolmin'),
1049 (63, 1, 21427705, 'Dobrna'),
1050 (64, 1, 11027636, 'Vipava'),
1051 (65, 1, 21427799, 'Jezersko'),
1052 (66, 1, 21428086, 'Sveti Andraž v Slov. goricah'),
1053 (67, 1, 21427926, 'Å empeter-Vrtojba'),
1054 (68, 1, 11027555, 'Å tore'),
1055 (69, 1, 21428035, 'Polzela'),
1056 (70, 1, 21427764, 'Hodoš'),
1057 (71, 1, 21427918, 'SolÄava'),
1058 (72, 1, 11027393, 'Slovenska Bistrica'),
1059 (73, 1, 11027288, 'Ravne na Koroškem'),
1060 (74, 1, 11027385, 'Slovenj Gradec'),
1061 (75, 1, 11027431, 'Å enÄur'),
1062 (76, 1, 11028080, 'Vojnik'),
1063 (77, 1, 11027318, 'Rogašovci'),
1064 (78, 1, 11027237, 'Preddvor'),
1065 (79, 1, 11028039, 'Ptuj'),
1066 (80, 1, 21427900, 'Selnica ob Dravi'),
1067 (81, 1, 21427730, 'Grad'),
1068 (82, 1, 21436437, 'ApaÄe'),
1069 (83, 1, 11027687, 'ZreÄe'),
1070 (84, 1, 11027695, 'Žiri'),
1071 (85, 1, 21427721, 'Dolenjske Toplice'),
1072 (86, 1, 11028098, 'Vuzenica'),
1073 (87, 1, 11028071, 'Vitanje'),
1074 (88, 1, 21427691, 'Dobje'),
1075 (89, 1, 21427969, 'Trzin'),
1076 (90, 1, 21427713, 'Dobrovnik'),
1077 (91, 1, 11026621, 'Celje'),
1078 (92, 1, 21428043, 'Prevalje'),
1079 (93, 1, 21428094, 'Velika Polana'),
1080 (94, 1, 11026699, 'ÄŒrnomelj'),
1081 (95, 1, 11028128, 'Železniki'),
1082 (96, 1, 21427683, 'Cerkvenjak'),
1083 (97, 1, 21427675, 'Cankova'),
1084 (98, 1, 21428078, 'Sveta Ana'),
1085 (99, 1, 21427888, 'Prebold'),
1086 (100, 1, 21427934, 'Tabor'),
1087 (101, 1, 21427942, 'Trnovska vas'),
1088 (102, 1, 11026818, 'Gorišnica'),
1089 (103, 1, 21436488, 'PoljÄane'),
1090 (104, 1, 11027938, 'Muta'),
1091 (105, 1, 11027539, 'Å martno ob Paki'),
1092 (106, 1, 11027547, 'Šoštanj'),
1093 (107, 1, 24063453, 'RenÄe-Vogrsko'),
1094 (108, 1, 24063461, 'Gorje'),
1095 (109, 1, 11027741, 'KidriÄevo'),
1096 (110, 1, 21436445, 'Cirkulane'),
1097 (111, 1, 21428264, 'Å martno pri Litiji'),
1098 (112, 1, 11028063, 'Videm'),
1099 (113, 1, 21427756, 'HoÄe-Slivnica'),
1100 (114, 1, 21427853, 'Mirna PeÄ'),
1101 (115, 1, 11027407, 'Slovenske Konjice'),
1102 (116, 1, 11026702, 'Destrnik'),
1103 (117, 1, 21427870, 'Podlehnik'),
1104 (118, 1, 11026770, 'Dornava'),
1105 (119, 1, 21427748, 'Hajdina'),
1106 (120, 1, 11027172, 'Ormož'),
1107 (121, 1, 21427985, 'Žetale'),
1108 (122, 1, 21428051, 'Ribnica na Pohorju'),
1109 (123, 1, 21427977, 'Veržej'),
1110 (124, 1, 21427837, 'Križevci'),
1111 (125, 1, 21428019, 'Markovci'),
1112 (126, 1, 11026931, 'Juršinci'),
1113 (127, 1, 11027415, 'Starše'),
1114 (128, 1, 21427993, 'Žužemberk'),
1115 (129, 1, 11027377, 'Sežana'),
1116 (130, 1, 11027466, 'Å entjur'),
1117 (131, 1, 21433659, 'Straža'),
1118 (132, 1, 11026532, 'Bled'),
1119 (133, 1, 11026761, 'Domžale'),
1120 (134, 1, 21433667, 'Sveta Trojica v Slovenskih goricah'),
1121 (135, 1, 11027326, 'Rogaška Slatina'),
1122 (136, 1, 21428060, 'Sodražica'),
1123 (137, 1, 11027873, 'Lukovica'),
1124 (138, 1, 24063488, 'ReÄica ob Savinji'),
1125 (139, 1, 11026583, 'Brda'),
1126 (140, 1, 24063496, 'Sveti Jurij v Slovenskih goricah'),
1127 (141, 1, 11026826, 'Gornja Radgona'),
1128 (142, 1, 11026559, 'Bohinj'),
1129 (143, 1, 11026664, 'Črenšovci'),
1130 (144, 1, 11027270, 'Radovljica'),
1131 (145, 1, 21428108, 'Vransko'),
1132 (146, 1, 21427624, 'Benedikt'),
1133 (147, 1, 21433683, 'Šmarješke Toplice'),
1134 (148, 1, 21436453, 'Kostanjevica na Krki'),
1135 (149, 1, 21427802, 'Komenda'),
1136 (150, 1, 11027580, 'Trebnje'),
1137 (151, 1, 24063500, 'Å entrupert'),
1138 (152, 1, 11027792, 'Kranjska Gora'),
1139 (153, 1, 11026729, 'DivaÄa'),
1140 (154, 1, 11026745, 'Dobrova-Polhov Gradec'),
1141 (155, 1, 11027652, 'Vrhnika'),
1142 (156, 1, 21427667, 'BraslovÄe'),
1143 (157, 1, 24063526, 'Ankaran'),
1144 (158, 1, 11027628, 'Velike LaÅ¡Äe'),
1145 (159, 1, 11026753, 'Dol pri Ljubljani'),
1146 (160, 1, 11027865, 'Loška dolina'),
1147 (161, 1, 21427772, 'Horjul'),
1148 (162, 1, 24063518, 'Mirna'),
1149 (163, 1, 11026567, 'Borovnica'),
1150 (164, 1, 11027717, 'Ilirska Bistrica'),
1151 (165, 1, 24063470, 'Log-Dragomer'),
1152 (166, 1, 11027814, 'Laško'),
1153 (167, 1, 11027890, 'Medvode'),
1154 (168, 1, 11028055, 'RadeÄe'),
1155 (169, 1, 11026907, 'Ig'),
1156 (170, 1, 11027059, 'Logatec'),
1157 (171, 1, 11027504, 'Å kofljica'),
1158 (172, 1, 21427659, 'Bloke'),
1159 (173, 1, 11026591, 'Brezovica'),
1160 (174, 1, 11026800, 'Gorenja vas-Poljane'),
1161 (175, 1, 21428116, 'Žirovnica'),
1162 (176, 1, 11027725, 'Jesenice'),
1163 (177, 1, 11027679, 'Zagorje ob Savi'),
1164 (178, 1, 21427845, 'Lovrenc na Pohorju'),
1165 (179, 1, 11027881, 'Maribor'),
1166 (180, 1, 11027954, 'Nazarje'),
1167 (181, 1, 11027334, 'Ruše'),
1168 (182, 1, 21428027, 'Miklavž na Dravskem polju'),
1169 (183, 1, 11027997, 'Piran'),
1170 (184, 1, 11027482, 'Å kofja Loka'),
1171 (185, 1, 21427861, 'Oplotnica'),
1172 (186, 1, 21436461, 'Makole'),
1173 (187, 1, 11026885, 'Hrastnik'),
1174 (188, 1, 11026648, 'Cerknica'),
1175 (189, 1, 11027024, 'Litija'),
1176 (190, 1, 11027989, 'Osilnica'),
1177 (191, 1, 11027903, 'Metlika'),
1178 (192, 1, 11027571, 'Trbovlje'),
1179 (193, 1, 21436470, 'Mokronog-Trebelno'),
1180 (194, 1, 21427632, 'Bistrica ob Sotli'),
1181 (195, 1, 11027598, 'TržiÄ'),
1182 (196, 1, 11026966, 'KoÄevje'),
1183 (197, 1, 11026940, 'Kanal'),
1184 (198, 1, 11027644, 'Vodice'),
1185 (199, 1, 21427829, 'Kostel'),
1186 (200, 1, 11027130, 'Moravske Toplice'),
1187 (201, 1, 11027369, 'Sevnica'),
1188 (202, 1, 21428124, 'Žalec'),
1189 (203, 1, 21433675, 'Sveti Tomaž'),
1190 (204, 1, 11027784, 'Kranj'),
1191 (205, 1, 21427896, 'Razkrižje'),
1192 (206, 1, 11027202, 'PodÄetrtek'),
1193 (207, 1, 11028047, 'Puconci'),
1194 (208, 1, 11027458, 'Å entjernej'),
1195 (209, 1, 11027300, 'Rogatec'),
1196 (210, 1, 11027733, 'Kamnik'),
1197 (211, 1, 11028101, 'ZavrÄ'),
1198 (212, 1, 21433632, 'SrediÅ¡Äe ob Dravi');
1199
1200INSERT INTO `tpo`.`letnik`
1201(`ID_LETNIK`, `LETNIK`)VALUES
1202 (1,1),
1203 (2,2),
1204 (3,3);
1205
1206INSERT INTO `posta` (`ID_POSTA`, `AKTIVNOST`, `MID_POSTA`, `ST_POSTA`, `KRAJ`) VALUES
1207 (1, 1, 21428698, 8321, 'Brusnice'),
1208 (2, 1, 21431125, 8222, 'OtoÄec'),
1209 (3, 1, 21431656, 5297, 'PrvaÄina'),
1210 (4, 1, 21432539, 5261, 'Å empas'),
1211 (5, 1, 21429481, 5251, 'Grgar'),
1212 (6, 1, 21428850, 5253, 'ÄŒepovan'),
1213 (7, 1, 21432954, 5252, 'Trnovo pri Gorici'),
1214 (8, 1, 21431036, 8000, 'Novo mesto'),
1215 (9, 1, 21430854, 2382, 'Mislinja'),
1216 (10, 1, 21433420, 2201, 'Zgornja Kungota'),
1217 (11, 1, 21430412, 1231, 'Ljubljana - ÄŒrnuÄe'),
1218 (12, 1, 21430447, 1260, 'Ljubljana - Polje'),
1219 (13, 1, 21431150, 2211, 'Pesnica pri Mariboru'),
1220 (14, 1, 21429856, 2351, 'Kamnica'),
1221 (15, 1, 21430307, 9220, 'Lendava - Lendva'),
1222 (16, 1, 21433284, 2232, 'VoliÄina'),
1223 (17, 1, 21431834, 5292, 'RenÄe'),
1224 (18, 1, 21430064, 5296, 'Kostanjevica na Krasu'),
1225 (19, 1, 21430234, 8270, 'Krško'),
1226 (20, 1, 21430188, 9242, 'Križevci pri Ljutomeru'),
1227 (21, 1, 21430463, 1211, 'Ljubljana - Å martno'),
1228 (22, 1, 21430668, 9243, 'Mala Nedelja'),
1229 (23, 1, 21430293, 2230, 'Lenart v Slov. goricah'),
1230 (24, 1, 21432024, 8281, 'Senovo'),
1231 (25, 1, 21431672, 2323, 'Ptujska gora'),
1232 (26, 1, 21431141, 2231, 'Pernica'),
1233 (27, 1, 21428469, 8283, 'Blanca'),
1234 (28, 1, 21430790, 2392, 'Mežica'),
1235 (29, 1, 21431613, 2391, 'Prevalje'),
1236 (30, 1, 21430820, 5291, 'Miren'),
1237 (31, 1, 21432822, 3325, 'Šoštanj'),
1238 (32, 1, 21430951, 9000, 'Murska Sobota'),
1239 (33, 1, 21433144, 9241, 'Veržej'),
1240 (34, 1, 21430641, 2322, 'Majšperk'),
1241 (35, 1, 21430986, 3331, 'Nazarje'),
1242 (36, 1, 21430943, 3330, 'Mozirje'),
1243 (37, 1, 21431010, 5000, 'Nova Gorica'),
1244 (38, 1, 21430439, 1261, 'Ljubljana - Dobrunje'),
1245 (39, 1, 21431354, 4244, 'Podnart'),
1246 (40, 1, 21430765, 1215, 'Medvode'),
1247 (41, 1, 21432644, 1296, 'Å entvid pri StiÄni'),
1248 (42, 1, 21429775, 8261, 'Jesenice na Dolenjskem'),
1249 (43, 1, 21428744, 4207, 'Cerklje na Gorenjskem'),
1250 (44, 1, 21429422, 6272, 'GraÄiÅ¡Äe'),
1251 (45, 1, 21429228, 2370, 'Dravograd'),
1252 (46, 1, 21428884, 6275, 'ÄŒrni Kal'),
1253 (47, 1, 21429333, 5275, 'GodoviÄ'),
1254 (48, 1, 21430978, 4202, 'Naklo'),
1255 (49, 1, 21429236, 4203, 'Duplje'),
1256 (50, 1, 21430757, 4211, 'MavÄiÄe'),
1257 (51, 1, 21430480, 9240, 'Ljutomer'),
1258 (52, 1, 21430455, 1210, 'Ljubljana - Å entvid'),
1259 (53, 1, 21430404, 1000, 'Ljubljana'),
1260 (54, 1, 21431559, 4205, 'Preddvor'),
1261 (55, 1, 21433403, 4201, 'Zgornja Besnica'),
1262 (56, 1, 21433551, 4209, 'Žabnica'),
1263 (57, 1, 21430471, 3333, 'Ljubno ob Savinji'),
1264 (58, 1, 21430617, 3334, 'LuÄe'),
1265 (59, 1, 21430773, 1234, 'Mengeš'),
1266 (60, 1, 21429341, 4204, 'Golnik'),
1267 (61, 1, 21430242, 9263, 'Kuzma'),
1268 (62, 1, 21430587, 1318, 'Loški Potok'),
1269 (63, 1, 21430897, 1251, 'MoravÄe'),
1270 (64, 1, 21428396, 9231, 'Beltinci'),
1271 (65, 1, 21431451, 4223, 'Poljane nad Å kofjo Loko'),
1272 (66, 1, 21430382, 3202, 'LjubeÄna'),
1273 (67, 1, 21430994, 1357, 'Notranje Gorice'),
1274 (68, 1, 21431591, 1352, 'Preserje'),
1275 (69, 1, 21429961, 9227, 'Kobilje'),
1276 (70, 1, 21429953, 5222, 'Kobarid'),
1277 (71, 1, 21430030, 6000, 'Koper - Capodistria'),
1278 (72, 1, 21433349, 2367, 'Vuzenica'),
1279 (73, 1, 21432229, 2241, 'Spodnji Duplek'),
1280 (74, 1, 21432717, 6274, 'Å marje'),
1281 (75, 1, 21428914, 5262, 'ÄŒrniÄe'),
1282 (76, 1, 21431168, 9203, 'Petrovci'),
1283 (77, 1, 21432512, 9204, 'Å alovci'),
1284 (78, 1, 21430170, 9206, 'Križevci'),
1285 (79, 1, 21429520, 1290, 'Grosuplje'),
1286 (80, 1, 21432261, 8256, 'Sromlje'),
1287 (81, 1, 21433390, 8272, 'Zdole'),
1288 (82, 1, 21429651, 5280, 'Idrija'),
1289 (83, 1, 21431192, 8255, 'Pišece'),
1290 (84, 1, 21428434, 8259, 'Bizeljsko'),
1291 (85, 1, 21429821, 5214, 'Kal nad Kanalom'),
1292 (86, 1, 21429864, 1241, 'Kamnik'),
1293 (87, 1, 21430340, 2372, 'LibeliÄe'),
1294 (88, 1, 21429104, 1431, 'Dol pri Hrastniku'),
1295 (89, 1, 21433373, 1303, 'Zagradec'),
1296 (90, 1, 21430013, 6223, 'Komen'),
1297 (91, 1, 21428345, 6280, 'Ankaran - Ancarano'),
1298 (92, 1, 21428833, 5273, 'Col'),
1299 (93, 1, 21428566, 5230, 'Bovec'),
1300 (94, 1, 21429899, 8258, 'Kapele'),
1301 (95, 1, 21428337, 5270, 'AjdovÅ¡Äina'),
1302 (96, 1, 21429406, 3342, 'Gornji Grad'),
1303 (97, 1, 21432768, 3341, 'Å martno ob Dreti'),
1304 (98, 1, 21428361, 8253, 'ArtiÄe'),
1305 (99, 1, 21430102, 6240, 'Kozina'),
1306 (100, 1, 21429716, 6310, 'Izola - Isola'),
1307 (101, 1, 21430684, 6273, 'Marezige'),
1308 (102, 1, 21431893, 5215, 'RoÄinj'),
1309 (103, 1, 21432679, 6281, 'Å kofije'),
1310 (104, 1, 21432598, 2373, 'Šentjanž pri Dravogradu'),
1311 (105, 1, 21433195, 5271, 'Vipava'),
1312 (106, 1, 21432695, 3211, 'Å kofja vas'),
1313 (107, 1, 21431257, 8312, 'PodboÄje'),
1314 (108, 1, 21429015, 8257, 'Dobova'),
1315 (109, 1, 21428680, 4210, 'Brnik - Aerodrom'),
1316 (110, 1, 21429732, 2221, 'Jarenina'),
1317 (111, 1, 21431907, 3250, 'Rogaška Slatina'),
1318 (112, 1, 21431397, 2363, 'Podvelka'),
1319 (113, 1, 21430099, 2394, 'Kotlje'),
1320 (114, 1, 21428558, 8294, 'Boštanj'),
1321 (115, 1, 21432415, 8293, 'Studenec'),
1322 (116, 1, 21429830, 3233, 'Kalobje'),
1323 (117, 1, 21428809, 2215, 'Ceršak'),
1324 (118, 1, 21429376, 3263, 'Gorica pri Slivnici'),
1325 (119, 1, 21430161, 4294, 'Križe'),
1326 (120, 1, 21432369, 8322, 'StopiÄe'),
1327 (121, 1, 21431516, 6230, 'Postojna'),
1328 (122, 1, 21432474, 9244, 'Sveti Jurij ob Å Äavnici'),
1329 (123, 1, 21429988, 1338, 'KoÄevska Reka'),
1330 (124, 1, 21432407, 1313, 'Struge'),
1331 (125, 1, 21430196, 1301, 'Krka'),
1332 (126, 1, 21431249, 6276, 'Pobegi'),
1333 (127, 1, 21428949, 6271, 'Dekani'),
1334 (128, 1, 21433179, 2284, 'Videm pri Ptuju'),
1335 (129, 1, 21431745, 9252, 'Radenci'),
1336 (130, 1, 21430226, 8262, 'Krška vas'),
1337 (131, 1, 21428752, 8263, 'Cerklje ob Krki'),
1338 (132, 1, 21432709, 1291, 'Å kofljica'),
1339 (133, 1, 21432725, 1293, 'Å marje - Sap'),
1340 (134, 1, 21433217, 1294, 'Višnja Gora'),
1341 (135, 1, 21432296, 1332, 'Stara Cerkev'),
1342 (136, 1, 21428701, 3255, 'BuÄe'),
1343 (137, 1, 21428876, 2393, 'Črna na Koroškem'),
1344 (138, 1, 21433152, 1312, 'Videm - Dobrepolje'),
1345 (139, 1, 21431273, 3254, 'PodÄetrtek'),
1346 (140, 1, 21433608, 4226, 'Оiri'),
1347 (141, 1, 21432881, 9251, 'Tišina'),
1348 (142, 1, 21432202, 5281, 'Spodnja Idrija'),
1349 (143, 1, 21428787, 5282, 'Cerkno'),
1350 (144, 1, 21432814, 3201, 'Šmartno v Rožni dolini'),
1351 (145, 1, 21430323, 3261, 'LesiÄno'),
1352 (146, 1, 21432199, 4225, 'Sovodenj'),
1353 (147, 1, 21430129, 3260, 'Kozje'),
1354 (148, 1, 21433039, 1311, 'Turjak'),
1355 (149, 1, 21429686, 1295, 'IvanÄna Gorica'),
1356 (150, 1, 21428671, 8250, 'Brežice'),
1357 (151, 1, 21431109, 1316, 'Ortnek'),
1358 (152, 1, 21431966, 6333, 'SeÄovlje - Sicciole'),
1359 (153, 1, 21433128, 1315, 'Velike LaÅ¡Äe'),
1360 (154, 1, 21431206, 6257, 'Pivka'),
1361 (155, 1, 21429627, 6225, 'Hruševje'),
1362 (156, 1, 21431729, 2327, 'RaÄe'),
1363 (157, 1, 21429295, 2313, 'Fram'),
1364 (158, 1, 21429244, 6221, 'Dutovlje'),
1365 (159, 1, 21430579, 6219, 'Lokev'),
1366 (160, 1, 21431052, 9233, 'Odranci'),
1367 (161, 1, 21431842, 1310, 'Ribnica'),
1368 (162, 1, 21432008, 8333, 'SemiÄ'),
1369 (163, 1, 21429279, 2343, 'Fala'),
1370 (164, 1, 21433047, 9224, 'TurniÅ¡Äe'),
1371 (165, 1, 21432580, 8297, 'Šentjanž'),
1372 (166, 1, 21432792, 2383, 'Å martno pri Slovenj Gradcu'),
1373 (167, 1, 21429007, 3224, 'Dobje pri Planini'),
1374 (168, 1, 21428710, 8276, 'BuÄka'),
1375 (169, 1, 21432733, 3240, 'Šmarje pri Jelšah'),
1376 (170, 1, 21433012, 8295, 'TržiÅ¡Äe'),
1377 (171, 1, 21432571, 2212, 'Å entilj v Slov. goricah'),
1378 (172, 1, 21433322, 2365, 'Vuhred'),
1379 (173, 1, 21432890, 5220, 'Tolmin'),
1380 (174, 1, 21429040, 3204, 'Dobrna'),
1381 (175, 1, 21433535, 3214, 'ZreÄe'),
1382 (176, 1, 21433489, 4206, 'Zgornje Jezersko'),
1383 (177, 1, 21433241, 2255, 'Vitomarci'),
1384 (178, 1, 21432547, 5290, 'Å empeter pri Gorici'),
1385 (179, 1, 21432377, 3206, 'Stranice'),
1386 (180, 1, 21430005, 5211, 'Kojsko'),
1387 (181, 1, 21431133, 2361, 'Ožbalt'),
1388 (182, 1, 21432458, 2353, 'Sv. Duh na Ostrem Vrhu'),
1389 (183, 1, 21431982, 2352, 'Selnica ob Dravi'),
1390 (184, 1, 21432130, 5232, 'SoÄa'),
1391 (185, 1, 21431869, 2364, 'Ribnica na Pohorju'),
1392 (186, 1, 21429902, 2362, 'Kapla'),
1393 (187, 1, 21431486, 3313, 'Polzela'),
1394 (188, 1, 21429210, 3222, 'Dramlje'),
1395 (189, 1, 21430498, 3215, 'LoÄe'),
1396 (190, 1, 21432776, 3327, 'Å martno ob Paki'),
1397 (191, 1, 21431087, 2312, 'Orehova vas'),
1398 (192, 1, 21429562, 9205, 'Hodoš - Hodos'),
1399 (193, 1, 21432156, 3335, 'SolÄava'),
1400 (194, 1, 21429201, 8343, 'Dragatuš'),
1401 (195, 1, 21432105, 2310, 'Slovenska Bistrica'),
1402 (196, 1, 21431818, 2390, 'Ravne na Koroškem'),
1403 (197, 1, 21432750, 2315, 'Å martno na Pohorju'),
1404 (198, 1, 21431079, 2317, 'Oplotnica'),
1405 (199, 1, 21432563, 4208, 'Å enÄur'),
1406 (200, 1, 21433268, 3212, 'Vojnik'),
1407 (201, 1, 21433209, 4212, 'Visoko'),
1408 (202, 1, 21431915, 9262, 'Rogašovci'),
1409 (203, 1, 21433357, 8292, 'Zabukovje'),
1410 (204, 1, 21430072, 6256, 'Košana'),
1411 (205, 1, 21431494, 3232, 'Ponikva'),
1412 (206, 1, 21431583, 1276, 'Primskovo'),
1413 (207, 1, 21430927, 5216, 'Most na SoÄi'),
1414 (208, 1, 21432300, 8342, 'Stari trg ob Kolpi'),
1415 (209, 1, 21429449, 9264, 'Grad'),
1416 (210, 1, 21428353, 9253, 'ApaÄe'),
1417 (211, 1, 21431265, 5243, 'Podbrdo'),
1418 (212, 1, 21429708, 1411, 'Izlake'),
1419 (213, 1, 21429155, 8350, 'Dolenjske Toplice'),
1420 (214, 1, 21433225, 3205, 'Vitanje'),
1421 (215, 1, 21431303, 2381, 'Podgorje pri Slovenj Gradcu'),
1422 (216, 1, 21432997, 1236, 'Trzin'),
1423 (217, 1, 21429546, 8362, 'Hinje'),
1424 (218, 1, 21432270, 5224, 'Srpenica'),
1425 (219, 1, 21430510, 5231, 'Log pod Mangartom'),
1426 (220, 1, 21428736, 3000, 'Celje'),
1427 (221, 1, 21433110, 9225, 'Velika Polana'),
1428 (222, 1, 21428922, 8340, 'ÄŒrnomelj'),
1429 (223, 1, 21433586, 4228, 'Železniki'),
1430 (224, 1, 21431532, 3312, 'Prebold'),
1431 (225, 1, 21432865, 3304, 'Tabor'),
1432 (226, 1, 21428728, 9261, 'Cankova'),
1433 (227, 1, 21432962, 2254, 'Trnovska vas'),
1434 (228, 1, 21429252, 8361, 'Dvor'),
1435 (229, 1, 21432172, 4229, 'Sorica'),
1436 (230, 1, 21433187, 8344, 'Vinica'),
1437 (231, 1, 21428990, 1233, 'Dob'),
1438 (232, 1, 21431761, 1235, 'Radomlje'),
1439 (233, 1, 21431419, 2208, 'Pohorje'),
1440 (234, 1, 21432083, 5283, 'Slap ob Idrijci'),
1441 (235, 1, 21430749, 6242, 'Materija'),
1442 (236, 1, 21432440, 2233, 'Sv. Ana v Slov. goricah'),
1443 (237, 1, 21433055, 8323, 'Uršna sela'),
1444 (238, 1, 21430595, 2324, 'Lovrenc na Dravskem polju'),
1445 (239, 1, 21430714, 2281, 'Markovci'),
1446 (240, 1, 21431427, 2257, 'Polenšak'),
1447 (241, 1, 21433276, 5293, 'VolÄja Draga'),
1448 (242, 1, 21429929, 2325, 'KidriÄevo'),
1449 (243, 1, 21428612, 8280, 'Brestanica'),
1450 (244, 1, 21431753, 2360, 'Radlje ob Dravi'),
1451 (245, 1, 21431508, 6320, 'Portorož - Portorose'),
1452 (246, 1, 21432784, 1275, 'Å martno pri Litiji'),
1453 (247, 1, 21430803, 2204, 'Miklavž na Dravskem polju'),
1454 (248, 1, 21429554, 2311, 'HoÄe'),
1455 (249, 1, 21430846, 8216, 'Mirna PeÄ'),
1456 (250, 1, 21432113, 3210, 'Slovenske Konjice'),
1457 (251, 1, 21429309, 3213, 'Frankolovo'),
1458 (252, 1, 21430676, 2229, 'MaleÄnik'),
1459 (253, 1, 21431281, 2273, 'Podgorci'),
1460 (254, 1, 21431664, 2250, 'Ptuj'),
1461 (255, 1, 21428973, 2253, 'Destrnik'),
1462 (256, 1, 21432873, 3221, 'Teharje'),
1463 (257, 1, 21431338, 2286, 'Podlehnik'),
1464 (258, 1, 21429171, 2252, 'Dornava'),
1465 (259, 1, 21429848, 4246, 'Kamna Gorica'),
1466 (260, 1, 21431095, 2270, 'Ormož'),
1467 (261, 1, 21433594, 2287, 'Žetale'),
1468 (262, 1, 21429538, 2288, 'Hajdina'),
1469 (263, 1, 21431460, 2319, 'PoljÄane'),
1470 (264, 1, 21428370, 4275, 'Begunje na Gorenjskem'),
1471 (265, 1, 21428655, 4243, 'Brezje'),
1472 (266, 1, 21433080, 3320, 'Velenje'),
1473 (267, 1, 21430706, 2206, 'Marjeta na Dravskem polju'),
1474 (268, 1, 21432849, 6222, 'Å tanjel'),
1475 (269, 1, 21428531, 4265, 'Bohinjsko jezero'),
1476 (270, 1, 21430048, 8282, 'Koprivnica'),
1477 (271, 1, 21429813, 2256, 'Juršinci'),
1478 (272, 1, 21431389, 3257, 'Podsreda'),
1479 (273, 1, 21432326, 2205, 'Starše'),
1480 (274, 1, 21429384, 2272, 'Gorišnica'),
1481 (275, 1, 21431524, 2331, 'Pragersko'),
1482 (276, 1, 21428817, 2326, 'Cirkovce'),
1483 (277, 1, 21432903, 3326, 'Topolšica'),
1484 (278, 1, 21432067, 6210, 'Sežana'),
1485 (279, 1, 21428795, 2236, 'Cerkvenjak'),
1486 (280, 1, 21432504, 2258, 'Sv.Tomaž'),
1487 (281, 1, 21428825, 2282, 'Cirkulane'),
1488 (282, 1, 21428639, 2354, 'Bresternica'),
1489 (283, 1, 21431974, 4227, 'Selca'),
1490 (284, 1, 21429325, 8254, 'Globoko'),
1491 (285, 1, 21429074, 9223, 'Dobrovnik - Dobronak'),
1492 (286, 1, 21432610, 3230, 'Å entjur'),
1493 (287, 1, 21428477, 4260, 'Bled'),
1494 (288, 1, 21429511, 3231, 'Grobelno'),
1495 (289, 1, 21429163, 1230, 'Domžale'),
1496 (290, 1, 21432466, 2235, 'Sv. Trojica v Slov. goricah'),
1497 (291, 1, 21428400, 2234, 'Benedikt'),
1498 (292, 1, 21429198, 1319, 'Draga'),
1499 (293, 1, 21429147, 1331, 'Dolenja vas'),
1500 (294, 1, 21428515, 4263, 'Bohinjska Bela'),
1501 (295, 1, 21431176, 3301, 'PetrovÄe'),
1502 (296, 1, 21432148, 1317, 'Sodražica'),
1503 (297, 1, 21429937, 1412, 'Kisovec'),
1504 (298, 1, 21430625, 1225, 'Lukovica'),
1505 (299, 1, 21432237, 9245, 'Spodnji Ivanjci'),
1506 (300, 1, 21430218, 4245, 'Kropa'),
1507 (301, 1, 21430315, 4248, 'Lesce'),
1508 (302, 1, 21429082, 5212, 'Dobrovo v Brdih'),
1509 (303, 1, 21429392, 9250, 'Gornja Radgona'),
1510 (304, 1, 21433365, 1410, 'Zagorje ob Savi'),
1511 (305, 1, 21431001, 3203, 'Nova Cerkev'),
1512 (306, 1, 21433454, 2213, 'Zgornja Velka'),
1513 (307, 1, 21428523, 4264, 'Bohinjska Bistrica'),
1514 (308, 1, 21432253, 4267, 'Srednja vas v Bohinju'),
1515 (309, 1, 21432741, 8220, 'Šmarješke Toplice'),
1516 (310, 1, 21432601, 8310, 'Å entjernej'),
1517 (311, 1, 21428868, 9232, 'Črenšovci'),
1518 (312, 1, 21429503, 3302, 'Griže'),
1519 (313, 1, 21431770, 4240, 'Radovljica'),
1520 (314, 1, 21433292, 3305, 'Vransko'),
1521 (315, 1, 21430056, 8311, 'Kostanjevica na Krki'),
1522 (316, 1, 21429694, 2259, 'Ivanjkovci'),
1523 (317, 1, 21432652, 8275, 'Å kocjan'),
1524 (318, 1, 21432393, 8351, 'Straža pri Novem mestu'),
1525 (319, 1, 21428957, 5210, 'Deskle'),
1526 (320, 1, 21431214, 6232, 'Planina'),
1527 (321, 1, 21430200, 8296, 'Krmelj'),
1528 (322, 1, 21433314, 1360, 'Vrhnika'),
1529 (323, 1, 21430021, 1218, 'Komenda'),
1530 (324, 1, 21432946, 8210, 'Trebnje'),
1531 (325, 1, 21432636, 8232, 'Å entrupert'),
1532 (326, 1, 21429643, 4276, 'Hrušica'),
1533 (327, 1, 21431605, 6258, 'Prestranek'),
1534 (328, 1, 21429350, 3303, 'Gomilsko'),
1535 (329, 1, 21432687, 4220, 'Å kofja Loka'),
1536 (330, 1, 21429945, 6253, 'Knežak'),
1537 (331, 1, 21429414, 4282, 'Gozd Martuljek'),
1538 (332, 1, 21430145, 4280, 'Kranjska Gora'),
1539 (333, 1, 21428981, 6215, 'DivaÄa'),
1540 (334, 1, 21432628, 3271, 'Å entrupert'),
1541 (335, 1, 21433306, 6217, 'Vremski Britof'),
1542 (336, 1, 21431044, 6243, 'Obrov'),
1543 (337, 1, 21431346, 5272, 'Podnanos'),
1544 (338, 1, 21432032, 6224, 'SenožeÄe'),
1545 (339, 1, 21429066, 1356, 'Dobrova'),
1546 (340, 1, 21428841, 1413, 'Čemšenik'),
1547 (341, 1, 21432911, 2371, 'Trbonje'),
1548 (342, 1, 21433411, 2242, 'Zgornja Korena'),
1549 (343, 1, 21429473, 5242, 'Grahovo ob BaÄi'),
1550 (344, 1, 21429791, 2223, 'Jurovski Dol'),
1551 (345, 1, 21432555, 3311, 'Å empeter v Savinjski dolini'),
1552 (346, 1, 21433527, 1432, 'Zidani Most'),
1553 (347, 1, 21433462, 4247, 'Zgornje Gorje'),
1554 (348, 1, 21428485, 4273, 'Blejska Dobrava'),
1555 (349, 1, 21431788, 8274, 'Raka'),
1556 (350, 1, 21430331, 8273, 'Leskovec pri Krškem'),
1557 (351, 1, 21432164, 5250, 'Solkan'),
1558 (352, 1, 21428582, 3314, 'BraslovÄe'),
1559 (353, 1, 21431621, 3262, 'Prevorje'),
1560 (354, 1, 21430935, 1221, 'Motnik'),
1561 (355, 1, 21429112, 1262, 'Dol pri Ljubljani'),
1562 (356, 1, 21432318, 1386, 'Stari trg pri Ložu'),
1563 (357, 1, 21431567, 6255, 'Prem'),
1564 (358, 1, 21431362, 3241, 'Podplat'),
1565 (359, 1, 21428540, 1353, 'Borovnica'),
1566 (360, 1, 21429678, 6250, 'Ilirska Bistrica'),
1567 (361, 1, 21430285, 1219, 'Laze v Tuhinju'),
1568 (362, 1, 21430277, 3270, 'Laško'),
1569 (363, 1, 21428442, 1223, 'Blagovica'),
1570 (364, 1, 21430269, 2318, 'Laporje'),
1571 (365, 1, 21430889, 8230, 'Mokronog'),
1572 (366, 1, 21432121, 1216, 'Smlednik'),
1573 (367, 1, 21433438, 2316, 'Zgornja Ložnica'),
1574 (368, 1, 21433446, 2314, 'Zgornja Polskava'),
1575 (369, 1, 21431885, 1314, 'Rob'),
1576 (370, 1, 21429783, 3273, 'Jurklošter'),
1577 (371, 1, 21432288, 1242, 'Stahovica'),
1578 (372, 1, 21430552, 3223, 'Loka pri Оusmu'),
1579 (373, 1, 21430366, 2341, 'Limbuš'),
1580 (374, 1, 21429597, 1372, 'Hotedršica'),
1581 (375, 1, 21432482, 3264, 'Sveti Å tefan'),
1582 (376, 1, 21430960, 2366, 'Muta'),
1583 (377, 1, 21431222, 3225, 'Planina pri Sevnici'),
1584 (378, 1, 21429180, 5294, 'Dornberk'),
1585 (379, 1, 21429724, 2222, 'Jakobski dol'),
1586 (380, 1, 21429660, 1292, 'Ig'),
1587 (381, 1, 21429023, 1423, 'Dobovec'),
1588 (382, 1, 21430536, 1370, 'Logatec'),
1589 (383, 1, 21428388, 1382, 'Begunje pri Cerknici'),
1590 (384, 1, 21433098, 8212, 'Velika Loka'),
1591 (385, 1, 21433101, 2274, 'Velika Nedelja'),
1592 (386, 1, 21431796, 1381, 'Rakek'),
1593 (387, 1, 21430838, 8233, 'Mirna'),
1594 (388, 1, 21428663, 1351, 'Brezovica pri Ljubljani'),
1595 (389, 1, 21429058, 8211, 'DobrniÄ'),
1596 (390, 1, 21433624, 8360, 'Оužemberk'),
1597 (391, 1, 21433616, 4274, 'Оirovnica'),
1598 (392, 1, 21428906, 5274, 'ÄŒrni vrh nad Idrijo'),
1599 (393, 1, 21429368, 4224, 'Gorenja vas'),
1600 (394, 1, 21432342, 2289, 'Stoperce'),
1601 (395, 1, 21429767, 4270, 'Jesenice'),
1602 (396, 1, 21430609, 2344, 'Lovrenc na Pohorju'),
1603 (397, 1, 21432857, 3220, 'Å tore'),
1604 (398, 1, 21430692, 2000, 'Maribor'),
1605 (399, 1, 21430811, 2275, 'Miklavž pri Ormožu'),
1606 (400, 1, 21431826, 3332, 'ReÄica ob Savinji'),
1607 (401, 1, 21431940, 2342, 'Ruše'),
1608 (402, 1, 21429465, 1384, 'Grahovo'),
1609 (403, 1, 21432989, 1222, 'Trojane'),
1610 (404, 1, 21432091, 2380, 'Slovenj Gradec'),
1611 (405, 1, 21429589, 1354, 'Horjul'),
1612 (406, 1, 21428418, 2345, 'Bistrica ob Dravi'),
1613 (407, 1, 21431184, 6330, 'Piran - Pirano'),
1614 (408, 1, 21430528, 1358, 'Log pri Brezovici'),
1615 (409, 1, 21430650, 2321, 'Makole'),
1616 (410, 1, 21431320, 1414, 'Podkum'),
1617 (411, 1, 21428892, 3272, 'Rimske Toplice'),
1618 (412, 1, 21430544, 1434, 'Loka pri Zidanem Mostu'),
1619 (413, 1, 21431028, 1385, 'Nova Vas'),
1620 (414, 1, 21428493, 9265, 'Bodonci'),
1621 (415, 1, 21429759, 6254, 'Jelšane'),
1622 (416, 1, 21429619, 1430, 'Hrastnik'),
1623 (417, 1, 21428779, 1380, 'Cerknica'),
1624 (418, 1, 21431478, 1272, 'Polšnik'),
1625 (419, 1, 21431737, 1433, 'RadeÄe'),
1626 (420, 1, 21430374, 1270, 'Litija'),
1627 (421, 1, 21431117, 1337, 'Osilnica'),
1628 (422, 1, 21431923, 3252, 'Rogatec'),
1629 (423, 1, 21431630, 3253, 'Pristava pri Mestinju'),
1630 (424, 1, 21430781, 8330, 'Metlika'),
1631 (425, 1, 21432920, 1420, 'Trbovlje'),
1632 (426, 1, 21431800, 4283, 'RateÄe Planica'),
1633 (427, 1, 21430862, 4281, 'Mojstrana'),
1634 (428, 1, 21428426, 3256, 'Bistrica ob Sotli'),
1635 (429, 1, 21433004, 4290, 'TržiÄ'),
1636 (430, 1, 21432423, 8331, 'Suhor'),
1637 (431, 1, 21432075, 2214, 'Sladki Vrh'),
1638 (432, 1, 21432938, 8231, 'Trebelno'),
1639 (433, 1, 21429970, 1330, 'KoÄevje'),
1640 (434, 1, 21429457, 8332, 'Gradac'),
1641 (435, 1, 21428507, 9222, 'Bogojina'),
1642 (436, 1, 21433063, 1252, 'VaÄe'),
1643 (437, 1, 21429872, 5213, 'Kanal'),
1644 (438, 1, 21431958, 1282, 'Sava'),
1645 (439, 1, 21430153, 1281, 'Kresnice'),
1646 (440, 1, 21431648, 9207, 'Prosenjakovci - PÑrtosfalva'),
1647 (441, 1, 21429287, 9208, 'Fokovci'),
1648 (442, 1, 21433250, 1217, 'Vodice'),
1649 (443, 1, 21433071, 1336, 'Kostel'),
1650 (444, 1, 21433136, 8213, 'Veliki Gaber'),
1651 (445, 1, 21428329, 8341, 'AdleÅ¡iÄi'),
1652 (446, 1, 21431311, 6244, 'Podgrad'),
1653 (447, 1, 21430722, 9221, 'Martjanci'),
1654 (448, 1, 21431699, 9201, 'Puconci'),
1655 (449, 1, 21433519, 2285, 'Zgornji Leskovec'),
1656 (450, 1, 21430919, 9226, 'Moravske Toplice'),
1657 (451, 1, 21432059, 8290, 'Sevnica'),
1658 (452, 1, 21429031, 5263, 'Dobravlje'),
1659 (453, 1, 21428574, 5295, 'Branik'),
1660 (454, 1, 21433560, 3310, 'Оalec'),
1661 (455, 1, 21430137, 4000, 'Kranj'),
1662 (456, 1, 24034658, 9246, 'Razkrižje'),
1663 (457, 1, 21429139, 1273, 'Dole pri Litiji'),
1664 (458, 1, 21429317, 1274, 'Gabrovka'),
1665 (459, 1, 21431435, 1355, 'Polhov Gradec'),
1666 (460, 1, 21431931, 1373, 'Rovte'),
1667 (461, 1, 21430633, 9202, 'MaÄkovci'),
1668 (462, 1, 21433381, 2283, 'ZavrÄ'),
1669 (463, 1, 21432245, 2277, 'SrediÅ¡Äe ob Dravi'),
1670 (464, 1, 21428604, 5223, 'Breginj'),
1671 (465, 1, 21429996, 2276, 'Kog'),
1672 (466, 1, 21431290, 6216, 'Podgorje');
1673
1674
1675INSERT INTO `tpo`.`nacin_studija`
1676(`ID_NACIN`,`OPIS_NACIN`,`ANG_OPIS_NACIN`,`AKTIVNOST`)VALUES
1677 (1,'redni','full-time',1),
1678 (2,'izredni','part-time',1);
1679
1680
1681INSERT INTO `tpo`.`oblika_studija`
1682(`ID_OBLIKA`,`NAZIV_OBLIKA`,`ANG_OPIS_OBLIKA`,`AKTIVNOST`)VALUES
1683 (1,'na lokaciji','on site','e-learning'),
1684 (2,'na daljavo','distance learning','e-learning'),
1685 (3,'e-studij','e-studij','e-learning');
1686
1687INSERT INTO `tpo`.`vrsta_vpisa`
1688(`ID_VRSTAVPISA`,`OPIS_VPISA`,`AKTIVNOST`)VALUES
1689 (1,'Prvi vpis v letnik',1),
1690 (2,'Ponavlanje letnika',1),
1691 (3,'Prvi vpis v letnik/dodatno leto',1);
1692
1693INSERT INTO `tpo`.`stopnja`(`ID_STOPNJA`, `NAZIV`,`SIFRA`,`MOZEN_VPIS`)VALUES
1694 (1,'Stari dodiplomski program-uni','123',0),
1695 (2,'Stari dodiplomski-visokosolski', '123',0),
1696 (3,'1. stopnja', '123',1),
1697 (4,'2. stopnja', '123',1),
1698 (5,'3. stopnja', '123',1),
1699 (6,'EM', '123',1),
1700 (7,'Stari magistrski studij', '123',0),
1701 (8,'Stari doktorski studij', '123',0);
1702
1703INSERT INTO `tpo`.`program`(`ID_PROGRAM`, `ID_STOPNJA`, `SIFRA_PROGRAM`, `NAZIV_PROGRAM`,
1704 `ST_SEMESTROV`,`SIFRA_EVS`,`AKTIVNOST`)VALUES
1705 (1,8,'LE','INF. SISTEMI IN ODLOÄŒANJE - DR',4,1000479,1),
1706 (2,7,'L3','INFORMAC. SISTEMI IN ODLOÄŒANJE - MAG',4,1000480,1),
1707 (3,4,'X5','Kognitivna znanost MAG II. st.',4,1000472,1),
1708 (4,3,'MM', 'Multimedija UN 1. st.',6,1001001,1),
1709 (5,4,'7002801','PEDAGOŠKO RAČ. IN INF. MAG-II. st.',4,1000977,1),
1710 (6,1,'L2','RAÄŒUNAL. IN INFROMATIKA UN',9,1000475,1),
1711 (7,1,'P7','RAÄŒUNAL. IN MATEMATIKA UN',8,1000425,1),
1712 (8,2,'HB','RAÄŒUNAL. IN INFORMATIKA VS',6,1000477,1),
1713 (9,3,'VV','RAÄŒUNAL. IN MATEMA. UN-I.ST',6,1000407,1),
1714 (10,4,'L1','RAÄŒUNALN. IN INFORM. MAG II.ST',4,1000471,1),
1715 (11,3,'VT','RAÄŒUNALN. IN INFORM. UN-I.ST',6,1000468,1),
1716 (12,3,'VU','RAÄŒUNALN. IN INFORM. VS-I.ST',6,1000470,1),
1717 (13,5,'X6','RAÄŒUNALNIÅ . IN INF. DR-III ST.',6,1000474,1),
1718 (14,8,'7E','RAÄŒUNALNIÅ TVO IN INF. - DR', 4,1000478,1),
1719 (15,7,'71','RAÄŒUNALNIÅ TVO IN INF. - MAG',4,1000481,1),
1720 (16,3,'02','RAÄŒUNALNIÅ TVO IN INF. - VIS',8,1,1),
1721 (17,3,'03','RAÄŒUNALNIÅ TVO IN INF. - VÅ ',4,1,1),
1722 (18,4,'KP00','RaÄnalniÅ¡tvo in matematika MAG II. st.',4,1000934,1),
1723 (19,3,'Z2','Upravna informatika UN 1. st.',6,1000469,1),
1724 (20,5,'XU','Humanistika in družb.-DR. III',6,1,1);
1725
1726INSERT INTO `tpo`.`studijsko_leto`(`ID_STUD_LETO`, `STUD_LETO`)VALUES
1727 (0,'2015/16'),
1728 (1,'2016/17'),
1729 (2,'2017/18'),
1730 (3,'2018/19'),
1731 (4,'2019/20'),
1732 (5,'2020/21'),
1733 (6,'2021/22'),
1734 (7,'2022/23'),
1735 (8,'2023/24');
1736
1737 /*
1738 1-100 --> Studenti
1739 100-200 --> Profesorji. Mail je: imeP@uni-lj.si
1740 300 = Referent
1741 400 = Admin
1742
1743
1744 */
1745
1746INSERT INTO `tpo`.`oseba`(`ID_OSEBA`,`EMAIL`,`UPORABNISKO_IME`,`GESLO`,`VRSTA_VLOGE`,`IME`,`PRIIMEK`,`TELEFONSKA_STEVILKA`, `SIFRA_IZVAJALCA`)VALUES
1747 (1, 'ab0001@student.uni-lj.si', 'ab0001', '123456', 's', 'Ana', 'Balon', '040040040' ,NULL ),
1748 (2, 'bc0002@student.uni-lj.si', 'bc0002', '123456', 's', 'Borut', 'Cementarna', '040040040' ,NULL ),
1749 (3, 'cd0003@student.uni-lj.si', 'cd0003', '123456', 's', 'Cilko', 'Dobovšek', '040040040' ,NULL ),
1750 (4, 'de0004@student.uni-lj.si', 'de0004', '123456', 's', 'Demir', 'Ehratatan', '040040040' ,NULL ),
1751 (5, 'ef0005@student.uni-lj.si', 'ef0005', '123456', 's', 'Evelina', 'FraÄa', '040040040' ,NULL ),
1752 (6, 'fg0006@student.uni-lj.si', 'fg0006', '123456', 's', 'Filip', 'Granata', '040040040' ,NULL ),
1753 (7, 'gh0007@student.uni-lj.si', 'gh0007', '123456', 's', 'Gaja', 'Humovar', '040040040' ,NULL ),
1754 (8, 'hi0008@student.uni-lj.si', 'hi0008', '123456', 's', 'Hilda', 'Ilirai', '040040040' ,NULL ),
1755 (9, 'ij0009@student.uni-lj.si', 'ij0009', '123456', 's', 'Ibrahim', 'JuvanÄiÄ', '040040040' ,NULL ),
1756 (10, 'jk0010@student.uni-lj.si', 'jk0010', '123456', 's', 'Jovan', 'Klepec', '040040040' ,NULL ),
1757 (11, 'kl0011@student.uni-lj.si', 'kl0011', '123456', 's', 'Klemen', 'Lizard', '040040040' ,NULL ),
1758 (12, 'lm0012@student.uni-lj.si', 'lm0012', '123456', 's', 'Lin-Wun', 'Mun-Son', '040040040' ,NULL ),
1759 (13, 'mn0013@student.uni-lj.si', 'mn0013', '123456', 's', 'Milorad', 'Namiljen', '040040040' ,NULL ),
1760 (14, 'no0014@student.uni-lj.si', 'no0014', '123456', 's', 'Nik', 'Opresnik', '040040040' ,NULL ),
1761 (15, 'op0015@student.uni-lj.si', 'op0015', '123456', 's', 'Olin', 'Polin', '040040040' ,NULL ),
1762
1763
1764 /* 1. Letnik - Profesorji */
1765 (100, 'gasperF@uni-lj.si', 'GašperF', '123456', 'p', 'Gašper', 'Fijavž', '040502896' ,100100),
1766 (101, 'polonaO@uni-lj.si', 'PolonaO', '123456', 'p', 'Polona', 'Oblak', '040502896' ,100101),
1767 (102, 'vilijanM@uni-lj.si', 'VilijanM', '123456', 'p', 'Vilijan', 'MahniÄ', '040502896' ,100102),
1768 (103, 'nikolajZ@uni-lj.si', 'NikolajZ', '123456', 'p', 'Nikolaj', 'Zimic', '040502896' ,100103),
1769 (104, 'irenaD@uni-lj.si', 'IrenaD', '123456', 'p', 'Irena', 'Drvenšek', '040502896' ,100104),
1770 (105, 'bostjanS@uni-lj.si', 'BoštijanS', '123456', 'p', 'Boštijan', 'Slivnik', '040502896' ,100105),
1771 (106, 'brankoS@uni-lj.si', 'BrankoÅ ', '123456', 'p', 'Branko', 'Å ter', '040502896' ,100106),
1772 (107, 'zoranB@uni-lj.si', 'ZoranB', '123456', 'p', 'Zoran', 'BosniÄ', '040502896' ,100107),
1773 (108, 'dejanL@uni-lj.si', 'DejanL', '123456', 'p', 'Dejan', 'LavbiÄ', '040502896' ,100108),
1774 (109, 'bojanO@uni-lj.si', 'BojanO', '123456', 'p', 'Bojan', 'Orel', '040502896' ,100109),
1775
1776 /* 2. Letnik - Profesorji */
1777 (110, 'patricioB@uni-lj.si', 'GaÅ¡perF', '123456', 'p', 'Patricio', 'BuliÄ', '040502896' ,100110),
1778 (111, 'aleksandarJ@uni-lj.si', 'aleksandarJ', '123456', 'p', 'Aleksandar', 'JuriÅ¡iÄ', '040502896' ,100111),
1779 (112, 'igorK@uni-lj.si', 'igorK', '123456', 'p', 'Igor', 'Kononenko', '040502896' ,100112),
1780 (113, 'markoB@uni-lj.si', 'markoB', '123456', 'p', 'Marko', 'Bajec', '040502896' ,100113),
1781 (114, 'borutR@uni-lj.si', 'borutR', '123456', 'p', 'Borut', 'RobiÄ', '040502896' ,100114),
1782 (115, 'urosL@uni-lj.si', 'urosL', '123456', 'p', 'UroÅ¡', 'LotriÄ', '040502896' ,100115),
1783 (116, 'nezaM@uni-lj.si', 'nezaM', '123456', 'p', 'Neža', 'Mramor Kosta', '040502896' ,100116),
1784 (117, 'ivanB@uni-lj.si', 'ivanB', '123456', 'p', 'Ivan', 'Bratko', '040502896' ,100117),
1785 (118, 'rokZ@uni-lj.si', 'rokZ', '123456', 'p', 'Rok', 'Žitko', '040502896' ,100118),
1786
1787 /* 3. Letnik - Profesorji */
1788 /* Modul: IS */
1789 (119, 'tomazH@uni-lj.si', 'tomazH', '123456', 'p', 'Tomaž', 'Hovelja', '040502896' ,100119),
1790 (120, 'denisT@uni-lj.si', 'denisT', '123456', 'p', 'Denis', 'TrÄek', '040502896' ,100120),
1791 (121, 'blazZ@uni-lj.si', 'blazZ', '123456', 'p', 'Blaž', 'Zupan', '040502896' ,100121),
1792
1793 /* Modul: Odvladovanje informatike */
1794 (122, 'matjazK@uni-lj.si', 'tomazH', '123456', 'p', 'Matjaž', 'Kukar', '040502896' ,100122),
1795 (123, 'rokR@uni-lj.si', 'rokR', '123456', 'p', 'Rok', 'Rupnik', '040502896' ,100123),
1796
1797 /* Modul: Razvoj prog. opreme */
1798 (124, 'matjazJ@uni-lj.si', 'matjazJ', '123456', 'p', 'Matjaž B', 'JuriÄ', '040502896' ,100124),
1799
1800 /* Modul: RaÄunalniÅ¡ka omrežja */
1801 (125, 'mihaM@uni-lj.si', 'mihaM', '123456', 'p', 'Miha', 'Mraz', '040502896' ,100125),
1802 (126, 'mojcaC@uni-lj.si', 'mojcaC', '123456', 'p', 'Mojca', 'CiglariÄ', '040502896',100126),
1803
1804 /* Modul: Umetna intelignca */
1805 (127, 'markoR@uni-lj.si', 'markoR', '123456', 'p', 'Marko', 'Robnik Å ikonja', '040502896',100127),
1806 (128, 'matejK@uni-lj.si', 'matejK', '123456', 'p', 'Matej', 'Kristan', '040502896',100128),
1807 (129, 'danielS@uni-lj.si', 'danielS', '123456', 'p', 'Daniel', 'SkoÄaj', '040502896',100129),
1808
1809 /* Modul: Medijske tehnologije */
1810 (130, 'narvikaB@uni-lj.si', 'mojcaC', '123456', 'p', 'Narvika', 'Bovcon', '040502896',100130),
1811 (131, 'lukaS@uni-lj.si', 'lukaS', '123456', 'p', 'Luka', 'Å ajn', '040502896',100131),
1812 (132, 'matijaM@uni-lj.si', 'matijaM', '123456', 'p', 'Matija', 'Marolt', '040502896',100132),
1813
1814 (300, 'referentFri@uni-lj.si', 'referentFri', '123456', 'p', 'Berta', 'Prijaznik', '040502896',NULL),
1815 (400, 'adminFri@uni-lj.si', 'adminFri', '123456', 'p', 'Simon', 'Stroj', '040502896',NULL);
1816
1817
1818-- absolvent, pogojnoNaprej, PonavljalecNaredl7, zamenjalProgram
1819-- preverjanje login:
1820-- uporabnisko ime=testS geslo='123456'
1821-- VRSTA_VLOGE: admin='a', referat='r', profesor='p', student='s' in kandidat='k'
1822
1823
1824-- Inserti preko import fila
1825INSERT INTO `tpo`.`kandidat`(`ID_KANDIDAT`, `ID_PROGRAM`, `ID_OSEBA`, `ID_STUD_LETO`, `IZKORISCEN`, `EMSO`, `VPISNA_STEVILKA`) VALUES
1826 (1,11, 1, 0,1,1706996500334,63150001),
1827 (2,11, 2, 0,1,1706996500334,63150002),
1828 (3,11, 3, 0,1,1706996500334,63150003),
1829 (4,11, 4, 0,1,1706996500334,63150004),
1830 (5,11, 5, 0,1,1706996500334,63150005),
1831 (6,11, 6, 1,1,1706996500334,63150006),
1832 (7,11, 7, 1,1,1706996500334,63150007),
1833 (8,11, 8, 1,1,1706996500334,63150008),
1834 (9,11, 9, 1,1,1706996500334,63150009),
1835 (10,11,10,1,1,1706996500334,63150010),
1836 (11,11,11,2,1,1706996500334,63150011),
1837 (12,11,12,2,1,1706996500334,63150012),
1838 (13,11,13,2,1,1706996500334,63150013),
1839 (14,11,14,2,1,1706996500334,63150014),
1840 (15,11,15,2,1,1706996500334,63150015);
1841
1842/*
1843 1. Letnik = 10-19
1844 2. Letnik
1845 -Obvezni = 20-27
1846 -Strokovni izbirni = 28-30
1847 3. Letnik
1848 -Obvezni = 31-33
1849 -Moduli =
1850 */
1851INSERT INTO `tpo`.`PREDMET`
1852(`ID_PREDMET`, `SIFRA_PREDMET`, `IME_PREDMET`, `AKTIVNOST`)
1853VALUES
1854
1855 /* 1. Letnik */
1856 (10, 63702,'Programiranje 1', 1),
1857 (11, 63202,'Osnove MatematiÄne Analize', 1),
1858 (12, 63203,'Diskretne Strukture', 1),
1859 (13, 63204,'Osnove Digitalnih Vezji', 1),
1860 (14, 63205,'Fizika', 1),
1861 (15, 63706,'Programiranje 2', 1),
1862 (16, 63207,'Linearna Algebra', 1),
1863 (17, 63212,'Arhitekrura RaÄunalniÅ¡kih Sistemov', 1),
1864 (18, 63708,'RaÄunalniÅ¡ke Komunikacije', 1),
1865 (19, 63215,'Osnove Informacijskih Sistemov', 1),
1866
1867 /* 2. Letnik - Obvezni */
1868 (20, 63711,'Algoritmi in Podatkovne Strukture 1', 1),
1869 (21, 63723,'Algoritmi in Podatkovne Strukture 2', 1),
1870 (22, 63208,'Osnove Podatkovnih Baz', 1),
1871 (23, 63213,'Verjetnost in Statistika', 1),
1872 (24, 63283,'IzraÄunljivost in RaÄunska Zahtevnost', 1),
1873 (25, 63216,'Teorija Informacij in Sistemov', 1),
1874 (26, 63217,'Opreacijski Sistemi', 1),
1875 (27, 63218,'Organizacija RaÄunalniÅ¡kih Sistemov', 1),
1876
1877 /* 2. Letnik - Strokovni izbirni */
1878 (28, 63220,'Principi Programskih Jezikov', 1),
1879 (29, 63219,'MatematiÄno modeliranje', 1),
1880 (30, 63221,'RaÄunalniÅ¡ke Tehnologije', 1),
1881
1882 /* 3. Letnik - Obvezni */
1883 (31, 63214,'Osnove Umetne Inteligence', 1),
1884 (32, 63248,'Ekonomika in Podjetništvo ', 1),
1885 (33, 63281,'Diplomski seminar', 1),
1886
1887 /* 3. Letnik - Moduli */
1888 (34, 63256,'Tehnologija Programske Opreme', 1),
1889 (35 63254,'Postopki Razvoja Programke Opreme', 1),
1890 (36, 63255,'Spletno Progrmiranje', 1),
1891
1892 (37, 63249,'Elektronsko Poslovanje', 1),
1893 (38, 63250,'Organizacija in Management', 1),
1894 (39, 63251,'Uvod v odkrivanje znanj iz podatkov', 1),
1895
1896 (40, 63226,'Tehnologija Upravljanja Podatkov', 1),
1897 (41, 63725,'Razvoj Informacijskih Sistemov', 1),
1898 (42, 63253,'Planiranje in Upravljanje Informatike', 1),
1899
1900 (43, 63258,'Komunikacijski Protokoli', 1),
1901 (44, 63259,'BrezžiÄna in Mobilna Omrežja', 1),
1902 (45, 63257,'Modeliranje RaÄunalniÅ¡kih Omrežji', 1),
1903
1904 (46, 63262,'Zanesljivost in zmogljivost raÄunalniÅ¡kih sistemov', 1),
1905 (47, 63260,'Digitalno naÄrtovanje', 1),
1906 (48, 63261,'Porazdeljeni sistemi', 1),
1907
1908 (49, 63264,'Sistemska programska oprema', 1),
1909 (50, 63263,'RaÄunska zahtevnost in hevristiÄno programiranje', 1),
1910 (51, 63265,'Prevajalniki', 1),
1911
1912 (52, 63268,'Razvoj Inteligentnih Sistemov', 1),
1913 (53, 63266,'Inteligentni Sistemi', 1),
1914 (54, 63267,'Umetno Zaznavanje', 1),
1915
1916 (55, 63271,'Osnove Oblikovanja', 1),
1917 (56, 63270,'Multimedijski sistemi', 1),
1918 (57, 63269,'RaÄunalniÅ¡ka grafika in tehnologija iger', 1);
1919
1920
1921/* Splosni izbirni predmeti: 100-naprej */
1922/* 2 Inserta zato, ker imajo spodnji predmeti definirane se kreditne tocke, razlicne od default 6 */
1923INSERT INTO `tpo`.`PREDMET`
1924(`ID_PREDMET`, `SIFRA_PREDMET`, `IME_PREDMET`, `ST_KREDITNIH_TOCK`, `AKTIVNOST`)
1925VALUES
1926 (100, 63240,'Å port', 3, 1),
1927 (101, 63241,'RaÄunalniÅ¡tvo v praksi I', 3, 1),
1928 (102, 63242,'RaÄunalniÅ¡tvo v praksi II', 3, 1),
1929 (103, 63284,'TehniÄne veÅ¡Äine: Scala', 3, 1),
1930 (104, 63285,'TehniÄne veÅ¡Äine: RaÄunalniÅ¡ki vid', 3, 1),
1931 (105, 63767,'TehniÄne veÅ¡Äine: OpenStack', 3, 1),
1932 (106, 63222,'Angleški jezik nivo A', 3, 1),
1933 (107, 63745,'Angleški jezik nivo B', 3, 1),
1934 (108, 63224,'Angleški jezik nivo C', 3, 1),
1935 (109, 63737,'Procesna avtomatika', 3, 1),
1936 (110, 64000,'Izbrana poglavja RI', 3, 1),
1937 (111, 64001,'Predmeti drugih fakulete', 3, 1);
1938
1939INSERT INTO `tpo`.`del_predmetnika`
1940(`ID_DELPREDMETNIKA`, `NAZIV_DELAPREDMETNIKA`, `SKUPNOSTEVILOKT`, `TIP`, `AKTIVNOST`)
1941VALUES
1942 /* Ostali tipi */
1943 (1, 'Obvezni predmet', 6, 'o', 1),
1944 (2, 'Strokovni izbirni predmet', 6, 'st', 1),
1945 (3, 'Splosno izbirni predmet', 6, 'sp', 1),
1946 (4, 'Splosno izbirni predmet', 3, 'sp', 1),
1947
1948 /* Moduli */
1949 (10, 'Razvoj programske opreme', 18, 'm', 1),
1950 (11, 'Informacijski sistemi', 18, 'm', 1),
1951 (12, 'Obvladovanje informatike', 18, 'm', 1),
1952 (13, 'RaÄunalniÅ¡ka omrežja', 18, 'm', 1),
1953 (14, 'RaÄunalniÅ¡ki sistemi', 18, 'm', 1),
1954 (15, 'Algoritmi in sistemski programi', 18, 'm', 1),
1955 (16, 'Umetna inteligenca', 18, 'm', 1),
1956 (17, 'Medijske tehnologije', 18, 'm', 1);
1957
1958
1959INSERT INTO `tpo`.`predmetnik`
1960(`ID_STUD_LETO`, `ID_LETNIK`, `ID_PREDMET`, `ID_DELPREDMETNIKA`, `ID_PROGRAM`, `AKTIVNOST`) VALUES
1961
1962 /* ---------------- STUD LETO 0 START ---------------- */
1963
1964 /* STUD LETO = 0 (2015/16), 1. Letnik */
1965 (0, 1, 10, 1, 11, 1),
1966 (0, 1, 11, 1, 11, 1),
1967 (0, 1, 12, 1, 11, 1),
1968 (0, 1, 13, 1, 11, 1),
1969 (0, 1, 14, 1, 11, 1),
1970 (0, 1, 15, 1, 11, 1),
1971 (0, 1, 16, 1, 11, 1),
1972 (0, 1, 17, 1, 11, 1),
1973 (0, 1, 18, 1, 11, 1),
1974 (0, 1, 19, 1, 11, 1),
1975
1976 /* STUD LETO = 0 (2015/16), 2. Letnik - Obvezni */
1977 (0, 2, 20, 1, 11, 1),
1978 (0, 2, 21, 1, 11, 1),
1979 (0, 2, 22, 1, 11, 1),
1980 (0, 2, 23, 1, 11, 1),
1981 (0, 2, 24, 1, 11, 1),
1982 (0, 2, 25, 1, 11, 1),
1983 (0, 2, 26, 1, 11, 1),
1984 (0, 2, 27, 1, 11, 1),
1985
1986 /* STUD LETO = 0 (2015/16), 2. Letnik - Strokovni izbirni */
1987 (0, 2, 28, 2, 11, 1),
1988 (0, 2, 29, 2, 11, 1),
1989 (0, 2, 30, 2, 11, 1),
1990
1991 /* STUD LETO = 0 (2015/16), 2. Letnik - Splosni izbirni */
1992 (0, 2, 100, 4, 11, 1),
1993 (0, 2, 101, 4, 11, 1),
1994 (0, 2, 102, 4, 11, 1),
1995 (0, 2, 103, 4, 11, 1),
1996 (0, 2, 104, 4, 11, 1),
1997 (0, 2, 105, 4, 11, 1),
1998 (0, 2, 106, 4, 11, 1),
1999 (0, 2, 107, 4, 11, 1),
2000 (0, 2, 108, 4, 11, 1),
2001 (0, 2, 109, 3, 11, 1),
2002 (0, 2, 110, 3, 11, 1),
2003 (0, 2, 111, 3, 11, 1),
2004
2005 /* STUD LETO = 0 (2015/16), 3. Letnik - Obvezni */
2006 (0, 3, 31, 1, 11, 1),
2007 (0, 3, 32, 1, 11, 1),
2008 (0, 3, 33, 1, 11, 1),
2009
2010 /* STUD LETO = 0 (2015/16), 3. Letnik - Moduli */
2011 -- Razvoj prog opreme
2012 (0, 3, 34, 10, 11, 1),
2013 (0, 3, 35, 10, 11, 1),
2014 (0, 3, 36, 10, 11, 1),
2015
2016 -- Inf. sistemi
2017 (0, 3, 37, 11, 11, 1),
2018 (0, 3, 38, 11, 11, 1),
2019 (0, 3, 39, 11, 11, 1),
2020
2021 -- Upr. inf.
2022 (0, 3, 40, 12, 11, 1),
2023 (0, 3, 41, 12, 11, 1),
2024 (0, 3, 42, 12, 11, 1),
2025
2026 -- Rac omz
2027 (0, 3, 43, 13, 11, 1),
2028 (0, 3, 44, 13, 11, 1),
2029 (0, 3, 45, 13, 11, 1),
2030
2031 -- Rac sis
2032 (0, 3, 46, 14, 11, 1),
2033 (0, 3, 47, 14, 11, 1),
2034 (0, 3, 48, 14, 11, 1),
2035
2036 -- Alg sis prog
2037 (0, 3, 49, 15, 11, 1),
2038 (0, 3, 50, 15, 11, 1),
2039 (0, 3, 51, 15, 11, 1),
2040
2041 -- Umet int
2042 (0, 3, 52, 16, 11, 1),
2043 (0, 3, 53, 16, 11, 1),
2044 (0, 3, 54, 16, 11, 1),
2045
2046 -- Med teh
2047 (0, 3, 55, 17, 11, 1),
2048 (0, 3, 56, 17, 11, 1),
2049 (0, 3, 57, 17, 11, 1),
2050
2051 /* STUD LETO = 0 (2015/16), 3. Letnik - Splosni izbirni */
2052 (0, 3, 100, 4, 11, 1),
2053 (0, 3, 101, 4, 11, 1),
2054 (0, 3, 102, 4, 11, 1),
2055 (0, 3, 103, 4, 11, 1),
2056 (0, 3, 104, 4, 11, 1),
2057 (0, 3, 105, 4, 11, 1),
2058 (0, 3, 106, 4, 11, 1),
2059 (0, 3, 107, 4, 11, 1),
2060 (0, 3, 108, 4, 11, 1),
2061 (0, 3, 109, 3, 11, 1),
2062 (0, 3, 110, 3, 11, 1),
2063 (0, 3, 111, 3, 11, 1),
2064
2065 /* ---------------- STUD LETO 0 END ---------------- */
2066
2067 /* ---------------- STUD LETO 1 START ---------------- */
2068 /* STUD LETO = 1 (2016/17), 1. Letnik */
2069 (1, 1, 10, 1, 11, 1),
2070 (1, 1, 11, 1, 11, 1),
2071 (1, 1, 12, 1, 11, 1),
2072 (1, 1, 13, 1, 11, 1),
2073 (1, 1, 14, 1, 11, 1),
2074 (1, 1, 15, 1, 11, 1),
2075 (1, 1, 16, 1, 11, 1),
2076 (1, 1, 17, 1, 11, 1),
2077 (1, 1, 18, 1, 11, 1),
2078 (1, 1, 19, 1, 11, 1),
2079
2080 /* STUD LETO = 1 (2016/17), 2. Letnik - Obvezni */
2081 (1, 2, 20, 1, 11, 1),
2082 (1, 2, 21, 1, 11, 1),
2083 (1, 2, 22, 1, 11, 1),
2084 (1, 2, 23, 1, 11, 1),
2085 (1, 2, 24, 1, 11, 1),
2086 (1, 2, 25, 1, 11, 1),
2087 (1, 2, 26, 1, 11, 1),
2088 (1, 2, 27, 1, 11, 1),
2089
2090 /* STUD LETO = 1 (2016/17), 2. Letnik - Strokovni izbirni */
2091 (1, 2, 28, 2, 11, 1),
2092 (1, 2, 29, 2, 11, 1),
2093 (1, 2, 30, 2, 11, 1),
2094
2095 /* STUD LETO = 1 (2016/17), 2. Letnik - Splosni izbirni */
2096 (1, 2, 100, 4, 11, 1),
2097 (1, 2, 101, 4, 11, 1),
2098 (1, 2, 102, 4, 11, 1),
2099 (1, 2, 103, 4, 11, 1),
2100 (1, 2, 104, 4, 11, 1),
2101 (1, 2, 105, 4, 11, 1),
2102 (1, 2, 106, 4, 11, 1),
2103 (1, 2, 107, 4, 11, 1),
2104 (1, 2, 108, 4, 11, 1),
2105 (1, 2, 109, 3, 11, 1),
2106 (1, 2, 110, 3, 11, 1),
2107 (1, 2, 111, 3, 11, 1),
2108
2109 /* STUD LETO = 1 (2016/17), 3. Letnik - Obvezni */
2110 (1, 3, 31, 1, 11, 1),
2111 (1, 3, 32, 1, 11, 1),
2112 (1, 3, 33, 1, 11, 1),
2113
2114 /* STUD LETO = 1 (2016/17), 3. Letnik - Moduli */
2115 -- Razvoj prog opreme
2116 (1, 3, 34, 10, 11, 1),
2117 (1, 3, 35, 10, 11, 1),
2118 (1, 3, 36, 10, 11, 1),
2119
2120 -- Inf. sistemi
2121 (1, 3, 37, 11, 11, 1),
2122 (1, 3, 38, 11, 11, 1),
2123 (1, 3, 39, 11, 11, 1),
2124
2125 -- Upr. inf.
2126 (1, 3, 40, 12, 11, 1),
2127 (1, 3, 41, 12, 11, 1),
2128 (1, 3, 42, 12, 11, 1),
2129
2130 -- Rac omz
2131 (1, 3, 43, 13, 11, 1),
2132 (1, 3, 44, 13, 11, 1),
2133 (1, 3, 45, 13, 11, 1),
2134
2135 -- Rac sis
2136 (1, 3, 46, 14, 11, 1),
2137 (1, 3, 47, 14, 11, 1),
2138 (1, 3, 48, 14, 11, 1),
2139
2140 -- Alg sis prog
2141 (1, 3, 49, 15, 11, 1),
2142 (1, 3, 50, 15, 11, 1),
2143 (1, 3, 51, 15, 11, 1),
2144
2145 -- Umet int
2146 (1, 3, 52, 16, 11, 1),
2147 (1, 3, 53, 16, 11, 1),
2148 (1, 3, 54, 16, 11, 1),
2149
2150 -- Med teh
2151 (1, 3, 55, 17, 11, 1),
2152 (1, 3, 56, 17, 11, 1),
2153 (1, 3, 57, 17, 11, 1),
2154
2155 /* STUD LETO = 1 (2016/17), 3. Letnik - Splosni izbirni */
2156 (1, 3, 100, 4, 11, 1),
2157 (1, 3, 101, 4, 11, 1),
2158 (1, 3, 102, 4, 11, 1),
2159 (1, 3, 103, 4, 11, 1),
2160 (1, 3, 104, 4, 11, 1),
2161 (1, 3, 105, 4, 11, 1),
2162 (1, 3, 106, 4, 11, 1),
2163 (1, 3, 107, 4, 11, 1),
2164 (1, 3, 108, 4, 11, 1),
2165 (1, 3, 109, 3, 11, 1),
2166 (1, 3, 110, 3, 11, 1),
2167 (1, 3, 111, 3, 11, 1),
2168
2169 /* ---------------- STUD LETO 1 END ---------------- */
2170
2171 /* ---------------- STUD LETO 2 START ---------------- */
2172 /* STUD LETO = 2 (2017/18), 1. Letnik */
2173 (2, 1, 10, 1, 11, 1),
2174 (2, 1, 11, 1, 11, 1),
2175 (2, 1, 12, 1, 11, 1),
2176 (2, 1, 13, 1, 11, 1),
2177 (2, 1, 14, 1, 11, 1),
2178 (2, 1, 15, 1, 11, 1),
2179 (2, 1, 16, 1, 11, 1),
2180 (2, 1, 17, 1, 11, 1),
2181 (2, 1, 18, 1, 11, 1),
2182 (2, 1, 19, 1, 11, 1),
2183
2184 /* STUD LETO = 2 (2017/18), 2. Letnik - Obvezni */
2185 (2, 2, 20, 1, 11, 1),
2186 (2, 2, 21, 1, 11, 1),
2187 (2, 2, 22, 1, 11, 1),
2188 (2, 2, 23, 1, 11, 1),
2189 (2, 2, 24, 1, 11, 1),
2190 (2, 2, 25, 1, 11, 1),
2191 (2, 2, 26, 1, 11, 1),
2192 (2, 2, 27, 1, 11, 1),
2193
2194 /* STUD LETO = 2 (2017/18), 2. Letnik - Strokovni izbirni */
2195 (2, 2, 28, 2, 11, 1),
2196 (2, 2, 29, 2, 11, 1),
2197 (2, 2, 30, 2, 11, 1),
2198
2199 /* STUD LETO = 2 (2017/18), 2. Letnik - Splosni izbirni */
2200 (2, 2, 100, 4, 11, 1),
2201 (2, 2, 101, 4, 11, 1),
2202 (2, 2, 102, 4, 11, 1),
2203 (2, 2, 103, 4, 11, 1),
2204 (2, 2, 104, 4, 11, 1),
2205 (2, 2, 105, 4, 11, 1),
2206 (2, 2, 106, 4, 11, 1),
2207 (2, 2, 107, 4, 11, 1),
2208 (2, 2, 108, 4, 11, 1),
2209 (2, 2, 109, 3, 11, 1),
2210 (2, 2, 110, 3, 11, 1),
2211 (2, 2, 111, 3, 11, 1),
2212
2213 /* STUD LETO = 2 (2017/18), 3. Letnik - Obvezni */
2214 (2, 3, 31, 1, 11, 1),
2215 (2, 3, 32, 1, 11, 1),
2216 (2, 3, 33, 1, 11, 1),
2217
2218 /* STUD LETO = 2 (2017/18), 3. Letnik - Moduli */
2219 -- Razvoj prog opreme
2220 (2, 3, 34, 10, 11, 1),
2221 (2, 3, 35, 10, 11, 1),
2222 (2, 3, 36, 10, 11, 1),
2223
2224 -- Inf. sistemi
2225 (2, 3, 37, 11, 11, 1),
2226 (2, 3, 38, 11, 11, 1),
2227 (2, 3, 39, 11, 11, 1),
2228
2229 -- Upr. inf.
2230 (2, 3, 40, 12, 11, 1),
2231 (2, 3, 41, 12, 11, 1),
2232 (2, 3, 42, 12, 11, 1),
2233
2234 -- Rac omz
2235 (2, 3, 43, 13, 11, 1),
2236 (2, 3, 44, 13, 11, 1),
2237 (2, 3, 45, 13, 11, 1),
2238
2239 -- Rac sis
2240 (2, 3, 46, 14, 11, 1),
2241 (2, 3, 47, 14, 11, 1),
2242 (2, 3, 48, 14, 11, 1),
2243
2244 -- Alg sis prog
2245 (2, 3, 49, 15, 11, 1),
2246 (2, 3, 50, 15, 11, 1),
2247 (2, 3, 51, 15, 11, 1),
2248
2249 -- Umet int
2250 (2, 3, 52, 16, 11, 1),
2251 (2, 3, 53, 16, 11, 1),
2252 (2, 3, 54, 16, 11, 1),
2253
2254 -- Med teh
2255 (2, 3, 55, 17, 11, 1),
2256 (2, 3, 56, 17, 11, 1),
2257 (2, 3, 57, 17, 11, 1),
2258
2259 /* STUD LETO = 2 (2017/18), 3. Letnik - Splosni izbirni */
2260 (2, 3, 100, 4, 11, 1),
2261 (2, 3, 101, 4, 11, 1),
2262 (2, 3, 102, 4, 11, 1),
2263 (2, 3, 103, 4, 11, 1),
2264 (2, 3, 104, 4, 11, 1),
2265 (2, 3, 105, 4, 11, 1),
2266 (2, 3, 106, 4, 11, 1),
2267 (2, 3, 107, 4, 11, 1),
2268 (2, 3, 108, 4, 11, 1),
2269 (2, 3, 109, 3, 11, 1),
2270 (2, 3, 110, 3, 11, 1),
2271 (2, 3, 111, 3, 11, 1),
2272
2273 /* ---------------- STUD LETO 2 END ---------------- */
2274
2275 /* ---------------- STUD LETO 3 START ---------------- */
2276 /* STUD LETO = 3 (2018/19) 1. Letnik */
2277 (3, 1, 10, 1, 11, 1),
2278 (3, 1, 11, 1, 11, 1),
2279 (3, 1, 12, 1, 11, 1),
2280 (3, 1, 13, 1, 11, 1),
2281 (3, 1, 14, 1, 11, 1),
2282 (3, 1, 15, 1, 11, 1),
2283 (3, 1, 16, 1, 11, 1),
2284 (3, 1, 17, 1, 11, 1),
2285 (3, 1, 18, 1, 11, 1),
2286 (3, 1, 19, 1, 11, 1),
2287
2288 /* STUD LETO = 3 (2018/19), 2. Letnik - Obvezni */
2289 (3, 2, 20, 1, 11, 1),
2290 (3, 2, 21, 1, 11, 1),
2291 (3, 2, 22, 1, 11, 1),
2292 (3, 2, 23, 1, 11, 1),
2293 (3, 2, 24, 1, 11, 1),
2294 (3, 2, 25, 1, 11, 1),
2295 (3, 2, 26, 1, 11, 1),
2296 (3, 2, 27, 1, 11, 1),
2297
2298 /* STUD LETO = 3 (2018/19), 2. Letnik - Strokovni izbirni */
2299 (3, 2, 28, 2, 11, 1),
2300 (3, 2, 29, 2, 11, 1),
2301 (3, 2, 30, 2, 11, 1),
2302
2303 /* STUD LETO = 3 (2018/19), 2. Letnik - Splosni izbirni */
2304 (3, 2, 100, 4, 11, 1),
2305 (3, 2, 101, 4, 11, 1),
2306 (3, 2, 102, 4, 11, 1),
2307 (3, 2, 103, 4, 11, 1),
2308 (3, 2, 104, 4, 11, 1),
2309 (3, 2, 105, 4, 11, 1),
2310 (3, 2, 106, 4, 11, 1),
2311 (3, 2, 107, 4, 11, 1),
2312 (3, 2, 108, 4, 11, 1),
2313 (3, 2, 109, 3, 11, 1),
2314 (3, 2, 110, 3, 11, 1),
2315 (3, 2, 111, 3, 11, 1),
2316
2317 /* STUD LETO = 3 (2018/19), 3. Letnik - Obvezni */
2318 (3, 3, 31, 1, 11, 1),
2319 (3, 3, 32, 1, 11, 1),
2320 (3, 3, 33, 1, 11, 1),
2321
2322 /* STUD LETO = 3 (2018/19), 3. Letnik - Moduli */
2323 -- Razvoj prog opreme
2324 (3, 3, 34, 10, 11, 1),
2325 (3, 3, 35, 10, 11, 1),
2326 (3, 3, 36, 10, 11, 1),
2327
2328 -- Inf. sistemi
2329 (3, 3, 37, 11, 11, 1),
2330 (3, 3, 38, 11, 11, 1),
2331 (3, 3, 39, 11, 11, 1),
2332
2333 -- Upr. inf.
2334 (3, 3, 40, 12, 11, 1),
2335 (3, 3, 41, 12, 11, 1),
2336 (3, 3, 42, 12, 11, 1),
2337
2338 -- Rac omz
2339 (3, 3, 43, 13, 11, 1),
2340 (3, 3, 44, 13, 11, 1),
2341 (3, 3, 45, 13, 11, 1),
2342
2343 -- Rac sis
2344 (3, 3, 46, 14, 11, 1),
2345 (3, 3, 47, 14, 11, 1),
2346 (3, 3, 48, 14, 11, 1),
2347
2348 -- Alg sis prog
2349 (3, 3, 49, 15, 11, 1),
2350 (3, 3, 50, 15, 11, 1),
2351 (3, 3, 51, 15, 11, 1),
2352
2353 -- Umet int
2354 (3, 3, 52, 16, 11, 1),
2355 (3, 3, 53, 16, 11, 1),
2356 (3, 3, 54, 16, 11, 1),
2357
2358 -- Med teh
2359 (3, 3, 55, 17, 11, 1),
2360 (3, 3, 56, 17, 11, 1),
2361 (3, 3, 57, 17, 11, 1),
2362
2363 /* STUD LETO = 3 (2018/19), 3. Letnik - Splosni izbirni */
2364 (3, 3, 100, 4, 11, 1),
2365 (3, 3, 101, 4, 11, 1),
2366 (3, 3, 102, 4, 11, 1),
2367 (3, 3, 103, 4, 11, 1),
2368 (3, 3, 104, 4, 11, 1),
2369 (3, 3, 105, 4, 11, 1),
2370 (3, 3, 106, 4, 11, 1),
2371 (3, 3, 107, 4, 11, 1),
2372 (3, 3, 108, 4, 11, 1),
2373 (3, 3, 109, 3, 11, 1),
2374 (3, 3, 110, 3, 11, 1),
2375 (3, 3, 111, 3, 11, 1);
2376
2377 /* ---------------- STUD LETO 3 END ---------------- */
2378
2379/*
2380INSERT INTO `tpo`.`IZVEDBA_PREDMETA`
2381(`ID_IZVEDBA`, `ID_STUD_LETO`, `ID_OSEBA1`, `ID_OSEBA2`, `ID_OSEBA3`, `ID_PREDMET`)
2382VALUES
2383 (1, 1, 2,13, 14, 1),
2384 (2, 1, 2,NULL,NULL, 6),
2385 (3, 1,13,14, NULL, 4),
2386 (5, 2, 2,13, 14, 1),
2387 (6, 2, 2,NULL,NULL, 6),
2388 (7, 2,13,14, NULL, 4),
2389 (9, 3, 2,13, 14, 1),
2390 (10,3, 2,NULL,NULL, 6),
2391 (11,3,13,14, NULL, 4),
2392 (244,4, 2,13, 14, 1),
2393 (245,4, 2,NULL,NULL, 6),
2394 (246,4,13,14, NULL, 4),
2395 (247,5, 2,13, 14, 1),
2396 (248,5, 2,NULL,NULL, 6),
2397 (249,5,13,14, NULL, 4),
2398 (250,6, 2,13, 14, 1),
2399 (251,6, 2,NULL,NULL, 6),
2400 (252,6,13,14, NULL, 4),
2401
2402 #ID_STUD_LETO = 1
2403 (13,1,29,NULL,NULL,10),
2404 (15,1,32,NULL,NULL,11),
2405 (16,1,34,NULL,NULL,13),
2406 (17,1,35,NULL,NULL,15),
2407 (18,1,36,NULL,NULL,16),
2408 (19,1,37,NULL,NULL,17),
2409 (20,1,38,NULL,NULL,14),
2410 (21,1,2, 30, NULL, 9),
2411 (22,1,14,NULL,NULL,12),
2412 (23,1,36,NULL,NULL,18),
2413 (24,1,37,NULL,NULL,19),
2414
2415 (27,1,14,NULL,NULL,12),
2416 (28,1,32,NULL,NULL,20),
2417 (29,1,34,NULL,NULL,21),
2418 (30,1,35,NULL,NULL,22),
2419 (31,1,36,NULL,NULL,23),
2420 (32,1,37,NULL,NULL,24),
2421 (33,1,38,NULL,NULL,25),
2422 (34,1,29,NULL,NULL,26),
2423 (35,1,30,NULL,NULL,27),
2424 (36,1,31,NULL,NULL,29),
2425 (37,1,32,NULL,NULL,7),
2426 (38,1,33,NULL,NULL,8),
2427 (39,1,29,NULL,NULL,2),
2428 (40,1,30,NULL,NULL,3),
2429 (41,1,31,NULL,NULL,5),
2430 (42,1,32,NULL,NULL,30),
2431 (43,1,33,NULL,NULL,31),
2432 (44,1,32,NULL,NULL,32),
2433 (45,1,31,NULL,NULL,33),
2434 (46,1,30,NULL,NULL,54),
2435 (47,1,29,NULL,NULL,53),
2436 (48,1,38,NULL,NULL,52),
2437 (49,1,37,NULL,NULL,51),
2438 (50,1,36,NULL,NULL,50),
2439 (51,1,35,NULL,NULL,55),
2440 (52,1,34,NULL,NULL,56),
2441 (238,1,34,NULL,NULL,57),
2442
2443
2444 (53,2,29,NULL,NULL,10),
2445 (54,2,32,NULL,NULL,11),
2446 (55,2,34,NULL,NULL,13),
2447 (56,2,35,NULL,NULL,15),
2448 (57,2,36,NULL,NULL,16),
2449 (58,2,37,NULL,NULL,17),
2450 (59,2,38,NULL,NULL,14),
2451 (60,2,2, 30, NULL, 9),
2452 (61,2,14,NULL,NULL,12),
2453 (62,2,36,NULL,NULL,18),
2454 (63,2,37,NULL,NULL,19),
2455
2456 (64,2,14,NULL,NULL,12),
2457 (65,2,32,NULL,NULL,20),
2458 (66,2,34,NULL,NULL,21),
2459 (67,2,35,NULL,NULL,22),
2460 (68,2,36,NULL,NULL,23),
2461 (69,2,37,NULL,NULL,24),
2462 (70,2,38,NULL,NULL,25),
2463 (71,2,29,NULL,NULL,26),
2464 (72,2,30,NULL,NULL,27),
2465 (73,2,31,NULL,NULL,29),
2466 (74,2,32,NULL,NULL,7),
2467 (75,2,33,NULL,NULL,8),
2468 (76,2,29,NULL,NULL,2),
2469 (77,2,30,NULL,NULL,3),
2470 (78,2,31,NULL,NULL,5),
2471 (79,2,32,NULL,NULL,30),
2472 (80,2,33,NULL,NULL,31),
2473 (81,2,32,NULL,NULL,32),
2474 (82,2,31,NULL,NULL,33),
2475 (83,2,30,NULL,NULL,54),
2476 (84,2,29,NULL,NULL,53),
2477 (85,2,38,NULL,NULL,52),
2478 (86,2,37,NULL,NULL,51),
2479 (87,2,36,NULL,NULL,50),
2480 (88,2,35,NULL,NULL,55),
2481 (89,2,34,NULL,NULL,56),
2482 (239,2,34,NULL,NULL,57),
2483
2484
2485 (90,3,29,NULL,NULL,10),
2486 (91,3,32,NULL,NULL,11),
2487 (92,3,34,NULL,NULL,13),
2488 (93,3,35,NULL,NULL,15),
2489 (94,3,36,NULL,NULL,16),
2490 (95,3,37,NULL,NULL,17),
2491 (96,3,38,NULL,NULL,14),
2492 (97,3,2, 30, NULL, 9),
2493 (98,3,14,NULL,NULL,12),
2494 (99,3,36,NULL,NULL,18),
2495 (100,3,37,NULL,NULL,19),
2496
2497 (101,3,14,NULL,NULL,12),
2498 (102,3,32,NULL,NULL,20),
2499 (103,3,34,NULL,NULL,21),
2500 (104,3,35,NULL,NULL,22),
2501 (105,3,36,NULL,NULL,23),
2502 (106,3,37,NULL,NULL,24),
2503 (107,3,38,NULL,NULL,25),
2504 (108,3,29,NULL,NULL,26),
2505 (109,3,30,NULL,NULL,27),
2506 (110,3,31,NULL,NULL,29),
2507 (111,3,32,NULL,NULL,7),
2508 (112,3,33,NULL,NULL,8),
2509 (113,3,29,NULL,NULL,2),
2510 (114,3,30,NULL,NULL,3),
2511 (115,3,31,NULL,NULL,5),
2512 (116,3,32,NULL,NULL,30),
2513 (117,3,33,NULL,NULL,31),
2514 (118,3,32,NULL,NULL,32),
2515 (119,3,31,NULL,NULL,33),
2516 (120,3,30,NULL,NULL,54),
2517 (121,3,29,NULL,NULL,53),
2518 (122,3,38,NULL,NULL,52),
2519 (123,3,37,NULL,NULL,51),
2520 (124,3,36,NULL,NULL,50),
2521 (125,3,35,NULL,NULL,55),
2522 (126,3,34,NULL,NULL,56),
2523 (240,3,34,NULL,NULL,57),
2524
2525
2526 (127,4,29,NULL,NULL,10),
2527 (128,4,32,NULL,NULL,11),
2528 (129,4,34,NULL,NULL,13),
2529 (130,4,35,NULL,NULL,15),
2530 (131,4,36,NULL,NULL,16),
2531 (132,4,37,NULL,NULL,17),
2532 (133,4,38,NULL,NULL,14),
2533 (134,4,2, 30, NULL, 9),
2534 (135,4,14,NULL,NULL,12),
2535 (136,4,36,NULL,NULL,18),
2536 (137,4,37,NULL,NULL,19),
2537
2538 (138,4,14,NULL,NULL,12),
2539 (139,4,32,NULL,NULL,20),
2540 (140,4,34,NULL,NULL,21),
2541 (141,4,35,NULL,NULL,22),
2542 (142,4,36,NULL,NULL,23),
2543 (143,4,37,NULL,NULL,24),
2544 (144,4,38,NULL,NULL,25),
2545 (145,4,29,NULL,NULL,26),
2546 (146,4,30,NULL,NULL,27),
2547 (147,4,31,NULL,NULL,29),
2548 (148,4,32,NULL,NULL,7),
2549 (149,4,33,NULL,NULL,8),
2550 (150,4,29,NULL,NULL,2),
2551 (151,4,30,NULL,NULL,3),
2552 (152,4,31,NULL,NULL,5),
2553 (153,4,32,NULL,NULL,30),
2554 (154,4,33,NULL,NULL,31),
2555 (155,4,32,NULL,NULL,32),
2556 (156,4,31,NULL,NULL,33),
2557 (157,4,30,NULL,NULL,54),
2558 (158,4,29,NULL,NULL,53),
2559 (159,4,38,NULL,NULL,52),
2560 (160,4,37,NULL,NULL,51),
2561 (161,4,36,NULL,NULL,50),
2562 (162,4,35,NULL,NULL,55),
2563 (163,4,34,NULL,NULL,56),
2564 (241,4,34,NULL,NULL,57),
2565
2566
2567 (164,5,29,NULL,NULL,10),
2568 (165,5,32,NULL,NULL,11),
2569 (166,5,34,NULL,NULL,13),
2570 (167,5,35,NULL,NULL,15),
2571 (168,5,36,NULL,NULL,16),
2572 (169,5,37,NULL,NULL,17),
2573 (170,5,38,NULL,NULL,14),
2574 (171,5,2, 30, NULL, 9),
2575 (172,5,14,NULL,NULL,12),
2576 (173,5,36,NULL,NULL,18),
2577 (174,5,37,NULL,NULL,19),
2578
2579 (175,5,14,NULL,NULL,12),
2580 (176,5,32,NULL,NULL,20),
2581 (177,5,34,NULL,NULL,21),
2582 (178,5,35,NULL,NULL,22),
2583 (179,5,36,NULL,NULL,23),
2584 (180,5,37,NULL,NULL,24),
2585 (181,5,38,NULL,NULL,25),
2586 (182,5,29,NULL,NULL,26),
2587 (183,5,30,NULL,NULL,27),
2588 (184,5,31,NULL,NULL,29),
2589 (185,5,32,NULL,NULL,7),
2590 (186,5,33,NULL,NULL,8),
2591 (187,5,29,NULL,NULL,2),
2592 (188,5,30,NULL,NULL,3),
2593 (189,5,31,NULL,NULL,5),
2594 (190,5,32,NULL,NULL,30),
2595 (191,5,33,NULL,NULL,31),
2596 (192,5,32,NULL,NULL,32),
2597 (193,5,31,NULL,NULL,33),
2598 (194,5,30,NULL,NULL,54),
2599 (195,5,29,NULL,NULL,53),
2600 (196,5,38,NULL,NULL,52),
2601 (197,5,37,NULL,NULL,51),
2602 (198,5,36,NULL,NULL,50),
2603 (199,5,35,NULL,NULL,55),
2604 (200,5,34,NULL,NULL,56),
2605 (242,5,34,NULL,NULL,57),
2606
2607
2608 (201,6,29,NULL,NULL,10),
2609 (202,6,32,NULL,NULL,11),
2610 (203,6,34,NULL,NULL,13),
2611 (204,6,35,NULL,NULL,15),
2612 (205,6,36,NULL,NULL,16),
2613 (206,6,37,NULL,NULL,17),
2614 (207,6,38,NULL,NULL,14),
2615 (208,6,2, 30, NULL, 9),
2616 (209,6,14,NULL,NULL,12),
2617 (210,6,36,NULL,NULL,18),
2618 (211,6,37,NULL,NULL,19),
2619
2620 (212,6,14,NULL,NULL,12),
2621 (213,6,32,NULL,NULL,20),
2622 (214,6,34,NULL,NULL,21),
2623 (215,6,35,NULL,NULL,22),
2624 (216,6,36,NULL,NULL,23),
2625 (217,6,37,NULL,NULL,24),
2626 (218,6,38,NULL,NULL,25),
2627 (219,6,29,NULL,NULL,26),
2628 (220,6,30,NULL,NULL,27),
2629 (221,6,31,NULL,NULL,29),
2630 (222,6,32,NULL,NULL,7),
2631 (223,6,33,NULL,NULL,8),
2632 (224,6,29,NULL,NULL,2),
2633 (225,6,30,NULL,NULL,3),
2634 (226,6,31,NULL,NULL,5),
2635 (227,6,32,NULL,NULL,30),
2636 (228,6,33,NULL,NULL,31),
2637 (229,6,32,NULL,NULL,32),
2638 (230,6,31,NULL,NULL,33),
2639 (231,6,30,NULL,NULL,54),
2640 (232,6,29,NULL,NULL,53),
2641 (233,6,38,NULL,NULL,52),
2642 (234,6,37,NULL,NULL,51),
2643 (235,6,36,NULL,NULL,50),
2644 (236,6,35,NULL,NULL,55),
2645 (237,6,34,NULL,NULL,56),
2646 (243,6,34,NULL,NULL,57);
2647*/
2648
2649INSERT INTO `tpo`.`vpis`(`ID_VPIS`,`ID_PROGRAM`,`ID_NACIN`,`ID_STUD_LETO`,`ID_VRSTAVPISA`,
2650 `ID_OBLIKA`,`ID_LETNIK`,`POTRJENOST_VPISA`,`VPISNA_STEVILKA`)VALUES
2651
2652 (1,11,1, 2,1,1,1,1,63150000),
2653 (2,11,1, 2,1,1,1,1,63150001),
2654 (3,11,1, 2,1,1,1,1,63150002),
2655 (4,11,1, 2,1,1,1,1,63150003),
2656 #(5,11,1,2,1,1,1,1,63150004),
2657
2658 (6,11,1, 2,1,1,2,1,63150005),
2659 (7,11,1, 2,1,1,2,1,63150006),
2660 (8,11,2, 2,1,1,1,1,63150007),
2661
2662
2663 (9,11,1, 2,1,1,3,1,63150008),
2664 (10,11,1,2,1,1,2,1,63150009),
2665 (11,11,1,2,1,1,3,1,63150010),
2666 (12,11,1,2,1,1,1,1,63150011),
2667 (13,11,1,2,1,1,2,1,63150012),
2668 (14,11,1,2,1,1,2,1,63150013),
2669
2670 (15,11,1,2,1,1,2,1,63150014),
2671 (16,11,1,2,1,1,2,1,63150015),
2672 (17,11,1,2,1,1,2,1,63150016),
2673 (18,11,1,2,1,1,2,1,63150017),
2674 (19,11,1,2,1,1,2,1,63150018),
2675 (20,11,1,2,1,1,2,1,63150019),
2676 (21,11,1,2,1,1,2,1,63150020),
2677 (22,11,1,2,1,1,2,1,63150022),
2678
2679 (51,11,1,1,1,1,1,1,63150101),
2680
2681 (52,11,1,1,1,1,1,1,63150102),
2682 (53,11,1,2,1,1,2,1,63150102),
2683
2684 (54,11,1,1,1,1,1,1,63150103),
2685
2686 (55,11,1,2,1,1,2,1,63150103);
2687
2688
2689INSERT INTO `tpo`.`student`
2690(`VPISNA_STEVILKA`,`ID_OSEBA`,`ID_KANDIDAT`,`ID_VPIS`,`EMSO`,`ID_PROGRAM`,
2691 `VSOTA_OPRAVLJENIH_KREDITNIH_TOCK`,`POVPRECNA_OCENA_OPRAVLJENIH_IZPITOV`)VALUES
2692
2693 (63150000,1,1,1,2505996500510,11,60,10),
2694 (63150001,4,2,2,1234567891211,11,60,6),
2695 (63150002,7,2,2,1234567891212,11,36,6),
2696 (63150003,8,2,2,1234567891213,11,60,10),
2697 (63150004,9,2,2,1234567891214,11,12,7),
2698 (63150005,10,2,2,1234567891215,11,120,9.33),
2699 (63150006,11,2,2,1234567891216,11,100,8.20),
2700 (63150007,12,2,2,1234567891217,11,66,7.3),
2701 (63150008,15,2,2,1234567891218,11,180,6),
2702 (63150009,16,2,2,1234567891219,11,54,7.7),
2703 (63150010,17,2,2,1234567891220,11,114,8),
2704 (63150011,18,2,2,1234567891221,11,42,7),
2705 (63150012,19,2,2,1234567891222,11,24,6),
2706 (63150013,20,2,2,1234567891223,12,120,6),
2707 (63150014,21,2,2,1234567891224,11,120,6),
2708 (63150015,22,2,2,1234567891225,11,120,6),
2709 (63150021,23,2,2,1234567891226,11,120,6),
2710 (63150016,24,2,2,1234567891227,11,120,6),
2711 (63150017,25,2,2,1234567891228,11,120,6),
2712 (63150018,26,2,2,1234567891229,11,120,6),
2713 (63150019,27,2,2,12345678912330,11,120,6),
2714 (63150020,28,2,2,12345678912331,11,120,6),
2715 (63150022,39,2,22,12345678912332,11,54,6),
2716 (63150101, 41, 4, 51, 1706996500334, 11, 60, 8),
2717 (63150102, 42, 5, 53, 1706996500334, 11, 120, 8),
2718 (63150103, 43, 6, 55, 1706996500334, 11, 120, 9);
2719
2720INSERT INTO `tpo`.`naslov`(`ID_NASLOV`,`ID_POSTA`,`ID_OBCINA`,`ID_DRZAVA`,
2721 `ID_OSEBA`,`JE_ZAVROCANJE`,`JE_STALNI`,`ULICA`) VALUES
2722 (1,1,1,705,1,1,0,'naslovzavrocanje 13'),
2723 (2,1,1,705,1,0,1,'stalninaslov 12'),
2724 (3,2,1,705,4,1,0,'zaVrocanje Ulica 12'),
2725 (4,2,1,705,4,0,1,'stalna Ulica 12'),
2726
2727 (11, NULL, NULL, 40, 41, 0, 1, 'Test 50, 1000 Viena'),
2728 (12, 187, 61, 705, 41, 1, 0, 'Dunajska 10'),
2729
2730 (13, NULL, NULL, 40, 42, 0, 1, 'Test 50, 1000 Viena'),
2731 (14, 187, 61, 705, 42, 1, 0, 'Dunajska 10'),
2732
2733 (15, NULL, NULL, 40, 43, 0, 1, 'Test 50, 1000 Viena'),
2734 (16, 187, 61, 705, 43, 1, 0, 'Dunajska 10');
2735
2736INSERT INTO `tpo`.`zeton`
2737(`ID_OSEBA`, `ID_LETNIK`, `ID_STUD_LETO`, `ID_OBLIKA`, `ID_NACIN`, `ID_VRSTAVPISA`, `ID_PROGRAM`,`IZKORISCEN`, `AKTIVNOST`)
2738VALUES
2739 (1,1,1,1,1,1,3,1,1),
2740 (4,1,1,1,1,1,3,1,1),
2741 (7,1,1,1,1,2,3,1,0),
2742 (8,1,1,1,1,1,3,1,0),
2743 (10,2,1,1,1,1,3,1,0),
2744 (11,2,1,1,1,1,3,1,0),
2745
2746
2747 (15,3,1,1,1,1,3,1, 1),
2748 (16,2,1,1,1,2,3,1, 1),
2749 (17,3,1,1,1,2,3,1, 1),
2750 (18,1,1,1,1,1,3,1, 1),
2751 (19,2,1,1,1,1,3,1, 1),
2752 (20,2,1,1,1,1,3,1, 1),
2753 (21,2,1,1,1,1,3,1, 1),
2754 (22,2,1,1,1,1,3,1, 1),
2755 (23,2,1,1,1,1,3,1, 1),
2756 (24,2,1,1,1,1,3,1, 1),
2757 (25,2,1,1,1,1,3,1, 1),
2758 (26,2,1,1,1,1,3,1, 1),
2759 (27,2,1,1,1,1,3,1, 1),
2760 (28,2,1,1,1,1,3,1, 1),
2761
2762 (41,1,1,1,1,1,11,1,1),
2763 (41,2,2,1,1,1,11,0,1),
2764
2765 (42,1,1,1,1,1,11,1,1),
2766 (42,2,2,1,1,1,11,1,1),
2767 (42,3,2,1,1,1,11,0,1),
2768
2769 (43,1,1,1,1,1,11,1,1),
2770 (43,2,2,1,1,1,11,1,1);
2771
2772INSERT INTO `tpo`.`zeton` (`ID_OSEBA`, `ID_LETNIK`, `ID_STUD_LETO`, `ID_OBLIKA`, `ID_NACIN`, `ID_VRSTAVPISA`, `ID_PROGRAM`,`IZKORISCEN`, `AKTIVNOST`, `PROSTA_IZBIRNOST`) VALUES
2773 (43,3,2,1,1,1,11,0,1,1);
2774
2775INSERT INTO tpo.rok
2776(ID_ROK, ID_IZVEDBA, DATUM_ROKA, CAS_ROKA, AKTIVNOST, ID_OSEBA_IZPRASEVALEC1, ID_OSEBA_IZPRASEVALEC2, ID_OSEBA_IZPRASEVALEC3)
2777VALUES
2778 /* TPO (Mah, Fur, Poz), Studijsko leto 2017/18 */
2779 (1,5,"2018-01-13", "10:00:00", 1, 2, 13, NULL),
2780 (2,5,"2018-01-25", "11:00:00", 1, 2, 14, NULL),
2781 (3,5,"2018-09-25", "12:00:00", 1, 2, 13, 14),
2782
2783 /* P1 (Mah), Studijsko leto 2017/18 */
2784 (4,6,"2018-01-12", "12:00:00", 1, NULL, NULL, NULL),
2785 (5,6,"2018-01-19", "13:00:00", 1, NULL, NULL, NULL),
2786 (6,6,"2018-09-21", "14:00:00", 1, NULL, NULL, NULL),
2787
2788 /* TPO (Mah, Fur, Poz), Studijsko leto 2016/17 */
2789 (7,1,"2017-06-20", "14:00:00", 1, NULL, NULL, NULL),
2790 (8,1,"2017-06-25", "15:00:00", 1, NULL, NULL, NULL),
2791 (9,1,"2017-09-05", "16:00:00", 1, NULL, NULL, NULL),
2792
2793 /* P1 (Fur, Poz), Studijsko leto 2016/17 */
2794 (10,2,"2017-01-20", "16:00:00", 1, NULL, NULL, NULL),
2795 (11,2,"2017-01-25", "17:00:00", 1, NULL, NULL, NULL),
2796 (12,2,"2017-09-05", "18:00:00", 1, NULL, NULL, NULL),
2797
2798 /*id_predmet=9, stud_leto=2017/18*/
2799 (13,21,"2019-01-20", "16:00:00", 1, NULL, NULL, NULL),
2800 (14,21,"2019-01-25", "17:00:00", 1, NULL, NULL, NULL),
2801 (15,21,"2018-09-05", "18:00:00", 1, NULL, NULL, NULL),
2802
2803 /*id_predmet=12, stud_leto=2017/18*/
2804 (16,22,"2019-01-21", "16:00:00", 1, NULL, NULL, NULL),
2805 (17,22,"2019-01-26", "17:00:00", 1, NULL, NULL, NULL),
2806 (18,22,"2018-09-06", "18:00:00", 1, NULL, NULL, NULL),
2807
2808 /*id_predmet=18, stud_leto=2017/18*/
2809 (19,23,"2019-01-21", "16:00:00", 1, NULL, NULL, NULL),
2810 (20,23,"2019-01-26", "17:00:00", 1, NULL, NULL, NULL),
2811 (21,23,"2018-09-06", "18:00:00", 1, NULL, NULL, NULL),
2812
2813 /*id_predmet=19, stud_leto=2017/18*/
2814 (22,24,"2019-01-21", "16:00:00", 1, NULL, NULL, NULL),
2815 (23,24,"2019-01-26", "17:00:00", 1, NULL, NULL, NULL),
2816 (24,24,"2018-09-06", "18:00:00", 1, NULL, NULL, NULL),
2817
2818 /*
2819 (25,25,"2018-06-20", "14:00:00", 1, NULL, NULL, NULL),
2820 (26,25,"2018-06-25", "15:00:00", 1, NULL, NULL, NULL),
2821 (27,25,"2018-09-05", "16:00:00", 1, NULL, NULL, NULL),
2822
2823 (28,26,"2019-06-20", "14:00:00", 1, NULL, NULL, NULL),
2824 (29,26,"2019-06-25", "15:00:00", 1, NULL, NULL, NULL),
2825 (30,26,"2019-09-05", "16:00:00", 1, NULL, NULL, NULL),
2826 (31,26,"2019-09-07", "16:00:00", 1, NULL, NULL, NULL),
2827 */
2828 (32,27,"2017-06-20", "14:00:00", 1, NULL, NULL, NULL),
2829 (33,27,"2017-06-25", "15:00:00", 1, NULL, NULL, NULL),
2830 (34,27,"2017-09-05", "16:00:00", 1, NULL, NULL, NULL),
2831
2832 (35,22,"2018-09-20","10:00:00",1, NULL, NULL, NULL);
2833
2834
2835
2836INSERT INTO `predmeti_studenta`
2837( `VPISNA_STEVILKA`, `ID_PREDMET`, `ID_STUD_LETO`)
2838VALUES
2839 (63150000, 6, 2),
2840 (63150000, 9, 2),
2841 (63150000, 10, 2),
2842 (63150000, 11, 2),
2843 (63150000, 12, 2),
2844 (63150000, 13, 2),
2845 (63150000, 14, 2),
2846 (63150000, 15, 2),
2847 (63150000, 16, 2),
2848 (63150000, 17, 2),
2849 (63150001, 6, 2),
2850 (63150001, 9, 2),
2851 (63150001, 10, 2),
2852 (63150001, 11, 2),
2853 (63150001, 12, 2),
2854 (63150001, 13, 2),
2855 (63150001, 14, 2),
2856 (63150001, 15, 2),
2857 (63150001, 16, 2),
2858 (63150001, 17, 2),
2859 (63150002, 6, 2),
2860 (63150002, 9, 2),
2861 (63150002, 10, 2),
2862 (63150002, 11, 2),
2863 (63150002, 12, 2),
2864 (63150002, 13, 2),
2865 (63150002, 14, 2),
2866 (63150002, 15, 2),
2867 (63150002, 16, 2),
2868 (63150002, 17, 2),
2869 (63150003, 6, 2),
2870 (63150003, 9, 2),
2871 (63150003, 10, 2),
2872 (63150003, 11, 2),
2873 (63150003, 12, 2),
2874 (63150003, 13, 2),
2875 (63150003, 14, 2),
2876 (63150003, 15, 2),
2877 (63150003, 16, 2),
2878 (63150003, 17, 2),
2879 (63150004, 6, 2),
2880 (63150004, 9, 2),
2881 (63150004, 10, 2),
2882 (63150004, 11, 2),
2883 (63150004, 12, 2),
2884 (63150004, 13, 2),
2885 (63150004, 14, 2),
2886 (63150004, 15, 2),
2887 (63150004, 16, 2),
2888 (63150004, 17, 2),
2889 (63150011, 6, 2),
2890 (63150011, 9, 2),
2891 (63150011, 10, 2),
2892 (63150011, 11, 2),
2893 (63150011, 12, 2),
2894 (63150011, 13, 2),
2895 (63150011, 14, 2),
2896 (63150011, 15, 2),
2897 (63150011, 16, 2),
2898 (63150011, 17, 2),
2899 (63150005, 18, 2),
2900 (63150006, 18, 2),
2901 (63150007, 18, 2),
2902 (63150012, 18, 2),
2903 (63150013, 18, 2),
2904 (63150014, 18, 2),
2905 (63150015, 18, 2),
2906 (63150016, 18, 2),
2907 (63150017, 18, 2),
2908 (63150018, 18, 2),
2909 (63150019, 18, 2),
2910 (63150020, 18, 2),
2911 (63150005, 19, 2),
2912 (63150006, 19, 2),
2913 (63150007, 19, 2),
2914 (63150012, 19, 2),
2915 (63150013, 19, 2),
2916 (63150014, 19, 2),
2917 (63150015, 19, 2),
2918 (63150016, 19, 2),
2919 (63150017, 19, 2),
2920 (63150018, 19, 2),
2921 (63150019, 19, 2),
2922 (63150020, 19, 2),
2923 (63150005, 20, 2),
2924 (63150006, 20, 2),
2925 (63150007, 20, 2),
2926 (63150012, 20, 2),
2927 (63150013, 20, 2),
2928 (63150014, 20, 2),
2929 (63150015, 20, 2),
2930 (63150016, 20, 2),
2931 (63150017, 20, 2),
2932 (63150018, 20, 2),
2933 (63150019, 20, 2),
2934 (63150020, 20, 2),
2935 (63150005, 21, 2),
2936 (63150006, 21, 2),
2937 (63150007, 21, 2),
2938 (63150012, 21, 2),
2939 (63150013, 21, 2),
2940 (63150014, 21, 2),
2941 (63150015, 21, 2),
2942 (63150016, 21, 2),
2943 (63150017, 21, 2),
2944 (63150018, 21, 2),
2945 (63150019, 21, 2),
2946 (63150020, 21, 2),
2947 (63150005, 22, 2),
2948 (63150006, 22, 2),
2949 (63150007, 22, 2),
2950 (63150012, 22, 2),
2951 (63150013, 22, 2),
2952 (63150014, 22, 2),
2953 (63150015, 22, 2),
2954 (63150016, 22, 2),
2955 (63150017, 22, 2),
2956 (63150018, 22, 2),
2957 (63150019, 22, 2),
2958 (63150020, 22, 2),
2959 (63150005, 23, 2),
2960 (63150006, 23, 2),
2961 (63150007, 23, 2),
2962 (63150012, 23, 2),
2963 (63150013, 23, 2),
2964 (63150014, 23, 2),
2965 (63150015, 23, 2),
2966 (63150016, 23, 2),
2967 (63150017, 23, 2),
2968 (63150018, 23, 2),
2969 (63150019, 23, 2),
2970 (63150020, 23, 2),
2971 (63150005, 24, 2),
2972 (63150006, 24, 2),
2973 (63150007, 24, 2),
2974 (63150012, 24, 2),
2975 (63150013, 24, 2),
2976 (63150014, 24, 2),
2977 (63150015, 24, 2),
2978 (63150016, 24, 2),
2979 (63150017, 24, 2),
2980 (63150018, 24, 2),
2981 (63150019, 24, 2),
2982 (63150020, 24, 2),
2983 (63150005, 25, 2),
2984 (63150006, 25, 2),
2985 (63150007, 25, 2),
2986 (63150012, 25, 2),
2987 (63150013, 25, 2),
2988 (63150014, 25, 2),
2989 (63150015, 25, 2),
2990 (63150016, 25, 2),
2991 (63150017, 25, 2),
2992 (63150018, 25, 2),
2993 (63150019, 25, 2),
2994 (63150020, 25, 2),
2995 (63150005, 26, 2),
2996 (63150006, 26, 2),
2997 (63150007, 26, 2),
2998 (63150012, 26, 2),
2999 (63150013, 26, 2),
3000 (63150014, 26, 2),
3001 (63150015, 26, 2),
3002 (63150016, 26, 2),
3003 (63150017, 26, 2),
3004 (63150018, 26, 2),
3005 (63150019, 26, 2),
3006 (63150020, 26, 2),
3007 (63150000, 1, 2),
3008 (63150001, 1, 2),
3009 (63150002, 1, 2),
3010 (63150022, 18,2),
3011 (63150022, 19,2),
3012 (63150022, 20,2),
3013 (63150022, 21,2),
3014 (63150022, 22,2);
3015/*
3016(63150022, 57,2);
3017*/
3018
3019INSERT INTO prijava(ID_PRIJAVA, ID_ROK, VPISNA_STEVILKA, ZAP_ST_POLAGANJ, ZAP_ST_POLAGANJ_LETOS, PODATKI_O_PLACILU, TOCKE_IZPITA, DATUM_PRIJAVE, DATUM_ODJAVE) VALUES
3020 /* Prijave na izpite TPO. 1,2 in 3 rok, stud. leto 2017/18 */
3021 (1, 1, 63150000, 1, 1, 1, NULL, '2018-01-02 12:22:00', NULL),
3022 (2, 1, 63150001, 1, 1, 1, NULL, '2018-01-04 12:23:00', NULL),
3023 (3, 1, 63150002, 1, 1, 2, NULL, '2018-01-05 23:32:22', NULL),
3024 (4, 2, 63150000, 2, 2, 1, NULL, '2018-01-03 12:23:34', NULL),
3025 (5, 2, 63150001, 1, 1, 1, NULL, '2018-06-01 11:12:13', NULL),
3026 (6, 2, 63150002, 2, 2, 1, NULL, '2018-06-01 17:12:13', NULL),
3027 (7, 3, 63150003, 2, 2, 1, NULL, '2018-06-03 15:16:17', NULL),
3028
3029 /* Prijave na izpite P1. 1,2 in 3 rok, stud. leto 2017/18 */
3030 (8, 4, 63150000, 1, 1, 1, NULL, '2018-01-02 11:11:11', NULL),
3031 (9, 5, 63150000, 2, 2, 1, NULL, '2018-01-03 12:12:12', NULL),
3032 (10,4, 63150001, 1, 1, 1, NULL, '2018-01-04 13:14:11', NULL),
3033 (11,4, 63150002, 1, 1, 1, NULL, '2018-01-05 16:16:16', NULL),
3034 (12,4, 63150003, 1, 1, 1, NULL, '2018-01-05 17:16:15', NULL),
3035 (13,4, 63150004, 1, 1, 1, NULL, '2018-01-05 14:13:12', NULL),
3036 (14,5, 63150004, 2, 1, 1, NULL, '2018-01-05 14:11:12', NULL),
3037 (15,4, 63150011, 1, 1, 1, NULL, '2018-01-05 11:10:09', NULL);
3038
3039
3040INSERT INTO `posta_obcina` (`MID_POSTA`, `MID_OBCINA`) VALUES
3041 (21431010, 11027156),
3042 (21431125, 11027962),
3043 (21428574, 11027156),
3044 (21432539, 11027156),
3045 (21432164, 11027156),
3046 (21429481, 11027156),
3047 (21431036, 11027962),
3048 (21428698, 11027962),
3049 (21429180, 11027156),
3050 (21432954, 11027156),
3051 (21431656, 11027156),
3052 (21431834, 11027156),
3053 (21428850, 11027156),
3054 (21430404, 11027849),
3055 (21430455, 11027849),
3056 (21430137, 11027784),
3057 (21428612, 11026982),
3058 (21430048, 11026982),
3059 (21428469, 11026982),
3060 (21432024, 11026982),
3061 (21430064, 11027911),
3062 (21430820, 11027911),
3063 (21430854, 11027113),
3064 (21430951, 11027148),
3065 (21433390, 11026982),
3066 (21431257, 11026982),
3067 (21433420, 11027008),
3068 (21433284, 11027016),
3069 (21430447, 11027849),
3070 (21430439, 11027849),
3071 (21430412, 11027849),
3072 (21430234, 11026982),
3073 (21431150, 11027008),
3074 (21429856, 11027008),
3075 (21430242, 11027806),
3076 (21428973, 11027016),
3077 (21430307, 11027822),
3078 (21430331, 11026982),
3079 (21430293, 11027016),
3080 (21433411, 11027016),
3081 (21429791, 11027016),
3082 (21431834, 11027911),
3083 (21430480, 11027857),
3084 (21430188, 11027857),
3085 (21430463, 11027849),
3086 (21430668, 11027857),
3087 (21431672, 11027083),
3088 (21432342, 11027083),
3089 (21429457, 11027903),
3090 (21430781, 11027903),
3091 (21430943, 11027920),
3092 (21431788, 11026982),
3093 (21431141, 11027016),
3094 (21430641, 11027083),
3095 (21430595, 11027083),
3096 (21430790, 11027105),
3097 (21431613, 11027105),
3098 (21432822, 11027920),
3099 (21432776, 11027920),
3100 (21432725, 11027849),
3101 (21433144, 11027857),
3102 (21432423, 11027903),
3103 (21430986, 11027920),
3104 (21432768, 11027954),
3105 (21430986, 11027954),
3106 (21430773, 11027091),
3107 (21429236, 11027946),
3108 (21430978, 11027946),
3109 (21431354, 11027946),
3110 (21429341, 11027784),
3111 (21430765, 11027784),
3112 (21429686, 11026915),
3113 (21433217, 11026915),
3114 (21432644, 11026915),
3115 (21430226, 11026605),
3116 (21428671, 11026605),
3117 (21429775, 11026605),
3118 (21429988, 11026966),
3119 (21428736, 11026621),
3120 (21430382, 11026621),
3121 (21432814, 11026621),
3122 (21428876, 11026672),
3123 (21432300, 11026966),
3124 (21428884, 11027776),
3125 (21433152, 11026737),
3126 (21432407, 11026737),
3127 (21428744, 11026630),
3128 (21429970, 11026966),
3129 (21429422, 11027776),
3130 (21428949, 11027776),
3131 (21431249, 11027776),
3132 (21429228, 11026788),
3133 (21429619, 11026885),
3134 (21429651, 11026893),
3135 (21431931, 11026893),
3136 (21429333, 11026893),
3137 (21433551, 11027784),
3138 (21430757, 11027784),
3139 (21433403, 11027784),
3140 (21430471, 11027032),
3141 (21428663, 11027849),
3142 (21430897, 11027121),
3143 (21431559, 11027784),
3144 (21430960, 11027938),
3145 (21430617, 11027075),
3146 (21430587, 11027067),
3147 (21432792, 11027113),
3148 (21430030, 11027776),
3149 (21432717, 11027776),
3150 (21428914, 11026516),
3151 (21429031, 11026516),
3152 (21428396, 11026524),
3153 (21428434, 11026605),
3154 (21432695, 11026621),
3155 (21429520, 11026869),
3156 (21432229, 11026796),
3157 (21433411, 11026796),
3158 (21428345, 11027776),
3159 (21431451, 11026800),
3160 (21428663, 11026591),
3161 (21431192, 11026605),
3162 (21432261, 11026605),
3163 (21432873, 11026621),
3164 (21430994, 11026591),
3165 (21431591, 11026591),
3166 (21433390, 11026605),
3167 (21432881, 11026613),
3168 (21429961, 11027750),
3169 (21429953, 11026958),
3170 (21432679, 11027776),
3171 (21430013, 11027768),
3172 (21432849, 11027768),
3173 (21428337, 11026516),
3174 (21433349, 11026788),
3175 (21429406, 11026834),
3176 (21430684, 11027776),
3177 (21428566, 11026575),
3178 (21431168, 11026842),
3179 (21432512, 11026842),
3180 (21430170, 11026842),
3181 (21428361, 11026605),
3182 (21429716, 11026923),
3183 (21428957, 11026940),
3184 (21429872, 11026940),
3185 (21429821, 11026940),
3186 (21429864, 11026630),
3187 (21432911, 11026788),
3188 (21430340, 11026788),
3189 (21429104, 11026885),
3190 (21430196, 11026915),
3191 (21433373, 11026915),
3192 (21431893, 11026940),
3193 (21428833, 11026516),
3194 (21429325, 11026605),
3195 (21429899, 11026605),
3196 (21429015, 11026605),
3197 (21428680, 11026630),
3198 (21428990, 11026761),
3199 (21432598, 11026788),
3200 (21428574, 11027768),
3201 (21430102, 11027709),
3202 (21430749, 11027709),
3203 (21431044, 11027709),
3204 (21432768, 11026834),
3205 (21432296, 11026966),
3206 (21433195, 11026516),
3207 (21428752, 11026605),
3208 (21428906, 11026893),
3209 (21431257, 11026605),
3210 (21432202, 11026893),
3211 (21432199, 11026893),
3212 (21432920, 11027571),
3213 (21431818, 11027288),
3214 (21431907, 11027326),
3215 (21432822, 11027547),
3216 (21432903, 11027547),
3217 (21433004, 11027598),
3218 (21433080, 11027610),
3219 (21431150, 11027199),
3220 (21429732, 11027199),
3221 (21431273, 11027202),
3222 (21431907, 11027202),
3223 (21430323, 11027202),
3224 (21431397, 11028012),
3225 (21431664, 11028039),
3226 (21431745, 11027253),
3227 (21430099, 11027288),
3228 (21432059, 11027369),
3229 (21428558, 11027369),
3230 (21432415, 11027369),
3231 (21432091, 11027385),
3232 (21432105, 11027393),
3233 (21432610, 11027466),
3234 (21429830, 11027466),
3235 (21432571, 11027440),
3236 (21428809, 11027440),
3237 (21432857, 11027466),
3238 (21429511, 11027466),
3239 (21429210, 11027466),
3240 (21429376, 11027466),
3241 (21431613, 11027288),
3242 (21431362, 11027326),
3243 (21432474, 11027253),
3244 (21431753, 11027261),
3245 (21429023, 11027571),
3246 (21430161, 11027598),
3247 (21433055, 11027962),
3248 (21431303, 11027385),
3249 (21431141, 11027199),
3250 (21429724, 11027199),
3251 (21432369, 11027962),
3252 (21433438, 11027393),
3253 (21431516, 11027229),
3254 (21432075, 11027440),
3255 (21433454, 11027440),
3256 (21430196, 11026737),
3257 (21431117, 11027989),
3258 (21432750, 11027393),
3259 (21433209, 11027431),
3260 (21428701, 11027202),
3261 (21431630, 11027202),
3262 (21433179, 11028039),
3263 (21431559, 11027431),
3264 (21432563, 11027431),
3265 (21432512, 11026877),
3266 (21431168, 11026877),
3267 (21431494, 11027466),
3268 (21430170, 11026877),
3269 (21428787, 11026656),
3270 (21429368, 11026800),
3271 (21432199, 11026800),
3272 (21433039, 11026869),
3273 (21432709, 11026869),
3274 (21432725, 11026869),
3275 (21430129, 11026974),
3276 (21428701, 11026974),
3277 (21431389, 11026974),
3278 (21428868, 11026664),
3279 (21431273, 11026974),
3280 (21430323, 11026974),
3281 (21433608, 11026800),
3282 (21428787, 11026893),
3283 (21432202, 11026656),
3284 (21431974, 11026800),
3285 (21431842, 11027296),
3286 (21429147, 11027296),
3287 (21432008, 11027342),
3288 (21431109, 11027296),
3289 (21431362, 11027512),
3290 (21432733, 11027512),
3291 (21431966, 11027997),
3292 (21431214, 11027229),
3293 (21433128, 11027296),
3294 (21430269, 11027393),
3295 (21431524, 11027393),
3296 (21431508, 11027997),
3297 (21429716, 11027997),
3298 (21431206, 11028004),
3299 (21430552, 11027512),
3300 (21429627, 11027229),
3301 (21431630, 11027512),
3302 (21431729, 11027245),
3303 (21432482, 11027512),
3304 (21429295, 11027245),
3305 (21432890, 11027563),
3306 (21431729, 11027415),
3307 (21432474, 11027423),
3308 (21431605, 11027229),
3309 (21431559, 11027237),
3310 (21433047, 11027601),
3311 (21430200, 11027369),
3312 (21432580, 11027369),
3313 (21433012, 11027369),
3314 (21432067, 11027377),
3315 (21429244, 11027377),
3316 (21432849, 11027377),
3317 (21430579, 11027377),
3318 (21431052, 11027164),
3319 (21431184, 11027997),
3320 (21432601, 11027458),
3321 (21428698, 11027458),
3322 (21432652, 11027474),
3323 (21432741, 11027474),
3324 (21430587, 11027296),
3325 (21431923, 11027300),
3326 (21432598, 11027288),
3327 (21430340, 11027288),
3328 (21431940, 11027334),
3329 (21431419, 11027334),
3330 (21432652, 11027369),
3331 (21432792, 11027385),
3332 (21430854, 11027385),
3333 (21430552, 11027466),
3334 (21431621, 11027466),
3335 (21430323, 11027466),
3336 (21429511, 11027512),
3337 (21429376, 11027512),
3338 (21429341, 11027598),
3339 (21433322, 11027261),
3340 (21431397, 11027261),
3341 (21429279, 11027334),
3342 (21428418, 11027334),
3343 (21432598, 11027385),
3344 (21429007, 11027466),
3345 (21428710, 11027474),
3346 (21433357, 11027466),
3347 (21430099, 11027385),
3348 (21431354, 11027598),
3349 (21432822, 11027385),
3350 (21430676, 11027199),
3351 (21432571, 11027199),
3352 (21429791, 11027199),
3353 (21433420, 11027199),
3354 (21432113, 11027407),
3355 (21429732, 11027440),
3356 (21431222, 11027466),
3357 (21430960, 11027261),
3358 (21428841, 11027679),
3359 (21431320, 11027679),
3360 (21433365, 11027679),
3361 (21432695, 11028080),
3362 (21433268, 11028080),
3363 (21429937, 11027679),
3364 (21433381, 11028101),
3365 (21429040, 21427705),
3366 (21429309, 11028080),
3367 (21433535, 11027407),
3368 (21433195, 11027636),
3369 (21433535, 11027687),
3370 (21428582, 21427667),
3371 (21433489, 21427799),
3372 (21431338, 21427870),
3373 (21433241, 21428086),
3374 (21432857, 11027555),
3375 (21432547, 21427926),
3376 (21433560, 21428124),
3377 (21431346, 11027636),
3378 (21431869, 21428051),
3379 (21429082, 11026583),
3380 (21432377, 11027687),
3381 (21433225, 11028071),
3382 (21429350, 21427667),
3383 (21430005, 11026583),
3384 (21431133, 11028012),
3385 (21429902, 11028012),
3386 (21432458, 11028012),
3387 (21431982, 11028012),
3388 (21432130, 11026575),
3389 (21431869, 11028012),
3390 (21433179, 21427870),
3391 (21433519, 21427870),
3392 (21431486, 21428035),
3393 (21430803, 21427756),
3394 (21429554, 21427756),
3395 (21431419, 21427756),
3396 (21430692, 21427756),
3397 (21429210, 11028080),
3398 (21430498, 11027407),
3399 (21432776, 21427667),
3400 (21431087, 21427756),
3401 (21431079, 21427861),
3402 (21432113, 21427861),
3403 (21429562, 21427764),
3404 (21432156, 21427918),
3405 (21432440, 21428078),
3406 (21429201, 11026699),
3407 (21433187, 11026699),
3408 (21433519, 11028063),
3409 (21432822, 11027610),
3410 (21431672, 11028063),
3411 (21429708, 11027679),
3412 (21433446, 11027393),
3413 (21431915, 11027318),
3414 (21428469, 11027369),
3415 (21433357, 11027369),
3416 (21431079, 11027393),
3417 (21430072, 11028004),
3418 (21431958, 11027679),
3419 (21430846, 21427853),
3420 (21432148, 21428060),
3421 (21433128, 21428060),
3422 (21431028, 21428060),
3423 (21430544, 11027369),
3424 (21432300, 11026699),
3425 (21428922, 11026699),
3426 (21433179, 11028063),
3427 (21430137, 11027431),
3428 (21431567, 11028004),
3429 (21433306, 11028004),
3430 (21431524, 11027245),
3431 (21432784, 21428264),
3432 (21431583, 21428264),
3433 (21432083, 11027563),
3434 (21430927, 11027563),
3435 (21428787, 11027563),
3436 (21429473, 11027563),
3437 (21433608, 11027695),
3438 (21431982, 21427900),
3439 (21432199, 11027695),
3440 (21432393, 21427721),
3441 (21429155, 21427721),
3442 (21429449, 21427730),
3443 (21431265, 11027563),
3444 (21428353, 21436437),
3445 (21430803, 21428027),
3446 (21431818, 21428043),
3447 (21429392, 21436437),
3448 (21428329, 11026699),
3449 (21428400, 21427624),
3450 (21431001, 11028080),
3451 (21433586, 11028128),
3452 (21432172, 11028128),
3453 (21432989, 11027679),
3454 (21433349, 11028098),
3455 (21429074, 21427713),
3456 (21432202, 11027563),
3457 (21430609, 21427845),
3458 (21433055, 21427721),
3459 (21429279, 21427845),
3460 (21431133, 21427845),
3461 (21431613, 21428043),
3462 (21428850, 11027563),
3463 (21429651, 11027563),
3464 (21430790, 21428043),
3465 (21433322, 11028098),
3466 (21431303, 11027113),
3467 (21432466, 21427683),
3468 (21428795, 21427683),
3469 (21429007, 21427691),
3470 (21433071, 21427829),
3471 (21431532, 21427888),
3472 (21432962, 21427942),
3473 (21428973, 21427942),
3474 (21432997, 21427969),
3475 (21429252, 21427993),
3476 (21433624, 21427993),
3477 (21429546, 21427993),
3478 (21432270, 11026575),
3479 (21430510, 11026575),
3480 (21429368, 11028128),
3481 (21431265, 11028128),
3482 (21431974, 11028128),
3483 (21430188, 21427837),
3484 (21433110, 21428094),
3485 (21433144, 21427977),
3486 (21433373, 21427993),
3487 (21428728, 21427675),
3488 (21428400, 21428078),
3489 (21430293, 21428078),
3490 (21429791, 21428078),
3491 (21431532, 21427667),
3492 (21432865, 21427667),
3493 (21432865, 21427934),
3494 (21433535, 11028071),
3495 (21432687, 11027482),
3496 (21429503, 21428124),
3497 (21428892, 11027814),
3498 (21430048, 11026605),
3499 (21431389, 11026605),
3500 (21429384, 11026818),
3501 (21430692, 11027881),
3502 (21429350, 21427934),
3503 (21431460, 21436488),
3504 (21432245, 21433632),
3505 (21432466, 21427624),
3506 (21432652, 11026982),
3507 (21432741, 21433683),
3508 (21433462, 11026559),
3509 (21432776, 11027539),
3510 (21431761, 11026761),
3511 (21431419, 11027881),
3512 (21432911, 11028098),
3513 (21429813, 21433675),
3514 (21432504, 21433675),
3515 (21429856, 11027881),
3516 (21428639, 11027881),
3517 (21431095, 11027172),
3518 (21433101, 11027172),
3519 (21429996, 11027172),
3520 (21432466, 21433667),
3521 (21429392, 11026826),
3522 (21430676, 11026796),
3523 (21429848, 11027270),
3524 (21433292, 21428108),
3525 (21432440, 21436437),
3526 (21433276, 24063453),
3527 (21431834, 24063453),
3528 (21433462, 24063461),
3529 (21428639, 21427900),
3530 (21431150, 11027881),
3531 (21429694, 11027172),
3532 (21432474, 21427837),
3533 (21429503, 21427888),
3534 (21429813, 11026931),
3535 (21430595, 11027741),
3536 (21429171, 11026770),
3537 (21430714, 11026770),
3538 (21431427, 11026770),
3539 (21431419, 11027393),
3540 (21430366, 11027881),
3541 (21430820, 24063453),
3542 (21428817, 11027741),
3543 (21429929, 11027741),
3544 (21432539, 24063453),
3545 (21428825, 21436445),
3546 (21428981, 11027377),
3547 (21432032, 11027377),
3548 (21430013, 11027377),
3549 (21432997, 11027091),
3550 (21431508, 11026923),
3551 (21430056, 21436453),
3552 (21432440, 21427624),
3553 (21431036, 21427853),
3554 (21429309, 11027407),
3555 (21432458, 21427900),
3556 (21431133, 21427900),
3557 (21430676, 11027881),
3558 (21431141, 11027881),
3559 (21431281, 11027172),
3560 (21431737, 11026885),
3561 (21432440, 24063496),
3562 (21428973, 11026702),
3563 (21431664, 11026702),
3564 (21432393, 21433659),
3565 (21431036, 21433659),
3566 (21430650, 21436488),
3567 (21430293, 11027881),
3568 (21431427, 11027172),
3569 (21429384, 11027172),
3570 (21428523, 11026559),
3571 (21428531, 11026559),
3572 (21430218, 11027270),
3573 (21428655, 11027270),
3574 (21431770, 11027270),
3575 (21431974, 11027482),
3576 (21429902, 11027261),
3577 (21433594, 21427985),
3578 (21429538, 21427748),
3579 (21430714, 21428019),
3580 (21431338, 21427985),
3581 (21433349, 11027261),
3582 (21433063, 11027679),
3583 (21431745, 11026826),
3584 (21430595, 11028063),
3585 (21429538, 11028063),
3586 (21430269, 21436488),
3587 (21430650, 21436461),
3588 (21428612, 11027369),
3589 (21431397, 21428051),
3590 (21428370, 11027270),
3591 (21431354, 11027270),
3592 (21432776, 11027547),
3593 (21433080, 11027547),
3594 (21432326, 11027415),
3595 (21430706, 11027415),
3596 (21432849, 11026516),
3597 (21430811, 11027172),
3598 (21432253, 11026559),
3599 (21433306, 11027709),
3600 (21432245, 11027172),
3601 (21429384, 11026770),
3602 (21431524, 11027741),
3603 (21432199, 11026656),
3604 (21428795, 21433667),
3605 (21429171, 11026818),
3606 (21431427, 11026931),
3607 (21431664, 21427748),
3608 (21433420, 11027881),
3609 (21428868, 11027822),
3610 (21429074, 11027822),
3611 (21432555, 21428124),
3612 (21428477, 11026532),
3613 (21429163, 11026761),
3614 (21429112, 11026761),
3615 (21431176, 21428124),
3616 (21428442, 11027873),
3617 (21430625, 11027873),
3618 (21430943, 24063488),
3619 (21430986, 24063488),
3620 (21431826, 24063488),
3621 (21428400, 21433667),
3622 (21430293, 21433667),
3623 (21432237, 11026826),
3624 (21429198, 11027067),
3625 (21429147, 11027067),
3626 (21432814, 21428124),
3627 (21429040, 21428124),
3628 (21428515, 11026532),
3629 (21430315, 11027270),
3630 (21431451, 11027482),
3631 (21431842, 21428060),
3632 (21431109, 21428060),
3633 (21428353, 11026826),
3634 (21429791, 24063496),
3635 (21430293, 24063496),
3636 (21431141, 24063496),
3637 (21433080, 21428035),
3638 (21431753, 11028012),
3639 (21433012, 11027474),
3640 (21432938, 21427853),
3641 (21431427, 21433675),
3642 (21432326, 21427748),
3643 (21428418, 11027881),
3644 (21430536, 11027059),
3645 (21432822, 11027539),
3646 (21431176, 11026621),
3647 (21431494, 11027407),
3648 (21432792, 21428051),
3649 (21433365, 11027571),
3650 (21429813, 21428086),
3651 (21430692, 11027199),
3652 (21431818, 11027385),
3653 (21431869, 11027261),
3654 (21430153, 11027121),
3655 (21433420, 11027440),
3656 (21433454, 21436437),
3657 (21431435, 11027482),
3658 (21432601, 21433683),
3659 (21433322, 21428051),
3660 (21432989, 21428108),
3661 (21430765, 11027482),
3662 (21429694, 11027857),
3663 (21432652, 21433683),
3664 (21433063, 11027121),
3665 (21433551, 11027482),
3666 (21431281, 21433675),
3667 (21428809, 11027199),
3668 (21431982, 11027881),
3669 (21432636, 24063500),
3670 (21429759, 11027717),
3671 (21429678, 11027717),
3672 (21429767, 11027725),
3673 (21428485, 11027725),
3674 (21433314, 11027059),
3675 (21433314, 11027652),
3676 (21431931, 11027059),
3677 (21431931, 11027652),
3678 (21429066, 11026745),
3679 (21429589, 11026745),
3680 (21431435, 11026745),
3681 (21430277, 11027814),
3682 (21429864, 11027733),
3683 (21431761, 11027733),
3684 (21432288, 11027733),
3685 (21430021, 21427802),
3686 (21430617, 11027733),
3687 (21431885, 11027628),
3688 (21433128, 11027628),
3689 (21433039, 11027628),
3690 (21428779, 11026648),
3691 (21429465, 11026648),
3692 (21430528, 11027652),
3693 (21432946, 11027580),
3694 (21430838, 24063500),
3695 (21429945, 11027717),
3696 (21429643, 11027725),
3697 (21428981, 11026729),
3698 (21433306, 11026729),
3699 (21430765, 11027890),
3700 (21432687, 11027890),
3701 (21431486, 21427667),
3702 (21431567, 11027717),
3703 (21428540, 11027652),
3704 (21430463, 11027890),
3705 (21429783, 11027814),
3706 (21432628, 11027814),
3707 (21429414, 11027792),
3708 (21430862, 11027792),
3709 (21430145, 11027792),
3710 (21432032, 11026729),
3711 (21431044, 11026729),
3712 (21431346, 11026729),
3713 (21433357, 11026982),
3714 (21431044, 11027717),
3715 (21431796, 11026648),
3716 (21429589, 11027652),
3717 (21430374, 21428264),
3718 (21430099, 21428043),
3719 (21431893, 11027563),
3720 (21429554, 11027881),
3721 (21433284, 21433667),
3722 (21433594, 21427870),
3723 (21431397, 21427845),
3724 (21430480, 11027172),
3725 (21431672, 21427870),
3726 (24034658, 21427896),
3727 (21432784, 11026915),
3728 (21432776, 21428035),
3729 (21428353, 21428078),
3730 (21432091, 11027288),
3731 (21430404, 21428264),
3732 (21432342, 21427985),
3733 (21429350, 21427888),
3734 (21433292, 21427934),
3735 (21432865, 21428108),
3736 (21430960, 11026788),
3737 (21430277, 11026621),
3738 (21428477, 24063461),
3739 (21433080, 11027113),
3740 (21431087, 11027245),
3741 (21431486, 21428124),
3742 (21433527, 11027369),
3743 (21428485, 11026532),
3744 (21433322, 11028012),
3745 (21431923, 11027326),
3746 (21428345, 24063526),
3747 (21430048, 11026974),
3748 (21431621, 11026974),
3749 (21431222, 21427691),
3750 (21430641, 21436461),
3751 (21433527, 11027814),
3752 (21430285, 11027733),
3753 (21430935, 11027733),
3754 (21432709, 11027504),
3755 (21429112, 11026753),
3756 (21432318, 11027865),
3757 (21431028, 21427659),
3758 (21429589, 21427772),
3759 (21433098, 11027580),
3760 (21433136, 11027580),
3761 (21430838, 24063518),
3762 (21432938, 21436470),
3763 (21428540, 11026567),
3764 (21431311, 11027717),
3765 (21430528, 24063470),
3766 (21428663, 24063470),
3767 (21432121, 11027890),
3768 (21428442, 11027733),
3769 (21431435, 21427772),
3770 (21433314, 21427772),
3771 (21430650, 11027393),
3772 (21433624, 11027580),
3773 (21430889, 21436470),
3774 (21430838, 21436470),
3775 (21429066, 11027890),
3776 (21431737, 11028055),
3777 (21429597, 11027059),
3778 (21429333, 11027059),
3779 (21432482, 11027466),
3780 (21429660, 11027504),
3781 (21429660, 11026907),
3782 (21429023, 11028055),
3783 (21428388, 11026648),
3784 (21430404, 11026907),
3785 (21431591, 11026907),
3786 (21432709, 11026907),
3787 (21428361, 11026982),
3788 (21429058, 11027580),
3789 (21430846, 11027580),
3790 (21433616, 11027725),
3791 (21430838, 11027580),
3792 (21430374, 11027024),
3793 (21431826, 11027954),
3794 (21432342, 21436461),
3795 (21433616, 21428116),
3796 (21430315, 21428116),
3797 (21432229, 11028039),
3798 (21428973, 11028039),
3799 (21432687, 11026800),
3800 (21432920, 21427888),
3801 (21433080, 21428124),
3802 (21432857, 11026621),
3803 (21430811, 11027857),
3804 (21433594, 11027083),
3805 (21429171, 11028039),
3806 (21432989, 11027873),
3807 (21432091, 11026788),
3808 (21432580, 24063500),
3809 (21430200, 24063500),
3810 (21432415, 11027474),
3811 (21431788, 11027474),
3812 (21433152, 11026869),
3813 (21429368, 11026745),
3814 (21432644, 21428264),
3815 (21429139, 11027024),
3816 (21431320, 11027024),
3817 (21431281, 11026770),
3818 (21428736, 11027814),
3819 (21432857, 11027814),
3820 (21430544, 11027814),
3821 (21431028, 11027628),
3822 (21431648, 11027130),
3823 (21430722, 11027130),
3824 (21431699, 11028047),
3825 (21428493, 11028047),
3826 (21430722, 11027148),
3827 (21431478, 11027024),
3828 (21432784, 11027024),
3829 (21431958, 11027024),
3830 (21430153, 11027024),
3831 (21430404, 11027024),
3832 (21429112, 11027024),
3833 (21431737, 11027369),
3834 (21432342, 11027326),
3835 (21431800, 11027792),
3836 (21428426, 21427632),
3837 (21429457, 11026699),
3838 (21430463, 11027644),
3839 (21433250, 11027644),
3840 (21430188, 11027253),
3841 (21428507, 11027130),
3842 (21429287, 11027130),
3843 (21433063, 11027024),
3844 (21433292, 11027954),
3845 (21429317, 11027024),
3846 (21429724, 11027440),
3847 (21430919, 11027130),
3848 (21429791, 11027440),
3849 (21433535, 21427861),
3850 (21428434, 21427632),
3851 (21430170, 11027130),
3852 (21430633, 11028047),
3853 (21433519, 21436445),
3854 (21430897, 11027873),
3855 (21430854, 11027610),
3856 (21428574, 11026516),
3857 (21430633, 21427730),
3858 (21429163, 11027091),
3859 (21430765, 11026745),
3860 (21431931, 11026745),
3861 (21429503, 11027814),
3862 (21430153, 21428264),
3863 (21430471, 24063488),
3864 (21429112, 11027121),
3865 (21428604, 11026958),
3866 (21431290, 11027776);