· 8 years ago · Feb 15, 2018, 08:56 PM
1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema jpdsi_calculator
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`.`customer`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`customer` (
24 `idcustomer` INT(11) NOT NULL AUTO_INCREMENT,
25 `name` TINYTEXT NULL DEFAULT NULL,
26 `surname` TINYTEXT NULL DEFAULT NULL,
27 `city` TINYTEXT NULL DEFAULT NULL,
28 `street_and_home` TINYTEXT NULL DEFAULT NULL,
29 PRIMARY KEY (`idcustomer`))
30ENGINE = InnoDB
31DEFAULT CHARACTER SET = utf8;
32
33
34-- -----------------------------------------------------
35-- Table `mydb`.`user`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `mydb`.`user` (
38 `iduser` INT(11) NOT NULL AUTO_INCREMENT,
39 `login` TINYTEXT NULL DEFAULT NULL,
40 `pass` TINYTEXT NULL DEFAULT NULL,
41 `role` INT(1) NULL DEFAULT NULL,
42 PRIMARY KEY (`iduser`))
43ENGINE = InnoDB
44DEFAULT CHARACTER SET = utf8;
45
46
47-- -----------------------------------------------------
48-- Table `mydb`.`car`
49-- -----------------------------------------------------
50CREATE TABLE IF NOT EXISTS `mydb`.`car` (
51 `idcar` INT(11) NOT NULL AUTO_INCREMENT,
52 `mark` TINYTEXT NULL DEFAULT NULL,
53 `model` TINYTEXT NULL DEFAULT NULL,
54 `buy_date` DATE NULL DEFAULT NULL,
55 `sell_date` DATE NULL DEFAULT NULL,
56 `buy_price` INT(11) NULL DEFAULT NULL,
57 `sell_price` INT(11) NULL DEFAULT NULL,
58 `add_cost` INT(11) NULL DEFAULT NULL,
59 `sum_cost` INT(11) NULL DEFAULT NULL,
60 `gain` INT(11) NULL DEFAULT NULL,
61 `sell_state` INT(1) NULL DEFAULT NULL,
62 `customer_idcustomer` INT(11) NOT NULL,
63 `user_iduser` INT(11) NOT NULL,
64 PRIMARY KEY (`idcar`),
65 INDEX `fk_car_customer_idx` (`customer_idcustomer` ASC),
66 INDEX `fk_car_user1_idx` (`user_iduser` ASC),
67 CONSTRAINT `fk_car_customer`
68 FOREIGN KEY (`customer_idcustomer`)
69 REFERENCES `mydb`.`customer` (`idcustomer`)
70 ON DELETE NO ACTION
71 ON UPDATE NO ACTION,
72 CONSTRAINT `fk_car_user1`
73 FOREIGN KEY (`user_iduser`)
74 REFERENCES `mydb`.`user` (`iduser`)
75 ON DELETE NO ACTION
76 ON UPDATE NO ACTION)
77ENGINE = InnoDB
78DEFAULT CHARACTER SET = utf8;
79
80
81-- -----------------------------------------------------
82-- Table `mydb`.`additional_cost`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `mydb`.`additional_cost` (
85 `idadd_cost` INT(11) NOT NULL AUTO_INCREMENT,
86 `part` TINYTEXT NULL DEFAULT NULL,
87 `cost` INT(11) NULL DEFAULT NULL,
88 `car_idcar` INT(11) NOT NULL,
89 PRIMARY KEY (`idadd_cost`),
90 INDEX `fk_additional_cost_car1_idx` (`car_idcar` ASC),
91 CONSTRAINT `fk_additional_cost_car1`
92 FOREIGN KEY (`car_idcar`)
93 REFERENCES `mydb`.`car` (`idcar`)
94 ON DELETE NO ACTION
95 ON UPDATE NO ACTION)
96ENGINE = InnoDB
97DEFAULT CHARACTER SET = utf8;
98
99
100SET SQL_MODE=@OLD_SQL_MODE;
101SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
102SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;