backupDB.sql

DROP DATABASE IF EXISTS StoreManager;

CREATE DATABASE StoreManager;

USE StoreManager;

CREATE TABLE products (
  id INT NOT NULL auto_increment,
  name VARCHAR(30) NOT NULL,
  PRIMARY KEY(id)
);

CREATE TABLE sales (
  id INT NOT NULL auto_increment,
  date DATETIME DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(id)
);

CREATE TABLE sales_products (
  sale_id INT NOT NULL,
  product_id INT NOT NULL,
  quantity INT NOT NULL,
  FOREIGN KEY (sale_id) REFERENCES sales (id) ON DELETE CASCADE,
  FOREIGN KEY (product_id) REFERENCES products (id) ON DELETE CASCADE
);

SET
  SQL_SAFE_UPDATES = 0;

INSERT INTO
  StoreManager.products (name)
VALUES
  ("Bolsa"),
  ("Casaco"),
  ("Tenis"),
  ("Bota");

INSERT INTO
  StoreManager.sales (date)
VALUES
  (NOW()),
  (NOW()),
  (NOW());

INSERT INTO
  StoreManager.sales_products (sale_id, product_id, quantity)
VALUES
  (1, 1, 5),
  (1, 2, 10),
  (2, 3, 15),
  (3, 4, 3),
  (3, 1, 4);