schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.oracle
| 5 +++++
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.postgresql
| 2 +-
2 files changed, 6 insertions(+), 1 deletion(-)
New commits:
commit 2ed9809ff0914a0f409d680f75f700634f7a4d59
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Sep 7 13:41:43 2012 +0200
We need to recreate the index.
Addressing
alter table rhnPackageCapability modify version varchar2(512)
*
ERROR at line 1:
ORA-01404: ALTER COLUMN will make an index too large
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.oracle
index dc5569b..1fabe97 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.oracle
@@ -1,3 +1,8 @@
+drop index rhn_pkg_cap_name_version_uq;
+
alter table rhnPackageCapability modify version varchar2(512) ;
+CREATE UNIQUE INDEX rhn_pkg_cap_name_version_uq
+ ON rhnPackageCapability (name, version);
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.postgresql
index d54cbb7..1a8473a 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.postgresql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/127-rhnPackageCapability-version.sql.postgresql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 2ec08603934e79457fb7fe1a0a6075f4331363ba
+-- oracle equivalent source sha1 45038e4725945641a777666cdae258c004b36599
alter table rhnPackageCapability alter version type varchar(512) ;
Show replies by date