November 2012 - spacewalk-commits - Fedora Mailing-Lists

Changes to 'refs/tags/spacewalk-java-1.9.22-1'

by Tomas Lestach

Tag 'spacewalk-java-1.9.22-1' created by Tomas Lestach <tlestach(a)redhat.com> at 2012-11-28 16:47 +0000 Tagging package [spacewalk-java] version [1.9.22-1] in directory [java/]. Changes since spacewalk-web-1.9.4-1: Tomas Lestach (1): Automatic commit of package [spacewalk-java] release [1.9.22-1]. --- java/spacewalk-java.spec | 13 ++++++++++++- rel-eng/packages/spacewalk-java | 2 +- 2 files changed, 13 insertions(+), 2 deletions(-) ---

11 years, 5 months

1
0
0 / 0

java/spacewalk-java.spec rel-eng/packages

by Tomas Lestach

java/spacewalk-java.spec | 13 ++++++++++++- rel-eng/packages/spacewalk-java | 2 +- 2 files changed, 13 insertions(+), 2 deletions(-) New commits: commit ffa1b9c32d33b12eb62b63d02cda83f978102f74 Author: Tomas Lestach <tlestach(a)redhat.com> Date: Wed Nov 28 17:47:21 2012 +0100 Automatic commit of package [spacewalk-java] release [1.9.22-1]. diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec index fa670b5..8071f0c 100644 --- a/java/spacewalk-java.spec +++ b/java/spacewalk-java.spec @@ -23,7 +23,7 @@ Name: spacewalk-java Summary: Spacewalk Java site packages Group: Applications/Internet License: GPLv2 -Version: 1.9.21 +Version: 1.9.22 Release: 1%{?dist} URL: https://fedorahosted.org/spacewalk Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz @@ -617,6 +617,17 @@ fi %{jardir}/postgresql-jdbc.jar %changelog +* Wed Nov 28 2012 Tomas Lestach <tlestach(a)redhat.com> 1.9.22-1 +- typo fix +- 519472 - suggest deleting custom packages after a channel is deleted +- 880346 - deleting an org should remove cobbler profiles too +- Revert "880346 - delete cobbler profiles when deleting an org" +- add a null check +- 470463 - fixing xmllint issue +- put a newline before pre_install_network_config snippet +- 880346 - delete cobbler profiles when deleting an org +- 675193 - removing the confising tip + * Mon Nov 26 2012 Jan Pazdziora 1.9.21-1 - 864037 - fixing typo. diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java index 34ef4bc..310bd77 100644 --- a/rel-eng/packages/spacewalk-java +++ b/rel-eng/packages/spacewalk-java @@ -1 +1 @@ -1.9.21-1 java/ +1.9.22-1 java/

11 years, 5 months

1
0
0 / 0

Changes to 'refs/tags/spacewalk-web-1.9.4-1'

by Tomas Lestach

Tag 'spacewalk-web-1.9.4-1' created by Tomas Lestach <tlestach(a)redhat.com> at 2012-11-28 16:46 +0000 Tagging package [spacewalk-web] version [1.9.4-1] in directory [web/]. Changes since spacewalk-branding-1.9.3-1: Tomas Lestach (1): Automatic commit of package [spacewalk-web] release [1.9.4-1]. --- rel-eng/packages/spacewalk-web | 2 +- web/spacewalk-web.spec | 5 ++++- 2 files changed, 5 insertions(+), 2 deletions(-) ---

11 years, 5 months

1
0
0 / 0

Changes to 'refs/tags/spacewalk-branding-1.9.3-1'

by Tomas Lestach

Tag 'spacewalk-branding-1.9.3-1' created by Tomas Lestach <tlestach(a)redhat.com> at 2012-11-28 16:46 +0000 Tagging package [spacewalk-branding] version [1.9.3-1] in directory [branding/]. Changes since spacewalk-java-1.9.21-1: Milan Zazrivec (5): 877451 - read the repo config from yumbase put a newline before pre_install_network_config snippet typo fix New installation type: RHEL 7 New timezones for RHEL 7 Stephen Herr (4): 880346 - delete cobbler profiles when deleting an org 879299 - statinfo needs to be defined even if file does not exist Revert "880346 - delete cobbler profiles when deleting an org" 880346 - deleting an org should remove cobbler profiles too Tomas Lestach (5): 675193 - removing the confising tip 470463 - fixing xmllint issue add a null check 519472 - suggest deleting custom packages after a channel is deleted Automatic commit of package [spacewalk-branding] release [1.9.3-1]. --- backend/satellite_tools/repo_plugins/yum_src.py | 5 branding/spacewalk-branding.spec | 5 branding/styles/navbar_top.txt | 2 branding/styles/navbar_top_sat.txt | 2 client/tools/rhncfg/config_common/file_utils.py | 6 java/code/src/com/redhat/rhn/domain/kickstart/KickstartFactory.java | 10 java/code/src/com/redhat/rhn/domain/org/OrgFactory.java | 97 java/code/src/com/redhat/rhn/frontend/action/channel/manage/DeleteChannelAction.java | 32 java/code/src/com/redhat/rhn/frontend/action/multiorg/OrgDeleteAction.java | 12 java/code/src/com/redhat/rhn/frontend/action/rhnpackage/CustomPackageListAction.java | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_bn_IN.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_de.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_en_US.xml | 8 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_es.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_fr.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_gu.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_hi.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_it.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_ja.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_ko.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_pa.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_pt_BR.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_ru.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_ta.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_zh_CN.xml | 7 java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_zh_TW.xml | 7 java/code/src/com/redhat/rhn/frontend/taglibs/list/ListTagUtil.java | 2 java/code/src/com/redhat/rhn/frontend/xmlrpc/org/OrgHandler.java | 32 java/code/src/com/redhat/rhn/frontend/xmlrpc/test/SatScrubberTest.java | 15 java/code/src/com/redhat/rhn/manager/kickstart/KickstartDeleteCommand.java | 12 java/code/src/com/redhat/rhn/manager/kickstart/KickstartFormatter.java | 1 java/code/webapp/WEB-INF/includes/header.jsp | 2 java/code/webapp/WEB-INF/pages/common/fragments/configuration/channel/create.jspf | 1 java/code/webapp/WEB-INF/struts-config.xml | 1 rel-eng/packages/spacewalk-branding | 2 schema/spacewalk/common/data/rhnKSInstallType.sql | 5 schema/spacewalk/common/data/rhnKickstartTimezone.sql | 2904 +++++++++ schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/002-rhnKSInstallType.sql | 4 schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/003-rhnKickstartTimezome.sql | 2905 ++++++++++ web/html/errors/403.html | 2 web/html/errors/404.html | 2 web/html/errors/413.html | 2 web/html/errors/500.html | 2 43 files changed, 5984 insertions(+), 201 deletions(-) ---

11 years, 5 months

1
0
0 / 0

rel-eng/packages web/spacewalk-web.spec

by Tomas Lestach

