INSERT INTO roles (id, role_name, status, created_on, updated_on) VALUES
(1, 'ADMIN', 'active', '2022-06-06 06:05:18', '2022-06-06 06:05:18'),
(2, 'HR', 'active', '2022-06-06 06:05:26', '2022-06-06 06:05:26'),
(3, 'ACCOUNT', 'active', '2022-06-06 06:05:32', '2022-06-06 06:05:32'),
(4, 'CLIENT', 'active', '2022-06-06 06:05:40', '2022-06-22 04:57:11'),
(5, 'EMPLOYEE', 'active', '2022-06-06 06:05:58', '2022-06-22 05:01:44');

INSERT INTO module_managers (id, module_name, created_on, updated_on) VALUES
(1, 'Role', '2022-06-06 06:05:18', '2022-06-06 06:05:18'),
(2, 'Employee', '2022-06-06 06:05:26', '2022-06-06 06:05:26'),
(3, 'Company', '2022-06-06 06:05:32', '2022-06-06 06:05:32'),
(4, 'Location', '2022-06-06 06:05:40', '2022-06-22 04:57:11'),
(5, 'Shift','2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(6, 'Salary Slip', '2022-06-06 06:05:18', '2022-06-06 06:05:18'),
(7, 'Tax', '2022-06-06 06:05:26', '2022-06-06 06:05:26'),
(8, 'Appraisal Cycle', '2022-06-06 06:05:32', '2022-06-06 06:05:32'),
(9, 'Probation Cycle', '2022-06-06 06:05:40', '2022-06-22 04:57:11'),
(10, 'Leave Type','2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(11, 'Bank Detail', '2022-06-06 06:05:18', '2022-06-06 06:05:18'),
(12, 'Office Holiday', '2022-06-06 06:05:26', '2022-06-06 06:05:26'),
(13, 'Salary Range', '2022-06-06 06:05:32', '2022-06-06 06:05:32'),
(14, 'Roaster', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(15, 'Assignment', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(16, 'Attendance', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(17, 'Profile - Basic Info', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(18, 'Profile - Team Members', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(19, 'Profile - Seniors', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(20, 'Profile - Leaves Applied', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(21, 'Profile - Leaves Approved', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(22, 'Profile - Leaves In Hand', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(23, 'Profile - Tax Roaster', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(24, 'Profile - Extra Work Days', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(25, 'Profile - Show Attandance', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(26, 'Profile - Attandance Override', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(27, 'Profile - Salary Slips', '2022-06-06 06:05:58', '2022-06-22 05:01:44'),
(28, 'Profile - Bank Details', '2022-06-06 06:05:58', '2022-06-22 05:01:44');
/*(17, 'Assignment', '2022-06-06 06:05:58', '2022-06-22 05:01:44');
(18, 'Assignment', '2022-06-06 06:05:58', '2022-06-22 05:01:44');*/


INSERT INTO timezone_masters (id, label, tzCode, name, utc, isdst, zone, created_on, updated_on) VALUES
(1, 'India Standard Time', 'IST', '\"(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi\"', '+5.5', 'false', '\"Asia/Kolkata,Asia/Calcutta\"', NULL, NULL),
(2, 'Dateline Standard Time', 'DST', '(UTC-12:00) International Date Line West', '-12', 'false', 'Etc/GMT+12', NULL, NULL),
(3, 'UTC-11', 'U', '(UTC-11:00) Coordinated Universal Time-11', '-11', 'false', '\"Etc/GMT+11,Pacific/Midway,Pacific/Niue,Pacific/Pago_Pago\"', NULL, NULL),
(4, 'Hawaiian Standard Time', 'HST', '(UTC-10:00) Hawaii', '-10', 'false', '\"Etc/GMT+10,Pacific/Honolulu,Pacific/Johnston,Pacific/Rarotonga,Pacific/Tahiti\"', NULL, NULL),
(5, 'Alaskan Standard Time', 'AKDT', '(UTC-09:00) Alaska', '-8', 'true', '\"America/Anchorage,America/Juneau,America/Nome,America/Sitka,America/Yakutat\"', NULL, NULL),
(6, 'Pacific Standard Time (Mexico)', 'PDT', '(UTC-08:00) Baja California', '-7', 'true', 'America/Santa_Isabel', NULL, NULL),
(7, 'Pacific Daylight Time', 'PDT', '(UTC-07:00) Pacific Daylight Time (US & Canada)', '-7', 'true', '\"America/Los_Angeles,America/Tijuana,America/Vancouver\"', NULL, NULL),
(8, 'Pacific Standard Time', 'PST', '(UTC-08:00) Pacific Standard Time (US & Canada)', '-8', 'false', '\"America/Los_Angeles,America/Tijuana,America/Vancouver,PST8PDT\"', NULL, NULL),
(9, 'US Mountain Standard Time', 'UMST', '(UTC-07:00) Arizona', '-7', 'false', '\"America/Creston,America/Dawson,America/Dawson_Creek,America/Hermosillo,America/Phoenix,America/Whitehorse,Etc/GMT+7\"', NULL, NULL),
(10, 'Mountain Standard Time (Mexico)', 'MDT', '\"(UTC-07:00) Chihuahua, La Paz, Mazatlan\"', '-6', 'true', '\"America/Chihuahua,America/Mazatlan\"', NULL, NULL),
(11, 'Mountain Standard Time', 'MDT', '(UTC-07:00) Mountain Time (US & Canada)', '-6', 'true', '\"America/Boise,America/Cambridge_Bay,America/Denver,America/Edmonton,America/Inuvik,America/Ojinaga,America/Yellowknife,MST7MDT\"', NULL, NULL),
(12, 'Central America Standard Time', 'CAST', '(UTC-06:00) Central America', '-6', 'false', '\"America/Belize,America/Costa_Rica,America/El_Salvador,America/Guatemala,America/Managua,America/Tegucigalpa,Etc/GMT+6,Pacific/Galapagos\"', NULL, NULL),
(13, 'Central Standard Time', 'CDT', '(UTC-06:00) Central Time (US & Canada)', '-5', 'true', '\"America/Chicago,America/Indiana/Knox,America/Indiana/Tell_City,America/Matamoros,America/Menominee,America/North_Dakota/Beulah,America/North_Dakota/Center,America/North_Dakota/New_Salem,America/Rainy_River,America/Rankin_Inlet,America/Resolute,America/Winnipeg,CST6CDT\"', NULL, NULL),
(14, 'Central Standard Time (Mexico)', 'CDT', '\"(UTC-06:00) Guadalajara, Mexico City, Monterrey\"', '-5', 'true', '\"America/Bahia_Banderas,America/Cancun,America/Merida,America/Mexico_City,America/Monterrey\"', NULL, NULL),
(15, 'Canada Central Standard Time', 'CCST', '(UTC-06:00) Saskatchewan', '-6', 'false', '\"America/Regina,America/Swift_Current\"', NULL, NULL),
(16, 'SA Pacific Standard Time', 'SPST', '\"(UTC-05:00) Bogota, Lima, Quito\"', '-5', 'false', '\"America/Bogota,America/Cayman,America/Coral_Harbour,America/Eirunepe,America/Guayaquil,America/Jamaica,America/Lima,America/Panama,America/Rio_Branco,Etc/GMT+5\"', NULL, NULL),
(17, 'Eastern Standard Time', 'EST', '(UTC-05:00) Eastern Time (US & Canada)', '-5', 'false', '\"America/Detroit,America/Havana,America/Indiana/Petersburg,America/Indiana/Vincennes,America/Indiana/Winamac,America/Iqaluit,America/Kentucky/Monticello,America/Louisville,America/Montreal,America/Nassau,America/New_York,America/Nipigon,America/Pangnirtung,America/Port-au-Prince,America/Thunder_Bay,America/Toronto\"', NULL, NULL),
(18, 'Eastern Daylight Time', 'EDT', '(UTC-04:00) Eastern Daylight Time (US & Canada)', '-4', 'true', '\"America/Detroit,America/Havana,America/Indiana/Petersburg,America/Indiana/Vincennes,America/Indiana/Winamac,America/Iqaluit,America/Kentucky/Monticello,America/Louisville,America/Montreal,America/Nassau,America/New_York,America/Nipigon,America/Pangnirtung,America/Port-au-Prince,America/Thunder_Bay,America/Toronto\"', NULL, NULL),
(19, 'US Eastern Standard Time', 'UEDT', '(UTC-05:00) Indiana (East)', '-5', 'false', '\"America/Indiana/Marengo,America/Indiana/Vevay,America/Indianapolis\"', NULL, NULL),
(20, 'Venezuela Standard Time', 'VST', '(UTC-04:30) Caracas', '-4.5', 'false', 'America/Caracas', NULL, NULL),
(21, 'Paraguay Standard Time', 'PYT', '(UTC-04:00) Asuncion', '-4', 'false', 'America/Asuncion', NULL, NULL),
(22, 'Atlantic Standard Time', 'ADT', '(UTC-04:00) Atlantic Time (Canada)', '-3', 'true', '\"America/Glace_Bay,America/Goose_Bay,America/Halifax,America/Moncton,America/Thule,Atlantic/Bermuda\"', NULL, NULL),
(23, 'Central Brazilian Standard Time', 'CBST', '(UTC-04:00) Cuiaba', '-4', 'false', '\"America/Campo_Grande,America/Cuiaba\"', NULL, NULL),
(24, 'SA Western Standard Time', 'SWST', '\"(UTC-04:00) Georgetown, La Paz, Manaus, San Juan\"', '-4', 'false', '\"America/Anguilla,America/Antigua,America/Aruba,America/Barbados,America/Blanc-Sablon,America/Boa_Vista,America/Curacao,America/Dominica,America/Grand_Turk,America/Grenada,America/Guadeloupe,America/Guyana,America/Kralendijk,America/La_Paz,America/Lower_Princes,America/Manaus,America/Marigot,America/Martinique,America/Montserrat,America/Port_of_Spain,America/Porto_Velho,America/Puerto_Rico,America/Santo_Domingo,America/St_Barthelemy,America/St_Kitts,America/St_Lucia,America/St_Thomas,America/St_Vincent,America/Tortola,Etc/GMT+4\"', NULL, NULL),
(25, 'Pacific SA Standard Time', 'PSST', '(UTC-04:00) Santiago', '-4', 'false', '\"America/Santiago,Antarctica/Palmer\"', NULL, NULL),
(26, 'Newfoundland Standard Time', 'NDT', '(UTC-03:30) Newfoundland', '-2.5', 'true', 'America/St_Johns', NULL, NULL),
(27, 'E. South America Standard Time', 'ESAST', '(UTC-03:00) Brasilia', '-3', 'false', 'America/Sao_Paulo', NULL, NULL),
(28, 'Argentina Standard Time', 'AST', '(UTC-03:00) Buenos Aires', '-3', 'false', '\"America/Argentina/La_Rioja,America/Argentina/Rio_Gallegos,America/Argentina/Salta,America/Argentina/San_Juan,America/Argentina/San_Luis,America/Argentina/Tucuman,America/Argentina/Ushuaia,America/Buenos_Aires,America/Catamarca,America/Cordoba,America/Jujuy,America/Mendoza\"', NULL, NULL),
(29, 'SA Eastern Standard Time', 'SEST', '\"(UTC-03:00) Cayenne, Fortaleza\"', '-3', 'false', '\"America/Araguaina,America/Belem,America/Cayenne,America/Fortaleza,America/Maceio,America/Paramaribo,America/Recife,America/Santarem,Antarctica/Rothera,Atlantic/Stanley,Etc/GMT+3\"', NULL, NULL),
(30, 'Greenland Standard Time', 'GDT', '(UTC-03:00) Greenland', '-3', 'true', 'America/Godthab', NULL, NULL),
(31, 'Montevideo Standard Time', 'MST', '(UTC-03:00) Montevideo', '-3', 'false', 'America/Montevideo', NULL, NULL),
(32, 'Bahia Standard Time', 'BST', '(UTC-03:00) Salvador', '-3', 'false', 'America/Bahia', NULL, NULL),
(33, 'UTC-02', 'U', '(UTC-02:00) Coordinated Universal Time-02', '-2', 'false', '\"America/Noronha,Atlantic/South_Georgia,Etc/GMT+2\"', NULL, NULL),
(34, 'Mid-Atlantic Standard Time', 'MDT', '(UTC-02:00) Mid-Atlantic - Old', '-1', 'true', '', NULL, NULL),
(35, 'Azores Standard Time', 'ADT', '(UTC-01:00) Azores', '0', 'true', '\"America/Scoresbysund,Atlantic/Azores\"', NULL, NULL),
(36, 'Cape Verde Standard Time', 'CVST', '(UTC-01:00) Cape Verde Is.', '-1', 'false', '\"Atlantic/Cape_Verde,Etc/GMT+1\"', NULL, NULL),
(37, 'Morocco Standard Time', 'MDT', '(UTC) Casablanca', '+1', 'true', '\"Africa/Casablanca,Africa/El_Aaiun\"', NULL, NULL),
(38, 'UTC', 'UTC', '(UTC) Coordinated Universal Time', '0', 'false', '\"America/Danmarkshavn,Etc/GMT\"', NULL, NULL),
(39, 'GMT Standard Time', 'GMT', '\"(UTC) Edinburgh, London\"', '0', 'false', '\"Europe/Isle_of_Man,Europe/Guernsey,Europe/Jersey,Europe/London\"', NULL, NULL),
(40, 'British Summer Time', 'BST', '\"(UTC+01:00) Edinburgh, London\"', '+1', 'true', '\"Europe/Isle_of_Man,Europe/Guernsey,Europe/Jersey,Europe/London\"', NULL, NULL),
(41, 'GMT Standard Time', 'GDT', '\"(UTC) Dublin, Lisbon\"', '+1', 'true', '\"Atlantic/Canary,Atlantic/Faeroe,Atlantic/Madeira,Europe/Dublin,Europe/Lisbon\"', NULL, NULL),
(42, 'Greenwich Standard Time', 'GST', '\"(UTC) Monrovia, Reykjavik\"', '0', 'false', '\"Africa/Abidjan,Africa/Accra,Africa/Bamako,Africa/Banjul,Africa/Bissau,Africa/Conakry,Africa/Dakar,Africa/Freetown,Africa/Lome,Africa/Monrovia,Africa/Nouakchott,Africa/Ouagadougou,Africa/Sao_Tome,Atlantic/Reykjavik,Atlantic/St_Helena\"', NULL, NULL),
(43, 'W. Europe Standard Time', 'WEDT', '\"(UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna\"', '+2', 'true', '\"Arctic/Longyearbyen,Europe/Amsterdam,Europe/Andorra,Europe/Berlin,Europe/Busingen,Europe/Gibraltar,Europe/Luxembourg,Europe/Malta,Europe/Monaco,Europe/Oslo,Europe/Rome,Europe/San_Marino,Europe/Stockholm,Europe/Vaduz,Europe/Vatican,Europe/Vienna,Europe/Zurich\"', NULL, NULL),
(44, 'Central Europe Standard Time', 'CEDT', '\"(UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague\"', '+2', 'true', '\"Europe/Belgrade,Europe/Bratislava,Europe/Budapest,Europe/Ljubljana,Europe/Podgorica,Europe/Prague,Europe/Tirane\"', NULL, NULL),
(45, 'Romance Standard Time', 'RDT', '\"(UTC+01:00) Brussels, Copenhagen, Madrid, Paris\"', '+2', 'true', '\"Africa/Ceuta,Europe/Brussels,Europe/Copenhagen,Europe/Madrid,Europe/Paris\"', NULL, NULL),
(46, 'Central European Standard Time', 'CEDT', '\"(UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb\"', '+2', 'true', '\"Europe/Sarajevo,Europe/Skopje,Europe/Warsaw,Europe/Zagreb\"', NULL, NULL),
(47, 'W. Central Africa Standard Time', 'WCAST', '(UTC+01:00) West Central Africa', '+1', 'false', '\"Africa/Algiers,Africa/Bangui,Africa/Brazzaville,Africa/Douala,Africa/Kinshasa,Africa/Lagos,Africa/Libreville,Africa/Luanda,Africa/Malabo,Africa/Ndjamena,Africa/Niamey,Africa/Porto-Novo,Africa/Tunis,Etc/GMT-1\"', NULL, NULL),
(48, 'Namibia Standard Time', 'NST', '(UTC+01:00) Windhoek', '+1', 'false', 'Africa/Windhoek', NULL, NULL),
(49, 'GTB Standard Time', 'GDT', '\"(UTC+02:00) Athens, Bucharest\"', '+3', 'true', '\"Asia/Nicosia,Europe/Athens,Europe/Bucharest,Europe/Chisinau\"', NULL, NULL),
(50, 'Middle East Standard Time', 'MEDT', '(UTC+02:00) Beirut', '+3', 'true', 'Asia/Beirut', NULL, NULL),
(51, 'Egypt Standard Time', 'EST', '(UTC+02:00) Cairo', '+2', 'false', 'Africa/Cairo', NULL, NULL),
(52, 'Syria Standard Time', 'SDT', '(UTC+02:00) Damascus', '+3', 'true', 'Asia/Damascus', NULL, NULL),
(53, 'E. Europe Standard Time', 'EEDT', '(UTC+02:00) E. Europe', '+3', 'true', '\"Asia/Nicosia,Europe/Athens,Europe/Bucharest,Europe/Chisinau,Europe/Helsinki,Europe/Kiev,Europe/Mariehamn,Europe/Nicosia,Europe/Riga,Europe/Sofia,Europe/Tallinn,Europe/Uzhgorod,Europe/Vilnius,Europe/Zaporozhye\"', NULL, NULL),
(54, 'South Africa Standard Time', 'SAST', '\"(UTC+02:00) Harare, Pretoria\"', '+2', 'false', '\"Africa/Blantyre,Africa/Bujumbura,Africa/Gaborone,Africa/Harare,Africa/Johannesburg,Africa/Kigali,Africa/Lubumbashi,Africa/Lusaka,Africa/Maputo,Africa/Maseru,Africa/Mbabane,Etc/GMT-2\"', NULL, NULL),
(55, 'FLE Standard Time', 'FDT', '\"(UTC+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius\"', '+3', 'true', '\"Europe/Helsinki,Europe/Kiev,Europe/Mariehamn,Europe/Riga,Europe/Sofia,Europe/Tallinn,Europe/Uzhgorod,Europe/Vilnius,Europe/Zaporozhye\"', NULL, NULL),
(56, 'Turkey Standard Time', 'TDT', '(UTC+03:00) Istanbul', '+3', 'false', 'Europe/Istanbul', NULL, NULL),
(57, 'Israel Standard Time', 'JDT', '(UTC+02:00) Jerusalem', '+3', 'true', 'Asia/Jerusalem', NULL, NULL),
(58, 'Libya Standard Time', 'LST', '(UTC+02:00) Tripoli', '+2', 'false', 'Africa/Tripoli', NULL, NULL),
(59, 'Jordan Standard Time', 'JST', '(UTC+03:00) Amman', '+3', 'false', 'Asia/Amman', NULL, NULL),
(60, 'Arabic Standard Time', 'AST', '(UTC+03:00) Baghdad', '+3', 'false', 'Asia/Baghdad', NULL, NULL),
(61, 'Kaliningrad Standard Time', 'KST', '(UTC+02:00) Kaliningrad', '+3', 'false', 'Europe/Kaliningrad', NULL, NULL),
(62, 'Arab Standard Time', 'AST', '\"(UTC+03:00) Kuwait, Riyadh\"', '+3', 'false', '\"Asia/Aden,Asia/Bahrain,Asia/Kuwait,Asia/Qatar,Asia/Riyadh\"', NULL, NULL),
(63, 'E. Africa Standard Time', 'EAST', '(UTC+03:00) Nairobi', '+3', 'false', '\"Africa/Addis_Ababa,Africa/Asmera,Africa/Dar_es_Salaam,Africa/Djibouti,Africa/Juba,Africa/Kampala,Africa/Khartoum,Africa/Mogadishu,Africa/Nairobi,Antarctica/Syowa,Etc/GMT-3,Indian/Antananarivo,Indian/Comoro,Indian/Mayotte\"', NULL, NULL),
(64, 'Moscow Standard Time', 'MSK', '\"(UTC+03:00) Moscow, St. Petersburg, Volgograd, Minsk\"', '+3', 'false', '\"Europe/Kirov,Europe/Moscow,Europe/Simferopol,Europe/Volgograd,Europe/Minsk\"', NULL, NULL),
(65, 'Samara Time', 'SAMT', '\"(UTC+04:00) Samara, Ulyanovsk, Saratov\"', '+4', 'false', '\"Europe/Astrakhan,Europe/Samara,Europe/Ulyanovsk\"', NULL, NULL),
(66, 'Iran Standard Time', 'IDT', '(UTC+03:30) Tehran', '+4.5', 'true', 'Asia/Tehran', NULL, NULL),
(67, 'Arabian Standard Time', 'AST', '\"(UTC+04:00) Abu Dhabi, Muscat\"', '+4', 'false', '\"Asia/Dubai,Asia/Muscat,Etc/GMT-4\"', NULL, NULL),
(68, 'Azerbaijan Standard Time', 'ADT', '(UTC+04:00) Baku', '+5', 'true', 'Asia/Baku', NULL, NULL),
(69, 'Mauritius Standard Time', 'MST', '(UTC+04:00) Port Louis', '+4', 'false', '\"Indian/Mahe,Indian/Mauritius,Indian/Reunion\"', NULL, NULL),
(70, 'Georgian Standard Time', 'GET', '(UTC+04:00) Tbilisi', '+4', 'false', 'Asia/Tbilisi', NULL, NULL),
(71, 'Caucasus Standard Time', 'CST', '(UTC+04:00) Yerevan', '+4', 'false', 'Asia/Yerevan', NULL, NULL),
(72, 'Afghanistan Standard Time', 'AST', '(UTC+04:30) Kabul', '+4.5', 'false', 'Asia/Kabul', NULL, NULL),
(73, 'West Asia Standard Time', 'WAST', '\"(UTC+05:00) Ashgabat, Tashkent\"', '+5', 'false', '\"Antarctica/Mawson,Asia/Aqtau,Asia/Aqtobe,Asia/Ashgabat,Asia/Dushanbe,Asia/Oral,Asia/Samarkand,Asia/Tashkent,Etc/GMT-5,Indian/Kerguelen,Indian/Maldives\"', NULL, NULL),
(74, 'Yekaterinburg Time', 'YEKT', '(UTC+05:00) Yekaterinburg', '+5', 'false', 'Asia/Yekaterinburg', NULL, NULL),
(75, 'Pakistan Standard Time', 'PKT', '\"(UTC+05:00) Islamabad, Karachi\"', '+5', 'false', 'Asia/Karachi', NULL, NULL),
(76, 'India Standard Time', 'IST', '\"(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi\"', '+5.5', 'false', '\"Asia/Kolkata,Asia/Calcutta\"', NULL, NULL),
(77, 'Sri Lanka Standard Time', 'SLST', '(UTC+05:30) Sri Jayawardenepura', '+5.5', 'false', 'Asia/Colombo', NULL, NULL),
(78, 'Nepal Standard Time', 'NST', '(UTC+05:45) Kathmandu', '+5.75', 'false', 'Asia/Kathmandu', NULL, NULL),
(79, 'Central Asia Standard Time', 'CAST', '(UTC+06:00) Nur-Sultan (Astana)', '+6', 'false', '\"Antarctica/Vostok,Asia/Almaty,Asia/Bishkek,Asia/Qyzylorda,Asia/Urumqi,Etc/GMT-6,Indian/Chagos\"', NULL, NULL),
(80, 'Bangladesh Standard Time', 'BST', '(UTC+06:00) Dhaka', '+6', 'false', '\"Asia/Dhaka,Asia/Thimphu\"', NULL, NULL),
(81, 'Myanmar Standard Time', 'MST', '(UTC+06:30) Yangon (Rangoon)', '+6.5', 'false', '\"Asia/Rangoon,Indian/Cocos\"', NULL, NULL),
(82, 'SE Asia Standard Time', 'SAST', '\"(UTC+07:00) Bangkok, Hanoi, Jakarta\"', '+7', 'false', '\"Antarctica/Davis,Asia/Bangkok,Asia/Hovd,Asia/Jakarta,Asia/Phnom_Penh,Asia/Pontianak,Asia/Saigon,Asia/Vientiane,Etc/GMT-7,Indian/Christmas\"', NULL, NULL),
(83, 'N. Central Asia Standard Time', 'NCAST', '(UTC+07:00) Novosibirsk', '+7', 'false', '\"Asia/Novokuznetsk,Asia/Novosibirsk,Asia/Omsk\"', NULL, NULL),
(84, 'China Standard Time', 'CST', '\"(UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi\"', '+8', 'false', '\"Asia/Hong_Kong,Asia/Macau,Asia/Shanghai\"', NULL, NULL),
(85, 'North Asia Standard Time', 'NAST', '(UTC+08:00) Krasnoyarsk', '+8', 'false', 'Asia/Krasnoyarsk', NULL, NULL),
(86, 'Singapore Standard Time', 'MPST', '\"(UTC+08:00) Kuala Lumpur, Singapore\"', '+8', 'false', '\"Asia/Brunei,Asia/Kuala_Lumpur,Asia/Kuching,Asia/Makassar,Asia/Manila,Asia/Singapore,Etc/GMT-8\"', NULL, NULL),
(87, 'W. Australia Standard Time', 'WAST', '(UTC+08:00) Perth', '+8', 'false', '\"Antarctica/Casey,Australia/Perth\"', NULL, NULL),
(88, 'Taipei Standard Time', 'TST', '(UTC+08:00) Taipei', '+8', 'false', 'Asia/Taipei', NULL, NULL),
(89, 'Ulaanbaatar Standard Time', 'UST', '(UTC+08:00) Ulaanbaatar', '+8', 'false', '\"Asia/Choibalsan,Asia/Ulaanbaatar\"', NULL, NULL),
(90, 'North Asia East Standard Time', 'NAEST', '(UTC+08:00) Irkutsk', '+8', 'false', 'Asia/Irkutsk', NULL, NULL),
(91, 'Japan Standard Time', 'JST', '\"(UTC+09:00) Osaka, Sapporo, Tokyo\"', '+9', 'false', '\"Asia/Dili,Asia/Jayapura,Asia/Tokyo,Etc/GMT-9,Pacific/Palau\"', NULL, NULL),
(92, 'Korea Standard Time', 'KST', '(UTC+09:00) Seoul', '+9', 'false', '\"Asia/Pyongyang,Asia/Seoul\"', NULL, NULL),
(93, 'Cen. Australia Standard Time', 'CAST', '(UTC+09:30) Adelaide', '+9.5', 'false', '\"Australia/Adelaide,Australia/Broken_Hill\"', NULL, NULL),
(94, 'AUS Central Standard Time', 'ACST', '(UTC+09:30) Darwin', '+9.5', 'false', 'Australia/Darwin', NULL, NULL),
(95, 'E. Australia Standard Time', 'EAST', '(UTC+10:00) Brisbane', '+10', 'false', '\"Australia/Brisbane,Australia/Lindeman\"', NULL, NULL),
(96, 'AUS Eastern Standard Time', 'AEST', '\"(UTC+10:00) Canberra, Melbourne, Sydney\"', '+10', 'false', '\"Australia/Melbourne,Australia/Sydney\"', NULL, NULL),
(97, 'West Pacific Standard Time', 'WPST', '\"(UTC+10:00) Guam, Port Moresby\"', '+10', 'false', '\"Antarctica/DumontDUrville,Etc/GMT-10,Pacific/Guam,Pacific/Port_Moresby,Pacific/Saipan,Pacific/Truk\"', NULL, NULL),
(98, 'Tasmania Standard Time', 'TST', '(UTC+10:00) Hobart', '+10', 'false', '\"Australia/Currie,Australia/Hobart\"', NULL, NULL),
(99, 'Yakutsk Standard Time', 'YST', '(UTC+09:00) Yakutsk', '+9', 'false', '\"Asia/Chita,Asia/Khandyga,Asia/Yakutsk\"', NULL, NULL),
(100, 'Central Pacific Standard Time', 'CPST', '\"(UTC+11:00) Solomon Is., New Caledonia\"', '+11', 'false', '\"Antarctica/Macquarie,Etc/GMT-11,Pacific/Efate,Pacific/Guadalcanal,Pacific/Kosrae,Pacific/Noumea,Pacific/Ponape\"', NULL, NULL),
(101, 'Vladivostok Standard Time', 'VST', '(UTC+11:00) Vladivostok', '+11', 'false', '\"Asia/Sakhalin,Asia/Ust-Nera,Asia/Vladivostok\"', NULL, NULL),
(102, 'New Zealand Standard Time', 'NZST', '\"(UTC+12:00) Auckland, Wellington\"', '+12', 'false', '\"Antarctica/McMurdo,Pacific/Auckland\"', NULL, NULL),
(103, 'UTC+12', 'U', '(UTC+12:00) Coordinated Universal Time+12', '+12', 'false', '\"Etc/GMT-12,Pacific/Funafuti,Pacific/Kwajalein,Pacific/Majuro,Pacific/Nauru,Pacific/Tarawa,Pacific/Wake,Pacific/Wallis\"', NULL, NULL),
(104, 'Fiji Standard Time', 'FST', '(UTC+12:00) Fiji', '+12', 'false', 'Pacific/Fiji', NULL, NULL),
(105, 'Magadan Standard Time', 'MST', '(UTC+12:00) Magadan', '+12', 'false', '\"Asia/Anadyr,Asia/Kamchatka,Asia/Magadan,Asia/Srednekolymsk\"', NULL, NULL),
(106, 'Kamchatka Standard Time', 'KDT', '(UTC+12:00) Petropavlovsk-Kamchatsky - Old', '+13', 'true', 'Asia/Kamchatka', NULL, NULL),
(107, 'Tonga Standard Time', 'TST', '(UTC+13:00) Nukualofa', '+13', 'false', '\"Etc/GMT-13,Pacific/Enderbury,Pacific/Fakaofo,Pacific/Tongatapu\"', NULL, NULL),
(108, 'Samoa Standard Time', 'SST', '(UTC+13:00) Samoa', '+13', 'false', 'Pacific/Apia', NULL, NULL);