Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL Script generated by MySQL Workbench
- -- Thu Jan 16 10:09:46 2020
- -- Model: New Model Version: 1.0
- -- MySQL Workbench Forward Engineering
- SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
- SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
- SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
- -- -----------------------------------------------------
- -- Schema mydb
- -- -----------------------------------------------------
- -- -----------------------------------------------------
- -- Schema mydb
- -- -----------------------------------------------------
- CREATE SCHEMA IF NOT EXISTS `baza` DEFAULT CHARACTER SET utf8 ;
- USE `baza` ;
- -- -----------------------------------------------------
- -- Table `mydb`.`User`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `baza`.`User` (
- `idUser` INT NOT NULL AUTO_INCREMENT,
- `username` VARCHAR(45) NOT NULL,
- `password` VARCHAR(45) NOT NULL,
- `email` VARCHAR(45) NULL,
- `firstName` VARCHAR(45) NOT NULL,
- `lastName` VARCHAR(45) NOT NULL,
- `phoneNumber` VARCHAR(45) NULL,
- `country` VARCHAR(45) NULL,
- `city` VARCHAR(45) NULL,
- `imageLink` VARCHAR(45) NULL,
- PRIMARY KEY (`idUser`),
- UNIQUE INDEX `userId` (`idUser` ASC),
- UNIQUE INDEX `username` (`username` ASC),
- UNIQUE INDEX `password` (`password` ASC))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`Category`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `baza`.`Category` (
- `idCategory` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`idCategory`),
- UNIQUE INDEX `idCategory` (`idCategory` ASC))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`Item`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `baza`.`Item` (
- `itemId` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(45) NOT NULL,
- `description` VARCHAR(45) NULL,
- `Category_idCategory` INT NOT NULL,
- `User_idUser` INT NOT NULL,
- PRIMARY KEY (`itemId`),
- UNIQUE INDEX `itemId` (`itemId` ASC),
- INDEX `fk_Item_Category_idx` (`Category_idCategory` ASC),
- INDEX `fk_Item_User1_idx` (`User_idUser` ASC),
- CONSTRAINT `fk_Item_Category`
- FOREIGN KEY (`Category_idCategory`)
- REFERENCES `baza`.`Category` (`idCategory`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_Item_User1`
- FOREIGN KEY (`User_idUser`)
- REFERENCES `baza`.`User` (`idUser`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`Bid`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `baza`.`Bid` (
- `idBid` INT NOT NULL AUTO_INCREMENT,
- `startingPrice` INT NOT NULL,
- `currentPrice` INT NULL,
- `startingDate` DATE NOT NULL,
- `endDate` DATE NULL,
- `Item_itemId` INT NOT NULL,
- PRIMARY KEY (`idBid`),
- UNIQUE INDEX `idBid` (`idBid` ASC),
- INDEX `fk_Bid_Item1_idx` (`Item_itemId` ASC),
- CONSTRAINT `fk_Bid_Item1`
- FOREIGN KEY (`Item_itemId`)
- REFERENCES `baza`.`Item` (`itemId`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`Image`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `baza`.`Image` (
- `idImage` INT NOT NULL AUTO_INCREMENT,
- `imageLink` VARCHAR(45) NOT NULL,
- `Item_itemId` INT NOT NULL,
- PRIMARY KEY (`idImage`),
- UNIQUE INDEX `idImage` (`idImage` ASC),
- INDEX `fk_Image_Item1_idx` (`Item_itemId` ASC),
- CONSTRAINT `fk_Image_Item1`
- FOREIGN KEY (`Item_itemId`)
- REFERENCES `baza`.`Item` (`itemId`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`Message`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `baza`.`Message` (
- `idMessage` INT NOT NULL AUTO_INCREMENT,
- `content` VARCHAR(45) NOT NULL,
- `User_idUserSender` INT NOT NULL,
- `User_idUserReceiver` INT NOT NULL,
- PRIMARY KEY (`idMessage`),
- UNIQUE INDEX `idMessage` (`idMessage` ASC),
- INDEX `fk_Message_User1_idx` (`User_idUserSender` ASC),
- INDEX `fk_Message_User2_idx` (`User_idUserReceiver` ASC),
- CONSTRAINT `fk_Message_User1`
- FOREIGN KEY (`User_idUserSender`)
- REFERENCES `baza`.`User` (`idUser`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_Message_User2`
- FOREIGN KEY (`User_idUserReceiver`)
- REFERENCES `baza`.`User` (`idUser`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`Rating`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `baza`.`Rating` (
- `idRating` INT NOT NULL AUTO_INCREMENT,
- `rating` INT NOT NULL,
- `User_idUserSender` INT NOT NULL,
- `User_idUserReceiver` INT NOT NULL,
- PRIMARY KEY (`idRating`),
- UNIQUE INDEX `idRating` (`idRating` ASC),
- INDEX `fk_Rating_User1_idx` (`User_idUserSender` ASC),
- INDEX `fk_Rating_User2_idx` (`User_idUserReceiver` ASC),
- CONSTRAINT `fk_Rating_User1`
- FOREIGN KEY (`User_idUserSender`)
- REFERENCES `baza`.`User` (`idUser`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_Rating_User2`
- FOREIGN KEY (`User_idUserReceiver`)
- REFERENCES `baza`.`User` (`idUser`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`User_has_Bid`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `baza`.`User_has_Bid` (
- `User_idUser` INT NOT NULL,
- `Bid_idBid` INT NOT NULL,
- INDEX `fk_User_has_Bid_Bid1_idx` (`Bid_idBid` ASC),
- INDEX `fk_User_has_Bid_User1_idx` (`User_idUser` ASC),
- CONSTRAINT `fk_User_has_Bid_User1`
- FOREIGN KEY (`User_idUser`)
- REFERENCES `baza`.`User` (`idUser`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_User_has_Bid_Bid1`
- FOREIGN KEY (`Bid_idBid`)
- REFERENCES `baza`.`Bid` (`idBid`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement