BUG update sessions, upcomingavailability not updated correctly? E.g. foir water -> erg, it stays as water

[AdelaideBaron]

I think this is actually due to duplicated sessions

use rowers_hub; 

-- MENS THURSDAY 6AM INTER WATER SESSION S 

SELECT up.date, 
s.start_time, s.session_type
FROM upcoming_sessions up 
INNER JOIN sessions s 
ON 
up.session_id = s.session_id
WHERE squad = 'MENS';

-- duplicate sessions input into the db... 

SELECT * FROM sessions WHERE squad = 'MENS';

-- put a check in on updating/adding a session
-- manually remove duplicates 
-- and then have a unique check on the db 

[AdelaideBaron]

• /update_session already checks for the session by id, so also adding in a check to verify other fields

[AdelaideBaron]

• will also cause issues due to combining of levels... maybe have a follow up for this part