schema/spacewalk/common/tables/rhn_sat_node_probe.sql | 46 -----------
schema/spacewalk/common/tables/tables.deps | 1
schema/spacewalk/common/tables/web_customer_notification.sql | 33 -------
schema/spacewalk/oracle/procs/procs.deps | 2
schema/spacewalk/oracle/synonyms/sat_node_probe.sql | 28 ------
schema/spacewalk/postgres/procs/procs.deps | 2
6 files changed, 2 insertions(+), 110 deletions(-)
New commits:
commit 7ff8f35fef298b06120c08610ae97313bed0de78
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Feb 22 14:11:44 2011 +0100
removed unused rhn_sat_node_probe table
diff --git a/schema/spacewalk/common/tables/rhn_sat_node_probe.sql
b/schema/spacewalk/common/tables/rhn_sat_node_probe.sql
deleted file mode 100644
index 5493490..0000000
--- a/schema/spacewalk/common/tables/rhn_sat_node_probe.sql
+++ /dev/null
@@ -1,46 +0,0 @@
---
--- Copyright (c) 2008--2010 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 rhn_sat_node_probe
-(
- probe_id NUMBER(12) NOT NULL
- CONSTRAINT rhn_sndpb_probe_id_pk PRIMARY KEY
- USING INDEX TABLESPACE [[2m_tbs]],
- probe_type VARCHAR2(12)
- DEFAULT ('satnode') NOT NULL
- CONSTRAINT rhn_sndpb_probe_type_ck
- CHECK (probe_type='satnode'),
- sat_node_id NUMBER(12) NOT NULL
-)
-ENABLE ROW MOVEMENT
-;
-
-COMMENT ON TABLE rhn_sat_node_probe IS 'sndpb satellite node probe
definitions';
-
-CREATE INDEX rhn_sndpb_sat_node_id_idx
- ON rhn_sat_node_probe (sat_node_id)
- TABLESPACE [[2m_tbs]];
-
-ALTER TABLE rhn_sat_node_probe
- ADD CONSTRAINT rhn_sndpb_pr_recid_pr_typ_fk FOREIGN KEY (probe_id, probe_type)
- REFERENCES rhn_probe (recid, probe_type)
- ON DELETE CASCADE;
-
-ALTER TABLE rhn_sat_node_probe
- ADD CONSTRAINT rhn_sndpb_satnd_sat_nd_id_fk FOREIGN KEY (sat_node_id)
- REFERENCES rhn_sat_node (recid)
- ON DELETE CASCADE;
-
diff --git a/schema/spacewalk/common/tables/tables.deps
b/schema/spacewalk/common/tables/tables.deps
index 85e9e53..c18f582 100644
--- a/schema/spacewalk/common/tables/tables.deps
+++ b/schema/spacewalk/common/tables/tables.deps
@@ -242,7 +242,6 @@ 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_schedules :: web_customer rhn_schedule_types
rhn_schedule_weeks :: rhn_schedules
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 6d86c7c..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
---
---
commit 0b33abcfc1d53e97fb1ecde872da1833150e8607
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Feb 22 14:03:39 2011 +0100
rhn_synch_probe_state doesn't depend on rhn_satellite_state
diff --git a/schema/spacewalk/oracle/procs/procs.deps
b/schema/spacewalk/oracle/procs/procs.deps
index ae75ee2..debe0be 100644
--- a/schema/spacewalk/oracle/procs/procs.deps
+++ b/schema/spacewalk/oracle/procs/procs.deps
@@ -116,7 +116,7 @@ rhn_install_satellite :: rhn_command_queue_instances
rhn_sat_cluster \
rhn_prepare_install :: rhn_command_queue_instances
rhn_synch_probe_state :: rhn_probe_state rhn_deployed_probe \
rhn_current_state_summaries \
- rhn_multi_scout_threshold rhn_satellite_state \
+ rhn_multi_scout_threshold \
rhn_current_state_summaries
set_ks_session_history_message :: rhnKickstartSessionState \
rhnKickstartSessionHistory
diff --git a/schema/spacewalk/postgres/procs/procs.deps
b/schema/spacewalk/postgres/procs/procs.deps
index 84aeead..4166cf0 100644
--- a/schema/spacewalk/postgres/procs/procs.deps
+++ b/schema/spacewalk/postgres/procs/procs.deps
@@ -114,7 +114,7 @@ rhn_install_satellite :: rhn_command_queue_instances
rhn_sat_cluster \
rhn_prepare_install :: rhn_command_queue_instances
rhn_synch_probe_state :: rhn_probe_state rhn_deployed_probe \
rhn_current_state_summaries \
- rhn_multi_scout_threshold rhn_satellite_state \
+ rhn_multi_scout_threshold \
rhn_current_state_summaries
set_ks_session_history_message :: rhnKickstartSessionState \
rhnKickstartSessionHistory
commit 1f99852ff5d793d12127dfbd38f26c04a6e12e42
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Feb 22 13:48:04 2011 +0100
removed unused table
diff --git a/schema/spacewalk/common/tables/web_customer_notification.sql
b/schema/spacewalk/common/tables/web_customer_notification.sql
deleted file mode 100644
index 4325308..0000000
--- a/schema/spacewalk/common/tables/web_customer_notification.sql
+++ /dev/null
@@ -1,33 +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 web_customer_notification
-(
- id NUMBER NOT NULL
- CONSTRAINT web_cust_not_id_pk PRIMARY KEY
- USING INDEX TABLESPACE [[64k_tbs]],
- org_id NUMBER NOT NULL
- CONSTRAINT web_cust_not_oid_fk
- REFERENCES web_customer (id)
- ON DELETE CASCADE,
- contact_email_address VARCHAR2(150) NOT NULL,
- creation_date DATE NOT NULL
-)
-ENABLE ROW MOVEMENT
-;
-
-CREATE SEQUENCE web_cust_notif_seq START WITH 1000000;
-