schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.oracle | 7 +++++++ schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql | 10 +++++++++- 2 files changed, 16 insertions(+), 1 deletion(-)
New commits: commit ae5d845568961d3bed9c4a0dfe18b73c85e3fda4 Author: Milan Zazrivec mzazrivec@redhat.com Date: Tue Nov 26 15:30:26 2013 +0100
delete child channel references from rhnDistChannelMap
We no longer keep child channel fks in rhnDistChannelMap.
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 fc94185..91bb082 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 @@ -4,6 +4,13 @@ ALTER TABLE rhnDistChannelMap DROP CONSTRAINT rhn_dcm_os_release_caid_uq; DROP INDEX rhn_dcm_os_release_caid_idx;
delete + from rhnDistChannelMap +where channel_id in ( + select id + from rhnChannel + where parent_channel is not null); + +delete from rhnDistChannelMap a where a.rowid > any ( select b.rowid diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql index 3d6f3dd..f2c7ec2 100644 --- a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/145-rhnDistChannelMap.sql.postgresql @@ -1,9 +1,17 @@ --- oracle equivalent source sha1 a6c3a61fbee096e6d6a45219175f0af4750f7338 +-- oracle equivalent source sha1 5d4e5693ab56a45ba202db768693b4ee63450b76
ALTER TABLE rhnDistChannelMap ADD org_id NUMERIC; ALTER TABLE rhnDistChannelMap ADD CONSTRAINT rhn_dcm_oid_fk FOREIGN KEY (org_id) REFERENCES web_customer (id) ON DELETE CASCADE; DROP INDEX if exists rhn_dcm_os_release_caid_idx; ALTER TABLE rhnDistChannelMap DROP CONSTRAINT rhn_dcm_os_release_caid_uq; + +delete + from rhnDistChannelMap +where channel_id in ( + select id + from rhnChannel + where parent_channel is not null); + ALTER TABLE rhnDistChannelMap ADD CONSTRAINT rhn_dcm_release_caid_oid_uq UNIQUE (release, channel_arch_id, org_id);
ALTER TABLE rhnDistChannelMap ADD id NUMERIC;
spacewalk-commits@lists.fedorahosted.org