 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2016-03-22 13:44:02
+-- Dump completed on 2016-03-24 10:52:37

/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = '' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `Tasks_Select`()
    NO SQL
SELECT 
	`TaskID`
    ,`Content`
    ,`IsActive` 
    ,`IsCompleted`
FROM 
	`Tasks`
WHERE 
	`IsActive` = 1 ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;

CREATE TABLE `Labels` (
  `LabelID` int(11) NOT NULL AUTO_INCREMENT,
  `Content` varchar(64) NOT NULL,
  `IsDeleted` bit(1) NOT NULL DEFAULT b'0',
  `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ModifiedDate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`LabelID`)
