V3__init_20241220.sql 1.6 KB

1234567891011121314151617
  1. ALTER TABLE bus_device_history ADD COLUMN block1 int(255) DEFAULT NULL COMMENT '运行时电机压力值';
  2. ALTER TABLE bus_device_history ADD COLUMN block2 int(255) DEFAULT NULL COMMENT '非运行时电机压力值';
  3. ALTER TABLE bus_device_history ADD COLUMN block_status varchar(255) DEFAULT NULL COMMENT '堵塞状态';
  4. ALTER TABLE bus_device_history ADD COLUMN evening_time1 int(255) DEFAULT NULL COMMENT '夜间减档开始时间';
  5. ALTER TABLE bus_device_history ADD COLUMN evening_time2 int(255) DEFAULT NULL COMMENT '夜间减档结束时间';
  6. ALTER TABLE bus_device_history ADD COLUMN night_ratio int(255) DEFAULT NULL COMMENT '夜间减档比例';
  7. ALTER TABLE bus_device_history ADD COLUMN reset_params int(255) DEFAULT NULL COMMENT '是否重设参数';
  8. ALTER TABLE bus_infusion_history ADD COLUMN block1 int(255) DEFAULT NULL COMMENT '运行时电机压力值';
  9. ALTER TABLE bus_infusion_history ADD COLUMN block2 int(255) DEFAULT NULL COMMENT '非运行时电机压力值';
  10. ALTER TABLE bus_infusion_history ADD COLUMN block_status varchar(255) DEFAULT NULL COMMENT '堵塞状态';
  11. ALTER TABLE bus_infusion_history ADD COLUMN evening_time1 int(255) DEFAULT NULL COMMENT '夜间减档开始时间';
  12. ALTER TABLE bus_infusion_history ADD COLUMN evening_time2 int(255) DEFAULT NULL COMMENT '夜间减档结束时间';
  13. ALTER TABLE bus_infusion_history ADD COLUMN night_ratio int(255) DEFAULT NULL COMMENT '夜间减档比例';
  14. ALTER TABLE bus_infusion_history ADD COLUMN reset_params int(255) DEFAULT NULL COMMENT '是否重设参数';
  15. ALTER TABLE sys_user ADD COLUMN psw_need_reset tinyint(1) DEFAULT NULL COMMENT '是否需要修改密码';