-- 扫码充电 V2.0：预约时段与车辆 VIN 校验
|
ALTER TABLE charging_pile_service.t_site
|
ADD COLUMN reservation_start_time varchar(5) NULL COMMENT '允许预约开始时间(HH:mm)' AFTER supportOrder,
|
ADD COLUMN reservation_end_time varchar(5) NULL COMMENT '允许预约结束时间(HH:mm)' AFTER reservation_start_time;
|
|
ALTER TABLE charging_pile_account.t_app_user_car
|
ADD COLUMN vin varchar(64) NULL COMMENT '车辆VIN码' AFTER license_plate;
|
|
ALTER TABLE charging_pile_order.t_charging_order
|
ADD COLUMN reservation_time datetime NULL COMMENT '预约充电时间' AFTER plate_num,
|
ADD COLUMN expected_vin varchar(64) NULL COMMENT '支付车辆VIN快照' AFTER reservation_time,
|
ADD COLUMN actual_vin varchar(64) NULL COMMENT '启动时设备识别VIN' AFTER expected_vin;
|
