m2u-upass-admin / DBScript / insert_tb_am_tac.sql @ 88:2ab7c8154b54
History | View | Annotate | Download (1.34 KB)
1 |
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;
|