· 6 years ago · Jan 18, 2020, 08:32 PM
1-- MySQL Script generated by MySQL Workbench
2-- Thu Jan 16 10:09:46 2020
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @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';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `baza` DEFAULT CHARACTER SET utf8 ;
18USE `baza` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`User`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `baza`.`User` (
24 `idUser` INT NOT NULL AUTO_INCREMENT,
25 `username` VARCHAR(45) NOT NULL,
26 `password` VARCHAR(45) NOT NULL,
27 `email` VARCHAR(45) NULL,
28 `firstName` VARCHAR(45) NOT NULL,
29 `lastName` VARCHAR(45) NOT NULL,
30 `phoneNumber` VARCHAR(45) NULL,
31 `country` VARCHAR(45) NULL,
32 `city` VARCHAR(45) NULL,
33 `imageLink` VARCHAR(45) NULL,
34 PRIMARY KEY (`idUser`),
35 UNIQUE INDEX `userId` (`idUser` ASC),
36 UNIQUE INDEX `username` (`username` ASC),
37 UNIQUE INDEX `password` (`password` ASC))
38ENGINE = InnoDB;
39
40
41-- -----------------------------------------------------
42-- Table `mydb`.`Category`
43-- -----------------------------------------------------
44CREATE TABLE IF NOT EXISTS `baza`.`Category` (
45 `idCategory` INT NOT NULL AUTO_INCREMENT,
46 `name` VARCHAR(45) NOT NULL,
47 PRIMARY KEY (`idCategory`),
48 UNIQUE INDEX `idCategory` (`idCategory` ASC))
49ENGINE = InnoDB;
50
51
52-- -----------------------------------------------------
53-- Table `mydb`.`Item`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `baza`.`Item` (
56 `itemId` INT NOT NULL AUTO_INCREMENT,
57 `name` VARCHAR(45) NOT NULL,
58 `description` VARCHAR(45) NULL,
59 `Category_idCategory` INT NOT NULL,
60 `User_idUser` INT NOT NULL,
61 PRIMARY KEY (`itemId`),
62 UNIQUE INDEX `itemId` (`itemId` ASC),
63 INDEX `fk_Item_Category_idx` (`Category_idCategory` ASC),
64 INDEX `fk_Item_User1_idx` (`User_idUser` ASC),
65 CONSTRAINT `fk_Item_Category`
66 FOREIGN KEY (`Category_idCategory`)
67 REFERENCES `baza`.`Category` (`idCategory`)
68 ON DELETE NO ACTION
69 ON UPDATE NO ACTION,
70 CONSTRAINT `fk_Item_User1`
71 FOREIGN KEY (`User_idUser`)
72 REFERENCES `baza`.`User` (`idUser`)
73 ON DELETE NO ACTION
74 ON UPDATE NO ACTION)
75ENGINE = InnoDB;
76
77
78-- -----------------------------------------------------
79-- Table `mydb`.`Bid`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `baza`.`Bid` (
82 `idBid` INT NOT NULL AUTO_INCREMENT,
83 `startingPrice` INT NOT NULL,
84 `currentPrice` INT NULL,
85 `startingDate` DATE NOT NULL,
86 `endDate` DATE NULL,
87 `Item_itemId` INT NOT NULL,
88 PRIMARY KEY (`idBid`),
89 UNIQUE INDEX `idBid` (`idBid` ASC),
90 INDEX `fk_Bid_Item1_idx` (`Item_itemId` ASC),
91 CONSTRAINT `fk_Bid_Item1`
92 FOREIGN KEY (`Item_itemId`)
93 REFERENCES `baza`.`Item` (`itemId`)
94 ON DELETE NO ACTION
95 ON UPDATE NO ACTION)
96ENGINE = InnoDB;
97
98
99-- -----------------------------------------------------
100-- Table `mydb`.`Image`
101-- -----------------------------------------------------
102CREATE TABLE IF NOT EXISTS `baza`.`Image` (
103 `idImage` INT NOT NULL AUTO_INCREMENT,
104 `imageLink` VARCHAR(45) NOT NULL,
105 `Item_itemId` INT NOT NULL,
106 PRIMARY KEY (`idImage`),
107 UNIQUE INDEX `idImage` (`idImage` ASC),
108 INDEX `fk_Image_Item1_idx` (`Item_itemId` ASC),
109 CONSTRAINT `fk_Image_Item1`
110 FOREIGN KEY (`Item_itemId`)
111 REFERENCES `baza`.`Item` (`itemId`)
112 ON DELETE NO ACTION
113 ON UPDATE NO ACTION)
114ENGINE = InnoDB;
115
116
117-- -----------------------------------------------------
118-- Table `mydb`.`Message`
119-- -----------------------------------------------------
120CREATE TABLE IF NOT EXISTS `baza`.`Message` (
121 `idMessage` INT NOT NULL AUTO_INCREMENT,
122 `content` VARCHAR(45) NOT NULL,
123 `User_idUserSender` INT NOT NULL,
124 `User_idUserReceiver` INT NOT NULL,
125 PRIMARY KEY (`idMessage`),
126 UNIQUE INDEX `idMessage` (`idMessage` ASC),
127 INDEX `fk_Message_User1_idx` (`User_idUserSender` ASC),
128 INDEX `fk_Message_User2_idx` (`User_idUserReceiver` ASC),
129 CONSTRAINT `fk_Message_User1`
130 FOREIGN KEY (`User_idUserSender`)
131 REFERENCES `baza`.`User` (`idUser`)
132 ON DELETE NO ACTION
133 ON UPDATE NO ACTION,
134 CONSTRAINT `fk_Message_User2`
135 FOREIGN KEY (`User_idUserReceiver`)
136 REFERENCES `baza`.`User` (`idUser`)
137 ON DELETE NO ACTION
138 ON UPDATE NO ACTION)
139ENGINE = InnoDB;
140
141
142-- -----------------------------------------------------
143-- Table `mydb`.`Rating`
144-- -----------------------------------------------------
145CREATE TABLE IF NOT EXISTS `baza`.`Rating` (
146 `idRating` INT NOT NULL AUTO_INCREMENT,
147 `rating` INT NOT NULL,
148 `User_idUserSender` INT NOT NULL,
149 `User_idUserReceiver` INT NOT NULL,
150 PRIMARY KEY (`idRating`),
151 UNIQUE INDEX `idRating` (`idRating` ASC),
152 INDEX `fk_Rating_User1_idx` (`User_idUserSender` ASC),
153 INDEX `fk_Rating_User2_idx` (`User_idUserReceiver` ASC),
154 CONSTRAINT `fk_Rating_User1`
155 FOREIGN KEY (`User_idUserSender`)
156 REFERENCES `baza`.`User` (`idUser`)
157 ON DELETE NO ACTION
158 ON UPDATE NO ACTION,
159 CONSTRAINT `fk_Rating_User2`
160 FOREIGN KEY (`User_idUserReceiver`)
161 REFERENCES `baza`.`User` (`idUser`)
162 ON DELETE NO ACTION
163 ON UPDATE NO ACTION)
164ENGINE = InnoDB;
165
166
167-- -----------------------------------------------------
168-- Table `mydb`.`User_has_Bid`
169-- -----------------------------------------------------
170CREATE TABLE IF NOT EXISTS `baza`.`User_has_Bid` (
171 `User_idUser` INT NOT NULL,
172 `Bid_idBid` INT NOT NULL,
173 INDEX `fk_User_has_Bid_Bid1_idx` (`Bid_idBid` ASC),
174 INDEX `fk_User_has_Bid_User1_idx` (`User_idUser` ASC),
175 CONSTRAINT `fk_User_has_Bid_User1`
176 FOREIGN KEY (`User_idUser`)
177 REFERENCES `baza`.`User` (`idUser`)
178 ON DELETE NO ACTION
179 ON UPDATE NO ACTION,
180 CONSTRAINT `fk_User_has_Bid_Bid1`
181 FOREIGN KEY (`Bid_idBid`)
182 REFERENCES `baza`.`Bid` (`idBid`)
183 ON DELETE NO ACTION
184 ON UPDATE NO ACTION)
185ENGINE = InnoDB;
186
187
188SET SQL_MODE=@OLD_SQL_MODE;
189SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
190SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;