RHNSERVERGROUPMEMBERS
DDL scriptColumns
Name | Type | Nullable | Default value | Comment |
---|
SERVER_ID | NUMBER(38) | N | | |
SERVER_GROUP_ID | NUMBER(38) | N | | |
CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
Foreign Keys:
Options:
Option | Settings |
---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Indexes:
Triggers
RHN_SERVER_GROUP_ORG_MAPPING
Legend: 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: 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 := current_timestamp;
end;