schema/spacewalk/common/tables/rhnServerProfile.sql
| 7 +------
schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/272-rhnServerProfile-indexes.sql
| 3 +++
2 files changed, 4 insertions(+), 6 deletions(-)
New commits:
commit e5510999877a92cd4b8c2fb865bdadbab4f5baad
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Oct 29 14:58:38 2010 +0200
We have rhn_sprofile_id_oid_bc_idx and rhn_server_profile_noid_uq, so
rhn_server_profile_o_id_bc_idx is not useful, removing.
diff --git a/schema/spacewalk/common/tables/rhnServerProfile.sql
b/schema/spacewalk/common/tables/rhnServerProfile.sql
index b1b737e..bac521a 100644
--- a/schema/spacewalk/common/tables/rhnServerProfile.sql
+++ b/schema/spacewalk/common/tables/rhnServerProfile.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
@@ -46,11 +46,6 @@ CREATE INDEX rhn_sprofile_id_oid_bc_idx
ON rhnServerProfile (id, org_id, base_channel)
TABLESPACE [[64k_tbs]];
-CREATE INDEX rhn_server_profile_o_id_bc_idx
- ON rhnServerProfile (org_id, id, base_channel)
- TABLESPACE [[64k_tbs]]
- NOLOGGING;
-
CREATE INDEX rhn_server_profile_bc_idx
ON rhnServerProfile (base_channel)
TABLESPACE [[64k_tbs]]
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/272-rhnServerProfile-indexes.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/272-rhnServerProfile-indexes.sql
new file mode 100644
index 0000000..50c938b
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/272-rhnServerProfile-indexes.sql
@@ -0,0 +1,3 @@
+
+drop index rhn_server_profile_o_id_bc_idx ;
+
Show replies by thread