m2u-upass-ws / test / resources / db-scripts / m2u-upass-ci-oracle.sql @ 82:999497720cfa
History | View | Annotate | Download (77.9 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 |
|
154 |
--------------------------------------------------------
|
155 |
-- Constraints for Table USER_APP_ACCESS
|
156 |
--------------------------------------------------------
|
157 |
|
158 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("USER_ID" NOT NULL ENABLE); |
159 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("APP_ID" NOT NULL ENABLE); |
160 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("ACCESS_TYPE" NOT NULL ENABLE); |
161 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("REGISTRATION_TIME" NOT NULL ENABLE); |
162 |
|
163 |
--------------------------------------------------------
|
164 |
-- DDL for Table M2U_USER
|
165 |
--------------------------------------------------------
|
166 |
|
167 |
CREATE TABLE "M2U_UPASS_CI"."M2U_USER" ( |
168 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
169 |
"IBPAN" VARCHAR2(30 CHAR), |
170 |
"IBPAN2" VARCHAR2(30 CHAR) |
171 |
); |
172 |
|
173 |
--------------------------------------------------------
|
174 |
-- DDL for Table TICKETING_USER
|
175 |
--------------------------------------------------------
|
176 |
|
177 |
CREATE TABLE "M2U_UPASS_CI"."TICKETING_USER" ( |
178 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
179 |
"FULL_NAME" VARCHAR2(200 CHAR), |
180 |
"FIRST_NAME" VARCHAR2(200 CHAR), |
181 |
"LAST_NAME" VARCHAR2(200 CHAR), |
182 |
"PAYEE_CODE" VARCHAR2(20 CHAR) |
183 |
); |
184 |
|
185 |
--------------------------------------------------------
|
186 |
-- DDL for Table IBCC_PUBLIC_USER
|
187 |
--------------------------------------------------------
|
188 |
|
189 |
CREATE TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" ( |
190 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
191 |
"PAN_CC" VARCHAR2(20 CHAR) |
192 |
); |
193 |
|
194 |
--------------------------------------------------------
|
195 |
-- DDL for Table STOCK_USER
|
196 |
--------------------------------------------------------
|
197 |
|
198 |
CREATE TABLE "M2U_UPASS_CI"."STOCK_USER" ( |
199 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
200 |
"HIGH_NET_WORTH_ATTR" CHAR(1 CHAR), |
201 |
"CUST_TYPE" NUMBER(10,0), |
202 |
"ID_NO" VARCHAR2(20 CHAR), |
203 |
"ACTIVE_ATTR" CHAR(1 CHAR), |
204 |
"ST_ACCOUNT_NO" VARCHAR2(20 CHAR), |
205 |
"PAL_ACCOUNT_NO" VARCHAR2(20 CHAR) |
206 |
); |
207 |
|
208 |
--------------------------------------------------------
|
209 |
-- DDL for Table IM2U_USER
|
210 |
--------------------------------------------------------
|
211 |
|
212 |
CREATE TABLE "M2U_UPASS_CI"."IM2U_USER" ( |
213 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
214 |
"WS_FLAG" CHAR(1 CHAR), |
215 |
"WS_IDENT_CODE" VARCHAR2(100 CHAR), |
216 |
"WS_MY_SG_ID" VARCHAR2(20 CHAR), |
217 |
"WS_REG_TIMESTAMP" TIMESTAMP |
218 |
); |
219 |
|
220 |
|
221 |
--------------------------------------------------------
|
222 |
-- DDL for Table SMS_TABLE
|
223 |
--------------------------------------------------------
|
224 |
|
225 |
CREATE TABLE "M2U_UPASS_CI"."SMS_TABLE" |
226 |
( "OID" NUMBER(38,2), |
227 |
"SMS_CREATESTAMP" TIMESTAMP, |
228 |
"SMS_IBREF_NO" VARCHAR2(20 CHAR), |
229 |
"SMS_IC_NO" VARCHAR2(30 CHAR), |
230 |
"SMS_CUST_NAME" VARCHAR2(40 CHAR), |
231 |
"SMS_HP_NO" VARCHAR2(30 CHAR), |
232 |
"SMS_MESSAGE" VARCHAR2(512 CHAR), |
233 |
"SMS_SERVICE" VARCHAR2(64 CHAR), |
234 |
"SMS_STATUS" VARCHAR2(4 CHAR), |
235 |
"CREATION_DATE" TIMESTAMP, |
236 |
"SMS_GUID" VARCHAR2(45 CHAR), |
237 |
"SMS_SDDATESTAMP" TIMESTAMP, |
238 |
"SMS_RCDATESTAMP" TIMESTAMP, |
239 |
"SMS_CHECK" VARCHAR2(2 CHAR), |
240 |
"SMS_PRIORITY" VARCHAR2(2 CHAR), |
241 |
"SMS_TYPE" VARCHAR2(64 CHAR), |
242 |
"STATUS" VARCHAR2(64 CHAR), |
243 |
"REFERENCE" VARCHAR2(50 CHAR), |
244 |
"REMOTE_IP" VARCHAR2(64 CHAR), |
245 |
"OTHER1" VARCHAR2(50 CHAR), |
246 |
"OTHER2" VARCHAR2(50 CHAR), |
247 |
"AMOUNT" NUMBER(38,2), |
248 |
"IB_SERVICE" VARCHAR2(50 CHAR) |
249 |
) ; |
250 |
--------------------------------------------------------
|
251 |
-- DDL for Table TB_AM_APPSERV
|
252 |
--------------------------------------------------------
|
253 |
|
254 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" |
255 |
( |
256 |
"A_USER_ID" NUMBER(10,0), |
257 |
"A_APP_SERV_ID" VARCHAR2(10 CHAR), |
258 |
"A_APP_SERV_ACCESS1" VARCHAR2(20 CHAR), |
259 |
"A_APP_SERV_ACCESS2" VARCHAR2(20 CHAR), |
260 |
"A_APP_SERV_AUTH_LIST" VARCHAR2(20 CHAR) , |
261 |
CONSTRAINT PK_TB_AM_APPSERV PRIMARY KEY ( A_USER_ID , A_APP_SERV_ID ) |
262 |
); |
263 |
--------------------------------------------------------
|
264 |
-- DDL for Table TB_AM_CONFIG
|
265 |
--------------------------------------------------------
|
266 |
|
267 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" |
268 |
( |
269 |
"CONFIG_NAME" VARCHAR2(64 CHAR), |
270 |
"CONFIG_VALUE" VARCHAR2(128 CHAR), |
271 |
"CONFIG_DESCRIPTION" VARCHAR2(256 CHAR), |
272 |
"APPLICATION_ID" NUMBER(10,0), |
273 |
"MK_PENDING" NUMBER(38,2), |
274 |
CONSTRAINT PK_TB_AM_CONFIG PRIMARY KEY ( CONFIG_NAME , APPLICATION_ID ) |
275 |
) ; |
276 |
--------------------------------------------------------
|
277 |
-- DDL for Table TB_AM_CONFIG_CHANGE
|
278 |
--------------------------------------------------------
|
279 |
|
280 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" |
281 |
( "CONFIG_UPDATE" NUMBER(10,0) PRIMARY KEY |
282 |
) ; |
283 |
--------------------------------------------------------
|
284 |
-- DDL for Table TB_AM_GEMALTO
|
285 |
--------------------------------------------------------
|
286 |
|
287 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" |
288 |
( "G_SERIAL_NO" VARCHAR2(22 CHAR) PRIMARY KEY, |
289 |
"G_USER_ID" NUMBER(10,0), |
290 |
"G_DP_MODEL" VARCHAR2(5 CHAR), |
291 |
"G_DP_AUTH_MODE" VARCHAR2(2 CHAR), |
292 |
"G_DP_CIPHERTEXT" BLOB, |
293 |
"G_BAK_CIPHERTEXT" BLOB, |
294 |
"G_DP_ASSIGNED" NUMBER(10,0), |
295 |
"G_DATE_ASSIGNED" TIMESTAMP, |
296 |
"G_DATE_FIRST_USED" TIMESTAMP, |
297 |
"G_DATE_LAST_USED" TIMESTAMP, |
298 |
"G_USE_COUNT" NUMBER(10,0), |
299 |
"G_ERROR_COUNT" NUMBER(10,0), |
300 |
"G_DP_STATE" NUMBER(10,0), |
301 |
"G_BATCH_NO" VARCHAR2(8 CHAR) |
302 |
) ; |
303 |
--------------------------------------------------------
|
304 |
-- DDL for Table TB_AM_TAC
|
305 |
--------------------------------------------------------
|
306 |
|
307 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_TAC" |
308 |
( "T_USER_ID" NUMBER(10,0) PRIMARY KEY, |
309 |
"T_TAC_CIPHERTEXT" VARCHAR2(128 CHAR), |
310 |
"T_TAC_STATE" NUMBER(10,0), |
311 |
"T_DATE_GENERATED" TIMESTAMP, |
312 |
"T_DATE_FIRST_USED" TIMESTAMP, |
313 |
"T_DATE_LAST_USED" TIMESTAMP, |
314 |
"T_USE_COUNT" NUMBER(10,0), |
315 |
"T_ERROR_COUNT" NUMBER(10,0), |
316 |
"T_SESSION_ID" VARCHAR2(32 CHAR) |
317 |
) ; |
318 |
--------------------------------------------------------
|
319 |
-- DDL for Table TB_AM_TAC_BACKUP
|
320 |
--------------------------------------------------------
|
321 |
|
322 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" |
323 |
( "OID" NUMBER(10,0) PRIMARY KEY, |
324 |
"T_USER_ID" NUMBER(10,0), |
325 |
"T_TAC_CIPHERTEXT" VARCHAR2(64 CHAR), |
326 |
"T_TAC_STATE" NUMBER(10,0), |
327 |
"T_DATE_GENERATED" TIMESTAMP, |
328 |
"T_DATE_FIRST_USED" TIMESTAMP, |
329 |
"T_DATE_LAST_USED" CHAR(10 CHAR), |
330 |
"T_USE_COUNT" NUMBER(10,0), |
331 |
"T_ERROR_COUNT" NUMBER(10,0), |
332 |
"T_SESSION_ID" VARCHAR2(32 CHAR), |
333 |
"T_APPLICATION_ID" NUMBER(10,0) |
334 |
) ; |
335 |
--------------------------------------------------------
|
336 |
-- DDL for Table TB_AM_USER
|
337 |
--------------------------------------------------------
|
338 |
|
339 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USER" |
340 |
( "U_USER_ID" NUMBER(10,0) PRIMARY KEY, |
341 |
"U_USER_ALIAS" VARCHAR2(50 CHAR), |
342 |
"U_USER_TYPE" NUMBER(10,0), |
343 |
"U_USER_DESC" VARCHAR2(40 CHAR), |
344 |
"U_DATE_CREATED" TIMESTAMP, |
345 |
"U_DATE_LAST_USED" TIMESTAMP, |
346 |
"U_USE_COUNT" NUMBER(19,0), |
347 |
"U_DATE_LAST_ACT" TIMESTAMP, |
348 |
"U_DATE_LAST_LOCK" TIMESTAMP, |
349 |
"U_USER_STATE" NUMBER(10,0), |
350 |
"U_DATE_LOCK_FROM" TIMESTAMP, |
351 |
"U_DATE_LOCK_TO" TIMESTAMP, |
352 |
"P_PASSWD_CIPHERTEXT" VARCHAR2(64 CHAR), |
353 |
"P_PASSWD_STATE" NUMBER(10,0), |
354 |
"P_DATE_GENERATED" TIMESTAMP, |
355 |
"P_DATE_FIRST_USED" TIMESTAMP, |
356 |
"P_DATE_LAST_USED" TIMESTAMP, |
357 |
"P_USE_COUNT" NUMBER(19,0), |
358 |
"P_ERROR_COUNT" NUMBER(10,0), |
359 |
"P_EXPIRED_STATUS" NUMBER(10,0), |
360 |
"P_DATE_EXPIRED" TIMESTAMP, |
361 |
"P_PASSWD_HIST" CLOB,
|
362 |
"U_APPLICATION_ID" NUMBER(10,0) |
363 |
) ; |
364 |
--------------------------------------------------------
|
365 |
-- DDL for Table TB_AM_USERMAS
|
366 |
--------------------------------------------------------
|
367 |
|
368 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" |
369 |
( "M_USER_ALIAS" VARCHAR2(20 CHAR) PRIMARY KEY, |
370 |
"M_USER_ID" NUMBER(10,0) |
371 |
) ; |
372 |
--------------------------------------------------------
|
373 |
-- DDL for Table TB_AM_USERMAS_BACKUP
|
374 |
--------------------------------------------------------
|
375 |
|
376 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" |
377 |
( "M_USER_ALIAS" VARCHAR2(50 CHAR) PRIMARY KEY, |
378 |
"M_USER_ID" NUMBER(10,0) |
379 |
) ; |
380 |
--------------------------------------------------------
|
381 |
-- DDL for Table TB_AM_USER_BACKUP
|
382 |
--------------------------------------------------------
|
383 |
|
384 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" |
385 |
( "OID" NUMBER(10,0) PRIMARY KEY, |
386 |
"U_USER_ID" NUMBER(10,0), |
387 |
"U_USER_ALIAS" VARCHAR2(50 CHAR), |
388 |
"U_USER_TYPE" NUMBER(10,0), |
389 |
"U_USER_DESC" VARCHAR2(40 CHAR), |
390 |
"U_DATE_CREATED" TIMESTAMP, |
391 |
"U_DATE_LAST_USED" TIMESTAMP, |
392 |
"U_USE_COUNT" NUMBER(19,0), |
393 |
"U_DATE_LAST_ACT" TIMESTAMP, |
394 |
"U_DATE_LAST_LOCK" TIMESTAMP, |
395 |
"U_USER_STATE" NUMBER(10,0), |
396 |
"U_DATE_LOCK_FROM" TIMESTAMP, |
397 |
"U_DATE_LOCK_TO" TIMESTAMP, |
398 |
"P_PASSWD_CIPHERTEXT" VARCHAR2(64 CHAR), |
399 |
"P_PASSWD_STATE" NUMBER(10,0), |
400 |
"P_DATE_GENERATED" TIMESTAMP, |
401 |
"P_DATE_FIRST_USED" TIMESTAMP, |
402 |
"P_DATE_LAST_USED" TIMESTAMP, |
403 |
"P_USE_COUNT" NUMBER(19,0), |
404 |
"P_ERROR_COUNT" NUMBER(10,0), |
405 |
"P_EXPIRED_STATUS" NUMBER(10,0), |
406 |
"P_DATE_EXPIRED" TIMESTAMP, |
407 |
"P_PASSWD_HIST" VARCHAR2(256 CHAR), |
408 |
"U_APPLICATION_ID" NUMBER(10,0) |
409 |
) ; |
410 |
--------------------------------------------------------
|
411 |
-- DDL for Table TB_AM_VASCO
|
412 |
--------------------------------------------------------
|
413 |
|
414 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_VASCO" |
415 |
( "V_SERIAL_NO" VARCHAR2(22 CHAR) PRIMARY KEY, |
416 |
"V_USER_ID" NUMBER(10,0), |
417 |
"V_DP_MODEL" VARCHAR2(5 CHAR), |
418 |
"V_DP_AUTH_MODE" VARCHAR2(2 CHAR), |
419 |
"V_DP_CIPHERTEXT" BLOB, |
420 |
"V_BAK_CIPHERTEXT" BLOB, |
421 |
"V_DP_ASSIGNED" NUMBER(10,0), |
422 |
"V_DATE_ASSIGNED" TIMESTAMP, |
423 |
"V_DATE_FIRST_USED" TIMESTAMP, |
424 |
"V_DATE_LAST_USED" TIMESTAMP, |
425 |
"V_USE_COUNT" NUMBER(10,0), |
426 |
"V_ERROR_COUNT" NUMBER(10,0), |
427 |
"V_DP_STATE" NUMBER(10,0), |
428 |
"V_BATCH_NO" VARCHAR2(8 CHAR) |
429 |
) ; |
430 |
|
431 |
--------------------------------------------------------
|
432 |
-- DDL for Table ADMIN_ACTION
|
433 |
--------------------------------------------------------
|
434 |
|
435 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_ACTION" |
436 |
( "ACTION_ID" NUMBER(38,2), |
437 |
"ACTION" VARCHAR2(64 CHAR), |
438 |
"APPROVABLE" NUMBER(10,0), |
439 |
"MK_PENDING" NUMBER(10,0) |
440 |
); |
441 |
|
442 |
--------------------------------------------------------
|
443 |
-- DDL for Table ADMIN_AUDIT_LOG
|
444 |
--------------------------------------------------------
|
445 |
|
446 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" |
447 |
( "LOG_ID" NUMBER(38,2), |
448 |
"AUDIT_CATEGORY_ID" NUMBER(38,2), |
449 |
"LOG_DESCRIPTION" VARCHAR2(256 CHAR), |
450 |
"LOG_CREATION_DATE" TIMESTAMP, |
451 |
"LOG_STATUS" NUMBER(38,2), |
452 |
"LOG_REASON" VARCHAR2(256 CHAR), |
453 |
"LOG_CREATED_BY" VARCHAR2(64 CHAR), |
454 |
"LOG_GROUP_ID" NUMBER(38,2), |
455 |
"LOG_ROLE_ID" NUMBER(38,2), |
456 |
"LOG_BEFORE_STATE" CLOB,
|
457 |
"LOG_AFTER_STATE" CLOB,
|
458 |
"LOG_AUTH_REASON" VARCHAR2(256 CHAR), |
459 |
"LOG_IP_ADDRESS" VARCHAR2(50 CHAR), |
460 |
"LOG_INITIATOR_ID" NUMBER(38,2), |
461 |
"LOG_ACTION_ID" NUMBER(38,2) |
462 |
); |
463 |
|
464 |
--------------------------------------------------------
|
465 |
-- DDL for Table ADMIN_CONFIG
|
466 |
--------------------------------------------------------
|
467 |
|
468 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_CONFIG" |
469 |
( "CONFIG_NAME" CLOB,
|
470 |
"CONFIG_VALUE" CLOB,
|
471 |
"CONFIG_DESCRIPTION" CLOB
|
472 |
); |
473 |
|
474 |
--------------------------------------------------------
|
475 |
-- DDL for Table ADMIN_GROUP
|
476 |
--------------------------------------------------------
|
477 |
|
478 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_GROUP" |
479 |
( "GROUP_ID" NUMBER(38,2), |
480 |
"GROUP_NAME" VARCHAR2(64 CHAR), |
481 |
"GROUP_DESCRIPTION" VARCHAR2(256 CHAR), |
482 |
"GROUP_CREATED_BY" NUMBER(38,2), |
483 |
"GROUP_UPDATED_BY" NUMBER(38,2), |
484 |
"GROUP_CREATION_DATE" TIMESTAMP, |
485 |
"GROUP_UPDATED_DATE" TIMESTAMP, |
486 |
"CATEGORY" NUMBER(38,2), |
487 |
"GROUP_LVL" NUMBER(38,2), |
488 |
"MODE_TYPE" VARCHAR2(1 CHAR), |
489 |
"MK_PENDING" NUMBER(10,0) |
490 |
); |
491 |
|
492 |
--------------------------------------------------------
|
493 |
-- DDL for Table ADMIN_NAVIGATION
|
494 |
--------------------------------------------------------
|
495 |
|
496 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" |
497 |
( "NODE_ID" NUMBER(38,2), |
498 |
"PARENT_ID" NUMBER(38,2), |
499 |
"NODE_NAME" VARCHAR2(64 CHAR), |
500 |
"NODE_DESCRIPTION" VARCHAR2(256 CHAR), |
501 |
"NODE_TYPE" VARCHAR2(1 CHAR), |
502 |
"NODE_STATUS" VARCHAR2(1 CHAR), |
503 |
"NODE_CODE" VARCHAR2(16 CHAR), |
504 |
"NODE_DISPLAY_ORDER" NUMBER(38,2), |
505 |
"PAGE_PATH" VARCHAR2(256 CHAR), |
506 |
"NODE_CREATED_BY" NUMBER(38,2), |
507 |
"NODE_UPDATED_BY" NUMBER(38,2), |
508 |
"NODE_CREATION_DATE" TIMESTAMP, |
509 |
"NODE_UPDATED_DATE" TIMESTAMP, |
510 |
"CATEGORY" NUMBER(38,2), |
511 |
"NODE_SYSTEM" VARCHAR2(64 CHAR), |
512 |
"MK_PENDING" NUMBER(38,2) |
513 |
); |
514 |
|
515 |
--------------------------------------------------------
|
516 |
-- DDL for Table ADMIN_NAVIGATION_ACTION
|
517 |
--------------------------------------------------------
|
518 |
|
519 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" |
520 |
( "NAVIGATION_ID" NUMBER(38,2), |
521 |
"ACTION_ID" NUMBER(38,2) |
522 |
); |
523 |
|
524 |
--------------------------------------------------------
|
525 |
-- DDL for Table ADMIN_NAVIGATION_GROUP
|
526 |
--------------------------------------------------------
|
527 |
|
528 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" |
529 |
( "NAVIGATION_ID" NUMBER(38,2), |
530 |
"GROUP_ID" NUMBER(38,2), |
531 |
"IS_EDIT" NUMBER(38,2), |
532 |
"IS_VIEW" NUMBER(38,2), |
533 |
"NODE_CODE" VARCHAR2(16 CHAR) |
534 |
); |
535 |
|
536 |
--------------------------------------------------------
|
537 |
-- DDL for Table ADMIN_PERMISSION
|
538 |
--------------------------------------------------------
|
539 |
|
540 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" |
541 |
( "USER_ID" NUMBER(38,2), |
542 |
"ACTION_ID" NUMBER(38,2), |
543 |
"IS_APPROVER" NUMBER(10,0) |
544 |
); |
545 |
|
546 |
--------------------------------------------------------
|
547 |
-- DDL for Table ADMIN_ROLE
|
548 |
--------------------------------------------------------
|
549 |
|
550 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_ROLE" |
551 |
( "ROLE_ID" NUMBER(38,2), |
552 |
"ROLE_NAME" VARCHAR2(64 CHAR), |
553 |
"ROLE_DESCRIPTION" VARCHAR2(256 CHAR), |
554 |
"ROLE_CREATED_BY" NUMBER(38,2), |
555 |
"ROLE_UPDATED_BY" NUMBER(38,2), |
556 |
"ROLE_CREATION_DATE" TIMESTAMP, |
557 |
"ROLE_UPDATED_DATE" DATE |
558 |
); |
559 |
|
560 |
--------------------------------------------------------
|
561 |
-- DDL for Table ADMIN_USER_PROFILE
|
562 |
--------------------------------------------------------
|
563 |
|
564 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" |
565 |
( "USER_ID" NUMBER(38,2), |
566 |
"ROLE_ID" NUMBER(38,2), |
567 |
"GROUP_ID" NUMBER(38,2), |
568 |
"USER_NAME" VARCHAR2(64 CHAR), |
569 |
"USER_DOB" VARCHAR2(8 CHAR), |
570 |
"USER_EMAIL" VARCHAR2(64 CHAR), |
571 |
"USER_GENDER" VARCHAR2(1 CHAR), |
572 |
"USER_RACE" VARCHAR2(4 CHAR), |
573 |
"USER_OFFICE_NUMBER" VARCHAR2(30 CHAR), |
574 |
"USER_MOBILE_NUMBER" VARCHAR2(30 CHAR), |
575 |
"CREATED_BY" NUMBER(38,2), |
576 |
"UPDATED_BY" NUMBER(38,2), |
577 |
"UPDATED_DATE" TIMESTAMP, |
578 |
"LAST_LOGIN_DATE" TIMESTAMP, |
579 |
"FORCE_RESET" NUMBER(38,2), |
580 |
"MK_PENDING" NUMBER(38,2), |
581 |
"LAST_IP_ADDRESS" VARCHAR2(50 CHAR), |
582 |
"LAST_HOST_NAME" VARCHAR2(50 CHAR), |
583 |
"USER_ADMIN_ROLE" VARCHAR2(10 CHAR) |
584 |
); |
585 |
|
586 |
--------------------------------------------------------
|
587 |
-- DDL for Table ADMIN_USER_PROFILE_BACKUP
|
588 |
--------------------------------------------------------
|
589 |
|
590 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP" |
591 |
( "OID" NUMBER(10,0), |
592 |
"USER_ID" NUMBER(38,2), |
593 |
"ROLE_ID" NUMBER(38,2), |
594 |
"GROUP_ID" NUMBER(38,2), |
595 |
"USER_NAME" VARCHAR2(200 CHAR), |
596 |
"USER_DOB" VARCHAR2(8 CHAR), |
597 |
"USER_EMAIL" VARCHAR2(64 CHAR), |
598 |
"USER_GENDER" VARCHAR2(1 CHAR), |
599 |
"USER_RACE" VARCHAR2(4 CHAR), |
600 |
"USER_OFFICE_NUMBER" VARCHAR2(20 CHAR), |
601 |
"USER_MOBILE_NUMBER" VARCHAR2(20 CHAR), |
602 |
"CREATED_BY" NUMBER(38,2), |
603 |
"UPDATED_BY" NUMBER(38,2), |
604 |
"UPDATED_DATE" TIMESTAMP, |
605 |
"LAST_LOGIN_DATE" TIMESTAMP, |
606 |
"FORCE_RESET" NUMBER(38,2), |
607 |
"MK_PENDING" NUMBER(38,2) |
608 |
); |
609 |
|
610 |
--------------------------------------------------------
|
611 |
-- DDL for Table ADMIN_USER_SECURITY
|
612 |
--------------------------------------------------------
|
613 |
|
614 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY" |
615 |
( "USER_ID" NUMBER(38,2), |
616 |
"IB_SESSION_ID" VARCHAR2(255 CHAR) |
617 |
) ; |
618 |
|
619 |
--------------------------------------------------------
|
620 |
-- DDL for Table ADMIN_USER_SECURITY_BACKUP
|
621 |
--------------------------------------------------------
|
622 |
|
623 |
CREATE TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY_BACKUP" |
624 |
( "USER_ID" NUMBER(38,2), |
625 |
"IB_SESSION_ID" VARCHAR2(255 CHAR), |
626 |
"OID" NUMBER(10,0) |
627 |
) ; |
628 |
--------------------------------------------------------
|
629 |
-- DDL for Table IB_CONTENT_CATEGORY
|
630 |
--------------------------------------------------------
|
631 |
|
632 |
CREATE TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" |
633 |
( "OID" NUMBER(38,2), |
634 |
"PARENT_ID" NUMBER(38,2), |
635 |
"CREATION_DATE" TIMESTAMP, |
636 |
"LAST_MOD_DATE" TIMESTAMP, |
637 |
"CONTENT_TYPE_ID" NUMBER(38,2), |
638 |
"CATEGORY_TYPE" VARCHAR2(64 CHAR), |
639 |
"MK_PENDING" NUMBER(38,2) |
640 |
); |
641 |
--------------------------------------------------------
|
642 |
-- DDL for Table IB_CONTENT_TYPE
|
643 |
--------------------------------------------------------
|
644 |
|
645 |
CREATE TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" |
646 |
( "OID" NUMBER(38,2), |
647 |
"CONTENT_TYPE_CODE" VARCHAR2(64 CHAR), |
648 |
"CONTENT_PATH" VARCHAR2(256 CHAR), |
649 |
"CONTENT_TABLE_NAME" VARCHAR2(64 CHAR), |
650 |
"CREATION_DATE" DATE |
651 |
); |
652 |
--------------------------------------------------------
|
653 |
-- DDL for Table IB_CUST_PROFILE
|
654 |
--------------------------------------------------------
|
655 |
|
656 |
CREATE TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" |
657 |
( "USER_ID" NUMBER(38,2), |
658 |
"USER_NAME" VARCHAR2(200 CHAR), |
659 |
"USER_DOB_BRD" VARCHAR2(8 CHAR), |
660 |
"USER_EMAIL" VARCHAR2(64 CHAR), |
661 |
"USER_GENDER" VARCHAR2(1 CHAR), |
662 |
"USER_RACE" VARCHAR2(4 CHAR), |
663 |
"USER_HOME_PHONE" VARCHAR2(30 CHAR), |
664 |
"USER_OFFICE_PHONE" VARCHAR2(30 CHAR), |
665 |
"USER_MOBILE_PHONE" VARCHAR2(30 CHAR), |
666 |
"USER_TAC_PHONE" VARCHAR2(30 CHAR), |
667 |
"USER_ADDR1" VARCHAR2(64 CHAR), |
668 |
"USER_ADDR2" VARCHAR2(64 CHAR), |
669 |
"USER_ADDR3" VARCHAR2(64 CHAR), |
670 |
"USER_ADDR4" VARCHAR2(64 CHAR), |
671 |
"USER_ADDR5" VARCHAR2(64 CHAR), |
672 |
"USER_ACCESS_NO" VARCHAR2(19 CHAR), |
673 |
"USER_TYPE" VARCHAR2(3 CHAR), |
674 |
"UPDATED_BY" NUMBER(38,2), |
675 |
"USER_CITY" VARCHAR2(128 CHAR), |
676 |
"USER_STATE" VARCHAR2(128 CHAR), |
677 |
"USER_POSTCODE" VARCHAR2(50 CHAR), |
678 |
"USER_COUNTRY" VARCHAR2(128 CHAR), |
679 |
"USER_AGE_RANGE" NUMBER(38,2), |
680 |
"USER_INCOME_RANGE" VARCHAR2(10 CHAR), |
681 |
"USER_MARITAL_STATUS" NUMBER(38,2), |
682 |
"USER_EMPLOY_STATUS" VARCHAR2(10 CHAR), |
683 |
"USER_EDUCATION_LEVEL" VARCHAR2(10 CHAR), |
684 |
"USER_DISPLAY_NAME" VARCHAR2(64 CHAR), |
685 |
"INSIDER" VARCHAR2(1 CHAR), |
686 |
"INQUIRY_CODE" VARCHAR2(15 CHAR), |
687 |
"MOTHER_MAIDEN_NAME" VARCHAR2(40 CHAR), |
688 |
"NATIONALITY" VARCHAR2(3 CHAR), |
689 |
"BUMI" VARCHAR2(3 CHAR), |
690 |
"RESIDENCE" VARCHAR2(1 CHAR), |
691 |
"RELIGION_CODE" VARCHAR2(1 CHAR), |
692 |
"LANGUAGE" VARCHAR2(3 CHAR), |
693 |
"CUST_STATUS" VARCHAR2(2 CHAR), |
694 |
"DECEASED" VARCHAR2(1 CHAR), |
695 |
"HOLD_MAIL_CODE" VARCHAR2(1 CHAR), |
696 |
"PROMO_MAIL_CODE" VARCHAR2(1 CHAR), |
697 |
"ADDRESS_SEQ" VARCHAR2(5 CHAR), |
698 |
"RETENTION" VARCHAR2(1 CHAR), |
699 |
"CONSITUTION" VARCHAR2(1 CHAR), |
700 |
"PLACE_OF_BIRTH" VARCHAR2(40 CHAR), |
701 |
"CUST_SEGMENT_CODE" VARCHAR2(1 CHAR), |
702 |
"NO_OF_EMP" NUMBER(38,2), |
703 |
"HIGH_RISK" VARCHAR2(1 CHAR), |
704 |
"HIGH_RISK_CODE" VARCHAR2(2 CHAR), |
705 |
"STAFF_FLAG" VARCHAR2(1 CHAR), |
706 |
"STAFF_ID_NO" VARCHAR2(20 CHAR), |
707 |
"DURATION_STAY_PRE_ADD" NUMBER(38,2), |
708 |
"HOUSE_OWNER_CODE" VARCHAR2(1 CHAR), |
709 |
"TYPE_DWELLING" VARCHAR2(2 CHAR), |
710 |
"NO_OF_DEPENDENTS" NUMBER(38,2), |
711 |
"BUSS_PREMISE_CODE" VARCHAR2(1 CHAR), |
712 |
"BUSSINESS_TYPE" VARCHAR2(2 CHAR), |
713 |
"BUSS_OPER_HOURS" VARCHAR2(2 CHAR), |
714 |
"ID_NO" VARCHAR2(40 CHAR), |
715 |
"ID_TYPE" VARCHAR2(3 CHAR), |
716 |
"SALUTATION" VARCHAR2(25 CHAR), |
717 |
"BRANCH_NO" NUMBER(38,2), |
718 |
"OFFICE_CONTACT_NAME" VARCHAR2(40 CHAR), |
719 |
"FAX" VARCHAR2(30 CHAR), |
720 |
"FAX_CONTACT_NAME" VARCHAR2(40 CHAR), |
721 |
"YEAR" NUMBER(38,2), |
722 |
"ANNUAL_TURNOVER" NUMBER(38,2), |
723 |
"SECTOR" VARCHAR2(1 CHAR), |
724 |
"NO_FULLTIME_EMP" NUMBER(38,2), |
725 |
"CLIENT_TYPE" VARCHAR2(3 CHAR), |
726 |
"MOBILE_NO_FLAG" VARCHAR2(255 CHAR), |
727 |
"GROUP_ID" NUMBER(38,2), |
728 |
"ORG_ID" NUMBER(38,2), |
729 |
"ROLE_ID" NUMBER(38,2), |
730 |
"MK_PENDING" NUMBER(38,2), |
731 |
"BEFORE_VALUE" CLOB,
|
732 |
"AFTER_VALUE" CLOB,
|
733 |
"LAST_LOGIN_DATE" TIMESTAMP, |
734 |
"UPDATED_DATE" TIMESTAMP, |
735 |
"MARITAL_DATE" TIMESTAMP, |
736 |
"CUST_STATUS_DATE" TIMESTAMP, |
737 |
"DECEASED_DATE" TIMESTAMP, |
738 |
"START_RELATIONSHIP" TIMESTAMP, |
739 |
"REVIEW_DATE" TIMESTAMP, |
740 |
"CREATION_DATE" DATE |
741 |
) ; |
742 |
--------------------------------------------------------
|
743 |
-- DDL for Table IB_USER
|
744 |
--------------------------------------------------------
|
745 |
|
746 |
CREATE TABLE "M2U_UPASS_CI"."IB_USER" |
747 |
( "USER_ID" NUMBER(38,2), |
748 |
"ACCOUNT_ID" NUMBER(38,2), |
749 |
"USER_ALIAS" VARCHAR2(50 CHAR), |
750 |
"PASSWORD" VARCHAR2(64 CHAR), |
751 |
"USER_STATE" NUMBER(38,2), |
752 |
"MODIF_TIME" TIMESTAMP, |
753 |
"CREATION_DATE" DATE |
754 |
) ; |
755 |
|
756 |
--------------------------------------------------------
|
757 |
-- DDL for Table IB_CONTENT_CATEGORY_ML
|
758 |
--------------------------------------------------------
|
759 |
|
760 |
CREATE TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" |
761 |
( "OID" NUMBER(38,2), |
762 |
"CATEGORY_NAME" VARCHAR2(64 CHAR), |
763 |
"LOCALE" VARCHAR2(2 CHAR), |
764 |
"CONTENT_CATEGORY_ID" NUMBER(38,2) |
765 |
); |
766 |
|
767 |
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); |
768 |
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); |
769 |
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); |
770 |
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); |
771 |
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); |
772 |
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); |
773 |
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); |
774 |
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); |
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(),3,0); |
776 |
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); |
777 |
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); |
778 |
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); |
779 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','14400', EMPTY_CLOB(),1,1); |
780 |
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); |
781 |
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); |
782 |
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); |
783 |
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); |
784 |
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); |
785 |
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); |
786 |
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); |
787 |
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); |
788 |
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); |
789 |
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); |
790 |
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); |
791 |
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); |
792 |
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); |
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(),4,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(),5,0); |
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(),0,0); |
796 |
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); |
797 |
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); |
798 |
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); |
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(),1,1); |
800 |
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); |
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(),0,0); |
802 |
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); |
803 |
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); |
804 |
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); |
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(),1,1); |
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(),2,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(),0,0); |
808 |
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); |
809 |
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); |
810 |
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); |
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(),1,1); |
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(),2,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(),0,0); |
814 |
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); |
815 |
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); |
816 |
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); |
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(),1,1); |
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(),2,0); |
819 |
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); |
820 |
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); |
821 |
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); |
822 |
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); |
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(),1,1); |
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(),2,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(),0,0); |
826 |
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); |
827 |
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); |
828 |
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); |
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(),1,1); |
830 |
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); |
831 |
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); |
832 |
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); |
833 |
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); |
834 |
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); |
835 |
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); |
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(),2,0); |
837 |
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); |
838 |
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); |
839 |
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); |
840 |
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); |
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(),1,1); |
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(),2,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(),0,0); |
844 |
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); |
845 |
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); |
846 |
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); |
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(),1,1); |
848 |
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); |
849 |
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); |
850 |
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); |
851 |
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); |
852 |
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); |
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(),4,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(),5,0); |
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(),0,0); |
856 |
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); |
857 |
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); |
858 |
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); |
859 |
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); |
860 |
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); |
861 |
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); |
862 |
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); |
863 |
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); |
864 |
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); |
865 |
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); |
866 |
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); |
867 |
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); |
868 |
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); |
869 |
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); |
870 |
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); |
871 |
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); |
872 |
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); |
873 |
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); |
874 |
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); |
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(),1,1); |
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(),2,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(),0,0); |
878 |
|
879 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (1); |
880 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (2); |
881 |
|
882 |
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); |
883 |
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); |
884 |
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); |
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 (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); |
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 (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); |
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 (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); |
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 (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); |
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 (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); |
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 (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); |
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 (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); |
892 |
|
893 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('root',1); |
894 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('UpassAdmin',12); |
895 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('administrator',57); |
896 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser1',100); |
897 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser2',101); |
898 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser3',102); |
899 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser4',103); |
900 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser5',104); |
901 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser6',105); |
902 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser7',106); |
903 |
|
904 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1019); |
905 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1020); |
906 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1021); |
907 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1023); |
908 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3021); |
909 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3022); |
910 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3023); |
911 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3024); |
912 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3025); |
913 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3026); |
914 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3027); |
915 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (6,3002); |
916 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3011); |
917 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3012); |
918 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3013); |
919 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (35,3031); |
920 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8001); |
921 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8002); |
922 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8003); |
923 |
|
924 |
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); |
925 |
|
926 |
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); |
927 |
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); |
928 |
|
929 |
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); |
930 |
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); |
931 |
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); |
932 |
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); |
933 |
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); |
934 |
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); |
935 |
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); |
936 |
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); |
937 |
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); |
938 |
|
939 |
|
940 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (1,1,0,0,'SSSSUENQ'); |
941 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (3,1,0,0,'SSSSAENQ'); |
942 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (6,1,0,0,'SSSSNAVI'); |
943 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (7,1,0,0,'SSSSAGRP'); |
944 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (8,1,0,0,'SSSSALOG'); |
945 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (9,1,0,0,'SSSSCPWD'); |
946 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (19,1,0,0,'ADMIN'); |
947 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (35,1,0,0,'SSSSSETT'); |
948 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (36,1,0,0,'SSSSAUM'); |
949 |
|
950 |
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')); |
951 |
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')); |
952 |
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); |
953 |
|
954 |
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')); |
955 |
|
956 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (1, 'M2U Retail Internet Banking'); |
957 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (2, 'Maybank Online Stock'); |
958 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (3, 'Maybank Online Ticketing'); |
959 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (4, 'Maybank CCPP'); |
960 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (5, 'M2U Singapore Integration'); |
961 |
|
962 |
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); |
963 |
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); |
964 |
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); |
965 |
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); |
966 |
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); |
967 |
|
968 |
|
969 |
--------------------------------------------------------
|
970 |
-- Constraints for Table TB_AM_TAC
|
971 |
--------------------------------------------------------
|
972 |
|
973 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_ERROR_COUNT" NOT NULL ENABLE); |
974 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_USE_COUNT" NOT NULL ENABLE); |
975 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_TAC_STATE" NOT NULL ENABLE); |
976 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_USER_ID" NOT NULL ENABLE); |
977 |
--------------------------------------------------------
|
978 |
-- Constraints for Table TB_AM_GEMALTO
|
979 |
--------------------------------------------------------
|
980 |
|
981 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_STATE" NOT NULL ENABLE); |
982 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_ERROR_COUNT" NOT NULL ENABLE); |
983 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_USE_COUNT" NOT NULL ENABLE); |
984 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_ASSIGNED" NOT NULL ENABLE); |
985 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_BAK_CIPHERTEXT" NOT NULL ENABLE); |
986 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_CIPHERTEXT" NOT NULL ENABLE); |
987 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_USER_ID" NOT NULL ENABLE); |
988 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_SERIAL_NO" NOT NULL ENABLE); |
989 |
--------------------------------------------------------
|
990 |
-- Constraints for Table TB_AM_USERMAS
|
991 |
--------------------------------------------------------
|
992 |
|
993 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" MODIFY ("M_USER_ID" NOT NULL ENABLE); |
994 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
995 |
--------------------------------------------------------
|
996 |
-- Constraints for Table TB_AM_USER_BACKUP
|
997 |
--------------------------------------------------------
|
998 |
|
999 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1000 |
--------------------------------------------------------
|
1001 |
-- Constraints for Table TB_AM_APPSERV
|
1002 |
--------------------------------------------------------
|
1003 |
|
1004 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ACCESS2" NOT NULL ENABLE); |
1005 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ACCESS1" NOT NULL ENABLE); |
1006 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ID" NOT NULL ENABLE); |
1007 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_USER_ID" NOT NULL ENABLE); |
1008 |
--------------------------------------------------------
|
1009 |
-- Constraints for Table TB_AM_CONFIG_CHANGE
|
1010 |
--------------------------------------------------------
|
1011 |
|
1012 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" MODIFY ("CONFIG_UPDATE" NOT NULL ENABLE); |
1013 |
--------------------------------------------------------
|
1014 |
-- Constraints for Table TB_AM_TAC_BACKUP
|
1015 |
--------------------------------------------------------
|
1016 |
|
1017 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1018 |
--------------------------------------------------------
|
1019 |
-- Constraints for Table SMS_TABLE
|
1020 |
--------------------------------------------------------
|
1021 |
|
1022 |
ALTER TABLE "M2U_UPASS_CI"."SMS_TABLE" MODIFY ("OID" NOT NULL ENABLE); |
1023 |
--------------------------------------------------------
|
1024 |
-- Constraints for Table TB_AM_VASCO
|
1025 |
--------------------------------------------------------
|
1026 |
|
1027 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_STATE" NOT NULL ENABLE); |
1028 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_ERROR_COUNT" NOT NULL ENABLE); |
1029 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_USE_COUNT" NOT NULL ENABLE); |
1030 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_ASSIGNED" NOT NULL ENABLE); |
1031 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_BAK_CIPHERTEXT" NOT NULL ENABLE); |
1032 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_CIPHERTEXT" NOT NULL ENABLE); |
1033 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_USER_ID" NOT NULL ENABLE); |
1034 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_SERIAL_NO" NOT NULL ENABLE); |
1035 |
--------------------------------------------------------
|
1036 |
-- Constraints for Table TB_AM_CONFIG
|
1037 |
--------------------------------------------------------
|
1038 |
|
1039 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1040 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("APPLICATION_ID" NOT NULL ENABLE); |
1041 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("CONFIG_NAME" NOT NULL ENABLE); |
1042 |
--------------------------------------------------------
|
1043 |
-- Constraints for Table TB_AM_USERMAS_BACKUP
|
1044 |
--------------------------------------------------------
|
1045 |
|
1046 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
1047 |
--------------------------------------------------------
|
1048 |
-- Constraints for Table TB_AM_USER
|
1049 |
--------------------------------------------------------
|
1050 |
|
1051 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_EXPIRED_STATUS" NOT NULL ENABLE); |
1052 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_ERROR_COUNT" NOT NULL ENABLE); |
1053 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_USE_COUNT" NOT NULL ENABLE); |
1054 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_DATE_GENERATED" NOT NULL ENABLE); |
1055 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_PASSWD_STATE" NOT NULL ENABLE); |
1056 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_STATE" NOT NULL ENABLE); |
1057 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USE_COUNT" NOT NULL ENABLE); |
1058 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_DATE_CREATED" NOT NULL ENABLE); |
1059 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_TYPE" NOT NULL ENABLE); |
1060 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_ALIAS" NOT NULL ENABLE); |
1061 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_ID" NOT NULL ENABLE); |
1062 |
|
1063 |
--------------------------------------------------------
|
1064 |
-- Constraints for Table ADMIN_ACTION
|
1065 |
--------------------------------------------------------
|
1066 |
|
1067 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("APPROVABLE" NOT NULL ENABLE); |
1068 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("ACTION" NOT NULL ENABLE); |
1069 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1070 |
--------------------------------------------------------
|
1071 |
-- Constraints for Table ADMIN_AUDIT_LOG
|
1072 |
--------------------------------------------------------
|
1073 |
|
1074 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_CREATION_DATE" NOT NULL ENABLE); |
1075 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_DESCRIPTION" NOT NULL ENABLE); |
1076 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("AUDIT_CATEGORY_ID" NOT NULL ENABLE); |
1077 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_ID" NOT NULL ENABLE); |
1078 |
--------------------------------------------------------
|
1079 |
-- Constraints for Table ADMIN_GROUP
|
1080 |
--------------------------------------------------------
|
1081 |
|
1082 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_LVL" NOT NULL ENABLE); |
1083 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_CREATION_DATE" NOT NULL ENABLE); |
1084 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_NAME" NOT NULL ENABLE); |
1085 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1086 |
--------------------------------------------------------
|
1087 |
-- Constraints for Table ADMIN_NAVIGATION
|
1088 |
--------------------------------------------------------
|
1089 |
|
1090 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_CREATION_DATE" NOT NULL ENABLE); |
1091 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_CODE" NOT NULL ENABLE); |
1092 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_NAME" NOT NULL ENABLE); |
1093 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_ID" NOT NULL ENABLE); |
1094 |
--------------------------------------------------------
|
1095 |
-- Constraints for Table ADMIN_NAVIGATION_ACTION
|
1096 |
--------------------------------------------------------
|
1097 |
|
1098 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1099 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" MODIFY ("NAVIGATION_ID" NOT NULL ENABLE); |
1100 |
--------------------------------------------------------
|
1101 |
-- Constraints for Table ADMIN_NAVIGATION_GROUP
|
1102 |
--------------------------------------------------------
|
1103 |
|
1104 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("IS_VIEW" NOT NULL ENABLE); |
1105 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("IS_EDIT" NOT NULL ENABLE); |
1106 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1107 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("NAVIGATION_ID" NOT NULL ENABLE); |
1108 |
--------------------------------------------------------
|
1109 |
-- Constraints for Table ADMIN_PERMISSION
|
1110 |
--------------------------------------------------------
|
1111 |
|
1112 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("IS_APPROVER" NOT NULL ENABLE); |
1113 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1114 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("USER_ID" NOT NULL ENABLE); |
1115 |
--------------------------------------------------------
|
1116 |
-- Constraints for Table ADMIN_ROLE
|
1117 |
--------------------------------------------------------
|
1118 |
|
1119 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_CREATION_DATE" NOT NULL ENABLE); |
1120 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_NAME" NOT NULL ENABLE); |
1121 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1122 |
--------------------------------------------------------
|
1123 |
-- Constraints for Table ADMIN_USER_PROFILE
|
1124 |
--------------------------------------------------------
|
1125 |
|
1126 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1127 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("FORCE_RESET" NOT NULL ENABLE); |
1128 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_EMAIL" NOT NULL ENABLE); |
1129 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_NAME" NOT NULL ENABLE); |
1130 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1131 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1132 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_ID" NOT NULL ENABLE); |
1133 |
--------------------------------------------------------
|
1134 |
-- Constraints for Table ADMIN_USER_PROFILE_BACKUP
|
1135 |
--------------------------------------------------------
|
1136 |
|
1137 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1138 |
--------------------------------------------------------
|
1139 |
-- Constraints for Table ADMIN_USER_SECURITY
|
1140 |
--------------------------------------------------------
|
1141 |
|
1142 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY" MODIFY ("USER_ID" NOT NULL ENABLE); |
1143 |
--------------------------------------------------------
|
1144 |
-- Constraints for Table ADMIN_USER_SECURITY_BACKUP
|
1145 |
--------------------------------------------------------
|
1146 |
|
1147 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY_BACKUP" MODIFY ("USER_ID" NOT NULL ENABLE); |
1148 |
--------------------------------------------------------
|
1149 |
-- Constraints for Table IB_CONTENT_CATEGORY
|
1150 |
--------------------------------------------------------
|
1151 |
|
1152 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1153 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("CONTENT_TYPE_ID" NOT NULL ENABLE); |
1154 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1155 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("OID" NOT NULL ENABLE); |
1156 |
--------------------------------------------------------
|
1157 |
-- Constraints for Table IB_CONTENT_TYPE
|
1158 |
--------------------------------------------------------
|
1159 |
|
1160 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1161 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("CONTENT_TYPE_CODE" NOT NULL ENABLE); |
1162 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("OID" NOT NULL ENABLE); |
1163 |
--------------------------------------------------------
|
1164 |
-- Constraints for Table IB_CUST_PROFILE
|
1165 |
--------------------------------------------------------
|
1166 |
|
1167 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1168 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1169 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1170 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_FULLTIME_EMP" NOT NULL ENABLE); |
1171 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("ANNUAL_TURNOVER" NOT NULL ENABLE); |
1172 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("YEAR" NOT NULL ENABLE); |
1173 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("BRANCH_NO" NOT NULL ENABLE); |
1174 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_OF_DEPENDENTS" NOT NULL ENABLE); |
1175 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("DURATION_STAY_PRE_ADD" NOT NULL ENABLE); |
1176 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_OF_EMP" NOT NULL ENABLE); |
1177 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("USER_ID" NOT NULL ENABLE); |
1178 |
--------------------------------------------------------
|
1179 |
-- Constraints for Table IB_USER
|
1180 |
--------------------------------------------------------
|
1181 |
|
1182 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1183 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("ACCOUNT_ID" NOT NULL ENABLE); |
1184 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1185 |
|
1186 |
--------------------------------------------------------
|
1187 |
-- Constraints for Table IB_CONTENT_CATEGORY_ML
|
1188 |
--------------------------------------------------------
|
1189 |
|
1190 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("CONTENT_CATEGORY_ID" NOT NULL ENABLE); |
1191 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("LOCALE" NOT NULL ENABLE); |
1192 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("OID" NOT NULL ENABLE); |
1193 |
|
1194 |
|
1195 |
ALTER TABLE "M2U_UPASS_CI"."M2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1196 |
ALTER TABLE "M2U_UPASS_CI"."TICKETING_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1197 |
ALTER TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1198 |
ALTER TABLE "M2U_UPASS_CI"."STOCK_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1199 |
ALTER TABLE "M2U_UPASS_CI"."IM2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE) |
1200 |
|