为虚构的餐厅创建SQL数据库脚本

-- 创建数据库
CREATE DATABASE restaurant;

-- 使用数据库
USE restaurant;

-- 创建菜单表
CREATE TABLE menu (
  id INT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  price DECIMAL(8, 2) NOT NULL,
  description VARCHAR(255),
  category VARCHAR(50) NOT NULL
);

-- 创建订单表
CREATE TABLE orders (
  id INT PRIMARY KEY,
  customer_name VARCHAR(100) NOT NULL,
  order_date DATE NOT NULL,
  total_amount DECIMAL(8, 2) NOT NULL
);

-- 创建订单详情表
CREATE TABLE order_details (
  id INT PRIMARY KEY,
  order_id INT NOT NULL,
  menu_id INT NOT NULL,
  quantity INT NOT NULL,
  subtotal DECIMAL(8, 2) NOT NULL,
  FOREIGN KEY (order_id) REFERENCES orders(id),
  FOREIGN KEY (menu_id) REFERENCES menu(id)
);

-- 创建顾客表
CREATE TABLE customers (
  id INT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(100) NOT NULL,
  phone VARCHAR(20) NOT NULL
);