NwZQ4uaw

1
2CREATE SCHEMA IF NOT EXISTS `vezba22` DEFAULT CHARACTER SET latin1 ;
3USE `vezba22` ;
4
5CREATE TABLE IF NOT EXISTS `vezba22`.`Antikvitet` (
6  `AntikvitetID` INT(11) NOT NULL,
7  `PeriodID` INT(11) NULL DEFAULT NULL,
8  `TipAntikvitetaID` INT(11) NULL DEFAULT NULL,
9  `LokalitetID` INT(11) NULL DEFAULT NULL,
10  `ArheologID` INT(11) NULL DEFAULT NULL,
11  `DatumPronalaska` DATE NULL DEFAULT NULL,
12  PRIMARY KEY (`AntikvitetID`))
13ENGINE = InnoDB
14DEFAULT CHARACTER SET = latin1;
15
16CREATE TABLE IF NOT EXISTS `vezba22`.`Arheolog` (
17  `ArheologID` INT(11) NOT NULL,
18  `Ime` VARCHAR(45) NULL DEFAULT NULL,
19  `Prezime` VARCHAR(45) NULL DEFAULT NULL,
20  `DatumRodjenja` DATE NULL DEFAULT NULL,
21  `Mejl` VARCHAR(45) NULL DEFAULT NULL,
22  `ZiviU` VARCHAR(45) NULL DEFAULT NULL,
23  PRIMARY KEY (`ArheologID`))
24ENGINE = InnoDB
25DEFAULT CHARACTER SET = latin1;
26
27CREATE TABLE IF NOT EXISTS `vezba22`.`Lokalitet` (
28  `LokalitetID` INT(11) NOT NULL,
29  `KoordinateDuzina` DECIMAL(3,2) NULL DEFAULT NULL,
30  `KoordinateSirina` DECIMAL(3,2) NULL DEFAULT NULL,
31  `Naziv` VARCHAR(45) NULL DEFAULT NULL,
32  PRIMARY KEY (`LokalitetID`))
33ENGINE = InnoDB
34DEFAULT CHARACTER SET = latin1;
35
36CREATE TABLE IF NOT EXISTS `vezba22`.`Period` (
37  `PeriodID` INT(11) NOT NULL,
38  `Period` VARCHAR(45) NULL DEFAULT NULL,
39  PRIMARY KEY (`PeriodID`))
40ENGINE = InnoDB
41DEFAULT CHARACTER SET = latin1;
42
43CREATE TABLE IF NOT EXISTS `vezba22`.`Tip_Antikviteta` (
44  `TipAntikvitetaID` INT(11) NOT NULL,
45  `Tip` VARCHAR(45) NULL DEFAULT NULL,
46  PRIMARY KEY (`TipAntikvitetaID`))
47ENGINE = InnoDB
48DEFAULT CHARACTER SET = latin1;