m2u-upass-admin / DBScript / tb_am_usermas.sql @ 49:ad895fba5a3b
History | View | Annotate | Download (1.65 KB)
1 |
Rem ===================================================================== |
---|---|
2 |
Rem NAME |
3 |
Rem <tb_am_usermas.sql> |
4 |
Rem DESCRIPTION |
5 |
Rem <User Master Information Table>
|
6 |
Rem MODULE |
7 |
Rem <Authentication Module> |
8 |
Rem MODIFIED (MM/DD/YYYY) |
9 |
Rem YCLiew 12/10/2008 - Creation |
10 |
Rem xxxxxx mm/dd/yyyy - Modify |
11 |
Rem ===================================================================== |
12 |
|
13 |
CREATE TABLE TB_AM_USERMAS |
14 |
( |
15 |
M_USER_ALIAS VARCHAR2(20 BYTE) CONSTRAINT NN_UM_USER_ALIAS NOT NULL, |
16 |
M_USER_ID NUMBER(9) CONSTRAINT NN_UM_USER_ID NOT NULL |
17 |
) |
18 |
TABLESPACE USERS |
19 |
PCTUSED 0
|
20 |
PCTFREE 20
|
21 |
INITRANS 1
|
22 |
MAXTRANS 255
|
23 |
STORAGE ( |
24 |
INITIAL 16K
|
25 |
MINEXTENTS 1
|
26 |
MAXEXTENTS UNLIMITED |
27 |
PCTINCREASE 0
|
28 |
BUFFER_POOL DEFAULT
|
29 |
) |
30 |
LOGGING |
31 |
NOCOMPRESS |
32 |
NOCACHE |
33 |
NOPARALLEL |
34 |
MONITORING; |
35 |
|
36 |
|
37 |
CREATE UNIQUE INDEX PK_UM_USER_ALIAS ON TB_AM_USERMAS |
38 |
(M_USER_ALIAS) |
39 |
LOGGING |
40 |
TABLESPACE USERS |
41 |
PCTFREE 10
|
42 |
INITRANS 2
|
43 |
MAXTRANS 255
|
44 |
STORAGE ( |
45 |
INITIAL 16K
|
46 |
MINEXTENTS 1
|
47 |
MAXEXTENTS UNLIMITED |
48 |
PCTINCREASE 0
|
49 |
BUFFER_POOL DEFAULT
|
50 |
) |
51 |
NOPARALLEL; |
52 |
|
53 |
|
54 |
ALTER TABLE TB_AM_USERMAS ADD ( |
55 |
CONSTRAINT PK_UM_USER_ALIAS
|
56 |
PRIMARY KEY |
57 |
(M_USER_ALIAS) |
58 |
USING INDEX |
59 |
TABLESPACE USERS |
60 |
PCTFREE 10
|
61 |
INITRANS 2
|
62 |
MAXTRANS 255
|
63 |
STORAGE ( |
64 |
INITIAL 16K
|
65 |
MINEXTENTS 1
|
66 |
MAXEXTENTS UNLIMITED |
67 |
PCTINCREASE 0
|
68 |
)); |
69 |
|
70 |
CREATE SEQUENCE seq_user_id
|
71 |
START WITH 10
|
72 |
INCREMENT BY 1 |
73 |
MAXVALUE 999999999
|
74 |
NOCACHE |
75 |
NOCYCLE; |