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
