schema/spacewalk/common/tables/rhnSnapshotPackage.sql
| 6 +-----
schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/273-rhnSnapshotPackage-indexes.sql
| 3 +++
2 files changed, 4 insertions(+), 5 deletions(-)
New commits:
commit 0d3a4e927f582cfe87494ce2fce5f237de46b3ab
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Oct 29 15:07:31 2010 +0200
We have rhn_snapshotpkg_sid_nid_uq, no need to have another index on column
snapshot_id.
diff --git a/schema/spacewalk/common/tables/rhnSnapshotPackage.sql
b/schema/spacewalk/common/tables/rhnSnapshotPackage.sql
index b3d491c..00494fa 100644
--- a/schema/spacewalk/common/tables/rhnSnapshotPackage.sql
+++ b/schema/spacewalk/common/tables/rhnSnapshotPackage.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
@@ -27,10 +27,6 @@ CREATE TABLE rhnSnapshotPackage
ENABLE ROW MOVEMENT
;
-CREATE INDEX rhn_snapshotpkg_sid
- ON rhnSnapshotPackage (snapshot_id)
- TABLESPACE [[8m_tbs]];
-
CREATE UNIQUE INDEX rhn_snapshotpkg_sid_nid_uq
ON rhnSnapshotPackage (snapshot_id, nevra_id)
TABLESPACE [[32m_tbs]];
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/273-rhnSnapshotPackage-indexes.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/273-rhnSnapshotPackage-indexes.sql
new file mode 100644
index 0000000..7e26584
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/273-rhnSnapshotPackage-indexes.sql
@@ -0,0 +1,3 @@
+
+drop index rhn_snapshotpkg_sid ;
+
Show replies by date