schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/026-rhnReleaseChannelMap-uq.sql.oracle
| 14 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/026-rhnReleaseChannelMap-uq.sql.postgresql
| 2 +
2 files changed, 16 insertions(+)
New commits:
commit ee1000616b506619d42f6d650d581ebe423ff406
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Aug 30 12:18:00 2011 +0200
fixed rhnReleaseChannelMap upgrade from 0.5 to 0.6
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/026-rhnReleaseChannelMap-uq.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/026-rhnReleaseChannelMap-uq.sql.oracle
new file mode 100644
index 0000000..e3d6076
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/026-rhnReleaseChannelMap-uq.sql.oracle
@@ -0,0 +1,14 @@
+-- during 05 -> 0.6 schema upgrade RHN_RCM_PVA_DEF_UNIQ had been mis-renamed
+-- to RHN_RCM_PVAR_UNIQ
+
+declare
+ constraint_not_exists exception;
+ pragma exception_init(constraint_not_exists, -23292);
+begin
+ execute immediate 'alter table RHNRELEASECHANNELMAP rename constraint
RHN_RCM_PVAR_UNIQ to RHN_RCM_PVA_DEF_UNIQ';
+exception
+ when constraint_not_exists then
+ null; -- constraint has right name
+end;
+/
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/026-rhnReleaseChannelMap-uq.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/026-rhnReleaseChannelMap-uq.sql.postgresql
new file mode 100644
index 0000000..dc172e9
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/026-rhnReleaseChannelMap-uq.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 3fd4b70be8d6cf690ac54d07ff15afb9e0e7264c
+-- This file is intentionally left empty.
Show replies by thread