Hey, we found that the GMT+0300 timezone was missing in the Locale Preferences so here is a patch adding it as "Saudi Arabia".
Best regards, Johannes -- SUSE LINUX Products GmbH, HRB 16746 (AG Nürnberg) GF: Jeff Hawn, Jennifer Guild, Felix Imendörffer
>From 6d3be8faa7754e7151c57c07827eda8543c7a83e Mon Sep 17 00:00:00 2001 From: Johannes Renner <jren...@suse.de> Date: Wed, 12 Feb 2014 09:42:05 +0100 Subject: [PATCH] Add missing GMT+3 timezone as Saudi Arabia --- .../rhn/frontend/strings/database/StringResource_en_US.xml | 6 ++++++ schema/spacewalk/common/data/rhnTimezone.sql | 6 ++++++ .../050-rhnTimezone-data.sql | 13 +++++++++++++ 3 files changed, 25 insertions(+) create mode 100644 schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/050-rhnTimezone-data.sql diff --git a/java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml b/java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml index 0312614..e7f3437 100644 --- a/java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml +++ b/java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml @@ -326,6 +326,12 @@ <context context-type="sourcefile">/rhn/account/UserDetails</context> </context-group> </trans-unit> + <trans-unit id="Asia/Riyadh"> + <source>(GMT+0300) Saudi Arabia</source> + <context-group name="ctx"> + <context context-type="sourcefile">/rhn/account/UserDetails</context> + </context-group> + </trans-unit> <trans-unit id="Asia/Tehran"> <source>(GMT+0330) Iran</source> <context-group name="ctx"> diff --git a/schema/spacewalk/common/data/rhnTimezone.sql b/schema/spacewalk/common/data/rhnTimezone.sql index 2a70465..84b6fce 100644 --- a/schema/spacewalk/common/data/rhnTimezone.sql +++ b/schema/spacewalk/common/data/rhnTimezone.sql @@ -224,6 +224,12 @@ insert into rhnTimezone (id, olson_name, display_name) values (sequence_nextval('rhn_timezone_id_seq'), + 'Asia/Riyadh', 'Saudi Arabia'); + +insert into rhnTimezone + (id, olson_name, display_name) +values + (sequence_nextval('rhn_timezone_id_seq'), 'Asia/Tehran', 'Iran'); insert into rhnTimezone diff --git a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/050-rhnTimezone-data.sql b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/050-rhnTimezone-data.sql new file mode 100644 index 0000000..a3ab1e5 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/050-rhnTimezone-data.sql @@ -0,0 +1,13 @@ +insert into rhnTimezone (id, olson_name, display_name) ( + select sequence_nextval('rhn_timezone_id_seq'), + 'Asia/Riyadh', + 'Saudi Arabia' + from dual + where not exists ( + select 1 + from rhnTimezone + where olson_name = 'Asia/Riyadh' + and display_name = 'Saudi Arabia' + ) +); + -- 1.8.4.5
_______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel