schema/spacewalk/rhnsat/tables/rhnServerNeededCache_indexes.sql
| 5 +++++
schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
| 5 +++++
2 files changed, 10 insertions(+)
New commits:
commit 3b3cf1138386169aa3ea4e8d75c3f3e1a63fc5c8
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Tue Mar 31 14:14:25 2009 -0400
adding missing index for errata cache\
between spacewalk 0.4 and 0.5 an index was added to the upgrade sql scripts but was
mistakenly left out of the base schema. This commit puts it in the base, and adds it to
the 0.5 -> 0.6 upgrade scripts.
diff --git a/schema/spacewalk/rhnsat/tables/rhnServerNeededCache_indexes.sql
b/schema/spacewalk/rhnsat/tables/rhnServerNeededCache_indexes.sql
index be40c5f..2776ce8 100644
--- a/schema/spacewalk/rhnsat/tables/rhnServerNeededCache_indexes.sql
+++ b/schema/spacewalk/rhnsat/tables/rhnServerNeededCache_indexes.sql
@@ -31,3 +31,8 @@ create index rhn_snc_eid_idx
tablespace [[128m_tbs]]
nologging;
+create index rhn_snc_speid_idx
+ on rhnServerNeededCache(server_id, package_id, errata_id)
+ parallel
+ tablespace [[128m_tbs]]
+ nologging;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
new file mode 100644
index 0000000..e46acff
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/100-rhnServerNeededCache_indexes.sql
@@ -0,0 +1,5 @@
+create index rhn_snc_speid_idx
+ on rhnServerNeededCache(server_id, package_id, errata_id)
+ parallel
+ tablespace [[128m_tbs]]
+ nologging;
Show replies by date