spacewalk-commits April 2009

spacewalk-commits@lists.fedorahosted.org

21 participants
741 discussions

Branch 'VADER' - java/code
by Justin Sherrill 02 Apr '09

02 Apr '09

java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit a3c2cc569b6df682f34c133d71fcbb86c1e1df04 Author: Justin Sherrill <jsherril(a)redhat.com> Date: Thu Apr 2 11:32:05 2009 -0400 fixing silly string comparison diff --git a/java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java b/java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java index 38b3db6..3f336e6 100644 --- a/java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java +++ b/java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java @@ -83,7 +83,7 @@ public abstract class BaseTreeAction extends BaseEditAction { BaseTreeEditOperation bte = (BaseTreeEditOperation) operation; String label = form.getString(LABEL); - if (label != bte.getTree().getLabel()) { + if (!label.equals(bte.getTree().getLabel())) { KickstartableTree tree = KickstartFactory.lookupKickstartTreeByLabel( label, bte.getUser().getOrg()); if (tree != null) {

1 0

java/code
by Justin Sherrill 02 Apr '09

02 Apr '09

java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 44ed6898803be2e97170c244f636d88843dec2a6 Author: Justin Sherrill <jsherril(a)redhat.com> Date: Thu Apr 2 11:32:05 2009 -0400 fixing silly string comparison diff --git a/java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java b/java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java index 38b3db6..3f336e6 100644 --- a/java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java +++ b/java/code/src/com/redhat/rhn/frontend/action/kickstart/tree/BaseTreeAction.java @@ -83,7 +83,7 @@ public abstract class BaseTreeAction extends BaseEditAction { BaseTreeEditOperation bte = (BaseTreeEditOperation) operation; String label = form.getString(LABEL); - if (label != bte.getTree().getLabel()) { + if (!label.equals(bte.getTree().getLabel())) { KickstartableTree tree = KickstartFactory.lookupKickstartTreeByLabel( label, bte.getUser().getOrg()); if (tree != null) {

1 0

Branch 'schemasandbox' - schema/spacewalk
by Jeff Ortel 02 Apr '09

02 Apr '09

schema/spacewalk/oracle/synonyms/Makefile.deps | 85 -- schema/spacewalk/oracle/synonyms/check_probe.sql | 31 schema/spacewalk/oracle/synonyms/check_suite_probe.sql | 28 schema/spacewalk/oracle/synonyms/check_suites.sql | 29 schema/spacewalk/oracle/synonyms/command.sql | 29 schema/spacewalk/oracle/synonyms/command_center_state.sql | 28 schema/spacewalk/oracle/synonyms/command_class.sql | 28 schema/spacewalk/oracle/synonyms/command_groups.sql | 28 schema/spacewalk/oracle/synonyms/command_param_threshold.sql | 28 schema/spacewalk/oracle/synonyms/command_parameter.sql | 28 schema/spacewalk/oracle/synonyms/command_queue_commands.sql | 29 schema/spacewalk/oracle/synonyms/command_queue_execs.sql | 28 schema/spacewalk/oracle/synonyms/command_queue_execs_bk.sql | 28 schema/spacewalk/oracle/synonyms/command_queue_instances.sql | 29 schema/spacewalk/oracle/synonyms/command_queue_instances_bk.sql | 28 schema/spacewalk/oracle/synonyms/command_queue_params.sql | 28 schema/spacewalk/oracle/synonyms/command_queue_sessions.sql | 28 schema/spacewalk/oracle/synonyms/command_requirements.sql | 28 schema/spacewalk/oracle/synonyms/command_target.sql | 29 schema/spacewalk/oracle/synonyms/config_group.sql | 28 schema/spacewalk/oracle/synonyms/config_macro.sql | 28 schema/spacewalk/oracle/synonyms/config_parameter.sql | 28 schema/spacewalk/oracle/synonyms/config_security_type.sql | 28 schema/spacewalk/oracle/synonyms/contact.sql | 26 schema/spacewalk/oracle/synonyms/contact_group_members.sql | 28 schema/spacewalk/oracle/synonyms/contact_groups.sql | 29 schema/spacewalk/oracle/synonyms/contact_methods.sql | 29 schema/spacewalk/oracle/synonyms/current_alerts.sql | 29 schema/spacewalk/oracle/synonyms/current_state_summaries.sql | 28 schema/spacewalk/oracle/synonyms/customer.sql | 26 schema/spacewalk/oracle/synonyms/db_environment.sql | 28 schema/spacewalk/oracle/synonyms/deployed_probe.sql | 28 schema/spacewalk/oracle/synonyms/environment.sql | 28 schema/spacewalk/oracle/synonyms/host.sql | 26 schema/spacewalk/oracle/synonyms/host_check_suites.sql | 28 schema/spacewalk/oracle/synonyms/host_probe.sql | 29 schema/spacewalk/oracle/synonyms/ll_netsaint.sql | 28 schema/spacewalk/oracle/synonyms/method_types.sql | 28 schema/spacewalk/oracle/synonyms/metrics.sql | 28 schema/spacewalk/oracle/synonyms/multi_scout_threshold.sql | 28 schema/spacewalk/oracle/synonyms/notification_formats.sql | 29 schema/spacewalk/oracle/synonyms/notifservers.sql | 28 schema/spacewalk/oracle/synonyms/os.sql | 28 schema/spacewalk/oracle/synonyms/os_commands_xref.sql | 28 schema/spacewalk/oracle/synonyms/pager_types.sql | 29 schema/spacewalk/oracle/synonyms/physical_location.sql | 29 schema/spacewalk/oracle/synonyms/probe.sql | 28 schema/spacewalk/oracle/synonyms/probe_param_value.sql | 28 schema/spacewalk/oracle/synonyms/probe_state.sql | 28 schema/spacewalk/oracle/synonyms/probe_types.sql | 28 schema/spacewalk/oracle/synonyms/quanta.sql | 28 schema/spacewalk/oracle/synonyms/redirect_criteria.sql | 29 schema/spacewalk/oracle/synonyms/redirect_email_targets.sql | 28 schema/spacewalk/oracle/synonyms/redirect_group_targets.sql | 28 schema/spacewalk/oracle/synonyms/redirect_match_types.sql | 28 schema/spacewalk/oracle/synonyms/redirect_method_targets.sql | 28 schema/spacewalk/oracle/synonyms/redirect_types.sql | 29 schema/spacewalk/oracle/synonyms/redirects.sql | 29 schema/spacewalk/oracle/synonyms/rhnKickstartChildChannel_synonyms.sql | 16 schema/spacewalk/oracle/synonyms/rhnProductName_synonyms.sql | 16 schema/spacewalk/oracle/synonyms/rhnServerCacheInfo_synonyms.sql | 27 schema/spacewalk/oracle/synonyms/rhnSolarisPackage_synonyms.sql | 22 schema/spacewalk/oracle/synonyms/rhnUserInfoPane_synonyms.sql | 20 schema/spacewalk/oracle/synonyms/rhn_config_channel_synonyms.sql | 15 schema/spacewalk/oracle/synonyms/rhn_date_manip_synonyms.sql | 30 schema/spacewalk/oracle/synonyms/sat_cluster.sql | 28 schema/spacewalk/oracle/synonyms/sat_cluster_probe.sql | 28 schema/spacewalk/oracle/synonyms/sat_node.sql | 28 schema/spacewalk/oracle/synonyms/sat_node_probe.sql | 28 schema/spacewalk/oracle/synonyms/satellite_state.sql | 28 schema/spacewalk/oracle/synonyms/schedule_days.sql | 29 schema/spacewalk/oracle/synonyms/schedule_days_norm.sql | 28 schema/spacewalk/oracle/synonyms/schedule_types.sql | 29 schema/spacewalk/oracle/synonyms/schedule_weeks.sql | 29 schema/spacewalk/oracle/synonyms/schedules.sql | 29 schema/spacewalk/oracle/synonyms/semantic_data_type.sql | 28 schema/spacewalk/oracle/synonyms/service_probe_origins.sql | 28 schema/spacewalk/oracle/synonyms/snmp_alert.sql | 29 schema/spacewalk/oracle/synonyms/strategies.sql | 29 schema/spacewalk/oracle/synonyms/threshold_type.sql | 28 schema/spacewalk/oracle/synonyms/time_zone_names.sql | 28 schema/spacewalk/oracle/synonyms/units.sql | 28 schema/spacewalk/oracle/synonyms/url_probe.sql | 28 schema/spacewalk/oracle/synonyms/url_probe_step.sql | 29 schema/spacewalk/oracle/synonyms/widget.sql | 28 schema/spacewalk/rhnsat/poll/create_poll.sql | 19 schema/spacewalk/rhnsat/poll/rhnPoll.sql | 63 - schema/spacewalk/rhnsat/poll/rhnPollChoice.sql | 62 - schema/spacewalk/rhnsat/poll/rhnPollQuestion.sql | 73 - schema/spacewalk/rhnsat/poll/rhnPollQuestionType.sql | 51 - schema/spacewalk/rhnsat/poll/rhnPollResponse.sql | 78 -- schema/spacewalk/rhnsat/poll/rhnPollState.sql | 51 - schema/spacewalk/rhnsat/quit.sql | 15 schema/spacewalk/rhnsat/start.sql | 15 schema/spacewalk/rhnsat/tables/Makefile.deps | 380 ---------- schema/spacewalk/rhnsat/tables/rhnVersionInfo_data.pre | 33 schema/spacewalk/rhnsat/types/Makefile.deps | 6 schema/spacewalk/rhnsat/views/Makefile | 8 schema/spacewalk/rhnsat/views/Makefile.deps | 154 ---- 99 files changed, 3414 deletions(-) New commits: commit bf52df7fdfc38b96b2a2f987298480839f28b711 Author: Jeff Ortel <jortel(a)redhat.com> Date: Thu Apr 2 11:16:08 2009 -0400 Remove unused /rhnsat and oracle/synonyms. All useful rhnsat contents moved to either /common /oracle or /postgres. All references to synonyms replaced in schema objects but code still needs to be retrofitted. diff --git a/schema/spacewalk/oracle/synonyms/Makefile.deps b/schema/spacewalk/oracle/synonyms/Makefile.deps deleted file mode 100644 index 7d7b132..0000000 --- a/schema/spacewalk/oracle/synonyms/Makefile.deps +++ /dev/null @@ -1,85 +0,0 @@ -# Dependencies for objects in the rhn/tables directory -# -# - -all :: - -check_probe :: rhn_check_probe -check_suite_probe :: rhn_check_suite_probe -check_suites :: rhn_check_suites -command :: rhn_command -command_center_state :: rhn_command_center_state -command_class :: rhn_command_class -command_groups :: rhn_command_groups -command_parameter :: rhn_command_parameter -command_parameter_threshold :: rhn_command_param_threshold -command_queue_commands :: rhn_command_queue_commands -command_queue_execs_bk :: rhn_command_queue_execs_bk -command_queue_execs :: rhn_command_queue_execs -command_queue_instances_bk :: rhn_command_queue_instances_bk -command_queue_instances :: rhn_command_queue_instances -command_queue_params :: rhn_command_queue_params -command_queue_sessions :: rhn_command_queue_sessions -command_requirements :: rhn_command_requirements -command_target :: rhn_command_target -config_group :: rhn_config_group -config_macro :: rhn_config_macro -config_parameter :: rhn_config_parameter -config_security_type :: rhn_config_security_type -contact :: rhn_contact_monitoring -contact_group_members :: rhn_contact_group_members -contact_groups :: rhn_contact_groups -contact_methods :: rhn_contact_methods -current_alerts :: rhn_current_alerts -current_state_summaries :: rhn_current_state_summaries -customer :: rhn_customer_monitoring -db_environment :: rhn_db_environment -deployed_probe :: rhn_deployed_probe -environment :: rhn_environment -host :: rhn_host_monitoring -host_check_suites :: rhn_host_check_suites -host_probe :: rhn_host_probe -ll_netsaint :: rhn_ll_netsaint -method_types :: rhn_method_types -metrics :: rhn_metrics -multi_scout_threshold :: rhn_multi_scout_threshold -notification_formats :: rhn_notification_formats -notifservers :: rhn_notifservers -os_commands_xref :: rhn_os_commands_xref -os :: rhn_os -pager_types :: rhn_pager_types -physical_location :: rhn_physical_location -probe_param_value :: rhn_probe_param_value -probe :: rhn_probe -probe_state :: rhn_probe_state -probe_types :: rhn_probe_types -quanta :: rhn_quanta -redirect_criteria :: rhn_redirect_criteria -redirect_email_targets :: rhn_redirect_email_targets -redirect_group_targets :: rhn_redirect_group_targets -redirect_match_types :: rhn_redirect_match_types -redirect_method_targets :: rhn_redirect_method_targets -redirects :: rhn_redirects -redirect_types :: rhn_redirect_types -sat_cluster_probe :: rhn_sat_cluster_probe -sat_cluster :: rhn_sat_cluster -satellite_state :: rhn_satellite_state -sat_node_probe :: rhn_sat_node_probe -sat_node :: rhn_sat_node -schedule_days_norm :: rhn_schedule_days_norm -schedule_days :: rhn_schedule_days -schedules :: rhn_schedules -schedule_types :: rhn_schedule_types -schedule_weeks :: rhn_schedule_weeks -semantic_data_type :: rhn_semantic_data_type -service_probe_origins :: rhn_service_probe_origins -snmp_alert :: rhn_snmp_alert -strategies :: rhn_strategies -threshold_type :: rhn_threshold_type -time_zone_names :: rhn_time_zone_names -units :: rhn_units -url_probe :: rhn_url_probe -url_probe_step :: rhn_url_probe_step -widget :: rhn_widget -rhnUser :: web_contact -rhnUser.satellite :: web_contact diff --git a/schema/spacewalk/oracle/synonyms/check_probe.sql b/schema/spacewalk/oracle/synonyms/check_probe.sql deleted file mode 100644 index e1d1b1b..0000000 --- a/schema/spacewalk/oracle/synonyms/check_probe.sql +++ /dev/null @@ -1,31 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special check_probe synonyms for monitoring backend code to function as is - -create or replace synonym check_probe for rhn_check_probe; - --- --- ---Revision 1.1 2004/06/23 15:18:19 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/check_suite_probe.sql b/schema/spacewalk/oracle/synonyms/check_suite_probe.sql deleted file mode 100644 index a6b69d6..0000000 --- a/schema/spacewalk/oracle/synonyms/check_suite_probe.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special check_suite_probe synonyms for monitoring backend code to function as is - -create or replace synonym check_suite_probe for rhn_check_suite_probe; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/check_suites.sql b/schema/spacewalk/oracle/synonyms/check_suites.sql deleted file mode 100644 index f4370df..0000000 --- a/schema/spacewalk/oracle/synonyms/check_suites.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special check_suites synonyms for monitoring backend code to function as is - -create or replace synonym check_suites for rhn_check_suites; -create or replace synonym check_suites_recid_seq for rhn_check_suites_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command.sql b/schema/spacewalk/oracle/synonyms/command.sql deleted file mode 100644 index 0bef2db..0000000 --- a/schema/spacewalk/oracle/synonyms/command.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command synonyms for monitoring backend code to function as is - -create or replace synonym command for rhn_command; -create or replace synonym commands_recid_seq for rhn_commands_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_center_state.sql b/schema/spacewalk/oracle/synonyms/command_center_state.sql deleted file mode 100644 index f55a5d8..0000000 --- a/schema/spacewalk/oracle/synonyms/command_center_state.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_center_state synonyms for monitoring backend code to function as is - -create or replace synonym command_center_state for rhn_command_center_state; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_class.sql b/schema/spacewalk/oracle/synonyms/command_class.sql deleted file mode 100644 index 8621c33..0000000 --- a/schema/spacewalk/oracle/synonyms/command_class.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_class synonyms for monitoring backend code to function as is - -create or replace synonym command_class for rhn_command_class; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_groups.sql b/schema/spacewalk/oracle/synonyms/command_groups.sql deleted file mode 100644 index 003aedb..0000000 --- a/schema/spacewalk/oracle/synonyms/command_groups.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_groups synonyms for monitoring backend code to function as is - -create or replace synonym command_groups for rhn_command_groups; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_param_threshold.sql b/schema/spacewalk/oracle/synonyms/command_param_threshold.sql deleted file mode 100644 index 536b250..0000000 --- a/schema/spacewalk/oracle/synonyms/command_param_threshold.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_param_threshold synonyms for monitoring backend code to function as is - -create or replace synonym command_parameter_threshold for rhn_command_param_threshold; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_parameter.sql b/schema/spacewalk/oracle/synonyms/command_parameter.sql deleted file mode 100644 index 2c64a42..0000000 --- a/schema/spacewalk/oracle/synonyms/command_parameter.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_parameter synonyms for monitoring backend code to function as is - -create or replace synonym command_parameter for rhn_command_parameter; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_queue_commands.sql b/schema/spacewalk/oracle/synonyms/command_queue_commands.sql deleted file mode 100644 index 1a476a4..0000000 --- a/schema/spacewalk/oracle/synonyms/command_queue_commands.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_queue_commands synonyms for monitoring backend code to function as is - -create or replace synonym command_queue_commands for rhn_command_queue_commands; -create or replace synonym command_q_command_recid_seq for rhn_command_q_comm_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_queue_execs.sql b/schema/spacewalk/oracle/synonyms/command_queue_execs.sql deleted file mode 100644 index add230f..0000000 --- a/schema/spacewalk/oracle/synonyms/command_queue_execs.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_queue_execs synonyms for monitoring backend code to function as is - -create or replace synonym command_queue_execs for rhn_command_queue_execs; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_queue_execs_bk.sql b/schema/spacewalk/oracle/synonyms/command_queue_execs_bk.sql deleted file mode 100644 index d711f17..0000000 --- a/schema/spacewalk/oracle/synonyms/command_queue_execs_bk.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_queue_execs_bk synonyms for monitoring backend code to function as is - -create or replace synonym command_queue_execs_bk for rhn_command_queue_execs_bk; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_queue_instances.sql b/schema/spacewalk/oracle/synonyms/command_queue_instances.sql deleted file mode 100644 index 4230929..0000000 --- a/schema/spacewalk/oracle/synonyms/command_queue_instances.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_queue_instances synonyms for monitoring backend code to function as is - -create or replace synonym command_queue_instances for rhn_command_queue_instances; -create or replace synonym command_q_instance_recid_seq for rhn_command_q_inst_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_queue_instances_bk.sql b/schema/spacewalk/oracle/synonyms/command_queue_instances_bk.sql deleted file mode 100644 index e834d0b..0000000 --- a/schema/spacewalk/oracle/synonyms/command_queue_instances_bk.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_queue_instances_bk synonyms for monitoring backend code to function as is - -create or replace synonym command_queue_instances_bk for rhn_command_queue_instances_bk; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_queue_params.sql b/schema/spacewalk/oracle/synonyms/command_queue_params.sql deleted file mode 100644 index 7deb091..0000000 --- a/schema/spacewalk/oracle/synonyms/command_queue_params.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_queue_params synonyms for monitoring backend code to function as is - -create or replace synonym command_queue_params for rhn_command_queue_params; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_queue_sessions.sql b/schema/spacewalk/oracle/synonyms/command_queue_sessions.sql deleted file mode 100644 index 6b32c83..0000000 --- a/schema/spacewalk/oracle/synonyms/command_queue_sessions.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_queue_sessions synonyms for monitoring backend code to function as is - -create or replace synonym command_queue_sessions for rhn_command_queue_sessions; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_requirements.sql b/schema/spacewalk/oracle/synonyms/command_requirements.sql deleted file mode 100644 index 3ed55e1..0000000 --- a/schema/spacewalk/oracle/synonyms/command_requirements.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special command_requirements synonyms for monitoring backend code to function as is - -create or replace synonym command_requirements for rhn_command_requirements; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/command_target.sql b/schema/spacewalk/oracle/synonyms/command_target.sql deleted file mode 100644 index 9e09149..0000000 --- a/schema/spacewalk/oracle/synonyms/command_target.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special synonyms for monitoring backend code to function as is - -create or replace synonym command_target for rhn_command_target; -create or replace synonym command_target_recid_seq for rhn_command_target_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/config_group.sql b/schema/spacewalk/oracle/synonyms/config_group.sql deleted file mode 100644 index 5ecdf32..0000000 --- a/schema/spacewalk/oracle/synonyms/config_group.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special config_group synonyms for monitoring backend code to function as is - -create or replace synonym config_group for rhn_config_group; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/config_macro.sql b/schema/spacewalk/oracle/synonyms/config_macro.sql deleted file mode 100644 index 465b9c3..0000000 --- a/schema/spacewalk/oracle/synonyms/config_macro.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special config_macro synonyms for monitoring backend code to function as is - -create or replace synonym config_macro for rhn_config_macro; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/config_parameter.sql b/schema/spacewalk/oracle/synonyms/config_parameter.sql deleted file mode 100644 index 7e58f41..0000000 --- a/schema/spacewalk/oracle/synonyms/config_parameter.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special config_parameter synonyms for monitoring backend code to function as is - -create or replace synonym config_parameter for rhn_config_parameter; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/config_security_type.sql b/schema/spacewalk/oracle/synonyms/config_security_type.sql deleted file mode 100644 index c18ccec..0000000 --- a/schema/spacewalk/oracle/synonyms/config_security_type.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special config_security_type synonyms for monitoring backend code to function as is - -create or replace synonym config_security_type for rhn_config_security_type; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/contact.sql b/schema/spacewalk/oracle/synonyms/contact.sql deleted file mode 100644 index 033d6c4..0000000 --- a/schema/spacewalk/oracle/synonyms/contact.sql +++ /dev/null @@ -1,26 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special contact synonyms for monitoring backend code to function as is - -create or replace synonym contact for rhn_contact_monitoring; - --- ---Revision 1.1 2004/07/16 15:35:00 kja ---Bug 126465 -- fix synonyms for monitoring views. --- diff --git a/schema/spacewalk/oracle/synonyms/contact_group_members.sql b/schema/spacewalk/oracle/synonyms/contact_group_members.sql deleted file mode 100644 index ef80964..0000000 --- a/schema/spacewalk/oracle/synonyms/contact_group_members.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special contact_group_members synonyms for monitoring backend code to function as is - -create or replace synonym contact_group_members for rhn_contact_group_members; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/contact_groups.sql b/schema/spacewalk/oracle/synonyms/contact_groups.sql deleted file mode 100644 index f23b0cb..0000000 --- a/schema/spacewalk/oracle/synonyms/contact_groups.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special contact_groups synonyms for monitoring backend code to function as is - -create or replace synonym contact_groups for rhn_contact_groups; -create or replace synonym contact_groups_recid_seq for rhn_contact_groups_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/contact_methods.sql b/schema/spacewalk/oracle/synonyms/contact_methods.sql deleted file mode 100644 index bf7dbef..0000000 --- a/schema/spacewalk/oracle/synonyms/contact_methods.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special contact_methods synonyms for monitoring backend code to function as is - -create or replace synonym contact_methods for rhn_contact_methods; -create or replace synonym contact_methods_recid_seq for rhn_contact_methods_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/current_alerts.sql b/schema/spacewalk/oracle/synonyms/current_alerts.sql deleted file mode 100644 index aa25235..0000000 --- a/schema/spacewalk/oracle/synonyms/current_alerts.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special current_alerts synonyms for monitoring backend code to function as is - -create or replace synonym current_alerts for rhn_current_alerts; -create or replace synonym current_alerts_recid_seq for rhn_current_alerts_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/current_state_summaries.sql b/schema/spacewalk/oracle/synonyms/current_state_summaries.sql deleted file mode 100644 index f7060b0..0000000 --- a/schema/spacewalk/oracle/synonyms/current_state_summaries.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special current_state_summaries synonyms for monitoring backend code to function as is - -create or replace synonym current_state_summaries for rhn_current_state_summaries; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/customer.sql b/schema/spacewalk/oracle/synonyms/customer.sql deleted file mode 100644 index 05fdbca..0000000 --- a/schema/spacewalk/oracle/synonyms/customer.sql +++ /dev/null @@ -1,26 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special customer synonyms for monitoring backend code to function as is - -create or replace synonym customer for rhn_customer_monitoring; - --- ---Revision 1.1 2004/07/16 15:35:00 kja ---Bug 126465 -- fix synonyms for monitoring views. --- diff --git a/schema/spacewalk/oracle/synonyms/db_environment.sql b/schema/spacewalk/oracle/synonyms/db_environment.sql deleted file mode 100644 index 0172c7d..0000000 --- a/schema/spacewalk/oracle/synonyms/db_environment.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special db_environment synonyms for monitoring backend code to function as is - -create or replace synonym db_environment for rhn_db_environment; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/deployed_probe.sql b/schema/spacewalk/oracle/synonyms/deployed_probe.sql deleted file mode 100644 index 7be233c..0000000 --- a/schema/spacewalk/oracle/synonyms/deployed_probe.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special deployed_probe synonyms for monitoring backend code to function as is - -create or replace synonym deployed_probe for rhn_deployed_probe; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/environment.sql b/schema/spacewalk/oracle/synonyms/environment.sql deleted file mode 100644 index 6558069..0000000 --- a/schema/spacewalk/oracle/synonyms/environment.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special environment synonyms for monitoring backend code to function as is - -create or replace synonym environment for rhn_environment; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/host.sql b/schema/spacewalk/oracle/synonyms/host.sql deleted file mode 100644 index 76ef3d0..0000000 --- a/schema/spacewalk/oracle/synonyms/host.sql +++ /dev/null @@ -1,26 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special host synonyms for monitoring backend code to function as is - -create or replace synonym host for rhn_host_monitoring; - --- ---Revision 1.1 2004/07/16 15:35:00 kja ---Bug 126465 -- fix synonyms for monitoring views. --- diff --git a/schema/spacewalk/oracle/synonyms/host_check_suites.sql b/schema/spacewalk/oracle/synonyms/host_check_suites.sql deleted file mode 100644 index ec2018b..0000000 --- a/schema/spacewalk/oracle/synonyms/host_check_suites.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special host_check_suites synonyms for monitoring backend code to function as is - -create or replace synonym host_check_suites for rhn_host_check_suites; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/host_probe.sql b/schema/spacewalk/oracle/synonyms/host_probe.sql deleted file mode 100644 index 4cf6e47..0000000 --- a/schema/spacewalk/oracle/synonyms/host_probe.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special host_probe synonyms for monitoring backend code to function as is - -create or replace synonym host_probe for rhn_host_probe; -create or replace synonym host_probes_recid_seq for rhn_host_probes_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/ll_netsaint.sql b/schema/spacewalk/oracle/synonyms/ll_netsaint.sql deleted file mode 100644 index 331db1e..0000000 --- a/schema/spacewalk/oracle/synonyms/ll_netsaint.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special ll_netsaint synonyms for monitoring backend code to function as is - -create or replace synonym ll_netsaint for rhn_ll_netsaint; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/method_types.sql b/schema/spacewalk/oracle/synonyms/method_types.sql deleted file mode 100644 index 7a5a484..0000000 --- a/schema/spacewalk/oracle/synonyms/method_types.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special method_types synonyms for monitoring backend code to function as is - -create or replace synonym method_types for rhn_method_types; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/metrics.sql b/schema/spacewalk/oracle/synonyms/metrics.sql deleted file mode 100644 index 573fb1e..0000000 --- a/schema/spacewalk/oracle/synonyms/metrics.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special metrics synonyms for monitoring backend code to function as is - -create or replace synonym metrics for rhn_metrics ; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/multi_scout_threshold.sql b/schema/spacewalk/oracle/synonyms/multi_scout_threshold.sql deleted file mode 100644 index bc786fa..0000000 --- a/schema/spacewalk/oracle/synonyms/multi_scout_threshold.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special multi_scout_threshold synonyms for monitoring backend code to function as is - -create or replace synonym multi_scout_threshold for rhn_multi_scout_threshold; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/notification_formats.sql b/schema/spacewalk/oracle/synonyms/notification_formats.sql deleted file mode 100644 index 7eb2417..0000000 --- a/schema/spacewalk/oracle/synonyms/notification_formats.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special notification_formats synonyms for monitoring backend code to function as is - -create or replace synonym notification_formats for rhn_notification_formats; -create or replace synonym ntfmt_recid_seq for rhn_ntfmt_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/notifservers.sql b/schema/spacewalk/oracle/synonyms/notifservers.sql deleted file mode 100644 index 725765d..0000000 --- a/schema/spacewalk/oracle/synonyms/notifservers.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special notifservers synonyms for monitoring backend code to function as is - -create or replace synonym notifservers for rhn_notifservers; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/os.sql b/schema/spacewalk/oracle/synonyms/os.sql deleted file mode 100644 index 12a5bf9..0000000 --- a/schema/spacewalk/oracle/synonyms/os.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special os synonyms for monitoring backend code to function as is - -create or replace synonym os for rhn_os; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/os_commands_xref.sql b/schema/spacewalk/oracle/synonyms/os_commands_xref.sql deleted file mode 100644 index 2714cf7..0000000 --- a/schema/spacewalk/oracle/synonyms/os_commands_xref.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special os_commands_xref synonyms for monitoring backend code to function as is - -create or replace synonym os_commands_xref for rhn_os_commands_xref; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/pager_types.sql b/schema/spacewalk/oracle/synonyms/pager_types.sql deleted file mode 100644 index 2e68f7d..0000000 --- a/schema/spacewalk/oracle/synonyms/pager_types.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special pager_types synonyms for monitoring backend code to function as is - -create or replace synonym pager_types for rhn_pager_types; -create or replace synonym pager_types_recid_seq for rhn_pager_types_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/physical_location.sql b/schema/spacewalk/oracle/synonyms/physical_location.sql deleted file mode 100644 index b4d48f8..0000000 --- a/schema/spacewalk/oracle/synonyms/physical_location.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special physical_location synonyms for monitoring backend code to function as is - -create or replace synonym physical_location for rhn_physical_location; -create or replace synonym physical_location_recid_seq for rhn_physical_loc_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/probe.sql b/schema/spacewalk/oracle/synonyms/probe.sql deleted file mode 100644 index f7c1f0d..0000000 --- a/schema/spacewalk/oracle/synonyms/probe.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- --- - -create or replace synonym probe for rhn_probe; -create or replace synonym probes_recid_seq for rhn_probes_recid_seq; - --- --- --- Revision 1.1 2004/06/22 21:15:08 nhansen --- bug none: make probe synonyms available on satellites --- - diff --git a/schema/spacewalk/oracle/synonyms/probe_param_value.sql b/schema/spacewalk/oracle/synonyms/probe_param_value.sql deleted file mode 100644 index 5f249d4..0000000 --- a/schema/spacewalk/oracle/synonyms/probe_param_value.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special probe_param_value synonyms for monitoring backend code to function as is - -create or replace synonym probe_param_value for rhn_probe_param_value; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/probe_state.sql b/schema/spacewalk/oracle/synonyms/probe_state.sql deleted file mode 100644 index 32b18ae..0000000 --- a/schema/spacewalk/oracle/synonyms/probe_state.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special probe_state synonyms for monitoring backend code to function as is - -create or replace synonym probe_state for rhn_probe_state; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/probe_types.sql b/schema/spacewalk/oracle/synonyms/probe_types.sql deleted file mode 100644 index c947913..0000000 --- a/schema/spacewalk/oracle/synonyms/probe_types.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special probe_types synonyms for monitoring backend code to function as is - -create or replace synonym probe_types for rhn_probe_types; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/quanta.sql b/schema/spacewalk/oracle/synonyms/quanta.sql deleted file mode 100644 index 907c1cb..0000000 --- a/schema/spacewalk/oracle/synonyms/quanta.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special quanta synonyms for monitoring backend code to function as is - -create or replace synonym quanta for rhn_quanta; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/redirect_criteria.sql b/schema/spacewalk/oracle/synonyms/redirect_criteria.sql deleted file mode 100644 index 4641856..0000000 --- a/schema/spacewalk/oracle/synonyms/redirect_criteria.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special redirect_criteria synonyms for monitoring backend code to function as is - -create or replace synonym redirect_criteria for rhn_redirect_criteria; -create or replace synonym redirect_criteria_recid_seq for rhn_redirect_crit_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/redirect_email_targets.sql b/schema/spacewalk/oracle/synonyms/redirect_email_targets.sql deleted file mode 100644 index 7886aa6..0000000 --- a/schema/spacewalk/oracle/synonyms/redirect_email_targets.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special redirect_email_targets synonyms for monitoring backend code to function as is - -create or replace synonym redirect_email_targets for rhn_redirect_email_targets; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/redirect_group_targets.sql b/schema/spacewalk/oracle/synonyms/redirect_group_targets.sql deleted file mode 100644 index 3a94708..0000000 --- a/schema/spacewalk/oracle/synonyms/redirect_group_targets.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special redirect_group_targets synonyms for monitoring backend code to function as is - -create or replace synonym redirect_group_targets for rhn_redirect_group_targets; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/redirect_match_types.sql b/schema/spacewalk/oracle/synonyms/redirect_match_types.sql deleted file mode 100644 index 81eced7..0000000 --- a/schema/spacewalk/oracle/synonyms/redirect_match_types.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special redirect_match_types synonyms for monitoring backend code to function as is - -create or replace synonym redirect_match_types for rhn_redirect_match_types; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/redirect_method_targets.sql b/schema/spacewalk/oracle/synonyms/redirect_method_targets.sql deleted file mode 100644 index a49eba4..0000000 --- a/schema/spacewalk/oracle/synonyms/redirect_method_targets.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special redirect_method_targets synonyms for monitoring backend code to function as is - -create or replace synonym redirect_method_targets for rhn_redirect_method_targets; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/redirect_types.sql b/schema/spacewalk/oracle/synonyms/redirect_types.sql deleted file mode 100644 index ff42304..0000000 --- a/schema/spacewalk/oracle/synonyms/redirect_types.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special redirect_types synonyms for monitoring backend code to function as is - -create or replace synonym redirect_types for rhn_redirect_types; -create or replace synonym redirect_types_recid_seq for rhn_redirect_types_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/redirects.sql b/schema/spacewalk/oracle/synonyms/redirects.sql deleted file mode 100644 index 3c3e5da..0000000 --- a/schema/spacewalk/oracle/synonyms/redirects.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special redirects synonyms for monitoring backend code to function as is - -create or replace synonym redirects for rhn_redirects; -create or replace synonym redirects_recid_seq for rhn_redirects_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/rhnKickstartChildChannel_synonyms.sql b/schema/spacewalk/oracle/synonyms/rhnKickstartChildChannel_synonyms.sql deleted file mode 100644 index d066eb9..0000000 --- a/schema/spacewalk/oracle/synonyms/rhnKickstartChildChannel_synonyms.sql +++ /dev/null @@ -1,16 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- - -create synonym rhnKickstartChildChannel for rhn.rhnKickstartChildChannel; diff --git a/schema/spacewalk/oracle/synonyms/rhnProductName_synonyms.sql b/schema/spacewalk/oracle/synonyms/rhnProductName_synonyms.sql deleted file mode 100644 index c08b1aa..0000000 --- a/schema/spacewalk/oracle/synonyms/rhnProductName_synonyms.sql +++ /dev/null @@ -1,16 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- -create synonym rhnProductName for rhn.rhnProductName; -create synonym rhn_productname_id_seq; diff --git a/schema/spacewalk/oracle/synonyms/rhnServerCacheInfo_synonyms.sql b/schema/spacewalk/oracle/synonyms/rhnServerCacheInfo_synonyms.sql deleted file mode 100644 index e3436d0..0000000 --- a/schema/spacewalk/oracle/synonyms/rhnServerCacheInfo_synonyms.sql +++ /dev/null @@ -1,27 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create or replace synonym rhnServerCacheInfo for rhn.rhnServerCacheInfo; - --- --- --- Revision 1.2 2005/02/09 22:03:16 jslagle --- Comments changes --- --- - diff --git a/schema/spacewalk/oracle/synonyms/rhnSolarisPackage_synonyms.sql b/schema/spacewalk/oracle/synonyms/rhnSolarisPackage_synonyms.sql deleted file mode 100644 index 845ede2..0000000 --- a/schema/spacewalk/oracle/synonyms/rhnSolarisPackage_synonyms.sql +++ /dev/null @@ -1,22 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- -create synonym rhnSolarisPackage for rhn.rhnSolarisPackage; - --- --- --- diff --git a/schema/spacewalk/oracle/synonyms/rhnUserInfoPane_synonyms.sql b/schema/spacewalk/oracle/synonyms/rhnUserInfoPane_synonyms.sql deleted file mode 100644 index 2f7f18a..0000000 --- a/schema/spacewalk/oracle/synonyms/rhnUserInfoPane_synonyms.sql +++ /dev/null @@ -1,20 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create or replace synonym rhnUserInfoPane for rhn.rhnUserInfoPane; - diff --git a/schema/spacewalk/oracle/synonyms/rhn_config_channel_synonyms.sql b/schema/spacewalk/oracle/synonyms/rhn_config_channel_synonyms.sql deleted file mode 100644 index 8692c7f..0000000 --- a/schema/spacewalk/oracle/synonyms/rhn_config_channel_synonyms.sql +++ /dev/null @@ -1,15 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- -create synonym rhn_config_channel for rhn.rhn_config_channel; diff --git a/schema/spacewalk/oracle/synonyms/rhn_date_manip_synonyms.sql b/schema/spacewalk/oracle/synonyms/rhn_date_manip_synonyms.sql deleted file mode 100644 index 69b0153..0000000 --- a/schema/spacewalk/oracle/synonyms/rhn_date_manip_synonyms.sql +++ /dev/null @@ -1,30 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create or replace synonym rhn_date_manip for rhn.rhn_date_manip; - --- --- Revision 1.2 2004/01/28 22:22:10 pjones --- bugzilla: none -- one of the dumbest typos ever, now fixed. We never --- refer to this package from rhnuser, so I don't think it makes any --- significant difference... --- --- Revision 1.1 2003/03/07 23:13:58 pjones --- date manipulation procedures --- so far, these pick date ranges to do reports from --- diff --git a/schema/spacewalk/oracle/synonyms/sat_cluster.sql b/schema/spacewalk/oracle/synonyms/sat_cluster.sql deleted file mode 100644 index 70256da..0000000 --- a/schema/spacewalk/oracle/synonyms/sat_cluster.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special sat_cluster synonyms for monitoring backend code to function as is - -create or replace synonym sat_cluster for rhn_sat_cluster; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/sat_cluster_probe.sql b/schema/spacewalk/oracle/synonyms/sat_cluster_probe.sql deleted file mode 100644 index f9d2103..0000000 --- a/schema/spacewalk/oracle/synonyms/sat_cluster_probe.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special sat_cluster_probe synonyms for monitoring backend code to function as is - -create or replace synonym sat_cluster_probe for rhn_sat_cluster_probe; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/sat_node.sql b/schema/spacewalk/oracle/synonyms/sat_node.sql deleted file mode 100644 index 7bdd9ff..0000000 --- a/schema/spacewalk/oracle/synonyms/sat_node.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special sat_node synonyms for monitoring backend code to function as is - -create or replace synonym sat_node for rhn_sat_node; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/sat_node_probe.sql b/schema/spacewalk/oracle/synonyms/sat_node_probe.sql deleted file mode 100644 index 7e7bbfd..0000000 --- a/schema/spacewalk/oracle/synonyms/sat_node_probe.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special sat_node_probe synonyms for monitoring backend code to function as is - -create or replace synonym sat_node_probe for rhn_sat_node_probe; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/satellite_state.sql b/schema/spacewalk/oracle/synonyms/satellite_state.sql deleted file mode 100644 index e174b90..0000000 --- a/schema/spacewalk/oracle/synonyms/satellite_state.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special satellite_state synonyms for monitoring backend code to function as is - -create or replace synonym satellite_state for rhn_satellite_state; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/schedule_days.sql b/schema/spacewalk/oracle/synonyms/schedule_days.sql deleted file mode 100644 index d109311..0000000 --- a/schema/spacewalk/oracle/synonyms/schedule_days.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special schedule_days synonyms for monitoring backend code to function as is - -create or replace synonym schedule_days for rhn_schedule_days; -create or replace synonym schedule_days_recid_seq for rhn_schedule_days_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/schedule_days_norm.sql b/schema/spacewalk/oracle/synonyms/schedule_days_norm.sql deleted file mode 100644 index 3f02b82..0000000 --- a/schema/spacewalk/oracle/synonyms/schedule_days_norm.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special schedule_days_norm synonyms for monitoring backend code to function as is - -create or replace synonym schedule_days_norm for rhn_schedule_days_norm; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/schedule_types.sql b/schema/spacewalk/oracle/synonyms/schedule_types.sql deleted file mode 100644 index d47f939..0000000 --- a/schema/spacewalk/oracle/synonyms/schedule_types.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special schedule_types synonyms for monitoring backend code to function as is - -create or replace synonym schedule_types for rhn_schedule_types; -create or replace synonym schedule_types_recid_seq for rhn_schedule_types_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/schedule_weeks.sql b/schema/spacewalk/oracle/synonyms/schedule_weeks.sql deleted file mode 100644 index 6a7e0bb..0000000 --- a/schema/spacewalk/oracle/synonyms/schedule_weeks.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special schedule_weeks synonyms for monitoring backend code to function as is - -create or replace synonym schedule_weeks for rhn_schedule_weeks; -create or replace synonym schedule_weeks_recid_seq for rhn_schedule_weeks_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/schedules.sql b/schema/spacewalk/oracle/synonyms/schedules.sql deleted file mode 100644 index 26d2546..0000000 --- a/schema/spacewalk/oracle/synonyms/schedules.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special schedules synonyms for monitoring backend code to function as is - -create or replace synonym schedules for rhn_schedules; -create or replace synonym schedules_recid_seq for rhn_schedules_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/semantic_data_type.sql b/schema/spacewalk/oracle/synonyms/semantic_data_type.sql deleted file mode 100644 index b11157f..0000000 --- a/schema/spacewalk/oracle/synonyms/semantic_data_type.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special semantic_data_type synonyms for monitoring backend code to function as is - -create or replace synonym semantic_data_type for rhn_semantic_data_type; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/service_probe_origins.sql b/schema/spacewalk/oracle/synonyms/service_probe_origins.sql deleted file mode 100644 index c537bea..0000000 --- a/schema/spacewalk/oracle/synonyms/service_probe_origins.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special service_probe_origins synonyms for monitoring backend code to function as is - -create or replace synonym service_probe_origins for rhn_service_probe_origins; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/snmp_alert.sql b/schema/spacewalk/oracle/synonyms/snmp_alert.sql deleted file mode 100644 index 0cd8815..0000000 --- a/schema/spacewalk/oracle/synonyms/snmp_alert.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special snmp_alert synonyms for monitoring backend code to function as is - -create or replace synonym snmp_alert for rhn_snmp_alert; -create or replace synonym snmp_alert_recid_seq for rhn_snmp_alert_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/strategies.sql b/schema/spacewalk/oracle/synonyms/strategies.sql deleted file mode 100644 index 81ce92d..0000000 --- a/schema/spacewalk/oracle/synonyms/strategies.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special strategies synonyms for monitoring backend code to function as is - -create or replace synonym strategies for rhn_strategies; -create or replace synonym strategies_recid_seq for rhn_strategies_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/threshold_type.sql b/schema/spacewalk/oracle/synonyms/threshold_type.sql deleted file mode 100644 index 3fa22e7..0000000 --- a/schema/spacewalk/oracle/synonyms/threshold_type.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special threshold_type synonyms for monitoring backend code to function as is - -create or replace synonym threshold_type for rhn_threshold_type; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/time_zone_names.sql b/schema/spacewalk/oracle/synonyms/time_zone_names.sql deleted file mode 100644 index 5c1a2d6..0000000 --- a/schema/spacewalk/oracle/synonyms/time_zone_names.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special time_zone_names synonyms for monitoring backend code to function as is - -create or replace synonym time_zone_names for rhn_time_zone_names; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/units.sql b/schema/spacewalk/oracle/synonyms/units.sql deleted file mode 100644 index 3636610..0000000 --- a/schema/spacewalk/oracle/synonyms/units.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special units synonyms for monitoring backend code to function as is - -create or replace synonym units for rhn_units; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/url_probe.sql b/schema/spacewalk/oracle/synonyms/url_probe.sql deleted file mode 100644 index e31065c..0000000 --- a/schema/spacewalk/oracle/synonyms/url_probe.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special url_probe synonyms for monitoring backend code to function as is - -create or replace synonym url_probe for rhn_url_probe; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/url_probe_step.sql b/schema/spacewalk/oracle/synonyms/url_probe_step.sql deleted file mode 100644 index 01b235e..0000000 --- a/schema/spacewalk/oracle/synonyms/url_probe_step.sql +++ /dev/null @@ -1,29 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special url_probe_step synonyms for monitoring backend code to function as is - -create or replace synonym url_probe_step for rhn_url_probe_step; -create or replace synonym url_probe_step_recid_seq for rhn_url_probe_step_recid_seq; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/oracle/synonyms/widget.sql b/schema/spacewalk/oracle/synonyms/widget.sql deleted file mode 100644 index bb8fd25..0000000 --- a/schema/spacewalk/oracle/synonyms/widget.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - ---create special widget synonyms for monitoring backend code to function as is - -create or replace synonym widget for rhn_widget; - --- --- ---Revision 1.1 2004/06/23 15:01:07 kja ---bugzilla 126465 -- fix synonyms for monitoring backend --- --- diff --git a/schema/spacewalk/rhnsat/poll/create_poll.sql b/schema/spacewalk/rhnsat/poll/create_poll.sql deleted file mode 100644 index 8472b62..0000000 --- a/schema/spacewalk/rhnsat/poll/create_poll.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- -(a)rhnPollState.sql -(a)rhnPoll.sql -(a)rhnPollChoice.sql -(a)rhnPollQuestion.sql -(a)rhnPollResponse.sql diff --git a/schema/spacewalk/rhnsat/poll/rhnPoll.sql b/schema/spacewalk/rhnsat/poll/rhnPoll.sql deleted file mode 100644 index e616443..0000000 --- a/schema/spacewalk/rhnsat/poll/rhnPoll.sql +++ /dev/null @@ -1,63 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create table -rhnPoll -( - id number - constraint rhn_poll_id_nn not null - constraint rhn_poll_id_pk primary key - using index tablespace rhn_ind - storage ( initial 40960 - next 507904 pctincrease 1 ), - name varchar2(512) - constraint rhn_poll_name_nn not null, - state_id number - constraint rhn_poll_sid_nn not null - constraint rhn_poll_sid_fk - references rhnPollState(id), - begin_date date default(sysdate) - constraint rhn_poll_begin_nn not null, - end_date date default(sysdate) - constraint rhn_poll_end_nn not null, - created date default(sysdate) - constraint rhn_poll_created_nn not null, - modified date default(sysdate) - constraint rhn_poll_modified_nn not null -) -storage ( initial 40960 next 5816320 pctincrease 1 ); - -create sequence rhn_poll_id_seq; - -create or replace trigger -rhn_poll_mod_trig -before insert or update on rhnPoll -for each row -begin - :new.modified := sysdate; -end; -/ -show errors - --- --- Revision 1.2 2001/12/10 22:29:27 pjones --- add poll state and begin/end dates --- --- Revision 1.1 2001/12/10 22:19:09 pjones --- initial checkin of user poll schema --- diff --git a/schema/spacewalk/rhnsat/poll/rhnPollChoice.sql b/schema/spacewalk/rhnsat/poll/rhnPollChoice.sql deleted file mode 100644 index 232335a..0000000 --- a/schema/spacewalk/rhnsat/poll/rhnPollChoice.sql +++ /dev/null @@ -1,62 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create table -rhnPollChoice -( - id number - constraint rhn_poll_choice_id_nn not null - constraint rhn_poll_choice_id_pk primary key - using index tablespace rhn_ind - storage ( initial 40960 - next 507904 pctincrease 1 ), - poll_id number - constraint rhn_poll_choice_pid_nn not null - constraint rhn_poll_choice_pid_fk - references rhnPoll(id), - text varchar2(512) - constraint rhn_poll_choice_text_nn not null, - position number, - created date default(sysdate) - constraint rhn_poll_choice_created_nn not null, - modified date default(sysdate) - constraint rhn_poll_choice_modified_nn not null -) -storage ( initial 40960 next 5816320 pctincrease 1 ); - -create sequence rhn_poll_choice_id_seq; - -create or replace trigger -rhn_poll_choice_mod_trig -before insert or update on rhnPoll -for each row -begin - :new.modified := sysdate; -end; -/ -show errors - --- --- Revision 1.2 2001/12/11 16:03:03 pjones --- add position on each of these. Note that it's nullable, so if somebody --- wanted to only specify which question came first, and not care about the --- rest, that'd work. --- --- Revision 1.1 2001/12/10 22:19:09 pjones --- initial checkin of user poll schema --- diff --git a/schema/spacewalk/rhnsat/poll/rhnPollQuestion.sql b/schema/spacewalk/rhnsat/poll/rhnPollQuestion.sql deleted file mode 100644 index 165c30d..0000000 --- a/schema/spacewalk/rhnsat/poll/rhnPollQuestion.sql +++ /dev/null @@ -1,73 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create table -rhnPollQuestion -( - id number - constraint rhn_poll_question_id_nn not null - constraint rhn_poll_question_id_pk primary key - using index tablespace rhn_ind - storage ( initial 40960 - next 507904 pctincrease 1 ), - poll_id number - constraint rhn_poll_question_pid_nn not null - constraint rhn_poll_question_pid_fk - references rhnPoll(id), - question_type number - constraint rhn_poll_question_type_nn not null - constraint rhn_poll_question_type_fk - referneces rhnPollQuestionType(id), - text varchar2(512) - constraint rhn_poll_question_name_nn not null, - position number, - created date default(sysdate) - constraint rhn_poll_question_created_nn not null, - modified date default(sysdate) - constraint rhn_poll_question_modified_nn not null -) -storage ( initial 40960 next 5816320 pctincrease 1 ); - -create sequence rhn_poll_question_id_seq; - -create or replace trigger -rhn_poll_question_mod_trig -before insert or update on rhnPoll -for each row -begin - :new.modified := sysdate; -end; -/ -show errors - --- --- Revision 1.3 2001/12/12 16:46:45 pjones --- add question type to rhnPollQuestion --- add rhnPollQuestionType --- add answer and remove poll_choice_id's not null on rhnPollResponse --- add verification trigger on rhnPollResponse --- fix values in rhnPollState --- --- Revision 1.2 2001/12/11 16:03:03 pjones --- add position on each of these. Note that it's nullable, so if somebody --- wanted to only specify which question came first, and not care about the --- rest, that'd work. --- --- Revision 1.1 2001/12/10 22:19:09 pjones --- initial checkin of user poll schema --- diff --git a/schema/spacewalk/rhnsat/poll/rhnPollQuestionType.sql b/schema/spacewalk/rhnsat/poll/rhnPollQuestionType.sql deleted file mode 100644 index b406a44..0000000 --- a/schema/spacewalk/rhnsat/poll/rhnPollQuestionType.sql +++ /dev/null @@ -1,51 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create table -rhnPollQuestionType -( - id number - constraint rhn_poll_questiontype_id_nn not null - constraint rhn_poll_questiontype_id_pk primary key - using index tablespace rhn_ind - storage ( initial 40960 - next 507904 pctincrease 1 ), - text varchar2(32) - constraint rhn_poll_questiontype_name_nn not null -) -storage ( initial 40960 next 5816320 pctincrease 1 ); - -insert into rhnPollState values (1,'TEXT'); -insert into rhnPollState values (2,'SINGLE CHOICE'); -insert into rhnPollState values (3,'SEVERAL CHOICES'); - - --- --- Revision 1.1 2001/12/12 16:46:45 pjones --- add question type to rhnPollQuestion --- add rhnPollQuestionType --- add answer and remove poll_choice_id's not null on rhnPollResponse --- add verification trigger on rhnPollResponse --- fix values in rhnPollState --- --- Revision 1.1 2001/12/10 22:29:27 pjones --- add poll state and begin/end dates --- --- Revision 1.1 2001/12/10 22:19:09 pjones --- initial checkin of user poll schema --- diff --git a/schema/spacewalk/rhnsat/poll/rhnPollResponse.sql b/schema/spacewalk/rhnsat/poll/rhnPollResponse.sql deleted file mode 100644 index cbd0c03..0000000 --- a/schema/spacewalk/rhnsat/poll/rhnPollResponse.sql +++ /dev/null @@ -1,78 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create table -rhnPollResponse -( - web_contact_id number - constraint rhn_poll_response_wcid_nn not null - constraint rhn_poll_response_wcid_fk - references web.web_contact(id), - poll_question_id number - constraint rhn_poll_response_pqid_nn not null - constraint rhn_poll_response_pqid_fk - references rhnPollQuestion(id), - poll_choice_id number - constraint rhn_poll_response_pcid_fk - references rhnPollChoice(id), - answer varchar2(4096), - created date default(sysdate) - constraint rhn_poll_response_created_nn not null, - modified date default(sysdate) - constraint rhn_poll_response_modified_nn not null -) -storage ( initial 40960 next 5816320 pctincrease 1 ); - -create sequence rhn_poll_response_id_seq; - -create or replace trigger -rhn_poll_response_mod_trig -before insert or update on rhnPoll -for each row - question rhnPollQuestion%ROWTYPE; -begin - :new.modified := sysdate; - select rpq.* - into question - from rhnPollQuestion rpq - where rpq.id = :new.poll_question_id; - if question.question_type == 1 and - (question.poll_choice_id is not null or - question.answer is null) then - raise VALUE_ERROR; - end if; - if question.question_type in (2,3) and - (question.answer is not null or - question.poll_choice_id is null) then - raise VALUE_ERROR; - end if; -end; -/ -show errors - --- --- Revision 1.2 2001/12/12 16:46:45 pjones --- add question type to rhnPollQuestion --- add rhnPollQuestionType --- add answer and remove poll_choice_id's not null on rhnPollResponse --- add verification trigger on rhnPollResponse --- fix values in rhnPollState --- --- Revision 1.1 2001/12/10 22:19:09 pjones --- initial checkin of user poll schema --- diff --git a/schema/spacewalk/rhnsat/poll/rhnPollState.sql b/schema/spacewalk/rhnsat/poll/rhnPollState.sql deleted file mode 100644 index ab3e9c0..0000000 --- a/schema/spacewalk/rhnsat/poll/rhnPollState.sql +++ /dev/null @@ -1,51 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- - -create table -rhnPollState -( - id number - constraint rhn_poll_state_id_nn not null - constraint rhn_poll_state_id_pk primary key - using index tablespace rhn_ind - storage ( initial 40960 - next 507904 pctincrease 1 ), - text varchar2(32) - constraint rhn_poll_state_name_nn not null -) -storage ( initial 40960 next 5816320 pctincrease 1 ); - -insert into rhnPollState values (1,'NEW'); -insert into rhnPollState values (2,'PUBLISHED'); -insert into rhnPollState values (3,'CLOSED'); - - --- --- Revision 1.2 2001/12/12 16:46:45 pjones --- add question type to rhnPollQuestion --- add rhnPollQuestionType --- add answer and remove poll_choice_id's not null on rhnPollResponse --- add verification trigger on rhnPollResponse --- fix values in rhnPollState --- --- Revision 1.1 2001/12/10 22:29:27 pjones --- add poll state and begin/end dates --- --- Revision 1.1 2001/12/10 22:19:09 pjones --- initial checkin of user poll schema --- diff --git a/schema/spacewalk/rhnsat/quit.sql b/schema/spacewalk/rhnsat/quit.sql deleted file mode 100644 index b3ca817..0000000 --- a/schema/spacewalk/rhnsat/quit.sql +++ /dev/null @@ -1,15 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- -quit; diff --git a/schema/spacewalk/rhnsat/start.sql b/schema/spacewalk/rhnsat/start.sql deleted file mode 100644 index f159e71..0000000 --- a/schema/spacewalk/rhnsat/start.sql +++ /dev/null @@ -1,15 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- -whenever sqlerror exit failure; diff --git a/schema/spacewalk/rhnsat/tables/Makefile.deps b/schema/spacewalk/rhnsat/tables/Makefile.deps deleted file mode 100644 index a740286..0000000 --- a/schema/spacewalk/rhnsat/tables/Makefile.deps +++ /dev/null @@ -1,380 +0,0 @@ -# Dependencies for objects in the rhn/tables directory -# -# - -all :: - -PXTSessions :: web_contact - -rhnAction :: rhnActionType web_customer web_contact -rhnActionScript :: rhnAction -rhnActionClientOptions :: rhnAction rhnClientConfigOption -rhnActionConfigChannel :: rhnServerAction rhnConfigChannel -rhnActionConfigDate :: rhnAction -rhnActionConfigDateFile :: rhnAction -rhnActionConfigFileName :: rhnServerAction rhnConfigFileName rhnConfigFileFailure \ - rhnConfigRevision -rhnActionConfigRevision :: rhnAction rhnServer rhnConfigRevision rhnConfigFileFailure -rhnActionConfigRevisionResult:: rhnActionConfigRevision -rhnActionDaemonConfig :: rhnAction -rhnActionErrataUpdate :: rhnAction rhnErrata -rhnActionKickstart :: rhnAction rhnKickstartableTree -rhnActionKickstartFileList :: rhnActionKickstart rhnFileList -rhnActionKickstartGuest :: rhnActionKickstart rhnKickstartSession rhnKickstartableTree -rhnActionPackage :: rhnPackage rhnPackageName rhnPackageArch rhnAction -rhnActionPackageAnswerfile :: rhnActionPackage -rhnActionPackageDelta :: rhnPackageDelta -rhnActionPackageOrder :: rhnActionPackage -rhnActionPackageRemovalFailure :: rhnServer rhnAction rhnPackageName \ - rhnPackageEVR rhnPackageCapability -rhnActionTransactions :: rhnAction rhnTransaction -rhnActionVerifyResult :: rhnAction rhnPackageName rhnPackageEVR \ - rhnPackageCapability -rhnActivationKey :: rhnRegToken rhnKickstartSession -rhnArchTypeActions :: rhnArchType rhnActionType -rhnArchTypeActions_data :: rhnArchType_data rhnActionType_data -rhnAppInstallSession :: rhnAppInstallInstance -rhnAppInstallSessionData :: rhnAppInstallSession - -rhnBlacklistObsoletes :: rhnChannel rhnPackageName rhnChannelPackage \ - rhnPackage -rhnBlacklistObsoletes_data :: lookup_functions - -rhnCache :: rhnCacheKey -# rhnCacheKey is a a file, but it can be ignored in certain environments -# (satellite); add a dummy rule to prevent the precompiler from freaking out -rhnCacheKey :: -rhnCacheTimestamps :: rhnCacheKey rhnCache -rhnChannel :: web_customer rhnChannelArch rhnChannelProduct rhnProductName -rhnChannel_triggers :: rhnChannel lookup_functions rhnSnapshot -rhnChannelArch :: rhnArchType -rhnChannelArch_data :: lookup_arch_type -rhnChannelDownloads :: rhnChannel rhnDownloads -rhnChannelComps :: rhnChannel -rhnChannelCloned :: rhnChannelComps -rhnChannelErrata :: rhnChannel rhnErrata -rhnChannelFamily :: web_customer -rhnChannelFamilyLicenseConsent :: rhnChannelFamily web_contact rhnServer -rhnChannelFamilyMembers :: rhnChannel rhnChannelFamily -rhnChannelFamilyVirtSubLevel :: rhnChannelFamily rhnVirtSubLevel -rhnPrivateChannelFamily :: web_customer rhnChannelFamily -rhnPublicChannelFamily :: rhnChannelFamily -rhnChannelPackage :: rhnChannel rhnPackage -rhnChannelPackage_triggers :: rhnChannelPackage rhnSnapshot rhnChannel \ - lookup_functions rhnSnapshotChannel -rhnChannelPackageArchCompat :: rhnPackageArch rhnChannelArch -rhnChannelPackageArchCompat_data :: lookup_functions rhnChannelArch_data \ - rhnPackageArch_data -rhnChannelPermission :: rhnChannelPermissionRole rhnChannel web_contact -rhnChannelRelationship :: rhnRelationshipType rhnChannel -rhnChannelTrust :: rhnChannel -rhnChannel_triggers :: rhnChannelTrust -rhnClientCapability :: rhnClientCapabilityName -rhnClientOptionVersionMap :: rhnClientConfigOption rhnPackageEVR -rhnConfigFile :: rhnConfigChannel rhnConfigFileState rhnConfigFileName -rhnConfigFile_foreignkeys:: rhnConfigRevision -rhnConfigChannel :: web_customer rhnConfigChannelType -rhnConfigChannel_triggers :: rhnConfigChannel rhnSnapshotConfigChannel \ - rhnSnapshot lookup_functions -rhnConfigRevision :: rhnConfigFile rhnConfigInfo rhnConfigContent rhnConfigFileType -rhnConfigRevision_triggers:: rhnConfigRevision rhnSnapshotConfigRevision \ - rhnSnapshot lookup_functions rhn_quota_HEAD \ - rhnConfigContent rhnConfigChannel rhnConfigFile \ - rhnOrgQuota rhn_exception_HEAD -rhnCpu :: rhnServer rhnCpuArch -rhnCryptoKey :: rhnCryptoKeyType -rhnCryptoKeyKickstart :: rhnCryptoKey rhnKSData - -rhnDemoEntitlementStopDate_data :: rhnDemoEntitlementStopDate -rhnDevice :: rhnServer -rhnDistChannelMap :: rhnChannel rhnChannelArch -rhnDownloads :: rhnChannelFamily rhnFile rhnDownloadType - -rhnDumpSnapshotChannel :: rhnDumpSnapshot rhnChannel -rhnDumpSnapshotChannelErrata :: rhnDumpSnapshotChannel rhnErrata -rhnDumpSnapshotChannelPackage :: rhnDumpSnapshotChannel rhnPackage -rhnDumpSnapshotChannelPkgSrc :: rhnDumpSnapshotChannel rhnPackageSource -rhnDumpSnapshotChannelKSTree :: rhnDumpSnapshotChannel rhnKickstartableTree -rhnEmailAddress :: rhnEmailAddressState web_contact -rhnEntitlementQueue :: web_customer -rhnErrata :: web_customer rhnErrataSeverity -rhnErrata_triggers :: rhnChannel rhnChannelErrata -rhnErrataBuglist :: rhnErrata -rhnErrataBuglistTmp :: rhnErrataTmp -rhnErrataCVE :: rhnErrata rhnCVE -rhnErrataCVETmp :: rhnErrataTmp rhnCVE -rhnErrataFile :: rhnErrata rhnErrataFileType lookup_functions -rhnErrataFileChannel :: rhnChannel rhnErrataFile rhnChannelErrata -rhnErrataFilePackage :: rhnPackage rhnErrataFile rhnErrataPackage -rhnErrataFilePackageSource :: rhnErrataFile rhnPackageSource rhnErrataPackage -rhnErrataFileTmp :: rhnErrataTmp rhnErrataFileType lookup_functions -rhnErrataFileChannelTmp :: rhnErrataFileTmp rhnChannel -rhnErrataFilePackageTmp :: rhnErrataFileTmp rhnChannel -rhnErrataKeyword :: rhnErrata -rhnErrataKeywordTmp :: rhnErrataTmp -rhnErrataPackage :: rhnPackage rhnErrata -rhnErrataPackageTmp :: rhnPackage rhnErrataTmp -rhnErrataRelationship :: rhnRelationshipType rhnErrata -rhnErrataRelationshipTmp :: rhnRelationshipType rhnErrataTmp rhnErrata -rhnErrataTmp :: web_customer - -rhnFAQ :: rhnFAQClass -rhnFAQ_satdata :: rhnFAQClass_data -rhnFile :: web_customer -rhnFileLocation :: rhnFile - -rhnGrailComponents :: rhnUserGroupType -rhnGrailComponentChoices :: web_contact - -rhnKSData :: web_customer -rhnKickstartableTree :: rhnChannel rhnKSTreeType web_customer \ - rhnKSInstallType -rhnKickstartCommand :: rhnKSData rhnKickstartCommandName -rhnKickstartDefaults :: rhnKSData rhnKickstartableTree rhnServerProfile \ - rhnKickstartVirtualizationType -rhnKickstartDefaultRegToken :: rhnKSData rhnRegToken -rhnKickstartPackages :: rhnPackageName rhnKSData -rhnKickstartPreserveFileList :: rhnKSData rhnFileList -rhnKickstartScript :: rhnKSData -rhnKickstartSession :: rhnKSData web_customer rhnServer rhnAction \ - rhnKickstartSessionState rhnServerProfile \ - rhnKickstartVirtualizationType -rhnKickstartSession_triggers :: rhnKickstartSession rhnKickstartSessionHistory -rhnKickstartSessionHistory :: rhnKickstartSession rhnKickstartSessionState -rhnKSTreeFile :: rhnKickstartableTree rhnChannelErrata rhnErrata -rhnKSRawData :: rhnKSData -rhnKickstartTimezone :: rhnKSInstallType -rhnKickstartTimezone_data :: rhnKSInstallType_data -rhnMessage :: rhnMessageType rhnMessagePriority -rhnMonitor :: rhnServer rhnMonitorGranularity - -rhnOrgChannelSettings :: web_customer rhnChannel rhnOrgChannelSettingsType -rhnOrgEntitlements :: rhnOrgEntitlementType -rhnOrgErrataCacheQueue :: web_customer -rhnOrgInfo :: rhnServerGroupType -rhnOrgState :: rhnOrgAvailableStates web_customer -rhnOrgState_triggers :: rhn_bel -rhnOrgStateTransitions :: rhnOrgAvailableStates -rhnOrgQuota :: web_customer - -rhnPackage :: rhnPackageName rhnPackageEVR rhnPackageArch \ - rhnPackageGroup rhnSourceRPM web_customer -rhnPackageArch :: rhnArchType -rhnPackageArch_data :: lookup_arch_type -rhnPackageDeltaElement :: rhnPackageDelta rhnTransactionPackage -rhnPackageEVR :: evr_t -rhnPackageChangelog :: rhnPackage -rhnPackageConflicts :: rhnPackage rhnPackageCapability -rhnPackageFile :: rhnPackage rhnPackageCapability -rhnPackageKeyAssociation :: rhnPackageKey rhnPackage -rhnPackageKey :: rhnPackageKeyType rhnPackageProvider -rhnPackageKey_data :: rhnPackageKey rhnPackageProvider lookup_package_provider lookup_package_key_type rhnPackageKeyType_data rhnPackageProvider_data -rhnPackageProvider_data :: rhnPackageProvider -rhnPackageKeyType_data :: rhnPackageKeyType -rhnPackageObsoletes :: rhnPackage rhnPackageCapability -rhnPackageNEVRA :: rhnPackageName rhnPackageEVR rhnPackageArch -rhnPackageProvides :: rhnPackage rhnPackageCapability -rhnPackageRequires :: rhnPackage rhnPackageCapability -rhnPackageSenseMap :: rhnPackageSense -rhnPackageSource :: web_customer rhnSourceRPM rhnFile rhnPackageGroup -rhnPackageSyncBlacklist :: rhnPackageName web_customer -rhnPathChannelMap :: rhnChannel -rhnProduct :: rhnProductLine -rhnProductChannel :: rhnChannel rhnProduct -rhnProxyInfo :: rhnServer -rhnPushClient :: rhnServer rhnPushClientState - -rhnRam :: rhnServer -rhnRegToken :: rhnServerGroupType -rhnRegTokenChannels :: rhnRegToken rhnChannel -rhnRegTokenConfigChannels:: rhnRegToken rhnConfigChannel -rhnRegTokenEntitlement :: rhnRegToken rhnServerGroupType -rhnRegTokenGroups :: rhnRegToken rhnServerGroup -rhnRegTokenPackages :: rhnRegToken rhnPackageName -rhnRepoRegenQueue :: rhnSatelliteCert rhnSatelliteChannelFamily rhnSatelliteInfo -rhnRevision :: rhnConfigFile rhnConfigContent rhnConfigInfo - -rhnSatelliteInfo :: rhnServer -rhnSatelliteServerGroup :: rhnServer rhnServerGroup -rhnSavedSearch :: rhnSavedSearchType web_contact -rhnServer :: rhnServerArch web_contact web_customer \ - rhnProvisionState -rhnServerAction :: rhnServer rhnAction rhnActionStatus -rhnServerActionPackageResult :: rhnActionPackage -rhnServerActionScriptResult :: rhnActionScript rhnServer -rhnServerArch :: rhnArchType -rhnServerArch_data :: lookup_arch_type -rhnServerChannel :: rhnServer rhnChannel -rhnServerChannelArchCompat :: rhnServerArch rhnChannelArch -rhnServerChannelArchCompat_data :: lookup_functions -rhnServerConfigChannel :: rhnServer rhnConfigChannel -rhnServerCustomDataValue :: rhnCustomDataKey -rhnServerDMI :: rhnServer -rhnServerGroup :: rhnServerGroupType web_customer rhn_exception -rhnServerGroup_triggers :: rhnUserGroup rhnUserGroupType rhn_exception \ - lookup_functions rhnSnapshot rhnServerGroup \ - rhnSnapshotServerGroup -rhnServerGroupMembers :: rhnServer rhnServerGroup rhn_exception -rhnServerGroupNotes :: web_contact rhnServerGroup -rhnServerGroupTypeFeature :: rhnFeature rhnServerGroupType -rhnServerGroupTypeFeature_data :: rhnFeature_data rhnServerGroupType_data lookup_sg_type lookup_feature_type -rhnServerHistory :: rhnServer -rhnServerInfo :: rhnServer -rhnServerUuid :: rhnServer -rhnServerInstallInfo :: rhnServer -rhnServerLocation :: rhnServer -rhnServerNeededCache :: web_customer rhnServer rhnErrata -rhnServerNetwork :: rhnServer -rhnServerNotes :: rhnServer web_contact -rhnServerPackage :: rhnServer rhnPackageArch rhnPackageName rhnPackageEVR -rhnServerPackageArchCompat :: rhnPackageArch rhnServerArch -rhnServerPath :: rhnServer -rhnServerPrefs :: rhnServer -rhnServerPreserveFileList :: rhnServer rhnFileList -rhnServerProfile :: web_customer rhnChannel rhnServerProfileType -rhnServerProfilePackage :: rhnServerProfile rhnPackageName rhnPackageEVR -rhnServerTokenRegs :: rhnRegToken rhnServer -rhnServerServerGroupArchCompat :: rhnServerGroupType rhnServerArch -rhnServerServerGroupArchCompat_data :: lookup_functions - -rhnServiceChannelFamilyMap :: rh_product -rhnServiceServerGroupMap :: rh_product rhnServerGroupType -rhnSet :: web_contact -rhnSGTypeBaseAddonCompat :: rhnServerGroupType -rhnSGTypeBaseAddonCompat_data :: rhnServerGroupType_data -rhnSGTypeVirtSubLevel :: rhnServerGroupType rhnVirtSubLevel -rhnSGTypeVirtSubLevel_data :: lookup_virt_sub_level rhnServerGroupType_data \ - rhnVirtSubLevel_data -rhnSnapshot :: web_customer rhnSnapshotInvalidReason -rhnSnapshotChannel :: rhnSnapshot rhnChannel -rhnSnapshotConfigChannel:: rhnSnapshot rhnConfigChannel -rhnSnapshotConfigChannel_triggers:: rhnSnapshot rhnConfigChannel -rhnSnapshotConfigRevision:: rhnSnapshot rhnConfigRevision -rhnSnapshotPackage :: rhnSnapshot -rhnSnapshotServerGroup :: rhnServerGroup rhnSnapshot -rhnSnapshotTag :: rhnSnapshot rhnTag -rhnSNPErrataQueue :: rhnErrata -rhnSNPServerQueue :: rhnServer -rhnSolarisPackage :: rhnPackage -rhnSolarisPatch :: rhnPackage rhnSolarisPatchType -rhnSolarisPatchPackages :: rhnPackage rhnPackageNEVRA -rhnSolarisPatchedPackages :: rhnPackage rhnPackageNEVRA rhnServer -rhnSolarisPatchSetMembers :: rhnPackage rhnSolarisPatchSet -rhnSsmOperationServer :: rhnSsmOperation -rhnSurveyQuestionResponse :: rhnSurveyQuestion -rhnSurveyQuestion :: rhnSurvey - -rhnTag :: rhnTagName web_customer -rhnTransaction :: rhnServer -rhnTransactionElement :: rhnTransactionPackage rhnTransaction -rhnTransactionPackage :: rhnTransactionOperation rhnPackageArch \ - rhnPackageEVR rhnPackageName - -rhnUserFeedback :: web_contact -rhnUserGroupMembers :: web_contact rhnUserGroup -rhnUserGroup :: web_customer rhnUserGroupType -rhnUserInfo :: web_contact rhnTimezone -rhnUserInfo_triggers :: rhnTimezone rhn_contact_methods -rhnUserInfoPane :: rhnInfoPane web_contact -rhnUserServerGroupPerms :: web_contact rhnServerGroup -rhnUserServerPerms :: web_contact rhnServer -rhnUserServerPrefs :: web_contact rhnServer -rhnUserMessage :: web_contact rhnMessage rhnUserMessageStatus -rhnUserSurveyStatus :: rhnUserSurveyStatusType - -rhnVersionInfo :: rhnPackageName rhnPackageEVR -rhnVersionInfo_data :: lookup_functions - -rhnVirtualInstance :: rhnServer -rhnVirtualInstanceInfo :: rhnVirtualInstance rhnVirtualInstanceType \ - rhnVirtualInstanceState -rhnVirtualInstanceInstallLog :: rhnKickstartSession -rhnVirtualInstanceEventLog :: rhnVirtualInstance rhnVirtualInstanceEventType \ - rhnVirtualInstanceState - -rhnVisibleObjects :: PXTSessions -rhnIndexerWork :: - -rhnWebContactChangeLog :: rhnWebContactChangeState - -rhn_channel_cloned_comps_trig :: rhnChannelComps - -rhn_check_probe :: rhnServer rhn_probe rhn_sat_cluster -rhn_check_suite_probe :: rhn_check_suites -rhn_check_suites :: web_customer -rhn_command :: rhn_command_groups rhn_command_class \ - rhn_command_requirements -rhn_command_data :: rhn_command_groups_data rhn_command_class_data \ - rhn_command_requirements_data -rhn_command_parameter :: rhn_command rhn_widget rhn_semantic_data_type -rhn_command_parameter_data :: \ - rhn_semantic_data_type rhn_widget_data \ - rhn_command_data rhn_semantic_data_type_data -rhn_command_param_threshold :: \ - rhn_command rhn_metrics rhn_threshold_type -rhn_command_param_threshold_data :: \ - rhn_command_data rhn_metrics_data \ - rhn_threshold_type_data -rhn_command_queue_execs :: rhn_command_queue_instances rhn_command_target -rhn_command_queue_instances :: \ - rhn_command_queue_commands -rhn_command_queue_params:: rhn_command_queue_instances -rhn_command_queue_sessions :: \ - web_contact -rhn_command_target :: web_customer -rhn_config_macro :: rhn_environment -rhn_config_macro_data :: rhn_environment_data -rhn_config_parameter :: rhn_config_group rhn_config_security_type -rhn_config_parameter_data :: \ - rhn_config_group_data rhn_config_security_type_data -rhn_contact_group_members :: \ - rhn_contact_methods rhn_contact_groups -rhn_contact_groups :: web_customer rhn_strategies rhn_notification_formats -rhn_contact_methods :: web_contact rhn_method_types rhn_pager_types \ - rhn_sat_cluster rhn_schedules rhn_time_zone_names \ - rhn_notification_formats rhnTimezone rhnUserInfo -rhn_db_environment :: rhn_environment -rhn_db_environment_data :: rhn_environment_data -rhn_host_check_suites :: rhn_check_suites rhn_host_probe -rhn_host_monitoring :: rhn_server_monitoring_info rhn_interface_monitoring -rhn_host_probe :: rhnServer rhn_probe rhn_sat_cluster -rhn_interface_monitoring:: rhnServerNetInterface -rhn_ll_netsaint :: rhn_sat_cluster -rhn_metrics :: rhn_command_class rhn_units -rhn_metrics_data :: rhn_command_class_data rhn_units_data -rhn_notification_formats:: web_customer -rhn_os_commands_xref :: rhn_command rhn_os -rhn_os_commands_xref_data :: rhn_command_data rhn_os_data -rhn_probe :: rhn_command web_customer rhn_probe_types -rhn_probe_param_value :: rhn_probe rhn_command_parameter -rhn_redirect_criteria :: rhn_redirects rhn_redirect_match_types -rhn_redirect_email_targets :: rhn_redirects -rhn_redirect_group_targets :: rhn_contact_groups rhn_redirects -rhn_redirect_method_targets :: rhn_contact_methods rhn_redirects -rhn_redirects :: web_contact web_customer rhn_redirect_types -rhn_sat_cluster :: rhn_command_target web_customer rhn_physical_location -rhn_sat_cluster_probe :: rhn_probe rhn_sat_cluster -rhn_sat_node :: rhn_command_target rhn_sat_cluster -rhn_sat_node_probe :: rhn_probe rhn_sat_node -rhn_schedule_days :: rhn_schedules -rhn_schedule_days_data :: rhn_schedules_data -rhn_schedules :: web_customer rhn_schedule_types -rhn_schedules_data :: rhn_schedule_types_data -rhn_schedule_weeks :: rhn_schedules -rhn_server_monitoring_info :: \ - rhnServer rhn_os -rhn_service_probe_origins :: \ - rhn_check_suite_probe rhn_probe -rhn_snmp_alert :: rhn_sat_cluster -rhn_units :: rhn_quanta -rhn_units_data :: rhn_quanta_data -rhn_url_probe :: rhn_probe -rhn_url_probe_step :: rhn_url_probe -web_contact :: web_customer -web_user_contact_permission :: web_contact -web_user_site_info :: web_contact web_user_site_type -web_user_personal_info :: web_contact web_user_prefix -web_contact_triggers :: web_contact -web_customer_product :: rh_product web_product_valid_numbers - -$(TOP)/rhn/quit.sql :: rhnConfigFile_foreignkeys diff --git a/schema/spacewalk/rhnsat/tables/rhnVersionInfo_data.pre b/schema/spacewalk/rhnsat/tables/rhnVersionInfo_data.pre deleted file mode 100644 index 2934e95..0000000 --- a/schema/spacewalk/rhnsat/tables/rhnVersionInfo_data.pre +++ /dev/null @@ -1,33 +0,0 @@ --- --- --- --- this populates rhnVersionInfo. It needs to be run through cpp --- during build. see Makefile.schema - -delete -from rhnVersionInfo -where label = 'schema' - and name_id = lookup_package_name(SCHEMA_NAME); - -insert into rhnVersionInfo( - label, - name_id, - evr_id -) ( - select 'schema', - lookup_package_name(SCHEMA_NAME), - lookup_evr(null, SCHEMA_VERSION , SCHEMA_RELEASE ) - from dual -); -commit; - --- --- Revision 1.2 2003/04/28 20:56:21 pjones --- make it delete rhnVersionInfo data for schema with name rhn-satellite-schema --- before populating --- --- Revision 1.1 2002/06/06 19:39:23 pjones --- make rhnVersionInfo get populated again. --- --- This is a bit cleaner than the old Makefile.sat way. --- diff --git a/schema/spacewalk/rhnsat/types/Makefile.deps b/schema/spacewalk/rhnsat/types/Makefile.deps deleted file mode 100644 index a5c0c19..0000000 --- a/schema/spacewalk/rhnsat/types/Makefile.deps +++ /dev/null @@ -1,6 +0,0 @@ -# Dependencies for objects in the rhn/tables directory -# -# - -all :: - diff --git a/schema/spacewalk/rhnsat/views/Makefile b/schema/spacewalk/rhnsat/views/Makefile deleted file mode 100644 index 5d5343b..0000000 --- a/schema/spacewalk/rhnsat/views/Makefile +++ /dev/null @@ -1,8 +0,0 @@ -# Makefile for the views SQL directory -# -# - -all:: - -clean :: - rm -fv *~ diff --git a/schema/spacewalk/rhnsat/views/Makefile.deps b/schema/spacewalk/rhnsat/views/Makefile.deps deleted file mode 100644 index 0923447..0000000 --- a/schema/spacewalk/rhnsat/views/Makefile.deps +++ /dev/null @@ -1,154 +0,0 @@ -# Dependencies for the rhn/views directory -# -# - -all :: - -rhnActionOverview :: rhnAction rhnActionType web_contact -rhnAvailableChannels :: rhnServer \ - rhnServerChannel \ - rhnOrgChannelTreeView \ - rhnSharedChannelTreeView \ - rhn_channel_HEAD -rhnCDDevice :: rhnDevice -rhnChannelFamilyServerPhysical :: rhnServerEntitlementView \ - rhnChannelFamilyVirtSubLevel \ - rhnSGTypeVirtSubLevel \ - rhnVirtualInstance \ - rhnChannelFamilyMembers \ - rhnServerChannel \ - rhnServer -rhnChannelFamilyServerVirtual :: rhnServerEntitlementView \ - rhnChannelFamilyVirtSubLevel \ - rhnSGTypeVirtSubLevel \ - rhnVirtualInstance \ - rhnChannelFamilyMembers \ - rhnServerChannel \ - rhnServer -hnChannelFamilyOverview :: rhnPrivateChannelFamily rhnChannelFamily -rhnChannelFamilyPermissions :: rhnPublicChannelFamily \ - rhnPrivateChannelFamily -rhnChannelFamilyServers :: rhnChannelFamilyMembers rhnChannelFamily \ - rhnServerChannel rhnServer -rhnChannelPackageOverview :: rhnChannelPackage rhnPackageEVR rhnPackage -rhnChannelPermissions :: rhnChannelFamilyMembers rhnPrivateChannelFamily \ - rhnPublicChannelFamily web_contact -rhnChannelTreeView :: rhnChannel rhnChannelFamilyMembers \ - rhnChannelFamilyPermissions -rhnDemoOrgs :: demo_log -rhnEntitledServers :: rhnServerGroup rhnServerGroupType \ - rhnServerGroupMembers rhnServer -rhnExpiringTrialMail :: rhnServerGroupType rh_product \ - web_user_site_info web_user_personal_info \ - web_user_contact_permission web_contact \ - rhnUserGroupMembers rhnUserGroup \ - rhnServiceServerGroupMap \ - web_customer_product web_cp_service_line -rhnFreeErrataMail :: rhnChannelErrata rhnServerChannel \ - rhnServerGroupMembers rhnServerGroup \ - rhnServer web_contact rhnErrata \ - web_user_personal_info rhnUserInfo \ - rhnErrata rhnServerArch rhnUserServerPrefs \ - rhnUserGroupType rhnUserGroup \ - rhnUserGroupMembers rhnServerGroupMembers \ - rhnUserServerGroupPerms -rhnHistoryView :: rhnServerHistory rhnPackageArch \ - rhnPackageName rhnPackageEVR \ - rhnActionPackage -rhnHWDevice :: rhnDevice -rhnOrgChannelTreeView :: rhnChannel rhnChannelFamilyMembers \ - rhnOrgChannelFamilyPermissions -rhnOrgChannelFamilyPermissions :: rhnPublicChannelFamily web_contact \ - rhnPrivateChannelFamily -rhnOrgErrata :: rhnChannelErrata rhnAvailableChannels -rhnOrgPackageOverview :: rhnPackageName rhnPackageEVR rhnPackageArch \ - rhnChannelPackageArchCompat rhnPackage \ - rhn_package -rhnPaidOrgs :: rhnDemoOrgs rhnServerGroup -rhnPrivateErrataMail :: rhnFreeErrataMail rhnServerPackage \ - rhnWebContactDisabled -rhnServerEntitledView :: rhnServerGroupType rhnServerGroup \ - rhnServerGroupMembers -rhnServerErrataTypeView :: rhnErrata rhnServerNeededPackageCache -rhnServerFeaturesView :: rhnFeature rhnServerGroupTypeFeature \ - rhnServerGroupMembers rhnServerGroup -rhnServerGroupMembership :: rhnServerGroupType rhnServerGroupMembers \ - rhnServerGroup -rhnServerGroupOverview :: rhnErrata rhnUserManagedServerGroups \ - rhnServerGroupMembers rhnServerGroup rhnServerFeaturesView -rhnServerGroupOVLiteHelper :: rhnServerNeededPackageCache rhnErrata \ - rhnServerGroupMembers -rhnServerErrataTypeView :: rhnServerNeededErrataCache -rhnServerNeededPackageView :: rhnPackage rhnPackageEVR rhnErrataPackage \ - rhnServerPackage rhnServerPackageArchCompat \ - rhnChannelPackage rhnServerChannel \ - rhnServer rhnChannelErrata -rhnServerOutdatedPackages :: rhnServerNeededPackageCache rhnErrata \ - rhnPackageName rhnPackageEVR rhnPackage -rhnServerOverview :: rhnUserServerPerms \ - rhnChannel rhnVisibleServerGroupMembers \ - rhnServerChannel rhnServerHistory \ - rhnPackage rhnServerNeededPackageCache \ - rhn_entitlements -rhnServiceLineChannelView :: web_customer_product web_cp_service_line \ - rhnServiceChannelFamilyMap -rhnServiceLineServerGroup :: web_customer_product web_cp_service_line \ - rhnServerGroupType rhnServiceServerGroupMap -rhnServiceLineUserGroup :: web_customer_product web_cp_service_line \ - rhnUserGroupType rhnServiceUserGroupMap -rhnServices :: rhnServiceChannelFamilyMap \ - rhnServiceServerGroupMap \ - rhnServiceUserGroupMap -rhnStorageDevice :: rhnDevice -rhnUserAvailableChannels :: rhn_channel_HEAD rhnServerChannel \ - rhnUserChannelTreeView rhnUserServerPerms -rhnUserAvailableUpgrades :: rhnServiceServerGroupMap rhnServerGroupType \ - web_customer_product -rhnUserChannel :: rhn_channel_HEAD rhnChannelFamilyMembers \ - rhnUserChannelFamilyPerms web_contact -rhnUserChannelFamilyPerms :: rhnPrivateChannelFamily \ - rhnPublicChannelFamily web_contact -rhnUserChannelTreeView :: rhnChannel rhnChannelFamilyMembers \ - rhnUserChannelFamilyPerms -rhnUserGroupMembership :: rhnUserGroupType rhnUserGroup \ - rhnUserGroupMembers -rhnUserManagedServerGroups :: rhnServerGroup rhnServerGroupType \ - rhnUserGroup rhnUserGroupMembers web_contact -rhnUserServerPermsDupes :: rhnServerGroupMembers rhnUserGroup \ - rhnUserServerGroupPerms rhnUserGroupType \ - rhnUserGroupMembers rhnServer -rhnUserTypeArray :: web_contact rhnUserTypeBase \ - user_group_name_t user_group_label_t \ - user_group_id_t -rhnUserTypeBase :: rhnUserGroupMembers rhnUserGroupType \ - rhnUserGroup -rhnUserTypeCommaView :: rhnUserTypeArray name_join label_join \ - id_join -rhnUsersInOrgOverview :: rhnUserServerPerms web_contact \ - rhnUserManagedServerGroups \ - rhnVisibleServerGroup rhnUserTypeCommaView \ - web_user_site_info web_user_personal_info -rhnVisServerGroupMembership :: rhnServerGroupType rhnServerGroupMembers \ - rhnVisibleServerGroup -rhnVisServerGroupOverview :: rhnErrata rhnServerNeededPackageCache \ - rhnServerGroupMembers \ - rhnUserManagedServerGroups \ - rhnServerGroupMembers rhnVisibleServerGroup -rhnVisServerGroupOverviewLite :: rhnVisibleServerGroup rhnServerGroupMembers \ - rhnUserManagedServerGroups \ - rhnServerGroupOVLiteHelper -rhnVisibleServerGroup :: rhnServerGroup -rhnVisibleServerGroupMembers :: rhnServerGroup rhnServerGroupMembers - -rhnWebContactDisabled :: rhnWebContactChangeLog rhnWebContactChangeState web_contact -rhnWebContactEnabled :: rhnWebContactDisabled - -rhn_contact_monitoring :: web_contact web_user_personal_info -rhn_customer_monitoring :: web_customer -rhn_host_monitoring :: rhnServer rhnServerNetInterface \ - rhn_interface_monitoring \ - rhn_server_monitoring_info -web_customer_orders :: web_user_order web_user_order_line \ - rh_product web_customer_product web_contact -rhnSharedChannelView :: rhnChannel rhnChannelTrust rhnTrustedOrgs -rhnSharedChannelTreeView :: rhnSharedChannelView

1 0

backend/satellite_tools
by Jesus M. Rodriguez 02 Apr '09

02 Apr '09

backend/satellite_tools/satCerts.py | 22 ++++++++++++++++++---- 1 file changed, 18 insertions(+), 4 deletions(-) New commits: commit 77b45bd45c371d7e0231c5004c3463fb9d5b6c2b Author: Pradeep Kilambi <pkilambi(a)redhat.com> Date: Thu Apr 2 10:54:35 2009 -0400 adding some additional checks before creating first org info diff --git a/backend/satellite_tools/satCerts.py b/backend/satellite_tools/satCerts.py index 101c43a..f542dc0 100644 --- a/backend/satellite_tools/satCerts.py +++ b/backend/satellite_tools/satCerts.py @@ -544,6 +544,16 @@ def create_first_private_chan_family(): Check to see if org has a channelfamily associated with it. If not, Create one. """ + _lookup_chfam = """ + SELECT 1 from rhnChannelFamily + WHERE label='private-channel-family-1' + """ + h = rhnSQL.prepare(_lookup_chfam) + row = h.execute() + # some extra check for upgrades + if row: + # Already exists, move on + return _query_create_chfam = """ INSERT INTO rhnChannelFamily (id, name, label, org_id, product_url) @@ -551,10 +561,14 @@ def create_first_private_chan_family(): """ h = rhnSQL.prepare(_query_create_chfam) - h.execute(name="Private Channel Family 1", \ - label="private-channel-family-1", \ - org=1, url="First Org Created") - + try: + h.execute(name='Private Channel Family 1', \ + label='private-channel-family-1', \ + org=1, url='First Org Created') + except rhnSQL.SQLError, e: + # if we're here that means we're voilating something + raise e + def verify_family_permissions(orgid=1): """

1 0

Branch 'schemasandbox' - 2 commits - schema/spacewalk schema/util
by Jeff Ortel 02 Apr '09

02 Apr '09

schema/spacewalk/README | 105 +++++++++++++++++++++++ schema/spacewalk/common/data/data.deps | 13 ++ schema/spacewalk/common/tables/tables.deps | 12 ++ schema/spacewalk/common/views/views.deps | 13 ++ schema/spacewalk/header.txt | 3 schema/spacewalk/oracle/Makefile | 38 ++++++++ schema/spacewalk/oracle/class/class.deps | 13 ++ schema/spacewalk/oracle/data/data.deps | 13 ++ schema/spacewalk/oracle/packages/packages.deps | 13 ++ schema/spacewalk/oracle/procs/procs.deps | 15 +++ schema/spacewalk/oracle/tables/tables.deps | 17 +++ schema/spacewalk/oracle/triggers/triggers.deps | 13 ++ schema/spacewalk/oracle/types/types.deps | 13 ++ schema/spacewalk/oracle/views/views.deps | 13 ++ schema/spacewalk/postgres/Makefile | 30 ++++++ schema/spacewalk/postgres/class/class.deps | 13 ++ schema/spacewalk/postgres/data/data.deps | 13 ++ schema/spacewalk/postgres/packages/packages.deps | 13 ++ schema/spacewalk/postgres/procs/procs.deps | 15 +++ schema/spacewalk/postgres/tables/tables.deps | 15 +++ schema/spacewalk/postgres/triggers/triggers.deps | 13 ++ schema/spacewalk/postgres/views/views.deps | 13 ++ schema/util/genmain.py | 19 ++++ 23 files changed, 418 insertions(+), 20 deletions(-) New commits: commit 7bfebb5990eab9cbb14a3af3107e8c6f470f6d37 Author: Jeff Ortel <jortel(a)redhat.com> Date: Thu Apr 2 10:53:12 2009 -0400 Update .deps header and comments; add README diff --git a/schema/spacewalk/README b/schema/spacewalk/README new file mode 100644 index 0000000..ede788b --- /dev/null +++ b/schema/spacewalk/README @@ -0,0 +1,105 @@ + + +DIRECTORIES +------------------------------------------------------------------------------- + +/schema/spacewalk +/schema/spacewalk/common - Common DDL +/schema/spacewalk/common/tables - Common DDL: table,index,sequences +/schema/spacewalk/common/data - Common SQL: INSERTs +/schema/spacewalk/common/views - Generic view DDL + +ORACLE: + +/schema/spacewalk/oracle - Oracle specific DDL +/schema/spacewalk/oracle/class - Oracle specific class DDL +/schema/spacewalk/oracle/types - Oracle specific types DDL +/schema/spacewalk/oracle/tables - Oracle specific table DDL +/schema/spacewalk/oracle/tables/common - Generated from common/tables +/schema/spacewalk/oracle/views - Oracle specific view DDL +/schema/spacewalk/oracle/views/common - Copied from common/views +/schema/spacewalk/oracle/data - Oracle specific INSERTs +/schema/spacewalk/oracle/data/common - Generated from common/data +/schema/spacewalk/oracle/triggers - Oracle specific trigger DDL +/schema/spacewalk/oracle/procs - PL/SQL procedures/functions DDL. +/schema/spacewalk/oracle/packages - PL/SQL packages DDL. + +POSTGRES: + +/schema/spacewalk/postgres - Postgres specific DDL +/schema/spacewalk/postgres/class - Postgres specific class DDL +/schema/spacewalk/postgres/types - Postgres specific types DDL +/schema/spacewalk/postgres/tables - Postgres specific table DDL +/schema/spacewalk/postgres/tables/common - Generated from common/tables +/schema/spacewalk/postgres/views - Postgres specific view DDL +/schema/spacewalk/postgres/views/common - Copied from common/views +/schema/spacewalk/postgres/data - Postgres specific INSERTs +/schema/spacewalk/postgres/data/common - Generated from common/data +/schema/spacewalk/postgres/triggers - Postgres specific trigger DDL +/schema/spacewalk/postgres/procs - PG/SQL procedures/functions DDL. +/schema/spacewalk/postgres/packages - PG/SQL packages DDL. + + +TOOLS +------------------------------------------------------------------------------- + +dogchow - Used to translate the common DDL to oracle|postgres specific + DDL. + +util/genmain.py - Used to generate the main.sql based on .deps files. + + +DEPENDENCY FILES (.deps) +------------------------------------------------------------------------------- + +Terms: + namespace - A root directory. + May be: (.|class|types|tables|views|procs|packages) + where (.) represents the current namesapce. + + qname - A qualified name. + May be: [namespace/]basename[.ext]. When the namespace + is not specified, the name is unqualified and resolved + using the "path". Using the extension is only necessary + when more then (1) file exists in a given namespace with + the same name but with different extensions. + +Format: + + path = {namespace}([\s,]+{namespace})* + + {qname} :: {qname}([\s,]+{qname})* + +Examples: + + path = . tables packages" + + rhnSharedChannelView :: rhnChannel procs/lookup_functions \ + rhn_channel.pks + + Assuming the current namespace (or directory) is /views. + The table dependency "rhnChannel" is unqualifed and would be searched + for in the following order: + 1st. views/rhnChannel + 2nd. tables/rhnChannel + 3rd. packages/rhnChannel + However, lookup_functions dependency is qualified by namespace so the + path will not be used. + The package header dependency "rhn_channel.pks" is unqualifed and but has + an extension and would be searched for in the following order: + 1st. views/rhn_channel.pks + 2nd. tables/rhn_channel.pks + 3rd. packages/rhn_channel.pks + +Lines may be joined by (\). + + +MAIN.SQL +------------------------------------------------------------------------------- +The main.sql file is generated and references includes +the individual .sql, .pks, .pkb files within the directory +tree. This file is generated by "utils/genmain.py and ordered +based on .deps files. This takes the place of the universal .sql +file. + + diff --git a/schema/spacewalk/common/data/data.deps b/schema/spacewalk/common/data/data.deps index ac54834..649e6ad 100644 --- a/schema/spacewalk/common/data/data.deps +++ b/schema/spacewalk/common/data/data.deps @@ -1,5 +1,16 @@ # -# Dependencies for objects in the data directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for data (insert) objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . tables procs diff --git a/schema/spacewalk/common/tables/tables.deps b/schema/spacewalk/common/tables/tables.deps index 6623e18..0b28da3 100644 --- a/schema/spacewalk/common/tables/tables.deps +++ b/schema/spacewalk/common/tables/tables.deps @@ -1,6 +1,16 @@ # -# Dependencies for objects in the tables directory +# Copyright (c) 2008 Red Hat, Inc. # +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for table objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . class types diff --git a/schema/spacewalk/common/views/views.deps b/schema/spacewalk/common/views/views.deps index ebd2419..1f7a6ba 100644 --- a/schema/spacewalk/common/views/views.deps +++ b/schema/spacewalk/common/views/views.deps @@ -1,5 +1,16 @@ # -# Dependencies for the views directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for view objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . tables procs packages diff --git a/schema/spacewalk/oracle/class/class.deps b/schema/spacewalk/oracle/class/class.deps index 76d2c50..f9c55f6 100644 --- a/schema/spacewalk/oracle/class/class.deps +++ b/schema/spacewalk/oracle/class/class.deps @@ -1,5 +1,16 @@ # -# Dependencies for objects in the class directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for class objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . packages diff --git a/schema/spacewalk/oracle/data/data.deps b/schema/spacewalk/oracle/data/data.deps index a483ce7..85aea44 100644 --- a/schema/spacewalk/oracle/data/data.deps +++ b/schema/spacewalk/oracle/data/data.deps @@ -1,5 +1,16 @@ # -# Dependencies for the data directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for data (insert) objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = tables procs diff --git a/schema/spacewalk/oracle/packages/packages.deps b/schema/spacewalk/oracle/packages/packages.deps index 5e7574c..36b8ffe 100644 --- a/schema/spacewalk/oracle/packages/packages.deps +++ b/schema/spacewalk/oracle/packages/packages.deps @@ -1,5 +1,16 @@ # -# Dependencies for the packages directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for packages objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . tables views procs diff --git a/schema/spacewalk/oracle/procs/procs.deps b/schema/spacewalk/oracle/procs/procs.deps index 2f169d0..4328b6a 100644 --- a/schema/spacewalk/oracle/procs/procs.deps +++ b/schema/spacewalk/oracle/procs/procs.deps @@ -1,5 +1,18 @@ # -# Dependencies for objects in the procs directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for stored procedures/functions objects +# in this (namespace) directory. +# +# See: ../../README for details. +# No TABS, PLEASE! # path = . tables views packages class types diff --git a/schema/spacewalk/oracle/tables/tables.deps b/schema/spacewalk/oracle/tables/tables.deps new file mode 100644 index 0000000..e635a5d --- /dev/null +++ b/schema/spacewalk/oracle/tables/tables.deps @@ -0,0 +1,17 @@ +# +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for table objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! +# + +path = . class types + diff --git a/schema/spacewalk/oracle/triggers/triggers.deps b/schema/spacewalk/oracle/triggers/triggers.deps index 12a2378..1010127 100644 --- a/schema/spacewalk/oracle/triggers/triggers.deps +++ b/schema/spacewalk/oracle/triggers/triggers.deps @@ -1,5 +1,16 @@ # -# Dependencies for objects in the triggers directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for trigger objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = tables procs packages diff --git a/schema/spacewalk/oracle/types/types.deps b/schema/spacewalk/oracle/types/types.deps index fb30acd..228a613 100644 --- a/schema/spacewalk/oracle/types/types.deps +++ b/schema/spacewalk/oracle/types/types.deps @@ -1,5 +1,16 @@ # -# Dependencies for objects in the types directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for user defined types objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . diff --git a/schema/spacewalk/oracle/views/views.deps b/schema/spacewalk/oracle/views/views.deps index da48a15..047458c 100644 --- a/schema/spacewalk/oracle/views/views.deps +++ b/schema/spacewalk/oracle/views/views.deps @@ -1,5 +1,16 @@ # -# Dependencies for the views directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for view objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . tables procs packages types diff --git a/schema/spacewalk/postgres/class/class.deps b/schema/spacewalk/postgres/class/class.deps index 76d2c50..f9c55f6 100644 --- a/schema/spacewalk/postgres/class/class.deps +++ b/schema/spacewalk/postgres/class/class.deps @@ -1,5 +1,16 @@ # -# Dependencies for objects in the class directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for class objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . packages diff --git a/schema/spacewalk/postgres/data/data.deps b/schema/spacewalk/postgres/data/data.deps index a483ce7..85aea44 100644 --- a/schema/spacewalk/postgres/data/data.deps +++ b/schema/spacewalk/postgres/data/data.deps @@ -1,5 +1,16 @@ # -# Dependencies for the data directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for data (insert) objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = tables procs diff --git a/schema/spacewalk/postgres/packages/packages.deps b/schema/spacewalk/postgres/packages/packages.deps index 5e7574c..ba053ea 100644 --- a/schema/spacewalk/postgres/packages/packages.deps +++ b/schema/spacewalk/postgres/packages/packages.deps @@ -1,5 +1,16 @@ # -# Dependencies for the packages directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for package objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . tables views procs diff --git a/schema/spacewalk/postgres/procs/procs.deps b/schema/spacewalk/postgres/procs/procs.deps index 2f169d0..3c5f4b3 100644 --- a/schema/spacewalk/postgres/procs/procs.deps +++ b/schema/spacewalk/postgres/procs/procs.deps @@ -1,5 +1,18 @@ # -# Dependencies for objects in the procs directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for stored procedure/function objects +# in this (namespace) directory. +# +# See: ../../README for details. +# No TABS, PLEASE! # path = . tables views packages class types diff --git a/schema/spacewalk/postgres/tables/tables.deps b/schema/spacewalk/postgres/tables/tables.deps index 507bddc..e635a5d 100644 --- a/schema/spacewalk/postgres/tables/tables.deps +++ b/schema/spacewalk/postgres/tables/tables.deps @@ -1,4 +1,17 @@ # -# Dependencies for (forked) objects in the tables directory +# Copyright (c) 2008 Red Hat, Inc. # +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for table objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! +# + +path = . class types diff --git a/schema/spacewalk/postgres/triggers/triggers.deps b/schema/spacewalk/postgres/triggers/triggers.deps index 12a2378..1010127 100644 --- a/schema/spacewalk/postgres/triggers/triggers.deps +++ b/schema/spacewalk/postgres/triggers/triggers.deps @@ -1,5 +1,16 @@ # -# Dependencies for objects in the triggers directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for trigger objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = tables procs packages diff --git a/schema/spacewalk/postgres/views/views.deps b/schema/spacewalk/postgres/views/views.deps index 85a3569..65a9ab6 100644 --- a/schema/spacewalk/postgres/views/views.deps +++ b/schema/spacewalk/postgres/views/views.deps @@ -1,5 +1,16 @@ # -# Dependencies for the views directory +# Copyright (c) 2008 Red Hat, Inc. +# +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Dependencies for view objects in this (namespace) directory. +# See: ../../README for details. +# No TABS, PLEASE! # path = . tables procs packages diff --git a/schema/util/genmain.py b/schema/util/genmain.py index 8cc8150..4482c95 100755 --- a/schema/util/genmain.py +++ b/schema/util/genmain.py @@ -13,6 +13,25 @@ # You should have received a copy of the GNU Lesser General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. +# +# The (.dep) file grammar is as follows: +# +# path : 'path' '=' nslist +# +# nslist : namespace +# | nslist \s namespace +# | nslist ',' namespace +# +# entry : qname '::' deplist +# +# qname : [namespace/]basename[.ext] +# +# deplist : dependency +# | deplist \s dependency +# | deplist ',' dependency +# +# dependency : qname +# import sys, os, re from getopt import getopt, GetoptError commit 596ac4e4652847612434331f90cceba926644e9a Author: Jeff Ortel <jortel(a)redhat.com> Date: Thu Apr 2 09:04:05 2009 -0400 Update Makefile header and comments diff --git a/schema/spacewalk/header.txt b/schema/spacewalk/header.txt index b680460..5995461 100644 --- a/schema/spacewalk/header.txt +++ b/schema/spacewalk/header.txt @@ -11,5 +11,6 @@ -- Red Hat trademarks are not licensed under GPLv2. No permission is -- granted to use or replicate Red Hat trademarks that are incorporated -- in this software or its documentation. --- generated: DO NOT EDIT HERE! +-- +-- Generated from ../common: DO NOT EDIT HERE! -- diff --git a/schema/spacewalk/oracle/Makefile b/schema/spacewalk/oracle/Makefile index 8dbde5f..517fb62 100644 --- a/schema/spacewalk/oracle/Makefile +++ b/schema/spacewalk/oracle/Makefile @@ -1,6 +1,42 @@ # -# make +# Copyright (c) 2008 Red Hat, Inc. # +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Red Hat trademarks are not licensed under GPLv2. No permission is +# granted to use or replicate Red Hat trademarks that are incorporated +# in this software or its documentation. +# +# Make used to build the oracle schema. +# +# Arguments: +# +# SQLUSER - The sqlplus connect information. +# (default: spacewalk/spacewalk@xe). +# TBS - The name of the tablespace to be used to replace the +# [[ tbs ]] macros found in the DDL. It is intended that +# this be specified only for development installs. +# (default: users). +# +# It uses the following tools: +# +# dogchow - A common DDL -> oracle DDL generator installed via rpm +# installed via (yum install dogchow) from fedora extras. +# genmain.py - A tool used to process the .deps files to produce +# the main.sql. It will inject the contents of a file +# named "start.sql" at the beginning if it exits. +# +# The build steps are as follows: +# +# - Populate tables/common from ../common/tables using dogchow. +# - Populate data/common from ../data/tables using dogchow. +# - Populate views/common from ../views/tables +# - Generate the main.sql using genmain.py. # ifndef TBS diff --git a/schema/spacewalk/postgres/Makefile b/schema/spacewalk/postgres/Makefile index 992b3da..510620d 100644 --- a/schema/spacewalk/postgres/Makefile +++ b/schema/spacewalk/postgres/Makefile @@ -1,6 +1,34 @@ # -# make +# Copyright (c) 2008 Red Hat, Inc. # +# This software is licensed to you under the GNU General Public License, +# version 2 (GPLv2). There is NO WARRANTY for this software, express or +# implied, including the implied warranties of MERCHANTABILITY or FITNESS +# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +# along with this software; if not, see +# http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +# +# Make used to build the postgres schema. +# +# Arguments: +# +# SQLUSER - The psql connect information. +# (default: spacewalk). +# +# It uses the following tools: +# +# dogchow - A common DDL -> postgres DDL generator installed via rpm +# installed via (yum install dogchow) from fedora extras. +# genmain.py - A tool used to process the .deps files to produce +# the main.sql. It will inject the contents of a file +# named "start.sql" at the beginning if it exits. +# +# The build steps are as follows: +# +# - Populate tables/common from ../common/tables using dogchow. +# - Populate data/common from ../data/tables using dogchow. +# - Populate views/common from ../views/tables +# - Generate the main.sql using genmain.py. # ifndef SQLUSER

1 0

Branch 'VADER' - 3 commits - backend/satellite_tools client/tools rel-eng/packages
by Pradeep Kilambi 02 Apr '09

02 Apr '09

backend/satellite_tools/satCerts.py | 22 ++++++++++++++++++---- client/tools/rhnpush/rhnpush.spec | 5 ++++- rel-eng/packages/rhnpush | 2 +- 3 files changed, 23 insertions(+), 6 deletions(-) New commits: commit bb23eda42f34a5a900fb2cd4b3cd92d2ce13a48e Author: Pradeep Kilambi <pkilambi(a)redhat.com> Date: Thu Apr 2 10:54:35 2009 -0400 adding some additional checks before creating first org info diff --git a/backend/satellite_tools/satCerts.py b/backend/satellite_tools/satCerts.py index 101c43a..f542dc0 100644 --- a/backend/satellite_tools/satCerts.py +++ b/backend/satellite_tools/satCerts.py @@ -544,6 +544,16 @@ def create_first_private_chan_family(): Check to see if org has a channelfamily associated with it. If not, Create one. """ + _lookup_chfam = """ + SELECT 1 from rhnChannelFamily + WHERE label='private-channel-family-1' + """ + h = rhnSQL.prepare(_lookup_chfam) + row = h.execute() + # some extra check for upgrades + if row: + # Already exists, move on + return _query_create_chfam = """ INSERT INTO rhnChannelFamily (id, name, label, org_id, product_url) @@ -551,10 +561,14 @@ def create_first_private_chan_family(): """ h = rhnSQL.prepare(_query_create_chfam) - h.execute(name="Private Channel Family 1", \ - label="private-channel-family-1", \ - org=1, url="First Org Created") - + try: + h.execute(name='Private Channel Family 1', \ + label='private-channel-family-1', \ + org=1, url='First Org Created') + except rhnSQL.SQLError, e: + # if we're here that means we're voilating something + raise e + def verify_family_permissions(orgid=1): """ commit 6d05320a4707c8757a3bc0987345744931ab6856 Merge: bea9453... d5661f4... Author: Pradeep Kilambi <pkilambi(a)redhat.com> Date: Thu Apr 2 10:18:10 2009 -0400 Merge branch 'VADER' of ssh://pkilambi@git.fedorahosted.org/git/spacewalk into vader commit bea9453378fbed4511a2d43bf7507d538bca6abf Author: Pradeep Kilambi <pkilambi(a)redhat.com> Date: Wed Apr 1 10:07:31 2009 -0400 Automatic commit of package [rhnpush] release [0.4.7-1]. diff --git a/client/tools/rhnpush/rhnpush.spec b/client/tools/rhnpush/rhnpush.spec index 2a49301..b37c129 100644 --- a/client/tools/rhnpush/rhnpush.spec +++ b/client/tools/rhnpush/rhnpush.spec @@ -5,7 +5,7 @@ Summary: Common programs needed to be installed on the RHN servers/proxies Group: Applications/System License: GPLv2 URL: http://fedorahosted.org/spacewalk -Version: 0.4.6 +Version: 0.4.7 Release: 1%{?dist} Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u} -n) @@ -49,6 +49,9 @@ rm -rf $RPM_BUILD_ROOT %{_mandir}/man8/solaris2mpm.8* %changelog +* Wed Apr 01 2009 Pradeep Kilambi <pkilambi(a)redhat.com> 0.4.7-1 +- new build for 485880 (pkilambi(a)redhat.com) + * Wed Apr 1 2009 Pradeep Kilambi <pkilambi(a)redhat.com> - Resolves: 485880 - missing help and man options for rhnpush - new build diff --git a/rel-eng/packages/rhnpush b/rel-eng/packages/rhnpush index db58155..e1e0f3a 100644 --- a/rel-eng/packages/rhnpush +++ b/rel-eng/packages/rhnpush @@ -1 +1 @@ -0.4.6-1 client/tools/rhnpush/ +0.4.7-1 client/tools/rhnpush/

1 0

java/code
by Brad Buckingham 02 Apr '09

02 Apr '09

java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml | 2 java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java | 1 java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java | 31 +++++++ java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java | 42 ++++++++-- 4 files changed, 69 insertions(+), 7 deletions(-) New commits: commit ac1887d26123c8b430d26c82d4ff5dadcb6abd90 Author: Brad Buckingham <bbuckingham(a)redhat.com> Date: Thu Apr 2 10:03:08 2009 -0400 493421 - api - kickstart.tree.deleteTreeAndProfiles fixed to delete associated profiles The API as initially written appeared to be a copy/paste of kickstart.tree.delete. As a result, if a tree had any profiles associated with it, the request was rejected. This commit includes updates to remove any profiles associated with the tree. Also, added a junit test for the API which was previously missing... diff --git a/java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml b/java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml index 9f1b484..71ad4e8 100644 --- a/java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml +++ b/java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml @@ -17,7 +17,7 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" <many-to-one name="kstree" class="com.redhat.rhn.domain.kickstart.KickstartableTree" - cascade="save-update" + cascade="none" column="kstree_id" /> <many-to-one name="profile" diff --git a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java index 835202c..c3d21ce 100644 --- a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java +++ b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java @@ -174,6 +174,7 @@ public class KickstartTreeHandler extends BaseHandler { if (op.getTree() == null) { throw new InvalidKickstartTreeException("api.kickstart.tree.notfound"); } + op.setDeleteProfiles(Boolean.TRUE); ValidatorError ve = op.store(); if (ve != null) { throw new InvalidKickstartTreeException(ve.getKey()); diff --git a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java index 2e75334..03058c7 100644 --- a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java +++ b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java @@ -16,10 +16,13 @@ package com.redhat.rhn.frontend.xmlrpc.kickstart.tree.test; import com.redhat.rhn.domain.channel.Channel; import com.redhat.rhn.domain.channel.test.ChannelFactoryTest; +import com.redhat.rhn.domain.kickstart.KickstartData; import com.redhat.rhn.domain.kickstart.KickstartFactory; import com.redhat.rhn.domain.kickstart.KickstartInstallType; import com.redhat.rhn.domain.kickstart.KickstartableTree; +import com.redhat.rhn.domain.kickstart.test.KickstartDataTest; import com.redhat.rhn.domain.kickstart.test.KickstartableTreeTest; +import com.redhat.rhn.frontend.xmlrpc.kickstart.KickstartHandler; import com.redhat.rhn.frontend.xmlrpc.kickstart.tree.KickstartTreeHandler; import com.redhat.rhn.frontend.xmlrpc.test.BaseHandlerTestCase; import com.redhat.rhn.testing.TestUtils; @@ -33,6 +36,7 @@ import java.util.List; public class KickstartTreeHandlerTest extends BaseHandlerTestCase { private KickstartTreeHandler handler = new KickstartTreeHandler(); + private KickstartHandler ksHandler = new KickstartHandler(); public void testListKickstartableTrees() throws Exception { Channel baseChan = ChannelFactoryTest.createTestChannel(admin); @@ -103,6 +107,33 @@ public class KickstartTreeHandlerTest extends BaseHandlerTestCase { assertNull(KickstartFactory.lookupKickstartTreeByLabel(label, admin.getOrg())); } + public void testDeleteTreeAndProfiles() throws Exception { + + KickstartData ks = KickstartDataTest.createKickstartWithProfile(admin); + KickstartableTree testTree = ks.getKickstartDefaults().getKstree(); + Channel channel = testTree.getChannel(); + + // verify our setup... should have 1 tree and 1 profile associated w/it + List ksTrees = handler.list(adminKey, channel.getLabel()); + List ksProfiles = ksHandler.listKickstarts(adminKey); + assertNotNull(ksTrees); + assertNotNull(ksProfiles); + assertEquals(1, ksTrees.size()); + assertEquals(1, ksProfiles.size()); + + // execute test... + int result = handler.deleteTreeAndProfiles(adminKey, testTree.getLabel()); + assertEquals(1, result); + + // verify that both the tree and associated profile no longer exist + ksTrees = handler.list(adminKey, channel.getLabel()); + ksProfiles = ksHandler.listKickstarts(adminKey); + assertNotNull(ksTrees); + assertNotNull(ksProfiles); + assertEquals(0, ksTrees.size()); + assertEquals(0, ksProfiles.size()); + } + public void testListTreeTypes() throws Exception { List types = handler.listInstallTypes(adminKey); assertNotNull(types); diff --git a/java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java b/java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java index 0b916db..656ccc6 100644 --- a/java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java +++ b/java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java @@ -15,19 +15,23 @@ package com.redhat.rhn.manager.kickstart.tree; import com.redhat.rhn.common.validator.ValidatorError; +import com.redhat.rhn.domain.kickstart.KickstartData; import com.redhat.rhn.domain.kickstart.KickstartFactory; import com.redhat.rhn.domain.user.User; +import com.redhat.rhn.manager.kickstart.KickstartDeleteCommand; import com.redhat.rhn.manager.kickstart.cobbler.CobblerCommand; import com.redhat.rhn.manager.kickstart.cobbler.CobblerDistroDeleteCommand; import java.util.List; /** - * TreeEditCommand to edit a KickstartableTree + * TreeDeleteOperation to delete a KickstartableTree * @version $Rev$ */ public class TreeDeleteOperation extends BaseTreeEditOperation { + private Boolean deleteProfiles = Boolean.FALSE; + /** * Default constructor: DONT USE * @param userIn to set @@ -57,22 +61,48 @@ public class TreeDeleteOperation extends BaseTreeEditOperation { } /** + * Set the delete profiles flag. If set, invoking store will delete + * any profile that are currently associated with the tree. + * + * @param deleteProfilesIn flag indicating if profiles associated with + * the tree should be deleted during store() + */ + public void setDeleteProfiles(Boolean deleteProfilesIn) { + deleteProfiles = deleteProfilesIn; + } + + /** * {@inheritDoc} * store() here actually does a remove operation. * It is done to reuse code from BaseTreeEditOperation and BaseTreeAction */ public ValidatorError store() { - List profiles = KickstartFactory.lookupKickstartDatasByTree(this.tree); + + ValidatorError error = null; + List<KickstartData> profiles = KickstartFactory.lookupKickstartDatasByTree( + this.tree); + if (profiles != null && profiles.size() > 0) { - return new ValidatorError("kickstart.tree.inuse"); + + if (deleteProfiles) { + for (KickstartData profile : profiles) { + KickstartDeleteCommand cmd = new KickstartDeleteCommand( + profile.getId(), this.user); + cmd.store(); + } + } + else { + error = new ValidatorError("kickstart.tree.inuse"); + } } - else { + + if (error == null) { KickstartFactory.removeKickstartableTree(this.tree); CobblerDistroDeleteCommand delcmd = new CobblerDistroDeleteCommand(this.tree, - this.user); + this.user); delcmd.store(); - return null; } + return error; }

1 0

Branch 'VADER' - java/code
by Brad Buckingham 02 Apr '09

02 Apr '09

java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml | 2 java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java | 1 java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java | 31 +++++++ java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java | 42 ++++++++-- 4 files changed, 69 insertions(+), 7 deletions(-) New commits: commit d5661f414a0229e685631906b596cfe24458fab3 Author: Brad Buckingham <bbuckingham(a)redhat.com> Date: Thu Apr 2 10:03:08 2009 -0400 493421 - api - kickstart.tree.deleteTreeAndProfiles fixed to delete associated profiles The API as initially written appeared to be a copy/paste of kickstart.tree.delete. As a result, if a tree had any profiles associated with it, the request was rejected. This commit includes updates to remove any profiles associated with the tree. Also, added a junit test for the API which was previously missing... diff --git a/java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml b/java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml index 9f1b484..71ad4e8 100644 --- a/java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml +++ b/java/code/src/com/redhat/rhn/domain/kickstart/KickstartDefaults.hbm.xml @@ -17,7 +17,7 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" <many-to-one name="kstree" class="com.redhat.rhn.domain.kickstart.KickstartableTree" - cascade="save-update" + cascade="none" column="kstree_id" /> <many-to-one name="profile" diff --git a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java index 835202c..c3d21ce 100644 --- a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java +++ b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/KickstartTreeHandler.java @@ -174,6 +174,7 @@ public class KickstartTreeHandler extends BaseHandler { if (op.getTree() == null) { throw new InvalidKickstartTreeException("api.kickstart.tree.notfound"); } + op.setDeleteProfiles(Boolean.TRUE); ValidatorError ve = op.store(); if (ve != null) { throw new InvalidKickstartTreeException(ve.getKey()); diff --git a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java index 2e75334..03058c7 100644 --- a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java +++ b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/tree/test/KickstartTreeHandlerTest.java @@ -16,10 +16,13 @@ package com.redhat.rhn.frontend.xmlrpc.kickstart.tree.test; import com.redhat.rhn.domain.channel.Channel; import com.redhat.rhn.domain.channel.test.ChannelFactoryTest; +import com.redhat.rhn.domain.kickstart.KickstartData; import com.redhat.rhn.domain.kickstart.KickstartFactory; import com.redhat.rhn.domain.kickstart.KickstartInstallType; import com.redhat.rhn.domain.kickstart.KickstartableTree; +import com.redhat.rhn.domain.kickstart.test.KickstartDataTest; import com.redhat.rhn.domain.kickstart.test.KickstartableTreeTest; +import com.redhat.rhn.frontend.xmlrpc.kickstart.KickstartHandler; import com.redhat.rhn.frontend.xmlrpc.kickstart.tree.KickstartTreeHandler; import com.redhat.rhn.frontend.xmlrpc.test.BaseHandlerTestCase; import com.redhat.rhn.testing.TestUtils; @@ -33,6 +36,7 @@ import java.util.List; public class KickstartTreeHandlerTest extends BaseHandlerTestCase { private KickstartTreeHandler handler = new KickstartTreeHandler(); + private KickstartHandler ksHandler = new KickstartHandler(); public void testListKickstartableTrees() throws Exception { Channel baseChan = ChannelFactoryTest.createTestChannel(admin); @@ -103,6 +107,33 @@ public class KickstartTreeHandlerTest extends BaseHandlerTestCase { assertNull(KickstartFactory.lookupKickstartTreeByLabel(label, admin.getOrg())); } + public void testDeleteTreeAndProfiles() throws Exception { + + KickstartData ks = KickstartDataTest.createKickstartWithProfile(admin); + KickstartableTree testTree = ks.getKickstartDefaults().getKstree(); + Channel channel = testTree.getChannel(); + + // verify our setup... should have 1 tree and 1 profile associated w/it + List ksTrees = handler.list(adminKey, channel.getLabel()); + List ksProfiles = ksHandler.listKickstarts(adminKey); + assertNotNull(ksTrees); + assertNotNull(ksProfiles); + assertEquals(1, ksTrees.size()); + assertEquals(1, ksProfiles.size()); + + // execute test... + int result = handler.deleteTreeAndProfiles(adminKey, testTree.getLabel()); + assertEquals(1, result); + + // verify that both the tree and associated profile no longer exist + ksTrees = handler.list(adminKey, channel.getLabel()); + ksProfiles = ksHandler.listKickstarts(adminKey); + assertNotNull(ksTrees); + assertNotNull(ksProfiles); + assertEquals(0, ksTrees.size()); + assertEquals(0, ksProfiles.size()); + } + public void testListTreeTypes() throws Exception { List types = handler.listInstallTypes(adminKey); assertNotNull(types); diff --git a/java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java b/java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java index 0b916db..656ccc6 100644 --- a/java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java +++ b/java/code/src/com/redhat/rhn/manager/kickstart/tree/TreeDeleteOperation.java @@ -15,19 +15,23 @@ package com.redhat.rhn.manager.kickstart.tree; import com.redhat.rhn.common.validator.ValidatorError; +import com.redhat.rhn.domain.kickstart.KickstartData; import com.redhat.rhn.domain.kickstart.KickstartFactory; import com.redhat.rhn.domain.user.User; +import com.redhat.rhn.manager.kickstart.KickstartDeleteCommand; import com.redhat.rhn.manager.kickstart.cobbler.CobblerCommand; import com.redhat.rhn.manager.kickstart.cobbler.CobblerDistroDeleteCommand; import java.util.List; /** - * TreeEditCommand to edit a KickstartableTree + * TreeDeleteOperation to delete a KickstartableTree * @version $Rev$ */ public class TreeDeleteOperation extends BaseTreeEditOperation { + private Boolean deleteProfiles = Boolean.FALSE; + /** * Default constructor: DONT USE * @param userIn to set @@ -57,22 +61,48 @@ public class TreeDeleteOperation extends BaseTreeEditOperation { } /** + * Set the delete profiles flag. If set, invoking store will delete + * any profile that are currently associated with the tree. + * + * @param deleteProfilesIn flag indicating if profiles associated with + * the tree should be deleted during store() + */ + public void setDeleteProfiles(Boolean deleteProfilesIn) { + deleteProfiles = deleteProfilesIn; + } + + /** * {@inheritDoc} * store() here actually does a remove operation. * It is done to reuse code from BaseTreeEditOperation and BaseTreeAction */ public ValidatorError store() { - List profiles = KickstartFactory.lookupKickstartDatasByTree(this.tree); + + ValidatorError error = null; + List<KickstartData> profiles = KickstartFactory.lookupKickstartDatasByTree( + this.tree); + if (profiles != null && profiles.size() > 0) { - return new ValidatorError("kickstart.tree.inuse"); + + if (deleteProfiles) { + for (KickstartData profile : profiles) { + KickstartDeleteCommand cmd = new KickstartDeleteCommand( + profile.getId(), this.user); + cmd.store(); + } + } + else { + error = new ValidatorError("kickstart.tree.inuse"); + } } - else { + + if (error == null) { KickstartFactory.removeKickstartableTree(this.tree); CobblerDistroDeleteCommand delcmd = new CobblerDistroDeleteCommand(this.tree, - this.user); + this.user); delcmd.store(); - return null; } + return error; }

1 0

rel-eng/lib
by Devan Goodwin 02 Apr '09

02 Apr '09

rel-eng/lib/spacewalk/releng/cli.py | 5 +++++ 1 file changed, 5 insertions(+) New commits: commit 2d1a58d39379256ba57a795da4b5996c5f96fc13 Author: Devan Goodwin <dgoodwin(a)redhat.com> Date: Thu Apr 2 10:37:10 2009 -0300 tito: Support block_tagging in tito.props. diff --git a/rel-eng/lib/spacewalk/releng/cli.py b/rel-eng/lib/spacewalk/releng/cli.py index 7b40068..36d71e5 100644 --- a/rel-eng/lib/spacewalk/releng/cli.py +++ b/rel-eng/lib/spacewalk/releng/cli.py @@ -426,6 +426,11 @@ class TagModule(BaseCliModule): def main(self): BaseCliModule.main(self) + if self.global_config.has_option(GLOBALCONFIG_SECTION, + "block_tagging"): + debug("block_tagging defined in tito.props") + error_out("Tagging has been disabled in this git branch.") + build_dir = lookup_build_dir(self.user_config) package_name = get_project_name(tag=None)

1 0

Branch 'VADER' - 2 commits - rel-eng/lib rel-eng/tito.props
by Devan Goodwin 02 Apr '09

02 Apr '09

rel-eng/lib/spacewalk/releng/cli.py | 5 +++++ rel-eng/tito.props | 1 + 2 files changed, 6 insertions(+) New commits: commit 2fe9faea3069eaf3dead9c31b4f8e22b2b57ff0c Author: Devan Goodwin <dgoodwin(a)redhat.com> Date: Thu Apr 2 10:38:26 2009 -0300 Disable package tagging in this branch. diff --git a/rel-eng/tito.props b/rel-eng/tito.props index ce9e025..df1d30d 100644 --- a/rel-eng/tito.props +++ b/rel-eng/tito.props @@ -1,6 +1,7 @@ [globalconfig] default_builder = spacewalk.releng.builder.Builder default_tagger = spacewalk.releng.tagger.VersionTagger +block_tagging = 1 [koji] autobuild_tags = dist-f10-sw-0.5-candidate dist-5E-sw-0.5-candidate commit cb878b7f4e09891d95ab91aaaa4f60e50e31ee3e Author: Devan Goodwin <dgoodwin(a)redhat.com> Date: Thu Apr 2 10:37:10 2009 -0300 tito: Support block_tagging in tito.props. diff --git a/rel-eng/lib/spacewalk/releng/cli.py b/rel-eng/lib/spacewalk/releng/cli.py index 7b40068..36d71e5 100644 --- a/rel-eng/lib/spacewalk/releng/cli.py +++ b/rel-eng/lib/spacewalk/releng/cli.py @@ -426,6 +426,11 @@ class TagModule(BaseCliModule): def main(self): BaseCliModule.main(self) + if self.global_config.has_option(GLOBALCONFIG_SECTION, + "block_tagging"): + debug("block_tagging defined in tito.props") + error_out("Tagging has been disabled in this git branch.") + build_dir = lookup_build_dir(self.user_config) package_name = get_project_name(tag=None)

1 0

← Newer
1
...
68
69
70
71
72
73
74
75
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

spacewalk-commits April 2009