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@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@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@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; -
spacewalk-commits@lists.fedorahosted.org