RHNKICKSTARTSESSION

Columns

Primary key:

Foreign Keys:

Options:

Indexes:

Referenced by:

Triggers

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;

	-- rob says we want an update if the time changes, but I don't
	-- know of any way to do this that won't result in a mutating
	-- table during the trigger in the delete_server() case, so we're
	-- not doing it now.
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 := current_timestamp;
end;