RHNKICKSTARTSESSION

Columns

Primary key:

Foreign Keys:

Options:

Indexes:

Referenced by:

Triggers

RHN_KSSCRIPT_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_ksscript_mod_trig
before insert or update on rhnKickstartSession
for each row

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

RHN_KS_SESSION_HISTORY_TRIGGER

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_ks_session_history_trigger
after insert or update on rhnKickstartSession
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
	if inserting or (updating and :new.state_id != :old.state_id) then
		insert into rhnKickstartSessionHistory (
				id, kickstart_session_id, action_id, state_id
			) values (
				rhn_ks_sessionhist_id_seq.nextval,
				:new.id,
				:new.action_id,
				:new.state_id
			);
	end if;
end;

RHN_KS_SESSION_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_ks_session_mod_trig
before insert or update on rhnKickstartSession
for each row

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