Branch 'sha256-support2' - 2 commits - schema/spacewalk

[Michael Mraka]

schema/spacewalk/common/tables/rhnPackageChecksum.sql                                       |    3 ---
 schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/006-move-checksum.sql |    2 +-
 2 files changed, 1 insertion(+), 4 deletions(-)

New commits:
commit f03ef9f26cbc057aba2462b1edebb80926d33da0
Author: Michael Mraka 
Date:   Mon Oct 5 16:59:21 2009 +0200

fixed table reference (removed test schema)

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
index 6dd4a9c..f43f20f 100644
--- 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
@@ -1,7 +1,7 @@

insert into rhnPackageChecksum (package_id, checksum_type_id, checksum)
         (select p.id, md5.id, md5sum
-           from test1064.rhnPackage p,
+           from rhnPackage p,
                 (select id from rhnpackageChecksumType where label = 'md5') md5
         );

commit 01ecd6ff00ddecaae90416e67ff50842f5c79635
Author: Michael Mraka 
Date:   Mon Oct 5 12:15:00 2009 +0200

don't create index separately

diff --git a/schema/spacewalk/common/tables/rhnPackageChecksum.sql b/schema/spacewalk/common/tables/rhnPackageChecksum.sql
index cb99de1..093e0b9 100644
--- a/schema/spacewalk/common/tables/rhnPackageChecksum.sql
+++ b/schema/spacewalk/common/tables/rhnPackageChecksum.sql
@@ -32,8 +32,5 @@ rhnPackageChecksum
         enable row movement
 ;

-create index rhn_pkgcsum_id_n_idx
-        on rhnPackageChecksum (package_id, checksum_type_id)
-
 alter table rhnPackageChecksum add constraint rhn_pkg_checksum_id_pk primary key (package_id, checksum_type_id);