schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/005-rhnChecksum-table.sql
| 4 ++-
schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/003-rhnChecksum-unique.sql
| 13 ++++++++++
2 files changed, 16 insertions(+), 1 deletion(-)
New commits:
commit e6aba2e66d3e645936800b233f7802b2c6b29e88
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Mar 2 14:07:47 2010 +0100
568293 - let's fix rhnChecksum
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/003-rhnChecksum-unique.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/003-rhnChecksum-unique.sql
new file mode 100644
index 0000000..c79f623
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/003-rhnChecksum-unique.sql
@@ -0,0 +1,13 @@
+declare
+ index_not_exists exception;
+ pragma exception_init(index_not_exists, -01418);
+begin
+ execute immediate 'drop index rhnChecksum_chsum_idx';
+ execute immediate 'alter table rhnChecksum add constraint rhnChecksum_chsum_uq
+ unique (checksum, checksum_type_id)
+ using index tablespace [[32m_tbs]]';
+exception
+ when index_not_exists then
+ null; -- index was already dropped
+end;
+/
commit 277a81c34c0089d25dde14a87ae065c99d71032d
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;
Show replies by date