rel-eng/packages/spacewalk-schema
| 2 +-
schema/spacewalk/common/tables/rhnChecksum.sql
| 4 +++-
schema/spacewalk/spacewalk-schema.spec
| 5 ++++-
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/005-rhnChecksum-table.sql
| 4 +++-
4 files changed, 11 insertions(+), 4 deletions(-)
New commits:
commit 4b1b5eecbe08a7ad4a74949acfc4536ba7e08f94
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Wed Mar 3 10:34:01 2010 +0100
Automatic commit of package [spacewalk-schema] release [0.8.15-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 6fd8d6d..ae89b21 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-0.8.14-1 schema/spacewalk/
+0.8.15-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 038c312..cedeec8 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -2,7 +2,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 0.8.14
+Version: 0.8.15
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -58,6 +58,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-schema-upgrade*
%changelog
+* Wed Mar 03 2010 Michael Mraka <michael.mraka(a)redhat.com> 0.8.15-1
+- 568293 - don't allow duplicated rows
+
* Fri Feb 19 2010 Michael Mraka <michael.mraka(a)redhat.com> 0.8.14-1
- more fixes of 0.7 -> 0.8 upgrade errors
commit 84c3e563ee3c0f56765edfc45528ab85ead63b7a
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Mar 2 13:29:31 2010 +0100
568293 - don't allow duplicated rows
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/005-rhnChecksum-table.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/005-rhnChecksum-table.sql
index 7eb526b..1fac8df 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/005-rhnChecksum-table.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/005-rhnChecksum-table.sql
@@ -28,6 +28,8 @@ rhnChecksum
enable row movement
;
-CREATE INDEX rhnChecksum_chsum_idx on rhnChecksum(checksum);
+alter table rhnChecksum add constraint rhnChecksum_chsum_uq
+ unique (checksum, checksum_type_id)
+ using index tablespace [[32m_tbs]];
CREATE SEQUENCE rhnChecksum_seq;
commit c9d3fd4cc43fdd708080bcd76a99b8ce619b5a50
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Feb 25 12:52:08 2010 +0100
don't allow duplicated rows
diff --git a/schema/spacewalk/common/tables/rhnChecksum.sql
b/schema/spacewalk/common/tables/rhnChecksum.sql
index 7eb526b..1fac8df 100644
--- a/schema/spacewalk/common/tables/rhnChecksum.sql
+++ b/schema/spacewalk/common/tables/rhnChecksum.sql
@@ -28,6 +28,8 @@ rhnChecksum
enable row movement
;
-CREATE INDEX rhnChecksum_chsum_idx on rhnChecksum(checksum);
+alter table rhnChecksum add constraint rhnChecksum_chsum_uq
+ unique (checksum, checksum_type_id)
+ using index tablespace [[32m_tbs]];
CREATE SEQUENCE rhnChecksum_seq;
Show replies by date