3 commits - rel-eng/packages spacewalk/package spacewalk/setup
by Miroslav Suchý
rel-eng/packages/spacewalk-setup | 2 +-
spacewalk/package/spacewalk.spec | 2 +-
spacewalk/setup/lib/Spacewalk/Setup.pm | 16 +++++++++++++++-
spacewalk/setup/spacewalk-setup.spec | 5 ++++-
4 files changed, 21 insertions(+), 4 deletions(-)
New commits:
commit 8095c8af31ccf343acace8c7a25cdb52dd7aef6e
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Mon Dec 7 12:20:06 2009 +0100
Automatic commit of package [spacewalk-setup] release [0.8.1-1].
diff --git a/rel-eng/packages/spacewalk-setup b/rel-eng/packages/spacewalk-setup
index f623722..d1595c2 100644
--- a/rel-eng/packages/spacewalk-setup
+++ b/rel-eng/packages/spacewalk-setup
@@ -1 +1 @@
-0.7.7-1 spacewalk/setup/
+0.8.1-1 spacewalk/setup/
diff --git a/spacewalk/setup/spacewalk-setup.spec b/spacewalk/setup/spacewalk-setup.spec
index 3e898e1..266d2d0 100644
--- a/spacewalk/setup/spacewalk-setup.spec
+++ b/spacewalk/setup/spacewalk-setup.spec
@@ -1,5 +1,5 @@
Name: spacewalk-setup
-Version: 0.8.0
+Version: 0.8.1
Release: 1%{?dist}
Summary: Initial setup tools for Red Hat Spacewalk
@@ -106,6 +106,9 @@ rm -rf %{buildroot}
%dir %{_sysconfdir}/pki/spacewalk/jabberd
%changelog
+* Mon Dec 7 2009 Miroslav Suchy <msuchy(a)redhat.com> 0.8.1-1
+- change spinning patter to bowling
+
* Thu Nov 19 2009 Michael Mraka <michael.mraka(a)redhat.com> 0.7.7-1
- make installer look more consistent
commit e972fb294831f8fb4a562143eb1df3f00c7db3ef
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Mon Dec 7 12:17:37 2009 +0100
next release will be bowling (replacing worm)
diff --git a/spacewalk/package/spacewalk.spec b/spacewalk/package/spacewalk.spec
index d04fd2d..51e52fb 100644
--- a/spacewalk/package/spacewalk.spec
+++ b/spacewalk/package/spacewalk.spec
@@ -1,4 +1,4 @@
-%define release_name Gemini
+%define release_name Bowling
Name: spacewalk
Version: 0.8.0
diff --git a/spacewalk/setup/lib/Spacewalk/Setup.pm b/spacewalk/setup/lib/Spacewalk/Setup.pm
index 599ce4c..ad246ee 100644
--- a/spacewalk/setup/lib/Spacewalk/Setup.pm
+++ b/spacewalk/setup/lib/Spacewalk/Setup.pm
@@ -306,18 +306,19 @@ sub upgrade_stop_services {
my $spinning_callback_count;
my @spinning_pattern = (
- '_/\,',
- ' ___,',
- ' _/\,',
- ' ___,',
- ' _/\,',
- ' _,_',
- ' ,/\_',
- ' ,___',
- ' ,/\_',
- ' ,___',
- ',/\_',
- '_,_');
+ '______|||',
+ 'o_____|||',
+ '_o____|||',
+ '__o___|||',
+ '___o__|||',
+ '____o_|||',
+ '_____o/||',
+ '______o/|',
+ '_______o/',
+ '________o',
+ '_________',
+ '______///',
+);
my $spinning_pattern_maxlength = 0;
for (@spinning_pattern) {
commit d8d87e678b9950b3e895c7efc0b27a387b5a8b85
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Mon Dec 7 12:12:29 2009 +0100
splitting spinning patter to multiple lines, for easier overview
diff --git a/spacewalk/setup/lib/Spacewalk/Setup.pm b/spacewalk/setup/lib/Spacewalk/Setup.pm
index 5289272..599ce4c 100644
--- a/spacewalk/setup/lib/Spacewalk/Setup.pm
+++ b/spacewalk/setup/lib/Spacewalk/Setup.pm
@@ -305,7 +305,20 @@ sub upgrade_stop_services {
}
my $spinning_callback_count;
-my @spinning_pattern = ('_/\,', ' ___,', ' _/\,', ' ___,', ' _/\,', ' _,_', ' ,/\_', ' ,___', ' ,/\_', ' ,___', ',/\_', '_,_');
+my @spinning_pattern = (
+ '_/\,',
+ ' ___,',
+ ' _/\,',
+ ' ___,',
+ ' _/\,',
+ ' _,_',
+ ' ,/\_',
+ ' ,___',
+ ' ,/\_',
+ ' ,___',
+ ',/\_',
+ '_,_');
+
my $spinning_pattern_maxlength = 0;
for (@spinning_pattern) {
if (length > $spinning_pattern_maxlength) {
14 years, 4 months
rel-eng/tito.props
by Miroslav Suchý
rel-eng/tito.props | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
New commits:
commit 9f14a1b62b2d3baeedfd64113a73cb63d5eefc44
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Fri Dec 4 17:12:49 2009 +0100
bumping up version for tito
diff --git a/rel-eng/tito.props b/rel-eng/tito.props
index 9b13600..d6e97d9 100644
--- a/rel-eng/tito.props
+++ b/rel-eng/tito.props
@@ -3,15 +3,15 @@ default_builder = spacewalk.releng.builder.Builder
default_tagger = spacewalk.releng.tagger.VersionTagger
[koji]
-autobuild_tags = dist-f11-sw-0.7-candidate dist-5E-sw-0.7-candidate dist-f12-sw-0.7-candidate
+autobuild_tags = dist-f11-sw-0.8-candidate dist-5E-sw-0.8-candidate dist-f12-sw-0.8-candidate
-[dist-f11-sw-0.7-candidate]
+[dist-f11-sw-0.8-candidate]
disttag = .fc11
blacklist=jabberd-selinux
-[dist-5E-sw-0.7-candidate]
+[dist-5E-sw-0.8-candidate]
disttag = .el5
-[dist-f12-sw-0.7-candidate]
+[dist-f12-sw-0.8-candidate]
disttag = .fc12
blacklist=jabberd-selinux
14 years, 4 months
Changes to 'refs/tags/rhnlib-2.5.17-1'
by Miroslav Suchý
Tag 'rhnlib-2.5.17-1' created by Miroslav Suchý <msuchy(a)redhat.com> at 2009-12-04 16:07 +0000
Tagging package [rhnlib] version [2.5.17-1] in directory [client/rhel/rhnlib/].
Changes since spacewalk-schema-0.8.1-1:
Miroslav Suchý (1):
Automatic commit of package [rhnlib] release [2.5.17-1].
---
client/rhel/rhnlib/rhnlib.spec | 5 ++++-
rel-eng/packages/rhnlib | 2 +-
2 files changed, 5 insertions(+), 2 deletions(-)
---
14 years, 4 months
client/rhel rel-eng/packages
by Miroslav Suchý
client/rhel/rhnlib/rhnlib.spec | 5 ++++-
rel-eng/packages/rhnlib | 2 +-
2 files changed, 5 insertions(+), 2 deletions(-)
New commits:
commit b924afd2acc94ad997a0e6388a962374a87f6541
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Fri Dec 4 17:07:54 2009 +0100
Automatic commit of package [rhnlib] release [2.5.17-1].
diff --git a/client/rhel/rhnlib/rhnlib.spec b/client/rhel/rhnlib/rhnlib.spec
index 3f987f1..d0a6642 100644
--- a/client/rhel/rhnlib/rhnlib.spec
+++ b/client/rhel/rhnlib/rhnlib.spec
@@ -4,7 +4,7 @@ Summary: Python libraries for the RHN project
Name: rhnlib
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
-Version: 2.5.16
+Version: 2.5.17
Release: 1%{?dist}
Group: Development/Libraries
@@ -54,6 +54,9 @@ rm -rf $RPM_BUILD_ROOT
%{python_sitelib}/*
%changelog
+* Fri Dec 4 2009 Miroslav Suchý <msuchy(a)redhat.com> 2.5.17-1
+- sha256 support
+
* Fri Dec 04 2009 Michael Mraka <michael.mraka(a)redhat.com> 2.5.16-1
- added rhn_rpm and rhn_mpm
diff --git a/rel-eng/packages/rhnlib b/rel-eng/packages/rhnlib
index 543e357..243514d 100644
--- a/rel-eng/packages/rhnlib
+++ b/rel-eng/packages/rhnlib
@@ -1 +1 @@
-2.5.16-1 client/rhel/rhnlib/
+2.5.17-1 client/rhel/rhnlib/
14 years, 4 months
Changes to 'refs/tags/spacewalk-schema-0.8.1-1'
by Michael Mraka
Tag 'spacewalk-schema-0.8.1-1' created by Michael Mraka <michael.mraka(a)redhat.com> at 2009-12-04 15:39 +0000
Tagging package [spacewalk-schema] version [0.8.1-1] in directory [schema/spacewalk/].
Changes since rhnpush-5.4.4-1:
Michael Mraka (2):
moved sha256 related upgrade scripts to appropriate directory
Automatic commit of package [spacewalk-schema] release [0.8.1-1].
---
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(-)
---
14 years, 4 months
2 commits - rel-eng/packages schema/spacewalk
by Michael Mraka
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' , '?' ));
14 years, 4 months
Changes to 'refs/tags/rhnpush-5.4.4-1'
by Miroslav Suchý
Tag 'rhnpush-5.4.4-1' created by Miroslav Suchý <msuchy(a)redhat.com> at 2009-12-04 15:35 +0000
Tagging package [rhnpush] version [5.4.4-1] in directory [client/tools/rhnpush/].
Changes since spacewalk-proxy-0.8.1-1:
Miroslav Suchý (1):
Automatic commit of package [rhnpush] release [5.4.4-1].
---
client/tools/rhnpush/rhnpush.spec | 5 ++++-
rel-eng/packages/rhnpush | 2 +-
2 files changed, 5 insertions(+), 2 deletions(-)
---
14 years, 4 months
client/tools rel-eng/packages
by Miroslav Suchý
client/tools/rhnpush/rhnpush.spec | 5 ++++-
rel-eng/packages/rhnpush | 2 +-
2 files changed, 5 insertions(+), 2 deletions(-)
New commits:
commit a349b73c34e1d2d2f6d982a79754536a3dfb4939
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Fri Dec 4 16:35:59 2009 +0100
Automatic commit of package [rhnpush] release [5.4.4-1].
diff --git a/client/tools/rhnpush/rhnpush.spec b/client/tools/rhnpush/rhnpush.spec
index 10b8318..26efa29 100644
--- a/client/tools/rhnpush/rhnpush.spec
+++ b/client/tools/rhnpush/rhnpush.spec
@@ -5,7 +5,7 @@ Summary: Common programs needed to be installed on the RHN servers/proxies
Group: Applications/System
License: GPLv2
URL: http://fedorahosted.org/spacewalk
-Version: 5.4.3
+Version: 5.4.4
Release: 1%{?dist}
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u} -n)
@@ -49,6 +49,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man8/solaris2mpm.8*
%changelog
+* Fri Dec 4 2009 Miroslav Suchý <msuchy(a)redhat.com> 5.4.4-1
+- merge uploadLib.py
+
* Fri Dec 04 2009 Michael Mraka <michael.mraka(a)redhat.com> 5.4.3-1
- rhn_rpm/rhn_mpm moved to rhnlib
diff --git a/rel-eng/packages/rhnpush b/rel-eng/packages/rhnpush
index 1f00051..42ea7a4 100644
--- a/rel-eng/packages/rhnpush
+++ b/rel-eng/packages/rhnpush
@@ -1 +1 @@
-5.4.3-1 client/tools/rhnpush/
+5.4.4-1 client/tools/rhnpush/
14 years, 4 months
Changes to 'refs/tags/spacewalk-proxy-0.8.1-1'
by Miroslav Suchý
Tag 'spacewalk-proxy-0.8.1-1' created by Miroslav Suchý <msuchy(a)redhat.com> at 2009-12-04 15:34 +0000
Tagging package [spacewalk-proxy] version [0.8.1-1] in directory [proxy/proxy/].
Changes since spacewalk-backend-0.8.2-1:
Miroslav Suchý (1):
Automatic commit of package [spacewalk-proxy] release [0.8.1-1].
---
proxy/proxy/spacewalk-proxy.spec | 5 ++++-
rel-eng/packages/spacewalk-proxy | 2 +-
2 files changed, 5 insertions(+), 2 deletions(-)
---
14 years, 4 months
proxy/proxy rel-eng/packages
by Miroslav Suchý
proxy/proxy/spacewalk-proxy.spec | 5 ++++-
rel-eng/packages/spacewalk-proxy | 2 +-
2 files changed, 5 insertions(+), 2 deletions(-)
New commits:
commit 00efb762a87e52945a96bbcb8048da2ffb4ca1ed
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Fri Dec 4 16:34:10 2009 +0100
Automatic commit of package [spacewalk-proxy] release [0.8.1-1].
diff --git a/proxy/proxy/spacewalk-proxy.spec b/proxy/proxy/spacewalk-proxy.spec
index 62901f3..99a0dc5 100644
--- a/proxy/proxy/spacewalk-proxy.spec
+++ b/proxy/proxy/spacewalk-proxy.spec
@@ -4,7 +4,7 @@ Group: Applications/Internet
License: GPLv2
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
-Version: 0.8.0
+Version: 0.8.1
Release: 1%{?dist}
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u} -n)
BuildRequires: python
@@ -294,6 +294,9 @@ fi
%changelog
+* Fri Dec 4 2009 Miroslav Suchý <msuchy(a)redhat.com> 0.8.1-1
+- sha256 support
+
* Wed Nov 25 2009 Miroslav Suchý <msuchy(a)redhat.com> 0.7.2-1
- 499020 - bump up proxy version to 5.3.1 to enable CDN
diff --git a/rel-eng/packages/spacewalk-proxy b/rel-eng/packages/spacewalk-proxy
index 387be88..c790be4 100644
--- a/rel-eng/packages/spacewalk-proxy
+++ b/rel-eng/packages/spacewalk-proxy
@@ -1 +1 @@
-0.7.2-1 proxy/proxy/
+0.8.1-1 proxy/proxy/
14 years, 4 months