update country set time_zone_r7='Africa/Casablanca'  where code='ao';
update country set time_zone_r7='Africa/Harare'  where code='bw';
update country set time_zone_r7='Africa/Casablanca'  where code='cd';
update country set time_zone_r7='Africa/Harare'  where code='sz';
update country set time_zone_r7='Atlantic/Azores'  where code='gh';
update country set time_zone_r7='Atlantic/Azores'  where code='intl';
update country set time_zone_r7='Atlantic/Azores'  where code='ci';
update country set time_zone_r7='Europe/London'  where code='je';
update country set time_zone_r7='Africa/Nairobi'  where code='ke';
update country set time_zone_r7='Africa/Harare'  where code='ls';
update country set time_zone_r7='Africa/Harare'  where code='mw';
update country set time_zone_r7='Asia/Muscat'  where code='mu';
update country set time_zone_r7='Africa/Harare'  where code='mz';
update country set time_zone_r7='Africa/Harare'  where code='na';
update country set time_zone_r7='Africa/Casablanca'  where code='ng';
update country set time_zone_r7='Africa/Harare'  where code='za';
update country set time_zone_r7='Africa/Nairobi'  where code='tz';
update country set time_zone_r7='Africa/Nairobi'  where code='ug';
update country set time_zone_r7='Africa/Nairobi'  where code='zm';
update country set time_zone_r7='Africa/Harare'  where code='zw';
update country set time_zone_r7='America/Los_Angeles' where code='us';



UPDATE country SET time_zone='Africa/Kinshasa' WHERE code='ao';
UPDATE country SET time_zone='Africa/Gaborone' WHERE code='bw';
UPDATE country SET time_zone='Africa/Kinshasa' WHERE code='cd';
UPDATE country SET time_zone='Africa/Mbabane' WHERE code='sz';
UPDATE country SET time_zone='Africa/Accra' WHERE code='gh';
UPDATE country SET time_zone='Etc/UTC' WHERE code='intl'; -- Assuming 'intl' stands for International, which typically uses UTC
UPDATE country SET time_zone='Africa/Abidjan' WHERE code='ci';
UPDATE country SET time_zone='Europe/Jersey' WHERE code='je';
UPDATE country SET time_zone='Africa/Nairobi' WHERE code='ke';
UPDATE country SET time_zone='Africa/Maseru' WHERE code='ls';
UPDATE country SET time_zone='Africa/Blantyre' WHERE code='mw';
UPDATE country SET time_zone='Indian/Mauritius' WHERE code='mu';
UPDATE country SET time_zone='Africa/Maputo' WHERE code='mz';
UPDATE country SET time_zone='Africa/Windhoek' WHERE code='na';
UPDATE country SET time_zone='Africa/Lagos' WHERE code='ng';
UPDATE country SET time_zone='Africa/Johannesburg' WHERE code='za';
UPDATE country SET time_zone='Africa/Dar_es_Salaam' WHERE code='tz';
UPDATE country SET time_zone='Africa/Kampala' WHERE code='ug';
UPDATE country SET time_zone='Africa/Lusaka' WHERE code='zm';
UPDATE country SET time_zone='Africa/Harare' WHERE code='zw';
UPDATE country SET time_zone='America/Los_Angeles' WHERE code='us';