schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
| 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 874dc5cb344d940fbda74e83f2509b7ebc377872
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Nov 1 18:51:30 2012 +0100
Cannot drop index used for enforcement of unique/primary key.
Addressing
DROP INDEX rhn_dcm_os_release_caid_idx
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
index 31b61b8..423bd06 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle
@@ -1,7 +1,7 @@
ALTER TABLE rhnDistChannelMap ADD org_id NUMBER;
ALTER TABLE rhnDistChannelMap ADD CONSTRAINT rhn_dcm_oid_fk FOREIGN KEY (org_id)
REFERENCES web_customer (id) ON DELETE CASCADE;
-DROP INDEX rhn_dcm_os_release_caid_idx;
ALTER TABLE rhnDistChannelMap DROP CONSTRAINT rhn_dcm_os_release_caid_uq;
+DROP INDEX rhn_dcm_os_release_caid_idx;
ALTER TABLE rhnDistChannelMap ADD CONSTRAINT rhn_dcm_release_caid_oid_uq UNIQUE (release,
channel_arch_id, org_id);
ALTER TABLE rhnDistChannelMap ADD id NUMBER;
Show replies by date