RHNRESETPASSWORD
DDL scriptColumns
Name | Type | Nullable | Default value | Comment |
---|
ID | NUMBER(38) | N | | |
USER_ID | NUMBER(38) | N | | |
TOKEN | VARCHAR2(64) | N | | |
IS_VALID | CHAR(1) | N | 'Y' | |
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_RSTPWD_ID_PK | ID
|
Check Constraints:
Constraint Name | Check Condition |
---|
RHN_RSTPWD_IS_VALID_CK | is_valid IN ('Y', 'N') |
Foreign Keys:
Unique Keys:
Constraint name | Columns |
---|
RHN_RSTPWD_TOKEN_UQ | TOKEN
|
Options:
Option | Settings |
---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Indexes:
Triggers
RHN_RSTPWD_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_rstpwd_mod_trig
before insert or update on rhnResetPassword
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
:new.modified := current_timestamp;
end;