小餐馆MYSQL程序设计报告
小餐馆MYSQL程序设计报告
为了满足小餐馆的数据需求，我们设计了以下MYSQL程序：
CREATE DATABASE IF NOT EXISTS restaurant; USE restaurant; CREATE TABLE IF NOT EXISTS menu ( id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, price DECIMAL(10,2) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS orders ( id INT(11) NOT NULL AUTO_INCREMENT, menu_id INT(11) NOT NULL, quantity INT(11) NOT NULL, time_ordered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), CONSTRAINT orders_menu_id_fk FOREIGN KEY (menu_id) REFERENCES menu(id) ) ENGINE=InnoDB;
