--
-- Host: localhost    Database: test_views
-- ------------------------------------------------------


--
-- Final view structure for view `viewlog`
--

/*!50001 DROP TABLE `viewlog`*/;
/*!50001 DROP VIEW IF EXISTS `viewlog`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`saulius`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `viewlog` AS select `validation`.`id` AS `id`,`messages`.`message` AS `message`,`programs`.`name` AS `name`,`programs`.`version` AS `version`,`programs`.`url` AS `url`,`programs`.`repo` AS `repo` from ((`validation` join `messages`) join `programs`) where ((`validation`.`program_id` = `programs`.`id`) and (`validation`.`message_id` = `messages`.`id`)) */;



