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@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;
spacewalk-commits@lists.fedorahosted.org