Code:
CREATE SCHEMA IF NOT EXISTS `laboratorija` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `laboratorija`;
CREATE TABLE IF NOT EXISTS `laboratorija`.`korisnik` (
`korisnikID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`korUsername` VARCHAR(45) NOT NULL ,
`korPassword` VARCHAR(45) NOT NULL ,
`korPassword2` VARCHAR(45) NOT NULL ,
`korIme` VARCHAR(45) NOT NULL ,
`korPrezime` VARCHAR(45) NOT NULL ,
`korTelefon` VARCHAR(45) NOT NULL ,
`korEmail` VARCHAR(45) NULL DEFAULT NULL ,
`korOdsek` VARCHAR(45) NOT NULL ,
`korgodStud` INT(11) NOT NULL ,
`korProsek` DOUBLE NOT NULL ,
`korTip` INT(11) NULL DEFAULT NULL ,
`korTipstring` VARCHAR(45) NOT NULL ,
`oznacenN` TINYINT(1) NULL DEFAULT NULL ,
`oznacenD` TINYINT(1) NULL DEFAULT NULL ,
`prisustvovao` TINYINT(1) NULL DEFAULT NULL ,
`pozvan` TINYINT(1) NULL DEFAULT NULL ,
`zauzet` TINYINT(1) NULL DEFAULT NULL ,
PRIMARY KEY (`korisnikID`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`labvezba` (
`labID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`nazivVezbe` VARCHAR(45) NOT NULL ,
`sifraAkt` INT(11) NOT NULL ,
`sifraPredmeta` INT(11) NOT NULL ,
`datumO` DATE NULL DEFAULT NULL ,
`vremeP` TIME NULL DEFAULT NULL ,
`vremeK` TIME NULL DEFAULT NULL ,
`korisnikID` INT(11) NULL DEFAULT NULL ,
`brojU` INT(11) NOT NULL ,
`maxbrDem` INT(11) NOT NULL ,
`zakljucena` TINYINT(4) NULL DEFAULT NULL ,
PRIMARY KEY (`labID`) ,
FOREIGN KEY (`korisnikID`)
REFERENCES `laboratorija`.`korisnik` (`korisnikID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`sifraPredmeta`)
REFERENCES `laboratorija`.`predmet` (`sifraPredmeta`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`sifraAkt`)
REFERENCES `laboratorija`.`sifarnik` (`sifraAkt`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`datumO`)
REFERENCES `laboratorija`.`datum` (`datumID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`sifarnik` (
`sifraAkt` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`tipVezbe` VARCHAR(45) NOT NULL ,
`koeficijent` DOUBLE NOT NULL ,
PRIMARY KEY (`sifraAkt`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`predmet` (
`sifraPredmeta` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`nazivP` VARCHAR(45) NOT NULL ,
`semestar` INT(11) NOT NULL ,
`semString` VARCHAR(45) NOT NULL ,
`selektovan` TINYINT(4) NULL DEFAULT NULL ,
`aktuelan` TINYINT(4) NULL DEFAULT NULL ,
`otvorenaprijava` TINYINT(4) NULL DEFAULT NULL ,
PRIMARY KEY (`sifraPredmeta`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`predmetikor` (
`korisnikID` INT(11) UNSIGNED NOT NULL ,
`godID` INT(11) NOT NULL ,
`oznacen` TINYINT(4) NULL DEFAULT NULL ,
`aktivan` TINYINT(4) NULL DEFAULT NULL ,
`sifraPredmeta` INT(11) NOT NULL ,
FOREIGN KEY (`korisnikID`)
REFERENCES `laboratorija`.`korisnik` (`korisnikID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`godID`)
REFERENCES `laboratorija`.`skolgod` (`godID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`sifraPredmeta`)
REFERENCES `laboratorija`.`predmet` (`sifraPredmeta`)
ON DELETE RESTRICT
ON UPDATE CASCADE
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`ucesnici` (
`korisnikID` INT(11) UNSIGNED NOT NULL ,
`labID` INT(11) UNSIGNED NOT NULL ,
`potvrdio` TINYINT(4) NULL DEFAULT NULL ,
`prisustvovao` TINYINT(4) NULL DEFAULT NULL ,
`komentar` VARCHAR(45) NULL DEFAULT NULL ,
`placen` TINYINT(4) NULL DEFAULT NULL ,
FOREIGN KEY (`korisnikID`)
REFERENCES `laboratorija`.`korisnik` (`korisnikID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`labID`)
REFERENCES `laboratorija`.`labvezba` (`labID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
PRIMARY KEY (`korisnikID`,`labID`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`datum` (
`datumID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`datGod` INT(11) NULL DEFAULT NULL ,
`datMes` INT(11) NULL DEFAULT NULL ,
`datDan` INT(11) NULL DEFAULT NULL ,
`datSat` INT(11) NULL DEFAULT NULL ,
`datMin` INT(11) NULL DEFAULT NULL ,
PRIMARY KEY (`datumID`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`skolgod` (
`godID` INT(10) UNSIGNED NOT NULL ,
`skolskagodina` VARCHAR(45) NOT NULL ,
`sifraPredmeta` INT(11) UNSIGNED NOT NULL ,
PRIMARY KEY (`godID`) ,
FOREIGN KEY (`sifraPredmeta`)
REFERENCES `laboratorija`.`predmet` (`sifraPredmeta`)
ON DELETE RESTRICT
ON UPDATE CASCADE
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`obracun` (
`obracunID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`labID` INT(11) UNSIGNED NOT NULL ,
`korisnikID` INT(11) UNSIGNED NOT NULL ,
`cena` INT(11) NULL DEFAULT 10 ,
`iznosHon` DOUBLE NOT NULL ,
`datumID` INT(11) NULL DEFAULT NULL ,
`napravljen` TINYINT(4) NULL DEFAULT NULL ,
PRIMARY KEY (`obracunID`) ,
FOREIGN KEY (`datumID`)
REFERENCES `laboratorija`.`datum` (`datumID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`labID`)
REFERENCES `laboratorija`.`labvezba` (`labID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`korisnikID`)
REFERENCES `laboratorija`.`korisnik` (`korisnikID`)
ON DELETE RESTRICT
ON UPDATE CASCADE
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE SCHEMA IF NOT EXISTS `laboratorija` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `laboratorija`;
CREATE TABLE IF NOT EXISTS `laboratorija`.`korisnik` (
`korisnikID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`korUsername` VARCHAR(45) NOT NULL ,
`korPassword` VARCHAR(45) NOT NULL ,
`korPassword2` VARCHAR(45) NOT NULL ,
`korIme` VARCHAR(45) NOT NULL ,
`korPrezime` VARCHAR(45) NOT NULL ,
`korTelefon` VARCHAR(45) NOT NULL ,
`korEmail` VARCHAR(45) NULL DEFAULT NULL ,
`korOdsek` VARCHAR(45) NOT NULL ,
`korgodStud` INT(11) NOT NULL ,
`korProsek` DOUBLE NOT NULL ,
`korTip` INT(11) NULL DEFAULT NULL ,
`korTipstring` VARCHAR(45) NOT NULL ,
`oznacenN` TINYINT(1) NULL DEFAULT NULL ,
`oznacenD` TINYINT(1) NULL DEFAULT NULL ,
`prisustvovao` TINYINT(1) NULL DEFAULT NULL ,
`pozvan` TINYINT(1) NULL DEFAULT NULL ,
`zauzet` TINYINT(1) NULL DEFAULT NULL ,
PRIMARY KEY (`korisnikID`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`labvezba` (
`labID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`nazivVezbe` VARCHAR(45) NOT NULL ,
`sifraAkt` INT(11) NOT NULL ,
`sifraPredmeta` INT(11) NOT NULL ,
`datumO` DATE NULL DEFAULT NULL ,
`vremeP` TIME NULL DEFAULT NULL ,
`vremeK` TIME NULL DEFAULT NULL ,
`korisnikID` INT(11) NULL DEFAULT NULL ,
`brojU` INT(11) NOT NULL ,
`maxbrDem` INT(11) NOT NULL ,
`zakljucena` TINYINT(4) NULL DEFAULT NULL ,
PRIMARY KEY (`labID`) ,
FOREIGN KEY (`korisnikID`)
REFERENCES `laboratorija`.`korisnik` (`korisnikID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`sifraPredmeta`)
REFERENCES `laboratorija`.`predmet` (`sifraPredmeta`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`sifraAkt`)
REFERENCES `laboratorija`.`sifarnik` (`sifraAkt`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`datumO`)
REFERENCES `laboratorija`.`datum` (`datumID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`sifarnik` (
`sifraAkt` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`tipVezbe` VARCHAR(45) NOT NULL ,
`koeficijent` DOUBLE NOT NULL ,
PRIMARY KEY (`sifraAkt`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`predmet` (
`sifraPredmeta` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`nazivP` VARCHAR(45) NOT NULL ,
`semestar` INT(11) NOT NULL ,
`semString` VARCHAR(45) NOT NULL ,
`selektovan` TINYINT(4) NULL DEFAULT NULL ,
`aktuelan` TINYINT(4) NULL DEFAULT NULL ,
`otvorenaprijava` TINYINT(4) NULL DEFAULT NULL ,
PRIMARY KEY (`sifraPredmeta`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`predmetikor` (
`korisnikID` INT(11) UNSIGNED NOT NULL ,
`godID` INT(11) NOT NULL ,
`oznacen` TINYINT(4) NULL DEFAULT NULL ,
`aktivan` TINYINT(4) NULL DEFAULT NULL ,
`sifraPredmeta` INT(11) NOT NULL ,
FOREIGN KEY (`korisnikID`)
REFERENCES `laboratorija`.`korisnik` (`korisnikID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`godID`)
REFERENCES `laboratorija`.`skolgod` (`godID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`sifraPredmeta`)
REFERENCES `laboratorija`.`predmet` (`sifraPredmeta`)
ON DELETE RESTRICT
ON UPDATE CASCADE
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`ucesnici` (
`korisnikID` INT(11) UNSIGNED NOT NULL ,
`labID` INT(11) UNSIGNED NOT NULL ,
`potvrdio` TINYINT(4) NULL DEFAULT NULL ,
`prisustvovao` TINYINT(4) NULL DEFAULT NULL ,
`komentar` VARCHAR(45) NULL DEFAULT NULL ,
`placen` TINYINT(4) NULL DEFAULT NULL ,
FOREIGN KEY (`korisnikID`)
REFERENCES `laboratorija`.`korisnik` (`korisnikID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`labID`)
REFERENCES `laboratorija`.`labvezba` (`labID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
PRIMARY KEY (`korisnikID`,`labID`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`datum` (
`datumID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`datGod` INT(11) NULL DEFAULT NULL ,
`datMes` INT(11) NULL DEFAULT NULL ,
`datDan` INT(11) NULL DEFAULT NULL ,
`datSat` INT(11) NULL DEFAULT NULL ,
`datMin` INT(11) NULL DEFAULT NULL ,
PRIMARY KEY (`datumID`)
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`skolgod` (
`godID` INT(10) UNSIGNED NOT NULL ,
`skolskagodina` VARCHAR(45) NOT NULL ,
`sifraPredmeta` INT(11) UNSIGNED NOT NULL ,
PRIMARY KEY (`godID`) ,
FOREIGN KEY (`sifraPredmeta`)
REFERENCES `laboratorija`.`predmet` (`sifraPredmeta`)
ON DELETE RESTRICT
ON UPDATE CASCADE
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
CREATE TABLE IF NOT EXISTS `laboratorija`.`obracun` (
`obracunID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`labID` INT(11) UNSIGNED NOT NULL ,
`korisnikID` INT(11) UNSIGNED NOT NULL ,
`cena` INT(11) NULL DEFAULT 10 ,
`iznosHon` DOUBLE NOT NULL ,
`datumID` INT(11) NULL DEFAULT NULL ,
`napravljen` TINYINT(4) NULL DEFAULT NULL ,
PRIMARY KEY (`obracunID`) ,
FOREIGN KEY (`datumID`)
REFERENCES `laboratorija`.`datum` (`datumID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`labID`)
REFERENCES `laboratorija`.`labvezba` (`labID`)
ON DELETE RESTRICT
ON UPDATE CASCADE,
FOREIGN KEY (`korisnikID`)
REFERENCES `laboratorija`.`korisnik` (`korisnikID`)
ON DELETE RESTRICT
ON UPDATE CASCADE
)ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
Kaze da ne moze da napravi tabele ucesnici i skolgod,ako moze pomoc!