RHNSERVERGROUPMEMBERS

Columns

Foreign Keys:

Options:

Indexes:

Triggers

RHN_SERVER_GROUP_ORG_MAPPING

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_server_group_org_mapping
BEFORE INSERT OR UPDATE ON rhnServerGroupMembers
FOR EACH ROW

REFERENCING NEW AS NEW OLD AS OLD
DECLARE
        same_org        NUMBER;
BEGIN
        same_org := 0;
        SELECT 1 INTO same_org
          FROM rhnServer S, rhnServerGroup SG
         WHERE SG.org_id = S.org_id
           AND S.id = :new.server_id
           AND SG.id = :new.server_group_id;
        IF same_org = 0 THEN
          rhn_exception.raise_exception('sgm_insert_diff_orgs');
        END IF;
EXCEPTION
        WHEN NO_DATA_FOUND THEN
          rhn_exception.raise_exception('sgm_insert_diff_orgs');
END;

RHN_SG_MEMBER_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_sg_member_mod_trig
before insert or update on rhnServerGroupMembers
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
        :new.modified := sysdate;
end;