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;
James, do you think this one will get included before the next QA push next week?
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.
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
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
qa contact == shughes
Use testplan from 160260.
prod ready