rel-eng/packages/spacewalk-web | 2 +- web/spacewalk-web.spec | 5 ++++- 2 files changed, 5 insertions(+), 2 deletions(-) New commits: commit 83a097c54cee604b1abf15565023eb9ead8a1e76 Author: Tomas Lestach <tlestach(a)redhat.com> Date: Wed Nov 28 17:46:51 2012 +0100 Automatic commit of package [spacewalk-web] release [1.9.4-1]. diff --git a/rel-eng/packages/spacewalk-web b/rel-eng/packages/spacewalk-web index eab61e7..d57a8a5 100644 --- a/rel-eng/packages/spacewalk-web +++ b/rel-eng/packages/spacewalk-web @@ -1 +1 @@ -1.9.3-1 web/ +1.9.4-1 web/ diff --git a/web/spacewalk-web.spec b/web/spacewalk-web.spec index e3ea9f4..e0efe8d 100644 --- a/web/spacewalk-web.spec +++ b/web/spacewalk-web.spec @@ -2,7 +2,7 @@ Name: spacewalk-web Summary: Spacewalk Web site - Perl modules Group: Applications/Internet License: GPLv2 -Version: 1.9.3 +Version: 1.9.4 Release: 1%{?dist} URL: https://fedorahosted.org/spacewalk/ Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz @@ -253,6 +253,9 @@ rm -rf $RPM_BUILD_ROOT # $Id$ %changelog +* Wed Nov 28 2012 Tomas Lestach <tlestach(a)redhat.com> 1.9.4-1 +- 470463 - fixing xmllint issue + * Wed Nov 21 2012 Jan Pazdziora 1.9.3-1 - Revert "removed dead query" - Revert "The ssm_rollback_by_tag_action_cb method no longer referenced,

11 years, 5 months

1
0
0 / 0

branding/spacewalk-branding.spec rel-eng/packages

by Tomas Lestach

branding/spacewalk-branding.spec | 5 ++++- rel-eng/packages/spacewalk-branding | 2 +- 2 files changed, 5 insertions(+), 2 deletions(-) New commits: commit 31b7744a932db334113702c14ef235d3af8043a9 Author: Tomas Lestach <tlestach(a)redhat.com> Date: Wed Nov 28 17:46:15 2012 +0100 Automatic commit of package [spacewalk-branding] release [1.9.3-1]. diff --git a/branding/spacewalk-branding.spec b/branding/spacewalk-branding.spec index 490f383..d01876c 100644 --- a/branding/spacewalk-branding.spec +++ b/branding/spacewalk-branding.spec @@ -1,5 +1,5 @@ Name: spacewalk-branding -Version: 1.9.2 +Version: 1.9.3 Release: 1%{?dist} Summary: Spacewalk branding data @@ -82,6 +82,9 @@ rm -rf %{buildroot} %doc LICENSE %changelog +* Wed Nov 28 2012 Tomas Lestach <tlestach(a)redhat.com> 1.9.3-1 +- 470463 - fixing xmllint issue + * Mon Nov 12 2012 Tomas Lestach <tlestach(a)redhat.com> 1.9.2-1 - Fix typos diff --git a/rel-eng/packages/spacewalk-branding b/rel-eng/packages/spacewalk-branding index 0ca7ff1..4bbec71 100644 --- a/rel-eng/packages/spacewalk-branding +++ b/rel-eng/packages/spacewalk-branding @@ -1 +1 @@ -1.9.2-1 branding/ +1.9.3-1 branding/

11 years, 5 months

1
0
0 / 0

schema/spacewalk

by Milan Zazrivec

