RHNREPOREGENQUEUE
DDL scriptColumns
Name | Type | Nullable | Default value | Comment |
---|
ID | NUMBER(38) | N | | |
CHANNEL_LABEL | VARCHAR2(128) | N | | |
CLIENT | VARCHAR2(128) | Y | | |
REASON | VARCHAR2(128) | Y | | |
FORCE | CHAR(1) | Y | | |
BYPASS_FILTERS | CHAR(1) | Y | | |
NEXT_ACTION | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | (current_timestamp) | |
CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
Primary key:
Constraint Name | Columns |
---|
RHN_REPOREGENQ_ID_PK | ID
|
Options:
Option | Settings |
---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Indexes:
Index Name | Type | Unuqueness | Columns | DDL script |
---|
RHN_REPOREGENQ_ID_PK | NORMAL | UNIQUE | ID
| DDL script |
Triggers
RHN_REPO_REGEN_QUEUE_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_repo_regen_queue_mod_trig
before insert or update on rhnRepoRegenQueue
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
if :new.id is null then
select rhn_repo_regen_queue_id_seq.nextval into :new.id from dual;
end if;
:new.modified := current_timestamp;
end;