java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml | 6 +++++
schema/spacewalk/common/data/rhnTimezone.sql | 6 +++++
schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/050-rhnTimezone-data.sql | 12 ++++++++++
3 files changed, 24 insertions(+)
New commits:
commit 5c264e4331e6e2b72921f84eeb699c2f40969e2c
Author: Johannes Renner <jrenner(a)suse.de>
Date: Wed Feb 12 10:39:07 2014 +0100
Add missing GMT+3 timezone as Saudi Arabia
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..117806a
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/050-rhnTimezone-data.sql
@@ -0,0 +1,12 @@
+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'
+ )
+);