schema/spacewalk/common/tables/rhnISSMaster.sql
| 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql
| 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 8ac37bd912a8009a80064f59dd6bb3aa9232394c
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Wed Jul 3 13:23:17 2013 +0200
Drop where from unique index creation
Not supported in Oracle.
diff --git a/schema/spacewalk/common/tables/rhnISSMaster.sql
b/schema/spacewalk/common/tables/rhnISSMaster.sql
index 7cf906c..a78e034 100644
--- a/schema/spacewalk/common/tables/rhnISSMaster.sql
+++ b/schema/spacewalk/common/tables/rhnISSMaster.sql
@@ -8,4 +8,4 @@ create table rhnIssMaster (
create sequence rhn_issmaster_seq;
-create unique index rhn_issm_only_one_default on rhnISSMaster (is_current_master) where
is_current_master = 'Y';
+create unique index rhn_issm_only_one_default on rhnISSMaster (is_current_master);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql
index 49d1874..a9a97c0 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql
@@ -3,4 +3,4 @@ alter table rhnISSMaster add is_current_master char(1) default 'N'
not null
alter table rhnISSMaster add ca_cert varchar2(256);
-create unique index rhn_issm_only_one_default on rhnISSMaster (is_current_master) where
is_current_master = 'Y';
+create unique index rhn_issm_only_one_default on rhnISSMaster (is_current_master);
Show replies by date