m2u-upass-ws / test / resources / db-scripts / m2u-upass-ci-oracle.sql @ 118:1602007a5ca3
History | View | Annotate | Download (80.2 KB)
1 |
--------------------------------------------------------
|
---|---|
2 |
-- File created - Friday-July-19-2013
|
3 |
--------------------------------------------------------
|
4 |
DROP TABLE "M2U_UPASS_CI"."SMS_TABLE" cascade constraints; |
5 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" cascade constraints; |
6 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" cascade constraints; |
7 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" cascade constraints; |
8 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" cascade constraints; |
9 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_TAC" cascade constraints; |
10 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" cascade constraints; |
11 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_USER" cascade constraints; |
12 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" cascade constraints; |
13 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" cascade constraints; |
14 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" cascade constraints; |
15 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_VASCO" cascade constraints; |
16 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_ACTION" cascade constraints; |
17 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" cascade constraints; |
18 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_CONFIG" cascade constraints; |
19 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_GROUP" cascade constraints; |
20 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" cascade constraints; |
21 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" cascade constraints; |
22 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" cascade constraints; |
23 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" cascade constraints; |
24 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_ROLE" cascade constraints; |
25 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" cascade constraints; |
26 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP" cascade constraints; |
27 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY" cascade constraints; |
28 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY_BACKUP" cascade constraints; |
29 |
DROP TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" cascade constraints; |
30 |
DROP TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" cascade constraints; |
31 |
DROP TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" cascade constraints; |
32 |
DROP TABLE "M2U_UPASS_CI"."IB_USER" cascade constraints; |
33 |
DROP TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" cascade constraints; |
34 |
|
35 |
DROP TABLE "M2U_UPASS_CI"."M2U_USER" cascade constraints; |
36 |
DROP TABLE "M2U_UPASS_CI"."TICKETING_USER" cascade constraints; |
37 |
DROP TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" cascade constraints; |
38 |
DROP TABLE "M2U_UPASS_CI"."STOCK_USER" cascade constraints; |
39 |
DROP TABLE "M2U_UPASS_CI"."IM2U_USER" cascade constraints; |
40 |
DROP TABLE "M2U_UPASS_CI"."CLIENT_APP" cascade constraints; |
41 |
DROP TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" cascade constraints; |
42 |
|
43 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_SEQ_TRNX"; |
44 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_SEQ_SESS"; |
45 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML_OID_SEQ"; |
46 |
DROP SEQUENCE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG_LOG_ID_SEQ"; |
47 |
DROP SEQUENCE "M2U_UPASS_CI"."ADMIN_GROUP_GROUP_ID_SEQ"; |
48 |
DROP SEQUENCE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP__SEQ"; |
49 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_OID_SEQ"; |
50 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_TYPE_OID_SEQ"; |
51 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_USER_USER_ID_SEQ"; |
52 |
DROP SEQUENCE "M2U_UPASS_CI"."SEQ_USER_ID_SEQ_VALUE_SEQ"; |
53 |
DROP SEQUENCE "M2U_UPASS_CI"."SMS_TABLE_OID_SEQ"; |
54 |
DROP SEQUENCE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP_OID_SEQ"; |
55 |
DROP SEQUENCE "M2U_UPASS_CI"."TB_AM_USER_BACKUP_OID_SEQ"; |
56 |
|
57 |
--------------------------------------------------------
|
58 |
-- DDL for Sequence IB_SEQ_TRNX
|
59 |
--------------------------------------------------------
|
60 |
|
61 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_SEQ_TRNX" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; |
62 |
|
63 |
--------------------------------------------------------
|
64 |
-- DDL for Sequence IB_SEQ_SESS
|
65 |
--------------------------------------------------------
|
66 |
|
67 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_SEQ_SESS" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; |
68 |
|
69 |
--------------------------------------------------------
|
70 |
-- DDL for Sequence SEQ_USER_ID_SEQ_VALUE_SEQ
|
71 |
--------------------------------------------------------
|
72 |
|
73 |
CREATE SEQUENCE "M2U_UPASS_CI"."SEQ_USER_ID_SEQ_VALUE_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 2000 CACHE 20 NOORDER NOCYCLE ; |
74 |
--------------------------------------------------------
|
75 |
-- DDL for Sequence SMS_TABLE_OID_SEQ
|
76 |
--------------------------------------------------------
|
77 |
|
78 |
CREATE SEQUENCE "M2U_UPASS_CI"."SMS_TABLE_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 3400 CACHE 20 NOORDER NOCYCLE ; |
79 |
--------------------------------------------------------
|
80 |
-- DDL for Sequence TB_AM_TAC_BACKUP_OID_SEQ
|
81 |
--------------------------------------------------------
|
82 |
|
83 |
CREATE SEQUENCE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 40 CACHE 20 NOORDER NOCYCLE ; |
84 |
--------------------------------------------------------
|
85 |
-- DDL for Sequence TB_AM_USER_BACKUP_OID_SEQ
|
86 |
--------------------------------------------------------
|
87 |
|
88 |
CREATE SEQUENCE "M2U_UPASS_CI"."TB_AM_USER_BACKUP_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 200 CACHE 20 NOORDER NOCYCLE ; |
89 |
--------------------------------------------------------
|
90 |
-- DDL for Sequence ADMIN_AUDIT_LOG_LOG_ID_SEQ
|
91 |
--------------------------------------------------------
|
92 |
|
93 |
CREATE SEQUENCE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG_LOG_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; |
94 |
--------------------------------------------------------
|
95 |
-- DDL for Sequence ADMIN_GROUP_GROUP_ID_SEQ
|
96 |
--------------------------------------------------------
|
97 |
|
98 |
CREATE SEQUENCE "M2U_UPASS_CI"."ADMIN_GROUP_GROUP_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 660 CACHE 20 NOORDER NOCYCLE ; |
99 |
--------------------------------------------------------
|
100 |
-- DDL for Sequence ADMIN_USER_PROFILE_BACKUP__SEQ
|
101 |
--------------------------------------------------------
|
102 |
|
103 |
CREATE SEQUENCE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP__SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 16 CACHE 20 NOORDER NOCYCLE ; |
104 |
--------------------------------------------------------
|
105 |
-- DDL for Sequence IB_CONTENT_CATEGORY_OID_SEQ
|
106 |
--------------------------------------------------------
|
107 |
|
108 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 600 CACHE 20 NOORDER NOCYCLE ; |
109 |
--------------------------------------------------------
|
110 |
-- DDL for Sequence IB_CONTENT_TYPE_OID_SEQ
|
111 |
--------------------------------------------------------
|
112 |
|
113 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_TYPE_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 17 CACHE 20 NOORDER NOCYCLE ; |
114 |
--------------------------------------------------------
|
115 |
-- DDL for Sequence IB_USER_USER_ID_SEQ
|
116 |
--------------------------------------------------------
|
117 |
|
118 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_USER_USER_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1010 CACHE 20 NOORDER NOCYCLE ; |
119 |
|
120 |
--------------------------------------------------------
|
121 |
-- DDL for Sequence IB_CONTENT_CATEGORY_ML_OID_SEQ
|
122 |
--------------------------------------------------------
|
123 |
|
124 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 331 CACHE 20 NOORDER NOCYCLE ; |
125 |
|
126 |
--------------------------------------------------------
|
127 |
-- DDL for Table CLIENT_APP
|
128 |
--------------------------------------------------------
|
129 |
|
130 |
CREATE TABLE "M2U_UPASS_CI"."CLIENT_APP" ( |
131 |
"APP_ID" NUMBER(10,0) PRIMARY KEY, |
132 |
"APP_NAME" VARCHAR2(100 CHAR) |
133 |
); |
134 |
|
135 |
--------------------------------------------------------
|
136 |
-- Constraints for Table CLIENT_APP
|
137 |
--------------------------------------------------------
|
138 |
|
139 |
ALTER TABLE "M2U_UPASS_CI"."CLIENT_APP" MODIFY ("APP_ID" NOT NULL ENABLE); |
140 |
ALTER TABLE "M2U_UPASS_CI"."CLIENT_APP" MODIFY ("APP_NAME" NOT NULL ENABLE); |
141 |
|
142 |
--------------------------------------------------------
|
143 |
-- DDL for Table USER_APP_ACCESS
|
144 |
--------------------------------------------------------
|
145 |
|
146 |
CREATE TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" ( |
147 |
"USER_ID" NUMBER(10,0) , |
148 |
"APP_ID" NUMBER(10,0), |
149 |
"ACCESS_TYPE" CHAR(1 CHAR), |
150 |
"REGISTRATION_TIME" TIMESTAMP, |
151 |
CONSTRAINT PK_USER_APP_ACCESS PRIMARY KEY ( USER_ID , APP_ID ) |
152 |
); |
153 |
create index M2U_UPASS_CI.IDX_USER_APP_ACCESS_USER_ID on M2U_UPASS_CI.USER_APP_ACCESS("USER_ID"); |
154 |
|
155 |
--------------------------------------------------------
|
156 |
-- Constraints for Table USER_APP_ACCESS
|
157 |
--------------------------------------------------------
|
158 |
|
159 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("USER_ID" NOT NULL ENABLE); |
160 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("APP_ID" NOT NULL ENABLE); |
161 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("ACCESS_TYPE" NOT NULL ENABLE); |
162 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("REGISTRATION_TIME" NOT NULL ENABLE); |
163 |
|
164 |
--------------------------------------------------------
|
165 |
-- DDL for Table M2U_USER
|
166 |
--------------------------------------------------------
|
167 |
|
168 |
CREATE TABLE "M2U_UPASS_CI"."M2U_USER" ( |
169 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
170 |
"IBPAN" VARCHAR2(30 CHAR), |
171 |
"IBPAN2" VARCHAR2(30 CHAR) |
172 |
); |
173 |
|
174 |
--------------------------------------------------------
|
175 |
-- DDL for Table TICKETING_USER
|
176 |
--------------------------------------------------------
|
177 |
|
178 |
CREATE TABLE "M2U_UPASS_CI"."TICKETING_USER" ( |
179 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
180 |
"FULL_NAME" VARCHAR2(200 CHAR), |
181 |
"FIRST_NAME" VARCHAR2(200 CHAR), |
182 |
"LAST_NAME" VARCHAR2(200 CHAR), |
183 |
"PAYEE_CODE" VARCHAR2(20 CHAR) |
184 |
); |
185 |
|
186 |
--------------------------------------------------------
|
187 |
-- DDL for Table IBCC_PUBLIC_USER
|
188 |
--------------------------------------------------------
|
189 |
|
190 |
CREATE TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" ( |
191 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
192 |
"PAN_CC" VARCHAR2(20 CHAR) |
193 |
); |
194 |
|
195 |
--------------------------------------------------------
|
196 |
-- DDL for Table STOCK_USER
|
197 |
--------------------------------------------------------
|
198 |
|
199 |
CREATE TABLE "M2U_UPASS_CI"."STOCK_USER" ( |
200 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
201 |
"HIGH_NET_WORTH_ATTR" CHAR(1 CHAR), |
202 |
"CUST_TYPE" NUMBER(10,0), |
203 |
"ID_NO" VARCHAR2(20 CHAR), |
204 |
"ACTIVE_ATTR" CHAR(1 CHAR), |
205 |
"ST_ACCOUNT_NO" VARCHAR2(20 CHAR), |
206 |
"PAL_ACCOUNT_NO" VARCHAR2(20 CHAR) |
207 |
); |
208 |
|
209 |
--------------------------------------------------------
|
210 |
-- DDL for Table IM2U_USER
|
211 |
--------------------------------------------------------
|
212 |
|
213 |
CREATE TABLE "M2U_UPASS_CI"."IM2U_USER" ( |
214 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
215 |
"WS_FLAG" CHAR(1 CHAR), |
216 |
"WS_IDENT_CODE" VARCHAR2(100 CHAR), |
217 |
"WS_MY_SG_ID" VARCHAR2(20 CHAR), |
218 |
"WS_REG_TIMESTAMP" TIMESTAMP |
219 |
); |
220 |
|
221 |
|
222 |
--------------------------------------------------------
|
223 |
-- DDL for Table SMS_TABLE
|
224 |
--------------------------------------------------------
|
225 |
|
226 |
CREATE TABLE "M2U_UPASS_CI"."SMS_TABLE" |
227 |
( "OID" NUMBER(38,2), |
228 |
"SMS_CREATESTAMP" TIMESTAMP, |
229 |
"SMS_IBREF_NO" VARCHAR2(20 CHAR), |
230 |
"SMS_IC_NO" VARCHAR2(30 CHAR), |
231 |
"SMS_CUST_NAME" VARCHAR2(40 CHAR), |
232 |
"SMS_HP_NO" VARCHAR2(30 CHAR), |
233 |
"SMS_MESSAGE" VARCHAR2(512 CHAR), |
234 |
"SMS_SERVICE" VARCHAR2(64 CHAR), |
235 |
"SMS_STATUS" VARCHAR2(4 CHAR), |
236 |
"CREATION_DATE" TIMESTAMP, |
237 |
"SMS_GUID" VARCHAR2(45 CHAR), |
238 |
"SMS_SDDATESTAMP" TIMESTAMP, |
239 |
"SMS_RCDATESTAMP" TIMESTAMP, |
240 |
"SMS_CHECK" VARCHAR2(2 CHAR), |
241 |
"SMS_PRIORITY" VARCHAR2(2 CHAR), |
242 |
"SMS_TYPE" VARCHAR2(64 CHAR), |
243 |
"STATUS" VARCHAR2(64 CHAR), |
244 |
"REFERENCE" VARCHAR2(50 CHAR), |
245 |
"REMOTE_IP" VARCHAR2(64 CHAR), |
246 |
"OTHER1" VARCHAR2(50 CHAR), |
247 |
"OTHER2" VARCHAR2(50 CHAR), |
248 |
"AMOUNT" NUMBER(38,2), |
249 |
"IB_SERVICE" VARCHAR2(50 CHAR) |
250 |
) ; |
251 |
--------------------------------------------------------
|
252 |
-- DDL for Table TB_AM_APPSERV
|
253 |
--------------------------------------------------------
|
254 |
|
255 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" |
256 |
( |
257 |
"A_USER_ID" NUMBER(10,0), |
258 |
"A_APP_SERV_ID" VARCHAR2(10 CHAR), |
259 |
"A_APP_SERV_ACCESS1" VARCHAR2(20 CHAR), |
260 |
"A_APP_SERV_ACCESS2" VARCHAR2(20 CHAR), |
261 |
"A_APP_SERV_AUTH_LIST" VARCHAR2(20 CHAR) , |
262 |
CONSTRAINT PK_TB_AM_APPSERV PRIMARY KEY ( A_USER_ID , A_APP_SERV_ID ) |
263 |
); |
264 |
--------------------------------------------------------
|
265 |
-- DDL for Table TB_AM_CONFIG
|
266 |
--------------------------------------------------------
|
267 |
|
268 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" |
269 |
( |
270 |
"CONFIG_NAME" VARCHAR2(64 CHAR), |
271 |
"CONFIG_VALUE" VARCHAR2(128 CHAR), |
272 |
"CONFIG_DESCRIPTION" VARCHAR2(256 CHAR), |
273 |
"APPLICATION_ID" NUMBER(10,0), |
274 |
"MK_PENDING" NUMBER(38,2), |
275 |
CONSTRAINT PK_TB_AM_CONFIG PRIMARY KEY ( CONFIG_NAME , APPLICATION_ID ) |
276 |
) ; |
277 |
--------------------------------------------------------
|
278 |
-- DDL for Table TB_AM_CONFIG_CHANGE
|
279 |
--------------------------------------------------------
|
280 |
|
281 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" |
282 |
( "CONFIG_UPDATE" NUMBER(10,0) PRIMARY KEY |
283 |
) ; |
284 |
--------------------------------------------------------
|
285 |
-- DDL for Table TB_AM_GEMALTO
|
286 |
--------------------------------------------------------
|
287 |
|
288 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" |
289 |
( "G_SERIAL_NO" VARCHAR2(22 CHAR) PRIMARY KEY, |
290 |
"G_USER_ID" NUMBER(10,0), |
291 |
"G_DP_MODEL" VARCHAR2(5 CHAR), |
292 |
"G_DP_AUTH_MODE" VARCHAR2(2 CHAR), |
293 |
"G_DP_CIPHERTEXT" BLOB, |
294 |
"G_BAK_CIPHERTEXT" BLOB, |
295 |
"G_DP_ASSIGNED" NUMBER(10,0), |
296 |
"G_DATE_ASSIGNED" TIMESTAMP, |
297 |
"G_DATE_FIRST_USED" TIMESTAMP, |
298 |
"G_DATE_LAST_USED" TIMESTAMP, |
299 |
"G_USE_COUNT" NUMBER(10,0), |
300 |
"G_ERROR_COUNT" NUMBER(10,0), |
301 |
"G_DP_STATE" NUMBER(10,0), |
302 |
"G_BATCH_NO" VARCHAR2(8 CHAR) |
303 |
) ; |
304 |
--------------------------------------------------------
|
305 |
-- DDL for Table TB_AM_TAC
|
306 |
--------------------------------------------------------
|
307 |
|
308 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_TAC" |
309 |
( "T_USER_ID" NUMBER(10,0) PRIMARY KEY, |
310 |
"T_TAC_CIPHERTEXT" VARCHAR2(128 CHAR), |
311 |
"T_TAC_STATE" NUMBER(10,0), |
312 |
"T_DATE_GENERATED" TIMESTAMP, |
313 |
"T_DATE_FIRST_USED" TIMESTAMP, |
314 |
"T_DATE_LAST_USED" TIMESTAMP, |
315 |
"T_USE_COUNT" NUMBER(10,0), |
316 |
"T_ERROR_COUNT" NUMBER(10,0), |
317 |
"T_SESSION_ID" VARCHAR2(32 CHAR) |
318 |
) ; |
319 |
--------------------------------------------------------
|
320 |
-- DDL for Table TB_AM_TAC_BACKUP
|
321 |
--------------------------------------------------------
|
322 |
|
323 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" |
324 |
( "OID" NUMBER(10,0) PRIMARY KEY, |
325 |
"T_USER_ID" NUMBER(10,0), |
326 |
"T_TAC_CIPHERTEXT" VARCHAR2(64 CHAR), |
327 |
"T_TAC_STATE" NUMBER(10,0), |
328 |
"T_DATE_GENERATED" TIMESTAMP, |
329 |
"T_DATE_FIRST_USED" TIMESTAMP, |
330 |
"T_DATE_LAST_USED" CHAR(10 CHAR), |
331 |
"T_USE_COUNT" NUMBER(10,0), |
332 |
"T_ERROR_COUNT" NUMBER(10,0), |
333 |
"T_SESSION_ID" VARCHAR2(32 CHAR), |
334 |
"T_APPLICATION_ID" NUMBER(10,0) |
335 |
) ; |
336 |
--------------------------------------------------------
|
337 |
-- DDL for Table TB_AM_USER
|
338 |
--------------------------------------------------------
|
339 |
|
340 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USER" |
341 |
( "U_USER_ID" NUMBER(10,0) PRIMARY KEY, |
342 |
"U_USER_ALIAS" VARCHAR2(50 CHAR) unique, |
343 |
"U_USER_TYPE" NUMBER(10,0), |
344 |
"U_USER_DESC" VARCHAR2(40 CHAR), |
345 |
"U_DATE_CREATED" TIMESTAMP, |
346 |
"U_DATE_LAST_USED" TIMESTAMP, |
347 |
"U_USE_COUNT" NUMBER(19,0), |
348 |
"U_DATE_LAST_ACT" TIMESTAMP, |
349 |
"U_DATE_LAST_LOCK" TIMESTAMP, |
350 |
"U_USER_STATE" NUMBER(10,0), |
351 |
"U_DATE_LOCK_FROM" TIMESTAMP, |
352 |
"U_DATE_LOCK_TO" TIMESTAMP, |
353 |
"P_PASSWD_CIPHERTEXT" VARCHAR2(64 CHAR), |
354 |
"P_PASSWD_STATE" NUMBER(10,0), |
355 |
"P_DATE_GENERATED" TIMESTAMP, |
356 |
"P_DATE_FIRST_USED" TIMESTAMP, |
357 |
"P_DATE_LAST_USED" TIMESTAMP, |
358 |
"P_USE_COUNT" NUMBER(19,0), |
359 |
"P_ERROR_COUNT" NUMBER(10,0), |
360 |
"P_EXPIRED_STATUS" NUMBER(10,0), |
361 |
"P_DATE_EXPIRED" TIMESTAMP, |
362 |
"P_PASSWD_HIST" VARCHAR(1024), |
363 |
"U_APPLICATION_ID" NUMBER(10,0) |
364 |
) ; |
365 |
|
366 |
--------------------------------------------------------
|
367 |
-- DDL for Table TB_AM_USERMAS
|
368 |
--------------------------------------------------------
|
369 |
|
370 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" |
371 |
( "M_USER_ALIAS" VARCHAR2(20 CHAR) PRIMARY KEY, |
372 |
"M_USER_ID" NUMBER(10,0) |
373 |
) ; |
374 |
--------------------------------------------------------
|
375 |
-- DDL for Table TB_AM_USERMAS_BACKUP
|
376 |
--------------------------------------------------------
|
377 |
|
378 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" |
379 |
( "M_USER_ALIAS" VARCHAR2(50 CHAR) PRIMARY KEY, |
380 |
"M_USER_ID" NUMBER(10,0) |
381 |
) ; |
382 |
--------------------------------------------------------
|
383 |
-- DDL for Table TB_AM_USER_BACKUP
|
384 |
--------------------------------------------------------
|
385 |
|
386 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" |
387 |
( "OID" NUMBER(10,0) PRIMARY KEY, |
388 |
"U_USER_ID" NUMBER(10,0), |
389 |
"U_USER_ALIAS" VARCHAR2(50 CHAR), |
390 |
"U_USER_TYPE" NUMBER(10,0), |
391 |
"U_USER_DESC" VARCHAR2(40 CHAR), |
392 |
"U_DATE_CREATED" TIMESTAMP, |
393 |
"U_DATE_LAST_USED" TIMESTAMP, |
394 |
"U_USE_COUNT" NUMBER(19,0), |
395 |
"U_DATE_LAST_ACT" TIMESTAMP, |
396 |
"U_DATE_LAST_LOCK" TIMESTAMP, |
397 |
"U_USER_STATE" NUMBER(10,0), |
398 |
"U_DATE_LOCK_FROM" TIMESTAMP, |
399 |
"U_DATE_LOCK_TO" TIMESTAMP, |
400 |
"P_PASSWD_CIPHERTEXT" VARCHAR2(64 CHAR), |
401 |
"P_PASSWD_STATE" NUMBER(10,0), |
402 |
"P_DATE_GENERATED" TIMESTAMP, |
403 |
"P_DATE_FIRST_USED" TIMESTAMP, |
404 |
"P_DATE_LAST_USED" TIMESTAMP, |
405 |
"P_USE_COUNT" NUMBER(19,0), |
406 |
"P_ERROR_COUNT" NUMBER(10,0), |
407 |
"P_EXPIRED_STATUS" NUMBER(10,0), |
408 |
"P_DATE_EXPIRED" TIMESTAMP, |
409 |
"P_PASSWD_HIST" VARCHAR2(1024 CHAR), |
410 |
"U_APPLICATION_ID" NUMBER(10,0) |
411 |
) ; |
412 |
--------------------------------------------------------
|
413 |
-- DDL for Table TB_AM_VASCO
|
414 |
--------------------------------------------------------
|
415 |
|
416 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_VASCO" |
417 |
( "V_SERIAL_NO" VARCHAR2(22 CHAR) PRIMARY KEY, |
418 |
"V_USER_ID" NUMBER(10,0), |
419 |
"V_DP_MODEL" VARCHAR2(5 CHAR), |
420 |
"V_DP_AUTH_MODE" VARCHAR2(2 CHAR), |
421 |
"V_DP_CIPHERTEXT" BLOB, |
422 |
"V_BAK_CIPHERTEXT" BLOB, |
423 |
"V_DP_ASSIGNED" NUMBER(10,0), |
424 |
"V_DATE_ASSIGNED" TIMESTAMP, |
425 |
"V_DATE_FIRST_USED" TIMESTAMP, |
426 |
"V_DATE_LAST_USED" TIMESTAMP, |
427 |
"V_USE_COUNT" NUMBER(10,0), |
428 |
"V_ERROR_COUNT" NUMBER(10,0), |
429 |
"V_DP_STATE" NUMBER(10,0), |
430 |
"V_BATCH_NO" VARCHAR2(8 CHAR) |
431 |
) ; |
432 |
|
433 |
--------------------------------------------------------
|
434 |
-- DDL for Table ADMIN_ACTION
|
435 |
--------------------------------------------------------
|
436 |
|
437 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_ACTION" |
438 |
( "ACTION_ID" NUMBER(38,2) PRIMARY KEY, |
439 |
"ACTION" VARCHAR2(64 CHAR), |
440 |
"APPROVABLE" NUMBER(10,0), |
441 |
"MK_PENDING" NUMBER(10,0) |
442 |
); |
443 |
|
444 |
--------------------------------------------------------
|
445 |
-- DDL for Table ADMIN_AUDIT_LOG
|
446 |
--------------------------------------------------------
|
447 |
|
448 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" |
449 |
( "LOG_ID" NUMBER(38,2), |
450 |
"AUDIT_CATEGORY_ID" NUMBER(38,2), |
451 |
"LOG_DESCRIPTION" VARCHAR2(256 CHAR), |
452 |
"LOG_CREATION_DATE" TIMESTAMP, |
453 |
"LOG_STATUS" NUMBER(38,2), |
454 |
"LOG_REASON" VARCHAR2(256 CHAR), |
455 |
"LOG_CREATED_BY" VARCHAR2(64 CHAR), |
456 |
"LOG_GROUP_ID" NUMBER(38,2), |
457 |
"LOG_ROLE_ID" NUMBER(38,2), |
458 |
"LOG_BEFORE_STATE" CLOB,
|
459 |
"LOG_AFTER_STATE" CLOB,
|
460 |
"LOG_AUTH_REASON" VARCHAR2(256 CHAR), |
461 |
"LOG_IP_ADDRESS" VARCHAR2(50 CHAR), |
462 |
"LOG_INITIATOR_ID" NUMBER(38,2), |
463 |
"LOG_ACTION_ID" NUMBER(38,2) |
464 |
); |
465 |
|
466 |
--------------------------------------------------------
|
467 |
-- DDL for Table ADMIN_CONFIG
|
468 |
--------------------------------------------------------
|
469 |
|
470 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_CONFIG" |
471 |
( "CONFIG_NAME" CLOB,
|
472 |
"CONFIG_VALUE" CLOB,
|
473 |
"CONFIG_DESCRIPTION" CLOB
|
474 |
); |
475 |
|
476 |
--------------------------------------------------------
|
477 |
-- DDL for Table ADMIN_GROUP
|
478 |
--------------------------------------------------------
|
479 |
|
480 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_GROUP" |
481 |
( "GROUP_ID" NUMBER(38,2), |
482 |
"GROUP_NAME" VARCHAR2(64 CHAR), |
483 |
"GROUP_DESCRIPTION" VARCHAR2(256 CHAR), |
484 |
"GROUP_CREATED_BY" NUMBER(38,2), |
485 |
"GROUP_UPDATED_BY" NUMBER(38,2), |
486 |
"GROUP_CREATION_DATE" TIMESTAMP, |
487 |
"GROUP_UPDATED_DATE" TIMESTAMP, |
488 |
"CATEGORY" NUMBER(38,2), |
489 |
"GROUP_LVL" NUMBER(38,2), |
490 |
"MODE_TYPE" VARCHAR2(1 CHAR), |
491 |
"MK_PENDING" NUMBER(10,0) |
492 |
); |
493 |
|
494 |
--------------------------------------------------------
|
495 |
-- DDL for Table ADMIN_NAVIGATION
|
496 |
--------------------------------------------------------
|
497 |
|
498 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" |
499 |
( "NODE_ID" NUMBER(38,2), |
500 |
"PARENT_ID" NUMBER(38,2), |
501 |
"NODE_NAME" VARCHAR2(64 CHAR), |
502 |
"NODE_DESCRIPTION" VARCHAR2(256 CHAR), |
503 |
"NODE_TYPE" VARCHAR2(1 CHAR), |
504 |
"NODE_STATUS" VARCHAR2(1 CHAR), |
505 |
"NODE_CODE" VARCHAR2(16 CHAR), |
506 |
"NODE_DISPLAY_ORDER" NUMBER(38,2), |
507 |
"PAGE_PATH" VARCHAR2(256 CHAR), |
508 |
"NODE_CREATED_BY" NUMBER(38,2), |
509 |
"NODE_UPDATED_BY" NUMBER(38,2), |
510 |
"NODE_CREATION_DATE" TIMESTAMP, |
511 |
"NODE_UPDATED_DATE" TIMESTAMP, |
512 |
"CATEGORY" NUMBER(38,2), |
513 |
"NODE_SYSTEM" VARCHAR2(64 CHAR), |
514 |
"MK_PENDING" NUMBER(38,2) |
515 |
); |
516 |
|
517 |
--------------------------------------------------------
|
518 |
-- DDL for Table ADMIN_NAVIGATION_ACTION
|
519 |
--------------------------------------------------------
|
520 |
|
521 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" |
522 |
( "NAVIGATION_ID" NUMBER(38,2), |
523 |
"ACTION_ID" NUMBER(38,2) |
524 |
); |
525 |
|
526 |
--------------------------------------------------------
|
527 |
-- DDL for Table ADMIN_NAVIGATION_GROUP
|
528 |
--------------------------------------------------------
|
529 |
|
530 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" |
531 |
( "NAVIGATION_ID" NUMBER(38,2), |
532 |
"GROUP_ID" NUMBER(38,2), |
533 |
"IS_EDIT" NUMBER(38,2), |
534 |
"IS_VIEW" NUMBER(38,2), |
535 |
"NODE_CODE" VARCHAR2(16 CHAR) |
536 |
); |
537 |
|
538 |
--------------------------------------------------------
|
539 |
-- DDL for Table ADMIN_PERMISSION
|
540 |
--------------------------------------------------------
|
541 |
|
542 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" |
543 |
( "USER_ID" NUMBER(38,2), |
544 |
"ACTION_ID" NUMBER(38,2), |
545 |
"IS_APPROVER" NUMBER(10,0) |
546 |
); |
547 |
|
548 |
--------------------------------------------------------
|
549 |
-- DDL for Table ADMIN_ROLE
|
550 |
--------------------------------------------------------
|
551 |
|
552 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_ROLE" |
553 |
( "ROLE_ID" NUMBER(38,2), |
554 |
"ROLE_NAME" VARCHAR2(64 CHAR), |
555 |
"ROLE_DESCRIPTION" VARCHAR2(256 CHAR), |
556 |
"ROLE_CREATED_BY" NUMBER(38,2), |
557 |
"ROLE_UPDATED_BY" NUMBER(38,2), |
558 |
"ROLE_CREATION_DATE" TIMESTAMP, |
559 |
"ROLE_UPDATED_DATE" DATE |
560 |
); |
561 |
|
562 |
--------------------------------------------------------
|
563 |
-- DDL for Table ADMIN_USER_PROFILE
|
564 |
--------------------------------------------------------
|
565 |
|
566 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" |
567 |
( "USER_ID" NUMBER(38,2), |
568 |
"ROLE_ID" NUMBER(38,2), |
569 |
"GROUP_ID" NUMBER(38,2), |
570 |
"USER_NAME" VARCHAR2(64 CHAR), |
571 |
"USER_DOB" VARCHAR2(8 CHAR), |
572 |
"USER_EMAIL" VARCHAR2(64 CHAR), |
573 |
"USER_GENDER" VARCHAR2(1 CHAR), |
574 |
"USER_RACE" VARCHAR2(4 CHAR), |
575 |
"USER_OFFICE_NUMBER" VARCHAR2(30 CHAR), |
576 |
"USER_MOBILE_NUMBER" VARCHAR2(30 CHAR), |
577 |
"CREATED_BY" NUMBER(38,2), |
578 |
"UPDATED_BY" NUMBER(38,2), |
579 |
"UPDATED_DATE" TIMESTAMP, |
580 |
"LAST_LOGIN_DATE" TIMESTAMP, |
581 |
"FORCE_RESET" NUMBER(38,2), |
582 |
"MK_PENDING" NUMBER(38,2), |
583 |
"LAST_IP_ADDRESS" VARCHAR2(50 CHAR), |
584 |
"LAST_HOST_NAME" VARCHAR2(50 CHAR), |
585 |
"USER_ADMIN_ROLE" VARCHAR2(10 CHAR) |
586 |
); |
587 |
|
588 |
--------------------------------------------------------
|
589 |
-- DDL for Table ADMIN_USER_PROFILE_BACKUP
|
590 |
--------------------------------------------------------
|
591 |
|
592 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP" |
593 |
( "OID" NUMBER(10,0), |
594 |
"USER_ID" NUMBER(38,2), |
595 |
"ROLE_ID" NUMBER(38,2), |
596 |
"GROUP_ID" NUMBER(38,2), |
597 |
"USER_NAME" VARCHAR2(200 CHAR), |
598 |
"USER_DOB" VARCHAR2(8 CHAR), |
599 |
"USER_EMAIL" VARCHAR2(64 CHAR), |
600 |
"USER_GENDER" VARCHAR2(1 CHAR), |
601 |
"USER_RACE" VARCHAR2(4 CHAR), |
602 |
"USER_OFFICE_NUMBER" VARCHAR2(20 CHAR), |
603 |
"USER_MOBILE_NUMBER" VARCHAR2(20 CHAR), |
604 |
"CREATED_BY" NUMBER(38,2), |
605 |
"UPDATED_BY" NUMBER(38,2), |
606 |
"UPDATED_DATE" TIMESTAMP, |
607 |
"LAST_LOGIN_DATE" TIMESTAMP, |
608 |
"FORCE_RESET" NUMBER(38,2), |
609 |
"MK_PENDING" NUMBER(38,2) |
610 |
); |
611 |
|
612 |
--------------------------------------------------------
|
613 |
-- DDL for Table ADMIN_USER_SECURITY
|
614 |
--------------------------------------------------------
|
615 |
|
616 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY" |
617 |
( "USER_ID" NUMBER(38,2), |
618 |
"IB_SESSION_ID" VARCHAR2(255 CHAR) |
619 |
) ; |
620 |
|
621 |
--------------------------------------------------------
|
622 |
-- DDL for Table ADMIN_USER_SECURITY_BACKUP
|
623 |
--------------------------------------------------------
|
624 |
|
625 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY_BACKUP" |
626 |
( "USER_ID" NUMBER(38,2), |
627 |
"IB_SESSION_ID" VARCHAR2(255 CHAR), |
628 |
"OID" NUMBER(10,0) |
629 |
) ; |
630 |
--------------------------------------------------------
|
631 |
-- DDL for Table IB_CONTENT_CATEGORY
|
632 |
--------------------------------------------------------
|
633 |
|
634 |
CREATE TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" |
635 |
( "OID" NUMBER(38,2), |
636 |
"PARENT_ID" NUMBER(38,2), |
637 |
"CREATION_DATE" TIMESTAMP, |
638 |
"LAST_MOD_DATE" TIMESTAMP, |
639 |
"CONTENT_TYPE_ID" NUMBER(38,2), |
640 |
"CATEGORY_TYPE" VARCHAR2(64 CHAR), |
641 |
"MK_PENDING" NUMBER(38,2) |
642 |
); |
643 |
--------------------------------------------------------
|
644 |
-- DDL for Table IB_CONTENT_TYPE
|
645 |
--------------------------------------------------------
|
646 |
|
647 |
CREATE TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" |
648 |
( "OID" NUMBER(38,2), |
649 |
"CONTENT_TYPE_CODE" VARCHAR2(64 CHAR), |
650 |
"CONTENT_PATH" VARCHAR2(256 CHAR), |
651 |
"CONTENT_TABLE_NAME" VARCHAR2(64 CHAR), |
652 |
"CREATION_DATE" DATE |
653 |
); |
654 |
--------------------------------------------------------
|
655 |
-- DDL for Table IB_CUST_PROFILE
|
656 |
--------------------------------------------------------
|
657 |
|
658 |
CREATE TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" |
659 |
( "USER_ID" NUMBER(38,2), |
660 |
"USER_NAME" VARCHAR2(200 CHAR), |
661 |
"USER_DOB_BRD" VARCHAR2(8 CHAR), |
662 |
"USER_EMAIL" VARCHAR2(64 CHAR), |
663 |
"USER_GENDER" VARCHAR2(1 CHAR), |
664 |
"USER_RACE" VARCHAR2(4 CHAR), |
665 |
"USER_HOME_PHONE" VARCHAR2(30 CHAR), |
666 |
"USER_OFFICE_PHONE" VARCHAR2(30 CHAR), |
667 |
"USER_MOBILE_PHONE" VARCHAR2(30 CHAR), |
668 |
"USER_TAC_PHONE" VARCHAR2(30 CHAR), |
669 |
"USER_ADDR1" VARCHAR2(64 CHAR), |
670 |
"USER_ADDR2" VARCHAR2(64 CHAR), |
671 |
"USER_ADDR3" VARCHAR2(64 CHAR), |
672 |
"USER_ADDR4" VARCHAR2(64 CHAR), |
673 |
"USER_ADDR5" VARCHAR2(64 CHAR), |
674 |
"USER_ACCESS_NO" VARCHAR2(19 CHAR), |
675 |
"USER_TYPE" VARCHAR2(3 CHAR), |
676 |
"UPDATED_BY" NUMBER(38,2), |
677 |
"USER_CITY" VARCHAR2(128 CHAR), |
678 |
"USER_STATE" VARCHAR2(128 CHAR), |
679 |
"USER_POSTCODE" VARCHAR2(50 CHAR), |
680 |
"USER_COUNTRY" VARCHAR2(128 CHAR), |
681 |
"USER_AGE_RANGE" NUMBER(38,2), |
682 |
"USER_INCOME_RANGE" VARCHAR2(10 CHAR), |
683 |
"USER_MARITAL_STATUS" NUMBER(38,2), |
684 |
"USER_EMPLOY_STATUS" VARCHAR2(10 CHAR), |
685 |
"USER_EDUCATION_LEVEL" VARCHAR2(10 CHAR), |
686 |
"USER_DISPLAY_NAME" VARCHAR2(64 CHAR), |
687 |
"INSIDER" VARCHAR2(1 CHAR), |
688 |
"INQUIRY_CODE" VARCHAR2(15 CHAR), |
689 |
"MOTHER_MAIDEN_NAME" VARCHAR2(40 CHAR), |
690 |
"NATIONALITY" VARCHAR2(3 CHAR), |
691 |
"BUMI" VARCHAR2(3 CHAR), |
692 |
"RESIDENCE" VARCHAR2(1 CHAR), |
693 |
"RELIGION_CODE" VARCHAR2(1 CHAR), |
694 |
"LANGUAGE" VARCHAR2(3 CHAR), |
695 |
"CUST_STATUS" VARCHAR2(2 CHAR), |
696 |
"DECEASED" VARCHAR2(1 CHAR), |
697 |
"HOLD_MAIL_CODE" VARCHAR2(1 CHAR), |
698 |
"PROMO_MAIL_CODE" VARCHAR2(1 CHAR), |
699 |
"ADDRESS_SEQ" VARCHAR2(5 CHAR), |
700 |
"RETENTION" VARCHAR2(1 CHAR), |
701 |
"CONSITUTION" VARCHAR2(1 CHAR), |
702 |
"PLACE_OF_BIRTH" VARCHAR2(40 CHAR), |
703 |
"CUST_SEGMENT_CODE" VARCHAR2(1 CHAR), |
704 |
"NO_OF_EMP" NUMBER(38,2), |
705 |
"HIGH_RISK" VARCHAR2(1 CHAR), |
706 |
"HIGH_RISK_CODE" VARCHAR2(2 CHAR), |
707 |
"STAFF_FLAG" VARCHAR2(1 CHAR), |
708 |
"STAFF_ID_NO" VARCHAR2(20 CHAR), |
709 |
"DURATION_STAY_PRE_ADD" NUMBER(38,2), |
710 |
"HOUSE_OWNER_CODE" VARCHAR2(1 CHAR), |
711 |
"TYPE_DWELLING" VARCHAR2(2 CHAR), |
712 |
"NO_OF_DEPENDENTS" NUMBER(38,2), |
713 |
"BUSS_PREMISE_CODE" VARCHAR2(1 CHAR), |
714 |
"BUSSINESS_TYPE" VARCHAR2(2 CHAR), |
715 |
"BUSS_OPER_HOURS" VARCHAR2(2 CHAR), |
716 |
"ID_NO" VARCHAR2(40 CHAR), |
717 |
"ID_TYPE" VARCHAR2(3 CHAR), |
718 |
"SALUTATION" VARCHAR2(25 CHAR), |
719 |
"BRANCH_NO" NUMBER(38,2), |
720 |
"OFFICE_CONTACT_NAME" VARCHAR2(40 CHAR), |
721 |
"FAX" VARCHAR2(30 CHAR), |
722 |
"FAX_CONTACT_NAME" VARCHAR2(40 CHAR), |
723 |
"YEAR" NUMBER(38,2), |
724 |
"ANNUAL_TURNOVER" NUMBER(38,2), |
725 |
"SECTOR" VARCHAR2(1 CHAR), |
726 |
"NO_FULLTIME_EMP" NUMBER(38,2), |
727 |
"CLIENT_TYPE" VARCHAR2(3 CHAR), |
728 |
"MOBILE_NO_FLAG" VARCHAR2(255 CHAR), |
729 |
"GROUP_ID" NUMBER(38,2), |
730 |
"ORG_ID" NUMBER(38,2), |
731 |
"ROLE_ID" NUMBER(38,2), |
732 |
"MK_PENDING" NUMBER(38,2), |
733 |
"BEFORE_VALUE" CLOB,
|
734 |
"AFTER_VALUE" CLOB,
|
735 |
"LAST_LOGIN_DATE" TIMESTAMP, |
736 |
"UPDATED_DATE" TIMESTAMP, |
737 |
"MARITAL_DATE" TIMESTAMP, |
738 |
"CUST_STATUS_DATE" TIMESTAMP, |
739 |
"DECEASED_DATE" TIMESTAMP, |
740 |
"START_RELATIONSHIP" TIMESTAMP, |
741 |
"REVIEW_DATE" TIMESTAMP, |
742 |
"CREATION_DATE" DATE |
743 |
) ; |
744 |
--------------------------------------------------------
|
745 |
-- DDL for Table IB_USER
|
746 |
--------------------------------------------------------
|
747 |
|
748 |
CREATE TABLE "M2U_UPASS_CI"."IB_USER" |
749 |
( "USER_ID" NUMBER(38,2), |
750 |
"ACCOUNT_ID" NUMBER(38,2), |
751 |
"USER_ALIAS" VARCHAR2(50 CHAR), |
752 |
"PASSWORD" VARCHAR2(64 CHAR), |
753 |
"USER_STATE" NUMBER(38,2), |
754 |
"MODIF_TIME" TIMESTAMP, |
755 |
"CREATION_DATE" DATE |
756 |
) ; |
757 |
|
758 |
--------------------------------------------------------
|
759 |
-- DDL for Table IB_CONTENT_CATEGORY_ML
|
760 |
--------------------------------------------------------
|
761 |
|
762 |
CREATE TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" |
763 |
( "OID" NUMBER(38,2), |
764 |
"CATEGORY_NAME" VARCHAR2(64 CHAR), |
765 |
"LOCALE" VARCHAR2(2 CHAR), |
766 |
"CONTENT_CATEGORY_ID" NUMBER(38,2) |
767 |
); |
768 |
|
769 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','5', EMPTY_CLOB(),1,1); |
770 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','1', EMPTY_CLOB(),2,0); |
771 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','1', EMPTY_CLOB(),3,0); |
772 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('AUTO_LOGOFF','30', EMPTY_CLOB(),1,1); |
773 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('AUTO_LOGOFF','10', EMPTY_CLOB(),2,0); |
774 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('AUTO_LOGOFF','1', EMPTY_CLOB(),3,0); |
775 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DEACTIVATE_PERIOD','1', EMPTY_CLOB(),1,1); |
776 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DEACTIVATE_PERIOD','1', EMPTY_CLOB(),2,0); |
777 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DEACTIVATE_PERIOD','1', EMPTY_CLOB(),3,0); |
778 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SINGLE_SIGNON','0', EMPTY_CLOB(),1,1); |
779 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SINGLE_SIGNON','1', EMPTY_CLOB(),2,0); |
780 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SINGLE_SIGNON','1', EMPTY_CLOB(),3,0); |
781 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','0', EMPTY_CLOB(),0,0); |
782 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','1', EMPTY_CLOB(),1,1); |
783 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','1', EMPTY_CLOB(),2,0); |
784 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','1', EMPTY_CLOB(),3,0); |
785 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','0', EMPTY_CLOB(),4,0); |
786 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('IBAM_SECURE_MESSAGE','1', EMPTY_CLOB(),1,1); |
787 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('IBAM_SECURE_MESSAGE','1', EMPTY_CLOB(),0,0); |
788 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','1', EMPTY_CLOB(),0,0); |
789 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('AUTO_LOGOFF','1', EMPTY_CLOB(),0,0); |
790 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DEACTIVATE_PERIOD','1', EMPTY_CLOB(),0,0); |
791 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SINGLE_SIGNON','1', EMPTY_CLOB(),0,0); |
792 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CONFIG_CHANGE','1', EMPTY_CLOB(),0,0); |
793 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),3,0); |
794 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),1,1); |
795 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),2,0); |
796 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),4,0); |
797 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),5,0); |
798 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),0,0); |
799 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','0', EMPTY_CLOB(),3,0); |
800 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','0', EMPTY_CLOB(),4,0); |
801 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','0', EMPTY_CLOB(),5,0); |
802 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','0', EMPTY_CLOB(),1,1); |
803 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','1', EMPTY_CLOB(),2,0); |
804 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','0', EMPTY_CLOB(),0,0); |
805 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),3,0); |
806 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),4,0); |
807 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),5,0); |
808 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),1,1); |
809 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),2,0); |
810 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),0,0); |
811 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),3,0); |
812 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),4,0); |
813 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),5,0); |
814 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),1,1); |
815 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),2,0); |
816 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),0,0); |
817 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','1', EMPTY_CLOB(),3,0); |
818 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','1', EMPTY_CLOB(),4,0); |
819 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','1', EMPTY_CLOB(),5,0); |
820 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','1', EMPTY_CLOB(),1,1); |
821 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','1', EMPTY_CLOB(),2,0); |
822 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','0', EMPTY_CLOB(),0,0); |
823 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),3,0); |
824 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),4,0); |
825 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),5,0); |
826 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),1,1); |
827 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),2,0); |
828 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),0,0); |
829 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),3,0); |
830 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),4,0); |
831 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),5,0); |
832 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),1,1); |
833 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','31', EMPTY_CLOB(),2,0); |
834 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','0', EMPTY_CLOB(),0,0); |
835 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),3,0); |
836 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),4,0); |
837 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),5,0); |
838 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','12', EMPTY_CLOB(),1,1); |
839 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),2,0); |
840 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','6', EMPTY_CLOB(),0,0); |
841 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),3,0); |
842 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),4,0); |
843 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),5,0); |
844 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),1,1); |
845 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),2,0); |
846 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),0,0); |
847 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','8', EMPTY_CLOB(),3,0); |
848 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','8', EMPTY_CLOB(),4,0); |
849 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','8', EMPTY_CLOB(),5,0); |
850 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','8', EMPTY_CLOB(),1,1); |
851 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','9', EMPTY_CLOB(),2,0); |
852 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','1', EMPTY_CLOB(),0,0); |
853 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),3,0); |
854 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),1,1); |
855 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),2,0); |
856 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),4,0); |
857 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),5,0); |
858 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),0,0); |
859 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_DEFAULT_TIMEOUT','86400', EMPTY_CLOB(),0,0); |
860 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_LIFTSPAN_TIMEOUT','86400', EMPTY_CLOB(),0,0); |
861 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_MAX_ERROR','3', EMPTY_CLOB(),0,0); |
862 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_MAX_USE','1', EMPTY_CLOB(),0,0); |
863 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_REPEAT_TIMEOUT','1', EMPTY_CLOB(),0,0); |
864 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_DEFAULT_TIMEOUT','300', EMPTY_CLOB(),0,0); |
865 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_LIFTSPAN_TIMEOUT','300', EMPTY_CLOB(),0,0); |
866 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_MAX_ERROR','3', EMPTY_CLOB(),0,0); |
867 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_MAX_USE','1', EMPTY_CLOB(),0,0); |
868 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_MAX_USE','1', EMPTY_CLOB(),2,0); |
869 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_REPEAT_TIMEOUT','60', EMPTY_CLOB(),0,0); |
870 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_REPEAT_TIMEOUT','30', EMPTY_CLOB(),2,0); |
871 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),3,0); |
872 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),1,1); |
873 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),2,0); |
874 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','0', EMPTY_CLOB(),0,0); |
875 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),3,0); |
876 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),4,0); |
877 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),5,0); |
878 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),1,1); |
879 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),2,0); |
880 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),0,0); |
881 |
|
882 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (1); |
883 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (2); |
884 |
|
885 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (1,'root',0,'Root ID',to_date('18-MAY-10','DD-MON-RR'),to_date('30-JUN-11','DD-MON-RR'),19,null,null,0,null,null,'1408A0F64A991CE378292A7EFB4B7B84DF7F9D98114C8E6F63C4758F062F989D',0,to_date('18-MAY-10','DD-MON-RR'),to_date('18-MAY-10','DD-MON-RR'),to_date('30-JUN-11','DD-MON-RR'),19,0,1,null,0); |
886 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (12,'UpassAdmin',1,'Admin',to_date('26-NOV-10','DD-MON-RR'),to_date('22-APR-13','DD-MON-RR'),3256,null,to_date('10-DEC-12','DD-MON-RR'),0,to_date('10-DEC-12','DD-MON-RR'),to_date('10-DEC-12','DD-MON-RR'),'7AABD6A7DF0B1F24A1996D57DD6E7ADA35ED56CA884996E4205C722F3EC139D6',0,to_date('26-NOV-10','DD-MON-RR'),to_date('26-NOV-10','DD-MON-RR'),to_date('09-MAY-13','DD-MON-RR'),4529,0,1,null,0); |
887 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (57,'administrator',1,'MSS Admin',to_date('01-DEC-10','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),14477,to_date('05-APR-13','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),0,to_date('05-APR-13','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),'64535FE6B9714612F18632CD33A2C2864DAA4EE1D06284FCA66D7DC1DD4689F8',0,to_date('01-DEC-10','DD-MON-RR'),to_date('01-DEC-10','DD-MON-RR'),to_date('09-MAY-13','DD-MON-RR'),17738,0,1,null,0); |
888 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (100,'ibuser1',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'31FC33E8DDFFE672C0975A8D3C9BF8AFE8F0DA511E70452514D3491190CA0E4F',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,1); |
889 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (101,'ibuser2',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'9382596D75FDF7DB48FA6BD0F3EB41587331F4340F5A3656D2F886406F290022',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,2); |
890 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (102,'ibuser3',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'BA2D69FB001B6A21FE5005528E8CFEEEA6C939D47E0CD383DD0D61295848FD89',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,3); |
891 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (103,'ibuser4',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'98C3D7E8CD74B22374703C31D182E56355B6830D5B648E8202883565881A88F6',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,4); |
892 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (104,'ibuser5',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'19264C925BB223D518D9284441353949FDA028FAABA3153DBA9752C3C89A7C28',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,5); |
893 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (105,'ibuser6',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'BD4CF661D7EEBC5F4F9DA263C5F40D6ED7E3B260',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null); |
894 |
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (106,'ibuser7',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'CFE07A6E720E205E6210BDBA5ED1473845856F56',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null); |
895 |
|
896 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('root',1); |
897 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('UpassAdmin',12); |
898 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('administrator',57); |
899 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser1',100); |
900 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser2',101); |
901 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser3',102); |
902 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser4',103); |
903 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser5',104); |
904 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser6',105); |
905 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser7',106); |
906 |
|
907 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (1021,'Unlock Customer',0,0); |
908 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (1023,'Activate Customer',0,0); |
909 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3002,'Edit USS Navigation',1,0); |
910 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3011,'Create USS Group',1,0); |
911 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3012,'Edit USS Group',1,0); |
912 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3013,'Delete USS Group',1,0); |
913 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3021,'Create USS User',1,0); |
914 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3022,'Edit USS User',1,0); |
915 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3023,'Delete USS User',1,0); |
916 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3024,'Suspend USS User',1,0); |
917 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3025,'Activate USS User',1,0); |
918 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3026,'Unlock USS User',1,0); |
919 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3027,'Reset Password for USS User',1,0); |
920 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3031,'Edit UPASS Configs',1,0); |
921 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8001,'Create Application Admin',1,0); |
922 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8002,'Edit Application Admin',1,0); |
923 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8003,'Delete Application Admin',1,0); |
924 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8004,'Reset Password for Application Admin',1,0); |
925 |
|
926 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1021); |
927 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1023); |
928 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3021); |
929 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3022); |
930 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3023); |
931 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3024); |
932 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3025); |
933 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3026); |
934 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3027); |
935 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (6,3002); |
936 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3011); |
937 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3012); |
938 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3013); |
939 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (35,3031); |
940 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8001); |
941 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8002); |
942 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8003); |
943 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8004); |
944 |
|
945 |
Insert into M2U_UPASS_CI.ADMIN_USER_PROFILE (USER_ID,ROLE_ID,GROUP_ID,USER_NAME,USER_DOB,USER_EMAIL,USER_GENDER,USER_RACE,USER_OFFICE_NUMBER,USER_MOBILE_NUMBER,CREATED_BY,UPDATED_BY,UPDATED_DATE,LAST_LOGIN_DATE,FORCE_RESET,MK_PENDING,LAST_IP_ADDRESS,LAST_HOST_NAME,USER_ADMIN_ROLE) values (12,1,1,'Tester number 1','30021987','mail@mail.com','M',null,'0312345678','0128888888',0,12,to_date('23/04/2013','DD/MM/RRRR'),to_date('11/07/2013','DD/MM/RRRR'),0,0,'172.16.23.132','172.16.23.132',null); |
946 |
|
947 |
Insert into M2U_UPASS_CI.ADMIN_GROUP (GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_CREATED_BY,GROUP_UPDATED_BY,GROUP_CREATION_DATE,GROUP_UPDATED_DATE,CATEGORY,GROUP_LVL,MODE_TYPE,MK_PENDING) values (0,'Ungrouped','No group',12,12,to_date('12/09/2011','DD/MM/RRRR'),to_date('12/09/2011','DD/MM/RRRR'),1,9,'1',0); |
948 |
Insert into M2U_UPASS_CI.ADMIN_GROUP (GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_CREATED_BY,GROUP_UPDATED_BY,GROUP_CREATION_DATE,GROUP_UPDATED_DATE,CATEGORY,GROUP_LVL,MODE_TYPE,MK_PENDING) values (1,'System Administrator','System ID',0,12,to_date('05/12/2010','DD/MM/RRRR'),to_date('06/12/2010','DD/MM/RRRR'),1,0,'1',0); |
949 |
|
950 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (19,null,'USS Navigation','Admin Navigation','0','0','ADMIN',1,null,12,822,to_timestamp('15/08/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('06/12/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
951 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (7,19,'Admin Group Maintenance ','Assign User Role to a Specific Group of Admin User','1','0','SSSSAGRP',2,'/ss103/groupEnquiryMain.do',6,12,to_timestamp('06/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('30/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
952 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (3,19,'Admin User Maintenance','Maintain IBAM Admin users','1','0','SSSSAENQ',3,'/ss102/userEnquiryScreen.do',6,12,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('23/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
953 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (6,19,'Menu Maintenance','To maintain IBAM Navigation','1','0','SSSSNAVI',4,'/ss100/navigationEnquiryMain.do',6,822,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('06/12/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
954 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (1,19,'Customer Enquiry','RIB User Enquiry','1','0','SSSSUENQ',5,'/ss112/searchUser.do',6,12,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('27/07/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
955 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (8,19,'USS Audit Log','Audit Log','1','0','SSSSALOG',6,'/ss104/auditTrailMain.do',6,12,to_timestamp('06/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('23/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
956 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (9,19,'Change Your Password','Change Password','1','0','SSSSCPWD',7,'/ss102/changePassword.do',6,12,to_timestamp('06/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('23/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
957 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (35,19,'Upass USS Maintenance','Settings','1','0','SSSSSETT',8,'/ss221/settings.do',1,12,to_timestamp('17/02/2012 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('30/06/2013 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
958 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (36,19,'Application Admin Maintenance','To Maintain Application Admin','1','0','SSSSAUM',9,'/ss223/appUserEnquiryMain.do',1,12,to_timestamp('17/02/2012 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('30/06/2013 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
959 |
|
960 |
|
961 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (1,1,0,0,'SSSSUENQ'); |
962 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (3,1,0,0,'SSSSAENQ'); |
963 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (6,1,0,0,'SSSSNAVI'); |
964 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (7,1,0,0,'SSSSAGRP'); |
965 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (8,1,0,0,'SSSSALOG'); |
966 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (9,1,0,0,'SSSSCPWD'); |
967 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (19,1,0,0,'ADMIN'); |
968 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (35,1,0,0,'SSSSSETT'); |
969 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (36,1,0,0,'SSSSAUM'); |
970 |
|
971 |
Insert into M2U_UPASS_CI.ADMIN_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (0,'Test role','Testing Description for this role',0,0,to_timestamp('10/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_date('10/10/2011','DD/MM/RRRR')); |
972 |
Insert into M2U_UPASS_CI.ADMIN_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (1,'Super Admin','Super Administrator',1,1,to_timestamp('05/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_date('05/12/2010','DD/MM/RRRR')); |
973 |
Insert into M2U_UPASS_CI.ADMIN_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (2,'Admin','Admin',1,1,to_timestamp('15/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),null); |
974 |
|
975 |
Insert into M2U_UPASS_CI.IB_USER (USER_ID,ACCOUNT_ID,USER_ALIAS,PASSWORD,USER_STATE,MODIF_TIME,CREATION_DATE) values (12,0,'administrator',null,0,to_date('05/12/2010','DD/MM/RRRR'),to_date('05/12/2010','DD/MM/RRRR')); |
976 |
|
977 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (1, 'M2U Retail Internet Banking'); |
978 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (2, 'Maybank Online Stock'); |
979 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (3, 'Maybank Online Ticketing'); |
980 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (4, 'Maybank CCPP'); |
981 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (5, 'M2U Singapore Integration'); |
982 |
|
983 |
Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 1, to_date('03/03/2013','DD/MM/RRRR'), 100); |
984 |
Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 2, to_date('03/03/2013','DD/MM/RRRR'), 101); |
985 |
Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 3, to_date('03/03/2013','DD/MM/RRRR'), 102); |
986 |
Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 4, to_date('03/03/2013','DD/MM/RRRR'), 103); |
987 |
Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 5, to_date('03/03/2013','DD/MM/RRRR'), 104); |
988 |
|
989 |
|
990 |
--------------------------------------------------------
|
991 |
-- Constraints for Table TB_AM_TAC
|
992 |
--------------------------------------------------------
|
993 |
|
994 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_ERROR_COUNT" NOT NULL ENABLE); |
995 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_USE_COUNT" NOT NULL ENABLE); |
996 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_TAC_STATE" NOT NULL ENABLE); |
997 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_USER_ID" NOT NULL ENABLE); |
998 |
--------------------------------------------------------
|
999 |
-- Constraints for Table TB_AM_GEMALTO
|
1000 |
--------------------------------------------------------
|
1001 |
|
1002 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_STATE" NOT NULL ENABLE); |
1003 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_ERROR_COUNT" NOT NULL ENABLE); |
1004 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_USE_COUNT" NOT NULL ENABLE); |
1005 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_ASSIGNED" NOT NULL ENABLE); |
1006 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_BAK_CIPHERTEXT" NOT NULL ENABLE); |
1007 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_CIPHERTEXT" NOT NULL ENABLE); |
1008 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_USER_ID" NOT NULL ENABLE); |
1009 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_SERIAL_NO" NOT NULL ENABLE); |
1010 |
--------------------------------------------------------
|
1011 |
-- Constraints for Table TB_AM_USERMAS
|
1012 |
--------------------------------------------------------
|
1013 |
|
1014 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" MODIFY ("M_USER_ID" NOT NULL ENABLE); |
1015 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
1016 |
--------------------------------------------------------
|
1017 |
-- Constraints for Table TB_AM_USER_BACKUP
|
1018 |
--------------------------------------------------------
|
1019 |
|
1020 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1021 |
--------------------------------------------------------
|
1022 |
-- Constraints for Table TB_AM_APPSERV
|
1023 |
--------------------------------------------------------
|
1024 |
|
1025 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ACCESS2" NOT NULL ENABLE); |
1026 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ACCESS1" NOT NULL ENABLE); |
1027 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ID" NOT NULL ENABLE); |
1028 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_USER_ID" NOT NULL ENABLE); |
1029 |
--------------------------------------------------------
|
1030 |
-- Constraints for Table TB_AM_CONFIG_CHANGE
|
1031 |
--------------------------------------------------------
|
1032 |
|
1033 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" MODIFY ("CONFIG_UPDATE" NOT NULL ENABLE); |
1034 |
--------------------------------------------------------
|
1035 |
-- Constraints for Table TB_AM_TAC_BACKUP
|
1036 |
--------------------------------------------------------
|
1037 |
|
1038 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1039 |
--------------------------------------------------------
|
1040 |
-- Constraints for Table SMS_TABLE
|
1041 |
--------------------------------------------------------
|
1042 |
|
1043 |
ALTER TABLE "M2U_UPASS_CI"."SMS_TABLE" MODIFY ("OID" NOT NULL ENABLE); |
1044 |
--------------------------------------------------------
|
1045 |
-- Constraints for Table TB_AM_VASCO
|
1046 |
--------------------------------------------------------
|
1047 |
|
1048 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_STATE" NOT NULL ENABLE); |
1049 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_ERROR_COUNT" NOT NULL ENABLE); |
1050 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_USE_COUNT" NOT NULL ENABLE); |
1051 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_ASSIGNED" NOT NULL ENABLE); |
1052 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_BAK_CIPHERTEXT" NOT NULL ENABLE); |
1053 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_CIPHERTEXT" NOT NULL ENABLE); |
1054 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_USER_ID" NOT NULL ENABLE); |
1055 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_SERIAL_NO" NOT NULL ENABLE); |
1056 |
--------------------------------------------------------
|
1057 |
-- Constraints for Table TB_AM_CONFIG
|
1058 |
--------------------------------------------------------
|
1059 |
|
1060 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1061 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("APPLICATION_ID" NOT NULL ENABLE); |
1062 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("CONFIG_NAME" NOT NULL ENABLE); |
1063 |
--------------------------------------------------------
|
1064 |
-- Constraints for Table TB_AM_USERMAS_BACKUP
|
1065 |
--------------------------------------------------------
|
1066 |
|
1067 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
1068 |
--------------------------------------------------------
|
1069 |
-- Constraints for Table TB_AM_USER
|
1070 |
--------------------------------------------------------
|
1071 |
|
1072 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_EXPIRED_STATUS" NOT NULL ENABLE); |
1073 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_ERROR_COUNT" NOT NULL ENABLE); |
1074 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_USE_COUNT" NOT NULL ENABLE); |
1075 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_DATE_GENERATED" NOT NULL ENABLE); |
1076 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_PASSWD_STATE" NOT NULL ENABLE); |
1077 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_STATE" NOT NULL ENABLE); |
1078 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USE_COUNT" NOT NULL ENABLE); |
1079 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_DATE_CREATED" NOT NULL ENABLE); |
1080 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_TYPE" NOT NULL ENABLE); |
1081 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_ALIAS" NOT NULL ENABLE); |
1082 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_ID" NOT NULL ENABLE); |
1083 |
|
1084 |
--------------------------------------------------------
|
1085 |
-- Constraints for Table ADMIN_ACTION
|
1086 |
--------------------------------------------------------
|
1087 |
|
1088 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("APPROVABLE" NOT NULL ENABLE); |
1089 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("ACTION" NOT NULL ENABLE); |
1090 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1091 |
--------------------------------------------------------
|
1092 |
-- Constraints for Table ADMIN_AUDIT_LOG
|
1093 |
--------------------------------------------------------
|
1094 |
|
1095 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_CREATION_DATE" NOT NULL ENABLE); |
1096 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_DESCRIPTION" NOT NULL ENABLE); |
1097 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("AUDIT_CATEGORY_ID" NOT NULL ENABLE); |
1098 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_ID" NOT NULL ENABLE); |
1099 |
--------------------------------------------------------
|
1100 |
-- Constraints for Table ADMIN_GROUP
|
1101 |
--------------------------------------------------------
|
1102 |
|
1103 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_LVL" NOT NULL ENABLE); |
1104 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_CREATION_DATE" NOT NULL ENABLE); |
1105 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_NAME" NOT NULL ENABLE); |
1106 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1107 |
--------------------------------------------------------
|
1108 |
-- Constraints for Table ADMIN_NAVIGATION
|
1109 |
--------------------------------------------------------
|
1110 |
|
1111 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_CREATION_DATE" NOT NULL ENABLE); |
1112 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_CODE" NOT NULL ENABLE); |
1113 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_NAME" NOT NULL ENABLE); |
1114 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_ID" NOT NULL ENABLE); |
1115 |
--------------------------------------------------------
|
1116 |
-- Constraints for Table ADMIN_NAVIGATION_ACTION
|
1117 |
--------------------------------------------------------
|
1118 |
|
1119 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1120 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" MODIFY ("NAVIGATION_ID" NOT NULL ENABLE); |
1121 |
--------------------------------------------------------
|
1122 |
-- Constraints for Table ADMIN_NAVIGATION_GROUP
|
1123 |
--------------------------------------------------------
|
1124 |
|
1125 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("IS_VIEW" NOT NULL ENABLE); |
1126 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("IS_EDIT" NOT NULL ENABLE); |
1127 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1128 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("NAVIGATION_ID" NOT NULL ENABLE); |
1129 |
--------------------------------------------------------
|
1130 |
-- Constraints for Table ADMIN_PERMISSION
|
1131 |
--------------------------------------------------------
|
1132 |
|
1133 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("IS_APPROVER" NOT NULL ENABLE); |
1134 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1135 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("USER_ID" NOT NULL ENABLE); |
1136 |
--------------------------------------------------------
|
1137 |
-- Constraints for Table ADMIN_ROLE
|
1138 |
--------------------------------------------------------
|
1139 |
|
1140 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_CREATION_DATE" NOT NULL ENABLE); |
1141 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_NAME" NOT NULL ENABLE); |
1142 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1143 |
--------------------------------------------------------
|
1144 |
-- Constraints for Table ADMIN_USER_PROFILE
|
1145 |
--------------------------------------------------------
|
1146 |
|
1147 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1148 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("FORCE_RESET" NOT NULL ENABLE); |
1149 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_EMAIL" NOT NULL ENABLE); |
1150 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_NAME" NOT NULL ENABLE); |
1151 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1152 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1153 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_ID" NOT NULL ENABLE); |
1154 |
--------------------------------------------------------
|
1155 |
-- Constraints for Table ADMIN_USER_PROFILE_BACKUP
|
1156 |
--------------------------------------------------------
|
1157 |
|
1158 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1159 |
--------------------------------------------------------
|
1160 |
-- Constraints for Table ADMIN_USER_SECURITY
|
1161 |
--------------------------------------------------------
|
1162 |
|
1163 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY" MODIFY ("USER_ID" NOT NULL ENABLE); |
1164 |
--------------------------------------------------------
|
1165 |
-- Constraints for Table ADMIN_USER_SECURITY_BACKUP
|
1166 |
--------------------------------------------------------
|
1167 |
|
1168 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY_BACKUP" MODIFY ("USER_ID" NOT NULL ENABLE); |
1169 |
--------------------------------------------------------
|
1170 |
-- Constraints for Table IB_CONTENT_CATEGORY
|
1171 |
--------------------------------------------------------
|
1172 |
|
1173 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1174 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("CONTENT_TYPE_ID" NOT NULL ENABLE); |
1175 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1176 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("OID" NOT NULL ENABLE); |
1177 |
--------------------------------------------------------
|
1178 |
-- Constraints for Table IB_CONTENT_TYPE
|
1179 |
--------------------------------------------------------
|
1180 |
|
1181 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1182 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("CONTENT_TYPE_CODE" NOT NULL ENABLE); |
1183 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("OID" NOT NULL ENABLE); |
1184 |
--------------------------------------------------------
|
1185 |
-- Constraints for Table IB_CUST_PROFILE
|
1186 |
--------------------------------------------------------
|
1187 |
|
1188 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1189 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1190 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1191 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_FULLTIME_EMP" NOT NULL ENABLE); |
1192 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("ANNUAL_TURNOVER" NOT NULL ENABLE); |
1193 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("YEAR" NOT NULL ENABLE); |
1194 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("BRANCH_NO" NOT NULL ENABLE); |
1195 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_OF_DEPENDENTS" NOT NULL ENABLE); |
1196 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("DURATION_STAY_PRE_ADD" NOT NULL ENABLE); |
1197 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_OF_EMP" NOT NULL ENABLE); |
1198 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("USER_ID" NOT NULL ENABLE); |
1199 |
--------------------------------------------------------
|
1200 |
-- Constraints for Table IB_USER
|
1201 |
--------------------------------------------------------
|
1202 |
|
1203 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1204 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("ACCOUNT_ID" NOT NULL ENABLE); |
1205 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1206 |
|
1207 |
--------------------------------------------------------
|
1208 |
-- Constraints for Table IB_CONTENT_CATEGORY_ML
|
1209 |
--------------------------------------------------------
|
1210 |
|
1211 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("CONTENT_CATEGORY_ID" NOT NULL ENABLE); |
1212 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("LOCALE" NOT NULL ENABLE); |
1213 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("OID" NOT NULL ENABLE); |
1214 |
|
1215 |
|
1216 |
ALTER TABLE "M2U_UPASS_CI"."M2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1217 |
ALTER TABLE "M2U_UPASS_CI"."TICKETING_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1218 |
ALTER TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1219 |
ALTER TABLE "M2U_UPASS_CI"."STOCK_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1220 |
ALTER TABLE "M2U_UPASS_CI"."IM2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE) |
1221 |
|