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