--
-- Host: localhost    Database: yeepa_kenya
-- ------------------------------------------------------


--
-- Temporary table structure for view `test_view`
--

/*!50001 DROP VIEW IF EXISTS `test_view`*/;
/*!50001 CREATE TABLE `test_view` (
  `1` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `test_view_2`
--

/*!50001 DROP VIEW IF EXISTS `test_view_2`*/;
/*!50001 CREATE TABLE `test_view_2` (
  `2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Final view structure for view `test_view`
--

/*!50001 DROP TABLE IF EXISTS `test_view`*/;
/*!50001 DROP VIEW IF EXISTS `test_view`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `test_view` AS select 1 AS `1` */;

--
-- Final view structure for view `test_view_2`
--

/*!50001 DROP TABLE IF EXISTS `test_view_2`*/;
/*!50001 DROP VIEW IF EXISTS `test_view_2`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `test_view_2` AS select 2 AS `2` */;

--
-- Dumping routines for database 'yeepa_kenya'
--
/*!50003 DROP FUNCTION IF EXISTS `test_function` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `test_function`() RETURNS int(11)
BEGIN

RETURN 1;
END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `test_function2` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `test_function2`() RETURNS int(11)
BEGIN

RETURN 2;
END ;;
DELIMITER ;


