Bug 159257 - Need extra columns for recurring notification filters
Need extra columns for recurring notification filters
Status: CLOSED CURRENTRELEASE
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Other (Show other bugs)
unspecified
All Linux
medium Severity medium
: ---
: ---
Assigned To: James Slagle
Shannon Hughes
:
Depends On:
Blocks: 150608 160260
  Show dependency treegraph
 
Reported: 2005-05-31 18:18 EDT by Mike McCune
Modified: 2007-10-23 22:10 EDT (History)
1 user (show)

See Also:
Fixed In Version: RHN 4.0.0
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2005-08-31 16:42:20 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Mike McCune 2005-05-31 18:18:26 EDT
Here is the script I used to create the extra columns necessary on the
rhn_redirects table:


ALTER TABLE rhn.rhn_redirects
    ADD recurring NUMBER(12,0) DEFAULT '0' NOT NULL;



ALTER TABLE rhn.rhn_redirects
    ADD ( CONSTRAINT RHN_RDRCT_RECUR_VALID
	CHECK (recurring IN('0', '1')));

ALTER TABLE rhn.rhn_redirects
    ADD recurring_frequency NUMBER(12,0) DEFAULT 2 NULL;

ALTER TABLE rhn.rhn_redirects
    ADD ( CONSTRAINT RHN_RDRCT_RECUR_FREQ_VALID
	CHECK (recurring_frequency IN(2, 3, 6)));

ALTER TABLE rhn.rhn_redirects
    ADD recurring_duration NUMBER(12,0) DEFAULT 0 NULL;
Comment 1 Mike McCune 2005-06-03 20:45:07 EDT
James, do you think this one will get included before the next QA push next week?  
Comment 2 James Slagle 2005-06-06 11:49:02 EDT
Applied to hosted, change script at:
rhn-svn/trunk/eng/schema/changes/dev/400/xml/159257.00.rhn_redirects_columns.xml

Change applied to satellite schema in svn.

This will go in tomorrow's QA push.
Comment 3 Mike McCune 2005-06-17 20:34:36 EDT
AGH!  While working on bz 160260 I found that I needed an extra column to store
the recurring durration type.  This needs to get adding in to the above set of
changes.  I apologize for the late notice on this one.

ALTER TABLE rhnsat.rhn_redirects
    ADD recurring_dur_type NUMBER(12,0) DEFAULT 12 NULL
GO

ALTER TABLE RHNSAT.RHN_REDIRECTS
    ADD ( CONSTRAINT RHN_RDRCT_REC_DTYPE_VALID
	CHECK (recurring_dur_type in (12,11,5,3,1))) 
GO
Comment 4 James Slagle 2005-06-23 16:03:03 EDT
Change applied to satellite schema / hosted.  Change script for hosted:
rhn-svn/trunk/eng/schema/changes/dev/400/xml/159257.01.more_columns_rhn_redirects.xml
Comment 5 Bret McMillan 2005-07-25 22:52:05 EDT
qa contact == shughes
Comment 6 James Slagle 2005-07-27 23:04:38 EDT
Use testplan from 160260.
Comment 7 Shannon Hughes 2005-07-29 16:25:31 EDT
prod ready

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