RHNERRATAPACKAGE
DDL scriptColumns
Name | Type | Nullable | Default value | Comment |
---|
ERRATA_ID | NUMBER(38) | N | | |
PACKAGE_ID | NUMBER(38) | N | | |
CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
Foreign Keys:
Options:
Option | Settings |
---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Indexes:
Triggers
RHN_ERRATA_PACKAGE_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_errata_package_mod_trig
before insert or update or delete on rhnErrataPackage
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
if inserting or updating then
:new.modified := current_timestamp;
end if;
if deleting then
update rhnErrata
set rhnErrata.last_modified = current_timestamp
where rhnErrata.id in ( :old.errata_id );
end if;
end rhn_errata_package_mod_trig;