Bug 96208 (NPB3750) - removal of phone columns from contact_methods table
Summary: removal of phone columns from contact_methods table
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: NPB3750
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Other
Version: unspecified
Hardware: All
OS: Linux
high
medium
Target Milestone: ---
Assignee: Peter Jones
QA Contact: Karen Jacqmin-Adams
URL:
Whiteboard:
Depends On:
Blocks: 120995
TreeView+ depends on / blocked
 
Reported: 2002-05-09 19:41 UTC by Nick Hansen
Modified: 2007-10-24 02:14 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2004-09-20 18:04:59 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Nick Hansen 2002-05-09 19:41:32 UTC
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

Comment 1 Nick Hansen 2003-06-06 12:18:44 UTC
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.

Comment 2 Nick Hansen 2003-06-26 16:55:54 UTC
I'll take this as work to do, if there are no objections from others that this
happen.

Comment 3 Karen Jacqmin-Adams 2004-05-28 15:00:37 UTC
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.

Comment 4 Peter Jones 2004-05-31 21:57:05 UTC
on dev.

Comment 5 Nick Hansen 2004-06-02 20:25:13 UTC
nope, the specified columns are not present in the rhn_contact_methods
table in either webdev or wedqa. Looks good.

Comment 6 Matt Jamison 2004-06-21 14:02:58 UTC
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.

Comment 7 Fanny Augustin 2004-07-02 22:05:27 UTC
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.  


Note You need to log in before you can comment on or make changes to this bug.