餐饮管理数据库代码

-- 创建数据库
CREATE DATABASE restaurant;

-- 使用数据库
USE restaurant;

-- 创建菜品表
CREATE TABLE dishes (
    dish_id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    category VARCHAR(50),
    stock INT
);

-- 创建订单表
CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT,
    order_date DATETIME DEFAULT CURRENT_TIMESTAMP,
    total_amount DECIMAL(10, 2) NOT NULL,
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
);

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

-- 插入示例数据
INSERT INTO dishes (name, price, category, stock) VALUES
('Chicken Curry', 12.99, 'Main Course', 50),
('Vegetable Salad', 7.99, 'Appetizer', 100);

INSERT INTO customers (name, email, phone) VALUES
('John Doe', 'john.doe@example.com', '1234567890');

INSERT INTO orders (customer_id, total_amount) VALUES
(1, 20.98);