schema/spacewalk/common/data/rhnKickstartTimezone.sql | 2904 +++++++++ schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/003-rhnKickstartTimezome.sql | 2905 ++++++++++ 2 files changed, 5809 insertions(+) New commits: commit 3f9ae912977dc08fadb79d709209448516eeddee Author: Milan Zazrivec <mzazrivec(a)redhat.com> Date: Wed Nov 28 17:19:41 2012 +0100 New timezones for RHEL 7 diff --git a/schema/spacewalk/common/data/rhnKickstartTimezone.sql b/schema/spacewalk/common/data/rhnKickstartTimezone.sql index 8ca8c19..1a75925 100644 --- a/schema/spacewalk/common/data/rhnKickstartTimezone.sql +++ b/schema/spacewalk/common/data/rhnKickstartTimezone.sql @@ -13148,5 +13148,2909 @@ insert into rhnKickstartTimezone (id, label, name, install_type) 'America/Toronto', (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_6') ); +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Abidjan', + 'Africa/Abidjan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Accra', + 'Africa/Accra', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Addis_Ababa', + 'Africa/Addis_Ababa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Algiers', + 'Africa/Algiers', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Asmara', + 'Africa/Asmara', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Bamako', + 'Africa/Bamako', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Bangui', + 'Africa/Bangui', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Banjul', + 'Africa/Banjul', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Bissau', + 'Africa/Bissau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Blantyre', + 'Africa/Blantyre', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Brazzaville', + 'Africa/Brazzaville', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Bujumbura', + 'Africa/Bujumbura', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Cairo', + 'Africa/Cairo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Casablanca', + 'Africa/Casablanca', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Ceuta', + 'Africa/Ceuta', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Conakry', + 'Africa/Conakry', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Dakar', + 'Africa/Dakar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Dar_es_Salaam', + 'Africa/Dar_es_Salaam', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Djibouti', + 'Africa/Djibouti', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Douala', + 'Africa/Douala', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/El_Aaiun', + 'Africa/El_Aaiun', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Freetown', + 'Africa/Freetown', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Gaborone', + 'Africa/Gaborone', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Harare', + 'Africa/Harare', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Johannesburg', + 'Africa/Johannesburg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Juba', + 'Africa/Juba', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Kampala', + 'Africa/Kampala', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Khartoum', + 'Africa/Khartoum', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Kigali', + 'Africa/Kigali', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Kinshasa', + 'Africa/Kinshasa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Lagos', + 'Africa/Lagos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Libreville', + 'Africa/Libreville', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Lome', + 'Africa/Lome', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Luanda', + 'Africa/Luanda', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Lubumbashi', + 'Africa/Lubumbashi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Lusaka', + 'Africa/Lusaka', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Malabo', + 'Africa/Malabo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Maputo', + 'Africa/Maputo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Maseru', + 'Africa/Maseru', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Mbabane', + 'Africa/Mbabane', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Mogadishu', + 'Africa/Mogadishu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Monrovia', + 'Africa/Monrovia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Nairobi', + 'Africa/Nairobi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Ndjamena', + 'Africa/Ndjamena', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Niamey', + 'Africa/Niamey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Nouakchott', + 'Africa/Nouakchott', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Ouagadougou', + 'Africa/Ouagadougou', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Porto-Novo', + 'Africa/Porto-Novo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Sao_Tome', + 'Africa/Sao_Tome', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Tripoli', + 'Africa/Tripoli', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Tunis', + 'Africa/Tunis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Windhoek', + 'Africa/Windhoek', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Adak', + 'America/Adak', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Anchorage', + 'America/Anchorage', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Anguilla', + 'America/Anguilla', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Antigua', + 'America/Antigua', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Araguaina', + 'America/Araguaina', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Buenos_Aires', + 'America/Argentina/Buenos_Aires', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Catamarca', + 'America/Argentina/Catamarca', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Cordoba', + 'America/Argentina/Cordoba', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Jujuy', + 'America/Argentina/Jujuy', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/La_Rioja', + 'America/Argentina/La_Rioja', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Mendoza', + 'America/Argentina/Mendoza', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Rio_Gallegos', + 'America/Argentina/Rio_Gallegos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Salta', + 'America/Argentina/Salta', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/San_Juan', + 'America/Argentina/San_Juan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/San_Luis', + 'America/Argentina/San_Luis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Tucuman', + 'America/Argentina/Tucuman', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Ushuaia', + 'America/Argentina/Ushuaia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Aruba', + 'America/Aruba', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Asuncion', + 'America/Asuncion', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Atikokan', + 'America/Atikokan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Bahia', + 'America/Bahia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Bahia_Banderas', + 'America/Bahia_Banderas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Barbados', + 'America/Barbados', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Belem', + 'America/Belem', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Belize', + 'America/Belize', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Blanc-Sablon', + 'America/Blanc-Sablon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Boa_Vista', + 'America/Boa_Vista', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Bogota', + 'America/Bogota', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Boise', + 'America/Boise', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cambridge_Bay', + 'America/Cambridge_Bay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Campo_Grande', + 'America/Campo_Grande', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cancun', + 'America/Cancun', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Caracas', + 'America/Caracas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cayenne', + 'America/Cayenne', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cayman', + 'America/Cayman', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Chicago', + 'America/Chicago', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Chihuahua', + 'America/Chihuahua', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Costa_Rica', + 'America/Costa_Rica', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Creston', + 'America/Creston', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cuiaba', + 'America/Cuiaba', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Curacao', + 'America/Curacao', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Danmarkshavn', + 'America/Danmarkshavn', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Dawson', + 'America/Dawson', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Dawson_Creek', + 'America/Dawson_Creek', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Denver', + 'America/Denver', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Detroit', + 'America/Detroit', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Dominica', + 'America/Dominica', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Edmonton', + 'America/Edmonton', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Eirunepe', + 'America/Eirunepe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/El_Salvador', + 'America/El_Salvador', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Fortaleza', + 'America/Fortaleza', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Glace_Bay', + 'America/Glace_Bay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Godthab', + 'America/Godthab', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Goose_Bay', + 'America/Goose_Bay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Grand_Turk', + 'America/Grand_Turk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Grenada', + 'America/Grenada', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Guadeloupe', + 'America/Guadeloupe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Guatemala', + 'America/Guatemala', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Guayaquil', + 'America/Guayaquil', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Guyana', + 'America/Guyana', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Halifax', + 'America/Halifax', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Havana', + 'America/Havana', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Hermosillo', + 'America/Hermosillo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Indianapolis', + 'America/Indiana/Indianapolis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Knox', + 'America/Indiana/Knox', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Marengo', + 'America/Indiana/Marengo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Petersburg', + 'America/Indiana/Petersburg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Tell_City', + 'America/Indiana/Tell_City', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Vevay', + 'America/Indiana/Vevay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Vincennes', + 'America/Indiana/Vincennes', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Winamac', + 'America/Indiana/Winamac', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Inuvik', + 'America/Inuvik', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Iqaluit', + 'America/Iqaluit', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Jamaica', + 'America/Jamaica', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Juneau', + 'America/Juneau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Kentucky/Louisville', + 'America/Kentucky/Louisville', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Kentucky/Monticello', + 'America/Kentucky/Monticello', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Kralendijk', + 'America/Kralendijk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/La_Paz', + 'America/La_Paz', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Lima', + 'America/Lima', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Los_Angeles', + 'America/Los_Angeles', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Lower_Princes', + 'America/Lower_Princes', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Maceio', + 'America/Maceio', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Managua', + 'America/Managua', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Manaus', + 'America/Manaus', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Marigot', + 'America/Marigot', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Martinique', + 'America/Martinique', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Matamoros', + 'America/Matamoros', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Mazatlan', + 'America/Mazatlan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Menominee', + 'America/Menominee', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Merida', + 'America/Merida', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Metlakatla', + 'America/Metlakatla', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Mexico_City', + 'America/Mexico_City', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Miquelon', + 'America/Miquelon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Moncton', + 'America/Moncton', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Monterrey', + 'America/Monterrey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Montevideo', + 'America/Montevideo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Montreal', + 'America/Montreal', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Montserrat', + 'America/Montserrat', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Nassau', + 'America/Nassau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/New_York', + 'America/New_York', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Nipigon', + 'America/Nipigon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Nome', + 'America/Nome', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Noronha', + 'America/Noronha', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/North_Dakota/Beulah', + 'America/North_Dakota/Beulah', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/North_Dakota/Center', + 'America/North_Dakota/Center', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/North_Dakota/New_Salem', + 'America/North_Dakota/New_Salem', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Ojinaga', + 'America/Ojinaga', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Panama', + 'America/Panama', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Pangnirtung', + 'America/Pangnirtung', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Paramaribo', + 'America/Paramaribo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Phoenix', + 'America/Phoenix', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Port_of_Spain', + 'America/Port_of_Spain', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Port-au-Prince', + 'America/Port-au-Prince', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Porto_Velho', + 'America/Porto_Velho', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Puerto_Rico', + 'America/Puerto_Rico', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Rainy_River', + 'America/Rainy_River', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Rankin_Inlet', + 'America/Rankin_Inlet', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Recife', + 'America/Recife', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Regina', + 'America/Regina', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Resolute', + 'America/Resolute', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Rio_Branco', + 'America/Rio_Branco', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Santa_Isabel', + 'America/Santa_Isabel', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Santarem', + 'America/Santarem', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Santiago', + 'America/Santiago', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Santo_Domingo', + 'America/Santo_Domingo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Sao_Paulo', + 'America/Sao_Paulo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Scoresbysund', + 'America/Scoresbysund', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Shiprock', + 'America/Shiprock', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Sitka', + 'America/Sitka', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Barthelemy', + 'America/St_Barthelemy', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Johns', + 'America/St_Johns', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Kitts', + 'America/St_Kitts', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Lucia', + 'America/St_Lucia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Thomas', + 'America/St_Thomas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Vincent', + 'America/St_Vincent', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Swift_Current', + 'America/Swift_Current', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Tegucigalpa', + 'America/Tegucigalpa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Thule', + 'America/Thule', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Thunder_Bay', + 'America/Thunder_Bay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Tijuana', + 'America/Tijuana', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Toronto', + 'America/Toronto', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Tortola', + 'America/Tortola', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Vancouver', + 'America/Vancouver', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Whitehorse', + 'America/Whitehorse', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Winnipeg', + 'America/Winnipeg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Yakutat', + 'America/Yakutat', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Yellowknife', + 'America/Yellowknife', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Casey', + 'Antarctica/Casey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Davis', + 'Antarctica/Davis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/DumontDUrville', + 'Antarctica/DumontDUrville', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Macquarie', + 'Antarctica/Macquarie', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Mawson', + 'Antarctica/Mawson', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/McMurdo', + 'Antarctica/McMurdo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Palmer', + 'Antarctica/Palmer', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Rothera', + 'Antarctica/Rothera', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/South_Pole', + 'Antarctica/South_Pole', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Syowa', + 'Antarctica/Syowa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Vostok', + 'Antarctica/Vostok', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Arctic/Longyearbyen', + 'Arctic/Longyearbyen', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Aden', + 'Asia/Aden', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Almaty', + 'Asia/Almaty', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Amman', + 'Asia/Amman', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Anadyr', + 'Asia/Anadyr', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Aqtau', + 'Asia/Aqtau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Aqtobe', + 'Asia/Aqtobe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Ashgabat', + 'Asia/Ashgabat', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Baghdad', + 'Asia/Baghdad', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Bahrain', + 'Asia/Bahrain', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Baku', + 'Asia/Baku', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Bangkok', + 'Asia/Bangkok', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Beirut', + 'Asia/Beirut', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Bishkek', + 'Asia/Bishkek', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Brunei', + 'Asia/Brunei', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Choibalsan', + 'Asia/Choibalsan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Chongqing', + 'Asia/Chongqing', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Colombo', + 'Asia/Colombo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Damascus', + 'Asia/Damascus', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Dhaka', + 'Asia/Dhaka', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Dili', + 'Asia/Dili', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Dubai', + 'Asia/Dubai', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Dushanbe', + 'Asia/Dushanbe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Gaza', + 'Asia/Gaza', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Harbin', + 'Asia/Harbin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Hebron', + 'Asia/Hebron', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Ho_Chi_Minh', + 'Asia/Ho_Chi_Minh', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Hong_Kong', + 'Asia/Hong_Kong', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Hovd', + 'Asia/Hovd', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Irkutsk', + 'Asia/Irkutsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Jakarta', + 'Asia/Jakarta', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Jayapura', + 'Asia/Jayapura', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Jerusalem', + 'Asia/Jerusalem', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kabul', + 'Asia/Kabul', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kamchatka', + 'Asia/Kamchatka', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Karachi', + 'Asia/Karachi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kashgar', + 'Asia/Kashgar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kathmandu', + 'Asia/Kathmandu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kolkata', + 'Asia/Kolkata', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Krasnoyarsk', + 'Asia/Krasnoyarsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kuala_Lumpur', + 'Asia/Kuala_Lumpur', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kuching', + 'Asia/Kuching', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kuwait', + 'Asia/Kuwait', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Macau', + 'Asia/Macau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Magadan', + 'Asia/Magadan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Makassar', + 'Asia/Makassar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Manila', + 'Asia/Manila', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Muscat', + 'Asia/Muscat', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Nicosia', + 'Asia/Nicosia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Novokuznetsk', + 'Asia/Novokuznetsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Novosibirsk', + 'Asia/Novosibirsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Omsk', + 'Asia/Omsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Oral', + 'Asia/Oral', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Phnom_Penh', + 'Asia/Phnom_Penh', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Pontianak', + 'Asia/Pontianak', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Pyongyang', + 'Asia/Pyongyang', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Qatar', + 'Asia/Qatar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Qyzylorda', + 'Asia/Qyzylorda', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Rangoon', + 'Asia/Rangoon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Riyadh', + 'Asia/Riyadh', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Sakhalin', + 'Asia/Sakhalin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Samarkand', + 'Asia/Samarkand', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Seoul', + 'Asia/Seoul', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Shanghai', + 'Asia/Shanghai', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Singapore', + 'Asia/Singapore', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Taipei', + 'Asia/Taipei', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Tashkent', + 'Asia/Tashkent', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Tbilisi', + 'Asia/Tbilisi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Tehran', + 'Asia/Tehran', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Thimphu', + 'Asia/Thimphu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Tokyo', + 'Asia/Tokyo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Ulaanbaatar', + 'Asia/Ulaanbaatar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Urumqi', + 'Asia/Urumqi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Vientiane', + 'Asia/Vientiane', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Vladivostok', + 'Asia/Vladivostok', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Yakutsk', + 'Asia/Yakutsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Yekaterinburg', + 'Asia/Yekaterinburg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Yerevan', + 'Asia/Yerevan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Azores', + 'Atlantic/Azores', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Bermuda', + 'Atlantic/Bermuda', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Canary', + 'Atlantic/Canary', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Cape_Verde', + 'Atlantic/Cape_Verde', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Faroe', + 'Atlantic/Faroe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Madeira', + 'Atlantic/Madeira', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Reykjavik', + 'Atlantic/Reykjavik', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/South_Georgia', + 'Atlantic/South_Georgia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/St_Helena', + 'Atlantic/St_Helena', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Stanley', + 'Atlantic/Stanley', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Adelaide', + 'Australia/Adelaide', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Brisbane', + 'Australia/Brisbane', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Broken_Hill', + 'Australia/Broken_Hill', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Currie', + 'Australia/Currie', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Darwin', + 'Australia/Darwin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Eucla', + 'Australia/Eucla', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Hobart', + 'Australia/Hobart', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Lindeman', + 'Australia/Lindeman', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Lord_Howe', + 'Australia/Lord_Howe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Melbourne', + 'Australia/Melbourne', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Perth', + 'Australia/Perth', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Sydney', + 'Australia/Sydney', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Amsterdam', + 'Europe/Amsterdam', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Andorra', + 'Europe/Andorra', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Athens', + 'Europe/Athens', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Belgrade', + 'Europe/Belgrade', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Berlin', + 'Europe/Berlin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Bratislava', + 'Europe/Bratislava', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Brussels', + 'Europe/Brussels', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Bucharest', + 'Europe/Bucharest', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Budapest', + 'Europe/Budapest', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Chisinau', + 'Europe/Chisinau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Copenhagen', + 'Europe/Copenhagen', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Dublin', + 'Europe/Dublin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Gibraltar', + 'Europe/Gibraltar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Guernsey', + 'Europe/Guernsey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Helsinki', + 'Europe/Helsinki', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Isle_of_Man', + 'Europe/Isle_of_Man', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Istanbul', + 'Europe/Istanbul', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Jersey', + 'Europe/Jersey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Kaliningrad', + 'Europe/Kaliningrad', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Kiev', + 'Europe/Kiev', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Lisbon', + 'Europe/Lisbon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Ljubljana', + 'Europe/Ljubljana', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/London', + 'Europe/London', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Luxembourg', + 'Europe/Luxembourg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Madrid', + 'Europe/Madrid', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Malta', + 'Europe/Malta', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Mariehamn', + 'Europe/Mariehamn', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Minsk', + 'Europe/Minsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Monaco', + 'Europe/Monaco', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Moscow', + 'Europe/Moscow', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Oslo', + 'Europe/Oslo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Paris', + 'Europe/Paris', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Podgorica', + 'Europe/Podgorica', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Prague', + 'Europe/Prague', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Riga', + 'Europe/Riga', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Rome', + 'Europe/Rome', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Samara', + 'Europe/Samara', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/San_Marino', + 'Europe/San_Marino', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Sarajevo', + 'Europe/Sarajevo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Simferopol', + 'Europe/Simferopol', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Skopje', + 'Europe/Skopje', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Sofia', + 'Europe/Sofia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Stockholm', + 'Europe/Stockholm', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Tallinn', + 'Europe/Tallinn', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Tirane', + 'Europe/Tirane', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Uzhgorod', + 'Europe/Uzhgorod', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Vaduz', + 'Europe/Vaduz', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Vatican', + 'Europe/Vatican', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Vienna', + 'Europe/Vienna', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Vilnius', + 'Europe/Vilnius', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Volgograd', + 'Europe/Volgograd', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Warsaw', + 'Europe/Warsaw', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Zagreb', + 'Europe/Zagreb', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Zaporozhye', + 'Europe/Zaporozhye', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Zurich', + 'Europe/Zurich', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Antananarivo', + 'Indian/Antananarivo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Chagos', + 'Indian/Chagos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Christmas', + 'Indian/Christmas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Cocos', + 'Indian/Cocos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Comoro', + 'Indian/Comoro', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Kerguelen', + 'Indian/Kerguelen', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Mahe', + 'Indian/Mahe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Maldives', + 'Indian/Maldives', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Mauritius', + 'Indian/Mauritius', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Mayotte', + 'Indian/Mayotte', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Reunion', + 'Indian/Reunion', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Apia', + 'Pacific/Apia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Auckland', + 'Pacific/Auckland', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Chatham', + 'Pacific/Chatham', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Chuuk', + 'Pacific/Chuuk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Easter', + 'Pacific/Easter', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Efate', + 'Pacific/Efate', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Enderbury', + 'Pacific/Enderbury', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Fakaofo', + 'Pacific/Fakaofo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Fiji', + 'Pacific/Fiji', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Funafuti', + 'Pacific/Funafuti', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Galapagos', + 'Pacific/Galapagos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Gambier', + 'Pacific/Gambier', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Guadalcanal', + 'Pacific/Guadalcanal', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Guam', + 'Pacific/Guam', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Honolulu', + 'Pacific/Honolulu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Johnston', + 'Pacific/Johnston', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Kiritimati', + 'Pacific/Kiritimati', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Kosrae', + 'Pacific/Kosrae', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Kwajalein', + 'Pacific/Kwajalein', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Majuro', + 'Pacific/Majuro', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Marquesas', + 'Pacific/Marquesas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Midway', + 'Pacific/Midway', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Nauru', + 'Pacific/Nauru', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Niue', + 'Pacific/Niue', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Norfolk', + 'Pacific/Norfolk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Noumea', + 'Pacific/Noumea', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Pago_Pago', + 'Pacific/Pago_Pago', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Palau', + 'Pacific/Palau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Pitcairn', + 'Pacific/Pitcairn', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Pohnpei', + 'Pacific/Pohnpei', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Port_Moresby', + 'Pacific/Port_Moresby', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Rarotonga', + 'Pacific/Rarotonga', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Saipan', + 'Pacific/Saipan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Tahiti', + 'Pacific/Tahiti', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Tarawa', + 'Pacific/Tarawa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Tongatapu', + 'Pacific/Tongatapu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Wake', + 'Pacific/Wake', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Wallis', + 'Pacific/Wallis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); commit; diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/003-rhnKickstartTimezome.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/003-rhnKickstartTimezome.sql new file mode 100644 index 0000000..1dd84cf --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/003-rhnKickstartTimezome.sql @@ -0,0 +1,2905 @@ +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Abidjan', + 'Africa/Abidjan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Accra', + 'Africa/Accra', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Addis_Ababa', + 'Africa/Addis_Ababa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Algiers', + 'Africa/Algiers', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Asmara', + 'Africa/Asmara', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Bamako', + 'Africa/Bamako', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Bangui', + 'Africa/Bangui', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Banjul', + 'Africa/Banjul', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Bissau', + 'Africa/Bissau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Blantyre', + 'Africa/Blantyre', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Brazzaville', + 'Africa/Brazzaville', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Bujumbura', + 'Africa/Bujumbura', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Cairo', + 'Africa/Cairo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Casablanca', + 'Africa/Casablanca', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Ceuta', + 'Africa/Ceuta', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Conakry', + 'Africa/Conakry', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Dakar', + 'Africa/Dakar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Dar_es_Salaam', + 'Africa/Dar_es_Salaam', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Djibouti', + 'Africa/Djibouti', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Douala', + 'Africa/Douala', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/El_Aaiun', + 'Africa/El_Aaiun', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Freetown', + 'Africa/Freetown', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Gaborone', + 'Africa/Gaborone', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Harare', + 'Africa/Harare', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Johannesburg', + 'Africa/Johannesburg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Juba', + 'Africa/Juba', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Kampala', + 'Africa/Kampala', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Khartoum', + 'Africa/Khartoum', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Kigali', + 'Africa/Kigali', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Kinshasa', + 'Africa/Kinshasa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Lagos', + 'Africa/Lagos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Libreville', + 'Africa/Libreville', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Lome', + 'Africa/Lome', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Luanda', + 'Africa/Luanda', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Lubumbashi', + 'Africa/Lubumbashi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Lusaka', + 'Africa/Lusaka', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Malabo', + 'Africa/Malabo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Maputo', + 'Africa/Maputo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Maseru', + 'Africa/Maseru', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Mbabane', + 'Africa/Mbabane', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Mogadishu', + 'Africa/Mogadishu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Monrovia', + 'Africa/Monrovia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Nairobi', + 'Africa/Nairobi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Ndjamena', + 'Africa/Ndjamena', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Niamey', + 'Africa/Niamey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Nouakchott', + 'Africa/Nouakchott', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Ouagadougou', + 'Africa/Ouagadougou', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Porto-Novo', + 'Africa/Porto-Novo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Sao_Tome', + 'Africa/Sao_Tome', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Tripoli', + 'Africa/Tripoli', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Tunis', + 'Africa/Tunis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Africa/Windhoek', + 'Africa/Windhoek', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Adak', + 'America/Adak', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Anchorage', + 'America/Anchorage', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Anguilla', + 'America/Anguilla', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Antigua', + 'America/Antigua', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Araguaina', + 'America/Araguaina', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Buenos_Aires', + 'America/Argentina/Buenos_Aires', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Catamarca', + 'America/Argentina/Catamarca', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Cordoba', + 'America/Argentina/Cordoba', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Jujuy', + 'America/Argentina/Jujuy', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/La_Rioja', + 'America/Argentina/La_Rioja', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Mendoza', + 'America/Argentina/Mendoza', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Rio_Gallegos', + 'America/Argentina/Rio_Gallegos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Salta', + 'America/Argentina/Salta', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/San_Juan', + 'America/Argentina/San_Juan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/San_Luis', + 'America/Argentina/San_Luis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Tucuman', + 'America/Argentina/Tucuman', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Argentina/Ushuaia', + 'America/Argentina/Ushuaia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Aruba', + 'America/Aruba', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Asuncion', + 'America/Asuncion', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Atikokan', + 'America/Atikokan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Bahia', + 'America/Bahia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Bahia_Banderas', + 'America/Bahia_Banderas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Barbados', + 'America/Barbados', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Belem', + 'America/Belem', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Belize', + 'America/Belize', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Blanc-Sablon', + 'America/Blanc-Sablon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Boa_Vista', + 'America/Boa_Vista', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Bogota', + 'America/Bogota', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Boise', + 'America/Boise', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cambridge_Bay', + 'America/Cambridge_Bay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Campo_Grande', + 'America/Campo_Grande', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cancun', + 'America/Cancun', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Caracas', + 'America/Caracas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cayenne', + 'America/Cayenne', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cayman', + 'America/Cayman', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Chicago', + 'America/Chicago', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Chihuahua', + 'America/Chihuahua', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Costa_Rica', + 'America/Costa_Rica', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Creston', + 'America/Creston', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Cuiaba', + 'America/Cuiaba', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Curacao', + 'America/Curacao', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Danmarkshavn', + 'America/Danmarkshavn', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Dawson', + 'America/Dawson', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Dawson_Creek', + 'America/Dawson_Creek', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Denver', + 'America/Denver', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Detroit', + 'America/Detroit', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Dominica', + 'America/Dominica', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Edmonton', + 'America/Edmonton', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Eirunepe', + 'America/Eirunepe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/El_Salvador', + 'America/El_Salvador', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Fortaleza', + 'America/Fortaleza', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Glace_Bay', + 'America/Glace_Bay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Godthab', + 'America/Godthab', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Goose_Bay', + 'America/Goose_Bay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Grand_Turk', + 'America/Grand_Turk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Grenada', + 'America/Grenada', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Guadeloupe', + 'America/Guadeloupe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Guatemala', + 'America/Guatemala', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Guayaquil', + 'America/Guayaquil', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Guyana', + 'America/Guyana', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Halifax', + 'America/Halifax', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Havana', + 'America/Havana', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Hermosillo', + 'America/Hermosillo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Indianapolis', + 'America/Indiana/Indianapolis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Knox', + 'America/Indiana/Knox', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Marengo', + 'America/Indiana/Marengo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Petersburg', + 'America/Indiana/Petersburg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Tell_City', + 'America/Indiana/Tell_City', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Vevay', + 'America/Indiana/Vevay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Vincennes', + 'America/Indiana/Vincennes', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Indiana/Winamac', + 'America/Indiana/Winamac', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Inuvik', + 'America/Inuvik', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Iqaluit', + 'America/Iqaluit', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Jamaica', + 'America/Jamaica', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Juneau', + 'America/Juneau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Kentucky/Louisville', + 'America/Kentucky/Louisville', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Kentucky/Monticello', + 'America/Kentucky/Monticello', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Kralendijk', + 'America/Kralendijk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/La_Paz', + 'America/La_Paz', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Lima', + 'America/Lima', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Los_Angeles', + 'America/Los_Angeles', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Lower_Princes', + 'America/Lower_Princes', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Maceio', + 'America/Maceio', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Managua', + 'America/Managua', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Manaus', + 'America/Manaus', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Marigot', + 'America/Marigot', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Martinique', + 'America/Martinique', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Matamoros', + 'America/Matamoros', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Mazatlan', + 'America/Mazatlan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Menominee', + 'America/Menominee', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Merida', + 'America/Merida', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Metlakatla', + 'America/Metlakatla', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Mexico_City', + 'America/Mexico_City', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Miquelon', + 'America/Miquelon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Moncton', + 'America/Moncton', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Monterrey', + 'America/Monterrey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Montevideo', + 'America/Montevideo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Montreal', + 'America/Montreal', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Montserrat', + 'America/Montserrat', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Nassau', + 'America/Nassau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/New_York', + 'America/New_York', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Nipigon', + 'America/Nipigon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Nome', + 'America/Nome', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Noronha', + 'America/Noronha', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/North_Dakota/Beulah', + 'America/North_Dakota/Beulah', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/North_Dakota/Center', + 'America/North_Dakota/Center', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/North_Dakota/New_Salem', + 'America/North_Dakota/New_Salem', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Ojinaga', + 'America/Ojinaga', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Panama', + 'America/Panama', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Pangnirtung', + 'America/Pangnirtung', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Paramaribo', + 'America/Paramaribo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Phoenix', + 'America/Phoenix', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Port_of_Spain', + 'America/Port_of_Spain', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Port-au-Prince', + 'America/Port-au-Prince', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Porto_Velho', + 'America/Porto_Velho', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Puerto_Rico', + 'America/Puerto_Rico', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Rainy_River', + 'America/Rainy_River', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Rankin_Inlet', + 'America/Rankin_Inlet', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Recife', + 'America/Recife', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Regina', + 'America/Regina', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Resolute', + 'America/Resolute', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Rio_Branco', + 'America/Rio_Branco', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Santa_Isabel', + 'America/Santa_Isabel', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Santarem', + 'America/Santarem', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Santiago', + 'America/Santiago', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Santo_Domingo', + 'America/Santo_Domingo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Sao_Paulo', + 'America/Sao_Paulo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Scoresbysund', + 'America/Scoresbysund', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Shiprock', + 'America/Shiprock', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Sitka', + 'America/Sitka', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Barthelemy', + 'America/St_Barthelemy', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Johns', + 'America/St_Johns', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Kitts', + 'America/St_Kitts', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Lucia', + 'America/St_Lucia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Thomas', + 'America/St_Thomas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/St_Vincent', + 'America/St_Vincent', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Swift_Current', + 'America/Swift_Current', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Tegucigalpa', + 'America/Tegucigalpa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Thule', + 'America/Thule', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Thunder_Bay', + 'America/Thunder_Bay', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Tijuana', + 'America/Tijuana', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Toronto', + 'America/Toronto', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Tortola', + 'America/Tortola', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Vancouver', + 'America/Vancouver', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Whitehorse', + 'America/Whitehorse', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Winnipeg', + 'America/Winnipeg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Yakutat', + 'America/Yakutat', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'America/Yellowknife', + 'America/Yellowknife', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Casey', + 'Antarctica/Casey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Davis', + 'Antarctica/Davis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/DumontDUrville', + 'Antarctica/DumontDUrville', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Macquarie', + 'Antarctica/Macquarie', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Mawson', + 'Antarctica/Mawson', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/McMurdo', + 'Antarctica/McMurdo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Palmer', + 'Antarctica/Palmer', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Rothera', + 'Antarctica/Rothera', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/South_Pole', + 'Antarctica/South_Pole', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Syowa', + 'Antarctica/Syowa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Antarctica/Vostok', + 'Antarctica/Vostok', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Arctic/Longyearbyen', + 'Arctic/Longyearbyen', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Aden', + 'Asia/Aden', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Almaty', + 'Asia/Almaty', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Amman', + 'Asia/Amman', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Anadyr', + 'Asia/Anadyr', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Aqtau', + 'Asia/Aqtau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Aqtobe', + 'Asia/Aqtobe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Ashgabat', + 'Asia/Ashgabat', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Baghdad', + 'Asia/Baghdad', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Bahrain', + 'Asia/Bahrain', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Baku', + 'Asia/Baku', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Bangkok', + 'Asia/Bangkok', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Beirut', + 'Asia/Beirut', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Bishkek', + 'Asia/Bishkek', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Brunei', + 'Asia/Brunei', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Choibalsan', + 'Asia/Choibalsan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Chongqing', + 'Asia/Chongqing', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Colombo', + 'Asia/Colombo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Damascus', + 'Asia/Damascus', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Dhaka', + 'Asia/Dhaka', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Dili', + 'Asia/Dili', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Dubai', + 'Asia/Dubai', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Dushanbe', + 'Asia/Dushanbe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Gaza', + 'Asia/Gaza', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Harbin', + 'Asia/Harbin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Hebron', + 'Asia/Hebron', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Ho_Chi_Minh', + 'Asia/Ho_Chi_Minh', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Hong_Kong', + 'Asia/Hong_Kong', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Hovd', + 'Asia/Hovd', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Irkutsk', + 'Asia/Irkutsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Jakarta', + 'Asia/Jakarta', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Jayapura', + 'Asia/Jayapura', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Jerusalem', + 'Asia/Jerusalem', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kabul', + 'Asia/Kabul', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kamchatka', + 'Asia/Kamchatka', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Karachi', + 'Asia/Karachi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kashgar', + 'Asia/Kashgar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kathmandu', + 'Asia/Kathmandu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kolkata', + 'Asia/Kolkata', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Krasnoyarsk', + 'Asia/Krasnoyarsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kuala_Lumpur', + 'Asia/Kuala_Lumpur', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kuching', + 'Asia/Kuching', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Kuwait', + 'Asia/Kuwait', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Macau', + 'Asia/Macau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Magadan', + 'Asia/Magadan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Makassar', + 'Asia/Makassar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Manila', + 'Asia/Manila', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Muscat', + 'Asia/Muscat', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Nicosia', + 'Asia/Nicosia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Novokuznetsk', + 'Asia/Novokuznetsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Novosibirsk', + 'Asia/Novosibirsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Omsk', + 'Asia/Omsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Oral', + 'Asia/Oral', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Phnom_Penh', + 'Asia/Phnom_Penh', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Pontianak', + 'Asia/Pontianak', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Pyongyang', + 'Asia/Pyongyang', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Qatar', + 'Asia/Qatar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Qyzylorda', + 'Asia/Qyzylorda', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Rangoon', + 'Asia/Rangoon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Riyadh', + 'Asia/Riyadh', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Sakhalin', + 'Asia/Sakhalin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Samarkand', + 'Asia/Samarkand', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Seoul', + 'Asia/Seoul', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Shanghai', + 'Asia/Shanghai', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Singapore', + 'Asia/Singapore', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Taipei', + 'Asia/Taipei', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Tashkent', + 'Asia/Tashkent', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Tbilisi', + 'Asia/Tbilisi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Tehran', + 'Asia/Tehran', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Thimphu', + 'Asia/Thimphu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Tokyo', + 'Asia/Tokyo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Ulaanbaatar', + 'Asia/Ulaanbaatar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Urumqi', + 'Asia/Urumqi', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Vientiane', + 'Asia/Vientiane', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Vladivostok', + 'Asia/Vladivostok', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Yakutsk', + 'Asia/Yakutsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Yekaterinburg', + 'Asia/Yekaterinburg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Asia/Yerevan', + 'Asia/Yerevan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Azores', + 'Atlantic/Azores', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Bermuda', + 'Atlantic/Bermuda', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Canary', + 'Atlantic/Canary', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Cape_Verde', + 'Atlantic/Cape_Verde', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Faroe', + 'Atlantic/Faroe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Madeira', + 'Atlantic/Madeira', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Reykjavik', + 'Atlantic/Reykjavik', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/South_Georgia', + 'Atlantic/South_Georgia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/St_Helena', + 'Atlantic/St_Helena', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Atlantic/Stanley', + 'Atlantic/Stanley', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Adelaide', + 'Australia/Adelaide', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Brisbane', + 'Australia/Brisbane', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Broken_Hill', + 'Australia/Broken_Hill', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Currie', + 'Australia/Currie', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Darwin', + 'Australia/Darwin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Eucla', + 'Australia/Eucla', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Hobart', + 'Australia/Hobart', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Lindeman', + 'Australia/Lindeman', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Lord_Howe', + 'Australia/Lord_Howe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Melbourne', + 'Australia/Melbourne', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Perth', + 'Australia/Perth', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Australia/Sydney', + 'Australia/Sydney', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Amsterdam', + 'Europe/Amsterdam', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Andorra', + 'Europe/Andorra', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Athens', + 'Europe/Athens', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Belgrade', + 'Europe/Belgrade', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Berlin', + 'Europe/Berlin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Bratislava', + 'Europe/Bratislava', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Brussels', + 'Europe/Brussels', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Bucharest', + 'Europe/Bucharest', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Budapest', + 'Europe/Budapest', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Chisinau', + 'Europe/Chisinau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Copenhagen', + 'Europe/Copenhagen', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Dublin', + 'Europe/Dublin', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Gibraltar', + 'Europe/Gibraltar', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Guernsey', + 'Europe/Guernsey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Helsinki', + 'Europe/Helsinki', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Isle_of_Man', + 'Europe/Isle_of_Man', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Istanbul', + 'Europe/Istanbul', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Jersey', + 'Europe/Jersey', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Kaliningrad', + 'Europe/Kaliningrad', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Kiev', + 'Europe/Kiev', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Lisbon', + 'Europe/Lisbon', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Ljubljana', + 'Europe/Ljubljana', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/London', + 'Europe/London', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Luxembourg', + 'Europe/Luxembourg', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Madrid', + 'Europe/Madrid', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Malta', + 'Europe/Malta', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Mariehamn', + 'Europe/Mariehamn', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Minsk', + 'Europe/Minsk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Monaco', + 'Europe/Monaco', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Moscow', + 'Europe/Moscow', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Oslo', + 'Europe/Oslo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Paris', + 'Europe/Paris', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Podgorica', + 'Europe/Podgorica', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Prague', + 'Europe/Prague', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Riga', + 'Europe/Riga', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Rome', + 'Europe/Rome', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Samara', + 'Europe/Samara', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/San_Marino', + 'Europe/San_Marino', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Sarajevo', + 'Europe/Sarajevo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Simferopol', + 'Europe/Simferopol', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Skopje', + 'Europe/Skopje', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Sofia', + 'Europe/Sofia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Stockholm', + 'Europe/Stockholm', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Tallinn', + 'Europe/Tallinn', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Tirane', + 'Europe/Tirane', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Uzhgorod', + 'Europe/Uzhgorod', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Vaduz', + 'Europe/Vaduz', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Vatican', + 'Europe/Vatican', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Vienna', + 'Europe/Vienna', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Vilnius', + 'Europe/Vilnius', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Volgograd', + 'Europe/Volgograd', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Warsaw', + 'Europe/Warsaw', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Zagreb', + 'Europe/Zagreb', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Zaporozhye', + 'Europe/Zaporozhye', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Europe/Zurich', + 'Europe/Zurich', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Antananarivo', + 'Indian/Antananarivo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Chagos', + 'Indian/Chagos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Christmas', + 'Indian/Christmas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Cocos', + 'Indian/Cocos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Comoro', + 'Indian/Comoro', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Kerguelen', + 'Indian/Kerguelen', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Mahe', + 'Indian/Mahe', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Maldives', + 'Indian/Maldives', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Mauritius', + 'Indian/Mauritius', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Mayotte', + 'Indian/Mayotte', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Indian/Reunion', + 'Indian/Reunion', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Apia', + 'Pacific/Apia', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Auckland', + 'Pacific/Auckland', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Chatham', + 'Pacific/Chatham', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Chuuk', + 'Pacific/Chuuk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Easter', + 'Pacific/Easter', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Efate', + 'Pacific/Efate', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Enderbury', + 'Pacific/Enderbury', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Fakaofo', + 'Pacific/Fakaofo', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Fiji', + 'Pacific/Fiji', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Funafuti', + 'Pacific/Funafuti', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Galapagos', + 'Pacific/Galapagos', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Gambier', + 'Pacific/Gambier', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Guadalcanal', + 'Pacific/Guadalcanal', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Guam', + 'Pacific/Guam', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Honolulu', + 'Pacific/Honolulu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Johnston', + 'Pacific/Johnston', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Kiritimati', + 'Pacific/Kiritimati', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Kosrae', + 'Pacific/Kosrae', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Kwajalein', + 'Pacific/Kwajalein', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Majuro', + 'Pacific/Majuro', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Marquesas', + 'Pacific/Marquesas', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Midway', + 'Pacific/Midway', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Nauru', + 'Pacific/Nauru', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Niue', + 'Pacific/Niue', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Norfolk', + 'Pacific/Norfolk', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Noumea', + 'Pacific/Noumea', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Pago_Pago', + 'Pacific/Pago_Pago', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Palau', + 'Pacific/Palau', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Pitcairn', + 'Pacific/Pitcairn', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Pohnpei', + 'Pacific/Pohnpei', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Port_Moresby', + 'Pacific/Port_Moresby', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Rarotonga', + 'Pacific/Rarotonga', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Saipan', + 'Pacific/Saipan', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Tahiti', + 'Pacific/Tahiti', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Tarawa', + 'Pacific/Tarawa', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Tongatapu', + 'Pacific/Tongatapu', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Wake', + 'Pacific/Wake', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); + +insert into rhnKickstartTimezone (id, label, name, install_type) + values (sequence_nextval('rhn_ks_timezone_id_seq'), + 'Pacific/Wallis', + 'Pacific/Wallis', + (SELECT IT.id FROM rhnKSInstallType IT WHERE IT.label = 'rhel_7') + ); +

11 years, 5 months

1
0
0 / 0

schema/spacewalk

by Milan Zazrivec

schema/spacewalk/common/data/rhnKSInstallType.sql | 5 +++++ schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/002-rhnKSInstallType.sql | 4 ++++ 2 files changed, 9 insertions(+) New commits: commit 0dfb43b9ee1f2ed6d432b5baea15bf3c1983360c Author: Milan Zazrivec <mzazrivec(a)redhat.com> Date: Wed Nov 28 13:23:23 2012 +0100 New installation type: RHEL 7 diff --git a/schema/spacewalk/common/data/rhnKSInstallType.sql b/schema/spacewalk/common/data/rhnKSInstallType.sql index cdef5d7..57ca3e7 100644 --- a/schema/spacewalk/common/data/rhnKSInstallType.sql +++ b/schema/spacewalk/common/data/rhnKSInstallType.sql @@ -14,6 +14,11 @@ -- insert into rhnKSInstallType (id, label, name) values (sequence_nextval('rhn_ksinstalltype_id_seq'), + 'rhel_7','Red Hat Enterprise Linux 7' + ); + +insert into rhnKSInstallType (id, label, name) + values (sequence_nextval('rhn_ksinstalltype_id_seq'), 'rhel_6','Red Hat Enterprise Linux 6' ); diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/002-rhnKSInstallType.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/002-rhnKSInstallType.sql new file mode 100644 index 0000000..31392c4 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/002-rhnKSInstallType.sql @@ -0,0 +1,4 @@ +insert into rhnKSInstallType (id, label, name) + values (sequence_nextval('rhn_ksinstalltype_id_seq'), + 'rhel_7','Red Hat Enterprise Linux 7' + );

11 years, 5 months

1
0
0 / 0

java/code

by Milan Zazrivec

java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_en_US.xml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 025df6d4b1374fbb427c437d01ca7addff42031f Author: Milan Zazrivec <mzazrivec(a)redhat.com> Date: Wed Nov 28 11:17:52 2012 +0100 typo fix diff --git a/java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_en_US.xml b/java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_en_US.xml index 846dce9..7ac0c31 100644 --- a/java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_en_US.xml +++ b/java/code/src/com/redhat/rhn/frontend/strings/jsp/StringResource_en_US.xml @@ -15182,7 +15182,7 @@ the <a href="/rhn/kickstart/ActivationKeysList.do?ksid={0}">Activation Key </context-group> </trans-unit> <trans-unit id="treecreate.jsp.header1"> - <source>The following details are needed to define a kickstartable distribution. The tree path field should be a valid path to a installation tree located on this @@PRODUCT_NAME@@ server. The Kickstart RPM should be the name of the rpm containing the kickstart deploy scripts. These RPMs are provided by @@PRODUCT_NAME@@ and located in the @@PRODUCT_NAME@@ Tools child channels. + <source>The following details are needed to define a kickstartable distribution. The tree path field should be a valid path to an installation tree located on this @@PRODUCT_NAME@@ server. The Kickstart RPM should be the name of the rpm containing the kickstart deploy scripts. These RPMs are provided by @@PRODUCT_NAME@@ and located in the @@PRODUCT_NAME@@ Tools child channels. The Distribution Label field should contain only letters, numbers, hyphens, periods, and underscores. It must also be at least 4 characters long.

11 years, 5 months

1
0
0 / 0

java/code

by Tomas Lestach

java/code/src/com/redhat/rhn/frontend/action/channel/manage/DeleteChannelAction.java | 32 +++++++++- java/code/src/com/redhat/rhn/frontend/action/rhnpackage/CustomPackageListAction.java | 7 +- java/code/webapp/WEB-INF/struts-config.xml | 1 3 files changed, 36 insertions(+), 4 deletions(-) New commits: commit 731a4a32b8acf9da74fb47797be67967a0e165ba Author: Tomas Lestach <tlestach(a)redhat.com> Date: Tue Nov 27 15:00:52 2012 +0100 519472 - suggest deleting custom packages after a channel is deleted diff --git a/java/code/src/com/redhat/rhn/frontend/action/channel/manage/DeleteChannelAction.java b/java/code/src/com/redhat/rhn/frontend/action/channel/manage/DeleteChannelAction.java index 587f834..c193f35 100644 --- a/java/code/src/com/redhat/rhn/frontend/action/channel/manage/DeleteChannelAction.java +++ b/java/code/src/com/redhat/rhn/frontend/action/channel/manage/DeleteChannelAction.java @@ -14,20 +14,30 @@ */ package com.redhat.rhn.frontend.action.channel.manage; +import com.redhat.rhn.common.db.datasource.DataResult; import com.redhat.rhn.common.security.PermissionException; import com.redhat.rhn.common.validator.ValidatorException; +import com.redhat.rhn.domain.Identifiable; import com.redhat.rhn.domain.channel.Channel; +import com.redhat.rhn.domain.rhnset.RhnSet; +import com.redhat.rhn.domain.rhnset.RhnSetFactory; import com.redhat.rhn.domain.user.User; import com.redhat.rhn.frontend.struts.RequestContext; import com.redhat.rhn.frontend.struts.RhnAction; import com.redhat.rhn.frontend.struts.RhnHelper; import com.redhat.rhn.manager.channel.ChannelManager; +import com.redhat.rhn.manager.rhnpackage.PackageManager; +import com.redhat.rhn.manager.rhnset.RhnSetDecl; import com.redhat.rhn.manager.system.SystemManager; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; +import java.util.HashMap; +import java.util.Iterator; +import java.util.Map; + import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; @@ -74,8 +84,10 @@ public class DeleteChannelAction extends RhnAction { boolean override = request.getParameter("unsubscribeSystems") != null; if (override || subscribedSystemsCount == 0) { - + DataResult dr; try { + dr = PackageManager.listCustomPackageForChannel(channelId, + user.getOrg().getId()); ChannelManager.deleteChannel(user, channelLabel); } catch (PermissionException e) { @@ -89,6 +101,15 @@ public class DeleteChannelAction extends RhnAction { } createSuccessMessage(request, "message.channeldeleted", channel.getName()); + if (dr.size() > 0) { + prefillRhnSetWithElements(RhnSetDecl.DELETABLE_PACKAGE_LIST.get(user), + dr.iterator()); + Map params = new HashMap(); + params.put("selected_channel", "all_managed_packages"); + params.put("forwarded", "true"); + return getStrutsDelegate().forwardParams(actionMapping.findForward("delete"), + params); + } return actionMapping.findForward("success"); } addMessage(request, "message.channel.delete.systemssubscribed"); @@ -102,4 +123,13 @@ public class DeleteChannelAction extends RhnAction { return actionMapping.findForward(RhnHelper.DEFAULT_FORWARD); } + + private void prefillRhnSetWithElements(RhnSet set, Iterator identifiables) { + set.clear(); + while (identifiables.hasNext()) { + Identifiable tkn = (Identifiable) identifiables.next(); + set.addElement(tkn.getId()); + } + RhnSetFactory.save(set); + } } diff --git a/java/code/src/com/redhat/rhn/frontend/action/rhnpackage/CustomPackageListAction.java b/java/code/src/com/redhat/rhn/frontend/action/rhnpackage/CustomPackageListAction.java index 523fca3..063cfb4 100644 --- a/java/code/src/com/redhat/rhn/frontend/action/rhnpackage/CustomPackageListAction.java +++ b/java/code/src/com/redhat/rhn/frontend/action/rhnpackage/CustomPackageListAction.java @@ -136,12 +136,13 @@ public class CustomPackageListAction extends RhnAction { //true if they clicked view packages boolean viewPackagesPressed = LocalizationService.getInstance().getMessage( "channel.jsp.package.viewpackages").equals(request.getParameter("view")); - + boolean forwarded = request.getParameter("forwarded") != null; String alphaBarPressed = request.getParameter( AlphaBarHelper.makeAlphaKey(TagHelper.generateUniqueName(listName))); - if (!requestContext.isSubmitted() && alphaBarPressed == null || - viewPackagesPressed) { + if (!forwarded && + (!requestContext.isSubmitted() && alphaBarPressed == null || + viewPackagesPressed)) { set.clear(); RhnSetManager.store(set); } diff --git a/java/code/webapp/WEB-INF/struts-config.xml b/java/code/webapp/WEB-INF/struts-config.xml index 00ffc82..0b44ba8 100644 --- a/java/code/webapp/WEB-INF/struts-config.xml +++ b/java/code/webapp/WEB-INF/struts-config.xml @@ -7374,6 +7374,7 @@ className="com.redhat.rhn.frontend.struts.RhnActionMapping"> <set-property property="postRequiredIfSubmitted" value="true" /> <forward name="default" path="/WEB-INF/pages/channel/manage/delete.jsp"/> + <forward name="delete" path="/software/manage/packages/PackageList.do" redirect="true" /> <forward name="success" path="/channels/manage/Manage.do" redirect="true" /> </action>

11 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

spacewalk-commits November 2012