Gjrzusmq

1DROP SCHEMA IF EXISTS `radnici`;
2
3CREATE SCHEMA `radnici`
4DEFAULT CHARACTER SET utf8;
5
6USE `radnici`;
7
8CREATE TABLE IF NOT EXISTS `radnici`.`kompanija` (
9	`idk` INT (11) NOT NULL,
10	`naziv` VARCHAR (45) NULL DEFAULT NULL,
11	PRIMARY KEY (`idk`));
12	
13CREATE TABLE IF NOT EXISTS `radnici`.`projekat`(
14	`idp` INT (11) NOT NULL,
15	`nazivP` VARCHAR(45) NULL DEFAULT NULL,
16	PRIMARY KEY (`idp`));
17	
18CREATE TABLE IF NOT EXISTS `radnici`.`radnik`(
19	`mbr` INT (11) NOT NULL,
20	`prezR` VARCHAR (45) NULL DEFAULT NULL,
21	`imeR` VARCHAR(45) NULL DEFAULT NULL,
22	`plt` DECIMAL (8,2) NULL DEFAULT NULL,
23	`idk` INT (11) NULL,
24	`sef` INT (11) NULL,
25	PRIMARY KEY (`mbr`),
26	CONSTRAINT `fk_radnik_radi_u_kompaniji`
27		FOREIGN KEY (`idk`)
28		REFERENCES `radnici`.`kompanija` (`idk`)
29		ON DELETE RESTRICT
30		ON UPDATE CASCADE,
31	CONSTRAINT `fk_radnik_sef`
32		FOREIGN KEY (`sef`)
33		REFERENCES `radnici`.`radnik`(`mbr`)
34		ON DELETE RESTRICT
35		ON UPDATE CASCADE);
36		
37CREATE TABLE IF NOT EXISTS `radnici`.`radi` (
38	`mbr` INT (11) NOT NULL,
39	`idp` INT (11) NOT NULL,
40	`brojCas` INT (11) NULL DEFAULT NULL,
41	PRIMARY KEY (`mbr`, `idp`),
42	CONSTRAINT `fk_radnik_has_projekat_projekat1`
43		FOREIGN KEY (`idp`)
44		REFERENCES `radnici`.`projekat`(`idp`)
45		ON UPDATE CASCADE,
46	CONSTRAINT `fk_radnik_has_projekat_radnik1`
47		FOREIGN KEY (`mbr`)
48		REFERENCES `radnici`.`radnik`(`mbr`)
49		ON UPDATE CASCADE);