CREATE DEFINER=`mysqladmin`@`97.78.168.218` PROCEDURE `getULPs`()
BEGIN
	DECLARE done INT DEFAULT FALSE;
	DECLARE lsId, pId, pOrderNumber INT;
    DECLARE lsName, pName varchar(45);

	DECLARE curLs CURSOR FOR SELECT LifestepsId, Name FROM Lifesteps;
	DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

	OPEN curLs;

	read_loop: LOOP
		FETCH curLs INTO lsId, lsName;

        IF done THEN
			LEAVE read_loop;
		END IF;

        BEGIN
			DECLARE curLsp CURSOR FOR SELECT PhaseId, Name, OrderNumber FROM LifestepsPhases WHERE LifestepsId = lsId;
			OPEN curLsp;
			FETCH curLsp INTO pId, pName, pOrderNumber;


        END;
	END LOOP;

    CLOSE curLs;
END