CREATE TABLE `cy_vehicle_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` bit(1) NOT NULL COMMENT '是否有效',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` varchar(50) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL COMMENT '类型',
  `name` varchar(50) DEFAULT NULL COMMENT '领用人',
  `time` datetime DEFAULT NULL COMMENT '时间',
  `vehicleid` int(11) DEFAULT NULL,
  `operator`  varchar(50) DEFAULT NULL COMMENT '操作员',
  `remarks` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `idx_id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=527 DEFAULT CHARSET=utf8;


ALTER TABLE `sb_vehicle`
ADD COLUMN `clstate`  varchar(3) NULL COMMENT '车辆状态' AFTER `remarks`;
ADD COLUMN `senddate`  datetime NULL COMMENT '派出时间' AFTER `clstate`,
ADD COLUMN `returndate`  datetime NULL COMMENT '归还时间' AFTER `senddate`,
ADD COLUMN `scrapdate`  datetime NULL COMMENT '报废日期' AFTER `returndate`;