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: PHONE_AREA_CODE PHONE_NUMBER PHONE_EXTENSION
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 happen.
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: PHONE_AREA_CODE PHONE_NUMBER PHONE_EXTENSION # What level of users are affected? None. # 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 deployed 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.
on dev.
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.