client/rhel
by Michael Mraka
client/rhel/yum-rhn-plugin/rhnplugin.py | 46 ++++++++++++++++----------------
1 file changed, 24 insertions(+), 22 deletions(-)
New commits:
commit e429437bd77eda75a76a3a52f72d744b54c30c37
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon Sep 5 10:27:10 2011 +0200
734492, 734965, 735282 - check command line options only for yum
diff --git a/client/rhel/yum-rhn-plugin/rhnplugin.py b/client/rhel/yum-rhn-plugin/rhnplugin.py
index d933de7..b38849c 100644
--- a/client/rhel/yum-rhn-plugin/rhnplugin.py
+++ b/client/rhel/yum-rhn-plugin/rhnplugin.py
@@ -86,28 +86,30 @@ def init_hook(conduit):
return
# check commands and options which don't need network communication
- cmd_args = sys.argv[1:]
- if ('--help' in cmd_args
- or '--version' in cmd_args
- or cmd_args == []):
- rhn_enabled = False
- conduit.info(10, _("Either --version, --help or no commands entered") +
- "\n" + RHN_DISABLED)
- return
- if 'clean' in cmd_args:
- addCachedRepos(conduit)
- conduit.info(10, _("Cleaning") + "\n" + RHN_DISABLED)
- # cleanup cached login info
- if os.path.exists(pcklAuthFileName):
- os.unlink(pcklAuthFileName)
- return
- if ('-C' in cmd_args
- or '--cacheonly' in cmd_args):
- rhn_enabled = False
- addCachedRepos(conduit)
- conduit.info(10, _("Using list of RHN repos from cache") +
- "\n" + RHN_DISABLED)
- return
+ prog_name = os.path.basename(sys.argv[0])
+ if prog_name == 'yum':
+ cmd_args = sys.argv[1:]
+ if ('--help' in cmd_args
+ or '--version' in cmd_args
+ or cmd_args == []):
+ rhn_enabled = False
+ conduit.info(10, _("Either --version, --help or no commands entered") +
+ "\n" + RHN_DISABLED)
+ return
+ if 'clean' in cmd_args:
+ addCachedRepos(conduit)
+ conduit.info(10, _("Cleaning") + "\n" + RHN_DISABLED)
+ # cleanup cached login info
+ if os.path.exists(pcklAuthFileName):
+ os.unlink(pcklAuthFileName)
+ return
+ if ('-C' in cmd_args
+ or '--cacheonly' in cmd_args):
+ rhn_enabled = False
+ addCachedRepos(conduit)
+ conduit.info(10, _("Using list of RHN repos from cache") +
+ "\n" + RHN_DISABLED)
+ return
try:
login_info = up2dateAuth.getLoginInfo()
12 years, 7 months
Changes to 'refs/tags/spacewalk-java-1.6.38-1'
by Michael Mraka
Tag 'spacewalk-java-1.6.38-1' created by Michael Mraka <michael.mraka(a)redhat.com> at 2011-09-02 14:48 +0000
Tagging package [spacewalk-java] version [1.6.38-1] in directory [java/].
Changes since spacewalk-schema-1.6.12-1:
Michael Mraka (1):
Automatic commit of package [spacewalk-java] release [1.6.38-1].
---
java/spacewalk-java.spec | 7 ++++++-
rel-eng/packages/spacewalk-java | 2 +-
2 files changed, 7 insertions(+), 2 deletions(-)
---
12 years, 7 months
java/spacewalk-java.spec rel-eng/packages
by Michael Mraka
java/spacewalk-java.spec | 7 ++++++-
rel-eng/packages/spacewalk-java | 2 +-
2 files changed, 7 insertions(+), 2 deletions(-)
New commits:
commit 33e87e49a60a067e2b40909271aba71e8ecd0443
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Sep 2 16:48:30 2011 +0200
Automatic commit of package [spacewalk-java] release [1.6.38-1].
diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec
index b733fee..b856da3 100644
--- a/java/spacewalk-java.spec
+++ b/java/spacewalk-java.spec
@@ -17,7 +17,7 @@ Name: spacewalk-java
Summary: Spacewalk Java site packages
Group: Applications/Internet
License: GPLv2
-Version: 1.6.37
+Version: 1.6.38
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -547,6 +547,11 @@ fi
%{jardir}/postgresql-jdbc.jar
%changelog
+* Fri Sep 02 2011 Michael Mraka <michael.mraka(a)redhat.com> 1.6.38-1
+- fixed column alias syntax
+- suite_id is number not string
+- replaced alias with table name
+
* Fri Sep 02 2011 Miroslav Suchý 1.6.37-1
- show cname aliases in hw tab from config file (msuchy(a)redhat.com)
- Checkstyle fixes (mzazrivec(a)redhat.com)
diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java
index 8089b4e..92d40bc 100644
--- a/rel-eng/packages/spacewalk-java
+++ b/rel-eng/packages/spacewalk-java
@@ -1 +1 @@
-1.6.37-1 java/
+1.6.38-1 java/
12 years, 7 months
Changes to 'refs/tags/spacewalk-schema-1.6.12-1'
by Michael Mraka
Tag 'spacewalk-schema-1.6.12-1' created by Michael Mraka <michael.mraka(a)redhat.com> at 2011-09-02 14:48 +0000
Tagging package [spacewalk-schema] version [1.6.12-1] in directory [schema/spacewalk/].
Changes since spacewalk-java-1.6.37-1:
Michael Mraka (7):
replaced alias with table name
suite_id is number not string
fixed column alias syntax
don't translate NUMBER(X) to SMALLINT or FLOAT
upgrade script for FLOAT -> NUMERIC fix
upgrade scripts for SMALLINT -> NUMERIC
Automatic commit of package [spacewalk-schema] release [1.6.12-1].
---
java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml | 12 +++++----
java/code/src/com/redhat/rhn/common/security/acl/Access.java | 2 -
rel-eng/packages/spacewalk-schema | 2 -
schema/spacewalk/spacewalk-oracle2postgresql | 2 -
schema/spacewalk/spacewalk-schema.spec | 7 ++++-
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.postgresql | 13 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.postgresql | 10 +++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.postgresql | 9 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.postgresql | 12 +++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.postgresql | 8 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.postgresql | 8 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.postgresql | 7 +++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.postgresql | 9 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.postgresql | 10 +++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.postgresql | 9 ++++++
107 files changed, 289 insertions(+), 10 deletions(-)
---
12 years, 7 months
rel-eng/packages schema/spacewalk
by Michael Mraka
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 7 ++++++-
2 files changed, 7 insertions(+), 2 deletions(-)
New commits:
commit 9212868468639f905d7bde8b96d90e6325057b70
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Sep 2 16:48:02 2011 +0200
Automatic commit of package [spacewalk-schema] release [1.6.12-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 5292545..6c5ddb9 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.6.11-1 schema/spacewalk/
+1.6.12-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index c1fe438..42e3225 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -2,7 +2,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 1.6.11
+Version: 1.6.12
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -66,6 +66,11 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Fri Sep 02 2011 Michael Mraka <michael.mraka(a)redhat.com> 1.6.12-1
+- upgrade scripts for SMALLINT -> NUMERIC
+- upgrade script for FLOAT -> NUMERIC fix
+- don't translate NUMBER(X) to SMALLINT or FLOAT
+
* Wed Aug 31 2011 Michael Mraka <michael.mraka(a)redhat.com> 1.6.11-1
- removed obsoleted warning
- Fedora 15 needs explicit BuildRequires for python
12 years, 7 months
6 commits - java/code schema/spacewalk
by Michael Mraka
java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml | 12 +++++----
java/code/src/com/redhat/rhn/common/security/acl/Access.java | 2 -
schema/spacewalk/spacewalk-oracle2postgresql | 2 -
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.postgresql | 13 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.postgresql | 10 +++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.postgresql | 9 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.postgresql | 12 +++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.postgresql | 8 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.postgresql | 8 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.postgresql | 7 +++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.postgresql | 4 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.postgresql | 9 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.postgresql | 2 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.postgresql | 3 ++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.postgresql | 5 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.postgresql | 10 +++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.postgresql | 9 ++++++
105 files changed, 282 insertions(+), 8 deletions(-)
New commits:
commit e2adc81d36e6d4bcf4652c5ffdbf14b9ed88af60
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Sep 2 16:42:40 2011 +0200
upgrade scripts for SMALLINT -> NUMERIC
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..a7cdd71
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/030-rhnVirtualInstance.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhnVirtualInstance alter column confirmed type numeric(1);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..d3fb867
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/031-rhn_check_probe.sql-numeric.sql.postgresql
@@ -0,0 +1,4 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_check_probe alter column probe_id type numeric(12);
+alter table rhn_check_probe alter column host_id type numeric(12);
+alter table rhn_check_probe alter column sat_cluster_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..91d3ef1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/032-rhn_check_suites.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_check_suites alter column recid type numeric(12);
+alter table rhn_check_suites alter column customer_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..61e2b39
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/033-rhn_check_suite_probe.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_check_suite_probe alter column probe_id type numeric(12);
+alter table rhn_check_suite_probe alter column check_suite_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..f09a5a4
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/034-rhn_command_param_threshold.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_command_param_threshold alter column command_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..f69440a
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/035-rhn_command_queue_commands.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_command_queue_commands alter column recid type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..7462977
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/036-rhn_command_queue_instances.sql-numeric.sql.postgresql
@@ -0,0 +1,4 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_command_queue_instances alter column recid type numeric(12);
+alter table rhn_command_queue_instances alter column command_id type numeric(12);
+alter table rhn_command_queue_instances alter column timeout type numeric(5);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..7eb1d37
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/037-rhn_command_queue_execs.sql-numeric.sql.postgresql
@@ -0,0 +1,4 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_command_queue_execs alter column instance_id type numeric(12);
+alter table rhn_command_queue_execs alter column netsaint_id type numeric(12);
+alter table rhn_command_queue_execs alter column exit_status type numeric(5);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..635f612
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/038-rhn_command_queue_params.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_command_queue_params alter column instance_id type numeric(12);
+alter table rhn_command_queue_params alter column ord type numeric(3);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..17bae1d
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/039-rhn_command_queue_sessions.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_command_queue_sessions alter column contact_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..c3b9469
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/040-rhn_command_target.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_command_target alter column customer_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..83f3c1e
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/041-rhn_strategies.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_strategies alter column recid type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..0287275
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/043-rhn_current_alerts.sql-numeric.sql.postgresql
@@ -0,0 +1,9 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_current_alerts alter column recid type numeric(12);
+alter table rhn_current_alerts alter column original_server type numeric(12);
+alter table rhn_current_alerts alter column current_server type numeric(12);
+alter table rhn_current_alerts alter column escalation_level type numeric(2);
+alter table rhn_current_alerts alter column host_probe_id type numeric(12);
+alter table rhn_current_alerts alter column service_probe_id type numeric(12);
+alter table rhn_current_alerts alter column customer_id type numeric(12);
+alter table rhn_current_alerts alter column netsaint_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..bfc74ba
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/044-rhn_current_state_summaries.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_current_state_summaries alter column customer_id type numeric(12);
+alter table rhn_current_state_summaries alter column state_count type numeric(9);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..c9654db
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/045-rhn_deployed_probe.sql-numeric.sql.postgresql
@@ -0,0 +1,12 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_deployed_probe alter column recid type numeric(12);
+alter table rhn_deployed_probe alter column customer_id type numeric(12);
+alter table rhn_deployed_probe alter column command_id type numeric(16);
+alter table rhn_deployed_probe alter column contact_group_id type numeric(12);
+alter table rhn_deployed_probe alter column os_id type numeric(12);
+alter table rhn_deployed_probe alter column notification_interval_minutes type numeric(16);
+alter table rhn_deployed_probe alter column check_interval_minutes type numeric(16);
+alter table rhn_deployed_probe alter column retry_interval_minutes type numeric(16);
+alter table rhn_deployed_probe alter column max_attempts type numeric(16);
+alter table rhn_deployed_probe alter column sat_cluster_id type numeric(12);
+alter table rhn_deployed_probe alter column parent_probe_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..aeda277
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/046-rhn_host_probe.sql-numeric.sql.postgresql
@@ -0,0 +1,4 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_host_probe alter column probe_id type numeric(12);
+alter table rhn_host_probe alter column host_id type numeric(12);
+alter table rhn_host_probe alter column sat_cluster_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..155ea8d
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/047-rhn_method_types.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_method_types alter column recid type numeric(12);
+alter table rhn_method_types alter column notification_format_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..40267cf
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/048-rhn_multi_scout_threshold.sql-numeric.sql.postgresql
@@ -0,0 +1,4 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_multi_scout_threshold alter column probe_id type numeric(12);
+alter table rhn_multi_scout_threshold alter column scout_warning_threshold type numeric(12);
+alter table rhn_multi_scout_threshold alter column scout_critical_threshold type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..e88ee36
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/049-rhn_notification_formats.sql-numeric.sql.postgresql
@@ -0,0 +1,5 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_notification_formats alter column recid type numeric(12);
+alter table rhn_notification_formats alter column customer_id type numeric(12);
+alter table rhn_notification_formats alter column max_subject_length type numeric(12);
+alter table rhn_notification_formats alter column max_body_length type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..be7ed4c
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/050-rhn_notifservers.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_notifservers alter column recid type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..7f1a2d7
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/051-rhn_os.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_os alter column recid type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..5f62c61
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/052-rhn_os_commands_xref.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_os_commands_xref alter column os_id type numeric(12);
+alter table rhn_os_commands_xref alter column commands_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..2fe00aa
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/053-rhn_pager_types.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_pager_types alter column recid type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..91987df
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/054-rhn_physical_location.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_physical_location alter column recid type numeric(12);
+alter table rhn_physical_location alter column customer_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..7c78334
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/055-rhn_probe.sql-numeric.sql.postgresql
@@ -0,0 +1,8 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_probe alter column customer_id type numeric(12);
+alter table rhn_probe alter column command_id type numeric(16);
+alter table rhn_probe alter column contact_group_id type numeric(12);
+alter table rhn_probe alter column notification_interval_minutes type numeric(16);
+alter table rhn_probe alter column check_interval_minutes type numeric(16);
+alter table rhn_probe alter column retry_interval_minutes type numeric(16);
+alter table rhn_probe alter column max_attempts type numeric(16);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..1eb946e
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/056-rhn_probe_state.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_probe_state alter column probe_id type numeric(12);
+alter table rhn_probe_state alter column scout_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..af0048f
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/057-rhn_redirects.sql-numeric.sql.postgresql
@@ -0,0 +1,8 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_redirects alter column recid type numeric(12);
+alter table rhn_redirects alter column customer_id type numeric(12);
+alter table rhn_redirects alter column contact_id type numeric(12);
+alter table rhn_redirects alter column recurring type numeric(12);
+alter table rhn_redirects alter column recurring_frequency type numeric(12);
+alter table rhn_redirects alter column recurring_duration type numeric(12);
+alter table rhn_redirects alter column recurring_dur_type type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..c8e6214
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/058-rhn_redirect_email_targets.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_redirect_email_targets alter column redirect_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..3096fb8
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/059-rhn_redirect_group_targets.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_redirect_group_targets alter column redirect_id type numeric(12);
+alter table rhn_redirect_group_targets alter column contact_group_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..f732929
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/060-rhn_redirect_method_targets.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_redirect_method_targets alter column redirect_id type numeric(12);
+alter table rhn_redirect_method_targets alter column contact_method_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..0fdaa70
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/061-rhn_redirect_criteria.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_redirect_criteria alter column recid type numeric(12);
+alter table rhn_redirect_criteria alter column redirect_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..d54948e
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/062-rhn_sat_cluster.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_sat_cluster alter column customer_id type numeric(12);
+alter table rhn_sat_cluster alter column physical_location_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..0a90d8b
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/063-rhn_sat_cluster_probe.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_sat_cluster_probe alter column probe_id type numeric(12);
+alter table rhn_sat_cluster_probe alter column sat_cluster_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..9c3fe98
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/064-rhn_sat_node.sql-numeric.sql.postgresql
@@ -0,0 +1,7 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_sat_node alter column recid type numeric(12);
+alter table rhn_sat_node alter column max_concurrent_checks type numeric(4);
+alter table rhn_sat_node alter column sat_cluster_id type numeric(12);
+alter table rhn_sat_node alter column sched_log_level type numeric(4);
+alter table rhn_sat_node alter column sput_log_level type numeric(4);
+alter table rhn_sat_node alter column dq_log_level type numeric(4);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..6c8c9f7
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/065-rhn_satellite_state.sql-numeric.sql.postgresql
@@ -0,0 +1,5 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_satellite_state alter column satellite_id type numeric(12);
+alter table rhn_satellite_state alter column probe_count type numeric(10);
+alter table rhn_satellite_state alter column recent_state_changes type numeric(10);
+alter table rhn_satellite_state alter column imminent_probes type numeric(10);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..3891c28
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/066-rhn_schedule_types.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_schedule_types alter column recid type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..ea8897a
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/067-rhn_schedules.sql-numeric.sql.postgresql
@@ -0,0 +1,4 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_schedules alter column recid type numeric(12);
+alter table rhn_schedules alter column schedule_type_id type numeric(12);
+alter table rhn_schedules alter column customer_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..046e378
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/068-rhn_schedule_weeks.sql-numeric.sql.postgresql
@@ -0,0 +1,5 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_schedule_weeks alter column recid type numeric(12);
+alter table rhn_schedule_weeks alter column schedule_id type numeric(12);
+alter table rhn_schedule_weeks alter column component_schedule_id type numeric(12);
+alter table rhn_schedule_weeks alter column ord type numeric(3);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..16d8375
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/069-rhn_schedule_days.sql-numeric.sql.postgresql
@@ -0,0 +1,4 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_schedule_days alter column recid type numeric(12);
+alter table rhn_schedule_days alter column schedule_id type numeric(12);
+alter table rhn_schedule_days alter column ord type numeric(3);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..747d26a
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/070-rhn_server_monitoring_info.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_server_monitoring_info alter column recid type numeric(12);
+alter table rhn_server_monitoring_info alter column os_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..20fcfeb
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/071-rhn_service_probe_origins.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_service_probe_origins alter column service_probe_id type numeric(12);
+alter table rhn_service_probe_origins alter column origin_probe_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..698f67f
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/072-rhn_snmp_alert.sql-numeric.sql.postgresql
@@ -0,0 +1,9 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_snmp_alert alter column recid type numeric(12);
+alter table rhn_snmp_alert alter column sender_cluster_id type numeric(12);
+alter table rhn_snmp_alert alter column dest_port type numeric(5);
+alter table rhn_snmp_alert alter column notif_type type numeric(5);
+alter table rhn_snmp_alert alter column probe_id type numeric(12);
+alter table rhn_snmp_alert alter column severity type numeric(5);
+alter table rhn_snmp_alert alter column command_id type numeric(12);
+alter table rhn_snmp_alert alter column probe_class type numeric(5);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..aa6dc40
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/073-rhn_contact_groups.sql-numeric.sql.postgresql
@@ -0,0 +1,5 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_contact_groups alter column customer_id type numeric(12);
+alter table rhn_contact_groups alter column strategy_id type numeric(12);
+alter table rhn_contact_groups alter column ack_wait type numeric(4);
+alter table rhn_contact_groups alter column notification_format_id type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..c2426f1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/074-rhn_threshold_type.sql-numeric.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_threshold_type alter column ordinal type numeric(3);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..9d84436
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/075-rhn_time_zone_names.sql-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_time_zone_names alter column recid type numeric(12);
+alter table rhn_time_zone_names alter column gmt_offset_minutes type numeric(4);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..0335bae
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/076-rhn_url_probe.sql-numeric.sql.postgresql
@@ -0,0 +1,5 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_url_probe alter column probe_id type numeric(12);
+alter table rhn_url_probe alter column sat_cluster_id type numeric(12);
+alter table rhn_url_probe alter column scout_warning_threshold type numeric(12);
+alter table rhn_url_probe alter column scout_critical_threshold type numeric(12);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..aaa37c5
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/077-rhn_url_probe_step.sql-numeric.sql.postgresql
@@ -0,0 +1,10 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_url_probe_step alter column recid type numeric(12);
+alter table rhn_url_probe_step alter column url_probe_id type numeric(12);
+alter table rhn_url_probe_step alter column step_number type numeric(3);
+alter table rhn_url_probe_step alter column trans_warn type numeric(12);
+alter table rhn_url_probe_step alter column trans_crit type numeric(12);
+alter table rhn_url_probe_step alter column through_warn type numeric(12);
+alter table rhn_url_probe_step alter column through_crit type numeric(12);
+alter table rhn_url_probe_step alter column cookie_port type numeric(5);
+alter table rhn_url_probe_step alter column cookie_maxage type numeric(9);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.postgresql
new file mode 100644
index 0000000..925179c
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/078-rhn_contact_methods.sql-numeric.sql.postgresql
@@ -0,0 +1,9 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+alter table rhn_contact_methods alter column contact_id type numeric(12);
+alter table rhn_contact_methods alter column schedule_id type numeric(12);
+alter table rhn_contact_methods alter column method_type_id type numeric(12);
+alter table rhn_contact_methods alter column pager_type_id type numeric(12);
+alter table rhn_contact_methods alter column pager_max_message_length type numeric(6);
+alter table rhn_contact_methods alter column snmp_port type numeric(5);
+alter table rhn_contact_methods alter column notification_format_id type numeric(12);
+alter table rhn_contact_methods alter column sender_sat_cluster_id type numeric(12);
commit e0795fdd74e19892a7badbb3e0c10f0439b660c2
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Sep 2 14:45:08 2011 +0200
upgrade script for FLOAT -> NUMERIC fix
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.postgresql
new file mode 100644
index 0000000..32a443c
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/027-rhn_command_queue_execs-numeric.sql.postgresql
@@ -0,0 +1,3 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+
+alter table rhn_command_queue_execs alter column execution_time type numeric(10,6);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.postgresql
new file mode 100644
index 0000000..2a4a07e
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/028-rhn_satellite_state.sql.postgresql
@@ -0,0 +1,13 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+
+alter table rhn_satellite_state alter column pct_ok type numeric(10,2);
+alter table rhn_satellite_state alter column pct_warning type numeric(10,2);
+alter table rhn_satellite_state alter column pct_critical type numeric(10,2);
+alter table rhn_satellite_state alter column pct_unknown type numeric(10,2);
+alter table rhn_satellite_state alter column pct_pending type numeric(10,2);
+alter table rhn_satellite_state alter column max_exec_time type numeric(10,2);
+alter table rhn_satellite_state alter column min_exec_time type numeric(10,2);
+alter table rhn_satellite_state alter column avg_exec_time type numeric(10,2);
+alter table rhn_satellite_state alter column max_latency type numeric(10,2);
+alter table rhn_satellite_state alter column min_latency type numeric(10,2);
+alter table rhn_satellite_state alter column avg_latency type numeric(10,2);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.postgresql
new file mode 100644
index 0000000..e43e9c1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/029-rhn_url_probe_step.sql.postgresql
@@ -0,0 +1,10 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+
+alter table rhn_url_probe_step alter column connect_warn type numeric(10,3);
+alter table rhn_url_probe_step alter column connect_crit type numeric(10,3);
+alter table rhn_url_probe_step alter column latency_warn type numeric(10,3);
+alter table rhn_url_probe_step alter column latency_crit type numeric(10,3);
+alter table rhn_url_probe_step alter column dns_warn type numeric(10,3);
+alter table rhn_url_probe_step alter column dns_crit type numeric(10,3);
+alter table rhn_url_probe_step alter column total_warn type numeric(10,3);
+alter table rhn_url_probe_step alter column total_crit type numeric(10,3);
commit a733f4c9a8671679c87e49cc8dfdc41bb56996a3
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Sep 2 14:23:40 2011 +0200
don't translate NUMBER(X) to SMALLINT or FLOAT
fixing
2011-09-02 11:57:46,834 [TP-Processor3] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT csouter.recid as suite_id,
...
com.redhat.rhn.common.util.MethodNotFoundException: Could not find method called: setSuiteId in class: com.redhat.rhn.frontend.dto.monitoring.ProbeSuiteDto with params: [type: java.lang.Integer, value: 1]
2011-09-02 11:57:46,841 [TP-Processor3] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back javax.servlet.ServletException: com.redhat.rhn.common.util.MethodNotFoundException: Could not find method called: setSuiteId in class: com.redhat.rhn.frontend.dto.monitoring.ProbeSuiteDto with params: [type: java.lang.Integer, value: 1]
diff --git a/schema/spacewalk/spacewalk-oracle2postgresql b/schema/spacewalk/spacewalk-oracle2postgresql
index 54b0f88..a11d6f4 100755
--- a/schema/spacewalk/spacewalk-oracle2postgresql
+++ b/schema/spacewalk/spacewalk-oracle2postgresql
@@ -3,8 +3,6 @@
# data types
s/\bVARCHAR2/VARCHAR/i;
s/\bDATE\b/TIMESTAMPTZ/i;
-s/\bNUMBER(\([1-9]\|1[0-9]\))/SMALLINT/i;
-s/\bNUMBER([0-9]\+,\([0-9]\+\))/FLOAT(\1)/i;
s/\bNUMBER\b/NUMERIC/i;
s/\bBLOB\b/BYTEA/i;
commit 19cfeee9e6215c9d8b164b3228de598a60fc3647
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Aug 25 14:42:50 2011 +0200
fixed column alias syntax
fixing
ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT csouter.recid suite_id, csouter.suite_name suite_name, csouter.description description,
(SELECT count(DISTINCT cp.host_id) system_count
FROM RHN_CHECK_SUITE_PROBE csp,
RHN_SERVICE_PROBE_ORIGINS spo, RHN_CHECK_PROBE cp
WHERE csouter.recid = csp.check_suite_id AND
csp.probe_id = spo.origin_probe_id AND
spo.service_probe_id = cp.probe_id) system_count,
(SELECT count(DISTINCT cp.host_id)
FROM RHN_CHECK_SUITE_PROBE csp,
RHN_SERVICE_PROBE_ORIGINS spo, RHN_CHECK_PROBE cp,
rhnUserServerPerms usp
WHERE csouter.recid = csp.check_suite_id AND
csp.probe_id = spo.origin_probe_id AND
spo.service_probe_id = cp.probe_id AND
cp.host_id = usp.server_id AND
usp.user_id = ?) access_count
FROM rhn_check_suites csouter
WHERE csouter.customer_id = ?
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
index b170708..86dffb8 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
@@ -26,13 +26,15 @@ SELECT O_ID, ENTRY_TIME, DATA
<mode name="probe_suites_in_org" class="com.redhat.rhn.frontend.dto.monitoring.ProbeSuiteDto">
<query params="org_id, user_id"><![CDATA[
-SELECT csouter.recid suite_id, csouter.suite_name suite_name, csouter.description description,
- (SELECT count(DISTINCT cp.host_id) system_count
+SELECT csouter.recid as suite_id,
+ csouter.suite_name as suite_name,
+ csouter.description as description,
+ (SELECT count(DISTINCT cp.host_id) as system_count
FROM RHN_CHECK_SUITE_PROBE csp,
RHN_SERVICE_PROBE_ORIGINS spo, RHN_CHECK_PROBE cp
WHERE csouter.recid = csp.check_suite_id AND
csp.probe_id = spo.origin_probe_id AND
- spo.service_probe_id = cp.probe_id) system_count,
+ spo.service_probe_id = cp.probe_id) as system_count,
(SELECT count(DISTINCT cp.host_id)
FROM RHN_CHECK_SUITE_PROBE csp,
RHN_SERVICE_PROBE_ORIGINS spo, RHN_CHECK_PROBE cp,
@@ -41,7 +43,7 @@ SELECT csouter.recid suite_id, csouter.suite_name suite_name, csouter.descriptio
csp.probe_id = spo.origin_probe_id AND
spo.service_probe_id = cp.probe_id AND
cp.host_id = usp.server_id AND
- usp.user_id = :user_id) access_count
+ usp.user_id = :user_id) as access_count
FROM rhn_check_suites csouter
WHERE csouter.customer_id = :org_id
]]>
commit ab4bbb78bd30a532b48672dfaeeb520f6a8e3721
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Aug 25 14:02:26 2011 +0200
suite_id is number not string
fixing
ERROR: operator does not exist: character varying = smallint at character 122
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT count(*) noaccess
FROM RHN_CHECK_SUITE_PROBE csp,
RHN_SERVICE_PROBE_ORIGINS spo, RHN_CHECK_PROBE cp
WHERE $1 = csp.check_suite_id
AND csp.probe_id = spo.origin_probe_id
AND spo.service_probe_id = cp.probe_id
AND NOT EXISTS (SELECT 1 FROM rhnUserServerPerms usp
WHERE usp.server_id = cp.host_id
AND usp.user_id = $2)
diff --git a/java/code/src/com/redhat/rhn/common/security/acl/Access.java b/java/code/src/com/redhat/rhn/common/security/acl/Access.java
index 4523dd1..69bcfa7 100644
--- a/java/code/src/com/redhat/rhn/common/security/acl/Access.java
+++ b/java/code/src/com/redhat/rhn/common/security/acl/Access.java
@@ -318,7 +318,7 @@ public class Access extends BaseHandler implements AclHandler {
if (suites == null || suites.length != 1) {
throw new IllegalArgumentException("Expected exactly one suite_id");
}
- String suite = suites[0];
+ Long suite = Long.parseLong(suites[0]);
SelectMode m = ModeFactory.getMode("Monitoring_queries", "probe_suite_accessible");
Map params = new HashMap();
params.put("user_id", user.getId());
commit 8e37f4998ae4cdbdb1b7f2d8cd98c5d3d1311887
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Aug 25 14:01:28 2011 +0200
replaced alias with table name
fixing
ERROR: relation "check_probe" does not exist at character 305
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
index 92fa36f..b170708 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
@@ -269,7 +269,7 @@ SELECT S.id server_id,
PS.last_check
FROM rhnServer S, rhn_probe P, rhn_probe_state PS, rhnUserServerPerms USP
WHERE P.recid = PS.probe_id
- AND S.id = (SELECT host_id from check_probe where probe_id = P.recid)
+ AND S.id = (SELECT host_id from rhn_check_probe where probe_id = P.recid)
AND customer_id = :org_id
AND P.probe_type = 'check'
AND USP.user_id = :user_id
12 years, 7 months
Changes to 'refs/tags/spacewalk-java-1.6.37-1'
by Miroslav Suchý
Tag 'spacewalk-java-1.6.37-1' created by Miroslav Suchý <msuchy(a)redhat.com> at 2011-09-02 13:06 +0000
Tagging package [spacewalk-java] version [1.6.37-1] in directory [java/].
Changes since spacewalk-branding-1.6.3-1:
Miroslav Suchý (2):
show cname aliases in hw tab from config file
Automatic commit of package [spacewalk-java] release [1.6.37-1].
---
java/code/src/com/redhat/rhn/domain/server/Server.java | 13 +++-----
java/code/webapp/WEB-INF/pages/systems/sdc/hardware.jsp | 26 ----------------
java/spacewalk-java.spec | 6 +++
rel-eng/packages/spacewalk-java | 2 -
4 files changed, 12 insertions(+), 35 deletions(-)
---
12 years, 7 months
2 commits - java/code java/spacewalk-java.spec rel-eng/packages
by Miroslav Suchý
java/code/src/com/redhat/rhn/domain/server/Server.java | 13 +++-----
java/code/webapp/WEB-INF/pages/systems/sdc/hardware.jsp | 26 ----------------
java/spacewalk-java.spec | 6 +++
rel-eng/packages/spacewalk-java | 2 -
4 files changed, 12 insertions(+), 35 deletions(-)
New commits:
commit d79f7fcac9fb6a1cb85a9ccbe6e0e2c88fbf336f
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Fri Sep 2 15:06:00 2011 +0200
Automatic commit of package [spacewalk-java] release [1.6.37-1].
diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec
index 90a3dfe..b733fee 100644
--- a/java/spacewalk-java.spec
+++ b/java/spacewalk-java.spec
@@ -17,7 +17,7 @@ Name: spacewalk-java
Summary: Spacewalk Java site packages
Group: Applications/Internet
License: GPLv2
-Version: 1.6.36
+Version: 1.6.37
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -547,6 +547,10 @@ fi
%{jardir}/postgresql-jdbc.jar
%changelog
+* Fri Sep 02 2011 Miroslav Suchý 1.6.37-1
+- show cname aliases in hw tab from config file (msuchy(a)redhat.com)
+- Checkstyle fixes (mzazrivec(a)redhat.com)
+
* Fri Sep 02 2011 Tomas Lestach <tlestach(a)redhat.com> 1.6.36-1
- checkstyle fix (tlestach(a)redhat.com)
diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java
index 5b0caad..8089b4e 100644
--- a/rel-eng/packages/spacewalk-java
+++ b/rel-eng/packages/spacewalk-java
@@ -1 +1 @@
-1.6.36-1 java/
+1.6.37-1 java/
commit 3176e7223d3899f0d2884e9defa58c82c5faed93
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Fri Sep 2 08:54:48 2011 +0200
show cname aliases in hw tab from config file
diff --git a/java/code/src/com/redhat/rhn/domain/server/Server.java b/java/code/src/com/redhat/rhn/domain/server/Server.java
index dd2f696..ee7a1d0 100644
--- a/java/code/src/com/redhat/rhn/domain/server/Server.java
+++ b/java/code/src/com/redhat/rhn/domain/server/Server.java
@@ -113,6 +113,8 @@ public class Server extends BaseDomainHelper implements Identifiable {
private Set<? extends ServerGroup> groups;
private Set<Capability> capabilities;
+ public static final String VALID_CNAMES = "valid_cnames_";
+
/**
* @return Returns the capabilities.
*/
@@ -950,13 +952,10 @@ public class Server extends BaseDomainHelper implements Identifiable {
*/
public List<String> getCnames() {
List<String> result = new ArrayList();
- Iterator nets = networks.iterator();
- if (nets.hasNext()) {
- nets.next(); // skip primary interface
- }
- while (nets.hasNext()) {
- Network net = (Network) nets.next();
- result.add(net.getHostname());
+ List proxyCnames = Config.get().getList(VALID_CNAMES +
+ serverInfo.getId().toString());
+ if (!proxyCnames.isEmpty()) {
+ result.addAll(proxyCnames);
}
return result;
}
diff --git a/java/code/webapp/WEB-INF/pages/systems/sdc/hardware.jsp b/java/code/webapp/WEB-INF/pages/systems/sdc/hardware.jsp
index 1fa7ca4..04405f9 100644
--- a/java/code/webapp/WEB-INF/pages/systems/sdc/hardware.jsp
+++ b/java/code/webapp/WEB-INF/pages/systems/sdc/hardware.jsp
@@ -5,15 +5,6 @@
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html" %>
<html:html xhtml="true">
- <head>
- <script src="/dojo/dojo/dojo.js" djConfig="parseOnLoad: true">
- <script type="text/javascript">
- dojo.require("dijit.form.DropDownButton");
- dojo.require("dijit.TooltipDialog");
- dojo.require("dijit.form.TextBox");
- dojo.require("dijit.form.Button");
- </script>
- </head>
<body>
<%@ include file="/WEB-INF/pages/common/fragments/systems/system-header.jspf" %>
@@ -164,23 +155,6 @@
</c:otherwise>
</c:choose>
</td>
- <td>
- <div dojoType="dijit.form.DropDownButton">
- <span>
- + Add CName alias
- </span>
- <div dojoType="dijit.TooltipDialog">
- <label for="cname_alias">
- CName alias:
- </label>
- <input dojoType="dijit.form.TextBox" id="cname_alias" name="cname_alias">
- <br>
- <button dojoType="dijit.form.Button" type="submit">
- Save
- </button>
- </div>
- </div>
- </td>
</tr>
<c:forEach items="${network_cnames}" var="cname_alias" varStatus="loop">
<tr>
12 years, 7 months
Changes to 'refs/tags/spacewalk-branding-1.6.3-1'
by Jan Pazdziora
Tag 'spacewalk-branding-1.6.3-1' created by Jan Pazdziora <jpazdziora(a)redhat.com> at 2011-09-02 12:49 +0000
Tagging package [spacewalk-branding] version [1.6.3-1] in directory [branding/].
Changes since spacewalk-java-1.6.36-1:
Jan Pazdziora (2):
558972 - making the navigational bar nice on 2000+ px wide screens.
Automatic commit of package [spacewalk-branding] release [1.6.3-1].
Milan Zazrivec (1):
Checkstyle fixes
---
branding/img/nav/navPrimeRight3.png |binary
branding/spacewalk-branding.spec | 5 ++-
java/code/src/com/redhat/rhn/domain/config/ConfigurationFactory.java | 8 ++---
java/code/src/com/redhat/rhn/frontend/xmlrpc/configchannel/ConfigChannelHandler.java | 4 +-
java/code/src/com/redhat/rhn/manager/configuration/ConfigurationManager.java | 14 +++++-----
rel-eng/packages/spacewalk-branding | 2 -
6 files changed, 18 insertions(+), 15 deletions(-)
---
12 years, 7 months
branding/spacewalk-branding.spec rel-eng/packages
by Jan Pazdziora
branding/spacewalk-branding.spec | 5 ++++-
rel-eng/packages/spacewalk-branding | 2 +-
2 files changed, 5 insertions(+), 2 deletions(-)
New commits:
commit b663320345ab31b82b743133b4790551e7df237e
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Sep 2 14:49:12 2011 +0200
Automatic commit of package [spacewalk-branding] release [1.6.3-1].
diff --git a/branding/spacewalk-branding.spec b/branding/spacewalk-branding.spec
index cf66728..6a34d2e 100644
--- a/branding/spacewalk-branding.spec
+++ b/branding/spacewalk-branding.spec
@@ -1,5 +1,5 @@
Name: spacewalk-branding
-Version: 1.6.2
+Version: 1.6.3
Release: 1%{?dist}
Summary: Spacewalk branding data
@@ -83,6 +83,9 @@ rm -rf %{buildroot}
%doc LICENSE
%changelog
+* Fri Sep 02 2011 Jan Pazdziora 1.6.3-1
+- 558972 - making the navigational bar nice on 2000+ px wide screens.
+
* Fri Aug 05 2011 Jan Pazdziora 1.6.2-1
- 458413 - hide the bubble help links since we do not ship the documentation
with Spacewalk.
diff --git a/rel-eng/packages/spacewalk-branding b/rel-eng/packages/spacewalk-branding
index 9dbc24d..2e94bfd 100644
--- a/rel-eng/packages/spacewalk-branding
+++ b/rel-eng/packages/spacewalk-branding
@@ -1 +1 @@
-1.6.2-1 branding/
+1.6.3-1 branding/
12 years, 7 months