CREATE OR REPLACE DEFINER=`root`@`localhost`
	SQL SECURITY DEFINER
	VIEW `vn2008`.`tblContadores`
AS SELECT `c`.`id` AS `id`,
	`c`.`ochoa` AS `ochoa`,
	`c`.`invoiceOutFk` AS `nfactura`,
	`c`.`inventoried` AS `FechaInventario`,
	`c`.`itemLog` AS `HistoricoArticulo`,
	`c`.`weekGoal` AS `week_goal`,
	`c`.`photosPath` AS `Rutafotos`,
	`c`.`cashBoxNumber` AS `numCaja`,
	`c`.`redCode` AS `CodigoRojo`,
	`c`.`TabletTime` AS `Tablet_Hora`,
	`c`.`t0` AS `t0`,
	`c`.`t1` AS `t1`,
	`c`.`t2` AS `t2`,
	`c`.`t3` AS `t3`,
	`c`.`cc` AS `cc`,
	`c`.`palet` AS `palet`,
	`c`.`campaign` AS `campaign`,
	`c`.`campaignLife` AS `campaign_life`,
	`c`.`truckDays` AS `truck_days`,
	`c`.`transportCharges` AS `tasa_transporte`,
	`c`.`escanerPath` AS `escaner_path`,
	`c`.`printedTurn` AS `turnoimpreso`,
	`c`.`truckLength` AS `truck_length`,
	`c`.`fuelConsumption` AS `fuel_consumption`,
	`c`.`petrol` AS `petrol`,
	`c`.`maintenance` AS `maintenance`,
	`c`.`hourPrice` AS `hour_price`,
	`c`.`meterPrice` AS `meter_price`,
	`c`.`kmPrice` AS `km_price`,
	`c`.`routeOption` AS `route_option`,
	`c`.`dbproduccion` AS `dbproduccion`,
	`c`.`mdbServer` AS `mdbServer`,
	`c`.`fakeEmail` AS `fakeEmail`,
	`c`.`defaultersMaxAmount` AS `defaultersMaxAmount`,
	`c`.`ASIEN` AS `ASIEN`
FROM `vn`.`config` `c`