Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE SCHEMA IF NOT EXISTS `vezba22` DEFAULT CHARACTER SET latin1 ;
- USE `vezba22` ;
- CREATE TABLE IF NOT EXISTS `vezba22`.`Antikvitet` (
- `AntikvitetID` INT(11) NOT NULL,
- `PeriodID` INT(11) NULL DEFAULT NULL,
- `TipAntikvitetaID` INT(11) NULL DEFAULT NULL,
- `LokalitetID` INT(11) NULL DEFAULT NULL,
- `ArheologID` INT(11) NULL DEFAULT NULL,
- `DatumPronalaska` DATE NULL DEFAULT NULL,
- PRIMARY KEY (`AntikvitetID`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = latin1;
- CREATE TABLE IF NOT EXISTS `vezba22`.`Arheolog` (
- `ArheologID` INT(11) NOT NULL,
- `Ime` VARCHAR(45) NULL DEFAULT NULL,
- `Prezime` VARCHAR(45) NULL DEFAULT NULL,
- `DatumRodjenja` DATE NULL DEFAULT NULL,
- `Mejl` VARCHAR(45) NULL DEFAULT NULL,
- `ZiviU` VARCHAR(45) NULL DEFAULT NULL,
- PRIMARY KEY (`ArheologID`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = latin1;
- CREATE TABLE IF NOT EXISTS `vezba22`.`Lokalitet` (
- `LokalitetID` INT(11) NOT NULL,
- `KoordinateDuzina` DECIMAL(3,2) NULL DEFAULT NULL,
- `KoordinateSirina` DECIMAL(3,2) NULL DEFAULT NULL,
- `Naziv` VARCHAR(45) NULL DEFAULT NULL,
- PRIMARY KEY (`LokalitetID`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = latin1;
- CREATE TABLE IF NOT EXISTS `vezba22`.`Period` (
- `PeriodID` INT(11) NOT NULL,
- `Period` VARCHAR(45) NULL DEFAULT NULL,
- PRIMARY KEY (`PeriodID`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = latin1;
- CREATE TABLE IF NOT EXISTS `vezba22`.`Tip_Antikviteta` (
- `TipAntikvitetaID` INT(11) NOT NULL,
- `Tip` VARCHAR(45) NULL DEFAULT NULL,
- PRIMARY KEY (`TipAntikvitetaID`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement