--  Source: https://www.gov.uk/bank-holidays
--
--  England and Wales
--
update calendar
set public_holiday_england_and_wales = 'N'
where year = 2020;

update calendar
set public_holiday_england_and_wales = 'Y'
where 
    calendar_date in
    (
        '01-Jan-2020',  -- New Year's Day
        '10-Apr-2020',  -- Good Friday
        '13-Apr-2020',  -- Easter Monday
        '04-May-2020',  -- Early May Bank Holiday
        '25-May-2020',  -- Spring Bank Holiday
        '31-Aug-2020',  -- Summer Bank Holiday
        '25-Dec-2020',  -- Christmas Day
        '28-Dec-2020'   -- Boxing Day (substitute day)
    );
--
--
--  Scotland
--
update calendar
set public_holiday_scotland = 'N'
where year = 2020;

update calendar
set public_holiday_scotland = 'Y'
where 
    calendar_date in
    (
        '01-Jan-2020',  -- New Year's Day
        '02-Jan-2020',  -- 2nd January
        '10-Apr-2020',  -- Good Friday
        '04-May-2020',  -- Early May Bank Holiday
        '25-May-2020',  -- Spring Bank Holiday
        '03-Aug-2020',  -- Summer Bank Holiday
        '30-Nov-2020',  -- St Andrew's Day (substitute day)
        '25-Dec-2020',  -- Christmas Day
        '28-Dec-2020'   -- Boxing Day (substitute day)
    );
--
--
--  Northern Ireland 
--
update calendar
set public_holiday_northern_ireland = 'N'
where year = 2020;

update calendar
set public_holiday_northern_ireland = 'Y'
where 
    calendar_date in
    (
        '01-Jan-2020',  -- New Year's Day 
        '17-Mar-2020',  -- St Patrick’s Day
        '10-Apr-2020',  -- Good Friday
        '13-Apr-2020',  -- Easter Monday
        '04-May-2020',  -- Early May Bank Holiday
        '25-May-2020',  -- Spring Bank Holiday
        '13-Jul-2020',  -- Battle of the Boyne (Orangemen’s Day) (substitute day)
        '31-Aug-2020',  -- Summer Bank Holiday
        '25-Dec-2020',  -- Christmas Day
        '26-Dec-2020'   -- Boxing Day
    );
