· 8 years ago · Mar 21, 2018, 02:48 PM
1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15-- -----------------------------------------------------
16-- Schema shemica
17-- -----------------------------------------------------
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Arheolog`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Arheolog` (
24 `ArheologID_1` INT NOT NULL AUTO_INCREMENT,
25 `Ime` VARCHAR(45) NOT NULL,
26 `Prezime` VARCHAR(45) NOT NULL,
27 `DatumRodjenja` DATE NOT NULL,
28 `Mejl` VARCHAR(45) NULL,
29 `ZiviU` VARCHAR(45) NULL,
30 PRIMARY KEY (`ArheologID_1`))
31ENGINE = InnoDB;
32
33
34-- -----------------------------------------------------
35-- Table `mydb`.`Tip_Antikviteta`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `mydb`.`Tip_Antikviteta` (
38 `TipAntikvitetaID_1` INT NOT NULL AUTO_INCREMENT,
39 `Tip` VARCHAR(45) NOT NULL,
40 PRIMARY KEY (`TipAntikvitetaID_1`))
41ENGINE = InnoDB;
42
43
44-- -----------------------------------------------------
45-- Table `mydb`.`Period`
46-- -----------------------------------------------------
47CREATE TABLE IF NOT EXISTS `mydb`.`Period` (
48 `PeriodID_1` INT NOT NULL AUTO_INCREMENT,
49 `Period` VARCHAR(45) NOT NULL,
50 PRIMARY KEY (`PeriodID_1`))
51ENGINE = InnoDB;
52
53
54-- -----------------------------------------------------
55-- Table `mydb`.`Lokalitet`
56-- -----------------------------------------------------
57CREATE TABLE IF NOT EXISTS `mydb`.`Lokalitet` (
58 `LokalitetID_1` INT NOT NULL AUTO_INCREMENT,
59 `KoordinateDuzina` DECIMAL NOT NULL,
60 `KoordinateSirina` DECIMAL NOT NULL,
61 `Naziv` VARCHAR(45) NOT NULL,
62 PRIMARY KEY (`LokalitetID_1`))
63ENGINE = InnoDB;
64
65
66-- -----------------------------------------------------
67-- Table `mydb`.`Antikvitet`
68-- -----------------------------------------------------
69CREATE TABLE IF NOT EXISTS `mydb`.`Antikvitet` (
70 `AntikvitetID` INT NOT NULL AUTO_INCREMENT,
71 `DatumPolaska` DATE NOT NULL,
72 `VremePolaska` TIME NOT NULL,
73 `Tip_Antikviteta_TipAntikvitetaID_1` INT NOT NULL,
74 `Period_PeriodID_1` INT NOT NULL,
75 `Lokalitet_LokalitetID_1` INT NOT NULL,
76 `Arheolog_ArheologID_1` INT NOT NULL,
77 PRIMARY KEY (`AntikvitetID`),
78 INDEX `fk_Antikvitet_Tip_Antikviteta_idx` (`Tip_Antikviteta_TipAntikvitetaID_1` ASC),
79 INDEX `fk_Antikvitet_Period1_idx` (`Period_PeriodID_1` ASC),
80 INDEX `fk_Antikvitet_Lokalitet1_idx` (`Lokalitet_LokalitetID_1` ASC),
81 INDEX `fk_Antikvitet_Arheolog1_idx` (`Arheolog_ArheologID_1` ASC),
82 CONSTRAINT `fk_Antikvitet_Tip_Antikviteta`
83 FOREIGN KEY (`Tip_Antikviteta_TipAntikvitetaID_1`)
84 REFERENCES `mydb`.`Tip_Antikviteta` (`TipAntikvitetaID_1`)
85 ON DELETE NO ACTION
86 ON UPDATE NO ACTION,
87 CONSTRAINT `fk_Antikvitet_Period1`
88 FOREIGN KEY (`Period_PeriodID_1`)
89 REFERENCES `mydb`.`Period` (`PeriodID_1`)
90 ON DELETE NO ACTION
91 ON UPDATE NO ACTION,
92 CONSTRAINT `fk_Antikvitet_Lokalitet1`
93 FOREIGN KEY (`Lokalitet_LokalitetID_1`)
94 REFERENCES `mydb`.`Lokalitet` (`LokalitetID_1`)
95 ON DELETE NO ACTION
96 ON UPDATE NO ACTION,
97 CONSTRAINT `fk_Antikvitet_Arheolog1`
98 FOREIGN KEY (`Arheolog_ArheologID_1`)
99 REFERENCES `mydb`.`Arheolog` (`ArheologID_1`)
100 ON DELETE NO ACTION
101 ON UPDATE NO ACTION)
102ENGINE = InnoDB
103COMMENT = 'A';
104
105
106SET SQL_MODE=@OLD_SQL_MODE;
107SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
108SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;