m2u-upass-admin / DBScript / insert_tb_am_tac.sql @ 33:0eec2c6c7dce
History | View | Annotate | Download (1.34 KB)
1 | 0:ea666cc7880e | hadi | Rem ===================================================================== |
---|---|---|---|
2 | Rem NAME |
||
3 | Rem <insert_tb_am_tac.sql> |
||
4 | Rem DESCRIPTION |
||
5 | Rem <Insert Data into UPASS TAC Table> |
||
6 | Rem MODULE |
||
7 | Rem <Authentication Module> |
||
8 | Rem MODIFIED (MM/DD/YYYY) |
||
9 | Rem Danniell 03/12/2010 - Creation |
||
10 | Rem xxxxxx mm/dd/yyyy - Modify |
||
11 | Rem ===================================================================== |
||
12 | |||
13 | SET DEFINE OFF;
|
||
14 | Insert into TB_AM_TAC |
||
15 | (T_USER_ID, T_TAC_CIPHERTEXT, T_TAC_STATE, T_DATE_GENERATED, T_DATE_FIRST_USED, |
||
16 | T_DATE_LAST_USED, T_USE_COUNT, T_ERROR_COUNT, T_SESSION_ID) |
||
17 | Values
|
||
18 | (1, NULL, 0, SYSTIMESTAMP, NULL, |
||
19 | NULL, 0, 0, NULL); |
||
20 | Insert into TB_AM_TAC |
||
21 | (T_USER_ID, T_TAC_CIPHERTEXT, T_TAC_STATE, T_DATE_GENERATED, T_DATE_FIRST_USED, |
||
22 | T_DATE_LAST_USED, T_USE_COUNT, T_ERROR_COUNT, T_SESSION_ID) |
||
23 | Values
|
||
24 | (2, NULL, 0, SYSTIMESTAMP, NULL, |
||
25 | NULL, 0, 0, NULL); |
||
26 | Insert into TB_AM_TAC |
||
27 | (T_USER_ID, T_TAC_CIPHERTEXT, T_TAC_STATE, T_DATE_GENERATED, T_DATE_FIRST_USED, |
||
28 | T_DATE_LAST_USED, T_USE_COUNT, T_ERROR_COUNT, T_SESSION_ID) |
||
29 | Values
|
||
30 | (3, NULL, 0, SYSTIMESTAMP, NULL, |
||
31 | NULL, 0, 0, NULL); |
||
32 | Insert into TB_AM_TAC |
||
33 | (T_USER_ID, T_TAC_CIPHERTEXT, T_TAC_STATE, T_DATE_GENERATED, T_DATE_FIRST_USED, |
||
34 | T_DATE_LAST_USED, T_USE_COUNT, T_ERROR_COUNT, T_SESSION_ID) |
||
35 | Values
|
||
36 | (4, NULL, 0, SYSTIMESTAMP, NULL, |
||
37 | NULL, 0, 0, NULL); |
||
38 | COMMIT; |