z6Tbk9R7

1CREATE TABLE IF NOT EXISTS `mydb`.`Mjesto` (
2  `idMjesto` INT UNSIGNED NOT NULL AUTO_INCREMENT,
3  `naziv` VARCHAR(255) NOT NULL,
4  `postanskiBroj` VARCHAR(255) NOT NULL,
5  `idParohija` INT UNSIGNED NOT NULL,
6  PRIMARY KEY (`idMjesto`),
7  UNIQUE INDEX `idMjesto_UNIQUE` (`idMjesto` ASC),
8  UNIQUE INDEX `postanskiBroj_UNIQUE` (`postanskiBroj` ASC),
9  INDEX `fk_Mjesto_Parohija1_idx` (`idParohija` ASC),
10  CONSTRAINT `fk_Mjesto_Parohija1`
11    FOREIGN KEY (`idParohija`)
12    REFERENCES `mydb`.`Parohija` (`idParohija`)
13    ON DELETE NO ACTION
14    ON UPDATE NO ACTION)
15ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
16
17
18-- -----------------------------------------------------
19-- Table `mydb`.`Adresa`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `mydb`.`Adresa` (
22  `idAdresa` INT UNSIGNED NOT NULL AUTO_INCREMENT,
23  `ulica` VARCHAR(255) NOT NULL,
24  `broj` INT UNSIGNED NULL,
25  `idMjesto` INT UNSIGNED NOT NULL,
26  PRIMARY KEY (`idAdresa`),
27  UNIQUE INDEX `idAdresa_UNIQUE` (`idAdresa` ASC),
28  INDEX `fk_Adresa_Mjesto1_idx` (`idMjesto` ASC),
29  CONSTRAINT `fk_Adresa_Mjesto1`
30    FOREIGN KEY (`idMjesto`)
31    REFERENCES `mydb`.`Mjesto` (`idMjesto`)
32    ON DELETE NO ACTION
33    ON UPDATE NO ACTION)
34ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;