Tag 'spacewalk-schema-1.6.9-1' created by Michael Mraka
<michael.mraka(a)redhat.com> at 2011-08-30 08:44 +0000
Tagging package [spacewalk-schema] version [1.6.9-1] in directory [schema/spacewalk/].
Changes since spacewalk-java-1.6.31-1:
Michael Mraka (16):
added sed script replacement for chameleon
use new spacewalk-oracle2postgresql script
chameleon is no more required
specify NOLOGGING directly
create contraint and its index at once
upgrade scripts for create contraint and its index at once
disable foreign keys first
disable foreign keys for rhn_cperm_role_id_pk first
disable foreign keys for rhn_cfname_id_pk first
disable foreign keys for rhn_kstree_id_pk first
disable foreign keys for rhn_cmmnd_recid_comm_cl_uq first
disable foreign keys for rhn_probe_recid_probe_type_uq first
having unique both on (a, b) and (b, a) isn't very useful
upgrade script for rhn_service_probe_origins
fixed rhn_command upgrade for schema <0.6
Automatic commit of package [spacewalk-schema] release [1.6.9-1].
---
rel-eng/packages/spacewalk-schema
| 2
schema/spacewalk/common/Makefile
| 4 -
schema/spacewalk/common/tables/PXTSessions.sql
| 9 +--
schema/spacewalk/common/tables/rhnChannelPermissionRole.sql
| 7 --
schema/spacewalk/common/tables/rhnConfigFileName.sql
| 7 --
schema/spacewalk/common/tables/rhnKickstartableTree.sql
| 7 --
schema/spacewalk/common/tables/rhnOrgErrataCacheQueue.sql
| 8 ---
schema/spacewalk/common/tables/rhnSet.sql
| 4 -
schema/spacewalk/common/tables/rhn_command.sql
| 7 --
schema/spacewalk/common/tables/rhn_command_param_threshold.sql
| 7 --
schema/spacewalk/common/tables/rhn_command_queue_execs.sql
| 3 -
schema/spacewalk/common/tables/rhn_command_queue_params.sql
| 7 --
schema/spacewalk/common/tables/rhn_config_macro.sql
| 7 --
schema/spacewalk/common/tables/rhn_config_parameter.sql
| 7 --
schema/spacewalk/common/tables/rhn_current_state_summaries.sql
| 7 --
schema/spacewalk/common/tables/rhn_os_commands_xref.sql
| 7 --
schema/spacewalk/common/tables/rhn_probe.sql
| 7 --
schema/spacewalk/common/tables/rhn_probe_param_value.sql
| 7 --
schema/spacewalk/common/tables/rhn_redirect_email_targets.sql
| 7 --
schema/spacewalk/common/tables/rhn_redirect_group_targets.sql
| 7 --
schema/spacewalk/common/tables/rhn_redirect_method_targets.sql
| 7 --
schema/spacewalk/common/tables/rhn_service_probe_origins.sql
| 11 ----
schema/spacewalk/common/tables/rhn_time_zone_names.sql
| 7 --
schema/spacewalk/postgres/tables/Makefile
| 2
schema/spacewalk/spacewalk-oracle2postgresql
| 25 +++++++++
schema/spacewalk/spacewalk-schema.spec
| 10 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/007-PXTSessions-pk.sql.oracle
| 5 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/007-PXTSessions-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/008-rhnChannelPermissionRole-pk.sql.oracle
| 5 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/008-rhnChannelPermissionRole-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/009-rhnConfigFileName-pk.sql.oracle
| 11 ++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/009-rhnConfigFileName-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/010-rhnKickstartableTree-pk.sql.oracle
| 9 +++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/010-rhnKickstartableTree-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/011-rhn_command-pk.sql.oracle
| 26 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/011-rhn_command-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/012-rhn_command_param_threshold-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/012-rhn_command_param_threshold-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/013-rhn_command_queue_execs-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/013-rhn_command_queue_execs-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/014-rhn_command_queue_params-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/014-rhn_command_queue_params-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/015-rhn_config_macro-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/015-rhn_config_macro-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/016-rhn_config_parameter-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/016-rhn_config_parameter-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/017-rhn_current_state_summaries-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/017-rhn_current_state_summaries-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/018-rhn_os_commands_xref-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/018-rhn_os_commands_xref-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/019-rhn_probe-pk.sql.oracle
| 15 +++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/019-rhn_probe-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/020-rhn_probe_param_value-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/020-rhn_probe_param_value-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/021-rhn_redirect_email_targets-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/021-rhn_redirect_email_targets-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/022-rhn_redirect_group_targets-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/022-rhn_redirect_group_targets-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/023-rhn_redirect_method_targets-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/023-rhn_redirect_method_targets-pk.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/024-rhn_service_probe_origins-pk.sql.oracle
| 4 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/024-rhn_service_probe_origins-pk.sql.postgresql
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/025-rhn_time_zone_names-pk.sql.oracle
| 3 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/025-rhn_time_zone_names-pk.sql.postgresql
| 2
64 files changed, 227 insertions(+), 113 deletions(-)
---
Show replies by date