| 12345678910111213141516171819202122232425262728 |
- ALTER TABLE kwf_truck ADD gps_flag tinyint NOT NULL default 0 comment '是否安装gps 0-未安装1-已安装';
- ALTER TABLE kwf_truck ADD company_id varchar(255) NOT NULL default '' comment '企业id(旧系统)';
- ALTER TABLE kwf_truck ADD truck_mark tinyint NOT NULL default 0 comment '0-自有车辆 1-外部车辆';
- ALTER TABLE kwf_truck ADD signup_channel tinyint NOT NULL default 0 comment '采集来源 0-app 1-pc端';
- ALTER TABLE kwf_truck ADD all_mileage varchar(255) NOT NULL default '' comment '里程总数';
- ALTER TABLE kwf_truck ADD car_axis varchar(255) NOT NULL default '' comment '轴数';
- ALTER TABLE kwf_truck ADD drive_mode varchar(255) NOT NULL default '' comment '是否是无人驾驶(0-有人驾驶,1-无人驾驶)';
- ALTER TABLE kwt_waybill_order ADD task_start_time datetime NOT NULL default '1000-01-01 00:00:00' comment '任务开始时间';
- ALTER TABLE kwt_waybill_order ADD task_end_time datetime NOT NULL default '1000-01-01 00:00:00' comment '任务结束时间';
- create table kwf_truck_route
- (
- id bigint not null comment '主键'
- primary key,
- fleet_id bigint null comment '车队id',
- driver_id bigint null comment '司机id',
- ent_id bigint not null comment '企业id',
- start_point varchar(400) null comment '起始点',
- unloading_Point int default 0 not null comment '卸货地点',
- shortest_time varchar(10) not null comment '最短时间',
- create_time datetime not null default current_timestamp comment '创建时间',
- update_time datetime not null default current_timestamp on update current_timestamp comment '更新时间',
- del_flag tinyint not null default 0 comment '是否删除（0未删除，1删除）'
- )
- comment '车辆惯用线路信息表';
|
