alter table vehicletype
add License image;



alter table joborder
add DriverLicense image;



alter table JobOrder add Year nvarchar(500);


alter table vehicletype
add ChassisNo nvarchar(500);

alter table vehicletype
add PlateNo nvarchar(500);

alter table vehicletype
add Model nvarchar(500);

alter table vehicletype
add CustomerCode nvarchar(500);

alter table vehicletype
add CustomerName nvarchar(500);

alter table companydetails add CustomerPrefix nvarchar(10);
alter table companydetails add SupplierPrefix nvarchar(10);