Bug 679333

Description of problem:

SQL> desc rhnPushClient
 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------
 ID                                        NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(64)
 SERVER_ID                                 NOT NULL NUMBER
 JABBER_ID                                          VARCHAR2(128)
 SHARED_KEY                                NOT NULL VARCHAR2(64)
 STATE_ID                                  NOT NULL NUMBER
 NEXT_ACTION_TIME                                   DATE
 LAST_MESSAGE_TIME                                  DATE
 LAST_PING_TIME                                     DATE
 CREATED                                   NOT NULL DATE
 MODIFIED                                  NOT NULL DATE

rhnPushClient table contains references to rhnServer table (not as a foreign
key), though the table is not being updated when a system is being removed
from rhnServer table.

This state needs to be fixed.

Version-Release number of selected component (if applicable):
spacewalk-schema-1.3.18-1

How reproducible:
Always

Steps to Reproduce:
1. Register a system to Spacewalk, osad running and working
2. Check content of rhnPushClient table
3. Delete the system from Spacewalk (webui for example)
4. Check content of rhnPushClient table again
  
Actual results:
The records from rhnPushClient table are not being deleted.

Expected results:
The records from rhnPushClient table are being deleted.

Additional info:
N/A