text: -- --------------------------------------------------------
  -- Host:                         127.0.0.1
  -- Server version:               10.1.32-MariaDB - mariadb.org binary distribution
  -- Server OS:                    Win32
  -- HeidiSQL Version:             9.5.0.5196
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8 */;
  /*!50503 SET NAMES utf8mb4 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  
  
  -- Dumping database structure for fakultet
  DROP DATABASE IF EXISTS `fakultet`;
  CREATE DATABASE IF NOT EXISTS `fakultet` /*!40100 DEFAULT CHARACTER SET utf8 */;
  USE `fakultet`;
  
  -- Dumping structure for table fakultet.dvorana
  DROP TABLE IF EXISTS `dvorana`;
  CREATE TABLE IF NOT EXISTS `dvorana` (
    `oznDvorana` char(5) CHARACTER SET utf8 NOT NULL,
    `kapacitet` int(11) DEFAULT '40',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`oznDvorana`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.dvorana: ~26 rows (approximately)
  /*!40000 ALTER TABLE `dvorana` DISABLE KEYS */;
  INSERT INTO `dvorana` (`oznDvorana`, `kapacitet`, `created_at`, `updated_at`) VALUES
  	('A001', 24, NULL, NULL),
  	('A002', 10, NULL, NULL),
  	('A101', 39, NULL, NULL),
  	('A102', 40, NULL, NULL),
  	('A104', 20, NULL, NULL),
  	('A105', 16, NULL, NULL),
  	('A111', 40, NULL, NULL),
  	('A201', 40, NULL, NULL),
  	('A202', 39, NULL, NULL),
  	('A204', 20, NULL, NULL),
  	('A205', 20, NULL, NULL),
  	('A209', 35, NULL, NULL),
  	('A210', 35, NULL, NULL),
  	('A211', 39, NULL, NULL),
  	('A301', 18, NULL, NULL),
  	('A302', 18, NULL, NULL),
  	('A304', 15, NULL, NULL),
  	('A309', 22, NULL, NULL),
  	('A310', 20, NULL, NULL),
  	('A311', 20, NULL, NULL),
  	('A312', 20, NULL, NULL),
  	('B1', 64, NULL, NULL),
  	('B2', 30, NULL, NULL),
  	('B3', 30, NULL, NULL),
  	('B4', 64, NULL, NULL),
  	('M2', 14, NULL, NULL);
  /*!40000 ALTER TABLE `dvorana` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.ispit
  DROP TABLE IF EXISTS `ispit`;
  CREATE TABLE IF NOT EXISTS `ispit` (
    `mbrStud` int(10) unsigned NOT NULL,
    `sifPred` int(10) unsigned NOT NULL,
    `sifNastavnik` int(10) unsigned NOT NULL,
    `datIspit` datetime NOT NULL,
    `ocjena` smallint(6) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    KEY `mbrStud` (`mbrStud`),
    KEY `sifPred` (`sifPred`),
    KEY `sifNastavnik` (`sifNastavnik`),
    CONSTRAINT `ispit_ibfk_1` FOREIGN KEY (`mbrStud`) REFERENCES `stud` (`mbrStud`),
    CONSTRAINT `ispit_ibfk_2` FOREIGN KEY (`sifPred`) REFERENCES `pred` (`sifPred`),
    CONSTRAINT `ispit_ibfk_3` FOREIGN KEY (`sifNastavnik`) REFERENCES `nastavnik` (`sifNastavnik`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.ispit: ~639 rows (approximately)
  /*!40000 ALTER TABLE `ispit` DISABLE KEYS */;
  INSERT INTO `ispit` (`mbrStud`, `sifPred`, `sifNastavnik`, `datIspit`, `ocjena`, `created_at`, `updated_at`) VALUES
  	(1167, 229, 122, '2002-08-23 00:00:00', 2, NULL, NULL),
  	(1210, 545, 481, '2002-10-22 00:00:00', 2, NULL, NULL),
  	(1272, 607, 191, '2003-01-14 00:00:00', 2, NULL, NULL),
  	(1312, 474, 142, '2003-06-05 00:00:00', 2, NULL, NULL),
  	(1369, 57, 256, '2002-12-30 00:00:00', 2, NULL, NULL),
  	(1426, 349, 379, '2003-08-22 00:00:00', 2, NULL, NULL),
  	(1464, 146, 326, '2002-12-17 00:00:00', 2, NULL, NULL),
  	(1490, 474, 501, '2003-04-10 00:00:00', 3, NULL, NULL),
  	(1127, 430, 277, '2002-11-27 00:00:00', 3, NULL, NULL),
  	(1306, 594, 456, '2003-05-20 00:00:00', 3, NULL, NULL),
  	(1471, 367, 195, '2003-06-24 00:00:00', 3, NULL, NULL),
  	(1421, 238, 277, '2003-06-06 00:00:00', 3, NULL, NULL),
  	(1267, 194, 330, '2003-04-02 00:00:00', 3, NULL, NULL),
  	(1376, 241, 501, '2002-10-09 00:00:00', 3, NULL, NULL),
  	(1498, 238, 277, '2003-05-30 00:00:00', 3, NULL, NULL),
  	(1370, 362, 456, '2003-05-01 00:00:00', 4, NULL, NULL),
  	(1434, 37, 166, '2003-06-20 00:00:00', 4, NULL, NULL),
  	(1393, 489, 371, '2003-06-03 00:00:00', 4, NULL, NULL),
  	(1120, 545, 122, '2003-08-25 00:00:00', 4, NULL, NULL),
  	(1125, 423, 150, '2003-01-07 00:00:00', 5, NULL, NULL),
  	(1127, 458, 166, '2002-12-30 00:00:00', 5, NULL, NULL),
  	(1172, 102, 232, '2002-06-21 00:00:00', 5, NULL, NULL),
  	(1139, 607, 281, '2002-12-10 00:00:00', 2, NULL, NULL),
  	(1140, 301, 301, '2002-09-10 00:00:00', 2, NULL, NULL),
  	(1145, 355, 334, '2003-06-03 00:00:00', 2, NULL, NULL),
  	(1230, 68, 371, '2002-12-13 00:00:00', 2, NULL, NULL),
  	(1152, 549, 391, '2002-03-26 00:00:00', 2, NULL, NULL),
  	(1153, 278, 436, '2003-09-11 00:00:00', 2, NULL, NULL),
  	(1160, 99, 481, '2002-12-02 00:00:00', 2, NULL, NULL),
  	(1331, 609, 505, '2002-09-19 00:00:00', 2, NULL, NULL),
  	(1172, 305, 154, '2003-09-03 00:00:00', 2, NULL, NULL),
  	(1173, 253, 166, '2002-06-28 00:00:00', 2, NULL, NULL),
  	(1178, 515, 236, '2002-10-07 00:00:00', 2, NULL, NULL),
  	(1386, 459, 256, '2002-10-30 00:00:00', 2, NULL, NULL),
  	(1189, 367, 285, '2003-08-27 00:00:00', 2, NULL, NULL),
  	(1190, 453, 301, '2003-01-14 00:00:00', 3, NULL, NULL),
  	(1441, 420, 391, '2002-11-08 00:00:00', 3, NULL, NULL),
  	(1204, 576, 436, '2003-03-24 00:00:00', 3, NULL, NULL),
  	(1209, 267, 465, '2002-09-12 00:00:00', 3, NULL, NULL),
  	(1216, 423, 509, '2002-11-25 00:00:00', 3, NULL, NULL),
  	(1490, 229, 122, '2002-12-11 00:00:00', 3, NULL, NULL),
  	(1222, 305, 154, '2003-01-13 00:00:00', 3, NULL, NULL),
  	(1223, 253, 166, '2003-01-07 00:00:00', 3, NULL, NULL),
  	(1229, 515, 236, '2003-04-22 00:00:00', 3, NULL, NULL),
  	(1230, 459, 256, '2003-04-18 00:00:00', 3, NULL, NULL),
  	(1237, 453, 301, '2002-09-19 00:00:00', 3, NULL, NULL),
  	(1242, 525, 334, '2003-08-27 00:00:00', 3, NULL, NULL),
  	(1243, 106, 375, '2003-09-05 00:00:00', 3, NULL, NULL),
  	(1249, 420, 391, '2003-09-04 00:00:00', 3, NULL, NULL),
  	(1254, 267, 465, '2003-09-10 00:00:00', 4, NULL, NULL),
  	(1259, 545, 481, '2003-06-27 00:00:00', 4, NULL, NULL),
  	(1261, 423, 509, '2003-01-24 00:00:00', 4, NULL, NULL),
  	(1266, 474, 142, '2003-04-15 00:00:00', 4, NULL, NULL),
  	(1222, 357, 154, '2003-10-21 00:00:00', 4, NULL, NULL),
  	(1274, 39, 236, '2002-10-25 00:00:00', 4, NULL, NULL),
  	(1279, 57, 256, '2003-09-12 00:00:00', 4, NULL, NULL),
  	(1280, 304, 289, '2002-10-22 00:00:00', 2, NULL, NULL),
  	(1266, 286, 326, '2003-09-02 00:00:00', 2, NULL, NULL),
  	(1287, 288, 367, '2003-02-04 00:00:00', 2, NULL, NULL),
  	(1292, 658, 379, '2003-04-17 00:00:00', 2, NULL, NULL),
  	(1294, 594, 411, '2003-06-19 00:00:00', 2, NULL, NULL),
  	(1299, 450, 436, '2003-08-26 00:00:00', 2, NULL, NULL),
  	(1306, 229, 481, '2002-09-30 00:00:00', 2, NULL, NULL),
  	(1314, 357, 154, '2003-04-21 00:00:00', 2, NULL, NULL),
  	(1351, 607, 191, '2003-05-06 00:00:00', 2, NULL, NULL),
  	(1317, 39, 236, '2003-09-16 00:00:00', 2, NULL, NULL),
  	(1323, 57, 256, '2003-01-23 00:00:00', 2, NULL, NULL),
  	(1324, 304, 289, '2003-02-11 00:00:00', 2, NULL, NULL),
  	(1329, 286, 326, '2003-04-01 00:00:00', 2, NULL, NULL),
  	(1393, 288, 367, '2003-05-16 00:00:00', 2, NULL, NULL),
  	(1336, 658, 379, '2003-05-09 00:00:00', 2, NULL, NULL),
  	(1337, 594, 411, '2003-05-26 00:00:00', 2, NULL, NULL),
  	(1343, 450, 436, '2002-07-05 00:00:00', 2, NULL, NULL),
  	(1344, 312, 465, '2003-09-02 00:00:00', 3, NULL, NULL),
  	(1434, 229, 481, '2002-12-26 00:00:00', 3, NULL, NULL),
  	(1351, 305, 514, '2003-09-09 00:00:00', 3, NULL, NULL),
  	(1356, 474, 142, '2003-04-30 00:00:00', 3, NULL, NULL),
  	(1357, 357, 154, '2002-05-20 00:00:00', 3, NULL, NULL),
  	(1363, 607, 191, '2003-09-12 00:00:00', 3, NULL, NULL),
  	(1483, 39, 236, '2003-01-03 00:00:00', 3, NULL, NULL),
  	(1370, 304, 289, '2003-06-12 00:00:00', 3, NULL, NULL),
  	(1376, 286, 326, '2002-11-29 00:00:00', 3, NULL, NULL),
  	(1377, 288, 367, '2003-04-10 00:00:00', 3, NULL, NULL),
  	(1381, 594, 411, '2003-07-04 00:00:00', 3, NULL, NULL),
  	(1386, 450, 436, '2003-05-23 00:00:00', 3, NULL, NULL),
  	(1388, 312, 465, '2003-03-14 00:00:00', 3, NULL, NULL),
  	(1393, 229, 481, '2003-03-10 00:00:00', 3, NULL, NULL),
  	(1230, 305, 514, '2002-10-11 00:00:00', 3, NULL, NULL),
  	(1401, 646, 154, '2003-01-22 00:00:00', 3, NULL, NULL),
  	(1406, 367, 195, '2003-05-23 00:00:00', 3, NULL, NULL),
  	(1408, 429, 244, '2003-03-12 00:00:00', 3, NULL, NULL),
  	(1331, 430, 277, '2002-12-17 00:00:00', 3, NULL, NULL),
  	(1419, 146, 326, '2003-02-18 00:00:00', 4, NULL, NULL),
  	(1421, 371, 367, '2003-10-08 00:00:00', 4, NULL, NULL),
  	(1386, 362, 411, '2003-01-31 00:00:00', 4, NULL, NULL),
  	(1433, 594, 456, '2003-05-27 00:00:00', 4, NULL, NULL),
  	(1434, 441, 469, '2003-01-13 00:00:00', 4, NULL, NULL),
  	(1439, 474, 501, '2003-07-04 00:00:00', 4, NULL, NULL),
  	(1441, 357, 514, '2002-01-07 00:00:00', 4, NULL, NULL),
  	(1441, 241, 142, '2003-09-16 00:00:00', 4, NULL, NULL),
  	(1450, 646, 154, '2003-01-21 00:00:00', 4, NULL, NULL),
  	(1451, 367, 195, '2003-04-11 00:00:00', 4, NULL, NULL),
  	(1457, 429, 244, '2003-03-03 00:00:00', 5, NULL, NULL),
  	(1458, 430, 277, '2003-01-14 00:00:00', 5, NULL, NULL),
  	(1490, 356, 289, '2003-08-27 00:00:00', 5, NULL, NULL),
  	(1470, 371, 367, '2002-11-29 00:00:00', 5, NULL, NULL),
  	(1471, 349, 379, '2003-04-23 00:00:00', 5, NULL, NULL),
  	(1476, 362, 411, '2002-12-10 00:00:00', 5, NULL, NULL),
  	(1483, 594, 456, '2002-09-24 00:00:00', 5, NULL, NULL),
  	(1484, 441, 469, '2003-05-19 00:00:00', 5, NULL, NULL),
  	(1491, 357, 514, '2003-08-20 00:00:00', 2, NULL, NULL),
  	(1498, 241, 142, '2003-07-04 00:00:00', 2, NULL, NULL),
  	(1503, 646, 154, '2002-11-04 00:00:00', 2, NULL, NULL),
  	(1504, 367, 195, '2003-04-24 00:00:00', 2, NULL, NULL),
  	(1152, 356, 289, '2003-09-16 00:00:00', 3, NULL, NULL),
  	(1173, 146, 326, '2003-02-17 00:00:00', 3, NULL, NULL),
  	(1202, 371, 367, '2003-01-17 00:00:00', 3, NULL, NULL),
  	(1370, 474, 501, '2003-09-16 00:00:00', 3, NULL, NULL),
  	(1414, 241, 142, '2002-09-11 00:00:00', 3, NULL, NULL),
  	(1439, 646, 154, '2003-01-28 00:00:00', 3, NULL, NULL),
  	(1496, 429, 244, '2003-02-14 00:00:00', 4, NULL, NULL),
  	(1202, 146, 326, '2003-01-23 00:00:00', 4, NULL, NULL),
  	(1223, 371, 367, '2002-09-20 00:00:00', 4, NULL, NULL),
  	(1249, 349, 379, '2003-08-22 00:00:00', 5, NULL, NULL),
  	(1272, 362, 411, '2003-01-29 00:00:00', 5, NULL, NULL),
  	(1324, 594, 456, '2002-05-10 00:00:00', 5, NULL, NULL),
  	(1349, 441, 469, '2003-09-22 00:00:00', 3, NULL, NULL),
  	(1393, 357, 514, '2003-01-17 00:00:00', 3, NULL, NULL),
  	(1450, 262, 154, '2002-03-06 00:00:00', 3, NULL, NULL),
  	(1471, 284, 232, '2003-09-16 00:00:00', 3, NULL, NULL),
  	(1496, 343, 244, '2002-09-18 00:00:00', 3, NULL, NULL),
  	(1147, 238, 277, '2002-11-22 00:00:00', 3, NULL, NULL),
  	(1180, 194, 330, '2003-10-14 00:00:00', 3, NULL, NULL),
  	(1202, 103, 367, '2003-03-06 00:00:00', 3, NULL, NULL),
  	(1235, 419, 379, '2002-09-05 00:00:00', 3, NULL, NULL),
  	(1253, 98, 411, '2003-06-13 00:00:00', 3, NULL, NULL),
  	(1267, 362, 456, '2003-04-16 00:00:00', 3, NULL, NULL),
  	(1286, 346, 469, '2002-11-26 00:00:00', 4, NULL, NULL),
  	(1312, 241, 501, '2003-03-06 00:00:00', 4, NULL, NULL),
  	(1324, 646, 514, '2003-10-07 00:00:00', 4, NULL, NULL),
  	(1343, 264, 142, '2003-01-10 00:00:00', 4, NULL, NULL),
  	(1357, 262, 154, '2003-03-17 00:00:00', 4, NULL, NULL),
  	(1388, 284, 232, '2003-09-02 00:00:00', 4, NULL, NULL),
  	(1439, 583, 289, '2002-06-03 00:00:00', 2, NULL, NULL),
  	(1464, 194, 330, '2002-01-18 00:00:00', 2, NULL, NULL),
  	(1483, 103, 367, '2003-09-19 00:00:00', 2, NULL, NULL),
  	(1498, 419, 379, '2003-05-23 00:00:00', 2, NULL, NULL),
  	(1132, 98, 411, '2003-09-26 00:00:00', 3, NULL, NULL),
  	(1165, 362, 456, '2003-09-22 00:00:00', 3, NULL, NULL),
  	(1180, 346, 469, '2003-03-18 00:00:00', 3, NULL, NULL),
  	(1202, 241, 501, '2003-06-03 00:00:00', 3, NULL, NULL),
  	(1217, 646, 514, '2003-12-11 00:00:00', 3, NULL, NULL),
  	(1253, 264, 142, '2002-09-10 00:00:00', 4, NULL, NULL),
  	(1267, 262, 154, '2002-12-16 00:00:00', 4, NULL, NULL),
  	(1286, 284, 232, '2003-11-03 00:00:00', 4, NULL, NULL),
  	(1294, 343, 244, '2002-12-12 00:00:00', 2, NULL, NULL),
  	(1324, 238, 277, '2003-09-18 00:00:00', 2, NULL, NULL),
  	(1343, 583, 289, '2003-03-27 00:00:00', 2, NULL, NULL),
  	(1376, 103, 367, '2003-09-12 00:00:00', 2, NULL, NULL),
  	(1406, 419, 379, '2003-09-11 00:00:00', 2, NULL, NULL),
  	(1439, 362, 456, '2002-11-20 00:00:00', 2, NULL, NULL),
  	(1450, 346, 469, '2003-10-21 00:00:00', 2, NULL, NULL),
  	(1483, 241, 501, '2002-12-06 00:00:00', 2, NULL, NULL),
  	(1498, 646, 514, '2003-04-10 00:00:00', 2, NULL, NULL),
  	(1132, 264, 142, '2002-10-03 00:00:00', 2, NULL, NULL),
  	(1147, 262, 154, '2002-10-17 00:00:00', 2, NULL, NULL),
  	(1180, 284, 232, '2003-02-18 00:00:00', 2, NULL, NULL),
  	(1202, 343, 244, '2003-03-28 00:00:00', 2, NULL, NULL),
  	(1217, 238, 277, '2003-02-10 00:00:00', 3, NULL, NULL),
  	(1235, 583, 289, '2002-10-14 00:00:00', 3, NULL, NULL),
  	(1286, 103, 367, '2003-05-16 00:00:00', 3, NULL, NULL),
  	(1294, 419, 379, '2002-12-02 00:00:00', 3, NULL, NULL),
  	(1312, 98, 411, '2003-06-25 00:00:00', 3, NULL, NULL),
  	(1343, 362, 456, '2003-02-04 00:00:00', 3, NULL, NULL),
  	(1357, 346, 469, '2003-10-07 00:00:00', 3, NULL, NULL),
  	(1388, 646, 514, '2003-11-04 00:00:00', 3, NULL, NULL),
  	(1421, 264, 142, '2003-02-24 00:00:00', 3, NULL, NULL),
  	(1439, 262, 154, '2002-11-19 00:00:00', 3, NULL, NULL),
  	(1450, 284, 232, '2003-08-25 00:00:00', 3, NULL, NULL),
  	(1464, 343, 244, '2003-01-07 00:00:00', 3, NULL, NULL),
  	(1145, 583, 289, '2003-10-27 00:00:00', 3, NULL, NULL),
  	(1222, 103, 367, '2003-07-01 00:00:00', 3, NULL, NULL),
  	(1300, 419, 379, '2003-04-22 00:00:00', 4, NULL, NULL),
  	(1336, 98, 411, '2003-04-18 00:00:00', 4, NULL, NULL),
  	(1406, 346, 469, '2002-10-31 00:00:00', 4, NULL, NULL),
  	(1484, 646, 514, '2003-07-01 00:00:00', 4, NULL, NULL),
  	(1145, 99, 122, '2003-04-22 00:00:00', 4, NULL, NULL),
  	(1180, 609, 146, '2003-01-24 00:00:00', 4, NULL, NULL),
  	(1300, 370, 232, '2003-03-27 00:00:00', 4, NULL, NULL),
  	(1336, 259, 244, '2003-07-01 00:00:00', 2, NULL, NULL),
  	(1370, 265, 277, '2003-04-23 00:00:00', 2, NULL, NULL),
  	(1441, 303, 289, '2003-02-04 00:00:00', 2, NULL, NULL),
  	(1450, 650, 334, '2003-10-10 00:00:00', 3, NULL, NULL),
  	(1484, 489, 371, '2003-09-10 00:00:00', 3, NULL, NULL),
  	(1145, 209, 391, '2003-02-04 00:00:00', 3, NULL, NULL),
  	(1222, 367, 420, '2002-12-27 00:00:00', 4, NULL, NULL),
  	(1259, 98, 456, '2003-04-10 00:00:00', 4, NULL, NULL),
  	(1300, 378, 469, '2003-05-15 00:00:00', 2, NULL, NULL),
  	(1336, 264, 501, '2003-08-15 00:00:00', 2, NULL, NULL),
  	(1406, 262, 514, '2003-09-04 00:00:00', 2, NULL, NULL),
  	(1450, 609, 146, '2003-02-07 00:00:00', 3, NULL, NULL),
  	(1145, 37, 166, '2003-08-29 00:00:00', 3, NULL, NULL),
  	(1180, 370, 232, '2003-07-04 00:00:00', 3, NULL, NULL),
  	(1259, 265, 277, '2003-06-05 00:00:00', 4, NULL, NULL),
  	(1167, 229, 122, '2002-08-23 00:00:00', 2, NULL, NULL),
  	(1210, 545, 481, '2002-10-22 00:00:00', 2, NULL, NULL),
  	(1272, 607, 191, '2003-01-14 00:00:00', 2, NULL, NULL),
  	(1312, 474, 142, '2003-06-05 00:00:00', 2, NULL, NULL),
  	(1369, 57, 256, '2002-12-30 00:00:00', 2, NULL, NULL),
  	(1426, 349, 379, '2003-08-22 00:00:00', 2, NULL, NULL),
  	(1464, 146, 326, '2002-12-17 00:00:00', 2, NULL, NULL),
  	(1490, 474, 501, '2003-04-10 00:00:00', 3, NULL, NULL),
  	(1127, 430, 277, '2002-11-27 00:00:00', 3, NULL, NULL),
  	(1306, 594, 456, '2003-05-20 00:00:00', 3, NULL, NULL),
  	(1471, 367, 195, '2003-06-24 00:00:00', 3, NULL, NULL),
  	(1421, 238, 277, '2003-06-06 00:00:00', 3, NULL, NULL),
  	(1267, 194, 330, '2003-04-02 00:00:00', 3, NULL, NULL),
  	(1376, 241, 501, '2002-10-09 00:00:00', 3, NULL, NULL),
  	(1498, 238, 277, '2003-05-30 00:00:00', 3, NULL, NULL),
  	(1370, 362, 456, '2003-05-01 00:00:00', 4, NULL, NULL),
  	(1434, 37, 166, '2003-06-20 00:00:00', 4, NULL, NULL),
  	(1393, 489, 371, '2003-06-03 00:00:00', 4, NULL, NULL),
  	(1120, 545, 122, '2003-08-25 00:00:00', 4, NULL, NULL),
  	(1125, 423, 150, '2003-01-07 00:00:00', 5, NULL, NULL),
  	(1127, 458, 166, '2002-12-30 00:00:00', 5, NULL, NULL),
  	(1172, 102, 232, '2002-06-21 00:00:00', 5, NULL, NULL),
  	(1139, 607, 281, '2002-12-10 00:00:00', 2, NULL, NULL),
  	(1140, 301, 301, '2002-09-10 00:00:00', 2, NULL, NULL),
  	(1145, 355, 334, '2003-06-03 00:00:00', 2, NULL, NULL),
  	(1230, 68, 371, '2002-12-13 00:00:00', 2, NULL, NULL),
  	(1152, 549, 391, '2002-03-26 00:00:00', 2, NULL, NULL),
  	(1153, 278, 436, '2003-09-11 00:00:00', 2, NULL, NULL),
  	(1160, 99, 481, '2002-12-02 00:00:00', 2, NULL, NULL),
  	(1331, 609, 505, '2002-09-19 00:00:00', 2, NULL, NULL),
  	(1172, 305, 154, '2003-09-03 00:00:00', 2, NULL, NULL),
  	(1173, 253, 166, '2002-06-28 00:00:00', 2, NULL, NULL),
  	(1178, 515, 236, '2002-10-07 00:00:00', 2, NULL, NULL),
  	(1386, 459, 256, '2002-10-30 00:00:00', 2, NULL, NULL),
  	(1189, 367, 285, '2003-08-27 00:00:00', 2, NULL, NULL),
  	(1190, 453, 301, '2003-01-14 00:00:00', 3, NULL, NULL),
  	(1441, 420, 391, '2002-11-08 00:00:00', 3, NULL, NULL),
  	(1204, 576, 436, '2003-03-24 00:00:00', 3, NULL, NULL),
  	(1209, 267, 465, '2002-09-12 00:00:00', 3, NULL, NULL),
  	(1216, 423, 509, '2002-11-25 00:00:00', 3, NULL, NULL),
  	(1490, 229, 122, '2002-12-11 00:00:00', 3, NULL, NULL),
  	(1222, 305, 154, '2003-01-13 00:00:00', 3, NULL, NULL),
  	(1223, 253, 166, '2003-01-07 00:00:00', 3, NULL, NULL),
  	(1229, 515, 236, '2003-04-22 00:00:00', 3, NULL, NULL),
  	(1230, 459, 256, '2003-04-18 00:00:00', 3, NULL, NULL),
  	(1237, 453, 301, '2002-09-19 00:00:00', 3, NULL, NULL),
  	(1242, 525, 334, '2003-08-27 00:00:00', 3, NULL, NULL),
  	(1243, 106, 375, '2003-09-05 00:00:00', 3, NULL, NULL),
  	(1249, 420, 391, '2003-09-04 00:00:00', 3, NULL, NULL),
  	(1254, 267, 465, '2003-09-10 00:00:00', 4, NULL, NULL),
  	(1259, 545, 481, '2003-06-27 00:00:00', 4, NULL, NULL),
  	(1261, 423, 509, '2003-01-24 00:00:00', 4, NULL, NULL),
  	(1266, 474, 142, '2003-04-15 00:00:00', 4, NULL, NULL),
  	(1222, 357, 154, '2003-10-21 00:00:00', 4, NULL, NULL),
  	(1274, 39, 236, '2002-10-25 00:00:00', 4, NULL, NULL),
  	(1279, 57, 256, '2003-09-12 00:00:00', 4, NULL, NULL),
  	(1280, 304, 289, '2002-10-22 00:00:00', 2, NULL, NULL),
  	(1266, 286, 326, '2003-09-02 00:00:00', 2, NULL, NULL),
  	(1287, 288, 367, '2003-02-04 00:00:00', 2, NULL, NULL),
  	(1292, 658, 379, '2003-04-17 00:00:00', 2, NULL, NULL),
  	(1294, 594, 411, '2003-06-19 00:00:00', 2, NULL, NULL),
  	(1299, 450, 436, '2003-08-26 00:00:00', 2, NULL, NULL),
  	(1306, 229, 481, '2002-09-30 00:00:00', 2, NULL, NULL),
  	(1314, 357, 154, '2003-04-21 00:00:00', 2, NULL, NULL),
  	(1351, 607, 191, '2003-05-06 00:00:00', 2, NULL, NULL),
  	(1317, 39, 236, '2003-09-16 00:00:00', 2, NULL, NULL),
  	(1323, 57, 256, '2003-01-23 00:00:00', 2, NULL, NULL),
  	(1324, 304, 289, '2003-02-11 00:00:00', 2, NULL, NULL),
  	(1329, 286, 326, '2003-04-01 00:00:00', 2, NULL, NULL),
  	(1393, 288, 367, '2003-05-16 00:00:00', 2, NULL, NULL),
  	(1336, 658, 379, '2003-05-09 00:00:00', 2, NULL, NULL),
  	(1337, 594, 411, '2003-05-26 00:00:00', 2, NULL, NULL),
  	(1343, 450, 436, '2002-07-05 00:00:00', 2, NULL, NULL),
  	(1344, 312, 465, '2003-09-02 00:00:00', 3, NULL, NULL),
  	(1434, 229, 481, '2002-12-26 00:00:00', 3, NULL, NULL),
  	(1351, 305, 514, '2003-09-09 00:00:00', 3, NULL, NULL),
  	(1356, 474, 142, '2003-04-30 00:00:00', 3, NULL, NULL),
  	(1357, 357, 154, '2002-05-20 00:00:00', 3, NULL, NULL),
  	(1363, 607, 191, '2003-09-12 00:00:00', 3, NULL, NULL),
  	(1483, 39, 236, '2003-01-03 00:00:00', 3, NULL, NULL),
  	(1370, 304, 289, '2003-06-12 00:00:00', 3, NULL, NULL),
  	(1376, 286, 326, '2002-11-29 00:00:00', 3, NULL, NULL),
  	(1377, 288, 367, '2003-04-10 00:00:00', 3, NULL, NULL),
  	(1381, 594, 411, '2003-07-04 00:00:00', 3, NULL, NULL),
  	(1386, 450, 436, '2003-05-23 00:00:00', 3, NULL, NULL),
  	(1388, 312, 465, '2003-03-14 00:00:00', 3, NULL, NULL),
  	(1393, 229, 481, '2003-03-10 00:00:00', 3, NULL, NULL),
  	(1230, 305, 514, '2002-10-11 00:00:00', 3, NULL, NULL),
  	(1401, 646, 154, '2003-01-22 00:00:00', 3, NULL, NULL),
  	(1406, 367, 195, '2003-05-23 00:00:00', 3, NULL, NULL),
  	(1408, 429, 244, '2003-03-12 00:00:00', 3, NULL, NULL),
  	(1331, 430, 277, '2002-12-17 00:00:00', 3, NULL, NULL),
  	(1419, 146, 326, '2003-02-18 00:00:00', 4, NULL, NULL),
  	(1421, 371, 367, '2003-10-08 00:00:00', 4, NULL, NULL),
  	(1386, 362, 411, '2003-01-31 00:00:00', 4, NULL, NULL),
  	(1433, 594, 456, '2003-05-27 00:00:00', 4, NULL, NULL),
  	(1434, 441, 469, '2003-01-13 00:00:00', 4, NULL, NULL),
  	(1439, 474, 501, '2003-07-04 00:00:00', 4, NULL, NULL),
  	(1441, 357, 514, '2002-01-07 00:00:00', 4, NULL, NULL),
  	(1441, 241, 142, '2003-09-16 00:00:00', 4, NULL, NULL),
  	(1450, 646, 154, '2003-01-21 00:00:00', 4, NULL, NULL),
  	(1451, 367, 195, '2003-04-11 00:00:00', 4, NULL, NULL),
  	(1457, 429, 244, '2003-03-03 00:00:00', 5, NULL, NULL),
  	(1458, 430, 277, '2003-01-14 00:00:00', 5, NULL, NULL),
  	(1490, 356, 289, '2003-08-27 00:00:00', 5, NULL, NULL),
  	(1470, 371, 367, '2002-11-29 00:00:00', 5, NULL, NULL),
  	(1471, 349, 379, '2003-04-23 00:00:00', 5, NULL, NULL),
  	(1476, 362, 411, '2002-12-10 00:00:00', 5, NULL, NULL),
  	(1483, 594, 456, '2002-09-24 00:00:00', 5, NULL, NULL),
  	(1484, 441, 469, '2003-05-19 00:00:00', 5, NULL, NULL),
  	(1491, 357, 514, '2003-08-20 00:00:00', 2, NULL, NULL),
  	(1498, 241, 142, '2003-07-04 00:00:00', 2, NULL, NULL),
  	(1503, 646, 154, '2002-11-04 00:00:00', 2, NULL, NULL),
  	(1504, 367, 195, '2003-04-24 00:00:00', 2, NULL, NULL),
  	(1152, 356, 289, '2003-09-16 00:00:00', 3, NULL, NULL),
  	(1173, 146, 326, '2003-02-17 00:00:00', 3, NULL, NULL),
  	(1202, 371, 367, '2003-01-17 00:00:00', 3, NULL, NULL),
  	(1370, 474, 501, '2003-09-16 00:00:00', 3, NULL, NULL),
  	(1414, 241, 142, '2002-09-11 00:00:00', 3, NULL, NULL),
  	(1439, 646, 154, '2003-01-28 00:00:00', 3, NULL, NULL),
  	(1496, 429, 244, '2003-02-14 00:00:00', 4, NULL, NULL),
  	(1202, 146, 326, '2003-01-23 00:00:00', 4, NULL, NULL),
  	(1223, 371, 367, '2002-09-20 00:00:00', 4, NULL, NULL),
  	(1249, 349, 379, '2003-08-22 00:00:00', 5, NULL, NULL),
  	(1272, 362, 411, '2003-01-29 00:00:00', 5, NULL, NULL),
  	(1324, 594, 456, '2002-05-10 00:00:00', 5, NULL, NULL),
  	(1349, 441, 469, '2003-09-22 00:00:00', 3, NULL, NULL),
  	(1393, 357, 514, '2003-01-17 00:00:00', 3, NULL, NULL),
  	(1450, 262, 154, '2002-03-06 00:00:00', 3, NULL, NULL),
  	(1471, 284, 232, '2003-09-16 00:00:00', 3, NULL, NULL),
  	(1496, 343, 244, '2002-09-18 00:00:00', 3, NULL, NULL),
  	(1147, 238, 277, '2002-11-22 00:00:00', 3, NULL, NULL),
  	(1180, 194, 330, '2003-10-14 00:00:00', 3, NULL, NULL),
  	(1202, 103, 367, '2003-03-06 00:00:00', 3, NULL, NULL),
  	(1235, 419, 379, '2002-09-05 00:00:00', 3, NULL, NULL),
  	(1253, 98, 411, '2003-06-13 00:00:00', 3, NULL, NULL),
  	(1267, 362, 456, '2003-04-16 00:00:00', 3, NULL, NULL),
  	(1286, 346, 469, '2002-11-26 00:00:00', 4, NULL, NULL),
  	(1312, 241, 501, '2003-03-06 00:00:00', 4, NULL, NULL),
  	(1324, 646, 514, '2003-10-07 00:00:00', 4, NULL, NULL),
  	(1343, 264, 142, '2003-01-10 00:00:00', 4, NULL, NULL),
  	(1357, 262, 154, '2003-03-17 00:00:00', 4, NULL, NULL),
  	(1388, 284, 232, '2003-09-02 00:00:00', 4, NULL, NULL),
  	(1439, 583, 289, '2002-06-03 00:00:00', 2, NULL, NULL),
  	(1464, 194, 330, '2002-01-18 00:00:00', 2, NULL, NULL),
  	(1483, 103, 367, '2003-09-19 00:00:00', 2, NULL, NULL),
  	(1498, 419, 379, '2003-05-23 00:00:00', 2, NULL, NULL),
  	(1132, 98, 411, '2003-09-26 00:00:00', 3, NULL, NULL),
  	(1165, 362, 456, '2003-09-22 00:00:00', 3, NULL, NULL),
  	(1180, 346, 469, '2003-03-18 00:00:00', 3, NULL, NULL),
  	(1202, 241, 501, '2003-06-03 00:00:00', 3, NULL, NULL),
  	(1217, 646, 514, '2003-12-11 00:00:00', 3, NULL, NULL),
  	(1253, 264, 142, '2002-09-10 00:00:00', 4, NULL, NULL),
  	(1267, 262, 154, '2002-12-16 00:00:00', 4, NULL, NULL),
  	(1286, 284, 232, '2003-11-03 00:00:00', 4, NULL, NULL),
  	(1294, 343, 244, '2002-12-12 00:00:00', 2, NULL, NULL),
  	(1324, 238, 277, '2003-09-18 00:00:00', 2, NULL, NULL),
  	(1343, 583, 289, '2003-03-27 00:00:00', 2, NULL, NULL),
  	(1376, 103, 367, '2003-09-12 00:00:00', 2, NULL, NULL),
  	(1406, 419, 379, '2003-09-11 00:00:00', 2, NULL, NULL),
  	(1439, 362, 456, '2002-11-20 00:00:00', 2, NULL, NULL),
  	(1450, 346, 469, '2003-10-21 00:00:00', 2, NULL, NULL),
  	(1483, 241, 501, '2002-12-06 00:00:00', 2, NULL, NULL),
  	(1498, 646, 514, '2003-04-10 00:00:00', 2, NULL, NULL),
  	(1132, 264, 142, '2002-10-03 00:00:00', 2, NULL, NULL),
  	(1147, 262, 154, '2002-10-17 00:00:00', 2, NULL, NULL),
  	(1180, 284, 232, '2003-02-18 00:00:00', 2, NULL, NULL),
  	(1202, 343, 244, '2003-03-28 00:00:00', 2, NULL, NULL),
  	(1217, 238, 277, '2003-02-10 00:00:00', 3, NULL, NULL),
  	(1235, 583, 289, '2002-10-14 00:00:00', 3, NULL, NULL),
  	(1286, 103, 367, '2003-05-16 00:00:00', 3, NULL, NULL),
  	(1294, 419, 379, '2002-12-02 00:00:00', 3, NULL, NULL),
  	(1312, 98, 411, '2003-06-25 00:00:00', 3, NULL, NULL),
  	(1343, 362, 456, '2003-02-04 00:00:00', 3, NULL, NULL),
  	(1357, 346, 469, '2003-10-07 00:00:00', 3, NULL, NULL),
  	(1388, 646, 514, '2003-11-04 00:00:00', 3, NULL, NULL),
  	(1421, 264, 142, '2003-02-24 00:00:00', 3, NULL, NULL),
  	(1439, 262, 154, '2002-11-19 00:00:00', 3, NULL, NULL),
  	(1450, 284, 232, '2003-08-25 00:00:00', 3, NULL, NULL),
  	(1464, 343, 244, '2003-01-07 00:00:00', 3, NULL, NULL),
  	(1145, 583, 289, '2003-10-27 00:00:00', 3, NULL, NULL),
  	(1222, 103, 367, '2003-07-01 00:00:00', 3, NULL, NULL),
  	(1300, 419, 379, '2003-04-22 00:00:00', 4, NULL, NULL),
  	(1336, 98, 411, '2003-04-18 00:00:00', 4, NULL, NULL),
  	(1406, 346, 469, '2002-10-31 00:00:00', 4, NULL, NULL),
  	(1484, 646, 514, '2003-07-01 00:00:00', 4, NULL, NULL),
  	(1145, 99, 122, '2003-04-22 00:00:00', 4, NULL, NULL),
  	(1180, 609, 146, '2003-01-24 00:00:00', 4, NULL, NULL),
  	(1300, 370, 232, '2003-03-27 00:00:00', 4, NULL, NULL),
  	(1336, 259, 244, '2003-07-01 00:00:00', 2, NULL, NULL),
  	(1370, 265, 277, '2003-04-23 00:00:00', 2, NULL, NULL),
  	(1441, 303, 289, '2003-02-04 00:00:00', 2, NULL, NULL),
  	(1450, 650, 334, '2003-10-10 00:00:00', 3, NULL, NULL),
  	(1484, 489, 371, '2003-09-10 00:00:00', 3, NULL, NULL),
  	(1145, 209, 391, '2003-02-04 00:00:00', 3, NULL, NULL),
  	(1222, 367, 420, '2002-12-27 00:00:00', 4, NULL, NULL),
  	(1259, 98, 456, '2003-04-10 00:00:00', 4, NULL, NULL),
  	(1300, 378, 469, '2003-05-15 00:00:00', 2, NULL, NULL),
  	(1336, 264, 501, '2003-08-15 00:00:00', 2, NULL, NULL),
  	(1406, 262, 514, '2003-09-04 00:00:00', 2, NULL, NULL),
  	(1450, 609, 146, '2003-02-07 00:00:00', 3, NULL, NULL),
  	(1145, 37, 166, '2003-08-29 00:00:00', 3, NULL, NULL),
  	(1180, 370, 232, '2003-07-04 00:00:00', 3, NULL, NULL),
  	(1259, 265, 277, '2003-06-05 00:00:00', 4, NULL, NULL),
  	(1336, 303, 289, '2002-11-01 00:00:00', 4, NULL, NULL),
  	(1370, 650, 334, '2003-06-27 00:00:00', 2, NULL, NULL),
  	(1406, 489, 371, '2003-01-03 00:00:00', 2, NULL, NULL),
  	(1441, 209, 391, '2003-08-26 00:00:00', 3, NULL, NULL),
  	(1484, 367, 420, '2003-09-16 00:00:00', 3, NULL, NULL),
  	(1173, 378, 469, '2003-06-02 00:00:00', 3, NULL, NULL),
  	(1222, 264, 501, '2003-04-11 00:00:00', 4, NULL, NULL),
  	(1351, 99, 122, '2003-10-24 00:00:00', 4, NULL, NULL),
  	(1393, 609, 146, '2003-03-31 00:00:00', 5, NULL, NULL),
  	(1173, 259, 244, '2002-08-23 00:00:00', 2, NULL, NULL),
  	(1222, 265, 277, '2003-06-03 00:00:00', 2, NULL, NULL),
  	(1266, 303, 289, '2003-03-05 00:00:00', 2, NULL, NULL),
  	(1351, 650, 334, '2003-09-23 00:00:00', 2, NULL, NULL),
  	(1434, 209, 391, '2002-10-23 00:00:00', 2, NULL, NULL),
  	(1483, 367, 420, '2003-03-11 00:00:00', 2, NULL, NULL),
  	(1173, 98, 456, '2003-09-05 00:00:00', 2, NULL, NULL),
  	(1222, 378, 469, '2003-10-13 00:00:00', 2, NULL, NULL),
  	(1266, 264, 501, '2003-09-16 00:00:00', 2, NULL, NULL),
  	(1434, 609, 146, '2003-03-24 00:00:00', 2, NULL, NULL),
  	(1483, 37, 166, '2003-09-10 00:00:00', 2, NULL, NULL),
  	(1132, 370, 232, '2003-04-23 00:00:00', 3, NULL, NULL),
  	(1222, 259, 244, '2003-06-12 00:00:00', 3, NULL, NULL),
  	(1266, 265, 277, '2003-08-27 00:00:00', 3, NULL, NULL),
  	(1312, 303, 289, '2002-12-27 00:00:00', 3, NULL, NULL),
  	(1434, 489, 371, '2002-05-16 00:00:00', 3, NULL, NULL),
  	(1483, 209, 391, '2003-09-03 00:00:00', 3, NULL, NULL),
  	(1132, 367, 420, '2003-04-07 00:00:00', 3, NULL, NULL),
  	(1266, 378, 469, '2002-09-25 00:00:00', 3, NULL, NULL),
  	(1351, 262, 514, '2003-01-28 00:00:00', 3, NULL, NULL),
  	(1393, 99, 122, '2003-11-25 00:00:00', 3, NULL, NULL),
  	(1483, 609, 146, '2003-04-17 00:00:00', 3, NULL, NULL),
  	(1172, 37, 166, '2002-09-12 00:00:00', 3, NULL, NULL),
  	(1230, 370, 232, '2003-08-29 00:00:00', 3, NULL, NULL),
  	(1490, 303, 289, '2003-04-17 00:00:00', 3, NULL, NULL),
  	(1172, 650, 334, '2003-11-18 00:00:00', 3, NULL, NULL),
  	(1230, 489, 371, '2003-02-21 00:00:00', 3, NULL, NULL),
  	(1441, 367, 420, '2003-09-09 00:00:00', 4, NULL, NULL),
  	(1490, 98, 456, '2003-04-01 00:00:00', 4, NULL, NULL),
  	(1172, 378, 469, '2002-04-26 00:00:00', 4, NULL, NULL),
  	(1386, 262, 514, '2002-02-25 00:00:00', 4, NULL, NULL),
  	(1441, 99, 122, '2003-10-08 00:00:00', 4, NULL, NULL),
  	(1490, 609, 146, '2003-05-23 00:00:00', 4, NULL, NULL),
  	(1230, 37, 166, '2003-09-26 00:00:00', 4, NULL, NULL),
  	(1331, 370, 232, '2003-10-15 00:00:00', 4, NULL, NULL),
  	(1386, 259, 244, '2003-01-02 00:00:00', 4, NULL, NULL),
  	(1441, 265, 277, '2003-02-27 00:00:00', 5, NULL, NULL),
  	(1230, 650, 334, '2003-01-24 00:00:00', 5, NULL, NULL),
  	(1331, 489, 371, '2003-10-21 00:00:00', 5, NULL, NULL),
  	(1386, 209, 391, '2003-05-02 00:00:00', 2, NULL, NULL),
  	(1490, 367, 420, '2003-01-01 00:00:00', 2, NULL, NULL),
  	(1172, 98, 456, '2003-10-06 00:00:00', 2, NULL, NULL),
  	(1230, 378, 469, '2002-09-19 00:00:00', 3, NULL, NULL),
  	(1331, 264, 501, '2003-08-28 00:00:00', 3, NULL, NULL),
  	(1133, 104, 256, '2003-05-02 00:00:00', 4, NULL, NULL),
  	(1173, 576, 436, '2003-10-21 00:00:00', 5, NULL, NULL),
  	(1307, 305, 514, '2003-06-05 00:00:00', 2, NULL, NULL),
  	(1414, 356, 289, '2003-11-26 00:00:00', 2, NULL, NULL),
  	(1324, 441, 469, '2003-05-20 00:00:00', 3, NULL, NULL),
  	(1172, 303, 289, '2003-09-05 00:00:00', 3, NULL, NULL),
  	(1196, 525, 334, '2003-11-12 00:00:00', 4, NULL, NULL),
  	(1439, 264, 142, '2004-02-10 00:00:00', 2, NULL, NULL),
  	(1406, 343, 244, '2003-10-28 00:00:00', 2, NULL, NULL),
  	(1357, 194, 330, '2003-10-30 00:00:00', 3, NULL, NULL),
  	(1331, 259, 244, '2003-10-28 00:00:00', 3, NULL, NULL),
  	(1400, 241, 142, '2003-07-02 00:00:00', 3, NULL, NULL),
  	(1421, 98, 411, '2003-06-06 00:00:00', 4, NULL, NULL),
  	(1312, 264, 501, '2003-10-24 00:00:00', 5, NULL, NULL),
  	(1312, 312, 465, '2003-05-23 00:00:00', 2, NULL, NULL),
  	(1197, 106, 375, '2003-08-22 00:00:00', 2, NULL, NULL),
  	(1513, 429, 244, '2003-09-25 00:00:00', 3, NULL, NULL),
  	(1450, 241, 501, '2003-06-23 00:00:00', 3, NULL, NULL),
  	(1312, 262, 514, '2004-01-09 00:00:00', 3, NULL, NULL),
  	(1441, 262, 514, '2003-04-10 00:00:00', 4, NULL, NULL),
  	(1172, 658, 379, '2003-10-13 00:00:00', 5, NULL, NULL),
  	(1165, 583, 289, '2003-11-19 00:00:00', 2, NULL, NULL),
  	(1259, 37, 166, '2003-10-21 00:00:00', 2, NULL, NULL),
  	(1159, 169, 460, '2003-09-24 00:00:00', 3, NULL, NULL),
  	(1127, 458, 166, '2002-01-15 00:00:00', 1, NULL, NULL),
  	(1230, 68, 371, '2002-08-27 00:00:00', 1, NULL, NULL),
  	(1190, 453, 301, '2002-09-17 00:00:00', 1, NULL, NULL),
  	(1230, 459, 256, '2002-11-22 00:00:00', 1, NULL, NULL),
  	(1173, 576, 436, '2002-10-02 00:00:00', 1, NULL, NULL),
  	(1292, 658, 379, '2003-04-07 00:00:00', 1, NULL, NULL),
  	(1329, 286, 326, '2002-11-04 00:00:00', 1, NULL, NULL),
  	(1434, 229, 481, '2002-09-04 00:00:00', 1, NULL, NULL),
  	(1386, 450, 436, '2003-05-19 00:00:00', 1, NULL, NULL),
  	(1406, 367, 195, '2002-12-12 00:00:00', 1, NULL, NULL),
  	(1441, 241, 142, '2002-10-21 00:00:00', 1, NULL, NULL),
  	(1249, 349, 379, '2002-12-05 00:00:00', 1, NULL, NULL),
  	(1439, 264, 142, '2003-02-24 00:00:00', 1, NULL, NULL),
  	(1180, 194, 330, '2003-01-15 00:00:00', 1, NULL, NULL),
  	(1312, 241, 501, '2002-11-28 00:00:00', 1, NULL, NULL),
  	(1165, 362, 456, '2002-10-14 00:00:00', 1, NULL, NULL),
  	(1286, 284, 232, '2003-03-07 00:00:00', 1, NULL, NULL),
  	(1406, 419, 379, '2002-10-24 00:00:00', 1, NULL, NULL),
  	(1132, 264, 142, '2002-09-12 00:00:00', 1, NULL, NULL),
  	(1259, 37, 166, '2002-10-18 00:00:00', 1, NULL, NULL),
  	(1484, 489, 371, '2002-12-17 00:00:00', 1, NULL, NULL),
  	(1406, 262, 514, '2003-04-07 00:00:00', 1, NULL, NULL),
  	(1259, 265, 277, '2002-09-25 00:00:00', 1, NULL, NULL),
  	(1132, 98, 456, '2002-04-09 00:00:00', 1, NULL, NULL),
  	(1132, 370, 232, '2002-09-06 00:00:00', 1, NULL, NULL),
  	(1483, 209, 391, '2002-09-04 00:00:00', 1, NULL, NULL),
  	(1393, 99, 122, '2003-06-06 00:00:00', 1, NULL, NULL),
  	(1490, 303, 289, '2002-04-12 00:00:00', 1, NULL, NULL),
  	(1172, 378, 469, '2002-01-14 00:00:00', 1, NULL, NULL),
  	(1331, 370, 232, '2003-07-08 00:00:00', 1, NULL, NULL),
  	(1386, 209, 391, '2002-08-23 00:00:00', 1, NULL, NULL),
  	(1133, 104, 256, '2002-10-18 00:00:00', 1, NULL, NULL),
  	(1159, 169, 460, '2003-05-26 00:00:00', 1, NULL, NULL),
  	(1167, 229, 122, '2002-01-18 00:00:00', 1, NULL, NULL),
  	(1196, 525, 334, '2002-12-05 00:00:00', 1, NULL, NULL),
  	(1197, 106, 375, '2002-07-02 00:00:00', 1, NULL, NULL),
  	(1210, 545, 481, '2002-08-19 00:00:00', 1, NULL, NULL),
  	(1132, 367, 285, '2002-08-23 00:00:00', 1, NULL, NULL),
  	(1173, 576, 436, '2003-04-03 00:00:00', 1, NULL, NULL),
  	(1272, 607, 191, '2002-08-23 00:00:00', 1, NULL, NULL),
  	(1312, 312, 465, '2003-03-07 00:00:00', 1, NULL, NULL),
  	(1307, 305, 514, '2003-01-20 00:00:00', 1, NULL, NULL),
  	(1312, 474, 142, '2003-04-15 00:00:00', 1, NULL, NULL),
  	(1369, 57, 256, '2002-09-27 00:00:00', 1, NULL, NULL),
  	(1172, 658, 379, '2003-09-18 00:00:00', 1, NULL, NULL),
  	(1400, 241, 142, '2002-09-24 00:00:00', 1, NULL, NULL),
  	(1414, 356, 289, '2003-04-10 00:00:00', 1, NULL, NULL),
  	(1426, 349, 379, '2002-12-06 00:00:00', 1, NULL, NULL),
  	(1464, 146, 326, '2002-01-07 00:00:00', 1, NULL, NULL),
  	(1490, 474, 501, '2002-11-25 00:00:00', 1, NULL, NULL),
  	(1513, 429, 244, '2003-03-04 00:00:00', 1, NULL, NULL),
  	(1127, 430, 277, '2002-10-15 00:00:00', 1, NULL, NULL),
  	(1249, 349, 379, '2002-12-31 00:00:00', 1, NULL, NULL),
  	(1272, 362, 411, '2002-06-07 00:00:00', 1, NULL, NULL),
  	(1306, 594, 456, '2003-04-22 00:00:00', 1, NULL, NULL),
  	(1324, 441, 469, '2003-01-22 00:00:00', 1, NULL, NULL),
  	(1393, 357, 514, '2002-11-18 00:00:00', 1, NULL, NULL),
  	(1471, 367, 195, '2003-02-21 00:00:00', 1, NULL, NULL),
  	(1127, 430, 277, '2002-09-11 00:00:00', 1, NULL, NULL),
  	(1152, 356, 289, '2002-12-04 00:00:00', 1, NULL, NULL),
  	(1370, 474, 501, '2003-08-15 00:00:00', 1, NULL, NULL),
  	(1439, 264, 142, '2002-11-04 00:00:00', 1, NULL, NULL),
  	(1165, 583, 289, '2002-12-17 00:00:00', 1, NULL, NULL),
  	(1406, 343, 244, '2003-02-18 00:00:00', 1, NULL, NULL),
  	(1421, 238, 277, '2002-03-15 00:00:00', 1, NULL, NULL),
  	(1357, 194, 330, '2003-06-06 00:00:00', 1, NULL, NULL),
  	(1421, 98, 411, '2003-04-28 00:00:00', 1, NULL, NULL),
  	(1267, 194, 330, '2003-01-24 00:00:00', 1, NULL, NULL),
  	(1376, 241, 501, '2002-08-14 00:00:00', 1, NULL, NULL),
  	(1498, 238, 277, '2003-05-19 00:00:00', 1, NULL, NULL),
  	(1180, 194, 330, '2003-08-26 00:00:00', 1, NULL, NULL),
  	(1370, 362, 456, '2002-11-20 00:00:00', 1, NULL, NULL),
  	(1450, 241, 501, '2003-03-04 00:00:00', 1, NULL, NULL),
  	(1259, 37, 166, '2003-05-19 00:00:00', 1, NULL, NULL),
  	(1441, 99, 122, '2002-09-17 00:00:00', 1, NULL, NULL),
  	(1222, 259, 244, '2002-10-30 00:00:00', 1, NULL, NULL),
  	(1132, 98, 456, '2002-12-13 00:00:00', 1, NULL, NULL),
  	(1312, 262, 514, '2002-11-22 00:00:00', 1, NULL, NULL),
  	(1434, 37, 166, '2003-02-28 00:00:00', 1, NULL, NULL),
  	(1132, 370, 232, '2003-02-11 00:00:00', 1, NULL, NULL),
  	(1393, 489, 371, '2002-12-30 00:00:00', 1, NULL, NULL),
  	(1312, 262, 514, '2003-01-23 00:00:00', 1, NULL, NULL),
  	(1393, 99, 122, '2003-09-22 00:00:00', 1, NULL, NULL),
  	(1351, 650, 334, '2002-09-20 00:00:00', 1, NULL, NULL),
  	(1173, 98, 456, '2003-01-24 00:00:00', 1, NULL, NULL),
  	(1312, 264, 501, '2003-01-03 00:00:00', 1, NULL, NULL),
  	(1331, 259, 244, '2003-05-28 00:00:00', 1, NULL, NULL),
  	(1441, 265, 277, '2003-01-07 00:00:00', 1, NULL, NULL),
  	(1386, 209, 391, '2003-04-28 00:00:00', 1, NULL, NULL),
  	(1331, 264, 501, '2002-08-15 00:00:00', 1, NULL, NULL),
  	(1172, 303, 289, '2002-09-10 00:00:00', 1, NULL, NULL),
  	(1441, 262, 514, '2002-12-17 00:00:00', 1, NULL, NULL),
  	(1196, 525, 334, '2003-09-16 00:00:00', 1, NULL, NULL),
  	(1363, 607, 191, '2002-12-27 00:00:00', 1, NULL, NULL),
  	(1471, 349, 379, '2003-01-13 00:00:00', 1, NULL, NULL),
  	(1439, 264, 142, '2002-11-12 00:00:00', 1, NULL, NULL),
  	(1406, 343, 244, '2002-11-26 00:00:00', 1, NULL, NULL),
  	(1357, 194, 330, '2003-03-28 00:00:00', 1, NULL, NULL),
  	(1312, 98, 411, '2003-05-05 00:00:00', 1, NULL, NULL),
  	(1450, 241, 501, '2003-03-20 00:00:00', 1, NULL, NULL),
  	(1441, 99, 122, '2002-11-21 00:00:00', 1, NULL, NULL),
  	(1434, 37, 166, '2003-03-03 00:00:00', 1, NULL, NULL),
  	(1483, 37, 166, '2003-06-23 00:00:00', 1, NULL, NULL),
  	(1331, 259, 244, '2003-01-09 00:00:00', 1, NULL, NULL),
  	(1133, 104, 256, '2003-03-12 00:00:00', 1, NULL, NULL),
  	(1173, 576, 436, '2003-01-27 00:00:00', 1, NULL, NULL),
  	(1307, 305, 514, '2002-10-30 00:00:00', 1, NULL, NULL),
  	(1363, 607, 191, '2003-04-10 00:00:00', 1, NULL, NULL),
  	(1414, 356, 289, '2003-05-23 00:00:00', 1, NULL, NULL),
  	(1471, 349, 379, '2002-09-19 00:00:00', 1, NULL, NULL),
  	(1324, 441, 469, '2002-12-24 00:00:00', 1, NULL, NULL),
  	(1312, 98, 411, '2002-09-17 00:00:00', 1, NULL, NULL),
  	(1450, 241, 501, '2003-01-20 00:00:00', 1, NULL, NULL),
  	(1441, 99, 122, '2003-08-20 00:00:00', 1, NULL, NULL),
  	(1434, 37, 166, '2002-09-06 00:00:00', 1, NULL, NULL),
  	(1483, 37, 166, '2003-04-18 00:00:00', 1, NULL, NULL),
  	(1172, 303, 289, '2003-03-28 00:00:00', 1, NULL, NULL),
  	(1197, 106, 375, '2003-06-03 00:00:00', 1, NULL, NULL),
  	(1312, 312, 465, '2003-03-10 00:00:00', 1, NULL, NULL),
  	(1513, 429, 244, '2003-05-09 00:00:00', 1, NULL, NULL),
  	(1180, 194, 330, '2003-09-16 00:00:00', 1, NULL, NULL),
  	(1450, 241, 501, '2003-04-10 00:00:00', 1, NULL, NULL),
  	(1312, 262, 514, '2003-11-24 00:00:00', 1, NULL, NULL),
  	(1441, 262, 514, '2003-03-18 00:00:00', 1, NULL, NULL),
  	(1197, 106, 375, '2003-02-10 00:00:00', 1, NULL, NULL),
  	(1400, 241, 142, '2003-06-27 00:00:00', 1, NULL, NULL),
  	(1513, 429, 244, '2003-08-25 00:00:00', 1, NULL, NULL),
  	(1180, 194, 330, '2003-09-12 00:00:00', 1, NULL, NULL),
  	(1421, 98, 411, '2002-10-31 00:00:00', 1, NULL, NULL),
  	(1450, 241, 501, '2003-03-25 00:00:00', 1, NULL, NULL),
  	(1312, 262, 514, '2003-09-08 00:00:00', 1, NULL, NULL),
  	(1312, 264, 501, '2003-09-22 00:00:00', 1, NULL, NULL),
  	(1441, 262, 514, '2002-12-13 00:00:00', 1, NULL, NULL),
  	(1312, 312, 465, '2003-02-26 00:00:00', 1, NULL, NULL),
  	(1400, 241, 142, '2003-05-23 00:00:00', 1, NULL, NULL),
  	(1180, 194, 330, '2003-01-21 00:00:00', 1, NULL, NULL),
  	(1421, 98, 411, '2003-02-28 00:00:00', 1, NULL, NULL),
  	(1312, 264, 501, '2003-03-19 00:00:00', 1, NULL, NULL),
  	(1159, 169, 460, '2002-12-02 00:00:00', 1, NULL, NULL),
  	(1172, 658, 379, '2002-06-11 00:00:00', 1, NULL, NULL),
  	(1165, 583, 289, '2003-01-21 00:00:00', 1, NULL, NULL),
  	(1259, 36, 166, '2002-12-12 00:00:00', 1, NULL, NULL),
  	(1172, 650, 334, '2003-01-07 00:00:00', 1, NULL, NULL),
  	(1159, 169, 460, '2003-03-18 00:00:00', 1, NULL, NULL),
  	(1172, 658, 379, '2003-04-16 00:00:00', 1, NULL, NULL),
  	(1165, 583, 289, '2003-10-28 00:00:00', 1, NULL, NULL),
  	(1259, 37, 166, '2003-02-05 00:00:00', 1, NULL, NULL),
  	(1172, 650, 334, '2002-11-29 00:00:00', 1, NULL, NULL),
  	(1159, 169, 460, '2003-04-17 00:00:00', 1, NULL, NULL),
  	(1172, 650, 334, '2003-02-28 00:00:00', 1, NULL, NULL),
  	(1172, 658, 379, '2003-04-30 00:00:00', 1, NULL, NULL),
  	(1165, 583, 289, '2003-09-12 00:00:00', 1, NULL, NULL),
  	(1259, 37, 166, '2003-05-30 00:00:00', 1, NULL, NULL),
  	(1172, 650, 334, '2003-08-22 00:00:00', 1, NULL, NULL);
  /*!40000 ALTER TABLE `ispit` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.migrations
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE IF NOT EXISTS `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.migrations: ~16 rows (approximately)
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  	(1, '2014_10_12_000000_create_users_table', 1),
  	(2, '2014_10_12_100000_create_password_resets_table', 1),
  	(3, '2016_11_03_231300_create_zupanija_table', 1),
  	(4, '2016_11_03_231350_create_mjesto_table', 1),
  	(5, '2016_11_03_231370_create_dvorana_table', 1),
  	(6, '2016_11_03_231443_create_stud_table', 1),
  	(7, '2016_11_03_231445_create_pred_table', 1),
  	(8, '2016_11_03_231446_create_ispit_table', 1),
  	(9, '2016_11_03_231480_create_nastavnik_table', 1),
  	(10, '2016_11_03_231490_create_orgjed_table', 1),
  	(11, '2016_11_03_231500_add_foreign_keys_to_ispit_table', 1),
  	(12, '2016_11_03_231510_add_foreign_keys_to_nastavnik_table', 1),
  	(13, '2016_11_03_231520_add_foreign_keys_to_mjesto_table', 1),
  	(14, '2016_11_03_231550_add_foreign_keys_to_pred_table', 1),
  	(15, '2016_11_03_231560_add_foreign_keys_to_stud_table', 1),
  	(16, '2017_05_31_125129_add_foreign_keys_to_orgjed_table', 1);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.mjesto
  DROP TABLE IF EXISTS `mjesto`;
  CREATE TABLE IF NOT EXISTS `mjesto` (
    `pbr` int(10) unsigned NOT NULL,
    `nazMjesto` char(40) COLLATE utf8_unicode_ci NOT NULL,
    `sifZupanija` smallint(5) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`pbr`),
    KEY `sifZupanija` (`sifZupanija`),
    CONSTRAINT `mjesto_ibfk_1` FOREIGN KEY (`sifZupanija`) REFERENCES `zupanija` (`sifZupanija`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.mjesto: ~274 rows (approximately)
  /*!40000 ALTER TABLE `mjesto` DISABLE KEYS */;
  INSERT INTO `mjesto` (`pbr`, `nazMjesto`, `sifZupanija`, `created_at`, `updated_at`) VALUES
  	(10000, 'Zagreb', 21, NULL, '2017-06-07 17:37:17'),
  	(10010, 'Zagreb-Sloboština', 21, NULL, NULL),
  	(10020, 'Zagreb-Novi Zagreb', 21, NULL, NULL),
  	(10040, 'Zagreb-Dubrava', 21, NULL, NULL),
  	(10090, 'Zagreb-Susedgrad', 21, NULL, NULL),
  	(10250, 'Lučko', 1, NULL, NULL),
  	(10255, 'Gornji Stupnik', 1, NULL, NULL),
  	(10290, 'Zaprešić', 1, NULL, NULL),
  	(10295, 'Kupljenovo', 1, NULL, NULL),
  	(10310, 'Ivanić-Grad', 1, NULL, NULL),
  	(10315, 'Novoselec', 1, NULL, NULL),
  	(10340, 'Vrbovec', 1, NULL, NULL),
  	(10345, 'Gradec', 1, NULL, NULL),
  	(10360, 'Sesvete', 1, NULL, NULL),
  	(10370, 'Dugo Selo', 1, NULL, NULL),
  	(10380, 'Sveti Ivan Zelina', 21, NULL, NULL),
  	(10410, 'Velika Gorica', 1, NULL, NULL),
  	(10415, 'Novo Čiče', 1, NULL, NULL),
  	(10430, 'Samobor', 1, NULL, NULL),
  	(10435, 'Sveti Martin pod Okićem', 1, NULL, NULL),
  	(10450, 'Jastrebarsko', 1, NULL, NULL),
  	(10455, 'Kostanjevac', 1, NULL, '2018-06-01 21:35:59'),
  	(20000, 'Dubrovnik', 19, NULL, NULL),
  	(20205, 'Topolo', 19, NULL, NULL),
  	(20210, 'Cavtat', 19, NULL, NULL),
  	(20215, 'Gruda', 19, NULL, NULL),
  	(20225, 'Babino Polje', 19, NULL, NULL),
  	(20230, 'Ston', 19, NULL, NULL),
  	(20235, 'Zaton Veliki', 19, NULL, NULL),
  	(20240, 'Trpanj', 19, NULL, NULL),
  	(20242, 'Oskorušno', 19, NULL, NULL),
  	(20245, 'Trstenik', 19, NULL, NULL),
  	(20250, 'Orebić', 19, NULL, NULL),
  	(20260, 'Korčula', 19, NULL, NULL),
  	(20270, 'Vela Luka', 19, NULL, NULL),
  	(20275, 'Žrnovo', 19, NULL, NULL),
  	(20290, 'Lastovo', 19, NULL, NULL),
  	(20340, 'Ploče', 19, NULL, NULL),
  	(20345, 'Staševica', 19, NULL, NULL),
  	(20350, 'Metković', 19, NULL, NULL),
  	(20355, 'Opuzen', 19, NULL, NULL),
  	(21000, 'Split', 17, NULL, NULL),
  	(21205, 'Donji Dolac', 17, NULL, NULL),
  	(21210, 'Solin', 17, NULL, NULL),
  	(21215, 'Kaštel Lukšić', 17, NULL, NULL),
  	(21220, 'Trogir', 17, NULL, NULL),
  	(21225, 'Drvenik Veliki', 17, NULL, NULL),
  	(21230, 'Sinj', 17, NULL, NULL),
  	(21232, 'Dicmo', 17, NULL, NULL),
  	(21235, 'Otišić', 17, NULL, NULL),
  	(21240, 'Trilj', 17, NULL, NULL),
  	(21245, 'Tijarica', 17, NULL, NULL),
  	(21250, 'Šestanovac', 17, NULL, NULL),
  	(21255, 'Zadvarje', 17, NULL, NULL),
  	(21260, 'Imotski', 17, NULL, NULL),
  	(21265, 'Studenci', 17, NULL, NULL),
  	(21270, 'Zagvozd', 17, NULL, NULL),
  	(21275, 'Dragljane', 17, NULL, NULL),
  	(21300, 'Makarska', 17, NULL, NULL),
  	(21310, 'Omiš', 17, NULL, NULL),
  	(21315, 'Dugi Rat', 17, NULL, NULL),
  	(21320, 'Baška Voda', 17, NULL, NULL),
  	(21325, 'Tučepi', 17, NULL, NULL),
  	(21330, 'Gradac', 17, NULL, NULL),
  	(21335, 'Podaca', 17, NULL, NULL),
  	(21400, 'Supetar', 17, NULL, NULL),
  	(21405, 'Milna', 17, NULL, NULL),
  	(21410, 'Postira', 17, NULL, NULL),
  	(21420, 'Bol', 17, NULL, NULL),
  	(21425, 'Selca', 17, NULL, NULL),
  	(21430, 'Grohote', 17, NULL, NULL),
  	(21450, 'Hvar', 17, NULL, NULL),
  	(21460, 'Stari Grad', 17, NULL, NULL),
  	(21465, 'Jelsa', 17, NULL, NULL),
  	(21480, 'Vis', 17, NULL, NULL),
  	(21485, 'Komiža', 17, NULL, NULL),
  	(22000, 'Šibenik', 15, NULL, NULL),
  	(22010, 'Šibenik-Brodarica', 15, NULL, NULL),
  	(22020, 'Šibenik-Ražine', 15, NULL, NULL),
  	(22030, 'Šibenik-Zablaće', 15, NULL, NULL),
  	(22205, 'Perković', 15, NULL, NULL),
  	(22215, 'Zaton', 15, NULL, NULL),
  	(22235, 'Kaprije', 15, NULL, NULL),
  	(22240, 'Tisno', 15, NULL, NULL),
  	(22300, 'Knin', 15, NULL, NULL),
  	(22305, 'Kistanje', 15, NULL, NULL),
  	(22310, 'Kijevo', 15, NULL, NULL),
  	(22320, 'Drniš', 15, NULL, NULL),
  	(23000, 'Zadar', 13, NULL, NULL),
  	(23205, 'Bibinje', 13, NULL, NULL),
  	(23210, 'Biograd na moru', 13, NULL, NULL),
  	(23235, 'Vrsi', 13, NULL, NULL),
  	(23245, 'Tribanj', 13, NULL, NULL),
  	(23250, 'Pag', 13, NULL, NULL),
  	(23275, 'Ugljan', 13, NULL, NULL),
  	(23285, 'Brbinj', 13, NULL, NULL),
  	(23295, 'Silba', 13, NULL, NULL),
  	(23420, 'Benkovac', 13, NULL, NULL),
  	(23440, 'Gračac', 13, NULL, NULL),
  	(23445, 'Srb', 13, NULL, NULL),
  	(23450, 'Obrovac', 13, NULL, NULL),
  	(31000, 'Osijek', 14, NULL, NULL),
  	(31205, 'Aljmaš', 14, NULL, NULL),
  	(31215, 'Ernestinovo', 14, NULL, NULL),
  	(31220, 'Višnjevac', 14, NULL, NULL),
  	(31225, 'Breznica Našička', 14, NULL, NULL),
  	(31300, 'Beli Manastir', 14, NULL, NULL),
  	(31301, 'Branjin Vrh', 14, NULL, NULL),
  	(31305, 'Draž', 14, NULL, NULL),
  	(31315, 'Karanac', 14, NULL, NULL),
  	(31325, 'Čeminac', 14, NULL, NULL),
  	(31400, 'Đakovo', 14, NULL, NULL),
  	(31410, 'Strizivojna', 14, NULL, NULL),
  	(31415, 'Selci Đakovački', 14, NULL, NULL),
  	(31500, 'Našice', 14, NULL, NULL),
  	(31530, 'Podravska Moslavina', 14, NULL, NULL),
  	(31531, 'Viljevo', 14, NULL, NULL),
  	(31540, 'Donji Miholjac', 14, NULL, NULL),
  	(31550, 'Valpovo', 14, NULL, NULL),
  	(31555, 'Marijanci', 14, NULL, NULL),
  	(32000, 'Vukovar', 16, NULL, NULL),
  	(32100, 'Vinkovci', 16, NULL, NULL),
  	(32225, 'Bobota', 16, NULL, NULL),
  	(32235, 'Bapska', 16, NULL, NULL),
  	(32240, 'Mirkovci', 16, NULL, NULL),
  	(32245, 'Nijemci', 16, NULL, NULL),
  	(32255, 'Soljani', 16, NULL, NULL),
  	(32260, 'Gunja', 16, NULL, NULL),
  	(32270, 'Županja', 16, NULL, NULL),
  	(32275, 'Bošnjaci', 16, NULL, NULL),
  	(32280, 'Jarmina', 16, NULL, NULL),
  	(33000, 'Virovitica', 10, NULL, NULL),
  	(33333, 'trice', 13, NULL, NULL),
  	(33405, 'Pitomača', 10, NULL, NULL),
  	(33410, 'Suhopolje', 10, NULL, NULL),
  	(33515, 'Orahovica', 10, NULL, NULL),
  	(33520, 'Slatina', 10, NULL, NULL),
  	(33525, 'Sopje', 10, NULL, NULL),
  	(34000, 'Požega', 11, NULL, NULL),
  	(34310, 'Pleternica', 11, NULL, NULL),
  	(34315, 'Ratkovica', 11, NULL, NULL),
  	(34320, 'Orljavac', 11, NULL, NULL),
  	(34330, 'Velika', 11, NULL, NULL),
  	(34335, 'Vetovo', 11, NULL, NULL),
  	(34340, 'Kutjevo', 11, NULL, NULL),
  	(34350, 'Čaglin', 11, NULL, NULL),
  	(34550, 'Pakrac', 11, NULL, NULL),
  	(35000, 'Slavonski Brod', 12, NULL, NULL),
  	(35210, 'Vrpolje', 12, NULL, NULL),
  	(35215, 'Svilaj', 12, NULL, NULL),
  	(35220, 'Slavonski Šamac', 12, NULL, NULL),
  	(35250, 'Oriovac', 12, NULL, NULL),
  	(35255, 'Slavonski Kobaš', 12, NULL, NULL),
  	(35400, 'Nova Gradiška', 12, NULL, NULL),
  	(35420, 'Staro Petrovo Selo', 12, NULL, NULL),
  	(35425, 'Davor', 12, NULL, NULL),
  	(35430, 'Okučani', 12, NULL, NULL),
  	(35435, 'Stara Gradiška', 12, NULL, NULL),
  	(40000, 'Čakovec', 20, NULL, NULL),
  	(40305, 'Nedelišče', 20, NULL, NULL),
  	(40315, 'Mursko Središče', 20, NULL, NULL),
  	(40320, 'Donji Kraljevec', 20, NULL, NULL),
  	(40325, 'Draškovec', 20, NULL, NULL),
  	(42000, 'Varaždin', 5, NULL, NULL),
  	(42205, 'Vidovec', 5, NULL, NULL),
  	(42220, 'Novi Marof', 5, NULL, NULL),
  	(42225, 'Breznički Hum', 5, NULL, NULL),
  	(42230, 'Ludbreg', 5, NULL, NULL),
  	(42240, 'Ivanec', 5, NULL, NULL),
  	(42245, 'Donja Voća', 5, NULL, NULL),
  	(42250, 'Lepoglava', 5, NULL, NULL),
  	(42255, 'Donja Višnjica', 5, NULL, NULL),
  	(43000, 'Bjelovar', 7, NULL, NULL),
  	(43240, 'Čazma', 7, NULL, NULL),
  	(43245, 'Gornji Draganec', 7, NULL, NULL),
  	(43270, 'Veliki Grđevac', 7, NULL, NULL),
  	(43271, 'Velika Pisanica', 7, NULL, NULL),
  	(43280, 'Garešnica', 7, NULL, NULL),
  	(43285, 'Velika Trnovitica', 7, NULL, NULL),
  	(43290, 'Grubišno Polje', 7, NULL, NULL),
  	(43500, 'Daruvar', 7, NULL, NULL),
  	(43505, 'Končanica', 7, NULL, NULL),
  	(43531, 'Veliki Bastaji', 7, NULL, NULL),
  	(44000, 'Sisak', 3, NULL, NULL),
  	(44010, 'Sisak-Caprag', 3, NULL, NULL),
  	(44205, 'Donja Bačuga', 3, NULL, NULL),
  	(44210, 'Sunja', 3, NULL, NULL),
  	(44250, 'Petrinja', 3, NULL, NULL),
  	(44271, 'Letovanić', 3, NULL, NULL),
  	(44320, 'Kutina', 3, NULL, NULL),
  	(44325, 'Krapje', 3, NULL, NULL),
  	(44330, 'Novska', 3, NULL, NULL),
  	(44400, 'Glina', 3, NULL, NULL),
  	(44405, 'Mali Gradac', 3, NULL, NULL),
  	(44410, 'Gvozd', 3, NULL, NULL),
  	(44415, 'Topusko', 3, NULL, NULL),
  	(44425, 'Gornja Bučica', 3, NULL, NULL),
  	(44430, 'Hrvatska Kostajnica', 3, NULL, NULL),
  	(44435, 'Divuša', 3, NULL, NULL),
  	(44440, 'Dvor', 3, NULL, NULL),
  	(44450, 'Hrvatska Dubica', 3, NULL, NULL),
  	(47000, 'Karlovac', 4, NULL, NULL),
  	(47201, 'Draganići', 4, NULL, NULL),
  	(47205, 'Vukmanić', 4, NULL, NULL),
  	(47220, 'Vojnić', 4, NULL, NULL),
  	(47240, 'Slunj', 4, NULL, NULL),
  	(47245, 'Rakovica', 4, NULL, NULL),
  	(47250, 'Duga Resa', 4, NULL, NULL),
  	(47251, 'Bosiljevo', 4, NULL, NULL),
  	(47280, 'Ozalj', 4, NULL, NULL),
  	(47285, 'Radatovići', 4, NULL, NULL),
  	(47300, 'Ogulin', 4, NULL, NULL),
  	(47302, 'Oštarije', 4, NULL, NULL),
  	(47305, 'Lička Jesenica', 4, NULL, NULL),
  	(48000, 'Koprivnica', 6, NULL, NULL),
  	(48260, 'Križevci', 6, NULL, NULL),
  	(48265, 'Raven', 6, NULL, NULL),
  	(48305, 'Reka', 6, NULL, NULL),
  	(48325, 'Novigrad Podravski', 6, NULL, NULL),
  	(48350, 'Đurđevac', 6, NULL, NULL),
  	(48355, 'Novo Virje', 6, NULL, NULL),
  	(49000, 'Krapina', 2, NULL, NULL),
  	(49210, 'Zabok', 2, NULL, NULL),
  	(49215, 'Tuhelj', 2, NULL, NULL),
  	(49225, 'Đurmanec', 2, NULL, NULL),
  	(49240, 'Donja Stubica', 2, NULL, NULL),
  	(49245, 'Gornja Stubica', 2, NULL, NULL),
  	(49250, 'Zlatar', 2, NULL, NULL),
  	(49255, 'Novi Golubovec', 2, NULL, NULL),
  	(49290, 'Klanjec', 2, NULL, NULL),
  	(49295, 'Kumrovec', 2, NULL, NULL),
  	(51000, 'Rijeka', 8, NULL, NULL),
  	(51211, 'Matulji', 8, NULL, NULL),
  	(51215, 'Kastav', 8, NULL, NULL),
  	(51225, 'Praputnjak', 8, NULL, NULL),
  	(51250, 'Novi Vinodolski', 8, NULL, NULL),
  	(51251, 'Ledenice', 8, NULL, NULL),
  	(51260, 'Crikvenica', 8, NULL, NULL),
  	(51265, 'Dramalj', 8, NULL, NULL),
  	(51280, 'Rab', 8, NULL, NULL),
  	(51300, 'Delnice', 8, NULL, NULL),
  	(51305, 'Tršće', 8, NULL, NULL),
  	(51315, 'Mrkopalj', 8, NULL, NULL),
  	(51325, 'Moravice', 8, NULL, NULL),
  	(51410, 'Opatija', 8, NULL, NULL),
  	(51415, 'Lovran', 8, NULL, NULL),
  	(51500, 'Krk', 8, NULL, NULL),
  	(51515, 'Šilo', 8, NULL, NULL),
  	(51550, 'Mali Lošinj', 8, NULL, NULL),
  	(51555, 'Belej', 8, NULL, NULL),
  	(52000, 'Pazin', 18, NULL, NULL),
  	(52100, 'Pula', 18, NULL, NULL),
  	(52210, 'Rovinj (Rovigno)', 18, NULL, NULL),
  	(52215, 'Vodnjan (Dignano)', 18, NULL, NULL),
  	(52220, 'Labin', 18, NULL, NULL),
  	(52420, 'Buzet', 18, NULL, NULL),
  	(52425, 'Roč', 18, NULL, NULL),
  	(52440, 'Poreč', 18, NULL, NULL),
  	(52445, 'Baderna', 18, NULL, NULL),
  	(52450, 'Vrsar', 18, NULL, NULL),
  	(52460, 'Buje (Buie)', 18, NULL, NULL),
  	(52465, 'Tar', 18, NULL, NULL),
  	(52470, 'Umag (Umago)', 18, NULL, NULL),
  	(52475, 'Savudrija (Salvore)', 18, NULL, NULL),
  	(53000, 'Gospić', 9, NULL, NULL),
  	(53205, 'Medak', 9, NULL, NULL),
  	(53220, 'Otočac', 9, NULL, NULL),
  	(53225, 'Švica', 9, NULL, NULL),
  	(53230, 'Korenica', 9, NULL, NULL),
  	(53235, 'Bunić', 9, NULL, NULL),
  	(53250, 'Donji Lapac', 9, NULL, NULL),
  	(53260, 'Brinje', 9, NULL, NULL),
  	(53270, 'Senj', 9, NULL, NULL),
  	(53285, 'Lukovo', 9, NULL, NULL);
  /*!40000 ALTER TABLE `mjesto` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.mjesto1
  DROP TABLE IF EXISTS `mjesto1`;
  CREATE TABLE IF NOT EXISTS `mjesto1` (
    `pbr` int(10) unsigned NOT NULL,
    `nazMjesto` char(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `sifZupanija` smallint(5) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `mojblob` mediumblob
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- Dumping data for table fakultet.mjesto1: ~276 rows (approximately)
  /*!40000 ALTER TABLE `mjesto1` DISABLE KEYS */;
  INSERT INTO `mjesto1` (`pbr`, `nazMjesto`, `sifZupanija`, `created_at`, `updated_at`, `mojblob`) VALUES
  	(10000, 'Zagreb', 21, NULL, '2017-06-07 17:37:17', _binary 0x00),
  	(10010, 'Zagreb-Sloboština', 21, NULL, NULL, NULL),
  	(10020, 'Zagreb-Novi Zagreb', 21, NULL, NULL, NULL),
  	(10040, 'Zagreb-Dubrava', 21, NULL, NULL, NULL),
  	(10090, 'Zagreb-Susedgrad', 21, NULL, NULL, NULL),
  	(10250, 'Lučko', 1, NULL, NULL, NULL),
  	(10255, 'Gornji Stupnik', 1, NULL, NULL, NULL),
  	(10290, 'Zaprešić', 1, NULL, NULL, NULL),
  	(10295, 'Kupljenovo', 1, NULL, NULL, NULL),
  	(10310, 'Ivanić-Grad', 1, NULL, NULL, NULL),
  	(10315, 'Novoselec', 1, NULL, NULL, NULL),
  	(10340, 'Vrbovec', 1, NULL, NULL, NULL),
  	(10345, 'Gradec', 1, NULL, NULL, NULL),
  	(10360, 'Sesvete', 1, NULL, NULL, NULL),
  	(10370, 'Dugo Selo', 1, NULL, NULL, NULL),
  	(10380, 'Sveti Ivan Zelina', 21, NULL, NULL, NULL),
  	(10410, 'Velika Gorica', 1, NULL, NULL, NULL),
  	(10415, 'Novo Čiče', 1, NULL, NULL, NULL),
  	(10430, 'Samobor', 1, NULL, NULL, NULL),
  	(10435, 'Sveti Martin pod Okićem', 1, NULL, NULL, NULL),
  	(10450, 'Jastrebarsko', 1, NULL, NULL, NULL),
  	(10455, 'Kostanjevac', 1, NULL, '2017-06-09 17:06:41', NULL),
  	(20000, 'Dubrovnik', 19, NULL, NULL, NULL),
  	(20205, 'Topolo', 19, NULL, NULL, NULL),
  	(20210, 'Cavtat', 19, NULL, NULL, NULL),
  	(20215, 'Gruda', 19, NULL, NULL, NULL),
  	(20225, 'Babino Polje', 19, NULL, NULL, NULL),
  	(20230, 'Ston', 19, NULL, NULL, NULL),
  	(20235, 'Zaton Veliki', 19, NULL, NULL, NULL),
  	(20240, 'Trpanj', 19, NULL, NULL, NULL),
  	(20242, 'Oskorušno', 19, NULL, NULL, NULL),
  	(20245, 'Trstenik', 19, NULL, NULL, NULL),
  	(20250, 'Orebić', 19, NULL, NULL, NULL),
  	(20260, 'Korčula', 19, NULL, NULL, NULL),
  	(20270, 'Vela Luka', 19, NULL, NULL, NULL),
  	(20275, 'Žrnovo', 19, NULL, NULL, NULL),
  	(20290, 'Lastovo', 19, NULL, NULL, NULL),
  	(20340, 'Ploče', 19, NULL, NULL, NULL),
  	(20345, 'Staševica', 19, NULL, NULL, NULL),
  	(20350, 'Metković', 19, NULL, NULL, NULL),
  	(20355, 'Opuzen', 19, NULL, NULL, NULL),
  	(21000, 'Split', 17, NULL, NULL, NULL),
  	(21205, 'Donji Dolac', 17, NULL, NULL, NULL),
  	(21210, 'Solin', 17, NULL, NULL, NULL),
  	(21215, 'Kaštel Lukšić', 17, NULL, NULL, NULL),
  	(21220, 'Trogir', 17, NULL, NULL, NULL),
  	(21225, 'Drvenik Veliki', 17, NULL, NULL, NULL),
  	(21230, 'Sinj', 17, NULL, NULL, NULL),
  	(21232, 'Dicmo', 17, NULL, NULL, NULL),
  	(21235, 'Otišić', 17, NULL, NULL, NULL),
  	(21240, 'Trilj', 17, NULL, NULL, NULL),
  	(21245, 'Tijarica', 17, NULL, NULL, NULL),
  	(21250, 'Šestanovac', 17, NULL, NULL, NULL),
  	(21255, 'Zadvarje', 17, NULL, NULL, NULL),
  	(21260, 'Imotski', 17, NULL, NULL, NULL),
  	(21265, 'Studenci', 17, NULL, NULL, NULL),
  	(21270, 'Zagvozd', 17, NULL, NULL, NULL),
  	(21275, 'Dragljane', 17, NULL, NULL, NULL),
  	(21300, 'Makarska', 17, NULL, NULL, NULL),
  	(21310, 'Omiš', 17, NULL, NULL, NULL),
  	(21315, 'Dugi Rat', 17, NULL, NULL, NULL),
  	(21320, 'Baška Voda', 17, NULL, NULL, NULL),
  	(21325, 'Tučepi', 17, NULL, NULL, NULL),
  	(21330, 'Gradac', 17, NULL, NULL, NULL),
  	(21335, 'Podaca', 17, NULL, NULL, NULL),
  	(21400, 'Supetar', 17, NULL, NULL, NULL),
  	(21405, 'Milna', 17, NULL, NULL, NULL),
  	(21410, 'Postira', 17, NULL, NULL, NULL),
  	(21420, 'Bol', 17, NULL, NULL, NULL),
  	(21425, 'Selca', 17, NULL, NULL, NULL),
  	(21430, 'Grohote', 17, NULL, NULL, NULL),
  	(21450, 'Hvar', 17, NULL, NULL, NULL),
  	(21460, 'Stari Grad', 17, NULL, NULL, NULL),
  	(21465, 'Jelsa', 17, NULL, NULL, NULL),
  	(21480, 'Vis', 17, NULL, NULL, NULL),
  	(21485, 'Komiža', 17, NULL, NULL, NULL),
  	(22000, 'Šibenik', 15, NULL, NULL, NULL),
  	(22010, 'Šibenik-Brodarica', 15, NULL, NULL, NULL),
  	(22020, 'Šibenik-Ražine', 15, NULL, NULL, NULL),
  	(22030, 'Šibenik-Zablaće', 15, NULL, NULL, NULL),
  	(22205, 'Perković', 15, NULL, NULL, NULL),
  	(22215, 'Zaton', 15, NULL, NULL, NULL),
  	(22235, 'Kaprije', 15, NULL, NULL, NULL),
  	(22240, 'Tisno', 15, NULL, NULL, NULL),
  	(22300, 'Knin', 15, NULL, NULL, NULL),
  	(22305, 'Kistanje', 15, NULL, NULL, NULL),
  	(22310, 'Kijevo', 15, NULL, NULL, NULL),
  	(22320, 'Drniš', 15, NULL, NULL, NULL),
  	(23000, 'Zadar', 13, NULL, NULL, NULL),
  	(23205, 'Bibinje', 13, NULL, NULL, NULL),
  	(23210, 'Biograd na moru', 13, NULL, NULL, NULL),
  	(23235, 'Vrsi', 13, NULL, NULL, NULL),
  	(23245, 'Tribanj', 13, NULL, NULL, NULL),
  	(23250, 'Pag', 13, NULL, NULL, NULL),
  	(23275, 'Ugljan', 13, NULL, NULL, NULL),
  	(23285, 'Brbinj', 13, NULL, NULL, NULL),
  	(23295, 'Silba', 13, NULL, NULL, NULL),
  	(23420, 'Benkovac', 13, NULL, NULL, NULL),
  	(23440, 'Gračac', 13, NULL, NULL, NULL),
  	(23445, 'Srb', 13, NULL, NULL, NULL),
  	(23450, 'Obrovac', 13, NULL, NULL, NULL),
  	(31000, 'Osijek', 14, NULL, NULL, NULL),
  	(31205, 'Aljmaš', 14, NULL, NULL, NULL),
  	(31215, 'Ernestinovo', 14, NULL, NULL, NULL),
  	(31220, 'Višnjevac', 14, NULL, NULL, NULL),
  	(31225, 'Breznica Našička', 14, NULL, NULL, NULL),
  	(31300, 'Beli Manastir', 14, NULL, NULL, NULL),
  	(31301, 'Branjin Vrh', 14, NULL, NULL, NULL),
  	(31305, 'Draž', 14, NULL, NULL, NULL),
  	(31315, 'Karanac', 14, NULL, NULL, NULL),
  	(31325, 'Čeminac', 14, NULL, NULL, NULL),
  	(31400, 'Đakovo', 14, NULL, NULL, NULL),
  	(31410, 'Strizivojna', 14, NULL, NULL, NULL),
  	(31415, 'Selci Đakovački', 14, NULL, NULL, NULL),
  	(31500, 'Našice', 14, NULL, NULL, NULL),
  	(31530, 'Podravska Moslavina', 14, NULL, NULL, NULL),
  	(31531, 'Viljevo', 14, NULL, NULL, NULL),
  	(31540, 'Donji Miholjac', 14, NULL, NULL, NULL),
  	(31550, 'Valpovo', 14, NULL, NULL, NULL),
  	(31555, 'Marijanci', 14, NULL, NULL, NULL),
  	(32000, 'Vukovar', 16, NULL, NULL, NULL),
  	(32100, 'Vinkovci', 16, NULL, NULL, NULL),
  	(32225, 'Bobota', 16, NULL, NULL, NULL),
  	(32235, 'Bapska', 16, NULL, NULL, NULL),
  	(32240, 'Mirkovci', 16, NULL, NULL, NULL),
  	(32245, 'Nijemci', 16, NULL, NULL, NULL),
  	(32255, 'Soljani', 16, NULL, NULL, NULL),
  	(32260, 'Gunja', 16, NULL, NULL, NULL),
  	(32270, 'Županja', 16, NULL, NULL, NULL),
  	(32275, 'Bošnjaci', 16, NULL, NULL, NULL),
  	(32280, 'Jarmina', 16, NULL, NULL, NULL),
  	(33000, 'Virovitica', 10, NULL, NULL, NULL),
  	(33333, 'trice', 13, NULL, NULL, NULL),
  	(33405, 'Pitomača', 10, NULL, NULL, NULL),
  	(33410, 'Suhopolje', 10, NULL, NULL, NULL),
  	(33515, 'Orahovica', 10, NULL, NULL, NULL),
  	(33520, 'Slatina', 10, NULL, NULL, NULL),
  	(33525, 'Sopje', 10, NULL, NULL, NULL),
  	(34000, 'Požega', 11, NULL, NULL, NULL),
  	(34310, 'Pleternica', 11, NULL, NULL, NULL),
  	(34315, 'Ratkovica', 11, NULL, NULL, NULL),
  	(34320, 'Orljavac', 11, NULL, NULL, NULL),
  	(34330, 'Velika', 11, NULL, NULL, NULL),
  	(34335, 'Vetovo', 11, NULL, NULL, NULL),
  	(34340, 'Kutjevo', 11, NULL, NULL, NULL),
  	(34350, 'Čaglin', 11, NULL, NULL, NULL),
  	(34550, 'Pakrac', 11, NULL, NULL, NULL),
  	(35000, 'Slavonski Brod', 12, NULL, NULL, NULL),
  	(35210, 'Vrpolje', 12, NULL, NULL, NULL),
  	(35215, 'Svilaj', 12, NULL, NULL, NULL),
  	(35220, 'Slavonski Šamac', 12, NULL, NULL, NULL),
  	(35250, 'Oriovac', 12, NULL, NULL, NULL),
  	(35255, 'Slavonski Kobaš', 12, NULL, NULL, NULL),
  	(35400, 'Nova Gradiška', 12, NULL, NULL, NULL),
  	(35420, 'Staro Petrovo Selo', 12, NULL, NULL, NULL),
  	(35425, 'Davor', 12, NULL, NULL, NULL),
  	(35430, 'Okučani', 12, NULL, NULL, NULL),
  	(35435, 'Stara Gradiška', 12, NULL, NULL, NULL),
  	(40000, 'Čakovec', 20, NULL, NULL, NULL),
  	(40305, 'Nedelišče', 20, NULL, NULL, NULL),
  	(40315, 'Mursko Središče', 20, NULL, NULL, NULL),
  	(40320, 'Donji Kraljevec', 20, NULL, NULL, NULL),
  	(40325, 'Draškovec', 20, NULL, NULL, NULL),
  	(42000, 'Varaždin', 5, NULL, NULL, NULL),
  	(42205, 'Vidovec', 5, NULL, NULL, NULL),
  	(42220, 'Novi Marof', 5, NULL, NULL, NULL),
  	(42225, 'Breznički Hum', 5, NULL, NULL, NULL),
  	(42230, 'Ludbreg', 5, NULL, NULL, NULL),
  	(42240, 'Ivanec', 5, NULL, NULL, NULL),
  	(42245, 'Donja Voća', 5, NULL, NULL, NULL),
  	(42250, 'Lepoglava', 5, NULL, NULL, NULL),
  	(42255, 'Donja Višnjica', 5, NULL, NULL, NULL),
  	(43000, 'Bjelovar', 7, NULL, NULL, NULL),
  	(43240, 'Čazma', 7, NULL, NULL, NULL),
  	(43245, 'Gornji Draganec', 7, NULL, NULL, NULL),
  	(43270, 'Veliki Grđevac', 7, NULL, NULL, NULL),
  	(43271, 'Velika Pisanica', 7, NULL, NULL, NULL),
  	(43280, 'Garešnica', 7, NULL, NULL, NULL),
  	(43285, 'Velika Trnovitica', 7, NULL, NULL, NULL),
  	(43290, 'Grubišno Polje', 7, NULL, NULL, NULL),
  	(43500, 'Daruvar', 7, NULL, NULL, NULL),
  	(43505, 'Končanica', 7, NULL, NULL, NULL),
  	(43531, 'Veliki Bastaji', 7, NULL, NULL, NULL),
  	(44000, 'Sisak', 3, NULL, NULL, NULL),
  	(44010, 'Sisak-Caprag', 3, NULL, NULL, NULL),
  	(44205, 'Donja Bačuga', 3, NULL, NULL, NULL),
  	(44210, 'Sunja', 3, NULL, NULL, NULL),
  	(44250, 'Petrinja', 3, NULL, NULL, NULL),
  	(44271, 'Letovanić', 3, NULL, NULL, NULL),
  	(44320, 'Kutina', 3, NULL, NULL, NULL),
  	(44325, 'Krapje', 3, NULL, NULL, NULL),
  	(44330, 'Novska', 3, NULL, NULL, NULL),
  	(44400, 'Glina', 3, NULL, NULL, NULL),
  	(44405, 'Mali Gradac', 3, NULL, NULL, NULL),
  	(44410, 'Gvozd', 3, NULL, NULL, NULL),
  	(44415, 'Topusko', 3, NULL, NULL, NULL),
  	(44425, 'Gornja Bučica', 3, NULL, NULL, NULL),
  	(44430, 'Hrvatska Kostajnica', 3, NULL, NULL, NULL),
  	(44435, 'Divuša', 3, NULL, NULL, NULL),
  	(44440, 'Dvor', 3, NULL, NULL, NULL),
  	(44450, 'Hrvatska Dubica', 3, NULL, NULL, NULL),
  	(47000, 'Karlovac', 4, NULL, NULL, NULL),
  	(47201, 'Draganići', 4, NULL, NULL, NULL),
  	(47205, 'Vukmanić', 4, NULL, NULL, NULL),
  	(47220, 'Vojnić', 4, NULL, NULL, NULL),
  	(47240, 'Slunj', 4, NULL, NULL, NULL),
  	(47245, 'Rakovica', 4, NULL, NULL, NULL),
  	(47250, 'Duga Resa', 4, NULL, NULL, NULL),
  	(47251, 'Bosiljevo', 4, NULL, NULL, NULL),
  	(47280, 'Ozalj', 4, NULL, NULL, NULL),
  	(47285, 'Radatovići', 4, NULL, NULL, NULL),
  	(47300, 'Ogulin', 4, NULL, NULL, NULL),
  	(47302, 'Oštarije', 4, NULL, NULL, NULL),
  	(47305, 'Lička Jesenica', 4, NULL, NULL, NULL),
  	(48000, 'Koprivnica', 6, NULL, NULL, NULL),
  	(48260, 'Križevci', 6, NULL, NULL, NULL),
  	(48265, 'Raven', 6, NULL, NULL, NULL),
  	(48305, 'Reka', 6, NULL, NULL, NULL),
  	(48325, 'Novigrad Podravski', 6, NULL, NULL, NULL),
  	(48350, 'Đurđevac', 6, NULL, NULL, NULL),
  	(48355, 'Novo Virje', 6, NULL, NULL, NULL),
  	(49000, 'Krapina', 2, NULL, NULL, NULL),
  	(49210, 'Zabok', 2, NULL, NULL, NULL),
  	(49215, 'Tuhelj', 2, NULL, NULL, NULL),
  	(49225, 'Đurmanec', 2, NULL, NULL, NULL),
  	(49240, 'Donja Stubica', 2, NULL, NULL, NULL),
  	(49245, 'Gornja Stubica', 2, NULL, NULL, NULL),
  	(49250, 'Zlatar', 2, NULL, NULL, NULL),
  	(49255, 'Novi Golubovec', 2, NULL, NULL, NULL),
  	(49290, 'Klanjec', 2, NULL, NULL, NULL),
  	(49295, 'Kumrovec', 2, NULL, NULL, NULL),
  	(51000, 'Rijeka', 8, NULL, NULL, NULL),
  	(51211, 'Matulji', 8, NULL, NULL, NULL),
  	(51215, 'Kastav', 8, NULL, NULL, NULL),
  	(51225, 'Praputnjak', 8, NULL, NULL, NULL),
  	(51250, 'Novi Vinodolski', 8, NULL, NULL, NULL),
  	(51251, 'Ledenice', 8, NULL, NULL, NULL),
  	(51260, 'Crikvenica', 8, NULL, NULL, NULL),
  	(51265, 'Dramalj', 8, NULL, NULL, NULL),
  	(51280, 'Rab', 8, NULL, NULL, NULL),
  	(51300, 'Delnice', 8, NULL, NULL, NULL),
  	(51305, 'Tršće', 8, NULL, NULL, NULL),
  	(51315, 'Mrkopalj', 8, NULL, NULL, NULL),
  	(51325, 'Moravice', 8, NULL, NULL, NULL),
  	(51410, 'Opatija', 8, NULL, NULL, NULL),
  	(51415, 'Lovran', 8, NULL, NULL, NULL),
  	(51500, 'Krk', 8, NULL, NULL, NULL),
  	(51515, 'Šilo', 8, NULL, NULL, NULL),
  	(51550, 'Mali Lošinj', 8, NULL, NULL, NULL),
  	(51555, 'Belej', 8, NULL, NULL, NULL),
  	(52000, 'Pazin', 18, NULL, NULL, NULL),
  	(52100, 'Pula', 18, NULL, NULL, NULL),
  	(52210, 'Rovinj (Rovigno)', 18, NULL, NULL, NULL),
  	(52215, 'Vodnjan (Dignano)', 18, NULL, NULL, NULL),
  	(52220, 'Labin', 18, NULL, NULL, NULL),
  	(52420, 'Buzet', 18, NULL, NULL, NULL),
  	(52425, 'Roč', 18, NULL, NULL, NULL),
  	(52440, 'Poreč', 18, NULL, NULL, NULL),
  	(52445, 'Baderna', 18, NULL, NULL, NULL),
  	(52450, 'Vrsar', 18, NULL, NULL, NULL),
  	(52460, 'Buje (Buie)', 18, NULL, NULL, NULL),
  	(52465, 'Tar', 18, NULL, NULL, NULL),
  	(52470, 'Umag (Umago)', 18, NULL, NULL, NULL),
  	(52475, 'Savudrija (Salvore)', 18, NULL, NULL, NULL),
  	(53000, 'Gospić', 9, NULL, NULL, NULL),
  	(53205, 'Medak', 9, NULL, NULL, NULL),
  	(53220, 'Otočac', 9, NULL, NULL, NULL),
  	(53225, 'Švica', 9, NULL, NULL, NULL),
  	(53230, 'Korenica', 9, NULL, NULL, NULL),
  	(53235, 'Bunić', 9, NULL, NULL, NULL),
  	(53250, 'Donji Lapac', 9, NULL, NULL, NULL),
  	(53260, 'Brinje', 9, NULL, NULL, NULL),
  	(53270, 'Senj', 9, NULL, NULL, NULL),
  	(53285, 'Lukovo', 9, NULL, NULL, NULL),
  	(11111, 'Zzzzzz', 789, NULL, NULL, NULL),
  	(22222, 'Zzzzzz', 789, NULL, NULL, NULL),
  	(44444, 'vvv', 4444, NULL, NULL, NULL),
  	(88888, 'bbb', 8888, NULL, NULL, NULL),
  	(6666, 'nnn', 9999, NULL, NULL, NULL),
  	(77777, 'mmm', 12121, NULL, NULL, NULL),
  	(44444, 'vvv', 4444, NULL, NULL, NULL),
  	(88888, 'bbb', 8888, NULL, NULL, NULL),
  	(6666, 'nnn', 9999, NULL, NULL, NULL),
  	(77777, 'mmm', 12121, NULL, NULL, NULL);
  /*!40000 ALTER TABLE `mjesto1` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.mjsttest
  DROP TABLE IF EXISTS `mjsttest`;
  CREATE TABLE IF NOT EXISTS `mjsttest` (
    `pbr` int(10) unsigned NOT NULL,
    `nazMjesto` char(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `sifZupanija` int(6) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- Dumping data for table fakultet.mjsttest: ~274 rows (approximately)
  /*!40000 ALTER TABLE `mjsttest` DISABLE KEYS */;
  INSERT INTO `mjsttest` (`pbr`, `nazMjesto`, `sifZupanija`, `created_at`, `updated_at`) VALUES
  	(10000, 'Zagreb', 22, NULL, '2017-06-07 17:37:17'),
  	(10010, 'Zagreb-Sloboština', 22, NULL, NULL),
  	(10020, 'Zagreb-Novi Zagreb', 22, NULL, NULL),
  	(10040, 'Zagreb-Dubrava', 22, NULL, NULL),
  	(10090, 'Zagreb-Susedgrad', 22, NULL, NULL),
  	(10250, 'Lučko', 2, NULL, NULL),
  	(10255, 'Gornji Stupnik', 2, NULL, NULL),
  	(10290, 'Zaprešić', 2, NULL, NULL),
  	(10295, 'Kupljenovo', 2, NULL, NULL),
  	(10310, 'Ivanić-Grad', 2, NULL, NULL),
  	(10315, 'Novoselec', 2, NULL, NULL),
  	(10340, 'Vrbovec', 2, NULL, NULL),
  	(10345, 'Gradec', 2, NULL, NULL),
  	(10360, 'Sesvete', 2, NULL, NULL),
  	(10370, 'Dugo Selo', 2, NULL, NULL),
  	(10380, 'Sveti Ivan Zelina', 22, NULL, NULL),
  	(10410, 'Velika Gorica', 2, NULL, NULL),
  	(10415, 'Novo Čiče', 2, NULL, NULL),
  	(10430, 'Samobor', 2, NULL, NULL),
  	(10435, 'Sveti Martin pod Okićem', 2, NULL, NULL),
  	(10450, 'Jastrebarsko', 2, NULL, NULL),
  	(10455, 'Kostanjevac', 2, NULL, '2017-06-09 17:06:41'),
  	(20000, 'Dubrovnik', 20, NULL, NULL),
  	(20205, 'Topolo', 20, NULL, NULL),
  	(20210, 'Cavtat', 20, NULL, NULL),
  	(20215, 'Gruda', 20, NULL, NULL),
  	(20225, 'Babino Polje', 20, NULL, NULL),
  	(20230, 'Ston', 20, NULL, NULL),
  	(20235, 'Zaton Veliki', 20, NULL, NULL),
  	(20240, 'Trpanj', 20, NULL, NULL),
  	(20242, 'Oskorušno', 20, NULL, NULL),
  	(20245, 'Trstenik', 20, NULL, NULL),
  	(20250, 'Orebić', 20, NULL, NULL),
  	(20260, 'Korčula', 20, NULL, NULL),
  	(20270, 'Vela Luka', 20, NULL, NULL),
  	(20275, 'Žrnovo', 20, NULL, NULL),
  	(20290, 'Lastovo', 20, NULL, NULL),
  	(20340, 'Ploče', 20, NULL, NULL),
  	(20345, 'Staševica', 20, NULL, NULL),
  	(20350, 'Metković', 20, NULL, NULL),
  	(20355, 'Opuzen', 20, NULL, NULL),
  	(21000, 'Split', 18, NULL, NULL),
  	(21205, 'Donji Dolac', 18, NULL, NULL),
  	(21210, 'Solin', 18, NULL, NULL),
  	(21215, 'Kaštel Lukšić', 18, NULL, NULL),
  	(21220, 'Trogir', 18, NULL, NULL),
  	(21225, 'Drvenik Veliki', 18, NULL, NULL),
  	(21230, 'Sinj', 18, NULL, NULL),
  	(21232, 'Dicmo', 18, NULL, NULL),
  	(21235, 'Otišić', 18, NULL, NULL),
  	(21240, 'Trilj', 18, NULL, NULL),
  	(21245, 'Tijarica', 18, NULL, NULL),
  	(21250, 'Šestanovac', 18, NULL, NULL),
  	(21255, 'Zadvarje', 18, NULL, NULL),
  	(21260, 'Imotski', 18, NULL, NULL),
  	(21265, 'Studenci', 18, NULL, NULL),
  	(21270, 'Zagvozd', 18, NULL, NULL),
  	(21275, 'Dragljane', 18, NULL, NULL),
  	(21300, 'Makarska', 18, NULL, NULL),
  	(21310, 'Omiš', 18, NULL, NULL),
  	(21315, 'Dugi Rat', 18, NULL, NULL),
  	(21320, 'Baška Voda', 18, NULL, NULL),
  	(21325, 'Tučepi', 18, NULL, NULL),
  	(21330, 'Gradac', 18, NULL, NULL),
  	(21335, 'Podaca', 18, NULL, NULL),
  	(21400, 'Supetar', 18, NULL, NULL),
  	(21405, 'Milna', 18, NULL, NULL),
  	(21410, 'Postira', 18, NULL, NULL),
  	(21420, 'Bol', 18, NULL, NULL),
  	(21425, 'Selca', 18, NULL, NULL),
  	(21430, 'Grohote', 18, NULL, NULL),
  	(21450, 'Hvar', 18, NULL, NULL),
  	(21460, 'Stari Grad', 18, NULL, NULL),
  	(21465, 'Jelsa', 18, NULL, NULL),
  	(21480, 'Vis', 18, NULL, NULL),
  	(21485, 'Komiža', 18, NULL, NULL),
  	(22000, 'Šibenik', 16, NULL, NULL),
  	(22010, 'Šibenik-Brodarica', 16, NULL, NULL),
  	(22020, 'Šibenik-Ražine', 16, NULL, NULL),
  	(22030, 'Šibenik-Zablaće', 16, NULL, NULL),
  	(22205, 'Perković', 16, NULL, NULL),
  	(22215, 'Zaton', 16, NULL, NULL),
  	(22235, 'Kaprije', 16, NULL, NULL),
  	(22240, 'Tisno', 16, NULL, NULL),
  	(22300, 'Knin', 16, NULL, NULL),
  	(22305, 'Kistanje', 16, NULL, NULL),
  	(22310, 'Kijevo', 16, NULL, NULL),
  	(22320, 'Drniš', 16, NULL, NULL),
  	(23000, 'Zadar', 14, NULL, NULL),
  	(23205, 'Bibinje', 14, NULL, NULL),
  	(23210, 'Biograd na moru', 14, NULL, NULL),
  	(23235, 'Vrsi', 14, NULL, NULL),
  	(23245, 'Tribanj', 14, NULL, NULL),
  	(23250, 'Pag', 14, NULL, NULL),
  	(23275, 'Ugljan', 14, NULL, NULL),
  	(23285, 'Brbinj', 14, NULL, NULL),
  	(23295, 'Silba', 14, NULL, NULL),
  	(23420, 'Benkovac', 14, NULL, NULL),
  	(23440, 'Gračac', 14, NULL, NULL),
  	(23445, 'Srb', 14, NULL, NULL),
  	(23450, 'Obrovac', 14, NULL, NULL),
  	(31000, 'Osijek', 15, NULL, NULL),
  	(31205, 'Aljmaš', 15, NULL, NULL),
  	(31215, 'Ernestinovo', 15, NULL, NULL),
  	(31220, 'Višnjevac', 15, NULL, NULL),
  	(31225, 'Breznica Našička', 15, NULL, NULL),
  	(31300, 'Beli Manastir', 15, NULL, NULL),
  	(31301, 'Branjin Vrh', 15, NULL, NULL),
  	(31305, 'Draž', 15, NULL, NULL),
  	(31315, 'Karanac', 15, NULL, NULL),
  	(31325, 'Čeminac', 15, NULL, NULL),
  	(31400, 'Đakovo', 15, NULL, NULL),
  	(31410, 'Strizivojna', 15, NULL, NULL),
  	(31415, 'Selci Đakovački', 15, NULL, NULL),
  	(31500, 'Našice', 15, NULL, NULL),
  	(31530, 'Podravska Moslavina', 15, NULL, NULL),
  	(31531, 'Viljevo', 15, NULL, NULL),
  	(31540, 'Donji Miholjac', 15, NULL, NULL),
  	(31550, 'Valpovo', 15, NULL, NULL),
  	(31555, 'Marijanci', 15, NULL, NULL),
  	(32000, 'Vukovar', 17, NULL, NULL),
  	(32100, 'Vinkovci', 17, NULL, NULL),
  	(32225, 'Bobota', 17, NULL, NULL),
  	(32235, 'Bapska', 17, NULL, NULL),
  	(32240, 'Mirkovci', 17, NULL, NULL),
  	(32245, 'Nijemci', 17, NULL, NULL),
  	(32255, 'Soljani', 17, NULL, NULL),
  	(32260, 'Gunja', 17, NULL, NULL),
  	(32270, 'Županja', 17, NULL, NULL),
  	(32275, 'Bošnjaci', 17, NULL, NULL),
  	(32280, 'Jarmina', 17, NULL, NULL),
  	(33000, 'Virovitica', 11, NULL, NULL),
  	(33333, 'trice', 14, NULL, NULL),
  	(33405, 'Pitomača', 11, NULL, NULL),
  	(33410, 'Suhopolje', 11, NULL, NULL),
  	(33515, 'Orahovica', 11, NULL, NULL),
  	(33520, 'Slatina', 11, NULL, NULL),
  	(33525, 'Sopje', 11, NULL, NULL),
  	(34000, 'Požega', 12, NULL, NULL),
  	(34310, 'Pleternica', 12, NULL, NULL),
  	(34315, 'Ratkovica', 12, NULL, NULL),
  	(34320, 'Orljavac', 12, NULL, NULL),
  	(34330, 'Velika', 12, NULL, NULL),
  	(34335, 'Vetovo', 12, NULL, NULL),
  	(34340, 'Kutjevo', 12, NULL, NULL),
  	(34350, 'Čaglin', 12, NULL, NULL),
  	(34550, 'Pakrac', 12, NULL, NULL),
  	(35000, 'Slavonski Brod', 13, NULL, NULL),
  	(35210, 'Vrpolje', 13, NULL, NULL),
  	(35215, 'Svilaj', 13, NULL, NULL),
  	(35220, 'Slavonski Šamac', 13, NULL, NULL),
  	(35250, 'Oriovac', 13, NULL, NULL),
  	(35255, 'Slavonski Kobaš', 13, NULL, NULL),
  	(35400, 'Nova Gradiška', 13, NULL, NULL),
  	(35420, 'Staro Petrovo Selo', 13, NULL, NULL),
  	(35425, 'Davor', 13, NULL, NULL),
  	(35430, 'Okučani', 13, NULL, NULL),
  	(35435, 'Stara Gradiška', 13, NULL, NULL),
  	(40000, 'Čakovec', 21, NULL, NULL),
  	(40305, 'Nedelišče', 21, NULL, NULL),
  	(40315, 'Mursko Središče', 21, NULL, NULL),
  	(40320, 'Donji Kraljevec', 21, NULL, NULL),
  	(40325, 'Draškovec', 21, NULL, NULL),
  	(42000, 'Varaždin', 6, NULL, NULL),
  	(42205, 'Vidovec', 6, NULL, NULL),
  	(42220, 'Novi Marof', 6, NULL, NULL),
  	(42225, 'Breznički Hum', 6, NULL, NULL),
  	(42230, 'Ludbreg', 6, NULL, NULL),
  	(42240, 'Ivanec', 6, NULL, NULL),
  	(42245, 'Donja Voća', 6, NULL, NULL),
  	(42250, 'Lepoglava', 6, NULL, NULL),
  	(42255, 'Donja Višnjica', 6, NULL, NULL),
  	(43000, 'Bjelovar', 8, NULL, NULL),
  	(43240, 'Čazma', 8, NULL, NULL),
  	(43245, 'Gornji Draganec', 8, NULL, NULL),
  	(43270, 'Veliki Grđevac', 8, NULL, NULL),
  	(43271, 'Velika Pisanica', 8, NULL, NULL),
  	(43280, 'Garešnica', 8, NULL, NULL),
  	(43285, 'Velika Trnovitica', 8, NULL, NULL),
  	(43290, 'Grubišno Polje', 8, NULL, NULL),
  	(43500, 'Daruvar', 8, NULL, NULL),
  	(43505, 'Končanica', 8, NULL, NULL),
  	(43531, 'Veliki Bastaji', 8, NULL, NULL),
  	(44000, 'Sisak', 4, NULL, NULL),
  	(44010, 'Sisak-Caprag', 4, NULL, NULL),
  	(44205, 'Donja Bačuga', 4, NULL, NULL),
  	(44210, 'Sunja', 4, NULL, NULL),
  	(44250, 'Petrinja', 4, NULL, NULL),
  	(44271, 'Letovanić', 4, NULL, NULL),
  	(44320, 'Kutina', 4, NULL, NULL),
  	(44325, 'Krapje', 4, NULL, NULL),
  	(44330, 'Novska', 4, NULL, NULL),
  	(44400, 'Glina', 4, NULL, NULL),
  	(44405, 'Mali Gradac', 4, NULL, NULL),
  	(44410, 'Gvozd', 4, NULL, NULL),
  	(44415, 'Topusko', 4, NULL, NULL),
  	(44425, 'Gornja Bučica', 4, NULL, NULL),
  	(44430, 'Hrvatska Kostajnica', 4, NULL, NULL),
  	(44435, 'Divuša', 4, NULL, NULL),
  	(44440, 'Dvor', 4, NULL, NULL),
  	(44450, 'Hrvatska Dubica', 4, NULL, NULL),
  	(47000, 'Karlovac', 5, NULL, NULL),
  	(47201, 'Draganići', 5, NULL, NULL),
  	(47205, 'Vukmanić', 5, NULL, NULL),
  	(47220, 'Vojnić', 5, NULL, NULL),
  	(47240, 'Slunj', 5, NULL, NULL),
  	(47245, 'Rakovica', 5, NULL, NULL),
  	(47250, 'Duga Resa', 5, NULL, NULL),
  	(47251, 'Bosiljevo', 5, NULL, NULL),
  	(47280, 'Ozalj', 5, NULL, NULL),
  	(47285, 'Radatovići', 5, NULL, NULL),
  	(47300, 'Ogulin', 5, NULL, NULL),
  	(47302, 'Oštarije', 5, NULL, NULL),
  	(47305, 'Lička Jesenica', 5, NULL, NULL),
  	(48000, 'Koprivnica', 7, NULL, NULL),
  	(48260, 'Križevci', 7, NULL, NULL),
  	(48265, 'Raven', 7, NULL, NULL),
  	(48305, 'Reka', 7, NULL, NULL),
  	(48325, 'Novigrad Podravski', 7, NULL, NULL),
  	(48350, 'Đurđevac', 7, NULL, NULL),
  	(48355, 'Novo Virje', 7, NULL, NULL),
  	(49000, 'Krapina', 3, NULL, NULL),
  	(49210, 'Zabok', 3, NULL, NULL),
  	(49215, 'Tuhelj', 3, NULL, NULL),
  	(49225, 'Đurmanec', 3, NULL, NULL),
  	(49240, 'Donja Stubica', 3, NULL, NULL),
  	(49245, 'Gornja Stubica', 3, NULL, NULL),
  	(49250, 'Zlatar', 3, NULL, NULL),
  	(49255, 'Novi Golubovec', 3, NULL, NULL),
  	(49290, 'Klanjec', 3, NULL, NULL),
  	(49295, 'Kumrovec', 3, NULL, NULL),
  	(51000, 'Rijeka', 9, NULL, NULL),
  	(51211, 'Matulji', 9, NULL, NULL),
  	(51215, 'Kastav', 9, NULL, NULL),
  	(51225, 'Praputnjak', 9, NULL, NULL),
  	(51250, 'Novi Vinodolski', 9, NULL, NULL),
  	(51251, 'Ledenice', 9, NULL, NULL),
  	(51260, 'Crikvenica', 9, NULL, NULL),
  	(51265, 'Dramalj', 9, NULL, NULL),
  	(51280, 'Rab', 9, NULL, NULL),
  	(51300, 'Delnice', 9, NULL, NULL),
  	(51305, 'Tršće', 9, NULL, NULL),
  	(51315, 'Mrkopalj', 9, NULL, NULL),
  	(51325, 'Moravice', 9, NULL, NULL),
  	(51410, 'Opatija', 9, NULL, NULL),
  	(51415, 'Lovran', 9, NULL, NULL),
  	(51500, 'Krk', 9, NULL, NULL),
  	(51515, 'Šilo', 9, NULL, NULL),
  	(51550, 'Mali Lošinj', 9, NULL, NULL),
  	(51555, 'Belej', 9, NULL, NULL),
  	(52000, 'Pazin', 19, NULL, NULL),
  	(52100, 'Pula', 19, NULL, NULL),
  	(52210, 'Rovinj (Rovigno)', 19, NULL, NULL),
  	(52215, 'Vodnjan (Dignano)', 19, NULL, NULL),
  	(52220, 'Labin', 19, NULL, NULL),
  	(52420, 'Buzet', 19, NULL, NULL),
  	(52425, 'Roč', 19, NULL, NULL),
  	(52440, 'Poreč', 19, NULL, NULL),
  	(52445, 'Baderna', 19, NULL, NULL),
  	(52450, 'Vrsar', 19, NULL, NULL),
  	(52460, 'Buje (Buie)', 19, NULL, NULL),
  	(52465, 'Tar', 19, NULL, NULL),
  	(52470, 'Umag (Umago)', 19, NULL, NULL),
  	(52475, 'Savudrija (Salvore)', 19, NULL, NULL),
  	(53000, 'Gospić', 10, NULL, NULL),
  	(53205, 'Medak', 10, NULL, NULL),
  	(53220, 'Otočac', 10, NULL, NULL),
  	(53225, 'Švica', 10, NULL, NULL),
  	(53230, 'Korenica', 10, NULL, NULL),
  	(53235, 'Bunić', 10, NULL, NULL),
  	(53250, 'Donji Lapac', 10, NULL, NULL),
  	(53260, 'Brinje', 10, NULL, NULL),
  	(53270, 'Senj', 10, NULL, NULL),
  	(53285, 'Lukovo', 10, NULL, NULL);
  /*!40000 ALTER TABLE `mjsttest` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.nastavnik
  DROP TABLE IF EXISTS `nastavnik`;
  CREATE TABLE IF NOT EXISTS `nastavnik` (
    `sifNastavnik` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `imeNastavnik` char(25) COLLATE utf8_unicode_ci NOT NULL,
    `prezNastavnik` char(25) COLLATE utf8_unicode_ci NOT NULL,
    `pbrStan` int(10) unsigned NOT NULL,
    `sifOrgjed` int(10) unsigned NOT NULL,
    `koef` decimal(3,2) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`sifNastavnik`),
    KEY `pbrStan` (`pbrStan`),
    KEY `sifOrgjed` (`sifOrgjed`),
    CONSTRAINT `nastavnik_ibfk_1` FOREIGN KEY (`pbrStan`) REFERENCES `mjesto` (`pbr`),
    CONSTRAINT `nastavnik_ibfk_2` FOREIGN KEY (`sifOrgjed`) REFERENCES `orgjed` (`sifOrgjed`)
  ) ENGINE=InnoDB AUTO_INCREMENT=519 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.nastavnik: ~98 rows (approximately)
  /*!40000 ALTER TABLE `nastavnik` DISABLE KEYS */;
  INSERT INTO `nastavnik` (`sifNastavnik`, `imeNastavnik`, `prezNastavnik`, `pbrStan`, `sifOrgjed`, `koef`, `created_at`, `updated_at`) VALUES
  	(122, 'Tin', 'Grabovac', 49000, 100005, 5.90, NULL, NULL),
  	(126, 'Zdravko', 'Budišin', 53000, 100006, 6.30, NULL, NULL),
  	(130, 'Antun Ivan', 'Jonjić', 10000, 100007, 6.70, NULL, NULL),
  	(134, 'Želimir', 'Somrak', 33000, 100025, 7.10, NULL, NULL),
  	(138, 'David', 'Petković', 35000, 100009, 7.50, NULL, NULL),
  	(142, 'Alan', 'Ostojčić', 10000, 100010, 7.90, NULL, NULL),
  	(146, 'Franjo', 'Vidaković', 20000, 100011, 8.30, NULL, NULL),
  	(150, 'Ana', 'Kukec', 20000, 100001, 8.70, NULL, NULL),
  	(154, 'Žarko', 'Dubinko', 10000, 100002, 9.10, NULL, NULL),
  	(158, 'Davorka', 'Volarić', 10000, 100003, 9.50, NULL, NULL),
  	(162, 'Želimir', 'Prester', 34550, 100004, 9.90, NULL, NULL),
  	(166, 'Nino', 'Lipec', 10000, 100005, 3.30, NULL, NULL),
  	(171, 'Dinko', 'Žubrinić', 10000, 100006, 4.50, NULL, NULL),
  	(175, 'Željko', 'Kovačević', 10000, 100007, 4.90, NULL, NULL),
  	(179, 'Adrijan', 'Dugonjić', 21000, 100008, 5.30, NULL, NULL),
  	(183, 'Dino', 'Parlov', 21000, 100025, 5.70, NULL, NULL),
  	(187, 'Gordana', 'Hočevar', 10000, 100025, 3.10, NULL, NULL),
  	(191, 'Davorka', 'Vidović', 10000, 100011, 3.50, NULL, NULL),
  	(195, 'Lovre', 'Đeri', 20000, 100001, 3.90, NULL, NULL),
  	(199, 'Marko', 'Pepelnjak', 10000, 100026, 4.30, NULL, NULL),
  	(203, 'Ivana', 'Sokol', 10000, 100003, 4.70, NULL, NULL),
  	(207, 'Mijo', 'Marović', 51000, 100004, 5.10, NULL, NULL),
  	(211, 'Julija', 'Studen', 10000, 100026, 5.50, NULL, NULL),
  	(215, 'Petar', 'Kruljac', 33000, 100006, 5.90, NULL, NULL),
  	(220, 'Katarina', 'Glavaš', 10000, 100007, 7.10, NULL, NULL),
  	(224, 'Lovro', 'Martinović', 10000, 100008, 7.50, NULL, NULL),
  	(228, 'Renata', 'Santo', 22000, 100009, 7.90, NULL, NULL),
  	(232, 'Dubravko', 'Josipović', 10000, 100010, 8.30, NULL, NULL),
  	(236, 'Robert', 'Pavlović', 20000, 100011, 8.70, NULL, NULL),
  	(240, 'Želimir', 'Bereček', 21000, 100025, 9.10, NULL, NULL),
  	(244, 'Zlatko', 'Tomašek', 10000, 100002, 9.50, NULL, NULL),
  	(248, 'Sandra', 'Stanojević', 31410, 100003, 9.90, NULL, NULL),
  	(252, 'Edita', 'Pavić', 21265, 100025, 3.30, NULL, NULL),
  	(256, 'Sanja', 'Watz', 10000, 100005, 3.70, NULL, NULL),
  	(260, 'Božidar', 'Došen', 21275, 100006, 4.10, NULL, NULL),
  	(264, 'Marko', 'Kovačević', 10000, 100007, 4.50, NULL, NULL),
  	(269, 'Marija', 'Novokmet', 32000, 100008, 5.70, NULL, NULL),
  	(273, 'Davor', 'Režan', 10000, 100009, 3.10, NULL, NULL),
  	(277, 'Silvije', 'Szekeres', 21000, 100010, 3.50, NULL, NULL),
  	(281, 'Dubravko', 'Kirinčić', 10000, 100011, 3.90, NULL, NULL),
  	(285, 'Iva', 'Frančišković', 10000, 100001, 4.30, NULL, NULL),
  	(289, 'Marina', 'Carek', 10000, 100002, 4.70, NULL, NULL),
  	(293, 'Mirna', 'Rakić', 21000, 100025, 5.10, NULL, NULL),
  	(297, 'Alen', 'Pisac', 10000, 100004, 5.50, NULL, NULL),
  	(301, 'Stanislav', 'Krznarić', 10000, 100005, 5.90, NULL, NULL),
  	(305, 'Nikolina', 'Horvat', 31000, 100006, 6.30, NULL, NULL),
  	(309, 'Lovre', 'Rožić', 35000, 100007, 6.70, NULL, NULL),
  	(313, 'Marko', 'Trajbar', 43000, 100008, 7.10, NULL, NULL),
  	(318, 'Nino', 'Gvozdić', 10000, 100009, 8.30, NULL, NULL),
  	(322, 'Ana', 'Juretić', 32000, 100025, 8.70, NULL, NULL),
  	(326, 'Sunčica', 'Pleško', 34000, 100011, 9.10, NULL, NULL),
  	(330, 'Vinko', 'Kecman', 10000, 100001, 9.50, NULL, NULL),
  	(334, 'Sandra', 'Mihaljević', 10000, 100002, 9.90, NULL, NULL),
  	(338, 'Petar', 'Petrović', 20000, 100026, 3.30, NULL, NULL),
  	(342, 'Tin', 'Mandić', 10000, 100004, 3.70, NULL, NULL),
  	(346, 'Anđelko', 'Puzak', 48260, 100025, 4.10, NULL, NULL),
  	(350, 'Vjeran', 'Kovačić', 10000, 100006, 4.50, NULL, NULL),
  	(354, 'Tamara', 'Križanić', 10000, 100007, 4.90, NULL, NULL),
  	(358, 'Aljoša', 'Marijanić', 31000, 100008, 5.30, NULL, NULL),
  	(362, 'Tanja', 'Crnić', 34000, 100009, 5.70, NULL, NULL),
  	(367, 'Tanja', 'Petrović', 10000, 100010, 3.90, NULL, NULL),
  	(371, 'Božidar', 'Mužar', 10000, 100011, 4.30, NULL, NULL),
  	(375, 'Tina', 'Švaljek', 10000, 100001, 4.70, NULL, NULL),
  	(379, 'Mia', 'Stojić', 21000, 100002, 5.10, NULL, NULL),
  	(383, 'Mihael', 'Schildenfeld', 10000, 100003, 5.50, NULL, NULL),
  	(387, 'Tina', 'Madunić', 21000, 100025, 5.90, NULL, NULL),
  	(391, 'Marko', 'Hazdovac', 10000, 100005, 6.30, NULL, NULL),
  	(395, 'Nino', 'Zajc', 51000, 100006, 6.70, NULL, NULL),
  	(399, 'Tino', 'Zerec', 31000, 100007, 7.10, NULL, NULL),
  	(403, 'Aurelija', 'Jurić', 34000, 100008, 7.50, NULL, NULL),
  	(407, 'Gregor', 'Krmpotić', 32100, 100009, 7.90, NULL, NULL),
  	(411, 'Kristian', 'Damjančić', 48000, 100010, 8.30, NULL, NULL),
  	(416, 'Željka', 'Bello', 10000, 100026, 9.50, NULL, NULL),
  	(420, 'Bernard', 'Jurjević', 33000, 100001, 9.90, NULL, NULL),
  	(424, 'Blaž', 'Bartolović', 10000, 100026, 3.30, NULL, NULL),
  	(428, 'Mirna', 'Ban', 10000, 100003, 3.70, NULL, NULL),
  	(432, 'Bojan', 'Bračić', 10000, 100004, 4.10, NULL, NULL),
  	(436, 'Karla', 'Glasnović', 31500, 100005, 4.50, NULL, NULL),
  	(440, 'Miroslav', 'Pongrac', 51550, 100025, 4.90, NULL, NULL),
  	(444, 'Ilija', 'Marasović', 10000, 100007, 5.30, NULL, NULL),
  	(448, 'Mladen', 'Butković', 10000, 100008, 5.70, NULL, NULL),
  	(452, 'Viktor', 'Kuzmić', 31000, 100009, 3.10, NULL, NULL),
  	(456, 'Slavica', 'Haban', 10000, 100010, 3.50, NULL, NULL),
  	(460, 'Ivana', 'Košanski', 10000, 100011, 3.90, NULL, NULL),
  	(465, 'Vinko', 'Belošević', 10000, 100001, 5.10, NULL, NULL),
  	(469, 'Ivana', 'Dumančić', 10000, 100002, 5.50, NULL, NULL),
  	(473, 'Ive', 'Pisarović', 10000, 100003, 5.90, NULL, NULL),
  	(477, 'Gordan', 'Štampar', 21000, 100004, 6.30, NULL, NULL),
  	(481, 'Iva', 'Habuš', 10000, 100005, 6.70, NULL, NULL),
  	(485, 'Ivo', 'Lovrić', 10000, 100025, 7.10, NULL, NULL),
  	(489, 'Vladimir', 'Vinković', 10000, 100007, 7.50, NULL, NULL),
  	(493, 'Vlado', 'Burela', 31000, 100025, 7.90, NULL, NULL),
  	(497, 'Hrvoje', 'Mandić', 42000, 100009, 8.30, NULL, NULL),
  	(501, 'Davorin', 'Rodinis', 48000, 100010, 8.70, NULL, NULL),
  	(505, 'Jerko', 'Zovko', 52000, 100011, 9.10, NULL, NULL),
  	(509, 'Petar', 'Posavčević', 10000, 100001, 9.50, NULL, NULL),
  	(514, 'Damjan', 'Dolar', 10000, 100002, 3.70, NULL, NULL),
  	(518, 'Josipa', 'Prokopić', 21000, 100026, 4.10, NULL, NULL);
  /*!40000 ALTER TABLE `nastavnik` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.orgjed
  DROP TABLE IF EXISTS `orgjed`;
  CREATE TABLE IF NOT EXISTS `orgjed` (
    `sifOrgjed` int(10) unsigned NOT NULL,
    `nazOrgjed` char(60) COLLATE utf8_unicode_ci NOT NULL,
    `sifNadorgjed` int(10) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`sifOrgjed`),
    KEY `sifNadorgjed` (`sifNadorgjed`),
    CONSTRAINT `orgjed_ibfk_1` FOREIGN KEY (`sifNadorgjed`) REFERENCES `orgjed` (`sifOrgjed`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.orgjed: ~134 rows (approximately)
  /*!40000 ALTER TABLE `orgjed` DISABLE KEYS */;
  INSERT INTO `orgjed` (`sifOrgjed`, `nazOrgjed`, `sifNadorgjed`, `created_at`, `updated_at`) VALUES
  	(6, 'Farmaceutsko-biokemijski fakultet', 9996, NULL, NULL),
  	(7, 'Geodetski fakultet', 9996, NULL, NULL),
  	(9, 'Filozofski fakultet u Rijeci', 9998, NULL, NULL),
  	(10, 'Ekonomski fakultet', 9997, NULL, NULL),
  	(11, 'Kemijsko-tehnološki fakultet', 9999, NULL, NULL),
  	(13, 'Edukacijsko-rehabilitacijski fakultet', 9996, NULL, NULL),
  	(15, 'Fakultet političkih znanosti', 9996, NULL, NULL),
  	(16, 'Fakultet organizacije i informatike u Varaždinu', 9996, NULL, NULL),
  	(18, 'Pravni fakultet', 9999, NULL, NULL),
  	(23, 'Fakultet elektrotehnike, strojarstva i brodogradnje', 9999, NULL, NULL),
  	(33, 'Fakultet za turizam i vanjsku trgovinu', 9999, NULL, NULL),
  	(34, 'Fakultet za fizičku kulturu', 9996, NULL, NULL),
  	(36, 'Fakultet elektrotehnike i računarstva', 9996, NULL, NULL),
  	(37, 'Prirodoslovno-matematički fakultet Matematički odjel', 9996, NULL, NULL),
  	(53, 'Veterinarski fakultet', 9996, NULL, NULL),
  	(54, 'Arhitektonski fakultet', 9996, NULL, NULL),
  	(55, 'Ekonomski fakultet', 9999, NULL, NULL),
  	(58, 'Prehrambeno-biotehnološki fakultet', 9996, NULL, NULL),
  	(62, 'Medicinski fakultet', 9998, NULL, NULL),
  	(63, 'Medicinski fakultet', 9999, NULL, NULL),
  	(65, 'Stomatološki fakultet', 9996, NULL, NULL),
  	(66, 'Pravni fakultet', 9996, NULL, NULL),
  	(67, 'Ekonomski fakultet', 9996, NULL, NULL),
  	(68, 'Šumarski fakultet', 9996, NULL, NULL),
  	(69, 'Tehnički fakultet', 9998, NULL, NULL),
  	(70, 'Filozofski fakultet', 9999, NULL, NULL),
  	(79, 'Poljoprivredni fakultet', 9997, NULL, NULL),
  	(81, 'Ekonomski fakultet', 9998, NULL, NULL),
  	(82, 'Građevinski fakultet', 9996, NULL, NULL),
  	(83, 'Građevinski fakultet', 9999, NULL, NULL),
  	(108, 'Medicinski fakultet', 9996, NULL, NULL),
  	(111, 'Pravni fakultet', 9997, NULL, NULL),
  	(113, 'Prehrambeno tehnološki fakultet', 9997, NULL, NULL),
  	(114, 'Građevinski fakultet', 9998, NULL, NULL),
  	(115, 'Pravni fakultet', 9998, NULL, NULL),
  	(116, 'Hotelijerski fakultet', 9998, NULL, NULL),
  	(117, 'Tekstilno-tehnološki fakultet', 9996, NULL, NULL),
  	(119, 'Prirodoslovno-matematički fakultet Prirodoslovni odsjeci', 9996, NULL, NULL),
  	(120, 'Fakultet strojarstva i brodogradnje', 9996, NULL, NULL),
  	(122, 'Pedagoški fakultet', 9997, NULL, NULL),
  	(124, 'Metalurški fakultet', 9996, NULL, NULL),
  	(125, 'Fakultet kemijskog inženjerstva i tehnologije', 9996, NULL, NULL),
  	(128, 'Grafički fakultet', 9996, NULL, NULL),
  	(130, 'Filozofski fakultet', 9996, NULL, NULL),
  	(131, 'Učiteljska akademija', 9996, NULL, NULL),
  	(135, 'Fakultet prometnih znanosti', 9996, NULL, NULL),
  	(140, 'Filozofski fakultet u Puli', 9998, NULL, NULL),
  	(145, 'Fakultet ekonomije i turizma "Dr. Mijo Mirković"', 9998, NULL, NULL),
  	(149, 'Građevinski fakultet', 9997, NULL, NULL),
  	(152, 'Strojarski fakultet', 9997, NULL, NULL),
  	(160, 'Geotehnički fakultet', 9996, NULL, NULL),
  	(165, 'Elektrotehnički fakultet', 9997, NULL, NULL),
  	(177, 'Fakultet prirodoslovno matematičkih znanosti i odgojnih podr', 9999, NULL, NULL),
  	(178, 'Agronomski fakultet', 9996, NULL, NULL),
  	(195, 'Rudarsko-geološko-naftni fakultet', 9996, NULL, NULL),
  	(203, 'Katolički bogoslovni fakultet', 9996, NULL, NULL),
  	(215, 'Umjetnička akademija', 9999, NULL, NULL),
  	(224, 'Veleučilište u Dubrovniku', NULL, NULL, NULL),
  	(236, 'Medicinski fakultet', 9997, NULL, NULL),
  	(239, 'Odjel za pomorstvo u Rijeci', 9998, NULL, NULL),
  	(245, 'Odjel za pomorstvo u Splitu', 9999, NULL, NULL),
  	(262, 'Visoka učiteljska škola', 9999, NULL, NULL),
  	(263, 'Visoka učiteljska škola', 9999, NULL, NULL),
  	(264, 'Visoka učiteljska škola', 9998, NULL, NULL),
  	(265, 'Visoka učiteljska škola', 9998, NULL, NULL),
  	(266, 'Visoka učiteljska škola', 9998, NULL, NULL),
  	(267, 'Visoka učiteljska škola', 9997, NULL, NULL),
  	(302, 'Studij poslovne informatike', 9996, NULL, NULL),
  	(381, 'Akademija likovnih umjetnosti', 9996, NULL, NULL),
  	(1053, 'Akademija dramske umjetnosti', 9996, NULL, NULL),
  	(1298, 'Katolički bogoslovni fakultet', 9999, NULL, NULL),
  	(1349, 'Muzička akademija', 9996, NULL, NULL),
  	(2223, 'Hrvatski studiji', 9996, NULL, NULL),
  	(2241, 'Nautički odjel', 224, NULL, NULL),
  	(2242, 'Strojarski odjel', 224, NULL, NULL),
  	(2243, 'Odjel elektrotehnike i računarstva', 224, NULL, NULL),
  	(2244, 'Turistički odjel', 224, NULL, NULL),
  	(8888, 'SPECIMEN', 9996, NULL, NULL),
  	(9996, 'Sveučilište u Zagrebu', NULL, NULL, NULL),
  	(9997, 'Sveučilište u Osijeku', NULL, NULL, NULL),
  	(9998, 'Sveučilište u Rijeci', NULL, NULL, NULL),
  	(9999, 'Sveučilište u Splitu', NULL, NULL, NULL),
  	(100001, 'Zavod za primijenjenu fiziku', 36, NULL, NULL),
  	(100002, 'Zavod za primijenjenu matematiku', 36, NULL, NULL),
  	(100003, 'Zavod za osnove elektrotehnike i električka mjerenja', 36, NULL, NULL),
  	(100004, 'Zavod za elektrostrojarstvo i automatizaciju', 36, NULL, NULL),
  	(100005, 'Zavod za visoki napon i energetiku', 36, NULL, NULL),
  	(100006, 'Zavod za telekomunikacije', 36, NULL, NULL),
  	(100007, 'Zavod za elektroničke sustave i obradbu informacija', 36, NULL, NULL),
  	(100008, 'Zavod za automatiku i procesno računarstvo', 36, NULL, NULL),
  	(100009, 'Zavod za elektroakustiku', 36, NULL, NULL),
  	(100010, 'Zavod za elektroniku, mikroelektroniku, računalne i intelige', 36, NULL, NULL),
  	(100011, 'Zavod za radiokomunikacije i visokofrekvencijsku elektroniku', 36, NULL, NULL),
  	(100012, 'Centar informacijske potpore', 36, NULL, NULL),
  	(100013, 'Služba održavanja', 100017, NULL, NULL),
  	(100015, 'Studentska služba', 100017, NULL, NULL),
  	(100016, 'Opća i kadrovska služba', 100017, NULL, NULL),
  	(100017, 'Tajništvo', 36, NULL, NULL),
  	(100020, 'Računovodstvo', 100017, NULL, NULL),
  	(100021, 'Bibliotekarska služba', 100017, NULL, NULL),
  	(100023, 'Grupa za fiziku', 100001, NULL, NULL),
  	(100024, 'Grupa fizikalnih osnova novih energetskih tehnologija', 100001, NULL, NULL),
  	(100025, 'Grupa za primijenjenu matematiku', 100002, NULL, NULL),
  	(100026, 'Grupa računarskih znanosti', 100002, NULL, NULL),
  	(100027, 'Grupa za osnove elektrotehnike', 100003, NULL, NULL),
  	(100028, 'Grupa za mjerenja u elektrotehnici', 100003, NULL, NULL),
  	(100029, 'Grupa za električne strojeve', 100004, NULL, NULL),
  	(100030, 'Grupa za regulaciju električnih strojeva', 100004, NULL, NULL),
  	(100031, 'Grupa za tehnologiju', 100004, NULL, NULL),
  	(100032, 'Grupa za mehaničke konstrukcije', 100004, NULL, NULL),
  	(100033, 'Grupa za električne aparate', 100004, NULL, NULL),
  	(100034, 'Grupa za energetsku elektroniku', 100004, NULL, NULL),
  	(100035, 'Grupa za elektrometriju', 36, NULL, NULL),
  	(100036, 'Grupa za električnu vuču', 100004, NULL, NULL),
  	(100037, 'Grupa za metode organizacije', 36, NULL, NULL),
  	(100038, 'Grupa za električna postrojenja', 100005, NULL, NULL),
  	(100039, 'Grupa za nuklearne elektrane', 100005, NULL, NULL),
  	(100040, 'Grupa za prijenos električne energije', 100005, NULL, NULL),
  	(100041, 'Grupa za električnu rasvjetu', 100005, NULL, NULL),
  	(100042, 'Grupa za električne željeznice', 100005, NULL, NULL),
  	(100043, 'Grupa za telekomunikacije i informatiku', 100006, NULL, NULL),
  	(100044, 'Grupa za mreže, sisteme i signale', 100007, NULL, NULL),
  	(100045, 'Grupa za elektronička mjerenja i biomedicinsku elektroniku', 100007, NULL, NULL),
  	(100046, 'Grupa za automatsko upravljanje sistemima', 100008, NULL, NULL),
  	(100047, 'Grupa za računarske sisteme i procese', 100008, NULL, NULL),
  	(100048, 'Grupa za tonfrekvencijsku i prijemničku elektroniku', 100009, NULL, NULL),
  	(100049, 'Grupa za akustiku i elektroakustiku', 100009, NULL, NULL),
  	(100050, 'Grupa za elektroničke sklopove', 100010, NULL, NULL),
  	(100051, 'Grupa za računarsku tehniku', 100010, NULL, NULL),
  	(100052, 'Grupa za radiokomunikacijske sustave', 100011, NULL, NULL),
  	(100053, 'Grupa za visokofrekvencijsku elektroniku', 100011, NULL, NULL),
  	(100054, 'Grupa za strani jezik', 100002, NULL, NULL),
  	(100062, 'Grupa za teoretsku elektrotehniku', 100003, NULL, NULL),
  	(100063, 'Grupa za energetsku elektrotehniku', 100004, NULL, NULL);
  /*!40000 ALTER TABLE `orgjed` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.password_resets
  DROP TABLE IF EXISTS `password_resets`;
  CREATE TABLE IF NOT EXISTS `password_resets` (
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`),
    KEY `password_resets_token_index` (`token`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.password_resets: ~0 rows (approximately)
  /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
  /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.pred
  DROP TABLE IF EXISTS `pred`;
  CREATE TABLE IF NOT EXISTS `pred` (
    `sifPred` int(10) unsigned NOT NULL,
    `kratPred` char(8) COLLATE utf8_unicode_ci DEFAULT NULL,
    `nazPred` char(60) COLLATE utf8_unicode_ci NOT NULL,
    `sifOrgjed` int(10) unsigned DEFAULT NULL,
    `upisanoStud` int(11) DEFAULT NULL,
    `brojSatiTjedno` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`sifPred`),
    KEY `sifOrgjed` (`sifOrgjed`),
    CONSTRAINT `pred_ibfk_1` FOREIGN KEY (`sifOrgjed`) REFERENCES `orgjed` (`sifOrgjed`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.pred: ~182 rows (approximately)
  /*!40000 ALTER TABLE `pred` DISABLE KEYS */;
  INSERT INTO `pred` (`sifPred`, `kratPred`, `nazPred`, `sifOrgjed`, `upisanoStud`, `brojSatiTjedno`, `created_at`, `updated_at`) VALUES
  	(36, 'TEHNO', 'Elektrotehnička tehnologija', 100003, 2, 2, NULL, NULL),
  	(37, 'EEL', 'Energetska elektronika', 100005, 6, 2, NULL, NULL),
  	(39, 'RASAKO', 'Radiorelejne i satelitske komunikacije', 100011, 6, 3, NULL, NULL),
  	(43, 'ELAK', 'Elektroakustika', 100009, 0, 4, NULL, NULL),
  	(47, 'MUE', 'Mjerenja u elektrotehnici', 100003, 0, 2, NULL, NULL),
  	(53, 'ELTER', 'Elektrotermija', 100001, 1, 1, NULL, NULL),
  	(56, 'GOMUAK', 'Govorna i muzička akustika', 100009, 2, 3, NULL, NULL),
  	(57, 'INSKEE', 'Integrirani sklopovi energetske elektronike', 100005, 6, NULL, NULL, NULL),
  	(58, 'KOELU', 'Komponente elektroničkih uređaja i mjerne metode', 100010, 3, NULL, NULL, NULL),
  	(59, 'KVELUR', 'Kvaliteta elektroakustičkih uređaja', 100009, 0, 3, NULL, NULL),
  	(68, 'PORAK', 'Pokretne radiokomunikacije', 100011, 5, 4, NULL, NULL),
  	(70, 'PRAPO', 'Projektiranje radiofrekvencijskih pojačala', 100011, 2, 2, NULL, NULL),
  	(71, 'PROAK', 'Prostorna akustika', 100009, 0, 2, NULL, NULL),
  	(76, 'ULHID', 'Ultrazvuk i hidroakustika', 100009, 70, 3, NULL, NULL),
  	(98, 'EKELS', 'Ekonomika elektroničkih sistema', 100010, 45, NULL, NULL, NULL),
  	(99, 'EKONEN', 'Ekonomika u energetici', 100005, 21, 2, NULL, NULL),
  	(101, 'ELSTR1', 'Električki strojevi I', 100004, 1, 2, NULL, NULL),
  	(102, 'ELIZNA', 'Elektronički izvori napajanja', 100010, 5, 3, NULL, NULL),
  	(103, 'ELKOS', 'Elektronički komutacijski sistemi', 100010, 10, 4, NULL, NULL),
  	(104, 'EEL-IP', 'Energetska elektronika-izabrana poglavlja', 100005, 110, 3, NULL, NULL),
  	(105, 'EEL', 'Energetska elektronika', 100005, 1, NULL, NULL, NULL),
  	(106, 'FLASER', 'Fizika lasera', 100001, 2, 1, NULL, NULL),
  	(107, 'FOSE', 'Fizikalne osnove spremanja energije', 100001, 70, 2, NULL, NULL),
  	(143, 'OPES', 'Optimalni pogon elektroenergetskog sustava', 100005, 1, 3, NULL, NULL),
  	(144, 'OETEM', 'Organizacija i eksploatacija telekomunikacijske mreže', 100006, 2, NULL, NULL, NULL),
  	(146, 'ORAKOM', 'Osnove radiokomunikacija', 100011, 8, 2, NULL, NULL),
  	(147, 'OELAK', 'Osnove elektroakustike', 100009, 0, 3, NULL, NULL),
  	(162, 'PIESS', 'Projektiranje integriranih elektroničkih sklopova', 100010, 0, 2, NULL, NULL),
  	(164, 'PIP', 'Projektiranje industrijskih postrojenja', 100004, 0, NULL, NULL, NULL),
  	(166, 'ZPM06A2', 'Projektiranje programske podrške', 100002, 1, 4, NULL, NULL),
  	(167, 'PROTEM', 'Projektiranje telekomunikacijskih mreža', 100006, 18, 1, NULL, NULL),
  	(169, 'RAKOM', 'Radiokomunikacije', 100011, 1, NULL, NULL, NULL),
  	(174, 'RESE', 'Regulacija električkih strojeva u elektranama', 100004, 1, 3, NULL, NULL),
  	(181, 'STAEES', 'Stabilnost elektroenergetskih sistema', 100005, 2, 3, NULL, NULL),
  	(194, 'UNUF', 'Uvod u nuklearnu fiziku', 100001, 14, 4, NULL, NULL),
  	(199, 'OSKLOP', 'Osnovni elektronički sklopovi', 100010, 0, 2, NULL, NULL),
  	(207, 'TEMRE', 'Telekomunikacijske mreže', 100006, 0, 2, NULL, NULL),
  	(209, 'ELENS', 'Elektroenergetski sistem', 100005, 10, NULL, NULL, NULL),
  	(229, 'OEEN', 'Osnove elektroenergetike', 100005, 25, 3, NULL, NULL),
  	(232, 'SISTR', 'Sinkroni strojevi', 100004, 1, NULL, NULL, NULL),
  	(234, 'PTEP', 'Prelaz topline u energ. postrojenjima', 100004, 2, NULL, NULL, NULL),
  	(238, 'ELSKLOP', 'Elektronički sklopovi', 100010, 10, 3, NULL, NULL),
  	(241, 'EINKO', 'Elektronička instrumentacija i konstrukcije', 100010, 9, 4, NULL, NULL),
  	(249, 'ELMJE', 'Elektronička mjerenja i komponente', 100010, 0, 3, NULL, NULL),
  	(253, 'ESIB', 'Energetski sistemi i bilance', 100005, 2, 2, NULL, NULL),
  	(254, 'FIZ3', 'Fizika III', 100001, 0, 2, NULL, NULL),
  	(256, 'NUMAT', 'Numerička matematika', 100002, 2, 4, NULL, NULL),
  	(258, 'OPEF', 'Odabrana poglavlja energetske fizike', 100001, 1, 3, NULL, NULL),
  	(259, 'OPOMAT', 'Odabrana poglavlja matematike', 100002, 25, 2, NULL, NULL),
  	(260, 'OES', 'Osnove električkih strojeva', 100004, 0, NULL, NULL, NULL),
  	(262, 'STOMAT', 'Stohastička matematika', 100002, 20, 1, NULL, NULL),
  	(264, 'ELRAČ', 'Elektronička računala', 100010, 32, NULL, NULL, NULL),
  	(265, 'ELEL1', 'Elektronički elementi', 100010, 21, 2, NULL, NULL),
  	(266, 'ZFI01O1', 'Fizika I', 100001, 70, 4, NULL, NULL),
  	(267, 'ZFI02O2', 'Fizika II', 100001, 2, 3, NULL, NULL),
  	(271, 'FOE', 'Fizikalne osnove elektrotehnike', 100003, 0, 2, NULL, NULL),
  	(273, 'OE', 'Osnove elektrotehnike', 100003, 2, NULL, NULL, NULL),
  	(277, 'TEOREL', 'Teoretska elektrotehnika', 100003, 1, 1, NULL, NULL),
  	(278, 'EENMR3', 'Elektroenergetske mreže III', 100005, 5, 2, NULL, NULL),
  	(282, 'EENMR1', 'Elektroenergetske mreže I', 100005, 5, 2, NULL, NULL),
  	(284, 'ELSKLOP', 'Elektronički sklopovi', 100010, 10, 4, NULL, NULL),
  	(285, 'RADAR', 'Radari i radiokomunikacije', 100011, 2, 3, NULL, NULL),
  	(286, 'RALOTE', 'Radiolokacija i radiotelemetrija', 100011, 13, 2, NULL, NULL),
  	(288, 'INE03O6', 'Elektronička instrumentacija', 100010, 15, 1, NULL, NULL),
  	(301, 'EPROC', 'Energetski procesi', 100005, 2, 2, NULL, NULL),
  	(303, 'MAT1', 'Matematika I', 100002, 6, 3, NULL, NULL),
  	(304, 'MAT2', 'Matematika II', 100002, 6, 2, NULL, NULL),
  	(305, 'MAT3', 'Matematika III', 100002, 17, 2, NULL, NULL),
  	(307, 'ISKLOP', 'Integrirani elektronički sklopovi', 100010, 0, 2, NULL, NULL),
  	(312, 'UNUF', 'Uvod u nuklearnu fiziku', 100001, 13, NULL, NULL, NULL),
  	(342, 'NEP-K', 'Nuklearna energetska postrojenja - konstrukcijske vježbe', 100004, 0, 2, NULL, NULL),
  	(343, 'ZPM01O1', 'Linearna algebra', 100002, 110, 3, NULL, NULL),
  	(344, 'ZPM02O1', 'Matematička analiza I', 100002, 70, NULL, NULL, NULL),
  	(345, 'ZOM01O1', 'Osnove elektrotehnike I', 100003, 1, 2, NULL, NULL),
  	(346, 'ZPM03O1', 'Primjena računala', 100002, 17, 3, NULL, NULL),
  	(347, 'ZPM04O2', 'Matematička analiza II', 100002, 0, 4, NULL, NULL),
  	(348, 'ZOM02O2', 'Osnove elektrotehnike II', 100003, 3, NULL, NULL, NULL),
  	(349, 'ZPM2002', 'Programiranje', 100002, 15, 2, NULL, NULL),
  	(351, 'ZPM06O3', 'Matematička analiza III', 100002, 1, 1, NULL, NULL),
  	(352, 'ZOM03O3', 'Mjerenja u elektrotehnici', 100003, 2, NULL, NULL, NULL),
  	(353, 'ZSE01O3', 'Energetska elektrotehnika', 100003, 0, 2, NULL, NULL),
  	(354, 'ZER3001', 'Elektronički elementi', 100010, 0, 3, NULL, NULL),
  	(355, 'ZPM07O3', 'Algoritmi i strukture podataka', 100002, 5, 4, NULL, NULL),
  	(356, 'ZPM4001', 'Stohastička i numerička matematika', 100002, 13, 2, NULL, NULL),
  	(357, 'ZPM4002', 'Diskretna i stohastička matematika', 100002, 20, 2, NULL, NULL),
  	(358, 'ZOM03O4', 'Mjerenja u elektrotehnici-praktikum', 100003, 0, 3, NULL, NULL),
  	(361, 'ZRS01O4', 'Osnove digitalnih računala', 100008, 0, NULL, NULL, NULL),
  	(362, 'ZER4002', 'Elektronički sklopovi', 100010, 40, 2, NULL, NULL),
  	(367, 'ZFI03O5', 'Fizika materijala', 100001, 45, 3, NULL, NULL),
  	(370, 'AUT6003', 'Elektronička instrumentacija i mjerenja', 100010, 17, 4, NULL, NULL),
  	(371, 'ZER15A2', 'Složeni elektronički sklopovi', 100010, 8, 2, NULL, NULL),
  	(372, 'ENE04O6', 'Osnove energetske elektronike', 100005, 18, 1, NULL, NULL),
  	(373, 'ZRS11A2', 'Analiza osjetljivosti, sinteza i optimiranje sustava', 100008, 0, 3, NULL, NULL),
  	(374, 'ZRS17A2', 'Procesna mjerenja', 100008, 0, 2, NULL, NULL),
  	(376, 'ZRS12A2', 'Otvoreno računarstvo', 100008, 0, 3, NULL, NULL),
  	(378, 'ZPM05A2', 'Matematičke osnove optimalnog upravljanja', 100002, 25, 2, NULL, NULL),
  	(382, 'ENE02O5', 'Električni strojevi i transformatori', 100004, 0, 4, NULL, NULL),
  	(384, 'ZOM04O5', 'Teorijska elektrotehnika', 100003, 1, 2, NULL, NULL),
  	(390, 'ESA07O6', 'Osnove čvrstoće i konstruiranja', 100004, 2, 2, NULL, NULL),
  	(391, 'ESA5001', 'Osnove električnih strojeva i transformatora', 100004, 0, 2, NULL, NULL),
  	(392, 'ESA02O5', 'Energetska elektronika', 100004, 2, 2, NULL, NULL),
  	(393, 'ESA03O5', 'Elektrotehnički materijali i tehnologija', 100004, 110, 4, NULL, NULL),
  	(394, 'ESA6002', 'Kolektorski i elektronički komutirani motori', 100004, 1, NULL, NULL, NULL),
  	(397, 'INE01O5', 'Elektronička mjerenja i komponente', 100010, 2, 2, NULL, NULL),
  	(404, 'RKP03O5', 'Elektroakustika', 100009, 0, 3, NULL, NULL),
  	(407, 'RKP09O7', 'Optoelektronički sklopovi', 100010, 70, 4, NULL, NULL),
  	(410, 'TKI03O5', 'Telekomunikacijske mreže', 100006, 0, 2, NULL, NULL),
  	(414, 'ZPM11O5', 'Programske paradigme i jezici', 100002, 2, 3, NULL, NULL),
  	(419, 'ZPM02A1', 'Operacijska istraživanja', 100002, 10, 1, NULL, NULL),
  	(420, 'ENE6101', 'Energetski izvori', 100005, 9, 2, NULL, NULL),
  	(423, 'IRB01A1', 'Fizika poluvodiča', 100001, 11, 2, NULL, NULL),
  	(425, 'ZPM01A1', 'Stohastički procesi', 100002, 70, 2, NULL, NULL),
  	(429, 'ZPM09O4', 'Numerička matematika', 100002, 8, NULL, NULL, NULL),
  	(430, 'AUT5002', 'Elektronička računala', 100010, 3, 2, NULL, NULL),
  	(439, 'ZPM08O4', 'Stohastička matematika', 100002, 18, 1, NULL, NULL),
  	(441, 'ZPM10O4', 'Diskretna matematika', 100002, 17, 4, NULL, NULL),
  	(450, 'ENE01O5', 'Energetski procesi', 100005, 11, NULL, NULL, NULL),
  	(452, 'ENE08O7', 'Elektroenergetske mreže', 100005, 0, 2, NULL, NULL),
  	(453, 'ENE09O7', 'Numerička analiza elektroenergetskog sustava', 100005, 2, 3, NULL, NULL),
  	(458, 'ENE14O8', 'Zaštita i automatika elektroenergetskog sustava', 100005, 5, NULL, NULL, NULL),
  	(459, 'ENE15O8', 'Energetika i okoliš', 100005, 9, 2, NULL, NULL),
  	(461, 'ESA04O6', 'Regulacijska tehnika', 100004, 2, 3, NULL, NULL),
  	(464, 'ESA10O7', 'Elektromotorni pogoni', 100004, 0, 4, NULL, NULL),
  	(465, 'ESA11O7', 'Upravljanje elektromotornim pogonima', 100004, 0, 2, NULL, NULL),
  	(467, 'ESA13O8', 'Projektiranje industrijskih postrojenja', 100004, 0, 2, NULL, NULL),
  	(468, 'ESA14O7', 'Razvod električne energije', 100004, 1, 3, NULL, NULL),
  	(470, 'ESA16O9', 'Mehatronički sustavi', 100004, 2, NULL, NULL, NULL),
  	(474, 'AUT06O6', 'Elektronička mjerenja i instrumentacija', 100010, 12, 1, NULL, NULL),
  	(483, 'INE08O7', 'Mikroelektronički sklopovi', 100010, 0, 3, NULL, NULL),
  	(489, 'RKP08O7', 'Osnove radiokomunikacijskih sustava', 100011, 6, 2, NULL, NULL),
  	(490, 'RKP10O7', 'Elektroakustički signali i sustavi', 100009, 0, 4, NULL, NULL),
  	(500, 'TKI11O8', 'Pouzdanost telekomunikacijskih sustava', 100006, 1, 2, NULL, NULL),
  	(505, 'ZER07A1', 'Osnove mikroelektroničkih sklopova', 100010, 2, 2, NULL, NULL),
  	(509, 'ZFI03A2', 'Fizika lasera', 100001, 0, 3, NULL, NULL),
  	(515, 'ZVF01A1', 'Radiolokacija i navigacija', 100011, 10, 2, NULL, NULL),
  	(517, 'ZEA01A1', 'Ultrazvuk i hidroakustika', 100009, 70, 3, NULL, NULL),
  	(525, 'ZPM03A1', 'Projektiranje informacijskih sustava', 100002, 10, 3, NULL, NULL),
  	(528, 'ZRS16A2', 'Upravljanje, slijedni sustavi i senzori u robotici', 100008, 3, NULL, NULL, NULL),
  	(529, 'FSB13A2', 'Regulacija u energetskim postrojenjima', 100004, 0, 2, NULL, NULL),
  	(532, 'ZES15A1', 'Sklopni i zaštitni uređaji u postrojenjima', 100004, 1, 3, NULL, NULL),
  	(535, 'ZES12A2', 'Projektiranje i konstruiranje u elektrostrojarstvu', 100004, 2, 4, NULL, NULL),
  	(541, 'ZEN01A1', 'Pouzdanost elektroenergetskog sustava', 100005, 5, 2, NULL, NULL),
  	(545, 'IHP10A2', 'Energetski izvori', 100005, 3, 2, NULL, NULL),
  	(548, 'ZEN04A1', 'Ekonomika u energetici', 100005, 0, 3, NULL, NULL),
  	(549, 'ZEN03A1', 'Numerički postupci u elektroenergetici', 100005, 5, 1, NULL, NULL),
  	(554, 'ESA02O5', 'Energetska elektronika', 100004, 18, 1, NULL, NULL),
  	(576, 'ZEN09B1', 'Dinamika elektroenergetskog sustava', 100005, 8, 2, NULL, NULL),
  	(580, 'ZRS01A1', 'Adaptivno i robusno upravljanje', 100008, 0, 3, NULL, NULL),
  	(583, 'ZPM04B1', 'Objektno orijentirano programiranje', 100002, 21, 4, NULL, NULL),
  	(588, 'ZRS05B1', 'Inteligentno upravljanje sustavima', 100008, 0, 4, NULL, NULL),
  	(589, 'ZRS09B1', 'Identifikacija procesa', 100008, 70, 2, NULL, NULL),
  	(590, 'ZRS06B1', 'Automatizacija brodskih procesa', 100008, 1, 2, NULL, NULL),
  	(594, 'ZES09B1', 'Elektronički pretvarači za elektromotorne pogone', 100010, 23, 3, NULL, NULL),
  	(595, 'ESA15O8', 'Automatizirana ispitivanja elektrotehničkih uređaja', 100004, 0, NULL, NULL, NULL),
  	(596, 'ZRS02A1', 'Alarmni sustavi', 100008, 5, 2, NULL, NULL),
  	(604, 'ZES16A1', 'Sinkroni strojevi i uzbude', 100004, 0, 3, NULL, NULL),
  	(605, 'ZRS07B1', 'Odabrana poglavlja iz programskog inženjerstva', 100008, 1, NULL, NULL, NULL),
  	(607, 'ZVF11B1', 'Projektiranje radiofrekvencijskih pojačala', 100011, 20, 3, NULL, NULL),
  	(609, 'ZVF04A1', 'Numerički postupci u radiokomunikacijama', 100011, 23, 1, NULL, NULL),
  	(610, 'ZRS10B1', 'Vođenje projekata automatike', 100008, 0, 3, NULL, NULL),
  	(611, 'ZRS03B1', 'Vođenje i upravljanje plovila', 100008, 1, 4, NULL, NULL),
  	(612, 'ZRS08B1', 'Realizacija upravljačkih algoritama i računalnih arhitektura', 100008, 0, 2, NULL, NULL),
  	(615, 'ZVF09B1', 'Tehnologija radiofrekvencijskih komponenata', 100011, 0, NULL, NULL, NULL),
  	(621, 'TKI05B1', 'Razvoj telekomunikacijske programske podrške', 100006, 1, 2, NULL, NULL),
  	(627, 'TKI08B1', 'Organizacija telekomunikacijske mreže', 100006, 2, 3, NULL, NULL),
  	(628, 'TKI09B1', 'Informacijski sustav telekmunikacijske mreže', 100006, 0, 4, NULL, NULL),
  	(634, 'ZVF05A1', 'Radiotelemetrija', 100011, 0, 2, NULL, NULL),
  	(636, 'ZEA03A1', 'Psihoakustika', 100009, 1, 3, NULL, NULL),
  	(637, 'ZEA05A1', 'Govorna i glazbena akustika', 100009, 2, NULL, NULL, NULL),
  	(641, 'ESA17O6', 'Električni strojevi', 100004, 70, 2, NULL, NULL),
  	(642, 'ESA01O5', 'Elektromehanička i elektromagnetska pretvorba', 100004, 0, 3, NULL, NULL),
  	(643, 'ESA19O8', 'Razvoj elektrotehničkih proizvoda', 100004, 5, 2, NULL, NULL),
  	(646, 'ZPM06A2', 'Projektiranje programske podrške', 100002, 29, 2, NULL, NULL),
  	(650, 'ZPM05O2', 'Programiranje', 100002, 17, 2, NULL, NULL),
  	(652, 'ZRS16A2', 'Fleksibilni proizvodni sustavi', 100008, 18, 1, NULL, NULL),
  	(653, 'ZRS08B1', 'Realizacija algoritama i računalnih arhitektura', 100008, 1, 2, NULL, NULL),
  	(654, 'Z0M03O3', 'Mjerenja u elektrotehnici', 100003, 2, 2, NULL, NULL),
  	(656, 'ZPM06A2', 'Ergonomija računalne i programske opreme', 100002, 0, 3, NULL, NULL),
  	(657, 'ZRS09B1', 'Identifikacija procesa', 100008, 70, NULL, NULL, NULL),
  	(658, 'ZPM07A1', 'Osnove baza podataka', 100002, 15, 2, NULL, NULL),
  	(662, 'ENE15O8', 'Energetika i okoliš', 100005, 1, 3, NULL, NULL),
  	(669, 'ZOM03O3', 'Mjerenja u elektrotehnici', 100003, 2, 4, NULL, NULL);
  /*!40000 ALTER TABLE `pred` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.rezervacija
  DROP TABLE IF EXISTS `rezervacija`;
  CREATE TABLE IF NOT EXISTS `rezervacija` (
    `oznDvorana` char(5) NOT NULL,
    `oznVrstaDan` char(2) NOT NULL,
    `sat` smallint(6) NOT NULL,
    `sifPred` int(10) unsigned NOT NULL,
    KEY `oznDvorana` (`oznDvorana`),
    KEY `sifPred` (`sifPred`),
    CONSTRAINT `FK_rezervacija_dvorana` FOREIGN KEY (`oznDvorana`) REFERENCES `dvorana` (`oznDvorana`),
    CONSTRAINT `FK_rezervacija_pred` FOREIGN KEY (`sifPred`) REFERENCES `pred` (`sifPred`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- Dumping data for table fakultet.rezervacija: ~89 rows (approximately)
  /*!40000 ALTER TABLE `rezervacija` DISABLE KEYS */;
  INSERT INTO `rezervacija` (`oznDvorana`, `oznVrstaDan`, `sat`, `sifPred`) VALUES
  	('B1', 'PO', 15, 393),
  	('B1', 'PO', 9, 393),
  	('B2', 'PO', 14, 393),
  	('B2', 'PO', 17, 393),
  	('B3', 'PO', 18, 393),
  	('B3', 'PO', 14, 393),
  	('B1', 'SR', 15, 393),
  	('B2', 'SR', 16, 393),
  	('B3', 'SR', 17, 393),
  	('A101', 'PO', 8, 104),
  	('A101', 'PO', 5, 104),
  	('A101', 'PO', 11, 104),
  	('A101', 'PO', 19, 104),
  	('A101', 'PO', 10, 104),
  	('A101', 'UT', 20, 104),
  	('A101', 'UT', 10, 104),
  	('A101', 'UT', 12, 104),
  	('A101', 'UT', 14, 104),
  	('A102', 'CE', 13, 343),
  	('A101', 'CE', 12, 343),
  	('A209', 'CE', 14, 641),
  	('A210', 'CE', 20, 641),
  	('A209', 'PE', 14, 641),
  	('A210', 'PE', 15, 641),
  	('A204', 'SR', 11, 107),
  	('A204', 'SR', 15, 107),
  	('A205', 'SR', 18, 107),
  	('A205', 'SR', 16, 107),
  	('B1', 'CE', 10, 425),
  	('A101', 'CE', 17, 425),
  	('B1', 'PO', 10, 305),
  	('B1', 'PO', 12, 304),
  	('B2', 'PO', 13, 288),
  	('B3', 'PO', 19, 286),
  	('B3', 'PO', 15, 285),
  	('B1', 'SR', 11, 284),
  	('B2', 'SR', 14, 282),
  	('B3', 'SR', 13, 278),
  	('A101', 'PO', 14, 267),
  	('A101', 'PO', 17, 266),
  	('A101', 'UT', 15, 265),
  	('A101', 'UT', 16, 262),
  	('A101', 'UT', 6, 259),
  	('A102', 'CE', 11, 258),
  	('A101', 'CE', 18, 256),
  	('A210', 'CE', 17, 253),
  	('A204', 'SR', 17, 36),
  	('A204', 'SR', 16, 39),
  	('B1', 'CE', 11, 53),
  	('A101', 'CE', 15, 56),
  	('B2', 'PO', 15, 68),
  	('B3', 'PO', 12, 70),
  	('B1', 'SR', 14, 76),
  	('B3', 'SR', 15, 101),
  	('A101', 'PO', 9, 102),
  	('A101', 'PO', 18, 103),
  	('A101', 'UT', 4, 143),
  	('A101', 'UT', 9, 384),
  	('A101', 'CE', 13, 390),
  	('B1', 'PO', 16, 370),
  	('B1', 'PO', 14, 371),
  	('B2', 'PO', 16, 372),
  	('B1', 'PO', 11, 576),
  	('B2', 'PO', 11, 589),
  	('B3', 'PO', 11, 590),
  	('B3', 'PO', 20, 594),
  	('B2', 'SR', 12, 596),
  	('A101', 'UT', 18, 607),
  	('A102', 'CE', 20, 611),
  	('A210', 'PE', 16, 621),
  	('A204', 'SR', 18, 627),
  	('A205', 'SR', 10, 643),
  	('B1', 'CE', 20, 636),
  	('B1', 'PO', 8, 652),
  	('B2', 'PO', 9, 653),
  	('B3', 'PO', 9, 654),
  	('B2', 'SR', 13, 658),
  	('B3', 'SR', 14, 662),
  	('A101', 'PO', 15, 669),
  	('A101', 'PO', 20, 301),
  	('A101', 'UT', 19, 37),
  	('A102', 'CE', 12, 392),
  	('A204', 'SR', 7, 515),
  	('A204', 'SR', 8, 99),
  	('B1', 'CE', 19, 181),
  	('B2', 'PO', 10, 489),
  	('B1', 'SR', 17, 166),
  	('B3', 'SR', 11, 650),
  	('A111', 'SR', 14, 589);
  /*!40000 ALTER TABLE `rezervacija` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.stud
  DROP TABLE IF EXISTS `stud`;
  CREATE TABLE IF NOT EXISTS `stud` (
    `mbrStud` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `imeStud` char(25) COLLATE utf8_unicode_ci NOT NULL,
    `prezStud` char(25) COLLATE utf8_unicode_ci NOT NULL,
    `pbrRod` int(10) unsigned DEFAULT NULL,
    `pbrStan` int(10) unsigned NOT NULL,
    `datRodStud` datetime DEFAULT NULL,
    `jmbgStud` char(13) COLLATE utf8_unicode_ci NOT NULL,
    `slikaStud` tinyint(1) NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'email za login',
    PRIMARY KEY (`mbrStud`),
    UNIQUE KEY `jmbgStud` (`jmbgStud`),
    UNIQUE KEY `email` (`email`),
    KEY `pbrRod` (`pbrRod`),
    KEY `pbrStan` (`pbrStan`),
    CONSTRAINT `stud_ibfk_1` FOREIGN KEY (`pbrRod`) REFERENCES `mjesto` (`pbr`),
    CONSTRAINT `stud_ibfk_2` FOREIGN KEY (`pbrStan`) REFERENCES `mjesto` (`pbr`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1566 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.stud: ~313 rows (approximately)
  /*!40000 ALTER TABLE `stud` DISABLE KEYS */;
  INSERT INTO `stud` (`mbrStud`, `imeStud`, `prezStud`, `pbrRod`, `pbrStan`, `datRodStud`, `jmbgStud`, `slikaStud`, `created_at`, `updated_at`, `email`) VALUES
  	(1120, 'Zdenko', 'Kolac', 31000, 40000, '1985-06-06 00:00:00', '0606985330186', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zdenko.kolac@algebra.hr'),
  	(1121, 'Danijel', 'Marović', 21000, 10000, '1984-12-18 00:00:00', '1812984330118', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'danijel.marovic@algebra.hr'),
  	(1123, 'Jozefina', 'Antončić', 10000, 10000, '1984-01-21 00:00:00', '2101984330133', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'jozefina.antoncic@algebra.hr'),
  	(1124, 'Tihomir', 'Crnkovich', 34000, 10000, '1985-05-01 00:00:00', '0105985303228', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tihomir.crnkovich@algebra.hr'),
  	(1125, 'Vjeran', 'Brezac', 44000, 44000, '1984-04-12 00:00:00', '1204984335026', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vjeran.brezac@algebra.hr'),
  	(1127, 'Dario', 'Risek', 32000, 32000, '1984-07-19 00:00:00', '1907984362909', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dario.risek@algebra.hr'),
  	(1128, 'Zlatko', 'Broz', 42000, 10000, '1984-03-17 00:00:00', '1703984330099', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zlatko.broz@algebra.hr'),
  	(1129, 'Julija', 'Kos', 51000, 51000, '1985-05-19 00:00:00', '1905985330161', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'julija.kos@algebra.hr'),
  	(1131, 'Zlatko', 'Nenadić', 35000, 35000, '1984-11-17 00:00:00', '1711984395329', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zlatko.nenadic@algebra.hr'),
  	(1132, 'Nikica', 'Arunović', 48000, 48000, '1984-09-01 00:00:00', '0109984330006', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'nikica.arunovic@algebra.hr'),
  	(1133, 'Darko', 'Cindrić', 40000, 10000, '1984-10-18 00:00:00', '1810984330093', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'darko.cindric@algebra.hr'),
  	(1135, 'Juraj', 'Rožman', 42000, 42000, '1984-08-19 00:00:00', '1908984312508', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'juraj.rozman@algebra.hr'),
  	(1136, 'Vlatko', 'Horvatić', 51000, 51000, '1985-06-26 00:00:00', '2606985325027', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vlatko.horvatic@algebra.hr'),
  	(1137, 'Jure', 'Ribarić', 22000, 22000, '1983-11-02 00:00:00', '0211983392304', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'jure.ribaric@algebra.hr'),
  	(1139, 'Niko', 'Marušić', 48000, 48000, '1984-08-22 00:00:00', '2208984173977', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'niko.marusic@algebra.hr'),
  	(1140, 'Davor', 'Vurnek', 20000, 20000, '1984-10-29 00:00:00', '2910984300802', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davor.vurnek@algebra.hr'),
  	(1141, 'Zoran', 'Habajec', 21000, 21000, '1984-07-25 00:00:00', '2507984301807', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zoran.habajec@algebra.hr'),
  	(1143, 'Davor', 'Voras', 20000, 10000, '1985-10-08 00:00:00', '0810985390025', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davor.voras@algebra.hr'),
  	(1144, 'Zvonimir', 'Ozimec', 21000, 21000, '1985-10-08 00:00:00', '0810985390015', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zvonimir.ozimec@algebra.hr'),
  	(1145, 'Jurica', 'Bašić', 10000, 10000, '1985-07-06 00:00:00', '0607985361605', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'jurica.basic@algebra.hr'),
  	(1147, 'Alenka', 'Vukojević', 21000, 21000, '1985-06-14 00:00:00', '1406985311906', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'alenka.vukojevic@algebra.hr'),
  	(1148, 'Antonijo', 'Javorina', 10000, 10000, '1984-07-16 00:00:00', '1607984330068', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antonijo.javorina@algebra.hr'),
  	(1149, 'Nikola', 'Bačić', 20000, 10000, '1984-04-08 00:00:00', '0804984330122', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'nikola.bacic@algebra.hr'),
  	(1151, 'Karlo', 'Krsnik', 10010, 10000, '1984-08-18 00:00:00', '1808984320522', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'karlo.krsnik@algebra.hr'),
  	(1152, 'Božidar', 'Tomić', 20250, 20250, '1985-08-07 00:00:00', '0708985395074', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'bozidar.tomic@algebra.hr'),
  	(1153, 'Josip', 'Dukić', 21270, 10000, '1985-06-23 00:00:00', '2306985330111', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'josip.dukic@algebra.hr'),
  	(1155, 'Davorin', 'Mirković', 32100, 32100, '1985-07-04 00:00:00', '0407985307804', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davorin.mirkovic@algebra.hr'),
  	(1156, 'Nikolina', 'Medvedec', 34340, 10370, '1985-01-27 00:00:00', '2701985381508', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'nikolina.medvedec@algebra.hr'),
  	(1157, 'Nina', 'Cnappi', 44320, 10000, '1985-05-23 00:00:00', '2305985390005', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'nina.cnappi@algebra.hr'),
  	(1159, 'Katarina', 'Dobrina', 52420, 10000, '1985-02-18 00:00:00', '1802985330169', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'katarina.dobrina@algebra.hr'),
  	(1160, 'Majo', 'Musić', 10450, 10000, '1984-10-27 00:00:00', '2710984303508', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'majo.music@algebra.hr'),
  	(1161, 'Davor', 'Jurinjak', 23250, 10000, '1985-05-23 00:00:00', '2305985330103', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davor.jurinjak@algebra.hr'),
  	(1163, 'Davorka', 'Smolić-Grgić', 43280, 10000, '1985-06-27 00:00:00', '2706985391817', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davorka.smolic-grgic@algebra.hr'),
  	(1164, 'Krešimir', 'Vlahović', 49250, 10000, '1985-03-07 00:00:00', '0703985395007', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'kresimir.vlahovic@algebra.hr'),
  	(1165, 'Željka', 'Morić', 20242, 10000, '1985-06-03 00:00:00', '0306985392119', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zeljka.moric@algebra.hr'),
  	(1167, 'Mirko', 'Teklić', 47201, 10000, '1984-03-28 00:00:00', '2803984310615', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mirko.teklic@algebra.hr'),
  	(1168, 'Doris', 'Rapinac', 40000, 10000, '1984-11-22 00:00:00', '2211984335101', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'doris.rapinac@algebra.hr'),
  	(1169, 'Dubravko', 'Vaniček', 42000, 10000, '1984-11-27 00:00:00', '2711984320539', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dubravko.vanicek@algebra.hr'),
  	(1170, 'Denis', 'Pauk', 31000, 31000, '1985-04-11 00:00:00', '1104985301819', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'denis.pauk@algebra.hr'),
  	(1172, 'Ninoslav', 'Novak', 21000, 10000, '1984-04-10 00:00:00', '1004984383309', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ninoslav.novak@algebra.hr'),
  	(1173, 'Gordan', 'Boršić', 10000, 20000, '1980-02-29 00:00:00', '1902980334016', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'gordan.borsic@algebra.hr'),
  	(1174, 'Edita', 'Domijan', 47300, 10000, '1985-06-21 00:00:00', '2106985380029', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'edita.domijan@algebra.hr'),
  	(1176, 'Predrag', 'Žuljević', 34000, 10000, '1983-12-31 00:00:00', '3112983320569', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'predrag.zuljevic@algebra.hr'),
  	(1177, 'Kristian', 'Klarin', 10000, 10000, '1985-06-10 00:00:00', '1006985330028', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'kristian.klarin@algebra.hr'),
  	(1178, 'Kristijan', 'Vrabec', 20000, 10000, '1984-10-07 00:00:00', '0710984361315', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'kristijan.vrabec@algebra.hr'),
  	(1180, 'Iva', 'Mioč', 21000, 21000, '1985-01-31 00:00:00', '3101985340008', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'iva.mioc@algebra.hr'),
  	(1181, 'Arsenio', 'Minić', 10000, 20000, '1984-09-17 00:00:00', '1709984320508', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'arsenio.minic@algebra.hr'),
  	(1182, 'Gorana', 'Božić', 20000, 20000, '1983-07-21 00:00:00', '2107983340011', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'gorana.bozic@algebra.hr'),
  	(1184, 'Tihomir', 'Fabris', 10000, 20000, '1984-09-08 00:00:00', '0809984360058', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tihomir.fabris@algebra.hr'),
  	(1185, 'Ozren', 'Smolić', 20000, 10000, '1985-06-23 00:00:00', '2306985330083', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ozren.smolic@algebra.hr'),
  	(1186, 'Zlatko', 'Kolar', 21000, 10000, '1984-09-18 00:00:00', '1809984391008', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zlatko.kolar@algebra.hr'),
  	(1188, 'Kristina', 'Mandić', 20000, 10000, '1985-01-19 00:00:00', '1901985391825', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'kristina.mandic@algebra.hr'),
  	(1189, 'Juraj', 'Maček', 21000, 21000, '1985-01-27 00:00:00', '2701985390206', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'juraj.macek@algebra.hr'),
  	(1190, 'Domagoj', 'Krišto', 10000, 10000, '1985-03-13 00:00:00', '1303985330094', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'domagoj.kristo@algebra.hr'),
  	(1192, 'Helena', 'Mandić', 21000, 21000, '1985-07-10 00:00:00', '1007985300028', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'helena.mandic@algebra.hr'),
  	(1193, 'Krunoslav', 'Brezak', 10000, 10000, '1984-11-03 00:00:00', '0311984370805', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'krunoslav.brezak@algebra.hr'),
  	(1194, 'Antun Ivan', 'Herak', 20000, 20000, '1984-07-04 00:00:00', '0407984330073', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antun ivan.herak@algebra.hr'),
  	(1196, 'Pavao', 'Falk', 20000, 10000, '1984-07-12 00:00:00', '1207984330057', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'pavao.falk@algebra.hr'),
  	(1197, 'Dominik', 'Hacek', 10000, 10000, '1985-04-12 00:00:00', '1204985306801', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dominik.hacek@algebra.hr'),
  	(1198, 'Helena', 'Vidaković', 21000, 21000, '1984-08-31 00:00:00', '3108984330057', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'helena.vidakovic@algebra.hr'),
  	(1200, 'Davor', 'Bunčec', 21000, 21000, '1984-05-05 00:00:00', '0505984330124', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davor.buncec@algebra.hr'),
  	(1201, 'Doris', 'Končar', 10000, 10000, '1985-06-01 00:00:00', '0106985392713', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'doris.koncar@algebra.hr'),
  	(1202, 'Perica', 'Mikulec', 21000, 21000, '1984-04-10 00:00:00', '1004984340304', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'perica.mikulec@algebra.hr'),
  	(1204, 'Ksenija', 'Čular', 51000, 51000, '1985-08-10 00:00:00', '1008985311207', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ksenija.čular@algebra.hr'),
  	(1205, 'Dragan', 'Vranešić', 51000, 10000, '1984-11-28 00:00:00', '2811984330185', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dragan.vranesic@algebra.hr'),
  	(1206, 'Jozefina', 'Blauhorn', 51000, 51000, '1985-06-10 00:00:00', '1006985383925', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'jozefina.blauhorn@algebra.hr'),
  	(1208, 'Franjo', 'Stipanov', 31000, 31000, '1984-08-11 00:00:00', '1108984385042', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'franjo.stipanov@algebra.hr'),
  	(1209, 'Petar', 'Škrinjarić', 31000, 31000, '1984-12-14 00:00:00', '1412984380046', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'petar.skrinjaric@algebra.hr'),
  	(1210, 'Lea', 'Dostal', 31000, 31000, '1984-12-28 00:00:00', '2812984335123', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lea.dostal@algebra.hr'),
  	(1212, 'Josip', 'Zelić', 47000, 47000, '1984-10-01 00:00:00', '0110984330012', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'josip.zelic@algebra.hr'),
  	(1213, 'Petra', 'Čuljak', 47000, 47000, '1984-12-23 00:00:00', '2312984380051', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'petra.čuljak@algebra.hr'),
  	(1214, 'Drago', 'Bartolinčić', 40000, 10000, '1985-05-26 00:00:00', '2605985383309', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'drago.bartolincic@algebra.hr'),
  	(1216, 'Lidija', 'Leonard', 43000, 43000, '1984-11-09 00:00:00', '0911984330036', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lidija.leonard@algebra.hr'),
  	(1217, 'Lovre', 'Huk', 52000, 52000, '1984-12-11 00:00:00', '1112984370017', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lovre.huk@algebra.hr'),
  	(1218, 'Majo', 'Hemetek', 31000, 31000, '1985-06-23 00:00:00', '2306985340015', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'majo.hemetek@algebra.hr'),
  	(1219, 'Predrag', 'Smirčić', 21000, 21000, '1985-03-17 00:00:00', '1703985335145', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'predrag.smircic@algebra.hr'),
  	(1221, 'Slavko', 'Prelec', 10000, 10000, '1985-06-27 00:00:00', '2706985362104', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'slavko.prelec@algebra.hr'),
  	(1222, 'Dragutin', 'Ladišić', 34000, 34000, '1984-12-15 00:00:00', '1512984391826', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dragutin.ladisic@algebra.hr'),
  	(1223, 'Kristina', 'Rubinić', 44000, 10000, '1985-07-02 00:00:00', '0207985335087', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'kristina.rubinic@algebra.hr'),
  	(1225, 'Mirko', 'Dubravić', 32000, 32000, '1984-08-05 00:00:00', '0508984380043', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mirko.dubravic@algebra.hr'),
  	(1226, 'Tin', 'Mikulaj', 42000, 42000, '1985-04-11 00:00:00', '1104985392619', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tin.mikulaj@algebra.hr'),
  	(1227, 'Dražen', 'Bošnjak', 51000, 51000, '1984-11-24 00:00:00', '2411984340712', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'drazen.bosnjak@algebra.hr'),
  	(1229, 'Vjeran', 'Brezovec', 44000, 10000, '1985-09-24 00:00:00', '2409985330058', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vjeran.brezovec@algebra.hr'),
  	(1230, 'Predrag', 'Buljat', 53000, 53000, '1985-01-06 00:00:00', '0601985320007', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'predrag.buljat@algebra.hr'),
  	(1231, 'Lucija', 'Matijašević', 32000, 32000, '1985-06-03 00:00:00', '0306985300888', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lucija.matijasevic@algebra.hr'),
  	(1233, 'Renato', 'Stepinac', 51000, 51000, '1985-06-03 00:00:00', '0306985300078', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'renato.stepinac@algebra.hr'),
  	(1234, 'Ksenija', 'Pavišić', 21000, 10000, '1981-09-15 00:00:00', '1509981330133', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ksenija.pavisic@algebra.hr'),
  	(1235, 'Lea', 'Kamenečki', 10000, 10000, '1985-01-29 00:00:00', '2901985390007', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lea.kamenecki@algebra.hr'),
  	(1237, 'Luka', 'Frankola', 21000, 21000, '1985-08-19 00:00:00', '1908985320002', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'luka.frankola@algebra.hr'),
  	(1238, 'Tihomir', 'Crnković', 10000, 10000, '1984-06-22 00:00:00', '2206984339303', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tihomir.crnkovic@algebra.hr'),
  	(1239, 'Duje', 'Šimić', 20000, 10000, '1984-09-07 00:00:00', '0709984330054', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'duje.simic@algebra.hr'),
  	(1241, 'Ljiljana', 'Valentić', 10000, 20000, '1984-10-04 00:00:00', '0410984330044', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ljiljana.valentic@algebra.hr'),
  	(1242, 'Alan', 'Samodol', 20000, 20000, '1984-10-12 00:00:00', '1210984330177', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'alan.samodol@algebra.hr'),
  	(1243, 'Lidija', 'Žiljak', 21000, 21000, '1985-01-04 00:00:00', '0401985330026', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lidija.ziljak@algebra.hr'),
  	(1245, 'Dujo Davor', 'Folnegović', 10360, 10000, '1984-11-05 00:00:00', '0511984391518', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dujo davor.folnegovic@algebra.hr'),
  	(1246, 'Roko', 'Novosel', 20340, 10000, '1985-04-04 00:00:00', '0404985335091', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'roko.novosel@algebra.hr'),
  	(1247, 'Alan', 'Pasanec', 21450, 10000, '1984-09-29 00:00:00', '2909984330071', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'alan.pasanec@algebra.hr'),
  	(1249, 'Maja', 'Belić', 32280, 10000, '1985-06-12 00:00:00', '1206985330109', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'maja.belic@algebra.hr'),
  	(1250, 'Antonijo', 'Franjković', 35420, 10000, '1984-11-23 00:00:00', '2311984360005', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antonijo.franjkovic@algebra.hr'),
  	(1251, 'Lucija', 'Brčić', 47240, 10000, '1985-05-07 00:00:00', '0705985391019', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lucija.brcic@algebra.hr'),
  	(1253, 'Božidar', 'Cetto', 53230, 10000, '1985-05-24 00:00:00', '2405985330205', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'bozidar.cetto@algebra.hr'),
  	(1254, 'Edo', 'Marić', 21420, 21420, '1985-02-27 00:00:00', '2702985390302', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'edo.maric@algebra.hr'),
  	(1255, 'Antonijo', 'Dumančić', 32100, 32100, '1984-09-21 00:00:00', '2109984302141', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antonijo.dumancic@algebra.hr'),
  	(1257, 'Adrian', 'Lukač', 44320, 10000, '1985-08-17 00:00:00', '1708985383929', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'adrian.lukac@algebra.hr'),
  	(1258, 'Majo', 'Varga', 10430, 10000, '1984-04-21 00:00:00', '2104984340015', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'majo.varga@algebra.hr'),
  	(1259, 'Ljiljana', 'Bulić', 31301, 10000, '1984-07-22 00:00:00', '2207984383304', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ljiljana.bulic@algebra.hr'),
  	(1261, 'Silvana', 'Novosel', 47302, 10000, '1984-12-11 00:00:00', '1112984308219', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'silvana.novosel@algebra.hr'),
  	(1262, 'Maja', 'Šeremet', 40000, 10000, '1984-12-17 00:00:00', '1712984311413', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'maja.seremet@algebra.hr'),
  	(1263, 'Davor', 'Plečko', 42000, 42000, '1985-01-05 00:00:00', '0501985392729', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davor.plecko@algebra.hr'),
  	(1265, 'Marija', 'Barbić', 31000, 31000, '1985-07-12 00:00:00', '1207985330096', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'marija.barbic@algebra.hr'),
  	(1266, 'Eduard', 'Petrović', 21000, 21000, '1984-09-25 00:00:00', '2509984383927', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'eduard.petrovic@algebra.hr'),
  	(1267, 'Adrijan', 'Vuković', 44400, 10000, '1983-07-12 00:00:00', '1207983330073', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'adrijan.vukovic@algebra.hr'),
  	(1268, 'Adrijana', 'Buršić', 34000, 10000, '1985-05-19 00:00:00', '1905985320026', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'adrijana.bursic@algebra.hr'),
  	(1270, 'Nino', 'Triska', 10000, 10000, '1985-04-25 00:00:00', '2504985334318', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'nino.triska@algebra.hr'),
  	(1271, 'Marijan', 'Mirošević', 20000, 10000, '1985-08-27 00:00:00', '2708985334008', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'marijan.mirosevic@algebra.hr'),
  	(1272, 'Emil', 'Sertić', 21000, 10000, '1985-04-09 00:00:00', '0904985820084', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'emil.sertic@algebra.hr'),
  	(1274, 'Silvestar', 'Sabljak', 21000, 10000, '1984-05-15 00:00:00', '1505984335045', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'silvestar.sabljak@algebra.hr'),
  	(1275, 'Dubravko', 'Toth', 10000, 10000, '1985-07-02 00:00:00', '0207985361927', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dubravko.toth@algebra.hr'),
  	(1276, 'Filip', 'Jurić', 20000, 10000, '1985-05-04 00:00:00', '0405985303209', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'filip.juric@algebra.hr'),
  	(1278, 'Gordan', 'Dular', 10000, 20000, '1984-11-29 00:00:00', '2911984317209', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'gordan.dular@algebra.hr'),
  	(1279, 'Martina', 'Krizmanić', 20000, 10000, '1985-01-10 00:00:00', '1001985383921', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'martina.krizmanic@algebra.hr'),
  	(1280, 'Marin', 'Jurić', 21000, 10000, '1984-10-26 00:00:00', '2610984311907', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'marin.juric@algebra.hr'),
  	(1282, 'Alan', 'Matuna', 20000, 10000, '1985-02-01 00:00:00', '0102985334042', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'alan.matuna@algebra.hr'),
  	(1283, 'Vinko', 'Padovan', 21000, 10000, '1985-04-05 00:00:00', '0504985335094', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vinko.padovan@algebra.hr'),
  	(1284, 'Albert', 'Hunić', 10000, 10000, '1985-01-08 00:00:00', '0801985366002', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'albert.hunic@algebra.hr'),
  	(1286, 'Fran', 'Šef', 21000, 10000, '1984-08-21 00:00:00', '2108984383317', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'fran.sef@algebra.hr'),
  	(1287, 'Adrijan', 'Trnski', 10000, 20000, '1984-03-11 00:00:00', '1103984361305', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'adrijan.trnski@algebra.hr'),
  	(1288, 'Mirjana', 'Iveković', 20000, 20000, '1985-03-01 00:00:00', '0103985320504', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mirjana.ivekovic@algebra.hr'),
  	(1290, 'Slavica', 'Pavić', 20000, 22000, '1984-12-20 00:00:00', '2012984321406', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'slavica.pavic@algebra.hr'),
  	(1291, 'Gordan', 'Kačar', 21000, 21000, '1984-11-15 00:00:00', '1511984330125', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'gordan.kacar@algebra.hr'),
  	(1292, 'Juraj', 'Sabljak', 10000, 20000, '1985-02-26 00:00:00', '2602985330075', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'juraj.sabljak@algebra.hr'),
  	(1294, 'Iva', 'Devčić', 10000, 10000, '1985-03-21 00:00:00', '2103985330067', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'iva.devcic@algebra.hr'),
  	(1295, 'Frane', 'Plavetić', 21000, 10000, '1985-01-06 00:00:00', '0601985330138', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'frane.plavetic@algebra.hr'),
  	(1296, 'Slavko', 'Petreković', 10000, 20000, '1985-07-23 00:00:00', '2307985330036', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'slavko.petrekovic@algebra.hr'),
  	(1298, 'Marinko', 'Horvat', 10000, 20000, '1985-04-11 00:00:00', '1104985390303', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'marinko.horvat@algebra.hr'),
  	(1299, 'Davorka', 'Ilić', 51000, 51000, '1985-04-15 00:00:00', '1504985380055', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davorka.ilic@algebra.hr'),
  	(1300, 'Alenka', 'Lozić', 51000, 51000, '1985-07-22 00:00:00', '2207985330193', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'alenka.lozic@algebra.hr'),
  	(1302, 'Lovre', 'Smiljanec', 31000, 10000, '1985-04-17 00:00:00', '1704985381105', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lovre.smiljanec@algebra.hr'),
  	(1303, 'Juraj', 'Szirovicza', 31000, 31000, '1985-05-23 00:00:00', '2305985330039', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'juraj.szirovicza@algebra.hr'),
  	(1304, 'Mario', 'Babić', 31000, 10000, '1984-07-31 00:00:00', '3107984381518', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mario.babic@algebra.hr'),
  	(1306, 'Helena', 'Octenjak', 47000, 47000, '1983-07-14 00:00:00', '1407983330042', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'helena.octenjak@algebra.hr'),
  	(1307, 'Franjo', 'Zdilar', 47000, 10000, '1984-09-16 00:00:00', '1609984330314', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'franjo.zdilar@algebra.hr'),
  	(1308, 'Stipe', 'Pugelnik', 22000, 22000, '1984-12-02 00:00:00', '0212984391814', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'stipe.pugelnik@algebra.hr'),
  	(1310, 'Marko', 'Mateković', 48000, 10000, '1985-06-21 00:00:00', '2106985334006', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'marko.matekovic@algebra.hr'),
  	(1311, 'Goran', 'Remenar', 40000, 40000, '1984-05-20 00:00:00', '2005984390118', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'goran.remenar@algebra.hr'),
  	(1312, 'Nina', 'Kućan', 33000, 10000, '1985-06-25 00:00:00', '2506985330144', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'nina.kucan@algebra.hr'),
  	(1314, 'Marko', 'Suhina', 52000, 52000, '1984-10-28 00:00:00', '2810984330097', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'marko.suhina@algebra.hr'),
  	(1315, 'Aljoša', 'Sobol', 31000, 31000, '1985-05-11 00:00:00', '1105985335128', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'aljosa.sobol@algebra.hr'),
  	(1316, 'Gorana', 'Frljak', 21000, 21000, '1984-05-06 00:00:00', '0605984334017', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'gorana.frljak@algebra.hr'),
  	(1317, 'Mijo', 'Vucelić', 49000, 49000, '1985-05-23 00:00:00', '2305985383905', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mijo.vucelic@algebra.hr'),
  	(1319, 'Petra', 'Školnik', 34000, 10000, '1984-11-13 00:00:00', '1311984330155', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'petra.skolnik@algebra.hr'),
  	(1320, 'Martin', 'Kovačić', 44000, 10000, '1984-09-20 00:00:00', '2009984311404', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'martin.kovacic@algebra.hr'),
  	(1321, 'Marko', 'Meljanac', 53000, 53000, '1985-02-09 00:00:00', '0902985390011', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'marko.meljanac@algebra.hr'),
  	(1323, 'Ivan', 'Jambrak', 21000, 21000, '1984-06-18 00:00:00', '1806984330251', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ivan.jambrak@algebra.hr'),
  	(1324, 'Petar', 'Nemet', 49000, 49000, '1984-11-17 00:00:00', '1711984335042', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'petar.nemet@algebra.hr'),
  	(1325, 'Martina', 'Simon', 10000, 10000, '1984-02-03 00:00:00', '0302984383304', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'martina.simon@algebra.hr'),
  	(1327, 'Andrej', 'Jurić', 44000, 44000, '1983-11-27 00:00:00', '2711983370016', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'andrej.juric@algebra.hr'),
  	(1328, 'Renata', 'Vujnovac', 53000, 10000, '1984-10-08 00:00:00', '0810984334302', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'renata.vujnovac@algebra.hr'),
  	(1329, 'Mijo', 'Poljak', 10000, 10000, '1985-05-26 00:00:00', '2605985153755', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mijo.poljak@algebra.hr'),
  	(1331, 'Gordan', 'Lacković', 21000, 10000, '1984-09-03 00:00:00', '0309984330249', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'gordan.lackovic@algebra.hr'),
  	(1332, 'Svebor', 'Keščec', 10000, 10000, '1985-02-09 00:00:00', '0902985383308', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'svebor.kescec@algebra.hr'),
  	(1333, 'Adrijan', 'Fabrični', 20000, 10000, '1984-09-04 00:00:00', '0409984391807', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'adrijan.fabricni@algebra.hr'),
  	(1335, 'Andrija', 'Topolovac', 10000, 10000, '1985-04-18 00:00:00', '1804985391514', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'andrija.topolovac@algebra.hr'),
  	(1336, 'Slavko', 'Hrvojević', 20000, 20000, '1985-06-29 00:00:00', '2906985350009', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'slavko.hrvojevic@algebra.hr'),
  	(1337, 'Mate', 'Crnjak', 21000, 21000, '1985-01-19 00:00:00', '1901985360076', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mate.crnjak@algebra.hr'),
  	(1339, 'Andro', 'Popović', 21000, 21000, '1984-12-24 00:00:00', '2412984330067', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'andro.popovic@algebra.hr'),
  	(1340, 'Matej', 'Dukić', 20230, 10000, '1985-08-02 00:00:00', '0208985361006', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'matej.dukic@algebra.hr'),
  	(1341, 'Sanja', 'Babić', 21240, 10000, '1985-06-28 00:00:00', '2806985371019', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'sanja.babic@algebra.hr'),
  	(1343, 'Davorka', 'Kralj', 31530, 10000, '1984-01-05 00:00:00', '0501984330031', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davorka.kralj@algebra.hr'),
  	(1344, 'Sven', 'Rac', 34330, 34330, '1984-12-25 00:00:00', '2512984330145', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'sven.rac@algebra.hr'),
  	(1345, 'Helena', 'Medved', 43290, 10000, '1984-12-10 00:00:00', '1012984320027', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'helena.medved@algebra.hr'),
  	(1347, 'Mateo', 'Maković', 52100, 52100, '1985-02-23 00:00:00', '2302985363032', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mateo.makovic@algebra.hr'),
  	(1348, 'Silvana', 'Vrbanić', 10370, 10000, '1985-03-19 00:00:00', '1903985110036', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'silvana.vrbanic@algebra.hr'),
  	(1349, 'Šime', 'Kovačić', 22010, 10000, '1984-09-19 00:00:00', '1909984302127', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'sime.kovacic@algebra.hr'),
  	(1351, 'Želimir', 'Babić', 42250, 10000, '1985-02-02 00:00:00', '0202985330149', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zelimir.babic@algebra.hr'),
  	(1352, 'Marko', 'Levačić', 44410, 10000, '1985-07-15 00:00:00', '1507985388902', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'marko.levacic@algebra.hr'),
  	(1353, 'Slavica', 'Đurak', 34330, 10000, '1984-10-13 00:00:00', '1310984363004', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'slavica.djurak@algebra.hr'),
  	(1355, 'Ante', 'Budimir', 51251, 10000, '1985-03-01 00:00:00', '0103985320023', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ante.budimir@algebra.hr'),
  	(1356, 'Matija', 'Bujas', 40000, 40000, '1985-04-22 00:00:00', '2204985391517', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'matija.bujas@algebra.hr'),
  	(1357, 'Nino', 'Barić', 31000, 31000, '1985-03-25 00:00:00', '2503985381527', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'nino.baric@algebra.hr'),
  	(1359, 'Matija Tvrtko', 'Andrišek', 10000, 10000, '1985-01-22 00:00:00', '2201985335002', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'matija tvrtko.andrisek@algebra.hr'),
  	(1360, 'Sunčica', 'Bošnjak', 21000, 10000, '1984-08-25 00:00:00', '2508984330069', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'suncica.bosnjak@algebra.hr'),
  	(1361, 'Anto', 'Globlek', 44400, 44400, '1984-06-14 00:00:00', '1406984330053', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'anto.globlek@algebra.hr'),
  	(1363, 'Matko', 'Grgić', 32000, 32000, '1985-06-08 00:00:00', '0806985383315', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'matko.grgic@algebra.hr'),
  	(1364, 'Antun', 'Ferenc', 20000, 10000, '1985-01-20 00:00:00', '2001985302121', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antun.ferenc@algebra.hr'),
  	(1365, 'Anton', 'Bečić', 21000, 21000, '1985-05-11 00:00:00', '1105985330025', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'anton.becic@algebra.hr'),
  	(1366, 'Vinko', 'Kontak', 10000, 10000, '1985-04-09 00:00:00', '0904985330095', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vinko.kontak@algebra.hr'),
  	(1368, 'Tea', 'Međimorec', 10000, 20000, '1984-07-17 00:00:00', '1707984330129', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tea.medimorec@algebra.hr'),
  	(1369, 'Mato', 'Kobal', 20000, 10000, '1984-07-30 00:00:00', '3007984383313', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mato.kobal@algebra.hr'),
  	(1370, 'Tibor', 'Poljanec', 21000, 10000, '1984-09-22 00:00:00', '2209984370027', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tibor.poljanec@algebra.hr'),
  	(1372, 'Adrijan', 'Herceg', 20000, 20000, '1985-04-30 00:00:00', '3004985330071', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'adrijan.herceg@algebra.hr'),
  	(1373, 'Antonijo', 'Bilić', 21000, 10000, '1984-12-03 00:00:00', '0312984391218', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antonijo.bilic@algebra.hr'),
  	(1374, 'Tea', 'Mihaljević', 10000, 10000, '1984-06-28 00:00:00', '2806984370019', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tea.mihaljevic@algebra.hr'),
  	(1376, 'Darko', 'Mrduljaš', 21000, 10000, '1985-07-16 00:00:00', '1607985330152', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'darko.mrduljas@algebra.hr'),
  	(1377, 'Davorka', 'Čavrak', 10000, 10000, '1984-07-31 00:00:00', '3107984390009', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davorka.čavrak@algebra.hr'),
  	(1378, 'Antonio', 'Pamučar', 20000, 10000, '1985-05-10 00:00:00', '1005985330166', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antonio.pamucar@algebra.hr'),
  	(1380, 'Tihomir', 'Medić', 10000, 10000, '1984-10-15 00:00:00', '1510984330055', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tihomir.medic@algebra.hr'),
  	(1381, 'Antun', 'Balog', 20000, 20000, '1984-08-30 00:00:00', '3008984335037', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antun.balog@algebra.hr'),
  	(1382, 'Vlatka', 'Relota', 21000, 21000, '1985-06-11 00:00:00', '1106985330115', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vlatka.relota@algebra.hr'),
  	(1384, 'Helena', 'Budimir', 21000, 21000, '1984-11-18 00:00:00', '1811984312506', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'helena.budimir@algebra.hr'),
  	(1385, 'Tin', 'Krajtner', 21000, 10000, '1984-12-27 00:00:00', '2712984330082', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tin.krajtner@algebra.hr'),
  	(1386, 'Dragan', 'Vidaković', 10000, 10000, '1984-12-02 00:00:00', '0212984340003', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dragan.vidakovic@algebra.hr'),
  	(1388, 'Antun Ivan', 'Šimić', 10000, 10000, '1985-01-09 00:00:00', '0901985330269', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antun ivan.simic@algebra.hr'),
  	(1389, 'Mihovil', 'Slaviček', 21000, 21000, '1985-08-12 00:00:00', '1208985330046', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mihovil.slavicek@algebra.hr'),
  	(1390, 'Zdenka', 'Jureta', 10000, 20000, '1985-05-10 00:00:00', '1005985391503', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zdenka.jureta@algebra.hr'),
  	(1392, 'Filip', 'Cigrovski', 51000, 51000, '1983-11-27 00:00:00', '2711983330077', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'filip.cigrovski@algebra.hr'),
  	(1393, 'Stjepan', 'Tomić', 51000, 10000, '1985-05-06 00:00:00', '0605985330013', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'stjepan.tomic@algebra.hr'),
  	(1394, 'Augustina', 'Šimek', 51000, 10000, '1985-01-15 00:00:00', '1501985320515', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'augustina.simek@algebra.hr'),
  	(1396, 'Gordana', 'Husak', 31000, 31000, '1982-01-18 00:00:00', '1801982380065', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'gordana.husak@algebra.hr'),
  	(1397, 'Mijo', 'Legović', 31000, 10000, '1984-12-28 00:00:00', '2812984361908', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mijo.legovic@algebra.hr'),
  	(1398, 'Zdravka', 'Budiša', 31000, 10000, '1985-01-04 00:00:00', '0401985383929', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zdravka.budisa@algebra.hr'),
  	(1400, 'Miljenko', 'Tuđen', 47000, 10000, '1984-07-22 00:00:00', '2207984391806', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'miljenko.tuden@algebra.hr'),
  	(1401, 'Vinko', 'Marković', 47000, 47000, '1984-10-19 00:00:00', '1910984334304', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vinko.markovic@algebra.hr'),
  	(1402, 'Slavko', 'Kavčič', 10000, 10000, '1985-04-15 00:00:00', '1504985383908', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'slavko.kavcic@algebra.hr'),
  	(1404, 'Željka', 'Puljek', 44000, 44000, '1985-03-05 00:00:00', '0503985334317', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zeljka.puljek@algebra.hr'),
  	(1405, 'Jerko', 'Ogresta', 53000, 53000, '1985-01-09 00:00:00', '0901985302806', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'jerko.ogresta@algebra.hr'),
  	(1406, 'Tomica', 'Lulić', 32000, 10000, '1984-11-20 00:00:00', '2011984330107', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tomica.lulic@algebra.hr'),
  	(1408, 'Mirjana', 'Cesnik', 51000, 10000, '1984-06-01 00:00:00', '0106984330014', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mirjana.cesnik@algebra.hr'),
  	(1409, 'Berislav', 'Crnković', 22000, 22000, '1985-04-05 00:00:00', '0504985330263', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'berislav.crnkovic@algebra.hr'),
  	(1410, 'Željka', 'Koren', 35000, 35000, '1985-03-12 00:00:00', '1203985334304', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zeljka.koren@algebra.hr'),
  	(1412, 'Hana', 'Birkić', 40000, 40000, '1984-08-10 00:00:00', '1008984302118', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'hana.birkic@algebra.hr'),
  	(1413, 'Antun Ivan', 'Galić', 33000, 10000, '1985-04-20 00:00:00', '2004985301006', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antun ivan.galic@algebra.hr'),
  	(1414, 'Tin', 'Šipek', 43000, 43000, '1984-11-24 00:00:00', '2411984330174', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tin.sipek@algebra.hr'),
  	(1415, 'Tomislav', 'Kovačić', 52000, 52000, '1984-06-15 00:00:00', '1506984370008', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tomislav.kovacic@algebra.hr'),
  	(1417, 'Toni', 'Merlak', 35000, 35000, '1985-04-13 00:00:00', '1304985310024', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'toni.merlak@algebra.hr'),
  	(1418, 'Davor', 'Roketinec', 48000, 10000, '1984-11-05 00:00:00', '0511984330035', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davor.roketinec@algebra.hr'),
  	(1419, 'Mirko', 'Brečić', 40000, 40000, '1984-10-29 00:00:00', '2910984383906', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mirko.brecic@algebra.hr'),
  	(1421, 'Ljiljana', 'Jokić', 43000, 10000, '1985-03-16 00:00:00', '1603985383315', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ljiljana.jokic@algebra.hr'),
  	(1422, 'Helena', 'Crnković', 52000, 52000, '1985-04-12 00:00:00', '1204985339016', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'helena.crnkovic@algebra.hr'),
  	(1423, 'Vjeran', 'Nakić', 20000, 10000, '1984-07-28 00:00:00', '2807984311904', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vjeran.nakic@algebra.hr'),
  	(1425, 'Martina', 'Petrinec', 10000, 20000, '1984-10-24 00:00:00', '2410984334004', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'martina.petrinec@algebra.hr'),
  	(1426, 'Vanja', 'Bonačić', 20000, 10000, '1985-02-14 00:00:00', '1402985391809', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vanja.bonacic@algebra.hr'),
  	(1427, 'Hrvoje', 'Juričić', 21000, 21000, '1985-03-06 00:00:00', '0603985330122', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'hrvoje.juricic@algebra.hr'),
  	(1429, 'Karla', 'Kafadar', 20000, 20000, '1984-08-13 00:00:00', '1308984370016', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'karla.kafadar@algebra.hr'),
  	(1430, 'Želimir', 'Pintar', 21000, 10000, '1984-10-24 00:00:00', '2410984320029', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zelimir.pintar@algebra.hr'),
  	(1431, 'Franjo', 'Berač', 10000, 10000, '1985-04-29 00:00:00', '2904985370026', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'franjo.berac@algebra.hr'),
  	(1433, 'Igor', 'Bogati', 10380, 10000, '1984-11-07 00:00:00', '0711984385009', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'igor.bogati@algebra.hr'),
  	(1434, 'Mijo', 'Vrhoci', 21210, 10000, '1985-03-09 00:00:00', '0903985330211', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mijo.vrhoci@algebra.hr'),
  	(1435, 'Alan', 'Franc', 22020, 10000, '1984-09-24 00:00:00', '2409984392103', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'alan.franc@algebra.hr'),
  	(1437, 'Miro', 'Pugar', 34310, 10000, '1984-07-02 00:00:00', '0207984335112', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'miro.pugar@algebra.hr'),
  	(1438, 'Vedran', 'Meštrić', 42240, 42240, '1985-04-07 00:00:00', '0704985368003', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vedran.mestric@algebra.hr'),
  	(1439, 'Josip', 'Škvorc', 47300, 10000, '1985-01-18 00:00:00', '1801985392106', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'josip.skvorc@algebra.hr'),
  	(1441, 'Majo', 'Meglaj', 47220, 10000, '1984-06-09 00:00:00', '0906984383906', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'majo.meglaj@algebra.hr'),
  	(1442, 'Boris', 'Jertec', 21450, 10000, '1984-02-29 00:00:00', '2902984330072', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'boris.jertec@algebra.hr'),
  	(1443, 'Nataša', 'Cerjan', 33520, 33405, '1984-08-28 00:00:00', '2808984335042', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'natasa.cerjan@algebra.hr'),
  	(1445, 'Niko', 'Grbić', 44400, 10000, '1985-01-04 00:00:00', '0401985330196', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'niko.grbic@algebra.hr'),
  	(1446, 'Antonijo', 'Nikolić', 20210, 10000, '1984-09-06 00:00:00', '0609984330247', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antonijo.nikolic@algebra.hr'),
  	(1447, 'Vid', 'Markulinčić', 31531, 10000, '1984-10-14 00:00:00', '1410984330114', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vid.markulincic@algebra.hr'),
  	(1449, 'Nataša', 'Osredečki', 51211, 10000, '1985-05-23 00:00:00', '2305985303534', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'natasa.osredecki@algebra.hr'),
  	(1450, 'Borislav', 'Gobin', 42000, 42000, '1985-08-04 00:00:00', '0408985330169', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'borislav.gobin@algebra.hr'),
  	(1451, 'Mirko', 'Kadić', 31000, 10000, '1984-09-15 00:00:00', '1509984382604', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mirko.kadic@algebra.hr'),
  	(1453, 'Petra', 'Tišlar', 31000, 31000, '1984-06-30 00:00:00', '3006984335183', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'petra.tislar@algebra.hr'),
  	(1454, 'Božidar', 'Sesar', 10000, 10000, '1983-04-29 00:00:00', '2904983383316', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'bozidar.sesar@algebra.hr'),
  	(1455, 'Iva', 'Hafner', 47300, 10000, '1984-09-18 00:00:00', '1809984340007', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'iva.hafner@algebra.hr'),
  	(1457, 'Borna', 'Burtina', 34000, 34000, '1985-06-04 00:00:00', '0406985380077', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'borna.burtina@algebra.hr'),
  	(1458, 'Davor', 'Kroflin', 21000, 21000, '1984-09-18 00:00:00', '1809984383124', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davor.kroflin@algebra.hr'),
  	(1459, 'Predrag', 'Vlah', 10000, 10000, '1984-11-29 00:00:00', '2911984330044', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'predrag.vlah@algebra.hr'),
  	(1461, 'Nenad', 'Toth', 21000, 21000, '1985-04-08 00:00:00', '0804985380005', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'nenad.toth@algebra.hr'),
  	(1462, 'Vilim', 'Živčić', 20000, 10000, '1984-11-10 00:00:00', '1011984370839', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vilim.zivcic@algebra.hr'),
  	(1463, 'Ivan', 'Balenović', 21000, 10000, '1983-08-16 00:00:00', '1608983335065', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ivan.balenovic@algebra.hr'),
  	(1464, 'Tihomir', 'Fizir', 10000, 10000, '1985-05-06 00:00:00', '0605985330058', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tihomir.fizir@algebra.hr'),
  	(1466, 'Neven', 'Rubeša', 21000, 10000, '1985-05-23 00:00:00', '2305985335025', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'neven.rubesa@algebra.hr'),
  	(1467, 'Tea', 'Stjepanović', 10000, 10000, '1984-10-27 00:00:00', '2710984330142', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'tea.stjepanovic@algebra.hr'),
  	(1468, 'Ivana', 'Kuzma', 20000, 20000, '1985-07-09 00:00:00', '0907985335135', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ivana.kuzma@algebra.hr'),
  	(1470, 'Dubravko', 'Bartolić', 10000, 10000, '1984-11-16 00:00:00', '1611984392608', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dubravko.bartolic@algebra.hr'),
  	(1471, 'Božidar', 'Ježić', 20000, 10000, '1984-11-26 00:00:00', '2611984321729', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'bozidar.jezic@algebra.hr'),
  	(1472, 'Ivana', 'Muranić', 21000, 21000, '1985-08-07 00:00:00', '0708985381113', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ivana.muranic@algebra.hr'),
  	(1474, 'Vjekoslav', 'Lacković', 20000, 10000, '1984-10-24 00:00:00', '2410984383901', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vjekoslav.lackovic@algebra.hr'),
  	(1475, 'Branimir', 'Bolfek', 21000, 10000, '1984-09-23 00:00:00', '2309984330054', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'branimir.bolfek@algebra.hr'),
  	(1476, 'Zlatko', 'Perčić', 10000, 10000, '1985-02-18 00:00:00', '1802985301803', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'zlatko.percic@algebra.hr'),
  	(1478, 'Vid', 'Kulišić', 10000, 10000, '1985-04-03 00:00:00', '0304985380005', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vid.kulisic@algebra.hr'),
  	(1479, 'Branko', 'Car', 10000, 20000, '1985-07-19 00:00:00', '1907985302136', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'branko.car@algebra.hr'),
  	(1480, 'Vjeran', 'Stipaničev', 21000, 21000, '1984-12-29 00:00:00', '2912984330052', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vjeran.stipanicev@algebra.hr'),
  	(1482, 'Iva', 'Klarin', 21000, 21000, '1984-11-10 00:00:00', '1011984383918', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'iva.klarin@algebra.hr'),
  	(1483, 'Ivica', 'Čučković', 10000, 35400, '1984-12-20 00:00:00', '2012984335149', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ivica.čuckovic@algebra.hr'),
  	(1484, 'Antun Ivan', 'Pužar', 21000, 21000, '1985-03-13 00:00:00', '1303985390025', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'antun ivan.puzar@algebra.hr'),
  	(1486, 'Iva', 'Kopjar', 21000, 21000, '1985-09-06 00:00:00', '0609985380028', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'iva.kopjar@algebra.hr'),
  	(1487, 'Juraj', 'Valjak', 51000, 10000, '1984-04-23 00:00:00', '2304984391802', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'juraj.valjak@algebra.hr'),
  	(1488, 'Davor', 'Dilber', 51000, 51000, '1984-10-03 00:00:00', '0310984330019', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'davor.dilber@algebra.hr'),
  	(1490, 'Bruno', 'Hundak', 31000, 10000, '1984-12-21 00:00:00', '2112984300052', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'bruno.hundak@algebra.hr'),
  	(1491, 'Jakov', 'Bumbar', 31000, 31000, '1985-01-15 00:00:00', '1501985330061', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'jakov.bumbar@algebra.hr'),
  	(1492, 'Ivan', 'Kordić', 31000, 31000, '1985-04-12 00:00:00', '1204985388117', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'ivan.kordic@algebra.hr'),
  	(1494, 'Franjo', 'Blažević', 31000, 10000, '1985-01-21 00:00:00', '2101985301004', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'franjo.blazevic@algebra.hr'),
  	(1495, 'Lovre', 'Šimek', 47000, 21000, '1984-11-14 00:00:00', '1411984303204', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'lovre.simek@algebra.hr'),
  	(1496, 'Cvijeta', 'Erceg', 32000, 10000, '1985-08-16 00:00:00', '1608985390075', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'cvijeta.erceg@algebra.hr'),
  	(1498, 'Janko', 'Jakopović', 51000, 51000, '1984-07-06 00:00:00', '0607984307828', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'janko.jakopovic@algebra.hr'),
  	(1499, 'Vlaho', 'Roginić', 22000, 10000, '1985-04-07 00:00:00', '0704985340301', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vlaho.roginic@algebra.hr'),
  	(1500, 'Dalibor', 'Gradečak', 35000, 35000, '1985-05-27 00:00:00', '2705985311411', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'dalibor.gradecak@algebra.hr'),
  	(1502, 'Josip', 'Nikl', 40000, 10000, '1984-09-30 00:00:00', '3009984383005', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'josip.nikl@algebra.hr'),
  	(1503, 'Majo', 'Posavec', 33000, 33000, '1984-09-03 00:00:00', '0309984330118', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'majo.posavec@algebra.hr'),
  	(1504, 'Josip', 'Poljak', 43000, 43000, '1984-12-06 00:00:00', '0612984391807', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'josip.poljak@algebra.hr'),
  	(1506, 'Damir', 'Buković', 31000, 31000, '1984-12-08 00:00:00', '0812984383608', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'damir.bukovic@algebra.hr'),
  	(1507, 'Mijo', 'Bitar', 21000, 21000, '1984-12-15 00:00:00', '1512984330055', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mijo.bitar@algebra.hr'),
  	(1508, 'Vlasta', 'Ciković', 49000, 10000, '1985-04-03 00:00:00', '0304985330026', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vlasta.cikovic@algebra.hr'),
  	(1510, 'Vlatka', 'Ćurković', 34000, 34000, '1984-12-19 00:00:00', '1912984360007', 0, '2017-06-05 15:30:52', '2018-05-04 20:37:24', 'vlatka.curkovic@algebra.hr'),
  	(1511, 'Mirko', 'Rech', 43000, 10000, '1984-04-12 00:00:00', '1204984321701', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'mirko.rech@algebra.hr'),
  	(1512, 'Josip', 'Horvat', 52000, 10000, '1985-08-05 00:00:00', '0508985383312', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'josip.horvat@algebra.hr'),
  	(1513, 'Josip', 'Ivanović', 31000, 31000, '1984-07-30 00:00:00', '3007984370022', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'josip.ivanovic@algebra.hr'),
  	(1515, 'Predrag', 'Fugaj', 49000, 49000, '1984-08-31 00:00:00', '3108984334004', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'predrag.fugaj@algebra.hr'),
  	(1516, 'Vlatko', 'Bedeniković', 10000, 10000, '1985-01-27 00:00:00', '2701985341117', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'vlatko.bedenikovic@algebra.hr'),
  	(1517, 'Daniel', 'Kamenar', 20000, 10000, '1984-07-05 00:00:00', '0507984312503', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'daniel.kamenar@algebra.hr'),
  	(1519, 'Slavko', 'Prstačić', 10000, 20000, '1984-01-15 00:00:00', '1501984330074', 0, '2017-06-05 15:30:52', '2018-05-04 20:36:50', 'slavko.prstacic@algebra.hr'),
  	(1535, 'Miss Tamia Cremin', 'Hammes', 10000, 21450, '1984-12-15 00:00:00', '1234567895555', 0, '2017-06-05 18:25:39', '2018-05-04 20:36:50', 'miss tamia cremin.hammes@algebra.hr'),
  	(1536, 'Ms. Lois Schultz', 'Tremblay', 10000, 21480, '1984-12-15 00:00:00', '1234567896666', 0, '2017-06-05 18:26:56', '2018-05-04 20:36:50', 'ms. lois schultz.tremblay@algebra.hr'),
  	(1537, 'Dorian West', 'Schinner', 10000, 32270, '1984-12-15 00:00:00', '1234567899999', 0, '2017-06-05 19:02:28', '2018-05-04 20:36:50', 'dorian west.schinner@algebra.hr'),
  	(1538, 'Terence Durgan', 'Osinski', 10000, 10295, '1984-12-15 00:00:00', '1234567897777', 0, '2017-06-05 19:04:21', '2018-05-04 20:36:50', 'terence durgan.osinski@algebra.hr'),
  	(1539, 'Monique Carter', 'Harvey', 10000, 22020, '1984-12-30 00:00:00', '1234567898888', 0, '2017-06-07 17:16:07', '2018-05-04 20:36:50', 'monique carter.harvey@algebra.hr'),
  	(1541, 'TestIme', 'TestPrezime', 31205, 31205, '2001-01-05 00:00:00', '1234567814524', 0, '2018-01-05 20:01:06', '2018-05-04 20:36:50', 'testime.testprezime@algebra.hr'),
  	(1542, 'Marko', 'Markovic', 10000, 10000, '1988-01-16 00:00:00', '1234567896385', 0, '2018-01-23 19:06:08', '2018-05-04 20:36:50', 'marko.markovic@algebra.hr'),
  	(1549, 'Marina', 'jhjha', 10000, 10000, '2018-01-16 00:00:00', '1234567899898', 0, '2018-01-23 19:18:10', '2018-05-04 20:36:50', 'marina.jhjha@algebra.hr'),
  	(1561, 'xin', 'yao', 10000, 10000, '0000-00-00 00:00:00', '8092555555555', 0, '2018-01-23 19:55:51', '2018-05-04 20:30:50', 'xin.yao@algebra.hr'),
  	(1563, 'Lovorka', 'Ivanov', 10000, 10000, '0000-00-00 00:00:00', '2965555555555', 0, '2018-01-23 19:59:30', '2018-05-04 20:36:50', 'lovorka.ivanov@algebra.hr'),
  	(1565, 'Marijana', 'Jurkotic', 10000, 10000, '2011-01-09 00:00:00', '2184555555558', 0, '2018-01-23 20:07:17', '2018-05-04 20:36:50', 'marijana.jurkotic@algebra.hr');
  /*!40000 ALTER TABLE `stud` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.stud_nas_ista_zup
  DROP TABLE IF EXISTS `stud_nas_ista_zup`;
  CREATE TABLE IF NOT EXISTS `stud_nas_ista_zup` (
    `imeNastavnik` char(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `prezNastavnik` char(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- Dumping data for table fakultet.stud_nas_ista_zup: ~24 rows (approximately)
  /*!40000 ALTER TABLE `stud_nas_ista_zup` DISABLE KEYS */;
  INSERT INTO `stud_nas_ista_zup` (`imeNastavnik`, `prezNastavnik`) VALUES
  	('Alan', 'Ostojčić'),
  	('Žarko', 'Dubinko'),
  	('Nino', 'Lipec'),
  	('Davorka', 'Vidović'),
  	('Dubravko', 'Josipović'),
  	('Zlatko', 'Tomašek'),
  	('Sanja', 'Watz'),
  	('Silvije', 'Szekeres'),
  	('Marina', 'Carek'),
  	('Stanislav', 'Krznarić'),
  	('Vinko', 'Kecman'),
  	('Sandra', 'Mihaljević'),
  	('Tanjanjanja', 'Petrović'),
  	('Božidar', 'Mužar'),
  	('Tina', 'Švaljek'),
  	('Marko', 'Hazdovac'),
  	('Kristian', 'Damjančić'),
  	('Slavica', 'Habana u nana'),
  	('Ivana', 'Košanski'),
  	('Vinko', 'Belošević'),
  	('Ivana', 'Dumančić'),
  	('Iva', 'Habuš'),
  	('Petar', 'Posavčević'),
  	('Damjan', 'Dolar');
  /*!40000 ALTER TABLE `stud_nas_ista_zup` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.users
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE IF NOT EXISTS `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.users: ~6 rows (approximately)
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  	(2, 'Antonije', 'nnm@ksha.com', '202cb962ac59075b964b07152d234b70', NULL, NULL, NULL),
  	(3, 'Neron', 'spalim@te.com', '202cb962ac59075b964b07152d234b70', NULL, NULL, NULL),
  	(5, 'Nerxon', 'lozim@te.com', '202cb962ac59075b964b07152d234b70', NULL, NULL, NULL),
  	(7, 'Julijus', 'Jul@augustus.rim', '202cb962ac59075b964b07152d234b70', NULL, NULL, NULL),
  	(8, 'novoime', 'novoime@fakemail.com', '202cb962ac59075b964b07152d234b70', NULL, NULL, NULL),
  	(9, 'anaxxxyz', 'milo@vana.com', '202cb962ac59075b964b07152d234b70', NULL, NULL, NULL);
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  
  -- Dumping structure for table fakultet.zupanija
  DROP TABLE IF EXISTS `zupanija`;
  CREATE TABLE IF NOT EXISTS `zupanija` (
    `sifZupanija` smallint(5) unsigned NOT NULL,
    `nazZupanija` char(40) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`sifZupanija`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- Dumping data for table fakultet.zupanija: ~22 rows (approximately)
  /*!40000 ALTER TABLE `zupanija` DISABLE KEYS */;
  INSERT INTO `zupanija` (`sifZupanija`, `nazZupanija`, `created_at`, `updated_at`) VALUES
  	(0, 'Nepoznata županija', NULL, NULL),
  	(1, 'Zagrebačka', NULL, '2018-06-01 21:35:59'),
  	(2, 'Krapinsko-zagorska', NULL, NULL),
  	(3, 'Sisačko-moslavačka', NULL, NULL),
  	(4, 'Karlovačka', NULL, NULL),
  	(5, 'Varaždinska', NULL, NULL),
  	(6, 'Koprivničko-križevačka', NULL, NULL),
  	(7, 'Bjelovarsko-bilogorska', NULL, NULL),
  	(8, 'Primorsko-goranska', NULL, NULL),
  	(9, 'Ličko-senjska', NULL, NULL),
  	(10, 'Virovitičko-podravska', NULL, NULL),
  	(11, 'Požeško-slavonska', NULL, NULL),
  	(12, 'Brodsko-posavska', NULL, NULL),
  	(13, 'Zadarska', NULL, NULL),
  	(14, 'Osječko-baranjska', NULL, NULL),
  	(15, 'Šibensko-kninska', NULL, NULL),
  	(16, 'Vukovarsko-srijemska', NULL, NULL),
  	(17, 'Splitsko-dalmatinska', NULL, NULL),
  	(18, 'Istarska', NULL, NULL),
  	(19, 'Dubrovačko-neretvanska', NULL, NULL),
  	(20, 'Međimurska', NULL, NULL),
  	(21, 'Grad Zagreb', NULL, NULL);
  /*!40000 ALTER TABLE `zupanija` ENABLE KEYS */;
  
  -- Dumping structure for view fakultet.v_brisime
  DROP VIEW IF EXISTS `v_brisime`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_brisime` (
  	`mbrStud` INT(10) UNSIGNED NOT NULL,
  	`imeStud` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`sifZupanija` SMALLINT(5) UNSIGNED NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_najmanji_mbr_u_mjestu
  DROP VIEW IF EXISTS `v_najmanji_mbr_u_mjestu`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_najmanji_mbr_u_mjestu` (
  	`MIN(stud.mbrStud)` INT(10) UNSIGNED NULL,
  	`Broj_studenata_u_mjestu` INT(10) UNSIGNED NOT NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_nastavnice
  DROP VIEW IF EXISTS `v_nastavnice`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_nastavnice` (
  	`pbr` INT(10) UNSIGNED NOT NULL,
  	`nazMjesto` CHAR(40) NOT NULL COLLATE 'utf8_unicode_ci',
  	`sifNastavnik` INT(10) UNSIGNED NOT NULL,
  	`imeNastavnik` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`prezNastavnik` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`pbrStan` INT(10) UNSIGNED NOT NULL,
  	`sifOrgjed` INT(10) UNSIGNED NOT NULL,
  	`koef` DECIMAL(3,2) NOT NULL,
  	`created_at` TIMESTAMP NULL,
  	`updated_at` TIMESTAMP NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_nepopularnipredmeti
  DROP VIEW IF EXISTS `v_nepopularnipredmeti`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_nepopularnipredmeti` (
  	`nazPred` CHAR(60) NOT NULL COLLATE 'utf8_unicode_ci',
  	`sifPred` INT(10) UNSIGNED NOT NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_studenti_iz_zg
  DROP VIEW IF EXISTS `v_studenti_iz_zg`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_studenti_iz_zg` (
  	`mbrStud` INT(10) UNSIGNED NOT NULL,
  	`imeStud` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`prezStud` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`pbrRod` INT(10) UNSIGNED NULL,
  	`pbrStan` INT(10) UNSIGNED NOT NULL,
  	`datRodStud` DATETIME NULL,
  	`jmbgStud` CHAR(13) NOT NULL COLLATE 'utf8_unicode_ci',
  	`slikaStud` TINYINT(1) NOT NULL,
  	`created_at` TIMESTAMP NULL,
  	`updated_at` TIMESTAMP NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_studmjesto
  DROP VIEW IF EXISTS `v_studmjesto`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_studmjesto` (
  	`mbrStud` INT(10) UNSIGNED NOT NULL,
  	`imeStud` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`prezStud` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`pbrStan` INT(10) UNSIGNED NOT NULL,
  	`nazMjesto` CHAR(40) NOT NULL COLLATE 'utf8_unicode_ci',
  	`created_at` TIMESTAMP NULL,
  	`sifZupanija` SMALLINT(5) UNSIGNED NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_stud_nas
  DROP VIEW IF EXISTS `v_stud_nas`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_stud_nas` (
  	`imeNastavnik` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`prezNastavnik` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`mbrStud` INT(10) UNSIGNED NOT NULL,
  	`imeStud` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`prezStud` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`pbrRod` INT(10) UNSIGNED NULL,
  	`pbrStan` INT(10) UNSIGNED NOT NULL,
  	`datRodStud` DATETIME NULL,
  	`jmbgStud` CHAR(13) NOT NULL COLLATE 'utf8_unicode_ci',
  	`slikaStud` TINYINT(1) NOT NULL,
  	`created_at` TIMESTAMP NULL,
  	`updated_at` TIMESTAMP NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_stud_nas_nas_zup
  DROP VIEW IF EXISTS `v_stud_nas_nas_zup`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_stud_nas_nas_zup` (
  	`imeNastavnik` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci',
  	`prezNastavnik` CHAR(25) NOT NULL COLLATE 'utf8_unicode_ci'
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_top_studenti_2003
  DROP VIEW IF EXISTS `v_top_studenti_2003`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_top_studenti_2003` (
  	`mbrStud` INT(10) UNSIGNED NOT NULL,
  	`broj_izlazaka` BIGINT(21) NOT NULL,
  	`prosjek` DECIMAL(9,4) NULL,
  	`RANK` DECIMAL(27,5) NULL,
  	`godina` INT(4) NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for view fakultet.v_upisanipredbezispita
  DROP VIEW IF EXISTS `v_upisanipredbezispita`;
  -- Creating temporary table to overcome VIEW dependency errors
  CREATE TABLE `v_upisanipredbezispita` (
  	`nazPred` CHAR(60) NOT NULL COLLATE 'utf8_unicode_ci',
  	`upisanoStud` INT(11) NULL
  ) ENGINE=MyISAM;
  
  -- Dumping structure for procedure fakultet.dohvati_mjesta_param
  DROP PROCEDURE IF EXISTS `dohvati_mjesta_param`;
  DELIMITER //
  CREATE DEFINER=`root`@`localhost` PROCEDURE `dohvati_mjesta_param`(
  	IN `parampbr` INT
  )
      COMMENT 'DOhvaca sva mjesta gdje je MBR veci od 60000'
  BEGIN
  SELECT * FROM mjesto WHERE mjesto.pbr > parampbr;
  END//
  DELIMITER ;
  
  -- Dumping structure for procedure fakultet.dohvati_sva_mjesta
  DROP PROCEDURE IF EXISTS `dohvati_sva_mjesta`;
  DELIMITER //
  CREATE DEFINER=`root`@`localhost` PROCEDURE `dohvati_sva_mjesta`()
      COMMENT 'Procedura koja dohvaća sva mjesta'
  BEGIN
  SELECT * FROM mjesto;
  END//
  DELIMITER ;
  
  -- Dumping structure for procedure fakultet.ime
  DROP PROCEDURE IF EXISTS `ime`;
  DELIMITER //
  CREATE DEFINER=`root`@`localhost` PROCEDURE `ime`(
  	IN `sifra` INT,
  	OUT `imee` VARCHAR(255)
  
  
  )
      NO SQL
      DETERMINISTIC
      COMMENT 'CALL `ime`(''1120'', @a);  SELECT @a ;'
  BEGIN
  SELECT stud.imeStud INTO imee FROM stud WHERE stud.mbrStud=sifra;
  END//
  DELIMITER ;
  
  -- Dumping structure for function fakultet.tran
  DROP FUNCTION IF EXISTS `tran`;
  DELIMITER //
  CREATE DEFINER=`root`@`localhost` FUNCTION `tran`() RETURNS int(11)
      COMMENT 'select tran();'
  BEGIN
  
  SAVEPOINT ime1;
  INSERT INTO `fakultet`.`mjesto1` (`pbr`, `nazMjesto`, `sifZupanija`) 
  VALUES (44444, 'vvv', 4444);
  INSERT INTO `fakultet`.`mjesto1` (`pbr`, `nazMjesto`, `sifZupanija`) 
  VALUES (88888, 'bbb', 8888);
  
  SAVEPOINT ime2;
  INSERT INTO `fakultet`.`mjesto1` (`pbr`, `nazMjesto`, `sifZupanija`) 
  VALUES (6666, 'nnn', 9999);
  INSERT INTO `fakultet`.`mjesto1` (`pbr`, `nazMjesto`, `sifZupanija`) 
  VALUES (77777, 'mmm', 12121);
  
  SELECT mjesto1.nazMjesto
  INTO @mojvar 
  FROM mjesto1 
  WHERE mjesto1.pbr=77777 LIMIT 1;
  
  
  RETURN(1);
  
  RETURN(1);
  END//
  DELIMITER ;
  
  -- Dumping structure for trigger fakultet.studValidation
  DROP TRIGGER IF EXISTS `studValidation`;
  SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
  DELIMITER //
  CREATE TRIGGER `studValidation` BEFORE INSERT ON `stud` FOR EACH ROW BEGIN
      IF CHAR_LENGTH(NEW.jmbgStud) < 13 THEN
      SIGNAL SQLSTATE '12345'
          SET MESSAGE_TEXT = 'GREŠKA !!! JMBG je manji od 13!';
      END IF;
          IF CHAR_LENGTH(NEW.imeStud) < 3 THEN
      SIGNAL SQLSTATE '12347'
          SET MESSAGE_TEXT = 'GREŠKA !!! Ime ne moze biti krace od 3 znaka!';
      END IF;
       IF CHAR_LENGTH(NEW.prezStud) < 3 THEN
      SIGNAL SQLSTATE '12346'
          SET MESSAGE_TEXT = 'GREŠKA !!! Prezime ne moze biti krace od 3 znaka!';
      END IF;  
  END//
  DELIMITER ;
  SET SQL_MODE=@OLDTMP_SQL_MODE;
  
  -- Dumping structure for trigger fakultet.stud_before_update
  DROP TRIGGER IF EXISTS `stud_before_update`;
  SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
  DELIMITER //
  CREATE TRIGGER `stud_before_update` BEFORE UPDATE ON `stud` FOR EACH ROW BEGIN
      IF CHAR_LENGTH(NEW.jmbgStud) < 13 THEN
      SIGNAL SQLSTATE '12345'
          SET MESSAGE_TEXT = 'GREŠKA !!! JMBG je manji od 13!';
      END IF;
  END//
  DELIMITER ;
  SET SQL_MODE=@OLDTMP_SQL_MODE;
  
  -- Dumping structure for trigger fakultet.users_before_insert
  DROP TRIGGER IF EXISTS `users_before_insert`;
  SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
  DELIMITER //
  CREATE TRIGGER `users_before_insert` BEFORE INSERT ON `users` FOR EACH ROW BEGIN
  IF (NEW.`email` REGEXP '^[A-Z0-9._%-]+@[A-Z0-9.-]+.[A-Z]{2,4}$')=0  THEN
  		SIGNAL SQLSTATE VALUE '45000'
  			SET MESSAGE_TEXT = '[table:users] - `email` nije ispravnog formata!';
  	END IF;
  END//
  DELIMITER ;
  SET SQL_MODE=@OLDTMP_SQL_MODE;
  
  -- Dumping structure for trigger fakultet.users_before_update
  DROP TRIGGER IF EXISTS `users_before_update`;
  SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
  DELIMITER //
  CREATE TRIGGER `users_before_update` BEFORE UPDATE ON `users` FOR EACH ROW BEGIN
  IF (NEW.`email` REGEXP '^[A-Z0-9._%-]+@[A-Z0-9.-]+.[A-Z]{2,4}$')=0  THEN
  		SIGNAL SQLSTATE VALUE '45000'
  			SET MESSAGE_TEXT = '[table:users] - `email` nije ispravnog formata!';
  	END IF;
  END//
  DELIMITER ;
  SET SQL_MODE=@OLDTMP_SQL_MODE;
  
  -- Dumping structure for view fakultet.v_brisime
  DROP VIEW IF EXISTS `v_brisime`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_brisime`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_brisime` AS SELECT 
  stud.mbrStud,
  stud.imeStud,
  mjesto.sifZupanija
  FROM stud INNER JOIN mjesto
  ON stud.pbrStan = mjesto.pbr
  WHERE mjesto.sifZupanija=21
  ORDER BY  stud.imeStud ASC,stud.pbrStan DESC ;
  
  -- Dumping structure for view fakultet.v_najmanji_mbr_u_mjestu
  DROP VIEW IF EXISTS `v_najmanji_mbr_u_mjestu`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_najmanji_mbr_u_mjestu`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_najmanji_mbr_u_mjestu` AS SELECT MIN(stud.mbrStud), stud.pbrStan AS Broj_studenata_u_mjestu 
  FROM fakultet.stud GROUP BY pbrStan ORDER BY stud.pbrStan DESC LIMIT 2,3 ;
  
  -- Dumping structure for view fakultet.v_nastavnice
  DROP VIEW IF EXISTS `v_nastavnice`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_nastavnice`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_nastavnice` AS SELECT mjesto.pbr, mjesto.nazMjesto, nastavnik.*  
  FROM mjesto INNER JOIN nastavnik 
  ON mjesto.pbr=nastavnik.pbrStan 
  WHERE RIGHT(nastavnik.imeNastavnik,1) LIKE 'a'
  ORDER BY mjesto.pbr ASC LIMIT 15 ;
  
  -- Dumping structure for view fakultet.v_nepopularnipredmeti
  DROP VIEW IF EXISTS `v_nepopularnipredmeti`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_nepopularnipredmeti`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_nepopularnipredmeti` AS SELECT 
  pred.nazPred,
  pred.sifPred
  FROM pred
  WHERE pred.sifPred NOT IN (
  SELECT
  DISTINCT ispit.sifPred
  FROM ispit) ;
  
  -- Dumping structure for view fakultet.v_studenti_iz_zg
  DROP VIEW IF EXISTS `v_studenti_iz_zg`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_studenti_iz_zg`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_studenti_iz_zg` AS SELECT * FROM stud WHERE stud.pbrRod =10000 ;
  
  -- Dumping structure for view fakultet.v_studmjesto
  DROP VIEW IF EXISTS `v_studmjesto`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_studmjesto`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_studmjesto` AS SELECT 
  stud.mbrStud,
  stud.imeStud,
  stud.prezStud,
  stud.pbrStan, 
  mjesto.nazMjesto, 
  mjesto.created_at,
  mjesto.sifZupanija
  FROM stud INNER JOIN mjesto
  ON stud.pbrStan = mjesto.pbr
  WHERE mjesto.sifZupanija=21
  ORDER BY  stud.imeStud ASC,stud.pbrStan DESC ;
  
  -- Dumping structure for view fakultet.v_stud_nas
  DROP VIEW IF EXISTS `v_stud_nas`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_stud_nas`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stud_nas` AS SELECT *
  FROM stud_nas_ista_zup INNER JOIN stud on stud.prezStud=stud_nas_ista_zup.prezNastavnik ;
  
  -- Dumping structure for view fakultet.v_stud_nas_nas_zup
  DROP VIEW IF EXISTS `v_stud_nas_nas_zup`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_stud_nas_nas_zup`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stud_nas_nas_zup` AS SELECT * FROM stud_nas_ista_zup ;
  
  -- Dumping structure for view fakultet.v_top_studenti_2003
  DROP VIEW IF EXISTS `v_top_studenti_2003`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_top_studenti_2003`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_top_studenti_2003` AS SELECT 
  ispit.mbrStud, 
  count(*) broj_izlazaka, 
  avg(ispit.ocjena) as prosjek ,
  (0.8*avg(ispit.ocjena) + count(*)*0.2) AS RANK,
  YEAR(ispit.datIspit) AS godina
  FROM ispit 
  WHERE ispit.ocjena>1
  AND YEAR(ispit.datIspit)=2003
  GROUP BY mbrstud
  ORDER BY RANK DESC 
  LIMIT 5 ;
  
  -- Dumping structure for view fakultet.v_upisanipredbezispita
  DROP VIEW IF EXISTS `v_upisanipredbezispita`;
  -- Removing temporary table and create final VIEW structure
  DROP TABLE IF EXISTS `v_upisanipredbezispita`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_upisanipredbezispita` AS /*
  PokuĹˇamo pronaÄ‡i sve predmete koji imaju upisane studente ali oni nisu izisli na ispit
  */
  SELECT 
  v_nepopularnipredmeti.nazPred,
  pred.upisanoStud
   FROM v_nepopularnipredmeti
  INNER JOIN pred on v_nepopularnipredmeti.sifPred=pred.sifPred
  WHERE v_nepopularnipredmeti.sifPred IN(
  select pred.sifPred FROM pred where pred.upisanoStud>0
  ) ;
  
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  