2iVRqJzf

1-- MySQL Script generated by MySQL Workbench
2-- Fri Nov 16 19:34:41 2018
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 `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Users` (
24  `idUsers` INT NOT NULL AUTO_INCREMENT,
25  `name` VARCHAR(45) NULL,
26  `surname` VARCHAR(45) NULL,
27  `login` VARCHAR(45) NULL,
28  `pw` VARCHAR(45) NOT NULL,
29  `email` VARCHAR(45) NOT NULL,
30  `telephone` VARCHAR(45) NULL,
31  `address` VARCHAR(45) NULL,
32  `created` DATE NULL,
33  `country` VARCHAR(45) NULL,
34  PRIMARY KEY (`idUsers`))
35ENGINE = InnoDB;
36
37
38-- -----------------------------------------------------
39-- Table `mydb`.`Ratings`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `mydb`.`Ratings` (
42  `idRatings` INT NOT NULL AUTO_INCREMENT,
43  `id_buyer` INT NOT NULL,
44  `id_seller` INT NOT NULL,
45  `created` DATE NULL,
46  `description` VARCHAR(45) NULL,
47  `rating` INT NOT NULL,
48  PRIMARY KEY (`idRatings`),
49  INDEX `fk_Ratings_Users_idx` (`id_buyer` ASC) VISIBLE,
50  INDEX `fk_Ratings_Users1_idx` (`id_seller` ASC) VISIBLE,
51  CONSTRAINT `fk_Ratings_Users`
52    FOREIGN KEY (`id_buyer`)
53    REFERENCES `mydb`.`Users` (`idUsers`)
54    ON DELETE NO ACTION
55    ON UPDATE NO ACTION,
56  CONSTRAINT `fk_Ratings_Users1`
57    FOREIGN KEY (`id_seller`)
58    REFERENCES `mydb`.`Users` (`idUsers`)
59    ON DELETE NO ACTION
60    ON UPDATE NO ACTION)
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `mydb`.`Machines`
66-- -----------------------------------------------------
67CREATE TABLE IF NOT EXISTS `mydb`.`Machines` (
68  `idMachines` INT NOT NULL AUTO_INCREMENT,
69  `id_owner` INT NOT NULL,
70  `machine_name` VARCHAR(45) NOT NULL,
71  `model` VARCHAR(45) NULL,
72  `brand` VARCHAR(45) NULL,
73  `km` INT NULL,
74  `hour` INT NULL,
75  `country` VARCHAR(45) NULL,
76  `serialNuber` VARCHAR(50) NULL,
77  `condition` VARCHAR(45) NULL,
78  PRIMARY KEY (`idMachines`),
79  INDEX `fk_Machines_Users1_idx` (`id_owner` ASC) VISIBLE,
80  CONSTRAINT `fk_Machines_Users1`
81    FOREIGN KEY (`id_owner`)
82    REFERENCES `mydb`.`Users` (`idUsers`)
83    ON DELETE NO ACTION
84    ON UPDATE NO ACTION)
85ENGINE = InnoDB;
86
87
88-- -----------------------------------------------------
89-- Table `mydb`.`Listing`
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS `mydb`.`Listing` (
92  `idListing` INT NOT NULL AUTO_INCREMENT,
93  `id_seller` INT NULL,
94  `id_maschine` INT NULL,
95  `price` INT NULL,
96  `location` VARCHAR(45) NULL,
97  PRIMARY KEY (`idListing`))
98ENGINE = InnoDB;
99
100
101SET SQL_MODE=@OLD_SQL_MODE;
102SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
103SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;