SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


CREATE ALGORITHM=UNDEFINED DEFINER=`becca37`@`localhost` SQL SECURITY DEFINER VIEW `Definitions`  AS SELECT `Definition`.`Category` AS `Category`, `Definition`.`Area` AS `Area`, `Definition`.`Type` AS `Type`, `Definition`.`SubType` AS `SubType`, `Definition`.`Name` AS `Name`, `Definition`.`Description` AS `Description`, if(((`Definition`.`LearnMore` is null) or (`Definition`.`LearnMore` = '')),'',concat('<a href="',`Definition`.`LearnMore`,'">Learn More</a>')) AS `LearnMore` FROM `Definition` ORDER BY `Definition`.`Category` ASC, `Definition`.`Area` ASC, `Definition`.`Type` ASC, `Definition`.`SubType` ASC, `Definition`.`Name` ASC ;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;