update_241014.sql 301 B

123456789101112
  1. -- 创建站点表
  2. CREATE TABLE rider_station
  3. (
  4. id INT PRIMARY KEY,
  5. station_name VARCHAR(100)
  6. );
  7. -- 用户表增加站点id字段
  8. ALTER TABLE tb_user ADD rider_station_id int;
  9. -- 给tb_order添加order_number索引
  10. ALTER TABLE tb_order ADD INDEX order_number_index (order_number);