RHNKICKSTARTABLETREE
DDL scriptColumns
Name | Type | Nullable | Default value | Comment |
---|
ID | NUMBER(38) | N | | |
ORG_ID | NUMBER(38) | Y | | |
LABEL | VARCHAR2(64) | N | | |
BASE_PATH | VARCHAR2(256) | N | | |
CHANNEL_ID | NUMBER(38) | N | | |
COBBLER_ID | VARCHAR2(64) | Y | | |
COBBLER_XEN_ID | VARCHAR2(64) | Y | | |
BOOT_IMAGE | VARCHAR2(128) | Y | ('spacewalk-koan') | |
KSTREE_TYPE | NUMBER(38) | N | | |
INSTALL_TYPE | NUMBER(38) | N | | |
KERNEL_OPTIONS | VARCHAR2(256) | Y | | |
KERNEL_OPTIONS_POST | VARCHAR2(256) | Y | | |
LAST_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (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_KSTREE_ID_PK | ID
|
Foreign Keys:
Options:
Option | Settings |
---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Indexes:
Referenced by:
Triggers
RHN_KSTREE_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_kstree_mod_trig
before insert or update on rhnKickstartableTree
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
if ((not :old.cobbler_id is null and :new.cobbler_id = :old.cobbler_id) or
(:old.cobbler_id is null and :new.cobbler_id is null)) and
((not :old.cobbler_xen_id is null and :new.cobbler_xen_id = :old.cobbler_xen_id) or
(:old.cobbler_xen_id is null and :new.cobbler_xen_id is null)) and
(:new.last_modified = :old.last_modified) or
(:new.last_modified is null ) then
:new.last_modified := current_timestamp;
end if;
:new.modified := current_timestamp;
end rhn_kstree_mod_trig;