-- 创建站点表 CREATE TABLE rider_station ( id INT PRIMARY KEY, station_name VARCHAR(100) ); -- 用户表增加站点id字段 ALTER TABLE tb_user ADD rider_station_id int; -- 给tb_order添加order_number索引 ALTER TABLE tb_order ADD INDEX order_number_index (order_number);