schema/spacewalk/common/tables/rhnVirtualInstance.sql
| 4 ++++
schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/008-rhnVirtualization.sql
| 3 +++
2 files changed, 7 insertions(+)
New commits:
commit 63a29bbc93b47465851b130a797e879c0e061840
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Mar 3 15:07:05 2011 +0100
upgrade script for rhnVirtualization.uuid index
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/008-rhnVirtualization.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/008-rhnVirtualization.sql
new file mode 100644
index 0000000..56d9c7f
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/008-rhnVirtualization.sql
@@ -0,0 +1,3 @@
+CREATE INDEX rhn_vi_uuid_idx
+ ON rhnVirtualInstance (uuid)
+ TABLESPACE [[64k_tbs]];
commit 136da793d9460e94f9b79594b53de7f02008f435
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Mar 3 15:04:11 2011 +0100
468690 - added index to rhnVirtualization.uuid
diff --git a/schema/spacewalk/common/tables/rhnVirtualInstance.sql
b/schema/spacewalk/common/tables/rhnVirtualInstance.sql
index 61e2edc..10ab243 100644
--- a/schema/spacewalk/common/tables/rhnVirtualInstance.sql
+++ b/schema/spacewalk/common/tables/rhnVirtualInstance.sql
@@ -44,5 +44,9 @@ CREATE INDEX rhn_vi_vsid_idx
ON rhnVirtualInstance (virtual_system_id)
TABLESPACE [[64k_tbs]];
+CREATE INDEX rhn_vi_uuid_idx
+ ON rhnVirtualInstance (uuid)
+ TABLESPACE [[64k_tbs]];
+
CREATE SEQUENCE rhn_vi_id_seq;
Show replies by date