schema/spacewalk/common/tables/rhnPackageNEVRA.sql
| 6 +-----
schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/271-rhnPackageNEVRA-indexes.sql
| 3 +++
2 files changed, 4 insertions(+), 5 deletions(-)
New commits:
commit c4fa0901e158f378e8cbdecabe6a34e13801aa55
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Oct 29 13:49:13 2010 +0200
No need to have index which includes column which is in primary key and the first two
which are in rhn_pkgnevra_nid_eid_paid_uq.
diff --git a/schema/spacewalk/common/tables/rhnPackageNEVRA.sql
b/schema/spacewalk/common/tables/rhnPackageNEVRA.sql
index f82707e..6a70b69 100644
--- a/schema/spacewalk/common/tables/rhnPackageNEVRA.sql
+++ b/schema/spacewalk/common/tables/rhnPackageNEVRA.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2008 Red Hat, Inc.
+-- Copyright (c) 2008--2010 Red Hat, Inc.
--
-- This software is licensed to you under the GNU General Public License,
-- version 2 (GPLv2). There is NO WARRANTY for this software, express or
@@ -32,10 +32,6 @@ CREATE TABLE rhnPackageNEVRA
ENABLE ROW MOVEMENT
;
-CREATE INDEX rhn_pkgnevra_nid_evrid_id_idx
- ON rhnPackageNEVRA (name_id, evr_id, id)
- TABLESPACE [[32m_tbs]];
-
CREATE SEQUENCE rhn_pkgnevra_id_seq;
ALTER TABLE rhnPackageNEVRA
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/271-rhnPackageNEVRA-indexes.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/271-rhnPackageNEVRA-indexes.sql
new file mode 100644
index 0000000..a86420e
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/271-rhnPackageNEVRA-indexes.sql
@@ -0,0 +1,3 @@
+
+drop index rhn_pkgnevra_nid_evrid_id_idx ;
+
Show replies by date