#mysql,

基础入门配置 1. #配置mysql，网络上找mysql入门，配置相应路径，创建数据库名：meal_card_management

cerate database meal_card_management; use meal_card_management

CREATE TABLE user ( id int PRIMARY KEY AUTO_INCREMENT, username varchar(50) NOT NULL, password varchar(50) NOT NULL, real_name varchar(50) NOT NULL, type tinyint NOT NULL DEFAULT 0 COMMENT '用户类型:0-学生,1-员工', student_id varchar(20) UNIQUE, employee_id varchar(20) UNIQUE, department_id int, grade int, balance decimal(8,2) NOT NULL DEFAULT 0.00, register_time datetime NOT NULL, last_login_time datetime );

CREATE TABLE department ( id int PRIMARY KEY AUTO_INCREMENT, name varchar(50) NOT NULL );

CREATE TABLE dish ( id int PRIMARY KEY AUTO_INCREMENT, name varchar(50) NOT NULL, price decimal(6,2) NOT NULL, category_id int NOT NULL,

                    `monthly_sales` int NOT NULL DEFAULT 0,

                    `inventory` int NOT NULL DEFAULT 0,
                    `status` tinyint NOT NULL DEFAULT 1 COMMENT '状态:0-下架,1-上架',
                    `create_time` datetime NOT NULL,
                    `update_time` datetime NOT NULL

);

CREATE TABLE order ( id int PRIMARY KEY AUTO_INCREMENT, user_id int NOT NULL, dish_id int NOT NULL, count smallint NOT NULL, amount decimal(6,2) NOT NULL, paid_amount decimal(6,2) NOT NULL, status tinyint NOT NULL DEFAULT 0 COMMENT '状态:0-未付款,1-已付款', pay_type tinyint NOT NULL DEFAULT 1 COMMENT '支付类型:1-余额;2-现金', complete_time datetime, create_time datetime NOT NULL );

-- 生成部门数据 INSERT INTO department VALUES (1, '开发部'), (2, '测试部');

-- 生成用户数据 INSERT INTO user VALUES (1, 'zhangsan', '123456', '张三', 0, '1001', NULL, 1, 3, 120, '2023-02-01 10:00:00', NULL), (2, 'lisi', '123456', '李四', 1, NULL, '1002', 2, NULL, 80, '2023-02-02 12:00:00', '2023-02-03 15:00:00');

-- 生成菜品数据 INSERT INTO dish VALUES (1, '香锅鱼', 12.5, 1, 500, 100, 1, '2023-01-01 12:00:00', NULL), (2, '烤鸡腿', 15, 2, 300, 80, 1, '2023-01-05 16:00:00', NULL);

-- 生成订单数据 INSERT INTO order VALUES (1, 1, 1, 2, 25, 25, 1, 1, '2023-02-04 18:00:00', '2023-02-04 17:30:00'), (2, 2, 2, 1, 15, 15, 1, 2, NULL, '2023-02-04 18:00:00');

ALTER TABLE user ADD signatures varchar(256);

ALTER TABLE user CHANGE employee_id email varchar(20);

配置meaven，然后加载依赖

application.yaml 中，只需要将 spring.datasource.username: root（自己数据库用户名） spring.datasource.password: 2605274496（自己数据库密码）