Bug 96208 (NPB3750)

Summary:	removal of phone columns from contact_methods table
Product:	Red Hat Satellite 5	Reporter:	Nick Hansen <nhansen>
Component:	Other	Assignee:	Peter Jones <pjones>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Karen Jacqmin-Adams <kja>
Severity:	medium	Docs Contact:
Priority:	high
Version:	unspecified	CC:	nhansen
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2004-09-20 18:04:59 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	120995

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.