ZTzw6FR6

1
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema AUTOPARTS
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema AUTOPARTS
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `AUTOPARTS` DEFAULT CHARACTER SET latin1 COLLATE latin1_spanish_ci ;
15USE `AUTOPARTS` ;
16
17-- -----------------------------------------------------
18-- Table `AUTOPARTS`.`CUSTOMERS`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `AUTOPARTS`.`CUSTOMERS` (
21  `Customers_id` INT NOT NULL,
22  `identification` VARCHAR(15) NOT NULL,
23  `name` VARCHAR(45) NOT NULL,
24  `surname` VARCHAR(45) NOT NULL,
25  `mail` VARCHAR(256) NOT NULL,
26  `phone` VARCHAR(15) NOT NULL,
27  PRIMARY KEY (`Customers_id`))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `AUTOPARTS`.`RECEIPTS`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `AUTOPARTS`.`RECEIPTS` (
35  `Receipt_id` INT NOT NULL,
36  `date` DATETIME NOT NULL,
37  `customer_id` INT NOT NULL,
38  PRIMARY KEY (`Receipt_id`),
39  INDEX `customerfk_id_idx` (`customer_id` ASC) VISIBLE,
40  CONSTRAINT `customerfk_id`
41    FOREIGN KEY (`customer_id`)
42    REFERENCES `AUTOPARTS`.`CUSTOMERS` (`Customers_id`)
43    ON DELETE NO ACTION
44    ON UPDATE NO ACTION)
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `AUTOPARTS`.`PRODUCTS`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `AUTOPARTS`.`PRODUCTS` (
52  `Products_id` INT NOT NULL,
53  `nameProduct` VARCHAR(45) NOT NULL,
54  `description` VARCHAR(80) NOT NULL,
55  `brand` VARCHAR(70) NOT NULL,
56  `dateCreation` DATETIME NOT NULL,
57  PRIMARY KEY (`Products_id`))
58ENGINE = InnoDB;
59
60
61-- -----------------------------------------------------
62-- Table `AUTOPARTS`.`DETAILS`
63-- -----------------------------------------------------
64CREATE TABLE IF NOT EXISTS `AUTOPARTS`.`DETAILS` (
65  `Details_id` INT NOT NULL,
66  `receipt_id` INT NOT NULL,
67  `product_id` INT NOT NULL,
68  `quantity` VARCHAR(7) NOT NULL,
69  PRIMARY KEY (`Details_id`),
70  INDEX `receiptfk_id_idx` (`receipt_id` ASC) VISIBLE,
71  INDEX `productfk_id_idx` (`product_id` ASC) VISIBLE,
72  CONSTRAINT `receiptfk_id`
73    FOREIGN KEY (`receipt_id`)
74    REFERENCES `AUTOPARTS`.`RECEIPTS` (`Receipt_id`)
75    ON DELETE NO ACTION
76    ON UPDATE NO ACTION,
77  CONSTRAINT `productfk_id`
78    FOREIGN KEY (`product_id`)
79    REFERENCES `AUTOPARTS`.`PRODUCTS` (`Products_id`)
80    ON DELETE NO ACTION
81    ON UPDATE NO ACTION)
82ENGINE = InnoDB;
83
84
85SET SQL_MODE=@OLD_SQL_MODE;
86SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
87SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
88