G2Nd28cp

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4
5CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
6USE `mydb` ;
7
8-- -----------------------------------------------------
9-- Table `mydb`.`Client`
10-- -----------------------------------------------------
11CREATE TABLE IF NOT EXISTS `mydb`.`Client` (
12  `idClient` INT NOT NULL AUTO_INCREMENT,
13  `Nume` VARCHAR(45) NOT NULL,
14  `Prenume` VARCHAR(45) NOT NULL,
15  `Adresa` VARCHAR(45) NOT NULL,
16  `Telefon` VARCHAR(45) NOT NULL,
17  PRIMARY KEY (`idClient`))
18ENGINE = InnoDB;
19
20
21-- -----------------------------------------------------
22-- Table `mydb`.`Produs`
23-- -----------------------------------------------------
24CREATE TABLE IF NOT EXISTS `mydb`.`Produs` (
25  `idProdus` INT NOT NULL AUTO_INCREMENT,
26  `Nume` VARCHAR(45) NOT NULL,
27  `Pret` FLOAT NOT NULL,
28  `Cantitate` INT NOT NULL,
29  PRIMARY KEY (`idProdus`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`Comanda`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`Comanda` (
37  `idComanda` INT NOT NULL AUTO_INCREMENT,
38  `Data` VARCHAR(45) NOT NULL,
39  `Client_idClient` INT NOT NULL,
40  PRIMARY KEY (`idComanda`, `Client_idClient`),
41  INDEX `fk_Comanda_Client1_idx` (`Client_idClient` ASC),
42  CONSTRAINT `fk_Comanda_Client1`
43    FOREIGN KEY (`Client_idClient`)
44    REFERENCES `mydb`.`Client` (`idClient`)
45    ON DELETE CASCADE
46    ON UPDATE CASCADE)
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `mydb`.`InfoComanda`
52-- -----------------------------------------------------
53CREATE TABLE IF NOT EXISTS `mydb`.`InfoComanda` (
54  `Comanda_idComanda` INT NOT NULL,
55  `Produs_idProdus` INT NOT NULL,
56  `Cantitate` INT NOT NULL,
57  PRIMARY KEY (`Comanda_idComanda`, `Produs_idProdus`),
58  INDEX `fk_Comanda_has_Produs_Produs1_idx` (`Produs_idProdus` ASC),
59  INDEX `fk_Comanda_has_Produs_Comanda_idx` (`Comanda_idComanda` ASC),
60  CONSTRAINT `fk_Comanda_has_Produs_Comanda`
61    FOREIGN KEY (`Comanda_idComanda`)
62    REFERENCES `mydb`.`Comanda` (`idComanda`)
63    ON DELETE CASCADE
64    ON UPDATE CASCADE,
65  CONSTRAINT `fk_Comanda_has_Produs_Produs1`
66    FOREIGN KEY (`Produs_idProdus`)
67    REFERENCES `mydb`.`Produs` (`idProdus`)
68    ON DELETE CASCADE
69    ON UPDATE CASCADE)
70ENGINE = InnoDB;
71
72
73SET SQL_MODE=@OLD_SQL_MODE;
74SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
75SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;