--
-- Host: 127.0.0.1    Database: balanco
-- ------------------------------------------------------


--
-- Temporary view structure for view `vw_histsomabalan`
--

/*!50001 DROP VIEW IF EXISTS `vw_histsomabalan`*/;
/*!50001 CREATE VIEW `vw_histsomabalan` AS SELECT 
 1 AS `idHstBalan`,
 1 AS `cod_Produ`,
 1 AS `descricao`,
 1 AS `cod_Lote`,
 1 AS `dat_fabric`,
 1 AS `dat_vencim`,
 1 AS `quantidade`,
 1 AS `quantidadeConf`,
 1 AS `marca`,
 1 AS `deposito`,
 1 AS `usuario`,
 1 AS `usuarioRecontagem`,
 1 AS `hstBalan`,
 1 AS `codProduLote`*/;

--
-- Final view structure for view `vw_histsomabalan`
--

/*!50001 DROP VIEW IF EXISTS `vw_histsomabalan`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vw_histsomabalan` AS select `histsomabalan`.`idHstBalan` AS `idHstBalan`,`histsomabalan`.`cod_Produ` AS `cod_Produ`,`produtos`.`descricao` AS `descricao`,`histsomabalan`.`cod_Lote` AS `cod_Lote`,`histsomabalan`.`dat_fabric` AS `dat_fabric`,`histsomabalan`.`dat_vencim` AS `dat_vencim`,`histsomabalan`.`quantidade` AS `quantidade`,`histsomabalan`.`quantidadeConf` AS `quantidadeConf`,`produtos`.`Marca` AS `marca`,`histsomabalan`.`deposito` AS `deposito`,`histsomabalan`.`usuario` AS `usuario`,`histsomabalan`.`usuarioRecontagem` AS `usuarioRecontagem`,`histsomabalan`.`hstBalan` AS `hstBalan`,concat(`histsomabalan`.`cod_Produ`,'|',`histsomabalan`.`cod_Lote`) AS `codProduLote` from (`histsomabalan` join `produtos`) where (`histsomabalan`.`cod_Produ` = `produtos`.`cod_produ`) */;


