DO $$ 
	DECLARE _path character varying(256) = 'patch-2024-08-27-TimeZones_Update_Offsets';

	BEGIN
		IF EXISTS (SELECT "Id" FROM public."Versions" WHERE "Path"=_path) THEN
			RETURN;
		END IF;

		IF EXISTS (SELECT "Id" FROM public."Versions" WHERE "Build">=14244) THEN
			RETURN;
		END IF;

		BEGIN
			UPDATE public."TimeZones" SET "UtcOffset"='-11:00', "OffsetMinutes"=-660 WHERE "Id" = 143;
			UPDATE public."TimeZones" SET "UtcOffset"='-11:00', "OffsetMinutes"=-660 WHERE "Id" = 142;
			UPDATE public."TimeZones" SET "UtcOffset"='-10:00', "OffsetMinutes"=-600 WHERE "Id" = 144;
			UPDATE public."TimeZones" SET "UtcOffset"='-10:00', "OffsetMinutes"=-600 WHERE "Id" = 146;
			UPDATE public."TimeZones" SET "UtcOffset"='-09:00', "OffsetMinutes"=-540 WHERE "Id" = 452;
			UPDATE public."TimeZones" SET "UtcOffset"='-10:00', "OffsetMinutes"=-600 WHERE "Id" = 145;
			UPDATE public."TimeZones" SET "UtcOffset"='-10:30', "OffsetMinutes"=-570 WHERE "Id" = 470;
			UPDATE public."TimeZones" SET "UtcOffset"='-09:00', "OffsetMinutes"=-540 WHERE "Id" = 456;
			UPDATE public."TimeZones" SET "UtcOffset"='-08:00', "OffsetMinutes"=-480 WHERE "Id" = 474;
			UPDATE public."TimeZones" SET "UtcOffset"='-08:00', "OffsetMinutes"=-480 WHERE "Id" = 149;
			UPDATE public."TimeZones" SET "UtcOffset"='-08:00', "OffsetMinutes"=-480 WHERE "Id" = 147;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 154;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 153;
			UPDATE public."TimeZones" SET "UtcOffset"='-08:00', "OffsetMinutes"=-480 WHERE "Id" = 449;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 152;
			UPDATE public."TimeZones" SET "UtcOffset"='-08:00', "OffsetMinutes"=-480 WHERE "Id" = 151;
			UPDATE public."TimeZones" SET "UtcOffset"='-08:00', "OffsetMinutes"=-480 WHERE "Id" = 150;
			UPDATE public."TimeZones" SET "UtcOffset"='-08:00', "OffsetMinutes"=-480 WHERE "Id" = 148;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 155;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 156;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 157;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 473;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 159;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 455;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 158;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 162;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 450;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 168;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 169;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 170;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 171;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 172;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 173;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 174;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 175;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 193;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 194;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 163;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 164;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 165;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 166;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 167;
			UPDATE public."TimeZones" SET "UtcOffset"='-07:00', "OffsetMinutes"=-420 WHERE "Id" = 161;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 160;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 185;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 187;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 188;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 189;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 190;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 191;
			UPDATE public."TimeZones" SET "UtcOffset"='-06:00', "OffsetMinutes"=-360 WHERE "Id" = 192;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 186;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 216;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 195;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 196;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 197;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 198;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 199;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 200;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 201;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 215;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 176;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 454;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 463;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 177;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 178;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 179;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 180;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 181;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 182;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 183;
			UPDATE public."TimeZones" SET "UtcOffset"='-05:00', "OffsetMinutes"=-300 WHERE "Id" = 184;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 217;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 214;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 202;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 203;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 204;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 205;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 206;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 207;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 208;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 209;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 210;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 211;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 212;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 213;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 218;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 225;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 226;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 227;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 228;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 229;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 230;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 231;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 232;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 233;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 234;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 235;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 236;
			UPDATE public."TimeZones" SET "UtcOffset"='-04:00', "OffsetMinutes"=-240 WHERE "Id" = 237;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 238;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 249;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 251;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 222;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 223;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 224;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 220;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 221;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 247;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 248;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 250;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 240;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 241;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 242;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 252;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 253;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 254;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 255;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 256;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 257;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 258;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 259;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 260;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 261;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 262;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 263;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 264;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 244;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 245;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 243;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 246;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 464;
			UPDATE public."TimeZones" SET "UtcOffset"='-02:00', "OffsetMinutes"=-120 WHERE "Id" = 462;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:00', "OffsetMinutes"=-180 WHERE "Id" = 219;
			UPDATE public."TimeZones" SET "UtcOffset"='-03:30', "OffsetMinutes"=-150 WHERE "Id" = 239;
			UPDATE public."TimeZones" SET "UtcOffset"='-02:00', "OffsetMinutes"=-120 WHERE "Id" = 265;
			UPDATE public."TimeZones" SET "UtcOffset"='-02:00', "OffsetMinutes"=-120 WHERE "Id" = 266;
			UPDATE public."TimeZones" SET "UtcOffset"='-01:00', "OffsetMinutes"=-60 WHERE "Id" = 475;
			UPDATE public."TimeZones" SET "UtcOffset"='-01:00', "OffsetMinutes"=-60 WHERE "Id" = 269;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 479;
			UPDATE public."TimeZones" SET "UtcOffset"='-01:00', "OffsetMinutes"=-60 WHERE "Id" = 267;
			UPDATE public."TimeZones" SET "UtcOffset"='+00:00', "OffsetMinutes"=0 WHERE "Id" = 268;
			UPDATE public."TimeZones" SET "UtcOffset"='+00:00', "OffsetMinutes"=0 WHERE "Id" = 272;
			UPDATE public."TimeZones" SET "UtcOffset"='+00:00', "OffsetMinutes"=0 WHERE "Id" = 278;
			UPDATE public."TimeZones" SET "UtcOffset"='+00:00', "OffsetMinutes"=0 WHERE "Id" = 279;
			UPDATE public."TimeZones" SET "UtcOffset"='+00:00', "OffsetMinutes"=0 WHERE "Id" = 280;
			UPDATE public."TimeZones" SET "UtcOffset"='+00:00', "OffsetMinutes"=0 WHERE "Id" = 281;
			UPDATE public."TimeZones" SET "UtcOffset"='+00:00', "OffsetMinutes"=0 WHERE "Id" = 282;
			UPDATE public."TimeZones" SET "UtcOffset"='+00:00', "OffsetMinutes"=0 WHERE "Id" = 459;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 478;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 309;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 305;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 270;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 274;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 306;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 273;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 307;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 277;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 271;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 276;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 275;
			UPDATE public."TimeZones" SET "UtcOffset"='+01:00', "OffsetMinutes"=60 WHERE "Id" = 308;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 304;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 289;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 288;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 287;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 286;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 285;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 315;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 284;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 283;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 446;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 322;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 323;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 326;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 465;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 469;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 477;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 290;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 292;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 291;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 293;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 294;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 295;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 296;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 297;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 298;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 299;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 300;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 301;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 302;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 303;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 311;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 310;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 312;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 313;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 314;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 316;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 317;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 318;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 319;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 320;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 321;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 324;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 325;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 327;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 328;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 329;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 330;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 331;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 332;
			UPDATE public."TimeZones" SET "UtcOffset"='+02:00', "OffsetMinutes"=120 WHERE "Id" = 333;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 334;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 335;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 336;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 337;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 338;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:00', "OffsetMinutes"=180 WHERE "Id" = 339;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 344;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 342;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 341;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 460;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 340;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 347;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 346;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 350;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 349;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 348;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:30', "OffsetMinutes"=270 WHERE "Id" = 351;
			UPDATE public."TimeZones" SET "UtcOffset"='+03:30', "OffsetMinutes"=210 WHERE "Id" = 343;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 358;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 361;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 362;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 363;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 360;
			UPDATE public."TimeZones" SET "UtcOffset"='+04:00', "OffsetMinutes"=240 WHERE "Id" = 345;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 352;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 353;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 354;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 355;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 453;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 356;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 357;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 359;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:30', "OffsetMinutes"=330 WHERE "Id" = 365;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:30', "OffsetMinutes"=330 WHERE "Id" = 364;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:45', "OffsetMinutes"=345 WHERE "Id" = 366;
			UPDATE public."TimeZones" SET "UtcOffset"='+06:00', "OffsetMinutes"=360 WHERE "Id" = 372;
			UPDATE public."TimeZones" SET "UtcOffset"='+06:00', "OffsetMinutes"=360 WHERE "Id" = 371;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 457;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 370;
			UPDATE public."TimeZones" SET "UtcOffset"='+06:00', "OffsetMinutes"=360 WHERE "Id" = 369;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 368;
			UPDATE public."TimeZones" SET "UtcOffset"='+05:00', "OffsetMinutes"=300 WHERE "Id" = 367;
			UPDATE public."TimeZones" SET "UtcOffset"='+06:00', "OffsetMinutes"=360 WHERE "Id" = 374;
			UPDATE public."TimeZones" SET "UtcOffset"='+06:00', "OffsetMinutes"=360 WHERE "Id" = 373;
			UPDATE public."TimeZones" SET "UtcOffset"='+06:30', "OffsetMinutes"=390 WHERE "Id" = 375;
			UPDATE public."TimeZones" SET "UtcOffset"='+06:30', "OffsetMinutes"=390 WHERE "Id" = 458;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 383;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 382;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 381;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 380;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 379;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 476;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 378;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 377;
			UPDATE public."TimeZones" SET "UtcOffset"='+06:00', "OffsetMinutes"=360 WHERE "Id" = 384;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 467;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 376;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 468;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 391;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 393;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 394;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 395;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 396;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 398;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 397;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 400;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 399;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 385;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 386;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 387;
			UPDATE public."TimeZones" SET "UtcOffset"='+07:00', "OffsetMinutes"=420 WHERE "Id" = 388;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 389;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 390;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:00', "OffsetMinutes"=480 WHERE "Id" = 392;
			UPDATE public."TimeZones" SET "UtcOffset"='+08:45', "OffsetMinutes"=525 WHERE "Id" = 471;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 402;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 401;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 419;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 406;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 405;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 404;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 403;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 418;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:00', "OffsetMinutes"=540 WHERE "Id" = 417;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:30', "OffsetMinutes"=570 WHERE "Id" = 408;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:30', "OffsetMinutes"=570 WHERE "Id" = 407;
			UPDATE public."TimeZones" SET "UtcOffset"='+09:30', "OffsetMinutes"=570 WHERE "Id" = 409;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 410;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 411;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 412;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 413;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 414;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 415;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 416;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 461;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:30', "OffsetMinutes"=630 WHERE "Id" = 451;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 421;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 422;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 424;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 445;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 425;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 423;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 444;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 448;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 427;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 420;
			UPDATE public."TimeZones" SET "UtcOffset"='+10:00', "OffsetMinutes"=600 WHERE "Id" = 426;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 433;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 440;
			UPDATE public."TimeZones" SET "UtcOffset"='+11:00', "OffsetMinutes"=660 WHERE "Id" = 439;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 437;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 436;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 435;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 434;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 432;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 431;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 430;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 429;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 428;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:45', "OffsetMinutes"=765 WHERE "Id" = 472;
			UPDATE public."TimeZones" SET "UtcOffset"='+13:00', "OffsetMinutes"=780 WHERE "Id" = 447;
			UPDATE public."TimeZones" SET "UtcOffset"='+12:00', "OffsetMinutes"=720 WHERE "Id" = 438;
			UPDATE public."TimeZones" SET "UtcOffset"='+13:00', "OffsetMinutes"=780 WHERE "Id" = 443;
			UPDATE public."TimeZones" SET "UtcOffset"='+13:00', "OffsetMinutes"=780 WHERE "Id" = 441;
			UPDATE public."TimeZones" SET "UtcOffset"='+13:00', "OffsetMinutes"=780 WHERE "Id" = 442;
			UPDATE public."TimeZones" SET "UtcOffset"='+14:00', "OffsetMinutes"=840 WHERE "Id" = 466;
			UPDATE public."TimeZones" SET "Name"='Europe/Kyiv' WHERE "Id"=446;
			INSERT INTO public."Versions" ("Path", "Build") VALUES (_path, 0);
			EXCEPTION
				WHEN OTHERS THEN RAISE NOTICE '[ERR] patch-2024-08-27-TimeZones_Update_Offsets: %', SQLERRM;
		END;
	END;
$$