RHNCHANNEL

Columns

Primary key:

Check Constraints:

Foreign Keys:

Options:

Indexes:

Referenced by:

Triggers

RHN_CHANNEL_DEL_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_channel_del_trig
before delete on rhnChannel
for each row

REFERENCING NEW AS NEW OLD AS OLD
declare
	cursor snapshots is
		select	snapshot_id id
		from	rhnSnapshotChannel
		where	channel_id = :old.id;
begin
	for snapshot in snapshots loop
		update rhnSnapshot
			set invalid = lookup_snapshot_invalid_reason('channel_removed')
			where id = snapshot.id;
		delete from rhnSnapshotChannel
			where snapshot_id = snapshot.id
				and channel_id = :old.id;
	end loop;
end;

RHN_CHANNEL_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_channel_mod_trig
before insert or update on rhnChannel
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
	:new.last_modified := sysdate;
	if updating then
		if (:old.id != :new.id) or
		  (:old.parent_channel != :new.parent_channel) or
		  (:old.org_id != :new.org_id) or
		  (:old.channel_arch_id != :new.channel_arch_id) or
		  (:old.label != :new.label) or
		  (:old.basedir != :new.basedir) or
		  (:old.name != :new.name) or
		  (:old.summary != :new.summary) or
		  (:old.description != :new.description) then
			:new.modified := sysdate;
		end if;
	end if;
end;