hXA4xiFM

1
2DROP DATABASE IF EXISTS fakultet_novi;
3CREATE DATABASE fakultet_novi; 
4DROP USER IF EXISTS 'fakultet_novi'@'localhost';
5CREATE USER 'fakultet_novi'@'localhost' IDENTIFIED BY 'fakultet_novi';
6GRANT ALL ON fakultet_novi.* TO 'fakultet_novi'@'localhost';
7USE fakultet_novi;
8
9DROP TABLE IF EXISTS `mjesto`;
10CREATE TABLE IF NOT EXISTS `mjesto` (
11  `id` int(11) NOT NULL,
12  `pbr` int(11) NOT NULL,
13  `nazMjesto` char(40) NOT NULL,
14  `sifZupanija` smallint(6) DEFAULT NULL, 
15  PRIMARY KEY (`id`),
16  CONSTRAINT ibfk_mjesto UNIQUE (`pbr`)  
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18
19
20DROP TABLE IF EXISTS `stud`;
21CREATE TABLE IF NOT EXISTS `stud` (
22  `id` int(11) NOT NULL,
23  `mbrStud` int(11) NOT NULL,
24  `imeStud` char(25) NOT NULL,
25  `prezStud` char(25) NOT NULL,
26  `pbrRod` int(11) DEFAULT NULL,
27  `pbrStan` int(11) NOT NULL,
28  `datRodStud` datetime DEFAULT NULL,
29  `jmbgStud` char(13) DEFAULT NULL,  
30  FOREIGN KEY(`pbrRod`) REFERENCES `mjesto`(`id`),
31  FOREIGN KEY(`pbrStan`) REFERENCES `mjesto`(`id`),
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35DROP TABLE IF EXISTS `ispit`;
36CREATE TABLE IF NOT EXISTS `ispit` (
37  `id` int(11) NOT NULL,
38  `mbrStud` int(11) NOT NULL,
39  `sifPred` int(11) NOT NULL,
40  `sifNastavnik` int(11) NOT NULL,
41  `datIspit` datetime NOT NULL,
42  `ocjena` smallint(6) NOT NULL DEFAULT '1',  
43  FOREIGN KEY(`mbrStud`) REFERENCES `stud`(`id`),  
44  PRIMARY KEY (`id`)
45) ENGINE=InnoDB DEFAULT CHARSET=utf8;