ACS3 Data Model

CREATE TRIGGER portal_tables_audit_trigger
before update or delete  on portal_tables
  for each row
    REFERENCING NEW AS NEW OLD AS OLD
When  (old.table_name is not null and (new.table_name is null or old.table_name <> new.table_name))
        or (old.admin_url is not null and (new.admin_url is null or old.admin_url <> new.admin_url))
	or (old.modified_date is not null and (new.modified_date is null or old.modified_date <> new.modified_date))
 
begin
       insert into portal_tables_audit
	(audit_id, table_id, table_name, adp, admin_url, modified_date, creation_user, audit_time)
       values
       	(portal_audit_id_sequence.nextval, :old.table_id, :old.table_name, :old.adp, :old.admin_url, :old.modified_date, :old.creation_user,  sysdate);
     end;