rel-eng/packages/spacewalk-schema
| 2
schema/spacewalk/spacewalk-schema.spec
| 5 -
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/004-rhnChecksumType-table.sql
| 37 -------
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/005-rhnChecksum-table.sql
| 33 ------
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/006-move-checksum.sql
| 14 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/007-rhnChecksumView.sql
| 24 ----
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/008-lookup_checksum.sql
| 49 ----------
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-1-rhnFile-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-2-rhnFile-data.sql
| 10 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-3-rhnFile-md5.sql
| 2
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-4-rhnFile-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-1-rhnPackage-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-2-rhnPackage-data.sql
| 11 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-3-rhnPackage-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-4-rhnPackage-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-1-rhnPackageFile-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-2-rhnPackageFile-data.sql
| 11 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-3-rhnPackageFile-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-1-rhnErrataFile-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-2-rhnErrataFile-data.sql
| 11 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-3-rhnErrataFile-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-4-rhnErrataFile-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-1-rhnErrataFileTmp-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-2-rhnErrataFileTmp-data.sql
| 11 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-3-rhnErrataFileTmp-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-4-rhnErrataFileTmp-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-1-rhnKSTreeFile-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-2-rhnKSTreeFile-data.sql
| 11 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-3-rhnKSTreeFile-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-4-rhnKSTreeFile-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-1-rhnConfigContent-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-2-rhnConfigContent-data.sql
| 11 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-3-rhnConfigContent-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-4-rhnConfigContent-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-1-rhnPackageSource-checksum.sql
| 6 -
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-2-rhnPackageSource-data.sql
| 21 ----
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-3-rhnPackageSource-md5.sql
| 2
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-4-rhnPackageSource-checksum.sql
| 2
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-1-rhnAppInstallSession-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-2-rhnAppInstallSession-data.sql
| 11 --
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-3-rhnAppInstallSession-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-4-rhnAppInstallSession-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/019-1-rhnServerActionVerifyResult-checksum.sql
| 7 -
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/004-rhnChecksumType-table.sql
| 37 +++++++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/005-rhnChecksum-table.sql
| 33 ++++++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/006-move-checksum.sql
| 14 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/007-rhnChecksumView.sql
| 24 ++++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/008-lookup_checksum.sql
| 49 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-1-rhnFile-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-2-rhnFile-data.sql
| 10 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-3-rhnFile-md5.sql
| 2
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-4-rhnFile-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-1-rhnPackage-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
| 11 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-3-rhnPackage-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-4-rhnPackage-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-1-rhnPackageFile-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
| 11 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-3-rhnPackageFile-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-1-rhnErrataFile-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-2-rhnErrataFile-data.sql
| 11 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-3-rhnErrataFile-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-4-rhnErrataFile-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-1-rhnErrataFileTmp-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-2-rhnErrataFileTmp-data.sql
| 11 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-3-rhnErrataFileTmp-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-4-rhnErrataFileTmp-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-1-rhnKSTreeFile-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
| 11 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-3-rhnKSTreeFile-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-4-rhnKSTreeFile-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-1-rhnConfigContent-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-2-rhnConfigContent-data.sql
| 11 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-3-rhnConfigContent-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-4-rhnConfigContent-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-1-rhnPackageSource-checksum.sql
| 6 +
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-2-rhnPackageSource-data.sql
| 21 ++++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-3-rhnPackageSource-md5.sql
| 2
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-4-rhnPackageSource-checksum.sql
| 2
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-1-rhnAppInstallSession-checksum.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-2-rhnAppInstallSession-data.sql
| 11 ++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-3-rhnAppInstallSession-md5.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-4-rhnAppInstallSession-checksum.sql
| 1
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/019-1-rhnServerActionVerifyResult-checksum.sql
| 7 +
84 files changed, 327 insertions(+), 324 deletions(-)
New commits:
commit 423bc27290c04171195dc6c868c455cedc9d9ed0
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Dec 4 16:39:04 2009 +0100
Automatic commit of package [spacewalk-schema] release [0.8.1-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 84fe8b4..3c62b9e 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-0.7.7-1 schema/spacewalk/
+0.8.1-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 2c3268f..9d4f65f 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.0
+Version: 0.8.1
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -58,6 +58,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-schema-upgrade*
%changelog
+* Fri Dec 04 2009 Michael Mraka <michael.mraka(a)redhat.com> 0.8.1-1
+- SHA256 feature related changes
+
* Mon Nov 30 2009 Milan Zazrivec <mzazrivec(a)redhat.com> 0.7.7-1
- schema upgrade fixes for Spacewalk 0.7
commit 9af2b26ef0981688dfd0e659de32cecea02d04c6
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Dec 4 16:25:21 2009 +0100
moved sha256 related upgrade scripts to appropriate directory
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/004-rhnChecksumType-table.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/004-rhnChecksumType-table.sql
deleted file mode 100644
index 6543051..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/004-rhnChecksumType-table.sql
+++ /dev/null
@@ -1,37 +0,0 @@
---
--- Copyright (c) 2008 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
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
---
-
-CREATE TABLE rhnChecksumType
-(
- id NUMBER NOT NULL
- CONSTRAINT rhn_checksumtype_id_pk PRIMARY KEY
- USING INDEX TABLESPACE [[64k_tbs]],
- label VARCHAR2(32) NOT NULL,
- description VARCHAR2(64) NOT NULL,
- created DATE DEFAULT (sysdate) NOT NULL,
- modified DATE DEFAULT (sysdate) NOT NULL
-)
-ENABLE ROW MOVEMENT
-;
-
-CREATE INDEX rhn_checksumtype_label_id_idx
- ON rhnChecksumType( label, id )
- TABLESPACE [[64k_tbs]];
-
-ALTER TABLE rhnChecksumType
- ADD CONSTRAINT rhn_checksumtype_label_uq UNIQUE (label);
-
-CREATE SEQUENCE rhn_checksum_id_seq;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/005-rhnChecksum-table.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/005-rhnChecksum-table.sql
deleted file mode 100644
index 7eb526b..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/005-rhnChecksum-table.sql
+++ /dev/null
@@ -1,33 +0,0 @@
---
--- Copyright (c) 2009 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
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
---
---
--- The checksum associated with a package/file/etc...
-
-create table
-rhnChecksum
-(
- id number not null
- constraint rhnChecksum_pk primary key,
- checksum_type_id number not null
- constraint rhnChecksum_typeid_fk
- references rhnChecksumType(id),
- checksum varchar2(128) not null
-)
- enable row movement
-;
-
-CREATE INDEX rhnChecksum_chsum_idx on rhnChecksum(checksum);
-
-CREATE SEQUENCE rhnChecksum_seq;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/006-move-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/006-move-checksum.sql
deleted file mode 100644
index f43f20f..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/006-move-checksum.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-
-insert into rhnPackageChecksum (package_id, checksum_type_id, checksum)
- (select p.id, md5.id, md5sum
- from rhnPackage p,
- (select id from rhnpackageChecksumType where label = 'md5') md5
- );
-
-commit;
-
-drop index rhn_package_md5_oid_uq;
-
-alter table rhnPackage drop column md5sum;
-
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/007-rhnChecksumView.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/007-rhnChecksumView.sql
deleted file mode 100644
index 4c3dfe1..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/007-rhnChecksumView.sql
+++ /dev/null
@@ -1,24 +0,0 @@
---
--- Copyright (c) 2009 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
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
---
-
-create or replace view rhnChecksumView
-as
-select c.id,
- ct.label checksum_type,
- c.checksum
- from rhnChecksum c,
- rhnChecksumType ct
- where c.checksum_type_id = ct.id;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/008-lookup_checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/008-lookup_checksum.sql
deleted file mode 100644
index 5baba4b..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/008-lookup_checksum.sql
+++ /dev/null
@@ -1,49 +0,0 @@
---
--- Copyright (c) 2009 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
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
---
---
---
---
-
-CREATE OR REPLACE FUNCTION
-LOOKUP_CHECKSUM(checksum_type_in IN VARCHAR2, checksum_in IN VARCHAR2)
-RETURN NUMBER
-IS
- PRAGMA AUTONOMOUS_TRANSACTION;
- checksum_id NUMBER;
-BEGIN
- if checksum_in is null then
- return null;
- end if;
-
- SELECT c.id
- INTO checksum_id
- FROM rhnChecksumView c
- WHERE c.checksum = checksum_in
- AND c.checksum_type = checksum_type_in;
-
- RETURN checksum_id;
-EXCEPTION
- WHEN NO_DATA_FOUND THEN
- INSERT INTO rhnChecksum (id, checksum_type_id, checksum)
- VALUES (rhnChecksum_seq.nextval,
- (select id from rhnChecksumType where label = checksum_type_in),
- checksum_in)
- RETURNING id INTO checksum_id;
- COMMIT;
- RETURN checksum_id;
-END;
-/
-SHOW ERRORS
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-1-rhnFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-1-rhnFile-checksum.sql
deleted file mode 100644
index 49abf2c..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-1-rhnFile-checksum.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-alter table rhnFile add checksum_id NUMBER
- CONSTRAINT rhn_file_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-2-rhnFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-2-rhnFile-data.sql
deleted file mode 100644
index 7e5e185..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-2-rhnFile-data.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select f.id, md5.id, f.md5sum
- from rhnFile f,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnFile f
- set checksum_id = (select id from rhnChecksum c where c.checksum = f.md5sum);
-
-commit;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-3-rhnFile-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-3-rhnFile-md5.sql
deleted file mode 100644
index 8cfe5f8..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-3-rhnFile-md5.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-alter table rhnFile drop column md5sum;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-4-rhnFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-4-rhnFile-checksum.sql
deleted file mode 100644
index d1c4b74..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/010-4-rhnFile-checksum.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnFile modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-1-rhnPackage-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-1-rhnPackage-checksum.sql
deleted file mode 100644
index 006cc7f..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-1-rhnPackage-checksum.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-alter table rhnPackage add checksum_id NUMBER
- CONSTRAINT rhn_package_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-2-rhnPackage-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-2-rhnPackage-data.sql
deleted file mode 100644
index eb5ab29..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-2-rhnPackage-data.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select p.id, md5.id, p.md5sum
- from rhnPackage p,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnPackage p
- set checksum_id = (select c.id from rhnChecksum c where c.checksum = p.md5sum);
-
-commit;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-3-rhnPackage-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-3-rhnPackage-md5.sql
deleted file mode 100644
index df2eca0..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-3-rhnPackage-md5.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnPackage drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-4-rhnPackage-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-4-rhnPackage-checksum.sql
deleted file mode 100644
index b67d9cc..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/011-4-rhnPackage-checksum.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnPackage modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-1-rhnPackageFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-1-rhnPackageFile-checksum.sql
deleted file mode 100644
index 20462ea..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-1-rhnPackageFile-checksum.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-alter table rhnPackageFile add checksum_id NUMBER
- CONSTRAINT rhn_package_file_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-2-rhnPackageFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-2-rhnPackageFile-data.sql
deleted file mode 100644
index 190f03b..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-2-rhnPackageFile-data.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select p.id, md5.id, p.md5sum
- from rhnPackageFile p,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnPackageFile p
- set checksum_id = (select c.id from rhnChecksum c where c.checksum = p.md5sum);
-
-commit;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-3-rhnPackageFile-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-3-rhnPackageFile-md5.sql
deleted file mode 100644
index f8ad8db..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/012-3-rhnPackageFile-md5.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnPackageFile drop column md5;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-1-rhnErrataFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-1-rhnErrataFile-checksum.sql
deleted file mode 100644
index ba57710..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-1-rhnErrataFile-checksum.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-alter table rhnErrataFile add checksum_id NUMBER
- CONSTRAINT rhn_erratafile_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-2-rhnErrataFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-2-rhnErrataFile-data.sql
deleted file mode 100644
index 166e7d5..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-2-rhnErrataFile-data.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select e.id, md5.id, e.md5sum
- from rhnErrataFile e,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnErrataFile e
- set checksum_id = (select c.id from rhnChecksum c where c.checksum = e.md5sum);
-
-commit;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-3-rhnErrataFile-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-3-rhnErrataFile-md5.sql
deleted file mode 100644
index 17a8c2f..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-3-rhnErrataFile-md5.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnErrataFile drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-4-rhnErrataFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-4-rhnErrataFile-checksum.sql
deleted file mode 100644
index 41a9318..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/013-4-rhnErrataFile-checksum.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnErrataFile modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-1-rhnErrataFileTmp-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-1-rhnErrataFileTmp-checksum.sql
deleted file mode 100644
index 2cbc875..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-1-rhnErrataFileTmp-checksum.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-alter table rhnErrataFileTmp add checksum_id NUMBER
- CONSTRAINT rhn_erratafiletmp_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-2-rhnErrataFileTmp-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-2-rhnErrataFileTmp-data.sql
deleted file mode 100644
index d7bac43..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-2-rhnErrataFileTmp-data.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select e.id, md5.id, e.md5sum
- from rhnErrataFileTmp e,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnErrataFileTmp e
- set checksum_id = (select c.id from rhnChecksum c where c.checksum = e.md5sum);
-
-commit;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-3-rhnErrataFileTmp-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-3-rhnErrataFileTmp-md5.sql
deleted file mode 100644
index fb6685a..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-3-rhnErrataFileTmp-md5.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnErrataFileTmp drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-4-rhnErrataFileTmp-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-4-rhnErrataFileTmp-checksum.sql
deleted file mode 100644
index c0b4e41..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/014-4-rhnErrataFileTmp-checksum.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnErrataFileTmp modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-1-rhnKSTreeFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-1-rhnKSTreeFile-checksum.sql
deleted file mode 100644
index 4c695d0..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-1-rhnKSTreeFile-checksum.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-alter table rhnKSTreeFile add checksum_id NUMBER
- CONSTRAINT rhn_kstreefile_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-2-rhnKSTreeFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-2-rhnKSTreeFile-data.sql
deleted file mode 100644
index 2e41006..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-2-rhnKSTreeFile-data.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select k.id, md5.id, k.md5sum
- from rhnKSTreeFile k,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnKSTreeFile k
- set checksum_id = (select c.id from rhnChecksum c where c.checksum = k.md5sum);
-
-commit;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-3-rhnKSTreeFile-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-3-rhnKSTreeFile-md5.sql
deleted file mode 100644
index 3915149..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-3-rhnKSTreeFile-md5.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnKSTreeFile drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-4-rhnKSTreeFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-4-rhnKSTreeFile-checksum.sql
deleted file mode 100644
index cf47171..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/015-4-rhnKSTreeFile-checksum.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnKSTreeFile modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-1-rhnConfigContent-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-1-rhnConfigContent-checksum.sql
deleted file mode 100644
index 09824b5..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-1-rhnConfigContent-checksum.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-alter table rhnConfigContent add checksum_id NUMBER
- CONSTRAINT rhn_confcontent_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-2-rhnConfigContent-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-2-rhnConfigContent-data.sql
deleted file mode 100644
index 2bd13b0..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-2-rhnConfigContent-data.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select cc.id, md5.id, cc.md5sum
- from rhnConfigContent cc,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnConfigContent cc
- set checksum_id = (select c.id from rhnChecksum c where c.checksum = cc.md5sum);
-
-commit;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-3-rhnConfigContent-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-3-rhnConfigContent-md5.sql
deleted file mode 100644
index 81b835f..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-3-rhnConfigContent-md5.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnConfigContent drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-4-rhnConfigContent-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-4-rhnConfigContent-checksum.sql
deleted file mode 100644
index 2af6aa0..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/016-4-rhnConfigContent-checksum.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnConfigContent modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-1-rhnPackageSource-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-1-rhnPackageSource-checksum.sql
deleted file mode 100644
index 1c6c5de..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-1-rhnPackageSource-checksum.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-alter table rhnPackageSource add sigchecksum_id NUMBER
- CONSTRAINT rhn_pkgsrc_sigchsum_fk
- REFERENCES rhnChecksum (id);
-alter table rhnPackageSource add checksum_id NUMBER
- CONSTRAINT rhn_pkgsrc_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-2-rhnPackageSource-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-2-rhnPackageSource-data.sql
deleted file mode 100644
index 5f0342d..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-2-rhnPackageSource-data.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select s.id, md5.id, s.sigmd5
- from rhnPackageSource s,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnPackageSource s
- set sigchecksum_id = (select c.id from rhnChecksum c where c.checksum = s.sigmd5);
-
-commit;
-
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select s.id, md5.id, s.md5sum
- from rhnPackageSource s,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnPackageSource s
- set checksum_id = (select c.id from rhnChecksum c where c.checksum = s.md5sum);
-
-commit;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-3-rhnPackageSource-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-3-rhnPackageSource-md5.sql
deleted file mode 100644
index 191f6e2..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-3-rhnPackageSource-md5.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-alter table rhnPackageSource drop column sigmd5;
-alter table rhnPackageSource drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-4-rhnPackageSource-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-4-rhnPackageSource-checksum.sql
deleted file mode 100644
index 06510f3..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/017-4-rhnPackageSource-checksum.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-alter table rhnPackageSource modify sigchecksum_id NUMBER NOT NULL;
-alter table rhnPackageSource modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-1-rhnAppInstallSession-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-1-rhnAppInstallSession-checksum.sql
deleted file mode 100644
index c8e87a7..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-1-rhnAppInstallSession-checksum.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-alter table rhnAppInstallSession add checksum_id NUMBER
- CONSTRAINT rhn_appinst_session_chsum_fk
- REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-2-rhnAppInstallSession-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-2-rhnAppInstallSession-data.sql
deleted file mode 100644
index c6bc5aa..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-2-rhnAppInstallSession-data.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-insert into rhnChecksum (id, checksum_type_id, checksum)
- (select s.id, md5.id, s.md5sum
- from rhnAppInstallSession s,
- (select id from rhnChecksumType where label = 'md5') md5
- );
-
-update rhnAppInstallSession s
- set checksum_id = (select c.id from rhnChecksum c where c.checksum = s.md5sum);
-
-commit;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-3-rhnAppInstallSession-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-3-rhnAppInstallSession-md5.sql
deleted file mode 100644
index 714be2b..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-3-rhnAppInstallSession-md5.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnAppInstallSession drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-4-rhnAppInstallSession-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-4-rhnAppInstallSession-checksum.sql
deleted file mode 100644
index ede722c..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/018-4-rhnAppInstallSession-checksum.sql
+++ /dev/null
@@ -1 +0,0 @@
-alter table rhnAppInstallSession modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/019-1-rhnServerActionVerifyResult-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/019-1-rhnServerActionVerifyResult-checksum.sql
deleted file mode 100644
index 7cf3f9a..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/019-1-rhnServerActionVerifyResult-checksum.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-alter table rhnServerActionVerifyResult
- rename column md5_differs to checksum_differs;
-alter table rhnServerActionVerifyResult
- drop constraint rhn_sactionvr_md5_ck;
-alter table rhnServerActionVerifyResult
- add constraint rhn_sactionvr_chsum_ck
- CHECK (checksum_differs in ( 'Y' , 'N' , '?' ));
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/004-rhnChecksumType-table.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/004-rhnChecksumType-table.sql
new file mode 100644
index 0000000..1b87738
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/004-rhnChecksumType-table.sql
@@ -0,0 +1,37 @@
+--
+-- Copyright (c) 2008 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
+-- implied, including the implied warranties of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+-- along with this software; if not, see
+--
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+--
+-- Red Hat trademarks are not licensed under GPLv2. No permission is
+-- granted to use or replicate Red Hat trademarks that are incorporated
+-- in this software or its documentation.
+--
+
+CREATE TABLE rhnChecksumType
+(
+ id NUMBER NOT NULL
+ CONSTRAINT rhn_checksumtype_id_pk PRIMARY KEY
+ USING INDEX TABLESPACE [[64k_tbs]],
+ label VARCHAR2(32) NOT NULL,
+ description VARCHAR2(64) NOT NULL,
+ created DATE DEFAULT (sysdate) NOT NULL,
+ modified DATE DEFAULT (sysdate) NOT NULL
+)
+ENABLE ROW MOVEMENT
+;
+
+CREATE INDEX rhn_checksumtype_label_id_idx
+ ON rhnChecksumType( label, id )
+ TABLESPACE [[64k_tbs]];
+
+ALTER TABLE rhnChecksumType
+ ADD CONSTRAINT rhn_checksumtype_label_uq UNIQUE (label);
+
+CREATE SEQUENCE rhn_checksum_id_seq;
+
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
new file mode 100644
index 0000000..7eb526b
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/005-rhnChecksum-table.sql
@@ -0,0 +1,33 @@
+--
+-- Copyright (c) 2009 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
+-- implied, including the implied warranties of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+-- along with this software; if not, see
+--
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+--
+-- Red Hat trademarks are not licensed under GPLv2. No permission is
+-- granted to use or replicate Red Hat trademarks that are incorporated
+-- in this software or its documentation.
+--
+--
+-- The checksum associated with a package/file/etc...
+
+create table
+rhnChecksum
+(
+ id number not null
+ constraint rhnChecksum_pk primary key,
+ checksum_type_id number not null
+ constraint rhnChecksum_typeid_fk
+ references rhnChecksumType(id),
+ checksum varchar2(128) not null
+)
+ enable row movement
+;
+
+CREATE INDEX rhnChecksum_chsum_idx on rhnChecksum(checksum);
+
+CREATE SEQUENCE rhnChecksum_seq;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/006-move-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/006-move-checksum.sql
new file mode 100644
index 0000000..f43f20f
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/006-move-checksum.sql
@@ -0,0 +1,14 @@
+
+insert into rhnPackageChecksum (package_id, checksum_type_id, checksum)
+ (select p.id, md5.id, md5sum
+ from rhnPackage p,
+ (select id from rhnpackageChecksumType where label = 'md5') md5
+ );
+
+commit;
+
+drop index rhn_package_md5_oid_uq;
+
+alter table rhnPackage drop column md5sum;
+
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/007-rhnChecksumView.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/007-rhnChecksumView.sql
new file mode 100644
index 0000000..8be71cb
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/007-rhnChecksumView.sql
@@ -0,0 +1,24 @@
+--
+-- Copyright (c) 2009 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
+-- implied, including the implied warranties of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+-- along with this software; if not, see
+--
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+--
+-- Red Hat trademarks are not licensed under GPLv2. No permission is
+-- granted to use or replicate Red Hat trademarks that are incorporated
+-- in this software or its documentation.
+--
+
+create or replace view rhnChecksumView
+as
+select c.id,
+ ct.label checksum_type,
+ c.checksum
+ from rhnChecksum c,
+ rhnChecksumType ct
+ where c.checksum_type_id = ct.id;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/008-lookup_checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/008-lookup_checksum.sql
new file mode 100644
index 0000000..5baba4b
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/008-lookup_checksum.sql
@@ -0,0 +1,49 @@
+--
+-- Copyright (c) 2009 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
+-- implied, including the implied warranties of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+-- along with this software; if not, see
+--
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+--
+-- Red Hat trademarks are not licensed under GPLv2. No permission is
+-- granted to use or replicate Red Hat trademarks that are incorporated
+-- in this software or its documentation.
+--
+--
+--
+--
+
+CREATE OR REPLACE FUNCTION
+LOOKUP_CHECKSUM(checksum_type_in IN VARCHAR2, checksum_in IN VARCHAR2)
+RETURN NUMBER
+IS
+ PRAGMA AUTONOMOUS_TRANSACTION;
+ checksum_id NUMBER;
+BEGIN
+ if checksum_in is null then
+ return null;
+ end if;
+
+ SELECT c.id
+ INTO checksum_id
+ FROM rhnChecksumView c
+ WHERE c.checksum = checksum_in
+ AND c.checksum_type = checksum_type_in;
+
+ RETURN checksum_id;
+EXCEPTION
+ WHEN NO_DATA_FOUND THEN
+ INSERT INTO rhnChecksum (id, checksum_type_id, checksum)
+ VALUES (rhnChecksum_seq.nextval,
+ (select id from rhnChecksumType where label = checksum_type_in),
+ checksum_in)
+ RETURNING id INTO checksum_id;
+ COMMIT;
+ RETURN checksum_id;
+END;
+/
+SHOW ERRORS
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-1-rhnFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-1-rhnFile-checksum.sql
new file mode 100644
index 0000000..49abf2c
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-1-rhnFile-checksum.sql
@@ -0,0 +1,3 @@
+alter table rhnFile add checksum_id NUMBER
+ CONSTRAINT rhn_file_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-2-rhnFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-2-rhnFile-data.sql
new file mode 100644
index 0000000..7e5e185
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-2-rhnFile-data.sql
@@ -0,0 +1,10 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select f.id, md5.id, f.md5sum
+ from rhnFile f,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnFile f
+ set checksum_id = (select id from rhnChecksum c where c.checksum = f.md5sum);
+
+commit;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-3-rhnFile-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-3-rhnFile-md5.sql
new file mode 100644
index 0000000..8cfe5f8
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-3-rhnFile-md5.sql
@@ -0,0 +1,2 @@
+alter table rhnFile drop column md5sum;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-4-rhnFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-4-rhnFile-checksum.sql
new file mode 100644
index 0000000..d1c4b74
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/010-4-rhnFile-checksum.sql
@@ -0,0 +1 @@
+alter table rhnFile modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-1-rhnPackage-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-1-rhnPackage-checksum.sql
new file mode 100644
index 0000000..006cc7f
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-1-rhnPackage-checksum.sql
@@ -0,0 +1,3 @@
+alter table rhnPackage add checksum_id NUMBER
+ CONSTRAINT rhn_package_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
new file mode 100644
index 0000000..eb5ab29
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
@@ -0,0 +1,11 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select p.id, md5.id, p.md5sum
+ from rhnPackage p,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnPackage p
+ set checksum_id = (select c.id from rhnChecksum c where c.checksum = p.md5sum);
+
+commit;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-3-rhnPackage-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-3-rhnPackage-md5.sql
new file mode 100644
index 0000000..df2eca0
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-3-rhnPackage-md5.sql
@@ -0,0 +1 @@
+alter table rhnPackage drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-4-rhnPackage-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-4-rhnPackage-checksum.sql
new file mode 100644
index 0000000..b67d9cc
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-4-rhnPackage-checksum.sql
@@ -0,0 +1 @@
+alter table rhnPackage modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-1-rhnPackageFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-1-rhnPackageFile-checksum.sql
new file mode 100644
index 0000000..20462ea
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-1-rhnPackageFile-checksum.sql
@@ -0,0 +1,3 @@
+alter table rhnPackageFile add checksum_id NUMBER
+ CONSTRAINT rhn_package_file_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
new file mode 100644
index 0000000..190f03b
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
@@ -0,0 +1,11 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select p.id, md5.id, p.md5sum
+ from rhnPackageFile p,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnPackageFile p
+ set checksum_id = (select c.id from rhnChecksum c where c.checksum = p.md5sum);
+
+commit;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-3-rhnPackageFile-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-3-rhnPackageFile-md5.sql
new file mode 100644
index 0000000..f8ad8db
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-3-rhnPackageFile-md5.sql
@@ -0,0 +1 @@
+alter table rhnPackageFile drop column md5;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-1-rhnErrataFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-1-rhnErrataFile-checksum.sql
new file mode 100644
index 0000000..ba57710
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-1-rhnErrataFile-checksum.sql
@@ -0,0 +1,3 @@
+alter table rhnErrataFile add checksum_id NUMBER
+ CONSTRAINT rhn_erratafile_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-2-rhnErrataFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-2-rhnErrataFile-data.sql
new file mode 100644
index 0000000..166e7d5
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-2-rhnErrataFile-data.sql
@@ -0,0 +1,11 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select e.id, md5.id, e.md5sum
+ from rhnErrataFile e,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnErrataFile e
+ set checksum_id = (select c.id from rhnChecksum c where c.checksum = e.md5sum);
+
+commit;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-3-rhnErrataFile-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-3-rhnErrataFile-md5.sql
new file mode 100644
index 0000000..17a8c2f
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-3-rhnErrataFile-md5.sql
@@ -0,0 +1 @@
+alter table rhnErrataFile drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-4-rhnErrataFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-4-rhnErrataFile-checksum.sql
new file mode 100644
index 0000000..41a9318
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-4-rhnErrataFile-checksum.sql
@@ -0,0 +1 @@
+alter table rhnErrataFile modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-1-rhnErrataFileTmp-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-1-rhnErrataFileTmp-checksum.sql
new file mode 100644
index 0000000..2cbc875
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-1-rhnErrataFileTmp-checksum.sql
@@ -0,0 +1,3 @@
+alter table rhnErrataFileTmp add checksum_id NUMBER
+ CONSTRAINT rhn_erratafiletmp_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-2-rhnErrataFileTmp-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-2-rhnErrataFileTmp-data.sql
new file mode 100644
index 0000000..d7bac43
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-2-rhnErrataFileTmp-data.sql
@@ -0,0 +1,11 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select e.id, md5.id, e.md5sum
+ from rhnErrataFileTmp e,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnErrataFileTmp e
+ set checksum_id = (select c.id from rhnChecksum c where c.checksum = e.md5sum);
+
+commit;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-3-rhnErrataFileTmp-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-3-rhnErrataFileTmp-md5.sql
new file mode 100644
index 0000000..fb6685a
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-3-rhnErrataFileTmp-md5.sql
@@ -0,0 +1 @@
+alter table rhnErrataFileTmp drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-4-rhnErrataFileTmp-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-4-rhnErrataFileTmp-checksum.sql
new file mode 100644
index 0000000..c0b4e41
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-4-rhnErrataFileTmp-checksum.sql
@@ -0,0 +1 @@
+alter table rhnErrataFileTmp modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-1-rhnKSTreeFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-1-rhnKSTreeFile-checksum.sql
new file mode 100644
index 0000000..4c695d0
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-1-rhnKSTreeFile-checksum.sql
@@ -0,0 +1,3 @@
+alter table rhnKSTreeFile add checksum_id NUMBER
+ CONSTRAINT rhn_kstreefile_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
new file mode 100644
index 0000000..2e41006
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
@@ -0,0 +1,11 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select k.id, md5.id, k.md5sum
+ from rhnKSTreeFile k,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnKSTreeFile k
+ set checksum_id = (select c.id from rhnChecksum c where c.checksum = k.md5sum);
+
+commit;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-3-rhnKSTreeFile-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-3-rhnKSTreeFile-md5.sql
new file mode 100644
index 0000000..3915149
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-3-rhnKSTreeFile-md5.sql
@@ -0,0 +1 @@
+alter table rhnKSTreeFile drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-4-rhnKSTreeFile-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-4-rhnKSTreeFile-checksum.sql
new file mode 100644
index 0000000..cf47171
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-4-rhnKSTreeFile-checksum.sql
@@ -0,0 +1 @@
+alter table rhnKSTreeFile modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-1-rhnConfigContent-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-1-rhnConfigContent-checksum.sql
new file mode 100644
index 0000000..09824b5
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-1-rhnConfigContent-checksum.sql
@@ -0,0 +1,3 @@
+alter table rhnConfigContent add checksum_id NUMBER
+ CONSTRAINT rhn_confcontent_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-2-rhnConfigContent-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-2-rhnConfigContent-data.sql
new file mode 100644
index 0000000..2bd13b0
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-2-rhnConfigContent-data.sql
@@ -0,0 +1,11 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select cc.id, md5.id, cc.md5sum
+ from rhnConfigContent cc,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnConfigContent cc
+ set checksum_id = (select c.id from rhnChecksum c where c.checksum = cc.md5sum);
+
+commit;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-3-rhnConfigContent-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-3-rhnConfigContent-md5.sql
new file mode 100644
index 0000000..81b835f
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-3-rhnConfigContent-md5.sql
@@ -0,0 +1 @@
+alter table rhnConfigContent drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-4-rhnConfigContent-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-4-rhnConfigContent-checksum.sql
new file mode 100644
index 0000000..2af6aa0
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-4-rhnConfigContent-checksum.sql
@@ -0,0 +1 @@
+alter table rhnConfigContent modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-1-rhnPackageSource-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-1-rhnPackageSource-checksum.sql
new file mode 100644
index 0000000..1c6c5de
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-1-rhnPackageSource-checksum.sql
@@ -0,0 +1,6 @@
+alter table rhnPackageSource add sigchecksum_id NUMBER
+ CONSTRAINT rhn_pkgsrc_sigchsum_fk
+ REFERENCES rhnChecksum (id);
+alter table rhnPackageSource add checksum_id NUMBER
+ CONSTRAINT rhn_pkgsrc_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-2-rhnPackageSource-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-2-rhnPackageSource-data.sql
new file mode 100644
index 0000000..5f0342d
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-2-rhnPackageSource-data.sql
@@ -0,0 +1,21 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select s.id, md5.id, s.sigmd5
+ from rhnPackageSource s,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnPackageSource s
+ set sigchecksum_id = (select c.id from rhnChecksum c where c.checksum = s.sigmd5);
+
+commit;
+
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select s.id, md5.id, s.md5sum
+ from rhnPackageSource s,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnPackageSource s
+ set checksum_id = (select c.id from rhnChecksum c where c.checksum = s.md5sum);
+
+commit;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-3-rhnPackageSource-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-3-rhnPackageSource-md5.sql
new file mode 100644
index 0000000..191f6e2
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-3-rhnPackageSource-md5.sql
@@ -0,0 +1,2 @@
+alter table rhnPackageSource drop column sigmd5;
+alter table rhnPackageSource drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-4-rhnPackageSource-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-4-rhnPackageSource-checksum.sql
new file mode 100644
index 0000000..06510f3
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-4-rhnPackageSource-checksum.sql
@@ -0,0 +1,2 @@
+alter table rhnPackageSource modify sigchecksum_id NUMBER NOT NULL;
+alter table rhnPackageSource modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-1-rhnAppInstallSession-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-1-rhnAppInstallSession-checksum.sql
new file mode 100644
index 0000000..c8e87a7
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-1-rhnAppInstallSession-checksum.sql
@@ -0,0 +1,3 @@
+alter table rhnAppInstallSession add checksum_id NUMBER
+ CONSTRAINT rhn_appinst_session_chsum_fk
+ REFERENCES rhnChecksum (id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-2-rhnAppInstallSession-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-2-rhnAppInstallSession-data.sql
new file mode 100644
index 0000000..c6bc5aa
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-2-rhnAppInstallSession-data.sql
@@ -0,0 +1,11 @@
+insert into rhnChecksum (id, checksum_type_id, checksum)
+ (select s.id, md5.id, s.md5sum
+ from rhnAppInstallSession s,
+ (select id from rhnChecksumType where label = 'md5') md5
+ );
+
+update rhnAppInstallSession s
+ set checksum_id = (select c.id from rhnChecksum c where c.checksum = s.md5sum);
+
+commit;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-3-rhnAppInstallSession-md5.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-3-rhnAppInstallSession-md5.sql
new file mode 100644
index 0000000..714be2b
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-3-rhnAppInstallSession-md5.sql
@@ -0,0 +1 @@
+alter table rhnAppInstallSession drop column md5sum;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-4-rhnAppInstallSession-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-4-rhnAppInstallSession-checksum.sql
new file mode 100644
index 0000000..ede722c
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-4-rhnAppInstallSession-checksum.sql
@@ -0,0 +1 @@
+alter table rhnAppInstallSession modify checksum_id NUMBER NOT NULL;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/019-1-rhnServerActionVerifyResult-checksum.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/019-1-rhnServerActionVerifyResult-checksum.sql
new file mode 100644
index 0000000..7cf3f9a
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/019-1-rhnServerActionVerifyResult-checksum.sql
@@ -0,0 +1,7 @@
+alter table rhnServerActionVerifyResult
+ rename column md5_differs to checksum_differs;
+alter table rhnServerActionVerifyResult
+ drop constraint rhn_sactionvr_md5_ck;
+alter table rhnServerActionVerifyResult
+ add constraint rhn_sactionvr_chsum_ck
+ CHECK (checksum_differs in ( 'Y' , 'N' , '?' ));