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

Reply via email to