RHNCHANNEL

Columns

Primary key:

Check Constraints:

Foreign Keys:

Options:

Indexes:

Referenced by:

Triggers

RHN_CHANNEL_ACCESS_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_channel_access_trig
after update on rhnChannel
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
   if :old.channel_access = 'protected' and
      :new.channel_access != 'protected'
   then
      delete from rhnChannelTrust where channel_id = :old.id;
   end if;
end;

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 := current_timestamp;
	-- this is a really bad way of saying "if all we''re
	-- changing is the date"
	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 := current_timestamp;
		end if;
	end if;
end;