CREATE DATABASE cafe_orders_db;
USE cafe_orders_db;

-- Tables
CREATE TABLE Tables (
  id INT AUTO_INCREMENT PRIMARY KEY,
  table_number INT,
  seats INT,
  location VARCHAR(50)
);

INSERT INTO Tables VALUES
(1, 1, 4, 'indoor'),
(2, 2, 2, 'outdoor'),
(3, 3, 6, 'terrace'),
(4, 4, 4, 'indoor'),
(5, 5, 3, 'outdoor');

-- Products
CREATE TABLE Products (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100),
  category VARCHAR(50),
  price DECIMAL(6,2),
  available BOOLEAN
);

INSERT INTO Products VALUES
(1, 'Espresso', 'coffee', 2.50, 1),
(2, 'Cappuccino', 'coffee', 3.00, 1),
(3, 'Freddo', 'coffee', 3.20, 1),
(4, 'Juice', 'beverage', 2.80, 1),
(5, 'Cake', 'dessert', 4.50, 1),
(6, 'Toast', 'snack', 2.50, 1),
(7, 'Tea', 'beverage', 2.00, 0),
(8, 'Cookie', 'dessert', 1.80, 1);

-- Orders
CREATE TABLE Orders (
  id INT AUTO_INCREMENT PRIMARY KEY,
  table_id INT,
  product_id INT,
  quantity INT,
  order_date DATE,
  FOREIGN KEY (table_id) REFERENCES Tables(id),
  FOREIGN KEY (product_id) REFERENCES Products(id)
);

INSERT INTO Orders VALUES
(1, 1, 1, 2, '2025-05-01'),
(2, 2, 2, 1, '2025-05-01'),
(3, 3, 3, 2, '2025-05-02'),
(4, 4, 4, 1, '2025-05-02'),
(5, 5, 5, 1, '2025-05-03'),
(6, 1, 6, 2, '2025-05-03'),
(7, 2, 7, 1, '2025-05-04'),
(8, 3, 8, 2, '2025-05-04'),
(9, 4, 2, 1, '2025-05-05'),
(10, 5, 3, 2, '2025-05-05');

<script defer data-domain="html.cafe" src="https://milkymouse.com/js/script.js"></script>