schema/spacewalk/common/tables/rhnPackageUpgradeArchCompat.sql
| 4 ++--
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/022-rhnPackageUpgradeArchCompat-unique.sql
| 5 +++++
2 files changed, 7 insertions(+), 2 deletions(-)
New commits:
commit 7f6c38cb972a723c597b11aeceded9e846eb7571
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Apr 20 11:26:09 2012 +0200
Make the records in rhnPackageUpgradeArchCompat -- no need to have duplicates.
diff --git a/schema/spacewalk/common/tables/rhnPackageUpgradeArchCompat.sql
b/schema/spacewalk/common/tables/rhnPackageUpgradeArchCompat.sql
index 1dd9a38..549994c 100644
--- a/schema/spacewalk/common/tables/rhnPackageUpgradeArchCompat.sql
+++ b/schema/spacewalk/common/tables/rhnPackageUpgradeArchCompat.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2010 Red Hat, Inc.
+-- Copyright (c) 2010--2012 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
@@ -30,6 +30,6 @@ CREATE TABLE rhnPackageUpgradeArchCompat
ENABLE ROW MOVEMENT
;
-CREATE INDEX rhn_puac_pa_pua
+CREATE UNIQUE INDEX rhn_puac_pa_pua_uq
ON rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id)
TABLESPACE [[64k_tbs]];
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/022-rhnPackageUpgradeArchCompat-unique.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/022-rhnPackageUpgradeArchCompat-unique.sql
new file mode 100644
index 0000000..dd3bf55
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/022-rhnPackageUpgradeArchCompat-unique.sql
@@ -0,0 +1,5 @@
+
+drop index rhn_puac_pa_pua;
+create unique index rhn_puac_pa_pua_uq
+ on rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id);
+
Show replies by date