On WEBDEV database.

Test Case #1:

Verify columns and data in rhnPackageSourceChecksum

SQL> desc rhnpackagesourcechecksum
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PACKAGE_ID                                NOT NULL NUMBER
 CHECKSUM_TYPE_ID                          NOT NULL NUMBER
 CHECKSUM                                  NOT NULL VARCHAR2(128)


Test Case #2:

Verify md5sum column has been dropped from rhnPackageSource table:

SQL> desc rhnpackagesource
...

EXPECTED: MD5SUM column should not appear.

Test Case #3:

Verify sample data in rhnPackageSourceChecksum:

SQL> select * from rhnPackageSourceChecksum where rownum < 5;

... should output 4 rows