Red Hat Bugzilla – Bug 96208
removal of phone columns from contact_methods table
Last modified: 2007-10-23 22:14:26 EDT
Given that phone contact methods are permanently deprecated, we should remove
the following columns from the contact_methods table:
This is a bug that has been migrated over from the old NOCpulse Bugzilla. The original NP bugid was 3750, the original reporter was Alyssa Umsawasdi, and the original assigned to was Greg Peters.
I'll take this as work to do, if there are no objections from others that this
I dropped the phone columns as part of monitoring schema migration.
# How was this issue addressed?
Dropped these columns from rhn_contact_method in initial definition:
# What level of users are affected?
# Where specifically can the change be seen?
Database schema only
# If the change cannot be verified visually, how should it be tested?
1) sqlplus command: "desc rhn_contact_methods" should not be able
to find the specified phone columns after the monitoring schema is
2) monitoring schema should deploy rhn_contact_methods cleanly
Transfering bug to Peter to mark as ON_DEV when the monitoring schema
is deployed to webdev.
nope, the specified columns are not present in the rhn_contact_methods
table in either webdev or wedqa. Looks good.
need to test on sat.
moving back to on_qa and upgrading priority to high since it's a
schema change and needs a fine tooth comb.
This is mainly a database schema change so I do not think it will
affect satellite build one way or the other. I have been working
with the sats all week long and I have not observed any anomallies.