SP_InitiateSeason

IF (SELECT COUNT(1)
      FROM t_Seasons
     WHERE SeasonName = VarSeasonName) = 1
THEN
    IF (SELECT COUNT(1)
          FROM t_Tiers
         WHERE TierName = VarTierName) = 1
    THEN
    INSERT INTO t_SeasonTourData (SeasonIdFk, SeasonNo, SeasonTourNo, StartDate, Playoffs, SeasonReference)
    SELECT S.SeasonIdPk,
           IFNULL(MAX(SeasonNo),0) + 1 AS SeasonNo,
           1 AS SeasonTourNo,
           VarStartDate AS StartDate,
           0 AS Playoffs,
           IFNULL(MAX(SeasonReference),0) + 1 AS SeasonReference
      FROM t_Seasons S
      LEFT JOIN t_SeasonTourData D
        ON S.SeasonIdPk = D.SeasonIdFk
     WHERE S.SeasonName = VarSeasonName;

    INSERT INTO t_Tournaments (TierIdFk, ProgressIdFk, TourStructureIdFk, SeasonTourIdFk)
    SELECT IFNULL(SeasonTierId,TierIdPk) AS TierIdFk,
           1 AS ProgressIdFk,
           1 AS TourStructureIdFk,
           MAX(SeasonTourIdPk) AS SeasonTourIdFk
      FROM t_Seasons S
      JOIN t_SeasonTourData D
        ON S.SeasonIdPk = D.SeasonIdFk
     CROSS JOIN t_Tiers T
     WHERE S.SeasonName = VarSeasonName
       AND T.TierName = VarTierName
  GROUP BY IFNULL(SeasonTierId,TierIdPk);

    ELSE SELECT 'Invalid Tier Name' AS ErrorMessage;
    END IF;
ELSE SELECT 'Invalid Season Name' AS ErrorMessage;
END IF