RHNPACKAGE

Columns

Primary key:

Check Constraints:

Foreign Keys:

Options:

Indexes:

Referenced by:

Triggers

RHN_PACKAGE_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_package_mod_trig
before insert or update on rhnPackage
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
	-- when we do a sat sync, we use last_modified to keep track
	-- of the upstream modification date.  So if we're setting
	-- it explicitly, don't override with sysdate.  But if we're
	-- not changing it, then this is a genuine update that needs
	-- tracking.
	--
	-- we're not using is_satellite() here instead, because we
	-- might want to use this to keep webdev in sync.
	if :new.last_modified = :old.last_modified then
		:new.last_modified := sysdate;
	end if;
	:new.modified := sysdate;
end;