m2u-upass-admin / DBScript / admin_audit_log.sql @ 5:8c9d33d99a2a
History | View | Annotate | Download (2.2 KB)
1 |
Rem ===================================================================== |
---|---|
2 |
Rem NAME |
3 |
Rem <admin_audit_log.sql> |
4 |
Rem DESCRIPTION |
5 |
Rem <Admin Audit Log Table>
|
6 |
Rem MODULE |
7 |
Rem <MSS 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 |
CREATE TABLE ADMIN_AUDIT_LOG |
14 |
( |
15 |
LOG_ID NUMBER NOT NULL, |
16 |
AUDIT_CATEGORY_ID NUMBER NOT NULL, |
17 |
LOG_DESCRIPTION VARCHAR2(256 BYTE) NOT NULL, |
18 |
LOG_CREATION_DATE TIMESTAMP(2) DEFAULT SYSDATE NOT NULL, |
19 |
LOG_STATUS NUMBER, |
20 |
LOG_REASON VARCHAR2(256 BYTE), |
21 |
LOG_CREATED_BY VARCHAR2(64 BYTE), |
22 |
LOG_GROUP_ID NUMBER, |
23 |
LOG_ROLE_ID NUMBER |
24 |
) |
25 |
TABLESPACE USERS |
26 |
PCTUSED 0
|
27 |
PCTFREE 10
|
28 |
INITRANS 1
|
29 |
MAXTRANS 255
|
30 |
STORAGE ( |
31 |
INITIAL 64K
|
32 |
NEXT 128K
|
33 |
MINEXTENTS 1
|
34 |
MAXEXTENTS UNLIMITED |
35 |
PCTINCREASE 0
|
36 |
FREELISTS 1
|
37 |
FREELIST GROUPS 1
|
38 |
BUFFER_POOL DEFAULT
|
39 |
) |
40 |
LOGGING |
41 |
NOCOMPRESS |
42 |
NOCACHE |
43 |
NOPARALLEL |
44 |
MONITORING; |
45 |
|
46 |
|
47 |
CREATE UNIQUE INDEX ADMIN_AUDIT_LOG_PK ON ADMIN_AUDIT_LOG |
48 |
(LOG_ID) |
49 |
LOGGING |
50 |
TABLESPACE USERS |
51 |
PCTFREE 10
|
52 |
INITRANS 2
|
53 |
MAXTRANS 255
|
54 |
STORAGE ( |
55 |
INITIAL 64K
|
56 |
NEXT 128K
|
57 |
MINEXTENTS 1
|
58 |
MAXEXTENTS UNLIMITED |
59 |
PCTINCREASE 0
|
60 |
FREELISTS 1
|
61 |
FREELIST GROUPS 1
|
62 |
BUFFER_POOL DEFAULT
|
63 |
) |
64 |
NOPARALLEL; |
65 |
|
66 |
|
67 |
ALTER TABLE ADMIN_AUDIT_LOG ADD ( |
68 |
CONSTRAINT ADMIN_AUDIT_LOG_PK
|
69 |
PRIMARY KEY |
70 |
(LOG_ID) |
71 |
USING INDEX |
72 |
TABLESPACE USERS |
73 |
PCTFREE 10
|
74 |
INITRANS 2
|
75 |
MAXTRANS 255
|
76 |
STORAGE ( |
77 |
INITIAL 64K
|
78 |
NEXT 128K
|
79 |
MINEXTENTS 1
|
80 |
MAXEXTENTS UNLIMITED |
81 |
PCTINCREASE 0
|
82 |
FREELISTS 1
|
83 |
FREELIST GROUPS 1
|
84 |
)); |