schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/004-2-rhnChecksumType-data.sql
| 11 ++++++
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/010-2-rhnFile-data.sql
| 8 -----
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
| 8 -----
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
| 8 -----
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/013-2-rhnErrataFile-data.sql
| 8 -----
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/014-2-rhnErrataFileTmp-data.sql
| 8 -----
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
| 8 -----
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/016-2-rhnConfigContent-data.sql
| 8 -----
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/017-2-rhnPackageSource-data.sql
| 16 +---------
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/018-2-rhnAppInstallSession-data.sql
| 8 -----
11 files changed, 21 insertions(+), 84 deletions(-)
New commits:
commit 8c97c65ffd3977e675f3c834d291640191c2db2e
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon Dec 7 16:38:36 2009 +0100
added upgrade script for rhnChecksumType data
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/004-2-rhnChecksumType-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/004-2-rhnChecksumType-data.sql
new file mode 100644
index 0000000..a035be1
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/004-2-rhnChecksumType-data.sql
@@ -0,0 +1,11 @@
+update rhnChecksumType
+ set label = translate(label, ' -', ' ');
+
+update rhnChecksumType
+ set description = label || 'sum';
+
+insert into rhnChecksumType (id, label, description) values
+ (rhn_checksum_id_seq.nextval, 'sha224', 'sha224sum' );
+
+commit;
+
commit 96e72916acc57fbd698997c6c8ecd13f70b9868d
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon Dec 7 16:25:32 2009 +0100
fixed sha256 related data upgrade scripts
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
deleted file mode 100644
index f43f20f..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/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.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
index 7e5e185..72d56cb 100644
---
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
@@ -1,10 +1,4 @@
-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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;
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
index eb5ab29..25f6381 100644
---
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
@@ -1,11 +1,5 @@
-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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;
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
index 190f03b..1366aee 100644
---
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
@@ -1,11 +1,5 @@
-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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;
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
index 166e7d5..7cf6030 100644
---
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
@@ -1,11 +1,5 @@
-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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;
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
index d7bac43..3419e7f 100644
---
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
@@ -1,11 +1,5 @@
-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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;
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
index 2e41006..4b4b94e 100644
---
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
@@ -1,11 +1,5 @@
-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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;
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
index 2bd13b0..e0d61cb 100644
---
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
@@ -1,11 +1,5 @@
-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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;
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
index 5f0342d..7cbf121 100644
---
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
@@ -1,21 +1,9 @@
-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);
+ set sigchecksum_id = lookup_checksum('md5', 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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;
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
index c6bc5aa..0209c49 100644
---
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
@@ -1,11 +1,5 @@
-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);
+ set checksum_id = lookup_checksum('md5', md5sum);
commit;