CREATE OR REPLACE DEFINER=`root`@`localhost`
	SQL SECURITY DEFINER
	VIEW `vn2008`.`Tipos`
AS SELECT `it`.`id` AS `tipo_id`,
	`it`.`code` AS `Id_Tipo`,
	`it`.`name` AS `Tipo`,
	`it`.`order` AS `Orden`,
	`it`.`categoryFk` AS `reino_id`,
	`it`.`workerFk` AS `Id_Trabajador`,
	`it`.`life` AS `life`,
	`it`.`isPackaging` AS `isPackaging`,
	`it`.`isInventory` AS `inventory`,
	`it`.`created` AS `odbc_date`,
	`it`.`making` AS `confeccion`,
	`it`.`temperatureFk` AS `Temperatura`,
	`it`.`promo` AS `promo`
FROM `vn`.`itemType` `it`