rel-eng/packages/spacewalk-schema
| 2 +-
schema/spacewalk/common/tables/rhnISSMaster.sql
| 4 +++-
schema/spacewalk/oracle/tables/rhnISSMaster_index.sql
| 4 ++++
schema/spacewalk/postgres/tables/rhnISSMaster_index.sql
| 4 ++++
schema/spacewalk/spacewalk-schema.spec
| 5 ++++-
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql
| 6 ------
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql.oracle
| 7 +++++++
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql.postgresql
| 7 +++++++
8 files changed, 30 insertions(+), 9 deletions(-)
New commits:
commit 27b6a57b7858fec26cb21d87c6b0a29c2b8ce371
Author: Stephen Herr <sherr(a)redhat.com>
Date: Wed Jul 3 09:26:21 2013 -0400
Automatic commit of package [spacewalk-schema] release [1.10.60-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 86ac00f..5a6e0ff 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.10.59-1 schema/spacewalk/
+1.10.60-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 53a07a9..dd3def7 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -4,7 +4,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 1.10.59
+Version: 1.10.60
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -71,6 +71,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Wed Jul 03 2013 Stephen Herr <sherr(a)redhat.com> 1.10.60-1
+- 977878 - rhnISSMaster index needs to be different for oracle
+
* Wed Jul 03 2013 Milan Zazrivec <mzazrivec(a)redhat.com> 1.10.59-1
- Drop where from unique index creation
commit 45353d38d943c42d2725b7d76b59ed2abe9936e9
Author: Stephen Herr <sherr(a)redhat.com>
Date: Wed Jul 3 09:21:22 2013 -0400
977878 - rhnISSMaster index needs to be different for oracle
diff --git a/schema/spacewalk/common/tables/rhnISSMaster.sql
b/schema/spacewalk/common/tables/rhnISSMaster.sql
index a78e034..c662baf 100644
--- a/schema/spacewalk/common/tables/rhnISSMaster.sql
+++ b/schema/spacewalk/common/tables/rhnISSMaster.sql
@@ -8,4 +8,6 @@ create table rhnIssMaster (
create sequence rhn_issmaster_seq;
-create unique index rhn_issm_only_one_default on rhnISSMaster (is_current_master);
+-- functional indexes for this table can be found at:
+-- oracle: oracle/tables/rhnISSMaster_index.sql
+-- postgres: postgres/tables/rhnISSMaster_index.sql
diff --git a/schema/spacewalk/oracle/tables/rhnISSMaster_index.sql
b/schema/spacewalk/oracle/tables/rhnISSMaster_index.sql
new file mode 100644
index 0000000..1c006b6
--- /dev/null
+++ b/schema/spacewalk/oracle/tables/rhnISSMaster_index.sql
@@ -0,0 +1,4 @@
+-- functional index for rhnISSMaster
+
+create unique index rhn_issm_only_one_default on rhnISSMaster (
+ case when is_current_master = 'Y' then is_current_master end);
diff --git a/schema/spacewalk/postgres/tables/rhnISSMaster_index.sql
b/schema/spacewalk/postgres/tables/rhnISSMaster_index.sql
new file mode 100644
index 0000000..a0b9bd6
--- /dev/null
+++ b/schema/spacewalk/postgres/tables/rhnISSMaster_index.sql
@@ -0,0 +1,4 @@
+-- functional index for rhnISSMaster
+
+create unique index rhn_issm_only_one_default on rhnISSMaster
+ (is_current_master) where is_current_master = 'Y';
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
deleted file mode 100644
index a9a97c0..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-alter table rhnISSMaster add is_current_master char(1) default 'N' not null
- constraint rhn_issm_master_yn check (is_current_master in ('Y',
'N'));
-
-alter table rhnISSMaster add ca_cert varchar2(256);
-
-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.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql.oracle
new file mode 100644
index 0000000..f940906
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql.oracle
@@ -0,0 +1,7 @@
+alter table rhnISSMaster add is_current_master char(1) default 'N' not null
+ constraint rhn_issm_master_yn check (is_current_master in ('Y',
'N'));
+
+alter table rhnISSMaster add ca_cert varchar2(256);
+
+create unique index rhn_issm_only_one_default on rhnISSMaster (
+ case when is_current_master = 'Y' then is_current_master end);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql.postgresql
new file mode 100644
index 0000000..9b3dbfe
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/028-satellite_sync_master_in_db.sql.postgresql
@@ -0,0 +1,7 @@
+alter table rhnISSMaster add is_current_master char(1) default 'N' not null
+ constraint rhn_issm_master_yn check (is_current_master in ('Y',
'N'));
+
+alter table rhnISSMaster add ca_cert varchar(256);
+
+create unique index rhn_issm_only_one_default on rhnISSMaster
+ (is_current_master) where is_current_master = 'Y';
Show replies by date